1. In the R02_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 from each heuristic model with a green fill

Please show detailed steps

\begin{tabular}{|l|r|r|r|} \hline Net Income & \multicolumn{3}{|c|}{ Economic Forecast } \\ \hline \multicolumn{1}{|c|}{ Location } & Weak Demand & Moderate Demand & \multicolumn{1}{|c|}{ High Demand } \\ \hline Probability & 15% & 45% & 40% \\ \hline Glace Bay & (7,200) & 11,250 & 54,900 \\ \hline Waterloo & 4,050 & 22,950 & 31,950 \\ \hline Vancouver & (9,650) & 31,900 & 52,850 \\ \hline Red Deer & 6,950 & 28,750 & 47,250 \\ \hline \end{tabular}