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

  

Answers


Andrew
Please access the attached answer file.
Andreaz answered the question on January 4, 2018 at 20:25

Next: 1.Identify 11 parts of speech in the following sentence; The company eventually refused to compesate the drunken driver for his injuries.
Previous: State the difference between the work of the John the Baptist and that of Jesus Christ

View More Computer Studies Questions and Answers | Return to Questions Index


Exams With Marking Schemes

Related Questions