An automobile manufacturer is considering mechanical design changes in one of its top-selling cars to reduce the
Question:
An automobile manufacturer is considering mechanical design changes in one of its top-selling cars to reduce the weight of the car by at least 400 pounds to improve its fuel efficiency. Design engineers have identified ten changes that could be made in the car to make it lighter (for example, using composite body pieces rather than metal). The weight saved by each design change and the estimated costs of implementing each change are summarized below:
Changes 4 and 7 represent alternate ways of modifying the engine block and, therefore, only one of these options could be selected. The company wants to determine which changes to make to reduce the total weight of the car by at least 400 pounds in the least costly manner.
a. Formulate an ILP model for this problem.
b. Create a spreadsheet model for this problem and solve it.
c. What is the optimalsolution?
Design Change 2 3 4 5 6 78910 Weight Saved (lbs) 50 75 25 150 0 95 200 480 30 Cost (in $1,000s) $150 $350 S50 $450 $90 $35 $650 $75 $110 $30
Step by Step Answer:
a LetXi 1 if design change i is selected 0 otherwise ...View the full answer
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics
ISBN: 1233
8th Edition
Authors: Cliff T. Ragsdale
Related Video
Today we’ll be performing an effective yoga exercise that has 6 benefits. The first and most important benefit is that it will help us reduce belly fat and will be beneficial for reducing weight. The rest of the 5 benefits will be discussed shortly in the video So keep watching the video till the end. Another yoga pose you can swear by to reduce belly fat is Kumbhakasana. It is also called the plank pose. Performing this asana on a regular basis aids weight loss, reduces back pain, strengthens core muscles, and improves body balance and flexibility.
Students also viewed these Management Leadership questions
-
An automobile manufacturer is considering locating an automobile assembly plant in your region. List two simple, two intermediate, and two complex problems associated with this proposal.
-
An automobile manufacturer is considering using robots for part of its assembly process. Converting to robots is an expensive process, so it will be undertaken only if there is strong evidence that...
-
An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is...
-
A long cylindrical wood log (k = 0.17 W/mK and = 1.28 10 -7 m 2 /s) is 10 cm in diameter and is initially at a uniform temperature of 15C. It is exposed to hot gases at 550C in a fireplace with a...
-
Prove that a subspace W of R3 coincides with R3 if and only if it contains the vectors And 001
-
A new accountant has been appointed to Dettum Ltd and has implemented major changes in the calculation of depreciation. As a result, some parts of the factory have much larger depreciation charges....
-
For each of the four categories of adjusting entries, describe the business activity that produces circumstances requiring adjustment. LO7
-
Jacksons Thriftway currently processes all of its credit sales at its Seguin, Texas, headquarters. The firm is considering establishing a lockbox arrangement with a Chicago bank to process payments...
-
Find Lim 1x +31 X -7- 3+ x+ 3 Lim 1x+31 x -7-3+ X+3
-
Statement of Cash Flows, Direct Method. Using the information from E6-7, compute net cash flow from operating activities for Tulsa Corporation under the direct reporting format. E6-7 Statement of...
-
The Mega-Bucks Corporation is planning its production schedule for the next four weeks and is forecasting the following demand for compound Xa key raw material used in its production process: The...
-
Darten Restaurants owns and operates several different restaurant chains including Red Snapper and the Olive Grove. The company is considering opening a number of new units in Ohio. There are ten...
-
In recent years, two global companies have had to deal with some quite large costs as a result of quality control failures. First, take the example of Toyota cars in the US. In late 2009 and early...
-
The Dutton Company is decentralized, and divisions are considered investment centers. Dutton has one division that manufactures oak dining room chairs with upholstered seat cushions. The Chair...
-
What are the main tax laws applicable in Puerto Rico? What is the function of the Office for the Protection of Taxpayer Rights? Which individuals are required to file a return? When are estimated tax...
-
On the planet Xgnu, 1 4 0 0 kryll = 1 blim. A book is presently being used at Xgnu University. The area of the cover of the book is 6 6 . 0 square krylls . What is its area in square blims?
-
Financial analysts forecast Limited Brands ( LTD ) growth rate for the future to be 9 . 5 percent. LTD s recent dividend was $ 0 . 4 0 . What is the value of Limited Brands stock when the required...
-
Effective data visualization is important for communicating findings to audiences without the need for technical knowledge to understand the analysis. However, data visualizations can be misleading,...
-
The Nazca and Pacific Plates are spreading relatively fastat the rate of 14.2 cm (5.6 in) per year. The East Pacific Rise is a midocean ridge system that divides these plates. If the central segment...
-
Suppose that A is an m n matrix with linearly independent columns and the linear system LS(A, b) is consistent. Show that this system has a unique solution.
-
How do you think different ethnocentric approaches to doing business might damage international trade?
-
a. Create a spreadsheet model for this problem and solve it. b. What is the optimal trading plan? c. What is the optimal transaction cost (in equivalent USD)? d. Suppose that another executive thinks...
-
a. Create a spreadsheet model for this problem and solve it. What is the optimal solution? b. Of the constraints Tom placed on this problem, which are binding or preventing the objective function...
-
A variable that assumes an optimal value between its lower and upper bounds has a reduced cost value of zero. Why must this be true? (What if such a variables reduced cost value is not zero? What...
-
Market research conducted by Kauai Ltd revealed great potential for a new energy drink. To produce the product would require R 1 1 0 0 0 0 0 in new equipment. The equipment is expected to have a...
-
Penelope was recruited to serve as the Chief Human Resources Officer (CHRO) of Epsilon Corporation, a privately-held company in the automotive industry, effective June 1, 2022. Throughout the fiscal...
-
Calculate Return on Equity (ROE): Requirements: Using the following figures: Net Income: $110,000 Average Equity: $700,000 Compute the return on equity (ROE). Express ROE as a percentage. Provide the...
Study smarter with the SolutionInn App