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?

Transcribed Image Text:

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