My Lab IT Worksheet
| Better You Fitness Center | ||||||||
| Profit and Loss Statement | ||||||||
| Year 1 | Year 2 | Year 3 | ||||||
| Income | ||||||||
| Memberships | $ 100,000 | $ 275,000 | $ 395,000 | |||||
| Clothing Merchandise | 85,000 | 111,300 | 126,000 | |||||
| Other | 4,250 | 5,350 | 6,140 | |||||
| Total Income | $ 189,250 | $ 391,650 | $ 527,140 | |||||
| Expenses | ||||||||
| Cost of Sales | $ 75,000 | $ 92,500 | $ 65,000 | |||||
| Payroll | 75,000 | 180,000 | 250,000 | |||||
| Advertising | 15,270 | 17,163 | 15,879 | |||||
| Education & Training | 10,000 | 12,000 | 10,000 | |||||
| Insurance | 15,000 | 15,000 | 15,000 | |||||
| Rent | 25,000 | 25,000 | 25,000 | |||||
| Repairs & Maintenance | 5,000 | 10,000 | 3,000 | |||||
| Utilities | 12,000 | 13,200 | 14,520 | |||||
| Supplies | 3,000 | 3,200 | 3,800 | |||||
| Total Operating Expenses | $ 235,270 | $ 368,063 | $ 402,199 | |||||
| Net Operating Profit | $ (46,020) | $ 23,587 | $ 124,941 | |||||
ORDER A PLAGIARISM-FREE PAPER HERE
We’ll write everything from scratch
Question 
Excel Unit 2 – Grader Project – GymExcel Unit 2 – Grader Project – Gym
Due: Sunday by 11:59 pm EST
You are to complete this Assignment in MyLab IT, by downloading the instructions and the worksheet. After the worksheet has been completed, you are to upload it into MyLab IT for grading.
My Lab IT Worksheet
Review this document before completing the project: Unit2GraderProject.pdf Unit2GraderProject.pdf – Alternative Formats
Review this tutorial before completing the project: