Answers

Which A-movers are out of position?

Finds fast SKUs sitting in quiet locations: the slotting problem to fix first.

  1. 1File
  2. 2Columns
  3. 3Result

Columns

Names are flexible
  • skuor item, item_id, product
  • picksor pick_count, quantity, qty
  • locationor bay, zone, slot, bin

Ideal format, one zone per row

sku,picks,location
SKU-A001,432,ZONE-A
SKU-B012,287,ZONE-B
SKU-C003,91,ZONE-C

Read in memory, never written to the database, gone after 15 minutes.