HomeMy WebLinkAboutCOW Agenda Packet (Special Meeting) 04/26/2016JOINT FINANCIAL PLANNING WORKSHOP
Meeting Location:
Village Board Room -50 S. Emerson
Mount Prospect, I L 60056
I. CALL TO ORDER
II. ROLL CALL
Meeting Date and Time:
Tuesday, April 26, 2016
6:30 PM
Village Board of Trustees
MayorArlene A. Juracek
Trustee Paul Hoefert Trustee Richard Rogers
Trustee John Matuszak Trustee Colleen Saccotelli
Trustee Steven Polit Trustee Michael Zadel
Finance Commission
Chair Vince Grochocinski
Commissioner Pam Bazan Commissioner Don Ocwieja
Commissioner Trisha Chokshi Commissioner Thomas Pekras
Commissioner John Kellerhals Commissioner Mary Rath
III. CITIZENS TO BE HEARD
IV. FINANCIAL PLANNING WORKSHOP
1. 2015 Year -End Results
2. 2016 First Quarter Review
3. 2016 Preliminary Property Tax Levy
4. 2017 Revised Forecast Budget
5. Preliminary Community Investment Program (2017-2021)
V. ANY OTHER BUSINESS
VI. ADJOURNMENT
NOTE. ANY INDIVIDUAL WHO WORD LIKE TO ATTEND THIS MEETING BUT BECAUSE OFA DISABILITY NEEDS SOME
ACCOMMODATION TO PARTICIPATE, SHOULD CONTACT THE VILLAGE MANAGERS OFFICEAT 50 SOUTH EMERSON,
MOUNT PROSPECT, ILLINOIS 60056, 847/392-6000, EXTENSION 5327
Workshop -April 26, 2016 Pagel of 53
Item IV.: FINANCIAL PLANNING WORKSHOP
Department: Finance
Information:
A first-quarter financial planning workshop is part of the overall budget process for
the village. At this joint workshop, staff present to members of the Village Board and
Finance Commission results of operations for the prior year along with updates on
the current year's budget and budget forecast. Also discussed is a preliminary look
at the upcoming property tax levy and five-year Community Investment Program.
Other items are added to the workshop agenda as deemed timely and or necessary.
For this year's workshop a formal presentation has been prepared to guide the
Village Board and Finance Commission through the following items:
1. 2015 Year -End Results
2. 2016 First Quarter Review
3. 2016 Preliminary Property Tax Levy
4. 2017 Revised Forecast Budget
5. Preliminary Community Investment Program (2017-2021)
Staff will be on hand to answer questions and facilitate discussion.
Budget Impact:
Various financial planning workshop items will be discussed.
Recommendation:
Information only.
SUPPORTS THE FOLLOWING STRATEGIC PLAN GOALS:
GOVERNANCE: Financial sound, providing exceptional service
ATTACHMENTS:
Workshop -April 26, 2016 Page 2 of 53
Description
Type
Upload Date
File Name
D 2015 Year -End
Cover Memo
4/22/2016
2015_Year-End Results --
Results
_Consolidated.pdf
° 2016 First
Cover Memo
4/22/2016
2016 First Quarter_ Review_-
Quarter Review
_Consolidated.pdf
2016 Preliminary
a Property Tax
Cover Memo
4/22/2016
2016 Preliminary_Property_Tax_Levy_-
_Consolidated.pdf
2017 Revised
Cover Memo
4/21 /2016
2017 Revised Forecast—Budget—
Forecast Budget
_Consolidated.pdf
Preliminary
Community
2017-
a Investement
Cover Memo
4/21/2016
2021 Community_lnvestment_Program_-
Program - 2017-
_Consolidated.pdf
2021
Workshop -April 26, 2016 Page 3 of 53
VILLAGE OF MOUNT PROSPECT
TOTAL VILLAGE BUDGET - REVENUES AND EXPENDITURES
2015 YEAR-END RESULTS
EXCESS OF REVENUES
OVER 1w 'P1wNl:hlll'1"1w RES
9,196,096 (19,785,514) (8,178,060)
Workshop -April 26, 2016 Page 4 of 53
Actual
Budget
Actual
Change from
2014
2015
2015
Prior Year
REVENUES
Property Taxes
21,264,473
21,920,500
21,769,995
505,522
Other Taxes
13,987,321
14,463,205
14,308,587
321,266
Licenses, Permits, and Fees
2,675,472
3,028,000
3,067,903
392,431
Intergovernmental Revenue
23,601,028
24,310,024
25,870,931
2,269,904
Charges for Services
26,689,705
28,536,345
27,983,964
1,294,259
Fines and Forfeits
862,467
664,250
725,066
(137,401)
Investment Income
7,963,880
4,117,118
2,603,794
(5,360,086)
Reimbursements
829,861
222,500
251,145
(578,715)
Other Revenue
9,357,114
9,231,500
9,225,178
(131,936)
Other Financing Sources
6,667,729
101,599
311,171
(6,356,558)
otalll Revenues
113,899,049
106,595,041-
106,117,733
(7,781,315)
EXPENDII1"LiRES
Personal Services
41,799,680
42,086,679
41,556,987
(242,693)
Pension Benefits
8,322,408
9,210,580
9,171,293
848,885
Contractual Services
20,684,134
22,416,454
21,056,891
372,757
Insurance
7,871,963
8,472,828
7,650,114
(221,849)
Commodities and Supplies
1,863,439
2,190,043
1,627,460
(235,979)
Other Expenditures
3,050,399
4,286,796
3,409,686
359,286
Bond Principal and Interest
5,916,741
6,126,007
6,125,731
208,990
Capital
15,194,188
31,509,569
23,416,033
8,221,845
Interfund Transfers
-
81,599
281,599
281,599
-9,592,841
1"otaI Expeindftuires
104,702,953
126,380,555-
114,295,794-
EXCESS OF REVENUES
OVER 1w 'P1wNl:hlll'1"1w RES
9,196,096 (19,785,514) (8,178,060)
Workshop -April 26, 2016 Page 4 of 53
2015 Year -End Results
Total Village Budget - Results for the 2015 budget were positive on the whole due to solid growth in a
number of revenue categories and prudent budget management by the Departments. In the instances
where a significant decrease in revenue occurred, the impact was due to the absence of a debt issuance
in relation to the prior year or lower than expected interest earnings caused by an unstable financial
market.
Unlike the past several years 2015 saw no significant weather events that impacted Village
expenditures. However, 2015 did see a significant event with the replacement of the Village Manager
who had served the Village for over 28 years including 23 as Village Manager. The uncertainty of the
state impact upon the Village continues to hover over many pending decisions and there is a need to
just move forward to address the needs of our citizenry. To address the uncertainty at the State level,
the village has laid out a multi -step contingency plan in the event of significant revenue loss.
The most significant challenge for 2015 was the determination of how to address the future funding for
the 6 firefighters once the SAFER grant funding expires in 2018. Staff spent substantial time in exploring
different scenarios and ultimately recommending a dedicated portion of the future property tax levy be
used for this funding. The timing on this option is especially critical since there continues to be ongoing
discussion at the state level regarding a property tax freeze for a two year period likely starting in 2017.
While such a freeze would offer no assistance to the state regarding their fiscal issues, it is a political
decision with full impact at the local level. The Village will be able to manage the property tax levy
impact if the freeze does occur based on the advanced notice and practice of projecting future levy
increases to account for the freeze.
The economic recovery continues, albeit at a more deliberate pace. The growth in revenue that has
occurred is not expected to fund the natural growth of expenditures long-term. The growth in personnel
costs continue to be the primarily factor in expenditure growth. The last of the labor contracts that were
completed in 2012 and 2013 and have provided a measure of personnel expenditure predictability
expire in 2016. Work on similar long-term agreements currently taking place hope to provide this same
level of predictability.
Year-end results from the 2015 Budget show total revenues of $106,117,733. This represents a
decrease of $7.8 million, or 6.8% from the prior year. Decreases in the revenue categories of investment
income and other financing sources (in the form of bond proceeds) attributed significantly to the overall
drop in revenue. Investment income related to public safety pensions decreased by $5.4 million and
other financing sources, consisting of general obligation bonds, decreased by $6.4 million. Revenue
growth over the prior year was seen in the property tax, license, permits and fees, intergovernmental
revenue, charges for service and other tax categories. Intergovernmental revenue grew by $2.3 million
primarily as a result of higher than expected sales and income taxes. Sales taxes in the General Fund
grew $1.7 million from the prior year while the income tax grew $577,000. The charges for service
category increased $1.3 million from the prior year due to increases implemented for water service
($564,000) and refuse collection ($617,000). A number of other revenue sources contributed to the
increases experienced in the remaining revenue categories. Included below is a pie chart illustrating
contributions to total village revenues by major revenue category.
Workshop -April 26, 2016 Page 5 of 53
2015 Year -End Results
2015 Total Budget - Revenue
Total expenditures for the 2015 budget were $114,295,794, an increase of $9.6 million from the prior
year. The increase is primarily due to flood control projects completed during the year. Funds to
support the additional spending were on hand and derived primarily from bond proceeds. The total
spending on capital during the year was $23.4 million versus the $15.2 million spent the year earlier. The
increase in pension benefits are related to increases to the public safety (police and fire) pension benefit
payments. Excluding the increases seen in the pension and capital expense accounts, total expenditures
for the year increased by just $522,111 or 0.5%. Included below is a pie chart illustrating total village
expenditures by major category.
$2
$6
2015 Total Budget - Expenditures
$7,650,114 $21,056,891
987
IIIIIIIIII Personal Services
I Pension Benefits
1111111 Contractual Services
IIIII1Insurance
111111111 Commodities and Supplies
Iluu Other Expenditures
III Bond Principal and Interest
1111111 Capital
;9,171,293 Interfund Transfers
Workshop -April 26, 2016 Page 6 of 53
2015 Year -End Results
While events impacting the Village both externally (fiscal uncertainty down in Springfield) and internally
(transition to a new Village Manager) did add to the complexity of operations, 2015 was an active year
for programming and projects throughout the organization. Below is a partial listing of activities by
Department during the past year.
Community Development:
The Village continues to see significant activity in economic development throughout the community.
The Community Development Department actively marketed properties within the downtown district
and permits have been issued for three new restaurants. Trezeros Kitchen and Tap will be occupying
the former Jake's Pizza location (302 W. Northwest Highway). In addition, Tokens and Tankards (18 E.
Busse) and Bar 145 (34 S. Main) will be locating in the small triangle district on Busse Avenue.
The Department reviewed and recommended approval of a townhome planned unit development on
the vacant site located on Elmhurst Avenue adjacent to the Post Office. Staff obtained a demolition
order to address a long-standing vacant Central Plaza shopping center located at the northwest corner
of Central Road and Main Street. Contracts were awarded for the demolition and environmental clean-
up of the property. The Village will ultimately pursue foreclosure proceedings on the property once a
full No Further Remediation Letter is obtained from the Illinois Environmental Protection Agency. Once
completed, the property will be available for redevelopment on this highly visible corner in the
downtown district.
The Department also worked with property owners and brokers to occupy vacant spaces/buildings
located in the Kensington Business Center (KBC). In 2015, the vacancy rate in KBC dropped to 14%, the
lowest rate in over a decade. The Village supported two applications for Class 6B property classifications
to encourage the occupancy of the KBC during 2015. The Village welcomed Novomatic, Atlas Material
Testing, Netrix and GoGo as new tenants in the KBC and assisted CVS/Caremark, R & B Foods and
NeuroRestorative on expansions of their facilities.
Randhurst Village welcomed several new restaurant tenants during the year, reducing the center's
vacancy rate to three percent (3%). New tenants included Smokey Bones, Truco Tacqueria and Outback
Steakhouse. Menards completed their garden center addition expansion and will soon be undertaking a
warehouse addition that is expected to be completed in 2016.
The Department also issued permits to construct a McDonald's restaurant on the old Baker's Square
property (100 W. Rand) and for two new mattress firms (1020 E. Central and 2 E. Rand).
Finance:
Throughout 2015, the Department spent significant time in developing a departmental strategic plan
that aligns with the organization -wide Strategic Plan for 2020. Included in this effort was the creation
and development of the Finance Department Strategic work plan for 2015. The management team
conducted weekly planning meetings, developed nine primary Finance Department goals and
established strategies and timelines to meet objectives.
Improvements were made to the Customer Service Division floor plan. The space was remodeled to
provide efficient and improved customer service at the front counter. This also provides for effective
use of customer service staff time throughout the work day. Decentralization of incoming calls was
implemented for the Village main telephone number which reduces caller wait time.
Workshop -April 26, 2016 Page 7 of 53
2015 Year -End Results
A Finance Department Customer Service Survey was conducted to establish a benchmark for
opportunities for improvement. A six (6) questions survey was distributed during the months of April
and May 2015. Areas surveyed included the customer wait time, facility appearance, customer
representative's knowledge and manner. The weighted average of the responses ranged from 4.71 to
4.91 out of 5.
Efforts to reduce paper and improve document retrieval were achieved with the establishment of
electronic files for workers compensation and the implementation of Laserfiche for Food and Beverage
tax, Licensing, Easy Park Pass, and miscellaneous receipts.
A significant amount of time was dedicated to the preparation of the 2016 Annual Budget and the 2016-
2020 Capital Improvement Plan and five year financial forecast. These documents were redesigned for a
new and improved look. The Department also successfully completed the annual audit and preparation
of the 2014 Comprehensive Annual Financial Report. The Village received word that we were awarded
the GFOA Certificate of Achievement for Excellence in Financial Reports for 2014 Comprehensive Annual
Financial Report and the GFOA Distinguished Budget Award for the 2015 Budget.
Fire:
The Department was awarded a SAFER (Staffing for Adequate Fire and Emergency Response) Grant from
the Federal Emergency Management Agency (FEMA). The grant funds allowed the Village to hire 6
additional firefighters to restore staffing back up to pre -2011 levels. After being out of service since
2011, Engine 13 has been placed back in full service for 2016. The EMS Coordinator was able to get 25
paramedics re -licensed in 2015. In addition, the Department began developing an Active Shooter
Protocol in conjunction with the Police Department. This will prepare paramedics for entering and
treating patients in the 'warm zone'. Helmets and ballistic vests will be utilized for safety, and the
paramedics will be escorted by armed police officers.
The Department's EMS Coordinator also assisted in the development of an infection control plan for the
Police Department. In addition, Tdap vaccinations for the Fire Department and Police Department were
administered in response to the pertussis outbreaks. A plan is now in place for large scale vaccinations
should there be another experience relating to an exposure risk.
In May, over 2000 Mount Prospect children attended our 35th annual Children's Fire and Safety Festival.
The Fire Prevention Bureau also developed and distributed fire safety pamphlets to all apartment
complexes.
Human Services:
The Department continued meeting its mission of improving the health and well-being of the residents
and community it serves through the provision of nursing and social services in 2015. A diabetes support
group, offered in both English and Spanish, was started in 2015 by the Village nurse.
The Community Connections Center Coordinator and the Mount Prospect Public Library collaborated on
a new program which is offered to preschool age children on a weekly basis. Social Service staff
members continue to provide crisis intervention services and responded to multiple fires to assist
displaced residents.
Workshop -April 26, 2016 Page 8 of 53
2015 Year -End Results
The Police Counselor was active in court throughout the year providing court advocacy services to
domestic violence victims. Administrative support staff re -organized the department network drive,
updated the Human Services Department website page and updated the Department service brochure.
The Department participated in various community events throughout the year including National Night
Out, Jewel Community Days, Hersey High School Community Resource fair, Harper Resource Fair and
Senior Celebration. The Department continues to place an emphasis on training, and various staff
members received training in Elder Law, Medicare, Leadership, Accessing Medical Benefits, Disability
Benefits, Ethics and the Law and training through the National Alliance for the Mentally III.
Police:
The Department continued meeting its mission of providing quality law enforcement services to our
citizens with pride, integrity, and professionalism. Through intensified enforcement efforts, public
education, and comprehensive investigative techniques, the Department continued to reduce the
number of Part I and Part II crimes committed in the Village.
The Crime Prevention Unit expanded the Department's presence on social media, actively disseminating
Department information on Facebook, Twitter, and YouTube through a series of podcast messages. The
Department continued to engage the community with its Citizen's Police Academy, "Kickin' it with the
Cops," and National Night Out events. The Police Department also continued its community outreach
initiatives through its participation in the Special Olympics annual "Cop on Top" and Torch Run events.
The Department continued to focus on the career development of its personnel, providing core law
enforcement training to line officers, cutting-edge training in specialized areas such as crisis intervention
training (CIT), and advanced management training for the Department's leadership team.
As part of the Department's Community Investment Program, the Department installed a new state-of-
the-art target carrier system in the Department's Pistol Range that is used extensively for weapons and
tactics training for all sworn personnel. The Department also deployed a rigorous recruiting program to
showcase the career opportunities available to prospective police applicants and conducted a recruit
testing process.
Public Works:
The Village's Street Improvement Program completed the resurfacing of 6.8 miles of local streets during
2015. A streets funding plan approved in 2013 allows the Village to keep pace with the annual program.
All local streets within the village would be resurfaced over a 20 -year period under the current program
avoiding the need for the more costly full street reconstruction project.
The Village completed a significant portion of the Isabella Street sewer improvements in 2015 that
included the installation of large diameter relief sewer with the intended benefit of providing properties
protection up to a 25 year rain event level. These Flood Control improvements were funded through a
$10 million bond sale in 2013.
2015 saw significant activity of the Village's Urban Forest. The Department received Growth Award for
the 13th time. Staff completed scheduled tree trimming of approximately 4,600 trees maintaining the
Village's five (5) year tree trimming cycle. There were 950 unhealthy trees removed in a timely manner
avoiding costly private property damage from falling branches. The Department also planted 1,040 trees
Workshop -April 26, 2016 Page 9 of 53
2015 Year -End Results
of varying species to maintain a diversified urban forest and achieved the ratio of one tree planting for
every tree removal for this past year. It also planted approximately 9,900 flowers and continued ongoing
management of landscape maintenance and turf mowing contracts.
Work performed on the Village's Water and Sewer System included the installation of the new
Automated Meter Reading system by completing the conversion of all 11,000 Village water accounts.
The Department also completed the replacement of approximately 2,000 lineal feet of water main
during the year which included the upsizing of water main along Evergreen, east of the elevated tank,
and Maple Street between Evergreen and Busse Avenue. The Department also completed the
Combined Sewer System Evaluation study making a recommendation to the Village Board that included
an estimated $15 million in sewer improvements over the next 10 — 15 years. The Department also
successfully completed the installation of emergency standby power for Water Booster Station 11. Also
completed the first year Illinois Environmental Protection Agency testing for Unregulated Contaminant
Monitoring Rule (UCMR3).
All Departments have continued to perform extremely well and deliver high quality services during the
economic recovery period and reaching out to residents that need additional attention, such as seniors
and lower income residents. We also endeavor to keep the community informed through the continual
evolution of our cable television channels, web site, newsletter, numerous publications, local newspaper
press releases, and the use of social media venues. The Village's Annual Budget and Audit Documents
were again recognized for their clarity and usability and Mount Prospect was recognized as Tree City
U.S.A. for the 301h consecutive year.
Workshop -April 26, 2016 Page 10 of 53
VILLAGE OF MOUNT PROSPECT
GENERAL FUND - REVENUES AND EXPENDITURES
2015 YEAR-END RESULTS
EXPENDII1"LIRES
Public Representation
564,093
636,934
605,328
Budget to Actual
Village Manager's Office
2,777,002
3,410,428
3,131,264
Variance -
Television Services Division
Actual
Budget
Actual
Favorable
Village Clerk's Office
2014
2015
2015
(Unfavorable)
REVENUES
2,007,010
1,991,728
1,945,588
46,140
Property Taxes
14,602,584
15,427,500
15,416,879
(10,621)
Sales Taxes - ROT Portion
13,285,441
14,000,000
15,003,273
1,003,273
Sales Taxes - HMR Portion
1,355,373
1,346,000
1,367,462
21,462
Food and Beverage Tax
738,642
755,000
759,073
4,073
Real Estate Transfer Tax
954,644
1,350,000
1,371,699
21,699
Telecommunications Tax
2,208,291
2,150,000
2,133,343
(16,657)
Other Utility Taxes
1,885,305
1,790,000
1,641,385
(148,615)
Other Taxes
278,863
275,566
303,623
28,057
Vehicle Licenses
340,344
0
0
0
Other Licenses, Permits, Fees
2,027,125
2,241,000
2,341,269
100,269
State Income Tax
5,186,155
5,200,000
5,763,542
563,542
Other Intergovernmental
1,657,322
1,597,827
1,796,764
198,937
Charges for Services
1,630,607
1,699,000
1,392,109
(306,891)
Fines and Forfeits
479,647
489,000
519,966
30,966
Investment Income
(64,970)
5,918
8,612
2,694
Other Revenue
722,516
-47,287,887-
476,000
-48,802,811
551,070
75,070
-1,567,257
otalll Revenues
50,370,068
EXPENDII1"LIRES
Public Representation
564,093
636,934
605,328
31,606
Village Manager's Office
2,777,002
3,410,428
3,131,264
279,164
Television Services Division
177,750
187,337
188,108
(771)
Village Clerk's Office
211,394
218,547
209,690
8,857
Finance Department
2,007,010
1,991,728
1,945,588
46,140
Community Development Dept.
2,241,264
2,425,767
2,104,967
320,800
Human Services Dept.
1,049,674
1,067,027
1,048,463
18,564
Police Department
16,578,938
16,637,444
16,277,671
359,773
Fire Department
13,166,939
13,234,459
13,171,001
63,458
Public Works Department
7,358,200
7,784,256
6,934,034
850,222
Emergency Events
142,283
0
0
0
Miscellaneous
46,300
46,456
46,455
1
1"otaI Expeindftuires
-46,320,848
-47,640,383
-45,662,568
-1,977,815
EXCESS OF REVENUES OVER EXPEND.
967,040
1,162,428
4,707,500
13'"1"III- ER 1=IIINANO N SOURCES/USES
Transfers In
0
0
0
Transfers Out
(203,112)
0
(281,599)
Tota1 13tIheir F=l inainding Uses
(203,112)
o-
(281,599).
EXCESS OF REVENUES OVER EXPEND.
and OTHER 1=IIINANO N SOURCES/USES
763,928 1,162,428 4,425,901
Workshop -April 26, 2016 Page 11 of 53
2015 Year -End Results
General Fund — The 2015 General Fund Budget shows a surplus of $4.4 million on revenues of
$50,370,068 and expenses of $45,662,568. General Fund revenues came in $1,567,257 above the
amended budget while expenses came in $1,977,815, or 4.2% UNDER the amended budget. The Village
has typically come in one to two -percent under budget on an annual basis. This is due to Departments
not being compelled to spend their entire budget by year-end.
Year-end results from the 2015 Budget show total General Fund revenues of $50,370,068. This
represents an increase of $3.1 million, or 6.5% from the prior year. Revenue growth over the prior year
was seen in the property tax, intergovernmental, and other tax categories. The increase in property
taxes was the result of a reallocation of a portion of the levy for refuse collection (as part of the street
funding plan). The amount of this reallocation was $340,000. There is an equivalent reduction in the
license, permit and fee category as vehicle sticker monies previously placed in the General Fund were
redirected to the Street Construction Fund. Intergovernmental revenue grew by $2.4 million primarily as
a result of growth in sales and income taxes totaling $1.7 million and $577,000 respectively. Other taxes
saw an increase from the prior year as a result of higher than expected real estate activity positively
impacting the real estate transfer tax. The increase from the prior year in the real estate transfer tax was
$417,000. Modest changes, both up and down, were realized in the other General Fund revenue
categories. Included below is a pie chart illustrating contributions to General Fund revenues broken out
by major revenue category.
$315,75
2015 General Fund - Revenue
$1,458,8-c
>l,SbL,b38
IIIIIIIIIII Property Taxes
(IIIIIIII Other Taxes
IIIIIIII Licenses, Permits, & Fees
1111111 Intergovernmental
IIIIIIIIII Charges for Services
IIVUI Fines and Forfeits
111111 Investment Income
111111 Reimbursements
Other Revenue
IIIIIIII Other Financing Sources
You will notice a credit value for the amount of other financing sources. The credit reflects the
disposition of the property the village acquired at 1112 N. Elmhurst. The property was acquired by the
village as part of an agreement with the property owner for adjudication fines due the village. The
adjustment resulted from the ultimate sale of the property back to a developer.
Workshop -April 26, 2016 Page 12 of 53
2015 Year -End Results
Total expenditures for the 2015 General Fund budget were $45,662,568, a decrease of $658,280, or
1.4% from the prior year and $1,977,815 under the amended 2015 budget. Departments that saw
significant savings from budget for 2015 include Public Works, Police, Community Development and
Village Manager's Office. The following pie chart illustrates a breakdown of General Fund expenses.
$1,048,4
$2,104,c
$1,992,04-
$3,529,062
$605,328
2015 General Fund - Expenditures
IIIIIIIIII Public Representation
(IIIIIIII Village Manager's Office
IIIIIIII Finance Department
1111111 Community Development
11111111111 Human Services
Iluui Police Department
H Fire Department
111111 Public Works Department
All of the Departments were at or below the benchmark of 50% at mid -year and finished the year under
their amended budget. The following chart illustrates General Fund expenditures as a percentage of the
annual budget at December 31.
% of Budget Utilized
80.00% 85.00% 90.00% 95.00% 100.00%
Public Representation
Village Manager's Office
Finance Department
Community Development
Human Services
Police Department
Fire Department
Public Works Department
Amendments to the original 2015 budget, including carryover items from the 2014 budget, totaled
$821,976. Carry-over items totaled $37,816 while personnel related items (including overtime) totaled
$505,673, and professional and contractual service and other expenses totaling $278,487.
Workshop -April 26, 2016 Page 13 of 53
2015 Year -End Results
As was mentioned earlier, total General Fund expenditures have come in anywhere from one to two
percent under budget with few exceptions. The chart below shows budget to actual expenditures since
2011. Savings have been used to offset shortfalls in revenue, reduce or eliminate a programmed budget
deficit or cover unanticipated expenditures that may occur during the year. If neither of these
conditions exists, the savings go toward maintaining the General Fund fund balance. The savings to the
2015 General Fund budget was 4.15%.
Year
Amended Budget
Actual Expenditures
Variance
2011
$41,975,978
$40,786,106
(2.83%)
2012
$42,585,149
$41,858,267
(1.71%)
2013
$45,693,626
$44,713,148
(2.15%)
2014
$47,396,714
$46,320,040
(2.27%)
Including the projected surplus in the General Fund for 2015, reserves to begin 2016 are $16,934,358.
These reserves represent a fund balance level of 33.7%. The target benchmark for reserves in the
General Fund according to the Village fund balance policy is 20.0% to 30.0%.
Workshop -April 26, 2016 Page 14 of 53
VILLAGE OF MOUNT PROSPECT
TOTAL VILLAGE BUDGET - REVENUES AND EXPENDITURES
2016 QUARTERLY REVIEW - Q1
REVENUES
Property Taxes
Other Taxes
Licenses, Permits, and Fees
Intergovernmental Revenue
Charges for Services
Fines and Forfeits
Investment Income
Reimbursements
Other Revenue
Other Financing Sources
Total Revenues
DI XPENDI:hIII'1n"LDRES
Personal Services
Pension Benefits
Contractual Services
Insurance
Commodities and Supplies
Other Expenditures
Bond Principal and Interest
Capital
Interfund Transfers
Total Expeindtuires
EXCESS OF REVENUES
OVER DIw 'TDIwNOf:hlll'10"LDRES
Workshop -April 26, 2016 Page 15 of 53
Budget
YTD Actual
2016
Variance -
Actual
Budget
01/01/2016-
Current
Favorable
2015
2016
3/31/2016
Estimate
(Unfavorable)
21,769,995
22,784,200
10,476,149
22,784,200
0
14,308,587
14,198,368
847,885
14,240,368
42,000
3,067,903
2,944,000
1,119,179
3,044,000
100,000
25,870,931
25,413,467
1,128,499
26,903,467
1,490,000
27,983,964
30,766,533
6,967,203
30,866,533
100,000
725,066
656,100
143,789
711,100
55,000
2,603,794
8,485,500
534,358
8,541,500
56,000
251,145
194,500
50,389
194,500
0
9,225,178
9,609,840
3,677,201
9,669,840
60,000
311,171
0
33,535
40,000
40,000
106,117,733
-115,052,508
-24,978,187-
116,995,508
1,943,000
41,556,987
43,960,891
11,040,511
43,960,891
0
9,171,293
9,424,423
2,404,717
9,424,423
0
21,056,891
23,850,475
4,292,923
23,850,475
0
7,650,114
8,593,266
2,168,031
8,593,266
0
1,627,460
2,195,498
383,598
2,195,498
0
3,409,686
3,695,673
4,402
3,695,673
0
6,125,731
6,087,191
1,481
6,087,191
0
23,416,033
18,959,503
389,438
18,959,503
0
281,599
0
0
0
0
-114,295,794
-116,766,920
-20,685,100
116,766,920
U
(8,178,060)
(1,714,412)
4,293,087
228,588
1,943,000
Workshop -April 26, 2016 Page 15 of 53
2016 First Quarter Review
Total Village Budget — The total approved budget for 2016 was $112,542,802. This was a decrease of 10.95%
from the final 2014 amended budget. In April 2016, the first budget amendment for 2016 was approved by the
Village Board. The amendment consisted primarily of capital projects deferred from the prior year. The total
amount of the budget amendment was $4.2 million. The current 2016 budget of $116,766,920 now reflects a
decrease of 7.61% from the prior year.
2015
Final Amended Budget $126,380,555
2016 % Change
Original Budget $112,542,802 -10.95%
BudgetAmendment(s) 4,224,118
Amended Budget $116,766,920 -7.61%
Total revenues budgeted for 2016 are $115,052,508. This represents an increase of $8.9 million, or 8.4% from
the prior year. A return to a normal level of earnings in the category of investment income (for public safety
pensions) account for a significant portion of the increase over the prior year. The budget for 2016 also built in
increases to the water rates (5%) and refuse utility rates ($45 per household) accounting for the increase to
Charges for Service revenue category. Current projections anticipate an additional $1.9 million in revenue for
the year based on final results of the 2015 budget. Total revenue projected during 2016 is now $116,995,508. A
positive adjustment was made to the intergovernmental revenues revenue category totaling $1.5 million. The
state sales and income tax revenue accounts were adjusted based on how they finished 2015. Included below is
a pie chart illustrating the total village budget for revenue by major revenue category.
2016 Total Amended Budget - Revenue
Total expenditures budgeted for 2016 are $116,766,920, an increase of $2.5 million from the prior year.
Personal service costs in 2016 are estimated to be $43,960,891, an increase of 5.8% from 2015. A 2.0% wage
increase is included in the budget for all non-union employees and collectively bargained groups. The increase
from the prior year was also driven by the new staff added for public safety. Six (6) new firefighter/paramedics
and four (4) Community Service Officers (2 full-time and 2 part-time) were added for 2016. The Capital Budget
decreased $4.5 million or 19.2% from the prior year and totals $18,959,503. Ongoing projects such as street
improvement, flood control and water system improvements are included in this total. The decrease is due to
the anticipated completion of the Isabella flood control project. Included below is a pie chart illustrating total
village expenditures by major category.
Workshop -April 26, 2016 Page 16 of 53
$3,6(
$2,195;
$8,593,266
$23,850,4:
2016 First Quarter Review
2016 Total Amended Budget - Expenditures
$18,959,503
$9,424,423
IIIIIIIII Personal Services
1111111 Pension Benefits
111111 Contractual Services
111111 Insurance
1111111 Commodities and Supplies
11111i Other Expenditures
$43,960,891 11111 Bond Principal and Interest
11111 Capital
These figures presented here assume no reduction in revenue as a result of budget decisions, or non -decisions,
being made in Springfield. There is a continued fear that the state in its desire to rectify its own budget
conundrum may well reach down and reduce shared revenues like the income tax, use tax and motor fuel tax.
Also being considered by the state legislature is a two-year freeze to the property tax levy.
The village has developed a multi -step contingency plan that can be implemented if the Village were to
experience a decline in revenues resulting from action taken in Springfield. The multi -step plan provides for
increasing levels of response to loss of revenue depending upon the timing and severity of cuts imposed by the
State. A listing of the steps taken in response to revenue loss, in order of least to most significant, are:
1. Eliminate or defer capital projects/purchases.
2. Reduce funding (lease payments) of computer and vehicle replacement programs.
3. Institute a freeze or reduction in commodity, contractual service and supply accounts, where possible.
4. Review catalog of programs and services provided by the village.
5. Review of staffing levels.
The Finance Department will continue to review budgeted revenues monthly and report back to the Board if a
significant decline is realized.
Workshop -April 26, 2016 Page 17 of 53
VILLAGE OF MOUNT PROSPECT
GENERAL FUND - REVENUES AND EXPENDITURES
2016 QUARTERLY REVIEW - Q1
11XPEND111"U ES
Public Representation
605,328
699,374
118,058
699,374
Budget
Village Manager's Office
3,131,264
3,396,802
YTD Actual
2016
Variance -
Television Services Division
Actual
Budget
01/01/16-
Current
Favorable
Village Clerk's Office
2015
2016
3/31/2016
Estimate
(Unfavorable)
REVENUES
1,945,588
2,035,030
430,458
2,035,030
0
Property Taxes
15,416,879
15,984,200
8,096,236
15,984,200
0
Sales Taxes - ROT Portion
15,003,273
14,375,000
0
15,450,000
1,075,000
Sales Taxes - HMR Portion
1,367,462
1,405,000
0
1,405,000
0
Food and Beverage Tax
759,073
720,000
120,102
760,000
40,000
Real Estate Transfer Tax
1,371,699
925,000
169,426
925,000
0
Telecommunications Tax
2,133,343
2,200,000
0
2,150,000
(50,000)
Other Utility Taxes
1,641,385
1,782,000
335,074
1,782,000
0
Other Taxes
303,623
308,000
15,334
308,000
0
Other Licenses, Permits, Fees
2,341,269
2,057,000
408,650
2,157,000
100,000
State Income Tax
5,763,542
5,350,000
534,735
5,525,000
175,000
Other Intergovernmental
1,796,764
2,290,420
342,977
2,530,420
240,000
Charges for Services
1,392,109
1,317,000
164,311
1,417,000
100,000
Fines and Forfeits
519,966
451,000
109,202
511,000
60,000
Investment Income
8,612
4,100
7,712
28,100
24,000
Other Revenue
551,070
489,500
-49,658,220
143,618
519,500
30,000
otalll Revenues
50,370,068
10,447,378
51,452,220
1,794,000
11XPEND111"U ES
Public Representation
605,328
699,374
118,058
699,374
0
Village Manager's Office
3,131,264
3,396,802
806,192
3,396,802
0
Television Services Division
188,108
195,097
46,924
195,097
0
Village Clerk's Office
209,690
238,198
56,593
238,198
0
Finance Department
1,945,588
2,035,030
430,458
2,035,030
0
Community Development Dept.
2,104,967
2,424,754
432,329
2,424,754
0
Human Services Dept.
1,048,463
1,107,503
250,418
1,107,503
0
Police Department
16,277,671
17,540,844
4,648,420
17,540,844
0
Fire Department
13,171,001
14,373,987
3,791,044
14,373,987
0
Public Works Department
6,934,034
7,852,237
1,436,601
7,852,237
0
Miscellaneous
46,455
46,616
-49,910,442
11,654
46,616
0
1"otaI Expeindftuires
45,662,568
12,028,691
49,910,442
0
EXCESS OF REVENUES
OVER 11XP11NIY1"1 RES
4,707,500
(252,222)
(1,581,313)
1,541,778
1,794,000
13'"1"III- ER 1=111NANO N SOURCES/USES
Transfers In
0
0
0
0
0
Transfers Out
(281,599)
0
0
(300,000)
(300,000)
Tota1 13tIheir F=l inainding Uses
(281,599)
0
-0
(300,000)
-(300,000).
EXCESS OF REVENUES OVER
EXPEND1'"1"1 RES and 13'"1"III-WEE
1=11flANON SOURCES/USES
4,425,901
(252,222)
(1,581,313)
1,241,778
1,494,000
Workshop -April 26, 2016 Page 18 of 53
2016 First Quarter Review
General Fund — The 2016 General Fund amended budget is showing a deficit of $252,222 on revenues of
$49,658,220 and expenses of $49,910,442. As of March 31, the General Fund had recorded expenditures of
$12,028,691. This represents 24.1% of the budget and is in line with spending through a quarter year period. A
more recent estimate now projects a surplus of $1,241,778. In this early estimate, revenues for sales taxes are
projected to exceed budget by $1.1 million. Of this amount, it is estimated that $300,000 was generated by the
Randhurst development and will be transferred to the Business District Fund for distribution as part of the
redevelopment agreement. Smaller adjustments were made to other revenue categories. Revenues are now
projected to come in at $51,452,220. This is $1,794,000 above the amended budget. Included below is a pie
chart estimating General Fund revenues broken out by major revenue category.
2016 General Fund Amended Budget - Revenue
The amended 2016 General Fund budget for expenses is $49,910,442. Budget amendments in this fund totaling
$252,222 were approved by the Village Board in April. The amendments impacted various commodity,
contractual service and capital accounts. To be conservative, no changes were made to any expense category for
the 2016 General Fund budget. The following pie chart illustrates a breakdown of estimated General Fund
expenses broken out by department.
2016 General Fund Amended Budget - Expenditures
If the surplus estimated for 2016 in the General Fund is realized, the funds could be used for prefunding/funding
the SAFER grant hires or to make a capital transfer in support of some larger projects in need of completion.
Workshop - April 26, 2016 Page 19 of 53
IIIIIIIIII Public Representation
$1,107,503
111111111 Village Manager's Office
$2,424,754
111111 Finance Department
$2,081,646
1111111 Community Development
$3,830,097
IIIIIIIII Human Services Dept.
II Police Department
$699,374
/r
11111 Fire Department
1111111 Public Works Department
If the surplus estimated for 2016 in the General Fund is realized, the funds could be used for prefunding/funding
the SAFER grant hires or to make a capital transfer in support of some larger projects in need of completion.
Workshop - April 26, 2016 Page 19 of 53
Village of Mount Prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: MICHAEL J. CASSADY, VILLAGE MANAGER
FROM: FINANCE DIRECTOR
DATE: APRIL 22, 2016
SUBJECT: PROPOSED 2016 PROPERTY TAX LEVY
The Forecast Budget for 2017 included a projected amount for property taxes to be derived
from the 2016 property tax levy. Included with this memo for your review are the preliminary
2016 levy and additional levy scenarios. Also included for reference are the final 2015 levy and
a levy history for the period 2002 - 2015. Below are a few points on each of these items to help
facilitate discussion at the upcoming financial planning workshop. For discussion purposes, the
Corporate Levy is the tax levy that includes allocations for public safety, debt service and police
and fire pensions. Please note that while the preliminary levy was included as part of the 2017
Forecast Budget, it is by no means final. It is only presented as a stepping off point for budget
discussion purposes.
Final 2015 Levy (Exhibit 1)
Corporate Levy - The total extended levy for 2015 was $18,312,756. This represented an
increase of $581,835, or 3.28% from the prior year. The levy is set for the purpose of funding
public safety (police and fire protection), debt service, police and fire pensions. The public
safety portion of the levy increased by 1.7% and the debt service portion of the levy increased
$17,102 or 0.7%. Included in the public safety portion is a SAFER prefunding amount of
$177,480. The prefunding amount added 1.0% to the overall increase of the levy. Lastly, the
portion of the levy for police pension contribution increased 10.8% while the fire pension
contribution increased by 3.0%. Increases to the tax levies for 2011 through 2014 are shown
below.
2011
4.33
2012
3.95
2013
5.00%
2014
2.48
Special Service Area #5 Levy — The total extended levy for 2015 was $1,545,773. There was no
increase in the special service levy from the prior year. The final year of the SSA #5 levy is 2017.
Workshop -April 26, 2016 Page 20 of 53
Proposed 2016 Property Tax Levy
April 22, 2016
Page 2 of 3
Preliminary 2016 Levy (Exhibit II)
Corporate Levy - The preliminary levy for 2016 for receipt in 2017 totaled $18,911,581. This
represented an increase of $598,825, or 3.27% from the prior year. This is the levy as
presented in the forecast budget. The public safety portion of the levy increases by 1.8% and
the debt service portion of the levy increases $11,368 or 0.5%. Again, included in the public
safety portion is a SAFER prefunding amount of $184,008. The prefunding amount adds 1.0% to
the overall increase of the levy. Lastly, the portion of the levy for both the police and fire
pension contribution is assumed to increase 7.0%. Results from the actuarial valuation of the
public safety pensions show the increase to the annual required contribution to be significantly
higher. Impact to the 2016 levy based on these actuary results will be presented in the next
section.
Special Service Area #5 Levy — The total extended levy for 2016 is $1,545,773. There is no
increase in the special service levy from the prior year.
Adjusted 2016 Levy (Exhibit III)
Corporate Levy — Results from the actuary showed a significant increase in the annual pension
contribution for the village. As a result, the preliminary 2016 levy for pension were adjusted for
the upcoming year. The actuary calculated the contribution amount using the same
assumptions as in past valuations with the exception of the mortality schedule. Utilizing the
new mortality table resulted in significantly higher contributions than would otherwise been
calculated. The move to the new table was governed by the Society of Actuaries. Instead of the
programmed increase of 7.0% for police and fire pension contributions, the increase for this
year is 19.1% and 23.8% respectively. Absent the change in mortality table the increase to
contributions would have been 4.0% and 4.5%.
The adjusted 2016 levy now totals $19,768,733. This represents an increase of $1,455,977, or
7.95% from the prior year. The increase in the public safety portion of the levy remains at 1.8%
and the debt service increase is at 0.5%. Also, SAFER prefunding stays in place adding 1.0% to
the overall increase of the levy.
Pension Abated 2016 Levy (Exhibit IV)
Corporate Levy — In an effort to reduce the overall increase of the property tax levy to a
manageable level, abatements were applied to the adjusted 2016 levy for pension
contributions. In lieu of levying the full amount for the annual contribution in 2016, General
Fund reserves could be used over a 4 -year period to phase in the significantly large pension
increase. Adequate reserves are on hand to support this plan.
In order to return a levy increase of 3.27%, the initial abatement amount will need to be
$840,000. Subsequent abatements will be reduced annually by one-quarter of the initial
amount until the abatement is eliminated. Using this schedule, abatements will be $630,000 in
2017, $420,000 in 2018 and $210,000 in 2019.
H:WDMN\Administration\Property Taxes\2016 Levy\April 2016 Workshop - Preliminary 2016 Levy.docx
Workshop - April 26, 2016 Page 21 of 53
Proposed 2016 Property Tax Levy
April 22, 2016
Page 3 of 3
This is but one alternative to address the increase in the levy. Also considered was the
reduction of the levy allocated to police and fire protection in an effort to absorb the pension
increase. This alternative may not be prudent in light of the pending property tax freeze.
Public Safety Pension Levy History (Exhibit V)
A table covering calendar years 2002 - 2015 of the public safety contribution and funding levels
is included with this memo. The table includes the ARC (annual required contribution) for the
police and fire pensions, percent change from year-to-year and funding level. The five-year
increase (2010-2015) in required contributions for police and fire are 53.6% and 44.2%
respectively. The average annual increase over the same period is 10.7% for the police pension
and 8.8% for the fire pension.
In spite of the increasing level of contributions, the overall funding level of both the police and
fire pension funds has fallen from over 75% funded in 2002 to 58% or below for year -ending
2015. While funding the pensions at the ARC has placed stress on the annual property tax levy
and General Fund, the Village is committed to proper funding in the current period not pushing
the matter "down the road."
As mentioned at the start of this memo, this information should provide a good stepping -off
point for discussion at the financial planning workshop. A more detailed presentation on the
proposed property tax levy for 2016 will be made at that time. Let me know if you have any
questions.
David O. Erb
Finance Director
H:WDMN\Administration\Property Taxes\2016 Levy\April 2016 Workshop - Preliminary 2016 Levy.docx
Workshop - April 26, 2016 Page 22 of 53
Exhibit I
VILLAGE OF MOUNT PROSPECT AND THE
MOUNT PROSPECT PUBLIC LIBRARY
FINAL 2015 PROPERTY TAX LEVY
2%
Net Provision Total @98.5%
2015 2015 Loss and 2015 2016
Levy Abatement Levy Costs Extension Budget
VILLAGE OF MOUNT PROSPECT
Police Protection
4,933,773
0
4,933,773
98,675
5,032,448
Fire Protection
5,107,773
0
5,107,773
102,155
5,209,928
Police Pension Fund
3,204,363
72,500
3,131,863
62,637
3,194,500
Firefighters' Pension Fund
2,589,599
71,300
2,518,299
50,366
2,568,665
Debt Service Funds
Series 2009
417,262
0
417,262
8,345
425,607
Series 2009B
385,725
0
385,725
7,715
393,440
Series 2009C
187,933
41,200
146,733
2,935
149,668
Series 2011B
787,610
0
787,610
15,752
803,362
Series 2012
54,095
0
54,095
1,082
55,177
Series 2013
369,956
369,956
0
0
0
Series 2014
470,550
0
470,550
9,411
479,961
Total Village
18,508,639
554,956
17,953,683
359,073
18,312,756
MOUNT PROSPECT PUBLIC LIBRARY
Library Operations
8,965,374
0
8,965,374
179,307
9,144,681
Library Debt Service
1,672,543
0
1,672,543
33,451
1,705,994
Total Library
10,637,917
0
10,637,917
212,758
10,850,675
TOTAL - VILLAGE OF MOUNT PROSPECT
AND PUBLIC LIBRARY
29,146,556
554,956
28,591,600
571,831
29,163,431
SPECIAL SERVICE AREA NO. 5
1,515,464 0 1,515,464 30,309 1,545,773
2014 2015
Total Levy Amount 17,730,922 18,312,756
Increase Over Prior Year 581,834 3.28%
Workshop - April 26, 2016 Page 23 of 53
4,957,000
5,132, 000
3,147, 000
2,530,000
419,000
388,000
147,000
791,000
54,000
0
473,000
18, 038, 000
Exhibit II
VILLAGE OF MOUNT PROSPECT AND THE
MOUNT PROSPECT PUBLIC LIBRARY
PRELIMINARY 2016 PROPERTY TAX LEVY
SPECIAL SERVICE AREA NO. 5 1,515,464 0 1,515,464 30,309 1,545,773
2015 2016
Total Levy Amount 18,312,756 18,911,581
Increase Over Prior Year 598,825 3.27%
Workshop - April 26, 2016 Page 24 of 53
2%
Net
Provision
Total
@98.5%
2016
2016
Loss and
2016
2017
Levy
Abatement
Levy
Costs
Extension
Budget
VILLAGE OF MOUNT PROSPECT
Police Protection
4,933,773
0
4,933,773
98,675
5,032,448
4,957,000
Fire Protection
5,288,173
0
5,288,173
105,763
5,393,936
5,313,000
Police Pension Fund
3,351,100
0
3,351,100
67,022
3,418,122
3,367,000
Firefighters' Pension Fund
2,694,600
0
2,694,600
53,892
2,748,492
2,707,000
Debt Service Funds
Series 2009
417,262
0
417,262
8,345
425,607
419,000
Series 2009B
381,275
0
381,275
7,626
388,901
383,000
Series 2009C
205,842
42,000
163,842
3,277
167,119
165,000
Series 2011B
790,096
0
790,096
15,802
805,898
794,000
Series 2012
54,095
0
54,095
1,082
55,177
54,000
Series 2013
369,956
369,956
0
0
0
0
Series 2014
466,550
0
466,550
9,331
475,881
469,000
Total Village
18,952,722
411,956
18,540,766
370,815
18,911,581
18,628,000
MOUNT PROSPECT PUBLIC LIBRARY
Library Operations
0
0
0
0
0
Library Debt Service
0
0
0
0
0
Total Library
0
0
0
0
0
TOTAL - VILLAGE OF MOUNT PROSPECT
AND PUBLIC LIBRARY
18,952,722
411,956
18,540,766
370,815
18,911,581
SPECIAL SERVICE AREA NO. 5 1,515,464 0 1,515,464 30,309 1,545,773
2015 2016
Total Levy Amount 18,312,756 18,911,581
Increase Over Prior Year 598,825 3.27%
Workshop - April 26, 2016 Page 24 of 53
Exhibit III
VILLAGE OF MOUNT PROSPECT AND THE
MOUNT PROSPECT PUBLIC LIBRARY
ADJUSTED 2016 PROPERTY TAX LEVY
SPECIAL SERVICE AREA NO. 5 1,515,464 0 1,515,464 30,309 1,545,773
2015 2016
Total Levy Amount 18,312,756 19,768,732
Increase Over Prior Year 1,455,976 7.95%
Workshop - April 26, 2016 Page 25 of 53
2%
Net
Provision
Total
@98.5%
2016
2016
Loss and
2016
2017
Levy
Abatement
Levy
Costs
Extension
Budget
VILLAGE OF MOUNT PROSPECT
Police Protection
4,933,773
0
4,933,773
98,675
5,032,448
4,957,000
Fire Protection
5,288,173
0
5,288,173
105,763
5,393,936
5,313,000
Police Pension Fund
3,742,725
0
3,742,725
74,854
3,817,579
3,760,000
Firefighters' Pension Fund
3,143,320
0
3,143,320
62,866
3,206,186
3,158,000
Debt Service Funds
Series 2009
417,262
0
417,262
8,345
425,607
419,000
Series 2009B
381,275
0
381,275
7,626
388,901
383,000
Series 2009C
205,842
42,000
163,842
3,277
167,119
165,000
Series 2011B
790,096
0
790,096
15,802
805,898
794,000
Series 2012
54,095
0
54,095
1,082
55,177
54,000
Series 2013
369,956
369,956
0
0
0
0
Series 2014
466,550
0
466,550
9,331
475,881
469,000
Total Village
19,793,067
411,956
19,381,111
387,621
19,768,732
19,472,000
MOUNT PROSPECT PUBLIC LIBRARY
Library Operations
0
0
0
0
0
Library Debt Service
0
0
0
0
0
Total Library
0
0
0
0
0
TOTAL - VILLAGE OF MOUNT PROSPECT
AND PUBLIC LIBRARY
19,793,067
411,956
19,381,111
387,621
19,768,732
SPECIAL SERVICE AREA NO. 5 1,515,464 0 1,515,464 30,309 1,545,773
2015 2016
Total Levy Amount 18,312,756 19,768,732
Increase Over Prior Year 1,455,976 7.95%
Workshop - April 26, 2016 Page 25 of 53
Exhibit IV
VILLAGE OF MOUNT PROSPECT AND THE
MOUNT PROSPECT PUBLIC LIBRARY
PENSION ABATED 2016 PROPERTY TAX LEVY
SPECIAL SERVICE AREA NO. 5 1,515,464 0 1,515,464 30,309 1,545,773
2015 2016
Total Levy Amount 18,312,756 18,911,581
Increase Over Prior Year 598,825 3.27%
Workshop - April 26, 2016 Page 26 of 53
2%
Net
Provision
Total
@98.5%
2016
2016
Loss and
2016
2017
Levy
Abatement
Levy
Costs
Extension
Budget
VILLAGE OF MOUNT PROSPECT
Police Protection
4,933,773
0
4,933,773
98,675
5,032,448
4,957,000
Fire Protection
5,288,173
0
5,288,173
105,763
5,393,936
5,313,000
Police Pension Fund
3,742,725
391,625
3,351,100
67,022
3,418,122
3,367,000
Firefighters' Pension Fund
3,143,320
448,720
2,694,600
53,892
2,748,492
2,707,000
Debt Service Funds
Series 2009
417,262
0
417,262
8,345
425,607
419,000
Series 2009B
381,275
0
381,275
7,626
388,901
383,000
Series 2009C
205,842
42,000
163,842
3,277
167,119
165,000
Series 2011B
790,096
0
790,096
15,802
805,898
794,000
Series 2012
54,095
0
54,095
1,082
55,177
54,000
Series 2013
369,956
369,956
0
0
0
0
Series 2014
466,550
0
466,550
9,331
475,881
469,000
Total Village
19,793,067
1,252,301
18,540,766
370,815
18,911,581
18,628,000
MOUNT PROSPECT PUBLIC LIBRARY
Library Operations
0
0
0
0
0
Library Debt Service
0
0
0
0
0
Total Library
0
0
0
0
0
TOTAL - VILLAGE OF MOUNT PROSPECT
AND PUBLIC LIBRARY
19,793,067
1,252,301
18,540,766
370,815
18,911,581
SPECIAL SERVICE AREA NO. 5 1,515,464 0 1,515,464 30,309 1,545,773
2015 2016
Total Levy Amount 18,312,756 18,911,581
Increase Over Prior Year 598,825 3.27%
Workshop - April 26, 2016 Page 26 of 53
Exhibit V
VILLAGE OF MOUNT PROSPECT
ANNUAL CONTRIBUTION AND FUNDING LEVEL
2002-2015
ARC = Annual Required Contribution
Fire
Annual Contribution and Funding Level
ARC
Police
% Funded
1,059,381
ARC
% Change in ARC
% Funded
2002
1,062,739
1,159,480
75.30%
2003
1,077,645
1.40%
77.50%
2004
1,246,954
15.71%
74.50%
2005
1,333,283
6.92%
74.10%
2006
1,408,423
5.64%
75.40%
2007
1,515,672
7.61%
75.50%
2008
2,208,174
45.69%
58.90%
2009
2,467,527
11.75%
60.60%
2010
2,484,859
0.70%
59.30%
2011
2,631,811
5.91%
59.20%
2012
2,922,979
11.06%
58.10%
2013
2,909,868
-0.45%
59.90%
2014
3,204,363
10.12%
57.90%
2015
3,817,579
19.14%
54.60%
5 -Year Increase (2010-2015)
53.63%
$3.0
5 -Year Average Annual Increase
10.73%
44.16%
8.83%
Fire
Annual Contribution and Funding Level
ARC
% Change in ARC
% Funded
1,059,381
80.10%
1,175,135
10.93%
78.80%
1,159,480
-1.33%
78.80%
1,302,011
12.29%
76.40%
1,389,833
6.75%
76.70%
1,414,110
1.75%
78.20%
1,925,110
36.14%
63.90%
2,140,664
11.20%
65.00%
2,224,122
3.90%
63.40%
2,323,609
4.47%
63.30%
2,468,554
6.24%
63.20%
2,526,101
2.33%
64.20%
2,589,599
2.51%
63.00%
3,206,186
23.81%
58.00%
44.16%
8.83%
Workshop -April 26, 2016 Page 27 of 53
Annual Contribution and Funding Level
$7.0
90.0%
$6.0
mmm
80.0%
70.0%
$5.0
60.0%
$4.0
50.0%
o
c
$3.0
40.0%
v
c
30.0%
on
$2.0
20.0%
.5
Cr
$1.0
�.,
�
�
�.
�
�
�
�..
�
�
�
10.0%
c
$0.0
..,,
..
.,,,,
..
.,,,
..
0.0%
c
a
o5 0� o� ow o� do titi titi ti3 ti� tis
do do do do do do do ,yo do do do
IIIIIIIIIIIIIIIIII
Police Pension ARC IIIIIIIIIIIIIIIIIIIIIIII Fire Pension ARC Police % Funded
Fire % Funded
Workshop -April 26, 2016 Page 27 of 53
VILLAGE OF MOUNT PROSPECT
TOTAL VILLAGE BUDGET - REVENUES AND EXPENDITURES
2017 FORECAST BUDGET - Q1
EXPEND111"LIRES
Personal Services
Estimate
Forecast
$ Change
% Change
Pension Benefits
2016
2017
from PY
from PY
REVENUES
23,850,475
24,085,501
235,026
0.99%
Property Taxes
22,784,200
23,555,200
771,000
3.38%
Other Taxes
14,240,368
14,483,592
243,224
1.71%
Licenses, Permits, and Fees
3,044,000
3,049,000
5,000
0.16%
Intergovernmental Revenue
26,903,467
27,277,435
373,968
1.39%
Charges for Services
30,866,533
32,004,365
1,137,832
3.69%
Fines and Forfeits
711,100
721,100
10,000
1.41%
Investment Income
8,541,500
8,918,500
377,000
4.41%
Reimbursements
194,500
196,500
2,000
1.03%
Other Revenue
9,669,840
10,169,577
499,737
5.17%
Other Financing Sources
40,000
-116,995,508
0
-120,375,269
(40,000)
-3,379,761-
-100.00%
-2.89%
otalll Revenues
EXPEND111"LIRES
Personal Services
43,960,891
45,136,518
1,175,627
2.67%
Pension Benefits
9,424,423
9,671,616
247,193
2.62%
ContrEstimate Services
23,850,475
24,085,501
235,026
0.99%
Insurance
8,593,266
8,856,127
262,861
3.06%
Commodities and Supplies
2,195,498
2,212,952
17,454
0.79%
Other Expenditures
3,695,673
3,748,242
52,569
1.42%
Bond Principal and Interest
6,087,191
6,187,678
100,487
1.65%
Capital
18,959,503
12,937,699
(6,021,804)
-31.76%
Interfund Transfers
0
0
0
1"otaI Expeindftuires
-116,766,920
-112,836,333
(3,930,587)
-3.37%
EXCESS OF REVENUES
OVER 1w 'P1wNIY1'1"U RES
228,588
7,538,936
7,310,348
Workshop -April 26, 2016 Page 28 of 53
2017 Revised Forecast Budget
Total Village Budget — The 2017 Forecast Budget is currently showing total projected revenues of $120,375,269
and total projected expenditures of $112,836,333. The excess of revenues over expenditures is $7.3 million. Of
this amount, surplus earnings in the two public safety pension funds accounts for $6.7 million. These surplus
pension funds are set aside for payment of benefits when due and are not available for general village use.
Total revenues forecast for 2017 are $120,375,269. This represents an increase of $3.4 million, or 2.9% from the
prior year. Increases in the charges for service, property tax, and other revenue categories attributed to the
overall growth in revenue. The increase in charges for service is driven by the increases planned for refuse
collection and water service. The increase to the property tax reflects a 3.3% increase in the 2016 levy over 2015
and includes an allocation to support the 6 new hires connected with the SAFER firefighter staffing grant.
Increases in other revenues consist of public safety contributions in the form of property taxes. Included below
is a pie chart illustrating the 2017 forecast for total village revenues by major revenue category.
The increase in the property tax levy included in the 2017 Budget is 3.3% with the portion allocated for
operations increasing 1.8% while the portion for debt service on municipal debt increased $11,368 or 0.5%. The
projected increase to the portion of the levy allocated to public safety increased 7.0%. Please note that the tax
levy (2016) included in the 2017 forecast is only a placeholder and is intended as a stepping off point for
discussion. The decision on a final levy will not occur until after initial budget discussions are held. The levies will
likely change as a result of the preliminary actuarial valuation showing greater than 7.0% increases for both the
police and fire pension.
Again, the figures presented here assume no reduction in revenue as a result of budget decisions made in
Springfield. The spring legislative session is currently open. Governor Rauner and the legislature still haven't
passed a budget for fiscal year 2015/2016. Approval of the state's next fiscal year budget isn't expected until
after the November elections. Depending on the outcome of these deliberations, there could be a significant
loss in revenue to both the General Fund and the Motor Fuel Tax Fund seriously impacting operations and the
street program, respectively.
Workshop -April 26, 2016 Page 29 of 53
2017 Revised Forecast Budget
Total expenditures forecast for 2017 are $112,836,333, a decrease of $4.0 million, or 3.4% from the amended
2016 budget. The decrease is primarily due to capital projects for flood control, water and sewer and general
capital purchases being completed during the prior year. Included below is a pie chart illustrating total village
expenditures by major category.
2017 Total Forecast Budget - Expenditures
$6,187,678 $12,937,699
�I�ll
$3,748,242
IIIIIIII Personal Services
$2,212,9 52
I Pension Benefits
VIII ContrEstimate Services
$8,856,127
1111 Insurance
$45,136,518 111 Commodities and Supplies
Iles Other Expenditures
11111 Bond Principal and Interest
VIII Capital
$24,085,501
$9,671,616
Workshop - April 26, 2016 Page 30 of 53
VILLAGE OF MOUNT PROSPECT
GENERAL FUND - REVENUES AND EXPENDITURES
2017 FORECAST BUDGET - Q1
EXPENDII1"LIRES
Public Representation
2016
709,302
2017 Forecast
0
0.00%
Village Manager's Office
Current
Original
Current
Increase
Percent
Television Services Division
Projections
Forecast
Forecast
(Decrease)
Change
REVENUES
238,198
243,228
243,228
0
0.00%
Property Taxes
15,984,200
16,567,200
16,567,200
0
0.00%
Sales Taxes - ROT Portion
15,450,000
14,700,000
15,900,000
1,200,000
8.16%
Sales Taxes - HMR Portion
1,405,000
1,433,000
1,433,000
0
0.00%
Food and Beverage Tax
760,000
720,000
760,000
40,000
5.56%
Real Estate Transfer Tax
925,000
936,000
936,000
0
0.00%
Telecommunications Tax
2,150,000
2,200,000
2,200,000
0
0.00%
Other Utility Taxes
1,782,000
1,794,000
1,794,000
0
0.00%
Other Taxes
308,000
322,000
322,000
0
0.00%
Other Licenses, Permits, Fees
2,157,000
2,105,000
2,205,000
100,000
4.75%
State Income Tax
5,525,000
5,450,000
5,525,000
75,000
1.38%
Other Intergovernmental
2,530,420
2,337,720
2,337,720
0
0.00%
Charges for Services
1,417,000
1,407,200
1,507,200
100,000
7.11%
Fines and Forfeits
511,000
451,000
511,000
60,000
13.30%
Investment Income
28,100
4,100
34,100
30,000
731.71%
Other Revenue
519,500
483,150
523,150
40,000
8.28%
otalll Revenues
51,452,220
50,910,370
-52,555,370
1,645,000
-3.23
EXPENDII1"LIRES
Public Representation
699,374
709,302
709,302
0
0.00%
Village Manager's Office
3,396,802
3,202,887
3,202,887
0
0.00%
Television Services Division
195,097
200,043
200,043
0
0.00%
Village Clerk's Office
238,198
243,228
243,228
0
0.00%
Finance Department
2,035,030
2,046,287
2,046,287
0
0.00%
Community Development Dept.
2,424,754
2,476,106
2,476,106
0
0.00%
Human Services Dept.
1,107,503
1,125,261
1,125,261
0
0.00%
Police Department
17,540,844
18,037,293
18,037,293
0
0.00%
Fire Department
14,373,987
14,952,239
14,952,239
0
0.00%
Public Works Department
7,852,237
7,828,407
7,828,407
0
0.00%
Miscellaneous
46,616
46,616
46,616
0
0.00%
1"otaI Expeindftuires
49,910,442
-50,867,669
50,867,669-
0
-0.00%
EXCESS OF REVENUES
OVER 1w 'P1wNl:hlll'1"1w RES
1,541,778
42,701
1,687,701
1,645,000
13'"1"III- ER 1=IIINANO N SO1wi1 LEES USES
Transfers In
0
0
0
0
Transfers Out
(300,000)
0
(300,000)
(300,000)
Tota1 13tIheir F=l inainding Uses
(300,000)
0
300,000)
(300,000)
EXCESS OF REVENUES OVER
1w 'P1wNl:hlll'1"1w RES and 13'"1"III-WEE
1=IIflANON SO1wiRCES/USES
1,241,778
42,701
1,387,701
1,345,000
Workshop -April 26, 2016 Page 31 of 53
2017 Revised Forecast Budget
General Fund — The original 2017 General Fund forecast budget showed a slight surplus of $42,701 on revenues
of $50,910,370 and expenses of $50,867,699. While not significant, the projected surplus is a departure from
previous forecast amounts that have typically projected a deficit. Our adjusted estimate for 2017 now projects a
surplus of $1.4 million. Adjustments were made to various revenue line items, however, sales taxes accounted
for the large swing in the forecast budget.
In this early estimate, revenues for sales taxes are expected to come in higher than budget based on
expectations for 2016. Revenues are now projected to come in at $52,555,370. This is $1.6 million above the
original forecast budget and $1.1 million or 2.1% over the prior year. Included below is a pie chart projecting
General Fund revenues broken out by major revenue category.
The 2017 General Fund forecast budget for expenditures is $50,867,669. Overall growth in General Fund
expenditures from 2016 is $1.0 million or 1.9%. As was the case for 2016, a payment of $300,000 is estimated to
be due the Randhurst development for sales generated on the Randhurst site. To be conservative no other
assumptions were made to any expenditure category for the 2017 General Fund budget. The following pie chart
illustrates a breakdown of estimated General Fund forecast expenses broken out by department.
2017 General Fund Forecast - Expenditures
$1,125,261
$2,476,106
$2,092,903
$3,646,1
$7(
iiiiiiiiiiii Public Representation
IIIIIIIV Village Manager's Office
IIIIIIII Finance Department
IIIIIIII Community Development
IIIIIIIIII' Human Services Dept.
IIUUI Police Department
111111 Fire Department
IIIIIIII Public Works Department
Workshop -April 26, 2016 Page 32 of 53
Village of Mount prospect
Mount Prospect, Illinois
INTEROFFICE MEMORANDUM
TO: VILLAGE BOARD AND FINANCE COMMISSION
FROM: DEPUTY FINANCE DIRECTOR
DATE: APRIL 19, 2016
SUBJECT: PRELIMINARY COMMUNITY INVESTMENT PROGRAM 2017-2021
The Community Investment Program (CIP) forecasts our capital investment needs for the
community over the next five years. Departments were asked to submit projects to be
considered. The inclusion of a project request in the CIP does not guarantee funding.
Attached are the preliminary summary tables for the 2017-2021 CIP submittals. The figures for
this preliminary CIP projects are placeholders containing raw data. Meetings with the
departments to discuss funding and priorities are scheduled for next month.
The submittals for the year 2017 total $11,705,651. The five-year total for all project submittals
is $74,208,063. Please find summaries by department, by project category and by funding
source. Again, this information is preliminary, and will likely change during the next few months
as we meet to develop funding and priorities.
A workshop is planned for July to review the Proposed CIP 2017-2021. Staff will be available
at the workshop to discuss the projects and their impact on operations.
Copy:
Michael J. Cassady, Village Manager
Department Directors
Lynn M.Jarog
Deputy Finance Director
Workshop -April 26, 2016 Page 33 of 53
Village of Mount Prospect, Illinois
2017-2021 Community Investment Program
2017 thru 2021
DEPARTMENT SUMMARY
Department 2017
Community Development
500,000
Fire Department
454,500
Information Technology
361,551
Police Department
32,000
Public Works - Buildings
603,000
Public Works - Engineering
5,357,200
Public Works - Flood Control
840,000
Public Works - Forestry
325,500
Public Works - Parking
150,000
Public Works - Streets
75,000
Public Works - Vehicle
390,000
Public Works - Water/Sewer
2,978,250
Village Administration
60,650
5,790,800
TOTAL 11,705,651
PW - Buildings
5.24%
Police Department
1.19%
Information
Technology
0.59%
Fire Department
1.25%
Community
Development
2.16%
Village
Administration
0.08%
2017-2021 Community Investment Pr•ogr•am
2018 2019 2020 2021 Total
500,000
300,000
300,000
1,600,000
301,000
138,000
32,000
925,500
52,680
26,512
440,743
570,000
315,000
885,000
846,000
390,000
530,000
1,521,000
3,890,000
6,069,000
5,790,800
5,182,600
4,809,500
27,209,100
752,000
1,344,040
2,156,121
1,108,243
6,200,404
258,500
264,500
261,000
258,000
1,367,500
185,000
160,000
190,000
155,000
840,000
125,000
125,000
125,000
125,000
575,000
140,000
145,000
285,000
3,086,662
8,730,246
7,714,008
7,420,000
29,929,166
60,650
12,885,842
17,729,098
16,490,729
15,396,743
74,208,063
2017-2021 Summary
PW - Flood Control
8.36%
PW - Forestry
/ 1.84%
PW - Parking
1.13%
PW - Streets
0.77%
PW - Vehicle
0.38%
Workshop - April 26, 2016 Page 34 of 53
Village of Mount Prospect, Illinois
2017-2021 Community Investment Program
2017 thru 2021
PROJECTS BY DEPARTMENT
Department Project# Priority 2017 2018 2019 2020 2021 Total
Community Development
Pedestrian Improvement-Central/NWHWY/Prospect Ave
CD002.0-16
3
200,000
200,000
400,000
Pedestrian Improvement - Prospect/Main/Evergreen
CD003.0-16
3
200,000
200,000
Corridor Improvements
CD400.0-AN
4
200,000
200,000
200,000
600,000
Fagade and Interior Buildout Program
CD401.0-AN
2
100,000
100,000
100,000
100,000
400,000
Community Development Total
500,000
500,000
300,000
300,000
11600,000
Fire Department
Station 12 Kitchen
FD001.0-17
3
75,000
75,000
Gear Washers
FD002.0-17
3
8,000
8,000
Village Warning Sirens
FD003.0-16
3
90,000
90,000
Cardiac Monitors
FD004.0-16
2
250,000
250,000
Fire Safety Trailer
FD005.0-16
3
75,000
75,000
Powered EMS Stretchers & Stair Chairs
FD006.0-16
2
192,000
128,000
320,000
SCBA facepieces
FD007.0-16
1
63,000
63,000
Surface Supplied Air System
FD009.0-16
2
32,000
32,000
Physical Fitness Treadmills
FD700.0-AN
2
12,500
12,500
Fire Department Total
454,500
301,000
138,000
32,000
925,500
Information Technology
Target Solutions Training Software
ITFD001.0-17
2
7,000
7,000
PSTrax System
ITFD002.0-17
3
9,800
9,800
Tablets
ITFD003.0-17
2
1,800
1,800
Instant Messaging
ITHS001.0-16
5
26,512
26,512
New Human Services Software
ITHS001.0-17
1
3,240
3,240
E -Citation and Billing Solution
ITPD001.0-17
1
85,000
85,000
Coplogic Electronic Reporting Software
ITPD002.0-16
3
25,000
25,000
License Plate Recognition (LPR)
ITPD004.0-16
3
45,000
45,000
Customer Service Interface - Hansen-Vlg Website
ITPW001.0-16
3
40,000
40,000
GeoCortex Laserfiche Interface
ITPW002.0-16
3
30,000
30,000
Public Works Laptops
ITPW003.0-16
3
2,930
1,000
3,930
Increase Bandwidth to Outlying Fire Stations
ITVA002.0-16
1
52,000
52,000
Microsoft Server Licenses
ITVA005.0-16
2
14,100
14,100
SharePoint Online
ITVA006.0-16
3
15,881
15,881
SEIM Managed Services
ITVA007.0-16
2
43,800
43,800
Backup to Cloud
ITVA008.0-16
4
6,680
6,680
Network Core Switch Upgrade
ITVA009-16
2
31,000
31,000
Information Technology Total
361,551
52,680
26,512
440,743
Police Department
Administrative Section Renovation
PD001.0-16
2
500,000
500,000
Roll Call and Kitchenette Renovation
PD002.0-16
3
70,000
70,000
Lobby and Lobby Restrooms Renovation
PD003.0-16
3
115,000
115,000
Evidence Lab Renovation
PD004.0-16
3
200,000
200,000
2017-2021 Community Investment Pr•ogr•am
Workshop -April 26, 2016 Page 35 of 53
Department
Police Department Total
Public Works - Buildings
Project# Priority 2017 2018 2019 2020 2021 Total
HVAC Upgrade Village Hall
PWB0001.0-16 4
PW Fire Pump Replacement
PWB0001.0-17 2
Public Safety Garage Sprinkler
PWB0002.0-16 2
PW Fence Replacement
PWB0002.0-17 3
Public Safety Parking Deck Maintenance
PWB0003.0-16 2
Village Hall Domestic Booster Pump Replacement
PWB0003.0-17 3
Public Safety Training Room Rehab
PWB0004.0-16 4
Village Hall Flooring Improvements
PWB0004.0-17 3
Public Safety Exterior Imp - Planter Bed Removal
PWB0005.0-16 3
Public Safety Exterior Imp -Tuck -point & Power Wash
PWB0006.0-16 3
Public Safety Exterior Imp -Window Replacement
PWB0007.0-16 3
Fire Station #12 Apparatus Floor
PWB0008.0-16 3
Fire Station #13 Apparatus Floor
PWB0009.0-16 3
Fire Station #13 Bathrooms
PWBU010.0-16 3
Public Works Facility Exterior
PWBU012.0-16 3
Public Works Fire Alarm Upgrade
PWBU013.0-16 3
Village Hall Window Replacement
PWBU014.0-16 5
Other Public Buildings
PWBU800.0-AN 3
HVAC Replacement Program
PWBU801.0-AN 2
Public Works - Buildings Total
63,000
63,000
Public Works - Engineering
Emergency Vehicle Preemption System Replacement
PWEN002.0-16 3
Northwest Hwy/Mount Prospect Road Bike Path
PWEN005.0-16 3
Rand -Central -MP Road Study
PWEN006.0-16 2
Rand -Elmhurst -Kensington Road Study
PWEN007.0-16 2
Streetscape Improvements
PWEN008.0-16 2
Traffic Signal Generator Connections
PWEN009.0-16 3
Downtown Intersections Study
PWEN010.0-16 2
Bridge Improvements - See Gwun Avenue
PWEN011.0.17 3
Bridge Improvements - George Street
PWEN012.0.17 3
Bridge Improvements - Emerson Street
PWEN013.0.17 3
Bridge Improvements - Briarwood Drive West - South
PWEN014.0.17 3
New Sidewalks
PWEN801.0-AN 2
Sidewalk Cost Share Program
PWEN802.0-AN 3
Street Improvement Program
PWEN803.0-AN 1
Traffic Calming
PWEN804.0-AN 4
Traffic Signal Replacement Engineering
PWEN805.0-AN 4
Public Works - Engineering Total
97,500
45,000
4,472,000
Public Works - Flood Control
McDonald Creek Bank Stabilization
PWFC001.0-16 2
Detention Pond Improvement- Pond 1
PWFC002.0-16 2
Detention Pond Improvement- Pond 2
PWFC003.0-16 2
Detention Pond Improvement- Pond 6
PWFC004.0-16 2
Detention Pond Improvement- Pond 6A
PWFC005.0-16 2
Detention Pond Improvement- Pond 8
PWFC006.0-16 2
Weller Creek Silt Removal
PWFC009.0-16 3
Levee 37 Standby Emergency Generators
PWFC010.0-16 3
Storm Sewer Improvements - Park Drive
PWFC012.0-17 2
Neighborhood Drainage Improvements
PWFC800.0-AN 3
2017-2021 Community Investment Program
Workshop -April 26, 2016
135,000
570,000
315,000
885,000
75,000
30,000
610,000
640,000
200,000
400,000
45,000
45,000
93,000
400,000
93,000
200,000
153,000
153,000
440,000
255,000
440,000
200,000
400,000
63,000
63,000
88,000
88,000
55,000
70,000
70,000
30,000
225,000
255,000
40,000
60,000
100,000
160,000
230,000
210,000
140,000
230,000
90,200
92,000
93,800
45,000
97,500
45,000
4,472,000
4,502,000
4,532,000
75,000
4,592,000
75,000
50,000
50,000
50,000
45,000
60,000
105,000
50,000
50,000
200,000
75,000
50,000
275,000
38,000
6,069,000
5,790,800
5,182,600
4,809,500
38,000
30,000
30,000
100,000
160,000
165,000
165,000
165,000
755,000
25,000
275,000
25,000
25,000
40,000
390,000
603,000
846,000
390,000
530,000
1,521,000
3,890,000
135,000
135,000
270,000
75,000
75,000
200,000
400,000
600,000
200,000
400,000
600,000
200,000
200,000
255,000
255,000
200,000
400,000
600,000
175,000
175,000
55,000
55,000
30,000
30,000
20,000
20,000
160,000
190,000
210,000
140,000
700,000
90,200
92,000
93,800
95,600
97,500
469,100
4,472,000
4,502,000
4,532,000
4,562,000
4,592,000
22,660,000
50,000
50,000
50,000
50,000
50,000
250,000
50,000
50,000
50,000
50,000
50,000
250,000
5,357,200
6,069,000
5,790,800
5,182,600
4,809,500
27,209,100
150,000 1,350,000
100,000
760,000
280,000
290,000
30,000
230,000 230,000
360,000
100,000 100,000 100,000
900,000
500,000
100,000 100,000
Page 36 of 53
1,500,000
1,000,000
760,000
280,000
290,000
500,000
30,000
460,000
360,000
500,000
Department Project# Prio
Storm Sewer Inspection Program
PWFC802.0-AN 2
Public Works - Flood Control Total
PWWS002.0-16 3
Lift Station Rehab - Cottonwood
PWWS002.0-17 3
Public Works - Forestry
Ash Replacement Plantings
PWF0001.0-16 3
Ash Tree and Stump Removals
PWF0002.0-16 2
Prospect Ave. Block Wall Construction
PWF0003.0-16 4
Tree Planting Program
PWF0801.0-AN 2
Public Works - Forestry Total
Wireless Telemetry System Upgrade -PLC Upgrades
PWWS009.0-16 1
VFD Replacement
Public Works - Parkin
Parking Lot Improvements - Fire Station 12
PWPA001.0-16 3
Parking Lot Improvements - Well 17
PWPA002.0.17 3
Parking Lot Improvements - Wille St. Commuter Lot
PWPA003.0.17 3
Parking Lot Improvements - Train Station
PWPA004.0.17 3
Village Hall Parking Deck Maintenance
PWPA800.0-AN 3
Village Hall Parking Deck Maintenance - Painting
PWPA802.0-AN 3
Public Works - Parking Total
PWWS800.0-AN 1
Sewer Main Rehabilitation
PWWS801.0-AN 2
Public Works - Streets
Streetlight Improvements
PWST800.0-AN 3
Streetlight Improvements LED Retrofits
PWST801.0-AN 4
Public Works - Streets Total
68,250
35,000
75,246
Public Works - Vehicle
Vehicle Lifts
PWVE002.0-16 2
Public Works - Vehicle Total
Public Works - Water/Sewer
Water Tank Rehabilitation - Reservoir 5E
PWWS001.0-17 2
Televising Camera System Upgrades
PWWS002.0-16 3
Lift Station Rehab - Cottonwood
PWWS002.0-17 3
Water Tank Rehabilitation - Reservoir #11
PWWS003.0-17 1
Water Facility Roof Rehab -Station #11
PWWS004.0-16 3
Water Facility Roof Rehab -Station #16
PWWS005.0-16 3
Water Tank Rehabilitation -Reservoir 5-N
PWWS006.0-16 2
Wireless Telemetry System Remote Pressure Stations
PWWS008.0-16 2
Wireless Telemetry System Upgrade -PLC Upgrades
PWWS009.0-16 1
VFD Replacement
PWWS011.0-16 1
Deep Well Rehabilitation - Well #16
PWWS012.0-16 2
Deep Well Rehabilitation - Well #17
PWWS013.0-16 2
Lift Relief Station Rehab - Louis Street
PWWS015.0-16 1
Lift Relief Station Rehab - Huntington
PWWS017.0-16 3
Lift Relief Station Rehab - Fairview
PWWS018.0-16 3
Lift Relief Station Rehab - Lincoln Street
PWWS019.0-16 3
Water Main Replacement
PWWS800.0-AN 1
Sewer Main Rehabilitation
PWWS801.0-AN 2
Booster Station Pump Rehabilitation
PWWS803.0-AN 2
Combined Sewer Improvements
PWWS804.0-AN 1
Public Works - Water/Sewer Total
2017-2021 Community Investment Program
Workshop -April 26, 2016
rity 2017 2018 2019 2020 2021 Total
100,000
102,000
104,040
106,121
108,243
520,404
840,000
752,000
1,344,040
2,156,121
1,108,243
6,200,404
40,000
450,000
40,000
47,000
47,000
42,500
42,500
27,500
112,500
196,000
216,000
237,000
261,000
258,000
1,168,000
325,500
258,500
264,500
261,000
258,000
1,367,500
68,250
35,000
75,246
79,008
80,000
35,000
40,000
40,000
10,000
40,000
40,000
10,000
30,000
50,000
40,000
50,000
40,000
75,000
435,000
30,000
30,000
50,000
50,000
50,000
50,000
50,000
250,000
100,000
100,000
100,000
100,000
75,000
475,000
150,000
185,000
160,000
190,000
155,000
840,000
75,000
75,000
75,000
75,000
75,000
375,000
50,000
50,000
50,000
50,000
200,000
75,000
125,000
125,000
125,000
125,000
575,000
550,000
140,000
145,000
1,000,000
1,000,000
285,000
55,000
140,000
145,000
60,000
65,000
285,000
2,978,250 3,086,662 8,730,246 7,714,008 7,420,000 29,929,166
Page 37 of 53
680,000
680,000
80,000
90,000
170,000
450,000
450,000
315,000
315,000
70,000
70,000
70,000
70,000
75,000
600,000
675,000
68,250
71,662
75,246
79,008
80,000
374,166
40,000
40,000
40,000
40,000
40,000
200,000
30,000
50,000
50,000
50,000
180,000
75,000
435,000
510,000
35,000
35,000
350,000
350,000
650,000
650,000
450,000
450,000
350,000
350,000
650,000
650,000
4,900,000
4,900,000
4,900,000
16,000,000
550,000
550,000
1,000,000
1,000,000
1,000,000
4,100,000
55,000
60,000
60,000
60,000
65,000
300,000
800,000
800,000
800,000
800,000
800,000
4,000,000
2,978,250 3,086,662 8,730,246 7,714,008 7,420,000 29,929,166
Page 37 of 53
Department Project# Priority 2017
Village Administration
Playback System Upgrade to HD VA001.0-16 3 35,650
Replacement Switcher for TV Services Control Room VA002.0.16 3 25,000
Village Administration Total 60,650
GRAND TOTAL 11,705,651 12,885,842 17,729,098 16,490,729 15,396,743 74,208,063
2018 2019 2020 2021 Total
35,650
25,000
60,650
2017-2021 Community Investment Pwgr•am
Workshop -April 26, 2016 Page 38 of 53
Village of Mount Prospect, Illinois
2017-2021 Community Investment Program
2017 thru 2021
CATEGORY SUMMARY
Category 2017 2018 2019 2020 2021 Total
700 Water System
1,278,250
1,086,662
6,480,246
5,564,008
19,579,166
701
Sanitary System
1,700,000
2,000,000
2,250,000
2,150,000
2,250,000
10,350,000
702
Flood Control Projects
510,000
410,000
530,000
1,500,000
150,000
3,100,000
703
Storm Sewer
380,000
392,000
864,040
706,121
1,008,243
3,350,404
704
Street Const & Reconst
935,000
1,310,000
1,055,000
485,000
20,000
3,805,000
705
Resurface-Curbs/Gutters/SW
4,797,200
5,184,000
4,960,800
4,922,600
4,814,500
24,679,100
706
Public Bldg Const& Improvements
753,000
1,531,000
940,000
720,000
1,676,000
5,620,000
707
Computer HW/SW
361,551
52,680
26,512
440,743
708
Vehicles and Auto Equip
215,000
145,000
360,000
709
Furnishings & Non -Auto Equip
515,150
206,000
63,000
32,000
816,150
710
Miscellaneous
475,500
498,500
414,500
411,000
308,000
2,107,500
TOTAL 11,705,651 12,885,842 17,729,098 16,490,729 15,396,743 74,208,063
2017-2021 Community Investment Pr•ogr•am
Workshop -April 26, 2016
Page 39 of 53
Village of Mount Prospect, Illinois
2017-2021 Community Investment Program
2017 thru 2021
PROJECTS BY CATEGORY
Category Project# Priority 2017 2018 2019 2020 2021 Total
700 Water Svstem
Water Tank Rehabilitation - Reservoir 5E
PWWS001.0-17
2
680,000
680,000
Televising Camera System Upgrades
PWWS002.0-16
3
80,000
90,000
170,000
Water Tank Rehabilitation - Reservoir #11
PWWS003.0-17
1
315,000
315,000
Water Facility Roof Rehab -Station #11
PWWS004.0-16
3
70,000
70,000
Water Facility Roof Rehab -Station #16
PWWS005.0-16
3
70,000
70,000
Water Tank Rehabilitation -Reservoir 5-N
PWWS006.0-16
2
75,000
600,000
675,000
Wireless Telemetry System Remote Pressure Stations
PWWS008.0-16
2
68,250
71,662
75,246
79,008
80,000
374,166
Wireless Telemetry System Upgrade -PLC Upgrades
PWWS009.0-16
1
40,000
40,000
40,000
40,000
40,000
200,000
VFD Replacement
PWWS011.0-16
1
30,000
50,000
50,000
50,000
180,000
Deep Well Rehabilitation - Well #16
PWWS012.0-16
2
75,000
435,000
510,000
Deep Well Rehabilitation - Well #17
PWWS013.0-16
2
35,000
35,000
Water Main Replacement
PWWS800.0-AN
1
650,000
650,000
4,900,000
4,900,000
4,900,000
16,000,000
Booster Station Pump Rehabilitation
PWWS803.0-AN
2
55,000
60,000
60,000
60,000
65,000
300,000
700 Water System Total
1,278,250
1,086,662
6,480,246
5,564,008
5,170,000
19,579,166
701 Sanitary System
Lift Station Rehab - Cottonwood
PWWS002.0-17
3
450,000
450,000
Lift Relief Station Rehab - Louis Street
PWWS015.0-16
1
350,000
350,000
Lift Relief Station Rehab - Huntington
PWWS017.0-16
3
650,000
650,000
Lift Relief Station Rehab - Fairview
PWWS018.0-16
3
450,000
450,000
Lift Relief Station Rehab - Lincoln Street
PWWS019.0-16
3
350,000
350,000
Sewer Main Rehabilitation
PWWS801.0-AN
2
550,000
550,000
1,000,000
1,000,000
1,000,000
4,100,000
Combined Sewer Improvements
PWWS804.0-AN
1
800,000
800,000
800,000
800,000
800,000
4,000,000
701 Sanitary System Total
1,700,000
2,000,000
2,250,000
2,150,000
2,250,000
10,350,000
702 Flood Control Projects
Traffic Signal Replacement Engineering
PWEN805.0-AN
4
50,000
50,000
50,000
50,000
50,000
250,000
McDonald Creek Bank Stabilization
PWFC001.0-16
2
150,000
1,350,000
1,500,000
Weller Creek Silt Removal
PWFC009.0-16
3
30,000
30,000
Levee 37 Standby Emergency Generators
PWFC010.0-16
3
230,000
230,000
460,000
Storm Sewer Improvements - Park Drive
PWFC012.0-17
2
360,000
360,000
Neighborhood Drainage Improvements
PWFC800.0-AN
3
100,000
100,000
100,000
100,000
100,000
500,000
702 Flood Control Projects Total
510,000
410,000
530,000
1,500,000
150,000
3,100,000
703 Storm Sewer
Detention Pond Improvement- Pond 1
PWFC002.0-16
2
100,000
900,000
1,000,000
Detention Pond Improvement- Pond 2
PWFC003.0-16
2
760,000
760,000
Detention Pond Improvement - Pond 6
PWFC004.0-16
2
280,000
280,000
Detention Pond Improvement - Pond 6A
PWFC005.0-16
2
290,000
290,000
Detention Pond Improvement- Pond 8
PWFC006.0-16
2
500,000
500,000
Storm Sewer Inspection Program
PWFC802.0-AN
2
100,000
102,000
104,040
106,121
108,243
520,404
2017-2021 Community Investment Program
Workshop - April 26, 2016 Page 40 of 53
Category Project# Priority 2017 2018 2019 2020 2021 Total
703 Storm Sewer Total
704 Street Const & Reconst
Pedestrian Improvement-Central/NWHWY/Prospect Ave CD002.0-16
Pedestrian Improvement - Prospect/Main/Evergreen CD003.0-16
Corridor Improvements
CD400.0-AN
Emergency Vehicle Preemption System Replacement
PWEN002.0-16
Rand -Central -MP Road Study
PWEN006.0-16
Rand -Elmhurst -Kensington Road Study
PWEN007.0-16
Traffic Signal Generator Connections
PWEN009.0-16
Downtown Intersections Study
PWEN010.0-16
Bridge Improvements - See Gwun Avenue
PWEN011.0.17
Bridge Improvements - George Street
PWEN012.0.17
Bridge Improvements - Emerson Street
PWEN013.0.17
Bridge Improvements - Briarwood Drive West - South
PWEN014.0.17
704 Street Const & Reconst Total
200,000
600,000
705 Resurface-Curbs/Gutters/SW
Northwest Hwy/Mount Prospect Road Bike Path
PWEN005.0-16
Streetscape Improvements
PWEN008.0-16
New Sidewalks
PWEN801.0-AN
Sidewalk Cost Share Program
PWEN802.0-AN
Street Improvement Program
PWEN803.0-AN
Streetlight Improvements
PWST800.0-AN
Streetlight Improvements LED Retrofits
PWST801.0-AN
705 Resurface-Curbs/Gutters/SW Total
600,000
3
706 Public Bldg Const & Improvement
Station 12 Kitchen
FD001.0-17
Administrative Section Renovation
PD001.0-16
Lobby and Lobby Restrooms Renovation
PD003.0-16
Evidence Lab Renovation
PD004.0-16
HVAC Upgrade Village Hall
PWB0001.0-16
PW Fire Pump Replacement
PWB0001.0-17
Public Safety Garage Sprinkler
PWB0002.0-16
PW Fence Replacement
PWB0002.0-17
Public Safety Parking Deck Maintenance
PWB0003.0-16
Village Hall Domestic Booster Pump Replacement
PWB0003.0-17
Public Safety Training Room Rehab
PWB0004.0-16
Village Hall Flooring Improvements
PWB0004.0-17
Public Safety Exterior Imp - Planter Bed Removal
PWB0005.0-16
Public Safety Exterior Imp -Tuck -point & Power Wash
PWB0006.0-16
Public Safety Exterior Imp -Window Replacement
PWB0007.0-16
Fire Station #12 Apparatus Floor
PWB0008.0-16
Fire Station #13 Apparatus Floor
PWB0009.0-16
Fire Station #13 Bathrooms
PWBU010.0-16
Public Works Facility Exterior
PWBU012.0-16
Public Works Fire Alarm Upgrade
PWBU013.0-16
Village Hall Window Replacement
PWBU014.0-16
Other Public Buildings
PWBU800.0-AN
HVAC Replacement Program
PWBU801.0-AN
Parking Lot Improvements - Fire Station 12
PWPA001.0-16
Parking Lot Improvements - Well 17
PWPA002.0.17
Parking Lot Improvements - Wille St. Commuter Lot
PWPA003.0.17
Parking Lot Improvements - Train Station
PWPA004.0.17
2017-2021 Community Investment Program
380,000
392,000
864,040
706,121
1,008,243
3,350,404
3 200,000
200,000
400,000
3 200,000
115,000
200,000
4
200,000
200,000
200,000
600,000
3 135,000
135,000
30,000
610,000
270,000
2 200,000
400,000
45,000
600,000
2
200,000
400,000
600,000
3
255,000
153,000
255,000
2 200,000
400,000
600,000
3
175,000
63,000
175,000
3
88,000
55,000
55,000
3
30,000
70,000
30,000
3
30,000
20,000
20,000
935,000
1,310,000
1,055,000
485,000
20,000
3,805,000
3
75,000
75,000
2
200,000
45,000
200,000
2 160,000
190,000
210,000
140,000
700,000
3 90,200
92,000
93,800
95,600
97,500
469,100
1 4,472,000
4,502,000
4,532,000
4,562,000
4,592,000
22,660,000
3 75,000
75,000
75,000
75,000
75,000
375,000
4
50,000
50,000
50,000
50,000
200,000
4,797,200
5,184,000
4,960,800
4,922,600
4,814,500
24,679,100
3
75,000
75,000
2
500,000
500,000
3
115,000
115,000
3
200,000
200,000
4
30,000
610,000
640,000
2
45,000
45,000
2
93,000
93,000
3
153,000
153,000
2 440,000
440,000
3
63,000
63,000
4
88,000
88,000
3
70,000
70,000
3
30,000
225,000
255,000
3
40,000
60,000
100,000
3
230,000
230,000
3
45,000
45,000
3
75,000
75,000
3
45,000
60,000
105,000
3
200,000
75,000
275,000
3 38,000
38,000
5
30,000
30,000
3 100,000
160,000
165,000
165,000
165,000
755,000
2 25,000
275,000
25,000
25,000
40,000
390,000
3
35,000
35,000
3
10,000
10,000
3
40,000
40,000
3
30,000
30,000
Workshop - April 26, 2016 Page 41 of 53
Category Project# Priority 2017 2018 2019 2020 2021 Total
Village Hall Parking Deck Maintenance
PWPA800.0-AN 3
Village Hall Parking Deck Maintenance - Painting
PWPA802.0-AN 3
706 Public Bldg Const & Improvements
250,000
Total
100,000
100,000
100,000
707 Computer HW/SW
Target Solutions Training Software
ITFD001.0-17 2
PSTrax System
ITFD002.0-17 3
Tablets
ITFD003.0-17 2
Instant Messaging
ITHS001.0-16 5
New Human Services Software
ITHS001.0-17 1
E -Citation and Billing Solution
ITPD001.0-17 1
Coplogic Electronic Reporting Software
ITPD002.0-16 3
License Plate Recognition (LPR)
ITPD004.0-16 3
Customer Service Interface - Hansen-Vlg Website
ITPW001.0-16 3
GeoCortex Laserfiche Interface
ITPW002.0-16 3
Public Works Laptops
ITPW003.0-16 3
Increase Bandwidth to Outlying Fire Stations
ITVA002.0-16 1
Microsoft Server Licenses
ITVA005.0-16 2
SharePoint Online
ITVA006.0-16 3
SEIM Managed Services
ITVA007.0-16 2
Backup to Cloud
ITVA008.0-16 4
Network Core Switch Upgrade
ITVA009-16 2
707 Computer HW/SW Total
3,240
85,000
708 Vehicles and Auto Equip
Fire Safety Trailer
FD005.0-16 3
Vehicle Lifts
PWVE002.0-16 2
708 Vehicles and Auto Equip Total
709 Furnishings & Non -Auto E ui
Gear Washers
FD002.0-17 3
Cardiac Monitors
FD004.0-16 2
Powered EMS Stretchers & Stair Chairs
FD006.0-16 2
SCBA facepieces
FD007.0-16 1
Surface Supplied Air System
FD009.0-16 2
Physical Fitness Treadmills
FD700.0-AN 2
Roll Call and Kitchenette Renovation
PD002.0-16 3
Playback System Upgrade to HD
VA001.0-16 3
Replacement Switcher for TV Services Control Room
VA002.0.16 3
709 Furnishings & Non -Auto Equip Total
2,930
1,000
710 Miscellaneous
Fagade and Interior Buildout Program
CD401.0-AN 2
Village Warning Sirens
FD003.0-16 3
Traffic Calming
PWEN804.0-AN 4
Ash Replacement Plantings
PWF0001.0-16 3
Ash Tree and Stump Removals
PWF0002.0-16 2
Prospect Ave. Block Wall Construction
PWF0003.0-16 4
Tree Planting Program
PWFO801.0-AN 2
710 Miscellaneous Total
GRAND TOTAL
2017-2021 Community Investment Program
Workshop -April 26, 2016
50,000
50,000
50,000
50,000
50,000
250,000
100,000
100,000
100,000
100,000
75,000
475,000
753,000
1,531,000
940,000
720,000
1,676,000
5,620,000
7,000
7,000
9,800
9,800
1,800
1,800
26,512
26,512
3,240
3,240
85,000
85,000
25,000
25,000
45,000
45,000
40,000
40,000
30,000
30,000
2,930
1,000
3,930
52,000
52,000
14,100
14,100
15,881
15,881
43,800
43,800
6,680
6,680
31,000
31,000
361,551
52,680
26,512
440,743
75,000
75,000
140,000
145,000
285,000
215,000
145,000
360,000
8,000
8,000
250,000
250,000
192,000
128,000
320,000
63,000
63,000
32,000
32,000
12,500
12,500
70,000
70,000
35,650
35,650
25,000
25,000
515,150
206,000
63,000
32,000
816,150
100,000
100,000
100,000
100,000
400,000
90,000
90,000
50,000
50,000
50,000
50,000
50,000
250,000
40,000
40,000
47,000
47,000
42,500
42,500
27,500
112,500
196,000
216,000
237,000
261,000
258,000
1,168,000
475,500
498,500
414,500
411,000
308,000
2,107,500
11,705,651
12,885,842
17,729,098
16,490,729
15,396,743
74,208,063
Page 42 of 53
2017-2021 Community Investment Pr•ogr•am
Workshop -April 26, 2016
Page 43 of 53
Village of Mount Prospect,
Illinois
Refuse Fund Fund
2017-2021 Community Investment Program
Summary
Flood Control
2017 thru 2021
Fund
4.06%
FUNDING SOURCE SUMMARY
Street
Source
2017 2018
2019
2020
2021
Total
001 General Fund
1,267,751 1,282,180
1,368,300
751,600
355,500
5,025,331
020 Capital Improvement Fund
1,582,650 2,927,000
2,194,512
1,527,000
2,596,000
10,827,162
022 Downtown Redevelopment Construction
Fund 100,000 300,000
100,000
100,000
600,000
023 Street Improvement Construction Fund
3,972,000 4,077,000
4,032,000
4,062,000
4,092,000
20,235,000
024 Flood Control Construction Fund
430,000 462,000
354,040
1,556,121
208,243
3,010,404
040 Refuse Fund
30,000
Water and Sewer
30,000
041 Motor Fuel Tax Fund
960,000 600,000
600,000
600,000
600,000
3,360,000
050 Water and Sewer Fund
3,003,250 3,087,662
8,050,246
7,714,008
8,100,000
29,955,166
051 Village Parking System Fund
590,000 150,000
150,000
150,000
125,000
1,165,000
GRAND TOTAL 11,935,651 12,885,842 16,849,098
16,460,729
16,076,743
74,208,063
2017-2021 Community Investment Pr•ogr•am
Workshop -April 26, 2016
Page 43 of 53
Motor Fuel Tax
2017-2021
Refuse Fund Fund
0.04% 4.53%
Summary
Flood Control
Fund
4.06%
Street
Improvement
Fund
27.27%
�f
Water and Sewer
Fund
40.37%
Downtown
Redevelopment
Fund
0.81%
Capital
Village Parking
Improvement
System Fund
Fund General Fund
1.57%
14.59% 0
6.7 7
2017-2021 Community Investment Pr•ogr•am
Workshop -April 26, 2016
Page 43 of 53
Source
Village of Mount Prospect, Illinois
2017 - 2021 Community Investment Program
2017 thru 2021
PROJECTS BY FUNDING SOURCE
Project# Priority 2017 2018 2019 2020 2021 Total
001 General Fund
CD400.0-AN
Station 12 Kitchen
FD001.0-17
Physical Fitness Treadmills
FD700.0-AN
2
12,500
Target Solutions Training Software
ITFD001.0-17
2
7,000
PSTrax System
ITFD002.0-17
3
9,800
Tablets
ITFD003.0-17
2
1,800
New Human Services Software
ITHS001.0-17
1
3,240
Customer Service Interface - Hansen-Vlg Website
ITPW001.0-16
3
10,000
GeoCortex Laserfiche Interface
ITPW002.0-16
3
5,000
Public Works Laptops
ITPW003.0-16
3
2,930
Microsoft Server Licenses
ITVA005.0-16
2
14,100
SharePoint Online
ITVA006.0-16
3
15,881
SEIM Managed Services
ITVA007.0-16
2
43,800
Backup to Cloud
ITVA008.0-16
4
31,000
Network Core Switch Upgrade
ITVA009-16
2
31,000
Emergency Vehicle Preemption System Replacement
PWEN002.0-16
3
135,000
Rand -Central -MP Road Study
PWEN006.0-16
2
200,000
Rand -Elmhurst -Kensington Road Study
PWEN007.0-16
2
255,000
Traffic Signal Generator Connections
PWEN009.0-16
3
600,000
Downtown Intersections Study
PWEN010.0-16
2
200,000
New Sidewalks
PWEN801.0-AN
2
160,000
Sidewalk Cost Share Program
PWEN802.0-AN
3
90,200
Ash Replacement Plantings
PWF0001.0-16
3
40,000
Ash Tree and Stump Removals
PWF0002.0-16
2
47,000
Prospect Ave. Block Wall Construction
PWF0003.0-16
4
42,500
Tree Planting Program
PWF0801.0-AN
2
196,000
001 General Fund Total
020 Capital Improvement Fund
Pedestrian Improvement-Central/NWHWY/Prospect Ave CD002.0-16
Pedestrian Improvement - Prospect/Main/Evergreen CD003.0-16
Corridor Improvements
CD400.0-AN
Station 12 Kitchen
FD001.0-17
Gear Washers
FD002.0-17
Village Warning Sirens
FD003.0-16
Cardiac Monitors
FD004.0-16
Fire Safety Trailer
FD005.0-16
Powered EMS Stretchers & Stair Chairs
FD006.0-16
SCBA facepieces
FD007.0-16
Surface Supplied Air System
FD009.0-16
Instant Messaging
ITHS001.0-16
E -Citation and Billing Solution
ITPD001.0-17
Coplogic Electronic Reporting Software
ITPD002.0-16
License Plate Recognition (LPR)
ITPD004.0-16
Increase Bandwidth to Outlying Fire Stations
ITVA002.0-16
2017-2021 Community Investment Program
3
3
4
3
3
3
2
3
2
1
2
5
1
3
3
1
1,267,751 1,282,180 1,368,300 751,600 355,500 5,025,331
200,000
200,000
12,500
7,000
200,000
9,800
8,000
1,800
90,000
250,000
3,240
75,000
10,000
192,000
128,000
5,000
63,000
2,930
26,512
14,100
15,881
43,800
6,680
6,680
31,000
135,000
270,000
400,000
600,000
200,000
400,000
600,000
255,000
255,000
400,000
600,000
190,000
210,000
140,000
700,000
92,000
93,800
95,600 97,500
469,100
40,000
47,000
42,500
27,500
112,500
216,000
237,000
261,000 258,000
1,168,000
1,267,751 1,282,180 1,368,300 751,600 355,500 5,025,331
200,000
200,000
200,000
200,000
200,000
75,000
8,000
90,000
250,000
75,000
192,000
128,000
63,000
26,512
85,000
25,000
52,000
45.000
200,000
32.000
Workshop - April 26, 2016 Page 44 of 53
400,000
200,000
600,000
75,000
8,000
90,000
250,000
75,000
320,000
63,000
32,000
26,512
85,000
25,000
45,000
52,000
Source Project# Priority
2017
2018
2019
2020
2021
Total
Administrative Section Renovation
PD001.0-16
2
500,000
500,000
Roll Call and Kitchenette Renovation
PD002.0-16
3
70,000
70,000
Lobby and Lobby Restrooms Renovation
PD003.0-16
3
115,000
115,000
Evidence Lab Renovation
PD004.0-16
3
200,000
200,000
HVAC Upgrade Village Hall
PWB0001.0-16
4
30,000
610,000
640,000
PW Fire Pump Replacement
PWB0001.0-17
2
45,000
45,000
Public Safety Garage Sprinkler
PWB0002.0-16
2
93,000
93,000
PW Fence Replacement
PWB0002.0-17
3
153,000
153,000
Village Hall Domestic Booster Pump Replacement
PWB0003.0-17
3
63,000
63,000
Public Safety Training Room Rehab
PWB0004.0-16
4
88,000
88,000
Village Hall Flooring Improvements
PWB0004.0-17
3
70,000
70,000
Public Safety Exterior Imp - Planter Bed Removal
PWB0005.0-16
3
30,000
225,000
255,000
Public Safety Exterior Imp -Tuck -point & Power Wash
PWB0006.0-16
3
40,000
60,000
100,000
Public Safety Exterior Imp -Window Replacement
PWB0007.0-16
3
230,000
230,000
Fire Station #12 Apparatus Floor
PWB0008.0-16
3
45,000
45,000
Fire Station #13 Apparatus Floor
PWB0009.0-16
3
75,000
75,000
Fire Station #13 Bathrooms
PWBU010.0-16
3
45,000
60,000
105,000
Public Works Facility Exterior
PWBU012.0-16
3
200,000
75,000
275,000
Public Works Fire Alarm Upgrade
PWBU013.0-16
3 38,000
38,000
Village Hall Window Replacement
PWBU014.0-16
5
30,000
30,000
Other Public Buildings
PWBU800.0-AN
3 100,000
160,000
165,000
165,000
165,000
755,000
HVAC Replacement Program
PWBU801.0-AN
2 25,000
275,000
25,000
25,000
40,000
390,000
Bridge Improvements - See Gwun Avenue
PWEN011.0.17
3
175,000
175,000
Bridge Improvements - George Street
PWEN012.0.17
3
55,000
55,000
Bridge Improvements - Emerson Street
PWEN013.0.17
3
30,000
30,000
Bridge Improvements - Briarwood Drive West - South
PWEN014.0.17
3
20,000
20,000
Detention Pond Improvement- Pond 1
PWFC002.0-16
2
100,000
900,000
1,000,000
Detention Pond Improvement- Pond 2
PWFC003.0-16
2
760,000
760,000
Detention Pond Improvement- Pond 6
PWFC004.0-16
2 280,000
280,000
Detention Pond Improvement- Pond 6A
PWFC005.0-16
2
290,000
290,000
Detention Pond Improvement- Pond 8
PWFC006.0-16
2
500,000
500,000
Parking Lot Improvements - Fire Station 12
PWPA001.0-16
3
35,000
35,000
Parking Lot Improvements - Well 17
PWPA002.0.17
3
10,000
10,000
Parking Lot Improvements - Wille St. Commuter Lot
PWPA003.0.17
3
40,000
40,000
Parking Lot Improvements - Train Station
PWPA004.0.17
3
30,000
30,000
Streetlight Improvements
PWST800.0-AN
3 75,000
75,000
75,000
75,000
75,000
375,000
Streetlight Improvements LED Retrofits
PWST801.0-AN
4
50,000
50,000
50,000
50,000
200,000
Vehicle Lifts
PWVE002.0-16
2
140,000
145,000
285,000
Playback System Upgrade to HD
VA001.0-16
3 35,650
35,650
Replacement Switcher for TV Services Control Room
VA002.0.16
3 25,000
25,000
020 Capital Improvement Fund Total
1,582,650
2,927,000
2,194,512
1,527,000
2,596,000
10,827,162
022 Downtown Redevelopment Constr
Fagade and Interior Buildout Program
CD401.0-AN
2 100,000
100,000
100,000
100,000
400,000
Streetscape Improvements
PWEN008.0-16
2
200,000
200,000
022 Downtown Redevelopment
100,000
300,000
100,000
100,000
600,000
Construction Fund Total
023 Street Improvement Construction
Northwest Hwy/Mount Prospect Road Bike Path
PWEN005.0-16
3
75,000
75,000
Street Improvement Program
PWEN803.0-AN
1 3,922,000
3,952,000
3,982,000
4,012,000
4,042,000
19,910,000
Traffic Calming
PWEN804.0-AN
4 50,000
50,000
50,000
50,000
50,000
250,000
2017-2021 Community Investment Pr•ogr•am
Workshop -April 26, 2016 Page 45 of 53
Source Project# Priority
023 Street Improvement Construction
4,077,000
Fund Total
4,062,000
4,092,000
20,235,000
024 Flood Control Construction Fund
McDonald Creek Bank Stabilization
PWFC001.0-16 2
Weller Creek Silt Removal
PWFC009.0-16 3
Levee 37 Standby Emergency Generators
PWFC010.0-16 3
Neighborhood Drainage Improvements
PWFC800.0-AN 3
Storm Sewer Inspection Program
PWFC802.0-AN 2
024 Flood Control Construction Fund
230,000
Total
680,000
040 Refuse Fund
Customer Service Interface - Hansen-Vlg Website
ITPW001.0-16 3
GeoCortex Laserfiche Interface
ITPW002.0-16 3
040 Refuse Fund Total
500,000
100,000
102,000
041 Motor Fuel Tax Fund
Street Improvement Program
PWEN803.0-AN 1
Traffic Signal Replacement Engineering
PWEN805.0-AN 4
Storm Sewer Improvements - Park Drive
PWFC012.0-17 2
041 Motor Fuel Tax Fund Total
208,243
3,010,404
15,000
050 Water and Sewer Fund
Customer Service Interface - Hansen-Vlg Website
ITPW001.0-16 3
GeoCortex Laserfiche Interface
ITPW002.0-16 3
Public Works Laptops
ITPW003.0-16 3
Water Tank Rehabilitation - Reservoir 5E
PWWS001.0-17 2
Televising Camera System Upgrades
PWWS002.0-16 3
Lift Station Rehab - Cottonwood
PWWS002.0-17 3
Water Tank Rehabilitation - Reservoir #11
PWWS003.0-17 1
Water Facility Roof Rehab -Station #11
PWWS004.0-16 3
Water Facility Roof Rehab -Station #16
PWWS005.0-16 3
Water Tank Rehabilitation -Reservoir 5-N
PWWS006.0-16 2
Wireless Telemetry System Remote Pressure Stations
PWWS008.0-16 2
Wireless Telemetry System Upgrade -PLC Upgrades
PWWS009.0-16 1
VFD Replacement
PWWS011.0-16 1
Deep Well Rehabilitation - Well #16
PWWS012.0-16 2
Deep Well Rehabilitation - Well #17
PWWS013.0-16 2
Lift Relief Station Rehab - Louis Street
PWWS015.0-16 1
Lift Relief Station Rehab - Huntington
PWWS017.0-16 3
Lift Relief Station Rehab - Fairview
PWWS018.0-16 3
Lift Relief Station Rehab - Lincoln Street
PWWS019.0-16 3
Water Main Replacement
PWWS800.0-AN 1
Sewer Main Rehabilitation
PWWS801.0-AN 2
Booster Station Pump Rehabilitation
PWWS803.0-AN 2
Combined Sewer Improvements
PWWS804.0-AN 1
050 Water and Sewer Fund Total
2017-2021 Community Investment Program
Workshop -April 26, 2016
2017 2018 2019 2020 2021 Total
3,972,000
4,077,000
4,032,000
4,062,000
4,092,000
20,235,000
10,000
150,000
1,350,000
1,500,000
30,000
30,000
230,000
230,000
680,000
460,000
100,000
100,000
100,000
100,000
100,000
500,000
100,000
102,000
104,040
106,121
108,243
520,404
430,000
462,000
354,040
1,556,121
208,243
3,010,404
15,000
15,000
15,000
70,000
15,000
30,000
75,000
600,000
30,000
550,000
550,000
550,000
550,000
550,000
2,750,000
50,000
50,000
50,000
50,000
50,000
250,000
360,000
30,000
50,000
50,000
50,000
360,000
960,000
600,000
600,000
600,000
600,000
3,360,000
15,000
15,000
10,000
10,000
1,000
1,000
680,000
680,000
80,000
90,000
170,000
450,000
450,000
315,000
315,000
70,000
70,000
70,000
70,000
75,000
600,000
675,000
68,250
71,662
75,246
79,008
80,000
374,166
40,000
40,000
40,000
40,000
40,000
200,000
30,000
50,000
50,000
50,000
180,000
75,000
435,000
510,000
35,000
35,000
350,000
350,000
650,000
650,000
450,000
450,000
350,000
350,000
650,000
650,000
4,900,000
4,900,000
4,900,000
16,000,000
550,000
550,000
1,000,000
1,000,000
1,000,000
4,100,000
55,000
60,000
60,000
60,000
65,000
300,000
800,000
800,000
800,000
800,000
800,000
4,000,000
3,003,250 3,087,662 8,050,246 7,714,008 8,100,000 29,955,166
Page 46 of 53
Source Project# Priority
051 Village Parking System Fund
Public Safety Parking Deck Maintenance PWB0003.0-16
Village Hall Parking Deck Maintenance PWPA800.0-AN
Village Hall Parking Deck Maintenance - Painting PWPA802.0-AN
051 Village Parking System Fund Total
GRAND TOTAL
2017-2021 Community Investment Program
Workshop -April 26, 2016
2017 2018 2019 2020 2021 Total
2 440,000
440,000
3 50,000 50,000 50,000 50,000 50,000
250,000
3 100,000 100,000 100,000 100,000 75,000
475,000
590,000 150,000 150,000 150,000 125,000
1,165,000
11,935,651 12,885,842 16,849,098 16,460,729 16,076,743 74,208,063
Page 47 of 53
Village of Mount Prospect, Illinois
2017-2021 Community Investment Program
2017 thru 2021
PROJECTS & FUNDING SOURCES BY DEPARTMENT
Department
Project#
Priority
2017
2018
2019
2020 2021
Total
Target Solutions Training Software
ITFD001.0-17
2
Community Development
Pedestrian Improvement-Central/NWHWY/Prospect Ave
CD002.0-16
3
200,000
200,000
7,000
7,000
400,000
020 Capital Improvement Fund
3
200,000
200,000
001 General Fund
400,000
Pedestrian Improvement - Prospect/Main/Evergreen
CD003.0-16
3
200,000
ITFD003.0-17
2
200,000
020 Capital Improvement Fund
001 General Fund
200,000
1,800
1,800
200,000
Corridor Improvements
CD400.0-AN
4
26,512
200,000
200,000
200,000
600,000
020 Capital Improvement Fund
26,512
26,512
New Human Services Software
200,000
200,000
200,000
600,000
Fagade and Interior Buildout Program
CD401.0-AN
2
100,000
100,000
100,000
100,000
400,000
022 Downtown Redevelopment Construction Fund
100,000
100,000
100,000
100,000
400,000
Community Development Total
500,000
500,000
300,000
300,000
11600,000
Fire Department
Station 12 Kitchen
FD001.0-17
3
75,000
75,000
020 Capital Improvement Fund
75,000
75,000
Gear Washers
FD002.0-17
3
8,000
8,000
020 Capital Improvement Fund
8,000
8,000
Village Warning Sirens
FD003.0-16
3
90,000
90,000
020 Capital Improvement Fund
90,000
90,000
Cardiac Monitors
FD004.0-16
2
250,000
250,000
020 Capital Improvement Fund
250,000
250,000
Fire Safety Trailer
FD005.0-16
3
75,000
75,000
020 Capital Improvement Fund
75,000
75,000
Powered EMS Stretchers & Stair Chairs
FD006.0-16
2
192,000
128,000
320,000
020 Capital Improvement Fund
192,000
128,000
320,000
SCBA facepieces
FD007.0-16
1
63,000
63,000
020 Capital Improvement Fund
63,000
63,000
Surface Supplied Air System
FD009.0-16
2
32,000
32,000
020 Capital Improvement Fund
32,000
32,000
Physical Fitness Treadmills
FD700.0-AN
2
12,500
12,500
001 General Fund
12.500
12.500
Fire Department Total
454,500 301,000 138,000 32,000
925,500
Information Technology
Target Solutions Training Software
ITFD001.0-17
2
7,000
7,000
001 General Fund
7,000
7,000
PSTrax System
ITFD002.0-17
3
9,800
9,800
001 General Fund
9,800
9,800
Tablets
ITFD003.0-17
2
1,800
1,800
001 General Fund
1,800
1,800
Instant Messaging
ITHS001.0-16
5
26,512
26,512
020 Capital Improvement Fund
26,512
26,512
New Human Services Software
ITHS001.0-17
1
3,240
3,240
2017-2021 Community Investment Program
Workshop - April 26, 2016 Page 48 of 53
Department
Project#
001 General Fund
2019
E-Citation and Billing Solution
ITPD001.0-17
020 Capital Improvement Fund
3,240
Coplogic Electronic Reporting Software
ITPD002.0-16
020 Capital Improvement Fund
3,240
License Plate Recognition (LPR)
ITPD004.0-16
020 Capital Improvement Fund
Customer Service Interface - Hansen-Vlg Website
ITPW001.0-16
001 General Fund
85,000
040 Refuse Fund
050 Water and Sewer Fund
85,000
GeoCortex Laserfiche Interface
ITPW002.0-16
001 General Fund
040 Refuse Fund
25,000
050 Water and Sewer Fund
25,000
Public Works Laptops
ITPW003.0-16
001 General Fund
25,000
050 Water and Sewer Fund
Increase Bandwidth to Outlying Fire Stations
ITVA002.0-16
020 Capital Improvement Fund
45,000
Microsoft Server Licenses
ITVA005.0-16
001 General Fund
SharePoint Online
ITVA006.0-16
001 General Fund
40,000
SEIM Managed Services
ITVA007.0-16
001 General Fund
40,000
Backup to Cloud
ITVA008.0-16
001 General Fund
Network Core Switch Upgrade
ITVA009-16
001 General Fund
15,000
Information Technology Total
Police Department
15,000
Administrative Section Renovation
PD001.0-16
020 Capital Improvement Fund
Roll Call and Kitchenette Renovation
PD002.0-16
020 Capital Improvement Fund
30,000
Lobby and Lobby Restrooms Renovation
PD003.0-16
020 Capital Improvement Fund
30,000
Evidence Lab Renovation
PD004.0-16
020 Capital Improvement Fund
Police Department Total
5,000
Public Works - Bual s
15,000
HVAC Upgrade Village Hall
PWB0001.0-16
020 Capital Improvement Fund
15,000
PW Fire Pump Replacement
PWB0001.0-17
020 Capital Improvement Fund
Public Safety Garage Sprinkler
PWB0002.0-16
020 Capital Improvement Fund
2,930
PW Fence Replacement
PWB0002.0-17
020 Capital Improvement Fund
3,930
Public Safety Parking Deck Maintenance
PWB0003.0-16
2017-2021 Community Investment Program
Priority
2017
2018
2019
2020 2021
Total
3,240
3,240
1
85,000
85,000
85,000
85,000
3
25,000
25,000
25,000
25,000
3
45,000
45,000
45,000
45,000
3
40,000
40,000
10,000
10,000
15,000
15,000
15,000
15,000
3
30,000
30,000
5,000
5,000
15,000
15,000
10,000
10,000
3
2,930
1,000
3,930
2,930
2,930
1,000
1,000
1
52,000
52,000
52,000
52,000
2
14,100
14,100
14,100
14,100
3
15,881
15,881
15,881
15,881
2
43,800
43,800
43,800
43,800
4
6,680
6,680
6,680
6,680
2
31,000
31,000
31,000
31,000
361,551
52,680
26,512
440,743
2
500,000
500,000
500,000
500,000
3
70,000
70,000
70,000
70,000
3
115,000
115,000
115,000
115,000
3
200,000
200,000
200,000
200,000
570,000
315,000
885,000
4
30,000 610,000
640,000
30,000 610,000
640,000
2
45,000
45,000
45,000
45,000
2
93,000
93,000
93,000
93,000
3
153,000
153,000
153,000
153,000
2
440,000
440,000
Workshop -April 26, 2016 Page 49 of 53
Department
Project#
051 Village Parking System Fund
135,000
Village Hall Domestic Booster Pump Replacement
PWB0003.0-17
020 Capital Improvement Fund
75,000
Public Safety Training Room Rehab
PWB0004.0-16
020 Capital Improvement Fund
45,000
Village Hall Flooring Improvements
PWB0004.0-17
020 Capital Improvement Fund
45,000
Public Safety Exterior Imp - Planter Bed Removal
PWB0005.0-16
020 Capital Improvement Fund
75,000
Public Safety Exterior Imp-Tuck-point & Power Wash
PWB0006.0-16
020 Capital Improvement Fund
75,000
Public Safety Exterior Imp-Window Replacement
PWB0007.0-16
020 Capital Improvement Fund
45,000
Fire Station #12 Apparatus Floor
PWB0008.0-16
020 Capital Improvement Fund
45,000
Fire Station #13 Apparatus Floor
PWB0009.0-16
020 Capital Improvement Fund
75,000
Fire Station #13 Bathrooms
PWBU010.0-16
020 Capital Improvement Fund
75,000
Public Works Facility Exterior
PWBU012.0-16
020 Capital Improvement Fund
175,000
Public Works Fire Alarm Upgrade
PWBU013.0-16
020 Capital Improvement Fund
Village Hall Window Replacement
PWBU014.0-16
020 Capital Improvement Fund
165,000
Other Public Buildings
PWBU800.0-AN
020 Capital Improvement Fund
165,000
HVAC Replacement Program
PWBU801.0-AN
020 Capital Improvement Fund
25,000
Public Works - Buildings Total
275,000
25,000
25,000
Public Works - Engineering
Emergency Vehicle Preemption System Replacement
PWEN002.0-16
001 General Fund
Northwest Hwy/Mount Prospect Road Bike Path
PWEN005.0-16
023 Street Improvement Construction Fund
Rand-Central-MP Road Study
PWEN006.0-16
001 General Fund
Rand-Elmhurst-Kensington Road Study
PWEN007.0-16
001 General Fund
Streetscape Improvements
PWEN008.0-16
022 Downtown Redevelopment Construction Fund
Traffic Signal Generator Connections
PWEN009.0-16
001 General Fund
Downtown Intersections Study
PWEN010.0-16
001 General Fund
Bridge Improvements - See Gwun Avenue
PWEN011.0.17
020 Capital Improvement Fund
Bridge Improvements - George Street
PWEN012.0.17
020 Capital Improvement Fund
Bridge Improvements - Emerson Street
PWEN013.0.17
020 Capital Improvement Fund
Bridge Improvements - Briarwood Drive West - South
PWEN014.0.17
2017-2021 Community Investment Program
Priority 2017 2018 2019 2020 2021
440,000
3
4
3
3
3
3
3
3
3
3
3
5
3
2
88,000
88,000
30,000
30,000
40,000
40,000
63,000
63,000
70,000
70,000
225,000
225,000
60,000
60,000
60,000
60,000
30,000
30,000
165,000
165,000
40,000
40,000
Total
440,000
63,000
63,000
88,000
88,000
70,000
70,000
255,000
255,000
100,000
100,000
230,000
230,000
45,000
45,000
75,000
75,000
105,000
105,000
275,000
275,000
38,000
38,000
30,000
30,000
755,000
755,000
390,000
390,000
603,000 846,000 390,000 530,000 1,521,000 3,890,000
3 135,000
230,000
135,000
135,000
230,000
3
75,000
75,000
45,000
2 200,000
400,000
45,000
400,000
2
75,000
400,000
200,000
75,000
2
200,000
45,000
200,000
3
45,000
255,000
200,000
75,000
2 200,000
200,000
75,000
38,000
400,000
3
175,000
38,000
175,000
100,000
160,000
165,000
165,000
100,000
160,000
165,000
165,000
25,000
275,000
25,000
25,000
25,000
275,000
25,000
25,000
63,000
63,000
70,000
70,000
225,000
225,000
60,000
60,000
60,000
60,000
30,000
30,000
165,000
165,000
40,000
40,000
Total
440,000
63,000
63,000
88,000
88,000
70,000
70,000
255,000
255,000
100,000
100,000
230,000
230,000
45,000
45,000
75,000
75,000
105,000
105,000
275,000
275,000
38,000
38,000
30,000
30,000
755,000
755,000
390,000
390,000
603,000 846,000 390,000 530,000 1,521,000 3,890,000
3 135,000
135,000
135,000
135,000
3
75,000
75,000
2 200,000
400,000
200,000
400,000
2
200,000
400,000
200,000
400,000
2
200,000
200,000
3
255,000
255,000
2 200,000
400,000
200,000
400,000
3
175,000
175,000
3
55,000
55,000
3
30,000
30,000
3
20.000
Workshop -April 26, 2016 Page 50 of 53
270,000
270,000
75,000
75,000
600,000
600,000
600,000
600,000
200,000
200,000
255,000
255,000
600,000
600,000
175,000
175,000
55,000
55,000
30,000
30,000
20,000
Department
Project#
020 Capital Improvement Fund
New Sidewalks
PWEN801.0-AN
001 General Fund
2
Sidewalk Cost Share Program
PWEN802.0-AN
001 General Fund
140,000
Street Improvement Program
PWEN803.0-AN
023 Street Improvement Construction Fund
160,000
041 Motor Fuel Tax Fund
210,000
Traffic Calming
PWEN804.0-AN
023 Street Improvement Construction Fund
3
Traffic Signal Replacement Engineering
PWEN805.0-AN
041 Motor Fuel Tax Fund
95,600
Public Works - Engineering Total
469,100
90,200
Public Works - Flood Control
McDonald Creek Bank Stabilization
PWFC001.0-16
024 Flood Control Construction Fund
469,100
Detention Pond Improvement- Pond 1
PWFC002.0-16
020 Capital Improvement Fund
4,532,000
Detention Pond Improvement - Pond 2
PWFC003.0-16
020 Capital Improvement Fund
Detention Pond Improvement- Pond 6
PWFC004.0-16
020 Capital Improvement Fund
4,012,000
Detention Pond Improvement - Pond 6A
PWFC005.0-16
020 Capital Improvement Fund
550,000
Detention Pond Improvement - Pond 8
PWFC006.0-16
020 Capital Improvement Fund
550,000
Weller Creek Silt Removal
PWFC009.0-16
024 Flood Control Construction Fund
50,000
Levee 37 Standby Emergency Generators
PWFC010.0-16
024 Flood Control Construction Fund
250,000
Storm Sewer Improvements - Park Drive
PWFC012.0-17
041 Motor Fuel Tax Fund
50,000
Neighborhood Drainage Improvements
PWFC800.0-AN
024 Flood Control Construction Fund
4
Storm Sewer Inspection Program
PWFC802.0-AN
024 Flood Control Construction Fund
50,000
Public Works - Flood Control Total
250,000
50,000
Public Works - Forest
Ash Replacement Plantings
PWF0001.0-16
001 General Fund
250,000
Ash Tree and Stump Removals
PWF0002.0-16
001 General Fund
5,790,800
Prospect Ave. Block Wall Construction
PWF0003.0-16
001 General Fund
2
Tree Planting Program
PWF0801.0-AN
001 General Fund
1,350,000
Public Works - Forestry Total
1,500,000
Public Works - Parkin
2017-2021 Community Investment Program
Priority 2017 2018 2019 2020 2021 Total
Workshop -April 26, 2016 Page 51 of 53
20,000
20,000
2
160,000
190,000
210,000
140,000
700,000
160,000
190,000
210,000
140,000
700,000
3
90,200
92,000
93,800
95,600
97,500
469,100
90,200
92,000
93,800
95,600
97,500
469,100
1
4,472,000
4,502,000
4,532,000
4,562,000
4,592,000
22,660,000
3,922,000
3,952,000
3,982,000
4,012,000
4,042,000
19,910,000
550,000
550,000
550,000
550,000
550,000
2,750,000
4
50,000
50,000
50,000
50,000
50,000
250,000
50,000
50,000
50,000
50,000
50,000
250,000
4
50,000
50,000
50,000
50,000
50,000
250,000
50,000
50,000
50,000
50,000
50,000
250,000
5,357,200
6,069,000
5,790,800
5,182,600
4,809,500
27,209,100
2
150,000
1,350,000
1,500,000
150,000
1,350,000
1,500,000
2
100,000
900,000
1,000,000
100,000
900,000
1,000,000
2
760,000
760,000
760,000
760,000
2
280,000
280,000
280,000
280,000
2
290,000
290,000
290,000
290,000
2
500,000
500,000
500,000
500,000
3
30,000
30,000
30,000
30,000
3
230,000
230,000
460,000
230,000
230,000
460,000
2
360,000
360,000
360,000
360,000
3
100,000
100,000
100,000
100,000
100,000
500,000
100,000
100,000
100,000
100,000
100,000
500,000
2
100,000
102,000
104,040
106,121
108,243
520,404
100,000
102,000
104,040
106,121
108,243
520,404
840,000
752,000
1,344,040
2,156,121
1,108,243
6,200,404
3
40,000
40,000
40,000
40,000
2
47,000
47,000
47,000
47,000
4
42,500
42,500
27,500
112,500
42,500
42,500
27,500
112,500
2
196,000
216,000
237,000
261,000
258,000
1,168,000
196,000
216,000
237,000
261,000
258,000
1,168,000
325,500
258,500
264,500
261,000
258,000
1,367,500
Workshop -April 26, 2016 Page 51 of 53
Department
Project#
Priority 2017 2018
Parking Lot Improvements - Fire Station 12
PWPA001.0-16
3 35,000
020 Capital Improvement Fund
Streetlight Improvements
35,000
Parking Lot Improvements - Well 17
PWPA002.0.17
3
020 Capital Improvement Fund
020 Capital Improvement Fund
75,000
Parking Lot Improvements - Wille St. Commuter Lot
PWPA003.0.17
3
020 Capital Improvement Fund
Public Works - Vehicle
Vehicle Lifts
Parking Lot Improvements - Train Station
PWPA004.0.17
3
020 Capital Improvement Fund
50,000
50,000
2019 2020 2021
10,000
10,000
40,000
40,000
Village Hall Parking Deck Maintenance PWPA800.0-AN 3 50,000 50,000 50,000 50,000
051 Village Parking System Fund 50,000 50,000 50,000 50,000
Village Hall Parking Deck Maintenance - Painting PWPA802.0-AN 3 100,000 100,000 100,000 100,000
051 Village Parking System Fund
185,000
Public Works - Parking Total
190,000
155,000
840,000
Public Works - Streets
Streetlight Improvements
PWST800.0-AN 3
020 Capital Improvement Fund
75,000
Streetlight Improvements LED Retrofits
PWST801.0-AN 4
020 Capital Improvement Fund
75,000
Public Works - Streets Total
75,000
375,000
80,000
Public Works - Vehicle
Vehicle Lifts
PWVE002.0-16 2
020 Capital Improvement Fund
200,000
Public Works - Vehicle Total
50,000
50,000
50,000
Public Works - Water/Sewer
Water Tank Rehabilitation - Reservoir 5E
PWWS001.0-17 2
050 Water and Sewer Fund
125,000
Televising Camera System Upgrades
PWWS002.0-16 3
050 Water and Sewer Fund
315,000
Lift Station Rehab - Cottonwood
PWWS002.0-17 3
050 Water and Sewer Fund
Water Tank Rehabilitation - Reservoir #11
PWWS003.0-17 1
050 Water and Sewer Fund
145,000
Water Facility Roof Rehab -Station #11
PWWS004.0-16 3
050 Water and Sewer Fund
70,000
Water Facility Roof Rehab -Station #16
PWWS005.0-16 3
050 Water and Sewer Fund
Water Tank Rehabilitation -Reservoir 5-N
PWWS006.0-16 2
050 Water and Sewer Fund
Wireless Telemetry System Remote Pressure Stations
PWWS008.0-16 2
050 Water and Sewer Fund
Wireless Telemetry System Upgrade -PLC Upgrades
PWWS009.0-16 1
050 Water and Sewer Fund
VFD Replacement
PWWS011.0-16 1
050 Water and Sewer Fund
Deep Well Rehabilitation - Well #16
PWWS012.0-16 2
050 Water and Sewer Fund
Deep Well Rehabilitation - Well #17
PWWS013.0-16 2
050 Water and Sewer Fund
2017-2021 Community Investment Program
Workshop -April 26, 2016
100,000 100,000 100,000 100,000
30,000
30,000
50,000
50,000
75,000
75,000
Total
35,000
35,000
10,000
10,000
40,000
40,000
30,000
30,000
250,000
250,000
475,000
475,000
150,000
185,000
160,000
190,000
155,000
840,000
75,000
75,000
75,000
75,000
75,000
375,000
75,000
75,000
75,000
75,000
75,000
375,000
80,000
50,000
50,000
50,000
50,000
200,000
50,000
50,000
50,000
50,000
200,000
75,000
125,000
125,000
125,000
125,000
575,000
315,000
140,000
145,000
285,000
315,000
140,000
145,000
285,000
70,000
140,000
145,000
285,000
Page 52 of 53
680,000
680,000
680,000
680,000
80,000
90,000
170,000
80,000
90,000
170,000
450,000
450,000
450,000
450,000
315,000
315,000
315,000
315,000
70,000
70,000
70,000
70,000
70,000
70,000
70,000
70,000
75,000
600,000
675,000
75,000
600,000
675,000
68,250
71,662
75,246
79,008
80,000
374,166
68,250
71,662
75,246
79,008
80,000
374,166
40,000
40,000
40,000
40,000
40,000
200,000
40,000
40,000
40,000
40,000
40,000
200,000
30,000
50,000
50,000
50,000
180,000
30,000
50,000
50,000
50,000
180,000
75,000
435,000
510,000
75,000
435,000
510,000
35,000
35,000
35,000
35,000
Page 52 of 53
Department
Project#
Priority
2017
2018
2019
2020
2021
Lift Relief Station Rehab - Louis Street
PWWS015.0-16
1
350,000
050 Water and Sewer Fund
350,000
Lift Relief Station Rehab - Huntington
PWWS017.0-16
3
650,000
050 Water and Sewer Fund
650,000
Lift Relief Station Rehab - Fairview
PWWS018.0-16
3
450,000
050 Water and Sewer Fund
450,000
Lift Relief Station Rehab - Lincoln Street
PWWS019.0-16
3
350,000
050 Water and Sewer Fund
350,000
Water Main Replacement
PWWS800.0-AN
1
650,000
650,000
4,900,000
4,900,000
4,900,000
050 Water and Sewer Fund
650,000
650,000
4,900,000
4,900,000
4,900,000
Sewer Main Rehabilitation
PWWS801.0-AN
2
550,000
550,000
1,000,000
1,000,000
1,000,000
050 Water and Sewer Fund
550,000
550,000
1,000,000
1,000,000
1,000,000
Booster Station Pump Rehabilitation
PWWS803.0-AN
2
55,000
60,000
60,000
60,000
65,000
050 Water and Sewer Fund
55,000
60,000
60,000
60,000
65,000
Combined Sewer Improvements
PWWS804.0-AN
1
800,000
800,000
800,000
800,000
800,000
050 Water and Sewer Fund
Public Works - Water/Sewer Total
Village Administration
Playback System Upgrade to HD VA001.0-16
020 Capital Improvement Fund
Replacement Switcher for TV Services Control Room VA002.0.16
020 Capital Improvement Fund
Village Administration Total
GRAND TOTAL
2017-2021 Community Investment Program
800,000 800,000 800,000 800,000 800,000
2,978,250 3,086,662 8,730,246 7,714,008 7,420,000
Total
350,000
350,000
650,000
650,000
450,000
450,000
350,000
350,000
16, 000, 000
16,000,000
4,100,000
4,100,000
300,000
300,000
4,000,000
4,000,000
29,929,166
3 35,650 35,650
35,650 35,650
3 25,000 25,000
25,000 25,000
60,650 60,650
11,705,651 12,885,842 17,729,098 16,490,729 15,396,743 74,208,063
Workshop -April 26, 2016 Page 53 of 53