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 & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th 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
-
How do individual decision styles, group influences, and organizational influences influence decision making in organizations?
-
We live in a global economy, and many different external activities have an impact on the business. On what basis would we narrow the scope of this book to de-emphasize tax law, currency exchange,...
-
Assume the following: the sales price to consumers is $150 the retailers markup is 50% Whirlpools after tax profit margin is 4% The hurdle rate is 20% Populations are as follows: Brazil 182...
-
(a) Explain the loop problem. Apply Spanning Tree Protocol (STP) in the following network diagram to solve the loop Problem. Find out the Root Bridge, root ports, designated bridge, designated ports,...
-
Earlier segments of this problem have described how Mary Graham created Echo Systems on October 1, 2014. The company has been successful, and its list of customers has started to grow. To accommodate...
-
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...
-
Suppose that a bank currently owns a $ 5 million par value Treasury bond, purchased at par, with four years remaining to maturity that pays $ 200,000 in interest every six months. Its current market...
-
Explain the difference between Net Income and Cash flow from Operations.Why is it important for a business to consistently generate a positive free cash flow.?
-
Compute the future value in year 7 of a $5,800 deposit in year 1, and another $5,300 deposit at the end of year 4 using an 8 percent interest rate. (Do not round Intermediate calculations and round...
-
What's the present value of a $970 annuity payment over four years if interest rates are 8 percent? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Present...
-
A farmer in Saskatchewan is considering planting a shelterbelt around the farmland to decrease heating and cooling costs. A projected cost of planting the shelterbelt is $10,000, whereas expected...
-
Collaboration is defined as the process by which two or more parties adopt a high level of purposeful cooperation to maintain a trading relationship over time. The relationship is bilateral in that...
-
As the Internet continues to evolve, new uses for digital communication tools like Facebook, Twitter, TikTok, Instagram, and YouTube continue to increase beyond expectations, creating large global...
-
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...
-
World Tourism Day 2 0 1 7 , with its official celebration on September 2 7 in Qatar, was focused on sustainable tourism. Established by the United Nations World Tourism Organization ( UNWTO ) , World...
-
Tracy is single and had adjusted gross income of $35,800 in 2018. Tracy also has the following items: How much may Tracy claim as itemized deductions?
-
Calculate the geometric mean return of an investment with five year returns of 10%, (15%), 12%, 8% and (5%).
Study smarter with the SolutionInn App