Elapsed Duration Remaining Duration Forecast Add.

Duration
PROJECT DASHBOARD
1409

REPORT DATE 5-Jan-25 PROJECT NAME - Construction of Miscellanious Structures at upcoming Airport : Location Navi Mumbai

PROJECT DATES CONTRACT VALUES INVOICING INFORMATION HEALTH & SAFETY STATUS
Original Contract Revised/Remeasured Potential/Pending
Project Start Contract Finish Forecast Finish Delay (Days) Approved VO(S) Gross Billed Net Billed W/O VAT Net Collected Net Due
Value Contract Value VO(s) FATALITIES

SIGNIFICANT
26-Feb-21 31-Dec-22 30-Jun-23 -181
40,000,000 120,000,000 100,000,000 80,000,000 20,000,000 MAJOR
100,000,000 140,000,000 25,000,000
40% MINOR

NEAR MISS
SCHEDULE PERFORMANCE INTERNAL COST PERFORMANCE 0.89
CONTRACT PERFORMANCE

Planned Value 140,000,000 100.00% Schedule Performance Index (SPI) BCWP 17,160,000 15.32% Earned Value 134,288,000 2.92% TOTAL PROJECT MANHOURS 2,474,298
1.00 Cost Performance Index (CPI) Billing Performance Index (BPI)
0.75 1.25 LOSS OF MANHOURS 49,486
0.50 1.50 0.75 1.00 1.25 0.75 1.00 1.25

Earned Value 134,288,000 95.92%

0.25 1.75
AC 21,360,000 19.07%
0.50 1.50
Actual Billed 120,000,000 85.71%
0.50 1.50 PROJECT QUALITY STATUS
0.25 1.75 0.25 1.75
2.0
0.96 2.0 2.0
Variance 5,712,000 -4.08% Variance 4,200,000 3.75% 0.80 Variance (14,288,000) 82.79% 0.89
<1 =.90-.99 >1 <1 =.90-.99 >1 <1 =.90-.99 >1

ENGINEERING PROGRESS PROJECT PROGRESS STATUS

Drawings
Material Sub- MES
Shop Drawings
mittal 80.00%
90.00
800

As-Built Drawings
%
900

Total
PROGRESS S-CURVE
600

2000
700

100.00%
100.00% 95.73% 98.29% 100.00%
92.31%
88.03%
1000 1300 90.00% 82.91% 90.00%
76.92% 80.00%
80.00% 70.09% 81.61% 82.00%
500 78.06% 80.30%
70.00% 62.39% 70.80%
74.89% 70.00% PHOTO-1 PROJECT MANPOWER HISTOGRAM
60.00% 53.85% 65.78% 60.00%
1000 800 59.83%
50.00% 44.44% 52.96% 50.00%
40.00% 35.90% 45.17% 40.00% 450 900000
Planned Actual Planned Actual Planned Actual 30.00%
28.21% 36.44% 30.00% Budgeted MH
400 800000
PROCUREMENT PROGRESS 20.00% 15.38%
21.37%
28.65%
20.00% 350Planned MH 700000
PO(s) & Delivery Status 10.26% 21.78%
300 Actual MH 750880 600000
10.00%2.56% 5.98% 15.83% 10.00%
Long Lead Short Lead Total 10.81% 250 500000
0.00%1.31% 6.72% 0.00%
3.56% 200 400000
160 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 150 300000
130 130 100 200000
Progress - Cumulative-Plan Progress - Cumulative-Actual 50 100000
90.00%
81.00 0 0
% 120 23 23 r-23 r-23 -23 -23 l-23 -23 -23 t-23 -23 -23 -24 -24 r-24 r-24 -24 -24
n- b- y n Ju g ep v c n b y n
100 100 70 Ja Fe Ma Ap Ma Ju Au S Oc No De Ja Fe Ma Ap Ma Ju
CASH-IN VS CASH-OUT Plan - Monthly Manpower Actual - Monthly Manpower Plan - MH Cum.

