Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
03-13-2023 COW Agenda and Packet
Committee of the Whole Workshop of the President and the Board of Trustees Monday, March 13, 2023 7:00 PM 24401 W. Lockport Street Plainfield, IL 60544 In the Boardroom Agenda A.CALL TO ORDER, ROLL CALL, PLEDGE B.APPROVAL OF THE MINUTES B.1.Approval of the Minutes of the Committee of the Whole Workshop and Executive Session held on February 27, 2023. 02-27-2023 COW Minutes C.PRESIDENTIAL COMMENTS D.TRUSTEES COMMENTS E.PUBLIC COMMENTS (3-5 minutes) F.WORKSHOP F.1.2023-2024 DRAFT FISCAL YEAR BUDGET Staff will present the overall Draft 2023-2024 Fiscal Year Budget. 3-9-23 Draft FY24 Budget REMINDERS - •March 20 Village Board Meeting – 7:00 p.m. •March 21 Plan Commission – 7:00 p.m. •March 27 Next Committee of the Whole Workshop – 7:00 p.m. 1 Minutes of the Committee of the Whole Workshop of the President and the Board of Trustees Held on February 27, 2023 In the Boardroom Mayor Argoudelis called the meeting to order at 7:00 p.m. Board present: Mayor Argoudelis, Trustee Wojowski, Trustee Benton, Trustee Calkins, Trustee Larson, and Trustee Ruane. Board absent: Trustee Kalkanis. Others present: Joshua Blakemore, Administrator; Michelle Gibas, Village Clerk; Amy De Boni, Community Relations Director; Dan Shug, Engineer; Scott Threewitt, Public Works Director; Tom Topor, Lead Engineer; Jon Proulx, Planning Director; Jake Melrose, Economic Development Director; Lonnie Spires, Building Official; Traci Pleckham, Management Services Director; and Robert Miller, Chief of Police.There was no one in the audience. Trustee Wojowski moved to approve the Minutes of the Committee of the Whole Workshop and Executive Session held on February 13, 2023. Second by Trustee Larson. Voice Vote. All in favor, 0 opposed. Motion carried. PRESIDENTIAL COMMENTS Mayor Argoudelis: Commented on the weather and thanked PEMA for watching out. Commented on the YMCA Giving Gala. Reminded everyone of the Irish Parade on March 12. TRUSTEE COMMENTS Trustee Benton commented on the YMCA Giving Gala. PUBLIC COMMENTS No Comments. WORKSHOP 1)2023-2024 DRAFT FISCAL YEAR BUDGET Scott Threewitt and Public Works staff gave a presentation highlighting the draft 2023-2024 Draft Fiscal Year Budget for Capital Improvements. Staff gave an overview of the Public Works divisions, engineering organizational chart, pavement management system, 2023 MFT and non-MFT Street Improvement Programs, Old Town improvements and funding, 143rd Street east and west corridor, 143rd Street/Route 30/Wallin intersection improvements, railroad grade separation study, 127th Street and Naperville/Plainfield traffic signal, Lockport Street bypass feasibility study, Route 126 and I-55 interchange improvements, 2023 Lockport Street refresh, Renwick Road improvements, 143rd Street/Route 30 (Wallin to Van Dyke) Multi-use path, Renwick Road pedestrian improvements, Fort Beggs pedestrian improvements, Indian Boundary Road structure replacement, Street/Sidewalk maintenance programs, Transportation and Mobility Plan Update, Central Square Asset Management and Work Order system, and Facility Maintenance Division. Amy De Boni gave an update on the Riverfront Master Plan Capital Projects including path extension, Council Ring, river overlook, signage, Springbank trail, and Riverfront Restoration Project. Traci Pleckham reviewed the Capital Improvement budget detail. There was some general discussion regarding removing the engineering project for the 143rd Street/Route 30/Wallin intersection and decreasing the allocation from $5 million to $4 million for street maintenance. There was general support for removing the engineering project. Trustee 2 Village of Plainfield Committee of the Whole Meeting Minutes – February 27, 2023 Page 2 Larson suggested requesting a financial contribution from the School District for some of the capital improvement projects directly related to the School District. Traci Pleckham then reviewed the proposed budgets for the TIF, Bond & Interest, and alcohol enforcement funds. Mayor Argoudelis thanked staff and read the reminders. Trustee Larson moved to adjourn to Executive Session as permitted under the Open Meetings Act under d Section 2 (c)(5) to discuss property acquisition, not to reconvene. Second by Trustee Benton. Vote by roll call. Wojowski, yes; Benton, yes; Calkins, yes; Kalkanis, absent; Larson, yes; Ruane, yes. 5 yes, 0 no, 1 absent. Motion carried. The meeting adjourned at 8:33 p.m. Michelle Gibas, Village Clerk 3 FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Fund: 01 - General Fund 6,302,842 7,023,862 7,240,884 7,159,080 7,333,040 11,556,111 13,220,143 16,689,021 16,180,750 16,865,000 1,008,302 972,349 1,265,768 1,206,000 1,406,000 1,460,594 1,724,514 2,129,563 1,318,200 1,728,200 678,496 524,873 562,840 659,000 534,000 5,173,763 5,257,178 5,589,077 5,626,700 5,884,995 65,421 1,932,958 81,261 45,750 45,750 601,567 572,856 605,638 565,000 560,000 380,539 52,737 (91,662)40,000 150,000 142,970 174,774 228,563 124,500 123,500 468,282 103,444 485,540 450,000 560,000 25,000 25,000 25,000 20,000 20,000 $27,863,887 $31,584,688 $34,811,493 $33,394,980 $35,210,485 Administration/Finance 9,118,204 11,818,181 15,374,261 11,432,330 11,444,970 Police Department 12,719,854 12,948,143 13,247,304 14,542,100 15,938,804 Street Department 4,275,503 4,419,936 4,262,455 4,639,390 4,960,425 Planning Program 558,561 603,526 588,910 842,750 859,780 Building Program 991,573 1,002,883 1,036,704 1,073,500 1,225,230 $27,663,695 $30,792,669 $34,509,634 $32,530,070 $34,429,209 $200,192 $792,019 $301,859 $864,910 $781,276 Classification Revenues Property Taxes General Fund Revenue & Expense Summary 2023-2024 Fiscal Year Budget State of Illinois Taxes Other Taxes Licenses & Permits Revenue Totals Fines and Forfeits Charges for Services Expense Totals Total: General Fund Grants Franchise Fees Investment Income Intergovernmental Interfund Transfers Expenses Miscellaneous $0 $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 $40,000,000 FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Revenue History by Type Interfund Transfers Intergovernmental Miscellaneous Investment Income Franchise Fees Grants Charges for Services Fines and Forfeits Licenses & Permits Other Taxes State of Illinois Taxes Property Taxes DRAFT 03/09/2023 Page 1 of 51 4 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Fund: 01 - General Fund Revenues Property Tax Revenue 4,084,845 4,512,639 4,593,107 4,504,080 4,501,225 4,408,040 Property Tax Rev-Road & 381,555 384,392 400,655 380,000 412,355 400,000 Property Tax-Police Pen 1,297,308 1,577,460 1,697,212 1,700,000 1,698,689 1,950,000 Property Tax Rev-IMRF 539,134 549,371 549,910 575,000 574,251 575,000 $6,302,842 $7,023,862 $7,240,884 $7,159,080 $7,186,520 $7,333,040 STTAX - State of Illinois Taxes Municipal Sales Tax 5,775,938 6,812,757 8,801,385 8,660,750 9,000,000 8,500,000 Illinois Income Tax 4,289,960 4,537,460 6,015,389 5,900,000 6,900,000 6,600,000 Replacement Tax 63,799 60,678 139,552 70,000 140,000 90,000 Local Use Tax 1,426,414 1,809,248 1,732,695 1,550,000 1,750,000 1,675,000 $11,556,111 $13,220,143 $16,689,021 $16,180,750 $17,790,000 $16,865,000 Hotel/Motel Tax 672 419 1,960 1,000 1,500 1,000 Amusement Tax 4,595 1,243 5,746 5,000 9,000 5,000 Local Motor Fuel Tax 1,003,035 970,687 1,258,062 1,200,000 1,350,000 1,400,000 $1,008,302 $972,349 $1,265,768 $1,206,000 $1,360,500 $1,406,000 LIC&PER - Licenses and Permits Liquor License 112,523 97,940 121,183 100,000 118,500 100,000 Contractors License 48,150 46,800 50,100 45,000 45,000 45,000 Cigarette License 6,045 5,750 5,500 6,000 6,000 6,000 Scavenger License 100 100 50 200 100 200 Business License 42,250 44,425 43,963 40,000 70,000 50,000 Building Permit 1,171,669 1,495,052 1,846,761 1,100,000 1,700,000 1,500,000 Sign Permit 4,937 3,687 4,731 5,000 4,500 5,000 Special Movement Permit 72,155 27,900 55,430 20,000 53,000 20,000 Solicitors Permit 2,765 2,860 1,845 2,000 2,500 2,000 $1,460,594 $1,724,514 $2,129,563 $1,318,200 $1,999,600 $1,728,200 Will County Court Fines 376,964 297,493 388,600 325,000 340,000 325,000 Aministrative Fines(P-Tkts)144,555 108,666 110,025 100,000 100,000 100,000 Aministrative Fines - Late fees 8,010 9,025 4,594 5,000 5,500 5,000 Asset Seizure 13,338 94,861 51,871 225,000 50,000 100,000 Alarm Fees 500 9,000 (600)1,000 1,850 1,000 Kendall County Court Fines 3,141 5,828 6,595 3,000 4,500 3,000 Total: Licenses & Permits FIN - Fines and Forfeits Total: State of Illinois Taxes OTHTX - Other Taxes Total: Other Taxes General Fund Revenue Detail 2023-2024 Fiscal Year Budget PROPTX - Property Taxes Total: Property Taxes DRAFT 03/09/2023 Page 2 of 51 5 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget General Fund Revenue Detail 2023-2024 Fiscal Year Budget Fund: 01 - General Fund Revenues (continued) Asset Seizure (DOJ)131,988 0 1,755 0 90,000 0 Asset Seizure (US Treas)0 0 0 0 0 0 $678,496 $524,873 $562,840 $659,000 $591,850 $534,000 Garbage Fee 4,504,532 4,708,687 4,913,961 5,000,000 5,111,500 5,264,845 Garbage Penalties 45,884 0 44,099 40,000 53,000 40,000 Engineering Services 0 0 0 5,000 0 0 Zoning Applications 22,544 21,899 28,344 15,000 42,000 15,000 Accident Report Fees 7,905 6,250 8,650 5,000 7,800 5,000 Copies-Maps & Ordinances 2,391 1,381 2,199 1,500 1,700 1,500 Impound Fee 26,150 41,000 24,750 25,000 27,000 25,000 Parking Lot Revenue 1,484 3,400 5,346 2,000 2,000 2,000 Tower Rent 45,110 49,215 46,240 46,000 46,450 46,450 Rental Income 49,200 49,200 49,200 49,200 49,200 49,200 Rental-Community/Multi 3,165 0 475 3,000 700 1,000 Special Detail/OT 115,398 26,146 115,813 85,000 100,000 85,000 Water & Sewer Service 350,000 350,000 350,000 350,000 350,000 350,000 $5,173,763 $5,257,178 $5,589,077 $5,626,700 $5,791,350 $5,884,995 FEMA Grant 0 36,196 12,693 0 12,693 0 Grant Revenue 8,600 1,814,016 0 0 3,000 0 Bulletproof Vest Grant 6,081 8,495 6,885 3,000 4,252 3,000 Tobacco Grant 1,375 1,320 1,320 2,750 4,503 2,750 Traffic Grant 49,365 72,931 60,363 40,000 65,635 40,000 $65,421 $1,932,958 $81,261 $45,750 $90,083 $45,750 AT&T Franchise Payment 127,184 102,746 93,686 90,000 81,000 80,000 Cable TV- Franchise 474,383 470,110 511,952 475,000 522,000 480,000 $601,567 $572,856 $605,638 $565,000 $603,000 $560,000 Interest Income 220,671 74,328 85,533 40,000 295,000 150,000 Realized Gain/Loss 69,706 0 6,367 0 0 0 Unrealized Gain/Loss 90,162 (21,591)(183,562)0 0 0 $380,539 $52,737 ($91,662)$40,000 $295,000 $150,000 INT - Investment Income Total: Investment Income Total: Fines and Forfeits GRNTS - Grants Total: Grants FRAN - Franchise Fees Total: Franchise Fees SERV - Charges for Services Total: Charges for Services DRAFT 03/09/2023 Page 3 of 51 6 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget General Fund Revenue Detail 2023-2024 Fiscal Year Budget Fund: 01 - General Fund Revenues (continued) Event Sponsorship Program 3,300 0 0 3,000 1,700 2,000 Reimb Police Training 0 1,444 0 0 0 0 Amphitheater Rent 125 0 250 500 250 500 Restitution Program 200 4,100 0 0 0 0 Donation/Contribution 21,579 6,494 8,534 5,000 38,000 5,000 Sales-Fixed Assets 4,740 21,603 0 1,000 2,400 1,000 Other Reimbursements 95,255 115,681 194,732 90,000 123,000 90,000 Other Receipts 17,771 25,452 25,047 25,000 50,000 25,000 $142,970 $174,774 $228,563 $124,500 $215,350 $123,500 INTERGOV - Intergovernmental School Liaison 460,772 76,005 468,154 440,000 485,000 550,000 HIDTA/Organized Crime 7,510 27,439 17,386 10,000 15,000 10,000 $468,282 $103,444 $485,540 $450,000 $500,000 $560,000 Transfer From Alcohol Enforc.25,000 25,000 25,000 20,000 20,000 20,000 $25,000 $25,000 $25,000 $20,000 $20,000 $20,000 $27,863,887 $31,584,688 $34,811,493 $33,394,980 $36,443,253 $35,210,485Revenues Total MISC - Miscellaneous Total: Miscellaneous Total: Intergovernmental INTER - Interfund Transfers Total: Interfund Transfers DRAFT 03/09/2023 Page 4 of 51 7 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget 2024 Proposed Budget 1,419,084 1,476,873 1,765,390 1,824,805 1,926,500 2,175,500 551,280 528,872 669,444 714,281 875,350 908,205 14,389 13,958 10,151 15,036 21,750 22,050 123,471 112,020 136,635 137,103 175,350 172,800 4,586,998 4,737,669 5,206,086 5,518,759 5,879,880 6,262,915 313,378 240,800 909,218 1,161,466 1,253,500 503,500 Sub-total $7,008,600 $7,110,192 $8,696,924 $9,371,450 $10,132,330 $10,044,970 1,359,212 2,008,012 3,121,257 6,002,811 1,300,000 1,400,000 $8,367,812 $9,118,204 $11,818,181 $15,374,261 $11,432,330 $11,444,970 Classification Fund: 01 - General Fund Expenditures General Fund Administration/Finance Summary 2023-2024 Fiscal Year Budget Unit: 04 - Administration/Finance Total Administration/Finance Salaries and Wages Benefits Utilities Supplies and Commodities Contractual Services Other Transfers $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget 2024 Proposed Budget Admin/Finance Expense History Other Contractual Services Supplies and Commodities Utilities Benefits Salaries and Wages DRAFT 03/09/2023 Page 5 of 51 8 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Unit: 04 - Administration/Finance Contrac - Contractual Services Fees to Refuse Hauler 4,161,324 4,364,628 4,561,774 4,798,250 4,800,000 5,116,915 Bad Debt Expense 0 11,305 0 0 0 0 $4,161,324 $4,375,933 $4,561,774 $4,798,250 $4,800,000 $5,116,915 Salaries-President 24,000 24,000 24,000 24,000 24,000 24,000 Salaries-Elected Officials 25,300 23,000 25,800 26,000 24,000 26,000 Salaries-Liquor Commissioner 1,500 1,500 1,500 1,500 1,500 1,500 Salaries-Treasurer 2,500 2,500 2,500 2,500 2,500 2,500 $53,300 $51,000 $53,800 $54,000 $52,000 $54,000 FICA 3,286 3,162 3,335 3,400 3,400 3,400 Medicare 769 740 780 800 800 800 Employee Insurance 109 101 8 100 100 100 Travel/Training 1,919 0 0 10,000 1,500 10,000 $6,083 $4,003 $4,123 $14,300 $5,800 $14,300 SUPP - Supplies and Commodities Replacement Supplies 742 5,248 2,684 10,000 6,000 10,000 Dues & Subscriptions 50,868 53,068 52,710 55,000 55,000 55,000 $51,610 $58,316 $55,394 $65,000 $61,000 $65,000 Contrac - Contractual Services Public Relations 122,741 107,052 105,690 120,000 110,000 120,000 Cable TV 0 15,761 0 10,000 8,000 10,000 $122,741 $122,813 $105,690 $130,000 $118,000 $130,000 Small Business Relief Grant 0 145,000 0 0 0 0 Economic Incentive Rebate 134,559 587,273 1,056,808 700,000 375,000 150,000 $134,559 $732,273 $1,056,808 $700,000 $375,000 $150,000 $368,293 $968,405 $1,275,815 $963,300 $611,800 $413,300 Administration/Finance Detail 2023-2024 Fiscal Year Budget General Fund Division: 00 - Non-Divisional Division: 01 - Legislative Program Expenditures Total: Salaries and Wages BEN - Benefits Total: Non-Divisional SAL - Salaries and Wages Total: Benefits Total: Supplies & Commodities Total: Contractual Services OTHER - Other Total: Other Total: 01 - Legislative Program DRAFT 03/09/2023 Page 6 of 51 9 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Administration/Finance Detail 2023-2024 Fiscal Year Budget General Fund Salaries-Full Time 768,361 671,481 678,916 740,000 710,000 770,000 Salaries-Part Time 55,836 63,773 75,283 55,000 53,000 60,000 Salaries-Overtime 359 276 1,158 2,000 1,000 2,000 $824,556 $735,530 $755,357 $797,000 $764,000 $832,000 FICA 45,731 40,466 44,578 50,000 47,500 51,590 Medicare 11,786 11,245 10,842 11,750 11,100 12,065 IMRF 80,550 84,122 78,435 88,000 84,000 91,520 Employee Insurance 105,980 89,852 99,570 135,000 125,000 115,000 Deferred Comp. Contribution 18,208 20,554 16,635 25,000 20,000 25,000 Travel/Training 4,901 1,501 2,311 12,000 6,500 12,000 IL Unemployment Insurance 3,594 5,311 4,303 6,000 6,000 6,000 $270,750 $253,051 $256,674 $327,750 $300,100 $313,175 UTIL - Utilities Telephone/Internet 5,814 2,468 6,101 8,000 6,000 8,000 Cellular Phones 2,531 1,657 3,361 5,000 2,500 5,000 $8,345 $4,125 $9,462 $13,000 $8,500 $13,000 SUPP - Supplies and Commodities Office Supplies/Postage 33,066 32,225 34,062 35,000 35,000 35,000 Dues & Subscriptions 3,759 2,476 1,549 5,000 4,000 5,000 Gas/Oil/Mileage/Carwash 8,378 7,200 3,143 9,500 6,500 9,500 $45,203 $41,901 $38,754 $49,500 $45,500 $49,500 Contrac - Contractual Services Maintenance Contracts/Lease 4,046 1,894 1,997 8,000 2,000 5,000 Recording Fees 166 506 509 1,000 800 1,000 Legal Notices 2,079 2,103 1,051 2,500 1,500 2,500 Legal Fees 60,032 43,085 106,052 95,000 90,000 95,000 Contractual Services 54,690 63,584 117,081 90,000 95,000 100,000 $121,013 $111,172 $226,690 $196,500 $189,300 $203,500 OTHER - Other Office Furniture & Equipment 9,982 3,920 1,631 5,000 2,000 5,000 Contingencies 7,054 25,884 7,376 400,000 25,000 200,000 $17,036 $29,804 $9,007 $405,000 $27,000 $205,000 Total: 02 - Administration $1,286,903 $1,175,583 $1,295,944 $1,788,750 $1,334,400 $1,616,175 Total: OTHER - Other SAL - Salaries and Wages Total: UTIL - Utilities Total: Supplies & Commodities Total: Contractual Services Total: Salaries and Wages Total: Benefits BEN - Benefits Division: 02 - Administration Program DRAFT 03/09/2023 Page 7 of 51 10 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Administration/Finance Detail 2023-2024 Fiscal Year Budget General Fund Salaries-Full Time 104,807 110,916 108,659 113,000 113,000 118,000 $104,807 $110,916 $108,659 $113,000 $113,000 $118,000 FICA 5,881 6,745 6,513 7,100 7,100 7,315 Medicare 1,375 1,577 1,523 1,700 1,700 1,715 IMRF 10,345 12,682 11,510 12,500 12,500 12,980 Employee Insurance 21,592 23,066 25,377 29,500 28,000 29,725 Deferred Comp. Contribution 1,700 3,755 3,784 5,000 5,000 5,000 Travel/Training 25 81 35 1,500 500 1,500 $40,918 $47,906 $48,742 $57,300 $54,800 $58,235 UTIL - Utilities Telephone/Internet 677 310 384 750 400 750 $677 $310 $384 $750 $400 $750 SUPP - Supplies and Commodities Office Supplies/Postage 0 0 22 300 100 400 Dues & Subscriptions 570 634 604 850 750 900 Gas/Oil/Mileage/Carwash 0 0 0 100 50 100 $570 $634 $626 $1,250 $900 $1,400 Contrac - Contractual Services Public Relations 11,124 11,148 15,522 31,000 25,000 32,000 Marketing and Promotions 0 0 0 2,000 2,000 7,000 Settler's Park 4,287 0 4,825 8,000 6,500 8,500 Contractual Services 384 13,561 3,800 7,500 5,000 7,000 $15,795 $24,709 $24,147 $48,500 $38,500 $54,500 Total: 03-Community Relations $162,767 $184,475 $182,558 $220,800 $207,600 $232,885 BEN - Benefits Total: Supplies & Commodities Total: Contractual Services SAL - Salaries and Wages Total: Benefits Total: UTIL - Utilities Total: Salaries and Wages Division: 03 - Community Relations Program DRAFT 03/09/2023 Page 8 of 51 11 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Administration/Finance Detail 2023-2024 Fiscal Year Budget General Fund Salaries-Full Time 52,087 53,084 55,226 60,000 58,000 60,000 Salaries-Overtime 4,176 3,344 4,729 5,000 5,500 7,500 $56,263 $56,428 $59,955 $65,000 $63,500 $67,500 FICA 3,323 3,511 3,594 4,100 4,000 4,185 Medicare 777 821 841 1,000 950 1,000 IMRF 5,493 6,405 6,266 7,200 6,985 7,425 Employee Insurance 15,525 14,732 13,899 18,000 15,250 18,500 Deferred Comp. Contribution 786 1,220 1,229 2,000 2,000 2,000 $25,904 $26,689 $25,829 $32,300 $29,185 $33,110 SUPP - Supplies and Commodities Building Supplies 10,722 12,676 9,581 20,000 15,000 20,000 $10,722 $12,676 $9,581 $20,000 $15,000 $20,000 Contrac - Contractual Services Contractual Services 45,241 42,946 73,570 70,000 50,000 70,000 $45,241 $42,946 $73,570 $70,000 $50,000 $70,000 OTHER - Other Building Improvements 4,775 32,885 1,669 30,000 15,000 30,000 $4,775 $32,885 $1,669 $30,000 $15,000 $30,000 Total: 04-Facility Management $142,905 $171,624 $170,604 $217,300 $172,685 $220,610 BEN - Benefits Total: Salaries and Wages Division: 04 - Facility Management Program Total: Supplies & Commodities Total: Contractual Services Total: OTHER - Other Total: Benefits SAL - Salaries and Wages DRAFT 03/09/2023 Page 9 of 51 12 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Administration/Finance Detail 2023-2024 Fiscal Year Budget General Fund Salaries-Full Time 174,765 185,129 196,717 195,000 199,500 215,000 Salaries-Overtime 0 0 0 500 500 500 $174,765 $185,129 $196,717 $195,500 $200,000 $215,500 FICA 10,228 11,788 11,810 12,000 12,400 13,360 Medicare 2,392 2,843 2,762 2,800 2,900 3,125 IMRF 17,263 22,034 20,806 21,000 22,000 23,705 Employee Insurance 39,343 42,044 43,435 50,000 33,000 35,000 Deferred Comp. Contribution 6,719 6,953 7,042 8,000 8,000 8,000 Travel/Training 964 614 383 10,000 4,000 10,000 $76,909 $86,276 $86,238 $103,800 $82,300 $93,190 UTIL - Utilities Telephone/Internet 1,067 450 514 1,000 600 1,000 Cellular Phones 672 543 466 600 515 600 $1,739 $993 $980 $1,600 $1,115 $1,600 SUPP - Supplies and Commodities Office Supplies/Postage 890 1,251 1,424 2,000 1,500 2,000 Dues & Subscriptions 946 707 9,563 10,000 2,000 5,000 Gas/Oil/Mileage/Carwash 24 0 0 1,200 200 1,000 $1,860 $1,958 $10,987 $13,200 $3,700 $8,000 Contrac - Contractual Services Public Relations 10,143 7,363 8,597 12,000 9,000 12,000 Contractual Services 4,393 1,348 6,888 10,000 5,000 10,000 $14,536 $8,711 $15,485 $22,000 $14,000 $22,000 Total: 06 - Human Resources $269,809 $283,067 $310,407 $336,100 $301,115 $340,290 Total: UTIL - Utilities BEN - Benefits SAL - Salaries and Wages Total: Salaries and Wages Division: 06 - Human Resources Program Total: Benefits Total: Supplies & Commodities Total: Contractual Services DRAFT 03/09/2023 Page 10 of 51 13 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Administration/Finance Detail 2023-2024 Fiscal Year Budget General Fund Salaries-Full Time 263,182 307,528 332,536 370,000 380,000 537,500 $263,182 $307,528 $332,536 $370,000 $380,000 $537,500 FICA 16,118 19,250 19,562 23,000 23,560 33,325 Medicare 3,769 4,502 4,575 5,500 5,510 7,795 IMRF 26,278 34,519 34,516 41,000 41,800 59,125 Employee Insurance 44,200 55,192 94,994 103,000 113,500 120,000 Deferred Comp. Contribution 8,767 7,419 5,100 7,500 6,000 7,500 Travel/Conventions/Training 9,176 0 1,665 15,000 3,000 15,000 $108,308 $120,882 $160,412 $195,000 $193,370 $242,745 UTIL - Utilities Telephone/Internet 534 228 257 500 400 500 Cellular Phones 2,663 2,796 2,674 4,200 2,800 4,200 $3,197 $3,024 $2,931 $4,700 $3,200 $4,700 SUPP - Supplies and Commodities Office Supplies/Postage 941 2,586 909 1,800 1,000 1,800 Dues & Subscriptions 754 689 564 800 800 1,100 Gas/Oil/Mileage/Carwash 360 0 0 400 400 400 Uniforms 0 267 288 800 400 800 $2,055 $3,542 $1,761 $3,800 $2,600 $4,100 Contrac - Contractual Services Software Licensing/Renewals 241,440 444,441 455,314 523,130 520,000 585,000 Contractual Services 15,579 52,263 29,115 70,500 35,000 60,000 $257,019 $496,704 $484,429 $593,630 $555,000 $645,000 OTHER - Other Server/Network Supplies 58,663 74,698 54,827 78,500 65,000 78,500 Computers 25,767 39,558 39,155 40,000 40,000 40,000 $84,430 $114,256 $93,982 $118,500 $105,000 $118,500 Total: 08 - IT Program $718,191 $1,045,936 $1,076,051 $1,285,630 $1,239,170 $1,552,545 Total: OTHER - Other Total: Salaries and Wages Total: Benefits SAL - Salaries and Wages BEN - Benefits Total: Contractual Services Division: 08 - IT Program Total: Supplies & Commodities Total: UTIL - Utilities DRAFT 03/09/2023 Page 11 of 51 14 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Administration/Finance Detail 2023-2024 Fiscal Year Budget General Fund SAL - Salaries and Wages Salaries-Full Time 0 291,981 291,810 298,000 309,000 320,000 Salaries - Part Time 0 26,878 25,971 33,000 25,000 30,000 Salaries-Overtime 0 0 0 1,000 0 1,000 $0 $318,859 $317,781 $332,000 $334,000 $351,000 BEN - Benefits FICA 0 20,013 18,952 21,000 20,710 21,760 Medicare 0 4,605 4,538 4,900 4,850 5,090 IMRF 0 35,706 34,019 37,000 36,750 38,600 Employee Insurance 0 60,370 65,032 68,000 70,100 74,000 Deferred Comp. Contrib.0 9,389 9,496 11,000 10,000 11,000 Travel/Training 0 554 226 3,000 1,000 3,000 $0 $130,637 $132,263 $144,900 $143,410 $153,450 UTIL - Utilities Telephone/Internet 0 491 515 1,000 500 1,000 Cellular Phones 0 1,208 764 700 1,000 1,000 $0 $1,699 $1,279 $1,700 $1,500 $2,000 SUPP - Supplies and Commodities Office Supplies/Postage 0 5,632 6,600 10,000 6,500 10,000 Dues & Subscriptions 0 10,506 11,667 11,000 11,000 12,000 Gas/Oil/Mileage/Carwash 0 836 1,135 1,000 1,800 2,200 Uniforms/Clothing 0 634 598 600 600 600 $0 $17,608 $20,000 $22,600 $19,900 $24,800 Contrac - Contractual Services Maintenance Contracts/Lease 0 2,016 2,931 3,000 3,000 3,000 Vehicle Maintenance 0 784 3,731 3,000 2,000 3,000 Legal Fees 0 20,298 20,312 15,000 15,000 15,000 $0 $23,098 $26,974 $21,000 $20,000 $21,000 Total: Legal Services $0 $491,901 $498,297 $522,200 $518,810 $552,250 Transfer to Tort Immunity 0 0 0 300,000 300,000 0 Transfer to Capital 2,008,012 3,121,257 6,002,811 1,000,000 1,000,000 1,400,000 $2,008,012 $3,121,257 $6,002,811 $1,300,000 $1,300,000 $1,400,000 Total: Administration/Finance $9,118,204 $11,818,181 $15,374,261 $11,432,330 $10,485,580 $11,444,970 Total: Contractual Services Total: Salaries and Wages Total: Benefits Total: Utilities Total: Supplies & Commodities Total: Transfers Transfers Division: 09 - Legal Services DRAFT 03/09/2023 Page 12 of 51 15 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget 2024 Proposed Budget Salaries and Wages 7,431,449 7,735,573 7,688,410 7,872,489 8,552,418 9,465,338 Benefits 3,485,115 3,425,247 3,693,848 3,882,652 4,079,002 4,349,668 Utilities 68,639 73,299 65,280 72,221 86,678 93,820 Supplies and Commodities 316,388 349,290 296,940 360,146 385,330 439,040 Contractual Services 1,083,725 1,048,631 1,079,414 1,001,718 1,297,672 1,361,938 Other 300,794 87,814 124,251 58,078 141,000 229,000 Total - Police Department $12,686,110 $12,719,854 $12,948,143 $13,247,304 $14,542,100 $15,938,804 Classification Fund: 01 - General Fund Expenditures Total Police Department General Fund Police Division Summary 2023-2024 Fiscal Year Budget $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget 2024 Proposed Budget Police Division Expense History Other Contractual Services Supplies and Commodities Utilities Benefits Salaries and Wages DRAFT 03/09/2023 Page 13 of 51 16 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Fund: 01 - General Fund Expenditures Unit: 05 - Police Department SAL - Salaries and Wages Salaries-Full Time 311,250 338,919 335,089 347,887 335,000 293,751 Salaries-Part Time 32,369 32,174 15,622 35,000 16,000 35,000 Salaries-Overtime 1,096 255 649 1,000 800 1,000 $344,715 $371,348 $351,360 $383,887 $351,800 $329,751 BEN - Benefits FICA 19,966 22,607 20,364 23,801 22,000 20,445 Medicare 4,761 5,450 4,958 5,566 5,100 4,781 IMRF 19,397 23,140 20,032 20,086 21,500 11,690 Employee Insurance 63,830 67,335 63,500 66,521 47,000 49,624 Deferred Comp. Contrib.6,135 6,381 6,455 8,000 8,000 8,000 Travel/Training 4,891 3,630 886 8,000 3,500 8,500 Education/School 3,511 3,000 3,000 3,000 3,000 3,000 Unemployment Insurance 18,788 20,000 20,663 20,000 20,000 20,000 $141,279 $151,543 $139,858 $154,974 $130,100 $126,040 UTIL - Utilities Telephone/Internet 627 450 534 1,100 600 1,100 Cellular Phones 734 527 466 1,200 1,200 1,200 $1,361 $977 $1,000 $2,300 $1,800 $2,300 SUPP - Supplies and Commodities Office Supplies/Postage 6,461 6,291 7,025 8,000 8,000 8,000 Replacement Supplies 1,837 1,898 1,562 4,550 3,000 3,500 Dues & Subscriptions 3,264 4,905 4,841 5,960 5,000 6,465 Gas/Oil/Mileage/Carwash 5,278 1,245 2,219 3,700 2,200 3,700 Uniforms/Clothing 2,515 2,251 1,240 1,800 5,800 1,800 $19,355 $16,590 $16,887 $24,010 $24,000 $23,465 Contrac - Contractual Services Maintenance Contracts/Lease 6,547 5,651 5,911 6,709 6,000 6,709 Custodial/Building Maintenance 64,491 71,172 68,030 75,000 65,000 82,500 Vehicle Maintenance 651 1,688 1,347 2,500 1,000 2,500 Contractual Services 4,760 21,229 7,892 8,000 5,000 8,000 $76,449 $99,740 $83,180 $92,209 $77,000 $99,709 Total: Administration Program $583,159 $640,198 $592,285 $657,380 $584,700 $581,265 Total: Supplies & Commodities Division: 02 - Police Executive General Fund Police Division Detail 2023-2024 Fiscal Year Budget Total: Salaries and Wages Total: Benefits Total: Utilities Total: Contractual Services DRAFT 03/09/2023 Page 14 of 51 17 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget General Fund Police Division Detail 2023-2024 Fiscal Year Budget SAL - Salaries and Wages Salaries-Full Time 4,258,971 3,985,541 4,079,432 4,319,335 4,170,500 5,264,785 Salaries-Part Time 261,624 (1,025)0 0 0 303,000 Salaries-Overtime 291,642 224,247 194,310 250,000 240,000 300,000 $4,812,237 $4,208,763 $4,273,742 $4,569,335 $4,410,500 $5,867,785 BEN - Benefits FICA 288,235 265,944 254,950 283,299 273,450 316,266 Medicare 67,924 62,253 59,931 66,255 63,950 73,966 IMRF 40,872 15,670 13,460 15,408 12,000 7,549 Employer Pension Contrib.1,297,308 1,577,460 1,697,212 1,700,000 1,700,000 1,950,000 Employee Insurance 659,918 630,361 679,629 705,889 715,000 779,536 Deferred Comp. Contrib.115,355 114,454 123,913 125,000 125,000 140,000 Travel/Training 38,592 24,968 41,655 41,000 33,000 50,000 $2,508,204 $2,691,110 $2,870,750 $2,936,851 $2,922,400 $3,317,317 UTIL - Utilities Telephone/Internet 40,595 33,635 44,867 35,000 40,000 40,000 Cellular Phones 5,853 6,256 4,079 7,000 5,500 7,000 $46,448 $39,891 $48,946 $42,000 $45,500 $47,000 SUPP - Supplies and Commodities Office Supplies/Postage 14,333 7,084 9,183 13,500 10,000 13,500 Replacement Supplies 16,250 16,708 18,482 20,000 18,000 22,500 Dues & Subscriptions 885 710 2,458 8,100 5,000 8,100 Gas/Oil/Mileage/Carwash 96,473 61,882 89,090 68,000 100,000 112,250 K-9 Unit 5,262 5,416 0 0 0 0 Uniforms/Clothing 52,837 48,402 32,088 42,950 30,000 55,900 Ammunition/Weapons 24,227 28,249 29,795 28,500 28,000 32,000 Bike Unit 5,806 3,385 0 6,000 3,000 6,000 $216,073 $171,836 $181,096 $187,050 $194,000 $250,250 Contrac - Contractual Services Traffic Programs 13,161 0 0 0 0 27,000 Explorer Program 0 2,682 975 5,000 1,500 5,000 Radio Maintenance 0 48 0 2,000 1,000 2,000 Maintenance Contracts/Lease 14,521 4,366 13,899 11,920 12,000 11,920 Vehicle Maintenance 73,943 75,795 49,182 53,000 45,000 70,200 Contractual Services 12,479 13,103 14,514 16,700 50,000 55,000 Contractual Svcs - WESCOM 601,421 607,001 605,468 619,813 619,813 640,779 Animal Control 7,060 2,780 0 0 0 9,000 $722,585 $705,775 $684,038 $708,433 $729,313 $820,899 Total: Police Operations $8,305,547 $7,817,375 $8,058,572 $8,443,669 $8,301,713 $10,303,251 Total: Supplies & Commodities Total: Contractual Services Total: Salaries and Wages Division: 51 - Police Patrol Total: Benefits Total: Utilities DRAFT 03/09/2023 Page 15 of 51 18 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget General Fund Police Division Detail 2023-2024 Fiscal Year Budget SAL - Salaries and Wages Salaries-Full Time 1,018,858 1,763,317 1,807,819 2,071,741 2,011,268 2,372,648 Salaries-Overtime 58,668 107,876 163,383 138,000 175,000 179,000 $1,077,526 $1,871,193 $1,971,202 $2,209,741 $2,186,268 $2,551,648 BEN - Benefits FICA 64,642 116,994 119,103 137,004 135,550 158,202 Medicare 15,118 27,450 28,078 32,041 31,700 36,999 IMRF 6,766 13,654 13,630 16,020 16,000 16,987 Employee Insurance 176,357 290,239 309,882 372,639 366,301 391,245 Deferred Comp. Contrib.46,030 53,793 59,790 58,000 61,000 65,000 Travel/Training 9,975 11,448 19,344 20,000 18,000 31,800 $318,888 $513,578 $549,827 $635,704 $628,551 $700,233 UTIL - Utilities Telephone/Internet 731 579 542 1,100 700 1,100 Cellular Phones 11,676 12,203 9,742 15,000 13,000 15,000 $12,407 $12,782 $10,284 $16,100 $13,700 $16,100 SUPP - Supplies and Commodities Office Supplies/Postage 3,100 3,877 3,291 5,500 4,000 5,500 Replacement Supplies 1,125 4,215 13,947 15,000 8,000 14,500 Dues & Subscriptions 3,923 3,999 5,331 7,000 5,000 6,700 Gas/Oil/Mileage/Carwash 16,888 16,903 35,709 30,000 42,000 45,000 Crime Scene/Evidence Tech 6,483 6,315 9,299 10,000 9,000 10,000 Uniforms/Clothing 9,148 14,057 14,679 13,900 13,000 19,560 $40,667 $49,366 $82,256 $81,400 $81,000 $101,260 Contrac - Contractual Services Community Programs 0 6,127 8,578 8,500 8,500 10,500 Community Prog-Alc/Tobacco 0 104 194 2,500 500 2,500 Explorer Program 11,962 (240)0 0 0 0 Radio Maintenance 1,326 25,564 18,946 31,000 23,000 33,000 Maintenance Contracts/Lease 3,151 2,498 2,642 4,920 3,000 4,920 Contractual Services 0 0 0 0 0 92,500 Vehicle Maintenance 13,609 27,120 28,561 30,000 26,000 30,000 D.A.R.E. Program 0 3,076 2,604 5,000 3,500 5,000 Background Check Svcs.2,521 2,407 2,405 2,500 2,500 2,500 Accreditation 4,595 0 0 0 0 0 $37,164 $66,656 $63,930 $84,420 $67,000 $180,920 OTHER - Other Shop with a Cop 0 14,900 15,818 10,000 12,900 10,000 $0 $14,900 $15,818 $10,000 $12,900 $10,000 Total: Police Administration $1,486,652 $2,528,475 $2,693,317 $3,037,365 $2,989,419 $3,560,161 Total: Salaries and Wages Total: Benefits Total: Utilities Total: Supplies & Commodities Total: Contractual Services Total: OTHER - Other Division: 52 - Police Administration DRAFT 03/09/2023 Page 16 of 51 19 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget General Fund Police Division Detail 2023-2024 Fiscal Year Budget SAL - Salaries and Wages Salaries-Full Time 226,435 0 0 0 0 0 Salaries-Part Time 32,979 0 0 0 0 0 Salaries-Overtime 4,310 0 0 0 0 0 $263,724 $0 $0 $0 $0 $0 BEN - Benefits FICA 16,489 0 0 0 0 0 Medicare 3,856 0 0 0 0 0 IMRF 26,696 0 0 0 0 0 Employee Insurance 31,405 0 0 0 0 0 Deferred Comp. Contrib.10,182 0 0 0 0 0 Travel/Training 877 0 0 0 0 0 $89,505 $0 $0 $0 $0 $0 UTIL - Utilities Telephone/Internet 731 0 0 0 0 0 $731 $0 $0 $0 $0 $0 SUPP - Supplies and Commodities Office Supplies/Postage 8,946 0 0 0 0 0 Dues & Subscriptions 50 0 0 0 0 0 Uniforms/Clothing 961 0 0 0 0 0 $9,957 $0 $0 $0 $0 $0 Contrac - Contractual Services Maintenance Contracts/Lease 5,193 0 0 0 0 0 $5,193 $0 $0 $0 $0 $0 Total: Police Records $369,110 $0 $0 $0 $0 $0 Division: 53 - Police Records Total: Salaries and Wages Total: Contractual Services Total: Benefits Total: Utilities Total: Supplies & Commodities DRAFT 03/09/2023 Page 17 of 51 20 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget General Fund Police Division Detail 2023-2024 Fiscal Year Budget Contrac - Contractual Services Seizure/Forfeiture Exp.77,906 100,230 70,599 225,000 50,000 100,000 $77,906 $100,230 $70,599 $225,000 $50,000 $100,000 Total: Seizure/Forfeiture $77,906 $100,230 $70,599 $225,000 $50,000 $100,000 SAL - Salaries and Wages Salaries-Special Activities 72,901 22,764 77,155 32,513 65,000 32,513 $72,901 $22,764 $77,155 $32,513 $65,000 $32,513 BEN - Benefits FICA 4,470 1,344 4,626 2,016 4,000 2,016 Medicare 1,067 315 1,105 471 700 471 $5,537 $1,659 $5,731 $2,487 $4,700 $2,487 SUPP - Supplies and Commodities Mobile Field Force 960 0 0 0 0 0 $960 $0 $0 $0 $0 $0 Total: Police Special Activities $79,398 $24,423 $82,886 $35,000 $69,700 $35,000 Total: Salaries and Wages Total: Benefits Division: 55 - Police Special Activities Total: Supplies & Commodities Total: Contractual Services Division: 54 - Seizure/Forfeiture DRAFT 03/09/2023 Page 18 of 51 21 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget General Fund Police Division Detail 2023-2024 Fiscal Year Budget SAL - Salaries and Wages Salaries-Full Time 947,620 914,637 891,580 994,442 975,000 595,261 Salaries-Part Time 1,598 258,505 259,167 300,000 260,000 75,880 Salaries-Overtime 47,938 40,089 44,335 56,000 45,000 6,000 $997,156 $1,213,231 $1,195,082 $1,350,442 $1,280,000 $677,141 BEN - Benefits FICA 59,433 77,332 72,628 83,727 77,800 41,983 Medicare 14,010 18,096 17,089 19,581 18,198 9,819 IMRF 4,956 58,343 55,628 70,439 55,000 40,230 Employee Insurance 163,410 149,288 138,009 129,058 140,000 65,418 Deferred Comp. Contrib.28,752 25,302 23,276 30,000 25,000 30,000 Travel/Training 13,262 5,931 7,998 10,760 5,000 10,220 $283,823 $334,292 $314,628 $343,565 $320,998 $197,670 UTIL - Utilities Telephone/Internet 919 1,164 1,074 2,200 1,200 2,200 Cellular Phones 2,787 2,923 2,394 7,220 2,500 7,220 $3,706 $4,087 $3,468 $9,420 $3,700 $9,420 SUPP - Supplies and Commodities Office Supplies/Postage 3,032 9,889 8,991 13,750 10,000 13,750 Replacement Supplies 3,366 2,707 8,750 11,500 5,000 6,500 Dues & Subscriptions 654 1,632 918 650 500 650 Gas/Oil/Mileage/Carwash 10,288 17,496 24,858 22,000 30,000 5,000 Uniforms/Clothing 6,592 12,074 16,395 11,870 7,000 5,065 $23,932 $43,798 $59,912 $59,770 $52,500 $30,965 Contrac - Contractual Services Traffic Program 0 20,259 15,495 27,000 22,000 0 Community Programs 4,662 0 0 0 0 0 Community Prog-Alc/Tobacco 24 0 0 0 0 0 Radio Maintenance 16,620 0 161 500 300 500 Maintenance Contracts 1,733 3,750 5,445 7,660 5,500 7,660 Vehicle Maintenance 10,431 19,310 22,993 21,500 25,000 4,300 DARE Program 4,999 0 0 0 0 0 Chaplaincy Program 2,880 1,220 1,566 3,000 2,000 3,000 Accreditation 0 4,595 1,714 8,000 7,800 8,000 Animal Control 0 0 4,595 9,000 5,000 0 $41,349 $49,134 $51,969 $76,660 $67,600 $23,460 OTHER - Other Shop With a Cop 14,755 0 0 0 0 0 $14,755 $0 $0 $0 $0 $0 Total: Community Services $1,364,721 $1,644,542 $1,625,059 $1,839,857 $1,724,798 $938,656 Total: Contractual Services Total: OTHER - Other Total: Salaries and Wages Total: Benefits Total: Utilities Total: Supplies & Commodities Division: 56 - Police Support Services DRAFT 03/09/2023 Page 19 of 51 22 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget General Fund Police Division Detail 2023-2024 Fiscal Year Budget SAL - Salaries and Wages Salaries-Full Time 138,968 0 0 0 0 0 Salaries - Part Time 26,666 0 0 0 0 0 Salaries-Overtime 43 0 0 0 0 0 $165,677 $0 $0 $0 $0 $0 BEN - Benefits FICA 9,809 0 0 0 0 0 Medicare 2,294 0 0 0 0 0 IMRF 16,401 0 0 0 0 0 Employee Insurance 40,813 0 0 0 0 0 Deferred Comp. Contrib.7,399 0 0 0 0 0 Travel/Training 612 0 0 0 0 0 $77,328 $0 $0 $0 $0 $0 UTIL - Utilities Telephone/Internet 702 0 0 0 0 0 $702 $0 $0 $0 $0 $0 SUPP - Supplies and Commodities Office Supplies/Postage 5,741 0 0 0 0 0 Dues & Subscriptions 10,353 0 0 0 0 0 Uniforms/Clothing 155 0 0 0 0 0 $16,249 $0 $0 $0 $0 $0 Contrac - Contractual Services Maintenance Contracts/Lease 2,371 0 0 0 0 0 Legal Fees 13,300 0 0 0 0 0 $15,671 $0 $0 $0 $0 $0 Total: Court Services $275,627 $0 $0 $0 $0 $0 OTHER - Other Office Furniture & Equip.3,122 9,739 2,026 8,000 8,000 10,000 Machinery and Equipment 45,940 85,762 22,576 100,000 75,000 181,000 $49,062 $95,501 $24,602 $108,000 $83,000 $191,000 Total: Capital $49,062 $95,501 $24,602 $108,000 $83,000 $191,000 OTHER - Other Contingencies 20,411 13,362 11,207 13,000 12,000 15,000 $20,411 $13,362 $11,207 $13,000 $12,000 $15,000 Total: Contingencies $20,411 $13,362 $11,207 $13,000 $12,000 $15,000 Total: Police Department $12,611,593 $12,864,106 $13,158,527 $14,359,271 $13,815,330 $15,724,333 Division: 93 - Contingencies Total: Salaries and Wages Total: Contractual Services Total: Benefits Total: Utilities Total: Supplies & Commodities Total: OTHER - Other Total: OTHER - Other Division: 57 - Court Services Division: 91 - Capital DRAFT 03/09/2023 Page 20 of 51 23 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget General Fund Police Division Detail 2023-2024 Fiscal Year Budget BEN - Benefits Travel/Training 415 1,482 0 4,000 3,000 4,000 $415 $1,482 $0 $4,000 $3,000 $4,000 UTIL - Utilities Telephone/Internet 7,265 6,940 7,928 16,000 7,500 16,000 Cellular Phones 679 603 595 858 2,200 3,000 $7,944 $7,543 $8,523 $16,858 $9,700 $19,000 SUPP - Supplies and Commodities Office Supplies/Postage 523 398 2,860 1,000 1,500 1,000 Replacement Supplies 5,294 4,624 6,815 6,000 5,000 6,000 Dues & Subscriptions 3,675 3,419 2,515 4,000 3,500 4,000 Gas/Oil/Mileage/Carwash 4,609 2,166 1,504 8,000 2,500 8,000 Supplies/Hardware 448 61 1,449 2,000 1,000 2,000 Supplies/Hardware-ESDA 944 0 0 2,000 500 2,000 Uniforms/Clothing 5,971 2,041 4,312 6,000 5,000 6,000 Bike Unit 0 168 0 1,500 500 1,500 $21,464 $12,877 $19,455 $30,500 $19,500 $30,500 Contrac - Contractual Services Emergency Operation Center 819 0 0 1,000 500 1,000 Police Public Relations 1,654 1,050 0 3,000 1,000 3,000 Disaster Plan/Exercises/NIMS 0 0 213 3,000 1,000 3,000 Radio Maintenance 15,524 13,915 6,950 16,000 28,000 16,000 Maintenance Contracts/Lease 2,281 1,798 1,798 1,200 1,200 1,200 Building Maintenance 868 1,299 3,741 20,000 5,000 20,000 Vehicle Maintenance 7,218 19,265 8,214 20,000 8,000 20,000 Siren Maintenance 8,802 10,228 8,469 13,000 8,000 13,000 Contractual Services 0 0 0 5,250 1,000 5,250 CERT/Cadet Program 1,751 1,759 0 4,500 2,500 4,500 PEMA Search and Rescue 3,474 3,900 3,275 3,000 3,000 3,000 $42,391 $53,214 $32,660 $89,950 $59,200 $89,950 OTHER - Other Office Furniture & Equipment 855 0 788 2,000 1,000 5,000 Machinery and Equipment 556 0 4,657 5,000 3,000 5,000 Contingencies 2,175 488 1,006 3,000 2,000 3,000 $3,586 $488 $6,451 $10,000 $6,000 $13,000 Total: PEMA $75,800 $75,604 $67,089 $151,308 $97,400 $156,450 Unit: 07 - PEMA Total: Benefits Total: Utilities Total: Supplies & Commodities Total: OTHER - Other Total: Contractual Services DRAFT 03/09/2023 Page 21 of 51 24 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget General Fund Police Division Detail 2023-2024 Fiscal Year Budget Division: 02 - Administration Program SAL - Salaries and Wages Salaries-Part Time 1,637 1,111 3,948 6,500 4,000 6,500 $1,637 $1,111 $3,948 $6,500 $4,000 $6,500 BEN - Benefits FICA 119 57 257 341 250 341 Medicare 28 13 60 80 60 80 Travel/Training 121 114 1,541 1,000 1,000 1,500 $268 $184 $1,858 $1,421 $1,310 $1,921 SUPP - Supplies and Commodities Office Supplies/Postage 258 1,774 165 2,000 500 2,000 Dues & Subscriptions 375 699 375 600 600 600 $633 $2,473 $540 $2,600 $1,100 $2,600 Contrac - Contractual Services Legal Fees 0 0 0 1,000 500 5,000 Marketing and Promotions 0 0 0 0 0 2,000 Police Testing/Hiring 29,923 4,665 15,342 20,000 15,000 40,000 $29,923 $4,665 $15,342 $21,000 $15,500 $47,000 Total: Police Commission $32,461 $8,433 $21,688 $31,521 $21,910 $58,021 Police Division Total $12,719,854 $12,948,143 $13,247,304 $14,542,100 $13,934,640 $15,938,804 Total: Contractual Services Total: Salaries and Wages Total: Benefits Total: Supplies & Commodities Unit: 50 - Police Commission DRAFT 03/09/2023 Page 22 of 51 25 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Salaries and Wages 1,644,082 1,671,891 1,645,291 1,644,737 1,842,000 1,962,000 Benefits 659,144 641,808 683,376 682,509 792,890 806,925 Utilities 249,654 249,238 236,511 201,647 203,500 203,500 Supplies and Commodities 496,484 645,363 377,461 473,212 534,000 591,000 Contractual Services 929,129 1,067,203 1,477,297 1,260,350 1,267,000 1,397,000 $3,978,493 $4,275,503 $4,419,936 $4,262,455 $4,639,390 $4,960,425 Unit: 08 - Street Division Total Street Division General Fund Streets Division Summary 2023-2024 Fiscal Year Budget Classification Fund: 01 - General Fund Expenditures $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Streets Division Expense History Contractual Services Supplies and Commodities Utilities Benefits Salaries and Wages DRAFT 1/19/2023 Page 23 of 51 26 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Unit: 08 - Street Department Salaries-Full Time 385,932 398,138 382,643 462,000 300,000 495,000 Salaries-Part Time 0 0 0 0 10,000 13,000 $385,932 $398,138 $382,643 $462,000 $310,000 $508,000 FICA 23,157 25,116 23,045 28,650 17,700 31,495 Medicare 5,538 5,992 5,503 6,700 4,135 7,365 IMRF 39,004 46,129 41,046 50,600 31,350 55,880 Employee Insurance 79,000 83,463 87,357 99,500 55,000 95,000 Deferred Comp. Contribution 9,578 10,884 5,949 12,000 5,000 10,000 Travel/Conventions/Training 11,370 2,187 15,114 13,000 9,000 13,000 IL Unemployment Insurance 4,553 4,500 4,659 4,500 5,000 5,000 $172,200 $178,271 $182,673 $214,950 $127,185 $217,740 Telephone/Internet 44,446 33,010 17,483 25,000 20,000 25,000 Cellular Phones 8,459 7,747 6,181 8,500 8,000 8,500 $52,905 $40,757 $23,664 $33,500 $28,000 $33,500 SUPP - Supplies and Commodities Office Supplies/Postage 8,064 4,134 4,732 5,000 6,000 6,000 Dues & Subscriptions 3,093 2,898 2,330 3,500 3,700 4,000 Gas/Oil/Mileage/Carwash 159 0 97 500 500 500 Supplies/Hardware 91 306 0 500 500 1,000 $11,407 $7,338 $7,159 $9,500 $10,700 $11,500 Building Maintenance 8,605 12,560 23,245 20,000 20,000 25,000 Legal Notices 2,342 3,243 1,205 2,000 1,500 2,000 $10,947 $15,803 $24,450 $22,000 $21,500 $27,000 $633,391 $640,307 $620,589 $741,950 $497,385 $797,740 Total:Supplies & Commodities Contrac - Contractual Services Total: Contractual Services Total: Administration Total: UTIL - Utilities General Fund Streets Division Detail 2023-2024 Fiscal Year Budget Fund: 01 - General Fund Expenditures Division: 02 - Administration Program SAL - Salaries and Wages Total: Salaries and Wages BEN - Benefits Total: Benefits UTIL - Utilities DRAFT 1/19/2023 Page 24 of 51 27 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget General Fund Streets Division Detail 2023-2024 Fiscal Year Budget Salaries-Full Time 817,383 848,798 872,519 900,000 910,000 940,000 Salaries-Part Time 57,794 0 1,596 75,000 70,000 85,000 Salaries-Overtime 120,530 97,807 97,330 85,000 95,000 95,000 $995,707 $946,605 $971,445 $1,060,000 $1,075,000 $1,120,000 FICA 60,282 58,971 58,119 65,720 66,650 69,440 Medicare 14,098 13,791 13,592 15,370 15,587 16,250 IMRF 91,478 106,751 100,899 116,600 118,250 123,200 Employee Insurance 184,471 192,658 203,716 235,000 220,000 225,000 Deferred Comp. Contribution 19,318 21,025 22,457 25,000 22,000 25,000 $369,647 $393,196 $398,783 $457,690 $442,487 $458,890 Electricity/Gas 196,333 195,754 177,983 170,000 160,000 170,000 $196,333 $195,754 $177,983 $170,000 $160,000 $170,000 SUPP - Supplies and Commodities Gas/Oil/Mileage/Carwash 60,155 48,040 71,645 75,000 78,000 80,000 Supplies/Hardware 16,617 14,617 16,505 15,000 18,000 20,000 Supplies - Salt Purchase 487,861 227,596 310,233 350,000 375,000 385,000 Street Sign Maintenance 43,468 51,998 38,032 60,000 55,000 60,000 Aggregate Materials 4,406 4,829 4,857 4,000 5,000 5,000 Uniforms/Clothing 9,815 11,972 10,940 10,000 11,000 13,000 $622,322 $359,052 $452,212 $514,000 $542,000 $563,000 Radio Maintenance 3,057 3,225 2,574 5,000 3,000 5,000 Vehicle Maintenance 30,102 22,249 47,110 35,000 40,000 40,000 Street Light Maintenance 153,120 137,641 180,004 135,000 125,000 140,000 Street Maintenance 168,928 157,742 104,253 165,000 165,000 190,000 Storm Sewer Improvements 11,463 15,272 10,740 20,000 20,000 30,000 Contractual Services 132,863 159,676 187,179 190,000 190,000 200,000 Contractual Snow Removal 330,321 758,253 529,834 500,000 425,000 550,000 Sidewalk Maintenance 442 5,220 3,185 5,000 5,000 5,000 Equipment Maintenance 167,928 134,510 106,498 125,000 120,000 135,000 $998,224 $1,393,788 $1,171,377 $1,180,000 $1,093,000 $1,295,000 $3,182,233 $3,288,395 $3,171,800 $3,381,690 $3,312,487 $3,606,890 Total: Utilities Total:Supplies & Commodities Contrac - Contractual Services Total: Contractual Services Total: Street Maintenance UTIL - Utilities Division: 60 - Street Maintenance Program SAL - Salaries and Wages Total: Salaries and Wages BEN - Benefits Total: Benefits DRAFT 1/19/2023 Page 25 of 51 28 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget General Fund Streets Division Detail 2023-2024 Fiscal Year Budget SAL - Salaries and Wages Salaries-Full Time 82,533 85,741 84,707 90,000 89,000 93,000 Salaries-Overtime 16,669 13,067 10,317 10,000 12,000 12,000 $99,202 $98,808 $95,024 $100,000 $101,000 $105,000 FICA 6,013 6,213 5,877 6,200 6,262 6,510 Medicare 1,406 1,453 1,375 1,450 1,465 1,525 IMRF 9,833 11,148 10,111 11,000 11,110 11,550 Employee Insurance 12,231 13,226 14,156 18,000 16,000 18,000 Deferred Comp. Contribution 2,268 2,275 3,061 3,500 3,500 4,000 $31,751 $34,315 $34,580 $40,150 $38,337 $41,585 SUPP - Supplies and Commodities Supplies/Hardware 11,634 11,071 13,841 10,000 15,000 15,000 Uniforms/Clothing 0 0 0 500 500 1,500 $11,634 $11,071 $13,841 $10,500 $15,500 $16,500 Tree Removal 33,790 44,200 26,823 35,000 42,000 45,000 Contractual Services 24,242 23,506 37,700 30,000 30,000 30,000 $58,032 $67,706 $64,523 $65,000 $72,000 $75,000 $200,619 $211,900 $207,968 $215,650 $226,837 $238,085 Salaries-Full Time 183,028 191,801 188,794 210,000 206,000 219,000 Salaries-Overtime 8,022 9,939 6,831 10,000 7,000 10,000 $191,050 $201,740 $195,625 $220,000 $213,000 $229,000 FICA 11,516 12,577 11,962 13,330 13,205 14,200 Medicare 2,693 2,942 2,798 3,120 3,088 3,320 IMRF 18,828 22,795 20,331 23,650 23,430 25,190 Employee Insurance 32,028 33,556 27,161 35,000 38,000 40,000 Deferred Comp. Contribution 3,145 5,724 4,221 5,000 4,500 6,000 $68,210 $77,594 $66,473 $80,100 $82,223 $88,710 $259,260 $279,334 $262,098 $300,100 $295,223 $317,710 $4,275,503 $4,419,936 $4,262,455 $4,639,390 $4,331,932 $4,960,425 Total: Salaries and Wages BEN - Benefits Total: Benefits Total: Vehicle Maintenance Total: Street Division SAL - Salaries and Wages Division: 62 - Forestry Program Total: Salaries and Wages BEN - Benefits Total: Benefits Total:Supplies & Commodities Contrac - Contractual Services Total: Contractual Services Total: Forestry Program Division: 63 - Vehicle Maintenance Program DRAFT 1/19/2023 Page 26 of 51 29 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Unit: 09 - Community Development Salaries and Wages 347,822 352,345 342,605 374,830 439,000 464,000 Benefits 154,115 145,197 150,066 158,020 197,500 176,530 Utilities 4,146 4,024 2,373 2,473 5,000 5,000 Supplies and Commodities 26,728 9,540 8,419 14,187 17,750 20,750 Contractual Services 61,036 47,455 100,063 39,400 183,500 193,500 $593,847 $558,561 $603,526 $588,910 $842,750 $859,780 Division: 20 - Planning Program Total: 20 - Planning Program General Fund Planning Division Summary 2023-2024 Fiscal Year Budget Classification Fund: 01 - General Fund Expenditures $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 $1,000,000 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Planning Division Expense History Contractual Services Supplies and Commodities Utilities Benefits Salaries and Wages DRAFT 1/5/2023 Page 27 of 51 30 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Unit: 09 - Community Development Division: 20 - Planning Program Salaries-Full Time 349,443 338,140 369,103 430,000 355,000 455,000 Salaries-Overtime 172 0 177 2,000 300 2,000 Salaries-Commissioner 2,730 4,465 5,550 7,000 6,000 7,000 $352,345 $342,605 $374,830 $439,000 $361,300 $464,000 FICA 20,988 21,781 22,860 27,500 22,500 28,765 Medicare 4,909 5,094 5,346 6,500 5,300 6,725 IMRF 34,288 38,774 39,109 48,500 39,000 51,040 Employee Insurance 74,752 75,575 80,653 96,000 87,000 70,000 Deferred Comp. Contribution 5,554 6,597 5,663 8,000 6,500 9,000 Travel/Training 3,856 1,245 3,427 10,000 4,000 10,000 IL Unemployment Insurance 850 1,000 962 1,000 1,000 1,000 $145,197 $150,066 $158,020 $197,500 $165,300 $176,530 Telephone/Internet 3,165 1,341 1,541 3,000 1,500 3,000 Cellular Phones 859 1,032 932 2,000 1,500 2,000 $4,024 $2,373 $2,473 $5,000 $3,000 $5,000 SUPP - Supplies and Commodities Office Supplies/Postage 4,866 3,795 9,310 12,000 10,000 12,000 Dues & Subscriptions 4,434 4,587 4,837 5,000 4,600 8,000 Gas/Oil/Mileage/Carwash 240 37 40 750 200 750 $9,540 $8,419 $14,187 $17,750 $14,800 $20,750 Maintenance Contracts/Lease 1,949 1,820 1,878 2,500 2,000 2,500 Vehicle Maintenance 0 0 0 1,000 0 1,000 Legal Notices 13,382 10,514 9,335 10,000 10,000 10,000 Legal Fees 2,184 2,026 2,250 5,000 1,800 5,000 Marketing and Promotions 0 0 0 0 0 5,000 Special Projects and Programs 12,217 62,528 0 135,000 80,000 135,000 Contractual Services 4,048 4,387 10,401 15,000 15,000 15,000 Engineering Fees 13,675 18,788 15,536 15,000 18,000 20,000 $47,455 $100,063 $39,400 $183,500 $126,800 $193,500 $558,561 $603,526 $588,910 $842,750 $671,200 $859,780 Contrac - Contractual Services Total: Contractual Services Total: 20 - Planning Program Total: Salaries and Wages BEN - Benefits Total: Benefits UTIL - Utilities Total: Utilities Total: Supplies & Commodities SAL - Salaries and Wages General Fund Planning Division Detail 2023-2024 Fiscal Year Budget Fund: 01 - General Fund Expenditures DRAFT 1/5/2023 Page 28 of 51 31 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Unit: 09 - Community Development Salaries and Wages 645,504 665,429 669,669 681,665 688,000 848,000 Benefits 296,055 304,758 313,503 308,428 345,500 337,230 Utilities 4,621 4,795 4,499 4,344 5,500 5,500 Supplies and Commodities 7,489 10,638 9,430 10,223 15,500 15,500 Contractual Services 10,496 5,953 5,782 32,044 19,000 19,000 $964,165 $991,573 $1,002,883 $1,036,704 $1,073,500 $1,225,230 Division: 21 - Building & Code Compliance Program Total Building Program General Fund Building & Code Compliance Summary 2023-2024 Fiscal Year Budget Classification Fund: 01 - General Fund Expenditures $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Building Division Expense History Contractual Services Supplies and Commodities Utilities Benefits Salaries and Wages DRAFT 1/5/2023 Page 29 of 51 32 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Unit: 09 - Community Development Salaries-Full Time 664,788 669,669 679,395 685,000 730,500 845,000 Salaries-Overtime 641 0 2,270 3,000 0 3,000 $665,429 $669,669 $681,665 $688,000 $730,500 $848,000 FICA 39,806 41,796 40,832 43,000 45,290 51,770 Medicare 9,310 9,775 9,549 10,000 9,800 12,110 IMRF 65,930 75,590 71,294 76,000 71,000 91,850 Employee Insurance 170,385 164,902 168,199 185,000 178,000 150,000 Deferred Comp. Contribution 11,931 16,397 10,015 15,000 15,000 15,000 Travel/Training 5,845 3,543 6,843 15,000 8,000 15,000 IL Unemployment Insurance 1,551 1,500 1,696 1,500 1,500 1,500 $304,758 $313,503 $308,428 $345,500 $328,590 $337,230 Telephone/Internet 1,031 449 514 1,000 600 1,000 Cellular Phones 3,764 4,050 3,830 4,500 4,000 4,500 $4,795 $4,499 $4,344 $5,500 $4,600 $5,500 Office Supplies/Postage 8,213 8,192 8,107 10,000 9,000 10,000 Dues & Subscriptions 935 340 546 3,000 1,000 3,000 Gas/Oil/Mileage/Carwash 547 0 0 1,000 500 1,000 Uniforms/Clothing 943 898 1,570 1,500 1,000 1,500 $10,638 $9,430 $10,223 $15,500 $11,500 $15,500 Recording Fees 1,847 2,612 2,501 3,000 3,000 3,000 Vehicle Maintenance 0 0 0 1,000 0 1,000 Contractual Services 4,106 3,170 29,543 15,000 30,000 15,000 $5,953 $5,782 $32,044 $19,000 $33,000 $19,000 $991,573 $1,002,883 $1,036,704 $1,073,500 $1,108,190 $1,225,230 SUPP - Supplies and Commodities Total: Supplies & Commodities Contrac - Contractual Services Total: Contractual Services Total: 21 - Building Program Total: Utilities General Fund Building & Code Compliance Division Detail 2023-2024 Fiscal Year Budget Fund: 01 - General Fund Expenditures Division: 21 - Building Program SAL - Salaries and Wages Total: SAL - Salaries and Wages BEN - Benefits Total: Benefits UTIL - Utilities DRAFT 1/5/2023 Page 30 of 51 33 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Fund: 02 - Water & Sewer Fund Licenses and Permits 1,760,395 1,593,514 3,410,306 3,737,652 1,650,000 2,155,000 State of Illinois Taxes 1,862,432 1,801,904 2,114,518 2,993,857 2,730,000 3,000,000 16,729,536 16,846,437 19,140,282 19,679,120 18,095,000 20,639,000 0 0 0 0 300,000 980,000 300,234 404,488 62,163 (177,284)10,000 150,000 27,599 25,631 52,618 45,044 25,500 28,000 0 0 0 0 2,600,000 1,909,000 Revenues Total $20,680,196 $20,671,974 $24,779,887 $26,278,389 $25,410,500 $28,861,000 1,290,678 1,318,114 1,312,957 1,285,091 1,540,000 1,672,000 478,365 481,960 530,380 496,517 638,238 690,830 665,229 742,311 756,615 717,465 684,500 749,500 462,225 500,546 490,170 585,830 664,000 768,000 9,793,009 9,462,377 10,685,604 11,642,679 9,881,500 12,185,500 250,000 350,000 350,000 350,000 350,000 350,000 976,800 981,000 983,800 935,748 949,100 952,088 2,224,833 4,088,669 4,549,267 4,903,080 9,255,000 9,975,000 3,111,360 3,123,776 1,309,591 1,302,982 1,445,758 1,494,774 3,238,274 3,472,840 3,588,950 3,640,901 0 0 Expenditures Total $22,490,773 $24,521,593 $24,557,334 $25,860,293 $25,408,096 $28,837,692 Total: Water & Sewer Fund ($1,810,577)($3,849,619)$222,553 $418,096 $2,404 $23,308 Other Transfer to Debt Service Capital Debt service Depreciation Supplies and Commodities Utilities Benefits Salaries and Wages Contractual Services Classification Water, Sewer & Expansion Revenues Water, Sewer & Expansion Expenses Water & Sewer Fund Revenue/Expense Summary 2023-2024 Fiscal Year Budget Charges for Services Grants Investment Income Miscellaneous Debt Proceeds DRAFT 02/09/2023 Page 31 of 51 34 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Budget FY 2024 Proposed Budget Fund: 02 - Water and Sewer Fund LIC&PER - Licenses and Permits Meter Sales 109,345 191,884 232,195 150,000 210,000 200,000 Water Connection Fee 740,749 1,103,812 1,649,436 700,000 1,200,000 950,000 Sewer Connection Fee 737,400 2,112,245 1,654,680 775,000 2,000,000 950,000 Sewer By-Pass Fee 6,020 2,365 5,375 5,000 6,500 5,000 Recapture Fee 0 0 195,966 20,000 250,000 50,000 $1,593,514 $3,410,306 $3,737,652 $1,650,000 $3,666,500 $2,155,000 STTAX - State of Illinois Taxes Home Rule Sales Tax 1,801,904 2,114,518 2,993,857 2,730,000 3,160,000 3,000,000 $1,801,904 $2,114,518 $2,993,857 $2,730,000 $3,160,000 $3,000,000 SERV - Charges for Services Water Sales 10,445,288 11,976,340 12,195,843 11,200,000 13,000,000 12,900,000 Water Penalty 82,258 0 87,542 80,000 115,000 85,000 Sewer Sales 5,130,943 6,029,551 6,181,896 5,600,000 6,700,000 6,400,000 Sewer Penalty 41,752 0 47,139 50,000 64,000 50,000 Capital Charge 1,090,178 1,110,391 1,133,511 1,131,000 1,160,000 1,170,000 Capital Charge Penalty 10,018 0 9,189 10,000 12,000 10,000 Tower Rent 46,000 24,000 24,000 24,000 24,000 24,000 $16,846,437 $19,140,282 $19,679,120 $18,095,000 $21,075,000 $20,639,000 Grant Revenue 0 0 0 300,000 3,015,000 980,000 $0 $0 $0 $300,000 $3,015,000 $980,000 Interest Income 177,512 44,047 17,708 10,000 460,000 150,000 Realized/Unrealized G/L 226,976 18,116 (194,992)0 0 0 $404,488 $62,163 ($177,284)$10,000 $460,000 $150,000 Sale of Scrap 997 2,581 6,163 500 2,000 500 Other Reimbursements (4,201)21,930 2,989 0 6,850 2,500 Other Receipts 28,835 28,107 35,892 25,000 30,000 25,000 $25,631 $52,618 $45,044 $25,500 $38,850 $28,000 Loan Proceeds 0 0 0 2,600,000 3,350,000 1,909,000 $0 $0 $0 $2,600,000 $3,350,000 $1,909,000 $20,671,974 $24,779,887 $26,278,389 $25,410,500 $34,765,350 $28,861,000 DEBT - Debt Proceeds Total: Debt Proceeds Water & Sewer Fund Revenue Detail 2023-2024 Fiscal Year Budget Revenues Total Revenues Total: Licenses & Permits Total: State of Illinois Taxes Total: Charges for Services INT - Investment Income Total: Investment Income MISC - Miscellaneous Total: Miscellaneous GRNTS - Grants Total: Grants DRAFT 02/09/2023 Page 32 of 51 35 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Budget FY 2024 Proposed Budget Fund: 02 - Water and Sewer Fund Expenses Unit: 10 - Water Department SAL - Salaries and Wages Salaries-Full Time 219,110 219,318 228,056 280,000 230,000 285,000 Salaries-Part Time 0 0 0 0 5,000 6,500 $219,110 $219,318 $228,056 $280,000 $235,000 $291,500 FICA 13,172 13,980 13,951 17,298 14,570 18,075 Medicare 3,170 3,355 3,346 4,050 34,708 4,225 IMRF 22,177 25,886 24,591 30,690 25,850 32,065 Employee Insurance 40,618 45,398 43,471 59,000 48,000 60,000 Deferred Comp. Contrib 6,569 7,708 6,874 9,000 8,000 12,000 Travel/Training 1,174 1,918 4,211 5,000 3,000 5,000 IL Unemployment Ins.1,334 2,000 1,447 2,000 2,000 2,000 $88,214 $100,245 $97,891 $127,038 $136,128 $133,365 Telephone/Internet 10,904 7,717 630 3,000 1,000 3,000 Cellular Phones 4,177 4,178 4,412 5,000 4,800 5,000 $15,081 $11,895 $5,042 $8,000 $5,800 $8,000 SUPP - Supplies & Commodities Office Supplies/Postage 30,955 29,484 36,212 30,000 34,000 35,000 Dues & Subscriptions 1,638 266 1,504 2,000 2,000 2,000 Gas/Oil/Mileage/Wash 226 82 538 500 200 500 Supplies/Hardware 525 448 485 500 500 500 Software 0 0 0 2,000 800 2,000 Sand & Gravel 1,107 1,476 847 2,000 1,000 2,000 Water Meters 177,309 174,832 236,273 230,000 365,000 325,000 $211,760 $206,588 $275,859 $267,000 $403,500 $367,000 Contract - Contractual Services Building Maintenance 8,411 10,623 17,122 15,000 15,000 20,000 Legal Fees 233 0 617 1,500 500 1,500 Contractual Services 37,766 36,904 89,347 50,000 90,000 90,000 Equipment Maintenance 0 251 689 500 500 500 Engineering Fees 9,875 79,590 97,499 40,000 30,000 40,000 $56,285 $127,368 $205,274 $107,000 $136,000 $152,000 Admin Service Charge 175,000 175,000 175,000 175,000 175,000 175,000 Transfer to Debt Service 245,250 245,950 233,937 237,275 237,275 238,022 $420,250 $420,950 $408,937 $412,275 $412,275 $413,022 $1,010,700 $1,086,364 $1,221,059 $1,201,313 $1,328,703 $1,364,887 Total: Salaries and Wages Division: 02 - Water Administration Program Water & Sewer Fund Water/Sewer/Expansion Expense Detail 2023-2024 Fiscal Year Budget BEN - Benefits Total: Benefits UTIL - Utilities Total: Utilities Total: Supplies & Commodities Total: Contractual Services OTHER - Other Total: Other Total: Water Admin Program DRAFT 02/09/2023 Page 33 of 51 36 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Budget FY 2024 Proposed Budget Water & Sewer Fund Water/Sewer/Expansion Expense Detail 2023-2024 Fiscal Year Budget Salaries-Full Time 380,926 387,777 396,777 430,000 385,000 495,000 Salaries-Part Time 18,676 8,086 1,595 20,000 6,000 20,000 Salaries-Overtime 29,806 32,515 39,927 35,000 35,000 35,000 $429,408 $428,378 $438,299 $485,000 $426,000 $550,000 FICA 24,293 27,058 26,678 30,000 26,400 34,100 Medicare 5,719 6,364 6,273 7,000 6,200 7,975 IMRF 39,397 47,854 45,808 52,700 46,900 60,500 Employee Insurance 71,372 75,837 70,620 85,000 72,000 85,000 Deferred Comp. Contrib 11,507 13,575 13,139 17,000 16,000 20,000 $152,288 $170,688 $162,518 $191,700 $167,500 $207,575 Telephone/Internet 25,376 18,521 1,513 5,000 2,000 5,000 Electricity/Gas 137,382 146,358 165,167 140,000 140,000 150,000 $162,758 $164,879 $166,680 $145,000 $142,000 $155,000 SUPP - Supplies and Commodities Office Supplies/Postage 371 331 226 2,000 500 2,000 Replacement Supplies 8,428 6,950 19,085 10,000 10,000 10,000 Gas/Oil/Mileage/Wash 17,838 10,092 16,462 15,000 15,000 20,000 Supplies/Hardware 4,215 7,699 8,907 5,000 11,000 10,000 Chemicals 3,833 5,851 5,475 10,000 7,500 10,000 Uniforms/Clothing 2,564 4,793 3,427 5,000 3,000 5,000 $37,249 $35,716 $53,582 $47,000 $47,000 $57,000 Contract - Contractual Services Building Maintenance 5,791 7,978 1,216 20,000 8,000 20,000 Vehicle Maintenance 7,441 8,136 8,552 10,000 12,000 10,000 Contractual Services 15,711 35,739 14,057 60,000 30,000 60,000 Lake Michigan Water 8,900,976 9,994,364 10,941,410 8,921,000 11,500,000 11,200,000 Equipment Maint.168 4,356 10,299 10,000 5,000 10,000 System Maintenance 39,650 46,540 20,413 90,000 90,000 90,000 Water/Fire Hydrant 11,837 42,815 41,511 50,000 40,000 50,000 EPA Analytical 13,356 25,244 18,723 30,000 20,000 30,000 $8,994,930 $10,165,172 $11,056,181 $9,191,000 $11,705,000 $11,470,000 Transfer to Debt Service 245,250 245,950 233,937 237,275 237,275 238,022 $245,250 $245,950 $233,937 $237,275 $237,275 $238,022 Contingencies/Depreciation Depreciation 3,472,840 3,588,950 3,640,901 0 0 0 $3,472,840 $3,588,950 $3,640,901 $0 $0 $0 $13,494,723 $14,799,733 $15,752,098 $10,296,975 $12,724,775 $12,677,597 $14,505,423 $15,886,097 $16,973,157 $11,498,288 $14,053,478 $14,042,484 Unit: 11 - Sewer Department Total: Salaries and Wages SAL - Salaries and Wages Division: 30 - Water Distribution Program Total: Water Department BEN - Benefits Total: Benefits UTIL - Utilities Total: Utilities Total: Supplies & Commodities Total: Contractual Services OTHER - Other Total: Other Total: Depreciation Total: Water Distribution Program DRAFT 02/09/2023 Page 34 of 51 37 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Budget FY 2024 Proposed Budget Water & Sewer Fund Water/Sewer/Expansion Expense Detail 2023-2024 Fiscal Year Budget Salaries-Full Time 220,532 220,781 224,276 280,000 230,000 285,000 Salaries-Part Time 0 0 0 0 0 6,500 $220,532 $220,781 $224,276 $280,000 $230,000 $291,500 FICA 13,278 14,021 13,601 17,500 14,500 18,075 Medicare 3,194 3,365 3,263 4,100 3,500 4,225 IMRF 22,376 25,985 24,049 30,700 25,300 32,065 Employee Insurance 38,917 43,787 41,968 57,000 48,000 59,000 Deferred Comp. Contrib 6,712 7,735 6,674 9,000 9,000 12,000 Travel/Training 11,351 989 3,150 12,000 4,000 12,000 IL Unemployment Ins.1,045 2,000 1,237 2,000 2,000 2,000 $96,873 $97,882 $93,942 $132,300 $106,300 $139,365 Telephone/Internet 18,893 13,376 1,093 3,000 3,000 3,000 Cellular Phones 2,573 2,372 2,008 3,500 3,500 3,500 $21,466 $15,748 $3,101 $6,500 $6,500 $6,500 SUPP - Supplies and Commodities Office Supplies/Postage 29,798 28,822 32,813 30,000 34,000 35,000 Dues & Subscriptions 65,308 63,935 64,560 70,000 70,000 70,000 Gas/Oil/Mileage/Wash 1,145 2,195 848 2,500 2,000 2,500 Supplies/Hardware 1,916 1,560 1,115 3,000 3,000 3,000 $98,167 $96,512 $99,336 $105,500 $109,000 $110,500 Contract - Contractual Services Building Maintenance 12,731 10,637 15,305 20,000 15,000 20,000 Legal Fees 425 0 0 1,500 500 1,500 Contractual Services 35,733 48,247 54,696 75,000 60,000 65,000 Equipment Maintenance 774 683 12 2,000 1,000 2,000 Engineering Fees 4,791 13,731 0 15,000 10,000 15,000 $54,454 $73,298 $70,013 $113,500 $86,500 $103,500 2013/2004A Bond (Principal)414,000 0 0 0 0 0 2013/2004A Bond (Interest)12,420 0 0 0 0 0 Admin Service Charge 175,000 175,000 175,000 175,000 175,000 175,000 Transfer to Debt Service 245,250 245,950 233,937 237,275 237,275 238,022 $846,670 $420,950 $408,937 $412,275 $412,275 $413,022 $1,338,162 $925,171 $899,605 $1,050,075 $950,575 $1,064,387 Total: Contractual OTHER - Other Total: Other BEN - Benefits Total: Benefits UTIL - Utilities Total: Utilities Total: Supplies and Commodities Division: 02 - Sewer Administration Program Total: Sewer Admin Program SAL - Salaries and Wages Total: Salaries and Wages DRAFT 02/09/2023 Page 35 of 51 38 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Budget FY 2024 Proposed Budget Water & Sewer Fund Water/Sewer/Expansion Expense Detail 2023-2024 Fiscal Year Budget Salaries-Full Time 401,976 409,938 371,322 445,000 385,000 489,000 Salaries-Part Time 11,873 8,086 1,595 20,000 10,000 20,000 Salaries-Overtime 35,215 26,456 21,543 30,000 25,000 30,000 $449,064 $444,480 $394,460 $495,000 $420,000 $539,000 FICA 25,771 28,018 24,060 30,100 26,000 33,420 Medicare 6,061 6,585 5,658 7,100 6,000 7,815 IMRF 42,031 49,784 41,818 54,000 46,200 59,290 Employee Insurance 57,643 63,072 59,009 78,000 68,000 90,000 Deferred Comp. Contrib 13,079 14,106 11,621 18,000 16,000 20,000 $144,585 $161,565 $142,166 $187,200 $162,200 $210,525 Telephone/Internet 50,070 36,014 2,938 5,000 4,000 5,000 Electricity/Gas 492,936 528,079 539,704 520,000 510,000 575,000 $543,006 $564,093 $542,642 $525,000 $514,000 $580,000 SUPP - Supplies and Commodities Office Supplies/Postage 20 73 0 3,000 200 3,000 Replacement Supplies 1,938 4,218 4,712 5,000 4,500 5,000 Gas/Oil/Mileage/Wash 18,779 7,140 13,810 15,000 13,000 15,000 Supplies/Hardware 10,296 12,038 6,774 15,000 10,000 15,000 Chemicals 112,446 118,308 124,923 190,000 125,000 180,000 Sand & Gravel 980 0 0 500 500 500 Industrial Flow Monitor 1,843 2,363 2,988 8,000 5,000 7,000 Uniforms/Clothing 7,068 7,214 3,846 8,000 6,000 8,000 $153,370 $151,354 $157,053 $244,500 $164,200 $233,500 Contract - Contractual Services Vehicle Maintenance 8,360 9,863 3,938 10,000 8,000 10,000 Contractual Services 211,043 227,502 253,846 310,000 275,000 300,000 Equipment Maint.29,966 22,125 18,761 30,000 25,000 30,000 System Maintenance 107,339 60,276 34,666 120,000 50,000 120,000 $356,708 $319,766 $311,211 $470,000 $358,000 $460,000 Transfer to Debt Service 245,250 245,950 233,937 237,275 237,275 238,022 $245,250 $245,950 $233,937 $237,275 $237,275 $238,022 $1,891,983 $1,887,208 $1,781,469 $2,158,975 $1,855,675 $2,261,047 $3,230,145 $2,812,379 $2,681,074 $3,209,050 $2,806,250 $3,325,434 Total: Sewer Treatment Program SAL - Salaries and Wages Total:Salaries & Wages BEN - Benefits Total: Benefits UTIL - Utilities Total: Utilities Total: Supplies & Commodities Total: Contractual OTHER - Other Total: Other Division: 40 - Sewer Treatment Program Total: Sewer Department DRAFT 02/09/2023 Page 36 of 51 39 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Budget FY 2024 Proposed Budget Water & Sewer Fund Water/Sewer/Expansion Expense Detail 2023-2024 Fiscal Year Budget Unit: 12 - Utility Expansion Contractual Services 67,750 233,451 57,577 200,000 100,000 200,000 Engineering Fees 86,368 123,920 68,696 175,000 75,000 175,000 Machinery & Equipment 215,554 413,836 534,132 1,300,000 2,300,000 500,000 Vehicles 41,391 0 59,888 80,000 60,000 100,000 Village Green Reconstruction 2,913,332 2,561,489 0 0 0 0 Old Town Reconstruction 0 0 3,888,346 3,000,000 1,500,000 3,000,000 143rd St. West Watermain 0 0 0 2,900,000 5,000 3,200,000 143rd Water/Sewer Improvements 572,937 0 0 0 0 0 Lakewater/Essignton Rd Trans Main 0 262,505 0 0 0 0 Scada Improvements 31,801 654,705 0 0 0 0 Pump Station Improvements 158,315 0 0 0 0 0 Tower Improvements 469 0 246,013 0 36,000 2,300,000 Liftstation Improvements 752 299,361 48,428 1,600,000 800,000 500,000 $4,088,669 $4,549,267 $4,903,080 $9,255,000 $4,876,000 $9,975,000 2013/2004A Bond (Principal)966,000 0 0 0 0 0 2013/2004A Bond (Interest)13,455 0 0 0 0 0 2013/2004B Bond (Principal)400,000 0 0 0 0 0 2013/2004B Bond (Interest)7,500 0 0 0 0 0 2008 Bond (Principal)0 0 0 0 0 0 2015/2008 Bond (Principal)620,000 645,000 665,000 700,000 700,000 725,000 2015/2008 Bond (Interest)503,150 477,350 450,750 422,750 422,750 393,750 IEPA Loan (Principal)161,392 163,416 165,465 167,540 167,540 169,640 IEPA Loan (Interest)25,859 23,825 21,767 20,468 20,468 18,367 IEPA Loan 2 (Principal)0 0 0 110,000 89,266 146,096 IEPA Loan 2 (Interest)0 0 0 25,000 26,929 41,921 $2,697,356 $1,309,591 $1,302,982 $1,445,758 $1,426,953 $1,494,774 $6,786,025 $5,858,858 $6,206,062 $10,700,758 $6,302,953 $11,469,774 $24,521,593 $24,557,334 $25,860,293 $25,408,096 $23,162,681 $28,837,692 OTHER - Other Division: 91 - Capital Unit: 12 - Utility Expansion Total: Water & Sewer Fund Total: Other Division: 92 - Bonds OTHER - Other Total: Other Unit Total: 12 - Utility Expansion DRAFT 02/09/2023 Page 37 of 51 40 Classification FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Fund: 11 - Capital Fund State of Illinois Taxes 3,725,422 3,604,349 4,229,671 5,988,612 5,655,000 6,150,000 Utility Taxes 3,553,905 3,298,561 3,287,274 3,812,880 3,600,000 3,925,000 Licenses and Permits 59,935 98,949 140,819 268,858 133,000 140,000 Fines and Forfeits 359,600 320,551 344,100 402,727 350,000 375,000 Charges for Services 36,473 29,810 44,880 25,290 28,000 28,000 Grants 195,273 258,216 1,025,569 2,431,421 1,990,000 11,965,000 Investment Income 283,557 316,491 34,709 6,422 25,000 250,000 Miscellaneous 3,818,643 882,169 296,080 226,443 105,000 1,150,000 Interfund Transfers 1,859,212 2,008,012 3,121,257 6,002,811 1,000,000 1,400,000 Revenues Total $13,892,020 $10,817,108 $12,524,359 $19,165,464 $12,886,000 $25,383,000 Transfers 2,018,731 2,022,925 2,025,793 2,058,885 2,045,682 2,045,399 Contractual Services 92,411 110,892 110,706 804,703 440,000 110,000 Machinery and Equipment 520,401 602,964 791,744 520,463 1,800,000 963,000 Storm/Drainage Improvements 57,345 119,933 19,902 18,463 150,000 40,000 Bridge Repairs & Construction 152,933 6,744 26,283 189,325 850,000 1,025,000 Sidewalk, Curb, & Bikepath 15,611 431,540 583,882 257,068 1,000,000 700,000 Traffic Control Device 47,839 462,786 48,146 95,691 575,000 0 Roadway Improvements 3,716,920 5,099,031 7,348,411 4,889,757 8,975,000 19,590,000 Misc. Capital Expenses 4,109,736 655,242 1,014,114 271,103 500,000 690,000 Building Improvements 125,050 46,691 208,863 701,099 800,000 1,100,000 Beautification Improvements 194,312 191,185 0 77,553 150,000 150,000 Expenses Total $11,051,289 $9,749,933 $12,177,844 $9,884,110 $17,285,682 $26,413,399 Total: Capital Fund $2,840,731 $1,067,175 $346,515 $9,281,354 ($4,399,682)($1,030,399) **Capital Fund has a 4/30/22 Fund Balance of $28,320,359 Capital Fund Revenues Capital Fund Expenses Capital Improvement Fund Summary 2023-2024 Fiscal Year Budget DRAFT 03/09/2023 Page 38 of 51 41 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Budget FY 2024 Proposed Budget Fund: 11 - Capital Improvement Fund Home Rule Sales Tax 3,604,349 4,229,671 5,988,612 5,655,000 6,375,000 6,150,000 $3,604,349 $4,229,671 $5,988,612 $5,655,000 $6,375,000 $6,150,000 Utility Tax 2,797,119 2,802,003 3,183,944 3,000,000 3,275,000 3,225,000 Local Motor Fuel Tax 501,442 485,271 628,936 600,000 700,000 700,000 $3,298,561 $3,287,274 $3,812,880 $3,600,000 $3,975,000 $3,925,000 Annexation/Impact Fee 0 0 84,774 30,000 75,000 30,000 Traffic Impact Fee 91,200 102,688 115,644 75,000 90,000 75,000 Municipal Facilities Fee 0 16,500 57,000 20,000 55,000 25,000 Recapture Fee 7,749 21,631 11,440 8,000 316,000 10,000 $98,949 $140,819 $268,858 $133,000 $536,000 $140,000 Red Light Fines 320,551 344,100 402,727 350,000 390,000 375,000 $320,551 $344,100 $402,727 $350,000 $390,000 $375,000 Impound Fee 26,150 41,000 24,750 25,000 25,000 25,000 Daily Storage Fee for Impound 3,660 3,880 540 3,000 6,000 3,000 $29,810 $44,880 $25,290 $28,000 $31,000 $28,000 Grant Revenue 5,395 196,026 167,445 1,990,000 310,400 1,665,000 IDOT Reimbursement 143rd St. East 0 0 0 0 0 8,800,000 STP Grant 252,821 829,543 2,263,976 0 525,000 1,500,000 $258,216 $1,025,569 $2,431,421 $1,990,000 $835,400 $11,965,000 Interest Income 316,491 34,709 6,422 25,000 375,000 250,000 $316,491 $34,709 $6,422 $25,000 $375,000 $250,000 Sales-Fixed Assets 65,918 2,828 69,363 5,000 1,500 5,000 Donation/Contribution 300,000 0 0 0 0 0 Other Reimbursements 328,938 112,260 36,402 20,000 50,000 1,050,000 Other Receipts 187,313 180,992 120,678 80,000 75,000 95,000 $882,169 $296,080 $226,443 $105,000 $126,500 $1,150,000 Transfer From General 2,008,012 3,121,257 6,002,811 1,000,000 1,000,000 1,400,000 $2,008,012 $3,121,257 $6,002,811 $1,000,000 $1,000,000 $1,400,000 $10,817,108 $12,524,359 $19,165,464 $12,886,000 $13,643,900 $25,383,000 STTAX - State of Illinois Taxes Total: State of Illinois Taxes Revenues Capital Improvement Fund Revenue & Expense Detail 2023-2024 Fiscal Year Budget OTHTX - Other Taxes Total: Other Taxes LIC&PER - Licenses and Permits Total: Licenses and Permits FIN - Fines and Forfeits Total: Fines and Forfeits SERV - Charges for Services Total: Charges for Services GRNTS - Grants Total: Grants INT - Investment Income Total: Investment Income Total: Miscellaneous MISC - Miscellaneous INTER - Interfund Transfers Total: Interfund Transfers Revenues Total DRAFT 03/09/2023 Page 39 of 51 42 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Budget FY 2024 Proposed Budget Capital Improvement Fund Revenue & Expense Detail 2023-2024 Fiscal Year Budget Police Fleet/Equipment 191,619 185,638 348,820 350,000 350,000 350,000 Body Cameras (reserve)0 0 0 1,000,000 163,000 163,000 Public Works/Community Dev.411,345 606,106 171,643 450,000 550,000 450,000 127th St. & Plfd-Naperville Rd 67,567 43,362 47,522 175,000 5,000 0 Rt. 30 and 143rd - engineering 0 0 0 100,000 0 0 Rt. 59 & Champion Dr. 0 0 48,169 200,000 50,000 0 Meadow Ln./143rd St. Signal 395,219 4,784 0 0 0 0 135th St. & Rt. 59 - engineering 0 0 0 100,000 0 0 431,540 583,882 257,068 Bike Path 850,000 100,000 550,000 Curb & Sidewalk 150,000 150,000 150,000 2,967,199 3,712,791 1,347,774 2,500,000 2,700,000 2,750,000 I-55 Interchange Design 46,655 26,340 856 0 0 40,000 143rd St. East Extension 1,300,370 1,223,145 3,416,416 5,300,000 3,500,000 8,100,000 143rd St. West Extension 176,566 318,989 115,334 1,000,000 125,000 8,000,000 Lockport Street bypass - eng 0 0 0 0 0 250,000 Renwick Corridor engineering 3,043 200 0 50,000 0 325,000 Village Green project 519,083 1,786,242 0 0 0 0 Woodfarm Road - eng 16,347 0 0 0 0 0 69,768 280,704 9,377 125,000 125,000 125,000 6,744 26,283 189,325 850,000 175,000 1,025,000 119,933 19,902 18,463 150,000 110,000 40,000 Settler's Park 91,779 28,423 0 50,000 0 50,000 Transportation Plan 0 0 4,374 135,000 130,000 0 Street Lights - LED/pole 186,134 163,451 159,970 125,000 125,000 125,000 Misc. Engineering 54,713 299,164 106,759 150,000 100,000 100,000 PD Parking Lot resurface 13,660 521,718 0 0 0 0 Pond Drainage 0 0 0 40,000 0 40,000 Grade Crossing Elimination Study 0 0 0 0 0 100,000 Gateway signage 0 0 0 0 0 200,000 PACE Lot 308,956 1,358 0 0 0 0 Riverfront Engineering (OSLAD)0 0 0 0 0 75,000 191,185 0 0 0 0 0 0 0 77,553 150,000 85,000 150,000 46,691 208,863 701,099 800,000 700,000 750,000 PEMA Building 0 0 0 0 350,000 110,892 110,706 110,704 110,000 110,000 110,000 0 0 693,999 330,000 138,500 0 2,022,925 2,025,793 2,058,885 2,045,682 2,060,600 2,045,399 $9,749,933 $12,177,844 $9,884,110 $17,285,682 $11,552,100 $26,413,399 Emerald Ash Borer Expenditure Grand Totals: Building Improvements Contractual Services (Red Lt Camera) Economic Incentive Transfer to Debt Service Beautification Improvements Miscellaneous Capital Expenses Bridge Repairs & Construction Storm & Drainage Improvements Expenses Roadway Improvements Pavement Patching Machinery and Equipment Traffic Control Device Sidewalk, Curb, & Bikepath DRAFT 03/09/2023 Page 40 of 51 43 Description 2020 Actual 2021 Actual 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Fund: 04 - Motor Fuel Tax State of Illinois Taxes MFT Entitlements 1,485,096 1,655,228 1,742,475 1,775,000 1,750,000 1,775,000 Grant Revenue 0 1,304,272 869,515 435,000 435,000 0 Total: State of Illinois Taxes $1,485,096 $2,959,500 $2,611,990 $2,210,000 $2,185,000 $1,775,000 Investment Income Interest Income 68,615 8,601 4,566 2,000 125,000 75,000 Total: Investment Income $68,615 $8,601 $4,566 $2,000 $125,000 $75,000 Revenues Total $1,553,711 $2,968,101 $2,616,556 $2,212,000 $2,310,000 $1,850,000 Division: 91 - Capital Street Improvements 1,254,866 2,122,092 1,665,386 2,500,000 2,500,000 2,500,000 127th St. & Plfd-Naper Rd 0 0 0 0 0 2,000,000 Total: Other $1,254,866 $2,122,092 $1,665,386 $2,500,000 $2,500,000 $4,500,000 Division Total: 91 - Capital $1,254,866 $2,122,092 $1,665,386 $2,500,000 $2,500,000 $4,500,000 Division: 99 - Transfers Transfer to General 0 0 0 0 0 0 Total: 99 - Transfers $0 $0 $0 $0 $0 $0 Total: Non-Departmental $1,254,866 $2,122,092 $1,665,386 $2,500,000 $2,500,000 $4,500,000 Expenditures Total $1,254,866 $2,122,092 $1,665,386 $2,500,000 $2,500,000 $4,500,000 Total: 04 - Motor Fuel Tax $298,845 $846,009 $951,170 ($288,000)($190,000)($2,650,000) **MFT has a 4/30/22 Fund Balance of $5,570,751 Motor Fuel Tax Fund 2023-2024 Fiscal Year Budget Revenues Expenditures Revenue & Expense Detail $1,000,000 $1,100,000 $1,200,000 $1,300,000 $1,400,000 $1,500,000 $1,600,000 $1,700,000 $1,800,000 $1,900,000 2020 Actual 2021 Actual 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget MFT Revenue History MFT Entitlements DRAFT 02/23/2023 Page 41 of 51 44 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Fund: 05 - Bond and Interest Fund Property Taxes Property Tax Revenue 114,802 0 0 0 0 0 Total: Property Taxes $114,802 $0 $0 $0 $0 $0 Investment Income Interest Income 11,223 1,276 0 1,000 0 0 Total: Investment Income $11,223 $1,276 $0 $1,000 $0 $0 Debt Proceeds Refunding Bond Proceeds 0 2,790,000 2,385,000 0 0 0 Total: Debt Proceeds $0 $2,790,000 $2,385,000 $0 $0 $0 Interfund Transfers Transfer From Water & Sewer 981,000 983,800 935,748 949,100 949,100 952,088 Transfer From Capital 2,022,925 2,025,793 2,058,885 2,045,682 2,045,191 2,045,399 Total: Interfund Transfers $3,003,925 $3,009,593 $2,994,633 $2,994,782 $2,994,291 $2,997,487 Revenues Total $3,129,950 $5,800,869 $5,379,633 $2,995,782 $2,994,291 $2,997,487 Bond & Interest Fund 2023-2024 Fiscal Year Budget Revenues Revenue & Expense Detail $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 $5,000,000 $5,500,000 $6,000,000 FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Bond & Interest Expense History Expenditures DRAFT 02/23/2023 Page 42 of 51 45 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Bond & Interest Fund 2023-2024 Fiscal Year Budget Revenue & Expense Detail Unit: 00 - Non-Departmental Division: 92 - Bonds OTHER - Other 2009 Refunding Bond(Princ)110,000 0 0 0 0 0 2009 Refunding Bond (Int)4,400 0 0 0 0 0 2010 Bond (Principal)805,000 840,000 0 0 0 0 2010 Bond (Interest)176,000 143,800 0 0 0 0 2012 Refunding Bond (Princ)695,000 715,000 735,000 0 0 0 2012 Refunding Bond (Int)135,000 114,150 92,700 0 0 0 2014 Refunding Bond (Princ)950,000 965,000 1,025,000 1,060,000 1,060,000 1,095,000 2014 Refunding Bond (Int)255,850 236,850 207,900 177,150 177,150 145,350 2020 Refunding Bond (Princ)0 0 910,000 935,000 935,000 945,000 2020 Refunding Bond (Int)0 0 25,749 14,100 13,607 7,088 2021 Refunding Bond (Princ)0 0 0 790,000 790,000 795,000 2021 Refunding Bond (Int)0 0 0 18,532 18,532 10,049 Payment to Escrow Agent 0 2,754,483 2,355,000 0 0 0 Bond Issuance Costs 0 33,300 28,400 0 0 0 Total: OTHER - Other $3,131,250 $5,802,583 $5,379,749 $2,994,782 $2,994,289 $2,997,487 Expenditures Total $3,131,250 $5,802,583 $5,379,749 $2,994,782 $2,994,289 $2,997,487 Total: Bond & Interest ($1,300)($1,714)($116)$1,000 $2 $0 Expenditures DRAFT 02/23/2023 Page 43 of 51 46 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Fund: 07 - Tort Immunity Fund Property Taxes Property Tax Revenue 399,426 150,397 349,689 685,000 678,000 825,000 Total: Property Taxes $399,426 $150,397 $349,689 $685,000 $678,000 $825,000 Investment Income Interest Income 8,237 484 0 300 0 0 Total: Investment Income $8,237 $484 $0 $300 $0 $0 Other Reimbursements $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Transfers Transfer from General 0 0 0 300,000 300,000 0 Total: Transfers $0 $0 $0 $300,000 $300,000 $0 Revenues Total $407,663 $150,881 $349,689 $985,300 $978,000 $825,000 Unit: 00 - Non-Departmental Contractual Services Bond-Treasurer 336 336 336 336 336 336 Comm. Umbrella Liability 157,579 220,751 352,420 437,500 436,500 525,000 Workman's Comp. Ins.189,364 189,914 240,481 315,000 311,000 360,000 Total: Contractual Services $347,279 $411,001 $593,237 $752,836 $747,836 $885,336 Expenditures Total $347,279 $411,001 $593,237 $752,836 $747,836 $885,336 Total: Tort Immunity Fund $60,384 ($260,120)($243,548)$232,464 $230,164 ($60,336) **Tort Immunity Fund has a 4/30/22 Fund Balance of ($761) Expenditures Tort Immunity Fund Revenue & Expense Detail 2023-2024 Fiscal Year Budget Revenues MISC - Miscellaneous Total: Miscellaneous $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Tort Immunity Revenue History Property Tax Revenue DRAFT 11/10/2022Page 44 of 51 47 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Fund: 08 - Audit Fund Property Taxes Property Tax Revenue 36,152 30,373 40,353 50,000 51,023 50,000 Total: Property Taxes $36,152 $30,373 $40,353 $50,000 $51,023 $50,000 Investment Income Interest Income 513 33 0 100 0 0 Total: Investment Income $513 $33 $0 $100 $0 $0 Revenues Total $36,665 $30,406 $40,353 $50,100 $51,023 $50,000 Unit: 00 - Non-Departmental Division: 00 - Non-Divisional Contrac - Contractual Services Audit Village 39,565 40,320 42,550 45,000 44,000 47,000 Total: Contractual Services $39,565 $40,320 $42,550 $45,000 $44,000 $47,000 Expenditures Total $39,565 $40,320 $42,550 $45,000 $44,000 $47,000 Total: Audit Fund ($2,900)($9,914)($2,197)$5,100 $7,023 $3,000 **Audit Fund has a 4/30/22 Fund Balance of $7,582 Audit Fund Revenue & Expense Detail 2023-2024 Fiscal Year Budget Revenues Expenditures $20,000 $25,000 $30,000 $35,000 $40,000 $45,000 $50,000 $55,000 FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 AdoptedBudget FY 2024 ProposedBudget Audit Fund Revenue History Property TaxRevenue DRAFT 11/10/2022Page 45 of 51 48 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Fund: 10 - Police Pension Fund Investment Income Interest Income 1,012,050 890,572 1,945,058 625,000 650,000 650,000 Realized Gain/Loss 765,702 580,856 365,528 300,000 300,000 300,000 Unrealized Gain/Loss (1,129,771)7,324,489 (5,853,280)200,000 200,000 200,000 Total: Investment Income $647,981 $8,795,917 ($3,542,694)$1,125,000 $1,150,000 $1,150,000 MISC - Miscellaneous Other Receipts 0 226 50 0 0 0 Employee Contributions 580,065 655,092 1,090,656 695,000 775,000 695,000 Employer Contributions 1,297,308 1,577,460 1,697,212 1,700,000 1,700,000 1,950,000 Total: Miscellaneous $1,877,373 $2,232,778 $2,787,918 $2,395,000 $2,475,000 $2,645,000 Revenues Total $2,525,354 $11,028,695 ($754,776)$3,520,000 $3,625,000 $3,795,000 Police Pension Fund Revenue & Expense Detail 2023-2024 Fiscal Year Budget Revenues $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 FY 2020 ActualFY 2021 ActualFY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Police Pension Contribution History Employee Contributions Employer Contributions DRAFT 11/10/2022Page 46 of 51 49 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Police Pension Fund Revenue & Expense Detail 2023-2024 Fiscal Year Budget Unit: 00 - Non-Departmental Division: 00 - Non-Divisional Salaries and Wages Pension Payments 640,262 811,860 936,000 1,100,000 1,175,000 1,250,000 Total: Salaries & Wages $640,262 $811,860 $936,000 $1,100,000 $1,175,000 $1,250,000 Benefits Travel/Training 6,765 (341)2,185 5,000 3,000 5,000 Total: Benefits $6,765 ($341)$2,185 $5,000 $3,000 $5,000 Supplies and Commodities Office Supplies/Postage 123 0 0 500 500 500 Dues & Subscriptions 7,111 8,213 8,074 8,500 8,500 8,500 Total: Supplies & Commodities $7,234 $8,213 $8,074 $9,000 $9,000 $9,000 Contractual Services Contractual Services 29,146 35,946 44,311 35,000 40,000 40,000 Total: Contractual Services $29,146 $35,946 $44,311 $35,000 $40,000 $40,000 Other Investment Expense 115,940 134,947 152,481 130,000 140,000 150,000 Total: OTHER - Other $115,940 $134,947 $152,481 $130,000 $140,000 $150,000 Total: Non-Divisional $799,347 $990,625 $1,143,051 $1,279,000 $1,367,000 $1,454,000 Expenditures Total $799,347 $990,625 $1,143,051 $1,279,000 $1,367,000 $1,454,000 Total: Police Pension Fund $1,726,007 $10,038,070 ($1,897,827)$2,241,000 $2,258,000 $2,341,000 Expenditures DRAFT 11/10/2022Page 47 of 51 50 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Fund: 14 - D.A.R.E. Fund Investment Income Interest Income $239 $11 $12 $100 $120 $100 Total: Investment Income $239 $11 $12 $100 $120 $100 Miscellaneous DARE Contributions 14,198 0 11,711 20,000 14,000 15,000 Total: Miscellaneous $14,198 $0 $11,711 $20,000 $14,000 $15,000 Revenues Total $14,437 $11 $11,723 $20,100 $14,120 $15,100 Unit: 00 - Non-Departmental Division: 00 - Non-Divisional D.A.R.E. Program 23,142 0 4,958 20,000 8,500 20,000 Total: Non-Divisional $23,142 $0 $4,958 $20,000 $8,500 $20,000 Expenditures Total $23,142 $0 $4,958 $20,000 $8,500 $20,000 Total: D.A.R.E. Fund ($8,705)$11 $6,765 $100 $5,620 ($4,900) **DARE Fund has a 4/30/22 Fund Balance of $10,313 D.A.R.E. Fund 2023-2024 Fiscal Year Budget Revenues Expenditures Revenue & Expense Detail $0 $5,000 $10,000 $15,000 $20,000 $25,000 FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget DARE Contribution History DARE Contributions DRAFT 02/23/2023 Page 48 of 51 51 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Fund: 17 - Tax Increment Financing Fund-Downtown Property Taxes Property Tax Revenue 735,635 775,317 757,117 775,000 747,531 750,000 Total: Property Taxes $735,635 $775,317 $757,117 $775,000 $747,531 $750,000 INT - Investment Income Interest Income 16,472 2,425 0 2,000 0 500 Total: Investment Income $16,472 $2,425 $0 $2,000 $0 $500 Revenues Total $752,107 $777,742 $757,117 $777,000 $747,531 $750,500 Unit: 00 - Non-Departmental Division: 91 - Capital Other Contractual Services 112,764 652,978 2,109,178 1,000,000 475,000 225,000 Facade Improvements 0 0 0 50,000 0 20,000 Total: Capital $112,764 $652,978 $2,109,178 $1,050,000 $475,000 $245,000 Division: 99 - Transfers OTHER - Other Property Tax Rebate 0 0 0 0 350,000 350,000 Total: Transfers $0 $0 $0 $0 $350,000 $350,000 Expenditures Total $112,764 $652,978 $2,109,178 $1,050,000 $825,000 $595,000 Total: Tax Increment Financing Fund $639,343 $124,764 ($1,352,061)($273,000)($77,469)$155,500 **TIF Fund has a 4/30/22 Fund Balance of ($232,917) Downtown Tax Increment Financing Fund 2023-2024 Fiscal Year Budget Revenues Expenditures Revenue & Expense Detail $480,000 $530,000 $580,000 $630,000 $680,000 $730,000 $780,000 $830,000 FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget TIF Property Tax Revenue History Property Tax Revenue DRAFT 02/23/2023 Page 49 of 51 52 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Fund: 18 - Tax Increment Financing Fund - Rt 30 Property Taxes Property Tax Revenue 968 11,723 121,715 130,000 640,000 800,000 Total: Property Taxes $968 $11,723 $121,715 $130,000 $640,000 $800,000 INT - Investment Income Interest Income 6 16 0 50 50 50 Total: Investment Income $6 $16 $0 $50 $50 $50 Revenues Total $974 $11,739 $121,715 $130,050 $640,050 $800,050 Unit: 00 - Non-Departmental Division: 91 - Capital Other Contractual Services 0 0 0 0 0 0 Total: Capital $0 $0 $0 $0 $0 $0 Property Tax Rebate 0 5,997 57,029 58,000 300,000 400,000 $0 $5,997 $57,029 $58,000 $300,000 $400,000 Expenditures Total $0 $5,997 $57,029 $58,000 $300,000 $400,000 Total: Tax Increment Financing Fund $974 $5,742 $64,686 $72,050 $340,050 $400,050 **TIF Fund has a 4/30/22 Fund Balance of $71,401 OTHER - Other Total: Other Route 30 Tax Increment Financing Fund Revenue & Expense Detail 2023-2024 Fiscal Year Budget Revenues Expenditures $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Rt. 30 TIF Property Tax Revenue History Property Tax Revenue DRAFT 02/23/2023 Page 50 of 51 53 Description FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2023 Estimated Amount FY 2024 Proposed Budget Fund: 27 - Alcohol Enforcement Fund Fines and Forfeits Alcohol Fines 21,203 15,858 19,872 15,000 20,000 15,000 Total: Fines and Forfeits $21,203 $15,858 $19,872 $15,000 $20,000 $15,000 Investment Income Interest Income 954 70 0 100 100 100 Total: Investment Income $954 $70 $0 $100 $100 $100 Revenues Total $22,157 $15,928 $19,872 $15,100 $20,100 $15,100 Unit: 00 - Non-Departmental Division: 99 - Transfers Other Transfer to General 25,000 25,000 25,000 20,000 20,000 20,000 Total: Other $25,000 $25,000 $25,000 $20,000 $20,000 $20,000 Expenditures Total $25,000 $25,000 $25,000 $20,000 $20,000 $20,000 Total: Alcohol Enforcement Fund ($2,843)($9,072)($5,128)($4,900)$100 ($4,900) **Alcohol Enforcement Fund has a 4/30/22 Fund Balance of $24,004 Alcohol Enforcement Fund 2023-2024 Fiscal Year Budget Revenues Expenditures Revenue & Expense Detail $8,200 $10,200 $12,200 $14,200 $16,200 $18,200 $20,200 $22,200 FY 2020 Actual FY 2021 Actual FY 2022 Actual FY 2023 Adopted Budget FY 2024 Proposed Budget Alcohol Fines History Alcohol Fines DRAFT 02/23/2023 Page 51 of 51 54