Breadcrumbs

Rate Plan Forecast .ng

Rate Plan Forecast Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 🔭 Yield & Forecasting

Target Roles: Directors of Revenue Management, Revenue Analysts, General Managers, Asset Managers, Hotel Controllers, Sales & Marketing Directors

Key Value: Evaluate forward-looking daily revenue and stay demand across individual rate plans, monitor rate code activation and yield performance, track rate plan mapping across market segments, and optimize dynamic pricing and promotional strategy execution.

Executive Summary

The Rate Plan Forecast Report is a primary rate-level forward projection and yield management document within the 🔭 Yield & Forecasting category of the 📈 Revenue & Analytics hub. Designed to deliver granular financial foresight down to specific rate codes, it projects daily room stay production, gross base room revenue, Average Daily Rate (ADR), occupancy contribution, and RevPAR contribution for every active and inactive rate plan code across future arrival dates.

  • By mapping rate plan parameters (Date, Day Of Week, Rate Plan Name, Rate Plan Code) to market segment structures (Market Segment, Market Segment Code, Local Market Segment, Local Market Segment Code) and forward performance metrics (Revenue, Stays, ADR, Occupancy Contribution, RevPAR Contribution), this report enables revenue managers, general managers, and controllers to project rate plan profitability, track forward corporate contract pickup, evaluate promotional rate uptake, and align dynamic pricing yield controls.

Key Capabilities

  • Granular Rate Plan Demand Forecasting: Projects daily stay volume (Stays), gross base room revenue (Revenue), and Average Daily Rate (ADR) across every individual rate plan code (Rate Plan Code) for future stay dates.

  • Hierarchical Market Mapping Alignment: Correlates forward rate plan performance with master corporate market segments (Market Segment, Market Segment Code) and local market classifications (Local Market Segment, Local Market Segment Code) for complete revenue attribution.

  • Forward Occupancy & RevPAR Contribution Tracking: Measures the exact contribution of each individual rate plan toward projected total hotel capacity (Occupancy Contribution) and overall property RevPAR (RevPAR Contribution).

  • Contract & Promotion Yield Monitoring: Evaluates forward demand build across public flexible rates, corporate negotiated plans, advance purchase promotions, loyalty member rates, and wholesale channels.

  • Time-Series Demand Horizon Analysis: Tracks day-by-day forecasted production across specified date ranges to identify projected compression dates, weekday versus weekend rate plan performance, and seasonal demand shifts.

Report Views & Functional Breakdown

The Rate Plan Forecast Report presents rate plan forward demand metrics in a unified single-table ledger that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                    RATE PLAN FORECAST REPORT                           │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Forward Revenue &     │ 2. Market Segment &      │ 3. Daily Stay &  │
│    Yield Projection      │    Code Alignment        │    Contribution  │
└──────────────────────────┴──────────────────────────┴──────────────────┘
1. Forward Revenue & Yield Projection

Monitors projected base room revenue generation and Average Daily Rates across individual rate plan codes.

  • Primary Use: Evaluating which specific rate plans are projected to generate the highest accommodation revenue (Revenue), auditing rate yield premiums (ADR), and identifying top promotional and corporate rate codes for future dates.

  • Key Metrics: Rate Plan Code, Rate Plan Name, Revenue, Stays, ADR.

2. Market Segment & Code Alignment

Tracks how individual forward rate plan codes map into corporate and local market segment hierarchies.

  • Primary Use: Verifying forward corporate agreement mapping, auditing promotional rate plan segmentation, and ensuring accurate revenue bucketing across transient, corporate, group, and wholesale categories.

  • Key Metrics: Rate Plan Code, Rate Plan Name, Market Segment, Market Segment Code, Local Market Segment, Local Market Segment Code.

3. Daily Stay & Contribution Analysis

Tracks projected daily room night production and calculates rate plan contribution to overall hotel capacity and RevPAR.

  • Primary Use: Measuring forward daily stay volume (Stays), analyzing day-of-week demand patterns, and evaluating rate plan contribution to projected occupancy (Occupancy Contribution) and property yield (RevPAR Contribution).

  • Key Metrics: Date, Day Of Week, Rate Plan Code, Stays, Occupancy Contribution, RevPAR Contribution, Revenue.

Image 10-9-26 at 2.47 PM.png
Rate Plan Forecast

Data Dictionary (Dynamic View Columns)

Customize your default view using the Configure (⚙️) icon on the report page. Below is the full data dictionary representing every column available in this report:

💡 Monetary & Rate Calculation Note: Revenue and ADR represent Base Room Revenue (Excludes Taxes & Non-Room Charges). ADR is calculated as ADR = Revenue ÷ Stays.

Column Name

Description

Data Source / System Mapping

Includes Taxes & Fees?

Date

Projected calendar date of the reported stay production (e.g., 2026-10-09).

Reservation System > Target Stay Date

N/A

Day Of Week

Corresponding day of the week for the stay date (e.g., Friday, Saturday).

System Calendar > Day Of Week

N/A

Rate Plan Name

Full descriptive title of the rate plan or corporate contract (e.g., BEST FLEXIBLE, FEDROOMS).

Rate Plan Setup > Rate Name

N/A

Rate Plan Code

Official alphanumeric code assigned to the rate plan (e.g., IDME0, IL5FP, IDU25).

CRS / PMS > Rate Code

N/A

Market Segment

Full name of the master market segment mapped to the rate plan (e.g., DISCOUNT AND TRANSIENT DISCOUNT).

PMS > Market Segment Title

N/A

Market Segment Code

Master market segment category code (e.g., D, W, V, P, L, C, Y, G).

PMS > Market Segment Code

N/A

Local Market Segment

Property-specific local market segment title (e.g., Government Individual, NONE).

PMS > Local Market Title

N/A

Local Market Segment Code

Property-specific local market segment category code (e.g., M, NONE).

PMS > Local Market Code

N/A

Revenue

Projected gross base room revenue generated by stays on the rate plan on the date.

SUM(Projected Rate Plan Room Revenue)

❌ No

Stays

Total physical room nights / stays projected for the rate plan on the date.

SUM(Projected Stays by Rate Plan)

N/A

ADR

Average Daily Rate projected per room stay for the rate plan ($\text{Revenue} \div \text{Stays}$).

Revenue / Stays

❌ No

Occupancy Contribution

Proportion of total available room capacity projected to be contributed by the rate plan on the date.

Stays / Total Available Rooms

N/A

RevPAR Contribution

Revenue Per Available Room projected to be contributed by the rate plan on the date.

Revenue / Total Available Rooms

❌ No

Customization & Platform Features

User & Property Preferences

  • Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.

  • Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into the below logical blocks.

    • Time & Date Tracking (Cols 1–2): Date | Day Of Week

    • Rate Plan Identification (Cols 3–4): Rate Plan Code | Rate Plan Name

    • Market Segmentation Mapping (Cols 5–8): Market Segment Code | Market Segment | Local Market Segment Code | Local Market Segment

    • Volume & Revenue Production (Cols 9–10): Stays | Revenue

    • Yield & Performance Metrics (Cols 11–13): ADR | Occupancy Contribution | RevPAR Contribution

Report Toolbar & Quick Actions

Use the top-right toolbar icons on the report page to manage and export your data view:

Icon

Action / Feature

Description
Image 9-29-26 at 1.04 PM.png

Knowledge Article

Opens the knowledge base article to learn how to interpret this report.
Image 9-29-26 at 12.37 PM.png

Saved Views

Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.
Image 9-29-26 at 12.51 PM.png

Bar Chart

Displays report data in a visual bar chart format.
Image 9-29-26 at 12.39 PM.png

Filter

Opens filter controls to isolate specific data within a column based on your selected criteria.
Image 9-29-26 at 12.40 PM.png

Highlight

Highlights column values in a designated color based on selected conditions.
Image 9-29-26 at 12.42 PM.png

Export

Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.
Image 9-29-26 at 12.43 PM.png

Configure

Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.
Image 9-29-26 at 12.44 PM.png

Additional Configuration

Provides advanced report configuration and display formatting options to customize data presentation.
Image 9-29-26 at 12.53 PM.png

Group By

Summarize and group report data dynamically in real time.
Interactive Visualizations & Grouping Controls

  • Group By & Pie Chart Visualization: The Rate Plan Forecast report features an interactive pie chart to help analyze forward market segment mix and projected demand distributions. Users can group forward rate performance entries on the fly by Market Segment to evaluate rate plan demand trends over future weekly or monthly horizons. By selecting a metric from the Select Base Column dropdown menu—such as occupancy_contribution, Revenue, or Stays—the chart dynamically renders percentage share breakdowns accompanied by an interactive color-coded legend.

Image 10-9-26 at 2.48 PM.png
Group By & Pie Chart Visualization

  • Bar Chart Visualizer: The Rate Plan Forecast report includes an interactive bar chart to help visualize forward rate plan demand, contribution, and projected revenue trends over time. By adjusting the Select Column (Y-Axis) dropdown menu, users can dynamically toggle the chart view to plot metrics such as Occupancy Contribution, Revenue, or Stays chronologically alongside the detailed forecast data grid.

Image 10-9-26 at 2.53 PM.png
Bar Chart Visualizer
Advanced Controls

  • Exporting & Rate Strategy Analysis: Download in Excel or PDF format to support weekly revenue strategy meetings, corporate contract pickup audits, and promotional rate evaluations.

  • Filtering: Filter data by specific Rate Plan Code, isolate top-producing rate plans, or filter by Market Segment.

  • Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-revenue projected rate codes, zero-stay dates, or low-ADR performance periods.

Within 📈 Revenue & Analytics & 🔭 Yield & Forecasting:

  • Rate Group Forecast – Forward demand projection evaluating revenue and occupancy across HotelKey rate group buckets.

  • Booking Pace – Multi-section tracking report evaluating pickup velocity across Revenue, Rooms Sold, ADR, and Occupancy.

  • Occupancy Forecast and History – Comprehensive daily overview tracking historical and forecasted occupancy, revenue, and movement counters.

Cross-Pillar Deep Dives: