Workforce Cost & Budget Variance Analysis

Helix Systems Inc. · YTD 2024 · Updated Dec 15, 2024

Workforce cost tracking $1.8M over approved budget

Engineering dept +$1.2M driven by above-midpoint offers; Contractor spend +$640K post hiring freeze

YTD Workforce Cost
$47.2M
+4.0% vs $45.4M plan
Labor Efficiency Ratio
38.2%
+1.8pp vs 36.4% target
Benefits Load Factor
28.4%
-0.6pp vs 29.0% plan
Contractor % Total Cost
14.2%
+3.8pp vs 10.4% plan
Comp Band Compliance
82.1%
-5.9pp vs 88% target
Headcount Variance
+28
1,240 / 1,212 act / plan

YTD Workforce Cost Variance Waterfall

Planned Budget
Overrun
Savings
Actual Total

Planned vs. Actual Headcount by Quarter

Contractor & Contingent Spend Trend

Monthly Workforce Cost Composition

Salary Run-Rate Variance by Department

Compensation Band Compliance by Job Family

Engineering 78.2%
Product 85.4%
Sales 88.9%
Marketing 82.1%
G&A 90.3%

Span of Control by Org Layer

Merit Increase Concentration (Gini)

0.42
Gini Index
Moderate concentration
Top 20%: 58% of pool
Bottom 50%: 18% of pool

Department Cost Variance Detail

Department Planned HC Actual HC Planned Cost Actual Cost Variance Variance %
Engineering 482 496 $18.2M $19.4M +$1.2M +6.6%
Sales 318 324 $11.4M $12.1M +$700K +6.1%
Product 124 118 $5.8M $5.6M -$200K -3.4%
Marketing 92 96 $3.2M $3.4M +$200K +6.3%
Customer Success 128 134 $4.1M $4.3M +$200K +4.9%
G&A 68 72 $2.7M $2.4M -$300K -11.1%
Total 1,212 1,240 $45.4M $47.2M +$1.8M +4.0%

Position Vacancy Productivity Cost by Department

Estimated weekly productivity loss per open req × avg time-to-fill × current open positions

Time-to-Fill by Urgency

Critical (P0) 28 days
vs 30d target
High (P1) 42 days
vs 45d target
Medium (P2) 58 days
vs 60d target
Low (P3) 71 days
vs 90d target

Annualized Voluntary Attrition Cost by Department

Total Attrition Cost
$4.2M
Avg Cost per Departure
$82K
YTD Voluntary Attrition
11.8%