## What is inventory optimization?

Inventory optimization is a much-used phrase, but what exactly is it, how do you achieve it and do you in fact even need it? As our mission as a company is to help organisations get value from inventory optimization, this is a topic very close to our heart.

In this article we consider inventory optimization to be the application of mathematical techniques to define ideal inventory levels. Such theoretical models are not easy to apply in practice. The idea that a piece of software can allow you to optimize your inventories simply and automatically is attractive but at present far from possible.

We believe that the biggest value of inventory optimization techniques is in showing you how much better your inventories could be, while the correct interpretation and application of that information is likely to require changes to how you manage your inventory.

The benefits of overcoming these challenges are substantial. Inventory optimization allows you to free up working capital, reduce shortages and obsolescence, reduce your environmental footprint and increase flow through your supply chain, usually by significant amounts.

You will often see any improvement to inventory management described as inventory optimization, but this is not strictly speaking accurate.

In mathematics, optimization means selecting the best option from a set of alternatives. When talking about inventory, this comes down to determining the best amount of inventory to hold to meet your objectives. Inventory optimization mathematically seeks to find the sweet spot between having too much and not enough.

This is a simple concept to grasp in principle, but not to apply in practise. In order to calculate an optimum level mathematically, you need to factor in a number of different considerations, some of which are themselves difficult to quantify.

Let’s say that you want to optimize on purely economic principles – what will make you the most profit? To do this you need to be able to quantify, on the one hand, the true holding cost of inventory and, on the other hand, the cost of shortages, which might include backorder costs, expediting costs, the cost of lost sales and lost market share, even the cost of damage to your brand. Noting that these costs are entwined with each other. It’s not that this is impossible to do, but it is laborious and somewhat imprecise.

In fact, it would be fair to say that few people, if any, actually try to calculate this. Instead, normal practice is to set a target service level, either implicitly or explicitly, and then try to minimize inventories while staying at or above that service level. This is a good, pragmatic move, that ties down one of the more difficult parameters to set. However, even with a pre-defined target service level, it is still challenging to calculate optimum inventory levels.

When it comes to improving inventories, we differentiate between optimizing, which involves working with the givens, and improvements based on changing the givens. What are the givens? They are the parameters you need as inputs to your inventory optimization calculations. We have already considered target service level as a given, but this is just one of many such parameters.

When working with the givens, you accept them as fixed parameters and optimize your inventory levels on that basis. Which is not to say that the givens can’t be improved, but you need such parameters defined to even attempt an optimization calculation.

### How can you optimize your inventories?

Inventory optimization comes down to defining two things for each item: the optimal order quantity/batch size (Q) and the optimal safety stock (SS), noting that the latter might be zero or even negative. But there is no one way to do this for all items you stock, since the method chosen will itself vary depending on a number of factors. Let us start by taking a couple of simple examples.

- You have a product that is
**made to order**. Whenever a customer orders one, you have**10 weeks**to make it. It takes**one week**to make and**4 weeks**to source the parts. Everything you need is**at or above your minimum order quantities**(MOQ’s). You have**no inbound supply variability**or**capacity constraints**. - You have a product that is
**made to stock**. Demand is**relatively stable**, with a**limited amount of variability**,**as is**supply. You check inventory levels of finished goods**continuously**. You**schedule production to avoid stock outs.**You try to maintain raw materials inventory to be able to produce**when needed**.

If anything in bold changes, you will need to factor it into your optimization calculation, along with the other factors shown in Figure 1 above.

Different types of inventory require not just different optimization calculations, but also different planning methodologies.

For the first example above, we can consider a deterministic planning model. This is appropriate when you know what demand is going to be. In this instance, you can set your order and batch sizes to exactly what is required. In principle, you shouldn’t need safety stock, although you might need to have some safety stock to protect against variation in supply, such as late deliveries or quality problems in production.

For the second example, we can consider a replenishment model. This is appropriate for make-to-stock finished goods and buy-to-stock raw materials where demand is not too intermittent but displays variability. In this case, the EOQ model or one of its variants should be used to calculate optimal order/batch size. Safety stock can be calculated using the target service level, the standard deviations of demand and lead time, and the lead time itself.

However, this replenishment model, which is based on probably the most widely known text-book set of equations, has important sensitivities. The most commonly found version of the safety stock equation, for instance, assumes that demand is normally distributed, that average demand does not vary, and it also breaks down when the variability is very high. You will sometimes find people saying that the equations “don’t work”, but this is often just their understanding of the equations running into some of these barriers which they either don’t understand or at any rate don’t know how to work around.

Note that different models might work best at different points in your supply chain. For instance, you might choose a replenishment model for finished goods and a deterministic model for raw materials. To really optimize your inventories, you are likely to need to employ different strategies for different types of inventory.

And these two examples are far from representing the only types of stock you might carry. For instance, you may have make-to-order items where the customer promise time is shorter than the total supply lead time. You may have spare parts with highly sporadic demand but which need to be available on demand. And so on. Each different type of inventory needs an appropriate optimization approach.

In order to optimize your inventories, you need to take all the factors above into consideration for every item. And so far, we’re just talking about mathematical optimization. In addition – and no less a challenge – you have to consider what processes, systems and people are in place and how they would need to change in order to deliver and maintain the optimization.

In our experience, the biggest gap is often in the people themselves and how they usually work. The knowledge of optimization techniques and how to take advantage of them is a rare commodity amongst material planners, whereas data scientists do not necessarily have the requisite understanding of the practicalities of the business to enable practical application of their models. Technology is sometimes seen as a way around this but we are far from this being a satisfactory solution yet.

### Inventory optimization software

