REQUIREMENT $2$: EVALUATING EXPANSION ALTERNATIVES

Background

IF is considering flying a new route from its hub in Ottawa. The management team had a market study done to

determine which cities people are flying to the most, and they found that there four cities close to Ottawa that

would make suitable routes.

You have been tasked to develop a model that can be used to evaluate these four new routes.

Tasks

$1.$ In the $$R$02\_$EXPANSION$$ worksheet, create a model that utilizes the Maximax, Maximin, Averaging, and

Expected Monetary Value heuristics.

$2.$ Apply conditional formatting that highlights the optimal value for each heuristic model with a green fill.