Business News

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
Best Practices   Business   Manufacturing   Demand-Driven Manufacturing   Digitization   Enterprise Resource Planning   All topics


Comments
Be the first to post a comment.
You must be logged in to post a comment. Login.

 
Latest Business News
People Are Your Organization’s Most Valuable Asset
During several of the industry conferences last year, I had multiple conversations about what many are now calling a “labor crisis” in the supply chain industry.

Apple Plans Major US Expansion Including a New $1 Billion Campus in Austin Texas
Apple Inc said it would invest $1 billion to build a second campus in North Austin, Texas and another $10 billion for new data centers over the next five years, as it aims to create 20,000 jobs in the…

Are You and Your Company Prepared For a Supply Chain Talent Crisis?
Supply chain programs aren’t graduating enough new practitioners to replace those exiting in the workforce, but the talent crisis is about more than demographics: a shift in thinking must also take place…

MIT Restructures Itself to Shape the Future of Computing & Artificial Intelligence
Gift of $350 million establishes the MIT Stephen A. Schwarzman College of Computing, an unprecedented, $1 billion commitment to world-changing breakthroughs and their ethical application.


 

24|7 Pro Team

The 24|7 Team is your direct pipeline to solutions for your business challenges. It's your opportunity to have supply chain and logistics experts look at your specific challenges and needs, and give you free, no-obligation advice, solutions, and information.

The 24|7 Team will simplify the task of creating a database of likely partners, building your knowledge base, and preparing your Request for Proposal list.

1
  Choose a topic for your RFP

Transportation RFP/RFI

The Transportation RFP is your direct pipeline to solutions for your transportation challenges. It's your opportunity to have logistics experts look at your specific transportation challenges and needs, and give you free, no-obligation advice, solutions, and information specific to your request.

Choosing the perfect software or system can be an indomitable challenge. Using this transportation/TMS RFP will simplify the task of creating a database of likely partners, building your knowledge base, and preparing your Request for Proposal list.

Warehouse/DC Management RFP/RFI

The Warehouse Management Systems (WMS) RFP is your direct pipeline to solutions for your WMS challenges. It's your opportunity to have logistics experts look at your specific WMS challenges and needs, and give you free, no-obligation advice, solutions, and information specific to your request.

Choosing the perfect WMS solution can be an indomitable challenge. Using this WMS RFP will simplify the task of creating a database of likely partners, building your knowledge base, and preparing your WMS Request for Proposal list.

Supply Chain RFP/RFI

The Supply Chain RFP is your opportunity to have logistics experts look at your specific challenges and needs, and receive free, no-obligation advice, solutions, and information. It simplifies finding a pool of likely partners, building your knowledge base, and preparing your Request for Proposal list. The companies in the Logistics Planner have agreed to respond to your request for in-depth information and follow-up, and your request is totally confidential.

Software/Technology RFP/RFI

The Software/Technology is your direct pipeline to solutions for your logistics information technology challenges. It's your opportunity to have logistics experts look at your specific technology challenges and needs, and give you free, no-obligation advice, solutions, and information specific to your request. Whether it's WMS, TMS, Mobile or Cloud, our pros can help.

The companies listed below have agreed to respond to your request for in-depth information and follow-up. Your request is totally confidential.

Executive Education RFI

The Logistics and Supply Chain Education RFI can help you identify the schools, coursework, continuing education, distance learning and certification opportunities available from leading logistics educational institutions.

Upgrade and improve your logistics and supply chain skillsets. Whatever route you choose—advanced degree, executive education, certification or distance learning—the time and money you invest in your education today can pay off in continued career success tomorrow. Contact leading universities and professional institutions for the information you need to prepare for the future.

Third Party Logistics RFP/RFI

This 3PL Request for Proposal (RFP)/Request for Information (RFI) can help you find the 3PL and 4PL providers that can meet your specific 3PL service challenges and needs. The 3PL companies below will provide free, no-obligation third-party logistics advice, solutions, and information.

Ask your 3PL questions, you'll get answers. Simply complete the information, and detail your 3PL challenges. Then, check off the third-party logistics companies that you want to review your request.

1. Choose an RFI topic.
2. Enter your contact information and challenge.
3. Select companies and optional categories.
4. Submit.


2

Your Information



Your Challenge, Problem or Request *

3

Select Transportation Companies

  • Select All

  • 3Gtms
  • BluJay Solutions
  • CSX Trans. Intermodal
  • Kuebix
  • Landstar
  • Legacy Supply Chain Svs.
  • One Network
  • Pitt Ohio
  • Purolator
  • Quintiq
  • SEKO Logistics
  • SMC3


Select Relevent Categories

  • Air Freight
  • Intermodal
  • Motor Freight
  • Ocean Freight
  • Rail Freight
  • TMS

Select Warehouse/DC Management Companies

  • Select All

  • 3PL Central
  • Apex Supply Chain Tech.
  • Honeywell Intelligrated
  • Kuebix
  • Legacy Supply Chain Svs.
  • Swisslog
  • Westfalia Technologies
  • Zebra Technologies


Select Relevent Categories

  • Auto ID & Data Capture
  • Automation
  • Conveyors & Sortation
  • Lift Trucks
  • Packaging & Labeling
  • Pallets & Containers
  • Shelving & Racking
  • WMS

Select Supply Chain Companies

  • Select All

  • 3Gtms
  • 3PL Central
  • Amber Road
  • Apex Supply Chain Tech.
  • APICS
  • BluJay Solutions
  • CSX Trans. Intermodal
  • Frontier Business
  • Kuebix
  • Landstar
  • Legacy Supply Chain Svs.
  • Logility
  • One Network
  • Purolator
  • Quintiq
  • SMC3
  • Synchrono
  • TAKE Supply Chain
  • Westfalia Technologies
  • Zebra Technologies


Select Relevent Categories

  • Global Trade
  • Inventory Management
  • Risk Management
  • Sustainability

Select Software/Technology Companies

  • Select All

  • 3GTMS
  • 3PL Central
  • Apex Supply Chain Tech.
  • BluJay Solutions
  • Honeywell Intelligrated
  • Frontier Business
  • Kuebix
  • Logility
  • One Network
  • Quintiq
  • SMC3
  • Swisslog Logistics
  • Synchrono
  • TAKE Supply Chain
  • Zebra Technologies


Select Relevent Categories

  • ERP
  • Sales & Operations
  • Sourcing/Procurement
  • Optimization
  • Transportation Mgmt
  • Warehouse Mgmt

Select Executive Education Choices

  • Select All

  • Graduate Courses
  • Online/Distance
  • Executive Education
  • Certifications
  • Undergraduate
  • Seminars
  • Associations
  • Conferences
  • Tradeshows


Select Third Party Logistics Companies

  • Select All

  • 3PL Central
  • Landstar
  • Legacy Supply Chain Svs.
  • Purolator
  • SEKO Logistics
  • Westfalia Technologies


4
 

24|7 Company Profiles