Labor Cost Projections: Essential Tools for Finance Directors

If labor costs represent 60–75% of your public-sector budget, and you're making workforce decisions based on spreadsheets updated monthly by hand, you're running blind. Most finance directors at cities, school districts, fire departments, and transit agencies lack the tools to answer a simple question: "What will payroll actually cost in three years if we agree to this contract?"

The result: budgets that miss by 5–15%, labor agreements negotiated without clear cost visibility, and board members blindsided by mid-year reforecasts. This article walks you through the labor cost projection tools, methodologies, and frameworks that will let you model any scenario in minutes—and defend your numbers with transparency and precision.

Why Labor Cost Projections Matter More Than Ever

Labor cost forecasting isn't optional. It's the foundation of every budget, every labor negotiation, and every strategic plan worth presenting to your board or council.

Here's what's changed: Benefits premiums are rising 5–8% annually, pension contribution rates are climbing in Pennsylvania, Illinois, Ohio, and California, turnover patterns are volatile, and every new collective bargaining agreement locks you into multi-year obligations. A 3% salary schedule increase sounds modest—until you model it against step advancement, lane movement, benefits trend, and staffing changes. That 3% quickly becomes 6–7% total payroll growth.

Finance directors who build rigorous labor cost models gain three immediate advantages:

1. Negotiation clarity: You know exactly what each 0.5% salary increase costs over the contract term, down to the dollar. No surprises.
2. Budget realism: Multi-year projections reveal when pension contributions or health insurance will overwhelm your budget, forcing strategic decisions early.
3. Board confidence: Presenting a transparent, auditable cost model replaces guesswork with defensible data.

Public-sector finance leaders manage constrained budgets. Labor cost transparency isn't a nice-to-have—it's a fiscal responsibility.

The Five Core Cost Drivers Every Projection Must Model

Every year-over-year change in payroll comes from exactly five sources. If you understand and isolate each one, you can build accurate projections and evaluate scenarios systematically.

1. Step Advancement (Automatic & Guaranteed)

Step advancement is the automatic movement down the salary schedule based on years of service. It happens every year—even when the schedule is frozen—and it typically costs 1.5–3.0% of total payroll annually.

Why it matters: A teacher in Step 5 on a BA lane earning $52,000 automatically moves to Step 6 the next year, earning perhaps $54,200. Multiply that across your entire workforce, and step advancement alone adds $200,000–$500,000+ annually to a 200-person school district payroll.

How to calculate it:

Step Advancement Cost = Sum of (Current Salary × Step Increase %)
for all employees moving to the next step

For example, if 180 teachers average a 3.8% step increase each (moving from their current step to the next), and their aggregate payroll is $12 million:

Step Advancement = $12,000,000 × 0.038 = $456,000 (Year 1)

This cost is built-in and non-negotiable. Boards often overlook it when reviewing a "freeze" contract, then wonder why payroll still grew.

2. Schedule Increase (Negotiated Growth)

A schedule increase means the entire salary grid moves up—every cell increases. A 2% schedule increase means every salary on every step in every lane grows by 2%, even before step advancement is applied.

Why it matters: This is what unions negotiate for, and it's what boards trade off during negotiations. A 2.5% schedule increase on a $12 million payroll costs $300,000 in Year 1 alone—$900,000 cumulatively over 3 years (without compounding).

How to calculate it:

Schedule Increase Cost (Year 1) = Total Payroll × Schedule % Increase
Cumulative Cost (3-year contract) = Year 1 + Year 2 (compounded) + Year 3 (compounded)

Using our $12M example with a 2.5% annual schedule increase:

Year 1: $12,000,000 × 0.025 = $300,000
Year 2: $12,300,000 × 0.025 = $307,500
Year 3: $12,607,500 × 0.025 = $315,188
Total 3-Year Cost: $922,688

3. Lane Movement (Probabilistic Growth)

Lane movement occurs when teachers complete additional graduate hours and move from, say, BA to BA+15, or MA to MA+30. It's not automatic—it requires action by the employee—but it happens at predictable rates.

Empirically, 5–8% of eligible teachers move one lane per year. On a mixed staff of BA and MA teachers, this typically adds 0.5–1.5% to payroll cost annually.

How to calculate it:

Lane Movement Cost ≈ (% of eligible staff moving lanes) × (Avg. lane difference in salary)

If you have 120 BA teachers at an average salary of $55,000, and 8% move to BA+15 (earning $2,000 more annually):

Lane Movement = (120 × 0.08) × $2,000 = $19,200 per year

Over a 3-year contract with 5% annual movement, this can exceed $60,000 cumulatively—often overlooked in baseline projections.

4. Benefits Trend (5–8% Annual Increase)

