Still planning production with spreadsheets? It could be a costly mistake

Be honest - how does production planning actually work in your business? For a lot of UK manufacturing SMEs, the answer involves a spreadsheet that only one person really understands, a whiteboard that hasn't been updated in days, and a planning process ‘stored’ in the heads of a handful of key people. 

It works. Most of the time, anyway. But most of the time isn't the same as being in control. And the gap between those two things has a cost that rarely shows up clearly on a P&L. 

The hidden cost of spreadsheet-based production planning

The costs of manual production planning are mostly invisible, which is precisely why they tend to persist. They don't appear as a line item but just sit and accumulate quietly across the business: 

• Late orders - not because the team isn't working hard, but because no one had a complete picture of capacity, materials and schedules in one place at the right time.
• Over-purchasing - buying components as a buffer against uncertainty, because the alternative (running short) is worse. Cash is tied up in stock that isn't needed yet.
• Reactive scheduling - jobs re-prioritised on the fly when something goes wrong, with a ripple effect across the rest of the production plan that takes hours to untangle.
• Key-person dependency - if the person who built the planning spreadsheet is off sick or leaves, so does the institutional knowledge baked into it.
• Reporting that lags reality - by the time management has a clear picture of where production stands, the situation has already moved on. 

None of this is unusual. It's the operational reality for a significant proportion of UK manufacturing SMEs. But it is a choice and it's one that becomes harder to justify as margins tighten and customers expect more. 

What changes with MRP planning software 

A material requirements planning system doesn't replace the experience of your team. What it does is give them something far better to work with than a spreadsheet: a live, connected view of everything that affects the production plan. 

In practice, that means: 

• Your sales orders, stock levels, open purchase orders and BOMs are all connected. The system automatically knows what needs to be made, what materials are available and what needs to be ordered, all in real time.
• Production schedules are built on data, not assumptions. When something changes - a new order, a delayed component, a capacity constraint - the plan updates and the impact is immediately visible.
• Works orders are generated from the plan and tracked through to completion. Progress on the shop floor is visible from anywhere in the business, without anyone having to chase for updates.
• Purchasing is driven by actual demand. No more over-ordering as a precaution and the MRP engine calculates what's needed and when, based on live information rather than gut feel 

The result isn't just a tidier planning process. It's a fundamentally different level of control — one where problems surface early enough to do something about them, rather than after a delivery has already been missed. 

'But our business is too complex for a standard system' 

We speak to SME manufacturers every single day and this is probably the most common objections to MRP software we hear.  And it’s usually the businesses with the most complex, bespoke production environments that need it most. Make-to-order businesses. Multi-level BOMs. Long and variable lead times. Frequent engineering changes. 

123Insight is built precisely for this kind of manufacturing environment. Flexible MRP, configurable routings, multi-level BOM management, and engineer-to-order support are core to the system, not add-ons. The flexibility isn't a feature list item. It's the reason manufacturers in complex production environments choose it. 

The switch is less disruptive than you think 

The other common hesitation is implementation. There is an assumption that moving to MRP software means months of disruption, expensive consultancy, and a difficult go-live. 

Yet most 123Insight customers are live within weeks. The data import toolkit handles the migration of existing product and BOM data, implementation is structured and supported by a UK-based team, and training is included. Manufacturers consistently report that the disruption of implementation is far smaller than the ongoing cost of the manual processes it replaces. 

We opened with a question and we’ll finish with one too. 

Is production planning is the thing in your business that relies most heavily on the right people being in the right place with the right spreadsheet open?  

It the answer is ‘yes’ then it's worth finding out what a proper manufacturing production schedule system looks like in practice.