Chapter 5Rooms Revenue Budget Model
Convert the approved rooms strategy into a monthly model of capacity, segment demand, ADR, gross revenue, channel cost, analytical net value, risk adjustments, scenarios, and downstream handoffs.
Questions this chapter helps answer
- How should a hotel convert rooms market strategy into monthly capacity, segment demand, pricing, and Rooms Revenue?
- How should channel economics and net room value be reflected when building a hotel rooms revenue budget?
- What operating and management handoffs should follow when occupancy, ADR, segment mix, or channel mix changes?
Key concepts
- rooms revenue budget
- available rooms
- occupancy
- ADR
- segment demand
- channel mix
- Rooms Revenue
- net rooms value
- monthly phasing
Converting market strategy into capacity, segment demand, pricing, USALI Rooms revenue, channel value, and management action
Chapter 4 established where rooms demand should come from, which segments the hotel intends to target or defend, what value supports the price, and which channels and commercial actions will be used. This chapter converts that approved strategy into a source-controlled monthly model.
The model must do more than calculate occupancy, ADR, and RevPAR. It must show how physical capacity, renovation timing, segment demand, pricing, channel cost, marketing spend, competitive evidence, risk, and reporting classification combine to create the rooms result.
EXECUTIVE TAKEAWAY
A credible rooms budget begins with capacity and evidence, not an annual occupancy target. Room nights and ADR are built by segment; channel and acquisition cost remain separate; package revenue is allocated correctly; formal Rooms revenue remains distinct from analytical net value; and every material strategy is connected to an owner, cost, operating consequence, and review trigger.
Learning outcomes
• Carry the approved Chapter 4 market and marketing strategy into the model without reopening settled decisions.
• Separate physical capacity, rooms available, rooms sold, and occupancy, including renovation and outage effects.
• Build room nights and pricing for every material USALI transient and group sub-segment.
• Keep market segment, distribution channel, marketing action, and acquisition cost as separate modelling dimensions.
• Align the formal Rooms revenue presentation with the Uniform System of Accounts for the Lodging Industry (USALI), 12th Revised Edition.
• Use competitor and STR-style evidence as controlled reasonableness checks rather than copied targets.
• Apply wash, probability, cancellation, no-show, displacement, package allocation, and scenario logic where material.
• Reconcile the completed model to operating costs, labour, F&B, GOP, cash, owner reporting, and the rolling forecast.
SCOPE AND CONTINUITY
This chapter builds the Rooms revenue model. It does not build the complete Rooms Department expense and labour budget. Sales and marketing spend is handed to the Sales & Marketing budget; housekeeping workload and Rooms costs are handed to later chapters; package food and beverage value is handed to the F&B budget.
Digital companion
Practice and apply this chapter
Open the working resource associated with this section. Access follows the resource setting shown on each card.
Excel workbook / working template
DC-05 Rooms Revenue Budget Model
Converting market strategy into capacity, segment demand, pricing, USALI Rooms revenue, channel value, and management action
DC-05_Rooms_Revenue_Model_Azure_Example_v2.0.xlsx · download readyExcel workbook
Rooms Revenue Budget Model
Completed Azure teaching example — USALI 12th Revised Edition compliant structure
DC-05_Rooms_Revenue_Model_Azure_Example_v2.0.xlsx · download readyChapter-end learning
Apply, check, and remember
Apply it to your situation
Connect the chapter to a real hotel decision
As you answer, think about where this issue appears in your own property, team, report, meeting, or control process. Work through one item at a time, check the result, and then continue.
Open learning preview: the quiz and flashcards are available to everyone. Answers are checked immediately, while the detailed reasoning remains in the complete chapter. Sign in to save quiz attempts and flashcard confidence.
Knowledge check
Question 1 of 8
Memory practice
Flashcard 1 of 12
Reveal the answer, decide how confident you are, and then move to the next card.
Continue the discussion
Share how this applies in practice
Use the chapter’s separation of capacity, rooms sold, occupancy, pricing, channel, package allocation, marketing, service, and reopening. Refer to the companion’s 600-room-night capacity loss, 450 room nights at risk, $72,492 direct Rooms revenue exposure, $25,000 relaunch spend, $16,109 reopening uplift, and the limits of this partial sensitivity.
Azure is considering a 20-room, 30-day renovation closure during August. The GM argues that occupancy will remain close to 71%, so the financial impact is limited. How should the management team rebuild the Rooms model and decide whether the timing is acceptable? Azure’s commercial gross ADR is $154, its USALI Rooms ADR is $150.09, and the synthetic comp-set ADR is $160. The owner asks why management is not budgeting $160. How should the Revenue Manager and Finance Lead answer?
Produce a decision note stating the approved or alternative timing, source evidence, room types affected, displacement response, pricing plan, marketing action, GOP/cash work still required, owner, and review triggers.
Sign in to contribute to this discussion.
0 responses
Responses are public and may be moderated to keep the exchange professional and useful.
No responses yet. Start the discussion with a practical example or a question raised by the chapter.