Inventory turnover: how to read turns, and why higher is not better
Inventory turnover explained: the COGS formula, days of inventory, GMROI, directional ranges by business type, and why chasing turns can cost you margin.
Inventory turnover is cost of goods sold divided by average inventory at cost. With $18,400,000 of COGS against $3,200,000 of average inventory, turnover is 5.75 turns a year, or 63.5 days of inventory. Turns measure how fast stock moves, not whether the business is healthy — read them alongside fill rate and margin.
Key takeaways
- Inventory turns = COGS ÷ average inventory at cost. Days of inventory = 365 ÷ turns. They are the same fact stated two ways.
- Turns computed on sales instead of COGS are inflated by the gross margin. At a 30.9% margin, 5.75 real turns read as 8.33.
- Turns are a symptom. The goals are service level and margin, and very high turns are often a stockout problem wearing a good number.
- GMROI — gross margin ÷ average inventory at cost — ranks product lines better than turns, because it prices the margin each stocked dollar earns.
- Any published turnover benchmark is directional at best. Your lead times and assortment breadth determine your achievable range more than your industry label does.
Inventory turnover is the most quoted inventory metric and one of the most casually misread. It counts how many times you sell and replace your stock in a year. What it does not do — despite how it gets used in board packs — is tell you whether that number should be higher. A distributor at 12 turns and 91% fill rate is running a worse business than one at 5 turns and 98% fill rate, and only one of those two numbers appears on the slide.
- Inventory turnover
- The number of times average inventory is sold and replaced over a period. Cost of goods sold divided by average inventory, both valued at cost. Expressed as a count of turns per year, or inverted into days of inventory: 365 ÷ turns.
The inventory turnover formula, and the version that lies
Inventory turnover = COGS ÷ Average inventory at cost
Days of inventory = 365 ÷ Inventory turnoverA worked example, which the rest of this post builds on. A distributor reports $18,400,000 of COGS for the year. Inventory opened at $3,050,000 and closed at $3,350,000, so average inventory is ($3,050,000 + $3,350,000) ÷ 2 = $3,200,000.
Now the mistake. Revenue for the same year was $26,641,048, giving a gross margin of $8,241,048, or 30.9%. Divide revenue by average inventory and you get $26,641,048 ÷ $3,200,000 = 8.33 turns, which reads as 43.8 days of inventory rather than 63.5. Nothing about the business changed. The ratio simply inflated by 1 ÷ (1 − 0.309) = 1.45, because revenue includes margin and inventory does not.
Enter COGS and your opening and closing balances to get turns, days of inventory, GMROI and the cash a target turn rate would release.
What is a good inventory turnover ratio?
There is no universal answer, and any figure quoted without the business model attached is noise. The achievable range is set by three things you mostly do not control: supplier lead times, shelf life, and how wide your assortment has to be to win orders. A spare-parts business stocking 14,000 line items against 16-week imports cannot reach the turns of a produce wholesaler, and should not try.
| Business shape | Turns range you typically see | What sets the ceiling |
|---|---|---|
| Fresh and perishable distribution | 20 and above | Shelf life. Stock that does not move spoils, so the metric is enforced by biology. |
| Fast-moving consumer goods wholesale | 8 to 14 | Short domestic lead times, narrow assortment, predictable demand. |
| General industrial distribution, domestic supply | 6 to 9 | Weeks not months of lead time, but service level requires breadth. |
| Import-led distribution or wide assortment | 3 to 5 | Ocean lead times and a long tail of slow lines that must still be available. |
| Service-critical spare parts | 1 to 3 | Availability is the product. Low turns here are the business model, not a failure. |
| Make-to-order job shop | 4 to 8 | Mostly raw material and WIP. Turns say more about cycle time than about buying. |
Which leaves the only two comparisons worth making: your own trend over eight or twelve quarters, and your turns against your lead times. Six turns means 61 days of stock. If your average replenishment lead time is 14 days, 61 days of cover is generous. If it is 90 days, six turns means you are running on luck and expediting. Work that comparison directly with the days of supply calculator rather than through the turns ratio.
Turns are a symptom, not a goal
Turnover has no customers. Nobody buys from you because your inventory turned 8.4 times. What the business is actually trying to do is fill orders at an acceptable margin without tying up more cash than it needs — and turns is one downstream consequence of doing that well or badly. Set turns as the target and you get the number by the cheapest available route, which is usually cutting buffers on the items customers ask for most.
Here is the same distributor split into three product lines. The totals reconcile to the company figures above.
| Line | COGS | Avg inventory | Turns | Days | Gross margin | GMROI | Fill rate |
|---|---|---|---|---|---|---|---|
| A — commodity fasteners | $6,000,000 | $500,000 | 12.0 | 30 | 12% | $1.64 | 91% |
| B — engineered assemblies | $4,600,000 | $1,150,000 | 4.0 | 91 | 46% | $3.41 | 98% |
| C — general MRO | $7,800,000 | $1,550,000 | 5.0 | 73 | 31% | $2.26 | 96% |
| Total | $18,400,000 | $3,200,000 | 5.75 | 63.5 | 30.9% | $2.58 | 95% |
Line A turns three times as fast as Line B and returns less than half the gross margin per stocked dollar, while failing one order in eleven. Line B parks 91 days of stock and earns $3.41 for every dollar sitting on the rack. On a turns league table, A wins and B is the problem child. On any measure the owner cares about, it is the other way round.
GMROI: the ratio that survives the argument
Gross margin return on inventory investment fixes the specific blindness in turns: it prices the margin that each dollar of stock earns, so a slow high-margin line is no longer punished for being slow.
GMROI = Gross margin dollars ÷ Average inventory at cost
Equivalently: GMROI = (margin % ÷ (1 − margin %)) × turnsFor the company: $8,241,048 ÷ $3,200,000 = $2.58. Check it with the second form: (0.309 ÷ 0.691) × 5.75 = 0.447 × 5.75 = 2.57, the same number within rounding. For Line A: $818,182 of margin ÷ $500,000 = $1.64. For Line B: $3,918,519 ÷ $1,150,000 = $3.41.
A GMROI of $1.00 means the line earns exactly as much gross margin as the cash it consumes — below that, it is not paying for the space it occupies before you have covered a single overhead. Use turns to talk about flow and GMROI to talk about assortment. Rank lines with an ABC analysis on value, then sort within class by GMROI: that combination finds the items worth arguing about far faster than a turns report does.
What a turn target actually costs
Suppose the CFO asks for 7.0 turns. At $18,400,000 of COGS, that means average inventory of $18,400,000 ÷ 7.0 = $2,628,571, a reduction of $571,429. At a 22% carrying rate, the recurring saving is $125,714 a year, plus the one-off cash release. That is a genuinely good outcome — if the reduction comes from somewhere that was not doing any work.
| Where the $571,429 comes from | What it costs | Verdict |
|---|---|---|
| Dead and obsolete stock with no issues in 12 months | A write-down you already owed, and some racking back | Take it first, always |
| Shorter or more reliable supplier lead times | Negotiation time; possibly higher freight cost | Best structural win — cuts buffer permanently |
| Smaller, more frequent orders on A items | More purchase orders and inbound receipts | Good if your ordering cost is genuinely low |
| Trimming the slow tail of the assortment | Some orders you can no longer fill complete | Defensible, but measure the lost lines |
| Cutting safety stock across the board | Fill rate. Directly and immediately. | This is where turn targets usually get met |
Price the fifth row before anyone commits to it. If hitting 7.0 turns by starving buffers drops fill rate from 95% to 91%, four points of $26,641,048 in revenue is $1,065,642 of demand exposed. Even if two thirds of that eventually ships late rather than being lost, the third that walks costs roughly $110,000 of gross margin at a 30.9% margin — comparable to the entire $125,714 carrying-cost saving, and it recurs too. Size the trade-off honestly with the safety stock calculator first.
Four ways the ratio misleads even when the formula is right
- A two-point average on seasonal stock. Closing the year at the seasonal low understates average inventory and flatters turns. Use a 12-point monthly average whenever the peak-to-trough swing exceeds about 30%.
- A container landing in the last week of the period. Inventory rises immediately; COGS only rises when the goods sell. Turns drop for a reason that has nothing to do with performance, and someone will ask about it in the meeting.
- Mixed-basis totals. Consignment stock, goods in transit and WIP belong in both COGS and inventory, or in neither. Half-in is the quiet error that makes year-on-year comparisons meaningless.
- Whole-company turns on a multi-warehouse business. A blended 5.75 can hide one branch at 11 and another at 2.3. The blend is arithmetically correct and operationally useless — segment by location and product line before drawing a conclusion.
Getting the number without a week of exports
The division is trivial. Assembling the inputs is not: twelve monthly inventory balances at cost, COGS on exactly the same basis, split by warehouse and product line, with consignment and in-transit treated consistently, and gross margin by line if you want GMROI alongside. That is normally a saved search, an export, a pivot table and a long afternoon — repeated every month, because the answer only means something as a trend.
With you ask for it in a sentence: "inventory turns and GMROI by product line for the last eight quarters, using a monthly average inventory". It computes against your own account, read-only, and prints the query underneath, so the argument in the room is about the assortment rather than about whose spreadsheet is right. If you want the working-capital context, cash conversion cycle explained sets days of inventory next to receivables and payables, and the ABC analysis guide is where to start if the answer turns out to be assortment rather than buying policy.
Frequently asked questions
How do you calculate inventory turnover?
Divide cost of goods sold for the period by average inventory at cost. Average inventory is usually opening plus closing divided by two. With $18,400,000 of COGS and $3,200,000 of average inventory, turnover is 5.75 turns. Divide 365 by turns for days of inventory: 365 ÷ 5.75 = 63.5 days.
What is a good inventory turnover ratio?
It depends entirely on lead times, shelf life and assortment breadth. Perishable distribution runs above 20 turns; service-critical spare parts run at 1 to 3 and should. The only reliable tests are your own trend over eight quarters and whether your days of inventory is sensible next to your replenishment lead time.
Should inventory turnover use COGS or sales?
COGS. Inventory sits on the balance sheet at cost, so a sales numerator mixes two bases and inflates the ratio by the gross margin. At a 30.9% margin, 5.75 real turns appear as 8.33. The sales-based variant exists in retail where stock is carried at retail value; label it clearly and never compare the two.
Is a higher inventory turnover always better?
No. Turns are a symptom of service level, lead times and assortment, not a goal. Very high turns frequently mean thin buffers and missed orders: a line at 12 turns with a 91% fill rate is losing business a line at 4 turns with 98% is winning. Judge turns against fill rate and GMROI together.
How do inventory turns and days of inventory relate?
They are the same number inverted. Days of inventory equals days in the period divided by turns, so 5.75 turns over a year is 63.5 days of stock. Turns compare across periods of different length more easily; days are more useful to planners because they compare directly against supplier lead times.
What is GMROI and how is it different from turns?
GMROI is gross margin dollars divided by average inventory at cost, so it measures margin earned per dollar of stock held. Turns count movement only. A line turning 4 times at a 46% margin returns $3.41 per stocked dollar; one turning 12 times at 12% returns $1.64. Use turns for flow, GMROI for assortment decisions.
Calculators for this
Calculate inventory turnover from COGS and average inventory. Get turns, days of inventory, GMROI and the cash freed by hitting a target turn rate.
Work out days of supply from on-hand stock and average daily usage. See weeks of cover, days until stockout, and the units needed to reach a target.
Calculate days inventory outstanding and inventory turns from average stock and COGS. See the cash tied up in inventory and the cost of holding it.
Build your inventory carrying cost rate from capital, storage, service and risk. Get the annual cost, the percentage rate, and holding cost per unit.
Keep reading
ABC analysis step by step: rank items by annual usage value, cut classes at 80% and 95% cumulative value, then set count, review and buffer policy per class.
EOQ explained with a worked example: the square-root formula, why ordering and holding cost are equal at the optimum, and the assumptions that break.
The cash conversion cycle explained: CCC = DIO + DSO − DPO, a full worked example at 65 days, and how to cut each leg without breaking the other two.
Four safety stock formulas on one data set, from 543 to 6,120 units: what each assumes, the z values, and service level versus fill rate.