Building a Data‑Driven Merit Increase Model Using Compa Ratios for a Mid‑Sized Professional Services Firm

Case Study

Client Overview

A mid‑sized auditing and advisory firm with approximately 250 employees sought to modernize its annual compensation review process. Historically, the company relied heavily on manager discretion and manual spreadsheets, resulting in:

Inconsistent merit increases across departments
Limited insight into how employees were positioned within their salary ranges
Challenges maintaining internal equity and market competitiveness
A time‑consuming, error‑prone planning process for HR and leadership

The firm needed a structured, transparent, and analytics‑driven approach that aligned pay decisions with both market data and employee performance.

Objective

InteGreat Solutions was engaged to design a centralized compensation planning model that would:

Consolidate employee compensation and performance data into a single, standardized census
Measure each employee’s position within their salary band
Incorporate performance ratings into merit decisions
Use compa ratios to guide equitable and market‑aligned pay adjustments
Standardize and automate the annual merit increase calculation process

The goal was to enable data‑driven decisions, ensure internal equity, and significantly streamline compensation planning.

Frequently Asked Questions

Why were compa ratios chosen as the foundation of the merit model?

Compa ratios provide an objective benchmark for evaluating how an employee’s pay compares to the market midpoint for their role. They allow for equitable and consistent adjustments based on both market position and performance.

Can this model scale to much larger organizations?

Yes. The model is designed to scale for organizations with hundreds or thousands of employees by leveraging centralized data structures and automated logic.

Does this approach work with any HRIS or payroll system?

Absolutely. The census pulls from any HRIS, payroll, or performance management platform. The key requirement is access to core employee and salary data.

What if an organization does not have well‑defined salary bands?

InteGreat Solutions can help develop or modernize salary structures before implementing the merit model.

Can the merit matrix be customized to different compensation philosophies?

Yes. The matrix can reflect conservative, market‑based, or aggressive pay strategies depending on company culture and financial guidance.

Solution

1. Centralized Employee Census Development

We created a comprehensive employee census by integrating data from HRIS, payroll, and performance systems. The dataset included:

Job title, department, and job level
City for cost of living adjustments (location index factor for the bands)
Current salary
Salary band minimum, midpoint, and maximum
Tenure and time in role
Performance score (1–5)

This unified dataset became the foundation of all compensation analytics.

2. Salary Band Mapping Across the Organization

The firm’s salary structures were incorporated into the model, aligning each employee with the appropriate job band. This provided immediate visibility into:

Market alignment
Internal pay relationships
Compression patterns across junior, mid‑level, and senior roles

3. Compa Ratio Calculation and Analysis

Using an industry‑standard formula, we calculated compa ratios for all employees:

Compa Ratio = Salary ÷ Midpoint

This metric enabled the firm to clearly identify:

Employees below market (ratio < 0.8)
Employees aligned to market (ratio ≈ 1.0)
Employees paid above market (ratio > 1.2)

Compa ratios became a core element in determining merit increase eligibility and magnitude.

4. Integrating Performance Ratings

Annual performance scores were mapped to rating categories from “Unsatisfactory” to “Exceptional.” These ratings formed the primary driver of merit increases and were embedded directly into the planning model.

5. Designing a Merit Increase Matrix

We developed a merit matrix that cross‑referenced performance ratings with compa ratio ranges.

Performance	Compa <0.85	Compa 0.85–0.95	Compa 0.95–1.05	Compa >1.05
5	0.07	0.06	0.05	0.03
4	0.05	0.04	0.03	0.02
3	0.03	0.025	0.02	0.01
2	0.01	0	0	0

The matrix ensured:

Higher increases for strong performers
Larger increases for employees below midpoint
Controlled increases for employees already above market

This eliminated discretionary bias and standardized pay decisions across all departments.

6. Automating Merit Recommendations

We automated merit calculations using spreadsheet logic to display:

Recommended merit %
Resulting salary increase
New salary
Updated compa ratio

HR and leadership could model multiple scenarios in minutes instead of days, dramatically improving the planning cycle.

Results

1. Stronger Pay Equity and Market Alignment

The analysis uncovered groups of high performers who were significantly below midpoint, enabling targeted corrections and improved internal equity.

2. Standardized and Transparent Decision‑Making

Managers used a unified merit matrix, reducing subjective decisions and ensuring consistent application of compensation philosophy.

3. Clearer Visibility Into Workforce Compensation

HR gained a real‑time view of salary distribution, band penetration, and compression risks across all job families.

4. Dramatic Reduction in Planning Time

What previously took multiple weeks of manual spreadsheet consolidation was reduced to a streamlined review completed within days.

5. Actionable Insights for Workforce Strategy

The model surfaced critical findings, including:

Employees stagnating at the bottom of pay ranges
Compression between early‑career and senior roles
High performers approaching or exceeding maximums

These insights informed both compensation decisions and broader talent strategies.

Key Takeaways

By implementing a centralized compensation planning model grounded in compa ratio analytics, the firm replaced a subjective, manual merit review process with a transparent and data‑driven framework.

The new model delivered:

Fair, consistent, and performance‑aligned merit increases
A scalable, repeatable annual review process
Rich insights into internal pay equity and market alignment
Significant time savings for HR and leadership

This methodology now serves as the organization’s standard approach for merit planning and compensation governance across all 250 employees.