Book companion · chapter 5 · Excel workbook
Rooms Revenue Budget Model
Completed Azure teaching example — USALI 12th Revised Edition compliant structure
Connected publication: Hotel Budgeting and Forecasting in Practice
What this companion is for
This companion is designed to turn the related reading into applied hotel-finance work. It belongs with Chapter 5 of Hotel Budgeting and Forecasting in Practice, where the underlying method, definitions, and management context are explained before the working resource is used.
When to use it
Open this excel workbook while working through Chapter 5 of Hotel Budgeting and Forecasting in Practice, then revisit it when the same planning, review, or control question returns.
Prepare before you start
Before you start, have the relevant source reports, operating assumptions, supporting schedules, and owner or management notes available. Record the inputs you actually used, the conclusion reached, and the follow-up required so the companion becomes part of the working evidence rather than a disconnected download.
This landing page is public so the companion can be found, shared and reached through a QR code. The working file or tool is available after the matching purchase is verified.
Paperback and hardcover purchasers can upload a receipt, invoice or order screenshot. Once the book purchase is approved, all purchaser companions attached to that book use the same entitlement.
Rooms revenue market segments and expense lines follow the Uniform System of Accounts for the Lodging Industry (USALI), 12th Revised Edition, Schedule 1 — Rooms, with distribution-channel analysis kept separate as an optional management view.
- Reconciled prior-year PMS and accounting baseline
- Chapter 4 demand calendar and strategy handoff
- Signed corporate production and rate logic
- Group pipeline after wash
- USALI 12th Revised Edition, Schedule 1 — Rooms, and Part V optional schedules
- Market-segment reallocation of legacy Chapter 4/5 categories into USALI sub-segments
- Synthetic STR-style competitive set: 72.5% occupancy, $160 ADR, $116 RevPAR
- Rooms renovation plan and outage sensitivity
- Sales and marketing action plan by USALI segment
- Guest-value and competitor evidence from Chapter 4