Offsets

1. Click , then Decisions, and then Pricing.
2. Click , then Decisions, and then Group Pricing Configuration.
3. Click the Offsets tab.

1. For each room 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 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.
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 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.

How G3 RMS handles changes that lead to overlapping seasons:

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 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.
   

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 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 , then Decisions, and then Group Pricing Configuration.
3. Click Offsets.
4. Click Delete for the season that you want to delete.
5. Click OK.
6. Click Save.

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