“Turn turn turn, see whats become of me” was prophetically written by Simon and Garfunkel over 40 years ago.  I am not sure if they were thinking of retail at the time but truer words could not be sung.  Retail is based on buying goods and then selling them for more than you paid for them.  If you only do that one time you do not make much cash.  The more times you can sell your inventory, the more cash you make.  Every time you sell your inventory you have “turned” it one time.  The more times you turn your inventory, the more cash you put in your coffers.  Turn turn turn and see what will become of YOU!

Turn is the relationship between inventory and sales and determines the success a retailer has in generating cash.   Just like any measurement, to be useful the measurement must be applied at the right place to have meaning.  Although a general indicator of a store’s success can be indicated by overall turn, a much more useful application of turn occurs at the classification level.  Every class should have a targeted turn based on the store’s location and character, the type of inventory (staple, fashion, hard goods etc. ), the season and many other variables that are all part of an effective merchandise plan.  When a classification is turning too fast, it could likely indicate that sales are being lost due to lack of selection, sizes or depth. If a classification is turning too slowly, there is too much inventory due to overbuying, old goods or other reasons that are taking up cash, space and focus while not generating sales.  Unless you have the right target, you don’t know what is too fast or too slow!

The Formula

Turnover is calculated over a continual 12 month period of time.  It is 12 months of retail sales divided by the average retail inventory over a 12 month period.  A good estimate of  turn rate can be calculated by  taking the first of month inventory amount for 12 consecutive months plus the ending inventory at the end of the 12th month and dividing this number by 13.  This will yield the average inventory amount.  Now divide the total sales for the same 12 month period by the average inventory amount to get the annual inventory turnover rate. In a seasonal business, annual turn is the best way to analyze turn.  We  also do a 12 month rolling average turn to get the most recent data but still including a year’s worth of data.

Why is Turnover rate Important?

The questions that a calculation of turn answers is whether you would like surplus inventory sitting on your racks or more cash in your bank account.  Too much inventory on the racks, ties up cash, yet not enough inventory results in lost sales.  Turn is the relationship between the inventory and the sales and when done at the class level, helps you find the right balance for your store.   Since turn generates cash, your challenge is to increase sales without increasing inventory. That is the goal of the science of merchandise planning! The secret lies within the art of sales forecasting for each classification. The skill lies in arriving at the right target turn rate for each classification in each store.  The results come from adhering to the right plan.

Simon and Garfunkel got it right. Turn is the key to your success.  Focus on it. Manage it. Plan for it. See what will become of you.