The hotelier’s ultimate guide to occupancy forecasting

In this guide, we’ll revisit the basic fundamentals of revenue management and walk through a step-by-step process to effectively forecast hotel occupancy using real datasets.

Forecasting future occupancy levels allows hoteliers to:

• Optimize dynamic pricing strategies

• Improve resource allocation

• Build realistic financial/budget goals

This guide will serve as a comprehensive resource, providing valuable insights and practical tools to guide your forecasting efforts. And, we’ll use a real-life revenue management situation to learn how to forecast occupancy effectively.

If you’re an independent hotelier who isn’t used to the whole process of regular forecasting, be sure to read on - reliable forecasts aren’t just for the large teams and major chains. It’s increasingly important for even smaller hotels to forecast occupancy and demand to better understand revenue flows and plan for future uncertainty.

As a a hotelier, here is a common challenge which you will regularly encounter:

Hotel management wants an occupancy forecast for the month of October. The good news is, it’s currently mid-summer, so you still have a few months of lead-time.

The bad news however, is that the management has requested a manually-created forecast, meaning no RMS forecasts, algorithms or Artificial Intelligence when creating our forecasted occupancy rate for the period.

Sounds scary?

Don’t worry. It shouldn’t be intimidating if you follow some logical steps to arrive at a data-driven occupancy forecast.

So, let’s get started.

A well-structured forecast gives you the confidence to make everyday revenue decisions – from rate changes to staffing plans – based on evidence rather than instinct alone and boost their bookings into the bargain.

It’s also important to remember that hospitality industry forecasting isn’t static. Traveler behavior, booking windows, and market and economic conditions continue to shift. Regularly revisiting and refining forecasts ensures they remain relevant, accurate and useful as demand patterns evolve.

Key takeaways

• A reliable occupancy forecast starts with a clearly defined time frame and strong historical data that provides context but not the final answer.

• Seasonality, market conditions, events and unique factors (like renovations or supply changes) all meaningfully influence demand and must be layered onto the forecast.

• Pickup, pace, stay patterns and market mix are core drivers that reveal how demand is shifting in real time and help refine accuracy.

Effective forecasting combines multiple inputs – historical trends, BI insights, segmentation, cancellations and event strength – to build a realistic, defensible projection.

Manually created forecasts and business intelligence-generated forecasts complement each other, helping hoteliers forecast with greater clarity and confidence as they plan for future performance.

1. Determine your forecasting time frame

It’s important to define exactly which time frame you’re forecasting occupancy for to cut down on vagueness and confusion. The process of forecasting for a single night, a month or an entire year will vary quite a bit, so it’s important to define exactly what the date range in question is.

An effective occupancy forecast is clearly defined; for this example, our goal is straightforward enough: to create an occupancy forecast for October. This is much more quantifiable and effective than forecasting ‘for the next 30 days or so’ or ‘the next couple of months’.

By keeping your occupancy forecast quantifiable and well-defined, you can use this to compare your forecast to other, previous October occupancy forecasts which can help us when doing other processes such as forecasting.

For example, forecasting occupancy for a single event weekend requires a much narrower focus on pickup, pace, and market demand, whereas forecasting for an entire month involves balancing high- and low-demand periods (also known as seasonality), cancellations and shifting booking windows.

Without a clearly defined window, it becomes difficult to apply the right data, assumptions or actions to the forecast.

Setting the forecasting time frame also helps align teams across the hotel.

Revenue, front office, sales and housekeeping can all plan against the same expectations, reducing last-minute surprises and improving operational coordination. Whether adjusting room rates, scheduling staff, preparing inventory or managing group demand.

2. Collect historical data to inform your forecast

Historical performance

One of the easiest ways in which you can forecast occupancy is to first gather data about your hotel’s historical performance for the same (or similar) period you’re forecasting for.

Using a combination of a business intelligence tool, a benchmarking tool (to get a better idea of your compset’s performance) and a rate shopping tool, you can quickly assess how your hotel has performed for a certain month for at least the last few years..

In practice, this data typically comes from standard PMS reports like monthly occupancy, average daily rate (ADR) and revenue per available room (RevPAR) summaries, rooms sold by date or pickup reports, as well as BI dashboards that consolidate performance trends across multiple years in one view.

Analyzing historical performance is a great place to start because it’s very simple. By analyzing previous years, you can piece together basic guidance that indicates what our occupancy might look like for the coming year.

Digging into our historical data, you can see that the past three Octobers have experienced occupancy performance of (85%, 93% and 93%) for the 2021, 2022 and 2023 time series.

When reviewing historical performance, it’s also important to flag any abnormal years that could skew expectations, such as periods impacted by renovations, temporary closures, supply changes or post-Covid recovery dynamics.

These years may still offer insight but they should be interpreted with care rather than treated as direct benchmarks.

Knowing this, it likely wouldn’t make sense to forecast 96% occupancy unless there was a major factor that justified this deviation from the norm.

Here’s a look at how easy it is to pull historical performance data from BI, using last year’s occupancy and rooms sold.

Here’s an easy visual of room nights sold for the past 3 years:

For our example hotel you can see that October is historically a strong month for us. Averaging our 2021-2023 performance you get 1934 rooms sold (or 90.42% occupancy) for the month.

That said, this number isn’t a valid forecast, as historical results aren’t indicative of future performance; averages provide context, not a final forecast.

Historical performance sets realistic boundaries for your forecast but it should always be adjusted as new demand signals emerge.

Remember: most of the time, hoteliers don’t expect to sell every available room every single time (although you certainly would if you could).

Even in periods of excessively high hotel demand, we still have to contend with cancellations, out-of-service rooms and other factors that can jeopardize the sellout.

For this reason, you will want to calculate the total number of rooms available for sale over the forecast period (2,139 rooms) and consider this as an upper constraint, as you know this realistically won’t happen. Our forecast should not exceed this number.

Seasonal trends

In addition, it’s beneficial to collect data on seasonal trends, so not only how past Octobers have performed but specifically how October as a month stacks up vs the surrounding months of the year and why it performs this way.

This ‘seasonality’ factor is very important as it is more multifaceted than it may initially appear, and includes many other factors that we will discuss in more detail below (such as events).

Examples of where seasonality greatly impacts a hotel’s forecast include:

A hotel in a warm climate (such as Miami or San Diego) might see an uptick in occupancy due to a busy convention calendar in winter months, a time of year when more northern cities aren’t a desirable destination.

Hotels in the northeastern United States often see a flurry of high demand in the fall when the picturesque foliage begins to change color. As soon as the display is over though, hotels often experience their slowest, most low-demand period of the year.

A ski resort in the Alps will often see its high and low seasons directly dictated by the level of snowfall that it receives through the winter.

Returning to our example hotel to learn more about its seasonality, let’s look at the average October performance vs the other months of the year going back to 2021.

Seasonality is ultimately shaped by broader travel patterns, which influence when and why guests choose to travel. These include school holiday calendars, corporate budget cycles, weather trends and shifting leisure behavior which can be brought on by political or economic conditions.

To keep this insight actionable over time, many hotels benefit from maintaining a simple, recurring ‘seasonality notes’ file each year, recording factors like unusual weather, changing event calendars, new demand drivers or weaker-than-expected periods.

These qualitative notes help contextualize future forecasts and explain why seasonal patterns evolve rather than remain fixed.

Rooms available / sellout constraints

In our discussion of historical performance above, we conclude with a consideration of upper constraints.

You should also add that sellouts are rare because hotels almost always have rooms that are out of order (OOO) due to routine maintenance cycles, preventative repairs, deep cleaning or light renovation work.

Even in strong demand periods, these operational realities reduce the number of rooms truly available for sale and should always be factored into a realistic occupancy forecast, especially for newer hoteliers who may otherwise assume full availability is the norm.

3. Account for unique factors that impact occupancy

Now you have a well-defined timeframe you’d like to forecast for, and then some additional context about historical performance and seasonality, you should assess unique factors that may influence any future findings you encounter as you analyze the data.

Here are a few common factors:

• Perhaps your hotel is renovating and has many hotel rooms out of service. Perhaps a competitor is renovating which is boosting demand at our hotel.

• Fluctuations in market supply; many new hotels may be opening in your area which is diluting occupancy at your hotel.

• Natural disasters – for example, if a competitor hotel experiences flooding while your hotel remains unaffected.

• Macro-Economic-level market trends, political unrest or recession.

When reviewing a future period, it’s helpful to run through a quick checklist such as:

• Are any rooms out of order due to maintenance or renovation?

• Have competitors opened, closed or reduced inventory?

• Are there major events added, canceled or relocated?

• Have booking windows, cancellation behavior or group demand changed?

• Are there broader economic, travel, weather-related or other external factors affecting demand?

• What do our online reviews look like?

Running this checklist each month helps ensure no material factor is overlooked before finalizing an occupancy forecast.

If you find that any unique factors are affecting your hotel, note them and refer back to them if you see any unexpected data points.

The only one that made an impact on the forecast decision-making here was reviewing the lower-than-average October 2021 occupancy performance.

After reviewing this, it was unsurprisingly caused by a slow first two weeks due to post-Covid event cancellations, which continued to plague this market well into 2021 and the first half of 2022.

To keep these factors from being forgotten, many general managers and revenue managers maintain a simple ‘risk and opportunity log’.

This can be a shared document or note where unique demand drivers are recorded along with their observed impact on occupancy.

Over time, this log becomes a valuable reference when similar conditions reappear, helping teams move faster and forecast with greater confidence rather than relying on memory alone.

4. Conduct data analysis

Pickup and pace

Pickup and pace are always top of mind for revenue managers.

You can use these metrics and KPIs to continually hone your occupancy forecast over time. Valuable questions we can ask include:

Are you already pacing ahead of where you thought you would be at this point in the booking curve?

Are you seeing pickup in an unexpected segment that will require you to revise your forecast up?

Tools like Lighthouse’s Performance help us look at pickup and pace side by side.

Examining pickup and pace charts in Lighthouse Performance, you can see pace is up by a strong margin (+138 room nights).

The dashed line in the chart below shows where you might expect to land for occupancy if you experience last year’s level of pickup, which in this case would be 2099 rooms sold or 98.13% occupancy.

Much like the rolling 3-year average example above, this also isn’t a valid, standalone forecast by itself. You can’t expect this year to play out in exactly the same way as last year; while it’s food for thought, it doesn’t include well thought out, rigorous analysis.

And what about pickup?

In the last 30 days, it’s been exceptionally strong when compared with last year, but much of that pickup is due to a corporate group (more on segmentation later) that was recently added for the week of 10/28.

You can see a screenshot of the group as it appears in BI in the image below. As you’ll discuss later, this group has pros and cons, but is a big reason why your pickup and pace metric looks as promising as it does.

To ensure booking pace comparisons remain meaningful, you should monitor pickup at consistent intervals – such as 7-day, 14-day and 30-day windows – so trends are evaluated on a like-for-like basis over time.

It’s also key to remember that large group blocks can temporarily distort pace figures, so these should always be reviewed in context and weighed against expected segment behavior before revising an occupancy forecast.

Demand (event calendars)

Additionally, understanding the anticipated level of future demand makes occupancy forecasting much easier. Strong, varied demand drivers create numerous opportunities for high occupancy from different types of travelers.

A good starting point for demand forecasting is to review an event calendar that shows various events along with their expected attendance.

Below is a comparison of our 2023 vs 2024 event calendars for the month of October. As it stands right now, the event calendar looks quite a bit softer this year, especially for weekends (and especially for Saturdays in the first half of the month).

In addition to the simple count of events, you can also get anticipated attendee data for many of the events on the calendar.

Looking out across the events for this coming October, our anticipated attendees attributable to known events appear to be about 20% lower than last year’s anticipated attendee counts.

While the situation may improve as you get closer to fall, there’s a slight decline in the number of conventions and conferences for 2024 and their anticipated attendee counts.

But you shouldn’t immediately assume occupancy will be lower as you’re only scratching the surface of our analysis.

For now, though, let’s anticipate that you may have some minor headwinds this year, especially on weekends.

To build a more complete demand picture, you should cross-check multiple event sources, including city and convention and visitors bureau (CVB) calendars, universities, major venues and local tourism boards. This will help you avoid missing smaller or newly announced demand drivers.

Stay pattern

Guests stay on all different days of the week and for varying lengths of stay (LOS).

Knowing their average LOS and on which days they tend to stay can bring crucial insights that lead to more accurate occupancy forecasts.

At your hotel you can see you have a relatively balanced stay pattern with occupancy ramping up through the week, ultimately leading to your strongest nights for occupancy in a leisure focused hotel which are Friday and Saturday.

Remember when we discussed the demand component and our lighter event calendar this year? Looking at pace by day of week, you can see our weekdays are driving all of our positive pace and as might be expected, weekends are slipping behind.

This aligns with our original assessment that there were potential weekend headwinds for occupancy.

Analyzing (LOS) alongside day-of-week patterns also helps identify compression weekends, where longer stays restrict availability on peak nights and can inflate midweek occupancy while limiting sellout potential on Fridays and Saturdays.

Market mix

Market mix is a crucial component to create the most accurate forecast possible.

It’s one thing to say: ‘You anticipate 1000 room nights this month.’ But it’s an entirely different level of detail to say: ‘You can anticipate 250 room nights of government segment business, 500 room nights of retail business and 250 room nights of tour-group segmented business.’

There are many ways to incorporate market mix analysis into hotel revenue management analysis, but a good starting point for using market segmentation to create an occupancy forecast is to analyze current booked production.

Recalling your pace chart, you know you have a solid variance but can you explain this by market segment?

The answer is yes. A deeper analysis reveals you’re experiencing an uptick in Transient, Qualified Discount and Transient Negotiated Business.

Also Group SMERF and Group Corporate are adding nice positive variances. Your largest negative variances are in the Transient Discount and Group Social segments.

To make this analysis more actionable, it’s helpful to build a simple monthly segmentation table that outlines the expected room nights contributed by each major segment, based on current bookings, historical patterns and known risks such as cancellations.

This level of segmentation not only improves occupancy forecasting accuracy but also supports more reliable ADR projections by clarifying which segments are likely to drive rate strength versus volume.

Cancellation patterns

A final aspect of market segmentation you should analyze is cancellations for a certain segment.

Knowing that much of our positive pace is owing to the group segment, you must pay attention to that segment’s tendency to cancel to ensure an accurate occupancy forecast.

Based on the cancellation to booking mix for 2023 and 2022, it looks like it’s reasonable to expect a 10% cancellation rate.

But remember to apply different wash percentages by segment if available.

5. Forecast future occupancy rates

Now let’s put pen to paper and actually generate your forecast. To do this, many revenue managers will use spreadsheets. It's far more efficient to use the forecast + budget module within the Business Intelligence space in Lighthouse Performance.

To start, you create a user forecast using last year’s performance as a template. This will be the template that you modified based on our data analysis and findings above.

Based on the softer event calendar and lower attendee counts for the current year, you reduced our weekend to-be by several room nights on both Fridays and Saturdays.

Some reasons for the change:

• You’ve already pacing behind STLY for weekends, with a softer event calendar.

• You weren’t consistently selling out last year on Fridays and Saturdays, and all indicators are showing that it will likely be even more to sell out this year.

Using your findings from the Market Mix and Stay-pattern analysis above, you know that the week of 10/27 will likely present some challenges due to the large group allocation on the books for 10/28 and 10/29.

• From a stay-pattern perspective, this will reduce stay-through availability and negatively impact the Sunday. For this reason, you reduce your ‘to-be's' by a significant amount to account for this disruption in the stay pattern likely to occur because of the group.

