D E F G H M N O P Q A 3 4. Problem D (38 points): 5 Weather-Tight 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.00% 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 9 10 11 12 Windows 65.00% 220 $ 105 29,250 $ 470,250 Doors 35.00% 605 425 15,750 384,750 45,000 855,000 $ $ 13 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 15 Average CM, Sales Mix, etc. See the narrated lectures for guidance. The detailed questions you are required to answer 16 start on line 40 of this worksheet and are also listed briefly in the SOLUTION space provided starting in Column J of this 17 18 19 3 Total Sales Dollars (products combined) to Break Even: 4 Sales Dollars by Product to Break Even: D E F G H O P Q - M N 5 Current Contribution Margin Income Statement at Break Even: 6 Contribution Margin Income Statement at Current Sales: 36 37 38 39 40 Required: 41 1 What is the current break-even point in units for both products combined? (2 points) 2 What is the number of units of each product that need to be sold at the current break-even point? (2 points) 3 What is the current break-even point in sales dollars for both 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) 5 Show the Current Contribution Margin Income Statement at Break-Even. (6 points) 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) 45 46 48 49 The Company is working on budgets for next year and plans a 10% increase in Target Pretax Income; a 10% increase in 50 both Selling Price and Variable Cost; and a 15% increase in Fixed Costs, keeping the Current Sales Mix in Dollars 7 Margin of Safety at Current Sales Level: 51 52 8 Show the Contribution Margin Income Statement at the Target Pretax Income Level. HINT--you need to start at the 53 bottom of the Contribution Margin Income Statement and work your way up to the top to figure this out. (8 9 What is the Sales Unit Volume of each product needed to achieve the Target Level of Pretax Income? (3 points) 55 10 What is the Margin of Safety at the Target Sales Level? (3 points) 56 57 Check Figures: Item 4: Doors = $1,314,310; Check Figure for Windows is not provided. 58 Item 6. Total contribution Margin = $6 198 750. 8 Contribution Margin Income Statement at the Target Level of Pretax Income: A D E F G H I I L M N O P Q _ 47 7 What is the Margin of Safety at the Current Sales Level? (3 points) 48 | 7 Margin of Safety at Current Sales Level: 49 The Company is working on budgets for next year and plans a 10% increase in Target Pretax Income; a 10% increase in 50 both Selling Price and Variable Cost; and a 15% increase in Fixed Costs, keeping the Current Sales Mix in Dollars 51 52 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 9 What is the Sales Unit Volume of each product needed to achieve the Target Level of Pretax Income? (3 points) 55 10 What is the Margin of Safety at the Target Sales Level? (3 points) 56 57 Check Figures: Item 4: Doors = $1,314,310; Check Figure for Windows is not provided. Item 6: Total Contribution Margin = $6,198,750; Item 8: Windows Pre-Tax Target Income = $3,182,850; Check Figure for Doors is not provided. 8 Contribution Margin Income Statement at the Target Level of Pretax Income: 9 Units of each Product to reach Target Pretax Income: 10 Margin of Safety at Target Sales Level: 73. Problem A. Problem B. Problem C. Problem D
