Assume you are the Director of Athletics & Extracu
icular activities at Hogwarts High School. There are 34 “Extracu
icular 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 extracu
icular 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/Activity Account # Expenditures Salaries Ticket Revenue Revenue Participants CPP
Drama $ 3,854.95 $ 4,454.00 $ 4,694.23 $ 1,025.00 110 $ XXXXXXXXXX
Speech $ XXXXXXXXXX $ 2,545.00 $ XXXXXXXXXX 30 $ XXXXXXXXXX
Vocal $ 5,194.85 $ 4,454.00 $ 3,573.85 $ 1,621.00 87 $ XXXXXXXXXX
Band $ 6,180.78 $ 6,682.00 $ 4,372.78 $ XXXXXXXXXX 121 $ XXXXXXXXXX
Colorguard $ 1,250.25 $ 1,591.00 $ XXXXXXXXXX 11 $ XXXXXXXXXX
Cheer $ 11,927.78 $ 11,391.89 23
Dance-Pacesetters $ 34,601.45 $ 33,558.29 17
Boy's Basketball $ 45,318.85 $ 9,485.85 $ 32,323.20 30
Football $ 31,602.71 $ 28,608.50 $ 25,711.00 104
Boy's Soccer $ 2,034.47 $ 3,606.55 $ 1,269.00 41
Baseball $ 6,242.49 $ 3,056.00 $ 4,892.00 39
Boy's Track $ 1,897.42 $ 1,456.05 $ 4,189.50 32
Boy's Cross Country $ 2,198.22 $ 2,840.00 12
Boy's Tennis $ XXXXXXXXXX $ 2,788.30 15
Boy's Golf $ 2,236.04 $ 3,624.60 19
Boy's Swim $ 3,937.20 $ XXXXXXXXXX $ 3,223.18 11
Wrestling $ 5,442.65 $ 3,127.50 $ 4,163.56 33
Girl's Basketball $ 15,457.51 $ 9,485.85 $ 12,228.25 31
Volleyball $ 11,423.88 $ 4,409.00 $ 16,139.00 35
Girl's Soccer $ 3,807.34 $ 3,094.00 $ 5,706.25 32
Softball $ 4,690.31 $ 5,377.00 $ 3,919.35 29
Girl's Track $ 7,825.36 $ XXXXXXXXXX $ 5,958.00 38
Girl's Cross Country $ 3,206.42 $ 4,179.72 14
Girl's Tennis $ 1,219.75 $ 2,889.28 21
Girl's Golf $ 4,918.02 $ 5,217.96 10
Girl's Swim $ 10,724.59 $ 1,872.00 $ 10,610.00 41
Bowling $ 1,562.73 $ 2,626.00 28
Student Council $ 8,305.34 $ 1,909.00 $ 7,653.97 84 $ XXXXXXXXXX
Key Club $ 2,449.00 $ 1,200.00 $ 2,369.00 20 $ XXXXXXXXXX
Yea
ook $ 5,157.16 $ 2,864.00 $ 5,318.20 13 $ XXXXXXXXXX
FFA $ 61,639.08 $ 1,200.00 $ 69,703.88 140 $ XXXXXXXXXX
DECA $ 14,164.28 $ 1,200.00 $ 17,178.72 29 $ XXXXXXXXXX
Newspaper $ 1,365.00 $ 1,909.00 $ 1,365.00 6 $ XXXXXXXXXX
Hero $ XXXXXXXXXX) $ XXXXXXXXXX $ XXXXXXXXXX 14 $ 0.06
Total Budget $ 323,229.25 $ 88,027.21 $ 307,436.45 1320 $ XXXXXXXXXX
Sheet2
Sheet3
HS
Account # Sport Position FTE Salary
Baseball HEAD BASEBALL 1 $ 4,773.00
Baseball ASST BASEBALL 1 $ 3,064.00
Baseball ASST BASEBALL 1 $ 3,064.00
Baseball FR BASEBALL 1 $ 2,437.00
Baseball FR BASEBALL 1 $ 2,437.00
5
Basketball HEAD Boy's BASKETBALL 1 $ 6,363.00
Basketball ASST BASKETBALL 1 $ 3,182.00
Basketball ASST BASKETBALL-JV 1 $ 3,182.00
Basketball ASST Basketball-Volunteer 1 $ - 0
Basketball ASST BASKETBALL-9th 1 $ 2,864.00
Basketball ASST BASKETBALL-9th 1 $ 2,545.00
6
Cross Counry HEAD Boy's CROSS COUNTRY 1 $ 2,983.00
Cross Counry ASST CROSS COUNTRY 0 $ - 0
1
Football HEAD FOOTBALL 1 $ 6,363.00
Football ASST FOOTBALL 1 $ 3,500.00
Football ASST FOOTBALL 1 $ 3,500.00
Football ASST FOOTBALL 1 $ 3,182.00
Football ASST FOOTBALL 1 $ 2,864.00
Football ASST FOOTBALL 1 $ 2,864.00
Football ASST FOOTBALL-Volunteer 0 $ - 0
Football ASST FOOTBALL 0 $ 2,864.00
Football ASST FOOTBALL-9th 0 $ 2,864.00
Football ASST FOOTBALL-9th 0 $ 2,545.00
Football ASST Football-9th 0 $ 2,545.00
Football ASST FOOTBALL-9th Volunteer 0 $ - 0
6 $ 33,091.00
Golf HEAD Boy's GOLF 1 $ 3,182.00
Golf ASST GOLF 0.6 $ 1,527.00
1.6
Soccer HEAD Boy's SOCCER 1 $ 4,454.00
Soccer ASST SOCCER-9th 1 $ 2,545.00
Soccer ASST SOCCER-JV 1 $ 2,545.00
3
Swimming HEAD Boy's SWIMMIMG 1 $ 4,454.00
Swimming ASST SWIMMING 1 $ 2,545.00
2
Tennis HEAD Boy's TENNIS 1 $ 3,182.00
Tennis ASST TENNIS 0
1
Track HEAD Boy's TRACK 1 $ 4,454.00
Track ASST TRACK 1 $ 2,545.00
Track ASST TRACK-Volunteer 0 $ - 0
2
Bowling HEAD BOWLING 1 $ 3,182.00
Bowling ASST BOWLING 1 $ 2,545.00
2
Wrestling HEAD WRESLING 1 $ 6,363.00
Wrestling ASST WRESTLING 1 $ 3,182.00
Wrestling ASST WRESTLING 1 $ 2,684.00
Wrestling ASST WRESTLING 1 $ 2,684.00
4
Danceline Winter HEAD DANCELINE 1 $ 1,909.00
Danceline Winter ASST DANCELINE 1 $ - 0
2
Cheerleading HEAD CHEERLEADING 1 $ 2,545.00
Cheerleading ASST CHEERLEADING 1 $ 1,591.00
2
Cross Country HEAD Girl's CROSS COUNTRY 1 $ 3,182.00
Cross Country ASST CROSS COUNTRY 0 $ - 0
1
Golf HEAD Girl's GOLF 1 $ 3,182.00
Golf ASST GOLF 0.4 $ 1,018.00
1.4
Soccer HEAD Girl's SOCCER 1 $ 4,454.00
Soccer ASST SOCCER-JV 1 $ 2,545.00
Soccer ASST SOCCER-9th 1 $ 2,545.00
3
Swimming HEAD Girl's SWIMMING 1 $ 4,454.00
Swimming ASST SWIMMING 1 $ 2,545.00
2
Tennis HEAD Girl's TENNIS 1 $ 3,182.00
Tennis ASST TENNIS 1 $ 2,545.00
2
Track HEAD Girl's TRACK 1 $ 4,454.00
Track ASST TRACK 1 $ 2,545.00
Track ASST TRACK 1 $ 2,545.00
3
Volleyball HEAD VOLLEYBALL 1 $ 4,773.00
Volleyball ASST VOLLEYBALL 1 $ 3,182.00
Volleyball ASST VOLLEYBALL-JV 1 $ 3,182.00
Volleyball ASST VOLLEYBALL-9th 1 $ 2,864.00
Volleyball ASST VOLLEYBALL-9th 1 $ 2,545.00
5
Softball HEAD SOFTBALL 1 $ 4,773.00
Softball ASST SOFTBALL-JV 1 $ 3,182.00
Softball ASST SOFTBALL-9th 1 $ 2,545.00
3
Basketball HEAD Girl's BASKETBALL 1 $ 6,363.00
Basketball ASST BASKETBALL 1 $ 3,182.00
Basketball ASST BASKETBALL 1 $ 3,182.00
Basketball ASST BASKETBALL-9th 1 $ 2,864.00
Basketball ASST BASKETBALL-9th 1 $ 2,545.00
5
MS
Account # Sport First Name Last Name Exp. Date IBOEE# Position FTE Salary
Basketball Tyler Stewart 3/30/20 1013577 MS ASST BASKETBALL 1 $ 2,227.00
Basketball Andrew Kuker 3/28/17 363323 MS HEAD BASKETBALL 1 $ 2,227.00
Basketball Brady Calow 10/17/19 1018937 MS HEAD BASKETBALL 1 $ 2,227.00
Basketball Steve Weeks 9/30/19 989505 MS ASST BASKETBALL 1 $ 2,227.00
4
Basketball Ashley Ryan 7/29/20 824348 MS 8th HEAD BASKETBALL 1 $ 2,227.00
Basketball JoEllen Linn 1/31/19 319633 MS 8th ASST BASKETBALL 1 $ 2,227.00
Basketball Elizabeth Mount TBA TBA MS 7th HEAD BASKETBALL 1 $ 2,227.00
Basketball Emily Svatosch TBA TBA MS 7th ASST BASKETBALL 1 $ 2,227.00
4
Softball Todd Lucas 7/31/16 311771 HEAD SOFTBALL 1 $ 2,227.00
Softball Lizzie Stock 4/6/20 1021564 ASST SOFTBALL 1 $ 2,227.00
2
Volleyball Eric VanderVelden 11/30/17 963449 MS VOLLEYBALL 1 $ 2,227.00
Volleyball Kim Powers 6/30/20 979778 MS VOLLEYBALL 1 $ 2,227.00
Volleyball Ashley Ryan 7/29/20 824348 MS VOLLEYBALL 1 $ 2,227.00
Volleyball Michaela Wood 2/22/17 1003447 MS VOLLEYBALL 1 $ 2,227.00
Volleyball Andrew Kuker 3/28/17 363323 MS VOLLEYBALL 1 $ 2,227.00
5
Cross Counry Chad Garvis 8/19/20 1023661 MS CROSS COUNTRY 1 $ 2,227.00
Cross Counry Rachel Tomas 8/11/16 971189 MS CROSS COUNTZRY 1 $ 2,227.00
2
Track Eric VanderVelden 11/30/17 963449 MS TRACK 1 $ 2,227.00
Track Brad Kahler 11/21/18 981945 MS TRACK 1 $ 2,227.00
Track zzzz zzzz MS TRACK 1 $ 2,227.00
Track Chad Garvis 8/19/20 1023661 MS TRACK 1 $ 2,227.00
Track JoEllen Linn 1/31/19 319633 MS TRACK 1 $ 2,227.00
Track David Hook 12/31/16 210785 MS TRACK 1 $ 2,227.00
6
Wrestling Cooper Heath 11/15/17 1005025 MS WRESTLING 1 $ 2,227.00
Wrestling Wayne Prime 2/14/19 339810 MS WRESTLING 1 $ 2,227.00
2
Football Archie Ergen
ight 4/3/19 1015666 MS FOOTBALL-8th Volunteer 0 $ - 0
Football Brian Smith 10/31/17 235821 MS FOOTBALL-8th 1 $ 2,227.00
Football Justin Liston 3/3/17 336023 MS FOOTBALL-8th 1 $ 2,227.00
Football Steve Pearson 9/30/18 194873 MS FOOTBALL-8th 1 $ 2,227.00
Football Darin Tisdale 11/29/17 812018 MS FOOTBALL-7th 1 $ 2,227.00
Football Cooper Heath 11/15/17 1005025 MS FOOTBALL-7th 1 $ 2,227.00
Football B
ady Calow 10/17/19 1018937 MS FOOTBALL-7th 1 $ 2,227.00
Football Tom Tisdale NA 129226 MS FOOTBALL-7thVolunteer 0 $ - 0
6