Markus Pöllmann.
← Back to application portfolio
Illustrative example. "Studio Lumen Productions", its business units, roles, and all figures below are synthetic — built to demonstrate the tool's logic and output, not a real company's workforce plan. The structure and reasoning match the production tool I built and operate for real multi-year staffing decisions.
Scenario Studio Lumen Productions — FY2027
Scenario
Studio Lumen Productions — FY2027 Executive Summary

Rolls up staffing plans across 20+ projects into demand vs. capacity by role, month, and business unit — auto-generates hiring / freelance / reallocation recommendations from the underlying gap, not from a gut call.

Five business units, 35 roles, monthly granularity, multi-year planning via fiscal-year scenarios. The pages that follow are exactly what the Executive Summary tab renders for a given fiscal year — flick through to see how the tool gets from raw staffing plans to a board-ready recommendation.

1 · Overview
Where FY2027 stands
Net FTE Gap, FY2027
−1.6
Across all roles & business units
Roles at Risk
2
Gap ≥0.4 FTE for >5 months
Hiring Recommended
1
Editor — permanent FTE
Freelance Extension
1
Line Producer — Q3–Q4
2 · Demand vs. Capacity
The role driving the gap: Editor

Demand vs. Capacity — Editor Role

FY2027, Jan–Jun · FTE per month
Capacity Demand
JanFebMarAprMayJun
3 · Role Detail
Every role, side by side

Role-Level Detail, FY2027 Average

RoleDemand (FTE)Capacity (FTE)Δ FTERecommendation
Editor6.24.8−1.4Hire
Line Producer4.03.1−0.9Freelance
Production Coordinator5.55.3−0.2Balanced
Post-Production Supervisor2.82.9+0.1Balanced
Producer3.03.9+0.9Reallocate
Result
Recommended actions
→
Bottom line
Hire 1 Editor FTE by Q2 · extend Line Producer freelance through Q3–Q4
Everything else on the roster is within tolerance for FY2027.
  • Hire one additional Editor FTE by end of Q2 FY2027 — demand exceeds capacity by ≥1.4 FTE for 5 consecutive months, past the threshold for a permanent-hire recommendation.
  • Extend the Line Producer freelance pool through Q3–Q4 — the gap is real but below the hiring threshold; freelance coverage is the lower-commitment fix.
  • Producer capacity runs 0.9 FTE ahead of demand for FY2027 — reallocate toward the Factual slate before considering headcount reduction.
  • Production Coordinator and Post-Production Supervisor are within tolerance (±0.2 FTE) — no action required.
Swipe, use ← → , or click a step number