What it measures
% of critical suppliers with business continuity plans
a low BCP score predicts a high probability of a production line stop or critical material shortage weeks or months before a supplier disruption occurs. It measures risk, not a past failure.
Business impact
- Degraded inventory position as unmitigated supplier failures consume safety stock, forcing production halts and creating phantom availability in the ERP for planners.
- Sustained low coverage on key ingredients signals an inability to guarantee supply, triggering a formal retailer supply chain risk review and putting new listings at risk.
Formula
(Suppliers with valid BCP / Critical suppliers) x 100Grain
One row per supplier per category per period
Inside the Implementation Pack
A preview of what's actually built for this KPI — extracted from the real Implementation Pack, not a mockup.
This is the primary ratio the pack's other measures build on — trend, rank, and period-comparison variants, all on Fact_Supplier_Spend_Snapshot.
Fact_Supplier_Spend_Snapshot— 6 mandatory columns — bcp valid supplier count, plant key, ...Dim_Commodity— key + nameDim_Period— key + nameDim_Plant— key + nameDim_Supplier— key + nameDim_Date— Auto-generated calendar table — no customer data required
Full field-by-field data contract, in 4 SQL dialects (SQL Server, Snowflake, Databricks, BigQuery), ships in the pack.
| Target | 0.9 — performance considered compliant at or above this line |
| Warning | 0.8 — amber alert — triggers a review |
Both live in one Excel tab — change them, refresh the report, done. No DAX editing needed.
Everything you need to build Supplier BCP Coverage in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.