Packer Performance / Single vs Multi Item Orders

[Ian_kbf]

Background:

We need a fair, complexity‑adjusted view of individual packer performance. Single‑item / Single‑SKU orders are inherently faster than mixed‑SKU, multi‑line baskets. I want report that normalises performance for order complexity so managers can compare packers like‑for‑like, set fair targets, identify training needs, and plan staffing.

Goals:

• Measure packer productivity adjusted for order complexity.

• Reduce bias toward packers assigned to easier baskets.

• Provide actionable insights for coaching, training, and line balancing.

Order Definition

• Order Type

  • SIO: Single Item Order

  • SIM: Single Item Multiple Order

  • MIX: Mixed Line Order

Output

• A complexity‑adjusted efficiency index (EI) per packer, shift, and date period
  Clear segmentation of order types (Single Item One‑unit (SIO), Single Item Multi‑unit (SIM), Mixed‑SKU Multi‑item (MIX))

The report could be further extended to add the complexity of packing an item as some items need extra filling, special packaging etc.

Happy for this to be a simple CSV report that we could pipe into a graphing engine columns to include

Structure:

• date, shift, packer_id, packer_name, station_id

• orders, SIO_orders, SIM_orders, MIX_orders

• units_packed, distinct_skus_packed, avg_ocf

• sum_sps_seconds, sum_aps_seconds, efficiency_index

• orders_per_hour, expected_orders_per_hour