8-Week Revenue Management System (RMS) Module

Course Description:
This module introduces students to the principles and tools of hotel Revenue Management. Students will learn how to analyze demand, set dynamic pricing, manage channel distribution, and maximize hotel RevPAR using a Revenue Management System (RMS).

Week 1: Introduction to Revenue Management & System Navigation

Objective: Understand core revenue management concepts and navigate the RMS dashboard.

Workflow Focus: System Orientation & KPI Fundamentals

Hands-on Exercise 1:

  1. Log into the RMS and explore the dashboard. Identify key KPIs: Occupancy Rate, ADR, RevPAR.
  2. Review the Demand Calendar and identify high-demand and low-demand dates for the next 30 days.
  3. Set up the hotel's room type inventory (e.g., Standard, Deluxe, Suite) with their base rates.
  4. Compute manually: RevPAR = Occupancy % × ADR. Compare with system-calculated value.

Week 2: Rate Plans & Pricing Strategy

Objective: Create and manage rate plans for different guest segments.

Workflow Focus: Rate Plan Setup

Hands-on Exercise 2:

  1. Create 3 rate plans: Rack Rate, Corporate Rate (15% discount), and OTA Rate (Booking.com - 20% discount).
  2. Set blackout dates for each rate plan (e.g., holidays when discounts are restricted).
  3. Apply a weekend surcharge of 10% to the Rack Rate for Friday and Saturday nights.
  4. Verify rate plan logic by simulating a 3-night booking under each rate plan.

Week 3: Dynamic Pricing & Yield Management

Objective: Apply dynamic pricing rules based on occupancy thresholds.

Workflow Focus: Yield Management & Price Optimization

Hands-on Exercise 3:

  1. Set pricing rules: if occupancy > 80%, increase BAR rate by 15%. If occupancy < 40%, decrease by 10%.
  2. Simulate a scenario where occupancy hits 85% and verify the system auto-adjusts rates.
  3. Apply a Length-of-Stay restriction (minimum 2 nights) for a peak weekend date.
  4. Review the Revenue Impact Report before and after dynamic pricing changes.

Week 4: Channel Management & Distribution

Objective: Manage room availability and rates across multiple booking channels.

Workflow Focus: Channel Distribution

Hands-on Exercise 4:

  1. Connect 3 booking channels: Direct Website, Booking.com, and Expedia. Set allotments for each.
  2. Close availability on Booking.com for a specific date while keeping Direct Website open.
  3. Sync a rate update across all channels simultaneously using the Channel Manager.
  4. Review the Channel Production Report and identify which channel generates the most bookings.

Week 5: Forecasting & Demand Analysis

Objective: Use historical data to forecast future demand and plan pricing accordingly.

Workflow Focus: Demand Forecasting

Hands-on Exercise 5:

  1. Generate a 30-day Demand Forecast report and identify the top 5 highest-demand dates.
  2. Compare current booking pace vs. same period last year (Pick-Up Report).
  3. Recommend rate adjustments for the top 5 high-demand dates with justification.
  4. Set up a Rate Alert to notify when a specific date's occupancy exceeds 70%.

Week 6: Competitor Rate Benchmarking

Objective: Analyze competitor pricing and position hotel rates strategically.

Workflow Focus: Competitive Intelligence

Hands-on Exercise 6:

  1. Set up a competitive set of 3 nearby hotels in the RMS benchmarking tool.
  2. Run a Rate Shopping report for the next 14 days and compare rates vs. competitors.
  3. Identify dates where the hotel is priced higher than competitors despite low occupancy.
  4. Propose and implement rate adjustments to improve competitiveness on those dates.

Week 7: Revenue Reports & Performance Analysis

Objective: Generate and interpret revenue reports for management decision-making.

Workflow Focus: Revenue Reporting

Hands-on Exercise 7:

  1. Generate a Month-to-Date (MTD) Revenue Report and compute total room revenue.
  2. Generate a Segment Analysis Report to compare revenue by guest type (Leisure, Corporate, Group).
  3. Calculate and interpret: ADR, RevPAR, and GOPPAR for the current month.
  4. Present a brief Revenue Management summary presentation to the class.

Week 8: Comprehensive Simulation (Final Practical Exam)

Objective: Apply all revenue management skills in a continuous real-world scenario.

Workflow Focus: End-to-End Revenue Management Operations

Hands-on Exercise 8 (Simulation Scenario):