In this assianment, rou will conduct a profit analysis applying the contribution margin (CM) approach. You should use Excel formulas for all calculations. 1. You will create a spreadsheet in your excel workbook that shows the P\&L 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. Uving total revenue, fixed cost, and total variable cos, calculase profit 2 and show that the protit is equal to the prolit 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 are 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: - Breakexen Arylysis in Excel. [Recommended for creating a breakeven analysis] - Breakmien Analysis in Excel - Cost-Yolume-Profit analysis to determine the breaksen point/dchart in Fxcel bx Chris Menard - Marcionl.Bnahola - Cost Volume Profit Analyeis in Excel (easy) In this assianment, rou will conduct a profit analysis applying the contribution margin (CM) approach. You should use Excel formulas for all calculations. 1. You will create a spreadsheet in your excel workbook that shows the P\&L 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. Uving total revenue, fixed cost, and total variable cos, calculase profit 2 and show that the protit is equal to the prolit 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 are 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: - Breakexen Arylysis in Excel. [Recommended for creating a breakeven analysis] - Breakmien Analysis in Excel - Cost-Yolume-Profit analysis to determine the breaksen point/dchart in Fxcel bx Chris Menard - Marcionl.Bnahola - Cost Volume Profit Analyeis in Excel (easy)