The Supply Chain Blame Game: Top 3 Excuses for Inventory Shortage and Excess
  1. Blaming Shortages on Lead Time Variability
    Suppliers will often be late, sometimes by a lot. Lead time delays and supply variability are supply chain facts of life, yet inventory carrying organizations are often caught by surprise when a supplier is late.  An effective inventory planning process embraces these facts of life and develops policies that effectively account for this uncertainty.  Sure, there will be times when lead time delays come out of nowhere.  But most often the stocking policies like reorder points, safety stocks, and Min/Max levels aren’t recalibrated often enough to catch changes in the lead time over time.  Many companies only review the reorder point after it has been breached, instead of recalibrating after each new lead time receipt.  We’ve observed situations where the Min/Max settings are only recalibrated annually or are even entirely manual.  If you have a mountain of parts using old Min/Max levels and associated lead times that were relevant a year ago, it should be no surprise that you don’t have enough inventory to hold you until the next order arrives. 

 

  1. Blaming Excess on Bad Sales/Customer Forecasts
    Forecasts from your customers or your sales team are often intentionally over-estimated to ensure supply, in response to past inventory shortages where they were left out to dry. Or, the demand forecasts are inaccurate simply because the sales team doesn’t really know what their customer demand is going to be but are forced to give a number. Demand Variability is another supply chain fact of life, so planning processes need to do a better job account for it.  Why should rely on sales teams to forecast when they best serve the company by selling? Why bother playing the game of feigning acceptance of customer forecasts when both sides know it is often nothing more than a WAG?  A better way is to accept the uncertainty and agree on a degree of stockout risk that is acceptable across groups of items.  Once the stockout risk is agreed to, you can generate an accurate estimate of the safety stock needed to counter the demand variability.  The catch is getting buy-in, since you may not be able to afford super high service levels across all items.  Customers must be willing to pay a higher price per unit for you to deliver extremely high service levels.  Sales people must accept that certain items are more likely to have backorders if they prioritize inventory investment on other items.  Using a consensus safety stock process ensures you are properly buffering and setting the right expectations.  When you do this, you free all parties from having to play the prediction game they were not equipped to play in the first place. 

 

  1. Blaming Problems on Bad Data
    “Garbage In/Garbage Out” is a common excuse for why now is not the right time to invest in planning software. Of course, it is true that if you feed bad data into a model, you won’t get good results, but here’s the thing:  someone, somewhere in the organization is planning inventory, building a forecast, and making decisions on what to purchase. Are they doing this blindly, or are they using data they have curated in a spreadsheet to help them make inventory planning decisions? Hopefully, the latter.  Combine that internal knowledge with software, automating data import from the ERP, and data cleansing.  Once harmonized, your planning software will provide continually updated, well-structured demand and lead time signals that now make effective demand forecasting and inventory optimization possible.  Smart Software cofounder Tom Willemain wrote in an IBF newsletter that “many data problems derive from data having been neglected until a forecasting project made them important.” So, start that forecasting project, because step one is making sure that “what goes in” is a pristine, documented, and accurate demand signal.

 

 

Managing Inventory amid Regime Change

​If you hear the phrase “regime change” on the news, you immediately think of some fraught geopolitical event. Statisticians use the phrase differently, in a way that has high relevance for demand planning and inventory optimization. This blog is about “regime change” in the statistical sense, meaning a major change in the character of the demand for an inventory item.

An item’s demand history is the fuel that powers demand planners’ forecasting machines. In general, the more fuel the better, giving us a better fix on the average level, the volatility, the size and frequency of any spikes, the shape of any seasonality pattern, and the size and direction of any trend.

But there is one big exception to the rule that “more data is better data.” If there is a major shift in your world and new demand doesn’t look like old demand, then old data become dangerous.

Modern software can make accurate forecasts of item demand and suggest wise choices for inventory parameters like reorder points and order quantities. But the validity of these calculations depends on the relevance of the data used in their calculation. Old data from an old regime no longer reflect current reality, so including them in calculations creates forecast error for demand planners and either excess stock or unacceptable stockout rates for inventory planners.

That said, if you were to endure a recent regime change and throw out the obsolete data, you would have a lot less data to work with. This has its own costs, because all the estimates computed from the data would have greater statistical uncertainty even though they would be less biased. In this case, your calculations would have to rely more heavily on a blend of statistical analysis and your own expert judgement.

At this point, you may ask “How can I know if and when there has been a regime change?” If you’ve been on the job for a while and are comfortable looking at timeplots of item demand, you will generally recognize regime change when you see it, at least if it’s not too subtle. Figure 1 shows some real-world examples that are obvious.

Figure 1 Four examples of regime change in real-world item demand

Figure 1: Four examples of regime change in real-world item demand

 

Unfortunately, less obvious changes can still have significant effects. Moreover, most of our customers are too busy to manually review all the items they manage even once per quarter. When you get beyond, say, 100 items, the task of eyeballing all those time series becomes onerous. Fortunately, software can do a good job of continuously monitoring demand for tens of thousands of items and alerting you to any items that may need your attention. Then too, you can arrange for the software to not only detect regime change but also automatically exclude from its calculations all data collected before the most recent regime change, if any. In other words, you can get both automatic warning of regime change and automatic protection from regime change.

For more on the basics of regime change, see our previous blog on the topic: https://smartcorp.com/blog/demandplanningregimechange/  

 

An Example with Numbers in It

If you would like to learn more, read on to see a numerical example of how much regime change can alter the calculation of a reorder point for a critical spare part. Here is a scenario to illustrate the point.

Scenario

  • Goal: calculate the reorder point needed to control the risk of stockout while waiting for replenishment. Assume the target stockout risk is 5%.
  • Assume the item has intermittent daily demand, with many days of zero demand.
  • Assume daily demand has a Poisson distribution with an average of 1.0 units per day.
  • Assume the replenishment lead time is always 30 days.
  • The lead time demand will be random, so it will have a probability distribution and the reorder point will be the 95th percentile of the distribution.
  • Assume the effect of regime change is to either raise or lower the mean daily demand.
  • Assume there is one year of daily data available for estimating the mean daily unit demand.

 

Figure 2 Example of change in mean demand and sample of random daily demand

Figure 2 Example of change in mean demand and sample of random daily demand

 

Figure 2 shows one form of this scenario. The top panel shows that the average daily demand increases from 1.0 to 1.5 after 270 days. The bottom panel shows one way that a year’s worth of daily demand might appear. (At this point, you may be feeling that calculating all this stuff is complicated, even for what turns out to be a simplified scenario. That is why we have software!)

Analysis

Successful calculation of the proper reorder point will depend on when regime change happens and how big a change occurs. We simulated regime changes of various sizes at various times within a 365 day period. Around a base demand of 1.0 units per day, we studied shifts in demand (“shift”) of ±25% and ±50% as well as a no change reference case. We located the time of the change (“t.break”) at 90, 180, and 270 days. In each case, we computed two estimates of the reorder point: The “ideal” value given perfect knowledge of the average demand in the new regime (“ROP.true”), and the estimated value of mean demand computed by ignoring the regime change and using all the demand data for the past year (“ROP.all”).

Table 1 shows the estimates of the reorder point computed over 100 simulations. The center block is the reference case, in which there is no change in the daily demand, which remains fixed at 1 unit per day. The colored block at the bottom is the most extreme increasing scenario, with demand increasing to 1.5 units/day either one-third, one-half, or two-thirds of the way through the year.

We can draw several conclusions from these simulations.

ROP.true: The correct choice for reorder point increases or decreases according to the change in mean demand after the regime change. The relationship is not a simple linear one: the table spans a 600% range of demand levels (0.25 to 1.50) but a 467% range of reorder points (from 12 to 56).

ROP.all: Ignoring the regime change can lead to gross overestimates of the reorder point when demand drops and gross underestimates when demand increases.  As we would expect, the later the regime change, the worse the error. For example, if demand increases from 1.0 to 1.5 units per day two-thirds of the way through the year without being noticed, the calculated reorder point of 43 units would fall 13 units short of where it should be.

A word of caution: Table 1 shows that basing the calculations of reorder points using only data from after a regime change will usually get the right answer. What it doesn’t show is that the estimates can be unstable if there is very little demand history after the change. Therefore, in practice, you should wait to react to the regime change until a decent number of observations have accumulated in the new regime. This might mean using all the demand history, both pre- and post-change, until, say, 60 or 90 days of history have accumulated before ignoring pre-change data.

 

Table 1 Correct and Estimated Reorder Points for different regime change scenarios

Table 1 Correct and Estimated Reorder Points for different regime change scenarios

Goldilocks Inventory Levels

You may remember the story of Goldilocks from your long-ago youth. Sometimes the porridge was too hot, sometimes it was too cold, but just once it was just right. Now that we are adults, we can translate that fairy tale into a professional principle for inventory planning: There can be too little or too much inventory, and there is some Goldilocks level that is “just right.” This blog is about finding that sweet spot.

To illustrate our supply chain fable, consider this example. Imagine that you sell service parts to keep your customers systems up and running. You offer a particular service part that costs you $100 to make but sells for a 20% markup. You can make $20 on each unit you sell, but you don’t get to keep the whole $20 because of the inventory operating costs you bear to be able to sell the part. There are holding costs to keep the part in good repair while in stock and ordering costs to replenish units you sell. Finally, sometimes you lose revenue from lost sales due to stockouts.  

These operating costs can be directly related to the way you manage the part in inventory. For our example, assume you use a (Q,R) inventory policy, where Q is the replenishment order quantity and R is the reorder point. Assume further that the reason you are not making $30 per unit is that you have competitors, and customers will get the part from them if they can’t get it from you.

Both your revenue and your costs depend in complex ways on your choices for Q and R. These will determine how much you order, when and therefore how often you order, how often you stock out and therefore how many sales you lose, and how much cash you tie up in inventory. It is impossible to cost out these relationships by guesswork, but modern software can make the relationships visible and calculate the dollar figures you need to guide your choice of values for Q and R. It does this by running detailed, fact-based, probabilistic simulations that predict costs and performance by averaging over a large number of realistic demand scenarios.  

With these results in hand, you can work out the margin associated with (Q,R) values using the simple formula

Margin = (Demand – Lost Sales) x Profit per unit sold – Ordering Costs – Holding Costs.

In this formula, Lost Sales, Ordering Costs and Holding Costs are dependent on reorder point R and order quantity Q.

Figure 1 shows the result of simulations that fixed Q at 25 units and varied R from 10 to 30 in steps of 5. While the curve is rather flat on top, you would make the most money by keeping on-hand inventory around 25 units (which corresponds to setting R = 20). More inventory, despite a higher service level and fewer lost sales, would make a little less money (and ties up a lot more cash), and less inventory would make a lot less.

 

Margins vs Inventory Level Business

Figure 1: Showing that there can be too little or too much inventory on hand

 

Without relying on the inventory simulation software, we would not be able to discover

  • a) that it is possible to carry too little and too much inventory
  • b) what the best level of inventory is
  • c) how to get there by proper choices of reorder point R and order quantity Q.

 

Without an explicit understanding of the above, companies will make daily inventory decisions relying on gut feel and averaging based rule of thumb methods. The tradeoffs described here are not exposed and the resulting mix of inventory yields a far lower return forfeiting hundreds of thousands to millions per year in lost profits.  So be like Goldilocks.  With the right systems and software tools, you too can get it just right!    

 

 

Leave a Comment
Related Posts
The Supply Chain Blame Game:  Top 3 Excuses for Inventory Shortage and Excess

The Supply Chain Blame Game: Top 3 Excuses for Inventory Shortage and Excess

The supply chain has become the blame game for almost any industrial or retail problem. Shortages on lead time variability, bad forecasts, and problems with bad data are facts of life, yet inventory-carrying organizations are often caught by surprise when any of these difficulties arise. So, again, who is to blame for the supply chain chaos? Keep reading this blog and we will try to show you how to prevent product shortages and overstocking.

An Example of Simulation-Based Multiechelon Inventory Optimization

Managing the inventory in a single facility is difficult enough, but the problem becomes much more complex when there are multiple facilities arrayed in multiple echelons. The complexity arises from the interactions among the echelons, with demands at the lower levels bubbling up and any shortages at the higher levels cascading down.

If each of the facilities were to be managed in isolation, standard methods could be used, without regard to interactions, to set inventory control parameters such as reorder points and order quantities. However, ignoring the interactions between levels can lead to catastrophic failures. Experience and trial and error allow the design of stable systems, but that stability can be shattered by changes in demand patterns or lead times or by the addition of new facilities. Coping with such changes is greatly aided by advanced supply chain analytics, which provide a safe “sandbox” within which to test out proposed system changes before deploying them. This blog illustrates that point.

 

The Scenario

To have some hope of discussing this problem usefully, this blog will simplify the problem by considering the two-level hierarchy pictured in Figure 1. Imagine the facilities at the lower level to be warehouses (WHs) from which customer demands are meant to be satisfied, and that the inventory items at each WH are service parts sold to a wide range of external customers.

 

Fact and Fantasy in Multiechelon Inventory Optimization

Figure 1: General structure of one type of two-level inventory system

Imagine the higher level to consist of a single distribution center (DC) which does not service customers directly but does replenish the WHs. For simplicity, assume the DC itself is replenished from a Source that always has (or makes) sufficient stock to immediately ship parts to the DC, though with some delay. (Alternatively, we could consider the system to have retail stores supplied by one warehouse).

Each level can be described in terms of demand levels (treated as random), lead times (random), inventory control parameters (here, Min and Max values) and shortage policy (here, backorders allowed).

 

The Method of Analysis

The academic literature has made progress on this problem, though usually at the cost of simplifications necessary to facilitate a purely mathematical solution. Our approach here is more accessible and flexible: Monte Carlo simulation. That is, we build a computer program that incorporates the logic of the system operation. The program “creates” random demand at the WH level, processes the demand according to the logic of a chosen inventory policy, and creates demand for the DC by pooling the random requests for replenishment made by the WHs. This approach lets us observe many simulated days of system operation while watching for significant events like stockouts at either level.

 

An Example

To illustrate an analysis, we simulated a system consisting of four WHs and one DC. Average demand varied across the WHs. Replenishment from the DC to any WH took from 4 to 7 days, averaging 5.15 days. Replenishment of the DC from the Source took either 7, 14, 21 or 28 days, but 90% of the time it was either 21 or 28 days, making the average 21 days. Each facility had Min and Max values set by analyst judgement after some rough calculations.

Figure 2 shows the results of one year of simulated daily operation of this system. The first row in the figure shows the daily demand for the item at each WH, which was assumed to be “purely random”, meaning it had a Poisson distribution. The second row shows the on-hand inventory at the end of each day, with Min and Max values indicated by blue lines. The third row describes operations at the DC.  Contrary to the assumption of much theory, the demand into the DC was not close to being Poisson, nor was the demand out of the DC to the Source. In this scenario, Min and Max values were sufficient to keep item availability was high at each WH and at the DC, with no stockouts observed at any of the five facilities.

 

Click here to enlarge the image

Figure 2 - Simulated year of operation of a system with four WHs and one DC.

Figure 2 – Simulated year of operation of a system with four WHs and one DC.

 

Now let’s vary the scenario. When stockouts are extremely rare, as in Figure 2, there is often excess inventory in the system. Suppose somebody suggests that the inventory level at the DC looks a bit fat and thinks it would be good idea to save money there. Their suggestion for reducing the stock at the DC is to reduce the value of the Min at the DC from 100 to 50. What happens? You could guess, or you could simulate.

Figure 3 shows the simulation – the result is not pretty. The system runs fine for much of the year, then the DC runs out of stock and cannot catch up despite sending successively larger replenishment orders to the Source. Three of the four WHs descend into death spirals by the end of the year (and WH1 follows thereafter). The simulation has highlighted a sensitivity that cannot be ignored and has flagged a bad decision.

 

Click here to enlarge image

Figure 3 - Simulated effects of reducing the Min at the DC.

Figure 3 – Simulated effects of reducing the Min at the DC.

 

Now the inventory managers can go back to the drawing board and test out other possible ways to reduce the investment in inventory at the DC level. One move that always helps, if you and your supplier can jointly make it happen, is to create a more agile system by reducing replenishment lead time. Working with the Source to insure that the DC always gets its replenishments in either 7 or 14 days stabilizes the system, as shown in Figure 4.

 

Click here to enlarge image

Figure 4 - Simulated effects of reducing the lead time for replenishing the DC.

Figure 4 – Simulated effects of reducing the lead time for replenishing the DC.

 

Unfortunately, the intent of reducing the inventory at the DC has not been achieved. The original daily inventory count was about 80 units and remains about 80 units after reducing the DC’s Min and drastically improving the Source-to-DC lead time. But with the simulation model, the planning team can try out other ideas until they arrive at a satisfactory redesign. Or, given that Figure 4 shows the DC inventory starting to flirt with zero, they might think it prudent to accept the need for an average of about 80 units at the DC and look for ways to trim inventory investment at the WHs instead.

 

The Takeaways

  1. Multiechelon inventory optimization (MEIO) is complex. Many factors interact to produce system behaviors that can be surprising in even simple two-level systems.
  2. Monte Carlo simulation is a useful tool for planners who need to design new systems or tweak existing systems.

 

 

 

Leave a Comment
Related Posts
The Supply Chain Blame Game:  Top 3 Excuses for Inventory Shortage and Excess

The Supply Chain Blame Game: Top 3 Excuses for Inventory Shortage and Excess

The supply chain has become the blame game for almost any industrial or retail problem. Shortages on lead time variability, bad forecasts, and problems with bad data are facts of life, yet inventory-carrying organizations are often caught by surprise when any of these difficulties arise. So, again, who is to blame for the supply chain chaos? Keep reading this blog and we will try to show you how to prevent product shortages and overstocking.

Fact and Fantasy in Multiechelon Inventory Optimization

For most small-to-medium manufacturers and distributors, single-level or single-echelon inventory optimization is at the cutting edge of logistics practice. Multi-echelon inventory optimization (“MEIO”) involves playing the game at an even higher level and is therefore much less common. This blog is the first of two. It aims to explain what MEIO is, why standard MEIO theories break down, and how probabilistic modeling through scenario simulation can restore reality to the MEIO process. The second blog will show a particular example.

 

Definition of Inventory Optimization

An inventory system is built on a set of design choices.

The first choice is the policy for responding to stockouts: Do you just lose the sale to a competitor, or can you convince the customer to accept a backorder? The former is more common with distributors than manufacturers, but this may not be much of a choice since customers may dictate the answer.

The second choice is the inventory policy. These divide into “continuous review” and “periodic review” policies, with several options within each type. You can link to a video tutorial describing several common inventory policies here.  Perhaps the most efficient is known to practitioners as “Min/Max” and to academics as (s, S) or “little S, Big S.” We use this policy in the scenario simulations below. It works as follows: When on-hand inventory drops to or below the Min (s), an order is placed for replenishment. The size of the order is the gap between the on-hand inventory and the Max (S), so if Min is 10, Max is 25 and on-hand is 8, it’s time for an order of 25-8 = 17 units.

The third choice is to decide on the best values of the inventory policy “parameters”, e.g., the values to use for Min and Max. Before assigning numbers to Min and Max, you need clarity on what “best” means for you. Commonly, best means choices that minimize inventory operating costs subject to a floor on item availability, expressed either as Service Level or Fill Rate. In mathematical terms, this is a “two-dimensional constrained integer optimization problem”. “Two-dimensional” because you have to pick two numbers: Min and Max. “Integer” because Min and Max have to be whole numbers. “Constrained” because you must pick Min and Max values that give a high-enough level of item availability such as service levels and fill rates. “Optimization” because you  want to get there with the lowest operating cost (operating cost combines holding, ordering and shortage costs).

 

Multiechelon Inventory Systems

The optimization problem becomes more difficult in multi-echelon systems. In a single-echelon system, each inventory item can be analyzed in isolation: one pair of Min/Max values per SKU. Because there are more parts to a multiechelon system, there is a bigger computational problem.

Figure 1 shows a simple two-level system for managing a single SKU. At the lower level, demands arrive at multiple warehouses. When those are in danger of stocking out, they are resupplied from a distribution center (DC). When the DC itself is in danger of stocking out, it is supplied by some outside source, such as the manufacturer of the item.

The design problem here is multidimensional: We need Min and Max values for 4 warehouses and for the DC, so the optimization occurs in 4×2+1×2=10 dimensions. The analysis must take account of a multitude of contextual factors:

  • The average level and volatility of demand coming into each warehouse.
  • The average and variability of replenishment lead times from the DC.
  • The average and variability of replenishment lead times from the source.
  • The required minimum service level at the warehouses.
  • The required minimum service level at the DC.
  • The holding, ordering and shortage costs at each warehouse.
  • The holding, ordering and shortage costs at the DC.

As you might expect, seat-of-the-pants guesses won’t do well in this situation. Neither will trying to simplify the problem by analyzing each echelon separately. For instance, stockouts at the DC increase the risk of stockouts at the warehouse level and vice versa.

This problem is obviously too complicated to try to solve without help from some sort of computer model.

 

Why Standard Inventory Theory is Bad Math

With a little looking, you can find models, journal articles and book about MEIO. These are valuable sources of information and insight, even numbers. But most of them rely on the expedient of over-simplifying the problem to make it possible to write and solve equations. This is the “Fantasy” referred to in the title.

Doing so is a classic modeling maneuver and is not necessarily a bad idea. When I was a graduate student at MIT, I was taught the value of having two models: a small, rough model to serve as a kind of sighting scope and a larger, more accurate model to produce reliable numbers. The smaller model is equation-based and theory-based; the bigger model is procedure-based and data-based, i.e., a detailed system simulation. Models based on simple theories and equations can produce bad numerical estimates and even miss whole phenomena. In contrast, models based on procedures (e.g., “order up to the Max when you breach the Min”) and facts (e.g., the last 3 years of daily item demand) will require a lot more computing but give more realistic answers. Luckily, thanks to the cloud, we have a lot of computing power at our fingertips.

Perhaps the greatest modeling “sin” in the MEIO literature is the assumption that demands at all echelons can be modeled as purely random Poisson processes. Even if it were true at the warehouse level, it would be far from true at the DC level. The Poisson process is the “white rat of demand modeling” because it is simple and permits more paper-and-pencil equation manipulation. Since not all demands are Poisson shaped, this results in unrealistic recommendations.

 

Scenario-based Simulation Optimization

To get realism, we must get down into the details of how the inventory systems operate at each echelon. With few limits except those imposed by hardware such as size of memory, computer programs can keep up any level of complexity. For instance, there is no need to assume that each of the warehouses faces identical demand streams or has the same costs as all the others.

A computer simulation works as follows.

  1. The real-world demand history and lead time history are gathered for each SKU at each location.
  2. Values of inventory parameters (e.g., Min and Max) are selected for trial.
  3. The demand and replenishment histories are used to create scenarios depicting inputs to the computer program that encodes the rules of operation of the system.
  4. The inputs are used to drive the operation of a computer model of the system with the chosen parameter values over a long period, say one year.
  5. Key performance indicators (KPI’s) are calculated for the simulated year.
  6. Steps 2-5 are repeated many times and the results averaged to link parameter choices to system performance.
  7.  

Inventory optimization adds another “outer loop” to the calculations by systematically searching over the possible values of Min and Max. Among those parameter pairs that satisfy the item availability constraint, further search identifies the Min and Max values that result in the lowest operating cost.

Fact and Fantasy in Multiechelon Inventory Optimization

Figure 1: General structure of one type of two-level inventory system

 

Stay Tuned for our next Blog

COMING SOON. To see an example of a simulation of the system in Figure 1, read the second blog on this topic

 

 

Leave a Comment
Related Posts
The Supply Chain Blame Game:  Top 3 Excuses for Inventory Shortage and Excess

The Supply Chain Blame Game: Top 3 Excuses for Inventory Shortage and Excess

The supply chain has become the blame game for almost any industrial or retail problem. Shortages on lead time variability, bad forecasts, and problems with bad data are facts of life, yet inventory-carrying organizations are often caught by surprise when any of these difficulties arise. So, again, who is to blame for the supply chain chaos? Keep reading this blog and we will try to show you how to prevent product shortages and overstocking.

Inventory Planning Becomes More Interesting

The Smart Forecaster

 Pursuing best practices in demand planning,

forecasting and inventory optimization

Taiichi Ohno of Toyota is credited with inventing Just-In-Time (JIT) manufacturing in the 1950s. JIT ensures that a manufacturer produces only what is needed, only when required, and only in the necessary amount. That innovation has since had major impacts, some good, some less so.

A recent New York Times article “How the World Ran out of Everything” describes some of the “less so” impacts.  For example, JIT has kept inventory costs very low improving return on assets.  This in turn is rewarded by Wall Street, so many companies have spent the last few decades reducing their inventories dramatically. Focused as they were on financials, many companies ignored the risks inherent in reducing inventories to the point that “lean” began to border on “emaciated.” Combined with increased globalization and new risks of supply interruption, stock-outs have abounded.

Some industries have gone too far, leaving them exposed to disruption. In a competition to get to the lowest cost, companies have inadvertently concentrated their risk, been interrupted by shortages of raw materials or components, and sometimes forced to halt assembly lines. Wall Street does not look kindly on production halts.

We all know that random events have added to the problem. First among them has been the Covid pandemic. As the pandemic has hindered factory operations and spread disarray in global shipping, many economies worldwide have been tormented by shortages of an immense range of goods — from computer chips to lumber to clothing.

The damage is compounded when more unexpected things go wrong. The Suez Canal Blockage is a prime example, obstructing the main trade route between Europe and Asia. Recently, cyberattacks have added another layer of disruption.

The reaction creates its own problems, just as the cyberattack on the Colonial Pipeline created gas shortages through panic buying. Suppliers start filling orders more slowly than usual. Manufacturers and distributors reverse course and increase inventories and diversify their suppliers to avoid future stockouts. Simply expanding warehouses may not deliver the solution, and the need to determine how much inventory to keep is more urgent every day.Manager In Warehouse With Inventory Management Software

So how can you execute a real-world plan for JIT inventory amidst all this risk and uncertainty? The foundation of your response is your corporate data. Uncertainty has two sources: supply and demand. You need the facts for both.

On the supply side, exploit the data you have on recent supplier lead times, which reflect the current turbulence. Don’t use average values when you can use probability distributions that reflect the full range of contingencies. Consider this comparison. Supplier A is now reliably filling orders in exactly 10 days. Supplier B also averages 10 days but does with a 78%/22% mix of 7 and 21 days. Both A and B have an average replenishment delay of 10 days, but the operational results they provide will be very different. You can only recognize this if you use probability models of inventory performance.

On the demand side, similar considerations apply. First, recognize that there may have been a major shift in the character of item demand (statisticians call this a “regime change”), so purge from your analysis any data that represent the “good old days.” Then, again, stop thinking in terms of averages. While the average demand is important, it is not a sufficient descriptor of the problem you face. Equally important is the volatility of demand. Volatility is the reason you keep inventory in the first place. If demand were completely predictable, you would have neither stockouts nor excess inventory. Just as you need to estimate the full probability distribution of replenishment lead times, you need the full distribution of demand values.

Once you understand the range of variability in both supply and demand, probabilistic forecasting will allow you to account for disruptions and unusual events. Software will convert your data on demand and lead times into huge numbers of scenarios representing how your next planning period might play out. Given those scenarios, the software can determine how best to meet your goals for such metrics as inventory costs and stockout rates. Using solutions such as Smart Inventory Optimization , you will confidently plan based on your targeted stockout risk with minimal inventory carrying cost. You may also consider letting the solution prescribe optimal service level targets by assessing the costs of additional inventory vs. stockout cost.

In inventory planning, as in science, we cannot escape the reality of uncertainty and the impact of unusual events. We must plan accordingly: using inventory optimization software helps you identify the least-cost service level. This creates a coherent, company-wide effort that combines visibility into current operations with mathematically correct assessments of future risks and conditions.

Inventory planning has become more “interesting” and requires a greater degree of risk awareness and agility. The right software can help.

 

Leave a Comment

Related Posts

Call an Audible to Proactively Counter Supply Chain Noise

Call an Audible to Proactively Counter Supply Chain Noise

You know the situation: You work out the best way to manage each inventory item by computing the proper reorder points and replenishment targets, then average demand increases or decreases, or demand volatility changes, or suppliers’ lead times change, or your own costs change.

Recent Posts

  • Epicor Prophet 21 with Forecasting Inventory PlanningExtend Epicor Prophet 21 with Smart IP&O’s Forecasting & Dynamic Reorder Point Planning
    Smart Inventory Planning & Optimization (Smart IP&O) can help with inventory ordering functionality in Epicor P21, reduce inventory, minimize stockouts and restore your organization’s trust by providing robust predictive analytics, consensus-based forecasting, and what-if scenario planning. […]
  • Supply Chain Math large-scale decision-making analyticsSupply Chain Math: Don’t Bring a Knife to a Gunfight
    Math and the supply chain go hand and hand. As supply chains grow, increasing complexity will drive companies to look for ways to manage large-scale decision-making. Math is a fact of life for anyone in inventory management and demand forecasting who is hoping to remain competitive in the modern world. Read our article to learn more. […]
  • Mature bearded mechanic in uniform examining the machine and repairing it in factoryService Parts Planning: Planning for consumable parts vs. Repairable Parts
    When deciding on the right stocking parameters for spare and replacement parts, it is important to distinguish between consumable and repairable servoce parts. These differences are often overlooked by inventory planning software and can result in incorrect estimates of what to stock. Different approaches are required when planning for consumables vs. repairable service parts. […]
  • Four Common Mistakes when Planning Replenishment TargetsFour Common Mistakes when Planning Replenishment Targets
    How often do you recalibrate your stocking policies? Why? Learn how to avoid key mistakes when planning replenishment targets by automating the process, recalibrating parts, using targeting forecasting methods, and reviewing exceptions. […]
  • Smart Software is pleased to introduce our series of webinars, offered exclusively for Epicor Users.Extend Epicor Kinetic’s Forecasting & Min/Max Planning with Smart IP&O
    Epicor Kinetic can manage replenishment by suggesting what to order and when via reorder point-based inventory policies. The problem is that the ERP system requires that the user either manually specify these reorder points, or use a rudimentary “rule of thumb” approach based on daily averages. In this article, we will review the inventory ordering functionality in Epicor Kinetic, explain its limitations, and summarize how to reduce inventory, and minimize stockouts by providing the robust predictive functionality that is missing in Epicor. […]

    Inventory Optimization for Manufacturers, Distributors, and MRO

    • Blanket Orders Smart Software Demand and Inventory Planning HDBlanket Orders
      Our customers are great teachers who have always helped us bridge the gap between textbook theory and practical application. A prime example happened over twenty years ago, when we were introduced to the phenomenon of intermittent demand, which is common among spare parts but rare among the finished goods managed by our original customers working in sales and marketing. This revelation soon led to our preeminent position as vendors of software for managing inventories of spare parts. Our latest bit of schooling concerns “blanket orders.” […]
    • Hand placing pieces to build an arrowProbabilistic Forecasting for Intermittent Demand
      The New Forecasting Technology derives from Probabilistic Forecasting, a statistical method that accurately forecasts both average product demand per period and customer service level inventory requirements. […]
    • Engineering to Order at Kratos Space – Making Parts Availability a Strategic Advantage
      The Kratos Space group within National Security technology innovator Kratos Defense & Security Solutions, Inc., produces COTS s software and component products for space communications - Making Parts Availability a Strategic Advantage […]
    • wooden-figures-of-people-and-a-magnet-team-management-warehouse inventoryManaging the Inventory of Promoted Items
      In a previous post, I discussed one of the thornier problems demand planners sometimes face: working with product demand data characterized by what statisticians call skewness—a situation that can necessitate costly inventory investments. This sort of problematic data is found in several different scenarios. In at least one, the combination of intermittent demand and very effective sales promotions, the problem lends itself to an effective solution. […]