# Workforce Planning

> 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.

- Skill: `kaakati/workforce-planning` (Agent Skill)
- Install (CLI): `npx skillmds@latest add kaakati/workforce-planning`
- Raw SKILL.md: https://api.skillmd.com/api/skills/kaakati/workforce-planning/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: Kaakati (https://skillmd.com/u/kaakati)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/kaakati/workforce-planning

---


# 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

```markdown
# 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