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