Consolidated Refineries, headquartered in Calgary, must decide among three sites for the construction of a new oil-processing centre. The firm has selected the six factors listed below as a basis for evaluation and has assigned rating weights from 1 to 5 on each factor:

Management has rated each location for each factor on a 1- to 100 point basis.

a) Which site will be recommended based on total weighted scores?
b) If location B€™s score for proximity to port facilities were reset at 90, how would the result change?
c) What score would location B need on proximity to port facilities to change its ranking?

Factor Factor Name Rating Weight Proximity to port facilities Power-source availability and cost 1 2 Workforce attitude and cost Distance from Calgary 2 Community desirability 2 Equipment suppliers in area 3 3. 4, Factor Location A Location B Location C 100 80 80 80 70 100 3 30 60 70 4 10 80 90 60 80 50 60 06