To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
We present an example of project crashing using an optimization model to help the project manager decide what to do.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
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.
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?