How to Use the Days in Inventory Calculator: Steps and a Worked Example
Estimate how many days, on average, stock sits before it is sold. This guide shows what to enter, a worked example with real numbers, and the limits to keep in mind. The Days in Inventory Calculator tool is free, needs no account and runs in your browser.
What you need
- Average inventory value, for example 40000
- Cost of goods sold for the year, for example 300000
Step by step
- Open the Days in Inventory Calculator tool.
- Fill in Average inventory value.
- Fill in Cost of goods sold for the year.
- Read the result, which updates as soon as the inputs change.
Worked example
With these inputs:
- Average inventory value: 40000
- Cost of goods sold for the year: 300000
the tool returns:
Days in inventory: 48.67
A second example
Changing Average inventory value 40000 to 80000 gives:
Days in inventory: 97.33
Comparing two runs like this is a quick way to see how much each input moves the result.
How it works
The calculation is: Days in inventory = 365 ÷ (cost of goods sold ÷ average inventory). Enter the average inventory value and cost of goods sold for the year and the result appears straight away. Everything runs in your browser, so nothing you type is uploaded.
Things to keep in mind
Check your inputs, units and any local rules before you rely on the result.
Related tools
If this is not quite what you need, try Safety Stock Calculator, Inventory Reorder Point Calculator or Accounts Receivable Turnover Calculator.