The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

You can’t properly manage your inventory levels, let alone optimize them, if you don’t have a handle on exactly how demand forecasts and stocking parameters (such as Min/Max, safety stocks, and reorder points, and order quantities) are determined.

Many organizations cannot specify how policy inputs are calculated or identify situations calling for management overrides to the policy.   For example, many people can say they rely on a particular planning method such as Min/Max, reorder point, or forecast with safety stock, but they can’t say exactly how these planning inputs are calculated.  More fundamentally, they may not understand what would happen to their KPI’s if they were to change Min,Max, or Safety Stock. They may know that the forecast relies on “averages” or “history” or “sales input”, but specific details about how the final forecast is arrived at are unclear.

Often enough, a company’s inventory planning and forecasting logic was developed by a former employee or vanished consultant and entombed in a spreadsheet.  It otherwise may rely on outdated ERP functionality or ERP customization by an IT organization that incorrectly assumed that ERP software can and should do everything. (Read this great and, as they say, “funny because it’s true,” blog by Shaun Snapp about ERP Centric Strategies.)  The policy may not have been properly documented, and no one currently on the job can improve it or use it to best advantage.

This unhappy situation leads to another, in which buyers and inventory planners flat out ignore the output from the ERP system, forcing reliance on Microsoft Excel to determine order schedules.  Ad hoc methods are developed that impede cohesive responses to operational issues and aren’t visible to the rest of the organization (unless you want your CFO to learn the complex and finicky spreadsheet).  These methods often rely on rules of thumb, averaging techniques, or textbook statistics without a full understanding of their shortcomings or applicability.  And even when documented, most companies often discover that actual ordering strays from the documented policy.  One company we consulted for had on hand inventory levels that were routinely 2 x’s the Max quantity!  In other words, there isn’t really a policy at all.

In summary, many current inventory and demand forecast “systems” were developed out of distrust for the previous system’s suggestions but don’t actually improve KPI’s.  They also force the organization to rely on a few employees to manage demand forecasting, daily ordering, and inventory replenishment.

And when there is a problem, it is impossible for the executive team to unwind how you got there, because there are too many moving parts.  For example, was the excess stock the fault of an inaccurate demand forecast that relied on an averaging method that didn’t account for a declining demand?  Or was it due to an outdated lead time setting that was higher than it should’ve been?  Or was it due to a forecast override a planner made to account for an order that just never happened?  And who gave the feedback to make that override?  A customer? Salesperson?

Do you have any of these problems?  If so, you are wasting hundreds of thousands to millions of dollars each year in unnecessary shortage costs, holding costs, and ordering costs.  What would you be able to do with that extra cash?  Imagine the impact that this would have on your business.

This blog details the top 10 questions that you can ask in order to uncover what’s really happening at your company.  We detail the typical answers provided when a forecasting/inventory planning policy doesn’t really exist, explain how to interpret these answers, and offer some clear advice on what to do about it.

 

Leave a Comment

Related Posts

Confused about AI and Machine Learning?

Confused about AI and Machine Learning?

Are you confused about what is AI and what is machine learning? Are you unsure why knowing more will help you with your job in inventory planning? Don’t despair. You’ll be ok, and we’ll show you how some of whatever-it-is can be useful.

Centering Act: Spare Parts Timing, Pricing, and Reliability

Centering Act: Spare Parts Timing, Pricing, and Reliability

In this article, we’ll walk you through the process of crafting a spare parts inventory plan that prioritizes availability metrics such as service levels and fill rates while ensuring cost efficiency. We’ll focus on an approach to inventory planning called Service Level-Driven Inventory Optimization. Next, we’ll discuss how to determine what parts you should include in your inventory and those that might not be necessary. Lastly, we’ll explore ways to enhance your service-level-driven inventory plan consistently.

Recent Posts

  • What is Inventory Control Planning Management Optimization DictionaryWhat is Inventory Planning? A Brief Dictionary of Inventory-Related Terms
    People involved in the supply chain are likely to have questions about various inventory terms and methods used in their jobs. This note may help by explaining these terms and showing how they relate. […]
  • artificial intelligence ai and machine learning inventory managementConfused about AI and Machine Learning?
    Are you confused about what is AI and what is machine learning? Are you unsure why knowing more will help you with your job in inventory planning? Don’t despair. You’ll be ok, and we’ll show you how some of whatever-it-is can be useful. […]
  • Centering Act Spare Parts Timing Pricing and ReliabilityCentering Act: Spare Parts Timing, Pricing, and Reliability
    In this article, we'll walk you through the process of crafting a spare parts inventory plan that prioritizes availability metrics such as service levels and fill rates while ensuring cost efficiency. We'll focus on an approach to inventory planning called Service Level-Driven Inventory Optimization. Next, we'll discuss how to determine what parts you should include in your inventory and those that might not be necessary. Lastly, we'll explore ways to enhance your service-level-driven inventory plan consistently. […]
  • Balance,Concept,With,Chrome,Balls,inventory optimization softwareHow to Forecast Inventory Requirements
    Forecasting inventory requirements is a specialized variant of forecasting that focuses on the high end of the range of possible future demand. Traditional methods often rely on bell-shaped demand curves, but this isn't always accurate. In this article, we delve into the complexities of this practice, especially when dealing with intermittent demand. […]
  • Demand Planning twin brothers holding forecasting toolsSix Demand Planning Best Practices You Should Think Twice About
    Every field, including forecasting, accumulates folk wisdom that eventually starts masquerading as “best practices.” These best practices are often wise, at least in part, but they often lack context and may not be appropriate for certain customers, industries, or business situations. There is often a catch, a “Yes, but”. This note is about six usually true forecasting precepts that nevertheless do have their caveats. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Centering Act Spare Parts Timing Pricing and ReliabilityCentering Act: Spare Parts Timing, Pricing, and Reliability
      In this article, we'll walk you through the process of crafting a spare parts inventory plan that prioritizes availability metrics such as service levels and fill rates while ensuring cost efficiency. We'll focus on an approach to inventory planning called Service Level-Driven Inventory Optimization. Next, we'll discuss how to determine what parts you should include in your inventory and those that might not be necessary. Lastly, we'll explore ways to enhance your service-level-driven inventory plan consistently. […]
    • 5 Steps to Improve the Financial Impact of Spare Parts Planning5 Steps to Improve the Financial Impact of Spare Parts Planning
      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. […]
    • Bottom Line strategies for Spare Parts Planning SoftwareBottom Line Strategies for Spare Parts Planning
      Managing spare parts presents numerous challenges, such as unexpected breakdowns, changing schedules, and inconsistent demand patterns. Traditional forecasting methods and manual approaches are ineffective in dealing with these complexities. To overcome these challenges, this blog outlines key strategies that prioritize service levels, utilize probabilistic methods to calculate reorder points, regularly adjust stocking policies, and implement a dedicated planning process to avoid excessive inventory. Explore these strategies to optimize spare parts inventory and improve operational efficiency. […]
    • professional technician engineer planning spare parts in industrial manufacturing factory,Prepare your spare parts planning for unexpected shocks
      In today's unpredictable business climate, we do have to worry about supply chain disruptions, long lead times, rising interest rates, and volatile demand. With all these challenges, it's never been more vital for organizations to accurately forecast parts usage, stocking levels, and to optimize replenishment policies such as reorder points, safety stocks, and order quantities. In this blog, we'll explore how companies can leverage innovative solutions like inventory optimization and parts forecasting software that utilize machine learning algorithms, probabilistic forecasting, and analytics to stay ahead of the curve and protect their supply chains from unexpected shocks. […]