Employee COLA Allocation Calculator
Apply specified adjustments across employees.
Employee COLA Allocation Calculator: Scenario Inputs
Annual percentage rate or benchmark index change.
Inflation & Purchasing Power Analysis
Over 3 years at 3.5% inflation, a $75,000 salary requires $83,154 to retain equal purchasing power. Without matching raises, your real compensation experiences an effective reduction of $7,355 (-9.81%).
Need complete multi-year compound modeling?
Run detailed comparisons, custom CPI series, and visual breakdown charts.
How Employee COLA Allocation Calculator Works?
The Employee COLA Allocation Calculator splits one fixed budget under each rule. It compares how much each employee receives under each approach.
Enter employees
Type each employee's salary, or upload a list.
Set the COLA budget
Type the total budget or a percentage of payroll.
Pick the allocation rule
Choose equal percentage, equal dollar or a hybrid split.
Review allocations
The output lists each employee's increase in dollars and percent.
Employee COLA Allocation Calculator Formula
The Employee COLA Allocation formula splits the budget by salary share or by headcount.
Increasee = Salarye × (Budget ÷ Payroll)
Increasee = Budget ÷ Headcount
Increasee = w × Equal % amount + (1 − w) × Equal $ amount
Variables
- Budget
- Total COLA budget
- Payroll
- Total salaries of covered employees
- w
- Weight on the percentage rule
Worked example
A 3% budget on a $362,000 payroll equals $10,860. Equal dollars give each of 5 employees $2,172, which is 5.72% for the $38,000 earner and 1.81% for the $120,000 earner.
Employee COLA Allocation Calculator Conversion Table
This table splits a $10,860 COLA budget across 5 employees under 3 rules.
| Employee | Salary | Equal 3% | Equal dollar | Equal dollar as % | 50/50 hybrid |
|---|---|---|---|---|---|
| Employee A | $38,000 | $1,140 | $2,172 | 5.72% | $1,656 |
| Employee B | $52,000 | $1,560 | $2,172 | 4.18% | $1,866 |
| Employee C | $67,000 | $2,010 | $2,172 | 3.24% | $2,091 |
| Employee D | $85,000 | $2,550 | $2,172 | 2.56% | $2,361 |
| Employee E | $120,000 | $3,600 | $2,172 | 1.81% | $2,886 |
What is Employee COLA Allocation Calculator?
The Employee COLA Allocation Calculator is a tool that splits a cost-of-living adjustment (COLA) budget across employees using a chosen rule: equal percentage, equal dollar amount or a hybrid. The rule decides who receives the larger share of the budget.
An equal-percentage COLA gives more dollars to higher earners. An equal-dollar COLA gives a larger percentage to lower earners.
What are the uses of Employee COLA Allocation Calculator?
There are 4 main uses of the Employee COLA Allocation Calculator.
Support lower earners
Give larger percentage COLAs to staff hit hardest by price rises.
Stay within budget
Split a fixed budget under any rule without overspending.
Compare fairness options
Show leaders the effect of each rule by employee.
Document decisions
Record the rule and results for pay equity reviews.
Related COLA & Adjustments Calculators
Browse all 140+ toolsRetroactive COLA Calculator
Apply a specified adjustment to prior pay periods.
COLA Schedule Calculator
Model recurring cost
COLA Calculator
Calculate a cost-of-living pay adjustment.
Capped COLA Calculator
Apply a maximum adjustment rate.
Floored COLA Calculator
Apply a minimum adjustment rate.
Capped-and-Floored COLA Calculator
Apply both adjustment limits.