FO Yield Management Forecast Report (Cloud) π₯
π₯ Watch Video
Yield management works best when pricing decisions are backed by clear data. The Yield Management Forecast Report shows how many rooms are forecasted to sell at each pricing tier β including the base rate β along with the projected ADR for each tier. This report helps revenue teams understand how demand is distributed across rate tiers and evaluate whether tier strategies are performing as expected.
Path: Front Office > Supervisor > Reports > Yield Management Forecast.
Generating the Report
This report is generated by selecting a date range. Once the dates are set, clicking Refresh calculates forecasted room pickup and ADR values across the base rate and all configured yield tiers.
1. Use the date filters at the top of the report to define your forecast window:
- Set the Start date.
- Set the End date.
The Yield Management Forecast Report always runs for a two-week period. When you change either the Start or End date, the system automatically adjusts the other date to maintain a two-week range.
2. Click Refresh to generate the forecast.
Understanding the Report
The Yield Management Forecast Report displays forecasted room pickup and average daily rate by date, broken down across the base rate and each configured yield tier.
Date Information
- Date β Forecast date.
- Day β Day of the week.
Base Rate Performance
- Base β Rms β Number of rooms forecasted to sell at the base rate.
- Base β ADR β Average Daily Rate for rooms forecasted at the base rate.
Yield Tier Performance (Tier 1 β Tier 5)
Each tier section includes the same two columns:
- Tier X β Rms β Number of rooms forecasted to sell at that tierβs rate.
- Tier X β ADR β Average Daily Rate for rooms forecasted at that tier.
Totals (Bottom of Report) - Totals Row Summary
The Totals row aggregates forecasted performance across the selected date range, including:
- Total rooms forecasted at the base rate and each tier
- Average ADR for each tier over the period
How to Read and Use This Report
This report shows how forecasted demand is distributed across pricing tiers, along with the calculated ADR for each tier. The ADR values shown are not fixed-tier prices β they are averages of the actual rates used on reservations that fell into each tier.
ADR in this report includes all rate variations, such as:
- Discounts
- Promotional rates
- Manual rate overrides
Because of this, the ADR for a tier may be lower or higher than the tierβs published rate, depending on how reservations were priced.
Example: How Tier ADR Is Calculated
For a given date, assume Tier 3 was active when four reservations were taken:
- 2 reservations at the full Tier 3 rate of $184.00
- 1 reservation with a 10% discount at $165.60
- 1 reservation overridden to $99.00
The Tier 3 ADR is calculated as: [(184Γ2)+165.60+99]/4=158.15
Later, when demand increased and the applicable tier shifted from Tier 3 to Tier 4, an additional reservation was taken at the full Tier 4 rate of $194.00, which then contributed to the Tier 4 ADR for that date.
How to Use This Information
- A lower ADR in a tier often indicates discounts or overrides were applied.
- A higher tier capturing reservations signals stronger demand and pricing power.
- Reviewing ADR alongside room counts helps identify whether pricing strategy or discounting is driving performance.
This approach provides a realistic view of pricing behavior and explains why ADR values may not exactly match configured tier rates.
Tips & Use Cases
- Monitor how demand moves between tiers as arrival dates approach.
- Identify compression nights where higher tiers are capturing more demand.
- Confirm whether base rates are holding too much volume.
- Pair with the Occupancy Forecast to understand demand vs. availability.
Still Need Help With This Topic?
Ask Yourself:
- Are rooms concentrating in lower or higher tiers?
- Do ADR changes align with expected demand?
- Should tier thresholds be adjusted?
Support May Ask You:
- What date range was selected?
- Which tiers are active for those dates?
- Are yield rules configured correctly?
Related Articles
Mgmt Yield Management Forecast Report (Cloud) π₯
? Watch Video The Yield Management forecast report will display the daily number of rooms currently booked in the system by tier (base to tier 5) and the ADR for that tier that day. Path: Management > Reports > Forecast > Yield Mgmt Generate report ...FO Occupancy Forecast Report (Cloud) π₯
? Watch Video Accurately forecasting occupancy is critical for pricing, staffing, and operational planning. The Occupancy Forecast Report provides a forward-looking view of expected room occupancy, combining guest reservations, group activity, and ...Sales & Mktg Yield Management Forecast Report (Cloud) π₯
? Watch Video The Yield Management forecast report will display the daily number of rooms currently booked in the system by tier (base to tier 5) and the ADR for that tier that day. Path: Sales & Marketing > Reports > Forecast > Yield Mgmt Generate ...Mgmt Revenue Forecast Report (Cloud) π₯
? Watch Video The Revenue Forecast report provides a quick snapshot at the main revenue metrics that are the occupancy forecast, total revenue and ADR. Path: Management > Reports > Forecast > Revenue Forecast Generate report 1. Narrow down the ...FO Extended Stay Daily Occupancy Report (Cloud)
The Extended Stay Daily Occupancy Report provides a detailed breakdown of hotel performance by guest stay length. It separates short-term guests from extended stays, helping management analyze occupancy, revenue, and rate trends across different ...