Master Resource Management Using Microsoft Project in 20 Minutes
A Practical Guide for Construction Managers, Engineers, and Project Leaders
Source Video:
Master Resource Management Using Microsoft Project in 20 Minutes! 🎥
Reference Notes: Based on the video transcript provided by the user.
Introduction
One of the biggest reasons projects fail is not because of poor scheduling, but because of poor resource management.
A project may have a perfect timeline, but if workers, equipment, materials, or costs are not managed properly, delays and budget overruns become unavoidable.
Microsoft Project provides powerful resource management tools that help project managers:
Assign workers correctly
Monitor workload
Track materials
Control project costs
Detect resource conflicts
Balance workloads
For construction contractors, engineers, and project managers, resource management is one of the most valuable skills to master.
What is Resource Management?
Resource Management is the process of planning, assigning, tracking, and controlling the resources needed to complete project activities.
Resources can include:
Workers
Teams
Equipment
Materials
Fixed costs
Microsoft Project allows managers to organize all these resources in one system and monitor their utilization throughout the project.
The Three Types of Resources in Microsoft Project
Microsoft Project uses three main resource types:
1. Work Resources
Work Resources are people or equipment that perform work.
Examples:
Human Resources
Project Manager
Site Engineer
Foreman
Mason Team
Rebar Team
Electrician Team
Equipment Resources
Concrete Mixer
Excavator
Crane
Generator
Testing Machine
These resources consume time while performing tasks.
Construction Example
Task:
Install Reinforcement Bars
Assigned Resources:
Rebar Team
Site Engineer
Microsoft Project calculates:
Labor hours
Resource utilization
Labor cost
2. Material Resources
Material Resources are consumable items used during project execution.
Examples:
Concrete
Steel
Bricks
Sand
Cement
Paint
Unlike Work Resources, materials are consumed and cannot be reused.
Construction Example
Task:
Pour Foundation
Material Resources:
Concrete = 50 m³
Rebar = 5 tons
Microsoft Project tracks:
Quantity used
Cost of materials
Material consumption
3. Cost Resources
Cost Resources represent fixed expenses associated with tasks.
Examples:
Building Permit
Equipment Rental
Insurance
Transportation Fees
Consultant Fees
These resources only track money, not labor hours or quantities.
Construction Example
Task:
Obtain Construction Permit
Cost Resource:
Permit Fee = $500
Microsoft Project records the expense without affecting labor calculations.
Step 1: Open Resource Sheet
Before assigning resources, create your resource database.
Navigation
View → Resource Sheet
or
Right Click Left Panel → Resource Sheet
The Resource Sheet acts as your project resource inventory.
Here you enter:
Resource Names
Resource Types
Capacity
Rates
Cost Information
Step 2: Create Work Resources
Example Team:
| Resource | Type |
|---|---|
| Project Manager | Work |
| Marketing Coordinator | Work |
| Vendor Manager | Work |
| Graphic Designer | Work |
| Volunteers | Work |
For construction projects, replace these with:
| Resource | Type |
|---|---|
| Site Engineer | Work |
| Mason Team | Work |
| Rebar Team | Work |
| Formwork Team | Work |
| Electrician Team | Work |
Step 3: Define Maximum Units
Maximum Units represent resource availability.
100%
Means:
One full-time person.
Example:
Site Engineer = 100%
Available full time.
50%
Means:
Half-time availability.
Example:
Architect = 50%
Only available half of working hours.
300%
Means:
Three workers.
Example:
Mason Team = 300%
Equivalent to:
Mason 1
Mason 2
Mason 3
Working simultaneously.
Step 4: Set Standard Rate
Standard Rate represents normal hourly cost.
Examples:
| Resource | Standard Rate |
|---|---|
| Site Engineer | $20/hr |
| Mason Team | $15/hr |
| Electrician Team | $18/hr |
Microsoft Project uses these values to calculate labor cost automatically.
Step 5: Set Overtime Rate
Overtime Rate is the cost for extra working hours.
Example:
| Resource | Standard | Overtime |
|---|---|---|
| Site Engineer | $20/hr | $30/hr |
| Mason Team | $15/hr | $22/hr |
This helps monitor overtime expenses.
Step 6: Set Accrual Method
Accrual determines when costs are charged.
Microsoft Project provides three options.
Prorated
Cost accumulates gradually while work progresses.
Best for:
Salaries
Daily wages
Labor crews
Example:
Mason Team works 10 days.
Cost is spread across 10 days.
Start
Cost occurs at task start.
Best for:
Material purchases
Deposits
Advance payments
Example:
Purchase concrete before pouring begins.
End
Cost occurs after task completion.
Best for:
Contractor payments
Equipment rental settlement
Example:
Pay supplier after delivery is completed.
Step 7: Create Material Resources
Examples:
| Material | Unit |
|---|---|
| Concrete | m³ |
| Rebar | ton |
| Brick | pcs |
| Paint | L |
Enter:
Material Label
Unit Cost
Accrual Type
Example
Concrete
Unit:
m³
Cost:
$80/m³
Microsoft Project automatically calculates:
50 m³ × $80 = $4,000
Step 8: Create Cost Resources
Examples:
| Cost Resource | Cost |
|---|---|
| Building Permit | $500 |
| Insurance | $1,000 |
| Equipment Rental | $2,000 |
These costs can be assigned directly to tasks.
Step 9: Assign Resources to Tasks
Navigation
Resource Tab → Assign Resources
A dialog box appears showing all project resources.
Example
Task:
Foundation Excavation
Assign:
Excavator
Operator
Site Engineer
Microsoft Project automatically calculates:
Labor hours
Resource costs
Total task cost
Step 10: Assign Resources to Summary Tasks
A useful technique shown in the video is assigning a resource to a summary task.
Example:
Project Manager assigned to:
Construction Project
100%
Microsoft Project automatically spreads the manager's involvement throughout the project duration.
This saves time and reduces repetitive assignments.
Step 11: Assign Material Quantities
Example:
Task:
Concrete Pouring
Resources:
| Resource | Quantity |
|---|---|
| Concrete | 50 m³ |
| Rebar | 5 ton |
Microsoft Project calculates:
Total Material Cost automatically.
Step 12: Assign Cost Resources
Example:
Task:
Obtain Permit
Cost Resource:
Building Permit = $500
Task:
Equipment Rental
Cost Resource:
Crane Rental = $1,500
These costs appear directly in project budgets.
Step 13: Split Vendor Payments
An advanced technique from the video is splitting payments.
Example:
Crane Rental = $4,000
Down Payment
Task:
Sign Contract
Cost:
$1,000
Final Payment
Task:
Complete Crane Work
Cost:
$3,000
This provides more accurate cash flow forecasting.
Understanding Resource Overallocation
After assigning resources, Microsoft Project may display a:
🔴 Red Person Icon
This means:
Resource Overallocation
Example:
Mason Team assigned to:
Brick Wall Construction
Concrete Casting
At the same time.
But only one team exists.
Microsoft Project detects the conflict.
How to Resolve Overallocation
Several methods exist.
Option 1: Delay One Task
Move one activity to a later date.
Option 2: Add More Workers
Increase:
Mason Team
From:
300%
To:
600%
if six workers are available.
Option 3: Split the Crew
Create:
Mason Team A
Mason Team B
Assign separately.
Option 4: Use Resource Leveling
Navigation
Resource → Level Resources
Microsoft Project automatically adjusts schedules to eliminate conflicts.
Resource Management Workflow for Construction Projects
Step 1
Create WBS
Step 2
Create Schedule
Step 3
Open Resource Sheet
Step 4
Create Labor Crews
Mason Team
Rebar Team
Formwork Team
Electrician Team
Step 5
Create Material Resources
Concrete
Steel
Brick
Step 6
Create Cost Resources
Permit
Equipment Rental
Insurance
Step 7
Assign Resources
Step 8
Check Resource Usage
Step 9
Identify Overallocation
Step 10
Level Resources
Step 11
Track Progress Weekly
Step 12
Monitor Cost Performance
Key Lessons
Resource Management in Microsoft Project is built around three resource types:
Work Resources → People and Equipment
Material Resources → Consumable Materials
Cost Resources → Fixed Expenses
By correctly setting up resources, project managers can:
Track manpower
Monitor equipment usage
Control material consumption
Forecast project costs
Detect overloads
Balance workloads
Improve schedule reliability
For construction contractors like 8AM Contractor, mastering Resource Sheet, Resource Assignment, Resource Usage, and Resource Leveling is one of the fastest ways to transform Microsoft Project from a simple scheduling tool into a complete project management system.