Spend Analysis — Category Intelligence & Tail Spend Consolidation

Hartwell Industrial Group | FY24 Q4 | $284.6M Controllable Spend across 8 Strategic Categories

Total Controllable Spend

$284.6M

↓ 4.2% YoY

Tail Spend Ratio

18.3%

↑ 1.1% vs Target

Category Conc. Index (HHI)

1,842

↓ 124 QoQ

Maverick Spend Rate

7.4%

↑ 0.6% MoM

Savings Capture Rate

82.1%

↑ 3.2% vs Q3

Spend Under Mgmt %

74.6%

↑ 2.8% QoQ

Spend by Category Treemap — Q4 FY24

MRO

$78.4M

27.5% | 142 vendors

Logistics

$52.1M

18.3%

IT Hardware

$34.2M

12.0%

Prof Services

$28.9M

10.2%

Facilities

$31.2M

11.0% | 312 tail

Packaging

$24.6M

8.6%

Raw Materials

$22.8M

8.0%

Marketing

$12.4M

4.4%

⚠ Alert: Facilities category shows $8.7M across 312 vendors each <$50K — immediate consolidation opportunity

Tail Spend Trend by Quarter

Tail vs. Strategic Distribution

Maverick Spend by Dept

PO Cycle Time by Category

Price Variance Index

Vendor Spend Pareto — Top 15 Suppliers

Rank	Vendor Name	Category	Spend ($M)	% of Total	Cumulative %	HHI Contrib	Contract Status
1	Grainger	MRO	$18.4	6.5%	6.5%	420	Active
2	XPO Logistics	Logistics	$16.2	5.7%	12.2%	324	Active
3	Dell Technologies	IT Hardware	$14.8	5.2%	17.4%	270	Active
4	Accenture	Prof Services	$12.1	4.3%	21.7%	182	Expiring Q1
5	CBRE	Facilities	$11.3	4.0%	25.7%	158	Active
6	Fastenal	MRO	$10.6	3.7%	29.4%	138	Active
7	UPS	Logistics	$9.8	3.4%	32.8%	118	Active
8	Sealed Air	Packaging	$9.2	3.2%	36.0%	104	Active
9	CDW	IT Hardware	$8.4	3.0%	39.0%	88	Active
10	Deloitte	Prof Services	$7.9	2.8%	41.8%	77	Active
11	Weyerhaeuser	Raw Materials	$7.6	2.7%	44.5%	71	Active
12	MSC Industrial	MRO	$7.1	2.5%	47.0%	62	Active
13	International Paper	Packaging	$6.8	2.4%	49.4%	57	Active
14	JLL	Facilities	$6.3	2.2%	51.6%	49	Active
15	Omnicom Group	Marketing	$5.9	2.1%	53.7%	43	Expiring Q2

Top 15 vendors represent 53.7% of spend | Remaining 721 vendors = 46.3%

Realized vs. Negotiated Savings by Category

Spend Forecast Accuracy by Category

Vendor Rationalization Progress

Supplier Diversity Spend Trend

Data Freshness

ERP Sync: Dec 18, 2024 06:42 EST

Contract Data: Dec 17, 2024 23:15 EST

TCO Reduction Target

$42.0M

FY24 Goal | YTD: $34.2M (81.4%)

Benchmark Position

Tail Spend: +3.1% vs Peer Avg

SUM %: +8.4% vs Peer Avg