Blog

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):

ColumnWhat goes in itFormula
ADay
BRooms availableYour room count, less any out of order
CForecast occupancy %Your best guess
DOccupied rooms=B x C
EHousekeeping hours per occupied roomA constant you choose
FHousekeeping hours=D x E
GFixed hoursDesk, maintenance, laundry that do not move with occupancy
HTotal hours=F + G

Tab 2: dollars. One row per role:

ColumnWhat goes in itFormula
ARoleHousekeeping, front desk, maintenance
BWeekly hoursSum from tab 1
CAverage wageYour actual blended wage
DWages=B x C
EBurden %Payroll taxes, workers’ comp and so on
FLoaded 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:

DayOccupancyOccupiedHK hoursFixed hoursTotal hours
Monday50%20102030
Tuesday55%22112031
Wednesday60%24122032
Thursday65%26132033
Friday80%32162036
Saturday90%36182038
Sunday60%24122032
Week18492140232

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):

RoleHoursWageWages
Housekeeping92$15$1,380
Front desk112$16$1,792
Maintenance and laundry28$18$504
Total wages232$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