Scenario #1 - Exact Match, then high to low quantity, no UOM breaks
- 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
- Sort by high to low inventory with lot rotation and ABC location
Scenario #1 Inventory
- Sorted by System Lot and License Plate.
- Inventory selected by allocation is highlighted in yellow.
- Inventory that was not considered is highlighted in blue. These lots are not eligible because they are outside the date code days window (more than 30 days from oldest date code in inventory).
Scenario #1 Results
- Rotate by Lottable04 (manufacture/receipt date)
Inventory selection process:
- Allocation Pass #1
- Qty to allocate = Qty 117
- Qty selected = 27
- Select LPN 107 from location B120
- No LPN matched the quantity to allocate
- Inventory sorted by (a) qty high to low, (b) Lot04, ©) Location ABC, (d) Location
- Allocation Pass #2
- Qty to allocate = Qty 90
- Qty selected = 25; LPN 103; location B101
- Select LPN 103 from location B101
- No LPN matched the quantity to allocate
- Inventory sorted by (a) qty high to low, (b) Lot04, ©) Location ABC, (d) Location
- Allocation Pass #3
- Qty to allocate = Qty 65
- Qty selected = 25; LPN 104; location B101
- No LPN matched the quantity to allocate
- Inventory sorted by (a) qty high to low, (b) Lot04, ©) Location ABC, (d) Location
- Allocation Pass #4
- Qty to allocate = Qty 40
- Qty selected = 25; LPN 106; location B130
- No LPN matched the quantity to allocate
- Inventory sorted by (a) qty high to low, (b) Lot04, ©) Location ABC, (d) Location
- Allocation Pass #5
- Qty to allocate = Qty 15
- Qty selected = 15; LPN 102; location B130
- 2 LPNs found with a quantity match
- Sort by (a) Lot04, (b) Location ABC, ©) Location
- Allocation Pass #5
- Qty to allocate = Qty 15
- Qty selected = 15; LPN 102; location B130
- 2 LPNs found with a quantity match
- Sort by (a) Lot04, (b) Location ABC, ©) Location