A location for a facility is to be selected from three candidate locations. The data is given in the Excel files attached. Three experts are used for this problem and their assessments about the weights for different criteria and scores for each candidate location are given. Find the following using the data given for you.

a) Average weights. b) Average scores for each location. c) Using the average weights and averages score calculate total scores for each location. d) Select the best location according to calculated total scores.

X fo B F G H J K M N P Considerations Avg C D DE Importance Weight Expert 1 Expert 2 Expert 3 70 70 15 30 85 95 95 Weight 50 35 65 35 50 Transportation facilities Labor supply Land Markets Utilities Raw materials Geographical/weather Taxes and legal factors Community National security Proximity to existing plant TE 45 35 45 55 75 70 80 95 95 70 15 65 70 25 50 50 45 Expert's Score Assesments Considerations Average Scores B A Transportation facilities Labor supply | Land Markets Utilities Raw materials Geographical/weather Taxes and legal factors Community National security Proximity to existing plant Location A Location B Location C Expert 1 Expert 2 Expert 3 Expert 1 Expert 2 Expert 3 Expert 1 Expert 2 Expert 3 65 40 60 65 55 45 70 60 60 25 95 55 30 100 50 25 100 45 50 70 95 40 65 70 35 60 70 70 85 85 85 70 80 90 75 75 65 70 80 55 75 75 45 80 65 20 75 65 100 70 85 85 50 75 90 40 75 90 30 100 30 90 55 90 80 70 100 80 100 85 75 80 35 85 65 35 95 75 50 75 50 50 70 35 70 60 35 60 70 30 65 75 45 65 70 25 75 BB8%B8%B www An Total Score Best Location Sheet1