Balance your inventory

Keep the balance with 8 inventory management viewpoints

Balance your net working capital tied up in inventory with your desired delivery performance

Many companies initiate projects on inventory optimisation, when inventories are too large and/or delivery performance is too low. All too often, companies face both challenges at the same time and, consequently, there is a need to find a balanced approach, where net working capital and delivery performance are equally in focus.

Keep the balance with 8 inventory management viewpoints

Based on experience from a wide range of projects carried out across companies, industries and nationalities, the following 8 inventory management viewpoints have been defined for the purpose of simplifying and improving the way in which we manage our inventories:

  1. We must understand the inventory breakdown and the levers that drive the stock level.
  2. Balancing service level and inventory is a top management business decision – and requires a clear process.
  3. We need a transparent way of simulating the balancing between service level and inventory.
  4. We must understand variability to balance service level and inventory.
  5. One inventory model does not fit all.
  6. For stable items, the safety stock should be defined using the fill rate method.
  7. We need a special inventory model for lumpy, erratic and intermittent materials.
  8. We must have a standardised inventory optimisation process with system support.

The 8 viewpoints can be used to set up a process at your company that will allow you to manage the inventory in a balanced and continuous manner. Do not be surprised if you achieve inventory reductions of 10 – 40 % – and at the same time even increase delivery performance.

Keep the balance

Where P signifies the calculated inventory management parameters, C signifies the cycle stock (e.g. due to batch production), T signifies the planners’ trust in the inventory management viewpoints, and S signifies the strategic stock. Notice T 2, which signifies that a high degree of confidence in the inventory management viewpoints lowers the total inventories – squared! Thus, the planners’ trust in the established inventory management viewpoints and processes is a significant factor in the size of the inventory.

In the following, the individual inventory management viewpoints are presented.

1. Understand your inventory in detail

It almost sounds trivial, but the first inventory management viewpoint is actually to understand your inventory. The inventory consists of a number of components and factors, all of which affect the inventory in one way or another. As not all factors affect the inventory in the same direction, there are, of course, a number of trade-offs to consider. It is therefore important to break down the inventories into different components; safety stock, cycle stock, stock in transit, strategic stock etc. and, subsequently, to list the factors or “levers” that affect the individual stock components.

The breakdown and visibility of the net working capital in the individual stock components and the associated levers make it possible to launch dedicated efforts within selected and prioritised areas.

A generic example of a breakdown of inventories into stock components and associated “levers”:

Inventory management

2. The balance is a top management decision

Your company’s inventory management should take place at different levels. At the operational level, the focus is to ensure that customer orders are met and inventories are increased or reduced in time. This is a process, which takes place daily or weekly.

At the tactical level, which takes place monthly or quarterly, the focus is to ensure that the product range is segmented in order to apply a differentiated approach (elaborated in viewpoint no. 5).

Finally, at the strategic level, the balance between delivery performance and net working capital is defined. At this level, it is not enough to ask “Sales”. Instead, the top management must make the decision based on a weighting between delivery performance and net working capital, which brings us to the third inventory management viewpoint.

The planning triangle, which defines the focus points in inventory management at strategic, tactical and operational level:

The planning triangle

3. Transparency in the balance between delivery performance and net working capital

In theory, the optimal delivery performance is calculated based on the costs of excess stock (storage costs) compared to the costs of not being able to deliver (lost sales and goodwill). In practice, however, this is rarely an option, because the total costs of lost sales are very difficult to estimate, and the trade-off against storage costs is an impossibility. Instead, you should determine the balance based on the following:

  • What delivery performance do your customers demand?
  • What delivery performance is possible, taking your inventory budget into account?
  • How does the balance fit with your company’s overall strategy?

The trade-off between delivery performance and net working capital should always be balanced between Sales, Finance and Production/Procurement.

By making the relation between delivery performance and net working capital visible, it is possible to simulate the consequences of the costs of a specific delivery performance.

It is about finding the right balance in the classic dilemma between Sales, Finance and Production/Procurement. The higher the delivery performance, the higher the net working capital:

The tradeoff

