Skip to content
Calculator Collection

Inventory Turnover Calculator

Calculate inventory turnover — how many times per year a company sells through its average inventory balance. Use it to measure how efficiently a business is converting inventory into sales and to spot overstocking, slow-moving products, or supply-chain issues.

Last updated: May 2026

Compare with similar

About this calculator

The formula is: inventory turnover = cost of goods sold ÷ average inventory. The numerator is COGS for the period (annual COGS for an annual turnover ratio); the denominator is average inventory, computed as (beginning inventory + ending inventory) ÷ 2 across the same period. The result is unitless and tells you how many times the company's entire average inventory was sold and replaced during the period. Higher turnover usually indicates efficient inventory management — products are moving quickly, capital is not stuck on the shelf, and obsolescence risk is low. The metric is often paired with days inventory outstanding (DIO), defined as 365 ÷ turnover, which converts the ratio to calendar days: a turnover of 12 means inventory turns monthly (30 DIO); a turnover of 4 means inventory turns quarterly (91 DIO). Some analysts use sales instead of COGS in the numerator; this is technically wrong because sales include markup over inventory cost, so it inflates the apparent turnover, but it is a common shortcut when COGS is not disclosed. Edge cases: a zero or near-zero inventory balance produces extreme turnover values; service businesses with no physical inventory have undefined ratios. Industry norms vary enormously: groceries 12–25, fast-food 30+, fashion retail 4–8, jewelry 0.5–1.5, automotive dealers 3–8, big-box retail 6–12, luxury 2–4. A high turnover within an industry usually reflects strong merchandising, lean supply chain, and fast-moving products; a low turnover suggests overstocking, slow sellers, or seasonal mismatches. But too-high turnover can also signal understocking and lost sales from stock-outs — there is an optimum, not a maximum.

How to use

Example 1 — Grocery chain. Annual COGS is $720,000,000. Beginning inventory was $58,000,000 and ending inventory was $62,000,000, so average inventory = (58M + 62M) / 2 = $60,000,000. Enter 720000000 for COGS and 60000000 for Average Inventory. Result: 12.0. Verify: 720M / 60M = 12.0. ✓ A turnover of 12 means inventory turns roughly once per month (about 30 DIO), strong for grocery and consistent with the industry norm of 12–18 for typical supermarket chains. Lower numbers in this industry usually point to bloated inventory or sluggish sales. Example 2 — Specialty furniture retailer. Annual COGS is $14,500,000 and average inventory is $7,250,000. Enter 14500000 and 7250000. Result: 2.0. Verify: 14.5M / 7.25M = 2.0. ✓ A turnover of 2.0 means about 182 days inventory outstanding (365 / 2 = 182), reasonable for specialty furniture where products are large, expensive, customizable, and slow-moving compared to general retail. The figure becomes a yellow flag only if it falls further (say, to 1.2–1.5) without a corresponding strategic decision to broaden inventory, or if certain SKUs sit for many years without selling.

Frequently asked questions

What is a good inventory turnover ratio?

Industry-dependent. Grocery chains and fast-food run 12–25; convenience stores 15–20; big-box retail 6–12; fashion retail 4–8 (seasonally constrained); automotive dealers 3–8; furniture and appliances 2–4; jewelry 0.5–1.5 (specialty, slow-moving); industrial manufacturers 4–8. The right benchmark is industry peers and your own multi-year trend. A turnover that has been steadily declining suggests accumulating slow-moving inventory or a shift toward broader assortment without corresponding sales velocity; that is usually a yellow flag because slow-moving inventory eventually requires markdowns and write-offs. A turnover that has been steadily rising might reflect leaner operations, better forecasting, or a deliberate shift to a tighter assortment — generally healthy unless it has gone so high that the business is missing sales due to stock-outs.

How do I convert inventory turnover into days inventory outstanding?

Days inventory outstanding (DIO) = 365 ÷ inventory turnover. So a turnover of 12 means 30 DIO; a turnover of 6 means 61 DIO; a turnover of 2 means 182 DIO. DIO is often more intuitive than the turnover ratio for operational discussions — it directly answers "how many days of sales worth of inventory do we hold on average?" Compare DIO to your reorder lead time and seasonal sales cycle: if you reorder weekly and DIO is 90, you have 13× too much on hand; if DIO is 5, you're running on fumes and may face frequent stock-outs. DIO is also a key input to the cash conversion cycle, which combines DIO, DSO (days sales outstanding), and DPO (days payable outstanding) to measure overall working-capital efficiency.

Can inventory turnover be too high?

Yes. Very high turnover can signal that the business is consistently understocked, missing sales when customers can't find what they want, and accepting lost revenue in exchange for low working-capital investment. Stock-out costs are often invisible (customer walks out, buys from a competitor, never returns) and can dwarf the inventory-holding cost they avoid. A turnover well above industry peers also raises questions about product breadth — are you stocking only the fastest-moving SKUs and losing the long-tail customer who wants something specific? The optimum is high enough to avoid bloat and obsolescence but low enough to maintain availability across the assortment. For mature retailers, the right turnover usually falls within a band that supports 95–98% in-stock rates for top-selling SKUs.

What are the most common mistakes people make using inventory turnover?

The biggest is using sales instead of COGS in the numerator — sales include markup, which inflates the turnover ratio and overstates efficiency. The second is using ending inventory instead of average; this distorts the ratio whenever the business is growing or seasonal. The third is mixing inventory categories — a healthy turnover overall can hide that 30% of SKUs haven't moved in 12 months and will need to be marked down or written off; segment the calculation by SKU class for actionable insight. The fourth is comparing turnover across companies with different fiscal year-ends — a retailer measured at January 31 (post-holiday) will look very different from one measured at June 30. The fifth is interpreting turnover in isolation rather than alongside gross margin: a strategy of low margin + high turnover (Costco) and high margin + low turnover (luxury) can both be profitable.

When should I not use this calculator?

Skip it for service businesses with no physical inventory — the metric doesn't apply. For software, consulting, and other zero-inventory businesses, focus on revenue per employee, gross margin, and customer-related metrics instead. Skip it for businesses with extreme seasonality (toy retailers, summer/winter apparel) using a snapshot ratio — the seasonal pattern matters more than any single point in time. Do not use it for businesses with high-value low-volume products where one large transaction can swing the ratio (private jets, custom industrial equipment, real estate development). It is also a poor fit for businesses with significant work-in-progress inventory (custom manufacturers, long-cycle producers) where finished-goods inventory is a small fraction of total inventory and turnover dynamics are very different. For comprehensive working-capital analysis, pair inventory turnover with A/R turnover and the cash conversion cycle.

Sources & references