Eligible payroll
$964,000
Merit pool
$33,740
Increases allocated
$34,445
Merit Increase Planner
Recommend each pay rise from a performance × compa-ratio matrix and track spend against the merit budget pool.
SpreadsheetPayroll & CompensationFree
Compare each employee’s pay with the band for their level and find who is under, over or out of line.
Shown with sample data
Compare each employee’s pay with the band for their level and find who is under, over or out of line.
Fair pay needs a structure. Set a minimum, midpoint and maximum for each level; the sheet calculates each employee’s compa-ratio and position in the band, flags anyone below the minimum or above the maximum and totals the cost of bringing everyone into range.
Salary divided by the midpoint of the band. 1.00 means paid at midpoint; most employees should fall between 0.85 and 1.15.
Download a copy
Downloads need a free account.