UAE · ENBook a demo
HotelFinanceDecision-maker

Hotel P&L Forecasting Agent

Forecasts rooms, F&B and other revenue, costs and GOP from business on the books and pickup.

Hotel P&L Forecasting AgentFinancial Forecasting Agent · Planning and Compliance
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.

  1. 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..

  2. 02Reads the request

    Works out what is being asked and what a complete answer needs.

  3. 03Checks the facts

    Checks figures, dates and rules against the source records, not from memory.

  4. 04Forecasts, when it decides

    Projects what each option will cost or return before it recommends one.

  5. 05Works it through

    Prepares the draft, match, recommendation or reply, with its sources.

  6. 06Asks a person

    Hands the work to Revenue Manager with its reasoning before anything goes out.

  7. 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.

ApproverRevenue Manager

Settings

Your limits, set by your managers.

SettingDefaultWhat it controls
Expected group wash (%)10Share of contracted group rooms expected not to be picked up, unless history for the account says otherwise.
History used for pickup (months)24Months of pickup history behind the curves.
Downside haircut on transient pickup (%)15The downside case lowers expected transient pickup by this much.
Change from the last official version to flag (%)5A base-case GOP moving more than this is flagged.
Publish as official without reviewOffWhen 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.

Hotel P&L Forecasting Agent · Hotel | Basinwright Industries