Underperforming Hotel Stabilisation Plan & 12-Month Turnaround Tracker: Hotel Turnaround Scorecard, Action Plan and Cash Runway Workbook
Full description
For general managers, asset managers and owners who take over a hotel that misses budget, scores badly with guests or burns cash. The workbook scores the hotel against 12 KPIs with ramp targets at day 30, 60, 90 and month 12, turns the gap into a weighted health score, tracks 61 sample actions (plus 8 spare rows) with owner, dates, tasks done, status and a 12-month Gantt, records 52 weeks of results and cash, and works out the cash runway from a 4-week average burn. A Word plan adds the diagnostic, the 30-60-90 plan, the operating rhythm and the forms. It supports the manager's decisions; the owner and your advisers approve funding and staffing changes.
What is inside
- Turnaround_Tracker.xlsx: 7 tabs, 2,016 formulas, 2 native charts, 27 drop-down and input rules
- Scorecard: 12 KPIs with baseline, targets, healthy level and weight, a health score at baseline and now, and a risk register of 12 sample risks (plus 4 spare rows) rated by likelihood x impact
- Initiatives: 61 sample actions across 10 departments, priority = impact x ease, labels (Done, Running, Do now, Next), statuses (including Overdue and Incomplete row) and a 12-month Gantt that follows the dates
- Weekly Tracker: 52 weekly rows (9 filled with sample data) for occupancy against budget, rate, guest score, defects, labour cost, direct share and cash, with burn, runway and a cash flag
- Dashboard with 7 KPI tiles, a check tile and 2 charts; 8 integrity checks on the Checks tab
- Stabilisation_Plan.docx and PDF: 9 pages with a 10-step two-week diagnostic, the health score method, a 30-60-90 plan, a resource table, the weekly review agenda, a cash runway worked example, a risk register and 3 forms
- README.txt and LICENSE-and-Terms.txt
How it works
- Enter the plan start, as-of date, opening cash and baseline burn on Settings.
- Replace the KPI baselines, targets, healthy levels and weights on Scorecard, then list your actions on Initiatives.
- Add one row a week on Weekly Tracker. Targets, status, burn and runway follow.
- Run the weekly review from the Dashboard and use the Word plan for the agenda and forms.
Details
- Formats: 1 Excel workbook (.xlsx), 1 plan in Word (.docx) and PDF, English
- Software: Excel 2016 or later, or LibreOffice Calc 7 or later
- No macros, no external links, no data tables, no array formulas
- 3 files plus README and license; instant digital download
Good to know
- Sample data is illustrative. Replace it with your own figures. Amounts are in currency units, in thousands.
- Targets, thresholds, runway levels and the sample plan are editable examples. Employment actions, funding terms and owner approvals depend on your contracts and local law. Verify local requirements.
- These files are not legal, financial or tax advice.
- Single-user license. Do not redistribute.
FAQ
What does the health score measure?
Each KPI scores the share of its healthy level reached, from 0 to 100. The score is the weighted average, so you see one number at baseline and one now.
How is the cash runway worked out?
Monthly burn is the average net cash outflow of the last 4 weeks x 52 / 12. Runway is the cash balance divided by that burn. The flag turns Watch and Critical at levels you set.
Can I change the KPIs and targets?
Yes. Rename the KPIs, change the targets, healthy levels and weights. Weights must add to 100; the Checks tab tells you if they do not.
Do I type progress and status?
No. You enter tasks done. Progress, label, status and the Gantt are calculated from the tasks and the dates.
Does it use macros?
No. Every result is a standard worksheet formula.
