Using a spreadsheet for Problem 21, find the following:

(a) What would be your recommendation if the weight for the transportation cost went down to 10 and the weight for union relations went up to 25?

(b) Suppose location A received a score of 3 for transport cost and location C received a score of 2 for transport cost. Would your recommendation change under these circumstances?

(c) The VP of Finance has looked at your scoring model and feels that tax considerations should be included in the model with a weight of 15. In addition, the VP has scored the locations on tax considerations as follows: A-3, B-2, and C-1. How does this affect your recommendation?