Inventory turnover is the number of times a business sells through and replaces its entire stock over a period, calculated as cost of goods sold (COGS) divided by average inventory value. A higher figure means stock moves quickly and less cash sits on the shelf. A lower figure means product lingers, tying up working capital and adding carrying cost. The metric is a fast, honest read on how efficiently a plant or warehouse converts inventory into sales.
The core formula is simple:
Use cost of goods sold (not revenue) in the numerator so the ratio compares like with like: inventory is valued at cost, so COGS keeps both sides on the same basis. Using sales revenue inflates the ratio because revenue includes margin. Always match the period: an annual COGS figure needs an annual average inventory to produce annual turns.
Turnover has a twin metric that many operators find more intuitive: days inventory outstanding (DIO), also called days of supply. It converts turns into a number of days:
If turnover tells you how many times a year you cycle stock, DIO tells you how many days of stock you are holding on average. Six turns a year equals roughly 61 days of supply. Twelve turns equals about 30 days. Lower DIO usually means leaner, faster inventory, as long as service levels hold.
Take a component manufacturer with these figures for the year:
First find average inventory: (900,000 + 700,000) / 2 = 1,600,000 / 2 = 800,000 EUR.
Now inventory turnover: 4,800,000 / 800,000 = 6.0 turns per year.
Then days inventory outstanding: 365 / 6.0 = 60.8 days of supply.
So this plant sells and replaces its inventory six times a year and carries about 61 days of stock on hand. If it could raise turns to 8.0 (by trimming average inventory to 600,000 EUR at the same COGS), DIO would drop to 365 / 8 = 45.6 days, freeing 200,000 EUR of cash while holding two fewer weeks of stock. That is the practical payoff of watching this metric.
There is no universal "good" number: benchmarks vary enormously by industry. Fast-moving consumer goods and grocery routinely hit 10 to 20 turns or more, because perishable, low-margin goods must move. Heavy industrial manufacturing and capital equipment often sit at 3 to 6 turns because components are expensive and lead times are long. The right way to judge your number is against your own history and against direct competitors, not against a cross-industry average.
Two rules of thumb hold across sectors: turnover that is rising while service levels stay steady is a healthy sign, and a number wildly out of step with peers deserves investigation in either direction.
It is tempting to treat "higher is always better," but both extremes carry risk.
The goal is not maximum turns. It is the highest turnover you can sustain while still meeting your service-level target. Techniques like economic order quantity (EOQ) and ABC analysis help you tune order sizes and prioritize the items where fast turns matter most.
One category breaks the "higher is better" rule entirely: maintenance, repair, and operations (MRO) inventory, especially critical spare parts. A critical bearing or motor for a bottleneck machine may sit on the shelf for years and turn over less than once annually. That is not waste. It is insurance against catastrophic unplanned downtime.
For MRO stock, the question is not "how fast does it turn" but "does missing this part shut down production." A part that costs 2,000 EUR but prevents a 50,000 EUR line stoppage is worth holding even at near-zero turns. So track MRO spares by criticality and consumption risk, not by turnover alone. A robust CMMS keeps spare-parts levels tied to actual maintenance activity rather than blunt reorder rules, and links each part to the assets and work orders that consume it.
Inventory turnover is only as trustworthy as the consumption data behind it. If you do not know how much stock is actually being used and when, your average inventory and COGS inputs are guesses. Fabrico is the real-time data foundation that makes those inputs accurate. Its CMMS tracks spare-parts usage against work orders, assets, and preventive schedules, so every part drawn from stores is logged as it happens. To be clear, Fabrico does not automatically reorder for you or run your inventory optimization math. What it does is give you a clean, EU-hosted record of real consumption, so your turnover ratio, DIO, and reorder decisions rest on what actually moved rather than on stale spreadsheet counts. Pairing that consumption record with your OEE and production data connects part usage directly to output.
Use COGS. Inventory on your balance sheet is valued at cost, so dividing by cost of goods sold keeps the numerator and denominator on the same basis. Using sales revenue inflates the ratio because revenue includes profit margin, which overstates how efficiently stock is turning.
It depends entirely on the industry. Grocery and consumer goods often exceed 10 to 20 turns a year, while heavy manufacturing may be healthy at 3 to 6. Compare your ratio to your own trend and to close competitors rather than to a cross-sector average, and watch that rising turns do not come at the cost of stockouts.
Low turnover is normal and often correct for critical MRO spares. A part held to prevent a costly line stoppage may turn over less than once a year, and that is deliberate insurance, not inefficiency. Judge spares by criticality and downtime risk, not by turnover, and manage them in a CMMS tied to real maintenance consumption.
Want your turnover ratio built on real consumption data instead of stale counts? Book a Fabrico demo to see how real-time CMMS and production monitoring give you the accurate usage foundation your inventory decisions depend on.
Login
Blog