Integer Programming HW

for Konopka

Homework Assignment $-$ Integer Programming

Note: For this problem, write down the IP model in a Word document, and solve the model in an Excel file. Submit both the Word and Excel files. The Word document should include the following contents:

The IP model $($decision variables, objective function, and constraints$)$ with necessary explanation $-$ clear explanation of the model would help the grader justify your model, and maximize your points earned even if your model is not completely correct.

The optimal solution ohfained in Excel.

Two screenshots: your Excel model setup, and the other for the "Solv neters" dialog.

$(20$ points$)$ A pharmaceutical company wants to select the right mix of drugs to maximize the expected revenue without exceeding its R&D resources. Drugs considered for development are listed in the following table.

$\backslash$table$[[$Drug$,$Purpose,$\backslash$table$[[$Expected Revenue $($in $