Question: Build a project selection solver model that maximizes a profit within a given budget. Project Init. Invest Annual NCF Life PW A $20,000 $5,000 4
Build a project selection solver model that maximizes a profit within a given budget.
| Project | Init. Invest | Annual NCF | Life | PW | ||
| A | $20,000 | $5,000 | 4 | -$2,270.25 | ||
| B | $90,000 | $19,000 | 9 | $45,048.61 | ||
| C | $70,000 | $26,800 | 5 | $46,029.97 | ||
| D | $40,000 | $24,000 | 4 | $45,102.81 | ||
| E | $60,000 | $20,000 | 5 | $26,589.53 | ||
| F | $70,000 | $20,000 | 6 | $31,513.84 | ||
| G | $40,000 | $17,000 | 5 | $33,601.10 | ||
| H | $10,000 | $3,400 | 5 | $4,720.22 | ||
| Budget | $215,000 | 5% | interest rate | |||
| Constraint 1: Project A must be selected if Project B is selected | ||||||
| Constraint 2: A maximum of two projects can be selected among Project C, D, E, and F. | ||||||
| Constraint 3: Exactly three projects must be selected among E, F, G, and H | ||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help