Hotel labor variance: scheduled vs worked vs budget
· labor, reporting, scheduling
A hotel labor variance report compares three numbers: the hours you budgeted, the hours you scheduled, and the hours people actually worked. Each gap between them points to a different kind of problem. Budget-to-schedule is a planning gap, the manager’s decision. Schedule-to-worked is an execution gap, what happened on the floor. Budget-to-worked is the total, and the only one that appears on payroll. Reading the three gaps separately tells you which conversation to have and with whom.
The three numbers
Budget hours. What you decided, in advance, a week of this property should cost in hours. It might come from a hours-per-occupied-room target, from last year, or from a fixed minimum coverage. It can be wrong, but it has to exist, or there is nothing to vary from.
Scheduled hours. What the manager posted. This is a plan for the week, not a record.
Worked hours. What the time clock recorded, after approval. This is the only one of the three that is a record. See a schedule is not a time record.
An invented week
An invented 48-room motel, placeholder average wage $16/hr, one week.
| Hours | Gap | |
|---|---|---|
| Budget | 400 | |
| Scheduled | 412 | +12 vs budget |
| Worked | 431 | +19 vs scheduled, +31 vs budget |
Check the arithmetic: 412 minus 400 is 12. 431 minus 412 is 19. 431 minus 400 is 31, and 12 plus 19 is 31. The gaps add. At $16, the 31 hours are $496 of straight-time cost (31 x 16); overtime premium, if any of those hours were overtime, would be extra.
Percentages: 12 / 400 is 3.0%. 19 / 412 is 4.6%. 31 / 400 is 7.75%.
How to read each gap
Scheduled over budget (+12)
This is a decision. Somebody wrote a schedule bigger than the plan. Common reasons:
- A known event the budget did not include. A wedding block, a contractor crew, a holiday weekend.
- Minimum coverage stacking up. Two people on the desk during a shift where the budget assumed one.
- A new hire overlapping with a trainer. Legitimate, and temporary.
- The budget is stale. If the schedule is over budget every week, the budget is the problem.
The question for the manager is “what did you know that the budget did not?” If there is a good answer, the variance is information, not a failure.
Worked over scheduled (+19)
This is what happened. Common reasons:
- Shifts running long. Early arrivals, late clock-outs, an extra twenty minutes every day. See clocking in early and time clock drift.
- Call-outs covered by someone not on the schedule. The schedule did not change, but the hours did.
- Forgotten clock-outs corrected upward. A missed clock-out fixed by estimate often adds hours. Forgot to clock out covers it.
- Unscheduled work. A housekeeper called in on a day off.
It could also run the other way. Worked under scheduled means people were sent home early, or a shift never got filled. That can be good news or a warning, depending on whether the property was understaffed.
Worked over budget (+31)
The total. This is the number an owner feels, and it is the sum of the two gaps. When it is large, resist the urge to react to the total. Split it into the two parts above and talk about each separately: planning with the person who schedules, execution with the person who supervises.
Usual causes, in the order to check them
- Occupancy differed from what the budget assumed. If the budget was set for 70% and the week came in at 82%, more hours were right. Compare hours per occupied room, not total hours, before concluding anything. Hours per occupied room versus headcount explains why.
- Small, steady overruns. Not one big event: ten minutes a shift across thirty shifts.
- Absences covered by overtime.
- A scheduling habit. Always scheduling the same fourth person on Saturday because it has always been done.
- Data problems. Missing punches, duplicate punches, a timezone or workweek boundary that put a shift in the wrong week. See overtime on the wrong day.
What to do with it
For a recurring weekly variance review:
- Put the three numbers and two gaps in one table.
- Compute the percentages. Under about 3% in either gap is usually noise for a small property; over about 5% is worth a question. These thresholds are judgment, not rules; set yours from a few months of your own history.
- For each gap above your threshold, write down one cause before the meeting, and confirm it with the manager.
- If the cause is “budget was wrong,” change the budget.
- Track the same gaps for a month before making any policy change.
ProfitClock records both the schedule and the punches, and sends a daily labor email each morning; reading a daily labor report walks through one, and the time and attendance page describes what is recorded. The budget side you will usually keep in your own spreadsheet.
When this breaks
Variance analysis assumes the three numbers are measured the same way. If the budget includes salaried manager hours and the clock does not, you will see a permanent gap that is no one’s fault. If overtime is allocated by a different workweek than the schedule, the weeks will not line up. And if a property is so small that one absence is 10% of the week, the percentages will bounce; look at hours instead.
Start seeing what labor actually costs
Set up your property, put staff on the clock, and read tomorrow morning’s labor number.
14-day free trial · No credit card · Cancel anytime