SHOW EXCEL SOLVER SETUP FOR UPVOTE

She wants to find a mix of projects with the greatest total value subject to a budget of $300,000. However, she must either accept or turn down a project (i.e., no partial funding is allowed). She wants to fund either G or H, but not both. Between B,C,E, and F, at least one project must be picked, but not more than 2 . Finally, project D should not be funded unless project A is also funded (but A can be funded without D ). Formulate the research budgeting problem facing her and solve her using Solver. Based on the solver output, select ALL the correct options from below. Penalties for incorrect options selected. Projects D and E should be funded Project G should be funded In the solution, money is left over (not being invested in projects) is more than $15,000 In the solution, money is left over (not being invested in projects) is less than $15,000 The maximum profit from the projects is $254,000 Project B should be funded to generate maximum profit Project H should be funded A and D both should be funded Projects D and E should not be funded The maximum profit from the projects is $245,000