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
-
The Ledger Balance of Cash section of the bank reconciliation for Lasha Company for July 31 follows. Journalize the entries required to bring the general ledger up to date as of July of thisyear....
-
Tuscany Statuary manufactures bust statues of famous historical figures. All statues are the same size. Each unit requires the same amount of resources. The following information is from the static...
-
When conducting an incremental analysis, what step must always be taken immediately prior to beginning the pairwise comparisons? a. Order the alternatives from highest to lowest initial investment b....
-
The Green Acres Inn is trying to determine its break-even point. The inn has 50 rooms that it rents at $60 a night. Operating costs are as follows. Salaries ..........$6,200 per month Utilities...
-
Consider the region R on Earth including points whose coordinates, when rounded to a whole number of seconds, round to 1233'8" N, 8843'11" W. Determine with justification the perimeter of region R.
-
You are employed by McDowell and Partners, Chartered Accountants (M&P). A new client, Community Finance Corporation (CFC), approached M&P for assistance. Enviro Ltd. (Enviro) has asked CFC for a loan...
-
Watertown, Inc. was founded in May, 2005 by Lawrence Rollins, who was employed for 20 years prior as a river rafting guide. Mr. Rollins received an unexpected inheritance of $2,000,000 in January,...
-
Why is price transparency of health care costs important for consumers? a. It helps consumers understand the remittance remarks codes and payment adjustments. b. It provides increased customer...
-
Assignment Overview - Write a four hundred word essay that analyzes the macroeconomic impact of the September 11th terrorist attack on the US economy and the policy responses by Congress and the...
-
Explain the role of Remittance Advice in the revenue cycle. a. It identifies services that may not be covered by insurance. b. It allows the MAC to process Medicare claims. c. It indicates the types...
-
Why would a company choose a NoSQL database over a relational database? What are the advantages of NoSQL databases? Describe one major difference between NoSQL and relational databases.
-
When is the account Freight-in included in the closing entries of a merchandising company that uses a perpetual inventory system? NeverFreight-in is a cost of inventory rather than an expense...
-
To which activity (1, 2, 3, and 4) is assignment Activity D in the solution of the problem? A 4OO B C D 1 38 54 56 42 2 48 60 94 40 388814 50 60 90 54 4 44 68 85 48
-
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,...
-
What is an off-by-one error?
-
Will the universality of management continue to be true in the future? Why or why not?
-
Describe what a manager does. How does the work of managers differ from that of nonmanagerial employees?
Study smarter with the SolutionInn App