An Explanation of Inventory Turnover


A relationship exists between inventory and sales. This is referred to as ‘Inventory Turnover’ or ‘Turnover Ratio’. It is simply the number of days it takes to turn over the dollar value of the inventory. This relationship is important because as the retailer, you would want this number has high as possible. You should not use this ratio to compare yourself to another similar store for various reasons, use it to compare yourself to the industry as a whole or to compare to past performances from the same store. It is a mere standard for internal comparison only; it is not a gauge of value. But if properly implemented and utilized, the retail store owner can maximize profits. 

There are three components to the formula. One is the sales, usually the annual dollar sales associated with the inventory element, i.e. don’t include services rendered in the sales value. Secondly, you would need the average dollar value of your inventory for the same period of time at retail value. The third number is the ratio or number of turns of the inventory in that period of time. Naturally the number is a relationship using the following formula:

Sales/Avg Inventory = Inventory Turnover

Let’s assume you own an auto parts store. Total sales in the year were 2.3 million and your average inventory runs around $237,000 at retail value, then your inventory turnover is 9.7. By knowing two of the pieces of the formula, you can derive the third. The formula is used to evaluate trends or performance of sales staff. A lower turnover rate with a similar sized inventory would mean lower sales. A higher turnover rate does imply better sales but it could identify poor stock levels. That is you may be losing out on some lost sales.

You cannot compare this number to another store for several reasons. First off, you may not have the same retail markup or the same type of customer. What if you sold only parts to hot rods? Your customer is significantly different than those for a Honda only parts supplier or a general parts supplier. Also, you may not be involved in the same line of products, yours could be non-body types of parts with an emphasis on exhaust systems whereas the other party could be maintenance based (filters, oil, lubricants, light bulbs). 

There are a multitude of other factors that impact the final turnover ratio. Many organizations use Cost of Goods Sold divided by the average cost of inventory to calculate the number of turns. Whatever you do to calculate this number, you must use the same formula each period of time for evaluation purposes. 

What is this formula used for in business? 

This formula is used to evaluate performance of your store to the industry as a whole. Do not use the formula to compare your store to another store, even if you own two stores in different parts of town. Unless you had the exact same customers, same vendors with same markups etc. you are not comparing apples to apples. This is really a wonderful tool to evaluate the sales performance in the company from one period to the next. It also will allow you to experiment at times with product lines or shifting trends. The sidebar illustrates a real life reason to not rely on the ratio too much. 

By understanding the formula, it’s purpose, and how to implement it in your store, you can begin to increase the actual dollars of profit. Act on Knowledge.

One of my former clients owned an RV Parts Supplies store. Back in the late 80’s, many of the campgrounds installed electricity at the sites. It wasn’t long before RV Campers were bringing their household window AC units on their camping trips. The industry responded by building custom made A/C units to fit on Pop-ups and trailers.

His parts manager relied on the inventory ratio for comparison purposes.  He didn’t want to carry too many of these A/C units in inventory because the cost was high and the margins were low.  Thus the turnover ratio would go down. The problem was that when the store sold an A/C unit the profit increased significantly that day. However, there were many days buyers had no A/C units in stock to choose from in the inventory. On one day, four customers sought A/C units at another store.

Sounds like a lost sale to me.

It took me about a year to convince the owner to stratify the inventory into groups and use ratios for the groups to evaluate performance.  By doing this, he was able to increase the margin in whole dollars but it did change his overall turns. The turn rate decreased slightly for whole inventory, but his margin went up. I reminded him that at the end of the day, it is about making money, not complying to some formula.

Value Investing

Do you want to learn how to get returns like this?

Then learn about Value Investing. Value investing in the simplest of terms means to buy low and sell high. Value investing is defined as a systematic process of buying high quality stock at an undervalued market price quantified by intrinsic value and justified via financial analysis; then selling the stock in a timely manner upon market price recovery.

There are four key principles used with value investing. Each is required. They are:

  1. Risk Reduction – Buy only high quality stocks;
  2. Intrinsic Value – The underlying assets and operations are of good quality and performance;
  3. Financial Analysis – Use core financial information, business ratios and key performance indicators to create a high level of confidence that recovery is just a matter of time;
  4. Patience – Allow time to work for the investor.

If you are interested in learning more, go to the Membership Program page under Value Investing section in the header above. 

Join the value investing club and learn about value investing and how you can easily acquire similar results with your investment fund. Upon joining, you’ll receive the book Value Investing with Business Ratios, a reference guide used with all the decision models you build. Each member goes through three distinct phases:

  1. Education – Introduction to value investing along with terminology used are explained. Key principles of value investing are covered via a series of lessons and tutorials.
  2. Development – Members are taught how pools of investments are developed by first learning about financial metrics and how to read financial statements. The member then uses existing models to grasp the core understanding of developing buy/sell triggers for high quality stocks.
  3. Sophistication – Most members reach this phase of understanding after about six months. Many members create their own pools of investments and share with others their knowledge. Members are introduced to more sophisticated types of investments and how to use them to reduce risk and improve, via leverage, overall returns for their value investment pools.

Each week, you receive an e-mail with a full update on the pools. Follow along as the Investment Fund grows. Start investing with confidence from what you learn. Create your own fund and over time, accumulate wealth. Joining entitles you to the following:

  • Lessons about value investing and the principles involved;
  • Free webinars from the author following up the lessons;
  • Charts, graphs, tutorials, templates and resources to use when you create your own pool;
  • Access to existing pools and their respective data models along with buy/sell triggers;
  • Follow along with the investment fund and its weekly updates;
  • White papers addressing financial principles and proper interpretation methods; AND
  • Some simple good advice.

Value Investment Club

Please Signup
*
Username
Username can not be left blank.
Please enter valid data.
This username is already registered, please choose another one.
This username is invalid. Please enter a valid username.
*
First Name
First Name can not be left blank.
Please enter valid data.
This first name is invalid. Please enter a valid first name.
*
Last Name
Last Name can not be left blank.
Please enter valid data.
This last name is invalid. Please enter a valid last name.
Website (URL)
Website (URL) can not be left blank.
Invalid URL
Invalid URL
*
Email Address
Email Address can not be left blank.
Please enter valid email address.
Please enter valid email address.
This email is already registered, please choose another one.
*
Password
Password can not be left blank.
Please enter valid data.
Please enter at least 6 characters.
    Strength: Very Weak
    Select Your Payment Gateway
    How you want to pay?
    Payment Summary

    Your currently selected plan : , Plan Amount :
    , Final Payable Amount:
    Submit