Inventory Turnover Calculator
Compute inventory turnover ratio using COGS ÷ Average Inventory. Add an industry band to get a benchmark-aware verdict and the days-on-hand equivalent. Updates live as you type.
Inputs
Total cost of goods sold over a full year. Use COGS, not revenue.
(Opening + Closing) ÷ 2 is the standard quick method. Cost value, not retail.
Used to translate the turnover into a benchmark verdict. Good ≥ 5×; OK ≥ 3×.
Result
How to use the calculator
Two inputs, one ratio, plus an industry band for benchmarking. The trap is mixing cost and retail values, or using revenue instead of COGS — both inflate the result.
- 1
Enter COGS for the period
Total cost of goods sold across the period. Use annual COGS for the standard benchmark — quarterly and monthly turnover figures are noisier and not directly comparable to industry data.
- 2
Enter average inventory value
Average value of inventory held during the period, valued at cost (not retail). Standard method: (opening inventory + closing inventory) ÷ 2. Or use the average of monthly closing balances for less volatility.
- 3
Pick your industry band
Used to colour the result and translate the turnover into a benchmark comparison. If your category isn't listed, pick the closest neighbour or use 'other / not listed'.
- 4
Read the turnover and the days-on-hand
Turnover is how many times inventory rotated through the business in the period. Days-on-hand (365 ÷ turnover) is the same idea in days. Compare both against your direct peers and your own trend.
- 5
Watch the trend, not the absolute
A turnover figure on its own says less than a turnover trend. A 20% drop from your historical average is a working-capital alarm regardless of how the absolute compares to industry benchmarks.
The inventory turnover formula, briefly
The formula is:
COGS is the cost of goods sold across the period. Average Inventory is the typical value held in stock during that period, valued at cost. Dividing gives the number of times your inventory rotated through the business — sold and replaced — within the period.
For the deeper explanation, the link between turnover, working capital, and stockout rate, read the inventory turnover glossary entry. Connected concepts: days of cover, GMROI, sell-through rate, and weeks of supply.
What actually changes the answer
COGS
Faster sales = higher turnover. But COGS rises with margin compression too — watch for COGS-driven turnover gains that reflect lower margins, not better operations.
Average inventory
Higher inventory = lower turnover. Driven by either holding more units, or product-mix shift towards higher-cost SKUs. The second case isn't a problem; the first usually is.
Period
Annual turnover is the benchmark. Quarterly or monthly figures are far noisier — and not directly comparable to industry data, which is published annually. Use shorter periods only for trend, not absolute comparison.
Inventory valuation method
FIFO vs weighted average produce different inventory values during inflation. Compare turnover trends within the same method only; cross-method comparison is unreliable.
Common turnover mistakes
- →Using revenue instead of COGS. Inflates turnover by your mark-up multiplier — a 3× turnover at COGS becomes a 9× turnover at revenue. Standard accounting expects COGS.
- →Valuing inventory at retail. Same problem as the above, in reverse. COGS is at cost; inventory has to be at cost too.
- →Treating high turnover as automatically good. A turnover well above industry benchmarks often hides stockouts and lost revenue. Pair turnover with stockout rate and fill rate before celebrating.
- →Comparing turnover across industries. A 4× turnover is excellent for furniture and disastrous for fast fashion. Always benchmark against direct peers.
Frequently asked questions
What is the inventory turnover formula?+
Inventory Turnover = COGS ÷ Average Inventory. COGS is the cost of goods sold during the period; average inventory is the typical stock value held during the period, also at cost. The result is the number of times your inventory rotated through the business — sold and replaced — within that period.
What's a good inventory turnover rate?+
It's industry-dependent. Fast fashion runs 8–12×. Mainstream apparel 4–6×. Beauty 3–5×. Furniture 2–4×. Industrial parts 2–4×. Food and beverage 10–20× depending on perishability. The right comparison is against direct peers and against your own trend — a 20% drop from your historical average is a working-capital alarm regardless of the absolute number.
Should I use COGS or revenue?+
COGS. Inventory is held at cost on the balance sheet, so the ratio has to be cost ÷ cost to make sense. Using revenue inflates the result by your mark-up multiplier and breaks comparability with both your accounting and industry data. If your turnover number seems suspiciously high, this is the most common cause.
What's the difference between inventory turnover and days inventory outstanding (DIO)?+
They measure the same thing from opposite sides. Turnover answers 'how many cycles per period'. DIO answers 'how many days per cycle'. They're reciprocals scaled by the period: Turnover × DIO = period length in days. CFOs tend to prefer turnover; ops teams find DIO more intuitive. Both are right.
Can my inventory turnover be too high?+
Yes. A turnover well above industry benchmarks often signals stockouts and lost revenue rather than operational excellence. The classic pattern: a brand cuts inventory to chase working-capital metrics, hits the cash-flow target, then watches fill rate and revenue drop because there isn't enough stock to sell. Pair turnover with stockout rate to avoid this.
Why does my turnover look different from my finance team's?+
Two usual causes. (1) Different period — they might use trailing twelve months while you used calendar year, or they might exclude consignment or in-transit stock from inventory. (2) Different inventory valuation method — FIFO vs weighted average produce different inventory values during inflation. Align on definitions before comparing.
Should I track turnover per SKU or in aggregate?+
Both. Aggregate turnover tells the CFO whether the business is becoming more or less capital-efficient. Per-SKU turnover tells the merchandising team which products are slow-movers and which are running tight. Aggregate is for finance; per-SKU is for ops.
How often should I recompute inventory turnover?+
Monthly for the trend, annually for the benchmark. Watching a monthly trend lets you catch a turnover slowdown before it hits the annual figures (and your working capital). The annual number is the one that compares cleanly to industry benchmarks. Both have a job.