Offsets

G3 RMS calculates the pricing decision for the Base Room Type of each Room Class using the price range set up in the Ceiling/Floor tab. Then, it uses Offsets to calculate the pricing decisions for: 

  1. Other room types that are in the same Room Class as the Base Room Type.

  2. Other occupancy types, like extra adults and extra children, for all room types, if you price those differently.

Define offsets by room type for each occupancy type and for each day of week as a fixed amount or a percentage. They are added cumulatively on top of the Base Room TypeClosed The one room type in each Room Class on which the system bases its pricing for the other room types in the Room Class. value. You can set seasonal offsets that override your default values.

Offsets for Group Evaluations

For Group Pricingor Function Spaceevaluations, the offsets of the primary priced product define how much the recommended rate for non-base room types differs from the recommended rate of the base room type. G3 RMS uses the offsets for the group's arrival date to determine the recommended rate.

Note: G3 RMS uses Offsets only for Room Class, not Run-of-House evaluations.

What Help Do You Need With Offsets?

  • I need to view the steps to set up Offsets.

  • I want to learn about the best practices for how to use Offsets.

  • I need to see scenarios for how G3 RMS uses Offsets to calculate the Final Price.

  • I need an overview on how to share my price strategy with G3 RMS in Pricing Configuration.

  • My property uses per room pricing and varies the extra child charge by age group. Before I define offsets, I need to set up Occupant Grouping.

Note: For independent products, you define Offsets separately from the primary priced product Offsets.

Setup Steps

  1. Click , then Decisions, and then Pricing.
  2. Click to edit the product.
  3. Click the Offsets tab.

Offsets impact your suggested Ceiling/Floor values. Before you use Suggest, set up Offsets for the first time or update the existing values.

  1. For each room type and occupancy type in a Room Class, select an Offset Method:
    • Fixed: G3 RMS adds the offset value to the Base Room Type price.
    • Percentage: G3 RMS calculates the offset as a percentage of the Base Room Type price.
  2. Enter the offset value for each room type, occupancy type and day of the week:
    1. Enter the offset value in the first field. The value populates each day of the week.
      For any room type that you want to price equally to the Base Room Type, leave the default fixed offset with a 0.00 value. If you do not enter any offsets, G3 RMS prices all room types in a Room Class the same.
    2. Press the Tab key to navigate to each day of the week to edit each value, if needed.

    Note: for the single occupancy of non-Base Room Types in a Price Excluded Room Class the Offset Method is Set. Enter the fixed value instead of an offset value.

  3. Click Save.
  4. Review that your setup is correct. If necessary, click the Export to Excel icon and review on a spreadsheet.

Use the upload option if you have a complex setup with many seasons, or you manage pricing data for multiple properties in one place, or both.

  1. Click Export to Excel to download the template with the current values.
    Note: Importing replaces the old values and you can't recover them.
  2. Save the workbook to a location on your computer.
  3. Add the new values or change existing values as needed.
    For details on entering the data, use the Upload Instructions tab in the Excel file.
  4. Save the modified workbook in an XLSX format.
  5. Click upload . A warning message displays, click Yes to continue.
  6. Navigate to and select the saved workbook, then click Open.
    G3 RMS checks the workbook for data and formatting errors. If the system finds no errors, it displays the imported data. If it finds errors, it cancels the import and tells you which rows have errors. Click the export icon to export the error list. Correct the errors, then re-import the workbook.

An optional season overrides the default Offsets. For example, during your high demand season, you want higher offsets than for the rest of the year.

  1. In the Seasons pane, click Add .
  2. Add a Name. You can refer to this name later if you need to copy a season to create another.
  3. Enter or select the Start Date for the season. The Start Date must be greater than or equal to the System Date.
  4. Enter or select the End Date for the season. The End Date can be any future date and is not limited by the forecast window.
  5. Enter the offset value for any room type, occupancy type and day of the week that differs from the defaults. Leave those fields empty that are the same as the default. You can also Copy From the values of an existing season or the default.
    1. Enter the offset values in the first field. The value populates each day of the week.
      For any room type that you want to price equally to the Base Room Type, leave the default fixed offset with a 0.00 value. If you do not enter any offsets, G3 RMS prices all room types in a Room Class the same.
    2. Press the Tab key to navigate to each day of the week to edit each value, if needed.
  6. Click Apply.
  7. Repeat the steps to add additional seasons, as needed.
  8. Click Save.

