This is the sum of all the band fees.
This is the sum of the cost of the stage props
This is the amount of tickets sold times the price per ticket, the amount of tickets sold times the estimated amount spent on food per person, the amount of ticket sold times the estimated amount spent on merchandise, and all the amounts added up to give a total income table.
This uses table references to show the wages of all the staff, the costs of the stadium, etc.
This subtracts the total expenditure from the total income to show whether there is a profit, loss or break even.
Implementations
WHAT IF… No one buys a ticket?
I changed the inputs to:
- No ticket sales
- No Merchandise Sales
- No food sales
This changed my profit to:
WHAT IF… Linkin Park Don’t turn up, so 300 people don’t buy tickets?
I changed the inputs to:
- -300 tickets sold
- Linkin Park Costing £0.00 (They didn’t turn up)
- This changed My profit to:
This is only a slight loss, because the loss in ticket
sales is counteracted by not having to pay one of the bands.
Evaluation
I think I handled this task very well, and I think my model is very useful, because anyone can use it, and every change links into another, so the slightest change can be seen easily on the actual sheet. I tried to use many different techniques to increase the efficiency of my model.
Sam May 10HS
