Occupancy %, ADR and RevPAR Excel Calculation
Is it better to sell every room at a cheap rate, or raise rates and leave some rooms empty? ADR (Average Daily Rate) vs. Occupancy.

-- Of course the change in number of rooms sold with the same ADR will increase the total hotel Revenue and then RevPAR will increase. For the mentioned scenario, if the number of rooms sold increased and ADR dropped to be the same total Revenue, then RevPAR will not change. RevPAR changes when the change occur basically to the Total Revenue, then we divide it by the number of hotel rooms inventory.


RevPAR is used to assess a hotel's ability to fill its available rooms at an average rate. If a property's RevPAR increases, that means the average room rate or occupancy rate is increasing. RevPAR is important because it helps hoteliers measure the overall success of their hotel.

Lets see how can we calculate the main 3 Hotels industry KPIs
#Hotel_Occupancy_Calculation
#Hotel_ADR_Calculation
#RevPAR_Calculation

свернуть