Question: Can you please solve these problems and show the work on excel? Use the table below to answer the following question(s) by invoking the binary

Can you please solve these problems and show the work on excel?

Can you please solve these problems and show the
Use the table below to answer the following question(s) by invoking the binary constraints on the variables using the standard Solver.) Below is the data for the spreadsheet for a project selection model: Project NPV (return) cash investment personnel requirements 1 75,000 30,000 10 2 50,000 45,000 5 3 25,000 75,000 10 4 85,000 30,000 4 5 50,000 45,000 8 5 25,000 75,000 7 7 95,000 45,000 5 8 25,000 60,000 1 9 75,000 30,000 2 10 65,000 45,000 2 You have $250,000 to invest and 36 people. Maximize NPV by approving/rejecting projects. Multiple Choice #8: How many projects ofthe ten are approved? A) 6 B) 4 c) 10 D) 5 Multiple Choice #9: If I told you that you cannot accept both projects #3 and project #4, would your current optimal solution change? A) Yes; since we current accept both projects, we know the optimal answer would have to be different with an additional constraint. B) No; since we are not accepting project #3 anyway, our current solution would still be optimal. C) No; since we are not accepting project #4 anyway, our current solution would still be optimal. D) No; since we are not accepting either project, our current solution would still be optimal. E) There is no way we can tell unless we redefine the problem and rerun Solver

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!