Why your plan fits in Excel and not on the plant floor

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 same plan: it fits in Excel, not on the plant floorLine 1 only makes product A and Line 2 only makes product B. Each line has an 8 h shift. Today there are 10 h of A and 4 h of B. In Excel, 14 h fit in 16 h available. On the plant floor, Line 1 needs 10 h in an 8 h shift and Line 2 has 4 h free that it cannot use. You are 2 h short: you deliver late or pay overtime.It fits in Excel. Not on the plant floor.Line 1 only makes product A. Line 2 only makes product B.8 h shift per line. Today there are 10 h of A and 4 h of B.In ExcelLines 1 + 216 h availableProduct A · 10 hA · 10 hProduct B · 4 hB · 4 h14 h in 16 h available. It fits.On the plant floorLine 1Product A · 10 h in an 8 h shift: 2 h past the shiftA · 10 h2 h past the shiftLine 2Product B · 4 hB · 4 h4 h free that cannot make product A4 h freeEnd of shift (8 h)2 h short. You deliver late or pay overtime.Illustrative example. The same plan: it fits in Excel, not on the plant floorLine 1 only makes A. Line 2 only makes B. 8 h shift per line. Today: 10 h of A and 4 h of B. In Excel: 14 h in 16 h available. It fits. On the plant floor: Line 1 10 h, 2 h past the shift; Line 2 4 h free. 2 h short. You deliver late or pay overtime.It fits in Excel.Not on the plant floor.Line 1 only makes A. Line 2 only makes B.8 h shift per line.Today: 10 h of A and 4 h of B.In ExcelLines 1 + 2A · 10 hB · 4 h14 h in 16 h available. It fits.On the plant floorLine 1A · 10 h2 h past the shiftLine 2B · 4 h4 h freeEnd of shift (8 h)2 h short.You deliver late or pay overtime.Illustrative example.

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.

Book a free diagnostic here.