GIFSQ Tools · Module 18 — Manufacturing, Costing & Supply Chain · Tool 355 of 500
Use the stock that expires first: enter each lot as quantity:days-to-expiry, plus the demand to fill, and the tool allocates the demand first-expired-first-out (FEFO) and shows any shortfall.
Try sample values — fills the form with the worked example below.
–
Allocated (units)
–
Shortfall (units)
–
Lots used
Equation: Sort lots by days to expiry, earliest first. Take from each lot in turn until the demand is filled or the lots run out. Allocated = units taken. Shortfall = demand − allocated (floored at 0). Lots used = the number of lots touched.
Method: First-expired-first-out (FEFO) allocation: the standard stock-rotation rule for food, where the lot nearest its expiry date is used first so the least stock expires on the shelf. FEFO differs from first-in-first-out (FIFO) when a later delivery has an earlier expiry date.
Assumptions: the days-to-expiry figures are correct on the day of planning; lots are used in whole units; partial use of a lot is allowed.
Limitations: the tool plans one demand figure only and does not check whether a lot will expire before it can be used — a lot with 2 days left and a slow production rate may still expire.
Rounding: quantities as whole units; intermediates unrounded.
This is a calculation aid, not a laboratory report — confirm against your accredited method before citing a value.
Method: First-expired-first-out (FEFO) allocation: the standard stock-rotation rule for food, where the lot nearest its expiry date is used first so the least stock expires on the shelf. FEFO differs from first-in-first-out (FIFO) when a later delivery has an earlier expiry date.
Assumptions: the days-to-expiry figures are correct on the day of planning; lots are used in whole units; partial use of a lot is allowed.
Limitations: the tool plans one demand figure only and does not check whether a lot will expire before it can be used — a lot with 2 days left and a slow production rate may still expire.
Rounding: quantities as whole units; intermediates unrounded.
This is a calculation aid, not a laboratory report — confirm against your accredited method before citing a value.
Worked example: Lots 200:10, 100:30, 50:60 and demand 250: use 200 from the 10-day lot, then 50 from the 30-day lot — allocated 250, shortfall 0, lots used 2.
Enter values above to see results.
Check the earliest lot first in the warehouse — FEFO only works if the physical pick matches the plan. Tool 355 of 500 — GIFSQ
