
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?