Inventory Turns and Days on Hand Calculator
How often the inventory turns per year, how many days it covers and what holding it costs.
Enter your figures and select Calculate. The fields are prefilled with a worked example.
How to read it
How it was calculated
Please confirm your newsletter subscription via the link in your inbox.
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
- Inventory turns = EUR 12,000,000 / EUR 1,500,000 = 8 turns per year
- Days on hand = 365 / 8 = 45.6 days
- Carrying cost = EUR 1,500,000 × 20% = EUR 300,000 per year
- 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.
- Kanban Card Count
The number of kanban cards or containers a loop needs: demand during the replenishment lead time plus safety, divided by the container quantity.
- Safety Stock
The stock that protects a service level against variation in demand and in lead time.
- Reorder Point
The inventory level at which a new order has to be placed, and whether today is the day.