11 - Dashboard (MentWay)

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 4

Project Dashboard

Contractual Data Project Progress Data Planned this period


Actual this period
Project Name Planned Cumm
Project Code
Cut off Date 28-Jan-2016 Expected Time at Completion (Days) #REF! EV vs. PV vs. AC Duration Actual Cumm Payment
The Contract Type Expected Completion Date 9-Mar-2016
Expected Cost at Completion (EGP) #REF!
4,500,000

The Employer Expected Milestone Date - 4,000,000


3,957,445 Contract Amount 8,265,340.43 EGP 8,265,340.43
The Employer Current Delay 9 IPC 2,803,040.85 EGP 2,803,040.85 2076559.93 904456.687764
3,263,156
EGP 5,462,299.58
3,500,000 33

The Consultant Requested EOT 0 3528 Remaining Payment 5,462,299.58 EGP 5,462,299.58
Project Progress Status
The Contractor Granted EOT 0
3,000,000

The Contract Amount (EGP) EGP 8,860,290.43 Elapsed Days 82


EGP 8,265,340.43
2,500,000

2,054,656
Variation Orders Amount (EGP 594,950.00) Remaining Days 33 EGP 726,480.92
Actual This Period % 7.00% 2,000,000

Revised Contract Amount EGP 8,265,340.43 Current Week 12 1,500,000

Advance Payment 0% Remaining Weeks 5 1,000,000


Retention (1) 5% Current Month 3 82 277994.384
15.00% Earned Value 3,263,156
EGP 2,803,040.85

Retention (2) 5% Remaining Months 1.1 Planned This Period % 500,000

Delay Damage (Per Week) - Planned This Period % 15.00% -


Planned Value 3,957,445 694,289 #REF! 460,115.55

Commencement Date 7-Nov-2015 Actual This Period % 7.00% Contract Amount IPC Remaining Payment
Earned Value Planned
Value
Actual Cost
Elapsed Days Remaining Days Actual Cost 2,054,656 363181.802
The Contract Duration (days) 115 Planned Cumulative % 57.00%
Time of Completion Date 1-Mar-2016 Actual Cumulative % 47.00%
Actual Cumulative % 47.00%
Row 22 Row 23 Row 24 Row 25 Row 26 Row 22 Row 23 Row 24 Row 25 Row 26 29250000
Milestone Date - Variance Progress % -10.00% 1 1 Planned last period 6.38%
Revised Time of Completion - Period to Receive Payment 30 Days 0.9 0.9

0.8
Actual last period 6.44%
57.00%
0.8

Planned Cumulative % 0.7


0.7

0.6
0.6
694,289
0.5

Area of Concern (Main Issue Register) Manpower Average per day for this Period 0.5

0.4
0.4

0.3
0.3

100%
0.2

0 0 0 0 0
Actual This Period %
0.2 0.1
Item Description Item Number 7.00%
0.1
0 0 0 0 0

Submitted Approved Rejected On Going Performance


Planned This Period %
0

Carpenter 11 0.00% 20.00% 40.00% 60.00% 80.00% 100.00% 120.00% Total Submitted Remaining Progress % % 15.00%
1
Steel Fixer 12 Actual Cumulative % 47.00% 1076734.1521
Column V Column X Column W Column Y
Actual Cost v.s Certified Payment (Cash Flow) Planned Cumulative %
EGP 9,000,000.00

Masonry 12 57.00%
2 14.00% 120.00%
EGP 8,000,000.00
Plaster 11 100%
12.00% 100.00%
Painting 10
EGP 7,000,000.00
694,289
3 10.00%
Tiles 0 80.00%
EGP 6,000,000.00

8.00%
Curtain Walls 26 EGP 5,000,000.00
460,115.55
4 60.00%
Gypsum Works 0 6.00% EGP 4,000,000.00

40.00% The Current Net Profit= 299,897.9 EGP


Steel Sructure 10 4.00% EGP 3,000,000.00
455970.151763999 693406.59612
5
MEP 43 2.00% 20.00% EGP 2,000,000.00 Actual Cost

Labors 25 0.00% 0.00%


EGP 1,000,000.00

