PLEASE SHOW EXCEL EQUATIONS!!!PLEASE SHOW EXCEL EQUATIONS!!!!

Instructions The Excel 5 Assignment is related to the case study included in the Week 5: Course Material. I recommend you complete this assignment after you have read the course textbook, the course material and the case study. The Excel 5 workbook has three separate tabs that must be completed. Breakeven/Sensitivity Analysis Tab Complete the breakeven point for SLS for May 2013 in Column D. In Column F, assume the contribution margin increases by $3 and complete the breakeven point. In Column H, assume the contribution margin decreases by $3 and complete the breakeven point. Hint: One fixed cost is notated with a "?" so you will need to identify the missing fixed cost in the case study. All other fixed costs are listed. Profit By Class Tab Calculate the profit by class type (sales mix). You will need to complete the percentage of client visits that is blank to make it easier to allocate the costs by a formula in Excel. Number of classes and contribution margins are provided. 3-Month Profit Analysis Tab Calculate the monthly profit for March 2013, April 2013, and May 2013. Hint: The total profit (or loss) on the Profit By Class tab will equal the May 2013 profit because the Profit by Class calculation is also for May 2013. Revenue for each month is provided. As always, review the Excel rubric and your formatting and organizing before submitting your assignment. A B C D E F G H J J K 1 2 3 4 5 6 7 8 SLS Yoga Group Classes Breakeven Analysis May 2013 May-13 May-13 May-13 (CM+3) May-13 (CM-3) Use Median Rent Per Sq Ft Provided Fixed Costs: Monthly Rent Monthly Shared Services ? Teacher Costs Total Fixed Costs Use Average Provided Contribution Margin Per Client Visit $21 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Total Number of Client Visits Required for Group Classes Number of Active Clients in May 2013 Monthly Number of Visits to Group Classes Required by Clients Breakeven Sensitivity Analysis Profit By Class 3-Month Profit Analysis + B D E F G H 1 2 3 4 5 6 SLS Yoga Profit By Class May 2013 Group Private Salt Cave Total Number of Client Visits Percentage Number of Classes Percentage 155 87% 18 10% 6 3% 179 100% Contribution Margin $21 $ 130 $70 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Total Revenue 0 Less Fixed Costs: Monthly Rent Monthly Shared Services ? Teacher Costs Allocate by Classes Conducted (Hint: Salt Cave Rental is Separate from Monthly Rent) Allocate by Client Visits Allocate by Client Visits Profit By Class 0 Breakeven Sensitivity Analysis Profit By Class 3-Month Profit Analysis + A B C D E F G H . I SLS Yoga 3-Month Profit Analysis March - May 2013 Mar-13 Apr-13 May-13 Revenue $ 19,400 $ 20,487 $ 25,188 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Costs: Monthly Rent Monthly Shared Services ? Cost of Group Classes Cost of Private Classes Cost of Salt Cave Classes Total Costs $ $ $ Monthly Profit $ 19,400 $ 20,487 $ 25,188 26 27 28 29 30 31 32 33 Breakeven|Sensitivity Analysis Profit By Class 3-Month Profit Analysis +