Compensation Benchmarking & Total Rewards Design
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
1 --- 2 name: compensation-benchmarking 3 description: USE THIS SKILL when the user asks about pay structure, salary bands, compensation benchmarking, incentive design, total rewards, compa-ratio analysis, pay equity, executive compensation, variable pay, equity compensation, market pricing, salary surveys, or grade structures. Also trigger for "red circle," "green circle," "range penetration," "pay philosophy," "STI design," "LTI design," "compensation cost modeling," "gender pay gap," "equal pay," or any request to design, analyze, or benchmark compensation against market data for any employee population. 4 --- 5 6 # Compensation Benchmarking & Total Rewards Design 7 8 ## Required Inputs 9 10 | Input | Description | Required? | 11 |-------|-------------|-----------| 12 | Employee data | Headcount by role, level, location, current compensation (base + variable + equity) | Yes | 13 | Job architecture | Internal job levels, titles, role descriptions | Yes | 14 | Business context | Industry, size, growth stage, geographic footprint | Yes | 15 | Compensation philosophy | Current philosophy or willingness to define one | Yes | 16 | Market survey data | Access to or willingness to acquire salary survey data | Recommended | 17 | Financial constraints | Total compensation budget, budget increase ceiling | Recommended | 18 | Current pay structure | Existing salary bands, grades, incentive plans | Recommended | 19 | Peer group | Identified competitor companies for talent | Recommended | 20 | Demographic data | Gender, ethnicity for pay equity analysis (where legally collected) | Recommended | 21 22 ## Execution Steps 23 24 ### 1. Compensation Philosophy Framework 25 26 Define the market positioning strategy that guides all compensation decisions: 27 28 **Philosophy Decision Matrix:** 29 30 | Element | Lead Market (P75+) | Match Market (P50) | Lag Market (P25-P40) | Blended | 31 |---------|-------------------|-------------------|---------------------|---------| 32 | **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 | 33 | **Cost implication** | 15-25% above median | Neutral | 10-20% below median | Varies | 34 | **Risk** | Overpaying for non-critical roles | Losing top talent to aggressive competitors | Attrition of key performers | Complexity, perceived inequity | 35 36 **Recommended Blended Philosophy (typical):** 37 38 | Role Segment | Target Percentile (Base) | Target Percentile (TTC) | Rationale | 39 |-------------|------------------------|------------------------|-----------| 40 | Executive / C-Suite | P50-P65 base | P65-P75 TTC (with LTI) | Attract proven leaders, weight toward variable | 41 | Strategic / scarce skills | P60-P75 base | P65-P75 TTC | Compete for talent in scarce markets | 42 | Core operational | P50 base | P50 TTC | Market competitive; retain through development | 43 | Support / admin | P40-P50 base | P45-P50 TTC | Cost-effective; supplement with benefits/culture | 44 45 `TTC = Total Target Compensation = Base + Target Bonus + Expected Equity Value` 46 47 ### 2. Market Data Sourcing Methodology 48 49 **Survey Selection Criteria:** 50 51 | Criterion | Evaluation Questions | 52 |-----------|---------------------| 53 | Industry coverage | Does the survey cover our specific industry segment? | 54 | Geographic coverage | Does it cover our operating locations with local data? | 55 | Company size match | Are participating companies of similar revenue and headcount? | 56 | Job match quality | Can our roles be matched at 70%+ content overlap? | 57 | Recency | Is data within 12 months? If not, apply aging factor. | 58 | Sample size | Minimum 5 companies, 20 incumbents per benchmark job? | 59 60 **Major Market Data Sources:** 61 62 | Source | Strengths | Typical Coverage | Cost | 63 |--------|----------|-----------------|------| 64 | Mercer Total Remuneration Survey | Global, broad industries, robust methodology | 25M+ data points, 130+ countries | $$$ | 65 | Radford (Aon) | Technology, life sciences specialization | Tech-focused, equity data strong | $$$ | 66 | Willis Towers Watson CDB | Large employers, global, detailed benefits | Executive through professional levels | $$$ | 67 | Culpepper | Mid-market, technology, niche surveys | US + select international | $$ | 68 | Payscale / Salary.com | Broad access, real-time data | Large databases, employee-reported | $ | 69 | Glassdoor / LinkedIn Salary | Directional, employee-reported | Best for market trends, less reliable for precision | Free | 70 | Bureau of Labor Statistics (BLS) | Free, government data, geographic detail | US only, broad occupational categories | Free | 71 72 **Data Aging Factor:** If survey data is X months old, apply: `Aged Value = Survey Value x (1 + Annual Movement Rate x (Months / 12))` 73 Typical annual movement: 3.0-4.5% for base salary in developed markets. 74 75 **Geographic Differential:** `Adjusted Value = National Median x Geographic Differential Factor` 76 Example: San Francisco = 1.25x national; Austin = 1.05x; rural markets = 0.80-0.90x. 77 78 ### 3. Job Matching / Leveling Framework 79 80 **Internal Leveling Architecture:** 81 82 | Grade | Level Title | Scope | Decision Authority | Management Responsibility | Typical Experience | 83 |-------|-----------|-------|-------------------|--------------------------|-------------------| 84 | G1 | Entry / Associate | Task execution | Follows procedures | None | 0-2 years | 85 | G2 | Specialist / Analyst | Project components | Standard decisions within guidelines | None | 2-5 years | 86 | G3 | Senior Specialist | Full projects | Complex decisions within policy | May lead small teams | 5-8 years | 87 | G4 | Manager / Lead | Function or team | Budget and people decisions | Direct reports | 7-12 years | 88 | G5 | Senior Manager / Director | Department | Strategic decisions for area | Multiple teams | 10-15 years | 89 | G6 | VP / Senior Director | Business unit or major function | P&L or major budget authority | Large organization | 15+ years | 90 | G7 | SVP / C-Suite | Enterprise | Enterprise-level strategy | Enterprise scope | 18+ years | 91 92 **Job Matching Protocol:** 93 1. Match internal role to survey benchmark job based on **content** (not title) 94 2. Require 70%+ overlap in duties, scope, and complexity 95 3. Document match rationale for audit trail 96 4. Use blended matches if no single survey job fits (weighted average of 2 benchmarks) 97 5. Flag "unique" roles with no market match -- price by comparable internal level 98 99 ### 4. Base Pay Analysis 100 101 **Compa-Ratio Analysis:** 102 103 `Compa-Ratio = Actual Base Pay / Range Midpoint (or Market P50)` 104 105 | Interpretation | Compa-Ratio | Action | 106 |---------------|-------------|--------| 107 | Significantly below range | < 0.85 | Immediate adjustment or accelerated progression | 108 | Below range | 0.85 - 0.95 | Priority for next increase cycle | 109 | At market | 0.95 - 1.05 | Standard merit increase | 110 | Above range | 1.05 - 1.15 | Reduced increase; ensure performance warrants | 111 | Significantly above range (red circle) | > 1.15 | Freeze or lump-sum in lieu of increase | 112 113 **Range Penetration Analysis:** 114 115 `Range Penetration = (Actual Pay - Range Min) / (Range Max - Range Min) x 100%` 116 117 Expected range penetration by tenure in role: New in role = 0-25%; Developing = 25-50%; Fully competent = 50-75%; Expert/Long tenure = 75-100%. 118 119 **Population Analysis Template:** 120 121 | Function | Headcount | Avg Compa-Ratio | % Below 0.90 | % Above 1.10 | Avg Range Penetration | Cost to Bring to P50 ($) | 122 |----------|-----------|----------------|-------------|-------------|----------------------|-------------------------| 123 | [Function] | | | | | | | 124 125 ### 5. Pay Band Design Methodology 126 127 **Band Structure Parameters:** 128 129 | Parameter | Typical Range | Formula | 130 |-----------|-------------|---------| 131 | Midpoint | Market P50 (or target percentile) | Set by market data | 132 | Spread (total range width) | 40-60% for professional; 60-80% for management; 80-100%+ for executive | Spread = (Max - Min) / Min | 133 | Midpoint differential (between grades) | 12-18% between adjacent grades | Midpoint Differential = (Grade N+1 Midpoint / Grade N Midpoint) - 1 | 134 | Overlap between adjacent grades | 30-50% typical | Overlap = (Grade N Max - Grade N+1 Min) / (Grade N Max - Grade N Min) | 135 | Range minimum | Derived from midpoint and spread | Min = Midpoint / (1 + Spread/2) | 136 | Range maximum | Derived from midpoint and spread | Max = Midpoint x (1 + Spread/2) | 137 138 **Example Band Calculation (50% spread, P50 = $100,000):** 139 ``` 140 Midpoint = $100,000 141 Minimum = $100,000 / 1.25 = $80,000 142 Maximum = $100,000 x 1.25 = $125,000 143 Spread = ($125,000 - $80,000) / $80,000 = 56.25% 144 ``` 145 146 ### 6. Variable / Incentive Compensation Design 147 148 **Short-Term Incentive (STI) Design:** 149 150 | Element | Design Choices | 151 |---------|---------------| 152 | Eligibility | By grade level (typically G4+ for individual bonus; G2+ for team/company bonus) | 153 | Target % of base | G2-G3: 5-10%; G4-G5: 15-25%; G6: 30-40%; G7: 50-100% | 154 | Performance measures | Company (revenue, EBITDA) + BU/Team + Individual (weighted) | 155 | Payout range | Threshold (50% payout at 80% achievement) to Maximum (200% payout at 120%+ achievement) | 156 | Payout curve | Linear, step, or accelerated above target | 157 | Funding mechanism | Self-funding (% of EBITDA above threshold) or budgeted pool | 158 159 **Long-Term Incentive (LTI) Design:** 160 161 | Vehicle | Mechanics | Best For | Vesting | Dilution Impact | 162 |---------|-----------|---------|---------|----------------| 163 | Stock options | Right to purchase at grant price | High-growth, pre-IPO | 4-year with 1-year cliff | Moderate-High | 164 | Restricted stock units (RSUs) | Shares delivered at vesting | Established public companies | 3-4 year ratable or cliff | Moderate | 165 | Performance share units (PSUs) | Shares contingent on performance metric | Senior leaders, performance culture | 3-year cliff, metric-based | Moderate | 166 | Phantom stock / SARs | Cash-settled equity equivalent | Private companies | 3-4 year | None (cash cost) | 167 | Profit sharing | % of profits distributed | Broad-based, partnership culture | Annual | None | 168 169 ### 7. Total Rewards Framework 170 171 | Component | Elements | Monetary Value | Market Positioning | 172 |-----------|---------|---------------|-------------------| 173 | **Base pay** | Fixed salary | $[X] | P[X] | 174 | **Short-term variable** | Annual bonus, commission, spot awards | $[X] target | P[X] | 175 | **Long-term incentive** | Equity, LTI cash, deferred comp | $[X] expected annual value | P[X] | 176 | **Benefits** | Health, retirement, insurance, PTO | $[X] employer cost | [Competitive / Above / Below] | 177 | **Perquisites** | Car, housing, club, executive benefits | $[X] | [By level] | 178 | **Career & development** | Training budget, tuition, mentoring | $[X] + intangible | [Describe offering] | 179 | **Work environment** | Flexibility, remote work, culture, mission | Intangible | [EVP strength] | 180 | **Total Rewards Value** | | **$[X]** | **P[X]** | 181 182 ### 8. Pay Equity Analysis 183 184 **Regression-Based Analysis:** 185 186 Run multivariate regression: `Ln(Base Pay) = B0 + B1(Grade) + B2(Tenure) + B3(Performance) + B4(Location) + B5(Gender) + B6(Ethnicity) + e` 187 188 | Variable | Coefficient | Significance (p-value) | Interpretation | 189 |----------|------------|----------------------|----------------| 190 | Gender (Female) | [+/-X%] | [p-value] | If significant (p<0.05), indicates unexplained pay gap | 191 | Ethnicity (non-white) | [+/-X%] | [p-value] | If significant, indicates unexplained pay gap | 192 193 **Practical Significance Threshold:** Flag gaps > 2% even if not statistically significant in small populations. 194 195 **Cohort Analysis (supplement to regression):** 196 197 | Comparison Group | Median Pay (Group A) | Median Pay (Group B) | Raw Gap | Adjusted Gap (controlling for grade, tenure, perf) | Employees Flagged | 198 |-----------------|---------------------|---------------------|---------|---------------------------------------------------|------------------| 199 | Male vs. Female | $[X] | $[X] | X% | X% | [X] | 200 | White vs. Non-White | $[X] | $[X] | X% | X% | [X] | 201 202 **Remediation Cost Estimate:** Sum of individual adjustments needed to close gaps > threshold for all flagged employees. 203 204 ### 9. Executive Compensation Benchmarking 205 206 **Executive Comp Components:** 207 208 | Element | CEO | CFO | COO | Other C-Suite | SVP/EVP | 209 |---------|-----|-----|-----|--------------|---------| 210 | Base salary | $[X] | $[X] | $[X] | $[X] | $[X] | 211 | Target bonus (% base) | X% | X% | X% | X% | X% | 212 | Target bonus ($) | $[X] | $[X] | $[X] | $[X] | $[X] | 213 | LTI (expected annual) | $[X] | $[X] | $[X] | $[X] | $[X] | 214 | Target TDC | $[X] | $[X] | $[X] | $[X] | $[X] | 215 | Market P50 TDC | $[X] | $[X] | $[X] | $[X] | $[X] | 216 | Percentile rank | P[X] | P[X] | P[X] | P[X] | P[X] | 217 218 **Pay Mix Analysis (% of target TDC):** 219 220 | Component | Company | Market Median | Observation | 221 |-----------|---------|-------------|-------------| 222 | Base | X% | X% | [Over/under-weighted] | 223 | STI | X% | X% | | 224 | LTI | X% | X% | | 225 226 Executive comp should shift toward variable/long-term as level increases. Typical CEO mix: 15-20% base, 15-25% STI, 55-70% LTI. 227 228 ### 10. Cost Modeling 229 230 **Current vs. Proposed Structure Impact:** 231 232 | Scenario | Total Base ($M) | Total Variable ($M) | Total Benefits ($M) | Total Comp Cost ($M) | Delta ($M) | Delta % | 233 |----------|----------------|--------------------|--------------------|--------------------|-----------| --------| 234 | Current state | | | | | -- | -- | 235 | Market alignment (bring all to P50) | | | | | | | 236 | Proposed structure (new bands) | | | | | | | 237 | Full remediation (equity + structure) | | | | | | | 238 239 **Phased Budget Impact:** 240 241 | Phase | Year 1 Cost ($M) | Year 2 Cost ($M) | Year 3 Cost ($M) | Cumulative ($M) | 242 |-------|-----------------|-----------------|-----------------|----------------| 243 | Priority adjustments (equity + critical) | | | | | 244 | Structure migration (new bands) | | | | | 245 | Incentive redesign | | | | | 246 | **Total** | | | | | 247 248 ### 11. Implementation / Transition Plan 249 250 **Red-Circle and Green-Circle Management:** 251 252 | Situation | Definition | Management Strategy | 253 |-----------|-----------|-------------------| 254 | **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 | 255 | **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 | 256 | **Compression** | New hires paid near or above tenured employees | Adjust tenured employees; widen bands; introduce tenure-based progression | 257 258 **Migration Timeline:** 259 260 | Phase | Timeline | Actions | Budget Required | 261 |-------|----------|--------|----------------| 262 | 1. Foundation | Month 1-2 | Finalize philosophy, approve bands, complete job matching | Minimal | 263 | 2. Equity fixes | Month 3-4 | Address green circles, pay equity gaps, critical retention risks | $[X] (highest priority) | 264 | 3. Structure rollout | Month 5-6 | Communicate new bands, train managers, update HR systems | $[X] | 265 | 4. Incentive redesign | Month 6-9 | Design and approve new STI/LTI plans, model costs, communicate | $[X] | 266 | 5. Steady state | Month 10-12 | Annual merit within new structure, monitor compa-ratios, refine | Ongoing | 267 268 ### 12. Communication Plan for Compensation Changes 269 270 | Audience | Message | Channel | Timing | Delivered By | 271 |----------|---------|---------|--------|-------------| 272 | Board / Compensation Committee | Philosophy, cost, competitive positioning, risk | Board presentation, executive summary | Before any changes | CHRO / CEO | 273 | Executive team | Philosophy, structure, their personal impact, manager toolkit | 1:1 meetings with CHRO | 4 weeks before announcement | CHRO | 274 | People managers | Philosophy, new bands, how to have conversations, FAQs, manager guide | Manager workshop (mandatory) | 2 weeks before announcement | HR + CHRO | 275 | All employees | Philosophy (why), what is changing (high level), timeline, individual impact | Town hall + personalized total rewards statement | Announcement day | CEO + CHRO | 276 | Individual employees | Personal impact: new band, any adjustment, path forward | 1:1 with manager (HR support available) | Within 1 week of announcement | Direct manager | 277 278 **Communication Principles:** 279 - Lead with philosophy and fairness rationale -- not just numbers 280 - Managers must understand the system before employees hear about it 281 - Every employee receives a personalized total rewards statement 282 - Provide a clear channel for questions and concerns 283 - Never promise future increases -- communicate the framework 284 285 ## Output Template 286 287 ```markdown 288 # Compensation Benchmarking & Total Rewards Report: [Organization] 289 290 **Date:** [Date] 291 **Scope:** [X] employees across [X] levels, [X] locations 292 **Market Data Sources:** [List surveys used] 293 **Data Effective Date:** [Date] (aged to [Date] at [X]% annual factor) 294 295 --- 296 297 ## 1. Executive Summary 298 299 [2-3 paragraphs: current comp positioning, key findings, recommended actions, cost] 300 301 **Current Total Comp Spend:** $[X]M 302 **Avg Compa-Ratio (company-wide):** [X.XX] 303 **Employees Below P25:** [X] ([X]%) 304 **Pay Equity Gaps Identified:** [X] employees flagged 305 **Estimated Remediation Cost:** $[X]M 306 **Proposed Structure Change Cost:** $[X]M total over [X] phases 307 308 --- 309 310 ## 2. Compensation Philosophy 311 312 [Approved philosophy statement with positioning by segment] 313 314 --- 315 316 ## 3. Market Data Summary 317 318 ### Survey Sources and Methodology 319 [Surveys used, aging factors, geographic adjustments] 320 321 ### Market Benchmarks by Grade 322 | Grade | P25 Base | P50 Base | P75 Base | P50 TTC | Current Midpoint | Gap to P50 | 323 |-------|---------|---------|---------|---------|-----------------|------------| 324 | | | | | | | | 325 326 --- 327 328 ## 4. Current State Analysis 329 330 ### Compa-Ratio Distribution 331 [By function, level, location with outlier identification] 332 333 ### Pay Equity Analysis 334 [Regression results, cohort analysis, flagged employees, remediation cost] 335 336 --- 337 338 ## 5. Proposed Pay Structure 339 340 ### Salary Bands 341 | Grade | Minimum | Midpoint | Maximum | Spread | Midpoint Differential | 342 |-------|---------|----------|---------|--------|----------------------| 343 | | | | | | | 344 345 ### Variable Compensation Design 346 [STI and LTI structure by level] 347 348 --- 349 350 ## 6. Total Rewards Summary 351 352 [Total rewards framework with monetary values and market positioning] 353 354 --- 355 356 ## 7. Executive Compensation 357 358 [C-suite benchmarking, pay mix analysis, market positioning] 359 360 --- 361 362 ## 8. Cost Model 363 364 [Current vs. proposed cost, phased budget, ROI through retention] 365 366 --- 367 368 ## 9. Implementation Plan 369 370 [Phased timeline, red/green circle management, communication plan] 371 372 --- 373 374 ## 10. Recommended Next Steps 375 376 1. [Immediate action with owner and deadline] 377 2. [Second action] 378 3. [Third action] 379 ``` 380 381 ## Quality Checks 382 383 - [ ] Compensation philosophy is explicit about market percentile target by role segment -- not a vague "competitive" statement 384 - [ ] Market data sources are named with data effective dates and aging factors applied 385 - [ ] Job matching uses content-based methodology (70%+ overlap) -- not title matching 386 - [ ] Compa-ratio and range penetration are calculated for every employee with outlier flags 387 - [ ] Pay bands specify midpoint, min, max, spread, and midpoint differential between grades 388 - [ ] Variable compensation design includes eligibility, targets, measures, payout curves, and funding mechanism 389 - [ ] Pay equity analysis uses regression controlling for legitimate factors -- raw gap alone is insufficient 390 - [ ] Executive compensation separates base, STI, LTI with pay mix analysis against market 391 - [ ] Cost model quantifies current vs. proposed at individual level, aggregated to total budget impact 392 - [ ] Red-circle and green-circle situations are identified with explicit management strategies 393 - [ ] Communication plan sequences board, executives, managers, then employees -- never reversed 394 - [ ] Total rewards framework includes non-monetary elements (career, culture, flexibility) alongside monetary 395 - [ ] Geographic differentials are applied when benchmarking multi-location workforces