Question: A manufacturer of prefabricated homes has decided to subcontract

A manufacturer of prefabricated homes has decided to subcontract four components of the homes. Several companies are interested in receiving this business, but none can handle more than one subcontract. The bids made by the companies for the various subcontracts are summarized in the following table.


Assuming that all the companies can perform each subcontract equally well, to which company should each subcontract be assigned if the home manufacturer wants to minimize payments to the subcontractors?
a. Formulate an LP model for this problem.
b. Create a spreadsheet model for this problem and solve it using Solver.
c. What is the optimalsolution?
View Solution:


Sale on SolutionInn
Sales52
Views2173
Comments
  • CreatedSeptember 22, 2012
  • Files Included
Post your question
5000