A developer of video game software has seven proposals for
A developer of video game software has seven proposals for new games. Unfortunately, the company cannot develop all the proposals because its budget for new projects 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 below. Projects 2 and 6 require specialized 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. (All dollar amounts represent thousands.)



a. Formulate an ILP model for this problem.
b. Create a spreadsheet model for this problem and solve it.
c. What is the optimalsolution?
Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
    Tutors
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
OR
Relevant Tutors available to help