Independent Hotel First Budget Guide

Forecast the business before you budget the numbers

Start with the business.

Not with the spreadsheet.

If I were sitting with you as the owner or GM of your hotel, my first question would not be: “What revenue number do you want next year?”

I would ask: “What do you genuinely think the hotel will look like next year — and why?”

• How many rooms do you expect to sell?
• Who will buy them?
• What will they pay?
• Which months will be strong — and which months worry you?
• Are you planning to change your business mix?
• Will you need more people?
• Are prices or salaries changing?
• Are you investing in marketing, maintenance or a new service?
• What are you expecting management to do differently?

Those are budget questions. The numbers come afterwards.

First, don’t open Excel yet

The easiest way to build a hotel budget is also one of the weakest.

Take last year’s revenue. Add 5%. Increase payroll by 4%. Increase the other expenses by inflation. Make the P&L balance. Done.

You certainly have a spreadsheet. But I would hesitate to call it a business plan.

A useful budget should tell me what management believes will happen and what management intends to do about it.

That distinction matters because almost every number in your final P&L is the result of something happening in the hotel first.

Rooms revenue does not appear because somebody typed a revenue target. It appears because rooms were available, guests wanted them, the hotel captured some of that demand, those guests came through particular channels or segments, and they paid particular rates.

Payroll does not appear because Finance selected a percentage. It appears because you decided what work needs to be done, how many people are needed, when they are needed and what they will cost.

The same logic applies throughout the budget.

Figure 1.1 — Start with the business, not the spreadsheet.

So what is the difference between a forecast and a budget?

You will hear the words forecast and budget used almost interchangeably in hotels. For this guide, I want to keep the distinction simple.

Imagine your current business suggests next year’s occupancy will probably remain around 58%. That is a forecast view.

But management may also be planning a stronger sales effort, new corporate accounts, better low-season promotions or improvements to the property. You may therefore finally approve a budget at 62%.

That can be reasonable. But I would immediately ask: “Where are those extra four occupancy points coming from?”

If the answer is “We want to grow,” I do not yet have a budget assumption.

If the answer is “Our existing business supports about 58%. We expect another two points from two corporate accounts under negotiation and another two from stronger low-season promotion, supported by the sales and marketing plan,” now I have something I can challenge.

I can ask who owns it. I can check whether the marketing money exists. I can monitor whether the corporate accounts materialise. And if they do not, I can change the forecast before the year gets away from us.

That is the difference between a number and a management assumption.

Yes, use last year — but don’t copy it

If your hotel has been operating for some time, last year is normally the best place to begin.

Your own history can show you things that a generic industry benchmark cannot. It can show when your high and low seasons really occur, which months normally struggle, your normal room-night pattern, rates, payroll, F&B activity and major expenses.

So yes, use last year. Just do not assume that last year is automatically next year.

I would first clean the story.

Suppose you had a large wedding or conference last year that generated 600 room nights and you know it will not return. Those room nights should not quietly become part of next year’s baseline.

Or perhaps five rooms were out of service for three months during renovation. In that case, last year’s performance may actually understate what the hotel can normally achieve.

Expenses need the same discipline. A major emergency repair may not repeat. But be careful.

I often hear managers say: “That was a one-off repair.” The exact repair may have been one-off. But if an ageing hotel has a major repair every year, repairs are not really a one-off operating need.

That is the question I want you to ask. Not: “Will I receive this exact invoice again?” But: “Does this represent something the hotel normally needs to operate?”

Now tell me what will be different next year

Once you understand the historical base, stop looking backward. This is where the real budgeting work starts.

I would ask you to divide the next-year discussion into two conversations.

You do not need a complicated economic model for every item.

For a first budget, I mainly want you to be able to answer: “Do I have a sensible reason to expect this part of the business to be stronger, weaker or broadly similar next year?”

That is already much better than applying the same growth percentage everywhere.

If you want growth, show me where it comes from

This is one of the most useful conversations you can have during budgeting.

Imagine the market around you is expected to grow by roughly 4%. Your hotel is budgeting 12% growth.

There is nothing automatically wrong with that. But I want to understand the extra eight points.

Perhaps you renovated your rooms. Perhaps you were badly underperforming the market and are recovering. Perhaps you hired a sales manager. Perhaps you are increasing inventory. Perhaps new corporate accounts are coming. Perhaps last year was unusually weak. Perhaps you have made a deliberate pricing or distribution change.

Any of those may support the plan. But growth should have a source.

The question is not: “How much growth do we want?” The better question is: “What has to change in the operation for this growth to happen?”

And then: “Have we actually funded and assigned those actions?”

A hotel cannot budget stronger Direct bookings and then provide no money for its website, digital marketing or sales activity. It cannot budget more F&B business and then ignore the labour, inventory and operating capacity needed to serve it. It cannot budget substantially higher rates without asking why the customer should pay them.

Your strategy has to travel through the whole budget.

Budget the cause before the result

This is probably the most important working habit in the entire guide.

Whenever possible, budget the cause before you budget the financial result.

Figure 1.2 — Budget the cause before the result.

The formula is usually the easy part. The difficult part is deciding whether the assumption behind it makes sense.

What if you don’t have perfect data?

You probably will not — especially if this is your hotel’s first proper budget.

You may know total Rooms revenue but not have reliable historical revenue by segment. You may know total F&B revenue but not have covers by meal period. You may have payroll totals but an incomplete department-level history.

