Question: Use the following spreadsheet to answer question 7 9: A B C D E F G H I 1 Index Numbers 2 This Year Last
Use the following spreadsheet to answer question 7 9:
|
|
| A | B | C | D | E | F | G | H | I |
| 1 |
| Index Numbers | ||||||||
| 2 |
| This Year | Last Year | Percent Change | ||||||
| 3 |
| Occupancy | ADR | RevPAR | Occupancy | ADR | RevPAR | Occupancy | ADR | RevPAR |
| 4 | 10-May | 122.1 | 119.1 | 145.4 | 99.8 | 124.6 | 124.4 |
|
|
|
- The year to year occupancy index percent change for May (G4) is __________________
- The year to year ADR index percent change for May (H4) is ______________________
- The year to year RevPAR index percent change for May (I4) _____________________
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
