{"as_of":"2026-06-23","source":"neon","config_version":"2026-06-pilot-1","count":12,"diagnostics":{"suppliers":18,"families":12,"spend_records":21},"opportunities":[{"opportunity_id":"opp_fam_acme_it_hardware","rank":1,"total_score":0.5142954157530781,"family_id":"fam_acme","family_name":"Acme","category":"IT Hardware","addressable_spend_usd":1848000,"factors":[{"factor":"addressable_spend","score":0.3696,"weight":0.3,"contribution":0.11087999999999999,"raw_value":1848000,"meaning":"$1,848,000 of addressable spend — 37% of the $5,000,000 cap; a bigger pool scores higher","evidence":["spend_INV-1001","spend_INV-1002","spend_INV-1003"]},{"factor":"fragmentation","score":0.45538876707707876,"weight":0.2,"contribution":0.09107775341541575,"raw_value":2,"meaning":"spread across 2 suppliers; a more even split scores higher (more consolidation upside)","evidence":["sup_acme_us","sup_acme_emea"]},{"factor":"contract_leakage","score":0.6493506493506493,"weight":0.25,"contribution":0.16233766233766234,"raw_value":1200000,"meaning":"65% of spend is off-contract or on an expired agreement","evidence":[]},{"factor":"sourcing_age","score":1,"weight":0.15,"contribution":0.15,"raw_value":1940,"meaning":"last sourced 1940 days ago — past the 1095-day stale line, score maxed","evidence":["1000000001"]},{"factor":"risk","score":0,"weight":0.1,"contribution":0,"raw_value":"low","meaning":"supply-risk band \"low\" (pilot uses a deterministic floor, not a live risk feed)","evidence":["risk:floor"]}],"savings":{"low_usd":92400,"high_usd":184800,"levers":["bring_off_contract_under_contract","consolidate_fragmented_spend","recompete_stale_category"]},"confidence":"needs_review","needs_review":true,"review_reasons":["thin_spend_coverage"],"recommended_action":"Consolidate fragmented spend across the supplier family","primary_lever":"consolidate_fragmented_spend","last_sourced":"2021-03-01","as_of":"2026-06-23","config_version":"2026-06-pilot-1","snapshot_hash":"dfe29f1ab5868b9662787a3d319589486e3181d8dadcd5bc693630491f2f7f37"},{"opportunity_id":"opp_fam_staples_office_supplies","rank":2,"total_score":0.5119361537502876,"family_id":"fam_staples","family_name":"Staples","category":"Office Supplies","addressable_spend_usd":488600,"factors":[{"factor":"addressable_spend","score":0.09772,"weight":0.3,"contribution":0.029316,"raw_value":488600,"meaning":"$488,600 of addressable spend — 10% of the $5,000,000 cap; a bigger pool scores higher","evidence":["spend_INV-3002","spend_INV-3003"]},{"factor":"fragmentation","score":0.49793498897247745,"weight":0.2,"contribution":0.0995869977944955,"raw_value":2,"meaning":"spread across 2 suppliers; a more even split scores higher (more consolidation upside)","evidence":["sup_staples_us","sup_staples_eu"]},{"factor":"contract_leakage","score":0.5321326238231683,"weight":0.25,"contribution":0.13303315595579207,"raw_value":260000,"meaning":"53% of spend is off-contract or on an expired agreement","evidence":[]},{"factor":"sourcing_age","score":1,"weight":0.15,"contribution":0.15,"raw_value":1756,"meaning":"last sourced 1756 days ago — past the 1095-day stale line, score maxed","evidence":["1000000090"]},{"factor":"risk","score":1,"weight":0.1,"contribution":0.1,"raw_value":"high","meaning":"supply-risk band \"high\" (pilot uses a deterministic floor, not a live risk feed)","evidence":["risk:floor"]}],"savings":{"low_usd":24430,"high_usd":48860,"levers":["bring_off_contract_under_contract","consolidate_fragmented_spend","recompete_stale_category"]},"confidence":"high","needs_review":false,"review_reasons":[],"recommended_action":"Consolidate fragmented spend across the supplier family","primary_lever":"consolidate_fragmented_spend","last_sourced":"2021-09-01","as_of":"2026-06-23","config_version":"2026-06-pilot-1","snapshot_hash":"dfe29f1ab5868b9662787a3d319589486e3181d8dadcd5bc693630491f2f7f37"},{"opportunity_id":"opp_fam_constellation_energy","rank":3,"total_score":0.48239999999999994,"family_id":"fam_constellation","family_name":"Constellation","category":"Energy","addressable_spend_usd":540000,"factors":[{"factor":"addressable_spend","score":0.108,"weight":0.3,"contribution":0.0324,"raw_value":540000,"meaning":"$540,000 of addressable spend — 11% of the $5,000,000 cap; a bigger pool scores higher","evidence":["spend_INV-3004"]},{"factor":"fragmentation","score":0,"weight":0.2,"contribution":0,"raw_value":1,"meaning":"spread across 1 supplier; a more even split scores higher (more consolidation upside)","evidence":["sup_constellation_energy"]},{"factor":"contract_leakage","score":1,"weight":0.25,"contribution":0.25,"raw_value":540000,"meaning":"100% of spend is off-contract or on an expired agreement","evidence":[]},{"factor":"sourcing_age","score":0.6666666666666666,"weight":0.15,"contribution":0.09999999999999999,"raw_value":844,"meaning":"last sourced 844 days ago","evidence":["1000000100"]},{"factor":"risk","score":1,"weight":0.1,"contribution":0.1,"raw_value":"high","meaning":"supply-risk band \"high\" (pilot uses a deterministic floor, not a live risk feed)","evidence":["risk:floor"]}],"savings":{"low_usd":16200,"high_usd":43200,"levers":["bring_off_contract_under_contract"]},"confidence":"high","needs_review":false,"review_reasons":[],"recommended_action":"Bring off-contract spend under an existing agreement","primary_lever":"bring_off_contract_under_contract","last_sourced":"2024-03-01","as_of":"2026-06-23","config_version":"2026-06-pilot-1","snapshot_hash":"dfe29f1ab5868b9662787a3d319589486e3181d8dadcd5bc693630491f2f7f37"},{"opportunity_id":"opp_fam_umbrella_marketing","rank":4,"total_score":0.4627530669654347,"family_id":"fam_umbrella","family_name":"Umbrella","category":"Marketing","addressable_spend_usd":1028000,"factors":[{"factor":"addressable_spend","score":0.2056,"weight":0.3,"contribution":0.06168,"raw_value":1028000,"meaning":"$1,028,000 of addressable spend — 21% of the $5,000,000 cap; a bigger pool scores higher","evidence":["spend_INV-1006","spend_INV-1007","spend_INV-1008"]},{"factor":"fragmentation","score":0.4649956850217263,"weight":0.2,"contribution":0.09299913700434526,"raw_value":2,"meaning":"spread across 2 suppliers; a more even split scores higher (more consolidation upside)","evidence":["sup_umbrella_us","sup_umbrella_eu"]},{"factor":"contract_leakage","score":0.632295719844358,"weight":0.25,"contribution":0.1580739299610895,"raw_value":650000,"meaning":"63% of spend is off-contract or on an expired agreement","evidence":[]},{"factor":"sourcing_age","score":1,"weight":0.15,"contribution":0.15,"raw_value":1634,"meaning":"last sourced 1634 days ago — past the 1095-day stale line, score maxed","evidence":["1000000030","1000000032"]},{"factor":"risk","score":0,"weight":0.1,"contribution":0,"raw_value":"low","meaning":"supply-risk band \"low\" (pilot uses a deterministic floor, not a live risk feed)","evidence":["risk:floor"]}],"savings":{"low_usd":51400,"high_usd":102800,"levers":["bring_off_contract_under_contract","consolidate_fragmented_spend","recompete_stale_category"]},"confidence":"high","needs_review":false,"review_reasons":[],"recommended_action":"Consolidate fragmented spend across the supplier family","primary_lever":"consolidate_fragmented_spend","last_sourced":"2022-01-01","as_of":"2026-06-23","config_version":"2026-06-pilot-1","snapshot_hash":"dfe29f1ab5868b9662787a3d319589486e3181d8dadcd5bc693630491f2f7f37"},{"opportunity_id":"opp_fam_grainger_mro","rank":5,"total_score":0.45307622891673516,"family_id":"fam_grainger","family_name":"Grainger","category":"MRO","addressable_spend_usd":874000,"factors":[{"factor":"addressable_spend","score":0.1748,"weight":0.3,"contribution":0.05244,"raw_value":874000,"meaning":"$874,000 of addressable spend — 17% of the $5,000,000 cap; a bigger pool scores higher","evidence":["spend_INV-2002","spend_INV-2003","spend_INV-2004"]},{"factor":"fragmentation","score":0.4665678722724631,"weight":0.2,"contribution":0.09331357445449262,"raw_value":2,"meaning":"spread across 2 suppliers; a more even split scores higher (more consolidation upside)","evidence":["sup_grainger_industrial","sup_grainger_eu"]},{"factor":"contract_leakage","score":0.6292906178489702,"weight":0.25,"contribution":0.15732265446224256,"raw_value":550000,"meaning":"63% of spend is off-contract or on an expired agreement","evidence":[]},{"factor":"sourcing_age","score":1,"weight":0.15,"contribution":0.15,"raw_value":2213,"meaning":"last sourced 2213 days ago — past the 1095-day stale line, score maxed","evidence":["1000000070"]},{"factor":"risk","score":0,"weight":0.1,"contribution":0,"raw_value":"low","meaning":"supply-risk band \"low\" (pilot uses a deterministic floor, not a live risk feed)","evidence":["risk:floor"]}],"savings":{"low_usd":43700,"high_usd":87400,"levers":["bring_off_contract_under_contract","consolidate_fragmented_spend","recompete_stale_category"]},"confidence":"high","needs_review":false,"review_reasons":[],"recommended_action":"Consolidate fragmented spend across the supplier family","primary_lever":"consolidate_fragmented_spend","last_sourced":"2020-06-01","as_of":"2026-06-23","config_version":"2026-06-pilot-1","snapshot_hash":"dfe29f1ab5868b9662787a3d319589486e3181d8dadcd5bc693630491f2f7f37"},{"opportunity_id":"opp_fam_stark_professional_services","rank":6,"total_score":0.29100000000000004,"family_id":"fam_stark","family_name":"Stark","category":"Professional Services","addressable_spend_usd":750000,"factors":[{"factor":"addressable_spend","score":0.15,"weight":0.3,"contribution":0.045,"raw_value":750000,"meaning":"$750,000 of addressable spend — 15% of the $5,000,000 cap; a bigger pool scores higher","evidence":["spend_INV-1009","spend_INV-1010"]},{"factor":"fragmentation","score":0.48,"weight":0.2,"contribution":0.096,"raw_value":2,"meaning":"spread across 2 suppliers; a more even split scores higher (more consolidation upside)","evidence":["sup_stark_industries","sup_stark_consulting"]},{"factor":"contract_leakage","score":0,"weight":0.25,"contribution":0,"raw_value":0,"meaning":"0% of spend is off-contract or on an expired agreement","evidence":[]},{"factor":"sourcing_age","score":1,"weight":0.15,"contribution":0.15,"raw_value":null,"meaning":"never competitively sourced — score maxed","evidence":[]},{"factor":"risk","score":0,"weight":0.1,"contribution":0,"raw_value":"low","meaning":"supply-risk band \"low\" (pilot uses a deterministic floor, not a live risk feed)","evidence":["risk:floor"]}],"savings":{"low_usd":37500,"high_usd":75000,"levers":["consolidate_fragmented_spend","recompete_stale_category"]},"confidence":"medium","needs_review":false,"review_reasons":[],"recommended_action":"Consolidate fragmented spend across the supplier family","primary_lever":"consolidate_fragmented_spend","last_sourced":null,"as_of":"2026-06-23","config_version":"2026-06-pilot-1","snapshot_hash":"dfe29f1ab5868b9662787a3d319589486e3181d8dadcd5bc693630491f2f7f37"},{"opportunity_id":"opp_fam_hertz_travel","rank":7,"total_score":0.26080000000000003,"family_id":"fam_hertz","family_name":"Hertz","category":"Travel","addressable_spend_usd":180000,"factors":[{"factor":"addressable_spend","score":0.036,"weight":0.3,"contribution":0.010799999999999999,"raw_value":180000,"meaning":"$180,000 of addressable spend — 4% of the $5,000,000 cap; a bigger pool scores higher","evidence":["spend_INV-2001"]},{"factor":"fragmentation","score":0,"weight":0.2,"contribution":0,"raw_value":1,"meaning":"spread across 1 supplier; a more even split scores higher (more consolidation upside)","evidence":["sup_hertz_global"]},{"factor":"contract_leakage","score":0,"weight":0.25,"contribution":0,"raw_value":0,"meaning":"0% of spend is off-contract or on an expired agreement","evidence":[]},{"factor":"sourcing_age","score":1,"weight":0.15,"contribution":0.15,"raw_value":null,"meaning":"never competitively sourced — score maxed","evidence":[]},{"factor":"risk","score":1,"weight":0.1,"contribution":0.1,"raw_value":"high","meaning":"supply-risk band \"high\" (pilot uses a deterministic floor, not a live risk feed)","evidence":["risk:floor"]}],"savings":{"low_usd":7200,"high_usd":18000,"levers":["recompete_stale_category"]},"confidence":"medium","needs_review":false,"review_reasons":[],"recommended_action":"Re-compete this category — sourcing is stale","primary_lever":"recompete_stale_category","last_sourced":null,"as_of":"2026-06-23","config_version":"2026-06-pilot-1","snapshot_hash":"dfe29f1ab5868b9662787a3d319589486e3181d8dadcd5bc693630491f2f7f37"},{"opportunity_id":"opp_fam_enterprise_fleet","rank":8,"total_score":0.25136411526207064,"family_id":"fam_enterprise","family_name":"Enterprise","category":"Fleet","addressable_spend_usd":405600,"factors":[{"factor":"addressable_spend","score":0.08112,"weight":0.3,"contribution":0.024336,"raw_value":405600,"meaning":"$405,600 of addressable spend — 8% of the $5,000,000 cap; a bigger pool scores higher","evidence":["spend_INV-3005","spend_INV-3006"]},{"factor":"fragmentation","score":0.38514057631035326,"weight":0.2,"contribution":0.07702811526207065,"raw_value":2,"meaning":"spread across 2 suppliers; a more even split scores higher (more consolidation upside)","evidence":["sup_enterprise_fleet_us","sup_enterprise_apac"]},{"factor":"contract_leakage","score":0,"weight":0.25,"contribution":0,"raw_value":0,"meaning":"0% of spend is off-contract or on an expired agreement","evidence":[]},{"factor":"sourcing_age","score":1,"weight":0.15,"contribution":0.15,"raw_value":null,"meaning":"never competitively sourced — score maxed","evidence":[]},{"factor":"risk","score":0,"weight":0.1,"contribution":0,"raw_value":"low","meaning":"supply-risk band \"low\" (pilot uses a deterministic floor, not a live risk feed)","evidence":["risk:floor"]}],"savings":{"low_usd":20280,"high_usd":40560,"levers":["consolidate_fragmented_spend","recompete_stale_category"]},"confidence":"medium","needs_review":false,"review_reasons":[],"recommended_action":"Consolidate fragmented spend across the supplier family","primary_lever":"consolidate_fragmented_spend","last_sourced":null,"as_of":"2026-06-23","config_version":"2026-06-pilot-1","snapshot_hash":"dfe29f1ab5868b9662787a3d319589486e3181d8dadcd5bc693630491f2f7f37"},{"opportunity_id":"opp_fam_initech_facilities","rank":9,"total_score":0.21499999999999997,"family_id":"fam_initech","family_name":"Initech","category":"Facilities","addressable_spend_usd":250000,"factors":[{"factor":"addressable_spend","score":0.05,"weight":0.3,"contribution":0.015,"raw_value":250000,"meaning":"$250,000 of addressable spend — 5% of the $5,000,000 cap; a bigger pool scores higher","evidence":["spend_INV-1005"]},{"factor":"fragmentation","score":0,"weight":0.2,"contribution":0,"raw_value":1,"meaning":"spread across 1 supplier; a more even split scores higher (more consolidation upside)","evidence":["sup_initech"]},{"factor":"contract_leakage","score":0,"weight":0.25,"contribution":0,"raw_value":0,"meaning":"0% of spend is off-contract or on an expired agreement","evidence":[]},{"factor":"sourcing_age","score":1,"weight":0.15,"contribution":0.15,"raw_value":null,"meaning":"never competitively sourced — score maxed","evidence":[]},{"factor":"risk","score":0.5,"weight":0.1,"contribution":0.05,"raw_value":"medium","meaning":"supply-risk band \"medium\" (pilot uses a deterministic floor, not a live risk feed)","evidence":["risk:floor"]}],"savings":{"low_usd":10000,"high_usd":25000,"levers":["recompete_stale_category"]},"confidence":"medium","needs_review":false,"review_reasons":[],"recommended_action":"Re-compete this category — sourcing is stale","primary_lever":"recompete_stale_category","last_sourced":null,"as_of":"2026-06-23","config_version":"2026-06-pilot-1","snapshot_hash":"dfe29f1ab5868b9662787a3d319589486e3181d8dadcd5bc693630491f2f7f37"},{"opportunity_id":"opp_fam_verizon_telecom","rank":10,"total_score":0.2132,"family_id":"fam_verizon","family_name":"Verizon","category":"Telecom","addressable_spend_usd":220000,"factors":[{"factor":"addressable_spend","score":0.044,"weight":0.3,"contribution":0.013199999999999998,"raw_value":220000,"meaning":"$220,000 of addressable spend — 4% of the $5,000,000 cap; a bigger pool scores higher","evidence":["spend_INV-3001"]},{"factor":"fragmentation","score":0,"weight":0.2,"contribution":0,"raw_value":1,"meaning":"spread across 1 supplier; a more even split scores higher (more consolidation upside)","evidence":["sup_verizon_business"]},{"factor":"contract_leakage","score":0,"weight":0.25,"contribution":0,"raw_value":0,"meaning":"0% of spend is off-contract or on an expired agreement","evidence":[]},{"factor":"sourcing_age","score":1,"weight":0.15,"contribution":0.15,"raw_value":1269,"meaning":"last sourced 1269 days ago — past the 1095-day stale line, score maxed","evidence":["1000000080"]},{"factor":"risk","score":0.5,"weight":0.1,"contribution":0.05,"raw_value":"medium","meaning":"supply-risk band \"medium\" (pilot uses a deterministic floor, not a live risk feed)","evidence":["risk:floor"]}],"savings":{"low_usd":8800,"high_usd":22000,"levers":["recompete_stale_category"]},"confidence":"high","needs_review":false,"review_reasons":[],"recommended_action":"Re-compete this category — sourcing is stale","primary_lever":"recompete_stale_category","last_sourced":"2023-01-01","as_of":"2026-06-23","config_version":"2026-06-pilot-1","snapshot_hash":"dfe29f1ab5868b9662787a3d319589486e3181d8dadcd5bc693630491f2f7f37"},{"opportunity_id":"opp_fam_globex_logistics","rank":11,"total_score":0.13047999999999998,"family_id":"fam_globex","family_name":"Globex","category":"Logistics","addressable_spend_usd":508000,"factors":[{"factor":"addressable_spend","score":0.1016,"weight":0.3,"contribution":0.030479999999999997,"raw_value":508000,"meaning":"$508,000 of addressable spend — 10% of the $5,000,000 cap; a bigger pool scores higher","evidence":["spend_INV-1004"]},{"factor":"fragmentation","score":0,"weight":0.2,"contribution":0,"raw_value":1,"meaning":"spread across 1 supplier; a more even split scores higher (more consolidation upside)","evidence":["sup_globex_logistics"]},{"factor":"contract_leakage","score":0,"weight":0.25,"contribution":0,"raw_value":0,"meaning":"0% of spend is off-contract or on an expired agreement","evidence":[]},{"factor":"sourcing_age","score":0.3333333333333333,"weight":0.15,"contribution":0.049999999999999996,"raw_value":387,"meaning":"last sourced 387 days ago","evidence":["1000000010"]},{"factor":"risk","score":0.5,"weight":0.1,"contribution":0.05,"raw_value":"medium","meaning":"supply-risk band \"medium\" (pilot uses a deterministic floor, not a live risk feed)","evidence":["risk:floor"]}],"savings":{"low_usd":0,"high_usd":0,"levers":[]},"confidence":"high","needs_review":false,"review_reasons":[],"recommended_action":"Monitor — covered, consolidated, and recently sourced; no material lever","primary_lever":null,"last_sourced":"2025-06-01","as_of":"2026-06-23","config_version":"2026-06-pilot-1","snapshot_hash":"dfe29f1ab5868b9662787a3d319589486e3181d8dadcd5bc693630491f2f7f37"},{"opportunity_id":"opp_fam_flexstaff_contingent_labor","rank":12,"total_score":0.118,"family_id":"fam_flexstaff","family_name":"Flexstaff","category":"Contingent Labor","addressable_spend_usd":300000,"factors":[{"factor":"addressable_spend","score":0.06,"weight":0.3,"contribution":0.018,"raw_value":300000,"meaning":"$300,000 of addressable spend — 6% of the $5,000,000 cap; a bigger pool scores higher","evidence":["spend_INV-4001"]},{"factor":"fragmentation","score":0,"weight":0.2,"contribution":0,"raw_value":1,"meaning":"spread across 1 supplier; a more even split scores higher (more consolidation upside)","evidence":["sup_flexstaff"]},{"factor":"contract_leakage","score":0,"weight":0.25,"contribution":0,"raw_value":0,"meaning":"0% of spend is off-contract or on an expired agreement","evidence":[]},{"factor":"sourcing_age","score":0.6666666666666666,"weight":0.15,"contribution":0.09999999999999999,"raw_value":752,"meaning":"last sourced 752 days ago","evidence":["1000000120"]},{"factor":"risk","score":0,"weight":0.1,"contribution":0,"raw_value":"low","meaning":"supply-risk band \"low\" (pilot uses a deterministic floor, not a live risk feed)","evidence":["risk:floor"]}],"savings":{"low_usd":0,"high_usd":0,"levers":[]},"confidence":"needs_review","needs_review":true,"review_reasons":["thin_spend_coverage"],"recommended_action":"Monitor — covered, consolidated, and recently sourced; no material lever","primary_lever":null,"last_sourced":"2024-06-01","as_of":"2026-06-23","config_version":"2026-06-pilot-1","snapshot_hash":"dfe29f1ab5868b9662787a3d319589486e3181d8dadcd5bc693630491f2f7f37"}]}