HR Analytics

Chapter 12
Workforce Planning, Talent Segmentation and Optimization

Bachelors Program in Human Resource Management
HR Analytics   •   Bachelor

Workforce Planning, Talent Segmentation and Optimization

Introduction

Workforce planning translates organizational strategy into decisions about people, capabilities, employment arrangements and technology. It asks not merely how many employees will be required, but which capabilities must be available, where and when they are needed, and at what acceptable cost and risk.

Traditional headcount planning often extrapolates the current workforce. Strategic workforce planning is broader: it forecasts demand and supply, diagnoses capability gaps, evaluates scenarios, examines succession and mobility, and selects interventions. These interventions are often summarized as build, buy, borrow and bot—develop employees, hire externally, obtain contingent capacity or automate work.

Workforce plans are forecasts rather than certainties. Their value therefore depends on explicit assumptions, credible data, scenario analysis, ethical governance and continuous revision.

Learning Objectives

After studying this chapter, students should be able to:

  1. Forecast workforce demand and internal supply using appropriate quantitative and qualitative methods.
  2. identify workforce gaps by capability, time, location and workforce segment.
  3. Conduct scenario, succession, mobility and workforce diversity analyses.
  4. Explain the strategic and ethical foundations of talent segmentation.
  5. Formulate a workforce optimization model, including capacity constraints and unmet-demand penalties.
  6. Apply cost–benefit reasoning to build-buy-borrow-bot decisions.
  7. Design resilient workforce plans with triggers, contingencies and governance controls.

1. The Strategic Workforce Planning System

A workforce planning cycle begins with strategy and operating assumptions. Demand and supply are then estimated independently before their difference is assessed. Gap analysis informs interventions, implementation and monitoring. Monitoring produces feedback that revises assumptions and forecasts.

Strategic workforce planning cycle Strategy, dataand assumptions Demand forecastwork and capabilities Supply forecastinternal and external Gap analysisquantity and quality Interventionsbuild, buy, borrow, bot Implementationowners and resources Monitoringoutcomes and triggers
Strategic workforce planning cycle in which demand and supply both feed gap analysis
Figure: Strategic workforce planning cycle in which demand and supply both feed gap analysis

Figure: Demand and supply forecasts both precede gap analysis; monitoring feeds revised strategy, data and assumptions.

A credible plan must specify:

  • Planning horizon: operational, tactical or strategic.
  • Unit of analysis: headcount, full-time equivalent (FTE), productive hours, positions or capability units.
  • Segmentation: job family, skill, proficiency, location, business unit or employment arrangement.
  • Scenario assumptions: business volume, productivity, automation, turnover and labor-market conditions.
  • Decision criteria: service, cost, speed, quality, risk, inclusion and resilience.

Headcount and FTE should not be confused. Two employees working half time represent two people but one FTE. Capability units may also differ from FTE where proficiency or technology materially changes output.

2. Forecasting Workforce Demand

Workforce demand is the labor capacity and capability required to execute expected work. It is derived from future work, not automatically from current staffing.

2.1 Managerial judgment and the Delphi method

Managers can estimate staffing requirements where historical data are limited or strategy is changing. Structured expert methods, such as Delphi rounds, reduce the influence of hierarchy by collecting estimates independently and sharing anonymized feedback. Judgment remains vulnerable to optimism, anchoring and political bargaining, so assumptions should be documented and challenged.

2.2 Workload analysis

When workload and time standards are available, required FTE can be estimated as:

D = (Q × t) ÷ (H × a)

where:

  • D = required FTE;
  • Q = expected work volume, such as cases per year;
  • t = average productive labor hours per case;
  • H = paid hours per FTE during the period;
  • a = productive availability, expressed as a proportion between 0 and 1.

The numerator has units of labor hours. The denominator is productive hours per FTE, so the result is FTE. The method assumes a representative time standard and a sufficiently stable relationship between volume and labor time.

Worked example. A service center expects 36,000 cases next year. Each case requires an average of 0.40 productive hours. Each FTE is paid for 1,800 hours, of which 80% is productively available.

D = (36,000 × 0.40) ÷ (1,800 × 0.80) = 14,400 ÷ 1,440 = 10 FTE

If arrival patterns are highly variable, ten FTE may be insufficient during peaks even though annual capacity balances. Queueing, scheduling or hourly simulation may then be required.

