Expiry Date and Dealer Order Discipline in Food and FMCG
Fundamentals of Expiry Date Management: Transitioning from FIFO to FEFO
In a modern FMCG warehouse, not a single pallet or case should slip out of sight
At its core, expiry date management is about keeping tabs on a product’s shelf life before it gets away from you; done right, it pulls waste, returns, and customer complaints down sharply. Even so, plenty of businesses still run on “first-in, first-out” (FIFO) logic. In FMCG, that approach simply doesn’t hold up.
FIFO vs. FEFO: The Critical Difference
FIFO (First In, First Out): The first product to enter the warehouse is the first to be shipped. Sorting is based on production date.
FEFO (First Expired, First Out): The product with the nearest expiry date is the first to be shipped. Sorting is based on the expiry date.
So why does FEFO matter so much? Because the same product, pulled from different production batches, can carry very different shelf lives:
- Raw material quality can fluctuate between batches
- Seasonal production differences affect shelf life
- Storage conditions (e.g., cold chain breaks) can shorten expiry dates
- Different supplier sources result in varying shelf lives
The Four Pillars of Expiry Date Management
1. Visibility
Instant access to expiry date information for every product, lot, and case. This is impossible without a lot-based barcode/QR system.
2. Prioritization
Which product should be shipped first? The system has to handle the FEFO sorting for you.
3. Alerting Mechanism
Proactive notifications for products approaching threshold values. Intervention before the issue escalates.
4. Action Protocol
What happens when the expiry date approaches? Promotions, channel shifts, or disposal? A ready-made protocol for every scenario.
Shelf Life Calculation and Critical Threshold Values
Shelf life percentage: the rule retailers never write into the contract but always enforce
Retail chains lean on a “shelf life percentage” criterion when they accept products. It rarely appears in the written contract, yet it is policed strictly out in the field.
Calculating Shelf Life Percentage
Formula: (Expiry Date – Today) / (Expiry Date – Production Date) x 100
Example Calculation:
- Production date: January 1
- Expiry date: April 1 (90-day shelf life)
- Today’s date: February 1 (60 days remaining)
- Calculation: 60/90 x 100 = 67% shelf life
Typical Threshold Values by Sector
| Product Category | Typical Shelf Life | Min. Acceptance Threshold | Critical Alert |
|---|---|---|---|
| Dairy Products | 7-30 days | 60-70% | 30% |
| Yogurt, Ayran | 14-45 days | 50-60% | 25% |
| Confectionery | 6-12 months | 50% | 20% |
| Biscuits, Crackers | 6-9 months | 50% | 20% |
| Fruit Juice | 6-12 months | 50-60% | 25% |
| Canned Goods | 2-3 years | 40-50% | 15% |
| Frozen Food | 6-18 months | 50% | 20% |
| Personal Care | 2-3 years | 50% | 20% |
Threshold Management Strategy
You should establish a three-tier alert system:
- Yellow Alert (40%): Information to the sales team, report on stock requiring quick movement
- Orange Alert (25%): Promotion/discount decision, evaluation of alternative channels
- Red Alert (15%): Outlet, staff sales, donation, or disposal decision
Expiry Tracking and Shipment Optimization in Warehouse Operations
A FEFO-compliant warehouse layout can halve the waste rate
The warehouse is where expiry date management lives or dies. Even the best software falls flat in a badly organized warehouse.
FEFO-Compliant Warehouse Layout
Racking Principles:
- Front-back system: Products with the nearest expiry date go to the front, those with longer shelf lives to the back
- Gravity flow racks: Loading from the back, picking from the front – automatic FEFO
- Color coding: Different colored labels for each month (January=blue, February=green, etc.)
- Zone separation: Critical expiry products (milk, yogurt) in a separate area with more frequent checks
Goods Receipt Process:
- Lot number and expiry date are recorded upon entry
- Shelf life percentage is calculated; if below threshold, reject/return
- Accepted products are placed according to FEFO sequence
- System is updated, ensuring stock visibility
Shipment Optimization
The shipment planning system has to run a FEFO algorithm. Pick by hand and you invite errors.
Picking Sequence Optimization:
- The system automatically selects the lot with the nearest expiry date
- Different lots of the same product are not mixed in a single order (traceability)
- Customer-specific expiry preferences are defined in the system (Market A min 60%, Market B min 50%)
- Route planning matched with expiry – products with longer shelf lives for distant locations
Cold Chain and Expiry Relationship
A cold chain break means a shorter shelf life. That connection is one people tend to overlook.
- 2-4 hour break: Shelf life shortens by 10-20%
- 4-8 hour break: Shelf life shortens by 30-50%
- 8+ hour break: Product at risk, assessment required
IoT temperature sensors catch this the moment it happens and flag the relevant lot as “restricted shelf life.”
Dealer Order Discipline: Preventing Overstocking
Disciplined ordering = low waste, high turnover rate
More often than not, expiry problems start at the dealer. Overstocking, improper storage, FEFO non-compliance… A product that leaves the manufacturer in perfect shape can still turn into a problem on the dealer’s shelf.
Dealer Stock Policy Design
Minimum-Maximum Stock Levels:
Stock limits must be defined for every dealer and every product category:
- Minimum stock: Demand until the next order + safety stock
- Maximum stock: Amount that can be consumed at 60% of shelf life
- Reorder point: Automatic order suggestion when minimum stock is reached
Order Frequency Optimization:
Frequent and small orders should be preferred over large and infrequent ones:
- Dairy products: 2-3 orders per week
- Fresh foods: 1-2 orders per week
- Packaged foods: 1 order per week
- Long-life products: 1 order every 2 weeks
Push vs. Pull Balance
The traditional FMCG model is heavily “push” – product forced from the manufacturer down to the dealer. This model makes expiry problems worse.
Risks of the Push Model:
- End-of-month target pressure = excessive shipment
- Quantity-based discounts = unnecessary overstocking
- Sales representative commission = pressure on the dealer
Transition to Pull Model:
- Dealer stock is monitored in real-time
- System-based order suggestions (minimizing manual intervention)
- Performance measurement: Turnover rate + waste rate instead of revenue
Dealer Performance Scoring
Every dealer’s expiry performance must be measured:
- Return rate: Ratio to total shipment
- Waste rate: Amount of expired/near-expiry products
- Stock turnover rate: Comparison by category
- FEFO compliance: Duration of old products remaining on shelves
Special training, frequent visits, or even stock limits can be applied to low-performing dealers.
For more information on the food and FMCG sector, you can visit our industry page.
Field Example: FMCG Distributorship Transformation
Company Profile (Representative)
Regional FMCG distributor. 3 main warehouses, 45+ sales points/dealers, 500+ SKUs. Product range: Dairy, confectionery, beverages, personal care. Annual revenue: Mid-scale. Biggest headache: High return and waste rates.
Initial State
- Waste rate: 14% (2x the sector average)
- Return rate: 8% (due to customer complaints)
- Stock turnover: 8 times per year (target 12)
- Expiry tracking: Excel-based, weekly manual check
- Dealer order system: Phone + WhatsApp
- FEFO compliance: None, not even FIFO is fully applied
Steps Taken
- Month 1-2: Current state analysis. 3 months of waste data categorized. Top 20 problematic SKUs identified (they accounted for 80% of the waste). Warehouse layout examined, FEFO non-compliances detected.
- Month 3-4: WMS installation. Lot-based barcode system implemented. Goods receipt and shipment processes redesigned. FEFO-compliant racking layout created in the warehouse.
- Month 5-6: Dealer integration. Min-max stock levels defined for each dealer. B2B order portal opened (phone orders weren’t shut off outright, just made deliberately inconvenient). Dealer expiry performance scores began to be published.
- Month 7-9: Alert and action protocols. Three-tier alert system established. Quick action team formed for products approaching expiry. Weekly expiry meetings initiated.
- Month 10-12: Optimization and measurement. Forecasting model implemented (demand-based order suggestions). Push-pull balance adjusted. KPI dashboard made operational.
12th Month Results (Representative Values)
- Waste rate: 14% → 4%
- Return rate: 8% → 2%
- Stock turnover: 8x → 14x
- Customer complaints (expiry-related): 75% reduction
- Critical expiry alert time: Increased from 2 weeks to 6 weeks prior
- Dealer FEFO compliance: 30% → 85%
Investment and Return
Total investment items: WMS license, barcode infrastructure, training, consulting. For an operation of this scale, the return on investment period was 6-10 months. The drop in waste and returns alone paid the investment back.
7 Deadly Sins in Expiry Date Management
1. Settling for FIFO Instead of FEFO
The “first-in, first-out” logic falls short in FMCG. Different production batches have different expiry dates. If the system doesn’t support FEFO, manual control becomes mandatory – and that never lasts. Companies that keep putting off the WMS investment pay for it in waste.
2. Not Performing Lot-Based Tracking
Product-based stock is assumed to be enough. But different lots of the same product can be in completely different shape. One lot might have a broken cold chain while another is perfectly intact. Without lot tracking, you can’t tell which product to recall.
3. Ignoring Dealer Stock
The “we shipped it, the rest is the dealer’s problem” mindset. Yet returns and customer complaints eventually land on the manufacturer. If you can’t see dealer stock, you can’t prevent overstocking. A B2B portal or integrated system is essential.
4. Excessive Shipment Due to End-of-Month Target Pressure
The sales team pushes too much stock to the dealer at month-end to hit targets. The product sits in the dealer’s warehouse, then comes back as a return. Result: Sales on paper, loss in reality. Performance measurement has to be balanced with turnover rate + waste.
5. Setting Up an Alert System but Not Converting to Action
The system sends alerts, but nobody looks. Or they look, but the authority to act is unclear. “Who will decide on the discount? Who will approve disposal?” These questions go unanswered. The trio of Alert + Protocol + Authority is essential.
6. Managing Cold Chain Independently of Expiry
Cold chain breaks get detected, but their impact on expiry is never calculated. The product goes out at its normal expiry date because “it looks fine.” Two weeks later, the customer complaint arrives. IoT sensor + expiry integration is essential.
7. Not Analyzing Waste Data
At month-end, people say “we had this much waste” but never ask why. Which product? Which lot? Which warehouse? Which dealer? Improvement is impossible without root cause analysis. Data must be collected and analyzed.
Every waste is a data point – those who analyze win
Expiry Performance Metrics: What and How to Measure?
The following table contains critical expiry KPIs for FMCG businesses, sector averages, and target values:
| Metric | Sector Average | Good Level | Measurement Method |
|---|---|---|---|
| Waste Rate (Expiry-related) | 8-15% | 2-4% | Disposal/return amount / total stock |
| Return Rate (Expiry-related) | 5-10% | 1-2% | Expiry-related return / total shipment |
| Stock Turnover Rate (Annual) | 8-10x | 12-18x | Annual sales / average stock |
| FEFO Compliance Rate | 50-60% | 90%+ | FEFO-compliant shipment / total |
| Average Shelf Life Percentage (at Shipment) | 55-65% | 70%+ | Avg. SL% of shipped products |
| Critical Expiry Alert Time | 2-3 weeks | 6+ weeks | Days between alert and expiry |
| Dealer Stock Visibility | 40-50% | 85%+ | Ratio of real-time monitored dealers |
| Cold Chain Break Rate | 5-10% | 1% | Lots with temp. anomalies / total |
Monitor these metrics weekly and run monthly trend analysis. What matters isn’t the number on any given day, but the improvement curve.
Weekly Expiry Management Checklist
Review this list with your team at the beginning of every week:
Warehouse and Stock Control
- Are products with critical expiry (<30%) listed?
- Has an action plan been determined for these products?
- Is there any layout that does not comply with FEFO?
- Were newly arrived lots positioned correctly?
- Have cold chain temperature records been reviewed?
- Are lots with detected anomalies marked?
Shipment and Sales
- Has the avg. SL% of last week’s shipments been calculated?
- Have customer-specific SL% preferences been updated?
- Were there any shipments contrary to FEFO?
- Have return requests and reasons been recorded?
Dealer Management
- Have dealer stock levels been checked?
- Have overstocked dealers been identified?
- Has the dealer expiry performance score been updated?
- Has contact been made with problematic dealers?
Reporting and Analysis
- Has the weekly waste report been prepared?
- Have waste reasons been categorized?
- Have trend graphs been updated?
- Has root cause analysis been performed?
Frequently Asked Questions
Expiry date management is an inventory discipline that keeps waste, returns, and customer complaints to a minimum by systematically tracking the shelf life of products.
Its importance emerges in four main points:
- Financial impact: Provides significant cost savings in FMCG by reducing waste rates from 15-20% to 3-5%
- Customer satisfaction: Fresh product = happy customer = repeat sales
- Legal compliance: Mandatory compliance with food safety regulations
- Sustainability: Reducing food waste = environmental responsibility
FEFO (First Expired, First Out): The principle that the product with the nearest expiry date is shipped first.
FIFO (First In, First Out): Means the product that enters the warehouse first is the first to leave.
Critical difference: FIFO looks at the production date, FEFO at the expiry date. In FMCG, different production batches can have different expiry dates. For example:
- Batch A: Jan 1 production, Apr 1 expiry
- Batch B: Jan 15 production, Mar 1 expiry (shorter life due to different raw material)
FIFO logic sends Batch A (it entered first), but FEFO logic should send Batch B (it will expire first). In large-scale operations, that difference opens up a serious waste gap.
Dealer order discipline rests on four fundamental elements:
- Min-Max stock levels: Minimum and maximum stock limits are defined for every dealer and every product. The system provides automatic alerts.
- Order frequency standardization: Periods such as 2x per week for dairy, 1x per week for packaged foods are determined.
- Redesigning incentives: Periodic campaigns are preferred over quantity-based discounts – the incentive for overstocking is removed.
- Performance monitoring: Expiry performance (waste rate, return rate, turnover rate) is monitored by dealer, and special interventions are made for problematic dealers.
A B2B order portal makes these processes easier and gives you visibility.
Shelf life percentage shows the ratio of the product’s remaining shelf life to its total shelf life.
Formula: (Expiry Date – Today) / (Expiry Date – Production Date) x 100
Example:
- Production: Jan 1
- Expiry: Apr 1 (90 days total life)
- Today: Feb 1 (60 days remaining)
- SL% = 60/90 x 100 = 67%
Retailers usually demand a minimum 50-60% shelf life. Products below this threshold may not be accepted, or are bought at a discount. Tracking SL% is what lets you see return risk coming before it hits.
A phased action plan should be applied for products approaching expiry:
- At 40% shelf life (Yellow alert): Information goes to the sales team. Marked as stock requiring quick movement. Added to the priority shipment list.
- At 25% shelf life (Orange alert): Promotion/discount decision is made. Offers are made to alternative channels (wholesale, corporate).
- At 15% shelf life (Red alert): Outlet sale, staff sale, donation, or disposal decision is made. Records are kept in every case.
Responsibility and approval authority must be clearly defined for each stage. Leaving “who decides?” unanswered leads to delayed action and rising waste.
Modern expiry management rests on four fundamental technology layers:
- Barcode/QR systems: Provide lot-based tracking. Every product, pallet, and case can be tracked individually. Compliant with GS1 standards.
- WMS (Warehouse Management System): Optimizes shipment with the FEFO algorithm. Picking lists are generated automatically, manual error is minimized.
- IoT temperature sensors: Instantly detect cold chain breaks. In case of anomaly, the relevant lot is marked and a decision to shorten expiry is made.
- Forecasting and AI: Dynamic stock levels are determined with demand forecasting. Overstocking is prevented, waste risk decreases.
When these technologies work in an integrated manner, waste rates can be reduced by 70-80%.
Get Support for Your Project
I can help guide your digital transformation initiative. Book a free preliminary call to discuss your priorities.