Using the excel screenshot below explain the below:

You can make investments in 4 different projects, which are denoted by P1, P2, P3, and P4. To model your investments, you assign a binary variable to each project. The binary variable has a value of 1 to mean that you should invest in the project and of 0 to mean that you should not invest in the project. You need to model several logical constraints for your investments. In the Excel file provided write down the constraint by use of proper coefficients and the SUMPRODUCT() formula:

Express the constraint that at least 1 investment should be undertaken.

Express the constraint that at most 3 investments should be undertaken

Express the constraint that investment P1 must be undertaken if investment P3 is undertaken

Express the constraint that investment P2 must be undertaken if at least two of the other three investments are undertaken.

Express the constraint that at least one between P3 and P4 must be undertaken if both P1 and P2 are undertaken.

Decision Variables binary Constraints LHS RHS Decision Variables binary Constraints LHS RHS