REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT by ESP Indonesia

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR)

FEBRUARY, 2006 This publication was produced by Development Alternatives, Inc. for the United States Agency for International Development under Contract No. 497-M-00-05-00005-00

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR

Title:

Program, activity, or project number: Strategic objective number: Sponsoring USAID office and contract number:

Report of Investment Estimate East Bogor Water Supply System Development (PDAM Tirta Kahuripan Kabupaten Bogor) Environmental Services Program, DAI Project Number: 5300201. SO No. 2, Higher Quality Basic Human Services Utilized (BHS). USAID/Indonesia, Contract number: 497-M-00-05-00005-00.

Contractor name:

DAI.

Date of publication:

February 2006.

TABLE OF CONTENTS LIST OF TABLES ....................................................................................................................... II BACKGROUND ......................................................................................................................... 1 1.

BASIC CONCEPTION ...................................................................................................... 2

BASIC ASSUMPTIONS AND PREMISES....................................................................... 2

THE RESULTS OF ANALYSIS AND CALCULATION ................................................ 3

LIST OF TABLES TABLE 1 COMPARISON SPAR PROPOSED VS NEW PROPOSED .......................................................................3 TABLE 2 POTENTIAL CONNECTION AND EXISTING DISTRIBUTION NETWORK ..............................................4

BACKGROUND This report is purposed to fulfill contract agreement with ESP program which will be finished on December 15, 2005. This agreement is started on November 15, 2005 or about 1 month period. Base on agreement, consultant has a responsibility to evaluate cost estimate or investment required to develop east Bogor water supply system, therefore consultant has visited to PDAM Tirta Kahuripan Kabupaten Bogor for discussing, collecting data, and observing project area as well as consultant has studied SPAR Kabupaten Bogor report and other relevant reports.

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR)

1. BASIC CONCEPTION Base on the results of discussion to the team from PDAM that is leaded by technical director, it has been decided that alternatives of water treatment plant (WTP) development scheme are as follow: • •

WTP at capacity of 50 l/sec will be placed at Bojong Kulur; WTP at capacity of 100 l/sec will be placed at Bojong Nangka;

Both systems will be integrated in distribution network mutually connected so that the system from Bojong Nangka will fill up a shortage of water supply which will be probably take place. This proposal is different from SPAR report proposed that the WTP should be built in Bojong Nangka at total capacity of 150 l/sec. Consultant will calculate the system proposed by PDAM that is developing WTP at capacity of 50 l/sec in Bojong Kulur and capacity of 100 l/sec in Bojong Nangka.

2. BASIC ASSUMPTIONS AND PREMISES To calculate the investment of east Bogor water supply system is required some of assumptions and premises are as follow: Water demand assumptions • Household water consumption: • Commercial water consumption: • Ratio household : commercial: • Additional number of house connection: • Unaccounted for water (UFW) on distribution: • Unaccounted for water (UFW) on production: • Basic year of prices: • Deep well will be decreased periodically: • Hydraulic calculation: • Type of WTP designed: • Staging of WTP construction:

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

23 m3/month 35 m3/month 99 : 1 1700 units per year 30% 2.5% 2005 (5 to 10) l/sec per year EPANET Model version 2 KEDASIH (hexacoidal flockulator) 2 phase (50 l/s and 100 l/s)

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR)

3. THE RESULTS OF ANALYSIS AND CALCULATION Comparison between the east Bogor water supply system proposed by SPAR and the new proposed which was recommended by PDAM can be described as follows: Table 1 Comparison SPAR Proposed vs New Proposed Description 1. Production (WTP & Intake)

SPAR Proposed Q: 150 l/s (Bojong Nangka)

New Proposed Q1: 50 l/s (Bojong Kulur) Q2: 100 l/s (Bojong Nangka)

2. Transmission pipe

ND 500 mm

ND 400 mm

3. Length of Distribution Network

166 km

38 km

4. Connections

9.900 units

12.879 units

5. Total Investment

Rp.69.3 billions

Rp.55.8 billions

Investment excluding tax and price contingency Source: Consultant Analysis, December 2005.

The significant difference of calculation on both systems is in length of distribution network. In SPAR proposed, length of distribution network is 166 km whereas length of distribution network of the new system is 38 km. In fact, some of the service/ project areas have been installed by pipes distribution network, so that it is not required to calculate back. Some of housing complex i.e. Villa Nusa Indah I to V, Bumi Mutiara, Limus Pratama and Citra Indah are the housing complex which has been installed by pipe distribution network fully. Kota Wisata as a bigger housing complex in the project area has been installed by pipe distribution network approximately 80% of the area. The following is some of data describing housing complex which is still has potential connection to be serviced and percentage of pipe distribution network which has been installed:

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR)

Table 2 Potential Connection and Existing Distribution Network No

Housing Complex

Potential Connection

Connected

% existing of distribution Network

Villa Mahkota

500

50%

Villa Nusa Indah I

1417

426

100%

Villa Nusa Indah II

3000

1644

100%

Villa Nusa Indah III

1800

925

100%

Villa Nusa Indah V

1700

202

100%

Bumi Mutiara

2155

615

100%

Kota Wisata

7000

4126

80%

Galileo Housing

297

Kota Legenda

2500

10.

Bukit Golf

2000

800

70%

11.

Limus Pratama

2154

100%

12.

Citra Indah

2932

2532

95%

13.

Jonggol (mix area)

925

14.

Cileungsi (mix area)

791

Trisakti

Total 27445 Source: PDAM Tirta Kahuripan Kabupaten Bogo, December 2005.

15190

In calculation of the new proposed system, the consultant is just calculating pipe distribution network which has not been installed fully. The results of water demand projection and investment calculation in detailed is shown in following annex:

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR) WATER DEMAND PROJECTION East Bogor Area

