Please see screenshot of data set for this problem.

Riesemberg Medical Devices is allocating next year's budget among its divisions. As a result, the R&D Division needs to determine which R&D projects to fund. Each project requires various software and hardware and consulting expenses, along with internal human resources. A budget allocation of $1,300,000 has been approved, and 35 engineers are available to work on the projects. The R&D group has determined that at most one of projects 1 and 2 should be pursued, and that if project 4 is chosen, then project 1 must also be chosen. Develop a model to select the best projects within the budget.

Which combination of projects maximizes NPV within the budget? Select all that apply.

A. 6

B. 4

C. 2

D. 3

E. 7

F. 5

G. 1

Thank you!

A B D 1 2. 3 4 5 w NP Project 1 2 3 Engineers 4 9 8 NPV 590000 610000 340000 400000 725000 550000 650000 Additional Costs 400000 196000 130000 180000 200000 70000 225000 4 12 10 6 5 7 6 7 8 7 00 9