Inventory turnover: what the number tells you

A cash question wearing a stock costume

Every unit on your shelf is money you have already spent and not yet recovered. That is the whole of it. Stock is not an asset in any sense that helps you this month; it is cash that has been converted into objects and cannot be converted back until somebody buys them.

Which makes the obvious question not "how much stock do we have" but "how fast does the stock turn back into money". That is what inventory turnover measures, and it is why the ratio belongs in a conversation about cash flow rather than a conversation about warehousing.

Stores that run out of money while trading profitably are almost always stores whose stock turns slowly. The profit is real and it is sitting in boxes.

The calculation, and the part people get wrong

Turnover is cost of goods sold divided by average inventory, both at cost.

Our glossary worked example: cost of goods sold for the year was 240,000, average inventory at cost was 60,000, so turnover is 4. The stock cycled about four times.

Two things go wrong here more often than anything else.

Mixing cost and retail. Using revenue on the top and cost on the bottom inflates the ratio by your entire margin, which makes a mediocre result look excellent. Both numbers have to be at cost. This is the single most common error and it is invisible, because the answer still looks like a plausible number.

Using a single snapshot as "average inventory". If you take your stock value on 31 December, you have taken it at the lowest point of the year, immediately after peak selling and before the new season lands. Turnover calculated against that is flattering nonsense. Average at least four points across the year, and monthly if you can.

Why the number on its own means nothing

Turnover of 4 is neither good nor bad, and anyone who tells you otherwise is selling something. It depends almost entirely on what you sell.

A grocer turning stock four times a year is in serious trouble. A furniture retailer turning it four times is doing well. A jeweller might turn stock once or twice and be extremely profitable, because the margin per unit is large enough to carry the holding cost. Published industry benchmarks are averages across businesses whose product mix, price point and supply chain look nothing like yours.

So the useful comparison is never against a benchmark. It is against two other things.

• Yourself, last year. Same catalogue, same kind of customer, same seasonality. A move from 3 to 4 means something concrete happened.
• Your own products against each other. Turnover per product line, ranked. This is where the actual decisions are.

The trap in the trend

Rising turnover feels unambiguously good. It is not, and this is the part worth internalising.

Turnover goes up when you sell more from the same stock, which is good. It also goes up when you simply hold less stock, which may be good or may mean you are running out of things people wanted to buy.

The glossary entry puts it plainly: if turnover rose from 3 to 4 while your stockout rate held steady, your buying improved. If it rose while stockouts doubled, you bought less than you could have sold. Identical ratio, opposite meanings, and only one of them is a success.

So turnover is never read alone. It is read next to your stockout rate, and ideally next to your lost-sale estimate. A store optimising turnover without watching stockouts is optimising its way towards an empty shop, which does have excellent turnover.

What a low number is actually telling you

Low turnover is a symptom, not a diagnosis, and the four common causes need completely different responses.

• Over-buying. Ordering in quantities that made sense for the unit price rather than for demand. Usually driven by a supplier discount at a higher tier, which is a real saving that stops being a saving once the stock sits for nine months.
• Too many variants. Depth across sizes and colours multiplies stock without multiplying demand. Often the right answer is fewer variants held deeper, not more variants held thinly.
• Genuine dead stock. Products that are not selling and are not going to. These need clearing rather than analysing, and the cost of clearing them is almost always lower than the cost of another year of holding. See dead stock for how to identify it before it is a year old.
• Defensive buying after a bad stockout. The most sympathetic cause. Something ran out during a promotion, it was painful, and the response was to hold far more of everything. That is a rational reaction to a specific failure and an expensive general policy.

That last one is worth sitting with, because the fix is not "hold less stock", it is safety stock sized properly on the products that actually need it, rather than a blanket increase across the catalogue.

Turnover per product beats turnover overall

A single company-wide figure tells you whether to worry. It never tells you what to do, because it is an average across products with wildly different behaviour, and averages hide exactly the distribution you need to see.

Calculate it per product line instead and rank the list. The shape is usually the same in every store: a small group turning very fast, a long middle, and a tail turning barely at all while occupying real money and real shelf space.

The tail is the action. Not necessarily to delete, because some slow lines earn their place by completing a range or carrying a margin that justifies the wait. But each one should be a decision somebody made, rather than an accident nobody has looked at since the first order.

If you want the shorter-horizon version of the same question, days of cover tells you how long current stock lasts at the current rate, which is the operational sibling of the annual ratio.

Running the number

The inventory turnover calculator takes cost of goods sold and average inventory and returns the ratio plus the implied days of inventory, which is often the more intuitive of the two. Free, no signup, and nothing leaves your browser.

Do it once a quarter rather than once a year. Annual turnover calculated annually tells you about a problem eleven months after it started, which is enough time to repeat it.

What to do with the answer

Three moves, in the order they usually pay off.

Cut the tail before you optimise the head. Clearing slow stock frees cash immediately and the freed cash can buy fast-moving stock. This is the only move on the list that funds itself.

Buy more often in smaller quantities where the supplier allows it. Higher turnover, lower holding cost, less exposure to a buying mistake. The constraints are minimum order quantities and freight economics, which is exactly where landed cost comes back into it, because smaller orders carry fixed charges less efficiently. The right answer is a trade-off, not a principle.

Shorten lead times where you can. Long lead times force larger orders and larger safety stock, both of which depress turnover. A supplier who can deliver in two weeks rather than ten is worth a slightly higher unit price, and that comparison is arithmetic rather than opinion once you cost the holding.

One caveat on cutting the tail: clearing slow stock at a discount realises a loss you have already made rather than creating a new one. The money went when the stock was bought, and every further month of holding it adds storage, handling and the opportunity cost of the cash it is sitting in. Stores hesitate because the writedown is visible and the holding cost is not, which is the wrong way round.

What not to do: set a turnover target and manage to it. A target produces the empty-shop failure described above, because the fastest route to better turnover is always to hold less, and holding less is only sometimes right. Watch the number, understand why it moved, and let the decisions be about products rather than ratios.

Common questions