workforce-planning

name

workforce-planning

description

USE THIS SKILL when the user asks about headcount planning, workforce strategy, skills gap analysis, capacity modeling, future of work, talent strategy, workforce segmentation, build/buy/borrow/bot analysis, workforce cost modeling, attrition forecasting, labor market analysis, contingent workforce, automation impact, FTE planning, or workforce right-sizing. Also trigger for "skills taxonomy," "talent supply chain," "strategic workforce planning," "workforce analytics," "labor productivity," or any request to project workforce needs over 12-24 months tied to business strategy, digital transformation, M&A integration, or cost reduction.

Strategic Workforce Planning

Required Inputs

Input	Description	Required?
Business strategy	Strategic plan, growth targets, transformation roadmap	Yes
Current headcount data	By function, level, location, employment type, cost	Yes
Organizational structure	Org chart, reporting lines, spans of control	Yes
Financial targets	Revenue plan, cost targets, productivity goals	Yes
Skills inventory	Current skills database or competency assessments	Recommended
Attrition data	Historical voluntary and involuntary turnover by segment	Recommended
Labor market data	Availability, compensation trends, competitor hiring	Recommended
Technology roadmap	Planned automation, AI, system implementations	Recommended
Demographic data	Age distribution, tenure, retirement eligibility	Recommended

Execution Steps

1. Current State Workforce Analysis

Headcount Profile:

Dimension	Segments	Data Points
Function	Engineering, Sales, Operations, Finance, HR, etc.	HC, FTE, % of total, YoY change
Level	Executive, Senior, Mid, Junior, Entry	HC, avg tenure, avg comp, span of control
Location	HQ, regional offices, remote, offshore	HC, cost differential, local labor market
Employment type	FT, PT, contractor, temp, outsourced	HC, FTE equivalent, cost per FTE
Tenure	<1yr, 1-3yr, 3-5yr, 5-10yr, 10yr+	HC, % of total, attrition rate per band
Demographics	Age bands, diversity dimensions (where legally collected)	Distribution, retirement risk, representation

Skills Inventory Assessment:

Skill Category	Current Supply (FTEs)	Proficiency Distribution	Strategic Importance (H/M/L)	Scarcity (H/M/L)
[Technical skill]		Beginner X% / Intermediate X% / Advanced X% / Expert X%
[Leadership skill]
[Digital skill]

Cost Structure Analysis:

Component	Amount ($)	% of Total	Per-FTE Average	Benchmark
Base salary
Variable compensation
Benefits (health, retirement)
Payroll taxes
Training and development
Recruitment costs
Technology (per employee)
Facilities (per employee)
Fully-loaded cost per FTE	$[X]	100%	$[X]	$[X]

Calculate fully-loaded cost by level and function: Fully-loaded cost = Base + Variable + Benefits + Taxes + Allocated Overhead

2. Future Demand Modeling

Strategy-Driven Demand Methodology:

Strategic Driver	Workforce Implication	Demand Impact (FTEs)	Timing
Revenue growth target of X%	Sales + delivery capacity	+[X] FTEs	Q1-Q4
New market entry	Local presence, regulatory skills	+[X] FTEs	Q2-Q3
Digital transformation	Digital skills, reduced manual roles	+[X] / -[X] FTEs	Q1-Q8
M&A integration	Consolidation, redundancy, new capabilities	+/-[X] FTEs	Q1-Q4
Cost reduction program	Productivity improvement, restructuring	-[X] FTEs	Q1-Q6
New product/service launch	R&D, marketing, support	+[X] FTEs	Q3-Q8

Scenario-Based Demand Projections:

Function	Current HC	Base Case (+12mo)	Base Case (+24mo)	Upside (+24mo)	Downside (+24mo)
Sales
Engineering
Operations
Finance
HR
IT
Total	[X]	[X]	[X]	[X]	[X]

3. Supply Forecasting

Attrition Modeling:

