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. Concept Evaluation Using Weighted Rating Method (Pahl and Beitz Method) Alternative Concepts / Embodiments V-belts Criteria cost weight size reliability efficiency force integral braking customer appeal Weight (%) 20 15 15 9 8 8 10 15 100 wt. rating rating 3 2 Gears 3 4 4 2 na wt. rating rating 4 4 2 3 3 3 3 1 na Unsatisfactory Just tolerable Adequate Good Very Good 01234 4 3 3 4 Chain wt. wt. rating rating rating rating 4 4 na Linkages 34W 3W3444 na