PLEASE USE EXCEL SOLVER AND THE SHORTEST ROUTE METHOD TO SOLVE THE ABOVE PROBLEM. INCLUDE ALL THE STEPS. PLEASE DO NOT COPY EXISTING SOLUTIONS ON CHEGG.

The Central Bureau of Investigation pays roughly $26,000 for a police vehicle. The annual maintenance cost of a vehicle is determined by the vehicle's age at the start of the year. (Every vehicle accumulates roughly the same amount of mileage each year.) The following table shows how maintenance costs rise as a vehicle ages: Age of the car (years) Annual cost of maintenance Used Selling Price $3000 1 $4500 $15000 2 $6000 $12000 $8000 $8000 $11000 $4000 5 $14000 $2000 6 0 0 3 4 To minimize the rising costs of upkeep, the CBI can sell a vehicle and buy a new one at the end of any year. The table also shows the selling price of the vehicle at the end of each year of use. It is estimated that the cost of a new vehicle will rise by USD500/yr. The department's goal for the next 6 years is to establish a vehicle replacement timetable that will reduce overall cost (that is, the purchase price of a new vehicle plus maintenance costs minus the money earned for selling a used vehicle). Develop a vehicle replacement schedule, using SHORTEST ROUTE METHOD USING EXCEL