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

Leveraging ERP Planning BOMs with Smart IP&O to Forecast the Unforecastable

Leveraging ERP Planning BOMs with Smart IP&O to Forecast the Unforecastable

In a highly configurable manufacturing environment, forecasting finished goods can become a complex and daunting task. The number of possible finished products will skyrocket when many components are interchangeable. A traditional MRP would force us to forecast every single finished product which can be unrealistic or even impossible. Several leading ERP solutions introduce the concept of the “Planning BOM”, which allows the use of forecasts at a higher level in the manufacturing process. In this article, we will discuss this functionality in ERP, and how you can take advantage of it with Smart Inventory Planning and Optimization (Smart IP&O) to get ahead of your demand in the face of this complexity.

Finding Your Spot on the Tradeoff Curve

Finding Your Spot on the Tradeoff Curve

Managing inventory, like managing anything, involves balancing competing priorities. Do you want a lean inventory? Yes! Do you want to be able to say “It’s in stock” when a customer wants to buy something? Yes!
But can you have it both ways? Only to a degree. If you lean into leaning your inventory too aggressively, you risk stockouts. If you stamp out stockouts, you create inventory bloat. You are forced to find a satisfactory balance between the two competing goals of lean inventory and high item availability.