Please show all your steps that you take to resolve this. Please be very clear, so that I understand what steps you take. If typing, please bold your responses per step. Make sure to follow all rounding instructions.

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. The CEO has rated each location for each factor on a 1 to 100 point basis. In the table below, the rating weights and the rating value for each of the locations on the factor are presented. Factor Factor Description 1 Proximity to port facilities 2. Power-source availability and cost 3 Workforce attitude and cost 4 Distance from Calgary 5 Community desirability 6 Equipment suppliers in area Rating Weight 5 3 4 2 2 3 Location A 80 80 40 15 100 50 Location B 80 65 60 80 60 65 Location C 75 90 75 55 75 85 a) Based on the given information, the best location for Consolidated Refineries is with a total weighted score of (Enter your response as an integer.) b) If Location B's score for Proximity to port facilities was reset at 90, it will have a new total weighted score of O. (Enter your response as an integer.) c) Location B will lower its ranking as soon as its score (within the confines of the 1 to 100 point basis) on Proximity to port facilities is less than (Enter your response as an integer.)