In
this task we will use formulae to calculate expenses incurred throughout
the course of the season.
Insert formulae
to calculate travel costs for every away game played in a season.
No. of
Away League Matches
No. of Away
Cup Matches
No. of Away
European Matches
Total
Travel Costs
Enter the number of players of each category for Option 1
Enter
a formula to calculate the total monthly salary
Multiply
this value by 12 to calculate the total annual salary
Player
Category
No of Players
A
B
C
D
E
F
Total Monthly
Salary
Total Annual
Salary
Using information
about the annual attendance for all competitions insert formulae to
calculate the stewarding costs per season.
Stewarding
Costs
Enter
the existing capacity and the New Capacity of the stadium. Note –
this is only applicable options 2, 3 and 4. Then enter a formula to
calculate the cost of expansion if each new seat costs £400
to be built.
Existing
Capacity
New Capacity
Expansion
Cost
Enter
a formula to add the four outgoing expenses of travel, security,
expansion and salaries.
