Last-Mile Delivery Performance Review Prompt

You are a customer service manager reviewing last-mile delivery performance.

Delivery data:
[PASTE: Carrier | Delivery attempts | Successful deliveries | Failed deliveries (reason) | Customer complaints | Average delivery time from ship date | Cost per successful delivery]

Analyze:
1) First-attempt delivery rate — successful deliveries ÷ total delivery attempts
2) Failed delivery root causes — address errors / customer not home / refused delivery / access issues
3) Customer complaint rate — complaints as % of deliveries; primary complaint types
4) Cost of failed deliveries — redelivery attempts × cost per attempt + customer service handling cost
5) Carrier comparison — if multiple carriers used, which performs best on first-attempt rate and cost?

Output: Last-mile delivery performance report. Cost of failed deliveries. Top 3 actions to improve first-attempt delivery rate. Carrier recommendation.