Improve Forecast Accuracy, Eliminate Excess Inventory, & Maximize Service Levels

In this Video Dr. Thomas Willemain, co–Founder and SVP Research, talks about forecast-based inventory management policy, also known as MRP logic. This is the fourth in our series on major approaches to managing inventory.  We begin by looking at some very simple and then more robust models of inventory dynamics that help us determine how much to order or manufacture and when. We then consider how to calculate lead time and account for lead time variability. Tom concludes by describing the importance of safety stock, it’s role in properly buffering against demand and supply uncertainty, and how best to calculate it. 

What is a Min/Max policy? How do you know is working well for you? Smart IP&O gets Min/Max right!

The Min/Max inventory policy is one of four available Replenishment methods in SIO. When the inventory level drops to or below the Min, a replenishment order is generated. The reorder quantity is the number of units needed to raise the stock up to the Max. How do you know your Min/Max settings are working well and triggering replenishment orders at the right time and for the right quantities? If you are like most companies, setting Min/Max levels is based on rules of thumb or simple averaging techniques that don’t expose the trade off curve between service level and inventory cost. This makes it impossible to predict which items are likely to have overstocks and shortages in the future. In this Video Blog we elaborate on this and describe how Smart Inventory Optimization can help.

This blog defines and compares the three most commonly used inventory control policies. It should be helpful both to those new to the field and also to experienced people contemplating a possible change in their company’s policy. The blog also considers how demand forecasting supports inventory management, choice of which policy to use, and calculation of the inputs that drive these policies. Think of it as an abbreviated piece of Inventory 101.

Scenario

You are managing a particular item. The item is important enough to your customers that you want to carry enough inventory to avoid stocking out. However, the item is also expensive enough that you also want to minimize the amount of cash tied up in inventory. The process of ordering replenishment stock is sufficiently expensive and cumbersome that you also want to minimize the number of purchase orders you must generate. Demand for the item is unpredictable.  So is the replenishment lead time between when you detect the need for more and when it arrives on the shelf ready for use or shipment. 

Your question is “How do I manage this item? How do I decide when to order more and how much to order?”  When making this decision there are different approaches you can use.  This blog outlines the most commonly used inventory planning policies:  Periodic Order Up To (T, S), Reorder Point/Order Quantity (R, Q), and Min/Max (s, S).  These approaches are often embedded in ERP systems and enable companies to generate automatic suggestions of what and when to order.  To make the right decision, you’ll need to know how each of these approaches are designed to work and the advantages and limitations of each approach.    

Periodic review, order-up-to policy

The shorthand notation for this policy is (T, S), where T is the fixed time between orders and S is the order-up-to-level.

When to order: Orders are placed like clockwork every T days. The used of a fixed reorder interval is helpful to firms that cannot keep track of their inventory level in real time or who prefer to issue orders to suppliers at scheduled intervals.

How much to order: The inventory level is measured and the gap computed between that level and the order-up-to level S. If the inventory level is 7 units and S = 10, then 3 units are ordered.

Comment: This is the simplest policy to implement but also the least agile in responding to fluctuations in demand and/or lead time. Also, note that, while the order size would be adequate to return the inventory level to S if replenishment were immediate, in practice there will be some replenishment delay during which time the inventory continues to drop, so the inventory level will rarely reach all the way up S.

Continuous review, fixed order quantity policy (Reorder Point, Order Quantity)

The shorthand notation for this policy is (R, Q), where R is the reorder point and Q is the fixed order quantity.

When to order: Orders are placed as soon as the inventory drops to or below the reorder point, R. In theory, the inventory level is checked constantly, but in practice it is usually checked periodically at the beginning or end of each workday. 

How much to order: The order size is always fixed at Q units.

Comment: (R, Q) is more responsive than (S, T) because it reacts more quickly to signs of imminent stockout. The value of the fixed order quantity Q may not be entirely up to you. Often suppliers can dictate terms that restrict your choice of Q to values compatible with minima and multiples. For example, a supplier may insist on an order minimum of 20 units and always be a multiple of 5. Thus orders sizes must be either 20, 25, 30, 35, etc. (This comment also applied to the two other inventory policies.)

Continuous review, order-up-to policy (Min/Max)

The shorthand notation for this policy is (s, S), sometimes called “little s, big S” where s is the reorder point and S is the order-up-to level. This policy is more commonly called (Min, Max).

