solve it excel

B D E F G N 1 Q1) A company is planning on expanding and building a new plant in one of three Southeast Asian countries. Chris Ellis, the manager charged with making the decision, has 3 determined that five key success factors can be used to evaluate the prospective countries. 4 Ellis used a rating system of 1 (least desirable country) to 5 (most desirable) to evaluate each factor. 5 6 a) Which country should be selected for the new plant? 7 b) Political unrest in Thailand results in a lower score, 2, for Political and legal aspects. Does 8 your conclusion change? 9 c) What if Thailand's score drops even further, to a 1, for Political and legal aspects? 10 11 12 13 14 15 CANDIDATE COUNTRY RATINGS 16 KEY SUCCESS FACTOR WEIGHT TAIWAN THAILAND SINGAPORE 17 Technology 0.2 4 5 1 18 Level of education 0.1 4 1 5 19 Political and legal aspects 0.4 1 3 3 20 Social and cultural aspects 0.1 4 2 3 21 Economic factors 0.2 2 22 23 24 25 26 27 28 lun | | A B C D E F G Q2) The following table gives the map coordinates and the shipping loads for a set of cities that we wish to connect through a central hub. a) Near which map coordinates should the hub be located? b) If the shipments from city A triple, how does this change the coordinates? 2 3 4 5 6 7 00 City MAP COORDINATE (X,Y) SHIPPING LOAD A (5, 10) 5 B (6,8) 10 C (4,9) 15 D (9,5) 5 E (7,9) 15 F (7,9) 10 G (7,9) 5 9 10 11 12 13 14 15 16 17 18 19 20 21 22 A B C D E Q3 ) Hyundai Motors is considering three sites-A, B, and C-at which to locate a factory to build its new-model 1 automobile, the Hyundai Sport C150. The goal is to locate at a minimum cost site, where cost is measured by the 2 annual fixed plus variable costs of production. Hyundai Motors has gathered the following data: The firm knows it will produce between 0 and 60,000 Sport C150s at the new plant each year, but, thus far, that is the extent of its knowledge about production plans. 3 4 a) For what values of volume, V, of production, if any, is site Ca recommended site? 5 b) What volume indicates site A is optimal? 6 c) Over what range of volume is site B optimal? Why? 7 8 9 10 11 SITE ANNUALIZED FIXED COST VARIABLE COST PER AUTO PRODUCED 12 A $10,000,000 $2,500 13 B $20,000,000 $2,000 14 C $25,000,000 $1,000 15 16 17 18 19 20 21 22 23 24 25 26 27