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.

Location Factor Weight A B C D E F G Community desirability 0.14 80 60 80 100 60 90 30 Distance from Houston 0.22 60 80 60 80 80 80 60 Equipment suppliers in area 0.30 90 100 90 60 100 100 80 Power-source availability and cost 0.14 80 90 50 70 70 30 100 Proximity to port facility 0.05 90 70 80 80 80 50 40 Workforce attitude and cost 0.15 60 60 70 90 80 60 80 Sum 1.00 Weighted Score 76.1 81.1 72.9 76.9 81.8 75.9 69.4

Q1. Select the best location and show the weigted score.

Q2. Select the second best location and show the weigted score.