Pricing Investigator

1. Click and then Investigator. The default selection is Pricing.

2. Click the calendar to select the date to investigate. The data for that date loads automatically.

• Click the back arrow or forward arrow to move to the previous or next occupancy date.
• Click the note to view and add notes for the date. A check mark indicates that a note already exists.
• Click the PDF icon to save the results to a PDF file.
  Attach the PDF file whenever you create a case for IDeaS Support about a pricing decision.
• Click Go to Pricing Management to review pricing information for the same occupancy date.

Interacting with the Graphs and Tables

• Point to elements in the charts, like bubbles or lines, to see numerical values.
• Click an item in the legend to hide the item from the chart. Click it again to restore it.
• In the Pricing Details table, select the Room Class and Room Type for which you want to see Occupancy Forecast, pricing and LRV data.
• Click the BAR link in the Pricing Details table to drill down to the Room Class level data.

Review the graph and table details

The Occupancy Forecast chart shows occupancy on books, and the unconstrained and constrained forecasted occupancy, all compared to capacity.

Data	Description
Preceding Days of Week	The percentage increase or decrease in the booking pace compared to the same day of the week from the five prior weeks. The value shows how you are pacing compared to the same day of the week. For example, the number of rooms on books for the arrival date Saturday, December 29 is compared to the average on books of the previous Saturdays: December 22, 15, 8, 1, and November 24. Note that Special Event days are excluded, so if November 24 was a Special Event the system adds November 17 to the comparison group.
Year on Year	The percentage increase or decrease in the booking pace compared to the same arrival date last year, adjusted to the same day of the week. The value shows how you are pacing compared to last year. For example, the number of rooms on books for the arrival date Saturday, December 29 this year is compared to the on books for Saturday, December 30 last year, as of the same number of days prior to arrival.
Effective Capacity	The Physical Capacity The total number of guest rooms at a property, including out of order rooms. minus out of order rooms
Authorized Capacity	Effective Capacity plus Overbooking.
On Books	The number of rooms that have already booked against the property's physical capacity.
Total Demand	The combination of on books and remaining unconstrained demand, which helps you understand if you have more demand than capacity.
Occupancy Forecast	The forecasted constrained occupancy shows you if there is enough constrained demand to fill the property's Effective Capacity The hotel's physical capacity minus the out of order rooms.. It helps you understand if the property is expected to fill and if out of order rooms are constraining its ability to fill.

Use the Booking Pace chart to compare the booking pace of the last 30 days against the average On Books of the previous weeks with the same day of the week. To see more pace data, review the Pace Data tab.

This table helps you to understand how the system optimizes pricing for an entire period and Room Class hierarchy.

Data	Description
Date	The occupancy date you selected and the three dates before and after it.
Occupancy Forecast %	The Occupancy Forecast The number of rooms (or percentage of the total number of rooms) that G3 RMS expects the property to achieve for the period. For the calculation, see the Demand and Wash - Overview topic (under Data Details). percentage at the total property level for the occupancy date.
Room Class and room type name	Prices display for the lowest priced room type of the selected Room Classes. displays for the Master Class The Room Class for which a value displays if there is only space to show one. For example, the price on the Summary tab of the Business Analysis Dashboard..
BAR	The pricing decision for the room type and occupancy date. If the value comes from a Specific, Floor or Ceiling override, an override icon displays next to the value. Click the linked BAR pricefor a room type and date to drill down into additional details. Clicking the link opens the Room Class details on the lower part of the page.
LRV	The Last Room Value Last Room Value (LRV) is a control that blocks lower-valued yieldable business when G3 RMS thinks that your property might sell out. LRV ensures that you accept only the most valuable demand. For example, an LRV of $150 means that guests can book a Flexible Rate product at $160, but not a discounted PrePay&Save product at $140. G3 RMS optimizes LRV by Room Class. for the selected date, Room Class and length of stay. For details, see the LRV topic.

Click link to open Competitor Details and view the data from all competitors and all channels. Review this data to understand how competitors' prices influence your price.

Check the remarks to ensure that you view comparable prices. For example, if you compare your BAR to the competitors’ discounted Loyalty Program price, then G3 RMS tends to price lower.

