← All work
Optimizing production and planning with data
Data-driven optimization of selected production and planning processes at a large manufacturing company.
The challenge
Decisions resting on spreadsheets and individual experience.
Part of planning rested on spreadsheets and individual experience. They were looking for a way to back the same decisions with data and compute them repeatably.
Our approach
Build a calculation that can be repeated.
We focused on specific processes, framed them as an optimization problem, and built a calculation in Python that produces consistent, repeatable outputs.
✓ Processes framed as an optimization problem
✓ Calculation in Python
✓ Repeatable, consistent outputs
✓ Inputs for decision-making
The outcome
A repeatable calculation instead of guesswork.
Optimization problem
PROCESSES FRAMED
Python
REPEATABLE CALCULATION
Consistent
DECISION INPUTS