Question: For question 4(a), implement the following linear programming (LP) problem and solve it. For questions 4(b)-4(e), without solving the LP problem again, answer the

For question 4(a), implement the following linear programming (LP) problem and solve

For question 4(a), implement the following linear programming (LP) problem and solve it. For questions 4(b)-4(e), without solving the LP problem again, answer the questions based on the Sensitivity Report obtained from the implementation in question 4(a). MIN: 5X13X2 + 2x3 Subject to: 2X1 + 2x2 + 4X3 4 5X13X2 + 2X3 > 1 X1, X2, X3 0 (a) Implement the LP model in a spreadsheet. Solve the problem using the solver in Excel. Save your solution with the report as "Q4.xlsx" and upload it in the box provided (see illustration below). [2 points] Edit View Insert Format Tools Table 12pt Paragraph To v Upload images BI U Upland documents (PDF XLS, DOC,.) de formare (b) How small can the coefficient of X3 in the objective function be without the necessity to change the optimal solution? [1 point] (c) Determine the optimal objective function value if the RHS value of the first constraint decreases to 2. [1 point] (d) Will the current solution remains optimal if the objective function's coefficient of X is decreased by 0.5 and the coefficient of X3 is increased by 1.5 at the same time? Justify your answer. [2 points]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!