Health insurance premiums, dental, vision, life insurance, and disability coverage all increase annually. Medical premiums typically climb 5–8% per year, driven by national healthcare inflation.

For a finance director, benefits are the second-largest labor cost driver after base salary. They account for 20–28% of total compensation cost.

How to calculate it:

Year 1 Benefits Cost = Current Benefits Payroll × (1 + Trend %)
Example: $3,000,000 × 1.06 = $3,180,000
Year 2: $3,180,000 × 1.06 = $3,370,800

Most public-sector employers cover 85% of Single, 80% of EE+Spouse, and 75% of Family premiums. When premiums rise faster than salary increases, the employer's cost per employee climbs in real dollars, even if the percentage share stays constant.

Employer Cost Multiplier Context: For every dollar of base salary, a public-sector employer typically spends an additional $0.28–$0.45 on health insurance, retirement contributions (pension + Social Security or equivalent), and other benefits. This is your cost multiplier: ranging from 1.28x to 1.45x depending on your state's pension system.

In Illinois (TRS, SS-exempt states), the typical multiplier is 1.32x (9.0% employee pension contribution often paid by district + 0.58% district pension rate + 1.45% Medicare + health insurance ~18% of base salary).

In Pennsylvania (PSERS, SS-paying state), the multiplier exceeds 1.50x ($35.26% employer PSERS contribution + 6.2% Social Security + 1.45% Medicare + health insurance ~18%).

5. Headcount Changes (Hiring, Turnover, Retirements)

Headcount changes—hiring new staff, retiring experienced staff, attrition—directly affect total payroll. This is where turnover dynamics reveal hidden cost savings.

The turnover paradox: When a Step 20/MA+30 teacher earning $95,000 retires and is replaced by a Step 1/BA teacher earning $42,000, you save $53,000 immediately. This single replacement typically offsets 30–50% of the step advancement costs across the entire staff.

Turnover rates vary dramatically by career stage:

• Steps 1–3 (early career): 12–18% annual turnover
• Steps 4–8 (mid-early): 6–10%
• Steps 9–15 (mid-career): 3–5%
• Steps 16+: 2–4% (stable) and 8–15% (pre-retirement spike)

For a 200-person school staff with blended 8% turnover, you'll have ~16 departures per year. If the average replacement saves $18,000 (accounting for experience mix), that's $288,000 in net payroll savings annually—a figure most finance directors never isolate.

Building Your Labor Cost Projection Model

A robust projection model requires clear inputs, transparent formulas, and scenario flexibility. Here's the framework CollBar uses with clients:

Step 1: Establish Your Baseline

Start with your current roster snapshot: each employee's name, current salary, step, lane (or experience tier), benefits election (Single/Family), and contract day count.

From this, calculate your current-year total payroll and total benefits cost. This becomes your baseline denominator for all percentage-based calculations.

Example Baseline (Small School District, 200 Teachers):

• Total Salary Payroll: $12,000,000
• Health Insurance (employer share): $2,100,000 (17.5% of salary)
• Retirement Contributions (district-paid EE + ER): $1,560,000 (13% of salary)
• Medicare: $174,000 (1.45% of salary)
• Payroll Taxes (FUTA, SUTA where applicable): $48,000
• Total Compensation Cost: $15,882,000
• Cost Multiplier: 1.324x ($15,882,000 ÷ $12,000,000)

Step 2: Define Your Assumptions

For each projection scenario, document your assumptions in a centralized worksheet:

Step 3: Calculate Year-by-Year Incremental Cost

For each scenario and each year, calculate the total incremental cost (the year-over-year change from the prior year).

Incremental Cost Formula:

Year N Incremental Cost = 
  (Step Advancement Cost) 
  + (Schedule Increase Cost) 
  + (Lane Movement Cost) 
  + (Benefits Trend Cost) 
  + (Headcount Impact)

Example: Year 1 of Scenario A (2.0% Schedule Increase):

Step Advancement:        $456,000 (1.5% step avg × $12M base)
Schedule Increase:       $300,000 (2.0% × $15M comp cost)
Lane Movement:           $19,200  (0.5% of eligible staff)
Benefits Trend:          $126,000 (6.0% trend × $2.1M current HI)
Headcount Savings:       -$288,000 (16 turnover × avg $18K savings)
─────────────────────────────────
Year 1 Incremental:      $613,200

Year 2 and Year 3 are calculated the same way, but using the prior year's ending payroll (which now includes the prior year's increases and adjustments) as the new baseline.

Step 4: Project Forward 3–5 Years

Most labor contracts span 3–4 years. Project forward through the full term, showing:

• Total payroll for each year
• Benefits cost for each year
• Total compensation cost for each year
• Cumulative incremental cost (total additional spending over the baseline)

