What it measures
% of spend outside approved procurement channels
The spend has already occurred outside the approved channel. The KPI measures a past failure, and the financial and quality risks are already embedded in the P&L and inventory before the score is calculated.
Business impact
- A rising 'chaos tax' from unvetted suppliers: QA overtime for incoming inspections, unplanned line trials for new materials, and legal fees to resolve disputes without a contract.
- Working capital is damaged by non-standard Minimum Order Quantity (MOQ) buys, bloating the inventory position with odd-lot materials that risk obsolescence and write-off.
- A single product recall traced to an unapproved ingredient or food-contact packaging bought 'maverick' triggers an immediate delisting and a GFSI audit failure — the commercial red zone.
Formula
(Maverick spend / Total spend) x 100Grain
One row per purchase order line — supplier × material × commodity × plant × date
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_Purchase_Order_Line. It guards against missing dates and values with NOT ISBLANK checks.
Fact_Purchase_Order_Line— 7 mandatory columns — po creation date key, supplier key, ...Dim_Commodity— key + nameDim_Material— material_key + material_descriptionDim_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.05 — performance considered compliant at or below this line |
| Warning | 0.12 — 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 Maverick Spend Rate in Power BI — dimensional model, DAX measures, SQL views, and a food-industry demo dataset.