Balancing Skills Capacity With Demand Across Your Portfolio of Projects

Managing a portfolio of projects with a limited pool of resources can be an exciting ride. No sooner do you have the skills demand nicely matching your capacity when an unexpected change arrives, throwing it out of balance. The challenge is to maintain high levels of resource utilization, when each project has its own priority, timeline and skills requirements.

Figuring out the right balance is not straightforward. There must be some spare resources on hand so that key project dates will be met, yet too many just hanging around will erode utilization levels and can rapidly reduce operational profits.

The financial rewards for getting it right are significant. The UK Association of Consulting Engineers (members benchmark survey, 2011) found that a 2% increase in staff billing would increase their members’ profitability by around a third. This is a rich reward for a relatively modest increase in resource utilization.

In more than 25 years’ experience of working with multi-project organizations, I have seen a common approach to how the successful ones tackle this. It boils down to having the right management information and an effective demand management process. This article focuses on these two aspects.

Management Information

There are a number of key reports that give the required visibility:

1. Forward Loading across the organization


The table is a heatmap that highlights periods of overload in red and underuse in green. Amber shows where the target utilization is being achieved. Clicking on the Department hyperlink drills progressively down into each corner of the organization, to identify the cause of any bottleneck.

Working down the Pipeline leg we see a demand of up to 10 Engineer Grade 1’s per month from new projects on a team of just 5, and only 1 of those is free.

2. Tracking resource utilization.

This report shows the utilization history for each department or team. It shows how close they are to meeting targets and if the trend is positive or not.


It looks as if the anticipated upturn in demand on the Mechanical department did not materialize.

3. Tracking outstanding request for resource.

Reports for the requesters (project managers) and resource suppliers (team leaders) highlight unfulfilled requests that could delay the start of project tasks.

Management places high reliance on these reports for making those important decisions on hiring, firing or retraining staff. For the reports to be credible, the underlying data must be current, complete and accurate. This means that the demand management process must be well defined and adhered too.

Managing changes in demand

Many multi-project organizations face high volatility in demand, because change can arise from such a variety of sources. These range from new projects or service request arriving unexpectedly, through clients deciding to postpone the next project phase, or key resources leaving at short notice. Project schedules and resource capacity levels need to be kept up to date, so that the forward loading report will show new bottlenecks and periods of under use as they arise.

There could well be a need to rebalance the workload, to see if new bottlenecks can be reduced without jeopardizing key project dates. This is where ‘What If… analysis steps in.

What If scenarios

The previous section showed reports for the committed projects only. But how to see the impact of new projects arriving? With ‚ÄòWhat if ‚Ķ’ scenarios you can selectively layer potential projects on top of the committed workload, so that the resource implications of their award will stand out. If a new project of high priority causes a bottleneck, then lower priority ones may need to be delayed. This is most easily shown with a Video. These scenarios usually work on a copy of the live data, so only when there is a consensus on the way forward will the changes be applied. ‚ÄòWhat if‚Ķ’ analysis is particularly useful in more volatile multi-project environments, where significant changes frequently occur.

So, when managing multiple projects, a few simple reports and an effective demand management process should see resource utilization levels start to rise. The financial rewards suggested by the Association of Consulting Engineers can then start to flow.


Recommended Project Management Software

If you’re interested in learning more about top rated project management software, the editors at actively recommend the following:


Visit website Work OS is the project management software that helps you and your team plan, execute, and track projects and workflows in one collaborative space. Manage everything from simple to complex projects more efficiently with the help of visual boards, 200+ ready-made templates, clever no-code automations, and easy integrations. In addition, custom dashboards simplify reporting, so you can evaluate your progress and make data-driven decisions.

Learn more about

2 ClickUp

Visit website

ClickUp is one of the highest-rated project management tools today. Use Docs, Reminders, Goals, Calendars, Chat, scheduling, assigned comments, custom views, & more with this all-in-one project management tool.

Used by 800,000+ teams in companies like Airbnb, Google, and Uber, it brings all of your projects into a single app! Built for teams of all sizes and industries, Our fully customizable & proprietary features make it a must-have for anyone wanting to keep project management in one place.

Learn more about ClickUp

3 Wrike

Visit website

Tackle complex projects with Wrike’s award-winning project management software. Break projects into simple steps, assign tasks to team members, and visualize progress with Gantt charts, Kanban boards, and calendars. Manage resource allocation and forecasting with software that’s easy to launch. Automation and AI features strip away time-consuming admin tasks so you can do the best work of your life. Streamline your practices, align your team, and ensure you hit deadlines and stay on budget.

Learn more about Wrike

Share Article


Barry Muir Avatar
Get the Free Newsletter!
Subscribe to Project Management Insider for best practices, reviews and resources.
This email address is invalid.
Get the Free Newsletter!
Subscribe to Project Management Insider for best practices, reviews and resources.
This email address is invalid.

Demos, trials & More information

Check out our library of 60+ pm books