Review pickup, pricing, and hotel revenue forecasts
Compare booking pace, cancellations, occupancy, ADR, and RevPAR before the revenue meeting.
What you’ll produce
A source-linked scenario table with assumptions and questions for the revenue manager.
Inputs & connections
- Approved occupancy, pickup, ADR, and cancellation exports
- Revenue manager assumptions and known event dates
Begin with approved exports or pasted source material. Live access requires separately configured integrations and permissions; this guide does not install them.
Your starting prompt
Replace the bracketed fields. This is our suggested prompt, not a quote from the source.
Prepare a revenue review for [property] and [stay-date range] using [dated PMS and revenue exports]. Reconcile rooms sold, rooms available, cancellations, and room revenue. Define net pickup as the change in rooms on the books for the same stay dates between the supplied snapshots. Compare booking pace at the same lead time, with weekday and seasonal differences noted. Compute occupancy as rooms sold / rooms available, ADR as room revenue / rooms sold, and RevPAR as room revenue / rooms available; mark ratios with zero denominators as not calculable and use consistent inventory and revenue definitions. Show formulas and distinguish actuals, on-the-books values, and forecasts. Explain unusual dates using verified event or aviation evidence where available, without claiming causation. Compare only the supplied scenario assumptions, show uncertainty, and list questions on pricing, distribution, and stay restrictions. Do not change rates or invent forecast values.
How to run it
- 01
Agree the decision and reporting period with the revenue manager.
- 02
Reconcile inputs and define scenario assumptions outside the model.
- 03
Generate the brief and recompute key totals in a spreadsheet.
- 04
Discuss the scenarios and record approved decisions with an owner.
Review before you act
Revenue staff verify formulas, inventory definitions, event context, and the difference between forecast and actuals.
Limitations & success checks
- Forecasts are uncertain and can miss local changes.
- Vendor forecasting capabilities are not recreated by a prompt alone.
Measure: Reconciliation errors, assumptions documented, and decisions traceable to inputs.
Sources & attribution
The sources below support the reported example or a tool capability. They do not validate our prompt or prove the outcome in your environment.
Product page describes hospitality forecasting and decision support. This guide proposes a manual scenario review, not autonomous rate changes.
Creator / publisher: Cloudbeds
Editorial review: 2026-10-12. How we label evidence.