Inventory turns is a crucial metric that helps businesses optimize their operations and stay ahead of the competition.
A high inventory turnover ratio indicates that a company is selling its products quickly, which means it's not holding onto inventory for too long. This reduces the risk of inventory becoming obsolete or going bad.
Having too much inventory on hand can lead to wasted resources, including storage space, and even result in financial losses. For instance, a company may have to write off inventory that's no longer sellable.
Inventory turns also provide insight into a company's cash flow and ability to pay its suppliers.
What Is Inventory Turns?
Inventory turns is a measure of units sold compared to units on hand, symbolizing a company's ability to manage inventory and generate sales from it.
It's an important component of effective supply chain management, particularly for retailers and companies that sell physical goods.
A lower inventory turn number means a particular stock keeping unit, or SKU, is not selling quickly or is no longer in demand.
A higher number indicates a company is stocking too little of an item, potentially missing out on profits.
Inventory turnover ratios are usually calculated at the SKU level, but can also be aggregated to find the turnover rate for the entire stock.
Reducing inventory holdings can lead to reduced overhead costs and improved enterprise profitability.
Calculating Inventory Turns
Calculating inventory turns is a straightforward process that helps you understand how well your business is managing its inventory. The formula for inventory turns is Cost of Goods Sold (COGS) ÷ average inventory, where the average inventory is calculated by adding the beginning and ending inventory values and dividing by 2.
There are two formulas for inventory turns, and the choice between them depends on your focus. Supply chain professionals prefer the second formula, which measures the speed at which product is shipped out to customers, while finance departments tend to like the first formula, which includes sales and selling price.
To calculate inventory turns, you need to find the cost of goods sold (COGS) and the average inventory value. COGS is the amount a company paid for its inventory, and it includes not just the cost of purchasing the goods but also storage, packaging, and labor costs. The average inventory value can be calculated by averaging the beginning and ending inventory values or by averaging the inventory value at the end of each month.
Here are the two formulas for inventory turns:
1. Cost of Goods Sold (COGS) ÷ average inventory
2. [Cost of raw materials used in production] ÷ [Inventory Cost]
Note that for companies with stable levels of inventory, using the ending inventory number may cause only a minor inaccuracy.
A high inventory turnover ratio indicates that a company is efficiently managing its inventory and working capital, which can lead to lower holding costs and higher profits. On the other hand, a low ratio suggests that a company may be overstocked, which can lead to higher holding costs and potentially obsolete inventory.
What Is Ratio?
The inventory turnover ratio is a financial metric that measures how quickly a company sells and replaces its inventory within a set period. It's also known as stock turnover or inventory turnover rate.
A high inventory turnover ratio indicates that a company is efficiently managing its inventory and working capital, which can lead to lower holding costs and higher profits. This is because the company is selling its inventory quickly and replenishing it with new stock, reducing the amount of inventory that's sitting idle.
The inventory turnover ratio is calculated by dividing the cost of goods sold (COGS) by the average inventory for the same time period. This is a simple yet effective way to measure sales and inventory efficiency.
A low inventory turnover ratio, on the other hand, suggests that a company may be overstocked, which can lead to higher holding costs and potentially obsolete inventory. This can be a sign of inefficient inventory management and may indicate that the company needs to adjust its inventory levels.
The inventory turnover ratio can be calculated for a specific period, such as one year or month, and it can provide valuable insights into a company's inventory management practices. By understanding the inventory turnover ratio, businesses can identify areas for improvement and make data-driven decisions to optimize their inventory levels and reduce costs.
What Goes into the Cost of Goods Sold?
Calculating the cost of goods sold (COGS) is a crucial step in determining your inventory turnover ratio. This figure measures the direct cost of the inventory that has been sold by your business.
The cost of goods sold is not just what you paid the supplier, but also includes what you spend on storing those goods, packaging, and any additional labor involved in selling those products.
To calculate the COGS, you can pull it off the financial statements, but it's not that simple. You need to consider the general ledger account numbers that are part of the company's overall COGS, as well as the costs listed in the column called "From Product Sales".
You should exclude adjustments to the value of inventory from the COGS value when calculating inventory turns, as these adjustments are not related to measuring selling speed.
Some common adjustments to exclude include inbound freight and labor costs, unless they are related to the speed of selling inventory. In that case, you should include them in the COGS value.
Here are some key components to consider when calculating the COGS:
- Direct costs of inventory sold
- Storage and packaging costs
- Labor costs involved in selling products
- Inbound freight costs (if related to selling speed)
- Labor costs for personnel creating finished goods inventory (if related to selling speed)
By considering these components and excluding irrelevant adjustments, you can accurately calculate your COGS and determine your inventory turnover ratio.
Calculating Ratios
To calculate the inventory turnover ratio, you need to divide the cost of goods sold by the average inventory. This can be done for a specific SKU or your entire stock, depending on the insights you're seeking. The result represents how many times your inventory was sold and restocked over a certain time period.
The formula for inventory turnover ratio is Cost of Goods Sold ÷ Average Inventory. This is a simple yet effective way to measure how quickly a company sells and replenishes its inventory. In simple terms, it reflects how fast a company sells an item and is used to measure sales and inventory efficiency.
A high inventory turnover ratio indicates that a company is efficiently managing its inventory and working capital, which can lead to lower holding costs and higher profits. On the other hand, a low ratio suggests that a company may be overstocked, which can lead to higher holding costs and potentially obsolete inventory.
To give you a better idea, here's a breakdown of the components:
- Cost of Goods Sold: This figure measures the direct cost of the inventory that has been sold by your business. It's a major factor in your profitability and essentially amounts to what you spend in order to keep and maintain inventory.
- Average Inventory: This is calculated by adding the value at the end of the period (such as the year) to the value at the beginning of the period and then dividing by two. Alternatively, you can average the inventory value at the end of each month of the year to get the average inventory on hand.
Example:
- Cost of Goods Sold: $25,000
- Average Inventory: $5,000
- Inventory Turnover Ratio: 5
This means you turned over your inventory and replaced it five times in the past month.
Understanding Inventory Turns Metrics
Inventory turns are a measure of how well a company is managing inventory and generating sales from that inventory. It's an important component of effective supply chain management.
For retailers and companies that sell physical goods, reducing inventory holdings can lead to reduced overhead costs and improved enterprise profitability.
The inventory turns formula is simple: cost of goods sold divided by inventory cost. This gives you an idea of how many times your inventory is sold and replaced over a certain time period.
Here's a breakdown of the inventory turns formula for finished goods and raw materials:
Understanding what a good number of turns is can be tricky, as it varies by industry. A good approach is to look up the financial records of public companies in your industry and compare your inventory turns to theirs.
Calculating Point-of-Use
Calculating Point-of-Use Inventory Turnover is a bit different than the traditional method.
The formula for calculating POU inventory turnover is: Annual Inventory Usage minus Safety Stock, divided by the average cost of the items used.
You need to account for safety stock by subtracting it from the equation, and use Annual Inventory Usage instead of Cost of Goods Sold as the numerator.
Contractors in the electrical contracting industry aim for an inventory turnover ratio of 8 to 1 to 12 to 1.
Safety stock can skew your calculations, so make sure to subtract it from the cost of goods used for the year.
Here's a simple way to think about it: if you have a lot of inventory sitting on shelves that you don't need, you're not maximizing turnover, and that means you're spending more cash on inventory than you need to.
By classifying your inventory into regularly consumed inventory and safety stock, you can get a more accurate picture of your inventory turnover ratio.
If your inventory turnover ratio is lower than the industry average, you may need to carry less inventory.
Here's a quick summary of the POU inventory turnover formula:
Abnormally high inventory turnover ratios can signal insufficient inventory, which can lead to stockouts.
By calculating the inventory turnover ratio and adjusting your inventory management practices, you can notice and address issues like obsolete inventory and stockouts.
Recommended Turns per Year
A good inventory turnover ratio is between 5 and 10, which indicates that you sell and restock your inventory every 1-2 months. This ratio strikes a good balance between having enough inventory on hand and not having to reorder too frequently.
The ideal inventory turnover ratio varies by industry, so it's essential to compare your numbers to those of public companies in your industry. You can find this information in their financial statements or consolidated industry reports.
For most industries, a good inventory turnover ratio is between 5 and 10. However, this can be too general, and you should consider your industry's average ITR as a starting point, not a goal.
Here's a rough guide to inventory turnover ratios by industry:
Keep in mind that this is just a rough guide, and the ideal inventory turnover ratio for your business will depend on your specific circumstances.
A high inventory turnover ratio can be a good thing, but an extremely high turnover ratio can be a bad thing, hurt your balance sheet, and affect your business performance.
Example and Analysis
Let's take a look at an example of how inventory turns can be calculated and analyzed.
Company X has sales of $12 million, with a COGS of $10 million, and an average inventory of $5 million, resulting in an inventory turnover ratio of 2. This indicates that the company sells through its stock of inventory in six months.
A higher inventory turnover ratio is typically more ideal, as it indicates more sales are occurring in relation to a certain amount of inventory. For instance, if Company X increases sales to $18 million, with a COGS of $15 million and an average inventory of $8 million, the inventory turnover ratio would be 1.875.
This decrease in inventory turnover ratio suggests that performance costs, margin, and company inventory retention are worse in comparison to the previous level. On the other hand, if sales were to decrease to $15 million, but inventory is reduced, the inventory turnover ratio would be higher, indicating overall performance and margin improvements.
Each industry and market has its own challenges and requirements that determine the best level of inventory turns. Typically, companies look to industry averages as a touchstone of whether they're gaining a competitive edge.
Improving Inventory Turns
Improving inventory turns requires a strategic approach to managing inventory and maximizing sales. You can start by reducing inventory holdings, which can lead to reduced overhead costs and improved enterprise profitability.
To improve your inventory turnover ratio, revisit your pricing strategy to ensure it's competitive with similar products on the market. Lowering prices can help stimulate sales, but be sure to maintain a fair price that covers your costs.
Here are some ways to improve your inventory turnover ratio:
- Reduce inventory holdings to minimize overhead costs
- Reprice products to be competitive with similar items
- Invest in stronger marketing to revitalize excess inventory
- Stock less of unpopular products to free up inventory space
- Encourage customers to preorder to increase confirmed sales
By implementing these strategies, you can improve your inventory turnover ratio and maximize your company's profits.
Important
Improving inventory turns is crucial for any business that sells physical goods. It's a measure of how well a company is managing inventory and generating sales from that inventory.
A high inventory turnover ratio can signal weak sales for an item, so it's essential to reassess whether that item is worth the associated carrying costs of storing and transporting it. This can add up quickly.
Industry average benchmarks are particularly useful in determining the right inventory turnover ratio for your business. A very high ratio could result in lost sales, as there may not be enough inventory to meet demand.
To improve inventory turns, revisit your pricing strategy to ensure it's competitive enough with similar products on the market. Lower prices can be achieved through sales or discounts, as long as the price still covers your costs.
A low inventory turnover ratio can be improved by stocking less of unpopular products and encouraging customers to preorder. This can help increase sales and reduce waste.
Here are some key metrics to keep in mind:
By keeping a close eye on your inventory turnover ratio and making adjustments as needed, you can optimize your operations and improve your bottom line.
MRO Example
Improving inventory turns is crucial for businesses that manage MRO inventory, such as janitorial and sanitation supplies.
For a fulfillment center, tracking inventory turns can be challenging, especially if they use ERP or MRP business software designed for strategic spending or A/B class parts.
To calculate inventory turns, you need to know the Average Annual Usage and Average On-hand Inventory Value of the item.
A fulfillment center with an Average Annual Usage of $5000 of paper towels and an Average On-hand Inventory Value of $1100 can calculate their inventory turns.
If they keep $100 of safety stock, the inventory turnover of the paper towels is 5.
There's probably room to decrease the min/max settings and keep less on hand to increase the turnover, as long as the Jan/San supplier can deliver the paper towels reliably and promptly.
How to Improve
Improving inventory turns requires a deep understanding of your business's unique needs and challenges. A good starting point is to revisit your pricing strategy, ensuring your products are competitive and priced correctly to maximize sales.
To increase inventory turnover, you can use inventory auto-replenishment apps that use QR code scans for cycle counts and usage tracking, making it easy to adjust minimum and maximum levels that trigger the right amount of replenishment.
Reducing inventory holdings can lead to reduced overhead costs and improved enterprise profitability, making it essential to examine your inventory levels and identify areas for improvement.
If you find that you have low turnover, consider reducing the set minimums and maximums you have for your inventory, which will burn it off by not replenishing it as often.
To identify areas for improvement, you can use software to track your inventory and automate the calculation of your ITR and other vital metrics, allowing you to discover the healthiest ratio for your business.
Here are some tried-and-true strategies to improve your inventory turnover ratio:
- Revisit how you're pricing your products and consider lowering prices with a sale or discount.
- Examine whether your prices might be too low and impacting your profitability.
- Invest in stronger marketing or find ways to revitalize your excess inventory.
- Stock less of unpopular products and phase out products with low sales.
- Encourage customers to preorder and register for certain products.
Keep in mind that you might want to actually lower inventory turnover that's too high, as high turnover can lead to frustrated customers who see that your products are consistently out of stock.
A good inventory turnover ratio can vary depending on your industry and business, but a general rule of thumb is to aim for 10 or more turns per year, as seen in Example 7: "Example of Great Inventory Turnover" where a company with an inventory turnover of 8 is considered good.
By implementing these strategies and monitoring your inventory turnover ratio, you can improve your business's efficiency and profitability.
Frequently Asked Questions
What does a high inventory turnover ratio indicate?
A high inventory turnover ratio typically indicates that products are selling quickly and sales are strong. This suggests efficient inventory management and a healthy sales pace.
Sources
- https://www.techtarget.com/searcherp/definition/inventory-turns
- https://www.extensiv.com/blog/good-inventory-turnover-ratio
- https://www.numericalinsights.com/blog/how-to-measure-inventory-turnover-inventory-turns
- https://www.eturns.com/resources/blog/what-is-inventory-turnover-ratio-definition-calculations/
- https://www.faire.com/blog/buying/inventory-turnover/
Featured Images: pexels.com