CapEx Portfolio & Investment FP&A Tracking

Horizon Infrastructure Group • $68M Portfolio Authorization

Goal: Deploy ≥85% strategic capex with portfolio ROIC above 14%

As of
June 2024
Portfolio ROIC
15.2%
+1.2% vs Hurdle (14%)
Deployed % of Auth.
71%
-14% vs Target (85%)
Cost Performance Index
0.91
Weighted avg, 3 critical
EAC vs Budget
+$4.1M
6.0% overrun
Contingency Burn Rate
68%
Of allocated reserves
Inactive Auth. Budget
$8.2M
4 paused projects

Project Performance: CPI vs SPI

Strategic
Maintenance
■ Red border = CPI <0.9

EAC Variance Drivers

Portfolio Contingency Burn

Allocated: $12.0M
Burned: $8.16M (68%)

Strategic vs. Maintenance CapEx Mix

Deployment Pace vs. Budget Timeline

Project Portfolio (24 Projects)

Project Type Budget EAC Variance CPI SPI Status
ERP Modernization Strategic $12.5M $15.7M +$3.2M 0.79 0.88 Critical
Data Center Expansion Strategic $8.2M $8.9M +$0.7M 0.86 0.92 At Risk
Network Infrastructure Maintenance $5.8M $5.9M +$0.1M 0.98 1.02 On Track
Security Platform Upgrade Strategic $4.3M $4.9M +$0.6M 0.88 0.95 At Risk
Cloud Migration Phase 2 Strategic $6.9M $6.8M -$0.1M 1.01 1.05 On Track
Building HVAC Replacement Maintenance $3.1M $3.2M +$0.1M 0.97 1.01 On Track
Manufacturing Automation Strategic $9.7M $9.8M +$0.1M 0.99 0.96 On Track
Fleet Electrification Strategic $7.6M $7.5M -$0.1M 1.01 0.98 On Track
+16 additional projects…