Despite decades of manufacturing technology advancements, pen and paper, spreadsheets, whiteboards, and other manual processes are still common on shop floors.
In fact, research from IoT Analytics found that 54% of small and medium-sized manufacturing plants use a combination of pen and paper and spreadsheets as their informal Manufacturing Execution System (MES).
Why?
It is usually not because manufacturers believe spreadsheets are the best way to run production. Manual processes often remain in place because they are familiar, inexpensive, flexible, and deeply embedded in how people work.
The problem comes when the operation outgrows them.
As production becomes more complex, manufacturers need faster access to accurate information about jobs, labor, machines, materials, quality, and work in progress. That’s where spreadsheets and paper begin to create an execution gap between what the ERP says should be happening and what is actually happening on the shop floor.
A Manufacturing Execution System (MES) is designed to close that gap.
Why Are Manufacturers Still Using Spreadsheets and Paper?
Manufacturers rarely decide one day that spreadsheets should become their shop floor management system.
It usually happens gradually.
Someone creates a spreadsheet to track production. Another department builds one for scheduling. Operators record information on paper travelers. Supervisors develop their own processes for tracking downtime or work in progress.
Each solution solves an immediate problem.
Over time, however, those temporary solutions become part of the company’s production process.
There are several reasons they are difficult to replace.
1. They’re Familiar
Paper and spreadsheets require little introduction.
Operators already know how to complete a traveler. Supervisors know how to update an Excel spreadsheet. Managers know where to look for the reports they’ve used for years.
Moving to a new manufacturing system means changing established processes, and change on the shop floor needs to provide a clear benefit to the people being asked to adopt it.
2. They Appear Inexpensive
A spreadsheet doesn’t come with an implementation project or software subscription.
That makes manual processes appear inexpensive compared with implementing manufacturing software.
But the true cost is harder to see.
Consider the time spent:
- Entering the same information into multiple systems
- Searching for production information
- Correcting data-entry errors
- Building reports manually
- Reconciling inventory discrepancies
- Tracking down work in progress
- Updating ERP after production has already occurred
Individually, those tasks may seem minor. Across hundreds or thousands of transactions, they create significant operational overhead.
3. Replacing Them Feels Disruptive
Manufacturers cannot simply stop production while they replace their processes.
That creates a legitimate concern:
Will implementing new technology disrupt the shop floor?
For manufacturers already operating at capacity, even a temporary productivity decline can make a technology project difficult to justify.
The answer isn’t avoiding modernization. It’s implementing technology in a way that accounts for the realities of manufacturing.
4. Manual Processes Often Work—Until They Don’t
A spreadsheet may work perfectly well when one person manages ten jobs.
What happens when that becomes 100 jobs across multiple work centers, shifts, machines, or facilities?
Growth exposes weaknesses that weren’t obvious before.
The same spreadsheet that once made production easier can eventually become one of the things limiting it.
What We See on Manufacturing Floors
After more than 40 years of working with manufacturers, ISE has seen how manual processes evolve.
The challenge usually isn’t simply that “the manufacturer uses paper.”
It’s the information gaps those processes create.
A production environment may have an ERP system managing orders, inventory, purchasing, scheduling, and financial information while shop floor execution still depends on a combination of paper travelers, spreadsheets, verbal updates, and tribal knowledge.
That can create situations where:
- Operators don’t have the latest production information.
- Supervisors maintain separate spreadsheets to understand job status.
- Production is completed before the ERP reflects what happened.
- WIP is difficult to locate without asking someone.
- Inventory records don’t match what’s physically available.
- Downtime is recorded manually or not captured consistently.
- Management receives production information after there’s still time to act on it.
- Different departments operate from different versions of the truth.
The issue isn’t the spreadsheet itself.
The issue is that production information isn’t moving quickly and accurately enough between the shop floor and the rest of the business.
ERP Plans the Work. MES Runs the Work.
Many manufacturers already have an ERP system, which can lead to another reasonable question:
If we have ERP, why do we need MES?
The systems solve different problems.
ERP manages business-wide planning and transactions, including orders, inventory, purchasing, scheduling, and financials.
MES focuses on production execution as it happens.
Think of it this way:
ERP plans the work. MES runs the work.
When the two systems are connected, production information can flow in both directions.
ERP sends production requirements to the shop floor. MES helps operators execute that work and captures what actually happens. Accurate production results can then flow back into ERP.
Instead of waiting for someone to update a spreadsheet or manually enter information at the end of a shift, manufacturers can build a continuous connection between planning and execution.
Related: What Is a Manufacturing Execution System (MES)? A Guide for Discrete Manufacturers
What Happens When Manufacturing Outgrows Spreadsheets?
Spreadsheets aren’t inherently bad.
They are extremely useful business tools.
The problem occurs when they’re asked to function as a real-time production system.
Production Information Becomes Outdated
Manufacturing conditions change constantly.
A machine goes down. A job takes longer than expected. Material isn’t available. A priority order enters production.
A spreadsheet represents the information available the last time someone updated it.
MES can capture production activity as it happens, giving supervisors and managers a more current view of operations.
Manual Data Entry Creates Errors
Every time information moves from paper to a spreadsheet and from a spreadsheet into ERP, another opportunity for error is introduced.
One incorrect quantity can affect inventory.
One missed labor transaction can affect job costing.
One incorrect production update can affect scheduling.
Capturing information closer to where production actually happens reduces those manual handoffs.
Information Becomes Fragmented
The production manager has one spreadsheet.
Quality has another.
Inventory maintains its own records.
Operators have paper travelers.
ERP contains another version of the information.
Each may be accurate within its own context, but understanding what’s actually happening requires bringing information together manually.
A modern MES provides a centralized layer for shop floor execution.
Problems Are Discovered Too Late
Historical reports tell you what happened.
Shop floor visibility helps tell you what is happening.
That distinction matters.
Knowing yesterday that a work center fell behind is useful for reporting. Knowing while production is still running allows someone to respond.
When Has a Manufacturer Outgrown Spreadsheets?
There isn’t a specific company size or number of employees that determines when a manufacturer needs MES.
A better indicator is the amount of friction created by the current process.
Your operation may be ready to move beyond spreadsheets and paper if:
- Supervisors spend significant time compiling production reports manually.
- Production data isn’t entered into ERP until hours after work occurs.
- Management has difficulty seeing current job status.
- Operators depend heavily on tribal knowledge.
- WIP is difficult to locate.
- Inventory accuracy is becoming harder to maintain.
- Different departments maintain separate versions of production data.
- Scheduling decisions rely on information that may already be outdated.
- Growth is making existing manual processes harder to maintain.
- Quality or traceability requirements require more consistent data collection.
- You have plenty of manufacturing data but struggle to turn it into useful information.
You don’t need to experience every problem on this list.
The larger question is:
Are your current tools helping your people run production, or are your people spending increasing amounts of time keeping those tools running?
What MES Replaces on the Shop Floor
MES isn’t simply a digital spreadsheet.
A Manufacturing Execution System creates a structured connection between people, production processes, machines, and enterprise systems.
Depending on the operation, MES can help manufacturers manage:
Production and Work Orders
Operators can access current job information and report production directly from the shop floor instead of relying on handwritten updates.
Scheduling and Dispatch
Production priorities can reflect what’s actually happening rather than relying entirely on a static schedule.
Labor Tracking
Manufacturers can capture labor against jobs and operations as work occurs.
Inventory and Material Movement
Material transactions can be captured closer to the point of use, helping improve inventory visibility and accuracy.
Quality
Quality requirements and inspections can become part of the production workflow rather than separate paper processes.
WIP Tracking
Supervisors can see where work is located and how it’s progressing without tracking down operators or manually updating spreadsheets.
Machine Integration
Machine information can be combined with operator and production data to create a more complete picture of manufacturing performance.
Performance and OEE
Instead of manually assembling reports after production, manufacturers can monitor performance using data captured throughout the process.
Related: 10 MES Use Cases That Improve Manufacturing Productivity
Better Manufacturing AI Starts With Better Shop Floor Data
The conversation around AI makes eliminating disconnected manual data even more important.
AI can analyze information quickly, but it still depends on the quality and timeliness of the information it receives.
If production data lives on paper travelers, individual spreadsheets, disconnected machines, or inside employees’ heads, AI cannot magically create complete shop floor visibility.
Manufacturers need a reliable digital foundation first.
That means capturing structured information about production, labor, inventory, quality, downtime, machines, and performance as close to the source as possible.
MES provides that execution layer.
Once accurate shop floor data is available digitally, manufacturers are in a much stronger position to apply analytics, automation, alerts, and AI to actual manufacturing operations.
Moving Away From Spreadsheets Doesn’t Mean Changing Everything at Once
One reason manufacturers delay MES projects is the assumption that modernization requires replacing every existing process at once.
It doesn’t have to.
The better approach is often to identify where lack of visibility or manual effort is creating the most significant operational problem.
That might be:
- Production reporting
- Labor tracking
- Inventory accuracy
- Scheduling
- Quality
- Machine visibility
- WIP tracking
Solve a meaningful manufacturing problem first. Then expand from there.
Technology adoption is also about people.
A system can have impressive functionality, but if operators find it difficult to use, adoption suffers. MES should make it easier for people to do their jobs—not simply digitize an inefficient process.
From Manual Processes to a Connected Shop Floor
Paper and spreadsheets have lasted this long in manufacturing for a reason: they’re flexible, familiar, and easy to start using.
But there’s a point where flexibility becomes fragmentation.
As manufacturers grow and production becomes more complex, they need accurate information moving between ERP and the shop floor in real time.
That’s the role of MES.
MV2 MES is ISE’s Manufacturing Execution System built for discrete manufacturers. It connects ERP with shop floor execution to provide real-time visibility into production, labor, inventory, quality, machines, and performance.
The goal isn’t technology for technology’s sake.
It’s giving the people running manufacturing accurate information when they can still do something with it.
Explore MV2 MES and see how it connects ERP data to shop floor execution.