Setting Reorder Points For Perishable And Expiry-Sensitive Stock

Reorder Point is the inventory level that triggers a new purchase or production order. For perishable and expiry-sensitive items (food, pharma, chemicals) the reorder point must account for shelf life, spoilage, FIFO rotation, and the higher cost of stockouts. This article explains how to set reorder points for perishables, including adjustments for demand decay and supplier constraints.

Extra Variables For Perishables

Beyond standard demand and lead time, perishable inventory requires consideration of: usable shelf life on receipt, average shelf life remaining at sale, expected spoilage rate, and regulatory hold times for quality sampling. These factors effectively increase required safety stock to avoid wastage-driven stockouts or reduce target on-hand to limit expiry risk—so you must balance service level against shrink.

Two Common Approaches

There are two pragmatic approaches: conservative service-driven reorder points and expiry-aware minimal stocking.

• Label:Service-Driven: Maintain higher reorder points that cover demand during lead time plus additional buffer for spoilage. Use when stockouts have severe commercial consequences (e.g., life-saving drugs).
• Label:Expiry-Aware Minimal: Lower reorder points to reduce on-hand quantities and waste; pair with more frequent orders and smaller lot sizes. Use when shrink costs exceed stockout costs or supplier flexibility supports frequent resupply.

Calculating An Expiry-Sensitive Reorder Point

Start with the standard formula: Reorder Point = Average Demand During Lead Time + Safety Stock. Adjust safety stock upward for expected spoilage during lead time and downward if faster turnover reduces shelf-life risk. A simple adjustment: Safety StockAdjusted = Safety StockStandard + (Average Lead Time Demand × Expected Spoilage Rate). If your spoilage is variable, add a spoilage-variability buffer based on historical variance.

Operational Controls To Reduce Risk

• Label:FIFO/FEFO: Enforce First-Expired-First-Out to minimize expiry on shelf; ensure the WMS tags batches with expiry dates and prioritizes picking accordingly.
• Label:Smaller Lots: Use smaller, more frequent orders to limit time on shelf; this reduces required reorder points and spoilage risk.
• Label:Supplier Collaboration: Negotiate shorter lead times or partial shipments to allow lower reorder points without raising stockout risk.
• Label:Real-Time Monitoring: Track remaining shelf life and recall risk; trigger promotions or rework before items expire to avoid write-offs.

Example

A dairy SKU sells 50 units per day. Lead time is 4 days. Expected spoilage during lead time averages 3% due to handling and in-transit temperature variability. Standard safety stock for desired service level is 40 units. Basic reorder point = (50 × 4) + 40 = 240 units. Adjusted safety stock for spoilage = 40 + (50 × 4 × 0.03) = 46 units. Adjusted reorder point = (50 × 4) + 46 = 246 units. If supplier can deliver twice per week replacing larger shipments, the operator may lower the reorder point and order smaller quantities more frequently to reduce waste.

Metrics To Track

• Label:Expiry Rate: Percentage of units expiring before sale; drives reorder point adjustments.
• Label:Fill Rate: Service level achieved; indicates if reorder points are too low.
• Label:Turnover Days: Average days on shelf; used to balance reorder point versus spoilage cost.
• Label:Write-Off Cost: Dollar value of spoiled inventory; compare to carrying cost to decide on safety stock strategy.

In short, the Reorder Point for perishables must be tuned to shelf life, spoilage, and supplier flexibility. Use expiry-aware calculations, enforce FEFO picking, and favor smaller, frequent replenishments when feasible to minimize waste while maintaining service levels.