Do not manufacture precision. And do not delay the entire budgeting process while waiting for perfect data.

Start with what you can support. Make the assumption visible. State where the information came from. Then improve the information you collect during the year.

Your first budget does not need to be perfect. It does need to be explainable.

That is why the workbook contains an assumption register. The register is not there to create more administration. It is there so that, six months later, you can still remember why you entered the number in the first place.

Let’s make this real: meet Riverside Grove Lodge

Throughout this guide, we are going to use one fictional hotel so that you can follow the same assumptions all the way from the first forecast to revenue, payroll, expenses, departmental profit, cash and owner review.

Riverside Grove Lodge is a fictional 24-room independent nature lodge. Its model includes Rooms, full-board F&B, Activities, Sales & Marketing, Administration, Maintenance and other property costs.

I am not asking you to copy its numbers. I want you to copy the thinking process.

Here are some of the opening assumptions already entered in the companion workbook.

Notice what we have not done.

We have not started by saying: “Rooms revenue should be $537,599.”

That is the kind of result the model eventually calculates. We first decide what we believe about the business.

Riverside Grove has 24 rooms. That gives us capacity. Occupancy is not spread evenly across the year. It starts at 38% in January and builds toward 72% in December. That gives us a demand pattern.

We then decide who is producing those occupied rooms, how guests are staying and what packages they buy. Only after that do we calculate revenue.

That sequence matters.

Figure 1.3 — Riverside Grove Lodge: the annual occupancy assumption is built from a monthly operating ramp.

Don’t lock yourself into one number too early

There is another mistake I see with first budgets. People assume they must immediately identify the one correct answer.

There usually is no such certainty.

Maybe you think occupancy will be around 58%, but there is a credible path to 62%. Maybe a key account could be lost. Maybe your new pricing strategy works better than expected. Maybe it does not.

Rather than arguing endlessly over the single perfect number, test the important assumptions.

The Riverside Grove workbook does this with three simple sensitivity views.

These are deliberately sensitivities, not three completely separate budgets. The rest of the workbook then shows what those changes do to revenue, GOP and cash.

That last point is important. An occupancy or pricing assumption does not affect only revenue. It may affect variable costs, working capital and eventually cash.

In the base Riverside Grove plan, the workbook produces approximately $1.217 million of operating revenue and $358,603 of GOP. But its lowest closing cash is about $67,559, below the $75,000 minimum reserve. The model therefore shows a funding gap to reserve of about $7,441.

That is a useful lesson for a first-time budgeter: a budget can look profitable and still create a cash question.

We will deal with that properly later. For now, I simply want you to see why testing assumptions matters.

And don’t turn the budget into a wish list

An opportunity case still needs a path.

If your hotel currently operates at 48% occupancy and you enter 75% simply because ownership wants growth, that is not a forecast. It is a target without an operating plan.

Whenever you make a material improvement assumption, I want you to be able to answer five things:

1. What is changing?
2. Why should it change?
3. Who has to make it happen?
4. What will it cost or require?
5. When will we know whether it is working?

That is the one checklist I would keep visible throughout the budgeting process. Ambition is useful. But the budget has to convert ambition into action.

Being conservative does not mean making the budget easy to beat

The opposite problem happens too. Some managers deliberately understate revenue and overstate expenses because they want a comfortable budget.

I understand the temptation. But it weakens the plan.

If the hotel genuinely expects stronger occupancy and you deliberately budget much less, you may plan too few employees. You may understate purchasing. You may misjudge cash requirements. You may delay investments that are actually necessary.

The purpose of the budget is not to create a number that management can comfortably beat. It is to create the most useful operating plan we can build with the evidence available today.

You can still create a conservative scenario. Just do not confuse that scenario with the most realistic base plan.

Keep the assumptions where everybody can see them

Suppose you and I agree on 62% occupancy. Six months later, the number 62% is not particularly useful on its own.

I want to know why we believed 62%. Was it because of two new accounts? A renovation? A stronger high season? A marketing campaign? A new flight? A recovering market?

Who was responsible? What were we supposed to watch?

This is why assumptions should not disappear inside formulas.

For Riverside Grove, the workbook keeps assumptions such as occupancy, Direct share and package rates visible in the assumption register. Occupancy is assigned to GM / Rooms, with a monthly action to track pickup, occupancy and market conditions. The double package rate is assigned to GM / Revenue, with a monthly review of achieved rate and competitor pricing.

That is much more useful than having somebody discover six months later that the revenue formula contains a number nobody remembers approving.

Figure 1.4 — Keep the assumption alive: source, owner and review discipline remain visible after the budget is approved.

Can you explain the budget without opening the workbook?

This is my favourite test.

When the budget is finally completed, I should be able to close Excel and ask you: “Tell me the plan.”

If the only answer is “Revenue is $1.2 million and GOP is 29.5%,” we are missing the important part.

For Riverside Grove, the management story might sound more like this:

That is already a budget story.

The spreadsheet will eventually prove whether the economics work.

So what should you have before we move on?

At the end of this first conversation, I do not expect you to have a completed P&L. I expect something much more useful.

You are now ready to open the model.

But before we start calculating Rooms revenue, we need to make one more decision.

How much detail does your hotel actually need?

A five-room guesthouse should not build the same budget as a 100-room full-service hotel. A rooms-only hotel should not be forced into an F&B model it does not operate. A full-board lodge like Riverside Grove needs to understand package allocation and activities in a way that a city bed-and-breakfast may not.

