What the inventory turnover ratio is
The inventory turnover ratio is cost of goods sold for a period divided by the average inventory at cost carried during that period: the number of times a retailer sells through its stock in a year. A supplements department holding $23,250 of inventory at cost and moving $186,000 of it over twelve months turns 8.0 times, which is the same as saying the whole shelf empties and refills about every six and a half weeks.
I spent five years on the brand side pulling Walmart Retail Link and KeHE Connect files, and every buyer I presented to had a turns number in their head before I opened the deck. It was rarely written down and it was never up for debate. If my SKU sat below the number they carried for that shelf, the meeting was about whether it stayed, not about how it grew.
How the inventory turnover ratio is calculated
There are two legitimate forms of the calculation and one common way to break it.
- Cost method. COGS divided by average inventory at cost.
- Retail method. Net sales divided by average inventory at retail.
Both answer the same question and land in the same place, because the margin cancels out when it sits in the numerator and the denominator alike. Average inventory is a beginning-plus-ending average at minimum, and a 12 or 13 period average if you have the balances, which matters for anything seasonal.
Here is the supplements department at one store of a nine-store natural grocery chain, for a full year.
| Line | Value |
|---|---|
| Net sales (at retail) | $300,000 |
| Gross margin | 38% |
| COGS | $186,000 |
| Beginning inventory at cost | $21,400 |
| Ending inventory at cost | $25,100 |
| Average inventory at cost | $23,250 |
| Inventory turnover ratio (turns) | 8.0 |
Walk it: $300,000 of sales at a 38% margin leaves $186,000 of COGS. Average inventory is ($21,400 + $25,100) / 2 = $23,250. And $186,000 / $23,250 = 8.0 turns.
The mistake that inflates turns by half
The number people quote wrong is net sales over average inventory at cost. It mixes a retail-priced numerator with a cost-priced denominator, and it inflates the answer by exactly 1 / (1 - margin).
On this department: $300,000 / $23,250 = 12.9 turns instead of 8.0. That is a 61% overstatement, and it comes entirely from the 38% margin, since 1 / 0.62 = 1.613 and 8.0 x 1.613 = 12.9.
The damage is not academic. Two stores with different category margins will rank in the wrong order under the mixed formula, so a 30%-margin tobacco set looks worse than it is against a 45%-margin general-merchandise set that is genuinely dead. Before comparing a turns figure to anyone else's, confirm which of the three formulas produced it. I have seen a chain's own two reports disagree by five turns for no reason other than this.
Turns benchmarks by category
There is no universal target, and any single published benchmark is worth less than your own store's trailing twelve months. What is stable is the ordering: perishable and high-frequency sets turn many times faster than anything a shopper buys once a year. The bands below are the ones I planned against for shelf-stable grocery and natural retail, stated per store per year.
| Category set (one store) | Typical annual turns |
|---|---|
| Fresh dairy | 40 to 60 |
| Packaged beverage | 18 to 25 |
| Salty snacks | 14 to 20 |
| Center-store dry grocery | 10 to 14 |
| Supplements and vitamins | 5 to 9 |
| General merchandise | 2 to 4 |
The worked example above lands at 8.0, inside the 5 to 9 band that supplements usually sit in, so that department is not the problem in that store. Two rules travel with the table. Compare a category only to itself, because a 3.0 in general merchandise and a 3.0 in dairy describe opposite situations. And read the trend before the level: a category drifting from 12 turns to 9 over four quarters is a live inventory management problem whatever the benchmark says.
How turns reconciles with days of supply and GMROI
Turns and days of cover are the same fact in different units. Divide 365 by the turns figure and you get days of supply: 365 / 8.0 = 46 days. They only agree cleanly when demand is flat, because turns is a trailing ratio built on a year of COGS while days of supply is a forward-looking number built on the demand rate you expect next. Around a promotion the two diverge on purpose, and the days-of-supply page is where that judgment lives.
Turns and GMROI are different questions, not different units. Turns counts how many times you sold through. GMROI counts how many gross margin dollars came back for each dollar of inventory at cost, which is why a cigarette set turning 20 times can return no more than a snack set turning 6. The formula that links them is on that page rather than this one.
Where Scout fits
Turns is arithmetic. The work is getting a trustworthy average inventory at cost by store and by category, every period, without hand-building it in a spreadsheet from an end-of-year count. Where Scout runs the back office it holds the item file with cost and retail and carries the inventory balances, so the turnover ratio can be computed per store per category on the same clock as sales rather than once a year off the annual accounts. Scout does not raise or transmit purchase orders, hold your order guide, or carry an EDI connection to your suppliers. Ordering stays in the purchasing system.
The short version
- The inventory turnover ratio is COGS divided by average inventory at cost, or net sales divided by average inventory at retail. Both work; mixing them does not.
- Net sales over inventory at cost inflates turns by 1 / (1 - margin). At a 38% margin that turned a real 8.0 into a reported 12.9.
- Benchmarks are directional only. Compare a category to its own history, and read the trend before the level.
- Divide 365 by turns to get days of supply. GMROI answers a different question: margin dollars returned per dollar of inventory.