Your best carpenters are assigned to two job sites at the same time. Your 40-ton crane is supposed to be in Laval on Tuesday while it is still finishing formwork in Longueuil. Your plumbing subcontractor cannot be in three places at once. Every construction contractor in Quebec has lived these situations. The shared resource pool in MS Project is designed precisely to make them visible, predictable and solvable.
Here is how this professional technique works, why it changes a project manager’s life, and how to integrate it into your construction management.
What is a shared resource pool?
A resource pool is a centralized file containing all of your company’s resources — people, equipment and costs — shared across multiple projects. Instead of creating separate resources in each MPP file, you define them once in a master file, and all your projects connect to it.
In practice, the pool contains:
- Your crews: carpenters, foremen, electricians, plumbers, equipment operators.
- Your equipment: cranes, excavators, concrete mixers, scaffolding.
- Your regular subcontractors with their maximum capacity.
- Hourly costs and negotiated rates for each resource.
- Specific availability calendars (vacations, training, equipment maintenance).
Why it is a game-changer in construction
In a construction company running several projects in parallel, the resource pool solves three major problems:
1. Automatic detection of cross-project overallocations
Without a shared pool, each project manager plans “their” project assuming their crews are fully dedicated to it. With a pool, MS Project compares the cumulative assignments across all projects and immediately flags when a crew exceeds its capacity (for example, 60 hours planned in a week instead of 40).
2. A consolidated view of the project portfolio
Management can see at a glance the forecast utilization of each resource over 3, 6 or 12 months. This view makes it possible to plan hiring, equipment rentals and subcontractor negotiations ahead of time.
3. Consolidated costs in real time
Because each resource has a cost defined only once in the pool, labour and equipment costs are automatically calculated across the entire portfolio. No more separate Excel sheets to add up budgets.
How to set up a resource pool
- Create a “Pool” MPP file containing only the list of resources and their properties (cost, capacity, calendar).
- Save this file in a shared network location accessible to all project managers (OneDrive, SharePoint or an internal server).
- For each new project, open the project’s MPP file and use the “Share Resources” feature to connect it to the pool.
- Define update rules: who can edit the pool and how often each project manager refreshes their assignments.
- Audit the detected conflicts monthly and adjust the schedule.
Resolving conflicts: practical options
When the pool flags an overallocation, several levers can be used. The right choice always depends on a cost/impact comparison:
- Automatic leveling: MS Project automatically delays non-critical tasks to avoid overallocation while respecting the critical path.
- Overtime: quick to implement, but costly and not sustainable. Limit it to occasional peaks.
- Temporary hiring: useful if the workload extends over several weeks. Run the numbers first.
- Subcontracting: transfers the risk but reduces your margin. Often the right answer for unexpected peaks.
- Postponing a project: an option to negotiate with the client if contractual penalties are manageable.
- Equipment rental: for equipment conflicts, compare renting versus buying based on expected usage.
The most common mistakes
- Defining resources as “groups” instead of individuals: you lose the granularity needed to detect real conflicts.
- Forgetting availability calendars: construction holidays, Quebec statutory holidays, mandatory continuing education.
- Not updating the pool: a frozen pool quickly becomes wrong.
- Letting several people edit the pool at the same time: risk of file corruption. Appoint a pool owner.
- Not training project managers: without training, the tool remains underused.
The real financial impact: an example
Let’s take a concrete case. A company runs 4 residential projects at once with 12 carpenters and 2 foremen. Without a shared pool, the project managers do not see that, in the week of June 15, their combined plans require 18 carpenters. The result: cascading delays, unplanned overtime and emergency subcontracting at premium prices.
With a pool, the overallocation is detected 6 weeks in advance. The company has time to negotiate a subcontractor at a normal rate, shift a non-critical task or move up a material delivery. The cost avoided often far exceeds the cost of the tool and the training.
Going further
Effective resource pool management relies on rigorous planning and a clear view of your schedules. See also:
- Multi-project management in construction with MS Project — structure the coordination of all your projects in a master project.
- Gantt charts in construction — visualize the dependencies and critical milestones of your projects.
🎓 Master the resource pool with RBQ-recognized training
CalcosaTech offers official training recognized by the Régie du bâtiment du Québec (training number 5877-4407-F001) that dedicates a significant part to shared resource pools: setup, automatic leveling, cross-project conflict analysis, decision scenarios and consolidated financial tracking. Hands-on training grounded in the reality of Quebec construction sites.
Training hours are reported to the RBQ and count toward your continuing education requirements.
Contact us for pricing and to schedule a session tailored to your team.