Rotate Stock, Maximize Profits: How to Use Inventory Turnover Ratio in Your Store

Inventory turnover ratio

Inventory turnover ratio (ITR), also known as stock turnover ratio, is the number of times inventory is sold and replaced during a given period. It’s calculated by dividing the cost of goods sold (COGS) by average inventory. 

In retail, you have limited funds available to purchase inventory. You can’t stock a lifetime supply of every item. 

To generate cash and pay the bills, you need to sell what you buy. Inventory turnover rate helps you understand how fast inventory moves through your warehouses. A high inventory turnover rate suggests optimal performance, while lower turnover means inefficiency. 

Knowing your inventory turnover ratio can help you make smarter decisions on pricing, manufacturing, and inventory management. It’ll help you find the balance of stocking the right amount of products and making consistent sales.

Want in on the action? You’ll learn everything you need to know about inventory turnover ratio in this article. 

What is inventory turnover?

Inventory accounts for one of the most important variables for a retailer. Inventory represents more than 50% of a retailer’s assets, which is why inventory productivity is a competitive edge in the industry. Inventory management processes are continuously being improved to reduce and optimize stock levels. 

Even though buildings and equipment have a higher dollar value, inventory is your most important asset. One way to measure the performance of your retail business is inventory turnover. 

Inventory turnover measures the number of times stock is sold and replaced throughout the year. Turnover of 12 means that the average inventory moves through the store once a month. 

Also known as “stock turn” or “inventory turn”, it’s often calculated annually to account for different shopping seasons throughout the year, like back to school or the winter holidays, which can affect total inventory numbers. 

High inventory turnover equals high business performance. It suggests that you:

  • Buy the right amount of inventory
  • Keep enough stock on hand
  • Maintain low storage costs 
  • Replenish display case 
High inventory turnover rates suggest you effectively sell the inventory you buy.

Low inventory turnover means the opposite because products get stuck in a warehouse and acquire holding costs. Low turnover also indicates you:

  • Overstock products
  • Have inefficient marketing efforts
  • Experience weak sales 
  • Are experiencing a decline in product popularity 
Low turnover indicates you overstock products, have weak sales, or experience a decline in product popularity.

There are also exceptions to the rule. An extremely high turnover can also indicate ineffective buying and low inventory, which results in stock shortages and lower sales. 


Take the guesswork out of restocks

Only Shopify helps you make smarter inventory purchasing decisions. See your most profitable and popular items, forecast demand, get low stock alerts, and create purchase orders without leaving your POS system.


How do you calculate inventory turnover ratio?

Knowing how to calculate your inventory turnover ratio starts with knowing your COGS, or cost of goods sold, as well as your average inventory. 

Inventory turnover ratio formula

To calculate the inventory turnover ratio you’ll want to divide the (COGS) or cost of goods soldby your average inventory (starting inventory plus ending inventory in a given time period divided by two).

COGS/ (starting inventory + ending inventory/2) = Your inventory turnover ratio

💡 PRO TIP: Want to see which items are flying off shelves or collecting dust? View the Percent of inventory sold report in Shopify admin to see your entire product catalog’s starting quantity, ending quantity, percent of sold, and more.

Cost of goods sold (COGS)

Your cost of goods sold, or COGS is usually reported on the income statement. It’s the cost of labor and all other direct costs involved with selling the product. 

5 Free Templates to Better Understand Your Inventory

Calculate your businesses cost of goods sold, sell through rate, inventory turnover, saftey stock, economic order quantity, or reorder point with ease using these custom templates. (No math required!)

Average inventory (AI)

To figure your average inventory, or AI, add your starting inventory during a given period of time with your ending inventory during that same period of time, then divide that by two. 

Once you’ve plugged in your numbers and worked the formula here are some additional areas into which your ratio gives you more insight: 

Sales performance: Are products moving off the shelf at a decent rate? Do you need to run special sales or pay attention to specific items and figure out how much holding them for longer is costing you? 

Are there any poorly performing products you should replace or remove altogether to improve your inventory balances? Your inventory turnover ratio can help lead you through important inventory control questions like these. 

Holes in your marketing strategy: Is your product marketing strategy not doing the best job at product positioning? Is the ROI on your advertising efforts not panning out due to holding costs eating into your margins and diminishing your inventory value? 

Improper pricing: A high inventory turnover ratio might mean that you’re undercharging for your products--which will be reflected in your financial statements. This could mean you can charge more per unit or that you can prioritize a specific product’s inventory to sell more. 

Knowing your inventory turnover ratio should not be taken lightly. One study found that annual inventory ratios of companies can predict future stock performance. The ability to control annual inventory turns is a good indicator of the quality of management in other areas of the business.

What is a good inventory turnover ratio for retail?

A good inventory turnover ratio in retail depends on what you sell, how you sell it, and who you sell to. Research shows that retailers see an average inventory turnover ratio of 10.86.

This means retailers restock their entire inventory over 10 times per year.

Consumer discretionary brands, which refer to nonessential but desirable goods like luxury clothing, replenish their inventory nearly 7 times per year. 

Consider that Walmart, one of the most successful retailers in the world with net sales of over $500 billion in 2020, has an average inventory turnover rate of 8.8 for the fiscal years of 2017 - 2021. Meanwhile, Amazon.com’s latest inventory turnover ratio is 9.8, with an average turnover rate of 8.8 for the fiscal years of December 2016 - 2020

As of August 2021, the average inventory turnover ratios per economic sector are:

Inventory turnover ratio by industry
Source

Your goal is to rotate inventory as much as possible to maximize profits. If you have older products that are low sellers, run a sale on them and discontinue the line after it's sold out.

Rhiannon Taylor, founder of RT1Home

Example of inventory turnover ratio

