Expiry Date and Dealer Order Discipline in Food and FMCG
Fundamentals of Expiry Date Management: Transitioning from FIFO to FEFO
In modern FMCG warehouses, every pallet and every case must be under constant monitoring
Expiry date management is an inventory discipline that minimizes waste, returns, and customer complaints by systematically tracking the shelf life of products. However, many businesses still operate using a “first-in, first-out” (FIFO) logic. In the FMCG sector, this approach is insufficient.
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.
Why is FEFO critical? Because the same product from different production batches may have varying 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 must be capable of performing automatic FEFO sorting.
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 silent rule of retailers
Retail chains apply a “shelf life percentage” criterion when accepting products. While this is often not stated in official contracts, it is strictly monitored in field operations.
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
FEFO-compliant warehouse layout can halve the waste rate
Warehouse operations are the heart of expiry date management. Even the best software loses its functionality in a poorly 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 must run a FEFO algorithm. Manual selection = error.
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
Cold chain break = shortened shelf life. This relationship is often overlooked.
- 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 detect this situation instantly and mark the relevant lot as “restricted shelf life.”
Dealer Order Discipline: Preventing Overstocking
Disciplined ordering = low waste, high turnover rate
The source of expiry issues is often the dealers. Overstocking, improper storage, FEFO non-compliance… A high-quality product leaving the manufacturer can become a problem at the dealer level.
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 “push” (pushing from manufacturer to dealer) heavy. This model exacerbates expiry issues.
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 problem: 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 (80% of 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 not closed but discouraged). 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 reduction in waste and returns alone amortized the investment.
7 Deadly Sins in Expiry Date Management
1. Settling for FIFO Instead of FEFO
The “first-in, first-out” logic is insufficient in FMCG. Different production batches have different expiry dates. If the system doesn’t support FEFO, manual control is mandatory – but it’s not sustainable. Companies that delay WMS investment pay the price in waste.
2. Not Performing Lot-Based Tracking
Product-based stock is thought to be sufficient. However, different lots of the same product may be in different conditions. One lot might have a broken cold chain, while another is intact. Without lot tracking, you cannot know which product to recall.
3. Ignoring Dealer Stock
The “we shipped it, it’s the dealer’s problem” mindset. However, returns and customer complaints ultimately hit the manufacturer. If dealer stock is not visible, overstocking cannot be prevented. 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 the end of the month to hit targets. The product sits in the dealer’s warehouse and returns as a loss. Result: Sales on paper, loss in reality. Performance measurement must be balanced with turnover rate + waste.
5. Setting Up an Alert System but Not Converting to Action
The system sends alerts, but no one looks. Or they look, but action authorities are unclear. “Who will decide on the discount? Who will approve disposal?” These questions remain unanswered. The trio of Alert + Protocol + Authority is essential.
6. Managing Cold Chain Independently of Expiry
Cold chain breaks are detected, but their impact on expiry is not calculated. It is sold with a normal expiry date because “the product looks fine.” 2 weeks later, customer complaint. IoT sensor + expiry integration is essential.
7. Not Analyzing Waste Data
At the end of the month, people say “there was this much waste,” but don’t 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 perform monthly trend analysis. What matters is not the instantaneous value, 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 minimizes waste, returns, and customer complaints 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 (entered first), but FEFO logic should send Batch B (will expire first). This difference creates a serious waste gap in large-scale operations.
Dealer order discipline is ensured with 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 facilitates these processes and provides 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 purchased at a discount. SL% tracking is critical to foresee return risks.
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. Uncertainty about “who will decide?” leads to action delays and increased waste.
Modern expiry management includes four fundamental technology layers:
- Barcode/QR systems: Provides 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 detects 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.