• 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...

Introduction

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

Analysis

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.

Design

Amount of tickets to be sold

10000

Price per ticket

30

Estimated Food total per person

25

Estimated merchandise purchases per person

35

Band fees

Metallica

40000

Linkin Park

15000

Blink 182

15000

Static X

10000

Spineshank

7000

The Darkness

50000

Sum 41

25000

Total Fee

=SUM(B10:B16)

This is the sum of all the band fees.

Stage manufacture

Giant Shredfest Logo

1500

Giant Electric guitar (inflatable)

300

Beach balls (200)

600

Stage supports

5000

Total stage cost

=SUM(B20:B23)

This is the sum of the cost of the stage props

Caterer's Fee

15000

Cleaning Team Wages

1000

Sound Team Wages

4000

Security Staff Wages

5000

Paramedic Team Wages

4000

Stadium fee

50000

...read more.

Middle

Ticket Sales

=B2*B3

Food sales

=B2*B4

Merchandise Sales

=B2*B5

Total

=SUM(E3:E5)

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.

Expenditure

Stadium Rental fee

=B31

Fee of bands

=B17

Manufacture of Stage

=B24

Sound team wages

=B28

Cleaning Staff Wages

=B27

Caterers fee

=B26

Security staff Wages

=B29

Paramedic team Wages

=B30

Total

=SUM(H3:H10)

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

...read more.

Conclusion

£248,400.00

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 - - - - - - - - - - ->

£639,600.00

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

...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. 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. 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. Pay Role Model.

    Now I will predict another change in the data, I will change the same data that I have already changed in the previous objectives. I predict that if I double the hours C. Clayton, works she will get 50% more salary.

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

    + 3 = 2(49) + 45 = 143 So I expect that pattern number 7 will have 143 tiles. I have drawn pattern 7 and counted 143 tiles, this confirms that my formula is correct. For four centre tiles Table 1 Pattern: N 1 2 3 4 5 Border Tiles:

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