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 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: Fuel/additives: 54¢ Truck payments: 24¢ Driver: 36¢ • Repairs: 12¢ Miscellaneous: 1¢ The old truck's costs are as follows: Fuel/additives: 60¢ Truck payments: Oc Rookie driver: 32¢ Repairs: 24¢ • • Miscellaneous: 1¢ 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. b) Use Solver to determine the number of miles each truck should be driven.
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).
![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:
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:
Fuel/additives: 54¢
Truck payments: 24¢
Driver: 36¢
• Repairs: 12¢
•
•
Miscellaneous: 1¢
The old truck's costs are as follows:
Fuel/additives: 60¢
Truck payments: 0¢
Rookie driver: 32¢
• Repairs: 24¢
Miscellaneous: 1¢
Scenario
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.
b) Use Solver to determine the number of miles each truck should be driven.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F01d01b29-ede7-42ba-8dcd-8c0b18e94cc8%2Fcf926b30-1424-4d21-b325-17468a2a9542%2Fgbnxyca_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 5 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)