That is our next conversation.

NEXT CONVERSATION

Before You Fill Every Row, Let’s Decide What Actually Matters

Map the hotel and choose the right level of detail.

Map your hotel before you build the budget

Before we forecast a single room night or enter a single expense, I want to understand how your hotel actually works.

A six-room guesthouse, a 35-room city hotel and a 70-room resort may all prepare a budget. They should not automatically prepare the same budget.

Your first job is therefore not to fill the template. It is to decide what deserves a place in it.

• Where does the hotel really earn money?
• Which parts of the business behave differently?
• Which activities are large enough, complex enough or strategically important enough to deserve separate attention?
• Which costs and people belong to each part of the operation?
• What can safely remain simple?

Once we answer those questions, the workbook becomes much easier to use.

Don’t let the chart of accounts design your budget

A common first instinct is to open the accounting P&L and copy every account into the budget.

That can create a very detailed spreadsheet without creating a useful management plan.

Your accounting system may separately record shampoo, soap, slippers, cleaning chemicals, stationery and minor operating supplies. For budgeting, several of those lines may be perfectly sensible as one controlled group if they move for the same operational reason.

The opposite can also happen. The accounts may show one line called Rooms Revenue, while management needs to understand Direct, OTA, Corporate or Travel Agent business separately because the rate, commission, seasonality or strategy is different.

Draw the hotel before you draw the spreadsheet

Take a blank page and write down every meaningful way the property earns revenue. Do not worry about formulas yet.

One hotel may need only Rooms, Breakfast and Airport Transfer. Another may need Rooms, Restaurant, Bar, Banquets, Spa, Activities, Transfers and Meetings.

Both can be correct. The point is not to look sophisticated. The point is to make the business visible.

Figure 2.1 — Start with the operating model, not somebody else’s template.

Start with the main revenue engine

For most independent hotels, Rooms is the largest revenue source, so it normally deserves the most attention.

At the minimum, I want you to understand available rooms, sellable room nights, occupied room nights, occupancy, average room rate and Rooms revenue.

Even a very small property should normally know those drivers. The real question is how much further you need to go.

How many Rooms lines do you actually need?

The right level of Rooms detail depends on hotel size, business mix, available data, management focus and distribution strategy.

The question is not “How many segments do other hotels use?” It is “Would knowing this segment’s volume, rate or trend help us make a different decision?”

Segmentation should help you see mix, not show off complexity

One of the main reasons to budget room nights by segment or source is to understand the quality of the business mix.

Both hotels may sell the same 10,000 room nights and show similar occupancy. But their commission cost, rate quality, booking windows, cancellation behaviour, customer loyalty and third-party dependency may be very different.

That is why a useful commercial objective is often not only “grow occupancy.” It may be “grow the right occupancy at the right net value.”

Sometimes a small segment still deserves its own line

Do not decide detail only from last year’s size.

Suppose Direct business is only 8% of room nights, but management intends to invest in a new website, metasearch, remarketing, email campaigns and loyalty benefits. Direct is now strategically important. It deserves visibility because management needs to know whether the strategy is working.

The same logic applies to a new Corporate segment, a new spa, a new event business or any other area management intends to actively build.

Now map the rest of the revenue

Once Rooms is visible, list every other meaningful source of revenue. Typical independent-hotel examples include:

• Food & Beverage — breakfast, lunch, dinner, bar, banquets, events, room service.
• Wellness — spa, massage, memberships, wellness packages.
• Activities — safari, tours, excursions, diving, water sports, guided experiences.
• Transportation — airport transfer, local transport, car-hire commission.
• Other — laundry, retail, parking, meeting rooms, equipment rental, resort fees or other guest services.

You are not creating a separate spreadsheet for every item. You are deciding which activities deserve their own operating build and which can remain a simple monthly line.

Use materiality as a clue, not a rule

A practical first test is the approximate share of hotel revenue. If a revenue stream contributes around 20% or more, that is a strong sign that it may deserve more detailed budgeting.

Hotel A clearly needs detailed Rooms planning. F&B may need some detail, but perhaps not a complex meal-period model. In Hotel B, F&B at 31% is too important to leave as one unexplained annual number.

But 20% is not an accounting rule. A smaller stream may still deserve separate planning if it is strategically important, high-margin, high-risk, operationally complex or changing rapidly.

Figure 2.2 — Four questions before adding another budget line.

F&B is where over-detail happens quickly

Food & Beverage is a good example of why the same template cannot suit every hotel.

If breakfast, lunch and dinner behave differently and management actively controls them separately, the detail can help. If the hotel has never measured lunch covers and has almost no local trade, inventing a meal-period model only creates false precision.

Don’t invent detail you cannot support

A first budget often starts with imperfect data. You may know only total monthly F&B revenue, total food cost and total payroll. That is still usable.

Start with the best information you can actually support. Improve the data discipline during the year. Next year, the budget can become more granular because the hotel has started collecting the information it needs.

Now map who actually runs the business

Revenue lines are only half the map. The hotel also needs operating and support departments.

Typical operated departments include Rooms, F&B, Spa, Activities, Parking or other guest services. Typical support departments include Administration & General, Sales & Marketing, Maintenance / Engineering, IT, Security and Human Resources.

Small hotels may combine several of these. Finance + HR + Administration may be one team. Sales + Reservations may be one team. Maintenance + Security may be combined. That is fine.

The budget should reflect how responsibility actually works in your hotel rather than force a textbook organisation chart onto it.

Revenue departments and support departments need different questions

This distinction becomes important when we later build departmental profitability.

A revenue-producing department can usually be viewed as revenue less its direct payroll and direct operating costs. What remains is the department’s contribution or profit before whole-hotel support costs.

Sales & Marketing, Finance, HR or Administration usually do not have a directly attributable revenue line. Do not force them into artificial profit calculations.

For a support department, the better question is: “Is this level of cost appropriate for the size, complexity and strategy of the hotel?”

Every important line needs a driver

Once you know which revenue streams and departments matter, ask what causes each important number to move.

A driver is simply the operating factor behind the number. It does not need to be complicated.

Figure 2.3 — Map the operating driver before you decide the formula.

Don’t make every cost move the same way

The driver map immediately shows why applying the same inflation percentage to every expense is weak budgeting.

The purpose is not to build a perfect economic equation for every account. It is to stop treating every cost as though it behaves the same way.

Give each department enough expense detail to manage it

A department needs enough lines to explain the costs management can actually influence. It does not need every minor accounting code.

If several small costs behave in the same way and nobody makes a different decision from seeing them separately, consolidate them.

Leave some room for a hotel that does not look like the example

No template can predict every independent hotel. A useful workbook therefore needs some flexible capacity.

the companion workbook provides flexible inputs in several places: local / extra meal covers, events, other activity units, custom expense lines and custom positions. Those fields are there so the hotel can adapt the structure without rebuilding the model from scratch.

If your hotel has a genuinely important revenue stream or commercial segment that is not represented, decide the mapping before approval rather than hiding it inside “Other” simply because the template did not anticipate your business.

Map the people before you budget the payroll

Although payroll is built in a later chapter, I want the manpower structure visible now because it tells us where labour cost will be generated.

For a small property, several roles may be combined. That is not a problem. The objective is not to create an organisation chart; it is to identify the work and the people needed to perform it.

Don’t allocate payroll by percentage if you know the people

A common shortcut is to take total payroll and allocate 40% to Rooms, 30% to F&B, 15% to Administration and so on.

That may be acceptable as a temporary estimate when no staffing information exists. But once you know the positions and headcount, payroll should ideally come from the people plan itself:

Then each position is assigned to the department that actually uses the work. This gives you a much clearer view of department profitability and manpower needs.

Shared employees do not need theoretical precision

Small hotels often have people serving more than one function. A driver may support both guest transfers and activities. The General Manager supports the whole property. Maintenance works across every department.

You have three reasonable options: assign the person to the main department, allocate a sensible percentage when the split is genuinely material, or keep the role in a support department.

The important thing is consistency. Do not spend hours allocating a small salary with theoretical precision when the allocation will not change a management decision.

A monthly budget must show the shape of the year

Hotel activity is rarely uniform. That is why the map must also include timing.

Note high and low seasons, major events, holiday periods, renovation closures, weather patterns, known group business and corporate contract cycles.

An annual occupancy of 60% does not mean 60% every month. The staffing, purchasing and cash consequences can be completely different depending on when the rooms are sold.

In Riverside Grove, occupancy begins at 38% in January and gradually builds to 72% in December. That monthly pattern is more useful than the annual average of about 56.8% because the rest of the budget can respond to the timing of the business.

Separate what is known from what is expected — and what is still only ambition

During the mapping exercise, make a short list of what will be different next year. Then classify each item honestly.

This small distinction prevents a management ambition from quietly appearing in the spreadsheet as though it were already supported by evidence.

Let’s map Riverside Grove Lodge properly

Riverside Grove Lodge is the fictional 24-room nature lodge used throughout this guide. The current companion workbook gives us a useful example of how the mapping principle works in practice.

Figure 2.4 — Riverside Grove Lodge: the operating map behind the companion workbook.

Three points are worth noticing.

1. Rooms is the largest single revenue stream, but it is not the whole hotel. It produces about 44.2% of annual operating revenue in the worked example.

2. F&B / Bar produces about 38.5%, so it is clearly material. However, the lodge is full-board, so the workbook does not pretend that breakfast, lunch and dinner are independent businesses. Included meals are created through the package allocation, while bar, local / extra meals and events can be tracked separately where relevant.

3. Activities produce about 17.3% of revenue — below the simple 20% signpost — but they still deserve a separate build because activity participation, price and direct cost behave differently from Rooms and F&B.

This is exactly why materiality must be combined with operating behaviour and management relevance.

What the Riverside workbook actually contains

The workbook structure follows the map rather than asking the hotel to fill every imaginable line.

The workbook is therefore not a list of disconnected tabs. It is the financial expression of the operating map we have just built.

Build your own one-page hotel map before you continue

Before we move into the Rooms forecast, I want you to be able to complete one page for your own property.

1. List every meaningful revenue source and estimate its approximate share of total hotel revenue.

2. Decide which revenue streams are material, strategic, high-margin, high-risk, operationally complex or actively managed.

3. Choose the useful level of detail for each one: total only, monthly, by segment, by meal period, by activity or another operating measure.

4. Identify the revenue-producing departments and the support departments.

5. For every major revenue and expense line, write down what makes the number move.

6. List the positions and shared roles required to support the operating plan.

7. List the known changes, expected changes and major uncertainties that will affect the year.

The test before we move on

At this point, I should be able to ask you five questions and get clear answers without opening the workbook:

