Free workforce planning calculator 2026. Build a year-by-year headcount and hiring plan from a revenue target, revenue per employee and attrition (backfill included); measure absenteeism rate, cost and Bradford factor; calculate span of control, layers and management cost; check labor efficiency, variance and labor cost per unit.
Headcount plan: enter current headcount, the planning horizon and your annual attrition rate, then size the target either from a revenue goal (current revenue, target revenue and how much revenue per employee should improve each year) or by typing the target headcount. You get a year-by-year table of growth, expected departures and the hires that cover both, the share of hiring that is pure backfill, hires per month, and the end state in FTE.
Absenteeism: enter employees, scheduled working days per employee, unplanned absence days across the workforce, average daily pay and an indirect-cost multiplier for cover and lost output. You get the absence rate, days per employee, the FTE missing on an average day, direct and total cost, cost per employee and the saving from each point of absence rate. A separate card scores one employee's Bradford factor from spells and days.
Span of control: enter total employees, people managers, loaded cost per manager and per contributor, and a target span to test. You get the average span, management ratio, approximate layers, the cost of the management layer, and how many managers the target span needs with the annual cost difference.
Labor efficiency: enter the standard hours for the output produced, actual hours worked and loaded hourly cost; optionally units, revenue and employees. You get efficiency, the hours and dollar variance, labor cost per unit, units and revenue per labor hour, labor cost as a share of revenue and revenue per employee.
Links from the old headcount, workforce capacity, absenteeism, span of control and labor efficiency calculators open the matching tab; each tab keeps its own history.
A headcount plan is a hiring plan with attrition built in: every year the business has to replace the people who leave before it can grow, and because departures are a share of the average headcount, growth itself raises the backfill bill. Sizing the target from revenue per employee makes the productivity assumption explicit, so a plan that quietly assumes each person will generate more revenue is visible as such. Absenteeism, span of control and labor efficiency are the three measures of how well the headcount you have is used: how often people are not there, how much of the payroll is spent managing rather than doing, and how many hours the work really takes against how many it should.
Revenue per employee $24,000,000 ÷ 120 = $200,000; at +3% a year it is $218,545 in year 3, so the target is $45,000,000 ÷ $218,545 ≈ 206 people (225 with flat productivity). Year 1: 120 → 149, 20 leave, 49 hires; Year 2: 149 → 177, 24 leave, 52 hires; Year 3: 177 → 206, 29 leave, 58 hires. Total 159 hires, 46% backfill.
Target 120 in one year at 15% attrition: departures 15% × 120 = 18, so 18 hires (about 1.5 a month) just to hold headcount.
1,100 ÷ (150 × 228) = 3.22%; 7.3 days each; 4.8 FTE absent on an average day. Cost 1,100 × $260 = $286,000, × 1.5 = $429,000 ($2,860 per employee). Each point of absence rate = $133,380.
6 spells, 9 days: 6² × 9 = 324 (concern). One 10-day absence = 10; ten 1-day absences = 1,000.
(240 − 40) ÷ 40 = 5; management ratio 16.7%; ≈ 4 layers; management layer $6,600,000 a year. At a span of 8: 25 managers (−15), 3 layers, saving $825,000 if surplus managers become contributors.
6,400 ÷ 7,100 = 90.1%; variance −700 hours × $32 = −$22,400. 16,000 units: $14.20 labor per unit (standard $12.80), 2.25 units per hour. $480,000 revenue: $67.61 per hour, labor 47.3% of revenue, $11,429 per employee for the month.
| Year | Start | Growth | Departures | Hires | Hires per month | End |
|---|---|---|---|---|---|---|
| Year 1 | 120 | +29 | −20 | 49 | 4.1 | 149 |
| Year 2 | 149 | +28 | −24 | 52 | 4.3 | 177 |
| Year 3 | 177 | +29 | −29 | 58 | 4.8 | 206 |
| Total | 120 | +86 | −73 | 159 | 4.4 | 206 |
Revenue per employee $200,000 today, $218,545 after 3% a year for 3 years, so the $45,000,000 target needs 206 people rather than 225 with flat productivity. 46% of all hires only replace leavers; with zero attrition the plan would need 86 hires instead of 159.
| Absence pattern | Spells | Days | Score (spells² × days) | Common reading |
|---|---|---|---|---|
| One long absence | 1 | 10 | 10 | Low |
| 2 separate absences | 2 | 10 | 40 | Low |
| 5 separate absences | 5 | 10 | 250 | Concern |
| 10 separate absences | 10 | 10 | 1,000 | High |
| 3 separate absences | 3 | 3 | 27 | Low |
| 8 separate absences | 8 | 8 | 512 | High |
Ten days off in one spell scores 10; the same ten days as ten single days scores 1,000. Trigger points of 50, 125 and 400 are common in attendance policies but are conventions, not law, and the score is a prompt for a conversation, not a judgment about genuine illness.
| Target span | Managers needed | Change vs today | Layers (approx.) | Annual cost difference |
|---|---|---|---|---|
| 3 | 67 | +27 | 5 | costs $1,485,000 |
| 5 | 40 | — | 4 | — |
| 8 | 25 | −15 | 3 | saves $825,000 |
| 12 | 17 | −23 | 3 | saves $1,265,000 |
| 20 | 10 | −30 | 2 | saves $1,650,000 |
Today: 40 managers, span 5, 16.7% of headcount in management, 4 layers. Cost differences assume a manager costs $165,000 and a contributor $110,000 fully loaded, and that surplus managers return to contributor roles. Narrow spans suit complex or novel work; 5–8 is typical of knowledge work; 9–15 suits experienced teams on well-defined work.
The example company has 120 people generating $24,000,000, $200,000 each, and wants $45,000,000 in 3 years. If each person keeps producing the same revenue it needs 225 people; with revenue per employee improving 3% a year it needs 206, a difference of 19 salaries that the plan should be able to defend. Growth from 120 to 206 is only 86 net additions, but at 15% attrition the company also loses 73 people over the horizon, so recruiting has to make 159 hires — 4.4 a month — and 46% of them only replace leavers.
Attrition is charged on the average headcount of each year, which is why the departures column grows as the company does, and why plans that apply the rate to the opening headcount under-hire. Even standing still has a cost: holding 120 people for a year at 15% attrition takes 18 hires. With zero attrition the three-year plan would need 86 hires instead of 159; each point of attrition reduced is worth roughly 5 fewer hires over the horizon, before counting the cost per hire and the productivity lost during ramp-up. Headcount here means people on payroll, full-time, part-time and temporary; contractors are a separate line.
150 employees scheduled for 228 days each give 34,200 scheduled days; 1,100 unplanned absence days is an absence rate of 3.22%, 7.3 days per person, and the equivalent of 4.8 full-time employees missing on any given day. Approved vacation and holidays are not absenteeism; the measure is about unplanned absence, which is why scheduled days are counted after planned time off. At $260 of daily pay the absent days cost $286,000 in salary alone; with a 1.5× multiplier for cover, overtime and lost output the real cost is $429,000, $2,860 per employee. Each point of absence rate is worth $133,380: cutting absence to 760 days (2.22%) saves $132,600 a year.
The Bradford factor looks at one person rather than the workforce. Multiplying the square of the number of spells by the total days absent makes frequent short absences score far higher than one long one: 1 spell of 10 days scores 10, 10 single days score 1,000. The example employee with 6 spells totaling 9 days scores 324, inside the band many policies treat as a trigger for a formal attendance review. Use it to spot patterns worth a conversation, apply it consistently, and remember that disability-related and protected leave should be excluded from any trigger-based process.
240 employees with 40 people managers is a span of 5 — 200 contributors ÷ 40 — with 16.7% of headcount in management and roughly 4 layers from the top to the front line. At $165,000 per manager the management layer costs $6,600,000 a year. Spans below 5 are typical where the work is complex, novel or needs close coaching; 5–8 is the most common range in knowledge work; 9–15 suits experienced teams doing similar, well-defined work; beyond that, managers mostly schedule and escalate. None of these is a target in itself: the right span depends on the work, the experience of the team and how much of the manager's week is their own output.
The target-span test turns the ratio into money. Moving to a span of 8 needs 25 managers, 15 fewer than today, and saves $825,000 a year if those managers return to contributor roles at $110,000 — it also removes a layer (3 instead of 4), which usually matters more than the saving. Going the other way to a span of 4 adds 10 managers and $550,000 a year. The reference table runs the same arithmetic for spans from 3 to 20.
Efficiency compares the hours the work should have taken with the hours it did. The example team produced output with a standard of 6,400 hours in 7,100 actual hours: 90.1% efficiency, an unfavorable variance of 700 hours worth $22,400 at $32 an hour. Per unit, labor cost is $14.20 against a standard of $12.80. Had the same output taken 6,200 hours, efficiency would be 103.2% and the variance a favorable $6,400. Variances in either direction deserve a look: a large favorable variance often means the standard is stale rather than the team heroic.
Productivity is output per input without reference to a standard: 2.25 units and $67.61 of revenue per labor hour, labor at 47.3% of revenue, $11,429 of revenue per employee for the period (a month here: 7,100 hours across 42 people is about 169 hours each). The two can move apart: a shift toward harder, higher-value work can lower efficiency against the old standards while raising revenue per hour. Track both, and reset standards when the work changes.
Find answers to the most common questions about workforce planning calculator.
Hires = growth + departures, year by year. Departures are your attrition rate applied to the average headcount for the year. The example grows from 120 to 206 over 3 years (86 net) but needs 159 hires because 73 people are expected to leave.
Divide the revenue target by revenue per employee. Use today's figure ($200,000 in the example) for a conservative plan, or let it improve by a stated percentage each year: at +3% the $45,000,000 target needs 206 people instead of 225. Write the assumption down; it is the plan's biggest lever.
Your own trailing twelve months: leavers ÷ average headcount. If you have no history, BLS JOLTS publishes monthly quits and total separations rates by industry that you can annualize, and the Employee Turnover calculator computes your rate from headcount and separations. The example uses 15%.
Its projection is the Headcount plan tab here, extended from one year to a multi-year plan with a revenue-based target. The FTE calculator still converts part-time hours to full-time equivalents and checks the ACA 50-FTE threshold.
Unplanned absence days ÷ scheduled working days, across the workforce: 1,100 ÷ 34,200 = 3.22% in the example. Count scheduled days after planned time off and exclude approved vacation; include sickness, no-shows and other unplanned absence. BLS publishes the absence rate of full-time wage and salary workers, which runs around 3% of usual hours, as a national reference.
At minimum the pay for the days missed: 1,100 × $260 = $286,000 in the example. Cover, overtime, lost output and management time add to that; a multiplier of 1.5× gives $429,000, or $2,860 per employee. Each point of absence rate is worth $133,380 a year at these figures.
Spells² × total days absent over a rolling year, usually 52 weeks. It weights frequency: ten single days score 1,000, one ten-day absence scores 10. Policies commonly use 50 as an informal trigger, 125 for a formal review and 400 for serious concern, but these are conventions. The example employee (6 spells, 9 days) scores 324.
It depends on the work. Under 5 direct reports suits complex, novel or closely coached work; 5–8 is typical in knowledge work; 9–15 suits experienced teams on well-defined tasks; 15 or more suits transactional work. The example's span of 5 is at the narrow end of moderate; moving to 8 would need 25 managers instead of 40.
Span = employees without reports ÷ employees with reports: (240 − 40) ÷ 40 = 5. Management ratio = managers ÷ total = 16.7%. Layers are roughly log(total) ÷ log(span), about 4 here.
Standard hours for the output produced ÷ actual hours worked: 6,400 ÷ 7,100 = 90.1%. Below 100% the gap is the efficiency variance, 700 hours or $22,400 at $32 an hour. Within about 10% of standard is usually treated as on target.
Efficiency compares actual hours with a standard for the same output; productivity is output per hour or per employee with no standard. The example is 90.1% efficient and produces 2.25 units and $67.61 of revenue per hour. Harder work can lower efficiency against old standards while raising revenue per hour, so track both.
They are the second, third and fourth tabs of this page, alongside the headcount plan they inform. Their links open the right tab and each tab keeps its own saved history.
The figures and rules behind this calculator come from the publications below. Each link goes to the issuing agency, so you can check the current rate yourself.
U.S. Bureau of Labor Statistics — Monthly hires, quits and separations rates by industry
U.S. Bureau of Labor Statistics — National absence rate (hours absent as a share of usual hours) used as the reference point for absenteeism
Results are estimates for planning and double-checking, not tax, legal or payroll advice. How we choose sources, how often rates are updated and how to report an error: editorial policy.
Leavers ÷ average headcount per year
To show the end state in FTE
0 = headcount scales with revenue
Hires needed over 3 years
159
headcount 120 → 206 (+86) · 73 expected leavers to replace · about 4.4 hires a month · 206 FTE at 40 h/week
| Year | Start | Growth | Departures | Hires | Per month | End |
|---|---|---|---|---|---|---|
| Year 1 | 120 | +29 | −20 | 49 | 4.1 | 149 |
| Year 2 | 149 | +28 | −24 | 52 | 4.3 | 177 |
| Year 3 | 177 | +29 | −29 | 58 | 4.8 | 206 |
| Total | 120 | +86 | −73 | 159 | 4.4 | 206 |
Backfill share of hiring
46%
73 of 159 hires only replace leavers
Hires with zero attrition
86
growth alone
Revenue per employee
$200,000
→ $218,545 at the target
Target with flat productivity
225
19 more people than with the gain
Each year: departures = attrition × average of start and end headcount; hires = growth + departures. Headcount counts people on payroll (full-time, part-time, temporary); contractors are excluded. Revenue-based sizing divides the revenue target by revenue per employee after the productivity gain compounds for the horizon.