Exhibit 14.9 The Following Questions Are Based on the Information Below

Essay

Exhibit 14.9
The following questions are based on the information below.
An investor is considering 4 investments, W, X, Y, and Z. The payoff from each investment is a function of the economic climate over the next 2 years. The economy can expand or decline. The following payoff matrix has been developed for the investment decision problem.
-A convenience store chain is considering opening a new store at one of four locations. They have developed the following multi-criteria scoring model for this problem. What formulas must be placed in cells C13:F16 to compute the weighted scores for use in generating a Weighted Score radar chart?