An automobile manufacturer wants to award contracts for the supply of five different engine components. Some of

Question:

An automobile manufacturer wants to award contracts for the supply of five different engine components. Some of the components are used in most models, while other components are specialized to one or two models—therefore, the volumes differ. Five contractors have submitted bids on the components, and the following table summarizes the prices bid per unit. Where no entry appears, the contractor did not bid.

The manufacturer wants to determine how many units of each component should be awarded to each contractor in order to minimize total cost for the purchases. (For these purposes, fractional solutions in the model are acceptable.)

a. What is the minimum total cost for the manufacturer, if no other conditions are imposed?
b. In fact, Supplier 2 is capacity-constrained and cannot provide more than 25,000 units in total. In addition, the manufacturer does not want more that $2 million allocated to any one of the suppliers. Recognizing these limitations, what is the minimum total cost for the manufacturer?
c. Describe the qualitative pattern (computational scheme) in the solution for (b).

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Management Science The Art Of Modeling With Spreadsheets

ISBN: 1301

4th Edition

Authors: Stephen G. Powell, Kenneth R. Baker

Question Posted: