Disco Fever: Spreadsheet Specification
Setting up disco costs spreadsheet
Follow these instructions to set up the disco costs spreadsheet.
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 for £1.50 each.
| 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 |
| 40 | 60.00 | 50.00 | 28.00 | 78.00 | -18.00 |
| 50 | 75.00 | 50.00 | 35.00 | 85.00 | -10.00 |
| 60 | 90.00 | 50.00 | 42.00 | 92.00 | -2.00 |
| 70 | 105.00 | 50.00 | 49.00 | 99.00 | 6.00 |
| 80 | 120.00 | 50.00 | 56.00 | 106.00 | 14.00 |
| 90 | 135.00 | 50.00 | 63.00 | 113.00 | 22.00 |
| 100 | 150.00 | 50.00 | 70.00 | 120.00 | 30.00 |
| 110 | 165.00 | 50.00 | 77.00 | 127.00 | 38.00 |
| 120 | 180.00 | 50.00 | 84.00 | 134.00 | 46.00 |
| 130 | 195.00 | 50.00 | 91.00 | 141.00 | 54.00 |
| 140 | 210.00 | 50.00 | 98.00 | 148.00 | 62.00 |
| 150 | 225.00 | 50.00 | 105.00 | 155.00 | 70.00 |
| 160 | 240.00 | 50.00 | 112.00 | 162.00 | 78.00 |
(1) The headings in rows 1 and 2 are headings, type them in.
(2) Column A lists possible numbers of tickets sold.
Either fill it in using your spreadsheets 'data-fill' facility.
Or start with 0 in cell A4, put the formula A4 + 10 in cell A5 and copy this formula down the column.
(3) Put the value 50.00 into column C using the copy facility.
(4) Put formulas into the remaining columns so that
- column B = column A x 1.50
- column D = column A x 0.70
- column E = column C + column D
- column F = column B - column E