If you add seasons that lead to overlapping dates, G3 RMS follows these rules:

  • If you add a new season in the middle of an existing season, G3 RMS splits the existing season into two seasons, one before the new season and one after the new season. These two have the values of the original season. The new season has the new values.
  • If you add a new season that partially overlaps (later start date, same end date as existing season), two seasons result. The new season and its values apply to the overlapping dates.
  • If you add a new season that includes all the dates of an existing season, the new season takes over and its values replace those of the existing season.
  1. Enter a new offset value for the required room type, occupancy type and day of the week. If you have many room types, use the Room Class Search to jump to the one that you want to change.
  2. Click Save.

Impact of editing seasons on pricing decisions

When you change offsets, the system detects the differences in the resulting price and delivers only those that have changed. Therefore, G3 RMS only pushes new room type prices to integrated selling systems.

For example, if you change only the 1 Adult offset for all room types, G3 RMS sees only a change in the 1 Adult values (and subject to setup, possibly changes to the 2 Adult values as well) for all room types. G3 RMS only sends the price changes impacted by the setup change to integrated systems at the next scheduled decision upload, in addition to any other changes as a result of optimization.

Impact on Saved Evaluations

Changes to your pricing setup might impact saved evaluations, but the results in saved evaluations only change if you run a re-evaluation.

You can edit a future season (with a Start Date after the System Date). When you edit a current season, G3 RMS splits the season and you can edit only the future dates. You can't edit past seasons.
  1. If necessary, change the selected checkboxes to view only Present or Future seasons.
  2. Click Edit for the season that you want to edit.
  3. Change the Season Name, if needed.
  4. Enter or select a new Start Date for the season, if needed. To be changed, the Start Date must be greater than or equal to the System Date.
  5. Enter or select a new End Date for the season, if needed. The End Date can be any future date and is not limited by the forecast window.
  6. Enter new offset values for the required room type, occupancy type and day of the week.
  7. Click Apply.

You can completely delete a future season (with a Start Date after the System Date). When you delete a current season, G3 RMS splits the season and deletes only future dates. You can't delete past seasons. G3 RMS deletes past seasons based on the data retention policy.

  1. Click , then Decisions, and then Pricing.
  2. Click to edit the product.
  3. Click Offsets.
  4. Click Delete for the season that you want to delete.
  5. Click OK.
  6. Click Save.

When you change Offsets, a sync flag in the top right indicates that the changes impact the forecast and decisions. See Sync for more information.

Note: If you change your offset values, G3 RMS ignores the Minimum Change Value and updates and sends any pricing decisions that changed as a result of the new pricing setup .

Best Practices

Consider Other Values That Impact the Setup of Offsets

Value When You Enter Values:
Taxes If you are in a country with Tax-Inclusive PricingClosed Tax-inclusive pricing applies in countries where quoted and booked prices have to include taxes like a Value-Added Tax (VAT) or Goods and Services Tax (GST). If you are not in a country with tax-inclusive pricing, taxes are added to pricing only at the point of payment. In G3 RMS, tax-inclusive pricing is enabled and configured in Property Specific Configuration., enter the Offset values inclusive of tax. This applies to all pricing setup values. View Entering and Display of Taxes in G3 RMS for more information.
Supplements If your property uses non-room Supplements, exclude their cost in offset values. For example, you want the difference in price between Room Type A and B in a Room Class to be 30. But 20 out of that 30 is breakfast and is set up as a supplement. In that case, enter 10 as the Offset value. G3 RMS adds the supplements that you set up to your pricing decision.

Understand the Options How to Enter Offsets

With Room-Based Pricing

  • Fixed and percentage offsets can be positive or negative (-).
  • Offsets are cumulative, so the double occupancy price is calculated by adding the Single + Double offsets to the Optimal Price. See Calculations for the Pricing Decision below.

