SOP: Prevent Resource Conflicts in Microsoft Project
🎯 What is a Resource Conflict?
A resource conflict happens when the same person, equipment, or team is assigned to multiple tasks at the same time.
Example
Site Engineer
├─ Site Inspection
├─ Client Meeting
└─ Material Check
All scheduled at 9:00 AM Monday.
The engineer cannot perform all three tasks simultaneously.
Result:
⚠ Resource Conflict (Overallocation)
Step 1: Identify Resource Conflicts
Method 1: Resource Sheet
Open:
View
↓
Resource Sheet
Look for:
Red resource names
Red overallocation icon in Indicators
These indicate a resource conflict.
Method 2: Resource Usage View
Open:
View
↓
Resource Usage
Example:
Site Engineer
Monday
Site Survey 4h
Client Meeting 4h
Material Check 4h
Total:
12h/day
Available:
8h/day
Conflict detected.
Method 3: Team Planner (Recommended)
Open:
View
↓
Team Planner
Microsoft Project highlights overlapping assignments.
This is the easiest view for construction managers.
Step 2: Understand the Cause
Most conflicts come from:
1. One Person Assigned to Multiple Tasks
Example:
Engineer
├─ Survey
├─ Inspection
└─ Meeting
2. One Equipment Assigned Twice
Example:
Crane
├─ Building A
└─ Building B
at the same time.
3. Too Few Workers
Example:
2 Masons Available
but work requires:
5 Masons
Step 3: Resolve Resource Conflicts
Solution 1: Reschedule Tasks
Move one task to another day.
Before:
Monday
Task A
Task B
Task C
After:
Monday
Task A
Tuesday
Task B
Wednesday
Task C
Solution 2: Use Team Planner Drag-and-Drop
Open:
View
↓
Team Planner
Drag the conflicting task to another date.
Example:
Client Meeting
Move from Monday to Tuesday.
Fast and simple.
Solution 3: Add Additional Resources
Example:
Before:
1 Site Engineer
After:
2 Site Engineers
or
Engineer A
Engineer B
The workload becomes shared.
Solution 4: Split the Task
Example:
Instead of:
Material Inspection
8 Hours
Use:
Material Inspection Part 1
4 Hours
Material Inspection Part 2
4 Hours
This creates flexibility.
Solution 5: Assign Multiple Resources
Instead of:
Concrete Pour
Engineer A
Use:
Concrete Pour
Engineer A
Supervisor
Work is distributed.
Step 4: Use Resource Leveling
Microsoft Project can automatically resolve many conflicts.
Open:
Resource
↓
Leveling Options
↓
Level All
Microsoft Project will:
Delay tasks
Adjust schedules
Remove overallocation
Automatically.
Step 5: Set Priorities Before Leveling
Not all tasks should move.
Example:
| Task | Priority |
|---|---|
| Foundation | 1000 |
| Site Cleaning | 100 |
Set:
Task Information
↓
General
↓
Priority
When leveling:
High-priority tasks stay.
Low-priority tasks move first.
Construction Example
Problem
One supervisor assigned to:
Foundation Inspection
Electrical Inspection
Client Walkthrough
Same day.
Result:
Supervisor = 14h/day
Conflict.
Solution
Reschedule:
Monday
Foundation Inspection
Tuesday
Electrical Inspection
Wednesday
Client Walkthrough
Now:
≤ 8h/day
No conflict.
Best Practice for 8AM Contractor
Before finalizing your weekly schedule:
Check Resource Usage
Who works more than 8h/day?
Check Team Planner
Who has overlapping tasks?
Run Resource Leveling
Resource → Level All
Review Critical Activities
Make sure important construction activities are not delayed.
Key Principle
Resource conflicts occur when demand is greater than available capacity.
Simple Formula:
Resource Conflict
=
Required Work
>
Available Capacity
To prevent conflicts:
Plan Tasks
+
Assign Resources
+
Check Workload
+
Level Resources
=
Conflict-Free Schedule
In real construction projects, the most powerful combination is:
Resource Usage
+
Team Planner
+
Resource Leveling
These three tools allow you to detect, visualize, and resolve resource conflicts before they create delays on site.