Methodology Preview:Position titles and range numbers are sourced from the City of Modesto's 2025-2026 Alphabetical Listing of Classifications. Salary, benefit, and pension figures shown here are illustrative — production data populated from City HRIS, CalPERS valuation, and current MOUs at engagement award.

HSG Methodology Demo

City of Modesto · INF-RFP-00096

Methodology Demo Suite · INF-RFP-00096

What Modesto would actually receive — already built.

Six interactive views that mirror the engagement deliverable: a stacked total-compensation model for 361 classifications across 5bargaining groups, CalPERS Misc and Safety pension modeling, employer benefits share including OPEB, the special-pays catalog from POA and Police Non-Sworn MOUs, and the cost-impact tool the City takes into MOU rounds. Built for this proposal — every chart populated with Modesto's actual classification structure (range numbers from the City's 2025-2026 Alpha List).

Workforce in Scope

361 classifications · 14 Executive Mgmt · 350 Other · 1,823 employees (SCO GCC 2024)

Confidential & Mgmt

Modesto Confidential & Management Association

~220 incumbents

MCEA

Modesto City Employee's Association

~1265 incumbents

POA

Modesto Police Officers Association (sworn)

~210 incumbents · sworn

Police Non-Sworn

Modesto Police Non-Sworn Association

~75 incumbents

Unrepresented

Modesto Unrepresented Employees

~53 incumbents

Total Compensation

Total compensation stack

Stacked employer cost per filled position — base salary + cash supplements + certification pay + auto allowance + PERS employer contribution + medical. The lens the Modesto RFP scopes at §SCOPE.

16 sample classifications · all 5 bargaining groups

Open

CalPERS

Pension tiers — Misc & Safety

CalPERS Classic vs. PEPRA, Misc vs. Safety. Employer contribution rates split into normal cost and UAAL. Modesto's largest non-base line item — and where comparator divergence shows up.

4 tiers · normal cost & UAAL split

Open

Benefits

Medical, dental, vision & retiree health

Employer monthly share by plan and tier. The Modesto RFP names “medical benefits” as a total-comp component; OPEB is the long shadow most studies under-resource.

EE / EE+1 / Family + ancillary + OPEB

Open

Cash Supplements

Special pays catalog

POST cert tiers, K-9, motors, SWAT, FTO, detective, bilingual, longevity, education, uniform, auto. The highest-variance line item between sworn classifications across the City and the comparator set.

13 pay codes · POA + Non-Sworn + MCEA + Mgmt

Open

MOU Negotiation Tool

Cost-per-1%-movement calculator

Slider-driven model. Move base or total comp 0–10% across each bargaining group, see City-wide annualized cost — with pensionable-pay rollup for sworn. The deliverable beyond a typical comp study.

5 bargaining groups · pensionable-pay rollup

Open

§5 Personnel

The team

Seven named professionals, allocation hours, signature projects, certifications, and study-specific roles. Every hour assigned to a named individual; every deliverable carries a named signatory.

7 named members · 1,948 committed hours

Open

Methodology Preview

These views aren't mockups. They're the deliverable.

Every chart, every table, every interactive control here is what we'll deliver post-award — sharper, populated with Modesto's production HRIS data, comparator MOUs, and the latest CalPERS valuation. Six months of analytic work, available to City Council and labor relations on day one of contract execution.

Back to overview