2019-2023 Five Year PlanVILLAGE OF OAK BROOK
2019-2023
Five -Year Financial Plan
OF o
r
ouNii
Village of Oak Brook, Illinois
1200 Oak Brook Road
Oak Brook, Illinois 60523
www.oak-brook.org
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
TABLE OF CONTENTS
SECTION
PAGE
Introduction
3
General Assumptions
3
Relationship to the Annual Budget
4
General Corporate Fund
6
Hotel/Motel Tax Fund
21
Motor Fuel Tax Fund
27
Infrastructure Fund
31
Promenade Special Tax Allocation Fund
36
Water Fund
40
Sports Core Fund
45
Golf Surcharge Fund
55
Self -Insurance Fund
59
Garage Fund
63
Equipment Replacement Fund
68
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
INTRODUCTION
The Village of Oak Brook Five -Year Financial Plan is intended to provide the community with a long-range projection of the financial condition for each
of the ten funds that comprise the financial structure of the Village of Oak Brook. The Five -Year Plan assumes the continuation of current service levels
and being able to maintain those levels in future years. The forecast provides a foundation for discussion and policy decisions that will be made in the
future to maintain the existing service levels and/or enhance service levels in specific areas.
Each fund in the Village's financial structure is a separate financial entity. Although the Village's audited financial statements are prepared on an accrual
or modified accrual basis (as applicable and consistent with generally accepted accounting principles as promulgated by the Governmental Accounting
Standards Board), the Five -Year Financial Plan, like the annual Municipal Budget, is prepared and presented on a cash basis. This results in a more easily
understood and more useful document.
The presentation for each fund includes a summary, revenue projections, a general long-range operating budget and a capital improvement program, if
applicable. The Capital Improvements Program focuses on all vehicles and all capital items that are over $5,000. The summary for each fund reflects
the revenue and expenditure projections and presents a rolling five-year operating statement, beginning with cash available as of January 1, 2018 as
reported in the audited financial statements as of December 31, 2017.
GENERAL ASSUMPTIONS
The principal assumptions for the Five -Year Financial Plan involve the rates for general inflation, "personnel inflation" (direct personnel costs as well as
costs of fringe benefits and training), interest rates, and the rate of growth in sales tax, the principal revenue source of the Village. The 2019-2023 Five -
Year Financial Plan is based on the following general assumptions:
Inflation is the measure of the increase in the cost of goods and services. Inflation is measured by the Consumer Price Index and impacts
most expenditure categories. For the purpose of this report, inflation for the purchase of goods and services and operational and
contractual services are forecasted at 2.5%.
• Personnel inflation, (including benefits, training and merit adjustments applicable to personnel not at top -of -grade) are factored at 4.5%
per year.
Interest earnings on invested funds at rates ranging from less than 0.2% to 2.0%, depending upon the available cash in the fund, the type
of investment, and length of investment.
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
Sales tax receipts for 2019 are projected to increase 1.0% from the adjusted 2018 estimated cash collections. Adjustments to future sales
tax receipts include new businesses entering and leaving the Village known at the time of creating this document. For each year
thereafter the sales tax receipts are projected to increase 1.5%. Receipts from the non -home rule sales tax, are projected using the same
assumptions as the growth in general sales tax receipts. Additionally, non -home rule sales tax receipts are reduced by 1.5% in years 2019-
2023 to account for the State of Illinois administrative collection fee.
• State income tax receipts have been reduced by 5% in years 2019-2023 to reflect recent changes in the State of Illinois budget.
In years 2019-2023, the long-range operating budget projections are adjusted by an experience factor intended to take into account normal positive
variances in expenditures across the thousands of accounts that make up the Village's financial structure and to partially offset the effects of
compounding of the inflation assumptions in the later years. Other assumptions specific to particular funds are described in the narrative preceding the
presentation of each fund.
RELATIONSHIP TO THE ANNUAL BUDGET
For 2019, staff has prepared the 2019-2023 Five -Year Plan, 2019 Budget, and 2019 Program Objectives concurrently. This is done in order to streamline
the budget process by reducing the amount of time spent overall by staff and the Village Board on budget -related activities.
The 2019 Budget and 2019-2023 Five -Year Plan continues the Village Board directive that staff should prioritize items for inclusion in the 2019 Budget
and Five -Year Financial Plan using the following hierarchy:
• Projects or expenditures necessary to maintain or replace critical equipment, projects already started yet not completed, projects that are the
recipient of grant funding, and items required to comply with Illinois and Federal law.
• Projects or expenditures that will directly contribute to increased revenues from sales tax, utility and telecommunications taxes, and
Hotel/Motel taxes.
• Projects or expenditures that will significantly increase the efficiency of Village operations.
• Projects or expenditures that will significantly improve the safety, convenience, or quality of life for residents, non-residents, and businesses.
• Projects or expenditures that will improve the aesthetics of the Village.
• Discretionary projects or expenditures that add new services or amenities.
4
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
The actual 2019 Municipal Budget is provided in a separate document; whereas, the Five -Year Financial Plan is structured by Fund, the operating budget
is structured according to cost centers (called "programs") and is presented at a level of detail far beyond that reflected in the Five -Year Plan. The
capital improvement budget is based on the capital improvement program for the first year of the Five -Year Plan.
At the fund level in the Budget document, revenue budgets are brought together with operating and capital' improvement expenditure budgets to
present a cash -basis income statement for each fund (called a "Fund Summary"). The Fund Summary can be compared to the first year of the relevant
Five -Year Financial Plan Summary to ensure that the Budget matches the first year of the Five -Year Plan for that fund.
5
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
GENERAL CORPORATE FUND
DESCRIPTION:
The General Corporate Fund is the main operating fund of the Village which provides core services for its operations of the major Village departments
such as Police, Fire, Library, and many other administrative departments. Capital improvements, contributions to pension funds (in lieu of property tax
levies), transfers to the Garage and Equipment Replacement Funds (through user charges), and loans to other funds as appropriate are all included in
the General Fund.
OVERVIEW:
The Village's budget methodology is to estimate revenues conservatively and to maintain a spending level less than or equal to current year resources.
The General Corporate Fund 2019 Budget is operating at a balanced budget where revenues are at or exceed expenditures without using cash reserves.
The proposed 2019 General Fund Revenues totals $24.8 million, a decrease of $1.3 million, or 5.1%, over the 2018 budgeted revenues. The total
General Fund spending in the proposed 2019 Budget is $24.8 million, a decrease of $1.4 million, or 5.2%, from the 2018 Budget. The following
highlights some of the major budget issues facing the Village for 2019 and beyond:
Police and Fire pension legislation requires municipalities to have pension funds 90% funded by the year 2040 rather than being 100% funded.
This provides municipalities with some relief; however, additional measures are necessary in order for the Village to meet its future pension
obligations. The Village continues to fund its annual obligation; however, over the past 10 years the contribution for police and fire pension
plans has increased from $1.3 million in 2008 to $3.8 million in 2017, or 192.3%. Pension contributions were budgeted at $4.0 million in fiscal
year 2018 and are budgeted at $4.1 million in 2019. The pension issue needs to be addressed by the State as the funding for these plans is
becoming increasingly unaffordable for all Illinois municipalities.
With the departure of McDonald's headquarters in 2018, the sustainability of various revenue sources remain uncertain. The loss of nearly
3,000 employees, as well as numerous business visitors could have a negative impact on revenue sources such has sales tax and
telecommunications tax. At this time, the exact economic impact of McDonald's corporate move is still being determined, but assumed
decreases were factored into the 2019 budget as a result. Although the Village is losing McDonald's, commercial development has been strong,
with the Village gaining numerous companies such as KiclZania, Lifetime Fitness, Senior Lifestyle, and Carvana. The Village must continue to
monitor the changing economic climate and plan future budgets accordingly.
A number of items within the State of Illinois 2019 Budget have an impact on Oak Brook. The State's 2019 budget includes a 5% cut in Local
Government Distributive Fund (LGDF) disbursements to local governments. The Oak Brook 2019 proposed budget was prepared using the
assumption that this reduction will continue into the State's 2020 budget, which begins July 1, 2019. The impact on Oak Brook is projected to
2
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
be nearly $40,000 in lost revenue to the General Fund. Additionally, the State is charging a 1.5% tax collection fee on locally administered taxes.
This is applicable to the Village's Non -Home Rule Sales Tax that is recorded in the Infrastructure Fund. The impact on Oak Brook is projected to
be nearly $85,000 in lost revenue to the Infrastructure Fund.
The future of health insurance is constantly changing and makes us wonder what future costs will bring. With the passage of the Affordable Care
Act (ACA) and subsequent requirements, the village has made many modifications to its plan designs and structure. The uncertainty surrounding
required reporting, associated penalties, and the Cadillac tax goes into effect in 2020. The ACA presents the Village a number of challenges in
forecasting and budgeting for federally mandated increases in benefits and taxes. The Village continues to prepare to the greatest extent
possible by obtaining competitive rates from our broker and carriers as well as tracking our plans to ensure they do not hit the Cadillac tax
threshold. We will continue to conservatively budget in order to prepare for unforeseen circumstances related to the on-going implementation
of the ACA.
Funding of Capital Improvements at the Sports Core, Village municipal buildings, vehicle replacements, and water main replacements continue
to be a challenge to prioritize and address all of the funding needs. A study for Fire Station 93 is planned for 2019. Facility studies for the
remainder of Village properties will be planned over the next few years. A water rate study was completed in the last quarter of 2015 to
determine any changes to water rates and future funding needed for major water system improvements. The result of the study indicated the
need for rate increases between 7-10% from 2016-2020. The Village updated this plan in late 2018 and recommended a 5% increase for 2019.
The Village completed a study of its vehicle fleet maintenance and replacement during 2017. Staff is in the progress of implementing changes
identified in this study, including investigating leasing options for vehicles and equipment.
The Village's 2019 — 2023 Five -Year Financial Plan represents the current conditions and future viability of the Village's finances. The overall objective of
this plan is to provide analytical information for key budgetary decisions that will allow the Village to accomplish its goals over the next five-year period
and beyond.
Revenues:
The principal source of revenue to the General Corporate Fund, and to the Village, is the sales tax. As a result, the rate of growth in sales tax receipts
determines, to a significant extent, the Village's ability to meet the needs of the community and its overall financial condition. It has been the practice
of the Village to project growth in sales tax receipts conservatively, and that practice is continued in this edition of the Five -Year Financial Plan (See
GENERAL ASSUMPTIONS). For 2019, sales tax revenue is projected to be $12.3 million, which is up slightly from the 2018 projected receipts. The 2019
sales tax estimate is down $0.1 million, or 1.0%, from the 2018 budgeted amount.
7
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
Receipts from the utility tax on electric, natural gas, and telecommunications service are expected to end the year at $5.9 million, an increase of $0.1
million, or 1.1% compared to the 2018 budget. Utility tax collections for 2019 are budgeted to be down $0.2 million from the 2018 estimated amount
due to the departure of McDonald's in 2018. Inflationary increases of 1.0% have been assumed in subsequent years 2020 - 2023.
State shared revenues in total are projected using information provided by the Illinois Municipal League for budget year 2019. The State Income Tax is
projected to increase $13,600, or 1.9%, compared to the 2018 projected amount. This is due to a change of the 10% reduction from the State of Illinois
to 5% that occurred in mid -2018. Use tax is expected to decrease $4,775, or 2.3%, from the 2018 projected amount. Replacement Tax is expecting to
decrease $13,375, or 5.1%, from 2018 projected amount. State shared revenues are projected to increase by 2.0% in years 2020 — 2023. The rates
imposed for a number of license and fee categories, such as building permits are projected to increase and should positively impact revenues.
Investment returns can significantly fluctuate depending on market conditions; therefore, interest revenue is projected at $330,000 for 2019 due to the
balance of cash on hand and current interest rates. Most other revenue sources are projected to increase from 0% to 3% per year for the duration of
the Five -Year Financial Plan.
Expenditures;
Legislative and General Management
This department involves a wide variety of general -scope functions including the operations of the Village Board and the offices of the Village Clerk,
Village Manager, Village Attorney, and Human Resources.
• The Village Clerk program includes the addition of 0.35 FTE related to an Administrative Assistant position. This position is split between two
other programs (Human Resources and Accounting and Reporting) and takes the place of a previous part-time position.
• The Legal program includes Labor Attorney fees of $45,000 budgeted for Fire union negotiations.
• The Human Resources budget includes $30,000 for the continuation of a tuition reimbursement program for employees seeking an advanced
degree. The Human Resources program also includes the addition of 0.35 FTE for an Administrative Assistant position.
• The Risk Management program reflects a decrease in liability insurance premiums in 2019. The liability insurance budget has decreased from
$346,250 in 2018 to $293,500 in 2019. This is due to the use of an IRMA surplus balance in 2019 to offset annual premium costs and an overall
decrease in claims history of late.
• Information Technology budget includes the addition of a part-time I.T. Technician position. Part of this position was formally contracted for
the village -wide document -imaging project. Duties have been expended to also include I.T. support to all departments. The contracted support
budget has been reduced from $67,400 to $15,400 related to this part-time position. The Information Technology budget also includes $35,000
for a Village phone system upgrade. A 10% portion of the IT Director's salary and benefits will continue to be allocated to the Geographic
Information System program in year 2019.
M
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
Financial Services
This department includes all functions related to the Village's financial management activities.
The Accounting and Reporting program reflects an increase due to the addition of 0.35 FTE for a payroll Administrative Assistant. In addition,
Ambulance Billing Service expenses increased $32,500 due to an increase in rates charged by the Village, which is offset by an increase in
revenue collected.
The Interfund Transfers program includes a cost reimbursement of $131,315 to Infrastructure for administrative costs. This program also
includes a transfer of $816,725 to the Sports Core Fund to assist with capital improvements at the Bath and Tennis Club.
Public Works
This department is in charge of maintenance of the Village's physical infrastructure consisting of buildings, streets, pathways, trees and vehicular
equipment. The department also is responsible for operation of the water utility.
The Municipal Buildings Improvements budget includes $459,900 in capital improvements budgeted for 2019 to improve and maintain Village
facilities.
Library
This department provides professional, responsive service and promotes the development of independent, self-confident and literate citizens through
the provision of open access to cultural, recreational, intellectual and informational resources.
• The Library General Operations budget includes the reorganization of various part-time positions the improve operating efficiencies.
• The Library Youth Services budget includes the addition of a 12 week part-time Summer Reading Assistant intern position.
Police
This department provides the community with law enforcement services and preserves and protects lives, property, and constitutional guarantees.
R1
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
The Police Field Services program includes a decrease in full-time salaries due to the retirement and replacement of multiple senior positions.
This program also includes $22,000 for a Patrol Outfitted ATV and $70,000 for 10 In -Care Camera Units.
Police Support Services Records includes DuComm fees of $481,515, a 2.7% increase from 2018.
Police pension contributions are budgeted at $2.0 million, an increase of $180,120 or 10.0% compared to the 2018 budget. This amount
reflects 100% of the actuarial determined contribution amount.
Fire
This department provides superior professional services in the areas of fire, rescue and emergency medicine dedicated to exceeding the evolving needs
of our community.
• Fire, Rescue, and EMS Operations includes a $262,500 decrease in overtime from the 2018 budget due to the additional use of contracted
paramedics. This program also includes $79,475 in capital requests, including fire gear replacement, station alerting upgrades, and more.
• The Emergency Medical Services program includes an increase of $259,580 in contract services due to the increase of contracted paramedic
staff from 6 to 11 employees. This program also includes $59,700 in capital requests, including Zoll Monitor/Defibrillator, Zoll Auto Pulse CPR
Units, and AED Units.
Fire pension contributions are budgeted at $2.1 million, a decrease of $40,730, or 1.9%, compared to the 2018 Budget. This amount reflects
100% of the actuarial determined contribution amount.
Department 9 — Development Services
This department is responsible for implementing the Village's Comprehensive Plan, zoning regulations, building codes, subdivision regulations, and
other Village codes as they relate to the built environment of the community.
• The Development Services Management program includes the Director's salary and benefits continue to be split between the Engineering
program (40%) and the Development Services program (60%). The Village Planner position continues to have 40% of salary and benefits
reimbursed by the Hotel Fund for work done on beautification projects.
Exceptional Charges:
Exceptional Charges in the General Corporate Fund include:
Contributions to the Police and Firefighters' Pension Funds (in lieu of property taxes). These contributions are expected to increase for the
duration of the Five -Year Financial Plan.
10
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
• Vehicle replacement charges are funded in the General Corporate Fund with 100% of funding contributions in years 2020 - 2023. The
Equipment Replacement fund projected cash balance (page 75) factors in General Fund contributions for years 2019-2023 and will continue
to be a healthy fund.
• An annual reimbursement to the Infrastructure Fund in order to offset costs (primarily administrative) funded by the Infrastructure Fund
that relate to General Corporate Fund activities.
Capital Improvements:
Significant capital expenditures reflected in the Plan include continued outlays for maintaining our current technology systems, Heritage Center
improvements, renovations to the Police Department, improvements to Fire Stations 93 and 94, replacement of critical equipment in the fire
department, Butler Government Center improvements, and many more. The prioritization of specific projects are reviewed annually during the budget
process and included if the General Corporate Fund has sufficient funds, but projecting them this far in advance is very difficult.
OTHER CONSIDERATIONS:
It is the financial policy of the Village Board to make every effort to maintain a six month reserve fund for operating expenses. The six month reserve
fund is expected to end 2019 at 9.3 months once all of the budget changes noted here have been fully implemented. Oak Brook's current philosophy is
to always try to keep reserves at or above 6 months even in downtimes. During years when we are in unexpected difficult economic times or having a
significant unplanned expenditure, this excess fund balance could be used to keep the village at or above the 6 month reserve funding without making
drastic cuts in services or personnel to deal with one or two years of financial issues.
11
Unrestricted Cash Available, January 1, 2017
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Interfund Loan
Interfund Loan Repayment
Adjusted Cash Available
Less Capital Improvement Program
Unrestricted Cash Available at Year -End
6 Months Operating Expenditures
# of Months Reserve
$17,526,141
12
Village of Oak Brook
2019-2023 Five -Year Financial Plan
GENERAL CORPORATE FUND
Summary
2018
2018
2019
2020
2021
2022
2023
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
$26,155,895
$25,661,120
$25,320,945
$24,250,941
$24,738,038
$25,063,794
$25,398,409
18,534,895
18,255,425
18,776,305
18,626,210
19,263,549
20,137,413
20,829,813
4,593,765
4,399,750
5,549,520
4,652,543
4,672,639
4,695,347
4,779,184
3,027,235
3,005,945
995,120
972,188
801,850
231,034
(210,588)
17,526,141
17,526,141
17,346,306
17,478,951
16,757,764
16,431,089
16,264,048
20,553,376
20,532,086
18,341,426
18,451,139
17,559,614
16,662,123
16,053,460
0
0
0
0
0
0
0
0
0
0
0
0
0
0
20,553,376
20,532,086
18,341,426
18,451,139
17,559,614
16,662,123
16,053,460
3,022,840
3,185,780
862,475
1,693,375
1,128,525
398,075
391,875
$17,530,536
$17,346,306
$17,478,951
$16,757,764
$16,431,089
$16,264,048
$15,661,585
$11,049,958
$11,049,958
$11,288,858
$11,396,180
$11,718,395
$12,159,239
$12,540,799
9.5
9.4
9.3
8.8
8.4
8.0
7.5
12
Village of Oak Brook
2019-2023 Five -Year Financial Plan
GENERAL CORPORATE FUND
Revenue Projections
13
2018
2018
2019
2020
2021
2022
2023
Description
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Genera I Sales Tax
12,453,000
12,318,500
12,325,000
12,509,875
12, 697,523
12,887,986
13,081,306
State Income Tax
674,200
729,400
743,000
757,860
773,017
788,478
804,247
Replacement Tax
251,000
261,375
248,000
252,960
258,019
263,180
268,443
York Township Road and Bridge Tax
24,000
35,000
30,000
30,000
30,000
30,000
30,000
State Use Tax
195,500
211,525
206,750
210,885
215,103
219,405
223,793
Charitable Games Tax
500
310
300
300
300
300
300
Grants
12,500
25,000
13,500
13,500
13,500
13,500
13,500
TelecommunicationsTax/Utility
5,792,250
6,076,000
5,857,500
5,916,075
5,975,236
6,034,988
6,095,338
Total Intergovernmental
19,402,950
19,657,110
19,424,050
19,691,455
19,962,698
20,237,836
20,516,927
Liquor License
185,000
185,000
185,000
185,000
185,000
185,000
185,000
Scavenger Licenses
10,000
8,000
8,000
8,000
8,000
8,000
8,000
Taxi Licenses
20,000
15,000
15,000
15,000
15,000
15,000
15,000
Tobacco License
1,200
1,200
1,200
1,200
1,200
1,200
1,200
Raffle Licenses
500
500
500
500
500
500
500
Building Permits
1,250,000
2,500,000
1,800,000
1,000,000
1,000,000
1,000,000
1,000,000
Electrical Permits
70,000
60,000
70,000
70,000
70,000
70,000
70,000
Plumbing Permits
20,000
15,000
20,000
20,000
20,000
20,000
20,000
Alarm Application Fee
34,000
37,000
37,000
37,000
37,000
37,000
37,000
Annual Alarm Permit Fee
120
100
100
100
100
100
100
Accessory Structure Permits
75,000
65,000
75,000
75,000
75,000
75,000
75,000
HVAC Permits
25,000
20,000
25,000
25,000
25,000
25,000
25,000
Demolition Permits
7,500
11,000
7,500
7,500
7,500
7,500
7,500
Application/Occupancy Fees
40,000
42,000
40,000
40,000
40,000
40,000
40,000
Miscellaneous Licenses & Permits
45,000
55,000
50,000
50,000
50,000
50,000
50,000
Solicitation Permits
750
750
750
750
750
750
750
Total Licenses and Permits
1,784,070
3,015,550
2,335,050
1,535,050
1,535,050
1,535,050
1,535,050
Elevator Inspections
125,000
115,000
115,000
115,000
115,000
115,000
115,000
Zoning/Subdivision Appl. Fees
12,500
20,000
15,000
15,000
15,000
15,000
15,000
Plan Review Fees
25,000
26,000
25,000
25,000
25,000
25,000
25,000
Building/Inspection Fees
120,000
121,000
120,000
120,000
120,000
120,000
120,000
Ambulance Fees
725,500
1,185,000
1,741,000
1,758,410
1,775,994
1,793,754
1,811,692
Toll Road Fire Service
40,000
43,000
40,000
40,000
40,000
40,000
40,000
Special Services -EMS
5,000
5,500
5,000
5,250
5,513
5,788
6,078
13
Village of Oak Brook
2019-2023 Five -Year Financial Plan
GENERAL CORPORATE FUND
Revenue Projections
2018 2018 2019 2020 2021 2022 2023
Description Budget Estimate Budget Projection Projection Projection Projection
Special Services -Fire
5,000
7,000
5,000
5,250
5,513
5,788
6,078
False Alarm -Fire
4,000
3,500
3,500
3,500
3,500
3,500
3,500
Compliance
5,000
6,500
5,000
5,000
5,000
5,000
5,000
Fingerprinting
2,700
1,500
2,000
2,000
2,000
2,000
2,000
Special Services -Police
150,000
140,000
140,000
147,000
154,350
162,068
170,171
Field Services -Police
100
100
100
100
100
100
100
Misc. Support Services -Police
4,300
4,300
4,000
4,000
4,000
4,000
4,000
False Alarm -Police
24,000
23,000
23,000
23,000
23,000
23,000
23,000
Eng. Plan Review & Inspection
7,500
5,000
7,500
7,500
7,500
7,500
7,500
Subdivision Review & Inspection
2,500
0
0
0
0
0
0
Fire Plan Review Fees
20,000
20,000
20,000
20,000
20,000
20,000
20,000
Library Services
9,000
5,500
3,300
3,300
3,300
3,300
3,300
Bad Debt
(270,000)
(135,000)
(223,000)
(225,230)
(227,482)
(229,757)
(232,055)
Ambulance Insurance Unallowable
0
(339,000)
(560,000)
(565,600)
(571,256) .
(576,969)
(582,738)
Total Charges for Services
1,017,100
1,257,900
1,491,400
1,508,480
1,526,031
1,544,072
1,562,625
Court Fines
120,000
125,000
120,000
123,600
127,308
131,127
135,061
Village Fines
22,000
25,000
25,000
25,000
25,000
25,000
25,000
Administrative Towing Fees
35,000
32,000
30,000
30,000
30,000
30,000
30,000
Administrative Fines
2,500
12,000
7,500
7,875
8,269
8,682
9,116
Library Fines
6,000
5,500
5,500
5,500
5,500
5,500
5,500
Interest
195,000
330,000
330,000
174,790
335,155
328,622
325,281
IMF/Franchise Fees
215,000
214,000
213,000
219,390
225,972
232,751
239,733
Rental Income
112,750
143,000
144,000
223,175
230,430
237,930
245,675
Road Maintenance Reimbursement
15,000
15,000
15,000
15,450
15,914
16,391
16,883
Miscellaneous
40,000
200,000
40,000
40,000
40,000
40,000
40,000
Installment Contract Proceeds
2,475,165
0
0
0
0
0
0
Total Other Revenues
3,238,415
1,101,500
930,000
864,780
1,043,547
1,056,003
1,072,249
Transfer From Equipment Replacement Fund
0
0
508,235
0
0
0
0
Reimbursements From Other Funds
713,360
629,060
632,210
651,176
670,712
690,833
711,558
Total Interfund Revenues
713,360
629,060
1,140,445
651,176
670,712
690,833
711,558
Total Revenue
26,155,895
25,661,120
25,320,945
24,250,941
24,738,038
25,063,794
25,398,409
14
Exceptional Charges
Police Pension Contribution
Village of Oak Brook
$1,946,715
$1,988,740
$2,018,170
$2,012,290
$2,006,940
2019-2023 Five -Year Financial Plan
Firefighters' Pension Contribution
2,149,300
2,064,690
2,108,570
2,147,980
GENERAL CORPORATE FUND
2,174,125
2,216,965
Vehicle Replacement Charges
247,030
247,030
Long -Range Operating Budget
341,360
350,315
361,025
369,845
Transfer to DuComm Building Reserve
2018 2018 2019
2020
2021
2022
2023
10,000
Budget Estimate Budget
Projection
Projection
Projection
Projection
135,033
139,084
Personnel
$13,995,430 $13,822,605 $14,086,435
$14,815,205
$15,582,022
$16,388,887
$17,237,908
Materials and Supplies
532,820 527,360 559,780
573,775
588,119
602,822
617,892
Operations and Contractual
4,006,645 3,905,460 4,130,090
4,217,557
4,322,996
4,431,071
4,541,848
Total Operating Budget
$18,534,895 $18,255,425 $18,776,305
$19,606,537
$20,493,137
$21,422,780
$22,397,649
Adjustment for Budget Goal Attainment
$18,776,305
$18,626,210
$19,263,549
$20,137,413
$20,829,813
Exceptional Charges
Police Pension Contribution
$1,808,620
$1,946,715
$1,988,740
$2,018,170
$2,012,290
$2,006,940
$2,034,820
Firefighters' Pension Contribution
2,149,300
2,064,690
2,108,570
2,147,980
2,160,950
2,174,125
2,216,965
Vehicle Replacement Charges
247,030
247,030
94,385
341,360
350,315
361,025
369,845
Transfer to DuComm Building Reserve
10,000
10,000
10,000
10,000
10,000
10,000
10,000
Reimbursement to Infrastructure Fund
131,315
131,315
131,100
135,033
139,084
143,257
147,554
Transfer to Sports Core Fund
0
0
1,216,725
0
0
0
0
Installment Contract Debt Service
247,500
0
0
0
0
0
0
Total Exceptional Charges
$4,593,765
$4,399,750
$5,549,520
$4,652,543
$4,672,639
$4,695,347
$4,779,184
Capital Improvement Program
(See Schedule)
$3,022,840
$3,185,780
$862,475
$1,693,375
$1,128,525
$398,075
$391,875
Total Budget
$26,151,500
$25,840,955
$25,188,300
$24,972,128
$25,064,712
$25,230,834
$26,000,873
15
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
General Fund
2018 2018 2019 2020 2021 2022 2023 Total
Project Name Budget Projected Budget Projection Projection Projection Projection 2019-2023
Legislative and General Management:
Computer Hardware and Software
Total Program 151
Butler Government Center:
Undesignated Repairs/Safety Projects
Interior Painting
Administration Coffee Bar/Reception Area
New Office Furniture
Department Mailboxes and Furniture
Board Room Ramp
Board Room Carpet
Board Room Seating and Table Refinish
Board Room Photo
Police Dep. Remodel/Addition
Police Dep. Upstairs Carpet
Police Dep. Admin. Kitchen Remodel
Redesign East Entrance
Development Services Counter
BGC Roof
Server Room A/C Units
Computer Lab A/C Unit
Generator Emergency Power Survey
Village Hall Carpet Replace West Wing
West Wing Painting
Galvanized Plumbing Replacement
$ 183,200 $ 183,200 $ 171,400 $ 125,000 $ 150,000 $ 125,000 $ 150,000 $ 721,400
$ 183,200 $ 183,200 $ 171,400 $ 125,000 $ 150,000 $ 125,000 $ 150,000 $ 721,400
$ 15,000 $ - $
15,000 $
15,000 $
15,000 $
15,000 $ 15,000 $
75,000
5,000 -
5,000
5,000
5,000
- 5,000
20,000
- -
15,000
-
-
- -
15,000
- 20,605
4,500
4,500
4,500
4,500 4,500
22,500
- -
5,000
-
-
- -
5,000
- -
-
20,000
-
- -
20,000
- -
-
50,000
-
- -
50,000
- -
-
100,000
-
- -
100,000
- -
-
125,000
-
- -
125,000
2,475,165 2,475,165
-
-
-
- -
-
- -
-
-
61,950
- -
61,950
- -
10,000
-
-
- -
10,000
- -
-
-
75,000
- -
75,000
- -
-
15,000
-
- -
15,000
- -
-
-
500,000
- -
500,000
- -
-
70,000
-
- -
70,000
-
-
-
31,000
- -
31,000
- -
30,000
-
-
- -
30,000
50,000 88,000
-
-
-
- -
-
5,000 -
5,000
5,000
5,000
- 5,000
20,000
15,000 -
15,000
15,000
-
- -
30,000
16
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
General Fund
17
2018
2018
2019
2020
2021
2022
2023
Total
Project Name
Budget
Projected
Budget
Projection
Projection
Projection
Projection
2019-2023
Village Hall Exterior Beautification
7,500
-
7,500
7,500
7,500
7,500
7,500
37,500
Ductwork Cleaning
10,000
-
10,000
10,000
10,000
10,000
10,000
50,000
Electric Door Strikes
15,000
7,500
15,000
15,000
15,000
15,000
15,000
75,000
Upper Level Bathroom Remodel
-
-
-
-
-
-
-
-
Lower Level Bathroom Remodel
-
75,690
-
-
-
-
-
-
Irrigation System
-
-
-
15,000
-
-
-
15,000
Fire Station 94:
Painting
-
-
5,000
5,000
5,000
-
5,000
20,000
Station 94 Apparatus Floor Patching
10,000
-
-
15,000
-
-
-
15,000
Station 94 Reseal Apparatus Floor
-
-
-
60,000
-
-
-
60,000
Station 94 Ceiling Fans
5,000
-
5,000
-
-
-
-
5,000
Kitchen Remodel
-
-
-
50,000
-
-
50,000
Apparatus Floor Speakers
-
5,000
-
-
-
-
5,000
Outdoor Signage
-
-
-
-
10,000
-
10,000
Furniture
-
5,000
5,000
-
-
-
10,000
Beds
-
6,000
-
-
-
-
6,000
Fire Station 93:
Building Needs Study
25,000
-
30,000
-
-
-
-
30,000
Painting Outside/Bird Proofing
-
-
10,000
-
-
-
-
10,000
Door Close Safety System
-
-
-
40,000
-
-
-
40,000
Bunk & Bathroom Remodel
-
112,350
-
-
-
-
-
-
Interior Painting
-
-
5,000
-
-
-
-
5,000
Carpet Replacement
-
-
-
10,000
-
-
-
10,000
Outdoor Signage
-
-
-
-
10,000
-
-
10,000
17
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
General Fund
18
2018
2018
2019
2020
2021
2022
2023
Total
Project Name
Budget
Projected
Budget
Projection
Projection
Projection
Projection
2019-2023
Window Replacement
-
-
-
-
60,000
-
-
60,000
Apparatus Floor Resurfacing and Refinishing
-
-
-
-
-
75,000
-
75,000
Workout Room Dividing Wall and Door
-
-
-
-
-
-
75,000
75,000
Workout Room A/C Unit
-
-
-
-
-
-
25,000
25,000
Furniture
-
-
5,000
5,000
-
-
-
10,000
Beds
-
-
6,000
-
-
-
-
6,000
Generator Replacement
-
-
-
75,000
-
-
-
75,000
Public Works Building:
Recondition/Reseal Garage Floor
25,000
-
25,000
25,000
25,000
25,000
-
100,000
Garage Exhaust Fans
-
-
-
125,000
-
-
-
125,000
Pressure Washer Electric and Gas Replacement
20,000
19,900
-
-
-
-
-
-
Heritage Center:
HVAC
-
-
-
306,000
-
-
-
306,000
Repoint Exterior
25,000
10,000
25,000
25,000
25,000
25,000
-
100,000
Painting
-
-
5,000
5,000
5,000
5,000
-
20,000
Library:
New Sign on 31st Street
15,000
5,055
-
-
-
-
-
-
Floor Retile
-
-
-
15,000
-
-
-
15,000
Lobby Electrical Improvements
5,000
-
-
-
-
-
-
-
Bathroom Remodel
-
-
25,000
-
-
-
-
25,000
Office Painting
5,000
-
5,000
5,000
-
5,000
5,000
20,000
Carpeting Replacement
-
-
-
200,000
-
-
-
200,000
Exterior Wood Siding Maintenance
-
-
-
20,000
-
-
-
20,000
Electrical Improvements
-
-
10,000
-
-
-
-
10,000
HVAC Controls Upgrade
-
-
90,000
-
-
-
-
90,000
Exterior Landscaping
-
-
10,000
-
-
-
-
10,000
18
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
General Fund
2018 2018 2019 2020 2021 2022 2023 Total
Project Name Budget Projected Budget Projection Projection Projection Projection 2019-2023
Convert Computer Lab to Conference Room - - 15,000 - - - 15,000
Sound Dampening - Lobby - - 10,700 - - - - 10,700
Sound Dampening - Study Rooms - - 10,200 - - - - 10,200
Combine Reference and Youth Services Desks - - 10,000 - - - - 10,000
Total Program 421 $ 2,732,665 $ 2,814,265 $ 459,900 $ 1,413,000 $ 909,950 $ 197,000 $ 172,000 3,151,850
Police:
Hand Gun Replacement
Patrol Outfitted ATV
In -Car Camera Units (10)
Speed Enforcement Trailer
Total Program 621
Fire:
Fire Gear Replacement
LDH Fire Hose
Gear Dryer - Station 93
Station Alerting Upgrades
Refrigerator/Freezer - Station 93
Emergency Vehicular Lighting
Starcom Portable Radios
Office Chairs
Mattresses - Stations 93 and 94
Gear Extractor
Thermal Imaging Camera
Total Program 700
$ - $ - $ - $ 35,000 $ - $ - $ - 35,000
- 22,000 - - - - 22,000
- 70,000 - - - - 70,000
7,900 7,900 - - - - - -
$ 7,900 $ 7,900 $ 92,000 $ 35,000 $ - $ - $ - 127,000
$ 21,875 $
72,165 $
21,875 $
21,875 $
21,875 $ 21,875 $
21,875 $ 109,375
10,000
-
10,000
10,000
- -
- 20,000
-
-
8,000
-
- -
- 8,000
-
-
10,000
-
- -
- 10,000
-
-
5,000
-
- -
- 5,000
-
33,050
-
-
- -
- -
-
8,000
-
-
- -
- -
-
-
7,600
7,600
7,600 7,600
7,600 38,000
-
-
17,000
-
- -
- 17,000
-
-
-
15,000
- -
- 15,000
7,500
7,500
-
7,500
- 7,500
- 15,000
$ 39,375 $
120,715 $
79,475 $
61,975 $
29,475 $ 36,975 $
29,475 $ 237,375
19
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
General Fund
2018 2018 2019 2020 2021 2022 2023 Total
Project Name Budget Projected Budget Projection Projection Projection Projection 2019-2023
Zoll Monitor/Defibrillator
$ 35,200
$ 35,200 $
35,200
$ 35,200
$ 35,200 $
35,200 $
35,200
$ 176,000
Zoll Auto Pulse CPR Units
18,000
18,000
18,000
18,000
-
-
-
36,000
AED Units
6,500
6,500
6,500
5,200
3,900
3,900
5,200
24,700
Total Program 731
$ 59,700
$ 59,700 $
59,700
$ 58,400
$ 39,100 $
39,100 $
40,400
$ 236,700
Total General Corporate Fund
$ 3,022,840
$ 3,185,780 $
862,475
$ 1,693,375
$ 1,128,525 $
398,075 $
391,875
$ 4,474,325
20
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
HOTEL/MOTEL TAX FUND
DESCRIPTION:
This fund is used to account for funds collected from imposition of the Village's Hotel/Motel Tax. State law requires that for non -home rule
communities this revenue must be devoted to programs and activities designed to increase tourism and overnight stays in hotels located within the
Village. For 2006 and prior, most expenditures of funds from the tax were those recommended by the Hotel, Convention and Visitors Committee and
specifically approval of the Village Board. Beginning in 2007, the Village Board established a Hotel Beautification District designed to improve and
maintain the landscape and hardscape features in the areas served by the hotels also in order to increase overnight stays in hotels located within the
Village. Village code dedicates 1% of the 3% Hotel/Motel Tax rate to funding activities of the Hotel, Convention and Visitors Committee; the remaining
2% of the 3% rate is dedicated to funding the Hotel District streetscape projects.
OVERVIEW:
Revenue:
For 2019, revenues from the 3% Hotel/Motel Tax are projected to be $1.3 million, which is decrease of $72,000, or 5.4%, compared to the 2018 Budget
and down $28,000, or 2.2%, 2018 projected amount. For 2020 and thereafter, revenue is projected to increase 1.0% per year.
Operations (1% Fund):
For 2019, the projections reflect expenditures for marketing efforts of the Hotel, Convention and Visitors Committee, as well as payments to the
DuPage Convention and Visitors Bureau equal to 25% of the first 1% of the Hotel Tax imposed. Thereafter, expenditures increase approximately 3.0%
per year.
Exceptional Charges:
The Plan reflects an annual transfer to the General Corporate Fund for administrative services from the Hotel, Convention and Visitors Committee for a
portion of the Village Planner.
Capital Improvement Program (2% Fund):
21
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
The 2019 Budget includes pedestrian access improvements budgeted for $269,010, median and street lighting projects for $3,886,535, and median
plantings for $25,000. Thereafter, additional outlays of specific projects are budgeted for improvements and maintenance in the Hotel Beautification
District.
22
Unrestricted Cash Available, January 1, 2018
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated Unrestricted Cash Balance at Year -End
$4,145,455
Village of Oak Brook
2019-2023 Five -Year Financial Plan
HOTEL/MOTEL TAX FUND
Summary
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
$1,370,000 $1,365,980 $1,298,000 $1,286,240 $1,300,694 $1,310,780 $1,322,301
596,515
560,050
577,860
449,270
458,970
468,920
479,170
99,550
99,550
103,115
106,208
109,395
112,677
116,057
673,935
706,380
617,025
730,762
732,329
729,183
727,074
4,145,455
4,145,455
4,711,485
1,147,965
1,438,727
856,056
560,239
4,819,390
4,851,835
5,328,510
1,878,727
2,171,056
1,585,239
1,287,313
690,000
140,350
4,180,545
440,000
1,315,000
1,025,000
525,000
$4,129,390
$4,711,485
$1,147,965
$1,438,727
$856,056
$560,239
$762,313
23
Village of Oak Brook
2019-2023 Five -Year Financial Plan
HOTEL/MOTEL TAX FUND
Revenue Projections
24
2018
2018
2019
2020
2021
2022
2023
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Hotel/Motel Tax
$1,340,000
$1,296,000
$1,268,000
$1,280,500
$1,293,500
$1,306,500
$1,319,500
Interest
30,000
67,000
30,000
5,740
7,194
4,280
2,801
Miscellaneous
0
2,980
0
0
0
0
0
Total Revenue
$1,370,000
$1,365,980
$1,298,000
$1,286,240
$1,300,694
$1,310,780
$1,322,301
24
Village of Oak Brook
2019-2023 Five -Year Financial Plan
HOTEL/MOTEL TAX FUND
Long -Range Operating Budget
25
2018
2018
2019
2020
2021
2022
2023
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Operations and Contractual
$596,515
$560,050
$577,860
$449,270
$458,970
$468,920
$479,170
Total Operating Budget
$596,515
$560,050
$577,860
$449,270
$458,970
$468,920
$479,170
Exceptional Charges
Reimbursement to General Fund
$99,550
$99,550
$103,115
$106,208
$109,395
$112,677
$116,057
Total Exceptional Charges
$99,550
$99,550
$103,115
$106,208
$109,395
$112,677
$116,057
Capital Improvement Program
Hotel Beautification and Projects
$690,000
$140,350
$4,180,545
$440,000
$1,315,000
$1,025,000
$525,000
Total Budget
$1,386,065
$799,950
$4,861,520
$995,478
$1,883,365
$1,606,597
$1,120,227
25
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
Hotel Tax Fund
2018 2018 2019 2020 2021 2022 2023 Total
Project Name Budget Projected Budget Projection Projection Projection Projection 2019-2023
Median/Streetlighting Projects
Connect McDonalds Irrigation System (Jorie Blvd) $
40,000 $
40,000
$ - $
-
$ - $ - $
- $ -
Design - Jorie, York, Perimeter of OB Center
30,000
-
-
-
- -
- -
Design - Jorie, Kensington, Forest Gate
-
37,900
$ 1,112,910 $
-
$ - $ - $
- $ 1,112,910
Construction - Jorie, Kensington, Forest Gate
-
-
2,723,625
-
- -
- 2,723,625
Design - York, 16th Street
-
-
-
40,000
- -
- 40,000
Construction - York, 16th Street
-
-
-
-
1,000,000 1,000,000
- 2,000,000
Perimeter of OB Center Plantings
-
12,450
-
-
- -
- -
Median Plantings
20,000
50,000
25,000
25,000
25,000 25,000
25,000 125,000
TBD Additional projects
-
-
50,000
250,000
250,000 -
500,000 1,050,000
Total Median/Streetlighting Projects $
90,000 $
140,350
$ 3,911,535 $
315,000
$ 1,275,000 $ 1,025,000 $
525,000 $ 7,051,535
Pedestrian Access Projects:
Spring/Harger Connection Ph2 (Proj C) Const 100,000 - - - - - - -
16th Street Connection (Proj A) Const 250,000 - - - - - - -
16th Street/Spring Road Connection/Street Light! - - $ - $ 125,000 $ - $ - $ - $ 125,000
Oak Brook Center to 16th St. Connection - - - - 40,000 - - 40,000
Jorie Blvd. - - 269,010 - - - - 269,010
TBD Additional projects 250,000 - - - - - - -
Total Pedestrian Access Projects $ 600,000 $ - $ 269,010 $ 125,000 $ 40,000 $ - $ - $ 434,010
Total Hotel and Motel Fund $ 690,000 $ 140,350 $ 4,180,545 $ 440,000 $ 1,315,000 $ 1,025,000 $ 525,000 $ 7,485,545
26
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
MOTOR FUEL TAX FUND
DESCRIPTION:
The Motor Fuel Tax (MFT) Fund is used to account for funds distributed to the Village by the State of Illinois pursuant to the MFT distribution formula.
State law limits the use of these funds for specified purposes. This edition of the Five -Year Financial Plan continues the practice of periodically allocating
MFT funds to eligible street resurfacing and reconstruction projects.
OVERVIEW:
Revenue:
The Motor Fuel Tax is levied on a cents -per -gallon basis and is deposited into a segregated fund at the State level. From there, funds are distributed to
local governments on a per -capita basis, according to a formula and based on the last certified census. Actual collections in 2018 are projected to be
$201,000. Revenues for 2019 are budgeted at $197,750, a decrease of $3,250, or 1.6%, over projected 2018 collections. For years, 2020 — 2023
revenues are projected to increase 2.0% each year.
Exceptional Charges:
Funds are projected to be transferred to the Infrastructure Fund as needed for related Motor Fuel Tax projects. For 2019, a $900,000 transfer to the
Infrastructure Fund is budgeted.
27
Unrestricted Cash Available, January 1, 2018
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated Unrestricted Cash Balance at Year -End
$568,661
Village of Oak Brook
2019-2022 Five -Year Financial Plan
MOTOR FUEL TAX FUND
Summary
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
$210,160 $211,500 $203,750 $202,086 $205,880 $209,924 $214,071
0
0
0
0
0
0
0
500,000
7,790
900,000
250,000
220,000
220,000
215,000
(289,840)
203,710
(696,250)
(47,914)
(14,120)
(10,076)
(929)
568,661
568,661
772,371
76,121
28,207
14,087
4,011
278,821
772,371
76,121
28,207
14,087
4,011
3,082
0
0
0
0
0
0
0
$278,821
$772,371
$76,121
$28,207
$14,087
$4,011
$3,082
28
o
Village of Oak Brook
2019-2022 Five -Year Financial Plan
MOTOR FUEL TAX FUND
Revenue Projections
2018
2018 2019
2020
2021
2022
2023
Budget
Estimate Budget
Projection
Projection
Projection
Projection
Motor Fuel Tax Allotments
$204,160
$201,000 $197,750
$201,705
$205,739
$209,854
$214,051
Interest
6,000
10,000 6,000
381
141
70
20
Miscellaneous
0
500 0
0
0
0
0
Total Revenue
$210,160
$211,500 $203,750
$202,086
$205,880
$209,924
$214,071
o
Village of Oak Brook
2019-2022 Five-Year Financial Plan
MOTOR FUEL TAX FUND
Long-Range Operating Budget
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
Exceptional Charges
Transfer to Infrastructure Fund $500,000 $7,790 $900,000 $250,000 $220,000 $220,000 $215,000
Total Exceptional Charges $500,000 $7,790 $900,000 $250,000 $220,000 $220,000 $215,000
30
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
INFRASTRUCTURE FUND
DESCRIPTION:
The Infrastructure Fund was established to separately account for revenues and expenditures related to certain categories of capital projects including
street resurfacing/reconstruction, safety pathways and drainage projects. Due to statutory restrictions on use, beginning in 2005 the Village's non -
home rule sales tax of 0.25% (authorized by referendum in 2004) became the major source of funding for this Fund. In April, 2007 a second referendum
was passed and the rate of tax increased to 0.50% effective January 1, 2008 (collections began in April, 2008). Periodic transfers from the Motor Fuel
Tax Fund have been made in order to supplement the roadway maintenance program. In 2005 and after, most operating costs of the Public Works and
Engineering Departments have been shifted to this fund.
OVERVIEW:
Revenue:
Revenue from the Village's Non -Home Rule Sales Tax is projected at $5.5 million for 2019, which represents a $15,000 decrease from the 2018 budget
and a $1,000 decrease from the 2018 projected amount. As is the case with the General Sales Tax, 20% of the incremental Non -Home Rule Sales Taxes
generated by the Promenade Development are required to be deposited in the Promenade Special Tax Allocation Fund. Thereafter, for 2020 — 2023,
the revenues are estimated to grow approximately 1.5% per year (See GENERAL ASSUMPTIONS). Transfers from the Motor Fuel Tax Fund are reflected
as needed in order to supplement the roadway maintenance program. Reimbursements from the General Corporate Fund are reflected in order to
allocate costs (mostly administrative) that are funded by the Infrastructure Fund that relate to activities in these funds.
Operations:
The 2019 Budget continues the outsourcing of the Village project engineering functions.
Capital Improvements:
The 2019 Street Improvement project will occur for approximately $2.3 million, including engineering. Additional projects are scheduled to begin in
2019, including: Salt Dome Construction for $3,985,000, York/1-88 Bridge for $762,420, and Harger Road Bike Path for $1,750,000. A full list of all
projects is included in this document.
31
Unrestricted Cash Available, January 1, 2018
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated Unrestricted Cash Balance at Year -End
$8,181,503
Village of Oak Brook
2019-2023 Five -Year Financial Plan
INFRASTRUCTURE FUND
Summary
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
$6,291,130 $5,882,920 $7,082,570 $7,667,740 $6,294,440 $6,390,788 $6,483,740
3,042,625
2,873,760
3,238,820
3,137,676
3,197,775
3,304,820
3,321,095
225,395
225,395
240,370
269,606
276,012
282,034
294,504
3,023,110
2,783,765
3,603,380
4,260,458
2,820,653
2,803,934
2,868,141
8,181,503
8,181,503
8,314,568
1,994,373
(7,446,094)
(11,392,611)
(11,995,342)
11,204,613
10,965,268
11,917,948
6,254,831
(4,625,441)
(8,588,677)
(9,127,201)
5,555,620
2,650,700
9,923,575
13,700,925
6,767,170
3,406,665
2,633,475
$5,648,993
$8,314,568
$1,994,373
($7,446,094)
($11,392,611)
($11,995,342)
($11,760,676)
32
33
Village of Oak Brook
2019-2023 Five -Year Financial Plan
INFRASTRUCTURE FUND
Revenue Projections
2018
2018 2019
2020
2021
2022
2023
Budget
Estimate Budget
Projection
Projection
Projection
Projection
Non -Home Rule Sales Tax
$5,563,000
$5,549,000 $5,548,000
$5,631,220
$5,715,688
$5,801,424
$5,888,445
G ra nts
0
0 0
1,428,100
0
0
0
Interest
42,000
140,000 80,000
9,972
0
0
0
Transfer From Equipment Replacement Fund
0
0 216,125
0
0
0
0
Transfer From Motor Fuel Tax Fund
500,000
7,790 900,000
250,000
220,000
220,000
215,000
Reimbursements From Other Funds
181,130
181,130 333,445
343,448
353,752
364,364
375,295
Miscellaneous
5,000
5,000 5,000
5,000
5,000
5,000
5,000
Total Revenue
$6,291,130
$5,882,920 $7,082,570
$7,667,740
$6,294,440
$6,390,788
$6,483,740
33
Personnel
Materials and Supplies
Operations and Contractual
Capital Outlay (not C.I.P.)
Miscellaneous
Total Operating Budget
Adjustment for Budget Goal Attainment
Exceptional Charges
Vehicle Replacement Charges
Reimbursement to Other Funds
Total Exceptional Charges
Capital Improvement Program
(See Schedule)
Total Budget
60,530 60,530 78,835 103,225 104,640 105,520 112,695
164,865 164,865 161,535 166,381 171,372 176,514 181,809
225,395 225,395 240,370 269,606 276,012 282,034 294,504
5,555,620 2,650,700 9,923,575 13,700,925 6,767,170 3,406,665 2,633,475
$8,823,640 $5,749,855 $13,402,765 $17,108,207 $10,240,957 $6,993,518 $6,249,074
34
Village of Oak Brook
2019-2023 Five -Year Financial Plan
INFRASTRUCTURE FUND
Long -Range Operating Budget
2018
2018
2019
2020
2021
2022
2023
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
$1,365,445
$1,328,735
$1,322,375
$1,371,181
$1,421,917
$1,523,501
$1,529,497
182,955
174,660
246,845
253,016
259,342
265,825
272,471
1,424,225
1,300,365
1,584,600
1,624,215
1,664,820
1,706,440
1,749,102
70,000
70,000
85,000
20,000
20,000
20,000
20,000
0
0
0
0
0
0
0
3,042,625
2,873,760
3,238,820
3,268,413
3,366,078
3,515,766
3,571,069
3,238,820
3,137,676
3,197,775
3,304,820
3,321,095
60,530 60,530 78,835 103,225 104,640 105,520 112,695
164,865 164,865 161,535 166,381 171,372 176,514 181,809
225,395 225,395 240,370 269,606 276,012 282,034 294,504
5,555,620 2,650,700 9,923,575 13,700,925 6,767,170 3,406,665 2,633,475
$8,823,640 $5,749,855 $13,402,765 $17,108,207 $10,240,957 $6,993,518 $6,249,074
34
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
Infrastructure Fund
2018 2018 2019 2020 2021 2022 2023 Total
Project Name Budget Projected Budget Projection Projection Projection Projection 2019-2023
Drainage Maintenance
Salt Dome/Storage Drainage Design $ 168,500 $ 188,525 $ - $ - $ - $ - $ - $ -
Salt Dome/Storage Drainage Construction - - 3,985,000 - - - - 3,985,000
Total Program 364 $ 168,500 $ 188,525 $ 3,985,000 $ - $ - $ - $ - $ 3,985,000
Roadway Improvements
Street Resurfacing/Reconstruction
Street Cracksealing
Luthin/Enterprise Reconstruction
York Road/1-88 Bridge
York Road/Harger Road Intersection
York Road/Harger Road Bike Path
B&T Circle Construction
Harger Road Bike Path Design
Harger Road Bike Path Construction
Windsor Bridge/Street Design
Windsor Bridge (Tollway)
Windsor Bridge/Street Construction
Total Program 461
$ 2,800,000 $ 1,233,275 $ 2,331,580 $ 2,750,000 $ 2,750,000 $ 3,000,000 $ 3,000,000 $13,831,580
-
-
-
75,000
75,000
75,000 75,000 300,000
-
-
621,000
-
-
- - 621,000
762,420
762,420
762,420
653,505
-
- - 1,415,925
1,210,000
133,500
257,300
6,270,000
-
- - 61527,300
634,700
117,500
-
-
-
- - -
-
-
616,275
-
-
- - 616,275
30,000
-
-
-
-
- - -
-
-
1,750,000
-
-
- - 1,750,000
350,000
415,480
-
-
-
- - -
-
-
-
762,420
762,420
762,420 - 2,287,260
-
-
-
3,600,000
3,600,000
- - 7,200,000
5,787,120
$ 2,662,175
$ 6,338,575
$14,110,925
$ 7,187,420
$ 3,837,420 $ 3,075,000 $34,549,340
Total Infrastructure Fund ,$ 5,955,620 $ 2,850,700 $10,323,575 $14,110,925 $ 7,187,420 $ 3,837,420 $ 3,075,000 $38,534,340
Less Engineering Fees $ (400,000) $ (200,000) $ (400,000) $ (410,000) $ (420,250) $ (430,755) $ (441,525) (2,102,530)
Net Capital Budget $) 5,555,620 $ 2,650,700 $ 9,923,575 $13,700,925 $ 6,767,170 $ 3,406,665 $ 2,633,475 $36,431,810
Note - Totals above include engineering costs that are recorded as operation and contractual expenses. $400,000 is budgeted as engineering
fees in account 461-76200 related to the roadway improvements.
35
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
PROMENDADE SPECIAL TAX ALLOCATION FUND
DESCRIPTION:
The Promenade Special Tax Allocation Fund was established in 2006 as a result of a redevelopment agreement approved by the Village Board that
provides for Tax Increment Financing (T.I.F.) for certain infrastructure improvements for the Promenade Development. As provided for in the
redevelopment agreement, the Village has issued a limited obligation note of $4.25 million bearing interest at 8%. The note is secured by 100% of the
incremental real estate taxes and 20% of the incremental sales taxes generated by the Promenade Development. The note is not a general obligation of
the Village and the Village's liability is limited to the pledge of incremental revenues previously noted for a period not to exceed 15 years.
OVERVIEW:
Revenue:
Revenues from the incremental real estate tax revenue generated by the development are projected based on sales tax projections from the General
and Infrastructure Funds. For 2020 and thereafter, real estate tax revenues are projected based on increasing at 1.5%. Sales tax receipts from the
General Fund and Infrastructure Fund is included based on 20% of the expected General Sales Tax and Non -Home Rule Sales Tax expected to be
generated from the development.
Exceptional Charges:
Exceptional charges consist of debt service on the $4.25 million limited obligation notes that were issued in early 2008. The notes provide in November
each year the Village is to notify the holders of the notes as to the amount funds expected to be on hand to fund debt service for the subsequent year.
Based on the amounts projected to be available for the succeed year debt service payments are to scheduled to be applied to (1) interest on past due
interest, (2) current interest, and (3) repayment of principal. For the 2019 Budget and years 2020-2023, principal and interest payments are projected
based on the original repayment schedule.
36
Unrestricted Cash Available, January 1, 2018 $276,164
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated Unrestricted Cash Balance at Year -End
Village of Oak Brook
2019-2023 Five -Year Financial Plan
PROMENADE SPECIAL TAX ALLOCATION (T.I.F.) FUND
Summary
2018 2018 2019
Budget Estimate Budget
2020 2021 2022 2023
Projection Projection Projection Projection
$487,750 $474,070 $460,900 $465,226 $470,377 $475,585 $480,853
4,090
4,090
4,210
4,315
4,423
4,534
4,647
459,820
489,820
460,980
476,880
483,770
490,715
222,460
23,840
(19,840)
(4,290)
(15,969)
(17,816)
(19,664)
253,746
276,164
276,164
256,324
252,034
236,065
218,249
198,585
300,004
256,324
252,034
236,065
218,249
198,585
452,331
0
0
0
0
0
0_
0
$300,004
$256,324
$252,034
$236,065
$218,249
$198,585
$452,331
37
Village of Oak Brook
2019-2023 Five -Year Financial Plan
PROMENADE SPECIAL TAX ALLOCATION (T.I.F.) FUND
Revenue Projections
2018
2018
2019
2020
2021
2022
2023
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Real Estate Taxes $385,000
$373,120
$360,000
$363,600
$367,236
$370,908
$374,617
Sales Tax 102,500
100,000
100,000
101,500
103,023
104,568
106,136
Interest 250
950
900
126
118
109
99
Total Revenue $487,750
$474,070
$460,900
$465,226
$470,377
$475,585
$480,853
38
Village of Oak Brook
2019-2023 Five -Year Financial Plan
PROMENADE SPECIAL TAX ALLOCATION (T.I.F.) FUND
Long -Range Operating Budget
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
Operations and Contractual $4,090 $4,090 $4,210 $4,315 $4,423 $4,534 $4,647
Total Operating Budget 4,090 4,090 4,210 4,315 4,423 4,534 4,647
Exceptional Charges
Debt Service Interest 262,820 262,820 243,980 225,980 205,370 182,515 81,950
Debt Service Principal 197,000 227,000 217,000 250,900 278,400 308,200 140,510
Total Exceptional Charges 459,820 489,820 460,980 476,880 483,770 490,715 222,460
Total Budget $ 463,910 $ 493,910 $ 465,190 $ 481,195 $ 488,193 $ 495,249 $ 227,107
39
VILLAGE OF OAK BROOK
2019-2123
FIVE-YEAR FINANCIAL PLAN
WATER FUND
DESCRIPTION:
The water utility is one of two large enterprises operated by the Village. It serves approximately 5,200 customers, nearly 2,000 of which are located
outside the corporate limits of Oak Brook. The Water Fund supports both operations and capital improvements to the water system. The Water Fund
is considered an enterprise fund and is operated on a self-supporting basis.
OVERVIEW:
Revenue:
Revenue from the sale of water is based on an average of 886 million gallons billed per year and usage is projected to remain flat in order to mitigate
fluctuations due to weather. In late 2018, the Village worked with a consultant to update its 2015 a water rate study. The results of the study
recommend rate increases over the next five years to continue its capital improvement plan on schedule. The 2019 budget was prepared using a 5%
increase for 2019. The 2019-2023 Five Year Plan reflects rate increases of 5% annually in order to fund expected long-term capital outlays due to the
aging of the system and an estimated 2.5% rate increase from the City of Chicago to the DuPage Water Commission.
Operations:
The cost to DuPage Water Commission is reflective in the 2019 budget at $5.2 million and 2.5% increase in years 2020 — 2023.
Capital Improvements:
The capital improvement program reflects a focus on water main replacement for the next twenty years.
40
Village of Oak Brook
2019-2023 Five -Year Financial Plan
WATER FUND
Summary
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
Unrestricted Cash Available, January 1, 2018 $5,682,739
Estimated Income
$9,937,425
$10,192,620
$10,715,835
$10,989,750
$11,443,750
$11,973,000
$12,528,500
Less Estimated Operating Expenses
Operating Budget
1,510,090
1,482,795
1,496,810
1,507,521
1,549,209
1,591,959
1,635,792
Exceptional Charges
6,494,445
5,539,720
5,782,225
5,939,090
6,090,917
6,245,193
6,404,895
Estimated Net Operating Income
1,932,890
3,170,105
3,436,800
3,543,139
3,803,624
4,135,848
4,487,813
Add Beginning of Year Cash Balance
5,682,739
5,682,739
6,450,844
3,643,569
3,599,368
3,917,992
5,178,415
Estimated Available Funds
7,615,629
8,852,844
9,887,644
7,186,708
7,402,992
8,053,840
9,666,228
Less Capital Improvement Program
2,785,220
2,402,000
6,244,075
3,587,340
3,485,000
2,875,425
3,020,000
Estimated Unrestricted Cash Balance at Year -End
$4,830,409
$6,450,844
$3,643,569
$3,599,368
$3,917,992
$5,178,415
$6,646,228
41
Water Sales
Unmetered Sales
Connection Fees
Meter Fees
Special Services
Fire Service Charge
Plan Review Fees
Inspection Fees
Interest
Transfer From Equipment Replacement Fund
Miscellaneous
Total Revenue
42
Village of Oak Brook
2019-2023 Five -Year Financial Plan
WATER FUND
Revenue Projections
2018
2018
2019
2020
2021
2022
2023
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
$9,730,425
$9,836,120
$10,223,250
$10,703,250
$11,207,250
$11,736,500
$12,292,000
30,000
33,000
30,000
30,000
30,000
30,000
30,000
50,000
120,000
50,000
100,000
50,000
50,000
50,000
25,000
15,000
20,000
20,000
20,000
20,000
20,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
5,000
5,000
5,000
5,000
5,000
5,000
5,000
2,000
1,500
1,500
1,500
1,500
1,500
1,500
5,000
7,000
5,000
5,000
5,000
5,000
5,000
10,000
75,000
55,000
45,000
45,000
45,000
45,000
0
0
221,085
0
0
0
0
50,000
70,000
75,000
50,000
50,000
50,000
50,000
$9,937,425
$10,192,620
$10,715,835
$10,989,750
$11,443,750
$11,973,000
$12,528,500
42
Personnel
Materials and Supplies
Operations and Contractual
Total Operating Budget
Adjustment for Budget Goal Attainment
Exceptional Charges
DWC Fixed and 0 & M Charges
Reimbursement To General Corporate Fund
Vehicle Replacement Charges
Total Exceptional Charges
Capital Improvement Program
(See Schedule)
Total Budget
Village of Oak Brook
2019-2023 Five -Year Financial Plan
WATER FUND
Long -Range Operating Budget
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
$817,490 $788,470 $828,710 $866,002 $904,972 $945,696 $988,252
76,860 77,610 76,210 78,496 80,851 83,277 85,775
615,740 616,715 591,890 609,647 627,936 646,774 666,177
$1,510,090 $1,482,795 $1,496,810 $1,554,145 $1,613,759 $1,675,747 $1,740,205
$1,496,810 $1,507,521 $1,549,209 $1,591,959 $1,635,792
$6,060,225 $5,105,500 $5,192,805 $5,322,625 $5,455,691 $5,592,083 $5,731,885
405,170 405,170 551,830 568,385 585,436 603,000 621,090
29,050 29,050 37,590 48,080 49,790 50,110 51,920
$6,494,445 $5,539,720 $5,782,225 $5,939,090 $6,090,917 $6,245,193 $6,404,895
$2,785,220 $2,402,000 $6,244,075 $3,587,340 $3,485,000 $2,875,425 $3,020,000
$10,789,755 $9,424,515 $13,523,110 $11,033,951 $11,125,126 $10,712,577 $11,060,687
43
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
Water Fund
2018 2018 2019 2020 2021 2022 2023 Total
Project Name Budget Projected Budget Projection Projection Projection Projection 2019-2023
Distribution Improvements:
Water System Controls Radio Upgrade
Replacement Water Meters
Total Program 351
New Water Meters and Radio Collectors
SCADA Controls
Water Storage Mixer
Master Meter Design
Install Master Meters
Water Tower Painting
Luthin Road Engineering and Construction
Control Valve Reservoir A
Generator Reservoir B
Harger Road Bridge to Yorkshire Design
Harger Road Bridge to Yorkshire Construction
Harger Road Steeplechase to Yorkshire
Enterprise to Clearwater Watermain
Concord/Ivy/Devonshire Watermain
Charleton/Kimberly, Pembroke/Shelburne WM
Hamilton, Victoria, Briarwood
Mockingbird, Lambeth, Heather, Camelot WM
Meyers Road Commercial Corridor
Total Program 451
Total Water Fund
$ 100,000 $ 100,000 $ - $ - $ - $ - $ - $ -
20,000 20,000 20,000 20,000 20,000 20,000 20,000 100,000
$ 120,000 $ 120,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 100,000
$ 2,000,000 $ 2,195,000 $ - $ - $ - $ - $ - $ -
- - 500,000 - - - - 500,000
- - 100,000 - - - - 100,000
25,000 37,000 25,000 25,000 25,000 25,000 - 100,000
350,220 - 610,825 185,000 190,000 195,000 - 1,180,825
- - 650,000 - 700,000 - - 1,350,000
25,000 25,000 408,250 - - - - 408,250
155,000 - - 155,000 - - - 155,000
85,000 - - 85,000 - - - 85,000
25,000 25,000 - - - - - -
- - 365,000 - - - - 365,000
- 404,820 - - - 404,820
- - 632,500 - - - - 632,500
2,932,500 - - - - 2,932,500
- - - 2,712,520 - - - 2,712,520
- - 2,550,000 - - 2,550,000
- - - - 2,635,425 - 2,635,425
- - - - - - 3,000,000 3,000,000
$ 2,665,220 $ 2,282,000 $ 6,224,075 $ 3,567,340 $ 3,465,000 $ 2,855,425 $ 3,000,000 $19,111,840
$ 2,785,220 $ 2,402,000 $ 6,244,075 $ 3,587,340 $ 3,485,000 $ 2,875,425 $ 3,020,000 $19,211,840
44
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
SPORTS CORE FUND
DESCRIPTION:
The Oak Brook Sports Core is the other large enterprise operated by the Village. The Sports Core Fund supports the entire operation including uses of
the Sports Core's fields and forest areas, the Oak Brook Golf Club, the Oak Brook Bath and Tennis Club (all available for use by the general public) and
food and beverage services at the various Sports Core venues. It is considered an enterprise fund since the majority of its revenues are derived from
user fees.
In order to make clear the specific designation of certain resources, the Sports Core Fund is broken down into three segments: Sports Core Operations,
the Golf Surcharge Account and the Capital Improvement Account. The Sports Core Fund - Consolidated presentation brings all of the parts together.
OVERVIEW:
For many years it has been the goal of the Village to operate the Sports Core on a self-sufficient basis; that is, it should be 100% supported by user fees.
Based on projections contained in this document, revenues are expected to cover operating expenses. However, scheduled capital expenditures will
vary depending on the amount of resources available each year. For 2019, a transfer from the General Fund totaling $816,725 is needed to fund
current capital expenditures. Delays in capital items are expected to occur in the future as funds are available.
Revenue:
The total number of Golf Club members is projected at 150 throughout the planning period. For years 2020 - 2023, memberships are to remain flat and
membership fees are increased 3% per year. Daily greens fees increase $.50 to $1.00 per round per year. Other revenues are adjusted consistent with
market factors.
Membership revenue for the Bath & Tennis Club is budgeted to increase $15,440, or 7.5%, over the 2018 budgeted amounts. In 2020 and thereafter, a
3% increase in the number of members is included as well as a $25 annual increase in rates for all membership categories.
Food and Beverage rental revenue is budgeted to increase by $47,500, or 25.3%, in 2019 compared to the 2018 budget due to the increase in future
events booked. In 2019 and thereafter, rental income revenue is projected to increase 2.5%.
Operations:
The Bath and Tennis Clubhouse will continue to market the preferred caterer (partner) concept to our wedding and special event clients.
45
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
Capital Improvements:
The capital improvement program in the Sports Core Fund Operations presentation reflects an ongoing program of maintaining existing equipment and
facilities. The 2019 budget includes $1,255,900 in capital improvements and equipment replacements.
FUTURE CONSIDERATIONS:
Although the future projections are encouraging, favorable operating results of the Sports Core Fund are largely dependent on favorable weather,
annual increases in user fee revenue, and improved financial results of the Food and Beverage operations. Capital improvements completed over the
past several years were planned with a view toward making more favorable operating results possible on an annual basis.
Cash Available, January 1, 2018
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated Cash Balance at Year -End
$474,973
Village of Oak Brook
2019-2023 Five -Year Financial Plan
SPORTS CORE FUND
Summary
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
$3,410,725 $3,638,385 $4,842,290 $4,171,205 $3,693,347 $3,667,295 $3,743,103
2,896,445
3,107,375
3,186,390
3,299,087
3,416,017
3,537,349
3,663,261
133,875
49,575
0
0
0
0
0
380,405
481,435
1,655,900
872,118
277,330
129,946
79,842
474,973
474,973
233,983
233,983
(497,174)
(2,637,364)
(3,815,113)
855,378
956,408
1,889,883
1,106,101
(219,844)
(2,507,418)
(3,735,271)
365,660
722,425
1,655,900
1,603,275
2,417,520
1,307,695
148,000
$489,718
$233,983
$233,983
($497,174)
($2,637,364)
($3,815,113)
($3,883,271)
47
Bath & Tennis Club:
General Administration
Miscellaneous
G ra nts
Transfer From General Fund
Reimbursement From Infrastructure Fund
Reimbursement From Water Fund
Swimming
Miscellaneous
Memberships
Swim Fees
Transfer From General Fund
Tennis
Memberships
Tennis Lessons and Programs
Beverage & Pro Shop Revenue
Miscellaneous
Open Fields
Field Rental
Sponsorships, Memberships, & Admissions
Total Bath & Tennis Club
Food & Beverage:
Clubhouse Food & Beverage
Rental Income
Miscellaneous
Transfer From General Fund
Poolside Grill
Food Sales
Beverage/Liquor Sales
Golf Club Lounge
Food Sales
Beverage/Liquor Sales
48
Village of Oak Brook
2019-2023 Five -Year Financial
Plan
SPORTS CORE FUND
Revenue Projections
2018
2018
2019
2020
2021
2022
2023
Budget
Estimate Budget
Projection
Projection
Projection
Projection
$0
($875)
($250)
$0
$0
$0
$0
0
0
0
300,000
100,000
0
0
0
0
95,000
0
0
0
0
24,000
24,000
24,000
24,000
24,000
24,000
24,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
207,175
212,810
222,615
233,746
245,433
257,705
270,590
89,200
19,355
20,200
20,806
21,430
22,073
22,735
0
0
870,500
0
0
0
0
16,200
21,275
22,200
22,866
23,552
24,259
24,986
11,500
33,250
33,250
34,248
35,275
36,333
37,423
0
330
0
0
0
0
0
0
500
500
500
500
500
500
200,000
200,000
200,000
206,000
212,180
218,545
225,102
185,000
185,920
185,000
188,700
192,474
196,323
200,250
$744,075
$707,565 $1,684,015
$1,041,865
$865,844
$790,738
$816,586
187,500
225,000
235,000
239,700
244,494
249,384
254,372
0
80
0
0
0
0
0
0
0
251,225
0
0
0
0
6,000
34,695
36,000
36,720
37,454
38,203
38,968
3,000
18,470
19,500
19,890
20,288
20,694
21,107
125,000
114,000
125,000
127,500
130,050
132,651
135,304
233,000
227,000
233,000
237,660
242,413
247,261
252,207
48
Village of Oak Brook
2019-2023 Five -Year Financial Plan
SPORTS CORE FUND
Revenue Projections
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
Candy/Cigarette Sales 14,500 14,500 14,500 14,790 15,086 15,388 15,695
Total Food & Beverage $569,000 $633,745 $914,225 $676,260 $689,785 $703,581 $717,653
Golf Club:
Memberships
$191,500
$204,050
$209,000
$213,180
$217,444
$221,792
$226,228
Golf Fees
975,000
920,000
930,000
948,600
967,572
986,923
1,006,662
Merchandise Sales
200,000
200,000
200,000
204,000
208,080
212,242
216,486
Driving Range Fees
310,000
305,000
310,000
313,100
316,231
319,393
322,587
Golf Lessons
40,000
33,000
40,000
40,400
40,804
41,212
41,624
Cart Rental Fees
371,000
340,000
371,000
374,710
378,457
382,242
386,064
Equipment Rental Fees
5,000
4,000
4,000
4,040
4,080
4,121
4,162
Miscellaneous
5,150
5,525
5,050
5,050
5,050
5,050
5,050
Transfer from Golf Surcharge
0
285,500
175,000
350,000
0
0
0
Total Golf Club
$2,097,650
$2,297,075
$2,244,050
$2,453,080
$2,137,718
$2,172,976
$2,208,865
Total Sports Core Operations
$3,410,725
$3,638,385
$4,842,290
$4,171,205
$3,693,347
$3,667,295
$3,743,103
►e
Village of Oak Brook
2019-2023 Five -Year Financial Plan
SPORTS CORE FUND OPERATIONS
Long -Range Operating Budget
50
2018
2018
2019
2020
2021
2022
2023
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Personnel
$1,497,200
$1,565,710
$1,572,920
$1,643,701
$1,717,668
$1,794,963
$1,875,736
Materials and Supplies
615,885
604,385
580,645
595,161
610,040
625,291
640,923
Operations and Contractual
961,510
1,115,430
1,115,975
1,143,374
1,171,459
1,200,245
1,229,751
Other
(178,150)
(178,150)
(83,150)
(83,150)
(83,150)
(83,150)
(83,150)
Total
$2,896,445
$3,107,375
$3,186,390
$3,299,087
$3,416,017
$3,537,349
$3,663,261
Exceptional Charges
Golf Cart Lease
$49,575
$49,575
$0
$0
$0
$0
$0
Reimbursement to General Fund
84,300
0
0
0
0
0
0
Total
$133,875
$49,575
$0
$0
$0
$0
$0
Capital Improvement Program
(See Schedule)
$365,660
$722,425
$1,655,900
$1,603,275
$2,417,520
$1,307,695
$148,000
Total Budget
$3,395,980
$3,879,375
$4,842,290
$4,902,362
$5,833,537
$4,845,044
$3,811,261
50
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
Sports Core Fund
2018 2018 2019 2020 2021 2022 2023 Total
Project Name Budget Projected Budget Projection Projection Projection Projection 2019-2023
Bath & Tennis General Operations:
New Sign on 31st Street
New Parking Lot Signs
HVAC Replacement
Replace Domestic Plumbing in Basement
B&T Hot Water Heater
B&T Clubhouse Roof Scuppers
Pond Bank Stabilization
Wedding Venue
Picnic Pavilion Area
Picnic Area Pathway
Jogging Track
Entryway Beautification
Parking Lot Expansion and Reconstruct
Total Program 811
Swimming Operations:
Wading Pool Improvements
Pool Lounge Chairs
Diving Boards
Repair/Replace Stairs
Refinish Pools
Replace Pool Gutter System
Slide
Pool Backwash Discharge to Sanitary
Sanitary Sewer Repairs B&T to Dover
Diving Well Padding
$ 15,000 $ 38,845 $ - $ - $ - $-
- - 5,000 5,000 5,000 - - 15,000
- 50,000 - - - 50,000
90,000 - - - - 90,000
- 15,000 - - - 15,000
- - - 20,000 - - - 20,000
- - 108,215 - - - 108,215
- - 261,095 - - - 261,095
- - 208,635 - - - 208,635
- - - 155,180 - - 155,180
- - - 91,830 - - - 91,830
- 367,310 - - 367,310
- - - - - 1,059,695 - 1,059,695
$ 15,000 $ 38,845 $ 95,000 $ 759,775 $ 527,490 $ 1,059,695 $ - $ 2,441,960
$ 25,000 $ - $ - $ - $ - $ - $ - $ -
19,750 2,150 8,000 - - - - 8,000
17,000 - 15,000 - - - - 15,000
6,000 - 10,000 - - - - 10,000
- - 350,000 - - - - 350,000
- - 400,000 - - - - 400,000
27,000 - - - - - - -
30,000 30,000 - - - - - -
20,000 20,005 - - - - - -
5,000 - - - - - - -
51
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
Sports Core Fund
Project Name
2018 2018 2019
Budget Projected Budget
2020
Projection
2021 2022
Projection Projection
2023
Projection
Total
2019-2023
Pool Awning Replacement/Guard Station
- - 20,000
-
- -
-
20,000
Pool Check -In Station
- - 5,000
-
15,000 -
-
20,000
Pool Painting
- - 45,000
-
- -
-
45,000
New Flow Meters/Gauges
- - 5,000
-
- -
-
5,000
Foundation Leak in Basement
- - 10,000
-
- -
-
10,000
Light Poles Around Pool (6)
- - -
-
35,000 -
-
35,000
Swim Team Storage Shed, Flaggs
- - 2,500
-
- -
-
2,500
Total Program 812
$ 149,750 $ 52,155 $ 870,500
$ -
$ 50,000 $ -
$ -
$ 920,500
Tennis Operations:
Tennis Court Nets and Posts
$ - $ - $ -
$ 6,500
$ - $ -
$ -
$ 6,500
Fencing for Courts
- - -
-
30,000 -
20,000
50,000
Tennis Shelter Paddle Tennis Courts
- - -
-
1,534,980 -
-
1,534,980
Total Program 813
$ - $ - $ -
$ 6,500
$ 1,564,980 $ -
$ 20,000
$ 1,591,480
Open Fields:
Soccer Building Siding $ 15,000 $ 15,000 $ - $ - $ - $ - $ - $ -
Soccer Building Foundation - - 20,000 - - - - 20,000
Field Improvements - - 15,000 - - - - 15,000
New Soccer Fields - - - - 153,050 - - 153,050
Total Program 816 $ 15,000 $ 15,000 $ 35,000 $ - $ 153,050 $ - $ - $ 188,050
B&T Clubhouse:
New Carpeting and Dance Floor - Oak Brook Roo $ - $ 10,000 $ - $ - $ - $ - $ - $ -
Electrical Service Upgrade and Generator - 175,000 200,000 - - - - 200,000
B&T Clubhouse Exterior Painting - - - 30,000 - - - 30,000
B&T Clubhouse Interior Painting - - 10,000 5,000 5,000 5,000 5,000 30,000
52
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
Sports Core Fund
2018 2018 2019 2020 2021 2022 2023 Total
Project Name Budget Projected Budget Projection Projection Projection Projection 2019-2023
B&T Clubhouse Faux Stone/Brick
Restain Window Trim and Interior Wood
Lighting Exterior Fixtures Around Clubhouse
Dishwasher Replacement
B&T Clubhouse Bar Update
B&T Clubhouse Front Entrace Facia
B&T Clubhouse Front Entrace Bird Netting
Kitchen Equipment Replacement
Designer Fee
B&T Clubhouse Bathrooms
Ceiling Repair over Bar
Remove Beadboard, Drywall and Paint
New Banquet Chairs 200
New Banquet Tables
Kitchen Floor Tile
Kitchen Ceiling Tile
Total Program 821
Golf Club:
New Sign on York Road
Patio Improvements
Golf Club Lounge Design Fees
Golf Club Lounge Improvements
Exterior Staining
Pro Shop Upgrades
Interior Flooring
Parking Lot Seal Coating/Striping
- - 30,000
-
- - - 30,000
- - 15,000
-
- - - 15,000
- - 36,400
-
- - - 36,400
- - -
25,000
- - - 25,000
- - 50,000
-
- - - 50,000
- - 10,000
-
- - - 10,000
- - 15,000
-
- - - 15,000
- - -
20,000
- - - 20,000
- - -
-
- 5,000 - 5,000
- - -
-
- 100,000 - 100,000
- - 5,000
-
- - - 5,000
- - 10,000
-
- - - 10,000
- - 7,000
-
- - - 7,000
- - 2,000
2,000
2,000 - - 6,000
- - -
20,500
- - - 20,500
- - -
5,000
- - - 5,000
$ - $ 185,000 $ 390,400 $
107,500 $
7,000 $ 110,000 $ 5,000 $ 619,900
$ 15,000 $ 4,400 $ - $ - $-
- 288,665 - - - - - -
- 20,000 - - - - 20,000
- - - 350,000 - - - 350,000
- - - 20,000 - - - 20,000
- - 100,000 - - - - 100,000
10,000 - - - - - - -
- - 10,000 - - 10,000 - 20,000
53
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
Sports Core Fund
2018 2018 2019 2020 2021 2022 2023 Total
Project Name Budget Projected Budget Projection Projection Projection Projection 2019-2023
Parking Lot Replacement
-
115,500
- -
- 115,500
Parking Lot Drainage
15,000 - -
-
- -
- -
Cart Path Replacement
25,000 17,435 25,000
25,000
25,000 25,000
25,000 125,000
Tee Signs
- - 15,000
-
- -
- 15,000
Exhaust Fans (2)
-
20,000
- -
- 20,000
HVAC Replacement
- - -
50,000
- -
- 50,000
Total Program 831
$ 65,000 $ 310,500 $ 170,000 $
580,500 $
25,000 $ 35,000 $
25,000 $ 835,500
Ball Dispenser Replacement
$ - $ - $ - $
9,000 $
- $ - $
- $ 9,000
Picker Cart Replacement
- - -
-
- 10,000
- 10,000
Turf Range Hitting Stations
- - -
50,000
- -
- 50,000
Housing Structure Ball Machine Area
- - 5,000
-
- -
- 5,000
Total Program 832
$ - $ - $ 5,000 $
59,000 $
- $ 10,000 $
- $ 74,000
Utility Cart Fleet - 6 Carts Total $ 40,910 $ 40,925 $ - $ - $ - $ - $ - $ -
Total Program 833 $ 40,910 $ 40,925 $ - $ - $ - $ - $ - $ -
Tractors/Mowers
$ 35,000 $
35,000
$ -
$ 50,000
$ 50,000
$ 53,000 $
50,000
$ 203,000
Dump Truck
45,000
45,000
-
-
-
-
-
-
Utility Vehicle
-
-
-
28,000
28,000
28,000
28,000
112,000
Sprayers
-
-
40,000
-
-
-
-
40,000
Skid Steer
-
-
50,000
-
-
-
-
50,000
Trim Mowers
-
-
-
12,000
12,000
12,000
-
36,000
Golf Maintenance Parking Lot Replacement
-
-
-
-
-
-
20,000
20,000
Total Program 834
$ 80,000 $
80,000
$ 90,000
$ 90,000
$ 90,000
$ 93,000 $
98,000
$ 461,000
Total Sports Core Operations
$ 365,660 $
722,425
$ 1,655,900
$ 1,603,275
$ 2,417,520
$ 1,307,695 $
148,000
$ 7,132,390
54
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
GOLF SURCHARGE FUND
DESCRIPTION:
The Golf Surcharge Fund is the repository for revenues received from the $3.00 per round surcharge levied on every round of golf played at the Oak
Brook Golf Club. Surcharge revenues are reserved for golf course improvements and for restoration of flood damage to the course, should it be
necessary in the future.
OVERVIEW:
Revenue:
Revenue is projected based on the $3.00 surcharge applied to 40,000 rounds played.
Exceptional Charges:
Transfers of $175,000 in 2019 and $350,000 in 2020 are planned to help fund golf clubhouse improvements.
55
Unrestricted Cash Available, January 1, 2018
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated restricted Cash Balance at Year -End
$552,499
Village of Oak Brook
2019-2023 Five -Year Financial Plan
GOLF SURCHARGE FUND
Summary
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
$123,500 $124,000 $125,000 $124,105 $125,424 $128,548 $131,737
0
0
0
0
0
0
0
0
285,500
175,000
350,000
0
0
0
123,500
(161,500)
(50,000)
(225,895)
125,424
128,548
131,737
552,499
552,499
390,999
340,999
i 115,104
240,528
369,076
675,999
390,999
340,999
115,104
240,528
369,076
500,813
0
_ 0
0
0
0
0
0
$675,999
$390,999
$340,999
$115,104
$240,528
$369,076
$500,813
Q:
Village of Oak Brook
2019-2023 Five -Year Financial Plan
GOLF SURCHARGE FUND
Revenue Projections
57
2018
2018
2019
2020
2021
2022
2023
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Golf Surcharge
$120,000
$115,000
$120,000
$122,400
$124,848
$127,345
$129,892
Interest
3,500
8,500
5,000
1,705
576
1,203
1,845
Miscellaneous
0
500
0
0
0
0
0
Total Revenue
$123,500
$124,000
$125,000
$124,105
$125,424
$128,548
$131,737
57
Village of Oak Brook
2019-2023 Five -Year Financial Plan
GOLF SURCHARGE FUND
Long -Range Operating Budget
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
Exceptional Charges
Transfer to Sports Core Fund $0 $285,500 $175,000 $350,000 $0 $0 $0
Total Exceptional Charges $0 $285,500 $175,000 $350,000 $0 $0 $0
58
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
SELF-INSURANCE FUND
DESCRIPTION:
The Self -Insurance Fund is an internal service fund used for funding the Village's employee welfare benefit programs, including the self-insured medical
and dental plans and group life and accidental death insurance coverage. These programs also are made available to employees of the Oak Brook Park
District, retired Village employees and separated employees and their dependents pursuant to COBRA regulations.
OVERVIEW:
Revenue:
Revenue comes principally from charges to other funds, through the budgets of departments where plan participants are employed, charges to the Oak
Brook Park District, charges to retirees, and charges to COBRA participants. The Plan also reflects increased participant contribution to the cost of
health and dental insurance for all covered Village employees. Revenue from equivalent premiums is projected to increase at a rate sufficient to fund
projected expenses.
Operations:
Since 2012, the amount expended for health insurance claims has moderated due primarily to a change in the third party administrator to Blue
Cross/Blue Shield and alternative plan offerings. The Village offers a PPO, HMO alternative and High Deductible plans to all employees. For 2019,
claims are projected based on various rates used to set equivalent premiums. For 2020 and beyond, a claims inflation factor of 5% per year has been
used. Other expenses, including reinsurance costs, are also projected to increase 3% to 5% annually, beginning in July 2019.
FUTURE CONSIDERATIONS:
The future of health insurance is changing and the Affordable Care Act (ACA) presents the Village a number of challenges in forecasting and budgeting
for federally mandated increases in benefits and taxes. We will continue to conservatively budget in order to prepare for unforeseen circumstances
related to the on-going implementation of the ACA.
F1']
Unrestricted Cash Available, January 1, 2018
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated Unrestricted Cash Balance at Year -End
$45,042
Village of Oak Brook
2019-2023 Five -Year Financial Plan
SELF-INSURANCE FUND
Summary
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
$3,259,330 $3,214,155 $3,414,750 $3,583,278 $3,762,506 $3,950,742 $4,148,439
3,317,920
3,134,810
3,400,500
3,555,245
3,717,249
3,886,858
4,064,439
(58,590)
79,345
14,250
28,033
45,257
63,884
84,000
45,042
45,042
124,387
138,637
166,670
211,927
275,811
(13,548)
124,387
138,637
166,670
211,927
275,811
359,811
0
0
0
0
0
0
0
($13,548)
$124,387
$138,637
$166,670
$211,927
$275,811
$359,811
Village of Oak Brook
2019-2023 Five -Year Financial Plan
SELF-INSURANCE FUND
Revenue Projections
61
2018
2018
2019
2020
2021
2022
2023
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Village Contributions
$1,692,705
$1,673,300
$1,814,250
$1,904,963
$2,000,211
$2,100,221
$2,205,232
Participant Contributions
427,000
448,140
482,000
506,100
531,405
557,975
585,874
Park District Contributions
635,000
680,300
717,000
752,850
790,493
830,017
871,518
Retiree Contributions
497,125
402,825
399,000
418,950
439,898
461,892
484,987
Cobra Contributions
5,000
5,495
0
0
0
0
0
Interest
2,500
4,095
2,500
416
500
636
827
Total Revenue
$3,259,330
$3,214,155
$3,414,750
$3,583,278
$3,762,506
$3,950,742
$4,148,439
61
Village of Oak Brook
2019-2023 Five -Year Financial Plan
SELF-INSURANCE FUND
Long -Range Operating Budget
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
Exceptional Charges
Stop -Loss Premiums
$285,000
$271,205
$289,000
$297,670
$306,600
$315,798
$325,272
PPO Health Claims
2,225,000
1,959,310
2,153,000
2,260,650
2,373,683
2,492,367
2,616,985
HMO Health Premiums
380,000
367,920
382,000
401,100
421,155
442,213
464,323
Retiree Supplemental Premiums
0
128,545
138,000
142,140
146,404
150,796
155,320
Dental Premiums
174,000
189,775
203,000
211,120
219,565
228,347
237,481
Vision Insurance Premiums
8,400
8,130
8,300
8,549
8,805
9,070
9,342
Life Insurance Premiums
22,000
22,000
22,200
22,866
23,552
24,259
24,986
Plan Administration Fees
170,520
129,250
145,000
149,350
153,831
158,445
163,199
Miscellaneous
53,000
58,675
60,000
61,800
63,654
65,564
67,531
Total Exceptional Charges
$3,317,920
$3,134,810
$3,400,500
$3,555,245
$3,717,249
$3,886,858
$4,064,439
A,
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
GARAGEFUND
DESCRIPTION:
This fund is an internal service fund financed by charges to Village departments for maintenance of vehicle fleet equipment. Expenditures support the
operation and maintenance of cars, trucks, most fire equipment, public works construction equipment and related items.
OVERVIEW:
Revenue:
Revenues are calculated as charge -backs to various operating budget programs based on historical fuel and maintenance cost information.
Operations:
All costs associated with operation and maintenance of the Village's vehicle and equipment fleet are charged to this fund. Annual transfers to the
General Corporate Fund for administrative services are also included. The projections include increases in the cost of fuel due to elevated oil prices as
well as increases in the cost of repairs.
Capital Expenditures:
No capital expenditures are planned for 2019. A floor lift for $20,000 is planned for 2020.
63
Village of Oak Brook
2019-2023 Five -Year Financial Plan
GARAGEFUND
Summary
64
2018
2018
2019
2020
2021
2022
2023
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Unrestricted Cash Available, January 1, 2018 $427,409
Estimated Income
$612,730
$616,000
$664,615
$779,315
$802,687
$826,820
$851,673
Less Estimated Operating Expenses
Operating Budget
751,560
710,310
709,410
701,024
723,387
746,527
770,472
Exceptional Charges
45,620
45,620
46,150
49,595
50,896
52,240
54,547
Estimated Net Operating Income
(184,450)
(139,930)
(90,945)
28,696
28,404
28,053
26,654
Add Beginning of Year Cash Balance
427,409
427,409
287,479
196,534
205,230
233,634
261,687
Estimated Available Funds
242,959
287,479
196,534
225,230
233,634
261,687
288,341
Less Capital Improvement Program
0
0
0
20,000
0
0
0
Estimated Unrestricted Cash Balance at Year -End
$242,959
$287,479
$196,534
$205,230
$233,634
$261,687
$288,341
64
Village of Oak Brook
2019-2023 Five -Year Financial Plan
GARAGEFUND
Revenue Projections
65
2018
2018
2019
2020
2021
2022
2023
Budget
Estimate
Budget
Projection
Projection
Projection
Projection
Vehicle 0 & M Charges
$611,230
$611,230
$605,560
$778,225
$801,572
$825,619
$850,387
Interest
1,000
4,200
4,000
590
616
701
785
Transfer From Equipment Replacement Fund
0
0
54,555
0
0
0
0
Miscellaneous
500
570
500
500
500
500
500
Total Revenue
$612,730
$616,000
$664,615
$779,315
$802,687
$826,820
$851,673
65
Exceptional Charges
Reimbursement to Infrastructure Fund
Village of Oak Brook
$41,290
$40,490
$41,705
$42,956
$44,245
2019-2023 Five -Year Financial Plan
Vehicle Replacement Charge
4,330
4,330
5,660
7,890
GARAGEFUND
7,995
8,975
Total Exceptional Charges
$45,620
$45,620
Long -Range Operating Budget
$49,595
$50,896
$52,240
$54,547
2018 2018 2019
2020
2021
2022
2023
Budget Estimate Budget
Projection
Projection
Projection
Projection
Personnel
$229,010 $205,770 $231,450
$241,865
$252,749
$264,123
$276,008
Materials and Supplies
224,040 203,030 170,790
175,060
179,436
183,922
188,520
Operations and Contractual
298,510 301,510 307,170
284,099
291,202
298,482
305,944
Total Operating Budget
$751,560 $710,310 $709,410
$701,024
6 $723,387
$746,527
$770,472
Exceptional Charges
Reimbursement to Infrastructure Fund
$41,290
$41,290
$40,490
$41,705
$42,956
$44,245
$45,572
Vehicle Replacement Charge
4,330
4,330
5,660
7,890
7,940
7,995
8,975
Total Exceptional Charges
$45,620
$45,620
$46,150
$49,595
$50,896
$52,240
$54,547
Capital Improvement Program
Floor Lift
0
0
0
20,000
0
0
0
Total Capital Improvement Program
$0
$0
$0
$20,000
$0
$0
$0
Total Budget
$797,180
$755,930
$755,560
$770,619
$774,283
$798,766
$825,019
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
Garage Fund
2018 2018 2019 2020 2021 2022 2023 Total
Project Name Budget Projected Budget Projection Projection Projection Projection 2019-2023
Floor Lift $ - $ - $ - $ 20,000 $ - $ - $ - $ 20,000
Total Program 341 $ - $ - $ - $ 20,000 $ - $ - $ - $ 20,000
Total Garage Fund $ - $ - $ - $ 20,000 $ - $ - $ - $ 20,000
67
VILLAGE OF OAK BROOK
2019-2023
FIVE-YEAR FINANCIAL PLAN
EQUIPMENT REPLACEMENT FUND
DESCRIPTION:
This fund was created as a means of pre -funding replacement of major capital equipment, primarily vehicles. It has been supported by other funds,
principally the General Corporate, Infrastructure, and Water Funds, through vehicle user charges. This fund is utilized solely for replacement of fleet
equipment. Acquisition of new equipment (i.e., not as replacements) is reflected in the fund where the using department or division resides.
OVERVIEW:
Revenue:
Prior to 2002, revenues were calculated as charge -backs to various operating budget programs based on future replacement cost and funded over the
remaining life of existing vehicles and equipment. In 2002, the charge -back attributable to the General Corporate Fund was eliminated and replaced
with 20% of utility tax collections (i.e. 1% of the total 5% rate). For 2003 and 2004, the Equipment Replacement Fund's share of utility tax collections
was redirected to the General Corporate Fund in order to fund operating needs (the General Corporate Fund share was not funded). For 2005 and
thereafter there is a return to the 2002 practice whereby operating budget programs are assessed a charge -back based on future replacement cost.
Operations:
A new vehicle -leasing program will begin in 2019. Annual lease fees of $115,440 are budgeted for 2019 and increase each year as more vehicles are
added to the leased fleet. The entire small vehicle fleet is scheduled to be under lease within five years.
Exceptional Charges:
Reimbursements to the Infrastructure Fund are budgeted for administration services for the Public Works Director and Public Works Superintendent.
Capital Expenditures:
The capital program reflects normal scheduled replacements of existing fleet vehicles. The actual timing of the replacement will be based on mileage,
condition, and maintenance history of the vehicle at that time. The deferral of the replacement of some vehicles from the schedule contained here is
likely to occur.
.:
Unrestricted Cash Available, January 1, 2018 $1,794,180
Estimated Income
Less Estimated Operating Expenses
Operating Budget
Exceptional Charges
Estimated Net Operating Income
Add Beginning of Year Cash Balance
Estimated Available Funds
Less Capital Improvement Program
Estimated Unrestricted Cash Balance at Year -End
Village of Oak Brook
2019-2023 Five -Year Financial Plan
EQUIPMENT REPLACEMENT FUND
Summary
2018 2018 2019 2020 2021 2022 2023
Budget Estimate Budget Projection Projection Projection Projection
$402,940 $435,940 $233,970 $635,706 $701,901 $781,122 $809,050
0
0
115,440
176,316
234,372
303,432
321,624
0
0
1,009,585
9,873
10,169
10,474
10,788
402,940
435,940
(891,055)
449,517
457,360
467,216
476,638
1,794,180
1,794,180
1,641,185
620,820
1,015,662
1,184,022
1,344,783
2,197,120
2,230,120
750,130
1,070,337
1,473,022
1,651,238
1,821,421
614,205
588,935
129,310
54,675
289,000
306,455
244,675
$1,582,915
$1,641,185
$620,820
$1,015,662
$1,184,022
$1,344,783
$1,576,746
R
70
Village of Oak Brook
2019-2023 Five -Year Financial Plan
EQUIPMENT REPLACEMENT FUND
Revenue Projections
2018 2018 2019
2020
2021
2022
2023
Budget Estimate Budget
Projection
Projection
Projection
Projection
Vehicle Replacement Charges
340,940 340,940 216,470
625,206
684,401
763,622
791,550
Interest
12,000 30,000 7,500
7,500
7,500
7,500
7,500
Sales/Insurance Proceeds
50,000 65,000 10,000
3,000
10,000
10,000
10,000
Total Revenue
$402,940 $435,940 $233,970
$635,706
$701,901
$781,122
$809,050
70
Village of Oak Brook
$0
$0
$1,000,000
$0
2019-2023 Five -Year Financial Plan
$0
$0
Reimbursement to Infrastructure Fund
0
EQUIPMENT REPLACEMENT FUND
9,585
9,873
10,169
10,474
Long -Range Operating Budget
Total Exceptional Charges
$0
$0
$1,009,585
2018 2018 2019
2020
2021
2022
2023
Budget Estimate Budget
Projection
Projection
Projection
Projection
Operations and Contractual $0 $0 $115,440
$176,316
$234,372
$303,432
$321,624
Total Operating Budget $0 $0 $115,440
$176,316
$234,372
$303,432
$321,624
Exceptional Charges
Transfer to Other Funds
$0
$0
$1,000,000
$0
$0
$0
$0
Reimbursement to Infrastructure Fund
0
0
9,585
9,873
10,169
10,474
10,788
Total Exceptional Charges
$0
$0
$1,009,585
$9,873
$10,169
$10,474
$10,788
Capital Improvement Program
(See Schedule)
$614,205
$588,935
$129,310
$54,675
$289,000
$306,455
$244,675
Total Budget
$614,205
$588,935
$1,254,335
$240,864
$533,541
$620,361
$577,087
71
VILLAGE OF OAK BROOK, ILLINOIS
Budget Summaries
Budgeted Capital Requests
Fiscal Year 2019
Equipment Replacement Fund
Project Name
2018
Budget
2018
Projected
2019
Budget
2020
Projection
2021
Projection
2022
Projection
2023
Projection
Total
2019-2023
Engineering Vehicles
$ 27,000
$ -
$ -
$ -
$ -
$ -
$ -
$ -
Police Vehicles
68,000
77,000
-
-
-
-
-
-
Fire and EMS Vehicles
317,000
342,000
-
-
289,000
-
-
289,000
Public Works Vehicles
122,415
83,100
129,310
54,675
-
264,930
244,765
693,680
Water Vehicles
79,790
86,835
-
-
-
41,525
-
41,525
Total Program 342
$ 614,205
$ 588,935
$ 129,310
$ 54,675
$ 289,000
$ 306,455
$ 244,765
$ 1,024,205
Total Equipment Replacement Fund
$ 614,205
$ 588,935
$ 129,310
$ 54,675
$ 289,000
$ 306,455
$ 244,765
$ 1,024,205
72