Five hotels given in Table 1 Competitive Set Data operate in the same market. On an Excel spreadsheet, compute the three indices' figures - MPI, RGI AND ARI, for each hotel for Quarter 1 of 2020. Data given is for 90 days in Q1. Table 1 Competitive Set Data Quarter 1 - January to March 2020 (days) 90 Hotel Name Alpha Backwaters Citadel Downtown Excellence Total Available rooms 13,500 18,000 22,500 16,200 10,800 Room Revenue $1,800,000.00 $2,700,000.00 $1,750,000.00 Rooms Sold 9,900 10,800 16,200 9,000 9,180 Occupancy percentage 60.0% 55.6% ADR $187.50 RevPAR $100.00 MPI RGI ARI QUESTION 2. STRATEGIC PLANNING IN REVENUE MANAGEMENT Assignment Introduction Noone, Canina