2012-09-24 - Village Board Committee of the Whole - Agenda Packet Meeting of the Village of Buffalo Grove Fifty Raupp Blvd
� Buffalo Grove, I L 60089-2100
Board of Trustees Phone:847-459-2500
Committee of the Whole
September 24, 2012 at 6:45 PM
1. Welcome
2. Discussion
A. 2013-2017 Capital Improvement Plan Initial Report [GO TO]
B. FY 2012 Property Tax Levy- Preliminary Discussion [GO TO]
C. 2013 General Wage Adjustment Recommendation [GO TO]
D. 2013 Employee Medical, Dental and Life Insurance Premium Recommendations [GO TO]
E. Golf Course Financials for January 1, 2012 through August 31, 2012 [GO TO]
F. 2012 Budgetary Goal Progress [GO TO]
3. Executive Session
A. Sale or Lease of Real Estate: Section 2(c)(6)of the Illinois Open Meetings Act
4. Adjournment
The Village of Buffalo Grove,in compliance with the Americans with Disabilities Act,requests that persons with disabilities, who require certain
accommodations to allow them to observe and/or participate in this meeting or have questions about the accessibility of the meeting or facilities, contact
the ADA Coordinator at 459-2525 to allow the Village to make reasonable accommodations for those persons.
2013-2017 Capital Improvement Plan Initial Report 2-A
Overview
Staff will provide an update on the 2013-2017 Capital Improvement Plan by providing an overview of the
preliminary requests received during the 2013 budget cycle. A full report is attached.
Attachments
2013 CIP Request Report(091712).pdf
Trustee Liaison Staff Contact
Michael K Skibbe,
....M.on.da...........Se......ptem.be.r..24......2.0.1..2...........................................................................................D.'sc uss.'.o.n...._...Ite.m........2._A.......................................................................................................................................................
Y,
OF
TO: DANE C. BRAGG
FROM: MICHAEL K. SKIBBE
SUBJECT: 2013-2017 CIP PLANNING DOCUMENT
DATE: 9/20/2012
CC: SCOTT D. ANDERSON
............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
The attached 2013-2017 Capital Improvement Plan, 2013 Budget Cycle Preliminary Requests
document contains all projects identified as part of the update of the Village's Capital
Improvement Plan for the five-year period beginning January 1, 2013 and ending December
31, 2017. Pending Village Board approval, those projects identified for FY 2013 will be
incorporated into the upcoming annual operating budget and will be reviewed again during
the formal budget presentation. The Capital Improvement Plan is intended to be a decision-
making tool for both staff and the Village Board to weigh the operational need for capital
requests against the ability of the Village to finance those projects. The Board's approval of
the CIP does not authorize spending until those projects are (1) approved for the current
year's budget(2) authorization is provided to staff to formally bid the project(3)the board
approves the bid(4) the bid is consistent with the budget and identified funding is available.
Staff Review Process
Staff has reviewed each submittal. As a part of the review, each project is evaluated using a
CIP Evaluation Form (see attachment). The evaluation form measures, through numerical
ranking, the merits of a project relative to specific criteria. The sum of the individual scores is
then posted to establish a priority rating.
The highest possible score for any specific project would be 26. There are thirteen different
criteria upon which a project is reviewed. The intent of the grade is to provide a decision
guide for prioritizing projects. Every year each individual project is revisited and changes in
priority made, as conditions warrant, that reflect the current environment. In addition, the
process will include a mid-year status evaluation of each approved budgeted project in order
to gauge construction progress and it shall also serve to initiate the cycle for the next five-year
program update.
Although 21 CIP requests were received for the 2013-2017 planning period, staff has elected
to place three projects on hold. The PSC Expansion ($4,227,275), Police Department
Skylight Replacement($107,320), and Council Chambers Audio/Visual Upgrades ($65,000)
were not included in the planning document because of the possible relocation of the Village
Campus due to redevelopment.
Page 1 of 6
Thus, there are a total of 18 projects noted over the plan period with particular emphasis
placed on the 17 which include FY 2013 expenditures. 10 of those are either a carry-over with
a revised scope of work or continuation from prior years, but 7 are new projects:
Police Headquarters Jail Interlock Upgrade
Replacement Antenna Tower—Fire Station 27
Villagewide Storm Sewer Repair Program
Document Management Solution
GIS Consortium
Public Works Software/Database Upgrades
Upgrade Wireless Network—Building to Building
All projects identified for FY 2013 total $9,150,333 and are divided into five categories.
Buildings and GroundsImprovements
There are 3 projects in this category totaling $117,441 for FY 2013. The Municipal Parking
Facility Maintenance program is ongoing, with a revised scope for FY 2013 covering planned
maintenance at the Public Service Center, Pace/Metra, and 4 well houses. The Police
Department Jail Control would provide an updated jail door interlock to replace troubled
existing equipment. Finally, the Replacement Antenna Tower at Fire Station 427 would
replace a tower that is undersized for the type and number of antennas currently needed.
Street, Sidewalk & Bikepath Maintenance
Street maintenance and construction improvement programs total $6,635,452. One project is
the ongoing Annual Sidewalk/Bike Path Maintenance program. Work also continues on the
Weiland Road/Prairie Road Street Improvement that will be reimbursed for 83% of eligible
expenditures by the Lake County Department of Transportation, and improvements to the
streetscape along Dundee Road. Finally, the Raupp Bridge Reconstruction is also planned for
the 2013 construction season.
Within the Motor Fuel Tax Fund, the projects involve traditional maintenance and
rehabilitation of local streets based upon a defined service life that is designed to maintain
quality surface conditions and avoid more significant roadway rebuilds that would be the
result of pushing the maintenance schedules out further in time. The majority of work to be
performed during the 2013 construction season will be for the rehabilitation of street surface
and curb/gutter along various identified local streets. Those streets identified for work in FY
2013 are noted in the summary sheet for this category in the planning document. The total
cost for the first year of the five year plan is $5,950,000 to be covered by the Village's
percentage of the State's Motor Fuel Tax, bond proceeds, and a portion of home rule sales tax.
The scope for 2013 is very large due to past years of deferred maintenance.
Page 2 of 6
Storm Sewer System
A new request this year sets up an ongoing maintenance program for the Village's Storm
Sewer System. Defects which are identified through our annual sewer televising program are
prioritized and scheduled for repair either through inhouse PW staff or through outside
contractual assistance. Initial estimates put the list of identified defects at$500,000, but staff
suggests that$300,000 be budgeted for FY 2013 to repair priority locations this year, while
establishing a program to perform storm sewer maintenance every other year opposite the
sanitary sewer maintenance program moving forward.
Unlike the Water and Sewer Fund, the storm sewer system does not have a direct revenue
stream to fund these repairs. Significant financial planning will be necessary to address this
network of 180 miles of pipe as infrastructure continues to age.
Technology is a new category in this year's CIP planning document and recognizes the
Village's key goal of utilizing technology to provide efficient service in the most cost
effective means possible.
The Villagewide implementation of a Document Management Solution is underway, and the
Information Technology (IT) department is requesting $45,000 to further deploy the
necessary digital equipment and scanners to support initiatives like the new financial software
and Laserfische digital document storage.
IT is also requesting $54,000 to upgrade the wireless network from building to building.
Several sites outside the Village Campus are linked to the network via wireless equipment
including all three Fire Houses,pumping facilities, and the Arboretum Golf Course. As more
and more data traffic is pushed through these conduits, IT believes an upgrade to the 5 year
old network is necessary at this time.
Public Works is also requesting funding for two technology programs. Staff is proposing to
join the GIS Consortium in 2013. The consortium represents a group of nearby communities
which are pooling resources to establish Geographical Information Systems (GIS)programs
without having to fund a full staff in house. The ability to scale staffing levels to fit our
needs, without having to hire a range of programmers, directors, and GIS technicians in
house, can provide significant cost savings while still implementing a top-notch GIS program
that would benefit all departments in the Village. The FY 2013 cost would be $153,000.
Second, PW is requesting funding for Public Works Software/Database Upgrades. Due to the
decreased size of an already lean Public Works Department, efficiencies in daily activities
need to be realized. The current Lotus Notes system of non-integrated databases is inefficient
because the same data is being entered multiple times in multiple locations. A
software/database upgrade from a company specializing in Public Works Computerized
Maintenance Management Systems (CMMS)would allow the technology to streamline
processes for everyone from the Resident looking to submit a service request, to a PW
employee closing out work orders, to a Supervisor tracking unit costs on the back end. The
FY 2013 cost would be $33,125.
Page 3 of 6
Water Main & SanitarySystems
Within the Water and Sewer system,projects total $1,812,318. An IEPA Wastewater
Pollution Control Loan is currently being lined up to fund the Lift Station Repair&
Rehabilitation project for repairs and upgrades at Old Treatment Plant and Cambridge on the
Lake Lift Stations. While the project is expected to begin in 2012, expenditures will likely
carry over into 2013. Also, Raupp Lift Station is under engineering design and would be
moved forward to construction in FY 2013. The total for the Lift Station Repair &
Rehabilitation program is $780,000 for 2013.
The other component of the Water and Sewer system requests includes Pump House Repairs
and Security Improvements and SCADA Improvements at$610,318 and $77,000
respectively. An IEPA Water Supply Loan has been allocated for the Pump House Repairs
and Security Improvement portions, but depending on the loan percentage finalized for the
IEPA Wastewater Loan, Staff may suggest that this project be funded from the revolving line
of credit instead.
Finally in this category, $345,000 is requested for the ongoing Villagewide Water Main
Replacement program. While the original request, covering rehabilitation of three separate
water mains, was proposed at$1.2M, staff has elected to push two locations to FY 2014 in
order to allow changes in the water rates to replenish depleted reserves. The priority location
scheduled for FY 2013 is proposed to use cutting edge water main lining rehabilitation
through the use of cured in place pipe (CIPP). The use of CIPP will reduce the amount of
money spent engineering the project up front, minimize the disturbance of the neighborhood
compared to open trench replacement, and provide a comparable service life to new ductile
iron pipe replacement.
CIP Planning Document
Included in the 2013-2017 CIP document, are tables that establish a historical reference point
on the progress of identified projects by showing the past five years of expenditures for each
program. In order to maintain adequate perspective on total project costs,projects requiring
multi-year funding are noted and the total estimated project costs through completion will be
listed along with the estimated costs to be incurred for the specific year. This shall not apply
to multi-year programs that have a different annual work element defined by specific
organizational needs, such as the maintenance projects.
The CIP Request Summary Table below shows totals by fiscal period for each proposed
project. The five-year summary shows that$37,846,915 is projected for Village capital
improvements through FY 2017.
Page 4 of 6
2013 Budget Cycle
CIP Request Summary Table
2013 2014 2015 2016 2017
Buildings and Grounds Improvements
Municipal Parking Facility Maintenance $74,100 $91,000 $218,000 $169,000 $49,000
Police Department Jail Control $27,341 - - - -
Police Department Skylights($107,320) On Hold - - - -
PSC Expansion ($4,227,275) On Hold - - - -
Replacement Antenna Tower FS#27 $16,000 - - - -
Subtotal $117,441 $91,000 $218,000 $169,000 $49,000
Street,Sidewalk&Bikepath Maintenance
Annual Street Maintenance $5,950,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000
Dundee Road Streetscape $60,000 - - - -
Raupp Bridge Reconstruction $200,000 $200,000 - - -
Annual Sidewalk/Bike Path Maintenance $325,000 $325,000 $325,000 $325,000 $325,000
Weiland Road/Prairie Road Improvements $100,452 - - - -
Subtotal $6,635,452 $5,525,000 $5,325,000 $5,325,000 $5,325,000
Storm Sewer System
Villagewide Storm Sewer Repair $300,000 - $300,000 - $300,000
Subtotal $300,000 $0 $300,000 $0 $300,000
Technology
Audio/Visual Council Chambers($65,000) On Hold - - - -
Document Management Solution $45,000 - - - -
GIS Consortium $152,997 $141,512 $148,143 $154,855 $162,372
Public Works Software $33,125 $4,500 $4,500 $4,500 $4,500
Upgrade Wireless Network $54,000 - - - -
Subtotal $285,122 $146,012 $152,643 $159,355 $166,872
Water Main&Sanitary Sewer Systems
Lift Station Repair& Rehabilitation $780,000 $530,000 $300,000 $300,000 $300,000
Pump House Repairs&Security Improvements $610,318 - - - -
Scada Improvements $77,000 $85,800 $103,400 $66,000 -
Villagewide Sanitary Sewer Replacement $0 $700,000 - $700,000 -
Villagewide Water Main Replacement $345,000 $959,500 $700,000 - $700,000
Subtotal $1,812,318 $2,275,300 $1,103,400 $1,066,000 $1,000,000
Total $9,150,333 $8,037,312 $7,099,043 $6,719,355 $6,840,872
Grand Total 2013-2017 $37,846,915
Page 5 of 6
In closing, the Capital Improvement Plan will be presented for review, comment and
consideration by the President and Board of Trustees at the Committee of the Whole meeting
on Monday, September 24, 2012. Ideally, the Village Board will authorize staff to move
forward for formal acceptance of the Plan update on November 5, 2012, in order to permit
integration of those first-year projects into the FY 2013 budgets.
Michael K. Skibbe
Civil Engineer
Page 6 of 6
9/17/2012
2013-2017 Capital Improvement Plan
2013 Budget Cycle
Preliminary Requests
VILLAGE OF BUFFALO GROVE
Public Works Department
Mike Skibbe, Civil Engineer
Village of Buffalo Grove 1 2013-2017 CIP Planning Document
Table of Contents
Tableof Contents..........................................................................................................................................2
Capital Improvement Summary....................................................................................................................3
Buildings &Grounds Improvements.............................................................................................................5
Municipal Parking Facility Maintenance...................................................................................................6
Police Headquarter Jail Interlock Upgrade...............................................................................................7
Replacement Antenna Tower- Fire Station 27.........................................................................................8
Street, Sidewalk& Bikepath Maintenance...................................................................................................9
Annual Street Maintenance....................................................................................................................10
Dundee Road Streetscape Improvement................................................................................................11
Raupp Boulevard Bridge Reconstruction................................................................................................12
Annual Sidewalk/Bike Path Maintenance...............................................................................................13
Weiland Road/Prairie Road Improvement .............................................................................................14
StormSewer System...................................................................................................................................15
Villagewide Storm Sewer Repair Program..............................................................................................16
Technology..................................................................................................................................................17
Document Management Solution...........................................................................................................18
GISConsortium .......................................................................................................................................19
Public Works Software/Database Upgrades...........................................................................................20
Upgrade Wireless Network- Building to Building ..................................................................................21
Water Main &Sanitary Sewer Systems......................................................................................................22
Lift Station Repair& Rehabilitation Program .........................................................................................23
Pump House &Security Improvements..................................................................................................24
SCADAImprovements.............................................................................................................................25
Villagewide Sanitary Sewer Replacement Program................................................................................26
Villagewide Water Main Replacement Program ....................................................................................27
Criteria List and Scoring Matrix...................................................................................................................28
Village of Buffalo Grove 2 2013-2017 CIP Planning Document
Capital Improvement Summary
The Capital Improvement Plan (CIP) is intended to be a decision-making tool for the Village Board and staff. The
operational need for capital expenditures must be weighed against the ability of the Village to finance these
projects. Capital improvement projects represent the equipment and infrastructure resources that all
municipalities need to provide resident and business services and generally provide future benefits with long
service life. A capital expenditure is incurred when the Village spends money to buy fixed assets or add value to an
existing fixed asset.
The Village Board's approval of the CIP does not authorize spending on the included projects. Each project must
still be accepted for the current year's budget. Projects must then go through the procurement process including
Board authorization to bid and Board award of bid. This insures that the project remains consistent with the
budget and that identified funding is available at the time of award.
Staff has reviewed each project and evaluated the project using the CIP Evaluation Form (see attachment). The
evaluation form measures, numerically,the merits of the project based on specific criteria. The sum of the
individual scores is then used to establish a priority rating. The highest possible score is 26. There are thirteen
criteria used to review projects. Each project is revisited yearly and changes in priority are made as current
conditions warrant. In addition,the process includes a mid-year status evaluation of each approved budgeted
project in order to gauge construction progress and initiate the cycle for the next five-year program update.
The proposed capital projects have no significant financial impact on current and future years'operating budgets.
Any additional maintenance will be minimal and there are no anticipated savings or revenues expected to result
from these projects. The non-financial impacts of these projects include improved access to bike paths,safer
streets, improved aesthetics,and improved customer service for residents.
Projects identified for FY 2012 total$9,150,333 and fall under five categories. The following chart illustrates each
category's percentage as it relates to funding the capital program for FY 2013.
Capital Expenditures by Category
1%
3% M Buildings and Grounds
3% Street,Sidewalk&Bikepath
03 Storm Sewer System
IBITechnology
03 Water Main&Sanitary Sewer
Village of Buffalo Grove 3 2013-2017 CIP Planning Document
2013 Capital Projects Summary Table
2013 Request
Buildings and Grounds Improvements
Municipal Parking Facility Maintenance $74,100
Police Department Jail Control $27,341
Police Department Skylights ($107,320)t On Hold
PSC Expansion ($4,227,275) t On Hold
Replacement Antenna Tower FS#27 $16,000
Subtotal $117,441
Street,Sidewalk& Bikepath Maintenance
Annual Street Maintenance $5,950,000
Dundee Road Streetscape $60,000
Raupp Bridge Reconstruction $200,000
Annual Sidewalk/Bike Path Maintenance $325,000
Weiland Road/Prairie Road Improvements $100,452
Subtotal $6,635,452
Storm Sewer System
Villagewide Storm Sewer Repair $300,000
Subtotal $300,000
Technology
Audio/Visual Council Chambers ($65,000)t On Hold
Document Management Solution $45,000
GIS Consortium $152,997
Public Works Software $33,125
Upgrade Wireless Network $54,000
Subtotal $285,122
Water Main &Sanitary Sewer Systems
Lift Station Repair& Rehabilitation $780,000
Pump House Repairs &Security Improvements $610,318
SCADA Improvements $77,000
Villagewide Sanitary Sewer Replacement* $0
Villagewide Water Main Replacement $345,000
Subtotal $1,812,318
Grand Total $9,150,333
t While staff has elected to defer several items,they are noted here with the projected costs but put'On Hold'and not included
in the 2013 CIP Request Summary total.
*2013 is an off year for Villagewide Sanitary Sewer Replacement, but expenditures are included in the item summary for out
years within the 2013-2017 CIP period.
Village of Buffalo Grove 4 2013-2017 CIP Planning Document
Buildings & Grounds Improvements
The Village is responsible for maintaining 23 structures within its corporate boundaries. Village buildings
and grounds must be maintained regularly to remain functional. Village facilities must also periodically
be upgraded to ensure efficient operations. Expenditures in this category historically include projects
that:
• Maintain the safety and appearance of Village owned property
• Maximize the life of facilities
• Maintain value of facilities through preventative maintenance before they become more
expensive to repair.
• Insure that any issues affecting health and safety of building occupants are promptly
addressed.
The Village's facilities include:
• Village Hall
• Public Service Center&Salt Dome
• Police Department
• Fire Station Admin, Stations 25, 26, & 27, Fire Training Facility and Classroom Trailer
• Pump Stations 1, 2, 6, &7
• BGGC &Arboretum Clubhouses, Halfway Houses, and Maintenance Buildings
• Train Station and Warming Shelters
• Youth Center
Village of Buffalo Grove 5 2013-2017 CIP Planning Document
Municipal Parking Facility Maintenance
gill
Category: Buildings & Grounds Improvements
Fund: Capital Projects - Facilities
Account Number: 150.75.560.40
Priority Score: 16
Initial Proposal Date: Ongoing
Project Coordinator: PW-Engineering
wmimYP'm➢1�r➢nlnrgrvSMrrywDMM7mfiY�N,YMrry�i lrNlcr.MyP'.�Y➢phirrylmlm➢DN➢UN5 r➢phirrylmf9➢UPfi:1NnI rYrhrgnM^MNSN➢U�Y r➢nlfl Irohi^M�MpP' 1.
Summary: This program provides for the routine sealing, restriping, and reconstruction of
municipal lots. The 2013 planned maintenance includes lots at the Public Service
Center, Pace/Metra, and Well Houses 1, 2, 6&7.
Budget Impact: This project is funded through the General Fund's operating revenues.
Estimated
Budgeted Amount FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$42,750 $43,000 $359,000 $48,000 $65,000 $557,750
Actual $35,317 $47,327 $54,700 $50,000 $65,000 $252,344
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering
Construction $74,100 $91,000 $218,000 $169,000 $49,000 $601,100
Equipment
Contingency
Sub-Total $74,100 $91,000 $218,000 $169,000 $49,000 $601,100
Village of Buffalo Grove 6 2013-2017 CIP Planning Document
Police Headquarter Jail Interlock Upgrade
Category: Buildings & Grounds Improvements
Fund: Capital Projects - Facilities
Account Number: 150.75.560.50
Priority Score: 10
Initial Proposal Date: 2013
Project Coordinator: Police
Summary: The door control interlock system for the jail has failed on several occasions. The
system and parts have not been manufacturer in more than 10 years causing
extreme difficulty in obtaining repair parts. This system is governed and inspected by
the Illinois Department of Corrections.
Budget Impact: This project is funded through an internal transfer from the General Fund's operating
revenues.
Estimated
Budgeted Amount
FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Actual $ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Expenditures
�.
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering
Construction $27,341 - - - - $27,341
Equipment
Contingency
Sub-Total $27,341 - - - - $27,341
Village of Buffalo Grove 7 2013-2017 CIP Planning Document
Replacement Antenna Tower - Fire Station 27
Category: Information Technology
Fund: Capital Projects— Facilities
Account Number: 150.75.560.50
Priority Score: 21
Initial Proposal Date: 2012
Project Coordinator: PW-Engineering
+7M1^lA%C'aP➢I1nnbWnmin�1^I^M PP➢IIAPA M4rii PIA iW%MMlml%rlialiwn'
Summary: This project will replace the antenna structure at Fire Station 27 that was installed in
1991.The current tower is undersized for the type and number of antennas currently
mounted.
Budget Impact: This project is funded through an internal transfer from the General Fund's operating
revenues.
EMEMEM
Estimated
Budgeted Amount
FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Actual $ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering $4,000 - - - - $4,000
Construction $8,000 - - - - $8,000
Equipment $4,000 - - - - $4,000
Contingency
Sub-Total $16,000 - - - - $16,000
Village of Buffalo Grove 8 2013-2017 CIP Planning Document
Street, Sidewalk & Bikepath Maintenance
The Village roadway network is comprised of state, county, and municipal roadways. Each roadway
carries with it a function such as arterial, collector or local streets. The break-down is as follows:
Municipal Roadways 117.70 miles
State Roadways 8.95 miles
Cook County Roadways 7.25 miles
Lake County Roadways 10.82 miles
Total 144.72 miles
Municipal Roadways are evaluated every five years and recommendations for the next five years of
street projects are developed. The projects involve traditional maintenance and rehabilitation of local
streets based upon a defined service life. The defined service life is designed to maintain quality surface
conditions and avoid more costly roadway rebuilds. Due to funding issues, since 2008 not all streets
identified for maintenance have been repaired. Cuts in the program were necessary given the current
economic climate and funding limitation both internally, and from the State of Illinois. The majority of
work to be performed during the 2013 construction season will be for the rehabilitation of street surface
and curb/gutter along various identified local streets.
The following streets are scheduled for repair in 2013:
Highland Grove Drive 0.77 Cobblestone Court 0.05 Meridian Way 0.12
Somerset Lane 0.19 Aberdeen Lane 0.16 Olive Hill Drive 0.29
Sunridge Lane 0.20 Aberdeen Court 0.04 Jordan Terrace 0.32
Wakefield Lane 0.13 Highland Grove Ct S. 0.03 Wright Boulevard 0.14
Wakefield Court 0.05 Woodridge Lane 0.13 Bank Lane 0.07
Pinehurst Lane 0.19 Chevy Chase Drive 0.35 Woodstone Drive 0.15
Fox Hill Drive 0.33 Columbus Parkway 0.21 Woodstone Court 0.09
Fox Court East 0.05 Prague Avenue 0.28 Brunswick Drive 0.08
Fox Court West 0.06 Marquette Place 0.14 Johnson Drive 1.52
Dunhill Drive 0.43 Linden Avenue 0.31 Hastings Lane/Drive 0.55
Newtown Court West 0.19 Buckingham Lane 0.20 Willow Parkway 1.50
Newtown Court East 0.05 Woodbury Road 0.07
Cobblestone Lane 0.26 Thorndale Drive 0.38 TOTAL 10.08
The Village of Buffalo Grove recognizes the need to have a network of pedestrian and mixed-use paths
throughout the community. The Village currently maintains 224 miles of concrete sidewalks and
bikeways. The Village actively pursues grant funding to expand or improve the current system and has
created an ad-hoc bike path committee to develop suggestions for future improvements
Village of Buffalo Grove 9 2013-2017 CIP Planning Document
Annual Street Maintenance
Category: Street, Sidewalk & Bike Path Maintenance
Fund: Motor Fuel Tax
Account Number: 130.75.560.20
Priority Score: 19
Initial Proposal Date: Ongoing
Project Coordinator: PW-Engineering
'nmm�,roea,inn,aarrn,�i,�ii�,,,aarrin,mimiimii,aarrn,memmniroanmin,aeanrw,memmmfl;roar,in,aea,n,aw,.✓n'.
Summary: The annual street maintenance and rehabilitation program is covered in each year's
CIP. In 2013, the Village is also scheduled to perform a complete pavement
evaluation study of all Village streets. This study will help plan the next five years of
street maintenance and is reflected in the FY 2013 Projected Expenditures below.
Budget Impact: The Village's percentage of the State's Motor Fuel Tax, bond proceeds, and a portion
of home rule sales tax fund this project.
EMEMEM
Estimated
Budgeted Amount FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$2,990,000 $2,300,000 $2,679,045 $1,750,000 $1,700,000 $11,419,045
Actual $2 914,130 $2,243,128 $1,512,258 $1,207,750 $3,408,226 $11,285,492
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering $475,000 $425,000 $425,000 $425,000 $425,000 $2,175,000
Construction $5,475,000 $4,575,000 $4,575,000 $4,575,000 $4,575,000 $23,775,000
Equipment
Contingency
Sub-Total $5,950,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 25,950,000
Village of Buffalo Grove 10 2013-2017 CIP Planning Document
Dundee Road Streetscape Improvement
Category: Street, Sidewalk & Bike Path Maintenance
Fund: Capital Projects -Streets
Account Number: 160.75.560.20
F�
Priority Score: 19
a
� Initial Proposal Date: 2009
d! Project Coordinator: PW-Engineering
°wnn,�J.°+%'9W1°'9W1°'9W1°'9Wm���iwiwlalalalalalaiwiwfiWiiwiwiwiwiV9,�1 mmmmmmmmmWlalaIDJ'�J.°+%'9W1°'9W1°'9W1°'9
Summary: This project includes installation of sidewalk and multi-use path along the Dundee
Road corridor. The proposed sidewalk locations were selected to complete bike
routes already in place along Dundee Road, provide access to schools, heavy
commercial districts and numerous town parks.
This project was included on IDOT's August 3, 2012 Letting. It is anticipated that
construction will be substantially complete in 2012 but restoration and project close-
out will likely carry over into 2013.
Budget Impact: This project is funded through an internal transfer from the General Fund's operating
revenues.
EMEMEM
Estimated
Budgeted Amount
FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $16,000 $650,211 $634,212 $101,013 $1,401,436
Actual $ 0 $ 0 $ 0 $ 0 $50,000 $50,000
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering
Construction $60,000 - - - - $60,000
Equipment
Contingency
Sub-Total $60,000 - - - - $60,000
Village of Buffalo Grove 11 2013-2017 CIP Planning Document
Raupp Boulevard Bridge Reconstruction
Category: Street, Sidewalk & Bike Path Maintenance
Fund: Capital Projects - Facilities
Account Number: 150.75.560.30
Priority Score: 19
Initial Proposal Date: 2011
Project Coordinator: PW-Engineering
�aonmanu,nmanwmnmanwmnmar¢mrvpr¢wn�m?�m?�mn�mn�nur��aanunarwmnm�nmmuamar¢inar¢wionu'
Summary: This project covers the evaluation and subsequent design and construction of needed
improvements to the Raupp Boulevard Bridge. Phase I design engineering is
scheduled to be completed in 2012 with Phase 11 ready to begin in 2013. Significant
funding (80%) is provided by the Highway Bridge Replacement and
Rehabilitation Program administered by the USDOT Federal Highway
Administration.
Budget Impact: This project is funded through an internal transfer from the General Fund's operating
revenues.
EMEMEM
Estimated
Budgeted Amount FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $ 0 $ 0 $23,000 $32,000 $55,000
Actual $ 0 $ 0 $ 0 $41,469 ($19,524) $21,945
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land $10,000 - - - - $10,000
Engineering $160,000 - - - - $160,000
Construction $830,000 - - - - $830,000
Equipment
Contingency ($800,000) - - - - ($800,000)
Sub-Total $200,000 - - - - $200,000
Village of Buffalo Grove 12 2013-2017 CIP Planning Document
Annual Sidewalk/Bike Path Maintenance
Category: Street, Sidewalk & Bikepath Maintenance
Fund: General Fund
Account Number: 100.55.10.535.05
r r Priority Score: 20
Initial Proposal Date: Ongoing
Project Coordinator: PW- Engineering
Summary: Annual sidewalk and bike path maintenance and rehabilitation program.
Budget Impact: This project is funded through an internal transfer from the General Fund's operating
revenues.
EMEMEM
Estimated
Budgeted Amount FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$250,000 $150,000 $150,000 $150,000 $325,000 $1,025,000
Actual $255,759 $148,926 $142,902 $149,964 $325,000 $1,022,551
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering
Construction $325,000 $325,000 $325,000 $325,000 $325,000 $1,625,000
Equipment
Contingency
Sub-Total $325,000 $325,000 $325,000 $325,000 $325,000 $1,625,000
Village of Buffalo Grove 13 2013-2017 CIP Planning Document
Weiland Road/Prairie Road Improvement
Category: Street, Sidewalk & Bike Path Maintenance
Fund: Capital Projects -Streets
Account Number: 160.75.560.20
Priority Score: 25
Initial Proposal Date: 2008
y Project Coordinator: PW-Engineering
Summary: Lake County Department of Transportation is to provide a percentage
reimbursement of the original full study cost after completion of the Weiland
Road/Prairie Road portion of the Phase I Study. The Cook County Highway
Department is paying 100% of the supplemental expenses which result from
expanding the study along the Lake Cook Road Corridor. The remaining expenditures
are being funded through an internal transfer from the General Fund.
Budget Impact: This project is funded through an internal transfer from the General Fund's operating
revenues.
EMEMEM
Estimated
Budgeted Amount
FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$884,104 $640,000 $496,390 $335,633 $234,054 $2,590,181
Actual ($141,377) $356,448 $361,579 $136,255 $163,902 $876,807
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering $100,452 - - - - $100,452
Construction
Equipment
Contingency
Sub-Total $100,452 - - - - $100,452
Village of Buffalo Grove 14 2013-2017 CIP Planning Document
Storm Sewer System
The Village of Buffalo Grove maintains a piped network of 180 miles of storm sewer and one storm
water lift station at Jackson Drive. While most periodic maintenance and cleaning efforts are included in
the Public Works Drainage Section operating budget, system repairs are being included in the CIP due to
the size and scope of necessary repairs.
Repair locations are identified through the annual Storm Sewer Televising program. The program allows
a televised inspection of 5%of the Village's storm sewers each year. Tapes are then reviewed by
Engineering staff and repair recommendations are grouped by point repair, sewer lining, or pipe
replacement.
In the past, most Storm Sewer repairs have been handled by in-house Public Works staff or in
conjunction with scheduled street maintenance. But, as infrastructure ages, the list of identified repairs
has increased. A contractual repair contract will be necessary in 2013 and repairs will be addressed in
order of priority.
It is anticipated that the storm sewer system repair program will be an ongoing need. The storm repairs
are being scheduled every other year, opposite of the sanitary sewer repair program.
Village of Buffalo Grove 15 2013-2017 CIP Planning Document
Villagewide Storm Sewer Repair Program
..G
Category: Storm Sewer
Fund: General
Account Number: TBD
1/;d1
Priority Score: 14
Initial Proposal Date: 2013
Project Coordinator: PW-Engineering
Summary: This program provides for storm sewer lining, point repairs, or replacements at
priority locations. The locations are identified through the Annual Storm Sewer
Televising Inspection Program. The Storm Sewer Repair Program is scheduled for
alternating years, opposite of the Sanitary Sewer program.
Budget Impact: This project is funded through an internal transfer from the General Fund's operating
revenues.
EMEMEM
Estimated
Budgeted Amount
FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Actual $ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering
Construction $300,000 - $300,000 - $300,000 $900,000
Equipment
Contingency
Sub-Total $300,000 - $300,000 - $300,000 $900,000
Village of Buffalo Grove 16 2013-2017 CIP Planning Document
Technology
The Village of Buffalo Grove's Information Technology(IT) staff is responsible for maintenance of local
and wide area networks that facilitate effective interdepartmental communication among Village offices
and facilities. The division currently maintains:
• 13 Servers
• 220+ Desktop and Mobile Workstations
• Almost 100 Printers and Specialty Devices
The backbone of the Village's data systems is a redundant wide area network comprised of fiber optic
cable and secure wireless transmission. This network links the data systems of three fire stations, two
golf courses, Police headquarters, Public Works, and Village Hall.
Several technology upgrades are being requested for 2013 which will strengthen both the distribution
and maintenance of data throughout the Village.
In addition to the Villagewide IT initiatives, Public Works is also requesting specific technology programs
for Geographical Information Systems (GIS) and Computerized Maintenance Management Systems
(CMMS).
Technology is a key part of the Village's vision and mission and that is reflected in this year's CIP
requests.
Village of Buffalo Grove 17 2013-2017 CIP Planning Document
Document Management Solution
Category: Technology
Fund: Capital Projects - Facilities
�i���o�ifuu9ll
Account Number: 150.75.560.50
Priority Score: 21
d' Initial Proposal Date: 2012
Project Coordinator: OVM-Information Technology
Summary: This project will allow employees to scan documents for long term document
management.
Budget Impact: This project is funded through an internal transfer from the General Fund's operating
revenues.
EMEMEM
Estimated
Budgeted Amount FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Actual $ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering
Construction
Equipment $45,000 - - - - $45,000
Contingency
Sub-Total $45,000 - - - - $45,000
Village of Buffalo Grove 18 2013-2017 CIP Planning Document
GIS Consortium
Category: Technology
ME Fund: Capital Projects- Facilities
Account Number: 150.75.560.50
Priority Score: 19
Initial Proposal Date: 2013
Project Coordinator: PW-Engineering
Summary: Joining the GIS Consortium would give the Village of Buffalo Grove access to staffing
and development tools through a cooperative, regional consortium. Savings over in-
house staff would be realized as the Village would only pay partial staff salaries sized
to fit our needs without bringing in our own set of employees. The expenditures laid
out below are based on the Remote Access Service GIS Consortium Model which
provides savings in hardware and software costs for the Village. Finally, a time
savings will be realized as implementation of a GIS system will be fully scheduled and
streamlined with input from professionals who specialize specifically in GIS.
Budget Impact: This project is funded through an internal transfer from the General Fund's operating
revenues.
EMEMEM
Estimated
Budgeted Amount
FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Actual $ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Staffing/Engineering $127,572 $133,951 $140,648 $147,680 $155,064 $704,915
Construction
Equipment $25,425 $7,561 $7,495 $7,175 $7,308 $54,964
Contingency
Sub-Total $152,997 $141,512 $148,143 $154,855 $162,372 $759,879
Village of Buffalo Grove 19 2013-2017 CIP Planning Document
Public Works Software/Database Upgrades
Lain- l i i Category: Technology
1�1
�uuuiui�uiui�i��w�R���a�o��
Fund: Capital Projects - Facilities
Account Number: 150.75.560.50
Priority Score: 20
Initial Proposal Date: 2013
Project Coordinator: PW-Admin
w... .........
mn�man�u naar¢wion�nan¢mmu�nrvi�n�rvm¢m¢n¢n,��irvi��ry ri�n�m�m�m�?�m�mmi mi mi mr¢i,nrn^nq��rnrnrnr¢wi�n��aan��mn�mar¢win�arrr.%
Summary: Due to the decreased size of an already lean Public Works Department, efficiencies in
daily activities need to be realized. The current Lotus Notes system of non-
integrated databases is inefficient because the same data is being entered multiple
times in multiple locations. A software/database upgrade from a company
specializing in Public Works Computerized Maintenance Management Systems
(CMMS) would allow the technology to streamline processes for everyone from the
Resident looking to submit a service request, to a PW employee closing out work
orders, to a Supervisor tracking unit costs on the back end.
Budget Impact: This project is funded through an internal transfer from the General Fund's operating
revenues.
EMEMEM
Estimated
Budgeted Amount
FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Actual Expenditures $ 0 $ 0 $ 0 $ 0 $ 0 $ 0
�.
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering $9,875 - - - - $9,875
(Training&Startup)
Construction
Equipment $23,250 $4,500 $4,500 $4,500 $4,500 $41,250
(Software)
Contingency
Sub-Total $33,125 $4,500 1 $4,500 $4,500 $4,500 $51,125
Village of Buffalo Grove 20 2013-2017 CIP Planning Document
Upgrade Wireless Network - Building to Building
+5 Category: Technology
Fund: Capital Projects - Facilities
Account Number: 150.75.560.50
i,
Priority Score: 21
jInitial Proposal Date: 2012
Project Coordinator: OVM-Information Technology
wvnmNltlarrvnNaarrvnNd1WMWarararararaYw^�,�iYiYiYiYVYrYii Ra�rnrnrninrnrnn�"d�"rnrnrnrnrnrnd�i"n�@i.'
Summary: This project will upgrade the current 5 year old wireless network. It will provide a
new base antenna system at Village Hall and upgrade the data connection at 9
remote buildings.
Budget Impact: This project is funded through an internal transfer from the General Fund's operating
revenues.
EMEMEM
Estimated
Budgeted Amount FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Actual $ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering $15,000 - - - - $15,000
Construction $7,000 - - - - $7,000
Equipment $32,000 - - - - $32,000
Contingency
Sub-Total $54,000 - - - - $54,000
Village of Buffalo Grove 21 2013-2017 CIP Planning Document
Water Main & Sanitary Sewer Systems
The Village of Buffalo Grove's oldest water main was constructed in 1929 with the majority,
approximately 50%, of water main put into place between 1983 and 1996. Currently,the water main
system has 181 linear miles of water main and has a replacement value of approximately$773 million.
Other water system features include:
• 2,475 Hydrants
• 1,900 Valves
• 4 Pump Houses with storage reservoirs and back-up deep wells
Due to the relatively young age of the water system, between 1993 and 2007 the only capital expense
was$229,527 for the St. Mary's Road water main replacement. In the previous five year period since
2008,there has been $1,997,566 capital expenses related to water system replacements and
improvements.
The Village of Buffalo Grove's sanitary sewer system is a combination of gravity lines,force mains, and
lift stations. There are 134.20 miles of gravity sewer and 5.07 miles of force main. Currently,there are
12 sanitary sewer lift stations in operation (6 in Cook County and 6 in Lake County).
All municipal waste is conveyed through village-owned and maintained sanitary sewer mains. The
wastewater is then routed to either Lake County Public Works or Midwest Water Reclamation District
(Cook County).
Expenditures in this category historically include repairs and reliability enhancements to the water and
wastewater systems.
Village of Buffalo Grove 22 2013-2017 CIP Planning Document
Lift Station Repair & Rehabilitation Program
Category: Water Main & Sanitary Sewer
Fund: Water & Sewer Fund
Account Number: 170.55.36.560.70
Priority Score: 21
Initial Proposal Date: 2001
Project Coordinator: Public Works
��NIDNIDd NPd�� PYP�P Y,,Y, Yddd ���Pd PdPP
Summary: This program provides for permanently installed standby emergency generators at
the Raupp, OTP and Cambridge on the Lake Lift Stations and will complete other
required work identified at other lift stations, such as condition evaluations, cathodic
protection system renovations, maintenance lift repairs, and contractual interior
painting.
A Water Pollution Control Loan through the IEPA was authorized at$531,000 in 2012
to help fund the OTP/COTL project.
Budget Impact: This program is funded by the Water&Sewer Fund Reserves.
Estimated
Budgeted Amount FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$300,000 $300,000 $300,000 $300,000 $300,000 $1,500,000
Actual 11; 0 $669,606 $133,455 $290,000 $150,000 $1,243,061
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering $30,000 $30,000 $30,000 $30,000 $30,000 $150,000
Construction $750,000 $500,000 $270,000 $270,000 $270,000 $2,060,000
Equipment
Contingency
Sub-Total 1 $780,000 1 $530,000 $300,000 1 $300,000 1 $300,000 1 $2,210,000
Village of Buffalo Grove 23 2013-2017 CIP Planning Document
Pump House & Security Improvements
Category: Water Main & Sanitary Sewer
M lilu
lA
Fund: Water & Sewer
Account Number: 170.55.35.560.60
j Priority Score: 19
Initial Proposal Date: 2010
Project Coordinator: PW-Engineering
'ymnw,�,mm^r,!ry r,lrv�,nv�ritit ry r,!ry�,ri�vv,Nmir,!ry ri1.�v�ini�Pi�n�'ry r,!ry�,ni�v�„N�mmvrirnvrnnivrl�nv7rn,n.�
Summary: This program incorporates pump house repair projects identified in the 2008
Comprehensive Water Study Update and improvements identified in the federally
mandated vulnerability study.
The IEPA has informed the Village that $610,318 in loan funds have been reserved
through the Public Water Supply Loan Program. The design engineering is
substantially complete and bidding will occur in accordance with the loan schedule.
It is anticipated that construction may begin late in 2012 but that most expenditures
will hit in 2013. If the loan is approved, the payment schedule would be extended
versus the lump sum shown in the table below.
Budget Impact: This program is funded by the Water&Sewer Fund Reserves.
Estimated
Budgeted Amount FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $ 0 $ 0 $600,000 $600,000 $1,200,000
Actual $ 0 $ 0 $ 0 $44,505.06 $100,000 $144,505.06
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering
Construction $610,318 - - - - $610,318
Equipment
Contingency
Sub-Total $610,318 - - - - $610,318
Village of Buffalo Grove 24 2013-2017 CIP Planning Document
SCADA Improvements
Category: Technology
Fund: Water & Sewer
Account Number: 170.55.35.560.60
Priority Score: 16
Initial Proposal Date: 2012
Project Coordinator: Public Works
Summary: Implement recommended improvements as detailed in the SCADA System Master
Plan. The numbers also include rain gauge upgrades in 2013.
Budget Impact: This program is funded by the Water &Sewer Fund Reserves.
Estimated
Budgeted Amount
FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Actual $ 0 $ 0 $ 0 $ 0 $ 0 $ 0
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering
Construction
Equipment $70,000 $78,000 $94,000 $60,000 - $302,000
Contingency $7,000 $7,800 $9,400 $6,000 - $30,200
Sub-Total $77,000 $85,800 $103,400 $66,000 - $332,200
Village of Buffalo Grove 25 2013-2017 CIP Planning Document
Villagewide Sanitary Sewer Replacement Program
Category: Water Main & Sanitary Sewer
Fund: Water & Sewer Fund
i�i ryry�Viuppl�lulll l�l�ll����,ti,I�u�'i„i ui�i�Villlllpl 1���4
uim����V�i1114 iiu'uV��luuii°up OYi
Account Number: 170.55.36.560.70
w„
s u
Priority Score: 14
Initial Proposal Date: 2012
Project Coordinator: PW-Engineering
��+irv'.%i.MGnrvrirvMMfiYFM^MVPVIry➢V f�fV�Y JVV➢HV.VM➢�vfV�Y JV pvrygvrygf�ry IYY YV Y"V vlvmyyyJy YV Y VfV➢V vp
Summary: This program provides for sanitary sewer lining, point repairs, or replacements at
priority locations. The locations are identified through the Annual Sanitary Sewer
Televising Inspection Program.
While 2013 is an off-year for this work, this item is included in the 2013-2017 CIP for
future planning purposes.
Budget Impact: This program is funded by the Water &Sewer Fund Reserves.
Estimated
Budgeted Amount FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $ 0 $ 0 $ 0 $650,000 $650,000
Actual $ 0 $ 0 $ 0 $ 0 $450,000 $450,000
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering
Construction - $700,000 - $700,000 - $1,400,000
Equipment
Contingency
Sub-Total - $700,000 - $700,000 - $1,400,000
Village of Buffalo Grove 26 2013-2017 CIP Planning Document
Villagewide Water Main Replacement Program
Category: Water Main & Sanitary Sewer
Fund: Water & Sewer Fund
Account Number: 170.55.35.560.60
Priority Score: 14
Initial Proposal Date: 2012
Project Coordinator: PW-Engineering
m»Nv91Ns1wiyrvslJiyrv�i)riinsnsnsnsnn�u� rrru�u�N��s1rv1rv1rv1�rv1�M�d»bUrv1rv1rv1rv1�rv1�rv1�b1�0y�alJwl�
Summary: This program provides for water main replacements at priority locations in older
portions of the Village as identified through the Water Service Interruption Reports.
In 2012, three priority locations were identified on Raupp Blvd (Golfview to
Mohawk), Patton Drive (Bradley to Stillwell), and Cottonwood Road (Cherrywood to
St. Marys) and are proposed to be rehabilitated using cured-in-place-pipe (CIPP). In
order to allow the water rate increases to catch up, a single location is proposed for
2013 to rehabilitate the most troubled of the water mains: Cottonwood Road. The
other two locations are being pushed to 2014.
Budget Impact: This program is funded by the Water &Sewer Fund Reserves.
Estimated
Budgeted Amount FY 2008 FY 2009 FY 2010 FY 2011 FY 2012 TOTAL
$ 0 $ 0 $ 0 $ 0 $160,000 $160,000
Actual $ 0 $ 0 $ 0 $ 0 $160,000 $160,000
Expenditures
Expense Category FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 TOTAL
Land
Engineering $15,000 $30,000 - - - $45,000
Construction $300,000 $845,000 $700,000 - $700,000 $2,545,000
Equipment
Contingency $30,000 $84,500 - - - $114,500
Sub-Total 1 $345,000 $959,500 $700,000 - $700,000 $2,704500
Village of Buffalo Grove 27 2013-2017 CIP Planning Document
Criteria List and Scoring Matrix
Project is inconsistent with Village's Project is consistent with Village's Project is directly consistent with
Consistency with Comprehensive Plan or does nothing Comprehensive Plan but does little the Village's Comprehensive Plan
Village Goals and 1 to advance Strategic Goals to advance Strategic Goals and advances the Strategic Goals 0, .J, of 2
Plans
Project would have no impact on Project would increase public Project addresses an immediate,
Public Health and 2 existing public health and/or safety health and/or safety but is not an continual safety hazard or public 0k 1.k �'.b€ �,2
Safety
concerns urgent,continual need or hazard health and/or safety need
Project is not mandated or otherwise Project would address anticipated Project required by federal,state,
Mandates or Other required by intergovernmental mandates,other legal or local mandates,grants,court
Legal Requirements 3 agreement,judgment,or court order requirements,or orders and judgments;required as 0, '.J, of 2
intergovernmental agreements a part of an intergovernmental
agreement
Project not related to maintaining an Project would maintain existing Project would address deficiencies
Maintains or existing standard of service standard of service or problems with existing services
Improves Standard 4 or will establish a new service 0, 1., or 2
of Service
Project would benefit only a small Project would benefit a large Project would benefit the entire
Extent of Benefit 5 percentage of citizens or particular percentage of citizens or many community 0, .J, of 2
neighborhood or area neighborhoods or regions
Project is not related to other Project linked to other projects in Project is essential to the success of
Relation to Other projects in the Capital Improvement the Capital Improvement Plan other projects identified in the
Projects 6 Plan already underway but not essential current Capital Improvement Plan 0, 1., or 2
to their completion
Project has no public support or Project has been identified by the Project has strong technical and
Public Perception of established voter appeal;is not residents as a need in the strong political support,project was
Need 7 identified by the community as a community but lacks strong suggested or demanded by the 0, .J, of 2
need support community
Project would have no impact on the Project would result in savings by Project would result in significant
efficiency of service eliminating obsolete or inefficient savings by increasing the efficiency
Efficiency of Service 8 services or facilities of the performance of a service or 0 1 or
reducing the on-going cost or
service of a facility
Project would discourage or directly Project would have no impact on Project would directly result in
prevent capital investment,decrease capital investment,tax base, capital investment,increased tax
Supports Economic B the tax base,decrease valuation,or valuation,or employment base,increased valuation,or
Development decrease job opportunities improved job opportunities ° 4C
Project would have a negative effect Project would not effect the Project would improve the
Environmental 10 on the environmental quality of the environmental quality of the Village environmental quality of the Village 2
Quality Village ��jk � or
Project is unable to proceed due to Minor obstacles exist,project is not Project is entirely ready to proceed,
Feasibility of Project 11 obstacles(land acquisition, entirely ready to proceed no obstacles exist 0, .J, of 2
easements,environmental)
If deferred,the increase in project If deferred,the increase in project If deferred,the increase in project
Opportunity Cost 12 costs would be less than the rate of costs would be equal to inflation costs would be greater than the 0, 1., t:'t,l` 2
inflation rate of inflation
Project would significantly increase Project would neither increase or Projects would decrease debt
debt service,installment payments, decrease debt service,installment service,installment payments,
Operational Budget personnel or other operating costs payments,personnel,or other personnel or other operating costs
Impact 13 M :�.Mf"
p or decrease revenues operating costs or revenues or increase revenues
TOTALSCORE "IIo'taI
Village of Buffalo Grove 28 2013-2017 CIP Planning Document
FY 2012 Property Tax Levy - Preliminary Discussion 2-B
Overview
Staff would request that the initial development of the FY 2012 Property Tax Levy be discussed with the
Village President and Board of Trustee as part of the September 24th Committee of the Whole Meeting to
obtain guidance on the final levy determination.
Attachments
2012 Tax Levy-Prehminary.pdf
Trustee Liaison Staff Contact
Trustee Berman Scott D Anderson,
....M.on.da...........Se......pte.m.be.r..24......2.0.1..2 Discussion
'sc uss.'.o.n...._...Ite.m........2._B........................................................................................................................................................
Y,
ti H,�
TO: DANE C. BRAGG
FROM: SCOTT D ANDERSON
SUBJECT: FY 2012 PRELIMINARY PROPERTY TAX LEVY
DATE: 9/20/2012
CC: KATIE SKIBBE
............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
In conjunction with the development of the FY 2013 Village Budget, staff is currently working on a
recommendation for the FY 2012 Tax Levy(collected in 2013).
Last year due to a confluence of factors, including the elimination of the Series 2002B bonds, a
legislative change to the public safety pensions coupled with strong 2010 investment returns, and a
zero growth Corporate Fund levy, the Village Board was able to pass a no growth levy($10,000 actual
decline)from the previous year.The total levy request was$14,201,796.
Using $14,201,796 as the baseline for this year, the following are observations on the three
components of the levy (Corporate, Debt Service and Pensions) and the challenges presented with
trying to duplicate the results of last year.
Corporate Fun
Historically the amounts requested to support the core functions of government are based on
inflationary growth values published by American City & County as the Municipal Cost Index. This
index is then added to the previous year's levy request. The MCI is a blended index that factors for
the Consumer Price Index, Producer Price Index, and other relevant inflationary indices applied to
how municipalities traditionally acquire goods and services. For the year ending August, 2012, the
cost index is 1.3 percent. This minimal inflationary growth will generate an additional $97,891 in
property tax revenue for corporate purposes. Last year the Village did not increase the levy. The
Corporate Fund was able to absorb the lack of tax growth due to savings generated by the Voluntary
Separation Incentive. Those savings have been realized and there is a significant gap between
operating revenues and expenditures in the preliminary phase of the FY 2013 Budget. Even with the
1.3 percent added to the levy, that increase is applicable to approximately 35 percent of the entire
Corporate Fund revenue budget. With the remaining revenues growing at less than 1.5 percent and
expenditures growing near 3.5 percent there are significant structural budget imbalances to address.
Debt Service
Last year's debt service requirement was $1,138,696. In December 2010, the final principal and
interest payment was made on the 2002B bonds. After the approval of a $200,000 tax abatement the
net property tax supported debt service amount was $938,696. With the issuance of the 2012 bonds
this year, the debt service requirement will be $1,321,300 next year. That amount represents
eighteen months of interest as the June 2012 obligation was rolled into the 2013 payment. It is
staff's intention to abate approximately $382,604 ($200,000 -Water Fund and $182,604 -Corporate
Page 1 of 3
Fund) of that levy to maintain level debt service. The abatement will partially be offset by reducing
home rule sales tax transfers to the Motor Fuel Tax Fund. As the abatement is being used to offset
interest payments on the debt to fund the annual street maintenance program, the deployment of
funds is appropriate. For budgeting purposes,there will be no growth in the debt service levy.
Pensions
Both the Police and Fire Pension Fund annual required contributions are being calculated by the
Village's independent actuary. Staff has received notification from the Illinois Municipal Retirement
Fund (IMRF)that the employer portion of the pension will increase 5.4 percent in 2013.The resultant
impact will be approximately a $47,500 increase with the Social Security/Medicare portions to
increase about $18,000. Using the IMRF recommendation as a proxy for the public safety pension an
estimate of 8 percent growth is used for this review. Staff should receive final report and
recommendation within the next several weeks. Applying 8 percent growth nets an additional
$172,787 and $160,300 of required additional levies for the Police and Firefighter's Pension Funds
respectively. The total additional required amount of pension levies is estimated to be$398,587.
EAN
Over the last two years the equalized assessed value of property in Buffalo Grove has dropped 12.6
percent from $1.89 billion to $1.66 billion. Staff anticipates another year of decline in the range of
4.5 to 6 percent as the last wave of property value appeals are meted out. The decline in EAV, and
the unequal distribution of those declines, has put much pressure on the tax rate and resulting
property tax liabilities. Below is a graph depicting the growth, and decline, of EAV over the last ten
years;
Equalized Assessed Valuation
2,000,000,000
1,800,000,000 ���
1,600,000,000
1,400,000,000
1,200,000,000
1,000,000,000
800,000,000
600,000,000
400,000,000
200,000,000 _.. .._..�
0 �...: �.... �.... ....i �.... �.... �.... �... �....
2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
ui Cook County uTotalEAV ua Lake Couty
Impact
The result of the increases noted above would result in a final levy, after abatements, of$14,698,274
or 3.5 percent growth. The first hurdle in the process is the truth in taxation report. If the Village's
tax levy request exceeds the prior year's tax extension (less debt service levies) by more than 5
percent the Village must publish for, and conduct a public hearing. Using the amounts above, the
Page 2 of 3
increase would be under 4 percent. At this point in the process, staff anticipates the tax levy (less
abatements)to resemble the table below;
Village of Buffalo Grove
Final Distribution of 2012 Property Tax Cook County Cook Lake County Lake 2012 Total 2011
After Tax Abatement Consideration Levy* County Levy* County Extension Levy Request
Rate
23.08% Rate(1) 76.92% (1) 100.00% 100.00%
Tax Levies:
Corporate 516,201.65 0.1324 1,720,373.96 0.1323 2,236,575.61 2,207,873.26
Street and Bridge 164,614.34 0.0422 548,619.38 0.0422 713,233.72 704,080.67
Street Lighting 55,810.42 0.0143 186,002.51 0.0143 241,812.94 238,709.71
Police Protection 123,768.86 0.0318 412,491.35 0.0317 536,260.21 529,378.29
Fire Protection 885,044.17 0.2271 2,949,635.96 0.2268 3,834,680.13 3,785,469.03
ESDA 2,952.94 0.0008 9,841.41 0.0008 12,794.34 12,630.15
Crossing Guard 12,148.01 0.0031 40,486.35 0.0031 52,634.36 51,958.89
Sub-Total:Corporate 1,760,540.39 0.4517 5,867,450.91 0.4511 7,627,991.30 7,530,100.00
IMRF/Social Security 377,336.07 0.0941 1,257,568.93 0.0967 1,634,905.00 1,569,405.00
Corp. Purpose Bonds
Facilities(2012) 0.00 0.0000 0.00 0.0000 0.00 0.00
Corp. Purpose Bonds
Facilities(2003) 76,256.32 0.0195 254,143.68 0.0195 330,400.00 325,008.00
Corp. Purpose Bonds
Facilities(2010A) 119,583.25 0.4035 398,541.75 0.0306 518,125.00 525,425.00
Corp. Purpose Bonds
Facilities(2010B) 20,371.10 0.0053 67,891.90 0.0052 88,263.00 88,263.00
Police Pension 538,369.86 0.1296 1,794,255.18 0.1380 2,332,625.04 2,159,838.00
Fire Pension 499,464.49 0.1202 1,664,593.07 0.1280 2,164,057.56 2,003,757.00
Total 3,391,921.48 0.7743 11,304,445.42 0.8691 14,696,366.90 14,201,796.00
Dollar Percentage
2012 Request 2011 Request Change Change
Corporate 7,627,991.30 7,530,100.00 97,891.30 1.30%
Special Purpose-IMRF 1,634,905.00 1,569,405.00 65,500.00 4.17%
Pension 4,496,682.60 4,163,595.00 333,087.60 8.00%
Debt Service 936,788.00 938,696.00 (1,908.00) -0.20%
14,696,366.90 14,201,796.00 494,570.90 3.48%
Staff would request that the initial development of the FY 2012 Property Tax Levy be discussed with
the Village President and Board of Trustee as part of the September 24`" Committee of the Whole
Meeting to obtain guidance on the final levy determination.
Page 3 of 3
2013 General Wage Adjustment Recommendation 2-C
Overview
The attached memo presents the research and recommendation for the 2013 general wage adjustment.
Attachments
2012 COLA Memo.pdf
Trustee Liaison Staff Contact
Trustee Sussman Arthur Malinowski,
....M.on.da...........Se......ptem.be.r..24......2.0.1..2...........................................................................................D.'sc uss.'.o.n...._...Ite.m........2._C........................................................................................................................................................
Y,
VILLAGE OFI uu NON°
BUFFALO GROVE
ikv� � Cupp Blvd.
V'x iI`f Io(�r,ivv D L WON 2196
MEMORANDUM
TO: Dane C. Bragg, Village Manager
FROM: Arthur A. Malinowski, Jr., Esq., Human Resources Director
DATE: September 19, 2012
RE: 2013 General Wage Adjustment Recommendation and Additional Considerations.
Staff has compiled actual 2012 and anticipated 2013 general wage increase (GWI)
information for the non-represented employees of the 20 communities in the Chicago
metropolitan area that the Village of Buffalo Grove considers "comparable". (List of
comparables attached).
Of the 20 communities surveyed, 10 communities are on a January 1 fiscal year and 10
communities are on a May 1 fiscal year.
Survey data indicates that the actual average GWI among the Village's comparable
communities was 1.28% in 2012 and that our comparables anticipate awarding an average of
1.54%to their non-represented employees in 2013. (Survey data attached). Skewing the 2012
average is the fact that 7 of the communities surveyed indicated that they did not award a GWI in
the year so noted. Furthermore, the 2013 GWI average is immature due to the fact that 6
communities were not in the position to provide an estimate as to their 2013 award.
It is the Village's long standing philosophy to award its non-represented employees the
same increase as its union employees in the event that its union employees are awarded a higher
increase. Due to significant economic considerations, this practice has been tested in recent years,
however, the Village was able to provide a similar GWI to both represented and non-represented
employees in 2012.
Based on the data reported to the Village by its comperables, staff recommendations that
the Village award a 2.0% GWI on January 1, 2013, subject to the availability of sufficient
revenue.
Based on the Village's 2012 payroll, including all non-represented full-time,part-time
and seasonal employees, each percent increase will have a budgetary impact of approximately
$150,000. Therefore, a GWI of 2.0% on January 1, 2013 to all non-represented employees will
have a budgetary impact of approximately $300,000. Each percent increase awarded on the first
day of the 2013/2014 collective bargaining year(May 1, 2013 to April 30, 2014)to all 54
-1-IPa1'1., C
members of the fire union, will have a budgetary impact of approximately $45,000.
In addition to the GWI component of the 2013 budget, staff continues work to develop a
program designed to move employees through their respective pay ranges via a combination of
step (longevity based criteria) and merit(performance based criteria). Until this program is
finalized, it is recommended that we continue the existing program, first implemented in 2012,
which is to award a range progression increase to all non-represented employees who have not
yet reached the top of their 2009 payrange, as adjusted by the 2011 and 2012 GWI and subject to
the availability of funds. The 2013 budgetary impact of this increase is estimated at
approximately $150,000.
I am available to discuss this matter with you at your convenience.
- 2 -
2012 COMPARABLE COMMUNITIES
The following list represents the comparable communities currently used by the Village for all
positions that are not represented by the Fire union.
1. Arlington Heights
2. Crystal Lake
3. Elk Grove Village
4. Glenview
5. Gurnee
6. Highland Park
7. Hoffman Estates
8. Lombard
9. Morton Grove
10. Mount Prospect
11. Mundelein
12. Niles
13. Northbrook
14. Palatine
15. Park Ridge
16. Rolling Meadows
17. Streamwood
18. Wheaton
19. Wheeling
20. Wilmette
The following list represents the comparable communities currently used by the Village for
negotiations with the Fire Union.
1. Elk Grove
2. Glenview
3. Gurnee
4. Highland Park
5. Hoffman Estates
6. Morton Grove
7. Mount Prospect
8. Mundelein
9. Niles
10. Northbrook
11. Park Ridge
12. Rolling Meadows
13. Wheeling
14. Wilmette
- 3 -
NON-UNION GENERAL WAGE INCREASE/MARKET ADJUSTMENT
BASED ON DATA AVAILABLE-AUGUST 2012
Municipality Actual 2012 Anticipated bate(s)Awarded
COLA% 2013 COLA%
Buffalo Grove 2.16% TBD January 1=2.00%
September 1= 0.50%
Arlington Heights 2.50% TBD May 1=2.00%
November 1 = 1.00%
Crystal Lake 0.00% 0.00% May 1
Elk Grove Village 2.00% 2.00%-3.00% May 1
Glenview 2.50% 2.50% January 1
Gurnee 1.00% 2.00% May 1
Highland Park 0.00% TBD Janaury 1
Hoffman Estates 2.00% 2.00% January 1
Lombard 0.00% 0.00% January 1
Morton Grove 0.00% 0.00% January 1
Mount Prospect 2.00% 2.00% January 1
Mundelein 0.00% 2.00%-2.50% May 1
Niles 2.00% TBD May 1
Northbrook 2.50% TBD May 1
Palatine 1.00% TBD January 1
Park Ridge 2.00% TBD May 1
Rolling Meadows 0.00% 0.00%- 1.00% January 1
Streamwood 0.00% 0.00% January 1
Wheaton 2.00% 2.00% May 1
Wheeling 2.00% 2.50% May 1
Wilmette 2.00% 2.00% January 1
Average(Less BG) 1.28% 1.54%
r
2013 Employee Medical, Dental and Life Insurance 2-D
Premium Recommendations
Overview
The attached memo presents the research and recommendation for the 2013 Employee Medical, Dental and
Life Insurance Recommendations.
Attachments
2012 INS Memo.pdf
Trustee Liaison Staff Contact
Trustee Sussman Arthur Malinowski,
....M.on.da...........Se......ptem.be.r..24......2.0.1..2...........................................................................................D.'sc uss.'.o.n...._...Ite.m........2._D........................................................................................................................................................
Y,
INTERGOVERNMENTAL PERSONNEL BENEFIT COOPERATIVE
Funding Sheet Detail
Village of Buffalo Grove
*Assumes an 8%HMO,10%PPO,and 4%Dental rate increase effective 7/1/2013
Jan 13 through Dec 13
Coverage 111113-6130113 Estimated 711113-1213111 3
Rate" Volume/Covered Amount Rate" Volume/Covered Amount
Lives Payable Lives Payable
Life Insurance
Life/$1,000 $0.070 17,435,093 $1,220.46 $0.070 17,435,093 $1,220.46
AD&D/$1,000 $0.020 17,435,093 $348.70 $0.020 17,435,093 $348.70
Family Life per Unit $0.260 9 $2.41 $0.260 9 $2.41
Under age 25 $0.055 0 $0.00 $0.055 0 $0.00
Age 25-29 $0.065 0 $0.00 $0.065 0 $0.00
Age 30-34 $0.075 1,150,000 $86.25 $0.075 1,150,000 $86.25
Age 35-39 $0.095 3,400,000 $323.00 $0.095 3,400,000 $323.00
Age 40-44 $0.120 3,360,000 $403.20 $0.120 3,360,000 $403.20
Age 45-49 $0.180 1,500,000 $270.00 $0.180 1,500,000 $270.00
Age 50-54 $0.275 500,000 $137.50 $0.275 500,000 $137.50
Age 55-59 $0.455 50,000 $22.75 $0.455 50,000 $22.75
Age 60-64 $0.780 10,000 $7.80 $0.780 10,000 $7.80
Age 65-69 $1.200 10,000 $12.00 $1.200 10,000 $12.00
Age 70-74 $2.300 0 $0.00 $2.300 0 $0.00
Over 75 $3.720 0 $0.00 $3.720 0 $0.00
Supplemental AD&D/$1,000 $0.030 0 $0.00 $0.030 0 $0.00
GBS Fee $0.250 222 $55.50 $0.250 222 $55.50
Life Ins.Total $2,889.56 Life Ins.Total $2,889.56
Medical Waivers
IPBC Fee $1.50 9 $13.50 $1.50 9 $13.50
Waiver Total $13.50 Waiver Total $13.50
HMO
BCBS HMOI-$20 Cbpay$10/$15/$30 2x mail Rx+Vision
Fixed Costs
Administrative Fee $50.49 9 $454.41 $50.66 9 $455.94
Data Warehousing Fee $1.20 9 $10.80 $1.20 9 $10.80
Stop LossPreiniurn $20.06 9 $180.54 $25.27 9 $227.43
Aggregate Premium $1.40 9 $12.60 $1.32 9 $11.88
IPBC Fee $1.50 9 $13.50 $1.50 9 $13.50
GBS Fee $13.65 9 $122.85 $13.65 9 $122.85
Subtotal 9 $794.70 Subtotal 9 $842.40
Claim Factors
Single $422.86 1 $422.86 $458.45 1 $458.45
Single+1 $944.24 0 $0.00 $1,021.54 0 $0.00
Family $1,736.53 6 $10,419.18 $1,877.22 6 $11,263.30
Single Retiree<65 $422.86 2 $845.72 $458.45 2 $916.91
Retiree<65+1<65 $944.24 0 $0.00 $1,021.54 0 $0.00
Retiree<65+Family $1,736.53 0 $0.00 $1,877.22 0 $0.00
Medicare Single $346.19 0 $0.00 $375.65 0 $0.00
Medicare Single+1 Dep.Medicare $780.68 0 $0.00 $844.90 0 $0.00
Medicare Single+1 Non-Medicare $857.35 0 $0.00 $927.70 0 $0.00
Subtotal 9 $11,687.76 Subtotal 9 $12,638.66
HMO Total 9 $12,482.46 HMO Total 9 $13,481.06
PPO
BCBS PPO A
Fixed Costs
Administrative Fee $51.52 99 $5,100.48 $51.52 99 $5,100.48
Data Warehousing Fee $1.20 99 $118.80 $1.20 99 $118.80
Stop LossPreiniurn $78.75 99 $7,796.25 $101.60 99 $10,058.40
IPBC Fee $1.50 99 $148.50 $1.50 99 $148.50
GBS Fee $13.65 99 $1,351.35 $13.65 99 $1,351.35
Subtotal 99 $14,515.38 Subtotal 99 $16,777.53
Claim Factors
Single $409.21 20 $8,184.20 $441.94 20 $8,838.86
Single+1 $976.15 22 $21,475.30 $1,065.58 22 $23,442.69
Family $1,837.67 33 $60,643.11 $2,013.25 33 $66,437.22
Single Retiree<65 $409.21 10 $4,092.10 $441.94 10 $4,419.43
Retiree<65+1<65 $976.15 6 $5,856.90 $1,065.58 6 $6,393.46
Retiree<65+Family $1,837.67 3 $5,513.01 $2,013.25 3 $6,039.75
Medicare Single $325.84 1 $325.84 $350.24 1 $350.24
Medicare Single+1 Dep.Medicare $798.30 3 $2,394.90 $869.94 3 $2,609.83
Medicare Single+1 Non-Medicare $881.67 1 $881.67 $961.65 1 $961.65
Page 1
INTERGOVERNMENTAL PERSONNEL BENEFIT COOPERATIVE
Funding Sheet Detail
Village of Buffalo Grove
*Assumes an 8%HMO,10%PPO,and 4%Dental rate increase effective 7/1/2013
Jan 13 through Dec 13
Coverage 111113-6130113 Estimated 711113-1213111 3
Subtotal 99 $109,367.03 Subtotal 99 $119,493.12
ItCBS PPO B
Fixed Costs
Administrative Fee $51.52 137 $7,058.24 $51.52 137 $7,058.24
Data Warehousing Fee $1.20 137 $164.40 $1.20 137 $164.40
Stop Loss Premium $78.75 137 $10,788.75 $101.60 137 $13,919.20
IPBC Fee $1.50 137 $205.50 $1.50 137 $205.50
GBS Fee $13.65 137 $1,870.05 $13.65 137 $1,870.05
Subtotal 137 $20,086.94 Subtotal 137 $23,217.39
Claim Factors
Single $438.39 29 $12,713.31 $474.04 29 $13,747.19
Single+1 $1,035.09 18 $18,631.62 $1,130.41 18 $20,347.40
Family $1,941.85 76 $147,580.60 $2,127.85 76 $161,716.37
Single Retiree<65 $438.39 5 $2,191.95 $474.04 5 $2,370.21
Retiree<65+1<65 $1,035.09 7 $7,245.63 $1,130.41 7 $7,912.88
Retiree<65+Family $1,941.85 0 $0.00 $2,127.85 0 $0.00
Medicare Single $350.64 0 $0.00 $377.52 0 $0.00
Medicare Single+1 Dep.Medicare $847.90 1 $847.90 $924.50 1 $924.50
Medicare Single+1 Non-Medicare $935.65 1 $935.65 $1,021.03 1 $1,021.03
Subtotal 137 $190,146.66 Subtotal 137 $208,039.57
PPO Total 236 $334,116.01 PPO Total 236 $367,527.61
Dental
Dental Option 1
Fixed Costs
Administrative Fee $3.81 258 $982.98 $3.81 258 $982.98
GBS Fee $1.00 258 $258.00 $1.00 258 $258.00
Subtotal 258 $1,240.98 Subtotal 258 $1,240.98
Claim Factors
Single $38.83 51 $1,980.33 $40.58 51 $2,069.36
Single+1 $68.66 37 $2,540.42 $71.60 37 $2,649.16
Family $118.40 119 $14,089.60 $123.33 119 $14,676.08
Single Retiree<65 $38.83 21 $815.43 $40.58 21 $852.09
Retiree<65+1<65 $68.66 26 $1,785.16 $71.60 26 $1,861.57
Retiree<65+Family $118.40 4 $473.60 $123.33 4 $493.31
Subtotal 258 $21,684.54 Subtotal 258 $22,601.56
Dental Total 258 $22,925.52 Dental Total 258 $23,842.54
Benefit Fund Distribution
Credit/Debit $0.00 $0.00
Total $0.00 Total $0.00
Terminal Reserve Activity
Credit/Debit $0.00 $0.00
Total $0.00 Total $0.00
$372,427.05 $407,754.27
*Total 2011-2012 premium number on bottom of funding sheet may not match your ACH debit due to your reported changes in enrollment.
Page 2
INTERGOVERNMENTAL PERSONNEL BENEFIT COOPERATIVE
Illustrative Premium Equivalent Rates
Village of Buffalo Grove
*Assumes an 8%HMO,10%PPO,and 4%Dental rate increase effective 7/1/2013
Jan 13 through Dec 13
Cowes e 111113-6130113 Estimated 711113-12131113 Estimated 111113-12131113
Rate" Volumo/Colored Amount' Rate" Volume/Covered Amount' Rate Volume/Co jeered Amount'
Lives:: Payable Lives Payable Lives Payable
Life Insurance
Life/$1,000 $0.070 17,435,093 $1,220.46 $0.070 17,435,093 $1,220.46 $0.070 17,435,093 $1,220.46
AD&D/$1,000 $0.020 17,435,093 $348.70 $0.020 17,435,093 $348.70 $0.020 17,435,093 $348.70
Fairrity Life per Unit $0.260 9 $2.41 $0.260 9 $2.41 $0.260 9 $2.41
Under age 25 $0.055 0 $0.00 $0.055 0 $0.00 $0.055 0 $0.00
Age 25-29 $0.065 0 $0.00 $0.065 0 $0.00 $0.065 0 $0.00
Age 30-34 $0.075 1,150,000 $86.25 $0.075 1,150,000 $86.25 $0.075 1,150,000 $86.25
Age 35-39 $0.095 3,400,000 $323.00 $0.095 3,400,000 $323.00 $0.095 3,400,000 $323.00
Age 40-44 $0.120 3,360,000 $403.20 $0.120 3,360,000 $403.20 $0.120 3,360,000 $403.20
Age 45-49 $0.180 1,500,000 $270.00 $0.180 1,500,000 $270.00 $0.180 1,500,000 $270.00
Age 50-54 $0.275 500,000 $137.50 $0.275 500,000 $137.50 $0.275 500,000 $137.50
Age 55-59 $0.455 50,000 $22.75 $0.455 50,000 $22.75 $0.455 50,000 $22.75
Age 60-64 $0.780 7000 $7.80 $0.780 10,000 $7.80 $0.780 10,000 $7.80
Age 65-69 $1.200 7000 $12.00 $1.200 10,000 $12.00 $1.200 10,000 $12.00
Age 70-74 $2.300 0 $0.00 $2.300 0 $0.00 $2.300 0 $0.00
Over 75 $3.720 0 $0.00 $3.720 0 $0.00 $3.720 0 $0.00
SupplementalAD&D/$1,000 $0.030 0 $0.00 $0.030 0 $0.00 $0.030 0 $0.00
GBS Fee $0.250 222 $55.50 $0.250 222 $55.50 $0.250 222 $55.50
Life Ins.Total $2,889.56 Life Ins.Total $2,889.56 Life Ins.Total $2,889.56
Medical W aivers
Fees $1.50 9 $13.50 $1.50 9 $13.50 $1.50 9 $13.50
Waiver Total $13.50 Waiver Total $13.50 Waiver Total $13.50
HMO
BCBS RMOI-$20 Cola Colmy SIOIS S30 U mail Rx+Vision
Single $511.16 1 $511.16 $552.05 1 $552.05 $531.61 1 $531.61
Single+1 $1,032.54 0 $0.00 $1,115.14 0 $0.00 $1,073.84 0 $0.00
Fairrity $1,824.83 6 $10,948.98 $1,970.82 6 $11,824.90 $1,897.82 6 $11,386.94
Single Retiree<65 $511.16 2 $1,022.32 $552.05 2 $1,104.11 $531.61 2 $1,063.21
Retiree<65+1<65 $1,032.54 0 $0.00 $1,115.14 0 $0.00 $1,073.84 0 $0.00
Retiree<65+Fairrity $1,824.83 0 $0.00 $1,970.82 0 $0.00 $1,897.82 0 $0.00
Medicare Single $434.49 0 $0.00 $469.25 0 $0.00 $451.87 0 $0.00
Medicare Single+1 Dep.Medicare $868.98 0 $0.00 $938.50 0 $0.00 $903.74 0 $0.00
Medicare Single+1 Non-Medicare $945.65 0 $0.00 $1,021.30 0 $0.00 $983.48 1 0 $0.00
HMO Total 9 $12,482.46 HMO Total 9 $13,481.06 HMO Total 9 $12,981.76
PPO
BCBS PPO A
Single $555.83 20 $11,116.60 $611.41 20 $12,228.26 $583.62 20 $11,672.43
Single+1 $1,122.77 22 $24,700.94 $1,235.05 22 $27,171.03 $1,178.91 22 $25,935.99
Fairrity $1,984.29 33 $65,481.57 $2,182.72 33 $72,029.73 $2,083.50 33 $68,755.65
Single Retiree<65 $555.83 10 $5,558.30 $611.41 10 $6,114.13 $583.62 10 $5,836.22
Retiree<65+1<65 $1,122.77 6 $6,736.62 $1,235.05 6 $7,410.28 $1,178.91 6 $7,073.45
Retiree<65+Fairrity $1,984.29 3 $5,952.87 $2,182.72 3 $6,548.16 $2,083.50 3 $6,250.51
Medicare Single $472.46 1 $472.46 $519.71 1 1 $519.71 $496.08 1 $496.08
Medicare Single+1 Dep.Medicare $944.92 3 $2,834.76 $1,039.41 3 $3,118.24 $992.17 3 $2,976.50
Medicare Single+1 Non-Medicare $1,028.29 1 $1,028.29 $1,131.12 1 $1,131.12 $1,079.70 1 $1,079.70
ROBS PPO R
Single $585.01 29 $16,965.29 $643.51 29 $18,661.82 $614.26 29 $17,813.55
Single+1 $1,181.71 18 $21,270.78 $1,299.88 18 $23,397.86 $1,240.80 18 $22,334.32
Fairrity $2,088.47 76 $158,723.72 $2,297.32 76 $174,596.09 $2,192.89 76 $166,659.91
Single Retiree<65 $585.01 5 $2,925.05 $643.51 5 $3,217.56 $614.26 5 $3,071.30
Retiree<65+1<65 $1,181.71 7 $8,271.97 $1,299.88 7 $9,099.17 $1,240.80 7 $8,685.57
Retiree<65+Fairrity $2,088.47 0 $0.00 $2,297.32 0 $0.00 $2,192.89 0 $0.00
Medicare Single $497.26 0 $0.00 $546.99 0 $0.00 $522.12 0 $0.00
Medicare Single+1 Dep.Medicare $994.52 1 $994.52 $1,093.97 1 $1,093.97 $1,044.25 1 $1,044.25
Medicare Single+1 Non-Medicare $1,082.27 1 $1,082.27 $1,190.50 1 $1,190.50 $1,136.38 1 $1,136.38
PPO Total 236 $334,116.01 PPO Total 236 $367,527.61 PPO Total 236 $350,821.81
Dental
Dental O tion I
Single $43.64 51 $2,225.64 $45.39 51 $2,314.67 $44.51 51 $2,270.15
Single+1 $73.47 37 $2,718.39 $76.41 37 $2,827.13 $74.94 37 $2,772.76
Fairrity $123.21 119 $14,661.99 $128.14 119 $15,248.47 $125.67 119 $14,955.23
Single Retiree<65 $43.64 21 $916.44 $45.39 21 $953.10 $44.51 21 $934.77
Retiree<65+1<65 $73.47 26 $1,910.22 $76.41 26 $1,986.63 $74.94 26 $1,948.42
Retiree<65+Fairrity $123.21 4 $492.84 $128.14 4 $512.55 $125.67 4 $502.70
Dental Total 258 $22,925.52 Dental Total 258 $23,842.54 Dental Total 258 $23,384.03
Benefit Fund Distribution
Credit/Debit $0.00 $0.00 $0.00
Total $0.00 Total $0.00 Total $0.00
Terminal Reserve Activity
Credit/Debit $0.00 $0.00 $0.00
Total $0.00 Total $0.00 Total $0.00
Total $372,427.05 Total $407,754.27 Total $390,090.66
*Total2011-2012 premium number on bottom of finding sheet may not match your ACH debit due to your reported changes in enrollment
Page 1
VILLAGE OFI uu NON°
BUFFALO GROVE
ikv� � Cupp Blvd.
V'x iI`f Io(�r,ivv D L WON 2196
MEMORANDUM
TO: Dane C. Bragg, Village Manager
FROM: Arthur A. Malinowski, Jr., Esq., Human Resources Director
DATE: September 19, 2012
RE: 2013 Employee Medical, Dental and Life Insurance Premium Recommendations.
The Village is a member of the Intergovernmental Personnel Benefits Cooperative (IPBC)
which coordinates the procurement and support of employee benefits to over 60 area units of
local government. To assist staff in the development of the 2013 Village budget, the IPBC has
provided staff with the following recommendations regarding the 2013 employee medical, dental
and life insurance premiums. It is important to note that the employee contribution to the medical
insurance premium will increase to 12.0% on January 1, 2013.
(1) Medical Insurance
HMO: 8.0% Increase in 2013, resulting in an increase of approximately $12,000 for 2013,
of which at least$1,500 is absorbed via employee contributions.
PPO-A: 10.0% Increase in 2013, resulting in an increase of approximately $150,000 for
2013, of which at least$18,000 will be absorbed via employee contributions and $15,000
via retiree contributions.
PPO-B: 10.0% Increase in 2013, resulting in an increase of approximately $250,000 for
2013, of which at least$30,000 will be absorbed via employee and $25,000 via retiree
contributions.
(2) Dental Insurance:
4.0%Increase in 2013, resulting in an increase of approximately $12,000 for 2013, of
which at least$1,200 is absorbed via retiree contributions.
(3) Life Insurance (Standard)
No Rate Change in 2013.
The gross increase is expected to total $424,000, of which approximately $49,500 will be offset
by employee contributions and $41,200 by retiree contributions for an expected net increase to
the Village of$333,300.
I am available to discuss this matter with you at your convenience.
Golf Course Financials for January 1, 2012 through August 2-E
31, 2012
Overview
While the golf industry still remains very competitive both Arboretum and Buffalo Grove Golf are
experiencing slight improvements in revenues in 2012 from the same time period in 2011.
Buffalo Grove Golf has shown an overall 11%increase in revenues in 2012 over the corresponding period
in 2011.While play levels were a bit slower in mid days during the near 50 days of over 90 degree
temperatures we at least did not have more than one or two days when we had to close totally due to
flooding.While overall it appears that total revenue for the year 2012 may fall slightly below budgeted
levels staff has managed the expense side of the ledger to at least maintain a break even financial position
for the fiscal year 2012. Savings in labor and other smaller project areas should be able to make up for
any shortfalls in revenue for the year. As of September first Buffalo Grove has captured 70%of budgeted
revenues while expending about 57 %of the allotted budget amounts.
Arboretum Club has shown an overall 6%increase in revenues in 2012 over the corresponding period in
2011. Arboretum has been able to maintain the excellent pace it had in 2011 and seems to be following
that excellent season up with another excellent season. It appears that Arboretum will come very close to
overall budgeted revenues for the year 2012. As of September first Arboretum has captured 75%of
budgeted operating revenues while expending about 65%of allotted budget amounts.
As an Enterprise Fund,both courses looked at as one;the Golf Department has collected$1,770,00 in
revenue as of September 1st. This represents about 71%of anticipated revenue for the fiscal year 2012.
On the expense side of the ledger Golf Enterprise has spent$1,510,000 as of September 1st. This
represents about 60%of budgeted expenses. It is felt that as an Enterprise fund the Golf Department could
provide a very slight positive cash flow back into the operations for the year 2012.While rounds seem to
be rebounding at Buffalo Grove more discounting than in previous years is taking place due to increased
competition and the ease of finding lower rates at all courses through electronic means. Management of
the expenditure side of the budget equation will remain of vital importance while the discounting of
greens fees continues nation wide.
Attachments
Golf Course Info.pdf
Trustee Liaison Staff Contact
Trustee Trilling Carmen A Molinaro,
....M.on.da...........Se......ptem.be.r..24......2.0.1..2...........................................................................................D.'sc uss.'.o.n...._...Ite.m........2._E........................................................................................................................................................
Y,
Arboretum Revenues and Expenses
Revenue Expenses
1/1/2011-8/31/2011 828000 807000
1/1/2012-8/31/2012 878000 809000
Arboretum Golf Course
IIIIIIIIIRevenue IIIIIIIIIExpense
878000
828000 807000 809000
1/1/2011-8/31/2011 1/1/2012-8/31/2012
Buffalo Grove Revenues and Expenses
Revenues Expenses
1/1/2011-8/31/2011 794000 818000
1/1/2012-8/31/2012 892000 695000
Buffalo Grove Golf Course
IIIIIIIIIRevenue IIIIIIIIIIExpense
$892,000.00
$794,000.00 $818,000.00
$695,000.00
1/1/2011-8/31/2011 1/1/2012-8/31/2012
Buffalo Grove Golf Club
Rounds
1/1/2011-8/31/2011 31100
1/1/2012-8/31/2012 33310
Buffalo Grove Club Rounds Played
33500
33310
33000
32500
32000
31500 Rounds
31000 3.1100
30500
30000
29500 ........................................................................................................................................................................................................................................................................................
1/1/2011-8/31/2011 1/1/2012-8/31/2012
Aboretum Club
rounds
1/1/2011-8/31/2011 23360
1/1/2012-8/31/2012 24160
Arboretum Club Rounds Played
24400 ..
24200 .. 24160 ....
24000
23800
23600
23400 rounds
23200 ..
23000 ..
22800 ..........................................................................................................................................................................................................................................................................................
1/1/2011-8/31/2011 1/1/2012-8/31/2012
2012 Budgetary Goal Progress 2-F
Overview
Village department directors will provide a brief overview on their progress toward the 2012 department
goals that were included in this year's budget.
Attachments
Trustee Liaison Staff Contact
Trustee Berman Dane C Bragg,
....M.o�n.d�a...........S�e......pte�m.be.r..24......2.0.1..2...........................................................................................D.��s�cu�s�s.�.o.n...._...Ite.m....�....�._��.........................................................................................................................................................
Y,