Problem $1($Chapter $6,$ exercise $16-$ easy BP$)$

A developer of video game software has seven proposals for new games. Unfortu$-$

nately, the company cannot develop all the proposals because its budget for new pro$-$

jects is limited to $$950,000,$ and it has only $20$ programmers to assign to new projects.

The financial requirements, returns, and the number of programmers required by

each project are summarized in the following table. Projects $2$ and $6$ require special$-$

ized programming knowledge that only one of the programmers has. Both of these

projects cannot be selected because the programmer with the necessary skills can be

assigned to only one of the projects. $($Note: All dollar amounts represent thousands.$)$

Formulate an optimization problem that maximizes the total estimated NPV subject to

constraints. Crate a spreadsheet model and solve the problem. Verify your solution with

Python. What is the optimal solution?