Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Need a quote

1 answer below »
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
Answered 1 days After Mar 25, 2024

Solution

Prince answered on Mar 27 2024
6 Votes
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    $ 23.54
    Speech        $ 675.25    $ 2,545.00        $ 816.25    30    $ 80.13
    Vocal        $ 5,194.85    $ 4,454.00    $ 3,573.85    $ 1,621.00    87    $ 51.20
    Band        $ 6,180.78    $ 6,682.00    $ 4,372.78    $ 100.40    121    $ 69.34
    Colorguard        $ 1,250.25    $ 1,591.00        $ 350.00    11    $ 226.48
    Cheer        $ 11,927.78    $ 4,136.00        $ 11,391.89    23    $ 203.13
    Dance-Pacesetters        $ 34,601.45    $ 1,909.00        $ 33,558.29    17    $ 173.66
    Boy's Basketball        $ 45,318.85    $ 18,136.00    $ 9,485.85    $ 32,323.20    30    $ 721.53
    Football        $ 31,602.71    $ 33,091.00    $ 28,608.50    $ 25,711.00    104    $ 99.75
    Boy's Soccer        $ 2,034.47    $ ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here