Consider the following investment projects where, for each project, you are given its

NPV as well as the cash out flow required during each year $($in million dollars$).$

No partial investment is allowed in any of these projects. The firm has $18$ million dollars

available for investment each year.

a$)$ Formulate an integer linear program to determine the best investment

plan and solve with SOLVER. $($Upload the excel sheet with your report$)$

b$)$ Formulate the following conditions as linear constraints and resolve the IP using

Excel Solver. $($Upload the excel sheet with your report$)$

Exactly one of Projects $4,5,6,7$ must be invested in$.$

If Project $1$ is invested in$,$ then Project $2$ cannot be invested in$.$

If Project $3$ is invested in$,$ then Project $4$ must also be invested in$.$

If Project $8$ is invested in$,$ then either Project $9$ or Project $10$ must also be

invested in$.$

If either Project $1$ or Project $2$ is invested in$,$ then neither Project $8$ nor Project $9$

can be invested in$.$