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:

    What it means for food waste