Please solve this using an excel spreadsheet and show all your work

3. Suppose it costs $10,000 to purchase a new car. The annual operating cost and resale value of a used car are shown in Table 1. Assuming that one now has a new car, determine a replacement policy that minimizes the net costs of owning and operating a car over the next six years. Table 1 Age of Car (Years) Resale Value ($) 7,000 6,000 4,000 3,000 2,000 1,000 Operating Cost (S) 300 500 800 1,200 1,600 2,200 a. Please draw a network to represent the model. 25 pts. b. Please create a color-coded Excel spreadsheet model to represent this problem. 25 pts. c. Please use Excel Solver to find the minimum cost of owning and maintaining over the six- year period. 25 pts. d. Please say if and in what years the car should be replaced. 25 pts