Excel Template

Question 3 (8 points): A location analysis has been narrowed down to two locations, A and B. The main factors in the decision will be supply of raw materials, which has a weight of 0.50 , transportation cost, which has a weight of 0.40 , and labor cost, which has a weight of 0.10 . The ratings (out of 100 , with higher score being more desirable) for raw materials, transportation cost, and labor cost are: A: 60,80 , and 70 , respectively; B: 70,50 , and 90 , respectively. On worksheet Q3, build up your own template to determine which location should the manager choose using the factor rating method