Beware of Simple Rules of Thumb for Managing Inventory

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

Mastering Automatic Forecasting for Time Series Data

Mastering Automatic Forecasting for Time Series Data

In this blog, we will explore the automatic forecasting for time series demand projections. There are multiple methods to predict future demand for an item, and this becomes complex when dealing with thousands of items, each requiring a different forecasting technique due to their unique demand patterns.

Forecast-Based Inventory Management for Better Planning

Forecast-Based Inventory Management for Better Planning

Forecast-based inventory management, or MRP (Material Requirements Planning) logic, is a forward-planning method that helps businesses meet demand without overstocking or understocking. By anticipating demand and adjusting inventory levels, it maintains a balance between meeting customer needs and minimizing excess inventory costs. This approach optimizes operations, reduces waste, and enhances customer satisfaction.

Future-Proofing Utilities: Advanced Analytics for Supply Chain Optimization

Future-Proofing Utilities: Advanced Analytics for Supply Chain Optimization

Utilities in the electrical, natural gas, urban water, and telecommunications fields are all asset-intensive and reliant on physical infrastructure that must be properly maintained, updated, and upgraded over time. Maximizing asset uptime and the reliability of physical infrastructure demands effective inventory management, spare parts forecasting, and supplier management. A utility that executes these processes effectively will outperform its peers, provide better returns for its investors and higher service levels for its customers, while reducing its environmental impact.

Recent Posts

  • Managing Spare Parts Inventory: Best PracticesManaging Spare Parts Inventory: Best Practices
    In this blog, we’ll explore several effective strategies for managing spare parts inventory, emphasizing the importance of optimizing stock levels, maintaining service levels, and using smart tools to aid in decision-making. Managing spare parts inventory is a critical component for businesses that depend on equipment uptime and service reliability. Unlike regular inventory items, spare parts often have unpredictable demand patterns, making them more challenging to manage effectively. An efficient spare parts inventory management system helps prevent stockouts that can lead to operational downtime and costly delays while also avoiding overstocking that unnecessarily ties up capital and increases holding costs. […]
  • 5 Ways to Improve Supply Chain Decision Speed5 Ways to Improve Supply Chain Decision Speed
    The promise of a digital supply chain has transformed how businesses operate. At its core, it can make rapid, data-driven decisions while ensuring quality and efficiency throughout operations. However, it's not just about having access to more data. Organizations need the right tools and platforms to turn that data into actionable insights. This is where decision-making becomes critical, especially in a landscape where new digital supply chain solutions and AI-driven platforms can support you in streamlining many processes within the decision matrix. […]
  • Two employees checking inventory in temporary storage in a distribution warehouse.12 Causes of Overstocking and Practical Solutions
    Managing inventory effectively is critical for maintaining a healthy balance sheet and ensuring that resources are optimally allocated. Here is an in-depth exploration of the main causes of overstocking, their implications, and possible solutions. […]
  • FAQ Mastering Smart IP&O for Better Inventory ManagementFAQ: Mastering Smart IP&O for Better Inventory Management.
    Effective supply chain and inventory management are essential for achieving operational efficiency and customer satisfaction. This blog provides clear and concise answers to some basic and other common questions from our Smart IP&O customers, offering practical insights to overcome typical challenges and enhance your inventory management practices. Focusing on these key areas, we help you transform complex inventory issues into strategic, manageable actions that reduce costs and improve overall performance with Smart IP&O. […]
  • 7 Key Demand Planning Trends Shaping the Future7 Key Demand Planning Trends Shaping the Future
    Demand planning goes beyond simply forecasting product needs; it's about ensuring your business meets customer demands with precision, efficiency, and cost-effectiveness. Latest demand planning technology addresses key challenges like forecast accuracy, inventory management, and market responsiveness. In this blog, we will introduce critical demand planning trends, including data-driven insights, probabilistic forecasting, consensus planning, predictive analytics, scenario modeling, real-time visibility, and multilevel forecasting. These trends will help you stay ahead of the curve, optimize your supply chain, reduce costs, and enhance customer satisfaction, positioning your business for long-term success. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Managing Spare Parts Inventory: Best PracticesManaging Spare Parts Inventory: Best Practices
      In this blog, we’ll explore several effective strategies for managing spare parts inventory, emphasizing the importance of optimizing stock levels, maintaining service levels, and using smart tools to aid in decision-making. Managing spare parts inventory is a critical component for businesses that depend on equipment uptime and service reliability. Unlike regular inventory items, spare parts often have unpredictable demand patterns, making them more challenging to manage effectively. An efficient spare parts inventory management system helps prevent stockouts that can lead to operational downtime and costly delays while also avoiding overstocking that unnecessarily ties up capital and increases holding costs. […]
    • Innovating the OEM Aftermarket with AI-Driven Inventory Optimization XLInnovating the OEM Aftermarket with AI-Driven Inventory Optimization
      The aftermarket sector provides OEMs with a decisive advantage by offering a steady revenue stream and fostering customer loyalty through the reliable and timely delivery of service parts. However, managing inventory and forecasting demand in the aftermarket is fraught with challenges, including unpredictable demand patterns, vast product ranges, and the necessity for quick turnarounds. Traditional methods often fall short due to the complexity and variability of demand in the aftermarket. The latest technologies can analyze large datasets to predict future demand more accurately and optimize inventory levels, leading to better service and lower costs. […]
    • Future-Proofing Utilities. Advanced Analytics for Supply Chain OptimizationFuture-Proofing Utilities: Advanced Analytics for Supply Chain Optimization
      Utilities in the electrical, natural gas, urban water, and telecommunications fields are all asset-intensive and reliant on physical infrastructure that must be properly maintained, updated, and upgraded over time. Maximizing asset uptime and the reliability of physical infrastructure demands effective inventory management, spare parts forecasting, and supplier management. A utility that executes these processes effectively will outperform its peers, provide better returns for its investors and higher service levels for its customers, while reducing its environmental impact. […]
    • 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. […]