Select Page

Prepare an Excel sheet that does a Monte Carlo analysis for the revenues (just the revenues) of the Tim Horton’s shop in the Student Union Building. Submit your Excel sheet as a separate part, but include the main conclusions (and your histogram) as an Executive Summary on this page. Be sure to include at least 5 different random variables and at least 3 different types of distributions. (I realize that you may need to make some heroic assumptions. I am not interested in the accuracy of your estimates per-se; I am more interested in your process and quality of your model development.
The question should be answered in an Excel sheet in addition to an Executive Summary as part of your submitted Word Document.