Business

Inventory Turnover

Cost of goods sold divided by average inventory, and the days that implies.

Embed this calculator

Put it on your site. The link under the tool is required, the same way a quoted figure needs a source.

<iframe src="https://wagefigure.com/embed/inventory-turnover" title="Inventory Turnover" width="100%" height="720" style="border:0"></iframe>

Worked example

Start with Cost of goods sold of $480,000 and Average inventory of $60,000. Turns per year is 8.00. The breakdown is Days of inventory of 46.

How this number is made

Inventory turnover says how many times the stock is sold and replaced. Days in inventory is 365 divided by that turnover. Use average inventory, not the year-end number alone, if the year-end is a low or high point.

  1. Cost of goods sold is the cost, not the sales price.
  2. Average inventory is typically the beginning plus the ending balance, divided by two.

Formula

Turnover = cost of goods sold ÷ average inventory. Days = 365 ÷ turnover.

Questions

Is a higher turnover always better?

It ties up less cash. It can also mean you stock out. The right number depends on the product.

Why cost and not sales?

Sales include your markup. Inventory is on the books at cost. Mixing them inflates the turnover.