How to build a housekeeping assignment sheet
· housekeeping, scheduling, labor planning
A housekeeping assignment sheet is a one-page list that gives each attendant a set of rooms for the day, built so that every person’s total cleaning minutes are within about a quarter hour of each other, not their room counts. Count minutes, not doors: a checkout takes more than twice as long as a stayover, so one attendant with nine checkouts and another with nine stayovers have the same number of rooms and very different days. The method below takes about ten minutes once you have the day’s room list.
The example is invented: a 62-room two-floor exterior-corridor motel outside Lubbock, Texas, a 24-minute measured checkout clean, an 11-minute stayover, $16/hr placeholder wage and 390 productive minutes per attendant on an eight-hour shift. (That is 480 minutes less a 30-minute break and about an hour of cart setup, linen runs and walking.) Use your own measured times.
The assignment sheet method, in five steps
- List the day’s rooms by type. Checkouts, stayovers, vacant-dirty, and what to skip (vacant-clean, out of order, do-not-disturb with a note).
- Convert to minutes. Checkouts × checkout minutes, plus stayovers × stayover minutes.
- Divide by productive minutes to get the number of attendants. Round up, then look at the utilization.
- Split rooms into zones that follow the building: a wing, a floor, a stretch of corridor. Zones cut walking.
- Balance each zone to the same minutes, by swapping a checkout from the heavy zone for stayovers from the light one.
For the example, today’s board is 26 checkouts, 28 stayovers, and 8 vacant-clean rooms (62 total).
- Checkouts: 26 × 24 = 624 minutes
- Stayovers: 28 × 11 = 308 minutes
- Total: 624 + 308 = 932 minutes
- 932 ÷ 390 = 2.39, so three attendants, at 932 ÷ (3 × 390) = 80% utilization
Two attendants would need 466 minutes each against 390 available. That is how a day runs 76 minutes over per person without anyone planning it.
Balanced by minutes, not by door count
| Attendant | Checkouts | Stayovers | Minutes | Rooms |
|---|---|---|---|---|
| A (first floor, west) | 9 | 9 | 9 × 24 + 9 × 11 = 315 | 18 |
| B (first floor, east and stairs) | 9 | 9 | 315 | 18 |
| C (second floor) | 8 | 10 | 8 × 24 + 10 × 11 = 302 | 18 |
| Total | 26 | 28 | 932 | 54 |
All three have 18 rooms, and the minutes agree within 13. If you balanced strictly by door count the same way on a day with 20 checkouts and 34 stayovers, the split would not be so lucky. For example, 18 rooms of mostly checkouts is 18 × 24 = 432 minutes, which is 42 over the 390 limit, while 18 mostly stayovers is 198.
A copyable layout
Print this at the top of the sheet, one block per attendant:
Date: ________ Day / occupancy: ______ Manager on duty: ______
ATTENDANT: ____________ Start: ____ Cart #: ____
Zone: ____________ Planned minutes: ____ Rooms: ____
ROOM TYPE (CO / SO / VD) PRIORITY NOTES START DONE
101 CO 1 (early) King, extra towel ___ ___
102 SO DND until 11 ___ ___
...
Skips (DND, refused service): ____________
Maintenance / issues found: ____________
Total minutes planned: ____ Total actual: ____
Keep the notes column short. The priority column is for rooms promised to an early arrival; see which rooms to clean first. The “actual” fields are how you correct the minutes next month.
Rules of thumb for the zones
- One floor or one wing per person where you can. Exterior corridors make stairs the expensive part; an attendant crossing a parking lot twice loses ten minutes.
- Mix the type, not the count. If one zone is all checkouts, move two to a neighbour and take back two stayovers.
- Put the longest rooms early. Suites, multi-bed rooms, anything with a kitchenette, before the person tires.
- Give the strongest attendant the odd zone, the one with the awkward stairs or the room with an extra bed.
- Leave slack, at least 20 to 30 minutes. The example sheet at 315 of 390 leaves 75, which is more than the minimum; that is the buffer for the room with a spill, the guest who asks for an extra pillow and the radio call.
How tasks and the sheet fit together
If you generate the day’s cleaning list from room status, the sheet becomes a view of it. In ProfitClock, housekeeping tasks are generated each night in the property’s timezone from room status, and a manager assigns them to attendants, so the board is already a list of the rooms to clean. The balancing is still yours: you decide which attendant gets which tasks. Room status can be updated in bulk, or loaded from a report the property already exports (previewed before it writes), so the morning edit is mostly for the rooms that changed overnight. Taking photos as proof on a task is available if you use it.
When the sheet breaks
- A late checkout list changes the board at 10:00. Re-balance one pair of rooms, not the whole sheet. Swap, do not rebuild.
- A call-out. With 932 minutes and two attendants, the plan is 466 each, over their productive time. The choice is to push stayovers to “on request,” call someone in, or accept overtime; see covering a call-out.
- Your times are guesses. If 24 and 11 are not measured at your property, every total above is off by the same percentage. Time ten rooms of each before you trust the sheet.
- A mixed-skill crew. A new hire does fewer rooms than a seasoned person. Weight the minutes, say 30 minutes for a checkout for them, rather than giving everyone the same list.
A good sheet is boring. Everyone finishes within a quarter hour of each other, nobody is handed the ugly floor three days running, and the minutes written down at 8:00 match the minutes spent by 3:00.
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