Every budget cycle, the same question surfaces in finance offices across school districts, cities, and special districts: "How much will our labor costs actually increase next year?" The answer determines whether you can fund programs, hire staff, or maintain service levels. Yet most finance directors rely on outdated spreadsheets, rough percentage estimates, or industry assumptions that miss the real drivers of labor cost growth.
This article will equip you with the frameworks, formulas, and decision tools that separate accurate projections from budget surprises. You'll learn the five cost drivers that actually move the needle, how to build a defensible multi-year model, and how to communicate incremental costs to elected officials and union negotiators with confidence.
Why Labor Cost Projections Matter More Than You Think
Labor typically represents 55–75% of public-sector operating budgets. For a city with a $50 million budget, labor might account for $35 million. A 1% projection error on that $35 million costs $350,000 in unanticipated exposure. Over a 3-year contract, a 2% modeling error compounds to over $2 million in unbudgeted liability.
The problem isn't data scarcity—it's modeling rigor. Many finance offices know their current salary expense but underestimate growth because they conflate three distinct cost drivers:
- Step advancement — automatic annual movement on the salary grid, guaranteed and mandatory
- Schedule increase — the grid itself expanding, typically negotiated as a percentage
- Benefits trend — premium increases independent of any CBA changes, compounding annually
A district might assume "3% salary growth" across the board. But in reality, step advancement alone could be 1.5–3.0% annually (automatic), while a negotiated schedule increase adds another 2.5%, and benefits trend another 5.0%. The true incremental cost is not 3%—it's closer to 8.5%, absorbed by the budget whether or not the district negotiated it.
This article breaks down the mechanics so your projections match reality.
The Five Cost Drivers: Your Projection Foundation
Every dollar of labor cost growth in any given year comes from exactly five sources. Understanding each is the foundation of accurate modeling.
1. Step Advancement (The Inevitable Cost)
Step advancement is automatic. Teachers move down one row on the salary grid annually until they reach the top step. This is typically not negotiated; it's baked into the CBA structure. It's also often underestimated because finance teams mentally "freeze" the schedule and forget that the workforce still advances.
Formula:
Step Advancement Cost = Sum of (New Salary - Old Salary) for each teacher advancing one step
Simplified estimate: Step advancement ≈ 1.5–3.0% of current payroll annually
Example: A district with a $40 million teacher payroll where the average salary increase between steps is 2.3% automatically incurs:
$40,000,000 × 0.023 = $920,000 in step advancement cost in Year 1
This is unavoidable unless the CBA explicitly freezes steps (rare, and typically traded for schedule increases or one-time bonuses).
Red flag: Boards that freeze salary schedules often fail to account for step advancement, then discover a $500K–$1M surprise by February.
2. Schedule Increase (The Negotiated Cost)
This is what unions and management primarily bargain over: the percentage by which every cell in the salary schedule grows. A "2.5% schedule increase" means every salary on the grid increases by 2.5%.
Formula:
Schedule Increase Cost = Current Total Salary × Negotiated Schedule % Increase
Example: Same $40 million district negotiates a 2.5% schedule increase:
$40,000,000 × 0.025 = $1,000,000 in Year 1 schedule increase cost
Schedule increases typically range from 0% (freeze) to 5.0% (strong union market). Combined with step advancement, a typical Year 1 "salary growth" is 4.0–5.5% of payroll.
3. Lane Movement (Probabilistic, Often Overlooked)
A teacher in the BA lane completes a master's degree and moves to the MA lane. This mid-year or next-cycle transition adds 8–15% to that teacher's salary (the difference between BA+0 and MA+0 on the same step). Across a district, 5–8% of eligible teachers move one lane per year.
Formula:
Lane Movement Cost ≈ (Eligible Teachers × Movement Rate × Average Lane Differential)
Simplified: Lane movement ≈ 0.5–1.5% of payroll annually
Example: District with 400 teachers, 8% movement rate, average lane differential of $3,500:
400 × 0.08 × $3,500 = $112,000 annual lane movement cost
Why it matters: A 3-year projection that ignores lane movement understates cost by $336,000. Many districts don't even track this separately; they lump it into "step advancement" and get surprised.
4. Benefits Trend (The Silent Multiplier)
Health insurance premiums, dental, vision, life, and disability insurance rise annually independent of any CBA negotiation. This is driven by medical cost inflation, plan design changes, and actuarial revaluations.
Annual benefits trend rates (standard assumptions):
| Benefit | Annual Trend |
|---|---|
| Medical | 5.0–8.0% |
| Dental | 3.0–3.5% |
| Vision | 2.0–2.5% |
| Life | 0% (fixed coverage) |
| LTD | 2.0–3.0% |
Benefits trend is employer cost. Even if the CBA is frozen (0% salary increase), benefits costs rise.
Formula:
Benefits Trend Cost Year N = Benefits Cost Year N-1 × (1 + Trend Rate)
Example: District spends $12 million/year on health insurance with a 5.5% trend:
Year 1: $12,000,000 × 1.055 = $12,660,000 (+$660,000)
Year 2: $12,660,000 × 1.055 = $13,356,300 (+$696,300)
Year 3: $13,356,300 × 1.055 = $14,090,897 (+$734,597)
Over 3 years, benefits alone grow by $2.09 million, even with 0% salary increases.
Key insight: Benefits trend typically accounts for 15–30% of total incremental labor cost, but is often invisible in salary-focused negotiations.
5. Headcount & Workforce Composition Changes
Retirements, new hires, reduction in force, attrition, and shifts in the tenure mix all affect payroll cost. A high-step retirement creates savings that offset wage increases. New hires at Step 1 are cheaper but take years to reach top step.
Formula:
Headcount Impact = (New Hires × Avg New Hire Salary) - (Departures × Avg Departing Salary)
Example: 10 retirements at average $95,000 (Steps 18–22, MA+30) replaced by 12 new hires at average $42,500 (Step 1, BA):
Cost = (12 × $42,500) - (10 × $95,000) = $510,000 - $950,000 = –$440,000 (savings)
This $440,000 savings offsets step advancement and benefits growth, but only if the district explicitly models turnover. Most don't.
Critical detail: Turnover rates vary sharply by career stage. Early-career teachers (Steps 1–3) turn over at 12–18% annually. Late-career teachers (Steps 16+) turn over at 2–4%. A district aging rapidly has lower turnover—and thus fewer replacement-savings offsets.
The Cost Multiplier: From Salary to Total Employer Cost
Every compensation model needs a cost multiplier—the ratio of total employer cost to base salary. This captures salary + benefits + payroll taxes + retirement contributions in a single number.
Formula:
Cost Multiplier = Total Employer Cost / Total Base Salary
For most public-sector employers, the cost multiplier ranges from 1.25x to 1.45x. What does this mean?
Example breakdown (Illinois teacher, BA+15, Step 8, $65,000 base):
| Category | Amount |
|---|---|
| Base Salary | $65,000 |
| Health Insurance (Employer) | $9,600 |
| Dental (Employer) | $648 |
| Vision (Employer) | $162 |
| Life Insurance (Employer) | $300 |
| Retirement - TRS (9.0%, often district-paid) | $5,850 |
| Retirement - TRS (0.58% employer match) | $377 |
| Medicare (1.45%) | $943 |
| Workers' Compensation (0.5%) | $325 |
| FUTA/SUTA | $0 (public school exempt) |
| Total Employer Cost | $83,205 |
| Cost Multiplier | 1.281x |
In this case, for every $1.00 of salary, the employer spends $1.28 in total cost.
Why this matters for projections: When the board negotiates a 2.5% schedule increase + 2.0% step advancement, the true incremental cost is not 4.5% of salary—it's 4.5% × 1.28 = 5.76% of total employer cost. A $40 million salary budget becomes a $51.2 million employer cost budget. A 2% error in the multiplier compounds across a 3-year contract.
State-specific multipliers (rough guidance):
| State | Pension ER % | Multiplier Range |
|---|---|---|
| Illinois (TRS, 9% picked up) | 10.58% | 1.32–1.42x |
| Ohio (STRS) | 14.0% | 1.35–1.45x |
| Pennsylvania (PSERS) | 35.26% | 1.50–1.65x |
| California (CalSTRS) | 19.10% | 1.38–1.48x |
| New York (NYSTRS + SS) | 11.0% + 6.2% | 1.35–1.45x |
| Wisconsin (WRS + SS) | 6.9% + 6.2% | 1.27–1.37x |
Practical takeaway: A Pennsylvania district projecting labor cost with a 1.35x multiplier will systematically underestimate by 10%+. If PSERS rates are 35.26% (2024–25), your actual multiplier is closer to 1.58x.
Building a Multi-Year Labor Cost Projection Model
Now that you understand the five drivers, here's the process to build a defensible, auditable model.
Step 1: Establish Your Current-Year Baseline
Pull actual payroll data from your accounting system by employee: name (anonymized as Employee ID), current salary, step, lane, benefits tier, hire date, position code. This is your roster as of June 30 (or your fiscal year-end).
Required data columns:
- Employee ID, Position Title, Classification (Teacher, Administrator, Support)
- Current Salary, Current Step, Current Lane
- Benefits Tier (Single, EE+Spouse, Family)
- Hire Date, Years of Service
- FTE (full-time equivalent adjustment)
Step 2: Load the Current Salary Schedule
Input your actual step-and-lane grid. For a school district, this is typically 20–30 steps (BA through MA+60 lanes). For municipal departments, input your current rate tables by classification and experience tier.
This is your anchor document. Every projection flows from this grid.
Step 3: Project Step Advancement
For each employee, identify their current step and determine next year's step. Use these rules:
- If step < maximum, advance one step (automatic)
- If step = maximum, stay at maximum (or apply off-schedule longevity if your CBA includes it)
- If the CBA freezes steps, apply the freeze per the contract language
Formula (for each employee):
Next Year Salary = Salary Schedule[Next Step][Current Lane]
Sum all employees to get total step advancement cost.
Step 4: Apply Schedule Increase Scenarios
Create columns for 0%, 1.0%, 2.0%, 2.5%, 3.0%, 3.5%, and 4.0% schedule increases (adjust range to your local market). For each scenario, multiply every cell in the salary schedule by (1 + increase %).
Most finance offices maintain 3–4 budget scenarios:
- Scenario A (Conservative): 0% schedule increase (freeze) + step advancement
- Scenario B (Status Quo): 2.0% schedule increase + step advancement
- Scenario C (Union Ask): 3.5% schedule increase + step advancement
- Scenario D (Stretch): 4.5% schedule increase + step advancement
By Year 3, the cumulative differences are dramatic:
| Scenario | Year 1 Salary Cost | Year 3 Salary Cost | 3-Year Growth |
|---|---|---|---|
| 0% (Freeze) | $40,920,000 | $42,180,000 | +3.1% |
| 2.0% | $41,920,000 | $44,508,000 | +8.9% |
| 3.5% | $42,420,000 | $45,717,000 | +12.0% |
(Assumes $40M baseline + 2.3% average step advancement annually.)
Step 5: Layer in Lane Movement
Estimate the number of employees expected to advance lanes in each year. Typically:
- 5–8% of bachelor's-degreed staff → master's degree
- 2–3% of BA → BA+15, BA+30, etc.
Assign each movers the salary differential (new lane, same step). Sum to get lane movement cost.
Many models treat this as a separate line item. Some lump it into step advancement. Transparency matters; document your assumption.
Step 6: Project Benefits Costs
By employee tier (using your current benefits distribution):
Start with current benefits cost by tier:
- Single: $9,600/year (medical) + $648/year (dental) + $162 (vision) = $10,410
- EE+Spouse: $19,200 + $1,200 + $300 = $20,700
- Family: $26,400 + $1,800 + $420 = $28,620
Assume your workforce distribution (industry default: 35% Single, 25% EE+Spouse, 40% Family).
Apply annual trend factors:
Benefits Cost Year N = Benefits Cost Year N-1 × (1 + Trend %)
Use separate trend rates by benefit type, or a blended rate of 5.5% annually (conservative middle-ground for commercial plans).
Add life, LTD, and workers' compensation (0.5% of payroll).
Step 7: Project Payroll Taxes & Retirement Contributions
Retirement contributions (use your state's rates; do not guess):
- Apply employee percentage (if not district-paid), employer percentage, and any supplemental contributions (THIS Fund in Illinois, etc.)
Payroll taxes:
- Medicare: 1.45% of all payroll, all employees, all states
- Social Security: 6.2% employer only if your state is NOT SS-exempt (verify for your state)
- FUTA/SUTA: Typically $0 for public schools (self-insured), but confirm with your state
Formula:
Payroll Tax Cost = (Payroll × Medicare Rate) + (Payroll × Social Security Rate, if applicable)
Step 8: Model Headcount Scenarios
Create two headcount projections:
Static scenario: Assume current headcount holds constant (no retirements, no new hires).
Dynamic scenario: Estimate realistic retirements, turnover, and new hires by career stage, and apply the cost impact:
- 10 retirements from Steps 18–22 (average $90,000)
- 12 new hires at Step 1 (average $42,500)
- Routine turnover offsets: 4 EE departures, 4 replacements at Step 3 (avg savings: $35,000)
Sum to get headcount cost swing.
Incremental vs. Cumulative Cost: What Boards Actually Need to See
Finance directors must present costs two ways for clarity.
Incremental cost = Year-over-year additional cost compared to the prior year.
Cumulative cost = Total additional cost over the full contract term (typically 3 years).
Example (3-year contract, 2.5% annual schedule increase + 2.3% step advancement + 5.5% benefits trend):
| Year | Salary Cost | Benefits Cost | Total Employer Cost | Annual Increment | Cumulative |
|---|---|---|---|---|---|
| Baseline | $40,000,000 | $12,000,000 | $52,000,000 | — | — |
| Year 1 | $41,788,000 | $12,660,000 | $54,448,000 | +$2,448,000 | +$2,448,000 |
| Year 2 | $43,664,000 | $13,356,300 | $57,020,300 | +$2,572,300 | +$5,020,300 |
| Year 3 | $45,632,000 | $14,090,897 | $59,722,897 | +$2,702,600 | +$7,722,900 |
How to present to elected officials:
"The proposed contract will increase total employer labor costs by $2.45 million in Year 1, $2.57 million in Year 2, and $2.70 million in Year 3, for a cumulative 3-year cost of $7.72 million. This represents a total increase of 14.8% over baseline. To put this in context, that's $48.88 per student per year (if your district has 50,000 students), or a tax-levy impact of 0.98% annually (if you have a $250 million tax base)."
This is far more actionable than "3% salary increase."
Common Modeling Errors (And How to Avoid Them)
Error 1: Ignoring Step Advancement
Mistake: Projecting "2.5% salary growth" by applying 2.5% to the entire payroll, as if the grid is static.
Reality: Step advancement happens automatically. Your projection should add 2.5% (schedule) + 2.3% (step advancement) = 4.8% total salary growth, year-over-year.
Fix: Build step advancement into your baseline projection. It is not optional.
Error 2: Using a Single, Stale Benefits Cost Figure
Mistake: "Health insurance costs $10,000 per employee" and never updating it.
Reality: Premiums increase 5–8% annually. A 3-year-old number is already 15–25% low.
Fix: Gather actual premiums from your current insurance broker (single, family, EE+Spouse, EE+Children by tier). Project each separately using the trend factor from your state's medical cost inflation data or your broker's renewal history.
Error 3: Underestimating the Cost Multiplier
Mistake: Calculating total incremental cost as salary increase × payroll, forgetting retirement contributions and benefits.
Reality: Every 1% salary increase costs closer to 1.35% of total employer cost (in an Illinois district with district-paid TRS contributions).
Fix: Calculate your actual cost multiplier using the formula above. Use it consistently in every scenario.
Error 4: Treating All Headcount Changes as Equal
Mistake: Averaging: "If 10 people retire and 10 are hired, net cost impact is zero."
Reality: Retirees at Step 20+ cost far more than new hires at Step 1. The average retirement nets $45,000 in savings; the new hire costs $42,000—net benefit of $3,000 per cycle.
Fix: Model retirements and new hires separately by position, step, and lane. Calculate the actual cost delta.
Error 5: Forgetting Stipends, Overtime, and Leave Costs
Mistake: Projecting only base salary, ignoring coaching stipends, mentoring pay, extended contracts, and substitute fill-in costs.
Reality: Stipends add 3–5% to payroll. Sick leave usage requires $150–$200/day substitutes (12 days/employee/year). These are real costs.
Fix: Pull actual stipend and substitute expenditure from the prior 3 years. Average, trend, and include in the model.
Scenario Planning: The Tool That Wins Negotiations
Once your base model is built, scenario planning becomes your negotiation lever. You can answer "what if" questions in real time.
Setup: Create input cells (highlighted in yellow) for:
- Schedule increase % (input: 0%, 1%, 2%, 2.5%, 3%, 3.5%, 4%)
- Benefits trend % (input: 4%, 5%, 5.5%, 6%)
- Headcount changes (input: number of retirements, new hires)
- Stipend increases (input: 0%, 1%, 2%)
Every input cascades: Change schedule increase from 2.0% to 2.5%, and all three years recalculate instantly. You see the cost swing in seconds.
Example questions you can answer instantly:
- "What's the cost difference between 2.5% and 3.0%?" → $400,000 Year 1, $1.2M over 3 years
- "If we freeze health insurance premium sharing, what's the savings?" → $85,000 Year 1 (fewer employee contributions, no savings)
- "If we limit step advancement to teachers under Step 10, what's the impact?" → $320,000 Year 1 savings, but creates labor relations risk
Scenario Planning in Action: A Real-World Example
A school district faces a union demand: 3.5% annual schedule increase over 3 years.
Scenario A: No move (0% schedule increase)
- Year 1 cost: $40.92M (step advancement only)
- Year 3 cost: $42.18M
- Cumulative salary growth: 3.1%
Scenario B: Union ask (3.5% annual schedule increase)
- Year 1 cost: $42.42M (3.5% schedule + 2.3% step advancement)
- Year 3 cost: $45.72M
- Cumulative salary growth: 12.0%
Scenario C: Compromise (2.5% annual schedule increase + enhanced benefits)
- Year 1 cost: $41.92M (2.5% schedule + 2.3% step advancement)
- Sweeten retirement pickup: district absorbs additional $0.25M/year
- Real Year 1 cost: $42.17M
- Year 3 cost: $44.51M + benefits enhancements
- Cumulative salary+benefits growth: 10.2%, with different cash distribution (more retirement security, less take-home)
Board presentation: "Scenario C delivers union members 10.2% more total compensation over 3 years, at a lower employer cost than Scenario B, because the district is investing in retirement security rather than cash salary. This is defensible to taxpayers and sustainable for 6+ years."
Union can then evaluate: Is retirement security worth 1.0% less annual salary increase? The model enables that conversation.
Frequently Asked Questions
What if my state recently changed retirement contribution rates?
State pension contribution rates (employer side) change infrequently but dramatically when they do. Illinois raised its THIS Fund from 0.50% to 0.58% in 2024. Pennsylvania's PSERS rate jumped to 35.26% in 2024–25. Always verify your rates directly with your state system or your pension actuarial advisor. Do not use a 2-year-old assumption. If rates are scheduled to increase (California CalSTRS is rising annually), build that into multi-year projections. Contact CollBar if you need help with state-specific pension rate verification; this is a critical element of labor costing.
Should I model turnover if I don't have firm data?
Yes. A static model (assuming no turnover) systematically overstates cost by 10–30%, depending on your workforce age. Use conservative defaults: 8% average turnover, with higher rates for early-career (15%) and lower for late-career (3%). Turnover savings offset 30–50% of step advancement costs in most districts. If you can't justify your turnover assumption with 3 years of actual HR data, say so in your footnotes. Better to flag the assumption than hide it.
How do I handle CBAs with "me-too" clauses?
A "me-too" clause says, "If any other bargaining unit gets a better increase, this unit automatically gets the same." This creates a cost cascade. If Unit A (police) wins 3.5%, then Units B, C, and D (fire, public works, admin) all get 3.5% automatically, even if you budgeted 2.0%. Model this by calculating the incremental cost of the largest increase, then multiplying by the number of units affected. Example: If police cost $25M and get 3.5%, that's +$875K. If four unions have me-too, the true cost is $3.5M+. Always surface this risk in board presentations.
What's the right benefits trend rate to use?
Use 5.5% as a baseline for commercial health plans (PPO/HMO). If your carrier provided renewal projections, use those. For Taft-Hartley multi-employer plans (union healthcare funds), use 8.0%—these plans trend higher because they cover 100% premium with no employee cost-sharing. If you're in a cost-sharing arrangement (board pays 80% family, 90% single), model each tier separately, and note that cost-sharing may shift dollars to employee deductions rather than employer premium, but the trend still affects the total plan cost. Check with CollBar's benchmarking service if you're unsure whether your trend assumption is in line with regional peers.
How do I validate my cost multiplier?
Pull your most recent full fiscal year payroll: total gross salary paid, total employer benefits cost (health, dental, vision, life, LTD, workers' comp), total employer retirement contributions (pension + Social Security, if applicable), and total payroll taxes. Sum the last three categories and divide by total gross salary. The result is your cost multiplier. If it's below 1.20x, you're missing a cost category (workers' comp? retiree health liability accruals?). If it's above 1.60x, your pension rate or benefit package is unusually rich. Document your multiplier in your model footnotes so external reviewers can validate it.
Should I model health insurance mid-contract changes?
Yes, if your CBA includes specific change dates. Example: "Effective 7/1/2025, employee health insurance cost-sharing increases from 15% to 20% family premium." This reduces employer cost by roughly 5% of the health insurance budget. Many CBAs include automatic premium-sharing increases, wellness program incentives, or plan design changes. Build these in as discrete line items by year, clearly labeled, with the effective date and cost impact.
How do I present multi-year projections to a board that's anxious about voter perception?
Lead with the cumulative dollar figure (not the percentage). "Over 3 years, the contract costs $7.7 million more. That's $48.88 per student per year, or 0.98% of the tax levy." Then explain the drivers separately: salary increase ($4.2M), benefits trend ($2.8M), step advancement ($0.7M). Voters are typically less sensitive to absolute dollars than to percentage increases. They also understand that some cost growth is unavoidable (benefits trend, pensions). Frame negotiated salary increases separately from non-negotiable cost pressures. CollBar's scenario-planning tools help you model and communicate these distinctions clearly.
Key Takeaways
Step advancement is automatic and often underestimated. A district projecting only the negotiated schedule increase (e.g., 2.5%) while ignoring mandatory step advancement (2.3%) understates true salary cost growth by nearly 50%. Both must be included in every multi-year baseline.
Use a realistic cost multiplier. Salary increases cost more than salary. In Pennsylvania (PSERS), every 1% salary increase costs 1.58% of total employer cost. In Illinois (TRS with district pickup), it's 1.35–1.42%. Using an outdated or generic multiplier introduces systematic error that compounds over 3 years.
Benefits trend is silent, steady, and huge. Even with a frozen salary schedule, health insurance premiums rise 5–8% annually. Over 3 years, benefits alone can grow $2–3 million. This is not negotiable but must be budgeted.
Scenario planning wins negotiations. Build input cells for schedule increase %, benefits trend %, headcount changes, and stipend changes. The ability to answer "what if" questions in real time gives boards and union negotiators a shared framework for compromise.
Present incremental AND cumulative costs. "The contract costs $2.45 million in Year 1" (incremental) is different from "the contract costs $7.72 million over 3 years" (cumulative). Both numbers matter; both should appear in executive summaries and board presentations.
How CollBar Can Help
CollBar helps finance directors and HR teams build defensible, auditable labor cost models that withstand scrutiny from elected officials, union negotiators, and external auditors. Our labor costing service includes workforce roster analysis, step-and-lane grid modeling, multi-year scenario projections, and state-specific retirement and tax rate integration.
We also offer scenario-planning tools that let you input CBA terms and instantly see the cost impact across years, by cost driver. No spreadsheet expertise required—our software cascades every change through the model in seconds.
If your last labor cost projection was more than 18 months ago, or if you've faced a budget surprise related to step advancement, benefits trend, or hidden stipend costs, it's time for a professional review.
Call CollBar at (419) 350-8420 to book a free 30-minute strategy session. We'll review your current projection methodology, identify gaps, and show you how to integrate more accurate modeling into your annual budget process. Whether you're a first-time negotiator or a seasoned finance director, we ensure your projections match reality.
