School of Hotel Administration

Overbooking Practices in Hotel Revenue Management

Available dates

Nov 20, 2019
USD 769
Dec 4, 2019
USD 769
Dec 18, 2019
USD 769
+28 more options


Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with School of Hotel Administration.

Full disclaimer.

About the course

Businesses that accept reservations must cope with the problem of no-shows - customers who make a reservation but fail to honor it. Hotels can protect themselves from the revenue-losing no-shows and generate increased revenue by overbooking. This course teaches how to strategically overbook and how to manage issues associated with overbooking, as well as how to evaluate groups and determine which rates to charge.

This course explores the components of a successful overbooking strategy including no-show forecasting, no-show rates, arrival uncertainty, pricing policies, and cancellation forecasts. It explores the risks of overbooking and presents strategies to minimize costs and mitigate customer impact.

To fully realize a property’s revenue potential, managers must be able to manage group reservations. This course teaches participants how to create a group forecast and explores yieldable and non-yieldable business and incremental group costs and revenue opportunities. It introduces models to calculate displacement costs and contribution margins to determine which groups are most profitable.

Participants use Microsoft Excel to practice overbooking and group-management techniques.

Key Benefits

Participants who complete this course will be able to...

  • Develop an overbooking approach
  • Manage issues associated with overbooking
  • Evaluate groups
  • Determine appropriate group rates

Topics Include

Module 1 - Introduction to No-Shows

  • The Problem of No-Shows
  • Managing No-Shows
  • Assessing and Addressing No-Shows

Module 2 - No-Show Data and the Overbooking Decision

  • How Many No-Shows?
  • The Chances of a No-Show
  • Forecast the No-Shows

Module 3 - The Pros and Cons of Overbooking

  • Cost of Overbooking
  • When Overbooking Leads to Overselling
  • The Cost of Not Overbooking

Module 4 - The Overbooking Ratio Method

  • Components of an Overbooking Policy
  • Overbooking Ratio Method
  • Using Excel for Overbooking

Module 5 - Group Management Decisions

  • Groups and Group Decisions
  • Group Blocks
  • Group Value

Module 6 - Calculating Group Rates

  • Rate and Contribution
  • How Does Group Size Influence Rate?
  • Using Excel for Simple Displacement
  • Using Excel with Multiple Contributions

Module 7 - Group Forecasting

  • The Importance of Group Forecasting
  • Group Forecasting Methods

Who should attend

This course is designed for hospitality managers, general managers, revenue managers, and other hospitality professionals responsible for the financial performance of their organization.

Trust the experts

Sheryl Kimes

Education Qualifications PhD, Operations Management, University of Texas at Austin, 1987 MBA, New Mexico State University, 1983 MA, Public Administration, University of Virginia, 1977 AB, Political Science and Mathematics, University of Missouri, 1975 Academic Experience Visiting Professor,...


Course reviews

Downloadable files