How to do the following questions?

1. Downtown Los Angeles has three hotels with the following performance statistics on one weekend. Hotel 1: Total 400 rooms Occupancy RevPAR Sold Room nights ADR 350 $200.0 300 $190.0 Friday Saturday Weekend Average Weekend Index Hotel 2: Total 300 rooms Occupancy RevPAR Sold Room nights 250 200 ADR $210.0 $180.0 Friday Saturday Weekend Average Weekend Index Hotel 3: Total 250 rooms RevPAR Sold Room nights 200 180 ADR Occupancy $220.0 $170.0 Friday Saturday Weekend Average Weekend Index ADR Occupancy RevPAR Total Weekend Average of 3 hotels A. Please calculate the averages and indices in the yellow cells. The indices should be based on the weekend average in the area as the comp set. B. Which hotel had the best performance for that weekend? Why