Formulate as an ILP & Solve using Excel A company is considering three major research projects labeled A, B, and C. Each of the projects can be selected for any of the next 3 years or may be omitted from the portfolio entirely. The total return for each project based on the year it is selected is given in the table. This return captures all relevant cash flows, including investments. It also includes the effects of the time value of money. The investment required for each project occurs entirely within the year for which it is selected. The goal is to maximize the total return. This problem has the following constraints. No more than two projects can be selected in any year. Total investment in any year cannot exceed 9. Project B must be selected after project A. Project A and B cannot be selected in the same year. A project can be selected at most once. Formulate and solve the problem as an IP. Define all notation. Year 1 2 3 Investment A 7585 Total return for project B 6 4 47 3 4455