How do you reduce food waste in a supermarket using data?
Short answer
Measure waste per store and per line first, then attack it at the order and the markdown. Most fresh waste is ordered, not created on the shelf. Joining sales, deliveries and write-offs shows which lines lose money after waste, so orders and markdown timing can be corrected line by line.
- 1
Record write-offs and markdowns per SKU and store, with a reason — damaged, expired, quality. Without this there is no baseline. (This and the next four points are from our project experience, not a study.)
- 2
Join them to sales and deliveries so each line shows margin after waste, not just sales.
- 3
Find the lines where waste is consistently high and orders consistently exceed sell-through, and correct those orders first.
- 4
Move markdowns earlier and make them data-driven: discount by remaining shelf life and stock left, not at a fixed time.
- 5
Track the result weekly against the baseline, so the saving is measured rather than assumed.
- 6
Keep the scale in mind: the CSIR estimates 10.3 million tonnes of edible food is lost or wasted in South Africa a year — 45% of the available supply.