Question 1 Examine the spreadsheet in the figure below. Note that the design team has decided upon a rating for each of the four alternatives. a) Determine the weighted ratings for each alternative. b) Is there any alternative that will NOT be chosen no matter how we change the weights? If so, what is the alternative(s) (maybe more than one)? Briefly explain your answer. Question 1 Examine the spreadsheet in the figure below. Note that the design team has decided upon a rating for each of the four alternatives. a) Determine the weighted ratings for each alternative. b) Is there any alternative that will NOT be chosen no matter how we change the weights? If so, what is the alternative(s) (maybe more than one)? Briefly explain your