Forecasting Internal and External Workforce Supply

Introduction

Human resource planning requires more than estimating how many employees an organization will need. It must also determine where those employees will come from, when they will become available, what capabilities they will possess, and how reliably the organization can access them. Workforce supply forecasting is the systematic estimation of the future availability of people and skills from internal and external sources.

Internal supply concerns employees who may be available within the organization through promotion, transfer, development, redeployment, return from leave, or continued employment. External supply concerns potential workers available in the wider labor market, including graduates, experienced applicants, migrants, contingent workers, and people returning to employment.

Supply forecasting is therefore a bridge between workforce demand and managerial action. If expected demand exceeds internal supply, the organization may recruit externally, accelerate development, redesign work, automate tasks, or retain employees more effectively. If supply exceeds demand, it may redeploy workers, slow recruitment, reduce overtime, or redesign jobs.

Learning Objectives

By the end of this chapter, students should be able to:

1. Explain the purpose and logic of internal and external workforce supply forecasting.
2. Use skills inventories, replacement charts, succession information, and turnover analysis to assess internal supply.
3. Interpret a basic Markov model of employee movement.
4. Evaluate labor-market, demographic, educational, geographic, and technological intelligence.
5. Identify the ethical, data-quality, and governance risks of workforce forecasting.
6. Integrate internal and external evidence into practical HR decisions.

1. The Supply-Forecasting System

A useful supply forecast follows five linked steps:

1. Define the workforce unit: job family, location, grade, skill, employment type, or critical role.
2. Establish the current baseline: headcount, capability, tenure, age, performance, mobility, and employment status.
3. Estimate future internal movements: promotions, transfers, exits, retirements, absences, and development outcomes.
4. Assess external availability: labor-force participation, unemployment, qualifications, wages, migration, and competitor demand.
5. Compare supply with demand: identify shortages, surpluses, timing problems, and capability gaps.

Supply is not identical to headcount. An employee counts as useful supply only if the person is likely to be available at the required time, in the required location, at an acceptable cost, and with sufficiently relevant capability. Thus, a workforce of 100 employees may provide much less than 100 units of effective supply if many lack required skills or are likely to leave.

A simple reconciliation is:

Here, S_t is supply at the beginning of period t, I_t is inflow during the period, O_t is outflow, and N_t is net change caused by classification, restructuring, or other adjustments. All terms must be measured in the same headcount or full-time-equivalent units. The expression is an accounting identity, not a prediction by itself; the quality of the forecast depends on how inflows and outflows are estimated.

For skill-based planning, effective supply can be represented conceptually as:

where E_t is effective supply, H_t is available headcount, A_t is the proportion available at the required time, and C_t is the proportion meeting the capability standard. This multiplicative form assumes the factors are proportions between 0 and 1 and is a simplified planning measure. It should not be interpreted as a precise probability unless the assumptions behind the factors are justified.

2. Internal Supply Forecasting

2.1 Skills Inventories

A skills inventory is a structured database describing employees’ qualifications, experience, technical and transferable skills, certifications, language abilities, career interests, location, availability, performance, and development needs. It converts a workforce list into a capability profile.

A strong inventory distinguishes among:

• Qualification: formal education or certification;
• Competence: demonstrated ability to perform a task to a required standard;
• Experience: exposure to roles, industries, systems, or contexts;
• Potential: capacity and readiness for more complex work;
• Availability: whether the person can be deployed when and where needed.

Skills inventories support project staffing, internal recruitment, succession planning, redeployment, and gap analysis. They are especially valuable where skills are scarce or changing rapidly.

However, inventories become unreliable when employees do not update them, managers use inconsistent definitions, or self-reported skills are accepted without evidence. Organizations should use a common skills taxonomy, define proficiency levels, record the source and date of evidence, and provide employees with a way to review and correct their records.

2.2 Replacement Charts

A replacement chart identifies current role holders and possible replacements for positions that are important, vulnerable, or difficult to fill. It commonly includes readiness categories such as:

• ready now;
• ready within one to two years;
• ready in more than two years;
• no identified successor.

Replacement charts are position-centered. They answer the question: “Who could fill this role if the current holder left?” They are useful for continuity planning but can become overly narrow if they focus only on traditional career paths or a small group of favored employees.

