Create spreadsheets and use Solver to determine the correct miles for each truck to travel to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Related Book For
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
a. Prepare a plot of the CPI data. Based on this plot, which of the time series forecasting techniques covered in this chapter would not be appropriate for forecasting this time series? b. Apply...
-
Let a function f be the line graph connecting the data points (1, 2), (4,9), and (6,3). (a) Write the formula for a piecewise-linear function f that passes through these data points whose domain is 1...
-
Show the product you would obtain from the reaction of cellobiose with the following reagents: (a) NaBH4 (b) Br2 H2O (c) CH3COCl, pyridine
-
Refer to Exercise 12. Estimate n, and find the relative uncertainty in the estimate, from the following measurements: 1 = 0.216 0.003 radians and 2 = 0.456 0.005 radians.
-
On 28 February 2025, Darwin-based entity, HandsFree Partners, had inventory of 480 phones at a total cost of $134 400. The business maintains a perpetual inventory system. The following transactions...
-
Blake Romney became Chief Executive Officer of Peters Inc. two years ago. At the time, the company was reporting lagging profits, and Blake was brought in to stir things up. The company has three...
-
Sketch a hand written a Enhanced ER diagram for this table and fix the error if there is Message cation D Notification UserNotif Password UserName UserID RoleID User D Phone User # Role securityID...
-
In a paint mixing plant, two tanks supply fluids to a mixing cistern. The height, h, of the fluid in the cistern is dependent upon the difference between the input mass flow rate, q, and the output...
-
A $63,000 machine with a 7-year class life was purchased 2 years ago. The machine will now be sold for $50,000 and replaced with a new machine costing $75,000, with a 5-year class life. The new...
-
Rule of 78 With a typical installment loan, you are asked to sign a contract stating the terms of repayment. If you pay off the loan early, you are entitled to an interest rebate. For example, if you...
-
If a state issued license plates using the scheme of one letter followed by five digits, how many plates could it issue?
-
Distinguish a sequence from a series.
-
Find the sum of the first 50 terms of the arithmetic sequence whose first term is -15 and whose common difference is 5 .
-
Suppose someone tells you she has traced her family tree back 10 generations. What is the minimum number of people on her family tree if there were no intermarriages?
-
1. In your own words, summarise the purpose of the text. (10 marks) 5 2. With reference to the whole text, suggest THREE possible ways in which workplace bullying may be resolved. Cite at least TWO...
-
Big Jim Company sponsored a picnic for employees and purchased a propane grill equipped with a standard-sized propane tank for the picnic. To make sure there was enough propane for all the cooking...
-
In the United Copiers service center model, we used total distance traveled as the objective to minimize. Suppose in addition that there is an annual fixed cost of locating a service center in any...
-
A furniture company manufactures tables and chairs. Each table and chair must be made entirely out of oak or entirely out of pine. A total of 15,000 board feet of oak and 21,000 board feet of pine...
-
Your company has signed a contract with a good customer to ship the customer an order no later than 20 days from now. The contract indicates that the customer will accept the order even if it is...
-
Use Stokes' theorem [Eq. (27.5)] to prove that Eq. (27.4) leads to Eq. (27.6). Data from Eq. 27.4 Data from Eq. 27.5 Data from Eq. 27.6 = z ) ); A dr. - SA dr) = f A dr.
-
Prove the result of Eq. (26.10) that a path-dependent representation of a gauge group is sensitive to a gauge transformation only at the endpoints of the path.
-
In Eq. (26.7), invert \(A^{\mu}(x)=A_{i}^{\mu}(x) \tau^{i}\) to obtain \(A_{i}^{\mu}(x) \equiv 2 \operatorname{Tr}\left(\tau_{i} A^{\mu} ight)\).
Study smarter with the SolutionInn App