BrainyCalculators
Login
Advertisement

Inventory Turnover Calculator

Calculate inventory turnover ratio and Days Inventory Outstanding (DIO) from COGS and average inventory. Compare against retail, e-commerce, and manufacturing benchmarks.

Setting order quantities and reorder points?

This page measures turnover and DIO from financial statements. For EOQ, reorder point, and inventory value, use the Inventory Calculator →

$
$

Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2. If you only have one figure, use that as the average.

What is Inventory Turnover?

Inventory turnover measures how many times a company sells and replaces its stock in a year: Turnover = COGS ÷ Average Inventory. Days Inventory Outstanding (DIO) = 365 ÷ Turnover — the average days a unit sits before sale. High turnover means efficient capital use; low turnover signals overstocking or weak demand.

Use this page for financial analysis, working-capital reviews, and investor reporting. Benchmarks vary by industry: grocery 20–30×, fashion 4–6×, furniture 2–4×. Comparing your ratio to sector norms reveals operational efficiency.

For operational stocking decisions — EOQ order quantity, reorder point, safety stock, and inventory valuation — use the Inventory Calculator. That page answers “how much to order and when”; this page answers “how fast does stock move?”

Inventory Turnover Formula

Inventory Turnover = COGS ÷ Average Inventory
Days Inventory Outstanding (DIO) = 365 ÷ Inventory Turnover
Average Inventory = (Beginning + Ending Inventory) ÷ 2

How to Use This Calculator

  1. 1
    Enter Annual COGS
    Find your annual Cost of Goods Sold on your income statement. This is the direct cost of products sold, not including operating expenses.
  2. 2
    Calculate Average Inventory
    Add your beginning and ending inventory values and divide by 2. This smooths out seasonal fluctuations in stock levels.
  3. 3
    Read the Results
    A higher turnover ratio is generally better — it means you are selling through stock quickly. DIO tells you how many days your stock sits before being sold.
  4. 4
    Compare to Benchmarks
    Use the benchmark table to see how your turnover compares to your industry. Significantly below benchmark may indicate overstocking or slow-moving items.

How the Inventory Turnover Calculator Works

Formula, assumptions, and calculation steps for this business tool.

Formula Used

Inventory Turnover = Cost of Goods Sold / Average Inventory Value

Methodology

Divides cost of goods sold for the period by average inventory value to measure how many times inventory is sold and replaced.

Calculation Steps

  1. Enter the business quantities, prices, costs, or rates.
  2. Separate fixed values from variable values where the formula requires it.
  3. Calculate the metric using standard business arithmetic.
  4. Return the headline result with supporting totals or percentages.

Assumptions and Limits

  • Inputs should represent the same period or business unit.
  • One-time and recurring costs should not be mixed unless the calculator explicitly supports them.
  • Results are planning estimates and may differ from accounting statements.

Frequently Asked Questions

A good ratio depends on your industry. Grocery and fast-moving consumer goods turn 20–30x per year. Fashion and apparel averages 4–6x. Furniture may only turn 2–4x. A ratio above your industry average typically indicates efficient inventory management.

DIO (also called Days Sales of Inventory or DSI) measures how many days, on average, your inventory sits before being sold. Lower DIO means faster-moving stock and better cash flow. DIO = 365 ÷ Inventory Turnover Ratio.

Low turnover can indicate overstocking, poor demand forecasting, slow-moving or obsolete products, or pricing issues. It ties up cash in inventory and increases carrying costs (storage, insurance, obsolescence).

Yes. An extremely high turnover may mean you are understocking and missing sales due to stockouts. The optimal ratio balances avoiding excess stock while maintaining enough inventory to fulfil orders without delays.

Real-World Applications

🛒
Retail Performance Benchmarking
Compare a retailer's inventory turnover to industry benchmarks — a grocery chain should turn inventory 15–20× per year; a clothing retailer 4–6×.
📦
Slow-Moving Stock Identification
Identify product categories with DIO above the company average — these are candidates for discounting, return to supplier, or discontinuation.
💰
Working Capital Analysis
A rising DIO tied up in inventory reduces free cash flow — model how improving turnover by 10% would free up capital for reinvestment.
🏭
Manufacturer Efficiency
Measure raw materials, WIP, and finished goods turnover separately to pinpoint whether inventory inefficiency is in production, procurement, or distribution.
📊
Investor Due Diligence
Analyse a public company's historical inventory turnover trend — a declining trend in a growth business may signal demand weakness or supply chain issues.
🔗
Supply Chain Optimisation
Use turnover rate to right-size safety stock and reorder points — high-turn items need frequent small orders; low-turn items may justify bulk purchasing discounts.

Common Mistakes

1
Using revenue instead of COGS in the numerator
Inventory turnover uses Cost of Goods Sold, not Revenue. Using revenue inflates the ratio for high-margin businesses, making them appear to turn inventory faster than they actually do.
2
Using ending inventory instead of average inventory
Average Inventory = (Beginning + Ending Inventory) / 2. Using only ending inventory distorts the ratio when inventory levels change significantly during the period.
3
Comparing ratios across different industries
A turnover of 4× is excellent for a car dealership but terrible for a grocery store. Only compare within the same industry — cross-industry comparisons are meaningless.
4
Treating a higher ratio as always better
Extremely high turnover can indicate insufficient safety stock leading to stockouts and lost sales. The optimal rate balances carrying cost minimisation against stockout risk.
5
Not adjusting for seasonality
Seasonal businesses (toy retailers, ski equipment shops) have very different inventory levels in peak vs off-peak months. Annual DIO averages mask within-year patterns that require separate analysis.

Inventory Turnover Benchmarks by Industry

Industry Turnover (×/yr) DIO (days)
Grocery / Food Retail 15–25× 15–25 days
Fast Fashion 4–6× 60–90 days
Automotive Dealership 3–5× 73–122 days
Consumer Electronics 6–10× 37–61 days
Pharmaceuticals 3–5× 73–122 days
Jewellery / Luxury 1–3× 122–365 days

References

  1. Damodaran, Aswath. Damodaran Online — Industry Averages. NYU Stern, 2024.
  2. Bragg, Steven. Financial Analysis: A Controller's Guide. Wiley, 2012.
  3. APICS. APICS Dictionary: The Standard for Operations Management Terminology. APICS, 2017.
  4. Council of Supply Chain Management Professionals. CSCMP's Supply Chain Management Definitions and Glossary. CSCMP, 2023.
  5. Wild, Tony. Best Practice in Inventory Management. Routledge, 2017.

Related Calculators

Browse all Business calculators →
📦 Business

Inventory Calculator

Calculate inventory value, reorder point, economic order quantity (EOQ), and stock turnover.

Calculate now
💸 Business

Cash Flow Calculator

Calculate net cash flow, operating cash flow, and free cash flow from income and expenses.

Calculate now
💵 Business

Profit Margin Calculator

Calculate gross and net profit margins for your products and services.

Calculate now