Determine the correct miles for each truck

Assignment Help Other Subject

Reference no: EM133756930

Question: 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), 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).

Reference no: EM133756930

Questions Cloud

Multidisciplinary integrated curriculum : Use at least one scholarly resource to describe and explain what is meant by Multidisciplinary Integrated Curriculum.

Reflect on a group experience where you noticed : Reflect on a group experience where you noticed this shift to synergy with your group. (Some ideas: at a human services agency where you work

How does ontario compare to the other provinces-territories : How does Ontario compare to the other provinces/territories? Were all provinces/territories making changes at the same pace? Explain.

Total discounted costs and health gain : What are the total discounted costs and health gain at 3% for the course of the program?

Determine the correct miles for each truck : Create spreadsheets and use Solver to determine the correct miles for each truck to travel to minimize cost for the problem

Analyze cultural-educational impacts of british colonialism : Analyze (1) cultural and educational impacts of British colonialism. What do you think about the educational impacts of British colonialism?

Male who has been brought to hospital by daughter : Mr. XY is an 84-year-old male who has been brought to hospital by his daughter. Mr. XY lives with his daughter and her family

Describe what you learned about the staging : describe what you learned about the staging in this case (e.g. in what ways was this crime scene staged? What was the motivation forth staging? etc.)

Analyze how an emerging security technology is : Analyze how an emerging security technology is affecting the cybersecurity landscape. In your response, detail the impact this technology has on existing

User Account

All Pages