Part 1: On the first tab raw subject data, there is data in Columns include STR Number, Month Date, Supply, Demand, and Revenue. The second tab has Subject Property Daily Data. The third tab has Subject and Comp Set Monthly Data. Using the formulas provided in the lecture notes this week, on the fourth tab named Appl Exercise Subject& Comp Set, calculate ADR, Occupancy, and RevPAR for both subject and comp set. You can copy the formulas down in each column of each KPI.

Part 2: In tab 3 and 4, after you have calculated the KPIs of ADR, Occupancy, RevPAR then you will add formulas for percent changes. You will have to compare the This Year value to the last Year value which appears 12 row above. Note: You will not be able to derive these metrics for the first year of data.

Part 3: Determine the index values.

Part 4: Compute index values percent change.