Segment	Historical Attrition (3yr avg)	Predicted Attrition (12mo)	Predicted Attrition (24mo)	Risk Factors
By function	X%	[X] FTEs	[X] FTEs	[Drivers]
By level	X%	[X] FTEs	[X] FTEs	[Drivers]
By tenure band	X%	[X] FTEs	[X] FTEs	[Drivers]
By performance rating	X%	[X] FTEs	[X] FTEs	[Drivers]

Attrition projection formula: Projected Attrition = Current HC x Attrition Rate x (1 + Trend Adjustment)

Internal Pipeline Analysis:

Level	Current HC	Promotable (12mo)	Promotable (24mo)	Lateral Move Candidates	Retirement Eligible (24mo)
Executive
Senior
Mid-level
Junior

Labor Market Analysis:

Critical Role	Internal Supply	External Availability	Time to Fill (avg)	Market Compensation	Premium Required
[Role]	[X] candidates	Scarce / Moderate / Abundant	[X] days	$[X]	[X]% above current

4. Gap Analysis Framework

Quantitative Gaps (Headcount):

Function / Role	Demand (24mo)	Projected Supply (24mo)	Gap (Surplus)	Gap Type	Priority
[Function]	[X]	[X]	[+/- X]	Shortage / Surplus	Critical / High / Medium

Qualitative Gaps (Skills):

Skill	Required Proficiency	Current Proficiency	Gap Severity (1-5)	# People Affected	Urgency
[Skill]	Advanced	Beginner	4	[X]	Immediate / 6mo / 12mo

Location Gaps:

Location Need	Current Presence	Gap	Constraint	Solution Option
[Market/Region]	[X] FTEs	[+/- X]	[Visa, cost, talent pool]	Hire / Relocate / Remote

Timing Gaps:

Role	Needed By	Earliest Available (Build)	Earliest Available (Buy)	Gap (Weeks)
[Role]	[Date]	[Date]	[Date]	[X] weeks

5. Build / Buy / Borrow / Bot Analysis

Decision Framework:

Strategy	Definition	Best When	Cost Profile	Time to Capability	Risk
Build	Develop existing employees through training, rotation, stretch assignments	Skill is adjacent to current capabilities; long-term need; cultural fit matters	Low direct cost; high opportunity cost	6-24 months	Attrition before ROI
Buy	Recruit externally (permanent hires)	Skill does not exist internally; urgent and ongoing need; market supply adequate	High (recruitment + premium + onboarding)	3-6 months	Cultural fit; retention
Borrow	Engage contingent workers, consultants, gig talent, outsourcing	Temporary or project-based need; specialized expertise; demand uncertainty	Variable (day rate or project fee)	1-4 weeks	Knowledge loss; dependency
Bot	Automate through RPA, AI, workflow automation	Task is rules-based, repetitive, high-volume; data-driven decision	Capex + maintenance; low marginal cost	3-12 months	Change resistance; edge cases

Gap-by-Gap Decision Matrix:

Gap	Build	Buy	Borrow	Bot	Recommended Strategy	Rationale
[Gap 1]	Feasible? Cost? Time?	Feasible? Cost? Time?	Feasible? Cost? Time?	Feasible? Cost? Time?	[Strategy]	[Why]

6. Skills Taxonomy Development

Taxonomy Structure:

Level 1: Skill Domain (e.g., Digital, Leadership, Technical, Functional)
  Level 2: Skill Category (e.g., Data & Analytics, Change Leadership)
    Level 3: Specific Skill (e.g., Machine Learning, Stakeholder Management)
      Level 4: Proficiency Level (Foundational / Intermediate / Advanced / Expert)

Proficiency Definitions:

Level	Definition	Observable Behaviors
Foundational	Basic awareness; can perform with guidance	Follows procedures, asks for help, learning
Intermediate	Competent; performs independently in standard situations	Works independently, handles routine variation
Advanced	Expert; handles complex/novel situations, coaches others	Solves novel problems, mentors, improves processes
Expert	Recognized authority; shapes strategy and innovation	Industry thought leader, designs frameworks, strategic advisor

7. Workforce Segmentation

Strategic Segmentation Model:

Segment	Definition	Examples	Talent Strategy	Investment Level
Strategic	Roles that directly create competitive advantage; scarce, high-impact	Chief Data Scientist, Key Account Director, Head of Innovation	Attract, develop, retain aggressively; premium compensation; bespoke development	Highest
Core	Roles essential to business operations; require strong performance	Engineers, Analysts, Project Managers, Sales Reps	Structured career paths; competitive compensation; build bench strength	High
Support	Roles that enable operations; important but more substitutable	Admin, Facilities, Standard IT Support, Payroll	Efficient delivery; consider shared services, outsourcing, automation	Moderate
Misaligned	Roles no longer aligned to strategy; shrinking demand	Legacy system specialists, redundant management layers	Reskill to core/strategic, redeploy, or managed transition out	Transitional

8. Capacity Modeling

FTE Equivalence Calculation:

Effective FTE = Gross FTE x Availability Factor x Productivity Factor

Where:
  Availability Factor = (Working Days - PTO - Holidays - Training - Admin) / Working Days
  Typical range: 0.75 - 0.85

  Productivity Factor = Actual Output / Expected Output
  Typical range: 0.80 - 1.10 (varies by role maturity)

Example: 100 Gross FTE x 0.82 Availability x 0.90 Productivity = 73.8 Effective FTE

Utilization Analysis:

Function	Gross FTE	Effective FTE	Current Utilization	Target Utilization	Capacity Gap (FTEs)
[Function]			X%	X%	[+/- X]

9. Workforce Action Plans

12-Month Action Plan:

Quarter	Build Actions	Buy Actions	Borrow Actions	Bot Actions	Net HC Change	Cumulative Cost
Q1	[Training programs launched]	[X hires in pipeline]	[X contractors engaged]	[X automations scoped]	+/- X	$[X]
Q2
Q3
Q4

24-Month Strategic Workforce Roadmap:

Phase	Focus	Key Actions	Target Outcomes	Investment
Phase 1 (Mo 1-6)	Foundation	Skills assessment, critical hires, quick automations	Close critical gaps, build planning capability	$[X]
Phase 2 (Mo 7-12)	Acceleration	Development programs, strategic hires, process automation	50% of skill gaps addressed, productivity gains	$[X]
Phase 3 (Mo 13-18)	Transformation	Role redesign, advanced automation, new capabilities	New operating model staffed, automation scaled	$[X]
Phase 4 (Mo 19-24)	Optimization	Fine-tuning, continuous improvement, talent pipeline	Steady-state workforce aligned to strategy	$[X]

10. Workforce Cost Modeling

Current vs. Future State Cost Comparison:

Cost Element	Current ($M)	Future State ($M)	Delta ($M)	Driver of Change
Permanent headcount cost				HC change x avg loaded cost
Contingent workforce cost				Borrow strategy
Recruitment cost				Buy strategy volume
Training and development				Build strategy investment
Automation investment				Bot strategy capex
Severance / transition				Surplus management
Total workforce cost	$[X]	$[X]	$[X]
Revenue per employee	$[X]	$[X]		Productivity improvement
Workforce cost as % revenue	X%	X%		Efficiency gain

11. Contingent Workforce Strategy

Dimension	Current State	Target State	Actions
Contingent as % of total workforce	X%	X%	[Increase/Decrease with rationale]
Managed service providers (MSP)	[Y/N]	[Y/N]	[Vendor selection/management]
Vendor management system (VMS)	[Y/N]	[Y/N]	[Technology enablement]
Rate card governance	[Describe]	[Standardized rates by skill/level]	[Rate negotiation]
Compliance (co-employment risk)	[Assess]	[Compliant]	[Legal review, policy update]
Conversion pipeline	[X]% convert to FTE	[X]% target	[Try-before-you-buy program]

12. Automation and AI Impact Assessment

Task-Level Analysis:

Role	Task	% of Role Time	Automation Potential	Technology	Impact on Role	Timeline
[Role]	[Task]	X%	Full / Partial / None	RPA / AI / ML / Workflow	Eliminate / Augment / Unchanged	[When]