PDAM KABUPATEN BOGOR East Bogor Water Supply System For Indonsian Titles, Put '2' Here --->

Pessimistic Scenario 1 WATER DEMAND ANALYSIS 2005 Year 0

General Description Area (Ha) Number of Population (Inhabitant) Population Increase (%) Population Density (Inhabitant/Ha) Number of Person per Household Connection (person)

2006 Year 1

12,651 252,391 20 5

2007 Year 2

2008 Year 3

2009 Year 4

2010 Year 5

2011 Year 6

2012 Year 7

2013 Year 8

2014 Year 9

2015 Year 10

2016 Year 11

2017 Year 12

2018 Year 13

2019 Year 14

2020 Year 15

2021 Year 16

2022 Year 17

2023 Year 18

2024 Year 19

2025 Year 20

2026 Year 21

2027 Year 22

2028 Year 23

2029 Year 24

2030 Year 25

12,651 262,487 4.0% 21 5

12,651 272,986 4.0% 22 5

12,651 283,906 4.0% 22 5

12,651 295,262 4.0% 23 5

12,651 307,072 4.0% 24 5

12,651 319,355 4.0% 25 5

12,651 332,129 4.0% 26 5

12,651 345,415 4.0% 27 5

12,651 359,231 4.0% 28 5

12,651 373,600 4.0% 30 5

12,651 388,544 4.0% 31 5

12,651 404,086 4.0% 32 5

12,651 420,250 4.0% 33 5

12,651 437,060 4.0% 35 5

12,651 454,542 4.0% 36 5

12,651 472,724 4.0% 37 5

12,651 491,633 4.0% 39 5

12,651 511,298 4.0% 40 5

12,651 531,750 4.0% 42 5

12,651 553,020 4.0% 44 5

12,651 575,141 4.0% 45 5

12,651 598,146 4.0% 47 5

12,651 622,072 4.0% 49 5

12,651 646,955 4.0% 51 5

12,651 672,833 4.0% 53 5

16,338 1,300 81,690 31%

17,838 1,500 89,190 33%

19,338 1,500 96,690 34%

20,838 1,500 104,190 35%

22,338 1,500 111,690 36%

23,838 1,500 119,190 37%

25,338 1,500 126,690 38%

26,838 1,500 134,190 39%

27,738 900 138,690 39%

27,738 0 138,690 37%

27,738 0 138,690 36%

27,738 0 138,690 34%

27,738 0 138,690 33%

27,738 0 138,690 32%

27,738 0 138,690 31%

27,738 0 138,690 29%

27,738 0 138,690 28%

27,738 0 138,690 27%

27,738 0 138,690 26%

27,738 0 138,690 25%

27,738 0 138,690 24%

27,738 0 138,690 23%

27,738 0 138,690 22%

27,738 0 138,690 21%

Number of Connection Domestic Connection Household (unit) Connection increase (unit) Supplied Population (Inhabitants) Services Coverage (%) Non Domestic Connection Non Household (unit) Connection increase (unit) Total of Connections (unit) Total Increase (unit)

15,038 12,700 75,190 30% 1.0% 128 12,828

15,190 0

152

165 13 16,503 1313

180 15 18,018 1515

195 15 19,533 1515

210 15 21,048 1515

226 15 22,564 1515

241 15 24,079 1515

256 15 25,594 1515

271 15 27,109 1515

280 9 28,018 909

280 0 28,018 0

23 153 35

4,150,488 63,798 4,214,286 134 30.0% 2.5% 2,029,100 64

4,509,288 69,313 4,578,601 145 30.0% 2.5% 2,204,511 70

4,923,288 75,676 4,998,964 159 30.0% 2.5% 2,406,909 76

5,337,288 82,040 5,419,328 172 30.0% 2.5% 2,609,306 83

5,751,288 88,404 5,839,692 185 30.0% 2.5% 2,811,703 89

6,165,288 94,767 6,260,055 199 30.0% 2.5% 3,014,101 96

6,579,288 101,131 6,680,419 212 30.0% 2.5% 3,216,498 102

6,993,288 107,495 7,100,783 225 30.0% 2.5% 3,418,895 108

7,407,288 113,858 7,521,146 238 30.0% 2.5% 3,621,293 115

7,655,688 117,676 7,773,364 246 30.0% 2.5% 3,742,731 119

6,243,386 198 1.5 297 150 65

6,783,112 215 1.5 323 150 65

7,405,873 235 1.5 352 150 65 50

8,028,634 255 1.5 382 150 65 50

8,651,395 274 1.5 412 150 65 50 50

9,274,156 294 1.5 441 150 65 50 50

9,896,917 314 1.5 471 150 65 50 50

10,519,678 334 1.5 500 150 65 50 50 50 365 91% 402

11,142,439 353 1.5 530 150 65 50 50 50 365 97% 402

11,516,095 365 1.5 548 150 65 50 50 50 365 100% 402

Water Demand Average Demand (m3/year) (l/second) Peak Factor Max Day (l/second) Existing WTP (l/second) Existing Deep Well (l/second) New WTP Stage 1 (l/second) New WTP Stage 2 (l/second) New WTP Stage 3 (l/second) Total Capacity (l/second) Plant Utilization (%) Raw Water Required/Intake Capacity (l/second)

1.10

215 92% 237

215 100% 237

265 89% 292

265 96% 292

315 87% 347

315 93% 347

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

315 100% 347

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR) WATER DEMAND PROJECTION East Bogor Area

PDAM KABUPATEN BOGOR East Bogor Water Supply System For Indonsian Titles, Put '2' Here --->

