Workforce Supply Analysis and Gap Planning

Introduction

Human resource planning connects an organisation’s future work to the people and capabilities available to perform it. Workforce demand analysis asks, “How many people and what capabilities will be required?” Workforce supply analysis asks, “Where will those people come from, when will they be available, and what risks affect their availability?” Gap planning then converts the comparison between demand and supply into practical action.

Supply is not simply a headcount. It includes employee numbers, skills, experience, location, availability, performance potential, diversity, employment status and the probability that employees will remain with the organisation. A workforce may have enough employees numerically but still face a critical shortage of cybersecurity, supervisory or customer-service capability. Conversely, an organisation may have a surplus of employees in declining roles while lacking people for emerging work.

This chapter explains internal and external labour supply analysis, the principal analytical tools used by HR professionals, and the strategic responses known as build, buy, borrow, redeploy, automate and reduce.

Learning objectives

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

1. Distinguish internal from external labour supply.
2. Use skills inventories, HR databases, replacement charts and transition analysis to assess internal supply.
3. Interpret labour-market information and identify external supply risks.
4. Calculate basic retention, turnover and workforce-gap measures.
5. Diagnose quantitative and qualitative workforce gaps.
6. Select an appropriate build, buy, borrow, redeploy, automate or reduce response.
7. Evaluate ethical, legal, technological and implementation issues in gap planning.

1. The meaning and scope of workforce supply

1.1 Internal and external supply

Internal labour supply consists of people already employed by the organisation who may be available for current or future work through promotion, transfer, retraining, increased hours or succession arrangements. Internal supply is influenced by current staffing, skills, performance, career preferences, retirement, resignation, absenteeism, mobility and development investment.

External labour supply consists of people outside the organisation who could potentially be recruited. It includes unemployed people, graduates, experienced workers, migrants where legally permitted, people returning to work, contractors and workers in related occupations. External supply is influenced by population trends, education systems, wage levels, technology, labour mobility, immigration policy, competitor demand and the organisation’s reputation.

Supply analysis should examine three dimensions:

• Quantity: the number of people available.
• Quality: the skills, qualifications, experience and performance capability available.
• Timing and location: when and where the capability can be obtained.

A supply estimate is therefore a reasoned forecast, not a guaranteed number. It should state assumptions and be updated as conditions change.

1.2 Workforce flow and the supply equation

A basic workforce-flow identity is:

where:

• S₀ = workforce at the beginning of the period;
• S₁ = workforce at the end of the period;
• A = accessions, or hires and other entries;
• L = leavers, including resignations, retirements and dismissals;
• I = internal inflows into the workforce segment being analysed, such as transfers or promotions into it;
• O = internal outflows from that segment.

All variables must be measured in the same unit, normally employees or full-time equivalents (FTEs), and for the same period. For a whole organisation, internal inflows and outflows cancel each other, but they are essential when analysing a department, occupation or location. The identity describes accounting movement; it does not predict whether people possess the required skills.

If demand is D and expected supply is S₁, a simple numerical gap is:

A positive G indicates a shortage; a negative value indicates a surplus. This calculation assumes that demand and supply are comparable in time, location, employment unit and capability definition. A headcount gap should therefore be supplemented by a skills and productivity analysis.

1.3 Turnover and retention measures

Turnover helps HR estimate how much internal supply may be lost. A commonly used period turnover rate is:

The average workforce may be estimated as:

This is a descriptive measure, not a causal explanation. Organisations should distinguish voluntary and involuntary turnover, regretted and non-regretted losses, and turnover by role, location, tenure and demographic group. A retention rate can be calculated as the percentage of a defined starting cohort still employed at the end of the period, but the cohort and time period must be stated clearly.

Worked example. A service centre begins the year with 240 employees and ends with 260. During the year, 30 employees leave. Average workforce is (240 + 260) ÷ 2 = 250. Turnover is (30 ÷ 250) × 100 = 12%. If 18 of the leavers were experienced technicians, the overall rate conceals a more serious capability risk.