*Various software solutions on the market, including ERP systems themselves, aim to help you achieve inventory optimization. Whichever one you choose, if any, think of it as part of the solution rather than the whole solution. These tools are very sensitive to the input parameters, make different assumptions and have varying degrees of ease of use. Most practitioners find that their tools work well for some types of inventory but not for others. We believe that supply chain planners need to understand how their tools work and what their limitations are.One of the issues with optimization technology, and optimization itself, is its precision. Because it is a mathematical calculation, it will produce an embarrassingly precise value. Because so many of the parameters used to calculate optimal levels are approximate, one should be cautious with calculations. Given the precision of the calculation and the imprecision of many of the critical parameters, automation is risky. Think twice before letting such tools work without human intervention and supervision.One of the most important principles in applying inventory optimization is incremental progress. Human brains are much better at applying caution to new approaches than machines.* They

*are an essential input to moving towards optimization. If an optimization tool or equation tells you that you can decrease inventory for an item by 20%, a sensible human approach would be to try decreasing it by 10% first and seeing what happens, but optimization tools don’t make this easy. Only once techniques are tried and tested should they be automated and, even then, verified on a regular basis.*

However, technology is an important part of the solution. As is hopefully evident from this white paper, even calculating optimal levels is complex, labour-intensive and error-prone. Especially where large numbers of items are being managed, it is essential to take advantage of technology to be able to get anywhere close to inventory optimization. Just be wary of software that appears to offer a silver bullet…

However, technology is an important part of the solution. As is hopefully evident from this white paper, even calculating optimal levels is complex, labour-intensive and error-prone. Especially where large numbers of items are being managed, it is essential to take advantage of technology to be able to get anywhere close to inventory optimization. Just be wary of software that appears to offer a silver bullet…

### Do you need inventory optimization?

From the brief summary above, it should be evident that inventory optimization is not simple. In fact, it is closer to the truth to call it impossible than to call it simple, but this is not an all or nothing situation. Given the complexities outlined, as well as the fact that your optimal inventory levels are constantly changing, fully optimized inventory is not an achievable goal. But the application of optimization techniques is incredibly valuable. You don’t have to win an Olympic gold medal to get value from learning how to swim. Moreover, many of the biggest benefits from inventory optimization come from the first steps.

In the absence of inventory optimization, inventory management is flying blind. You are searching for the sweet spot between too little and too much inventory without knowing where it is. Think of it as trying to find a black mouse in a completely dark room. With optimization techniques, you are switching the light on. It is still difficult to catch the mouse, but at least you can see it.

It is of course possible to manage your inventories without trying to optimize them. Especially in times of abundant cheap cash this is what many organisations choose to do. But without the analytics of inventory optimization you have no real way of knowing how well you’re doing. Or rather, your view becomes lopsided. Your service level performance tells you if you have enough, but what is telling you if you have too much? Top-down aggregate measures like cover, inventory turns or DIO give you ratios that indicate whether you’re getting leaner over time. You can also use them for quick benchmarking exercises, although actually they tell you nothing about how much is optimal.

Where organisations do not use optimization techniques, there is a strong tendency to apply “one size fits all” approaches to different types of inventory: for instance, setting target safety stock levels for all raw materials at 2 weeks’ average demand. This could only be optimal if all raw materials have identical variability of demand and supply plus identical lead times. This approach means there is a strong correlation between shortages and inventory levels long before you reach an optimized level. Because inventory optimization by necessity works at an individual item level, it allows you in aggregate to reduce inventories and shortages simultaneously.

From our own empirical experience of working with multiple organisations, it is normally the case that inventory optimization alone (so taking the givens as given) allows net inventory reductions of 20-50% while maintaining or improving service levels. This improvement takes time and effort to achieve, but double-digit improvements are normally achievable in the first year. We can think of no other option that delivers such large improvements so quickly in such a risk-free fashion.

### How do you take advantage of inventory optimization?

The good news is that you do not need to solve all of the technical problems at once. Some of the biggest benefits come from the simplest steps.

To take advantage of inventory optimization you need two things. Firstly, the ability to run the optimization calculations. Secondly, and no less importantly, the ability to operationalize the findings of your analytics. You will only sustainably improve inventory levels if your organisation can use the insights generated day to day.

The biggest value in inventory optimization analytics comes from the visibility it gives you into the biggest opportunities for improvement. It highlights things that are not necessarily obvious or intuitive. In the first instance, a calculation using a number of approximations is normally good enough. Once you have a good grasp of this, you can go further and seek to remove or refine the input approximations one at a time, noting that you will never remove all of them entirely.

Because the analytical challenge is high, you need specialist skills to do it properly. But those skills are not necessarily the same ones required to make changes to how your business actually works. Too much emphasis on analytics, or a siloed mentality, can leave a large gap between theory and practice. The analytics itself is only one part of the picture. In addition, you need to build the people, processes and systems to take advantage of it.

Inventory optimization is not something you can implement and then forget about. Rather, it is an ongoing process which needs constant attention. All of the input parameters to your optimization calculations are in a state of almost constant change. The right process controls need to be in place to optimize your inventories, especially the closer you get to optimal.

If done well, inventory optimization can transform how well your supply chain functions. However, this requires a clear understanding of what it can do and how to use it. Year one of a well-designed programme can easily deliver double digit improvements from some of the easiest steps. Those who want to get much closer to optimization can deliver that type of improvement for many years in succession.

##### Share this insight:

All of our insights are available free and without registration. You can find more articles on our main Insights page.

More Insights

##### Content Subscription

Would you like to receive more content like this, direct to your inbox? We publish white papers on a range of supply chain topics approximately once every one to two months. Subscribe below and we will notify you of new content. Unsubscribe at any time.