Solver Practice Problems
Solver practice problems ask you to compute a numerical solution with Excel Solver or MATLAB after formulating the LP.
Expected Answer Structure
A solver-practice answer should include:
- model formulation
- solver input structure
- solution vector
- optimal objective value
- short interpretation
- verification of constraints
Excel Solver Practice
For Excel Solver:
- put variables in cells
- compute objective with
SUMPRODUCT - compute constraint left-hand sides with
SUMPRODUCT - add constraints in Solver
- choose Simplex LP
- solve and report the result
MATLAB Practice
For MATLAB:
[x, fval] = linprog(f, A, b, Aeq, beq, lb, ub);
For maximization:
f = -c;
[x, fval] = linprog(f, A, b, Aeq, beq, lb, ub);
max_value = -fval;
Verification
After solving, check:
\[Ax\le b, \qquad A_{eq}x=b_{eq}, \qquad x\ge 0.\]Then recompute the original objective value.
Interpreting Solver Status
If the solver reports infeasible, unbounded, or no convergence, do not invent a solution.
State the solver status and explain what it means for the original problem.
Checklist
Solver practice is graded on both formulation and computation. A correct solver command with a wrong model is still wrong.
See Also
Exam checkpoint
Practice under exam timing. Write the full pipeline: model, standard form if needed, BFS/reduced costs if asked, simplex iterations if asked, final objective value and interpretation.