Scribd
Upload
19 views3 pages

Room Charges

Uploaded by

jymoohmwas4
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
19 views3 pages

Room Charges

Uploaded by

jymoohmwas4
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

SERVICE COST

PER DAY
Single(S) 1500
Double(D) 2800
Vip(V) 3200
Fridge(F) 300

Room Fridge Fridge


Room Id Guest ID Days Status Availability Room Charges Charges Total Charges
363 RM001 3D Yes 8,400 XDR 300 XDR 8,700 XDR
103 RM002 1D Yes 2,800 XDR 300 XDR 3,100 XDR
368 RM003 1S no 1,500 XDR 0 XDR 1,500 XDR
332 RM004 4D No 11,200 XDR 0 XDR 11,200 XDR
370 RM005 5D Yes 14,000 XDR 300 XDR 14,300 XDR
102 RM006 1S No 1,500 XDR 0 XDR 1,500 XDR
383 RM007 4D Yes 11,200 XDR 300 XDR 11,500 XDR
233 RM008 3D Yes 8,400 XDR 300 XDR 8,700 XDR
325 RM009 3V Yes 9,600 XDR 300 XDR 9,900 XDR
364 RM010 1V Yes 3,200 XDR 300 XDR 3,500 XDR
114 RM011 1D Yes 2,800 XDR 300 XDR 3,100 XDR
174 RM012 4S No 6,000 XDR 0 XDR 6,000 XDR
330 RM013 5D Yes 14,000 XDR 300 XDR 14,300 XDR
147 RM014 2D Yes 5,600 XDR 300 XDR 5,900 XDR
SERVICE COST
PER DAY
368 RM003 1S no 1,500 - 1,500
102 RM006 1S No 1,500 - 1,500
174 RM012 4S No 6,000 - 6,000

Single Room
7,000
6,000

Revenue in Ksh
5,000
4,000
3,000
2,000
- -
1,000 1,500 1,50
-
1
GuestID

Column F Colum
Single Room Revenue

6,000

- -
1,500 1,500

1 2 3
GuestID

Column F Column G

You might also like