Question

8. By using solver, and given the following LP model, please answer. Make sure to provide the sensitivity analysis results: (4 points each) 1 2 18Y 14X + МАX 3 4 s.t. 1000 12Y + 10X 5 1000 40X 2000 30Y 20X + 7 0 X.Y VI VI VI A e. What would happen if we would change the RHSS of constraint 3 to 2400? Explain

Answer 1

Y Number to make 25 50 Available Used Required Inputs 12 850 1000 10 1000 <= 1000 40 0 20 2000 = 2000 30 Objective value 1250 14 18 Objective fn. cs Scanned with. CamScanner

1 Microsoft Excel 16.0 Sensitivity Report 2 Worksheet: [Book1]Sheet1 3 Report Created: 6/19/2019 6:19:20 AM 4 5 6 Variable Cells Final Reduced Objective Allowable Allowable 7 Coefficient Increase Decrease Value Cost Cell 8 Name 1E+30 2 14 0 25 $C$3 Number to make X 9 18 18 3 50 $D$3 Number to make Y 10 11 12 Constraints Final Shadow Constraint Allowable Allowable 13 Decrease R.H.Side Value Price creas Cell Name 14 150 1E+30 1000 SE$5 Required Inputs Used $E$6 Used 850 15 1000 3000 1000 0.05 1000 16 1500 SES7n USed with CamScanner 2000 375 0.6 2000 17に
e) if RHS of const. 3 to 2400

the value of objective function increasing. also X is decreasing and Y is increaaing as compare to part first.

fir X G H F A C B Y X 20 66.66667 Number to make Used Available Required Inputs 10 12 1000 1000 40 0 800 = 1000 20 2400 30 2400 Objective value Objective fn 14 18 1480 CS Scanned with CamScanner T