Manufacturers are under pressure to improve productivity, control costs and respond to changing customer demands, often while dealing with skills shortages, supply chain pressures and tighter margins.
That places more pressure on the systems already supporting day-to-day operations. ERP sits at the centre of many of those challenges, supporting everything from purchasing and stock through to production, planning, costing and reporting.
When the ERP no longer reflects how your business operates, the impact starts to show in everyday work. Reporting takes longer, spreadsheets fill gaps, planning moves outside the system and different areas develop their own processes.
This article looks at the key warning signs that your manufacturing ERP may no longer fit the business, what they can reveal and how to decide what needs to change.
How do you know if your manufacturing ERP no longer fits?
A manufacturing ERP may no longer fit when teams increasingly work outside the system, reporting becomes difficult to trust, the business has outgrown the way the ERP was originally set up, planning relies on disconnected tools or the system makes future improvements harder to deliver.
These are the five signs to look for:
| Warning sign | What you might see |
|---|---|
| 1. Spreadsheets have become part of your operating system | Spreadsheets, manual workarounds and separate records have become part of everyday operations |
| 2. Reporting and data take too much effort to trust | Teams spend too long extracting, checking and reconciling information |
| 3. The business has changed, but the ERP hasn’t kept pace | New products, sites, operating models or acquisitions place different demands on systems and processes |
| 4. Planning and operational processes increasingly rely on other systems | Teams depend on separate tools, manual data transfers and disconnected processes |
| 5. The ERP is making future improvement harder | Automation, new processes and digital initiatives are difficult to introduce |
1. Spreadsheets have become part of your operating system
There’s nothing unusual about using spreadsheets in manufacturing. They’re flexible, familiar and useful for analysis.
They become more concerning when they start carrying important operational processes because the ERP can’t provide the information, functionality or flexibility people need.
Production schedules may be maintained separately. Finance may export data before rebuilding management reports. Stock positions need manual reconciliation. Forecasting, costing or purchasing information can sit in files owned by individual employees.
These workarounds add administration, create duplicate data and make important processes more dependent on individual knowledge. Over time, the spreadsheet becomes part of the process rather than a temporary solution.
What to look for:
- ERP data being repeatedly exported into Excel before it can be used
- Production plans or schedules maintained outside the system
- Manual reconciliation of stock, costs or financial information
- Important calculations held in locally maintained spreadsheets
- Multiple teams keeping different versions of the same information
- Business-critical spreadsheets understood by only one or two people
Case study | Manual Processes & Complex Spreadsheets | FINSBURY FOOD GROUP
Growth through acquisition had taken Finsbury Food Group to eight UK manufacturing sites, each with its own systems and ways of working. Manual processes and complex spreadsheets had become part of the operating environment.
Optimum supported Finsbury through its ERP transformation, helping introduce more standardised processes, improve data accuracy and reduce reliance on spreadsheets.
The programme also strengthened visibility across its end-to-end supply chain.
KEY INSIGHT
Spreadsheet use isn’t the problem by itself. Look at why people need the spreadsheet. If it exists because the ERP or underlying process can’t provide what the team needs, it’s worth investigating further.
2. Reporting & data take too much effort to trust
Manufacturing leaders need reliable information across margin, costs, inventory, production, purchasing, customer service and supply chain performance.
It becomes a concern when producing that information requires several extracts, manual calculations and repeated checking before anyone feels confident using it.
You may see finance and operations working from different figures. Reports may arrive after the point at which they would have been most useful. Managers can end up spending more time validating information than analysing what it means.
What to look for:
- Several reports needed to answer one straightforward management question
- Departments presenting different figures for the same KPI
- Heavy manual manipulation before reports reach leadership
- Month-end processes involving repeated reconciliations and adjustments
- Limited real-time visibility of stock, production or costs
- Recurring questions about whether the system data is right
Case study | Business Intelligence & Reporting | PETAINER
Petainer’s reporting relied on multiple data sources and labour-intensive processes across Excel, PowerPoint, Word and email. Monthly management information wasn’t available until working day five or six, while real-time operational reporting was extremely difficult.
Optimum helped introduce a new business intelligence environment and data warehouse, alongside improvements to the underlying data and processes.
The result was real-time reporting, automated monthly management information and a single trusted source of data, allowing teams to spend more time analysing performance rather than collating information.
KEY INSIGHT
Weak reporting can come from the ERP, but data quality and ownership are just as important. A technically capable reporting tool can’t compensate for inconsistent or unreliable underlying information.
3. The business has changed, but the ERP hasn’t kept pace
Manufacturing businesses are constantly evolving. A system introduced several years ago may now be supporting more products, more customers, additional sites, international operations or a completely different manufacturing model.
Acquisitions can add further systems and processes. New sales channels create different integration requirements. Outsourcing changes supply chain processes. Product customisation places greater demands on planning, costing and configuration.
This makes it important to review the ERP alongside the wider business model, rather than treating the system as a fixed part of the operation.
What to look for:
- Significant changes to the manufacturing or supply chain model
- New sites or acquisitions operating differently from the wider group
- Processes that no longer reflect how the business works
- Increasing customisation or workarounds to support new requirements
- Future products, markets or operating models that are difficult to accommodate
Case study | Business Change | FERN PLASTIC PRODUCTS
Fern Plastic Products changed the way it operated, moving from a make-to-order model towards a more supply chain-driven approach. Its systems and processes needed to be realigned to support that change.
Optimum reviewed business methods, data collection and reporting before re-engineering and optimising key areas including supply chain management, stock management and production processes.
Customer delivery performance increased from 75% to 98%, supplier delivery performance improved from 75% to 95%, and additional transport costs were reduced by 75%.
KEY INSIGHT
A change in how the business operates doesn’t necessarily mean a new ERP is required. Fern shows the value of realigning an existing system and the processes around it when the underlying platform can still support the business.
4. Planning and operational processes increasingly rely on other systems
If planners build the plan somewhere else and then tell the ERP what they decided, the system is recording production rather than planning it.
Planning tends to get harder as manufacturers add products, sites and supply chain dependencies. Demand changes. Raw material constraints need to be considered. Production capacity has to be balanced. Customer lead times tighten. Bills of material and routings become more involved.
Some ERP platforms manage these requirements well. In other businesses, planning teams rely heavily on spreadsheets or specialist applications.
The important part is making sure that approach is deliberate and that information moves reliably between systems.
What to look for:
- Production or supply chain planning happens largely outside the ERP
- Data is regularly transferred manually between systems
- The same information is maintained in more than one application
- Teams rely on workarounds where integrations are weak
- Ownership of important data isn’t clear
Case study | Supply Chain Planning | CEDO
During Cedo’s multi-site ERP programme, detailed analysis identified advanced supply chain planning requirements that weren’t best served by IFS alone.
Optimum helped define the future operating model and introduced a specialist supply chain planning solution alongside the core ERP. The two platforms were integrated as part of the wider transformation programme.
Cedo gained stronger planning capability, more consistent processes and improved operational visibility across its European sites.
KEY INSIGHT
A strong technology landscape doesn’t require a single system to do everything. Each application needs a clear purpose and should work effectively with the rest of the environment.
5. Your ERP is making future improvement harder
An ERP should be able to evolve as manufacturing requirements change. New products are introduced. Customers ask for different information. Reporting needs develop. Teams identify opportunities to automate manual processes or improve how work moves through the business.
When relatively straightforward improvements become difficult to introduce, the ERP itself can start slowing change. This becomes increasingly important as manufacturers invest more heavily in automation, analytics and AI.
Make UK reports that 65% of manufacturers plan major investment in digitalisation and AI. Its research also found that only 2% of manufacturers say AI is widely embedded across their operations. Those technologies ultimately depend on good underlying systems, processes and data.
AI and automation are hard to deploy when product information is inconsistent, supplier data sits in several places, production activity is not captured reliably, or reporting depends on manual manipulation.
What to look for:
- New requirements regularly need bespoke development or workarounds
- Simple process improvements are difficult to introduce
- Manual tasks remain because automation feels too difficult
- ERP changes are repeatedly delayed because of cost or risk
- Data or integration problems are restricting AI or other digital initiatives
Case study | ERP Data Optimisation | MMP UK
MMP UK needed its ERP to stay aligned with evolving procedures and growing customer demands. Production data was captured manually, raw material supply lacked visibility, and paper-based purchase requisitioning slowed traceability across sites.
Optimum supported MMP as a multi-functional ERP partner over several years. The work covered real-time shop-floor data capture by RF scanning across goods receipt, raw material transfer, point-of-use production issue, finished goods receipt and vehicle loading; production planning able to absorb late design and quantity changes; raw material scheduling with consignment stocking and just-in-time purchasing; automated data exchange between Mayr-Melnhof sites and key customers; and a multi-site purchase requisitioning solution.
Individual business processes have improved by up to 80% in time and cost, alongside better data quality and faster access to real-time information for decision-making.
KEY INSIGHT
Future improvement depends on the foundations already in place. If your ERP, processes and data are difficult to change or trust, automation, analytics and AI will be harder to implement and less likely to deliver the expected value.
How to assess whether your manufacturing ERP still fits
Understanding whether your ERP still fits means looking beyond the software itself. Issues can come from poor data, inefficient processes, weak integration or inconsistent ways of working, as well as limitations in the ERP.
A useful review should look at how the business operates today, where teams are relying on workarounds and what the organisation will need from its systems over the next few years. The aim is to establish what should be improved, what should be kept and whether optimisation, integration or replacement is the right next step.
1. Business Direction
Can the current technology support planned products, markets, acquisitions, sites and changes to the operating model?
2. Manufacturing Processes
Where are teams relying on manual work, duplication or workarounds? Are important processes more complicated than they need to be?
3. Data & Reporting
Can leadership access accurate financial and operational information without excessive checking and manipulation?
4. People & System Use
Do employees understand and trust the system? Are they making effective use of the functionality available?
5. Integration
Do systems exchange information effectively, and is ownership of important data clear?
6. Technology & Risk
Can the platform be supported, maintained and developed at a reasonable cost? Will it support future digital requirements?
The aim is to establish what should be kept, where the real gaps sit and what type of change will deliver the most value.
What a good manufacturing ERP looks like
A strong ERP environment should make it easier to run the business, giving teams reliable information, connected processes and the right tools for the job.
For most mid-sized manufacturers, that means having a clear core ERP supported by specialist systems where they add real value, all working together around consistent data and well-defined processes.
In practice, that should provide:
- Clear ownership of data
- Reliable stock and costing information
- Strong financial and operational reporting
- Production and supply chain planning matched to the real requirement
- Consistent core processes across sites
- Deliberate integration with specialist manufacturing applications
- Less reliance on manual data entry and reconciliation
- Systems people understand and trust
- A platform capable of supporting future digital investment
The aim isn’t to reduce the number of systems at all costs. It’s to make sure each one has a clear role, data moves reliably between them and the overall environment supports how the business needs to operate.
Does your manufacturing ERP need replacing?
Problems with a manufacturing ERP can come from the system itself, but they can also result from poor data, inefficient processes, weak integration, configuration or low user adoption.
The right response depends on what is causing the problem.
| What you’re finding | Where to look next |
|---|---|
| Capable ERP, but inefficient processes or reporting | Optimise |
| Poor data and inconsistent ownership | Fix the foundations |
| A specialist requirement the ERP can’t handle effectively | Integrate |
| Existing functionality isn’t being used | Configure and train |
| Unsupported technology or fundamental capability gaps | Upgrade or replace |
| The system can’t support future scale or operating models | Review replacement options |
Understanding the cause before deciding where to invest can help avoid unnecessary cost and disruption.
Summary: What should manufacturers do if their ERP no longer fits?
ERP problems can come from the system itself, but they can also point to weaknesses in data, processes, integration or how the technology is being used.
Understanding the cause should come before deciding what to change. For some manufacturers, the existing ERP will still have plenty of value and may need better processes, data, configuration or integration around it. For others, the gap between what the business needs and what the system can deliver will have become too large.
An independent review gives leadership the evidence to decide whether to optimise what is already there, introduce additional capability or start planning for ERP replacement.
Optimum PPS – Independent ERP support for manufacturing and engineering businesses
Optimum PPS has worked across ERP selection, implementation, optimisation and digital transformation for more than 20 years. Our experience includes:
Our manufacturing and engineering clients include organisations such as Finsbury Food Group, Cedo, milkrite | InterPuls, MMP, Trox, AG Paving & Building Products, WGM Engineering and Noble Foods.
Optimum is independent and vendor-agnostic. We don’t sell ERP software, so our role is to understand the business requirement, establish what is causing the current issues and help leadership decide the most appropriate route forward.
Our ERP Health Check looks across people, processes and systems to identify where problems sit, where more value can be gained from existing technology and where wider change may be needed.
We can help you see where your ERP currently stands, the risks worth attention now, and the practical next steps to move forward with confidence.
FAQs
What are the warning signs that a manufacturing ERP no longer fits?
Common warning signs include growing reliance on spreadsheets and workarounds, difficult reporting, systems that no longer reflect how the business operates, fragmented planning and integration, and increasing difficulty introducing improvements. These issues should prompt closer investigation rather than an immediate decision to replace the system.
Does an outdated ERP always need replacing?
An older ERP can still support a manufacturing business if it remains capable, maintainable and able to meet current and future requirements. In many cases, better processes, data, configuration, integration or training can deliver more value from the existing system.
What should a manufacturing ERP review include?
A manufacturing ERP review should assess business direction, processes, data and reporting, people, integrations and the underlying technology. It should also consider what the organisation will need from its systems over the next few years, rather than focusing only on current problems.
Can an existing ERP support automation and AI?
Yes, if the underlying platform, data and processes can support it. Reliable data, consistent processes and effective integration are important foundations for automation, analytics and AI. Where those foundations are weak, they may need attention before wider digital investment can deliver its full value.