Home / Professional / Business / Inventory Turnover Ratio

Inventory Turnover Ratio

Calculate your Inventory Turnover Ratio and Days Sales of Inventory (DSI). Identify trapped working capital, benchmark against industry standards, and quantify the cash freed by reducing your stock cycle.

Inventory Turnover Ratio Calculator

Inventory sitting on a shelf is cash that can't work for you. The Inventory Turnover Ratio tells you how quickly your business converts stock into sales — and its inverse, Days Sales of Inventory (DSI), reveals exactly how many days of supply you're carrying at any moment.

Annual COGS ($)

Cost of Goods Sold from P&L statement

Beginning Inventory ($)

Opening balance sheet inventory value

Ending Inventory ($)

Closing balance sheet inventory value

Average Inventory = ($80,000 + $100,000) / 2 = $90,000

Inventory Turnover = $500,000 / $90,000 = 5.56×

Days Sales of Inventory = 365 / 5.56 = 65.7 days

Avg Inventory Value

$90,000

Cash tied up in stock

Inventory Turnover

5.56×

per year

Days Sales of Inventory

days on shelf

Industry Benchmark Context

Healthy Range

Good balance of supply and demand

Practical Example

Company XYZ: COGS $500,000, Starting stock $80,000, Ending stock $100,000

Average Inventory = ($80,000 + $100,000) / 2 = $90,000
Inventory Turnover = $500,000 / $90,000 = 5.56×/year
Days Sales of Inventory = 365 / 5.56 = ~65.6 days

The company's warehouse is fully restocked every 65 days. This is near the low end of "Healthy" — they could potentially reduce average inventory by $20k (to $70k avg) and push turnover above 7×, freeing $20,000 in working capital without increasing revenue.

💡 Field Notes

High turnover isn't always better — the stockout trap: Retailers like luxury goods or fine wine intentionally maintain low turnover (1–2×) to signal exclusivity and allow proper aging. Conversely, a grocery store with 25× turnover in produce is normal — but a 25× turnover in hard goods suggests chronic under-ordering that causes stockouts. Customers experiencing empty shelves or weeks-long back orders don't wait — they switch to a competitor permanently. Optimal ITR varies enormously by industry: apparel (4–6×), grocery (15–20×), automotive parts (3–5×), pharmaceuticals (6–10×).
COGS vs. Sales as the numerator — an important choice: Some analysts use Net Sales instead of COGS in the numerator. Using COGS produces a more accurate ratio because it keeps the denominator (inventory at cost) and numerator (cost of goods sold) on the same cost basis. Using Sales inflates the ratio by the gross margin percentage, making cross-company comparisons misleading unless both companies have identical margins. Always use COGS for apples-to-apples comparison.
DSI as a working capital management tool: DSI × daily COGS = cash tied up in inventory at any given time. If DSI is 65 days and daily COGS is $1,370, you always have $89,000 locked in stock. Reducing DSI by 15 days would free $20,500 in cash — capital that could pay supplier invoices early (earning 2% discounts worth $10,000/yr on $500k COGS), reduce short-term borrowing, or fund growth initiatives.

Email Link Text/SMS WhatsApp

What is Supply Chain Efficiency and Working Capital Management?

Inventory Turnover Ratio is the foundational metric of supply chain health. It answers a deceptively simple question: how many times per year does a business sell through its entire stock? Its inverse — Days Sales of Inventory (DSI) — translates that ratio into the most actionable form: if sales stopped today, how many days would it take to sell everything on hand? Together, these metrics reveal whether cash is being trapped in overstock, whether stockouts are imminent from under-ordering, and whether the business's working capital cycle is healthy.

Mathematical Foundation

Average Inventory

\text{Avg Inventory} = \frac{\text{Beginning} + \text{Ending}}{2}

\text{Beginning}

= Inventory value at the start of the measurement period (opening balance sheet). Averaging beginning and ending smooths seasonal fluctuations that would distort a point-in-time snapshot.

\text{Ending}

= Inventory value at close of the period. If both are zero, the ratio is mathematically undefined — this only applies if the company carried no inventory whatsoever.

Inventory Turnover Ratio (ITR)

ITR = \frac{COGS}{\text{Avg Inventory}}

COGS

