For this assignment, please submit one Excel file. Use a separate worksheet for each question set and label the worksheets. To rename a worksheet, right-click the worksheet tab located at the bottom of your current sheet and use the rename option. Label the tabs as Q Set 1, Q Set 2, and Q Set 3, respectively. Be sure to label all results clearly.

Questions

Question Set 1. Google is considering different R&D paths for the upcoming years release. The five strategies (along with changing nothing) under consideration are:

• Decrease Depth: Decrease the width of the phones without changing other specs
• Smaller Battery: Decrease battery capacity of phones by 7%
• Mixed: Combine above two strategies
• Larger Battery: Increase battery capacity of phones by 6%
• 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. Google considers four different outcomes, which are not shared, but we will call them as scenarios 1, 2, 3 and 4. Negative values indicate loss for Google and positive values indicates possible profits.

	Scenarios
Strategy	1	2	3	4
Decrease Depth	-70	-30	50	55
Smaller Battery	-65	-40	35	45
Mixed	-60	-35	30	60
Larger Battery	-50	-35	25	50
No Change	-50	-45	30	30

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 Googles decision using the maximax criterion? (3pts)

2. What would be Googles decision using the maximin criterion? (3pts)

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

4. What would be Googles decision using the minimax regret criterion? It is most 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 Googles strategies. Assume that the probabilities for scenarios are:

• P(Scenario 1) = 0.2
• P(Scenario 2) = 0.3
• P(Scenario 3) = 0.3
• P(Scenario 4) = 0.2

1. What decision will maximize Googles 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 below:

1. Find the sum of weighted metropolitan model distances for each of the five locations; A1, A2, A3, A4 and A5. Be sure the calculations are shown for each locations sum of distances. (8pts)

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

Demand Data
Weight	D	E
2	35	29
3	29	39
4	23	25
1	29	34
3	37	30
2	29	37
3	23	33
2	34	23
1	20	24
8	30	39
3	29	27
5	21	34
3	31	28
2	34	25
3	18	29
1	33	29
5	26	30
2	18	25
1	40	31
2	31	40

Location	D	E
A1	26	32
A2	33	31
A3	31	33
A4	31	29
A5	32	29