rizal street, infanta, quezonin early 1980, municipality of infanta and general nakar through their...

"A member of the Philippine Association of Water Districts (PAWD)

Rizal Street, Infanta, Quezon

touching lives 24/7

FOREWORD

VISION, MISSION AND CORE VALUES

I. GENERAL

A. ADMINISTRATIVE

B. FINANCIAL/COMMERCIAL

C. TECHNICAL

D. OPERATIONAL

II. PROFILE

A. THE WATER DISTRICT AND ITS PHYSICAL SYSTEMS FACILITIES

1. ORGANIZATION

2. EXISTING SYSTEM FACILITIES

B. CURRENT OPERATIONAL/FINANCIAL HIGHLIGHTS

1. EXISTING WATER RATES

2. OPERATING INCOME/EXPENSES

3. FINANCIAL HIGHLIGHTS

C. COMMUNITY ECONOMIC PROFILE

1. TOTAL POPULATION

2. AVERAGE MONTHLY INCOME

3. MAJOR SOURCE OF INCOME

4. AVERAGE MONTHLY EXPENDITURES

5. MUNICIPALITY / CITY REVENUE

6. AVERAGE RATE OF MORTALITY (WATER BORNE DISEASE)

7. AVERAGE RATE OF MORBIDITY (WATER BORNE DISEASE)

8. MAJOR AGRICULTURAL, INDUSTRIAL AND

COMMERCIAL ACTIVITIES

D. OTHER INFORMATION

III. ANNEXES

A. FUNCTIONAL CHART

B. ORGANIZATIONAL CHART

C. LIST OF PLANTILLA OF PERSONNEL

D. SUMMARY OF POLICY SETTING RESOLUTIONS

E. FINANCIAL STATEMENTS

1. BALANCE SHEET

2. STATEMENT OF INCOME

3. COMPOSITIONOF CASH AND CASH IN BANK

4. STATEMENT OF CHANGES IN EQUITY

5. CASH FLOW STATEMENT

6. TRIAL BALANCE

7. COMPARATIVE BALANCE SHEET (2013-14)

8. COMPARATIVE INCOME STATEMENT (203-14)

9. COMPARATIVE CASH FLOW STATEMENT (2013-14)

10. COMPARATIVE STATEMENT OF CHANGES

IN EQUITY (2013-14)

11. NOTES TO FINANCIAL STATEMENTS

F. SUMMARYOF LOAN PAYMENT TO LWUA

G. WATER RATES

H. SUMMARY OF WATER PRODUCTION AND CONSUMPTION

I. WD WATER SOURCES

J. SERVICE CONNECTION GROWTH

K. SUMMARY OF NON REVENUE WATER

L. LIST OF MAJOR EQUIPMENTS

M. SUMMARY OF BACTERIOLOGICAL ANALYSIS

N. MONTHLY DATA SHEETS

INFANTA (QUEZON) WATER DISTRICT

Infanta , Quezon

2014 ANNUAL REPORT

TABLE OF CONTENTS

INFANTA (QUEZON) WATER DISTRICT Infanta, Quezon

2014 ANNUAL REPORT

A. Historical Background

In early 1980, Municipality of Infanta and General Nakar through their respective resolution formed a water district in compliance with the provision of PD 198 and on November 24, 1982 a Conditional Certificate of Compliance 229 was issued to Infanta-Gen. Nakar Water District. Since then, Infanta-Gen. Nakar Water District was a recipient of financial assistance from Local Water Utilties Administration in the form of loans.

In 2002 the Municipality of Gen. Nakar, requested for de-annexation and the district was renamed Infanta (Quezon) Water District (IQWD). During that time IQWD was maintaining four (4) water sources with 2,401 service connections.

On November 29, 2004 Typhoon Winnie devastated Infanta and other neighboring towns. The whole water system was 80% destroyed and the operation was financially affected causing the district to be in arrears in its loan repayments. Other obligations to BIR, premium payment to GSIS, Pag-ibig and virtually all obligations including payables to suppliers were also discontinued. Thru sheer determination, the management and employees, hardly work together even without enough salaries to rehabilitate the district. The district survived on meager donations from different organizations. IQWD rehabilitated Pumping Station III, the biggest source of IQWD water supply through financial assistance from a supplier who understood IQWD’s plight which was believed to be the surest and fastest way towards recovery. After less than a year in September 2005, IQWD’s operation was back to normal except for its financial capabilities.

At present, IQWD is serving potable water to 34 out of 36 barangays in the whole municipality of Infanta, with 5,816 active service connections as of December 2014. It has 3 pumping stations with combined production of 54 lps. These Pumping Stations are located in Brgy. Ilog, Brgy. Pilaway and Brgy .Agos-Agos. In 2015, IQWD plans to construct two (2) more pumping stations to augment its dwindling supply of potable water.

On March 21, 2012, IQWD was re-categorized by LWUA as ClASS “C” Water District and is now in the process of adapting Revised LWD Manual on Categorization, Re-Categorization and Other Related Matters under Department of Budget and Management. The Water District opted to have its position below the General Manager as two (2) Divisions - Admin., Finance & Commercial Division and Operations & Technical Division.

B. Vision-Mission Statement

Vision

To establish and build an efficient, reliable, economicallyviable and sound water

district that is committed to pursue its social responsibility, environmental

initiatives and its commitment to harness the fullest potential of its personnel as

the key drivers to its sustainable development program.

Mission

To provide access to safe and reliable potable drinking water at an affordable cost

thru efficient water system ever ensuring the protection of its water sources and

the environment in general by dedicated and competent management, in particular,

directed by evaluative and supportive Board of Directors and to provide to

sustainable growth essential to meet the challenges and the needs of the water

district and the community.

C. Value Statement

God created water as one of the signs of life, thus, INFANTA (QUEZON) WATER

DISTRICT’s officers and employees are considered the guardians of life as well as all

officers and employees of all water districts in the country today.

Our officers and employees are determined to pursue realization of IQWD’s Vision

and Mission by inculcating in their hearts and minds the following:

a. Sense of responsibility, rather than honor;

b. Altruism, rather than selfishness;

c. Sense of Duty, rather than political subservience;

d. Unity, rather than infighting ; and

e. Sense of Service, rather than remuneration.

D. Strategic Objective

As defined in PD 198 which created all Water Districts in the land, we adhere to the

rules and regulations of Local Water Utilities Administration as well as the rules and

regulations of other National Agencies such as Civil Service Commission, Department

of Public Works and Highways, Bureau of Internal Revenue, Commission On Audit,

National Water Resources Board, Department Of Health and other National

Government Agencies.

A. ADMINISTRATIVE

1. Attached approved organizational charts in effect as year's end.

a. Functional Chart /

b. Position/Organizational Chart (Key employees only) - showing

Permanent positions and incumbents /

2. Attach list of employed personnel with pertinent information.

(List of Plantilla of Personnel for the Fiscal Year 2014) /

The following summarizes the District's staffing

a. Total number of employees

b. Number of permanent employees

c. Number of casual/temporary employees/laborers

d. Number of employees meeting minimum qualifications per

Job Description adopted by the District

e. Number of employees not classified as casual/temporary

who do not meet the minimum qualifications established

by the District

3. Has the District adopted a policy prohibiting hiring of personnel related

up to the fourth degree by affinity or consaguinity? (Yes or No)

If not, how many of the employees are related to other employees

of officials with the fourth degree by affinity of consaguinity ?

4. Has the District adopted rules and regulation

a. Peronnel Matters /

b. Utility Customer Relations /

c. General Utility Operations /

During the year, in how many instances (or how many times) have

exemption to theses rules and regulations has been in special

cases?

5. Attach list of policy - setting resolutions adopted, repealed or amended

by the District Board including those adopting LWUA guidelines

(Summary of Policy - Setting Resolutions) /

6. Has the District written and properly updated, reliable records of the following?

(A field check may be undertaken, if necessary? Yes or no)

a. Customer Complaints /

b. Billing and Collection /

c. Deliquencies in Payment of Water Bills /

d. Meter Histories /

e. Service Connections /

f. Equipment Histories /

g. Equipment Downtime /

h. Bacteriological Tests /

i. System Pressure /

j. Leak Reports /

k. Unaccounted for Water /

l. Pump Effeciencies /

m. Water Production /

n. Water Production /

33

0

33

Yes, CSC Rules

0


Infanta, Quezon

For the Period January 1, 2014 to December 31, 2014

I. GENERAL

ANNUAL REPORT

33

o. Valve and pipeline location /

p. General Accounting /

q. Stock Inventory /

r. Stores Usage /

s. Employees Record /

t. Minutes and Board Meetings /

7. For this year, Auditing has been done by the Commission on Audit No

8. Attach list of reports prepared regularly by the District on a monthly basis as

