Excel project
jamesrulai
GoldGym2016-2020Analysis.xlsx2016
| 2016 Overhead | ||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
| Instructor salaries | $6,400 | $6,500 | $6,400 | $7,000 |
| Food | $2,300 | $2,483 | $1,948 | $3,129 |
| Utilities | $1,293 | $1,384 | $1,589 | $1,305 |
| Office Supplies | $388 | $490 | $435 | $376 |
| Repairs / Maintenance | $6,000 | $3,000 | $4,200 | $2,100 |
| Equipment Purchases | $10,000 | $14,000 | $8,000 | $4,000 |
| Internet / Marketing | $903 | $956 | $785 | $657 |
| 2016 Sales | ||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
| Membership | $2,625 | $2,500 | $3,500 | $3,725 |
| Premium Classes | $125 | $188 | $150 | $175 |
| Equipment Sales | $935 | $811 | $636 | $611 |
| Merchandise Sales | $473 | $260 | $425 | $431 |
| Hydrate Cafe | $1,216 | $1,361 | $1,623 | $1,133 |
| Summer Swim Camp | $0 | $0 | $0 | $0 |
2017
| 2017 Overhead | ||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
| Instructor salaries | $6,600 | $6,450 | $6,400 | $6,600 |
| Food | $2,598 | $2,804 | $3,185 | $3,200 |
| Utilities | $1,293 | $1,384 | $1,589 | $1,305 |
| Office Supplies | $598 | $560 | $348 | $450 |
| Repairs / Maintenance | $3,000 | $2,500 | $1,300 | $1,700 |
| Equipment Purchases | $14,000 | $0 | $2,000 | $800 |
| Internet / Marketing | $654 | $700 | $450 | $569 |
| 2017 Sales | ||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
| Membership | $3,500 | $3,313 | $3,750 | $3,875 |
| Premium Classes | $250 | $263 | $438 | $363 |
| Equipment Sales | $3,049 | $984 | $1,128 | $841 |
| Merchandise Sales | $359 | $363 | $435 | $584 |
| Hydrate Cafe | $3,599 | $3,631 | $4,498 | $4,185 |
| Summer Swim Camp | $0 | $0 | $0 | $0 |
2018
| 2018 Overhead | ||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
| Instructor salaries | $8,200 | $8,000 | $8,400 | $8,200 |
| Food | $2,700 | $2,549 | $3,019 | $3,008 |
| Utilities | $1,298 | $1,400 | $1,568 | $1,389 |
| Office Supplies | $485 | $423 | $412 | $503 |
| Repairs / Maintenance | $0 | $900 | $850 | $1,200 |
| Equipment Purchases | $0 | $1,200 | $800 | $600 |
| Internet / Marketing | $650 | $490 | $478 | $507 |
| 2018 Sales | ||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
| Membership | $6,000 | $5,975 | $4,688 | $4,750 |
| Premium Classes | $300 | $325 | $475 | $463 |
| Equipment Sales | $1,099 | $986 | $1,193 | $1,154 |
| Merchandise Sales | $350 | $223 | $193 | $488 |
| Hydrate Cafe | $2,250 | $3,261 | $3,861 | $3,588 |
| Summer Swim Camp | $0 | $42,000 | $40,000 | $0 |
2019
| 2019 Overhead | ||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
| Instructor salaries | $19,200 | $20,000 | $18,800 | $22,000 |
| Food | $3,091 | $2,980 | $2,870 | $3,150 |
| Utilities | $1,340 | $1,148 | $2,300 | $1,215 |
| Office Supplies | $495 | $560 | $536 | $502 |
| Repairs / Maintenance | $1,200 | $1,400 | $2,000 | $1,700 |
| Equipment Purchases | $2,400 | $3,050 | $1,200 | $750 |
| Internet / Marketing | $754 | $867 | $504 | $578 |
| 2019 Sales | ||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
| Membership | $6,000 | $4,625 | $4,750 | $5,125 |
| Premium Classes | $400 | $450 | $350 | $500 |
| Equipment Sales | $4,000 | $2,483 | $1,099 | $1,195 |
| Merchandise Sales | $234 | $184 | $431 | $810 |
| Hydrate Cafe | $4,125 | $3,813 | $3,861 | $4,084 |
| Summer Swim Camp | $0 | $65,000 | $64,000 | $0 |
2020
| 2020 Overhead | ||
| 1st Quarter | 2nd Quarter | |
| Instructor salaries | $18,400 | $12,000 |
| Food | $2,956 | $1,405 |
| Utilities | $1,422 | $800 |
| Office Supplies | $495 | $276 |
| Repairs / Maintenance | $1,200 | $874 |
| Equipment Purchases | $1,950 | $0 |
| Internet / Marketing | $547 | $450 |
| New Classes | $2,390 | $980 |
| 2020 Sales | ||
| 1st Quarter | 2nd Quarter | |
| Membership | $3,000 | $1,813 |
| Premium Classes | $350 | $513 |
| Equipment Sales | $759 | $438 |
| Merchandise Sales | $738 | $350 |
| Hydrate Cafe | $3,759 | $1,509 |
| Summer Swim Camp | $0 | $0 |
Business Model
| Membership | Gym/Full Time Instructors | |
| $20/month | salary varies by level of experience | |
| $220/year | ||
| Premium Classes | ||
| $5/class | ||
| $20/class kit (5 classes) | ||
| Equipment & Merchandise | ||
| $100 - $6,000 | Least expensive | Most expensive |
| T-shirts | Ellipticals | |
| Dumbbells | Treadmills | |
| Hydrate Cafe | Swim Camps | |
| Smoothies | $250/swimmer/week | |
| $4.50 each, one size | 12 weeks in summer | |
| Protein Shakes | ||
| $4.00 each, one size | Summer Swim Instructors | |
| Snack Boxes | $12/hour | |
| $6-9 each, depends on ingredients | ||
| Water Bottles | ||
| $1.50 each |
