An automobile manufacturer is considering mechanical design

Assignment Help Business Management
Reference no: EM13228762

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 10 changes that could be made in the car to make it lighter. The weight saved by each design change and the estimated costs of implementing each change are summarized in the table:
Design Changes 1 2 3 4 5 6 7 8 9 10
Weight Saved (lbs) 50 75 25 150 60 95 200 40 80 30
Cost (in $1000) 150 350 50 450 90 35 650 75 110 30 

Changes 4 and 7 represent alternate ways of modifying the engine block and therefore only one of these options can be selected. The company wants to determine which changes to make in order to reduce te total weight of the car by at least 400 pounds in the least costly manner.

1) Formulate an ILP model for this problem.
2) Create a spreadsheet model for this problem

Reference no: EM13228762

Questions Cloud

Design a training environment that minimizes these obstacles : How will you design a training environment that minimizes these obstacles?
Find a news article with homicide : Was there a connection between the type of crime and the location of the crime? What prevention strategies could have been employed to reduce this type of crime?
How much the amplitude of envelope increases : Needs to oscillate 5 times per second. Amplitude envelope increases 25% every second. Amplitude is 1 at t =0. The derivative at t = 0 is 54.6371. the sinusoid has to be a cos(2*pi*5*t) for the exponential exp(at).
Write down only the first three harmonics : Four frequencies are applied at the input of a non-linear amplifier. Write down all of the frequency components at the output of the non-linear device. Write down only the first three harmonics. Frequencies of 1205Khz, 1200Khz, 1195Khz
An automobile manufacturer is considering mechanical design : 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 10 changes that could be made i..
Review the annual report for relevant details of the size : Research the Harley-Davidson (H-D) Web site for each brand, and review the annual report for relevant details of the size, scope, target market, services and amenities, and other salient points of differentiation.
The perspective of the quality of life for the entrepreneur : From the perspective of the quality of life for the entrepreneur which is better: To run a private company or to run a public company? Why? Provide real-life examples from the business world. What would you suggest to improve the quality of life issu..
Project manager at the project inception stage : What sort of challenges do you think the Project Manager might encounter during the project inception and feasibility stages - Project Manager at the project inception stage to still be in his or her position through the procurement phase
Managerial groups within a large organization : Managerial groups within a large organization are more likely to make better decisions than other managers within that same organization. Provide support for your position.

Reviews

Write a Review

 

Business Management Questions & Answers

  Explain how much are the annual payments worth to you today

f you can earn 7% per year, Explain how much are the annual payments worth to you today? Which is the better deal? Explain why?

  How to write a welcome letter

How to write a welcome letter explaining organizational culture at CollinsPine - Business has been good and the company has recently hired new employees.

  Illustrate what was the most important thing you learned

Now which you have completed payroll accounting, take a few moments to reflect on illustrates what you have accomplished.

  The quantity in order to maximize profits

The cost to produce each of two products is dependent on the quantity in order to maximize profits.

  Explain the difference between extrinsic and intrinsic

Explain the difference between extrinsic and intrinsic motivation and Describe school and work experiences in which you have experienced each type of motivation.

  How a mentor and orientation can assist career development

How a Mentor and Orientation can Assist Career Development - Propose three ways that a mentor and a new employee orientation can assist employees with their career development.

  Explain and discuss what is included in calculating gdp

Explain and Discuss what is and what is not included in calculating GDP and Why do total leakages and total injections have to be equal?

  Assume the owner wishes to consider her decision problem

Assume the owner wishes to consider her decision problem over a two day period. Her substitute for the second day are determined as follows.

  What does this relationship propose to potential investors

What does this relationship propose to potential investors as far as setting important priorities? What is the most significant determinant of meeting retirement goals?"

  Organizational behavior - communications technology

Technology application examples can range from situations as varied as using the telephone or walkie-talkie to talk to someone vs. talking in person to tweeting to advertise product enhancements

  Define business strategy

The project may draw on items from the online environment-newspapers, magazines, and websites-to provide current (i.e., within the last year) examples of course-related topics (i.e., Business Strategy). Relevance and probable interest to the class..

  Test statistics as well as the stated life

The test question was if this variance between the test statistics as well as the stated life of the battery was significant? The .05 important level was selected for the test. Which is the accurate statement?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd