Question: answer needs to be in excel sheet BBT is considering migrating their servers to a cloud service, upgrading their existing servers, or doing nothing. A
answer needs to be in excel sheet
BBT is considering migrating their servers to a cloud service, upgrading their existing servers, or doing nothing. A payoff table (in $ 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!
| Poor Market | Average Market | Good Market | |
| Cloud | -5 | 21 | 29 |
| Upgrade Servers | 10 | 15 | 27 |
| Do nothing | 0 | -9 | -15 |
| 0.29 | 0.53 | 0.18 |
In # 1 and #2, provide the value of the criterion and the associated decision. For example, for #1, an answer could be Best EMV = 100; Decision = Do nothing.
1.
2.
a.
b.
c.
d.
3.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
