Hiro Tanaka is going to purchase a new car and has narrowed the decision down to three different sedans. The following table summarizes how he rates each sedan on the criteria that are most important to him.

Criterion	Sedan 1	Sedan 2	Sedan 3
Economy	0.9	0.7	0.4
Safety	0.6	0.7	0.8
Reliability	0.9	0.8	0.7
Style	0.4	0.5	0.8
Comfort	0.5	0.8	0.9

Upon reflection, Hiro decides that the weights he would assign to each criteria are as follows: Economy 30%, Safety 15%, Reliability 15%, Style 15%, and Comfort 25%.

a. Create a multicriteria scoring model for this problem.

b. Create a radar chart showing the weighted scores for each car on each of the criteria.

c. According to this model, which car should Hiro purchase?

d. Suppose Hiro is uncertain about the weights he assigned to the comfort and safety criteria. If he is willing to trade comfort for safety, how would the solution change?

e. Suppose Hiro is uncertain about the weights he assigned to the economy and safety criteria. If he is willing to trade economy for safety, how would the solution change?

Answer rating: 100% (QA)

Firstly write down the whole data in excel spr... View the full answer