When to order: Orders are placed as soon as the inventory drops to or below the Min. As with (R, Q), the inventory level is supposedly monitored constantly, but in practice it is usually checked at the end of each workday. 

How much to order: The order size varies. It equals the gap between the Max and the current inventory at the moment that the Min is reached or breached.

Comment: (Min, Max) is even more responsive than (R, Q) because it adjusts the order size to take account of how much the inventory has fallen below the Min. When demand is either zero or one units, a common variation sets Min = Max -1; this is called the “base stock policy.”

Another policy choice: What happens if I stock out?

As you can imagine, each policy is likely to lead to a different temporal sequence of inventory levels (see Figure 1 below). There is another factor that influences how events play out over time: the policy you select for dealing with stockouts. Broadly speaking, there are two main approaches.

Backorder policy: If you stock out, you keep track of the order and fill it later.  Under this policy, it is sensible to speak of negative inventory. The negative inventory represents the number of backorders that need to be filled. Presumably, any customer forced to wait gets first dibs when replenishment arrives. You are likely to have a backorder policy on items that are unique to your business that your customer cannot purchase elsewhere.

Loss policy: If you stock out, the customer turns to another source to fill their order. When replenishment arrives, some new customer will get those new units. Inventory can never go below zero.  Choose this policy for commodity items that can easily be purchased from a competitor.  If you don’t have it in stock, your customer will most certainly go elsewhere. 

The role of demand forecasting in inventory control

Choice of control parameters, such as the values of Min and Max, requires inputs from some sort of demand forecasting process.

Traditionally, this has meant determining the probability distribution of the number of units that will be demanded over a fixed time interval, either the lead time in (R, Q) and (Min, Max) systems or T + lead time in (T, S) systems. This distribution has been assumed to be Normal (the famous “bell-shaped curve”).  Traditional methods have been expanded where the demand distribution isn’t assumed to be normal but some other distribution (i.e. Poisson, negative binomial, etc.) 

These traditional methodologies have several deficiencies.

• First, it usually ignores the problem of undershoot, in which demand drops inventory not just to the reorder point but below it. Assuming no undershoot leads to overestimates of service levels and fill rates.

• Second, the probability distribution of demand is very often not even close to “bell-shaped” or whatever assumed distribution was selected –  especially for items with intermittent demand such as spares and service parts.

• Third, accurate estimates of inventory operating costs require analysis of the entire replenishment cycle (from one replenishment to the next), not merely the part of the cycle that begins with inventory hitting the reorder point.

• Finally, replenishment lead times are typically unpredictable or random, not fixed. Many models assume a fixed lead time based on an average, vendor quoted lead time, or average lead time + safety time.

Fortunately, better inventory planning and inventory optimization software exists based on generating a full range of random demand scenarios, together with random lead times. These scenarios “stress test” any proposed pair of inventory control parameters and assess their expected performance. Users can not only choose between policies (i.e. Min, Max vs. R, Q) but also determine which variation of the proposed policy is best (i.e. Min, Max of 10,20 vs. 15, 25, etc.) Examples of these scenarios are given below.

The process of ordering replenishment stock is sufficiently expensive and cumbersome that you also want to minimize the number of purchase orders you must generate

Choosing among inventory control policies

Which policy is right for you? There is a clear pecking order in terms of item availability, with (Min, Max) first, (R, Q) second, and (T, S) last. This order derives from the responsiveness of the policy to fluctuations in the randomness of demand and replenishment. The order reverses when considering ease of implementation.

How do you “score” the performance of an inventory policy? There are two opposing forces that must be balanced: cost and service.

Inventory cost can be expressed either as inventory investment or inventory operating cost. The former is the dollar value of the items waiting around to be used. The latter is the sum of three components: holding cost (the cost of the “care and feeding of stuff on the shelf”), ordering cost (basically the cost of cutting a purchase order and receiving that order), and shortage cost (the penalty you pay when you either lose a sale or force a customer to wait for what they want).

Service is usually measured by service level and fill rate.  Service level is the probability that an item requested is shipped immediately from stock. Fill rate is the proportion of units demanded that are shipped immediately from stock. As a former professor, I think of service level as an all-or-nothing grade: If a customer needs 10 units and you can provide only 9, that’s an F. Fill rate is a partial credit grade: 9 out of 10 is 90%.

