Hi- Having trouble setting up my solver in excel to calculate the fields needed.

Create spreadsheets and use Solver to determine the correct volumes to be produced to minimize cost for the following problem. Your company has two trucks that it wishes to use on a specific contract. One is a new truck the company is making payments on, and one is an old truck that is fully paid for. The new truck's costs per mile are as follows: 54? (fuel/additives), 24? (truck payments), 36? (driver), 12? (repairs), and 1? (misc.). The old truck's costs are 60? (fuel/additives), 0? (truck payments), 32? (rookie driver), 24? (repairs), and 1? (misc.). The company knows that truck breakdowns lose customers, so it has capped estimated repair costs at $14,000. The total distance involved is 90,000 miles (to be divided between the two trucks).

Use Solver to determine the number of miles each truck should be driven.

Attached is what I have done setting up the table, the constraints and calculations . however when I try to run solver I get the numbers but they do not seem correct. What am I doing wrong. Can you point me to the where I need to fix?

Part 4 Create spreadsheets and use Solver to determine the correct volumes to be produced to minimize cost for the following problem. Your company has two trucks that it wishes to use on a specific contract. One is a new truck the company is making payments on, and one is an old truck that is fully paid for. The new truck's costs per mile are as follows: 54 (fuel/additives), 240 (truck payments), 36 (driver), 12@ (repairs), and 10 (misc.). The old truck's costs are Solver Parameters X 60@ (fuel/additives), O (truck payments), 324 (rookie driver), 240 (repairs), and 14 (misc.). The company knows that truck breakdowns lose customers, so it has capped estimated repair costs at $14,000. The total distance involved is 90,000 miles (to be divided between the two trucks). Set Objective: $F$15 + To: Max O Min O Value Of: By Changing Variable Cells: New Truck Old Truck New Truck Cost Old Truck Cost $B$24:$B$25 + Fuel/Additives 0.54 $ 0.60 $ 28,991,029.25 $29,675,856.07 Truck Payments | $ 0.24 $ $ 12,884,901.89 $ Subject to the Constraints: Driver $ 0.36 5 0.32 $ 19,327,352.83 $ 15,827,123.24 $B$19