Cornell Research Center Issues New Forecasting Tool

Hotel revenue management forecasts are made clearer with this spreadsheet-based program

• 
  SAVE
• 
  SHARE
• 
  TEXT SIZE
• 
  PRINT
• 
  COMMENT
• 
  PDF

. September 05, 2009

ITHACA, MY, September 4, 2009 - A spreadsheet-based tool that will assist revenue managers in making demand forecasts is now available from Cornell's Center for Hospitality Research. The tool, "Revenue Management Forecasting Aggregation Analysis Tool," was developed by Gary Thompson, a professor at the Cornell School of Hotel Administration. The hotel revenue management tool and a user guide are available from the CHR at no charge at www.hotelschool.cornell.edu/research/chr/pubs/tools/.

"The key point here is to determine the aggregation level of the forecast," Thompson explained. "Hotel revenue managers usually forecast arrivals for each day, for each length of stay, and for each rate class. For each level of aggregation, the tool will evaluate three different methods of forecasting, two of which use a wide range of parameter values. Based on whichever of five error measurements is selected, this tool will show which forecast method is best, and rank-order the others."

The tool involves a series of worksheets that are formatted to allow hotel revenue managers to plug in their own historical data. The tool is limited to seven lengths of stay and five rate classes.

Meet and interact with Dr. Thompson, an active member of the executive education faculty at the School of Hotel Administration, when he presents sessions in the Professional Development Program: www.hotelschool.cornell.edu/industry/executive/pdp/.

Thanks to the support of the Center for Hospitality Research partners listed below, all publications posted on the center's website are available free of charge, at www.chr.cornell.edu.