Close

Cart

Total $0.00

Checkout

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.

Contact: Carol Zhe

caz9@cornell.edu / 607.254.4504

Related News

Text Analytics Reveal the Impact of Guest Sentiment on Hotel Review Scores

Radio Interview with Cornell's Professor Chekitan S. Dev on Hilton's New Tru Brand Targeting Millennials

Cornell Report Shows Hotel Brand Conversions Can Boost Performance

Center for Hospitality Research Reports on the New Science of Service Innovation

Cornell Analysis Finds Confusion in Recent Supreme Court Employment Decisions

Duetto's Marco Benvenuti is 2015-16 Pillsbury Institute Entrepreneur in Residence at Cornell's SHA

The Deepwater Horizon Oil Spill Damaged the Environment, the Travel Industry & Corporate Reputations

Cornell Study Analyzes Effects of EB-5 Financing on Hotel Development

Cuba Offers Great Opportunities and Great Obstacles, Says New Report

Disruption Equals Opportunity for Tech Entrepreneurs, Says Cornell Panel

Cornell Offers Sustainability Measurement Tool

Cornell Roundtable Focuses on Potential Model Union Contract

Cornell Study Finds Travelers Want More Mobile Options

Cornell Study Highlights Drivers of Risk Premium Paid for Hotel Loans

Cornell Study Supports Strategic Price Positioning in European Hotels

Say What You Mean - Do as You Say - Cornell Report Demonstrates the Power of Management Integrity

Cornell Study Finds that Loyal Sports Fans Focus on Complete Service Experience

Cornell Study Highlights Customers' Role in Service Quality

Cornell Study Introduces a "Canary" for Hotel Loan Delinquencies; Provides Metric for Early Warning

Cornell "Cyborg" Study Focuses on the Combination of Technology with Customer Service

All News »

Please login or register to post a comment.