UAE · ENBook a demo
HotelFinanceInvestigator

Hotel Budget and Variance Agent

Builds departmental hotel budgets and explains variances by occupancy, rate, covers and cost.

Hotel Budget and Variance AgentBudgeting Agent · Planning and Compliance
Industry
Hotel
Department
Finance
Team
Planning and Compliance
Kind
Investigator
Approver
General Manager
Code
FIN-09

It builds each property's departmental budget in USALI form, from rooms, F&B and spa revenue driven by occupancy, ADR and covers, to labour by department and undistributed costs, from last year's actuals, the revenue manager's demand outlook and the planning assumptions. Each month it compares actuals with the budget and explains every material variance by its driver, such as occupancy, rate, mix, covers, labour productivity, food cost percentage, timing or miscoding, and proposes reforecast lines where a variance will not reverse. **The problem it solves:** Why actuals differ from budget: each line's variance, the occupancy, rate, covers and labour statistics behind it, the events in the month and what changed in cost.

How it works

6 steps, and a person signs off before step 6.

  1. 01Looks it up

    Finds the record the request is about in the accounting system's general ledger and the revenue management system: actuals by USALI department, statistics (occupied rooms, ADR, covers) and the approved budget for the property and month..

  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. 04Works it through

    Weighs competing explanations against the evidence and shows which one holds up.

  5. 05Asks a person

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

  6. 06Acts

    Once approved, it acts in the planning system: it saves the budget or variance commentary and proposes the reforecast lines. and records what was done.

What it works with

Your knowledge, your systems, your people.

Knows

The budgeting method: USALI departmental structure, the driver model (occupied rooms, ADR, covers and average check, spa treatments), labour standards per occupied room and per cover, cost of sales targets, flow-through expectations and the variance thresholds.

Reads from

the accounting system's general ledger and the revenue management system: actuals by USALI department, statistics (occupied rooms, ADR, covers) and the approved budget for the property and month.

Acts in

the planning system: it saves the budget or variance commentary and proposes the reforecast lines.

Hands back

An object with mode, property, lines (a list, each with department, line, budget_usd, actual_usd, variance_usd, variance_percent, drivers (a ranked list, each with driver, effect_usd, evidence and how_to_confirm)), flow_through_percent, reforecast_lines (a list) and summary.

Asks a person when

It proposes a new budget, a change to an approved budget, or a reforecast.

ApproverGeneral Manager

Settings

Your limits, set by your managers.

SettingDefaultWhat it controls
Variance to explain (%)5A line varying more than this from budget is explained.
Variance to explain (USD)5000A line varying more than this from budget is explained.
Expected flow-through of revenue variance (%)50A revenue variance should move departmental profit by about this share; less is examined.
Wage inflation when none is given (%)4Applied to labour lines when building.
Reforecast after (months of variance)2A variance lasting this long is proposed for reforecast.

Limits are settings, not code: a manager changes them without a developer.

Rules it always follows

  • Build revenue from drivers: occupied rooms times ADR for rooms, covers times average check for each outlet, and treatments for the spa; build labour from the standards per occupied room and per cover.
  • Explain every line varying more than 5 percent or 5000 from budget by its driver, splitting rooms revenue into occupancy and rate effects.
  • Check flow-through: when departmental profit moves less than 50 percent of the revenue variance, explain which costs did not flex.
  • Separate timing and miscoding from real variances before proposing any reforecast.
  • Propose reforecast lines for variances lasting 2 months that will not reverse.
  • Apply 4 percent wage inflation when none is given, and send any new budget or reforecast to the General Manager.

See the Hotel Budget and Variance 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 Budget and Variance Agent · Hotel | Basinwright Industries