HomeMy Public PortalAbout01-08-2024 Special Meeting & COW Agenda and PacketSpecial Meeting and Committee of the Whole Workshop
Monday, January 08, 2024
7:00 PM
24401 W. Lockport Street
Plainfield, IL 60544
IN THE BOARDROOM
Agenda
A.CALL TO ORDER, ROLL CALL, PLEDGE
B.PUBLIC COMMENTS (3-5 Minutes)
C.BUSINESS MEETING
1.APPROVAL OF THE AGENDA
2.CONSENT AGENDA
2a.Resolution Number _____, Abating the 2023 Tax Levies for the General Obligation
Refunding Bonds, Series 2014.
2023 Abatement Memo and Resolutions
2b.Resolution Number _____, Abating the 2023 Tax Levies for the General Obligation
Refunding Bonds, Series 2021.
2c.Authorize the Village Administrator to execute the annual maintenance agreement from
Tyler Technologies for the New World ERP software in the amount of $82,137.30.
nwERP Annual Maintenance Staff Report
2d.Authorize the purchase of the 9 Dell Rugged Laptops from Dell Technologies in the
amount of $19,630.60.
Rugged Laptop Replacement Staff Report
2e.Authorize the Village Administrator to execute the annual renewal with PACE Scheduler
in the amount of $13,900.00.
PACE Scheduler Staff Report
2f.Ordinance No. ____, an ordinance authorizing enforcement of the Illinois Vehicle Code
on Private Streets and Roads in the Lakelands Subdivision and authorizing an agreement
for that purpose.
Lakelands Vehicle Code Enforcement Staff Report, Ordinance, and Agreement
1
Special Meeting and Committee of the Whole Workshop Page - 2
ADJOURN
COMMITTEE OF THE WHOLE WORKSHOP
A.CALL TO ORDER, ROLL CALL
B.APPROVAL OF THE MINUTES
B1.Approval of the Minutes of the Committee of the Whole Workshop and Special Meeting
held on December 11, 2023.
12-11-2023 COW Minutes
12-11-2023 Special Village Board Minutes
C.PRESIDENTIAL COMMENTS
D.TRUSTEES COMMENTS
E.PUBLIC COMMENTS (3-5 Minutes)
F.WORKSHOP
F1.2024-2025 DRAFT FISCAL YEAR BUDGET
Staff will present the 2024-2025 Draft Fiscal Year Budget for the Water and Sewer
Divisions.
Water Sewer Draft FY25 Budget
1-4-24 Water Sewer Budget Performance Report
REMINDERS -
•January 10 Coffee with the Mayor – 9:00 a.m. at the Village Hall
•January 11 Historic Preservation Commission - 7:00 p.m.
•January 15 Village Offices Closed
•January 16 Plan Commission - 7:00 p.m.
•January 22 Next Committee of the Whole Workshop – 7:00 p.m.
2
MEMORANDUM
January 2, 2024
To: Mayor Argoudelis and the Board of Trustees
From: Traci Pleckham – Assistant Village Administrator/Management Services Director
CC: Joshua Blakemore – Village Administrator
Subject: 2023 Tax Levy Abatement Resolutions
Enclosed please find resolutions to abate (eliminate) the 2023 property tax levy for the Village’s
Series 2014 and Series 2021 outstanding bond issues.
The Village has historically abated the property tax levies for its outstanding bonds each year.
By abating the levies, the debt amounts are not passed on to the Village residents’ property tax
bills. The total abatement amount for the 2023 tax levies is $2,007,540. In the event these
resolutions are not approved, the County Clerk’s Offices would extend the property tax levies
for each of the bond series listed (as required per the bond issuance documents), and this
additional extension on average would increase the Village portion of a resident’s property tax
bill by approximately 20%.
Principal and interest payments for these debt issues will be included in the Village’s Fiscal Year
2025 Debt Service and Capital Fund budgets. The resolutions are consistent with prior Board
direction and policy, and Staff is recommending approval.
Recommended Actions:
1. A motion to adopt Resolution Number , Abating the 2023 Tax Levies for the
General Obligation Refunding Bonds, Series 2014.
2. A motion to adopt Resolution Number , Abating the 2023 Tax Levies for the
General Obligation Refunding Bonds, Series 2021.
3
RESOLUTION NO.
RESOLUTION ABATING THE 2023 TAX LEVY FOR THE GENERAL
OBLIGATION REFUNDING BONDS, SERIES 2014, OF THE VILLAGE OF PLAINFIELD, ILLINOIS.
WHEREAS, there was ordained by the President and Board of Trustees of Plainfield, Illinois on June 2, 2014 Ordinance No. 3158 entitled “Ordinance Authorizing the Issuance of Not to Exceed $10,525,000 General Obligation Refunding Bonds, Series 2014 of the Village of
Plainfield, Illinois”; and
WHEREAS, pursuant to the Ordinance, the Village has heretofore issued $9,665,000 General Obligation Refunding Bonds Series 2014, dated July 16, 2014 (the "Bonds"), and has filed in the offices of the County Clerks of Will and Kendall Counties, Illinois, a Bond Order for the levy of taxes to pay the Bonds; and
WHEREAS, the Village Treasurer has certified to the Board of Trustees that there are sufficient funds on hand to meet the requirements of the 2014 Debt Service Fund described in Section 15 of Ordinance No. 3158 and accompanying Bond Order to pay the principal of and interest on the 2014 Bonds authorized by said Ordinance as the same becomes due during the
period for which the 2023 tax levy was made; and
WHEREAS, it is in the best interest of the Village of Plainfield that the taxes levied for tax levy year 2023 under said Ordinance No. 3158 and in the accompanying Bond Order be abated in full.
NOW, THEREFORE, BE IT RESOLVED BY THE PRESIDENT AND BOARD OF TRUSTEES OF THE
VILLAGE OF PLAINFIELD, WILL AND KENDALL COUNTIES, ILLINOIS, AS FOLLOWS:
Section 1. That the preamble hereto is herewith reinstated as though fully reprinted herein.
Section 2. That the $1,202,500 tax levy for the 2014 Bond Series provided in Ordinance No. 3158 and accompanying Bond Order be abated in full.
Section 3. That the Series 2014 Revenue Source is sufficient to pay the principal and interest on the 2014 Bonds when due during the period for which the taxes are abated hereunder and is herewith pledged to said payments of principal and interest on the 2014 Bonds in compliance with Section 12(D) of Ordinance No. 3158, as it applies to the 2014 Debt Service Fund.
Section 4. That immediately upon this Resolution becoming effective, a copy thereof certified by the Village Clerk, which certificate shall recite that this Resolution has been duly adopted, shall be filed with the County Clerks of Will and Kendall Counties, Illinois, who are hereby directed to abate said taxes for the 2023 tax levy year and not to extend the same for
collection.
4
-2-
Section 5. The Village Clerk is hereby authorized and directed to publish this Resolution in pamphlet form and to file copies thereof for public inspection in her office.
This Resolution shall become effective in the manner provided by law.
ADOPTED this day of January, 2024 by a roll call vote as follows:
AYES:
NAYS:
____________________________________
Village Clerk
Approved: January , 2024
____________________________________
Village President
Attest:
___________________________________
Village Clerk (Seal)
5
RESOLUTION NO.
RESOLUTION ABATING THE 2023 TAX LEVY FOR THE GENERAL
OBLIGATION REFUNDING BONDS, SERIES 2021, OF THE VILLAGE OF PLAINFIELD, ILLINOIS.
WHEREAS, there was ordained by the President and Board of Trustees of Plainfield, Illinois on August 2, 2021 Ordinance No. 3519 entitled “Ordinance Authorizing the Issuance of Not to Exceed $2,475,000 General Obligation Refunding Bonds, Series 2021 of the Village of
Plainfield, Illinois”; and
WHEREAS, pursuant to the Ordinance, the Village has heretofore issued $2,385,000 General Obligation Refunding Bonds Series 2021, dated September 21, 2021 (the "Bonds"), and has filed in the offices of the County Clerks of Will and Kendall Counties, Illinois, a Bond Order for the levy of taxes to pay the Bonds; and
WHEREAS, the Village Treasurer has certified to the Board of Trustees that there are sufficient funds on hand to meet the requirements of the 2021 Debt Service Fund described in Section 15 of Ordinance No. 3519 and accompanying Bond Order to pay the principal of and interest on the 2021 Bonds authorized by said Ordinance as the same becomes due during the
period for which the 2023 tax levy was made; and
WHEREAS, it is in the best interest of the Village of Plainfield that the taxes levied for tax levy year 2023 under said Ordinance No. 3519 and in the accompanying Bond Order be abated in full.
NOW, THEREFORE, BE IT RESOLVED BY THE PRESIDENT AND BOARD OF TRUSTEES OF THE
VILLAGE OF PLAINFIELD, WILL AND KENDALL COUNTIES, ILLINOIS, AS FOLLOWS:
Section 1. That the preamble hereto is herewith reinstated as though fully reprinted herein.
Section 2. That the $805,040 tax levy for the 2021 Bond Series provided in Ordinance No. 3519 and accompanying Bond Order be abated in full.
Section 3. That the Series 2021 Revenue Source is sufficient to pay the principal and interest on the 2021 Bonds when due during the period for which the taxes are abated hereunder and is herewith pledged to said payments of principal and interest on the 2021 Bonds in compliance with Section 12(D) of Ordinance No. 3519, as it applies to the 2021 Debt Service Fund.
Section 4. That immediately upon this Resolution becoming effective, a copy thereof certified by the Village Clerk, which certificate shall recite that this Resolution has been duly adopted, shall be filed with the County Clerks of Will and Kendall Counties, Illinois, who are hereby directed to abate said taxes for the 2023 tax levy year and not to extend the same for
collection.
6
-2-
Section 5. The Village Clerk is hereby authorized and directed to publish this Resolution in pamphlet form and to file copies thereof for public inspection in her office.
This Resolution shall become effective in the manner provided by law.
ADOPTED this day of January, 2024 by a roll call vote as follows:
AYES:
NAYS:
____________________________________
Village Clerk
Approved: January , 2024
____________________________________
Village President
Attest:
___________________________________
Village Clerk (Seal)
7
MEMORANDUM
To: Mayor Argoudelis and Trustees
From: James Kastrantas, Information Technology Director
CC: Traci Pleckham, Assistant Village Administrator/Management Services Director
Date: 1/3/2024
Re: Tyler New World ERP annual software maintenance
Background Findings
The Village utilizes the New World ERP system from Tyler Technologies for accounting, payroll, human resources,
utility billing, permits, inspections and code enforcement. In order to stay up-to-date with new features and
functionality within the New World ERP product, an annual software maintenance, support and licensing fee is
charged. Continuing the maintenance and support is vital to ensure a high level of responsiveness in nearly all
areas of the Village’s operations. With the transition to OpenGov staff will be ending support for the modules
related to building and permitting once operations cease for those functions in New World. Any remaining credits
will be applied to our next years 2024-25 annual renewal.
Policy Considerations
According to Section to 2-76 (5) of the Village Code of Ordinances, the Village Administrator shall make a
recommendation to the President and Board of Trustees on purchases over the $10,000 statutory limit. The
Board has the right to accept or reject any or all proposals.
Financial Considerations
The cost for the annual software maintenance of the New World ERP system is $82,137.30. Funding is budgeted in
the Information Technology budget.
Recommendation
It is our recommendation that the Village Board authorize the annual maintenance agreement from Tyler
Technologies for the New World ERP software.
8
9
10
MEMORANDUM
To: Mayor Argoudelis and Trustees
From: James Kastrantas, Information Technology Director
Date: 1/3/2024
Re: Squad Car Rugged Laptop Refresh
Background Findings
The Village has over 40 squad cars with Dell Rugged Laptops for patrol. Most of our rugged laptops were
purchased with a grant and are all the same age, 5 years old. Based on the heavy use these laptops receive in the
field staff would recommend working towards a replacement cycle of 9 to 10 a year. This would ensure that the
devices are covered under warranty and function properly under their current use. Staff did try to extend the
warranty of the current Dell Rugged Laptops beyond 5 years for the remaining devices but was not allowed to
because the model has been discontinued.
Policy Considerations
According to Section 2-43 (6) of the Village Code of Ordinances, the Village Administrator shall make a
recommendation to the President and Board of Trustees on purchases over the $10,000 statutory limit. The
Board has the right to accept or reject any or all proposals.
Financial Considerations
Staff had reached out to 3 vendors of which only 2 responded. The cost of the Dell Rugged Laptops refresh is
currently in the Police capital fund. The cost for the proposed replacement for 9 Dell Rugged Laptops is
$19,630.60. This would be for 2 cellular and 7 non cellular devices.
The cost per computer per vendor was
Recommendation
It is my recommendation that the Village Board direct the Village administrator to authorize the purchase of the 9
Dell Rugged Laptops from Dell Technologies in the amount of $19,630.60.
11
A quote for your consideration
Based on your business needs, we put the following quote together to help with your
purchase decision. Below is a detailed summary of the quote we’ve created to help you with
your purchase decision.
To proceed with this quote, you may respond to this email, order online through your
Premier page, or, if you do not have Premier, use this Quote to Order.
Quote No.3000169277354.1
Total $19,630.60
Customer #14187860
Quoted On Nov. 29, 2023
Expires by Dec. 29, 2023
Contract Name Standard Governing Terms
in Supplier's Quote
Contract Code C000000006563
Deal ID 26350527
Sales Rep Daniel Miller
Phone (800) 456-3355, 6180802
Email Daniel_Miller3@Dell.com
Billing To ACCOUNTS PAYABLE
VILLAGE OF PLAINFIELD
24401 W LOCKPORT ST
PLAINFIELD, IL 60544-2313
Message from your Sales Rep
Please contact your Dell sales representative if you have any questions or when you are ready to place an order.
Thank you for shopping with Dell!
Regards,
Daniel Miller
Product Unit Price Quantity Subtotal
Dell Latitude 5430 Rugged $2,280.08 2 $4,560.16
Dell Latitude 5430 Rugged $2,152.92 7 $15,070.44
Page 1
Dell Marketing LP. U.S. only. Dell Marketing LP. is located at One Dell Way, Mail Stop 8129, Round Rock, TX 78682
12
Subtotal:
Shipping:
Environmental Fee:
Non-Taxable Amount:
Taxable Amount:
Estimated Tax:
Total:
$19,630.60
$0.00
$0.00
$19,630.60
$0.00
$0.00
$19,630.60
Page 2
Dell Marketing LP. U.S. only. Dell Marketing LP. is located at One Dell Way, Mail Stop 8129, Round Rock, TX 78682
13
Unit Price Quantity Subtotal
Dell Latitude 5430 Rugged
Estimated delivery if purchased today:
Dec. 20, 2023
Contract # C000000006563
$2,280.08 2 $4,560.16
Description SKU Unit Price Quantity Subtotal
Dell Latitude 5430 Rugged 210-BCFW -2 -
Intel Core Processor i7-1185G7, (QC, 3.0 to 4.3 GHz, 28W, vPro)379-BERR -2 -
Windows 11 Pro, English, French, Spanish 619-AQLP -2 -
No Microsoft Office License Included 658-BCSB -2 -
Intel® Core™ vPro i7-1185G7 with Iris Xe Graphics 338-CCRL -2 -
ME Lockout MOD - Manageability 631-ADED -2 -
16GB, 2x8GB, 3200 MHz DDR4 Non-ECC 370-AGTH -2 -
256GB M.2 PCIe NVMe Class 35 Solid State Drive 400-BMSB -2 -
14" Touch 1100 nits WVA FHD (1920 x 1080) 100% sRGB Anti-
Glare, Outdoor Viewable 391-BGGI -2 -
English US RGB Backlit Sealed Internal keyboard 583-BILF -2 -
Intel AX210 WLAN Driver 555-BHCC -2 -
Intel AX210 Wireless Card with Bluetooth 555-BHCH -2 -
4G CAT16 - Qualcomm(R) Snapdragon(TM) X20 LTE (DW5821e),
eSIM, Verizon, NMEA GPS port 556-BDVJ -2 -
Hot surface warning label 389-ECGC -2 -
Primary 3 Cell 53.5 Whr ExpressCharge Capable Battery 451-BCWC -2 -
65W Type-C EPEAT Adapter 492-BCXP -2 -
No Fingerprint, no Smartcard reader 346-BHQK -2 -
E4 Power Cord 1M for US 537-BBBL -2 -
Setup and Features Guide 340-CXCE -2 -
Dummy Airbay Cover 325-BEIV -2 -
ENERGY STAR Qualified 387-BBPC -2 -
Custom Configuration 817-BBBB -2 -
Dell Applications for Windows 11 658-BFIP -2 -
Mix Ship, Notebook, 5430 Rugged 340-CYJC -2 -
EPEAT 2018 Registered (Silver)379-BDTO -2 -
No mic / no camera; Touch; WWAN/WLAN antennae; Pogo vehicle
docking and RF passthrough 319-BBHU -2 -
No Option Included 340-ACQQ -2 -
Additional USB-A rear port 590-TFHR -2 -
Additional TBT/Type-C port 325-BEJZ -2 -
Rigid handle 750-ADPK -2 -
ProSupport: Next Business Day Onsite, 2 YearS Extended 808-6783 -2 -
ProSupport: Next Business Day Onsite, 3 Years 808-6784 -2 -
Dell Limited Hardware Warranty Initial Year 808-6805 -2 -
ProSupport: 7X24 Technical Support, 5 Years 808-6813 -2 -
Dell Limited Hardware Warranty Extended Year(s)975-3461 -2 -
Page 3
Dell Marketing LP. U.S. only. Dell Marketing LP. is located at One Dell Way, Mail Stop 8129, Round Rock, TX 78682
14
Thank you choosing Dell ProSupport. For tech support, visit
//support.dell.com/ProSupport 989-3449 -2 -
Subtotal:
Shipping:
Environmental Fee:
Estimated Tax:
Total:
$4,560.16
$0.00
$0.00
$0.00
$4,560.16
Unit Price Quantity Subtotal
Dell Latitude 5430 Rugged
Estimated delivery if purchased today:
Dec. 20, 2023
Contract # C000000006563
$2,152.92 7 $15,070.44
Description SKU Unit Price Quantity Subtotal
Dell Latitude 5430 Rugged 210-BCFW -7 -
Intel Core Processor i7-1185G7, (QC, 3.0 to 4.3 GHz, 28W, vPro)379-BERR -7 -
Windows 11 Pro, English, French, Spanish 619-AQLP -7 -
No Microsoft Office License Included 658-BCSB -7 -
Intel® Core™ vPro i7-1185G7 with Iris Xe Graphics 338-CCRL -7 -
ME Lockout MOD - Manageability 631-ADED -7 -
16GB, 2x8GB, 3200 MHz DDR4 Non-ECC 370-AGTH -7 -
256GB M.2 PCIe NVMe Class 35 Solid State Drive 400-BMSB -7 -
14" Touch 1100 nits WVA FHD (1920 x 1080) 100% sRGB Anti-
Glare, Outdoor Viewable 391-BGGI -7 -
English US RGB Backlit Sealed Internal keyboard 583-BILF -7 -
Intel AX210 WLAN Driver 555-BHCC -7 -
Intel AX210 Wireless Card with Bluetooth 555-BHCH -7 -
Hot surface warning label 389-ECGC -7 -
Primary 3 Cell 53.5 Whr ExpressCharge Capable Battery 451-BCWC -7 -
65W Type-C EPEAT Adapter 492-BCXP -7 -
No Fingerprint, no Smartcard reader 346-BHQK -7 -
E4 Power Cord 1M for US 537-BBBL -7 -
Setup and Features Guide 340-CXCE -7 -
Dummy Airbay Cover 325-BEIV -7 -
ENERGY STAR Qualified 387-BBPC -7 -
Custom Configuration 817-BBBB -7 -
Dell Applications for Windows 11 658-BFIP -7 -
Mix Ship, Notebook, 5430 Rugged 340-CYJC -7 -
EPEAT 2018 Registered (Silver)379-BDTO -7 -
Microphone +RGB HD camera; Touch; WLAN/WWAN antennae;
Pogo vehicle docking and RF passthrough 319-BBHV -7 -
No Option Included 340-ACQQ -7 -
Additional USB-A rear port 590-TFHR -7 -
Additional TBT/Type-C port 325-BEJZ -7 -
Rigid handle 750-ADPK -7 -
Page 4
Dell Marketing LP. U.S. only. Dell Marketing LP. is located at One Dell Way, Mail Stop 8129, Round Rock, TX 78682
15
ProSupport: Next Business Day Onsite, 2 YearS Extended 808-6783 -7 -
ProSupport: Next Business Day Onsite, 3 Years 808-6784 -7 -
Dell Limited Hardware Warranty Initial Year 808-6805 -7 -
ProSupport: 7X24 Technical Support, 5 Years 808-6813 -7 -
Dell Limited Hardware Warranty Extended Year(s)975-3461 -7 -
Thank you choosing Dell ProSupport. For tech support, visit
//support.dell.com/ProSupport 989-3449 -7 -
Subtotal:
Shipping:
Environmental Fee:
Estimated Tax:
Total:
$15,070.44
$0.00
$0.00
$0.00
$15,070.44
Page 5
Dell Marketing LP. U.S. only. Dell Marketing LP. is located at One Dell Way, Mail Stop 8129, Round Rock, TX 78682
16
Important Notes
Terms of Sale
This Quote will, if Customer issues a purchase order for the quoted items that is accepted by Supplier, constitute a contract between the
entity issuing this Quote (“Supplier”) and the entity to whom this Quote was issued (“Customer”). Unless otherwise stated herein, pricing is
valid for thirty days from the date of this Quote. All product, pricing and other information is based on the latest information available and is
subject to change. Supplier reserves the right to cancel this Quote and Customer purchase orders arising from pricing errors. Taxes and/or
freight charges listed on this Quote are only estimates. The final amounts shall be stated on the relevant invoice. Additional freight charges
will be applied if Customer requests expedited shipping. Please indicate any tax exemption status on your purchase order and send your tax
exemption certificate to Tax_Department@dell.com or ARSalesTax@emc.com, as applicable.
Governing Terms: This Quote is subject to: (a) a separate written agreement between Customer or Customer’s affiliate and Supplier or a
Supplier´s affiliate to the extent that it expressly applies to the products and/or services in this Quote or, to the extent there is no such
agreement, to the applicable set of Dell’s Terms of Sale (available at www.dell.com/terms or www.dell.com/oemterms), or for cloud/as-a-
Service offerings, the applicable cloud terms of service (identified on the Offer Specific Terms referenced below); and (b) the terms
referenced herein (collectively, the “Governing Terms”). Different Governing Terms may apply to different products and services on this
Quote. The Governing Terms apply to the exclusion of all terms and conditions incorporated in or referred to in any documentation submitted
by Customer to Supplier.
Supplier Software Licenses and Services Descriptions: Customer’s use of any Supplier software is subject to the license terms
accompanying the software, or in the absence of accompanying terms, the applicable terms posted on www.Dell.com/eula. Descriptions and
terms for Supplier-branded standard services are stated at www.dell.com/servicecontracts/global or for certain infrastructure products at
www.dellemc.com/en-us/customer-services/product-warranty-and-service-descriptions.htm.
Offer-Specific, Third Party and Program Specific Terms: Customer’s use of third-party software is subject to the license terms that
accompany the software. Certain Supplier-branded and third-party products and services listed on this Quote are subject to additional,
specific terms stated on www.dell.com/offeringspecificterms (“Offer Specific Terms”).
In case of Resale only: Should Customer procure any products or services for resale, whether on standalone basis or as part of a solution,
Customer shall include the applicable software license terms, services terms, and/or offer-specific terms in a written agreement with the end-
user and provide written evidence of doing so upon receipt of request from Supplier.
In case of Financing only: If Customer intends to enter into a financing arrangement (“Financing Agreement”) for the products and/or
services on this Quote with Dell Financial Services LLC or other funding source pre-approved by Supplier (“FS”), Customer may issue its
purchase order to Supplier or to FS. If issued to FS, Supplier will fulfill and invoice FS upon confirmation that: (a) FS intends to enter into a
Financing Agreement with Customer for this order; and (b) FS agrees to procure these items from Supplier. Notwithstanding the Financing
Agreement, Customer’s use (and Customer’s resale of and the end-user’s use) of these items in the order is subject to the applicable
governing agreement between Customer and Supplier, except that title shall transfer from Supplier to FS instead of to Customer. If FS
notifies Supplier after shipment that Customer is no longer pursuing a Financing Agreement for these items, or if Customer fails to enter into
such Financing Agreement within 120 days after shipment by Supplier, Customer shall promptly pay the Supplier invoice amounts directly to
Supplier.
Customer represents that this transaction does not involve: (a) use of U.S. Government funds; (b) use by or resale to the U.S. Government;
or (c) maintenance and support of the product(s) listed in this document within classified spaces. Customer further represents that this
transaction does not require Supplier’s compliance with any statute, regulation or information technology standard applicable to a U.S.
Government procurement.
For certain products shipped to end users in California, a State Environmental Fee will be applied to Customer’s invoice. Supplier
encourages customers to dispose of electronic equipment properly.
Electronically linked terms and descriptions are available in hard copy upon request.
Page 6
Dell Marketing LP. U.S. only. Dell Marketing LP. is located at One Dell Way, Mail Stop 8129, Round Rock, TX 78682
17
HTTP://WWW.INSIGHT.COM
Page 1 of 2INSIGHT PUBLIC SECTOR SLED
2701 E INSIGHT WAY
CHANDLER AZ 85286-1930
Tel: 800-467-4448
SOLD-TO PARTY 10944418
VILLAGE OF PLAINFIELD
24401 W LOCKPORT ST
PLAINFIELD IL 60544-2313
SHIP-TO
VILLAGE OF PLAINFIELD
24401 W LOCKPORT ST
PLAINFIELD IL 60544-2313
We deliver according to the following terms:
Payment Terms :Net 30 days
Ship Via :Insight Assigned Carrier/Ground
Terms of Delivery :FOB DESTINATION
Currency :USD
Quotation
Quotation Number :0226961888
Document Date :19-DEC-2023
PO Number :
PO release::
Sales Rep :Bob Erwin
Email :BOB.ERWIN@INSIGHT.COM
Telephone :+14803667058
Sales Rep 2 :Lia Paredes
Email :LIA.PAREDES@INSIGHT.COM
Telephone :+14809021145
Material Material Description Quantity Unit Price Extended Price
3000170144720 VILLAGE OF PLAINFIELD - DELL LATITUDE 5430
RUGGED INTEL CORE PROCESSOR I7-1185G7,
3.0 TO 4.3 GHZ, 28W, VPRO) 14" TOUCH 1100
NITS WVA FHD (1920 X 1080) 100% SRGB
ANTI-GLARE, OUTDOOR VIEWABLE
1 2,852.00 2,852.00
OMNIA PARTNERS (COBB COUNTY) IT PRODUCTS AND
SERVICES(# 23-6692-03)
List Price: 3402.99
Discount: 16.191%
Product Subtotal 2,852.00
TAX 0.00
Total 2,852.00
Lease & Financing options available from Insight Global Finance for your equipment & software acquisitions. Contact your Insight
account executive for a quote.
Thank you for choosing Insight. Please contact us with any questions or for additional information about Insight's complete IT
solution offering.
Sincerely,
Bob Erwin
+14803667058
BOB.ERWIN@INSIGHT.COM
Lia Paredes
+14809021145
LIA.PAREDES@INSIGHT.COM
Fax 4807608347
To purchase under this contract, your agency must be registered with OMNIA Partners Public Sector.
18
HTTP://WWW.INSIGHT.COM Document Date 19-DEC-2023
Quotation Number 226961888
Page 2 of 2
Insight Global Finance has a wide variety of flexible financing options and technology refresh solutions. Contact your Insight
representative for an innovative approach to maximizing your technology and developing a strategy to manage your financial
options.
This purchase is subject to Insight’s online Terms of Sale unless you have a separate purchase agreement signed by you and
Insight, in which case, that separate agreement will govern. Insight’s online Terms of Sale can be found at the “terms-and-policies”
link below.
SOFTWARE AND CLOUD SERVICES PURCHASES: If your purchase contains any software or cloud computing offerings
(“Software and Cloud Offerings”), each offering will be subject to the applicable supplier's end user license and use terms
("Supplier Terms") made available by the supplier or which can be found at the “terms-and-policies” link below. By ordering,
paying for, receiving or using Software and Cloud Offerings, you agree to be bound by and accept the Supplier Terms unless you
and the applicable supplier have a separate agreement which governs.
https://www.insight.com/terms-and-policies
19
HTTP://WWW.INSIGHT.COM
Page 1 of 2INSIGHT PUBLIC SECTOR SLED
2701 E INSIGHT WAY
CHANDLER AZ 85286-1930
Tel: 800-467-4448
SOLD-TO PARTY 10944418
VILLAGE OF PLAINFIELD
24401 W LOCKPORT ST
PLAINFIELD IL 60544-2313
SHIP-TO
VILLAGE OF PLAINFIELD
24401 W LOCKPORT ST
PLAINFIELD IL 60544-2313
We deliver according to the following terms:
Payment Terms :Net 30 days
Ship Via :Insight Assigned Carrier/Ground
Terms of Delivery :FOB DESTINATION
Currency :USD
Quotation
Quotation Number :0226961878
Document Date :19-DEC-2023
PO Number :
PO release::
Sales Rep :Bob Erwin
Email :BOB.ERWIN@INSIGHT.COM
Telephone :+14803667058
Sales Rep 2 :Lia Paredes
Email :LIA.PAREDES@INSIGHT.COM
Telephone :+14809021145
Material Material Description Quantity Unit Price Extended Price
3000170144267 VILLAGE OF PLAINFIELD - DELL LATITUDE 5430
RUGGED INTEL CORE PROCESSOR I7-1185G7,
3.0 TO 4.3 GHZ, 28W, VPRO) 14" TOUCH 1100
NITS WVA FHD (1920 X 1080) 100% SRGB
ANTI-GLARE, OUTDOOR VIEWABLE
1 2,681.00 2,681.00
OPEN MARKET
Product Subtotal 2,681.00
Freight 16.48
TAX 0.00
Total 2,697.48
Lease & Financing options available from Insight Global Finance for your equipment & software acquisitions. Contact your Insight
account executive for a quote.
Thank you for choosing Insight. Please contact us with any questions or for additional information about Insight's complete IT
solution offering.
Sincerely,
Bob Erwin
+14803667058
BOB.ERWIN@INSIGHT.COM
Lia Paredes
+14809021145
LIA.PAREDES@INSIGHT.COM
Fax 4807608347
20
HTTP://WWW.INSIGHT.COM Document Date 19-DEC-2023
Quotation Number 226961878
Page 2 of 2
Insight Global Finance has a wide variety of flexible financing options and technology refresh solutions. Contact your Insight
representative for an innovative approach to maximizing your technology and developing a strategy to manage your financial
options.
This purchase is subject to Insight’s online Terms of Sale unless you have a separate purchase agreement signed by you and
Insight, in which case, that separate agreement will govern. Insight’s online Terms of Sale can be found at the “terms-and-policies”
link below.
SOFTWARE AND CLOUD SERVICES PURCHASES: If your purchase contains any software or cloud computing offerings
(“Software and Cloud Offerings”), each offering will be subject to the applicable supplier's end user license and use terms
("Supplier Terms") made available by the supplier or which can be found at the “terms-and-policies” link below. By ordering,
paying for, receiving or using Software and Cloud Offerings, you agree to be bound by and accept the Supplier Terms unless you
and the applicable supplier have a separate agreement which governs.
https://www.insight.com/terms-and-policies
21
Hardware Software Services IT Solutions Brands Research Hub
JAMES KASTRANTAS,
Thank you for considering CDWG for your technology needs. The details of your quote are below. If
you are an eProcurement or single sign on customer, please log into your system to access
the CDW site. You can search for your quote to retrieve and transfer back into your system for
processing.
For all other customers, click below to convert your quote to an order.
Convert Quote to Order
QUOTE #QUOTE DATE QUOTE REFERENCE CUSTOMER #GRAND TOTAL
NRQX861 1/3/2024 NRQX861 12479087 $6,186.70
QUOTE DETAILS
ITEM QTY CDW#UNIT PRICE EXT.PRICE
DELL CTO 5430 I7-1185G7 256 16 W11P 1 7749938 $3,020.79 $3,020.79
Mfg. Part#: 3000170080492
Contract: MARKET
DELL CTO 5430 I7-1185G7 256 16 W11P 1 7749943 $3,165.91 $3,165.91
Mfg. Part#: 3000170080491
Contract: MARKET
SUBTOTAL $6,186.70
SHIPPING $0.00
SALES TAX $0.00
GRAND TOTAL $6,186.70
PURCHASER BILLING INFO DELIVER TO
Billing Address:VILLAGE OF PLAINFIELD IT
ACCOUNTS PAYABL24401 W LOCKPORT STPLAINFIELD, IL 60544-2313Phone: (815) 436-7093
Payment Terms: NET 30-VERBAL
Shipping Address:
VILLAGE OF PLAINFIELD ITJAMES KASTRANTAS24401 W LOCKPORT STPLAINFIELD, IL 60544-2313Phone: (815) 436-7093
Shipping Method: DROP SHIP-GROUND
Please remit payments to:
CDW Government75 Remittance Drive
Suite 1515Chicago, IL 60675-1515
Sales Contact Info
Sam Raes | (877) 465-3134 | sam.raes@cdwg.com
22
Page 2 of 2
LEASE OPTIONS
FMV TOTAL FMV LEASE OPTION BO TOTAL BO LEASE OPTION
$6,186.70 $173.78/Month $6,186.70 $198.53/Month
Monthly payment based on 36 month lease. Other terms and options are available. Contact your Account Manager for details. Payment quoted
is subject to change.
Why finance?
Lower Upfront Costs. Get the products you need without impacting cash flow. Preserve your working capital and existing credit line.
Flexible Payment Terms. 100% financing with no money down, payment deferrals and payment schedules that match your company’s
business cycles.
Predictable, Low Monthly Payments. Pay over time. Lease payments are fixed and can be tailored to your budget levels or revenue streams.
Technology Refresh. Keep current technology with minimal financial impact or risk. Add-on or upgrade during the lease term and choose to
return or purchase the equipment at end of lease.
Bundle Costs. You can combine hardware, software, and services into a single transaction and pay for your software licenses over time! We
know your challenges and understand the need for flexibility.
General Terms and Conditions:
This quote is not legally binding and is for discussion purposes only. The rates are estimate only and are based on a collection of industry data
from numerous sources. All rates and financial quotes are subject to final review, approval, and documentation by our leasing partners.
Payments above exclude all applicable taxes. Financing is subject to credit approval and review of final equipment and services configuration.
Fair Market Value leases are structured with the assumption that the equipment has a residual value at the end of the lease term.
Need Help?
My Account Support Call 800.800.4239
About Us |Privacy Policy |Terms and Conditions
This order is subject to CDW’s Terms and Conditions of Sales and Service Projects at
http://www.cdwg.com/content/terms-conditions/product-sales.aspx
For more information, contact a CDW account manager.
' 2024 CDWG LLC, 200 N. Milwaukee Avenue, Vernon Hills, IL 60061 | 800.808.4239
23
MEMORANDUM
To: Mayor Argoudelis and Trustees
From: James Kastrantas, Information Technology Director
Date: 1/4/2024
Re: Online Scheduling and Time Reporting Solution Renewal
Background Findings
In order to work more effectively and efficiently across all departments and provide employees and supervisors
an easier way to create and manage department schedules we have implemented PACE Scheduling for an online
scheduling platform. Since January 2022 we have the Police Department fully using the platform. Previously
schedules, time sheets, leave requests and other time-based functions range across a variety of different
platforms including paper-based, Microsoft Excel, and others. This wide range of platforms can cause inefficiency
and extra work for employees, supervisors, and payroll.
Pace Scheduler will continue help the Village achieve our goal of a suitable online time scheduling and reporting
system that would:
•Allow for the complex schedule permutations of a police department, including shift bids, special details,
overtime/comp time, minimum staffing, zone/beat assignments, etc.
•Allow employees to request time off from the platform and allow supervisor and HR approval as well
•Allow for integration with our existing payroll system
•Integrate notifications and messaging to users
•Have an easy to use interface for all user levels
•Be mobile device friendly
•Use a secure, web-based interface to allow access from anywhere, including users working remotely due
to the COVID-19 pandemic
•Be extensible to all departments and divisions, not just police
PACE Scheduler provides the best functionality and ease of use. PACE Systems is a based in Naperville and has
very good reviews and recommendations from other local municipalities.
Policy Considerations
According to Section 2-43 (6) of the Village Code of Ordinances, the Village Administrator shall make a
recommendation to the President and Board of Trustees on purchases over the $10,000 statutory limit. The
Board has the right to accept or reject any or all proposals.
Financial Considerations
The annual cost for PACE Scheduler is $13,900.00. Funding for this renewal was in the Information Technology
Department budget.
Recommendation
It is staff’s recommendation that the Village Board authorize the Village administrator to execute the annual
renewal with PACE Scheduler in the amount of $13,900.00
24
ORDER CONFIRMATION
VIL035
ORD0036970
BILL TO:SHIP TO:
SO2 Orders
Sales Order No.
Order Type
Customer ID
Pace Systems, Inc
2040 Corporate Lane
Naperville, IL 60563
Phone: (630) 395-2260
Fax:
RICK KACZANKO
PLAINFIELD IL POLICE DEPARTMENT
24401 W LOCKPORT STREET
PLAINFIELD, IL 60544
PLAINFIELD IL POLICE DEPARTMENT
24401 W LOCKPORT STREET
PLAINFIELD, IL 60544
Notes:Page 1 of 1
12/1/2023
F.O.B. POINT SHIP VIA ORDERED BY
ORDER DATE TERMS SALES PERSON CONTRACT NUMBER
PART NUMBER UNITSQUANTITY UNIT PRICE DISC %EXTENDED PRICE
PROVENZANO, FRANK
CUSTOMER P.O. NO.
2021-00000088
Net 30 Days
Best Way Available
EA1.00 13,900.00 0.00PACE-SCHEDULER 13,900.0000001
SOFTWARE ANNUALLY 12/02/2023-12/01/2024
Notes:
Sales Total
Shipping & Handling
Total Misc. Charges
Sales Tax
0.00
13,900.00
TOTAL
Less Paid Amount 0.00
13,900.00
0.00
13,900.00
0.00
25
MEMORANDUM
To: Mayor Argoudelis and Trustees
From: Robert Miller, Chief of Police
Josh Blakemore, Village Administrator
Date: Monday, January 8th, 2024
Re: Memorandum of Understanding: Lakelands Subdivision
The Lakelands Subdivision Homeowners Association recently requested the Village of Plainfield enter into an agreement
(Memorandum of Understanding) authorizing enforcement of the Illinois Vehicle Code on private streets and roads
within the Lakelands Subdivision by the Village of Plainfield.
The Lakelands Subdivision Homeowners Association and the Village of Plainfield previously had a Memorandum of
Understanding for said purpose, which has since expired. The Lakelands Subdivision Homeowners Association requests
the Village enter into a new agreement.
The agreement submitted for your consideration has already been approved by the Lakelands Subdivision Homeowners
Association.
26
DocuSign Envelope ID: CD135564-D739-4B8F-94C1-1706D84592A027
DocuSign Envelope ID: CD135564-D739-4B8F-94C1-1706D84592A028
DocuSign Envelope ID: CD135564-D739-4B8F-94C1-1706D84592A029
DocuSign Envelope ID: CD135564-D739-4B8F-94C1-1706D84592A030
DocuSign Envelope ID: CD135564-D739-4B8F-94C1-1706D84592A031
DocuSign Envelope ID: CD135564-D739-4B8F-94C1-1706D84592A032
DocuSign Envelope ID: CD135564-D739-4B8F-94C1-1706D84592A033
DocuSign Envelope ID: CD135564-D739-4B8F-94C1-1706D84592A034
DocuSign Envelope ID: CD135564-D739-4B8F-94C1-1706D84592A035
DocuSign Envelope ID: CD135564-D739-4B8F-94C1-1706D84592A036
Minutes of the Committee of the Whole Workshop of the President
and the Board of Trustees
Held on December 11, 2023
In the Boardroom
Mayor Argoudelis called the meeting to order at 7:00 p.m. Board present: Mayor Argoudelis, Trustee
Bonuchi, Trustee Kalkanis, Trustee Kiefer, Trustee Larson, Trustee Ruane, and Trustee Wojowski. Others
present: Joshua Blakemore, Administrator; Michelle Gibas, Village Clerk; Rich Vogel, Village Attorney;
Scott Threewitt, Public Works Director; Jon Proulx, Planning Director; Jake Melrose, Economic
Development Director; Traci Pleckham, Management Services Director; Lonnie Spires, Building Official;
and Robert Miller, Chief of Police. There were approximately 10 persons in the audience.
Trustee Ruane moved to approve the Minutes of the Special Meeting and Committee of the Whole
Workshop held on November 27, 2023. Second by Trustee Kiefer Voice Vote. All in favor, 0
opposed. Motion carried.
PRESIDENTIAL COMMENTS
Mayor Argoudelis commented on holiday parties and gatherings.
TRUSTEE COMMENTS
No Comments.
PUBLIC COMMENTS
1)Christopher Angela expressed concern regarding the pace the Village is proceeding with
developments and expressed concern with the Lockley Park proposed development.
2)Nick Plattos expressed concern regarding proceeding with development with no regards to the
future traffic. Mr. Plattos expressed concern regarding putting in a development on 143
rd Street
because that road dead ends. Mr. Plattos also expressed concern that the Village is not talking
with the School District regarding the impact that new developments have on the School District.
Mayor Argoudelis commented on previously approved developments with legal rights to build and also
commented on conversations the Village has had with the School District. Administrator Blakemore gave
an update on the 143rd Street west extension, the 143rd Street east extension, the Transportation and
Mobility Plan which identifies approximately $160 million of transportation improvement projects, and
the Comprehensive Plan Amendment.
WORKSHOP
1)RENTAL ORDINANCE
Mr. Lonnie Spires presented a draft of the Rental Ordinance. Mayor Argoudelis expressed concern
regarding some definitions and requested updating language for family, nuisance activity, short-term
rentals, and good standing. Trustee Wojowski expressed concern with language pertaining to police
discretion in section 2.5-535 and suggested including articulable facts. If you do “x”, then you get “y”.
Trustee Larson stated that she is not a fan of the ordinance and felt that it is invasive. Trustee Larson also
expressed concern regarding information being released pursuant to FOIA requests, expensive fines,
definition of family, restrictions on landlords, and enforcement. Trustee Ruane indicated support for the
rental ordinance with changes to definitions as identified by the other Board members and perhaps
including some language identifying safe exterior.
37
Village of Plainfield
Committee of the Whole Meeting Minutes – December 11, 2023
Page 2
Sargeant Mulacek reviewed Crime Free Housing. Mayor Argoudelis suggested including language
pertaining to Fair Housing violations. Trustee Wojowski suggested including language regarding
updating any new adult occupants after the lease was initiated.
Mayor Argoudelis thanked staff and requested staff to continue working on the rental ordinance and bring
it back for consideration.
2) LOCKLEY PARK (CASE NUMBER 2023-082523.SU/SPR/PP)
Mr. Jon Proulx stated that the developer, M/I Homes of Chicago, is seeking approval of a special use for
planned development to permit up to 168 townhomes on approximately 38 acres of vacant agricultural
land located at the southeast corner of 143rd Street and Steiner Road. The applicant is also seeking
approval of the corresponding site plan review and preliminary plat. The subject property was originally
annexed in 2004 as Pod 12 of a larger, 673-acre development known as the McMicken Assemblage. The
subject property is currently zoned R-1 PUD to allow a townhome development of up to 252 units,
pursuant to the previously executed annexation agreement.
The Village Board considered the case on November 6 and was generally supportive. The Village Board
asked the applicant to consider relocating townhome building 48 to provide more setback and separation
from 143rd Street and there was also discussion about how storage needs would be addressed and whether
basements could be incorporated. The applicant has modified the plans to eliminate Building 48. As a
result, a few four-unit buildings have been redesigned to five-unit buildings and the corresponding
approvals to allow five-unit buildings has been added to the planned development Statement of Intent and
Agreement. The applicant has also committed to providing basements in specific homes and has
redesigned the floorplans to include a storage room in the homes without basements.
There was some general discussion regarding the applicant incorporating previous suggestions by the
Board as well as developments previously approved by past Boards. Trustee Kalkanis stated that she is
not in favor of this project and felt that this is not responsible growth. Trustee Wojowski indicated that he
does not support this project and expressed concerns regarding deviations of setbacks, trees, and streets.
Mayor Argoudelis thanked the staff and developer.
Trustee Ruane moved to adjourn the Committee of the Whole Workshop. Second by Trustee Larson.
Voice Vote. All in favor, 0 opposed. Motion carried.
The meeting adjourned at 8:47 p.m.
Michelle Gibas, Village Clerk
38
VILLAGE OF PLAINFIELD
SPECIAL MEETING MINUTES
DECEMBER 11, 2023
AT:VILLAGE HALL
BOARD PRESENT: J. ARGOUDELIS, M.BONUCHI, . P.KALKANIS, R.KIEFER, C.LARSON,
T.RUANE, AND B.WOJOWSKI. OTHERS PRESENT: J.BLAKEMORE, ADMINISTRATOR;
R.VOGEL, ATTORNEY; M.GIBAS, VILLAGE CLERK; S.THREEWITT, PUBLIC WORKS
DIRECTOR; J.PROULX, PLANNING DIRECTOR; J.MELROSE, ECONOMIC DEVELOPMENT
DIRECTOR; L.SPIRES, BUILDING OFFICIAL; T.PLECKHAM, MANAGEMENT SERVICES
DIRECTOR; AND R.MILLER, CHIEF OF POLICE.
CALL TO ORDER, ROLL CALL
Mayor Argoudelis called the meeting to order at 8:48 p.m. Roll call was taken, all Trustees were present.
There were approximately 10 persons in the audience.
PUBLIC COMMENTS (3-5 minutes)
No comments.
BUSINESS MEETING
1)APPROVAL OF AGENDA
Trustee Larson moved to approve the Agenda. Second by Trustee Bonuchi. Vote by roll call. Bonuchi,
yes; Kalkanis, yes; Kiefer, yes; Larson, yes; Ruane, yes; Wojowski, yes. 6 yes, 0 no. Motion carried.
2)LOCKLEY PARK (CASE NUMBER 2023-082523.SU/SPR/PP)
Trustee Bonuchi moved to remove this matter from the table. Second by Trustee Larson. Vote by roll call.
Bonuchi, yes; Kalkanis, no; Kiefer, yes; Larson, yes; Ruane, yes; Wojowski, no. 4 yes, 2 no. Motion
carried.
Trustee Ruane moved to adopt the findings of fact of the Plan Commission as the findings of fact of the
Board of Trustees and, furthermore, to approve Ordinance No. 3627, granting approval of a special use
for planned development for the project known as Lockley Park, located generally at the southeast corner
of 143rd Street and Steiner Road, to permit a townhome residential development of up to 168 townhomes,
subject to the stipulations noted in the staff report. Second by Trustee Bonuchi. Vote by roll call.
Bonuchi, yes; Kalkanis, no; Kiefer, yes; Larson, yes; Ruane, yes; Wojowski, no. 4 yes, 2 no. Motion
carried.
Trustee Ruane moved to approve the site plan review for the project known as Lockley Park, subject to
the stipulations noted in the staff report. Second by Trustee Bonuchi. Vote by roll call. Bonuchi, yes;
Kalkanis, no; Kiefer, yes; Larson, yes; Ruane, yes; Wojowski, no. 4 yes, 2 no. Motion carried.
Trustee Ruane moved to approve the Preliminary plat of Subdivision for Lockley Park, subject to the
stipulations noted in the staff report. Second by Trustee Bonuchi. Vote by roll call. Bonuchi, yes;
Kalkanis, no; Kiefer, yes; Larson, yes; Ruane, yes; Wojowski, no. 4 yes, 2 no. Motion carried.
Trustee Larson moved to Bonuchi. Second by Trustee Larson. Voice Vote. All in favor, 0 opposed.
Motion carried.
The meeting adjourned at 8:52 p.m.
Michelle Gibas, Village Clerk
39
FY 2020
Actual
FY 2021
Actual
FY 2022
Actual
FY 2023
Actual
FY 2024
Adopted
Budget
FY 2025
Proposed
Budget
Fund: 02 - Water & Sewer Fund
Licenses and Permits 1,593,514 3,410,306 3,737,652 4,379,140 2,155,000 2,305,000
State of Illinois Taxes 1,801,904 2,114,518 2,993,857 3,168,756 3,000,000 3,200,000
16,846,437 19,140,282 19,679,120 20,606,940 20,639,000 22,827,700
0 0 0 2,753,043 980,000 0
404,488 62,163 (177,284)883,868 150,000 550,000
25,631 52,618 45,044 45,283 28,000 28,000
0 0 0 1,233,941 1,909,000 0
Revenues Total $20,671,974 $24,779,887 $26,278,389 $33,070,971 $28,861,000 $28,910,700
1,318,114 1,312,957 1,285,091 1,306,747 1,672,000 1,770,000
481,960 530,380 496,517 480,033 690,830 648,756
742,311 756,615 717,465 553,744 749,500 823,000
500,546 490,170 585,830 777,429 768,000 785,500
9,462,377 10,685,604 11,642,679 12,039,693 12,185,500 14,350,500
350,000 350,000 350,000 350,000 350,000 350,000
981,000 983,800 935,748 949,100 952,088 0
4,088,669 4,549,267 4,903,080 5,835,977 9,975,000 9,725,000
3,123,776 1,309,591 1,302,982 1,427,933 1,494,774 1,603,887
3,472,840 3,588,950 3,640,901 3,667,321 0 0
Expenditures Total $24,521,593 $24,557,334 $25,860,293 $27,387,977 $28,837,692 $30,056,643
Total: Water & Sewer Fund ($3,849,619)$222,553 $418,096 $5,682,994 $23,308 ($1,145,943)
Classification
Water, Sewer & Expansion Revenues
Water, Sewer & Expansion Expenses
Water & Sewer Fund
Revenue/Expense Summary
2024-2025 Fiscal Year Budget
Charges for Services
Grants
Investment Income
Miscellaneous
Debt Proceeds
Supplies and Commodities
Utilities
Benefits
Salaries and Wages
Contractual Services
Other
Transfer to Debt Service
Capital
Debt service
Depreciation
DRAFT 01/04/24 Page 1
40
Description
FY 2021
Actual
FY 2022
Actual
FY 2023
Actual
FY 2024
Adopted
Budget
FY 2024
Estimated
Budget
FY 2025
Proposed
Budget
Fund: 02 - Water and Sewer Fund
LIC&PER - Licenses and Permits
Meter Sales 191,884 232,195 242,445 200,000 200,000 250,000
Water Connection Fee 1,103,812 1,649,436 1,459,649 950,000 1,200,000 1,000,000
Sewer Connection Fee 2,112,245 1,654,680 2,413,488 950,000 1,300,000 1,000,000
Sewer By-Pass Fee 2,365 5,375 5,805 5,000 5,000 5,000
Recapture Fee 0 195,966 257,753 50,000 75,000 50,000
$3,410,306 $3,737,652 $4,379,140 $2,155,000 $2,780,000 $2,305,000
STTAX - State of Illinois Taxes
Home Rule Sales Tax 2,114,518 2,993,857 3,168,756 3,000,000 3,150,000 3,200,000
$2,114,518 $2,993,857 $3,168,756 $3,000,000 $3,150,000 $3,200,000
SERV - Charges for Services
Water Sales 11,976,340 12,195,843 12,730,856 12,900,000 13,650,000 14,195,000
Water Penalty 0 87,542 116,695 85,000 125,000 95,000
Sewer Sales 6,029,551 6,181,896 6,496,573 6,400,000 6,920,000 7,195,000
Sewer Penalty 0 47,139 62,523 50,000 70,000 70,000
Capital Charge 1,110,391 1,133,511 1,163,801 1,170,000 1,197,970 1,235,000
Capital Charge Penalty 0 9,189 12,492 10,000 13,500 10,000
Tower Rent 24,000 24,000 24,000 24,000 24,000 27,700
$19,140,282 $19,679,120 $20,606,940 $20,639,000 $22,000,470 $22,827,700
Grant Revenue 0 0 2,753,043 980,000 2,942,000 0
$0 $0 $2,753,043 $980,000 $2,942,000 $0
Interest Income 44,047 17,708 835,249 150,000 750,000 550,000
Realized/Unrealized G/L 18,116 (194,992)48,619 0 0 0
$62,163 ($177,284)$883,868 $150,000 $750,000 $550,000
Sale of Scrap 2,581 6,163 3,136 500 2,750 500
Other Reimbursements 21,930 2,989 7,235 2,500 2,500 2,500
Other Receipts 28,107 35,892 34,912 25,000 10,000 25,000
$52,618 $45,044 $45,283 $28,000 $15,250 $28,000
Loan Proceeds 0 0 1,233,941 1,909,000 1,515,000 0
$0 $0 $1,233,941 $1,909,000 $1,515,000 $0
$24,779,887 $26,278,389 $33,070,971 $28,861,000 $33,152,720 $28,910,700
DEBT - Debt Proceeds
Total: Debt Proceeds
Water & Sewer Fund
Revenue Detail
2024-2025 Fiscal Year Budget
Revenues Total
Revenues
Total: Licenses & Permits
Total: State of Illinois Taxes
Total: Charges for Services
INT - Investment Income
Total: Investment Income
MISC - Miscellaneous
Total: Miscellaneous
GRNTS - Grants
Total: Grants
DRAFT 01/04/24 Page 2
41
Description
FY 2021
Actual
FY 2022
Actual
FY 2023
Actual
FY 2024
Adopted
Budget
FY 2024
Estimated
Budget
FY 2025
Proposed
Budget
Fund: 02 - Water and Sewer Fund Expenses
Unit: 10 - Water Department
SAL - Salaries and Wages
Salaries-Full Time 219,318 228,056 225,835 285,000 240,000 295,000
Salaries-Part Time 0 0 4,299 6,500 10,000 15,000
$219,318 $228,056 $230,134 $291,500 $250,000 $310,000
FICA 13,980 13,951 13,190 18,075 15,500 19,220
Medicare 3,355 3,346 3,085 4,225 3,625 4,495
IMRF 25,886 24,591 19,024 32,065 25,000 31,000
Employee Insurance 45,398 43,471 43,080 60,000 50,000 55,000
Deferred Comp. Contrib 7,708 6,874 5,737 12,000 10,000 10,000
Travel/Training 1,918 4,211 2,922 5,000 2,500 5,000
IL Unemployment Ins.2,000 1,447 1,175 2,000 2,000 2,000
$100,245 $97,891 $88,213 $133,365 $108,625 $126,715
Telephone/Internet 7,717 630 638 3,000 1,000 2,000
Cellular Phones 4,178 4,412 5,207 5,000 7,000 7,500
$11,895 $5,042 $5,845 $8,000 $8,000 $9,500
SUPP - Supplies & Commodities
Office Supplies/Postage 29,484 36,212 38,907 35,000 35,000 35,000
Dues & Subscriptions 266 1,504 2,224 2,000 2,200 2,500
Gas/Oil/Mileage/Wash 82 538 68 500 200 500
Supplies/Hardware 448 485 540 500 550 500
Software 0 0 0 2,000 400 2,000
Sand & Gravel 1,476 847 1,666 2,000 1,000 2,000
Water Meters 174,832 236,273 403,635 325,000 300,000 350,000
$206,588 $275,859 $447,040 $367,000 $339,350 $392,500
Contract - Contractual Services
Building Maintenance 10,623 17,122 14,959 20,000 15,000 20,000
Legal Fees 0 617 0 1,500 1,500 1,500
Contractual Services 36,904 89,347 83,315 90,000 85,000 90,000
Equipment Maintenance 251 689 19 500 500 500
Engineering Fees 79,590 97,499 16,872 40,000 40,000 40,000
$127,368 $205,274 $115,165 $152,000 $142,000 $152,000
Admin Service Charge 175,000 175,000 175,000 175,000 175,000 175,000
Transfer to Debt Service 245,950 233,937 237,275 238,022 238,022 0
$420,950 $408,937 $412,275 $413,022 $413,022 $175,000
$1,086,364 $1,221,059 $1,298,672 $1,364,887 $1,260,997 $1,165,715
BEN - Benefits
Total: Benefits
UTIL - Utilities
Total: Utilities
Total: Supplies & Commodities
Total: Contractual Services
OTHER - Other
Total: Other
Total: Water Admin Program
Total: Salaries and Wages
Division: 02 - Water Administration Program
Water & Sewer Fund
Water/Sewer/Expansion Expense Detail
2024-2025 Fiscal Year Budget
DRAFT 01/04/24 Page 3
42
Description
FY 2021
Actual
FY 2022
Actual
FY 2023
Actual
FY 2024
Adopted
Budget
FY 2024
Estimated
Budget
FY 2025
Proposed
Budget
Water & Sewer Fund
Water/Sewer/Expansion Expense Detail
2024-2025 Fiscal Year Budget
Salaries-Full Time 387,777 396,777 375,882 495,000 445,000 525,000
Salaries-Part Time 8,086 1,595 5,681 20,000 15,000 20,000
Salaries-Overtime 32,515 39,927 38,559 35,000 42,000 40,000
$428,378 $438,299 $420,122 $550,000 $502,000 $585,000
FICA 27,058 26,678 26,153 34,100 31,125 36,270
Medicare 6,364 6,273 6,116 7,975 7,280 8,483
IMRF 47,854 45,808 37,986 60,500 45,000 50,000
Employee Insurance 75,837 70,620 64,772 85,000 62,000 65,000
Deferred Comp. Contrib 13,575 13,139 11,075 20,000 15,000 18,000
$170,688 $162,518 $146,102 $207,575 $160,405 $177,753
Telephone/Internet 18,521 1,513 1,531 5,000 1,600 2,000
Electricity/Gas 146,358 165,167 124,455 150,000 200,000 225,000
$164,879 $166,680 $125,986 $155,000 $201,600 $227,000
SUPP - Supplies and Commodities
Office Supplies/Postage 331 226 1,047 2,000 1,500 2,000
Replacement Supplies 6,950 19,085 11,716 10,000 15,000 20,000
Gas/Oil/Mileage/Wash 10,092 16,462 14,555 20,000 18,000 20,000
Supplies/Hardware 7,699 8,907 10,707 10,000 18,000 20,000
Chemicals 5,851 5,475 10,040 10,000 6,000 10,000
Uniforms/Clothing 4,793 3,427 2,914 5,000 4,500 5,000
$35,716 $53,582 $50,979 $57,000 $63,000 $77,000
Contract - Contractual Services
Building Maintenance 7,978 1,216 1,672 20,000 10,000 45,000
Vehicle Maintenance 8,136 8,552 13,270 10,000 10,000 10,000
Contractual Services 35,739 14,057 6,833 60,000 25,000 60,000
Lake Michigan Water 9,994,364 10,941,410 11,385,077 11,200,000 12,920,000 13,305,000
Equipment Maint.4,356 10,299 8,605 10,000 10,000 10,000
System Maintenance 46,540 20,413 105,089 90,000 85,000 90,000
Water/Fire Hydrant 42,815 41,511 35,550 50,000 45,000 50,000
EPA Analytical 25,244 18,723 24,040 30,000 30,000 30,000
$10,165,172 $11,056,181 $11,580,136 $11,470,000 $13,135,000 $13,600,000
Transfer to Debt Service 245,950 233,937 237,275 238,022 238,022 0
$245,950 $233,937 $237,275 $238,022 $238,022 $0
Contingencies/Depreciation
Depreciation 3,588,950 3,640,901 3,667,321 0 0 0
$3,588,950 $3,640,901 $3,667,321 $0 $0 $0
$14,799,733 $15,752,098 $16,227,921 $12,677,597 $14,300,027 $14,666,753
$15,886,097 $16,973,157 $17,526,593 $14,042,484 $15,561,024 $15,832,468Total: Water Department
BEN - Benefits
Total: Benefits
UTIL - Utilities
Total: Utilities
Total: Supplies & Commodities
Total: Contractual Services
OTHER - Other
Total: Other
Total: Depreciation
Total: Water Distribution Program
Total: Salaries and Wages
SAL - Salaries and Wages Division: 30 - Water Distribution Program
DRAFT 01/04/24 Page 4
43
Description
FY 2021
Actual
FY 2022
Actual
FY 2023
Actual
FY 2024
Adopted
Budget
FY 2024
Estimated
Budget
FY 2025
Proposed
Budget
Water & Sewer Fund
Water/Sewer/Expansion Expense Detail
2024-2025 Fiscal Year Budget
Unit: 11 - Sewer Department
Salaries-Full Time 220,781 224,276 227,052 285,000 240,000 295,000
Salaries-Part Time 0 0 4,298 6,500 10,000 15,000
$220,781 $224,276 $231,350 $291,500 $250,000 $310,000
FICA 14,021 13,601 13,100 18,075 15,500 19,220
Medicare 3,365 3,263 3,063 4,225 3,625 4,495
IMRF 25,985 24,049 18,918 32,065 25,000 34,100
Employee Insurance 43,787 41,968 43,101 59,000 53,000 55,000
Deferred Comp. Contrib 7,735 6,674 5,690 12,000 12,000 12,000
Travel/Training 989 3,150 12,183 12,000 12,000 13,500
IL Unemployment Ins.2,000 1,237 1,144 2,000 2,000 2,000
$97,882 $93,942 $97,199 $139,365 $123,125 $140,315
Telephone/Internet 13,376 1,093 1,106 3,000 2,000 3,000
Cellular Phones 2,372 2,008 2,763 3,500 3,500 3,500
$15,748 $3,101 $3,869 $6,500 $5,500 $6,500
SUPP - Supplies and Commodities
Office Supplies/Postage 28,822 32,813 38,571 35,000 35,000 35,000
Dues & Subscriptions 63,935 64,560 67,460 70,000 70,000 72,000
Gas/Oil/Mileage/Wash 2,195 848 208 2,500 2,000 2,500
Supplies/Hardware 1,560 1,115 1,720 3,000 2,000 3,000
$96,512 $99,336 $107,959 $110,500 $109,000 $112,500
Contract - Contractual Services
Building Maintenance 10,637 15,305 22,234 20,000 20,000 65,000
Legal Fees 0 0 0 1,500 500 1,500
Contractual Services 48,247 54,696 64,977 65,000 65,000 75,000
Equipment Maintenance 683 12 0 2,000 2,000 2,000
Engineering Fees 13,731 0 15,409 15,000 15,000 15,000
$73,298 $70,013 $102,620 $103,500 $102,500 $158,500
Admin Service Charge 175,000 175,000 175,000 175,000 175,000 175,000
Transfer to Debt Service 245,950 233,937 237,275 238,022 238,022 0
$420,950 $408,937 $412,275 $413,022 $413,022 $175,000
$925,171 $899,605 $955,272 $1,064,387 $1,003,147 $902,815 Total: Sewer Admin Program
SAL - Salaries and Wages
Total: Salaries and Wages
Total: Benefits
UTIL - Utilities
Total: Utilities
Total: Supplies and Commodities
Division: 02 - Sewer Administration Program
Total: Contractual
OTHER - Other
Total: Other
BEN - Benefits
DRAFT 01/04/24 Page 5
44
Description
FY 2021
Actual
FY 2022
Actual
FY 2023
Actual
FY 2024
Adopted
Budget
FY 2024
Estimated
Budget
FY 2025
Proposed
Budget
Water & Sewer Fund
Water/Sewer/Expansion Expense Detail
2024-2025 Fiscal Year Budget
Salaries-Full Time 409,938 371,322 398,858 489,000 455,000 530,000
Salaries-Part Time 8,086 1,595 5,681 20,000 0 5,000
Salaries-Overtime 26,456 21,543 20,602 30,000 25,000 30,000
$444,480 $394,460 $425,141 $539,000 $480,000 $565,000
FICA 28,018 24,060 26,056 33,420 29,800 35,030
Medicare 6,585 5,658 6,094 7,815 6,960 8,193
IMRF 49,784 41,818 38,095 59,290 45,000 55,750
Employee Insurance 63,072 59,009 67,241 90,000 80,500 85,000
Deferred Comp. Contrib 14,106 11,621 11,033 20,000 15,000 20,000
$161,565 $142,166 $148,519 $210,525 $177,260 $203,973
Telephone/Internet 36,014 2,938 2,978 5,000 5,000 5,000
Electricity/Gas 528,079 539,704 415,066 575,000 525,000 575,000
$564,093 $542,642 $418,044 $580,000 $530,000 $580,000
SUPP - Supplies and Commodities
Office Supplies/Postage 73 0 1,937 3,000 5,000 3,000
Replacement Supplies 4,218 4,712 4,497 5,000 5,000 5,000
Gas/Oil/Mileage/Wash 7,140 13,810 15,016 15,000 15,000 15,000
Supplies/Hardware 12,038 6,774 12,392 15,000 15,000 15,000
Chemicals 118,308 124,923 126,717 180,000 130,000 150,000
Sand & Gravel 0 0 0 500 500 500
Industrial Flow Monitor 2,363 2,988 3,807 7,000 4,000 7,000
Uniforms/Clothing 7,214 3,846 7,085 8,000 6,000 8,000
$151,354 $157,053 $171,451 $233,500 $180,500 $203,500
Contract - Contractual Services
Vehicle Maintenance 9,863 3,938 5,828 10,000 8,000 10,000
Contractual Services 227,502 253,846 184,600 300,000 300,000 300,000
Equipment Maint.22,125 18,761 8,163 30,000 20,000 30,000
System Maintenance 60,276 34,666 43,181 120,000 80,000 100,000
$319,766 $311,211 $241,772 $460,000 $408,000 $440,000
Transfer to Debt Service 245,950 233,937 237,275 238,022 238,022 0
$245,950 $233,937 $237,275 $238,022 $238,022 $0
$1,887,208 $1,781,469 $1,642,202 $2,261,047 $2,013,782 $1,992,473
$2,812,379 $2,681,074 $2,597,474 $3,325,434 $3,016,929 $2,895,288
Division: 40 - Sewer Treatment Program
Total: Sewer Department
Total: Sewer Treatment Program
SAL - Salaries and Wages
Total:Salaries & Wages
BEN - Benefits
Total: Benefits
UTIL - Utilities
Total: Utilities
Total: Supplies & Commodities
Total: Contractual
OTHER - Other
Total: Other
DRAFT 01/04/24 Page 6
45
Description
FY 2021
Actual
FY 2022
Actual
FY 2023
Actual
FY 2024
Adopted
Budget
FY 2024
Estimated
Budget
FY 2025
Proposed
Budget
Water & Sewer Fund
Water/Sewer/Expansion Expense Detail
2024-2025 Fiscal Year Budget
Unit: 12 - Utility Expansion
Contractual Services 233,451 57,577 56,632 200,000 70,000 75,000
Engineering Fees 123,920 68,696 55,933 175,000 50,000 150,000
Machinery & Equipment 413,836 534,132 3,266,407 500,000 150,000 250,000
Vehicles 0 59,888 58,963 100,000 100,000 100,000
Village Green Reconstruction 2,561,489 0 0 0 0 0
Wastewater Treatment Plant 0 0 0 0 0 500,000
Old Town Reconstruction 0 3,888,346 2,121,841 3,000,000 3,000,000 7,200,000
143rd St. West Watermain 0 0 3,364 3,200,000 3,200,000 0
Lakewater/Essignton Rd Trans Main 262,505 0 0 0 0 0
Scada Improvements 654,705 0 0 0 0 0
Tower Improvements 0 246,013 35,738 2,300,000 75,000 750,000
Well House Pump Rebuild 0 0 0 0 0 450,000
Liftstation Improvements 299,361 48,428 237,099 500,000 650,000 250,000
$4,549,267 $4,903,080 $5,835,977 $9,975,000 $7,295,000 $9,725,000
2015/2008 Bond (Principal)645,000 665,000 700,000 725,000 725,000 750,000
2015/2008 Bond (Interest)477,350 450,750 422,750 393,750 393,750 363,750
IEPA Loan (Principal) L17-311500 163,416 165,465 167,539 169,640 169,640 171,768
IEPA Loan (Interest) L17-311500 23,825 21,767 19,682 18,367 18,367 16,240
IEPA Loan 2 (Principal) L17-4666 0 0 89,266 146,096 146,096 166,277
IEPA Loan 2 (Interest) L17-4666 0 0 28,696 41,921 41,921 44,852
IEPA Loan 3 (Principal) L17-4069 0 0 0 0 0 71,000
IEPA Loan 3 (Interest) L17-4069 0 0 0 0 0 20,000
$1,309,591 $1,302,982 $1,427,933 $1,494,774 $1,494,774 $1,603,887
$5,858,858 $6,206,062 $7,263,910 $11,469,774 $8,789,774 $11,328,887
$24,557,334 $25,860,293 $27,387,977 $28,837,692 $27,367,727 $30,056,643Total: Water & Sewer Fund
Total: Other
Division: 92 - Bonds
OTHER - Other
Total: Other
Unit Total: 12 - Utility Expansion
OTHER - Other
Division: 91 - Capital
Unit: 12 - Utility Expansion
DRAFT 01/04/24 Page 7
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 YTD
Fund 02 - Water and Sewer Fund
REVENUE
0450.450 Home Rule Sales Tax 3,000,000.00 .00 3,000,000.00 .00 .00 2,058,997.53 941,002.47 69 2,109,989.59
0570.850 Meter Sales 200,000.00 .00 200,000.00 2,550.00 .00 143,160.00 56,840.00 72 162,180.00
0570.851 Water Connection Fee 950,000.00 .00 950,000.00 13,810.00 .00 1,015,397.50 (65,397.50)107 990,513.50
0570.852 Sewer Connection Fee 950,000.00 .00 950,000.00 7,200.00 .00 1,105,410.00 (155,410.00)116 1,622,688.00
0570.859 Sewer By-Pass Fee 5,000.00 .00 5,000.00 .00 .00 2,150.00 2,850.00 43 4,515.00
0570.876 Recapture Fee 50,000.00 .00 50,000.00 .00 .00 61,682.40 (11,682.40)123 239,600.53
0620.672 Water Sales 12,900,000.00 .00 12,900,000.00 421.05 .00 9,839,741.49 3,060,258.51 76 9,061,065.01
0620.673 Water Penalty 85,000.00 .00 85,000.00 .00 .00 95,154.72 (10,154.72)112 84,286.12
0620.674 Sewer Sales 6,400,000.00 .00 6,400,000.00 (36.72).00 4,978,568.74 1,421,431.26 78 4,644,546.57
0620.675 Sewer Penalty 50,000.00 .00 50,000.00 .00 .00 51,140.67 (1,140.67)102 44,813.90
0620.676 Capital Charge 1,170,000.00 .00 1,170,000.00 (13.00).00 896,449.97 273,550.03 77 870,285.31
0620.677 Capital Charge Penalty 10,000.00 .00 10,000.00 .00 .00 9,221.29 778.71 92 8,380.67
0650.818 Tower Rent 24,000.00 .00 24,000.00 2,000.00 .00 18,000.00 6,000.00 75 18,000.00
0700.650 Grant Revenue 980,000.00 .00 980,000.00 .00 .00 .00 980,000.00 0 3,014,819.33
0800.800 Interest Income 150,000.00 .00 150,000.00 .00 .00 626,524.06 (476,524.06)418 381,332.48
0800.827 Unrealized Gain/Loss .00 .00 .00 .00 .00 22,025.15 (22,025.15)+++(13,120.72)
0800.830 Unrealized Gain/Loss IMET .00 .00 .00 .00 .00 49,477.09 (49,477.09)+++(19,063.02)
0803.001 Sale of Scrap 500.00 .00 500.00 .00 .00 2,747.00 (2,247.00)549 1,959.00
0805.000 Other Reimbursements 2,500.00 .00 2,500.00 .00 .00 1,330.00 1,170.00 53 6,845.00
0806.000 Other Receipts 25,000.00 .00 25,000.00 .00 .00 4,918.43 20,081.57 20 17,498.28
0950.952 Loan Proceeds 1,909,000.00 .00 1,909,000.00 .00 .00 868,287.06 1,040,712.94 45 3,350,099.58
REVENUE TOTALS $28,861,000.00 $0.00 $28,861,000.00 $25,931.33 $0.00 $21,850,383.10 $7,010,616.90 76%$26,601,234.13
EXPENSE
Unit 10 - Water Department
Division 02 - Administration Program
1005 Salaries-Full Time 285,000.00 .00 285,000.00 .00 .00 155,912.56 129,087.44 55 128,154.25
1015 Salaries-Part Time 6,500.00 .00 6,500.00 .00 .00 6,623.23 (123.23)102 1,018.80
2000 FICA 18,075.00 .00 18,075.00 .00 .00 10,041.99 8,033.01 56 7,998.69
2001 Medicare 4,225.00 .00 4,225.00 .00 .00 2,348.75 1,876.25 56 1,870.74
2010 IMRF 32,065.00 .00 32,065.00 .00 .00 13,062.31 19,002.69 41 11,837.61
2020 Employee Insurance 60,000.00 .00 60,000.00 .00 .00 36,047.04 23,952.96 60 30,489.07
2025 Deferred Comp. Contribution 12,000.00 .00 12,000.00 .00 .00 .00 12,000.00 0 .00
3000 Travel/Training 5,000.00 .00 5,000.00 .00 .00 549.92 4,450.08 11 1,166.99
3015 IL Unemployment Insurance 2,000.00 .00 2,000.00 .00 .00 513.13 1,486.87 26 595.86
4000 Telephone/Internet 3,000.00 .00 3,000.00 .00 .00 270.88 2,729.12 9 419.62
4005 Cellular Phones 5,000.00 .00 5,000.00 .00 .00 4,036.94 963.06 81 2,967.56
5005 Office Supplies/Postage 35,000.00 .00 35,000.00 2,708.18 .00 27,484.71 7,515.29 79 27,781.46
5015 Dues & Subscriptions 2,000.00 .00 2,000.00 .00 .00 1,364.45 635.55 68 1,841.08
5020 Gas/Oil/Mileage/Carwash 500.00 .00 500.00 .00 .00 3.33 496.67 1 68.38
Run by Traci Pleckham on 01/04/2024 02:17:42 PM Page 1 of 5
Budget Performance Report
Fiscal Year to Date 01/04/24
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 YTD
Fund 02 - Water and Sewer Fund
EXPENSE
Unit 10 - Water Department
Division 02 - Administration Program
5040 Supplies/Hardware 500.00 .00 500.00 .00 .00 512.99 (12.99)103 256.52
5065 Software 2,000.00 .00 2,000.00 .00 .00 179.99 1,820.01 9 .00
5075 Sand & Gravel 2,000.00 .00 2,000.00 .00 .00 459.66 1,540.34 23 .00
5080 Water Meters 325,000.00 .00 325,000.00 .00 .00 218,161.23 106,838.77 67 295,952.25
8020 Building Maintenance 20,000.00 .00 20,000.00 .00 .00 9,679.65 10,320.35 48 10,296.21
8065 Legal Fees 1,500.00 .00 1,500.00 .00 .00 .00 1,500.00 0 .00
8135 Contractual Services 90,000.00 .00 90,000.00 .00 .00 32,359.77 57,640.23 36 33,691.71
8135.008 Settlement Charges .00 .00 .00 .00 .00 20,636.54 (20,636.54)+++13,839.08
8160 Equipment Maintenance 500.00 .00 500.00 .00 .00 .00 500.00 0 18.67
8225 Engineering Fees 40,000.00 .00 40,000.00 .00 .00 9,228.75 30,771.25 23 6,247.50
9401 Administrative Service Charge 175,000.00 .00 175,000.00 .00 .00 87,500.00 87,500.00 50 87,500.00
9905 Transfer to Debt Service 238,022.00 .00 238,022.00 .00 .00 238,022.00 .00 100 237,275.00
Division 02 - Administration Program Totals $1,364,887.00 $0.00 $1,364,887.00 $2,708.18 $0.00 $874,999.82 $489,887.18 64%$901,287.05
Division 30 - Water Distribution Program
1005 Salaries-Full Time 495,000.00 .00 495,000.00 .00 .00 284,271.15 210,728.85 57 264,500.64
1015 Salaries-Part Time 20,000.00 .00 20,000.00 .00 .00 14,322.50 5,677.50 72 5,807.66
1800 Salaries-Overtime 35,000.00 .00 35,000.00 .00 .00 32,519.34 2,480.66 93 23,212.81
2000 FICA 34,100.00 .00 34,100.00 .00 .00 20,027.35 14,072.65 59 17,695.30
2001 Medicare 7,975.00 .00 7,975.00 .00 .00 4,683.80 3,291.20 59 4,138.49
2010 IMRF 60,500.00 .00 60,500.00 .00 .00 25,854.15 34,645.85 43 26,432.28
2020 Employee Insurance 85,000.00 .00 85,000.00 .00 .00 43,339.32 41,660.68 51 52,514.82
2025 Deferred Comp. Contribution 20,000.00 .00 20,000.00 .00 .00 .00 20,000.00 0 .00
4000 Telephone/Internet 5,000.00 .00 5,000.00 .00 .00 597.24 4,402.76 12 1,007.05
4015 Electricity/Gas 150,000.00 .00 150,000.00 .00 .00 110,868.15 39,131.85 74 65,639.18
5005 Office Supplies/Postage 2,000.00 .00 2,000.00 .00 .00 733.47 1,266.53 37 263.28
5010 Replacement Supplies 10,000.00 .00 10,000.00 .00 .00 10,015.83 (15.83)100 7,853.15
5020 Gas/Oil/Mileage/Carwash 20,000.00 .00 20,000.00 .00 .00 8,189.67 11,810.33 41 10,505.57
5040 Supplies/Hardware 10,000.00 .00 10,000.00 .00 .00 14,839.45 (4,839.45)148 6,493.41
5070 Chemicals 10,000.00 .00 10,000.00 .00 .00 2,660.30 7,339.70 27 4,876.46
5095 Uniforms/Clothing 5,000.00 .00 5,000.00 .00 .00 3,852.70 1,147.30 77 2,108.06
8020 Building Maintenance 20,000.00 .00 20,000.00 .00 .00 3,295.17 16,704.83 16 245.60
8060 Vehicle Maintenance 10,000.00 .00 10,000.00 .00 .00 6,301.63 3,698.37 63 3,583.66
8135 Contractual Services 60,000.00 .00 60,000.00 .00 .00 2,658.03 57,341.97 4 2,483.57
8135.003 Lake Michigan Water Purchase 11,200,000.00 .00 11,200,000.00 .00 .00 7,144,268.82 4,055,731.18 64 6,462,977.50
8160 Equipment Maintenance 10,000.00 .00 10,000.00 .00 .00 480.81 9,519.19 5 2,299.79
8185 System Maintenance 90,000.00 .00 90,000.00 .00 .00 67,720.20 22,279.80 75 70,158.04
8194 Water/Fire Hydrant 50,000.00 .00 50,000.00 .00 .00 41,943.27 8,056.73 84 35,550.00
Run by Traci Pleckham on 01/04/2024 02:17:42 PM Page 2 of 5
Budget Performance Report
Fiscal Year to Date 01/04/24
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 YTD
Fund 02 - Water and Sewer Fund
EXPENSE
Unit 10 - Water Department
Division 30 - Water Distribution Program
8200 EPA Analytical 30,000.00 .00 30,000.00 .00 .00 21,007.50 8,992.50 70 12,643.50
9905 Transfer to Debt Service 238,022.00 .00 238,022.00 .00 .00 238,022.00 .00 100 237,275.00
Division 30 - Water Distribution Program Totals $12,677,597.00 $0.00 $12,677,597.00 $0.00 $0.00 $8,102,471.85 $4,575,125.15 64%$7,320,264.82
Unit 10 - Water Department Totals $14,042,484.00 $0.00 $14,042,484.00 $2,708.18 $0.00 $8,977,471.67 $5,065,012.33 64%$8,221,551.87
Unit 11 - Sewer Department
Division 02 - Administration Program
1005 Salaries-Full Time 285,000.00 .00 285,000.00 .00 .00 156,356.68 128,643.32 55 125,795.94
1015 Salaries-Part Time 6,500.00 .00 6,500.00 .00 .00 6,623.18 (123.18)102 1,018.79
2000 FICA 18,075.00 .00 18,075.00 .00 .00 9,925.95 8,149.05 55 7,775.81
2001 Medicare 4,225.00 .00 4,225.00 .00 .00 2,321.27 1,903.73 55 1,818.46
2010 IMRF 32,065.00 .00 32,065.00 .00 .00 13,002.74 19,062.26 41 11,527.68
2020 Employee Insurance 59,000.00 .00 59,000.00 .00 .00 37,095.36 21,904.64 63 29,710.40
2025 Deferred Comp. Contribution 12,000.00 .00 12,000.00 .00 .00 .00 12,000.00 0 .00
3000 Travel/Training 12,000.00 .00 12,000.00 .00 .00 8,051.47 3,948.53 67 8,295.32
3015 IL Unemployment Insurance 2,000.00 .00 2,000.00 .00 .00 572.40 1,427.60 29 513.64
4000 Telephone/Internet 3,000.00 .00 3,000.00 .00 .00 416.64 2,583.36 14 727.30
4005 Cellular Phones 3,500.00 .00 3,500.00 .00 .00 2,105.89 1,394.11 60 1,269.98
5005 Office Supplies/Postage 35,000.00 .00 35,000.00 2,707.37 .00 28,276.24 6,723.76 81 27,218.17
5015 Dues & Subscriptions 70,000.00 .00 70,000.00 .00 .00 64,525.20 5,474.80 92 66,765.46
5020 Gas/Oil/Mileage/Carwash 2,500.00 .00 2,500.00 .00 .00 3.33 2,496.67 0 .00
5040 Supplies/Hardware 3,000.00 .00 3,000.00 .00 .00 519.96 2,480.04 17 1,433.86
8020 Building Maintenance 20,000.00 .00 20,000.00 .00 .00 10,486.49 9,513.51 52 15,129.49
8065 Legal Fees 1,500.00 .00 1,500.00 .00 .00 .00 1,500.00 0 .00
8135 Contractual Services 65,000.00 .00 65,000.00 .00 .00 23,953.93 41,046.07 37 21,235.85
8135.008 Settlement Charges .00 .00 .00 .00 .00 20,642.72 (20,642.72)+++13,842.59
8160 Equipment Maintenance 2,000.00 .00 2,000.00 .00 .00 .00 2,000.00 0 .00
8225 Engineering Fees 15,000.00 .00 15,000.00 .00 .00 35.00 14,965.00 0 1,908.75
9401 Administrative Service Charge 175,000.00 .00 175,000.00 .00 .00 87,500.00 87,500.00 50 87,500.00
9905 Transfer to Debt Service 238,022.00 .00 238,022.00 .00 .00 238,022.00 .00 100 237,275.00
Division 02 - Administration Program Totals $1,064,387.00 $0.00 $1,064,387.00 $2,707.37 $0.00 $710,436.45 $353,950.55 67%$660,762.49
Division 40 - Sewer Treatment Program
1005 Salaries-Full Time 489,000.00 .00 489,000.00 .00 .00 302,865.89 186,134.11 62 250,871.08
1015 Salaries-Part Time 20,000.00 .00 20,000.00 .00 .00 .00 20,000.00 0 5,807.60
1800 Salaries-Overtime 30,000.00 .00 30,000.00 .00 .00 13,787.76 16,212.24 46 13,216.60
2000 FICA 33,420.00 .00 33,420.00 .00 .00 18,971.84 14,448.16 57 16,146.12
2001 Medicare 7,815.00 .00 7,815.00 .00 .00 4,436.75 3,378.25 57 3,776.06
2010 IMRF 59,290.00 .00 59,290.00 .00 .00 26,002.49 33,287.51 44 24,335.80
Run by Traci Pleckham on 01/04/2024 02:17:42 PM Page 3 of 5
Budget Performance Report
Fiscal Year to Date 01/04/24
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 YTD
Fund 02 - Water and Sewer Fund
EXPENSE
Unit 11 - Sewer Department
Division 40 - Sewer Treatment Program
2020 Employee Insurance 90,000.00 .00 90,000.00 .00 .00 54,767.06 35,232.94 61 47,187.17
2025 Deferred Comp. Contribution 20,000.00 .00 20,000.00 .00 .00 .00 20,000.00 0 .00
4000 Telephone/Internet 5,000.00 .00 5,000.00 .00 .00 1,047.78 3,952.22 21 1,958.15
4015 Electricity/Gas 575,000.00 .00 575,000.00 .00 .00 248,302.76 326,697.24 43 224,886.18
5005 Office Supplies/Postage 3,000.00 .00 3,000.00 .00 .00 4,068.15 (1,068.15)136 .00
5010 Replacement Supplies 5,000.00 .00 5,000.00 .00 .00 3,923.16 1,076.84 78 3,154.67
5020 Gas/Oil/Mileage/Carwash 15,000.00 .00 15,000.00 .00 .00 3,561.63 11,438.37 24 8,204.19
5040 Supplies/Hardware 15,000.00 .00 15,000.00 .00 .00 6,165.57 8,834.43 41 5,678.57
5070 Chemicals 180,000.00 .00 180,000.00 .00 .00 99,498.62 80,501.38 55 69,256.28
5075 Sand & Gravel 500.00 .00 500.00 .00 .00 .00 500.00 0 .00
5085 Industrial Flow Monitor 7,000.00 .00 7,000.00 .00 .00 2,262.00 4,738.00 32 2,247.00
5095 Uniforms/Clothing 8,000.00 .00 8,000.00 .00 .00 3,310.07 4,689.93 41 4,844.45
8060 Vehicle Maintenance 10,000.00 .00 10,000.00 .00 .00 3,311.23 6,688.77 33 4,016.65
8135 Contractual Services 300,000.00 .00 300,000.00 .00 .00 192,761.47 107,238.53 64 42,554.21
8160 Equipment Maintenance 30,000.00 .00 30,000.00 .00 .00 12,507.48 17,492.52 42 2,234.55
8185 System Maintenance 120,000.00 .00 120,000.00 .00 .00 16,123.28 103,876.72 13 26,536.73
9905 Transfer to Debt Service 238,022.00 .00 238,022.00 .00 .00 238,022.00 .00 100 237,275.00
Division 40 - Sewer Treatment Program Totals $2,261,047.00 $0.00 $2,261,047.00 $0.00 $0.00 $1,255,696.99 $1,005,350.01 56%$994,187.06
Unit 11 - Sewer Department Totals $3,325,434.00 $0.00 $3,325,434.00 $2,707.37 $0.00 $1,966,133.44 $1,359,300.56 59%$1,654,949.55
Unit 12 - Utility Expansion
Division 91 - Capital
8133.008 Old Town Reconstruction 3,000,000.00 .00 3,000,000.00 .00 .00 1,384,579.41 1,615,420.59 46 692,435.96
8133.009 143rd St. West Extension-Watermain 3,200,000.00 .00 3,200,000.00 .00 .00 6,635.76 3,193,364.24 0 1,063.75
8134.001 Lift Station Improvements 500,000.00 .00 500,000.00 .00 .00 618,855.22 (118,855.22)124 12,497.26
8134.003 Tower Improvements 2,300,000.00 .00 2,300,000.00 .00 .00 .00 2,300,000.00 0 35,738.00
8135 Contractual Services 200,000.00 .00 200,000.00 .00 .00 360.00 199,640.00 0 33,837.02
8225 Engineering Fees 175,000.00 .00 175,000.00 .00 .00 11,784.00 163,216.00 7 5,998.75
9120 Machinery and Equipment 500,000.00 .00 500,000.00 .00 .00 50,685.00 449,315.00 10 434,887.40
9120.200 Machinery and Equipment-ARPA Project-Aeration
Blower
.00 .00 .00 .00 .00 .00 .00 +++1,706,518.06
9125 Vehicles 100,000.00 .00 100,000.00 .00 .00 70,268.74 29,731.26 70 58,963.50
Division 91 - Capital Totals $9,975,000.00 $0.00 $9,975,000.00 $0.00 $0.00 $2,143,168.13 $7,831,831.87 21%$2,981,939.70
Division 92 - Bonds
9200.032 2015 Refunding-2008 Bond (Principal)725,000.00 .00 725,000.00 .00 .00 .00 725,000.00 0 .00
9200.033 2015 Refunding-2008 Bond (Interest)393,750.00 .00 393,750.00 .00 .00 196,875.00 196,875.00 50 211,375.00
9201.001 IEPA Loan (Principal)169,640.00 .00 169,640.00 .00 .00 169,640.34 (.34)100 167,539.55
9201.002 IEPA Loan (Interest)18,367.00 .00 18,367.00 .00 .00 18,366.76 .24 100 20,467.55
Run by Traci Pleckham on 01/04/2024 02:17:42 PM Page 4 of 5
Budget Performance Report
Fiscal Year to Date 01/04/24
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 YTD
Fund 02 - Water and Sewer Fund
EXPENSE
Unit 12 - Utility Expansion
Division 92 - Bonds
9201.003 IEPA Loan L174666 (Principal)146,096.00 .00 146,096.00 .00 .00 81,751.25 64,344.75 56 16,951.39
9201.004 IEPA Loan L174666 (Interest)41,921.00 .00 41,921.00 .00 .00 23,812.95 18,108.05 57 5,234.19
Division 92 - Bonds Totals $1,494,774.00 $0.00 $1,494,774.00 $0.00 $0.00 $490,446.30 $1,004,327.70 33%$421,567.68
Unit 12 - Utility Expansion Totals $11,469,774.00 $0.00 $11,469,774.00 $0.00 $0.00 $2,633,614.43 $8,836,159.57 23%$3,403,507.38
EXPENSE TOTALS $28,837,692.00 $0.00 $28,837,692.00 $5,415.55 $0.00 $13,577,219.54 $15,260,472.46 47%$13,280,008.80
Fund 02 - Water and Sewer Fund Totals
REVENUE TOTALS 28,861,000.00 .00 28,861,000.00 25,931.33 .00 21,850,383.10 7,010,616.90 76%26,601,234.13
EXPENSE TOTALS 28,837,692.00 .00 28,837,692.00 5,415.55 .00 13,577,219.54 15,260,472.46 47%13,280,008.80
Fund 02 - Water and Sewer Fund Totals $23,308.00 $0.00 $23,308.00 $20,515.78 $0.00 $8,273,163.56 ($8,249,855.56)$13,321,225.33
Grand Totals
REVENUE TOTALS 28,861,000.00 .00 28,861,000.00 25,931.33 .00 21,850,383.10 7,010,616.90 76%26,601,234.13
EXPENSE TOTALS 28,837,692.00 .00 28,837,692.00 5,415.55 .00 13,577,219.54 15,260,472.46 47%13,280,008.80
Grand Totals $23,308.00 $0.00 $23,308.00 $20,515.78 $0.00 $8,273,163.56 ($8,249,855.56)$13,321,225.33
Run by Traci Pleckham on 01/04/2024 02:17:42 PM Page 5 of 5
Budget Performance Report
Fiscal Year to Date 01/04/24
Exclude Rollup Account
51