Skip to content
Free calculator | Inventory and replenishment

Inventory Turns and Days on Hand Calculator

How often the inventory turns per year, how many days it covers and what holding it costs.

Your figures

EUR
EUR

Valued at cost, average of several dates, not one year-end value.

%

Calculated in your browser. Your figures are neither transmitted nor stored.

Enter your figures and select Calculate. The fields are prefilled with a worked example.

The formula

Use this calculator when you want to judge the level of inventory as a whole and put a EUR figure on it.

Inventory turns = Annual cost of goods sold / Average inventory value

Days on hand = 365 / Inventory turns

Carrying cost = Average inventory value × Carrying cost rate

Worked example

Inputs

  • Annual cost of goods sold: 12,000,000 EUR
  • Average inventory value: 1,500,000 EUR
  • Carrying cost rate per year: 20%

Calculation

  1. Inventory turns = EUR 12,000,000 / EUR 1,500,000 = 8 turns per year
  2. Days on hand = 365 / 8 = 45.6 days
  3. Carrying cost = EUR 1,500,000 × 20% = EUR 300,000 per year
  4. One more turn: EUR 12,000,000 / 9 = EUR 1,333,333 inventory, EUR 166,667 less than today

Result

Inventory turns: 8 turns per year. The inventory turns 8 times per year and covers 45.6 days. Holding it costs about EUR 300,000 per year. One additional turn would release EUR 166,667 in cash once and save EUR 33,333 in carrying cost every year. What is a good value depends on the industry and the depth of production, so compare with your own trend first.

How to read the result

  • Use cost of goods sold, not revenue, and value the inventory at cost. Mixing revenue with cost-based inventory inflates the turns.
  • An average hides the extremes. Split the result by raw material, work in progress and finished goods, and look for the items that do not move at all.
  • Turns rise through shorter lead times and smaller lots. Cutting stock without changing the process only moves the problem into delivery performance.
Newsletter

One Lean idea.
Every two weeks.