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?

Transcribed Image Text:

Bids by Companies (in $1,000s) for Various Subcontracts Company Component 185 225 193 207 200 190 175 225 330 320 315 300 375 389 425 445 4