4. Use the tab labeled Solver Part 4 to complete the following: a] Create and program a spreadsheet with data based on the following scenario: Scenario Your company has two trucks that it wishes to use on a specic 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: I Fuelladditives: 540 I Truck payments: 240 I Driver: 35C I Repairs: 12C I Miscellaneous: 1C The old truck's oosts are as follows: I Fuelladditives: SOC I Truck payments: DC I Rookie driver: 32!: I Repairs: 24C I Miscellaneous: 1C The company knows that truck breakdowns lose customers, so they have capped estimated repair costs at $14,000. The total distance involved is 90,000 miles {to be divided between the two trucks}. After you set up and program your table, be sure to provide a rationale statement. h] Use Solver to determine the number of miles each truck should be driven