Assignment
Implement the following LP problem in a spreadsheet. Use Solver to solve the problem and create a Sensitivity Report. Use this information to answer the following questions:
MAX: 4X1+2X2
Subject to: 2X1+4X2≤20
3X1+5X2≤15
X1,X2≥0
1. What range of values can the objective function coefficient for variable X1 assume without changing the optimal solution?
2. Is the optimal solution to this problem unique, or are there alternate optimal solutions?
3. How much does the objective function coefficient for variable X2 have to increase before it enters the optimal solution at a strictly positive level?
4. What is the optimal objective function value if X2 equals 1?
5. What is the optimal objective function value if the RHS value for the second constraint changes from 15 to 25?
6. Is the current solution still optimal if the coefficient for X2 in the second constraint changes from 5 to 1? Explain.
Format your assignment according to the give formatting requirements:
1. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the course title, the student's name, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.