Tuesday, 10:40 a.m. The production manager wipes three lines off the whiteboard. The biggest customer pulled an order forward, a component promised for Monday never arrived, and press 2 has been down since eight. He rewrites the week in marker pen, photographs it with his phone and posts it to the shop floor WhatsApp group.
At 11:15, a salesperson promises another customer delivery on the 28th. He based it on the schedule sent out on Friday. That schedule stopped existing 35 minutes ago.
This is not a competence problem. The production manager is doing exactly the right thing with the tool he has. The problem is that his tool is connected to nothing.
Key points
- A production schedule is only reliable if it connects four things: demand, real stock, bills of material and work centre capacity.
- A spreadsheet connects none of them automatically. It is accurate the moment it is printed and wrong at the first disruption.
- The Master Production Schedule (MPS) is what links what you intend to sell with what you are able to produce.
- The real gain is not the schedule itself: it is that the date promised to the customer stops being an estimate and becomes a calculation.
Why a spreadsheet schedule always drifts
A planning file is not wrong the day you build it. It becomes wrong because it is disconnected from the events that invalidate it. Four mechanisms show up in every manufacturer we work with:
- Stock moves, the schedule doesn't. An unplanned consumption on Tuesday reaches nothing.
- Every reschedule is manual. Pushing one order out by three days means recalculating every component and every downstream order by hand.
- Only one reliable copy exists, and it is in one person's head. Everyone else works from a stale version.
- The customer promise is made elsewhere. Sales has no view of real load, so they promise what suits them and the shop floor arbitrates afterwards.
The four things a schedule has to connect
A credible production schedule continuously links four data sets. Connect only two and it is no longer a schedule, it is a wish:
- Demand: firm orders, sales forecasts, and safety stock to rebuild.
- Real stock: quantities on hand, quantities already reserved by other orders, and quantities inbound.
- Bills of material and lead times: what it takes to build, at every level, with the procurement lead time of each component and the manufacturing lead time of each sub-assembly.
- Capacity: how many hours each work centre can actually produce, accounting for efficiency and setup times.
What is a Master Production Schedule?
The Master Production Schedule is the table that links sales to the shop floor. For each finished product and each period, it shows forecast demand, the resulting projected stock, and the quantity to launch into production to avoid running out.
Its value is not predicting the future. It is making the gap between what you want to sell and what you can produce visible early enough to arbitrate. An MPS that refreshes itself every morning is worth ten planning meetings.
How Odoo chains demand, components and capacity
In Odoo, the chain runs unbroken from sales order to the work order at the machine. On a typical industrial project at Prism Technology, we switch on:
- Master production scheduling to steer finished-goods families over a horizon of weeks to months.
- Reordering rules and automated replenishment: Odoo computes net requirements from multi-level bills of material and proposes the matching purchase and manufacturing orders.
- Lead times everywhere: vendor lead time on the product, manufacturing lead time on the routing, configurable safety margins. That is what lets the system work a start date back from a delivery date.
- Work orders per work centre, with setup time, operation time and work centre efficiency, so load is expressed in hours rather than good intentions.
- The planning view showing load per work centre, where moving an order shows its downstream impact immediately.
- Missing component alerts on the manufacturing order, before release rather than in front of the machine.
- Subcontracting inside the same chain, lead times included.
The trap: planning at infinite capacity
This is the most common go-live mistake. If you enter no operation times, no efficiency and no working calendars, the system will cheerfully schedule forty hours of work on a work centre that has thirty-five, and you will conclude that "the ERP cannot plan".
Schedule quality does not depend on the algorithm. It depends on three data points nobody enjoys entering: routing times, setup times and the real team calendar. Getting them 80 % right is enough to make a schedule usable. Waiting for 100 % guarantees you never start.
When the customer promise becomes a calculation
The real shift is not visible from the shop floor, it is visible from the sales desk. When load, stock and lead times live in one place, the delivery date offered to the customer comes out of the system instead of out of optimism.
Illustrative example, typical of our client base: an 80-person industrial SME running around fifty manufacturing orders a week.
- Monday's planning meeting drops from ninety minutes to twenty, because you arbitrate instead of rebuilding.
- Emergency reschedules become visible downstream immediately, instead of being discovered by the customer.
- Missing components are caught at order release, not when the operator opens the bin.
Frequently asked questions
Do you need an APS to plan properly?
Rarely, and never as a first step. Advanced planning tools earn their place when you face hard combinatorial constraints: sequencing by colour or tooling, expensive changeovers, oven or curing constraints. For most industrial SMEs, what Odoo does natively is enough, provided routings are filled in.
Can you plan without capturing shop floor times?
You can plan on theoretical routing times, yes. But with no feedback from reality, you will never learn that your routing time is 30 % off. Capturing actual times, even in the simplified tablet view, is what makes the schedule progressively accurate.
How long does it take to set up reliable planning?
Configuration takes days. The long part is cleaning up bills of material and routings, which are rarely up to date at the start. That is the work to plan for, not the software.
Take action
Prism Technology is an official Odoo partner in Belgium, based in Walloon Brabant, focused on manufacturing, inventory and supply chain. Bring this week's schedule: in 30 minutes we show you what it becomes once it is connected to your real stock and real capacity.
👉 Book your 30-minute demo — Contact us
