Scribd
Upload
33 views14 pages

Pot Cost Map

The document outlines the procurement and construction activities for potable water systems across multiple roads, including Roads 11, 12, 13, 15, and 16. Each road has specific tasks with associated activity IDs, start dates, and durations, detailing the installation of pipes, valves, and other components. The overall timeline for the project spans from March 2025 to September 2025.

Uploaded by

Erickson Malicsi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
33 views14 pages

Pot Cost Map

The document outlines the procurement and construction activities for potable water systems across multiple roads, including Roads 11, 12, 13, 15, and 16. Each road has specific tasks with associated activity IDs, start dates, and durations, detailing the installation of pipes, valves, and other components. The overall timeline for the project spans from March 2025 to September 2025.

Uploaded by

Erickson Malicsi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 14

Activity ID

POTABLE WATER
ROAD 11
PROCUREMENT
A8310
CONSTRUCTION
A5000
A5010
A5020
A13760
A13770
A5030
A5040
A13780
A13790
A5050
A6830
A6840
A6850
A13800
A13810
A6860
A6870
A13820
A13830
A6880
ROAD 12
PROCUREMENT
A8600
CONSTRUCTION
A15690
A4270
A4280
A4290
A13840
A13850
A4300
A4310
A13860
A13870
A4320
ROAD 13
PROCUREMENT
A8830
CONSTRUCTION
A3570
A3580
A3590
A13880
A13890
A3600
A3610
A13900
A13910
A3620
ROAD 15
PROCUREMENT
A9230
CONSTRUCTION
A2130
A2150
A2160
A13920
A13930
A2180
A2190
A13940
A13950
A2200
ROAD 16
PROCUREMENT
A9520
CONSTRUCTION
A5650
A5660
A5670
A13960
A13970
A5680
A5690
A13980
A13990
A5700
Activity Name Start
20-Mar-25
20-Mar-25
20-Mar-25
Procure & Deliver of Pipes - R11-PWS 20-Mar-25
14-Apr-25
Backfill to invert level - R11 - PWS 14-Apr-25
Bedding under pipe - R11 - PWS 29-Apr-25
Install pipes - R11 - PWS 1-May-25
Install valves - R11 - PWS 1-May-25
Valve chamber & chamber finishing - R11 - PWS 1-May-25
Hydrostatic test - R11 - PWS 4-May-25
Valve chamber cover installation - R11 - PWS 7-May-25
Water meter installation - R11 - PWS 7-May-25
House connection and surface box installation - R11 - PWS 7-May-25
Backfilling until another utility - R11 - PWS 10-May-25
Backfill to invert level - R11 - PWS (RW) 10-Jul-25
Bedding under pipe - R11 - PWS (RW) 17-Jul-25
Install pipes - R11 - PWS (RW) 19-Jul-25
Install valves - R11 - PWS (RW) 19-Jul-25
Valve chamber & chamber finishing - R11 - PWS (RW) 19-Jul-25
Hydrostatic test - R11 - PWS (RW) 20-Jul-25
Valve chamber cover installation - R11 - PWS (RW) 22-Jul-25
Water meter installation - R11 - PWS (RW) 22-Jul-25
House connection and surface box installation - R11 - PWS (RW) 22-Jul-25
Backfilling until another utility - R11 - PWS (RW) 23-Jul-25
20-Jul-25
20-Jul-25
Procure & Deliver of Pipes - R12-PWS 20-Jul-25
12-Aug-25
Potable Work System - R12 - PW (RW) 12-Aug-25
Backfill to invert level - R12 - PW 2-Sep-25
Bedding under pipe - R12 - PW 18-Sep-25
Install pipes - R12 - PW 20-Sep-25
Install valves - R12 - PW 20-Sep-25
Valve chamber & chamber finishing - R12 - PW 20-Sep-25
Hydrostatic test - R12 - PW 21-Sep-25
Valve chamber cover installation - R12 - PW 24-Sep-25
Water meter installation - R12 - PW 24-Sep-25
House connection and surface box installation - R12 - PW 24-Sep-25
Backfilling until another utility - R12 - PW 25-Sep-25
6-Jul-25
6-Jul-25
Procure & Deliver of Pipes - R13-PWS 6-Jul-25
12-Jul-25
Backfill to invert level - R13 - PW 12-Jul-25
Bedding under pipe - R13 - PW 16-Aug-25
Install pipes - R13 - PW 17-Aug-25
Install valves - R13 - PW 20-Aug-25
Valve chamber & chamber finishing - R13 - PW 20-Aug-25
Hydrostatic test - R13 - PW 24-Aug-25
Valve chamber cover installation - R13 - PW 28-Aug-25
Water meter installation - R13 - PW 28-Aug-25
House connection and surface box installation - R13 - PW 28-Aug-25
Backfilling until another utility - R13 - PW 31-Aug-25
23-Apr-25
23-Apr-25
Procure & Deliver of Pipes - R15-PWS 23-Apr-25
27-May-25
Backfill to invert level - R15 - PWS 27-May-25
Bedding under pipe - R15 - PWS 15-Jun-25
Install pipes - R15 - PWS 17-Jun-25
Install valves - R15 - PWS 17-Jun-25
Valve chamber & chamber finishing - R15 - PWS 17-Jun-25
Hydrostatic test - R15 - PWS 19-Jun-25
Valve chamber cover installation - R15 - PWS 23-Jun-25
Water meter installation - R15 - PWS 23-Jun-25
House connection and surface box installation - R15 - PWS 23-Jun-25
Backfilling until another utility - R15 - PWS 25-Jun-25
27-Apr-25
27-Apr-25
Procure & Deliver of Pipes - R16-PWS 27-Apr-25
15-May-25
Backfill to invert level - R16 - PWS 15-May-25
Bedding under pipe - R16 - PWS 25-Jun-25
Install pipes - R16 - PWS 29-Jun-25
Install valves - R16 - PWS 29-Jun-25
Valve chamber & chamber finishing - R16 - PWS 29-Jun-25
Hydrostatic test - R16 - PWS 1-Jul-25
Valve chamber cover installation - R16 - PWS 3-Jul-25
Water meter installation - R16 - PWS 3-Jul-25
House connection and surface box installation - R16 - PWS 3-Jul-25
Backfilling until another utility - R16 - PWS 6-Jul-25
Original Duration Finish Total Float for contact and suggestions raja_qasir2001@yahoo.com
156 27-Sep-25 5
101 23-Jul-25 20
30 28-Apr-25 20
30 28-Apr-25 20
84 23-Jul-25 20
13 28-Apr-25 5
2 30-Apr-25 18
2 3-May-25 18
2 3-May-25 18
2 3-May-25 18
3 6-May-25 18
2 8-May-25 18
2 8-May-25 18
2 8-May-25 18
4 13-May-25 18
6 16-Jul-25 17
1 17-Jul-25 20
1 19-Jul-25 20
1 19-Jul-25 20
1 19-Jul-25 20
2 21-Jul-25 20
1 22-Jul-25 20
1 22-Jul-25 20
1 22-Jul-25 20
1 23-Jul-25 20
59 27-Sep-25 5
30 23-Aug-25 24
30 23-Aug-25 24
39 27-Sep-25 5
9 21-Aug-25 35
14 17-Sep-25 0
1 18-Sep-25 1
1 20-Sep-25 1
1 20-Sep-25 1
1 20-Sep-25 1
2 22-Sep-25 1
1 24-Sep-25 1
1 24-Sep-25 1
1 24-Sep-25 1
2 27-Sep-25 1
52 3-Sep-25 14
30 9-Aug-25 23
30 9-Aug-25 23
47 3-Sep-25 14
30 14-Aug-25 14
4 19-Aug-25 14
3 19-Aug-25 17
3 23-Aug-25 14
3 23-Aug-25 14
4 27-Aug-25 14
2 30-Aug-25 14
2 30-Aug-25 14
2 30-Aug-25 14
4 3-Sep-25 14
55 29-Jun-25 6
30 27-May-25 20
30 27-May-25 20
26 29-Jun-25 6
13 14-Jun-25 6
2 16-Jun-25 6
2 18-Jun-25 6
2 18-Jun-25 6
2 18-Jun-25 6
3 22-Jun-25 6
2 24-Jun-25 6
2 24-Jun-25 6
2 24-Jun-25 6
4 29-Jun-25 6
59 7-Jul-25 21
30 31-May-25 42
30 31-May-25 42
43 7-Jul-25 21
32 24-Jun-25 21
3 28-Jun-25 21
2 30-Jun-25 21
2 30-Jun-25 21
2 30-Jun-25 21
2 2-Jul-25 21
2 5-Jul-25 21
2 5-Jul-25 21
2 5-Jul-25 21
2 7-Jul-25 21
Activity ID
POTABLE WATER
ROAD 11
PROCUREMENT
A8310
CONSTRUCTION
A5000
A5010
A5020
A13760
A13770
A5030
A5040
A13780
A13790
A5050
A6830
A6840
A6850
A13800
A13810
A6860
A6870
A13820
A13830
A6880
ROAD 12
PROCUREMENT
A8600
CONSTRUCTION
A15690
A4270
A4280
A4290
A13840
A13850
A4300
A4310
A13860
A13870
A4320
ROAD 13
PROCUREMENT
A8830
CONSTRUCTION
A3570
A3580
A3590
A13880
A13890
A3600
A3610
A13900
A13910
A3620
ROAD 15
PROCUREMENT
A9230
CONSTRUCTION
A2130
A2150
A2160
A13920
A13930
A2180
A2190
A13940
A13950
A2200
ROAD 16
PROCUREMENT
A9520
CONSTRUCTION
A5650
A5660
A5670
A13960
A13970
A5680
A5690
A13980
A13990
A5700
Activity Name

