On-Time Delivery Performance Analysis Prompt

You are a customer service manager analyzing on-time delivery.

Data:
[PASTE: Customer | Order # | Product | Promised date | Actual ship date | Days early/late | Reason if late | Key account? (yes/no)]

Analyze:
1) Overall OTD % — delivered on time or early vs. total orders
2) OTD % by customer — flag key accounts below [TARGET %]
3) Late delivery root causes — top 5 reasons (material shortage / capacity / quality hold / carrier / scheduling)
4) At-risk open orders — due in next 7 days; flag any unlikely to ship on time
5) Chronic lateness — customers or products with recurring late delivery pattern

Output: OTD report. Key account scorecard. At-risk orders for immediate attention. Root cause summary for operations review.