Use the Excel Solver output for a maximization LP problem to determine which constraints are binding, Objective Function

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Use the Excel Solver output for a maximization LP problem to determine which constraints are binding, Objective Function

Post by answerhappygod »

Use The Excel Solver Output For A Maximization Lp Problem To Determine Which Constraints Are Binding Objective Function 1
Use The Excel Solver Output For A Maximization Lp Problem To Determine Which Constraints Are Binding Objective Function 1 (47.29 KiB) Viewed 29 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”