I need help on the formulas that say check formula along with the explanation

B D E 1 2 3 4 1 ASSUMPTIONS Product: Strike and Run: Revenue 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 Sidd Upde inkin Data Desc 5 6 Denver $35 $60,000 $70,000 $40,000 $30,000 El Paso $35 $130,000 $0 $50,000 $50,000 7 8 9 Quarterly volume of units sold in the fourth quarter 2011 20,000 20,000 10 11 12 13 14 15 16 17 18 19 20 21 Sales Total Variable costs Contribution margin Total Fixed costs Net income Projected Contribution Margin based Income Statement For Fourth quarter 2011 Denver $ $700,000 $100,000 $600,000 $100,000 $500,000 El Paso $ Answer check $700,000 Correct $180,000 Correct $520,000 Correct $50,000 Correct $470,000 Correct Project Description Part A Data File CVP Part B Data File Budget Grading Criteria Ready A B c D E 21 22 3 Variable Cost per unit Contribution Margin per unit Break Even units Break Even sales Margin of Safety percentage Operating Leverage $5 $30 3,334 $116,666.67 83.33% 100000.00 $9 Correct $26 Correct 1.924 Correct $67,308 Check formula 90.38% Check formula 50000.00 Check formula + 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 $140,000 $158,000 Check formula 4 Sensitivity Analyis Conservative scenario: Sales decrease by 40% than the projected sales 40% Net Income under conservative scenario: Optimistic scenario: Sales increase by 40% than the projected sales 40% Net Income under optimistic scenario: 5. Explanation: $140,000 $258,000 check formula 38 39 40 41 Project Description Part A Data File CVP Part 6 Data File Budget Grading Criteria Resty