Restaurant Reservations Optimization Tool
dc.contributor.author | Thompson, Gary | |
dc.date.accessioned | 2020-09-10T18:28:37Z | |
dc.date.available | 2020-09-10T18:28:37Z | |
dc.date.issued | 2015-11-16 | |
dc.description.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. | |
dc.description.legacydownloads | The_Restaurant_Reservations_Optimization_Tool_Instructions.pdf: 2090 downloads, before Aug. 1, 2020. | |
dc.description.legacydownloads | 0-Restaurant_Reservations_Optimization_Model_R1.xlsm: 860 downloads, before Aug. 1, 2020. | |
dc.identifier.other | 7847102 | |
dc.identifier.uri | https://hdl.handle.net/1813/71293 | |
dc.language.iso | en_US | |
dc.rights | Required Publisher Statement: © Cornell University. This report may not be reproduced or distributed without the express permission of the publisher. | |
dc.subject | Cornell | |
dc.subject | restaurants | |
dc.subject | tables mix | |
dc.subject | reservations | |
dc.subject | wait times | |
dc.title | Restaurant Reservations Optimization Tool | |
dc.type | article | |
local.authorAffiliation | Thompson, Gary: gmt1@cornell.edu Cornell University School of Hotel Administration |
Files
Original bundle
1 - 2 of 2
Loading...
- Name:
- The_Restaurant_Reservations_Optimization_Tool_Instructions.pdf
- Size:
- 192.72 KB
- Format:
- Adobe Portable Document Format
No Thumbnail Available
- Name:
- 0-Restaurant_Reservations_Optimization_Model_R1.xlsm
- Size:
- 37.4 KB
- Format:
- Unknown data format
- Description:
- Released 11/2015