Aging analysis

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.

mceclip0.png

Have more questions? Submit a request