How to Use the Days in Inventory Calculator: Steps and a Worked Example

By 1 min read

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

  1. Open the Days in Inventory Calculator tool.
  2. Fill in Average inventory value.
  3. Fill in Cost of goods sold for the year.
  4. 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.

If this is not quite what you need, try Safety Stock Calculator, Inventory Reorder Point Calculator or Accounts Receivable Turnover Calculator.

More from the blog