Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Or go directly to:

Class notes Holiday assignments Topical questions Other resources

The following tourists were on holiday in Kenya and during their stay they enjoyed different services in different hotels as shown:? Cathie Timpson stays at Casablanca...

The following tourists were on holiday in Kenya and during their stay they enjoyed different services in different hotels as shown:
? Cathie Timpson stays at Casablanca for 5 days and enjoys 2 Massage sessions at 1,400/- per session.
? Sue Carlisle stays at Hilton Hotel for 10 days and enjoys 6 facials worth 2,000/- per session
? Amina Abdul stays at Karen Blixen for 22 days and enjoys 10 Gym classes at 2,500 per class.
? Josh Weru stays at Ole Sereni for 6 days and enjoys 1 golf class at 6,000/- per class.
? Henry White stays at Mvuli for 12 days and enjoys 3 swimming sessions at 1,500/- per session.
? Charlie Long stays at Karen Country Club for 2 days and does not indulge in any service.
? Priscilla Saunders stays at West Royale for 14 days and takes 7 Internet sessions at 1,000/- per session.
? Jane Law stays at House of Waine for 6 days and takes 2 Yoga classes at 3,000/- per class.

The following are day rates charged at the different hotels:
Casablanca 3,200/-
Hilton Hotel 4,000/-
Karen Blixen 2,500/-
Ole Sereni 7,000/-
Mvuli 5,200/-
Karen Country Club 6,500/-
West Royale 9,750/-
House of Waine 4,000/-

*Kindly note that a 20% discount is allocated to guests whose final bill is worth more than 50,000/-

Create an Excel spreadsheet to capture the following:
1) Names of the Tourists visiting.
2) Day Rates and days spent in each hotel by each tourist.
3) Total amount of Day Rates (Insert proper formulae for this)
4) Types of Services incurred by each tourist in each hotel
5) Rates at which each Service is charged at different hotels
6) Total Amount of Services taken by each tourist (Insert proper formulae for this)
7) Total Amount of Services and Day Rates (Insert proper formulae for this)
8) Discounted Amount applied to relevant tourists
9) Overall Amount charged
10) Sort the Tourist names in Alphabetical order.
11) A Pie Chart reflecting on the Final Total Bill of each tourist