Create spreadsheets and use Solver to determine the correct miles for each truck to travel 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), 360 (driver), 12 (repairs), and 14 (misc.). The old truck's costs are 60 (fuel/additives), 04 (truck payments), 32 (rookie driver), 24 (repairs), and 10 (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). Cost total Miles Driven Truck1 new Fuel truck payment driver repairs misc Total Truck 1 Truck 2 Fuel truck payment driver repairs misc Total truck 2 Truck 1 Amount Cost 1 $ 1 $ 1 $ 1 $ 1 $ Amount Cost 1 1 1 1 1 0.6 0.54 $ 0.24 $ 0.36 $ 0.12 $ 0.01 $ $ 0 Truck 2 0.32 0.24 0.01 Mile Cost 0.54 0.24 0.36 0.12 0.01 1.27 Mile Cost Total Cost 0.6 0 0.32 0.24 0.01 1.17 Constraints Repairs Miles Driven $14,000.00 $14,000.00 90000