Excell formulas please

K32 xfx A B 1 2 Problem 1: CM Income Statement, Breakeven, Required sales units and what-if Scenario Zeta Inc produces glass windows, which it sells for $100 per unit. The company's forecast income statement for March 2017 for producing and selling 7,000 windows is as follows: 8 5 Zeta Inc. Income Statement for March 20YY $ 6 Sales revenue 7000 Windows @ $100 per unit) 1700,000 7 Variable cost of goods sold (7,000 windows @ $43 per unit, 301000 Fixed cost of goods sold 99,000 9 Gross profit 300,000 10 Shipping and handling expense (7,000 windows @ $2 per 14,000 11. Administrative salaries 24,000 12 Variable selling expenses (1,000 windows @ $5 per unit) 35,000 13 Fixed advertising expenses 10,000 14 Other administrative fixed costs including office depreciatia 12.000 15 Net income 205,000 16 17 Required: Siddique, Solise: 18 A. Prepare a contribution margin format income statement for M Hint Clarrify cart w variable and fixed 19 20 Zeta Inc. 21 Contribution margin-based income statement for March 2014 22 $ 23 24 25 26 27 28 29 30 31 32 33 84 35 36 37 38 B. Calculate the company's Unit Contribution Margin (CMU). 39 Unit Contribution Marcin (CMU: per unit $ 40 41 C. Calculate the company's Breakeven units and Breakeven Dollars. 42 Breakeven units. 43 Breakeven Dollars units 44 45 D. Calculate the required sales unit for March 2017 to earn a net income of $300,000? 46 Required sales unit: units 47 48 E. Using your answer from part A), calculate Zeta's operating leverage. 49 Operating Leverage: 50 51. F. If the sales revenue in March decreases by 1574. 52 What would be the percentage decrease in Net Income? 53 ) What would be the net income following the decrease in sales revenue? 54 55 56 57 58 59 60 61 CVP 1 Ready Accessibility: Investigate 55F