Inventory turnover ratio: formula, worked example and what a good number is
The inventory turnover ratio formula with a worked ecommerce example, how it links to days inventory outstanding, and how to improve it without stocking out.

The short answer: inventory turnover ratio = cost of goods sold ÷ average inventory. It tells you how many times in a period you sell through your stock. A higher number means stock turns into sales, and into cash, faster.
The formula
Inventory turnover ratio = cost of goods sold (COGS) ÷ average inventory
Average inventory = (opening inventory + closing inventory) ÷ 2
Use COGS and inventory at cost, not retail prices. Mixing the two is the most common reason this number comes out wrong. Some textbooks use sales instead of COGS, so check which one a benchmark uses before you compare yourself with it.
A worked example
These figures are illustrative. An online store has COGS of £480,000 for the year. Opening inventory was £110,000 and closing inventory was £130,000 at cost.
- Average inventory = (110,000 + 130,000) ÷ 2 = £120,000
- Inventory turnover ratio = 480,000 ÷ 120,000 = 4.0
The stock turned over four times in the year.
Turnover and days inventory outstanding
The same information can be shown in days. Divide 365 by the turnover ratio:
Days inventory outstanding = 365 ÷ inventory turnover ratio
For the example: 365 ÷ 4.0 = about 91 days. That is the same result as (average inventory ÷ COGS) × 365, and it means stock bought today takes roughly three months to sell. Our guide to days inventory outstanding explains how that number turns into cash tied up in stock, and the days inventory outstanding calculator will work out both figures for your own numbers.
What is a good inventory turnover ratio?
There is no single answer. Fast-moving consumables turn over many times a year, while furniture, bulky goods or wide size ranges turn over far fewer. Three comparisons are more useful than a universal benchmark:
- Your own ratio this quarter against the same quarter last year.
- Ratio by product category, because a healthy overall average can hide a range that never sells.
- Your ratio against your supplier payment terms. If stock takes 91 days to sell and you pay suppliers in 30, you are funding about two months of it yourself.
Low and high turnover
Low turnover usually means too much stock, slow sellers, or orders placed on optimism rather than sell-through. It ties up cash and raises the risk of discounting later.
Very high turnover can be a warning too. If you sell out often, you may be losing sales to stockouts or ordering too little at a time.
How to improve it
- Order against sell-through. Base each reorder on current sales speed, not last year's total.
- Clear dead stock deliberately. Discounting slow lines frees cash and lowers average inventory.
- Split large orders. Where supplier minimums allow it, two smaller orders hold less stock.
- Set reorder points and safety stock properly. The reorder point formula with a worked example shows how, and the reorder point calculator does the sums.
- Check every order against your cash. A reorder that improves turnover but empties the bank account is not an improvement. The affordability check covers that step.
FAQ
Is inventory turnover the same as days inventory outstanding? They measure the same thing in different units. Turnover counts how many times stock cycles in a period. DIO converts that into days using 365 ÷ turnover.
Should I use sales or COGS in the formula? COGS is the standard version because inventory is held at cost. If you use sales, your ratio will look higher and will not match benchmarks that use COGS.
How often should I calculate it? Monthly or quarterly, and by category as well as in total.
What is the inventory ratio? People use "inventory ratio" to mean the inventory turnover ratio in most search results. Check the formula any source uses before comparing numbers.



