Managing Perishable Inventory & Expiry Wastage in Retail Supermarkets: Practical Strategies & Calculations

For FMCG grocery retailers, neighborhood supermarkets, and departmental marts, inventory shrinkage and expired packaged goods represent a persistent drain on gross margins. When store owners rely on manual visual spot-checks to reorder stock from suppliers, two costly errors occur: overstocking slow-moving SKUs (which leads to shelf expiry) and stocking out of high-velocity staples during peak rush hours.

1. The Mechanics of Shelf Shrinkage in Indian Retail

Unlike durable goods, perishable and FMCG items have defined shelf-life windows. Dairy products (3–7 days), bakery items (3–5 days), and packaged condiments or snacks (3–6 months) require continuous turnover monitoring. Without system-enforced batch tracking, cashiers and floor staff routinely shelve newer shipments in front of older stock, leaving older units to expire unpurchased at the back of display aisles.

2. Implementing First-Expired-First-Out (FEFO) Protocol

Modern retail POS systems solve this by enforcing FEFO (First-Expired-First-Out) protocols rather than simple FIFO (First-In-First-Out):

• Inward Batch Indexing: When receiving supplier shipments, record the manufacturer batch number and expiry date alongside the standard EAN-13 barcode.
• Automated Pre-Expiry Thresholds: Configure the system to flag items 15, 7, and 3 days before their expiration date.
• Dynamic Counter Markdowns: Instead of writing off near-expiry goods at a 100% loss, trigger automated 20% to 40% clearance discounts at the billing counter to clear inventory profitably.

3. Illustrative Financial Model

Note: The following model is an illustrative operational projection for a typical neighborhood supermarket with ₹10,00,000 monthly FMCG turnover. Actual results vary based on product mix and supplier return terms.

4. Practical Steps for Cashiers and Store Managers

To successfully prevent inventory loss, retail managers should implement a 3-step routine:

1. Daily Expiry Audit Report: Review the automated 5-minute morning report listing all items expiring within the next 7 days.
2. Clearance Basket Placement: Physically move identified goods to a prominent checkout clearance stand with clear promotional signage.
3. Weekly Variance Count: Reconcile recorded stock levels against physical shelf counts using a handheld 2D barcode scanner every Tuesday morning.