Hotel Workforce Analytics Agent
Reports headcount, labour cost per occupied room, turnover and hiring, and explains what moved them.
- Industry
- Hotel
- Department
- HR
- Team
- People Operations
- Kind
- Investigator
- Approver
- Financial Controller
- Code
- HRS-14
It reports headcount and FTE, labour hours and labour cost per occupied room, hires, leavers, 90-day turnover, time to fill and cost per hire by property and department, and explains what drove any significant movement, such as labour cost per occupied room rising while occupancy fell, overtime replacing unfilled roles, or seasonal leavers arriving early. It publishes the report to the BI workspace with headcount that reconciles to the HR system and payroll and every small group suppressed. **The problem it solves:** Why a workforce metric moved: the metric and period, occupancy and covers behind it, overtime and unfilled roles, seasonal effects and what changed in staffing or pay.
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 people analytics warehouse: headcount, hours, labour cost, hires, leavers and requisitions by property and department, with occupancy from the PMS for the period..
- 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 Financial Controller with its reasoning before anything goes out.
- 06Acts
Once approved, it acts in the BI workspace: it publishes the workforce report with its drivers and reconciliation. and records what was done.
What it works with
Your knowledge, your systems, your people.
Knows
The workforce metric definitions (FTE, labour cost per occupied room, covers per labour hour, rooms cleaned per attendant shift), staffing standards by occupancy level, seasonal patterns, the reconciliation rules and the reporting privacy rules.
Reads from
the people analytics warehouse: headcount, hours, labour cost, hires, leavers and requisitions by property and department, with occupancy from the PMS for the period.
Acts in
the BI workspace: it publishes the workforce report with its drivers and reconciliation.
Hands back
An object with metrics (a list, each with metric, property, department, value, prior, change_percent and flagged), drivers (a ranked list, each with movement, driver, evidence and how_to_confirm), reconciliation (an object with hr_system, payroll and difference), suppressed_cells (a count) and summary.
Asks a person when
The report goes to owners, the board or anyone outside HR and the general managers, includes a protected-characteristic breakdown, shows a group small enough to identify people, or headcount does not reconcile within 0.
Settings
Your limits, set by your managers.
| Setting | Default | What it controls |
|---|---|---|
| Smallest group shown | 5 | Cells with fewer people are suppressed. |
| Movement worth explaining (%) | 10 | A metric moving more than this against the prior period or budget is diagnosed. |
| Labour cost per occupied room target (USD) | 48 | Rooms-division labour cost per occupied room above this is flagged. |
| Time to fill target (days) | 21 | Hourly hotel roles filled slower than this are flagged. |
| Allow protected-characteristic breakdowns | Off | When off, no breakdown by protected characteristic is produced. |
| Headcount reconciliation tolerance | 0 | Headcount must match the HR system and payroll within this many people. |
Limits are settings, not code: a manager changes them without a developer.
Rules it always follows
- Reconcile headcount to the HR system and payroll within 0 before publishing.
- Read labour cost per occupied room against occupancy; flag it above 48 and explain whether the cause is volume, rate, overtime or mix.
- Diagnose any metric moving more than 10 percent, ranking drivers by evidence and saying what would confirm each.
- Flag hourly roles filled slower than 21 days and the overtime they caused.
- Suppress any cell below 5 people, and produce protected-characteristic breakdowns only when off is true.
- A report going to owners or the board goes to the Financial Controller first.
See the Hotel Workforce Analytics Agent agent on your own work.
We’ll run it on a sample of your work and show you what your approver would see.