How Do You Calculate Inventory Turnover? Training on Average Inventory, Days of Inventory, Category-Based Analysis and Freed-Up Cash
How do you calculate inventory turnover? Formula, average inventory, days of inventory, category-based analysis and freed-up cash: an 8-lesson e-commerce guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: What is inventory turnover?
- Lesson 2: What is the inventory turnover formula?
- Lesson 3: How do you find average inventory?
- Lesson 4: What do days of inventory tell you?
- Lesson 5: How do you analyze inventory turnover by category?
- Lesson 6: Is high turnover always good? Return on inventory
- Lesson 7: How do you increase turnover, and how much cash is freed up?
- Lesson 8: How do you monitor inventory turnover monthly?
- What are the most common mistakes with inventory turnover?
- How does NetKasam make tracking inventory turnover easier?
- Mini quiz: Test what you have learned
- Conclusion: Calculate your turnover by category this month
- Frequently Asked Questions About Inventory Turnover
Imagine two warehouses: both sell ₺3,600,000 worth of goods a year. One holds an average inventory of ₺450,000, the other ₺900,000. The warehouse making the same sales with twice the inventory keeps twice the cash sitting on the shelf. Inventory turnover shows this difference in a single number: how many times a year your inventory is sold and replenished. If the number is high, your cash is turning over quickly; if it is low, it is sitting on the shelf. Most businesses never calculate this number; they mistake full shelves for health.
This article is not a narrative but an 8-lesson practical course. We will answer the question how to calculate inventory turnover with numbers through a sample business, calculating the formula, why the cost of goods sold is used instead of sales, finding average inventory in two ways, days of inventory, category-based analysis, return on inventory and how much cash you free up by increasing turnover. At the end there is a mini quiz and a monthly routine. For the general importance of the concept, see the article the role of inventory turnover in e-commerce success; here we do the calculation itself step by step.
What will you be able to do by the end of this training?
In short: You will correctly calculate inventory turnover and days of inventory, find average inventory with seasonality in mind, compare categories, measure return on inventory and calculate the cash effect of increasing turnover.
- 01DataPull the cost of goods sold and inventory values for the period.
- 02AverageCalculate average inventory with monthly values.
- 03TurnoverFind turnover and days of inventory.
- 04BreakdownCalculate separately by category and product.
- 05ReturnCompare gross profit per unit of inventory.
- 06TargetSet a target turnover and calculate the cash to be freed up.
The 8 lessons of the course: (1) what inventory turnover is, (2) the formula, (3) average inventory, (4) days of inventory, (5) category-based analysis, (6) is high turnover always good: return on inventory, (7) ways to increase turnover and freed-up cash, (8) monthly monitoring.
Lesson 1: What is inventory turnover?
In short: Inventory turnover is the ratio that shows how many times your inventory is sold and replenished in a given period. High turnover means stock is moving quickly; low turnover means it is sitting on the shelf.
| Turnover | Meaning | Possible situation |
|---|---|---|
| High | Stock sells quickly, cash turns over fast | The right stock level; or a risk of stockouts |
| Medium | Balanced | The target of most businesses |
| Low | Stock sits on the shelf | Overbuying, slow products, dead stock |
The line between "high" and "low" varies by industry and product: food and fashion don't turn over at the same speed. That is why this article doesn't give industry norms; compare your own history and categories. For the extreme case of low turnover, see the article how to clear dead stock.
Lesson 2: What is the inventory turnover formula?
In short: Inventory turnover = cost of goods sold ÷ average inventory. The numerator is cost, not the sales amount, because inventory is recorded at cost value and the selling price includes the profit margin.
- Inventory turnover = Cost of goods sold ÷ Average inventory
- Days of inventory = 365 ÷ Inventory turnover
- Average inventory = Average of monthly inventory values
- Return on inventory = Gross profit ÷ Average inventory
- Freed-up cash = Average inventory − (Cost of goods sold ÷ Target turnover)
- Days of inventory (quick calculation) = Average inventory ÷ (Cost of goods sold ÷ 365)
Cost of goods sold and inventory must be taken for the same period and with the same valuation method.
Sample business (annual; the figures are chosen only to illustrate the method): cost of goods sold ₺3,600,000, opening inventory ₺420,000, closing inventory ₺480,000. Two-point average (420,000 + 480,000) ÷ 2 = ₺450,000; turnover 3,600,000 ÷ 450,000 = 8.0.
To calculate cost correctly, see the article how to calculate inventory cost; different valuation methods change turnover.
Lesson 3: How do you find average inventory?
In short: Average inventory is found in two ways: the average of opening and closing values for the year (simple) or the average of 12 monthly inventory values (closer to reality). If there are seasonal fluctuations, the second way should be used.
The sample business's monthly inventory values show the seasonal increase in November:
- January400 thousand ₺
- February380 thousand ₺
- March420 thousand ₺
- April460 thousand ₺
- May480 thousand ₺
- June470 thousand ₺
- July450 thousand ₺
- August480 thousand ₺
- September560 thousand ₺
- October640 thousand ₺
- November720 thousand ₺
- December660 thousand ₺
Prepared with sample values. The sum of the 12 values is 6,120 thousand ₺.
| Method | Average stock | Turnover | Days of inventory |
|---|---|---|---|
| Average of opening and closing values | 450.000 ₺ | 8,0 | 45.6 days |
| 12-month average (6,120 ÷ 12) | 510.000 ₺ | 7,1 | 51.7 days |
The difference comes from the 12-month average capturing the seasonal load. The two-point method shows inventory optimistically. For businesses with seasonally fluctuating sales, the seasonality index in the article how to make a sales forecast leads you to plan seasonal stock. In NetKasam, you track stock movements on one screen and see stock and inventory turnover by warehouse (inventory management).
Recommended readingHow to Make a Sales Forecast?Lesson 4: What do days of inventory tell you?
In short: Days of inventory = 365 ÷ turnover; it shows how many days on average it takes to sell your inventory. The sentence "products sit on the shelf for 52 days on average" is much easier to understand than "turnover is 7.1".
| Turnover | Days of inventory (365 ÷ turnover) | Interpretation |
|---|---|---|
| 4 | 91.3 days | Products stay on the shelf for three months |
| 6 | 60.8 days | Two months |
| 8 | 45.6 days | A month and a half |
| 12 | 30.4 days | One month |
| 24 | 15.2 days | Replenished every two weeks |
Days of inventory are read together with lead time: if a product with a 30-day lead time turns over in 15 days, there is a risk of stockouts; if it turns over in 90 days, there is overbuying. For reorder timing, see the article how to calculate safety stock. For its place in working capital, the article how to calculate working capital uses days of inventory.
Lesson 5: How do you analyze inventory turnover by category?
In short: Overall turnover mixes fast and slow categories together. Calculate it separately for each category; the problem is usually in one or two categories.
The sample business's three categories (annual):
| Category | Cost of goods sold | Average stock | Turnover | Days of inventory |
|---|---|---|---|---|
| Clothing | 1.800.000 ₺ | 300.000 ₺ | 6,0 | 60,8 |
| Accessories | 1.000.000 ₺ | 100.000 ₺ | 10,0 | 36,5 |
| Home textiles | 800.000 ₺ | 50.000 ₺ | 16,0 | 22,8 |
| Total | 3.600.000 ₺ | 450.000 ₺ | 8,0 | 45,6 |
- Apparel₺300,00066.7%
- Accessories₺100,00022.2%
- Home textiles₺50,00011.1%
Prepared with sample values. Apparel: 66.7% of inventory, 50% of cost.
Overall turnover of 8 looks good, but apparel is at 6 and home textiles at 16. To find the problem, classify your products by speed and value: how to do an ABC analysis. In NetKasam, you can save sales reports by category and product with criteria and export them to Excel (reports).
Lesson 6: Is high turnover always good? Return on inventory
In short: No. Turnover shows how fast cash turns over, while return on inventory (gross profit ÷ average inventory) shows how much profit each lira sitting on the shelf earns. The two are looked at together.
| Category | Gross profit | Average stock | Return on inventory | Interpretation |
|---|---|---|---|---|
| Clothing | 720.000 ₺ | 300.000 ₺ | 2,4 | Low turnover, low return |
| Accessories | 600.000 ₺ | 100.000 ₺ | 6,0 | High return |
| Home textiles | 240.000 ₺ | 50.000 ₺ | 4,8 | Very high turnover, medium return |
In apparel, with a return on inventory of 2.4, every ₺1 tied up in stock earns ₺2.40 of gross profit a year; in accessories, ₺6.00. Home textiles, which has the highest turnover, trails accessories because its margin is lower. On the other hand, very high turnover can signal insufficient stock: sales may be lost because stock runs out. For the margin calculation, see the article how to calculate profit margin.
Lesson 7: How do you increase turnover, and how much cash is freed up?
In short: Ways to increase turnover are reducing overbuying, clearing dead stock, ordering more often in smaller batches and increasing sales. The cash value of each increase is calculated with the freed-up cash formula.
If turnover in the apparel category rises from 6 to 8, the required average inventory becomes 1,800,000 ÷ 8 = ₺225,000; from the current ₺300,000, ₺75,000 of cash is freed up.
- Current average inventory (turnover 6)₺300,000
- Freed-up cash−₺75,000
- Target average inventory (turnover 8)₺225,000
Prepared with sample values. Cost of goods sold of ₺1,800,000 is assumed to be constant.
| Lever | How does it work? | Note |
|---|---|---|
| Reducing overbuying | Tie purchasing to the sales forecast | Stockout risk; safety stock |
| Clearing dead stock | Sell aging products with campaigns | The discount's margin; see discounting without losing money |
| Frequent, small orders | Reduce batch size | Cost per order rises |
| Increasing sales | Sell more with the same stock | Marketing cost |
| Removing slow products | Narrow the low-return product group | Customer expectations |
Uses of freed-up cash: paying off debt, investing in faster-turning products or a campaign budget. You can see the effect of this on financing costs in the article working capital.
Lesson 8: How do you monitor inventory turnover monthly?
In short: Calculate turnover and days of inventory by category every month, and compare them with the target and the same month last year. The trend is more valuable than a single month's figure.
| When? | What to do? | Who? |
|---|---|---|
| Every month | Pull the cost of goods sold and the month-end inventory value | Accounting |
| Every month | Calculate turnover and days of inventory by category | Accounting, purchasing |
| Every month | Set actions for categories below the target turnover | Purchasing |
| Once a quarter | Compare return on inventory, review product group decisions | Management |
| Once a year | Update target turnovers and the season plan | Management |
- 8.0turnover with the two-point method
- 7.1turnover with the 12-month average
- 2.4apparel's return on inventory (accessories 6.0)
- ₺75,000cash freed up when apparel turnover rises to 8
Catch the reorder point with the critical stock report; in NetKasam, critical stock levels are set for products. For month-end stock checks, see month-end close, and for counting, see the article how to do a stock count.
Recommended ReadingHow to Measure the Order Fill Rate: Line, Order and Unit-Based Rates, Reasons for Missing Lines, Value of Lost Sales, Count Discrepancies, Channel Stock Delays and the Path to the Target GuideWhat are the most common mistakes with inventory turnover?
- Using the sales amount. The numerator should be cost; the sales amount inflates turnover.
- Looking only at the average of opening and closing values. The seasonal load disappears.
- Treating overall turnover as a single number. Category differences are hidden.
- Reading turnover without margin. A fast but low-profit category may not pay off.
- Always treating high turnover as good. Stockouts and lost sales are hidden.
- Mixing different valuation methods. Comparisons between periods are distorted.
- Not setting a target turnover. Improvement can't be measured.
How does NetKasam make tracking inventory turnover easier?
- Seeing inventory turnover. You report inventory turnover, product expenses and your costs (inventory management).
- Stock movements. You track all movements in detail on one screen.
- Critical stock report. You set critical stock levels based on inventory turnover and make purchases at the right time.
- Stock by warehouse and branch. You see stock separately across multiple warehouses and branches (branch and warehouse management).
- Unlimited categories. You categorize products and get category-based sales reports separately.
- Saved reports. You save the monthly report and export it to Excel (reports).
- Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If the cost of goods sold is ₺2,400,000 and average inventory is ₺300,000, what are turnover and days of inventory?
- If the same business raises turnover to 10, what are the required average inventory and the freed-up cash?
- Why is cost used in turnover instead of the sales amount?
- If gross profit is ₺540,000 and average inventory is ₺300,000, what is the return on inventory?
- If there are seasonal fluctuations, how do you find average inventory?
Answer key:
- 2,400,000 ÷ 300,000 = 8.0; days of inventory 365 ÷ 8 = 45.6 days.
- 2,400,000 ÷ 10 = ₺240,000; 300,000 − 240,000 = ₺60,000 is freed up.
- Inventory is recorded at cost value; since the selling price also includes the profit margin, it inflates turnover.
- 540.000 ÷ 300.000 = 1,8.
- Take the average of 12 monthly inventory values.
Frequently Asked Questions About Inventory Turnover
How do you calculate inventory turnover?
Divide the cost of goods sold by average inventory. For a cost of ₺3,600,000 and an average inventory of ₺450,000, turnover is 8.
How do you calculate days of inventory?
Divide 365 by inventory turnover. If turnover is 8, days of inventory is 45.6; that is, stock sells in 46 days on average.
Is sales or cost used in the turnover calculation?
Cost is used. Inventory is recorded at cost value, and since the sales amount includes the profit margin, it shows turnover as higher than it really is.
How do you find average inventory?
The average of opening and closing inventory for the year is the simple way; if there are seasonal fluctuations, the average of 12 monthly inventory values is more accurate.
What is a good inventory turnover?
There is no single right number; it varies by industry and product. Compare with your own history and your categories, and set a target.
How do you increase inventory turnover?
By reducing overbuying, clearing dead stock, ordering smaller and more often, increasing sales and narrowing the slow product group. The cash effect of each increase is calculated with the freed-up cash formula.
Can I see inventory turnover in NetKasam?
Yes. You can see inventory turnover rates, report your product expenses and costs and track inventory movements on one screen.
Does NetKasam have a critical stock alert?
Yes. You can set a critical stock level for your products and get critical stock reports based on inventory turnover.
Conclusion: Calculate your turnover by category this month
Inventory turnover is a single division, yet it shows you your most expensive decisions. This month, pull the cost of goods sold and your 12-month average inventory, calculate turnover and days of inventory by category, look at them together with return on inventory and set a target turnover for the slowest category. When you calculate the cash that will be freed up, you'll see why this work is a priority.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.