Falcon Defense & Aerospace / 6. Supply Chain Performance
Reporting Period: Jan–Dec 2024 · Active suppliers only
← Back to Portal
Filter: DIM_SUPPLIER.IS_ACTIVE = TRUE · 198 active suppliers (10/16/172 by tier)
Supply Chain KPIs
2024
Tier & Risk Analysis
5-Year OTD % by Supplier Tier (PO-level actual)
Stable per-tier performance across 700K POs
Sole-Source Concentration by Part Category ($M)
2024 · 28% portfolio avg sole-source
Tier Snapshot (Dim OTD avg)
Tier-3 OTD 79% is the headline risk
Top 15 At-Risk Active Suppliers (lowest OTD)
Supplier CodeName Tier Quality OTD % Spend ($M) Defects
Methodology. Two OTD views coexist: (1) DIM_SUPPLIER.ON_TIME_DELIVERY_PCT is a supplier-scorecard metric (T1 95%, T2 87%, T3 79%). (2) PO-level OTD from FACT_PARTS_SUPPLY.ON_TIME_FLAG averages ~63% across tiers — reflecting tighter "on or before promised date" measurement. Both are valid; the scorecard is used for vendor management and the PO-level for operational tracking. Sole-source = parts with a single qualified supplier (IS_SOLE_SOURCE). Filter: active suppliers only. Synthetic demo data.