Reach truck moving a pallet through a high-bay warehouse aisle

Inventory Turnover: Formula, Examples and How to Improve It Without Stockouts

Inventory turnover, or the inventory turnover ratio, is the number of times a business sells and replaces its average inventory over a period, usually a year, calculated as cost of goods sold divided by average inventory. A higher ratio means each unit spends less time in stock and the same sales tie up less cash.

The ratio is easy to compute and easy to misread. One company-wide number blends fast and slow products, stores and DCs, online and store stock, and it can rise because shelves went empty.

What Is Inventory Turnover?

Inventory turnover (also called inventory turns or the stock turnover ratio) measures how quickly inventory converts into sales. If a retailer turns its inventory 8 times a year, the average unit sits in stock for about 46 days before it sells. Finance reads it as a cash measure, planners as a sign of whether stock matches demand. Every extra day of inventory is cash tied up in product, plus the cost of storing, handling and sometimes throwing it away. Slow turns also raise the risk that stock ages into excess and obsolete inventory, which ends in markdowns or write-offs.

How Do You Calculate the Inventory Turnover Ratio?

To calculate the inventory turnover ratio, divide cost of goods sold by average inventory at cost, or units sold by average units on hand. Use the cost version for reporting and for comparing categories, and the units version for planning a single item or location.

Cost-Based Formula

Inventory turnover = cost of goods sold ÷ average inventory

Average inventory = (beginning inventory + ending inventory) ÷ 2

Use COGS, not sales revenue. Sales include margin while inventory is carried at cost, so a sales-based ratio comes out higher than the real one, and it moves whenever prices or margins change. The exception is the retail method: retailers that value inventory at selling price compute turns as sales ÷ average inventory at retail, which is consistent because both sides are at retail. The error is mixing sales with inventory at cost.

For seasonal businesses, two balance-sheet dates can badly misstate the average. A year-end count taken after the holiday sell-down makes inventory look smaller than it was for most of the year. Averaging the 12 or 13 month-end balances gives a fairer denominator.

Units-Based Formula

Inventory turnover (units) = units sold ÷ average units on hand

Planners use this for a single SKU, store or DC. It avoids distortion from cost changes and valuation methods (FIFO, weighted average), but units of different products can’t be added together, so it doesn’t work at company level.

Worked Example

A regional retailer reports cost of goods sold of $12 million for the year. Inventory at cost was $2.6 million at the start of the year and $3.4 million at the end.

  1. Average inventory = ($2.6M + $3.4M) ÷ 2 = $3.0M
  2. Inventory turnover = $12M ÷ $3.0M = 4.0 turns
  3. Days of inventory = 365 ÷ 4.0 = about 91 days

For one item: a store sold 4,800 units of a cereal SKU in a year and held 400 units on average. That’s 4,800 ÷ 400 = 12 turns, or about 30 days of stock.

What Is the Difference Between DIO and Days of Supply?

Days inventory outstanding (DIO), also called days sales of inventory or days on hand, converts turns into days: DIO = 365 ÷ inventory turnover, or equivalently average inventory ÷ COGS × 365. Four turns is about 91 days; 12 turns is about 30. The two measures move in opposite directions, so lower DIO means higher turns.

Days of supply is often used as a synonym, but planners usually mean something forward-looking by it: days of supply = current inventory ÷ forecast average daily demand. DIO describes the past year from the accounts. Days of supply tells you how long today’s stock will last against expected demand, which is the number a replenishment decision needs. A seasonal item can show high DIO for the year and only a few days of supply going into its peak week. Weeks of supply is the same idea divided by seven.

How Should You Read Inventory Turnover?

A single inventory turnover ratio is an average of very different products, locations and channels, and averages hide both problems and wins. Read it by segment, and always next to an availability measure. Turns that rose because shelves emptied are a worse result than flat turns with full shelves.

Why One Average Hides the Mix

Suppose the retailer above has two product groups. Group A (fast sellers) has $9M of COGS on $1M of average inventory: 9 turns. Group B (slow sellers) has $3M of COGS on $2M: 1.5 turns. Together they make the 4.0 turns in the example. Two-thirds of the inventory sits in the group that accounts for a quarter of cost of goods sold.

The same thing happens across locations and channels:

  • SKU. A long tail of slow sellers can hold a large share of stock while the fast sellers run short.
  • Location. Stores and DCs turn at different rates: stores carry display and minimum-facing stock, DCs carry pooled safety stock and forward buys. A store with a back room full of last season’s stock turns slowest of all.
  • Inventory accuracy. If the stock record overstates what’s really there (phantom inventory), the calculated turns look slower than reality, and replenishment stops reordering items that are actually out.

When Is Higher Turnover Worse?

Inventory falls fastest when you stop buying, so a category that cuts orders posts better turns until its best sellers run out. Pair turns with on-shelf availability or fill rate and with lost sales. If availability dropped at the same time, you swapped carrying cost for lost sales, and lost sales are usually the more expensive of the two. Turns also say nothing about margin; GMROI (gross margin ÷ average inventory at cost) shows whether faster turns earned money. The inventory replenishment guide covers how stockouts start.

What Is a Good Inventory Turnover Ratio?

There’s no single good number. Turns vary widely by category: products with short shelf lives and daily deliveries turn much faster than durable goods with long supplier lead times and wide assortments (see food and beverage supply chain best practices). Compare against your own history for the same category, and against peers in the same category using their published COGS and inventory.

