Availability and Overbooking Examples

In the following examples for room availability and overbooking, we will be looking only at the Detailed Availability screen. However, the Control Panel and Maximum Availability screens will also reflect the activities described. Also, each example will show only one room type (XX) since that will be the only room type for which we will add an overbooking.

As a basis for comparison, we will look at a day for which no reservations have been made. We will also look at different scenarios with regards to the overbooking levels and how the Detailed Availability screen will change.

For the following examples, we will be using a hotel with 192 rooms. Refer to the following table for the hotel's room data:

Number of Rooms in Hotel: 192

Room Class	No. of Rooms	Room Types (no. of rooms)
HOTEL	127	JS (5), K (46), X (5), XX (71)
RES	65	S (5), MOF (3), MOM (20), MOT (2), BIM (13), TDT (17), TDS (5)
PSE	0	(only PM rooms)
MIGRATE	0	(only PM rooms)

Example 1: No overbooking levels have been set.

CTRL + F2, Room Class: none, Include Overbooking: N, no overbooking levels set

Total	RC Total	Room Type XX
192	192	71

CTRL + F2, Room Class: HOTEL, Include Overbooking: N, no overbooking levels set

Total	RC Total	Room Type XX
192	127	71

Example 2: Adding a room type overbooking level of 5 rooms for room type XX.

1. No room class filter

   CTRL + F2, Room Class: none, Include Overbooking: N, room type overbooking on XX(5)

   Total	RC Total	Room Type XX
   192	192	71

   CTRL + F2, Room Class: none, Include Overbooking: Y, room type overbooking on XX(5)

   Total	RC Total	Room Type XX
   192	192	76

   The number for room type XX increases by 5, but the RC Total does not change.

2. Adding a room class filter on room class HOTEL

   CTRL + F2, Room Class: HOTEL, Include Overbooking: N, room type overbooking on XX(5)

   Total	RC Total	Room Type XX
   192	127	71

   CTRL + F2, Room Class: HOTEL, Include Overbooking: Y, room type overbooking on XX(5)

   Total	RC Total	Room Type XX
   192	132	76

   The number for room type XX increases by 5, but RC Total also changes!

3. Adding a room class filter on all room classes

   CTRL + F2, Room Class: HOTEL, RES, PSE, MIGRATE, Include Overbooking: N, room type overbooking on XX(5)

   Total	RC Total	Room Type XX
   192	192	71

   CTRL + F2, Room Class: HOTEL, RES, PSE, MIGRATE, Include Overbooking: Y, room type overbooking on XX(5)

   Total	RC Total	Room Type XX
   192	197	76

The number for room type XX increases by 5, but RC Total also changes! What may be confusing here is that the room class total is different from not having any room class filter at all.

The reason for this is based on the fact that a room type level overbooking does not increase the house level overbooking. In our example, the system will allow us to book 76 rooms of room type XX, but we will have to borrow these rooms from some other room type. If we try to sell more than 192 rooms, the system will not allow it (unless the user has permission to overwrite the overbooking levels, of course).

When we look at the room class level, the system will allow us to book 132 rooms of room class HOTEL. That is because a reservation is not made against a room class, rather, it is made against a room type. Therefore, to calculate the room class totals we have to consider the room type overbooking levels. When using a filter on many or all room classes, the same rules still apply and we will just add the totals for all room classes.

Example 3: Adding a room class overbooking level of 3 rooms for room class HOTEL; the overbooking on room type XX stays in place.

1. No room class filter

   CTRL + F2, Room Class: none, Include Overbooking: N, room type overbooking on XX(5), room class overbooking on HOTEL(3)

   Total	RC Total	Room Type XX
   192	192	71

   CTRL + F2, Room Class: none, Include Overbooking: Y, room type overbooking on XX(5), room class overbooking on HOTEL(3)

   Total	RC Total	Room Type XX
   192	192	76

   The number for room type XX increases by 5, but the RC Total does not change (same as in example 2 - A)

2. Adding a room class filter on room class HOTEL

   CTRL + F2, Room Class: HOTEL, Include Overbooking: N, room type overbooking on XX(5), room class overbooking on HOTEL(3)

   Total	RC Total	Room Type XX
   192	127	71

   CTRL + F2, Room Class: HOTEL, Include Overbooking: Y, room type overbooking on XX(5), room class overbooking on HOTEL(3)

   Total	RC Total	Room Type XX
   192	130	76

   The number for room type XX increases by 5; the RC Total only increased by 3 because the room class overbooking level is lower than the room type overbooking level.

3. Adding a room class filter on all room classes

   CTRL + F2, Room Class: HOTEL, RES, PSE, MIGRATE, Include Overbooking: N, room type overbooking on XX(5), room class overbooking on HOTEL(3)

   Total	RC Total	Room Type XX
   192	192	71

   CTRL + F2, Room Class: HOTEL, RES, PSE, MIGRATE, Include Overbooking: Y, room type overbooking on XX(5), room class overbooking on HOTEL(3)

Total	RC Total	Room Type XX
192	195	76

The number for room type XX increases by 5; again, the room class level only increases by 3. In this scenario, it is easier to understand why the RC Total is higher than the Total because there is an actual overbooking level on a room class.

Example 4: Adding a house overbooking level of 1 room, the other overbooking levels stay in place.

1. No room class filter

   CTRL + F2, Room Class: none, Include Overbooking: N, room type overbooking on XX(5), room class overbooking on HOTEL(3), house overbooking (1)

   Total	RC Total	Room Type XX
   192	192	71

   CTRL + F2, Room Class: none, Include Overbooking: Y, room type overbooking on XX(5), room class overbooking on HOTEL(3), house overbooking (1)

   Total	RC Total	Room Type XX
   193	193	76

   The number for room type XX increases by 5, but the RC Total does not change (same as in examples 2 - A and 3 - A).

2. Adding a room class filter on room class HOTEL

   CTRL + F2, Room Class: HOTEL, Include Overbooking: N, room type overbooking on XX(5), room class overbooking on HOTEL(3), house overbooking (1)

   Total	RC Total	Room Type XX
   192	127	71

   CTRL + F2, Room Class: HOTEL, Include Overbooking: Y, room type overbooking on XX(5), room class overbooking on HOTEL(3), house overbooking (1)

   Total	RC Total	Room Type XX
   193	130	76

   The number for room type XX increases by 5; the RC Total only increased by 3 because of the room class overbooking level, which is lower than the room type overbooking level; the Total increases by 1 because it looks only at the house overbooking level.

3. Adding a room class filter on all room classes

   CTRL + F2, Room Class: HOTEL, RES, PSE, MIGRATE, Include Overbooking: N, room type overbooking on XX(5), room class overbooking on HOTEL(3), house overbooking (1)

   Total	RC Total	Room Type XX
   192	192	71

   CTRL + F2, Room Class: HOTEL, RES, PSE, MIGRATE, Include Overbooking: Y, room type overbooking on XX(5), room class overbooking on HOTEL(3), house overbooking (1)

   Total	RC Total	Room Type XX
   193	195	76

The number for room type XX increases by 5; again, the room class level only increases by 3; Total increases by 1.

Rules on How the Total Columns are Calculated

When the Include Overbooking check box is selected, the following rules will apply to the way the Total columns are calculated:

Total

• Will only include house-level overbookings
• Will ignore room class and room type overbookings

RC Total

• If no room class filter is set, then the room class total will be the same as the total.
• If a filter on room classes is set, then the RC Total will look at both room class and room type level overbookings.
• If a room class level overbooking exists, then the room type levels will be ignored.
• If no room class level overbookings exist, then the room type level overbookings for the room class will be added together.