Loading...
HomeMy Public PortalAbout02-28-2022 COW Agenda and PacketCommittee of the Whole Workshop of the President and the Board of Trustees Monday, February 28, 2022 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 Special Meeting and Committee of the Whole Workshop held on February 14, 2022. 02-14-2022 Special Village Board Minutes 02-14-2022 COW Minutes C.PRESIDENTIAL COMMENTS D.TRUSTEES COMMENTS E.PUBLIC COMMENTS (3-5 minutes) F.WORKSHOP F.1.PATRIOTIC PICNIC AND FIREWORKS Staff is seeking input from the Village Board on the Plainfield Park District’s request for a financial contribution of $10,000 in addition to the request of law enforcement assistance for the Patriotic Picnic and Fireworks Event to be held on July 3, 2022. Plainfield Park District Funding Request Staff Report F.2.2022-2023 DRAFT FISCAL YEAR BUDGET Staff will present the Draft 2022-2023 Overall General Fund Revenues and expenditures. Draft General Fund and Tort Immunity Budgets 1-31-22 General Fund Budget Performance Report F.3.FINANCIAL POLICIES Staff will present the annual review of the Village’s Financial Policies. Financial Policies Staff Report 1 Committee of the Whole Workshop of the President and the Board of Trustees Page - 2 REMINDERS - •March 7 Village Board Meeting – 7:00 p.m. •March 9 Coffee with the Mayor – 9:00 a.m. •March 10 Historic Preservation Commission – 7:00 p.m. •March 14 Next Committee of the Whole Workshop – 7:00 p.m. 2 VILLAGE OF PLAINFIELD SPECIAL MEETING MINUTES FEBRUARY 14, 2022 AT:VILLAGE HALL BOARD PRESENT: J.ARGOUDELIS, B.WOJOWSKI (ELECTRONIC), H.BENTON (ELECTRONIC), P.KALKANIS, C.LARSON, T.RUANE. BOARD ABSENT: K.CALKINS. OTHERS PRESENT: J.BLAKEMORE, VILLAGE ADMINISTRATOR; M.GIBAS, VILLAGE CLERK; T.PLECKHAM, MANAGEMENT SERVICES DIRECTOR; A.PERSONS, PUBLIC WORKS DIRECTOR; D.KISSEL, WASTEWATER SUPERINTENDENT; R.JESSEN, PUBLIC IMPROVEMENTS SUPERINTENDENT; S.THREEWITT, LEAD ENGINEER; J.PROULX, PLANNING DIRECTOR; A DE BONI, COMMUNITY RELATIONS DIRECTOR; J.KASTRANTAS, IT DIRECTOR; L.SPIRES, BUILDING OFFICIAL; AND J.KONOPEK, CHIEF OF POLICE. CALL TO ORDER, ROLL CALL, PLEDGE Mayor Argoudelis called the meeting to order at 7:00 p.m. Roll call was taken, Trustee Calkins was absent, all other Trustees were present. Mayor Argoudelis led the Pledge of Allegiance. There were approximately 8 persons in the audience. PUBLIC COMMENTS (3-5 minutes) None. PROCLAIM FEBRUARY 15, 2022 AS DAVID J. COUNTRYMAN DAY Mayor Argoudelis proclaimed February 15, 2022 as David J. Countryman Day, congratulated him on his retirement, and thanked him for his nearly 40 years of service. BUSINESS MEETING 1)APPROVAL OF THE AGENDA Trustee Ruane moved to approve the Agenda. Second by Trustee Kalkanis. Vote by roll call. Wojowski, yes; Benton, yes; Calkins, absent; Kalkanis, yes; Larson, yes; Ruane, yes. 5 yes, 0 no, 1 absent. Motion carried. 2) GOV HR Trustee Kalkanis moved to authorize the Village Administrator to execute a Full Scope Recruitment Service contract with GovHR USA to recruit a Director of Public Works as presented for the total amount not to exceed $23,500.00. Second by Trustee Benton. Vote by roll call. Wojowski, yes; Benton, yes; Calkins, absent; Kalkanis, yes; Larson, no; Ruane, yes. 4 yes, 1 no, 1 absent. Motion carried. 3) COM ED Trustee Wojowski moved to authorize the Village President to sign the Letter of Agreement with ComEd for the 143rd Street East Extension related to Land Acquisition and Streambank Stabilization. Second by Trustee Larson. Vote by roll call. Wojowski, yes; Benton, yes; Calkins, absent; Kalkanis, yes; Larson, yes; Ruane, yes. 5 yes, 0 no, 1 absent. Motion carried. 3 Village of Plainfield Special Meeting Minutes – February 14, 2021 Page 2 4)2022 SHAMROCK SHENANIGANS RUN Trustee Ruane moved to approve the 2022 Shamrock Shenanigans Run to be held on Sunday, March 13, 2022 from 12:40 p.m. to 12:55 p.m. Second by Trustee Kalkanis. Andy Remley, DNA, gave a brief overview of the race. Mr. Remly pointed out that the race is a one- mile route and is limited to 100 runners. Based on that and since the road will already be closed for the Irish Parade, they are requesting a reduction of fees from $2,500 to $500.00. Trustee Larson requested that the applicant work with the Police Department regarding parking. Vote by roll call. Wojowski, yes; Benton, yes; Calkins, absent; Kalkanis, yes; Larson, yes; Ruane, yes. 5 yes, 0 no, 1 absent. Motion carried. Trustee Larson moved to adjourn the Special Meeting. Second by Trustee Kalkanis. Voice Vote. All in favor, 0 opposed. Motion carried. The meeting adjourned at 7:25 p.m. Michelle Gibas, Village Clerk 4 Minutes of the Committee of the Whole Workshop of the President and the Board of Trustees Held on February 14, 2022 In the Boardroom Mayor Argoudelis called the meeting to order at 7:26 p.m. Board Present: Mayor Argoudelis, Trustee Wojowski (Electronic), Trustee Benton (Electronic), Trustee Kalkanis, Trustee Larson, and Trustee Ruane. Board Absent: Trustee Calkins. Others Present: Joshua Blakemore, Village Administrator; Michelle Gibas, Village Clerk; Traci Pleckham, Management Services Director; Allen Persons, Public Works Director; Doug Kissel, Wastewater Superintendent; Randy Jessen, Public Improvements Superintendent; Scott Threewitt, Lead Engineer; Jon Proulx, Planning Director; Amy De Boni, Community Relations Director; James Kastrantas, IT Director; Lonnie Spires, Building Official; and John Konopek, Chief of Police. Trustee Larson moved to approve the Minutes of the Committee of the Whole Workshop held on January 24, 2022. Second by Trustee Ruane. Voice Vote. All in favor, 0 opposed. Motion carried. PRESIDENTIAL COMMENTS Mayor Argoudelis offered condolences to the Calkins family. TRUSTEE COMMENTS Trustee Ruane: Offered condolences to the Calkins family. Congratulated Dave Countryman on his retirement and thanked him for his service. Trustee Larson: Offered condolences to the Calkins family. Congratulated Dave Countryman on his retirement and thanked him for his service. Trustee Benton: Offered condolences to the Calkins family. Congratulated Dave Countryman on his retirement and thanked him for his service. Trustee Wojowski: Offered condolences to the Calkins family. Congratulated Dave Countryman on his retirement and thanked him for his service. Trustee Kalkanis: Offered condolences to the Calkins family. Congratulated Dave Countryman on his retirement and thanked him for his service. PUBLIC COMMENTS No Comments. WORKSHOP 1) KELLER FARM DEVELOPMENT (CASE NO. 1955-010622.CP) Jon Proulx stated that applicant is seeking input and direction from the Village Board on a mixed-use development at the northwest corner of Illinois Route 126 and Wallin Drive. The proposed concept plan includes 334 single-family detached dwelling units, 100 townhome dwelling units, and a 10-acre commercial outlot. 5 Village of Plainfield Committee of the Whole Meeting Minutes – February 14, 2022 Page 2 John McFarland, Lennar, gave a presentation highlighting the proposed residential component, commercial component, open space, and elevations. Trustee Larson stated that she liked the concept plan and expressed concern regarding the active adult component, how the homeowner’s association will work, garages on ranch models, and school impact. Trustee Ruane stated that he likes the concept and expressed concern regarding the townhomes that back up to the commercial space, buffering, and townhomes on slabs. Trustee Kalkanis expressed concern regarding slabs, total number of homes, infrastructure, smaller lots, and felt that the age-targeted component should be age- restricted. Mayor Argoudelis stated he would like to see a connection with the shared use path and expressed concern regarding the straight line of homes. Trustee Wojowski expressed concern regarding the small lot sizes. The developer will continue working with staff. 2)2022-2023 DRAFT FISCAL YEAR BUDGET Village staff gave a presentation highlighting the draft 2022-2023 Fiscal Year Budgets for the Administration Department including Legislative, Human Resources, Facility Maintenance, Legal, Community Relations, and IT; Planning Department, and Building Department. Traci Pleckham reviewed the budget summary and budget detail for each department. Mayor Argoudelis thanked staff and read the reminders. Trustee Ruane moved to adjourn. Second by Trustee Larson. Voice Vote. All in favor, 0 opposed. Motion carried. The meeting adjourned at 9:19 p.m. Michelle Gibas, Village Clerk 6 MEMORANDUM To: Mayor Argoudelis and Trustees From: Joshua Blakemore, Village Administrator Date: February 28, 2022 Re: Plainfield Park District Funding Request Background On February 10th the Plainfield Park District to the Mayor and Village Board regarding the Patriotic Picnic and Fireworks for 2022. While the $10,000 request is within staff’s authority for approval, given the request is for a public event hosted by another taxing body, it seemed prudent for the Village Board to weigh in on the matter. Representatives from the Park District will be in attendance during the February 28th Committee of the Whole Workshop. With this being a workshop, no formal vote is on the agenda, however staff is seeking input from the Village Board on the matter. Going back to 2008, it appears as though the Village has donated anywhere from $0 - $8,500 for the event (not including PD & PW time). The event has been canceled in recent years due to COVID, however in more recent years, the Village typically contributed $4,000 to the event. The Police Department estimates roughly $7,000 in costs to the Village aside from any donation, in time spent on the event by the Police, Public Works, and PEMA. Financial Considerations If the Village Board desires for the Village to participate in this event, the funding amount can be incorporated into the Legislative - Public Relations Program as part of the FY 22/23 Budget. Recommendation In the past the norm appears to have been for the Village to contribute $4,000 to Patriotic Picnic and Fireworks. Given the request is coming from a fellow taxing body staff felt it was important for the Village Board to have input on this matter. With Monday’s meeting being a Committee of the Whole, no vote is being requested however, staff would ask for the Board’s direction on the matter. 7 February 10, 2022 Honorable President Argoudelis, Over the past several years the Plainfield Park District has hosted the Patriotic Picnic and Fireworks on July 3, servicing the Village of Plainfield as the local fireworks display. We have done such with the assistance of many entities including the Village of Plainfield in the means of both financial contributions and law enforcement support. This has been greatly appreciated by the Park District as well as many of the constituents who enjoy the event annually. The past few years have been unprecedented and have required all entities and organizations to pivot and reaction to the Covod-19 pandemic and the affects it has brought. Part of that aftermath has been the loss of the event in both 2020 and 2021. Due to budget constraints the District is seeking a partner in efforts to hold the event in 2022, as without one the event would be lost again for this year. This all being stated; the Park District is willing and hopeful to bring the event back for our residents. Understanding the great undertaking this event takes both in man power and financial resources, we are requesting the Village of Plainfield be a co-partner on the event. The Park District has allocated $10,000 toward the event for fireworks and we would be grateful if the Village is willing to do the same in allocation $10,000. This financial contribution would be in addition to the request of the typical law enforcement assistance that accompanies the event. The Park District is more than willing to still be the coordinating partner in the preparation, operation, and execution of the event. This assistance would allow for the traditional fireworks display that has been seen in previous year, but would be unaccompanied with music or the choreograph, mainly due to the increase in costs. The Park District has been in contact with our past vendor and would need to execute a contract by mid to late March to secure the date. We are requesting the Village’s intent prior to our next Park District Board of Commissioner Board Meeting on March 9, 2022. This would be the latest we could approve a contract and meet the vendors timeframe. The District and Board of Commissioners greatly appreciates your reviewing this request and are hopefully that the value and excitement that the event brings to our shared residents would secure the Village’s partnership. If you would like to further discuss this matter or hold a joint meeting, please do not hesitate to reach out to of us through Bill Thoman (Board President), any Commissioner for the Park District, or myself. Sincerely, Executive Director CC: Village of Plainfield Trustee Plainfield Park District Commissioners 8 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2023 Proposed Budget Fund: 01 - General Fund 5,929,329 6,302,842 7,023,862 7,148,780 7,159,080 10,870,272 11,556,111 13,220,143 12,255,000 16,180,750 1,124,341 1,008,302 972,349 1,007,800 1,206,000 1,318,572 1,460,594 1,724,514 1,388,200 1,318,200 611,677 678,496 524,873 694,000 659,000 4,927,437 5,173,763 5,257,178 5,453,200 5,626,700 147,994 65,421 1,932,958 35,750 45,750 658,354 601,567 572,856 595,000 565,000 270,129 380,539 52,737 41,758 40,000 409,787 142,970 174,774 135,500 124,500 452,080 468,282 103,444 405,000 450,000 25,000 25,000 25,000 225,000 20,000 $26,744,972 $27,863,887 $31,584,688 $29,384,988 $33,394,980 Administration/Finance 8,367,812 9,118,204 11,818,181 9,027,045 11,432,330 Police Department 12,686,110 12,719,854 12,948,143 14,332,593 14,542,100 Street Department 3,978,493 4,275,503 4,419,936 4,326,500 4,639,390 Planning Program 593,847 558,561 603,526 676,050 842,750 Building Program 964,165 991,573 1,002,883 1,022,800 1,073,500 $26,590,427 $27,663,695 $30,792,669 $29,384,988 $32,530,070 $154,545 $200,192 $792,019 $0 $864,910 Expenses Expense Totals Total: General Fund Franchise Fees Investment Income Miscellaneous Intergovernmental Interfund Transfers Revenue Totals State of Illinois Taxes Other Taxes Licenses & Permits Fines and Forfeits Charges for Services Grants General Fund Revenue & Expense Summary 2022-2023 Fiscal Year Budget Classification Revenues Property Taxes $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 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2023 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 DRAFT Page 1 of 4 02/24/2022 9 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Fund: 01 - General Fund Revenues Property Tax Revenue 3,607,982 4,084,845 4,512,639 4,518,780 4,593,107 4,504,080 Property Tax Rev-Road & 377,733 381,555 384,392 380,000 400,655 380,000 Property Tax-Police Pen 1,402,475 1,297,308 1,577,460 1,700,000 1,697,212 1,700,000 Property Tax Rev-IMRF 541,139 539,134 549,371 550,000 549,910 575,000 $5,929,329 $6,302,842 $7,023,862 $7,148,780 $7,240,884 $7,159,080 STTAX - State of Illinois Taxes Municipal Sales Tax 5,754,207 5,775,938 6,812,757 6,550,000 8,575,000 8,660,750 Illinois Income Tax 3,842,879 4,289,960 4,537,460 4,100,000 5,900,000 5,900,000 Replacement Tax 48,665 63,799 60,678 55,000 85,000 70,000 Local Use Tax 1,224,521 1,426,414 1,809,248 1,550,000 1,600,000 1,550,000 $10,870,272 $11,556,111 $13,220,143 $12,255,000 $16,160,000 $16,180,750 Hotel/Motel Tax 1,097 672 419 800 1,800 1,000 Amusement Tax 7,168 4,595 1,243 7,000 6,000 5,000 Local Motor Fuel Tax 1,116,076 1,003,035 970,687 1,000,000 1,200,000 1,200,000 $1,124,341 $1,008,302 $972,349 $1,007,800 $1,207,800 $1,206,000 LIC&PER - Licenses and Permits Liquor License 103,150 112,523 97,940 100,000 123,000 100,000 Contractors License 44,400 48,150 46,800 45,000 45,000 45,000 Cigarette License 8,000 6,045 5,750 6,000 6,000 6,000 Scavenger License 100 100 100 200 100 200 Business License 41,438 42,250 44,425 40,000 40,000 40,000 Building Permit 1,087,619 1,171,669 1,495,052 1,175,000 1,500,000 1,100,000 Sign Permit 3,895 4,937 3,687 5,000 5,000 5,000 Special Movement Permit 26,540 72,155 27,900 15,000 52,000 20,000 Solicitors Permit 3,430 2,765 2,860 2,000 2,200 2,000 $1,318,572 $1,460,594 $1,724,514 $1,388,200 $1,773,300 $1,318,200 Will County Court Fines 353,322 376,964 297,493 325,000 325,000 325,000 Aministrative Fines(P-Tkts)179,769 144,555 108,666 125,000 100,000 100,000 Aministrative Fines - Late fees 9,020 8,010 9,025 9,000 6,500 5,000 Asset Seizure 43,815 13,338 94,861 225,000 95,000 225,000 Alarm Fees 650 500 9,000 1,000 500 1,000 Kendall County Court Fines 2,213 3,141 5,828 3,000 4,000 3,000 FIN - Fines and Forfeits Total: Property Taxes Total: State of Illinois Taxes OTHTX - Other Taxes Total: Other Taxes Total: Licenses & Permits General Fund Revenue Detail 2022-2023 Fiscal Year Budget PROPTX - Property Taxes DRAFT Page 2 of 4 02/24/2022 10 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget General Fund Revenue Detail 2022-2023 Fiscal Year Budget Fund: 01 - General Fund Revenues (continued) Asset Seizure (DOJ)22,888 131,988 0 5,000 0 0 Asset Seizure (US Treas)0 0 0 1,000 0 0 $611,677 $678,496 $524,873 $694,000 $531,000 $659,000 Garbage Fee 4,320,878 4,504,532 4,708,687 4,850,000 4,915,000 5,000,000 Garbage Penalties 55,301 45,884 0 25,000 38,000 40,000 Engineering Services 0 0 0 5,000 0 5,000 Zoning Applications 37,634 22,544 21,899 15,000 20,000 15,000 Accident Report Fees 5,969 7,905 6,250 5,000 6,500 5,000 Copies-Maps & Ordinances 2,512 2,391 1,381 2,000 1,650 1,500 Impound Fee 32,762 26,150 41,000 25,000 23,500 25,000 Parking Lot Revenue 8,566 1,484 3,400 2,000 2,000 2,000 Tower Rent 42,910 45,110 49,215 46,000 46,000 46,000 Rental Income 49,200 49,200 49,200 49,200 49,200 49,200 Rental-Community/Multi 3,740 3,165 0 4,000 900 3,000 Special Detail/OT 117,965 115,398 26,146 75,000 105,000 85,000 Water & Sewer Service 250,000 350,000 350,000 350,000 350,000 350,000 $4,927,437 $5,173,763 $5,257,178 $5,453,200 $5,557,750 $5,626,700 FEMA Grant 0 0 36,196 0 36,196 0 Grant Revenue 98,848 8,600 1,814,016 0 0 0 Bulletproof Vest Grant 3,425 6,081 8,495 3,000 2,256 3,000 Tobacco Grant 2,750 1,375 1,320 2,750 1,320 2,750 Traffic Grant 42,971 49,365 72,931 30,000 79,158 40,000 $147,994 $65,421 $1,932,958 $35,750 $118,930 $45,750 AT&T Franchise Payment 126,384 127,184 102,746 120,000 90,000 90,000 Cable TV- Franchise 531,970 474,383 470,110 475,000 475,000 475,000 $658,354 $601,567 $572,856 $595,000 $565,000 $565,000 Interest Income 225,089 220,671 74,328 41,758 60,000 40,000 Realized Gain/Loss (829)69,706 0 0 0 0 Unrealized Gain/Loss 45,869 90,162 (21,591)0 0 0 $270,129 $380,539 $52,737 $41,758 $60,000 $40,000 FRAN - Franchise Fees Total: Franchise Fees INT - Investment Income Total: Investment Income Total: Fines and Forfeits SERV - Charges for Services Total: Charges for Services GRNTS - Grants Total: Grants DRAFT Page 3 of 4 02/24/2022 11 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget General Fund Revenue Detail 2022-2023 Fiscal Year Budget Fund: 01 - General Fund Revenues (continued) Event Sponsorship Program 5,729 3,300 0 3,000 0 3,000 Reimb Police Training 0 0 1,444 0 0 0 Amphitheater Rent 250 125 0 500 250 500 Restitution Program 0 200 4,100 0 0 0 Donation/Contribution 17,083 21,579 6,494 15,000 8,000 5,000 Sales-Fixed Assets 0 4,740 21,603 2,000 0 1,000 Liability Write Off 238,525 0 0 0 0 0 Other Reimbursements 99,015 95,255 115,681 90,000 175,000 90,000 Other Receipts 49,185 17,771 25,452 25,000 29,000 25,000 $409,787 $142,970 $174,774 $135,500 $212,250 $124,500 INTERGOV - Intergovernmental School Liaison 441,774 460,772 76,005 395,000 440,000 440,000 HIDTA/Organized Crime 10,306 7,510 27,439 10,000 15,000 10,000 $452,080 $468,282 $103,444 $405,000 $455,000 $450,000 Transfer From MFT 0 0 0 150,000 0 0 Transfer From TIF 0 0 0 50,000 0 0 Transfer From Alcohol Enforc.25,000 25,000 25,000 25,000 25,000 20,000 $25,000 $25,000 $25,000 $225,000 $25,000 $20,000 $26,744,972 $27,863,887 $31,584,688 $29,384,988 $33,906,914 $33,394,980 Total: Intergovernmental INTER - Interfund Transfers Total: Interfund Transfers Revenues Total MISC - Miscellaneous Total: Miscellaneous DRAFT Page 4 of 4 02/24/2022 12 FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget 2023 Proposed Budget 1,380,447 1,419,084 1,476,873 1,765,390 1,862,500 1,926,500 536,021 551,280 528,872 669,444 771,080 875,350 11,892 14,389 13,958 10,151 23,305 21,750 95,485 123,471 112,020 136,635 152,800 175,350 4,633,183 4,586,998 4,737,669 5,206,086 5,378,860 5,879,880 255,551 313,378 240,800 909,218 838,500 1,253,500 Sub-total $6,912,579 $7,008,600 $7,110,192 $8,696,924 $9,027,045 $10,132,330 532,831 1,359,212 2,008,012 3,121,257 0 1,300,000 $7,445,410 $8,367,812 $9,118,204 $11,818,181 $9,027,045 $11,432,330 Unit: 04 - Administration/Finance Total Administration/Finance Salaries and Wages Benefits Utilities Supplies and Commodities Contractual Services Other Transfers Classification Fund: 01 - General Fund Expenditures General Fund Administration/Finance Summary 2022-2023 Fiscal Year Budget $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget 2023 Proposed Budget Admin/Finance Expense History Other Contractual Services Supplies and Commodities Utilities Benefits Salaries and Wages DRAFT Page 1 of 8 02/24/2022 13 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Unit: 04 - Administration/Finance Contrac - Contractual Services Fees to Refuse Hauler 3,982,891 4,161,324 4,364,628 4,480,000 4,569,765 4,798,250 Bad Debt Expense 0 0 11,305 0 0 0 $3,982,891 $4,161,324 $4,375,933 $4,480,000 $4,569,765 $4,798,250 Salaries-President 24,000 24,000 24,000 24,000 24,000 24,000 Salaries-Elected Officials 23,800 25,300 23,000 25,000 26,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 $51,800 $53,300 $51,000 $53,000 $54,000 $54,000 FICA 3,037 3,286 3,162 3,300 3,350 3,400 Medicare 710 769 740 780 785 800 Employee Insurance 139 109 101 150 10 100 Travel/Training 4,393 1,919 0 10,000 500 10,000 $8,279 $6,083 $4,003 $14,230 $4,645 $14,300 SUPP - Supplies and Commodities Replacement Supplies 0 742 5,248 3,000 4,000 10,000 Dues & Subscriptions 56,001 50,868 53,068 50,000 55,000 55,000 $56,001 $51,610 $58,316 $53,000 $59,000 $65,000 Contrac - Contractual Services Public Relations 100,472 122,741 107,052 115,000 115,000 120,000 Cable TV 0 0 15,761 10,000 10,000 10,000 $100,472 $122,741 $122,813 $125,000 $125,000 $130,000 Small Business Relief Grant 0 0 145,000 0 0 0 Economic Incentive Rebate 189,796 134,559 587,273 650,000 930,000 700,000 $189,796 $134,559 $732,273 $650,000 $930,000 $700,000 $406,348 $368,293 $968,405 $895,230 $1,172,645 $963,300 Total: Supplies & Commodities Total: Contractual Services OTHER - Other Total: Other Total: 01 - Legislative Program Total: Salaries and Wages BEN - Benefits Total: Non-Divisional SAL - Salaries and Wages Total: Benefits Administration/Finance Detail 2022-2023 Fiscal Year Budget General Fund Division: 00 - Non-Divisional Division: 01 - Legislative Program Expenditures DRAFT Page 2 of 8 02/24/2022 14 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Administration/Finance Detail 2022-2023 Fiscal Year Budget General Fund Salaries-Full Time 744,712 768,361 671,481 675,000 670,000 740,000 Salaries-Part Time 53,127 55,836 63,773 75,000 70,000 55,000 Salaries-Overtime 878 359 276 2,000 1,500 2,000 $798,717 $824,556 $735,530 $752,000 $741,500 $797,000 FICA 45,116 45,731 40,466 45,000 44,500 50,000 Medicare 11,560 11,786 11,245 10,500 10,500 11,750 IMRF 84,813 80,550 84,122 80,000 80,000 88,000 Employee Insurance 103,736 105,980 89,852 90,000 110,000 135,000 Deferred Comp. Contribution 23,458 18,208 20,554 25,000 22,000 25,000 Travel/Training 12,055 4,901 1,501 12,000 5,000 12,000 IL Unemployment Insurance 4,043 3,594 5,311 5,000 5,500 6,000 $284,781 $270,750 $253,051 $267,500 $277,500 $327,750 UTIL - Utilities Telephone/Internet 6,346 5,814 2,468 12,085 8,000 8,000 Cellular Phones 2,146 2,531 1,657 2,500 4,200 5,000 $8,492 $8,345 $4,125 $14,585 $12,200 $13,000 SUPP - Supplies and Commodities Office Supplies/Postage 32,003 33,066 32,225 32,000 32,000 35,000 Dues & Subscriptions 3,716 3,759 2,476 5,000 4,000 5,000 Gas/Oil/Mileage/Carwash 8,919 8,378 7,200 9,500 4,000 9,500 $44,638 $45,203 $41,901 $46,500 $40,000 $49,500 Contrac - Contractual Services Maintenance Contracts/Lease 8,719 4,046 1,894 8,000 2,500 8,000 Recording Fees 1,579 166 506 1,000 800 1,000 Legal Notices 2,328 2,079 2,103 2,500 2,200 2,500 Legal Fees 48,478 60,032 43,085 80,000 82,000 95,000 Contractual Services 95,535 54,690 63,584 65,000 85,000 90,000 $156,639 $121,013 $111,172 $156,500 $172,500 $196,500 OTHER - Other Office Furniture & Equipment 1,748 9,982 3,920 5,000 1,500 5,000 Contingencies 37,696 7,054 25,884 40,000 20,000 400,000 $39,444 $17,036 $29,804 $45,000 $21,500 $405,000 Total: 02 - Administration $1,332,711 $1,286,903 $1,175,583 $1,282,085 $1,265,200 $1,788,750 Total: Supplies & Commodities Total: Contractual Services Total: Salaries and Wages Total: Benefits BEN - Benefits Total: OTHER - Other SAL - Salaries and Wages Total: UTIL - Utilities Division: 02 - Administration Program DRAFT Page 3 of 8 02/24/2022 15 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Administration/Finance Detail 2022-2023 Fiscal Year Budget General Fund Salaries-Full Time 102,251 104,807 110,916 111,000 108,000 113,000 $102,251 $104,807 $110,916 $111,000 $108,000 $113,000 FICA 5,901 5,881 6,745 6,800 6,700 7,100 Medicare 1,380 1,375 1,577 1,600 1,500 1,700 IMRF 11,010 10,345 12,682 12,100 11,800 12,500 Employee Insurance 21,094 21,592 23,066 25,000 26,000 29,500 Deferred Comp. Contribution 3,656 1,700 3,755 4,000 4,200 5,000 Travel/Training 251 25 81 1,500 500 1,500 $43,292 $40,918 $47,906 $51,000 $50,700 $57,300 UTIL - Utilities Telephone/Internet 635 677 310 750 400 750 $635 $677 $310 $750 $400 $750 SUPP - Supplies and Commodities Office Supplies/Postage 0 0 0 300 150 300 Dues & Subscriptions 530 570 634 850 650 850 Gas/Oil/Mileage/Carwash 0 0 0 100 0 100 $530 $570 $634 $1,250 $800 $1,250 Contrac - Contractual Services Public Relations 10,799 11,124 11,148 28,000 20,000 31,000 Marketing and Promotions 173 0 0 1,000 200 2,000 Settler's Park 6,191 4,287 0 4,000 3,000 8,000 Contractual Services 3,850 384 13,561 4,000 5,000 7,500 $21,013 $15,795 $24,709 $37,000 $28,200 $48,500 Total: 03-Community Relations $167,721 $162,767 $184,475 $201,000 $188,100 $220,800 Total: UTIL - Utilities Total: Salaries and Wages Division: 03 - Community Relations Program BEN - Benefits Total: Supplies & Commodities Total: Contractual Services SAL - Salaries and Wages Total: Benefits DRAFT Page 4 of 8 02/24/2022 16 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Administration/Finance Detail 2022-2023 Fiscal Year Budget General Fund Salaries-Full Time 50,139 52,087 53,084 55,000 55,000 60,000 Salaries-Overtime 4,226 4,176 3,344 4,500 4,500 5,000 $54,365 $56,263 $56,428 $59,500 $59,500 $65,000 FICA 3,227 3,323 3,511 3,700 3,700 4,100 Medicare 755 777 821 900 900 1,000 IMRF 5,766 5,493 6,405 6,500 6,500 7,200 Employee Insurance 15,300 15,525 14,732 18,000 15,500 18,000 Deferred Comp. Contribution 777 786 1,220 1,000 1,500 2,000 $25,825 $25,904 $26,689 $30,100 $28,100 $32,300 SUPP - Supplies and Commodities Building Supplies 10,387 10,722 12,676 15,000 15,000 20,000 $10,387 $10,722 $12,676 $15,000 $15,000 $20,000 Contrac - Contractual Services Contractual Services 43,067 45,241 42,946 45,000 60,000 70,000 $43,067 $45,241 $42,946 $45,000 $60,000 $70,000 OTHER - Other Building Improvements 5,987 4,775 32,885 25,000 10,000 30,000 $5,987 $4,775 $32,885 $25,000 $10,000 $30,000 Total: 04-Facility Management $139,631 $142,905 $171,624 $174,600 $172,600 $217,300 Total: Salaries and Wages Division: 04 - Facility Management Program Total: Supplies & Commodities Total: Contractual Services Total: OTHER - Other Total: Benefits SAL - Salaries and Wages BEN - Benefits DRAFT Page 5 of 8 02/24/2022 17 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Administration/Finance Detail 2022-2023 Fiscal Year Budget General Fund Salaries-Full Time 166,248 174,765 185,129 190,000 190,000 195,000 Salaries-Overtime 50 0 0 500 500 500 $166,298 $174,765 $185,129 $190,500 $190,500 $195,500 FICA 9,972 10,228 11,788 12,000 12,000 12,000 Medicare 2,332 2,392 2,843 2,800 2,800 2,800 IMRF 17,738 17,263 22,034 21,000 20,000 21,000 Employee Insurance 38,063 39,343 42,044 45,000 47,000 50,000 Deferred Comp. Contribution 6,580 6,719 6,953 8,000 7,500 8,000 Travel/Training 8,688 964 614 6,500 5,000 10,000 $83,373 $76,909 $86,276 $95,300 $94,300 $103,800 UTIL - Utilities Telephone/Internet 1,269 1,067 450 1,000 550 1,000 Cellular Phones 667 672 543 600 600 600 $1,936 $1,739 $993 $1,600 $1,150 $1,600 SUPP - Supplies and Commodities Office Supplies/Postage 518 890 1,251 1,500 1,300 2,000 Dues & Subscriptions 7,804 946 707 9,000 9,800 10,000 Gas/Oil/Mileage/Carwash 341 24 0 1,200 100 1,200 $8,663 $1,860 $1,958 $11,700 $11,200 $13,200 Contrac - Contractual Services Public Relations 4,149 10,143 7,363 12,000 9,000 12,000 Contractual Services 5,473 4,393 1,348 8,000 5,000 10,000 $9,622 $14,536 $8,711 $20,000 $14,000 $22,000 Total: 06 - Human Resources $269,892 $269,809 $283,067 $319,100 $311,150 $336,100 Total: Supplies & Commodities Total: Contractual Services Total: Benefits Total: UTIL - Utilities BEN - Benefits SAL - Salaries and Wages Total: Salaries and Wages Division: 06 - Human Resources Program DRAFT Page 6 of 8 02/24/2022 18 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Administration/Finance Detail 2022-2023 Fiscal Year Budget General Fund Salaries-Full Time 245,653 263,182 307,528 368,000 325,000 370,000 Salaries-Overtime 0 0 0 500 0 0 $245,653 $263,182 $307,528 $368,500 $325,000 $370,000 FICA 15,004 16,118 19,250 23,000 20,200 23,000 Medicare 3,509 3,769 4,502 5,400 47,100 5,500 IMRF 26,162 26,278 34,519 40,500 35,000 41,000 Employee Insurance 42,083 44,200 55,192 81,000 88,000 103,000 Deferred Comp. Contribution 6,926 8,767 7,419 6,000 6,500 7,500 Travel/Conventions/Training 12,046 9,176 0 17,000 3,000 15,000 $105,730 $108,308 $120,882 $172,900 $199,800 $195,000 UTIL - Utilities Telephone/Internet 669 534 228 500 300 500 Cellular Phones 2,657 2,663 2,796 4,170 3,000 4,200 $3,326 $3,197 $3,024 $4,670 $3,300 $4,700 SUPP - Supplies and Commodities Office Supplies/Postage 1,869 941 2,586 1,750 1,300 1,800 Dues & Subscriptions 675 754 689 800 700 800 Gas/Oil/Mileage/Carwash 340 360 0 400 100 400 Uniforms 368 0 267 800 300 800 $3,252 $2,055 $3,542 $3,750 $2,400 $3,800 Contrac - Contractual Services Software Licensing/Renewals 256,683 241,440 444,441 436,700 425,000 523,130 Contractual Services 16,611 15,579 52,263 55,500 50,000 70,500 $273,294 $257,019 $496,704 $492,200 $475,000 $593,630 OTHER - Other Server/Network Supplies 55,355 58,663 74,698 78,500 60,000 78,500 Computers 22,796 25,767 39,558 40,000 35,000 40,000 $78,151 $84,430 $114,256 $118,500 $95,000 $118,500 Total: 08 - IT Program $709,406 $718,191 $1,045,936 $1,160,520 $1,100,500 $1,285,630 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 Page 7 of 8 02/24/2022 19 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Administration/Finance Detail 2022-2023 Fiscal Year Budget General Fund SAL - Salaries and Wages Salaries-Full Time 0 0 291,981 292,000 290,000 298,000 Salaries - Part Time 0 0 26,878 35,000 28,000 33,000 Salaries-Overtime 0 0 0 1,000 500 1,000 $0 $0 $318,859 $328,000 $318,500 $332,000 BEN - Benefits FICA 0 0 20,013 20,300 19,500 21,000 Medicare 0 0 4,605 4,750 4,600 4,900 IMRF 0 0 35,706 36,000 36,000 37,000 Employee Insurance 0 0 60,370 68,000 65,500 68,000 Deferred Comp. Contrib.0 0 9,389 8,000 10,000 11,000 Travel/Training 0 0 554 3,000 1,000 3,000 $0 $0 $130,637 $140,050 $136,600 $144,900 UTIL - Utilities Telephone/Internet 0 0 491 1,000 600 1,000 Cellular Phones 0 0 1,208 700 550 700 $0 $0 $1,699 $1,700 $1,150 $1,700 SUPP - Supplies and Commodities Office Supplies/Postage 0 0 5,632 10,000 7,000 10,000 Dues & Subscriptions 0 0 10,506 10,500 10,500 11,000 Gas/Oil/Mileage/Carwash 0 0 836 500 750 1,000 Uniforms/Clothing 0 0 634 600 500 600 $0 $0 $17,608 $21,600 $18,750 $22,600 Contrac - Contractual Services Maintenance Contracts/Lease 0 0 2,016 2,160 2,500 3,000 Vehicle Maintenance 0 0 784 1,000 4,000 3,000 Legal Fees 0 0 20,298 20,000 15,000 15,000 $0 $0 $23,098 $23,160 $21,500 $21,000 Total: Legal Services $0 $0 $491,901 $514,510 $496,500 $522,200 Transfer to Tort Immunity 0 0 0 0 0 300,000 Tr. to Capital (body cam/PEMA)1,359,212 2,008,012 3,121,257 0 0 1,000,000 $1,359,212 $2,008,012 $3,121,257 $0 $0 $1,300,000 Total: Administration/Finance $8,367,812 $9,118,204 $11,818,181 $9,027,045 $9,276,460 $11,432,330 Total: Transfers Transfers Total: Contractual Services Division: 09 - Legal Services Total: Salaries and Wages Total: Benefits Total: Utilities Total: Supplies & Commodities DRAFT Page 8 of 8 02/24/2022 20 FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2023 Proposed Budget Salaries and Wages 7,076,406 7,431,449 7,735,573 7,688,410 8,420,518 8,552,418 Benefits 3,342,703 3,485,115 3,425,247 3,693,848 4,060,416 4,079,002 Utilities 59,597 68,639 73,299 65,280 74,215 86,678 Supplies and Commodities 319,678 316,388 349,290 296,940 363,520 385,330 Contractual Services 981,636 1,083,725 1,048,631 1,079,414 1,273,924 1,297,672 Other 133,141 300,794 87,814 124,251 140,000 141,000 Total - Police Department $11,913,161 $12,686,110 $12,719,854 $12,948,143 $14,332,593 $14,542,100 Classification Fund: 01 - General Fund Expenditures Total Police Department General Fund Police Division Summary 2022-2023 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 FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2023 Proposed Budget Police Division Expense History Other Contractual Services Supplies and Commodities Utilities Benefits Salaries and Wages DRAFT Page 1 of 10 01/06/2022 21 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Fund: 01 - General Fund Expenditures Unit: 05 - Police Department SAL - Salaries and Wages Salaries-Full Time 309,660 311,250 338,919 345,063 335,000 347,887 Salaries-Part Time 34,245 32,369 32,174 34,944 16,000 35,000 Salaries-Overtime 361 1,096 255 1,000 800 1,000 $344,266 $344,715 $371,348 $381,007 $351,800 $383,887 BEN - Benefits FICA 20,055 19,966 22,607 23,622 22,000 23,801 Medicare 4,773 4,761 5,450 5,525 5,100 5,566 IMRF 21,272 19,397 23,140 25,576 21,500 20,086 Employee Insurance 63,618 63,830 67,335 72,800 72,500 66,521 Deferred Comp. Contrib.6,068 6,135 6,381 8,000 8,000 8,000 Travel/Training 4,058 4,891 3,630 7,000 3,500 8,000 Education/School 0 3,511 3,000 3,000 3,000 3,000 Unemployment Insurance 18,634 18,788 20,000 20,000 20,000 20,000 $138,478 $141,279 $151,543 $165,523 $155,600 $154,974 UTIL - Utilities Telephone/Internet 1,741 627 450 1,100 600 1,100 Cellular Phones 748 734 527 1,200 700 1,200 $2,489 $1,361 $977 $2,300 $1,300 $2,300 SUPP - Supplies and Commodities Office Supplies/Postage 4,680 6,461 6,291 8,000 6,500 8,000 Replacement Supplies 907 1,837 1,898 4,550 3,000 4,550 Dues & Subscriptions 2,967 3,264 4,905 5,000 5,000 5,960 Gas/Oil/Mileage/Carwash 1,178 5,278 1,245 3,700 2,000 3,700 Uniforms/Clothing 1,871 2,515 2,251 1,800 1,800 1,800 $11,603 $19,355 $16,590 $23,050 $18,300 $24,010 Contrac - Contractual Services Maintenance Contracts/Lease 7,385 6,547 5,651 6,709 6,000 6,709 Custodial Supplies 58,936 64,491 71,172 65,000 65,000 75,000 Vehicle Maintenance 2,115 651 1,688 2,500 1,500 2,500 Contractual Services 3,002 4,760 21,229 8,000 7,500 8,000 $71,438 $76,449 $99,740 $82,209 $80,000 $92,209 Total: Administration Program $568,274 $583,159 $640,198 $654,089 $607,000 $657,380 Total: Contractual Services Total: Supplies & Commodities Division: 02 - Police Executive General Fund Police Division Detail 2022-2023 Fiscal Year Budget Total: Salaries and Wages Total: Benefits Total: Utilities DRAFT Page 2 of 10 01/06/2022 22 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget General Fund Police Division Detail 2022-2023 Fiscal Year Budget SAL - Salaries and Wages Salaries-Full Time 3,972,682 4,258,971 3,985,541 4,262,309 4,000,000 4,319,335 Salaries-Part Time 245,263 261,624 (1,025)0 0 0 Salaries-Overtime 306,702 291,642 224,247 250,000 240,000 250,000 $4,524,647 $4,812,237 $4,208,763 $4,512,309 $4,240,000 $4,569,335 BEN - Benefits FICA 271,691 288,235 265,944 279,763 266,000 283,299 Medicare 64,010 67,924 62,253 65,428 62,500 66,255 IMRF 41,580 40,872 15,670 14,550 16,000 15,408 Employer Pension Contrib.1,402,475 1,297,308 1,577,460 1,700,000 1,700,000 1,700,000 Employee Insurance 615,423 659,918 630,361 665,615 695,000 705,889 Deferred Comp. Contrib.122,332 115,355 114,454 125,000 120,000 125,000 Travel/Training 32,232 38,592 24,968 41,000 33,000 41,000 $2,549,743 $2,508,204 $2,691,110 $2,891,356 $2,892,500 $2,936,851 UTIL - Utilities Telephone/Internet 29,305 40,595 33,635 12,160 33,000 35,000 Cellular Phones 5,365 5,853 6,256 23,300 6,000 7,000 $34,670 $46,448 $39,891 $35,460 $39,000 $42,000 SUPP - Supplies and Commodities Office Supplies/Postage 14,553 14,333 7,084 13,500 10,000 13,500 Replacement Supplies 18,178 16,250 16,708 17,000 17,000 20,000 Dues & Subscriptions 1,124 885 710 3,900 3,000 8,100 Gas/Oil/Mileage/Carwash 91,570 96,473 61,882 61,000 63,000 68,000 K-9 Unit 4,655 5,262 5,416 0 0 0 Uniforms/Clothing 37,983 52,837 48,402 43,150 43,150 42,950 Ammunition/Weapons 32,522 24,227 28,249 28,000 28,000 28,500 Bike Unit 825 5,806 3,385 3,500 3,000 6,000 $201,410 $216,073 $171,836 $170,050 $167,150 $187,050 Contrac - Contractual Services Traffic Programs 20,302 13,161 0 0 0 0 Explorer Program 0 0 2,682 5,000 2,000 5,000 Radio Maintenance 955 0 48 2,000 1,000 2,000 Maintenance Contracts/Lease 15,656 14,521 4,366 15,995 12,000 11,920 Vehicle Maintenance 78,393 73,943 75,795 46,970 45,000 53,000 Contractual Services 13,887 12,479 13,103 16,000 15,000 16,700 Contractual Svcs - WESCOM 602,845 601,421 607,001 608,000 606,000 619,813 Animal Control 4,440 7,060 2,780 0 0 0 $736,478 $722,585 $705,775 $693,965 $681,000 $708,433 Total: Police Operations $8,046,948 $8,305,547 $7,817,375 $8,303,140 $8,019,650 $8,443,669 Total: Salaries and Wages Division: 51 - Police Patrol Total: Benefits Total: Utilities Total: Supplies & Commodities Total: Contractual Services DRAFT Page 3 of 10 01/06/2022 23 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget General Fund Police Division Detail 2022-2023 Fiscal Year Budget SAL - Salaries and Wages Salaries-Full Time 1,042,704 1,018,858 1,763,317 2,009,633 1,775,000 2,071,741 Salaries-Overtime 79,262 58,668 107,876 134,500 135,000 138,000 $1,121,966 $1,077,526 $1,871,193 $2,144,133 $1,910,000 $2,209,741 BEN - Benefits FICA 68,145 64,642 116,994 132,936 120,000 137,004 Medicare 15,999 15,118 27,450 31,090 28,000 32,041 IMRF 6,773 6,766 13,654 15,212 14,500 16,020 Employee Insurance 177,746 176,357 290,239 358,181 355,000 372,639 Deferred Comp. Contrib.39,548 46,030 53,793 55,000 55,000 58,000 Travel/Training 10,445 9,975 11,448 32,460 12,000 20,000 $318,656 $318,888 $513,578 $624,879 $584,500 $635,704 UTIL - Utilities Telephone/Internet 2,238 731 579 1,110 700 1,100 Cellular Phones 11,609 11,676 12,203 19,800 10,000 15,000 $13,847 $12,407 $12,782 $20,910 $10,700 $16,100 SUPP - Supplies and Commodities Office Supplies/Postage 2,488 3,100 3,877 5,500 4,000 5,500 Replacement Supplies 893 1,125 4,215 14,400 8,000 15,000 Dues & Subscriptions 5,050 3,923 3,999 5,220 4,000 7,000 Gas/Oil/Mileage/Carwash 16,974 16,888 16,903 30,000 26,000 30,000 Crime Scene/Evidence Tech 7,851 6,483 6,315 12,400 7,000 10,000 Uniforms/Clothing 7,199 9,148 14,057 13,000 13,000 13,900 $40,455 $40,667 $49,366 $80,520 $62,000 $81,400 Contrac - Contractual Services Community Programs 0 0 6,127 8,500 8,500 8,500 Community Prog-Alc/Tobacco 0 0 104 2,500 1,000 2,500 Explorer Program 6,471 11,962 (240)0 0 0 Radio Maintenance 0 1,326 25,564 31,000 25,000 31,000 Maintenance Contracts/Lease 3,735 3,151 2,498 4,920 3,000 4,920 Vehicle Maintenance 14,102 13,609 27,120 31,820 26,000 30,000 D.A.R.E. Program 0 0 3,076 5,000 3,500 5,000 Background Check Svcs.2,330 2,521 2,407 2,500 2,500 2,500 Accreditation 4,595 4,595 0 0 0 0 $31,233 $37,164 $66,656 $86,240 $69,500 $84,420 OTHER - Other Shop with a Cop 0 0 14,900 10,000 15,800 10,000 $0 $0 $14,900 $10,000 $15,800 $10,000 Total: Police Administration $1,526,157 $1,486,652 $2,528,475 $2,966,682 $2,652,500 $3,037,365 Division: 52 - Police Administration Total: Salaries and Wages Total: Benefits Total: Utilities Total: Supplies & Commodities Total: Contractual Services Total: OTHER - Other DRAFT Page 4 of 10 01/06/2022 24 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget General Fund Police Division Detail 2022-2023 Fiscal Year Budget SAL - Salaries and Wages Salaries-Full Time 216,142 226,435 0 0 0 0 Salaries-Part Time 27,636 32,979 0 0 0 0 Salaries-Overtime 6,235 4,310 0 0 0 0 $250,013 $263,724 $0 $0 $0 $0 BEN - Benefits FICA 15,877 16,489 0 0 0 0 Medicare 3,713 3,856 0 0 0 0 IMRF 26,816 26,696 0 0 0 0 Employee Insurance 56,492 31,405 0 0 0 0 Deferred Comp. Contrib.8,966 10,182 0 0 0 0 Travel/Training 2,136 877 0 0 0 0 $114,000 $89,505 $0 $0 $0 $0 UTIL - Utilities Telephone/Internet 2,238 731 0 0 0 0 $2,238 $731 $0 $0 $0 $0 SUPP - Supplies and Commodities Office Supplies/Postage 8,624 8,946 0 0 0 0 Dues & Subscriptions 15 50 0 0 0 0 Uniforms/Clothing 1,019 961 0 0 0 0 $9,658 $9,957 $0 $0 $0 $0 Contrac - Contractual Services Maintenance Contracts/Lease 2,160 5,193 0 0 0 0 $2,160 $5,193 $0 $0 $0 $0 Total: Police Records $378,069 $369,110 $0 $0 $0 $0 Division: 53 - Police Records Total: Salaries and Wages Total: Contractual Services Total: Benefits Total: Utilities Total: Supplies & Commodities DRAFT Page 5 of 10 01/06/2022 25 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget General Fund Police Division Detail 2022-2023 Fiscal Year Budget Contrac - Contractual Services Seizure/Forfeiture Exp.123,515 77,906 100,230 225,000 95,000 225,000 $123,515 $77,906 $100,230 $225,000 $95,000 $225,000 Total: Seizure/Forfeiture $123,515 $77,906 $100,230 $225,000 $95,000 $225,000 SAL - Salaries and Wages Salaries-Special Activities 77,522 72,901 22,764 32,513 65,000 32,513 $77,522 $72,901 $22,764 $32,513 $65,000 $32,513 BEN - Benefits FICA 4,927 4,470 1,344 2,016 4,000 2,016 Medicare 1,169 1,067 315 471 700 471 $6,096 $5,537 $1,659 $2,487 $4,700 $2,487 SUPP - Supplies and Commodities Mobile Field Force 0 960 0 0 0 0 $0 $960 $0 $0 $0 $0 Total: Police Special Activities $83,618 $79,398 $24,423 $35,000 $69,700 $35,000 Total: Contractual Services Division: 54 - Seizure/Forfeiture Total: Supplies & Commodities Total: Salaries and Wages Total: Benefits Division: 55 - Police Special Activities DRAFT Page 6 of 10 01/06/2022 26 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget General Fund Police Division Detail 2022-2023 Fiscal Year Budget SAL - Salaries and Wages Salaries-Full Time 909,075 947,620 914,637 984,456 885,000 994,442 Salaries-Part Time 203 1,598 258,505 303,600 250,000 300,000 Salaries-Overtime 46,408 47,938 40,089 56,000 45,000 56,000 $955,686 $997,156 $1,213,231 $1,344,056 $1,180,000 $1,350,442 BEN - Benefits FICA 57,350 59,433 77,332 83,331 75,000 83,727 Medicare 13,508 14,010 18,096 19,489 17,500 19,581 IMRF 5,514 4,956 58,343 70,031 55,000 70,439 Employee Insurance 164,841 163,410 149,288 147,139 147,139 129,058 Deferred Comp. Contrib.27,000 28,752 25,302 40,000 28,000 30,000 Travel/Training 12,670 13,262 5,931 10,760 5,000 10,760 $280,883 $283,823 $334,292 $370,750 $327,639 $343,565 UTIL - Utilities Telephone/Internet 2,238 919 1,164 2,200 1,500 2,200 Cellular Phones/Pagers 2,709 2,787 2,923 5,220 3,500 7,220 $4,947 $3,706 $4,087 $7,420 $5,000 $9,420 SUPP - Supplies and Commodities Office Supplies/Postage 2,661 3,032 9,889 13,750 10,000 13,750 Replacement Supplies 931 3,366 2,707 8,200 5,000 11,500 Dues & Subscriptions 1,319 654 1,632 1,650 1,650 650 Gas/Oil/Mileage/Carwash 9,783 10,288 17,496 22,000 19,000 22,000 Uniforms/Clothing 4,443 6,592 12,074 11,200 12,000 11,870 $19,137 $23,932 $43,798 $56,800 $47,650 $59,770 Contrac - Contractual Services Traffic Program 0 0 20,259 25,900 22,000 27,000 Community Programs 4,895 4,662 0 0 0 0 Community Prog-Alc/Tobacco 152 24 0 0 0 0 Radio Maintenance 25,962 16,620 0 500 500 500 Maintenance Contracts 0 1,733 3,750 7,660 5,000 7,660 Vehicle Maintenance 16,321 10,431 19,310 21,500 20,000 21,500 DARE Program 4,159 4,999 0 0 0 0 Chaplaincy Program 1,097 2,880 1,220 3,000 2,000 3,000 Accreditation 0 0 4,595 8,000 5,000 8,000 Animal Control 0 0 0 9,000 5,000 9,000 $52,586 $41,349 $49,134 $75,560 $59,500 $76,660 OTHER - Other Shop With a Cop 13,600 14,755 0 0 0 0 $13,600 $14,755 $0 $0 $0 $0 Total: Community Services $1,326,839 $1,364,721 $1,644,542 $1,854,586 $1,619,789 $1,839,857 Total: Salaries and Wages Total: Benefits Total: Utilities Total: Supplies & Commodities Division: 56 - Police Support Services Total: Contractual Services Total: OTHER - Other DRAFT Page 7 of 10 01/06/2022 27 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget General Fund Police Division Detail 2022-2023 Fiscal Year Budget SAL - Salaries and Wages Salaries-Full Time 129,880 138,968 0 0 0 0 Salaries - Part Time 25,268 26,666 0 0 0 0 Salaries-Overtime 100 43 0 0 0 0 $155,248 $165,677 $0 $0 $0 $0 BEN - Benefits FICA 9,282 9,809 0 0 0 0 Medicare 2,171 2,294 0 0 0 0 IMRF 16,579 16,401 0 0 0 0 Employee Insurance 40,435 40,813 0 0 0 0 Deferred Comp. Contrib.4,879 7,399 0 0 0 0 Travel/Training 2,252 612 0 0 0 0 $75,598 $77,328 $0 $0 $0 $0 UTIL - Utilities Telephone/Internet 1,741 702 0 0 0 0 $1,741 $702 $0 $0 $0 $0 SUPP - Supplies and Commodities Office Supplies/Postage 8,300 5,741 0 0 0 0 Dues & Subscriptions 9,808 10,353 0 0 0 0 Uniforms/Clothing 809 155 0 0 0 0 $18,917 $16,249 $0 $0 $0 $0 Contrac - Contractual Services Maintenance Contracts/Lease 1,920 2,371 0 0 0 0 Legal Fees 13,816 13,300 0 0 0 0 $15,736 $15,671 $0 $0 $0 $0 Total: Court Services $267,240 $275,627 $0 $0 $0 $0 OTHER - Other Office Furniture & Equip.4,590 3,122 9,739 8,000 8,000 8,000 Machinery and Equipment 262,011 45,940 85,762 100,000 75,000 100,000 $266,601 $49,062 $95,501 $108,000 $83,000 $108,000 Total: Capital $266,601 $49,062 $95,501 $108,000 $83,000 $108,000 OTHER - Other Contingencies 18,119 20,411 13,362 12,000 12,000 13,000 $18,119 $20,411 $13,362 $12,000 $12,000 $13,000 Total: Contingencies $18,119 $20,411 $13,362 $12,000 $12,000 $13,000 Total: Police Department $12,605,380 $12,611,593 $12,864,106 $14,158,497 $13,158,639 $14,359,271 Total: Contractual Services Total: Benefits Total: Utilities Total: Supplies & Commodities Total: OTHER - Other Total: OTHER - Other Division: 57 - Court Services Division: 91 - Capital Division: 93 - Contingencies Total: Salaries and Wages DRAFT Page 8 of 10 01/06/2022 28 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget General Fund Police Division Detail 2022-2023 Fiscal Year Budget BEN - Benefits Travel/Training 1,377 415 1,482 4,000 1,500 4,000 $1,377 $415 $1,482 $4,000 $1,500 $4,000 UTIL - Utilities Telephone/Internet 6,590 7,265 6,940 7,250 7,250 16,000 Cellular Phones/Pagers 2,117 679 603 875 700 858 $8,707 $7,944 $7,543 $8,125 $7,950 $16,858 SUPP - Supplies and Commodities Office Supplies/Postage 739 523 398 1,000 1,500 1,000 Replacement Supplies 2,215 5,294 4,624 6,000 5,000 6,000 Dues & Subscriptions 3,153 3,675 3,419 4,000 3,500 4,000 Gas/Oil/Mileage/Carwash 4,461 4,609 2,166 8,000 3,500 8,000 Supplies/Hardware 1,245 448 61 2,000 500 2,000 Supplies/Hardware-ESDA 514 944 0 2,000 1,000 2,000 Uniforms/Clothing 2,094 5,971 2,041 6,000 5,000 6,000 Bike Unit 0 0 168 1,500 500 1,500 $14,421 $21,464 $12,877 $30,500 $20,500 $30,500 Contrac - Contractual Services Emergency Operation Center 933 819 0 1,000 500 1,000 Police Public Relations 524 1,654 1,050 3,000 1,000 3,000 Disaster Plan/Exercises/NIMS 216 0 0 3,000 1,000 3,000 Radio Maintenance 10,939 15,524 13,915 16,000 15,000 16,000 Maintenance Contracts/Lease 1,269 2,281 1,798 1,200 1,200 1,200 Building Maintenance 1,059 868 1,299 20,000 5,000 20,000 Vehicle Maintenance 17,620 7,218 19,265 20,000 15,000 20,000 Siren Maintenance 10,246 8,802 10,228 13,000 10,000 13,000 Contractual Services 194 0 0 5,250 1,000 5,250 CERT/Cadet Program 2,001 1,751 1,759 4,500 2,000 4,500 PEMA Search and Rescue 1,500 3,474 3,900 3,000 3,000 3,000 $46,501 $42,391 $53,214 $89,950 $54,700 $89,950 OTHER - Other Office Furniture & Equipment 228 855 0 2,000 1,000 2,000 Machinery and Equipment 1,710 556 0 5,000 3,000 5,000 Contingencies 536 2,175 488 3,000 1,000 3,000 $2,474 $3,586 $488 $10,000 $5,000 $10,000 Total: PEMA $73,480 $75,800 $75,604 $142,575 $89,650 $151,308 Total: Utilities Total: Supplies & Commodities Total: OTHER - Other Total: Contractual Services Total: Benefits Unit: 07 - PEMA DRAFT Page 9 of 10 01/06/2022 29 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget General Fund Police Division Detail 2022-2023 Fiscal Year Budget Division: 02 - Administration Program SAL - Salaries and Wages Salaries-Part Time 2,101 1,637 1,111 6,500 4,000 6,500 $2,101 $1,637 $1,111 $6,500 $4,000 $6,500 BEN - Benefits FICA 118 119 57 341 250 341 Medicare 28 28 13 80 60 80 Travel/Training 138 121 114 1,000 1,800 1,000 $284 $268 $184 $1,421 $2,110 $1,421 SUPP - Supplies and Commodities Office Supplies/Postage 412 258 1,774 2,000 1,000 2,000 Dues & Subscriptions 375 375 699 600 600 600 $787 $633 $2,473 $2,600 $1,600 $2,600 Contrac - Contractual Services Legal Fees 0 0 0 1,000 500 1,000 Police Testing/Hiring 4,078 29,923 4,665 20,000 15,000 20,000 $4,078 $29,923 $4,665 $21,000 $15,500 $21,000 Total: Police Commission $7,250 $32,461 $8,433 $31,521 $23,210 $31,521 Police Division Total $12,686,110 $12,719,854 $12,948,143 $14,332,593 $13,271,499 $14,542,100 Total: Contractual Services Total: Salaries and Wages Total: Benefits Total: Supplies & Commodities Unit: 50 - Police Commission DRAFT Page 10 of 10 01/06/2022 30 FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2023 Proposed Budget Salaries and Wages 1,566,120 1,644,082 1,671,891 1,645,291 1,651,000 1,842,000 Benefits 626,529 659,144 641,808 683,376 732,700 792,890 Utilities 290,125 249,654 249,238 236,511 243,500 203,500 Supplies and Commodities 424,591 496,484 645,363 377,461 503,300 534,000 Contractual Services 956,824 929,129 1,067,203 1,477,297 1,196,000 1,267,000 $3,864,189 $3,978,493 $4,275,503 $4,419,936 $4,326,500 $4,639,390 Unit: 08 - Street Division Total Street Division General Fund Streets Division Summary 2022-2023 Fiscal Year Budget Classification Fund: 01 - General Fund Expenditures $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 $5,000,000 FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2023 Proposed Budget Streets Division Expense History Contractual Services Supplies and Commodities Utilities Benefits Salaries and Wages DRAFT Page 1 of 4 01/20/22 31 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Unit: 08 - Street Department Salaries-Full Time 351,002 385,932 398,138 400,000 397,000 462,000 $351,002 $385,932 $398,138 $400,000 $397,000 $462,000 FICA 21,110 23,157 25,116 24,800 24,500 28,650 Medicare 5,062 5,538 5,992 5,800 5,750 6,700 IMRF 37,925 39,004 46,129 44,000 43,000 50,600 Employee Insurance 69,871 79,000 83,463 89,000 97,700 99,500 Deferred Comp. Contribution 9,433 9,578 10,884 10,500 11,000 12,000 Travel/Conventions/Training 12,212 11,370 2,187 10,000 10,000 13,000 IL Unemployment Insurance 4,000 4,553 4,500 4,500 4,500 4,500 $159,613 $172,200 $178,271 $188,600 $196,450 $214,950 Telephone/Internet 31,749 44,446 33,010 25,000 20,000 25,000 Cellular Phones 8,948 8,459 7,747 8,500 8,000 8,500 $40,697 $52,905 $40,757 $33,500 $28,000 $33,500 SUPP - Supplies and Commodities Office Supplies/Postage 5,237 8,064 4,134 5,000 4,500 5,000 Dues & Subscriptions 2,881 3,093 2,898 3,000 3,000 3,500 Gas/Oil/Mileage/Carwash 318 159 0 300 300 500 Supplies/Hardware 705 91 306 500 300 500 $9,141 $11,407 $7,338 $8,800 $8,100 $9,500 Building Maintenance 7,124 8,605 12,560 20,000 20,000 20,000 Legal Notices 0 2,342 3,243 1,000 1,500 2,000 $7,124 $10,947 $15,803 $21,000 $21,500 $22,000 $567,577 $633,391 $640,307 $651,900 $651,050 $741,950 Total:Supplies & Commodities Contrac - Contractual Services Total: Contractual Services Total: Administration SAL - Salaries and Wages Total: Salaries and Wages BEN - Benefits Total: Benefits UTIL - Utilities Total: UTIL - Utilities General Fund Streets Division Detail 2022-2023 Fiscal Year Budget Fund: 01 - General Fund Expenditures Division: 02 - Administration Program DRAFT Page 2 of 4 01/20/22 32 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget General Fund Streets Division Detail 2022-2023 Fiscal Year Budget Salaries-Full Time 813,414 817,383 848,798 875,000 870,000 900,000 Salaries-Part Time 71,643 57,794 0 0 0 75,000 Salaries-Overtime 134,402 120,530 97,807 80,000 85,000 85,000 $1,019,459 $995,707 $946,605 $955,000 $955,000 $1,060,000 FICA 60,326 60,282 58,971 59,500 59,000 65,720 Medicare 14,109 14,098 13,791 14,000 14,000 15,370 IMRF 98,715 91,478 106,751 105,100 105,100 116,600 Employee Insurance 199,481 184,471 192,658 226,000 225,000 235,000 Deferred Comp. Contribution 21,725 19,318 21,025 25,000 23,000 25,000 $394,356 $369,647 $393,196 $429,600 $426,100 $457,690 Electricity/Gas 208,957 196,333 195,754 210,000 160,000 170,000 $208,957 $196,333 $195,754 $210,000 $160,000 $170,000 SUPP - Supplies and Commodities Gas/Oil/Mileage/Carwash 51,796 60,155 48,040 65,000 72,000 75,000 Supplies/Hardware 17,352 16,617 14,617 15,000 15,000 15,000 Supplies - Salt Purchase 356,106 487,861 227,596 325,000 371,000 350,000 Street Sign Maintenance 37,318 43,468 51,998 65,000 55,000 60,000 Aggregate Materials 2,711 4,406 4,829 4,000 4,000 4,000 Uniforms/Clothing 10,428 9,815 11,972 10,000 10,000 10,000 $475,711 $622,322 $359,052 $484,000 $527,000 $514,000 Radio Maintenance 3,956 3,057 3,225 5,000 3,500 5,000 Vehicle Maintenance 26,194 30,102 22,249 35,000 30,000 35,000 Street Light Maintenance 94,787 153,120 137,641 125,000 125,000 135,000 Street Maintenance 97,537 168,928 157,742 165,000 165,000 165,000 Storm Sewer Improvements 16,940 11,463 15,272 20,000 15,000 20,000 Contractual Services 95,073 132,863 159,676 190,000 190,000 190,000 Contractual Snow Removal 468,986 330,321 758,253 475,000 400,000 500,000 Sidewalk Maintenance 0 442 5,220 5,000 5,000 5,000 Equipment Maintenance 105,630 167,928 134,510 100,000 100,000 125,000 $909,103 $998,224 $1,393,788 $1,120,000 $1,033,500 $1,180,000 $3,007,586 $3,182,233 $3,288,395 $3,198,600 $3,101,600 $3,381,690 Total: Utilities Total:Supplies & Commodities Contrac - Contractual Services Total: Contractual Services Total: Street Maintenance Division: 60 - Street Maintenance Program SAL - Salaries and Wages Total: Salaries and Wages BEN - Benefits Total: Benefits UTIL - Utilities DRAFT Page 3 of 4 01/20/22 33 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget General Fund Streets Division Detail 2022-2023 Fiscal Year Budget SAL - Salaries and Wages Salaries-Full Time 74,795 82,533 85,741 85,000 85,000 90,000 Salaries-Overtime 7,219 16,669 13,067 8,000 12,000 10,000 $82,014 $99,202 $98,808 $93,000 $97,000 $100,000 FICA 5,558 6,013 6,213 6,000 6,075 6,200 Medicare 1,300 1,406 1,453 1,400 1,425 1,450 IMRF 9,785 9,833 11,148 10,500 10,700 11,000 Employee Insurance 13,719 12,231 13,226 15,000 16,000 18,000 Deferred Comp. Contribution 2,253 2,268 2,275 3,500 2,700 3,500 $32,615 $31,751 $34,315 $36,400 $36,900 $40,150 SUPP - Supplies and Commodities Supplies/Hardware 11,557 11,634 11,071 10,000 10,000 10,000 Uniforms/Clothing 75 0 0 500 300 500 $11,632 $11,634 $11,071 $10,500 $10,300 $10,500 Tree Removal 11,765 33,790 44,200 30,000 35,000 35,000 Contractual Services 1,137 24,242 23,506 25,000 30,000 30,000 $12,902 $58,032 $67,706 $55,000 $65,000 $65,000 $139,163 $200,619 $211,900 $194,900 $209,200 $215,650 Salaries-Full Time 183,376 183,028 191,801 195,000 190,000 210,000 Salaries-Overtime 8,231 8,022 9,939 8,000 8,000 10,000 $191,607 $191,050 $201,740 $203,000 $198,000 $220,000 FICA 11,381 11,516 12,577 12,600 12,275 13,330 Medicare 2,662 2,693 2,942 3,000 2,870 3,120 IMRF 20,495 18,828 22,795 22,500 21,900 23,650 Employee Insurance 34,877 32,028 33,556 35,000 30,000 35,000 Deferred Comp. Contribution 3,145 3,145 5,724 5,000 4,000 5,000 $72,560 $68,210 $77,594 $78,100 $71,045 $80,100 $264,167 $259,260 $279,334 $281,100 $269,045 $300,100 $3,978,493 $4,275,503 $4,419,936 $4,326,500 $4,230,895 $4,639,390 Total: Salaries and Wages BEN - Benefits Total: Benefits Total: Vehicle Maintenance Total: Street Division Total:Supplies & Commodities Contrac - Contractual Services Total: Contractual Services Total: Forestry Program Division: 63 - Vehicle Maintenance Program SAL - Salaries and Wages Division: 62 - Forestry Program Total: Salaries and Wages BEN - Benefits Total: Benefits DRAFT Page 4 of 4 01/20/22 34 FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2023 Proposed Budget Unit: 09 - Community Development Salaries and Wages 343,473 347,822 352,345 342,605 397,500 439,000 Benefits 150,362 154,115 145,197 150,066 184,300 197,500 Utilities 3,276 4,146 4,024 2,373 4,500 5,000 Supplies and Commodities 20,465 26,728 9,540 8,419 17,750 17,750 Contractual Services 32,415 61,036 47,455 100,063 72,000 183,500 $549,991 $593,847 $558,561 $603,526 $676,050 $842,750Total: 20 - Planning Program Classification Fund: 01 - General Fund Expenditures General Fund Planning Division Summary 2022-2023 Fiscal Year Budget Division: 20 - Planning Program $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2023 Proposed Budget Planning Division Expense History Contractual Services Supplies and Commodities Utilities Benefits Salaries and Wages DRAFT Page 1 of 4 02/10/2022 35 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Unit: 09 - Community Development Division: 20 - Planning Program Salaries-Full Time 343,839 349,443 338,140 389,000 355,000 430,000 Salaries-Overtime 2,845 172 0 2,000 300 2,000 Salaries-Commissioner 1,138 2,730 4,465 6,500 6,000 7,000 $347,822 $352,345 $342,605 $397,500 $361,300 $439,000 FICA 21,162 20,988 21,781 25,000 22,500 27,500 Medicare 4,949 4,909 5,094 5,800 5,300 6,500 IMRF 37,018 34,288 38,774 43,000 39,000 48,500 Employee Insurance 76,347 74,752 75,575 93,000 87,000 96,000 Deferred Comp. Contribution 5,420 5,554 6,597 8,500 6,500 8,000 Travel/Training 8,341 3,856 1,245 8,000 4,000 10,000 IL Unemployment Insurance 878 850 1,000 1,000 1,000 1,000 $154,115 $145,197 $150,066 $184,300 $165,300 $197,500 Telephone/Internet 3,173 3,165 1,341 3,000 1,500 3,000 Cellular Phones 973 859 1,032 1,500 1,500 2,000 $4,146 $4,024 $2,373 $4,500 $3,000 $5,000 SUPP - Supplies and Commodities Office Supplies/Postage 22,702 4,866 3,795 12,000 10,000 12,000 Dues & Subscriptions 3,776 4,434 4,587 5,000 4,600 5,000 Gas/Oil/Mileage/Carwash 250 240 37 750 200 750 $26,728 $9,540 $8,419 $17,750 $14,800 $17,750 Maintenance Contracts/Lease 550 1,949 1,820 2,000 2,000 2,500 Vehicle Maintenance 0 0 0 1,000 0 1,000 Legal Notices 0 13,382 10,514 10,000 10,000 10,000 Legal Fees 4,199 2,184 2,026 4,000 1,800 5,000 Special Projects and Programs 9,924 12,217 62,528 15,000 15,000 135,000 Contractual Services 30,913 4,048 4,387 30,000 15,000 15,000 Engineering Fees 15,450 13,675 18,788 10,000 18,000 15,000 $61,036 $47,455 $100,063 $72,000 $61,800 $183,500 $593,847 $558,561 $603,526 $676,050 $606,200 $842,750 Fund: 01 - General Fund Expenditures General Fund Planning Division Detail 2022-2023 Fiscal Year Budget Total: Supplies & Commodities Contrac - Contractual Services Total: Contractual Services Total: 20 - Planning Program SAL - Salaries and Wages Total: Salaries and Wages BEN - Benefits Total: Benefits UTIL - Utilities Total: Utilities DRAFT Page 2 of 4 02/10/2022 36 FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2023 Proposed Budget Unit: 09 - Community Development Salaries and Wages 579,510 645,504 665,429 669,669 658,000 688,000 Benefits 269,032 296,055 304,758 313,503 330,300 345,500 Utilities 4,278 4,621 4,795 4,499 5,500 5,500 Supplies and Commodities 9,710 7,489 10,638 9,430 15,000 15,500 Contractual Services 3,166 10,496 5,953 5,782 14,000 19,000 $865,696 $964,165 $991,573 $1,002,883 $1,022,800 $1,073,500 General Fund Building Division Summary 2022-2023 Fiscal Year Budget Total Building Program Classification Fund: 01 - General Fund Expenditures Division: 21 - Building Program $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 FY 2018 Actual FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2023 Proposed Budget Building Division Expense History Contractual Services Supplies and Commodities Utilities Benefits Salaries and Wages DRAFT Page 3 of 4 02/10/2022 37 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Unit: 09 - Community Development Salaries-Full Time 642,943 664,788 669,669 655,000 655,000 685,000 Salaries-Overtime 2,561 641 0 3,000 0 3,000 $645,504 $665,429 $669,669 $658,000 $655,000 $688,000 FICA 38,083 39,806 41,796 41,000 41,000 43,000 Medicare 8,906 9,310 9,775 9,800 9,800 10,000 IMRF 67,963 65,930 75,590 73,000 71,000 76,000 Employee Insurance 152,094 170,385 164,902 178,000 178,000 185,000 Deferred Comp. Contribution 16,344 11,931 16,397 15,000 15,000 15,000 Travel/Training 11,188 5,845 3,543 12,000 8,000 15,000 IL Unemployment Insurance 1,477 1,551 1,500 1,500 1,500 1,500 $296,055 $304,758 $313,503 $330,300 $324,300 $345,500 Telephone/Internet 810 1,031 449 1,000 600 1,000 Cellular Phones 3,811 3,764 4,050 4,500 4,000 4,500 $4,621 $4,795 $4,499 $5,500 $4,600 $5,500 Office Supplies/Postage 6,265 8,213 8,192 10,000 9,000 10,000 Dues & Subscriptions 675 935 340 3,000 1,000 3,000 Gas/Oil/Mileage/Carwash 57 547 0 1,000 500 1,000 Uniforms/Clothing 492 943 898 1,000 1,000 1,500 $7,489 $10,638 $9,430 $15,000 $11,500 $15,500 Recording Fees 1,079 1,847 2,612 3,000 3,000 3,000 Vehicle Maintenance 0 0 0 1,000 0 1,000 Contractual Services 9,417 4,106 3,170 10,000 15,000 15,000 $10,496 $5,953 $5,782 $14,000 $18,000 $19,000 $964,165 $991,573 $1,002,883 $1,022,800 $1,013,400 $1,073,500 Fund: 01 - General Fund Expenditures Division: 21 - Building Program General Fund Building Division Detail 2022-2023 Fiscal Year Budget Total: 21 - Building Program SAL - Salaries and Wages Total: SAL - Salaries and Wages BEN - Benefits Total: Benefits SUPP - Supplies and Commodities Total: Supplies & Commodities Contrac - Contractual Services Total: Contractual Services UTIL - Utilities Total: Utilities DRAFT Page 4 of 4 02/10/2022 38 Description FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2022 Estimated Amount FY 2023 Proposed Budget Fund: 07 - Tort Immunity Fund Property Taxes Property Tax Revenue 491,668 399,426 150,397 350,000 350,000 685,000 Total: Property Taxes $491,668 $399,426 $150,397 $350,000 $350,000 $685,000 Investment Income Interest Income 8,101 8,237 484 1,000 500 300 Total: Investment Income $8,101 $8,237 $484 $1,000 $500 $300 Other Reimbursements $451 $0 $0 $0 $0 $0 $451 $0 $0 $0 $0 $0 Transfers Transfer from General 0 0 0 0 0 300,000 Total: Transfers $0 $0 $0 $0 $0 $300,000 Revenues Total $500,220 $407,663 $150,881 $351,000 $350,500 $985,300 Unit: 00 - Non-Departmental Contractual Services Bond-Treasurer 336 336 336 336 336 336 Comm. Umbrella Liability 170,959 157,579 220,751 280,000 351,336 437,500 Workman's Comp. Ins.180,488 189,364 189,914 230,000 240,481 315,000 Total: Contractual Services $351,783 $347,279 $411,001 $510,336 $592,153 $752,836 Expenditures Total $351,783 $347,279 $411,001 $510,336 $592,153 $752,836 Total: Tort Immunity Fund $148,437 $60,384 ($260,120)($159,336)($241,653)$232,464 **Tort Immunity Fund has a 4/30/21 Fund Balance of $242,787 Tort Immunity Fund 2022-2023 Fiscal Year Budget Revenues Expenditures Revenue & Expense Detail MISC - Miscellaneous Total: Miscellaneous $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 FY 2019 Actual FY 2020 Actual FY 2021 Actual FY 2022 Adopted Budget FY 2023 Proposed Budget Tort Immunity Revenue History Property Tax Revenue DRAFT Page 1 of 1 02/24/2022 39 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund REVENUE 0400.401 Property Tax Revenue 4,518,780.00 .00 4,518,780.00 18,985.00 .00 4,593,106.68 (74,326.68)102 4,512,638.69 0400.402 Property Tax Rev-Road & Bridge 380,000.00 .00 380,000.00 1,966.02 .00 400,655.01 (20,655.01)105 384,392.48 0400.403 Property Tax Rev-Police Pension 1,700,000.00 .00 1,700,000.00 7,015.49 .00 1,697,212.37 2,787.63 100 1,577,460.01 0400.404 Property Tax Revenue-IMRF 550,000.00 .00 550,000.00 2,273.35 .00 549,909.66 90.34 100 549,370.66 0450.451 Municipal Sales Tax 6,550,000.00 .00 6,550,000.00 723,542.08 .00 6,407,025.10 142,974.90 98 6,812,757.14 0450.452 Illinois Income Tax 4,100,000.00 .00 4,100,000.00 609,892.24 .00 4,221,090.54 (121,090.54)103 4,537,459.83 0450.453 Replacement Tax 55,000.00 .00 55,000.00 17,128.01 .00 78,030.92 (23,030.92)142 60,678.44 0450.454 Replacement Tax-Library .00 .00 .00 5,850.27 .00 7,444.43 (7,444.43)+++.00 0450.455 Local Use Tax 1,550,000.00 .00 1,550,000.00 143,050.71 .00 1,159,034.45 390,965.55 75 1,809,248.02 0500.500 Hotel/Motel Tax 800.00 .00 800.00 612.88 .00 1,415.88 (615.88)177 418.50 0500.501 Amusement Tax 7,000.00 .00 7,000.00 2,893.00 .00 5,578.05 1,421.95 80 1,242.85 0500.503 Local Motor Fuel Tax 1,000,000.00 .00 1,000,000.00 106,677.99 .00 948,183.75 51,816.25 95 970,687.25 0550.551 Liquor License 100,000.00 .00 100,000.00 .00 .00 120,933.30 (20,933.30)121 97,940.40 0550.552 Contractors License 45,000.00 .00 45,000.00 3,700.00 .00 37,700.00 7,300.00 84 46,800.00 0550.553 Cigarette License 6,000.00 .00 6,000.00 .00 .00 5,500.00 500.00 92 5,750.00 0550.554 Scavenger License 200.00 .00 200.00 .00 .00 50.00 150.00 25 100.00 0550.558 Business License 40,000.00 .00 40,000.00 4,000.00 .00 38,812.50 1,187.50 97 44,425.00 0570.555 Building Permit 1,175,000.00 .00 1,175,000.00 121,500.88 .00 1,259,008.71 (84,008.71)107 1,495,052.16 0570.556 Sign Permit 5,000.00 .00 5,000.00 885.15 .00 4,040.31 959.69 81 3,687.04 0570.557 Special Movement Permit 15,000.00 .00 15,000.00 3,755.00 .00 50,080.00 (35,080.00)334 27,900.00 0570.560 Solicitors Permit 2,000.00 .00 2,000.00 50.00 .00 1,175.00 825.00 59 2,860.00 0600.601 County Court Fines 325,000.00 .00 325,000.00 24,097.53 .00 308,706.77 16,293.23 95 297,493.49 0600.602 Administrative Fines(P-Tickets)125,000.00 .00 125,000.00 9,975.00 .00 81,500.00 43,500.00 65 108,666.25 0600.603 Asset Seizure-Non Federal 225,000.00 .00 225,000.00 6,543.98 .00 51,034.09 173,965.91 23 94,861.24 0600.604 Alarm Fees 1,000.00 .00 1,000.00 100.00 .00 (550.00)1,550.00 -55 9,000.03 0600.605 Kendall County Court Fines 3,000.00 .00 3,000.00 1,354.00 .00 3,479.95 (479.95)116 5,828.16 0600.607 Administrative Fines- Late Fee 9,000.00 .00 9,000.00 1,140.00 .00 5,085.00 3,915.00 56 9,025.00 0600.630 Asset Seizure-Federal (Dept of Justice Equitable Share) 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 .00 0600.632 Asset Seizure-Federal (U.S. Treasury Equitable Share) 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 0620.655 Garbage Fee 4,850,000.00 .00 4,850,000.00 417,494.92 .00 4,079,783.54 770,216.46 84 4,708,690.19 0620.656 Garbage Penalty 25,000.00 .00 25,000.00 5,024.06 .00 29,904.34 (4,904.34)120 (2.82) 0640.500 Engineering Services 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 .00 0650.651 Zoning Applications 15,000.00 .00 15,000.00 925.00 .00 17,054.00 (2,054.00)114 21,899.45 0650.653 Accident Report Fees 5,000.00 .00 5,000.00 730.00 .00 6,275.00 (1,275.00)126 6,250.00 0650.654 Copies-Maps & Ordinances 2,000.00 .00 2,000.00 165.00 .00 1,484.96 515.04 74 1,381.25 0650.670 Impound Fee 25,000.00 .00 25,000.00 1,750.00 .00 20,000.00 5,000.00 80 41,000.00 0650.815 Parking Lot Revenue 2,000.00 .00 2,000.00 .00 .00 1,946.00 54.00 97 3,400.00 0650.818 Tower Rent 46,000.00 .00 46,000.00 9,325.69 .00 36,697.49 9,302.51 80 49,215.20 0650.825 Rental Income 49,200.00 .00 49,200.00 6,100.00 .00 38,900.00 10,300.00 79 49,200.00 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 1 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 40 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund REVENUE 0650.830 Rental-Community/Multi Room 4,000.00 .00 4,000.00 15.00 .00 355.00 3,645.00 9 .00 0650.904 Special Detail/OT Reimbursement 75,000.00 .00 75,000.00 .00 .00 92,816.00 (17,816.00)124 26,146.40 0690.902 Water & Sewer Service Charge 350,000.00 .00 350,000.00 .00 .00 175,000.00 175,000.00 50 350,000.00 0700.005 FEMA Grant .00 .00 .00 .00 .00 36,195.60 (36,195.60)+++36,195.60 0700.650 Grant Revenue .00 .00 .00 .00 .00 .00 .00 +++1,814,016.25 0700.704 Bulletproof Vest Grant 3,000.00 .00 3,000.00 .00 .00 2,256.31 743.69 75 8,495.26 0700.710 Tobacco Grant 2,750.00 .00 2,750.00 .00 .00 1,320.00 1,430.00 48 1,320.00 0700.717 Traffic Grant 30,000.00 .00 30,000.00 4,774.11 .00 79,158.12 (49,158.12)264 72,930.87 0750.750 AT&T Franchise Fees 120,000.00 .00 120,000.00 624.13 .00 50,435.08 69,564.92 42 102,746.17 0750.751 Cable TV-Franchise Fees 475,000.00 .00 475,000.00 (5,987.22).00 378,218.78 96,781.22 80 470,110.30 0800.800 Interest Income 41,758.00 .00 41,758.00 2,544.98 .00 59,762.06 (18,004.06)143 74,328.49 0800.826 Realized Gain/Loss On Investment .00 .00 .00 .00 .00 6,367.04 (6,367.04)+++.00 0800.827 Unrealized Gain/Loss .00 .00 .00 (14,596.06).00 (66,623.89)66,623.89 +++(30,264.47) 0800.830 Unrealized Gain/Loss IMET .00 .00 .00 (10,554.07).00 (23,322.66)23,322.66 +++8,671.62 0801.200 Event Sponsorship Program 3,000.00 .00 3,000.00 .00 .00 .00 3,000.00 0 .00 0801.801 Reimbursement Police Training .00 .00 .00 .00 .00 .00 .00 +++1,443.60 0801.802 Amphitheater Rent 500.00 .00 500.00 250.00 .00 250.00 250.00 50 .00 0801.807 Restitution Program .00 .00 .00 .00 .00 .00 .00 +++4,100.00 0801.822 Donation/Contribution 15,000.00 .00 15,000.00 .00 .00 8,013.67 6,986.33 53 6,494.00 0803.000 Sales-Fixed Assets 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 21,602.77 0805.000 Other Reimbursements 90,000.00 .00 90,000.00 22,062.62 .00 147,716.27 (57,716.27)164 115,680.85 0806.000 Other Receipts 25,000.00 .00 25,000.00 2,781.38 .00 27,290.57 (2,290.57)109 25,451.89 0860.804 School Liaison Reimbursement 395,000.00 .00 395,000.00 .00 .00 353,963.81 41,036.19 90 76,004.58 0860.819 HIDTA/Organized Crime Reimb 10,000.00 .00 10,000.00 (387.65).00 12,036.10 (2,036.10)120 27,438.79 0999.904 Transfer From MFT 150,000.00 .00 150,000.00 .00 .00 .00 150,000.00 0 .00 0999.917 Transfer From TIF 50,000.00 .00 50,000.00 .00 .00 .00 50,000.00 0 .00 0999.927 Transfer From Alcohol Enforc.25,000.00 .00 25,000.00 .00 .00 .00 25,000.00 0 25,000.00 REVENUE TOTALS $29,384,988.00 $0.00 $29,384,988.00 $2,260,030.47 $0.00 $27,608,495.66 $1,776,492.34 94%$31,584,688.88 EXPENSE Unit 00 - Non-Departmental Division 94 - Contra 2020.001 Contra Insurance Account .00 .00 .00 .00 .00 .00 .00 +++(127,595.20) Division 94 - Contra Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++($127,595.20) Unit 00 - Non-Departmental Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++($127,595.20) Unit 04 - Administration/Finance Division 00 - Non-Divisional 8100 Fees to Refuse Hauler 4,480,000.00 .00 4,480,000.00 .00 .00 2,630,418.00 1,849,582.00 59 4,364,628.13 9997 Bad Debt Expense .00 .00 .00 .00 .00 .00 .00 +++11,305.30 Division 00 - Non-Divisional Totals $4,480,000.00 $0.00 $4,480,000.00 $0.00 $0.00 $2,630,418.00 $1,849,582.00 59%$4,375,933.43 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 2 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 41 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 01 - Legislative Program 1000 Salaries-President 24,000.00 .00 24,000.00 2,000.00 .00 18,000.00 6,000.00 75 24,000.00 1002 Salaries-Elected Officials 25,000.00 .00 25,000.00 1,500.00 .00 20,800.00 4,200.00 83 23,000.00 1003 Salaries-Liquor Commissioner 1,500.00 .00 1,500.00 125.00 .00 1,125.00 375.00 75 1,500.00 1004 Salaries-Treasurer 2,500.00 .00 2,500.00 208.33 .00 1,874.97 625.03 75 2,499.96 2000 FICA 3,300.00 .00 3,300.00 237.67 .00 2,591.60 708.40 79 3,162.00 2001 Medicare 780.00 .00 780.00 55.58 .00 606.09 173.91 78 739.50 2020 Employee Insurance 150.00 .00 150.00 .00 .00 8.40 141.60 6 100.80 3000 Travel/Training 10,000.00 .00 10,000.00 .00 .00 .00 10,000.00 0 .00 5010 Replacement Supplies 3,000.00 .00 3,000.00 .00 .00 2,683.68 316.32 89 5,247.72 5015 Dues & Subscriptions 50,000.00 .00 50,000.00 .00 .00 15,556.15 34,443.85 31 53,068.42 8070 Public Relations 115,000.00 .00 115,000.00 8,315.82 .00 61,723.12 53,276.88 54 107,052.45 8074 Cable TV 10,000.00 .00 10,000.00 .00 .00 .00 10,000.00 0 15,760.63 8078 Economic Incentive Rebate 650,000.00 .00 650,000.00 59,640.94 .00 89,137.86 560,862.14 14 587,273.04 8078.001 Small Business Relief Grant .00 .00 .00 .00 .00 .00 .00 +++145,000.00 Division 01 - Legislative Program Totals $895,230.00 $0.00 $895,230.00 $72,083.34 $0.00 $214,106.87 $681,123.13 24%$968,404.52 Division 02 - Administration Program 1005 Salaries-Full Time 675,000.00 .00 675,000.00 50,455.90 .00 493,552.90 181,447.10 73 671,481.33 1015 Salaries-Part Time 75,000.00 .00 75,000.00 5,642.39 .00 53,739.45 21,260.55 72 63,772.72 1800 Salaries-Overtime 2,000.00 .00 2,000.00 180.14 .00 871.65 1,128.35 44 276.07 2000 FICA 45,000.00 .00 45,000.00 3,416.28 .00 31,693.26 13,306.74 70 40,465.91 2001 Medicare 10,500.00 .00 10,500.00 798.99 .00 7,828.95 2,671.05 75 11,244.56 2010 IMRF 80,000.00 .00 80,000.00 5,051.98 .00 59,235.16 20,764.84 74 84,122.43 2020 Employee Insurance 90,000.00 .00 90,000.00 9,355.64 .00 80,280.91 9,719.09 89 89,851.90 2025 Deferred Comp. Contribution 25,000.00 .00 25,000.00 .00 .00 .00 25,000.00 0 20,553.72 3000 Travel/Training 12,000.00 .00 12,000.00 .00 .00 575.50 11,424.50 5 1,501.00 3015 IL Unemployment Insurance 5,000.00 .00 5,000.00 .00 .00 2,232.47 2,767.53 45 5,310.50 4000 Telephone/Internet 12,085.00 .00 12,085.00 150.30 .00 4,042.83 8,042.17 33 2,467.67 4005 Cellular Phones 2,500.00 .00 2,500.00 239.77 .00 905.98 1,594.02 36 1,657.48 5005 Office Supplies/Postage 32,000.00 .00 32,000.00 2,626.73 .00 25,194.27 6,805.73 79 32,225.42 5015 Dues & Subscriptions 5,000.00 .00 5,000.00 .00 .00 859.00 4,141.00 17 2,476.00 5020 Gas/Oil/Mileage/Carwash 9,500.00 .00 9,500.00 500.00 .00 1,643.11 7,856.89 17 7,200.00 8035 Maintenance Contracts/Lease 8,000.00 .00 8,000.00 149.83 .00 1,289.03 6,710.97 16 1,893.73 8045 Recording Fees 1,000.00 .00 1,000.00 .00 .00 301.75 698.25 30 505.67 8050 Legal Notices 2,500.00 .00 2,500.00 .00 .00 996.68 1,503.32 40 2,103.26 8065 Legal Fees 80,000.00 .00 80,000.00 5,380.00 .00 65,653.69 14,346.31 82 43,084.50 8135 Contractual Services 65,000.00 .00 65,000.00 740.80 .00 61,198.00 3,802.00 94 54,831.99 8135.008 Settlement Charges .00 .00 .00 1,637.99 .00 10,819.04 (10,819.04)+++8,752.95 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 3 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 42 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 02 - Administration Program 9115 Office Furniture & Equipment 5,000.00 .00 5,000.00 .00 .00 1,110.74 3,889.26 22 3,919.90 9300 Contingencies 40,000.00 .00 40,000.00 40.63 .00 1,066.43 38,933.57 3 25,884.43 Division 02 - Administration Program Totals $1,282,085.00 $0.00 $1,282,085.00 $86,367.37 $0.00 $905,090.80 $376,994.20 71%$1,175,583.14 Division 03 - Community Relations Program 1005 Salaries-Full Time 111,000.00 .00 111,000.00 8,333.86 .00 79,142.81 31,857.19 71 110,915.66 2000 FICA 6,800.00 .00 6,800.00 494.34 .00 4,653.94 2,146.06 68 6,745.24 2001 Medicare 1,600.00 .00 1,600.00 115.62 .00 1,088.44 511.56 68 1,577.49 2010 IMRF 12,100.00 .00 12,100.00 761.72 .00 8,653.90 3,446.10 72 12,682.10 2020 Employee Insurance 25,000.00 .00 25,000.00 1,998.62 .00 21,379.55 3,620.45 86 23,066.34 2025 Deferred Comp. Contribution 4,000.00 .00 4,000.00 .00 .00 .00 4,000.00 0 3,754.60 3000 Travel/Training 1,500.00 .00 1,500.00 .00 .00 35.00 1,465.00 2 81.00 4000 Telephone/Internet 750.00 .00 750.00 9.33 .00 256.74 493.26 34 309.49 5005 Office Supplies/Postage 300.00 .00 300.00 .00 .00 21.74 278.26 7 .00 5015 Dues & Subscriptions 850.00 .00 850.00 .00 .00 604.00 246.00 71 634.00 5020 Gas/Oil/Mileage/Carwash 100.00 .00 100.00 .00 .00 .00 100.00 0 .00 8070 Public Relations 28,000.00 .00 28,000.00 .00 .00 12,608.81 15,391.19 45 11,148.20 8071 Marketing and Promotions 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 8072 Settler's Park 4,000.00 .00 4,000.00 .00 .00 1,180.00 2,820.00 30 .00 8135 Contractual Services 4,000.00 .00 4,000.00 .00 .00 3,800.00 200.00 95 13,561.25 Division 03 - Community Relations Program Totals $201,000.00 $0.00 $201,000.00 $11,713.49 $0.00 $133,424.93 $67,575.07 66%$184,475.37 Division 04 - Facility Management Program 1005 Salaries-Full Time 55,000.00 .00 55,000.00 4,101.69 .00 40,760.64 14,239.36 74 53,083.52 1800 Salaries-Overtime 4,500.00 .00 4,500.00 859.22 .00 3,019.34 1,480.66 67 3,344.38 2000 FICA 3,700.00 .00 3,700.00 297.27 .00 2,618.05 1,081.95 71 3,510.65 2001 Medicare 900.00 .00 900.00 69.53 .00 612.36 287.64 68 821.09 2010 IMRF 6,500.00 .00 6,500.00 453.42 .00 4,773.94 1,726.06 73 6,405.34 2020 Employee Insurance 18,000.00 .00 18,000.00 1,086.96 .00 11,724.96 6,275.04 65 14,731.91 2025 Deferred Comp. Contribution 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 1,219.72 5000 Building Supplies 15,000.00 .00 15,000.00 113.69 .00 6,320.34 8,679.66 42 12,675.93 5010 Replacement Supplies .00 .00 .00 .00 .00 111.27 (111.27)+++.00 8135 Contractual Services 45,000.00 .00 45,000.00 293.00 .00 44,651.47 348.53 99 42,946.26 9105 Building Improvements 25,000.00 .00 25,000.00 .00 .00 1,668.79 23,331.21 7 32,885.12 Division 04 - Facility Management Program Totals $174,600.00 $0.00 $174,600.00 $7,274.78 $0.00 $116,261.16 $58,338.84 67%$171,623.92 Division 06 - Human Resources Program 1005 Salaries-Full Time 190,000.00 .00 190,000.00 14,566.48 .00 138,292.91 51,707.09 73 185,128.87 1800 Salaries-Overtime 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 2000 FICA 12,000.00 .00 12,000.00 855.43 .00 8,147.90 3,852.10 68 11,788.55 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 4 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 43 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 06 - Human Resources Program 2001 Medicare 2,800.00 .00 2,800.00 200.06 .00 1,905.55 894.45 68 2,842.73 2010 IMRF 21,000.00 .00 21,000.00 1,331.38 .00 15,163.41 5,836.59 72 22,033.98 2020 Employee Insurance 45,000.00 .00 45,000.00 3,390.50 .00 36,654.24 8,345.76 81 42,044.34 2025 Deferred Comp. Contribution 8,000.00 .00 8,000.00 .00 .00 .00 8,000.00 0 6,952.80 3000 Travel/Training 6,500.00 .00 6,500.00 .00 .00 85.00 6,415.00 1 614.00 4000 Telephone/Internet 1,000.00 .00 1,000.00 12.44 .00 343.40 656.60 34 449.57 4005 Cellular Phones 600.00 .00 600.00 84.64 .00 339.07 260.93 57 543.16 5005 Office Supplies/Postage 1,500.00 .00 1,500.00 .00 .00 809.88 690.12 54 1,250.61 5015 Dues & Subscriptions 9,000.00 .00 9,000.00 390.00 .00 9,563.00 (563.00)106 707.50 5020 Gas/Oil/Mileage/Carwash 1,200.00 .00 1,200.00 .00 .00 .00 1,200.00 0 .00 8070 Public Relations 12,000.00 .00 12,000.00 197.00 .00 4,799.05 7,200.95 40 7,362.66 8135 Contractual Services 8,000.00 .00 8,000.00 .00 .00 398.00 7,602.00 5 1,348.00 Division 06 - Human Resources Program Totals $319,100.00 $0.00 $319,100.00 $21,027.93 $0.00 $216,501.41 $102,598.59 68%$283,066.77 Division 08 - IT Program 1005 Salaries-Full Time 368,000.00 .00 368,000.00 25,068.79 .00 235,226.41 132,773.59 64 307,527.37 1800 Salaries-Overtime 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 2000 FICA 23,000.00 .00 23,000.00 1,450.51 .00 13,981.72 9,018.28 61 19,250.42 2001 Medicare 5,400.00 .00 5,400.00 339.23 .00 3,269.90 2,130.10 61 4,502.13 2010 IMRF 40,500.00 .00 40,500.00 2,291.29 .00 25,720.93 14,779.07 64 34,518.62 2020 Employee Insurance 81,000.00 .00 81,000.00 7,469.86 .00 65,815.64 15,184.36 81 55,192.36 2025 Deferred Comp. Contribution 6,000.00 .00 6,000.00 .00 .00 .00 6,000.00 0 7,419.36 3000 Travel/Training 17,000.00 .00 17,000.00 .00 .00 183.64 16,816.36 1 .00 4000 Telephone/Internet 500.00 .00 500.00 6.22 .00 171.69 328.31 34 227.62 4005 Cellular Phones 4,170.00 .00 4,170.00 486.10 .00 1,945.88 2,224.12 47 2,795.93 5005 Office Supplies/Postage 1,750.00 .00 1,750.00 82.34 .00 696.32 1,053.68 40 2,586.46 5015 Dues & Subscriptions 800.00 .00 800.00 .00 .00 564.00 236.00 70 689.00 5020 Gas/Oil/Mileage/Carwash 400.00 .00 400.00 .00 .00 .00 400.00 0 .00 5095 Uniforms/Clothing 800.00 .00 800.00 .00 .00 288.50 511.50 36 267.00 8030 Server/Network Supplies 78,500.00 .00 78,500.00 3,595.50 .00 40,648.18 37,851.82 52 74,697.61 8031 Software Licensing/Renewals 436,700.00 .00 436,700.00 40,822.92 74,664.99 232,383.62 129,651.39 70 444,440.44 8135 Contractual Services 55,500.00 .00 55,500.00 92.25 .00 6,546.75 48,953.25 12 52,263.22 9111 Computers 40,000.00 .00 40,000.00 .00 .00 430.21 39,569.79 1 39,558.05 Division 08 - IT Program Totals $1,160,520.00 $0.00 $1,160,520.00 $81,705.01 $74,664.99 $627,873.39 $457,981.62 61%$1,045,935.59 Division 09 - Legal Program 1005 Salaries-Full Time 292,000.00 .00 292,000.00 22,110.86 .00 213,427.60 78,572.40 73 291,980.86 1015 Salaries-Part Time 35,000.00 .00 35,000.00 2,509.42 .00 20,047.24 14,952.76 57 26,877.50 1800 Salaries-Overtime 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 5 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 44 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund EXPENSE Unit 04 - Administration/Finance Division 09 - Legal Program 2000 FICA 20,300.00 .00 20,300.00 1,482.58 .00 13,644.95 6,655.05 67 20,012.90 2001 Medicare 4,750.00 .00 4,750.00 346.72 .00 3,296.44 1,453.56 69 4,605.01 2010 IMRF 36,000.00 .00 36,000.00 2,265.57 .00 25,907.90 10,092.10 72 35,706.31 2020 Employee Insurance 68,000.00 .00 68,000.00 4,936.14 .00 55,159.34 12,840.66 81 60,369.99 2025 Deferred Comp. Contribution 8,000.00 .00 8,000.00 .00 .00 .00 8,000.00 0 9,389.04 3000 Travel/Training 3,000.00 .00 3,000.00 .00 .00 80.00 2,920.00 3 554.00 4000 Telephone/Internet 1,000.00 .00 1,000.00 12.44 .00 344.89 655.11 34 491.38 4005 Cellular Phones 700.00 .00 700.00 150.46 .00 474.88 225.12 68 1,207.59 5005 Office Supplies/Postage 10,000.00 .00 10,000.00 436.38 .00 3,012.07 6,987.93 30 5,632.37 5015 Dues & Subscriptions 10,500.00 .00 10,500.00 35.00 .00 6,845.72 3,654.28 65 10,505.52 5020 Gas/Oil/Mileage/Carwash 500.00 .00 500.00 .00 .00 655.91 (155.91)131 836.53 5095 Uniforms/Clothing 600.00 .00 600.00 .00 .00 155.85 444.15 26 633.80 8035 Maintenance Contracts/Lease 2,160.00 .00 2,160.00 149.83 .00 1,496.52 663.48 69 2,016.40 8060 Vehicle Maintenance 1,000.00 .00 1,000.00 .00 .00 3,356.33 (2,356.33)336 783.77 8065 Legal Fees 20,000.00 .00 20,000.00 .00 .00 12,190.00 7,810.00 61 20,298.00 Division 09 - Legal Program Totals $514,510.00 $0.00 $514,510.00 $34,435.40 $0.00 $360,095.64 $154,414.36 70%$491,900.97 Division 99 - Transfers 9911 Transfer to Capital Improvements .00 .00 .00 .00 .00 .00 .00 +++3,121,257.00 Division 99 - Transfers Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 +++$3,121,257.00 Unit 04 - Administration/Finance Totals $9,027,045.00 $0.00 $9,027,045.00 $314,607.32 $74,664.99 $5,203,772.20 $3,748,607.81 58%$11,818,180.71 Unit 05 - Police Department Division 02 - Administration Program 1005 Salaries-Full Time 345,063.00 .00 345,063.00 24,261.42 .00 245,284.59 99,778.41 71 338,918.78 1015 Salaries-Part Time 34,944.00 .00 34,944.00 2,399.40 .00 7,852.32 27,091.68 22 32,173.67 1800 Salaries-Overtime 1,000.00 .00 1,000.00 .00 .00 486.97 513.03 49 254.89 2000 FICA 23,622.00 .00 23,622.00 1,605.69 .00 14,323.63 9,298.37 61 22,606.90 2001 Medicare 5,525.00 .00 5,525.00 375.55 .00 3,544.97 1,980.03 64 5,449.54 2010 IMRF 25,576.00 .00 25,576.00 1,319.79 .00 15,027.16 10,548.84 59 23,139.76 2020 Employee Insurance 72,800.00 .00 72,800.00 4,799.84 .00 53,900.21 18,899.79 74 67,335.57 2025 Deferred Comp. Contribution 8,000.00 .00 8,000.00 .00 .00 .00 8,000.00 0 6,380.80 3000 Travel/Training 7,000.00 .00 7,000.00 52.52 .00 816.25 6,183.75 12 3,630.03 3001 Education/School 3,000.00 .00 3,000.00 .00 .00 3,000.00 .00 100 3,000.00 3015 IL Unemployment Insurance 20,000.00 .00 20,000.00 .00 .00 9,794.73 10,205.27 49 20,000.00 4000 Telephone/Internet 1,100.00 .00 1,100.00 11.70 .00 355.20 744.80 32 449.72 4005 Cellular Phones 1,200.00 .00 1,200.00 84.64 .00 339.07 860.93 28 527.06 5005 Office Supplies/Postage 8,000.00 .00 8,000.00 216.59 .00 3,536.01 4,463.99 44 6,290.96 5010 Replacement Supplies 4,550.00 .00 4,550.00 140.08 .00 1,351.81 3,198.19 30 1,898.53 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 6 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 45 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 02 - Administration Program 5015 Dues & Subscriptions 5,000.00 .00 5,000.00 440.00 .00 4,636.00 364.00 93 4,905.45 5020 Gas/Oil/Mileage/Carwash 3,700.00 .00 3,700.00 .00 .00 1,446.17 2,253.83 39 1,244.90 5095 Uniforms/Clothing 1,800.00 .00 1,800.00 125.96 .00 654.69 1,145.31 36 2,251.03 8035 Maintenance Contracts/Lease 6,709.00 .00 6,709.00 760.58 .00 4,804.67 1,904.33 72 5,650.65 8040 Custodial Supplies/Building Maintenance 65,000.00 .00 65,000.00 2,814.30 .00 41,213.29 23,786.71 63 71,172.04 8060 Vehicle Maintenance 2,500.00 .00 2,500.00 100.10 .00 782.65 1,717.35 31 1,687.76 8135 Contractual Services 8,000.00 .00 8,000.00 .00 .00 5,057.50 2,942.50 63 21,229.55 Division 02 - Administration Program Totals $654,089.00 $0.00 $654,089.00 $39,508.16 $0.00 $418,207.89 $235,881.11 64%$640,197.59 Division 51 - Police Patrol 1005 Salaries-Full Time 4,262,309.00 .00 4,262,309.00 327,687.77 .00 2,983,156.09 1,279,152.91 70 3,985,541.07 1015 Salaries-Part Time .00 .00 .00 .00 .00 .00 .00 +++(1,025.22) 1800 Salaries-Overtime 250,000.00 .00 250,000.00 23,991.58 .00 170,892.81 79,107.19 68 224,246.65 2000 FICA 279,763.00 .00 279,763.00 20,606.83 .00 186,183.84 93,579.16 67 265,944.17 2001 Medicare 65,428.00 .00 65,428.00 4,819.30 .00 43,849.05 21,578.95 67 62,252.63 2010 IMRF 14,550.00 .00 14,550.00 880.72 .00 10,259.27 4,290.73 71 15,670.28 2011 Employer Pension Contributions 1,700,000.00 .00 1,700,000.00 7,015.49 .00 1,697,212.37 2,787.63 100 1,577,460.01 2020 Employee Insurance 665,615.00 .00 665,615.00 52,362.72 .00 553,955.38 111,659.62 83 630,360.85 2025 Deferred Comp. Contribution 125,000.00 .00 125,000.00 .00 .00 .00 125,000.00 0 114,453.73 3000 Travel/Training 41,000.00 .00 41,000.00 310.20 .00 24,639.03 16,360.97 60 24,967.61 4000 Telephone/Internet 12,160.00 .00 12,160.00 4,135.15 .00 28,429.76 (16,269.76)234 33,634.76 4005 Cellular Phones 23,300.00 .00 23,300.00 678.52 .00 3,076.78 20,223.22 13 6,255.94 5005 Office Supplies/Postage 13,500.00 .00 13,500.00 .00 .00 3,268.51 10,231.49 24 7,084.18 5010 Replacement Supplies 17,000.00 .00 17,000.00 .00 .00 13,724.42 3,275.58 81 16,707.64 5015 Dues & Subscriptions 3,900.00 .00 3,900.00 190.00 .00 2,133.00 1,767.00 55 709.82 5020 Gas/Oil/Mileage/Carwash 61,000.00 .00 61,000.00 1,824.19 .00 60,399.83 600.17 99 61,882.34 5068 K-9 Unit .00 .00 .00 .00 .00 .00 .00 +++5,416.27 5095 Uniforms/Clothing 43,150.00 .00 43,150.00 732.87 .00 24,033.58 19,116.42 56 48,402.57 5100 Ammunition/Weapons 28,000.00 .00 28,000.00 2,234.30 .00 14,288.40 13,711.60 51 28,249.11 5115.004 Community Programs-Explorer Program 5,000.00 .00 5,000.00 219.84 .00 315.97 4,684.03 6 2,681.83 8003 Radio Maintenance 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 48.31 8035 Maintenance Contracts/Lease 15,995.00 .00 15,995.00 149.83 .00 10,711.94 5,283.06 67 4,366.03 8060 Vehicle Maintenance 46,970.00 .00 46,970.00 2,207.90 .00 39,234.47 7,735.53 84 75,795.14 8069 Bike Unit 3,500.00 .00 3,500.00 .00 .00 .00 3,500.00 0 3,384.90 8135 Contractual Services 16,000.00 .00 16,000.00 .00 .00 13,758.01 2,241.99 86 13,102.87 8265 Contractual Services-Wescom 608,000.00 .00 608,000.00 .00 .00 454,100.85 153,899.15 75 607,001.28 8267 Animal Control .00 .00 .00 .00 .00 .00 .00 +++2,780.00 Division 51 - Police Patrol Totals $8,303,140.00 $0.00 $8,303,140.00 $450,047.21 $0.00 $6,337,623.36 $1,965,516.64 76%$7,817,374.77 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 7 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 46 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 52 - Police Administration 1005 Salaries-Full Time 2,009,633.00 .00 2,009,633.00 153,204.08 .00 1,306,253.60 703,379.40 65 1,763,317.37 1800 Salaries-Overtime 134,500.00 .00 134,500.00 7,040.26 .00 118,964.01 15,535.99 88 107,875.75 2000 FICA 132,936.00 .00 132,936.00 9,673.11 .00 85,526.07 47,409.93 64 116,993.79 2001 Medicare 31,090.00 .00 31,090.00 2,262.25 .00 20,225.10 10,864.90 65 27,450.04 2010 IMRF 15,212.00 .00 15,212.00 915.72 .00 10,424.52 4,787.48 69 13,654.52 2020 Employee Insurance 358,181.00 .00 358,181.00 24,504.68 .00 260,873.12 97,307.88 73 290,238.50 2025 Deferred Comp. Contribution 55,000.00 .00 55,000.00 .00 .00 .00 55,000.00 0 53,792.80 3000 Travel/Training 32,460.00 .00 32,460.00 45.00 .00 8,620.67 23,839.33 27 11,447.91 4000 Telephone/Internet 1,110.00 .00 1,110.00 11.80 .00 360.82 749.18 33 579.01 4005 Cellular Phones 19,800.00 .00 19,800.00 1,813.73 .00 7,261.11 12,538.89 37 12,203.15 5005 Office Supplies/Postage 5,500.00 .00 5,500.00 157.91 .00 2,096.31 3,403.69 38 3,877.36 5010 Replacement Supplies 14,400.00 .00 14,400.00 .00 .00 2,438.83 11,961.17 17 4,215.15 5015 Dues & Subscriptions 5,220.00 .00 5,220.00 190.00 .00 3,185.50 2,034.50 61 3,999.47 5020 Gas/Oil/Mileage/Carwash 30,000.00 .00 30,000.00 342.42 .00 21,067.67 8,932.33 70 16,903.43 5040.002 Crime Scene/Evidence Tech Supply 12,400.00 .00 12,400.00 .00 .00 4,964.00 7,436.00 40 6,314.65 5095 Uniforms/Clothing 13,000.00 .00 13,000.00 554.46 .00 12,653.61 346.39 97 14,056.57 5115.002 Community Programs 8,500.00 .00 8,500.00 .00 .00 1,921.36 6,578.64 23 6,127.48 5115.003 Community Prog.-Alcohol/Tobacco 2,500.00 .00 2,500.00 .00 .00 157.95 2,342.05 6 103.80 5115.004 Community Programs-Explorer Program .00 .00 .00 .00 .00 .00 .00 +++(240.00) 8003 Radio Maintenance 31,000.00 .00 31,000.00 .00 .00 14,278.79 16,721.21 46 25,563.66 8035 Maintenance Contracts/Lease 4,920.00 .00 4,920.00 864.83 .00 1,957.24 2,962.76 40 2,498.02 8060 Vehicle Maintenance 31,820.00 .00 31,820.00 817.32 .00 21,381.51 10,438.49 67 27,119.67 8245 D.A.R.E. Program 5,000.00 .00 5,000.00 .00 .00 1,003.57 3,996.43 20 3,076.16 8246 Shop with a Cop 10,000.00 .00 10,000.00 .00 .00 15,817.79 (5,817.79)158 14,900.00 8250 Background Check Services 2,500.00 .00 2,500.00 209.20 .00 1,682.60 817.40 67 2,406.60 Division 52 - Police Administration Totals $2,966,682.00 $0.00 $2,966,682.00 $202,606.77 $0.00 $1,923,115.75 $1,043,566.25 65%$2,528,474.86 Division 54 - Seizure/Forfeiture 5012 Asset Seizure/Forfeiture Expense 225,000.00 .00 225,000.00 .00 .00 68,829.35 156,170.65 31 82,864.76 5012.030 Asset Seizure/Forfeture-Federal (DOJ Equitable Share).00 .00 .00 .00 .00 .00 .00 +++17,365.00 Division 54 - Seizure/Forfeiture Totals $225,000.00 $0.00 $225,000.00 $0.00 $0.00 $68,829.35 $156,170.65 31%$100,229.76 Division 55 - Police Special Activities 1005.061 Salaries-Special Activities 32,513.00 .00 32,513.00 4,192.95 .00 58,330.50 (25,817.50)179 22,764.17 2000 FICA 2,016.00 .00 2,016.00 254.62 .00 3,441.74 (1,425.74)171 1,344.41 2001 Medicare 471.00 .00 471.00 59.54 .00 827.74 (356.74)176 314.46 Division 55 - Police Special Activities Totals $35,000.00 $0.00 $35,000.00 $4,507.11 $0.00 $62,599.98 ($27,599.98)179%$24,423.04 Division 56 - Police Support Services 1005 Salaries-Full Time 984,456.00 .00 984,456.00 68,000.39 .00 656,935.63 327,520.37 67 914,636.73 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 8 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 47 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund EXPENSE Unit 05 - Police Department Division 56 - Police Support Services 1015 Salaries-Part Time 303,600.00 .00 303,600.00 15,791.39 .00 180,871.87 122,728.13 60 258,505.06 1800 Salaries-Overtime 56,000.00 .00 56,000.00 3,293.88 .00 29,832.15 26,167.85 53 40,089.08 2000 FICA 83,331.00 .00 83,331.00 5,326.14 .00 52,557.64 30,773.36 63 77,332.47 2001 Medicare 19,489.00 .00 19,489.00 1,245.62 .00 12,394.75 7,094.25 64 18,095.65 2010 IMRF 70,031.00 .00 70,031.00 3,311.53 .00 41,869.04 28,161.96 60 58,343.41 2020 Employee Insurance 147,139.00 .00 147,139.00 9,841.85 .00 120,596.04 26,542.96 82 149,287.61 2025 Deferred Comp. Contribution 40,000.00 .00 40,000.00 .00 .00 .00 40,000.00 0 25,302.34 3000 Travel/Training 10,760.00 .00 10,760.00 19.46 .00 1,911.84 8,848.16 18 5,930.75 4000 Telephone/Internet 2,200.00 .00 2,200.00 23.40 .00 715.43 1,484.57 33 1,163.71 4005 Cellular Phones 5,220.00 .00 5,220.00 437.80 .00 1,741.87 3,478.13 33 2,923.45 5005 Office Supplies/Postage 13,750.00 .00 13,750.00 411.77 .00 4,168.83 9,581.17 30 9,889.19 5010 Replacement Supplies 8,200.00 .00 8,200.00 .00 .00 3,777.30 4,422.70 46 2,707.47 5015 Dues & Subscriptions 1,650.00 .00 1,650.00 190.00 .00 729.00 921.00 44 1,632.00 5020 Gas/Oil/Mileage/Carwash 22,000.00 .00 22,000.00 6.00 .00 15,543.04 6,456.96 71 17,495.72 5095 Uniforms/Clothing 11,200.00 .00 11,200.00 102.29 .00 10,977.86 222.14 98 12,073.98 5115.001 Traffic Program 25,900.00 .00 25,900.00 .00 .00 9,747.04 16,152.96 38 20,259.43 8003 Radio Maintenance 500.00 .00 500.00 .00 .00 160.60 339.40 32 .00 8035 Maintenance Contracts/Lease 7,660.00 .00 7,660.00 299.66 .00 4,080.08 3,579.92 53 3,749.91 8060 Vehicle Maintenance 21,500.00 .00 21,500.00 2,564.18 .00 15,615.85 5,884.15 73 19,309.61 8266 Chaplaincy Program 3,000.00 .00 3,000.00 .00 .00 1,168.96 1,831.04 39 1,219.49 8267 Animal Control 9,000.00 .00 9,000.00 .00 .00 1,384.30 7,615.70 15 .00 8268 Accreditation 8,000.00 .00 8,000.00 .00 .00 4,595.00 3,405.00 57 4,595.00 Division 56 - Police Support Services Totals $1,854,586.00 $0.00 $1,854,586.00 $110,865.36 $0.00 $1,171,374.12 $683,211.88 63%$1,644,542.06 Division 91 - Capital 9115 Office Furniture & Equipment 8,000.00 .00 8,000.00 .00 .00 2,026.01 5,973.99 25 9,739.47 9120 Machinery and Equipment 100,000.00 .00 100,000.00 .00 .00 22,575.52 77,424.48 23 85,762.39 Division 91 - Capital Totals $108,000.00 $0.00 $108,000.00 $0.00 $0.00 $24,601.53 $83,398.47 23%$95,501.86 Division 93 - Contingencies 9300 Contingencies 12,000.00 .00 12,000.00 125.00 .00 7,553.58 4,446.42 63 13,361.69 Division 93 - Contingencies Totals $12,000.00 $0.00 $12,000.00 $125.00 $0.00 $7,553.58 $4,446.42 63%$13,361.69 Unit 05 - Police Department Totals $14,158,497.00 $0.00 $14,158,497.00 $807,659.61 $0.00 $10,013,905.56 $4,144,591.44 71%$12,864,105.63 Unit 07 - PEMA Division 07 - PEMA Program 3000 Travel/Training 4,000.00 .00 4,000.00 .00 .00 .00 4,000.00 0 1,482.41 4000 Telephone/Internet 7,250.00 .00 7,250.00 502.65 .00 5,055.17 2,194.83 70 6,940.09 4005 Cellular Phones 875.00 .00 875.00 108.14 .00 432.56 442.44 49 603.34 5005 Office Supplies/Postage 1,000.00 .00 1,000.00 .00 .00 1,462.14 (462.14)146 397.57 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 9 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 48 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund EXPENSE Unit 07 - PEMA Division 07 - PEMA Program 5010 Replacement Supplies 6,000.00 .00 6,000.00 .00 .00 3,893.93 2,106.07 65 4,623.79 5015 Dues & Subscriptions 4,000.00 .00 4,000.00 59.98 .00 2,069.91 1,930.09 52 3,418.86 5020 Gas/Oil/Mileage/Carwash 8,000.00 .00 8,000.00 .00 .00 1,123.58 6,876.42 14 2,166.43 5040 Supplies/Hardware 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 61.00 5040.001 Supplies/Hardware-ESDA 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 .00 5095 Uniforms/Clothing 6,000.00 .00 6,000.00 400.76 .00 3,291.15 2,708.85 55 2,041.17 5110 Emergency Operation Center 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 5115 Police Public Relations 3,000.00 .00 3,000.00 .00 .00 .00 3,000.00 0 1,050.30 5120 Disaster Plan/Exercises/NIMS 3,000.00 .00 3,000.00 .00 .00 212.88 2,787.12 7 .00 8003 Radio Maintenance 16,000.00 .00 16,000.00 .00 6,670.07 280.32 9,049.61 43 13,914.75 8020 Building Maintenance 20,000.00 .00 20,000.00 .00 .00 1,786.41 18,213.59 9 1,298.41 8035 Maintenance Contracts/Lease 1,200.00 .00 1,200.00 149.83 .00 1,198.64 1.36 100 1,797.96 8060 Vehicle Maintenance 20,000.00 .00 20,000.00 641.82 .00 6,016.35 13,983.65 30 19,265.23 8069 Bike Unit 1,500.00 .00 1,500.00 .00 .00 .00 1,500.00 0 168.00 8125 Siren Maintenance 13,000.00 .00 13,000.00 .00 .00 7,979.52 5,020.48 61 10,227.74 8135 Contractual Services 5,250.00 .00 5,250.00 .00 .00 .00 5,250.00 0 .00 8280 Cadet Program 4,500.00 .00 4,500.00 .00 .00 .00 4,500.00 0 1,759.51 8305 PEMA Search and Rescue 3,000.00 .00 3,000.00 .00 .00 1,500.40 1,499.60 50 3,900.00 9115 Office Furniture & Equipment 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 .00 9120 Machinery and Equipment 5,000.00 .00 5,000.00 .00 .00 2,299.00 2,701.00 46 .00 9300 Contingencies 3,000.00 .00 3,000.00 409.70 .00 746.91 2,253.09 25 488.13 Division 07 - PEMA Program Totals $142,575.00 $0.00 $142,575.00 $2,272.88 $6,670.07 $39,348.87 $96,556.06 32%$75,604.69 Unit 07 - PEMA Totals $142,575.00 $0.00 $142,575.00 $2,272.88 $6,670.07 $39,348.87 $96,556.06 32%$75,604.69 Unit 08 - Street Department Division 02 - Administration Program 1005 Salaries-Full Time 400,000.00 .00 400,000.00 30,410.78 .00 289,504.49 110,495.51 72 398,138.28 2000 FICA 24,800.00 .00 24,800.00 1,895.08 .00 16,985.50 7,814.50 68 25,115.91 2001 Medicare 5,800.00 .00 5,800.00 443.20 .00 4,086.05 1,713.95 70 5,992.15 2010 IMRF 44,000.00 .00 44,000.00 2,887.62 .00 31,877.03 12,122.97 72 46,129.27 2020 Employee Insurance 89,000.00 .00 89,000.00 6,822.26 .00 73,889.40 15,110.60 83 83,463.12 2025 Deferred Comp. Contribution 10,500.00 .00 10,500.00 .00 .00 .00 10,500.00 0 10,884.10 3000 Travel/Training 10,000.00 .00 10,000.00 929.13 .00 9,734.75 265.25 97 2,186.92 3015 IL Unemployment Insurance 4,500.00 .00 4,500.00 .00 .00 2,176.02 2,323.98 48 4,500.00 4000 Telephone/Internet 25,000.00 .00 25,000.00 174.81 .00 10,386.11 14,613.89 42 33,009.89 4005 Cellular Phones 8,500.00 .00 8,500.00 1,146.97 .00 4,589.12 3,910.88 54 7,747.32 5005 Office Supplies/Postage 5,000.00 .00 5,000.00 196.92 .00 2,879.44 2,120.56 58 4,134.07 5015 Dues & Subscriptions 3,000.00 .00 3,000.00 200.00 .00 1,695.65 1,304.35 57 2,898.33 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 10 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 49 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund EXPENSE Unit 08 - Street Department Division 02 - Administration Program 5020 Gas/Oil/Mileage/Carwash 300.00 .00 300.00 .00 .00 97.12 202.88 32 .00 5040 Supplies/Hardware 500.00 .00 500.00 .00 .00 .00 500.00 0 305.95 8020 Building Maintenance 20,000.00 .00 20,000.00 1,192.70 .00 17,000.02 2,999.98 85 12,559.39 8050 Legal Notices 1,000.00 .00 1,000.00 .00 .00 841.68 158.32 84 3,242.66 Division 02 - Administration Program Totals $651,900.00 $0.00 $651,900.00 $46,299.47 $0.00 $465,742.38 $186,157.62 71%$640,307.36 Division 60 - Street Maintenance Program 1005 Salaries-Full Time 875,000.00 .00 875,000.00 67,001.17 .00 634,169.81 240,830.19 72 848,798.02 1800 Salaries-Overtime 80,000.00 .00 80,000.00 16,030.88 .00 65,723.17 14,276.83 82 97,807.19 2000 FICA 59,500.00 .00 59,500.00 4,915.52 .00 41,793.55 17,706.45 70 58,970.64 2001 Medicare 14,000.00 .00 14,000.00 1,149.61 .00 9,774.28 4,225.72 70 13,791.35 2010 IMRF 105,100.00 .00 105,100.00 7,481.07 .00 76,047.03 29,052.97 72 106,750.60 2020 Employee Insurance 226,000.00 .00 226,000.00 16,279.46 .00 168,976.22 57,023.78 75 192,658.31 2025 Deferred Comp. Contribution 25,000.00 .00 25,000.00 .00 .00 .00 25,000.00 0 21,024.90 4015 Electricity/Gas 210,000.00 .00 210,000.00 26,356.33 .00 61,988.72 148,011.28 30 195,754.28 5020 Gas/Oil/Mileage/Carwash 65,000.00 .00 65,000.00 15,294.99 .00 40,283.51 24,716.49 62 48,039.63 5040 Supplies/Hardware 15,000.00 .00 15,000.00 724.43 .00 6,700.47 8,299.53 45 14,616.48 5040.003 Supplies/Hardware-Salt Purchase 325,000.00 .00 325,000.00 42,984.87 6,575.55 51,883.59 266,540.86 18 227,596.30 5055 Street Sign Maintenance 65,000.00 .00 65,000.00 1,708.58 .00 15,340.77 49,659.23 24 51,998.32 5060 Aggregate Materials 4,000.00 .00 4,000.00 10.33 .00 3,267.55 732.45 82 4,829.37 5095 Uniforms/Clothing 10,000.00 .00 10,000.00 829.67 .00 7,967.27 2,032.73 80 11,972.20 8003 Radio Maintenance 5,000.00 .00 5,000.00 .00 .00 781.30 4,218.70 16 3,224.60 8060 Vehicle Maintenance 35,000.00 .00 35,000.00 1,320.21 .00 18,821.88 16,178.12 54 22,249.14 8130 Street Light Maintenance 125,000.00 .00 125,000.00 2,957.12 .00 78,177.70 46,822.30 63 137,640.58 8131 Street Maintenance 165,000.00 .00 165,000.00 .00 .00 94,769.74 70,230.26 57 157,742.16 8132 Storm Sewer Improvements 20,000.00 .00 20,000.00 795.00 .00 9,365.23 10,634.77 47 15,272.36 8135 Contractual Services 190,000.00 .00 190,000.00 11,062.06 .00 140,286.58 49,713.42 74 159,676.36 8135.004 Snow Removal 475,000.00 .00 475,000.00 .00 .00 142.95 474,857.05 0 758,252.49 8150 Sidewalk Maintenance 5,000.00 .00 5,000.00 .00 .00 3,185.27 1,814.73 64 5,219.96 8160 Equipment Maintenance 100,000.00 .00 100,000.00 7,602.88 .00 70,088.03 29,911.97 70 134,510.30 Division 60 - Street Maintenance Program Totals $3,198,600.00 $0.00 $3,198,600.00 $224,504.18 $6,575.55 $1,599,534.62 $1,592,489.83 50%$3,288,395.54 Division 62 - Forestry Program 1005 Salaries-Full Time 85,000.00 .00 85,000.00 6,448.04 .00 61,854.49 23,145.51 73 85,741.40 1800 Salaries-Overtime 8,000.00 .00 8,000.00 2,348.42 .00 7,869.73 130.27 98 13,066.80 2000 FICA 6,000.00 .00 6,000.00 532.88 .00 4,219.03 1,780.97 70 6,212.59 2001 Medicare 1,400.00 .00 1,400.00 124.63 .00 986.69 413.31 70 1,452.91 2010 IMRF 10,500.00 .00 10,500.00 804.01 .00 7,604.20 2,895.80 72 11,148.51 2020 Employee Insurance 15,000.00 .00 15,000.00 1,097.78 .00 11,960.12 3,039.88 80 13,226.20 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 11 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 50 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund EXPENSE Unit 08 - Street Department Division 62 - Forestry Program 2025 Deferred Comp. Contribution 3,500.00 .00 3,500.00 .00 .00 .00 3,500.00 0 2,275.31 5040 Supplies/Hardware 10,000.00 .00 10,000.00 664.29 .00 3,964.97 6,035.03 40 11,070.90 5095 Uniforms/Clothing 500.00 .00 500.00 .00 .00 .00 500.00 0 .00 8135 Contractual Services 25,000.00 .00 25,000.00 .00 .00 6,825.00 18,175.00 27 23,505.60 8135.002 Tree Removal 30,000.00 .00 30,000.00 .00 .00 29,350.00 650.00 98 44,200.00 Division 62 - Forestry Program Totals $194,900.00 $0.00 $194,900.00 $12,020.05 $0.00 $134,634.23 $60,265.77 69%$211,900.22 Division 63 - Vehicle Maintenance Program 1005 Salaries-Full Time 195,000.00 .00 195,000.00 10,221.79 .00 135,832.02 59,167.98 70 191,800.49 1800 Salaries-Overtime 8,000.00 .00 8,000.00 181.52 .00 4,625.20 3,374.80 58 9,939.19 2000 FICA 12,600.00 .00 12,600.00 632.34 .00 8,578.48 4,021.52 68 12,577.04 2001 Medicare 3,000.00 .00 3,000.00 147.88 .00 2,006.23 993.77 67 2,941.45 2010 IMRF 22,500.00 .00 22,500.00 950.87 .00 15,445.85 7,054.15 69 22,794.91 2020 Employee Insurance 35,000.00 .00 35,000.00 1,639.22 .00 22,034.57 12,965.43 63 33,556.04 2025 Deferred Comp. Contribution 5,000.00 .00 5,000.00 .00 .00 .00 5,000.00 0 5,724.44 Division 63 - Vehicle Maintenance Program Totals $281,100.00 $0.00 $281,100.00 $13,773.62 $0.00 $188,522.35 $92,577.65 67%$279,333.56 Unit 08 - Street Department Totals $4,326,500.00 $0.00 $4,326,500.00 $296,597.32 $6,575.55 $2,388,433.58 $1,931,490.87 55%$4,419,936.68 Unit 09 - Community Development Division 20 - Planning Program 1005 Salaries-Full Time 389,000.00 .00 389,000.00 25,004.48 .00 279,808.75 109,191.25 72 338,140.45 1045 Salaries-Commissioner 6,500.00 .00 6,500.00 670.00 .00 3,840.00 2,660.00 59 4,465.00 1800 Salaries-Overtime 2,000.00 .00 2,000.00 .00 .00 114.02 1,885.98 6 .00 2000 FICA 25,000.00 .00 25,000.00 1,550.68 .00 17,228.51 7,771.49 69 21,780.54 2001 Medicare 5,800.00 .00 5,800.00 362.66 .00 4,029.28 1,770.72 69 5,093.86 2010 IMRF 43,000.00 .00 43,000.00 2,285.42 .00 30,774.66 12,225.34 72 38,774.51 2020 Employee Insurance 93,000.00 .00 93,000.00 5,719.10 .00 69,997.87 23,002.13 75 75,575.42 2025 Deferred Comp. Contribution 8,500.00 .00 8,500.00 .00 .00 .00 8,500.00 0 6,596.55 3000 Travel/Training 8,000.00 .00 8,000.00 35.00 .00 2,604.00 5,396.00 33 1,245.00 3015 IL Unemployment Insurance 1,000.00 .00 1,000.00 .00 .00 483.32 516.68 48 1,000.00 4000 Telephone/Internet 3,000.00 .00 3,000.00 37.31 .00 1,030.17 1,969.83 34 1,340.94 4005 Cellular Phones 1,500.00 .00 1,500.00 169.28 .00 678.14 821.86 45 1,031.52 5005 Office Supplies/Postage 12,000.00 .00 12,000.00 90.24 .00 7,136.97 4,863.03 59 3,794.76 5015 Dues & Subscriptions 5,000.00 .00 5,000.00 327.88 .00 2,254.71 2,745.29 45 4,587.55 5020 Gas/Oil/Mileage/Carwash 750.00 .00 750.00 .00 .00 40.00 710.00 5 37.29 8035 Maintenance Contracts/Lease 2,000.00 .00 2,000.00 149.83 .00 1,240.97 759.03 62 1,820.32 8050 Legal Notices 10,000.00 .00 10,000.00 .00 .00 5,489.06 4,510.94 55 10,514.30 8060 Vehicle Maintenance 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 8065 Legal Fees 4,000.00 .00 4,000.00 .00 .00 1,372.25 2,627.75 34 2,026.00 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 12 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 51 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund EXPENSE Unit 09 - Community Development Division 20 - Planning Program 8097 Special Projects and Programs 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 62,528.00 8135 Contractual Services 30,000.00 .00 30,000.00 .00 .00 4,936.75 25,063.25 16 4,386.75 8225 Engineering Fees 10,000.00 .00 10,000.00 .00 .00 14,543.75 (4,543.75)145 18,787.65 Division 20 - Planning Program Totals $676,050.00 $0.00 $676,050.00 $36,401.88 $0.00 $447,603.18 $228,446.82 66%$603,526.41 Division 21 - Building Program 1005 Salaries-Full Time 655,000.00 .00 655,000.00 56,147.93 .00 507,950.94 147,049.06 78 669,669.46 1800 Salaries-Overtime 3,000.00 .00 3,000.00 .00 .00 2,270.16 729.84 76 .00 2000 FICA 41,000.00 .00 41,000.00 3,377.67 .00 30,607.78 10,392.22 75 41,795.81 2001 Medicare 9,800.00 .00 9,800.00 789.95 .00 7,158.26 2,641.74 73 9,774.84 2010 IMRF 73,000.00 .00 73,000.00 5,131.93 .00 55,731.51 17,268.49 76 75,589.73 2020 Employee Insurance 178,000.00 .00 178,000.00 12,380.79 .00 147,036.79 30,963.21 83 164,902.05 2025 Deferred Comp. Contribution 15,000.00 .00 15,000.00 .00 .00 .00 15,000.00 0 16,396.77 3000 Travel/Training 12,000.00 .00 12,000.00 (733.20).00 5,229.81 6,770.19 44 3,542.75 3015 IL Unemployment Insurance 1,500.00 .00 1,500.00 .00 .00 803.93 696.07 54 1,500.00 4000 Telephone/Internet 1,000.00 .00 1,000.00 12.42 .00 343.37 656.63 34 449.56 4005 Cellular Phones 4,500.00 .00 4,500.00 696.14 .00 2,784.62 1,715.38 62 4,049.91 5005 Office Supplies/Postage 10,000.00 .00 10,000.00 240.84 .00 4,949.50 5,050.50 49 8,191.63 5015 Dues & Subscriptions 3,000.00 .00 3,000.00 .00 .00 271.40 2,728.60 9 340.00 5020 Gas/Oil/Mileage/Carwash 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 5095 Uniforms/Clothing 1,000.00 .00 1,000.00 .00 .00 700.50 299.50 70 898.29 8045 Recording Fees 3,000.00 .00 3,000.00 .00 .00 1,804.00 1,196.00 60 2,612.00 8060 Vehicle Maintenance 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 8135 Contractual Services 10,000.00 .00 10,000.00 258.89 .00 3,497.75 6,502.25 35 3,170.18 Division 21 - Building Program Totals $1,022,800.00 $0.00 $1,022,800.00 $78,303.36 $0.00 $771,140.32 $251,659.68 75%$1,002,882.98 Unit 09 - Community Development Totals $1,698,850.00 $0.00 $1,698,850.00 $114,705.24 $0.00 $1,218,743.50 $480,106.50 72%$1,606,409.39 Unit 50 - Police Commission Division 02 - Administration Program 1015 Salaries-Part Time 6,500.00 .00 6,500.00 167.29 .00 2,932.20 3,567.80 45 1,110.53 2000 FICA 341.00 .00 341.00 10.37 .00 181.80 159.20 53 57.20 2001 Medicare 80.00 .00 80.00 2.43 .00 42.54 37.46 53 13.37 3000 Travel/Training 1,000.00 .00 1,000.00 .00 .00 1,541.69 (541.69)154 114.00 5005 Office Supplies/Postage 2,000.00 .00 2,000.00 .00 .00 115.70 1,884.30 6 1,773.80 5015 Dues & Subscriptions 600.00 .00 600.00 .00 .00 375.00 225.00 62 699.00 8065 Legal Fees 1,000.00 .00 1,000.00 .00 .00 .00 1,000.00 0 .00 8115 Police Testing/Hiring 20,000.00 .00 20,000.00 .00 .00 12,340.94 7,659.06 62 4,665.00 Division 02 - Administration Program Totals $31,521.00 $0.00 $31,521.00 $180.09 $0.00 $17,529.87 $13,991.13 56%$8,432.90 Unit 50 - Police Commission Totals $31,521.00 $0.00 $31,521.00 $180.09 $0.00 $17,529.87 $13,991.13 56%$8,432.90 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 13 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 52 Adopted Budget Amended Current Month YTD YTD Budget - YTD % Used/ Account Account Description Budget Amendments Budget Transactions Encumbrances Transactions Transactions Rec'd Prior Year Total Fund 01 - General Fund EXPENSE TOTALS $29,384,988.00 $0.00 $29,384,988.00 $1,536,022.46 $87,910.61 $18,881,733.58 $10,415,343.81 65%$30,665,074.80 Fund 01 - General Fund Totals REVENUE TOTALS 29,384,988.00 .00 29,384,988.00 2,260,030.47 .00 27,608,495.66 1,776,492.34 94%31,584,688.88 EXPENSE TOTALS 29,384,988.00 .00 29,384,988.00 1,536,022.46 87,910.61 18,881,733.58 10,415,343.81 65%30,665,074.80 Fund 01 - General Fund Totals $0.00 $0.00 $0.00 $724,008.01 ($87,910.61)$8,726,762.08 ($8,638,851.47)$919,614.08 Grand Totals REVENUE TOTALS 29,384,988.00 .00 29,384,988.00 2,260,030.47 .00 27,608,495.66 1,776,492.34 94%31,584,688.88 EXPENSE TOTALS 29,384,988.00 .00 29,384,988.00 1,536,022.46 87,910.61 18,881,733.58 10,415,343.81 65%30,665,074.80 Grand Totals $0.00 $0.00 $0.00 $724,008.01 ($87,910.61)$8,726,762.08 ($8,638,851.47)$919,614.08 Run by Traci Pleckham on 02/24/2022 02:47:49 PM Page 14 of 14 Budget Performance Report Fiscal Year to Date 01/31/22 Exclude Rollup Account 53 MEMORANDUM To: Mayor Argoudelis and Trustees From: Traci Pleckham – Assistant Village Administrator/Management Services Director CC: Joshua Blakemore – Village Administrator Date: February 24, 2022 Re: Financial Policies annual review Attached please find the Village of Plainfield Financial Policies for review. The financial policies establish the basic framework for sound fiscal management of the Village and is used to frame major policy initiatives for the Village’s continued financial stability. The Financial Policies are reviewed annually as part of the budget process. Last year, the section regarding the Village’s reporting methods in the Investment Policy was updated (Exhibit A) along with adding language based on the State of Illinois Sustainable Investing Act. Staff has no recommended modifications to the Financial Policies for this year. 54 Financial Policies (Adopted 2/1/10; Last Amended 3/4/19) FINANCIAL POLICIES General The Village of Plainfield has an important responsibility to carefully account for public funds, to manage municipal finances wisely, and to plan and provide for the adequate funding of services desired by the public and as required by laws, rules, or regulations, including the provision and maintenance of public facilities and improvements. The financial goals and policies set forth in this document are intended to establish guidelines for the continued financial strength and stability of the Village of Plainfield. Financial Goals Financial goals are broad, fairly timeless statements of the financial position the Village seeks to attain. The financial goals for the Village of Plainfield are: • To provide full value for each tax dollar by delivering quality services efficiently and on a cost-effective basis. • To preserve our quality of life by providing and maintaining adequate financial resources necessary to sustain a sufficient level of municipal services, and to respond to changes in the economy, the priorities of governmental and non-governmental organizations, and other changes that may affect our financial well-being. • To maintain a strong credit rating in the financial community. Financial Policies Financial policies support the financial goals. They are general statements that guide decision- making in specific situations, to ensure that a decision will contribute to the attainment of the financial goals. Federal and state laws, rules, and regulations, our Village Code of Ordinances, and generally accepted accounting principles promulgated by the Governmental Accounting Standards Board (“GASB”) and the Government Finance Officers Association of the United States and Canada (“GFOA”) govern our financial policies and processes. Budget Policies Sound financial practice and the desire to maintain a strong credit rating dictate that our budgets be balanced, constantly monitored, and responsive to changes in service demands. With these concepts in mind, the Village of Plainfield has adopted the following budget policy statements: • The Village will adopt and maintain a balanced budget in which expenditures will not be allowed to exceed reasonably estimated revenues and other available funds at the same time maintaining recommended fund balances. • Fund balance should not be considered a source of funds for operating expenditures. Excess unreserved and undesignated fund balance may be appropriated as part of the adopted budget to fund capital or emergency expenditures. Page 1 55 Financial Policies (Adopted 2/1/10; Last Amended 3/4/19) FINANCIAL POLICIES • As part of the annual budget review process, the Village will project fund revenues and expenditures for a minimum of two years beyond the budget year and compare the projected balances to the fund balance policy. This will allow the Village to identify potential problems early enough to correct them. • The Village will maintain a budgetary control system to ensure adherence to the budget and will prepare monthly reports comparing actual revenues and expenditures to budgeted amounts. • Twice annually, the Village Administrator will provide the Village Board with trend analysis/projections of revenues and expenditures. Revenue Policies Revenues determine the capacity of a local government to provide services. Under ideal conditions, revenues would grow at a rate equal to or greater than expenditures. To ensure that our revenues are balanced and capable of supporting our desired levels of services, the Village of Plainfield has adopted the following revenue policy statements. • The Village endeavors to develop and maintain a diversified and stable revenue base to shelter it from short-term fluctuations in any one revenue source. • The Village will estimate annual revenues on an objective, reasonable, and conservative basis. Most revenues will be estimated based on a historical trend analysis. Major revenues will receive a more in-depth analysis. • Each year and whenever appropriate, existing revenues will be re-examined and possible new sources of revenues will be explored to ensure that we are maximizing our revenue potential. • The Village will strive to be informed and aware of all grants and other aid that may be available to us. All potential grants and other aid shall be carefully examined for matching requirements (both dollar and level-of-effort) and restrictive covenants, to ensure that our participation in such grants will be beneficial and cost-effective. • All charges for services, fees, licenses, permits, etc. will be reviewed regularly to insure that rates are maintained at a level that is related to the cost of providing the services and are competitive with others providing similar services in the area. • Water and Sewer Funds will be self-supporting. Page 2 56 Financial Policies (Adopted 2/1/10; Last Amended 3/4/19) FINANCIAL POLICIES • The Village will establish user charges and set fees for services for its enterprise funds at a level that fully supports both the direct and indirect costs of the activity. Indirect costs include the recognition of annualized depreciation of capital assets. Cash flow requirements to adequately defray bond retirement and capital outlay will become a primary determinant in the development of user charges. • Connection fees for water and sewer services shall be reviewed regularly to assure that fees reflect the cost of providing services to new developments. • One-time revenues that are not required by law or agreement to be expended for a particular purpose will only be used to fund one-time capital or emergency expenditures. One-time revenues will not be used to support operating expenditures, except in emergency situations. Cash Management Policies • An investment policy has been adopted by the Village Board, which provides guidelines for the prudent investment of the temporary idle cash and outlines the policies for maximizing the efficiency of the cash management system. The ultimate goal is to enhance the economic status of the Village while protecting its pooled cash. The current Investment Policy is attached as Exhibit A. • The cash management system is designed to accurately monitor and forecast expenditures and revenues, thus enabling the Village to invest funds to the fullest extent possible. The Village attempts to match funds to projected disbursements. • Except for cash in certain restricted and special funds, the Village of Plainfield will consolidate cash balances from all funds to maximize investment earnings. Investment income will be allocated to the various funds based on their respective participation and in accordance with generally accepted accounting principles. • Criteria for selecting investments and the order of priority are: safety, liquidity, and yield. Expenditure Policies Expenditures are a rough measure of a local government’s service output. While many expenses can be easily controlled, emergencies, unfunded mandates, and unanticipated service demands may strain our ability to maintain a balanced budget. To ensure the proper control of expenditures and provide for a quick and effective response to adverse financial situations, the Village of Plainfield has adopted the following expenditure statements: • The Village will maintain a level of expenditures that will provide for the public well-being and safety of the residents and businesses of the community. Page 3 57 Financial Policies (Adopted 2/1/10; Last Amended 3/4/19) FINANCIAL POLICIES • The Village will pay all current operating expenditures with current operating revenues. • Expenditures and purchase commitments will follow the Village’s approved Purchasing Authority Policy. The current Purchasing Authority Policy is attached as Exhibit B. • Encumbrances represent commitments related to unperformed contracts for goods or services, and will be recorded when incurred. Fund Balance Fund balances are established to protect against the need to reduce service levels or raise taxes and fees due to temporary revenue shortfalls or unpredicted one-time expenditures. In addition, in accordance with GASB Statement 54, the Village must establish fund balance classifications that inform the financial statement user as to the extent to which the Village must observe constraints imposed upon use of the resources that are reported by the governmental funds. More detailed fund balance financial reporting and the increased disclosures will aid the user of the financial statements in understanding the availability of resources for various governmental purposes. The fund balance will be composed of five categories: 1) Nonspendable, 2) Restricted, 3) Committed, 4) Assigned, or 5) Unassigned. Definitions Governmental Funds – are used to account for all or most of the Village’s general activities, including the collection and disbursement of earmarked monies (special revenue funds), the acquisition or construction of general capital assets (capital projects funds) and the servicing of general long-term debt (debt service funds). The General Fund is used to account for all activities of the Village not accounted for in some other fund. Fund Balance – the difference between assets and liabilities in a Governmental Fund. Nonspendable Fund Balance – the portion of a Governmental Fund’s fund balance that is not available to be spent, either short-term or long-term, in either form (e.g., inventories, prepaid items, land held for resale) or through legal restrictions (e.g., endowments). Restricted Fund Balance - the portion of a Governmental Fund’s fund balance that is subject to external enforceable legal restrictions (e.g., grantor, contributors and property tax levies). Committed Fund Balance - the portion of a Governmental Fund’s fund balance with self- imposed constraints or limitations that have been placed by formal action at the highest level of decision making. Assigned Fund Balance - the portion of a Governmental Fund’s fund balance to denote an intended use of resources, or for all remaining fund balance in non-General funds not categorized above. Page 4 58 Financial Policies (Adopted 2/1/10; Last Amended 3/4/19) FINANCIAL POLICIES Unassigned Fund Balance - available expendable financial resources in a governmental fund that are not the object of tentative management plan (i.e. designations). (Only in the General Fund, unless negative) Fund Balance Policies • The Village will spend the most restricted dollars before less restricted, in the following order: a. Nonspendable (if funds become spendable) b. Restricted c. Committed d. Assigned e. Unassigned • The Management Services Director will determine if a portion of fund balance should be assigned, consistent with intentions of the Village Board. • The Village will strive to maintain the unassigned fund balance of the General Fund at a level at least equal to 25% of the total General Fund annual operational expenditures. • If the General Fund unassigned fund balance falls below the minimum, a plan will be developed to return to the minimum balance within a reasonable period of time. • General Fund unassigned fund balance in excess of 40% may be transferred to the Capital Improvement Fund. • The Village will strive to maintain the unrestricted net position of the Enterprise Fund (Water and Sewer) at a level at least equal to 25% of the total Water and Sewer Fund annual operational expenditures. • If the Enterprise Fund unrestricted net position falls below the minimum, rates may be adjusted so as to gradually return to the minimum within a reasonable period of time. If the position exceeds 40%, the overage may be used to offset rate increases, or transferred to the Village’s Capital Replacement Fund, or a combination thereof. • The Water and Sewer Capital Replacement Fund is a reserve fund for future capital investments in the Village’s infrastructure system. Funding amounts for the Capital Replacement Fund is largely driven by the annual depreciation amount of the Enterprise Fund infrastructure system. Page 5 59 Financial Policies (Adopted 2/1/10; Last Amended 3/4/19) FINANCIAL POLICIES Capital Improvement Policies • The Village shall maintain a Five-Year Capital Improvement Program and capital improvements will be made in accordance with that plan. The program shall be updated annually. • The corresponding year of the Capital Improvement Program will be incorporated into the annual operating budget as the Capital Budget. • As part of the development of the Capital Improvement Program, the condition of Village infrastructure will be evaluated to appropriately prioritize and schedule maintenance and replacement. • Each capital project will be evaluated for its impact on current and future operating budgets. Debt Policies Debt is an effective way to finance capital improvements or to even out short-term revenue flows. Properly managed debt preserves our credit rating, provides flexibility in current and future operating budgets, and provides us with long-term assets that maintain or improve our quality of life. To provide for the appropriate issuance and responsible use of debt, the Village of Plainfield has adopted the following debt management policy statements: • The Village will confine long-term borrowing to capital improvements or one- time obligations that cannot be financed from current revenues or reserves. Debt will not be issued to fund ongoing operating expenses. • Capital projects financed through the issuance of bonds shall be financed for a period not to exceed the expected useful life of the improvement. • Before issuing debt, the Village shall assess financial alternatives to include, whenever feasible, categorical grants, revolving loans or other state/federal aid. • The Village shall strive to attain the highest possible credit rating for each debt issue. • The Village shall take all practical precautions to avoid any financial decision which negatively impact current credit ratings on existing or future debt issues. • The Village will maintain good communications with bond rating agencies about its financial condition. The Village will follow a policy of full disclosure on every financial report and bond prospectus. • The Village will attempt to keep the average maturity of General Obligation Bonds at or below 20 years. Page 6 60 Financial Policies (Adopted 2/1/10; Last Amended 3/4/19) FINANCIAL POLICIES • The annual operating budgets of all funds will be maintained so as to ensure the full and timely repayment of debt principal and interest due that year. • The Village’s annual audit and official statements will reflect the Village’s commitment to full and open disclosure concerning our debt. • As a home rule unit of government in the State of Illinois, the Village has no statutory debt limit. Capital Asset Policies This policy is to establish the principles related to the accounting treatment of the Village’s capital assets. Capital assets include land, improvements to land, buildings, building improvements, vehicles, machinery, equipment, works of art and historical treasures, infrastructure, construction in progress and all other tangible and intangible assets that are used in operations and have initial useful lives extending beyond a single reporting period. Infrastructure assets are long-lived capital assets that normally are stationary in nature and can be preserved for a significantly greater number of years than most capital assets. Examples of infrastructure assets include roads, bridges, drainage systems, water and sewer systems. Land and land improvements are inexhaustible capital assets and will not be depreciated. Construction in progress will not be depreciated until construction is complete. All other capital assets will be depreciated over their estimated useful lives, using the straight-line method of depreciation. In no event shall the useful life of an asset be less than the period of probable usefulness established for debt purposes as outlined by GASB34. A capitalization threshold is the cost established by the Management Services Director that must be met or exceeded if an asset is to be recorded and depreciated as a capital asset. The capitalization threshold is based on the cost of a single asset. Assets that do not meet the capitalization threshold will be recorded as expenditures or expenses. For purposes of property control (insurance, security, etc.), the Management Services Director and/or department heads may develop and maintain the appropriate record keeping system(s) to account for assets which do not meet the capitalization threshold. Capital assets that meet the minimum capitalization threshold will be recorded at historical cost. The cost of a capital asset includes capitalized interest and ancillary charges necessary to place the asset into its intended location and condition for use. Ancillary charges include costs that are directly attributable to asset acquisition, such as freight and transportation charges, site preparation costs, and professional fees. Donated capital assets will be recorded at their estimated fair value at the time of acquisition, including any ancillary charges. Estimated historical cost may be used in those cases where the actual historical cost is not readily available. Estimated historical cost will be calculated using the current replacement cost of a similar asset and deflating this cost to the acquisition year (or estimated acquisition year) using a price-level index approved by the Management Services Director. Page 7 61 Financial Policies (Adopted 2/1/10; Last Amended 3/4/19) FINANCIAL POLICIES Capital assets associated with the operation of enterprise funds will be recorded in those funds. Capital assets associated with general government operations, with the exception of infrastructure assets, will be recorded in the appropriate internal service fund(s). Infrastructure assets will not be recorded in a governmental or proprietary fund, but a record keeping system necessary to allow for the accounting, auditing, and reporting of such assets, including depreciation will be maintained. Estimated useful life means the estimated number of years that an asset will be able to be used for the purpose for which it was purchased. The Village of Plainfield will capitalize all assets that have a useful life greater than one year and meet the following dollar thresholds: Asset Category Threshold Est. Useful Life Land & Improvements Any Inexhaustible Building & Improvements $20,000 5 – 50 Machinery & Equipment $5,000 3 – 20 Infrastructure $50,000 15 – 50 With respect to asset improvements (such as street resurfacing, roof replacement, etc), costs over the appropriate asset category threshold will be capitalized if: • The estimated life of the asset is extended by more than 25%, or • The cost results in an increase in the capacity of the asset, or • Significantly changes the asset, or • In the case of streets and road – if the work impacts the “base” structure Accounting, Auditing & Financial Reporting Policies 1. The Village will adhere to a policy of full and open disclosure of all financial operations. 2. The Village will comply with prevailing federal, state and local statutes and regulations. 3. The Village will maintain a high standard of accounting practices in conformance with generally accepted accounting principles (GAAP) for governmental entities as promulgated by the Governmental Accounting Standards Board (GASB) and will adopt all applicable accounting and financial reporting standards established from time to time by GASB. 4. The Village will produce a Comprehensive Annual Financial Report (CAFR) in accordance with generally accepted accounting principles as outlined by the Governmental Accounting Standards Board (GASB). Page 8 62 Financial Policies (Adopted 2/1/10; Last Amended 3/4/19) FINANCIAL POLICIES 5. An independent firm of certified public accountants will perform an annual audit according to Generally Accepted Auditing Standards (GAAS). Their opinions will be incorporated in the Village’s Comprehensive Annual Financial Report. 6. As an additional independent confirmation of the quality of the Village’s financial reporting, the Village will submit its Comprehensive Annual Financial Report (CAFR) to the Government Finance Officers Association (GFOA) for the purpose of obtaining the Certificate of Achievement for Excellence in Financial Reporting. 7. The Village will promote full disclosures in its financial statements in accordance with, but not limited to, the requirements of the Governmental Accounting Standards Board (GASB). Page 9 63 EXHIBIT A VOP Investment Policy (1/28/10); Last Revised 4/5/21 VILLAGE OF PLAINFIELD INVESTMENT POLICY I. SCOPE This policy applies to the investment of all funds, excluding the investment of employees' retirement funds. Proceeds from certain bond issues, as well as separate foundation or endowment assets, are covered by a separate policy. 1. Pooling of Funds Except for cash in certain restricted and special funds, the Village of Plainfield will consolidate cash and reserve balances from all funds to maximize investment earnings and to increase efficiencies with regard to investment pricing, safekeeping and administration. Investment income will be allocated to the various funds based on their respective participation and in accordance with generally accepted accounting principles. II. GENERAL OBJECTIVES The primary objectives, in priority order, of investment activities shall be safety, liquidity, and yield: 1. Safety Safety of principal is the foremost objective of the investment program. Investments shall be undertaken in a manner that seeks to ensure the preservation of capital in the overall portfolio. The objective will be to mitigate credit risk and interest rate risk. a. Credit Risk The Village of Plainfield will minimize credit risk, which is the risk of loss due to the failure of the security issuer or backer, by: • Limiting investments to the types of securities listed in this Investment Policy. • Pre-qualifying the financial institutions, broker/dealers, intermediaries, and advisers with which the Village of Plainfield will do business. • Diversifying the investment portfolio so that the impact of potential losses from any one type of security or from any one individual issuer will be minimized. b. Interest Rate Risk The Village of Plainfield will minimize interest rate risk, which is the risk that the market value of securities in the portfolio will fall due to changes in market interest rates, by: • Structuring the investment portfolio so that securities mature to meet cash requirements for ongoing operations, thereby avoiding the need to sell securities on the open market prior to maturity. • Investing operating funds primarily in shorter-term securities, money market mutual funds, or similar investment pools and limiting the average maturity of the portfolio in accordance with this policy. 2. Liquidity The investment portfolio shall remain sufficiently liquid to meet all operating requirements that may be reasonably anticipated. This is accomplished by structuring the portfolio so that securities mature concurrent with cash needs to meet anticipated demands (static liquidity). Furthermore, since all possible cash demands cannot be anticipated, the portfolio should consist largely of securities with Page 10 64 EXHIBIT A VOP Investment Policy (1/28/10); Last Revised 4/5/21 active secondary or resale markets (dynamic liquidity). Alternatively, a portion of the portfolio may be placed in money market mutual funds or local government investment pools which offer same-day liquidity for short-term funds. 3. Yield The investment portfolio shall be designed with the objective of attaining a market rate of return throughout budgetary and economic cycles, taking into account the investment risk constraints and liquidity needs. Return on investment is of secondary importance compared to the safety and liquidity objectives described above. The core of investments are limited to relatively low risk securities in anticipation of earning a fair return relative to the risk being assumed. Securities shall generally be held until maturity with the following exceptions: • A security with declining credit may be sold early to minimize loss of principal. • A security swap would improve the quality, yield, or target duration in the portfolio. • Liquidity needs of the portfolio require that the security be sold. III. STANDARDS OF CARE 1. Prudence The standard of prudence to be used by investment officials shall be the "prudent person" standard and shall be applied in the context of managing an overall portfolio. Investment officers acting in accordance with written procedures and this investment policy and exercising due diligence shall be relieved of personal responsibility for an individual security's credit risk or market price changes, provided deviations from expectations are reported in a timely fashion and the liquidity and the sale of securities are carried out in accordance with the terms of this policy. The "prudent person" standard states that, "Investments shall be made with judgment and care, under circumstances then prevailing, which persons of prudence, discretion and intelligence exercise in the management of their own affairs, not for speculation, but for investment, considering the probable safety of their capital as well as the probable income to be derived." 2. Ethics and Conflicts of Interest Officers and employees involved in the investment process shall refrain from personal business activity that could conflict with the proper execution and management of the investment program, or that could impair their ability to make impartial decisions. Employees and investment officials shall disclose any material interests in financial institutions with which they conduct business. They shall further disclose any personal financial/investment positions that could be related to the performance of the investment portfolio. Employees and officers shall refrain from undertaking personal investment transactions with the same individual with whom business is conducted on behalf of the Village of Plainfield. 3. Delegation of Authority Authority to manage the investment program is granted to the Management Services Director, hereinafter referred to as investment officer. Responsibility for the operation of the investment program is hereby delegated to the investment officer, who shall act in accordance with established written procedures and internal controls for the operation of the investment program consistent with this investment policy. Procedures should include references to: safekeeping, delivery vs. payment, investment accounting, repurchase agreements, wire transfer agreements, and collateral/depository agreements. No person may engage in an investment transaction except as provided under the terms of this policy and the procedures established by the investment officer. The investment officer shall be Page 11 65 EXHIBIT A VOP Investment Policy (1/28/10); Last Revised 4/5/21 responsible for all transactions undertaken and shall establish a system of controls to regulate the activities of subordinate officials. 4. Sustainability When evaluating potential investments, the investment officer shall consider material, relevant, and decision-useful sustainability factors, within the bounds of financial and fiduciary prudence. Such factors include, but are not limited to: (1) corporate governance and leadership factors, (2) environmental factors, (3) social capital factors, (4) human capital factors, and (5) business model and innovation factors, as provided under the Illinois Sustainable Investing Act, 30 ILCS 238/. IV. AUTHORIZED FINANCIAL INSTITUTIONS, DEPOSITORIES, AND BROKER/DEALERS 1. Authorized Financial Institutions, Depositories, and Broker/Dealers A list will be maintained of financial institutions and depositories authorized to provide investment services. In addition, a list will be maintained of approved security broker/dealers selected by creditworthiness (e.g., a minimum capital requirement of $10,000,000 and at least five years of operation). These may include "primary" dealers or regional dealers that qualify under Securities and Exchange Commission (SEC) Rule 15C3-1 (uniform net capital rule). All financial institutions and broker/dealers who desire to become qualified for investment transactions must supply the following as appropriate: • Audited financial statements • Proof of National Association of Securities Dealers (NASD) certification (not applicable to Certificate of Deposit counterparties) • Proof of state registration • Proof of Federal Deposit Insurance Corp (FDIC) membership • Certification of having read and understood and agreeing to comply with the Village’s investment policy. An annual review of the financial condition and registration of all qualified financial institutions and broker/dealers will be conducted by the investment officer V. SAFEKEEPING AND CUSTODY 1. Delivery vs. Payment All trades of marketable securities will be executed by delivery vs. payment (DVP) to ensure that securities are deposited in an eligible financial institution prior to the release of funds. 2. Safekeeping Securities will be held by an independent third-party custodian as evidenced by safekeeping receipts. 3. Internal Controls The investment officer is responsible for establishing and maintaining an internal control structure designed to ensure that the assets of the Village of Plainfield are protected from loss, theft or misuse. The internal control structure shall be designed to provide reasonable assurance that these objectives are met. The concept of reasonable assurance recognizes that (1) the cost of a control should not exceed the benefits likely to be derived and (2) the valuation of costs and benefits requires estimates and judgments by management. Page 12 66 EXHIBIT A VOP Investment Policy (1/28/10); Last Revised 4/5/21 The internal controls structure shall address the following points: • Control of collusion • Separation of transaction authority from accounting and recordkeeping • Custodial safekeeping • Avoidance of physical delivery securities • Clear delegation of authority to subordinate staff members • Written confirmation of transactions for investments and wire transfers • Development of a wire transfer agreement with the lead bank and third-party custodian Accordingly, the investment officer shall establish a process for an annual independent review by an external auditor to assure compliance with policies and procedures or alternatively, compliance should be assured through the Village of Plainfield annual independent audit. VI. SUITABLE AND AUTHORIZED INVESTMENTS 1. Investment Types Consistent with the GFOA Policy Statement on State and Local Laws Concerning Investment Practices, the following investments will be permitted by this policy and are those defined by state and local law where applicable: • U.S. Treasury obligations which carry the full faith and credit guarantee of the United States government and are considered to be the most secure instruments available; • U.S. government agency and instrumentality obligations that have a liquid market with a readily determinable market value; • Certificates of deposit and other evidences of deposit at financial institutions, • Bankers' acceptances; • Commercial paper, rated in the highest tier (e.g., A-1, P-1, F-1, or D-1 or higher) by a nationally recognized rating agency; • Investment-grade obligations of state, provincial and local governments and public authorities; • Repurchase agreements whose underlying purchased securities consist of the aforementioned instruments; • Money market mutual funds regulated by the Securities and Exchange Commission and whose portfolios consist only of dollar-denominated securities; and • Local government investment pools either state-administered or developed through joint powers statutes and other intergovernmental agreement legislation. Direct investment in derivatives shall be prohibited. 2. Collateralization Where allowed by state law and in accordance with the GFOA Recommended Practices on the Collateralization of Public Deposits, full collateralization will be required on all demand deposit accounts, including checking accounts and non-negotiable certificates of deposit. 3. Repurchase Agreements Repurchase agreements shall be consistent with GFOA Recommended Practices on Repurchase Agreements. VII. INVESTMENT PARAMETERS 1. Diversification The investments shall be diversified by: Page 13 67 EXHIBIT A VOP Investment Policy (1/28/10); Last Revised 4/5/21 • limiting investments to avoid overconcentration in securities from a specific issuer or business sector (excluding U.S. Treasury securities), • limiting investment in securities that have higher credit risks, • investing in securities with varying maturities, and • continuously investing a portion of the portfolio in readily available funds such as local government investment pools (LGIPs), money market funds or overnight repurchase agreements to ensure that appropriate liquidity is maintained in order to meet ongoing obligations. 2. Maximum Maturities To the extent possible, the Village of Plainfield shall attempt to match its investments with anticipated cash flow requirements. Unless matched to a specific cash flow, the Village of Plainfield will not directly invest in securities maturing more than three (3) years from the date of purchase. Reserve funds and other funds with longer-term investment horizons may be invested in securities exceeding three (3) years if the maturities of such investments are made to coincide as nearly as practicable with the expected use of funds. Because of inherent difficulties in accurately forecasting cash flow requirements, a portion of the portfolio should be continuously invested in readily available funds such as local government investment pools, money market funds, or overnight repurchase agreements to ensure that appropriate liquidity is maintained to meet ongoing obligations. 3. Competitive Bids The investment officer shall obtain competitive bids from at least two brokers or financial institutions on all purchases of investment instruments purchased on the secondary market. VIII. REPORTING 1. Methods • Quarterly - The investment officer shall ensure that the portfolio is reviewed to determine its general performance and effectiveness in meeting the objectives. The investment officer shall prepare a cash and investment report at least quarterly to the Village Board. • Annually - The Comprehensive Annual Financial Report of the Village shall include all investment information and disclosures required by the Government Accounting Standards Board. 2. Performance Standards The investment portfolio will be managed in accordance with the parameters specified within this policy. The portfolio should obtain a market average rate of return during a market/economic environment of stable interest rates. A series of appropriate benchmarks shall be established against which portfolio performance shall be compared on a regular basis. The benchmarks shall be reflective of the actual securities being purchased and risks undertaken, and the benchmarks shall have a similar weighted average maturity as the portfolio. 3. Marking to Market The market value of the portfolio shall be calculated at least quarterly and a statement of the market value of the portfolio shall be issued at least quarterly. This will ensure that review of the investment portfolio, in terms of value and price volatility, has been performed consistent with the GFOA Page 14 68 EXHIBIT A VOP Investment Policy (1/28/10); Last Revised 4/5/21 Recommended Practice on "Mark-to-Market Practices for State and Local Government Investment Portfolios and Investment Pools." In defining market value, considerations should be given to the GASB Statement 31 pronouncement. IX. INVESTMENT POLICY AMENDMENTS The Village Plainfield’s investment policy shall be amended by ordinance of the Village Board of Trustees. This policy shall be reviewed on an annual basis by the Management Services Director and any modifications thereto must be approved by the Village Board of Trustees. Page 15 69 EXHIBIT B Effective 4/21/09 – Revised 1/28/10; 4/7/14; 5/21/18 VILLAGE OF PLAINFIELD PURCHASING AUTHORITY POLICY PURPOSE The purpose of this policy is to provide general guidelines for purchasing activities and to expedite processing of Village purchases in a timely, efficient manner while assuring adequate internal controls and purchasing authority. This policy is designed to be a fluid document and will be modified from time to time to conform to changes in legislation, technology and actual practice. The Village Administrator, or his/her designee, shall be the final authority with regards to enforcement of any of the provisions of this policy. Failure to follow the procedures outlined in this policy may lead to disciplinary action in accordance with the provisions of the Village of Plainfield Personnel Manual. The Management Services Director will establish written procedures consistent with this purchasing policy and may amend the written procedures in a manner not inconsistent with this policy, local ordinances, or state statutes. CODE OF ETHICS All Village personnel engaged in purchasing and related activities shall conduct business dealings in a manner above reproach in every respect. Transactions relating to expenditure of public funds require the highest degree of public trust to protect the interests of the Village and the residents and businesses of Plainfield. Village employees shall strive to: • Ensure that public money is spent efficiently and effectively and in accordance with statutes, regulations and Village policies. • Maintain confidentiality at all times. • Not accept gifts or favors from current or potential suppliers, which might compromise the integrity of their purchasing function. • Specify generic descriptions of goods wherever possible in lieu of brand names when compiling specifications. • Never allow purchase orders for identical goods or services to be split or variations to Village Board approvals to be made in order to circumvent established policy. • Purchase without favor or prejudice. • Ensure that all potential suppliers are provided with adequate and identical information upon which to base their offer or quotation and that any subsequent information is made available to all bidders. • Establish and maintain procedures to ensure that fair and equal consideration is given to each offer or quotation received and selection is based upon the lowest total cost compliant bid. • Offer a prompt and courteous response to all inquiries from potential or existing suppliers. Page 16 70 EXHIBIT B Effective 4/21/09 – Revised 1/28/10; 4/7/14; 5/21/18 CONFLICT OF INTEREST Except as may be disclosed to and permitted by the Village Board, it shall be a breach of ethical standards for any employee to participate directly or indirectly in the purchasing process when the employee knows that: • The employee is contemporaneously employed by a bidder, vendor or contractor involved in the procurement transaction; or • The employee, the employee's partner, or any member of the employee's immediate family holds a position with a bidder, offeror or contractor such as an officer, director, trustee, partner or the like, or is employed in a capacity involving personal and substantial participation in the procurement transaction, or owns or controls an interest in the company; or • The employee, the employee's partner, or any member of the employee's immediate family has a financial interest arising from the procurement transaction; or • The employee, the employee's partner, or any member of the employee's immediate family is negotiating, or has an arrangement concerning, prospective employment with a bidder, vendor or contractor. • The employee’s immediate family shall be defined as a spouse, children, parents, brothers and sisters and any other person living in the same household as the employee. PURCHASING PROCEDURES The Village’s policy is to obtain the most cost effective price available for purchases through competitive pricing. When quotes are required, pricing should be obtained from at least three vendors. When applicable, quotes from state purchasing programs or other similar forms of governmental pooled purchasing programs are encouraged. Purchases submitted without the required quotes require explanation of why quotes were not obtained (e.g. sole source, emergency, standardized vendor, etc.). The following guidelines will determine the process and approval levels required for purchases**: 1. Purchases up to $1,000.00 – Verbal quotes are sufficient. If the nature of the purchase is repetitive (i.e. monthly), pricing does not need to be obtained every time, but should be reviewed periodically to ensure that vendors are competitive. Purchases must be approved by the appropriate Department Head. 2. Purchases from $1,000.01 - $3,500.00 – Verbal quotes are required. Purchases must be approved by the appropriate Department Head. 3. Purchases from $3,500.01 - $7,500.00 – Authorization required by purchase order which must be approved by the Management Services Director. Written price quotes are required. 4. Purchases from $7,500.01 - $10,000.00 – Authorization required by purchase order which must be approved by the Village Administrator. Written price quotes are required. 5. Purchases of $10,000.01 or more – Must be approved by the Board of Trustees. The requestor must prepare a purchase order and attempt to obtain at least three (3) written price quotes. Purchases over $25,000 in most cases must be competitively bid in accordance with State law. Page 17 71 EXHIBIT B Effective 4/21/09 – Revised 1/28/10; 4/7/14; 5/21/18 For purposes of this policy, Department Heads are defined as: Building Official, Management Services Director, Police Chief, Public Works Director, Planning Director and IT Director. In the Department Heads’ absence, the Department Head may designate a supervisor to approve purchases if necessary. The Management Services Department must be notified of this temporary designation along with the expiration date of this designation. Exceptions to the pricing requirements include single source vendors, repetitive purchases as discussed in Item 1, requirements by State statute or local ordinance, emergency purchases, contractual obligations, professional associations, or any other unusual purchasing situation. **The Plainfield Police Department authorizes purchasing through General Order Number 07- 215 as part of CALEA Standards, which is consistent with this Purchasing Authority Policy** INVOICE PROCESSING 1. Approved invoices are forwarded to the Management Services Department for inclusion in the Village’s accounts payable process. Invoices should be submitted on a regular basis as received. The Management Services Department returns any incomplete invoices to their respective Departments for completion. Invoices are due to the Management Services Department by the Thursday following a Board Meeting for inclusion in the subsequent Board Meeting’s Accounts Payable List. 2. All properly approved invoices are compiled by the Management Services Department on a Accounts Payable List for Board approval. The Accounts Payable List is included in the agenda packet for the Board Meeting. 3. Checks are then processed and mailed by the Management Services Department. PURCHASE ORDERS The policy intends to define the use of purchase orders. Departments will be required to file purchase orders only if one of the following criteria is met: 1. Purchase is over $3,500. 2. Vendor requires a purchase order in order to deliver the good or service and invoice for the item at a later date. 3. A significant time period is anticipated between the ordering of an item and the payment of such item. Examples include capital projects which take place over several months and items ordered well in advance of delivery (i.e. vehicle). In order to expedite purchasing throughout the year, blanket purchase orders may also be prepared on a fiscal year basis if authorized by the Village Administrator. Blanket purchase orders are for vendors that require a purchase order amount for small items or per unit purchases. Page 18 72 EXHIBIT B Effective 4/21/09 – Revised 1/28/10; 4/7/14; 5/21/18 EMERGENCY PURCHASES The Village Administrator shall authorize any emergency purchases or rental of equipment or services to effectively protect the public health and safety, protect property, and provide emergency assistance as necessary. The Village Administrator shall notify promptly with the Board of Trustees information detailing such emergency and the necessity of such action, together with an itemized account of all expenditures. Emergency expenditures would be handled through the first Accounts Payable List process immediately following the emergency expenditure. VILLAGE CREDIT CARD/STORE CREDIT Village-issued credit cards and store credit (or invoicing) accounts shall use such credit only for goods or services for the official business of the Village. Any items purchased and/or benefits produced from the use of the credit card or store credit charges will be the property of the Village of Plainfield. The credit card or store credit charges may not be used for personal or non- village use. Use of the Village-issued credit card and charges on store credit accounts are subject to all requirements of this Purchasing Authority Policy and is not to be used for means other than allowed by this policy. MANUAL CHECKS Occasionally, a need will arise for a check to be prepared manually outside of the normal Accounts Payable List process. These manual checks are needed when a check has to be remitted prior to the next Board Meeting Accounts Payable List process. The Village’s policy is to keep requests for manual checks at a minimum. Common items for which manual checks can be prepared include 1) Payroll related checks; 2) Late notification of billings; 3) Unavoidable cash on delivery transactions; 4) Monthly utilities such as electric, telephone and gas: 5) Board approved contractual obligations requiring check; 6) Emergency purchase, and; 7) Situations which will significantly impair the Village financially or operationally if a check is not prepared. The Management Services Department will process manual checks no more frequently than weekly. The Management Services Director may authorize a non-emergency related check between weekly cycles in situations where immediate issuance of the check is needed to prevent an adverse impact on the Village. All manual checks are to be approved by the Department Head and Management Services Director. The Village Administrator may also approve manual checks. Departments will have to demonstrate that a manual check fits one of the above criteria. Once a check is prepared, reporting to the Board will take place at the following Village Board Meeting available via the Accounts Payable List process. Page 19 73 EXHIBIT B Effective 4/21/09 – Revised 1/28/10; 4/7/14; 5/21/18 PETTY CASH The Village Board has approved two petty cash funds within the Village as follows: Management Services-$200; Police-$500. Responsibility for custody and safeguarding of each fund and for all fund disbursements rests with the appropriate Department Head. Petty cash is to be used to reimburse employees for Village expenses which the employee incurs up front and for small purchases which are handled most efficiently by utilizing petty cash. Employees should seek approval for petty cash reimbursement before expenditures are made. The following restrictions apply: 1. The maximum amount for Management Services petty cash reimbursement is $50. The maximum amount for Police petty cash reimbursement is $100. 2. Employee must prepare a petty cash voucher which is approved by the Department Head. 3. Receipts documenting the expense must be attached to the petty cash form. Disbursements from petty cash funds cannot be approved without receipts. In the case of mileage reimbursements, an approved travel expense report is sufficient in lieu of receipts. If an employee cannot provide a receipt. Alternative verification approved by the Department Head must be attached. Each department is responsible for balancing and reconciling its own petty cash fund. Departments replenish petty cash funds by submitting a request to the Management Services Department. The request is then processed through the Accounts Payable List procedure. The request for replenishment must be supported by petty cash vouchers/receipts which agree to the amount of the request. The fund must be at least 50% depleted for the Management Services Department to process a check to replenish. Page 20 74