Create excel file for both hw 3 and hw 5 that i upload. I will also provide the
Create excel file for both hw 3 and hw 5 that i upload. I will also provide the solution for the questions except 1 of them. So just need to solve 1 question and the excel files
so two total excel files.
Hw 5 solution
1.
Thailand = (0.4)(0.90) + (0.4)(1.15) +(0.2)(1.05) = $1.03
Taiwan = (0.6)(0.85) +(0.3)(1.20) + (0.1)(0.98) = $0.968
Vietnam = (0.5)(0.95)+(0.2)(1.10)+(0.3)(1.00) = $0.995
The company should select the country from Taiwan because it is the cheapest price and the three country.