i-nth logo
Optimization models in Excel
26 February 2021

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

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?

Full article: Optimization models in Excel and Python