Inventory Turnover Formula

Q: Why use COGS instead of revenue in the inventory turnover formula?

COGS is the cost of inventory sold — the same unit basis as the inventory you are measuring. Revenue includes markup, which inflates the ratio and makes inventory appear to turn faster than it actually does. Using revenue also makes your results incomparable to COGS-based industry benchmarks.

Q: What are the variants of the inventory turnover formula?

The four main variants are: (1) COGS ÷ Average Inventory — standard, most accurate; (2) Revenue ÷ Average Inventory — used in some retail benchmarks, inflates the ratio; (3) Purchases ÷ Average Inventory — useful when COGS is unavailable; (4) COGS ÷ Ending Inventory — simpler but less accurate for seasonal businesses. The COGS-based formula is the industry standard.

The inventory turnover formula measures how many times a business sells and replaces its stock in a period. It is one of the most widely used efficiency ratios in finance and supply chain — connecting purchasing decisions directly to cash flow and profitability.

Inventory Turnover = COGS ÷ Average Inventory

COGS = Cost of Goods Sold Average Inventory = (Beginning + Ending) ÷ 2 Result = turns per period

What Is the Inventory Turnover Formula?

The standard inventory turnover formula is:

Inventory Turnover = Cost of Goods Sold (COGS) ÷ Average Inventory

The result is a dimensionless ratio — the number of times you sold and replaced your average inventory during the period. A ratio of 6 means you turned your stock six times in a year, or roughly every two months.

The formula uses COGS rather than revenue because COGS is measured in the same units as inventory (cost). Using revenue — which includes markup — inflates the ratio and makes comparison to published benchmarks impossible, since nearly all benchmarks are COGS-based.

Inventory Turnover Formula Variables Explained

Variable	Definition	Where to Find It	Notes
COGS	Cost of goods sold — the direct cost of inventory sold during the period	Income statement	Includes materials, direct labour, and manufacturing overhead. Does not include selling, general, or administrative expenses.
Average Inventory	(Beginning Inventory + Ending Inventory) ÷ 2	Balance sheets at start and end of period	Must cover the same period as COGS. For seasonal businesses, consider using a monthly average (sum of 12 month-end balances ÷ 12).
Beginning Inventory	Inventory value at the start of the measurement period	Prior period balance sheet (ending inventory = next period beginning)	Valued at cost, not at retail price. The same cost method (FIFO, LIFO, weighted average) must be used consistently.
Ending Inventory	Inventory value at the end of the measurement period	Current period balance sheet	Can be distorted by seasonality — see assumptions section.
Result (Turnover)	Number of times stock is sold and replaced in the period	Calculated output	Typically annualised. A ratio of 1 means average stock was held for the entire year before selling.

Inventory Turnover Calculation Example (Step by Step)

A general retailer reports the following for the financial year: COGS of $500,000, beginning inventory of $100,000, and ending inventory of $66,666.

Identify COGS: $500,000 (from income statement)

Calculate Average Inventory: ($100,000 + $66,666) ÷ 2 = $83,333

Apply the formula: $500,000 ÷ $83,333 = 6.0×

Interpret: This retailer sold and replaced its average stock approximately 6 times during the year. For general retail (benchmark: 4–8×), this sits in the upper half — strong performance.

Inventory Turnover = 6.0× — stock replaces approximately every 61 days · Benchmark: General Retail 4–8× (upper half)

Calculate Your Inventory Turnover

Enter COGS and average inventory — or beginning and ending — and get your ratio and DIO instantly.

Open Calculator →

Inventory Turnover Formula Variants

The COGS-based formula is the standard, but there are three common variants used when data is limited or the audience requires a different measure. Understand the differences before choosing:

Standard (COGS-based)

COGS ÷ Average Inventory

The industry standard. Uses cost-basis for both inputs — the only apples-to-apples comparison. Required for published benchmarks.

Recommended — use this unless you have a specific reason not to

Revenue-based

Revenue ÷ Average Inventory

Used in some retail and analyst reports. Revenue includes markup, so the ratio is always higher than the COGS-based version.

Inflates the ratio — not comparable to standard benchmarks

Purchases-based

Purchases ÷ Average Inventory

