Capacity Planning: How AI Optimises Manufacturing Schedules
Lennard Kooy
·
6 min read
Mid-market manufacturers lose production hours every week to scheduling conflicts, unplanned changeovers, and capacity bottlenecks that spreadsheets cannot predict. Capacity planning with an AI layer inside your ERP models real constraints, generates optimised schedules, and flags conflicts before they reach the shop floor, keeping production lines running without dedicated planning teams.

Capacity planning is the process of matching production demand to available resources: machines, labour, materials, and time. For mid-market manufacturers, it is the difference between hitting delivery dates and explaining to customers why their order is late.
Most mid-market manufacturers plan capacity in spreadsheets or in the basic scheduling module of their ERP. Both approaches work until they do not. A rush order arrives, a machine goes down, a key operator calls in sick, and the carefully constructed schedule falls apart. Rebuilding it takes hours, and by the time the new schedule is ready, conditions have changed again.
This is not a scheduling problem. It is a constraint modelling problem. And spreadsheets are not built to solve it.
The Real Cost of Poor Capacity Planning
A mid-market manufacturer running three to five production lines faces a set of interconnected scheduling challenges.
Changeover waste
Every time a production line switches from one product to another, there is setup time, calibration, and material changeover. Poor scheduling means more changeovers than necessary. A production line that should achieve 75-80% overall equipment effectiveness (OEE) drops to 60-65% because changeovers are not optimised.
Delivery failures
When the schedule does not reflect real capacity constraints, orders are promised on dates the factory cannot meet. The result is late deliveries, expediting costs, and damaged customer relationships.
Labour inefficiency
Operators are assigned to lines without visibility into the full picture. Overtime is scheduled reactively when a bottleneck appears, rather than planned proactively based on known constraints.
Invisible bottlenecks
The real constraints in a manufacturing operation are often not where managers think they are. A finishing station that limits throughput for an entire product family. A shared quality testing bay that creates queues. Without modelling these constraints explicitly, scheduling decisions are made against an idealised version of the factory that does not exist.
How the Industry Currently Approaches Capacity Planning
Mid-market manufacturers typically use one of three approaches.
Spreadsheet-based scheduling
The production planner exports orders from the ERP, builds a Gantt chart or scheduling grid in Excel, and assigns orders to lines and shifts manually. This works when volume is predictable and the product mix is stable. It breaks when rush orders arrive or when capacity changes.
ERP scheduling modules
Most ERPs include basic finite or infinite capacity scheduling. These modules assign operations to work centres based on routing times and available hours. They handle the mechanics of scheduling but struggle with the nuances: sequence-dependent changeover times, shared resources, operator skill constraints, and multi-level dependencies.
Standalone advanced planning systems
Enterprise-grade Advanced Planning and Scheduling (APS) systems offer constraint-based scheduling with detailed modelling. These are powerful, but they require significant investment in implementation, integration, and ongoing maintenance. For a mid-market manufacturer, the cost and complexity often exceed the planning team's capacity to manage.
How an AI Layer Optimises Capacity Planning Inside Your ERP
An AI layer that works inside your existing ERP changes capacity planning from a periodic, export-and-calculate exercise to a continuous, constraint-aware process.
Real constraint modelling
The AI layer builds a constraint model directly from your ERP data: machine availability, operator shift patterns, sequence-dependent changeover times, material availability dates, and shared resource dependencies. This model reflects the factory as it actually operates.
Schedule optimisation
Using the constraint model and current order book, the AI layer generates production schedules that minimise changeover time, balance load across lines, and respect material and labour availability. When a new order arrives or a constraint changes, the schedule is recalculated in minutes rather than hours.
Conflict detection
Before publishing a schedule, the AI layer identifies conflicts: orders that cannot be completed by the promised date given current constraints, material shortages that will halt a production run, or labour gaps on specific shifts. These conflicts are flagged for the planner before they become shop floor problems.
What-if scenarios
The planner can test scenarios: what if we add overtime on line 3 this week? What if we defer order X by two days to avoid a changeover? What if supplier Y delivers three days late? Each scenario is evaluated in minutes against the full constraint model.
What This Looks Like in Practice
A production planner at a mid-market manufacturer producing metal components opens the ERP on Monday morning. The AI layer has generated a draft schedule for the week based on the current order book, machine availability, and confirmed material deliveries.
The planner sees three flagged items:
A rush order received Friday afternoon that conflicts with an existing job on line 2. The AI layer suggests two alternatives: moving the existing job to line 4 or deferring the rush order by one day
A material delivery delay from a key supplier that will leave line 3 idle for four hours on Wednesday. The AI layer has already shifted a shorter job forward to fill the gap
An operator absence on the Thursday night shift that reduces capacity on line 1. The schedule has been adjusted to front-load line 1 output earlier in the week
The planner reviews each flag, confirms two suggestions, modifies the third, and publishes the schedule by 9 AM.
Trade-offs and Risks
Capacity planning through an AI layer is not the right fit for every manufacturer:
Routing and master data accuracy is essential. The constraint model is only as good as the routing times, changeover matrices, and resource definitions in your ERP.
Very basic operations may not benefit. If you run a single production line with a stable product mix and predictable demand, a spreadsheet may genuinely be sufficient.
Planner adoption is critical. The shift from "I build the schedule myself" to "I review and adjust a generated schedule" requires trust in the constraint model.
Integration scope matters. The AI layer needs access to orders, routings, BOM data, machine status, and labour schedules.
Next Step
If your production planners spend hours rebuilding schedules every week and you want to see constraint-based capacity planning with your own ERP data, we can demonstrate the process using your actual orders and routings.
See it work with your data. Book a demo with Lleverage.