What if the booking does not fit entirely within the selected period in BedBooking Statistics?

A common situation in Statistics is that some bookings do not fit entirely within the selected period.

For example, we have a selected period from May 1 to May 31 and a reservation that lasts 14 nights from May 22 to June 5 and costs 100 euros per night. The property has 3 rooms, but there were no bookings in the period from May 1 to May 31 except for this one. The Statistics modules will then behave as follows:

  1. Total income module
    The revenue amount will include only the prices for the 10 nights starting from May 22 to May 31, or €1,000.

    Total revenue = total booking revenue for nights falling within the selected period

  2. Occupancy module
    The algorithm calculating occupancy will include 10 nights starting from May 22 to May 31. The occupancy rate for the facility from May 1 to May 31 will be 11%, as there are 30 nights for this period in which each of the 3 rooms could be rented.

    Occupancy rate = sum of the number of reservation nights falling within the selected period / (number of nights in the selected period * number of rooms)

  3. Revenue and occupancy module
    The algorithm will take into account only the booking nights falling on that point in the chart when calculating the income and occupancy at that point. For example, if a point on the chart runs from May 20 to May 22, the income at that point will be €100, as there are only 1 booking night falling on that point starting May 22. The occupancy rate will be 11%, as there are 3 nights from May 20 to May 22 for each of the available 3 rooms.

    Revenue = sum of revenue for reservation nights falling per chart point

    Occupancy = sum of booking nights per chart point / (number of nights per chart point * number of rooms)

  4. Additional data module

    - Number of reservations
    If the reservation contains at least 1 night, the start day of which is included in the selected period, the reservation is concluded for calculation.

    - Booking Window
    If the reservation contains at least 1 night whose start day includes the selected period, the reservation is included in the calculation.

    - Number of canceled reservations
    If the reservation contains at least 1 night, the start day of which is included in the selected period, the reservation is included in the calculation.

    - RevPAR
    Only prices for 10 nights starting from May 22 to May 31, or €1,000, will be used for RevPAR calculations. From May 1 to May 31 there are 30 nights. The property has 3 rooms, so theoretically the property could be rented for 90 nights during this period. The total income for these days is €1,000, so divide this amount by 90.

    RevPAR = income in the selected period / (number of rooms * number of nights in the selected period).

    With this, we know that on average, 1 room of the facility brought a profit of 11.11 euros per night.

    - ADR
    Only prices for 10 nights starting from May 22 to May 31, or €1,000, will be used for ADR calculations. The average price for 1 night of booking is 100 euros. However, for example, if there was one more reservation during the period for 2 nights from May 1 to 3 at a price of 200 euros per night, the ADR would be 116.67 euros.

    ADR = income in the selected period / sum of the number of booking nights falling within the selected period

    - Average booking length
    If a reservation contains at least 1 night whose start day falls within the selected period, the reservation is included in its entirety for the calculation.

    In the example given, the average length of the reservation would be 14 nights.

     

  5. Booking Origin module
    If the reservation includes at least 1 night, the start day of which is included in the selected period, the reservation is concluded for calculation.

  6. Income Origin Module
    Only nights of bookings that start on the days of the selected period are included in the revenue calculation.
    If the booking in the example came from Airbnb, the origin of the Airbnb income would be €1,000, or 100%.
Was this article helpful?
0 out of 1 found this helpful
Have more questions?
Submit a request