Stock Turn Calculator

How it is calculated

Stock turn is the retail counterpart of inventory turnover and is most often calculated in units: units sold in a period ÷ average units held. It can equally be run at retail value, sales ÷ average inventory at retail, which is the convention in most shops.

The unit version is the cleanest for a single product because it is unaffected by price changes and markdowns. The value versions are necessary for comparing across a mixed range, where units are not comparable at all.

Numbers on it

2,080 units sold in a year against an average of 174 units held. Stock turn is 11.95, the stock is sold and replaced about twelve times a year.

At retail value: $120,640 of sales against average inventory at retail of 174 × $58 = $10,092, giving 11.95 again. The two agree because there were no markdowns and the price did not change.

Introduce a season where 300 units sell at 30% off, and the retail-value turn falls to about 11.4 while the unit turn is unchanged. That gap is the markdown, made visible by running both.

What it does not tell you

Turn at cost and turn at retail give different answers whenever margin varies or markdowns occur, and comparing one business's cost-based figure against another's retail-based figure is meaningless. Retailers usually mean the retail version and manufacturers usually mean the cost version.

High turn also gets read as unambiguously good. A range turning eighteen times with a 12% stockout rate is turning fast because it keeps running out, and the lost sales exceed the carrying cost saved.

What follows from it

Track it per category and per SKU rather than for the business. The aggregate number is a board metric; the disaggregated ones tell you which parts of the range are working.

Then pair it with the stockout rate. Turn and availability move in opposite directions, and either one on its own can be improved by damaging the other, which is precisely what happens when turn is set as a target in isolation.

Turn as a space and capital allocation rule

In a shop or a warehouse with fixed space, turn decides how much room a product deserves. A line turning twenty times needs a fraction of the facings of one turning four to support the same sales, and reallocating space toward faster lines raises total sales without any change in stock investment.

The same logic applies to capital in an ecommerce business. Products turning slowly are consuming the funding that faster products could use, and a ranked turn report is the shortest route to identifying which ones.

The caution is to weight the reallocation by margin rather than turn alone, because a slow high-margin line can still be earning its keep. GMROI combines the two into one figure and is the better ranking for the final decision; turn is the better diagnostic for understanding why a product landed where it did.

Separately, a turn target applied uniformly across a range punishes the categories where slow turn is structural. Furniture, jewellery and specialist tools turn slowly because they are considered purchases, not because they are managed badly.

Setting the target per category, benchmarked against that category's own history, avoids the outcome where a buyer meets a corporate turn target by cutting exactly the depth of range that made the category work.