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. Expert's Weight Assesments Weight Considerations Importance Weight Expert 1 Expert 2 Expert 3 Transportation facilities 70 Labor supply 50 65 Land 70 Markets 45 35 Utilities 30 Raw materials 75 100 Geographical/weather 40 Taxes and legal factors Community 15 National security 40 Proximity to exisiting plant 8 8 8 8 8 8 8 8 8 8 85*6d8388 65 30 45 L Expert's Score Assesments Average Scores A B C Location C Expert 2 Expert 3 70 70 75 45 50 90 70 40 Considerations Location A Location B Expert 1 Expert 2 Expert 3 Expert 1 Expert 2 Expert 3 Expert 1 Transportation facilities 100 60 80 95 55 70 100 Labor supply 70 55 50 70 70 55 55 Land 30 40 100 35 45 80 40 Markets 85 75 30 80 85 50 90 Utilities 70 55 90 55 45 85 65 Raw materials 55 45 50 40 40 40 45 Geographical/weather 65 65 70 55 70 55 65 Taxes andlegal factors 50 60 35 55 50 60 30 Community 100 35 100 100 50 80 75 National security 100 80 65 85 90 80 80 Proximity to exisiting plant 80 45 35 80 55 50 95 85 mm5 mmmmm 35 45 55 50 65 45 50 100 80 70 50 40 Total Score Best Location