Storekeeper

Inventory Turnover Ratio: Formula, Benchmarks and What Good Looks Like

Metrics · 9 min read

Nothing you paste is stored.

SKU On hand Cover Status

A live preview of Storekeeper's forecasting engine on fictional sample dataon the rows you pasted. The full product connects to your POS and store and runs this continuously.

Inventory turnover ratio = cost of goods sold ÷ average inventory. It counts how many times you sold and replaced your entire stock in a period, usually a year. A ratio of 6 means you turned the whole shelf over six times, roughly every two months. Higher generally means your cash is working harder; too high means you are running empty and losing sales you could have made.

That is the whole thing. The reason it fills so many finance textbooks is not that the formula is hard, it is that the number is easy to calculate and easy to misread. Below is how to compute it properly, what counts as a good result in your industry, and the two traps that make a healthy-looking ratio lie to you.

The inventory turnover formula

inventory turnover ratio = cost of goods sold ÷ average inventory

Both terms need care. Cost of goods sold (COGS) is what the stock cost you, not what you sold it for. Using revenue instead of COGS is the single most common mistake, and it inflates the ratio by your entire gross margin, which is exactly the amount that makes the number flattering and useless.

Average inventory smooths out the fact that stock levels swing. The usual version:

average inventory = (beginning inventory + ending inventory) ÷ 2

Both figures are inventory at cost, taken from the balance sheet. If your business is seasonal, a two-point average is genuinely misleading: a swimwear brand measured in January and December will look like it barely holds stock, because both readings land in the trough. Average the twelve month-end balances instead. The numbers you need for both terms come straight off the year-end financial statements your bookkeeper already produces, so this is not a data-collection project.

A worked example

A coffee roaster's books show COGS of $840,000 for the year. Inventory was $150,000 in January and $130,000 in December.

average inventory = (150,000 + 130,000) ÷ 2 = 140,000

inventory turnover = 840,000 ÷ 140,000 = 6.0

Six turns a year. To convert that into something operationally useful, flip it into days:

days inventory outstanding = 365 ÷ 6.0 = 61 days

On average, a bag of beans sits for 61 days between arriving and selling. For a product with a roast date on it, that sentence should cause a conversation. This is why days is the more useful form for operators even though turnover is the form accountants quote: 61 days means something you can feel, 6.0 does not.

What is a good inventory turnover ratio?

A good ratio is one that beats your own last quarter and sits near the norm for your category. The category matters enormously, because turnover is really a statement about shelf life and margin, and those are set by what you sell rather than how well you run.

Sector Typical annual turns Roughly, days on hand
Grocery and fresh food12 to 20+18 to 30 days
Restaurants and cafes20 to 40+9 to 18 days
Consumer electronics6 to 1036 to 60 days
Apparel and fashion retail4 to 660 to 90 days
Automotive parts3 to 573 to 120 days
Jewelry and luxury goods1 to 2180 to 365 days

These are working rules of thumb, not laws. A jeweler turning stock twice a year is healthy; a grocer doing the same is in serious trouble. Compare yourself to your sector and to your own history, never to a universal target.

The deeper point is that the ratio is a tradeoff dial, not a score to maximize. Push turnover up by holding less stock and you free cash, reduce spoilage, and cut the risk of being stuck with product nobody wants. Push it too far and you have no buffer, so an ordinary demand spike or a late delivery becomes an empty shelf. The cost of that empty shelf never appears in the turnover calculation, which is precisely what makes the metric dangerous when someone is bonused on it.

Two traps that make the ratio lie

1. The company-wide average hides everything

A turnover of 6.0 across the whole business is compatible with a catalog where half the SKUs turn twelve times and the other half have not moved in a year. The average is fine. The business is not: the frozen half is dead stock, and it is quietly funding nothing.

Calculate turnover per SKU, or at minimum per category. The first time most operators do this, they find that something like 20 percent of the catalog accounts for most of the movement and a long tail accounts for most of the trapped cash. That finding is the actual value of the metric. The company-wide number is just the cover page.

2. A rising ratio can mean you are running out

Turnover goes up when COGS rises or when average inventory falls. Those are very different stories. The first means you sold more. The second can mean you simply had less to sell, which is what a stockout looks like from the accounting side. A quarter with empty shelves and lost sales can report a beautiful turnover ratio.

So never read turnover alone. Read it next to your fill rate or your stockout count. Turnover up and stockouts flat is a genuine improvement. Turnover up and stockouts up means you have optimized your way into losing revenue, and the metric is congratulating you for it.

How to improve inventory turnover without creating stockouts

The honest version of this advice is short, because most of the levers are the same lever seen from different angles: buy closer to actual demand.

  • Set reorder points from real demand and real lead times. Not from what the supplier promised and not from a number typed in eighteen months ago. The reorder point formula is the mechanism.
  • Size safety stock from measured variability, not from nerves. Most businesses carry far too much buffer on steady items and far too little on volatile ones, which hurts turnover and service level at the same time. The safety stock guide has the math.
  • Order smaller and more often where the supplier allows it. Half the quantity at twice the frequency doubles turnover on that line without changing demand at all, as long as ordering costs and minimums permit.
  • Deal with the tail deliberately. Discount it, bundle it, return it, or write it off, but decide. Slow movers do not improve with age, and the longer you wait, the worse the recovery.
  • Track turnover per SKU monthly, not annually. An annual number tells you what happened. A monthly one lets you do something about it.

Related metrics worth having next to it

Turnover is one of four numbers that together describe inventory health, and it is misleading without the others.

Metric Formula What it tells you
Inventory turnover COGS ÷ average inventory How many times stock cycled
Days inventory outstanding 365 ÷ turnover How long a unit sits, in days you can feel
Sell-through rate units sold ÷ units received Whether a specific buy was a good buy
Days of cover stock on hand ÷ daily demand How long until this SKU runs out

Turnover and days outstanding look backward and belong to finance. Days of cover looks forward and belongs to whoever places the orders. That is the number the stock scan on our homepage computes per SKU, alongside the safety stock and the reorder verdict, because knowing you turned stock six times last year does not tell you what to buy this morning.

The one-paragraph summary

Divide cost of goods sold by average inventory, both at cost. Compare the result to your sector norm and to your own trend, not to a universal target. Convert it to days if you want it to mean anything operationally. Then immediately break it down per SKU, because the company-wide figure conceals both your best products and your worst, and read it alongside your stockout rate so you can tell a genuine improvement from a shelf that is simply empty.

See this math run itself

The free stock scan computes cover, safety stock and verdicts per SKU on sample data or rows you paste. No signup.

Run the stock scan

More from the stockroom

Early access · launching soon

Reading about it is step one

Step two is a system that does this arithmetic for every SKU, every day. Join the early-access list.

One confirmation email, no spam, no card.