How a hotel rooms budget is built: months first, then segments
For the owner and the team to defend the same number, three things must sit on one page: how many rooms sell in each month, at what rate, and from which segment. Argue them separately and the hotel rooms revenue budget turns into a wish list. Argued together, each number constrains the others, which is what makes the document defensible in front of an investor or a bank.
Whose job the budget is, and who brings what
The budget never comes out of one person's desk: sales and marketing bring the segment plan and the agency contracts, front office brings last year's actual room counts and cancellations, revenue management brings the rate and occupancy assumption, and the owner brings the investment and cash expectation. Have every number written down before the meeting, so the room argues over documents rather than opinions. The same division of labor runs the weekly revenue meeting later in the year, and an agenda for the weekly revenue meeting keeps who-brings-what from becoming a question again.
The difference between a budget and a demand forecast
The budget is the target approved at the start of the year, and it does not move easily; the demand forecast is an estimate rewritten every month, looking at the current pick-up, the net room nights that came in from yesterday to today. Write the two into the same cell and at month end you cannot tell which one you missed. Let the budget be the target and the forecast be the route; keep them in separate columns.
What data the budget starts from
Start from last year broken down by month and by segment, not from last year's total. If all you hold is an annual total, first produce a breakdown that splits it into months and segments, or the budget stays a guess. The four sources below build that breakdown.
Last year, month by month and segment by segment
Pull room nights, room rate and rooms revenue from the property management system by month and by segment, and keep cancellations and no-shows in a separate column so you do not mistake gross bookings for net stays. Check that your segment names did not change during the year, or the year's rows will not stack. This breakdown is the single foundation of the budget.
Getting the segment mix right before you multiply anything
If the segment mix is built wrong, every multiplication that follows is wrong: a room arriving through an agency contract and a room booked direct do not sit on the same scale, because their rates, cancellation behavior and payment timing differ. Separate your hotel's own sales channels, its agency and tour operator contracts, and its group business. Once the mix is right, the budget lines fall into place on their own, and getting your hotel's segment mix right is worth doing before any rate discussion starts.
Reading shifts in source markets into the plan
When one market's share falls while another's rises, the budget cannot be a copy of last year: the same total room nights arrive with a different rate and a different length of stay. Put your source market breakdown beside last year's and write the growing market's rate and stay behavior into the budget as its own line. This changes the distribution, not the total, and it is the part of the plan to check against last year's rows before it is copied forward. Reading shifts in Türkiye's source markets into your segment plan turns that comparison into concrete rows.
Planning room nights and occupancy month by month
For each month, write the available room nights first, then the occupancy you plan for that month; the room rate comes last. Order matters: with room nights and occupancy fixed, the rate argument becomes arithmetic; the other way round it becomes an argument about taste.
Start from available room nights, not from rooms
A month's available room nights are the room count times the nights in that month, minus the nights not on sale: renovation, closed floors and staff accommodation. Do not calculate an occupancy before this number is written; an inflated denominator makes the target look easier than it is. Bring the renovation calendar to the budget table, and you will not regret it in November.
Splitting the season into periods and writing each month separately
In a resort, the year is not one curve: inside the season sit holidays, school breaks and shoulder periods, and each period's occupancy and rate are written separately. Dividing the budget into months shows you, at year end, exactly which period missed its target. The rate side of those periods needs its own treatment, and pricing a Türkiye resort season period by period is the companion piece to this table.
Why the occupancy target is never one hundred percent
Budgeting every month at full occupancy produces nothing but rate cuts: rooms filled with last-minute discounts pull the budgeted room rate down with them. Set an occupancy target that fits the month's own structure and look for the rest in rate. In a budget, occupancy is an assumption, not a ceiling.
Working out room rate and revenue by segment
A segment's revenue is its room nights times its room rate; the hotel's average daily rate (ADR: average revenue per room sold) falls out of those lines at the end. Compute the segments one by one and let the average appear last.
Keeping agency, direct and group lines apart
The rate on an agency contract is written in the contract and reads differently as commission or net; the direct rate is the room rate you set yourself; group business runs on a block and a single rate. Add the three into one line and you can no longer see which channel carries the budget. Write each with its own room nights and its own rate.
For example, in a month 1122 room nights split as 500 from agency contracts at 60 euros, 450 direct at 95 euros and 172 group at 70 euros: the agency line is 500 * 60 = 30000, direct is 450 * 95 = 42750, group is 172 * 70 = 12040 euros; the month's rooms revenue is 30000 + 42750 + 12040 = 84790 euros and the ADR is 84790 / 1122 = 75.57 euros.
Reading the ADR out of the segment mix
The average daily rate is not a target but the result of the segment mix: when the cheaper segment's share grows, the average falls, even if the same rooms sell at the same rates. If you want a higher average in the budget, change the mix first and the rate second. At month end, read a drifting average in that order.
From rooms revenue to revenue per available room
Revenue per available room (RevPAR: rooms revenue per available room) comes out of the budget two ways: room rate times occupancy, or total rooms revenue divided by available room nights. If the two calculations do not give the same number, there is an error in the table. Run this check on every month's row.
Laying out the twelve-month table and checking it
The table has twelve rows, each with available room nights, room nights, occupancy, rate and rooms revenue, and segment columns beneath. When it is done, run three checks: do the months add up to the annual target, do the segments add up to each month, and does RevPAR come out the same both ways.
Letting the annual total come out of the months
Writing the annual target first and dividing it into months is easy but misleading: if the months do not add up to the target, the problem is in the months, not the target. Build each month from its own structure, read the total last, and if it differs from the target, decide which month carries the gap. Make that decision in writing.
Presenting one page the owner and the team both sign
The owner gets one page and the team gets its own section of the same page: the owner sees the annual rooms revenue and the monthly curve, the sales team sees the segment lines, front office sees the month's room nights and occupancy. Let every number come from the same source, so the meeting does not end up arguing two separate budgets. Getting that page signed is what makes the budget defensible.
When to revise the budget during the year
The budget does not change every month during the year; a revision happens when an event breaks an assumption: a market closing, a major renovation, a contract not renewed. Read the revision alongside the month-end gap report, so it is visible which assumption broke. A revision made without a stated reason turns the budget into something other than a target, and reading the gap between budget and actuals at month end is the discipline that keeps the two documents honest with each other.
The mistakes that break a rooms budget
What breaks a rooms budget is rarely the arithmetic; it is a wrongly set assumption, and the five mistakes below all come from there. Check each one once in your own table, because fixing it later is expensive.
- Writing the annual total first and dividing it into months: the monthly curve stops showing the real shape and the periods inside the season disappear.
- Collapsing segments into one line: you can no longer see which channel carries the budget, and agency and direct business share a cell.
- Mixing commission and net rate: the agency line looks higher than it is and the month closes short.
- Leaving renovation and closed rooms in the denominator: the occupancy target looks easier than it is.
- Putting the budget and the forecast in the same cell: at month end nobody can tell whether the target or the forecast missed.
What happens in the first month after the budget is signed
The budget should not go on the shelf the day it is signed: the first month is the most valuable one for seeing which line is actually materializing. In the first week, compare pick-up against the budget line and write the gap down.
Comparing early pick-up against the budget line
In the month's first week, answer three questions on one screen: how much of the budgeted room nights has materialized, which segment it came from, and is that segment's rate the same as the budgeted one. If there is a gap, look at rate and channel adjustments without waiting for the month to close. This does not replace the month-end gap report, but it makes that report readable.
Putting the budget on the weekly revenue meeting's agenda
Make the budget the first item of the weekly meeting: last week's room nights, the current month's budget line, and the gap. Let the second item be rate and channel decisions, and the third the state of agency and group blocks. With a fixed agenda, the budget gets discussed every week and year end holds no surprises.
Share this post
Frequently Asked Questions
What does a hotel rooms budget consist of?
A rooms revenue budget consists of available room nights, room nights, occupancy, room rate and rooms revenue, each written by month and by segment. Cost, payroll and capital are separate budgets and do not go into the rooms revenue line.
How do I split the annual budget into months?
Write each month's available room nights first, then its occupancy, then the segment mix and the rate, and read the annual total last. If the months do not add up to the annual target, decide in writing which month carries the gap.
Should the agency rate go into the budget gross or net?
Read the contract to see whether the rate is gross or net of commission, and use one definition for the whole year; if one month is gross and another net, the lines cannot be compared. Note the definition you chose at the top of the table.
Who approves the budget and who carries it out?
The owner approves the budget; sales, front office and revenue management carry it out together, and approver and executor must see the same page. After approval the budget becomes the first item of the weekly revenue meeting.
When is the budget revised if it is not being met?
The budget does not change every month; it is revised when an event breaks an assumption, alongside the month-end gap report and with the reason written down. Revising it merely because the target was missed turns it from a target into a forecast.