Free tool · Hotel
Hotel KPIs
Log each night's rooms sold, room revenue, no-shows, rooms out of order and complaints, or paste them from the PMS export. See occupancy, ADR and RevPAR month to date against the budget, the forecast for the month, the weekday pattern, the revenue that leaked, and the KPI to work on first, ready to copy as the morning report.
Paste from Excel or CSV
One row per day, columns in this order: date, rooms available, rooms sold, room revenue, other revenue, arrivals, depa
3 · Log
| Date | Sold | Available | Occupancy | Room revenue | ADR | RevPAR | No-shows | Out of order | Complaints | Cause | Remove |
|---|
No days logged yet. Add the first one above, paste from Excel, or .
The guide · Edition 3 · Page 31
How t o use this t ool, in the guide
Why each tool exists, which family it belongs to and how to use it step by step, in one book you can leaf through.
Feedback
Did this t ool help you?
Your work
All your work in one file
Every tool keeps your work only in this browser. Save it as one file to keep a copy, to carry on from another phone or computer, or to hand it to a colleague. Nothing is uploaded.
Works offline too: once a tool has been opened on this device, it and the other tools of its role open without a connection.
- Last mile · WeeklyLast-Mile CX Control
T owerPerfect Delivery per order, on time, incomplete, damage, cold chain, loading and departures, partner and driver scorecards, route risk, root-cause Pareto, actions and a weekly review. A deep dive on one failure: where it concentrates, the evidence rows and an investigation that becomes a verified action. Reads your Excel workbook.→ - Diagnostic · 2 minKPI DiagnosticA number turned red. Ten statements show whether the cause is clarity, skill, capacity, process design or ownership, with first moves for each.→
- Root causes · 5 minPar
e t o 80/20Which few causes make most of your delays, errors, idle time or complaints? Templates for delivery, warehouse and hotel, CSV and Excel import, a checked chart.→ - Problem solving · 20 minA3 Repo
r tOne problem on one sheet, the Toyota way: the facts and the number, the target and its date, the root cause, countermeasures with an owner each, and the follow-up. An eight-point check, print on A3 or A4, Word.→ - Improvement · WeeklyKaizen BoardEvery improvement idea of the team on one board, from Idea through Plan, Do and Check to Adopted, with an effort and impact matrix that shows the quick wins. Adoption rate, days to adopted, savings per month and year, and the idea of the month.→
- People · 15 minSkills MatrixRate each person on each task from 0 to 4 in an ILU grid, with templates for warehouse, hotel front office and delivery station. Cover against target, single points of failure, cover per shift and a training plan that pairs a level 4 with a trainee, straight into actions.→
- Equipment · OngoingOEELog each shift of a machine with its stops, pieces and rejects. Availability, performance, quality and OEE, the six big losses day by day, and the one to attack first.→
- Lean · 15 minGemba WalkLayered process audits by team lead, area manager and site lead, with yes or no checks on the standard for warehouse, hotel and delivery station, and a waste walk that counts the 8 wastes, Mura and Muri. Compliance per week and layer, where the no answers sit, which layer is late, and findings straight into actions.→
- Report · 5 minOperations Repo
r tThe weekly or monthly report for your manager, written from the data of the other tools: safety, quality, delivery, OEE, 5S, hotel, Kaizen and actions, each against the period before and its target. What got better, what got worse, the biggest risk, one decision and three priorities. Text, A4 or Word.→ - Hotel · 5 minRoom InspectionCheck a cleaned room before it is released: pass, fail or n.a. by zone, critical items that fail the room on their own, a photo of the fault. Re-cleans go back to the attendant, maintenance to the Action Tracker; the first-time pass rate per attendant, floor and room type shows where to coach.→