For Hotel Revenue Managers ·
What you'll accomplish
Budget season is the most document-intensive period in a revenue manager's year — multi-scenario Excel models, assumption narratives, comp set analysis, and ownership presentations all happen in a compressed window. You'll use Claude Pro to draft the narrative sections, generate scenario commentary, and analyze the competitive documents that inform your budget assumptions. The modeling stays in Excel; Claude handles the writing and synthesis that currently takes the most time.
What you'll need
Create a dedicated Claude Project for budget season — separate from your regular RM project, since you'll be uploading large documents.
This project is for [Year] annual budget preparation for [Hotel Name].
Property: [room count] rooms, [brand/segment], [city]
Current year performance baseline: RevPAR $[X], ADR $[X], Occupancy [X]% (YTD through [month])
Budget process: [describe — e.g., "We submit to asset manager by Nov 15. Three scenarios required: conservative, base, optimistic."]
Key stakeholders: [Asset manager name], [Ownership entity name], [GM name]
Budget format: [describe your standard format — narrative + financial tables, or narrative only]
Prior year outcome: Budget was $[X] RevPAR, actual came in at $[X] — [brief explanation of variance]
Budget narratives require solid market context. Run this sequence early in the process:
Prompt 1 — Market environment summary:
I'm building the [Year] hotel budget for [Hotel Name] in [city/market]. Based on the documents I've uploaded (YTD performance and STR benchmarking), write a 2-paragraph market environment summary covering: (1) how our market performed this year vs. prior year, and (2) key factors that drove our competitive index results (MPI, ARI, RGI). Use specific numbers from the documents where available.
Prompt 2 — New supply and competitive threat summary:
Here is information about new hotel supply entering our market: [paste any pipeline data you have — brand, room count, opening quarter]. Assess the competitive impact on our property for [Year]: which segments and day-of-week patterns are most at risk, and what does this imply for our RevPAR growth assumptions?
Prompt 3 — Demand drivers outlook:
Here are the major demand generators in our market for [Year]: [list events, corporate accounts, seasonal patterns, new generators]. Based on this list and our current performance baseline, what's a reasonable occupancy and ADR growth assumption range for the base scenario? Give me a range with reasoning for conservative, base, and optimistic cases.
Once you have your scenarios modeled in Excel, use Claude to write the narrative:
Section 1 — Executive summary:
Write a 150-word executive summary for our [Year] hotel budget. Base scenario: RevPAR $[X] (vs. current year $[X], growth of [X]%). ADR $[X], Occupancy [X]%. Key drivers of growth: [list 2-3]. Key risks: [list 1-2]. Audience: asset manager. Lead with the headline number and be direct about assumptions.
Section 2 — Assumptions narrative:
Write the budget assumptions narrative section. Our key assumptions for the base scenario: (1) Market RevPAR growth of [X]% based on [reasoning]. (2) ADR growth of [X]% supported by [pricing strategy]. (3) Occupancy: [X]% assuming [demand pattern]. (4) New supply impact: [estimated effect]. (5) No material renovation impact. 300-400 words. Explain the logic, not just the numbers.
Section 3 — Scenario comparison:
Write a 200-word section comparing our three budget scenarios for the ownership review. Conservative: $[X] RevPAR, $[X] ADR, [X]% Occ. Base: $[X], $[X], [X]%. Optimistic: $[X], $[X], [X]%. Explain what would have to happen for each scenario to occur — what demand conditions, rate environment, and market developments would drive us to each outcome.
Section 4 — Strategy section:
Write a 200-word revenue strategy section for the budget. Our strategic priorities for [Year]: [list 3-4 initiatives — e.g., growing direct booking mix by X%, implementing a new group pricing policy, targeting new corporate accounts in X segment]. For each priority, briefly explain how it contributes to hitting our base RevPAR target.
When Q2 actuals diverge significantly from budget, ownership wants an updated forecast. Use Claude for the revision narrative:
Our [Year] budget assumed $[X] RevPAR through year-end. Through [month], actual RevPAR is $[X] — [X]% [above/below] budget pace. Here's what changed vs. our original assumptions: [list actual market developments].
Write a revised full-year forecast memo for the asset manager: (1) revised year-end RevPAR estimate with reasoning, (2) explanation of what changed vs. budget assumptions and why, (3) management actions being taken in response. Tone: honest and forward-looking. 300-350 words.
Comp set benchmarking analysis for budget:
Here is our STR annual benchmarking data: [paste or upload]. Our RevPAR index [grew/fell] from [X] to [X] this year. Write a 2-paragraph competitive benchmarking analysis explaining what drove the index movement and what it means for our [Year] positioning strategy.
Ownership Q&A prep:
Based on our budget assumptions — [paste key assumptions] — what questions will an asset manager likely ask in the budget review meeting? Give me the top 5 questions with suggested talking-point answers for each.
Conservative scenario justification:
Write a 150-word rationale for why we built a conservative budget scenario at $[X] RevPAR (vs. base $[X]). The conditions that would drive this outcome: [list]. Tone: realistic and credible — this should read as a genuine risk scenario, not a hedge.
Revenue strategy narrative:
Write a "Revenue Strategy for [Year]" section for our budget deck. Our three strategic priorities: (1) [priority], (2) [priority], (3) [priority]. For each, include: what we'll do, why it drives revenue, and what success looks like. ~250 words. Audience: asset manager.