Designing an optimization model is difficult. This article explains common mathematical notation used to define optimization model formulations.
Page 29 of 35
Using the SciPy library, we find an optimal solution to Aryabhata's approximation of trigonometric functions using ratios of quadratic polynomials.
To compare optimization modelling in Excel and Python, we replicate a Python model then compare it with an equivalent Excel implementation.
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.
Minimize the number of racks to store all pallets in a warehouse, freeing space for other activities and allowing company growth.
We run optimization model cases 10 times faster, fully using the parallel capabilities of the CPU cores/threads in a modern computer.
This article replicates and extends a transportation optimization model for managing a COVID-19 vaccination plan in Hong Kong.
We estimate the speed improvement for optimization solvers in the 35 years from 1989 to 2024. The results may be surprising.
The selection of a better fantasy sports team can substantially improve performance. Excel plus OpenSolver can pick an optimal team.
Given available resources, what mix of products will maximize profit? We can answer to question using Excel and the Solver add-in.
We've collated links to dozens of websites about optimization modelling. The links are organized into several categories.
Job sequencing is a common problem. Excel Solver can help you make optimal job sequencing decisions to minimize cost.
