Develop a comprehensive KPI tree for [Company] focused on improving On-Time Delivery (OTD) in [Region] over [Timeframe]. Start by defining the primary KPI (OTD %) and decompose it into second-level drivers (e.g., pickup reliability, departure adherence, linehaul punctuality, port/terminal dwell, last-mile arrival accuracy) and third-level operational metrics (e.g., gate-in to gate-out, dwell > [TargetThreshold] hours, first-attempt delivery rate). Specify data sources (TMS, WMS, telematics, EDI 214/315), calculation formulas, and measurement frequency. Then design a continuous feedback loop owned by [Role] detailing cadence (daily/weekly/monthly), roles, and touchpoints (control tower, dispatch, warehouse, customer service).
Output format:
Executive Summary (≤120 words).
KPI Tree (indented text).
KPI Catalog (Markdown table: KPI | Formula | Source | Frequency | Owner | Target | Thresholds).
Feedback Loop Design (bulleted steps: detect → diagnose → decide → act → verify).
RACI Matrix (Markdown table).
90-Day Improvement Roadmap with milestones and leading indicators.
Include alert thresholds for green/amber/red aligned to [OnTimeTarget] and an issue triage flow from detection to corrective action within [SLAWindow].