Disco Fever: Student Worksheet
Diane and John are organising a disco party at school to raise money for charity. It costs £50 to hire a DJ and disco. Refreshments will be provided at an average cost of 70p per person. They intend to sell tickets at £1.50 each.
(1) Start up your spreadsheet package and make a spreadsheet to show the takings, costs and profits for a range of possible sales figures. If you want some help with this go to the spreadsheet specification
| Tickets sold | Takings | Disco hire | Food cost | Total cost | Profit |
|---|---|---|---|---|---|
| 0 | 0.00 | 50.00 | 0.00 | 50.00 | -50.00 |
| 10 | 15.00 | 50.00 | 7.00 | 57.00 | -42.00 |
| 20 | 30.00 | 50.00 | 14.00 | 64.00 | -34.00 |
| 30 | 45.00 | 50.00 | 21.00 | 71.00 | -26.00 |
| and so on |
(2) Use your spreadsheet to find out how many tickets they must sell to make:
- £30.00 profit
- £70 profit.
(3) Alter your spreadsheet to find how many tickets they must sell to make a £50 profit. Replace the values in the 'Tickets sold' column to make a close-up of values between 120 and 130.
| Tickets sold | Takings | Disco hire | Food cost | Total cost | Profit |
|---|---|---|---|---|---|
| 120 | 180.00 | 50.00 | 84.00 | 134.00 | 46.00 |
| 121 | 181.50 | 50.00 | 84.70 | 134.70 | 4680 |
| and so on, up to | |||||
| 130 | 195.00 | 50.00 | 91.00 | 141.00 | 54.00 |
(4) How many tickets must they sell to break even? That means they just cover their costs and avoid losing money.
Alter your spreadsheet to make a close -up showing between 60 and 70 tickets sold.
(5) What if prices go up? See what happens if disco hire increases to £55 and the cost of refreshments changes to 85p.
- How will profits change?
- What is the new break-even point?
- What new price should they charge for tickets to restore the profits figures to what they were like before?