The Aging Analysis report shows the length of time that inventory has been in a particular warehouse. The report assumes first in-first out inventory management.
In order to compute the age of a product for the Aging Analysis report, historical inventory is reverse calculated, where intakes are subtracted from the current inventory until there are none left.
So, for example, if there were 100 units in stock, each costing £1 and selling for £2, and 25 units had been brought in per month, the report would display:
Metric | Current | 0-30 days | 31-60 days | 61-90 days | 91-120 days | 121-180 days | |
---|---|---|---|---|---|---|---|
Item A | Stock | 100 | 25 | 25 | 25 | 25 | 0 |
Stock cost | £ 100 | £ 25 | £ 25 | £ 25 | £ 25 | £ 0 | |
Stock Retail | £ 200 | £ 50 | £ 50 | £ 50 | £ 50 | £ 0 |
Each intake increases the value of new stock in the corresponding time window.
The report can be filtered for specific warehouses, and grouped by category, vendor, brand, or tag or by individual variants, bundles or assemblies.
Note: The aging report is computed based on the historical stock and it won't populate with information immediately after you connect Demand Planner.
To access the Inventory Aging report, click on Reports > Aging Analysis.