Excell Assignments PR 19-6B
Question 5
PR 19-68 (1) L e Sween Home 1 Insert 8 Page Layout Search View Draw Data Review Help x Arial Formulas 10- A D B I VA 2 $ % Clipboard Font Number Alianment A B C D E F G H I J K L Units 12,000 Margin of safety Sale Price Expected sales $240 Break-even point $240 Margin of safety (in dollars) Expected sales Margin of safety (as a percentage of sales) 8,000 $ 2,880,000 1.920,000 $ 960,000 2,880,000 Operating leverage: Unit CMS $144 12.000 GOOD Contribution margin Income from operations Operating leverage $ 1.728.000 576.000 30 Pr. 19(5)-63 Type here to search 8 5 Page Layout PR 19-6B (1) Formulas Data L e Review Search View ile Home insert Draw Help e X 10 - I u - A A 3 - $ % 9 Paste pboard - Font I A B C D E G H Key Code Keycode here 3 Instructions Answers are entered in the cells with gray backgrounds 10 Cells with non-gray backgrounds are protected and cannot be edited 11 An asterisk will appear to the noht of an incomect entry Belmain Co. Estimated Income Statement For the Year Ended December 31, 2017 $ 2,880,000 600,000 360,000 422 000 Sales Cost of goods sold Direct materials Direct labor Factory overhead Cost of goods sold Gross pro Expenses Selling expenses Sales salaries and commissions Advertising Pr. 1945) 68 000 $ 1498 000 Type here to search File Home insert Draw Page Layout Formulas Data Review View X - BA A Format as 2 Cell Styles Font Total selling expenses Adn expenses Office and aces Supplies Total expenses Income from operations 922 000 575.000 $ Contribution margin ratio 12.000 Vanable costs Corbution 1152 000 Pr. 1905) 68 Type here to search AutoSave OD File Home 8. - Page Layout PR 19-68 (1) Formulas Data Search View Insert Draw Review Help 25 Lb 3 @ Paste BIU A A EA $ - % 900 Clipboard Alignment Number N99 : x for D A B C E F G H 1 K L M Break-even sales: Fixed costs $ 1,152,000 - Sale Price $240 Unit Variable Cost $96 $144 8.000 Unit contribution margin Break-even sales (units) Sale price Break-even sales (dollars) $240 1.920,000 $ 4. For each unit level of sales, enter the total sales dollars and total costs. The chart at right will be plotted as you enter the After all points are plotted, grab and move the labels provided at the left to identify each area. Units Sales $ $ Cost-VC 2.000 4 000 6.000 8000 10 000 Pr. 1905) 6B 480.000 960 000 1.440.000 1920,000 2 400.000 Costs $ 1.152.000 1.344000 1.536000 1.728.000 1.920,000 2 112.000 Type here to search AutoSave Home File Home 8 - PR 19-68 (1) - Insert Draw Page Layout Formulas Data 10 BILA A Search View Review Help Arial - $ % Clipboard Font Alignment Number N99 A B C D E F G H I J K L 61 4. For each unit level of sales, enter the total sales dollars and total costs. The chart at right will be plotted as you ente 62 After all points are plotted, grab and move the labels provided at the left to identify each area. Units Sales $ $ Cost 2,000 4,000 6.000 8,000 10.000 12 000 14.000 16.000 18 000 480.000 960,000 1.440.000 1.920,000 2,400,000 2,880,000 3,360,000 3,840,000 4.320.000 Costs $ 1.152,000 1,344,000 1,536.000 1,728.000 1.920,000 2. 112.000 2,304,000 2,496.000 2.688000 2.880.000 Operating Loss Area Break-Even Point Pr. 19(5)-68 Type here to search
