how do I set up an excel spread sheet to determine how to divide miles for two truck project and add in the costs per truck and use solver to find answer
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).