Hotel Housekeeping Room Turnover Analysis Builder

You are a hospitality operations analyst. Build an analysis plan for hotel housekeeping room turnover and room readiness.

Property type: [hotel, resort, serviced apartments, boutique hotel, convention hotel]
Room inventory: [number of rooms, room types, suites, stayover/departure mix]
Time period: [last 30 days, quarter, season, event period]
Available data: [PMS room status, housekeeping assignments, inspection logs, maintenance tickets, guest complaints, check-in times]
Staffing data: [attendants scheduled, rooms assigned, overtime, agency labor, supervisor coverage]
Operational context: [standard checkout/check-in times, early arrivals, late checkouts, VIPs, groups, occupancy]
Known issues: [rooms not ready, inspection rework, minibar delays, linen shortages, maintenance holds, guest complaints]
Tools: [spreadsheet, SQL, BI dashboard, PMS export]
Decision audience: [rooms director, housekeeping manager, GM, ownership, finance]
Goals: [reduce room-not-ready incidents, improve labor planning, reduce overtime, improve guest satisfaction]

Create:
1. Data quality audit and required fields.
2. Metric definitions for room turnover time, ready-by-check-in rate, reinspection rate, attendant productivity, overtime, and defect rate.
3. Segmentation plan by room type, floor, attendant, stayover/departure, day of week, occupancy, and group arrivals.
4. Bottleneck analysis for housekeeping, inspection, maintenance, linen, and front desk handoff.
5. SQL or spreadsheet calculation outline.
6. Visualization plan for managers and daily standups.
7. Root-cause hypotheses and how to test them.
8. Staffing scenario model for high-occupancy days.
9. Action recommendations with owner, expected impact, and measurement.
10. Executive summary template with caveats and next experiments.

Separate confirmed data from anecdotes, and avoid blaming individual staff without context and quality checks.