Please include formulas

A B C 1 2 3 4 5 6 7 1 ASSUMPTIONS Product: Sports drink Selling price per unit Total Variable costs of Goods Sold Total Fixed Costs of Goods Sold Total Variable Selling and Administration Expenses Total Fixed Selling and Administration Expenses Colorado $70 $700,000 $1,200,000 $200,000 $400,000 Arizona $70 $1,900,000 $0 $100,000 $500,000 8 Quarterly volume of units sold in the fourth quarter 2011 200,000 100,000 2 Projected Contribution Margin based Income Statement For Fourth quarter 2041 Colorado $ Arizona $ Ans Sales Total Variable costs Contribution margin Total Fixed costs Net Income 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 29 3 Variable Cost per unit Contribution Margin per unit Break Even units Break Even sales (Calculate as: Breakeven sales x Selling price per box) Margin of Safety percentage Operating Leverage 4 Sensitivity Analyis Conservative scenario: Sales decrease by 40% than the projected sales Net Income under conservative scenario: -30% -30% 30% 30% Optimistic scenario: Sales increase by 40% than the projected sales Net Income under optimistic scenario: 5. Explanation