With Per Person Pricing

  • Extra adult offsets are cumulative, so the price for an Extra Adult occupancy includes the price for the maximum adults + Extra Adult offsets. See Calculations for the Pricing Decision below.
  • Child offsets are the exact price for the number of children in the room (1 Child, 2 Children, etc.). See Calculations for the Pricing Decision below.
  • Since Child offsets are the exact price, the value can't be negative. Other offsets can be positive or negative (-).
  • Pricing setup, including Offsets, must follow your Rounding Rules. G3 RMS rounds the Final Price for each room type and occupancy level if you do not. For the Base Room Type, Final Price is the system's pricing decision with rounding applied. For other room types, Final Price is the pricing decision after both offsets and rounding are applied.

Scenarios for Pricing Calculations

If your property prices by room, you can set up offsets for Single, Double, Extra Adult and Extra Child occupancies (and optional child age groups if you use Occupant Grouping). The Optimal Price is for the Single occupancy. All other prices are offset from the Optimal Price for the Single pricing decision.

In this example, STKG and STDD are in the same Room Class. STKG is the Base Room Type for the Standard Room Class. Offsets add an extra charge for double occupancy and extra adults in each room type.

Room Type Optimal
Price		 Occupancy Type Offset
Method		 Offset Price before Rounding
STKG 100 Single Not applicable Not applicable 100
Double Fixed 10 100 + 10 Double Offset = 110
Extra Adult Fixed 30

110 + 30 for each extra adult = 140, 170 etc.
Extra Child Fixed 0.00 +0 for each extra child

STDD (priced 20 above Base Room Type)

 Not applicable Single Fixed 20

100 + 20 Single Offset = 120
Double Fixed 10 100 + 20 Single Offset + 10 Double Offset = 130
Extra Adult Fixed 30

130 + 30 for each extra adult = 160, 190 etc.

Extra Child Fixed 0.00 +0 for each extra child

In this example, all offsets are percentages of Optimal Price. Occupant Grouping was used to add child age groups:

Room Type Optimal
Price		 Occupancy Type Offset
Method		 Offset Price before Rounding
STKG 100 Single Not applicable Not applicable 100
Double Percentage 20 100 + (100 × 20%) = 120
Extra Adult Percentage 30

120 + (100 × 30%) for each extra adult = 150, 180 etc.
Children Aged 0-2 Percentage 0 + 0 for each extra child
Children Aged 3-10 Percentage 10 + (100 × 10%) = 10 for each extra child

STDD (priced 20 above Base Room Type)

 Not applicable Single Percentage 20

100 + (100 × 20%) Single Offset = 120
Double Percentage 20 100 + (100 × 20%) Single Offset + (100 × 20%) Double Offset = 140
Extra Adult Percentage 30

140 + (100 × 30%) for each extra adult = 170, 200 etc.
Children Aged 0-2 Percentage 0 + 0 for each extra child
Children Aged 3-10 Percentage 10 + (100 × 10%) = 10 for each extra child

The following example shows pricing calculations when non-room Supplements are included. Note that offsets are cumulative, but Supplement values are not cumulative.

Room Type Optimal
Price 		Occupancy Type Offsets Supplements - Breakfast Price before Rounding
STKG 100 Single Not applicable 10 100 + 10 Single Breakfast Supplement = 110
Double 10 20 100 + 10 Double Offset + 20 Double Breakfast Supplement = 130
Extra Adult 30 10

130 + 30 Extra Adult Price + 10 Extra Adult Breakfast Supplement = 170, 210 etc.

STDD (priced 20 above Base Room Type)

 Not applicable Single 20 10

100 + 20 Single Offset + 10 Single Breakfast Supplement = 130
Double 10 20 100 + 20 Single Offset + 10 Double Offset + 20 Double Breakfast Supplement = 150
Extra Adult 30 10

150 + 30 Extra Adult Price + 10 Extra Adult Breakfast Supplement = 190, 230 etc.

If your property prices by occupant (Per Person Pricing), you set up offsets for 1 Adult, 2 Adults, Extra Adult and Extra Child occupancies (plus additional occupancy types if you use Occupant Grouping). The Optimal Price is for the 2 Adults occupancy. All other prices are offset from the Final Price for the 2 Adults pricing decision.

In this example, KNG and QN are in the same Room Class, and KNG is the Base Room Type. You set up Occupant Grouping so that you can define the prices for up to 4 Adults and charge Extra Adults above that. And you charge for every Extra Child. You set up Maximum Occupants for the KNG as 3 (2 Adults and 1 Child) and 5 (4 Adults and 1 Child) for QN. Offsets are fixed values off Final Price:

