Plan Your Salary Budget
Use the fields below to forecast payroll, merit increases, promotion cost, hiring cost, employer burden, and contingency reserve.
Example Data Table
| Team | Headcount | Average Salary | Merit % | Bonus % | Estimated Team Budget |
|---|---|---|---|---|---|
| HR Operations | 10 | $58,000 | 4.0% | 6.0% | $787,640 |
| Talent Acquisition | 8 | $61,500 | 4.5% | 7.0% | $697,656 |
| People Analytics | 6 | $73,000 | 5.0% | 8.0% | $571,188 |
| Learning & Development | 5 | $56,000 | 4.0% | 5.0% | $361,760 |
This table is illustrative. Your actual result depends on the assumptions entered in the calculator.
Formula Used
1) Current Base Payroll
Current Base Payroll = Current Headcount × Average Current Salary
2) Merit Increase Cost
Merit Cost = Current Base Payroll × Merit Increase %
3) Promotion Cost
Promotion Cost = Current Base Payroll × Promotion Share % × Promotion Uplift %
4) Planned Hire Payroll
Hire Payroll = Planned Hires × Average New Hire Salary × (Months Funded ÷ 12)
5) Attrition Vacancy Savings
Attrition Savings = Current Base Payroll × Attrition % × (Vacancy Months ÷ 12)
6) Adjusted Base Payroll
Adjusted Base Payroll = Current Base + Merit + Promotion + Market Adjustment + Hire Payroll − Attrition Savings
7) Total Annual Budget
Total Budget = Adjusted Base Payroll + Bonus + Benefits + Payroll Tax + Other Costs + Contingency
How to Use This Calculator
Step 1: Enter your current headcount and average base salary.
This builds the starting payroll level for the forecast.
Step 2: Add expected hires, salary levels, and funded months.
This estimates the payroll impact of growth during the planning period.
Step 3: Enter merit, promotion, and market adjustments.
These fields model internal pay movement and external competitiveness.
Step 4: Add bonus, benefits, payroll tax, and support budgets.
This converts base payroll into a fuller employer cost forecast.
Step 5: Include attrition and average vacancy timing.
This estimates temporary salary savings caused by open roles.
Step 6: Review the summary, table, graph, and export files.
Use the outputs for workforce planning, finance review, and approval meetings.
Frequently Asked Questions
1) What does this salary budget planner measure?
It estimates total annual people cost, not just base pay. It combines salary, raises, promotions, hiring, bonuses, benefits, payroll tax, and other workforce expenses into one forecast.
2) Why include vacancy months for attrition?
Vacancy time often lowers payroll spending because a role remains unfilled temporarily. This tool treats that gap as a short-term savings estimate within the annual plan.
3) Should benefits and payroll tax be based on adjusted payroll?
Yes. Many employers apply those costs to the updated payroll level after raises, promotions, market changes, and planned hiring are considered.
4) Can I use this for one department only?
Yes. Enter headcount and assumptions for a single department, region, or job family. The model works at team level or companywide level.
5) What is employer cost loading?
Employer cost loading shows how much total budget sits above adjusted base payroll. It helps explain the burden created by bonus, tax, benefits, and support programs.
6) Why use a contingency reserve?
A reserve helps absorb uncertain items like off-cycle adjustments, unexpected backfills, benefits inflation, or unplanned retention actions during the year.
7) Does this calculator replace detailed compensation planning?
No. It is a planning model for fast forecasting. Detailed compensation decisions still need market data, pay ranges, approvals, and employee-level review.
8) Can I compare multiple scenarios?
Yes. Run the calculator several times with different assumptions for raises, hiring pace, attrition, or benefits. Then export each result for side-by-side comparison.