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.

Result

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