The data in Competitor Details changes depending on the Room Class that you selected above the table:

• All Room Classes: Shopping data for all Room Classes that are mapped to a competitor room type.
• Single Room Class: Shopping data for that single Room Class, if it is available.

Some data conditions are so meaningful for a pricing decision that G3 RMS points them out to you with a light bulb icon and a short explanation. If there are multiple explanations, click each bullet to read all of them. Here are two examples:

• When the system selects the highest possible pricing decision. If you observe this condition repeatedly, it might mean that you need to expand your price range setup.
• When the system selects a price that doesn't meet the Minimum Price Differential for this Room Class. It means that your pricing setup and price ranking don't allow G3 RMS to select a value that meets the Minimum Price Differential.

• The occupancy forecast percentage, at the property level.
• The percentage change in the booking pace compared to the same day of the week from the five prior weeks, excluding Special Event days. As an example for the pace comparison, the number of rooms on books for arrival date Saturday December 29 compared against the average on books of the preceding Saturdays, December 22, 15, 8, 1, and November 24. Note that Special Event days are excluded, so if November 24 was a Special Event the system adds November 17 to the comparison group.
• The lowest and highest price points that you set up in Rate Plan setup and your competitors' lowest and highest price points from rate shopping data. Both are for the selected Room Class and occupancy date.
• The Historical Price for the Room Class and date ( for Limited Data Build properties: Projections BAR).
• The Available Capacity for the Room Class. It's calculated as Capacity plus Overbooking minus Out of Order minus On Books. This value is the number of rooms that the system can sell before the property or room type is sold out.
• The Remaining Demand The remaining unconstrained demand for a date in the future. This value is either generated by G3 RMS or, in case of an active user demand override, the user override value plus or minus a possible system adjustment. G3 RMS adjusts a demand override according to the booking pace, so the override remains accurate after its implementation. for the Room Class and for market segments attributed as Unqualified or Qualified, Linked to BAR and Yieldable.
• The Remaining Demand for the Room Class for all other market segments.
• Whether there is enough demand to fill the Room Class, and if it can accept demand from a lower-ranked Room Class due to the Upgrade Path. Use this to review the LRV decision. Click See more details and compare the Remaining Demand - Total against the Available Capacity to Sell Physical Capacity plus Overbooking minus On Books and minus Out of Order. This value is the number of rooms that G3 RMS can sell before the property or room type is sold out. for the selected Room Class. If remaining demand is larger, then there is enough demand to fill and G3 RMS uses LRV to restrict demand. You can also view the remaining demand by Forecast Group to analyze its mix.

Use the Price Ranking chart to understand how the value and type of demand versus available capacity impacts the pricing decision for the selected day and the three days before and after that day. Review the data for the selected Room Class and, based on the upgrade path, the neighboring Room Classes, and for shoulder days.

For an example of demand impact across Room Classes, see Investigate LRV across Room Classes.

If you have an Advanced Price Ranking and Upgrade Path, move the charts to view the neighboring towers that connect to the selected Room Class.

Data	Description
Date	The investigated date and the three days before and after that day, provided all these days are current or in the future. Past dates don't display.
Effective Capacity	The total number of physical rooms minus the out of order rooms, for the Room Class.
Final Price	The pricing decision for the lowest priced room type in the Room Class for each occupancy date.
On Books	The number of rooms that have already booked.
Demand - Unqualified	The number of rooms of Remaining Demand The remaining unconstrained demand for a date in the future. This value is either generated by G3 RMS or, in case of an active user demand override, the user override value plus or minus a possible system adjustment. G3 RMS adjusts a demand override according to the booking pace, so the override remains accurate after its implementation. for market segments attributed as Unqualified in Market Segment setup. For details, review the attribute definitions.
Demand - Qualified Linked	The number of rooms of Remaining Demand for market segments attributed as Qualified, Linked to BAR, Yieldable in Market Segment setup.
Demand - Qualified Semi-Yieldable	The number of rooms of Remaining Demand for market segments attributed as Qualified Non-block, Semi-Yieldable and either Linked to BAR or Non-linked in Market Segment setup.
Demand - Qualified Transient Other	The number of rooms of Remaining Demand for all other remaining transient market segments.
Demand - Block	The number of rooms of Remaining Demand for all market segments attributed as Group or Transient Block in Market Segment setup.
Price Rank Arrows	A solid arrow indicates that the path between the Room Classes is both Price Rank and Upgrade. When this arrow displays, and only on days when the higher ranked Room Class has less forecasted demand than capacity and the lower ranked Room Class has more demand than capacity, the excess capacity of the lower ranked Room Class can be added to the overbooking of the higher ranked Room Class. An outlined arrow indicates Price Rank Only. When this arrow displays, the higher Room Class does not accept any upgrades. If there is no demand for it, its rooms remain unsold even if there is more demand than capacity for lower Room Classes.
Min Differential	The Minimum Price Differential between two Room Classes.

