How to calculate inventory turnover, what it should be and how to read it
Who it is forGrocery chain buying, category management, inventory planning
Inventory turnover is the most calculated and the most miscalculated metric in retail. The formula is one line, yet it is entirely possible to produce three different numbers for the same store: use retail price in the denominator, take average inventory from two end points, or ignore transfers made during the period and the answer changes. This guide works through the formula, the correct denominator, the sector ranges and why turnover is not enough on its own.
What inventory turnover measures
Inventory turnover shows how many times the stock held during a period was depleted and replaced. A store with a turnover of 4 has sold and refilled its entire shelf four times in the year.
What the metric really describes is money, not stock. Capital tied up in inventory cannot be used for anything else until it sells. As turnover rises you are producing the same revenue with less capital; as it falls, more money sits on the shelves.
That makes turnover a finance metric more than an inventory one. When a retailer is short of cash, the source of the problem is usually not sales but falling turnover.
The formula and the correct denominator
The formula itself is not disputed; the denominator is. Both sides must be at cost: cost of goods sold on top, average inventory at cost underneath. When retail price is used in the denominator the result inflates systematically by the margin rate.
The second mistake is taking average inventory from two end points. The average of opening and closing stock is badly misleading in a grocery chain whose stock swings around religious holidays and the seasons: if stock bottoms out at the end of December, the annual average comes out too low and turnover looks higher than it really is.
The correct approach is to average the monthly closing stocks. Twelve month-end inventory values at cost, summed and divided by twelve. Where the data exists, a weekly average is better still; in categories that build stock for holiday and promotion weeks the difference is substantial.
- Inventory turnover
Cost of Goods Sold ÷ Average inventory at cost- Average inventory (simple)
(Opening stock + Closing stock) ÷ 2Use only where stock fluctuation is low.- Average inventory (correct)
Sum of 12 month-end inventory values at cost ÷ 12- Retail-basis turnover
Net sales ÷ Average inventory at retailValid only if both sides are at retail; it cannot be compared with a cost-basis result.
Numerator and denominator must cover the same period. When calculating monthly turnover, do not annualise COGS; divide the month's COGS by that month's average inventory and multiply the result by twelve to express it annually.
What inventory turnover should be, by category
There is no single good turnover, only a range that varies by category. Short shelf life and thin margins force high turnover; high margins and slow-moving lines (personal care, non-food specials) make low turnover normal.
The ranges below are typical values observed in Turkish grocery chains. Compare your own figure against your own history and against a competitor operating the same format rather than against the range itself; the information is in the direction, not the level.
| Category | Typical range | Days on hand | Binding constraint |
|---|---|---|---|
| Grocery — fresh | 40-90 | 4-9 days | Shelf life and shrinkage |
| Grocery — ambient | 12-25 | 15-30 days | Delivery frequency |
| Grocery — personal care aisle | 4-8 | 45-90 days | Expiry dates and assortment width |
| Grocery — non-food specials | 3-6 | 60-120 days | Supplier lead time |
Is rising turnover always good news
No. Turnover rises in two ways and the two mean the opposite of each other: because sales went up, or because stock went down.
Turnover that rises because stock is shrinking flatters the picture in the short term while hiding lost sales. A product that is not on the shelf cannot be sold; the sale you did not make never appears as a line in any report. That is why an out-of-stock rate or service level figure has to sit next to turnover.
The reverse also holds. Falling turnover is not always bad: at a grocery chain filling up on confectionery, Turkish delight and nuts ahead of a religious holiday, turnover falling in those weeks is planned. Read without reference to the calendar, a perfectly normal movement looks like an alarm.
- Turnover ↑ + sales ↑ + out-of-stock flat → genuine improvement
- Turnover ↑ + sales ↓ + out-of-stock ↑ → stock is eroding and sales are being lost
- Turnover ↓ + sales flat + pre-holiday stock build → planned, not a problem
- Turnover ↓ + sales ↓ + ageing stock ↑ → dead stock is building
Do not use turnover alone: what belongs next to it
Turnover cannot see margin. It cannot compare a product turning twenty times at an 8 per cent margin with one turning three times at 45 per cent; both may be working correctly in their own context.
GMROI closes that gap. By dividing gross profit by average inventory at cost it combines margin and turnover in one number, and category comparison only becomes meaningful with it.
The second complement is stock age. Turnover is an average, and averages hide the extremes: thirty fast-moving products and a hundred that never move can together produce a healthy-looking average. An ageing report breaks that concealment.
- Calculate turnoverDivide COGS by average monthly inventory at cost. Calculate it per category; total turnover is for management, category turnover is for decisions.
- Put GMROI next to itGross profit ÷ average inventory at cost. Categories with low turnover but high GMROI must not be cut.
- Add stock ageSplit into 0-30, 31-90, 91-180 and 180+ days. If stock older than 180 days exceeds 15 per cent, the average is misleading you.
- Check the out-of-stock rateIf turnover is improving while out-of-stock is also rising, the improvement is not real; lost sales have simply not been booked to inventory.
Frequently asked questions
- How is inventory turnover calculated?
- Cost of goods sold is divided by average inventory at cost. A business with annual COGS of ₺620,000 and average inventory at cost of ₺155,000 has a turnover of 620,000 ÷ 155,000 = 4.0. Both sides must be on a cost basis.
- What is a good inventory turnover ratio?
- It depends on the category. In a grocery chain, 40-90 for fresh, 12-25 for ambient, 4-8 for the personal care aisle and 3-6 for non-food specials. There is no single correct value; compare against your own history and a competitor running the same format.
- Can inventory turnover be calculated on retail price?
- It can, but both sides must be at retail: net sales ÷ average inventory valued at retail. When one side is at cost and the other at retail, the result inflates by the margin rate. Cost-basis and retail-basis results cannot be compared with each other.
- How is average inventory calculated?
- The most accurate way is to sum twelve month-end inventory values at cost and divide by twelve. The average of opening and closing stock is only reliable where stock fluctuation is low; in categories that build stock for holidays and promotions it misleads badly.
- What is the difference between inventory turnover and days on hand?
- They are two presentations of the same information. Turnover says how many times stock turns in a year, days on hand says how long one turn takes. The conversion is: days on hand = 365 ÷ turnover. A business with a turnover of 4.0 holds 91 days of stock.
- How can inventory turnover be improved?
- Three routes: narrow the assortment and deepen it, increase order frequency while reducing batch size, and clear slow-moving stock through planned markdowns. Improvement achieved by simply cutting stock is not durable; the out-of-stock rate rises alongside it.