2.3 Ratio and trend methods

A staffing ratio links workforce demand to a business driver:

Dt = r × Xt

Here Xt is the forecast business driver in period t, and r is the historical or benchmark labor ratio, such as advisers per 1,000 customers. Ratio methods are transparent but assume that productivity and work design remain reasonably stable.

Time-series models extrapolate historical patterns, while regression models estimate demand from one or more drivers. A simple model is:

Dt = β0 + β1Xt + εt

where β0 is the intercept, β1 is the estimated change in workforce demand per unit change in the driver, and εt represents unexplained influences. Regression supports inference only when model assumptions are examined. Structural change, omitted variables and extrapolation beyond observed data can make apparently precise forecasts misleading.

2.4 Task and capability forecasting

Automation changes tasks more often than it eliminates whole occupations. Demand analysis should therefore decompose jobs into tasks and identify whether each task is likely to be automated, augmented, retained or newly created. The resulting demand forecast should specify skills and proficiency levels—for example, “20 advanced cybersecurity analysts”—rather than only job titles.

3. Forecasting Workforce Supply

Supply analysis estimates which capabilities will be available from current employees and relevant external labor markets.

3.1 Stock-and-flow analysis

For a defined workforce segment, the basic accounting identity is:

St+1 = St + Ht + Tint + Rt − Et − Toutt

where St is workforce supply at the start of the period; Ht is hires; Tint and Toutt are transfers in and out; Rt is returns from extended leave; and Et is exits. Every term must use the same unit and period, such as annual FTE.

If a team starts with 120 FTE, hires 12, receives 4 transfers, has 3 employees return, loses 15 through exits and transfers 6 out, expected ending supply is:

St+1 = 120 + 12 + 4 + 3 − 15 − 6 = 118 FTE

3.2 Transition or Markov analysis

Transition analysis estimates movement among workforce states such as junior, senior, manager and exit. In matrix form:

nt+1 = ntP + et+1

Here nt is a row vector of employees or FTE in each state, P is a transition-probability matrix, and et+1 is a vector of external entrants. Each row of P must sum to 1 when states are mutually exclusive and collectively exhaustive, including exit. The method assumes that estimated transition rates remain sufficiently relevant. It is less reliable after mergers, policy changes or labor-market shocks.

3.3 Skills inventories and external supply

A skills inventory records verified capabilities, proficiency, experience, credentials, aspirations and mobility constraints. Self-reported data are useful but should be validated where decisions are consequential. External supply analysis examines graduate pipelines, occupational unemployment, wage pressure, geographic availability, visa rules, competitor demand and time-to-hire.

Supply should be risk-adjusted. An employee nominally possessing a skill may not be available at the required location, proficiency, date or capacity.

4. Capability-Gap Analysis

For a defined segment, the basic gap is:

Gk,t,l = Dk,t,l − Sk,t,l

where Gk,t,l is the gap for capability k, period t and location l. A positive value denotes a shortage and a negative value indicates a potential surplus. Demand and supply must be measured using comparable definitions and units.

A useful gap register contains:

FieldExample
CapabilityCloud security, advanced proficiency
Required dateQuarter 3 next year
Demand24 FTE
Risk-adjusted supply15 FTE
Gap9 FTE
Business consequenceDelayed regulatory certification
InterventionBuild 4, buy 3, borrow 2
Owner and triggerCIO; activate agency at gap forecast ≥2

Not every surplus justifies redundancy. Surplus capacity may be redeployed, reskilled, held as resilience capacity or reduced through natural attrition.

5. Scenario Planning and Workforce Resilience

A point forecast conceals uncertainty. Scenario planning constructs internally coherent futures based on influential uncertainties, such as demand growth and automation speed. A common design includes downside, base and accelerated scenarios.

Each scenario should contain:

  1. explicit assumptions;
  2. workforce demand and supply estimates;
  3. capability gaps and consequences;
  4. no-regret actions useful across scenarios;
  5. contingent actions activated by observable triggers.

Sensitivity analysis changes one assumption at a time. Scenario analysis changes several connected assumptions. Simulation can represent probability distributions and estimate ranges of outcomes, but distributions should not be assigned without evidence.

