B C D E G 1 2 3 4 5 Units Sold A Cookie Business Chocolate Chip 1,500,000 Sugar 980,000 Specialty 300,000 Total 2,780,000 6 Sales $ 1,875,000.00 $ 882,000.00 $1,050,000.00 $ 3,807,000.00 7 Less: Variable Costs 8 Contribution Margin $ 690,000.00 $ 205,800.00 $ 81,000.00 $ 976,800.00 $ 1,185,000.00 $ 676,200.00 $ 969,000.00 $ 2,830,200.00 g Less: Common Fixed Costs 10 Profit $ 125,000.00 2,705,200.00 11 12 Per item Contribution Margin 13 Weighted Average 14 Contribution Margin 15 16 17 Break-even point in units 19 8 19 20 21 Part 1: Based on the data presented in the Unit VII Spreadsheet Template in Excel (CM Breakeven tab): Calculate the contribution margin (CM) for each of the three products sold at the cookie business. Calculate the weighted average CM. Calculate the breakeven point. Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Discuss the results based on your calculations as far as which type of cookie you think is the most profitable, which has the highest CM, etc. Part 2 Based on the data presented in the Unit VILSpreadsheet Template in Iveal T E