The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

 

1. Built-in ERP functionality is baked into Order Management.

Consider what is meant by “demand management”, “demand planning”, and “forecasting”. These terms imply certain standard functionality for collaboration, statistical analysis, and reporting to support a professional demand planning process.  However, in most ERP systems, “demand management” consists of executing MRP and reconciling demand and supply for the purpose of placing orders, i.e., “order management.” It has very little to do with demand planning which is discrete process focused on developing the best possible predictions of future demand by combining statistical analysis with business knowledge of events, promotions, and sales force intelligence.   Most ERP systems offer little statistical capability and, when offered, the user is left with a choice of a few statistical methods that they either have to apply manually from a drop-down list or program themselves. It’s baked into the order management process enabling the user to possibly how the forecast might impact inventory.  However, there isn’t any ability to manage the forecast, improve the quality of the forecast, apply and track management overrides, collaborate, measure forecast accuracy, and track “forecast value add.” 

2. ERP planning methods are often based on simplistic rules of thumb.

ERP systems will always offer min, max, safety stock, reorder point, reorder quantity, and forecasts to drive replenishment decisions.  But what about the underlying methods used to calculate these important drivers?   In nearly every case, the methods provided are nothing more than rule-of-thumb approaches that don’t account for demand or supplier variability.  Some do offer “service level targeting” but mistakenly rely on the assumption of a Normal distribution (“bell-shaped curve”) which means the required safety stocks and reorder points recommended by the system to achieve the service level target are going to be flat out wrong if your data doesn’t fit the ideal theoretical model, which is often gravely unrealistic.  Such over-simplified calculations tend to do more harm than good.  

3. You’ll probably still use spreadsheets for at least 2 years after purchase.

Most often, if you were to implement a new ERP solution, your old data would be stranded.  So, any native ERP functionality for forecasting, setting stocking policy such as Min/Max, etc., cannot be used, and you will be forced to revert back to cumbersome and error-prone spreadsheets for at least two years (one year to implement at earliest and another year to collect at least 12 months of history).  Hardly a digital transformation.  Using a best-of-breed solution avoids this problem.  You can load data from your legacy ERP system and not disrupt your ERP deployment.  This means that on Day 1 of ERP go-live you can populate your new ERP system with better inputs for demand forecasts, safety stocks, reorder points, and Min/Max settings.

4. ERP isn’t designed to do everything

The “Do everything in ERP/One-Vendor” mindset was a marketing message promoted by ERP firms, particularly SAP, to get you, the customer, to spend 100% of your IT budget with them.  That marketing message has been parroted back to users by analyst groups, IT firms, and systems integrators, drowning out rational voices who asked “Why do you want to be so dependent on one firm to the point of using inferior forecasting and inventory planning technology?”  The sheer number of IT failures and huge implementation costs have caused many companies to rethink their approach to ERP.  With the advent of specialized planning apps born in the cloud with no IT footprint, the way to go is a “thin” ERP focused on the fundamentals – accounting, order management, financials – but supported by specialized planning apps. 

The expertise of ERP consultant’s lies in how their system is designed to automate certain business processes and how the system can be configured or customized.   Their consultants are not specialists in on proper approaches to planning stock, forecasting, and inventory planning.  So if you are trying to understand what demand planning approach is right for your business, how should you buffer properly, (e.g., “Should we do Min/Max or forecast-based replenishment?” “Should we use forecasting method X?”), you generally aren’t going to find it and if you do that resource will be spread quite thin. 

 

 

 

Leave a Comment

Related Posts

The Next Frontier in Supply Chain Analytics

The Next Frontier in Supply Chain Analytics

We believe the leading edge of supply chain analytics to be the development of digital twins of inventory systems. These twins take the form of discrete event models that use Monte Carlo simulation to generate and optimize over the full range of operational risks. We also assert that we and our colleagues at Smart Software have played an outsized role in forging that leading edge.

Overcoming Uncertainty with Service and Inventory Optimization Technology

Overcoming Uncertainty with Service and Inventory Optimization Technology

In this blog, we will discuss today’s fast-paced and unpredictable market and the constant challenges businesses face in managing their inventory and service levels efficiently. The main subject of this discussion, rooted in the concept of “Probabilistic Inventory Optimization,” focuses on how modern technology can be leveraged to achieve optimal service and inventory targets amidst uncertainty. This approach not only addresses traditional inventory management issues but also offers a strategic edge in navigating the complexities of demand fluctuations and supply chain disruptions.

Daily Demand Scenarios

Daily Demand Scenarios

