What is a Good Inventory Turnover Ratio? [Formula]

A good inventory turnover ratio is typically between 4 and 8 for most industries. While the optimal ratio may vary depending on your industry, this range generally indicates a good balance between stock replenishment and sales numbers.

No matter the size of your business, you’re sure to have some items that fly off the shelves and some that take a little longer to move. It’s ok if not all your items are best-sellers, as some will always sell faster than others. This just means you need to have a system in place to ensure you restock at the proper rate.

Inventory turnover ratio is the rate at which a company buys and sells its products. Companies use this ratio to make informed decisions about pricing, demand planning, and supply chain management.

This ratio, used in both large warehouses and small shops, helps determine how much inventory is utilized within a set time. Therefore, businesses can estimate new inventory requirements from that metric.

Stay with us as we unpack what inventory turnover is, how to calculate it, and what you can do to optimize your inventory turnover ratio.

Key Takeaways:

  • Inventory turnover is the rate at which stock is purchased, used, and sold by a company.
  • Calculate inventory turnover ratio by dividing cost of goods sold by average inventory.
  • The ideal inventory turnover ratio varies by industry, as more competitive industries must have a higher inventory turnover ratio, while less competitive markets can enjoy a lower one.
  • You can optimize your inventory turnover ratio by adjusting your pricing, eliminating supply chain inefficiencies, reordering strategically, and automating your inventory management.

What is inventory turnover?

The definition of inventory turnover

Inventory turnover illustrates the amount of time it takes for a company to purchase and sell an item, and is a good indicator of their efficiency regarding inventory management. By calculating inventory turnover, business owners can:

  • Make inventory control decisions.
  • Keep business running smoothly without going out of stock or overstocking the products.

For a business to flourish, it needs proper inflow and outflow of cash and inventory. It’s essential that businesses keep their shelves stocked so they can sell products and make profits. However, having obsolete inventory can be equally harmful to a business.

As a result, it’s crucial to optimize your inventory turnover ratio so it’s ideal for your specific business needs and aligns with industry standards. But how do you determine your specific inventory turnover ratio? Luckily, there’s a way to calculate it.

How to calculate inventory turnover ratio

The inventory turnover ratio formula is based on two main activities of a business:

  • Purchases of the goods to be sold
  • Selling of the goods

These are two determining factors in the success of any business, and you can only judge their performance by calculating the inventory turnover ratio.

  • A high inventory turnover ratio tends to be best and generally means strong sales numbers.
  • A low inventory turnover ratio illustrates either weak sales or overstocking, meaning the business is replenishing at a much faster rate than they’re selling.

While a higher turnover ratio typically represents stronger sales, companies can often struggle to meet surging demand, which, in some cases, can result in a stockout.

Inventory turnover ratio formula + example  

There are multiple formulas to calculate inventory turnover ratio, but the most commonly used formula is:

The inventory turnover ratio formula 

Inventory turnover = Cost of goods sold / Average inventory

However, there are a few values you need to find before you can calculate inventory turnover itself. Here’s how the process breaks down with an example:

1. Calculate cost of goods sold (COGS) 

To find the inventory turnover ratio, you first need to calculate the cost of goods sold (COGS). To find COGS, you’ll need to know the stock count of inventory at the beginning of the month (beginning inventory) and at the end of the month (ending inventory). You’ll take the beginning inventory, add purchases made over the course of the month, and then subtract ending inventory to find COGS.

For example, say you’re a retailer selling perfume for $100 per bottle. You have 90 bottles at the beginning of September, making your beginning inventory $9,000, and 92 bottles at the end of September, making your ending inventory $9,200. Assuming you purchased 77 bottles over the course of the month, your COGS calculation would look like this:

An example of the cost of goods sold formula 

2. Calculate average inventory

Once you’ve found COGS, you can calculate your average inventory. To find average inventory, you simply need to add your beginning inventory and ending inventory and divide the sum by two. For our perfume example, the calculation would look like this:

An example of how to find average inventory 

3. Calculate inventory turnover ratio 

Once you’ve determined the COGS and average inventory, you can divide COGS by average inventory to find your inventory turnover ratio. This would be:

7,500/9,100 = 0.824

