MRWD Water Production Proposals Comparison

Comparison between water production proposals (CPE report summary)
1. Rehabilitation of old Lawaan WTP
2. Construction of new WTP
3. Bulk Water contract
Constraints:
1. Financial
2. Environmental
3. Time Savings

1. Metro Roxas Water District Status and Proposals for Increase in Water Production

2. Common Complaints Low water pressure during peak hours Limited service coverage due to inadequate water supply Breakdowns in machinery and equipment Increasing losses due to leakage and spoilage (Non Revenue Water)

3. Service Areas Service Areas Connections 2020 Average Daily Consumption Roxas City 29,770 20,230 m 3 Panay 5,319 2,788 m 3 Panitan 1,858 1,015 m 3 Ivisan 1,663 887 m 3 Sigma Bulk Water 1 177 m 3 Total 38,611 25,096 m 3

4. Population Served Service Areas Population Served % Served Roxas City 138,172 77.5% Panay 25,166 25.3% Panitan 8,918 53.0% Ivisan 7,932 20.8% Total 180,745 54.4%

5. Water Production Facilities Facility Location Source Daily Output Salocon WTP Salocon, Panitan Surface Water 38.00 MLD * Bahit WTP Bahit, Panitan Surface Water 1.50 MLD * Cabugao Pumping Station Cabugao , Roxas City Deep Well 0.26 MLD * Lonoy Pumping Station Lonoy , Roxas City Deep Well 0.13 MLD * 39.89 MLD * Theoretical capacity

6. Water Production Process Raw Water Intake Sand and Grit Sedimentation Basins Treated Water Pumping Station Reservoirs Distribution

7. Raw Water Intake Intended to draw raw water from the Panay River for processing in the sedimentation basins. Composed of the following: Intake structure Three (3) 75hp submersible pumps Replaced by vertical turbine pumps

8. Sand and Grit structure intended to remove sand and other debris from raw water before being pumped to sedimentation basins

9. Sedimentation Basins two (2) structures designed to process raw water and produce 15 million liters per day ( MLD ) With a flash mixing chamber, flocculation tanks, sedimentation or clarifier basins, and filter media beds

10. Treated Water Pumping Station Treated water is pumped to the reservoirs using: Three (3) 300hp vertical turbine pumps Two (2) 75hp vertical turbine pumps

11. Reservoirs Main Reservoirs Lawaan Reservoir (2,700 m 3 ) Arkabalo Reservoir (700 m 3 ) Other storage facilities: Culasi Reservoir (1,000 m 3 ) NHA Reservoir (300 m 3 ) Ivisan Reservoir (300 m 3 )

12. Distribution Treated water is distributed from reservoirs to consumers using gravity 373 kilometers of distribution pipelines, from as small as 50mm to as large as 600mm

13. Areas Serviced Facility Areas Serviced Daily Output Salocon WTP All areas 38.00 MLD Bahit WTP Panitan 1.50 MLD Cabugao Pumping Station Parts of Roxas City 0.26 MLD Lonoy Pumping Station Parts of Roxas City, Ivisan, and Sigma 0.13 MLD 39.89 MLD

14. Daily Water Consumption (Actual) Type 2017 2018 2019 2020 Residential 19,397 20,093 21,263 22,432 Government 797 813 847 882 Commercial 2,505 2,570 2,696 2,822 Industrial 105 107 112 117 Bulk Sales 221 236 257 278 Sigma 383 400 216 225 Total 23,408 24,219 25,391 26,755

15. Average Water Production Year Average Annual Water Production Increase 2017 809,935 m 3 2018 854,810 m 3 44,875 m 3 2019 987,723 m 3 132,913 m 3 2020 YTD 1,017,935 m 3 30,312 m 3

16. Water Demand Projection Year Projected Average Daily Demand Maximum Daily Demand (ADD x 1.2) 2022 34,716 41,659 2023 36,049 43,259 2024 38,083 45,700 2025 40,254 48,305 2026 42,827 51,392 2027 44,983 53,980 2028 47,515 57,018 2029 50,241 60,289 2030 52,653 63,184

17. Water Demand Projection Year Projected Average Daily Demand Maximum Daily Demand (ADD x 1.2) 2031 55,215 66,258 2032 57,945 69,534 2033 60,168 72,202 2034 62,481 74,977 2035 64,901 77,881

18. Water Demand Projection

19. Water Supply and Demand Year Average Daily Demand Maximum Daily Demand (ADD x 1.2) Daily Water Production Non Revenue Water (20%) Water Supplied (WP - NRW ) 2022 34,716 41,659 39,890 7,978 31,912 2023 36,049 43,259 39,890 7,978 31,912 2024 38,083 45,700 39,890 7,978 31,912 2025 40,254 48,305 39,890 7,978 31,912 2026 42,827 51,392 39,890 7,978 31,912 2027 44,983 53,980 39,890 7,978 31,912 2028 47,515 57,018 39,890 7,978 31,912 2029 50,241 60,289 39,890 7,978 31,912 2030 52,653 63,184 39,890 7,978 31,912

20. Water Supply and Demand Year Average Daily Demand Maximum Daily Demand (ADD x 1.2) Daily Water Production Non Revenue Water (20%) Water Supplied (WP - NRW ) 2030 52,653 63,184 39,890 7,978 31,912 2031 55,215 66,258 39,890 7,978 31,912 2032 57,945 69,534 39,890 7,978 31,912 2033 60,168 72,202 39,890 7,978 31,912 2034 62,481 74,977 39,890 7,978 31,912 2035 64,901 77,881 39,890 7,978 31,912

21. Water Supply and Demand

22. Timeline Date Action 11072019 Long Term Improvemen t Plan (Resolution no. 103, 2019) 01022020 Creation of Technical Working Group (Office Order 2020-01-01) 01202020 TWG recommended an independent consultant to evaluate options 01242020 Approval to engage services of consultant (Resolution no. 12, 2020) 05052020 Terms of Reference for consultant approved (Resolution no. 29, 2020)

23. Timeline Date Action 05052020 Terms of Reference for consultant approved (Resolution no. 29, 2020) 07022020 CPE Engineering Services awarded contract 08052020 Final draft of recommendation submitted and copies furnished to key personnel 08062020 Department heads tasked to review final draft 08272020 Finance and Planning Departments submitted detailed financial analysis of all 3 options 09072020 Board of Directors instructed inclusion of pay-as-you-consume stipulation in Terms of Reference

24. Options Status Quo Rehabilitation of old Lawaan Water Treatment Plant Construction of new Water Treatment Plant at Salocon Bulk Water contract

25. Status Quo No rehabilitation No new Water Treatment Plant Incremental increase in water production No bulk water No rate increase

26. Status Quo Impact on consumers Year Average Daily Consumption Maximum Demand (AD x 1.2) Water Supply Non Revenue Water (20%) Actual Water Supply Surplus ( Deficit ) on Average Demand Surplus ( Deficit ) on Maximum Demand 2022 34,716 41,659 39,890 7,978 31,912 ( 2,804) ( 9,747) 2023 36,049 43,259 39,890 7,978 31,912 ( 4,137) ( 11,347) 2024 38,083 45,700 39,890 7,978 31,912 ( 6,171) ( 13,788) 2025 40,254 48,305 39,890 7,978 31,912 ( 8,342) ( 16,393) 2026 42,827 51,392 39,890 7,978 31,912 ( 10,915) ( 19,480) 2027 44,983 53,980 39,890 7,978 31,912 ( 13,071) ( 22,068) 2028 47,515 57,018 39,890 7,978 31,912 ( 15,603) ( 25,106) 2029 50,241 60,289 39,890 7,978 31,912 ( 18,329) ( 28,377) 2030 52,653 63,184 39,890 7,978 31,912 ( 20,741) ( 31,272)

27. Status Quo Impact on consumers

28. Rehabilitation of Lawaan WTP Rehabilitation of old 15MLD Water Treatment Plant at Lawaan Reservoir. This Water Treatment Plant was abandoned when the Salocon Water Treatment Plant became operational. Advantages: Existing structure Proximity to reservoir

29. Structures and Equipment (Phase I) Raw Water Intake Facility – rehabilitation of old raw water pumping station Raw Water Pumping Station – three (3) 225hp pumps to pump raw water to Lawaan WTP (18.75MLD) Transmission pipeline –10.2 km pipeline (33MLD) 6.05 kms of 700mm steel pipes 4.25 kms of 600mm steel pipes

30. Structures and Equipment (Phase I) Water Treatment Plant – rehabilitation of old Lawaan WTP (15 MLD ) Storage Facility – required to account for pressure drop Lot Acquisition – required for ground reservoir and sludge lagoon (no more available space at area)

