Inventory turnover is the rate at which your business sells and replaces stock over a given period. It is one of the most diagnostic metrics in any product business — a low turnover signals dead capital sitting on shelves, while a very high turnover may indicate stockouts and lost sales. Tracking it correctly tells you whether your purchasing decisions are working and whether your assortment is still relevant.

This guide explains how to calculate inventory turnover, what days inventory outstanding (DIO) means in practical terms, what good turnover looks like by industry, and how to use the metric to improve cash flow and product mix.

What Inventory Turnover Measures

Inventory turnover counts how many times you have sold and refilled your inventory over a period — usually a year. The standard formula uses cost of goods sold (COGS), not revenue, because inventory is recorded at cost:

Inventory Turnover = Cost of Goods Sold ÷ Average Inventory

Average inventory is typically calculated as (Opening Inventory + Closing Inventory) ÷ 2. If COGS for the year was RM1,200,000 and average inventory was RM200,000, inventory turnover is 6. The business sells through and replaces its stock six times a year, or roughly once every two months.

Days Inventory Outstanding (DIO)

Many managers find days inventory outstanding more intuitive than turnover ratios. It converts the turnover number into a count of days:

DIO = 365 ÷ Inventory Turnover

Using the example above: DIO = 365 ÷ 6 = 61 days. On average, each unit of stock sits in inventory for 61 days before being sold. DIO is directly comparable to days payable outstanding (DPO) and days sales outstanding (DSO), which together describe the working capital cycle.

Industry Benchmarks for Inventory Turnover

What constitutes a "good" turnover depends entirely on the industry and the type of product:

  • Fresh food and groceries: 15–25 (DIO ~15–24 days) — perishable goods require fast turnover
  • Fashion retail: 4–8 (DIO ~45–90 days) — seasonal collections drive the cycle
  • Consumer electronics: 6–10 (DIO ~36–60 days)
  • Furniture and home goods: 3–5 (DIO ~70–120 days)
  • Automotive parts: 4–6 (DIO ~60–90 days)
  • Industrial supply and B2B distribution: 5–10 (DIO ~36–73 days)
  • Luxury jewellery: 1–2 (DIO ~180–365 days) — high-value, low-volume items

Compare your business against direct competitors and industry norms. A furniture retailer turning inventory 2 times a year is below average; a grocery store turning inventory 6 times a year is failing.

What Low Turnover Tells You

A turnover number lower than industry norms usually points to one or more of the following:

  • Over-purchasing. Buying too much of one SKU or buying too far in advance ties up cash unproductively.
  • Mismatched assortment. Stock that does not match what customers want sits on shelves while customers walk out empty-handed.
  • Pricing too high. Inventory moves slowly because the price-to-value perception is wrong.
  • Weak demand forecasting. Buying based on hope rather than data leads to bloated stock in slow-moving lines.
  • Obsolete or seasonal inventory. Last year's models, off-season items, or discontinued products that should have been cleared.

Slow inventory is hidden debt. Every ringgit sitting in unsold stock is a ringgit that could be paying suppliers, funding marketing, or reducing borrowing.

What Very High Turnover Tells You

A turnover number significantly above industry norms is not automatically positive. It can indicate:

  • Frequent stockouts. If customers cannot find what they want, they buy elsewhere — and high turnover only captures sales that happened, not sales that were lost.
  • Under-purchasing. Holding too little safety stock saves on capital but exposes the business to supply chain shocks.
  • Lost economies of scale. Smaller, more frequent orders often cost more per unit than larger orders.

The ideal is a turnover that matches industry norms while maintaining an acceptable in-stock rate. Tracking lost sales due to stockouts alongside turnover gives the complete picture.

Calculating Turnover by SKU

A single business-wide turnover ratio averages over fast-moving and dead stock alike. Calculating turnover at the SKU or product category level reveals where the real problems are.

A typical product business follows the Pareto distribution: roughly 80% of sales come from 20% of SKUs. The bottom 20% of SKUs often account for 80% of the inventory dollars sitting idle. Identify those SKUs and decide deliberately whether to keep them, mark them down, or discontinue them.

Using Turnover to Improve Cash Flow

Each additional turn in inventory turnover reduces the working capital tied up in stock. If your business currently turns inventory 4 times a year and could push that to 6 times, average inventory falls by one third — releasing a significant amount of cash.

Concrete tactics to increase turnover:

  • Run quarterly ABC analysis (high, medium, low value/turnover) and reduce orders on C-grade SKUs
  • Set markdown rules — anything not moving in 90 days drops 15%, 120 days drops 30%, 180 days liquidate
  • Negotiate smaller, more frequent supplier orders even at slightly higher unit cost
  • Use sales velocity data to set reorder points instead of fixed monthly quantities
  • Bundle slow-movers with fast-movers to clear stock without margin destruction

Common Inventory Turnover Mistakes

  • Using revenue instead of COGS. Revenue and inventory are measured in different units (retail price vs cost). Using revenue inflates turnover artificially.
  • Using only year-end inventory. Year-end snapshots often miss the true average if inventory swings seasonally.
  • Ignoring write-downs. Obsolete inventory that should have been written off is still sitting in the average inventory figure, deflating turnover.
  • Comparing across very different businesses. A jewellery store and a bakery cannot share benchmarks; their cost structures and product economics are entirely different.

Calculate Inventory Turnover with Popupnote

The Inventory Turnover Calculator on Popupnote computes both inventory turnover ratio and days inventory outstanding from your cost of goods sold and average inventory. It also surfaces the working capital tied up at your current turnover level. The calculator runs in your browser without any account required.