• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Modelling - Using a spreadsheet.

Extracts from this document...


Modelling – Using a spreadsheet

The Subject

Organising a concert – I am going to use a spreadsheet to create a working model for the organisation of a rock concert. This concert will be called “Shredfest”. It will be open to anyone who is able to get a ticket. Backstage passes are not sold. Children under 13 will need to be accompanied by an adult. It is not recommended that children under the age of 8 attend due to excessive noise and unruly behaviour!image00.pngimage01.pngimage00.png


I will need to consider:

  • Number of seats.
  • Price per seat.
  • Catering.
  • Fee of the bands.
  • Cleaners.
  • Sound team.
  • Manufacture of the stage.
  • Advertising and promotion.
  • Fee of renting the stadium.


Amount of tickets to be sold


Price per ticket


Estimated Food total per person


Estimated merchandise purchases per person


Band fees



Linkin Park


Blink 182


Static X




The Darkness


Sum 41


Total Fee


This is the sum of all the band fees.

Stage manufacture

Giant Shredfest Logo


Giant Electric guitar (inflatable)


Beach balls (200)


Stage supports


Total stage cost


This is the sum of the cost of the stage props

Caterer's Fee


Cleaning Team Wages


Sound Team Wages


Security Staff Wages


Paramedic Team Wages


Stadium fee


...read more.


Ticket Sales


Food sales


Merchandise Sales




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.


Stadium Rental fee


Fee of bands


Manufacture of Stage


Sound team wages


Cleaning Staff Wages


Caterers fee


Security staff Wages


Paramedic team Wages




This uses table references to show the wages of all the staff, the costs of the stadium, etc.

...read more.



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:

Profit - - - - - - - - - - ->


This is only a slight loss, because the loss in ticket

sales is counteracted by not having to pay one of the bands.


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

...read more.

This student written piece of work is one of many that can be found in our GCSE T-Total section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE T-Total essays

  1. I am going to investigate how changing the number of tiles at the centre ...

    Each pattern number is counted as N and the squares in that outer most border is counted as B. These numbers change as each outer border gets bigger. Every pattern number with only centre tiles has no border, so it has not been included in the sequence to make my formulae.

  2. Compile a report which will look at, and assess the performance of sales generated ...

    The average of total sales generated by the outlets is �635,440. The lowest total sales generated by an outlet is �449,000. up to 25% of the shops generated total sales of �559,000, whilst 50% generated total sales of up to �641,000.

  1. For this task we were required to create a model that can be used ...

    Multiplying the first amount of units up to the split value, and then adding this to the total of the cost of the units after the split value can work out the total for the units. This gives you the total cost for the units.

  2. Pay Role Model.

    I changed fothergill's hours from 35 to 48 hours per week so this will increase his net pay Then for the fourth change, things will also change because "C. Clayton's" "Total hours" worked changed it went up from 35 to 50 so her wage slip is going to be more, so the "Total wage bill" will be more.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work