We experiment with the new Python in Excel feature, building and solving a linear program using the Python SciPy library.
Page 11 of 35
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.
Job sequencing is a common problem. Excel Solver can help you make optimal job sequencing decisions to minimize cost.
We run optimization model cases 10 times faster, fully using the parallel capabilities of the CPU cores/threads in a modern computer.
Academic research papers can be tremendously valuable. But only if they are complete. So, academics, please publish your data and code.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
This series explores optimization of a "picking warehouse" by improving the warehouse design and efficiency of the picking process.
A new role mining model is claimed to be more tractable and practical. We test that assertion using constraint programming and MILP.
We describe an example of how to represent price breaks in a linear programming model, built in Excel using Solver or OpenSolver.
Minimize the number of racks to store all pallets in a warehouse, freeing space for other activities and allowing company growth.
We've collated many interesting optimization models in our GitHub repository. The focus is on Excel and Python models.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
This series of 13 articles compares Python libraries Pyomo, PuLP, OR-Tools, Gekko, CVXPY, and SciPy for building a linear programming model.