Assume that you are Front Office Manager running a 4-star 12…

Assume that you are Front Office Manager running a 4-star 124-room hotel. GM has assigned you to create a spreadsheet that he/she can review and send it for review by owners for a yearly P&L meeting. By using a MS Excel spreadsheet, perform horizontal analysis on the following items Rooms Occupied, Occupancy, ADR, & RevPAR and summarize the results. ACT MTD PREV MTD Rooms Available 45,260 45,260 Rooms Occupied 39,376 37,566 Occupancy ADR $336.51 $290.95 RevPAR $275.15 $238.88