On this page
Most distributors can tell you their gross margin to one decimal place and have to think for a moment about their inventory turns. That is the wrong way round. Margin tells you what happened on the transactions you completed. Turns tells you how hard your capital is working to make those transactions possible — and in a business whose largest asset sits on a rack, that is the more useful signal.
This is a practical guide to the number: how to calculate it without fooling yourself, how to read it, the two distinct ways it goes wrong, and which operational levers actually move it.
The formula, and the traps inside it
The definition is simple:
Inventory turns = cost of goods sold ÷ average inventory at cost
Illustratively: a distributor with $24 million of COGS and $6 million of average inventory at cost turns four times a year. Same thing expressed as time on hand: 365 ÷ 4 = about 91 days of inventory.
Three traps catch people out.
Trap one: using revenue instead of COGS. Revenue includes your margin; inventory does not. Dividing sales by inventory at cost inflates the number by roughly your mark-up and makes year-on-year comparison meaningless the moment your pricing changes. Both sides of the fraction must be at cost.
Trap two: using a single point-in-time inventory value. If you take the balance on 31 December, you are measuring the year with the number from its quietest day. Average across the period — monthly closing balances averaged over twelve months is the usual compromise, and any ERP holds the data to do it.
Trap three: only ever looking at the company-wide figure. A single blended number for a business carrying thousands of SKUs across several warehouses is not actionable. The aggregate is for the board; the version you manage with is turns by product line, warehouse, vendor and ABC class — the level at which somebody can do something differently on Monday.
Why turns tells you more than gross margin
Gross margin measures the profitability of a sale. Turns measures how much capital you had to freeze in order to be able to make that sale at all. Two distributors with identical 26% margins can be in completely different health if one turns six times and the other turns two.
Turns is also the only common operating metric that reaches both financial statements at once. It has COGS from the income statement on top and inventory from the balance sheet underneath, which makes it the cleanest single link between how you run the warehouse and how much cash the business has available. When turns fall, working capital tightens even though the P&L may look unchanged for another quarter or two — which is exactly why it works as an early warning.
Most importantly, turns is one half of a trade-off you are always making whether you measure it or not: capital efficiency against service level. Every extra unit on the shelf buys you a slightly better chance of filling the next order from stock and costs you cash, space and obsolescence risk. Managing turns without also tracking fill rate is how businesses cut inventory and lose customers. The pair belongs on the same page of the same report.
Failure mode one: too few turns
The classic distributor problem. Inventory accumulates because ordering more is always the locally sensible choice — a better price break, a supplier minimum, a promise to a customer who might come back, a buyer who was once caught short and never wants to be again.
What it costs, in order of how easily it is ignored:
- Frozen cash. Money in slow stock is money not available for growth, and for many distributors it is the single largest use of working capital in the business.
- Carrying cost. Space, handling, insurance, shrinkage and the finance cost of the capital — ongoing, and rarely allocated back to the SKUs that cause it.
- Obsolescence. Slow items do not sit still; they age. Eventually they are written down or scrapped, and the loss lands in one period even though it was created over three years.
- Crowding out. Rack space and buyer attention consumed by dead items are unavailable for the items that would have turned.
The tell is not the average. It is the distribution: run turns by SKU and look at the bottom decile. In most distributors a meaningful share of inventory value has not moved in twelve months, and nobody has looked at that list in a while because nothing in the routine reporting cycle produces it.
Failure mode two: turns chased carelessly
The opposite error gets less attention because it looks like discipline on a dashboard. Cut stock hard enough and turns rise beautifully — right up to the point where the operation starts paying for it in ways that never get attributed to the inventory decision.
- Stockouts and lost counter sales. A trade customer who drives to your counter and leaves empty-handed does not file a complaint; they try the competitor next time. The revenue does not appear as a loss anywhere in your system.
- Expedited freight. Air freight and emergency inbound orders that exist purely because the reorder point was too tight. This cost usually sits in a freight account, not against inventory strategy.
- Backorder administration. Every split shipment costs picking, packing, freight and a customer service conversation.
- Buyer firefighting. A purchasing team spending its week chasing shortages is not negotiating terms or rationalising the vendor base.
| Too few turns | Turns chased carelessly | |
|---|---|---|
| What you see | Inventory growing faster than sales | Turns improving, fill rate quietly falling |
| Where it shows first | Balance sheet, cash forecast | Freight costs, customer service volume |
| Who feels it | Finance | Counter, warehouse, purchasing |
| Typical cause | Static reorder points, price-break buying | A stock reduction target set without a service floor |
| The honest fix | Forecast by item, act on the slow decile | Set a fill-rate floor and manage turns beneath it |
The rule of thumb worth adopting: never set a turns target without simultaneously setting a fill-rate floor. One number without the other will be gamed, not because anyone is dishonest, but because that is what single-metric targets do.
The five levers an ERP actually moves
Turns is an outcome. You cannot manage it directly; you manage the decisions that produce it. Five of those decisions are made materially better by a system that holds live demand, supply and stock data in one place — which is the design principle behind Centerprism's inventory management module.
1. Demand forecasting instead of gut reorder points
Most reorder points were set by someone experienced, a while ago, using judgement that was good at the time. They then persisted through a demand shift nobody re-baselined for. Forecasting from actual movement history — and re-forecasting on a schedule — replaces a one-off judgement with a maintained one. Prism Forecaster™ is the Centerprism module for this work, and it is the difference between a reorder point that reflects last year's business and one that reflects this quarter's.
2. Min/max by seasonality, not a single static level
A single min/max per item is wrong twice a year in any seasonal business: too low going into the season and too high coming out of it. Seasonal profiles let the same item carry a different target in March than in October, which raises service level in the peak and releases cash in the trough without anyone remembering to intervene.
3. Supplier lead-time accuracy
Safety stock is a bet on lead-time variability, so a lead time that is wrong in the item master corrupts every reorder calculation downstream. The fix is measurement rather than negotiation: track promised versus actual receipt dates by vendor and item, and let the safety stock reflect what suppliers actually do. This is usually the fastest available improvement, because the data already exists in your purchase history — it has simply never been aggregated.
4. Visible backorder and allocation logic
When two orders want the last case, something decides who gets it. If that logic is invisible, the answer is whoever the salesperson knows best. Explicit allocation rules, visible on the order management screen, mean commitments are made against reality instead of hope — and that promised dates stop being a source of inbound phone calls.
5. Cycle counting instead of an annual shutdown
An annual physical count tells you once a year how wrong you were, then resets the error to zero and lets it grow again. Cycle counting — counting a rotating subset continuously, weighted towards high-value and fast-moving items — keeps accuracy high all year and removes the shutdown. It also matters for turns directly: a forecast built on inaccurate on-hand quantities produces a reorder point built on fiction. Barcode-driven transactions in warehouse management are what make continuous counting practical rather than aspirational.
What the published figures say
Two figures already published on this site are worth stating precisely, and no more precisely than they deserve. A dedicated ERP has been shown to raise the average inventory turn ratio by a multiplier of 2.9x. Measured against the Grant Thornton industry average of roughly four turns annually, that implies a potential 62% increase in inventory turnover.
Both figures are quoted exactly as they stand. We would not extrapolate them into a cash release number for your business, because the honest answer depends on your product mix, lead times, seasonality and how far your reorder points have drifted. What they do support is the direction, and you can do the measurement yourself: take your current turns, model the working capital released at one additional turn, and compare it with what you spend annually on the software that would produce it. That calculation belongs to you, not to a vendor's brochure.
How to start measuring on Monday
You do not need a project. You need one report, produced consistently, that four people look at.
- Pick the denominator and never change it. Average inventory at cost, from monthly closing balances. Write the definition down so the number means the same thing next year.
- Produce turns at three levels. Company, product line and warehouse. The first is for the board, the second is where decisions get made, the third is where the problem is usually hiding.
- Put fill rate on the same page. Always. A turns figure alone is an invitation to cut stock into a service problem.
- Publish the slow decile every month. The bottom 10% of SKUs by turns, with the inventory value attached. This is the list that turns strategy into action — return it, mark it down, or accept it deliberately.
- Review it with the buyers, not just with finance. Turns improves through purchasing behaviour. A number that only finance sees will not change anyone's ordering.
If pulling those numbers together currently takes a day of exports and a reconciliation, that is itself a finding — and it is the problem a live grid over the ERP database solves, as we covered in the piece on PrismView and SmartLists. Distribution-specific detail on how these modules fit together is on the wholesale distribution page, and the inventory management datasheet (PDF) covers the module itself. The rest of the module set is in the datasheet library.
If you would like to see turns, fill rate and the slow decile built as live views against distribution data rather than assembled by hand each month, request a demo.
