In: Accounting
se the following spreadsheet to calculate the March year-to-date (YTD) RevPAR (G4).
A |
B |
C |
D |
E |
F |
G |
|
Year 2013 |
Rooms available |
Rooms sold |
Revenue |
Occupancy (%) |
ADR |
RevPAR |
|
1 |
Jan |
4,650 |
2,883 |
374,790 |
|||
2 |
Feb |
4,200 |
2,394 |
304,038 |
|||
3 |
Mar |
4,650 |
3,255 |
462,210 |
|||
4 |
Mar YTD |
A | B | C | D | E | F | G | ||
Year 2013 | Rooms available | Rooms sold | Revenue | Occupancy (%) | ADR | RevPAR | ||
(Supply) | (Demand) | |||||||
1 | Jan | 4,650 | 2,883 | 374,790 | ||||
2 | Feb | 4,200 | 2,394 | 304,038 | ||||
3 | Mar | 4,650 | 3,255 | 462,210 | ||||
4 | Mar YTD | 13,500 | 8,532 | 1,141,038 | ||||
1 | March YTD occupancy % | 63.20% | ||||||
(Demand / Supply) | ||||||||
(8,532 / 13,500) | ||||||||
2 | March YTD ADR | 133.74 | ||||||
(Revenue / Demand) | ||||||||
(1,141,038 / 8,532) | ||||||||
3 | March RevPAR | 84.52 | ||||||
(Revenue / Supply) | ||||||||
(1,141,038 / 13,500) | ||||||||