Moderate Scenario 1 WATER DEMAND ANALYSIS 2005 Year 0

General Description Area (Ha) Number of Population (Inhabitant) Population Increase (%) Population Density (Inhabitant/Ha) Number of Person per Household Connection (person)

2006 Year 1

12,651 252,391 20 5

2007 Year 2

2008 Year 3

2009 Year 4

2010 Year 5

2011 Year 6

2012 Year 7

2013 Year 8

2014 Year 9

2015 Year 10

2016 Year 11

2017 Year 12

2018 Year 13

2019 Year 14

2020 Year 15

2021 Year 16

2022 Year 17

2023 Year 18

2024 Year 19

2025 Year 20

2026 Year 21

2027 Year 22

2028 Year 23

2029 Year 24

2030 Year 25

12,651 262,487 4.0% 21 5

12,651 272,986 4.0% 22 5

12,651 283,906 4.0% 22 5

12,651 295,262 4.0% 23 5

12,651 307,072 4.0% 24 5

12,651 319,355 4.0% 25 5

12,651 332,129 4.0% 26 5

12,651 345,415 4.0% 27 5

12,651 359,231 4.0% 28 5

12,651 373,600 4.0% 30 5

12,651 388,544 4.0% 31 5

12,651 404,086 4.0% 32 5

12,651 420,250 4.0% 33 5

12,651 437,060 4.0% 35 5

12,651 454,542 4.0% 36 5

12,651 472,724 4.0% 37 5

12,651 491,633 4.0% 39 5

12,651 511,298 4.0% 40 5

12,651 531,750 4.0% 42 5

12,651 553,020 4.0% 44 5

12,651 575,141 4.0% 45 5

12,651 598,146 4.0% 47 5

12,651 622,072 4.0% 49 5

12,651 646,955 4.0% 51 5

12,651 672,833 4.0% 53 5

16,338 1,300 81,690 31%

18,338 2,000 91,690 34%

20,338 2,000 101,690 36%

22,338 2,000 111,690 38%

24,338 2,000 121,690 40%

26,338 2,000 131,690 41%

27,738 1400 138,690 42%

27,738 0 138,690 40%

27,738 0 138,690 39%

27,738 0 138,690 37%

27,738 0 138,690 36%

27,738 0 138,690 34%

27,738 0 138,690 33%

27,738 0 138,690 32%

27,738 0 138,690 31%

27,738 0 138,690 29%

27,738 0 138,690 28%

27,738 0 138,690 27%

27,738 0 138,690 26%

27,738 0 138,690 25%

27,738 0 138,690 24%

27,738 0 138,690 23%

27,738 0 138,690 22%

27,738 0 138,690 21%

15,038 12,700 75,190 30% 1.0% 128 12,828

15,190 0

152

165 13 16,503 1313

185 20 18,523 2020

205 20 20,543 2020

226 20 22,564 2020

246 20 24,584 2020

266 20 26,604 2020

280 14 28,018 1414

280 0 28,018 0

23 153 35

4,150,488 63,798 4,214,286 134 30.0% 2.5% 2,029,100 64

4,509,288 69,313 4,578,601 145 30.0% 2.5% 2,204,511 70

5,061,288 77,798 5,139,086 163 30.0% 2.5% 2,474,375 78

5,613,288 86,282 5,699,570 181 30.0% 2.5% 2,744,238 87

6,165,288 94,767 6,260,055 199 30.0% 2.5% 3,014,101 96

6,243,386 198 1.5 297 150 65

6,783,112 215 1.5 323 150 65

7,613,460 241 1.5 362 150 65 100

8,443,808 268 1.5 402 150 65 100

9,274,156 294 1.5 441 150 65 100

6,717,288 103,252 6,820,540 216 30.0% 2.5% 3,283,964 104

7,269,288 111,737 7,381,025 234 30.0% 2.5% 3,553,827 113

7,655,688 117,676 7,773,364 246 30.0% 2.5% 3,742,731 119

1.10

215 92% 237

215 100% 237

315 77% 347

315 85% 347

315 93% 347

10,104,504 320 1.5 481 150 65 100 50

10,934,852 347 1.5 520 150 65 100 50

365 88% 402

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

365 95% 402

11,516,095 365 1.5 548 150 65 100 50 365 100% 402

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR) WATER DEMAND PROJECTION East Bogor Area

PDAM KABUPATEN BOGOR East Bogor Water Supply System For Indonsian Titles, B3Put '2' Here --->

Optimistic Scenario 1 WATER DEMAND ANALYSIS 2005 Year 0

General Description Area (Ha) Number of Population (Inhabitant) Population Increase (%) Population Density (Inhabitant/Ha) Number of Person per Household Connection (person)

2006 Year 1

12,651 252,391 20 5

2007 Year 2

2008 Year 3

2009 Year 4

2010 Year 5

2011 Year 6

2012 Year 7

2013 Year 8

2014 Year 9

2015 Year 10

2016 Year 11

2017 Year 12

2018 Year 13

2019 Year 14

2020 Year 15

2021 Year 16

2022 Year 17

2023 Year 18

2024 Year 19

2025 Year 20

2026 Year 21

2027 Year 22

2028 Year 23

2029 Year 24

2030 Year 25

12,651 262,487 4.0% 21 5

12,651 272,986 4.0% 22 5

12,651 283,906 4.0% 22 5

12,651 295,262 4.0% 23 5

12,651 307,072 4.0% 24 5

12,651 319,355 4.0% 25 5

12,651 332,129 4.0% 26 5

12,651 345,415 4.0% 27 5

12,651 359,231 4.0% 28 5

12,651 373,600 4.0% 30 5

12,651 388,544 4.0% 31 5

12,651 404,086 4.0% 32 5

