Capital Expenditure Portfolio Oversight

Hartwell Industrial Group · FY2024 · $142.8M Active Portfolio

Last Updated

Dec 15, 2024 14:30

Total Portfolio Budget

$142.8M

Approved Envelope

Actual Spend YTD

$87.4M

● 61.2% utilized

Forecast at Completion

$151.2M

▲ +$8.4M variance

Portfolio CPI

0.94

● Below target 1.00

Contingency Burn Rate

78%

● vs 62% complete

At-Risk Projects

4 / 17

● CPI < 0.90

Project Performance Matrix — CPI × SPI

On Track (CPI>0.95, SPI>0.95)

Watch (CPI 0.90–0.95)

At Risk (CPI<0.90)

Committed vs Approved Budget by Phase

Contingency Burn vs Schedule Progress

Change Order Volume & Approval Rate (Last 90 Days)

Forecast at Completion Trend — Top 5 Projects

Active Project Portfolio

Project	Budget	Actual	FAC	Variance	CPI	SPI	% Complete	Status
FORGE Facility	$38.0M	$27.8M	$45.2M	+$7.2M	0.84	0.91	73%	At Risk
ERP Implementation	$22.0M	$18.4M	$22.6M	+$0.6M	0.94	0.98	84%	Watch
Warehouse Expansion	$14.5M	$8.2M	$14.1M	-$0.4M	1.03	1.01	58%	On Track
Equipment Modernization	$12.8M	$7.1M	$13.2M	+$0.4M	0.97	0.92	55%	On Track
Quality Lab Build-out	$9.2M	$6.8M	$10.4M	+$1.2M	0.88	0.94	74%	At Risk
IT Infrastructure Upgrade	$8.4M	$5.2M	$8.6M	+$0.2M	0.98	0.99	62%	On Track
Sustainability Initiative	$6.9M	$3.1M	$7.1M	+$0.2M	0.94	0.96	45%	Watch
Robotics Integration	$5.8M	$4.3M	$6.6M	+$0.8M	0.88	0.89	74%	At Risk

Operations

$64.2M

of $68.0M budget

94% utilized

Technology

$27.8M

of $30.8M budget

90% utilized

Facilities

$38.4M

of $44.0M budget

87% utilized

Vendor Invoice vs Milestone Payment Adherence

Portfolio Reforecast Accuracy (Bias Score)

Q1 2024 -2.4%

Q2 2024 +3.8%

Q3 2024 +5.9%

Q4 2024 (Projected) +4.2%

Bias score indicates systematic over- or under-estimation. Positive bias = underestimating costs.

Data as of December 15, 2024 · Hartwell Industrial Group CFO Office · Confidential