Page 1 of 5
Why does my model find different solutions? Some solutions are better than others – how can that be true? How do I find the overall best solution?
Allocating people to teams is a task common in both sport and business. We allocate 32 people to 4 teams that are as balanced as possible.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
Given available stock of wire and a list of pieces required, what is the best way to cut the stock to fulfil demand while minimizing waste?
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
Designing an optimization model is difficult. This article explains common mathematical notation used to define optimization model formulations.
This article series implements a staff scheduling model in Excel using OpenSolver, then in Python using Pyomo.