Christian Guldager Pedersen
Christian Guldager Pedersen
+45 4138 0026

Uncertainties within supply and demand

4. Understand demand and supply uncertainty

Both demand and supply for the individual products vary over the delivery time offered by suppliers and/or internal production. From the time an order (supply) is placed until it reaches the warehouse, the number of customer orders may change – a larger or smaller number of orders than expected may be placed.

Furthermore, the quantities that are ordered for supply may differ from what you actually receive and, finally, delivery time may vary as well. Demand variability increases over delivery time. The further you look into the future, the more uncertain is the demand. It is therefore important to understand the magnitude and consequences of the uncertainty over delivery time in order to balance the right amount of safety stock.

We are generally better at predicting sales and uncertainties on the short horizon, but calculating the safety stock should be based on the decision-making horizon, which typically equals the delivery time:

5. Treat your inventory as your refrigerator

You can easily use your big inventory management hammer and treat everything relating to inventory management as nails, but, in many cases, the result is ugly. It is therefore important to segment your products in the inventory on the basis of the predictability/variance (forecast error, sales variance etc.) and order frequency.

The four segments are controlled based on different methods, which ensure that you can spend your time on products that require extra attention and free up time from products that do not require much attention (in your ERP or planning system).

Your inventory can be managed in the same way as your refrigerator, where various products are managed based on different inventory and production/procurement principles. The limit values are based on empirical data:

6. Use formulas for calculating safety stocks for stable products – not your gut feeling!

It can be complicated to calculate safety stocks on the basis of uncertainty in the supply chain. As a consequence, many safety stocks are defined based simply on order sizes, inventory budgets or gut feelings. As the delivery performance is typically in focus, it may take some time for you to realise that the amount of net working capital is unnecessarily high (you will realise this when the CFO taps you on the shoulder!), and when that happens, an inventory optimisation project is initiated with the purpose of reducing the inventories. Subsequently, the inventories are gradually increased again as delivery performance fails for the individual products.

By using formulas (the fill rate method is recommended) for calculating the safety stocks for the stable products, the right/required balance is achieved between the net working capital and the delivery performance, cf. the management decision in inventory management viewpoint no. 2 – a balance that requires maintenance!

7. Use other methods for calculating safety stocks for unstable products – still not your gut feeling!

For unstable products, it is rarely possible to use a standard formula for calculating safety stocks. Spare parts are a typical example of products that are not stable. It can be very difficult to predict when a need arises. Consequently, it is difficult to safeguard against uncertainty.

For some of these products (valuable/important), there may be an agreement to have a strategic safety stock. The classic example is the ship, which is in port because of a lack of spare parts. In that case, the daily rate of the ship can often justify additional net working capital for the spare parts. For other less valuable products, simulations are a great tool for determining the safety stocks.

8. Use the previous 7 viewpoints in a standardised process – preferably with system support

The eighth and final inventory management viewpoint is as simple as the first viewpoint, which is to use the 7 other viewpoints in a standardised process – preferably with system support. You should not settle for immediate benefits from a thorough inventory clean-up. After a clean-up, the inventory will increase once again, and the delivery performance will gradually decrease as time goes by. Instead, inventory management should be a well-defined process that is repeated week after week, month after month, year after year. The process can be defined based on the planning triangle described in inventory management viewpoint no. 2.

The inventory management process is a continuous process, where inventory parameters are calculated and updated based on master data and transaction data from the ERP or planning system:

When you, in the near future, start to use the 8 inventory management viewpoints, you will discover that some products need higher inventories, while others need lower inventories compared with the current status. The majority of products will, in all probability, be in the latter category. With this in mind, you must remember that an increase in the inventory can take place immediately, while a decrease in the inventory will take place over a period of time (e.g. as demand gradually reduces the inventory). In any case, you will, over time, reap significant benefits by following the 8 inventory management viewpoints.

During the entire process, it is important to keep the inventory formula (T 2!) in mind. No inventory management viewpoints or processes are advanced enough to keep a planner from overwriting the result, if he/she does not have confidence in the result.

Good luck!