The write-off report arrived in March, covering the previous quarter, and the warehouse manager nearly choked on his coffee: $43,000 of frozen food had gone past its best-before date while sitting in the back of the cold room. The year-end number was worse — $87,000 in expired stock, all thrown out. For a food distributor with $8 million in annual revenue, that was a full 1 percent of sales, evaporated.
Why stock was dying in a cold room that had plenty of space
The warehouse had empty racks, so this wasn’t a space problem. The issue was that nobody knew what was actually in the back rows. New deliveries were stacked in front, and the older pallets stayed buried until someone got curious.
By then, the dates had passed. An ERP Consulting review traced the trail of every expired pallet in that quarter and found four identical patterns in every single case.
- Incoming pallets were logged by product name and supplier, but the best-before date was written on the box — never into the system, so no report could ever warn anyone.
- Pick lists were filled from the nearest stack, not the oldest stock, because there was no rule for which pallet to pick first.
- The cold room had daily temperature logs, but nobody connected a slow cooling fault in the back corner to the shorter shelf life of the product stored there.
- No one had ever run a “pallets shipping in the next 14 days” report, because the data didn’t exist.
The fix: dates in the system, and a 14-day warning
ERP Consulting set up three changes. First, every inbound pallet gets a shelf-life date typed into the system at receiving — it takes ten seconds per pallet. Second, the system flags any pallet with fewer than 14 days of shelf life left, and the fastest-moving product line gets picked from that flagged stock first. Third, the warehouse added a “last in, first moved” rule for short-life items, meaning the newest delivery goes into the back rows so the older stock comes out first.
The first quarter under the new rules produced a write-off of $18,000. The second quarter came in at $12,000. Most of that remaining amount was a single refrigeration failure that the temperature alarm did catch — but slowly. The team saved roughly $70,000 in a year with changes that cost nothing but discipline.
What to check this afternoon
Walk to your own warehouse or back room and look at the ten pallets with the oldest dates. Then check the system: does it even know those dates exist? If the answer is no, you’re holding a lottery ticket to the write-off report.
Start by making the date part of the receiving record on Monday morning, and run a report every Friday afternoon listing anything expiring in the next two weeks. That one habit will cut your spoilage faster than any renegotiated supplier contract. If the reporting structure isn’t obvious, an ERP Consulting workshop can map it in half a day.