Budget Workshop
Budget Workshop March 4, 2017
Fiscal Year 2017 Summary FUND General Motor Fuel Tax Tax Increment Financing Debt Service Capital Improvement Water and Sewer Water and Sewer Capital Garbage Collection Vehicle Police Pension TOTAL
Budget Revenues Expenditures
Difference Rev/Exp
Projected Revenues Expenditures
Difference Rev/Exp
17,542,053 801,250 0 1,754,594 34,587,059 5,190,800 796,000 2,501,950 732,500 2,190,000
17,345,988 862,500 0 1,754,394 6,943,700 5,967,699 659,000 2,501,200 713,680 634,900
196,065 -61,250 0 200 27,643,359 -776,899 137,000 750 18,820 1,555,100
16,729,325 854,000 0 2,390,525 34,948,590 5,194,145 170,000 2,360,900 748,800 3,322,833
16,675,283 842,500 1,735,500 2,387,225 6,826,515 5,940,676 455,700 2,350,000 711,190 705,400
54,042 11,500 -1,735,500 3,300 28,122,075 -746,531 -285,700 10,900 37,610 2,617,433
66,096,206
37,383,061
28,713,145
66,719,118
38,629,989
28,089,129
Fiscal Year 2018 Budget Fund
Budget Year Comparison Summary - All Funds Fiscal Year Fiscal Year 2018 2018 Revenues Expenditures
Fiscal Year 2018 Difference
Major Governmental Funds General Fund
$17,661,787
$17,650,807
Capital Improvement Fund Debt Service Fund
$2,930,000 $2,923,316
$27,077,000 $2,922,844
($24,147,000) $472
$23,515,103
$47,650,651
($24,135,548)
$854,000 $40,500
$1,162,500 $350,500
($308,500) ($310,000)
$894,500
$1,513,000
($618,500)
$5,172,300
$5,202,154
($29,854)
$160,000
$1,250,000
($1,090,000)
$2,451,700
$2,450,000
$1,700
$90,400
$85,000
$5,400
$7,874,400 $32,284,003
$8,987,154 $58,150,805
$2,343,100
$728,300
$1,614,800
Total Fiduciary Funds
$2,343,100
$728,300
$1,614,800
Total Non Operating Funds
$2,343,100
$728,300
$1,614,800
$34,627,103
$58,879,105
Total Major Governmental Funds
$10,980
Non-Major Governmental Funds Motor Fuel Tax Fund Tax Increment Financing Total Non Major Governmental Funds Proprietary Funds Enterprise Funds Waterworks & Sewer Fund Waterworks & Sewer Capital Fund Garbage Fund Internal Service Funds Vehicle Fund Total Proprietary Funds Total Operating Funds
($1,112,754) ($25,866,802)
Non Operating Funds Fiduciary Funds Police Officers' Pension Fund
Total All Funds
($24,252,002)
Fiscal Year 2018 Budget REVENUES - ALL FUNDS
FUND
FY 2016 ACTUAL
General
17,270,896 17,542,053
Motor Fuel Tax Tax Increment Financing Debt Service Capital Improvement
FY 2017 FY 2017 FY 2018 BUDGET PROJECTED BUDGET 16,729,325 17,661,787
FY 2018 Budget vs FY 2017 Projected Budget 6%
1%
892,689
801,250
854,000
854,000
0%
7%
0
0
0
40,500
100%
100%
1,774,573
1,754,594
2,390,525
2,923,316
22%
67%
886,931 34,587,059
34,948,590
2,930,000
-92%
-92%
Water and Sewer
5,823,419
5,190,800
5,194,145
5,172,300
0%
0%
Water and Sewer Capital
6,351,628
796,000
170,000
160,000
-6%
-80%
Garbage Collection
2,407,632
2,501,950
2,360,900
2,451,700
4%
-2%
0
732,500
748,800
90,400
-88%
-88%
1,907,128
2,190,000
3,322,833
2,243,100
-32%
2%
66,719,118 34,527,103
-48%
-48%
Vehicle Police Pension TOTAL REVENUES
37,314,896 66,096,206
Fiscal Year 2018 Budget EXPENDITURES - ALL FUNDS
FUND General Motor Fuel Tax Tax Increment Financing Debt Service Capital Improvement Water and Sewer Water and Sewer Capital Garbage Collection Vehicle Police Pension TOTAL EXPENSES
FY 2016 ACTUAL
FY 2018 Budget vs FY 2017 Projected Budget
FY 2017 BUDGET
FY 2017 PROJECTED
FY 2018 BUDGET
17,688,079
17,345,988
16,675,283
17,650,807
6%
2%
679,004
862,500
842,500
1,162,500
38%
35%
0
0
1,735,500
350,500
-80%
100%
1,772,101
1,754,394
2,387,225
2,922,844
22%
67%
345,037
6,943,700
6,826,515
27,077,000 297%
290%
10,666,503
5,967,699
5,940,676
705,167
659,000
455,700
2,415,909
2,501,200
0
5,202,154
-12%
-13%
1,250,000 174%
90%
2,350,000
2,450,000
4%
-2%
713,680
711,190
85,000
-88%
-88%
598,532
634,900
705,400
728,300
3%
15%
34,870,331
37,383,060
38,629,989
58,879,105
52%
58%
Fiscal Year 2018 Budget REVENUES BY SOURCE - ALL FUNDS FY 2018 Budget FY 2017 FY 2018 vs FY 2017 PROJECTED BUDGET Projected Budget
REVENUES
FY 2016 ACTUAL
FY 2017 BUDGET
Taxes
17,007,331
19,261,839
Charges for Services
8,288,509
8,498,150
8,078,475
Licenses and Permits
620,418
697,100
1,001,568
Fines and Forfeitures
1%
-1%
8,275,206
2%
-3%
565,800
574,500
2%
-18%
1,101,000
985,000
978,000
-1%
-11%
291,922
307,100
181,100
181,000
0%
-41%
Franchise Fees
545,401
1,113,561
565,500
592,500
5%
-47%
Donations/ Contributions
752,916
924,362
936,145
722,081
-23%
-22%
8,356,595
3,956,894
4,095,108
3,708,016
-9%
-6%
344,449
232,700
1,509,500
492,700
-67%
112%
0
30,000,000
30,988,607
0
-100%
-100%
105,786
3,500
23,170
5,100
-78%
46%
37,314,896
66,096,206
66,719,118 34,527,103
-48%
-48%
Grants/Intergovernmental
Transfers From Other Funds Interest Bond Proceeds Miscellaneous TOTAL REVENUE
18,790,713 18,998,000
Fiscal Year 2018 Budget General Fund $7,000,000
Sales Tax Revenue Sales Tax Revenue
Sales Tax Fiscal Year Revenue % Change FY 2009 4,501,565 -4.2% FY 2010 4,829,238 7.3% FY 2011 4,892,537 1.3% FY 2012 5,183,713 6.0% FY 2013 5,331,846 2.9% FY 2014 5,519,552 3.5% FY 2015 5,729,920 3.8% FY 2016 6,047,817 5.5% FY 2017* 6,000,000 -0.8% FY 2018* 6,100,000 1.7% *Projected
$6,000,000 $5,000,000 $4,000,000
$3,000,000 $2,000,000 $1,000,000 $0
* Projected
Fiscal Year 2018 Budget General Fund
Income Tax Revenue Income Tax Revenue
Fiscal Year 2009 2010 2011 2012 2013 2014 2015 2016 2017* 2018*
$3,500,000
$3,000,000 $2,500,000 $2,000,000
$1,500,000 $1,000,000 $500,000
* Projected
Income Tax % Revenues Change 2,175,465 9.2% 2,304,243 5.9% 2,261,968 -1.8% 2,460,342 8.8% 2,735,608 11.2% 2,957,978 8.1% 2,972,805 0.5% 3,235,006 8.8% 2,900,000 -10.4% 3,000,000 3.4%
Fiscal Year 2018 Budget EXPENDITURES BY TYPE - ALL FUNDS
EXPENDITURES
FY 2016 ACTUAL
FY 2017 BUDGET
FY 2017 PROJECTED
FY 2018 BUDGET
FY 2018 Budget vs FY 2017 Projected Budget
Personnel Services
9,104,900
9,624,014
9,377,749
10,066,836
7%
5%
Insurance and Benefits
3,848,176
4,344,961
4,169,619
4,252,869
2%
-2%
Professional Services
3,521,490
3,649,007
3,915,933
3,682,813
-6%
1%
Contractual Services
2,847,840
3,872,737
3,642,807
3,919,334
8%
1%
Communication
337,741
383,708
385,753
404,296
5%
5%
Professional Development
128,174
173,230
172,500
188,249
9%
9%
Operating Supplies
459,519
632,160
613,905
483,440
-21%
-24%
3,465,599
8,281,380
8,550,698
27,639,800
223%
234%
11,240,548
2,986,894
3,231,425
3,708,016
15%
24%
3,454,697
3,434,970
4,069,600
4,533,452
11%
32%
38,408,684
37,383,060
38,129,989
58,879,105
54%
58%
Capital Outlay Transfers Debt Service TOTAL EXPENSES
Fiscal Year 2018 Budget The Budget includes funding to provide for;
Normal operations Shared Facilities Manager $27,639,800 in capital improvements $4,533,452 for debt service Community/business conversations Increased storm sewer maintenance Increase for pavement markings Continued tree purchases for EAB replacement Regional positioning implementation Special events Economic development Contracted IT support ERP implementation TIF District development Water/sewer operations Water/sewer improvements of $1,250,000 Garbage collection Vehicle replacements Pension contributions
Fiscal Year 2018 Capital Improvements Budget
Fiscal Year 2018 Capital Improvements Budget $ 590,000 $23,000,000 $ 1,600,000 $ 644,800 $ 60,000 $ 110,000 $ 125,000 $ 80,000 $ 45,000 $ 400,000 $ 85,000 $ 300,000
ERP Implementation Police Headquarters Construction Annual Road Program Wolf’s Crossing Phase One Engineering Public Works salt dome roof repairs Police squad car mobile computer upgrade Sewer Lining Kendall Point Tower removal Water Tower washing Future Water Plant Vehicle and Equipment Downtown Parking Lot (TIF)
Fiscal Year 2018 Budget Detail GENERAL FUND FUND SUMMARY FY 2018 Budget vs FY 2017 FY 2018 BUDGET Projected Budget 6,780,503 1% 1%
FY 2016 ACTUAL 7,143,645
FY 2017 BUDGET 6,726,461
FY 2017 PROJECTED 6,726,461
REVENUES Taxes Charges for Services Licenses and Permits Grants Fines and Forfeitures Franchise Fees Donations/Contributions Transfers In Interest Miscellaneous
14,939,756 507,221 620,058 65,925 291,922 545,401 215,710 5,898 18,630 60,375
15,142,201 616,450 696,800 65,000 307,100 549,002 146,000 0 16,000 3,500
14,671,075 495,700 565,600 50,000 181,100 565,500 155,250 0 22,000 23,100
14,779,500 616,006 574,300 50,000 181,000 592,500 143,381 700,000 20,000 5,100
1% 24% 2% 0% 0% 5% -8% 100% -9% -78%
-2% 0% -18% -23% -41% 8% -2% 100% 25% 46%
TOTAL REVENUE
17,270,895
17,542,053
16,729,325
17,661,787
6%
1%
EXPENDITURES General Corporate Building and Zoning Community Development Road and Bridge Community Relations Economic Development Finance Technology Police
1,575,353 713,457 593,607 3,184,640 265,602 197,076 708,311 0 8,938,046
1,368,051 711,504 553,170 1,938,395 364,092 214,471 647,284 537,652 9,519,473
1,299,837 696,979 449,753 1,920,637 367,541 140,273 516,311 480,948 9,201,210
1,440,430 729,783 471,410 2,123,965 367,846 208,177 531,105 838,388 9,501,387
11% 5% 5% 11% 0% 48% 3% 74% 3%
5% 3% -15% 10% 1% -3% -18% 56% 0%
Operating Expenditures
16,176,091
15,854,093
15,073,489
16,212,491
8%
2%
1,094,804
1,687,960
1,655,836
1,449,296
-12%
-14%
(1,511,989)
(1,491,894)
(1,601,794)
(1,438,316)
-10%
-4%
0%
-2%
Beginning Fund Balance
Revenues Over/Under Expenditures Other Financing Sources/(Uses) Change in Fund Balance Ending Fund Balance
(417,185) 6,726,461
196,066
54,042
10,980
6,922,527
6,780,503
6,791,483
Fiscal Year 2018 Budget Detail GENERAL FUND EXPENDITURES BY TYPE-ALL DEPARTMENTS FY 2017 BUDGET
FY 2017 PROJECTED
FY 2018 BUDGET
6,877,483 265,611 345,451 16,450
7,412,628 155,327 356,099 17,000
7,030,272 204,600 382,160 17,000
7,679,306 171,595 387,091 17,000
9% -16% 1% 0%
4% 10% 9% 0%
Total Personnel Services
7,504,994
7,941,054
7,634,032
8,254,992
8%
4%
Insurance and Benefits
3,400,948
3,870,463
3,721,674
3,789,662
2%
-2%
Professional Services
958,122
889,007
823,457
873,813
6%
-2%
Contractual Services
1,581,866
2,268,338
2,037,218
2,370,939
16%
5%
Communication
273,844
318,041
314,653
338,196
7%
6%
Professional Development
119,933
153,930
154,300
169,549
10%
10%
Operating Supplies
337,491
413,260
388,155
415,340
7%
1%
1,998,892
0
0
0
0%
0%
16,176,090
15,854,093
15,073,489
16,212,491
8%
2%
EXPENDITURES Personnel Services Salaries Full-Time Salaries Part-Time Overtime Stipends
Capital Outlay Total Operating Expenditures
FY 2016 ACTUAL
FY 2018 Budget vs FY 2017 Projected Budget
Fiscal Year 2018 General Fund Departments
FY18 DRAFT BUDGET.pdf
Corporate- pg. 109 Building & zoning- pg. 120 Community development- pg. 128 Road & bridge- pg. 136 Community relations- pg. 150 Economic development- pg. 156 Finance- pg. 162 Information technology- pg. 169 Police- pg. 175
Fiscal Year 2018 Budget MOTOR FUEL TAX FUND (02) FY 2016 ACTUAL
FY 2017 BUDGET
FY 2017 PROJECTED
FY 2018 BUDGET
FY 2018 Budget vs FY 2017 Projected Budget
Beginning Fund Balance
692,430
906,115
906,115
917,615
1%
1%
REVENUES State Allotments Other Interest Income TOTAL REVENUE
845,024 45,031 2,634 892,689
800,000 1,250 801,250
850,000
850,000
0%
6%
4,000 854,000
4,000 854,000
0% 0%
220% 7%
EXPENDITURES Public Improvements Transfer to Debt Service Fund TOTAL EXPENDITURES
416,504 262,500 679,004
600,000 262,500 862,500
580,000 262,500 842,500
900,000 262,500 1,162,500
55% 0% 38%
50% 0% 35%
Revenues Over/Under Expenditures
213,685
(61,250)
11,500
(308,500) -2783%
404%
Other Financing Sources/(Uses)
0
0
0
Change in Fund Balance
213,685
(61,250)
11,500
Ending Fund Balance
906,115
844,865
917,615
0
0%
0%
(308,500) -2783%
404%
609,115
-34%
-28%
Fiscal Year 2018 Budget TAX INCREMENT FINANCING FUND (03) FY 2017 BUDGET Beginning Fund Balance REVENUES Property tax Interest Income TOTAL REVENUE
0
0 0
FY 2018 Budget vs FY 2017 FY 2017 FY 2018 PROJECTED BUDGET Projected Budget 0
264,500
100%
100%
0 0
40,000 500 40,500
0% 0% 0%
0% 0% 0%
135,000
50,000
100%
500 1,600,000
500 300,000
100% 100%
1,735,500
350,500
EXPENDITURES Professional Services Contractual Services Communication Public Improvements TOTAL EXPENDITURES
0
0
3
Revenues Over/Under Expenditures 0
(1,735,500) (310,000) 0
-82%
-100%
0%
0%
Other Financing Sources/(Uses)
0
2,000,000
Change in Fund Balance
0
264,500
(310,000)
-217%
-100%
Ending Fund Balance
0
264,500
(45,500)
-117%
-100%
Fiscal Year 2018 Budget
DEBT SERVICE FUND (20) FY 2016 ACTUAL
FY 2018 Budget vs FY 2017 Projected Budget
FY 2017 FY 2017 FY 2018 BUDGET PROJECTED BUDGET
Beginning Fund Balance
63,494
65,965
65,965
69,265
5%
5%
REVENUES Transfer In - Other Funds Transfer In - MFT Fund Interest TOTAL REVENUE
1,511,989 262,500 84 1,774,573
1,491,894 262,500 200 1,754,594
2,126,525 262,500 1,500 2,390,525
2,660,516 262,500 300 2,923,316
25% 0% -80% 22%
78% 0% 100% 67%
EXPENDITURES Registrar/Paying Agent Fees Debt Service-Principal Debt Service-Interest TOTAL EXPENDITURES
1,612 1,305,000 465,489 1,772,101
4,000 1,340,000 410,394 1,754,394
2,200 1,340,000 1,045,025 2,387,225
2,200 1,335,000 1,585,644 2,922,844
0% 0% 52% 22%
-45% 0% 286% 67%
2,471
200
3,300
472
-86%
100%
-
-
-
-
0%
0%
2,471
200
3,300
472
65,965
66,166
69,265
69,737
1%
5%
Revenues Over/Under Expenditures Other Financing Source/Use Change in Fund Balance Ending Fund Balance
Fiscal Year 2018 Budget CAPITAL IMPROVEMENT FUND (06)
FY 2016 ACTUAL 257,558
Beginning Fund Balance REVENUES Local Sales tax 885,706 Charges for Service Impact Fees Grant Proceeds 349 Interest 876 TOTAL REVENUE 886,931 EXPENDITURES Professional Services Paying Agent Fees Capital Improvements Annual Road Program 11,250 Bridge repairs 11,750 Computer Systems (PD Vehicles) Downtown Brick Pavers IL 71-Village Share (IDOT) Mill Rd Expense 117 Minkler Rd Bridge Repair Other Capital Outlay 131,797 Paths & Sidewalk Connections Police Facility (New) 59,812 US 30 - Village Share (IDOT) Rt 34 from W Village Limits to Salt Dome Roof Repair Sidewalk Replacements Stormwater Improvements Streetlights LED Conversion Downtown Parking Lot Holiday Lights Village Hall Expenditures 130,311 Wolf's Crossing Rd TOTAL EXPENDITURES 345,037 Revenues Over/Under Expenditures 541,894 Other Financing Source/Use Transfer to General Fund Transfer In - Escrow Transfer In - General Fund Transfer to Vehicle Fund Transfer to Debt Service Fund Bond Proceeds (net of issuance) TOTAL Ending Fund Balance 799,452 Reserved Fund Balance, Police Headquarters Reserved Fund Balance, Wolf's Crossing Rd Unreserved Fund Balance
FY 2017 FY 2017 FY 2018 BUDGET PROJECTED BUDGET 799,452 799,452 28,921,527 2,900,000 564,559 150,000 2,500 3,617,059
-
2,900,000 3,400 83,000 2,986,400
353,076
2,900,000 30,000 2,930,000
-
FY 2018 Budget vs FY 2017 Projected Budget 3518% 3518% 0% -100% 0% 0% -64% -2%
100% 0% -100% -100% 1100% -19%
-100%
0%
1,400,000 105,000 120,000 88,000 38,100 2,300,000
1,400,000 105,000 120,000 10,008 2,300,000
700,000 110,000 23,000,000
-50% 0% 100% -100% -100% -100% 0% 0% 0% 900%
-50% 0% 100% -100% -100% 0% -100% 0% -100% 900%
113,600 27,500 40,000 50,500
56,600 34,400 -
60,000 -
-100% 100% -100% 0%
-100% 118% -100% -100%
525,000 1,636,000 6,443,700
525,000 787,800 5,691,884
590,000 644,800 25,104,800
12% -18% 341%
12% -61% 290%
720%
684%
(700,000) -
100% -100%
100% -100%
(500,000) (50,000) (634,631) (1,222,200) 30,988,607 30,827,559 (1,972,200) 28,921,527 4,774,527 28,133,976 5,133,976 185,783 0 601,768 (359,449)
-90% 93% -100% -106% -83%
-90% 100% -100% -106% -83%
(2,826,641) 970,000 (500,000) 30,000,000 30,470,000 28,442,811
(2,705,484) (22,174,800) 973,583
Fiscal Year 2018 Budget WATER AND SEWER FUND (05) FUND SUMMARY
Beginning Unrestricted Net Assets REVENUES Charges for Services Permits Grants Interest Donations/Contributions Transfers In Miscellaneous TOTAL REVENUE EXPENSES Personnel Services Insurance and Benefits Professional Services Contractual Services Communication Professional Development Operating Supplies Debt Service TOTAL EXPENSES Change in Unrestricted Net Assets Other Financing Source/Use Net Change to Unrestricted Net Assets Transfer to Water & Sewer Capital Transfer to Vehicle Fund Total Other Financing Source/Use Ending Unrestricted Net Assets
FY 2017 FY 2017 BUDGET PROJECTED 237,950 237,950
FY 2018 Budget vs FY 2017 FY 2018 BUDGET Projected Budget (8,581) -104% -104%
5,000,678 360 90,270 39,486 43,743 648,502 380 5,823,419
5,090,500 300 86,000 6,000 8,000 0 0 5,190,800
5,079,175 200 85,000 17,000 12,700 0 70 5,194,145
5,068,000 200 78,000 17,000 9,100 0 0 5,172,300
0% 0% -8% 0% -28% 0% -100% 0%
0% -33% -9% 183% 14% 0% 0% 0%
1,081,927 447,229 72,756 1,265,974 63,897 6,005 116,801 1,684,208 4,738,797 1,084,622
1,148,960 474,498 163,800 1,604,399 65,667 15,400 77,900 1,684,575 5,235,199 (44,399)
1,135,717 447,945 163,700 1,605,589 70,600 15,400 84,650 1,684,575 5,208,176 (14,031)
1,184,844 463,207 214,300 1,548,395 65,600 15,400 62,600 1,612,808 5,167,154 5,146
4% 3% 31% -4% -7% 0% -26% -4% -1%
3% -2% 31% -3% 0% 0% -20% -4% -1%
(500,000) (232,500) (732,500) (538,949)
0 (232,500) (232,500) (8,581)
0% -85% -85% 348%
-100% -85% -95% -93%
FY 2016 ACTUAL 8,619,387
(3,538,353) (5,927,706) (9,466,059) 237,950
0 (35,000) (35,000) (38,435)
Fiscal Year 2018 Budget WATER & SEWER CAPITAL FUND (04)
FY 2016 ACTUAL Beginning Fund Balance
FY 2017 FY 2017 FY 2018 BUDGET PROJECTED BUDGET
0 5,646,461
FY 2018 Budget vs FY 2017 Projected Budget
5,646,461
5,360,761
-5%
-5%
REVENUES Charges for Service Meter Tap on Fees MXU Fees Total Charges for Service
330,530 43,130 373,660
220,000 70,000 290,000
110,000 30,000 140,000
110,000 30,000 140,000
0% 0% 0%
-50% -57% -52%
Interest TOTAL REVENUE
50,262 423,922
6,000 296,000
30,000 170,000
20,000 160,000
-33% -6%
233% -46%
100,000 35,000 135,000
100,000 35,000 135,000
-
0% 0% 0%
-100% -100% -100%
-
0%
0%
0% 0% 0% 78% -100% 100% 100% 100% 100% 0% 0% 290% 290% 174%
0% 0% 0% 56% -100% 100% 100% 100% 100% 0% -100% 139% 139% 90%
282%
200%
EXPENDITURES Water Meter Supplies Water Meters for New Homes & Commercial Development Water Meter Replacements Total Water Meter Supplies Capital Improvements Vehicle Purchase Utility System Improvements Generator Installation US Route 34 Water Main Relocation Alternative Water Source Study Sanitary Sewer Lining Program SCADA Replacements/Lift Stations Water Meter & Reader Replacement Water Tower Demolition-Kendall Point Water Tower Washing Water Plant Improvements Orchard Rd Loop/Booster Station Downtown Development site Utility System Improvements Total: Total Capital Improvements TOTAL EXPENDITURES Revenues Over/Under Expenditures
122,240 140,000 192,192 13,518 67,387 169,830 582,927 705,167 705,167
80,000 335,000 109,000 524,000 524,000 659,000
(281,245) (363,000)
70,400 250,300 320,700 320,700 455,700
125,000 0 600,000 80,000 45,000 400,000 1,250,000 1,250,000 1,250,000
(285,700) (1,090,000)
Other Financing Source/Use Transfer From Water & Sewer Fund
5,927,706
500,000
-
-
0
-100%
Ending Fund Balance
5,646,461 5,783,461
5,360,761
4,270,761
-20%
-26%
Fiscal Year 2018 Budget GARBAGE COLLECTION FUND (08) FY 2016 ACTUAL Beginning Net Assets
FY 2017 FY 2017 BUDGET PROJECTED
FY 2018 Budget vs FY 2017 FY 2018 BUDGET Projected Budget
521,713
513,437
513,437
524,337
2%
2%
Charges for Services Disposal Fees Waste Stickers and Bins
2,405,709 1,241
2,500,000 1,200
2,359,000 1,200
2,450,000 1,200
4% 0%
-2% 0%
Total Charges for Services
2,406,950
2,501,200
2,360,200
2,451,200
4%
-2%
682
750
700
500
-29%
-33%
2,407,632
2,501,950
2,360,900
2,451,700
4%
-2%
2,414,409 1,500
2,500,000 1,200
2,350,000
2,450,000
4% 0%
-2% -100%
2,415,909
2,501,200
2,350,000
2,450,000
4%
-2%
750
10,900
1,700
-84%
127%
-
-
0%
0%
750
10,900
1,700
-84%
127%
514,187
524,337
526,037
0%
2%
REVENUES
Interest TOTAL REVENUE EXPENSES Professional Services Disposal Service Waste Stickers and Bins TOTAL EXPENSES Revenues Over/Under Expenditures Other Financing/ (Uses) Change in Fund Balance Ending Net Assets
(8,276) (8,276) 513,437
-
Fiscal Year 2018 Budget VEHICLE FUND (11) FY 2017 BUDGET
FY 2017 PROJECTED
FY 2018 BUDGET
FY 2018 Budget vs FY 2017 Projected Budget
Beginning Net Assets
-
-
37,610
REVENUES Asset Sales Interest TOTAL REVENUE
-
15,000 1,300 16,300
5,000 400 5,400
-67% -69% -67%
100% 100% 100%
EXPENDITURES General Fund Purchases Vehicle Purchase B&Z Vehicle Purchase R&B Vehicle Purchase Police Equipment R&B Total General Funds
27,000 162,500 190,680 101,000 481,180
25,000 162,500 190,680 100,755 478,935
20,000 30,000 50,000
-100% -100% -90% -70% -90%
-100% -100% -90% -70% -90%
Water & Sewer Purchases Vehicle Purchase W&S Equipment W&S Total Water & Sewer
131,500 101,000 232,500
131,500 100,755 232,255
35,000 35,000
-73% -100% -85%
-73% -100% -85%
TOTAL EXPENDITURES
713,680
711,190
85,000
-88%
-88%
(713,680)
(694,890)
(79,600)
-89%
-89%
500,000 232,500 732,500
500,000 232,500 732,500
50,000 35,000 85,000
-90% -85% -88%
-90% -85% -88%
Change in Fund Balance
18,820
37,610
5,400
-86%
-71%
Ending Net Assets
18,820
37,610
43,010
14%
129%
Revenues Over/Under Expenditures Other Financing Source (Use) Transfer from Capital Improvement Fund Transfer from Water & Sewer Fund Total Other Financing Source/Use
Fiscal Year 2018 Budget POLICE OFFICERS' PENSION FUND (21) FY 2016 ACTUAL Beginning Net Assets
FY 2018 Budget vs FY 2017 FY 2017 FY 2017 FY 2018 Projected Budget BUDGET PROJECTED BUDGET
21,245,030 22,553,626
22,553,626 25,171,059
12%
12%
REVENUES Employer Contribution Property Taxes Village Contribution Total Employer Contribution Employee Contributions Interest Income TOTAL REVENUES
1,181,869 68,131 1,250,000 425,332 231,796 1,907,128
1,219,638 330,362 1,550,000 440,000 200,000 2,190,000
1,219,638 330,362 1,550,000 422,833 1,350,000 3,322,833
1,278,500 121,500 1,400,000 443,100 400,000 2,243,100
5% -63% -10% 5% -70% -32%
5% -63% -10% 1% 100% 2%
EXPENDITURES Benefits Refunds Legal Services Accounting Expense Investment Expense Professional Development Operating Supplies TOTAL EXPENDITURES
513,505 4,474 2,436 10,760 59,895 2,237 5,226 598,532
534,000 5,000 16,000 70,000 3,900 6,000 634,900
608,000 1,500 15,000 72,000 2,800 6,100 705,400
627,000 1,500 15,000 76,000 3,300 5,500 728,300
3% 0% 0% 0% 6% 18% -10% 3%
17% 0% -70% -6% 9% -15% -8% 15%
1,308,596
1,555,100
2,617,433
1,514,800
-42%
-3%
2,617,433
1,514,800
-42%
-3%
25,171,059 26,685,859
6%
11%
Revenues Over/Under Expenditures Other Finacing Sources/(Uses) Change in Fund Balance Ending Net Assets
1,308,596
1,555,100
22,553,626 24,108,726
Fiscal Year 2018 Budget Next steps March 21st- More Budget discussion (if necessary) and Capital Improvement Plan review
April 11th- Public Hearing on Fiscal Year 2018 Village Budget April 18th- Adopt Fiscal Year 2018 Village Budget April 18th- Adopt Capital Improvement Plan
Fiscal Year 2018 Budget
Fiscal Year 2017 Summary FUND General Motor Fuel Tax Tax Increment Financing Debt Service Capital Improvement Water and Sewer Water and Sewer Capital Garbage Collection Vehicle Police Pension TOTAL
Budget Revenues Expenditures
Difference Rev/Exp
Projected Revenues Expenditures
Difference Rev/Exp
17,542,053 801,250 0 1,754,594 34,587,059 5,190,800 796,000 2,501,950 732,500 2,190,000
17,345,988 862,500 0 1,754,394 6,943,700 5,967,699 659,000 2,501,200 713,680 634,900
196,065 -61,250 0 200 27,643,359 -776,899 137,000 750 18,820 1,555,100
16,729,325 854,000 0 2,390,525 34,948,590 5,194,145 170,000 2,360,900 748,800 3,322,833
16,675,283 842,500 1,735,500 2,387,225 6,826,515 5,940,676 455,700 2,350,000 711,190 705,400
54,042 11,500 -1,735,500 3,300 28,122,075 -746,531 -285,700 10,900 37,610 2,617,433
66,096,206
37,383,061
28,713,145
66,719,118
38,629,989
28,089,129
Fiscal Year 2018 Budget Fund
Budget Year Comparison Summary - All Funds Fiscal Year Fiscal Year 2018 2018 Revenues Expenditures
Fiscal Year 2018 Difference
Major Governmental Funds General Fund
$17,661,787
$17,650,807
Capital Improvement Fund Debt Service Fund
$2,930,000 $2,923,316
$27,077,000 $2,922,844
($24,147,000) $472
$23,515,103
$47,650,651
($24,135,548)
$854,000 $40,500
$1,162,500 $350,500
($308,500) ($310,000)
$894,500
$1,513,000
($618,500)
$5,172,300
$5,202,154
($29,854)
$160,000
$1,250,000
($1,090,000)
$2,451,700
$2,450,000
$1,700
$90,400
$85,000
$5,400
$7,874,400 $32,284,003
$8,987,154 $58,150,805
$2,343,100
$728,300
$1,614,800
Total Fiduciary Funds
$2,343,100
$728,300
$1,614,800
Total Non Operating Funds
$2,343,100
$728,300
$1,614,800
$34,627,103
$58,879,105
Total Major Governmental Funds
$10,980
Non-Major Governmental Funds Motor Fuel Tax Fund Tax Increment Financing Total Non Major Governmental Funds Proprietary Funds Enterprise Funds Waterworks & Sewer Fund Waterworks & Sewer Capital Fund Garbage Fund Internal Service Funds Vehicle Fund Total Proprietary Funds Total Operating Funds
($1,112,754) ($25,866,802)
Non Operating Funds Fiduciary Funds Police Officers' Pension Fund
Total All Funds
($24,252,002)
Fiscal Year 2018 Budget REVENUES - ALL FUNDS
FUND
FY 2016 ACTUAL
General
17,270,896 17,542,053
Motor Fuel Tax Tax Increment Financing Debt Service Capital Improvement
FY 2017 FY 2017 FY 2018 BUDGET PROJECTED BUDGET 16,729,325 17,661,787
FY 2018 Budget vs FY 2017 Projected Budget 6%
1%
892,689
801,250
854,000
854,000
0%
7%
0
0
0
40,500
100%
100%
1,774,573
1,754,594
2,390,525
2,923,316
22%
67%
886,931 34,587,059
34,948,590
2,930,000
-92%
-92%
Water and Sewer
5,823,419
5,190,800
5,194,145
5,172,300
0%
0%
Water and Sewer Capital
6,351,628
796,000
170,000
160,000
-6%
-80%
Garbage Collection
2,407,632
2,501,950
2,360,900
2,451,700
4%
-2%
0
732,500
748,800
90,400
-88%
-88%
1,907,128
2,190,000
3,322,833
2,243,100
-32%
2%
66,719,118 34,527,103
-48%
-48%
Vehicle Police Pension TOTAL REVENUES
37,314,896 66,096,206
Fiscal Year 2018 Budget EXPENDITURES - ALL FUNDS
FUND General Motor Fuel Tax Tax Increment Financing Debt Service Capital Improvement Water and Sewer Water and Sewer Capital Garbage Collection Vehicle Police Pension TOTAL EXPENSES
FY 2016 ACTUAL
FY 2018 Budget vs FY 2017 Projected Budget
FY 2017 BUDGET
FY 2017 PROJECTED
FY 2018 BUDGET
17,688,079
17,345,988
16,675,283
17,650,807
6%
2%
679,004
862,500
842,500
1,162,500
38%
35%
0
0
1,735,500
350,500
-80%
100%
1,772,101
1,754,394
2,387,225
2,922,844
22%
67%
345,037
6,943,700
6,826,515
27,077,000 297%
290%
10,666,503
5,967,699
5,940,676
705,167
659,000
455,700
2,415,909
2,501,200
0
5,202,154
-12%
-13%
1,250,000 174%
90%
2,350,000
2,450,000
4%
-2%
713,680
711,190
85,000
-88%
-88%
598,532
634,900
705,400
728,300
3%
15%
34,870,331
37,383,060
38,629,989
58,879,105
52%
58%
Fiscal Year 2018 Budget REVENUES BY SOURCE - ALL FUNDS FY 2018 Budget FY 2017 FY 2018 vs FY 2017 PROJECTED BUDGET Projected Budget
REVENUES
FY 2016 ACTUAL
FY 2017 BUDGET
Taxes
17,007,331
19,261,839
Charges for Services
8,288,509
8,498,150
8,078,475
Licenses and Permits
620,418
697,100
1,001,568
Fines and Forfeitures
1%
-1%
8,275,206
2%
-3%
565,800
574,500
2%
-18%
1,101,000
985,000
978,000
-1%
-11%
291,922
307,100
181,100
181,000
0%
-41%
Franchise Fees
545,401
1,113,561
565,500
592,500
5%
-47%
Donations/ Contributions
752,916
924,362
936,145
722,081
-23%
-22%
8,356,595
3,956,894
4,095,108
3,708,016
-9%
-6%
344,449
232,700
1,509,500
492,700
-67%
112%
0
30,000,000
30,988,607
0
-100%
-100%
105,786
3,500
23,170
5,100
-78%
46%
37,314,896
66,096,206
66,719,118 34,527,103
-48%
-48%
Grants/Intergovernmental
Transfers From Other Funds Interest Bond Proceeds Miscellaneous TOTAL REVENUE
18,790,713 18,998,000
Fiscal Year 2018 Budget General Fund $7,000,000
Sales Tax Revenue Sales Tax Revenue
Sales Tax Fiscal Year Revenue % Change FY 2009 4,501,565 -4.2% FY 2010 4,829,238 7.3% FY 2011 4,892,537 1.3% FY 2012 5,183,713 6.0% FY 2013 5,331,846 2.9% FY 2014 5,519,552 3.5% FY 2015 5,729,920 3.8% FY 2016 6,047,817 5.5% FY 2017* 6,000,000 -0.8% FY 2018* 6,100,000 1.7% *Projected
$6,000,000 $5,000,000 $4,000,000
$3,000,000 $2,000,000 $1,000,000 $0
* Projected
Fiscal Year 2018 Budget General Fund
Income Tax Revenue Income Tax Revenue
Fiscal Year 2009 2010 2011 2012 2013 2014 2015 2016 2017* 2018*
$3,500,000
$3,000,000 $2,500,000 $2,000,000
$1,500,000 $1,000,000 $500,000
* Projected
Income Tax % Revenues Change 2,175,465 9.2% 2,304,243 5.9% 2,261,968 -1.8% 2,460,342 8.8% 2,735,608 11.2% 2,957,978 8.1% 2,972,805 0.5% 3,235,006 8.8% 2,900,000 -10.4% 3,000,000 3.4%
Fiscal Year 2018 Budget EXPENDITURES BY TYPE - ALL FUNDS
EXPENDITURES
FY 2016 ACTUAL
FY 2017 BUDGET
FY 2017 PROJECTED
FY 2018 BUDGET
FY 2018 Budget vs FY 2017 Projected Budget
Personnel Services
9,104,900
9,624,014
9,377,749
10,066,836
7%
5%
Insurance and Benefits
3,848,176
4,344,961
4,169,619
4,252,869
2%
-2%
Professional Services
3,521,490
3,649,007
3,915,933
3,682,813
-6%
1%
Contractual Services
2,847,840
3,872,737
3,642,807
3,919,334
8%
1%
Communication
337,741
383,708
385,753
404,296
5%
5%
Professional Development
128,174
173,230
172,500
188,249
9%
9%
Operating Supplies
459,519
632,160
613,905
483,440
-21%
-24%
3,465,599
8,281,380
8,550,698
27,639,800
223%
234%
11,240,548
2,986,894
3,231,425
3,708,016
15%
24%
3,454,697
3,434,970
4,069,600
4,533,452
11%
32%
38,408,684
37,383,060
38,129,989
58,879,105
54%
58%
Capital Outlay Transfers Debt Service TOTAL EXPENSES
Fiscal Year 2018 Budget The Budget includes funding to provide for;
Normal operations Shared Facilities Manager $27,639,800 in capital improvements $4,533,452 for debt service Community/business conversations Increased storm sewer maintenance Increase for pavement markings Continued tree purchases for EAB replacement Regional positioning implementation Special events Economic development Contracted IT support ERP implementation TIF District development Water/sewer operations Water/sewer improvements of $1,250,000 Garbage collection Vehicle replacements Pension contributions
Fiscal Year 2018 Capital Improvements Budget
Fiscal Year 2018 Capital Improvements Budget $ 590,000 $23,000,000 $ 1,600,000 $ 644,800 $ 60,000 $ 110,000 $ 125,000 $ 80,000 $ 45,000 $ 400,000 $ 85,000 $ 300,000
ERP Implementation Police Headquarters Construction Annual Road Program Wolf’s Crossing Phase One Engineering Public Works salt dome roof repairs Police squad car mobile computer upgrade Sewer Lining Kendall Point Tower removal Water Tower washing Future Water Plant Vehicle and Equipment Downtown Parking Lot (TIF)
Fiscal Year 2018 Budget Detail GENERAL FUND FUND SUMMARY FY 2018 Budget vs FY 2017 FY 2018 BUDGET Projected Budget 6,780,503 1% 1%
FY 2016 ACTUAL 7,143,645
FY 2017 BUDGET 6,726,461
FY 2017 PROJECTED 6,726,461
REVENUES Taxes Charges for Services Licenses and Permits Grants Fines and Forfeitures Franchise Fees Donations/Contributions Transfers In Interest Miscellaneous
14,939,756 507,221 620,058 65,925 291,922 545,401 215,710 5,898 18,630 60,375
15,142,201 616,450 696,800 65,000 307,100 549,002 146,000 0 16,000 3,500
14,671,075 495,700 565,600 50,000 181,100 565,500 155,250 0 22,000 23,100
14,779,500 616,006 574,300 50,000 181,000 592,500 143,381 700,000 20,000 5,100
1% 24% 2% 0% 0% 5% -8% 100% -9% -78%
-2% 0% -18% -23% -41% 8% -2% 100% 25% 46%
TOTAL REVENUE
17,270,895
17,542,053
16,729,325
17,661,787
6%
1%
EXPENDITURES General Corporate Building and Zoning Community Development Road and Bridge Community Relations Economic Development Finance Technology Police
1,575,353 713,457 593,607 3,184,640 265,602 197,076 708,311 0 8,938,046
1,368,051 711,504 553,170 1,938,395 364,092 214,471 647,284 537,652 9,519,473
1,299,837 696,979 449,753 1,920,637 367,541 140,273 516,311 480,948 9,201,210
1,440,430 729,783 471,410 2,123,965 367,846 208,177 531,105 838,388 9,501,387
11% 5% 5% 11% 0% 48% 3% 74% 3%
5% 3% -15% 10% 1% -3% -18% 56% 0%
Operating Expenditures
16,176,091
15,854,093
15,073,489
16,212,491
8%
2%
1,094,804
1,687,960
1,655,836
1,449,296
-12%
-14%
(1,511,989)
(1,491,894)
(1,601,794)
(1,438,316)
-10%
-4%
0%
-2%
Beginning Fund Balance
Revenues Over/Under Expenditures Other Financing Sources/(Uses) Change in Fund Balance Ending Fund Balance
(417,185) 6,726,461
196,066
54,042
10,980
6,922,527
6,780,503
6,791,483
Fiscal Year 2018 Budget Detail GENERAL FUND EXPENDITURES BY TYPE-ALL DEPARTMENTS FY 2017 BUDGET
FY 2017 PROJECTED
FY 2018 BUDGET
6,877,483 265,611 345,451 16,450
7,412,628 155,327 356,099 17,000
7,030,272 204,600 382,160 17,000
7,679,306 171,595 387,091 17,000
9% -16% 1% 0%
4% 10% 9% 0%
Total Personnel Services
7,504,994
7,941,054
7,634,032
8,254,992
8%
4%
Insurance and Benefits
3,400,948
3,870,463
3,721,674
3,789,662
2%
-2%
Professional Services
958,122
889,007
823,457
873,813
6%
-2%
Contractual Services
1,581,866
2,268,338
2,037,218
2,370,939
16%
5%
Communication
273,844
318,041
314,653
338,196
7%
6%
Professional Development
119,933
153,930
154,300
169,549
10%
10%
Operating Supplies
337,491
413,260
388,155
415,340
7%
1%
1,998,892
0
0
0
0%
0%
16,176,090
15,854,093
15,073,489
16,212,491
8%
2%
EXPENDITURES Personnel Services Salaries Full-Time Salaries Part-Time Overtime Stipends
Capital Outlay Total Operating Expenditures
FY 2016 ACTUAL
FY 2018 Budget vs FY 2017 Projected Budget
Fiscal Year 2018 General Fund Departments
FY18 DRAFT BUDGET.pdf
Corporate- pg. 109 Building & zoning- pg. 120 Community development- pg. 128 Road & bridge- pg. 136 Community relations- pg. 150 Economic development- pg. 156 Finance- pg. 162 Information technology- pg. 169 Police- pg. 175
Fiscal Year 2018 Budget MOTOR FUEL TAX FUND (02) FY 2016 ACTUAL
FY 2017 BUDGET
FY 2017 PROJECTED
FY 2018 BUDGET
FY 2018 Budget vs FY 2017 Projected Budget
Beginning Fund Balance
692,430
906,115
906,115
917,615
1%
1%
REVENUES State Allotments Other Interest Income TOTAL REVENUE
845,024 45,031 2,634 892,689
800,000 1,250 801,250
850,000
850,000
0%
6%
4,000 854,000
4,000 854,000
0% 0%
220% 7%
EXPENDITURES Public Improvements Transfer to Debt Service Fund TOTAL EXPENDITURES
416,504 262,500 679,004
600,000 262,500 862,500
580,000 262,500 842,500
900,000 262,500 1,162,500
55% 0% 38%
50% 0% 35%
Revenues Over/Under Expenditures
213,685
(61,250)
11,500
(308,500) -2783%
404%
Other Financing Sources/(Uses)
0
0
0
Change in Fund Balance
213,685
(61,250)
11,500
Ending Fund Balance
906,115
844,865
917,615
0
0%
0%
(308,500) -2783%
404%
609,115
-34%
-28%
Fiscal Year 2018 Budget TAX INCREMENT FINANCING FUND (03) FY 2017 BUDGET Beginning Fund Balance REVENUES Property tax Interest Income TOTAL REVENUE
0
0 0
FY 2018 Budget vs FY 2017 FY 2017 FY 2018 PROJECTED BUDGET Projected Budget 0
264,500
100%
100%
0 0
40,000 500 40,500
0% 0% 0%
0% 0% 0%
135,000
50,000
100%
500 1,600,000
500 300,000
100% 100%
1,735,500
350,500
EXPENDITURES Professional Services Contractual Services Communication Public Improvements TOTAL EXPENDITURES
0
0
3
Revenues Over/Under Expenditures 0
(1,735,500) (310,000) 0
-82%
-100%
0%
0%
Other Financing Sources/(Uses)
0
2,000,000
Change in Fund Balance
0
264,500
(310,000)
-217%
-100%
Ending Fund Balance
0
264,500
(45,500)
-117%
-100%
Fiscal Year 2018 Budget
DEBT SERVICE FUND (20) FY 2016 ACTUAL
FY 2018 Budget vs FY 2017 Projected Budget
FY 2017 FY 2017 FY 2018 BUDGET PROJECTED BUDGET
Beginning Fund Balance
63,494
65,965
65,965
69,265
5%
5%
REVENUES Transfer In - Other Funds Transfer In - MFT Fund Interest TOTAL REVENUE
1,511,989 262,500 84 1,774,573
1,491,894 262,500 200 1,754,594
2,126,525 262,500 1,500 2,390,525
2,660,516 262,500 300 2,923,316
25% 0% -80% 22%
78% 0% 100% 67%
EXPENDITURES Registrar/Paying Agent Fees Debt Service-Principal Debt Service-Interest TOTAL EXPENDITURES
1,612 1,305,000 465,489 1,772,101
4,000 1,340,000 410,394 1,754,394
2,200 1,340,000 1,045,025 2,387,225
2,200 1,335,000 1,585,644 2,922,844
0% 0% 52% 22%
-45% 0% 286% 67%
2,471
200
3,300
472
-86%
100%
-
-
-
-
0%
0%
2,471
200
3,300
472
65,965
66,166
69,265
69,737
1%
5%
Revenues Over/Under Expenditures Other Financing Source/Use Change in Fund Balance Ending Fund Balance
Fiscal Year 2018 Budget CAPITAL IMPROVEMENT FUND (06)
FY 2016 ACTUAL 257,558
Beginning Fund Balance REVENUES Local Sales tax 885,706 Charges for Service Impact Fees Grant Proceeds 349 Interest 876 TOTAL REVENUE 886,931 EXPENDITURES Professional Services Paying Agent Fees Capital Improvements Annual Road Program 11,250 Bridge repairs 11,750 Computer Systems (PD Vehicles) Downtown Brick Pavers IL 71-Village Share (IDOT) Mill Rd Expense 117 Minkler Rd Bridge Repair Other Capital Outlay 131,797 Paths & Sidewalk Connections Police Facility (New) 59,812 US 30 - Village Share (IDOT) Rt 34 from W Village Limits to Salt Dome Roof Repair Sidewalk Replacements Stormwater Improvements Streetlights LED Conversion Downtown Parking Lot Holiday Lights Village Hall Expenditures 130,311 Wolf's Crossing Rd TOTAL EXPENDITURES 345,037 Revenues Over/Under Expenditures 541,894 Other Financing Source/Use Transfer to General Fund Transfer In - Escrow Transfer In - General Fund Transfer to Vehicle Fund Transfer to Debt Service Fund Bond Proceeds (net of issuance) TOTAL Ending Fund Balance 799,452 Reserved Fund Balance, Police Headquarters Reserved Fund Balance, Wolf's Crossing Rd Unreserved Fund Balance
FY 2017 FY 2017 FY 2018 BUDGET PROJECTED BUDGET 799,452 799,452 28,921,527 2,900,000 564,559 150,000 2,500 3,617,059
-
2,900,000 3,400 83,000 2,986,400
353,076
2,900,000 30,000 2,930,000
-
FY 2018 Budget vs FY 2017 Projected Budget 3518% 3518% 0% -100% 0% 0% -64% -2%
100% 0% -100% -100% 1100% -19%
-100%
0%
1,400,000 105,000 120,000 88,000 38,100 2,300,000
1,400,000 105,000 120,000 10,008 2,300,000
700,000 110,000 23,000,000
-50% 0% 100% -100% -100% -100% 0% 0% 0% 900%
-50% 0% 100% -100% -100% 0% -100% 0% -100% 900%
113,600 27,500 40,000 50,500
56,600 34,400 -
60,000 -
-100% 100% -100% 0%
-100% 118% -100% -100%
525,000 1,636,000 6,443,700
525,000 787,800 5,691,884
590,000 644,800 25,104,800
12% -18% 341%
12% -61% 290%
720%
684%
(700,000) -
100% -100%
100% -100%
(500,000) (50,000) (634,631) (1,222,200) 30,988,607 30,827,559 (1,972,200) 28,921,527 4,774,527 28,133,976 5,133,976 185,783 0 601,768 (359,449)
-90% 93% -100% -106% -83%
-90% 100% -100% -106% -83%
(2,826,641) 970,000 (500,000) 30,000,000 30,470,000 28,442,811
(2,705,484) (22,174,800) 973,583
Fiscal Year 2018 Budget WATER AND SEWER FUND (05) FUND SUMMARY
Beginning Unrestricted Net Assets REVENUES Charges for Services Permits Grants Interest Donations/Contributions Transfers In Miscellaneous TOTAL REVENUE EXPENSES Personnel Services Insurance and Benefits Professional Services Contractual Services Communication Professional Development Operating Supplies Debt Service TOTAL EXPENSES Change in Unrestricted Net Assets Other Financing Source/Use Net Change to Unrestricted Net Assets Transfer to Water & Sewer Capital Transfer to Vehicle Fund Total Other Financing Source/Use Ending Unrestricted Net Assets
FY 2017 FY 2017 BUDGET PROJECTED 237,950 237,950
FY 2018 Budget vs FY 2017 FY 2018 BUDGET Projected Budget (8,581) -104% -104%
5,000,678 360 90,270 39,486 43,743 648,502 380 5,823,419
5,090,500 300 86,000 6,000 8,000 0 0 5,190,800
5,079,175 200 85,000 17,000 12,700 0 70 5,194,145
5,068,000 200 78,000 17,000 9,100 0 0 5,172,300
0% 0% -8% 0% -28% 0% -100% 0%
0% -33% -9% 183% 14% 0% 0% 0%
1,081,927 447,229 72,756 1,265,974 63,897 6,005 116,801 1,684,208 4,738,797 1,084,622
1,148,960 474,498 163,800 1,604,399 65,667 15,400 77,900 1,684,575 5,235,199 (44,399)
1,135,717 447,945 163,700 1,605,589 70,600 15,400 84,650 1,684,575 5,208,176 (14,031)
1,184,844 463,207 214,300 1,548,395 65,600 15,400 62,600 1,612,808 5,167,154 5,146
4% 3% 31% -4% -7% 0% -26% -4% -1%
3% -2% 31% -3% 0% 0% -20% -4% -1%
(500,000) (232,500) (732,500) (538,949)
0 (232,500) (232,500) (8,581)
0% -85% -85% 348%
-100% -85% -95% -93%
FY 2016 ACTUAL 8,619,387
(3,538,353) (5,927,706) (9,466,059) 237,950
0 (35,000) (35,000) (38,435)
Fiscal Year 2018 Budget WATER & SEWER CAPITAL FUND (04)
FY 2016 ACTUAL Beginning Fund Balance
FY 2017 FY 2017 FY 2018 BUDGET PROJECTED BUDGET
0 5,646,461
FY 2018 Budget vs FY 2017 Projected Budget
5,646,461
5,360,761
-5%
-5%
REVENUES Charges for Service Meter Tap on Fees MXU Fees Total Charges for Service
330,530 43,130 373,660
220,000 70,000 290,000
110,000 30,000 140,000
110,000 30,000 140,000
0% 0% 0%
-50% -57% -52%
Interest TOTAL REVENUE
50,262 423,922
6,000 296,000
30,000 170,000
20,000 160,000
-33% -6%
233% -46%
100,000 35,000 135,000
100,000 35,000 135,000
-
0% 0% 0%
-100% -100% -100%
-
0%
0%
0% 0% 0% 78% -100% 100% 100% 100% 100% 0% 0% 290% 290% 174%
0% 0% 0% 56% -100% 100% 100% 100% 100% 0% -100% 139% 139% 90%
282%
200%
EXPENDITURES Water Meter Supplies Water Meters for New Homes & Commercial Development Water Meter Replacements Total Water Meter Supplies Capital Improvements Vehicle Purchase Utility System Improvements Generator Installation US Route 34 Water Main Relocation Alternative Water Source Study Sanitary Sewer Lining Program SCADA Replacements/Lift Stations Water Meter & Reader Replacement Water Tower Demolition-Kendall Point Water Tower Washing Water Plant Improvements Orchard Rd Loop/Booster Station Downtown Development site Utility System Improvements Total: Total Capital Improvements TOTAL EXPENDITURES Revenues Over/Under Expenditures
122,240 140,000 192,192 13,518 67,387 169,830 582,927 705,167 705,167
80,000 335,000 109,000 524,000 524,000 659,000
(281,245) (363,000)
70,400 250,300 320,700 320,700 455,700
125,000 0 600,000 80,000 45,000 400,000 1,250,000 1,250,000 1,250,000
(285,700) (1,090,000)
Other Financing Source/Use Transfer From Water & Sewer Fund
5,927,706
500,000
-
-
0
-100%
Ending Fund Balance
5,646,461 5,783,461
5,360,761
4,270,761
-20%
-26%
Fiscal Year 2018 Budget GARBAGE COLLECTION FUND (08) FY 2016 ACTUAL Beginning Net Assets
FY 2017 FY 2017 BUDGET PROJECTED
FY 2018 Budget vs FY 2017 FY 2018 BUDGET Projected Budget
521,713
513,437
513,437
524,337
2%
2%
Charges for Services Disposal Fees Waste Stickers and Bins
2,405,709 1,241
2,500,000 1,200
2,359,000 1,200
2,450,000 1,200
4% 0%
-2% 0%
Total Charges for Services
2,406,950
2,501,200
2,360,200
2,451,200
4%
-2%
682
750
700
500
-29%
-33%
2,407,632
2,501,950
2,360,900
2,451,700
4%
-2%
2,414,409 1,500
2,500,000 1,200
2,350,000
2,450,000
4% 0%
-2% -100%
2,415,909
2,501,200
2,350,000
2,450,000
4%
-2%
750
10,900
1,700
-84%
127%
-
-
0%
0%
750
10,900
1,700
-84%
127%
514,187
524,337
526,037
0%
2%
REVENUES
Interest TOTAL REVENUE EXPENSES Professional Services Disposal Service Waste Stickers and Bins TOTAL EXPENSES Revenues Over/Under Expenditures Other Financing/ (Uses) Change in Fund Balance Ending Net Assets
(8,276) (8,276) 513,437
-
Fiscal Year 2018 Budget VEHICLE FUND (11) FY 2017 BUDGET
FY 2017 PROJECTED
FY 2018 BUDGET
FY 2018 Budget vs FY 2017 Projected Budget
Beginning Net Assets
-
-
37,610
REVENUES Asset Sales Interest TOTAL REVENUE
-
15,000 1,300 16,300
5,000 400 5,400
-67% -69% -67%
100% 100% 100%
EXPENDITURES General Fund Purchases Vehicle Purchase B&Z Vehicle Purchase R&B Vehicle Purchase Police Equipment R&B Total General Funds
27,000 162,500 190,680 101,000 481,180
25,000 162,500 190,680 100,755 478,935
20,000 30,000 50,000
-100% -100% -90% -70% -90%
-100% -100% -90% -70% -90%
Water & Sewer Purchases Vehicle Purchase W&S Equipment W&S Total Water & Sewer
131,500 101,000 232,500
131,500 100,755 232,255
35,000 35,000
-73% -100% -85%
-73% -100% -85%
TOTAL EXPENDITURES
713,680
711,190
85,000
-88%
-88%
(713,680)
(694,890)
(79,600)
-89%
-89%
500,000 232,500 732,500
500,000 232,500 732,500
50,000 35,000 85,000
-90% -85% -88%
-90% -85% -88%
Change in Fund Balance
18,820
37,610
5,400
-86%
-71%
Ending Net Assets
18,820
37,610
43,010
14%
129%
Revenues Over/Under Expenditures Other Financing Source (Use) Transfer from Capital Improvement Fund Transfer from Water & Sewer Fund Total Other Financing Source/Use
Fiscal Year 2018 Budget POLICE OFFICERS' PENSION FUND (21) FY 2016 ACTUAL Beginning Net Assets
FY 2018 Budget vs FY 2017 FY 2017 FY 2017 FY 2018 Projected Budget BUDGET PROJECTED BUDGET
21,245,030 22,553,626
22,553,626 25,171,059
12%
12%
REVENUES Employer Contribution Property Taxes Village Contribution Total Employer Contribution Employee Contributions Interest Income TOTAL REVENUES
1,181,869 68,131 1,250,000 425,332 231,796 1,907,128
1,219,638 330,362 1,550,000 440,000 200,000 2,190,000
1,219,638 330,362 1,550,000 422,833 1,350,000 3,322,833
1,278,500 121,500 1,400,000 443,100 400,000 2,243,100
5% -63% -10% 5% -70% -32%
5% -63% -10% 1% 100% 2%
EXPENDITURES Benefits Refunds Legal Services Accounting Expense Investment Expense Professional Development Operating Supplies TOTAL EXPENDITURES
513,505 4,474 2,436 10,760 59,895 2,237 5,226 598,532
534,000 5,000 16,000 70,000 3,900 6,000 634,900
608,000 1,500 15,000 72,000 2,800 6,100 705,400
627,000 1,500 15,000 76,000 3,300 5,500 728,300
3% 0% 0% 0% 6% 18% -10% 3%
17% 0% -70% -6% 9% -15% -8% 15%
1,308,596
1,555,100
2,617,433
1,514,800
-42%
-3%
2,617,433
1,514,800
-42%
-3%
25,171,059 26,685,859
6%
11%
Revenues Over/Under Expenditures Other Finacing Sources/(Uses) Change in Fund Balance Ending Net Assets
1,308,596
1,555,100
22,553,626 24,108,726
Fiscal Year 2018 Budget Next steps March 21st- More Budget discussion (if necessary) and Capital Improvement Plan review
April 11th- Public Hearing on Fiscal Year 2018 Village Budget April 18th- Adopt Fiscal Year 2018 Village Budget April 18th- Adopt Capital Improvement Plan
Fiscal Year 2018 Budget
