v

Homework 5 BBT is considering migrating their servers to a cloud service, upgrading their existing servers, or doing nothing. A payoff table (in 9 millions) is provided in the accompanying spreadsheet. Using that table, answer the following questions: 1. What is the EMV of each alternative? Based on this analysis, what is the best decision? 2. Assume that the probabilities given are not reliable, then compute the criteria below and give the best decision for each. a. Maximin b. Maximax c. Equally likely (Laplace) d. Minimax regret 3. Based on your analysis in 1 and 2, what do you recommend? Defend your answer! Word File Edit View Insert Format Tools T AutoSave C 12 Hoc Sert Draw Page Layout Formulas Data Queries & Connections Properties Get Data (Power Query) Data from Picture Refresh All Edit Links Open recovered workbooks? Your recent changes were saved. Do you F16 XV fx B D 1 E F Nm 2 3 if 4 Cloud 5 Upgrade Servers 6 Do nothing 7 Poor Market Average Market Good Market -5 21 29 10 15 27 0 -9 -15 0.29 0.53 0.18 8 9 10 11 12 13