DRAFT 7,,,,...,,, ,,,,
Water & Sewer Fund
W,.,
Revenue/ Expense Summary
PLAINFIELD
2018- 2019 Fiscal Year Budget
Classification
FY 2018
FY 2019
FY 2015
FY 2016
FY 2017
Adopted
Proposed
Actual
Actual
Actual
Budget
Budget
Fund: 02 - Water& Sewer Fund
Water, Sewer& Licenses
State
of
Expansion Revenues
Permits
648, 200
817, 169
938, 329
603, 000
618, 000
Illinois Taxes
1, 643, 244
1, 701, 328
1, 745, 968
1, 775, 000
1, 775, 000
13, 377, 977
and
Charges for Services
14, 194, 012
15, 018, 795
14, 875, 000
15, 820, 000
Investment Income
11, 253)
45, 688
47, 752
24, 382
35, 000
Miscellaneous
18, 745
35, 549
37, 565
25, 500
20, 500
15, 676, 913
$ 16, 793, 746
$ 17, 788, 409
$ 17, 302, 882
$ 18, 268, 500
Revenues Total
Water, Sewer& Salaries
and
Wages
Benefits Utilities
Supplies
and
Commodities
Contractual Services
Expansion Expenses
1, 295, 489
1, 308, 405
1, 375, 599
1, 374, 000
1, 360, 000
522, 633
516, 299
504, 869
552, 875
551, 243
589, 954
696, 361
694, 889
717, 600
725, 600
509, 019
458, 161
440, 934
478, 900
493, 100
8, 033, 790
8, 579, 626
9, 042, 292
8, 960, 000
9, 893, 000
Other
250, 380
250, 000
250, 000
250, 000
250, 000
Transfer to Debt Service
489, 852
498, 100
970, 900
979, 300
976, 800
56, 011
463, 391
1, 402, 943
830, 000
850, 000
3, 082, 189
3, 160, 125
3, 105, 059
3, 160, 207
3, 168, 757
3, 083, 662
3, 102, 438
3, 149, 875
0
0
17, 912, 979
$ 19, 032, 906
$ 20, 937, 360
$ 17, 302, 882
$ 18, 268, 500
0
0
Capital
Debt
service
Depreciation Expenditures Total
Total: Water& Sewer Fund
($
2,236, 066) ($ 2, 239, 160) ($ 3, 148, 951)
P1
12/ 7/ 2017
ail
u,,', i,;,,,••.•..
IN
I
I-
fl..,.
uq.,. , .
Water & Sewer Fund
_.,,,
0
Revenue Detail
PLAINFIELD
2018- 2019 Fiscal Year Budget FY 2018
FY 2018
FY 2019
FY 2015
FY 2016
FY 2017
Adopted
Estimated
Proposed
Actual
Actual
Actual
Budget
Budget
Budget
Description Fund: 02-
Water and Sewer Fund
Revenues
LIC& PER-
Licenses and Permits 29, 815
30, 672
52, 325
35, 000
32, 000
35, 000
Water Connection Fee
Meter Sales
309, 199
460, 745
446, 840
280, 000
325, 000
300, 000
Sewer Connection Fee
303, 166
316, 937
427, 124
280, 000
260, 000
275, 000
Sewer
By- Pass
Fee
Total: Licenses&
6, 020 Permits
$
8, 815
648, 200
12, 040
817, 169
$
$
938, 329
8, 000 $
8, 000
603, 000
$
8, 000
625, 000
$
618, 000
STTAX- State of Illinois Taxes Home Rule Sales Tax Total: State
of
Illinois Taxes
1, 643, 244
$ 1, 643, 244
1, 701, 328
$
1, 701, 328
1, 745, 968
$
1, 745, 968
1, 775, 000
$
1, 775, 000
1, 760, 000
$
1, 760, 000
1, 775, 000
$
1, 775, 000
SERV- Charges for Services Water Sales
Water
7, 801, 882
8, 539, 253
9, 316, 320
9, 350, 000
9, 600, 000
9, 933, 000
84, 824
93, 946
100, 004
85, 000
95, 000
85, 000 4, 700, 000
Penalty
Sewer Sales
4, 175, 306
4, 229, 705
4, 335, 795
4, 250, 000
4, 557, 000
Penalty
46, 640
47, 713
47, 432
45, 000
45, 000
40, 000
Capital Charge
1, 253, 043
1, 267, 061
1, 204, 238
1, 130, 000
1, 143, 000
1, 050, 000
16, 282
16, 334
15, 006
15, 000
14, 000
12, 000
Sewer
Capital Charge
Penalty
Total: Charges for Services $ 13, 377, 977 $ 14, 194,012 $ 15, 018, 795 $
14, 875, 000 $ 15, 454,000 $ 15, 820,000
INT- Investment Income
Interest Income
12, 928
25, 813
44, 481
24, 382
50, 000
Unrealized Gain/ Loss
24, 181)
19, 875
3, 271
0
0
Total: Investment Income
($
11, 253)
$
45, 688
$
47,752
$
24, 382
$
50, 000
35, 000
0 $
35, 000
MISC- Miscellaneous Sale
of
Sale
of
Fixed Assets
Scrap
Other Reimbursements Other Receipts
Total: Miscellaneous
$
0
500
0
0
0
0
645
1, 465
1, 055
500
1, 500
500
0
0
13, 714
0
4, 600
0
18, 100
33, 584
22, 796
25, 000
20, 000
20, 000
18, 745
Revenues Total $ 15, 676, 913
$
35, 549
$ 16, 793, 746 $
$
37, 565
17, 788, 409 $
P2
$
25, 500
17, 302, 882 $
$
26, 100
17, 915, 100 $
$
20, 500
18, 268, 500
12/ 7/ 2017
iii...
,,,,,....._, 1
Water & Sewer Fund
,,..,,,
I
I .-,..•,....,...
Iii
PLAINFIELDFWater/Sewer/Expansion Expense Detail 2018- 2019 Fiscal Year Budget FY 2018
FY 2018
FY 2019
FY 2015
FY 2016
FY 2017
Adopted
Estimated
Proposed
Actual
Actual
Actual
Budget
Budget
Budget
Description Fund: 02-
Water and Sewer Fund Expenses
Unit: 10- Water Department Division: 02- Water Administration Program SAL- Salaries and Wages Salaries- Full Time
227, 194
227, 229
236, 158
245, 000
260, 000
0
2, 172
0
0
0
Salaries- Part Time Total: Salaries and Wages
$
227, 194
$
229, 401
$
236, 158
$
245, 000
$
260, 000
250, 000 0 $
250, 000
BEN- Benefits FICA
14, 463
Medicare
13, 984
14, 288
15, 200
15, 200
15, 500
3, 465
3, 354
3, 457
3, 600
3, 600
3, 700
IMRF
27, 774
26, 624
27, 343
28, 000
28, 000
29, 000
Employee Insurance
47, 710
41, 684
36, 257
46, 000
46, 000
42, 000
Deferred
Contrib
8, 448
7, 788
8, 028
10, 000
10, 000
10, 000
Training
2, 100
4, 239
2, 708
7, 000
7, 000
7, 000
IL Unemployment Ins.
1, 891
1, 671
1, 706
2, 500
105, 851
99, 344
93, 787
Telephone/ Internet
4, 403
3, 128
4, 665
Cellular Phones/ Pagers
4, 044
3, 690
4, 153
3, 000
3, 000
8, 447
6, 818
8, 818
8, 600
8, 600
26, 033
30, 848
33, 548
26, 000
26, 000
30, 000
1, 360
1, 244
1, 458
1, 400
1, 400
1, 500
21
131
522
500
500
500
436
175
525
500
550
500
1, 784
1, 838
1, 893
2, 000
1, 800
2, 000
Gravel
772
926
1, 384
800
800
800
Water Meters
205, 979
141, 417
131, 728
150, 000
140, 000
150, 000
Travel/
Comp.
Total: Benefits
$
$
112, 300
2, 500
$
112,300
2, 500 $
109, 700
UTIL- Utilities
Total: Utilities
SUPP- Supplies&
Subscriptions
Gas/ Oil/ Mileage/ Wash
Supplies/ Hardware Software Sand&
5, 600
5, 600 7, 000 $
12, 600
Commodities
Office Supplies/ Postage Dues&
5, 600
Total: Supplies& Commodities
$
236, 385
$
176, 579
$
171, 058
$
181, 200
$
171, 050
$
185, 300
Contract- Contractual Services
Building
Maintenance
Legal Notices Legal Fees
Contractual Services Equipment Maintenance
Engineering
8, 996
8, 541
4, 921
8, 000
9, 500
10, 000
0
0
0
500
500
500
684
2, 244
292
1, 000
1, 000
1, 000
9, 124
34, 698
42, 195
27, 000
27, 000
50, 000
139)
Fees
Total: Contractual Services
$
0
126
500
500
500
0
128
0
4, 000
4, 100
4, 000
18, 665
45, 611
47, 534
41, 000
42, 600
66, 000
125, 190
125, 000
125, 000
125, 000
125, 000
125, 000
0
0
3, 424
0
0
0
122, 463
124, 525
242, 725
244, 825
244, 825
OTHER- Other
Admin Service Charge Bad Debt Expense Transfer to Debt Service
Total: Other Total: Water Admin Program
244, 200
$ 247, 653
$
249, 525
$
371, 149
$
369, 825
$
369, 825
$
369, 200
$
$
807, 278
$
928, 504
$
957, 925
$
964, 375
$
992, 800
844, 195
P3
12/ 7/ 2017
W_
Water & Sewer Fund
PLAINFIELD
Water/Sewer/Expansion Expense Detail 2018- 2019 Fiscal Year Budget FY 2018
FY 2018
FY 2019 Proposed
Budget
FY 2015
FY 2016
FY 2017
Adopted
Estimated
Actual
Actual
Actual
Budget
Budget
Description
Division: 30- Water Distribution Program SAL- Salaries and Wages 376, 723
Salaries- Full Time
378, 548
375, 000
360, 000
410, 000
403, 796
Salaries- Part Time
4, 707
9, 474
15, 650
14, 000
14, 000
15, 000
Salaries- Overtime
37, 098
35, 280
31, 516
35, 000
35, 000
35, 000
Total: Salaries BEN-
and
Wages
$
418, 528
$
423, 302
$
450, 962
$
459, 000
$
409, 000
$
425, 000
Benefits 24, 569
FICA
26, 171
26, 732
27, 000
29, 000
29, 000
5, 780
6, 155
6, 300
6, 800
6, 800
6, 500
IMRF
48, 351
47, 939
47, 882
53, 000
53, 000
50, 000
Employee Insurance
61, 000
60, 654
63, 113
70, 975
70, 975
73, 000
Medicare
Deferred
Comp.
13, 904
11, 533
Contrib
Total: Benefits
$
151, 233
$
$
159, 529
174, 775
$
16, 500
15, 000
15, 000
15, 502
154, 823
$
174, 775
173, 000
$
UTIL- Utilities Telephone/ Internet
Cellular Phones/ Pagers
6, 885
5, 362
7, 888
9, 000
9, 000
9, 000
0
0
152
500
500
500
131, 748
Electricity/ Gas Total: Utilities
$
$
162, 152
$
125, 000
140, 000
123, 566
156, 790
138, 633
131, 606
$
149, 500
$
140, 000
134, 500
$
149, 500
SUPP- Supplies and Commodities Office Supplies/ Postage
3, 687
75
2, 000
2, 000
200
2, 000
2, 456
10, 150
7, 017
5, 000
5, 000
5, 000
14, 402
12, 137
8, 602
15, 000
15, 000
15, 000
Supplies/ Hardware
3, 118
4, 282
5, 485
4, 000
5, 800
4, 000
Chemicals
4, 811
4, 025
5, 380
5, 500
6, 000
6, 000
Uniforms/
2, 366
3, 322
5, 328
2, 000
2, 000
2, 000 34, 000
5, 000
Replacement Supplies
Gas/ Oil/ Mileage/ Wash
Clothing
Total: Supplies&
Commodities
$
30, 840
33, 991
32, 012
33, 500
35, 800
1, 920
2, 365
2, 772
4, 000
4, 000
Contract- contractual Services
Building
Maintenance
Vehicle Maintenance Contractual Services Lake Michigan Water
9, 371
5, 215
6, 090
6, 500
6, 500
7, 500
43, 807
48, 317
53, 499
40, 000
40, 000
65, 000
7, 649, 599
8, 124, 114
8, 471, 988
8, 403, 000
8, 930, 000
9, 225, 000
Equipment Maint.
10, 804
11, 512
12, 096
9, 000
9, 000
10, 000
System Maintenance
45, 303
26, 311
49, 419
44, 000
44, 000
60, 000
Water/ Fire Hydrant
15, 119
15, 071
19, 075
20, 000
20, 000
20, 000
EPA Analytical
15, 400
15, 429
11, 035
16, 000
16, 000
Total: Contractual Services
$ 7, 791, 323
8, 248, 334
$
$
8, 625, 974
$
8, 542, 500
$
9, 069, 500
16, 000 9, 408, 500
$
OTHER- Other 122, 463
Transfer to Debt Service Total: Other
$
122, 463
242, 725
124, 525 $
124, 525
$
$
244, 825
244, 200
244, 825
244, 825
242, 725
$
244, 825
244, 200
$
Contingencies/ Depreciation 3, 102, 438
3, 149, 875
0
0
0
3, 102, 438
$ 3, 149, 875
0
0
0
Total: Water Distribution Program $ 11, 736, 682
$ 12, 249, 565
$ 12, 792, 683
$
12, 580, 877
$ 13, 056, 843
$ 13, 721, 187
$ 10, 562, 025
3, 083, 662
Depreciation
Total: Depreciation
Total: Water Department
$ 3, 083, 662
$
P4
9, 604, 100 $ 10, 068, 400 $ 10, 434, 200 $ 11, 032, 775 $
1
11, 427, 000
7
117
ii...
1.
al
ISI
IIIIII
1
1
I-
..."
Water & Sewer Fund
Lb.,
11a111M...
1Y I
111
Water/Sewer/Expansion Expense Detail
PLAINFIELD
2018- 2019 Fiscal Year Budget FY 2018
FY 2018
FY 2019
FY 2015
FY 2016
FY 2017
Adopted
Estimated
Proposed
Actual
Actual
Actual
Budget
Budget
Budget
Description
Unit: 11- Sewer Department Division: 02- Sewer Administration Program
SAL- Salaries and Wages Salaries- Full Time
227, 693
227, 529
235, 197
245, 000
245, 000
0
2, 172
0
0
0
Salaries- Part Time Total: Salaries
BEN-
and
Wages
$
227, 693
$
229, 701
$
235, 197
$
245, 000
$
250, 000 0
245, 000
$
250, 000
Benefits
FICA Medicare
13, 964
13, 951
14, 291
15, 200
15, 200
15, 500
3, 348
3, 346
3, 457
3, 600
3, 600
4, 000
IMRF
27, 837
26, 595
27, 356
28, 000
28, 000
29, 000
Employee Insurance
47, 420
37, 137
35, 825
46, 000
46, 000
42, 000
8, 460
7, 565
7, 723
10, 000
10, 000
10, 000
Training
3, 443
10, 175
5, 192
12, 000
12, 000
12, 000
IL Unemployment Ins.
1, 891
1, 671
1, 706
2, 500
2, 500
100, 440
95, 550
Deferred Travel/
Comp.
Contrib
Total: Benefits
$
106, 363
$
$
117, 300
$
2, 500
117, 300
$
115, 000
UTIL- Utilities Telephone/ Internet
9, 846
7, 242
11, 909
9, 000
Cellular Phones/ Pagers
3, 969
3, 435
2, 974
3, 500
3, 500
3, 500
13, 815
10, 677
14, 883
12, 500
13, 500
16, 500
Office Supplies/ Postage
25, 340
30, 738
31, 332
25, 000
25, 000
30, 000
Dues & Subscriptions
61, 871
59, 021
60, 536
68, 200
68, 200
72, 300
Gas/ Oil/ Mileage/ Wash
950
366
299
1, 000
1, 000
1, 000
Supplies/ Hardware
661
Total: Utilities
$
10, 000
13, 000
SUPP- Supplies and Commodities
Total: Supplies
and
Commodities
$
661
511
90, 786
92, 678
11, 577
12, 405
959 9, 294
88,822
$
2, 500
2, 500
96, 700
96, 700
17, 449
15, 000
16, 000
756
172
1, 500
1, 500
1, 500
19, 636
39, 620
30, 000
30, 000
50, 000
$
2, 500 $
105, 800
Contract- Contractual Services
Building Maintenance Legal Fees
Contractual Services Equipment Maintenance
Engineering
Fees Total: Contractual
$
20, 000
613
880
0
2, 000
2, 000
2, 000
0
13, 350
10, 186
10, 000
10, 000
10, 000
22, 443
47, 027
67, 427
58, 500
59, 500
83, 500
OTHER- Other 2013/ 2004A Bond( Principal)
3, 000
3, 000
340, 500
39, 840
384, 000
397, 500
48, 069
46, 710
46, 650
384, 000
39, 840
28, 320
331, 500
348, 000
30, 000
0
0
0
2005B Bond ( Interest)
33, 480
18, 563
1, 162
0
0
0
Admin Service Charge
125, 190
125, 000
125, 000
125, 000
125, 000
125, 000
0
0
2, 321
0
0
0
122, 463
124, 525
242, 725
244, 825
244, 825
244, 200
2013/ 2004A Bond ( Interest) 2005B Bond ( Principal)
Bad Debt Expense
Transfer to Debt Service Total: Other
Total: Sewer Admin Program
$
663, 702
$ 1, 122, 838
$ $
665, 798 1, 144, 429
P5
$
788, 358
$ 1, 294, 093
$
793, 665
$ 1, 323, 665
$
793, 665
$ 1, 325, 665
$ $
795, 020
1, 365, 820
12/ 7/ 2017
Water & Sewer Fund 1-
1_.
1
1
1-
11. 1, 111."
1. 1.
1
111
Water/Sewer/Expansion Expense Detail
PLANGMELD
2018- 2019 Fiscal Year Budget
Description
FY 2015
Actual
FY 2018
FY 2018
FY 2019
FY 2016
FY 2017
Adopted
Estimated
Proposed
Actual
Actual
Budget
Budget
Budget
Division: 40- Sewer Treatment Program
SAL- Salaries and Wages 386, 560
Salaries- Full Time
388, 887
410, 780
395, 000
380, 000
385, 000
Salaries- Part Time
4, 707
9, 474
15, 650
10, 000
10, 000
10, 000
Salaries- Overtime
30, 807
27, 640
26, 852
30, 000
30, 000
30, 000
Total: Salaries&
BEN-
Wages
$
422, 074
$
426, 001
$
453, 282
$
425, 000
$
420, 000
$
435, 000
Benefits 24, 616
26, 345
27, 243
26, 500
26, 500
5, 788
6, 193
6, 414
6, 500
6, 500
6, 543
47, 747
48, 544
48, 878
46, 000
46, 000
48, 000
Employee Insurance
69, 128
68, 440
60,441
56, 000
56, 000
57, 000
Deferred
11, 907
12, 170
13, 027
13, 500
13, 500
15, 000
FICA
Medicare
IMRF
Comp.
Contrib Total: Benefits
$
159, 186
$
161, 692
$
156, 003
$
148, 500
$
27, 000
148, 500
$
153, 543
UTIL- Utilities
Telephone/ Internet
Electricity/ Gas Total: Utilities
17, 212
13, 405
19, 797
22, 000
22, 000
22, 000
411, 847
503, 309
519, 785
525, 000
525, 000
525, 000
$ 429, 059
$
516, 714
$
539, 582
$
547, 000
$
547, 000
$
547, 000
SUPP- Supplies and Commodities Office Supplies/ Postage
3, 686
272
841
4, 500
4, 500
4, 500
Replacement Supplies
1, 300
1, 376
2, 085
1, 500
2, 200
2, 000
Gas/ Oil/ Mileage/ Wash
Supplies/ Hardware Chemicals Sand&
17, 601
10, 229
8, 249
13, 000
10, 000
12, 000
6, 007
12, 960
10, 857
10, 000
10, 000
10, 000
110, 989
117, 231
112, 021
115, 000
115, 000
115, 000
0
0
253
500
500
500
Industrial Flow Monitor
8, 612
7, 052
1, 971
18, 000
18, 000
18, 000
Uniforms/
4, 777
7, 685
8, 909
5, 000
5, 000
6, 000
Gravel
Clothing
152, 972
Total: Supplies& Commodities
$
156, 805
$
145, 186
$
167, 500
$
165, 200
$
168, 000
Contract- Contractual Services Vehicle Maintenance Contractual Services Equipment Maint. Maintenance- James St.
System Maintenance Total: Contractual
8, 200
4, 977
3, 473
8, 000
10, 000
10, 000
148, 525
149, 779
214, 685
160, 000
160, 000
170, 000
22, 892
29, 493
22, 092
20, 000
20, 000
25, 000
0
196
5, 601
5, 000
5, 000
5, 000
21, 742
54, 209
55, 506
125, 000
125, 000
125, 000
$
201, 359
$
122, 463
$
238, 654
$
301, 357
$
242, 725
$
318, 000
$
320, 000
$
244, 825
$
335, 000
$
244, 200
OTHER- Other 122, 463
Transfer to Debt Service Total: Other
124, 525 $
124, 525
Total: Sewer Treatment Program
$ 1, 487, 113
$
1, 624, 391
Total: Sewer Department
$ 2, 609, 951
$ 2, 768, 820
P6
242, 725
$
1, 838, 135
$ 3, 132, 228
244, 825 $
244, 825
244,825
244, 200
1, 850, 825
$ 1, 845, 525
$
1, 882, 743
$ 3, 174, 490
$ 3, 171, 190
$
3, 248, 563
$
12/ 7/ 2017
Water & Sewer Fund
iiil. 1_..
1
1
tuy. l.
1-.,..,,
1 X11
PLAINFIELDFWater/Sewer/Expansion Expense Detail
2018- 2019 Fiscal Year Budget Description
FY 2018
FY 2018
FY 2019
FY 2015
FY 2016
FY 2017
Adopted
Estimated
Proposed
Actual
Actual
Actual
Budget
Budget
Budget
Unit: 12- Utility Expansion Unit: 12- Utility Expansion Division: 91- Capital OTHER- Other Contractual Services
5, 260
0
0
210, 000
210, 000
210, 000
533
3, 100
40, 152
150, 000
150, 000
150, 000
Machinery& Equipment
25, 764
3, 454
12, 894
0
6, 000
75, 000
Vehicles
Fees
Engineering
19, 522
0
0
180, 000
40, 000
70, 000
Route 30 Water Main
0
296, 356
269, 614
0
0
0
Rt 30 Main- Kuusakoski to Tower 2
0
22, 461
840, 470
100, 000
100, 000
0
742
63, 520
2, 158
20, 000
20, 000
20, 000
0
0
56, 525
0
200, 000
225, 000
4, 190
74, 500
181, 130
170, 000
150, 000
100, 000
Scada Improvements
Pump
Station Improvements
Liftstation Improvements Total: Other
Division: 92OTHER-
$
56, 011
$
463, 391
$
1, 402, 943
$
830,000
$
876, 000
$
850,000
Bonds
Other
2013/ 2004A Bond ( Principal)
7, 000
7, 000
794, 500
896, 000
896, 000
927, 500
2013/ 2004A Bond( Interest)
108, 838
108, 990
100, 338
92, 960
92, 960
66, 080
2013/ 2004B Bond ( Principal)
345, 000
360, 000
365, 000
375, 000
375, 000
385, 000
57, 880
53, 150
43, 213
38, 650
38, 650
27, 400
773, 500
812, 000
70, 000
0
0
0
59, 473
43, 313
1, 260
0
0
0
2008 Bond( Principal)
415, 000
450, 000
450, 000
500, 000
500, 000
0
2008 Bond( Interest)
543, 438
721, 391
47, 863
25, 000
25, 000
0
0
0
90, 000
90, 000
90, 000
620, 000
2015/ 2008 Bond ( Interest)
168, 894
0
531, 550
529, 750
529, 750
527, 950
IEPA Loan
151, 643
153, 545
155, 470
158, 419
158, 419
158, 419
35, 474
34, 463
31, 808
30, 588
30, 588
30, 588
178, 866
0
0
0
0
0
Total: Other
$ 2, 845, 006
$ 2, 743, 852
$ 2, 681,002
$ 2, 736, 367
$ 2, 736, 367
$
Expansion
$ 2, 901, 017
$ 3, 207, 243
$ 4, 083, 945
$ 3, 566, 367
$ 3, 612, 367
$ 3, 592, 937
2013/ 2004B Bond ( Interest) 2005B Bond( Principal) 2005B Bond ( Interest)
2015/ 2008 Bond ( Principal)
IEPA Loan ( Interest)
Bond Issuance Costs
Unit Total: 12-
Utility
Total: Water& Sewer Fund $ 18, 091, 845
$ 19, 032, 906 $ 20, 937, 360 $ 17, 302, 882 $
P7
2, 742, 937
17, 816, 332 $ 18, 268, 500
12/ 7/ 2017
DRAFT l,
t(
fn
m'
ni
Water & Sewer Fund
w'
..
uvm •..
i ,-
q. 0.-. ,
l,
PLAINFIELD
Revenue & Expense Forecast
Fiscal Years 2018- 2021 FY 2019
Classification
Proposed
FY 2020
FY 2021
FY 2022
Budget
Budget
Budget
Budget
Fund: 02- Water& Sewer Fund
Water, Sewer & Expansion Revenues Licenses
Permits
618, 000
600, 000
600, 000
600, 000
Illinois Taxes
1, 775, 000
1, 792, 750
0
0
15, 820, 000
16, 294, 600
16, 783, 438
17, 286, 941
Investment Income
35, 000
15, 000
15, 000
15, 000
Miscellaneous
20, 500
15, 000
15, 000
15, 000
18, 268, 500
$ 18, 717, 350
$ 17, 413, 438
$ 17, 916, 941
State
of
and
Charges for Services
Revenues Total
Water, Sewer & Expansion Expenses Salaries
Wages
1, 360, 000
1, 394, 000
1, 435, 820
Benefits
551, 243
573, 293
596, 224
620, 073
Utilities
725, 600
729, 228
732, 874
736, 539
Supplies
and
Commodities
1, 478, 895
493, 100
495, 566
498, 043
500, 534
9, 893, 000
10, 140, 325
10, 393, 833
10, 653, 679
Other
250, 000
250, 000
250, 000
250, 000
Transfer to Debt Service
976, 800
981, 000
983, 800
985, 200
Capital
850, 000
900, 000
900, 000
900, 000
3, 168, 757
3, 170, 557
1, 331, 357
1, 339, 757
and
Contractual Services
Debt
service
Depreciation Expenses Total
Surplus/( Deficit) Water& Sewer Fund
0
83, 382
291, 486
452, 265
18, 268, 500
$ 18, 717, 350
$ 17, 413, 438
$ 17, 916, 941
0
0
0)
0
12/ 7/ 2017
Water&
Sewer Fund-
Debt Service Schedules
2013
Fiscal
Year
(
portion
2013
portion
2010
that
that
Refunding
refunded
refunded
Revenue Bond
Revenue Bond
Bond ( refunded
2004A
2004B
1st lien 2008
2nd lien 2008
2008)
was
2003A)
2018 $
979, 300
2019 $
$
1, 412, 800
976, 800
$
2020 $
981, 000
$
2021 $
$
413, 650
1, 419, 400
$
1, 421, 400
$
2015 Revenue
$
262, 500
$
262, 500
$
Total Fund IEPA LOAN
02
619, 750
$
189, 007
$
4, 139, 507
412, 400
1, 147, 950
$
189, 007
$
4, 145, 557
412, 000
1, 148, 150
$
189, 007
$
4, 151, 557
983, 800
1, 142, 350
$
189, 007
$
2, 315, 157
2022 $
985, 200
1, 150, 750
$
189, 007
$
2, 324, 957
2023 $
995, 200
1, 147, 750
$
189, 007
$
2, 331, 957
2024 $
998, 400
1, 143, 750
$
189, 007
$
2, 331, 157
2025
1, 143, 750
$
189, 007
$
1, 332, 757
2026
1, 142, 550
$
189, 007
$
1, 331, 557
2027
1, 140, 150
$
189, 007
$
1, 329, 157
2028
1, 141, 550
$
189, 007
$
1, 330, 557
2029
1, 151, 550
$
189, 007
$
1, 340, 557
2030
1, 144, 750
$
189, 007
$
1, 333, 757
2031
1, 146, 750
$
189, 007
$
1, 335, 757
2032
1, 147, 150
$
189, 007
$
1, 336, 157
2033
1, 145, 950
1, 145, 950
2034
1, 138, 500
1, 138, 500
Village
of
Plainfield
City/ Village
Water&
Water/ 100
cu
ft
Sewer Survey- Neighbors
Water/ 1000
gal
DRAFT
Monthly
Monthly
Water
Sewer
Charge
Sewer/ 100
cu
ft
Sewer/ 1000
gal
Charge
12/ 4/ 2017
Combined
Water Source
Softened
Other
Water
Charges
Charge
Type
of
Other
Joliet
3. 92 $
5. 24 $
23. 71
3. 54 $
4. 73 $
24. 78
Well
Yes
15. 23
Maintenance
Naperville
5. 12 $
6. 85 $
35. 84 $
1. 96 $
2. 62 $
13. 72
Lake
Yes
20. 61
Meter& Sewer
Oswego
3. 83 $
5. 12 $
26. 81 $
5. 75 $
7. 69 $
40. 25
Well
No
Romeoville
4. 36 $
5. 83 $
30. 52 $
5. 84 $
7. 81
40. 88
Well
No
Plainfield
6. 47 $
8. 65 $
45. 29 $
2. 95 $
3. 94 $
20. 65
Lake
Yes
3. 17
7. 00
Monthly
Water&
Sewer Charges
63. 72 $
Capital
70. 17 70. 23
None
71. 40
Capital
72. 94
Lockport
4. 62
6. 18 $
32. 34 $
4. 46 $
5. 96 $
31. 22
Well
No
14. 50
Surcharge
78. 06
Yorkville
4. 30 $
5. 75 $
31. 08 $
1. 10 $
1. 47 $
25. 33
Well
Yes
35. 11
Capital
91. 52
Yes
29. 10
Storm&
Env.
$
95. 67
Yes
56. 33
Meter& Fire
$
147. 53
Aurora
5. 05 $
6. 75 $
35. 35 $
4. 46 $
5. 96
31. 22
Well&
Bolingbrook
9. 04 $
12. 09 $
63. 28 $
1. 82 $
2. 43 $
27. 92
Lake
Monthly
charge
based
on
700
cu.
ft. (5, 236
gallons)
total water&
sewer consumption.
River
Average Charge
$
84. 58
Village
of
Plainfield
City/ Village
Water&
Water/ 100
cu
ft
Sewer Survey - Lake Water/Like Population
Water/ 1000
Monthly
Monthly
Water
Sewer
Charge
gal
DRAFT
Sewer/ 100
cu
ft
Sewer/ 1000
gal
Charge
12/ 4/ 2017
Combined Softened Water Source
Water
Type Other Charges
Oak Forest
6. 27 $
8. 38 $
43. 89 $
1. 41 $
1. 89
9. 87
Lake
Yes
5. 00
Mokena
5. 52 $
7. 38 $
38. 64 $
3. 18 $
4. 25 $
22. 26
Lake
Yes
11. 33
Plainfield
6. 47 $
8. 65 $
45. 29 $
2. 95 $
3. 94 $
20. 65
Lake
Yes
7. 00
Downers Grove
$
6. 03 $
8. 06 $
42. 21 $
1. 24 $
1. 66 $
8. 68
Lake
Yes
24. 45
Lombard
5. 94 $
7. 94 $
41. 58 $
4. 31 $
5. 76
30. 17
Lake
Yes
8. 40
Oak Park
6. 70 $
8. 96 $
46. 90 $
1. 85 $
2. 47 $
27. 92
Lake
Yes
Darien
7. 29 $
9. 75 $
51. 03 $
2. 85 $
3. 81 $
19. 95
Lake
Villa Park
6. 62 $
8. 85 $
46. 34 $
6. 29 $
8. 41 $
44. 03
Homewood
12. 18 $
16. 28 $
85. 26 $
4. 05 $
5. 41 $
Bolingbrook
9. 04 $
12. 09 $
63. 28 $
1. 82 $
2. 43 $
Monthly
charge
based
on
700
cu.
ft.( 5, 236
gallons)
total
water&
sewer consumption.
of
Other
Monthly
Charge
Water&
Sewer Charges
Service
58. 76
Meter
72. 23
Capital
72. 94
Customer/ Sewer
$
75. 34
Capital
80. 15
10. 00
Customer
84. 82
Yes
15. 78
Service
86. 76
Lake
Yes
27. 70
Various
118. 07
48. 19
Lake
Yes
27. 92
Lake
Yes
None 56. 33
Meter& Fire
Average Charge
133. 45 $
147. 53
$
93. 01
Village
City/
of
Plainfield
Water&
Water/ 100 cu ft
Village
Sewer Survey- GovHR Communities
Water/ 1000
gal
DRAFT
Monthly
Monthly
Water
Sewer
Charge
Sewer/ 100
cu
ft
Sewer/ 1000
gal
Charge
12/ 4/ 2017 Combined Softened
Water Source
Water
Type Other Charges
of
Other
Monthly Water&
Charge
Sewer Charges
West Chicago
2. 90 $
3. 88 $
20. 30 $
4. 20 $
5. 62 $
29. 40
Well
Yes
9. 30
Capital
59. 00
Lisle
4. 86 $
6. 50 $
34. 02 $
2. 84 $
3. 80 $
19. 88
Lake
Yes
8. 58
Capital
62. 48
Oswego
3. 83 $
5. 12 $
26. 81 $
5. 75 $
7. 69 $
40. 25
Well
No
3. 17
Capital
Batavia
3. 33 $
4. 45 $
23. 31 $
3. 86 $
5. 16 $
27. 02
Well
Yes
Romeoville
4. 36 $
5. 83 $
30. 52 $
5. 84 $
7. 81 $
40. 88
Well
No
5. 61 $
7. 50 $
39. 27 $
3. 45 $
4. 61 $
24. 15
Well
No
Plainfield
6. 47 $
8. 65 $
45. 29 $
2. 95 $
3. 94 $
20. 65
Lake
St. Charles
2. 60 $
3. 48 $
18. 20 $
4. 17 $
5. 58 $
29. 19
Lockport
4. 62 $
6. 18 $
32. 34 $
4. 46 $
5. 96 $
Lombard
5. 94 $
7. 94 $
41. 58 $
4. 31 $
Woodridge
6. 12 $
8. 18 $
42. 84 $
New Lenox
3. 52 $
4. 71 $
24. 64 $
Villa Park
6. 62 $
8. 85 $
Wheaton
5. 05 $
6. 75 $
Glendale Heights
Monthly
charge
$
based
on
700
cu.
ft.( 5, 236
gallons)
19. 95
Meter/ Sewer
70. 23
$
70. 28
None
71. 40
9. 00
Service
72. 42
Yes
7. 00
Capital
72. 94
Well
Yes
29. 28
Meter/ EPA
76. 67
31. 22
Well
No
14. 50
Surcharge
78. 06
5. 76 $
30. 17
Lake
Yes
8. 40
3. 52 $
4. 71 $
24. 64
Lake
Yes
26. 59
Service/ Sewer
6. 36 $
8. 50 $
44. 52
Well
Yes
46. 09
Various
115. 25
46. 34 $
6. 29 $
8. 41 $
44. 03
Lake
Yes
27. 70
Various
118. 07
35. 35 $
5. 75 $
7. 69 $
40. 25
Lake
Yes
54. 25
Various
129. 85
total water& sewer consumption.
Capital
Average Charge
80. 15 $
$
94. 07
83. 63
DRAFT Village
of
Plainfield
2018 - 2021 Water&
Sewer Proposed Rates
12/ 5/ 2017
Without Refuse Charge)
Current Rates
Average Bill( 700 Water
45. 29
Sewer
20. 65
Capital
cu
ft/ mo)
Minimum Bill
Rate/ 100
cu
ft
6. 47 ( first 100
cu
ft)
6. 47
8. 85 ( first 300
cu
ft)
2. 95
7. 00
7. 00
72. 94
22. 32
DRAFT Proposed Rate 2018, 2019, 2020, 2021
2018
Average Bill( 700
cu
ft/mo)
Minimum Bill
Rate/ 100
cu
ft
Rate Change
Water
47. 53
6. 79 ( first 100
cu
ft)
6. 79 $
0. 32
Sewer
22. 89
9. 81 ( first 300
cu
ft)
3. 27 $
0. 32
Capital
Difference/ Mo
2019
$
6. 50
6. 50
76. 92
23. 10
3. 98
0. 78
Average Bill( 700
cu
ft/ mo)
Minimum Bill
Rate/ 100
cu
ft
Rate Change
Water
49. 63
7. 09 ( first 100
cu
ft)
7. 09 $
0. 30
Sewer
24. 78
10. 62 ( first 300
cu
ft)
3. 54 $
0. 27
Capital
Difference/Mo
2020
$
6. 50
6. 50
80. 91
24. 21
3. 99
1. 11
Average Bill( 700
cu
ft/ mo)
Minimum Bill
Rate/ 100
cu
ft
Rate Change
Water
51. 73
7. 39 ( first 100
cu
ft)
7. 39 $
0. 30
Sewer
26. 67
11. 43 ( first 300
cu
ft)
3. 81 $
0. 27
Capital
Difference/ Mo
2021
$
6. 50
6. 50
84. 90
25. 32
3. 99
1. 11
Average Bill( 700
cu
ft/ mo)
Minimum Bill
Rate/ 100
cu
ft
Rate Change
Water
53. 83
7. 69 ( first 100
cu
ft)
7. 69
$
0. 30
Sewer
28. 56
12. 24 ( first 300
cu
ft)
4. 08 $
0. 27
Capital
Difference/ Mo
$
6. 50
6. 50
88. 89
26.43
3. 99
1. 11
A Senior Citizen, that
qualifies
for the
County
tax
freeze
exemption, will
be
offered a
10% discount.