Payroll Forecasting & Scenario Planning

Clarion Software Group • 920 Employees • $91M ARR • Series D • Updated: Dec 21, 2024

12M Payroll (Base)

$31.4M

+$1.2M vs Budget (+3.9%)

Upside Scenario

$33.8M

+12.0% over Budget

Downside (Freeze)

$28.6M

-5.3% under Budget

Headcount Exec. Rate

78%

32 of 41 offers accepted

Merit Cycle Cost

$1.08M

3.8% avg increase

Benefits Escalation

+7.2%

Carrier proposal (Jan 1)

12-Month Payroll Cash Obligation — Three Scenarios vs. Board Budget

Payroll Cost Bridge: Current → 12M Projected (Base)

Merit Increase Impact by Department

13-Week Rolling Cash Flow

Headcount Plan Execution

Attrition-Adjusted Savings

Department-Level Payroll Forecast vs. Budget (12-Month, Base Scenario)

Department	Current HC	Projected HC	12M Payroll	Budget	Variance	Merit Impact	Plan Status
Engineering	320	334	$12,840k	$12,200k	+$640k (+5.2%)	$388k	68% Exec
Sales	185	203	$7,320k	$7,100k	+$220k (+3.1%)	$198k	91% Exec
Product	58	64	$2,890k	$2,750k	+$140k (+5.1%)	$92k	75% Exec
Customer Success	112	118	$3,640k	$3,580k	+$60k (+1.7%)	$110k	83% Exec
Marketing	42	45	$1,820k	$1,780k	+$40k (+2.2%)	$58k	67% Exec
Finance & Legal	38	41	$1,680k	$1,600k	+$80k (+5.0%)	$54k	100% Exec
People & Ops	48	50	$1,210k	$1,190k	+$20k (+1.7%)	$42k	100% Exec
Total	803	855	$31,400k	$30,200k	+$1,200k (+3.9%)	$1,080k	—

Open Requisition Start-Date Risk Map

Revenue per Payroll Dollar Trend

Scenario Comparison Scorecard (Six Dimensions, Normalized 0-100)