Hotel Housekeeping Operations: Room Credits, Attendant Staffing, Linen Par Levels, Laundry & Amenity Costs, Inspections and Cost per Occupied Room

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn a week's forecast of departures, stay-overs and deep cleans into cleaning minutes and room credits per day, add up the week and see how much of the workload the stay-overs cause.
• Work out the productive minutes of a shift, the full shifts each day's workload needs, and how many part-time shifts cover what the core team cannot do.
• Count the attendants scheduled each day, compare them with the shifts needed, find the days that are short and check the weekend pattern with COUNTIFS.
• Set the par stock for eight linen items, find how many pieces to buy to reach par, and budget the yearly replacement of lost and worn-out pieces.
• Turn occupied rooms into laundry kilograms, cost a year of laundry with an outside laundry and in-house, find the yearly saving and the monthly volume where in-house starts to pay.
• Cost the amenities of three room types per occupied night with SUMPRODUCT, add the wastage, find October's amenity cost and the weighted average cost per occupied room.
• Measure each attendant's rooms per hour and re-clean rate, pool the department's re-clean rate and flag who needs a review because speed, quality or score misses its target.
• Cost October's housekeeping labour, turn every cost line into a cost per occupied room, compare the total with the budget and chart the half-year trend of actual vs budget.