Inventory Turnover Ratio: Formula, Benchmarks and What Good Looks Like
Metrics · 9 min read
Nothing you paste is stored.
The scan could not run.
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 food | 12 to 20+ | 18 to 30 days |
| Restaurants and cafes | 20 to 40+ | 9 to 18 days |
| Consumer electronics | 6 to 10 | 36 to 60 days |
| Apparel and fashion retail | 4 to 6 | 60 to 90 days |
| Automotive parts | 3 to 5 | 73 to 120 days |
| Jewelry and luxury goods | 1 to 2 | 180 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 scanMore from the stockroom
- Working capital GMROI: Formula, Benchmarks and How to Improve It
- Practice ABC vs XYZ Analysis: The Difference and How to Combine Them
- Working capital How to Value Inventory for Taxes: Methods, Rules and COGS
- Practice Consignment Inventory: How It Works, Pros and Cons, and the Accounting
- Practice Par Level Inventory: What It Is and How to Set Par Levels
- Practice How to Reduce Supplier Lead Time (9 Practical Ways)
- Working capital What Is Landed Cost? Formula, Components and How to Calculate It
- Practice Just-in-Time Inventory (JIT): How It Works and When to Use It
- Practice Min/Max Inventory: How the System Works and How to Set Levels
- Lost sales How to Avoid Stockouts: 7 Ways to Stop Running Out of Stock
- Practice What Is a SKU? Stock Keeping Unit Meaning, Examples and How to Set One Up
- Practice How to Do a Physical Inventory Count (Step by Step)
- Metrics What Is a Good Inventory Turnover Ratio? (Benchmarks by Industry)
- Practice How to Reduce Inventory Carrying Cost (6 Practical Levers)
- Practice How to Forecast Inventory Demand (Methods and a Practical Process)
- Metrics How to Calculate Inventory Turnover (Formula, Example, Days)
- Practice How Much Safety Stock Should You Hold? (Formula and Service Levels)
- Practice How to Sync Inventory Across Multiple Sales Channels
- Metrics How to Calculate Inventory Value: FIFO, LIFO and Weighted Average
- Practice How to Reduce Inventory Without Causing Stockouts
- Metrics Inventory KPIs: The 7 Metrics That Actually Matter
- Metrics Days of Inventory on Hand (DIO): Formula, Benchmarks and How to Lower It
- Practice Inventory Optimization: Techniques to Cut Stock Without Stocking Out
- Practice Perpetual vs Periodic Inventory: Which System to Use and How COGS Differs
- Working capital Inventory Shrinkage: Formula, Causes and How to Reduce It
- Working capital Inventory Carrying Cost: Formula, Percentage and How to Lower It
- Practice Cycle Counting: What It Is, Methods and How Often to Count
- Metrics ABC Analysis in Inventory Management: Formula, Classes and a Worked Example
- Formulas Economic Order Quantity (EOQ): The Formula and When to Trust It
- Practice Inventory Management in Excel: How to Build It, and When to Stop
- Formulas Safety Stock: What It Is and How to Calculate It
- Formulas Reorder Point Formula: How to Calculate When to Reorder
- Working capital Dead Stock: Why It Happens and How to Clear It
- Lost sales Stockouts: The True Cost of Running Out