Our perfume retailer has an inventory turnover ratio of 0.8, meaning they replenish their inventory a little less than once a month. While this may seem low, remember that perfume is a luxury good, and retailers in this space can afford a lower turnover ratio. In the next section, we’ll explore how your industry affects your ideal inventory turnover ratio.

Inventory turnover ratio by industry

The nature of your industry and the products you sell will influence your ideal inventory turnover ratio. While a high ratio is vital in certain sectors, others can operate with lower turnover. Let’s look at the best inventory turnover ratios for different industries.

The best inventory turnover ratio for four different industries 

Industries with low margins 

Industries with low margins need to maintain a high inventory turnover ratio to stay profitable. These are companies in particularly competitive industries, like grocers, retailers, and discount shops.

These companies should get products off the shelves quickly — unlike high-profit margin companies that can afford to make fewer sales due to selling more expensive products.

Industries with higher holding costs 

Industries with higher holding costs additionally need to maintain a high inventory turnover ratio, as keeping items on the shelves is costly.

Take food and beverage companies that sell perishable goods. Since they must dispose of these products after a certain period, vendors must sell them quickly, thus maintaining a high inventory turnover ratio.

Industries selling luxury goods 

Industries that sell luxury goods can enjoy a lower inventory turnover ratio since they operate in a niche market, unlike more competitive industries such as retail.

Jewelers, for example, can keep a lower inventory turnover ratio. This is because jewelers have high profit margins and often lower competition. This is all relative to scale, however, as a local business may not sell items as quickly as a national franchise.

Why is inventory turnover ratio important? 

Maintaining a certain amount of stock to run a business smoothly is essential. The inventory turnover ratio helps determine how much inventory you need to keep shelves stocked while avoiding overstocking.

Additionally, knowing your inventory turnover ratio can answer supplementary questions about your business, such as:

  • Am I pricing items correctly?
  • Am I using the most efficient supplier?
  • Am I restocking my most profitable items quickly enough?

By uncovering these answers, business owners can find more efficient ways to run their companies.

How to improve inventory turnover ratio

After determining the ideal inventory turnover ratio for your industry, you can optimize your own inventory turnover ratio. Here’s how:

Four ways to optimize your inventory turnover ratio 

1. Reevaluate your pricing 

If you have a high inventory turnover ratio but low-profit margins, you’re likely pricing your products incorrectly.

Make sure you’re accounting for everything in your final price: raw materials, production costs, processing costs, etc. While raising your prices may lose a few customers, it’s necessary for long-term profitability.

2. Eliminate supply chain inefficiencies  

Despite popular opinion, the cheapest suppliers aren’t always the best choice. If you’re struggling to meet market demand, you may want to opt for the most efficient supplier, to ensure you’re keeping your most popular products in stock.

To maintain an ideal inventory turnover ratio in your industry, it’s crucial you’re staying stocked with the correct items. Opting for the most efficient supplier is often the best way to ensure an optimal turnover ratio.

3. Rethink your reorders   

It’s tempting to want to place bulk orders, as this usually results in supplier discounts. However, think about which items sell quickly and which aren’t. If certain items aren’t moving off the shelves, consider ordering them in smaller quantities.

If you continue ordering items in bulk that aren’t selling, you may wind up with excess inventory, which can be costly for a business. In some cases, just-in-time inventory management, which means only having the items needed for the given time, can optimize your turnover ratio.

4. Opt for automation   

Opting for automation in favor of manual reordering is a great way to ensure you always stay on track and your inventory levels never get too low. Especially if you find yourself reordering too often and getting left with obsolete inventory, an automated inventory management system will notify you when your stock is getting low — and even reorder for you.

An automated system can track what items sell the best and ensure those items get replenished when inventory is low. Automation keeps a pulse on inventory levels and takes the stress out of reordering, so you can focus on running your business more efficiently.

Frequently asked questions (FAQ)

Still have questions about finding a good inventory turnover ratio for your business? We’ve got you covered. Here are some of the most common questions (and answers) about nailing your inventory turnover ratio.

Is an inventory turnover of 4 good? 

In most cases an inventory turnover of 4 to 8 illustrates a good balance of restocking and sales. For most retailers and e-commerce brands, a turnover ratio of 4 is considered healthy.

What is a low inventory turnover ratio? 

A low inventory turnover ratio signals that sales are weak and inventory isn’t moving off the shelves. Many industries consider an inventory ratio under 4 a low turnover ratio.