= Cost of Goods Sold from the income statement. Using COGS (not revenue) ensures numerator and denominator are both expressed at cost, making the ratio internally consistent. Revenue-based ITR is inflated by gross margin and incomparable across companies.

Days Sales of Inventory (DSI)

DSI = \frac{365}{ITR}

365

= Days in the year. Some analysts use 360 (banking convention). 365 is standard for supply chain and operational finance.

ITR

= The inventory turnover ratio. DSI is its reciprocal in days. ITR of 6× = DSI 60.8 days — meaning the business takes ~61 days to sell through its average inventory balance.

Laws & Principles

The Goldilocks Problem — High Turnover Isn't Always Better: A low ITR (1-2x) signals overstock: trapped cash, aging product, high carrying costs. But an extremely high ITR signals chronic under-ordering and stockout risk. Stockouts cost more than warehouse space: you lose the sale, train the customer to buy elsewhere, and permanently damage long-term revenue. The optimal ITR is always industry-specific.
COGS vs. Sales — Why the Numerator Choice Destroys Comparisons: Many published benchmarks use revenue (not COGS) in the numerator. This inflates the ratio by the gross margin percentage. A company with 40% gross margin computing ITR with revenue appears 67% faster than one using COGS, even if physical stock movements are identical. Always verify which numerator a published benchmark uses before comparing.
DSI as a Working Capital Lever: Cash tied up in inventory = DSI x (Annual COGS / 365). Reducing DSI by 10 days on $500,000 COGS frees ($500,000 / 365) x 10 = $13,699 in real cash. McKinsey research shows best-in-class supply chain performers carry 40-60% less inventory than average industry peers while maintaining or exceeding service levels.

Step-by-Step Example Walkthrough

" Specialty hardware distributor: Annual COGS $500,000. Beginning inventory $80,000. Ending inventory $100,000. "

1. Average Inventory = ($80,000 + $100,000) / 2 = $90,000.
2. Inventory Turnover = $500,000 / $90,000 = 5.56x per year.
3. DSI = 365 / 5.56 = 65.7 days.
4. What-if: reduce average inventory to $72,000 → ITR = 6.94x, DSI = 52.6 days.
5. Cash freed: $90,000 - $72,000 = $18,000 in unlocked working capital.

Final Result: ITR of 5.56x / DSI 65.7 days is healthy for hardware distribution. A modest inventory reduction from $90k to $72k average pushes turnover above 6.9x, freeing $18,000 in cash — with no revenue increase required.

Quick Answer: What does Inventory Turnover Ratio measure?

The Inventory Turnover Ratio measures how many times per year a business sells through its entire average inventory. A ratio of 6× means the company replenishes its stock 6 times annually — about every 61 days. Days Sales of Inventory (DSI) expresses this as calendar days: if turnover stopped today, DSI tells you exactly how many days of selling the current stock represents. Lower DSI = less cash trapped, faster cash conversion, lower carrying costs.

The Working Capital Formula Chain

Step 1 — Average Inventory

Avg Inventory = (Beginning Inventory + Ending Inventory) ÷ 2

Step 2 — Turnover Ratio

Inventory Turnover = COGS ÷ Average Inventory

Step 3 — Days Sales of Inventory

DSI = 365 ÷ Inventory Turnover Ratio

⚠ Always Use COGS — Not Revenue — in the Numerator

Using revenue instead of COGS inflates the ITR by your gross margin percentage, making the result incomparable to COGS-based industry benchmarks and incomparable internally across years when margins change.

Inventory Optimization Scenarios

✓ Lean Replenishment (Grocery Produce)

High-perishability forces extremely high turnover — a best practice model.

Setup: A grocery produce department runs COGS of $2,600,000/year. Average inventory maintained = $100,000 (buys and receives produce 5 days/week).
ITR: $2,600,000 / $100,000 = 26x per year.
DSI: 365 / 26 = 14 days average shelf life.
Result: With 14-day DSI, produce rotates almost perfectly with its natural shelf life. Shrinkage (waste) is minimized and cash is barely tied up in perishables. This is achievable only with daily supplier delivery agreements and tight demand forecasting.

✗ Inventory Glut (Seasonal Retailer)

Over-buying for peak season creates a year-round anchor on cash.