This is where you'll see the true multi-year impact. A 2.0% annual schedule increase that seems modest in Year 1 ($300K) balloons to $922K cumulative over 3 years when compounded and applied to a growing base.

Step 5: Run Sensitivity & Scenario Analysis

Build an input worksheet where changing a single assumption (schedule %, benefits trend, headcount) instantly recalculates all years. This is your negotiation tool.

Quick-Change Inputs:

• What if schedule increase is 1.5% instead of 2.0%? (Savings: ~$230K over 3 years)
• What if health insurance premium sharing shifts to 90/85/80 from 85/80/75? (Savings: ~$150K-$200K annually)
• What if we reduce contract days from 180 to 178? (Savings: $140K-$200K, depending on salary)

This flexibility lets you model real, at-the-table trade-offs in real time.

Essential Tools & Technology for Labor Cost Projections

Hand-built spreadsheets work—but they're error-prone, inflexible, and non-transparent. The best finance directors use layered tools:

Tier 1: Spreadsheet Foundation

A master Excel or Google Sheets model with locked formula cells, clearly labeled assumptions, and color-coded inputs vs. calculated outputs. This should be your single source of truth.

Key structure:

• Assumptions Tab: All inputs (schedule %, trend %, headcount) live here
• Roster Tab: Current salary data (optionally anonymized as position/step/lane)
• Calculations Tab: Year-by-year payroll, benefits, and incremental cost
• Summary Tab: One-page executive view for board presentation

Tier 2: Scenario Planning & Modeling

Software that integrates labor costing—either a dedicated labor cost model or a broader financial forecasting platform—removes manual copy-paste errors and enables rapid what-if analysis.

CollBar's labor costing service, available at /services/labor-costing, is specifically designed for this: input your roster and contract terms, and the system automatically projects payroll forward 3–5 years with auditable formulas and instant scenario comparison.

Tier 3: Strategic Benchmarking

Before you negotiate, know what comparable agencies pay. CollBar's benchmarking service provides peer-comparison data by job class, experience tier, and region—showing you whether your salary schedule is leading, market-based, or lagging peers.

Benchmarking is critical because wage comparability is a universal negotiation topic. Union negotiators will cite comparable districts; you need defensible data to respond.

Avoiding Common Projection Mistakes

Even experienced finance directors fall into traps. Here's what to avoid:

Mistake 1: Forgetting Step Advancement in a "Freeze" Scenario

Many boards present a scenario as "salary schedule freeze—no increase." What they mean is the grid doesn't grow. But employees still advance one step per year automatically (unless the CBA suspends step advancement, which is rare).

Correct framing: Status quo includes step advancement (YES) + schedule increase (0%) + benefits trend (YES). This scenario still has 3–4% payroll growth even with zero negotiated increases.

Mistake 2: Static Headcount Assumptions

Assuming flat headcount year-over-year misses turnover dynamics. If you consistently lose experienced staff and replace them with new hires, your blended average salary actually declines—a natural cost brake that offsets 20–40% of step and schedule increases.

Correct approach: Model realistic turnover by career stage (8% Steps 1–3, 4% Steps 4–15, 12% pre-retirement). This is where your $288K savings comes from.

Mistake 3: Separating Salary from Benefits Trend

Salary projections and benefits trend are not independent. Benefits premium increases (6–8% annually) often outpace salary increases (2–3% negotiated). When this happens, total compensation cost grows faster than base salary, compressing your cost multiplier from 1.35x to 1.42x over time.

Correct approach: Always model salary and benefits together. Present total compensation cost, not salary alone.

Mistake 4: Ignoring Pension Contribution Volatility

In Pennsylvania (PSERS), Ohio (STRS), and California (CalSTRS), employer pension contributions fluctuate based on actuarial valuations. Pennsylvania jumped from 28% to 35%+ employer PSERS over the past decade. Ohio continues climbing.

Correct approach: Use the current published rate for the baseline year, but note in your assumptions where volatility risk exists. Flag it to your CFO and board.

Mistake 5: Conflating Cost Multiplier with "True Cost"

Many finance directors say, "Every $1 of salary costs us $1.35 total," then use that multiplier to multiply gross salary increases. This is directionally correct but mechanically wrong.

Correct approach: Calculate incremental cost by cost driver. A 2% salary schedule increase costs 2% × total salary base + benefits trend cost on that base salary. Don't just multiply the salary increase by the full cost multiplier; benefits don't increase proportionally with salary.

State-Specific Considerations for Your Projections

Pension contribution rates and Social Security obligations vary dramatically by state and directly affect your cost multiplier. Know your baseline:

If you're in a high-rate state like Pennsylvania or California, every percentage point of salary increase costs more because it's applied to a higher pension contribution base. This context is essential for board presentations: "A 3% salary increase costs us 4.2% of our total comp budget because our pension system adds 35%+ to the employer cost basis."

