Home / Blog / Planning

Planning

Why lot expiration dates belong in the production schedule

By Karel Quintana · Updated October 17, 2026

Planning only works if “available” means available on the day the batch will run. In batch and process plants that day is often not today. The line is in a changeover, a vessel is tied up, or a higher-priority order is already sequenced. The ingredient lot sitting in the warehouse can expire, or fall inside a customer’s remaining-shelf-life rule, before that line is free.

Schedules built without that view fail in a familiar way. The plan looks full and feasible on Monday. On Wednesday the batch cannot start. Someone hunts for a substitute lot, the changeover gets longer, and the promise to the customer moves. The information was in the building the whole time. It was not in the schedule.

On-hand quantity is not a plan

Quantity on hand answers a warehouse question. The scheduler needs a different one: which lot can this recipe consume on this date, on this line. That answer depends on:

• Expiration or retest date, compared with the planned start, not with today’s date.
• Status. Quarantine, hold, and rejected stock are not available, even when the balance looks healthy.
• Allocation. A lot already promised to another batch should not be planned twice.
• Where it sits. A lot in another warehouse, or in a tank that is not connected to this line, is not ready because a report says the item exists.

First-expired, first-out is the picking rule that keeps those lots from becoming waste. It only helps if planning uses the same rule. A scheduler who sequences by due date alone will keep assigning the freshest-looking quantity and leave the short-dated lot for a batch that can no longer use it.

Changeover and expiration travel together

Expiration problems get worse when changeovers are underestimated. If the real clean takes twice as long as the standard, every downstream batch slides toward the date its ingredients die. The plant then “discovers” a material problem that was actually a scheduling assumption. Seeing changeover time, equipment, and lot dates in one plan stops that handoff. You either pull the batch forward, pick a lot that survives the delay, or tell the customer before the week is already broken.

This is the second of the five decisions batch plants make every day: can we deliver what we promised? MFGMAX Nutra ERP keeps inventory, batches, and lot status in the same system so that question is not split across a planning board and a binder. Distributors face a cousin of the same issue — cash and fill rate trapped in lots customers will not take — which is covered in how distributors see cash in inventory.

What to ask of the current system

Before adding another planning meeting, ask whether the schedule can show, for a proposed batch:

1. The lots that will still be eligible on the start date.
2. The lots that will not, and why.
3. The equipment and the changeover that date assumes.

If the honest answer is “someone checks the binder,” the plan is being finished on the floor. That is where delays, substitutions, and wasted lots come from. Once the batch does start, the next gap is whether anyone can see yield while it is running. That is in-process visibility.