This is Article 2 of 4 in the "Rate" Series

1. Rates: Overview
2. Rates: Rate Table Formats
3. Rates: Rate Hierarchy
4. Rates: Initial Rate Setup

Overview

The Rate Structure selected on the Rate Table determines which rate formats and calculation options are available. Each format can include one or more 'Based On' options to further customise how the entered rate values will be calculated on a reservation.

This article covers the five Rate Table formats available in RMS: Daily, Extended Stay, Hourly, Nightly, and Per Guest. For an introduction to rate concepts and components, see Rates: Overview.

Daily

The 'Daily' Rate Format is only available when the Rate Structure is set to 'Direct' and includes the 'Based On' options of:

• Day of the Week
• Number of Days
• Per Day

Daily rates count each date of the reservation stay period from midnight to midnight, calculating these periods using the selected 'Based On' option.
 

Day of the Week

A daily rate based on the day of the week is calculated using the specific day on which each reservation stay date falls, with the ability to charge a different amount for the check-out day.

 

Using the above Rate Table, a reservation arriving on Thursday and departing on Sunday will pay:

Number of Days

A daily rate based on the number of days uses the reservation's length of stay to determine the rate amount for each reservation stay date.

 

Using the above Rate Table:

• A reservation staying three days will pay $180 per day.
• A reservation staying seven days will pay $120 per day.
   

Per Day

A daily rate based on each day is calculated using the value entered for each reservation stay date.

 

Using the above Rate Table, a reservation staying four days and departing on the fifth will pay:

Extended Stay

The 'Extended Stay' Rate Format is available for both the 'OTA' and 'Direct' Rate Structures:

• Direct includes the 'Based On' options of Night of the Week or Per Night.
• OTA can only be set up as Night of the Week.

Extended Stay rates provide greater flexibility for longer-term reservations, using a combination of nightly, weekly, and monthly rate values to calculate the amount due for a reservation.

A cap on the number of cycles for which a weekly or monthly rate can apply can be set. Once reached, the reservation will use the Best Available Rate for any additional reservation stay dates.

The 'Extended Stay' Rate Table can be used to:

• Set up a weekly or monthly rate, or
• Create a single rate that accommodates short and long stays by utilising all three sections.

How Extended Stay Calculates the Rate

At a high level:

1. RMS will first try to use a Monthly rate for any full calendar months in the stay.
2. For any remaining nights, it will then use as many full Weekly blocks as possible.
3. Any leftover nights are charged at the Nightly rate.

For reporting, the total Weekly or Monthly amount is then evenly distributed across the nights covered by that block, so each stay date shows a share of the weekly or monthly total.

The following Rate Table example shows the Nightly, Weekly, and Monthly rate amounts configured for an Extended Stay rate:

 

The next examples use this Extended Stay Rate Table to demonstrate how the rate is calculated for different lengths of stay:

1. Stays of six nights or less — Nightly rate only

A reservation for six nights or less will use the Nightly rate amounts entered on the Extended Stay Rate Table.

 

2. Seven nights — Weekly rate

A seven-night reservation will use the Weekly rate instead of the Nightly rate. This Weekly rate will be used for each seven-night block of the reservation.

 

3. Eight nights — Weekly + Nightly

For an eight-night reservation, RMS calculates the rate using:

• 1 × Weekly Rate for the first seven nights, plus
• 1 × Nightly Rate for the additional night.

The above example calculates the rate using 1 × Weekly Rate + 1 × Nightly Rate for the eight-night reservation.

4. Fourteen, twenty-one, or twenty-eight nights — Multiple Weekly blocks

A fourteen, twenty-one, or twenty-eight-night reservation multiplies the Weekly rate by each block of seven days.

In the example shown, 4 × Weekly Rate = $5,680.

5. Monthly rate — Full calendar months

The Monthly rate applies for each calendar month, from the first of one month to the first of the following month. Any reservation stay dates beyond the calendar month will use the Nightly and/or Weekly rate amounts for the remaining reservation dates.

In the first example, the total is calculated as 1 × Monthly Rate + 1 × Nightly Rate = $5,755.

In the second example, the total is calculated as 1 × Monthly Rate + 2 × Weekly Rate = $8,370.

6. When a Nightly, Weekly, or Monthly value is not set

If the Nightly, Weekly, or Monthly rate amounts are not set, they will be skipped during the calculation once a reservation reaches that length of stay, and the next available block will be used instead.

Examples:

• If no Weekly rate is configured, a seven-night stay will use 7 × Nightly Rate.
• If no Monthly rate is configured, a 31-night stay will use the applicable combination of Weekly + Nightly rates.
   

7. How Extended Stay affects revenue allocation

Weekly and Monthly rates are divided evenly across the reservation stay dates they cover for reporting and revenue allocation.

This means:

• Financially, the guest is charged the total Weekly or Monthly amount as a single block (e.g. one transaction for the Weekly amount).
• Operationally, RMS spreads that total across each stay date in the block, which affects the individual nightly transactions and the Operational Revenue per reservation night.

Hourly

The 'Hourly' Rate Format is only available with the 'Direct' Rate Structure and does not include any alternative 'Based On' options.

The rate amount for a reservation is calculated per hour using the values entered on the Rate Table. Options are available to:

• Set a flat hourly rate after ten hours, or
• Loop back to the first hourly rate after a set number of hours is reached.

Standard Hourly Calculation

Using the above Rate Table:

A six-hour reservation pays $425 total:

A twelve-hour reservation (with a flat rate after ten hours) pays $1,100 total (10 × $100 + 2 × $50).
 

Hourly with Loop-Back

With looping after five hours:

A six-hour reservation pays $515:

An eight-hour reservation pays $685:

Nightly

The 'Nightly' Rate Format is available for both the OTA and Direct Rate Structures:

• Direct includes the 'Based On' options of Night of the Week, Number of Nights, and Per Night.
• OTA can only be calculated using the Night of the Week.

Unlike Daily rates, Nightly rates calculate each reservation stay date from the check-in time on the arrival date to the check-out time of the following date to determine the length of stay.
 

Night of the Week

A nightly rate based on the day of the week is calculated using the specific day on which each reservation's stay date falls.

 

Using the above Rate Table, a reservation arriving on Thursday and departing on Sunday will pay:

Number of Nights

A nightly rate based on the number of nights uses the reservation's length of stay to determine the rate amount for each reservation stay date.

 

Using the above Rate Table:

• A four-night reservation will pay $725 per night.
• A seven-night reservation will pay $650 per night.
   

Per Night

A nightly rate based on each night is calculated using the value entered for each reservation stay date.

 

Using the above Rate Table, a four-night reservation will pay:

Per Guest

The 'Per Guest' Rate Format is only available with the 'Direct' Rate Structure and will calculate the rate amounts per reservation stay date based on the number of adults and children entered as guests.

 

Using the above Rate Table, a three-night reservation with two adults and one child will pay $405 per night for a total of $1,215.

Rate Format Availability Summary