The Texas Consolidated Electronics Company is contemplating a research and development program encompassing five research projects. The company is constrained from embarking on all projects by the number of available management scientists (24) and the budget available for R &D projects ($800,000). Following are the resource requirements and the estimated profit for each project: Project Expense Management Estimated Profit
($1000s) Scientists Required ($1,000,000s)
1 180 6 0.4
2 250 8 0.8
3 150 7 0.3
4 180 5 0.5
5 200 5 0.6
6 190 4 0.4
The company would like to maximize net profit for this program. Solve the problem using excel solver.