🏡 To use Microsoft Project for Weekly Tracking with Cost Impact, you should build a system that tracks:

1. Planned Progress

2. Actual Progress

3. Weekly Cost Spent

4. Delay Impact

5. Cost Variance

6. Labor / Material / Equipment Cost Impact

---

Weekly Tracking with Cost Impact in Microsoft Project

1. Create Your Baseline (Very Important)

Before construction starts:

Go to:

Project → Set Baseline → Set Baseline

This saves:

• Planned Duration

• Planned Cost

• Planned Start/Finish

• Planned Work

Without baseline → you cannot compare planned vs actual.

---

2. Prepare Main Columns for Weekly Tracking

Add these columns in Gantt Chart View:

Tracking Area	Column
Task Progress	% Complete
Planned Cost	Baseline Cost
Actual Cost	Actual Cost
Remaining Cost	Remaining Cost
Cost Variance	Cost Variance
Planned Finish	Baseline Finish
Actual Finish	Finish
Delay	Finish Variance
Work Hours	Actual Work
Remaining Hours	Remaining Work

---

3. Weekly Site Update Process

Every week:

Step 1 — Update Actual Progress

Example:

Task	Planned	Actual
Concrete Slab	100%	70%

Update:

• % Complete

• Actual Start

• Actual Finish

• Actual Work

---

Step 2 — Update Weekly Cost

You can track:

• Labor

• Material

• Equipment

• Subcontractor

Example:

Resource	Weekly Cost
Carpenter Team	$800
Concrete	$1200
Crane	$500

Update in:
Resource Sheet

or

Task Usage View

---

4. Understand Cost Impact

Microsoft Project automatically calculates:

A. Cost Variance

Formula:

Cost\ Variance = Baseline\ Cost - Actual\ Cost

Example:

Baseline	Actual
$10,000	$13,000

Impact:

• Over budget = $3,000

---

B. Schedule Delay Impact

Formula:

Finish\ Variance = Actual\ Finish - Baseline\ Finish

Example:

• Planned Finish = Friday

• Actual Finish = Next Tuesday

Result:

• 4 days delay

---

5. Weekly Tracking Workflow (Real Construction Method)

Every Saturday or Sunday

Site Engineer Updates:

• Actual quantity completed

• Labor used

• Material consumed

• Delay reason

Project Manager Updates:

• % complete

• Cost

• Variance

• Recovery action

---

6. Use Tracking Gantt View

Go to:

View → Tracking Gantt

This shows:

Bar Color	Meaning
Gray	Baseline
Blue	Current Plan
Red	Delayed

Very useful for weekly meetings.

---

7. Create Weekly Cost Report

Recommended Tables

A. Weekly Progress Report

Task	Planned %	Actual %	Delay

---

B. Weekly Cost Impact Report

Item	Budget	Actual	Variance
Labor	$5,000	$6,200	+$1,200
Material	$10,000	$9,500	-$500

---

8. Use Earned Value Analysis (Professional Method)

In Microsoft Project:

Add Columns:

• BCWS

• BCWP

• ACWP

• CV

• SV

• CPI

• SPI

These are professional project control metrics.

---

Important Formulas

Cost Performance Index (CPI)

CPI = \frac{EV}{AC}

• CPI > 1 = Good

• CPI < 1 = Over budget

---

Schedule Performance Index (SPI)

SPI = \frac{EV}{PV}

• SPI > 1 = Ahead

• SPI < 1 = Delay

---

9. Best Weekly Tracking Structure for Construction Projects

Recommended WBS

1. Site Preparation
2. Foundation
3. Structure
4. Masonry
5. MEP
6. Finishing
7. Handover

Each activity should contain:

• Duration

• Cost

• Resource

• Responsible person

---

10. Practical Construction Workflow (Your GC Team)

For your construction team:

Site Team

Reports:

• Daily progress

• Material usage

• Worker count

Office Team

Updates:

• Microsoft Project

• Cost tracking

• Delay analysis

• Weekly dashboard

---

11. Professional Weekly Meeting Format

Weekly Meeting Topics

Schedule

• Planned vs Actual

Cost

• Budget vs Actual

Delay

• Cause

• Impact

• Recovery Plan

Resource

• Labor shortage?

• Material shortage?

• Equipment issue?

---

12. Recommended Microsoft Project Views

View	Purpose
Gantt Chart	Main schedule
Tracking Gantt	Delay tracking
Resource Sheet	Resource cost
Task Usage	Weekly work hours
Team Planner	Team allocation
Reports	Dashboard

---

Simple Example

Task	Baseline Cost	Actual Cost	Variance
Foundation	$5,000	$6,500	+$1,500

Meaning:

• Foundation overspent by $1,500

Possible reasons:

• Rework

• Delay

• Material waste

• Extra labor

---

Recommended Weekly SOP

Monday–Saturday

• Daily update from site

Saturday Evening

• Update Microsoft Project

Sunday

• Weekly review meeting

• Analyze:

  • Delay

  • Cost impact

  • Recovery action

This is how professional contractors control:

• Time

• Cost

• Productivity

• Profitability

✎ Edit Post ↑ Top Up