TAYSAN WATER DISTRICT

TAYSAN, BATANGAS

2017 BUDGET ASSUMPTIONS and JUSTIFICATIONS

WITH SUPPORTING SCHEDULE FOR BILLINGS, COLLECTIONS AND DISBURSEMENTS

I. Water Sales -pertains to Billings of Water deliveries to active consumers.

January 2017 to June 2017

Assumption:

Justification:

Res.

Comm'l

Comm'l A

Comm'l B

Comm'l C

Total

Projected Number of Service Connection 2017 is 3,603

No. of Conn. Beg.of JANUARY

3,505

3

8

-

138

3,654

Market growth is projected at an average of 21 SC per month.

Additional Conn. During THIS PERIOD

120

2

2

-

2

126

Number of SC year end 2016- 3,654

Dec 2016

June 2017

No. of Conn. end of JUNE

3,625

5

10

-

140

3,780

For Residential @ 20 SC/month;

3,505

3,625

Ave. No. of Connections/month

3,565

4

9

-

139

3,717

For Commercial A-C @ 1 SC/month ;

149

155

Average consumption -21 cu. M.

2012 WATER RATES APPLIES:

Ave.

Ave.

Min.

Ave.Rev./

TOTAL

Classification

Conn.

Cons.

Charge

11-20

21-30

31-40

over 40

Conn.

Billings

Residential

3,565

21

206.80

22.70

24.00

25.50

26.60

457.80

1,632,057.00

Commercial

4

21

413.60

45.40

48.00

51.00

53.20

915.60

3,662.40

Commercial A

9

21

361.90

39.73

42.00

44.63

46.55

801.15

7,210.35

Commercial B

-

310.20

34.05

36.00

38.25

39.90

-

UNDER

UNDER

Commercial C

139

21

258.50

28.38

30.00

31.85

33.25

572.25

79,542.75

PROJECTED

PROJECTED

Bulk Sales

-

620.40

68.10

72.00

76.50

79.80

-

INCOME STATEMENT

CASHFLOW

1,722,472.50

BILLINGS

COLLECTION

Projected Water Sales -

January 2017 to June 2017

(SIX MONTHS)

X 6

10,334,835.00

10,334,835.00

less:

0.30%

Senior Citizens' Discount

31,004.51

(31,004.51)

Net Water Sales

10,303,830.50

Multiply by Estimated Collection Efficiency

95%

Estimated Collection on Water Sales -

9,788,638.97

9,788,638.97

II.

Penalty Charges- This pertains to surcharge imposed by the District as penalty for

late payment at the rate of 10% beyond due date.

Fines & penalties on illegal connections are also included.

Projected Water Sales -

January 2017 to June 2017

10,303,830.50

Multiply by delinquency rate (on-time-paid 75%)

25%

Overdue Bills

2,575,957.62

Multilply by Penalty rate

10%

Projected Penalty Charges

257,595.76

257,595.76

Multiply by Estimated Collection Efficiency

95%

Estimated Collection from Penalty Charges

244,715.97

244,715.97

II. Collection of Prior Years Accounts Receivable-Customer:

10,561,426.26

10,033,354.94

Accounts Receivable -PY-

12/31/2016

or 1/1/2017

per MDS

1,971,897.89

less: Inactive accounts

-

Net AR-C - PY

1,971,897.89

1,676,113.21

Estimated Collection Ratio

Collection on prior period Accounts Receivable- Customer

1,676,113.21

10,561,426.26

11,709,468.15

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

PAGE 1

SUPPORTING COMPUTATION

252

-

3,654

434

#REF!

3,654

126

30

#REF!

based on LWUA cash flow of 72 sc a year

6

3,780

EVERY 10

EVERY 10

EVERY 10

EVERY 10

EVERY 10

l

10

10

1

3,565

206.80

227.00

24.00

-

457.80

677,986.75

4

413.60

454.00

48.00

915.60

47,895.00

9

361.90

397.25

42.00

-

801.15

2,162.55

-

-

-

3,297.20

139

258.50

283.75

30.00

-

572.25

686,229.75

-

-

-

48,410.00

731,341.50

2,162.55

3,297.20

144,969.00

128,115.05

128,677.35

401,761.40

694,472.75

48,925.00

2,162.55

3,297.20

2,220,298.50

8,083,532.00

10,033,354.94

385,741.21

45,509.58

-

JAN

FEB

MARCH

24,786.03

2,692.35

1,076.20

28,554.58

#REF!