TCC Manpower
Actual - MH Cum.

50 Total Manpower
2 15 Total Direct & Indi- Indirect
40 30 30 Subcon rect
20 Indirect
2
50
PO -PL PO-ACT DEL.-PL DEL.-AC 2 153 102
CONSTRUCTION PROGRESS Structural MEP Architecture 1 10
Works /Finishes 1

85%
1 PHOTO-2
90% 89% 1
1 5

80.00% 68%
250
60.00 65% 300 351
Direct
% TC Direct
71% Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 C

Cash-In - Monthly-Plan Cash-In - Monthly-Actual Cash-Out-Monthly-Plan Cash-Out-Monthly-Actual Planned Actual Variance

Cash-in - Cumulative-Plan Cash-in - Cumulative-Plan Cash-Out-Cumulative-Plan Cash-Out-Cumulative-Actual
Thabat
Supplier
No. ISSUES/CONCERNS BUDGET VS COST PERFORMANCE Subcon
Millions
PROJECT COST PERFORMANCE Total

150 Budget at completion 112.00 M PROJECT EQUIPMENT

BCWS
BCWP
119 120 121 121 122 122 36 600
115 117 118 35 34 34
ACWP 110 122.36 M 32 32
105 Estimate at completion 30 31 30 500
99 112 112 29 29
100 FCST 92 107 109 110 111 30 28 27 27 28
99 103
26 25 25 26
84 93 25 24 23 23 24 400
73 87 22 21 21 22
80 Estimate to Go 101.00 M 20
20 19 19 20
18
63 17 17 300
71 15 15
51 62 15 13
50 42 52 200
Cost Variance at
No. RISKS/ACTIONS 28
35
44
Completion
-10.36 M 10
21 32 38 100
21
26 5
17
13 20 17
10 16
7 12 13
2 5
5
4 8
6 8 11 Cost Variance at to-Date -4.20 M 0 0
2
22 -22 r-22 r-22 -22 -22 l-22 -22 -22 t-22 -22 -22 -23 -23 r-23 r-23 -23 -23 l-23 -23 -23 t-23 -23 -23 -24 -24 r-24
n- b y un Ju g p v c a n eb ay Jun Ju Aug S ep Oc Nov Dec Jan F eb
Ja F e Ma Ap Ma J Au S e Oc No De J F M
a Ap
M M
a
Plan - Eq. - Monthly Actual- Eq. - Monthly Plan - Eq. - Cum. Actual - Eq. - Cum.
Millions
PROJECT COST PERFORMANCE
150 BCWS
BCWP
119 120 121 121 122 122 36 600
115 117 118 35 34 34
ACWP 110 32 31 32
105 30 30 500
99 112 112 29 29
100 FCST 92 107 109 110 111 30 28 27 27 28
99 103
26 25 25 26
84 93 25 24 23 23 24 400
73 87 22 21 21 22
80 20 19 19 20
63 20 17 17 18 300
71 15 15
51 62 15 13
50 42 52 200
35 10
28 44
21 32 38 100
21
26 5
17
13 20
7 10 16
12 13 17 0 0
2 5
5 8
6 8 11 Cost Variance at to-Date -4.20 M
2 4
22 -22 r-22 r-22 -22 -22 l-22 -22 -22 t-22 -22 -22 -23 -23 r-23 r-23 -23 -23 l-23 -23 -23 t-23 -23 -23 -24 -24 r-24
n- b y un Ju g p v c a n eb ay Jun Ju Aug S ep Oc Nov Dec Jan F eb
Ja F e Ma Ap Ma J Au S e Oc No De J F M
a Ap
M M
a
Plan - Eq. - Monthly Actual- Eq. - Monthly Plan - Eq. - Cum. Actual - Eq. - Cum.
 CASH-IN VS CASH-OUT Jan-23 Feb-23 Mar-23
