Hotel employee schedule template: a weekly grid
· scheduling, labor cost
A good hotel employee schedule template starts with coverage, not with names: list the hours each position must be filled, then assign people to those slots. Below is a weekly grid for an invented 30-room motel with a 24-hour front desk and two part-time housekeepers, followed by the method that produced it, so you can rebuild it for your own property. The names are letters. Replace them, and replace the times with yours.
The grid
Seven days, Monday to Sunday. Front desk runs three eight-hour shifts: Morning 7:00 AM to 3:00 PM, Evening 3:00 PM to 11:00 PM, Night 11:00 PM to 7:00 AM. Housekeeping runs one shift, 9:00 AM to 3:30 PM, with a 30-minute unpaid meal. Cells show who works.
| Position | Mon | Tue | Wed | Thu | Fri | Sat | Sun |
|---|---|---|---|---|---|---|---|
| Desk morning | A | A | A | A | A | D | D |
| Desk evening | B | B | B | B | B | E | E |
| Desk night | C | C | C | C | C | F | F |
| Housekeeper 1 | H1 | H1 | H1 | H1 | H1 | ||
| Housekeeper 2 | H2 | H2 | H2 | H2 | H2 | ||
| Housekeepers on duty | 1 | 1 | 1 | 2 | 2 | 2 | 1 |
How to check it before you post it
Coverage. Count the cells. The desk needs 3 shifts × 7 days = 21 filled slots, and the grid has 21. No slot is empty and none is doubled, which is the first test of any schedule.
Hours. Every desk shift is 8 hours, paid as worked (a desk cannot be left empty for a meal, so assume an on-duty paid meal; check your state’s rule on that). A, B and C each work 5 shifts, which is 40 hours. D, E and F each work 2, which is 16. Housekeepers work a 6-hour paid day (9:00 to 3:30 less 30 minutes). H1 works 5 days, 30 hours. H2 works 5 days, 30 hours. Desk hours: A, B and C give 3 × 40 = 120, D, E and F give 3 × 16 = 48, so 168. Housekeeping is 10 shifts × 6 hours = 60. Total paid hours for the week: 228. Check the desk figure another way: 24 hours × 7 days = 168. It matches.
The 40-hour trap. A, B and C sit at exactly 40.0 hours. That is no cushion. A handoff that runs 10 minutes over every shift puts each of them at 40 hours 50 minutes, and the weekly overtime threshold under federal law is 40 hours in a workweek. Either plan the handoff into the schedule, so the grid is honest about 8 hours 10 minutes, or give one of the three a shorter week and cover the difference with a part-timer. Run any week through the overtime calculator before you post it. One caveat: this check is weekly only. Some states also count overtime by the day, so a long shift can trigger it even when the week is under 40; see daily overtime states and check your own state’s rule.
Rooms. The housekeeper line is the part to test against rooms. At a placeholder 30 minutes per room, a 6-hour paid day with 45 minutes of setup and restocking leaves 315 productive minutes, which is 10.5 rooms at 30 minutes each. Call it about 10 rooms per housekeeper and about 21 for two. On Thursday through Saturday two housekeepers handle about 21 rooms; on Monday, Tuesday, Wednesday and Sunday, one handles about 10. That is roughly a third of this motel’s 30 rooms, so the single-housekeeper days only work when occupancy is around a third or lower, with few full turns to do. Your own minutes will differ, and so will your busy days. See hotel housekeeping schedule window for when in the day the work actually falls.
The method, in six steps
- List the positions and the hours each must be filled. For a motel: desk 24/7, housekeeping 9 to 3:30, and a maintenance or manager block if you have one.
- Decide the shift lengths and the handoff. Overlap costs hours, and it pushes people past their scheduled length. Front desk shift times works through the overlap arithmetic for a 24-hour desk.
- Set the number of people per position per day. Here, one at the desk always, and housekeeping scaled to the busy days.
- Count slots, then assign names to slots. Slots first, because it is easier to see a gap in a grid of letters than in a list of people.
- Total hours by person and check against 40. And against each person’s stated availability.
- Post it, with the date it is posted. Changes after posting are changes to a record. Some states and cities have rules about how far ahead a schedule must be shared. See predictive scheduling laws.
Coverage notes to put on the template
Put these under the grid so they travel with it:
- Desk handoff: Outgoing agent stays until incoming is at the desk. Shift change is 3:00 PM and 11:00 PM.
- Night audit: Night agent completes the day close before 7:00 AM; if it runs late, note how many minutes.
- Call-outs: Who to call first for each position. Housekeeping call-out coverage covers the order.
- Holidays: Which days run a different pattern.
- Time off requests: Where they live, and the deadline for next week’s schedule.
Doing this in a tool
A spreadsheet works fine at this size, and for 30 rooms it is a legitimate choice. What it will not do is show an uncovered slot as you build the week, or what was actually worked against what you planned. ProfitClock’s scheduling lets you set coverage rules and see the week against them; you can look at how scheduling works before deciding. The template above works in either.
When the template breaks
- Fixed grids and changing demand. This week assumes the same shape every week. A group booking on Wednesday needs a different grid. Copy the template and change the cells, not the method.
- More than one department. Maintenance, breakfast and laundry each get their own block of rows. Keep them in one view so one person is not scheduled twice.
- Employees at two properties. Hours across properties add up for the employee, whatever the grid shows. See overtime across two properties.
- Availability. A grid that ignores who can work when produces a perfect schedule nobody can follow.
The grid is a start. The point of the method is that you can rebuild it in twenty minutes when a person leaves.
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