Hotel Sales Forecast Example

Our Hotel Sales Forecast Structure covers all the essential aspects you need to consider when starting or scaling a Hotel business. By following this structure, you can better understand your revenue streams and align your vision with realistic expectations while ensuring operational readiness and securing investor confidence.

Sales forecasting is a critical process for any hotel business—whether you’re running a boutique hotel, a large resort, or a chain of properties. It provides a roadmap of expected revenues based on realistic assumptions and helps align operations, staffing, and marketing strategies. Additionally, a well-thought-out sales forecast allows business owners and investors to make informed decisions about resource allocation, expansion opportunities, and cash flow management. In an industry heavily influenced by seasonality, market trends, and varying demand, accurate forecasting can be the difference between success and failure. Developing a precise Hotel Sales Forecast is essential for gaining a competitive edge in such a dynamic industry.

How to Forecast Sales for Hotel Business

To develop an accurate Hotel Sales Forecast for a hotel business, it is essential to identify all the different revenue streams that contribute to overall income. Here are the primary revenue streams you should consider:

• Room Revenue: This is the most significant revenue stream for most hotels. It is generated by guests booking rooms for overnight stays. Factors such as occupancy rates, average daily rates (ADR), and room types all influence total room revenue.
• Food and Beverage (F&B): Hotels that offer restaurants, bars, or room service earn revenue through food and drink sales. This category may also include catering services for events.
• Meetings and Events: Revenue from organizing corporate meetings, weddings, and other events. This includes room rentals, equipment, and related service charges.
• Spa and Wellness: Hotels with amenities such as spas or wellness centers can generate additional income from services like massages, yoga classes, or wellness packages.
• Parking Fees: Urban or airport hotels often charge for parking, contributing to overall income.
• Ancillary Services: Services such as laundry, airport shuttles, concierge services, and in-room entertainment can also add to the revenue mix.
• Retail & Merchandise: Some hotels earn revenue by operating gift shops or selling branded merchandise.
• Franchise or Management Fees: For hotel chains or owners of multiple properties under different brand names, franchise or management fees may be a source of revenue.

Define the Calculation Logic & Drivers (Assumptions) for Hotel

Driver-based financial planning involves forecasting financial performance based on key operational drivers (also known as assumptions or activities) that generate revenue. A Hotel Sales Forecast is a cornerstone of this process, as it connects these operational drivers to financial outcomes. Each revenue stream has specific drivers that inform how much revenue is expected. Here’s how to define those for each revenue stream:

• Room Revenue:
  Drivers: Number of available rooms, occupancy rate, average daily rate (ADR)
  Formula: Room Revenue = Available Rooms × Occupancy Rate × ADR × 365
• Food and Beverage (F&B):
  Drivers: Number of guests per day, average spend per guest, occupancy rate (to determine guest flow)
  Formula: F&B Revenue = Guests per Day × Average Spend × 365
• Meetings and Events:
  Drivers: Number of events per month, average revenue per event
  Formula: Event Revenue = Events per Month × Avg Revenue per Event × 12
• Spa and Wellness:
  Drivers: Number of spa users per day, average spend per visit
  Formula: Spa Revenue = Daily Users × Avg Spend × 365
• Parking Fees:
  Drivers: Percentage of guests using parking, parking fee per day
  Formula: Parking Revenue = Room Nights × % Using Parking × Fee
• Ancillary Services:
  Drivers: Usage rate per guest, average fee per use
  Formula: Ancillary Revenue = Total Guests × Avg Spend Per Guest
• Retail & Merchandise:
  Drivers: Average daily sales from the shop
  Formula: Retail Revenue = Daily Avg Sales × 365
• Franchise or Management Fees:
  Drivers: % of revenues from managed properties
  Formula: Franchise Revenue = % Fee × Managed Property Revenues

Gather Data for Your Assumptions

There are generally two sources of data for building the assumptions that drive your hotel sales forecast:

1. Historical Performance: Existing hotels with several years of operations can pull from past data for metrics such as occupancy rates, average daily room rates, and average customer spend. This method is particularly useful for stable properties where past trends are a reasonable proxy for future performance.
2. Industry and Competitor Benchmarks: Startups, new hotel developments, or high-growth ventures may not have sufficient historical data. In these cases, industry averages and competitor data are essential for setting realistic benchmarks and estimating potential performance.

In practice, most forecasts are a blend of both. For example, a new hotel in a chain may use the chain’s historic data combined with local market occupancy benchmarks to estimate future performance.

Sense Check Your Sales Forecast

Once the forecast is complete, it’s critical to validate it using several sense-checking methods to ensure it’s realistic and credible:

1. Forecast Revenue Growth vs. Past Revenue Growth: Compare your expected growth rates to historical ones. If you are forecasting a 25% annual growth in revenue but historically achieved only 5%, you must justify the leap—perhaps due to a major renovation or a new marketing strategy.
2. Competitor Benchmarks: Cross-reference your assumptions with those of local competitors or published industry reports.
   Example: If your average daily rate (ADR) is forecast at $300 while competitors in the same area charge $150, you’ll need to explain why your offering justifies a 2x premium, or lower your expectations.
3. Market Share Sense Check: Determine what percentage of the local or regional market you are aiming to capture within 5 years. If you’re currently at 1% market share and expect to reach 20%, compare that to the market leader’s share to see if it’s feasible, given your positioning and resources.
4. Capacity Constraints: Validate that your physical or logistical capacity supports your forecast.
   Example: A hotel with 100 rooms cannot physically achieve more than 36,500 room nights per year (100 rooms × 365 days). If your forecast shows 50,000 room nights, this is unrealistic unless you’re counting multiple properties.

Hotel Sales Forecast Summary

The purpose of a sales forecast is not just to create numbers for a spreadsheet—it should serve as a strategic planning tool that helps owners, managers, and investors:

• Understand how the hotel will perform financially over time.
• Gain confidence that the business plan is solid, logical, and achievable.
• Prepare for staffing and operational demands based on anticipated guest volumes.
• Establish revenue targets and performance benchmarks for internal teams.

Taking a structured, driver-based approach ensures that every piece of your Hotel Sales Forecast is grounded in realistic, goal-oriented planning.

If you want to know more about driver-based financial planning and why it is the right way to plan, see the founder of Modeliks explaining it in the video below.

If you need help with your sales forecast, try Modeliks , a financial planning solution for SMEs and startups or contact us at contact@modeliks.com and we can help.

Author:
Blagoja Hamamdjiev , Founder and CEO of Modeliks , Entrepreneur, and business planning expert.

In the last 20 years, he helped everything from startups to multi-billion-dollar conglomerates plan, manage, fundraise, and grow.