The World Bank Report No: ISR14424 Implementation Status & Results Indonesia ID-Urban Water Supply and Sanitation (P090991) Public Disclosure Copy Operation Name: ID-Urban Water Supply and Sanitation (P090991) Project Stage: Implementation Seq.No: 5 Status: ARCHIVED Archive Date: 27-Jun-2014 Country: Indonesia Approval FY: 2010 Product Line: IBRD/IDA Region: EAST ASIA AND PACIFIC Lending Instrument: Specific Investment Loan Implementing Agency(ies): DG Cipta Karya - Ministry of Public Works Key Dates Board Approval Date 28-Jul-2009 Original Closing Date 31-Dec-2014 Planned Mid Term Review Date Last Archived ISR Date 25-Oct-2013 Effectiveness Date 25-Nov-2009 Revised Closing Date 31-Dec-2014 Actual Mid Term Review Date Project Development Objectives Project Development Objective (from Project Appraisal Document) The objective of the Project is to improve and expand water supply services in the Project areas by strengthening local water utilities to become operationally efficient and financially sustainable. Has the Project Development Objective been changed since Board Approval of the Project? Yes No Component(s) Component Name Component Cost Water Supply Infrastructure in Bogor 10.95 Water Supply Infratructure in Kapuas 5.65 Water Supply Infrastructure in Muara Enim 14.48 Institution Strengthening 2.36 Overall Ratings Public Disclosure Copy Previous Rating Current Rating Progress towards achievement of PDO Satisfactory Moderately Satisfactory Overall Implementation Progress (IP) Moderately Satisfactory Moderately Satisfactory Overall Risk Rating Implementation Status Overview Continued progress has been made in improving and expanding water supply services in the three targeted districts, with remaining investments expected to be completed by mid-2014. The project has already increased water production capacity by almost 25 percent, provided new connections to more than 52,500 households, and improved the reliability of water Page 1 of 12 The World Bank Report No: ISR14424 supply both as results of direct investments through this project and indirectly through additional programs funded by the Government as part of the incentives to the Local Governments for investing the sector development. Locations Public Disclosure Copy Country First Administrative Division Location Planned Actual Indonesia Not Entered Kabupaten Muaraenim Indonesia Not Entered Kabupaten Kapuas Indonesia Not Entered Bogor Results Project Development Objective Indicators Indicator Name Core Unit of Measure Baseline Current End Target Increment in installed capacity Number Value 2097.00 2572.00 3267.00 Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Comments Total production capacity in Increased of 475 l/s (23%) as Represents increase of 1,170 liters per second of 3 PDAMs per June 2013 (Bogor as per liters per second (56%) in - based on installed capacity December 2013). total production capacity of 3 PDAMs - based on installed capacity Kapuas Number Value 197.00 202.00 307.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Baseline value in the PAD. Data as per June 2013.The Target for 2014 PDAM Kapuas experienced new water treatment plant has problems during the long been operated although not drought in 2009-2010 and yet in full capacity as the new some of their systems had to water intake andwater stop operation - thus reduced transmission line is not yet in the production capacity. optimal operation. Public Disclosure Copy Muara Enim Number Value 190.00 460.00 650.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Baseline value in the PAD Data as per June 2013. New Target for 2014 water treatment plants under this project are still under construction and expected to be completed and in operation by end of June 2014. Kota Bogor Number Value 1710.00 2310.00 2310.00 Page 2 of 12 The World Bank Report No: ISR14424 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Baseline value in the PAD Data as per December 2013. Target for 2014. Construction of the new 400 l/ Public Disclosure Copy sec water treatment plant has just been completed. Increment in number of connections Number Value 115258.00 167746.00 173808.00 Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Comments Total number of connections A total of 52,488 new Represents a total increase of from 3 PDAMs connections (increase of 58,550 connections (51%) in 46%). Data as of the end of the 3 PDAMs June 2013, based on PDAMs' monthly reports Muara Enim Number Value 16421.00 23859.00 27021.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Baseline value in the PAD in Number of connections by Total connections targeted in 10800 but after reviewing end of June 2013, based on 2014. Total additional new annual report from Muara PDAM's monthly report. connection targeted is 10,600 Enim the baseline figure is actually higher. Kapuas Number Value 12250.00 14800.00 17700.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Baseline value in the PAD - Number of connections by Total new connections in corrected based on PDAM's end of June 2013 based on 2014 is targeted 17,700. audited annual report PDAM's monthly report. Additional new connection targeted is 5,450 Kota Bogor Number Value 86587.00 116971.00 129087.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Baseline value in the PAD is Number of connections by Total new connections in 74988 but after reviewing end of June 2013 based on 2014 targeted is 129087. annual report from Kota PDAM's monthly report Additional new connection Public Disclosure Copy Bogor the baseline figure is targeted from the project is 86587. 42,500 Operating Ratio less than 1 (<1) Yes/No Value No No Yes Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Comments Baseline value included in the Bogor has improved its Based on PDAM's audited signed Performance operating ratio to 0.77, but annual financial report. All Agreement (PA): ratio for Muara Enim is still PDAM's operating ratio <1 Bogor 0.91 1.2 and the ratio in Kapuas Muara Enim 1.2 has dropped to 1.51 (see Kapuas 1.31 details below). Page 3 of 12 The World Bank Report No: ISR14424 Muara Enim Yes/No Value No No Yes Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Baseline value included in the As per PDAM's audited <1 Public Disclosure Copy signed PA 1.2 annual financial report 2012, operating ratio is still 1.2 Kapuas Yes/No Value No No Yes Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Baseline value included in the As per PDAM's audited <1 signed PA was 1.08 based on annual financial report 2012, the PDAM's financial report, operating ratio is still 1.51 but it was later corrected/ (slightly improved from 1.56 in updated as 1.31. 2011). Following the long dry season in 2010-2011 when PDAM lost some of their customers and with delays of full optimalization of the new treatment plant, PDAM has not managed to reach targeted additional number of connections and still burdened by excess of number of employee. Tariff increase is not yet possible as PDAM still has not managed to improve services. Kota Bogor Yes/No Value Yes Yes Yes Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Baseline value included in the As per PDAM's audited <1 signed PA 0.91 annual financial report 2012, operating ratio is 0.77 Debt Service Coverage Ratio (DSCR) > 1.3 Yes/No Value Yes Yes Yes (for Bogor only) Public Disclosure Copy Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Comments DSCR 2.68 PDAM's audited financial Based on PDAM's audited report 2012 indicated that annual financial report PDAM Kota Bogor has been DSCR >1.3 able to maintain the DSCR>1.3 (actual DSCR per June 2013 is 4.4) New piped household water connections that Number Value 0.00 40372.00 58550.00 are resulting from the project intervention Date 24-Jun-2009 31-Dec-2013 31-Dec-2014 Page 4 of 12 The World Bank Report No: ISR14424 Comments Accumulative. Total from the Accumulative. Total from the three PDAMs three PDAMs Improvements in customer satisfaction - Percentage Value 98.42 98.33 98.33 Public Disclosure Copy complaint handling Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Comments Average from three PDAMs Average from three PDAMs Average from three PDAMs Kota Bogor Percentage Value 99.68 99.00 95.00 Sub Type Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Based on PDAM's audited Based on PDAM's monthly annual report 2009 report June 2013 Muara Enim Percentage Value 100.00 100.00 100.00 Sub Type Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Based on PDAM's audited Based on PDAM's monthly annual report 2009 report June 2013 Kapuas Percentage Value 95.59 96.00 100.00 Sub Type Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Based on PDAM's audited Based on PDAM's monthly annual report 2009 report June 2013 Improvements in customer satisfaction - Hours Value 12.20 15.66 18.00 service hours Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Comments Average from three PDAMs Average from three PDAMs Average from three PDAMs Kota Bogor Hours Value 23.00 24.00 24.00 Sub Type Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Based on PDAM's audited Per June 2013 annual report 2009 Muara Enim Hours Value 5.00 12.00 12.00 Sub Type Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Based on PDAM's audited Per June 2013. Low average annual report 2009 service hours because PDAM Public Disclosure Copy also manages small systems outside the urban areas which have very low service hours. Service hour in the city is already 24 hours in average. Kapuas Hours Value 8.62 11.00 18.00 Sub Type Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Page 5 of 12 The World Bank Report No: ISR14424 Breakdown Comments Based on PDAM's audited Per June 2013. Low average annual report 2009 service hours because PDAM also manages small systems outside the urban areas which Public Disclosure Copy have very low service hours. Service hour in the city is already 24 hours in average Improvements in customer satisfaction - Percentage Value 100.00 100.00 100.00 compliance with water quality standards Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Comments Average from three PDAMs Average from three PDAMs Average from three PDAMs Measures quality compliance based on direct, periodic testing done by the local Health Department - as reported in the annual audited performance report Kota Bogor Percentage Value 100.00 100.00 100.00 Sub Type Date 31-Dec-2013 18-Dec-2013 31-Dec-2014 Breakdown Comments As per PDAM's audited As per PDAM's audited annual report 2009 annual report 2012 Muara Enim Percentage Value 100.00 100.00 100.00 Sub Type Date 31-Dec-2009 18-Dec-2013 31-Dec-2013 Breakdown Comments As per PDAM's audited As per PDAM's audited annual report 2009 annual report 2012 Kapuas Percentage Value 100.00 100.00 100.00 Sub Type Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments As per PDAM's audited As per PDAM's audited annual report 2009 annual report 2012 Intermediate Results Indicators Public Disclosure Copy Page 6 of 12 The World Bank Report No: ISR14424 Indicator Name Core Unit of Measure Baseline Current End Target Number of individual meters replaced or Number Value 19675.00 340.00 31350.00 repaired Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Public Disclosure Copy Comments Total from three PDAMs Total from the three PDAMs, This is the target of number of for the period of January to individual meters replaced or June 2013 only. repaired/calibrated from 2013 Total cumulative number of to 2014 only. Total meters to meters replaced or repaired/ be replaced or repaired/ calibrated since the beginning calibrated will be cumulative of project implementation till 123,877 units end of December 2012 is 41,492 units Muara Enim Number Value 238.00 236.00 600.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Total number of meters This is the target number of replaces or repaired from individual meters replaced or January to June 2013. repaired from 2013 to 2014 Accumulative number from only. Total meters to be beginning of project till end of replaced or repaired/ December 2012 is 1,676 units calibrated in Muara Enim will be cumulative 2,638 units Kapuas Number Value 0.00 104.00 750.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Total number of meters This is the target number of replaces or repaired from individual meters replaced or January to June 2013. repaired from 2013 to 2014 Accumulative number from only. Total meters to be beginning of project till end of replaced or repaired/ December 2012 is 398 units calibrated in Kapuas will be 1,962 units Kota Bogor Number Value 19437.00 0.00 30000.00 Public Disclosure Copy Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Baseline in the PA Total number of meters Included in the PA.This is the replaces or repaired from target number of individual January to June 2013 - data meters replaced or repaired not yet available. from 2013 to 2014 only. Total Accumulative number from connections tobe replaced or beginning of project till end of repaired in Kota Bogor will be December 2012 is 81,561 119,277 units units Number of employees per 1000 connection Number Value 8.63 8.49 7.00 Page 7 of 12 The World Bank Report No: ISR14424 Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Comments Average of three PDAMs Average of three PDAMs In accordance to the MOHA Decree No. 47/1999 - Public Disclosure Copy maximum ratio of number of employee per 1000 connections Muara Enim Number Value 9.07 9.72 8.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Per June 2013, based on In accordance to the MOHA PDAM's monthly report. Decree No. 47/1999 - PDAM has new systems maximum ratio of number of serving new service areas employee per 1000 located in remote locations, connections requiresthem to hire new employees for these new systems. Situation is expected to improve with new connections following the completion ofthe project activities. Kapuas Number Value 10.13 10.68 8.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Per June 2013, based on In accordance to the MOHA PDAM's monthly report. Decree No. 47/1999 - Following the long dry season maximum ratio of number of during the period of employee per 1000 2010-2011 when PDAM lost connections some of their customers, PDAM has not managed to meet the targeted number of connections and is still burdened by excess number Public Disclosure Copy of employees. PDAM is also responsible for the operation of a local bottled water company (belongs to LG) that employs about 50 people. Situation is expected to improve as some of the employees will be retired and the local bottled water company will be handed over to LG. Page 8 of 12 The World Bank Report No: ISR14424 Kota Bogor Number Value 6.54 5.07 5.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Per June 2013, based on Public Disclosure Copy PDAM's monthly report Water tariffs collection efficiency Percentage Value 93.00 76.44 93.44 Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Comments Average of three PDAMs Unweighted average of three Average of three PDAMs PDAMs. Target achieved or exceeded in Kapuas (95%) and Bogor (98%), but not yet in Muara Enim (36%, seebelow) Muara Enim Percentage Value 84.48 36.43 90.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Per June 2013 based on PDAM's monthly report. This is most probably linked to late payments by the customers in Muara Enim. This figure will be verified and updated with the audited annual report for 2013 when it is available. Kapuas Percentage Value 90.00 95.00 95.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Per June 2013, based on PDAM's monthly report Kota Bogor Percentage Value 94.00 98.00 96.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Per June 2013, based on PDAM's monthly report Public Disclosure Copy Non Revenue Water Percentage Value 33.79 29.87 27.79 Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Comments Non Revenue Water (NRW) Average of three cities. Average of three cities. NRW measures system losses and is expected to be reduced by unbilled consumption. 5% as a result of project Average of three cities. Based investment on the baseline data included in the PAs. Kota Bogor Percentage Value 34.39 35.33 29.39 Page 9 of 12 The World Bank Report No: ISR14424 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Per June 2013 based on PDAM's monthly report. On- Public Disclosure Copy going construction works at the distribution networks have slightly affected the water leakage. Situation is expected to improve following the completion of the network rehabilitation. Muara Enim Percentage Value 25.00 20.00 20.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Per June 2013 based on PDAM's monthly report Kapuas Percentage Value 42.00 34.30 34.00 Sub Type Date 24-Jun-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Per June 2013 based on PDAM's monthly report Increment volume of water produced Number Value 1557.40 2046.80 2572.00 Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Comments Total from three PDAMs Total from three PDAMs Total from three PDAMs in average liters per second. Measures the actual production rather than installed capacity Kota Bogor Number Value 1322.00 1625.00 1972.00 Sub Type Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Per December 2012, based on PDAM's audited annual report 2012 Public Disclosure Copy Muara Enim Number Value 114.60 300.00 400.00 Sub Type Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Breakdown Comments Per December 2012, based on PDAM's audited annual report 2012 Kapuas Number Value 120.80 121.80 200.00 Sub Type Date 31-Dec-2009 18-Dec-2013 31-Dec-2014 Page 10 of 12 The World Bank Report No: ISR14424 Breakdown Comments Per December 2012, based on PDAM's audited annual report 2012 Public Disclosure Copy Data on Financial Performance (as of 30-Jan-2014) Financial Agreement(s) Key Dates Project Ln/Cr/Tf Status Approval Date Signing Date Effectiveness Date Original Closing Date Revised Closing Date P090991 IBRD-77300 Effective 28-Jul-2009 01-Sep-2009 25-Nov-2009 31-Dec-2014 31-Dec-2014 Disbursements (in Millions) Project Ln/Cr/Tf Status Currency Original Revised Cancelled Disbursed Undisbursed % Disbursed P090991 IBRD-77300 Effective USD 23.56 23.56 0.00 16.53 7.03 70.00 Disbursement Graph Public Disclosure Copy Key Decisions Regarding Implementation Project's results framework has been revised through project restructuring which was approved in December 23, 2013. The revised results framework will better reflect the progress of implementation and its impact in improving service performance. Restructuring History Level two Approved on 20-Dec-2013 Page 11 of 12 The World Bank Report No: ISR14424 Related Projects There are no related projects. Public Disclosure Copy Public Disclosure Copy Page 12 of 12