Housekeeping Schedule Calculator

Those three figures only depend on Total Rooms, Occupancy Rate, and Checkout Rate -- Shift Length describes how housekeeping staff time is structured, which is a separate question from how many rooms are occupied or checking out. The room-count math and the staffing math are calculated independently and then combined.

No -- Shift Length pulls in two directions at once: a longer shift means each housekeeper covers more cleaning minutes, so fewer housekeepers are needed (which lowers cost), while each housekeeper is also paid for more hours per shift (which raises cost). The headcount-reduction effect wins out over the full range, so Daily Labor Cost trends down as Shift Length increases, even though the per-housekeeper pay effect is real. Because Housekeepers Needed always rounds up to a whole person, that downward trend isn't perfectly smooth -- a specific Shift Length change can occasionally nudge cost up if it happens to tip the rounded headcount over a threshold, so don't expect every single step to move the same direction.

Avg Minutes/Room is Total Cleaning Minutes divided by Occupied Rooms -- both of those figures come from room counts and per-room clean-time standards, with no reference to how the shift is structured. Shift Length only enters the calculation later, when converting total cleaning minutes into a headcount.

Housekeepers Needed rounds the ratio of Total Cleaning Minutes to one housekeeper's effective working minutes up to the next whole person. At the default inputs, that ratio sits close to a whole-number threshold, so a change to almost any input -- Total Rooms, Occupancy Rate, Checkout Rate, either clean-time figure, or Shift Length -- can be enough to push the count over that threshold, each producing a similarly sized one-person jump.

Total Cleaning Minutes is Stayover Rooms times Stayover Clean Time, plus Checkout Rooms times Checkout Clean Time -- treating stayover and checkout rooms as needing different amounts of cleaning time, since a full checkout clean is more thorough than a stayover service. It has no dependence on Shift Length, which only comes into play afterward when converting this workload into a staffing count.