Calculator Form
Use this stacked page layout with a responsive calculator grid: three columns on large screens, two on smaller screens, and one on mobile.
Example Data Table
This worked example shows how grouped salaries and weights combine into one weighted average salary.
| Group | Base Salary | Employees | Adjustment % | Adjusted Salary | Weighted Value |
|---|---|---|---|---|---|
| Engineering | $92,000.00 | 14 | 3.00% | $94,760.00 | $1,326,640.00 |
| Sales | $68,000.00 | 9 | 4.00% | $70,720.00 | $636,480.00 |
| HR | $54,000.00 | 5 | 2.00% | $55,080.00 | $275,400.00 |
| Support | $48,000.00 | 12 | 1.00% | $48,480.00 | $581,760.00 |
| Total | 40 | - | Weighted Average Salary | $2,820,280.00 | |
Example weighted average salary: $70,507.00 because $2,820,280.00 ÷ 40 = $70,507.00.
Formula Used
Weighted Average Salary = Σ(Adjusted Salary × Weight) ÷ Σ(Weight)
Adjusted Salary = Base Salary × (1 + Adjustment % ÷ 100)
Each group salary is scaled by its chosen weight. If you use employee count, larger teams influence the result more than smaller teams.
If you enter an adjustment percentage, the calculator updates that row before applying the weight. This helps model raises, regional premiums, or market changes.
The weighted salary value is useful for budgeting because it combines pay level and group size into one clear figure.
How to Use This Calculator
- Choose your currency, weight basis, and decimal preference.
- Enter one row for each department, grade, location, or scenario.
- Provide the average salary and the matching weight for that row.
- Add an optional adjustment percentage if you want a modeled increase or decrease.
- Click the calculate button to place the result below the header and above the form.
- Review the summary cards, detailed table, and Plotly graph.
- Download the current result as CSV or PDF for reporting.
- Use the add row button whenever you need more salary groups.
FAQs
1) What does weighted average salary mean?
Weighted average salary multiplies each salary by its assigned weight, adds those products, then divides by the total weight. It is more realistic than a simple mean when teams, grades, or workloads are not equal.
2) When should I use employee count as the weight?
Use employee count when each row represents a group of people sharing a typical salary. The result then estimates the combined average pay across the represented workforce.
3) Can I use hours or FTE instead of headcount?
Yes. Hours, FTE, and custom weights all work. The calculator still multiplies each salary by its weight, then divides by the total weight.
4) Why include adjustment percentages?
Adjustment percentages help model raises, location premiums, market shifts, or cost corrections. Each adjustment changes the row salary before the weighted average is calculated.
5) What happens if a row has zero weight?
A zero-weight row has no influence on the result. This page requires weights above zero for included rows, which protects the formula from meaningless inputs and divide-by-zero problems.
6) Is weighted average salary the same as payroll per employee?
Not always. They match when the weight is employee count and each salary is per person. Other weight types create a different planning view.
7) Can I compare departments with different sizes?
Yes. Weighted averages are useful for comparing departments, locations, and job bands because they reflect both pay level and relative size.
8) Do the downloads include my submitted data?
Yes. The CSV and PDF exports use the current calculated result, including row details, totals, weighted average, and adjustment effects shown after submission.