required in the commercial Practice Manual (Omit this item if the District has not yet

installed the commercial practices system in which case, indicate that the said

system has not yet been installed yet.

(List of Reports Prepared Regularly)


1. Attach the District's financial statements for the report year including a comparison

of the immediate past year.

2. For the year under report, the District's total budgetary outlay was broken down into:

(Source: Approved Budget)

a. Operating Outlay

b. Capital Outlay

c. Special budgets, if any (additional budget )-Contingency

d. Debt Service

e. Reserve

3. For this same one-year period, the District's Gross Revenue was broken down into:

(Source: Financial Report)

a. Collection from water sales

b. Other water revenues

c. Other non-operating income

d. Proceeds from LWUA loan to finance new service connections

4. For this same one-year period, the District's expenditures was broken down into:

(Source: Financial Report)

a. Operational (operation & maintenance expenses, including depreciation)

b. Capital Outlay

c. Annual Debt Servicing (Annex G - Summary of Loan Payments to LWUA)

5. For this same one-year period, the total salaries, wages & other emoluments paid

for the District's employees where broken down into:

a. For permanent employees

b. For casual/temporary

6. Expenses for power/fuel for pumping during the year (Acct. #726, if Commercial

Practices Accts. are in effect):

7. Total amount billed during the year is broken down into:

a. Total Billings (Residential and Govt.) (in Php)

b. Commercial and Others.

8. Total amount collected (water sales only during the year is broken down into:

a. Current Billings

b. Arrears

26,124,829.32

5,720,249.44

18,941,546.67

12,761,126.79

1,097,564.52

1,675,056.00

6,283,972.40

0.00

4,835,013.93

977,494.20

31,605,486.24

1,224,892.60

2,069,160.71

0.00

23,171,656.53

Annex E

Annex N

23,419,009.78

5,500,000.00

0.00

2,359,106.41

9. Total amount uncollected (deliquent) at year's end excluding Bad Debts

10. Total reserves at year's end

11. Complaints filed, processed and settled during the year

a. Total number filed, processed and settled during the year

b. Number dismissed for lack of merit/wothdrawn

c. Number investigated

d. Number settled to the satisfaction of complaints

e. Number elevated to the District Board of Directors

f. Number settled by the Board

g. Number elevated to the higher authorities

12. At year's end, the following water charges were in force:

(Annex G-Approved Water Rates Schedule)

Had these rates been submitted to LWUA for review? (Yes or No )

C. TECHNICAL

1. Has the District adopted by Board Resolutions, a set of design and construction

standard? (Yes or No)

If so, who prepared it?

Is it being adhered to strictly?

2. Does the District undertake bacteriological test of its water? (Yes or No)

How often are these test made per year?

Is LWUA being furnished copies of these test reports? (Yes or No)

For the report year, how many such reports were submitted to LWUA?

3. State the method of water treatment employed by the District, if any

4. Does the District undertake regular pump efficiency test? (Yes or No)

How many of these pumps does the District have in its system?

How many of these pumps are operational?

D. OPERATIONAL

1. Total water production during the year in cubic metes

(Annex H-Summary of Water Production and Consumption)

Total water billed in cubic meters

Average per capita consumption in lpd

2. Attach list of Water Sources (Annex I-WD Water Sources)

3. Is the District provided with measuring devices to measure their water

production? (Yes or No)

If yes, what type?

If not, how do you measure productions

4. As of year's end, the District has the following existing service connection and

related information. (Annex J-Service Connection Growth)

a. Total number of existing connections (Active & Inactive Connection)

b. Number of Active Connections

c. Number of Metered Connections

1. With functioning meters

2. With non-functioning meters

d. Number of flat rate connections

e. Number of connections regularly billed

f. Number of deliquent concessionaires

5,816.00

0

0

5,755.00

Yes

Flow Meter

Annex J

6,522.00

5,816.00

5,816.00

3

Annex H

1,032,347.00

1.14:1

Annex I

Once a Month

Yes

12

Chlorination

Yes

4

1,730.00

1,730.00

Annex G

No

Yes

2,672,712.08

936,389.58

1. THE WATER DISTRICT & ITS PHYSICAL SYSTEM'S FACILITIES

A. ORGANIZATION

1. Date Formed Age (months) as of 12/31/14 385 Months

2. Date CCC was issued CCC No. 229

3. Personnel

Comments: (adequacy, qualification, performance & others)

B. EXISTING SYSTEM'S FACILITIES

1. Service

1.1 Service Area

1.2 Population of Service Area (Latest)

1.3 No. of Households

1.4 No. of Persons/Household

1.5 Service Time (hrs./day)

2. Structure and Equipment

2.1 Administration Building

Office Area

Office Equipment (see List of Major Equipments)

2.2 If rented, how much per month?

2.3 Type of Water Source

Rated Capacity per day (cu.m. / day)

2.5 Water Sources (Annex K-WD Water Sources)

2.6 Service Connections

Type Flat Metered

Residential Government 5,398

Commercial 418

Bulk -

Total 5,816


ANNUAL REPORT

For the Period January 1, 2014 to December 31, 2014

II. PROFILE

24 hours/day

Annex M

5,816

24-Nov-82

November 24, 1982

33- employees

150 square meter

Infanta, Quezon

31,988

6

Deep Well

7,000.00

4,441.21 cu.m

2.7 Production

Average Monthly Production

a. Booster/Pumping (cu.m)

b. Bulk Water (cu.m)

Production Efficiency % (average/month)

(Total Water Utilized/Total Production)

NRW % (______________) YTD

2. CURRENT OPERATION / FINANCIAL HIGHLIGHTS

A. Existing Water Rates (Annex H-Water Rates Schedule)

B. Operating Income/Expenses

Average Water Sales (average/mo)

Average Collection (average/mo)

Average Expenses-O & M for the year (average/mo)

C. Financial Highlights (rate & status)

Current Assets

Current Liabilities

Long Term Debt/Equity Ratio

Monthly Biling (average/mo)

Collection Efficiency-% of On-Time Payment (YTD)

3. COMMUNITY ECONOMIC PROFILE

A. Total Population (covered by the Water District)

B. Average Monthly Family Income in the Area

C. Major Source of Income

D. Average Monthly Family Expenditure in the Area

E. City/Municipal Revenue (CY 2014)

F. Average Rate of Mortality per 100,000 population due to waterborne diseases (e.g. diarrhea)

G. Average Rate of Morbidity per 100,000 population due to waterborne diseases (e.g. diarrhea)

H. Major Agricultural. Industrial and Commercial activities

Palay/Corn/Squash Production, Carabao/Cattle/Swine/Goat/Chicken Production; Concrete Aggregates

Current Ratio =

142,105,770.24

133,236.42 cu.m

NA

2,633,790.52

Annex G

2,641,889.46

1,930,971.38

38%

62%

0

13.28

0.28

2,633,790.52

89.12%

0

31,988

Farming/Fishing

No.Available data from LGU

I. GENERAL

A. ADMINISTRATIVE


C. TECHNICAL

D. OPERATIONAL

II PROFILE

A. THE WATER DISTRICT AND ITS PHYSICAL SYSTEM FACILITIES

1. ORGANIZATION

2. EXISTING SYSTEM FACILITIES

The lot for propose office building has an area of 3,779 sq.m., located at Bgy. Comon,

Infanta, Quezon

A. The table shows the three (3) pump stations with their corresponding

capacities.

1. P/S 2 (Bgy. Agos-Agos) Bgy. Agos-Agos, Infanta, Quezon

2. P/S 3 (Bgy. Ilog) Bgy. Ilog, Infanta, Quezon

3. P/S 4 (Bgy. Pilaway) Bgy. Pilaway, Infanta, Quezon

B. CURRENT OPERATIONAL/FINANCIAL HIGHLIGHTS

1. EXISTING WATER RATES

17 lps

CATEGORY METER SIZE MINIMUM

straight listing positions below the General Manager.

NAME

10 lps

34 lps

TOTAL RATED

CAPACITY (lps)LOCATION

The Infanta (Quezon) Water District was categorized as Category "C" Water District

in compliance with the guidelines as provided for in the Department of Budget and Management

(DBM) approved revised Local Water District (LWD) Manual on Categorization, Re-categorization

and other related matters (LWD-MACRO). The Certificate of Category was issued by the Local

Water Utilities Administration (LWUA) last March 21, 2012. At present the District opted to have

Commercial A

Commercial C

1/2"

1/2"

1/2"

1/2"

0-10

248.00

496.00

434.00

310.00

Commercial B 1/2" 372.00

Residential/Government

Commercial/Industrial

2. OPERATING INCOME/EXPENSES

a) OPERATING INCOME = 34,899,539.55

b) EXPENSES = 23,171,656.53

c) NET INCOME = 11,727,883.02

3. FINANCIAL HIGHLIGHTS

a) Total Current Assets = 12,351,097.21

b) Total Non-Current Assets = 56,064,969.65

c) Total Current Liabilities = 930,241.95

d. Total Government Equity = 52,596,230.93

C. COMMUNITY ECONOMIC PROFILE

1. TOTAL POPULATION = 31,988

2. AVERAGE MONTHLY INCOME = Php 5,000.00

3. MAJOR SOURCE OF INCOME

a. Farming

b. Fishing

4. AVERAGE MONTHLY EXPENDITURES **

5. MUNICIPALITY REVENUE = Php 142,105,770.24

6. AVERAGE RATE OF MORBIDITY

(Water Borne Disease)1

7. AVERAGE RATE OF MORTALITY

(Water Borne Disease)1

1. No available data

8. MAJOR AGRICULTURAL, COMMERCIAL AND INDUSTRIAL ACTIVITIES

A. Agricultural Production and Land Utilization

There are a total of 10,171.46 hectares of agricultural land in the municipality of Infanta. Areas serviced by National Irrigation Administration (NIA) are 1,784 hectares.

B. Crop Production and Land Utilities

There are three (3) major crops produced in the municipality of Infanta they are rice,

coconut and vegetables.

A. 1 Existing Major Agricultural Crops by Area, Production and Market CY 2012

MAJOR CROPS

AREA PRODUCTION PRODUCT MARKET

Hectares % Total Volume

(MT) Value Local Export/Other

Areas

1. Rice

Irrigated 1491.12 45.16 14016.53 Php 19,623,142.00 √ Laguna

Non-Irrigated 29.5 0.89 184 Php 257,600.00 √

2. Vegetable 63.02 1.90 1102.8 Php 22,056,000.00 √ Real, Polillo Island

3. Banana 310.5 9.39 2949.75 Php 2,949,750.00 √

4. Rootcrops 86.75 2.62 1279 Php 10,232,000.00 √ Rizal

5. Corn 30.5 0.92 162.67 Php 813,333.13 √

6. Coconut 1120.5 33.68

7. Pineapple 5 0.15 200 Php 3,000,000.00

8. Coffee / Cacao 30 0.91 (No Production Yet)

9. Peanut 20 0.60 1.28 Php 800,000.00 √

10. Fruit Trees 15.7 0.47 261.5 Php 4,296,445.00 √ Rizal

11. Kalamansi 5.75 0.17 2.875 Php 43,125.00 √

12. Other Crops 100 3.02 no record no record

Total 3308.34 99.88 20160.41 Php 64,071,395.13

Source: Infanta Municipal Agricultural Office

B. 1 Comparative Agricultural Crop Areas and Production CY 2011-2012

Source: Municipal Agricultural Office/PCA

Major and Minor Agricultural Occupations/Groups in Urban and Rural Areas CY 2012 Major and Minor Occupation Groups Location Urban Rural

Farmers 36 Barangays 6 30

Farmworkers 36 Barangays 6 30

Fishermen 16 Barangays 1 15

Crop Farmers 36 Barangays 6 30

Orchard Farmers 1 0 1

Ornamental and Other 1 0 1

Livestock 33 Barangays 1 32

Poultry Farmers 33 Barangays 1 32

Other Animal - - -

Aqua Farm cultivators - - -

Inland and Coastal 16 Barangays 1 15

Water Fishermen 16 Barangays 1 15

Deepsea Fishermen 1 Barangay 1

Other Farm workers

- - - not elsewhere classified

TOTAL

Source: Office of the Municipal Agriculturist

