USING 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 VII Spreadsheet Template in Excel (Full Variable tab), complete the calculations listed below.
Calculate the value of ending inventory under full or absorption costing.
Calculate the value of ending inventory under variable costing.
Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report.
Discuss the results, and comment on which method you think is more helpful to managers and why