A resilient workforce plan balances efficiency with adaptability. Relevant mechanisms include cross-training, internal talent marketplaces, vendor frameworks, geographic diversification, succession depth and modular learning programs. Excessive reliance on any single labor source can create fragility.

6. Talent Segmentation

Talent segmentation differentiates workforce investments according to strategic contribution, capability scarcity, development needs or employment relationship. It does not imply that some people possess greater human worth.

Two related distinctions are important:

  • Position segmentation: identifies roles that have disproportionate influence on strategic outcomes.
  • Person segmentation: assesses individual readiness, performance, potential or specialized expertise.

Positions should generally be segmented before individuals. A transparent framework may consider strategic impact, scarcity, replacement time and consequence of vacancy. Segments might include pivotal roles, core professional roles, enabling roles and flexible capacity. The categories should guide differentiated actions such as succession depth or retention investment, not diminish fair treatment.

Poor segmentation can become self-fulfilling: employees classified as low potential receive less development and subsequently have fewer opportunities to demonstrate capability. Organizations should therefore use multiple forms of evidence, permit review and appeal, monitor group differences, and allow movement between segments.

7. Succession, Mobility and Diversity Analysis

7.1 Succession analysis

Succession planning protects continuity in critical positions and capabilities. A simple ready-now coverage measure is:

Coverage = Cs ÷ C

where Cs is the number of critical positions with at least one credible ready-now successor and C is the total number of critical positions. If 9 of 12 critical positions have a ready-now successor, coverage is 9 ÷ 12 = 75%. This measure does not reveal successor quality or whether the same person appears on several slates.

Additional measures include successors per critical role, readiness horizon, emergency coverage, concentration risk and demographic diversity of succession slates. Candidate consent, career aspiration and realistic availability should be considered.

7.2 Internal mobility

Mobility analysis studies transfers, promotions and skill-adjacent moves. A mobility network represents jobs as nodes and observed employee moves as links. It can identify feeder roles, bottlenecks and career pathways. Skills similarity may reveal feasible moves that historical data miss, but recommendations should account for required proficiency, employee interest, pay, location and accessibility.

A high mobility rate is not automatically desirable: repeated moves may disrupt operations, while low mobility may reflect either stability or blocked opportunity. Interpretation requires context.

7.3 Diversity and workforce-flow analysis

Representation is a stock measure; hiring, promotion and exit are flows that create future representation. Analysis should therefore compare rates at each decision stage.

For group g, the selection rate is:

SRg = Hg ÷ Ag

where Hg is the number selected and Ag is the number eligible or applying in group g. The selection-rate ratio is:

Selection-rate ratio = SRprotected ÷ SRreference

Suppose 16 of 80 applicants in a protected group and 30 of 100 applicants in a reference group are hired. The rates are 20% and 30%, respectively, so the ratio is:

0.20 ÷ 0.30 = 0.667

In some jurisdictions, a ratio below 0.80 is used as an initial adverse-impact screening indicator. It is not proof of unlawful discrimination, a universal legal standard or a substitute for statistical and contextual investigation. Small samples can produce unstable ratios. Analysts should consult applicable law and examine job relevance, process design and confidence intervals where appropriate.

8. Build-Buy-Borrow-Bot Decisions

OptionMeaningTypical advantagePrincipal risk
BuildDevelop current employeesRetains knowledge and supports careersTime to proficiency
BuyHire employees externallyAdds capability directlyScarcity, hiring delay and integration
BorrowUse contractors, partners or temporary laborFlexible and relatively fastDependency, knowledge leakage and legal classification
BotAutomate or augment tasksScalable, consistent processingImplementation failure, bias and work redesign needs

These options are not perfect substitutes. A bot may remove routine tasks while increasing demand for judgment and oversight. Contractors may provide short-term capacity but not organizational memory. Decision criteria should include speed, total cost, quality, reversibility, knowledge retention, employee impact, compliance and resilience.

8.1 Cost–benefit reasoning

Costs should include acquisition, learning time, management, technology integration, turnover and transition disruption. Benefits may include additional output, avoided vacancy loss, quality, risk reduction and strategic option value.

For cash flows over T periods, net present value is:

NPV = −I0 + ∑t=1T (Bt − Ct) ÷ (1 + r)t

where I0 is initial investment, Bt and Ct are period benefits and costs, and r is the discount rate per period. Financial NPV should not be the sole criterion where legal obligations, safety or material social effects are involved.

