Groups - Group Profile Formulas

Follow

In this article you can find formulas and explanations which will help you to understand how Group Profile header is formed.

Group Header

1. Reservations:  The number of reservations of any status minus reservations with “cancelled” status, combined from all Definite Blocks in the Group. Plus number of reservations of any status in the Group Profile that don’t belong to any allotment block minus reservations with “cancelled” status in the Group Profile that don’t belong to any allotment block.

“Confirmation pending” status is included in the calculations and treated the same way as “Confirmed”

2. Guests: number of Guests (“Guest” field on the reservation) from all Reservations that are listed in the “Reservations” field above.

3. Nights Booked: number of Nights (“Nights” field on the reservation) multiplied by number of Rooms in the reservation, from all Reservations that are listed in the “Reservations” field above

4. Nights Available: number of nights still available to be sold from the allotment blocks, combined from all Definite Blocks in the Group.

5. ADR: “Revenue” / (“Nights Booked” + “Nights Available”)

6. Room Revenue:  The sum of daily room rate from each allotted room in the allotment block, combined from all Definite Allotment Blocks in the Group Plus sum of daily room rate from each Reservation of any status in the Group Profile that don’t belong to any allotment block minus sum of daily room rate from reservations with “cancelled” status in the Group Profile that don’t belong to any allotment block.

Equals: sum of room rate for all Reservations that are listed in the “Reservations” field above + sum of room rate for all available rooms that are listed in the “Nights Available” field above.

Have more questions? Contact Support

Comments

Powered by Zendesk