To work this problem via spreadsheet, please refer to the data in Problem 10.50.

(a) Determine which proposal, A or B, to select using the weighted attribute method and the importance scores for the manager and the supervisor.

(b) You have given proposal B a very low rating, V_ij, for safety, only 20%. Determine the minimum value rating that you would have to assign to proposal B for the safety attribute to select B with an R_B that is at least 10% more than that determined previously for proposal A.

Problem 10.50

An airport Baggage Handing Department has evaluated two proposals for baggage delivery conveyor systems. A present worth analysis at i = 15% per year of estimated revenues and costs resulted in PW_A = $460,000 and PW_B = $395,000. In addition to this economic measure, three more attributes were independently assigned a relative importance score from 0 to 100 by the department manager and a senior team supervisor.

Separately, you have used the four attributes to value rate the two proposals on a scale of 0 to 1.0 as shown in the following table. (The economics attribute was rated using the PW values.)

Importance Scores Attribute Manager Supervisor 1. Economics 80 25 2. Durability 3. Safety 4. Maintainability 35 80 30 100 20 90