Scribd
Upload
29 views4 pages

Room Occupancy

The document contains daily room sales data for a hotel over multiple months. It includes metrics like rooms sold, room inventory, total hotel sales, and rooms leased. The data is broken down by date and month and contains counts for various sales figures each day of the months shown.

Uploaded by

Carlo Cariaso
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
29 views4 pages

Room Occupancy

The document contains daily room sales data for a hotel over multiple months. It includes metrics like rooms sold, room inventory, total hotel sales, and rooms leased. The data is broken down by date and month and contains counts for various sales figures each day of the months shown.

Uploaded by

Carlo Cariaso
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
You are on page 1/ 4

Pesos Units

Date Room Sales Room Leased Sales Total Hotel Sales Room Inventory Rooms Sold
Jan-20 843,230.94 - 843,230.94 682 484
Feb-20 669,517.54 - 669,517.54 638 327
Mar-20 210,295.18 - 210,295.18 682 123
Apr-20 - - - 660
May-20 4,320.30 4,320.30 682
Jun-20 62,994.12 53,283.30 116,277.42 660 52
Jul-20 198,743.87 50,403.13 249,147.00 682 146
Aug-20 139,485.75 50,403.13 189,888.88 682 100
Sep-20 200,830.41 9,360.58 210,190.99 660 124
Oct-20 268,365.13 13,680.00 282,045.13 682 192
Nov-20 301,426.15 8,640.00 310,066.15 660 181
Dec-20 440,054.44 - 440,054.44 682 244
3,334,943.54 190,090.44 3,525,033.98 8052 1973

P25,000 Monthly rate of Room Leased (Vat inclusive) Note:


P22,321.43 Monthly rate of Room Leased (Vat Exclusive)
P720.05 Daily rate of Room Leased (Vat Exclusive)
Units
Rooms Leased Total Room Sold & Leased Occupancy rate Ave. Room Rate
484 70.97% 1,742.21
327 51.25% 2,047.45
123 18.04% 1,709.72
0.00%
6 6 0.88% 720.05
74 126 19.09% 922.84
70 216 31.67% 1,153.46
70 170 24.93% 1,116.99
13 137 20.76% 1,534.24
19 211 30.94% 1,336.71
12 193 29.24% 1,606.56
244 35.78% 1,803.50
264 2237

P25,000 Monthly rate of Room Leased (Vat inclusive)


P22,321.43 Monthly rate of Room Leased (Vat Exclusive)
P720.05 Daily rate of Room Leased (Vat Exclusive)

Total
# of Units Sold
Day Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20
1 16 20 9 1
2 16 6 3 1
3 22 3 9 1
4 21 9 6 1
5 15 10 6 1
6 12 8 6 1
7 11 11 22 1
8 9 22 13 2
9 11 8 5 3
10 14 7 7 4
11 22 9 12 4
12 13 8 3 4
13 14 12 6 No Sales 4
14 22 16 7 4
15 22 22 1 4
16 5 17 8 No Sales 4
17 10 4 5
18 20 5 5
19 11 5 5
20 17 11 4
21 16 10 4
22 21 9 5
23 16 22 5
24 21 15 No Sales 6
25 22 10 8
26 15 8 1 9
27 17 11 1 13
28 15 9 1 7
29 13 20 1 7
30 20 - 1 3
31 5 - 1 -
484 327 123 0 6 126
Jul-20 Aug-20 Sep-20
5 9 2
6 10 2
10 6 3
9 3 6
5 7 8
4 5 1
6 7 6
8 9 1
5 8 1
9 3 3
10 2 3
3 3 10
3 4 11
5 5 3
7 4 1
6 3 6
4 3 6
15 5 8
14 3 9
7 5 7
4 2 2
11 9 3
7 2 4
7 2 2
12 4 7
5 3 9
4 9 4
7 7 2
6 12 5
5 9 2
7 7 -
216 170 137

You might also like