|
TAYSAN WATER DISTRICT |
||||||||||||||||
|
TAYSAN, BATANGAS |
||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2017 BUDGET ASSUMPTIONS and JUSTIFICATIONS |
||||||||||||||||
|
WITH SUPPORTING SCHEDULE FOR BILLINGS, COLLECTIONS AND DISBURSEMENTS |
||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected Billings and Collection of Water Sales & Penalty Charges |
|
|
|
|
|
|
|
|
|
|||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
July 2017 to Dec 2017 |
|
|
|
Justification: |
|
|
Res. |
Comm'l |
Comm'l A |
Comm'l B |
Comm'l C |
Total |
|||
|
|
|
|
|
|
|
|
No. of Conn. Beg.of July |
|
3,625 |
5 |
10 |
- |
140 |
3,780 |
||
|
|
|
|
|
|
|
|
Additional Conn. During THIS PERIOD |
120 |
2 |
2 |
- |
2 |
126 |
|||
|
|
|
|
|
|
|
|
No. of Conn. end of DECEMBER |
|
3,745 |
7 |
12 |
- |
- |
3,764 |
||
|
|
|
|
|
|
|
|
Ave. No. of Connections/month |
|
3,685 |
7 |
11 |
- |
70 |
3,772 |
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2012 WATER RATES APPLIES: |
|
|
|
|
|
|||||
|
|
|
|
Ave. |
Ave. |
Min. |
|
|
|
|
Ave.Rev./ |
Quarterly |
|
|
|
|
|
|
Classification |
Conn. |
Cons. |
Charge |
11-20 |
21-30 |
31-40 |
over 40 |
Conn. |
Billings |
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Residential |
|
3,685 |
21 |
206.80 |
22.70 |
24.00 |
25.50 |
26.60 |
457.80 |
1,686,993.00 |
|
|
|
|
||
|
Commercial |
7 |
21 |
413.60 |
45.40 |
48.00 |
51.00 |
53.20 |
915.60 |
6,409.20 |
|
|
|
|
|||
|
Commercial A |
11 |
21 |
361.90 |
39.73 |
42.00 |
44.63 |
46.55 |
759.15 |
8,350.65 |
|
|
|
|
|||
|
Commercial B |
- |
21 |
310.20 |
34.05 |
36.00 |
38.25 |
39.90 |
|
- |
|
UNDER |
|
UNDER |
|||
|
Commercial C |
70 |
21 |
258.50 |
28.38 |
30.00 |
31.85 |
33.25 |
|
- |
|
PROJECTED |
|
PROJECTED |
|||
|
Bulk Sales |
- |
21 |
620.40 |
68.10 |
72.00 |
76.50 |
79.80 |
|
- |
|
INCOME STATEMENT |
CASHFLOW |
||||
|
|
|
|
|
|
|
|
|
|
|
|
1,701,752.85 |
|
BILLINGS |
|
COLLECTION |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected Water Sales - |
July 2017 to Dec 2017 |
|
(SIX MONTHS) |
|
X 6 |
10,210,517.10 |
|
10,210,517.10 |
|
|
||||
|
|
|
less: |
|
|
|
|
|
|
|
|
0.30% |
|
|
|
|
|
|
|
|
Senior Citizens' Discount |
|
|
|
|
|
30,631.55 |
|
(30,631.55) |
|
|
||||
|
|
|
Net Water Sales |
|
|
|
|
|
|
10,179,885.55 |
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Multiply by Estimated Collection Efficiency |
|
|
|
|
|
|
|
|
|
||||
|
|
|
|
Estimated Collection on Water Sales - |
|
|
|
|
|
10,179,884.60 |
|
|
|
10,179,884.60 |
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Projected Water Sales - |
July 2017 to Dec 2017 |
|
|
|
10,179,885.55 |
|
|
|
|
||||
|
|
|
|
Multiply by delinquency rate (on-time-paid 75%) |
|
|
|
|
|
|
|
|
|
||||
|
|
|
|
Overdue Bills |
|
|
|
|
|
|
2,544,971.39 |
|
|
|
|
||
|
|
|
|
Multilply by Penalty rate |
|
|
|
|
|
|
|
|
|
|
|
||
|
|
|
Projected Penalty Charges |
|
|
|
|
|
|
254,497.14 |
|
254,497.14 |
|
|
|||
|
|
|
|
Multiply by Estimated Collection Efficiency |
|
|
|
|
|
|
|
|
|
||||
|
|
|
|
Estimated Collection from Penalty Charges |
|
|
|
|
241,772.28 |
|
|
|
241,772.28 |
||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10,434,382.69 |
|
10,421,656.88 |
|
|
Collection of Prior Years Accounts Receivable-Customer: |
|
|
|
|
|
|
|
|
|
|||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Receivable - PY- |
6/30/2017 |
|
|
|
|
295,784.68 |
|
|
|
|
|||
|
|
|
|
Add: JANUARY TO JUNE 2017 uncollected Billings |
|
|
|
|
528,071.31 |
|
|
|
|
||||
|
|
|
|
|
Total arrears for collection |
|
|
|
|
|
823,856.00 |
|
|
|
|
||
|
|
|
|
Estimated Collection Rate during JULY TO DECEMBER |
|
|
|
85% |
|
|
|
|
|||||
|
|
|
|
Collection on prior years' Accounts Receivable-Customer and previous MONTHS |
|
|
|
|
|
|
251,416.98 |
||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10,434,382.69 |
|
10,673,073.86 |
|
|
|
|
|
|
|
|
|
SUB-TOTAL PROJECTED OPERATING REVENUES FOR 2016 |
|
20,995,808.94 |
|
|
|||||
|
|
|
|
|
|
|
|
|
SUB-TOTAL PROJECTED WATER SALES COLLECTION |
|
|
|
22,382,542.01 |
||||
|
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |
PAGE 2 |
|||||||||||||||
