Inventory Turnover

What is Inventory Turnover?

Inventory turnover is a comparison of average inventory held by an organization with the cost of goods sold. In simple words, a number of times goods sold or consumed by an organization, and the ratio is also used to calculate the estimated time period required to sale the inventory held by the organization.

Inventory Turnover Formula

It can be calculated as follows:

Inventory Turnover Formula = Cost of Goods Sold/Average Inventory 
Inventory Turnover Formula

Explanation

This ratio is used by an organization to calculate the number of times it is selling goods and replace its stock during a given period of time. This ratio also helps in showing how effectively a company manages its inventory cost and how effectively its sales efforts are converted into figures. For the calculation of inventory turnover, we need to understand the following items:

Cost of Goods Sold

We use the cost of goods sold from the income statement since the cost of goods sold includes purchase cost as well as the cost incurred by the organization to manage such inventory, such as storage cost, handling cost, wages, and labor charges, etc.

Average Inventory Held

We use average inventory during the period is used instead of closing inventory since there might be situations where the company had an opening stock of inventory and purchased very less quantity of goods and the year-end it had sold most of the goods and if we use closing inventory, the ratio will not be based on inventory held by the organization during the period, which will not display the actual picture of time period taken by the organization to generate such sales.

Examples of Inventory Turnover Calculation (with Excel Template)

Let’s see some simple to advanced practical examples to understand it better.

You can download this Inventory Turnover Formula Excel Template here – Inventory Turnover Formula Excel Template

Example #1

Company STYLISH Ltd. is operating in the clothing products and income statement of last year of the company shows the following figures. You need to calculate the inventory turnover ratio.

Solution

Use below given data for the calculation.

Inventory Turnover Formula Example 1

Calculation of Average Inventory 

Inventory Turnover Formula Example 1.1

  • =(24560+1540)/2
  • Average Inventory = 13050

Inventory Turnover Formula Example 1.2

  • =452700/13050

Inventory Turnover will be –

Inventory Turnover Formula Example 1.3

Example #2

Taking the concept of inventory formula ahead, we will learn to calculate inventory turnover ratio as well as the inventory holding period. Suppose Company Furniture and fixtures Pvt. Ltd. manufactures chairs and tables. Its income statement shows that it had an opening inventory of 86900, and during the period, it manufactures chair and table costing 3495000, and at the end of the period, it had 635000 as stock in hand of inventory. We need to calculate the inventory turnover ratio as per as inventory holding period.

Solution

Use below given data for the calculation.

Inventory Turnover Formula Example 2

Calculation of Cost of Goods Sold

Inventory Turnover Formula Example 2.1

  • =86900+3495000-635000
  • Cost of Goods Sold = 2946900

Calculation of Average Inventory

Inventory Turnover Formula Example 2.2

  • =(86900+635000)/2
  • Average Inventory = 360950

The calculation can be done as follows-

Inventory Turnover Formula Example 2.3

  • = 2946900/360950

Inventory Turnover will be –

Inventory Turnover Formula Example 2.4

Inventory Holding Period

Example 2.5

  • = 365/ Inventory turnover Ratio
  • = 365/8.16
  • = 44.71 days

This means that the company roughly takes one and a half months to replace it is stock and sell its complete stock in hand.

Example #3

Taking another example to understand the benefit of using the inventory turnover ratio formula in practical life, Suppose Company Delta has an opening stock of $ 326,500 and purchased goods amounting to $ 5,284,600, and it paid direct expenses relating to goods handling are 65,300. At the end of the accounting period, it had $ 765,300 as a closing inventory. We need to calculate the inventory turnover ratio formula, as well as the inventory holding period.

Solution

Use below given data for the calculation.

Example 3

Calculation of Cost of Goods Sold

Inventory Turnover Formula Example 3.1

  • =326500+5284600+65300+765300
  • Cost of Goods Sold = 4911100

Calculation of Average Inventory

Example 3.2

  • =(326500+765300)/2
  • Average Inventory = 545900

The calculation can be done as follows-

Example 3.3

  • =4911100/545900

Inventory Turnover will be –

Example 3.4

Inventory Holding Period

Example 3.5

  • Inventory Holding Period = 40.57

Calculator

You can use these inventory turnover formula calculator

Cost of Goods Sold
Total Interest Expense
Inventory Turnover Formula
 

Inventory Turnover Formula =
Cost of Goods Sold
=
Total Interest Expense
0
= 0
0

Relevance and Use

  • It varies from industry to industry. For example, a clothing retailer company may have an inventory turnover of 5 to 8, whereas an automotive parts company may have a turnover of 45 to 50. So this shows that it is a very important tool in making strategies and achieving company objectives.
  • Inventory turnover depends on purchase and sale. If a company purchase high-value items, then it has to sell to be matched with purchase; otherwise, the company has to bear storage and handling the cost of high-value inventory.
  • In decision making, inventory turnover also plays a very important role, as explained below:

Higher Ratio

If the inventory turnover ratio is high, it means that the company’s product has very good demand in the market, and products are sold very quickly, which leads to less inventory maintenance costs and higher profits.

Lower Ratio

If the inventory ratio of a company is very low, it indicates that the company’s products are not often sold in the market, and inventory of the company becomes a slow-moving inventory, which leads to higher inventory costs and fewer profits.

If a company is suffering from a low inventory turnover ratio, it can adopt the following strategies to improve its inventory turnover ratio:

  • Review strategies relating to the pricing of products.
  • Try to improve sales by using marketing techniques.
  • Analyze the fast-moving inventory and slow-moving inventory
  • Improve bargain power and review the purchase price regularly
  • Understand the customers’ needs and try to get an order from customers well in advance.

Recommended Articles

This article has been a guide Inventory Turnover Formula. Here we discuss the formula for calculation of inventory turnover along with practical examples and a downloadable excel template. You can learn more about financial analysis from the following articles –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *