Rates by Day by Room Type by LOS
Note: Available only when the OPP_OPUS OPERA Revenue Management add on license is active.
With the activation of the Rates>Prevailing Rate by LOS application function, OPERA can create daily rate amounts per room type per length of stay based on bid prices/hurdle rates sent down by ORMS and other yield management systems.
When the Rates>Prevailing Rate by LOS application function is set to Y, the Rates>Prevailing Rate Code application setting becomes active. The prevailing rate code identified by this setting tells OPERA which rate code will hold the rate amounts (prevailing rates) created or updated based on the length of stay hurdle/bid prices from ORMS. The prevailing rates will be calculated automatically and dynamically by OPERA's Rates by Day by Room Type by LOS process. For this reason, in order for a rate code to be selected as the prevailing rate code via the Rates>Prevailing Rate Code application setting, the rate code must meet the following criteria:
Note: If the Rates>Prevailing Rate by LOS application function is set to Y, a specialized Rate Query Details screen displays the prevailing rates for the guest's requested arrival date, plus 3 days prior to and three days following the arrival date. See Prevailing Rate Query for details. Prevailing Rates can also be displayed on the ORS Sales Screen|Rate Availability Screen as the Default Display Set. See ORS Sales Screen for more information.
Each day ORMS sends hurdle rates for all room types that are "yieldable." Hurdle rates are sent for a range of Length of Stays. After calculation, the prevailing rate code will hold rate amounts per day per LOS for all room types sent from ORMS. Up to 15 other rate codes can be based on the prevailing rate code (by selecting the prevailing rate code as the Base Rate on the Rate Setup screen More tab); rate amounts for these other rate codes will be driven by the rate amounts calculated for the prevailing rate code.
The above diagram shows the major elements in the prevailing rate amount calculation process. ORMS sends daily hurdle rates to OPERA for each yieldable room type and length of stay for a date. The rounding process takes the daily hurdle rate for each room type/LOS and calculates the prevailing rate amount for the day by room type and LOS using the Rounding and Increment values for the applicable room type. The rounding and increment processing would be applicable to all room types associated with a yield category.
The prevailing rate amount calculations are made in the following manner.
The following table gives additional examples of the rounding process.
Hurdle Rate |
Initial Round Up |
Increment |
Prevailing Rate Amount |
104.25 |
4.95 |
5 |
104.95 |
107.25 |
4.95 |
5 |
109.95 |
111.25 |
4.95 |
5 |
114.95 |
125.50 |
4.95 |
5 |
129.95 |
101.02 |
0.04 |
5 |
105.04 |
101.25 |
0.04 |
5 |
105.04 |
302.50 |
20.00 |
25 |
320.00 |
321.20 |
20.00 |
25 |
345.00 |
350.00 |
20.00 |
25 |
370.00 |
The last example in the above table shows that an increment can be applied more than once, if necessary. The initial round up produces a rate amount of 320. Because this is lower than the hurdle rate, the increment (25) is added, resulting in a rate amount of 345. This is still lower than the hurdle rate so the increment is applied again, resulting in a 370 prevailing rate amount.
Hurdle rates for LOS1 through LOS7 are passed to OPERA from TLP. OPERA computes rate amounts for LOSs of up to 14 nights. The rate amounts for the extra nights are calculated by taking the hurdle amount for the 7-night LOS plus the hurdle amounts for the applicable extra number of additional nights based on the extra number of nights' applicable hurdle value, and then rounding.
Example:
Here is a hypothetical example that illustrates the prevailing rate calculation process for a DLSV room type when the guest is arriving on 11/21/06 and staying for 14 nights.
805 +89 +89 +89 +129+129+89+89 = 1508
1508 /14 = 107.71
Applying the rounding value to the 107.71 per-night rate results in 104.95.
104.95 is less than the 107.71 hurdle rate so the increment value for the room type, 5.00, is applied.
104.95 + 5 = 109.95
To enable quotes based on arrival date, LOS, and room type, rate storage for the prevailing rate code must be more extensive than for other OPERA rate codes. Amounts for stays up to 14 nights are stored. Stored rates for room type DLX for arrival dates May 15 and May 16 might be represented like this:
To view the calculated LOS rate amounts by date and room type (the prevailing rates), select the Rate Detail tab on the Rate Setup screen (Configuration>Rate Management>Rate Classifications>Rate Codes) for the prevailing rate code (the rate code defined by the application setting, Rates>Prevailing Rate Code). You may edit these rate amounts manually, but any changes made will be overwritten when ORMS sends new hurdle rates and the Rates by Day by Room Type by LOS process recalculates rate amounts. When manually entering rates here, OPERA does not take into consideration the rounding and increment values — only the number of nights. For example, if the user enters the nightly rate amount for DLX for 01.01.10 for LOS 2 as 175.00, the total amount for a 2-night stay for the noted room type and date combination would be 350.00.
A maximum of 15 rate codes may be based on the prevailing rate code. (A rate code may be based on another rate code by using the features provided on the Rate Code Setup screen More tab.) When configuring base rate functionality for a rate code, you can select the room types for which rates will be set by the base (prevailing) rate. When a new room type is added to a rate code that is based on the prevailing rate, a rate amount will not be created until the next hurdle rate update is sent from TLP.
Base rate functionality allows either a flat amount (e.g., -10.00, 12.50) or a percentage (e.g., -5%, 10%) difference from the prevailing rate amount.
Here are some examples showing how rate amounts are calculated.
LOS |
Room Type |
Prevailing Rate Code Total Stay Amount |
Rate Code Based on Prevailing Rate |
|
Total Stay Amount |
Nightly Rate Amount |
|||
LOS1 |
DLX |
105.95 |
105.95/1 nts = 105.95 |
95.36 |
LOS2 |
DLX |
201.90 |
201.90/2 nts = 100.95 |
90.86 |
LOS3 |
DLX |
287.85 |
287.85/3 nts = 95.95 |
86.36 |
When the bid for an arrival date is changed, OPERA recalculates rate amounts for those rate codes that are based on the prevailing rate code for the affected room types.
Standard yield functionality compares the hurdle rate to the rate amount determined by the rate code specifications in order to determine availability. The Yield As field on the Rate Code Setup screen header allows you to specify a rate code to which the current rate will defer should it happen to fall below the hurdle rate. For rate codes based on the prevailing rate code, it is assumed that the Yield As option on the Rate Code Setup screen header will be set to the prevailing rate code. This will prevent the possibility of its coming in lower than the hurdle rate and therefore being closed.
It is also understood that rate codes based on the prevailing rate must be manually opened and closed should their availability need to be restricted.
The Room Type screen (Configuration>Reservations>Room Classifications>Room Types) includes the Initial Round Up and Increments fields when the Rates>Prevailing Rate by LOS application function is set to Y. These fields provide inputs to the Rate by Day by Room Type by LOS rounding process which are specific to the room type being processed. These fields are described above in Rate Calculation Methodology.
Note: In Multi-property environments, Initial Round Up and Increments may be configured at the individual property level only. These fields are not available when creating or editing room type templates.
See Also