Systems & Software

Inventory Turnover Ratio: How to Calculate and Improve It

The inventory turnover ratio shows how many times you sell and replace stock in a year, and where cash is trapped on the racking.

The inventory turnover ratio tells you how many times you sell through and replace your stock in a year. A ratio of six means you cycle your entire inventory roughly every two months.

It is one of the few numbers that connects the warehouse directly to the balance sheet. Every unit sitting on a rack is cash that has already been spent and not yet recovered.

The calculation is simple. Reading it correctly is where most of the value sits, because a high ratio is not automatically good and a low one is not automatically bad.

Diagram showing how the inventory turnover ratio is calculated from cost of goods sold and average inventory
Turnover equals cost of goods sold divided by average inventory, then converted into days of cover.

How to calculate the inventory turnover ratio

Divide your cost of goods sold for the year by your average inventory value over the same period. Average inventory is usually the opening and closing values added together and halved.

Use cost rather than revenue on the top line. Dividing sales revenue by inventory at cost mixes two different bases and inflates the result, which makes the number useless for comparison.

Turning the inventory turnover ratio into days

Days of inventory is often more intuitive than turns. Divide 365 by your turnover figure and you get the average number of days a unit sits before it sells.

A ratio of six becomes about 61 days of stock. Expressed that way, the number is easier to discuss with people outside finance, and easier to compare against your supplier lead times.

What a good inventory turnover ratio looks like

There is no universal target, because the right figure depends almost entirely on what you sell. Grocery and fresh goods may turn thirty or more times a year. Industrial spares might turn twice, quite reasonably.

So compare against your own sector and your own history rather than a generic benchmark. The trend over several quarters usually tells you more than any single reading.

Why a high ratio is not always good

A rising ratio can mean efficient, disciplined purchasing. It can equally mean you are chronically understocked and losing sales you never recorded.

Always read turnover next to your service level and stockout rate. Fast turns alongside frequent shortages is not efficiency, it is a shortage dressed up as a good number.

What a low ratio is telling you

Slow turns usually mean cash is trapped. The common causes are over-ordering to chase volume discounts, obsolete lines nobody has written off, and forecasts that never got corrected after demand shifted.

Before launching a broad reduction programme, break the ratio down by item. A single large dead stock line can drag a whole category average down and send you optimising the wrong products.

Calculating turnover per item and per category

The company-wide figure is a headline, not a diagnosis. Running the same calculation per category, and then per item for your major lines, is where the actionable detail appears.

Pairing this with a value ranking helps you focus. Slow turns on a high-value item deserve immediate attention, while slow turns on a cheap, critical spare may be entirely intentional.

Practical ways to improve the inventory turnover ratio

Start by clearing what is already dead. Discounting or writing off obsolete stock improves the ratio and frees space, even though it is an uncomfortable conversation.

Then work on order quantities. Smaller, more frequent replenishment reduces average inventory, provided your supplier terms and inbound costs support it.

Finally, tighten the forecast and buffer sizing. Much excess stock is simply safety stock that was set once, generously, and never revisited as demand settled.

How the ratio fits your other metrics

Turnover makes most sense alongside service level, gross margin and carrying cost. Improving turns while service collapses is not a win, and neither is holding perfect availability funded by a warehouse full of idle cash.

The inputs have to be trustworthy, which means accurate stock records from regular cycle counting and properly sized safety stock. Classifying items with an ABC analysis shows where slow turns actually cost you money, and most inventory management platforms can report all of this automatically. For external context, the US Census Bureau publishes inventory and sales ratios by sector, and ASCM maintains the standard definitions.

Frequently asked questions about the inventory turnover ratio

Should you use sales or cost of goods sold?

Use cost of goods sold. Using revenue mixes a selling-price numerator with a cost-based denominator and produces an inflated figure that cannot be compared with anything.

How often should you measure it?

Monthly at category level and quarterly at company level works for most operations. Measuring too frequently tends to surface noise rather than genuine movement.

Can the ratio be too high?

Yes. Very high turns often come with stockouts, rushed inbound freight and no room to absorb a supply disruption, all of which cost more than the saved carrying cost.

The practical takeaway

Calculate turnover from cost of goods sold, convert it to days for clarity, and always read it beside your service level. Break it down by item to find trapped cash, clear dead stock first, then tighten order quantities and buffers.