A replacement chart should therefore include evidence about performance, potential, development requirements, mobility, retention risk, and the consequences of losing the incumbent. It should not be treated as a promise of promotion.

2.3 Succession Data

Succession planning extends replacement analysis by preparing a broader pipeline for critical roles. It examines not only who might replace an incumbent, but also how potential successors will acquire the required knowledge, relationships, judgment, and leadership capacity.

Useful succession indicators include:

• successor readiness;
• critical-role coverage;
• time to readiness;
• diversity of the successor pool;
• development-plan completion;
• retention risk among high-potential employees;
• dependence on a single successor.

Succession data should be reviewed periodically because readiness is dynamic. A person may become more capable through development, or less available because of turnover intentions, health, family responsibilities, relocation constraints, or changing career goals.

2.4 Turnover Analysis

Turnover reduces internal supply and may also create valuable internal movement. Analysts should distinguish voluntary from involuntary turnover, regrettable from non-regrettable exits, avoidable from unavoidable exits, and employee-initiated from employer-initiated separations.

A basic turnover rate is:

where T is the turnover rate for a specified period, L is the number of separations during that period, and A is average headcount during the same period. Average headcount is often approximated as beginning headcount plus ending headcount, divided by two. The numerator and denominator must use the same population, period, and employment basis.

For example, if 18 employees leave during a year and average headcount is 240:

The overall rate can hide important differences. Turnover should be examined by job family, location, tenure, demographic group, manager, performance level, and reason for leaving. Cohort or survival analysis may be more informative than a single annual percentage because employees hired at different times face different risks of exit.

Turnover forecasting must avoid assuming that past patterns will continue unchanged. Pay changes, labor-market conditions, restructuring, leadership, workload, remote-work policy, and competitor recruitment can alter future behavior.

2.5 Absence, Retirement, and Mobility

Internal supply is affected by long-term absence, parental leave, illness, retirement, secondments, part-time work, transfers, promotions, and geographic mobility. A headcount forecast that ignores these flows may overstate operational capacity.

Retirement analysis should use eligibility and actual retirement behavior carefully. Eligibility does not mean that an employee will retire. Ethical practice requires avoiding age-based assumptions and using lawful, job-relevant information.

2.6 Markov Models of Internal Movement

A Markov model estimates how employees move among defined states, such as job grades, departments, locations, or employment statuses. It uses historical transition probabilities to project future distributions.

Let p_ij be the probability that an employee in state i moves to state j during one period. For every origin state, the probabilities must satisfy:

If n_t is a row vector showing the number of employees in each state at time t, and P is the transition matrix, then:

The model assumes that the defined states are mutually exclusive, transitions are consistently measured, and historical probabilities provide a reasonable approximation of future movement. It is a forecasting aid, not a causal explanation. It may fail when the organization changes its structure, labor conditions shift, or the past contains unusual events.

Worked Example: A Basic Markov Forecast

An organization has 100 employees distributed as follows: 60 in Grade 1, 30 in Grade 2, and 10 in Grade 3. Historical annual transitions are:

The projected Grade 1 population is:

• Grade 1 employees remaining: 60 × 0.70 = 42
• Grade 2 employees promoted into Grade 1: none
• Projected Grade 1 total: 42

The projected Grade 2 population is:

• Grade 1 employees promoted: 60 × 0.20 = 12
• Grade 2 employees remaining: 30 × 0.75 = 22.5
• Projected Grade 2 total: 34.5

The projected Grade 3 population is:

• Grade 2 employees promoted: 30 × 0.15 = 4.5
• Grade 3 employees remaining: 10 × 0.85 = 8.5
• Projected Grade 3 total: 13

Expected exits are 6 from Grade 1, 3 from Grade 2, and 1.5 from Grade 3, totaling 10.5. Because expected values may be fractional, they represent planning averages rather than literal people. Managers must convert them into realistic staffing decisions and consider uncertainty.

3. External Workforce Supply

Internal analysis cannot reveal the full availability of talent. External supply forecasting studies the labor market surrounding the organization and the factors that influence access to workers.

3.1 Labor-Market Intelligence

Relevant intelligence includes:

