In manufacturing, the spreadsheet has always been the office worker’s right hand. Apart from pen and paper, it’s the most flexible, reasonably smart tool they’ve had at hand. It’s endlessly malleable: any situation can be represented in an Excel table very easily.
However, as operations get more complex, Excel tends to fall short. Specifically for production scheduling, it calculates with infinite capacity: it adds up hours without seeing which line can make each product or how long each changeover takes. The result is scenarios that don’t reflect the reality of the plant.
What do you do here?
The chart shows how reality differs from what was calculated. This forces the people responsible for planning to look for other options or keep changing their spreadsheet so it reflects how production really runs. The gap between what was calculated and what actually happens grows every day.
In this case, the plant would deliver late, or it has to run overtime to deliver on time. The decision is driven by the plant’s objective: hitting OTIF at all costs, reducing costs, or asking production to improve its changeovers.
Constraints only tell you which plans are actually possible.
How Lucie solves it: from spreadsheet to decision
With Lucie, the decision is optimized immediately. With an ERP connection, the planner gets live feedback from the plant: available raw materials, up-to-date inventory and the status of production. With this live information, the team can decide immediately, with all the information, what to do: reoptimizing becomes a decision, not operational work. AI agents, together with our advanced optimization models, generate real plant scenarios.