The Texas Consolidated Electronics Company is contemplating a research and development program encompassing eight research projects. The company is constrained from embarking on all projects by the number of available management scientists (40) and the budget available for R&D projects ($300,000). Further, if project 2 is selected, project 5 must also be selected (but not vice versa). Following are the resource requirements and the estimated profit for each project:

1. Define the decision variables
2. Develop the objective function
3 Write the constraints
4 Solve the problem in Excel

Transcribed Image Text:

Project Expense (S1,000s) Management Scientists Required Estimated Profit (S1,000,000s S60 110 53 47 92 85 73 65 S0.36 0.82. 0.29 .16 56 .61 48 41