Housekeeping schedule template, built from checkouts
· housekeeping, scheduling, labor cost
A housekeeping schedule template should size the crew from forecast checkouts and stayovers, not from a fixed headcount: minutes of work for the day divided by productive minutes per housekeeper gives the number of shifts. Below is the formula, a week built from it for an invented motel, and the roster it replaces. For when in the day the work lands, see the housekeeping schedule window; this post is about how many people.
The formula
For each day:
Shifts needed = (checkouts × minutes per checkout + stayovers × minutes per stayover) ÷ productive minutes per shift
Three inputs, all of which should be your own measured numbers rather than ours.
- Minutes per checkout. A departure clean, a full turn. Placeholder: 30.
- Minutes per stayover. A refresh of an occupied room. Placeholder: 15. If your policy is to clean stayovers only on request, this number drops. See stayover cleaning on request.
- Productive minutes per shift. Not the paid minutes. Placeholder: 390 of the 450 paid minutes in a 7.5-hour shift. The economy hotel housekeeping quota shows how that figure is built from a shift, and cart setup and restock minutes shows how to measure the minutes lost to setup.
Every housekeeper-shift is then 7.5 paid hours (450 minutes) and 390 productive minutes.
The week, worked
An invented 52-room exterior-corridor motel. Checkouts and stayovers come from the front desk’s forecast, built from reservations on the books plus a typical number of walk-ins. Placeholder wage $16 an hour.
| Day | Checkouts | Stayovers | Work minutes | Shifts needed | Schedule |
|---|---|---|---|---|---|
| Mon | 14 | 16 | 660 | 1.69 | 2.0 |
| Tue | 12 | 14 | 570 | 1.46 | 1.5 |
| Wed | 13 | 15 | 615 | 1.58 | 2.0 |
| Thu | 16 | 12 | 660 | 1.69 | 2.0 |
| Fri | 20 | 14 | 810 | 2.08 | 2.5 |
| Sat | 24 | 18 | 990 | 2.54 | 3.0 |
| Sun | 22 | 20 | 960 | 2.46 | 2.5 |
Check two rows. Monday: 14 × 30 = 420, plus 16 × 15 = 240, equals 660 minutes; 660 ÷ 390 = 1.69. Saturday: 24 × 30 = 720, plus 18 × 15 = 270, equals 990; 990 ÷ 390 = 2.54.
The schedule column rounds up to the nearest half shift, where a half shift is about 3.75 paid hours. A half-shift crew must still cover the work: Tuesday’s 1.5 shifts is 585 productive minutes, more than the 570 needed. Wednesday’s 1.58 does not fit in 1.5 (585 minutes against 615 needed), so it goes to 2.0. Sunday’s 2.46 fits in 2.5, which is 975 minutes against 960.
Total scheduled: 2.0 + 1.5 + 2.0 + 2.0 + 2.5 + 3.0 + 2.5 = 15.5 shifts, which is 15.5 × 7.5 = 116.25 paid hours, or $1,860 at $16.
What a flat roster costs
Most small motels run the same crew every day, and the table above shows why that overstaffs the slow days. Against a flat three-a-day roster (21 shifts), this week’s 15.5 shifts leave a surplus of 5.5 shifts, which is 41.25 paid hours or $660 at $16. The surplus is largest on Tuesday (1.5 shifts), with Monday, Wednesday and Thursday each carrying a full spare shift; Friday and Sunday carry half a shift and Saturday none. The full comparison, including what a flat two-a-day roster does to the weekend, is in weekend vs weekday housekeeping staffing.
People also want predictable schedules, and some states and cities regulate changes to posted schedules. A workable compromise is to fix a base crew (say two a day) and add the extra shifts on the forecast days with two weeks’ notice, or whatever your state or city requires. See predictive scheduling laws.
Building the template
Make a sheet with these columns and copy it each week. A blank version of the layout, one row per day:
| Day | Fcst checkouts | Fcst stayovers | Work min | Shifts needed | Scheduled | Names | Actual C/O | Actual S/O | Actual hrs |
|---|---|---|---|---|---|---|---|---|---|
| Mon | |||||||||
| Tue | |||||||||
| Wed | |||||||||
| Thu | |||||||||
| Fri | |||||||||
| Sat | |||||||||
| Sun | |||||||||
| Week |
The columns, in the order you fill them in:
- Date and day.
- Forecast checkouts and stayovers. Source: your reservation system, or the front desk’s count from a report the property already exports.
- Work minutes. The formula above.
- Shifts needed. Work minutes ÷ productive minutes per shift.
- Scheduled shifts. Rounded up to a half shift.
- Names. Fill after you have the numbers, matched to availability.
- Actual checkouts and stayovers, and actual hours (after the fact).
The actual-hours entries matter most, because it is how the placeholders turn into your own numbers. After four weeks, compare the actual hours per room with the 30 and 15. If they differ, change the inputs, not the staff. Pairing the schedule with measured room minutes is what hours per occupied room vs headcount describes.
The half-shift rounding rule
Round each day’s shifts needed up to the next half shift, then check that the rounded figure still covers the work: scheduled shifts × 390 must be at least the work minutes. A half shift is a person on about 3.75 paid hours, or a full-shift person starting late or leaving early, so decide on the property which it is and write it on the sheet. If the rounded figure covers the work by a wide margin, as with Tuesday above, keep it; if the work is 5 minutes past a half-shift boundary, consider whether stayovers on request or a manager helping closes it, rather than adding a person for 5 minutes.
The fill-in sheet, in order
- Copy last week’s sheet and clear the forecast, scheduled and actual columns.
- Enter forecast checkouts and stayovers for each day.
- Multiply and add: checkouts × your checkout minutes, plus stayovers × your stayover minutes.
- Divide by productive minutes per shift and round up to the half shift.
- Add the Scheduled column down and multiply by 7.5 for paid hours, then by the wage for a pay estimate.
- Add names against availability, then post the sheet.
- After the week, fill in the actual columns.
If you would rather run the day from a task list than a sheet, ProfitClock’s housekeeping tools cover task assignment with photo proof and room status updates, including by CSV import of a report the property already exports. The forecasting step above is still yours.
When this breaks
- The forecast is wrong. Occupancy forecasts miss. Build in a trigger (for example, send someone home early if departures are 20% under, call in if 20% over). See sending housekeepers home early and scheduling to a forecast that’s wrong.
- Room types. A suite takes longer than a standard room. Weight the minutes, or add a separate column.
- Deep cleans and linen. Those are not in the formula. Add them as fixed blocks on slow days. See deep clean and maintenance labor.
- Different speeds. The formula assumes an average housekeeper. A new hire may run at 120% of your placeholder minutes for weeks.
- Weekly overtime. Any one person near 40 hours changes the answer. Check with the overtime calculator.
The template is a method for deciding how many, not who. The who is your availability sheet and your judgment.
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