Question: you recommend adding this time to sewing, cutting, or quality control? (Provide a detailed justification of your recommendation). (10 points) Question 5 An investor wants
you recommend adding this time to sewing, cutting, or quality control? (Provide a detailed justification of your recommendation). (10 points) Question 5 An investor wants to invest $5 million in different projects. After assessment, he is focusing on 8 promising projects. Each project is characterized by a budget and an associated net present value (NPV). These budgets and NPVs are displayed in the following table. Project A B C D E F G H Budget (in $100,000) NPV (in $100,000) 6 | 9 | iol 131 1ST 8 | 6 31 22 17 31 28 17 15 33 The investor wants to find a portfolio of projects that will maximize the sum of the net present values. 1) Formulate the problem using binary variables. (5 points) 2) Solve the problem using Excel Solver. What is the optimal solution? What is the optimal objective value. (5 points) The investor considers that projects D, E, and F are quite risky. Therefore, he does not want to select more than one out of these risky projects. Write the corresponding model and solve it using Excel Solver. (5 points) 3)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
