In this assianment, rou will conduct a profit analysis applying the contribution margin (CM) approach. You should use Encel formulas for all calculations. 1. You will create a spreadsheet in your excel workbook that shows the PLL statement 2. Using the list of costs in the table below, calculate - Total cost * Variable cost rate - Total revenue * CM - Total CM - Prodit 1 (the CM approach) 3. Uxing total revenue, fixed cost, and total variable cost, calculate profit 2 and show that the protit is equal to the profit that you calculated in a2 above 4. Perform a breakeven analysis based on a standard format 5. Perform a breakeven analysis based on CM format and show that the results ane identical, 6. Write a synopsis that describes the steps of the breakeven analysis and how to use it for decision-making in the healthcare industry. 1 You might find these links helpful; - Brezkextn Anglysin Excel. [Recommended for creating a break-eren analysis] - Breakmien Analyos in Excel - - Cost-Yolume-Profit analysis to determine the breakeren point L chact in Fxcel bx Chris Merird - MarcinnlAnahols - Cost Volume Profit.Analyes in Excel (easy)