Use the Competitors chart to see the relationship between your price, the range of rates that you provided to the system, your competitors' pricing, the LRV, and the Historical Price (for Limited Data Build properties: Projections BAR ).

The Pricing Pace chart shows how your price (as of each nightly processing) changed in the last 30 days. Compare that to how your competitors' prices have changed over the same period.

This chart shows the Occupancy Demand The remaining price-able unconstrained demand that will stay over an occupancy date in the future. It is limited to market segments that are impacted by pricing changes (all unqualified and all linked qualified market segments) and only applies to the selected Room Class or Room Type.or, for properties with BAR by LOS, the Arrival Demand The remaining price-able unconstrained demand that will arrive on a date in the future. It is limited to market segments that are impacted by pricing changes (all unqualified and all linked qualified market segments) and only applies to a selected length of stay and room class. for the system's selected price point, compared to the demand for the neighboring higher and lower price points. The chart helps you understand how the price sensitivity of the demand is influencing the system’s pricing decision. A steep curve shows that price sensitivity is very elastic. A shallow curve shows that price sensitivity is inelastic.

Click Rate Plan Configuration to see a summary of pricing setup for the Room Class and occupancy date. The Pricing setup summary shows the following data:

• Base Room Type for all Room Classes

• Rounding Rules for the Final Price

• The Ceiling/Floor for all Room Classes and days of week that include the investigated date

• Offsets for all room types in the Room Class for all days of the week that include the investigated date

• Supplements, if enabled, for all room types in the Room Class

Your setup is the primary input to pricing, since the system must pick the optimal pricing decision from the price spectrum that you defined. Therefore, it's important that you use Rate Plan setup to share your pricing strategy with G3 RMS.

For pricing Room Classes, the system also considers any Minimum Price Differential that you set up as part of your Rooms Configuration.

• The volume of demand, or how many rooms are on books, how many are still expected, and how much of that demand is expected to wash. Review the demand and wash forecast, or learn more about how G3 RMS forecasts unconstrained demand.
• The value of that demand. A strong indicator of that value is the historical Unqualified ADR. Competitors' pricing, especially if they are pricing a lot higher, is another big factor.
• The uncertainty of the demand to come. For example, far into the future uncertainty is high and G3 RMS might price lower. You can see uncertainty in the Actual versus Expected On Books data in the Investigator. Another example is the impact on LRV. A 0.00 LRV day has the same impact on restrictions as a 0.01 LRV day, but the uncertainty might be very different: for the 0.00 day, G3 RMS is certain that demand is not enough to fill the property. But with 0.01 LRV, there is still some uncertainty about the volume of demand. There might be a chance that demand reaches or surpasses capacity as the arrival date approaches and as G3 RMS receives more data.
• Available Capacity to Sell, which is the Physical Capacity plus Overbooking, minus On Books, and minus Out of Order. Setup settings like overbooking or the upgrade path might affect that capacity. Therefore, they also impact the BAR.