Setup: A ski apparel retailer. Annual COGS = $480,000. Over-purchases for winter: Beginning inventory $200,000, Ending inventory $180,000 (unsold spring carryover). Average = $190,000.
ITR: $480,000 / $190,000 = 2.53x.
DSI: 365 / 2.53 = 144 days — nearly 5 months of stock on hand at all times.
Result: $190,000 tied up in inventory year-round at 20% carrying cost = $38,000/year in hidden costs (warehousing, insurance, capital). Buying tighter with a target DSI of 90 days would reduce average inventory to $118,000 and free $72,000 in cash.

Industry Inventory Turnover Benchmarks

Industry	Typical ITR	DSI Equivalent
Grocery / Supermarkets	15 - 25x	15 - 24 days. Perishables demand extreme velocity.
Electronics / Consumer Tech	8 - 15x	24 - 46 days. Rapid obsolescence drives fast turns.
Automotive Parts	3 - 5x	73 - 122 days. Broad SKU range requires buffer stock.
Fashion Apparel	4 - 6x	61 - 91 days. Seasonal cycles create peaks and valleys.
Luxury Goods	1 - 2x	183 - 365 days. Exclusivity intentionally limits velocity.

Supply Chain Strategy Directives

Do This

✓Track ITR by SKU category, not just in aggregate. An overall ITR of 6x may mask that 20% of your SKUs turn at 15x while 30% of your inventory sits at 1.5x and consumes 40% of your warehouse space. SKU-level analysis reveals where to slash reorder quantities and free the most cash per square foot.
✓Use DSI reduction to quantify the cash-flow impact of purchasing decisions. Before committing to a large purchase order, calculate how increasing average inventory will change your DSI and how much cash that ties up. This converts abstract inventory arguments into concrete working capital impact numbers your CFO can directly compare to the cost of capital.

Avoid This

✗Don't compare your ITR to an industry benchmark without verifying the numerator. Many published industry ITR averages use revenue instead of COGS. A company with 30% gross margin using revenue will show an ITR 43% higher than the same company using COGS — rendering the benchmark comparison completely meaningless without adjusting for this difference.
✗Don't maximize ITR at the expense of stockout rate. Reducing inventory so aggressively that any demand spike causes stockouts is far more expensive than carrying modest buffer stock. The cost of a lost sale, a cancelled order, and a customer trained to use a competitor is typically 3-5x the carrying cost of the buffer inventory you 'saved.'

Frequently Asked Questions

Why does a retailer show a higher ITR than a manufacturer with the same COGS?

Retailers typically carry finished goods inventory only, while manufacturers hold raw materials, work-in-process (WIP), and finished goods simultaneously. Each stage of the manufacturing process adds time and value without incrementing the 'sold' portion of the ITR numerator. A manufacturer with 120 days of WIP and 30 days of finished goods will have a much lower aggregate ITR than a pure retailer holding only the same 30 days of finished goods, even if their ultimate sales velocity is identical.

How does economic order quantity (EOQ) relate to Inventory Turnover?

EOQ minimizes the total cost of ordering (setup/shipping cost per order × number of orders) plus holding costs (carrying rate × average inventory). The EOQ formula naturally produces an optimal order size that, combined with demand rate, implies a specific reorder frequency — which directly drives average inventory balance and therefore ITR. Companies that optimize EOQ by product category often find their ITR improves significantly without any forced reduction in service levels, because ordered quantities are mathematically justified by the true cost structure.

Can a business have an ITR that is too high?

Yes. An unusually high ITR relative to your industry can signal that the business is systematically under-stocking, leading to frequent stockouts and lost sales. It can also indicate that suppliers have extremely short lead times (which is a genuine competitive advantage, not a problem). The diagnostic test: check your stockout frequency alongside the ITR. If both ITR is very high and stockout rate is elevated, the business is over-optimizing inventory at the expense of service level and revenue potential.

How do inventory write-downs affect the Inventory Turnover Ratio?

Write-downs (reducing inventory to lower of cost or net realizable value) reduce the ending inventory balance without affecting COGS directly — which mathematically increases the calculated ITR. This can create a misleading picture: after a major write-down, a company's ITR appears to improve even though what actually happened is that obsolete or damaged inventory was acknowledged and removed from the balance sheet. Always review notes to financial statements for write-down disclosures before drawing operational conclusions from an unusually high ITR.

Inventory Turnover Ratio

Inventory Turnover Ratio Calculator