• Next, you account for group wash and reduce those that are to-be by 10% accordingly. This is in line with the cancellation rate that the hotel has seen over the past few years for this segment. While SMERF groups are up in pace, you still must account for group wash

Weekdays (except for the Sunday mentioned above) look strong; the to-be group was slightly increased for several midweek ‘peaks’ to better reflect how the hotel will likely perform based on current occupancy trends.

You can confidently forecast this way due to your findings in the pickup and pace section above, where you found positive midweek trends in pickup and pace in certain corporate segments.

Before reviewing the final output, it’s worth briefly clarifying the difference between forecasting room nights sold and forecasting occupancy.

Room-night forecasting allows for more precise adjustments at a daily, segment or stay-pattern level, while occupancy translates that volume into a performance metric that supports staffing, budgeting and owner reporting. In practice, effective forecasts often start with room nights and then roll up into an occupancy view.

As these adjustments are made, documenting the assumptions behind them is just as important as the numbers themselves. Noting factors such as event strength, group wash or shifts in pickup ensures internal clarity and alignment across revenue meetings, operations planning and ownership discussions.

It also creates a valuable reference point when forecasts are reviewed or refined later.

Finally, it’s important to treat occupancy forecasts as living documents. As pickup evolves and new information becomes available, forecasts should be revisited regularly to reflect changing demand conditions and maintain confidence in decision-making.

So, after all that, what was your forecast?

1,998 room nights sold (93.4%) occupancy +/- 1% to account for variability.

All signs point towards a reasonably strong October with performance very similar to the last two years but with a slight shift in segmentation favoring negotiated and group corporate.

Weekends will likely be slightly softer due to a less active event calendar and underwhelming recent transient pickup, but will likely still be relatively strong. Weekdays will likely see a slight lift to rooms sold due to stronger group and qualified discount production.

Here’s how our occupancy forecast stacks up with both LY’s totals and the algorithmically generated BI forecast.

This example also highlights the value of combining human context and market knowledge with automated forecasting models, as experienced judgment helps interpret anomalies and nuances that algorithms alone can’t always explain.

For hoteliers looking to streamline this process and surface these insights more consistently, the Lighthouse platform can support forecasting workflows by bringing historical trends, pickup, segmentation and predictive analytics models into one clear, actionable view.

Improve occupancy forecasts with a predictive market intelligence solution

Forecasting your hotel’s occupancy can be a complicated and involved process for even the most sophisticated hoteliers.

Compiling historical data and performing data analysis on a variety of variables can be a daunting task for hoteliers who aren’t armed with the right data.

But with quality data and a tech platform built for purpose, you can generate high-quality forecasts with relative ease, and there are major benefits to incorporating a user-forecasting process for your property.

A user-created forecast is always a welcome complement to an algorithmically-generated RMS forecast and/or a business intelligence tool’s forecast, as the more forecasts a hotelier can analyze and weigh, the more accurately they can predict their hotel’s performance and, ultimately, its profitability.

By manually adjusting forecasts based on events, segmentation, cancellations or operational constraints, you gain greater control over the narrative of their performance and can clearly explain why a forecast looks the way it does.

This transparency strengthens decision-making, improves cross-team alignment and makes it easier to challenge or validate automated forecasts rather than relying on them in isolation.

If you’d like to learn more about the tools used in this guide, visit us here.

FAQs

How far in advance should a hotel forecast occupancy?

Most hotels forecast at least ninety days ahead, updating forecasts more frequently in the final thirty days as pickup patterns shift.

What data is most important for accurate occupancy forecasting?

Historical performance, seasonality patterns, local events, pickup trends, cancellations and room availability all contribute to strong, reliable forecasts.

How often should forecasts be updated?

Weekly updates are ideal, especially for markets with short booking windows or high volatility.

What is the simplest forecasting method for small hotels?

A straightforward year-over-year approach, adjusted for events, pickup and cancellations, works well and improves with consistent use.

How does occupancy forecasting support pricing decisions?

Forecasts help hoteliers set more intentional pricing by revealing when demand is expected to rise or soften, reducing guesswork and reactive rate changes.