Conduct TOPSIS in an Excel spreadsheet to determine the best car that he should purchase. What do the results suggest?

Supply Chain Modelling and Design

Details
Adam is interested in finding a sedan car for work. 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?
Note: Calculate the data given below in the same way as the rating scale. There is no need to convert the data into the rating scale before the calculation.
Criteria Weight
Toyota
Camry
Volkswagen
Passat
Mazda
6
Hyundai
Sonata Objective
Price 8 $28,990 $46,590 $50,090 $28,490 Min
Engine size (L) 2 2.5 2.0 2.5 2.4 Max
Fuel tank capacity (L) 6 60 66 62 70 Max
Power: Weight (W/kg) 5 89.3 92.7 104.9 87.0 Max
Max torque (Nm) 6 231 320 420 241 Max
Fuel consumption (L/100km) 7 7.8 6.4 7.6 8.3 Min