2.9 Ranga Ramasesh is the operations manager for a firm that is trying to decide which one of four countries it should r

[answerhappygod]

2.9 Ranga Ramasesh is the operations manager for a firm that is
trying to decide which one of four countries it should research for
possible outsourcing providers. The first step is to select a
country based on cultural risk factors, which are criti- cal to
eventual business success with the provider. Ranga has reviewed
outsourcing provider directories and found that the four countries
in the table that follows have an ample number of providers from
which they can choose. To aid in the country selection step, he has
enlisted the aid of a cultural expert, John Wang, who has provided
ratings of the various criteria in the table. The resulting ratings
are on a 1 to 10 scale, where 1 is a low risk and 10 is a high
risk. John has also determined six criteria weightings: Trust, with
a weight of 0.4; Quality, with 0.2; Religious, with 0.1;
Individualism, with 0.1; Time, with 0.1; and Uncertainty, with 0.1.
Using the factor-rating method, which country should Ranga
select?
Please complete in excel and show all formulas for
answers