Inventory Turnover Ratio Calculator

What Is Inventory Turnover?

The inventory turnover ratio shows how many times a business sells through and replaces its inventory in a given period. A higher number means stock is moving; a lower number means product is sitting on shelves, tying up cash and taking up space. It's also called the stock turnover ratio, and it's one of the first numbers warehouse, operations, and finance teams check when they look at inventory health.

Inventory Turnover Formula: How to Calculate It

The inventory turnover formula is Inventory Turnover = Cost of Goods Sold ÷ Average Inventory. To calculate it:

1. Pick a period — usually a year — and use it for every number.
2. Find your cost of goods sold (COGS) for that period.
3. Find the value of your inventory at cost at the start and the end of the period, and average them: Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2.
4. Divide COGS by average inventory.

Worked example

A business has $1,200,000 in annual COGS, $280,000 of inventory at the start of the year and $320,000 at the end. Average inventory is ($280,000 + $320,000) ÷ 2 = $300,000, so inventory turnover is $1,200,000 ÷ $300,000 = 4.0 turns per year.

Raise that to 4.8 turns (a 20% improvement) and the same $1,200,000 of COGS needs only $250,000 of average inventory — about $50,000 in cash freed. The calculator above runs this math on your numbers.

One limit of the formula: averaging only the beginning and ending inventory assumes stock moved steadily between the two. If yours swung a lot mid-period — a seasonal peak, a big one-time purchase, a clearance — the two-point average can misstate your true turnover. For a more accurate figure, average monthly inventory values instead and enter that average as both the beginning and ending inventory.

Days sales of inventory (days inventory outstanding)

Turnover converts directly into days on hand, also called days sales of inventory (DSI) or days inventory outstanding (DIO): Days on Hand = Days in Period ÷ Inventory Turnover. At 4.0 turns, a 365-day year gives 365 ÷ 4.0 ≈ 91 days — on average, inventory sits about three months before it sells.

What's a Good Inventory Turnover Ratio?

There's no single good number — it depends on what you sell. Fast-moving consumables turn many times a year, while bulky, slow-selling goods turn only a few. Compare yourself to your own category, and to your own trend over time, rather than to a universal target.

Historical industry averages on a cost-of-sales basis, from CSIMarket's industry efficiency data, which is compiled from U.S. public companies and so skews toward larger businesses. Benchmarks depend on the formula used — this calculator uses COGS ÷ average inventory at cost — so treat them as a starting point.

Is a high or low ratio better?

A low ratio can mean overstock, slow-moving or obsolete items, or cash tied up in stock. A very high ratio isn't automatically good either — it can mean you're running lean enough to risk stockouts and lost sales. The goal is the highest turnover you can sustain while still filling orders.

How to Improve Inventory Turnover

• Find and clear slow movers. Rank SKUs by days on hand and decide what to discount, bundle, or stop reordering.
• Reorder to demand, not habit. Set reorder points and quantities from actual sales velocity and supplier lead times.
• Shorten replenishment cycles. More frequent, smaller orders mean less stock on hand at any moment, if your suppliers allow it.
• Keep counts accurate. If the system says you have stock you don't, you reorder late; if it says you have less than you do, you overbuy.
• Review by SKU, not just in total. A healthy overall ratio can hide a handful of SKUs that account for most of the excess.

How Your WMS Impacts Inventory Turnover

Inventory turnover is only as trustworthy as the inventory number behind it. A warehouse management system gives you real-time visibility into what's on hand and where, supports cycle counting and replenishment, and shows you which items are moving and which are aging — so you reorder from data instead of estimates. SphereWMS gives growing companies and 3PLs that real-time inventory accuracy, which is what lets you carry less stock without running out.

Related reading: Inventory Turnover Ratio: A Guide for Warehouse Management · Excess Inventory: The Hidden Costs and 6 Ways to Clear It