• Where does the hotel earn money?
• Which revenue streams and departments genuinely deserve separate attention?
• What level of detail helps management make a different decision?
• What are the major operating drivers, people and costs behind those activities?
• What is changing next year, and when?

If those answers are clear, the budget structure is ready.

Now we can begin the first real build: how many room nights can the hotel realistically sell each month, and what does that demand look like?

Build capacity, demand, business mix and rate month by month

For most independent hotels, Rooms is the largest source of revenue. That makes it tempting to start with the final number.

You look at last March, see 620 room nights, and type 650 for next March. Or you take last year’s Rooms revenue and add 5%.

It is quick. It may even land close to the eventual result. But it does not tell you whether the business is actually achievable.

If I were reviewing the Rooms budget with you, I would want to hear the commercial story before I saw the revenue total.

• How many room nights can we genuinely sell?
• How much demand is available in each month?
• How much of that demand can this hotel realistically capture?
• Which guests, segments or channels will provide those room nights?
• What will they pay?
• What commercial action is needed to make the plan happen?

Once those answers make sense, the revenue calculation becomes the easy part.

Figure 3.1 — Build the operating chain before calculating Rooms revenue.

First tell me how many room nights you can actually sell

Before forecasting demand, establish capacity. The basic calculation is simple.

That distinction matters. Occupancy should tell you how effectively the hotel used the inventory that was genuinely available for sale, not rooms that management could not sell anyway.

Unavailable room nights may come from renovation, major maintenance, seasonal closure, staff or management use, deliberate inventory withdrawal or another operating restriction.

Now stop looking at capacity and start looking at demand

The next question is not “How full do we want to be?” It is “How much demand can we reasonably expect to capture?”

Your own history is a useful starting point because it shows the shape of the business: strong months, weak months, normal room-night volume, typical mix and rate behaviour.

But last year is evidence, not a ceiling and not an automatic template for next year.

A historical number becomes useful only after you understand what created it.

Your occupancy assumption needs a reason

Suppose last year’s annual occupancy was 56%. I would not accept “56% plus 5% growth” as the complete explanation for a 59% budget.

I would ask what changed.

Maybe destination demand is improving. Maybe first-quarter bookings are ahead. Maybe two corporate accounts are likely to contribute new business. Maybe a renovation improves the product. Or perhaps new competitive supply will offset some of that opportunity.

The exact percentage matters less than the reasoning behind it. A good assumption can be challenged, assigned and monitored.

Separate market growth from your hotel’s growth

This is an important discipline. A destination growing by 3% does not automatically justify your hotel growing by 12%.

If you expect to gain market share, explain why. Perhaps you are renovating, improving distribution, adding a sales person, securing new accounts, recovering from a weak comparison year or adding room inventory.

The opposite is also possible. Your hotel can grow more slowly than the market if the product is ageing, an important account is lost, renovation is delayed or competitors are stronger.

The budget should acknowledge both opportunity and constraint. It should not quietly assume that the hotel deserves whatever growth ownership would like to see.

You do not need expensive research to challenge the demand story

A smaller hotel can still build a sensible market view. The aim is not to become an economist. It is to check whether your own assumptions are consistent with what is happening around you.

Competitor rates are useful context. They are not your rate card. A competitor charging $180 does not prove that your hotel can charge $180.

Ask whether location, room quality, inclusions, facilities, reviews and service proposition are actually comparable. Rate needs a positioning argument.

Build the year month by month - do not smooth away the hotel

Annual occupancy is useful for the final summary. It is weak as an operating plan.

If you estimate annual room nights and divide them evenly by twelve, the total may be mathematically correct while the monthly budget becomes operationally useless.

Seasonality affects staffing, laundry, amenities, breakfast, purchasing, utilities, working capital and cash. The Rooms plan therefore has to resemble the way the hotel actually trades.

Figure 3.2 — Riverside Grove reaches 56.8% for the full year, but the operating pattern moves from 38% to 72%.

For Riverside Grove, the annual occupancy is about 56.8%. But January is budgeted at 38% while December reaches 72%. Those are very different operating months.

The workbook converts the monthly percentage into occupied room nights using sellable capacity. Across 2027, the 24-room lodge has 8,760 physical room nights and, with no planned closures in the worked example, 8,760 sellable room nights. The monthly plan produces about 4,973 occupied room nights for the year.

Build demand in layers before you add “growth”

Before estimating new business, identify what is already visible. I find it useful to think about future room nights in three layers.

This makes the forecast more transparent. If the budget requires 500 additional room nights, you can see whether they are already supported or still depend on management execution.

Now tell me who will buy those rooms

Once total demand is sensible, we can talk about business mix. Use only the level of segmentation that helps you make a commercial decision.

A very small property may need Direct, OTA and Other. Another hotel may need Direct, OTA, Travel Agent, Corporate and Packages. A larger property may need additional group, government, wholesale or negotiated segments.

The important point is that a segment should behave differently enough to justify its own line.

Do not grow every segment just because the total needs to grow

Suppose last year the hotel sold 4,000 room nights. A spreadsheet can add 5% to every segment in seconds. That does not mean the result reflects the strategy.

In the strategy-led version, total room nights increase by 450, but the mix changes deliberately. Direct and Corporate grow, OTA remains important, and lower-rated Travel Agent volume is reduced.

Now the extra room nights have a commercial story. That is much stronger than applying one growth rate to every line.

Every growth assumption needs a route to market