Why is a low inventory turnover ratio bad? 

A low inventory turnover ratio typically shows either weak sales or a lack of demand in your industry. In some cases, a low ratio will illustrate an imbalance between how frequently you’re restocking items and your actual sales numbers.

What should you do about a low inventory turnover ratio? 

Our tips above are all great strategies to implement if your business has a low inventory turnover ratio. If you have a low inventory turnover ratio, consider reevaluating your prices, streamlining your supply chain, or automating your reorder system.

What does an inventory turnover of less than one mean? 

If you have an inventory turnover of one or less than one, you have too much stock. For example, if you sell 50 items over a year and always have 50 units of inventory in stock, you’d have a rate of one. However, this is far more inventory than is needed to meet demand — meaning you’ve significantly overstocked.

Can an inventory turnover ratio be too high? 

For most businesses, a high inventory turnover ratio is generally a sign of strong sales numbers. However, a high inventory turnover ratio, and high sales, requires you to keep up with demand. If you can’t keep up with demand, you won’t be able to meet customer demand and may experience stockouts.

What is an ideal inventory turnover ratio? 

The ideal inventory turnover ratio depends on your business and industry. But regardless of what you sell, it’s still essential to know your current ratio so you can improve upon it.

Opting for an automated inventory management system is an excellent way to ensure you always get notified when stock is low and it’s time to replenish. An automated system will also calculate your cost of goods sold and give you real-time insights — so you never miss a beat.

Stay on top of turnover with Cin7 Core.

Eight Signs It’s Time to Implement an Inventory Management System

Let’s face it, inventory management is complex.  Tracking all costs from procurement to distribution is not a small task. It’s okay to start small with an Excel spreadsheet to track inventory, but as your inventory management needs grow and change, it’s important to assess whether it’s time to abandon the spreadsheets and adopt a more robust inventory management system that will sync with your accounting and operations systems

The good news is that inventory management doesn’t have to be hard.  Employing an inventory management system like Cin7 Core will offer the insight and efficiency needed to make informed decisions and drive growth.

Here are eight common signs that you need to up your game and invest in an inventory management system

One:  Lack of Clarity Around Frequent Inventory Adjustments

If you’re in the manufacturing space and have raw materials and/or employ labor to create finished goods to sell, you’re officially at a complex level of inventory management. The calculation of all of the various inputs involved in understanding each piece of the process will be eased by having a system in place

If you are experiencing significant discrepancies between the inventory value on your financials and what your physical counts are showing an inventory management system can help provide insight into which SKU or locations are causing these discrepancies

Two:  Changing From In-House to Co-Pack, or Co-Pack to Turn-Key

Just when you get to know your trusty process, it is time to change.  With a change in manufacturing support, setup can come a host of adjustments.  All of which can affect your COGS and bottom line.  Don’t let small changes snowball into big money consequences.  Get ahead of your new partnership and/or manufacturing format by implementing an inventory management system

Three:  Expansion of Inventory Locations

For a company that pulls inventory and sells from a number of different locations, an inventory system will help you translate the details across each location. If you have multiple 3PLs (third-party logistics) at play, having more accurate tracking of the costs behind each in a clear view will help determine the best and most profitable locations to house your inventory

Four:  You Are Planning to Grow at a High Rate in the Near or Mid Future

For help with ordering and being able to stay ahead of the business needs, an inventory system will clearly show you where you stand on counts and status. This beats manually going through your data to figure out if it makes sense to reorder now, later, or whether or not you are equipped to fulfill a large order in the works

Five:  You Need More Detailed Reports:  Profitability by SKU, Reorder Points, etc.

Sometimes the classic report from your spreadsheets, Shopify, or Quickbooks just doesn’t cut it. You will need something more precise to pull from. Especially when you need an understanding of your Inventory velocity–the amount of turn on a week-over-week basis. Having better reporting means better decision-making

Side Note: Like the other systems we recommend and use, DEAR/Cin7 Core is cloud-based, integrates nicely with other systems like Shopify, Amazon, Faire, and syncs with accounting and fulfillment systems to pull data through each seamlessly.  For example, the business hosted by Shopify, shipping through ShipStation, and accounting with Quickbooks, is all set.  You’ll see sales orders, understand shipments, and more; all in one spot and without entering the same data twice

