Question 1

How much does CollBar's Cost Modeling Engine cost for public employers in Columbia, Missouri?

Accepted Answer

CollBar's Cost Modeling Engine pricing for public employers typically ranges from $8,000 to $25,000 depending on organizational size, complexity of bargaining units, and scope of analysis. A small municipal department with one or two unions might invest $8,000–$12,000 for a comprehensive 3-year cost projection model, while a mid-sized city or county with multiple bargaining units and complex pension obligations could expect $15,000–$25,000. This investment includes initial data gathering, model calibration, scenario testing, and a detailed final report with negotiation guidance. CollBar's transparent pricing model ensures public employers understand exactly what they're paying for and receive measurable ROI through informed contract negotiations and budget forecasting.

Question 2

What is included in CollBar's Cost Modeling Engine service?

Accepted Answer

CollBar's Cost Modeling Engine delivers a comprehensive suite of deliverables tailored to public-sector labor dynamics. The service includes detailed wage and benefit cost projections (3–10 year horizons), pension obligation calculations compliant with GASB standards, scenario modeling for various contract settlement proposals, impact analysis on municipal budgets and fund balances. You also receive an interactive dashboard allowing your finance and HR teams to test different contract scenarios in real-time, executive summary briefings, and strategic negotiation recommendations.

Question 3

How long does it take to complete a Cost Modeling Engine analysis?

Accepted Answer

A typical CollBar Cost Modeling Engine engagement takes 6–12 weeks from contract initiation to final report delivery, depending on data availability and complexity. The timeline breaks down as: 2 weeks for data collection and validation, 2–3 weeks for model development and calibration, 2–4 weeks for scenario analysis and stakeholder feedback cycles, and 1–2 weeks for final reporting and presentation. If your organization has well-organized payroll data and clear contract documents readily available, CollBar can often accelerate this timeline. CollBar offers expedited 4–6 week engagements for focused analysis on critical scenarios.

Question 4

Should we build cost modeling in-house or hire CollBar as a consultant?

Accepted Answer

While some large public employers maintain internal labor relations analytics teams, outsourcing to CollBar offers distinct advantages for most organizations. Building these capabilities in-house requires hiring specialized staff (often $80,000–$120,000 annually), purchasing software licenses, and investing months in model development—costs that exceed a single CollBar engagement for most organizations. Additionally, CollBar's independence and reputation for objective analysis strengthens your negotiating position and provides external credibility that internal models may lack with union counterparts.

Question 5

How does CollBar handle complex pension obligations in cost modeling?

Accepted Answer

Pension obligations represent the largest long-term liability for most public employers, and CollBar's Cost Modeling Engine explicitly accounts for GASB 67/68-compliant calculations, unfunded actuarial accrued liabilities (UAAL), and contribution rate volatility. CollBar works directly with your pension administrator or actuary to integrate current funding levels, assumed return rates, and projected contribution schedules into your contract cost projections.

Question 6

What data does CollBar need from our organization to build the cost model?

Accepted Answer

CollBar requires five core data categories: (1) Current payroll data including wages, step progression, longevity pay, and differentials by position and bargaining unit; (2) Benefit plan documentation (health insurance, dental, vision, life insurance terms and employer/employee cost splits); (3) Collective bargaining agreement language covering wages, hours, leaves, grievance procedures, and all compensation terms; (4) Historical financial data showing actual compensation costs for 3–5 years; and (5) Workforce demographics including age distribution, tenure, turnover rates, and hiring projections.

Question 7

Can CollBar model different wage increase scenarios for negotiations?

Accepted Answer

Yes—scenario modeling is a cornerstone of CollBar's Cost Modeling Engine service. CollBar builds your cost model with flexible architecture allowing you to test unlimited contract settlement scenarios: across-the-board wage increases (2%, 3%, 4%+), lump-sum bonuses, step progression changes, tiered increases by seniority, and cost-of-living adjustments (COLA). You can also model non-wage scenarios like health insurance cost-sharing changes, paid leave modifications, or pension benefit adjustments. CollBar typically delivers your model with 5–10 pre-built scenarios representing likely negotiation outcomes, plus training for your team to build additional scenarios independently.

Question 8

How does CollBar help us prepare for contract negotiations?

Accepted Answer

CollBar's Cost Modeling Engine directly strengthens your negotiating position by providing objective, data-driven justification for your contract proposals. With detailed cost projections, you demonstrate to unions exactly how wage and benefit proposals impact your municipal budget, pension fund, and taxpayers—removing speculation from the negotiation table. CollBar also provides competitive benchmarking showing how your current and proposed compensation compares to peer cities and counties, which unions often use in counterclaims. Additionally, CollBar prepares executive briefings explaining complex cost impacts in language suitable for union leadership and rank-and-file members, addressing common misconceptions and building common ground.

Question 9

What sets CollBar's Cost Modeling Engine apart from other labor consulting services?

Accepted Answer

CollBar's distinction lies in deep public-sector specialization and software-enabled accessibility. Unlike generalist HR consultants, CollBar focuses exclusively on public-sector labor relations, meaning every analyst understands GASB pension accounting, prevailing wage rules, bargaining statutory constraints, and public-employer budget dynamics that private-sector consultants frequently mishandle. Critically, CollBar delivers an interactive cost modeling dashboard (not just a static PDF report) allowing your finance and HR teams to continue testing scenarios months after the initial engagement, extending the value of your investment. Finally, CollBar's commitment to objectivity and transparent methodology builds trust with union partners, creating conditions for more efficient, durable negotiations that avoid costly grievances and arbitrations.

One engine

What's Included

Our Process

Discovery

Analysis

Strategy

Execution

Frequently Asked Questions

Book a Free Strategy Session

Related Services

Cities We Serve