Hotel Budget and Variance Agent
Builds departmental hotel budgets and explains variances by occupancy, rate, covers and cost.
- 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.
- 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..
- 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.
- 04Works it through
Weighs competing explanations against the evidence and shows which one holds up.
- 05Asks a person
Hands the work to General Manager with its reasoning before anything goes out.
- 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.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Variance to explain (%) | 5 | A line varying more than this from budget is explained. |
| Variance to explain (USD) | 5000 | A line varying more than this from budget is explained. |
| Expected flow-through of revenue variance (%) | 50 | A revenue variance should move departmental profit by about this share; less is examined. |
| Wage inflation when none is given (%) | 4 | Applied to labour lines when building. |
| Reforecast after (months of variance) | 2 | A 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.