Cornell University
Library
Cornell UniversityLibrary

eCommons

Help
Log In(current)
  1. Home
  2. Cornell Peter and Stephanie Nolan School of Hotel Administration
  3. Centers and Institutes
  4. The Center for Hospitality Research (CHR)
  5. Center for Hospitality Research Tools
  6. Restaurant Reservations Optimization Tool

Restaurant Reservations Optimization Tool

File(s)
The_Restaurant_Reservations_Optimization_Tool_Instructions.pdf (192.72 KB)
0-Restaurant_Reservations_Optimization_Model_R1.xlsm (37.4 KB)
Released 11/2015
Permanent Link(s)
https://hdl.handle.net/1813/71293
Collections
Center for Hospitality Research Tools
Author
Thompson, Gary
Abstract

The purpose of this tool is to determine the best mix of tables in a restaurant, while simultaneously determining which reservations should be accepted from forecasted demand. A key parameter in the tool is the degree to which average dining durations are inflated. The tool user selects this inflation factor according to expectations regarding the extent to which parties will exceed the anticipated average dining time. Lower inflation factors result in more revenue, because more reservations are accepted, but also come with lower service levels, meaning more customers will need to wait for a table. Based on the user inputs, the tool, which uses the Solver add-in for Microsoft Excel, returns the optimum table mix for the greatest revenue.

Date Issued
2015-11-16
Keywords
Cornell
•
restaurants
•
tables mix
•
reservations
•
wait times
Rights
Required Publisher Statement: © Cornell University. This report may not be reproduced or distributed without the express permission of the publisher.
Type
article

Site Statistics | Help

About eCommons | Policies | Terms of use | Contact Us

copyright © 2002-2026 Cornell University Library | Privacy | Web Accessibility Assistance