• labor-force size and participation;
• employment and unemployment rates;
• vacancy and hiring rates;
• wage levels and wage growth;
• occupation-specific shortages or surpluses;
• qualification and certification pipelines;
• competitor hiring;
• geographic mobility and commuting patterns;
• immigration and migration trends;
• availability of contract, freelance, and temporary workers;
• legal restrictions affecting recruitment.

National averages may be misleading. A labor market should be defined by occupation, geography, skill level, industry, and time period. A shortage of software engineers in one city does not imply a shortage everywhere, and a national surplus may coexist with a local shortage.

3.2 Demographic Intelligence

Demographic analysis examines population age structure, birth rates, retirement patterns, migration, educational attainment, gender composition, disability, household structure, and urbanization. These variables influence both the size of the labor pool and the design of attractive employment practices.

Demography should be interpreted carefully. Population characteristics are not deterministic predictions of individual behavior. For example, an aging population may increase retirement pressure in some occupations while also creating opportunities for flexible work, phased retirement, and knowledge transfer.

3.3 Education and Skill Pipelines

External supply depends on the flow of graduates, vocational trainees, professional license holders, and people retrained through short courses or employer academies. HR planners should compare the timing and content of these pipelines with the organization’s requirements.

A large number of graduates does not guarantee supply if graduates lack practical experience, required licenses, language ability, or geographic mobility. Conversely, a small formal pipeline may be supplemented by experienced workers, international recruitment, internal training, or technology-enabled work redesign.

3.4 Geographic and Competitive Factors

Location affects access through wages, housing costs, transportation, safety, climate, family considerations, and employer reputation. Competitor expansion can reduce availability even when broad unemployment is high.

Useful sources include official labor statistics, professional associations, educational institutions, industry surveys, recruitment data, job-posting analysis, and structured consultations with local experts. Sources should be evaluated for scope, date, methodology, sampling bias, and commercial incentives.

4. Integrating Internal and External Evidence

A practical supply statement should specify:

• the number of people likely to be available;
• the skills and proficiency levels available;
• the date and duration of availability;
• location and work-pattern constraints;
• expected losses through turnover or retirement;
• confidence level and major assumptions;
• actions required to close any gap.

A gap can be expressed conceptually as:

where G_t is the workforce gap, D_t is forecast demand, and S_t is forecast effective supply in the same units. A positive value indicates a shortage; a negative value indicates a surplus. The formula is meaningful only when demand and supply refer to comparable job families, capability standards, time periods, and full-time-equivalent definitions.

Supply alternatives include recruitment, internal development, succession acceleration, retention interventions, redeployment, outsourcing, contingent work, automation, job redesign, and changes to service levels. The best option depends on cost, speed, quality, risk, employee relations, and strategic importance.

5. Illustrative Case: Northstar Health Services

Background

Northstar Health Services, a fictional regional provider, plans to open two outpatient centers in eighteen months. It needs 40 registered nurses, 10 laboratory technicians, and 8 clinic managers.

Problem

The organization’s skills inventory shows 34 nurses who could transfer, but 6 are likely to retire or leave within eighteen months. Only 4 clinic managers are considered ready now, and 3 more may be ready within two years. Local labor intelligence indicates strong demand for nurses, a limited technician pipeline, and intense competition among healthcare employers.

Analysis

The HR team combines several sources:

• skills inventory for current qualifications and mobility;
• replacement charts for clinic-manager continuity;
• turnover analysis by occupation and location;
• Markov transition estimates for promotions and transfers;
• local wage and vacancy data;
• projected graduate numbers from nearby colleges;
• demographic evidence indicating a growing older population and rising healthcare demand.

The internal nursing supply is not simply 34. After allowing for expected losses, it is approximately 28, before considering transfers needed to maintain existing clinics. The organization therefore faces a substantial net shortage. Internal supply of managers is also insufficient for eight new positions.

Approach and Solution

Northstar adopts a portfolio response:

1. retain vulnerable nurses through scheduling flexibility and targeted career discussions;
2. recruit experienced nurses in nearby and remote labor markets;
3. establish a paid technician apprenticeship with a local college;
4. develop three manager candidates through supervised assignments;
5. create a temporary manager pool and standardized clinic-opening playbook;
6. use quarterly scenario reviews rather than relying on one forecast;
7. audit selection and promotion data for adverse impact.

