Question: excels solver tools has been used in the spreadsheet below to solve a linear programming problem with a minimization objective function and all >= constraints
excels solver tools has been used in the spreadsheet below to solve a linear programming problem with a minimization objective function and all >= constraints
| input section | x | y | |
| objective function coefficients | 5 | 3 | |
| constraints | Required | ||
| #1 | 4 | 2 | 60 |
| #2 | 5 | 4 | 50 |
| #3 | 7 | 8 | 144 |
| Output Section | |||
| Variables | 10.66667 | 8.666667 | |
| Total | |||
| profit | 53.33333 | 26 | 79.33333 |
| Constraints | usage | ||
| #1 | 60 | ||
| #2 | 88 | ||
| #3 | 144 |
a. give the original linear programming problem
b. give the complete optimal solution (including slack)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