Six:  You Need to Include More in Your Landed Cost

Do you import raw materials and/or products from overseas?  Maybe duties factor into your COGS.  What about the fluctuation in the exchange rate?  There are already complexities popping up and we only touched on two items:  freight-in and duties.  For companies with more complexities in areas like landed costs (freight-in costs, labor, etc.), it is best to err on the precise side, when it comes to costs of goods sold. From a margins or general assessment standpoint, you may need to dig into the weeds a bit more

An inventory system like Cin7 Core will allow better visibility over all of these functions. From purchasing to selling and seeing the segregation of duties within each

Seven:  You Have Frequent Variances in Raw Material Cost/ Purchase Price

Remember that fluctuating exchange rate concept we just mentioned?  Raw goods costs can fluctuate based on a number of factors, and cause subtle, yet significant changes to your margins if not tracked properly over time. We see this a lot in CPG companies that source ingredients from their suppliers.  Many of these ingredients are reliant upon market conditions, weather, you name it.  They need access to the costs and fluctuations so they can make adjustments to pricing and/or seek out alternative suppliers

Eight:  You Need Access to Real-Time Data Now, Not Monthly

Up-to-date data can be the difference between making a profitable choice and paying for a guess later.  Cin7 Core provides up-to-date data that you can access immediately and make decisions from.  No more waiting to update a bulky spreadsheet or pulling a monthly report.  Since it syncs with all of your popular systems like Quickbooks and Shopify, you will have all of your sales data at hand too

If some or all of these areas spoke to you, it is time to do a bit more research into which inventory management system can support your needs.  At the end of the day, there are no awards for managing the most detailed, complex spreadsheets.  Filter that time and energy into updating your data within a more accurate and user-friendly option like Cin7 Core, and get back to moving those products and making sales

Stop the stress: The future of budgeting and forecasting

A lot of hype happens when ‘budget season’ comes around for a business, with images of late nights and spreadsheets and stress levels boiling over. For accountants, it’s just another normal financial budgeting task with monthly updates including actual results and changes to the forecast.

 

How budgeting works

Businesses generally set a budget for the financial year ahead, based on prior performance and planned changes to the business, including product expansions, efficiencies, and changes in the market.The budget is used as a tool to track progress, usually on a monthly basis when the actual results for the month are compared to the budget set for that month. In this monthly review, the team creates an updated forecast for the remainder of the year to support upcoming business decisions.

For product sellers, this budget is done with varying levels of information, depending on what is easily accessible for the business. Setting a budget often means taking an educated guess on the volume, pricing, and cost of their product sales, rather than actual data that may be buried in systems or needs to be manually calculated.

 

Digital commerce tools simplify budgeting

With digital commerce systems, budgeting and forecasting is more sophisticated and accurate as historical information is readily available and easily analyzed. Budgets based on actual prior performance with an assumed margin of improvement give the most accurate picture of future success. Forecasts are then a simple formula of the actual year to date results plus the budget for the balance of the financial year.

Budgeting made easier with intelligent commerce

Looking forward, as software evolves and brings intelligent commerce to small businesses, annual budgets and latest forecasts must become a financial plan based on the latest real time factors, both internally and externally. The annual budget will take into account market predictions and the monthly forecasting process will take into account real time information for their market each month.

With the help of digital commerce, accountants can easily access the last 12 months of product sales to create their seasonal revenue and cost budgets. Intelligent commerce takes this a step further ,enabling businesses to have a financial plan that updates in real time based on the latest internal data and the targeted market conditions. Businesses that use the power of intelligent commerce can make strategic decisions to achieve the best outcomes or address adverse conditions as they happen.

 

Accountants and business leaders will be able to focus on making strategic decisions – including finding opportunities for expansion or cost savings, instead of spending time compiling historical numbers to work out a trend for the year ahead.

 

Cin7 and intelligent budgeting

Cin7’s solutions provide today’s businesses with tomorrow’s intelligent budget needs, including detailed product sales and costing information to create your budgets and update your forecasts. Plus, these budgets and forecasts can be compared to actual results within Cin7 for the greatest visibility with less manual data management.

Cin7 led the way with bringing digital commerce to product sellers and is committed to democratizing intelligent commerce for small businesses. Join us in this exciting journey where intelligent commerce will enable small business owners and their accountants to add more value to the growth of the business.