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.
| Symbol | Meaning | Unit | Notes |
|---|---|---|---|
| COGS | Cost of goods sold over the period | currency | The cost of the stock that was actually sold, never revenue, which contains the margin. |
| AVG | Average inventory | currency | The value of stock carried on average, normally the mean of opening and closing. |
| T | Inventory turnover | ratio | How many times the shelf emptied in the period. A ratio, with no units. |
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.