A location analysis has been narrowed down to three locations. The critical factors, their weights, and the ratings for each location are shown below: Location Factor Wt. X Y Z Labor Cost .3 70 60 75 Transportation Cost .3 90 90 60 Market Access .1 60 80 80 Utility Cost .2 80 90 70 Raw Materials Cost .1 90 70 80 3.What is the composite score for location Y
Use excel formulas to show calculations
*A location analysis has been narrowed down to three locations. The critical factors, their weights, and the ratings for each location are shown below:
Location
Factor Wt. X Y Z
Labor Cost .3 70 60 75
Transportation Cost .3 90 90 60
Market Access .1 60 80 80
Utility Cost .2 80 90 70
Raw Materials Cost .1 90 70 80
3.What is the composite score for location Y?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps