Need a quote
Assume you are the Director of Athletics & Extracurricular activities at Hogwarts High School. There are 34 “Extracurricular Activity Budgets” you oversee at the High School Level. Use the following spreadsheets to complete this assignment (DOWNLOAD EACH SPREADSHEET): ***Your objective is to figure out the “Cost Per Participant” in Column H (missing/empty values highlighted in yellow for the High School Sports). Doc Kelley's NOTE: DON'T CONCERN YOURSELF WITH THE "MS" or Middle School Salaries on the HOGWARTS ATHLETIC SALARIES SPREADSHEET.*** Column C are your Expenditures Column D are your Salaries (w/out benefits) To find the Salaries for column D-Refer to Spreadsheet 2. (Attached/Linked). Column E are your Ticket Revenues/Admission Fees. Column F are the Revenues (e.g. Donations, Fundraising by individuals; Booster monies, special activities dances/dinners). Column G are the actual participants in those extracurricular activities. Column H is the Cost per Participant calculations you must fill in. Spreadsheet 2 are your individual “Athletics Coaching Salaries”. In order to fill in the “blank spaces”; add head coaching and assistant coaching salaries together. **NOTE: In order to calculate the Cost per Participant; utilize the following formula: Expenditures + Salaries – Ticket Revenue – Revenues/ Participants (**If a CPP comes out as a negative number; you must have not utilized the order of the formula). Sheet1 Inerscholastic Athletic/ActivityAccount #ExpendituresSalariesTicket RevenueRevenueParticipantsCPP Drama$ 3,854.95$ 4,454.00$ 4,694.23$ 1,025.00110$ 23.54 Speech$ 675.25$ 2,545.00$ 816.2530$ 80.13 Vocal$ 5,194.85$ 4,454.00$ 3,573.85$ 1,621.0087$ 51.20 Band$ 6,180.78$ 6,682.00$ 4,372.78$ 100.40121$ 69.34 Colorguard$ 1,250.25$ 1,591.00$ 350.0011$ 226.48 Cheer$ 11,927.78$ 11,391.8923 Dance-Pacesetters$ 34,601.45$ 33,558.2917 Boy's Basketball$ 45,318.85$ 9,485.85$ 32,323.2030 Football$ 31,602.71$ 28,608.50$ 25,711.00104 Boy's Soccer$ 2,034.47$ 3,606.55$ 1,269.0041 Baseball$ 6,242.49$ 3,056.00$ 4,892.0039 Boy's Track$ 1,897.42$ 1,456.05$ 4,189.5032 Boy's Cross Country$ 2,198.22$ 2,840.0012 Boy's Tennis$ 803.94$ 2,788.3015 Boy's Golf$ 2,236.04$ 3,624.6019 Boy's Swim$ 3,937.20$ 844.00$ 3,223.1811 Wrestling$ 5,442.65$ 3,127.50$ 4,163.5633 Girl's Basketball$ 15,457.51$ 9,485.85$ 12,228.2531 Volleyball$ 11,423.88$ 4,409.00$ 16,139.0035 Girl's Soccer$ 3,807.34$ 3,094.00$ 5,706.2532 Softball$ 4,690.31$ 5,377.00$ 3,919.3529 Girl's Track$ 7,825.36$ 964.05$ 5,958.0038 Girl's Cross Country$ 3,206.42$ 4,179.7214 Girl's Tennis$ 1,219.75$ 2,889.2821 Girl's Golf$ 4,918.02$ 5,217.9610 Girl's Swim$ 10,724.59$ 1,872.00$ 10,610.0041 Bowling$ 1,562.73$ 2,626.0028 Student Council$ 8,305.34$ 1,909.00$ 7,653.9784$ 30.48 Key Club$ 2,449.00$ 1,200.00$ 2,369.0020$ 64.00 Yearbook$ 5,157.16$ 2,864.00$ 5,318.2013$ 207.92 FFA$ 61,639.08$ 1,200.00$ 69,703.88140$ 49.03 DECA$ 14,164.28$ 1,200.00$ 17,178.7229$ 62.58 Newspaper$ 1,365.00$ 1,909.00$ 1,365.006$ 318.17 Hero$ (85.82)$ 400.00$ 486.7014$ 0.06 Total Budget$ 323,229.25$ 88,027.21$ 307,436.451320$ 124.75 Sheet2 Sheet3 HS Account #SportPositionFTESalary BaseballHEAD BASEBALL1$ 4,773.00 BaseballASST BASEBALL1$ 3,064.00 BaseballASST BASEBALL1$ 3,064.00 BaseballFR BASEBALL1$ 2,437.00 BaseballFR BASEBALL1$ 2,437.00 5 BasketballHEAD Boy's BASKETBALL1$ 6,363.00 BasketballASST BASKETBALL1$ 3,182.00 BasketballASST BASKETBALL-JV1$ 3,182.00 BasketballASST Basketball-Volunteer1$ - 0 BasketballASST BASKETBALL-9th1$ 2,864.00 BasketballASST BASKETBALL-9th1$ 2,545.00 6 Cross CounryHEAD Boy's CROSS COUNTRY1$ 2,983.00 Cross CounryASST CROSS COUNTRY0$ - 0 1 FootballHEAD FOOTBALL1$ 6,363.00 FootballASST FOOTBALL1$ 3,500.00 FootballASST FOOTBALL1$ 3,500.00 FootballASST FOOTBALL1$ 3,182.00 FootballASST FOOTBALL1$ 2,864.00 FootballASST FOOTBALL1$ 2,864.00 FootballASST FOOTBALL-Volunteer0$ - 0 FootballASST FOOTBALL0$ 2,864.00 FootballASST FOOTBALL-9th0$ 2,864.00 FootballASST FOOTBALL-9th0$ 2,545.00 FootballASST Football-9th0$ 2,545.00 FootballASST FOOTBALL-9th Volunteer0$ - 0 6$ 33,091.00 GolfHEAD Boy's GOLF1$ 3,182.00 GolfASST GOLF0.6$ 1,527.00 1.6 SoccerHEAD Boy's SOCCER1$ 4,454.00 SoccerASST SOCCER-9th1$ 2,545.00 SoccerASST SOCCER-JV1$ 2,545.00 3 SwimmingHEAD Boy's SWIMMIMG1$ 4,454.00 SwimmingASST SWIMMING1$ 2,545.00 2 TennisHEAD Boy's TENNIS1$ 3,182.00 TennisASST TENNIS0 1 TrackHEAD Boy's TRACK1$ 4,454.00 TrackASST TRACK1$ 2,545.00 TrackASST TRACK-Volunteer0$ - 0 2 BowlingHEAD BOWLING1$ 3,182.00 BowlingASST BOWLING1$ 2,545.00 2 WrestlingHEAD WRESLING1$ 6,363.00 WrestlingASST WRESTLING1$ 3,182.00 WrestlingASST WRESTLING1$ 2,684.00 WrestlingASST WRESTLING1$ 2,684.00 4 Danceline WinterHEAD DANCELINE1$ 1,909.00 Danceline WinterASST DANCELINE1$ - 0 2 CheerleadingHEAD CHEERLEADING1$ 2,545.00 CheerleadingASST CHEERLEADING1$ 1,591.00 2 Cross CountryHEAD Girl's CROSS COUNTRY1$ 3,182.00 Cross CountryASST CROSS COUNTRY0$ - 0 1 GolfHEAD Girl's GOLF1$ 3,182.00 GolfASST GOLF0.4$ 1,018.00 1.4 SoccerHEAD Girl's SOCCER1$ 4,454.00 SoccerASST SOCCER-JV1$ 2,545.00 SoccerASST SOCCER-9th1$ 2,545.00 3 SwimmingHEAD Girl's SWIMMING1$ 4,454.00 SwimmingASST SWIMMING1$ 2,545.00 2 TennisHEAD Girl's TENNIS1$ 3,182.00 TennisASST TENNIS1$ 2,545.00 2 TrackHEAD Girl's TRACK1$ 4,454.00 TrackASST TRACK1$ 2,545.00 TrackASST TRACK1$ 2,545.00 3 VolleyballHEAD VOLLEYBALL1$ 4,773.00 VolleyballASST VOLLEYBALL1$ 3,182.00 VolleyballASST VOLLEYBALL-JV1$ 3,182.00 VolleyballASST VOLLEYBALL-9th1$ 2,864.00 VolleyballASST VOLLEYBALL-9th1$ 2,545.00 5 SoftballHEAD SOFTBALL1$ 4,773.00 SoftballASST SOFTBALL-JV1$ 3,182.00 SoftballASST SOFTBALL-9th1$ 2,545.00 3 BasketballHEAD Girl's BASKETBALL1$ 6,363.00 BasketballASST BASKETBALL1$ 3,182.00 BasketballASST BASKETBALL1$ 3,182.00 BasketballASST BASKETBALL-9th1$ 2,864.00 BasketballASST BASKETBALL-9th1$ 2,545.00 5 MS Account #SportFirst NameLast NameExp. DateIBOEE#PositionFTESalary BasketballTylerStewart3/30/201013577MS ASST BASKETBALL1$ 2,227.00 BasketballAndrewKuker3/28/17363323MS HEAD BASKETBALL1$ 2,227.00 BasketballBradyCalow10/17/191018937MS HEAD BASKETBALL1$ 2,227.00 BasketballSteveWeeks9/30/19989505MS ASST BASKETBALL1$ 2,227.00 4 BasketballAshleyRyan7/29/20824348MS 8th HEAD BASKETBALL1$ 2,227.00 BasketballJoEllenLinn1/31/19319633MS 8th ASST BASKETBALL1$ 2,227.00 BasketballElizabethMountTBATBAMS 7th HEAD BASKETBALL1$ 2,227.00 BasketballEmilySvatoschTBATBAMS 7th ASST BASKETBALL1$ 2,227.00 4 SoftballToddLucas7/31/16311771HEAD SOFTBALL1$ 2,227.00 SoftballLizzieStock4/6/201021564ASST SOFTBALL1$ 2,227.00 2 VolleyballEricVanderVelden11/30/17963449MS VOLLEYBALL1$ 2,227.00 VolleyballKimPowers6/30/20979778MS VOLLEYBALL1$ 2,227.00 VolleyballAshleyRyan7/29/20824348MS VOLLEYBALL1$ 2,227.00 VolleyballMichaelaWood2/22/171003447MS VOLLEYBALL1$ 2,227.00 VolleyballAndrewKuker3/28/17363323MS VOLLEYBALL1$ 2,227.00 5 Cross CounryChadGarvis8/19/201023661MS CROSS COUNTRY1$ 2,227.00 Cross CounryRachelTomas8/11/16971189MS CROSS COUNTZRY1$ 2,227.00 2 TrackEricVanderVelden11/30/17963449MS TRACK1$ 2,227.00 TrackBradKahler11/21/18981945MS TRACK1$ 2,227.00 TrackzzzzzzzzMS TRACK1$ 2,227.00 TrackChadGarvis8/19/201023661MS TRACK1$ 2,227.00 TrackJoEllenLinn1/31/19319633MS TRACK1$ 2,227.00 TrackDavidHook12/31/16210785MS TRACK1$ 2,227.00 6 WrestlingCooperHeath11/15/171005025MS WRESTLING1$ 2,227.00 WrestlingWaynePrime2/14/19339810MS WRESTLING1$ 2,227.00 2 FootballArchieErgenbright4/3/191015666MS FOOTBALL-8th Volunteer0$ - 0 FootballBrianSmith10/31/17235821MS FOOTBALL-8th1$ 2,227.00 FootballJustinListon3/3/17336023MS FOOTBALL-8th1$ 2,227.00 FootballStevePearson9/30/18194873MS FOOTBALL-8th1$ 2,227.00 FootballDarinTisdale11/29/17812018MS FOOTBALL-7th1$ 2,227.00 FootballCooperHeath11/15/171005025MS FOOTBALL-7th1$ 2,227.00 FootballBrradyCalow10/17/191018937MS FOOTBALL-7th1$ 2,227.00 FootballTomTisdaleNA129226MS FOOTBALL-7thVolunteer0$ - 0 6