Cornell Offers Spreadsheet to Generate Optimum Restaurant Seating

Nov 30, 2015

FOR IMMEDIATE RELEASE:

Cornell Offers Spreadsheet to Generate Optimum Restaurant Seating

Ithaca, NY, November 30, 2015 – A new tool from the Center for Hospitality Research (CHR) allows restaurateurs to optimize their reservations and seating using Microsoft's Excel spreadsheet. The tool and description, "Instructions for the Restaurant Reservations Optimization Tool," by Gary Thompson, are available from CHR at no charge. Thompson is a professor at the Cornell School of Hotel Administration. 

"The tool uses the Solver add-in for Excel, which allows restaurant operators to determine their best mix of tables and also decide which reservations they should accept based on their demand forecast," Thompson explained. "As part of this calculation, the operator does have to make an estimate of how much to inflate the amount of time guests will be seated at the table, since dining duration is an important aspect of when tables will become available and when reservations can be accepted." 

Thompson added that the "inflation factor" for dining time influences revenue and service levels, since a lower inflation factor would result in more revenue, but also risks lower service levels since it could leave customers waiting for a table. 

The instruction document depicts the components of the tool and explains how to use the tool by presenting a practical example of table mix optimization for two nights. Thompson also shows the optimization model behind the tool. 

"In my explanation and examples, I have set up the tool for four table sizes and eight reservation time slots, because of limitations in the basic Solver add-in," Thompson said. "But this can easily be expanded by upgrading Solver's capabilities, as I explain in the tool instructions."

About the Center for Hospitality Research
The purpose of the Center for Hospitality Research is to enable and conduct research of significance to the global hospitality and related service industries. CHR also works to improve the connections between academe and industry, continuing the School of Hotel Administration's long-standing tradition of service to the hospitality industry. Founded in 1992, CHR remains the industry's foremost creator and distributor of timely research, all of which is posted at no charge for all to use. In addition to its industry advisory board, CHR convenes several industry roundtables each year for the purpose of identifying new issues affecting the hospitality industry.

Center Members: Accenture, Access Point Financial, Inc., Cvent, Davis & Gilbert LLP, Deloitte & Touche USA LLP, Denihan Hospitality Group, Duetto, Four Seasons Hotels and Resorts, Fox Rothschild LLP, Hilton Worldwide, Host Hotels & Resorts, Hyatt Hotels Corporation, Infosys Limited, Intel Corporation, InterContinental Hotels Group, Jumeirah Group, Marriott International, NTT DATA, priceline.com, PwC, The Rainmaker Group, RateGain, ReviewPro, Sabre Hospitality Solutions, SAS, STR, Taj Hotels Resorts and Palaces, Talent Plus, Tata Consultancy Services, TripAdvisor, Wipro EcoEnergy, and Wyndham Hotel Group