Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
Optimal facility location is a common & difficult decision that organizations need to make. We build a location optimization model in Excel.
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.
We compare a linear programming model written using Julia/JuMP with the same model written using Python/Pyomo.
Job sequencing is a common problem. Excel Solver can help managers make optimal job sequencing decisions to minimize cost.
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.