Shelf-Life ATP

The core mechanism that dynamically computes the usable life of a batch at the time of delivery. The system subtracts the transit time from the batch's expiration date to determine if it meets the customer's minimum remaining shelf life (MRSL) requirement.

• Formula: Remaining Shelf Life = Expiration Date - (Current Date + Transit Time)
• Rejection Logic: If Remaining Shelf Life < Customer MRSL, the batch is excluded from the ATP check
• Example: A pharmaceutical batch expiring in 90 days with a 5-day transit time and a customer requirement of 60 days minimum remaining shelf life would be rejected (85 days available < 90 days required? No, 85 > 60, so it passes)

A material valuation and picking strategy that prioritizes the consumption of batches closest to their expiration date. When multiple batches meet the customer's minimum remaining shelf life, the ATP engine allocates the oldest viable stock first to minimize waste.

• Waste Reduction: Reduces write-offs from expired inventory by up to 30%
• Rule Hierarchy: FEFO logic applies only after the MRSL gate is passed
• Industry Application: Critical in food, beverage, and pharmaceutical cold chains

A master data configuration that defines the minimum remaining shelf life and maximum shelf life tolerances per customer or ship-to location. This allows the ATP engine to segment inventory by quality requirements.

• Minimum Remaining Shelf Life: The floor below which a batch cannot be promised (e.g., 70% of total shelf life)
• Maximum Shelf Life: An upper bound to prevent shipping overly fresh goods when older stock is available
• Regulatory Alignment: Enforces compliance with retailer-specific receiving policies and pharmacopeia standards

The ability to filter ATP results not just by expiration date but by other batch-level attributes such as country of origin, potency, or certification status. This combines shelf-life logic with broader batch management rules.

• Attribute-Based Promising: Only batches with 'Organic' or 'Halal' certifications are considered
• Regulatory Hold: Batches in quality inspection status are automatically excluded from the ATP netting
• Traceability: Maintains a full audit trail from order line to specific batch number for recall readiness

The forward-looking time window over which the system projects batch expiration and availability. Unlike standard ATP which looks at inventory quantity, shelf-life ATP must also project quality degradation over time.

• Dynamic Horizon: Extends through the latest expiration date of any batch in the system
• Simulation: Planners can simulate 'what-if' scenarios for large orders that might consume multiple batches
• Constraint Coupling: Integrates with Capable-to-Promise (CTP) to trigger new production if no existing batch meets the freshness window

The step-by-step calculation that modifies standard ATP netting to account for expiration. The system nets demand against supply in chronological order of expiration, not just receipt date.

• Step 1: Identify all batches with sufficient remaining shelf life at the requested delivery date
• Step 2: Sort eligible batches by expiration date (FEFO)
• Step 3: Net the order quantity against the oldest eligible batch first
• Step 4: If quantity remains, proceed to the next batch; if exhausted, trigger a backorder or CTP check