If you tell me the hotel will sell 500 more room nights, I want to know how those guests will find you.

This is why Rooms revenue should be built before many of the related expenses. The revenue strategy creates the resource requirement.

Occupancy and rate are one decision, not two separate targets

A hotel can increase occupancy by discounting heavily. That does not automatically improve the economics. It can also push rate too aggressively and lose more volume than the higher price can recover.

Do not choose the strategy with the highest occupancy simply because the hotel looks busier. Compare volume, rate, mix, acquisition cost, variable room cost, staffing and positioning together.

Think about net economics - and do not count the channel cost twice

Two bookings can carry the same published rate and still deliver different economics.

An OTA or travel-agent booking may include commission or a negotiated net-rate discount. A Direct booking may carry lower third-party cost but require website and marketing investment.

Neither channel is automatically “good” or “bad”. The question is what role each should play in the monthly mix.

Be consistent with the workbook and with your accounting policy. If revenue is recorded at the gross guest rate and commission is expensed separately, budget it that way. If the negotiated amount is already a net rate, do not add the same commission again as a second cost.

A package hotel needs one extra conversation: what belongs to Rooms?

Riverside Grove does not sell a simple room-only rate. It sells a full-board package. That means the package selling price cannot automatically be treated as Rooms revenue.

The workbook first calculates the package value from occupancy type and channel mix. It then adds the chargeable-child supplement and allocates the package between Rooms and F&B.

Figure 3.3 — The Riverside Grove package logic, aligned to the worked workbook.

This is why the workbook’s Rooms ADR is about $108.11 even though the displayed double package rate is $230 and the single package rate is $140. Those are package prices, not the final Rooms-only ADR.

If your hotel sells room-only rates, you do not need this allocation step. If you sell full-board, half-board, activity-inclusive or other bundled packages, you do need a consistent allocation method so Rooms and F&B are not overstated.

Let us walk through Riverside Grove from capacity to Rooms revenue

The workbook keeps the logic visible so you can trace the annual result back to monthly assumptions.

The multiplication is not the hard part. The value of the model is that you can challenge every driver before accepting the $537,599 Rooms revenue result.

High season and low season need different commercial questions

When occupancy is low, the hotel has unused capacity. The question is how to create sensible additional demand.

When occupancy is already high, the question changes. You cannot grow every segment at once because the room inventory is constrained. Mix, rate and displacement become more important than simply filling another room.

Figure 3.4 — The same hotel should ask a different commercial question in weak and strong demand periods.

Use the first budget as a safe place to test commercial choices

A first formal budget is useful because it lets you model strategies before committing money or changing the market position.

• What if Direct grows from 15% to 25% of room nights?
• What if ADR rises 8% but occupancy falls three points?
• What if a new sales position creates 500 Corporate room nights?
• What if OTA promotions are used only in weak months instead of all year?
• What if a planned renovation removes room nights for two months but supports a higher rate afterwards?

You do not need dozens of scenarios. Change the few assumptions that actually alter the decision, then see what happens to Rooms revenue, departmental cost, GOP and cash.

Remember: the Rooms budget will drive much of the rest of the workbook

Occupied room nights are not only a revenue statistic. They create workload and cost across the hotel.

This is why we build Rooms before Labour and many operating expenses. The revenue plan creates the operating volume that later schedules must support.

Before you approve the Rooms plan, have this conversation

If these questions cannot be answered, I would not solve the problem by typing a different Rooms revenue total. I would go back to the assumption that is still weak.

Can you explain the Rooms budget without opening Excel?

The completed Rooms budget should end with a short commercial story. For Riverside Grove, I would expect something like this:

That tells me far more than “Rooms revenue is $537,599.”

Now for your hotel

What I want you to carry into Chapter 4

Do not start the Rooms budget with last year plus a growth percentage.

Start with sellable capacity. Build demand month by month. Decide how much of that demand you can capture. Decide who will provide the business and at what rate. Treat channel cost and package allocation consistently. Then calculate the revenue.

The sequence is:

Capacity → Demand → Capture → Business Mix → Rate and Channel Economics → Rooms Revenue

Build F&B and other revenue from the business behind the number

This is where many first budgets become inconsistent.

Rooms has been built from capacity, occupancy, mix and rate. Then management reaches Food & Beverage or Activities and suddenly the method changes: “Last year plus 8%.”

I would not accept that change in logic. If a revenue stream matters enough to appear in the budget, I want to understand the business activity that creates it.

That does not mean every restaurant, transfer, spa treatment or laundry transaction needs a complicated model. It means we choose enough detail to explain the revenue and manage it.

• Who buys this service?

• What creates the volume?

• What do they pay?

• Is the demand linked to hotel occupancy or to an external market?

• Can the hotel actually serve the volume?

• What additional direct cost follows the revenue?

• What management action is supposed to create the growth?

The same rule from the Rooms chapter still applies: budget the cause before the result.

Before we forecast another dollar, tell me what F&B business you actually run

Food & Beverage is a good place to see why one budgeting template should not be forced onto every independent hotel.

Imagine three properties that all show an F&B line in the accounts.

The point is not the percentages. The point is that the operating model decides the budget detail.

In Chapter 2 we already decided which revenue streams at your hotel are material, strategically important or operationally complex. Chapter 4 now turns that map into revenue logic.

Figure 4.1 — Revenue outside Rooms can come from several different demand engines. Do not force them into one formula.

