03 · ERP, MES & FACTORY
Know When Spreadsheets Stop Scaling
ERP and MES are not signs that a company has become “professional.” They are control systems for specific coordination problems. Implemented too early, they freeze immature processes and create administration. Implemented too late, teams spend each week reconciling different versions of orders, inventory, WIP, quality and delivery status.
STAGE 01Startup / Early Operation
A small team can still coordinate through direct conversation and a controlled set of files.
Do first:Define item codes, BOM ownership, project stages and one source of truth. A full ERP may be premature while the process changes every week.
STAGE 02Scaling Across Projects
More customers, projects and employees create shared-resource, purchasing and delivery conflicts.
ERP starts earning its cost:Control order-to-cash, project budgets, procurement, inventory, capacity and financial commitments in one transaction model.
STAGE 03Factory / Multi-Line Operation
The plan exists in ERP, but supervisors still cannot see accurate WIP, downtime, genealogy or quality status from the shop floor.
MES becomes necessary:Control execution by work order, operation, machine, material lot, operator and quality checkpoint as production happens.
Signals That The Current System Is Already Costing You
These are diagnostic triggers, not universal industry benchmarks. The right threshold depends on product complexity, regulation and production model.
- 2+ manual re-entriesThe same order, BOM or material movement is typed into multiple files or systems.
- 3–5+ working daysTeams need several days to reconcile inventory, project cost or month-end operating data.
- <97–98% inventory accuracyThe system quantity cannot be trusted for purchasing or production release without a physical check.
- <85–90% schedule adherencePlanned completion dates repeatedly move because actual capacity, shortages and WIP are not visible together.
- Hours to trace a lot or serial numberQuality teams reconstruct genealogy from paper, chat messages and separate machine files.
- Next-day production visibilityDowntime, scrap and output are manually consolidated after the shift instead of supporting decisions during it.
ERP And MES Solve Different Layers
Decision layerERPMES
Primary questionWhat should the business buy, make, deliver and account for?
What is actually happening to this order, unit and operation now?
Core objectsCustomer orders, projects, BOMs, purchasing, inventory, capacity and cost.
Work orders, routing, WIP, machines, operators, parameters, defects and genealogy.
Time horizonDays, weeks, months and financial periods.
Shift, hour, cycle and event.
What improvesCommitment visibility, material planning, project margin and cross-department control.
Schedule execution, traceability, quality evidence, downtime response and real production status.
WHEN IT CREATES VALUE- Processes and master-data owners are defined.
- Management agrees which system owns each record.
- KPIs have operational definitions and accountable users.
- Deployment is phased around measurable business pain.
WHEN IT MAKES THINGS WORSE- Software is used to avoid deciding how the process should work.
- Every department demands its spreadsheet be copied into the new system.
- Bad BOM, routing and inventory data are migrated without cleanup.
- Go-live is measured by features installed instead of decisions improved.
What ERP/MES will not fix by itselfUnclear process ownership · Invalid master data · Unstable BOMs and routings · Weak production discipline · Incentives that reward local optimization · Management decisions made outside the system