Question

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 sells 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: points Skipped Sinks Mirrors Vanities Units 800 400 400 Percentage 50% 25% 25% Total 1,600 100% eBook Ask Percentage of total sales Sales Variable expenses Sinks 45% $301, 032.00 60,206.40 Product - Mirrors 25% . $166,500 133,200 Vanities 30% $198,468.00 Total 100% $666,000.00 292,640.40 Print 100% 20% 100% 80% 100% 50% 100% 44% 99,234.00 Contribution margin $240,825.60 80% $ 33,300 20% $ 99,234.00 50% 373, 359.60 56% Contribution margin per unit 301.03 $ 83.25 248.09 338,800.00 CS Fixed expenses Scaoperaen income th CamScanner $ 34,559.60

Answer 1

Con = FCDDF000 (Autosaved) (Autosaved) (Autosaved) - Microsoft Excel - 0 X View Home Insert Page Layout Formulas Data Review * Cut Comic Sans MS - 11 - AA = = = La Copy Paste Format Painter BI U A E Clipboard Font = Wrap Text Merge & Center General % - 8:09 3 D Insert Delete Format Autosum " AT A E 2D Conditional Format Cell Formatting as Table Styles Styles , Clear Sort & Find & Filter Select Editing Alignment Number Cells A28 A G H I J L M N O P Q 1 Requirement 1 Smithen Company Contribution Margin income statement Product Sinks Mirrors 31.00% % 40.00% % 2,37,063.00 100% $ 2.99,700.00 47,412.60 20% $ 2,39,760.00 1,89,650.40 80% $ 59.940.00 6 Percentage of total 7 Sales 8 Variable costs contribution Margin 10 Fixed cost Operating Income (loss) Vanities 29.00% % 100% $ 2,23,277.00 80% $ 111,638.50 20% $ 111638.50 Total 100 % 100% $ 7,60,040.00 50% $ 3.98,811.10 50% $ 3,61.228.90 $ 3,38,800.00 $ 22,428.90 100% 52% 48% 14 Requirement 2 15 Break even in dollars : 16 Fixed cost / Cm ratio 17 338800/48% 7,05,833 18 19 Requirement 3 20 Break even in units : Fixed cost / weightd cm per unit 1713 Units sinks 24 Weight cm per unit 25 Contribution margin per unit 26 Sales mix 27 N Sheet251 Sheet252 Ready mirrors vanities 301.03 $ 83.25 $ 248.09 31% 39% 29% 197.732349206349 Sheet254 Sheet255 Sheet257 Sheet258 $ Sheet253 I Sheet260 Sheet261 Februar Average: 105381,4186 Count: 71 Sum: 4109875.324 0 80% 0+ 12:28 Type here to search o e @ 9 A O * ENG 01-03-2020