
Design an Executive Reliability KPI Dashboard
N.B. Merge fields will be populated from equity system; ensure numbers align with HRIS. Include regional variants where [Jurisdiction] requires different phrasing.
📄 Prompt Template
Develop an executive-ready supply chain reliability dashboard for [CompanyName] operating in [Region] over [Timeframe]. Prioritize indicators such as OTIF, Perfect Order Rate, Order Cycle Time, Lead Time Variability, Carrier On-Time %, Warehouse Pick Accuracy, Damage Rate, and Port/Terminal Dwell Time. Use [DataSource] as the primary data source and include any additional KPIs from [KPIList]. Specify the calculation logic, data lineage, and refresh cadence.
Output format:
Executive summary (≤120 words) on reliability trends vs. targets [TargetOTIF].
Markdown table “KPI Definitions” with columns: KPI, Formula, Target, Thresholds (R/Y/G), Grain, Data Source, Owner, Review Cadence.
Visualization blueprint listing each chart’s type, purpose, and drill-downs.
Data model sketch: dimensions (time, lane, node, carrier, SKU, customer tier) and fact tables.
Governance plan with KPI owners and escalation triggers.
Ensure recommendations for three “quick wins” and three structural initiatives aligned to the dashboard insights.