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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!