The hotelier’s ultimate guide to occupancy forecasting

In this guide, we'll walk through a step-by-step process to forecast hotel occupancy using real datasets.

Forecasting future occupancy levels allows hoteliers to:

• Optimize dynamic pricing strategies

• Improve resource allocation

• Build realistic financial and budget goals

Smaller hotels benefit from occupancy forecasting just as much as large chains; clearer revenue flows, better planning and less reactive decision-making.

Here's a common challenge revenue managers regularly face: 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 catch: they want it built manually, with no RMS forecasts, no algorithms, no AI.

It's a useful exercise even when an RMS forecast is available, because it forces you to look at every input on its own merits.

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.

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.

• Seasonality, market conditions, events and unique factors must all be layered onto the forecast.

• Pickup, pace, stay patterns and market mix reveal how demand is shifting in real time.

• Effective forecasting combines historical trends, BI insights, segmentation, cancellations and event strength.

• Manually created and BI-generated forecasts complement each other — use both.

How to calculate hotel occupancy

The occupancy formula is straightforward:

Occupancy rate = rooms sold ÷ rooms available × 100

For a forecast, the same formula applies to projected numbers:

Forecast occupancy = forecast rooms sold ÷ forecast rooms available × 100

Rooms available should reflect your real sellable inventory, which means excluding out-of-order rooms and any known inventory changes during the forecast window.

Hotel occupancy forecasting methods

Most revenue managers use one or more of four forecasting methods. They aren't mutually exclusive; stronger forecasts layer them together.

A pragmatic occupancy forecast uses historical performance as the anchor, pace to refine it and unique-factor adjustments to account for what last year cannot tell you. Automated forecasts from a BI platform or RMS add a second baseline to check against. The rest of this guide walks through that approach in detail.

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 be specific about the date range in question.

For this example, the goal is straightforward: create an occupancy forecast for October. That's 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 compare it to previous October occupancy forecasts and learn from year-over-year patterns.

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 to 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 and 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 occupancy might look like for the coming year.

Digging into the historical data, you can see that the past three Octobers have run at 85%, 93% and 93% occupancy.

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-pandemic 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 the deviation from the norm.

For this example hotel, October is historically a strong month. Averaging the past three years gets you to 1,934 rooms sold (or 90.42% occupancy) for the month.

That said, this number isn't a valid forecast — historical results aren't indicative of future performance, and 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, you still have to contend with cancellations, out-of-service rooms and other factors that can jeopardize the sellout.

For this reason, calculate the total number of rooms available for sale over the forecast period (2,139 rooms) and consider this as an upper constraint. Realistically, the forecast shouldn't exceed it.

Seasonal trends

It's also beneficial to collect data on seasonal trends — not just how past Octobers have performed, but specifically how October as a month stacks up versus the surrounding months of the year and why it performs that way.

This "seasonality" factor is more multifaceted than it may initially appear, and includes many other factors discussed 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 it receives through the winter.

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 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 and sellout constraints

In the discussion of historical performance above, we conclude with a consideration of upper constraints. 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 that you have a well-defined timeframe, plus context about historical performance and seasonality, assess unique factors that may influence the forecast as you analyze the data.

A few common factors:

• Your hotel is renovating and has many hotel rooms out of service. Or a competitor is renovating, which is boosting demand at your hotel.

• Fluctuations in market supply: Many new hotels may be opening in your area, 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, run through a quick checklist:

• 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 your 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.

In this example, the only one that made an impact on the forecast decision-making was the lower-than-average October occupancy two years ago. After reviewing it, that softness was unsurprisingly caused by a slow first two weeks due to post-pandemic event cancellations, which continued to affect this market well into the following year.

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 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.

Lighthouse Performance's Pace Graph lets you compare pickup and pace side by side. In this scenario, 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 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 28 October. This group has pros and cons, but is a big reason the pickup and pace metric looks as promising as it does.

To ensure booking pace comparisons remain meaningful, 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 and event calendars

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.

Comparing this year's October event calendar with last year's, the 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 pull anticipated attendee data for many of the events on the calendar. Looking out across the events for this coming October, 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 this year and their anticipated attendee counts.

But you shouldn't immediately assume occupancy will be lower; you're only scratching the surface of the analysis. For now, anticipate some minor headwinds this year, especially on weekends.

To build a more complete demand picture, 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 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.

This example hotel has a relatively balanced stay pattern, with occupancy ramping up through the week, ultimately leading to the strongest nights for occupancy in a leisure-focused hotel: Friday and Saturday.

Remember the demand component and the lighter event calendar this year? Looking at pace by day of week, weekdays are driving all of the positive pace and, as might be expected, weekends are slipping behind. This aligns with the 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.

A forecast that says "1,000 room nights this month" is fine. A forecast that says "250 government, 500 retail, 250 tour group" is something you can actually plan against.

There are many ways to incorporate market mix analysis into hotel revenue management, but a good starting point is to analyze current booked production.

Recalling the pace chart, you have a solid variance – but can you explain it by market segment? Yes.

A deeper analysis reveals an uptick in transient, qualified discount and transient negotiated business.

Group SMERF and group corporate are adding nice positive variances. The largest negative variances are in the transient discount and group social segments.

To make this analysis more actionable, 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 to analyze is cancellations for a certain segment.

Knowing that much of the 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 over the past two years, 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

To generate the forecast, many revenue managers use spreadsheets. It's far more efficient to use the Budget & Forecast feature in Lighthouse Performance.

Start by creating a user forecast using last year's performance as a template. Modify it based on the data analysis and findings above.

Based on the softer event calendar and lower attendee counts for the current year, reduce the weekend to-be by several room nights on both Fridays and Saturdays. Some reasons for the change:

• You're 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 it will likely be even harder to sell out this year.

Using the findings from the market mix and stay-pattern analysis above, the week of 27 October will likely present some challenges due to the large group allocation on the books for 28 and 29 October. From a stay-pattern perspective, this will reduce stay-through availability and negatively impact the Sunday. For this reason, reduce the to-be by a significant amount to account for this disruption in the stay pattern.

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, 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 given the 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, 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 the forecast?

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

All signs point toward 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.

This example also highlights the value of combining human context and market knowledge with automated forecasting models; 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, Lighthouse Performance supports forecasting workflows by bringing historical trends, pickup, segmentation and predictive analytics models into one clear, actionable view.

How Lighthouse Performance supports occupancy forecasting

Forecasting occupancy is an involved process even for experienced revenue managers. Compiling historical data and analyzing multiple variables is demanding, but with the right platform the process is considerably faster and the outputs more reliable.

A user-created forecast is always a welcome complement to a system-generated one. The more forecasts a revenue manager can weigh, the more accurately they can predict performance and plan with confidence.

Lighthouse Performance brings historical trends, pace, pickup and segmentation into one workspace. Revenue Agent's Smart Summaries delivers a daily performance narrative so you're not starting each session by reconstructing context. Smart Insights surfaces pace shifts and segment-level opportunities over the next 90 days, so a manual forecast starts from a sharper read of the current market.

The Budget & Forecast feature lets you input manual forecasts alongside system-generated ones, save multiple versions and track variance against budgets and actuals as the period plays out.

By manually adjusting forecasts based on events, segmentation, cancellations or operational constraints, you gain greater control over the narrative of your performance and can clearly explain why a forecast looks the way it does. This strengthens decision-making, improves cross-team alignment and makes it easier to challenge or validate automated forecasts rather than accepting them uncritically.

FAQs

How far in advance should a hotel forecast occupancy?

Most hotels forecast at least 90 days ahead, updating more frequently in the final 30 days as pickup patterns shift. Portfolios and group-heavy properties often maintain a 365-day forward view.

What forecasting methods do hotels use?

Four main methods: historical or moving average (prior-year performance), pace-based (on-the-books pace versus STLY), regression or time series (statistical modeling) and AI-assisted forecasts from an RMS or BI platform. Most revenue teams combine at least two.

What data is most important for accurate occupancy forecasting?

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

What is a good hotel forecast accuracy benchmark?

Most revenue teams aim for forecast accuracy within ±3-5% of actual occupancy on a monthly view, tightening in the final 30 days. Shorter windows are more volatile.

How often should occupancy forecasts be updated?

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

How is occupancy forecasting different from budgeting?

A budget is a target set before the period starts. A forecast is an ongoing prediction of where the period will actually land. Budgets change rarely; forecasts should update as pace and demand signals evolve.

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.