Expense Summary AWS

Report 0 Downloads 59 Views
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.