Automation Impact Summary:

Function	Current FTEs	Tasks Automatable (FTE equiv.)	Net FTE Change	Roles Eliminated	Roles Augmented	New Roles Created
[Function]	[X]	[X]	[-X]	[X]	[X]	[X]

Automation Readiness Criteria:

Criterion	Weight	Score (1-5)
Process standardization	20%
Data quality and availability	20%
Volume and frequency	20%
Rule-based vs. judgment-based	20%
Change readiness of workforce	10%
Technology infrastructure	10%

Output Template

# Strategic Workforce Plan: [Organization / BU]

**Date:** [Date]
**Planning Horizon:** [12 / 24] months
**Scope:** [X] FTEs across [X] functions, [X] locations
**Business Strategy:** [One-line summary]

---

## 1. Executive Summary

[2-3 paragraphs: workforce challenge, key gaps, recommended strategy, investment required]

**Current Workforce:** [X] FTEs, $[X]M fully-loaded cost
**Projected Demand (24mo):** [X] FTEs (base case)
**Projected Supply (24mo):** [X] FTEs (after attrition)
**Net Gap:** [X] FTEs ([X] skill gaps, [X] location gaps)
**Recommended Strategy Mix:** Build [X]% / Buy [X]% / Borrow [X]% / Bot [X]%
**Total Investment Required:** $[X]M over [X] months

---

## 2. Current State Analysis

### Workforce Profile
[Headcount tables by function, level, location, employment type]

### Skills Inventory Summary
[Top skill strengths and gaps]

### Cost Structure
[Fully-loaded cost per FTE by level and function]

---

## 3. Future Demand Projections

### Scenario Summary
[Base / Upside / Downside demand by function]

### Key Strategic Drivers
[Strategy-to-workforce linkage table]

---

## 4. Supply Forecast

### Attrition Projections
[By segment with risk factors]

### Internal Pipeline
[Promotable talent, retirement risk]

### Labor Market Assessment
[Critical role availability and competition]

---

## 5. Gap Analysis

### Headcount Gaps
[Surplus/shortage by function and role]

### Skills Gaps
[Critical skill gaps with severity and urgency]

---

## 6. Build / Buy / Borrow / Bot Recommendations

[Decision matrix for each critical gap]

---

## 7. 24-Month Workforce Action Plan

[Phased roadmap with quarterly milestones]

---

## 8. Cost Model

[Current vs. future state cost comparison, ROI of workforce investments]

---

## 9. Automation Impact Assessment

[Task-level analysis, FTE displacement/augmentation projections]

---

## 10. Risk and Contingency

| Risk | Likelihood | Impact | Mitigation |
|------|-----------|--------|------------|
| Attrition exceeds forecast | | | |
| Skills not available in market | | | |
| Automation delays | | | |
| Budget constraints | | | |

---

## 11. Recommended Next Steps

1. [Immediate action with owner and deadline]
2. [Second action]
3. [Third action]

Quality Checks

• Workforce plan explicitly links to business strategy -- every headcount change traced to a strategic driver
• Planning horizon is 12-24 months with quarterly milestones, not just a point-in-time snapshot
• Build/Buy/Borrow/Bot analysis provides decision criteria for each gap -- not a blanket recommendation
• Attrition modeling uses historical data with trend adjustment -- not a single flat rate
• Skills gaps are assessed at the proficiency level, not just skill presence/absence
• Cost model uses fully-loaded cost per FTE (base + variable + benefits + taxes + overhead) -- not salary alone
• Workforce segmentation distinguishes strategic from core from support roles
• Automation assessment is at the task level within roles -- not role-level generalizations
• Capacity modeling accounts for availability and productivity factors -- not gross FTE
• Contingent workforce strategy addresses compliance, governance, and conversion pipeline
• Scenario planning includes base, upside, and downside cases with different workforce implications
• Labor market analysis covers availability, compensation, and time-to-fill for critical roles
• Plan includes risk register with mitigation strategies for execution risks