Check these instead of chasing a benchmark:

  1. Trend by segment. Are turns rising in the categories where you changed something, and holding elsewhere?
  2. Turns next to availability. Did fill rate or on-shelf availability hold while turns rose?
  3. Days of supply against lead time. If an item holds 90 days of supply, its supplier delivers in 7 days and you order weekly, most of that stock covers neither the lead time nor the review gap, unless a minimum order quantity or a planned forward buy explains it.

A ratio below 1 means the business held more inventory at cost, on average, than it sold during the period. That’s normal for some slow-moving spare parts and rare for fast-moving consumer goods.

How to Improve Inventory Turnover Without Hurting Availability

Raise turns by holding less stock that doesn’t protect sales, while keeping the stock that does. Cutting buy budgets across the board raises turns and stockouts together.

LeverHow it raises turnsHow it protects availabilityWatch for
Forecast accuracyLess buffer needed for the same service levelFewer misses on promotions, holidays and local eventsMeasure error by item and location, not in total
Dynamic safety stockRemoves buffers sized for last year’s volatilityRaises buffers where forecast error or lead-time variance grewStatic levels drift out of date within months
Replenishment frequencySmaller, more frequent orders lower cycle stockShorter review periods shrink the safety stock the review gap needsTransport, handling and minimum order quantities
AssortmentDelisting the slow tail frees cash and shelf spaceSpace and buying focus go to items customers wantCheck substitution before delisting
Markdown timingEarlier, shallower markdowns clear seasonal stock before it agesFrees space and budget for in-season replenishmentLate, deep discounts cost more margin
Network designFewer or better-placed stocking points pool safety stockPooled buffers absorb demand swings across more storesLonger last-mile distance can raise cost to serve

Safety stock deserves a closer look because excess often hides there. The textbook calculation sizes the buffer from the standard deviation of demand over the lead time plus the review period, times a service-level factor. If an input is out of date, such as last year’s volatility or the contract lead time instead of the actual one, the buffer is wrong everywhere it’s used. Inventory planning that recalculates targets from actual forecast error and lead-time variability keeps those inputs current, and demand planning supplies the forecast error. Inventory management vs. inventory planning explains where those targets come from.

Markdowns and the network set limits too: see pricing and markdown optimization and strategic network design.

How Decision Automation Raises Inventory Turns

Turnover improves when thousands of daily stock decisions get slightly better at once: each store order, DC purchase and transfer sized to forecast demand and current risk. A decision automation system can recalculate them daily. The gain only reaches the shelf when the recommendations are good enough that planners stop editing them.

Orders have to reflect promotions, local demand, pack sizes, delivery days and shelf life. When they do, planners stop adding their own buffers on top, and that informal safety stock is often what kept turns low. At Mopaş, users accept 93% of the store replenishment decisions; that share is the user acceptance rate.

Grocery retailers that moved from manual or store-order-driven replenishment to demand-driven replenishment report less inventory and fewer stockouts in the same project:

  • A101 automated demand-driven replenishment and DC purchasing on one platform: stock-outs fell 50% and inventory fell 18%. (case study)
  • Mopaş, a grocer with 121 stores and one DC, replaced manual, store-order-driven replenishment: inventory cost fell 14% and lost sales fell 58%. (case study)
  • Şok, a hard discounter with 2,500 stores and 18 DCs at the time, automated store replenishment and purchase order planning: stock-days fell 13% and stock-outs fell 38%. Stock-days is the same family of measure as DIO. (case study)

Outside grocery, g2m, a foodservice distributor supplying hotels, restaurants and cafés from 8 DCs with 17,000+ SKUs, set out to balance inventory investment against service commitments. Its case study lists “$8.7M Annual Savings by Inventory Turn” alongside a 40% OTIF improvement.

Solvoyo, a supply chain decision automation platform, runs store, DC and online replenishment this way through its omnichannel inventory and replenishment solution.

Frequently Asked Questions

What is a good inventory turnover ratio?

It depends on the category. Products with short shelf lives and frequent deliveries turn much faster than durable goods with long lead times, so a single target across a business means little. Compare each category against its own history and against peers in the same category, and check that availability held steady while turns improved.

Is high inventory turnover always good?

No. High turns usually mean lean stock and steady sales, but very high turns can also mean stock is too thin to cover demand, so stockouts and lost sales rise. Turns can also jump for a month simply because purchasing stopped. Read turnover alongside fill rate, on-shelf availability and lost sales, and treat a turnover gain as real only when service held.

What is the difference between inventory turnover and days inventory outstanding?

They measure the same thing in different units. Inventory turnover counts how many times average inventory sold during a period; days inventory outstanding counts how many days the average unit sat in stock. DIO equals 365 divided by annual turns, so 4 turns is about 91 days and 12 turns is about 30 days. Lower DIO means higher turnover.

Should I use sales or cost of goods sold to calculate inventory turnover?

Use cost of goods sold. Inventory is carried at cost, so dividing sales revenue by inventory mixes selling prices with cost values and overstates turnover by the markup: at a 30% gross margin, a sales-based ratio reads about 43% high. A sales-based ratio also shifts when prices or margins change even if stock levels don’t. If you only have sales data for one item, the units-based formula (units sold ÷ average units on hand) is the cleaner alternative.


See It Run on Your Own Data

See how Solvoyo turns your supply chain plans into decisions that run on their own.

Solvoyo mascot