Scenario #3 - Full pallets, remaining quantity match, minimize picks

  • Rotate by Lottable04 (manufacture/receipt date)
  • Quantity Ordered = 117
  • Shelf Life - not applicable
  • Date Code Days = 30
  • Pack Quantity
    • 1 Case
    • 25 Pallets
  • General Strategy Rules
    • Allocate a license plate with a quantity that matches the quantity needed
    • Select full pallet quantity by Lot, Location ABC, Location, then LIFO time in location
    • Sort non pallets by LPN quantity with lot rotation, Location ABC, then Location

Scenario #3 Inventory

  • Sorted initially by System Lot to identify lots that are not valid since they are outside date code days (30)
  • Inventory selected by allocation highlighted in yellow

Scenario #3 Results

  • Get full pallets based on Lottable04 (manufacture/receipt date), location ABC, and location
  • Quantity match where possible (none found)
  • Get non full pallet quantity LPNs based on lottable04, low to high quantity, location ABC, and location

Inventory selection process:

  • Allocation Pass #1
    • Qty to allocate = Qty 117
    • Qty selected = 25; LPN 103 from location B101
    • No LPN matched the quantity to allocate
    • Include only full pallet quantity LPNs by (a) Lot04, (b) Location ABC, ©) Location
  • Allocation Pass #2
    • Qty to allocate = Qty 92
    • Qty selected = 25; LPN 104; location B101
    • No LPN matched the quantity to allocate
    • Include only full pallet quantity LPNs by (a) Lot04, (b) Location ABC, ©) Location
  • Allocation Pass #3
    • Qty to allocate = Qty 67
    • Qty selected = 25; LPN 106; location B130
    • No LPN matched the quantity to allocate
    • Include only full pallet quantity LPNs by (a) Lot04, (b) Location ABC, ©) Location
  • Allocation Pass #4
    • Qty to allocate = Qty 42
    • Qty selected = 25; LPN 110; location B120
    • No LPN matched the quantity to allocate
    • Include only full pallet quantity LPNs by (a) Lot04, (b) Location ABC, ©) Location
  • Allocation Pass #5
    • Qty to allocate = Qty 17
    • Qty selected = 17; LPN 101; location B130
    • No LPN matched the quantity to allocate
    • Quantity needed less than full pallet (25) so skip pallet step
    • Select LPNs for non-pallet quantity (<> 25)
      • Bigger fit rule requires LPN quantity > 17 (quantity needed)
      • LPN 101 is oldest lot closest to the quantity needed (qty = 20)