Inventory Turnover Ratio Formula, Benchmarks and What Good Looks Like
Metrics · 9 min read
Create your account in a minute · no card required
Nothing you paste is stored.
The scan could not run.
SKUs, scroll for the rest
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.
How do I calculate inventory turnover step by step?
Pull COGS for the period, pull beginning and ending inventory at cost, average the two, then divide. It is four numbers and one division, but each input has to be measured the same way for the answer to mean anything.
- Get cost of goods sold. It sits on the income statement. Under periodic inventory, COGS = beginning inventory + purchases minus ending inventory; under perpetual inventory your system tracks it per sale (see perpetual versus periodic inventory).
- Find average inventory at cost. Add the start and end values and divide by two, or average the month-end balances if you are seasonal.
- Divide. COGS divided by average inventory is the number of turns in the period.
- Convert to days. 365 divided by the ratio gives days of inventory on hand, the form most operators find easier to act on.
Then repeat the calculation per SKU or per category. A company-wide 6 can hide a healthy catalog carrying a few dead lines, and the per-SKU view is where the decisions live: what to reorder, what to discount, what to drop.
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
- Buying guide Cin7 vs Unleashed Pricing for Wholesalers
- Buying guide Fishbowl vs QuickBooks Enterprise Pricing
- Buying guide Lightspeed POS Pricing and Lightspeed Retail Cost per Plan
- Buying guide Sumtracker Pricing and Cost per Plan
- Buying guide Ordoro Pricing and Cost per Plan for Shipping and Inventory
- Buying guide StockTrim Pricing and Cost by Revenue Band
- Buying guide Prediko Pricing and Cost by Revenue Band with Add-Ons
- Buying guide Sellbrite Pricing, Sellbrite Cost, Plans and Order Limits
- Buying guide Finale Inventory Pricing and Contract Terms
- Buying guide SOS Inventory Pricing and What Add-ons Cost
- Buying guide Veeqo Pricing and Cost per Month by Order Volume
- Buying guide inFlow Pricing and What the App Costs
- Buying guide Unleashed Pricing and Cost per Month
- Buying guide Zoho Inventory Pricing and Order Limits
- Buying guide Katana Pricing and Katana MRP Add-on Costs
- Buying guide Fishbowl Pricing and Software Add-on Costs
- Buying guide Cin7 Pricing for Core, Omni and Add-ons
- Working capital How to Value Inventory for Taxes (Methods, Rules and COGS)
- Practice Consignment Inventory and How It Works
- Practice Par Level Inventory 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) Explained
- Practice What Is a SKU? Stock Keeping Unit Meaning, Examples and How to Set One Up
- Metrics What Is a Good Inventory Turnover Ratio? (Benchmarks by Industry)
- Practice How to Reduce Inventory Carrying Cost (6 Practical Levers)
- Practice How Much Safety Stock Should You Hold? (Formula and Service Levels)
- Practice How to Sync Inventory Across Multiple Sales Channels
- Practice How to Reduce Inventory Without Causing Stockouts
- 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 Systems
- 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 Methods, What It Is and How Often to Count
- Metrics ABC Analysis in Inventory Management with XYZ Matrix and Worked Example
- Formulas Economic Order Quantity (EOQ) Formula and When to Trust It
- Practice Inventory Management in Excel, How to Build It and When to Stop
- Formulas Reorder Point Formula and Min Max Inventory Levels
- Working capital Dead Stock and How to Clear It
- Lost sales Stockouts and How to Avoid Them in 7 Steps