31. Project Cost Structure and Equipment Cost Phase I (15MLD) Raw Water Intake P5,000,000.00 Raw Water Pumping Station P35,000,000.00 Water Treatment Plant (Construction) P30,000,000.00 Water Treatment Plant (Equipment) P70,000,000.00 Transmission Lines P440,400,000.00 Storage Facility P24,700,000.00 Lot Acquisition P3,250,000.00 Total Cost for Phase I P608,350,000.00

32. Structures and Equipment (Phase II) Raw Water Pumping Station – upgrading (18.75 MLD to 37.5 MLD ) Water Treatment Plant – upgrading (15MLD to 30MLD)

33. Project Cost Structure and Equipment Cost Phase II (30MLD) Raw Water Pumping Station P15,000,000.00 Water Treatment Plant (Construction) P105,000,000.00 Water Treatment Plant (Equipment) P70,000,000.00 Total Cost for Phase II P190,000,000.00 Total Basic Construction Cost P798,350,000.00 Contingency Fund (10%) P79,835,000.00 Total Cost for Rehabilitation of Lawaan WTP P878,185,000.00

34. Time to Completion Project Loan Local Water Utilities Administration Requirements Duration Feasibility Study 5 to 6 months Loan Application Financial Evaluation Monetary Board Clearance 8 to 11 months Loan Approval 2 to 3 months Terms of Reference 0.5 to 1 month Procurement through Design Build under RA 9184 6 to 8 months Implementation to Completion 12 to 15 months Total 33.5 to 44 months

35. Time to Completion Project Loan Government Financial Institution Requirements Duration Feasibility Study 5 to 6 months Waiver from Local Water Utilities Administration and Loan Application 6 to 8 months Financial Evaluation and Monetary Board Clearance 5 to 6 months Loan Approval 1.5 to 2 months Terms of Reference 0.5 to 1 month Tendering for Design Build 6 to 8 months Construction and Implementation 12 to 15 months Total 36 to 46 months

36. Impact on consumers Year Average Daily Consumption Maximum Demand (AD x 1.2) Additional Water Supply Actual Water Supply (20% NRW ) Surplus ( Deficit ) on Average Demand Surplus ( Deficit ) on Maximum Demand 2022 34,716 41,659 31,912 -2,804 -9,747 2023 36,049 43,259 31,912 -4,137 -11,347 2024 38,083 45,700 15,000 46,912 8,829 1,212 2025 40,254 48,305 15,000 46,912 6,658 -1,393 2026 42,827 51,392 15,000 46,912 4,085 -4,480 2027 44,983 53,980 30,000 61,912 16,929 7,932 2028 47,515 57,018 30,000 61,912 14,397 4,894 2029 50,241 60,289 30,000 61,912 11,671 1,623 2030 52,653 63,184 30,000 61,912 9,259 -1,272

37. Impact on consumers

38. New 15MLD WTP at Salocon Construction of new 15MLD Water Treatment Plant at Sitio Paslang , Barangay Salocon, Panitan, Capiz using vacant area. Advantages: No additional cost for land acquisition Stable design

39. Structures and Equipment (Phase I) Raw Water Intake Facility – rehabilitation of old raw water pumping station Raw Water Pumping Station – upgrading to 15MLD (3 x 25hp pumps) Water Treatment Plant – 15MLD Water Treatment Plant to be constructed beside existing Water Treatment Plants

40. Structures and Equipment (Phase I) Treated Water Pumping Station – composed of three (3) 150hp vertical turbine pumps to pump water to reservoirs Transmission pipelines – 10.2 kms 600mm steel pipeline to reservoirs (33MLD) Storage Facility – use of old Lawaan Water Treatment Plant as storage facility

41. Project Cost Structure and Equipment Cost Phase I (15MLD) Raw Water Intake P5,000,000.00 Raw Water Pumping Station P20,000,000.00 Water Treatment Plant (Construction) P92,310,000.00 Water Treatment Plant (Equipment) P88,690,000.00 Treated Water Pumping Station P28,000,000.00 Transmission Lines 374,600,000.00 Storage Facility 3,000,000.00 Site Development P1,000,000.00 Total Cost for Phase I P612,600,000.00

42. Structures and Equipment (Phase II) Raw Water Pumping Station – upgrading (15 MLD to 37.5 MLD ) Treated Water Pumping Station – upgrading (15MLD to 30MLD) Water Treatment Plant – upgrading (15MLD to 30MLD)

