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.

1. a) Average weights.

2. b) Average scores for each location.

3. c) Using the average weights and averages score calculate total scores for each location.

4. d) Select the best location according to calculated total scores.

Can you write proper excel codes that answer the question

Expert's Weight Assesments Considerations Avg. Weight Transportation facilities Labor supply Land Markets Utilities Raw materials Geographical/weather Taxes and legal factors Community National security Proximity to existing plant Importance Weight Expert 1 Expert 2 Expert 3 50 55 45 80 55 55 40 40 65 75 90 95 95 90 90 55 45 30 90 75 90 85 100 95 80 90 100 80 60 75 35 40 30 8 Expert's Score Assesments Considerations Average Scores B NE tlar Transportation facilities Labor supply Land Markets Utilities Raw materials Geographical/weather Taxes and legal factors Community National security Proximity to existing plant ou Location A Expert 2 60 80 85 80 50 30 45 50 25 80 55 Expert 1 70 80 90 40 55 90 75 55 40 75 85 Expert 3 100 95 45 55 95 60 45 45 75 75 60 Expert 1 80 100 95 40 50 90 60 60 50 90 85 Location B Expert 2 65 85 70 70 60 35 45 45 25 90 45 A & Kn in Oo in un Expert 3 100 85 65 45 75 55 35 45 95 75 55 Expert 1 65 100 100 35 65 95 60 45 35 95 85 8 in this Location C Expert 2 50 75 65 90 60 35 35 30 25 100 45 Expert 3 95 100 65 45 90 45 50 45 100 60 50 Total Score Best Location