9. Workforce Optimization with Unmet-Demand Penalties

Optimization converts workforce choices into a transparent decision model. Let:

  • xB, xH, xR and xA denote capability units obtained through build, external hire, borrow and automation;
  • cB, cH, cR and cA denote cost per unit;
  • [[MATH{u}]] denote unmet demand, measured in the same capability units;
  • p denote the penalty per unit of unmet demand;
  • G denote the capability gap.

A basic model is:

Minimize Z = cBxB + cHxH + cRxR + cAxA + pu

subject to:

xB + xH + xR + xA + u ≥ G
0 ≤ xj ≤ Uj for j ∈ {B, H, R, A}, and u ≥ 0

Here Uj is the maximum feasible capacity of intervention j. All costs must cover the same time horizon and all decision variables must represent comparable capability units. If decisions concern indivisible people, relevant variables may need integer restrictions. The penalty p can represent expected lost contribution, service failure, overtime pressure or risk, but it should not be selected merely to force a preferred solution.

Worked optimization. An organization has a gap of 28 capability units. Available interventions are:

InterventionCost per unitMaximum units
Build$4,00010
Buy$7,00012
Borrow$9,00015
Bot$6,0008
Unmet demand$20,000 penaltyUnlimited

Because each unit contributes equally in this simplified model and there are no other constraints, capacity is selected in ascending unit-cost order. Build supplies 10 units, bot supplies 8, and buy supplies the remaining 10.

Z = 10(4,000) + 8(6,000) + 10(7,000) = 158,000

Thus xB = 10, xA = 8, xH = 10, xR = 0 and u = 0. The buy capacity of 12 is not fully used.

The unmet-demand variable matters. If the estimated penalty were only $5,000 per unit, the model would choose 10 build units and leave 18 units unmet because every remaining intervention costs at least $6,000 per unit. Its modeled total would be:

Z = 10(4,000) + 18(5,000) = 130,000

That result does not mean unmet demand is operationally acceptable. It reveals that the penalty assumption or missing service constraints require managerial review. A minimum service-level constraint could instead impose u ≤ umax. More advanced models can include timing, proficiency, learning curves, attrition, diversity safeguards, budget limits and scenario-dependent demand.

10. Applied Case: Northstar Mobility Systems

This is an illustrative fictional case.

Background

Northstar Mobility Systems, an automotive-components manufacturer, is moving from mechanical products toward connected electric-vehicle systems. Its strategy requires data engineering, embedded analytics and cybersecurity capabilities within two years.

Problem

A task-based demand model forecast 150 data-engineering capability FTE in the base scenario. Markov analysis, expected hires, attrition and verified reskilling readiness produced a risk-adjusted internal supply forecast of 105 FTE, creating a base gap of 45 FTE. Scenario gaps were 20 FTE under delayed market adoption and 75 FTE under accelerated adoption.

Northstar also identified eight pivotal technical-lead positions. Only three had a credible ready-now successor, giving ready-now coverage of 3 ÷ 8 = 37.5%. Mobility data showed that process engineers had substantial skill adjacency, but employees in two smaller locations had limited access to development assignments.

Analysis and approach

Northstar estimated the following two-year capability costs and capacities:

OptionCost per ready capability FTECapacity
Build process engineers$45,00020
Buy external specialists$80,00018
Borrow specialist capacity$105,00025
Bot through engineering automation$60,00012
Unmet-demand penalty$160,000Unlimited

For the base gap of 45, the cost-minimizing combination under the simplified equal-capability assumption was build 20, bot 12 and buy 13:

Z = 20(45,000) + 12(60,000) + 13(80,000) = 2,660,000

No borrowed or unmet units were required. In the accelerated scenario, all intervention capacities totaled exactly 75 units, so all four channels would be needed. This highlighted dependence on contractors and justified advance vendor agreements.

The company adopted build and bot investments as no-regret actions. It created quarterly hiring triggers based on orders and time-to-fill, and established prequalified borrowing arrangements for an accelerated scenario. Succession actions included deputy assignments, mentoring and separate emergency and longer-term successor slates. Development access was expanded across locations, and hiring, promotion and program-completion rates were monitored by demographic group.

Outcome

