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
| Input | Value |
|---|---|
| Days in observation period | 365 |
Products
| Average inventory at cost | Period cost of goods sold |
|---|---|
| 50 | 500 |
| 100 | 500 |
| Result | Value |
|---|---|
| Aggregate inventory days | 54.75 days |
| Total average inventory | 150 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Days in observation period | 365 | 402 | Aggregate inventory days | 54.75 days | 60.3 days |
| Average inventory at cost (row 1) | 50 | 55 | Aggregate inventory days | 54.75 days | 56.575 days |
| Period cost of goods sold (row 1) | 500 | 550 | Aggregate inventory days | 54.75 days | 52.142857 days |
