A mid-size electronics manufacturer came to us running production planning across a patchwork of spreadsheets, a decade-old inventory system, and phone calls between the planning office and the shop floor. Machine downtime was tracked manually, often a day after the fact, which meant recurring problems went unnoticed until they'd already cost weeks of output.
The problem beneath the problem
On the surface, the client asked for 'a better inventory system.' Once we mapped the actual production workflow, the real issue was a lack of shared, real-time visibility: planners didn't know machine status until the next shift briefing, procurement didn't know which components were actually running low until a line stopped, and maintenance had no structured way to flag recurring faults before they became full breakdowns.
- Machine downtime was logged on paper and entered into spreadsheets once per shift
- Inventory counts were reconciled manually every Friday, often a week behind actual stock levels
- Production schedules were built without visibility into real component availability
- Maintenance requests had no ticketing system, so recurring issues weren't tracked as patterns
What we built
We designed a custom manufacturing ERP centered on a live production dashboard, connected to shop-floor sensors for machine status and to a rebuilt inventory module tied directly to the bill of materials for each product line. Maintenance requests became structured tickets with a history, so recurring faults on the same machine were visible to planners before they escalated.
Real-time machine status changed planning behavior
The single highest-impact change was pushing machine status — running, idle, under maintenance, faulted — into a live dashboard visible to planners, not just the shop floor. Planners could reroute a batch to another line the moment a machine flagged an issue, instead of finding out at the next shift handover, which alone eliminated a large share of the downstream schedule slippage.
The results after six months
- 32% reduction in unplanned production downtime, measured against the prior two quarters
- Inventory discrepancies dropped from a weekly manual reconciliation to near-zero variance
- Maintenance response time to recurring faults improved by tracking patterns across tickets instead of treating each as isolated
- Production planners gained same-day visibility into component shortages instead of discovering them mid-run
Perhaps the most telling metric wasn't a percentage at all: the plant manager stopped starting weekly meetings by asking 'what happened this week' and started them by reviewing dashboard trends everyone had already seen. The system had become the shared source of truth it was meant to be.
Key takeaways
- The stated request ('better inventory') and the real bottleneck (visibility across teams) were different problems — mapping the actual workflow first mattered more than the initial ask
- Connecting shop-floor status to planning in real time had more impact than any single feature in the inventory module
- Structured maintenance tickets turned recurring faults into visible patterns instead of one-off incidents
- A single shared dashboard changed how teams communicated, not just what data they had access to
Conclusion
This engagement is a reminder that manufacturing ERP projects succeed or fail on visibility, not features. Giving planners, procurement and maintenance a shared, real-time view of the same shop floor did more for downtime than any individual reporting tool could have on its own.


