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