The resulting plan did not claim to predict one future precisely. Instead, it connected each scenario to capacities, costs, triggers and accountable owners. It also exposed succession concentration, geographic inequality of opportunity and the operational consequence of delayed action.

Learning points

  • Demand and supply must be estimated separately before gaps are calculated.
  • A low-cost base plan may still be fragile under accelerated demand.
  • Succession, mobility and diversity are workforce-flow issues, not isolated HR programs.
  • Optimization clarifies assumptions but does not replace managerial or ethical judgment.

11. Governance, Ethics and Contemporary Technology

Workforce analytics uses consequential personal data. Governance should specify purpose, lawful basis, access, retention, data quality, security and employee communication. Data minimization is especially important for inferred skills, potential ratings, health-related information and demographic attributes.

Algorithmic forecasting and internal talent marketplaces can reveal hidden skills and career opportunities. They can also reproduce historical patterns. If past mobility favored one group, a model trained to imitate those moves may perpetuate exclusion. Validation should therefore examine predictive accuracy, calibration, group-level error, accessibility and practical consequences.

Human accountability must remain clear. Managers should not treat model outputs as objective facts when labels, outcomes and assumptions reflect prior decisions. Employees should have reasonable means to correct inaccurate profiles and question consequential recommendations.

Contemporary workforce planning increasingly uses skills graphs, generative AI task analysis, real-time labor-market data and digital workforce twins. These tools can improve responsiveness, but claims of precision should be resisted where skill definitions, external data or causal assumptions are weak.

12. Implementation Principles

Effective practice includes the following:

  1. Begin with strategic work and capabilities rather than current job titles.
  2. Reconcile workforce, finance and operational definitions of demand.
  3. Maintain comparable units across demand, supply and interventions.
  4. Use several scenarios and document assumptions.
  5. Separate model outputs from managerial decisions and record overrides.
  6. Combine quantitative forecasts with operational expertise.
  7. Monitor outcomes, forecast errors and unintended group effects.
  8. Use clear triggers, owners and review dates.
  9. Protect privacy and provide appropriate employee transparency.
  10. Revise the plan as evidence changes.

Chapter Summary

Strategic workforce planning connects organizational strategy to future work, capabilities and labor choices. Demand may be estimated through workload, ratio, regression, expert and task-based approaches. Supply analysis combines stock-and-flow identities, transition models, skills inventories and external labor-market evidence. Demand and supply must be defined in comparable units before capability gaps are calculated.

Scenario planning strengthens resilience by linking uncertain futures to no-regret actions, contingencies and triggers. Talent segmentation should focus first on strategic positions and must not be interpreted as a ranking of human worth. Succession, mobility and diversity analyses reveal workforce flows, concentration risks and unequal access to opportunity.

Build-buy-borrow-bot decisions require consideration of cost, timing, quality, knowledge, compliance and reversibility. Optimization can allocate constrained interventions and explicitly represent unmet demand through a penalty and slack variable. Models support rather than replace professional judgment, ethical accountability and continuing review.

Key Terms

Adverse-impact screening: Preliminary comparison of selection rates across demographic groups.

Build: Development of current employees to create required capability.

Buy: External recruitment of employees with required capability.

Borrow: Acquisition of contingent capability through contractors, partners or temporary labor.

Bot: Automation or technological augmentation of work tasks.

Capability gap: Difference between required and forecast available capability.

Capability unit: A standardized measure of productive skill capacity.

Demand forecast: Estimate of future labor capacity and capability requirements.

Full-time equivalent (FTE): Work capacity equivalent to one full-time schedule over a defined period.

Internal mobility: Employee movement across roles, units, locations or career levels.

Markov analysis: Forecasting method based on probabilities of movement among workforce states.

No-regret action: Intervention expected to create value across multiple plausible scenarios.

Selection rate: Number selected divided by the eligible or applicant population for a group.

Scenario planning: Development and analysis of coherent alternative futures.

Succession coverage: Proportion of critical positions with at least one credible successor.

Supply forecast: Estimate of future internal and external workforce availability.

Talent segmentation: Differentiation of roles or workforce investments using strategically relevant criteria.

Unmet-demand penalty: Modeled cost or consequence assigned to each unit of unsatisfied workforce demand.

Workforce resilience: Capacity to adapt workforce resources to disruption and changing strategic requirements.

