Time for Manufacturers to Cut Ties with MRP and Spreadsheets

A recent study shows 63% of “best in class” manufacturers still used spreadsheets for planning, consequently, it's probably safe to say that there's a lack of trust in planning tools like Enterprise Resource Planning and Manufacturing Resource Planning even in the best-run companies.

A few years ago Aberdeen Group did a study that showed that 63% of “best in class” manufacturers still used spreadsheets for planning.

With percentages this high, it’s probably safe to say that there is a lack of trust in planning tools like Enterprise Resource Planning (ERP) and Manufacturing Resource Planning (MRP) even in the best-run companies.

Of course, spreadsheets come with their own set of issues.

You may have a certain amount of confidence in the spreadsheets you’ve created, but what about those from your colleagues?

Do you know what formulas they use to arrive at their conclusions?

Where did they get their data?

If the creator of the spreadsheet goes on vacation or worse – leaves the company – how quickly could a new planner take over their role using the existing planning tools and methodologies?

Spreadsheets also contain computational and data errors.

Forbes published an article quoting “various studies” that put the rate of significant errors at 88%. Though no specific studies were named, you probably don’t need that extra level of validation. You know the spreadsheets you use have errors in them. Otherwise, why would you still be having such a hard time synchronizing inventory and production to demand?

The Problem Lies in the Basis of the Plan

Actually, spreadsheets are pretty powerful tools, even with the occasional error that creeps in.

Likewise, MRP and ERP usually do exactly what they are supposed to do. They create time-phased material requirements and production plans based on the parameters entered into the system: forecasts, reorder points, capacity and so on. The calculations are so basic that even the most rudimentary software applications get them right.

The problem lies in the basis for the plans themselves. At the root of all production and material requirements plans lies the forecast, often generated by the sales or marketing department.

Even when calculations are based on an analysis of historical data, it’s still a forecast. And, as we are all painfully aware, there is no such thing as an “accurate forecast.”

Not trusting what [Forecast-based production planning problems] they’ve been handed, inventory and production planners use spreadsheets to massage the forecast data before it is entered into the system. Some of these comments might sound familiar:

“We always see a bump in demand for these items in June, so we need to increase production now.”

“I know sales have a quota on this new product, but I think they’re being overly optimistic. If we cut the requirements by about 10%, we can deal with it later if they actually manage to reach their quota.”

“I read in the news that there may be shortages of this material. Let’s order extra now so we can stay ahead of the problem.”

At the end of the day, the forecast is still a forecast, even with the wisdom of inventory and production planners added in.

Unfortunately, the new forecast may not represent reality any better than the original forecast received from sales, and ERP and MRP have no choice but to translate those erroneous assumptions into equally flawed material requirements and production plans.

In turn, these flawed plans translate into all sorts of issues: expediting orders, late nights increased overtime, missed deadlines, angry salespeople, angrier customers, inflated inventory levels, blown budgets, tense meetings in the executive conference room and bland food diets to prevent your indigestion from turning into a full-blown ulcer.

Grounding Planning in Reality

Since there is no such thing as a crystal ball that shows future demand, manufacturers who want to break free from this vicious cycle need to replace forecast-based planning with reality-based planning. In short, ditch ERP, MRP and spreadsheets (at least for replenishment and production planning) once and for all.

The only way to do that is to synchronize production and material requirements to actual demand and supply as well as what is happening on the factory floor. It’s called Demand-Driven Manufacturing, and here’s a quick definition:

Demand–Driven Manufacturing is a method of manufacturing where production is based on actual customer orders (demand) rather than a forecast. This process is accelerated by technology that automates, digitizes data and connects every function within the demand-driven organization and to every layer of the supply chain.

We created an entire platform called the Synchrono® Demand-Driven Manufacturing Platform that sits on top of your current ERP system and synchronizes all elements of production to demand and supply.

There is no need to rip out your current ERP or MRP applications; our tools use actual customer demand, supply status and the reality of the factory floor to synchronize production. The methods used, such as eKanban, Lean Six Sigma, Theory of Constraints, are no doubt familiar to you.

If this is the first time you’ve taken a close look at Demand-Driven Manufacturing, we have several resources which can help you build a solid foundation for discussions with others in your organization:

Related White Papers & Guides

Download the Paper

Next Generation of Planning & Scheduling Solutions
This white paper explores the ways manufacturing has changed, from the goals of manufacturers to the systems they rely on, discover how the software market is addressing the changing manufacturing sector. Download Now!

Download the Paper

How Technology will Connect Your Enterprise & Create the Demand-Driven Factory of the Future - Today
The Industrial Internet of Things, Smart Manufacturing, Industry 4.0 and the Factory of the Future all point toward a digitally connected environment, this paper reviews these strategies – along with how and why manufacturers are enabling them today. Download Now!

Download the Paper

Why Become More Demand-Driven?
In this paper, we will examine the nuts and bolts of “common” manufacturing environments and look at how software solutions help harmonize these processes using improved data, visibility, and demand-driven practices. Download Now!

More  Demand-Driven Resources

Article Topics

Synchrono News & Resources

Strategies for Managing Manufacturing Bottlenecks and Constraints
Eliminate Production Bottlenecks; Manage Manufacturing Constraints
Demand-Driven Manufacturing Can Help You Cost-Justify Your Next IIoT Project
Technology will Connect Your Enterprise and Create the Demand-Driven Factory of the Future - Today
Time for Manufacturers to Cut Ties with MRP and Spreadsheets
How SyncKanban eKanban Software Addresses Lean’s 8 Forms of Manufacturing Waste
The 8 Forms of Waste in Lean Manufacturing
More Synchrono

Latest in Business

Artificial Intelligence to Drive M&A Activity in Supply Chain
Supply Chains Can’t Find Talent With The Right Skill Sets
Bank of America Introduces Digital Supply Chain Finance Platform
National Retail Federation Seeks to ‘Close the Loop,’ Acquires Reverse Logistics Association
How Digital Commerce Can Survive and Thrive in Times of Inflation
Talking Supply Chain: Cardinal Health at-Home Solutions Remakes the Supply Chain
Yellow’s Demise Underscores the Need for a New Labor Relations Narrative
More Business

Synchrono®, Inc. is leading the movement in demand-driven manufacturing with software that is enabling the factory of the future.  Our portfolio of web-based applications focus on real-time   synchronization of your enterprise and manufacturing operations - from supply chain and eKanban inventory replenishment to production and execution systems. Since 2001, we have helped clients worldwide bring Lean and constraints management principles to life; providing greater visibility, real-time information integration and increasing flow through plants and beyond to the extended supply chain ecosystem. Synchrono manufacturing software enables the real-time, synchronized, visual factory of the future – today. Our enterprise systems provide greater clarity, control and confidence providing our clients with a clear competitive advantage.

View Synchrono company profile


Featured Downloads

Becoming a Shipper of Choice
Becoming a Shipper of Choice
C3 solutions' scheduling software streamlines the shipping process.
Thinking Differently About Supply Chain Planning
Thinking Differently About Supply Chain Planning
Political landscapes shift overnight, global trade is constantly changing, consumers demand increasingly personalized service and smaller day-to-day challenges hit without warning. If...

Rapidly Improve the Performance of Your Warehouse Logistics
Rapidly Improve the Performance of Your Warehouse Logistics
The Rapid Performance Evaluation identifies opportunities and potential improvements in every aspect of warehouse logistics operations; performance, productivity, service, quality, and systems.
Resource Management System (RMS): How to Effectively Leverage Your Assets
Resource Management System (RMS): How to Effectively Leverage Your Assets
This guide provides an in-depth analysis of the potential of various resources available in a warehouse and how they can be utilized...
Sustainable Supply Chain Insights From PITT OHIO
Sustainable Supply Chain Insights From PITT OHIO
A whitepaper on supply chain insights gleaned at the LEED-certified gold Cleveland transportation and sustainability summit.