what formulas do I put in for these answers on excel?

Undo Clipboard Font AI 023 -Xv fx =B6 1 A B Problem 1: CM Income Statement, Breakeven, Required sales units and What-if Scenario Malcom Ino produces glass doors, which it sells for $80 per unit. The company's forecast income statement for October 2017 for producing and selling 5,000 doors is as follows: go to to w to 9 Malcom Inc. Income Statement for October 2017 6 Sales revenue (5.000 doors @ $80 per unit) 2 Variable cost of goods sold (5.000 doors @ $30 per unit) 8 Fixed cost of goods sold Gross profit 10 Administrative salaries 1 Shipping and handling expense (5,000 doors @ $1 per unit) 12 Variable selling expenses 5,000 doors @ $8 per unit) 13 Fixed advertising expenses Other administrative fixed costs Net income $ 400,000 150,000 98,000 152,000 20.000 5,000 15.000 12,000 8.000 92,000 1 15 18 10 Required: A. Prepare a contribution margin format income statement for October 20YY. 18 19 20 Malcom Inc. Contribution margin-based income statement for October 20YY $ $ 400.000 150,000 5.000 15.000 170 000 98.000 23 Sales revenue 5.000 doors @ $80 per unit) 24 25 Variable cost of goods sold/5.000 doors @ $50 per unit) 26 Shipping and handling expense (5.000 doors @ $1 per unit 21 Variable selling expenses (5,000 doors @ $3 per unit) 28 Contribution Margin 23 Less: Fixed Cost 30 Fixed Dost of Goods Sold 31 Administative Salaries 20,000 32 Fixed Advertising Expenss 12.000 33 Other Administrative fixed cost 8.000 34 Net Income 35 36 37 38 B. Calculate the company's Unit Contribution Margin (CMU). 39 CMUESPU-VCHI 138 000 $46 per unit 41 C. Calculate the company's Break-even units and Break-even Dollars. 42 BEU = FCICMU 43 BE$ = BEU, SPIU 3.000.00 units $240.000 44 45 D. Calculate the required sales unit for October 20YY to earn a net income of $184,000? 46 Pequired sales unit (Fo+Target profit/OMU 7.000.00 units 47 46 E. Using your answer from part a), calculate Malcom's operating leverage. 45 OLE CMIM 50 51 F. Determine the followings if Malcom's sales revenue increases by 10% 52 during October 20YY: 53 D. Increase in Ner Income: 125.000 54 Dollar amount by which Net Income would inorease $26.000.00 55 56 57 -58 59 60 61 Problem1 +