Please include formulas - Thank you!

Problem 2 Denver Doors produces wooden doors, which it sells for $50 per unit. The company's forecast income statement for October 20YY is as follows: $ Denver Doors: income statement for October 20YY Sales revenue (2,000 doors @ $50 per unit) Variable cost of goods sold 2.000 doors @ $15 per unit) Fixed cost of goods sold Gross profit Administrative salaries Shipping and handling expense (2,000 doors $1 per unit) Variable selling expenses (2,000 doors $4 per unit) Fixed advertising expenses Depreciation of administrative office furniture Net Income 100.000 30,000 10,000 60,000 15,000 2,000 8,000 20,000 5.000 10,000 Required: A. Prepare a contribution margin format income statement for October 20YY. $ Denver Doors: Contribution margin-based Income statement for Oct 20YY $ Sales revenue (2,000 doors $50 per unit) Less variable costs Variable cost of goods sold (2,000 doors @ $15 per unit) Shipping and handling expense (2.000 doors @ $1 per unit) Variable selling expenses (2.000 doors @ $4 per unit) Total Variable costs Contribution margin Less fixed costs Fixed cost of goods sold Administrative salaries Fixed advertising expenses Depreciation of administrative office furniture Total Fixed costs Net Income B. Calculate the company's Unit Contribution Margin. CMU = SP/U - VC/U per unit C. Calculate the company's Break-even units and Break-even Dollars. (Round up your answer) BEU = FC/CMU units BE$ =BEU X SPU D. Calculate the required sales unit for October 20YY to earn a net income of $25,000? Required sales unit = (FC + Target profitCMU units E. Using your answer from part a), calculate Denver's operating leverage. OL = CMNI F. Determine the amount of net income that Denver would earn during October 2049 If sales revenue increases by 20%. % Increase in NI = OL X % increase in sales therefore, increased NI = Current Nlx (1 + % increase in NI)