Required Inputs
| Input | Description | Required? |
|---|---|---|
| Employee data | Headcount by role, level, location, current compensation (base + variable + equity) | Yes |
| Job architecture | Internal job levels, titles, role descriptions | Yes |
| Business context | Industry, size, growth stage, geographic footprint | Yes |
| Compensation philosophy | Current philosophy or willingness to define one | Yes |
| Market survey data | Access to or willingness to acquire salary survey data | Recommended |
| Financial constraints | Total compensation budget, budget increase ceiling | Recommended |
| Current pay structure | Existing salary bands, grades, incentive plans | Recommended |
| Peer group | Identified competitor companies for talent | Recommended |
| Demographic data | Gender, ethnicity for pay equity analysis (where legally collected) | Recommended |
Execution Steps
1. Compensation Philosophy Framework
Define the market positioning strategy that guides all compensation decisions:
Philosophy Decision Matrix:
| Element | Lead Market (P75+) | Match Market (P50) | Lag Market (P25-P40) | Blended |
|---|---|---|---|---|
| When to use | Scarce talent, critical roles, high-growth companies | Most roles, mature industries, stable markets | Commodity roles, strong EVP, employer-of-choice | Different positioning by segment |
| Cost implication | 15-25% above median | Neutral | 10-20% below median | Varies |
| Risk | Overpaying for non-critical roles | Losing top talent to aggressive competitors | Attrition of key performers | Complexity, perceived inequity |
Recommended Blended Philosophy (typical):
| Role Segment | Target Percentile (Base) | Target Percentile (TTC) | Rationale |
|---|---|---|---|
| Executive / C-Suite | P50-P65 base | P65-P75 TTC (with LTI) | Attract proven leaders, weight toward variable |
| Strategic / scarce skills | P60-P75 base | P65-P75 TTC | Compete for talent in scarce markets |
| Core operational | P50 base | P50 TTC | Market competitive; retain through development |
| Support / admin | P40-P50 base | P45-P50 TTC | Cost-effective; supplement with benefits/culture |
TTC = Total Target Compensation = Base + Target Bonus + Expected Equity Value
2. Market Data Sourcing Methodology
Survey Selection Criteria:
| Criterion | Evaluation Questions |
|---|---|
| Industry coverage | Does the survey cover our specific industry segment? |
| Geographic coverage | Does it cover our operating locations with local data? |
| Company size match | Are participating companies of similar revenue and headcount? |
| Job match quality | Can our roles be matched at 70%+ content overlap? |
| Recency | Is data within 12 months? If not, apply aging factor. |
| Sample size | Minimum 5 companies, 20 incumbents per benchmark job? |
Major Market Data Sources:
| Source | Strengths | Typical Coverage | Cost |
|---|---|---|---|
| Mercer Total Remuneration Survey | Global, broad industries, robust methodology | 25M+ data points, 130+ countries | $$$ |
| Radford (Aon) | Technology, life sciences specialization | Tech-focused, equity data strong | $$$ |
| Willis Towers Watson CDB | Large employers, global, detailed benefits | Executive through professional levels | $$$ |
| Culpepper | Mid-market, technology, niche surveys | US + select international | $$ |
| Payscale / Salary.com | Broad access, real-time data | Large databases, employee-reported | $ |
| Glassdoor / LinkedIn Salary | Directional, employee-reported | Best for market trends, less reliable for precision | Free |
| Bureau of Labor Statistics (BLS) | Free, government data, geographic detail | US only, broad occupational categories | Free |
Data Aging Factor: If survey data is X months old, apply: Aged Value = Survey Value x (1 + Annual Movement Rate x (Months / 12))
Typical annual movement: 3.0-4.5% for base salary in developed markets.
Geographic Differential: Adjusted Value = National Median x Geographic Differential Factor
Example: San Francisco = 1.25x national; Austin = 1.05x; rural markets = 0.80-0.90x.
3. Job Matching / Leveling Framework
Internal Leveling Architecture:
| Grade | Level Title | Scope | Decision Authority | Management Responsibility | Typical Experience |
|---|---|---|---|---|---|
| G1 | Entry / Associate | Task execution | Follows procedures | None | 0-2 years |
| G2 | Specialist / Analyst | Project components | Standard decisions within guidelines | None | 2-5 years |
| G3 | Senior Specialist | Full projects | Complex decisions within policy | May lead small teams | 5-8 years |
| G4 | Manager / Lead | Function or team | Budget and people decisions | Direct reports | 7-12 years |
| G5 | Senior Manager / Director | Department | Strategic decisions for area | Multiple teams | 10-15 years |
| G6 | VP / Senior Director | Business unit or major function | P&L or major budget authority | Large organization | 15+ years |
| G7 | SVP / C-Suite | Enterprise | Enterprise-level strategy | Enterprise scope | 18+ years |
Job Matching Protocol:
- Match internal role to survey benchmark job based on content (not title)
- Require 70%+ overlap in duties, scope, and complexity
- Document match rationale for audit trail
- Use blended matches if no single survey job fits (weighted average of 2 benchmarks)
- Flag "unique" roles with no market match -- price by comparable internal level
4. Base Pay Analysis
Compa-Ratio Analysis:
Compa-Ratio = Actual Base Pay / Range Midpoint (or Market P50)
| Interpretation | Compa-Ratio | Action |
|---|---|---|
| Significantly below range | < 0.85 | Immediate adjustment or accelerated progression |
| Below range | 0.85 - 0.95 | Priority for next increase cycle |
| At market | 0.95 - 1.05 | Standard merit increase |
| Above range | 1.05 - 1.15 | Reduced increase; ensure performance warrants |
| Significantly above range (red circle) | > 1.15 | Freeze or lump-sum in lieu of increase |
Range Penetration Analysis:
Range Penetration = (Actual Pay - Range Min) / (Range Max - Range Min) x 100%
Expected range penetration by tenure in role: New in role = 0-25%; Developing = 25-50%; Fully competent = 50-75%; Expert/Long tenure = 75-100%.
Population Analysis Template:
| Function | Headcount | Avg Compa-Ratio | % Below 0.90 | % Above 1.10 | Avg Range Penetration | Cost to Bring to P50 ($) |
|---|---|---|---|---|---|---|
| [Function] |
5. Pay Band Design Methodology
Band Structure Parameters:
| Parameter | Typical Range | Formula |
|---|---|---|
| Midpoint | Market P50 (or target percentile) | Set by market data |
| Spread (total range width) | 40-60% for professional; 60-80% for management; 80-100%+ for executive | Spread = (Max - Min) / Min |
| Midpoint differential (between grades) | 12-18% between adjacent grades | Midpoint Differential = (Grade N+1 Midpoint / Grade N Midpoint) - 1 |
| Overlap between adjacent grades | 30-50% typical | Overlap = (Grade N Max - Grade N+1 Min) / (Grade N Max - Grade N Min) |
| Range minimum | Derived from midpoint and spread | Min = Midpoint / (1 + Spread/2) |
| Range maximum | Derived from midpoint and spread | Max = Midpoint x (1 + Spread/2) |
Example Band Calculation (50% spread, P50 = $100,000):
Midpoint = $100,000
Minimum = $100,000 / 1.25 = $80,000
Maximum = $100,000 x 1.25 = $125,000
Spread = ($125,000 - $80,000) / $80,000 = 56.25%
6. Variable / Incentive Compensation Design
Short-Term Incentive (STI) Design:
| Element | Design Choices |
|---|---|
| Eligibility | By grade level (typically G4+ for individual bonus; G2+ for team/company bonus) |
| Target % of base | G2-G3: 5-10%; G4-G5: 15-25%; G6: 30-40%; G7: 50-100% |
| Performance measures | Company (revenue, EBITDA) + BU/Team + Individual (weighted) |
| Payout range | Threshold (50% payout at 80% achievement) to Maximum (200% payout at 120%+ achievement) |
| Payout curve | Linear, step, or accelerated above target |
| Funding mechanism | Self-funding (% of EBITDA above threshold) or budgeted pool |
Long-Term Incentive (LTI) Design:
| Vehicle | Mechanics | Best For | Vesting | Dilution Impact |
|---|---|---|---|---|
| Stock options | Right to purchase at grant price | High-growth, pre-IPO | 4-year with 1-year cliff | Moderate-High |
| Restricted stock units (RSUs) | Shares delivered at vesting | Established public companies | 3-4 year ratable or cliff | Moderate |
| Performance share units (PSUs) | Shares contingent on performance metric | Senior leaders, performance culture | 3-year cliff, metric-based | Moderate |
| Phantom stock / SARs | Cash-settled equity equivalent | Private companies | 3-4 year | None (cash cost) |
| Profit sharing | % of profits distributed | Broad-based, partnership culture | Annual | None |
7. Total Rewards Framework
| Component | Elements | Monetary Value | Market Positioning |
|---|---|---|---|
| Base pay | Fixed salary | $[X] | P[X] |
| Short-term variable | Annual bonus, commission, spot awards | $[X] target | P[X] |
| Long-term incentive | Equity, LTI cash, deferred comp | $[X] expected annual value | P[X] |
| Benefits | Health, retirement, insurance, PTO | $[X] employer cost | [Competitive / Above / Below] |
| Perquisites | Car, housing, club, executive benefits | $[X] | [By level] |
| Career & development | Training budget, tuition, mentoring | $[X] + intangible | [Describe offering] |
| Work environment | Flexibility, remote work, culture, mission | Intangible | [EVP strength] |
| Total Rewards Value | $[X] | P[X] |
8. Pay Equity Analysis
Regression-Based Analysis:
Run multivariate regression: Ln(Base Pay) = B0 + B1(Grade) + B2(Tenure) + B3(Performance) + B4(Location) + B5(Gender) + B6(Ethnicity) + e
| Variable | Coefficient | Significance (p-value) | Interpretation |
|---|---|---|---|
| Gender (Female) | [+/-X%] | [p-value] | If significant (p<0.05), indicates unexplained pay gap |
| Ethnicity (non-white) | [+/-X%] | [p-value] | If significant, indicates unexplained pay gap |
Practical Significance Threshold: Flag gaps > 2% even if not statistically significant in small populations.
Cohort Analysis (supplement to regression):
| Comparison Group | Median Pay (Group A) | Median Pay (Group B) | Raw Gap | Adjusted Gap (controlling for grade, tenure, perf) | Employees Flagged |
|---|---|---|---|---|---|
| Male vs. Female | $[X] | $[X] | X% | X% | [X] |
| White vs. Non-White | $[X] | $[X] | X% | X% | [X] |
Remediation Cost Estimate: Sum of individual adjustments needed to close gaps > threshold for all flagged employees.
9. Executive Compensation Benchmarking
Executive Comp Components:
| Element | CEO | CFO | COO | Other C-Suite | SVP/EVP |
|---|---|---|---|---|---|
| Base salary | $[X] | $[X] | $[X] | $[X] | $[X] |
| Target bonus (% base) | X% | X% | X% | X% | X% |
| Target bonus ($) | $[X] | $[X] | $[X] | $[X] | $[X] |
| LTI (expected annual) | $[X] | $[X] | $[X] | $[X] | $[X] |
| Target TDC | $[X] | $[X] | $[X] | $[X] | $[X] |
| Market P50 TDC | $[X] | $[X] | $[X] | $[X] | $[X] |
| Percentile rank | P[X] | P[X] | P[X] | P[X] | P[X] |
Pay Mix Analysis (% of target TDC):
| Component | Company | Market Median | Observation |
|---|---|---|---|
| Base | X% | X% | [Over/under-weighted] |
| STI | X% | X% | |
| LTI | X% | X% |
Executive comp should shift toward variable/long-term as level increases. Typical CEO mix: 15-20% base, 15-25% STI, 55-70% LTI.
10. Cost Modeling
Current vs. Proposed Structure Impact:
| Scenario | Total Base ($M) | Total Variable ($M) | Total Benefits ($M) | Total Comp Cost ($M) | Delta ($M) | Delta % |
|---|---|---|---|---|---|---|
| Current state | -- | -- | ||||
| Market alignment (bring all to P50) | ||||||
| Proposed structure (new bands) | ||||||
| Full remediation (equity + structure) |
Phased Budget Impact:
| Phase | Year 1 Cost ($M) | Year 2 Cost ($M) | Year 3 Cost ($M) | Cumulative ($M) |
|---|---|---|---|---|
| Priority adjustments (equity + critical) | ||||
| Structure migration (new bands) | ||||
| Incentive redesign | ||||
| Total |
11. Implementation / Transition Plan
Red-Circle and Green-Circle Management:
| Situation | Definition | Management Strategy |
|---|---|---|
| Red circle (above max) | Current pay exceeds new range maximum | Freeze base; lump-sum bonus in lieu of increase; reclassify if scope warrants higher grade; managed attrition |
| Green circle (below min) | Current pay falls below new range minimum | Immediate adjustment to minimum (or phased over 2 cycles max); priority in next merit cycle |
| Compression | New hires paid near or above tenured employees | Adjust tenured employees; widen bands; introduce tenure-based progression |
Migration Timeline:
| Phase | Timeline | Actions | Budget Required |
|---|---|---|---|
| 1. Foundation | Month 1-2 | Finalize philosophy, approve bands, complete job matching | Minimal |
| 2. Equity fixes | Month 3-4 | Address green circles, pay equity gaps, critical retention risks | $[X] (highest priority) |
| 3. Structure rollout | Month 5-6 | Communicate new bands, train managers, update HR systems | $[X] |
| 4. Incentive redesign | Month 6-9 | Design and approve new STI/LTI plans, model costs, communicate | $[X] |
| 5. Steady state | Month 10-12 | Annual merit within new structure, monitor compa-ratios, refine | Ongoing |
12. Communication Plan for Compensation Changes
| Audience | Message | Channel | Timing | Delivered By |
|---|---|---|---|---|
| Board / Compensation Committee | Philosophy, cost, competitive positioning, risk | Board presentation, executive summary | Before any changes | CHRO / CEO |
| Executive team | Philosophy, structure, their personal impact, manager toolkit | 1:1 meetings with CHRO | 4 weeks before announcement | CHRO |
| People managers | Philosophy, new bands, how to have conversations, FAQs, manager guide | Manager workshop (mandatory) | 2 weeks before announcement | HR + CHRO |
| All employees | Philosophy (why), what is changing (high level), timeline, individual impact | Town hall + personalized total rewards statement | Announcement day | CEO + CHRO |
| Individual employees | Personal impact: new band, any adjustment, path forward | 1:1 with manager (HR support available) | Within 1 week of announcement | Direct manager |
Communication Principles:
- Lead with philosophy and fairness rationale -- not just numbers
- Managers must understand the system before employees hear about it
- Every employee receives a personalized total rewards statement
- Provide a clear channel for questions and concerns
- Never promise future increases -- communicate the framework
Output Template
# Compensation Benchmarking & Total Rewards Report: [Organization]
**Date:** [Date]
**Scope:** [X] employees across [X] levels, [X] locations
**Market Data Sources:** [List surveys used]
**Data Effective Date:** [Date] (aged to [Date] at [X]% annual factor)
---
## 1. Executive Summary
[2-3 paragraphs: current comp positioning, key findings, recommended actions, cost]
**Current Total Comp Spend:** $[X]M
**Avg Compa-Ratio (company-wide):** [X.XX]
**Employees Below P25:** [X] ([X]%)
**Pay Equity Gaps Identified:** [X] employees flagged
**Estimated Remediation Cost:** $[X]M
**Proposed Structure Change Cost:** $[X]M total over [X] phases
---
## 2. Compensation Philosophy
[Approved philosophy statement with positioning by segment]
---
## 3. Market Data Summary
### Survey Sources and Methodology
[Surveys used, aging factors, geographic adjustments]
### Market Benchmarks by Grade
| Grade | P25 Base | P50 Base | P75 Base | P50 TTC | Current Midpoint | Gap to P50 |
|-------|---------|---------|---------|---------|-----------------|------------|
| | | | | | | |
---
## 4. Current State Analysis
### Compa-Ratio Distribution
[By function, level, location with outlier identification]
### Pay Equity Analysis
[Regression results, cohort analysis, flagged employees, remediation cost]
---
## 5. Proposed Pay Structure
### Salary Bands
| Grade | Minimum | Midpoint | Maximum | Spread | Midpoint Differential |
|-------|---------|----------|---------|--------|----------------------|
| | | | | | |
### Variable Compensation Design
[STI and LTI structure by level]
---
## 6. Total Rewards Summary
[Total rewards framework with monetary values and market positioning]
---
## 7. Executive Compensation
[C-suite benchmarking, pay mix analysis, market positioning]
---
## 8. Cost Model
[Current vs. proposed cost, phased budget, ROI through retention]
---
## 9. Implementation Plan
[Phased timeline, red/green circle management, communication plan]
---
## 10. Recommended Next Steps
1. [Immediate action with owner and deadline]
2. [Second action]
3. [Third action]
Quality Checks
- Compensation philosophy is explicit about market percentile target by role segment -- not a vague "competitive" statement
- Market data sources are named with data effective dates and aging factors applied
- Job matching uses content-based methodology (70%+ overlap) -- not title matching
- Compa-ratio and range penetration are calculated for every employee with outlier flags
- Pay bands specify midpoint, min, max, spread, and midpoint differential between grades
- Variable compensation design includes eligibility, targets, measures, payout curves, and funding mechanism
- Pay equity analysis uses regression controlling for legitimate factors -- raw gap alone is insufficient
- Executive compensation separates base, STI, LTI with pay mix analysis against market
- Cost model quantifies current vs. proposed at individual level, aggregated to total budget impact
- Red-circle and green-circle situations are identified with explicit management strategies
- Communication plan sequences board, executives, managers, then employees -- never reversed
- Total rewards framework includes non-monetary elements (career, culture, flexibility) alongside monetary
- Geographic differentials are applied when benchmarking multi-location workforces