Skip to content
Inventory Management | Part 5 of 8

Inventory Turns and Days on Hand: Reading the Speed of Stock

How to calculate inventory turns, days on hand and reach per item, why the average hides the problem and how to use the figures without cutting in the wrong place.

Inventory turns and days on hand are two views of the same thing: how long money stays in the warehouse. They are easy to calculate and easy to misread.

The two figures

Inventory turns = annual consumption at cost / stock value

Days on hand = 365 / turns

The drive unit plant consumes purchased parts worth EUR 18.25 million per year and holds EUR 3.65 million of them. That is 5.0 turns, or 73 days on hand.

For a single item, the same idea is called reach:

Reach = stock on hand / average demand per week

The motor flange has 3,900 units on hand and a demand of 400 per week: 9.8 weeks.

The average hides the spread

A total of 5.0 turns sounds acceptable. Split by ABC class, the pilot group of 40 items shows what is behind such a number:

Class Items Stock in EUR Turns Days on hand
A 9 297,210 6.5 56
B 8 85,355 4.0 91
C 23 82,933 1.2 296
Total 40 465,498 5.1 71

The A items turn 6.5 times a year. The C items turn 1.2 times. Eleven items have a reach of more than 26 weeks, and one washer has 75 weeks on the shelf. The inverter module, an A item, has 2.5 weeks at a lead time of eight.

Four rules for the figure

  • Same basis. Consumption and stock both at cost. Revenue in the numerator flatters the result by the size of the margin.
  • Average stock. Use the average of the month-end values, not the lowest day of the year.
  • Per class and per group. A total without the split leads to cuts in the wrong place.
  • Together with availability. Turns that rise while stockouts rise are not an improvement. Show both on one page.

Why a flat cut fails

When the figure is too low, the usual instruction is a reduction of ten percent for everybody. Planners then stop ordering. The fast items run down first, because they are the only ones that leave the warehouse by themselves. Within weeks the A items are short, the C items are unchanged, and the stockouts rise.

In the pilot group this is easy to see. A ten percent cut would be EUR 46,550. The C items alone hold EUR 52,993 above their maximum.

Do not set a target in turns

Turns depend on the industry, the depth of production, the distance to suppliers and the number of variants. Another plant’s figure says little about yours.

A better way is to calculate the target stock per item, add it up and read the turns that follow. For each item, the target is the safety stock plus half the order quantity. In the pilot group the sum is EUR 224,031, which would mean 10.6 turns if every item ran exactly on its parameters. Closing half of the gap in the first year gives EUR 345,000 and 6.9 turns.

How to use the figures

Measure monthly, for the total and per class. Add a short list of the ten items with the longest reach and the ten with the shortest.

Then watch the trend against your own goal. In the example plant, the year runs from 5.0 to 6.25 turns and from 73 to 58 days, while availability rises from 91 to 97 percent.

Newsletter

One Lean idea.
Every two weeks.