Room Type Final Price Occupancy Type Offset
Method		 Offset Price before Rounding
  KNG   200 2 Adults Not applicable Not applicable 200
1 Adult Fixed -20 200 - 20 = 180
Extra Adult Fixed 30

200 + 30 for each extra adult = 230, 260, etc.
Extra Child Fixed 20

+ 20 for each extra child
QN Not applicable 2 Adults Fixed 20 200 + 20 = 220
1 Adult Fixed -10

220 - 10 = 210
3 Adults Fixed 20 220 + 20 = 240
4 Adults Fixed 30 220 + 30 = 250
Extra Adult Fixed 40

250 + 40 for each extra adult = 290, 330, etc.
Extra Child Fixed 20

+ 20 for each extra child

 

In the next example, all offsets are percentages of Final Price. Occupant Grouping was used to add more adult and child occupancy levels. The maximum occupants you can set up is 4 adults before the additional adult supplement applies.

Room Type Final Price Occupancy Type Offset
Method		 Offset Price before Rounding
  KNG   200 2 Adults Not applicable Not applicable 200
1 Adult Percentage -10 200 - (200 × 10%) = 180
3 Adults Percentage 10

200 + (200 × 10%) = 220
4 Adults Percentage 20 200 + (200 × 20%) = 240
Extra Adult Percentage 20

+ (200 × 20%) = 40 for each additional adult. In this case, beyond 4 adults, 240 + 40 = 280, 320, etc.)
1 Child Percentage 10 (200 × 10%) = 20
2 Children Percentage 15 (200 × 15%) = 30
3 Children Percentage 20 (200 × 20%) = 40
Extra Child Percentage 20

(200 × 20%) = 40
QN Not applicable 2 Adults Percentage 20 200 + (200 × 20%) = 240
1 Adult Percentage -5

240 - (240 × 5%) = 228
3 Adults Percentage 25 240 + (240 × 25%) = 300
4 Adults Percentage 30 240 + (240 × 30%) = 312
Extra Adult Percentage 40

+ (240 × 40%) = 96 for each additional adult (in this case, beyond 4 adults, so 312 + 96 = 408, 504, etc.)
1 Child Percentage 20 (240 × 20%) = 48
2 Children Percentage 25 (240 × 25%) = 60
3 Children Percentage 30 (240 × 30%) = 72
Extra Child Percentage 40

(240 × 40%) = 96

In this example, offsets are fixed values off Final Price, and Occupant Grouping was used to set up child age groups.

Room Type Final Price Occupancy
Type		 Offset
Method		 Offset Price before Rounding
  KNG   200 2 Adults Not applicable Not applicable 200
1 Adult Fixed 0 200 + 0 = 200
Extra Adult Fixed 50

200 + 50 for each extra adult = 250, 300, etc.
Children Aged 0-2 Fixed 0 0 (free)
Children Aged 3-12 Fixed 30 30
Children Aged 13-16 Fixed 50 50
QN Not applicable 2 Adults Fixed 25 200 + 25 = 225
1 Adult Fixed 0

225 + 0 = 225
Extra Adult Fixed 50

225 + 50 for each extra adult = 275, 350, etc.
Children Aged 0-2 Fixed 0 0 (free)
Children Aged 3-12 Fixed 30 30
Children Aged 13-16 Fixed 50 50

In the offset setup example below, the group recommended rate for the STD-King and STD-Lakeview King room types are offset from the Base Room Type rate in the same Room Class:

Room Type Offset Values Group Recommended Rate
STD-Double Not Applicable 200
STD-King Fixed Offset = 25 single 225
STD-Lakeview King Fixed Offset = 50 single 250

If you don't include the Base Room Type in a group evaluation, the group's recommended rate uses the offsets for the included room types. In the following example, the Base Room Type (STD-Double) isn't selected, but the other room types in the Room Class (STD-King and STD-Lakeview King) are included:

Room Type Offset Values Number of Group Rooms Requested Group Recommended Rate
STD-Double Not Applicable Not requested 350 (not used)
STD-King Fixed Offset = 25 single 20 375
STD-Lakeview King Fixed Offset = 50 single 10 400