Procure & Deliver of Pipes - R11-PWS

Backfill to invert level - R11 - PWS


Bedding under pipe - R11 - PWS
Install pipes - R11 - PWS
Install valves - R11 - PWS
Valve chamber & chamber finishing - R11 - PWS
Hydrostatic test - R11 - PWS
Valve chamber cover installation - R11 - PWS
Water meter installation - R11 - PWS
House connection and surface box installation - R11 - PWS
Backfilling until another utility - R11 - PWS
Backfill to invert level - R11 - PWS (RW)
Bedding under pipe - R11 - PWS (RW)
Install pipes - R11 - PWS (RW)
Install valves - R11 - PWS (RW)
Valve chamber & chamber finishing - R11 - PWS (RW)
Hydrostatic test - R11 - PWS (RW)
Valve chamber cover installation - R11 - PWS (RW)
Water meter installation - R11 - PWS (RW)
House connection and surface box installation - R11 - PWS (RW)
Backfilling until another utility - R11 - PWS (RW)

Procure & Deliver of Pipes - R12-PWS

Potable Work System - R12 - PW (RW)


Backfill to invert level - R12 - PW
Bedding under pipe - R12 - PW
Install pipes - R12 - PW
Install valves - R12 - PW
Valve chamber & chamber finishing - R12 - PW
Hydrostatic test - R12 - PW
Valve chamber cover installation - R12 - PW
Water meter installation - R12 - PW
House connection and surface box installation - R12 - PW
Backfilling until another utility - R12 - PW

Procure & Deliver of Pipes - R13-PWS


Backfill to invert level - R13 - PW
Bedding under pipe - R13 - PW
Install pipes - R13 - PW
Install valves - R13 - PW
Valve chamber & chamber finishing - R13 - PW
Hydrostatic test - R13 - PW
Valve chamber cover installation - R13 - PW
Water meter installation - R13 - PW
House connection and surface box installation - R13 - PW
Backfilling until another utility - R13 - PW

Procure & Deliver of Pipes - R15-PWS

Backfill to invert level - R15 - PWS


Bedding under pipe - R15 - PWS
Install pipes - R15 - PWS
Install valves - R15 - PWS
Valve chamber & chamber finishing - R15 - PWS
Hydrostatic test - R15 - PWS
Valve chamber cover installation - R15 - PWS
Water meter installation - R15 - PWS
House connection and surface box installation - R15 - PWS
Backfilling until another utility - R15 - PWS

Procure & Deliver of Pipes - R16-PWS

Backfill to invert level - R16 - PWS


Bedding under pipe - R16 - PWS
Install pipes - R16 - PWS
Install valves - R16 - PWS
Valve chamber & chamber finishing - R16 - PWS
Hydrostatic test - R16 - PWS
Valve chamber cover installation - R16 - PWS
Water meter installation - R16 - PWS
House connection and surface box installation - R16 - PWS
Backfilling until another utility - R16 - PWS
Weightage BY Unit Length

1,740.14
435.04 OK
100% 435.04
1,305.11 OK
5% 65.26
5% 65.26
25% 326.28
15% 195.77
10% 130.51
5% 65.26
10% 130.51
5% 65.26
5% 65.26
5% 65.26
1% 13.05
1% 13.05
1% 13.05
1% 13.05
1% 13.05
1% 13.05
1% 13.05
1% 13.05
1% 13.05
1% 13.05
3,017.08
754.27 OK
100% 754.27
2,262.81 OK
10% 226.28
5% 113.14
5% 113.14
25% 565.70
15% 339.42
10% 226.28
5% 113.14
10% 226.28
5% 113.14
5% 113.14
5% 113.14
2,197.09
549.27 OK
100% 549.27
1,647.82 OK
5% 82.39
5% 82.39
30% 494.34
20% 329.56
10% 164.78
5% 82.39
10% 164.78
5% 82.39
5% 82.39
5% 82.39
1,158.01
289.50 OK
100% 289.50
868.51 OK
5% 43.43
5% 43.43
30% 260.55
20% 173.70
10% 86.85
5% 43.43
10% 86.85
5% 43.43
5% 43.43
5% 43.43
1,158.01
289.50 OK
100% 289.50
868.51 OK
5% 43.43
5% 43.43
30% 260.55
20% 173.70
10% 86.85
5% 43.43
10% 86.85
5% 43.43
5% 43.43
5% 43.43
Road Name: RD-10 RD-11 RD-12
Road Length: 1,597.57 59.57 278.00 482.00
Weightage: 100% 3.73% 17.40% 30.17%
Budgeted per Road 10,000.00 1,740.14 3,017.08
Engineering 5%
Procurement 25% - 435.04 754.27
Construction 70% - 1,305.11 2,262.81

Value must be equal to Budgeted per road = - 1,740.14 3,017.08


Variance = - - -
Checking OK OK OK
RD-13 RD-14 RD-15 RD-16
351.00 57.00 185.00 185.00
21.97% 3.57% 11.58% 11.58%
2,197.09 1,158.01 1,158.01

549.27 - 289.50 289.50


1,647.82 - 868.51 868.51

2,197.09 - 1,158.01 1,158.01


- - - -
OK OK OK OK

You might also like