Frequently Asked Questions

What headcount should I assume for next year's projection?

Use your current roster, subtract realistic departures (based on your historical turnover rate by career stage), and add realistic hires. Most public-sector entities hire at Step 1 with a BA or entry-level credential. For a 200-person school district with 8% average turnover, assume 16 departures and 16 new hires at Step 1, BA, entry benefits.

If you know specific retirements are planned, adjust upward; if you're in a hiring freeze, reduce new hires. But default to historical pattern when specifics aren't known.

How do I handle salary increases mid-contract if the CBA allows for "cost-of-living adjustments" (COLAs)?

COLAs are typically tied to the Consumer Price Index (CPI-U) and calculated annually. Project them as a variable input: if CPI-U is currently 3.2% and your CBA includes a COLA floor of 2.0% / ceiling of 4.0%, use 3.2% as your assumption.

Sensitivity-test the model at 2.0%, 3.2%, and 4.0% to show the board the range of outcomes.

Should I use gross salary or take-home salary for pension contribution calculations?

Always use gross (pre-tax) salary. Pension contributions (both employee and employer) are calculated on gross pay. If an employee earns $60,000 gross and the employer pays the 9% TRS contribution on behalf of the employee, the pension basis is $60,000, not $60,000 minus taxes.

Can I use an average step/lane to project instead of building a detailed roster model?

For a small agency (under 50 employees), a detailed roster model is worth the effort—it takes 1–2 hours and gives perfect accuracy.

For a large agency (500+ employees), you can use a simplified model: (Average Salary × Headcount) + (Cost Multiplier Adjustments). However, this misses lane movement and turnover dynamics. CollBar's labor costing service models large rosters automatically, so consider outsourcing if your team doesn't have time for detail-level builds.

How far forward should I project—just the contract term, or longer?

Project through the full contract term (typically 3–4 years) at minimum. This is what you'll be locked into. Many finance directors also project an additional 1–2 years with status quo assumptions to show the board what happens when the contract expires and a new one is negotiated.

What if the union requests a salary minimum or a floor for step advancement (e.g., "no step increase below 3%")?

Floor clauses lock you into minimum step increases regardless of actual experience distribution. If your contract says "step advancement shall not be less than 3% per step," you've essentially committed to 3% base payroll growth annually even if steps otherwise average 2%.

Model this as a separate scenario, and flag to your board that step floors eliminate natural cost brakes (like turnover savings).

How should I account for overtime, shift differentials, or longevity bonuses?

These are typically small (1–3% of base payroll in a typical public agency) but must be modeled separately if they're negotiated as increases.

Overtime and shift differentials don't carry forward to pension calculations (in most states), so they have a lower cost multiplier (~1.05x vs. 1.35x). Longevity bonuses (off-schedule pay for high-step employees) DO carry forward to pensions and should be treated as base salary.

Key Takeaways

• Labor costs represent 60–75% of public-sector budgets. Without a rigorous projection model, you're making multi-million-dollar budget decisions on incomplete information.

• Five cost drivers account for all payroll growth: step advancement, schedule increase, lane movement, benefits trend, and headcount changes. Isolate each one in your model so you can evaluate trade-offs transparently.

• Status quo is not zero cost. Even a "freeze" scenario includes step advancement (1.5–3.0%) and benefits trend (5–8%), totaling 5–7% payroll growth annually.

• Turnover is your largest natural cost brake. A high-step retiree replaced by a new hire saves $15K–$45K immediately. Model realistic turnover by career stage to reveal the real incremental cost of labor agreements.

• Your cost multiplier varies by state pension system. Illinois (1.32x) is far cheaper than Pennsylvania (1.50x+) per dollar of salary. Know your baseline multiplier and use it to frame board discussions about the true cost of agreements.

• Scenario planning tools are non-negotiable. Hand-built spreadsheets fail under pressure. Invest in a labor cost modeling system (whether spreadsheet-based or software-based) that lets you change one assumption and recalculate all years instantly.

How CollBar Can Help

Building a labor cost projection model from scratch takes time—and getting the formulas wrong costs far more than the modeling effort saves. CollBar's scenario planning service helps you model unlimited "what-if" scenarios, from salary increases and benefits changes to staffing adjustments and work rule modifications. We build transparent, auditable models that your board and union negotiators can trust.

Whether you need a single projection model for an upcoming negotiation, multi-year scenario analysis for strategic planning, or ongoing labor cost forecasting support, CollBar brings both the expertise and the tools to give you answers—not guesses.

Ready to project with confidence? Call us at (419) 350-8420 to schedule a free 20-minute strategy session. We'll walk through your current projection challenges and show you exactly how we'd approach your next labor cost forecast.