The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

We frequently encounter confusion about the process of setting safety stock levels. This blog hopes to clarify the issue.

Safety stock is a critical component in any system of inventory management. Indeed, some inventory software treats safety stock as the key decision variable in the quest to balance inventory cost against item availability. Unfortunately, that approach is not the best way to strike the balance.

First, realize that safety stock is part of a general equation:

Inventory Target = Average Lead Time Demand + Safety Stock.

Average Lead Time Demand is defined as the average units demanded multiplied by the average replenishment lead time. Example: If daily demand averages 2 units and the average lead time is 7 days, then the average lead time demand is 2 x 7= 14 units. Keeping 14 units on hand suffices to handle typical demand.

But we all know that demand is random, so keeping enough stock on hand to cover the average lead time demand invites stockouts. As we like to say, “The average is not the answer.” The smart answer is to add in some safety stock to accommodate any random spikes in demand. But how much?

There’s the problem. If you try to guesstimate a number for the safety stock, you are on thin ice. How do you know what the “right” number is?  You may think that you don’t have to worry about that because you have a good-enough answer now, but that answer has a sell-by date. Lead times change. So do demand patterns. So do company priorities. That means today’s good answer may become tomorrow’s blunder.

Some companies try to wing it using a crude rule of thumb approach. For instance, they may say something like “Set safety stock at an additional two weeks of average demand.” This approach is seductive: It only needs simple math, and it is clear.  But for the reasons listed in the previous paragraph, it’s foolish. Better to get a good answer than a convenient answer.

You need a principled, objective way to answer the question that takes account of the mathematics of randomness.  More than that, you need an answer that is linked to the key performance indicators (KPI’s) of the system: inventory cost and item availability.

Simple logic gives you some sense of the answer, but it doesn’t provide the number you need. You know that more safety stock increases both cost and availability, while less safety stock decreases both. But without knowing how much those metrics will change if you change the safety stock, you have no way to align the safety stock decision with management’s intent for striking the balance between cost and availability.

Rather than flying blind, you can back into the choice of safety stock by first finding the right choice for inventory target. Once you’ve done that, the safety stock pops out by a simple subtraction:

 Safety Stock = Inventory Target – Average Lead Time Demand.

Manager In Warehouse With ClipboardOften times, companies will state that they don’t carry safety stock because the safety stock field in their ERP system is blank. Nearly always, safety stock is built into the targeted inventory level they have established.  So, using the above formula to “back out” how much safety stock you are building into the plan is quite helpful.  The key is not just to know how much safety stock you are carrying but the link between your inventory target, safety stocks, and its corresponding KPI’s.

For instance, suppose you can tolerate only a 5% chance of stocking out while waiting for replenishment (inventory texts call this interval the “period of risk.”). Software can examine the demand history of each item and work out the odds of stockout based on the thousands of different demand scenarios that can occur during the lead time. Then the right answer for the inventory target is the choice that leads to no more than a 5% stockout risk. Given that target and knowing the average lead time demand, the appropriate safety stock value falls right out by subtraction. You also get to know the average holding, ordering and shortage costs.

That’s what we mean by “backing into the safety stock.” Start with company objectives, determine the appropriate inventory target, then derive the safety stock as the last step. Don’t start with a guess about safety stock and hope for the best.

Leave a Comment

Related Posts

Head to Head: Which Service Parts Inventory Policy is Best?

Head to Head: Which Service Parts Inventory Policy is Best?

Our customers have usually settled into one way to manage their service parts inventory. The professor in me would like to think that the chosen inventory policy was a reasoned choice among considered alternatives, but more likely it just sort of happened. Maybe the inventory honcho from long ago had a favorite and that choice stuck. Maybe somebody used an EAM or ERP system that offered only one choice. Perhaps there were some guesses made, based on the conditions at the time.

Leveraging ERP Planning BOMs with Smart IP&O to Forecast the Unforecastable

Leveraging ERP Planning BOMs with Smart IP&O to Forecast the Unforecastable

In a highly configurable manufacturing environment, forecasting finished goods can become a complex and daunting task. The number of possible finished products will skyrocket when many components are interchangeable. A traditional MRP would force us to forecast every single finished product which can be unrealistic or even impossible. Several leading ERP solutions introduce the concept of the “Planning BOM”, which allows the use of forecasts at a higher level in the manufacturing process. In this article, we will discuss this functionality in ERP, and how you can take advantage of it with Smart Inventory Planning and Optimization (Smart IP&O) to get ahead of your demand in the face of this complexity.

Finding Your Spot on the Tradeoff Curve

Finding Your Spot on the Tradeoff Curve

Managing inventory, like managing anything, involves balancing competing priorities. Do you want a lean inventory? Yes! Do you want to be able to say “It’s in stock” when a customer wants to buy something? Yes!
But can you have it both ways? Only to a degree. If you lean into leaning your inventory too aggressively, you risk stockouts. If you stamp out stockouts, you create inventory bloat. You are forced to find a satisfactory balance between the two competing goals of lean inventory and high item availability.

Recent Posts

  • Smart Software Partnership with Sage for Inventory Optimization and Demand ForecastingSmart Software Announces Strategic Partnership with Sage for Inventory Optimization and Demand Forecasting
    Smart Software announces today their strategic partnership with Sage. This collaboration brings Smart IP&O (Inventory Planning and Optimization) into the latest cloud and on-premises versions of Sage X3, Sage 300, and Sage 100. […]
  • Head to Head Which Service Parts Inventory Policy is Best SoftwareHead to Head: Which Service Parts Inventory Policy is Best?
    Our customers have usually settled into one way to manage their service parts inventory. The professor in me would like to think that the chosen inventory policy was a reasoned choice among considered alternatives, but more likely it just sort of happened. Maybe the inventory honcho from long ago had a favorite and that choice stuck. Maybe somebody used an EAM or ERP system that offered only one choice. Perhaps there were some guesses made, based on the conditions at the time. […]
  • The Forecasting Process For Decision-MakersThe Forecasting Process for Decision-Makers
    In almost every business and industry, decision-makers need reliable forecasts of critical variables, such as sales, revenues, product demand, inventory levels, market share, expenses, and industry trends.Many kinds of people make these forecasts. Some are sophisticated technical analysts such as business economists and statisticians. Many others regard forecasting as an important part of their overall work: general managers, production planners, inventory control specialists, financial analysts, strategic planners, market researchers, and product and sales managers. Still, others seldom think of themselves as forecasters but often have to make forecasts on an intuitive, judgmental basis. […]
  • Success Story: Procon Pumps Uses Smart Demand Planner to Keep Business FlowingProcon Pumps Uses Smart Demand Planner to Keep Business Flowing
    Smart platform’s advanced analytics, and smooth integration with Procon’s ERP system led to accurate forecasts, and optimal inventory levels. […]
  • Weathering a Demand ForecastWeathering a Demand Forecast
    For some of our customers, weather has a significant influence on demand. Extreme short-term weather events like fires, droughts, hot spells, and so forth can have a significant near-term influence on demand. There are two ways to factor weather into a demand forecast: indirectly and directly. The indirect route is easier using the scenario-based approach of Smart Demand Planner. The direct approach requires a tailored special project requiring additional data and hand-crafted modeling. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • 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. […]
    • 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. […]