6 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Total 160 EGP 0.00 0 EGP 0.00
0 2 4 6 8 10 12
1 EGP 0.00
1 EGP 0.00 EGP 46,655.00 0
Quality Performance Safety Performance Activity Name Duration Performance % Complete Schedule % Complete Start Finish 2 EGP 0.00 EGP 104,701.50 1
2 EGP 1,640,000.00 EGP 660,074.20 2
xxx #VALUE! 47% 57.05% 7-Nov-15 A 9-Mar-16 3 EGP 1,640,000.00 EGP 2,054,656.36 3
xxxx 13 100% 100% 07-Nov-15 A 06-Jan-16 A 3 EGP 2,354,554.31 4
1-Mobilization 23 100% 100% 14-Nov-15 A 28-Dec-15 A 4 EGP 2,354,554.31 5
2-General & Preliminaries 4 100% 100% 14-Nov-15 A 19-Nov-15 A EGP 299,897.95 4 6
3-Procurement 5 100% 100% 24-Nov-15 A 28-Dec-15 A 299897.954 5 7
4-Main Building 64 52.08% 65.66% 23-Nov-15 A 7-Mar-16 5 8
4a- Second Basement 29 100% 100% 23-Nov-15 A 14-Jan-16 A 195000000 6
4b- First Basement 32 17.38% 30.76% 11-Jan-16 A 3-Mar-16 6
4c- Ground Floor 30 22% 59.89% 23-Jan-16 A 7-Mar-16 7
4d- First Floor 55 60.78% 75.93% 08-Dec-15 A 3-Mar-16 7
4e- Second Floor 8 100% 100% 08-Dec-15 A 22-Dec-15 A 8
4f- Third Floor 32 31.04% 65.71% 07-Jan-16 A 25-Feb-16 8
4g- Fourth Floor 39 54.48% 59.89% 16-Jan-16 A 3-Mar-16 9
4h- Fifth Floor 47 57.99% 60.60% 24-Dec-15 A 3-Mar-16 9
4i- Sixth Floor 8 100% 100% 24-Dec-15 A 07-Jan-16 A 10 EGP 8,000,000.00
4j- Roof Floor 30 24.06% 27.09% 16-Jan-16 A 23-Feb-16
4k- Upper Floor 30 54% 60% 21-Jan-16 A 3-Mar-16
5- Façade Works 34 18.88% 33.52% 09-Jan-16 A 28-Feb-16
5a- Northern facade 24 69.13% 69.13% 09-Jan-16 A 14-Feb-16
5b- Southern facade 23 5.95% 12% 16-Jan-16 A 25-Feb-16
5a- Eastern facade 20 0% 56% 30-Jan-16 28-Feb-16
5a- Western facade 19 0% 0% 8-Feb-16 6-Mar-16
6- External Works 28 1% 6.92% 24-Jan-16 A 1-Mar-16
7- Testing & Commissioning 22 0% 29% 28-Jan-16 27-Feb-16

xxxxx xxxxx xxxxx xxxxxx xxxxxx xxxxx Masonry Works


0
0
32
Total Submitted Submitted

0
0
32
Submitted Replied Approved

RFI

0
0
0
Remaining On Going Rejected
Shop Drawing

0
Progress % On Going

###
27
Submitted

27
Approved

Engineering Progress %
IR

0
Rejected
0
On Going

0
9

Submitted Submitted

0
9

Approved Approved
MIR

0
0

Rejected Rejected
0
0

On Going On Going

Performance %
Engineering Performance

#DIV/0!
Planned Progress Actual Progress
Month
This Period Cumulative This Period
1 7-Nov-15 0.61% 0.61% 0.61%
2 14-Nov-15 1.36% 1.97% 1.36%
3 21-Nov-15 4.86% 6.83% 4.86%
4 28-Nov-15 4.39% 11.21% 4.39%
5 5-Dec-15 4.91% 16.12% 4.91%
6 12-Dec-15 2.24% 18.36% 2.24%
7 19-Dec-15 6.18% 24.54% 6.18%
8 26-Dec-15 3.68% 28.23% 3.68%
9 2-Jan-16 7.91% 36.14% 7.91%
10 9-Jan-16 5.89% 42.03% 2.00%
11 16-Jan-16 8.38% 50.40% 3.00%
12 23-Jan-16 7.99% 58.39% 4.00%
13 30-Jan-16 12.69% 71.07%
14 6-Feb-16 7.57% 78.64%
15 13-Feb-16 11.20% 89.84%
ormance 16 20-Feb-16 10.03% 99.88%
17 27-Feb-16 0.12% 100.00%
Total 100.00% 100.00%
Actual Progress Dry Cost
Cumulative This Period Cumulative
0.61% 0.07% 0.07% 50400 4666.67
1.97% 0.65% 0.72% 112000 41988.33
6.83% 1.44% 2.17% 401037.5 92782.5
11.22% 5.67% 7.84% 362106.9 365264
16.13% 2.08% 9.92% 405317.6 134201.5
18.36% 4.99% 14.91% 184646 321171.2
24.55% 2.71% 17.62% 510489.47 174316.8
28.23% 4.07% 21.69% 304059.02 261847.48
38.00% 5.23% 26.91% 652940.34 336513.33
40.00% 7.17% 34.09% 486161.5 461746.19
43.00% 6.17% 40.26% 691479.75 397104.34
47.00% 8.38% 48.64% 659199 539594.44
9.49% 58.13% 1047172 611241.22
13.45% 71.58% 624616.73 865890.8
11.76% 83.35% 924916.61 757365.03
8.99% 92.34% 828347.5 578980.64
7.66% 100.00% 9950.5 493250.5
100.00% 8254840 6437925

You might also like