Enter each group’s average salary and the chosen weight (e.g., headcount). Subtotals and totals update automatically. Fields with a red border need attention.
| Group / Team | Average salary | Headcount | Subtotal | Remove |
|---|---|---|---|---|
| Total | 0 | 0 |
Weighted average salary
0
Total weight: 0
Total payroll: 0
Rows: 0
Currency: PKR
Weights: Headcount
Formula used
Let the average salary for group i be Si and its weight be wi (e.g., headcount, FTE, or hours). The weighted average salary is:
Weighted Average = (Σ (S_i × w_i)) / (Σ w_i)The total payroll equals Σ (Si × wi). When weights are headcount, this payroll is the modeled annual cost.
How to use this calculator
- Select a currency and the weight type label you prefer.
- Enter each group’s average salary and its weight. Add rows as needed.
- Watch subtotals, totals, and the weighted average update automatically.
- Fix any fields highlighted red; negative or blank values are invalid.
- Click Download CSV to export the dataset and results.
- Click Download PDF for a formatted summary with your table.
- Use the example dataset to explore the math and outputs quickly.
Example dataset
| Group | Average salary | Headcount | Subtotal (salary × count) |
|---|---|---|---|
| Engineering | 120,000 | 15 | 1,800,000 |
| Sales | 90,000 | 10 | 900,000 |
| Support | 60,000 | 8 | 480,000 |
| Totals | 33 | 3,180,000 | |
| Weighted average salary | 96,364 | ||
Calculation: (120,000×15 + 90,000×10 + 60,000×8) ÷ (15+10+8) = 96,363.64
Departmental salary mix (sample)
| Department | Average salary | Headcount | Subtotal |
|---|---|---|---|
| Engineering | 150,000 | 30 | 4,500,000 |
| Marketing | 95,000 | 12 | 1,140,000 |
| Operations | 70,000 | 20 | 1,400,000 |
| Totals | 62 | 7,040,000 | |
| Weighted average salary | 113,548.39 | ||
Computation: (150,000×30 + 95,000×12 + 70,000×20) ÷ 62 = 113,548.39
Hiring plan impact (scenario comparison)
Illustrates how staffing changes shift weighted averages and total payroll.
| Scenario | Groups (salary × weight) | Total weight | Total payroll | Weighted average |
|---|---|---|---|---|
| Current | Eng (120,000×15), Sales (90,000×10), Support (60,000×8) | 33 | 3,180,000 | 96,363.64 |
| Plan | Eng (125,000×20), Sales (90,000×10), Support (62,000×10) | 40 | 4,020,000 | 100,500.00 |
Region cost adjustment example
Applies regional cost factors to base salaries before computing the weighted average.
| Region | Avg salary | Headcount | Cost factor | Adjusted salary | Adjusted subtotal |
|---|---|---|---|---|---|
| AMER | 100,000 | 12 | 1.15 | 115,000 | 1,380,000 |
| EMEA | 85,000 | 15 | 1.00 | 85,000 | 1,275,000 |
| APAC | 60,000 | 20 | 0.85 | 51,000 | 1,020,000 |
| Totals | 3,675,000 | ||||
| Weighted average adjusted salary (47 total) | 78,191.49 | ||||
Frequently asked questions
Use headcount for people counts, FTE for partial staffing, or hours for hourly workloads. The math is identical—only the interpretation changes.
Yes. Average salary supports decimals, and weights can be fractional FTE or hours. Negative values are invalid and will be highlighted.
It is the sum of each group’s average salary multiplied by its weight: Σ(S×w). With headcount weights, this approximates modeled annual payroll cost.
The weighted average is undefined; this tool shows a note and 0. Add at least one valid weight to compute a meaningful result.
No. Currency only changes symbols and formatting. The calculations are numeric and unit-agnostic.
Your entries are auto-saved to your browser’s local storage. They reload on your next visit unless you click Reset.
Accuracy depends on the quality of your averages and weights. Use current salary medians and up-to-date headcounts or FTE allocations.