Do it in excel only part b

Income Statement Income Participants per Week 150 Average Class Price $12 Total Revenue S 1,800.00 Variable Expenses Participants 150 Classes 10 0 Average Equipment Cost per Participant 4.00 Total Equipment Cost Average Instructor Cost per Class S 80.00 Total Instructor Costs Total Variable Expenses + Fixed Expenses 6 Rent 500.00 Advertising 200.00 Administrative 800.00 Miscellaneous 500.00 Total Fixed Expenses Summary Total Revenue Total Expenses Net Income 26 Part A: Complete Income Statement 27 1. Compute Total Revenue 18 2. Compute Total Variable Expenses (Total Equipment + Total Instructors Costs) 9 3. Compute Total Fixed Expenses 0 4. Compute Net Income for 150 Participants (Total Revenue - Total Expenses) 32 Part B: Complete Income Statement 33 1. Determine Break-Even (Total Revenue - Total Expenses = 0), [Hint: only change number of participants (Cell B4), assume a class can support up to 50 participants, and fixed costs do not vary.) 2. Determine the maximum Net Income (Total Revenue - Total Expenses ), [Hint: only change number of participants (Cell B4), assume a class can support up to 50 participants, and fixed costs do not vary. 36