Review Questions

Short Answer Questions

  1. Distinguish headcount, FTE and capability units.
  2. Why must workforce demand and supply be forecast before gap analysis?
  3. What assumptions underpin a Markov workforce model?
  4. What does ready-now succession coverage measure?
  5. Define an unmet-demand variable in workforce optimization.

Long Answer Questions

  1. Compare workload, ratio, regression and expert-based demand forecasting methods.
  2. Explain how scenario planning contributes to workforce resilience.
  3. Critically evaluate the strategic and ethical implications of talent segmentation.
  4. Discuss how succession, mobility and diversity analysis can be integrated into workforce planning.
  5. Evaluate build, buy, borrow and bot decisions using financial and nonfinancial criteria.

Analytical / Application Questions

  1. A support function expects 54,000 cases requiring 0.30 productive hours each. An FTE provides 1,800 paid hours with 75% productive availability. Calculate required FTE and explain two limitations of the estimate.
  2. A business begins with 200 FTE, expects 18 hires, 6 transfers in, 4 returns, 22 exits and 9 transfers out. Forecast ending supply and identify one risk not represented by the calculation.
  3. Formulate an optimization model for a 40-unit capability gap using build, buy and borrow options. Include capacities, an unmet-demand slack variable and a penalty. Explain how changing the penalty could alter the solution.

Multiple Choice Questions with Answers

Question 1

A unit expects 24,000 tasks, each requiring 0.5 productive hours. If one FTE provides 1,500 productive hours, what is required demand?

A. 6 FTE

B. 8 FTE

C. 12 FTE

D. 16 FTE

Correct Answer: B. 8 FTE

Question 2

A department starts with 90 FTE, hires 8, receives 3 transfers, loses 10 through exits and transfers 4 out. With no returns from leave, what is ending supply?

A. 87 FTE

B. 89 FTE

C. 91 FTE

D. 95 FTE

Correct Answer: A. 87 FTE

Question 3

A protected group has a 20% selection rate and the reference group has a 25% selection rate. What is the selection-rate ratio?

A. 0.50

B. 0.75

C. 0.80

D. 1.25

Correct Answer: C. 0.80

Question 4

In a Markov workforce model with mutually exclusive and collectively exhaustive destination states, including exit, what must each transition-matrix row sum to?

A. 0

B. 0.5

C. 1

D. The current headcount

Correct Answer: C. 1

Question 5

A 12-unit gap can be met by build at $3,000 per unit with capacity 5, bot at $4,000 with capacity 4, buy at $6,000 with sufficient capacity, or unmet demand at a $10,000 penalty. What is the minimum modeled cost?

A. $39,000

B. $43,000

C. $49,000

D. $60,000

Correct Answer: C. $49,000

Question 6

What is the primary purpose of scenario planning in workforce analysis?

A. To identify one forecast that cannot change

B. To evaluate plans across coherent alternative futures

C. To eliminate all workforce uncertainty

D. To replace supply forecasting with managerial judgment

Correct Answer: B. To evaluate plans across coherent alternative futures

Question 7

Which practice best supports ethical talent segmentation?

A. Treating segment membership as permanent

B. Segmenting people before examining strategic roles

C. Using transparent criteria and permitting movement between segments

D. Withholding development from employees outside pivotal roles

Correct Answer: C. Using transparent criteria and permitting movement between segments

Question 8

An organization has 12 critical positions, of which 9 have at least one credible ready-now successor. What is ready-now succession coverage?

A. 25%

B. 67%

C. 75%

D. 133%

Correct Answer: C. 75%

Question 9

Under the chapter's NPV formulation, what does a positive NPV indicate when all relevant cash benefits and costs are correctly measured at the chosen discount rate?

A. Discounted benefits exceed discounted costs and initial investment

B. The project has no implementation risk

C. Every annual cash flow is positive

D. Nonfinancial considerations are irrelevant

Correct Answer: A. Discounted benefits exceed discounted costs and initial investment

Question 10

In the workforce optimization model, what does a positive unmet-demand variable represent?

A. Workforce supply exceeding demand

B. Required capability not provided by selected interventions

C. The maximum capacity of the build option

D. A mandatory increase in external hiring

Correct Answer: B. Required capability not provided by selected interventions

HR Analytics
Chapter 12 of 14