O-23-33
VILLAGE OF DEERFIELD
2024 VILLAGE MANAGER’S BUDGET MESSAGE
Municipal government provides a wide range of basic services on which we all depend: police protection,
drinking water, sewage treatment, snow plowing and building inspection to name a few. The ability of an
elected board to supply these services in an effective and efficient manner depends on its financial decisions.
That is why of all issues considered by the Village Board over the course of a year none is more important than
adoption of the annual budget. This budget reflects operations from January 1, 2024 through December 31,
2024. This budget meets all state mandated accounting and financial reporting requirements.
The total expenditure budget for fiscal year 2024 is $59,735,938 which represents a 4.2% increase from last
year’s budget. This year’s expenditure increase is primarily due to a general increase in the cost of goods and
services, one-time expenditures such as equipment purchases and budget roll overs due to supply chain
delays. General Fund transfers include $1,091,700 to the Refuse Fund, which represents a 3.5% increase from
last year and reflects the property tax levy for this fund that has been reallocated to the General Fund since
2015. No new debt is anticipated in 2024. Funding for 2024 capital projects includes $3,990,000 in MFT and
$3,495,000 in IRF funds for a total of $7,485,000.
The operating component of the budget is $35.8 million, which is a 6.69% increase from the prior year. The
increase in the operating component is due primarily to contractual increases in personnel services, and other
contractual services and commodities.
Prior to COVID-19, programs and service levels had been largely stable over the past decade and the budget
prioritizes these activities as well as capital project funding that rebuilds an aging infrastructure. Reflecting the
volatile economic conditions locally and statewide and a relatively stable but growing population, the Village
continues to provide a high level of service with minimal staffing. For several years, the Village maintained
vacancies and operated with a reduced workforce. The Village continues to evaluate workforce needs as
positions are vacated through attrition and demands for service evolve with changing demographics and
technology. In 2024, there are multiple promotions and new positions created. This includes the creation of a
new IT Systems Specialist position and filling the Administrative Assistant position in Public Works which has
been vacant for multiple years. In addition, the recently vacated Police Communications Supervisor role will be
filled by a sworn police officer with another sworn police officer hired to fill the old position.
PLANNING PROCESSES
The Board has determined that a continued program of replacing and maintaining the infrastructure of the
Village remains a key priority. The 2011 Qualified Energy Conservation Bonds will once again be abated in the
total amount of $359,239. In 2020, the 2010A bonds were refunded resulting in a total estimated savings of
$899,860 over the next 10 years. In 2021, the Village refunded its 2011A, 2012 & 2013 bonds resulting in a
total estimated savings of $1.695 million over the next 10 years. The total Village levy will increase 2.3% to
$8,422,932.
The uncertainty around COVID-19 and its impact on the economy as well as the fiscal position of the State of
Illinois and the continued legislative uncertainties in Springfield played a major role in the budget deliberations
this year. As the impact of COVID-19 on the local economy begins to decline, the budget assumes a modest
increase in sales tax, home-rule sales tax, and food and beverage tax. However, the budget includes flat hotel
tax revenue which is still well below pre-pandemic levels.
The budget continues to reflect a state-imposed revenue cut to the Local Government Distributive Fund and a
1.5% administrative fee on Home Rule Sales Tax receipts received by the Village when compared to 2018 but
revenue figures are budgeted for a slight increase when compared to last year. State income tax is distributed
on a per-capita basis and with the completion of the 2020 Census the Village has experienced a population
growth to 19,196 permanent residents. For the past three years, the Village received 6 total payments of
approximately $206,000 each as part of the State’s Rebuild Illinois Program. Two payments were received in
2020, 2021 and 2022 for a total of approximately $1.236 million. The Rebuild Illinois Program funding will be
used to fund a portion of the 2024 capital program. Due to past budgeting decisions, a low tax composition
relative to other similarly situated communities, conservative spending practices, the relative strength of the
micro economy in Deerfield, and our strong fund balance, the Village has not had to implement the drastic
personnel and program reductions that many local governments have found necessary. The Village has
selectively filled open employee positions, implemented departmental reorganizations to gain efficiencies and
eliminated unfilled full-time positions when possible.
Just over ten years ago, the Village Board undertook a comprehensive review of the Village’s Water and Sewer
Funds to address their structural deficits. Due to lower water usage that affects both water and sewer revenues,
the Board approved a revenue plan that strategically increased water and sewer revenues to reverse the
negative revenue projections. These rate increases along with strategic personnel changes and the completion
of the water meter replacement project have eliminated the structural imbalance that previously affected these
funds. This budget reflects growth in the Water Fund and the Sewer Fund is projected to end the year with a
positive fund balance, albeit a lower balance than at the beginning of the year. In 2021, Baxter & Woodman
conducted a comprehensive rate analysis and recommended several years of rate increases to keep pace with
increased costs and to build adequate reserves, especially in the Sewer Fund over the next five years. This
year’s budget includes a 4% increase in the Water user fee and a 4% increase in the Sewer user fee.
The Deerfield Public Library remodeling project required the Village to issue approximately $12 million of GO
debt several years ago. Funding for this debt service, endorsed by the voters in the November 2010
referendum, comes from a combination of Library general revenues, fund balance and property taxes. All the
debt is general obligation as the Village has unlimited home rule authority to raise taxes and enjoys a Aaa bond
rating from Moody’s, which was once again reaffirmed in 2021.
The Village organizes its budget under several funds. Following are brief highlights of each major fund.
GENERAL CORPORATE FUND
This is the basic operating fund of the Village, which includes revenues and expenditures of all governmental
activities, except those funds that must be accounted for independently under Illinois law.
Revenues: The General Fund has projected new revenues of $25,551,490 which is a 3%
increase over last year’s budget. The General Fund property tax levy is $4,220,740
and reflects a $162,337 or 4% increase over last year. The entire property tax levy
remains in the General Fund to support public safety. The Sales Tax revenues reflect
a 4% increase as this revenue stream stabilized and is less volatile than it was during
the height of COVID-19. The Hotel Room Tax is projected to remain flat, as business
travel and leisure and convention activity have been especially impacted by COVID-
19 due to travel restrictions, limitations on large-scale gatherings and the conversion
of business activity to remote/online meetings. Hotel/Motel Tax is budgeted at $1.5
million, which is approximately 60% of the pre-COVID figures which approached $2.5
million in revenue. The state shared income tax is expected to increase $400,000
(16%) as the Village has experienced population growth over the last 10 years and
the economy recovers from COVID-19. Building permit revenue is budgeted at $1.1
million due to historic performance and the continued strong residential and
commercial remodeling activity that the Village has experienced in recent years.
Multiple large-scale housing projects have been proposed in 2023 and 2024 and may
lead to a large increase in permit fees if approved. The telecom tax is expected to
decrease by 16.67% to $1 million as the number of lines decreases and the tax does
not apply to data transfers. Overall, revenues and reserves are sufficient to cover the
operating costs of the fund.
Expenditures: Total expenditures for the General Corporate Fund are budgeted at $28,137,348
which is an 4.2% increase from last year's budget. There are no General Fund
transfers to the Infrastructure Replacement Fund this year in part due to the use of
over $1,200,000 in Rebuild Illinois Grants that were accumulated over the past three
years. Additionally, $1,091,700 is being transferred from the General Fund to the
Scavenger Fund to support waste hauling operations since the property tax levy was
eliminated in the Scavenger Fund in recent years. The Walgreen sales tax rebate
expense in the Finance Department budget reflects a slight increase and totals
$3,325,000 and is consistent with Walgreen’s sales and production levels achieved
recently. $125,000 is projected for the fifth year of the sales tax rebate with Jewel-
Osco. A tax rebate for Shake Shack totaling $45,000 had also been added. There is
a 5.8% increase in PPO employee health insurance charges and a 11.1% increase
in HMO employee health insurance charges and 3.4% decrease to dental insurance.
Personnel costs reflect a wage increase of 4% for non-union employees, which is
consistent with the wage increases recently negotiated with the two unions. A four-
year contract was negotiated with the Illinois Council of Police (Police Patrol Officers)
and the Illinois Union of Operating Engineers (IUOE Local 150 – Public Works)
commencing on January 1, 2023. Village operations are very labor intensive. The
largest single operating cost relates to personnel, representing 70% of the General
Fund less economic incentive payments, transfers to the Infrastructure Replacement
Fund (IRF) and Scavenger Fund. Highlights of this year’s expenditure budget include:
The Walgreen’s incentive expense is budgeted at $3.2 million. Since the Village
receives 20% of the revenue from this agreement, as Walgreen’s activity
changes the expense changes, and this is offset by a similar move in the sales
tax revenue line. Total economic incentive expenses are budgeted at $3.3 million.
The original Economic Incentive Agreement with Walgreens National was
negotiated in 2001 and was set to expire on December 31, 2021. In April of 2021,
the Village and Walgreens National extended the Economic Incentive Agreement
for 10 additional years, ending December 31, 2031, and includes two additional
five-year renewals.
$1,091,700 General Fund transfer to the Scavenger Fund.
A 4% increase in wages to both union and non-union personnel consistent with
the approved collective bargaining agreements.
WATER AND SEWER FUNDS
The water and sewer utility systems operated by Deerfield are intended to be self-funding, based upon user
charges for services. Revenues for operations are derived primarily from services furnished to utility customers.
Other sources are interest earnings from cash invested on a short-term basis, and connection fees from new
construction where the Village's prior investments in its utilities operate to the advantage of new customers
who did not share in that initial investment.
Water Budget: Expenditures are budgeted at $6,107,395 (6.4%) against new revenues of
$5,993,500 (3.8%). The expenditure level continues to reflect investments in water
infrastructure as the water meter head replacement project is ongoing and augments
the meter change outs that were completed several years ago. The Village continues
to see a decrease in revenue when compared with historical usage due to a
fundamental reduction in the average usage. The Village has received 12-15% rate
increases from Highland Park since 2019 with the exception of 2021 when the
increase was 0% due to COVID-19 impacts. For 2024-2028 Highland Park is
expected to pass on wholesale increases of 6.5% as Highland Park pays debt service
associated with the recent rehabilitation of their water treatment facility. This budget
includes a pass through of the wholesale rate increases resulting in a 4% increase in
water user rates for Deerfield customers from $6.23 to $6.46 per 100 cubic feet
effective January 1. The fund will end 2023 with a positive cash balance. It will be
imperative that the Village keep pace with wholesale rate increases to maintain a
positive position in this fund in future years.
Sewer Budget: The Sewer Fund expenditures are budgeted at $5,279,381 (6.4%) against new
revenues of $5,139,628 (3%). In 2021, the total number of units consumed were
adjusted down to better reflect historical consumption and that is the reason that
budgeted revenues in 2021 and 2022 are less than prior years. No substantial capital
expenditures are included in this budget; these are in the IRF. As discussed further
below, the sewer rate will be increased 4% from $4.01 to $4.17 per 100 cubic feet
effective January 1.
The Village Board has considered the structural deficits that have previously existed in these funds and their
inability to cover all operating and capital costs through the revenue base. In 2021, Baxter & Woodman
conducted a comprehensive rate study to analyze the funds and made recommendations to the Village Board
to keep the funds in a healthy financial position. The decision remains to fund operations entirely from user
charges and to fund the capital expenses through the IRF. Over the last decade, the Board has implemented
several strategic changes in the Water Fund, which helped return the fund to a positive balance. User rate
increases in recent years have better reflected true operational expenses, an accelerated meter change out
program was completed in 2023 bringing greater efficiency to the operation, and major capital improvements
have been completed that significantly reduced the amount of non-revenue water in the Village. In particular,
the replacement of aging commercial meters this year will have a large impact on the accuracy of water reading
and billing. In addition, the annual sewer lining program has lined over 20 miles of sewers and dramatically
reduces the risk of sewer failures and the large expense of point repairs. While some of these strategies come
with an inherent cost they have helped the Village achieve the goal of bringing the Water and Sewer Fund back
to a positive annual cash flow. At the end of 2024, the Water Fund is projected to end with a balance of
$1,726,799. 2019 was the first time the Water Fund ended the year with a positive cash balance in nearly a
decade. As projected, strategic user rate increases in the Sewer Fund over the last ten years have returned
the fund to a positive position. The Sewer Fund will end the year with a fund balance of $1,020,321. The
reduction in units consumed has a significant impact on the Sewer Fund and future increases in this fund will
needed to keep pace with operating costs.
SCAVENGER (REFUSE) FUND
In 2021, the Village bid and awarded waste hauling services to Lake Shore Recycling Systems that will save
the Village approximately $250,000 over the five-year contract term. This year, the Refuse Fund user rate
reflects an increase of 3.5%. The waste hauler contract includes an increase between 2% and 3.5% effective
May of each year. Seven years ago, the property tax levy for this fund was reallocated to the General Fund
and replaced by an inter-fund transfer. The inter-fund transfer totals $1,091,700 which also reflects a 3.5%
increase from last year. The user rate will increase from $8.32 to $8.62 per month per household. This fund will
use $57,143 from reserves to fund operations this year, leaving a reserve balance of $871,606 at the end of
the year.
MOTOR FUEL TAX FUND
The MFT budget projects State allotments of $840,000 in 2024. After saving MFT funds for multiple years, the
Village will use $3,990,000 in funding for the street rehab program. The long-term outlook on MFT revenues
remain uncertain as the State continues to face their own fiscal challenges.
PENSION FUNDS
For employees covered by the Illinois Municipal Retirement Fund, the Village contributed 7.60% (a very slight
increase from 7.59% in 2023) of each employee’s eligible pay plus the employer's contribution of 7.65% for
Social Security and Medicare coverage. The employee contributes 4.5% for IMRF and 7.65% for Social
Security and Medicare coverage. The employer’s contribution to the Police Pension Fund is also expensed
through the Police Department budget and is financed through General Fund revenues. The contribution is
actuarially determined as adequate for funding pension payments and for amortizing the actuarial reserve
deficiency. Sworn police covered by this fund contribute 9.91% of their basic wages but do not participate in
Social Security. Additional income is derived from investment earnings. In 2023, the Village contributed the
full budgeted amount of $1.1 million rather than only the actuarially determined required amount of $1,082,673.
The additional contribution to the Police Pension Fund enhances the Village’s commitment to funding for rating
agencies and allows for increased investment options. The Village expects the near-term contributions to
increase slightly each year barring any large changes in investment results.
The Village is committed to making 100% of its annual required contribution to the pension funds. Contributions
are expensed within each operating fund/department/division that has corresponding salary expense.
CAPITAL PROJECTS
The most obvious benefit of establishing a capital budget is the reinforcement of planning at all levels. It is an
extremely valuable decision-making device used to 1) stabilize the volume of capital improvements at some
relatively uniform level, and 2) coordinate the capital costs and their financing with the attendant debt service
demands on the operating budget.
The rolling five-year capital plan has been extremely helpful both in scheduling major projects and in
determining their financing. More than any other part of the budget, capital projects warrant detailed discussion
between Board and staff. Good financial management dictates that we review closely the major expenditures
required in the future to maintain the community's infrastructure. Once long-range plans and projects are
determined, priorities must be set and a funding program approved.
The 2021 capital plan was significantly reduced as a result of the revenue impacts from COVID-19 but the
proposed 2022-2024 capital plan funding resumes normal levels of activity. Accordingly, the Village Board
issued $7 million in bonds that are intended to supplement funding for the two-year capital plan program for
2022 and 2023. The two-year program totaled approximately $15.7 million of capital improvements.
$7,922,000 is budgeted in the Infrastructure Replacement Fund to cover capital expenditures for 2023, with
$1.26 million coming from a federal grant and $1,350,000 coming from a State of Illinois DCEO reimbursement
from the 2019 Woodland Park project.
In 2024 the Village is not proposing any new debt, rather projects are expected to be funded through use of
Motor Fuel Tax (MFT) and Rebuild Illinois (RBI) funds. Both funding sources are managed through the Illinois
Department of Transportation and are required to follow strict guidance through their Bureau of Local Roads
and Streets. The Village is able to make this proposal due to multi-year planning for the use of these funds as
well as the recent addition of Surface Transportation Funds (STP) of $4.7 million for the proposed
reconstruction of Hazel Avenue in 2025. The total expenditure for Capital Improvements in 2024 is
approximately $7.485 million.
Major capital projects scheduled for 2024 include (costs shown are Village totals for the fiscal year):
Continuation of the Street Rehabilitation Program ($4,000,000 MFT and RBI)
Deerfield Rd and Warwick Road Pump and Hatch Replacement project ($1,000,000 IRF)
Sanitary and Storm Sewer Lining ($500,000 IRF)
Village Green initiatives ($250,000 IRF)
Salt Building Roof Replacement ($300,000 IRF)
The demand for capital improvements continues to be a pressing need and the 2024 program year reflects a
significant investment in these services. A $10 million bond issuance and a $2.5 million bond issuance were
approved in 2015 and 2017, respectively, in order to meet funding levels for the recently completed three-year
capital improvement program (2015-2017). A $6 million bond issuance was approved in 2019 to cover capital
projects for 2018 and 2019, totaling approximately $12 million in improvements.
As previously noted, an additional $7 million in bonds were issued in 2021 to supplement funding for capital
improvements slated for 2022 and 2023. In addition to MFT and RBI funds, the 2024 program will be funded
through a combination of Food and Beverage Tax receipts, ¼ of the Home Rule Sales Tax receipts,
Infrastructure Maintenance Fee, and interest earnings.
In summary, this year’s program will require the full attention of staff and these capital improvements have been
prioritized to address areas that are in need of roadway improvements as well as underground utility
improvements. The work has also been planned in a way that will minimize disruption to the motoring public as
much as possible. The street rehab program has been maintained while critical capital improvements will also
be completed on the Deerfield Road and Warwick Road pumping stations. In recent years, significant road
and/or water system improvements have been completed on Waukegan Road, Charing Cross, Gordon
Terrace, Greenwood Avenue East, in the Woodland Park Area Subdivision (Woodland, Hawthorne, Oakwood,
Woodbine), the elevated tank, Deerfield Road, Pfingsten/Kate’s Bridge, Brierhill Road, North Avenue, Deer
Lake/Estate Drive, North Trail Subdivision, and the Briarwood Vista Subdivision. Prior to that roadway
improvements were completed at Lake Eleanor/Heather Road project, Carlisle/Carriage Way Infrastructure
Improvement Project, and the Lake Cook Road Widening and Reconstruction Project.
VEHICLE/EQUIPMENT REPLACEMENT FUND
This fund includes purchases of vehicles and equipment amounting to more than $5,000. Each operating
department is charged an annual amount to offset these more expensive items from impacting the budget in
any one given year. This year's proposed expenditures amount to $1,841,840. This fund’s expenditures vary
widely year to year depending on the replacement schedule for a given year. Due to continued supply chain
delays, it has become difficult to pre-order and schedule deliveries for vehicles.
ASSESSED VALUATION
Over the past ten years, the taxable assessed valuations have changed as follows:
Year Amount * % Change
2013 1,228,417,175 -5.0
2014 1,227,301,586 -0.1
2015 1,319,070,388 7.4
2016 1,407,512,362 6.0
2017 1,468,241,454 4.3
2018 1,460,222,579 -0.5
2019 1,524,116,833 4.3
2020 1,479,532,161 -2.9
2021 1,466,012,476 -0.9
2022 1,520,213,882 3.5
DEBT SERVICE FUND
As an Illinois Home Rule community by referendum, the Village has no legal debt limit and is authorized to
issue debt without any requirement for a local referendum.
In 2021, the Village issued $7 million of additional GO Bonds in coordination with the refunding of the 2011A,
2012 and 2013 bonds. The refunding portion resulted in total estimated savings of $1.695 million over the next
ten years. Similarly, in 2020, the Village issued $6.28 million of GO bonds to refund the 2010A (Build America)
bonds resulting in a total savings of $899,860 over the next decade. In 2018, the Village issued $5.97 million
of GO bonds and the full debt service amount associated with the issuance was abated. 2020 was the first time
the debt service amount of $438,330 associated with the 2018 bond issuance appeared on the tax bills. In
2017, the Village refunded $3.215 million of 2008 GO bonds and issued approximately $2.485 million in new
debt to complete the accelerated three-year (2015 – 2017) capital improvement plan. The Village currently has
six outstanding GO debt issues, $12.48 million of 2011 Series B, $6.185 million of the 2015 Series, $4.06 million
of the 2017 Series, $4.84 million of the 2018 Series, $4.62 million of the 2020 Series and $16.97 million of the
2021 Series. In addition, the Village has outstanding debt of $4.545 million relating to the Library improvement
project, which is supported by the Library’s property tax payers. As of December 31, 2023, Deerfield's total
outstanding bonded General Obligation debt of $53,700,000 is 3.66% of its total 2021 assessed
valuation. When considering that, in Illinois, non-Home Rule communities are allowed a ratio of 8.6%, the
Village, as a Home Rule community, can be proud of its low debt service obligations.
Deerfield currently has a Aaa rating from Moody's Investors Service, Inc., an accomplishment shared by few
municipalities in the United States. This rating was reaffirmed in October 2021. The Village Board has indicated
that it will examine the financial status of the Village each year prior to the final adoption of the annual tax levy
with a preference for abating debt service requirements for the Qualified Energy Conservation Bonds. The
Village Board used federal credits of $359,239 to abate a portion of the 2023 required Property Tax Levy
resulting in a total debt service property tax levy of $4,202,192.
PROPERTY TAX LEVY
The 2023 Property Tax Levy, collected in 2024, for all Village funds is $8,422,932. The levy reflects a 2.2%
increase from the extended 2022 levy. As discussed above, this includes abatements only for debt service
associated with the Qualified Energy Conservation Bonds. The 2023 levy is distributed as follows: $4,220,740
to the General Fund and $4,202,192 for the various GO debt service requirements, which relate to the
wastewater treatment plant reconstruction project and other various capital projects. Village property taxes for
2023 represent approximately 6% of the total property tax bill in the Village.
The Library levy is slightly higher year-over-year and totals $5,297,200. This levy was approved by the Library
Board and accepted by the Village Board, as statutorily required.
SUMMARY
Preparing the annual budget is a very thorough and time-consuming process and one that the Village Board
takes very seriously. As fellow taxpayers, they too want to hold the line on taxes, but without sacrificing the
number and quality of services rendered and making sound investments in infrastructure.
I wish to acknowledge the efforts of the Village Board and all departments in compiling this document, and to
thank them for their professional support. Special thanks are extended to the Director of Finance and all finance
department personnel who do the majority of the budget preparation. We hope that you find it both informative
and helpful in implementing our financial plan for fiscal period between January 1, 2024 and December 31,
2024.
KENT STREET
Village Manager
2022 2023 2023 2023 Percent Dollar
Fund Levy Levy Abatements Net Change Change
Purpose Extended Budget (Reduction)Levy (22 g 23)(22 g 23)
General Fund $4,058,403 $4,220,740 $0 $4,220,740 4.00%$162,337
Scavenger Fund 0 0 0 0 -0
Infrastructure 0 0 0 0 -0
Debt Service Fund 4,175,792 4,561,431 359,239 4,202,192 0.63%26,400
Total Village Levies 8,234,195 8,782,171 359,239 8,422,932 2.29%188,737
Library 4,382,500 4,607,500 0 4,607,500 5.13%225,000
Library Debt Service 687,450 689,700 0 689,700 0.33%2,250
Total 13,304,145 14,079,371 359,239 13,720,132 3.13%415,987
11/7/2023
Village of Deerfield - Exhibit A
2023 Property Tax Levy with comparison to 2022
2023_WORKSHEET updated 2022 EAV.xls
Exhibit B
2023 Property Tax Levy with Five Year Comparison
Proposed
Fund 2019 2020 2021 2022 2023
General 3,677,437 3,752,222 3,902,311 4,058,403 4,220,740
Scavenger 0 0 0 0 0
Infrastructure 0 0 0 0 0
Debt Service (net)4,197,136 4,122,351 4,155,492 4,175,792 4,202,192
Total Village 7,874,573 7,874,573 8,057,803 8,234,195 8,422,932
Library 5,113,331 5,113,331 5,066,450 5,069,950 5,297,200
Combined Levy 12,987,904 12,987,904 13,124,253 13,304,145 13,720,132
Tax Rate History
EAV 1,524,116,833 1,479,532,161 1,466,012,476 1,520,213,882 1,550,618,160
Tax Rate( per $100)(est)
Village (blended)0.517 0.532 0.550 0.542 0.543
Library (blended)0.335 0.346 0.346 0.334 0.342
Combined 0.852 0.878 0.895 0.875 0.885
11/7/2023
2023_WORKSHEET updated 2022 EAV.xls
Corporate Corporate Corporate Corporate Corporate Corporate Corporate
QECB Purpose Purpose Purpose Purpose Purpose Purpose Purpose
2011B 2015 2017 2018 2020 2020 2021 2021
WRF non-WRF WRF non-WRF WRF Total
Debt Service Levies $1,225,000 $673,750 $438,438 $438,330 $298,185 $447,278 $317,000 $723,450 $4,561,431
Abate from:
General Fund 0
BAB Rebate 0
QECB Rebate 359,239 359,239
Total Abatement 359,239 0 0 0 0 0 0 0 359,239
Net Levy $865,761 $673,750 $438,438 $438,330 $298,185 $447,278 $317,000 $723,450 $4,202,192
11/7/2023
Exhibit C - Abatement Analysis - Debt Service - 2023 Levy
2023_WORKSHEET updated 2022 EAV.xls
Exhibit D
2022 Property Tax Levy with Three Year Projection
Proposed Projected Projected Projected
Fund 2022 2023 2024 2025 2026
General 4,058,403 4,220,740 4,389,569 4,565,152 4,747,758
Scavenger 0 0 0 0 0
Infrastructure 0 0 0 0 0
Debt Service (net)4,175,792 4,202,192 4,204,142 4,222,542 4,241,542
Total Village 8,234,195 8,422,932 8,593,711 8,787,694 8,989,300
Library 5,069,950 5,297,200 5,509,088 5,729,452 5,958,630
Combined Levy 13,304,145 13,720,132 14,102,799 14,517,145 14,947,930
Tax Rate History
EAV 1,520,213,882 1,550,618,160 1,581,630,523 1,613,263,133 1,645,528,396
Tax Rate( per $100)(est)(est)(est)(est)
Village 0.542 0.543 0.543 0.545 0.546
Library 0.334 0.342 0.348 0.355 0.362
Combined 0.875 0.885 0.892 0.900 0.908
2024 through 2026 projections include 4% increases in the General and Library levies. Actual
levies will be determined in future years.
2023_WORKSHEET updated 2022 EAV.xls
2022 Village Tax $902.75
2023 Village Tax $923.44
2024 Village Tax $942.16
2025 Village Tax $963.43
2026 Village Tax $985.53
11/7/2023
Village-Only Tax Levy
Exhibit E
($500,000 market value)
Effect on a Median Priced House
2023_WORKSHEET updated 2022 EAV.xls
1/1/2023 12/31/2023
AUDITED PROJECTED PROJECTED
BEGINNING NEW PROJECTED ENDING
FUND FUND BALANCE REVENUES EXPENDITURES FUND BALANCE
General $22,798,398 $25,854,653 $24,881,320 $23,771,731
Sewer 1,275,811 4,936,948 5,052,685 1,160,074
Water 1,416,803 5,841,500 5,417,609 1,840,694
Garage 905 460,000 455,475 5,430
Subtotal "Operational" Funds $25,491,917 $37,093,101 $35,807,089 $26,777,929
MFT 2,608,416 900,000 - 3,508,416
Refuse (Solid Waste)907,057 1,680,800 1,659,108 928,749
Debt Service 278,348 4,527,481 4,501,681 304,148
2011B Debt Service Sinking Fund 7,056,320 840,000 1,200 7,895,120
Infrastructure
Replacement (inc. Bond Proc)7,660,584 2,310,200 7,799,000 2,171,784
Parking Lots (125,645) 158,000 229,300 (196,945)
Vehicle & Equipment
Replacement 5,864,190 1,153,186 801,725 6,215,651
COMBINED VILLAGE FUNDS $49,741,187 $48,662,768 $50,799,103 $47,604,852
Police Pension $55,549,935 7,312,100 3,637,000 $59,225,035
Certain funds are restricted in that available funds may only be used
for expenditures allowed within said fund. Figures for proprietary funds represent available cash balances.
VILLAGE OF DEERFIELD
2023
BUDGET SUMMARIES BY FUND
1/1/2024 12/31/2024
PROJECTED PROJECTED
BEGINNING BUDGET NEW BUDGET ENDING
FUND FUND BALANCE REVENUES EXPENDITURES FUND BALANCE
General $23,771,731 $25,551,490 $28,160,348 $21,162,873
Sewer 1,160,074 5,139,628 5,279,381 1,020,321
Water 1,840,694 5,993,500 6,107,395 1,726,799
Garage 5,430 490,000 489,000 6,430
Subtotal "Operational" Funds $26,777,929 $37,174,618 $40,036,124 $23,916,423
MFT 3,508,416 840,000 3,990,000 358,416
Refuse (Solid Waste)928,749 1,723,200 1,780,343 871,606
Debt Service 304,148 4,541,131 4,530,331 314,948
2011B Debt Service Sinking Fund 7,895,120 800,000 51,500 8,643,620
Infrastructure
Replacement (inc. Bond Proc)2,171,784 2,115,000 3,495,000 791,784
Parking Lots (196,945)146,500 218,100 (268,545)
Vehicle & Equipment
Replacement 6,215,651 1,037,030 1,841,840 5,410,841
COMBINED VILLAGE FUNDS $47,604,852 $48,377,479 $55,943,238 $40,039,093
Police Pension $59,225,035 2,805,000 3,792,700 $58,237,335
Certain funds are restricted in that available funds may only be used
for expenditures allowed within said fund. Figures for proprietary funds represent available cash balances.
Available balance is based on estimated prior year end totals.
VILLAGE OF DEERFIELD
2024
BUDGET SUMMARIES BY FUND
BUDGET SUMMARY - FOUR YEAR COMPARISON
YR.END YR.END BUDGET EST.YR.END BUDGET % CHG BUDG
FUND/REVENUE SOURCE 2021 2022 2023 2023 2024 23->24
GENERAL FUND (10)
Taxes-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-Corporate Property 3,659,999 3,992,211 4,058,403 4,058,403 4,220,740 4.00%
-Sales 7,983,200 6,390,184 5,282,500 5,000,000 5,400,000 2.22%
-Home Rule Sales 5,267,788 3,964,695 3,100,000 3,125,000 3,425,000 10.48%
-Hotel/Motel 1,120,137 1,837,893 1,500,000 1,500,000 1,500,000 0.00%
-State Income 2,483,841 3,127,937 2,500,000 2,800,000 2,900,000 16.00%
-State Use Tax 726,161 777,978 710,000 750,000 750,000 5.63%
-Pers. Prop. Replace.247,245 500,261 250,000 425,000 250,000 0.00%
-Telecommunications Tax 1,171,660 932,501 1,200,000 1,000,000 1,000,000 -16.67%
-Electric Utility Tax 1,078,509 1,066,336 1,100,000 1,100,000 1,100,000 0.00%
Fines--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-Court/Local Ordinance 171,789 139,405 142,500 125,000 154,500 8.42%
License Fees----------------------------------------------------------------------------------------------------------------------------------------------------------------
-Business 23,504 66,961 45,500 45,500 45,500 0.00%
-Liquor 32,838 53,550 60,000 60,000 60,000 0.00%
-Vehicle 344,250 333,513 340,000 330,000 330,000 -2.94%
-Other 1,550 1,475 3,000 3,000 3,000 0.00%
Permit Fees------------------------------------------------------------------------------------------------------------------------------------------------------------------
-Building 1,083,490 1,022,558 1,100,000 1,100,000 1,100,000 0.00%
-Other 6,250 21,350 20,000 20,000 20,000 0.00%
Inspection Fees-------------------------------------------------------------------------------------------------------------------------------------------------------------
-Engineering 10,161 0 200,000 60,000 260,000 30.00%
Other--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-Dispatching Services 620,428 716,632 1,240,000 1,240,000 540,000 -56.45%
-Interest Earned (net)(2,984)111,860 125,000 1,000,000 500,000 300.00%
-Special Police Services 274,372 318,120 303,000 308,000 303,000 0.00%
-Activity Donations 2,446 15,992 35,000 31,000 35,000 0.00%
-Grants 44,048 126,556 65,000 105,000 345,000 430.77%
-Transfers In 264,009 196,962 293,250 243,250 293,250 0.00%
-Cable Franchise Fees 437,295 441,364 450,000 450,000 450,000 0.00%
-Auction Proceeds 1,955 680 7,500 2,500 7,500 0.00%
-Rental Income 286,592 198,162 305,000 305,000 305,000 0.00%
-False Alarm Fees 17,650 16,550 15,000 15,000 15,000 0.00%
-Miscellaneous 1,382,120 459,819 317,696 653,000 239,000 -24.77%
TOTAL NEW REVENUE 28,740,303 26,831,505 24,768,349 25,854,653 25,551,490 3.16%
Adjustment (To)
From Fund Balance (4,233,232)(1,875,779)2,178,902 (973,333)2,608,858 19.73%
TOTAL EXPENDITURES 24,507,071 24,955,726 26,947,251 24,881,320 28,160,348 4.50%
WATER FUND (50)
-Water Sales 5,432,367 5,407,874 5,607,000 5,600,000 5,832,000 4.01%
-Interest Earned (366)50,862 4,500 45,000 10,000 122.22%
-Miscellaneous/contributions 670,539 742,479 151,500 196,500 151,500 0.00%
TOTAL NEW REVENUE 6,102,540 6,201,215 5,763,000 5,841,500 5,993,500 4.00%
Adjustment (To)
From Retained Earnings (461,114)(526,890)(49,401)(423,891)113,895 -330.55%
TOTAL OPERATING EXPENSES 5,641,426 5,674,325 5,713,599 5,417,609 6,107,395 6.89%
BUDGET SUMMARY - FOUR YEAR COMPARISON
YR.END YR.END BUDGET EST.YR.END BUDGET % CHG BUDG
FUND/REVENUE SOURCE 2021 2022 2023 2023 2024 23->24
SEWER FUND (54)
-Sewer Use Fees 3,310,267 3,220,927 3,276,300 3,200,000 3,406,700 3.98%
-Interest Earned (183)1,443 5,000 45,000 20,000 300.00%
-Miscellaneous/transfers in/contributions 2,140,719 2,596,203 1,699,848 1,691,948 1,712,928 0.77%
TOTAL NEW REVENUE 5,450,803 5,818,573 4,981,148 4,936,948 5,139,628 3.18%
Adjustment (To)
From Retained Earnings (744,796)(873,589)20,635 115,737 139,753 577.26%
TOTAL OPERATING EXPENSES 4,706,007 4,944,984 5,001,783 5,052,685 5,279,381 5.55%
MOTOR FUEL TAX FUND (14)
-Intergov. Transfer In 1,148,335 1,174,486 750,000 800,000 800,000 6.67%
-Interest Inc./Misc.(387)4,699 10,000 100,000 40,000 300.00%
TOTAL NEW REVENUE 1,147,948 1,179,185 760,000 900,000 840,000 10.53%
Adjustment (To)
From Fund Balance (598,413)(1,179,185)(760,000)(900,000)3,150,000 -514.47%
TOTAL EXPENDITURES 549,535 0 0 0 3,990,000 N/A
GARAGE FUND (70)
-Charges for Service 466,497 447,805 395,000 450,000 480,000 21.52%
-Interest Earned/Misc.11,647 13,193 10,000 10,000 10,000 0.00%
TOTAL NEW REVENUE 478,144 460,998 405,000 460,000 490,000 20.99%
Adjustment (To)
From Fund Balance 11,295 (26,890)69,100 (4,525)(1,000)-101.45%
TOTAL EXPENDITURES 489,439 434,108 474,100 455,475 489,000 3.14%
POLICE PENSION FUND (80)
-Employer Contribution 1,100,000 1,100,000 1,100,000 1,100,000 1,100,000 0.00%
-Employee Contrib.450,777 521,477 450,000 512,000 505,000 12.22%
-Invest. Income 8,052,433 (8,588,554)1,200,000 5,700,100 1,200,000 0.00%
TOTAL NEW REVENUE 9,603,210 (6,967,077)2,750,000 7,312,100 2,805,000 2.00%
Adjustment (To)
From Fund Balance (6,280,696)10,383,556 925,900 (3,675,100)987,700 6.67%
TOTAL EXPENDITURES 3,322,514 3,416,479 3,675,900 3,637,000 3,792,700 3.18%
DEBT SERVICE FUND (35)
-Property Taxes 3,330,668 3,526,810 3,450,792 3,450,792 3,477,192 0.77%
-Interest Earned/Misc./BAB credit 11,286,838 1,052,898 1,052,689 1,076,689 1,063,939 1.07%
TOTAL NEW REVENUE 14,617,506 4,579,708 4,503,481 4,527,481 4,541,131 0.84%
Adjustment (To)
From Fund Balance (262,792)(103,403)(1,800)(25,800)(10,800)500.00%
TOTAL EXPENDITURES 14,354,714 4,476,305 4,501,681 4,501,681 4,530,331 0.64%
2011B DEBT SERVICE SINKING FUND (36)
-Property Taxes 725,000 725,000 725,000 725,000 725,000 0.00%
-Interest Earned (112,260)(897,153)50,000 115,000 75,000 50.00%
TOTAL NEW REVENUE 612,740 (172,153)775,000 840,000 800,000 3.23%
Adjustment (To)
From Fund Balance (497,801)173,115 (723,500)(838,800)(748,500)3.46%
TOTAL EXPENDITURES 114,939 962 51,500 1,200 51,500 0.00%
BUDGET SUMMARY - FOUR YEAR COMPARISON
YR.END YR.END BUDGET EST.YR.END BUDGET % CHG BUDG
FUND/REVENUE SOURCE 2021 2022 2023 2023 2024 23->24
INFRASTRUCTURE REPLACEMENT (22) including bond proceeds
-Transfers in 500,000 0 0 0 0 N/A
-Home Rule Sales Tax 1,605,788 1,321,565 1,000,000 1,040,000 1,140,000 14.00%
-Food & Beverage Tax 606,487 718,491 500,000 745,000 600,000 20.00%
-Infrastructure Maintenance Fee 249,358 265,035 300,000 300,000 300,000 0.00%
-Other (Grants/Bond Proc.)8,370,702 1,353,559 0 0 N/A
-Interest Earned 74,413 82,245 30,000 225,200 75,000 150.00%
TOTAL NEW REVENUE 11,406,748 3,740,895 1,830,000 2,310,200 2,115,000 15.57%
Adjustment (To)
From Fund Balance (7,768,267)911,820 6,092,000 5,488,800 1,380,000 -77.35%
TOTAL EXPENDITURES 3,638,481 4,652,715 7,922,000 7,799,000 3,495,000 -55.88%
VEHICLE & EQUIPMENT REPLACEMENT FUND (21)
-Interfund Transfer 725,837 893,890 961,186 961,186 962,030 0.09%
-Interest/Misc.66,790 67,416 33,000 192,000 75,000 127.27%
TOTAL NEW REVENUE 792,627 961,306 994,186 1,153,186 1,037,030 4.31%
Adjustment (To)
From Fund Balance (224,611)(508,323)157,526 (351,461)804,810 410.91%
TOTAL EXPENDITURES 568,016 452,983 1,151,712 801,725 1,841,840 59.92%
SOLID WASTE SYSTEM (58)
-User Fees 560,282 583,127 586,000 586,000 606,500 3.50%
-Property Taxes 0 0 0 0 0 N/A
-Interfund Transfer 984,665 1,019,130 1,054,800 1,054,800 1,091,700 3.50%
-Miscellaneous 7,569 3,388 10,000 10,000 10,000 0.00%
-Interest 190 563 3,000 30,000 15,000 400.00%
TOTAL NEW REVENUE 1,552,706 1,606,208 1,653,800 1,680,800 1,723,200 4.20%
Adjustment (To)
From Fund Balance (63,895)(98,226)8,208 (21,692)57,143 596.19%
TOTAL OPERATING EXPENSES 1,488,811 1,507,982 1,662,008 1,659,108 1,780,343 7.12%
BUDGET SUMMARY - FOUR YEAR COMPARISON
YR.END YR.END BUDGET EST.YR.END BUDGET % CHG BUDG
FUND/REVENUE SOURCE 2021 2022 2023 2023 2024 23->24
COMM. STATION PARKING (60)
-User Fees 30,719 88,599 146,500 158,000 146,500 0.00%
-Misc. Revenue 0 0 0 0 0 N/A
-Interest 0 0 0 0 0 N/A
TOTAL NEW REVENUE 30,719 88,599 146,500 158,000 146,500 0.00%
Adjustment (To)
From Fund Balances 174,328 111,282 83,600 71,300 71,600 -14.35%
TOTAL EXPENDITURES 205,047 199,881 230,100 229,300 218,100 -5.22%
TOTAL NEW REVENUES 80,535,994 44,328,962 49,330,464 55,974,868 51,182,479 3.75%
Adjustment (To)
From Fund Balance (20,949,994)6,387,488 8,001,170 (1,538,765)8,553,459 6.90%
TOTAL EXPENDITURES 59,586,000 50,716,450 57,331,634 54,436,103 59,735,938 4.19%
0
0.1
0.2
0.3
0.4
0.5
0.6
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022+2023+RATETAX YEAR
VILLAGE PROPERTY TAX RATE -$/$100 OF EQUALIZED ASSESSED VALUATION
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 1
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
100001 GENERAL FUND REVENUE
100001 4110 PROP TAX -3,992,210.69 -4,058,403.00 -4,058,403.00 -2,302,896.96 -4,058,403.00 -4,220,740.00 4.0%
100001 4112 PRTX ROAD -32,413.61 -35,000.00 -35,000.00 -32,615.29 -35,000.00 -35,000.00 .0%
100001 4120 REPLACEMT -500,260.94 -250,000.00 -250,000.00 -336,819.10 -425,000.00 -250,000.00 .0%
100001 4140 ST SALES -6,390,184.21 -5,282,500.00 -5,282,500.00 -3,833,894.08 -5,000,000.00 -5,400,000.00 2.2%
100001 4141 HR SALES -3,964,694.72 -3,100,000.00 -3,100,000.00 -2,292,409.22 -3,125,000.00 -3,425,000.00 10.5%
100001 4142 LOC USE TX -777,978.30 -710,000.00 -710,000.00 -535,065.93 -750,000.00 -750,000.00 5.6%
100001 4145 CAN TAX -31,396.60 -30,000.00 -30,000.00 -19,690.71 -30,000.00 -30,000.00 .0%
100001 4150 ST INC TX -3,127,937.19 -2,500,000.00 -2,500,000.00 -2,161,114.73 -2,800,000.00 -2,900,000.00 16.0%
100001 4160 HOTEL TAX -1,837,893.43 -1,500,000.00 -1,500,000.00 -1,151,678.24 -1,500,000.00 -1,500,000.00 .0%
100001 4170 TELECOM TX -932,500.55 -1,200,000.00 -1,200,000.00 -610,299.92 -1,000,000.00 -1,000,000.00 -16.7%
100001 4175 ELEC UTIL -1,066,335.83 -1,100,000.00 -1,100,000.00 -680,895.45 -1,100,000.00 -1,100,000.00 .0%
100001 4211 LIQR LIC -53,550.00 -60,000.00 -60,000.00 -7,925.00 -60,000.00 -60,000.00 .0%
100001 4213 FOOD LIC -4,607.00 -5,000.00 -5,000.00 -1,078.00 -5,000.00 -5,000.00 .0%
100001 4214 BUSN LIC -3,445.00 -5,500.00 -5,500.00 -3,855.00 -5,500.00 -5,500.00 .0%
100001 4220 BLDG PERM -1,022,558.15 -1,100,000.00 -1,100,000.00 -725,219.76 -1,100,000.00 -1,100,000.00 .0%
100001 4222 CONTR LIC -21,350.00 -20,000.00 -20,000.00 -5,700.00 -20,000.00 -20,000.00 .0%
100001 4232 LIC & PERM -58,909.31 -35,000.00 -35,000.00 -5,496.95 -35,000.00 -35,000.00 .0%
100001 4233 ALRM PERM -1,475.00 -3,000.00 -3,000.00 -950.00 -3,000.00 -3,000.00 .0%
100001 4240 VEH LIC -333,512.50 -340,000.00 -340,000.00 -321,690.00 -330,000.00 -330,000.00 -2.9%
100001 4330 ST GRANT -47,181.62 .00 .00 -32,402.85 -40,000.00 -280,000.00 .0%
100001 4350 FED GRANT -2,505.00 .00 .00 .00 .00 .00 .0%
100001 4415 C/S RAVINI .00 .00 .00 -4,346.00 -5,000.00 .00 .0%
100001 4417 C/S POL OT -314,703.97 -298,000.00 -298,000.00 -162,093.34 -298,000.00 -298,000.00 .0%
100001 4419 C/S OTHER -3,416.00 -5,000.00 -5,000.00 -4,199.73 -5,000.00 -5,000.00 .0%
100001 4425 C/S BNK DI -716,631.84 -1,240,000.00 -1,240,000.00 -807,243.12 -1,240,000.00 -540,000.00 -56.5%
100001 4430 C/S ENGIN .00 -200,000.00 -200,000.00 -53,919.35 -60,000.00 -260,000.00 30.0%
100001 4462 C/S TREE -56,724.88 -65,000.00 -65,000.00 -27,100.00 -65,000.00 -65,000.00 .0%
100001 4463 C/S HWY MT -69,327.67 -60,000.00 -60,000.00 -55,795.75 -60,000.00 -60,000.00 .0%
100001 4464 C/S TSM -7,541.34 -5,000.00 -5,000.00 -3,087.42 -5,000.00 -5,000.00 .0%
100001 4510 ORD V CTY -110,104.25 -100,000.00 -100,000.00 -73,496.32 -85,000.00 -100,000.00 .0%
100001 4511 ORD V VIL -14,885.00 -30,000.00 -30,000.00 -22,115.00 -30,000.00 -42,000.00 40.0%
100001 4520 FLSE ALRM -16,549.98 -15,000.00 -15,000.00 -12,425.00 -15,000.00 -15,000.00 .0%
100001 4530 RSTIT FINE -380.00 -1,000.00 -1,000.00 -240.00 .00 -1,000.00 .0%
100001 4540 OVR SZ VEH -9,050.00 -10,000.00 -10,000.00 -1,200.00 -10,000.00 -10,000.00 .0%
100001 4560 FF & PEN -4,985.52 -1,500.00 -1,500.00 -130.00 .00 -1,500.00 .0%
100001 4610 INTER EARN -508,669.62 -125,000.00 -125,000.00 -675,081.85 -1,000,000.00 -500,000.00 300.0%
100001 4620 GAIN SALE 17,302.71 .00 .00 .00 .00 .00 .0%
100001 4622 UNRLZD G/L 379,507.17 .00 .00 .00 .00 .00 .0%
100001 4810 MISC REV -318,573.86 -182,696.00 -182,696.00 -452,991.72 -498,000.00 -104,000.00 -43.1%
100001 4811 RENT INC -198,162.45 -305,000.00 -305,000.00 -132,132.71 -305,000.00 -305,000.00 .0%
100001 4822 FAM DY DON -15,992.13 -35,000.00 -35,000.00 -30,521.00 -31,000.00 -35,000.00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 2
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
100001 4830 IMPACT FEE .00 .00 .00 2,598.89 .00 .00 .0%
100001 4843 WC REIMB .00 -5,000.00 -5,000.00 -17,163.64 -15,000.00 -5,000.00 .0%
100001 4844 INS REIMB -2,500.00 .00 .00 -8,579.93 -10,000.00 .00 .0%
100001 4847 IPBCMICA -18,210.87 .00 .00 .00 .00 .00 .0%
100001 4851 SALE EQPM -680.36 -7,500.00 -7,500.00 -726.11 -2,500.00 -7,500.00 .0%
100001 4880 CABLE TV -441,364.15 -450,000.00 -450,000.00 -324,410.06 -450,000.00 -450,000.00 .0%
100001 4910 TRSNFR IN -196,961.88 -293,250.00 -293,250.00 -87,500.05 -243,250.00 -293,250.00 .0%
TOTAL GENERAL FUND REVENUE -26,831,505.54 -24,768,349.00 -24,768,349.00 -18,015,596.40 -25,854,653.00 -25,551,490.00 3.2%
TOTAL GENERAL FUND -26,831,505.54 -24,768,349.00 -24,768,349.00 -18,015,596.40 -25,854,653.00 -25,551,490.00 3.2%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 3
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
MOTOR FUEL TAX FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
140001 MOTOR FUEL TAX REVENUE
140001 4310 MFT REV -1,174,486.39 -750,000.00 -750,000.00 -574,648.48 -800,000.00 -800,000.00 6.7%
140001 4610 INTER EARN -35,634.79 -10,000.00 -10,000.00 -69,823.65 -100,000.00 -40,000.00 300.0%
140001 4620 GAIN SALE 1,348.98 .00 .00 .00 .00 .00 .0%
140001 4622 UNRLZD G/L 29,587.62 .00 .00 .00 .00 .00 .0%
TOTAL MOTOR FUEL TAX REVENUE -1,179,184.58 -760,000.00 -760,000.00 -644,472.13 -900,000.00 -840,000.00 10.5%
TOTAL MOTOR FUEL TAX FUND -1,179,184.58 -760,000.00 -760,000.00 -644,472.13 -900,000.00 -840,000.00 10.5%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 4
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
VEHICLE & EQUIPMENT REPLACE. ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
210001 VERF REVENUES
210001 4453 C/S UB PEN -1,360.21 .00 .00 -1,108.63 -2,000.00 .00 .0%
210001 4455 C/S WTRMTR -214,307.57 -180,000.00 -180,000.00 -123,208.66 -180,000.00 -180,000.00 .0%
210001 4480 C/S FUNDS -679,582.00 -781,186.00 -781,186.00 -455,691.85 -781,186.00 -782,030.00 .1%
210001 4610 INTER EARN -91,971.49 -33,000.00 -33,000.00 -149,017.22 -180,000.00 -75,000.00 127.3%
210001 4620 GAIN SALE 3,737.85 .00 .00 .00 .00 .00 .0%
210001 4622 UNRLZD G/L 81,983.68 .00 .00 .00 .00 .00 .0%
210001 4851 SALE EQPM -31,150.00 .00 .00 -6,245.00 -10,000.00 .00 .0%
210001 4852 G/L FADISP -28,655.83 .00 .00 .00 .00 .00 .0%
TOTAL VERF REVENUES -961,305.57 -994,186.00 -994,186.00 -735,271.36 -1,153,186.00 -1,037,030.00 4.3%
TOTAL VEHICLE & EQUIPMENT RE -961,305.57 -994,186.00 -994,186.00 -735,271.36 -1,153,186.00 -1,037,030.00 4.3%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 5
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
INFRASTRUCTURE REPLACEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
220001 INFRA REPL FUND REVENUE
220001 4141 HR SALES -1,321,564.85 -1,000,000.00 -1,000,000.00 -764,136.36 -1,040,000.00 -1,140,000.00 14.0%
220001 4165 FB TAX -718,490.84 -500,000.00 -500,000.00 -515,479.73 -745,000.00 -600,000.00 20.0%
220001 4330 ST GRANT -1,350,000.00 .00 .00 .00 .00 .00 .0%
220001 4610 INTER EARN -102,135.15 -30,000.00 -30,000.00 -157,191.16 -200,000.00 -75,000.00 150.0%
220001 4620 GAIN SALE 3,896.72 .00 .00 .00 .00 .00 .0%
220001 4622 UNRLZD G/L 85,468.31 .00 .00 .00 .00 .00 .0%
220001 4810 MISC REV -3,558.72 .00 .00 .00 .00 .00 .0%
220001 4830 IMPACT FEE -265,035.00 -300,000.00 -300,000.00 -215,763.51 -300,000.00 -300,000.00 .0%
220001 4910 TRSNFR IN -4,528,428.99 .00 .00 -2,420,614.53 .00 .00 .0%
TOTAL INFRA REPL FUND REVENU -8,199,848.52 -1,830,000.00 -1,830,000.00 -4,073,185.29 -2,285,000.00 -2,115,000.00 15.6%
TOTAL INFRASTRUCTURE REPLACE -8,199,848.52 -1,830,000.00 -1,830,000.00 -4,073,185.29 -2,285,000.00 -2,115,000.00 15.6%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 6
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
BOND PROCEEDS FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
230001 BOND PROC FUND REVENUES
230001 4610 INVST EARN -69,475.33 .00 .00 -25,199.56 -25,200.00 .00 .0%
TOTAL BOND PROC FUND REVENUE -69,475.33 .00 .00 -25,199.56 -25,200.00 .00 .0%
TOTAL BOND PROCEEDS FUND -69,475.33 .00 .00 -25,199.56 -25,200.00 .00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 7
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
DEBT SERVICE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
350001 DEBT SERVICE REVENUE
350001 4110 PROP TAX -3,526,810.18 -3,450,792.00 -3,450,792.00 -2,366,032.40 -3,450,792.00 -3,477,192.00 .8%
350001 4610 INTER EARN -30,342.48 -6,000.00 -6,000.00 -19,263.66 -30,000.00 -15,000.00 150.0%
350001 4620 GAIN SALE 933.02 .00 .00 .00 .00 .00 .0%
350001 4622 UNRLZD G/L 20,464.24 .00 .00 .00 .00 .00 .0%
350001 4810 MISC REV -360,002.71 -359,239.00 -359,239.00 -180,001.35 -359,239.00 -359,239.00 .0%
350001 4893 LIBCNTRB -683,950.00 -687,450.00 -687,450.00 -116,225.00 -687,450.00 -689,700.00 .3%
TOTAL DEBT SERVICE REVENUE -4,579,708.11 -4,503,481.00 -4,503,481.00 -2,681,522.41 -4,527,481.00 -4,541,131.00 .8%
TOTAL DEBT SERVICE FUND -4,579,708.11 -4,503,481.00 -4,503,481.00 -2,681,522.41 -4,527,481.00 -4,541,131.00 .8%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 8
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
2011B SINKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
360001 SINKING FUND REVENUE
360001 4110 PROP TAX -725,000.00 -725,000.00 -725,000.00 .00 -725,000.00 -725,000.00 .0%
360001 4610 INVST EARN -99,492.40 -50,000.00 -50,000.00 -74,527.48 -115,000.00 -75,000.00 50.0%
360001 4612 NCHGFRVAL 996,645.80 .00 .00 -17,955.50 .00 .00 .0%
TOTAL SINKING FUND REVENUE 172,153.40 -775,000.00 -775,000.00 -92,482.98 -840,000.00 -800,000.00 3.2%
TOTAL 2011B SINKING FUND 172,153.40 -775,000.00 -775,000.00 -92,482.98 -840,000.00 -800,000.00 3.2%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 9
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
500001 WATER FUND REVENUES
500001 4216 WTR PERM -36,389.28 -40,000.00 -40,000.00 -30,129.03 -40,000.00 -40,000.00 .0%
500001 4451 C/S UB -5,407,873.80 -5,607,000.00 -5,607,000.00 -3,307,315.85 -5,600,000.00 -5,832,000.00 4.0%
500001 4452 C/S UB MSC -3,343.75 .00 .00 -21,666.53 -18,500.00 .00 .0%
500001 4453 C/S UB PEN -47,303.03 -40,000.00 -40,000.00 -31,980.73 -40,000.00 -40,000.00 .0%
500001 4610 INTER EARN -64,839.22 -4,500.00 -4,500.00 -34,773.86 -45,000.00 -10,000.00 122.2%
500001 4620 GAIN SALE 609.49 .00 .00 .00 .00 .00 .0%
500001 4622 UNRLZD G/L 13,368.28 .00 .00 .00 .00 .00 .0%
500001 4810 MISC REV -5,230.69 -1,500.00 -1,500.00 -361.95 -1,000.00 -1,500.00 .0%
500001 4811 RENT INC -34,677.44 -70,000.00 -70,000.00 -72,875.19 -70,000.00 -70,000.00 .0%
500001 4834 AST CNTR -539,711.81 .00 .00 .00 .00 .00 .0%
500001 4844 INS REIMB -75,823.37 .00 .00 -26,571.46 -27,000.00 .00 .0%
TOTAL WATER FUND REVENUES -6,201,214.62 -5,763,000.00 -5,763,000.00 -3,525,674.60 -5,841,500.00 -5,993,500.00 4.0%
TOTAL WATER FUND -6,201,214.62 -5,763,000.00 -5,763,000.00 -3,525,674.60 -5,841,500.00 -5,993,500.00 4.0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 10
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
540001 SEWER FUND REVENUES
540001 4215 SWR PERM -7,050.00 -7,500.00 -7,500.00 -3,000.00 -7,500.00 -7,500.00 .0%
540001 4451 C/S UB -3,220,927.34 -3,276,300.00 -3,276,300.00 -2,027,125.13 -3,200,000.00 -3,406,700.00 4.0%
540001 4453 C/S UB PEN -32,054.19 -30,000.00 -30,000.00 -17,178.68 -25,000.00 -30,000.00 .0%
540001 4495 C/S OTHER .00 -500.00 -500.00 .00 -100.00 -500.00 .0%
540001 4610 INTER EARN -17,540.91 -5,000.00 -5,000.00 -29,811.14 -45,000.00 -20,000.00 300.0%
540001 4620 GAIN SALE 701.93 .00 .00 .00 .00 .00 .0%
540001 4622 UNRLZD G/L 15,395.70 .00 .00 .00 .00 .00 .0%
540001 4810 MISC REV -8,641.45 -5,000.00 -5,000.00 -17.42 -2,500.00 -5,000.00 .0%
540001 4834 AST CNTR -899,538.78 .00 .00 .00 .00 .00 .0%
540001 4910 TRSNFR IN -1,648,918.00 -1,656,848.00 -1,656,848.00 -454,423.75 -1,656,848.00 -1,669,928.00 .8%
TOTAL SEWER FUND REVENUES -5,818,573.04 -4,981,148.00 -4,981,148.00 -2,531,556.12 -4,936,948.00 -5,139,628.00 3.2%
TOTAL SEWER FUND -5,818,573.04 -4,981,148.00 -4,981,148.00 -2,531,556.12 -4,936,948.00 -5,139,628.00 3.2%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 11
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
REFUSE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
580001 REFUSE FUND REVENUES
580001 4451 C/S UB -562,538.15 -565,000.00 -565,000.00 -386,678.18 -565,000.00 -585,000.00 3.5%
580001 4453 C/S UB PEN -5,744.90 -6,000.00 -6,000.00 -3,366.96 -6,000.00 -6,000.00 .0%
580001 4454 C/S REF CN -14,843.66 -15,000.00 -15,000.00 -10,154.04 -15,000.00 -15,500.00 3.3%
580001 4610 INTER EARN -8,711.03 -3,000.00 -3,000.00 -17,299.27 -30,000.00 -15,000.00 400.0%
580001 4620 GAIN SALE 355.30 .00 .00 .00 .00 .00 .0%
580001 4622 UNRLZD G/L 7,792.88 .00 .00 .00 .00 .00 .0%
580001 4810 MISC REV -3,388.80 -10,000.00 -10,000.00 -2,937.55 -10,000.00 -10,000.00 .0%
580001 4910 TRSNFR IN -1,019,130.00 -1,054,800.00 -1,054,800.00 .00 -1,054,800.00 -1,091,700.00 3.5%
TOTAL REFUSE FUND REVENUES -1,606,208.36 -1,653,800.00 -1,653,800.00 -420,436.00 -1,680,800.00 -1,723,200.00 4.2%
TOTAL REFUSE FUND -1,606,208.36 -1,653,800.00 -1,653,800.00 -420,436.00 -1,680,800.00 -1,723,200.00 4.2%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 12
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
COMMUTER PARKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
600001 COMMUTER PARKING FUND REVENUES
600001 4440 C/S CPKMTR -58,881.32 -77,500.00 -77,500.00 -70,465.65 -100,000.00 -77,500.00 .0%
600001 4442 C/S VPKPER -23,654.50 -51,000.00 -51,000.00 -25,099.75 -51,000.00 -51,000.00 .0%
600001 4443 C/S CPKPER -6,063.50 -18,000.00 -18,000.00 -3,849.75 -7,000.00 -18,000.00 .0%
600001 4610 INTER EARN .00 .00 .00 2,979.89 .00 .00 .0%
TOTAL COMMUTER PARKING FUND -88,599.32 -146,500.00 -146,500.00 -96,435.26 -158,000.00 -146,500.00 .0%
TOTAL COMMUTER PARKING FUND -88,599.32 -146,500.00 -146,500.00 -96,435.26 -158,000.00 -146,500.00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 13
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GARAGE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
700001 GARAGE FUND REVENUE
700001 4480 C/S FUNDS -447,805.21 -395,000.00 -395,000.00 -240,049.08 -450,000.00 -480,000.00 21.5%
700001 4610 INTER EARN .00 .00 .00 1,179.05 .00 .00 .0%
700001 4810 MISC REV -13,193.35 -10,000.00 -10,000.00 -9,054.82 -10,000.00 -10,000.00 .0%
TOTAL GARAGE FUND REVENUE -460,998.56 -405,000.00 -405,000.00 -247,924.85 -460,000.00 -490,000.00 21.0%
TOTAL GARAGE FUND -460,998.56 -405,000.00 -405,000.00 -247,924.85 -460,000.00 -490,000.00 21.0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 09/07/2023 07:44
User: eburk
Program ID: bgnyrpts
Page 14
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
POLICE PENSION FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION MANAGER CHANGE
800001 POLICE PENSION FUND REVENUE
800001 4610 INTER EARN -517,411.45 -700,000.00 -700,000.00 -230,640.64 -700,000.00 -700,000.00 .0%
800001 4612 NCHGFRVAL 7,063,341.31 -500,000.00 -500,000.00 .00 .00 .00 -100.0%
800001 4620 GAIN SALE -578,427.59 .00 .00 -35,672.87 .00 .00 .0%
800001 4622 UNRLZD G/L 2,621,176.96 .00 .00 -5,097,058.41 -5,000,000.00 -500,000.00 .0%
800001 4810 MISC REV -125.00 .00 .00 -93.91 -100.00 .00 .0%
800001 4890 EMPR CONTB -1,100,000.00 -1,100,000.00 -1,100,000.00 .00 -1,100,000.00 -1,100,000.00 .0%
800001 4891 EMPEE-CONT -521,477.25 -450,000.00 -450,000.00 -343,769.86 -512,000.00 -505,000.00 12.2%
TOTAL POLICE PENSION FUND RE 6,967,076.98 -2,750,000.00 -2,750,000.00 -5,707,235.69 -7,312,100.00 -2,805,000.00 2.0%
TOTAL POLICE PENSION FUND 6,967,076.98 -2,750,000.00 -2,750,000.00 -5,707,235.69 -7,312,100.00 -2,805,000.00 2.0%
TOTAL REVENUE -48,857,391.17 -49,330,464.00 -49,330,464.00 -38,796,992.65 -55,974,868.00 -51,182,479.00 3.8%
TOTAL EXPENSE .00 .00 .00 .00 .00 .00 .0%
GRAND TOTAL -48,857,391.17 -49,330,464.00 -49,330,464.00 -38,796,992.65 -55,974,868.00 -51,182,479.00 3.8%
** END OF REPORT - Generated by Eric Burk **
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 1
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
101111 FINANCE DEPARTMENT
101111 5110 REG SALAR 772,903.33 810,000.00 810,000.00 653,987.20 793,000.00 859,000.00 6.0%
101111 5111 PT SALARY .00 5,000.00 5,000.00 .00 2,500.00 5,000.00 .0%
101111 5112 OT SALARY 3,354.56 5,000.00 5,000.00 619.02 1,000.00 5,000.00 .0%
101111 5120 MED BNFT 156,614.01 157,000.00 157,000.00 125,682.59 144,500.00 173,000.00 10.2%
101111 5121 DNTL BNFT 6,883.71 6,500.00 6,500.00 5,585.83 6,500.00 6,800.00 4.6%
101111 5122 MISC BNFT 4,294.22 7,600.00 7,600.00 5,415.52 3,000.00 7,600.00 .0%
101111 5130 APPAREL 882.89 500.00 500.00 504.67 500.00 500.00 .0%
101111 5140 PEN CNTRB 131,863.83 125,000.00 125,000.00 98,294.76 120,000.00 130,000.00 4.0%
101111 5210 TRNG REG 2,506.20 8,500.00 8,500.00 1,635.00 5,000.00 8,500.00 .0%
101111 5211 TRNG TRAV 2,862.95 2,200.00 2,200.00 675.38 2,200.00 2,200.00 .0%
101111 5212 TRNG EXP 195.00 3,000.00 3,000.00 .00 500.00 3,000.00 .0%
101111 5213 SUBSCRIPT 82.00 600.00 600.00 143.99 300.00 600.00 .0%
101111 5320 BLDG R&M 9,631.96 24,500.00 24,500.00 11,768.32 16,000.00 34,200.00 39.6%
101111 5322 EQUP R&M 5,008.58 24,650.00 24,650.00 11,254.59 21,825.00 13,750.00 -44.2%
101111 5324 CEME R&M 26,271.21 28,000.00 28,000.00 30,620.33 25,000.00 28,000.00 .0%
101111 5325 DOG PND 340.00 3,000.00 3,000.00 350.00 1,000.00 3,000.00 .0%
101111 5330 DUES 2,230.25 2,500.00 2,500.00 1,701.00 2,500.00 2,500.00 .0%
101111 5332 TRAV EXP 532.72 3,500.00 3,500.00 560.92 2,000.00 3,500.00 .0%
101111 5335 PRINTING 2,404.85 4,500.00 4,500.00 3,002.13 4,500.00 10,000.00 122.2%
101111 5336 LGL NOTICE 1,763.17 2,000.00 2,000.00 1,882.02 2,000.00 2,000.00 .0%
101111 5337 POSTAGE 5,553.04 5,500.00 5,500.00 2,033.21 5,500.00 5,500.00 .0%
101111 5350 INS GL 67,533.33 110,000.00 110,000.00 76,664.77 85,000.00 110,000.00 .0%
101111 5363 P/S MEDIC .00 1,000.00 1,000.00 .00 300.00 1,000.00 .0%
101111 5365 P/S OTHER 83,132.03 85,000.00 85,000.00 90,444.51 90,000.00 80,000.00 -5.9%
101111 5366 P/S EAP .00 .00 .00 .00 .00 25,000.00 .0%
101111 5370 DP SERV 84,886.61 90,983.00 90,983.00 87,233.46 81,500.00 128,410.00 41.1%
101111 5371 CC FEES 5,865.96 25,000.00 25,000.00 7,402.27 15,000.00 15,000.00 -40.0%
101111 5383 SENR PKDIS 167,921.25 180,000.00 180,000.00 157,105.00 160,000.00 180,000.00 .0%
101111 5395 ECON INCEN 4,585,090.68 3,310,000.00 3,310,000.00 2,145,563.74 2,225,000.00 3,495,000.00 5.6%
101111 5410 MISC SUPP 966.58 4,000.00 4,000.00 407.42 2,500.00 4,000.00 .0%
101111 5450 OFF SUPP 2,008.56 2,000.00 2,000.00 2,269.62 2,000.00 2,000.00 .0%
101111 5460 OPER SUPP 411.98 2,000.00 2,000.00 768.14 2,000.00 2,000.00 .0%
101111 5470 R&M SUPP .00 2,500.00 2,500.00 .00 1,000.00 2,500.00 .0%
101111 5520 U/E NAT GA 466.39 1,000.00 1,000.00 310.21 750.00 1,000.00 .0%
101111 5530 U/E WATER 21,283.93 15,000.00 15,000.00 18,509.46 14,000.00 15,000.00 .0%
101111 5550 U/E TELECM 8,535.27 8,200.00 8,200.00 4,110.42 7,600.00 8,200.00 .0%
101111 5810 OP EQP .00 1,500.00 1,500.00 .00 500.00 2,000.00 33.3%
101111 7210 TRNSFR OUT 1,019,130.00 1,054,800.00 1,054,800.00 .00 1,054,800.00 1,091,700.00 3.5%
101111 7211 TRANS VERF 3,000.00 3,000.00 3,000.00 2,250.00 3,000.00 3,000.00 .0%
TOTAL FINANCE DEPARTMENT 7,186,411.05 6,125,033.00 6,125,033.00 3,548,755.50 4,904,275.00 6,469,460.00 5.6%
101210 ADMINISTRATION
101210 5110 REG SALAR 1,014,311.21 1,135,172.00 1,135,172.00 948,142.21 1,158,280.00 1,355,667.00 19.4%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 2
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
101210 5111 PT SALARY 8,045.55 10,000.00 10,000.00 4,754.01 10,000.00 10,000.00 .0%
101210 5112 OT SALARY .00 .00 .00 873.06 1,000.00 1,000.00 .0%
101210 5120 MED BNFT 133,607.07 142,000.00 142,000.00 116,411.46 131,500.00 163,000.00 14.8%
101210 5121 DNTL BNFT 5,418.07 7,400.00 7,400.00 4,901.97 5,600.00 8,000.00 8.1%
101210 5122 MISC BNFT 10,354.74 10,320.00 10,320.00 19,618.76 19,320.00 39,420.00 282.0%
101210 5140 PEN CNTRB 171,172.92 162,000.00 162,000.00 139,877.14 180,000.00 193,000.00 19.1%
101210 5210 TRNG REG 3,458.08 15,000.00 15,000.00 2,667.00 7,000.00 15,000.00 .0%
101210 5211 TRNG TRAV 724.64 2,800.00 2,800.00 980.68 2,400.00 2,800.00 .0%
101210 5213 SUBSCRIPT 1,320.00 2,000.00 2,000.00 2,336.10 2,000.00 2,000.00 .0%
101210 5320 BLDG R&M 45,533.95 47,000.00 47,000.00 73,421.89 48,000.00 40,700.00 -13.4%
101210 5322 EQUP R&M 8,481.72 27,900.00 27,900.00 13,590.88 25,325.00 37,000.00 32.6%
101210 5326 VEH MAINT 4,535.84 4,000.00 4,000.00 2,029.51 2,000.00 3,000.00 -25.0%
101210 5330 DUES 30,906.85 32,750.00 32,750.00 23,661.72 32,500.00 32,750.00 .0%
101210 5331 CNF MEET .00 .00 .00 27.00 .00 .00 .0%
101210 5332 TRAV EXP 719.84 750.00 750.00 416.96 750.00 750.00 .0%
101210 5335 PRINTING 22,426.37 27,500.00 27,500.00 21,009.49 27,500.00 29,500.00 7.3%
101210 5336 LGL NOTICE 1,090.44 600.00 600.00 .00 600.00 600.00 .0%
101210 5337 POSTAGE 11,213.75 15,400.00 15,400.00 12,928.66 15,400.00 15,400.00 .0%
101210 5360 P/S CRP CN 214,693.82 220,000.00 220,000.00 149,380.38 220,000.00 220,000.00 .0%
101210 5364 P/S CATV 5,160.00 8,190.00 8,190.00 8,385.00 8,190.00 38,190.00 366.3%
101210 5365 P/S OTHER 147,299.43 100,000.00 100,000.00 253,467.83 203,000.00 105,000.00 5.0%
101210 5370 DP SERV 42,999.55 56,872.00 56,872.00 33,604.40 52,450.00 73,569.00 29.4%
101210 5382 HOUS ASST 2,750.00 2,750.00 2,750.00 2,750.00 2,750.00 2,750.00 .0%
101210 5384 TAXI SUBS 38,657.00 60,000.00 60,000.00 32,383.50 45,000.00 50,000.00 -16.7%
101210 5386 FAMDYSEXP 62,479.52 90,000.00 90,000.00 107,730.14 95,000.00 110,000.00 22.2%
101210 5387 ADV BOARD 197,558.49 190,700.00 190,700.00 523,661.16 580,700.00 204,896.00 7.4%
101210 5410 MISC SUPP 148.02 1,000.00 1,000.00 1,062.14 750.00 1,000.00 .0%
101210 5420 PETR PROD 699.66 1,100.00 1,100.00 .00 500.00 500.00 -54.5%
101210 5450 OFF SUPP 156.50 500.00 500.00 846.82 900.00 500.00 .0%
101210 5460 OPER SUPP 7,727.27 6,000.00 6,000.00 5,033.34 6,000.00 6,000.00 .0%
101210 5550 U/E TELECM 11,679.59 12,700.00 12,700.00 7,285.72 11,800.00 12,800.00 .8%
101210 5810 OP EQP 2,253.79 8,500.00 8,500.00 3,995.30 4,500.00 9,000.00 5.9%
101210 5840 OFC FURN .00 700.00 700.00 .00 .00 700.00 .0%
101210 5914 STRSCP IMP 33,754.77 45,600.00 45,600.00 29,070.63 45,600.00 45,600.00 .0%
101210 7211 TRANS VERF 46,417.00 48,738.00 48,738.00 36,553.50 48,738.00 50,000.00 2.6%
TOTAL ADMINISTRATION 2,287,755.45 2,495,942.00 2,495,942.00 2,582,858.36 2,995,053.00 2,880,092.00 15.4%
101330 COMMUNITY DEVELOPMENT
101330 5110 REG SALAR 1,052,175.46 1,120,882.00 1,120,882.00 939,980.69 1,108,560.00 1,171,720.00 4.5%
101330 5111 PT SALARY 4,401.95 5,000.00 5,000.00 944.24 4,500.00 5,000.00 .0%
101330 5112 OT SALARY 589.76 2,500.00 2,500.00 499.55 1,000.00 2,500.00 .0%
101330 5120 MED BNFT 156,608.27 160,000.00 160,000.00 141,089.59 160,500.00 176,000.00 10.0%
101330 5121 DNTL BNFT 6,810.71 7,200.00 7,200.00 6,192.32 7,000.00 6,000.00 -16.7%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 3
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
101330 5122 MISC BNFT 6,566.53 3,000.00 3,000.00 1,381.44 3,000.00 3,000.00 .0%
101330 5130 APPAREL 1,195.81 1,550.00 1,550.00 152.99 1,200.00 1,550.00 .0%
101330 5140 PEN CNTRB 167,303.04 172,000.00 172,000.00 130,181.21 170,000.00 180,000.00 4.7%
101330 5211 TRNG TRAV .00 3,000.00 3,000.00 75.25 1,000.00 3,000.00 .0%
101330 5212 TRNG EXP 2,200.00 4,500.00 4,500.00 1,932.00 3,000.00 4,500.00 .0%
101330 5213 SUBSCRIPT 128.30 250.00 250.00 128.30 200.00 250.00 .0%
101330 5320 BLDG R&M 10,855.33 22,000.00 22,000.00 19,055.65 22,000.00 30,700.00 39.5%
101330 5322 EQUP R&M 5,399.16 19,650.00 19,650.00 11,049.49 16,575.00 8,750.00 -55.5%
101330 5326 VEH MAINT 6,000.00 6,000.00 6,000.00 3,665.62 6,000.00 6,000.00 .0%
101330 5330 DUES 2,068.50 3,000.00 3,000.00 4,675.89 2,500.00 3,000.00 .0%
101330 5335 PRINTING 1,392.30 4,000.00 4,000.00 2,824.20 4,000.00 4,000.00 .0%
101330 5336 LGL NOTICE 1,543.93 4,600.00 4,600.00 2,782.03 4,000.00 6,000.00 30.4%
101330 5337 POSTAGE 1,440.21 3,000.00 3,000.00 1,370.07 2,000.00 3,000.00 .0%
101330 5361 P/S PRSCTR .00 .00 .00 .00 .00 12,000.00 .0%
101330 5365 P/S OTHER 96,129.15 143,895.00 143,895.00 95,481.63 113,895.00 175,895.00 22.2%
101330 5370 DP SERV 25,217.24 60,990.00 60,990.00 50,181.27 60,500.00 78,843.00 29.3%
101330 5387 ADV BOARD 6,049.85 4,300.00 4,300.00 139.65 2,000.00 4,300.00 .0%
101330 5410 MISC SUPP 800.00 5,000.00 5,000.00 1,103.14 5,000.00 5,000.00 .0%
101330 5420 PETR PROD 2,538.13 3,600.00 3,600.00 1,319.10 2,000.00 2,000.00 -44.4%
101330 5450 OFF SUPP 442.18 1,500.00 1,500.00 2,218.74 2,000.00 1,500.00 .0%
101330 5460 OPER SUPP 6,815.42 5,500.00 5,500.00 4,131.55 5,500.00 5,500.00 .0%
101330 5550 U/E TELECM 9,959.30 10,500.00 10,500.00 6,044.62 10,200.00 11,100.00 5.7%
101330 5810 OP EQP 3,726.85 1,000.00 1,000.00 1,929.99 500.00 1,500.00 50.0%
101330 5830 OFC EQP .00 .00 .00 .00 .00 8,000.00 .0%
101330 7211 TRANS VERF 9,375.00 9,375.00 9,375.00 7,031.25 9,375.00 11,560.00 23.3%
TOTAL COMMUNITY DEVELOPMENT 1,587,732.38 1,787,792.00 1,787,792.00 1,437,561.47 1,728,005.00 1,932,168.00 8.1%
102010 STREET ADMINISTRATION
102010 5110 REG SALAR 205,691.68 217,000.00 217,000.00 192,281.83 217,000.00 242,000.00 11.5%
102010 5112 OT SALARY .00 4,000.00 4,000.00 .00 4,000.00 4,000.00 .0%
102010 5120 MED BNFT 29,188.69 32,000.00 32,000.00 26,147.44 30,000.00 41,000.00 28.1%
102010 5121 DNTL BNFT 1,143.19 1,400.00 1,400.00 1,026.15 1,200.00 1,400.00 .0%
102010 5122 MISC BNFT 450.19 500.00 500.00 403.83 500.00 500.00 .0%
102010 5130 APPAREL 3,346.98 3,500.00 3,500.00 3,009.71 4,200.00 4,200.00 20.0%
102010 5140 PEN CNTRB 34,740.05 34,000.00 34,000.00 28,589.36 34,000.00 38,500.00 13.2%
102010 5210 TRNG REG 1,203.77 3,400.00 3,400.00 1,104.35 3,400.00 3,000.00 -11.8%
102010 5211 TRNG TRAV 324.01 1,000.00 1,000.00 665.29 1,000.00 1,000.00 .0%
102010 5320 BLDG R&M 53,980.10 39,212.00 39,212.00 46,366.17 37,260.52 50,212.00 28.1%
102010 5322 EQUP R&M 6,710.00 8,830.00 8,830.00 2,828.68 6,175.00 6,650.00 -24.7%
102010 5326 VEH MAINT 6,898.53 5,000.00 5,000.00 1,814.32 5,000.00 5,000.00 .0%
102010 5330 DUES 1,138.20 1,600.00 1,600.00 1,208.20 1,600.00 1,600.00 .0%
102010 5332 TRAV EXP 20.00 500.00 500.00 .00 500.00 500.00 .0%
102010 5335 PRINTING 960.73 1,200.00 1,200.00 747.60 1,200.00 1,200.00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 4
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
102010 5336 LGL NOTICE .00 250.00 250.00 .00 250.00 250.00 .0%
102010 5337 POSTAGE 1,422.04 2,000.00 2,000.00 1,417.27 2,000.00 2,000.00 .0%
102010 5350 INS GL 120,337.62 181,500.00 181,500.00 123,575.57 165,000.00 181,500.00 .0%
102010 5363 P/S MEDIC 370.00 1,000.00 1,000.00 690.00 1,800.00 1,000.00 .0%
102010 5365 P/S OTHER 1,267.50 3,000.00 3,000.00 1,305.00 3,000.00 3,000.00 .0%
102010 5370 DP SERV 13,409.72 10,076.00 10,076.00 4,810.99 9,970.00 14,455.00 43.5%
102010 5410 MISC SUPP 367.69 500.00 500.00 158.07 500.00 500.00 .0%
102010 5420 PETR PROD 2,427.64 2,000.00 2,000.00 1,452.75 2,000.00 2,000.00 .0%
102010 5421 MATERIAL 447.62 .00 .00 .00 .00 .00 .0%
102010 5450 OFF SUPP 1,074.93 1,200.00 1,200.00 939.95 1,200.00 1,200.00 .0%
102010 5460 OPER SUPP 4,847.10 4,000.00 4,000.00 4,064.76 4,000.00 4,000.00 .0%
102010 5510 U/E ELECT 2,450.20 3,000.00 3,000.00 1,181.06 .00 3,000.00 .0%
102010 5550 U/E TELECM 4,514.80 5,700.00 5,700.00 3,320.80 5,200.00 5,600.00 -1.8%
102010 5810 OP EQP 735.41 6,850.00 6,850.00 1,717.75 2,467.75 3,500.00 -48.9%
102010 7211 TRANS VERF 221,934.00 221,934.00 221,934.00 166,450.50 221,934.00 202,401.00 -8.8%
TOTAL STREET ADMINISTRATION 721,402.39 796,152.00 796,152.00 617,277.40 766,357.27 825,168.00 3.6%
102036 STREET SNOW & ICE REMOVAL
102036 5112 OT SALARY 50,442.23 60,000.00 60,000.00 42,035.92 60,000.00 60,000.00 .0%
102036 5120 MED BNFT 5,910.99 14,000.00 14,000.00 6,988.01 12,000.00 14,000.00 .0%
102036 5121 DNTL BNFT 242.87 1,500.00 1,500.00 278.75 500.00 1,500.00 .0%
102036 5122 MISC BNFT 35.44 250.00 250.00 39.64 100.00 250.00 .0%
102036 5140 PEN CNTRB 9,097.15 11,000.00 11,000.00 6,256.71 9,000.00 11,000.00 .0%
102036 5310 RENT EQP 15,891.50 20,000.00 20,000.00 20,000.00 11,548.00 20,000.00 .0%
102036 5322 EQUP R&M 55,000.00 55,000.00 55,000.00 61,583.88 55,000.00 55,000.00 .0%
102036 5326 VEH MAINT 50,580.33 35,000.00 35,000.00 14,528.95 50,000.00 50,000.00 42.9%
102036 5390 OTHER 34,070.00 25,000.00 25,000.00 20,000.00 30,000.00 30,000.00 20.0%
102036 5420 PETR PROD 16,844.20 14,000.00 14,000.00 11,231.15 15,000.00 15,000.00 7.1%
102036 5421 MATERIAL 845.65 750.00 750.00 576.07 1,000.00 1,000.00 33.3%
102036 5422 CHEMICAL 205,244.33 200,000.00 200,000.00 239,879.85 250,000.00 200,000.00 .0%
102036 5460 OPER SUPP 607.00 1,500.00 1,500.00 1,432.19 2,000.00 1,500.00 .0%
102036 5470 R&M SUPP 250.00 1,500.00 1,500.00 450.00 1,000.00 1,500.00 .0%
102036 5810 OP EQP .00 750.00 750.00 .00 750.00 750.00 .0%
TOTAL STREET SNOW & ICE REMO 445,061.69 440,250.00 440,250.00 425,281.12 497,898.00 461,500.00 4.8%
102037 STREET FORESTRY
102037 5112 OT SALARY 991.59 4,000.00 4,000.00 53.25 4,000.00 4,000.00 .0%
102037 5120 MED BNFT 134.19 3,000.00 3,000.00 11.98 1,000.00 3,000.00 .0%
102037 5121 DNTL BNFT 5.35 300.00 300.00 .44 100.00 300.00 .0%
102037 5122 MISC BNFT .88 100.00 100.00 .05 2.00 100.00 .0%
102037 5140 PEN CNTRB 173.35 700.00 700.00 7.88 700.00 700.00 .0%
102037 5320 BLDG R&M 1,765.00 .00 .00 .00 .00 .00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 5
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
102037 5322 EQUP R&M 16,029.20 20,000.00 20,000.00 12,459.29 20,000.00 20,000.00 .0%
102037 5326 VEH MAINT 13,000.00 13,000.00 13,000.00 4,641.50 13,000.00 13,000.00 .0%
102037 5365 P/S OTHER 263,452.02 255,000.00 255,000.00 202,121.30 255,000.00 280,000.00 9.8%
102037 5420 PETR PROD 4,434.41 3,000.00 3,000.00 3,029.11 3,000.00 3,000.00 .0%
102037 5421 MATERIAL 5,146.92 5,000.00 5,000.00 956.70 5,000.00 5,000.00 .0%
102037 5460 OPER SUPP 951.44 2,000.00 2,000.00 890.00 2,000.00 2,000.00 .0%
102037 5810 OP EQP .00 2,000.00 2,000.00 .00 2,000.00 2,000.00 .0%
102037 5914 STRSCP IMP 177,119.44 200,000.00 200,000.00 181,096.27 198,000.00 200,000.00 .0%
TOTAL STREET FORESTRY 483,203.79 508,100.00 508,100.00 405,267.77 503,802.00 533,100.00 4.9%
102038 STREET TRAIN STATION MAINT
102038 5110 REG SALAR 8,794.77 6,750.00 6,750.00 7,517.50 6,750.00 9,100.00 34.8%
102038 5120 MED BNFT 860.83 1,000.00 1,000.00 787.24 1,000.00 1,000.00 .0%
102038 5121 DNTL BNFT 35.52 250.00 250.00 32.21 50.00 250.00 .0%
102038 5122 MISC BNFT 9.88 .00 .00 8.70 100.00 .00 .0%
102038 5140 PEN CNTRB 1,540.97 1,100.00 1,100.00 1,069.20 1,100.00 1,100.00 .0%
102038 5320 BLDG R&M 30,624.00 30,000.00 30,000.00 27,023.01 30,000.00 30,000.00 .0%
102038 5321 STRUC R&M 11,991.13 12,500.00 12,500.00 7,581.60 12,500.00 12,500.00 .0%
102038 5322 EQUP R&M 1,560.98 1,000.00 1,000.00 1,261.38 1,500.00 1,000.00 .0%
102038 5460 OPER SUPP 1,667.79 3,000.00 3,000.00 766.45 3,000.00 3,000.00 .0%
102038 5550 U/E TELECM 1,993.06 2,400.00 2,400.00 1,471.38 1,800.00 2,100.00 -12.5%
TOTAL STREET TRAIN STATION M 59,078.93 58,000.00 58,000.00 47,518.67 57,800.00 60,050.00 3.5%
102050 STREET MAINTENANCE
102050 5110 REG SALAR 549,036.88 547,000.00 547,000.00 494,642.09 547,000.00 607,000.00 11.0%
102050 5111 PT SALARY .00 9,000.00 9,000.00 .00 .00 9,000.00 .0%
102050 5112 OT SALARY 79,601.19 60,000.00 60,000.00 82,339.64 80,000.00 60,000.00 .0%
102050 5120 MED BNFT 86,388.46 92,000.00 92,000.00 80,927.90 91,000.00 108,000.00 17.4%
102050 5121 DNTL BNFT 3,592.24 3,800.00 3,800.00 3,341.15 3,600.00 4,700.00 23.7%
102050 5122 MISC BNFT 2,043.87 3,000.00 3,000.00 2,521.22 3,000.00 3,000.00 .0%
102050 5130 APPAREL 373.89 .00 .00 806.84 .00 .00 .0%
102050 5140 PEN CNTRB 110,432.48 97,000.00 97,000.00 86,742.02 97,000.00 100,000.00 3.1%
102050 5210 TRNG REG 970.90 .00 .00 .00 .00 .00 .0%
102050 5310 RENT EQP 4,713.28 4,000.00 4,000.00 2,575.25 4,000.00 4,000.00 .0%
102050 5322 EQUP R&M 29,932.77 20,000.00 20,000.00 28,403.23 25,000.00 20,000.00 .0%
102050 5326 VEH MAINT 71,818.64 50,000.00 50,000.00 50,839.81 50,000.00 50,000.00 .0%
102050 5365 P/S OTHER 104,408.62 110,000.00 110,000.00 136,856.52 115,000.00 110,000.00 .0%
102050 5410 MISC SUPP 2,064.71 2,000.00 2,000.00 1,685.14 2,000.00 2,000.00 .0%
102050 5420 PETR PROD 20,552.45 15,000.00 15,000.00 15,042.24 15,000.00 15,000.00 .0%
102050 5421 MATERIAL 137,290.41 121,500.00 121,500.00 140,837.76 141,500.00 121,500.00 .0%
102050 5430 ST SIGNS 13,143.94 15,000.00 15,000.00 12,324.63 15,000.00 15,000.00 .0%
102050 5440 SMTLSEQUP 774.97 1,000.00 1,000.00 468.33 1,000.00 1,000.00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 6
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
102050 5450 OFF SUPP 422.73 .00 .00 154.99 .00 .00 .0%
102050 5470 R&M SUPP 525.43 2,500.00 2,500.00 761.22 2,500.00 2,500.00 .0%
102050 5510 U/E ELECT 34,636.01 60,000.00 60,000.00 31,534.61 45,000.00 60,000.00 .0%
102050 5611 PMTS OTHR 89,095.36 60,000.00 60,000.00 59,624.58 60,000.00 60,000.00 .0%
102050 5810 OP EQP 102.32 .00 .00 1,062.63 .00 25,000.00 .0%
TOTAL STREET MAINTENANCE 1,341,921.55 1,272,800.00 1,272,800.00 1,233,491.80 1,297,600.00 1,377,700.00 8.2%
102110 ENGINEERING DIVISION
102110 5110 REG SALAR 318,279.49 310,800.00 310,800.00 246,858.76 310,800.00 355,000.00 14.2%
102110 5111 PT SALARY 5,312.00 10,000.00 10,000.00 5,775.00 10,000.00 10,000.00 .0%
102110 5120 MED BNFT 44,722.34 42,000.00 42,000.00 34,344.01 40,000.00 47,000.00 11.9%
102110 5121 DNTL BNFT 2,023.77 3,400.00 3,400.00 1,617.81 2,000.00 3,500.00 2.9%
102110 5122 MISC BNFT 1,374.93 1,500.00 1,500.00 1,641.15 600.00 1,500.00 .0%
102110 5130 APPAREL 1,174.48 2,500.00 2,500.00 667.15 1,500.00 3,000.00 20.0%
102110 5140 PEN CNTRB 54,509.87 51,000.00 51,000.00 37,108.27 50,000.00 58,000.00 13.7%
102110 5210 TRNG REG 395.00 3,900.00 3,900.00 552.95 1,400.00 3,000.00 -23.1%
102110 5211 TRNG TRAV 1,158.64 2,200.00 2,200.00 1,818.83 2,200.00 2,200.00 .0%
102110 5213 SUBSCRIPT 81.50 .00 .00 164.49 .00 .00 .0%
102110 5320 BLDG R&M 13,608.38 24,000.00 24,000.00 6,537.15 17,048.52 30,000.00 25.0%
102110 5322 EQUP R&M 2,882.95 13,200.00 13,200.00 5,538.91 10,175.00 7,250.00 -45.1%
102110 5326 VEH MAINT 12,000.00 12,000.00 12,000.00 13,783.25 12,000.00 12,000.00 .0%
102110 5330 DUES 1,662.98 1,400.00 1,400.00 1,043.45 1,400.00 1,400.00 .0%
102110 5332 TRAV EXP 91.13 500.00 500.00 180.00 500.00 500.00 .0%
102110 5335 PRINTING 1,270.09 1,000.00 1,000.00 233.03 1,000.00 1,000.00 .0%
102110 5336 LGL NOTICE 492.82 3,500.00 3,500.00 .00 1,000.00 3,000.00 -14.3%
102110 5337 POSTAGE 273.35 500.00 500.00 438.39 600.00 500.00 .0%
102110 5350 INS GL 17,793.33 20,900.00 20,900.00 13,863.31 19,000.00 20,900.00 .0%
102110 5362 P/S ENG 71,450.80 290,000.00 290,000.00 128,869.00 111,000.00 355,000.00 22.4%
102110 5363 P/S MEDIC 125.00 250.00 250.00 .00 250.00 250.00 .0%
102110 5365 P/S OTHER 1,299.50 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0%
102110 5370 DP SERV 5,608.27 8,041.00 8,041.00 3,748.74 8,000.00 13,887.00 72.7%
102110 5375 GIS SERV 91,293.00 98,185.00 98,185.00 93,388.59 97,030.00 99,710.00 1.6%
102110 5410 MISC SUPP 381.53 1,500.00 1,500.00 467.77 1,000.00 1,500.00 .0%
102110 5420 PETR PROD 7,758.39 6,000.00 6,000.00 4,432.85 6,000.00 8,000.00 33.3%
102110 5450 OFF SUPP 2,506.30 3,000.00 3,000.00 883.41 1,500.00 3,000.00 .0%
102110 5460 OPER SUPP 2,373.32 1,000.00 1,000.00 1,227.53 1,000.00 1,000.00 .0%
102110 5550 U/E TELECM 4,713.40 5,900.00 5,900.00 3,402.56 5,200.00 5,600.00 -5.1%
102110 5810 OP EQP 3,624.79 7,250.00 7,250.00 1,717.75 2,467.75 10,000.00 37.9%
102110 7211 TRANS VERF 24,680.00 24,680.00 24,680.00 18,509.99 24,680.00 37,135.00 50.5%
TOTAL ENGINEERING DIVISION 694,921.35 951,106.00 951,106.00 628,814.10 740,351.27 1,095,832.00 15.2%
106010 POLICE DEPT ADMINISTRATION
106010 5110 REG SALAR 766,590.57 1,052,364.00 1,052,364.00 666,258.63 842,494.00 1,140,711.00 8.4%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 7
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
106010 5112 OT SALARY .00 1,500.00 1,500.00 509.91 .00 1,500.00 .0%
106010 5120 MED BNFT 190,350.95 210,000.00 210,000.00 162,953.72 195,000.00 220,000.00 4.8%
106010 5121 DNTL BNFT 5,810.38 6,500.00 6,500.00 4,842.73 6,770.00 6,200.00 -4.6%
106010 5122 MISC BNFT 2,829.23 2,160.00 2,160.00 1,094.63 2,160.00 2,160.00 .0%
106010 5130 APPAREL 3,197.45 6,300.00 6,300.00 2,372.56 4,100.00 6,900.00 9.5%
106010 5140 PEN CNTRB 156,032.12 160,000.00 160,000.00 48,282.10 165,000.00 175,000.00 9.4%
106010 5211 TRNG TRAV 73.67 10,700.00 10,700.00 6,750.31 7,900.00 11,800.00 10.3%
106010 5212 TRNG EXP 1,115.00 7,500.00 7,500.00 3,353.25 9,500.00 24,100.00 221.3%
106010 5213 SUBSCRIPT 290.00 390.00 390.00 290.00 390.00 390.00 .0%
106010 5320 BLDG R&M 135,656.08 855,660.00 855,660.00 907,545.82 842,148.00 192,460.00 -77.5%
106010 5322 EQUP R&M 17,030.21 97,800.00 97,800.00 59,347.60 91,150.00 78,750.00 -19.5%
106010 5326 VEH MAINT 2,000.00 2,300.00 2,300.00 950.10 2,300.00 2,300.00 .0%
106010 5330 DUES 1,960.00 2,695.00 2,695.00 2,875.95 2,664.00 2,895.00 7.4%
106010 5335 PRINTING 3,180.54 8,850.00 8,850.00 5,050.10 7,061.00 8,950.00 1.1%
106010 5336 LGL NOTICE 746.00 1,000.00 1,000.00 .00 700.00 1,000.00 .0%
106010 5337 POSTAGE 1,916.99 3,200.00 3,200.00 2,061.79 2,000.00 3,200.00 .0%
106010 5350 INS GL 242,454.97 396,000.00 396,000.00 262,715.14 242,399.00 396,000.00 .0%
106010 5361 P/S PRSCTR 78,037.50 85,000.00 85,000.00 32,780.87 75,000.00 85,000.00 .0%
106010 5363 P/S MEDIC 16,400.30 20,850.00 20,850.00 18,101.50 18,655.00 21,050.00 1.0%
106010 5370 DP SERV 67,675.42 118,038.00 118,038.00 67,367.18 85,876.00 155,319.00 31.6%
106010 5387 ADV BOARD 7,725.50 9,800.00 9,800.00 6,056.65 6,100.00 18,900.00 92.9%
106010 5388 EMER SERV 4,291.07 4,500.00 4,500.00 3,760.92 3,980.00 4,680.00 4.0%
106010 5390 OTHER 73,391.85 97,065.00 97,065.00 97,306.00 99,640.00 83,595.00 -13.9%
106010 5410 MISC SUPP 1,316.93 1,750.00 1,750.00 1,054.35 1,300.00 1,750.00 .0%
106010 5420 PETR PROD 1,430.85 1,925.00 1,925.00 999.97 1,200.00 1,925.00 .0%
106010 5450 OFF SUPP 3,488.01 9,000.00 9,000.00 2,761.24 6,000.00 6,000.00 -33.3%
106010 5460 OPER SUPP 14,856.25 15,000.00 15,000.00 13,356.34 11,700.00 16,500.00 10.0%
106010 5550 U/E TELECM 22,235.13 26,525.00 26,525.00 13,445.28 24,525.00 26,450.00 -.3%
106010 5810 OP EQP 10,222.46 34,300.00 34,300.00 14,026.49 15,400.00 285,900.00 733.5%
106010 7211 TRANS VERF 180,623.00 279,906.00 279,906.00 209,929.50 279,906.00 300,662.00 7.4%
TOTAL POLICE DEPT ADMINISTRA 2,012,928.43 3,528,578.00 3,528,578.00 2,618,200.63 3,053,018.00 3,282,047.00 -7.0%
106020 POLICE DEPT COMMUNICATIONS
106020 5110 REG SALAR 764,236.16 906,575.00 906,575.00 731,179.18 812,324.00 940,205.00 3.7%
106020 5111 PT SALARY 43,140.27 65,000.00 65,000.00 42,529.94 49,600.00 65,000.00 .0%
106020 5112 OT SALARY 55,132.82 45,000.00 45,000.00 55,828.12 65,200.00 45,000.00 .0%
106020 5120 MED BNFT 107,761.11 130,000.00 130,000.00 91,788.09 115,000.00 140,000.00 7.7%
106020 5121 DNTL BNFT 4,541.16 5,500.00 5,500.00 3,982.37 5,300.00 6,200.00 12.7%
106020 5122 MISC BNFT 2,922.64 3,100.00 3,100.00 2,674.54 2,750.00 3,100.00 .0%
106020 5130 APPAREL 2,070.22 3,800.00 3,800.00 4,644.42 3,540.00 4,650.00 22.4%
106020 5140 PEN CNTRB 141,348.90 156,000.00 156,000.00 109,627.49 145,000.00 160,000.00 2.6%
106020 5211 TRNG TRAV 1,751.26 5,300.00 5,300.00 666.91 1,300.00 5,300.00 .0%
106020 5212 TRNG EXP 1,808.00 5,400.00 5,400.00 715.00 700.00 12,500.00 131.5%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 8
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
106020 5213 SUBSCRIPT 82.50 300.00 300.00 58.30 120.00 300.00 .0%
106020 5330 DUES 338.00 500.00 500.00 247.00 497.00 500.00 .0%
106020 5810 OP EQP 434.79 5,000.00 5,000.00 17,163.94 1,000.00 5,000.00 .0%
TOTAL POLICE DEPT COMMUNICAT 1,125,567.83 1,331,475.00 1,331,475.00 1,061,105.30 1,202,331.00 1,387,755.00 4.2%
106033 POLICE DEPT INVESTIGATIONS
106033 5110 REG SALAR 753,698.34 854,133.00 854,133.00 581,645.36 754,450.00 902,286.00 5.6%
106033 5112 OT SALARY 34,945.63 40,000.00 40,000.00 19,477.15 28,000.00 40,000.00 .0%
106033 5120 MED BNFT 98,419.64 119,000.00 119,000.00 72,525.34 85,000.00 127,000.00 6.7%
106033 5121 DNTL BNFT 4,174.06 5,000.00 5,000.00 3,197.62 3,700.00 5,500.00 10.0%
106033 5122 MISC BNFT 5,534.59 5,800.00 5,800.00 3,957.23 5,528.00 5,800.00 .0%
106033 5130 APPAREL 5,906.22 5,750.00 5,750.00 6,014.86 6,000.00 8,010.00 39.3%
106033 5140 PEN CNTRB 171,429.88 180,000.00 180,000.00 29,204.65 166,000.00 190,000.00 5.6%
106033 5211 TRNG TRAV 929.04 3,000.00 3,000.00 1,106.44 1,400.00 3,000.00 .0%
106033 5212 TRNG EXP 5,123.99 14,550.00 14,550.00 8,134.00 10,900.00 12,350.00 -15.1%
106033 5213 SUBSCRIPT .00 300.00 300.00 79.00 80.00 300.00 .0%
106033 5326 VEH MAINT 10,763.24 6,500.00 6,500.00 7,960.41 6,500.00 7,500.00 15.4%
106033 5330 DUES 1,046.00 1,700.00 1,700.00 971.00 1,350.00 1,830.00 7.6%
106033 5415 COMMUNITY 4,486.16 6,500.00 6,500.00 6,369.75 7,000.00 7,500.00 15.4%
106033 5420 PETR PROD 2,777.71 4,125.00 4,125.00 1,895.03 3,500.00 4,125.00 .0%
106033 5810 OP EQP 11,907.30 16,137.00 16,137.00 5,488.38 11,360.00 36,500.00 126.2%
TOTAL POLICE DEPT INVESTIGAT 1,111,141.80 1,262,495.00 1,262,495.00 748,026.22 1,090,768.00 1,351,701.00 7.1%
106034 POLICE DEPT PATROL
106034 5110 REG SALAR 3,894,958.74 4,185,447.00 4,185,447.00 3,398,454.30 3,944,219.00 4,256,016.00 1.7%
106034 5111 PT SALARY .00 5,000.00 5,000.00 .00 .00 2,500.00 -50.0%
106034 5112 OT SALARY 214,758.76 160,000.00 160,000.00 146,903.25 200,000.00 168,000.00 5.0%
106034 5120 MED BNFT 503,382.13 555,000.00 555,000.00 455,876.05 525,000.00 580,000.00 4.5%
106034 5121 DNTL BNFT 21,728.77 26,000.00 26,000.00 19,709.49 22,500.00 25,000.00 -3.8%
106034 5122 MISC BNFT 16,936.87 14,820.00 14,820.00 12,842.35 13,772.00 14,820.00 .0%
106034 5130 APPAREL 73,592.23 64,200.00 64,200.00 39,092.40 47,340.00 85,460.00 33.1%
106034 5140 PEN CNTRB 935,154.12 945,000.00 945,000.00 49,087.89 940,000.00 925,000.00 -2.1%
106034 5211 TRNG TRAV 5,030.52 16,000.00 16,000.00 3,505.49 10,000.00 17,128.00 7.1%
106034 5212 TRNG EXP 44,371.89 77,445.00 77,445.00 25,255.99 48,645.00 73,113.00 -5.6%
106034 5326 VEH MAINT 59,000.00 59,000.00 59,000.00 69,311.59 73,695.00 79,000.00 33.9%
106034 5330 DUES 290.00 560.00 560.00 80.00 560.00 1,220.00 117.9%
106034 5420 PETR PROD 63,462.07 68,750.00 68,750.00 41,767.21 72,468.00 79,500.00 15.6%
106034 5460 OPER SUPP 29,966.98 72,711.00 72,711.00 54,016.75 68,049.00 66,830.00 -8.1%
106034 5550 U/E TELECM 4,612.85 6,600.00 6,600.00 4,325.47 6,755.00 7,300.00 10.6%
106034 5810 OP EQP 15,031.19 84,995.00 84,995.00 37,892.34 46,058.00 74,888.00 -11.9%
TOTAL POLICE DEPT PATROL 5,882,277.12 6,341,528.00 6,341,528.00 4,358,120.57 6,019,061.00 6,455,775.00 1.8%
106061 POLICE DEPT SPEC DETAIL
106061 5112 OT SALARY 14,250.01 35,000.00 35,000.00 25,005.56 22,000.00 35,000.00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 9
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GENERAL FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
106061 5120 MED BNFT 1,737.14 10,000.00 10,000.00 2,890.53 2,000.00 10,000.00 .0%
106061 5121 DNTL BNFT 83.19 1,000.00 1,000.00 133.34 500.00 1,000.00 .0%
106061 5122 MISC BNFT 10.77 .00 .00 22.79 .00 .00 .0%
106061 5140 PEN CNTRB 240.88 2,000.00 2,000.00 428.52 500.00 2,000.00 .0%
TOTAL POLICE DEPT SPEC DETAI 16,321.99 48,000.00 48,000.00 28,480.74 25,000.00 48,000.00 .0%
TOTAL GENERAL FUND 24,955,725.75 26,947,251.00 26,947,251.00 19,740,759.65 24,881,319.54 28,160,348.00 4.5%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 10
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
MOTOR FUEL TAX FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
142050 MOTOR FUEL TAX EXPENDITURES
142050 5910 STREET IMP .00 .00 .00 .00 .00 3,990,000.00 .0%
TOTAL MOTOR FUEL TAX EXPENDI .00 .00 .00 .00 .00 3,990,000.00 .0%
TOTAL MOTOR FUEL TAX FUND .00 .00 .00 .00 .00 3,990,000.00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 11
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
VEHICLE & EQUIPMENT REPLACE. ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
211150 VERF EXPENSES
211150 5670 DEPR EXP 405,750.87 .00 .00 .00 .00 .00 .0%
211150 5810 OP EQP 44,815.75 308,500.00 308,500.00 39,955.72 68,313.00 555,000.00 79.9%
211150 5860 MOTOR VEH 2,416.03 843,212.38 843,212.38 553,420.90 733,411.90 1,286,840.00 52.6%
TOTAL VERF EXPENSES 452,982.65 1,151,712.38 1,151,712.38 593,376.62 801,724.90 1,841,840.00 59.9%
TOTAL VEHICLE & EQUIPMENT RE 452,982.65 1,151,712.38 1,151,712.38 593,376.62 801,724.90 1,841,840.00 59.9%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 12
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
INFRASTRUCTURE REPLACEMENT ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
222082 INFRA REPL FUND EXPENDITURE
222082 5362 P/S ENG 403,222.88 1,190,000.00 1,190,000.00 908,376.66 968,000.00 410,000.00 -65.5%
222082 5910 STREET IMP 1,661,222.36 4,360,000.00 4,360,000.00 4,102,596.40 4,250,000.00 .00 -100.0%
222082 5911 SDWLK IMP 1,200.00 50,000.00 50,000.00 34,000.00 50,000.00 100,000.00 100.0%
222082 5990 OTHER CAP 2,587,070.22 2,322,000.00 2,322,000.00 2,510,046.60 2,531,000.00 2,985,000.00 28.6%
TOTAL INFRA REPL FUND EXPEND 4,652,715.46 7,922,000.00 7,922,000.00 7,555,019.66 7,799,000.00 3,495,000.00 -55.9%
TOTAL INFRASTRUCTURE REPLACE 4,652,715.46 7,922,000.00 7,922,000.00 7,555,019.66 7,799,000.00 3,495,000.00 -55.9%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 13
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
BOND PROCEEDS FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
237074 2021 BOND ISSUE
237074 7210 TRNSFR OUT 4,528,428.99 .00 .00 2,570,235.16 .00 .00 .0%
TOTAL 2021 BOND ISSUE 4,528,428.99 .00 .00 2,570,235.16 .00 .00 .0%
TOTAL BOND PROCEEDS FUND 4,528,428.99 .00 .00 2,570,235.16 .00 .00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 14
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
DEBT SERVICE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
350001 DEBT SERVICE REVENUE
350001 7210 TRNSFR OUT 1,648,918.00 1,656,848.00 1,656,848.00 454,423.75 1,656,848.00 1,669,928.00 .8%
TOTAL DEBT SERVICE REVENUE 1,648,918.00 1,656,848.00 1,656,848.00 454,423.75 1,656,848.00 1,669,928.00 .8%
357070 DEBT SERVICE 2021 EXP
357070 5760 D/S FA FEE 550.00 .00 .00 .00 .00 .00 .0%
TOTAL DEBT SERVICE 2021 EXP 550.00 .00 .00 .00 .00 .00 .0%
357072 DEBT SERVICE 2021 EXP
357072 5710 D/S INTER 519,450.00 496,450.00 496,450.00 248,225.00 496,450.00 471,700.00 -5.0%
357072 5730 D/S PRINC 460,000.00 495,000.00 495,000.00 .00 495,000.00 535,000.00 8.1%
357072 5760 D/S FA FEE 825.00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0%
TOTAL DEBT SERVICE 2021 EXP 980,275.00 992,450.00 992,450.00 248,225.00 992,450.00 1,007,700.00 1.5%
357073 DEBT SERVICE 2020 EXP
357073 5710 D/S INTER 76,345.00 67,465.00 67,465.00 33,732.50 67,465.00 58,185.00 -13.8%
357073 5730 D/S PRINC 222,000.00 232,000.00 232,000.00 .00 232,000.00 240,000.00 3.4%
357073 5760 D/S FA FEE 550.00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0%
TOTAL DEBT SERVICE 2020 EXP 298,895.00 300,465.00 300,465.00 33,732.50 300,465.00 299,185.00 -.4%
357074 DEBT SERVICE 2018 EXP
357074 5710 D/S INTER 184,130.00 173,930.00 173,930.00 86,965.00 173,930.00 163,330.00 -6.1%
357074 5730 D/S PRINC 255,000.00 265,000.00 265,000.00 .00 265,000.00 275,000.00 3.8%
357074 5760 D/S FA FEE 550.00 1,000.00 1,000.00 550.00 1,000.00 1,000.00 .0%
TOTAL DEBT SERVICE 2018 EXP 439,680.00 439,930.00 439,930.00 87,515.00 439,930.00 439,330.00 -.1%
357077 DEBT SERVICE 2015 EXP
357077 5710 D/S INTER 216,500.00 202,850.00 202,850.00 101,425.00 202,850.00 188,750.00 -7.0%
357077 5730 D/S PRINC 455,000.00 470,000.00 470,000.00 .00 470,000.00 485,000.00 3.2%
357077 5760 D/S FA FEE 500.00 1,000.00 1,000.00 500.00 1,000.00 1,000.00 .0%
TOTAL DEBT SERVICE 2015 EXP 672,000.00 673,850.00 673,850.00 101,925.00 673,850.00 674,750.00 .1%
357078 DEBT SERVICE 2017 EXP
357078 5710 D/S INTER 155,537.50 147,138.00 147,138.00 73,568.75 147,138.00 138,438.00 -5.9%
357078 5730 D/S PRINC 280,000.00 290,000.00 290,000.00 .00 290,000.00 300,000.00 3.4%
357078 5760 D/S FA FEE 450.00 1,000.00 1,000.00 500.00 1,000.00 1,000.00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 15
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
DEBT SERVICE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
TOTAL DEBT SERVICE 2017 EXP 435,987.50 438,138.00 438,138.00 74,068.75 438,138.00 439,438.00 .3%
TOTAL DEBT SERVICE FUND 4,476,305.50 4,501,681.00 4,501,681.00 999,890.00 4,501,681.00 4,530,331.00 .6%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 16
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
2011B SINKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
367072 SINKING FUND 2011B EXP
367072 5369 TRUST FEES 962.02 1,500.00 1,500.00 756.17 1,200.00 1,500.00 .0%
367072 7210 TRNSFR OUT .00 50,000.00 50,000.00 .00 .00 50,000.00 .0%
TOTAL SINKING FUND 2011B EXP 962.02 51,500.00 51,500.00 756.17 1,200.00 51,500.00 .0%
TOTAL 2011B SINKING FUND 962.02 51,500.00 51,500.00 756.17 1,200.00 51,500.00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 17
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
502010 WATER DEPARTMENT ADMINISTRATIO
502010 5110 REG SALAR 228,169.35 266,250.00 266,250.00 239,150.12 271,250.00 274,250.00 3.0%
502010 5112 OT SALARY 16,090.62 .00 .00 9,918.69 .00 .00 .0%
502010 5120 MED BNFT 45,079.26 52,000.00 52,000.00 39,585.04 46,000.00 62,000.00 19.2%
502010 5121 DNTL BNFT 1,724.23 2,000.00 2,000.00 1,511.29 2,000.00 2,000.00 .0%
502010 5122 MISC BNFT 486.53 900.00 900.00 432.33 900.00 900.00 .0%
502010 5130 APPAREL 3,922.99 3,000.00 3,000.00 3,563.71 3,600.00 3,600.00 20.0%
502010 5140 PEN CNTRB 45,443.42 42,000.00 42,000.00 37,006.91 42,000.00 45,500.00 8.3%
502010 5210 TRNG REG 1,550.47 7,900.00 7,900.00 6,860.48 7,900.00 2,500.00 -68.4%
502010 5211 TRNG TRAV 332.82 450.00 450.00 815.68 1,000.00 1,000.00 122.2%
502010 5320 BLDG R&M 30,969.90 35,000.00 35,000.00 32,619.69 33,048.52 46,000.00 31.4%
502010 5322 EQUP R&M 3,630.00 5,285.00 5,285.00 1,506.96 4,300.00 4,000.00 -24.3%
502010 5326 VEH MAINT 6,205.79 3,000.00 3,000.00 3,562.48 4,000.00 3,000.00 .0%
502010 5330 DUES 1,138.20 1,400.00 1,400.00 1,208.20 1,400.00 1,400.00 .0%
502010 5335 PRINTING 4,587.45 4,000.00 4,000.00 2,841.99 4,000.00 4,000.00 .0%
502010 5337 POSTAGE 9,740.84 9,000.00 9,000.00 8,043.96 9,000.00 9,000.00 .0%
502010 5350 INS GL 106,866.65 170,500.00 170,500.00 113,095.39 155,000.00 170,500.00 .0%
502010 5362 P/S ENG 6,207.50 30,000.00 30,000.00 25,400.00 30,000.00 30,000.00 .0%
502010 5363 P/S MEDIC 690.00 1,000.00 1,000.00 945.00 1,000.00 1,000.00 .0%
502010 5365 P/S OTHER 2,802.50 3,000.00 3,000.00 1,802.50 3,000.00 3,000.00 .0%
502010 5370 DP SERV 4,188.17 3,971.00 3,971.00 2,939.15 3,800.00 8,280.00 108.5%
502010 5371 CC FEES 24,156.81 10,000.00 10,000.00 16,642.98 20,000.00 20,000.00 100.0%
502010 5410 MISC SUPP 885.09 1,000.00 1,000.00 158.07 1,000.00 1,000.00 .0%
502010 5420 PETR PROD 2,999.77 2,000.00 2,000.00 2,138.71 2,000.00 2,000.00 .0%
502010 5450 OFF SUPP 1,086.89 1,000.00 1,000.00 551.20 1,000.00 1,000.00 .0%
502010 5460 OPER SUPP 1,444.26 1,500.00 1,500.00 554.59 1,500.00 1,500.00 .0%
502010 5550 U/E TELECM 8,276.49 9,200.00 9,200.00 5,667.08 8,500.00 9,400.00 2.2%
502010 5670 DEPR EXP 538,078.89 .00 .00 .00 .00 .00 .0%
502010 5810 OP EQP 299.98 5,850.00 5,850.00 2,128.94 2,267.75 2,250.00 -61.5%
502010 7210 TRNSFR OUT 25,000.00 25,000.00 25,000.00 18,750.01 25,000.00 25,000.00 .0%
502010 7211 TRANS VERF 46,243.00 46,243.00 46,243.00 34,682.26 46,243.00 63,965.00 38.3%
TOTAL WATER DEPARTMENT ADMIN 1,168,297.87 742,449.00 742,449.00 614,083.41 730,709.27 798,045.00 7.5%
502031 WATER DEPT DISTRIBUTION
502031 5110 REG SALAR 28,581.66 74,000.00 74,000.00 46,042.94 74,000.00 74,000.00 .0%
502031 5112 OT SALARY 15,837.23 14,000.00 14,000.00 17,604.55 14,000.00 14,000.00 .0%
502031 5120 MED BNFT 4,785.74 18,000.00 18,000.00 5,568.39 6,000.00 7,000.00 -61.1%
502031 5121 DNTL BNFT 198.16 1,000.00 1,000.00 324.84 1,000.00 1,000.00 .0%
502031 5122 MISC BNFT 45.82 1,300.00 1,300.00 74.86 .00 1,300.00 .0%
502031 5140 PEN CNTRB 7,037.64 14,000.00 14,000.00 9,609.15 14,000.00 16,000.00 14.3%
502031 5320 BLDG R&M 10,603.72 15,000.00 15,000.00 2,629.05 15,000.00 15,000.00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 18
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
502031 5322 EQUP R&M 132,316.58 15,000.00 15,000.00 21,474.20 25,000.00 15,000.00 .0%
502031 5326 VEH MAINT 3,000.00 3,000.00 3,000.00 515.00 3,000.00 3,000.00 .0%
502031 5362 P/S ENG 557.21 30,000.00 30,000.00 17,153.67 5,000.00 30,000.00 .0%
502031 5365 P/S OTHER 11,598.11 10,000.00 10,000.00 8,396.02 10,000.00 10,000.00 .0%
502031 5410 MISC SUPP 409.23 500.00 500.00 339.27 500.00 500.00 .0%
502031 5421 MATERIAL 216.55 500.00 500.00 .00 500.00 500.00 .0%
502031 5422 CHEMICAL 640.00 1,000.00 1,000.00 800.00 1,000.00 2,000.00 100.0%
502031 5423 BUY WATER 3,267,732.86 3,655,000.00 3,655,000.00 3,119,207.90 3,400,000.00 3,999,000.00 9.4%
502031 5460 OPER SUPP 186.40 300.00 300.00 .00 .00 .00 -100.0%
502031 5510 U/E ELECT 69,438.95 90,000.00 90,000.00 76,269.97 90,000.00 90,000.00 .0%
502031 5520 U/E NAT GA 2,126.83 2,500.00 2,500.00 1,510.59 2,500.00 2,500.00 .0%
502031 5810 OP EQP 7,769.13 5,000.00 5,000.00 .00 5,000.00 5,000.00 .0%
TOTAL WATER DEPT DISTRIBUTIO 3,563,081.82 3,950,100.00 3,950,100.00 3,327,520.40 3,666,500.00 4,285,800.00 8.5%
502050 WATER MAIN MAINTENANCE
502050 5110 REG SALAR 252,333.75 248,000.00 248,000.00 207,996.01 248,000.00 267,000.00 7.7%
502050 5111 PT SALARY .00 7,500.00 7,500.00 .00 .00 7,500.00 .0%
502050 5112 OT SALARY 57,963.15 40,000.00 40,000.00 59,620.27 60,000.00 40,000.00 .0%
502050 5120 MED BNFT 51,927.51 57,000.00 57,000.00 52,081.70 60,000.00 45,000.00 -21.1%
502050 5121 DNTL BNFT 2,412.65 3,000.00 3,000.00 1,963.57 3,000.00 3,000.00 .0%
502050 5122 MISC BNFT 1,175.38 3,100.00 3,100.00 261.54 2,600.00 3,100.00 .0%
502050 5140 PEN CNTRB 54,191.48 47,000.00 47,000.00 39,406.53 47,000.00 50,000.00 6.4%
502050 5310 RENT EQP .00 2,000.00 2,000.00 2,031.00 2,000.00 2,000.00 .0%
502050 5321 STRUC R&M 586.85 .00 .00 .00 .00 .00 .0%
502050 5322 EQUP R&M 11,744.93 9,250.00 9,250.00 21,597.42 20,750.00 9,250.00 .0%
502050 5326 VEH MAINT 35,560.12 20,000.00 20,000.00 32,275.65 25,000.00 20,000.00 .0%
502050 5365 P/S OTHER 46,946.34 95,000.00 95,000.00 84,690.65 113,250.00 95,000.00 .0%
502050 5410 MISC SUPP 2,035.66 2,000.00 2,000.00 1,416.85 2,000.00 2,000.00 .0%
502050 5420 PETR PROD 16,636.02 9,000.00 9,000.00 9,627.97 9,000.00 9,000.00 .0%
502050 5421 MATERIAL 237,076.62 175,000.00 175,000.00 200,493.84 175,000.00 175,000.00 .0%
502050 5440 SMTLSEQUP 1,183.59 1,200.00 1,200.00 1,446.31 1,200.00 1,200.00 .0%
502050 5810 OP EQP 6,869.64 14,000.00 14,000.00 6,303.91 14,000.00 4,000.00 -71.4%
TOTAL WATER MAIN MAINTENANCE 778,643.69 733,050.00 733,050.00 721,213.22 782,800.00 733,050.00 .0%
502054 WATER METER MAINTENANCE
502054 5110 REG SALAR 87,732.60 91,500.00 91,500.00 77,514.42 91,500.00 95,000.00 3.8%
502054 5112 OT SALARY 3,172.77 4,000.00 4,000.00 6,141.90 4,000.00 4,000.00 .0%
502054 5120 MED BNFT 24,030.27 25,000.00 25,000.00 21,590.83 25,000.00 27,000.00 8.0%
502054 5121 DNTL BNFT 900.81 1,000.00 1,000.00 801.51 1,000.00 1,000.00 .0%
502054 5122 MISC BNFT 100.06 500.00 500.00 86.60 100.00 500.00 .0%
502054 5140 PEN CNTRB 15,387.67 15,000.00 15,000.00 12,087.21 15,000.00 17,000.00 13.3%
502054 5322 EQUP R&M 1,500.00 1,500.00 1,500.00 1,013.48 1,500.00 1,500.00 .0%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 19
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
WATER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
502054 5326 VEH MAINT 3,500.00 3,500.00 3,500.00 4,849.27 3,500.00 3,500.00 .0%
502054 5365 P/S OTHER .00 40,000.00 40,000.00 40,574.00 40,000.00 35,000.00 -12.5%
502054 5410 MISC SUPP .00 500.00 500.00 .00 500.00 500.00 .0%
502054 5420 PETR PROD 2,595.12 3,500.00 3,500.00 1,903.39 3,500.00 3,500.00 .0%
502054 5810 OP EQP 25,382.13 102,000.00 102,000.00 9,351.67 52,000.00 102,000.00 .0%
TOTAL WATER METER MAINTENANC 164,301.43 288,000.00 288,000.00 175,914.28 237,600.00 290,500.00 .9%
TOTAL WATER FUND 5,674,324.81 5,713,599.00 5,713,599.00 4,838,731.31 5,417,609.27 6,107,395.00 6.9%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 20
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
542010 SEWER ADMINISTRATION
542010 5110 REG SALAR 82,051.03 178,762.00 178,762.00 166,532.74 178,762.00 197,500.00 10.5%
542010 5120 MED BNFT 33,947.00 36,000.00 36,000.00 19,921.75 25,000.00 40,000.00 11.1%
542010 5121 DNTL BNFT 1,305.62 2,000.00 2,000.00 778.62 1,300.00 2,000.00 .0%
542010 5122 MISC BNFT 432.92 900.00 900.00 1,963.79 2,000.00 900.00 .0%
542010 5130 APPAREL 3,444.30 2,500.00 2,500.00 3,115.91 3,000.00 3,000.00 20.0%
542010 5140 PEN CNTRB 31,638.31 28,000.00 28,000.00 25,094.27 35,000.00 39,500.00 41.1%
542010 5210 TRNG REG 2,962.87 1,900.00 1,900.00 .00 400.00 2,000.00 5.3%
542010 5211 TRNG TRAV 324.01 600.00 600.00 665.29 800.00 600.00 .0%
542010 5320 BLDG R&M 34,691.06 35,000.00 35,000.00 32,987.58 33,048.52 46,000.00 31.4%
542010 5322 EQUP R&M 1,200.00 1,200.00 1,200.00 .00 1,200.00 1,200.00 .0%
542010 5326 VEH MAINT 14,000.00 14,000.00 14,000.00 4,116.97 14,000.00 14,000.00 .0%
542010 5330 DUES 1,138.20 1,400.00 1,400.00 1,208.20 1,400.00 1,400.00 .0%
542010 5332 TRAV EXP .00 200.00 200.00 .00 200.00 200.00 .0%
542010 5335 PRINTING 2,081.02 2,000.00 2,000.00 1,411.27 2,000.00 2,000.00 .0%
542010 5337 POSTAGE 4,867.96 5,000.00 5,000.00 4,187.88 5,000.00 5,000.00 .0%
542010 5350 INS GL 139,068.59 220,000.00 220,000.00 145,929.53 180,000.00 220,000.00 .0%
542010 5362 P/S ENG 15,390.00 22,000.00 22,000.00 12,600.00 10,000.00 10,000.00 -54.5%
542010 5363 P/S MEDIC .00 700.00 700.00 570.00 700.00 700.00 .0%
542010 5365 P/S OTHER 2,802.50 4,000.00 4,000.00 1,802.50 4,000.00 4,000.00 .0%
542010 5370 DP SERV 1,478.11 600.00 600.00 784.95 1,200.00 1,200.00 100.0%
542010 5371 CC FEES 13,613.90 5,000.00 5,000.00 9,396.58 12,000.00 12,000.00 140.0%
542010 5410 MISC SUPP 217.70 600.00 600.00 158.07 600.00 600.00 .0%
542010 5420 PETR PROD 2,533.64 2,500.00 2,500.00 1,615.46 2,500.00 2,500.00 .0%
542010 5450 OFF SUPP 678.80 750.00 750.00 568.06 750.00 750.00 .0%
542010 5460 OPER SUPP 60.90 1,200.00 1,200.00 .00 1,200.00 1,200.00 .0%
542010 5550 U/E TELECM 4,618.96 3,800.00 3,800.00 3,252.85 4,300.00 4,700.00 23.7%
542010 5670 DEPR EXP 1,053,278.90 .00 .00 .00 .00 .00 .0%
542010 5710 D/S INTER 938,244.50 908,848.00 908,848.00 454,423.75 908,848.00 874,928.00 -3.7%
542010 5730 D/S PRINC .00 748,000.00 748,000.00 .00 748,000.00 795,000.00 6.3%
542010 5760 D/S FA FEE .00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0%
542010 5762 D/S AMORT -110,406.95 .00 .00 .00 .00 .00 .0%
542010 5810 OP EQP 5,189.06 5,950.00 5,950.00 4,370.98 5,867.75 6,250.00 5.0%
542010 7210 TRNSFR OUT 25,000.00 25,000.00 25,000.00 18,750.01 25,000.00 25,000.00 .0%
542010 7211 TRANS VERF 98,101.00 98,101.00 98,101.00 73,575.76 98,101.00 98,551.00 .5%
TOTAL SEWER ADMINISTRATION 2,403,953.91 2,357,511.00 2,357,511.00 989,782.77 2,307,177.27 2,413,679.00 2.4%
542031 SEWER LINE CONSTRUCTION
542031 5110 REG SALAR 265,284.29 203,300.00 203,300.00 202,610.95 203,300.00 223,000.00 9.7%
542031 5112 OT SALARY 8,614.47 20,000.00 20,000.00 16,886.23 25,000.00 20,000.00 .0%
542031 5120 MED BNFT 50,135.29 45,000.00 45,000.00 29,659.27 35,000.00 42,000.00 -6.7%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 21
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
542031 5121 DNTL BNFT 1,920.28 3,000.00 3,000.00 1,151.16 2,000.00 2,200.00 -26.7%
542031 5122 MISC BNFT 256.47 1,000.00 1,000.00 232.57 500.00 1,000.00 .0%
542031 5140 PEN CNTRB 44,923.23 37,000.00 37,000.00 32,822.01 42,000.00 37,000.00 .0%
542031 5310 RENT EQP .00 500.00 500.00 .00 500.00 500.00 .0%
542031 5321 STRUC R&M 5,494.85 5,500.00 5,500.00 3,305.00 5,500.00 5,500.00 .0%
542031 5322 EQUP R&M 6,635.51 6,500.00 6,500.00 5,410.85 6,500.00 6,500.00 .0%
542031 5326 VEH MAINT 13,574.91 8,000.00 8,000.00 6,296.60 8,000.00 8,000.00 .0%
542031 5420 PETR PROD 11,153.30 10,000.00 10,000.00 8,662.95 10,000.00 10,000.00 .0%
542031 5421 MATERIAL 54,251.68 52,000.00 52,000.00 28,564.68 52,000.00 52,000.00 .0%
542031 5440 SMTLSEQUP 1,035.74 1,000.00 1,000.00 1,286.95 1,200.00 1,000.00 .0%
542031 5460 OPER SUPP 1,133.52 1,200.00 1,200.00 1,159.28 1,400.00 1,200.00 .0%
542031 5810 OP EQP 9,860.98 5,000.00 5,000.00 4,378.62 5,000.00 5,000.00 .0%
TOTAL SEWER LINE CONSTRUCTIO 474,274.52 399,000.00 399,000.00 342,427.12 397,900.00 414,900.00 4.0%
542051 SEWER CLEANING
542051 5110 REG SALAR 166,365.06 182,000.00 182,000.00 145,145.01 182,000.00 190,000.00 4.4%
542051 5111 PT SALARY .00 5,000.00 5,000.00 .00 .00 5,000.00 .0%
542051 5112 OT SALARY 21,309.94 20,000.00 20,000.00 15,595.17 20,000.00 20,000.00 .0%
542051 5120 MED BNFT 42,907.23 35,000.00 35,000.00 43,039.00 31,000.00 45,000.00 28.6%
542051 5121 DNTL BNFT 1,823.94 2,000.00 2,000.00 1,598.59 1,300.00 2,000.00 .0%
542051 5122 MISC BNFT 211.14 1,000.00 1,000.00 174.22 200.00 1,000.00 .0%
542051 5140 PEN CNTRB 31,719.42 33,000.00 33,000.00 23,435.68 32,000.00 34,000.00 3.0%
542051 5310 RENT EQP .00 500.00 500.00 .00 500.00 500.00 .0%
542051 5322 EQUP R&M 5,523.28 4,000.00 4,000.00 5,211.34 4,000.00 4,000.00 .0%
542051 5326 VEH MAINT 22,283.99 12,000.00 12,000.00 18,921.08 20,000.00 20,000.00 66.7%
542051 5365 P/S OTHER 1,949.51 40,000.00 40,000.00 21,939.32 40,000.00 40,000.00 .0%
542051 5410 MISC SUPP 179.40 500.00 500.00 86.16 500.00 500.00 .0%
542051 5420 PETR PROD 6,298.51 4,000.00 4,000.00 5,343.55 5,000.00 5,000.00 25.0%
542051 5421 MATERIAL 5,610.53 7,500.00 7,500.00 8,443.41 8,000.00 7,500.00 .0%
542051 5440 SMTLSEQUP 4,525.26 5,000.00 5,000.00 5,153.91 5,000.00 10,000.00 100.0%
542051 5460 OPER SUPP .00 500.00 500.00 439.25 500.00 500.00 .0%
TOTAL SEWER CLEANING 310,707.21 352,000.00 352,000.00 294,525.69 350,000.00 385,000.00 9.4%
542052 WASTEWATER TREATMENT FACILITY
542052 5110 REG SALAR 715,782.88 732,000.00 732,000.00 634,257.15 749,000.00 789,000.00 7.8%
542052 5111 PT SALARY .00 8,000.00 8,000.00 7,021.00 9,500.00 11,500.00 43.8%
542052 5112 OT SALARY 23,244.48 24,000.00 24,000.00 18,184.31 24,000.00 25,000.00 4.2%
542052 5120 MED BNFT 141,188.56 143,000.00 143,000.00 138,272.52 140,000.00 153,000.00 7.0%
542052 5121 DNTL BNFT 6,124.72 6,000.00 6,000.00 5,594.61 6,000.00 6,500.00 8.3%
542052 5122 MISC BNFT 2,023.60 2,900.00 2,900.00 1,812.71 2,100.00 2,200.00 -24.1%
542052 5130 APPAREL 5,157.98 6,125.00 6,125.00 5,318.39 5,200.00 6,825.00 11.4%
542052 5140 PEN CNTRB 122,490.44 120,000.00 120,000.00 96,504.54 120,000.00 127,500.00 6.3%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 22
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
SEWER FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
542052 5210 TRNG REG 7,813.33 6,200.00 6,200.00 2,806.92 4,400.00 5,000.00 -19.4%
542052 5211 TRNG TRAV 2,325.63 4,000.00 4,000.00 2,785.87 3,500.00 4,000.00 .0%
542052 5320 BLDG R&M 22,482.17 35,500.00 35,500.00 19,572.35 30,100.00 46,100.00 29.9%
542052 5322 EQUP R&M 105,965.00 107,685.00 107,685.00 223,623.67 237,907.00 106,300.00 -1.3%
542052 5326 VEH MAINT 7,500.00 7,500.00 7,500.00 5,457.56 7,500.00 7,500.00 .0%
542052 5330 DUES 2,604.07 2,000.00 2,000.00 2,213.20 2,750.00 2,750.00 37.5%
542052 5335 PRINTING 819.65 1,000.00 1,000.00 1,002.68 1,000.00 1,000.00 .0%
542052 5362 P/S ENG 19,583.88 26,000.00 26,000.00 27,391.32 28,500.00 30,000.00 15.4%
542052 5363 P/S MEDIC .00 1,000.00 1,000.00 665.00 1,400.00 1,500.00 50.0%
542052 5365 P/S OTHER 85,683.52 103,000.00 103,000.00 75,240.81 102,100.00 115,000.00 11.7%
542052 5370 DP SERV 4,833.88 4,061.00 4,061.00 2,802.18 3,900.00 7,187.00 77.0%
542052 5410 MISC SUPP 1,962.28 2,000.00 2,000.00 784.46 2,000.00 2,000.00 .0%
542052 5420 PETR PROD 13,287.88 11,000.00 11,000.00 4,088.05 11,000.00 11,000.00 .0%
542052 5421 MATERIAL 6,833.53 10,000.00 10,000.00 2,952.19 10,000.00 10,000.00 .0%
542052 5422 CHEMICAL 30,793.98 55,000.00 55,000.00 50,283.81 52,000.00 107,500.00 95.5%
542052 5440 SMTLSEQUP 834.48 4,000.00 4,000.00 1,576.43 3,000.00 4,000.00 .0%
542052 5450 OFF SUPP 543.74 1,000.00 1,000.00 563.75 1,000.00 1,000.00 .0%
542052 5460 OPER SUPP 13,648.26 15,000.00 15,000.00 13,254.04 17,500.00 19,000.00 26.7%
542052 5470 R&M SUPP 52,400.98 39,000.00 39,000.00 18,188.02 39,000.00 47,000.00 20.5%
542052 5510 U/E ELECT 224,672.15 275,000.00 275,000.00 249,290.63 250,000.00 275,000.00 .0%
542052 5520 U/E NAT GA 23,198.42 20,000.00 20,000.00 9,397.19 20,000.00 20,000.00 .0%
542052 5530 U/E WATER 13,906.43 10,000.00 10,000.00 14,563.06 15,000.00 15,000.00 50.0%
542052 5550 U/E TELECM 10,796.72 12,300.00 12,300.00 8,274.91 11,400.00 12,500.00 1.6%
542052 5611 PMTS OTHR 42,900.00 55,500.00 55,500.00 31,745.77 43,500.00 43,500.00 -21.6%
542052 5810 OP EQP 7,845.06 6,700.00 6,700.00 3,822.23 6,550.00 13,500.00 101.5%
542052 7211 TRANS VERF 36,801.00 36,801.00 36,801.00 27,600.75 36,801.00 36,940.00 .4%
TOTAL WASTEWATER TREATMENT F 1,756,048.70 1,893,272.00 1,893,272.00 1,706,912.08 1,997,608.00 2,065,802.00 9.1%
TOTAL SEWER FUND 4,944,984.34 5,001,783.00 5,001,783.00 3,333,647.66 5,052,685.27 5,279,381.00 5.5%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 23
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
REFUSE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
582030 REFUSE COLLECTION
582030 5337 POSTAGE 1,399.34 2,000.00 2,000.00 1,138.74 2,000.00 2,000.00 .0%
582030 5350 INS GL 6,059.99 9,900.00 9,900.00 6,566.83 8,000.00 9,900.00 .0%
582030 5371 CC FEES 3,165.21 5,000.00 5,000.00 2,209.99 4,000.00 5,000.00 .0%
582030 5390 OTHER 9,850.31 10,000.00 10,000.00 9,715.81 10,000.00 10,000.00 .0%
582030 5391 REF COLCT 1,316,423.21 1,435,450.00 1,435,450.00 1,234,232.01 1,435,450.00 1,485,000.00 3.5%
582030 5410 MISC SUPP 6,000.00 10,000.00 10,000.00 6,220.00 10,000.00 10,000.00 .0%
582030 7210 TRNSFR OUT 25,000.00 25,000.00 25,000.00 18,750.01 25,000.00 25,000.00 .0%
TOTAL REFUSE COLLECTION 1,367,898.06 1,497,350.00 1,497,350.00 1,278,833.39 1,494,450.00 1,546,900.00 3.3%
582053 REFUSE LEAF COLLECTION
582053 5112 OT SALARY 11,035.47 .00 .00 .00 .00 .00 .0%
582053 5120 MED BNFT 1,144.10 .00 .00 .00 .00 .00 .0%
582053 5121 DNTL BNFT 46.34 .00 .00 .00 .00 .00 .0%
582053 5122 MISC BNFT 8.31 .00 .00 .00 .00 .00 .0%
582053 5140 PEN CNTRB 1,508.86 .00 .00 .00 .00 .00 .0%
582053 5322 EQUP R&M 44,246.34 40,000.00 40,000.00 26,922.90 40,000.00 40,000.00 .0%
582053 5326 VEH MAINT 11,037.95 8,000.00 8,000.00 1,599.38 8,000.00 8,000.00 .0%
582053 5420 PETR PROD 11,501.50 11,500.00 11,500.00 .00 11,500.00 11,500.00 .0%
582053 5460 OPER SUPP 1,885.58 1,200.00 1,200.00 .00 1,200.00 1,200.00 .0%
582053 7210 TRNSFR OUT 46,961.88 93,250.00 93,250.00 .00 93,250.00 93,250.00 .0%
582053 7211 TRANS VERF 10,708.00 10,708.00 10,708.00 8,031.01 10,708.00 79,493.00 642.4%
TOTAL REFUSE LEAF COLLECTION 140,084.33 164,658.00 164,658.00 36,553.29 164,658.00 233,443.00 41.8%
TOTAL REFUSE FUND 1,507,982.39 1,662,008.00 1,662,008.00 1,315,386.68 1,659,108.00 1,780,343.00 7.1%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 24
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
COMMUTER PARKING FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
602019 COMM PARK COMBINED FUNDING
602019 5110 REG SALAR 14,060.16 14,000.00 14,000.00 14,144.35 14,000.00 14,000.00 .0%
602019 5120 MED BNFT 3,049.86 5,000.00 5,000.00 2,657.42 5,000.00 5,000.00 .0%
602019 5121 DNTL BNFT 129.20 400.00 400.00 114.34 400.00 400.00 .0%
602019 5122 MISC BNFT 18.94 100.00 100.00 16.73 100.00 100.00 .0%
602019 5140 PEN CNTRB 2,577.44 2,500.00 2,500.00 2,118.81 2,500.00 2,500.00 .0%
602019 5320 BLDG R&M 22,601.21 31,000.00 31,000.00 23,748.51 31,000.00 25,000.00 -19.4%
602019 5350 INS GL 2,693.33 4,400.00 4,400.00 2,918.59 4,000.00 4,400.00 .0%
602019 5390 OTHER 4,716.38 29,000.00 29,000.00 5,379.38 29,000.00 29,000.00 .0%
602019 5510 U/E ELECT 1,841.69 3,300.00 3,300.00 1,279.05 3,300.00 3,300.00 .0%
602019 7210 TRNSFR OUT 37,500.00 37,500.00 37,500.00 28,125.00 37,500.00 37,500.00 .0%
TOTAL COMM PARK COMBINED FUN 89,188.21 127,200.00 127,200.00 80,502.18 126,800.00 121,200.00 -4.7%
602038 COMM PARK VILLAGE OWNED
602038 5110 REG SALAR 14,060.16 14,000.00 14,000.00 14,144.35 14,000.00 14,000.00 .0%
602038 5120 MED BNFT 3,049.86 5,000.00 5,000.00 2,657.42 5,000.00 5,000.00 .0%
602038 5121 DNTL BNFT 129.20 400.00 400.00 114.34 400.00 400.00 .0%
602038 5122 MISC BNFT 18.94 100.00 100.00 16.73 100.00 100.00 .0%
602038 5140 PEN CNTRB 2,577.44 2,500.00 2,500.00 2,118.81 2,500.00 2,500.00 .0%
602038 5322 EQUP R&M 1,425.00 11,000.00 11,000.00 4,175.15 11,000.00 5,000.00 -54.5%
602038 5350 INS GL 2,693.33 4,400.00 4,400.00 2,918.59 4,000.00 4,400.00 .0%
602038 5390 OTHER 19,757.28 23,000.00 23,000.00 25,126.37 23,000.00 23,000.00 .0%
602038 5510 U/E ELECT 2,743.75 5,000.00 5,000.00 2,056.73 5,000.00 5,000.00 .0%
602038 5670 DEPR EXP 26,737.44 .00 .00 .00 .00 .00 .0%
602038 7210 TRNSFR OUT 37,500.00 37,500.00 37,500.00 28,125.00 37,500.00 37,500.00 .0%
TOTAL COMM PARK VILLAGE OWNE 110,692.40 102,900.00 102,900.00 81,453.49 102,500.00 96,900.00 -5.8%
TOTAL COMMUTER PARKING FUND 199,880.61 230,100.00 230,100.00 161,955.67 229,300.00 218,100.00 -5.2%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 25
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
GARAGE FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
702050 GARAGE FUND EXPENDITURES
702050 5110 REG SALAR 207,019.85 213,500.00 213,500.00 182,876.30 213,500.00 225,500.00 5.6%
702050 5112 OT SALARY 15,652.15 20,000.00 20,000.00 11,397.78 20,000.00 20,000.00 .0%
702050 5120 MED BNFT 23,929.36 30,000.00 30,000.00 21,759.72 24,000.00 33,000.00 10.0%
702050 5121 DNTL BNFT 897.02 2,000.00 2,000.00 1,188.61 1,000.00 2,000.00 .0%
702050 5122 MISC BNFT 2,298.17 2,500.00 2,500.00 2,115.83 2,500.00 2,500.00 .0%
702050 5130 APPAREL 1,284.53 1,000.00 1,000.00 1,236.69 1,200.00 1,200.00 20.0%
702050 5140 PEN CNTRB 38,797.33 37,000.00 37,000.00 28,972.30 37,000.00 39,000.00 5.4%
702050 5210 TRNG REG 817.86 5,300.00 5,300.00 61.35 1,500.00 5,300.00 .0%
702050 5211 TRNG TRAV 751.40 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0%
702050 5322 EQUP R&M 4,536.55 9,000.00 9,000.00 7,413.46 9,000.00 9,000.00 .0%
702050 5332 TRAV EXP .00 400.00 400.00 .00 400.00 400.00 .0%
702050 5350 INS GL 12,242.42 20,000.00 20,000.00 13,266.32 17,000.00 20,000.00 .0%
702050 5410 MISC SUPP 1,479.35 1,500.00 1,500.00 645.05 1,500.00 1,500.00 .0%
702050 5420 PETR PROD 1,222.82 1,000.00 1,000.00 666.73 1,000.00 1,000.00 .0%
702050 5421 MATERIAL 4,956.51 5,000.00 5,000.00 2,078.38 5,000.00 5,000.00 .0%
702050 5440 SMTLSEQUP 5,387.78 7,000.00 7,000.00 2,777.11 7,000.00 7,000.00 .0%
702050 5450 OFF SUPP 61.93 300.00 300.00 .00 300.00 300.00 .0%
702050 5470 R&M SUPP 105,441.24 110,000.00 110,000.00 83,436.75 110,000.00 110,000.00 .0%
702050 5530 U/E WATER 2,033.08 2,500.00 2,500.00 4,927.37 .00 2,500.00 .0%
702050 5550 U/E TELECM 936.81 900.00 900.00 589.24 800.00 900.00 .0%
702050 5810 OP EQP 2,661.44 2,500.00 2,500.00 .00 75.00 200.00 -92.0%
702050 7211 TRANS VERF 1,700.00 1,700.00 1,700.00 1,274.99 1,700.00 1,700.00 .0%
TOTAL GARAGE FUND EXPENDITUR 434,107.60 474,100.00 474,100.00 366,683.98 455,475.00 489,000.00 3.1%
TOTAL GARAGE FUND 434,107.60 474,100.00 474,100.00 366,683.98 455,475.00 489,000.00 3.1%
VILLAGE OF DEERFIELD
NEXT YEAR / CURRENT YEAR BUDGET ANALYSIS
Report generated: 11/08/2023 11:42
User: eburk
Program ID: bgnyrpts
Page 26
PROJECTION: 20241 CY 2024 MASTER BUDGET PROJECTION FOR PERIOD 99
ACCOUNTS FOR:
2022 2023 2023 2023 2023 2024 PCT
POLICE PENSION FUND ACTUAL ORIG BUD REVISED BUD ACTUAL PROJECTION BOARD REVW CHANGE
806010 POLICE PENSION FUND EXPENDITUR
806010 5141 PEN PYMNT 3,352,949.07 3,605,000.00 3,605,000.00 2,872,435.60 3,500,000.00 3,700,000.00 2.6%
806010 5142 SEP REFND 9,859.76 15,000.00 15,000.00 18,075.43 20,000.00 15,000.00 .0%
806010 5330 DUES 795.00 1,000.00 1,000.00 .00 1,000.00 1,000.00 .0%
806010 5332 TRAV EXP 1,127.39 5,000.00 5,000.00 389.12 1,000.00 5,000.00 .0%
806010 5350 INS GL 5,781.00 6,000.00 6,000.00 .00 6,000.00 6,000.00 .0%
806010 5360 P/S CRP CN 9,198.51 7,500.00 7,500.00 3,180.60 8,500.00 7,500.00 .0%
806010 5365 P/S OTHER 17,698.00 18,400.00 18,400.00 9,000.00 17,500.00 20,200.00 9.8%
806010 5369 TRUST FEES 8,295.08 5,000.00 5,000.00 66,943.14 70,000.00 25,000.00 400.0%
806010 5390 OTHER 10,775.00 13,000.00 13,000.00 1,250.00 13,000.00 13,000.00 .0%
TOTAL POLICE PENSION FUND EX 3,416,478.81 3,675,900.00 3,675,900.00 2,971,273.89 3,637,000.00 3,792,700.00 3.2%
TOTAL POLICE PENSION FUND 3,416,478.81 3,675,900.00 3,675,900.00 2,971,273.89 3,637,000.00 3,792,700.00 3.2%
TOTAL REVENUE .00 .00 .00 .00 .00 .00 .0%
TOTAL EXPENSE 55,244,878.93 57,331,634.38 57,331,634.38 44,447,716.45 54,436,102.98 59,735,938.00 4.2%
GRAND TOTAL 55,244,878.93 57,331,634.38 57,331,634.38 44,447,716.45 54,436,102.98 59,735,938.00 4.2%
** END OF REPORT - Generated by Eric Burk **