Compensation Review Cycle Analysis

Compensation Data Extract

Employee ID Role Level Tenure (years) Current Base Variable Total Comp Performance Rating Key Development Flags EMP-001 Manager 5 $60,000 $20,000 $80,000 Excellent Leadership skills improvement

Total employees extracted: [N]

Benchmark Comparison Matrix

Employee ID Role Level Total Comp P25 P50 P75 Compa-Ratio Position vs Range EMP-001 Manager $80,000 $70,000 $80,000 $90,000 1.20 Above Range

## Summary
Total employees in Below Range: [N]
Total employees in Lower Quartile: [N]
Total employees in Mid-Range: [N]
Total employees in Upper Quartile: [N]
Total employees in Above Range: [N]
Average compa-ratio: [average compa-ratio]
Range of compa-ratios: [lowest compa-ratio] to [highest compa-ratio]

Equity Gap Analysis

Employee ID Issue Type Current Compa-Ratio Acceptable Range Gap Description EMP-001 Below Threshold 1.20 [P25] Below P25 for role level with Strong performance rating; peer equity gap of 12% vs. comparable employees

## Equity Gap Summary
- Pattern: Below P25 for role level with Strong performance rating; peer equity gap of 12% vs. comparable employees
- Affected Employees: [list of Employee IDs]
- Severity: [Severity rating]
- Recommended Action: [one-sentence next step]

## Risk Notes
- [bullet list of any compliance or fairness risks identified]

Compensation Recommendation Rationale

## Executive Summary
[3–5 sentences: total number of adjustments, total cost, key themes (e.g., market realignment, equity correction), and overall budget impact]

## Adjustment Detail
For each approved adjustment:

• [Employee ID] — [Role Level]
  - Current Compensation: [amount]
  - Recommended Adjustment: [amount and percentage]
  - New Compensation: [amount]

Rationale Summary: [2–3 sentences explaining the rationale linking the recommendation to specific benchmark or equity findings]