Stock and aging report
Shows where the money in stock lies: by warehouse, store, brand, season and age. The base for decisions on transfers, price cuts and returns.
Formula
Rows: warehouse, store, brand, season | Columns: units, cost, age groups (0–90, 91–180, 181–365, 365+ days), cover, dead-stock share, turnover
How to read
How to read: a growing share of the older age groups is a signal to act. The group boundaries are yours. Mistakes: age counted from the lot delivery date instead of first receipt of the SKU, mixing retail and cost valuation. In your company it may be named differently: check the reference book of your accounting system.