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:

  1. put variables in cells
  2. compute objective with SUMPRODUCT
  3. compute constraint left-hand sides with SUMPRODUCT
  4. add constraints in Solver
  5. choose Simplex LP
  6. 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.