MAJOR CROPS AREA VOLUME OF PRODUCTION (mt

2011 2012 Increase/Decrease 2011 2012 Increase/Decrease

RICE 504.62 1,520.62 Increase 14200.53 Increase

VEGETABLE 63.02 63.28 Increase 216.26 252.40 Increase

BANANA 298.75 310.50 Increase 2,838.13 2,949.75 Increase

ROOTCROPS 76.75 86.75 Increase 767.50 867.50 Increase

CORN 25.00 30.50 Increase 133.30 162.60 Increase

PINEAPPLE 9.00 10.00 Increase 1,800.00 2,000.00 Increase

COFFEE/CACAO 5.00 30.00 Increase newly planted (no production yet)

FRUIT TREES 105.60 106.25 Increase 1,752.96 1,763.75 Increase

COCONUT 1,120.50 1,120.50

3,646,055 nuts/year 3,646,055 nuts/year the same

PEANUT 19.00 20.00 increase 15.20 16.00 Increase

COMMERCIAL & TRADE Data on Commercial Areas

Location Commercial Areas in Hectares % increase/decrease

2013 2014

Infanta 15.83 16.32 increase

Industrial

Location Commercial Areas in Sq. Meters % increase/decrease

2013 2014

Infanta 1873 1000 decrease

III. ANNEXES

A. FUNCTIONAL CHART

BOARD OF DIRECTORS

Policy Making

GENERAL MANAGER Policy Implementation

General Supervision Fund Custodian

-Monitors staffing requirements. -Plans & organizes work within the area of responsibility. -Supervises training for area personnel’s. -Respond to & resolve difficult & complex citizen inquiries & complaints.

-Prepares Payroll

-Maintains file for the following: - Prepares water Bills -Maintains Personnel Files a. Encoding of consumption & billed amount

a. Employees 201 files to the water bills b. Earned leaves Record -Prepares Reports c. Other Relevant Records a. Daily Billing Summary

-Maintains Book of Accounts, General and b. Daily Collectors Report gathered Subsidiary ledgers c. Inactive/Disconnected Accounts Prepares the monthly Financial Reports d. Accountability for Accountable forms b. Posts Payments

a. Income Statement -Performs Cashiering Functions b. Balance Sheet d. Monthly Data Sheet Accepts collections for the following:

c. Other Relevant Records a. Water Bills d. Monthly Data Sheet b. Bulk Water e. Quarterly Reports submitted c. Fees & other charges for New Connections to COA and fines for illegal -Prepares Aging of Accounts -Maintains Customer Ledger Cards -Maintains Inventory records a. Posts billing -Posting of Procurement forms b. Posts Payments c. Billing adjustment Memo -Operation and Maintenance -Performs Customer-related Activities -Production a. Attend to registration of application -In-Charge of Pumping Operations for new service connections - Pump Station Maintenance and Inspection b. Attends to complaints & requests -Flushing of Distribution Lines c. Prepares Disconnection Notices -Physical, Chemical & Bacteriological Report d. Master List of Service Connections -Maintenance

e. Other Related records a. Prepares Program of Work -Read Water Meter b. Implementation of Projects for

-Distribute Billing Notices Expansion & Rehabilitation -Do field collections c. Do plumbing works

-Serves disconnection notice to delinquent d. Do field maintenance jobs Consumers e. Maintains the good conditions of

-Implement Disconnection Orders machineries, motor vehicle and equipment

B. ORGANIZATIONAL CHART

BOARD OF DIRECTORS

GENERAL MANAGER

Utility Worker A

↓

↓

Storekeeper D

Admin. Services Aide (Vacant)

↓

↓

Utilities Service Asst. D

↓

↓

↓

Water Maintenance Man C (Vacant)↓

Utilities Service Asst. D↓

Admin. Services Aide↓

Water Maintenance Man C↓

Customer Service Asst. D

Water Maintenance Man C

Water Maintenance Man C

Water Resource Facilities Tender B

↓

↓

Accounting Processor B (Vacant)↓

Water Resource Facilities Tender B↓





Water Resource Facilities Tender B↓

Water Maintenance Man B↓

Accounting Processor A↓



Admin. Services Asst. C

Water Maintenance Man B

↓

↓

Water Resource Facilities Operator B↓


Admin. Services Aide↓

↓

↓

↓

↓


↓

↓


Admin. Services Aide


Admin. Services Asst. A

Customer Service Asst. D


Cashiering Assistant

9

ITEM SALARY

NO GRADE/

STEP

1 ISAGANI R. PRADILLADA GENERAL MANAGER F 22/2

2 NAIDA S. EVASCO ADMINISTRATION SERVICES ASSITANT A 12/5

4 TIRSO R. RIVERA CUSTOMER SERVICE ASSISTANT D 6/8

17 MELCHOR R. COMBO WATER MAINTENANCE MAN B 6/4

6 LIEZL C. PEÑAMORA CASHIERING ASSISTANT 8/5

21 APOLLO C. PEÑAMORA WATER MAINTENANCE MAN B 6/2

20 MARILOU M. CONCHADA ADMINISTRATION SERVICES AIDE 4/3

32 ROBERTO A. GURANGO WATER MAINTENANCE MAN B 6/2

23 ISMAEL S. MASIBAY WATER RESOURCES FACILITIES OPERATOR B 6/1

24 MARLON B. MORIONES WATER RESOURCES FACILITIES OPERATOR B 6/1

31 RAMZIE P. CALARA WATER RESOURCES FACILITIES OPERATOR B 6/1

14 HELEN M. LEYNES ADMINISTRATION SERVICES AIDE 4/4

34 ARIES S. AMERICA WATER MAINTENANCE MAN B 6/1

29 JANETH R. SERAFINES ADMINISTRATION SERVICES ASSISTANT C 8/1

22 GERRY C. BUSTONERA WATER MAINTENANCE MAN B 6/2

30 ALEXIUS A. RITUAL WATER MAINTENANCE MAN B 6/2

28 FLOR ANGELIE L. CUBALLES ACCOUNTING PROCESSOR A 8/1

5 ARNEL P. MORTIZ WATER MAINTENANCE MAN C 4/3

13 GUILLERMO A. AUDITOR JR. WATER MAINTENANCE MAN C 4/2

19 JOMMEL P. SOLLEZA WATER MAINTENANCE MAN C 4/2

12 GLEN B. MORTIZ WATER RESOURCES FACILITIES TENDER B 4/2

11 MENANDRO V. RESPLANDOR WATER RESOURCES FACILITIES TENDER B 4/2

9 HERSON T. JAVIER WATER MAINTENANCE MAN C 4/2

16 LEO MARK A. TENA WATER MAINTENANCE MAN C 4/2

8 ARROLD C. FORTUNADO WATER MAINTENANCE MAN C 4/2

7 ALDRIN ANGELO M. ALTEZA WATER RESOURCES FACILITIES TENDER B 4/2

27 ROSE MARY D. VILLENA ACCOUNTING PROCESSOR B 6/1

26 JANNETTE O. DIMACULANGAN UTILITIES SERVICE ASSISTANT D 6/1

18 JERRY G. CUENTO ADMINISTRATION SERVICES AIDE 4/1

36 JULITO A. ASTOVEZA WATER MAINTENANCE MAN C 4/1

33 MYRA M. VELOSO UTILITIES SERVICE ASSISTANT D 6/1

25 RAMON A. ESCARECES CUSTOMER SERVICE ASSISTANT D 6/1

3 ARIES C. OCAMPO UTILITY WORKER A 3/1

15 LINALYN P. TOLENTINO STOREKEEPER D 4/1

10 VACANT ADMINISTRATION SERVICES AIDE 4/1

35 VACANT WATER MAINTENANCE MAN C 4/1

POSITIONNAME OF INCUMBENT

C. LIST OF PLANTILLA

10

D. SUMMARY OF POLICY SETTING RESOLUTIONS

RESOLUTION

NUMBER

JAN. 10, 2014 001-2014 ₱170,000.00 Medical Allowance of Employees for the year 2014

JAN. 10, 2014 002-2014 ₱170,000.00 Uniform/Clothing Allowance of Employees for the year 2014

JAN. 10, 2014 003-2014 ₱139,590.00 Cost Allocation for the Procurement from PR. No. 003-S14

JAN. 10, 2014 004-2014 ₱383,929.35 Estimated Amount Allocation for the Procurement

from PR. No. 004-S14

JAN. 10, 2014 005-2014 ₱155,000.00 Fund for the 35th PAWD NATIONAL CONVENTION

JAN. 24, 2014 006-2014 Award the Procurement from PR.No. 003-S14 & PR.No. 004-S14 to the

lowest compliying bidder Makati Foundry, Inc. in the amount

of ₱440,535.00

JAN. 24, 2014 007-2014 ₱80.000.00 Productivity Bonus for the year 2013

JAN. 24, 2014 008-2014 Amending Resolution No. 92, Series 2013

JAN. 24, 2014 009-2014 ₱36,795.00 Emergency Purchase of One (1) Unit of Epson Printer

LQ-2190 24 PINS

JAN. 24, 2014 010-2014 ₱108,000.00 Estimated Amount Allocation for the Procurement

from PR.NO 008-S14(15 Drums of Chlorine Granules 70% solution 45 KGS)

JAN. 24, 2014 011-2014 ₱2,400.00 Institutional Membership Dues for the year 2013 at

Philippine Water Works Association

FEB. 13, 2014 012-2014 Fund for One (1) Flow Meter

FEB. 13, 2014 013-2014 ₱115,500.00 Estimated Amount Allocation for the Procurement

from PR.NO.012-S14

FEB. 13, 2014 014-2014 ₱159,295.00 Estimated Amount Allocation for the Procurement


FEB. 13, 2014 015-2014 ₱177,544.17 Estimated Amount Allocation for the POW of

Rehabilitation & Clustering-Purok Tower, Brgy. Ilog & Procurement

from PR. No.014-S14

FEB. 13, 2014 016-2014 Fund for QUAWD General Membership Meeting & Induction Rites

/Installation of Officers on February 19, 2014 at Villa Escudero Plantation

& Resort ,Tiaong,Quezon

FEB. 13, 2014 017-2014 ₱20,000.00 Fund for Public Hearing & KFW Project Presentation on

February 26, 2014 at Infanta Town Plaza

FEB. 13, 2014 018-2014 A resolution requesting LWUA for re-evaluation of the per diem of

the Board of Directors

FEB. 13, 2014 019-2014 A board resolution requesting LWUA for the extension of

Implementation of Provisional Rate Increase

MAR. 7, 2014 19A-2014 Board Resolution requesting LWUA's Approval of the Php 61.0M Financial

Assistance under the KFW Financing Window and the Proposed Water

Rates as presented in the Project Presentation and Public Hearing

held last February 26, 2014 at the Infanta Town Plaza

MAR. 14, 2014 020-2014 A board resolution extending the appointment of Mr. Isagani R.

Pradillada as General Manager of Infanta (Quezon) Water District (IQWD)

for Six Months effective March 19, 2014

DATE SUBJECT/TITLE

APR. 11, 2014 021-2014 ₱500.00/each monthly mobile expense of Ms. Naida S. Evasco,

Ms. Jannette O. Dimaculangan and Ms. Myra M. Veloso effective

on May 2014

APR. 11, 2014 022-1014 ₱5,000.00 Donation to Local Government Unit (LGU) of Infanta for the

318th founding Anniversary and Town Fiesta 2014

APR. 11, 2014 023-2014 ₱5,000.00 Donation to Rotary Club of Infanta for the Forthcoming

Fiesta Celebration on April 24, 2014 APTLY dubbed as A Night of

Music and Dance with the Rotarians

APR. 11, 2014 024-2014 ₱53,900.00 Budget for 18th Annual Inter Office/Agency Basketball

Tournament 2014

APR. 29, 2014 025-2014 ₱170,000.00 Estimated Amount Allocation for the Procurement

from PR. No.020-S14

APR. 29, 2014 026-2014 Award the procurement from PR. No. 012-S14 to the lowest complying

bidder Caraga Plumbing Concepts in the amount of Php 112,400.00

APR. 29, 2014 027-2014 Award the procurement from PR. No. 013-S14 to the lowest complying

bidder JNR Enterprises in the amount of Php 158,300.00

APR. 29, 2014 028-2014 ₱8,340 .00 Payment for PAWD Annual Dues for 2014 & Aquarius

Magazine Subscription 2014

APR. 29, 2014 029-2014 ₱100,000.00 Partial Terminal Leave of GM Isagani R. Pradillada from

September 1, 2010 to March 18, 2014

APR. 29, 2014 030-2014 Board Resolution requesting for favorable endorsement from the

Municipal Development Council for the Infanta (Quezon) WD's KfW

Funded Project

APR. 29, 2014 031-2014 Board Resolution requesting for favorable endorsement from the

Provincial Development Council for the Infanta (Quezon) WD's KfW

Funded Project

APRIL 29, 2014 032-2014 Board Resoluition requesting for favorable endorsement from the

Regional Development Council forthe Infanta (Quezon) WD's KfW

Funded Project

MAY 9, 2014 033-2014 Fund For one (1) Flow Meter at Pumping Station 2

MAY 9, 2014 034-2014 Release of Employees ( 1/2) 13th Month Pay & Cash Gift

MAY 9, 2014 035-2014 Award the Procurement from PR. No. 020 -S14 to the lowest complying

bidder Rondex Enterprises Corp. in the amount of ₱167,040 .00

MAY 9, 2014 036-2014 ₱108 ,000.00 Estimated Amount Allocation for the Procurement


MAY 9, 2014 037-2014 A resolution requesting for the Immediate Passage of House Bill No.3675

MAY 9, 2014 038-2014 Aresolution earnestly requesting for the Immediate Passage of

Senate Bill No. 612

MAY 23, 2014 039-2014 Award the procurement from PR. No. 021-S14 to the lowest complying

bidder Caraga Plumbing Concepts in the amount of ₱107,700.00

MAY 23, 2014 040-2014 A resolution authorizing Mr. Isagani R. Pradillada, General Manager to

renew the services of one (1) Security Officer from Rapidfire Security

and Investigation Agency

MAY 23, 2014 041-2014 Fund for attending the Water Supply Materials Selection and Quality

Assurance Seminar

MAY 23, 2014 042-2014 A resolution approving the New Organizational Structure, Staffing

Pattern, Position Classification, Reclassification,Transfer of Positions,

Creation, Abolition of Positions and Other Related Matters of a Category

"C" Water District Duly Approved in March 2012

MAY 23, 2014 043-2014 A resolution committing to provide Equity for KfW Project in

the amount of ₱4,494,000.00

MAY 23, 2014 044-2014 Resolution adopting and committing the implementation of Capital

Expenditure Programs for 2014-2023 for the improvement and

expansion of Infanta (Quezon) Water Supply System

JUNE 11, 2014 045-2014 A resolution authorizing Mr. Isagani R. Pradillada, General Manager to

sign for and in behalf of Infanta (Quezon) Water District the Contract to

purchase of Real Property from Julita Sabeduria and Epimaco S. Adornado

JUNE 11, 2014 046-2014 ₱237, 898.00 estimated amount allocation for the procurement


JUNE 11, 2014 047-2014 ₱3,186.60 Payment for STAWD Annual Dues for 2014

(# of active service connections ending Dec. 2013)

JUNE 27, 2014 048-2014 ₱5,000.00 Donation to Alicia Water District & Php 5,000.00 Donation to

Cabuyao Water District

JUNE 27, 2014 049-2014 ₱196,000.00 Estimated Amount Allocation for the Procurement


JUNE 27, 2014 050-2014 Award the procurement from PR. No. 026-S14 to the lowest complying

bidder Agusan Metro-Plumbers Supply in the amount of ₱273,140.00

JUNE 27, 2014 051-2014 Fund for Four(4) pcs. of External Harddrive

JULY 11, 2014 052-2014 A resolution approving Inclusion of one (1) unit of IQWD Well Driling

Project under the KFW Loan Package into one-bidding process to be

conducted by LWUA Bids and Awards Committee''

JULY 11, 2014 053-2014 A resolution approving the Re-Evaluation of Organization Structure and

Staffing Pattern of IQWD for Category "C" and in favor of Ms. Naida S.

Evasco to reclassify her position from Administration Services Assistant A

to Division Manager C, including the position of other concerned

employees

JULY 11, 2014 054-2014 Fund for the Two (2) Employees attending The Seminar-Workshop on

Water Rates Determination with Cash Flow Projection at University

Hotel, UP Diliman , Quezon City

JULY 11, 2014 055-2014 Fund for attending The GAD: Practical Policy Making with a Gender Lens

at Richville Hotel, Mandaluyong City

JULY 25, 2014 056-2014 ₱41,396.73 payment for IQWD's Annual Water Changes for Water

Permit No. 021514 at National Water Resources Board

JULY 25, 2014 057-2014 A resolution committing to attain the Key Performance Indicators

as presented in the Cash Flow Projection

AUG. 7, 2014 058-2014 ₱107,700.00 Estimated Amount Allocation for the Procurement


AUG. 7, 2014 059-2014 ₱115,995.00 Estimated Amount Allocation for the Procurement


AUG. 7, 2014 060-2014 A resolution approving request to retract or withdraw the submitted

documents on the Organizational Structure and Staffing Pattern for

Category "C" Water District for further evaluation of its responsiveness

to the community it served

AUG. 7, 2014 061-2014 A resolution requesting LWUA's Board of Trustees for the Approval/

Confirmation of the Provisional Water Rates of Infanta (Quezon) Water

District

AUG. 7, 2014 062-2014 Fund for attending the Seminar-Workshop on Government Procurement

Reform Act (RA 9184) at Camelot Hotel, No. 35 Mother Ignacia Ave.,

Diliman, Quezon City

AUG. 7, 2014 063-2014 ₱68,000.00 Fund for Two (2) Chlorinator

AUG. 7, 2014 064-2014 ₱35,988.00 Fund for Eight (8) Channel CCTV Camera

AUG. 22, 2014 065-2014 Policy for Empty Drums of Chlorine

AUG. 22, 2014 066-2014 Award the procurement from PR. No. 035-S14 to the lowest complying

bidder Rondex Enterprises in the amount of ₱102,000.00

AUG. 22, 2014 067-2014 Award the Procurement from PR. No. 036-S14 to the lowest complying

bidder Dibar Marketing in the amount of ₱102,984.30

SEPT. 12, 2014 068-2014 Repealing Resolution No. 44, Series 2014

SEPT. 12, 2014 069-2014 Adopting and Commiting the Implementation of Capital Expenditure

Programs for 2016-2023 for the Improvement & Expansion of Infanta

(Quezon) Water Supply System

SEPT. 12, 2014 070-2014 ₱139,326.00 Estimated Amount Allocation for the Procurement


SEPT. 12, 2014 071-2014 Fund for attending the 31st STAWD Annual Convention at the Bellevue

Hotel, Alabang MuntinLupa on November 13-14,2014

SEPT. 12, 2014 072-2014 ₱7,000.00 Fund for IQWD'S 1/4 Page Advertisement at Consumer

Asia Magazine

SEPT. 12, 2014 073-2014 ₱15,050.00 Fund for IQWD Employees Drug Test

SEPT. 12, 2014 074-2014 Policy for IQWD Employees using Prohibited Drugs

SEPT. 12, 2014 075-2014 A resolution authorizing Mr. Isagani R. Pradillada, General Manager to

concur for and in behalf of Infanta (Quezon)Water District the Letter of

LWUA about the Key Performance Indicators & WD Equity KFW PTWSSP III

SEPT. 12, 2014 076-2014 A resolution approving the bidding of Php 1,364,904.00 for the Drilling of

One (1) Exploratory / Production Well

SEPT. 12, 2014 077-2014 A board resolution extending the appointment of Mr. Isagani R. Pradillada

as General Manager of Infanta (Quezon) Water District while waiting

for the approval of MACRO

SEPT. 12, 2014 078-2014 A board resolution giving recognition to Engr. Mario G. Macatangay

SEPT. 17, 2014 079-2014 ₱276,307. 50 Estimated Amount Allocation for the Emergecy purchase

of Hi-Way Rehabilitation at Brgy. Ingas Infanta, Quezon

SEPT. 17, 2014 080-2014 Fund for the Two (2) Water Maintenance Man B's Seminar for Wells

and Pumps Maintenance in Quezon City on Oct .16-17,2014

SEPT. 26, 2014 081-2014 Re-alignment of Approved Budget for 2014

OCT. 7, 2014 082-2014 New Members of Bids and Awards Committee, Bac Secretariat

and Technical Working Group

OCT. 7, 2014 083-2014 A resolution authorizing the General Manager of Infanta (Quezon)

Water District to sign Financial Assistance Loan Agreement between

LWUA and IQWD

OCT. 7, 2014 084-2014 ₱210,000.00 Estimated Amount Allocation for the Procurement

from PR. No. 055-S14 & PR. No. 056-S14

OCT. 7, 2014 085-2014 A resolution to Local Water Utilities Administration requesting authority

to purchase Three (3) Motorcycles

OCT. 7, 2014 086-2014 ₱5,500.00 fund for IQWD's Inside Black & White Half (1/2) Page

Advertisement at PAWD Directory of Water Districts 2014-2015

OCT. 24, 2014 087-2014 A resolution to authorizing Mr. Isagani Pradillada ,General Manager to

sign for and in behalf of Infanta (Quezon)Water District the Contract

of right of entry with option to buy from Mrs. Shirley R. Astoveza

OCT. 24, 2014 088-2014 ₱299,605.00 Cost Allocation for the Procurement from PR. No. 058-S14

OCT. 24, 2014 089-2014 ₱107,700.00 Estimated Amount Allocation for the Procurement


OCT. 24, 2014 090-2014 A resolution approving the New Organizational Structure, Staffing Patern,

Position Classification, Reclassification, Transfer of Positions, Creation,

Abolition of Positions, and Other Related Matters of a Category "C"

Water District duly approved in March 2012

OCT. 24, 2014 091-2014 A Resolution to stop the Implementation of IQWD Provident Fund

effective October 2014

OCT. 24, 2014 092-2014 Approval of release of ₱349,657.45 as IQWD Provident Fund Interest

to be given to its members

NOV. 12, 2014 093-2014 Release of the remaining ( 1/2) of Employees 13th Month Pay & Cash Gift

NOV. 12, 2014 094-2014 ₱267,350.00 Estimated Amount Allocation for the Procurement


NOV. 12, 2014 095-2014 Award the procurement from PR. No. 058-S14 to the lowest complying

bidder Rondex Enterprises Corp. in the amount of ₱291,203.70


bidder The Alpha Enterprise in the amount of ₱72,000.00

NOV. 12, 2014 097-2014 ₱36,000.00 fund for 3,000 pcs. of IQWD's Calendar for 2015

NOV. 12, 2014 098-2014 A resolution appealing for reconsideration on Notice of Dissallowance

of IQWD Board of Directors Cash Gift and Bonuses for the month of

May 2011 and November 2011

NOV. 28, 2014 099-2014 Award the Procurement from PR. No. 029-S14 to the lowest complying

bidder Web Technology in the amount of ₱42,220.00

NOV. 28, 2014 100-2014 A resolution authorizing Mr. Isagani R. Pradillada, General Manager to

sign for and in behalf of Infanta (Quezon) Water District in securing

excavation permit from Department of Public Works and High-Ways

NOV. 28, 2014 101-2014 ₱127,500.00 Estimated Amount Allocation for the Procurement

from PR. NO. 065-S14


bidder Dibar Marketing in the amount of ₱241,151.80

NOV. 28, 2014 103-2014 Fund for Two (2) Employees attending the Philgeps Training for Phase 1

NOV. 28, 2014 104-2014 Fund for GM Pradillada's GACPA-STAWD Chapter Asset Management

Seminar

NOV. 28, 2014 105-2014 ₱5,500.00 fund for IQWD's Inside Black & White Half (1/2) Page

Advertisement at Aquarius Magazines 36th PAWD Convention Issue.

DEC. 9, 2014 106-2014 ₱168,750,000.00 Productivity Enhancement Incentive (PEI) for FY 2014

DEC. 9, 2014 107-2014 A resolution adopting the Memorandum Circular No.011-14

Implementing Guidelines on the Adjustment of Per Diems of Water

District Board of Directors and requesting for LWUA'S approval

DEC. 22, 2014 108-2014 A resolution authorizing Mr. Isagani R. Pradillada, General Manager to

sign for and in behalf of Infanta (Quezon) Water District the Contract

to proceed with the construction of one (1) exploratory production well

from R.S Superbatch Development Inc.

'DEC. 22, 2014 109-2014 Approval of 2015 Budget

*** NOTHING FOLLOWS ***

Amount

Current Assets:Cash

Cash - Collecting Officer P 94,732.56

Petty Cash Fund 10,000.00

Cash in Bank - Local Currency-LBP 1,080,415.87 Cash in Bank - Local Currency, S/Account-LBP-# 1991-0011-54 4,658,351.20

Cash in Bank - Local Currency, JS/Account-LBP-#1991-0132-76 936,389.58

Cash in Bank-Local Currency-S/A-The Express Bank #01-07443-2 -

Total P 6,779,889.21

Receivables Accounts

Accounts Receivable-Inactive P 516,080.21 Accounts Receivable 2,156,631.87

Less: Allowance for Doubtful Accounts 29,909.25

Total P 2,642,802.83

Other Receivables

Due from Officers & Employees 408,649.08

Receivables-Disallowance Charges -

Other Receivable 538,382.60 Total P 947,031.68

Inventories

Office Supplies Inventory P 39,948.75

Accountable Forms Inventory 117,363.30

Chemical & Filtering Supplies Inventory 62,400.00

Construction Materials Inventory 1,145,880.55

Other Inventory 21,860.00

Total P 1,387,452.60

Prepayments, Deposits and Deferred Charges

Prepaid Rents 43,500.00

Deferred Charges 529,714.46

Other Currents Assets 20,706.43

Total Current Assets P 12,351,097.21

Property, Plant & EquipmentLand and Other Improvements

Land P 4,456,109.00

Plant, Buildings and Structure

Plant (UPIS) P 52,337,323.78

Less: Acc. Depreciation 12,351,781.56 Total P 39,985,542.22

Equipment and Machinery

Office Equipment P 1,189,147.16

Less: Acc. Depreciation 764,577.09

Total P 424,570.07 Land Transportation Equipment P 347,200.00 Less: Acc. Depreciation 69,825.50 Total P 277,374.50 Other Machinery & Equipment 629,199.04

Less: Acc. Depreciation 296,618.23

Total P 332,580.81 Total P 1,034,525.38

Furniture, Fixtures and Books

Office Furnitures & Fixtures P 182,825.00

Less: Acc. Depreciation 119,635.17 Total P 63,189.83

Construction in Progress- Plant P 749,539.71

Total Property, Plant and Equipment P 46,288,906.14

Other Assets P 9,776,063.51 TOTAL ASSETS AND OTHER DEBITS P 68,416,066.86


Infanta, Quezon

BALANCE SHEET

December 31, 2014

ASSETS AND OTHER DEBITS

Previous Current YTD

CASH FLOW FROM OPERATING ACTIVITIES

Cash Inflows:

Collection of Water Bills P 2,674,914.89 P 2,397,024.48 P 31,361,341.28

Collection of Other Water Revenue 92,876.73 48,410.00 1,346,437.23

Refund of overpayment of expense & Cash Advances 17,744.00 7,946.00 113,321.26

Collection of Other Receivable 44,155.77 34,148.24 496,113.67

Sale of materials 116,161.50 85,485.68 907,057.05

Interest Income 2,399.94 3,685.65

Other Deferred Credits 598.00 119,078.75

Total Cash Inflows P 2,945,852.89 P 2,576,012.34 P 34,347,034.89

Cash Outflows:

Payment of of Operating Expenses:

Payroll P 803,851.67 P 680,528.20 P 6,676,021.42

Other Personnel Benefits 10,000.00 25,000.00 1,834,933.43

Fuel/Power for Pumping/Chemicals 351,056.41 351,133.63 4,290,242.38

Other Operation and Maint. Expenses 160,852.73 187,299.49 2,023,998.16

Repair & Maintenance 8,723.00 15,915.00 240,553.50

Official Cash Advances-Official Travel 44,910.00 21,510.00 409,109.00

Refund of payment-water bill 431.20 431.20

Payment of Payables 376,712.48 295,700.69 4,833,229.32

Purchase of office supplies Inventory 6,928.00

Purchase of Accountable Forms Inventory 32,915.04 28,965.24 160,949.59

Purchase of Construction Materials Inventory 2,480.00 94,518.00

Purchase of Other Inventory -

Payment of Prepaid Expense -

Remittance of GSIS/PAGIBIG/PHILHEALTH& Taxes 288,320.61 323,554.22 3,922,292.94

Total Cash Outflows P 2,077,773.14 P 1,932,086.47 P 24,493,206.94

Total Cash Provided (used) by Operating Activities P 868,079.75 P 643,925.87 P 9,853,827.95

CASH FLOWS FROM INVESTING ACTIVITIES

Cash Inflows:

Proceeds from Short-Term Investments

Subsidies from LGU/Barangays 76,103.14

Proceeds from sale of:

Office Equipment, Furniture and Fixtures

Transportation Equipment

Other Property, Plant and Equipment

Total Cash Inflows P - P - P 76,103.14

Cash Outflows:

Investments in Securities P P P

Purchase/construction of

Construction Work in Progress(Plant) 24,125.00 26,500.00 375,628.00

Plant (UPIS) 49,200.00

Buildings -

Office Equipment, Furniture and Fixtures 42,220.00 118,790.00

Transportation Equipment -

Other Property, Plant and Equipment 137,450.04

Mortgage Payable 35,479.31 36,436.10 416,496.48

Total Cash Outflows P 59,604.31 P 105,156.10 P 1,097,564.52

Total Cash Provided (used) by Investing Activities P (59,604.31) P (105,156.10) P (1,021,461.38)

CASH FLOWS FROM FINANCING ACTIVITIES

Cash Inflows:

Proceeds from Borrowings (Loans Payable)

Total Cash Inflows P - P - P -

Cash Outflows:

Cash payment of interest on loans payable& other finance charges 239,079.45 82,894.36 1,465,475.17

Payment of domestic and foreign loans 78,260.88 79,040.70 914,986.77

Other Deferred Charges 83,733.31

Total Cash Outflows P 317,340.33 P 161,935.06 P 2,464,195.25

Total Cash Provided (used) by Investing Activities P (317,340.33) P (161,935.06) P (2,464,195.25)

CASH PROVIDED BY OPERATING, INVESTING

AND FINANCING ACTIVITIES P 491,135.11 P 376,834.71 P 6,368,171.32

ADD: CASH AND CASH EQUIVALENTS - BEGINNING 5,911,919.39 6,403,054.50 411,717.89

CASH AND CASH EQUIVALENTS, ENDING P 6,403,054.50 P 6,779,889.21 P 6,779,889.21


Infanta, Quezon

CASH FLOW STATEMENT

For the month of December 31, 2014

Dr. Cr. Dr. Cr. Dr Cr.

102 Cash Collecting Officer 94,732.56 94,732.56

103 Working Fund 10,000.00 10,000.00

107 Cash in Bank-LC-LBP 1,080,415.87 1,080,415.87

107-1 Cash in Bank-SA-LBP 4,658,351.20 4,658,351.20

107-2 Cash in Bank-JSA-LBP 936,389.58 936,389.58

111 Accounts Receivable 2,156,631.87 2,156,631.87

111-1 Accounts Receivable-Inactive 516,080.21 516,080.21

135 Due from Officers & Emp. 408,649.08 408,649.08

136 Receivables-Disallowance Charges - -

149 Others Receivables 538,382.60 538,382.60

149-1 Others Receivables (Sales of Materials) - -

151 Office Supplies Inventory 39,948.75 39,948.75

151-1 Office Supplies Inv.(Acct. Forms) 117,363.30 117,363.30

158 Chemical & Filtering Supplies Intry. 62,400.00 62,400.00

168 Const. Matls. Inventory 1,145,880.55 1,145,880.55

169 Other Inventory 21,860.00 21,860.00

171 Prepaid Rent 43,500.00 43,500.00

177 Guaranty Deposits - - -

189 Deferred Charges 529,714.46 529,714.46

201 Land 4,456,109.00 4,456,109.00

203 Utility Plant in Service 52,337,323.78 52,337,323.78

303 Accum. Depreciation 12,351,781.56 12,351,781.56

207 Office Equipment 1,189,147.16 1,189,147.16

307 Accum. Depreciation 764,577.09 764,577.09

214 Land Transport Equipment 347,200.00 347,200.00


225 Other Machinery & Equipment 629,199.04 629,199.04


226 Furnitures and Fixtures 182,825.00 182,825.00


243 Const. In Progress-Plant (UPIS) 749,539.71 749,539.71

279 Other Assets 9,776,063.51 9,776,063.51

279-1 Other Current Assets 20,706.43 20,706.43

301 Allow. for Doubtful Account 29,909.25 29,909.25

401 Accounts Payable 132,898.00 132,898.00

406 Interest Payable 236,058.66 236,058.66

412 Due to BIR 280,909.03 280,909.03

413-1 Due to GOCC-GSIS 70,287.15 70,287.15

413-2 Due to GOCC-PAGIBIG 69,066.88 69,066.88

413-3 Due to GOCC-PHILHEALTH 14,353.50 14,353.50

423 Due to Officers and Employees - -

423-1 Due to Off. & Emp. Profund EE - -

423-2 Due to Off. & Emp. Profund BOD 480.00 480.00

423-3 Due to Officer & Emp. Loans - -

423-4 Due to Officer & Emp. Loans BOD (0.01) (0.01)

429 Others Payable 126,188.74 126,188.74

429-1 Others Payable-Barangay 261,043.20 261,043.20

431 Mortgage Payable 2,986,270.44 2,986,270.44

433 Loans Payable-Domestic 11,633,562.34 11,633,562.34

434 Current Portion on Long Term Debt - -

459 Other Deffered Credits 8,718.00 8,718.00

471 Government Equity 76,000.00 76,000.00

479 Donated Capital (OPIC) 169,644.54 169,644.54

481 Retained Earnings 40,622,703.37 40,622,703.37

Sub-Total 82,048,413.66 70,320,530.64 82,048,413.66 70,320,530.64


Working Paper

December 31, 2014

A/C Account NameTrial Balance Income Statement Balance Sheet

Amount Amount

Current Assets:Cash

Cash - Collecting Officer P 72,336.12 P 94,732.56

Petty Cash Fund - 10,000.00

Cash in Bank - Local Currency-LBP 190,767.95 1,080,415.87 Cash in Bank - Local Currency, S/Account-LBP-# 1991-0011-54 50,399.04 4,658,351.20

Cash in Bank - Local Currency, JS/Account-LBP-#1991-0132-76 61,270.47 936,389.58

Cash in Bank-Local Currency-S/A-The Express Bank #01-07443-2 36,944.31 -

Total P 411,717.89 P 6,779,889.21

Receivables Accounts

Accounts Receivable-Inactive P 516,080.21 P 516,080.21 Accounts Receivable 1,014,910.22 2,156,631.87

Less: Allowance for Doubtful Accounts 29,909.25 29,909.25

Total P 1,501,081.18 P 2,642,802.83

Other Receivables

Due from Officers & Employees 401,541.58 408,649.08

Receivables-Disallowance Charges 330.00 -

Other Receivable 382,084.46 538,382.60 Total P 783,956.04 P 947,031.68

Inventories

Office Supplies Inventory P 62,017.50 P 39,948.75

Accountable Forms Inventory 61,722.87 117,363.30

Chemical & Filtering Supplies Inventory - 62,400.00

Construction Materials Inventory 1,198,683.49 1,145,880.55

Other Inventory - 21,860.00

Total P 1,322,423.86 P 1,387,452.60

Prepayments, Deposits and Deferred Charges

Prepaid Rents 43,500.00 43,500.00

Deferred Charges 55,000.00 529,714.46

Other Currents Assets 20,706.43 20,706.43

Total Current Assets P 4,138,385.40 P 12,351,097.21

Property, Plant & EquipmentLand and Other Improvements

Land P 4,456,109.00 P 4,456,109.00

Plant, Buildings and Structure

Plant (UPIS) P 50,098,825.10 P 52,337,323.78

Less: Acc. Depreciation 10,330,748.47 12,351,781.56 Total P 39,768,076.63 P 39,985,542.22

Equipment and Machinery

Office Equipment P 1,019,910.04 P 1,189,147.16

Less: Acc. Depreciation 638,386.17 764,577.09

Total P 381,523.87 P 424,570.07 Land Transportation Equipment P 322,200.00 P 347,200.00 Less: Acc. Depreciation 50,024.75 69,825.50 Total P 272,175.25 P 277,374.50 Other Machinery & Equipment 464,915.00 629,199.04

Less: Acc. Depreciation 189,019.01 296,618.23

Total P 275,895.99 P 332,580.81 Total P 929,595.11 P 1,034,525.38

Furniture, Fixtures and Books

Office Furnitures & Fixtures P 182,825.00 P 182,825.00

Less: Acc. Depreciation 109,217.17 119,635.17 Total P 73,607.83 P 63,189.83

Construction in Progress- Plant P 532,350.91 P 749,539.71

Total Property, Plant and Equipment P 45,759,739.48 P 46,288,906.14

Other Assets P 9,776,063.51 P 9,776,063.51 TOTAL ASSETS AND OTHER DEBITS P 59,674,188.39 P 68,416,066.86

See accompanying Notes to Financial Statement

CY 2014

(With Comparative Figures for CY 2013)

As of December 31, 2014

BALANCE SHEET

Infanta, Quezon


CY 2013

ASSETS AND OTHER DEBITS

LIABILITIES, EQUITY AND OTHER CREDIT ACCOUNTS

Current Liabilities:

Payable Accounts

Accounts Payable P 983,051.04 P 132,898.00

Notes Payable -

Total P 983,051.04 P 132,898.00

Inter-Agency Payables

Due to BIR P 532,335.49 P 280,909.03

Due to GOCC-GSIS 41,942.34 70,287.15

Due to GOCC- Pagibig 67,726.62 69,066.88

Due to GOCC-Philhealth 14,778.50 14,353.50

Total P 656,782.95 P 434,616.56

Other Payables

Due to Officer & Employee - -

Due to Officer & Employee (Prov. Fund-Employee) 18,420.08 -

Due to Officer & Employee (Prov. Fund-BOD) 2,064.00 480.00

Due to Officers & Emp. Profund Loans 54,244.03 -

Due to Officer & Emp. Profund Loans-BOD 2,433.99 (0.01)

Other Payable 126,188.74 126,188.74

Total P 203,350.84 P 126,668.73

Loans/Lease Payable

Current Portion on Long Term Debt -

Interest Payable 236,058.66 236,058.66

Total P 236,058.66 P 236,058.66

Total Current Liabilities P 2,079,243.49 P 930,241.95

Non - Current Liabilities

Loans Payable-Domestic-LWUA P 12,548,549.03 P 11,633,562.34

Mortgage Payable 3,402,766.92 2,986,270.44

Others Payable-Barangay 813,085.53 261,043.20

Total Non - Current Liabilities P 16,764,401.48 P 14,880,875.98

Total Liabilities P 18,843,644.97 P 15,811,117.93

Deferred Credits

Other Deffered Credits P 6,000.00 P 8,718.00

Equity

Government Equity, Beginning P 76,000.00 P 76,000.00

Add(Deduct) :

Donated Capital (OPIC) P P 169,644.54

Retained Earnings P 35,203,354.43 P 40,622,703.37

Net Income (Loss) 5,822,356.61 11,727,883.02

Prior Years' Adjustments 277,167.62

Total Equity P 40,824,543.42 P 52,596,230.93

TOTAL LIABILITIES, EQUITY AND OTHER CREDIT ACCOUNTS P 59,674,188.39 P 68,416,066.86

- -



CY 2013 CY 2014


Infanta, Quezon

BALANCE SHEET


CY 2013 CY 2014

INCOME

576 Gen., Trans., & Dist. Income (Water Sales) P 27,159,638.68 P 31,605,486.24

612 Interest Income 180.17 3,685.65

618 Other Business Income 1,804,118.86 2,065,475.06

619 Fines & Penalties-B/Income 1,005,278.95 1,224,892.60

649 Grants & Donations

TOTAL INCOME P 29,969,216.66 P 34,899,539.55

LESS: EXPENSES

701 Salaries & Wages-Regular 6,481,828.65 6,283,972.40

710 Representation Allowance 60,000.00 60,000.00

711 Transportation Allowance 60,000.00 60,000.00

712 Clothing/Uniform Allowance 140,000.00 170,000.00

713 Honoraria 472,560.00 547,078.82

714 Year End Bonus 820,565.00 794,905.50

719 Other Bonuses & Allowances 1,095,000.00 566,000.00

721 Life & Ret. Insurance Contr. 675,621.44 610,658.11

722 Pagibig Contributions 131,203.90 21,147.52

723 Philhealth Contributions 66,312.50 61,151.70

724 EC Contributions 41,900.00 39,600.00

725 Provident Fund Contribution 112,603.58 77,288.81

725-1 Provident Fund Contribution-BOD 9,372.00 7,062.00

737 Vacation & Sick Leave Benefits 459,860.53 493,811.39

749 Other Personnel Benefits -OTP 634,132.48 538,458.80

751 Office Supplies Expense 294,704.10 221,332.25

751-1 Office Supplies Expense (Accountable Forms) 26,497.23 115,582.53

757 Fuel, Oil and Lubricants Expense 79,585.25 216,462.67

759 Maintenance Supplies Expense - 13,715.00

766 Travel Expense 429,280.50 448,908.71

767 Training & Scholarship Expenses 367,949.29 341,600.00

768 Water 15,730.67 18,900.77

769 Electricity 256,540.42 226,064.15

772 Postage & Deliveries 4,024.00 3,435.00

773 Telephone Expense-Landline 51,913.89 41,047.95

774 Telephone Expense-Mobile 20,740.00 19,095.00

775 Internet Expense 12,629.00 12,436.00

778 Advertising, Promotional & Marketing Expenses 12,190.00 49,721.00

779 Taxes, Duties & Licenses 614,762.27 727,526.61

781 Insurance Premiums 35,752.57 46,017.27

782 Representation Expense 302,684.11 150,813.00

786 Rent Expense 156,125.00 84,000.00

792 Generation, Trans. & Dist. Exp. 4,606,156.30 4,835,013.93

796 Membership Dues & Contr. to Org. 10,249.80 10,926.60

803 Repair & Maint.-Plant (UPIS) 579,663.74 426,682.63

807 Repair & Maint. -Office Equip. 23,744.00 68,000.00

807-1 Repair & Maint.-IT/Equip. - 2,900.00

814 Repair & Maint.-Land Trans. Equip. 55,115.70 69,445.50

825 Repair & Maint.-Other Machinery & Equipment - 17,516.00

841 Donations 50,290.00 39,809.00

842 Legal Services 25,600.00 13,100.00

843 Auditing Services - -

846 Security Services - 110,500.00

903 Depreciation Exp.-Plant (UPIS) 1,905,946.47 2,021,033.09

907 Depreciation Exp.-O/Equip. 116,214.98 126,190.92

907-1 Depreciation Exp.-IT E/Software 6,622.20 -

914 Depreciation Exp.-Land Trans. Equip. 15,132.00 19,800.75

925 Depreciation Exp.-Other Machinery & Equip. 86,643.55 107,599.22

926 Depreciation Exp.-Furniture & Fixtures 15,126.94 10,418.00

989 Other Maint. & Opting. Exp. 1,578,184.10 1,197,305.90

991 Bank Charges 2,200.00 -

996 Interest Expense 1,127,901.89 1,027,622.03

TOTAL EXPENSES P 24,146,860.05 P 23,171,656.53

NET (LOSS) INCOME P 5,822,356.61 P 11,727,883.02



DETAILED STATEMENT OF INCOME & EXPENSES



Cash Inflows:

Collection of Water Bills P 27,545,961.10 P 31,361,341.28

Collection of Other Water Revenue 1,293,751.59 1,346,437.23

Refund of overpayment of expense & Cash Advances 155,727.02 113,321.26

Collection of Other Receivable 462,151.84 496,113.67

Sale of materials 663,817.31 907,057.05

Interest Income 180.17 3,685.65

Other Deferred Credits 84,845.00 119,078.75

Collection of Receivable Disallowance 28,968.00

Total Cash Inflows P 30,235,402.03 P 34,347,034.89

Cash Outflows:

Payment of of Operating Expenses:

Payroll P 7,231,945.57 P 6,676,021.42

Other Personnel Benefits 1,688,865.93 1,834,933.43

Fuel/Power for Pumping/Chemicals 4,315,079.79 4,290,242.38

Other Operation and Maint. Expenses 2,644,226.08 2,023,998.16

Repair & Maintenance 308,701.62 240,553.50

Official Cash Advances-Official Travel 679,662.75 409,109.00

Refund of payment-water bill/secvice connection fee 1,902.72 431.20

Payment of Payables 4,899,982.19 4,833,229.32

Purchase of office supplies Inventory 62,223.00 6,928.00

Purchase of Accountable Forms Inventory 80,181.52 160,949.59

Purchase of Construction Materials Inventory 145,592.00 94,518.00

Payment of Prepaid Expense 149,625.00 -

Remittance of GSIS/PAGIBIG/PHILHEALTH& Taxes 3,784,508.19 3,922,292.94

Total Cash Outflows P 25,992,496.36 P 24,493,206.94

Total Cash Provided (used) by Operating Activities P 4,242,905.67 P 9,853,827.95

CASH FLOWS FROM INVESTING ACTIVITIES

Cash Inflows:

Proceeds from Short-Term Investments

Subsidies from LGU/Barangays 76,103.14

Total Cash Inflows P - P 76,103.14

Cash Outflows:

Investments in Securities P P

Purchase/construction of

Construction Work in Progress(Plant) 1,123,493.31 375,628.00

Plant (UPIS) 34,000.00 49,200.00

Buildings -

Office Equipment, Furniture and Fixtures 56,420.00 118,790.00

Transportation Equipment 102,235.84 -

Other Property, Plant and Equipment - 137,450.04

Mortgage Payable 380,751.39 416,496.48


Total Cash Provided (used) by Investing Activities P (1,696,900.54) P (1,021,461.38)

CASH FLOWS FROM FINANCING ACTIVITIES

Cash Inflows:

Proceeds from Borrowings (Loans Payable)

Total Cash Inflows P - P -

Cash Outflows:

Cash payment of interest on loans payable& other finance charges 1,369,025.42 1,465,475.17

Payment of domestic and foreign loans 951,913.51 914,986.77

Other Deferred Charges 32,490.00 83,733.31


Total Cash Provided (used) by Investing Activities P (2,353,428.93) P (2,464,195.25)

CASH PROVIDED BY OPERATING, INVESTING

AND FINANCING ACTIVITIES P 192,576.20 P 6,368,171.32

ADD: CASH AND CASH EQUIVALENTS - BEGINNING 229,141.69 411,717.89

CASH AND CASH EQUIVALENTS, ENDING P 421,717.89 P 6,779,889.21



Infanta, Quezon

CASH FLOW STATEMENT



CASH FLOW FROM OPERATING ACTIVITIES CY 2013 CY 2014

ACCOUNT NOS. P 190,767.95 P 1,080,415.87

50,399.04 4,658,351.20

61,270.47 936,389.58

36,944.31

TOTAL CASH IN BANK P 339,381.77 P 6,675,156.65

ADD: CASH ON HAND P 72,336.12 P 94,732.56

CASH BALANCE P 411,717.89 P 6,769,889.21

PETTY CASH FUND P 10,000.00 P 10,000.00

TOTAL CASH BALANCE P 421,717.89 P 6,779,889.21

0.00 -



Infanta, Quezon

CASH FLOW STATEMENT



SUMMARY OF CASH BALANCE

INFANTA (QUEZON) WATER DISTRICT Infanta, Quezon

NOTES TO FINANCIAL STATEMENTS As of December 31, 2014

(With Comparative figures for 2013)

AGENCY BACKGROUND Infanta (Quezon) Water District is classified as small (category D) water district. Its formation was in accordance with Presidential Decree (P.D.) 198 as amended, known as the Provincial Water Utilities Act of 193. Certificate of Conformance No. 229 was awarded to the district which entitles her, all rights and privileges to operate, as authorized by P.D. 198. The agency has three (3) operating deep wells that serve to 5,816 active and metered concessionaires. It has an average monthly water sales of P 2,633,790.52 with twenty six (33) personnel complement and five (5) Board of Directors and (1) sixth member. The Local Water Utilities Administration (LWUA) provides regulatory services and technical advisory to the district when needed.

1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Method of Accounting The District uses accrual basis of accounting, and transactions are recorded on a double entry method. The accounts classification conforms with the accounts prescribed by the Commercial Practices System (CPS) - New Government Accounting System (NGAS) modified accounts. The district has adapted it with the approval of the Board of Directors.

2. CASH

The Cash-Collecting Officer amounting to P 94,732.56 was deposited on January 5, 2015 and the reserve fund is equivalent to 3% of the gross sales. These are mandatory reserves required by LWUA to the water district.

Cash consists of the following: CY 2013 CY 2014

Cash-Collecting Officer 72,336.12 94,732.56 Cash in Bank: Petty Cash Fund LBP – CA # 1992-1036-51 190,767.95 1,080,415.87 LBP – SA # 1991-0011-54 50,399.04 4,658,351.20 LBP – JSA # 1991-0132-76 61,270.47 936,389.58 36,944.31

TOTAL 411,717.89 6,769,889.21

3. RECEIVABLES CY 2013 CY 2014

Accounts Receivable - Customer (Active) 1,530,990.43 2,672,712.08

Accounts Receivable - Others 382,414.46 538,382.60

Total Accounts Receivables 1,913,404.89 3,211,094.68

Less: Allow. for Doubtful Accounts

29,909.25

29,909.25

Total 1,883,495.64 3,181,185.43

Due from Officers & Employees 401,541.58 408,649.08

T O T A L 2,285,037.22 3,589,834.51

Out of the amount of P538,382.60 of Accounts Receivable-Others, receivables totaling to P 227,937.59 are subject of a request with the Commission on Audit for writing off, the latest communication was mailed on June 29, 2006, informing the Regional Cluster Director, Legal and Adjudication Sector, Commission on Audit, Region IV, that the request for additional requirements is beyond compliance due to the fact that records/documents were destroyed and inundated during Typhoon Winnie on November 29, 2004.

4. MATERIALS AND SUPPLIES INVENTORY CY 2013 CY 2014 Materials and Supplies Inventory P 1,322,423.86 P 1,387,452.60

Materials and Supplies Inventory are valued at cost and determined on a First-In-First-Out (FIFO) Method. For inventory purposes, the Perpetual Inventory System is being used to record purchases, which include water meters purchased at cost which when not yet issued are treated as Inventory and are not subject to depreciation. On the other hand, issued water meters are lodged under UPIS and are subject to depreciation.

5. PREPAYMENTS CY 2013 CY 2014 Prepaid Rental P 43,500.00 P 43,500.00

Prepayments of P43,500.00 represents the advance deposit for three (3) months and two (2) month advance rental on the office space being occupied by the water district.

6. PROPERTY, PLANT AND EQUIPMENT The account includes assets of relatively permanent character used in the normal utility operation of the water district. The breakdown of this account is as follows:

CY 2013 CY 2014

Land 4,456,109.00

4,456,109.00

Plant (Utility Plant in Service) 50,098,825.10 52,337,323.78 Less: Accum. Depreciation 10,330,748.47 12,351,781.56

Total 39,768,076.63 39,985,542.22

Office Equipments 1,019,910.04 1,189,147.16 Less: Acc. Depreciation 638,386.17 764,577.09

Net Office Equipments 381,523.87 424,570.07

Other Property, Plant & Equipment 464,915.00 629,199.04 Less: Acc. Depreciation 189,019.01 296,618.23

Net Other Property, Plant & Equipment 275,895.99 332,580.81

Trans. Equip./Motor Vehicle 322,200.00 347,200.00 Less: Acc. Depreciation 50,024.75 69,825.50

Net Trans. Equip./Motor Vehicle 272,175.25 277,374.50

7. CONSTRUCTION WORK IN PROGRESS CY 2013 CY 2014 Construction Work- In Progress Agency Assets P 532,350.91 P 749,539.71

This account is usually booked to Water System and Structures upon completion of a specific project.

8. OTHER ASSETS

Other assets amounting to P 9,776,063.51 was obtained when the WD’s books of accounts was reconstructed after the calamity. It was subject for our request for write-off with COA.

9. CURRENT LIABILITIES CY 2013 CY 2014

Accounts Payable 983,051.04 132,898.00 Pagibig Fund Payable 67,726.62 69,066.88 Philhealth Payable 14,778.50 14,353.50

GSIS Payable

41,942.34 70,287.15

Withholding Tax Payable 532,335.49

280,909.03 Others Payable 203,350.84 126,668.73

T O T A L 1,843,184.83 694,183.29

Accounts Payables are payables to various suppliers used for the rehabilitation of existing water supply and expansion of water supply to various barangays.

Due to GSIS, PAGIBIG and PHILHEALTH represent the premiums as of December 31, 2014, were remitted on January 2015 in its particular schedule of due dates.

Due to BIR represents the unremitted tax withheld from both suppliers and

employees as of December 31, 2014, were remitted on January 10, 2015. Others Payables-Barangay P 261,043.20 under Non-current Liabilities are payables

to various Barangay, Local Governments of Infanta, Quezon for labor and materials used in the expansion and/or rehabilitation of water supply which was shouldered in advance by said barangays as per Memorandum of Agreement/s signed with the Water District.

10. LONG TERM LIABILITIES The amount of P11,633,562.34 are various loan account balance from LWUA.

Loans Acct. No. Date Released Maturity Date Interest Rate Loan Outstanding Per Annum

LA# 3-339 RL Oct. 1991 Oct. 2017 8.5% P 84,403.63 LA# 3-527 RL Dec., 1998 Dec. 2024 10.5% 2,918,536.29 LA# 3-527 SL Dec. 2004 Dec. 2024 8.5% 724,222.34 LA# 4-2612 RL Dec. 2010 Dec. 2020 9.5% 3,827,536.00 LA# 9-0065 NLIF July 2009 Aug. 2032 0 % 4,079,176.00 Total P 11,633,874.26

11. EQUITY CY 2013 CY 2014

Government Equity P 76,000,00 P 76,000.00

The amount of P 76,000.00 represents capital contributions from the LGU of Infanta prior to the creation, formation and operation of the Infanta (Quezon) Water District.

CY 2013

CY 2014

Government Equity P 76,000.00 P 76,000.00 Add (Deduct) Donated Capital (OPIC) 169,644.54 Retained Earnings 35,203,354.43 40,748,543.42 Net (Loss) Income 5,822,356.61 11,727,883.02 Prior Years’ Adjustments ( 277,167.62) ( 125,840.05)

Total Equity P40,824,543.42 P 52,596,230.93

F. SUMMARY OF LOAN PAYMENT TO LWUA 2014

SOFT REGULAR TOTAL

LOAN LOAN AMORTIZATION

January 19,241.00 8,980.00 111,367.00 139,588.00

February 19,241.00 8,980.00 111,367.00 139,588.00

March 19,241.00 8,980.00 111,367.00 139,588.00

April 19,241.00 8,980.00 111,367.00 139,588.00

May 19,241.00 8,980.00 111,367.00 139,588.00

June 19,241.00 8,980.00 111,367.00 139,588.00

July 19,241.00 8,980.00 111,367.00 139,588.00

August 19,241.00 8,980.00 111,367.00 139,588.00

September 19,241.00 8,980.00 111,367.00 139,588.00

October 19,241.00 8,980.00 111,367.00 139,588.00

November 19,241.00 8,980.00 111,367.00 139,588.00

December 19,241.00 8,980.00 111,367.00 139,588.00

TOTAL 230,892.00 107,760.00 1,336,404.00 1,675,056.00

MONTHLY

AVERAGE 19,241.00 8,980.00 111,367.00 139,588.00

NLIFMONTH

35

G. WATER RATES

Meter

Size

0-10 11 - 20 21 - 30 31 - 40 41 - up

Residential/Gov't 1/2" 248.00 27.05 29.90 33.85 36.05

Full Commercial 1/2" 496.00 54.10 59.80 67.70 72.10

1" 1,587.20 54.10 59.80 67.70 72.10

Commercial A 1/2" 434.00 47.34 52.33 59.24 63.09

Commercial B 1/2" 372.00 40.58 44.85 50.78 54.08

Commercial C 1/2" 310.00 33.81 37.38 42.31 45.06

Category Minimum

Commodity Charges per cubic meter

36

H. SUMMARY OF WATER PRODUCTION AND CONSUMPTION 2014

PRODUCTION CONSUMPTION

(CUBIC METER) (CUBIC METER)

January 129,726 86,019

February 132,005 74,432

March 121,680 73,673

April 137,164 83,938

May 123,772 91,226

June 131,353 93,403

July 135,984 89,520

August 136,211 93,171

September 140,182 88,227

October 130,806 86,101

November 138,832 90,321

December 133,333 82,316

TOTAL 1,591,048 1,032,347

MONTH

37

I. AGENCY WATER SOURCE

Total

Rated

Capacity

1. Pump Station No. 2 Bgy. Agos-Agos, Infanta, Quezon 10 lps

2. Pump Station No. 3 Bgy. Ilog, Infanta, Quezon 34 lps

3. Pump Station No. 4 Bgy. Pilaway, Infanta, Quezon 17 lps

NAME LOCATION

38

J. SERVICE CONNECTION GROWTH 2014

NUMBER OF

CONNECTION

January 23

February 37

March 48

April 48

May 50

June 67

July 64

August 36

September 37

October 38

November 44

December 41

TOTAL 533

AVERAGE 44

MONTH

39

K. SUMMARY OF NON-REVENUE WATER 2014

CONSUMPTION

(CUBIC METER)

January 37

February 44

March 40

April 39

May 26

June 29

July 34

August 32

September 37

October 34

November 35

December 38

TOTAL 425

AVERAGE 35.42

MONTH

39

L. LIST OF MAJOR EQUIPMENTS

Item Qty. Unit Particulars Total Amount

1 1 piece Aircon 17,950.00

2 1 unit Welding Machine 15,000.00

3 1 unit Aircon-Carrier 22,248.04

4 2 unit Computer Monitor 15,000.00

5 3 sets Computer with accessories 79,325.00

6 3 pcs. Computer Printer 10,500.00

7 2 pcs. Computer CPU 45,080.00

8 1 set Epson Printer for billing 29,500.00

9 1 piece Computer Printer 3,570.00

10 2 sets Computer with accessories 53,600.00



13 1 piece Bundy Clock 4,700.00

14 1 piece Check Writer 6,700.00

15 1 piece Typewriter 9,000.00

16 1 set Computer set w/ accessories 24,708.00

17 1 piece Computer Monitor 5,340.00




21 1 unit Fax Machine 7,990.00

22 1 unit HP Printer P1102 4,700.00

23 1 unit Laptop lenovo 35,000.00

24 1 unit Computer set w/ accessories 55,000.00

25 1 unit Camera 5,995.00

26 1 unit Projector 20,500.00

27 1 unit Check Writer 20,000.00

28 1 unit Computer CPU 19,700.00

29 1 unit Printer HP 4,400.00

30 1 unit Computer Monitor 2,700.00

31 4 unit External Hard Drive 12,780.00

32 1 unit Digital Copier 60,500.00

33 1 unit Digital Camera 5,500.00

34 1 unit Biometric 7,500.00

35 1 unit CCTV 42,220.00

36 3 unit Wave 100 144,300.00

37 2 unit Tricycle Side Car 50,000.00

38 2 unit Kawasaki Barako 175 152,900.00

39 1 set Water testing Equipment 220,000.00

40 1 set Water Treatment 53,000.00

41 1 unit Dosing Pump (Chlorinator) 94,250.00

42 3 unit Iwaki Metering Pump (Chlorinator) 102,000.00

43 1 unit Power Production Equipt. 35,080.04

41

M. SUMMARY OF BACTERIOLOGICAL ANALYSIS FOR THE YEAR 2014

SAMPLE NUMBER NUMBER

TAKEN OF NEGATIVE OF POSITIVE

RESULT RESULTS

JANUARY 10 10 0

FEBRUARY 10 10 0

MARCH 10 10 0

APRIL 10 10 0

MAY 9 9 0

JUNE 9 9 0

JULY 10 10 0

AUGUST 10 10 0

SEPTEMBER 10 10 0

OCTOBER 10 10 0

NOVEMBER 9 9 0

DECEMBER 9 9 0

TOTAL 116 116 0

MONTH

42

1 - SERVICE CONNECTION DATA:

1.1 Total Services 6,522 1.6 Changes: New 41

1.2 Total Active 5,816 Reconnected 20

1.3 Total Metered 5,816 Disconnected ™ 20

1.4 Total Billed 5,755 Inactive 706

1.5 Population Served 31,988 1.7 Customer in Arrears:

Number _____

2 - PRESENT WATER RATES: Effective - April 2011

LWUA Approved? yes No Provisional Water Date Approved --- October 24, 2013

Rates Effectivity Date --- December 2013

No of Minimum

Conns. Charge

Domestic/Government 5,398 248.00 27.05 29.90 33.85 36.05

Commercial/Industrial 418 496.00 54.10 59.80 61.70 72.10

Bulk/Wholesale NA NA NA NA NA

Total Active 5,816

3 - BILLING AND COLLECTION DATA:

3.1 Billing (Water Sales) This Month Year-To-Date

( TM ) ( YTD)

a. Current (Metered) P 2,591,657.77 P 31,605,486.24

b. Current (Flat Rate) NA NA

c. Penalty Charges 106,648.72 1,224,892.60

d. Account Receivable Beg. NA 1,530,990.43

Total P 2,698,306.49 P 34,361,369.27

3.2 Collections (Water Sales)

a. Current Account P 1,483,987.34 18,941,546.67

b. Arrears (Current Year) 929,738.69 11,681,171.95

c. Arrears (Previous Year) 1,079,954.84

Total P 2,413,726.03 31,702,673.46

(3.2.a)

3.3 On Time Paid, This Month = x 100 = 57.26%

Collection Effeciency, YTD = x 100 = 89.12%

Collection Ratio, YTD = x 100 = 92.26%

4 - FINANCIAL DATA:

This Month Year-To-Date

4.1 Revenue ( TM ) ( YTD)

a. Operating P 2,698,306.49 P 32,830,378.84

b. Non-Operating 146,545.58 2,069,160.71

Total P 2,844,852.07 P 34,899,539.55

MONTHLY DATA SHEET

CCC # 229

For the month of December 31, 2014

Infanta (Quezon) Water District

3.2 Total

3.1 Total

Commodity Charges

(3.1.a) + (3.1.b)

(3.2.a) + (3.2.b)

3.1 Total

x

-- 2 --

4.2 Expenses: This Month Year-To-Date

( TM ) ( YTD)

a. Salaries & Wages P 508,390.00 P 6,283,972.40

b. Pumping Cost (Electricity )

c. Chemicals (Treatment)

d. Pumping Cost (Fuel & Oil )

e. Other Operating &Maintenance Expense P 718,452.50 P 8,740,306.19

f. Depreciation Expense 195,545.40 2,284,741.98

g. Interest Expense 81,115.38 1,027,622.03

Total P 1,882,537.10 P 23,171,656.53

4.3 Net Income (Loss) P 962,314.97 P 11,727,883.02

4.4 Cash Flow Report

a. Receipts P 2,576,012.34 P 34,423,138.03

b. Disbursement 2,199,177.63 28,054,966.71

c. Net Receipt (Disbursement) 376,834.71 6,368,171.32

d. Cash Balance, Beginning 6,403,054.50 411,717.89

e. Cash Balance, Ending P 6,779,889.21 P 6,779,889.21

4.5 Miscellaneous Financial Data

a. Loan Funds c. Inventories P 1,387,452.60

1. Cash on Hand P NA d. Accts. Rec'ble

2. Cash in Bank NA CustomerActive P 2,156,631.87

Total P NA e. Accts. Rec'ble

Cust.-Inactive P 516,080.21

b. Water District Funds f. Other Assets P 9,776,063.51

1. Cash on Hand P 94,732.56 g. Loans Payable

2. Cash in Bank 5,738,767.07 LWUA P 11,633,562.34

3. Investment NA h. Accts. Payable

4. Working Fund 10,000.00 Suppliers P 132,898.00

5. Reserves 936,389.58 i. Mortgage Payable P 2,986,270.44

Total P 6,779,889.21 j. Other Long Term

Debts P 261,043.20

5 - WATER PRODUCTION DATA:

5.1 Source of Supply Number Basis of Data

a. Wells 3 10 & 17 & 34 LPS /cu m/mo. Pump Rating

b. Springs NA NA NA

c. Surface NA NA NA

Total 3

5.2 Water Production This Month Year-To-Date Method of

Measurement

a. Pumped 133,333 Cu. M3 1,598,837 Cu. M3 Flow Meter

b. Gravity

c. Total 133,333 Cu. M3 1,598,837 Cu. M3 Flow Meter

5.3 Water Production Cost

a. Total Power Consumption for Pumping 33,502.8

b. Total Power Cost for Pumping P 350,009.52

c. Other Energy Cost for Pumping P

d. Total Pumping Hours (Motor Drive) 24

e. Total Pumping Hours (Engine Drive) 24

f. Total Gas Chlorine Consumed NA

g. Total Powder Chlorine Consumed NA

h. Total Chlorine Cost P 35,900.00

i. Total Cost of Other Chemicals P NA

Total Rated

Capacity

379,033.82 4,835,013.93 P P

-- 3 --

5.4 Accounted Water Use

a. Metered Billed 82,302 m. 1,030,659

b. Unmetered Billed NA m. NA

c. Total Billed (5.4a + 5.4b) 82,302 m. 1,030,659

d. Metered Unbilled NA m. NA

e. Unmetered Unbilled 340 m. 604

f. Total Accounted 82,642 m. 1,031,263

Total (5.4c + 5.4d +5.4a) 82,642 1,031,263

5.5 Water Use Assestment

a. Average Monthly Consumption/Connection cu.m. 14.30

b. Average per Capita/Day Consumption NA

5.4 f

c. Accounted Water x 100 = 65%

5.2 c

5.4c

d. Revenue Producing Water x 100 = 64%

5.2c

6 - MISCELLANEOUS DATA:

6.1 Employees

a. Permanent 31 Temporary 3 Total 34

Co-Terminus NA

b. No. of Connection per Employee 171

c. Average Monthly Salary/Employee 14,952.65

6.2 Bacteriological

a. Total Sample Taken 10

b. No. of Negative Result 10

c. Test Results submitted to LWUA 10

6.3 Chlorination

a. Total Sample Taken NA

b. No. of Sample Meeting Standard NA

c. No. of Days Full Chlorination Daily

6.4 Board of Directors This Month Year-To-Date

a. Resolution Approved 4 110

b. Policies Passed 1 2

c. Director's Fee Paid P 26,400.00 P 432,300.00

d. Meeting

1. Held (No.) 2 24

2. Regular (No.) 1 12

3. Special (No.) 1 12

7 - STATUS OF VARIOUS DEVELOPMENTS:

7.1 Status of Loans as of NA Loan/Fund

Committed Amount Percentile

Types of Loans/Fund

a. Early Action P NA P NA NA

b. Interim Improvement NA NA NA

c. Comprehensive NA NA NA

d. New Service Connection NA NA NA

e. BPW Funds NA NA NA

Total P NA P NA NA

Availments to Date

rizal street, infanta, quezonin early 1980, municipality of infanta and general nakar through their...

Documents