Used when COGS is unavailable or cannot be reliably calculated — common in some small business or retail contexts where cost accounting is limited.

Less accurate — purchases ≠ COGS when inventory changes

Ending Inventory (simplified)

COGS ÷ Ending Inventory

Simpler — only requires one inventory figure. Used for quick estimates or when beginning inventory is unknown.

Distorted by seasonality — use average inventory where possible

Converting Inventory Turnover to Days (DIO Formula)

The turnover ratio tells you how many times per year inventory cycles. DIO (Days Inventory Outstanding) converts this to how many days stock sits before selling — often more intuitive for operations teams:

DIO = 365 ÷ Inventory Turnover

This can also be written directly from the underlying inputs: DIO = (Average Inventory ÷ COGS) × 365. Both formulas produce the same result.

Inventory Turnover	DIO (days)	Typical Sector
2×	183 days	Furniture, luxury goods
4×	91 days	Manufacturing, automotive parts
6×	61 days	General retail, apparel
12×	30 days	FMCG, grocery
52×	7 days	Fresh produce, bakeries

Convention note: some analysts use 360 days rather than 365 for DIO. Either is acceptable, but be consistent when comparing results over time or across companies. DIO is also referred to as Days Sales of Inventory (DSI) and Days Inventory on Hand — the same metric under different names.

Formula Assumptions and Limitations

COGS and inventory must cover the same period

Using annual COGS with a single month's ending inventory — or vice versa — produces a meaningless ratio. Always match the time periods. If you want a monthly turnover figure, use COGS for that month and average inventory from that month's start and end.

Average inventory may not reflect intra-period peaks

For businesses with strong seasonality, (beginning + ending) ÷ 2 can significantly understate or overstate the inventory actually held during the year. A retailer who builds up for the holiday season and then sells down will show a misleadingly low average. Use a monthly average (sum of 12 month-end figures ÷ 12) for greater accuracy.

Consistent cost accounting method required

COGS and inventory values must use the same cost method — FIFO, LIFO, or weighted average — applied consistently. Switching methods between periods distorts the ratio and makes trend analysis unreliable.

Only meaningful within the same industry

Inventory turnover ratios are only comparable between businesses in the same sector with similar margin structures. Comparing a grocery chain to a pharmaceutical distributor generates no actionable insight — their structural turnover levels differ by 3–4× for reasons unrelated to operational efficiency.

Frequently Asked Questions

What is the inventory turnover formula?

Inventory Turnover = Cost of Goods Sold (COGS) ÷ Average Inventory, where Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2. The result is the number of times you sold and replaced your stock in the period.

Why use COGS instead of revenue in the formula?

COGS is the cost of inventory sold — measured in the same units as the inventory on your balance sheet. Revenue includes markup, which inflates the ratio and makes inventory appear to turn faster than it actually does. Using revenue also makes your results incomparable to COGS-based industry benchmarks, which is the standard used by analysts, lenders, and published reports.

How do you convert inventory turnover to days?

DIO (Days Inventory Outstanding) = 365 ÷ Inventory Turnover. A turnover of 6× equals a DIO of 365 ÷ 6 ≈ 61 days. DIO tells you the average number of days inventory sits before being sold. It can also be calculated directly as (Average Inventory ÷ COGS) × 365. Some analysts use 360 days — be consistent when comparing results.

What is the difference between average inventory and ending inventory?

Average Inventory = (Beginning + Ending) ÷ 2 smooths out seasonal fluctuations and provides a more representative view of stock held during the period. Ending inventory is a single snapshot that can be distorted — artificially low after a season selldown or artificially high after pre-season buying. Average inventory is the standard and preferred input. For highly seasonal businesses, use a monthly average for even greater accuracy.

What are the variants of the inventory turnover formula?

The four main variants are: (1) COGS ÷ Average Inventory — the standard, most accurate formula; (2) Revenue ÷ Average Inventory — used in some retail benchmarks, but inflates the ratio; (3) Purchases ÷ Average Inventory — useful when COGS is unavailable; (4) COGS ÷ Ending Inventory — simpler but less accurate for seasonal businesses. The COGS-based standard formula is the only one that produces results comparable to published industry benchmarks.