The owner of a trucking company wants to expand its business by purchasing new trucks. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The owner of a trucking company wants to expand its business by purchasing new trucks. The owner considers two types of trucks: Peterbilt 579 or Kenworth T680. The owner has estimated that each Peterbilt 579 purchased will increase the daily profit by $1070 and each Kenworth T680 purchased by $1000. The number of truck the company can own is limited by the garage capacity of 7 trucks and company's budget of $1,000,000. The price of Peterbilt 579 is $166,950 and the price of Kenworth T680 is $156,000. a) Formulate this as a mixed-integer linear programming problem in terms of objective function and constraint(s) and solve using Branch-and-Bound method (branches can be solved using the Excel Solver). Graphically show branches and solutions. b) How many trucks should the company purchase from each brand and what is the objective function value? c) Compare original continuous solution (OCS) and decisions to integer solution and briefly explain your findings. The owner of a trucking company wants to expand its business by purchasing new trucks. The owner considers two types of trucks: Peterbilt 579 or Kenworth T680. The owner has estimated that each Peterbilt 579 purchased will increase the daily profit by $1070 and each Kenworth T680 purchased by $1000. The number of truck the company can own is limited by the garage capacity of 7 trucks and company's budget of $1,000,000. The price of Peterbilt 579 is $166,950 and the price of Kenworth T680 is $156,000. a) Formulate this as a mixed-integer linear programming problem in terms of objective function and constraint(s) and solve using Branch-and-Bound method (branches can be solved using the Excel Solver). Graphically show branches and solutions. b) How many trucks should the company purchase from each brand and what is the objective function value? c) Compare original continuous solution (OCS) and decisions to integer solution and briefly explain your findings.
Expert Answer:
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these programming questions
-
The maintenance manager at a trucking company wants to build a regression model to forecast the time until the first engine overhaul based on four independent variables: (1) annual miles driven, (2)...
-
The maintenance manager at a trucking company wants to build a regression model to forecast the time until the first engine overhaul based on four explanatory variables: (1) annual miles driven, (2)...
-
The maintenance manager at a trucking company wants to build a regression model to forecast the time until the first engine overhaul based on four explanatory variables: (1) annual miles driven, (2)...
-
Calculate the shape factor f for the wide flange beam shown in the figure if h = 12.2 in., b = 8.08 in., tf = 0.64 in., and tw = 0.37 in. Iw
-
What are the various approaches that can be used to locate a brand position?
-
You buy a dog whistle that operates at 21 kHz, but when you blow into it, your dog does not show the slightest reaction. You decide to see if you can hear the whistle yourself. Two friends help you....
-
Which depreciation method usually produces the most depreciation in the first year? a. Straight-line b. Units-of-production c. Double-declining-balance d. All produce the same amount of depreciation...
-
A stock will provide a rate of return of either -18% or +26%. a. If both possibilities are equally likely, calculate the stock's expected return and standard deviation. b. If Treasury bills yield 4%...
-
1. On average, it takes 0.4 hours to code one record. Determine how many hours it would take to code 600 records a month. 2. If one coder works 6.5 work hours per day, how many coders would be needed...
-
Finley Heaters Inc. is a mid sized manufacturer of residential water heaters. Sales have grown during the last several years, and the companys production capacity needs to be increased. The companys...
-
Data for selected fruits purchased at wholesale prices for 2005 and 2009 are shown in the following table. Red Delicious Apples (lb.) Navel Oranges (lb.) Bananas (1b.) Tomatoes (lb.) What is the...
-
Y ou push a 1 5 . 0 kg lawnmower across the lawn at constant speed. To do so , you exert 1 2 0 N of force along the handle, which makes an angle of 3 5 degree with the horizontal; ( a ) Draw the...
-
You may need to use the appropriate appendix table or technology to answer this question.Nominal income refers to an income value that is not adjusted for inflation. Real income adjusts the nominal...
-
A rope is lifting a heavy bucket. The speed of the bucket is increasing. How can the forces on the bucket be related to the change in speed?
-
Tempo Company's fixed budget ( based on sales of 1 4 , 0 0 0 units ) folllows. Tempo Company's fixed budget ( based on sales of 1 4 , 0 0 0 units ) folllows. 1 . Compute total variable cost per unit....
-
On January 1 , year 1 , firm ABC bought 2 5 % of the outstanding common stock of FXC for $ 3 0 4 , 0 0 0 cash. At the date of acquisition of the stock, FXC ' s net assets had a fair value of $ 9 2 0...
-
Write a Java program that keeps up with the scores in a baseball games, then reports them. Ask the user for the home team name and the visiting team name. Set up two arrays that will store the number...
-
Test whether the 5-year survival rate for breast cancer is significantly different between African American and Caucasian women who are younger than 50 years of age and have localized disease....
-
Consider again the supermarket chain described in Problem 50. Now, assume that the daily sales of the five stores are no longer independent of one another. In particular, the file S04_77.xlsx...
-
For the SciTools example, once you build the tree as in Figure 6.9 and then run a one-way sensitivity analysis with the dialog box filled in as in Figure 6.22, you obtain three strategy charts....
-
Consider again Techwares decision problem described in Problem 40. Suppose now that Techwares utility function of net revenue x (measured in dollars), earned from the given marketing opportunities,...
-
Describe the four procedures that can be used in conducting tests of controls.
-
Sampling is more likely to be used for certain types of tests of controls. What types are these?
-
For what types of procedures would sampling be appropriate?
Study smarter with the SolutionInn App