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) | ||||||||