Supply Chain KPI Dashboard Design

I need to design a supply chain KPI dashboard. Our needs:

Supply chain scope: [End-to-end or specific functions]
Key stakeholders: [Who will use the dashboard]
Current pain points: [Visibility gaps, decision delays]
Existing data sources: [ERP, WMS, TMS, etc.]
Reporting frequency: [Real-time, daily, weekly]
Benchmarking needs: [Internal trends, industry comparisons]
Alert requirements: [What needs immediate attention]

Please help create:
1. KPI selection framework by supply chain function
2. Metric definitions and calculations
3. Target-setting methodology
4. Dashboard layout and hierarchy
5. Drill-down structure
6. Alert and exception logic
7. Reporting cadence and review process