Draft reference — content review pending
Inventory Days on Hand
The number of days represented by average inventory value at the selected period cost of goods sold.
Business question
How many days of cost of goods sold are represented by the average inventory held?
Formula
Inventory days on hand = average inventory value ÷ cost of goods sold for the selected period × number of days in that period.
Calculation notes
Use the same currency basis, valuation method, locations, and period for inventory and cost of goods sold. State the day-count convention and whether the average uses opening and closing balances or more observations.
Edge-case guidance
A zero or very low cost of goods sold makes the result unstable or not meaningful. Seasonal peaks, purchases before demand, write-offs, transfers, and valuation changes can distort the average; do not compare inconsistent valuation policies.
Required data
| Input | Type | Status | Available source hints |
|---|---|---|---|
| Average inventory valueAverage inventory value under the agreed accounting valuation and location rules. | Currency | Required | Accounting software · Excel · Google Sheets · Manual records |
| Cost of goods soldCost assigned to goods sold during the same selected period and on a comparable basis. | Currency | Required | Accounting software · Excel · Google Sheets |
| Days in selected periodCalendar or operating days used consistently for the selected reporting period. | Number | Required | Manual records · Excel |
Interpretation
Use this working-capital measure with demand, lead time, service level, product mix, and seasonality. It is a value-based measure, not a count of physical units.
Caution
Lower days on hand is not automatically better: insufficient stock can cause stockouts, rushed purchasing, and lost service. Keep inventory valuation consistent and investigate seasonal mixes.
Implementation recommendation
Agree on valuation, averaging, day-count, and location rules with finance and operations, then review the trend by product group where data permits.
Target guidance
Set the first target for inventory days on hand from comparable internal history, then adjust it for assortment, service commitments, seasonality, capacity, and data quality. Review the direction with the accountable owner and consider this trade-off: reducing inventory days can release cash while increasing stockout and supplier-dependency risk.