Warehouse Expiry-Date Rotation Exception Rate

Define rotation by product and customer promise, because earliest expiry can be overruled by a required minimum remaining shelf life or a qualified hold, and different customers can set different minimum remaining life, so the system's generic earliest-expiry instruction may need an order-specific check before shipping. At the moment of allocation, build the set of lots that were actually eligible and available, since an older lot released from quarantine tomorrow could not have been picked today, and a lot released from hold only after the truck departed was not eligible when a picker chose a newer lot.

Check the date field's meaning, because manufacture, retest, best-before and use-by dates should not be treated as interchangeable simply because each looks like an expiry field. Compare the allocated lot with the carton that was picked and dispatched, since a change during packing can defeat an otherwise accurate system suggestion.

For mixed bins, verify labels, access and unit of measure, because an older case that cannot be broken into the requested pieces may not be the valid alternative, and when a carton is repacked into smaller units, retain the original expiry and lot on each new saleable unit, since a correct allocation to a case does not prove each inner item stayed traceable. Returned product may need a new quality decision even while its printed date remains in range, so do not put it back into rotation based solely on age.

Record an override with reason and authorized time before dispatch, because a later explanation can help an investigation but should not be counted as prior approval, and a justified override should still state why and who approved it, so the exception analysis can distinguish valid customer shelf-life requirements from avoidable location or data mistakes. When an older eligible lot was inaccessible, fix the location or handling problem, because repeated manual overrides can indicate a pick-face design issue rather than careless workers, and if workers regularly override first-expire-first-out because old cartons sit behind newer ones, change slotting or replenish the pick face.

Segment the rate by product risk and customer promise, since combining medicines with long-life hardware in one score can hide the exceptions that matter most. Track short-dated inventory and write-offs separately, because a strong rotation score does not guarantee that demand planning or receiving brought in suitable shelf life, and compare near-expiry stock and write-offs with the exception rate, since a perfect picking sequence can coexist with excess purchases that expire before anyone orders them.

Check whether short-dated receipts were accepted under supplier terms, because a rotation exception after receipt may be a symptom of incoming shelf-life data not being checked. When a customer changes its minimum-life requirement, preserve the effective version and order date, so an old shipment is tested against the rule that governed it at pick time, and watch the clock, since date and time zone can matter near expiry.

Audit a sample with the original order, all eligible lots visible then, the actual shipment and override record, because today's inventory state cannot reconstruct the earlier decision by itself. Never lift a quality hold to make the rotation statistic prettier, since this measure should reveal allocation and data problems without substituting for product-release authority, and for product with a retest date, consult the authorized quality owner before treating it as expired because a warehouse rule should not invent a scientific product decision.

Use an effective-dated quality status for any retested lot, so a later release can make it eligible for future orders without changing the validity of an earlier pick decision. WHO storage guidance discusses stock rotation in pharmaceutical distribution, while Oracle documents expiry-aware allocation, but the actual product and contractual requirements must be used.

Separate waste, because expired-stock write-offs are a different outcome measure. Record inaccessible older stock as a location problem, and apply the rotation rule at the actual pick time.