Documentation Shelly Cashman Excel 2019 | Module 9: SAM Project 1b Green Lake Sports Camp FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING Author:FATEMATUZ ZAHARA Note: Do not edit this...

1 answer below »
Documentation
Shelly Cashman Excel 2019 | Module 9: SAM Project 1b
Green Lake Sports Camp
FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING
Author:FATEMATUZ ZAHARA
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
Teams
Summer Teams
BaseballBasketballLacrosseSoccerVolleyball
Registration fee$ 129$ 278$ 119$ 149$ 119
Weeks per session24242
Minimum campers1510- 01610
Equipment fee$ 200$ 180$ 200$ 175$ 175
RevenueERROR:#VALUE!$ 4,580$ - 0$ 5,184$ 2,940
Counselors33222
Counselor cost$ 535$ 535$ 500$ 550$ 500
Supplies cost$ 125$ 95$ 105$ 125$ 95
Expenses$ 1,730$ 1,700$ 1,105$ 1,225$ 1,095
Revenue stats
Per sessionERROR:#VALUE!$ 2,880$ (1,105)$ 3,959$ 1,845
Per weekERROR:#VALUE!$ 720$ (553)$ 990$ 923
Per camperERROR:#VALUE!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
Average revenue
Per sessionERROR:#VALUE!
Per weekERROR:#NAME?
Per camperERROR:#VALUE!
Private Lessons
Private Lessons
BaseballBasketballLacrosseSoccerVolleyball
Coach cost per day$ 420$ 480$ 400$ 475$ 400
Equipment cost$ 120$ 85$ 100$ 95$ 85
Total cost$ 540$ 565$ 500$ 570$ 485
Maximum campers per day1012101215
Enrolled campers per day9107128
Coaching fee per person$ 75$ 80$ 80$ 80$ 75
Average profit per session$ 135$ 235$ 60$ 390$ 115
Average profit per camper$ XXXXXXXXXX$ XXXXXXXXXX$ 8.57$ XXXXXXXXXX$ XXXXXXXXXX
Revised Fees
Revised Fees
BaseballBasketballLacrosseSoccerVolleyball
Coach cost per day$ 420$ 480$ 400$ 475$ 400
Equipment cost$ 120$ 85$ 100$ 95$ 85
Total cost$ 540$ 565$ 500$ 570$ 485
Maximum campers per day1012101215
Enrolled campers per day9107128
Coaching fee per person$ 75$ 80$ 80$ 80$ 75
Average profit per session$ 135$ 235$ 60$ 390$ 115
Average profit per camper$ XXXXXXXXXX$ XXXXXXXXXX$ 8.57$ XXXXXXXXXX$ XXXXXXXXXX
Games
Games
Game Schedule
BaseballBasketballLacrosseSoccerVolleyballTotal
Friday games000000
Saturday games000000
Games per week000000
Games - Profit Analysis
BaseballBasketballLacrosseSoccerVolleyballTotal
Profit per Friday game$ XXXXXXXXXX$ XXXXXXXXXX$ XXXXXXXXXX$ XXXXXXXXXX$ XXXXXXXXXX$ XXXXXXXXXX
Subtotal profit$ - 0$ - 0$ - 0$ - 0$ - 0- 0
Profit per Saturday game$ XXXXXXXXXX$ XXXXXXXXXX$ XXXXXXXXXX$ XXXXXXXXXX$ XXXXXXXXXX185.00
Subtotal profit$ - 0$ - 0$ - 0$ - 0$ - 0- 0
Total weekly profit$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Practices
BaseballBasketballTotal
Friday practice000
Saturday practice000
Practices per week000
Maximum weekly profit model
Answered Same DayMay 01, 2021

Solution

Akshay Kumar Garg answered on May 02 2021
27 Votes

Documentation
Shelly Cashman Excel 2019 | Module 4: SAM Project 1b
Ramos Family Home Purchase
CREATE A LOAN ANALYSIS
Author:FATEMATUZ ZAHARA
Note: Do not edit this sheet....

Submit New Assignment

Copy and Paste Your Assignment Here