35 36 Problem 2 (30 points) 37 Pan American Refineries, headquartered in Houston must decide among 7 sites 38 for the construction of a new oil processing center. The firm has selected the 6 39 important factors as a basis for evaluation. The firm has also assigned rating 40 weights to each of the 6 factors and scores from 0 (worst) to 100 (best) to 41 cach of 7 sites listed in the table below. 42 A 80 44 Factor 4 Community desirability 46 Distance from Houston 47 Equipment suppliers in arca 48 Power-source availability and cost 49 Proximity to port facility 50 Workforce attitude and cost Weight 0.14 0.22 0.30 0.14 0.05 0.15 60 90 80 90 60 B 60 80 100 90 70 60 Location D 80 100 60 80 90 60 50 70 80 80 70 90 E 60 80 100 70 80 80 F 90 80 100 30 SO 60 G 30 60 80 100 40 80 51 52 53 Q1. Select the best location and show the weigted score. 54 55 56 57 Q2. Select the second best location and show the weigted score