Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me on 5-10, not 1-4. I did steps 1-4. .please help out from 5-10. MBA 6315 4 Problem D (38 points): 5 Weather-Teht

image text in transcribedplease help me on 5-10, not 1-4.image text in transcribedI did steps 1-4. .please help out from 5-10.

MBA 6315 4 Problem D (38 points): 5 Weather-Teht sells windows and doors. The following data applies to the company's current operating activities: Solution: Please place your answer and supporting calculations in the space below and either highlight your final answer or surround it with a border so that it can be easily identified by the grader. Total 100.000% 1 Total Units (products combined) to Break Even: Current sales mix in units percentage Selling Price per Unit Variable Cost per Unit Current Unit Volume Fixed Costs Windows 65.00% $225 $105 28,600 $470,250 Doors 35.00% $610 $425 15,400 $384,750 44,000 $855,000 2 Units of Each Product to Break Even: 14 Use the space provided below for organized calculations (including things like Current Unit Volume, Wtd CM, Wtd Average CM 15 Sales Mix, etc. See the narrated lectures for guidance. The detailed questions you are required to answer start on line 40 of this 16 worksheet and are also listed briefly in the SOLUTION space provided starting In Column J of this worksheet: 3 Total Sales Dollars (products combined) to Break Even: NNNNNNNNN 4 Sales Dollars by Product to Break Even: 5 Current Contribution Mangin Income Statement at Break Even: 6 Contribution Marin Income Statement et Current Sales: 40 Required: 1 What is the current break-even point in units for both products combined? (2 points) 42 2 What is the number of units of each product that need to be sold at the current break-even point? (2 points) 43 3 What is the current break even paint in sales dollars for both products combined? (2 points) 4 4 How much, in sales dollars, of each product does the company currently need to sell at the break-even point? (2 points) 45 5 Show the Current Contribution Mangin Income Statement at Break-even. (6 points) 6 6 Show the Contribution Margin Income Statement at the Current Sales Level. (7 points) 47 7 What is the Margin of Safety at the Current Sales Level? (3 points) 49 The Company is working on budgets for next year and plans a 10% increase in Target Pretax Income; a 10% increase in both Selling 50 Price and Variable Cost, and a 15% Increase in Fixed Costs, keeping the Current Sales Mix In Dollars constant. 7 Margin of Safety at Current Sales Level: 5 Current Contribution Margin Income Statement at Break Even: 6 Contribution Margin Income Statement at Current Sales: 38 39 40 Required: 41 1 What is the current break even point in units for bath praducts combined? (2 points) 42 2 what is the number of units of each product that need to be sold at the current break-even point? (2 points) 43 3 What is the current bresak tren point in sales dollars for bath products combined? [2 points) 44 4 How much, in sales dollars, of each product does the company currently need to sell at the break-even point? (2 points) 45 5 Show the Current Contribution Margin Income Statement at Break-Even. [6 points) 46 6 Show the Contribution Margin income Statement at the Current Sales Level (7 paints) 47 7 What is the Margin of safety at the Current Sales Level? (3 points) 49 The Company is working on budgets for next year and plans a 10% increase in Target Pretax Income; a 10% Increase in both selline So Price and Variable Cost; and a 15% increase in Fixed Costs, keeping the Current Sales Mix in Dollars constant. 7 Margin of Safety at Current Sales Level: 52 53 54 SS 8 Show the Contribution Margin Income Statement at the Target Pretax Income Level. HINT--you need to start at the bottom of the Contribution Margin Income Statement and work your way up to the top to figure this out. (8 points) 9 What is the Sales Unit Volume of each product needed to achieve the Target Level of Pretax income? (3 points) 10 What is the Margin of Safety at the Target Sales Level? (3 points) 8 Contribution Marein Income Statement at the Target Level of Pretax Income: Check Figures: Item 4: Doors = $1,278,757; Check Figure for Windows is not provided. Item 6: Total Contribution Margin - $6,281,000; Item 8: Windows Pre-Tax Target Income = $3,257,925; Check Figure for Doors is not provided. 9 Units of cach Product to reach Target Pretat Income: 10 Margin of Safety at Target Sales Level: MBA 6315 4 Problem D (38 points): 5 Weather-Teht sells windows and doors. The following data applies to the company's current operating activities: Solution: Please place your answer and supporting calculations in the space below and either highlight your final answer or surround it with a border so that it can be easily identified by the grader. Total 100.000% 1 Total Units (products combined) to Break Even: Current sales mix in units percentage Selling Price per Unit Variable Cost per Unit Current Unit Volume Fixed Costs Windows 65.00% $225 $105 28,600 $470,250 Doors 35.00% $610 $425 15,400 $384,750 44,000 $855,000 2 Units of Each Product to Break Even: 14 Use the space provided below for organized calculations (including things like Current Unit Volume, Wtd CM, Wtd Average CM 15 Sales Mix, etc. See the narrated lectures for guidance. The detailed questions you are required to answer start on line 40 of this 16 worksheet and are also listed briefly in the SOLUTION space provided starting In Column J of this worksheet: 3 Total Sales Dollars (products combined) to Break Even: NNNNNNNNN 4 Sales Dollars by Product to Break Even: 5 Current Contribution Mangin Income Statement at Break Even: 6 Contribution Marin Income Statement et Current Sales: 40 Required: 1 What is the current break-even point in units for both products combined? (2 points) 42 2 What is the number of units of each product that need to be sold at the current break-even point? (2 points) 43 3 What is the current break even paint in sales dollars for both products combined? (2 points) 4 4 How much, in sales dollars, of each product does the company currently need to sell at the break-even point? (2 points) 45 5 Show the Current Contribution Mangin Income Statement at Break-even. (6 points) 6 6 Show the Contribution Margin Income Statement at the Current Sales Level. (7 points) 47 7 What is the Margin of Safety at the Current Sales Level? (3 points) 49 The Company is working on budgets for next year and plans a 10% increase in Target Pretax Income; a 10% increase in both Selling 50 Price and Variable Cost, and a 15% Increase in Fixed Costs, keeping the Current Sales Mix In Dollars constant. 7 Margin of Safety at Current Sales Level: 5 Current Contribution Margin Income Statement at Break Even: 6 Contribution Margin Income Statement at Current Sales: 38 39 40 Required: 41 1 What is the current break even point in units for bath praducts combined? (2 points) 42 2 what is the number of units of each product that need to be sold at the current break-even point? (2 points) 43 3 What is the current bresak tren point in sales dollars for bath products combined? [2 points) 44 4 How much, in sales dollars, of each product does the company currently need to sell at the break-even point? (2 points) 45 5 Show the Current Contribution Margin Income Statement at Break-Even. [6 points) 46 6 Show the Contribution Margin income Statement at the Current Sales Level (7 paints) 47 7 What is the Margin of safety at the Current Sales Level? (3 points) 49 The Company is working on budgets for next year and plans a 10% increase in Target Pretax Income; a 10% Increase in both selline So Price and Variable Cost; and a 15% increase in Fixed Costs, keeping the Current Sales Mix in Dollars constant. 7 Margin of Safety at Current Sales Level: 52 53 54 SS 8 Show the Contribution Margin Income Statement at the Target Pretax Income Level. HINT--you need to start at the bottom of the Contribution Margin Income Statement and work your way up to the top to figure this out. (8 points) 9 What is the Sales Unit Volume of each product needed to achieve the Target Level of Pretax income? (3 points) 10 What is the Margin of Safety at the Target Sales Level? (3 points) 8 Contribution Marein Income Statement at the Target Level of Pretax Income: Check Figures: Item 4: Doors = $1,278,757; Check Figure for Windows is not provided. Item 6: Total Contribution Margin - $6,281,000; Item 8: Windows Pre-Tax Target Income = $3,257,925; Check Figure for Doors is not provided. 9 Units of cach Product to reach Target Pretat Income: 10 Margin of Safety at Target Sales Level

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Auditing Real Issues And Cases

Authors: Michael C. Knapp, Loreen Knapp

5th Edition

032418834X, 978-0324188349

More Books

Students also viewed these Accounting questions

Question

=+b. Would you need to edit down the copy for a smaller-space ad?

Answered: 1 week ago

Question

=+4. About the medium.

Answered: 1 week ago