Inventory Turnover: Formula, Benchmarks & What It Really Tells You
The ratio that tells you how hard your stock is working — the formula, how to read it against days-on-hand, sane benchmarks by sector, and the ways a "good" number lies.
Inventory turnover measures how many times you sell and replace your stock over a period — usually a year. It is the single fastest read on whether inventory is an engine or an anchor. A high turnover means stock moves quickly and cash is not sitting still; a low one means capital is parked on shelves, ageing toward obsolescence. It is the counterpart to the reorder logic that puts stock on those shelves in the first place — one decides how much comes in, the other measures how fast it leaves.
The formula (and the trap in it)
Inventory Turnover = Cost of Goods Sold ÷ Average Inventory (both at cost, over the same period). The trap is using sales instead of COGS in the numerator: sales include your margin, inventory is valued at cost, and mixing the two inflates the ratio and makes you look leaner than you are. Use cost on both sides. For "average inventory", the simple (opening + closing) ÷ 2 works; averaging monthly balances is better for seasonal businesses where a single snapshot misleads.
Days Inventory Outstanding is the same fact, easier to feel
Turnover of 6 is abstract. Divide 365 by it and you get Days Inventory Outstanding ≈ 61 days — "on average, stock sits about two months before it sells." Most operators reason better in days than in turns. The two are the same measurement; DIO just speaks in a unit you can act on.
What good looks like — and why "high" is not the goal
| Business type | Typical annual turnover | Why |
|---|---|---|
| Fresh food / grocery | 15–50+ | Perishable; must move fast or spoil |
| General retail | 4–8 | Balance of availability against holding cost |
| Distribution / wholesale | 6–12 | Thin margins reward fast, high-volume movement |
| Manufacturing (finished goods) | 4–8 | Buffered by production and lead times |
| Spare parts / slow-moving | 1–3 | Held for availability, not velocity |
Higher is not automatically better. Push turnover too high and you are ordering in tiny batches, paying repeatedly to reorder, and flirting with stockouts every time demand twitches. Too low and cash is trapped and obsolescence is accumulating. The right number is the one that keeps availability high without parking money — which is why turnover is read alongside stockout rate and service level, never alone.
The averaging problem: turnover hides its own tails
A single company-wide turnover figure is an average of averages, and averages conceal. A healthy overall 6 can hide fast movers turning 30 times and dead stock turning 0.3 — the good items subsidising the bad in the blended number. The useful analysis is turnover by item or category, which surfaces two lists worth acting on: the fast movers that deserve tighter reorder points so they never stock out, and the dead stock that deserves a clearance decision before it becomes a write-off.
Keeping the number trustworthy
Turnover is only as accurate as the inventory valuation behind it, and valuation is only as accurate as the counts. A turnover ratio built on stock records that drift from physical reality is precise nonsense — which is why the ratio and count discipline are the same problem. In a system, COGS, average inventory, and per-item turnover fall out of the transaction history automatically, so the ratio is a report you read rather than a spreadsheet you rebuild each quarter — and you can drill from the headline number straight to the SKUs dragging it down.
See turnover per item, not once a year
AWRA OpsHub computes inventory turnover and days-on-hand from live transactions — by item, category, and location — so slow stock is visible before it becomes a write-off.
See inventory analyticsFrequently asked questions
Should I use sales or cost of goods sold in the turnover formula?
Cost of goods sold. Inventory is valued at cost, so the numerator must be at cost too. Using sales — which include your profit margin — inflates the ratio and overstates how efficiently stock is moving. COGS ÷ average inventory is the correct, comparable version.
What is a good inventory turnover ratio?
It depends entirely on the sector: fresh food may turn 20–50 times a year while spare parts turn 1–3, and both can be healthy. Compare against businesses like yours, and read the number alongside your stockout rate — a high turnover achieved by constantly running out is not efficiency, it is under-stocking.
How is turnover related to days inventory outstanding?
They are the same measurement in different units. Days Inventory Outstanding = 365 ÷ turnover. A turnover of 6 equals roughly 61 days of stock on hand. DIO is often easier to act on because it expresses the result as a length of time rather than a count of turns.
Why is a single company-wide turnover figure misleading?
Because it averages fast and slow movers together, so healthy velocity in your bestsellers can mask dead stock that never moves. Always break turnover down by item or category — that is where you find both the SKUs to protect with tighter reorder points and the ones to clear before they are written off.