12,651 420,250 4.0% 33 5

12,651 437,060 4.0% 35 5

12,651 454,542 4.0% 36 5

12,651 472,724 4.0% 37 5

12,651 491,633 4.0% 39 5

12,651 511,298 4.0% 40 5

12,651 531,750 4.0% 42 5

12,651 553,020 4.0% 44 5

12,651 575,141 4.0% 45 5

12,651 598,146 4.0% 47 5

12,651 622,072 4.0% 49 5

12,651 646,955 4.0% 51 5

12,651 672,833 4.0% 53 5

16,338 1,300 81,690 31%

18,838 2,500 94,190 35%

21,338 2,500 106,690 38%

23,838 2,500 119,190 40%

26,338 2,500 131,690 43%

27,738 1,400 138,690 43%

27,738 0 138,690 42%

27,738 0 138,690 40%

27,738 0 138,690 39%

27,738 0 138,690 37%

27,738 0 138,690 36%

27,738 0 138,690 34%

27,738 0 138,690 33%

27,738 0 138,690 32%

27,738 0 138,690 31%

27,738 0 138,690 29%

27,738 0 138,690 28%

27,738 0 138,690 27%

27,738 0 138,690 26%

27,738 0 138,690 25%

27,738 0 138,690 24%

27,738 0 138,690 23%

27,738 0 138,690 22%

27,738 0 138,690 21%

15,038 12,700 75,190 30% 1.0% 128 12,828

15,190 0

152

165 13 16,503 1313

190 25 19,028 2525

216 25 21,554 2525

241 25 24,079 2525

266 25 26,604 2525

280 14 28,018 1414

280 0 28,018 0

23 153 35

4,150,488 63,798 4,214,286 134 30.0% 2.5% 2,029,100 64

4,509,288 69,313 4,578,601 145 30.0% 2.5% 2,204,511 70

5,199,288 79,919 5,279,207 167 30.0% 2.5% 2,541,840 81

5,889,288 90,525 5,979,813 190 30.0% 2.5% 2,879,169 91

6,579,288 101,131 6,680,419 212 30.0% 2.5% 3,216,498 102

6,243,386 198 1.5 297 150 65

6,783,112 215 1.5 323 150 65

7,821,047 248 1.5 372 150 65 150

8,858,982 281 1.5 421 150 65 150

9,896,917 314 1.5 471 150 65 150

7,269,288 111,737 7,381,025 234 30.0% 2.5% 3,553,827 113

7,655,688 117,676 7,773,364 246 30.0% 2.5% 3,742,731 119

1.10

215 92% 237

215 100% 237

365 68% 402

365 77% 402

365 86% 402

10,934,852 347 1.5 520 150 65 150

11,516,095 365 1.5 548 150 65 150

365 95% 402

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

11,516,095 365 1.5 548 150 65 150

365 100% 402

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR) WATER DEMAND PROJECTION EAST BOGOR AREA

PDAM KABUPATEN BOGOR East Bogor Water Supply System For Indonesian Titles, Put '2' Here --->

Optimum Scenario 1 WATER DEMAND ANALYSIS 2005 Year 0

General Description Area (Ha) Number of Population (Inhabitant) Population Increase (%) Population Density (Inhabitant/Ha) Number of Person per Household Connection (person)

2006 Year 1

12,651 252,391 20 5

2007 Year 2

2008 Year 3

2009 Year 4

2010 Year 5

2011 Year 6

2012 Year 7

2013 Year 8

2014 Year 9

2015 Year 10

2016 Year 11

2017 Year 12

2018 Year 13

2019 Year 14

2020 Year 15

2021 Year 16

2022 Year 17

2023 Year 18

2024 Year 19

2025 Year 20

2026 Year 21

2027 Year 22

2028 Year 23

2029 Year 24

2030 Year 25

12,651 262,487 4.0% 21 5

12,651 272,986 4.0% 22 5

12,651 283,906 4.0% 22 5

12,651 295,262 4.0% 23 5

12,651 307,072 4.0% 24 5

12,651 319,355 4.0% 25 5

12,651 332,129 4.0% 26 5

12,651 345,415 4.0% 27 5

12,651 359,231 4.0% 28 5

12,651 373,600 4.0% 30 5

12,651 388,544 4.0% 31 5

12,651 404,086 4.0% 32 5

12,651 420,250 4.0% 33 5

12,651 437,060 4.0% 35 5

12,651 454,542 4.0% 36 5

12,651 472,724 4.0% 37 5

12,651 491,633 4.0% 39 5

12,651 511,298 4.0% 40 5

12,651 531,750 4.0% 42 5

12,651 553,020 4.0% 44 5

12,651 575,141 4.0% 45 5

12,651 598,146 4.0% 47 5

12,651 622,072 4.0% 49 5

12,651 646,955 4.0% 51 5

12,651 672,833 4.0% 53 5

16,538 1,500 82,690 32%

18,238 1,700 91,190 33%

19,938 1,700 99,690 35%

21,638 1,700 108,190 37%

23,338 1,700 116,690 38%

25,038 1,700 125,190 39%

26,538 1,500 132,690 40%

27,788 1,250 138,940 40%

27,788 0 138,940 39%

27,788 0 138,940 37%

27,788 0 138,940 36%

27,788 0 138,940 34%

27,788 0 138,940 33%

27,788 0 138,940 32%

27,788 0 138,940 31%

27,788 0 138,940 29%

27,788 0 138,940 28%

27,788 0 138,940 27%

27,788 0 138,940 26%

27,788 0 138,940 25%

27,788 0 138,940 24%

27,788 0 138,940 23%

27,788 0 138,940 22%

27,788 0 138,940 21%

Number of Connection Domestic Connection Household (unit) Connection increase (unit) Supplied Population (Inhabitants) Services Coverage (%)

15,038 12,750 75,190 30%

Non Domestic Connection Non Household (unit) Connection increase (unit) Total of Connections (unit) Total Increase (unit)

1.0% 129 12,879

15,190 0

152

167 15 16,705 1515

184 17 18,422 1717

201 17 20,139 1717

219 17 21,857 1717

236 17 23,574 1717

253 17 25,291 1717

268 15 26,806 1515

281 13 28,069 1263

281 0 28,069 0

23 153 35

4,150,488 63,798 4,214,286 134 30.0% 2.5% 2,029,100 64

4,564,488 70,161 4,634,649 147 30.0% 2.5% 2,231,498 71

5,033,688 77,373 5,111,061 162 30.0% 2.5% 2,460,881 78

5,502,888 84,585 5,587,473 177 30.0% 2.5% 2,690,265 85

5,972,088 91,798 6,063,886 192 30.0% 2.5% 2,919,649 93

6,441,288 99,010 6,540,298 207 30.0% 2.5% 3,149,032 100

6,910,488 106,222 7,016,710 222 30.0% 2.5% 3,378,416 107

7,324,488 112,585 7,437,073 236 30.0% 2.5% 3,580,813 114

7,669,488 117,888 7,787,376 247 30.0% 2.5% 3,749,478 119

6,243,386 198 1.5 297 150 117

6,866,147 218 1.5 327 150 110

7,571,943 240 1.5 360 150 105

8,277,738 262 1.5 394 150 100 50

8,983,534 285 1.5 427 150 90 50

9,689,330 307 1.5 461 150 80 50 50

255 94% 281 0

300 87% 330 55

Water Consumption per Connection Household (m3/connection/month) (l/cap/day) Non Household (m3/connection/month) Total of Water Consumption (Water Sold) Household (m3/year) Non Household (m3/year) Total of Water Comsumption/ Water Sold (m3/year) (l/second) NRW on Distribution (%) NRW on Production (%) Total NRW (m3/year) (l/second) Water Demand Raw Water Required/Intake Capacity (l/second) (m3/year) (l/second) Peak Factor Max Day (l/second) Existing WTP (l/second) Existing Deep Well (l/second) New WTP Stage 1 (l/second) New WTP Stage 2 (l/second) New WTP Stage 3 (l/second) Total Capacity (l/second) Plant Utilization (%) Raw Water Required/Intake Capacity (l/second) Additional Intake Capacity (l/second)

1.10

267 74% 294

260 84% 286

290 98% 319 55

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

10,395,126 11,017,887 11,536,854 11,536,854 11,536,854 11,536,854 11,536,854 11,536,854 11,536,854 11,536,854 11,536,854 330 349 366 366 366 366 366 366 366 366 366 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 494 524 549 549 549 549 549 549 549 549 549 150 150 150 150 150 150 150 150 150 150 150 70 65 65 65 65 65 65 65 65 65 65 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 330 370 365 365 365 365 365 365 365 365 365 365 93% 89% 96% 100% 100% 100% 100% 100% 100% 100% 100% 100% 363 407 402 402 402 402 402 402 402 402 402 402 110 110 165

11,536,854 11,536,854 11,536,854 11,536,854 366 366 366 366 1.5 1.5 1.5 1.5 549 549 549 549 150 150 150 150 65 65 65 65 50 50 50 50 50 50 50 50 50 50 50 50 365 365 365 365 100% 100% 100% 100% 402 402 402 402

11,536,854 11,536,854 11,536,854 11,536,854 11,536,854 366 366 366 366 366 1.5 1.5 1.5 1.5 1.5 549 549 549 549 549 150 150 150 150 150 65 65 65 65 65 50 50 50 50 50 50 50 50 50 50 50 50 50 50 50 365 365 365 365 365 100% 100% 100% 100% 100% 402 402 402 402 402

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR)

CAPEX EAST BOGOR WATER SUPPLY

PDAM KABUPATEN BOGOR

WTP 50 L/SECOND (BOJONG KULUR)

East Bogor Water Supply System For Indonesian Title click 2 -->

INVESTMENT PROGRAM 1 1000000 Volume

Description

Unit

Basic Prices year 2005 Total Investment (Rp. 000)

Unit Price (Rp.000)

Land Acquisition and Bulldozing - Intake and WTP - Booster Pump - Administrative Building

1,300 m2 0 m2 0 m2

120 100 100

Water Intake

1,413,825

Civil Works

422,625

- Water Intake Construction - Intake Well/Storage Installation - Pumping Station M&E Works - Fine Screens and Strainers(Automatic) - Hider pipe - Raw water Pump (Centrifugal) - Water Hammer Protection - Power Supply (PLN) C

156,000 156,000 -

Water Treatment Plant (WTP) Civil Works - Grit Chamber Inlet/ Coagulator Unit - Mixing Chamber/ Flockulator (Hexacoidal) - Sedimentation Chamber - Filter Units/ Filtration (Rapid Sand Filter) - Disinfectant Units - Reservoir - Sludge Disposal & Treatment - Pumping Station M&E Works - Grit Chamber Inlet/ Coagulator Unit - Mixing Chamber/ Flockulator (Hexacoidal) - Filter Units - Ozonator Dosing Pump Equipment - Chlorine Dosing Pump Equipment - Lime Dosing Pump Equipment - Alum Sulphate Dosing Pump Equipment - Back Washing Compressor (Centrifugal), H =14 m - Back Wash Pump (Centrifugal), H =14 m - Distribution Pump (Centrifugal), H = 60 m - Hydrovar (Variable Speed) and Lightning Rod - Hider Pipe - Back Wash Pipe - Power Supply (PLN) - Genset Support Buildings - Office Building - Genset House - Ozonator House & Workshop - Chlorine House & Workshop - Lime House & Workshop - Alum Sulphate House & Workshop - Back Wash Room - Guard House - Musholla - Access Road - Drainage - Fence PIPING - Flow Meter Indicator + Box - Raw Water Pipe (PE) - Gate Valve SCADA

