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.
If you want the number now rather than after an implementation project, the inventory turnover calculator will do it from your cost of goods sold and average stock value.
What AWRA OpsHub does today
- A Dead Stock & Aging report grouping items with stock but no movement for 30, 60 and 90+ days, with the capital tied up in each.
- Inventory valuation on a weighted average cost basis, which is the denominator half of the ratio.
- Stock movement and item activity reports, which are where the consumption half comes from.
- A free turnover calculator outside the product.
- An Inventory Turnover & DIO report — shipped 2026-08-01. Turns and days-inventory-outstanding per item and overall, over any date range, annualised so the figure is comparable whatever window you pick. Consumption is taken from both stock issues and till sales, opening and closing balances are reconstructed from the period's own movements, and items that consumed nothing are flagged as non-movers. Exports to CSV and PDF.
More we can add to your workspace
- A turnover by category or location. The report is per item and in total; it does not roll up to a category or a warehouse.
- A trend over time. You can run any range, but nothing charts turns month over month, so improvement is something you compare by eye across two runs.
- A target or benchmark. The system holds no expected turnover to measure against, so nothing tells you whether 4× is good for your sector.
- A dashboard tile. It is a report you open, not a number that finds you.
This post said, until 2026-08-01, that we did not compute turnover at all. We do now. Aging is still the better first stop for most people — turnover is an average that hides its own tails, while "these 40 items have not moved in 90 days and represent KES 2.1m" names the actual problem — but the ratio is no longer something you export a spreadsheet to get.
Anything above that you need, we can build for you
Everything listed above as something we can add describes what ships in the standard product today — it is a starting point, not a limit on what AWRA OpsHub can do for your organisation. Kenya's eTIMS integration and its maintained payroll engine are both in the product because clients needed them and commissioned them; neither appeared by itself, and the same door is open for whatever you just read about. One qualification so this is worth what it claims: a small number of things on this blog we deliberately leave to a specialist rather than build — a statutory ledger we will not sign our name to, a rule that would decide a tax question for you, a clinical or member-funds record that belongs in a regulated system — and where that is true the post says so in those words. Everything else is a scope, a timeline and a price.
The operational work, which is what most commissions actually are
An extra approval stage in a chain that does not match the standard one, a custom field set on employees or assets that only your sector needs, an expiry that has to block an order rather than send an email, a report your board asks for in a shape nothing produces, or a scanner or weighbridge feeding the goods-in door. These are the commissions we are asked for most often and the smallest ones we quote — and unlike a revenue-authority pipeline, none of them waits on a regulator.
The module-shaped additions, which are the ones readers ask for most often
A price list with real discount authority, a customer-facing quotation that expires, a bill of materials or recipe costing, a staff advance that is issued, acquitted and chased, a member or unit ledger, a matching rule that holds a payment. Each of these is a build rather than a setting, and each has been quoted before — a bigger piece of work than a custom field, with a written spec and a date instead of a roadmap slide.
The report, document or pack nothing currently produces
The board pack in the shape your board actually asks for, a donor or funder layout, an invoice or receipt template carrying what your regulator or your customer expects, a dataset the report builder cannot reach yet. Usually the fastest thing on this list to deliver, because the data is already in the system.
Systems, rails and hardware you already run
The accounting package, CRM, online store, core banking or custom database you intend to keep — connected through our API so a fact is entered once and appears everywhere it is needed. Plus the physical edge: a scanner, a scale, a weighbridge or a till peripheral feeding the door it belongs to.
How it works: you describe the requirement, we return a written scope, timeline and cost, and once agreed it is built into your environment and maintained as part of the product. Nothing here waits on a regulator or a published specification, which is why operational builds are the ones we quote fastest. Tell us the requirement that would otherwise rule us out — that is a better first conversation than a demo.
Tell us what your operation needsSlow stock is usually a symptom rather than the disease; stock control in Kenya covers the buying and counting habits underneath it.
Find the stock that is not moving
Dead stock and aging reports over 30/60/90 days, with the capital tied up in each item — the practical version of a turnover problem.
Explore inventory managementFrequently 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.