First split the demand: are you serving the guest already in the hotel, or winning a separate customer?

One of the most useful distinctions in F&B planning is resident demand versus external demand.

Resident demand begins with a customer you have already brought into the hotel. Breakfast, package meals and room service often move with occupancy, guest-nights or the number of guests per room.

External demand is different. A local resident choosing dinner, a company booking a meeting, or a family holding a wedding is not created automatically because the hotel has occupied rooms.

Figure 4.2 — Resident and external F&B demand should normally be built from different assumptions.

For resident F&B, start with the guest opportunity - then ask how much of it you capture

Suppose breakfast is primarily purchased by in-house guests. A useful starting point could be:

If the hotel expects 600 occupied rooms, 1.6 guests per room, 80% breakfast participation and an average breakfast spend of $12, the logic is visible:

The exact formula is not sacred. What matters is that the number tells you what has to happen in the operation.

It also creates a better management conversation later. If breakfast revenue misses budget, you can ask whether occupancy was weak, the number of guests per room changed, participation fell, or spend was lower.

If the room rate includes meals, do not let the package hide the economics

Packages require special attention because one guest payment may contain several services.

A resort or lodge may sell one price covering accommodation, breakfast, dinner, an activity or a transfer. The guest sees one package. Management still needs to understand the economics of the services inside it.

If the entire package is treated as Rooms revenue while F&B carries all of the food and payroll cost, the departmental picture can become difficult to interpret. If, on the other hand, you count the same package value in Rooms and again in F&B, total hotel revenue is overstated.

So before you build the budget, decide which part is included, which part is allocated, and which part is genuinely incremental.

Riverside Grove makes this very visible

Riverside Grove Lodge sells a full-board package. In the worked example, the package revenue is deliberately allocated between Rooms and F&B so that the total payment is not counted twice.

For 2027, total package revenue - including the child supplement - is $977,454. The model allocates 55% to Rooms and 45% to F&B.

Figure 4.3 — Riverside Grove package allocation and incremental bar revenue in the companion workbook.

The F&B allocation is therefore $439,854. The model then adds $28,727 of incremental bar revenue, giving total F&B revenue of $468,581.

Why is the bar treated separately? Because this is additional guest spend beyond the package. The workbook assumes 25% bar participation per occupied room night and bar spend equal to 12% of the base package value. That is a different economic event from the included meal value.

Now separate volume from spend

When F&B is material, one of the simplest useful models is still one of the best: covers × average spend.

A cover is simply one customer served. If dinner serves 1,200 covers at an average spend of $28, revenue is $33,600.

That gives you two management questions instead of one accounting total:

• Are we serving enough customers?

• Are those customers spending enough?

Those are not the same problem. A restaurant can miss its revenue budget because too few people came, because each person spent less, or because the mix of guests and meal periods changed.

Figure 4.4 — Split revenue into volume, spend and mix before deciding what action is required.

This distinction becomes useful when actual results begin. If revenue is 10% below budget, covers may be 15% below while average spend is 6% above. Price is not the main problem; demand is.

Use breakfast, lunch and dinner detail only when somebody will manage them differently

Meal-period detail can be useful, but it can also become unnecessary spreadsheet weight.

If the restaurant actively prices, promotes and staffs these meal periods differently, the detail helps. If lunch is negligible and breakfast is already included in the package, three separate forecasts may not improve a decision.

Use detail because management needs it, not because a hotel spreadsheet normally contains it.

Local restaurant business needs its own reason to exist

A hotel restaurant that depends on external customers is not simply an extension of Rooms occupancy.

Its demand can depend on local competition, restaurant reputation, menu positioning, price, events, visibility, parking, access, local disposable income, corporate activity and seasonality.

So if management wants local dinner revenue to grow, I would ask for a small commercial story behind that growth.

The first statement gives us something to manage. We can ask whether the menu launched, whether the promotion ran, whether covers increased and whether the guests who came produced an acceptable spend and contribution.

Events do not behave like normal restaurant trade

Banquets, meetings and events can be lumpy. A single wedding can produce more revenue than several quiet restaurant days, so simply applying the restaurant growth percentage may be misleading.

Where event business is material, choose a driver that reflects the way it is sold. That may be:

• number of events × average revenue per event;

• expected event covers × average spend;

• a simple event-by-event pipeline where the hotel has enough information.

You may separate weddings, meetings, corporate functions and social events if management treats them differently. If the hotel hosts only a handful of small functions, a controlled monthly manual estimate may be better than a large event model.

Other revenue needs a business driver too

The same discipline applies to every other meaningful revenue stream. The driver should resemble what actually happens in the operation.

A first-time budget does not need a perfect driver. If you only know monthly spa revenue and a broad seasonal pattern, use that honestly. Do not invent treatment counts just to make the model look sophisticated.

Then improve the information you collect during the year. Next year, you may be able to budget treatments, utilisation and average spend because this year’s budgeting process taught you what data was missing.

Empty capacity is not the same as demand

This is a common trap when management is looking for new revenue.

The restaurant has empty tables. The spa has unused treatment rooms. The transfer vehicle is sometimes idle. It is tempting to say: “We have capacity, so we should budget more revenue.”

Capacity tells you what you could serve. It does not tell you that a customer wants to buy it.

Before I put the opportunity into the approved budget, I would want to know the route to market.

Figure 4.5 — A revenue idea becomes a budget assumption only when the demand and operating path are credible.