l/sec m3

2,275 2,275

120

2,100

125,125 45,500 252,000

400 mm 50 l/sec

1 12 2

units m units

330,000 4,100 150,000

991,200 330,000 49,200 300,000

80 KW

1 1

units units

240,000 900

240,000 72,000

300 10 300 10 1,000 150 55 55 55 -

50 50

l/sec l/sec

600 mm 150 mm

55 55 55 2 2 2 1 12 12 70 210 20 20

400 mm

m3 m3 m3 m3 m3 m3 m3 m3 l/sec l/sec l/sec l/sec l/sec l/sec l/sec units units units units m m KW KVA

2,000 2,000 2,000 2,000 2,000 1,700 3,400 2,100 975 975 1,100 600 600 600 600 82,500 110,000 130,000 100,000 8,200 742 900 2,100

10 10 10 10 20 20 865 288 180

m3 m3 m3 m3 m3 m3 m3 m3 m3 m3 m m

1,250 1,250 1,250 1,250 1,250 1,250 2,000 1,250 1,250 120 700 300

2 100 2 50

unit m unit l/sec

60,000 1,983 98,200 2,700

SUBTOTAL LAND AND PHYSICAL WORKS

6,044,654 3,255,000 600,000 20,000 600,000 20,000 1,700,000 315,000 1,623,054 53,625 53,625 60,500 33,000 33,000 33,000 165,000 220,000 260,000 100,000 98,400 8,904 63,000 441,000 516,900 25,000 25,000 12,500 12,500 12,500 20,000 25,000 25,000 103,800 201,600 54,000 514,700 120,000 198,300 196,400 135,000 7,614,479

Physical Contingency

SUBTOTAL LAND AND PHYSICAL WORKS NON PHYSICAL WORKS Environmental Study Public Campaign and Socialization Capacity Building and Institutionalization Pre Contract Engineering Project Administration Tax

55 20

7,614,479

1.00% 0.10% 0.10% 1.00% 6.00% 1.50% 10.00%

76,145 7,614 7,614 76,145 456,869 114,217 761,448

SUBTOTAL NON PHYSICAL WORKS

1,500,052

TOTAL INVESTMENT (CONSTANT PRICE)

9,114,531

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR

CAPEX EAST BOGOR WATER SUPPLY PDAM KABUPATEN BOGOR

WTP 100 L/SECOND (BOJONG NANGKA)

East Bogor Water Supply System For Indonesian Title click 2 -->

INVESTMENT PROGRAM 1 1000000

Description

Volume

Unit

Unit Price (Rp.000)

Land Acquisition and Bulldozing - Intake and WTP - Booster Pump - Administrative Building Water Intake Civil Works - Water Intake Construction - Intake Well/Storage Installation - Pumping Station M&E Works - Fine Screens and Strainers(Automatic) - Hider pipe - Raw water Pump (Centrifugal) - Water Hammer Protection - Power Supply (PLN) Water Treatment Plant (WTP) Civil Works - Grit Chamber Inlet/ Coagulator Unit - Mixing Chamber/ Flockulator (Hexacoidal) - Sedimentation Chamber - Filter Units/ Filtration (Rapid Sand Filter) - Disinfectant Units - Reservoir - Sludge Disposal & Treatment - Pumping Station M&E Works - Grit Chamber Inlet/ Coagulator Unit - Mixing Chamber/ Flockulator (Hexacoidal) - Filter Units - Ozonator Dosing Pump Equipment - Chlorine Dosing Pump Equipment - Lime Dosing Pump Equipment - Alum Sulphate Dosing Pump Equipment - Back Washing Compressor (Centrifugal), H =14 m - Back Wash Pump (Centrifugal), H =14 m - Distribution Pump (Centrifugal), H = 60 m - Hydrovar (Variable Speed) and Lightning Rod - Hider Pipe - Back Wash Pipe - Power Supply (PLN) - Genset Support Buildings - Office Building - Genset House - Ozonator House & Workshop - Chlorine House & Workshop - Lime House & Workshop - Alum Sulphate House & Workshop - Back Wash Room - Guard House - Musholla - Access Road - Drainage - Fence PIPING - Flow Meter Indicator + Box - Raw Water Pipe (PE) - Gate Valve SCADA

3,000 m2 0 m2 0 m2

110 l/sec 40 m3 150 m2

400 mm 50 l/sec 160 KW

1 12 3 1 1

units m units units units

450 30 450 80 2,000

m3 m3 m3 m3 m3 m3 m3 200 m3

50 l/sec 50 l/sec 600 mm 150 mm

400 mm

Basic Prices Year 2005 Total Investment (Rp. 000)

120 100 100

2,275 2,275 2,100 330,000 4,100 150,000 240,000 900

2,000 2,000 2,000 2,000 2,000 1,700 3,400 2,100

110 110 110 110 110 110 2 3 3 1 12 12 120 350

l/sec l/sec l/sec l/sec l/sec l/sec l/sec units units units units m m KW KVA

975 975 1,100 600 600 600 600 82,500 110,000 130,000 100,000 8,200 742 900 2,100

20 40 15 15 15 15 20 20 865 288 300

m3 m2 m3 m3 m3 m3 m3 m3 m3 m3 m m

1,250 1,250 1,250 1,250 1,250 1,250 2,000 1,250 1,250 120 700 300

