solution

Problem 4-20 Sales Mix; Multi-Product Break-Even Analysis [LO9] Smithen Company, a wholesale distributor, has been operating for only a few months. The company sets three products-sinks, mirrors, and vanities. Budgeted sales by product and in total for the coming month are shown below based on planned unit sales as follows: Units Percentage 1,000 50% Sinks Mirrors Vanities 500 25% 500 25% Total 2,000 100% Sinks Product Mirrors 20% 48% Percentage of total sales Sales Variable expenses $264,000 100.00% $110,000 30,30% B0,000 72,000 Vanities Total 32% 100% 100.00% $176,000 100.00% $550,000 100.00% 65,45% 82,000 46.59% 219,300 19.87% 34.55% $94,000 53.41% 330,700 60.13% $168.00 Contribution margin $184,000 69.70% $ 38,000 $76.00 Contribution margin per unit $184.00 293,300 Fixed expenses $37,400 Operating income $293,300 0.60 Break-even point in sales dollars Break-even point in unit sales: Fixed expenses Overall CM ratio $487,798.61 10 DAYDOR Hi Pont References Operating income Overall U Patie Break-even point in sales dollars -$417,79841 Break even point in unit sales Total Fixed p weighted average In par wit -1,356-3) wits 3291,390 $158.00 (576.00 0.25) ($106.00 *($184.000.0) 0.25) As shown by these data, operating income is budgeted at $37,400 for the month, break-even sales dollars at $48/798.61, and bea even unit sales at 1856.33. Assume that actual sales for the month total $554,400 (2300 units), with the CM ratio and per unit amounts the same as budgeted Actual fixed expenses are the same as budgeted, $203.300, Actual sales by product are as follows: sanks $138.600 525 mirrors, $231,000 (1.050 units), and vanities, $184,800 (525 units) Required: 1. Prepare a contribution format income statement for the month based on actual sales data (Round your answers to 2 decimal places.) SMITHEN COMPANY Contribution Margin Income Statement Product Mimars Sinks 4 of 5 4 HD Apped Bonk t Required: 1. Prepare a contribution format income statement for the month based on actual sales data (Round your answers to 2 decimal places) SMITHEN COMPANY Contribution Margin income Statement Product Sinks Minors Vanities Total Percentage of total sales S 1% N VIZS 183 $ 0:00] 0.00 $ 0.00 0.00 000 000 14 Operating income (loss) 2. Compute the break-even point in sales dollars for the month, based on the actual data (Round your percentage answers to nearest whole percent. Round other intermediate values and final answer to the nearest whole dollar) Break even point in sales dollars Sam IN N 1100 1000 ROON 10 points Skopped eBook Phot References 2. Compute the break-even point in sales dollars for the month, based on the actual data. (Round your percentage answers to nearest whole percent. Round other intermediate values and final answer to the nearest whole dollar) Break-even point in adoles 3. Calculate the break-even point in unit sales for the month, based on the actual data. (Do not round your intermediate calculations. Round your final answer to the nearest whole number.) Break-even point in und sales 4. This part of the question is not part of your Connect assignment