3 Homework Problems with Solutions (Quantitative Methods (Stats))
reneo.kena87
problems_with_screenshots.xlsxPA 4
| Project | NPV | Engineers | Costs | Allocation |
| 1 | 600000 | 9 | 196000 | 0 |
| 2 | 680000 | 12 | 400000 | 1 |
| 3 | 550000 | 7 | 70000 | 1 |
| 4 | 400000 | 4 | 180000 | 1 |
| 5 | 350000 | 8 | 225000 | 0 |
| 6 | 725000 | 10 | 275000 | 1 |
| 7 | 340000 | 8 | 130000 | 0 |
| Available | 35 | 1300000 | ||
| Used | 2355000 | 33 | 925000 | |
| Constraint 1 | 1 | <= | 1 | |
| Constraint 2 | 1 | <= | 1 |
