Answer and feedback
jamesrulai
A1.xlsx2019
| 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 |
Projected 2020 ProfitLoss
| 2020 Overhead | Totals | |||||||
| 1st Quarter | 2nd Quarter | 2020 Gold Gym Profit/Loss Statement for the First Two Quarters | ||||||
| Instructor salaries | $18,400 | $12,000 | $30,400 | INCOME | % of Total Income | |||
| Food | $2,956 | $1,405 | $4,361 | Other Revenue | $ 1,471.00 | |||
| Utilities | $1,422 | $800 | $2,222 | Membership | $4,813 | 26.64% | ||
| Office Supplies | $495 | $276 | $771 | Premium Classes | $863 | 4.77% | ||
| Repairs / Maintenance | $1,200 | $874 | $2,074 | Equipment Sales | $1,196 | 6.62% | ||
| Equipment Purchases | $1,950 | $0 | $1,950 | Merchandise Sales | $1,088 | 6.02% | ||
| Internet / Marketing | $547 | $450 | $997 | Hydrate Cafe | $5,268 | 29.15% | ||
| Grant Total | $42,775 | Summer Swim Camp | $0 | 0.00% | ||||
| New Classes | $3,370 | 18.65% | ||||||
| Total Income | $ 18,067.25 | 91.86% | ||||||
| 2020 Sales | Totals | |||||||
| 1st Quarter | 2nd Quarter | EXPENSES | ||||||
| Membership | $3,000 | $1,813 | $4,813 | Instructor salaries | $30,400 | 26.70% | ||
| Premium Classes | $350 | $513 | $863 | Food | $4,361 | 3.83% | ||
| Equipment Sales | $759 | $438 | $1,196 | Utilities | $2,222 | 1.95% | ||
| Merchandise Sales | $738 | $350 | $1,088 | Office Supplies | $771 | 0.68% | ||
| Hydrate Cafe | $3,759 | $1,509 | $5,268 | Repairs / Maintenance | $2,074 | 1.82% | ||
| Summer Swim Camp | $0 | $0 | $0 | Equipment Purchases | $1,950 | 1.71% | ||
| New Classes | 980 | $2,390 | $3,370 | Internet / Marketing | $997 | 0.88% | ||
| Loan Repayment | $70,000 | |||||||
| Other Expenses | $ 1,064.00 | |||||||
| Grand Total | $16,596 | Total Expenses | $113,839 | 37.57% | ||||
| NET INCOME | ($95,772) | |||||||
| Loss | ($95,772) | |||||||
| Gold Gym - Estimates | ||||||||
| Revenue | Overall Startup Costs | Production Costs per Unit | ||||||
| Prospective Product/Service | per item | Cost from Manufacturer | Labor/Supplies | Label/Packaging | Cost from Manufacturer | |||
| On Demand Fitness | $20/5 classes | $ - 0 | instructor salaries | $ - 0 | Instructors use equipment already in gym | |||
| Premium Fee | $ 5.00 | $ - 0 | $ - 0 | $ - 0 | ||||
| Nutrition Shakes | $ 6.00 | $ 1.00 | $ 1.00 | |||||
| Equipment | ||||||||
| Dumbbells (5/10/15 lb pack) | $ 40.00 | $ 30.00 | $ 5.00 | $ 50.00 | $ 3.00 | |||
| Ellipticals | $ 600.00 | $ 400.00 | $ 10.00 | $ 5.00 | ||||
| Treadmills | $ 450.00 | $ 300.00 | $ 10.00 | $ 5.00 | ||||
| Stationary Bikes | $ 275.00 | $ 200.00 | $ 10.00 | $ 5.00 | ||||
| Cardio Regiment | $35/4 classes | $ - 0 | instructor salaries | Instructors use equipment already in gym | ||||
| Gold Gym Apparel | ||||||||
| Shirts | $ 15.00 | $ 20.00 | clothing already packaged at manufacturer site | $ 3.00 | ||||
| Sweatbands | $ 5.00 | $ 0.50 | ||||||
| Wristbands | $ 5.00 | $ 0.50 | ||||||
| Socks | $ 15.00 | $ 1.00 | ||||||
| Leggings | $ 25.00 | $ 2.00 | ||||||
| Sweatpants | $ 30.00 | $ 2.00 | ||||||
| $ 1,471.00 | $ 930.00 | $ 55.00 | $ 51.00 | $ 28.00 | ||||
| $ 1,064.00 |
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 |
| 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 |
| New Classes | 980 | $2,390 |
2019 ProftLoss
| 2019 Overhead | Totals | |||||||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | 2019 | ||||||
| Instructor salaries | $19,200 | $20,000 | $18,800 | $22,000 | $80,000 | Gold Gym Profit and Loss Statement / For the Year Ending 2019 | ||||
| Food | $3,091 | $2,980 | $2,870 | $3,150 | $12,091 | INCOME | % of Total Income | |||
| Utilities | $1,340 | $1,148 | $2,300 | $1,215 | $6,003 | |||||
| Office Supplies | $495 | $560 | $536 | $502 | $2,093 | Membership | $20,500 | 11.55% | ||
| Repairs / Maintenance | $1,200 | $1,400 | $2,000 | $1,700 | $6,300 | Premium Classes | $1,700 | 0.96% | ||
| $0 | Equipment Sales | $8,776 | 4.94% | |||||||
| $0 | Merchandise Sales | $1,659 | 0.93% | |||||||
| $0 | Hydrate Cafe | $15,883 | 8.95% | |||||||
| $0 | Summer Swim Camp | $129,000 | 72.67% | |||||||
| $0 | Total Income | $177,518 | 100.00% | |||||||
| $0 | ||||||||||
| Equipment Purchases | $2,400 | $3,050 | $1,200 | $750 | $7,400 | |||||
| Internet / Marketing | $754 | $867 | $504 | $578 | $2,703 | EXPENSES | ||||
| Grand Total | $116,590 | Instructor salaries | $80,000 | 68.6% | ||||||
| Food | $12,091 | 10.4% | ||||||||
| 2019 Sales | Totals | Utilities | $6,003 | 5.1% | ||||||
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Office Supplies | $2,093 | 1.8% | ||||
| Membership | $6,000 | $4,625 | $4,750 | $5,125 | $20,500 | Repairs / Maintenance | $6,300 | 5.4% | ||
| Premium Classes | $400 | $450 | $350 | $500 | $1,700 | Equipment Purchases | $7,400 | 6.3% | ||
| Equipment Sales | $4,000 | $2,483 | $1,099 | $1,195 | $8,776 | Internet / Marketing | $2,703 | 2.3% | ||
| Merchandise Sales | $234 | $184 | $431 | $810 | $1,659 | Total Expenses | $116,590 | 100.0% | ||
| Hydrate Cafe | $4,125 | $3,813 | $3,861 | $4,084 | $15,883 | |||||
| Summer Swim Camp | $0 | $65,000 | $64,000 | $0 | $129,000 | NET INCOME | $60,928 | |||
| Grand Total | $149,500 | |||||||||
| PROFIT | $60,928 |
2020 (First 2 Quaters ProfitLos
| 2020 Overhead | Totals | |||||||
| 1st Quarter | 2nd Quarter | 2020 Gold Gym Profit/Loss Statement for the First Two Quarters | ||||||
| Instructor salaries | $18,400 | $12,000 | $30,400 | INCOME | % of Total Income | |||
| Food | $2,956 | $1,405 | $4,361 | |||||
| Utilities | $1,422 | $800 | $2,222 | Membership | $4,813 | 29.00% | ||
| Office Supplies | $495 | $276 | $771 | Premium Classes | $863 | 5.20% | ||
| Repairs / Maintenance | $1,200 | $874 | $2,074 | Equipment Sales | $1,196 | 7.21% | ||
| Equipment Purchases | $1,950 | $0 | $1,950 | Merchandise Sales | $1,088 | 6.55% | ||
| Internet / Marketing | $547 | $450 | $997 | Hydrate Cafe | $5,268 | 31.74% | ||
| Grant Total | $42,775 | Summer Swim Camp | $0 | 0.00% | ||||
| New Classes | $3,370 | 20.31% | ||||||
| Total Income | $16,596 | 100.00% | ||||||
| 2020 Sales | Totals | |||||||
| 1st Quarter | 2nd Quarter | EXPENSES | ||||||
| Membership | $3,000 | $1,813 | $4,813 | Instructor salaries | $30,400 | 71.07% | ||
| Premium Classes | $350 | $513 | $863 | Food | $4,361 | 10.20% | ||
| Equipment Sales | $759 | $438 | $1,196 | Utilities | $2,222 | 5.19% | ||
| Merchandise Sales | $738 | $350 | $1,088 | Office Supplies | $771 | 1.80% | ||
| Hydrate Cafe | $3,759 | $1,509 | $5,268 | Repairs / Maintenance | $2,074 | 4.85% | ||
| Summer Swim Camp | $0 | $0 | $0 | Equipment Purchases | $1,950 | 4.56% | ||
| New Classes | 980 | $2,390 | $3,370 | Internet / Marketing | $997 | 2.33% | ||
| Grand Total | $16,596 | Total Expenses | $42,775 | 100.00% | ||||
| NET INCOME | ($26,179) | |||||||
| Loss | ($26,179) | |||||||
