Tag Archives: Turn

Interpreting Turn Numbers

No Retail Math number is useful unless you are able to interpret it, 24607796422_e5979e3304_q
and this is just as true for inventory turnover rates as it is for sales or profit figures.

In general, retailers prefer high inventory turnover numbers.  The higher the inventory turnover, the more times the retailer has sold their average inventory.  This means that a higher turnover rate normally correlates with higher levels of sales and profits.

Let’s Calculate!
Retailer #1 carries an average retail inventory of $300,000 and has annual sales of $900,000.  This gives them an inventory turnover of 3.0 ($900,000/$300,000).  If Retailer #1 has no markdowns and a maintain margin of 10%, then they will achieve a profit of $90,000 ($900,000 * 10%).

Retailer #2 carries the same average retail inventory of $300,000, but manage their inventory more efficiently, turning it 4.0 times that year.  This gives Retailer B annual sales of $1,200,000 ($300,000 * 4.0).   If they also have no markdowns and a maintain margin of 10%, they will earn an annual profit of $120,000 ($1,200,000 * 10%).

Is it always true that a bigger turn number is better?  While retailers do generally prefer that their inventory turnover rates increase, there are 2 exceptions to this rule.

The first is when dealing with a loss leader.  If a retailer has a negative initial margin for a particular item, then they may not wish to drive their turnover numbers higher.

The second is when the retailer’s out of stock levels are high.  This situation is one which will be covered in a future post.

photo credit: danielfoster437 <a href=”http://www.flickr.com/photos/17423713@N03/24607796422″>Fresh Produce</a> via <a href=”http://photopin.com”>photopin</a> <a href=”https://creativecommons.org/licenses/by-nc-sa/2.0/”>(license)</a>

Inventory Turnover: Retail, Cost, or Unit?

Periodically I have students who are confused by the idea that there is not one, but three different ways to calculate inventory turnover.  What really confuses them is that when using all three formulas to calculate inventory turnover (turn) for a retailer, each formula provides a different answer.  And, that this happens even though each formula has the same two basic components:  Sales and Average Inventory.

Let’s start with the formulas:
Retail Turnover = Annual Retail Sales/Average Retail Inventory
Cost Turnover = Cost of Goods Sold/ Average Cost Inventory
Unit Turnover = Unit Sales/ Average Unit Inventory

Example:

Retailer Z’s Financials Show:

Total Retail Sales $2,000,000
Cost of Goods Sold $1,200,000
Unit Sales 180,000
Avg. Inventory at Retail $400,000
Avg. Inventory at Cost $220,000
Avg. Inventory in Units 30,000

Let’s Calculate!
Retail Turnover = Average Retail Sales/Average Retail Inventory
= $2,000,000/$400,000  = 5.0

Cost Turnover = Cost of Goods Sold/ Average Cost Inventory
= $1,200,000/$220,000 = 5.5

Unit Turnover = Unit Sales / Average Unit Inventory
= 90,000/ 15,000 = 6.0

While the inputs are similar, they are not identical, due to each one utilizing a different method of measurement.  Typically Retail Turnover will provide you with the most conservative estimate of your turn rate out of the three calculations.  This is due to the fact that the Retail Sales and Average Retail Inventory numbers both have initial margin (or markups) built into them.

Next time we’ll look at interpreting and using these numbers.