Outcome

The organization fills most nursing positions through a combination of internal transfers and external recruitment, while apprentices become a medium-term technician pipeline. The manager shortage remains a risk, so the opening schedule is staggered. This example demonstrates that supply forecasting is not merely a numerical exercise; it links evidence to timing, capability, risk, and feasible interventions.

Learning Points

• Headcount must be adjusted for availability, skill, and expected losses.
• Internal and external data answer different questions and should be integrated.
• Critical roles require succession depth, not only a named replacement.
• Forecasts should be updated as labor conditions and employee decisions change.

6. Technology, AI, and Data Governance

Human resource information systems can integrate employee records, skills, learning histories, movement data, absence records, and recruitment information. Workforce analytics can identify patterns in turnover, mobility, and skill gaps. AI may help classify job descriptions, infer skill relationships, identify possible internal candidates, or model alternative scenarios.

These tools create significant risks. Historical data may reproduce discriminatory promotion or recruitment patterns. Proxy variables may encode protected characteristics. Inferences about potential, health, family status, or retention intentions may be inaccurate or intrusive. Employees may not understand how their data are used.

Good governance requires:

• a clear lawful purpose and data minimization;
• accuracy, traceability, and documented definitions;
• access controls and retention limits;
• human review of consequential decisions;
• bias and adverse-impact testing;
• explainability appropriate to the decision;
• employee notice, correction, and appeal mechanisms;
• compliance with applicable privacy, employment, equality, and record-keeping law.

AI should support professional judgment rather than determine promotion, termination, or exclusion automatically. Forecast confidence and uncertainty should be communicated to decision makers.

7. Limitations and Best Practices

Supply forecasts are vulnerable to structural breaks, poor data, changing employee preferences, hidden labor, informal skills, unexpected exits, and inaccurate external statistics. Markov models may treat past movement as stable, while demographic projections may be too broad for a particular occupation. Skills inventories may confuse stated interest with demonstrated competence.

Best practice is to:

1. use multiple data sources and compare their assumptions;
2. segment results by job, skill, location, and time;
3. combine quantitative models with expert and employee input;
4. produce scenarios rather than a single apparently precise number;
5. report confidence, data age, and known limitations;
6. refresh forecasts regularly;
7. connect forecasts to specific interventions and owners;
8. evaluate outcomes against forecasts and learn from errors;
9. protect privacy and avoid discriminatory assumptions;
10. distinguish capability, availability, potential, and preference.

Chapter Summary

Workforce supply forecasting estimates the people and capabilities available to an organization from internal and external sources. Internal methods include skills inventories, replacement charts, succession data, turnover analysis, absence and retirement analysis, and Markov models of movement. These tools reveal current capability, likely mobility, critical-role coverage, and expected losses, but they depend on valid definitions and reliable data.

External forecasting examines labor-force conditions, wages, vacancies, education pipelines, demographics, migration, geography, competitors, and alternative forms of work. External evidence must be specific to the relevant occupation, location, skill level, and time period. Internal and external forecasts should be integrated with demand forecasts to identify shortages, surpluses, timing problems, and capability gaps.

Effective workforce planning is not a prediction of one certain future. It is a disciplined process of making assumptions visible, comparing scenarios, managing uncertainty, and selecting actions such as recruitment, development, retention, redeployment, job redesign, or automation. Technology and AI can improve analysis, but governance, privacy, fairness, human review, and accountability remain essential.

Key Terms

Supply forecasting: Estimating future availability of workers and capabilities.

Internal supply: Potential workforce availability from within the organization.

External supply: Potential workers available in the wider labor market.

Skills inventory: A structured record of employee qualifications, skills, experience, and availability.

Replacement chart: A record of possible replacements for important positions.

Succession planning: Preparing a pipeline of people for critical future roles.

Turnover: Employee separations from an organization during a specified period.

Voluntary turnover: Separation initiated by the employee.

Regrettable turnover: Loss of an employee whose departure creates significant organizational harm.

Markov model: A model that estimates movement among defined workforce states using transition probabilities.

