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 Profit 1 (Use CM approach) 3. Using total revenue, fixed cost, and total variable cost, calculate profit 2 and show that the profit is equal to the profit that you calculated in #2 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. [Part II - 10 pts.] 6. Write a synopsis that describes the steps of the breakeven analysis and how to use it for decision-making in the healthcare industry. # Amount Volume (visits) 125,000 Average revenue $100 Fixed cost $3,250,000 Total Variable cost $1,950,000 Total cost Variable cost rate Total revenue CM Total CM