Wrong stock records waste food.Unrecorded waste makes stock records wrong.
What 23 grocery stores and one year of data show about stock record errors and fresh food waste.
What is a stock record error?
Every product has a stock figure in the store system, and orders are placed from it. The real quantity on the shelf drifts away from that figure. The gap is called inventory record inaccuracy (IRI): shelf minus system, IRI = PH − IS.
Positive IRI
More on the shelf than the system knows.
Negative IRI
Less on the shelf than the system thinks.
Two ways they feed each other
Error → waste
The system sees 5, the shelf holds 9: positive IRI
The system thinks stock is low
It orders more than the store needs
Too much fresh food sits on the shelf
More of it spoils: more waste
Waste → error
Food spoils and is thrown away
Nobody records it as waste
The system still counts it: it sees 9, the shelf holds 5, negative IRI
Recorded waste looks lower than it is
The system waits to reorder: the shelf can run empty
The two loops connect: when the extra food that spoils is thrown away without being recorded, the first loop starts the second.
One product, day by day
Positive IRI builds up
Negative IRI builds up
A simulation, not store data: one typical run, the same customers in both cases. Extra and less are measured against the same product with an accurate record.
What the data show
Waste piles up until the count corrects the record
Fresh products with positive IRI against similar products with an accurate record, week by week around a stock count.
Waste vs similar products
Deliveries vs similar products, % of weekly sales
Dashed lines: average over the eight weeks before and the weeks after the count. Single weeks are noisy; the averages are the figures quoted.
Part of the loss never shows up as waste
Value lost per year, as a share of sales: recorded as waste, or found later as a stock correction.
Recorded as wasteNot recorded as waste
In short
How often records are wrong
Out of 100 fresh products checked in a stock count: