Home Free Tools Inventory Turnover Calculator — Measure How Fast Your Stock Moves
Inventory Tool — Stock Turnover Ratio

Inventory Turnover Calculator — Measure How Fast Your Stock Moves

Calculate your inventory turnover ratio and days inventory outstanding. Know if your stock is moving efficiently or if capital is getting locked in slow inventory.

Use the Calculator

Formula & How It Works

Average Inventory = (Opening Stock + Closing Stock) ÷ 2
Inventory Turnover Ratio = COGS ÷ Average Inventory
Days Inventory Outstanding (DIO) = Period Days ÷ Turnover Ratio

COGS is the cost of goods sold — your purchase price, not your selling price. Using COGS gives a more accurate turnover than using revenue.

Worked Example

Scenario: Annual COGS = ₹36L, Opening Stock = ₹4L, Closing Stock = ₹6L.

Average Inventory = (₹4L + ₹6L) ÷ 2 = ₹5L

Turnover Ratio = ₹36L ÷ ₹5L = 7.2x per year

DIO = 365 ÷ 7.2 = 51 days

A 7.2x annual turnover means your stock sells and is replaced every 51 days. For most retail categories, this is a healthy number.

When to Use This Calculator

  • Identify slow-moving categories that tie up working capital
  • Set inventory targets for buying team — aim for 8–12x for FMCG
  • Compare turnover month-on-month to spot seasonal trends
  • Justify reorder decisions to management or investors
  • Feed into purchase planning and open-to-buy calculations

Frequently Asked Questions

Inventory turnover measures how many times your average inventory is sold and replaced within a period. A higher ratio means stock moves faster, which is generally better.
It varies by industry. FMCG: 12–20x/year. Garments: 4–6x. Electronics: 6–8x. Supermarkets: 20–30x. Jewellery: 1–2x. Compare with your industry average.
DIO = 365 ÷ Inventory Turnover Ratio. It tells you how many days your current stock will last at the current rate of sales. Lower DIO means faster-moving inventory.
If your DIO is very high (e.g., 120+ days), it signals slow-moving inventory. Use the Dead Stock Calculator and Stock Aging Calculator to identify which products need clearance action.
Use COGS (Cost of Goods Sold) for the most accurate inventory turnover calculation. Using revenue overstates the ratio because it includes your margin.
Take the next step

Need a complete ERP for your business?

Use VasyERP to automate billing, inventory, GST, distribution, manufacturing, and business growth in one intelligent platform.

Explore More Free Tools Book Free ERP Demo Contact Sales