Required:
1. Prepare a contribution format income statement for the month based on actual sales data. (Round your percentage answers to the nearest whole number.)
Problem 4-20 Sales Mix; Multi-Product Break-Even Analysis (L09] Smithen Company, a wholesale distributor, has been operating for only a few months. The company sells three productssinks, mirrors, and vanities. Budgeted sales by product and in total for the coming month are shown below based on planned unit sales as follows: Sinks Mirrors Vanities Units 600 300 300 Percentage 508 258 25% Total 1,200 100% Product Percentage of total sales Sales Variable expenses Sinks 51% $412, 698.00 123, 809.40 Mirrors 30$ $244,200 100% 195,360 80% Vanities 198 $157,102.00 94, 261.20 Total 1008 $814,000.00 413,430.60 100% 30% 100% 60% 100% 51% Contribution margin $288,888.60 7 04 $ 48,840 20% $ 62,840.80 40% 400,569.40 498 Contribution margin per unit $ 481.48 $ 162.80 $ 209.47 Fixed expenses 362,600.00 Operating income $ 37,969.40 Fixed expenses $362,600 Break-even point in sales dollars - = $740,000 Overall CM ratio 0.49 Break-even point in unit sales: Total Fixed expenses $362,600 - = 1,086.25 units Weighted average CM per unit $333.81* *($481.48 x 0.50) + ($162.80 x 0.25) + ($209.47 x 0.25) Assume that actual sales for the month total $976,163 (1,400 units), with the CM ratio and per unit amounts the same as budgeted. Actual fixed expenses are the same as budgeted, $362,600. Actual sales by product are as follows: sinks, $337,037 (490 units); mirrors, $455,840 (560 units); and vanities, $183,286 (350 units). SMITHEN COMPANY Contribution Margin Income Statement Product Mirrors Vanities Sinks Total Percentage of total Sales Variable expenses Contribution margin Fixed expenses Operating income (loss) S 0 0% $ 0 0% $ 0 0% $ 2. Compute the break-even point in sales dollars for the month, based on the actual data. (Round your intermediate calculations to the nearest whole percent. Round your final answer to the nearest whole dollar.) Break-even point in sales dollars 3. Calculate the break-even point in unit sales for the month, based on the actual data. (Round your final answer to the nearest whole number.) Break-even point in unit sales
