Document Type

Article

Publication Date

11-16-2015

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.

Comments

Required Publisher Statement
© Cornell University. This report may not be reproduced or distributed without the express permission of the publisher.

Share

COinS