Inventory aging buckets
Group dated stock lots into inclusive age buckets and total their lot count, quantity and cost at an as-of date.
The example value has been entered. Check it immediately or change the value.
Input is processed in the browser. Refreshing returns a sample value.
Instructions and example
age=asOf−receipt; bucket=[previous upper+1,current upper]; value=Σquantity×unitCost
At 2026-03-31, a 30-day upper bound includes receipts from 2026-03-01. The default 0–30 bucket contains 5 units costing 80.
Up to 500 lots and 10 increasing integer bounds from 1–36,500 days. Dates 1900–2100, quantities 1–1,000,000, costs 0–1,000,000 with 2 decimals. No future receipts or write-down calculations.
Frequently asked questions
Are inventory age upper bounds inclusive?
Yes. An upper bound of 30 includes day 30; the next bucket starts at day 31.
Is older stock automatically written down?
No. Entered costs are grouped by age without judging saleability or impairment rates.
Calculation criteria and reference materials
The calculation formula and scope of this tool are disclosed in the above description. Examples can be checked by substituting input values into the formula or following the specified string and calendar handling rules.
Verification of calculation criteria: · Calculation·verification principles · Report errors