SOP: Resource Planning in Microsoft Project
🎯 Purpose
Resource Planning is the process of assigning the right people, equipment, and materials to the right tasks at the right time.
The goal is to:
Avoid overloading team members✓
Prevent resource conflicts✓
Improve productivity✓
Balance daily workloads✓
Complete the project on schedule✓
1. What is a Resource?
In Microsoft Project, a resource is anything needed to complete a task.
👷 Work Resources
People or equipment that perform work.
Examples:
Site Engineer
Supervisor
Foreman
Mason
Electrician
Excavator
Crane
📦 Material Resources
Consumable items used during construction.
Examples:
Cement
Sand
Rebar
Bricks
Paint
💰 Cost Resources
Special expenses not based on work hours.
Examples:
Permit Fee
Inspection Fee
Transportation Cost
2. Resource Planning Workflow
Create Tasks
↓
Create Resources
↓
Assign Resources
↓
Check Workload
↓
Resolve Conflicts
↓
Track Progress
↓
Adjust Resources
3. Step 1: Create Resources
Open Resource Sheet
View
↓
Resource Sheet
Enter:
| Resource Name | Type | Max Units |
|---|---|---|
| Site Engineer | Work | 100% |
| Supervisor | Work | 100% |
| Mason Team | Work | 100% |
| Electrician | Work | 100% |
| Crane | Work | 100% |
Meaning of Max Units
100%
One full-time resource
Example:
Site Engineer = 100%
Can work on one full-time task.
200%
Two resources available
Example:
Mason Team = 200%
Means:
2 Masons Available
500%
5 Workers Available
4. Step 2: Assign Resources to Tasks
Open:
Gantt Chart
Insert:
Resource Names Column
Example:
| Task | Resource |
|---|---|
| Site Survey | Site Engineer |
| Excavation | Excavator |
| Foundation | Mason Team |
| Electrical Installation | Electrician |
| Final Inspection | Supervisor |
5. Step 3: Check Resource Workload
Open:
View
↓
Resource Usage
Microsoft Project shows:
Resource
↓
Assigned Tasks
↓
Hours Per Day
Example:
| Resource | Monday |
|---|---|
| Site Engineer | 8h |
| Site Engineer | 10h |
Total:
18h/day
⚠ Resource Overallocated
6. Resource Overallocated
A resource is overallocated when:
Required Work
>
Available Capacity
Example:
Site Engineer Available = 8h/day
Assigned Work = 12h/day
Result:
Overallocated
Microsoft Project shows a red indicator.
7. Step 4: Resolve Resource Conflicts
Method 1: Delay Tasks
Move one task later.
Before:
Task A
Task B
Same Engineer
Same Time
After:
Task A
↓
Task B
No conflict.
Method 2: Add More Resources
Before:
1 Mason Team
After:
2 Mason Teams
Workload becomes balanced.
Method 3: Resource Leveling
Microsoft Project can automatically adjust schedules.
Open:
Resource
↓
Leveling Options
↓
Level All
Microsoft Project will:
Delay conflicting tasks
Reduce resource overload
Create a more realistic schedule
8. Resource Graph
Open:
View
↓
Resource Graph
This shows:
Resource Demand
vs
Resource Capacity
Example:
Blue Bar = Resource Usage
If the bar exceeds capacity:
Overallocated
9. Best Practice for Construction Projects
Site Engineer
Avoid assigning:
Site Inspection
+
Material Check
+
Client Meeting
At the same time.
Supervisor
Avoid supervising:
Foundation
+
Roof Work
+
Electrical Work
Simultaneously if only one supervisor is available.
Equipment
Example:
One Crane
Cannot be assigned to:
Building A
+
Building B
At the same time.
10. Recommended Weekly Resource Review
Every week check:
Resource Usage
Who is overloaded?
Resource Graph
Where are the peaks?
Resource Leveling
Can conflicts be removed?
Schedule Impact
Will adjustments delay the project?
Key Principle
A good schedule is not only about tasks. It is about having the right resources available when the tasks need them.
Simple Formula
Good Resource Planning
=
Right Resource
+
Right Task
+
Right Time
+
Right Capacity
This is the foundation of professional project scheduling in Microsoft Project, especially for construction projects where labor, equipment, and materials must be coordinated efficiently every day.