Please show how you got each answer!

A B C E 2 1 Excel formulas must be used. Please be sure to submit your file as an Excel file. Any submissions in numbers format will receive a 0. 3 CVP Student Name Colin Scott 5 Section Number M-002 4 => => 6 7 8 00 o 9 Data Section: Fixed Variable 10 11 12 13 $2.30 4.70 3.00 14 $225,000 15 16 0.75 Production costs: Direct materials Direct labor Factory overhead Selling expenses: Sales salaries & commissions Advertising Miscellaneous selling expense General expenses: Office salaries Supplies Miscellaneous general expense 17 97,000 47,500 16,200 18 19 20 21 92,000 12,300 15,000 0.25 22 23 24 Total FORMULA1 FORMULA2 25 26 27 28 Additional information: Selling price per unit Expected unit sales Target profit 29 $16.00 120,000 $20,000 30 31 32 A B E 19 20 21 22 23 24 General expenses: Office salaries Supplies Miscellaneous general expense 92,000 12,300 15,000 0.25 Total FORMULA1 FORMULA2 25 26 27 28 Additional information: Selling price per unit Expected unit sales Target profit 29 $16.00 120,000 $20,000 30 31 32 33 34 Answer Section: 35 36 37 38 Contribution margin per unit Contribution margin (Total) Contribution margin ratio Break-even point in units Break-even point in sales dollars Target profit (Unit sales needed) Target profit (Dollar sales needed) FORMULA3 FORMULA4 FORMULA5 FORMULA6 FORMULA7 FORMULAS FORMULAS 39 40 41 42 43 44 45 46 47 Total revenue at expected unit sales Net income at expected unit sales Margin of safety as a percentage of sales FORMULA10 FORMULA11 FORMULA12 48 49