Say you’re a sock retailer and your company sells thousands of packs each month. What would your inventory turnover ratio be if your starting inventory for the year was $5,800 and your ending inventory for that same year was $2600 with a cost of goods sold total of $3,700?

Your formula would look like this: 

COGS/ (beginning inventory + ending inventory/2) = Your inventory turnover ratio

$3,700/ ($5,800 - $2,600/2) = 2.3125

What can you infer from a 2.3 inventory turnover ratio? This number means that, within a year, the sock retailer turns over its inventory around 2.3 times. Depending on what your store’s inventory management goals are, this might be a satisfactory rate to maintain.

However, if you’re wanting to sell more socks, you'd need to look for ways to fix your low inventory turnover ratio, restock your shelves more quickly, and increase that 2.3 yearly turnover ratio while being careful not to go overboard with purchases that simply turn into excess inventory.

How to use inventory turnover ratio

Now that you’ve figured out your ITR, let’s look at how to use it in your store. 

Demand forecasting

When demand forecasting, you’re making predictions about future sales based on past sales data that are both qualitative and quantitative. Knowing how well you did in historical sales through each quarter makes it easier to plan for the next one. 

Demand forecasting also helps with figuring out tasks like weighing the pros and cons of opening another store, inventory control, or planning for holiday sales, where you’ll need to order ahead for additional inventory. 

Say you sell car parts and your historical inventory turnover ratio points to sales picking up the second quarter of the year. That gives you foresight into the amount of inventory you need to order months ahead of time to be ready for strong sales. 

Identify supply chain issues

Supply chain issuesare challenging businesses that don’t plan for mishaps—which are bound to happen at some point. Just take a look at the most recent supply chain issues that were felt worldwide. 

The culprit? There was a wide labor shortage that peaked during the height of the 2020 pandemic. That, plus a simultaneous increase in demand for consumer goods, created a dire supply chain situation. 

So, how can you identify supply chain issues with data like your inventory turnover ratio? For starters, it can help you more accurately calculate the amount of safety stock needed for products that sell faster. 

It can also help you identify:

  • Gaps in stocking and ordering policies
  • Forecast variance in marketing
  • Changes in lead time

The more a product sells, the more spending on storage costs on safety stock can be worth it. Understanding which SKUs have low turnover also helps you get rid of dead stock or write it off. Without your turnover ratio, it’s hard to spot the weak points in your supply chain. 

How to improve inventory turnover

Now that you know how to use your inventory turnover ratio, let’s look at some ways to improve inventory turnover in your store: 

  • Increase demand
  • Improve forecasting
  • Optimize your supply chain
  • Product bundling

Increase demand

Is inventory not moving fast enough, and storing it for longer eating into your profit margins? Increasing demand can help you move inventory faster. 

Sure, you can invest in paid ads in the short term for long-term returns, but you can also use your social media channels to market new discount prices or flash sales. If that isn’t quite working, consider adjusting your prices across the board. 

It might be that your target audience’s perceived value of your product isn’t what you thought. You can launch marketing campaigns to help shape that perception—including influencer marketing, or ambassadorship efforts. 

Resources:

Improve forecasting

Calculate the inventory ratio for each product line. This helps you identify which lines are moving slowly and not providing high returns, so you can improve forecasting. Consider reducing the quantity you normally order from suppliers. Inventory turns improve when you buy less product more often. 

Improved forecasting for better inventory turnover rates can look like:

  • Getting granular about specific products and their numbers instead of bundling forecasting into one general data set
  • Keeping clear and organized records with a reliable inventory management software
  • Considering seasonality as part of your overall forecast

Optimize your supply chain

Trimming unnecessary delays and strengthening your supply chain can help safeguard you from the headaches that come with delayed product deliveries. Besides reviewing your supply chain periodically, one of the best things to do is improve how much data you capture at each step to assess for efficiency and become more aware of how well you’re managing inventory. 

In this case, our inventory turnover rate gives you a glimpse into how much carrying cost you’re shouldering that you might not have to. Adopting a just-in-time (JIT) inventory strategy can help you trim a substantial amount of your carrying costs, but at the risk of increased stockouts. 

Knowing your inventory turnover ratio can also help you strengthen your relationship with your suppliers since you’ll be able to communicate your needs with more precision and fewer inconsistencies. 

Product bundling

When you use product bundling, you’re curating a set of complementary items to capture more buyers. For example, a buy-more-save-more strategy can be beneficial if products aren’t moving off the shelf fast enough. You pair complimentary items that are selling the slowest together in hopes of clearing your shelves faster while still turning a profit.

There are also quantity discount bundles to consider if you’re selling bundles of the same product. Think of three-for-two deals in which customers receive more for their money. But product bundling takes data to do successfully. 

At the very least, knowing which items move the slowest will help you make better decisions on which bundles you can create to attract higher sales. The inventory turnover ratio formula can increase visibility in those areas. 

Optimize your inventory turnover ratio

Inventory, sales, and profit have always had a significant relationship for retailers. Optimizing your inventory turnover ratio starts with using the right formula for the job. Overstocking can be just as hurtful as understocking, as it's bound to reflect in your balance sheet. 

Yet, once you figure out what your cost of goods sold divided by your average inventory is, you can start optimizing for efficiency, whether you’re planning for inventory control, streamlining your supply chain, or lowering warehouse expenses. 

But don’t just stop there. There’s plenty you can do once you have accurate financial ratios in your hands— from improving your marketing to adjusting your price points or even rethinking the mix of products you offer for better margins and less stocking expenses.

Unify your inventory management with Shopify

Only Shopify POS helps you manage warehouse and retail store inventory from the same back office. Shopify automatically syncs stock quantities as you receive, sell, return, or exchange products online or in store—no manual reconciling necessary.