• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month
Page
1. 1
1
2. 2
2
3. 3
3
4. 4
4

Extracts from this document...

Introduction

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!

Analysis

I will need to consider:

• Number of seats.
• Price per seat.
• Catering.
• Fee of the bands.
• Cleaners.
• Sound team.
• Manufacture of the stage.
• 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

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.

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

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

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