Compensation Planning & Total Rewards Lab

Compa-Ratio & Salary Range Lab

Calculate compensation compa-ratio, salary range penetration, range spread, merit increase matrices, and pay equity adjustments in a free HR analytics lab.

Compensation Grade Presets

Load benchmark total rewards pay bands.

Step 1: Configure Base Salary & Grade Structure

Salary Structure & Merit Inputs

Employee's current annualized pay.
Pay range lower boundary.
100% target market rate.
Pay range upper cap.

Annual performance review calibration score.
Target annual payroll increase budget.

Compensation KPIs

Compa-Ratio
94.6%
Developing / Entry-in-Grade Zone
Range Penetration
36.5%
Range Spread: 50.0% ($148k - $222k)
Recommended Merit Raise
+4.83% (+$8,453)
Merit matrix adjustment recommendation
Adjusted Base Salary
$183,453
Post-merit compa-ratio: 99.2%

Department Merit Matrix & Pay Equity Distribution Table

Employee Profile Current Salary Performance Compa-Ratio Penetration Merit Raise New Annual Base

Total Rewards Architecture

Principles of Salary Grade Management

Compa-ratios establish internal equity and market competitiveness:

  • 80% - 90% (Developing / Green-Circle): Entry-level proficiency in role. Eligible for larger percentage merit increases to reach market midpoint rapidly.
  • 95% - 105% (Market Midpoint Parity): Fully seasoned, fully competent professional meeting expectations. Receives standard merit budget increases.
  • 115% - 120%+ (High Tenured / Red-Circle): Top subject-matter expert or at risk of exceeding range maximum. Merit increases are moderated or delivered as lump-sum bonuses to avoid permanent wage distortion.
  • Merit Matrix Alignment: Ensures higher pay increases reward high performance and close pay equity gaps.

Measure workforce output in the Labor Productivity Lab.

Mathematical Compensation Equations

Compa-ratio formulas

Compa-Ratio (%) = (Base Salary ÷ Grade Midpoint) × 100%

Range Penetration (%) = [(Salary - Min) ÷ (Max - Min)] × 100%

Range Spread (%) = [(Max - Min) ÷ Min] × 100%

Midpoint Gap ($) = Base Salary - Grade Midpoint

Recommended Raise ($) = Base Salary × (Merit Pool % × Matrix Factor)

Calculate replacement drag in the Turnover Cost Lab.

FAQ

Compa-ratio & compensation planning questions

What is a compa-ratio in compensation planning?

A compa-ratio (comparative ratio) compares an employee's actual base salary to the midpoint of their salary grade: Compa-Ratio = (Base Salary / Range Midpoint) * 100%. A ratio of 100% indicates the employee is paid exactly at the competitive market rate.

What does a compa-ratio above or below 100% mean?

A compa-ratio below 80-90% indicates a developing employee or potential pay compression risk (green-circled), while 95-105% indicates seasoned competency at market parity. A ratio above 115-120% signals an exceptional performer or a red-circled employee approaching the salary cap.

What is salary range penetration?

Range penetration measures an employee's salary position within the entire pay band from minimum to maximum: Range Penetration = ((Salary - Min) / (Max - Min)) * 100%.

How is salary range spread calculated?

Range spread measures the breadth of a salary grade: Range Spread = ((Max - Min) / Min) * 100%. Entry-level roles typically have 30-40% spread, while executive roles often have 50-65% spread.

How does a merit increase matrix work?

A merit matrix allocates higher percentage raises to top-performing employees situated in lower compa-ratio quartiles to accelerate their pay to market parity while slowing salary growth for employees near the top of the pay band.

Can I export the compensation analysis to CSV?

Yes. You can export complete compa-ratios, range penetration, merit increase adjustments, and adjusted payroll figures as a UTF-8 CSV spreadsheet with formula defense.

Continue Exploring Staffing & Capacity Tools

Explore our Staffing & Capacity Hub, model labor efficiency in Labor Productivity Lab, calculate call center staffing in Erlang C Lab, measure unplanned absence drag in Absenteeism Lab, or evaluate employee retention ROI in Turnover Cost Lab.