A clear, defensible way to set pay by level and location, based on market data you research yourself.
The calculator uses all of these. Agree on what they mean before you build anything.
Plan for a few weeks the first time. After that, an annual refresh takes a few days.
Define 5 to 8 levels by scope and impact. Place each role and person at a level based on the work they actually do.
For each role, level, and location, research current pay from at least two sources. Record the source and date.
Set midpoints from your market data, apply location differentials and range spreads, and round to clean numbers.
Compare every employee to their band. Plan how to address anyone below minimum, and review with counsel.
Markets move. Re-research market rates at least once a year, before your merit and promotion cycle, and update the bands before you make offers or raises.
Plus the editable Excel template.