Second consulting is considering undertaking several proposed projects for the next fiscal year. The projects, the number of engineers and support personnel required for each project, and the expected profits for each project are summarized in the following table:Project123456Engineers required205547389063Support personnel required154550407070Profit ($1,000,000s)1.01.82.01.53.62.2 There are 175 engineers available and 150 support personnel available for these projects. Further, no more than 3 projects can be done. Formulate an integer program to solve this problem.Define the decision variables needed to model this problem.The objective is to maximize profit. Give the objection function.Write the constraints.What is the final answer? Explain in detail.

Answered: Second consulting is considering…

we would just formulate an ILP model assuming there is no need to solve the so obtained model-

Engineers required

Support personnel required

Profit ($1,000,000s)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 21P

See similar textbooks

Related questions

Question

Second consulting is considering undertaking several proposed projects for the next fiscal year. The projects, the number of engineers and support personnel required for each project, and the expected profits for each project are summarized in the following table:

There are 175 engineers available and 150 support personnel available for these projects. Further, no more than 3 projects can be done. Formulate an integer program to solve this problem.