Tag: production scheduling

  • It’s Time: Manufacturers Need to Cut Ties with MRP and Spreadsheets

    It’s Time: Manufacturers Need to Cut Ties with MRP and Spreadsheets

    Update your manufacturing tools

    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 ERP and 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?Old manufacturing production tools

    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 problemsthey’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 has 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:

    DemandDriven 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.

     

    Demand driven manufacturing tools

    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:

    White paper: The Next Generation of Planning and Scheduling Solutions

    White paper: How Technology Will Connect Your Enterprise and Create the Demand-Driven Manufacturing Factory of the Future – Today

    White paper: Why Become More Demand-Driven? Responding to Customer Needs

    We also produce a YouTube channel where you can access several educational podcasts and videos that explain some of these concepts in more depth.

    As always, if you have questions, please add them in the comments below, or reach out to us directly. We would love to hear from you!

     

“test”

manufacturing software

White Paper - The Next Generation of Planning and Scheduling Solutions

  • This field is for validation purposes and should be left unchanged.

×

manufacturing software

×

manufacturing software

White Paper | Gaining Clarity

  • This field is for validation purposes and should be left unchanged.

 

×
Test_form

manufacturing software

×
White Paper | Gaining Confidence

manufacturing software

White Paper | Gaining Confidence

Please complete and submit the following information to download the white paper. Thank you for your interest in Synchrono!

  • This field is for validation purposes and should be left unchanged.

×