Often called willingness to pay, price sensitivity measures how the BAR affects demand, and vice versa. The system calculates the overall price sensitivity of the unqualified and the linked qualified demand based on the actual booking patterns that it receives from the Reservation System The primary reservation system, like a PMS or CRS, that provides data to G3 RMS. The data from that one system is used by the RMS to forecast, optimize and produce controls. The controls are sent to all selling systems, which for some integrations may exclude the reservation system.. The system monitors the volume of BAR reservations and models price sensitivity by season, day of week, and time left to arrival. All price sensitivity models are then used to calculate the expected demand volume for each price point.

The system considers the impact on all demand that is attributed as Linked to BAR when selecting the optimal price. Therefore, a pricing decision might result in very little BAR business itself, but because of the impact on demand that is linked to the BAR, it is still the pricing decision that produces the maximum revenue.

A qualified discount that is 10% off your BAR is considered linked since a change in pricing changes the price of this qualified discount. The system assumes the same applies to all unqualified demand, so BAR-linked demand includes all unqualified business and all Linked to BAR qualified business.

G3 RMS calculates the remaining capacity and the remaining demand for all lengths of stay (LOS). If your system is set up for BAR by Day, G3 RMS considers all demand that stays over an occupancy day and finds the optimal pricing decision for that one day. With a BAR by LOS setup , G3 RMS calculates price decisions by arrival date and for each LOS between 1 and 8 nights.

With BAR by LOS pricing, the blended price might differ from the sum of the individual days. This example shows the BAR prices for a Monday 3-night stay and for the equivalent 1-night stays:

In sum, the 1-night stays are $25 more than the 3-night stay. In this case, G3 RMS determined that pricing the 3-night stay lower than the separate 1-night stays maximizes revenues, due to variations in demand or price sensitivity.

G3 RMS analyzes how you priced in the past compared to your competitors. And it measures how much impact each competitor had on your demand. Based on that, the system calculates the impact of future competitor prices on your demand.

For more on how rate shopping data helps the system generate better demand forecasts and pricing decisions, view How G3 RMS Uses Competitors' Data.

When calculating the pricing decision, G3 RMS does not consider contracted Group Rates, meaning G3 RMS might price BAR below an already contracted group rate. If necessary, use Floor Overrides to align BAR with group rates.

Demand varies by Room Class and therefore G3 RMS prices by Room Class. The difference in pricing between Room Classes mainly reflects the difference in remaining "price-able" demand (all unqualified and qualified Linked to BAR business). For example, if the remaining demand for your Suites is low, but the remaining demand for Standard rooms is high, the price difference tends to be smaller. If there is plenty of demand for Suites, the price difference is larger.

Note that Room Class pricing also considers any Minimum Price Differential that you set up as part of your Rooms Configuration. For all inputs into the pricing decision, see How G3 RMS Determines Pricing. Use the Investigator to review how Room Class demand impacts your pricing decisions.

How G3 RMS looks at remaining "price-able" demand depends on the Pricing Method:

• BAR by LOS properties: G3 RMS looks at remaining demand for a given arrival date and LOS. In the system this demand is called Arrival Demand The remaining price-able unconstrained demand that will arrive on a date in the future. It is limited to market segments that are impacted by pricing changes (all unqualified and all linked qualified market segments) and only applies to a selected length of stay and room class..
• BAR by Day or Continuous Pricing properties: G3 RMS considers all demand staying through a particular date (since only one price point is set). Called Occupancy Demand The remaining price-able unconstrained demand that will stay over an occupancy date in the future. It is limited to market segments that are impacted by pricing changes (all unqualified and all linked qualified market segments) and only applies to the selected Room Class or Room Type..

G3 RMS doesn't account for upgrade fees on or around the date of arrival. However, you can still use Room Class pricing as an indicator to determine the supplement for upgrades. The price difference between Room Classes indicates what the system expects. Whether the difference in Room Class pricing is low or high at a point close to arrival is a strong consideration for setting upgrade supplements.

This relative difference is especially important where the remaining demand is high, and G3 RMS might look for opportunities to sell a Room Class rather than offering discounted upgrades. Where remaining demand is low, the Room Class pricing difference may be lower. You might want to offer lower priced paid upgrades, particularly where lower Room Classes are overbooked. In this case, G3 RMS also plans for required upgrades to maximize revenue from available inventory across Room Classes.