operational research question Imp

Q.3. ABC company is considering investments into 6 projects: A, B, C, D, E and F. Details about each project are given in the table below: 0.6 1.8 D E 1.2 F Initial cost (in M) 1.3 0.8 2.4 10% 20% 20% 10% 10% 10% 4% Profit rate 6% 4% 6% 5% 5% Failure risk a) Provide a formulation to choose the projects that maximize total expected profit, such that the company does not invest more than 4M dollars and its average failure risk is not over 5% b) Suppose that if A is chosen, B must be chosen. Modify your formulation c) Suppose that if C and D are chosen, E must be chosen. Modify your formulation d) Solve the formulation in 'a' by using the branch and bound method e) Solve the formulation in 'b' by using the excel solver. Q.3. ABC company is considering investments into 6 projects: A, B, C, D, E and F. Details about each project are given in the table below: 0.6 1.8 D E 1.2 F Initial cost (in M) 1.3 0.8 2.4 10% 20% 20% 10% 10% 10% 4% Profit rate 6% 4% 6% 5% 5% Failure risk a) Provide a formulation to choose the projects that maximize total expected profit, such that the company does not invest more than 4M dollars and its average failure risk is not over 5% b) Suppose that if A is chosen, B must be chosen. Modify your formulation c) Suppose that if C and D are chosen, E must be chosen. Modify your formulation d) Solve the formulation in 'a' by using the branch and bound method e) Solve the formulation in 'b' by using the excel solver