Hotel P&L Forecasting Agent
Forecasts rooms, F&B and other revenue, costs and GOP from business on the books and pickup.
- Industry
- Hotel
- Department
- Finance
- Team
- Planning and Compliance
- Kind
- Decision-maker
- Approver
- Revenue Manager
- Code
- FIN-10
It forecasts each property's revenue, departmental costs, GOP and GOPPAR for the coming months from business on the books, historical pickup, group blocks and their expected attrition, banquet bookings and cost behaviour, and tests the scenarios asked for, such as a rate change, a lost corporate account, a citywide event or a renovation closing rooms. It saves the forecast as a version with its assumptions and a base, upside and downside case.
How it works
7 steps, and a person signs off before step 7.
- 01Looks it up
Finds the record the request is about in the revenue management system: business on the books by segment and stay date, pickup history, group blocks and banquet bookings for the property and horizon..
- 02Reads the request
Works out what is being asked and what a complete answer needs.
- 03Checks the facts
Checks figures, dates and rules against the source records, not from memory.
- 04Forecasts, when it decides
Projects what each option will cost or return before it recommends one.
- 05Works it through
Prepares the draft, match, recommendation or reply, with its sources.
- 06Asks a person
Hands the work to Revenue Manager with its reasoning before anything goes out.
- 07Acts
Once approved, it acts in the planning system: it saves the forecast as a new version with its assumptions and cases. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The forecasting method: on-the-books plus pickup curves by segment and lead time, group wash and attrition history, banquet revenue per group room night, fixed and variable cost behaviour, and the forecast accuracy history.
Reads from
the revenue management system: business on the books by segment and stay date, pickup history, group blocks and banquet bookings for the property and horizon.
Acts in
the planning system: it saves the forecast as a new version with its assumptions and cases.
Hands back
An object with property, months (a list, each with month, occupancy_percent, adr_usd, revpar_usd, rooms_revenue_usd, fb_revenue_usd, other_revenue_usd, gop_usd and goppar_usd for base, upside and downside), scenarios (a list, each with name and gop_change_usd), assumptions (a list) and change_vs_last_official_percent.
Asks a person when
The forecast would become the official version and off is false, a scenario changes rates, staffing or rooms available, or base-case GOP moves more than 5 percent from the last official version.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Expected group wash (%) | 10 | Share of contracted group rooms expected not to be picked up, unless history for the account says otherwise. |
| History used for pickup (months) | 24 | Months of pickup history behind the curves. |
| Downside haircut on transient pickup (%) | 15 | The downside case lowers expected transient pickup by this much. |
| Change from the last official version to flag (%) | 5 | A base-case GOP moving more than this is flagged. |
| Publish as official without review | Off | When off, the official version always goes to the approver. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Forecast rooms revenue as on-the-books plus expected pickup by segment and lead time, from 24 months of history.
- Count group blocks net of 10 percent wash unless the account's history shows otherwise, and apply attrition terms from the contract.
- Flex costs by their behaviour: labour and cost of sales with occupied rooms and covers, undistributed costs mostly fixed.
- Give a base, an upside and a downside case, the downside lowering transient pickup by 15 percent.
- Flag a base-case GOP moving more than 5 percent from the last official version and say why.
- When off is false, the official version goes to the Revenue Manager.
See the Hotel P&L Forecasting Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.