Question: gnment Question 1: Integer Programming (25 Points) The Texas Consolidated Electronics Company is contemplating a research and development program encompassing eight research projects. The company

 gnment Question 1: Integer Programming (25 Points) The Texas Consolidated Electronics

gnment Question 1: Integer Programming (25 Points) 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: Project Expense Management Estimated Profit ($1,000s) Scientists Required ($1,000,000s) $ 60 7 $0.36 N 100 0.82 53 0.29 47 0.16 92 0.56 vauA 85 0.61 73 0.48 8 65 0.41 a. Define the decision variables. (3 Points) b. Develop the objective function. (3 Points) c. Write the constraints. (9 Points) d. Solve the problem in Excel. (10 Points: Decision variables section: 1 points, O.F. Section: 1 points, Constraints section: 3 points, Solver: 5 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!