Formulate a linear integer programming model for the problems (In a MS word report format 4 pages max).
Problems 1 & 2 Instructions:
Formulate a linear integer programming model for the problems (In a MS word report format 4 pages max). Make sure you clearly define your decision variables objective function and constraints in a standard format. Use the equation editor in MS-Word to write your equations. Note: You can use the model you developed in Problem 1 and make the necessary adjustments to accommodate the requirements for Problem 2. Also answer the questions for both problems in MS word and justify your answers by addressing what you did in your excel spreadsheet to answer each question.
Excel Files:
Implement your formulated model in Excel and use Solver to answer the questions by the end of problem. Provide answers to these questions in your report based on your Excel model results. Remember you can use the model you developed in Problem 1 and make the necessary adjustments to accommodate the requirements for problem 2.
Note: The problems are attached in two PDF files (one for each problem) along with this instruction sheet.
Attachments: