Service level is a key performance indicator for companies that put a premium on satisfying customer demand. Service level is defined as the probability of surviving a replenishment lead time without stocking out.

Inventory management best practice begins with setting service level targets, then calculates reorder points (also called Mins) to achieve those targets. These calculations should account for variability in both demand and replenishment lead time. There are many software systems available for doing these calculations. If everything works out, the achieved service level ends up very close to the target service level. Unfortunately, there is often a painful gap between the two.

One reason for the gap is unrealistic models of demand. In many cases, software for calculating reorder points uses textbook formulas based on mathematical assumptions that make analysis simple at the expense of realism.  Many “Inventory 101” textbooks use formulas that assume demand has a Normal distribution (a.k.a. the “bell-shaped curve”) for finished goods and the Poisson distribution for spare parts. Fortunately, there are now inventory optimization and forecasting systems that process the actual demand histories of the inventory items using probabilistic forecasting.  These solutions calculate an accurate estimate of the distribution – not some idealized version.  To learn more check out this past blog on probabilistic forecasting:

But there is a second source of error in textbooks that operates invisibly in many inventory software package:  “undershoot”.

Calculations of reorder points almost always assume that stockouts arise when the total demand during a replenishment interval exceeds the reorder point. For example, assume that demand averages 1 unit per day. If lead time is 5 days, then on average lead time demand is 5 units. Setting the reorder point at 5 units would yield a laughable service level somewhere in the vicinity of 50%. Adding safety stock to the calculation might result in a reorder point of, say, 11 units, which might correspond to a service level of 95%. Another way to say this is, starting at a reorder point of 11 units, there should be a 95% chance of surviving the 5 day lead time without experiencing cumulative demand of more than 11 units. Theoretically!

What’s missing from this analysis is the undershoot phenomenon. Undershoot means that the lead time begins not at the reorder point but below it. Undershoot happens every time the demand that breached the reorder point took the stock down below (not down to) the reorder point. The figure below shows replenishment cycles with and without undershoot.  Undershoot picks your pocket before you even begin to roll the dice. It deludes the inventory professional into thinking his or her reorder points are sufficient to achieve their targets, whereas actual performance will not make the grade.

There is only one situation in which undershoot is not a worry: when demand is always either zero or one unit. In that case, undershoot is impossible. But in all other cases, undershoot is sure to happen to some extent, and it can seriously undercut the service level actually achieved by a given choice of reorder point. Our analyses show that the conditions most vulnerable to undershoot involve highly intermittent and skewed demand with very short lead times – the very conditions being made most common by market trends.

What can be done to protect yourself from the effect of undershoot on reorder point calculations?  Use inventory optimization and forecasting software that isn’t tied to the old textbook assumptions and instead automatically accounts for undershoot when calculating the service level produced by any choice of reorder point.

To see Smart Software’s Inventory Optimization solution in action, register to see a recorded demo below:

Most demand forecasts are partial or incomplete: They provide only one single number: the most likely value of future demand. This is called a point forecast. Usually, the point forecast estimates the average value of future demand.

Much more useful is a forecast of full probability distribution of demand at any future time. This is more commonly referred to as probability forecasting and is much more useful.

The Average is Not the Answer

The one advantage of a point forecast is its simplicity. If your ERP system is also simple, the point forecast fills in the one number needed by the ERP system to do workforce scheduling or raw material purchases.

The disadvantage of a point forecast is that it is too simple. It ignores additional information in an item’s demand history that can give you a more complete picture of how demand might unfold: a probability forecast.

Going Beyond the Average: Probability Forecasting

While the point forecast provides limited information, e.g., “The most likely demand next month is 15 units”, the probability forecast adds crucial information, e.g., “There is a 20% chance that demand will exceed 28 units and a 10% chance that it will be less than 5 units”.

This information lets you do risk assessment and contingency planning. Contingency planning is necessary because the point forecast usually has only a small chance of actually being correct. A probability forecast may also say “The chance of demand being 15 units is only 10%, even though it is the single most likely value.” In other words, there is a 90% chance that the point forecast is wrong. This kind of error is not a mistake in the forecasting calculations: it is the reality of dealing with demand volatility. It might better be called an “uncertainty” than an “error”.

An operations manager can use the extra information in a probability forecast in both informal and formal ways. Informally, even if an ERP system requires a single-number forecast as input, a wise manager will want to have some clue about the risks associated with that point forecast, i.e., its margin of error. So a forecast of 15 ± 1 unit is a lot safer than a forecast of 15 ± 10. The ± part is a compression of a probabilistic forecast. Figure 1 below shows an item’s demand history (red line), point forecasts for the next 12 months (green line) and their margins of error (cyan lines). The lowest forecast of about 3,300 units occurs in June, but the actual demand might be as much as 800 units higher or lower.

Bonus: Application to Inventory Management

Inventory management requires that you balance item availability against the inventory cost. It turns out that knowing the full probability distribution of demand over a replenishment lead time is essential for setting reorder points (also called mins) on a rational, scientific basis. Figure 2 shows a probability forecast of total demand during the 33 week replenishment lead time for a certain spare part. While the average lead time demand is 3 units, the most likely demand is zero, and a reorder point of 14 is needed to insure that the chance of stocking out is only 1%. Once again, the average is not the answer.

Knowing more is always better than knowing less and the probability forecast provides that extra bit of crucial information. Software has been able to supply a point forecast for over 40 years, but modern software can do better and provide the whole picture.

Figure 1: The red line shows the demand history of a finished good. The green line shows the point forecasts for the next 12 months. The blue lines indicate the margins of error in the 12 point forecasts.

Figure 2: A probabilistic forecast of demand for a spare part over a 33 week replenishment lead time. The most likely demand is zero, the average demand is 3, but a reorder point of 14 units is required to have only a 1% chance of stock out.

We are often asked what the difference is between these two important performance metrics for inventory planning. While they are both important for measuring how successful a business is in meeting demand, their meaning is very different.  If not understood and incorporated into the strategic inventory planning process, inventory will be inefficiently allocated resulting in lower customer service and higher carrying costs.  We’ve illustrated the difference in this 4 minute recording using Microsoft Excel.

Smart Operational Analytics automatically calculates historical service levels & fill rates across any item.  To see how you calculate these and other operational metrics including inventory turns, supplier performance, and more register below to watch a five minute demonstration.  The demo will show how our cloud platform continuously calculates and reports these metrics across thousands of items helping you identify opportunities for service level improvement and inventory reduction.

Summary

Setting a target service level or fill rate is a strategic decision about inventory risk management. Choosing service levels can be difficult. Relevant factors include current service levels, replenishment lead times, cost constraints, the pain inflicted by shortages on you and your customers, and your competitive position. Target setting is often best approached as a collaboration among operations, sales and finance. Inventory optimization software is an essential tool in the process.

Service Level Choices

Service level is the probability that no shortages occur between when you order more stock and when it arrives on the shelf. The reasonable range of service levels is from about 70% to 99%. Levels below 70% may signal that you don’t care about or can’t handle your customers. Levels of 100% are almost never appropriate and usually indicate a hugely bloated inventory.

Factors Influencing Choice of Service Level

Several factors influence the choice of service level for an inventory item. Here are some of the more important.

Current service levels:
A reasonable place to start is to find out what your current service levels are for each item and overall. If you are already in good shape, then the job becomes the easier one of tweaking an already-good solution. If you are in bad shape now, then setting service levels can be more difficult. Surprisingly few companies have data on this important metric across their whole fleet of inventory items. What often happens is that reorder points grow willy-nilly from choices made in corporate pre-history and are rarely, sometimes never, systematically reviewed and updated. Since reorder points are a major determinant of service levels, it follows that service levels “just happen”. Inventory optimization software can convert your current reorder points and lead times into solid estimates of your current service levels. This analysis often reveals subset of items with service levels either too high or too low, in which case you have guidance about which items to adjust down or up, respectively.

Replenishment lead times:
Some companies adjust service levels to match replenishment lead times. If it takes a long time to make or buy an item, then it takes a long time to recover from a shortage. Accordingly, they bump up service levels on long-lead-time items and reduce them on items for which backlogs will be brief.

Cost constraints:
Inventory optimization software can find the lowest-cost ways to hit high service level targets, but aggressive targets inevitably imply higher costs. You may find that costs constrain your choice of service level targets. Costs come in various flavors. “Inventory investment” is the dollar value of inventory. “Operating costs” include both holding costs and ordering costs. Constraints on inventory investment are often imposed on inventory executives and always imply ceilings on service level targets; software can make these relationships explicit but not take away the necessity of choice. It is less common to hear of ceilings on operating costs, but they are always at least a secondary factor arguing for lower service levels.

Shortage costs:
Shortage costs depend on whether your shortage policy calls for backorders or lost sales. In either case, shortage costs work counter to inventory investment and operating costs by arguing for higher service levels. These costs may not always be expressed in dollar terms, as in the case of medical/surgical supplies, where shortage costs are denominated in morbidity and mortality.

Competition:
The closer your company is to dominating its market, the more you can ease back on service levels to save money. However, easing back too far carries risks: It encourages potential customers to look elsewhere, and it encourages competitors. Conversely, high product availability can go far to bolstering the position of a minor player.

Collaborative Targeting

Inventory executives may be the ones tasked with setting service level targets, but it may be best to collaborate with other functions when making these calls. Finance can share any “red lines” early in the process, and they should be tasked with estimating holding and ordering costs. Sales can help with estimating shortage costs by explaining likely customer reactions to backlogs or lost sales.

The Role of Inventory Optimization and Planning Software

Without inventory optimization software, setting service level targets is pure guesswork: It is impossible to know how any given target will play out in terms of inventory investment, operating costs, shortage costs. The software can compute the detailed, quantitative tradeoff curves required to make informed choices or even recommend the target service level that results in the lowest overall cost considering holding costs, ordering costs, and stock out costs. However, not all software solutions are created equal. You might enter a user defined 99% service level into your inventory planning system or the system could recommend a target service – but it doesn’t mean you will actually hit that stated service level. In fact, you might not even come close to hitting it and achieve a much lower service level. We’ve observed situations where a targeted service level of 99% actually achieved a service level of just 82%! Any decisions made as a result of the target will result in unintended misallocation of inventory, very costly consequences, and lots of explaining to do. So be sure to check out our next blog article on how to measure the accuracy of your service level forecast so you don’t make this costly mistake.

Demand planning takes time and effort. It’s worth the effort to the extent that it actually helps you make what you need when you need it.

But the job can be done well or poorly. We see many manufacturers stopping at the first level when they could easily go to the second level. And with a little more effort, they could go all the way to the third level, utilizing probabilistic modeling to convert demand planning results into an inventory optimization process.

The First Level

The first level is making a demand forecast using statistical methods. Figure 1 shows a first level effort: an item’s demand history (red line) and its expected 12-month forecast (green line).

The forecast is bare bones. It only projects expected demand ignoring that demand is volatile and will inevitably create forecast error. (This is another example of an important maxim: “The Average is Not the Answer”). The forecast is as likely to be too high as it is to be too low, and there is no indication of forecast uncertainty accompanying the forecast. This means the planner has no estimate of the risk associated with committing to the forecast. Still, this forecast does provide a rational basis for production planning, personal scheduling, and raw materials purchase. So, it’s much better than guessing.

The Second Level

The second level takes explicit account of forecast uncertainty. Figure 2 shows a second level effort, known as a “percentile forecast”.

Now we see an explicit indication of forecast uncertainty. The cyan line above the green forecast line represents the projected 90th percentile of monthly demand. That is, the demand in each future month has a 90% chance of falling at or below the cyan line. Put another way, there is a 10% chance of demand exceeding the cyan line in each month.

This analysis is much more useful because it supports risk management. If it is important to assure sufficient supply of this item, then it makes sense to produce to the 90th percentile instead of to the expected forecast. After all, it’s a coin flip as to whether the expected forecast will result in enough production to meet monthly demand. This second level forecast is, in effect, a rough substitute for a careful inventory management process.

Figure 2. A percentile forecast, where the cyan line estimates the 90th percentiles of monthly demand.

Going All the Way to the Third Level

Best practice is the Third Level, which uses demand planning as a foundation for completing a second task: explicit inventory optimization. Figure 3 shows the fundamental plot for the efficient management of our finished good, assuming it has a 1 month production lead time.

Figure 3 shows the utilization of probabilistic forecasting and how much draw-down in finished good inventory might take place over a one month production lead time. The uncertainty in demand is apparent in the spread of the possible demand, from a low of 0 to a high of 35, with 15 units being the most likely value. The vertical red line at 22 indicates the “reorder point“ (or “min” or “trigger value”) corresponding to keeping the chance of stocking out while waiting for replenishment to a low 5%. When inventory drops to 22 or below, it is time to order more. The Third Level uses probabilistic demand forecasting with full exposure of forecast uncertainty to efficiently manage the stock of the finished product.

To Sum Up

Forecasting the most likely demand for an item is a useful first step. It gets you halfway to where you want to be. But it provides an incomplete guide to planning because it ignores demand volatility and the forecast uncertainty that it creates. Adding a cushion to the demand forecast gets you further along, because it lessen the risk that a jump in demand will leave you short of product. This cushion can be calculated by probabilistic forecasting approaches that forecasts a high percentile of the distribution of future demand. And if you want to take one step further, you can feed forecasts of the demand distribution over a lead time to calculate reorder points (mins) to ensure that you have an acceptably low level of stock-out risk.

Given what modern forecasting technology can do for you, why would you want to stop halfway to your goal?

There’s a stale old joke: “There are two types of people – those who believe there are two types of people, and those who don’t.” We can modify that joke: “There are two types of people – those who know there are three types of supply chain analytics, and those who haven’t yet read this blog.”

The three types of supply chain analytics are “descriptive”, “predictive”, and “prescriptive.” Each plays a different role in helping you manage your inventory. Modern supply chain software lets you exploit all three.

Descriptive Analytics

Descriptive Analytics are the stuff of dashboards. They tell you “what’s happenin’ now.” Included in this category are such summary numbers as dollars currently invested in inventory, current customer service level and fill rate, and average supplier lead times. These statistics are useful for keeping track of your operations, especially when you track changes in them from month to month. You will rely on them every day. They require accurate corporate databases, processed statistically.

Predictive Analytics

Predictive Analytics most commonly manifest as forecasts of demand, often broken down by product and location and sometimes also by customer. These statistics provide early warning so you can gear up production, staffing and raw material procurement to satisfy demand. They also provide predictions of the effect of changes in operating policies, e.g., what happens if we increase our order quantity for Product X from 20 to 25 units? You might rely on Predictive Analytics periodically, perhaps weekly or monthly, when you look up from what’s happening now to see what will happen next. Predictive Analytics uses Descriptive Analytics as a foundation but adds more capability. Predictive Analytics for demand forecasting requires advanced statistical processing to detect and estimate such features of product demand as trend, seasonality and regime change.  Predictive Analytics for inventory management uses forecasts of demand as inputs into models of the operation of inventory policies, which in turn provide estimates of key performance metrics such as service levels, fill rates, and operating costs.

Prescriptive Analytics

Prescriptive Analytics are not about what is happening now, or what will happen next, but about what you should do next, i.e., they recommend decisions aimed at maximizing inventory system performance. You might rely on Prescriptive Analytics to best posture your entire inventory policy. Prescriptive Analytics uses Predictive Analytics as a foundation then adds optimization capability. For instance, Prescriptive Analytics software can automatically work out the best choices for future values of Min’s and Max’s for thousands of inventory items. Here, “best” might mean the values of Min and Max for each item that minimize operating cost (the sum of holding, ordering, and shortage costs) while maintaining a 90% floor on item fill rate.

Example

The figure below shows how supply chain analytics can help the inventory manager. The columns show three predicted Key Performance Indicators (KPI’s): service level, inventory investment, and operating costs (holding costs + ordering costs + shortage costs).

 Figure 1: The three types of analytics used to evaluate planning scenarios

The rows show four alternative inventory policies, expressed as scenarios. The “Live” scenario reports on the values of the KPI’s on July 1, 2018. The “99% All” scenario changes the current policy by raising the service level of all items to 99%. The “75 floor/99 ceiling” scenario raises service levels that are too low up to 75% and lowers very high (i.e., expensive) service levels down to 95%. The “Optimization” scenario prescribes item specific service levels that minimizes total operating costs.

The “Live 07-01-2018” scenario is an example of Descriptive Analytics. It shows the current baseline performance. The software then allows the user to try out changes in inventory policy by creating new “What If” scenarios that might then be converted to named scenarios for further consideration. The next two scenarios are examples of Predictive Analytics. They both assess the consequences of their recommended inventory control policies, i.e., recommended values of Min and Max for all items. The “Optimization” scenario is an example of Prescriptive Analytics because it recommends a best compromise policy.

Consider how the three alternative scenarios compare to the baseline “Live” scenario. The “99% All” scenario raises the item availability metrics, increasing service level from 88% to 99%. However, doing so increases the total inventory investment from $3 million to about $4 million. In contrast, the “75 floor/99 ceiling” scenario increases both service level and reduces the cash tied up in inventory by about $300,000. Finally, the “Optimization” scenario achieves an 80% service level, a reduction from the current 88%, but it cuts more than $2 million from the inventory value and reduces operating costs by more than $400,000 annually. From here, managers could try further options, such as giving back some of the $2 million savings to achieve a higher average service level.

Summary

Modern software packages for inventory planning and inventory optimization should offer three kinds of supply chain analytics: Descriptive, Predictive, and Prescriptive. Their combination lets inventory managers track their operations (Descriptive), forecast where their operations will be in the future (Predictive), and optimize their inventory policies in response in anticipation of future conditions (Prescriptive).