For a restaurant, that means asking whether the local customer base exists, whether the concept is attractive, whether the pricing fits the market, whether access and parking work, whether operating hours match demand, and what commercial action will create awareness and conversion.

The same questions apply to spa, transfers, guided activities and events.

A new revenue stream is a small business case, not just another line in Excel

Suppose you decide to introduce airport transfers. The Revenue sheet may show a new line, but the hotel may also need a driver, fuel, maintenance, insurance, licences, depreciation or lease cost, and a method for booking and collecting the revenue.

A spa can require therapists, products, linen, equipment, commissions and marketing. An activities business can require guides, transport, safety equipment or a third-party operator.

So when you add revenue, immediately ask what resources and risks arrive with it.

Before you celebrate turnover, ask how much contribution the activity leaves behind

Revenue can be impressive while the economics are weak.

The rough guide uses a simple example: an activity produces $100,000 of revenue, but $65,000 goes to the third-party operator and $15,000 to commission and transport. Only $20,000 remains before overhead. Another activity may generate only $60,000 of revenue but leave $35,000 after direct costs.

The smaller revenue line can be the better business.

Riverside Grove gives us the same preview. The completed Departmental P&L later shows $468,581 of F&B revenue producing $223,959 of departmental contribution, while $210,598 of Activities revenue produces $84,239 of contribution. We will build the payroll and direct-cost logic in later chapters; for now, the lesson is simply that revenue should never be judged without asking what it costs to produce.

When the opportunity is uncertain, test a few assumptions instead of pretending one number is certain

New revenue ideas are often more uncertain than established business. That is exactly when scenarios help.

Suppose the hotel plans a new local restaurant promotion. Instead of typing one optimistic revenue number, test a small range.

Then continue the conversation:

• What additional food cost follows?

• Do we need extra service or kitchen hours?

• What marketing spend is required?

• Can the restaurant serve the extra covers at the expected times?

• Does the opportunity still make economic sense after those costs?

This turns an idea into a business case rather than a wish list.

Every growth assumption should land somewhere else in the budget

Revenue does not sit alone. A connected budget makes the downstream consequence visible.

This is why the revenue chapters come before manpower and departmental expenses. Once the volume and commercial plan are visible, the later cost schedules have something real to respond to.

Write down why you believe the number - not only the number itself

The assumption register introduced earlier becomes more valuable as the budget grows.

Do not record only “Dinner revenue = $180,000.” Record the operating belief behind it.

Now the budget contains a statement that can be reviewed, challenged and eventually tested.

The assumption register should preserve five things

The register does not need to become bureaucracy. Its purpose is to preserve management’s reasoning.

Where possible, name the source: prior-year PMS data, POS report, signed contract, OTA production, competitor review, tourism information, supplier quotation, salary review or management judgement.

Do not rewrite the original assumption when the year changes

Once the year begins, your view will change. That is normal. The forecast should change when evidence changes.

But the approved budget should not be overwritten. Keep three views separate:

If you overwrite the original assumption, you lose the ability to judge both performance and forecasting quality.

Suppose F&B revenue was budgeted at $300,000 and actual was $270,000. “We missed by $30,000” is only the accounting result. The management questions are richer: Were covers below plan? Was average spend weak? Did resident occupancy underperform? Did the local promotion happen? Did a competitor open? Was the restaurant closed?

That is how the budget becomes a learning system rather than an annual file.

Quantitative assumptions tell me how much. Qualitative assumptions tell me why

Not every useful assumption is a percentage or a dollar value.

The qualitative note often explains why the quantitative number was chosen. Keep both when the context matters.

Now let us walk through Riverside Grove from the guest payment to the revenue schedule

Riverside Grove is deliberately useful for this chapter because it is not a rooms-only hotel. The room product is a full-board package, guests can spend incrementally at the bar, and Activities are material enough to budget separately.

The annual revenue plan in the companion workbook is:

Together, these three streams produce $1,216,779 of operating revenue. Notice how different the drivers are. Rooms and included F&B come from the same package payment but are allocated once. Bar revenue comes from an incremental participation assumption. Activities revenue comes from guest volume, participation and price.

The monthly model matters because the guest volume changes through the year

Riverside Grove does not divide annual revenue by twelve. Occupancy rises from 38% in January to 72% in December, so the package, bar and activity volumes rise with it.

January shows the logic in a compact way:

The Activity formula is particularly useful because it forces management to state three separate beliefs: how many guest opportunities exist, what percentage will participate, and what price will be achieved.

The workbook also leaves controlled input lines for local / extra meal covers, events and other activities. Riverside currently leaves those lines blank rather than inventing revenue simply because the template contains them. That is exactly the behaviour I want from a first budget.

Before you approve other revenue, make the manager tell you the story

For each meaningful revenue stream, I would finish with the following conversation.

The chapter should end with a revenue story, not a growth percentage

A weak summary says:

A useful summary sounds more like this:

That paragraph tells me how the business works. It also tells the GM what needs to be monitored once the year begins.

What I want you to carry into the next chapter

Other hotel revenue should be budgeted with the same discipline we used for Rooms:

Do not stop at “F&B +8%.” Explain why the growth exists, where it comes from, what it costs to deliver, who owns the action and what evidence will tell you whether the assumption is working.

Next we move to people - one of the hotel’s largest controllable costs.

The next question is not “What payroll percentage can we afford?” It is “What work does this plan require, which positions are needed, when are they needed, and what will they cost?”