Question: p plz solve it using excel , with the steps Telecomp is a U.S.-based manufacturer of cellular tele- phones. It is planning to build a

p plz solve it using excel , with the steps p

plz solve it using excel , with the steps

Telecomp is a U.S.-based manufacturer of cellular tele- phones. It is planning to build a new manufacturing and distribution facility in either South Korea, China, Taiwan, Poland, or Mexico. The cost of the facility will differ between countries and will even vary within countries depending on the economic and political climate, including monetary exchange rates. The company has estimated the facility cost in $ millions) in each country under three dif- ferent future economic/political climates as follows. Country South Korea China Taiwan Poland Mexico Economic/Political Climate Decline Same Improve 21.7 19.1 15.2 19.0 18.5 17.6 19.2 17.1 14.9 22.5 16.8 13.8 25.0 21.2 12.5 Determine the best decision using the following decision criteria. (Note that since the payoff is cost, the maximax cri- teria becomes minimin and maximin becomes minimax.) a. Minimin b. Minimax c. Hurwicz (a = 0.40) d. Equal likelihood

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!