Cornell Offers Spreadsheet to Generate Optimum Restaurant Seating
November 30, 2015 10:47am
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."
Tags: 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
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
Please login or register to post a comment.