A weekly hotel labor budget template you can copy
· labor budget, template, occupancy
A weekly hotel labor budget is a small table that turns your occupancy forecast into hours, and the hours into dollars. Housekeeping hours follow occupied rooms; desk and maintenance hours are mostly fixed by the day. Add them up, price them, add payroll burden, and you have a number to hold the week against. This post gives the layout to copy into a spreadsheet, the formulas, and a worked example on an invented property with placeholder numbers.
The layout
Build two tabs, or two blocks on one sheet. The first is hours by day; the second prices them.
Tab 1: hours by day. One row per day, Monday to Sunday (or your workweek order):
| Column | What goes in it | Formula |
|---|---|---|
| A | Day | |
| B | Rooms available | Your room count, less any out of order |
| C | Forecast occupancy % | Your best guess |
| D | Occupied rooms | =B x C |
| E | Housekeeping hours per occupied room | A constant you choose |
| F | Housekeeping hours | =D x E |
| G | Fixed hours | Desk, maintenance, laundry that do not move with occupancy |
| H | Total hours | =F + G |
Tab 2: dollars. One row per role:
| Column | What goes in it | Formula |
|---|---|---|
| A | Role | Housekeeping, front desk, maintenance |
| B | Weekly hours | Sum from tab 1 |
| C | Average wage | Your actual blended wage |
| D | Wages | =B x C |
| E | Burden % | Payroll taxes, workers’ comp and so on |
| F | Loaded labor cost | =D x (1 + E) |
At the bottom: total loaded labor, forecast room revenue (occupied rooms x average daily rate), labor as a percent of revenue, and total hours per occupied room.
A worked example
An invented 40-room interior-corridor motel outside Bowling Green, Kentucky. Placeholder numbers: housekeeping at 0.5 hours per occupied room (a blend of checkouts and stayovers; calculate yours from your own cleaning times), fixed desk coverage of 16 hours a day, fixed maintenance and laundry of 4 hours a day, average daily rate $85, burden 12%.
Tab 1:
| Day | Occupancy | Occupied | HK hours | Fixed hours | Total hours |
|---|---|---|---|---|---|
| Monday | 50% | 20 | 10 | 20 | 30 |
| Tuesday | 55% | 22 | 11 | 20 | 31 |
| Wednesday | 60% | 24 | 12 | 20 | 32 |
| Thursday | 65% | 26 | 13 | 20 | 33 |
| Friday | 80% | 32 | 16 | 20 | 36 |
| Saturday | 90% | 36 | 18 | 20 | 38 |
| Sunday | 60% | 24 | 12 | 20 | 32 |
| Week | 184 | 92 | 140 | 232 |
Fixed hours are 16 desk plus 4 maintenance and laundry = 20 a day, 140 for the week. Housekeeping hours of 92 are 184 occupied rooms x 0.5.
Tab 2 (placeholder wages: housekeeping $15, desk $16, maintenance and laundry $18):
| Role | Hours | Wage | Wages |
|---|---|---|---|
| Housekeeping | 92 | $15 | $1,380 |
| Front desk | 112 | $16 | $1,792 |
| Maintenance and laundry | 28 | $18 | $504 |
| Total wages | 232 | $3,676 |
Burden at 12%: $3,676 x 1.12 = $4,117.12 loaded.
Forecast room revenue: 184 occupied rooms x $85 = $15,640.
Labor as a percent of room revenue: $4,117.12 / $15,640 = about 26.3%.
Hours per occupied room: 232 / 184 = about 1.26.
Those two ratios are the ones to hold the week against. They are worth more than the dollar figure, since a week with less occupancy will show a lower dollar number and a worse ratio.
How to set the constants
Housekeeping hours per occupied room. Start from your own cleaning times: minutes for a checkout clean and for a stayover, weighted by how many of each you expect. Stayover vs. checkout cleaning time helps you separate them. Add some time for laundry and supervision if they are not in fixed hours.
Fixed hours. Write what the building needs to be open and safe, regardless of occupancy: how many desk hours, whether there is a night position, how much maintenance. These are the hours that make a quiet night look expensive per room, which is expected.
Wage. Use the blended rate of the people who actually work the hours, not the posted starting rate.
Burden. Ask your accountant or payroll provider. Do not copy mine.
What a budget is for
The budget does two jobs.
It sets the week’s hours before the week starts. If Tuesday’s forecast is 55% and the schedule has 40 hours on it, you can see the gap against the 31 the budget supports and do something while the shifts are still editable.
It gives you a comparison after the week ends. Put actual punched hours next to the budget by day. A variance on Saturday means something different from a variance on Tuesday. The daily labor flash email lands in your inbox each morning with the prior day’s labor, which is a convenient thing to hold against the sheet; the budget itself you build and keep.
When this breaks
The forecast is wrong. Every number above flows from the occupancy column. If the forecast misses by ten points, the budget is a plan for a hotel you do not have. Scheduling to a forecast that’s wrong covers how to schedule around it.
Fixed hours are not really fixed. The desk is fixed until you decide it is not. Front desk coverage at a 40-room motel works through that decision.
One ratio for the whole year. Seasonal properties need a different hours-per-room figure in the high and low season. Keep a second copy of the sheet.
It does not include salaried managers. Their hours are real labor even though they are not on the clock. Salaried manager hours missing from labor metrics explains how to add a line for them.
For the benchmarks other operators use to judge the percentage, what is a good hotel labor cost percentage is the place to start, and labor cost by department shows how to split yours.
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