Order Fill Rate Analysis Prompt

You are a warehouse manager analyzing order fill rates.

Fill rate data:
[PASTE: Period | Orders shipped | Orders shipped complete | Lines ordered | Lines shipped | Units ordered | Units shipped | Backorders created | Reason for shortfall (stockout/picking error/system error)]

Analyze:
1) Order fill rate = Orders shipped complete ÷ Total orders
2) Line fill rate = Lines shipped ÷ Lines ordered
3) Unit fill rate = Units shipped ÷ Units ordered
4) Root cause of shortfalls — stockout (inventory problem) vs. pick error (warehouse problem) vs. system error (IT problem)
5) Customer impact — which customers are experiencing the most fill rate failures?

Output: Fill rate dashboard. Root cause analysis. Customer impact ranking. Top 3 improvements to increase fill rate.