2. Internal supply analysis

2.1 Skills inventories

A skills inventory is a structured record of employee capabilities and relevant attributes. Typical fields include:

A useful inventory defines skill levels behaviourally. For example, “advanced data analysis” should specify what an employee can independently perform, not merely record that the employee attended a course. Self-assessment can be useful for discovery, but critical skills should be verified through qualifications, work samples, supervisor assessment or practical tests.

The inventory should be maintained as a living system. Outdated records produce false confidence, particularly where technology and professional requirements change rapidly.

2.2 HR databases and people analytics

An HR information system (HRIS) can combine employee records, learning data, performance information, absence, recruitment, succession and workforce movement. A database enables HR to answer questions such as:

• Which employees possess a required certification?
• Which roles have only one qualified incumbent?
• What is the likely internal candidate pool for a vacancy?
• Which departments experience unusually high turnover?
• How long does it take to develop a scarce skill?

Data governance is essential. Access should be role-based, records should be accurate and current, and sensitive information should be collected only for legitimate purposes. Predictive analytics should support, not replace, professional judgement. Correlation between a characteristic and turnover does not prove that the characteristic causes turnover.

2.3 Replacement charts and succession analysis

A replacement chart identifies possible successors for key positions, their readiness and development requirements. A simple chart may classify candidates as:

• ready now;
• ready within one to two years;
• ready within three or more years; or
• no identified successor.

A replacement chart is position-centred. A succession plan is broader: it links critical roles, strategic capabilities, development actions, career pathways and alternative scenarios. Neither should promise a promotion. Employees may decline, performance may change, and organisational needs may be redesigned.

A practical replacement chart should include evidence, not only labels. For example, “ready within two years” might require completion of a qualification, demonstrated leadership of a project and experience managing a budget.

2.4 Transition analysis and Markov-style planning

Transition analysis examines how employees move between states such as job categories, grades, locations or employment statuses. A transition matrix records the proportion of people in one state who move to another during a defined period.

For example, suppose a department has 100 junior officers. Historical evidence shows that, over one year, 70% remain junior officers, 15% become senior officers, 10% leave and 5% transfer elsewhere. If the organisation expects 200 junior officers at the start of the next period, the expected outcomes based on stable historical rates are:

• 140 remaining junior officers;
• 30 becoming senior officers;
• 20 leaving;
• 10 transferring elsewhere.

This is a forecast, not a certainty. It assumes that the historical transition proportions remain reasonably stable and that the future population resembles the historical population. Structural change, a new reward system, economic disruption or a changed recruitment profile can invalidate the assumption.

A matrix representation is useful. If n_t is a row vector of employees across workforce states and P is a transition-probability matrix, then:

Each row of P should sum to 1 when all possible destinations, including leaving, are included. The model is appropriate for scenario planning where historical movement data are sufficient; it should not be treated as a precise prediction of individual behaviour.

2.5 Internal supply risks

Internal supply may be overstated because of:

• inaccurate skills records;
• employees who are technically qualified but unavailable at the required time;
• excessive dependence on a small number of experts;
• retirement or resignation risk;
• limited willingness to relocate or work particular shifts;
• weak managerial assessment of readiness;
• absenteeism and long-term leave;
• unequal access to development opportunities.

Consequently, HR should distinguish nominal supply from effective supply. Effective supply is the capability realistically available after considering proficiency, availability, productivity, legal restrictions and operational timing.

3. External labour-market analysis

External supply analysis uses labour-market information (LMI) from government statistics, professional bodies, educational institutions, industry reports, recruitment data and reputable research. Relevant indicators include:

• unemployment and participation rates;
• occupational employment and projected growth;
• vacancy levels and time to fill;
• wage and benefit movements;
• graduate output and qualification trends;
• geographic concentration of skills;
• migration and work-authorisation rules;
• competitor recruitment activity;
• technology-related changes in occupations.

