Hotel Revenue Management: Segments, Channel Costs, Comp-Set Indices, Pace & Group Displacement

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn nine months of segment data into ADR and mix, then split the change in the hotel's ADR into a mix effect and a rate effect.
• Take six booking channels from gross to net, total the cost of distribution, compute net RevPAR and value a shift of room nights from an OTA to the hotel's own website.
• Benchmark six months against a comp set with occupancy, rate and RevPAR indices, flag the months that lost RevPAR share and measure September's fair share and penetration.
• Measure last week's pickup, compare ten stay dates with the same time last year, forecast the final rooms sold with a capacity cap and count the dates that are behind.
• Turn arrivals by length of stay into room nights and the average length of stay, then value a 2-night minimum stay on a peak Saturday against selling it open.
• Turn forecast rooms into occupancy, look up the recommended BAR on a rate ladder, derive the advance-purchase rate, value the change against the loaded rate and find how many rooms push a night to the next band.
• Calculate night by night how many transient rooms a group would displace, weigh the group's room revenue and F&B profit against the lost revenue and extra costs, and find the lowest group rate that still breaks even.
• Compare the closed months with the budget, build the full-year outlook from actuals and the latest forecast, measure it against the budget and chart the three lines month by month.