The Demand calendar report in TravelLine WebPMS allows you to quickly assess the hotel occupancy both in numbers and in percent.
For example, the Demand calendar report will help to find out what periods in the past peaked in occupancy and during which ones the occupancy was lower. Based on this data, you can fix the hotel’s pricing strategy to increase the revenue.
Let’s study the performance of a test hotel.
How to use the report
For example, to see the seasonal changes in occupancy, look at the percentage of occupied rooms on July 1 for the last three years.
1. Generate three reports for the last three years: 2019, 2020, and 2021.
In the “Year” filter, select the year you need.
In the “Snapshot date” field, select July 1 of the year you selected in the “Year” filter.
In the “Data” filter, select “Occupied rooms”.
Then, click on the “Apply filter” button.
To download the report on the desktop, click on the “Export to XLS” button.
As a result, we get three reports: for 2019*, 2020**, and 2021***.
* For the year 2019, we selected Year: 2019; snapshot date: July 1, 2019; Data: Occupied rooms (%); Room type: all.
** For the year 2020, we selected Year: 2020; snapshot date: July 1, 2020; Data: Occupied rooms (%); Room type: all.
*** For the year 2021, we selected Year: 2021; snapshot date: July 1, 2021; Data: Occupied rooms (%); Room type: all.
Highlighted numbers stand for the occupancy percentages:
Number in green — the minimum occupancy rate
Number in yellow — the maximum occupancy rate
The higher the number the closer is its colour to yellow. As the number becomes closer to zero, its colour becomes brighter until it is green. If you selected “Occupied rooms” for the “Data” setting, the higher the occupancy, the closer the colour is to bright yellow.
2. Let’s have a look at the data on screenshots.
Before the pandemic, the months of the highest occupancy were April and May. In the post-pandemic year, they are January, May, June, and November. We see the highest occupancy of the year 2021 on January 1, 2021. In the year 2020, it is January 27, 2020.
In 2021, the occupancy in November has gone up compared to the pre-pandemic 2019. This means that the hotel might have introduced a new rate plan or a special offer.
In 2019, April has been one of the peak months, but in April 2021, the occupancy is much lower.
Occupancy is always low in December.
Based on the data above, we can draw the following conclusions:
Based on the peak occupancy dates in 2021, the hotel can raise prices in January and June.
The hotel needs to find out the market situation for April 2021. A new hotel might have opened nearby or competitor hotels lowered their rates.
Maybe, it is time to run a special offer in December to drive more bookings.
To fix the pricing strategy we recommend implementing dynamic pricing and monitoring competitors’ rates in TravelLine Rate Shopper |
What data are there in the report
Vacant rooms (pcs) = the total number of rooms - the number of occupied rooms
Vacant rooms (%) = (the total number of rooms - the number of occupied rooms)* 100%.
Occupied rooms (pcs) = the number of occupied rooms
Occupied rooms (%) = (the number of occupied rooms/ the total number of rooms)* 100%.
Room types — you can generate the report both on the hotel occupancy in general and on specific room types.
For the “Snapshot date” filed, by default, there is the current date. You can pick any date in the past.