Inventory Turnover
Inventory turnover is a logistics metric that shows how often the average stock level is fully consumed and replenished within a period — usually one year.
Inventory turnover is a business metric that measures how often a stock level is fully consumed and replenished within a defined period — usually a fiscal year. It is expressed as a turnover frequency (number of turns): an inventory turnover of 6 means that the average stock has mathematically "flowed" through the warehouse six times per year. The higher the value, the shorter the goods stay tied up in the warehouse.
The metric is central to inventory control because it relates tied-up capital, storage costs and delivery capability to one another. A high inventory turnover points to an efficiently managed, capital-friendly warehouse; a low value signals slow movers, excess stock or oversized order quantities. In practice, inventory turnover is analysed not only for the entire warehouse but broken down by item, product group or location — usually automatically from the transaction data of the ERP system.
At a glance
- Turnover frequency = goods issued or cost of goods sold divided by average stock level
- Higher value = less tied-up capital, lower storage costs
- The reciprocal gives the average days in inventory (dwell time)
- Meaningful only in an industry and item comparison, not as an absolute target
- Can be analysed automatically per item, product group and warehouse in the ERP
How is inventory turnover calculated?
The turnover frequency results from the quantity- or value-based issues over a period divided by the average stock level of the same period. In retail, the cost of goods sold (the goods sold, valued at purchase prices) is usually divided by the average stock at purchase prices. It is important that the numerator and denominator use the same basis — that is, both at purchase prices or both in quantity units. If revenue at sales prices is accidentally set against stock at purchase prices, the value comes out artificially too high.
The formula and the average stock level
Inventory turnover = cost of goods sold / average stock level. In the simplest case, the average stock is calculated as the mean of opening and closing stock ((OS + CS) / 2). More accurate is the average across several reporting dates, such as the twelve month-end stock levels, because seasonal fluctuations would otherwise distort it. ERP systems draw on the actual daily stock levels here and thus deliver the most precise value.
Turnover and days in inventory
The reciprocal of the turnover frequency, multiplied by the length of the period, gives the average days in inventory: 360 days divided by the inventory turnover. With a turnover of 6, the goods therefore sit in the warehouse for an average of 60 days. This dwell time is often more intuitive than the pure turnover figure and feeds directly into the calculation of tied-up capital.
Why inventory turnover matters
Inventory turnover is a direct lever for profitability. Every item sitting in the warehouse ties up capital that cannot be used elsewhere and causes costs for space, handling, insurance, shrinkage and loss of value. A high turnover lowers these costs and improves liquidity, because purchased goods are turned back into cash more quickly. In interplay with the trade margin, turnover largely determines profitability — an item with a low margin can still be very profitable through a high turnover frequency.
At the same time, a very high turnover is not automatically better. If ordering is too tight, the risks of shortfalls, delivery inability and frequent small orders with high ordering costs increase. Inventory turnover must therefore always be interpreted in the tension between tied-up capital and delivery readiness, and managed together with the safety stock and the service-level target.
For controlling, inventory turnover is also an early-warning indicator: a value falling over several periods points to creeping stock build-up, changing demand or misjudgements in procurement, before these show up in the balance sheet as excessive current assets.
Inventory turnover in the ERP system
In an ERP or inventory management system, inventory turnover arises as a derived metric from the existing data: the item master supplies valuation prices, the transaction data from goods receipt and goods issue supply the additions and withdrawals, and perpetual inventory management supplies the daily stock levels for the average. Because the system logs every posting, turnover can be analysed per item, product group, supplier or location without extra effort and tracked over time.
These metrics in turn feed the procurement planning functions. Items with low turnover can be identified as excess stock and reduced through promotions; fast movers are reordered on a tighter cycle. In combination with an ABC analysis and an XYZ analysis, inventory turnover forms the basis for differentiated ordering strategies and realistic reorder points.
Benchmarks and DACH specifics
There is no universally valid "good" inventory turnover — the range extends from grocery retail with double-digit values to the spare-parts or capital-goods business with turnovers well below one. The value is only meaningful in comparison with industry averages, one's own previous year or between similar items. An isolated target value without context quickly leads to mismanagement.
In the DACH region, it should be noted that the valuation of stock follows commercial and tax-law principles — such as the lower-of-cost-or-market principle under the HGB (German Commercial Code) and the permitted cost-flow methods such as FIFO. Since the average stock value goes into the denominator of the turnover formula, the chosen valuation method has a direct effect on the metric. For the traceability of the underlying stock postings, the GoBD also apply, which is why ERP-based analyses should be built on audit-proof, perpetual inventory management.
Example
Practical example: turnover in online retail
A mid-sized e-commerce retailer for household goods achieves a cost of goods sold of 1.8 million euros in a year. The average stock level — averaged over twelve month-end stock levels — is 300,000 euros at purchase prices. This results in an inventory turnover of 6, corresponding to an average of 60 days in inventory.
The ERP-based analysis per product group, however, shows a split picture: kitchen helpers as fast movers reach a turnover of 12, while a clearance group of seasonal decorations only reaches 1.5 and sits in the warehouse for around 240 days. The retailer lowers the order quantities for these slow movers, launches a clearance promotion and raises the overall turnover to 7 in the following year — with the same revenue, the tied-up capital thus falls by several tens of thousands of euros.
Frequently asked questions
Related services
Questions about Inventory Turnover in your ERP project?
We advise vendor-neutrally – and implement it ourselves on request.