top of page
Smartic Corporation
Search

Industry 4.0 vs. ERP and Excel: The Invisible Money Slipping Through the Cracks

Jul 9
4 min read

The paradox: You invested in an ERP, yet you still run your business with Excel


Your company has probably invested hundreds of thousands of dollars in SAP, Oracle, Dynamics, or a local ERP system. Yet when Monday comes and you need to know how much was produced during Saturday’s second shift, someone still opens an Excel spreadsheet. When the Plant Manager presents the report to the executive committee, the data is already seven days old. And when the CFO closes the month, they discover margin leaks that no one was able to explain in real time.


Your ERP is not the problem. The problem lies in your data architecture: ERP systems were never designed to see what is happening on the shop floor.


Why your ERP cannot see the factory floor


An ERP is a transactional system of record: it handles orders, invoices, inventory, payroll, and accounting. Its unit of time is the transaction—minutes, hours, or days. A factory operates on a completely different timescale: seconds. A 90-second micro-stop on a filling machine will not show up in any ERP module. But if it happens 40 times per shift, that adds up to 60 minutes of lost capacity that no one accounts for.


The layer that connects ERP systems to the shop floor is called MES (Manufacturing Execution System). It draws data from sensors, PLCs, and IoT platforms. Gartner describes this layer as the “system of record” for manufacturing operations. Without it, the ERP receives manually processed data that is delayed and potentially biased.


Where the “invisible money” is hiding


In its Digital Factories 2020 study, PwC identifies five sources of loss that ERP systems fail to capture:


  1. Unrecorded micro-stops: 5%–15% of capacity lost, according to ARC Advisory Group.

  2. Underreported scrap: Out-of-spec products that are mixed in or reworked without traceability.

  3. Excess energy consumption: Equipment left on standby, undetected spikes, and degraded power factor.

  4. Shift time lost to start-ups and stoppages: Unproductive time treated as “normal” in spreadsheets.

  5. Physical inventory vs. system discrepancies: Variances that are adjusted at month-end, erasing the audit trail.


Want to find out which of these five sources is costing your factory the most? In 30 minutes, we can conduct a visual quick assessment of your main production line and show you where we believe the largest loss is occurring. Request an assessment.


The total cost: 11% of revenue, according to Siemens


Siemens’ The True Cost of Downtime 2024 report estimates that Global 500 companies lose 11% of their revenue to unplanned downtime—up from 8% in 2019. If your company generates COP 50 billion in annual revenue, applying that figure proportionally would mean losses of up to COP 5.5 billion that your ERP is not showing you.


And that is downtime alone. Add scrap, energy costs, and inventory discrepancies, and the figure grows.


ERP + MES + IoT: The architecture that works


McKinsey recommends a three-layer architecture in its Industry 4.0 reports:

Layer

Function

Time unit

ERP

Transactions, finance, planning

Hours / days

MES

Execution, OEE, quality, traceability

Minutes

IoT / SCADA / PLC

Physical equipment variables

Seconds

When all three layers communicate with one another, data flows from the machine sensor all the way to the CFO’s income statement—with no one having to copy and paste anything into Excel.


Are all three layers connected in your company today? In a 20-minute exploratory call, we can map your current data flow and show you where the gaps are. Schedule a call.


The Monday Excel report problem


Here is a question for your executive committee: How many person-hours do your plant, quality, and administrative teams spend each week building manual reports that are already obsolete by Tuesday? At factories with 100–300 employees, that figure typically ranges from 20 to 60 hours per week. At average wage levels, that amounts to COP 60–150 million a year spent producing reports that no one should have to put together manually anymore.


What changes when you stop running your factory on Excel


Factories recognized by the WEF’s Global Lighthouse Network report performance improvements that are difficult to achieve with an ERP-plus-Excel architecture: productivity gains of 50% or more, defect reductions of over 80%, a 40% boost in workforce productivity, and a 48% reduction in lead time. Not because their teams are more talented, but because they make decisions using data that is 30 seconds old—not seven days old.


Conclusion: ERP is not the villain—Excel is


Your ERP does its intended job well. The problem is expecting it to handle tasks that require a real-time operational data layer. The solution is not to replace your ERP; it is to complement it with the MES/IoT layer it has been missing from day one. When that happens, the “invisible money” becomes visible—and turns into recoverable margin.


Want to see how much your factory could recover with this architecture? In a 30-minute demo, we will show you a real-world case from a company comparable to yours. Schedule a demo.

References and sources


Article prepared for Smartic — Industry 4.0, industrial IoT, and predictive maintenance. Want to see Smartic in action at your factory? Schedule a 30-minute demo.

 
 
 

Comments


© 2022 by Smartic Corporation

bottom of page