Formulating logic conditions in linear programs can be difficult. This two-part article series explains how, using easy to follow steps.
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 estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
Crossword puzzles are a popular pastime. We design and build Mixed Integer Linear Programming models to compile crossword puzzles.
Sometimes we need more power to solve a model. This article describes how to solve a model using the CPLEX solver via the NEOS Server.