Early Bird & Night Owl Evaluation Tool (EBNOET) v2015

The early bird and night owl restaurant tool found in the accompanying Excel file provides an estimate of the effects of offering off-peak special menu prices. Unlike the classic back-of-envelope calculation, the tool includes the effect of anticipated cannibalization of full-price covers and seeks to optimize table use. The tool also considers the revenue from new customers attracted by the early bird or night owl promotions, as well as the level of increased business needed to achieve the net monetary value target for the promotion.

Differential Evolution: A Tool for Global Optimization

This report describes a tool for global optimization that implements the Differential Evolution optimization algorithm as a new Excel add-in. The tool takes a step beyond Excel’s Solver add-in, because Solver often returns a local minimum, that is, a minimum that is less than or equal to nearby points, while Differential Evolution solves for the global minimum, which includes all feasible points. Despite complex underlying mathematics, the tool is relatively easy to use, and can be applied to practical optimization problems, such as establishing pricing and awards in a hotel loyalty program. The report demonstrates an example of how to develop an optimum approach to that problem.