Spread sheet for trips
Coach Hire Charges (53 Seater) No of students 80
Driving time, per hour 25 Budget 100
budget per
Waiting at destination, per hour 20 day 25
Mileage, per mile first 100 miles 1.2
each mile over 100 0.9
Travelling time total travelling waiting time
Heritage Place Mileage Under 100 over 100 total mileage (mins) time (mins) total coach cost
Hampton Court P 34.1 68.2 0 68.2 0.7 1.4 3 £353.68
Buckingham Pala 19.4 38.8 0 38.8 0.6 1.3 0.5 £176.45
Windsor Castle 22.9 45.8 0 45.8 0.5 1.0 3.5 £301.59
Half Day out
Hants Mega Maze 77.9 100 55.8 155.8 1.5 2.9 3.5 £627.11
Hollywood Bowl 1.1 2.2 0 2.2 0.1 0.2 4 £175.28
Harlequin 3.1 6.2 0 6.2 0.2 0.3 3 £149.88
Fun Day out
Bird World 48.6 97.2 0 97.2 1.0 2.0 2.5 £434.95
London Aquarium 21.1 42.2 0 42.2 0.7 1.5 3 £294.61
BFI London IMAX 21.2 42.4 0 42.4 0.7 1.5 1 £215.09
Open Air
Guildford Spect 39.5 79 0 79.0 0.7 1.5 2 £342.93
Kingfisher Leis 36.7 73.4 0 73.4 0.8 1.7 3 £379.49
Kew Gardens 20.8 41.6 0 41.6 0.6 1.1 3 £276.51
entrance cost per total cost per Chosen
total entrance costs student student in budget? Trips Place why?
£510.00 £6.38 £10.80 In budget Heritage Windsor Castle it was the activity which I thought would be the most enjoyable for the students
Hants Mega
£0.00 £0.00 £2.21 In budget Half Day Maze
out of the four activities it seemd as if it would be the most entertaining as the other options
£367.50 £4.59 £8.36 In budget could be done in their own countries
London it is the second most expensive location hwoever it is the only one which doesn’t require
Fun Day Aquarium fluent english
Open Air Kew Gardens it is the cheapest and most entertaining of the possible locations
£0.00 £0.00 £7.84 In budget
total for
£440.00 £5.50 £7.69 In budget chosen trips £33.59 in budget
money
£0.00 £0.00 £1.87 In budget remaining £66.41
£900.00 £11.25 £16.69 In budget
£820.00 £10.25 £13.93 In budget
£800.00 £10.00 £12.69 In budget
£0.00 £0.00 £4.29 In budget
£0.00 £0.00 £4.74 In budget
£0.00 £0.00 £3.46 In budget