PLEASE SOLVE THIS PROBLEM USING EXCEL SOLVER ADD-IN AND EXPLAIN STEP BY STEP. A supply chain manager faced with choosing among four possible locations has assessed each location according to the following criteria, where the weights reflect the importance of the criteria.\table[[Criteria,Weight,Location],[1,2,3,4],[Raw material availability,0.15,VG,VG,G,G],[Infrastructure,0.08,VG,P,VG,OK],[Transportation costs,0.23,G,VG,VG,P],[Labor relations,0.23,OK,OK,G,P],[Quality of life,0.31,VG,G,P,VG],[VG = Very good 5 pts; G = Good 4 pts; OK = Acceptable 3 pts ; P = Poor 1 pt.]]Using this information, determine the best and the worst location. Round your answers to two decimal places.\table[[Location,Total Points],[1,],[2,],[3,],[4,]] is the best location and is the worst location.