i-nth logo
Optimization models in Excel

Optimization models in Excel

26 February 2021

Solver Max, a sister company of i, provides a collection of optimization model examples using the Solver and OpenSolver add-ins.

Models include:

  • Facility location. Where should we locate our facility to maximize profit?
  • Job sequencing. What is the best sequence for the jobs that we need to complete?
  • Wire cutting. What is the best way to cut our stock material to minimize waste?
  • Fantasy sports. How can we select an optimal team for a fantasy sports competition?
  • Production mix. What mix of products should we make to maximize profit?