Transition probability: The likelihood of moving from one defined state to another during a period.

Effective supply: Available workers adjusted for timing and capability requirements.

Labor-market intelligence: Information about worker availability, wages, vacancies, and competition.

Demographic intelligence: Analysis of population characteristics relevant to workforce availability.

Skill pipeline: The expected flow of people acquiring relevant qualifications or capabilities.

Workforce gap: The difference between forecast demand and forecast supply.

Scenario planning: Examination of several plausible future conditions and responses.

Data governance: Policies and controls for responsible data collection, use, security, and accountability.

Review Questions

Short Answer Questions

1. What is the difference between internal and external workforce supply?
2. What information is commonly included in a skills inventory?
3. Why should turnover be analyzed by job family and reason for leaving?
4. What does a replacement chart show?
5. State one major assumption of a Markov model.

Long Answer Questions

1. Explain how skills inventories, replacement charts, and succession data complement one another.
2. Discuss the strengths and limitations of turnover analysis as a supply-forecasting method.
3. Explain how demographic and labor-market intelligence influence external recruitment planning.
4. Describe the Markov model equation n_t+1 = n_t P and explain its assumptions.
5. Discuss the ethical and governance requirements for using AI in workforce supply forecasting.

Analytical / Application Questions

1. An organization has 200 employees, 16 annual separations, and average headcount of 190. Calculate its turnover rate and explain one limitation of interpreting the result alone.
2. A firm expects demand for 50 technicians but forecasts 38 effective internal technicians. Analyze at least three possible responses and identify factors that should guide the choice.
3. Design a supply-forecasting approach for a hospital opening a new facility. Specify the internal data, external intelligence, assumptions, and governance controls you would use.

Multiple Choice Questions with Answers

Question 1

Which tool primarily records employees’ qualifications, skills, experience, and availability?

A. Skills inventory

B. Replacement chart

C. External wage survey

D. Turnover ratio

Correct Answer: A. Skills inventory

Question 2

A replacement chart is mainly designed to answer which question?

A. How many graduates will enter the labor market?

B. Who could fill an important position if its current holder leaves?

C. What is the organization’s annual revenue?

D. What percentage of employees work remotely?

Correct Answer: B. Who could fill an important position if its current holder leaves?

Question 3

If 12 employees leave and average headcount is 160, what is the turnover rate?

A. 5.0%

B. 7.5%

C. 12.0%

D. 13.3%

Correct Answer: B. 7.5%

Question 4

In a Markov workforce model, what does pᵢⱼ represent?

A. The pay difference between two jobs

B. The probability of movement from state i to state j

C. The number of vacancies in state j

D. The performance score of employee i

Correct Answer: B. The probability of movement from state i to state j

Question 5

Which condition is required for the transition probabilities from one origin state to be valid?

A. They must all be negative

B. They must sum to zero

C. They must sum to one

D. They must all be identical

Correct Answer: C. They must sum to one

Question 6

Which is an example of external workforce intelligence?

A. An employee’s internal promotion history

B. A succession candidate’s development plan

C. Local vacancy and wage data for an occupation

D. A manager’s replacement chart

Correct Answer: C. Local vacancy and wage data for an occupation

Question 7

Why can a headcount figure overstate effective workforce supply?

A. Headcount always excludes managers

B. Some employees may lack required skills or availability

C. Headcount is measured only externally

D. Headcount cannot be used in HR planning

Correct Answer: B. Some employees may lack required skills or availability

Question 8

A forecast demand of 75 and effective supply of 60 produces which workforce gap?

A. A shortage of 15

B. A surplus of 15

C. A shortage of 135

D. No gap

Correct Answer: A. A shortage of 15

Question 9

Which is a significant risk when AI uses historical promotion data for workforce forecasting?

A. It eliminates all uncertainty

B. It may reproduce historical discrimination

C. It guarantees legal compliance

D. It removes the need for human review

Correct Answer: B. It may reproduce historical discrimination

Question 10

Which practice improves the reliability of workforce supply forecasts?

A. Using one unchanging forecast

B. Ignoring data limitations

C. Combining multiple sources and reporting assumptions

D. Treating employee potential as certain

Correct Answer: C. Combining multiple sources and reporting assumptions