CCalclabhub

Operations

Turnover from cost of goods sold and average inventory

The standard form. Divide the cost of the stock sold by the average value of the stock held to get the number of turns.

Last updated

The Formula

T = COGS / AVG

The standard form. Divide the cost of the stock sold by the average value of the stock held to get the number of turns.

SymbolMeaning
COGSCost of goods sold over the period
AVGAverage inventory
TInventory turnover

What Each Symbol Means

COGScurrency

Cost of goods sold over the period

The cost of the stock that was actually sold, never revenue, which contains the margin.

AVGcurrency

Average inventory

The value of stock carried on average, normally the mean of opening and closing.

Tratio

Inventory turnover

How many times the shelf emptied in the period. A ratio, with no units.

See It Worked With Real Numbers

A formula on its own does not tell you which number goes where. The how to calculate inventory turnover page applies this equation to a concrete case, shows every intermediate step, and names the mistakes that produce a wrong answer even when the algebra is right.

Where This Formula Appears

This equation is the working core of How To Calculate Inventory Turnover, filed under Business. Every number the guide produces comes from substituting into this one line.

Common Questions

What is the formula for Turnover from cost of goods sold and average inventory?

The formula for Turnover from cost of goods sold and average inventory is T = COGS / AVG. The standard form. Divide the cost of the stock sold by the average value of the stock held to get the number of turns.

What does each symbol in Turnover from cost of goods sold and average inventory stand for?

COGS is cost of goods sold over the period; AVG is average inventory; T is inventory turnover.

What units should I use with Turnover from cost of goods sold and average inventory?

Substitute COGS in money (any currency, as long as every money input uses the same one), AVG in money (any currency, as long as every money input uses the same one), T in ratio. Convert every input to those units before you start, because the equation only returns the right answer when the units on both sides agree.

What is a common mistake when using Turnover from cost of goods sold and average inventory?

Dividing revenue by inventory instead of cost of goods sold. Revenue contains the gross margin, so using it as the numerator inflates the ratio by exactly the margin factor. On revenue of 600000 against an average inventory of 60000.0 the result reads 10.0 turns, a quarter higher than the true 8.0 derived from cost of goods sold of 480000. Inventory is carried at cost on the balance sheet, so only a cost-based numerator keeps the two sides of the fraction in the same units.