Page 1 of 5
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
We minimize the number of racks required to accommodate all pallets in a warehouse, freeing space for other activities and allowing company growth.
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've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
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?