Open calculator ↗

Inventory days by product mix · Calculation guide

Use average inventory at cost and cost of goods sold over the same period for each product.

Calculation guide

Aggregate balances first; high-cost products have proportionally greater weight.

Inventory days = period days × Σ average inventory / Σ cost of goods sold

Inputs

Days in observation period

Example entry 365. Use whole numbers.

Average inventory at cost

Example entry 50 (in the selected currency).

Period cost of goods sold

Example entry 500 (in the selected currency).

Worked example

InputValue
Days in observation period365

Products

Average inventory at costPeriod cost of goods sold
50500
100500
ResultValue
Aggregate inventory days54.75 days
Total average inventory150

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Days in observation period365402Aggregate inventory days54.75 days60.3 days
Average inventory at cost (row 1)5055Aggregate inventory days54.75 days56.575 days
Period cost of goods sold (row 1)500550Aggregate inventory days54.75 days52.142857 days
Inventory days by product mix →

Sources