Estimated Occupancy Forecast Report (Cloud)

Estimated Occupancy Forecast Report (Cloud)

The Estimated Occupancy Forecast is a powerful revenue management report designed to help hoteliers anticipate occupancy trends over a selected date range. It combines historical data, trend-based adjustments, and user-entered modifications to provide a dynamic forecast view. This report is part of the PMS's Revenue Management suite and supports different adjustment models to align forecasts with actual performance patterns or expectations.
Path: Revenue Management Live! > Reports

Date Range & Forecast Trend Adjustment

Report Period: The report covers a user-defined date range (e.g., 06/30/25 – 07/14/25).
Trend Adjustment Options: The report can be run using three different Forecast Trend Adjustments:
- None (#1) – No trend adjustment applied.
- Historical Year-Over-Year (#2) – Adjusts forecast using past year’s data as baseline.
- Pickup Year-Over-Year (#3) – Adjusts based on reservations "picked up" compared to same dates in the previous year.
Notes
The default trend adjustment used in the report is determined in the Setup of the Manual Enhanced and can be changed before generating the report.


Report Structure

The report is divided into two main sections: the Estimated Forecast and the Comparison Section.

Estimated Forecast (Left Table)
This section provides the forward-looking forecast, factoring in selected adjustments and user overrides. In cases where no rooms are forecasted, occupancy and ADR will show as 0.
- Date: Forecasted date.
- Day: Day of the week.
- Rooms: Forecasted number of rooms sold.
- Occ %: Estimated occupancy percentage.
- User Adj: Manual adjustment by user (if any).
- Curr ADR: Current Average Daily Rate (ADR).



Comparison Section (Right Table: Historical or Budget)
This section of the report will vary depending on the selected comparison setting. It presents a year-over-year or budget-based variance to help you measure performance expectations.
- Rooms: Number of rooms from last year or budget.
- Occ %: Occupancy percentage from last year or budget.
- User Adj: Any user-entered adjustment applied to the comparative data.
- LY ADR / Budget ADR: Average Daily Rate from the same date last year or from the budget.
Notes
Comparison Modes
When set to Historical (Year-Over-Year), the report displays actual figures from the same dates in the previous year to help track performance against past trends.
When set to Budget, it compares the forecasted data against internal budget values to evaluate alignment with financial planning goals.


Functional Behavior & Insights

Forecast Adjustments Based on Settings
The adjustment logic modifies the baseline data according to the selected trend (e.g., historical or pickup).
For example:
- If set to Historical YR/YR, the forecast includes occupancy estimates plus or minus historical variances.
- If Pickup YR/YR is selected, it reflects reservation pickup velocity versus the same period last year.

Cross-Module Differences
Forecasts shown in the Revenue Management module will differ from those in the Front Office module because:
- Front Office shows raw forecast values.
- Revenue Management applies forecast trend adjustments, providing a more strategic view.

Displaying vs. Adjusting by Budget
While the forecast can be adjusted by historical or pickup trends, it can also optionally display budget variances, if a budget is loaded in the PMS. This allows dual analysis:
- Adjustment is based on historical trend.
- Visual comparison is against budgeted values.

Notes
Key Takeaways
The Estimated Occupancy Forecast blends historical analysis and forward-looking projections.
Trend adjustments ensure the forecast reflects more than just raw reservations.
Customizable outputs include historical comparisons and budget views.
Ideal for strategic planning and real-time decision making.

    • Related Articles

    • Sales & Mktg Groups Forecast Report (Cloud) 🎥

      ? Watch Video The Group forecast report will display a recap of each group currently booked in the system. Path1: Sales & Marketing > Reports > Forecast > Groups Path2: Front Office > Group > Open a Group > Toolbox > Group Forecast Generate report ...

    • Mgmt Occupancy Forecast Report (Cloud) 🎥

      ? Watch Video The Occupancy Forecast report provides a look at what to expect based on the reservations and the rates currently booked within Visual Matrix. Path: Management > Reports > Forecast > Occupancy Forecast Generate report 1. Narrow down ...

    • Sales & Mktg Occupancy Forecast Report (Cloud) 🎥

      ? Watch Video The Occupancy forecast report will display every forecast number based on reservations currently in the system. Path: Sales & Marketing > Reports > Forecast > Occupancy Generate report 1. Narrow down the report using the optional ...

    • Front Office Occupancy Forecast Report (Cloud) 🎥

      ? Watch Video The Occupancy Forecast report offers a predictive view of expected occupancy based on current reservations and their associated rates within Visual Matrix. Please note that these projections may change as new reservations are made, ...

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