Please Provide answer via word document and excel formats.

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 please The optimal solution obtained in Excel. . Two screenshots: one for your Excel model setup, and the other for the "Solver Parameters" dialog. 1. 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. Drug Purpose Expected Revenue (in $ millions) Drug 1 Liver Cancer Treatment 450 Drug 2 Antibiotic for HIV patients 700 Drug 3 Colon Cancer 1,500 Drug 4 Cholesterol Reduction 3,500 Drug 5 Central Nervous System Treatment 4,000The primary resource constraints are human resource constraints based on knowledge and skill levels of experts. Sr. Sci. hrs Jr. Sci. hrs Lab Tech hrs Sr. Cli Sci, hrs Jr. Cli Sci, hrs Stat, hrs 40,000 80,000 80,000 40,000 80,000 20,000 The human resource requirement for each drug development is shown as follows. Liver Cancer HIV Colon Cancer Cholesterol CNS Sr. Sci, hrs 11,500 11,500 11,500 11,500 11,500 Jr. Sci, hrs 18,500 21,000 23,000 25,000 25,000 Lab Tech, hrs 9,000 11,500 11,500 11,500 13,500 Sr. Cli Sci, hrs 5,500 6,500 8,500 9,500 9,500 Jr. Cli Sci, hrs 9,500 12,000 14,000 17,000 17,000 Stat, hrs 4,500 5,500 6,500 6,500 7,000 Formulate and solve an integer programming model to select the drug candidates