Scenario #2 - Exact Match, full pallets, high to low quantity

  • 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 by high to low inventory with lot rotation, Location ABC, then Location

Scenario #2 Inventory

  • Sorted initially by System Lot to identify lots that are not valid since they are outside date code days (30)
  • Valid records then sorted by quantity high to low, Lot 04, Location ABC, then Location
  • Inventory selected by allocation highlighted in yellow

Scenario #2 Results

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

Inventory selection process:

  • Allocation Pass #1
    • Qty to allocate = Qty 117
    • Qty selected = 25
    • Select LPN 103 from location B101
    • No LPN matched the quantity to allocate
    • Sort 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
    • Sort 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
    • Sort 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
    • Sort full pallet quantity LPNs by (a) Lot04, (b) Location ABC, ©) Location
  • Allocation Pass #5
    • Qty to allocate = Qty 17
    • Qty selected = 17; LPN 102; location B130
    • No LPN matched the quantity to allocate
    • Sort full pallet quantity LPNs by (a) Lot04, (b) Location ABC, ©) Location