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