Cash-In - Monthly-Plan 1
Cash-in - Cumulative-Plan 1 1
Cash-In - Monthly-Actual
Cash-in - Cumulative-Plan 1 1
Cash-Out-Monthly-Plan
Cash-Out-Cumulative-Plan 1 1
Cash-Out-Monthly-Actual
Cash-Out-Cumulative-Actual 1
Actual Cost-Monthly
Actual Cost-Cumulative 1

PROGRESS Jan-23 Feb-23 Mar-23

Progress - Monthly-Plan 2.56% 3.42% 4.27%
Progress - Cumulative-Plan 2.56% 5.98% 10.26%
Progress - Monthly-Actual 1.31% 2.24% 3.17%
Progress - Cumulative-Actual 1.31% 3.56% 6.72%

MANPOWER Jan-23 Feb-23 Mar-23

Plan - Monthly Manpower 50 100 150
Plan - MH Cum. 10400 31200 62400
Actual - Monthly Manpower 25 75 125
Actual - MH Cum. 5200 20800 46800
Planned MH-Cumulative
Actual MH Culative

EQUIPMENT Jan-23 Feb-23 Mar-23

Plan - Eq. - Monthly 20 22 24
Plan - Eq. - Cum. 20 42 66
Actual- Eq. - Monthly 15 17 19
Actual - Eq. - Cum. 15 32 51

COST Jan-22 Feb-22 Mar-22

BCWS-Budgeted Cost of Work Schedule 2,000,000 3,000,000 3,000,000
BCWP-Budgeted Cost of Works performed 1,280,000 1,920,000 1,920,000
ACWP-Actual Cost of Works Performed 1,600,000 2,400,000 2,400,000
FCST-Forecast of remaining work
BAC-Budget at completion
EAC-Estimate at completion
FTG-Estimate to Go

COST Cum. Jan-22 Feb-22 Mar-22

BCWS 2 5 8
BCWP 2 4 6
ACWP 2 5 7
FCST

Budget at completion 112.0M

Estimate at completion 122.4M
Estimate to Go 101.0M
Cost Variance at Completion -10.4M
Cost Variance at to-Date -4.2M
Cost Performance Index 0.8

BCWS-Budgeted Cost of Work Schedule

BCWP-Budgeted Cost of Works performed
ACWP-Actual Cost of Works Performed
FCST-Forecast of remaining work

1
Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23
1 1 1 1 1 1
2 3 3 4 5 6
1 1 1 1 1 1
2 2 3 4 5 6
1 1 1 1 1 1
2 2 3 4 5 6
1 1 1 1
1 1 2 3 4 4
1 1 1 1
1 1 2 3 3 4

Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23

5.13% 5.98% 6.84% 7.69% 8.55% 9.40%
15.38% 21.37% 28.21% 35.90% 44.44% 53.85%
4.09% 5.02% 5.94% 6.87% 7.80% 8.72%
10.81% 15.83% 21.78% 28.65% 36.44% 45.17%

Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23

200 250 300 350 400 410
104000 156000 218400 291200 374400 459680
175 225 275 325 375 385
83200 130000 187200 254800 332800 412880

Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23

26 28 30 32 34 36
92 120 150 182 216 252
21 23 25 27 29 31
72 95 120 147 176 207

Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22

4,000,000 4,000,000 4,000,000 6,000,000 6,000,000 6,000,000
2,560,000 2,560,000 2,560,000 3,840,000
3,200,000 3,200,000 3,200,000 4,800,000
6,900,000 6,900,000
Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22
12 16 20 26 32 38
8 11 13 17
10 13 17 21
21 28 35
Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24
1 1 1 1 1 1
7 8 9 10 10 11
1 1 1 1 1
7 8 8 9 10 10
1 1 1 1 1
7 8 9 10 10 11
1 1 1
5 6 6 7 7 8
1 1 1
5 6 6 7 7 7

Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24

8.55% 7.69% 6.84% 5.98% 5.13% 4.27%
62.39% 70.09% 76.92% 82.91% 88.03% 92.31%
7.80% 6.87% 5.94% 5.02% 4.09% 3.17%
52.96% 59.83% 65.78% 70.80% 74.89% 78.06%

Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24

400 350 300 250 200 150
542880 615680 678080 730080 771680 802880
375 325 275 225 175 125
490880 558480 615680 662480 698880 724880

Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24

34 32 30 28 26 24
286 318 348 376 402 426
29 27 25 23 21 19
236 263 288 311 332 351

Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23

6,000,000 8,000,000 10,000,000 9,000,000 9,000,000 7,000,000

6,900,000 9,200,000 11,500,000 10,400,000 10,400,000 8,100,000

Oct-22 Nov-22 Dec-22 Jan-23 Feb-23 Mar-23
44 52 62 71 80 87

42 51 63 73 84 92
Apr-24 May-24 Jun-24

11 12 12

10 11 11

11 11 12

8 8 8

8 8 8

Apr-24 May-24 Jun-24

3.42% 2.56% 1.71%
95.73% 98.29% 100.00%
2.24% 1.31% 0.39%
80.30% 81.61% 82.00%

Apr-24 May-24 Jun-24

100 50 50
823680 834080 844480
75 25 25
740480 745680 750880

Apr-24 May-24 Jun-24

22 20 18
448 468 486
17 15 13
368 383 396

Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23

6,000,000 6,000,000 4,000,000 4,000,000 2,000,000 1,000,000 1,000,000

6,900,000 6,900,000 4,600,000 4,600,000 2,300,000 1,200,000 1,200,000

Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23
93 99 103 107 109 110 111

99 105 110 115 117 118 119

Nov-23 Dec-23 Jan-24 Feb-24 Mar-24
500,000 500,000 112,000,000
16,640,000
20,800,000
600,000 600,000 600,000 600,000 600,000 99,200,000
Nov-23 Dec-23 Jan-24 Feb-24 Mar-24
112 112

120 121 121 122 122

 ENGINEERING
Trade Planned Actual Variance Actual %
Shop Drawings 1000 800 -200 80%
Material Submittals 900 700 -200 78%
Method Statements 800 600 -200 75%
Total 2700 2100 78%

PROCUREMENT
PO(s) Delivery
Trade Total
PO -PL PO-ACT DEL.-PL
Civil 50 40 30 30
Arch. 30 20 15 15
Mechanical 70 50 45 45
Electrical 60 50 40 40
Total 210 160 130 130

CONSTRUCTION
Area Planned % Actual % Variance % SPI
Structural
Works 90% 65% -25% 0.72
MEP
Architecture 85% 71% -14% 0.84
/Finishes 89% 68% -21% 0.76
Area 4 81% 70% -11% 0.86

EPC Progress
L-01 PROGRESS Planned Rem. Actua Rem.
ENGINERRING 80.00% 20.0% 90.00% 10.00%
PROCURMENT 90.00% 10.0% 81.00% 19.00%
CONSTRUCTION 80.00% 20.0% 60.00% 40.00%

Direct - Thabat 250

Indirect - Thabat 50
Total Thabat 300
Direct - Supplier 50
Direct - Subcon 51
Indirect - Others 52
Total Direct 351
Total Indirect 102
Grand Total 453
TCC Total 300
Subcon/Rental Total 153
Total Project Manpower 453

Total Closed Open Pending

RFI's
 RFI's
800 700 100
Total Approved Rejected Pending
WIR(s)
900 800 35 80
Total Closed Open Pending
NCR(S)
20 16 4

Elapsed Duration 1409

Remaining Duration 0
Forecast Add. Duration 181

Total Project Budget 130,000,000

 ENGINEERING
Trade Planned Actual Variance Actual %
Shop Drawings 1000 800 -200 80%
As-Built Drawings 1000 500 -500 50%
Total 2000 1300 -700 65%

PROCUREMENT
Delivery PO(s) Delivery
Trade Total
DEL.-AC PO -PL PO-ACT DEL.-PL DEL.-AC
20 Long Lead 70 40 30 30 20
10 Short Lead 140 120 100 100 50
20 Total 210 160 130 130 70
20
70

Variance SPI
10.00% 1.13
-9.00% 0.90
-20.00% 0.75
Performance Label Value Labels Values Labels Values
Poor 45 0.25 0.25 Pointer 0.96
Average 5 0.50 0.25 Thickness 0.015
Good 50 0.75 0.25 Rest 3.0258
Total 100 1.00 0.25
1.25 0.25
1.50 0.25
1.75 0.25
2.0 0.25
Total 2

Schedule Performance Index (SPI)

0,75 1.00 1,25

0.50
1.50
0,25
1,75

2.0
0,96

Billing Performance Index (BPI)

0,75 1.00 1,25

0.50
1.50
0,25
1,75
2.0
0,89

Cost Performance Index (CPI)

0,75 1.001,25
0.50 1.50
0,25
1,75
2.0
0,80
 2.0
0,80

Performance Label Value Labels Values Labels Values

Poor 45 0.25 0.25 Pointer 0.89
Average 5 0.50 0.25 Thickness 0.015
Good 50 0.75 0.25 Rest 3.091398
Total 100 1.00 0.25
1.25 0.25
1.50 0.25
1.75 0.25
2.0 0.25
Total 2
Performance Label Value Labels Values Labels Values
Poor 45 0.25 0.25 Pointer 0.80
Average 5 0.50 0.25 Thickness 0.015
Good 50 0.75 0.25 Rest 3.181629
Total 100 1.00 0.25
1.25 0.25
1.50 0.25
1.75 0.25
2.0 0.25
Total 2
 SAFETY DATA
Fatalities 0
Significant 0
Major 0
Minor 1
Near Miss 2
 Cost Variance at Com
Budget at completion Estimate at completion Estimate to Go
= BCWP -ACWP @ Co

BAC 112.0M EAC 122.4M ETG 101.0M -10.4M

 Cost Variance at Completion Cost Variance at to-Date
Cost Performance Index
= BCWP -ACWP @ Completion = BCWP -ACWP @ To - Date

-10.4M -4.2M CPI 0.8

key legend Cost Types Description How to Calculate
also called the Planned Value (PV), is the sum of the budget for all
work scheduled to be accomplished with a given time period. It also
BCWS Budgeted Cost of Work Schedule includes the cost of previous work completed and can address a BCWS = % Complete (Planned) x Project Budget.
specific period of performance or a date in time

is the dollarized (budgeted) value of all work actually accomplished in

a given period of time. The variable is also called Earned Value (EV)
BCWP Budgeted Cost of Works performed and symbolizes the completion of work. BCWP is not 'earned' until BCWP = % Complete (Actual) x Project Budget.
the work is completed.

Is the cost actually incurred and recorded in accomplishing the work

ACWP = ACWP is calculated depends on the assigned
performed within a given accounting period and is accumulated
resources’ Standard Rate, Overtime Rate, Per Use
ACWP Actual Cost of Works Performed reported over time. The ACWP is reported by the contractor's
Cost, and Cost accrual settings in the Resource
accounting system in accordance with generally accepted accounting
Information
procedures.

Is the process of making predictions, guesses, or assumptions of the

possible outcomes of a project. These project forecasts are made
FCST Forecast of remaining work through the analysis of historical project data as well as predicted FCST= Forecast of total cost - Actual Cost.
future performances.

BAC = sum of all budgets established for the work to

BAC Budget at completion IS the sum of all budgets established for the work to be performed
be performed.
EAC = sum of the amount invested at the time of
Is the current expectation of the total costs of a project once
EAC Estimate at completion measurement and the costs necessary to complete
completed.
the work
ETG Estimate to Go Remaning Cost to be spent to complete the work ETG = EAC - ACWP
is a method for calculating the cost efficiency and financial
CPI The Cost Performance Index CPI = earned value (BCWP) / actual cost (ACWP)
effectiveness