Inventory Turnover

How Inventory Turnover and DIO Are Calculated

Inventory turnover measures how many times a business sells through and replaces its inventory over a period, and Days Inventory Outstanding expresses that same speed as a day count. Enter your cost of goods sold, average inventory value, and the number of days in the period, and this calculator returns both figures.

These two numbers are a quick read on how efficiently a business converts inventory into sales — useful when reviewing your own operation’s trend over time, comparing against similar businesses, or sanity-checking a target you’ve set for purchasing or production.

Key Factors to Consider

The ratio is only as reliable as the inputs behind it — a few things are easy to get wrong:

• How “average inventory” is calculated matters. The simplest approach, (beginning inventory + ending inventory) ÷ 2, can badly distort the ratio for a business with seasonal swings or volatile stock levels — a retailer that stocks up heavily before a holiday season and sells through it will show a very different number depending on which two snapshot dates get averaged. A monthly or quarterly average (summing several point-in-time balances and dividing by the count) is more representative when inventory fluctuates significantly.
• The period covered by cost of goods sold, average inventory, and the day count must all match. Mixing a full year’s COGS with only a single quarter’s average inventory (or vice versa) produces a ratio that doesn’t actually describe any real period.
• An aggregate ratio can hide a mix of fast- and slow-moving stock. A single company-wide number can look healthy even while a subset of slow-moving or dead stock sits unsold for months — breaking the same calculation down by product line or SKU category, where practical, gives a fuller picture than one blended figure.
• “Good” varies enormously by industry — a grocery store selling perishables might turn inventory over 15+ times a year, while a furniture or heavy-equipment retailer might turn it over just a few times, and neither is inherently better run than the other.

Interpreting Your Results

• Track the trend, not just a single snapshot. A single quarter’s ratio says little on its own — comparing it against your own business’s history (quarter-over-quarter, year-over-year) shows whether inventory efficiency is genuinely improving or declining.
• A rising ratio isn’t automatically good news. It can also mean a business is understocking and risking stockouts or lost sales, especially if it coincides with declining revenue rather than improving demand. Read turnover alongside sales trends, not in isolation.
• Benchmark against similar businesses in your own industry, not a single universal number — the wide range in “Key Factors” above means an outside comparison is only meaningful within the same category of business.

The Formula

$$\vC{\text{Inventory Turnover}} = \frac{\vA{\text{Cost of Goods Sold}}}{\vB{\text{Average Inventory}}}$$ $$\vD{\text{Days Inventory Outstanding}} = \frac{\vE{\text{Period (Days)}}}{\vC{\text{Inventory Turnover}}}$$

Worked Example

$500,000 in cost of goods sold, $100,000 average inventory, over a 365-day year:

1. Inventory Turnover: $\frac{\vA{500{,}000}}{\vB{100{,}000}} = \vC{5\text{x}}$.
2. Days Inventory Outstanding: $\frac{\vE{365}}{\vC{5}} = \vD{73} \text{ days}$.