Housekeeping efficiency index

Housekeeping was drifting with no oversight. The worry is simple: one slow housekeeper drags the whole team, and wasted labor-minutes scale across ten hotels. I wanted real, fair visibility, not a hunch about who is quick.

The metric

Efficiency Index is earned cleaning-credit-minutes divided by worked-minutes, per housekeeper, per day. Each room carries a credit value by room type and clean type. Worked-minutes come from actual clock data, net of breaks. 1.0 is on-standard, above is faster, below is slower.

The first version divided period totals and produced a wide, unfair spread. It was wrong, and being wrong fairly mattered more than shipping fast.

Paid hours include laundry, coverage, and public-area work that carries no room credits, which crushes some people unfairly. The fix was strict same-day pairing: only credits and hours from days the person actually cleaned, and flag the days where hours far outrun credits instead of judging them.

• Cleaning credits pulled from the housekeeping board and its analytics API
• Worked-minutes from Gusto, joined per person with a name-alias map per property
• A Python engine plus per-hotel dashboards and a portfolio index, including labor cost per occupied room

Live across the portfolio, refreshed nightly. It surfaces the outliers and the context behind them, so I can ask a real question instead of hovering over the crew. That is the analyst seat of an HR department, running on a schedule.