Four Ways to Optimize Inventory

The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

Now More than Ever

Inventory optimization has become an even higher priority in recent months for many of our customers.  Some are finding their products in vastly greater demand; more have the opposite problem. In either case, events like the Covid19 pandemic are forcing a reexamination of standard operating conditions, such as choices of reorder points and order quantities.

Even in quieter times, inventory control parameters like Mins and Maxes may be set far from their best values. We may ask “Why is the reorder point for SKU_1234 set at 20 units and the order quantify set at 35?” Those choices were probably the ossified result of years of accumulated guesses. A little investigation may show that the choices of 20 and 35 are no longer properly aligned with current demand level, demand volatility, supplier lead time and item costs.

The nagging feeling that “We should re-think all these choices” is often followed by “Oh no, we have to figure this out for all 10,000 items in inventory?” The savior here is advanced software that can scale up the process and make it not only desirable but feasible.  The software uses sophisticated algorithms to translate changes in inventory parameters such as reorder points into key performance indicators such as service levels and operating costs (defined as the sum of holding costs, ordering costs, and shortage costs).

This blog describes how to gain the benefits of inventory optimization by outlining 4 approaches with varying degrees of automation.

Four Approaches to Inventory Optimization

 

Hunt-and Peck

The first way is item-specific “hunt and peck” optimization. That is, you isolate one inventory item at a time and make “what if” guesses about how to manage that item. For instance, you may ask software to evaluate what happens if you change the reorder point for SKU123 from 20 to 21 while leaving the order quantity fixed at 35. Then you might try leaving 20 alone and reducing 35 to 34. Hours later, because your intuitions are good, you may have hit on a better pair of choices, but you don’t know if there is an even better combination that you didn’t try, and you may have to move on to the next SKU and the next and the next… You need something more automated and comprehensive.

There are three ways to get the job done more productively. The first two combine your intuition with the efficiency of treating groups of related items. The third is a fully automatic search.

Service-level Driven Optimization

  1. Identify items that you want to all have the same service level. For instance, you might manage hundreds of “C” items and wonder whether their service level target should be 70%, or more, or less.
  2. Input a potential service level target and have the software predict the consequences in terms of inventory dollar investment and inventory operating cost.
  3. If you don’t like what you see, try another service level target until you are comfortable. Here the software does group-level predictions of the consequences of your choices, but you are still exploring your choices.

Optimization by Reallocation from a Benchmark

  1. Identify items that are related in some way, such as “all spares for undercarriages of light rail vehicles.”
  2. Use the software to assess the current spectrum of service levels and costs across the group of items. Usually, you will discover some items to be grossly overstocked (as indicated by service levels unreasonably high) and others grossly understocked (service levels embarrassingly low).
  3. Use the software to calculate the changes needed to lower the highest service levels and raise the lowest. This adjustment will often result in achieving two goals at once: increasing average service level while simultaneously decreasing average operating costs.

Fully automated, Item-Specific Optimization

  1. Identify items that all require service levels above a certain minimum. For instance, maybe you want all your “A” items to have at least a 95% service level.
  2. Use the software to identify, for each item, the choice of inventory parameters that will minimize the cost of meeting or exceeding the service level minimum. The software will efficiently search the “design space” defined by pairs of inventory parameters (e.g., Min and Max) for designs (e.g., Min=10, Max=23) that satisfy the service level constraint. Among those, it will identify the least cost design.

This approach goes farthest to shift the burden from the planner to the program. Many would benefit from making this the standard way they manage huge numbers of inventory items. For some items, it may be useful to put in a little more time to make sure that additional considerations are also accounted for. For instance, limited capacity in a purchasing department may force the solution away from the ideal by requiring a decrease in the frequency of orders, despite the price paid in higher overall operating costs.

Going Forward

Optimizing inventory parameters has never been more important, but it has always seemed like an impossible dream: it was too much work, and there were no good models to relate parameter choices to key performance indicators like service level and operating cost. Modern software for supply chain analytics has changed the game. Now the question is not “Why would we do that?” but “Why are we not doing that?” With software, you can connect “Here’s what we want” to “Make it so.”

 

 

 

 

Volume and color boxes in a warehouese

 

Leave a Comment
Related Posts
Finding Your Spot on the Inventory Tradeoff Curve

Finding Your Spot on the Inventory Tradeoff Curve

This video blog holds essential insights for those working with the complexities of inventory management. The session focuses on striking the right balance within the inventory tradeoff curve, inviting viewers to understand the deep-seated importance of this equilibrium.

Why MRO Businesses Need Add-on Service Parts Planning & Inventory Software

Why 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.

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.

Recent Posts

  • Finding Your Spot on the Inventory Tradeoff CurveFinding Your Spot on the Inventory Tradeoff Curve
    This video blog holds essential insights for those working with the complexities of inventory management. The session focuses on striking the right balance within the inventory tradeoff curve, inviting viewers to understand the deep-seated importance of this equilibrium. […]
  • 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. […]
  • Descriptive, Predictive, and Prescriptive AnalyticsThe Three Types of Supply Chain Analytics
    In this video blog, we explore the critical roles of Descriptive, Predictive, and Prescriptive Analytics in inventory management, highlighting their essential contributions to driving supply chain optimization through strategic foresight and insightful data analysis. […]
  • Warning Signs that You Have a Supply Chain Analytics GapWarning Signs that You Have a Supply Chain Analytics Gap
    “Business is war” may be an overdone metaphor but it’s not without validity. Like the “Bomber Gap” and the “Missile Gap,” worries about falling behind the competition, and the resulting threat of annihilation, always lurk in the minds of business executives, If they don’t, they should, because not all gaps are imaginary (the Bomber Gap and the Missile Gap were shown to not exist between the US and the USSR, but the 1980’s gap between Japanese and American productivity was all too real). The difference between paranoia and justified concern is converting fear into facts. This post is about organizing your attention toward possible gaps in your company’s supply chain analytics. […]
  • The Objectives in ForecastingThe Objectives in Forecasting
    A forecast is a prediction about the value of a time series variable at some time in the future. For instance, one might want to estimate next month’s sales or demand for a product item. A time series is a sequence of numbers recorded at equally spaced time intervals; for example, unit sales recorded every month. The objectives you pursue when you forecast depend on the nature of your job and your business. Every forecast is uncertain; in fact, there is a range of possible values for any variable you forecast. Values near the middle of this range have a higher likelihood of actually occurring, while values at the extremes of the range are less likely to occur. […]

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

      Inventory optimization has become an even higher priority in recent months for many of our customers. Some are finding their products in vastly greater demand. Cloud computing companies with unique server and hardware parts, e-commerce, online retailers, home and office supply companies, onsite furniture, power utilities, intensive assets maintenance or warehousing for water supply companies have increased their activity during the pandemic. Garages selling car parts and truck parts, pharmaceuticals, healthcare or medical supply manufacturers and safety product suppliers are dealing with increasing demand. Delivery service companies, cleaning services, liquor stores and canned or jarred goods warehouses, home improvement stores, gardening suppliers, yard care companies, hardware, kitchen and baking supplies stores, home furniture suppliers with high demand are facing stockouts, long lead times, inventory shortage costs, higher operating costs and ordering costs.