Question: The follwoing reports were generated using Excel Solver for the follwoing LP problem Min Z= 5x1 + 3x2 Subject to: 2x1 +2x2 28 3x1+x2 26

The follwoing reports were generated using ExcelThe follwoing reports were generated using ExcelThe follwoing reports were generated using Excel

The follwoing reports were generated using Excel Solver for the follwoing LP problem Min Z= 5x1 + 3x2 Subject to: 2x1 +2x2 28 3x1+x2 26 4x1+2x2 s 12 X1, X220 Please read these tables and answer the following questions: 1) Please classify slack and surplus variables for all constraints and list the value for each constraint [1 points] 2) Calculate range of optimality for this problem and explain its meaning in 1-2 sentences [1.5 points] 3) Calculate range of feasibility for this problem and explain its meaning in 1-2 sentences [1.5 points] 4) What is the meaning of shadow price for THIS LP problem [2 points] (Hint: do not use general definition of the shadow price, rather use the numbers from this problem to expalin what happens) 5) What is the change on the Z value for the following changes in the parameters [2 points]: (a) change RHS for constraint-1 from 8 to 10; (b) change RHS for constraint-3 from 12 to 27 6) True or false (c) True or false: if we change the Z function from Min Z= 5x1+ 3x2 to Min Z= 8x1+ 3x2 ,then the optimal solution will not change and remains x1=1 and x2=3 (d) True or false: if we change the Z function from Min Z= 5x1+ 3x2 to Min Z= 5x1+ 6x2 then the optimal solution will not change and remains x1=1 and x2=3 + Slack Cell Name $C$18 Constraint-1 $C$19 Constraint-2 $C$20 Constraint-3 Cell Value Formula Status 8 $C$18>=$E$18 Binding 6 $C$19>=$E$19 Binding 10$C$20

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!