Engineering

Case 4 trader is interested in finding an SUV car. With a limited budget, he does not mind A new getting a used one. Below is the summary of his criteria and the choices that he has selected as potential cars that he may purchase. Conduct TOPSIS in an Excel spreadsheet to determine the best car that he should purchase. What do the results suggest? Ratings Mercedes-Benz ??zda Kia Nissan Criteria Weight Sportage GL320 QASHQAI CX-3 Objective $24,990 $21,999 $28,540 $21,990 Price Min Odometer (km) 5 59,234 143,000 0 29,195 Min Fuel consumption (1/100km) 3 7.9 10 6.9 6.1 Min Fuel average distance (km) 5 785 1,000 942 787 Max CO2 emission (g/km) 2 182 264 159 146 Min Power-to-weight ratio (W/kg) 7 73.1 69.4 79.5 90.8 ??? Build year 5 2017 2007 2018 2015 ??x Fuel cost per fill $147 $81 $60 6 $78 Min