Use the spreadsheet below to answer the following question regarding the methodology used to calculate KPIs for a competitive set. A B C D E F G 1 Property Date Supply Demand Revenue Occupancy ADR RevPAR 2 1111 May 4,650 3,348 525,636 3 2222 May 5,642 3,837 633,105 4 3333 May 5,425 3,961 728,824 5 4444 May 6,045 4,655 721,525 6 Comp Set Total for May The competitive set RevPAR (G6) for May is $119.74 $119.89 $155.16 $165.12 another question will save this response