Scenario FTE controls
Add or remove FTE by role and recalculate capacity immediately.
Power BI visual
Workforce planning
MVP package
Workforce Capacity Planner
by Zaratuk
A Power BI custom visual for modelling workforce capacity, FTE scenarios, utilization, demand gaps, and cost impact by department and position role.
Overview
Workforce capacity modelling directly inside Power BI.
Capacity Planner helps operational teams compare current staffing capacity against demand, then test the effect of adding or removing FTE by role. It is built for service delivery, case management, call center, public-sector, HR, and workforce planning reports where standard charts do not provide enough interaction.
- Model current capacity from current FTE and productivity per FTE.
- Add or remove scenario FTE by position role with immediate recalculation.
- Compare demand, current capacity, scenario capacity, gap, and utilization.
- Estimate required FTE and cost impact when cost per FTE is available.
- Use optional department grouping and optional cost fields.
- Run without a backend, external API, authentication service, writeback, or database.
Workforce Capacity Planner
Scenario dashboard mockup
Demand
7,900
Scenario capacity
8,250
Gap
+350
Officer
Scenario FTE change +2
- +2 +
Supervisor
Scenario FTE change 0
- 0 +
Agent
Scenario FTE change +1
- +1 +
Visual capabilities
Built for scenario planning workflows.
Executive summary
Surface demand, capacity, gap, required FTE, utilization, and cost impact.
Capacity and cost views
Split operational coverage from cost analysis to reduce table clutter.
Friendly missing-field state
Required fields are clear; Department and Cost per FTE remain optional.
Premium-ready settings
Demand shocks and advanced formatting can be shown disabled in Free mode.
Local-only state
No backend, writeback, external service, database, or authentication dependency.
Free
Core capacity modelling
The current downloadable package includes the core planner: role FTE changes, executive cards, interpretation text, capacity table, cost view when cost data exists, and local scenario state.
Premium mode
Advanced controls shown clearly
Premium modules such as demand shock modelling and advanced customization are visible with clear disabled messaging in Free mode. Premium mode is currently a visual setting, not secure license enforcement.
Field mapping
Required and optional inputs.
Power BI can aggregate repeated department-role combinations before calculation. Demand and current FTE are summed; productivity and cost are averaged.
| Field | Type | Requirement | Example |
|---|---|---|---|
| Position Role | Categorical | Required | Officer, Supervisor, Agent |
| Demand Volume | Numeric measure | Required | 1200 |
| Productivity per FTE | Numeric measure | Required | 200 |
| Current FTE | Numeric measure | Required | 5 |
| Department | Categorical | Optional | Passport, Calls |
| Cost per FTE | Numeric measure | Optional | 100000 |
Details + support
Publisher information
- Privacy policy
- https://zaratuk-website.pages.dev/privacy/
- Documentation
- /products/capacity-planner/#overview
Important notes
Current MVP limits
- No scenario saving, writeback, backend, authentication, or collaboration.
- No AppSource license enforcement yet.
- Scenario adjustments reset when the visual reloads.
- Cost impact is shown only when Cost per FTE is bound.
- Microsoft certification is not claimed until AppSource review is complete.
Get the visual
Test Capacity Planner in Power BI Desktop.
Download the current package and sample data. AppSource submission assets are being prepared, so this page mirrors the information buyers will see in the marketplace.