Inventory Turnover

What is Inventory Turnover?

Inventory Turnover measures how many times in a given time-period your organization is able to sell its entire inventory. Inventory Turnover is an important efficiency metric and helpful in analyzing pricing, product demand, and of-course inventory purchase and costs. It is also a critical tool when selling perishable goods, where potential of waste is high.

How to calculate Inventory Turnover

ƒ Sum(COGS) / ((Beginning Inventory Value + Ending Inventory Value) / 2)

Favourable trend

Up is positive

Complexity level:
Intermediate

Date created: Mar 01, 2019

Latest update: Apr 16, 2019

Tell me more about this metric

Two variations exist on the calculation. Although using Sales as the value into which Average Inventory is divided, replacing Sales with Cost of Goods Sold (COGS), generally produces a more accurate result because markup is not factored in. Average Inventory value is calculated by adding the beginning and ending inventory together and dividing by two.

Inventory turnover is an important indicator of the efficiency of your supply chain, the quality and demand of the inventory you carry, and if you have good buying practices. Generally speaking, a higher turnover rate is better, while a lower turnover rate suggests inefficiency and difficulty turning stock into revenue. Each type of industry will have different benchmarks and norms. For instance, a fresh produce supplier will have many more turns than a heavy equipment manufacturer.

Example

A clothing retailer generates $1M in sales each month, with $400K in Costs of Goods Sold (COGS). Beginning of month inventory was valued at $45K and closing at $55K.

Using the Sales method, Inventory Turnover = $1M / (( $45K + $55K ) / 2 ) = 20X per month

Using the COGS method, Inventory Turnover = $400 / (( $45K + $55K ) / 2 ) = 8X per month

What do others say?

An in-depth article on Inventory Turnover by Marshall Hargrave

Metrics related to Inventory Turnover

Cost Of Goods Sold
Net Income
Revenue