The analyst should assess both availability and accessibility. A large national supply may be irrelevant if qualified candidates are concentrated far from the workplace, require a scarce licence, or expect compensation beyond the organisation’s range.

3.1 Segmenting the external market

A labour market should be segmented rather than treated as one pool. Useful segments include occupation, skill level, geography, experience, employment preference, industry and demographic group. For example, a shortage of registered nurses in a rural region cannot be inferred from national nursing numbers alone.

Employer value proposition, recruitment reputation, selection speed, flexibility, pay equity and working conditions affect the organisation’s share of the available market. External supply is therefore partly an organisational outcome: an employer that improves its employment proposition can expand its realistic supply without changing the wider population.

3.2 Scenario assumptions

External forecasts should use scenarios rather than a single confident figure. A base case may assume current trends continue; an optimistic case may assume improved productivity or migration; a constrained case may assume competitor expansion or regulatory restrictions. Each scenario should document assumptions, data sources, date, uncertainty and triggers for review.

4. Identifying and diagnosing workforce gaps

A workforce gap exists when the capability required for planned work differs from the capability likely to be available. Gaps may be:

• quantitative: too few employees or FTEs;
• qualitative: insufficient skill, experience or performance;
• temporal: capability arrives too late;
• geographic: people are in the wrong location;
• structural: the organisation has the wrong occupational mix;
• flexibility-related: insufficient ability to cover peaks, shifts or emergencies.

A useful gap statement specifies role, capability, amount, date, location, confidence and business consequence. “We need 12 analysts” is weaker than “By July, the project requires eight analysts with advanced forecasting skills in the regional office; current effective supply is three, producing a gap of five.”

Worked gap example

A warehouse forecasts demand for 48 FTE supervisors next year. Its internal analysis identifies 40 supervisors likely to be available, but two are expected to retire before the peak season. Thus effective internal supply is 38. An external campaign is expected to recruit four qualified supervisors, while a development programme may prepare three team leaders, of whom two are expected to be ready by the required date.

Expected effective supply is:

38 + 4 + 2 = 44 FTEs

The remaining shortage is:

48 − 44 = 4 FTEs

The plan should not simply recruit four people. It should test whether the development estimate is realistic, whether new hires can be onboarded before the peak, and whether temporary or automated options can cover the residual requirement.

5. Responses to workforce gaps

A balanced gap plan considers six broad responses.

5.1 Build

Building includes induction, apprenticeships, mentoring, job rotation, formal learning, certification and stretch assignments. It is most suitable for strategically important capabilities that are difficult to buy and likely to remain relevant. Build plans need a capability specification, learning pathway, supervisor support, time allowance and assessment of demonstrated competence. Training attendance alone is not evidence that a gap has closed.

5.2 Buy

Buying includes external recruitment, targeted search, graduate recruitment and acquisition of a team or specialist capability. Selection criteria should be job-related and validated where possible. Recruitment should not be used to avoid improving poor management, unrealistic workload or inequitable pay, since these conditions can produce rapid turnover after hiring.

5.3 Borrow

Borrowing can provide speed and flexibility during a project, seasonal peak or specialist requirement. HR must clarify supervision, confidentiality, intellectual property, health and safety, data access, tax and employment-status obligations. Contractors should not be misclassified to evade employment protections.

5.4 Redeploy

Redeployment may involve transfer, secondment, reduced hours, shift changes or reskilling. It can preserve institutional knowledge and employee opportunity. A fair process requires transparent criteria, consultation, reasonable support and attention to accessibility and family or location constraints.

5.5 Automate

Automation should begin with task analysis, not the assumption that an entire occupation can be eliminated. HR should identify which tasks can be automated, augmented or redesigned, then assess quality, safety, privacy, cybersecurity, accessibility and employee impact. Artificial intelligence may assist scheduling, skills matching and demand forecasting, but training data can reproduce historical bias and automated recommendations require human oversight.

5.6 Reduce

Reduction may occur through natural attrition, vacancy controls, shorter operating hours, work redesign, redeployment, voluntary separation or, where necessary, redundancy. It should be a last-resort response to a properly evidenced structural surplus, not a substitute for short-term planning. Legal consultation, non-discrimination, notice, severance and respectful communication are essential.

6. An integrated gap-planning process

A professional process can follow these stages:

1. Clarify the planning question. Define the workforce segment, time horizon, work volume and required capability.
2. Define demand. Translate strategy and operating plans into roles, skills, FTEs, location and timing.
3. Baseline internal supply. Validate HRIS records, skills inventories, availability and performance information.
4. Forecast internal movement. Examine promotion, transfer, retirement, absence and turnover patterns.
5. Assess external supply. Analyse relevant labour-market segments and recruitment feasibility.
6. Calculate and qualify gaps. Compare demand with effective supply and classify the gap.
7. Generate options. Consider build, buy, borrow, redeploy, automate and reduce, including combinations.
8. Evaluate options. Compare cost, speed, quality, risk, employee impact, legal compliance and reversibility.
9. Assign accountability. Specify owner, milestones, budget, measures and review dates.
10. Monitor and revise. Track leading indicators such as applications, readiness, certification, turnover and time to competence.

A useful evaluation does not rely on recruitment numbers alone. Measures may include time to fill, time to proficiency, internal-fill rate, critical-role coverage, regretted turnover, skills-certification completion, productivity, employee experience and diversity outcomes.

7. Ethical, legal and governance considerations

Supply analysis uses personal and sometimes sensitive information. HR should apply purpose limitation, data minimisation, accuracy, secure access, retention controls and applicable privacy law. Employees should understand how skills, performance and career data are used.

Workforce decisions must not unlawfully discriminate on grounds such as sex, race, disability, age, religion or other protected characteristics. Automated screening and succession analytics require bias testing, explainability and a route for human review. A historical promotion pattern may reflect past discrimination; reproducing it mathematically does not make it fair.

Confidentiality is especially important for replacement charts and flight-risk analysis. Information should be shared only with those who need it for legitimate planning. Consultation with employee representatives may be required for restructuring, monitoring or changes to work arrangements.

8. Illustrative case: Meridian Foods distribution centre

Background. Meridian Foods, a fictional regional distributor, expects online orders to increase by 30% over two years. The distribution centre currently employs 120 warehouse workers, 12 team leaders and 4 operations supervisors. It has difficulty recruiting experienced supervisors and has an ageing workforce in forklift and inventory-control roles.

Problem. The demand plan requires 16 team leaders and 6 supervisors within 18 months. The skills inventory shows that only two team leaders are ready for promotion; three experienced workers could become ready within a year. Two supervisors are eligible to retire, and turnover among warehouse workers is 18% annually. External labour-market data indicate strong competition for supervisors, but a nearby technical college offers logistics qualifications.

Analysis. The nominal supervisor supply is four, but expected retirement reduces it to two. The required supply is six, creating a likely shortage of four. For team leaders, current supply is 12 and the requirement is 16, creating a shortage of four; internal development can probably provide three, leaving one gap. The analysis also reveals a qualitative gap: several employees have operational experience but lack coaching and data skills.

Approach. Meridian adopts a mixed plan. It builds capability through a six-month team-leader academy, mentoring and funded logistics qualifications. It buys two supervisors through targeted recruitment and borrows one specialist trainer during implementation. It redeploys an experienced inventory clerk into a data-coordination role after training. It pilots automated picking and scheduling tools, while retaining human supervision and safety checks. It does not immediately reduce headcount; instead, it uses natural attrition to adjust routine roles as productivity improves.

Outcome. After 12 months, three employees are ready for team-leader roles, one external supervisor has been appointed and the second is in final selection. The organisation identifies that the training schedule conflicts with peak operations, so it introduces paid release time and staggered cohorts. The case demonstrates that supply analysis is more than counting employees: it combines timing, readiness, skills, recruitment feasibility and work redesign.

Learning points. First, effective supply may be lower than nominal supply. Second, a portfolio of responses is usually stronger than one intervention. Third, technology should be evaluated as a redesign choice, not merely a headcount-reduction device. Finally, workforce plans require review because assumptions about turnover, retirement and external recruitment can change.

Challenges and limitations

Supply forecasts are vulnerable to poor data, changing strategy, unexpected economic conditions and uncertain employee behaviour. Historical rates may not apply after a merger, technology change or major policy reform. Skills taxonomies can become obsolete, while employee self-assessments may overstate or understate capability. External labour-market statistics may be aggregated too broadly for a specific location or occupation.

HR should therefore document assumptions, use ranges or scenarios, triangulate multiple data sources and conduct sensitivity analysis. Sensitivity analysis asks how the plan changes if a key assumption changes—for example, if turnover rises from 12% to 16% or recruitment takes three months longer. The purpose is not false precision, but better preparedness.

Best-practice principles

• Define capability clearly and connect it to business outcomes.
• Use both headcount and FTE measures consistently.
• Separate nominal, qualified, ready and effective supply.
• Validate skills data through evidence and regular review.
• Segment labour-market information by occupation, location and skill.
• Use scenarios rather than a single forecast.
• Combine build, buy, borrow, redeploy, automate and reduce thoughtfully.
• Evaluate employee, legal, ethical and operational consequences.
• Make assumptions, ownership and review dates explicit.
• Treat workforce planning as a continuing management process.

Chapter Summary

Workforce supply analysis determines the people and capabilities realistically available to an organisation. Internal supply is assessed through skills inventories, HR databases, replacement charts, succession information and transition analysis. External supply is examined through labour-market information, occupational trends, wages, education pipelines, geography and competitor activity. Workforce gaps may concern quantity, quality, timing, location, structure or flexibility.

Basic workforce-flow and turnover measures support analysis, but numbers must be interpreted with assumptions and evidence. Effective supply is lower than nominal supply when capability, availability, retirement, turnover or timing constraints are considered. Gap planning converts diagnosis into action through build, buy, borrow, redeploy, automate and reduce responses. The best plans combine options, assign accountability, protect employee rights, govern data responsibly and monitor results through changing conditions.

Key Terms

Internal labour supply: Current employees who may provide future workforce capacity.

External labour supply: Potential workers available outside the organisation.

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

HRIS: A human resource information system used to store and analyse workforce data.

Replacement chart: A record of potential successors and their readiness for key positions.

Succession planning: A systematic approach to preparing talent for critical future roles.

Transition analysis: Analysis of movement between workforce categories or states.

Transition matrix: A table showing probabilities or numbers moving from one state to another.

Effective supply: Capability realistically available after considering readiness, timing and constraints.

Nominal supply: The apparent number of employees without adjustment for capability or availability.

Labour-market information: Data describing workforce availability, demand, wages and occupational trends.

Workforce gap: A difference between required capability and expected available capability.

Build: Developing existing employees to meet future requirements.

Buy: Recruiting capability from the external labour market.

Borrow: Obtaining temporary or specialist capability from outside providers.

Redeploy: Moving or reskilling employees into different work.

Automate: Using technology to perform or augment selected work activities.

Reduce: Lowering workforce requirements through restructuring, attrition or work redesign.

Turnover rate: Leavers during a period divided by average workforce, expressed as a percentage.

Data governance: Policies and controls for responsible collection, use, protection and retention of data.

Review Questions

Short Answer Questions

