Additional Project

Break-Even Analysis for Harmony Fitness

Files Needed: Tutorial 10_Harmony Fitness Analysis.xlsx

Harmony Fitness is a 1000 square foot facility that offers fitness classes, including Yoga, Pilates, Nia, and aerobics. Shelley Getz, the owner of the facility, is evaluating her pricing options for fitness classes. She needs to know how many people need to take a class each week for her to pay instructors, cover her expenses, break even, and then make a profit. She asks you to help her set up a Break-Even Analysis using one and two-variable tables and scenarios.

1. Open the file Tutorial 10_Last Name_Harmony Fitness Analysis.xlsx. (Replace Last Name with your last name.)
2. Enter data in the Income Statement as shown below: