Contributor(s)

Benneyan, James, Legault, Craig

Abstract

The objective of this project is to develop a spreadsheet-based model that helps determine the optimal equipment allocation in new Allied Domecq Trombo facilities. Allied Domecq, the parent company of Dunkin Donuts, Baskin Robbins, and Togo, utilizes the concept of shared resources to combine their three brands into one store. The model ensures an acceptable range of customer wait time and equipment utilization. These constraints are based upon peak hour sales demand. Because variable demand is common to the retail environment, the model incorporates Monte Carlo analysis to simulate the impact of variation. With this probability addition, the static model helps determine the percentage of demand met with varying equipment types and levels.

Notes

Capstone Design Course, MIM 1501-1502, Technical Design Report, Final report

Keywords

spreadsheet-based model, optimal equipment allocation

Publication Date

2007

Permanent URL

http://hdl.handle.net/2047/d10011791


View Full Text

Click button above to open, or right-click to save.

Share

COinS