Question 12, all parts. Provide a formulation. In addition to the required formulation, solve the IP and the optimal solution and optimal value. Using Excel.

12. AB Investment Group wishes to invest $10 million in projects marked from A to E with the annual returns as shown: Their client has set the following investment guidelines. - Any money not invested in one of these projects will be invested in T-Bills paying 4% per year. - The combined investment amount in A and B may not exceed the total in E and F. - If they invest in C and D then they cannot invest in F. - At least one project from C, D, and E must be invested in. - If they invest in D then at least $1 million has to be invested in T-Bills. a. Formulate an integer linear programming problem, clearly defining the variables, to help ABI group allocate the funds in order to maximize the return on investment. b. Use Solver to find the optimal solution. How should they allocate their investments? What would be the total profit at the end of the year