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).
Step by Step Answer:
Management Science The Art Of Modeling With Spreadsheets
ISBN: 1301
4th Edition
Authors: Stephen G. Powell, Kenneth R. Baker