2 100 2 100

unit m unit l/sec

60,000 1,983 98,200 2,700

360,000 360,000 1,869,450 656,250 250,250 91,000 315,000 1,213,200 330,000 49,200 450,000 240,000 144,000 9,700,154 5,840,000 900,000 60,000 900,000 160,000 3,400,000 420,000 2,468,804 107,250 107,250 121,000 66,000 66,000 66,000 165,000 330,000 390,000 100,000 98,400 8,904 108,000 735,000 606,650 25,000 50,000 18,750 18,750 18,750 30,000 25,000 25,000 103,800 201,600 90,000 514,700 120,000 198,300 196,400 270,000 11,929,604

Physical Contingency SUBTOTAL LAND AND PHYSICAL WORKS NON PHYSICAL WORKS Environmental Study Public Campaign and Socialization Capacity Building and Institutionalization Pre Contract Engineering Project Administration Tax SUBTOTAL NON PHYSICAL WORKS TOTAL INVESTMENT (CONSTANT PRICE)

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

11,929,604

1.00% 0.10% 0.10% 1.00% 6.00% 1.50% 10.00%

119,296 11,930 11,930 119,296 715,776 178,944 1,192,960 2,350,132 14,279,736

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR)

CAPEX EAST BOGOR WATER SUPPLY PDAM KABUPATEN BOGOR

WTP 50 L/SECOND (BOJONG KULUR)

East Bogor Water Supply System For Indonesian Title click 2 --> Description

INVESTMENT PROGRAM 1 1000 Volume

Unit

Basic Prices year 2005 Total Investment (Rp. 000)

Unit Price (Rp.000)

Transmission pipes

5,969,015

Procurement

5,142,640

- ND 150 mm

PVC

0 m

228

- ND 200 mm - ND 250 mm - ND 300 mm Installing - ND 150 mm - ND 200 mm - ND 250 mm - ND 300 mm Pipe Bridge - ND 250 mm Bulk Water Meter - ND 200 mm - ND 250 mm

PVC PVC PVC

2400 m 8,000 m 0 m

357 536 858

PVC PVC PVC PVC

0 2400 8,000 0

STEEL

m m m m

53 63 75 89

0 m

2,800

1 unit 1 unit

Main Distribution Networks Procurement - ND 150 mm - ND 200 mm - ND 250 mm Installing - ND 150 mm - ND 200 mm - ND 250 mm Pipe Bridge - ND 150 mm

PVC PVC PVC

930 m 930 m 0 m

228 357 536

PVC PVC PVC

930 m 930 m 0 m

53 63 75

0 m

1,080

PVC

Tertiary Distribution Networks Procurement - ND 50 mm - ND 75 mm - ND 100 mm Installing - ND 50 mm - ND 75 mm - ND 100 mm Connection - House Connections/ Domestic - Non Domestic Connections

29,757 49,056

856,440 4,286,200 747,562 150,218 597,344 78,813 29,757 49,056 652,149 544,190 212,319 331,871 107,959 49,749 58,210 -

PVC PVC PVC

m 1860 m 1398 m 1398 m

36 72 108

PVC PVC PVC

1860 m 1398 m 1398 m

28 35 41

477,477 320,288 67,600 101,075 151,613 157,188 51,814 48,428 56,946

HDPE HDPE

5,470 83

475 750

2,660,500 2,598,250 62,250

units units

9,759,141 Physical Contingency

9,759,141

1.00% 0.10% 0.10% 1.00% 6.00% 1.50% 10.00%

SUBTOTAL NON PHYSICAL WORKS TOTAL INVESTMENT (CONSTANT PRICE)

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

97,591 9,759 9,759 97,591 585,548 146,387 975,914 1,922,551 11,681,691

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR)

CAPEX EAST BOGOR WATER SUPPLY

PDAM KABUPATEN BOGOR

WTP 50 L/SECOND (BOJONG KULUR)

East Bogor Water Supply System For Indonesian Title click 2 -->

Volume

Description

Unit

Unit Price (Rp.000)

Transmission pipes

Basic Prices year 2005 Total Investment (Rp. 000) 8,073,703

Procurement - ND 200 mm - ND 250 mm - ND 300 mm - ND 400 mm - ND 500 mm Installing - ND 200 mm - ND 250 mm - ND 300 mm - ND 400 mm - ND 500 mm Pipe Bridge - ND 300 mm Bulk Water Meter - ND 300 mm - ND 400 mm B

INVESTMENT PROGRAM 1000 1

PVC PVC PVC PVC STEEL

0 0 3750 3000 0

m m m m m

357 536 858 1,315 3,185

PVC PVC PVC PVC STEEL

0 0 3750 3000 0

m m m m m

63 75 89 114 181

STEEL

20 m 1 unit 1 unit

Main Distribution Networks Procurement - ND 150 mm - ND 200 mm - ND 250 mm Installing - ND 150 mm - ND 200 mm - ND 250 mm Pipe Bridge - ND 150 mm

PVC PVC PVC

4680 m 1200 m 0 m

228 357 536

PVC PVC PVC

4680 m 1200 m 0 m

53 63 75

20 m

1,080

PVC

Tertiary Distribution Networks Procurement - ND 50 mm - ND 75 mm - ND 100 mm Installing - ND 50 mm - ND 75 mm - ND 100 mm Connection - House Connections/ Domestic - Non Domestic Connections

2,800 65,541 111,005

PVC PVC PVC

m 3304 m 2478 m 2478 m

36 72 108

PVC PVC PVC

3304 m 2478 m 2478 m

28 35 41

HDPE HDPE

7,280 units 46 units

475 750

7,163,561 3,218,456 3,945,105 677,596 334,294 343,302 56,000 56,000 176,546 65,541 111,005 1,843,725 1,496,664 1,068,444 428,220 325,461 250,352 75,109 21,600 21,600 846,798 567,979 120,081 179,159 268,739 278,819 92,040 85,840 100,939 3,492,500 3,458,000 34,500 14,256,726

Physical Contingency

14,256,726

1.00% 0.10% 0.10% 1.00% 6.00% 1.50% 10.00%

SUBTOTAL NON PHYSICAL WORKS TOTAL INVESTMENT (CONSTANT PRICE)

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

142,567 14,257 14,257 142,567 855,404 213,851 1,425,673 2,808,575 17,065,301

REPORT OF INVESTMENT ESTIMATE EAST BOGOR WATER SUPPLY SYSTEM DEVELOPMENT (PDAM TIRTA KAHURIPAN KABUPATEN BOGOR)

CAPEX EAST BOGOR WATER SUPPLY CAPEX EAST BOGOR WATER SUPPLY

Description

NO A

Land Acquisition and Bulldozing - Intake and WTP

Water Intake Civil Works - Water Intake and Storage - Pumping Station M&E Works - Intake Installation - Raw water Pump (Centrifugal) - Power Supply (PLN)

INVESTMENT PROGRAM 1000000 1 <-- For Indonesian Title click 2 TOTAL 2005 2006 2007 INVESTMENT Year 0 Year 1 Year 2 (000 Rp) M2 4,300 m2 55 + 110 l/sec 225 m3 270 m3 1 ls 5x50 l/sec 240 kw

Water Treatment Plant (WTP) Civil Works - WTP - Reservoir - Sludge Disposal & Treatment - Pumping Station - Support Building M&E and Plumbing Works - WTP Installation - Back Wash Pump (Centrifugal), H =14 m - Distribution Pump (Centrifugal), H = 60 m - Power Supply (PLN) - Genset

50+100

l/sec

1,630 3,000 0 350 2,010

m3 m3 m3 m3 m3

1 5x50 5x50 190 560

ls l/sec l/sec kw kva

516,000 516,000

3,283,275 1,078,875 511,875 567,000 2,204,400 1,238,400 750,000 216,000

15,744,808 10,218,550 3,260,000 5,100,000 735,000 1,123,550 5,526,258 2,979,258 550,000 650,000 171,000 1,176,000

Piping Primary Pipes - ND 300 mm - ND 400 mm - ND 500 mm Secondary Pipes - ND 150 mm - ND 200 mm - ND 250 mm Tertiary Pipes - ND 50 mm - ND 75 mm - ND 100 mm Pipe Bridge - ND 150 mm - ND 300 mm Bulk Water Meter - ND 200 mm - ND 250 mm - ND 300 mm - ND 400 mm

37,806 m

17,862,867

3,750 m 3,000 m 0 m

3,552,750 4,288,407

5,610 m 4,530 m 8,000 m

1,580,864 1,900,068 4,883,544

5,164 m 3,876 m 3,876 m

331,534 414,503 578,237

Connection - House Connections/ Domestic - Non Domestic Connections

12,879 units 12,750 units 129 units

1 unit 1 unit 1 1 1 1

unit unit unit unit

SUB TOTAL OF LAND AND PHYSICAL WORKS Physical Contingency

10%

SUB TOTAL 1 Non Physical Works Environmental Study Public Campaign and Socialization Capacity Building and Institutionalization Pre Contract Engineering Project Administration Tax SUB TOTAL 2 GRAND TOTAL 1 + 2 (FIXED COST)

ENVIRONMENTAL SERVICES PROGRAM WWW.ESP.OR.ID

156,000 156,000 -

2008 Year 3 -

1,413,825

2009 Year 4

360,000 360,000 -

2010 Year 5 -

1,869,450

170,625 252,000

341,250 315,000

619,200 300,000 72,000

619,200 450,000 144,000

5,394,954

10,349,854

1,240,000 1,700,000 315,000 516,900

2,020,000 3,400,000

639,054 220,000 260,000 63,000 441,000

2,340,204 330,000 390,000 108,000 735,000

6,621,164

2011 Year 6

2012 Year 7

2013 Year 8

2014 Year 9

2015 Year 10

420,000 606,650

477,477

8,095,303

1,822,125

846,798

3,552,750 4,288,407 0 262,068 1,396,739 4,883,544

1,318,796 503,329

119,414 149,504 208,559

212,120 265,000 369,678 21,600 56,000

21,600 56,000 29,757 49,056

29,757 49,056 65,541 111,005

65,541 111,005

6,152,841 6,056,250 96,591

723,864 712,500 11,364

43,559,791 4,355,979

879,864

14,250,322

1,657,855

87,986

1,425,032

165,786

47,915,770

967,850

15,675,354

435,599 21,780

435,599 43,560 43,560 435,599 2,613,597 4,355,995

435,599 980,099 4,355,995

820,379 807,500 12,879

723,864 712,500 11,364

603,220 593,750 9,470

21,134,986

2,642,504

1,667,177

723,864

603,220

2,113,499

264,250

166,718

72,386

60,322

1,833,894

796,250

663,542

1,823,641

23,248,484

2,906,754

217,800

21,780 43,560 980,099

7,927,911

6,229,073

1,045,439

55,843,680

7,196,923

16,720,793

217,800

2,041,441

23,466,284

3,124,554

1,833,894

796,250

663,542

ENVIRONMENTAL SERVICES PROGRAM Ratu Plaza Building, 17th. Fl. Jl. Jend. Sudirman No. 9 Jakarta 10270 Indonesia Tel. +62-21-720-9594 Fax. +62-21-720-4546 www.esp.or.id