Inventory aging without a single fake average
Days-of-cover is a planning number. On the floor, aging is a location story: which pallets have sat in reserve past the last cycle count, and which pick faces were refilled from a different lot than the board assumed.
We draw aging as three location bands—receiving hold, reserve, pick—rather than one site-wide bar. A supervisor can then send a counter to the band that is actually old, instead of running a full physical because a chart turned red.
Lot codes and pack sizes belong on the board only when the site already writes them on the pallet label. Inventing a lot column for a site that does not capture lots creates a second set of fiction.
If a family is seasonal, we mark the season window on the column header. That prevents last year’s garden chemicals from looking like a current stockout risk in March.