The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

Managing inventory requires executives to balance competing goals: high product availability versus low investment in inventory. Executives strike this balance by stating availability targets and budget constraints. Then supply chain professionals translate these “commander’s intentions” into detailed specifications about reorder points and order quantities.

A High-Stakes Race Between Supply and Demand

 

Let’s focus on reorder points (also known as mins). They work as follows. As on-hand inventory decreases in response to demand, it eventually drops down to or below a trigger value, the reorder point or min. At that point, it’s like a gun goes off to start a race between supply and demand. A replenishment order is sent to restock the item, but there is a replenishment lead time, so the restocking is not instantaneous. While your system waits for resupply, demand continues to whittle away at the stock on hand. It is bad news if demand wins the race, because then you won’t be in position to provide what somebody is demanding. Then they either get it from a competitor or get back-ordered and unhappy: either way, stocking out is a bad outcome for you and your customer.

The risk of stocking is controlled by your staff’s choice of reorder points. If they are set too high, stock-outs are rare but inventory is bloated. Set them too low and stock-outs abound. So how should reorder points be set?

Avoiding Foolish Follow-Through

 

Several factors govern stock-out risk. Each item in your inventory has its own demand history and lead time. Together with your chosen availability targets, these factors determine the best choice of reorder point. But the relationships are statistical and require good analysis to work out. Inventory Optimization Software can compute the proper reorder point for each of tens of thousands of items. But instead of relying on proper analysis, many companies fall back on simple rules of thumb or just “doing what we always do”.

In place of using the right math, companies often rely on rules of thumb that serve them poorly. Here are some examples in order of most common to least common.

1) Multiples of Average Demand

 

Setting reorder points at some (arbitrary) multiple of average demand starts to rely on actual facts. But it ignores the key demand attribute that drives stock-out risk: demand variability. Two items with the same average demand but very different levels of variability will require very different reorder points to insure the same low risk of stock-out. (See Figure 1)

2) Gut feel

 

Some companies have self-styled supply chain gurus. Even if they actually are Jedi masters, it’s impossible to keep up with tens of thousands of items whose reorder points should be reviewed frequently.  And if the logic that drives decision making is buried in a hard to use spreadsheet that only they know how to use, the company risks not being able to execute the inventory plan without that one individual –a risky proposition.

3) Average Demand + some multiple of Demand Variability

 

This approach is taught in many “Inventory 101” courses. But it implicitly assumes some facts about demand that are very often not true: that demand has a Normal (“bell-shaped”) distribution and that demand in one period does not relate to demand in the previous time period(s).  Assumptions of independence and reliance on normal distribution models just don’t cut it.

4) Nursery rhymes

 

Not at all the norm, hence being last on the list, but we heard of one company that used one simple rule for all items: “If it’s down to four, order more”. It’s crazy to believe that one rule applies to all items at all times. But at least it rhymes.

Your people can do better than to rely on any of these approaches. Do you know whether your company is using any one of them?

Getting It Right

 

The right way to set reorder points uses the tools of probability theory. The details depend on whether you are selling finished goods or spare parts. Spare parts are usually more difficult to manage because they have quirky demand patterns: high intermittency (lots of zero demands), high skewness (lots of small demands but with some whoppers too), and auto-correlation (“feast or famine” behavior). Modern Reorder Point Software takes these quirks into account to set reorder points that insure the desired level of item availability. Importantly, they also let your people see explicit trade-off curves, so they can strike the balance you want — at the item by location level – between stock-out risk and inventory investment.

Inventory is a major item on the balance sheet and needs high-level attention. At many manufacturers, service parts can represent up to half of revenue. Modern software lets the C-Suite move beyond, incomplete math and other inadequate approaches to managing inventory.

 

 

Figure 1:  Two equally important items with the same average demand get assigned the same stocking policy that determines the Min (reorder point) as 2 x average lead time demand.  Despite the “same” stocking policy service performance varies significantly with the stable Item A experiencing overstocks and the volatile Item B experiencing stock outs.

Leave a Comment

Related Posts

You Need to Team up with the Algorithms

You Need to Team up with the Algorithms

This article is about the real power that comes from the collaboration between you and our software that happens at your fingertips. We often write about the software itself and what goes on “under the hood”. This time, the subject is how you should best team up with the software.

Rethinking forecast accuracy: A shift from accuracy to error metrics

Rethinking forecast accuracy: A shift from accuracy to error metrics

Measuring the accuracy of forecasts is an undeniably important part of the demand planning process. This forecasting scorecard could be built based on one of two contrasting viewpoints for computing metrics. The error viewpoint asks, “how far was the forecast from the actual?” The accuracy viewpoint asks, “how close was the forecast to the actual?” Both are valid, but error metrics provide more information.

Every Forecasting Model is Good for What it is Designed for

Every Forecasting Model is Good for What it is Designed for

With so much hype around new Machine Learning (ML) and probabilistic forecasting methods, the traditional “extrapolative” or “time series” statistical forecasting methods seem to be getting the cold shoulder. However, it is worth remembering that these traditional techniques (such as single and double exponential smoothing, linear and simple moving averaging, and Winters models for seasonal items) often work quite well for higher volume data. Every method is good for what it was designed to do. Just apply each appropriately, as in don’t bring a knife to a gunfight and don’t use a jackhammer when a simple hand hammer will do.

Recent Posts

  • Direct to the Brain of the Boss- Inventory AnalysisDirect to the Brain of the Boss – Inventory Analytics and Reporting
    In this blog, the spotlight is cast on the software that creates reports for management, the silent hero that translates the beauty of furious calculations into actionable reports. Watch as the calculations, intricately guided by planners utilizing our software, seamlessly converge into Smart Operational Analytics (SOA) reports, dividing five key areas: inventory analysis, inventory performance, inventory trending, supplier performance, and demand anomalies. […]
  • You need to team up with the algorithms for Inventory ManagementYou Need to Team up with the Algorithms
    This article is about the real power that comes from the collaboration between you and our software that happens at your fingertips. We often write about the software itself and what goes on “under the hood”. This time, the subject is how you should best team up with the software. […]
  • Rethinking forecast accuracy, A shift from accuracy to error metricsRethinking forecast accuracy: A shift from accuracy to error metrics
    Measuring the accuracy of forecasts is an undeniably important part of the demand planning process. This forecasting scorecard could be built based on one of two contrasting viewpoints for computing metrics. The error viewpoint asks, “how far was the forecast from the actual?” The accuracy viewpoint asks, “how close was the forecast to the actual?” Both are valid, but error metrics provide more information. […]
  • Using Key Performance Predictions to Plan Stocking Policies
    I can't imagine being an inventory planner in spare parts, distribution, or manufacturing and having to create safety stock levels, reorder points, and order suggestions without using key performance predictions of service levels, fill rates, and inventory costs. […]
  • Every forecasting model is good for what it is designed forEvery Forecasting Model is Good for What it is Designed for
    With so much hype around new Machine Learning (ML) and probabilistic forecasting methods, the traditional “extrapolative” or “time series” statistical forecasting methods seem to be getting the cold shoulder. However, it is worth remembering that these traditional techniques (such as single and double exponential smoothing, linear and simple moving averaging, and Winters models for seasonal items) often work quite well for higher volume data. Every method is good for what it was designed to do. Just apply each appropriately, as in don’t bring a knife to a gunfight and don’t use a jackhammer when a simple hand hammer will do. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

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