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.

User Account

All Pages