Page 1 of 1
Use the Excel Solver output for a maximization LP problem to determine which constraints are binding, Objective Function
Posted: Wed May 11, 2022 8:38 am
by answerhappygod
- Use The Excel Solver Output For A Maximization Lp Problem To Determine Which Constraints Are Binding Objective Function 1 (47.29 KiB) Viewed 30 times
Use the Excel Solver output for a maximization LP problem to determine which constraints are binding, Objective Function Value = 7475.00 Variable Cells Final Reduced Name Value Cost P1 8 0 Objective Allowable Allowable Coefficient Increase Decrease 100 1E+30 12.5 120 5 1E+30 150 12.5 25 P2 0 -5 P3 17 0 P4 33 0 125 25 5 Constraints Final Shadow Value Price Constraint Allowable Allowable R.H. Side Increase Decrease Name Constraint A 108 0 118 15.75 8 Constraint B 157 10 157 1E+30 63 Constraint C 25 25 25 33 17 Constraint D 50 -25 50 4 8.5 Constraints B.C, & Donly Constraints B & D only Constraint D only Constraints A & C only OO All the constraints are binding