1. Distinguish internal labour supply from external labour supply.
2. What information should be included in a skills inventory?
3. Why is effective supply different from nominal supply?
4. State two limitations of transition analysis.
5. What is the difference between a quantitative and a qualitative workforce gap?

Long Answer Questions

1. Explain how an HR professional could combine an HRIS, skills inventory and replacement chart to assess internal supply.
2. Describe the main sources of external labour-market information and explain how each may support workforce planning.
3. Explain the build, buy, borrow, redeploy, automate and reduce responses, including one appropriate use and one risk for each.
4. Discuss the ethical and governance issues involved in using employee data and AI for workforce planning.
5. Explain why workforce supply forecasts should use scenarios and documented assumptions rather than a single precise estimate.

Analytical / Application Questions

1. An organisation requires 80 qualified technicians. Internal records show 70, but five are expected to retire and eight lack the required certification. The organisation expects to recruit ten qualified technicians externally. Calculate the likely effective supply and identify the remaining gap, stating any assumptions.
2. A hospital has a high overall turnover rate, but most departures are from non-critical entry-level roles. Explain why an aggregate turnover rate may mislead workforce planning and propose at least three additional analyses.
3. A manufacturer plans to automate part of its inspection process. Recommend a workforce gap-planning approach that considers redeployment, reskilling, employee consultation, safety, data governance and possible reduction in roles.

Multiple Choice Questions with Answers

Question 1

Which statement best describes effective workforce supply?

A. The total number of people listed in the HR database

B. The number of employees realistically available with the required capability and timing

C. The number of applicants who respond to a vacancy

D. The number of positions shown in the organisation chart

Correct Answer: B. The number of employees realistically available with the required capability and timing

Question 2

A department begins with 100 employees, ends with 120, and has 11 leavers. Using the average workforce, what is the turnover rate?

A. 9.2%

B. 10.0%

C. 11.0%

D. 12.1%

Correct Answer: A. 9.2%

Question 3

What is the principal purpose of a replacement chart?

A. To calculate payroll tax

B. To identify potential successors and their readiness for key roles

C. To measure customer satisfaction

D. To record external unemployment

Correct Answer: B. To identify potential successors and their readiness for key roles

Question 4

In transition analysis, a transition matrix normally represents:

A. The probability or number of movements between workforce states

B. The cost of every employee benefit

C. The organisation’s annual sales forecast

D. The legal definition of an employee

Correct Answer: A. The probability or number of movements between workforce states

Question 5

Which response is most directly associated with developing current employees through training and mentoring?

A. Buy

B. Borrow

C. Build

D. Reduce

Correct Answer: C. Build

Question 6

An organisation uses contractors for a six-month specialist project. This is primarily an example of:

A. Borrow

B. Build

C. Redeploy

D. Reduce

Correct Answer: A. Borrow

Question 7

A positive workforce gap value calculated as demand minus supply indicates:

A. A workforce surplus

B. A workforce shortage

C. Zero turnover

D. A completed succession plan

Correct Answer: B. A workforce shortage

Question 8

Which is a limitation of relying exclusively on historical transition rates?

A. They always overestimate external recruitment

B. They cannot be expressed in percentages

C. They assume future movement will resemble the historical pattern

D. They measure only employee satisfaction

Correct Answer: C. They assume future movement will resemble the historical pattern

Question 9

Which practice best supports responsible use of AI in workforce planning?

A. Allowing an algorithm to make unreviewable promotion decisions

B. Using historical decisions without checking for bias

C. Applying human oversight, bias testing and explainable criteria

D. Collecting every available personal detail regardless of purpose

Correct Answer: C. Applying human oversight, bias testing and explainable criteria

Question 10

A required workforce is 48 FTEs and expected effective supply is 44 FTEs. What is the numerical gap?

A. 4 FTE shortage

B. 4 FTE surplus

C. 92 FTE shortage

D. 44 FTE shortage

Correct Answer: A. 4 FTE shortage