i cant attach two files . i have all info below along with my excel. can you review my excel doc and advise if my formulas and concepts are followed. instructions attached

Question Set 1. Samsung is considering different R&D paths for the upcoming year's release. The four strategies (along with changing nothing) under consideration are:

Decrease Depth: Decrease the depth of the phones without affecting other specs

More Battery Power: Increase battery capacity of phones by 7%

Mixed: Combine above two strategies somehow

No Change: Do not change anything, buyers seem content

The outcomes of the possible strategies (in millions of dollars) depend on how the competitors behave. Samsung considers four different outcomes, which are not shared, say A, B, C and D. Negative values indicate loss for Samsung and positive values indicates possible profits.

Scenarios

Strategy

A

B

C

D

Decrease Depth

-145

-35

60

150

More Battery Power

-55

-20

45

75

Mixed

-85

-25

50

90

No Change

-40

-15

50

40

For the following questions, you will use Excel to identify the best strategy according to various criteria. You only need to perform the necessary calculations to show which one is best. For example, the first question is for maximax. You need to set up formulas to find the maximum payoff for each strategy and to then find the highest value among them. However, once you have calculated that highest value, you can just type in the corresponding strategy without any further Excel calculations.

1. What would be Samsung's decision using the maximax criterion? (3pts)

2. What would be Samsung's decision using the maximin criterion? (3pts)

3. What would be Samsung's decision using the Laplace criterion? (3pts)

4. What would be Samsung's decision using the minimax regret criterion? It is helpful to construct a regret table for this problem. (6pts)

Question Set 2. This question set uses the table of outcomes from Question Set 1 for Samsung's strategies. Assume that the probabilities for scenarios are:

P(A) = 0.25

P(B) = 0.35

P(C) = 0.35

P(D) = 0.05

1. What decision will maximize Samsung's expected monetary value? (9pts)

2. What is the expected value of perfect information? (6pts)

Question Set 3. This question set uses the metropolitan model for facility location decisions. Each demand source has a weight indicating the volume of sales it is expected to generate. Using the demand data and five potential locations on the following page:

1. Find the sum of weighted metropolitan model distances for each of the five locations. Be sure the calculations are shown for each location's sum of distances. (8pts)

2. As evidenced by having the smallest weighted sum of distances, which location is best? (2pts)

Demand Data

Weight

my work attached tables attached in excel file

Scenarios Strategy Decrease Depth More Battery Power Mixed No Change A -145 -55 -85 -40 B -35 -20 -25 -15 C 60 45 50 50 1) Maximax 150 (Decrease Depth) 2) Maximin -40 (More Battery Power) 3) Laplace D 150 75 90 40 Maximum Minimum 150 -145 75 -55 90 -85 50 -40 D 0 75 60 110 Maximum 105 75 60 110 11.25 (No Change ) 4) Minimax regret 60 (More Battery Power) regret table Strategy Decrease Depth More Battery Power Mixed No Change A 105 15 45 0 Scenarios B C 20 0 5 15 10 10 0 10 Average 7.5 11.25 7.5 8.75 Scenarios Probability Strategy Decrease Depth More Battery Power Mixed No Change Best Case Scenario 1) Maximum Expected Monetary Value 2) Expected Value of Perfect Information 0.25 0.35 0.35 0.05 A B C D -145 -55 -85 -40 -35 -20 -25 -15 60 45 50 50 150 75 90 40 -40 -15 60 150 4.25 9 Expected Outcome -20 -1.25 -8 4.25 13.25 Weight 2 4 5 1 3 2 3 2 1 6 3 5 3 3 4 1 7 2 2 2 Demand Data X 28 30 28 35 30 32 26 27 27 30 27 30 28 27 25 34 30 25 31 30 Y 33 34 28 32 28 33 27 28 27 31 24 31 24 26 28 29 37 36 33 33 Sum of Distance Best Weighted Sum Location A 26 32 6 24 30 9 24 14 15 10 6 30 27 25 30 21 20 11 63 10 12 10 397 351 (location D) Location B 31 29 14 24 20 7 6 10 21 10 6 18 27 15 24 21 28 3 63 26 8 10 361 Location C 31 33 6 8 40 5 18 2 33 18 10 18 39 15 36 33 44 7 35 18 0 2 387 Location D 31 31 10 16 30 5 12 6 27 14 8 6 33 5 30 27 36 5 49 22 4 6 351 Location E 32 29 16 28 25 6 9 8 24 12 7 24 30 20 27 24 32 2 70 28 10 12 414