Fireworks Spreadsheet - Best Value

Name of Box Number of Fireworks Cost of Box Cost per fireworkKrypton - Selection Box 12 £9.99Blazing Star - Selection Box 14 £15.99Blast Zone - Selection Box 23 £29.99Little Big - 5 Rockets 5 £5.99Symphony - Selection Box 40 £99.99

Best Value:

Average Cost of Firework:Median Value:

Fireworks Spreadsheet - Rocket Heights Graph

Rocket Name 1st Flight 2nd Flight 3rd Flight Average HeightEcho Bomb 48 52 37Heat Seeker 44 36 53Mega 32 34 40Pro Rocket 53 55 38Sky Storm 47 47 41Space Blaster 38 37 39

Fireworks Spreadsheet - Party Time My Budget:

Food Cost Each Sell Each Profit Each Number Sold My ProfitPlain Burger £0.25 £0.50Cheese Burger £0.35 £0.75Pasty £0.49 £1.00Sausage Roll £0.45 £0.99Pork Roll £0.85 £1.50Lemonade £0.15 £0.30Squash £0.08 £0.20Coke £0.32 £0.75

Total ProfitI spent

Profit/Loss

£75