Inventory Turnover: Definition, Rate, and Calculation
On this page
Are your highest-margin items also the most profitable per euro of inventory?
Let's plan an exchangeLearn About AI-Powered Sales ForecastingInventory turnover measures how many times inventory is replaced over a given period: turnover ratio = cost of goods sold ÷ average inventory at cost. A ratio of 8 over one year means that inventory is sold and replenished eight times, resulting in a turnover period of approximately 46 days. When combined with the margin, it indicates the actual return on every euro tied up in inventory.
La rotation des stocks expliquée en 1 minute
Lire la transcription de la vidéo
Un rayon, c'est un peu un manège. Le stock arrive, il se vend, on le remplace...
et ça recommence ! Combien de tours dans l'année ?
Ça, c'est la rotation des stocks : le nombre de fois où votre stock se renouvelle sur une période.
Le calcul : le coût des ventes, divisé par le stock moyen. Les deux au prix d'achat, attention !
Exemple : un rayon vend pour un million deux cent mille euros au coût sur l'année, avec cent cinquante mille euros de stock moyen. Huit tours !
Soit environ quarante-six jours de stock.
Mais la vitesse ne fait pas tout. Produit A : quarante pour cent de taux de marque, trois tours par an.
Produit B : vingt pour cent, dix tours. Par euro de stock, B rapporte deux euros cinquante de marge, A seulement deux !
Le piège ? Diviser le chiffre d'affaires, en prix de vente, par un stock compté au prix d'achat.
Bases mélangées : la rotation paraît plus rapide... qu'en vrai !
Avec Booper, l'IA croise marge, rotation et élasticité, dans le cadre de vos règles. Elle propose le prix le plus rentable et simule l'impact sur les ventes et la marge, avant décision.
La rotation des stocks : la vitesse compte, mais toujours avec la marge. À retenir !
Stock turnover explained in 1 minute
Read the video transcript
A shelf is a bit like a merry-go-round. Stock comes in, it sells, you replace it, and round it goes!
How many laps a year?
That's stock turnover: the number of times your stock is renewed over a period.
To calculate it, divide the cost of sales by your average stock. Both at cost price, mind!
Say a department sells one point two million euros at cost in a year, with a hundred and fifty thousand of average stock. Eight laps!
About forty-six days of stock.
But speed isn't everything. Product A: forty per cent margin, three laps a year.
Product B: twenty per cent, ten laps. Per euro of stock, B earns two euros fifty of margin, A only two!
The trap? Dividing revenue, at selling prices, by stock valued at cost.
Mixed bases: turnover looks faster... than it really is!
With Booper, AI combines margin, turnover and elasticity, within your rules. It suggests the most profitable price and simulates the impact on sales and margin, before you decide.
Stock turnover: speed matters, but always alongside margin. Key takeaway!
The Essentials
- Inventory turnover refers to the number of times inventory is replenished over a given period—a different concept from the sales rate, which tracks sales following a specific purchase.
- If you look at it without considering the margin, it can be misleading: a fast turnover with a low margin may yield less than a slow turnover.
- When cross-referenced with the margin using the GMROI, it identifies which SKUs deserve to be kept in stock and which should be marked down.
In 6 Questions
The number of times inventory is replenished over a given period.
Purchasing, category managers, management accounting, pricing.
Tracked monthly, analyzed by season and by category.
By reference, department, store, and warehouse.
Measure tied-up cash and inventory profitability.
Cost of Goods Sold ÷ Average Inventory at Cost.
Formulas for Inventory Turnover
Four options, all using purchase price figures to avoid mixing calculation bases.
| Indicator | Formula |
|---|---|
| Inventory Turnover Rate | Cost of sales for the period ÷ average inventory at cost |
| Average Inventory | (Beginning inventory + ending inventory) ÷ 2, or the average of monthly inventories |
| Rotation Period (in days) | Average inventory ÷ cost of goods sold × 365, or 365 ÷ inventory turnover rate |
| Stock coverage | Current inventory ÷ average weekly (or daily) sales |
Turnover looks at the past, while coverage looks at the near future: the former indicates how quickly inventory has sold, while the latter indicates how long the current inventory will last. A decline in turnover for a particular item is the first sign of slow-moving inventory.
Example of an Inventory Turnover Calculation
A department that sells €1.2 million worth of merchandise at cost over the course of the year, with an average inventory value of €150,000, turns over 8 times a year.
annual turnover: 1,200,000 € ÷ 150,000 €.
rotation period: 365 ÷ 8.
average working capital tied up in inventory.
Increasing inventory turnover from 8 to 10 times while maintaining the same sales would free up €30,000 in cash (reducing average inventory to €120,000).
Inventory Turnover and Margin: GMROI
A high margin isn't enough: what matters is the margin relative to the capital tied up in inventory.
| Product A | Product B | |
|---|---|---|
| Gross margin | 40% | 20% |
| Annual rotation | 3 | 10 |
| GMROI (gross margin ÷ average inventory at cost) | €2.00 profit margin per €1 of inventory | €2.50 profit margin per €1 of inventory |
GMROI (gross margin return on inventory) is calculated as annual gross margin ÷ average inventory at cost. Here, Product B, which has half the gross margin, generates more revenue per euro of inventory because it turns over three times faster. This is a key criterion for determining product mix and pricing: lowering a price can improve the GMROI if turnover increases sufficiently, which is measuredby price elasticity. See also Gross margin and gross margin.
The 3 Common Mistakes in Inventory Turnover
Mix the bases, smooth out seasonality, or rely on the average.
- Mixing up sales price and cost: Dividing revenue by inventory valued at cost artificially inflates the inventory turnover rate.
- Calculate the average inventory based on only two points when business is seasonal: the inventory at the beginning and end of the year masks the peaks, so a monthly average is better.
- Relying on a category's average: Good overall turnover can mask items that are no longer selling, which should be marked down before they lose their value.
Frequently Asked Questions
Short answers to the most frequently asked questions about inventory turnover.
What is inventory turnover?
Inventory turnover measures how many times a company's inventory is sold and replenished over a given period, typically one year. It is calculated by dividing the cost of goods sold by the average inventory, both valued at purchase cost. A turnover ratio of 8 means that inventory is turned over eight times a year, or approximately every 46 days. The higher the turnover ratio, the less time merchandise remains tied up, and the lower the costs in terms of cash flow, storage space, and the risk of unsold inventory. It is always analyzed in conjunction with the margin: together, these two metrics indicate how profitable the inventory is.
How do you calculate the inventory turnover rate?
To calculate the inventory turnover ratio, divide the cost of goods sold for the period by the average inventory for the same period, valued at cost: inventory turnover ratio = cost of goods sold ÷ average inventory. Example: A department that sold €1,200,000 worth of merchandise at cost over the year, with an average inventory of €150,000, has an inventory turnover ratio of 8. It can also be calculated in terms of quantity, by dividing the number of units sold by the average inventory in units. The key is to use the same basis—either cost or selling price—in both the numerator and the denominator.
How do you calculate average inventory?
The simplest way to calculate average inventory is to add the beginning inventory and the ending inventory, then divide by two: average inventory = (beginning inventory + ending inventory) ÷ 2. This method is sufficient when business is steady. When business is seasonal, however, it distorts the reality, because inventory peaks before the holidays or at the start of the season are excluded from the average. In such cases, an average of monthly—or even weekly—inventory levels is calculated, which provides a much more accurate inventory turnover rate. Inventory is valued at purchase cost.
What is inventory turnover?
Inventory turnover is the average number of days that merchandise remains in inventory before being sold. It is calculated as average inventory ÷ cost of goods sold × 365, or more simply as 365 ÷ turnover rate. A turnover ratio of 8 thus corresponds to a period of approximately 46 days. This is a more meaningful way to interpret turnover, particularly from a cash flow perspective: every day that inventory is held for one less day frees up cash. It is compared to the product’s shelf life, which is short for perishable goods or fashion items.
What is a good inventory turnover rate?
A good inventory turnover rate depends entirely on the industry and the product. Fresh products, which are perishable by nature, turn over very quickly; home goods, technical products, and luxury goods turn over much more slowly, without this being a problem. The appropriate benchmark, therefore, is the historical data for your category and that of your direct competitors—not an average across all sectors. More than the level itself, it is the trend that matters: a declining turnover rate for a specific product or category signals excessive purchasing or waning demand.
What is the relationship between inventory turnover and margin?
Inventory turnover and gross margin are combined into a single metric, the GMROI: annual gross margin divided by average inventory at cost—that is, the margin earned per euro tied up in inventory. A product with a 40% Gross margin e that turns over 3 times a year yields approximately €2 in gross profit per euro of inventory; a product with a 20% e that turns over 10 times yields €2.50. Inventory turnover therefore compensates for a lower gross margin. This is why a price reduction can improve inventory profitability if it sufficiently accelerates sales.
Does a high turnover rate justify a lower margin?
Often, yes, and this is one of the key trade-offs in retail. A fast-moving product generates profit through repeat sales and ties up little capital; it can therefore be sold at a lower price. A slow-moving product must have a higher profit margin per unit to cover its storage costs and the risk of markdowns.
Key Takeaways
- Inventory turnover ratio = cost of goods sold ÷ average inventory, both calculated at cost.
- Turnover period = 365 ÷ turnover rate, in days.
- Inventory turnover and profit margin go hand in hand: GMROI measures profit margin per euro of inventory.
Would you like to set your prices based on your inventory turnover?
Booper combines margin, turnover, and elasticity to recommend the most profitable price, item by item.
Let's talk about your inventory →Learn About AI-Powered Sales ForecastingThese articles can interest you
End-of-line inventory and dormant inventory tie up the same amount of capital, but the latter is unpredictable and gets diluted into the catalog average. The early warning sign is the Stock coverage, when compared to the remaining time until sale, rather than the number of weeks without a sale.
Before removing an item from the shelves, a gradual price reduction serves as a diagnostic tool. Since the AGEC law took effect, the destruction of unsold non-food items has been prohibited: the later the issue is detected, the fewer opportunities there are to sell the items at a profit.
A markdown is a permanent price reduction and should not be treated as a promotion. It is triggered based on projected remaining inventory—which can be determined as early as the first few weeks of sales—rather than on the start date of the sales event.
The appropriate markdown strikes a balance between profit margin and turnover rate by factoring in the cost of carrying inventory and the residual value of remaining stock. It is determined on a per-item and per-store basis, based on an acceptable residual amount set in advance.