When you decide on the values of inventory control policies, you are striking a balance between cost and service. You can provide perfect service by keeping an infinite inventory. You can hold costs to zero by keeping no inventory. You must find a sensible place to operate between these two ridiculous extremes. Generating and analyzing demand scenarios can quantify the consequences of your choices.

A demonstration of the differences between two inventory control policies

We now show how on-hand inventory evolves differently under two policies. The two policies are (R, Q) and (Min, Max) with backorders allowed. To keep the comparison fair, we set Min = R and Max = R+Q, use a fixed lead time of five days, and subject both policies to the same sequence of daily demands over 365 simulated days of operation.

Figure 1 shows daily on-hand inventory under the two policies subjected to the same pattern of daily demand. In this example, the (Min, Max) policy has only two periods of negative inventory during the year, while the (R, Q) policy has three. The (Min, Max) policy also operates with a smaller average number of units on hand. Different demand sequences will produce different results, but in general the (Min, Max) policy performs better.

Note that the plots of on-hand inventory contain information needed to compute both cost and availability metrics.

Figure 1: Comparison of daily on-hand inventory under two inventory policies

Role of Inventory Planning Software

Best of Breed Inventory Planning, Forecasting, and Optimization systems can help you determine which type of policy (is it better to use Min/Max over R,Q) and what sets of inputs are optimal (i.e. what should I enter for Min and Max).  Best of breed inventory planning and demand forecasting systems can help you develop these optimized inputs so that you can regularly populate and update your ERP systems with accurate replenishment drivers.

Summary

We defined and described the three most commonly used inventory control policies: (T, S), (R, Q) and (Min, Max), along with the two most common responses to stockouts: backorders or lost orders. We noted that these policies require successively greater effort to implement but also have successively better average performance. We highlighted the role of demand forecasts in assessing inventory control policies. Finally, we illustrated how choice of policy influences the day-to-day level of on-hand inventory.

Stop buying everything, from paper clips to software? No. You should get a little bit smart about how you are going to ride it out.

Even in normal times, good inventory hygiene suggests that you continuously update your inventory control parameters: reorder points, order quantities, safety stocks, mins, maxes, lead times. Beyond that, you should be updating your inventory strategies, such as adjusting the target service levels or fill rates for every item you hold. That’s the “should.”

But in normal times, it’s easy enough to let those adjustments slide and focus on other things. Then, when the first whiff of recession is in the air, you might get panicky and jump into action in a way that makes it harder to survive the down times. You may look decisive by essentially freezing in place or even shutting some things down, but you risk looking decisive now and foolish later.

Better to take stock of your entire current inventory operation and do that tuning before things get really bad. It is common enough for inventory parameters like reorder points to be set at their current levels by somebody long gone at some time in the distant past for some reason that nobody remembers. Over time, conditions change but the system fails to adapt. So the start of a possible recession is an apt time to run your inventory optimization software to tune up your operations.

You may find that you can remove enough sludge in your current system to offset some or all of the bad news. For instance, your suppliers might be filling orders faster than your software thinks, so you can reduce inventories without risking more stockouts by recalculating reorder points. If you feel you must reduce stocks and ask your customers to accept lower fill rates, you should use your inventory optimization software to identify the best items to put on the chopping block, rather than, say, adjusting every item’s fill rate down by 5%.  If you have thousands or tens of thousands of inventory items, that kind of laser-focused adjustment may not be humanly possible without good software support. But with good software support, it’s doable and useful.

Before you hit the panic button, be sure to squeeze all the inefficiency out of your current operations. If, as is common, you have good software but your people are using only a fraction of its capabilities, fix that and get more out of the investment. If you don’t have modern inventory optimization, make a counter-cyclical decision and get some.

If you want to read more about demand planning, forecasting and find new business opportunities in economic recession, read this Journal of Business Forecasting article from the Institute of Business Forecasting (IBF) here or keep reading our new articles

Is your data isolated in Excel Silos? Do you have data in many disparate systems? Smart IP&O Solution brings clean, accessible and actionable data under one roof.

Scattering all your data across multiple spreadsheets gets in your way. Pulling all the data together in the Smart Platform on the cloud lets you automatically refresh the data every day and always see the full picture. Then you can run analytics in the Smart Inventory Optimization app to see how you’re doing in terms of multiple cost and performance metrics and how those metrics would change if you changed key drivers, such as supplier lead times.