Shop-floor sequencing under changeover constraints
Context & constraint
The ERP sequenced production orders by due date alone. Each material or tooling changeover imposed a 45-to-90-minute setup that the scheduler did not model, so mathematically similar jobs were being scattered across the week. Two planners rewrote the sequence by hand in a spreadsheet twice daily, and the cost of a bad sequence only became visible in the next shift report.
Engineering intervention
Order extraction through the ERP REST API into a staging schema. A changeover cost matrix was learned from 26 months of historical production events — actual setup durations by material, tooling family and machine, rather than the standard times in the routing master. A constraint solver then minimizes total setup time subject to due dates, machine capability, operator certification and material availability.
A natural-language layer lets the planner state the day's real constraints in plain English — an absent operator, a late steel delivery, an expedited customer — and receive a revised sequence with the trade-off quantified. The accepted sequence is written back to the ERP with its justification attached to the production order.
Architecture notes
Solver runs on a 20-minute cadence and on demand. Every published sequence is versioned, so a supervisor can see which constraint changed and why the plan moved. Write-back is idempotent on the order revision, and the human planner retains override authority on any individual job.