need step by step solution on excel with all the formulation
Consider the following investment projects where, for each project, you are given its net present value (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. NPV Year 1 Year 2 Year 3 Year 4 Project 1 Project 2 Project 3 Project 4 Project 5 Project 6 Project 7 Project 8 Project 9 Project 10 OOOOOO FOOOOO #roofoooo orrooooooo 18 (a) Formulate an integer linear program to determine the best investment plan and solve it by Excel Solver or implementing the Branch and Bound method. (b) Formulate the following conditions as linear constraints: (b.1) If Project 1 is invested in, then Project 2 cannot be invested in. (b.2) If Project 8 is invested in, then either Project 9 or Project 10 must also be invested in (b.3) If either Project 1 or Project 2 is invested in, then neither Project 8 nor Project 9 can be invested in. Consider the following investment projects where, for each project, you are given its net present value (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. NPV Year 1 Year 2 Year 3 Year 4 Project 1 Project 2 Project 3 Project 4 Project 5 Project 6 Project 7 Project 8 Project 9 Project 10 OOOOOO FOOOOO #roofoooo orrooooooo 18 (a) Formulate an integer linear program to determine the best investment plan and solve it by Excel Solver or implementing the Branch and Bound method. (b) Formulate the following conditions as linear constraints: (b.1) If Project 1 is invested in, then Project 2 cannot be invested in. (b.2) If Project 8 is invested in, then either Project 9 or Project 10 must also be invested in (b.3) If either Project 1 or Project 2 is invested in, then neither Project 8 nor Project 9 can be invested in