In this Videoblog, we will explain how time series forecasting has emerged as a pivotal tool, particularly at the daily level, which Smart Software has been pioneering since its inception over forty years ago. The evolution of business practices from annual to more refined temporal increments like monthly and now daily data analysis illustrates a significant shift in operational strategies.

Recent Posts

  • Two Multiechelon Inventory Optimization Neural Network AIThe Next Frontier in Supply Chain Analytics
    We believe the leading edge of supply chain analytics to be the development of digital twins of inventory systems. These twins take the form of discrete event models that use Monte Carlo simulation to generate and optimize over the full range of operational risks. We also assert that we and our colleagues at Smart Software have played an outsized role in forging that leading edge. […]
  • SMART JOINS EPICOREpicor Acquires Smart Software for AI-Powered Inventory Planning & Optimization Technologies
    The acquisition brings together two companies tightly aligned in helping organizations get to the right insights at the right time and take action to maximize business performance. . […]
  • Overcoming Uncertainty with Service and Inventory Optimization TechnologyOvercoming Uncertainty with Service and Inventory Optimization Technology
    In this blog, we will discuss today's fast-paced and unpredictable market and the constant challenges businesses face in managing their inventory and service levels efficiently. The main subject of this discussion, rooted in the concept of "Probabilistic Inventory Optimization," focuses on how modern technology can be leveraged to achieve optimal service and inventory targets amidst uncertainty. This approach not only addresses traditional inventory management issues but also offers a strategic edge in navigating the complexities of demand fluctuations and supply chain disruptions. […]
  • Daily Demand Scenarios Smart 2Daily Demand Scenarios
    In this Videoblog, we will explain how time series forecasting has emerged as a pivotal tool, particularly at the daily level, which Smart Software has been pioneering since its inception over forty years ago. The evolution of business practices from annual to more refined temporal increments like monthly and now daily data analysis illustrates a significant shift in operational strategies. […]
  • The Cost of Doing nothing with your inventory Planning SystemsThe Cost of Spreadsheet Planning
    Companies that depend on spreadsheets for demand planning, forecasting, and inventory management are often constrained by the spreadsheet’s inherent limitations. This post examines the drawbacks of traditional inventory management approaches caused by spreadsheets and their associated costs, contrasting these with the significant benefits gained from embracing state-of-the-art planning technologies. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Why MRO Businesses Need Add-on Service Parts Planning & Inventory SoftwareWhy MRO Businesses Need Add-on Service Parts Planning & Inventory Software
      MRO organizations exist in a wide range of industries, including public transit, electrical utilities, wastewater, hydro power, aviation, and mining. To get their work done, MRO professionals use Enterprise Asset Management (EAM) and Enterprise Resource Planning (ERP) systems. These systems are designed to do a lot of jobs. Given their features, cost, and extensive implementation requirements, there is an assumption that EAM and ERP systems can do it all. In this post, we summarize the need for add-on software that addresses specialized analytics for inventory optimization, forecasting, and service parts planning. […]
    • Spare-parts-demand-forecasting-a-different-perspective-for-planning-service-partsThe Forecast Matters, but Maybe Not the Way You Think
      True or false: The forecast doesn't matter to spare parts inventory management. At first glance, this statement seems obviously false. After all, forecasts are crucial for planning stock levels, right? It depends on what you mean by a “forecast”. If you mean an old-school single-number forecast (“demand for item CX218b will be 3 units next week and 6 units the week after”), then no. If you broaden the meaning of forecast to include a probability distribution taking account of uncertainties in both demand and supply, then yes. […]
    • Whyt MRO Businesses Should Care about Excess InventoryWhy MRO Businesses Should Care About Excess Inventory
      Do MRO companies genuinely prioritize reducing excess spare parts inventory? From an organizational standpoint, our experience suggests not necessarily. Boardroom discussions typically revolve around expanding fleets, acquiring new customers, meeting service level agreements (SLAs), modernizing infrastructure, and maximizing uptime. In industries where assets supported by spare parts cost hundreds of millions or generate significant revenue (e.g., mining or oil & gas), the value of the inventory just doesn’t raise any eyebrows, and organizations tend to overlook massive amounts of excessive inventory. […]
    • Top Differences between Inventory Planning for Finished Goods and for MRO and Spare PartsTop Differences Between Inventory Planning for Finished Goods and for MRO and Spare Parts
      In today’s competitive business landscape, companies are constantly seeking ways to improve their operational efficiency and drive increased revenue. Optimizing service parts management is an often-overlooked aspect that can have a significant financial impact. Companies can improve overall efficiency and generate significant financial returns by effectively managing spare parts inventory. This article will explore the economic implications of optimized service parts management and how investing in Inventory Optimization and Demand Planning Software can provide a competitive advantage. […]