OMGT2087 2550 A3C34 Study 4

For this case,

1) An Excel file to demonstrate how you use Solver to identify the solutions. You must ensure that the file is in a workable condition. Each model must be implemented in a separate sheet in the same file.

Problem Statement

A ridesharing driver is interested to purchase a new car that can be used for personal and business purposes. Due to the rise in living cost and the fringe tax benefits, they are interested in EV cars. Below are the summary of the criteria and the alternatives that they have selected as potentials for the purchase. They want you to determine the best alternative based on these data.

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.