Compare planned work with available capacity.
Fictional worked example. These are illustrative inputs, not customer results.
Starting point
Fictional example โ not a customer result: A fictional consultancy supplies ten team roles and 14 projects for the next quarter.
Illustrative delivery
Illustrative output: The planner compares allocated hours with available hours and highlights overlapping commitments without choosing which people or projects to cut.
What you receive
- Excel capacity planner
- weekly workload views
- overallocation flags
- instructions and assumptions
What we check
Reconcile weekly totals; test leave, zero availability and fractional hours; verify 15-person and 20-project capacity; no hidden overtime assumptions.
Your completed package uses your approved source material and agreed assumptions. This example is not a guarantee of business results.