Average compa-ratio
1
Below band
2
Above band
1
Salary Bands & Pay Equity Review
Compare each employee’s pay with the band for their level and find who is under, over or out of line.
SpreadsheetPayroll & CompensationFree
Forecast salary, employer taxes and benefits for every role by month and department, including new hires, leavers and merit.
Shown with sample data
Forecast salary, employer taxes and benefits for every role by month and department, including new hires, leavers and merit.
Latest: 13
Build next year’s people budget from the bottom up. List every current employee and planned hire with salary and start and end month; the model applies the merit increase from its effective month, adds employer payroll taxes and benefits per head, and produces the fully loaded labour cost for each person, each month and each department, with month-by-month headcount and variance against your budget.
Salary plus employer payroll taxes plus employer-paid benefits (and other on-costs such as retirement contributions or equipment). This model uses salary × (1 + tax rate) + benefits per head × months employed.
In the US, FICA is 7.65% up to the social security wage base, plus federal and state unemployment taxes and workers’ compensation. Many employers use a blended 9–12%. Other countries differ widely; use your payroll provider’s figure.
Each salary rises by the merit % from the effective month to the end of the year, so an April increase affects nine months of cost.
The first and last month the person is on payroll this year: 1 to 12 for a full year, a later start for new hires and an earlier end for planned leavers.
Download a copy
Downloads need a free account.