Stock turnover rate shows how many times the average inventory in your business is sold or consumed in production in a given period. This rate; It helps you understand how long your money is sitting on the shelf and in the warehouse, which products are overstocked and where there is a risk of out of stock.
Even though the calculation seems simple, mixing sales turnover with cost, using only end‑of‑period inventory, or splitting figures from different periods can be misleading. The formula and examples below are prepared so that manufacturers, wholesalers and retailers can perform correct calculations with their own data.
Inventory and Store Solution
Do you want to track stock turnover rate with software?
In this article, we explained the stock turnover rate with formulas and examples. To monitor stock movements based on model, color, size, warehouse and store KG WMS and KG Shop can examine their solutions; You can see how Terda Grup handles high order volume.
Inventory Turnover Rate Formula
Stock turnover rate
Cost of Goods Sold ÷ Average Inventory
Average stock
(Beginning‑of‑Period Inventory + End‑of‑Period Inventory) ÷ 2
Not the sales amount in the formula, cost of goods sold should be used. Because the stock is tracked at cost in the balance sheet. Comparing the sales turnover with the stock at cost may show a higher turnover rate than the actual one, especially if the profit rates of the products are different from each other.
Stock Turnover Rate Calculation Example for a Manufacturer
Let's say that the annual cost of goods sold of a manufacturing enterprise is 12,000,000 TL, the finished goods stock at the beginning of the year is 2,400,000 TL, and the finished goods stock at the end of the year is 1,600,000 TL.
| Calculation step | transaction | Result |
|---|---|---|
| Average finished goods stock | (2.400.000 + 1.600.000) ÷ 2 | 2,000,000 TL |
| Stock turnover rate | 12.000.000 ÷ 2.000.000 | 6 |
A result of 6 indicates that the business turns over its average finished goods inventory approximately six times during the year. However, the reasons for waiting for raw materials, semi-finished products and finished products are different. Manufacturing companies should monitor these three stock groups separately, as well as the total stock ratio. To establish the production cost correctly in the product cost calculation guide You can benefit from the distinction between material, labor, wastage and general expenses.
Stock Turnover Rate Calculation Example for a Retailer
Let's assume that a shoe store's annual cost of goods sold is 4,800,000 TL, its beginning stock is 700,000 TL, and its end stock is 900,000 TL. The average stock is 800,000 TL and the stock turnover rate is 4.800.000 ÷ 800.000 = 6 happens.
In retailing, total ratio alone is not enough. Out of stock of fast selling product based on model, color and size; It is possible for slow-selling variants to remain on the shelf. Therefore, the turnover rate based on category and product variant should be evaluated together with the total store rate.
How to Calculate Out-of-Stock Time?
Average out-of-stock time
365 ÷ Stock Turnover Rate
Since the turnover rate in the examples is 6, the average time in stock is 365 ÷ 6 = approximately 61 days happens. If a monthly analysis is performed, the number of days in the period should be used instead of 365. This value does not mean that every product waits exactly 61 days; It is the average result of fast and slow moving products.
How to Interpret Stock Turnover Rate?
What does low turnover speed mean?
- There may be excess or incorrect products stocked
- Demand may have dropped or the season may be over.
- Working capital may be tied up in slow moving stock.
- The risk of spoilage, obsolescence and storage cost can increase.
What does high turnover rate mean?
- Stock may be sold quickly or consumed quickly in production.
- Capital may be converted into sales in a shorter time.
- If the safety stock is insufficient, there may be a risk of stock out.
- Frequent small purchases can increase procurement cost.
There is no single ideal inventory turnover rate that applies to every sector and product. Fresh food, spare parts, seasonal shoes and custom‑made machines cannot be evaluated with the same metric. First compare your result with past periods of the same product group, then with products that have similar sales and supply structures. While establishing the balance between excess inventory and sales loss, causes of out of stock and dead stock Also check out.
Most Common Mistakes in Calculation
- Using sales turnover including VAT instead of cost of goods sold.
- Using only the stock value at the end of the period instead of the average stock.
- Comparing the monthly stock average with the annual cost value.
- To evaluate raw materials, semi-finished products, finished goods or store stocks in a single total.
- Accepting a high rate under all circumstances and overlooking the risk of stock‑outs and lost sales.
Stock Turnover Rate Tracking with ERP
A one‑time annual calculation shows the overall situation; regular monitoring by product, category, warehouse, store and period is needed to take action. When the ERP report shows the cost of sold goods, average inventory, turnover speed, days in stock and last movement date together, slowing products are detected earlier. ERP reports guide for managers You can see how to read stock indicators together with sales, cash and profitability data.
How do you turn the report result into action?
Review new purchasing or production decisions on slow-moving products; Consider options for inter-store transfer, campaign or use of common materials in product bills of materials. For fast-moving products, reduce the risk of sales or production stoppages by controlling lead time and safety stock.
Other steps to reduce inventory cost In the profitable stock management guide for SMEs you can find it.
To try the calculation with different period data stock turnover calculation tool you can use; Check that cost and stock values come from the same scope.
See Your Money Waiting in Stock by Product
Manage excess stock and out-of-stock risk together by monitoring warehouse and store stocks with movement, aging and turnover data.
The next step for low-turnover items: dead stock and inactive inventory analysis.