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 optimal solution?
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here