43. Project Cost Structure and Equipment Cost Phase II (30MLD) Raw Water Pumping Station P6,000,000.00 Water Treatment Plant (Construction) P75,735,000.00 Water Treatment Plant (Equipment) P72,765,000.00 Treated Water Pumping Station P12,000,000.00 Total Cost for Phase II P166,500,000.00 Total Basic Construction Cost P779,100,000.00 Contingency Fund (10%) P77,910,000.00 Total Cost for new WTP P857,010,000.00

44. Time to Completion Project Loan Local Water Utilities Administration Requirements Duration Feasibility Study 5 to 6 months Loan Application Financial Evaluation Monetary Board Clearance 8 to 11 months Loan Approval 2 to 3 months Terms of Reference 0.5 to 1 month Procurement through Design Build under RA 9184 6 to 8 months Implementation to Completion 12 to 15 months Total 33.5 to 44 months

45. Time to Completion Project Loan Government Financial Institution Requirements Duration Feasibility Study 5 to 6 months Waiver from Local Water Utilities Administration and Loan Application 6 to 8 months Financial Evaluation and Monetary Board Clearance 5 to 6 months Loan Approval 1.5 to 2 months Terms of Reference 0.5 to 1 month Tendering for Design Build 6 to 8 months Construction and Implementation 12 to 15 months Total 36 to 46 months

46. Impact on consumers Year Average Daily Consumption Maximum Demand (AD x 1.2) Additional Water Supply Actual Water Supply (20% NRW ) Surplus ( Deficit ) on Average Demand Surplus ( Deficit ) on Maximum Demand 2022 34,716 41,659 31,912 -2,804 -9,747 2023 36,049 43,259 31,912 -4,137 -11,347 2024 38,083 45,700 15,000 46,912 8,829 1,212 2025 40,254 48,305 15,000 46,912 6,658 -1,393 2026 42,827 51,392 15,000 46,912 4,085 -4,480 2027 44,983 53,980 30,000 61,912 16,929 7,932 2028 47,515 57,018 30,000 61,912 14,397 4,894 2029 50,241 60,289 30,000 61,912 11,671 1,623 2030 52,653 63,184 30,000 61,912 9,259 -1,272

47. Impact on consumers

48. Bulk Water Purchase Purchase of bulk water from independent supplier for P25.00 per m 3 in stages over a period of 15 years. Year Bulk Water Purchase Daily Cost 1 to 3 5 MLD P125,000.00 3 to 6 10 MLD P250,000.00 7 to 15 15 MLD P375,000.00

49. Project Cost and Revenues Year Annual Cost Expected Revenues (based on Effective Water Rate P40) 2022-2024 P45,625,000.00 P73,000,0000.00 2025-2027 P91,250,000.00 P146,000,000.00 2028-2037 P136,875,000.00 P219,000,000.00 P1,642,500,000.00 P2,628,000,000.00

50. Time to Completion Procurement Requirements Duration Financial Analysis of Bulk Water Rate 1 to 2 months Terms of Reference and Board Approval 0.5 to 1 month Procurement until Notice of Award 6 to 8 months Delivery after Notice of Award 12 to 15 months Total 19.5 to 26 months

51. Impact on consumers Year Average Daily Consumption Maximum Demand (AD x 1.2) Additional Water Supply Actual Water Supply (20% NRW ) Surplus ( Deficit ) on Average Demand Surplus ( Deficit ) on Maximum Demand 2022 34,716 41,659 5,000 36,912 2,196 (4,747) 2023 36,049 43,259 5,000 36,912 863 (6,347) 2024 38,083 45,700 5,000 36,912 (1,171) (8,788) 2025 40,254 48,305 10,000 41,912 1,658 (6,393) 2026 42,827 51,392 10,000 41,912 (915) (9,480) 2027 44,983 53,980 10,000 41,912 (3,071) (12,068) 2028 47,515 57,018 15,000 46,912 (603) (10,106) 2029 50,241 60,289 15,000 46,912 (3,329) (13,377) 2030 52,653 63,184 15,000 46,912 (5,741) (16,272)

52. Impact on consumers

53. Gantt Chart 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 LWUA Loan Feasibility Study Loan Application, Financial Evaluation , MB clearance Loan Approval TOR Procurement Design Build Implementation and Completion GFI Loan Feasibility Study LWUA waiver, Loan Application Evaluation Approval TOR Design Build Construction and Implementation Procurement FA TOR Procurement Delivery Year 1 Year 2 Year 3 Year 4

54. Timeline