Use This Simple Formula to Calculate Inventory Turnover Ratio
The inventory turnover ratios for each of your products can help you determine how marketable your goods are and how effective your marketing is.
Inventory turnover is a crucial measurement for understanding how your business is performing. This metric can help you make more informed decisions regarding manufacturing, buying products, storing inventory, marketing, and selling goods to customers.
What is inventory turnover ratio?
Inventory turnover is how fast (or how many times) you can sell through your inventory during a specific timeframe. A high turnover rate often means you’re selling your goods quickly and efficiently. A low turnover rate can indicate that sales are slow or that you’ve overstocked. Stock turn, stock turnover, and inventory turns are other common names for inventory turnover.
What is the inventory turnover ratio formula?
To calculate inventory turnover, let’s define the variables:
- Timeframe = 1 year (or whatever period you choose)
- Average inventory = (the dollar value of beginning inventory + ending inventory) / 2
- Cost of goods sold (COGS) = the number on your annual income statement
With those variables identified, you can now use this formula to calculate the inventory turnover rate:
Cost of goods sold / average inventory = inventory turnover rate
Inventory turnover ratio example
Let’s say you own a bookstore, and you’re trying to figure out inventory turnover for one of your best sellers. Your COGS is $10,000. Your beginning inventory is $3,000, your ending inventory is $1,000—so your average inventory is $1,000 ($3,000 – $1,000 and then divided by 2). If we plug those numbers into the formula, we get:
$10,000 (your COGS) / $1,000 (your average inventory) = 10 (your turnover rate)
In other words, you turned your inventory for that book ten times throughout the year. From here, you can average out how many days it takes to sell through your inventory one time. Take 365 days and divide it by 10 (your inventory turnover rate).
365 / 10 = 36.5
In this example, it takes 36.5 days to sell through your average inventory ($1,000-worth of books) one time. This number will help inform how much stock you need to order in the future and how many sales you can expect to make throughout the next year.
Inventory turnover rate vs. sell-through rate
Inventory turnover measures how many times you sell through and replace inventory (SPEED) in a specific period. Sell-through rate is a bit different. It measures how much stock you sell in a given period (AMOUNT), as a percentage.
(Quantity of goods sold / quantity of goods on hand) x 100 = sell-through rate
Your business needs to maximize both of these rates. A high turnover means you’re selling through items efficiently, and a high sell-through means you’re turning over a high quantity of items.
Days sales of inventory (DSI) vs. inventory turnover
Days sales of inventory (or days of inventory) calculates the average time it takes your business to turn inventory into sales. You can calculate DSI by taking your average inventory and dividing it by the cost of goods sold. Then multiply that number by 365, and you’ll know how many days it takes to sell your inventory. The smaller this number is, the better.
(Average inventory / cost of goods sold) x 365 = days of inventory
Other inventory calculations you should know
Asset turnover ratio
Your company’s asset turnover is your total sales ratio to the average value of your assets. You can use this formula to identify how efficiently your business uses your assets to generate sales and revenue. The higher your asset turnover ratio is, the better. To calculate this ratio:
Total annual sales / average assets = asset turnover
You can calculate your average assets by taking the value of your assets at the start of the year added to your assets at the end of the year. Then divide that number by two.
(Beginning assets + ending assets) / 2 = average assets
Inventory holding period
Your inventory holding period is how long (in days) your company holds inventory on average. The lower the holding period, the better it is. Calculate the holding period using the following formula:
(Inventory / cost of sales) x 365 = holding period
What is a good inventory turnover ratio?
The ideal ratio depends on what you’re selling and your specific industry. Some goods sell immediately, like toilet paper. Other goods can take much longer to sell, like fine artwork. An art gallery may have a turnover rate of three when a grocery store’s average is 15. It’s common for businesses with higher profit margins to have lower inventory turnover and vice versa.
When determining whether your inventory turnover rate is good or bad, you need to compare it to how other businesses in your industry are performing. In other words, compare your apples to other apples—not oranges or mangos.
In general, the higher your inventory turnover rate is, the better. A higher rate can indicate one of two things:
- Sales are strong: Your business is selling inventory effectively and efficiently.
- Inventory is too low: If you run out of stock because you’re selling through products too quickly, you could end up losing sales.
Conversely, if your inventory turnover rate is too low, you could face these types of problems:
- You’ve overstocked: You could be paying high storage and holding costs.
- Sales are weak: Your business isn’t selling efficiently.
- Marketing is inadequate: You’re not reaching and connecting with people effectively.
Going with the same example we used before, compare your inventory turnover rate of “10” with other bookstores in your area. All you need is their income statement and balance sheet.
If your competitors turn their top sellers faster than you do, you should analyze how their shop is marketing and selling books compared to yours and make adjustments as needed. Look at industry averages across the nation for bookstores that are similar in size and scope. Then you’ll have a good idea of whether your turnover rate is high, low, or average for your industry.
How can I improve inventory turnover for my business?
If you’ve used the inventory turnover ratio formula, and you know you need to improve your averages, we have several tips.
1. Try a new marketing strategy.
Make sure you set up your campaign to target your ideal customers. Tell them how you can solve their specific problems and how fantastic your solution is. Get people excited about what you offer, so they can’t wait to get their hands on it.
2. Choose products that sell well.
What do you have in your store that already gets a lot of hype and has a high turnover rate? Maybe you should find similar products to offer your customers.
3. Group similar inventory.
You can create “inventory groups” by identifying similar products. By placing them in the same category, you can compare how they perform on the shelves. This can help you recognize trends and project how much product you should order in the future.
4. Get rid of stuff you just can’t sell.
If you have a product that’s been taking up shelf space or warehouse space, but it doesn’t sell well, you may want to consider getting rid of it. If it’s only taking up valuable space, you’re losing money.
5. Double-check your prices.
If you’re already applying all of the other tips in this list and you’re still not making sales, your pricing could be too high. Compare your prices with similar businesses and products in your industry. If other companies are pricing things much higher or lower, change your pricing to be more competitive.
6. Buy smaller quantities more frequently.
An easy way to increase your inventory turnover rates is to buy less and buy more often.
Limitations of using the inventory turnover formula
If you aren’t comparing apples to apples, as we mentioned already, the inventory turnover ratio won’t give you accurate insight into how your business is performing. Make sure you’re accounting for discounts on items throughout the year, special campaigns or offers, and markup. That way, you can use this formula effectively and improve your tactics over time.
Powerful software to increase your inventory turnover
inFlow is stocked with impressive features to help you grow your business and track your results. Our software will help you find the perfect balance for supply and demand, so you know exactly how much inventory to order and when to order it.