HomeMy WebLinkAbout11.17.14 PacketCITY COUNCIL REGULAR MEETING
CITY OF EVANSTON, ILLINOIS
LORRAINE H. MORTON CIVIC CENTER
COUNCIL CHAMBERS
Monday, November 17, 2014
7:00 p.m.
ORDER OF BUSINESS
(I) City Council Roll Call – Begin with Alderman Braithwaite
(II) Mayor Public Announcements and Proclamations
Perennials Celebrates 25th Anniversary
Child Care Center of Evanston Celebrates 70th Anniversary
(III) City Manager Public Announcements
Paint Evanston Plows Awards
Evanston Entrepreneurship Week, November 17 – 23
“Mini Abe” Lincoln Visit to Evanston, November 29, 2014
(IV) Communications: City Clerk
(V) Public Comment
Members of the public are welcome to speak at City Council meetings. As part of the Council
agenda, a period for public comments shall be offered at the commencement of each regular
Council meeting. Those wishing to speak should sign their name and the agenda item or topic to
be addressed on a designated participation sheet. If there are five or fewer speakers, fifteen
minutes shall be provided for Public Comment. If there are more than five speakers, a period of
forty-five minutes shall be provided for all comment, and no individual shall speak longer than three
minutes. The Mayor will allocate time among the speakers to ensure that Public Comment does not
exceed forty-five minutes. The business of the City Council shall commence forty-five minutes after
the beginning of Public Comment. Aldermen do not respond during Public Comment. Public
Comment is intended to foster dialogue in a respectful and civil manner. Public comments are
requested to be made with these guidelines in mind.
(VI) Special Orders of Business
(VII) Call of the Wards
(Aldermen shall be called upon by the Mayor to announce or provide information
about any Ward or City matter which an Alderman desires to bring before the
Council.) {Council Rule 2.1(10)}
(VII) Executive Session
(IX) Adjournment
1 of 73
City Council Agenda November 17, 2014 Page 2 of 3
SPECIAL ORDERS OF BUSINESS
(SP1) Snow Awareness Week 2014
The City Manager’s Office and Public Works Department have developed plans
for a weeklong Snow Awareness campaign to take place from November 17-21.
For Discussion
(SP2) Implementation Plan and Related Issues for Ordinance 66-O-14, Enacting a
Regulation on Disposable Plastic Shopping Bags
Staff will provide a presentation and seek input on key elements of the
implementation plan.
For Discussion
(SP3) Resolution 87-R-14 Accepting Participation in the Divvy Bike Share
Expansion and Authorizing the City Manager to Negotiate an
Intergovernmental Agreement with City of Chicago to Implement the
Program
Staff recommends City Council adoption of Resolution 87-R-14 accepting
participation in the Divvy Bike Share Program and authorizing the City Manager
to negotiate an intergovernmental agreement with City of Chicago to implement
the program. Staff also seeks feedback on the proposed sponsorship approach
and process for finalizing the Divvy station locations. A cost match in the amount
of $80,000 to match funding provided by the State of Illinois Department of
Transportation is budgeted for FY 2015 in the Parking Fund Account BU:
505.19.7005.62603.
For Action
(SP4) FY2014 3rd Quarter Budget Report
Staff recommends City Council accept and place the Third Quarter Financial
Report for FY 2014 on file.
For Action: Accept and Place on File
(SP5) FY2015 Budget Presentation
Staff recommends that the City Council consider suggested revisions to the
Proposed 2015 Budget. No final action will be taken regarding the FY2015
Proposed Budget. This is a continuation of the Council budget discussion begun
on October 20, 2014. Budget documents are available here:
http://www.cityofevanston.org/city-budget/
For Discussion
(SP6) For Appointment to:
Environment Board Marcus Banks
Ladd Arboretum Committee Antonia Stoimenova
Preservation Commission Julie Hacker
Preservation Commission Timothy Schmitt
For Action
10/24/2013 6:42 PM 2 of 73
City Council Agenda November 17, 2014 Page 3 of 3
MEETINGS SCHEDULED THROUGH NOVEMBER 2014
Upcoming Aldermanic Committee Meetings
Tues, Nov 18 7:30 pm Housing & Community Dev Act Ctte
Wed, Nov 19 6 pm Transportation/Parking Committee
Wed, Nov 19 6:30 pm M/W/EBE Advisory Committee
Wed, Nov 19 7:30 pm Economic Development Committee
Fri, Nov 21 7 am Housing & Homelessness Commission
Mon, Nov 24 6 pm A&PW, P&D, City Council meetings
Order and agenda items are subject to change.
Information is available about Evanston City Council meetings at: www.cityofevanston.org/citycouncil.
Questions can be directed to the City Manager’s Office at 847-866-2936. The City is committed to
ensuring accessibility for all citizens. If an accommodation is needed to participate in this meeting, please
contact the City Manager’s Office 48 hours in advance so that arrangements can be made for the
accommodation if possible.
10/24/2013 6:42 PM 3 of 73
For City Council meeting of November 17, 2014 SP1
Snow Awareness Week
For Discussion
To: Honorable Mayor and Members of the City Council
From: Jim Maiworm, Assistant Director Of Public Works O & M
Cindy Plante, ICMA Local Government Management Fellow
Subject: Snow Awareness Week 2014
Date: November 17, 2014
Summary:
The City of Evanston and surrounding communities saw record-breaking snowfall during
the 2013-2014 winter season. Based on the feedback residents provided through 311
requests and a survey on snow operations, the City Manager’s Office and Public Works
developed plans for a weeklong Snow Awareness campaign to take place from
November 17-21 in order to remind residents and businesses of their responsibilities
during winter weather.
The Citizen Engagement Team developed a bilingual mailer on snow preparedness,
including information on snow removal operations, sidewalk shoveling, parking
regulations, and utilities. As with other Evanston Life publications, the mailer was sent
to every household mailing address in town. Business addresses were included in the
mailing as well, as part of ongoing efforts to communicate parking and snow removal
information to local businesses and employers.
In order to boost participation in email and text notifications regarding snow-related
parking restrictions, several changes were made to promote these services more
prominently on the City website. When users search the website for snow or parking
information, a popup reminder asks them to sign up for email or text notifications. An
opt-out dialogue was also added to the online forms for annual wheel tax and residential
parking. Residents will also be able to get a response about snow parking 24/7 by
texting “SNOW” to 847-448-4311.
In addition to these efforts, the Citizen Engagement team plans to post several short
Snow Awareness videos and graphics to City Facebook, Twitter, and Instagram
accounts throughout the week.
Memorandum
4 of 73
For City Council meeting of November 17, 2014 Item SP2
Disposable Shopping Bag Ordinance Implementation
For Discussion
To: Honorable Mayor and Members of City Council
From: Catherine Hurley, Sustainable Programs Coordinator
Suzette Robinson, Public Works Director
Subject: Implementation Plan and Related Issues for Ordinance 66-O-14, Enacting
a Regulation on Disposable Plastic Shopping Bags
Date: November 12, 2014
Recommended Action:
Staff is developing a multi-pronged implementation plan to support the community and
impacted businesses with the transition away from point-of-sale disposable plastic
shopping bags. Staff will provide a presentation and seek input on key elements of the
implementation plan, which include the following: outreach to impacted stores and
compliance tracking, enhancing plastic film and bag recycling opportunities, increasing
access to reusable bags through bag giveaway’s and share-a-bag program and public
outreach and education campaign.
Legislative History:
On Monday, July 28, the Evanston City Council approved ordinance 66-O-14 prohibiting
the distribution of point-of-sale disposable plastic shopping bags in Evanston stores
larger than 10,000 square feet. The ordinance applies to chain and franchise stores
and will take effect on August 1, 2015. Dine-in and take-out restaurants, as well as non-
chain stores, are exempt.
Memorandum
5 of 73
Item SP3 For City Council meeting of November 17, 2014
Resolution 87-R-14: Regional Bike Share System Grant Acceptance
For Action
To: Honorable Mayor and Members of the City Council
From: Catherine Hurley, Sustainable Programs Coordinator
Rickey Voss, Revenue/Parking Manager
Subject: Resolution 87-R-14 Accepting Participation in the Divvy Bike Share
Expansion and Authorizing the City Manager to Negotiate an
Intergovernmental Agreement with City of Chicago to Implement the
Program
Date: November 1, 2014
Recommended Action:
Staff recommends City Council adoption of Resolution 87-R-14 accepting participation
in the Divvy Bike Share Expansion to Evanston and authorizing the City Manager to
negotiate an intergovernmental agreement with City of Chicago to implement the
program expansion. Staff also seeks feedback on the proposed sponsorship approach
and process for finalizing the Divvy station locations.
Funding Source:
A cost match in the amount of $80,000 is required to match the funding provided by the
State of Illinois Department of Transportation and is budgeted for FY 2015 in the
Parking Fund Account BU: 505.19.7005.62603. Staff will also be exploring financial
support from community partners as outlined below.
Summary:
The City of Evanston is partnering with the City of Chicago and the Village of Oak Park
to expand the Divvy bicycle-sharing program (Divvy) to Evanston. This expansion is
being made possible by a $3 million investment from the State of Illinois Department of
Transportation to add 700 new bikes and 70 docking stations in Evanston, Oak Park
and Chicago neighborhoods. The City of Evanston would be awarded 80 bicycles at
eight docking stations.
The City of Chicago launched Divvy in the spring of 2013 and has 3,000 bikes and 300
stations across Chicago. Divvy provides individuals with access to bicycles for short-
term use at automated bicycle rental stations and is designed for short point to point
journeys, aiming to provide a transportation alternative to driving, transit or walking and
cover that last mile gap between a transit station and one’s destination.
Memorandum
6 of 73
Resolution 87-R-14 accepts participation in the Divvy expansion to Evanston and
authorizes the City Manager to negotiate an intergovernmental agreement with the City
of Chicago on the program expansion. Staff expects to bring the proposed
intergovernmental agreement to City Council by the end of the year. Once an
agreement is reached, staff will work with the City of Chicago to place the order for the
Divvy equipment. The delivery time for the equipment is 5 ½ months from the time the
order is placed.
Table 1 provides an estimate of capital and operating costs for Evanston’s Divvy
program. The City’s 2015 budget includes funds for both the City’s cost match and net
operating costs, which will be provided out of the Parking Fund.
Table 1 – Estimated Capital and Operating Costs for
Evanston Divvy Bike Share Program
Estimated Capital Budget
Description Cost /
Station
Total Cost
(8 stations)
Equipment & installation for 8 bicycle share
stations $ 54,000 $ 432,000
Evanston Cost Match ($ 80,000)
Annual Estimated Operating Budget
Description Cost /
Station
Total Cost
(8 stations)
Operating Costs $ 24,000 ($ 192,000)
Operating Revenue
$ 125,400
(65% of
Operating Cost)
Net Operating Cost ($ 66,600)
Bike share systems in the U. S. are recovering between 50% and 120% of operating
costs through user fees, advertising and sponsorships. Systems similar in size to
Evanston, such as the Arlington County, Virginia System, average 70% to 80% cost
recovery. Cost recovery is in large part dependent on the overall success of the
program and can be further advanced with community partnerships and sponsorships.
Sponsorships:
Capital and operating expenses for Evanston’s Divvy program can be supported
through sponsorships from Evanston businesses and community partners. In addition,
funding can be secured to provide bicycle education and awareness initiatives which
can complement the bike share infrastructure and help address the anticipated
increased amount of bicycle traffic on Evanston streets. Based on the common
sponsorship options from other bike share cities, staff proposes the following tiered
sponsorship approach to secure funds for Evanston’s Divvy program. The costs and
7 of 73
benefits of each sponsorship level are outlined in Attachment 2. Pending City Council’s
approval, staff will reach out to Evanston’s largest employers and other businesses
regarding sponsorship opportunities for the expansion of Divvy to Evanston.
Table 2 – Proposed Sponsorship Levels for
Evanston Divvy Bike Share Program
Tier Sponsorship Description
Tier 1 - Sustaining
Partner
Support bike education and awareness initiatives to promote
wellness, safe mobility, and livability in Evanston.
Tier 2- Capital
Sponsor
Support the installation of a bike share station, working with the
City to locate the station at a desired location.
Tier 3 - Adopt a
Station Sponsor
Support the operation and maintenance of an existing available
station.
Tier 4 - Community
Partner
Support the overall Divvy Evanston program with a gift of any
size.
Tier 5 - Friends of
Divvy
Support discounted or complementary Divvy passes to
community members who would otherwise not be able to
participate in bike share.
Divvy Station Location Overview:
Funding provided by the State of Illinois to expand Divvy to Evanston will cover the cost
for 8 stations with approximately 80 bicycles. Possible locations for the Divvy stations
were identified during the initial grant application with the City of Chicago and Village of
Oak Park. Following Evanston’s initial grant application, staff has continued to evaluate
options for locating the initial eight bike share stations. The survey part of the Bike Plan
Update included questions regarding top destinations for bike share stations. Staff also
reviewed locations suggested by the community on Divvy’s website at
http://suggest.divvybikes.com/. Additionally, in the spring of 2014, staff worked with two
groups of Northwestern University Industrial Engineer students for their capstone
project to evaluate possible locations for Divvy stations. A summary of the 2014 Bike
Plan Update survey data and Northwestern University student analysis can be reviewed
in Attachment 3.
Figure 1 below provides a consolidation of the key Divvy station locations considered to
date. Locations have been plotted from the original grant application, student team
analysis and the preliminary locations that City of Chicago is planning on Howard Street
in Chicago. The orange circles depict staff’s current proposed consolidated locations
for Divvy stations. These circles represent a two or three block radius where the Divvy
station could be located. The consolidated locations were selected based on the
following criteria/constraints:
• Split station locations between transit hubs and destinations
8 of 73
• Provide station locations to maximize coverage of the City
• One station near lakefront
• Relocate Evanston station identified during grant application from Howard Street
since Chicago plans to place one nearby
Figure 1 – Consolidated Divvy Station Locations
9 of 73
In order to finalize the locations for each Divvy station, staff proposes a two phase
community outreach process. Phase 1 will focus on finalizing the location of the regions
for each Divvy bike share station and conducting general education and outreach about
Divvy bike share to the community. In Phase 2, staff from across relevant departments
would work to evaluate the specific sites for the Divvy stations to be installed within the
identified regions with targeted outreach to businesses and neighbors near the specific
sites. Specific items under each phase are outlined below:
Phase 1 – Finalize Regions for Divvy Stations
• Hold one public meeting on Divvy bike share expansion to Evanston
• Conduct on-line survey to collect community input for stations
• Present finalized recommendation for station regions to City Council in January
Phase 2 – Divvy Site Selection
• Work across City Departments to identify specific site for station within identified
regions
• Presentation to Ward Meetings
• Meet with Alderman, adjacent businesses or organizations to review selected
sites
• Host “corner talks” with neighbors and public to talk about placement of stations
and generate awareness and interest
The results of Phase 1 would be presented to City Council in January. Staff will then
begin Phase 2 to select the specific sites within identified regions for each Divvy station
and prepare for the equipment installation.
Next Steps:
Staff seeks authorization for the City Manager to negotiate an intergovernmental
agreement with City of Chicago to implement the Divvy program expansion. Staff also
seeks authorization to proceed with outreach to business and community partners
regarding sponsorship opportunities for Evanston’s Divvy program and to move forward
with a two-phased approach to finalize the Divvy station locations.
Evanston is the leader in suburban Chicagoland for bicycle infrastructure and has been
recognized nationally as a bicycle friendly community. Bringing Divvy to Evanston will
create a truly regional bike share system and will benefit residents, visitors and local
employers.
Attachments:
Attachment 1 – Resolution 87-R-14
Attachment 2 – Evanston Divvy Bike Share Sponsorship Opportunities
Attachment 3 – 2014 Bike Plan Update survey data and Northwestern University
student analysis
10 of 73
10/29/2014
87-R-14
A RESOLUTION
Accepting Participation in the Expansion of Divvy Bike Share from
Chicago to Evanston and Oak Park Communities and Authorizing the
City Manager to Negotiate an Intergovernmental Agreement with the
City of Chicago to Implement the Program Expansion
WHEREAS, Governor Pat Quinn pledged a $3 million state investment in
the Divvy bicycle-sharing program to expand the green transportation option by adding
700 new bikes and 70 docking stations in the City of Evanston, Village of Oak Park and
City of Chicago neighborhoods; and
WHEREAS, the investment will be supported by an additional $750,000
from the three communities; the City of Chicago will be investing $550,000 and
Evanston and Oak Park will be investing $200,000 between them for the expansion
program; and
WHEREAS, Evanston will be receiving a total of 8 docking stations and
seeks to formalize its participation in the Divvy bicycle expansion program; and
WHEREAS, pursuant to Section 10 of Article VII of the Illinois Constitution
of 1970, and the Illinois Intergovernmental Cooperation Act, 5 ILCS 220/1 et seq., public
agencies may contract or otherwise associate among themselves, or transfer any power
or function, in any manner not prohibited by law or ordinance; and
WHEREAS, the City of Evanston (“City”) and the City of Chicago
(“Chicago”) are “public agencies” within the meaning of the Illinois Intergo vernmental
Cooperation Act; and
11 of 73
87-R-14
- 2 -
WHEREAS, Chicago has a contractual relationship with the operator of
the Divvy bicycle share program, Alta Bicycle Share, Inc., and the City seeks to
negotiate an Intergovernmental Agreement with Chicago to formalize the terms upon
which Evanston will participate and receive the docking stations; and
WHEREAS, the City Council of the City of Evanston has determined that the
best interests of the City of Evanston would be served by authorizing the City Manager to
negotiate an intergovernmental agreement with the City of Chicago for the aforementioned
purpose,
NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF
THE CITY OF EVANSTON, COOK COUNTY, ILLINOIS THAT:
SECTION 1: The City Council pledges its support and acknowledges its
participation in the expansion of the Divvy bike share program into the City of
Evanston and the Village of Oak Park and further extension to more neighborhoods
within the City of Chicago.
SECTION 2: The City Manager and designated staff are hereby
authorized to negotiate an intergovernmental agreement with the City of Chicago to
outline the program enlargement opportunity and the agreement will be presented for
your consideration and approval at a later date.
SECTION 3: This resolution shall be in full force and effect from and after
its passage and approval, in the manner provided by law.
______________________________
Elizabeth B. Tisdahl, Mayor
12 of 73
87-R-14
- 3 -
Attest:
______________________________
Rodney Greene, City Clerk
Adopted: __________________, 2014
13 of 73
Evanston Divvy Bike Share Program Partnership and Sponsorship Information
The City of Evanston is interested in working with community partners to invest in a bicycle
sharing program for Evanston. Bicycle sharing is a new form of public transit that will benefit
residents, employees and visitors alike and working together as a community will help support
long-term success of the program.
Tier 1 - Sustaining Partner
Support bike education and awareness initiatives and promote wellness, safe mobility,
and livability in Evanston
Benefits
• Prominent logo and link to company website on City of Evanston & Divvy websites
• Logo on Divvy system map at all stations
• Logo on printed materials, including membership information, bike outreach & safety
information, sponsorship packet, annual report, and other materials
• Recognition in press releases, electronic newsletters and other communication pieces from the
City in relation to the Divvy bike share expansion to Evanston
• Press release announcing the partnership
• Invitation to participate in semi-annual sponsor forums to discuss Evanston Bike Share
operations and outreach
• Complementary discount of $10 per membership for employees for the duration of the
sponsorship
Pricing
• $25,000 per year, with a three-year commitment
o For category exclusivity, $35,000 per year with a three-year commitment
Tier 2- Capital Sponsor
Support the installation of a bike share station, working with the City to locate the station
at sponsor’s location of choice
Benefits
• Placement of a station near your building or location of choice
• Logo on both sides of the map frame at selected station
• Logo and website link on Divvy Bike Share interactive map www.divvybikes.com/stations
• Logo and website link on City of Evanston bike share webpage
• Press release announcing station sponsorship
• Invitation to participate in semi-annual sponsor forums to discuss Evanston Bike Share
operations and outreach
• 100 complementary Divvy memberships for the first year following station installation
14 of 73
Pricing
• $56,000 per station
• $60,000 per station with 12-month advertising on station map panel
Tier 3 - Adopt a Station Sponsor
Support the operation and maintenance of an existing available station
Benefits
• Logo on Divvy system map at adopted station
• Logo and website link on Divvy Bike Share interactive map www.divvybikes.com/stations
• Logo and website link on City of Evanston bike share webpage
• Invitation to participate in semi-annual sponsor forums to discuss Evanston Bike Share
operations and outreach
Pricing
• $10,000 per station per year, with a 2-year commitment
• $14,000 per station per year with advertising on map panel, with a 2-year commitment
Tier 4 - Community Partner
Support the overall Divvy Evanston program with a gift of any size
Benefits
• Logo and link to company website on City of Evanston website and Divvy website
o Logo size commensurate with contribution
• Recognition in annual report
Pricing
• Donation of $1,000 or greater will earn logo and website link; smaller donations will be
recognized with company/donor typed name
Tier 5 - Friends of Divvy
Support discounted or complementary Divvy passes to community members who would
otherwise not be able to participate in bike share
Benefits
• Name listed on City of Evanston website
• Recognition in annual report
Pricing
• Donation of any quantity to help give the gift of Divvy to members of the community that would
otherwise not be able to participate
15 of 73
Attachment 3
Summary of Survey Responses from 2014 Bike Plan Update
Survey Questions on Divvy Bike Share System
Given what you currently know about bike share systems like Divvy, would you use it?
Answer Options Response
Percent
Response
Count
Yes 59.1% 1062
No 40.9% 736
answered question 1798
skipped question 183
Where would you prefer the Divvy system be installed? Please pick two.
Answer Options Response
Percent
Response
Count
Train Stations 83.5% 1365
Business Districts 50.6% 826
Lakefront 37.8% 618
Northwestern University 33.5% 548
Other (please specify) 94
answered question 1634
skipped question 347
16 of 73
Spring 2014 Northwestern University Capstone Projects
Analysis of Divvy Bike Share Station Locations
Bike Share Overview:
A bike share program is a service where individuals have access to bicycles for short-
term use. Systems like Chicago’s Divvy program provide bicycles for short-term use at
automated bicycle rental stations. Individuals may use any bicycle parked at the station,
and return the bicycle to any other station within the system. This system is designed for
short point to point journeys and aims to provide a transportation alternative to driving,
transit or walking. A bike share program is also designed to solve the “last mile”
problem, which refers to the difficulty for individuals to get to their final destination from
a public transport hub such as bus stops and train stations. A strategically planned bike
share system will help connect people on the last mile of their travel journey or serve as
an alternative to other forms of transportation. Bike share programs have many benefits
including reducing fuel use and greenhouse gas emissions, promoting health and active
living and providing a low cost transportation alternative.
Divvy – Chicagoland Regional Bike Share:
The City of Chicago launched Divvy bike share in the spring of 2013 to provide
residents and visitors with an additional transportation option for getting around the city.
Divvy has 300 stations with 3,000 bikes and plans to add another 175 stations next
spring. The bike share program infrastructure is owned by the City of Chicago and
operated and maintained by Alta Bikeshare. The cities of Evanston and Chicago and
the Village of Oak Park secured $3,000,000 to purchase and install bike share stations
to expand the Divvy program to Evanston and Oak Park and additional neighborhoods
in Chicago.
Northwestern University Student Analysis for Divvy Station Locations:
Following Evanston’s initial grant application for Divvy bike share funding, the Office of
Sustainability engaged with two groups of Industrial Engineer students for their
capstone project at Northwestern University to assist with locating the initial 8 bike
share stations. The two teams created numerical models and summarized their findings
in a detailed, data-driven report with their recommendations for the logical placement of
eight Divvy bike stations throughout Evanston. These reports are now serving as a
resource for the City of Evanston in selecting the locations for Divvy stations as the
program expands. Each groups report can be viewed at the following links:
Green Team Final Report
Blue Team Final Report
Evaluation Facts and Weights:
Both groups determined that the best approach to locating the Divvy stations would be
to develop evaluation criteria and assign each criterion a weight to reflect its importance
in evaluating the Divvy station sites. The criteria were identified by researching other
bike-share programs in similar cities, namely Arlington, VA and Chicago, and contacting
individuals familiar with the programs’ success. They determined that employment and
population density, proximity to public transit, and parks/landmarks (notably the
lakefront) were the greatest drivers of Divvy Bike usage, and thus commanded the
largest weights in their models. Coupling this information with their models, they created 17 of 73
maps showing their suggested locations (regions, not intersections) for Evanston’s eight
Divvy bike stations. Their maps differed depending on the weights assigned to the
criteria they chose to evaluate. Charts showing the considerations and their respective
weights used by each group can be found in Attachment 1. Additionally, the two groups
used a different approach in selecting the initial bike share locations for which to
evaluate. The Green Group considered all intersections as possible placements for
stations, while the Blue Group considered only intersections along bike routes or near
transit and landmark areas.
Location Constraints:
Constraints were the second factor used to determine the sites each group selected.
Given that eight stations are unable to sufficiently accommodate all areas of Evanston,
constraints play a pivotal role in spreading the sites out from the most intuitive
downtown and transit locations as recognized by their models. Both groups
implemented constraints requiring a minimum amount of stations to be located at
certain sites (parks, transit, and schools). The two groups also installed spacing
constraints between any two stations. The Blue Group required that the minimum and
maximum distance between any two stations be 1310 and 5250 feet respectively. The
Green Group came up with a graduated minimum distance constraint. They allowed for
a smaller minimum distance for any stations in downtown Evanston and the immediate
areas surrounding the downtown (.3 miles), and a larger distance for the rest of
Evanston (.5 miles). Both of these spacing constraints allow for more compressed
station locations in the more frequented regions of Evanston, while at the same time
forcing some stations to be placed farther west in order to incorporate more potential
Divvy bike users (a more detailed explanation of each groups' constraints can be found
in Attachment 1). The different station sites each group came up with are a combination
of their unique model weights as well as the constraints they enforced.
Physical Placement
Once an appropriate region for a Divvy station has been identified, an intersection in
that region needs to be chosen that can actually accommodate a station. There are
several stipulations that guide this choice. First, the Divvy Station must be visible in
order to spread awareness and encourage use. Second, the intersection cannot be too
busy with traffic so as to put any riders at risk of injury. And finally, the intersection must
be large enough to house the dimensions (24.5’-12’) of the Divvy station. A
representative from Evanston’s Engineering Department will be required to evaluate
which intersection in each selected region can realistically contain a Divvy bike station.
Attachments:
Attachment 1 – Weights and Constraints for Station Location Evaluation
Attachment 2 – Divvy Bike Share Station Location Map
18 of 73
ATTACHMENT 1 – WEIGHTS AND CONSTRAINTS FOR STATION LOCATION
EVALUATION
GREEN GROUP
Weights
Category Overall Weight Evaluation Criteria Weight
Land Use 58%
Population Density 17%
Employment Density 17%
Schools 8%
Parks 8%
Grocery Stores 8%
Transit 32% CTA 16%
Metra 16%
Accessibility 10% Bike Lanes and Bike Routes 10%
Constraints
- A minimum of two stations at parks or schools within Evanston, including one
specifically at ETHS.
- A minimum of three stations at transit stops.
- A maximum of four stations at transit stops.
- Assumes the City of Chicago will add a ninth station at Howard transit stop to
connect Evanston and Chicago systems
- Coverage constraints involving the minimum and maximum distance between the
selected blocks were 400 meters and 1600 meters
BLUE GROUP
Weights
Category Overall Weight Evaluation Criteria Weight
Land Use 72%
Population Density 15%
Popular Landmarks 15%
Nonresidential Zones 12%
Residential Zones 9%
Residential/Nonresidential Zones 9%
Campus Zones 6%
Recreation Zones 3%
Station Zones 3%
Transit 27% Traffic 9%
Bus Boarding 9%
Constraints
- A Maximum of one station on Northwestern Campus.
- A Minimum of one station on Central Street.
- A Maximum of two stations in downtown Evanston.
- A maximum of two stations at public transit stops.
19 of 73
- A maximum of 0 stations on any border of Evanston.
- Assumes the City of Chicago will add a ninth station at Howard transit stop to
connect Evanston and Chicago systems.
- Distance Constraints between any two stations: Downtown Zone (1) - .3 miles,
immediate downtown surroundings (2) - .3 miles, the rest of Evanston (3) - .5 miles.
20 of 73
ATTACHMENT 2 – DIVVY BIKE SHARE STATION LOCATION MAP
21 of 73
7For the City Council Meeting of September 20, 2010
2nd Quarter Financial Report
For City Council meeting of November 17, 2014 Item SP4
Third Quarter Financial Report for Fiscal Year 2014
For Action: Accept and Place on File
To: Honorable Mayor and Members of the City Council
From: Martin Lyons, Assistant City Manager/Chief Financial Officer
Ashley Porta, Budget Manager
Subject: Third Quarter Financial Report for Fiscal Year 2014
Date: November 10, 2014
Recommended Action:
Staff recommends City Council accept and place the Third Quarter Financial Report for
FY 2014 on file.
Summary:
The City ended the third quarter of the 2014 fiscal year in stable financial condition.
Through September 30, 2014, there is a General Fund surplus of approximately $4.1 M.
The City’s financial performance is the result of revenues being above budgeted targets
and expenditures being slightly below budget.
Attached are summaries of the City’s funds for the third quarter of FY 2014. In
reviewing these reports, please note the following:
•A majority of the revenues are recorded at the time they are actually received
(permits, property taxes, fees, etc.), however, some revenues are recorded at the
time of notification of the revenue being earned by the City (sales, income,
telecommunications taxes, etc).
•State revenue sources are delayed by one to three months based on the revenue
source in question.
•While some revenues are received on a monthly basis, other revenues are
received less uniformly throughout the year. An example is property taxes, which
are billed bi-annually and then distributed by the County as payments are
received. This disbursal method contrasts with other revenue sources such as
sales taxes, which are collected by the State and distributed on a monthly basis.
•Operating expenses are incurred on a uniform basis for items such as payroll,
utilities, fuel, etc., and on an as needed basis for supplies, equipment and
specific outsourced services.
General Fund Revenues:
General Fund revenues through the September 30, 2014 were $70.2 M or 78.7% of
budget, or 3.7% above the 75% target. The third quarter performance of major General
Fund revenue sources is summarized below:
Memorandum
22 of 73
• Through June 30, 2014 property tax revenue was $12.1 M or 98.6% of budget.
Other than prior year property tax receipts, this should represent our collections
for the year.
• State income tax was recorded in the amount of $5,377,426 through September
30, 2014, achieving 76.0% of the budget target for this revenue item. State
income tax is typically received in arrears by one or two months.
• Regular and home-rule sales tax revenue in FY 2014 was $11,270,030, or 71.4%
of budget. Staff anticipates that December sales tax revenues will bring year-end
totals for these items closer to budget targets. These revenues were increased
by approximately $700,000 and are also slightly above the 9/30/13 revenue
amount for last year.
• Real estate transfer tax through September 30, 2014 totaled $2,030,175
achieving 70.6% of the budget target for this item. This budget was increased by
$725,000 from the 2013 level.
• Through September 30, 2014, licenses, permits, and fees were approximately
82.5% of budget. Total revenues equal $10.4 million. Given that Wheel tax
revenues of nearly $2.8 million have not been received yet, this revenue category
should exceed budget by year end.
General Fund Expenditures:
Through September 30, 2014, General Fund expenditures were $66,085,169 or 74.2%
of budget. It is important to note, for the General Fund, many expenditures /
disbursements are not made evenly throughout the year. For example:
• As noted in the monthly financial report, the City will also have three pay periods
in December 2014, and one payroll is approximately $2.6 million. If this level of
surplus remains constant, it will be partially utilized to cover the final additional
payroll in December (the City is not paying any additional payroll costs, this is
just an issue of timing between monthly reporting and bi-weekly payrolls)
Enterprise Funds:
Revenues and expenses for the Parking, Water, and Sewer Funds were all below the
75% budget target through September 30, 2014. Revenues in the Solid Waste Fund
were 74.1% of budget and expenses are running at 61.5% percent of budget, yielding
and operating surplus for the year of $413,051. Similar to the General Fund, many
enterprise fund revenues and expenses / disbursements do not occur evenly throughout
the fiscal year. For example, the majority of enterprise fund capital project expenses
are incurred throughout the summer months. Staff will continue to monitor and report
on the performance of City enterprise fund revenues and expenditures throughout FY
2014.
Attachments
Attachment 1: September 30, 2014 Monthly Financial Report
Attachment 2: September 30, 2014 Investment Report
- 2 -
23 of 73
To: Wally Bobkiewicz, City Manager
Martin Lyons, Assistant City Manager/Chief Financial Officer
From: Ashley Porta, Budget Manager
Andrew Villamin, Interim Accounting Manager
Subject: September 2014 Monthly Financial Report
Date: October 31, 2014
Please find attached the unaudited financial statements as of September 30, 2014. A
summary by fund for total revenues, expenditures/expenses, fund balances, and cash
balances is as follows:
YTD YTD YTD 9/31/2014 9/31/2014
9/31/2014 9/31/2014 9/31/2014 Unreserved Cash
Fund Name Fund # Revenue Expenses Net Fund Balance Balance*
General 100 70,160,789$ 66,085,169$ 4,075,620$ 20,438,571$ 10,328,206$
General Assistance Fund 175 875,636 502,671 372,965 372,965 372,965
Neighborhood Stabilization 195 1,383,717 897,725 485,991 485,991 454,187
Motor Fuel 200 1,691,447 1,484,868 206,579 1,519,147 2,003,939
Emergency 911 205 661,811 917,452 (255,641) 965,238 699,793
SSA#4 210 311,063 240,000 71,063 (78,272) (109,139)
CDBG 215 1,045,231 916,739 128,492 141,291 (33,431)
CDBG Loan 220 199,611 182,666 16,945 2,371,216 131,776
Economic Development 225 1,375,433 1,502,200 (126,768) 3,380,434 2,817,333
Neighborhood Improvement 235 - - - 149,915 149,915
Home 240 530,228 591,953 (61,725) 3,880,803 (51,551)
Affordable Housing 250 131,304 55,792 75,512 2,526,590 813,897
Washington National TIF 300 4,934,683 2,519,057 2,415,626 7,453,067 7,045,667
SSA#5 305 428,530 31,025 397,505 872,390 811,083
SW II TIF (Howard Hartrey)310 1,151,922 1,129,330 22,592 3,379,640 3,364,006
Southwest TIF 315 607,668 22,125 585,543 930,260 918,617
Debt Service 320 12,496,300 2,609,206 9,887,094 13,262,785 11,743,188
Howard Ridge TIF 330 480,517 803,551 (323,034) 65,583 53,930
West Evanston TIF 335 100,724 49,228 51,496 589,135 589,136
Dempster-Dodge TIF 340 - - - - -
Capital Improvement 415 9,838,320 3,786,008 6,052,311 12,352,310 12,936,638
Special Assessment 420 615,932 132,225 483,707 2,556,122 2,552,126
Parking 505 7,103,763 4,699,968 2,403,795 16,006,614 15,348,942
Water 510-513 14,757,372 10,945,700 3,811,672 12,401,763 11,192,012
Sewer 515 11,088,766 10,923,164 165,602 4,740,598 4,259,962
Solid Waste 520 3,680,760 3,267,710 413,051 (870,509) (1,279,425)
Fleet 600 2,388,860 2,323,372 65,487 176,053 (413,021)
Equipment Replacement 601 2,195,887 1,396,949 798,938 1,387,921 1,387,920
Insurance 605 13,489,668 12,926,258 563,410 (3,164,252) 1,624,013
Library 185 5,575,258 4,108,055 1,467,203 2,449,967 1,768,846
Library Debt Fund 186 739,506 53,724 685,782 685,782 685,782
Total**169,301,199$ 135,050,167$ 34,251,032$ 110,743,337$ 92,167,310$
*This is net of any interfund receivables/payables
**This summary does not include the Police or Fire Pension Funds even though detailed reports are included.
Memorandum
24 of 73
Included above are the ending balances as of September 30, 2014 for both unreserved
fund and cash balances. Of these two amounts, cash balance is the more meaningful
metric since this represents liquid cash and/or invested assets which may be used (or
easily sold) to support and fund current operations. While ending fund balance is also
an important measurement of the City’s financial health, it usually includes illiquid
assets or future cash receipts or disbursements such as receivables (including property
tax) due to the City and accounts payable/accrued expenses.
As of September 30, 2014, the General Fund is reporting a surplus of $4,075,620 due to
several factors:
Timing of payroll; the City will have 3 pay dates in December 2014
(December 4, 18 and 31)
Receipt of the Kellog building permit
Receipt of second installment property taxes
Through September 30, 2014, the Special Service Area (SSA) #4 Fund is showing a
negative cash balance of $109,139.
Through September 30, 2014, the Community Development Block Grant (CDBG) Fund
is showing a fund balance of $141,291 with a negative cash balance of $33,431. The
City expects HUD reimbursements to eliminate this negative balance in the next month.
Through September 30, 2014, the Economic Development Fund is showing a fund
balance of $3,380,434 and a cash balance of $2,817,333. These balances include
approximately $1 million of revenue associated with the Gigabit Challenge.
Through September 30, 2014, the Solid Waste Fund is operating at a $413,051 surplus
for the year; this fund will also have three pay periods in December, thus reducing the
surplus. There is still a negative balance of $870,509 and a negative cash balance of
$1,279,425 which is a $100,000 improvement over last month.
Though operating at a surplus for the year, through September 30, 2014 the Fleet Fund
is showing a negative cash balance of $413,021.
Through September 30, 2014, the Insurance Fund is showing a negative fund balance
of $3,164,252. This negative balance is primarily for claims/cases being reserved and
expensed. These claims/cases have not been settled, and therefore there is no
guarantee the City will actually experience this negative fund balance as estimated.
Please note, the City’s annual liability and property in surance payments, totaling
$601,314, were paid in January, which further reduced the fund balance of the
Insurance Fund. These payments will gradually be reimbursed through FY 2014 from
interfund transfers to the Insurance Fund. Staff will continue to monitor the Insurance
Fund and provide regular updates to the City Council in the future. The Insurance
Fund’s cash balance of $1,624,013 includes a transfer from the IPBC Health Insurance
Pool of $500,000.
If there are any questions on the attached report, please contact me by phone at (847)
859-7884 or by email: aporta@cityofevanston.org. Detailed fund summary reports can
25 of 73
26 of 73
Revenues Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget Budget Actual
% of
Budget
Property Tax 12,271,386$ 12,099,016$ 98.6%-$ -$ -$ -$ -$ -$ -$ -$
Sales Tax 15,790,000 11,270,030 71.4%- - - - - - - -
State Income Tax 7,076,170 5,377,426 76.0%- - - - - - - -
Utility Tax 8,220,000 6,189,164 75.3%- - - - - - - -
Real Estate Transfer Tax 2,875,000 2,030,175 70.6%- - - - - - - -
Liquor Tax 2,375,000 2,015,098 84.8%- - - - - - - -
Other Taxes 5,940,053 4,165,054 70.1%- - - - - - - -
Licenses, Permits, Fees 12,622,280 10,409,485 82.5%- - - - - - - -
Charges for Services 7,936,754 5,847,372 73.7%6,434,293 7,103,763 110.4%13,913,400 11,444,453 82.3%12,922,700 9,982,155 77.2%3,889,033 2,867,933 73.7%
Intergovernmental Revenues 721,272 900,730 124.9%- - - 14,181 - - 25,000 20,852 83.4%
Interfund Transfers 7,742,893 5,900,974 76.2%2,925,296 - 0.0%- - - - 1,055,967 791,975 75.0%
Other Non-Tax Revenue 5,614,490 3,956,265 70.5%2,034,004 - 0.0%6,413,816 3,298,738 51.4%2,191,000 1,106,611 50.5%- -
Total Revenues 89,185,298$ 70,160,789$ 78.7%11,393,593$ 7,103,763$ 62.3%20,327,216$ 14,757,372$ 72.6%15,113,700$ 11,088,766$ 73.4%4,970,000$ 3,680,760$ 74.1%
Expenditures
Legislative 677,621$ 516,985$ 76.3%-$ -$ -$ -$ -$ -$ -$ -$
City Administration 1,941,115 1,225,855 63.2%- - - - - - - -
Law Department 1,045,232 751,262 71.9%- - - - - - - -
Administrative Services Department 8,826,606 5,747,690 65.1%- - - - - - - -
Community Development 2,652,887 1,878,446 70.8%- - - - - - - -
Police Department 26,876,444 20,390,171 75.9%- - - - - - - -
Fire & Life Safety Services 14,072,488 10,717,354 76.2%- - - - - - - -
Health Department 3,009,286 2,295,145 76.3%- - - - - - - -
Public Works - Operating 17,884,613 13,332,100 74.5%10,714,333 4,699,968 43.9%- - - - 5,309,082 3,267,710 61.5%
Public Works - Capital Outlay - - 5,180,000 - 0.0%- - - - - -
Parks, Recreation & Comm. Services 10,483,281 9,230,161 88.0%- - - - - - - -
Capital Improvement Transfer 936,500 - 0.0%
Transfer to Debt Service Fund 609,000 - 0.0%- - - - - - - -
Utilities - Operating - - - - 13,451,635 6,291,231 46.8%13,006,620 9,136,365 70.2%- -
Utilities - Capital Outlay - - - - 10,538,100 4,654,469 44.2%3,272,500 1,786,799 54.6%- -
Total Expenditures 89,015,073$ 66,085,169$ 74.2%15,894,333$ 4,699,968$ 29.6%23,989,735$ 10,945,700$ 45.6%16,279,120$ 10,923,164$ 67.1%5,309,082$ 3,267,710$ 61.5%
As of September 30, 2014
Report of Budget-to-Actual Revenues and Expenditures
Parking Fund Water Fund Solid Waste FundSewer FundGeneral Fund
(Target is 75% of FY 2014 Budget)
27 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited
Budget YTD
Amended Actual Adopted Actual
Tax - Property 12,481,386$ 11,941,575$ 12,271,386$ 12,099,016$
Tax - State Use 1,176,879 1,283,156 1,241,753 879,826
Tax - Sales Tax - Basic 9,291,000 9,717,393 9,690,000 6,955,554
Tax - Sales Tax - Home Rule 5,861,800 5,964,747 6,100,000 4,314,476
Tax - Auto Rental 40,000 43,598 40,000 33,763
Tax - Athletic Contest 760,000 1,056,355 800,000 188,657
Tax - State Income 6,322,645 7,182,793 7,076,170 5,377,426
Tax - Electric Utility 3,069,806 3,000,629 3,070,000 2,226,067
Tax - Natural Gas Utility 1,400,000 1,090,915 1,200,000 1,228,881
Tax - Natural Gas Use - Home Rule 800,000 760,734 800,000 628,897
Tax - Cigarette 485,000 372,000 300,000 132,000
Tax - Evanston Motor Fuel 707,667 634,196 610,000 548,359
Tax - Liquor 2,350,000 2,261,874 2,375,000 2,015,098
Tax - Parking 2,200,000 2,418,852 2,350,000 1,801,147
Tax - Personal Property Replacement 591,600 721,173 598,300 581,302
Tax - Real Estate Transfer 2,146,300 3,940,899 2,875,000 2,030,175
Tax - Telecommunications 3,244,500 2,837,899 3,150,000 2,105,319
License Fees - Vehicles 2,600,000 2,349,686 2,700,000 534,018
License Fees - Other 1,030,502 1,427,835 937,302 749,811
Permit Fees - Building 3,020,000 3,951,048 6,142,162 6,048,546
Permit Fees - Other 1,209,788 1,746,109 1,486,716 1,945,441
Other Fees 1,559,350 1,152,473 1,356,100 1,131,669
Fines and Forfeiture Revenue 4,366,022 3,448,523 4,366,022 2,376,596
Charges for Services Revenue 7,904,198 7,845,651 7,936,754 5,847,372
Intergovernmental Revenue 786,798 1,425,907 721,272 900,730
Other Revenue 1,418,443 647,935 1,238,468 1,568,964
Interfund Transfers In (Other Funds)7,693,367 7,521,427 7,742,893 5,900,974
Interest Income 6,000 26,907 10,000 10,705
Total Revenue 84,523,051 86,772,289 89,185,298 70,160,789
Legislative 657,069 421,198 677,621 516,985
City Administration 1,582,580 1,818,451 1,941,115 1,225,855
Law Department 973,254 973,254 1,045,232 751,262
Administrative Services Department 7,721,650 8,546,089 8,826,606 5,747,690
Community Development 2,536,250 2,536,209 2,652,887 1,878,446
Police Department 26,508,585 26,508,583 26,876,444 20,390,171
Fire & Life Safety Services Department 14,142,078 14,142,077 14,072,488 10,717,354
Health Department 2,917,848 3,601,469 3,009,286 2,295,145
Public Works Department 10,043,463 11,186,023 17,884,613 13,332,100
Parks, Recreation & Community Services 17,616,397 14,744,293 10,483,281 9,230,161
Transfer to Solid Waste Fund - 1,245,967 936,500 -
Transfer to Debt Service Fund 1,000,000 1,000,000 609,000 -
Transfer to Fleet Maintenance Fund 600,000 600,000 - -
Transfer to Insurance Fund 500,000 500,000 - -
Total Expenditures 86,799,174 87,823,613 89,015,073 66,085,169
Net Surplus (Deficit)(2,276,123)$ (1,051,324)$ 170,225$ 4,075,620$
Beginning Unrestricted Fund Balance (Note 1) 17,033,487 16,362,951
Adjustment to GAAP Basis of Accounting 380,788 -
Total Ending Fund Balance 16,362,951$ 20,438,571$
Note 1: Unrestricted fund balance includes amounts designated for compensated absences and IMRF.
City of Evanston
General Fund
As of September 30, 2014
28 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Property Taxes 407,251$
Misc. Revenue - - 2,117
Transfers from other Funds - - - 466,269
Total Revenue - - - 875,636
Administration - - - 98,775
Client Payments - - - 403,896
Capital Outlay - - - -
Community Sponsored Org - - - -
Total Expenditures - - - 502,671
Net Surplus (Deficit)-$ -$ -$ 372,965$
Beginning Fund Balance - -
Ending Fund Balance -$ 372,965$
City of Evanston
General Assistance Fund
As of September 30, 2014
29 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Grant Proceeds 4,011,917$ 2,885,571$ 458,044$ 782,855$
Program Income - 347 - 600,135
Investment Income - - - 727
Total Revenue 4,011,917 2,885,918 458,044 1,383,717
Development Activities 3,505,000 2,653,385 290,500 567,694
Administration 341,622 128,520 126,635 252,114
Transfer to Debt Service 3,905 - 4,046 6,940
Transfer to Insurance 16,390 16,390 6,863 5,260
Transfer to General Fund 145,000 87,624 30,000 65,718
Total Expenditures 4,011,917 2,885,918 458,044 897,725
Net Surplus (Deficit)-$ 0$ -$ 485,991$
Beginning Fund Balance - -
Ending Fund Balance 0$ 485,991$
City of Evanston
Neighborhood Stabilization Fund
As of September 30, 2014
30 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
State Allotment 2,125,000$ 2,118,506$ 1,750,000$ 1,368,848$
Grant Revenue -$ -$ -$ 322,396$
Investment Earnings 2,000 482 500 202
Miscellaneous Income - - - -
Total Revenue 2,127,000 2,118,988 1,750,500 1,691,447
Street Resurfacing 1,400,000 972,788 1,400,000 860,118
Transfer to General Fund - Staff Engineering 133,000 133,000 133,000 624,750
Transfer to General Fund - Street Maintenance 700,000 700,000 700,000 -
Total Expenditures 2,233,000 1,805,788 2,233,000 1,484,868
Net Surplus (Deficit)(106,000)$ 313,200$ (482,500)$ 206,579$
Beginning Fund Balance 999,368 1,312,568
Ending Fund Balance 1,312,568$ 1,519,147$
City of Evanston
Motor Fuel Fund
As of September 30, 2014
31 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Landline Surcharge Revenue 617,400$ 549,934$ 529,200$ 388,510$
Wireless Surcharge Revenue 416,160 454,019 428,400 170,714
Interest Income 1,000 215 1,000 74
Grants 102,078
Miscellaneous Revenue - - - 435
Total Revenue 1,034,560 1,004,169 958,600 661,811
Operating Expense 891,122 785,259 935,767 636,089
Transfer to General Fund 125,950 125,950 125,950 94,462
Transfer to Insurance Fund 98,993 98,993 88,858 13,086
Transfer to Debt Service Fund 11,215 11,215 11,622 8,717
Capital Replacement 120,000 26,680 250,000 165,097
Total Expenditures 1,247,280 1,048,097 1,412,197 917,452
Net Surplus (Deficit)(212,720)$ (43,928)$ (453,597)$ (255,641)$
Beginning Fund Balance 1,264,807 1,220,879
Ending Fund Balance 1,220,879$ 965,238$
City of Evanston
E911 Fund
As of September 30, 2014
32 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Property Tax Revenue 370,000$ 337,668$ 370,000$ 311,060$
Investment Income - - - 4
Total Revenues 370,000 337,668 370,000 311,063
Professional Fees (Evmark)370,000 370,000 370,000 240,000
Total Expenditures 370,000 370,000 370,000 240,000
Net Surplus (Deficit)-$ (32,332)$ -$ 71,063$
Beginning Fund Balance (117,003) (149,335)
Ending Fund Balance (149,335)$ (78,272)$
City of Evanston
Special Service Area #4 Fund
As of September 30, 2014
33 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Intergovernmental/Entitlement 1,540,000$ $ 1,665,720 1,500,000$ $ 1,031,929
Funds Reallocated from Prior Years 33,100 - 168,088 -
Program Income 352,000 14,412 70,000 13,196
Miscellaneous - - - 106
Total Revenues 1,925,100 1,680,132 1,738,088 1,045,231
CDBG Administration/Planning 195,522 239,602 300,000 275,100
Development Activities 612,500 293,045 456,288 152,724
Capital Projects 494,800 493,581 410,800 583
Transfers to Debt Service - 2,928 - 2,276
Transfers to General Fund 781,278 650,976 571,000 486,056
Total Expenditures 2,084,100 1,680,132 1,738,088 916,739
Net Surplus (Deficit)(159,000)$ -$ -$ 128,492$
Beginning Fund Balance 12,799 12,799
Ending Fund Balance 12,799$ 141,291$
City of Evanston
CDBG Fund
As of September 30, 2014
34 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Intergovernmental Revenue -$ 205,904$ 50,000$ 162,278$
Program Income 9,000 3,554 10,000 37,283
Interest Income - - 100 50
Total Revenues 9,000 209,458 60,100 199,611
Program Expenses 20,000 - 20,000 182,666
Total Expenditures 20,000 - 20,000 182,666
Net Surplus (Deficit) (11,000)$ 209,458$ 40,100$ 16,945$
Beginning Fund Balance 2,144,813 2,354,271
Ending Fund Balance 2,354,271$ 2,371,216$
City of Evanston
CDBG Loan Fund
As of September 30, 2014
35 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Hotel Tax 1,600,000$ 1,554,281$ 1,500,000$ 1,113,440$
Amusement Tax 300,000 275,646 300,000 225,052
Howard-Ridge Loan Repayment 48,500 48,500 45,500 34,125
Grants - 999,000 1,000,000 -
Investment Income 800 922 800 2,816
Total Revenues 1,949,300 2,878,349 2,846,300 1,375,433
Economic Development Activities 1,830,209 983,057 1,760,889 1,114,163
Other Charges - Gigabit Challenge - - 1,000,000 24,718
Capital Projects 3,500 4,600 - -
Transfer to Debt Service 13,771 13,771 14,271 10,703
Transfer to Insurance 67,416 67,416 66,546 13,086
Transfers to General Fund 452,707 452,707 452,707 339,530
Total Expenditures 2,367,603 1,521,551 3,294,413 1,502,200
Net Surplus (Deficit)(418,303)$ 1,356,798$ (448,113)$ (126,768)$
Beginning Fund Balance 2,150,404 3,507,202
Ending Fund Balance 3,507,202$ 3,380,434$
City of Evanston
Economic Development Fund
As of September 30, 2014
36 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Taxes 20,000$ 20,000$ 20,000$ -$
Interest Income - - - -
Total Revenues 20,000 20,000 20,000 -
Program Expenses - - 50,000 -
Transfers to Other Funds - - - -
Total Expenditures - - 50,000 -
Net Surplus (Deficit)20,000$ 20,000$ (30,000)$ -$
Beginning Fund Balance 129,915 149,915
Ending Fund Balance 149,915$ 149,915$
City of Evanston
Neighborhood Improvement Fund
As of September 30, 2014
37 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Intergovernmental /Entitlement 797,400$ 703,935$ 674,500$ 509,631$
Interest Income - - - 59
Program Income - 6,693 - 20,538
Total Revenues 797,400 710,628 674,500 530,228
Home Administration/Planning 4,000 - 27,836 15,721
Development Activities 765,000 8,775 650,000 576,231
Transfers to General Fund 28,400 65,700 22,500 -
Total Expenditures 797,400 74,475 700,336 591,953
Net Surplus (Deficit)-$ 636,153$ (25,836)$ (61,725)$
Beginning Fund Balance 3,306,375 3,942,528
Ending Fund Balance 3,942,528$ 3,880,803$
City of Evanston
Home Fund
As of September 30, 2014
38 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Developer Contributions 155,000 290,000 155,000 125,088
Rehab Repayments - 11,188 - -
Interest Income 228 198 150 244
Miscellaneous - - - 5,972
Total Revenues 155,228 301,386 155,150 131,304
Housing - Buildings 227,800 30,692 200,000 393
Down Payment Assistance - - - 14,906
Transfers to General Fund 23,990 23,990 13,990 10,492
Miscellaneous 46,000 31,752 50,000 30,000
Total Expenditures 297,790 86,434 263,990 55,792
Net Surplus (Deficit)(142,562)$ 214,952$ (108,840)$ 75,512$
Beginning Fund Balance 2,236,126 2,451,078
Ending Fund Balance 2,451,078$ 2,526,590$
City of Evanston
Affordable Housing Fund
As of September 30, 2014
39 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 4,600,000$ 4,488,658$ 3,700,000$ 4,924,133$
Interest Income 25,000 13,072 10,000 10,550
Total Revenue 4,625,000 4,501,730 3,710,000 4,934,683
Series 1997 Principal
(refunded by 1999 & 2008D) 425,000 425,000 455,000 -
Series 1997 Interest
(refunded by 1999 and 2008D) 78,376 78,375 55,000 27,500
Contributions to Other Agencies - - - -
Economic Development Projects 1,250,000 128,999 1,250,000 49,335
Capital Improvements 2,836,000 2,158,380 722,486 -
Contractual Services 145,000 2,489 250,000 -
Transfer to Parking Fund (Sherman) 3,631,350 3,631,350 2,925,296 2,193,972
Transfer to General Fund 331,000 331,000 331,000 248,250
Total Expenditures 8,696,726 6,755,593 5,988,782 2,519,057
Net Surplus (Deficit) (4,071,726)$ (2,253,863)$ (2,278,782)$ 2,415,626$
Beginning Fund Balance 7,291,304 5,037,441
Ending Fund Balance 5,037,441$ 7,453,067$
City of Evanston
Washington National TIF Fund
As of September 30, 2014
40 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Taxes 448,875$ 460,062$ 397,800$ 428,525$
Interest Income - 585 - 5
Total Revenue 448,875 460,647 397,800 428,530
Series 2012A Bonds Principal 340,000 340,000 390,000 -
Series 2012A Bonds Interest 78,816 78,816 46,605 31,025
General Management Support - - - -
Total Expenditures 418,816 418,816 436,605 31,025
Net Surplus (Deficit)30,059$ 41,831$ (38,805)$ 397,505$
Beginning Fund Balance 433,054 474,885
Ending Fund Balance 474,885$ 872,390$
City of Evanston
Special Service Area #5
As of September 30, 2014
41 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 1,100,000$ 1,122,248$ 1,100,000$ 1,140,311$
Interest Income 10,000 14,087 10,000 11,610
Total Revenue 1,110,000 1,136,335 1,110,000 1,151,922
1994 & 1996 Bonds Principal (refunded by
1999 and 2008D bonds)645,000 645,000 685,000
1994 & 1996 Bonds Interest (refunded by
1999 and 2008D bonds)75,611 75,611 39,088 19,544
Surplus Distribution 1,000,000 1,000,000 -
Capital Projects 1,400,000 150,000 500,000 1,000,000
Other Expenses 500,000 9,915 - 1,486
Economic Development - - 2,500,000
Operating Transfer to General Fund 144,400 144,400 144,400 108,300
Total Expenditures 3,765,011 2,024,926 3,868,488 1,129,330
Net Surplus (Deficit)(2,655,011)$ (888,591)$ (2,758,488)$ 22,592$
Beginning Fund Balance 4,245,639 3,357,048
Ending Fund Balance 3,357,048$ 3,379,640$
City of Evanston
SW II TIF (Howard Hartrey)
As of September 30, 2014
42 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 465,000$ 492,410$ 485,000$ 607,662$
Interest Income 100 2 1,000 6
Total Revenue 465,100 492,412 486,000 607,668
Economic Development Activities - 459 748,439 -
Capital Improvement Projects 580,000 422,675 - -
Operating Transfer to General Fund 29,500 29,500 29,500 22,125
Total Expenditures 609,500 452,634 777,939 22,125
Net Surplus (Deficit)(144,400)$ 39,778$ (291,939)$ 585,543$
Beginning Fund Balance 304,939 344,717
Ending Fund Balance 344,717$ 930,260$
City of Evanston
Southwest TIF
As of September 30, 2014
43 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax- Current 11,798,019$ 11,864,571$ 10,879,993$ 11,139,758
Special Assessment Levy - - 169,848
Bond Proceeds/Premium/ Discounts - 23,281,822 -
Transfer from Other Funds - IMRF- 783,004 783,004 141,125 608,574
Miscellaneous Revenue - 33,510 -
Interest Income 1,500 5,356 1,500 8,369
Transfer from General Fund - 1,000,000 1,279,306 456,750
Transfer from Sewer Fund 190,210 190,210 207,284 155,463
Transfer from Special Assessment Fund 317,660 317,660 169,848 127,386
Total Revenue 13,090,393 37,476,133 12,848,904 12,496,300
Series 2004- Principal 775,000 9,786,794 - -
Series 2004- Interest 478,400 478,400 - -
Series 2004 B- Principal 595,000 2,830,000 - -
Series 2004 B- Interest 130,439 130,439 - -
Series 2005- Principal 1,095,000 12,465,536 - -
Series 2005- Interest 664,000 664,000 - -
Series 2006- Principal 85,000 85,000 185,000 -
Series 2006- Interest 448,302 448,302 444,776 225,613
Series 2006 B Bonds- Principal 35,000 35,000 1,130,000 55,000
Series 2006 B Bonds- Interest 603,426 603,426 600,526 601,626
Series 2007 - Principal 965,000 965,000 1,909,709 -
Series 2007 - Interest 684,458 684,456 569,684 300,839
Series 2008A - Principal 300,000 300,000 300,000 -
Series 2008A - Interest 125,975 125,975 116,225 58,113
Series 2008C - Principal 362,900 362,900 378,180 -
Series 2008C - Interest 376,308 376,308 364,514 191,799
Series 2008D - Principal 1,410,000 1,410,000 565,600 -
Series 2008D - Interest 36,690 36,690 15,362 7,681
Series 2010 A - Principal DSF 305,000 305,000 305,000 -
Series 2010 A - Interest DSF 179,338 179,338 173,238 86,619
Series 2010 B - Principal DSF 647,358 647,358 684,946 -
Series 2010 B - Interest DSF 135,508 135,509 126,446 63,223
Series 2011 A - Principal DSF 1,234,836 1,234,836 1,250,432 -
Series 2011 A - Interest DSF 451,586 451,586 426,890 213,445
Series 2012 A - Interest DSF 955,000 995,000 1,025,000 113,944
Series 2012 A - Principal DSF 357,706 347,766 243,332 -
Series 2013 A - Principal DSF 505,055 -
Series 2013 A - Interest DSF 1,601,006 315,413
Series 2013 B - Principal DSF 586,498 -
Series 2013 B - Interest DSF 95,000 95,000 - 313,772
-
Series 2004- Interest SAF 13,650 13,650 - -
Series 2005- Principal SAF 20,000 350,000 - -
Series 2005- Interest SAF 17,500 17,500 - -
Series 2006- Principal SAF 50,000 50,000 50,000 -
Series 2006- Interest SAF 8,526 8,526 6,450 -
Series 2007 - Principal SAF 35,000 35,000 40,000 -
Series 2007 - Interest SAF 33,920 33,920 31,994 -
Series 2008C - Principal SAF 19,000 19,000 19,800 -
Series 2008C - Interest SAF 19,702 19,702 19,084 -
Series 2013 A - Principal SAF 20,000 -
Series 2013 A - Interest SAF 8,867 -
Series 2013 B - Principal SAF 120,000 -
Series 2013 B - Interest SAF 23,500 -
General Management and Support 5,000 - 1,000 -
Bond Issuance Costs 60,000 143,063 75,000 -
Net of Transfers - - - -
Fiscal Agent Fees 10,000 126,610 10,000 62,120
Total Expenditures 13,824,528 36,996,590 13,933,114 2,609,206
Net Surplus (Deficit)(734,135)$ 479,543$ (1,084,210)$ 9,887,094$
Beginning Fund Balance 2,896,148 3,375,691
Ending Fund Balance 3,375,691$ 13,262,785$
City of Evanston
Debt Service Fund
As of September 30, 2014
44 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 500,000$ 194,881$ 350,000$ 441,462$
Interest Income 400 344 400 127
Miscellaneous - 33,014 - 38,928
Total Revenue 500,400 228,239 350,400 480,517
Economic Dev. Projects - - -
Debt Service - Interest - 592 - 429
Capital Improvements 800,000 219,785 - 179,910
Developer Agreement Payments 610,000 505,855 300,000 544,086
Repayments to Econ. Dev. Fund 48,500 48,500 45,500 34,125
Transfers to General Fund 120,400 120,400 60,000 45,000
Total Expenditures 2,037,736 895,132 405,500 803,551
Net Surplus (Deficit)(1,537,336)$ (666,893)$ (55,100)$ (323,034)$
Beginning Fund Balance 1,055,510 388,617
Ending Fund Balance 388,617$ 65,583$
City of Evanston
Howard Ridge TIF
As of September 30, 2014
45 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 300,000$ 46,252$ 40,000$ -$
Bond Proceeds 3,400,000 - - -
Loan Proceeds - - - 100,262
Interest Income 1,000 167 100 463
Total Revenue 3,701,000 46,419 40,100 100,724
Economic Development Projects 650,000 - 75,000 -
Other Charges 1,600,000 135,353 20,000 -
Debt Service - Interest 40,000 7,274 10,000 4,228
Transfers to General Fund 60,000 60,000 60,000 45,000
Capital Projects 1,285,000 179,000 - -
Total Expenditures 3,635,000 381,627 165,000 49,228
Net Surplus (Deficit)66,000$ (335,208)$ (124,900)$ 51,496$
Beginning Fund Balance 872,847 537,639
Ending Fund Balance 537,639$ 589,135$
City of Evanston
W est Evanston TIF
As of September 30, 2014
46 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Net Property Tax Increment 100,000$ -$ -$ -$
Bond Proceeds 650,000 - - -
Interest Income - - - -
Total Revenue 750,000 - - -
Economic Development Projects 650,000 - - -
Total Expenditures 650,000 - - -
Net Surplus (Deficit)100,000$ -$ -$ -$
Beginning Fund Balance - -
Ending Fund Balance -$ -$
City of Evanston
Dempster-Dodge TIF
As of September 30, 2014
47 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Bond Proceeds 8,339,988$ 8,538,259$ 8,331,458$ 8,469,966$
Grants 1,675,000 882,160 5,382,638 487,563
Reimbursements - - -
Private Contributions 510,000 - 708,000 72,505
Parking Fund Loan for Financial System 596,000 - 100,000
General Fund Allocation - - 936,500 702,375
Miscellaneous - 53,986 - 93,046
Interest Income 10,000 18,562 10,000 12,864
Total Revenue 11,130,988 9,492,967 15,468,596 9,838,320
Capital Outlay (includes prior year rollovers) 13,100,351 6,119,879 17,935,016 3,429,758
Interfund Transfers Out 475,000 475,000 475,000 356,250
Total Expenditures 13,575,351 6,594,879 18,410,016 3,786,008
Net Surplus (Deficit)(2,444,363)$ 2,898,088$ (2,941,420)$ 6,052,311$
Beginning Fund Balance 3,401,911 6,299,999
Ending Fund Balance 6,299,999$ 12,352,310$
City of Evanston
Capital Improvement Fund
As of September 30, 2014
48 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Special Assessments Collected 300,000$ 274,848$ 230,000$ 119,874$
Bond Proceeds 250,000 241,906 250,000 493,949
Investment Income 10,000 1,982 1,200 2,110
Total Revenue 560,000 518,736 481,200 615,932
Transfer to Debt Service Fund 317,660 317,660 169,848 130,636
General Management & Support - - 1,000 620
Capital Outlay 361,000 33,976 500,000 970
Total Expenditures 678,660 351,636 670,848 132,225
Net Surplus (Deficit)(118,660)$ 167,100$ (189,648)$ 483,707$
Beginning Fund Balance 1,905,315 2,072,415
Ending Fund Balance 2,072,415$ 2,556,122$
City of Evanston
Special Assessment Fund
As of September 30, 2014
49 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Parking Lots & Meters Operations 3,070,000$ 2,443,331$ 3,070,000$ 2,294,819
Church Street Garage Operations 716,348 618,034 716,348 503,575
Maple Avenue Garage Operations 1,204,200 1,140,191 1,204,200 983,310
Sherman Avenue Garage Operations 1,417,275 1,600,383 1,417,275 3,322,059
Washington National TIF Interfund Transfers-In 3,631,350 3,631,350 2,925,296 -
Interest Income 15,070 11,892 15,070 -
Miscellaneous Revenue 11,400 20,481 11,400 -
Reserve for Future Repairs (Contra Depreciation)2,034,004 432,655 2,034,004 -
Total Revenue 12,099,647 9,898,317 11,393,593 7,103,763
7005 - Parking System Administration 784,607 804,417 976,360 1,239,991
7015 - Parking Lots and Meters 829,052 760,432 972,266 778,382
7025 - Church Street Self Park 607,955 414,444 624,855 247,433
7030 - Church Street Debt Payments 171,250 41,846 171,250 17,050
7036 - Sherman Avenue Garage 5,750,270 5,134,149 5,047,016 1,007,276
7037 - Maple Avenue Garage 1,611,920 861,836 1,654,244 515,950
7039 - Parking Debt 27,461 27,461 27,461 2,218
Transfer to Insurance Fund 490,236 490,236 319,648 239,737
Transfer to General Fund 644,242 644,242 869,242 651,931
Transfer to Fleet 21,991 21,992 21,991 -
Transfer to Equipment Replacement 30,000 30,000 30,000 -
Loans to Other Funds 2,796,000 - - -
Capital Outlay - - - -
Capital Improvements 3,455,000 1,896,659 5,180,000 -
Total Expenditures 17,219,984 11,127,714 15,894,333 4,699,968
Net Surplus (Deficit)(5,120,337)$ (1,229,397)$ (4,500,740)$ 2,403,795$
Further Operating Expense Breakdown:
7015 Parking Meter Activities 762,846 760,432 935,614 778,382
7015 Parking Meter Depreciation 36,652 - 36,652 -
SUBTOTAL 799,498 760,432 972,266 778,382
7025- Church Garage Activities 494,156 414,444 444,927 247,433
7025- Church Garage Depreciation 179,928 - 179,928 -
SUBTOTAL 674,084 414,444 624,855 247,433
7036 Sherman Garage Activities 1,199,756 1,884,149 468,766 1,007,276
7036 Debt Service Payments 3,250,300 3,250,000 3,703,600 -
7036 Reserve (Depreciation)874,650 - 874,650 -
SUBTOTAL 5,324,706 5,134,149 5,047,016 1,007,276
7037 Maple Garage Activities 1,013,991 861,836 988,046 515,950
7037 Debt Service Payments - - - -
7037 Reserve (Depreciation)666,198 - 666,198 -
SUBTOTAL 1,680,189 861,836 1,654,244 515,950
Beginning Unrestricted Fund Balance 14,418,330 13,602,819
Reclassification to Fund Balance to Capital Assets 413,886
Ending Unrestricted Fund Balance 13,602,819$ 16,006,614$
City of Evanston
Parking Fund
As of September 30, 2014
50 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Evanston 5,684,000$ 5,947,632$ 6,252,400$ 4,901,929$
Skokie 2,856,000 2,772,424 2,913,000 2,406,511
Northwest Commission 4,517,000 5,183,425 4,653,000 4,019,184
Cross Connection Control Fees 100,500 94,470 95,000 116,830
Investment Earnings 2,500 20,164 2,500 21,143
Debt Proceeds 2,630,700 2,043,779 4,000,000 2,700,000
Debt Proceeds (zero interest)1,370,000 - 2,000,000 197,048
Fees and Merchandise Sales 40,000 94,971 45,000 148,870
Fees and Outside Work 80,000 188,610 70,000 92,974
Grants - 78,792 - 14,181
Insurance Reimbursements - - - -
Phosphate Sales 66,000 48,114 69,000 34,499
Property Sales and Rentals 213,300 235,936 227,316 84,575
Misc Revenue - 92,165 - 19,629
Total Revenue 17,560,000 16,800,482 20,327,216 14,757,372
General Support 990,583 960,028 933,989 696,156
Pumping 2,333,247 2,226,781 2,355,718 1,250,341
Filtration 2,635,539 2,435,092 2,740,856 1,752,015
Distribution 1,424,324 1,389,136 1,425,352 1,039,131
Meter Maintenance 309,163 249,474 300,760 205,618
Other Operating Expenses 478,592 994,606 491,700 447,857
Debt Service 864,233 810,068 1,297,703 514,991
Debt Service - IEPA Loan 3382 67,506 67,504 67,506 33,752
Capital Improvements 8,314,200 5,435,207 10,538,100 2,127,300
Interfund Transfers Out - General Fund 3,356,300 3,356,300 3,369,559 2,527,169
Interfund Transfers Out - Insurance Fund 468,492 468,492 468,492 351,370
Total Expense 21,242,179 18,392,688 23,989,735 10,945,700
Net Surplus (Deficit)(3,682,179)$ (1,592,206)$ (3,662,519)$ 3,811,672$
Beginning Unrestricted Fund Balance 9,192,655 8,590,091
Reclassification to Fund Balance from Capital Assets 989,642
Ending Unrestricted Fund Balance 8,590,091$ 12,401,763$
City of Evanston
W ater Fund
As of September 30, 2014
51 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Operations 12,908,000$ 13,494,318$ 12,922,700$ 9,982,155$
Debt Proceeds 4,000,000 1,851,827 - -
Debt Proceeds - 2012 IEPA Loan 3,100,000 2,523,969 2,190,000 1,104,656
Investment Earnings 1,000 1,270 1,000 1,955
Miscellaneous 18,865 15,881 4,165 -
Grant Revenue - 860,353 - -
Total Revenue 20,027,865 18,747,618 15,117,865 11,088,766
Sewer Operations 2,134,549 2,026,860 2,260,545 1,502,128
Other Operating Expenses 43,300 10,900 129,500 23,879
Interfund Transfers Out - General Fund 142,200 142,200 145,044 108,783
Interfund Transfers Out - Insurance Fund 269,988 269,988 269,988 202,491
Transfer to Debt Service 190,211 190,210 207,284 155,463
Capital Outlay 20,600 13,714 47,500 41,040
Depreciation - 4,570,214 -
Capital Improvement Account 4,922,500 - 3,225,000 1,745,759
Debt Service 11,542,740 11,711,077 9,994,259 7,143,621
Total Expenses 19,266,088 18,935,163 16,279,120 10,923,164
Net Surplus (Deficit)761,777$ (187,545)$ (1,161,255)$ 165,602$
Beginning Unrestricted Fund Balance 4,199,578 4,574,996
Reclassification to Fund Balance to Capital Assets 562,963
Ending Unrestricted Fund Balance 4,574,996$ 4,740,598$
City of Evanston
Sewer Fund
As of September 30, 2014
52 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Transfer from General Fund 1,245,967$ 1,245,967$ 1,055,967$ 791,975$
Solid Waste Franchise Fees 175,000 199,980 175,000 125,497
SWANCC Recycling Incentive 140,000 30,467 25,000 20,852
Recycling Service Charge 2,954,033 3,013,668 3,334,033 2,567,531
Sanitation Service Charge Penalty 30,000 44,099 45,000 43,689
Special Pickup Fees 100,000 86,804 100,000 57,715
Trash Cart Sales 15,000 27,697 15,000 14,679
Investment Income - 20 -
Yard Waste Fees 350,000 248,077 220,000 58,822
Total Revenue 5,010,000 4,896,779 4,970,000 3,680,760
Refuse Collection & Disposal 3,259,574 2,882,420 3,372,698 1,957,989
Residential Recycling Collection 1,254,398 1,223,782 1,186,134 933,080
Yard Waste Collection 750,250 626,253 750,250 376,641
Total Expense 5,264,222 4,732,455 5,309,082 3,267,710
Net Surplus (Deficit)(254,222)$ 164,324$ (339,082)$ 413,051
Beginning Unrestricted Fund Balance (1,447,884) (1,283,560)
Ending Unrestricted Fund Balance (1,283,560)$ (870,509)
City of Evanston
Solid Waste
As of September 30, 2014
53 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
General Fund 2,507,356$ 3,107,358$ 2,507,356$ 1,880,519$
Library Fund 2,381 2,381 2,381 1,786
Parking Fund 21,992 21,992 21,992 16,494
Water Fund 122,751 122,751 122,751 92,063
Sewer Fund 177,729 177,729 177,729 133,297
Solid Waste Fund 298,071 298,071 298,071 223,553
Damage to City Property 24,789 - 24,789
Miscellaneous Revenue 10,000 46,349 10,000 41,148
Interest Income 1,000 - 1,000 -
Total Revenues 3,166,069 3,776,631 3,166,069 2,388,860
General Support 292,007 271,772 293,619 197,298
Major Maintenance 3,217,058 3,287,552 3,284,528 2,126,075
Total Expenditures 3,509,065 3,559,324 3,578,147 2,323,372
Net Surplus (Deficit)(342,996)$ 217,307$ (412,078)$ 65,487$
Beginning Fund Balance (107,097) 110,566
Reclassification from Fund Balance to Capital Assets 356
Ending Fund Balance 110,566$ 176,053$
City of Evanston
Fleet Maintenance Fund
As of September 30, 2014
54 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
General Fund 1,242,590$ 1,242,590$ 1,242,590$ 931,942$
Library Fund 1,700 1,700 1,700 1,275
Parking Fund 30,000 30,000 30,000 22,500
Solid Waste Fund 177,131 177,131 177,131 132,848
Bond Premiums - - - 72,810
Bond Proceeds - - 1,000,000 1,000,000
Sale of Surplus Property 210,217 131,072 210,217 34,511
Total Revenues 1,661,638 1,582,493 2,661,638 2,195,887
Capital Outlay 2,400,000 1,625,725 2,494,000 1,349,450
Carryover - - 200,000 -
Settlement Costs - - - 15,290
Bond Costs - 7,212
Capital Leases 50,000 - 50,000 24,997
Total Expenditures 2,450,000 1,625,725 2,744,000 1,396,949
Net Surplus (Deficit)(788,362)$ (43,232)$ (82,362)$ 798,938$
Beginning Fund Balance 1,500,482$ 588,983$
Reclassification from Capital Assets to Fund
Balance (868,267)$
Ending Fund Balance 588,983$ 1,387,921$
City of Evanston
Equipment Replacement Fund
As of September 30, 2014
55 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
General Admin Contribution- General 121,204$ 121,204.00$ 121,204$ 90,903$
General Admin Contribution- E911 930 930 930 698
General Admin Contribution- CDBG 930 930 930 698
General Admin Contribution- E.D.930 930 930 698
General Admin Contribution- Parking 17,032 17,032 17,032 12,774
General Admin Contribution- Water Fund 24,962 24,962 24,962 18,722
General Admin Contribution- Sewer Fund 14,385 14,385 14,385 10,789
Liability/Property Contribution- General 909,150 909,150 909,150 681,863
Liability/Property Contribution- E911 6,972 6,972 6,972 5,229
Liability/Property Contribution- CDBG 6,972 6,972 6,972 5,229
Liability/Property Contribution- E.D.6,972 6,972 6,972 5,229
Liability/Property Contribution- Parking 127,731 127,731 127,731 95,798
Liability/Property Contribution- Water Fund 187,209 187,209 187,209 140,407
Liability/Property Contribution- Sewer Fund 107,887 107,887 107,887 80,915
Workers' Comp Contribution- General 1,244,860 1,244,860 1,244,860 933,647
Workers' Comp Contribution- Library Fund 5,898 5,898 40,000 30,000
Workers' Comp Contribution- E911 9,546 9,546 9,546 7,160
Workers' Comp Contribution- CDBG 9,546 9,546 9,546 7,160
Workers' Comp Contribution- E.D. 9,546 9,546 9,546 7,160
Workers' Comp Contribution- Parking 174,886 174,886 174,886 131,164
Workers' Comp Contribution- Water Fund 256,322 256,322 256,322 192,242
Workers' Comp Contribution- Sewer Fund 147,716 147,716 147,716 110,787
Subrogation Proceeds 83,300 155,102 100,000 54,068
Yearend Transfer from General Fund - 874,289 -
Transfer from General Fund - Casualty Loss Acct - - -
Investment Income 41,650 212 1,000 219
Workers Comp & Liability - Subtotal 3,516,536 4,421,189 3,526,688 2,623,554
Health Insurance Chargebacks- General 8,232,350 8,262,909 8,780,657 6,585,494
Health Insurance Chargebacks - Library 318,681 318,681 366,065 274,549
Health Insurance Chargebacks - NSP2 16,390 16,390 6,863 5,147
Health Insurance Chargebacks- E911 81,545 81,545 71,410 53,557
Health Insurance Chargebacks- CDBG 12,586 12,586 31,521 23,640
Health Insurance Chargebacks- E.D. Fund 56,081 49,968 49,098 36,824
Health Insurance Chargebacks- Home Fund - - 2,735 2,051
Health Insurance Chargebacks- Parking 170,588 170,588 171,325 128494
Health Insurance Chargebacks- Water 596,392 596,392 616,227 462,171
Health Insurance Chargebacks- Sewer 168,030 168,030 183,218 137,414
Health Insurance Chargebacks - Solid Waste 114,220 114,220 106,846 80,134
Health Insurance Chargebacks- Fleet 183,414 183,414 202,427 151,820
Retiree Health Insurance Contributions 1,684,894 1,688,954 1,970,647 1,141,007
Employee Health Insurance Contributions 1,760,276 1,489,664 1,706,017 1,000,083
SWANNC-Health Insurance Contributions - - - 57,428
One Time IPBC Distribution 300,000 300,000 300,000 726,300
Health & Life insurance - Subtotal 13,695,447 13,453,341 14,565,056 10,866,113
Total Revenues 17,211,983 17,874,530 18,091,744 13,489,668
City of Evanston
Insurance Fund
As of September 30, 2014
56 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
City of Evanston
Insurance Fund
As of September 30, 2014
General Administration & Support 294,093 286,369 409,548 290,142
Auditing 25,000 - - -
Liability/Property Insurance Premiums 470,000 455,514 470,000 490,744
Liability Legal Fees 350,000 460,204 350,000 359,690
Liability Settlement Payments 400,000 471,052 400,000 420,989
Transfer - to ERI Debt Service 8,325 8,325 8,627 6,470
Workers' Comp Insurance Premiums 114,400 111,111 114,400 118,531
Workers' Comp Legal Fees 80,500 38,694 80,500 35,036
Workers' Comp Medical Payments 800,000 493,886 600,000 478,728
Workers' Comp Settlement Payments 1,100,000 899,625 1,100,000 498,966
Workers' Comp TPA Pymts (non specific)145,000 154,244 125,000 -
Workers' Comp TTD Pymts (non sworn)- - - 85,414
Workers' Comp & Liability - Subtotal 3,787,318 3,379,024 3,658,075 2,784,710
General Administration & Support 94,093 87,437 99,805 72,867
Health Insurance Premiums 13,458,615 13,183,406 14,217,604 10,057,104
Health Insurance Opt Out Payments 84,000 45,133 91,800 11,578
Health & Life Insurance - Subtotal 13,636,708 13,315,976 14,409,209 10,141,548
Total Expenditures 17,424,026 16,695,000 18,067,284 12,926,258
Net Surplus (Deficit)(212,043)$ 1,179,530$ 24,460$ 563,410$
Beginning Unrestricted Fund Balance (7,376,499) (3,727,662)
Adjustment to GAAP Basis of Accounting 2,469,307
Ending Unrestricted Fund Balance (3,727,662)$ (3,164,252)$
57 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Property Taxes 6,061,575$ 6,049,233$ 6,061,575$ 6,082,542$
Personal Property Repl Tax 280,000 280,000 280,000 279,696
Interest on Investment 800,000 1,564,893 850,000 327,247
Participant Contributions 922,500 975,932 950,000 661,799
Unrealized Gain - 5,233,195 - 5,000
Miscellaneous - 150 - -
Total Revenue 8,064,075 14,103,403 8,141,575 7,356,284
Administrative Expenses 154,000 271,223 154,000 141,125
Legal Fees 50,000 - 50,000
Retiree Pensions 4,841,000 4,871,953 4,995,500 3,953,771
Widows' Pensions 1,090,000 1,053,398 1,071,200 808,907
Disability Pensions 1,350,000 1,304,970 1,358,125 955,620
QUILDRO 75,000 90,364 90,000 71,400
Reserve for Future Payments - - - -
Total Expenditures 7,560,000 7,591,908 7,718,825 5,930,822
Net Surplus (Deficit)504,075$ 6,511,495$ 422,750$ 1,425,462$
Beg Net Assets held in Trust 58,463,916 58,463,916 65,024,941 65,024,941
Property Tax Adjustment for GAAP Basis 49,530
End Net Assets held in Trust 58,967,991$ 65,024,941$ 65,447,691$ 66,450,402$
City of Evanston
Fire Pension Fund
As of September 30, 2014
58 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Property Taxes 8,069,325$ 8,077,915$ 8,069,325$ 8,100,226$
Personal Property Repl Tax 325,000 325,000 325,000 279,696
Interest Income 2,625,000 3,277,547 2,800,000 1,067,060
Participant Contributions 1,383,750 1,759,216 1,423,000 1,034,315
Miscellaneous - - - 104,993
Unrealized Gain / (Loss)- 6,375,354 - -
Total Revenue 12,403,075 19,815,032 12,617,325 10,586,291
Administrative Expenses 250,000 264,528 250,000 163,770
Retiree Pensions 7,500,769 7,787,104 8,056,000 6,128,955
Widow Pensions 868,000 857,302 875,500 669,798
Disability Pensions 700,000 662,888 700,000 483,338
Separation Refunds 150,000 109,252 275,000 2,831
QUILDRO 18,000 21,084 18,000 16,288
Reserve for Future Payments - - - -
Total Expenditures 9,486,769 9,702,158 10,174,500 7,464,981
Net Surplus (Deficit)2,916,306$ 10,112,874$ 2,442,825$ 3,121,311$
Beg Net Assets held in Trust 80,589,961 80,589,961 90,763,143 90,763,143
Property Tax Adjustment for GAAP Basis 60,308
End Net Assets held in Trust 83,506,267$ 90,763,143$ 93,205,968$ 93,884,454$
City of Evanston
Police Pension Fund
As of September 30, 2014
59 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Revenue By Source
Allocation - Property Taxes 4,253,214$ 4,165,513$ 5,032,097$ 5,145,230$
Library Fines & Fees 185,000 169,583 164,000 89,214
Library Material Replacement 12,500 12,484 14,000 7,275
Copy Machine Charges 20,000 18,814 21,200 9,906
Meeting Room Fees 10,000 12,397 10,400 10,182
Non-resident Cards 1,690 1,565 1,040 260
North Branch Rental Income 59,660 58,697 60,000 16,578
State Per Capita Grant 76,300 103,995 94,177 4,000
Personal Property Repl. Tax 50,200 50,200 50,200 -
Video Rentals - - -
Book Sales 60,000 56,140 65,000 24,853
Merchandise Sale -
Fund for Excellence 245,000 127,433 125,000 28,704
Grants and Donations - 116,545 68,840
Transfer from Economic Development - 9,900 - 9,900
Miscellaneous - 3,854 - 2,366
Transfer from Endowment 131,250 131,249 159,315 157,951
Total Revenues 5,104,814 4,921,824 5,912,974 5,575,258
Expenditures
Youth Services 891,720 903,873 1,030,009 713,403
Adult Services 1,535,224 1,538,627 1,514,037 1,068,867
Circulation 612,892 605,865 573,258 388,765
Neighborhood Services 360,757 325,649 456,528 313,722
Technical Services 503,433 431,115 538,879 340,887
Maintenance 507,517 672,615 660,703 479,481
Administration 669,377 678,430 1,103,015 782,875
Library Grants - 35,569 36,545 20,056
Total Expenditures 5,080,920 5,191,743 5,912,974 4,108,055
Net Surplus (Deficit)23,894$ (269,919)$ -$ 1,467,203$
Beginning Fund Balance 1,101,096 982,764
Adjustment to GAAP Basis of Accounting 151,587 -
Ending Fund Balance 982,764 2,449,967
City of Evanston
Library Fund
As of September 30, 2014
60 of 73
FY 2013 FY 2013 FY 2014 FY 2014
Budget Audited Budget YTD
Amended Actual Adopted Actual
Revenue By Source
Net Property Taxes -$ -$ 748,178$ 739,506$
Investment Income - - 1,000 -
Total Revenues - - 749,178 739,506
Expenditures
Series 2004 - Principal DSF - - 53,430 -
Series 2004 - Interest DSF - - 8,454 -
Series 2005 - Principal DSF - - 44,918 -
Series 2005 - Interest DSF - - 14,089 -
Series 2007 - Principal DSF - - 200,291 -
Series 2007 - Interest DSF - - 60,496 30,248
Series 2008 - Principal DSF - - 344,400 -
Series 2008 - Interest DSF - - 22,100 11,050
Series 2013B - Interest DSF - - - 12,426
Total Expenditures - - 748,178 53,724
Net Surplus (Deficit)-$ -$ 1,000$ 685,782$
Beginning Fund Balance - -
Ending Fund Balance - 685,782
City of Evanston
Library Debt Fund
As of September 30, 2014
61 of 73
JanuaryFebruaryMarch AprilMay JuneJulyAugustSeptemberOctoberNovemberDecemberFY 2014 Unreserved Fund Balance17,321,904$ 17,910,959$ 21,166,294$ 20,395,607$ 20,882,214$ 19,058,144$ 19,999,271$ 22,595,599$ 20,438,571$ FY 2013 Unreserved Fund Balance17,412,530$ 18,091,096$ 21,774,085$ 22,459,219$ 23,342,537$ 19,526,063$ 20,250,620$ 21,816,228$ 20,501,689$ FY 2014 Cash Balance4,173,079$ 6,745,425$ 10,059,258$ 9,101,839$ 8,474,680$ 7,167,254$ 9,635,823$ 12,266,622$ 10,328,206$ FY 2013 Cash Balance6,624,063$ 7,811,937$ 12,160,633$ 12,969,898$ 12,797,660$ 13,337,226$ 14,279,322$ 14,279,322$ 11,977,938$ $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000City of Evanston General FundComparison of Fund and Cash BalancesFiscal Year 2014 vs Fiscal Year 2013FY 2014 Unreserved Fund BalanceFY 2013 Unreserved Fund BalanceFY 2014 Cash BalanceFY 2013 Cash Balance62 of 73
To: Wally Bobkiewicz, City Manager
Martin Lyons, Asst. City Manager/CFO
From: Andrew Villamin, Interim Accounting Manager
Subject: FY2014 – 3rd Quarter End Investment Report
Date: October 30, 2014
Attached please find the investment report as of September 30, 2014.
A comparison between the 2014 second quarter investment report and the third quarter
indicates an increase in combined cash & investments of $24,771,667 from
$67,395,643 to $92,167,310. Cash and investment changes from the previous period
are summarized below:
9/30/2014 6/30/2014 Change
Cash 41,908,027$ 37,981,865$ 3,926,162$
Investments 50,259,283$ 29,413,778$ 20,845,505$
Total 92,167,310$ 67,395,643$ 24,771,667$
The net increase of $24.8M in cash and investments was primarily due to the proceeds
from the bond issuance, second installment property taxes and Kellogg building permit.
Cash balances as of September 30, 2013 were $$89.8M.
As of September 30, 2014, ledger balances showed the highest percentage of total
deposits was held by IMET at approximately $42.8M, or 46.4% of the City’s $92.2M in
cash and investments followed by First Bank and Trust with $40.7M or 44.2% and US
Bank (Illinois Funds) with $7.5M or 8.1% of the total. The remaining $1.2M or 1.3% of
the funds were invested with Chase Bank. Per City’s investment policy, no financial
institution should have greater than 50% of the city’s total deposits. The Finance Staff
will continue to closely monitor the balances to have a suitable investment mix in
compliance of the City Investment policy to maximize returns on investments.
If you have any questions on this report or would like to discuss in greater detail, please
contact me @ (847) 866-2903 or at avillamin@cityofevanston.org.
Memorandum
63 of 73
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
A B C D E F
City of Evanston
Cash & Investment Summary by Fund
September 30, 2014
Fund #Fund Cash Investments Interfund Total
100 General 6,863,336 3,227,873 236,997 10,328,206
175 General Assistance 145,777 242,322 (15,134)372,965
185 Library 2,112,320 (343,473)1,768,846
186 Library Debt Service 685,782 685,782
195 Neighborhood Stabilization 467,125 (12,938)454,187
200 MFT 2,075,299 (71,361)2,003,939
205 E911 109,819 645,706 (55,731)699,793
210 SSD4 (109,139)(109,139)
215 CDBG 45,244 (78,675)(33,431)
220 CD Loan 131,776 131,776
225 Economic Dev.2,503,319 392,025 (78,011)2,817,333
235 Neighborhood Improvement 149,915 149,915
240 Home (51,551)(51,551)
250 Affordable Housing 451,583 363,481 (1,166)813,897
300 Washington National TIF 2,092,803 5,224,222 (271,358)7,045,667
305 SSD5 811,083 811,083
310 Howard Hartrey 4,039,223 (675,216)3,364,006
315 Southwest TIF 921,075 (2,458)918,617
320 Debt Service 10,611,703 979,947 151,538 11,743,188
330 Howard Ridge 152,570 (98,640)53,930
335 West Evanston 40,953 552,133 (3,950)589,136
415 Capital Improvements 15,015,330 (2,078,692)12,936,638
420 Special Assessment 2,326,770 239,279 (13,922)2,552,126
505 Parking 5,374,988 10,084,692 (110,738)15,348,942
510 Water 4,194,366 7,020,199 (22,553)11,192,012
515 Sewer 4,254,978 4,984 0 4,259,962
520 Solid Waste (1,279,425)(1,279,425)
600 Fleet (413,021)(413,021)
601 Equipment Replacement 1,266,968 120,952 1,387,920
605 Insurance 384,421 1,239,593 1,624,013
45,946,101 50,259,283 (4,038,074)92,167,310
Includes negative cash balance reclassed to interfund liability.
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
64 of 73
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
46
47
48
49
51
52
53
55
56
58
60
61
62
63
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
A B C D E F G H
City of Evanston
Cash & Investments Bank
Investment Investment Fiscal YTD Investment
Description Type Bank Rate Est. Income Amount Fund #Fund
IL Funds MMA US Bank 0.013 315 3,227,873 100 General
IL Funds MMA US Bank 0.013 24 242,322 175 General Assistance
IL Funds MMA US Bank 0.013 202 2,075,299 200 MFT
IL Funds MMA US Bank 0.013 63 645,706 205 E911
IL Funds MMA US Bank 0.013 38 392,025 225 Economic Development
IL Funds MMA US Bank 0.013 36 363,481 250 Affordable Housing
IL Funds MMA US Bank 0.013 4,564 300 Washington National
IL Funds MMA US Bank 0.013 1,305 320 Debt Service
IL Funds MMA US Bank 0.013 2,458 330 Howard Ridge TIF
IL Funds MMA US Bank 0.013 1,723 335 West Evanston TIF
IL Funds MMA US Bank 0.013 24 246,648 415 Capital Improvements
IL Funds MMA US Bank 0.013 6 63,201 505 Parking
IL Funds MMA US Bank 0.013 22 226,738 510 Water
IL Funds MMA US Bank 0.013 4,984 515 Sewer
US BANK Total 731 7,498,326
Money Market Fund MMA IMET 0.400 15,659 5,219,658 300 Washington National
Money Market Fund MMA IMET 0.400 12,118 4,039,223 310 Howard Hartrey TIF
Money Market Fund MMA IMET 0.400 2,936 978,641 320 Debt Service
Money Market Fund MMA IMET 0.400 450 150,112 330 Howard Ridge TIF
Money Market Fund MMA IMET 0.400 1,651 550,410 335 West Evanston TIF
Money Market Fund MMA IMET 0.400 44,306 14,768,682 415 Capital Improvements
Money Market Fund MMA IMET 0.400 718 239,279 420 Special Assessments
Money Market Fund MMA IMET 0.400 30,064 10,021,491 505 Parking
Money Market Fund MMA IMET 0.400 20,380 6,793,461 510 Water
IMET Total 128,283 42,760,958
Grand Total 129,014 50,259,283
Cash
Total Chase 1st Bank
Cash Cash 6,863,336 272,612 6,590,724 100 General
Cash Cash 145,777 145,777 175 General Assistance
Cash Cash 2,112,320 2,112,320 185 Library
Cash Cash 685,782 685,782 186 Library Debt Service
Cash Cash 467,125 467,125 195 Neighbrhd Stablztn
Cash Cash 109,819 109,819 205 E911
Cash Cash 45,244 45,244 215 CDBG
Cash Cash 131,776 131,776 220 CD Loan
Cash Cash 2,503,319 2,503,319 225 Economic Dev.
Cash Cash 149,915 149,915 235 Neighbrhd Improvemt
Cash Cash 451,583 451,583 250 Affordable Housing
Cash Cash 2,092,803 2,092,803 300 Washington National TIF
Cash Cash 811,083 811,083 305 SSD5
Cash Cash 921,075 921,075 315 Southwest TIF
Cash Cash 10,611,703 10,611,703 320 Debt
Cash Cash 40,953 40,953 335 West Evanston
Cash Cash 2,326,770 2,326,770 420 Special Assess
Cash Cash 5,374,988 5,374,988 505 Parking
Cash Cash 4,194,366 4,194,366 510 Water
Cash Cash 4,254,978 911,466 3,343,512 515 Sewer
Cash Cash 1,266,968 1,266,968 601 Equipment Replacemt
Cash Cash 384,421 384,421 605 Insurance
45,946,101 1,184,078 44,762,023
Total Cash 45,946,101
Interfunds & negative cash (4,038,074)
Net Cash 41,908,027
Total Investments & Cash 92,167,310
CASH / INVESTMENT Investments Cash Total
BALANCES BY
BANK Amount %Amount %Amount %
1ST Bank 40,723,949 97.17%40,723,949 44.18%
Chase 1,184,078 2.83%1,184,078 1.28%
IMET 42,760,958 85.08%42,760,958 46.39%
US Bank 7,498,326 14.92%7,498,326 8.14%
Total 50,259,283 100.00%41,908,027 100.00%92,167,310 100.00%
September 30, 2014
65 of 73
For City Council meeting of November 17, 2014 Item SP5
Consideration of FY2015 Revised Proposed Budget
For Discussion
To: Honorable Members of the City Council
From: Wally Bobkiewicz, City Manager
Subject: Revised Proposed 2015 Budget
Date: November 12, 2014
Recommendation:
That the City Council consider the attached revisions to the Proposed 2015 Budget
presented on October 10, 2014 and adopt the 2015 Proposed Budget as revised on
November 24, 2014.
Summary:
The Proposed Budget includes the following changes as included on the attached
revised Budget Balancing Worksheet document. These changes are the result of City
Council conversation on the initial draft, presented October 10, 2014.
1.General Fund—
In the initial draft, the General Fund proposed a $125,241 surplus. The
revised version includes a surplus of $109,312. This is an increase in
expenditure of $15,929 which can be broken down as follows:
Initial Revised Change Notes
REVENUES
Birth & Death Certificates (100,000.00)$ 12,000.00$ 112,000.00$ Initial draft included the
elimination of this revenue
EXPENSES
Vital Records Elimination (169,549.00)$ (71,620.00)$ 97,929.00$
Initial draft included
elimination of 2 positions;
revised is one position
Increase in Uniform costs 19,500.00$ 39,500.00$ 20,000.00$ Across departments
Training for Public Works Staff 10,000.00$ 10,000.00$ Increase for job certificate
training
NET CHANGE (15,929.00)$
General Fund Surplus 125,241.00$ 109,312.00$
To further explain these changes:
Memorandum
66 of 73
a. The original 2015 proposed budget included a decrease in revenues
and expenses associated with Vital Records. The revised document
includes the reduction of staff from 2 to 1 (with one individual being
transferred to a vacancy within the City). Secondly, the fees for birth
and death certificates have been changed to equal those charged by
Cook County, which increases the budgeted revenue to $112,000.
The Vital Records revenue analysis is attached.
b. There is an increase in uniform costs across the City.
c. The $10,000 increase in training for Public Works staff will allow for the
licensure of various employees.
The General Fund is still proposed to be balanced by approximately $109,000 for
2015.
2. Southwest TIF—
The initial draft of the 2015 Proposed Budget did not include any expenses
associated with the Southwest TIF. The Council approved the closing of this TIF
district on October 27, 2014; the actual date of dissolution is the end of 2014.
Because staff will be waiting on final bills during that time, the TIF is anticipated
to close 2014 with an approximately surplus of $860,000. As a result, the
disbursement of this money to various taxing bodies will take place in 2015. The
City of Evanston anticipates receiving approximately 20% or $172,000 of this
amount as a portion of the taxing body.
3. Capital Fund—
The revised Proposed 2015 Budget includes an increase of $1,000,000 to cover
three projects related to street and alley paving:
Initial Revised Change Notes
Paving of one additional alley 250,000$ 250,000$ Per Council direction
1.5 additional alleys paved 400,000$ 400,000$ Delayed due to weather
and legal discussion
0.5 miles of additional streets
paved 350,000$ 350,000$
2014 General Fund surplus
to be transferred with Nov
24 2014 Budget
Amendment
1,000,000$ The funding for this additional $1,000,000 is broken down as follows:
Cost
Paving of one additional alley 250,000$
1.5 additional alleys paved 400,000$
0.5 miles of additional streets
paved 350,000$
1,000,000$
Funding Source
$125,00 G.O. Bonds funded by property taxes; $125,000 in
Special Assessment Fund G.O. Bonds (funded by resident
contributions)
2014 Carryover from CDBG funds
Transfer of 2014 General Fund Surplus
The 2015 Proposed Budget originally included $7.58M in new G.O. Bonds for capital
projects, which is below the $8.33M issued in 2014. The additional alley will increase
the budgeted G.O. Bond issue amount paid from property taxes to $7.73M, which is still
$600,000 below the 2014 level.
Page 2 of 3
67 of 73
VITAL RECORDS Attachment 1
CURRENT FEES AND REVENUE PREDICTIONS
2014
Volume
Cost for
first
Each
Additional Totals
Birth 4000 10$ 2$ 57,232.00$
Death 1000 15$ 5$ 25,770.00$
83,002.00$
CHANGING FEES TO MATCH COUNTY:
2014
Volume Cost for
first
Each
Additional Totals
Birth 3600 15$ 4$ 85,017.60$
Death 900 17$ 6$ 26,931.60$
111,949.20$
Some Decrease in volume is expected with an increase
in Fees.
IF WE CHANGE THE FEES TO MATCH THE COUNTY:
Revenues 111,949.20$
Expenses 97,929.00$
Vital Records Net 14,020.20$
Page 3 of 3
68 of 73
1
FY 2015 INITIAL
PROPOSED
ADJUSTMENTS
FY 2015 FINAL
PROPOSED
ADJUSTMENTS
$ 2,500 $ 2,500
$ 122,000 $ 122,000
535,000$ 535,000.00$
423,830$ 423,830.00$
150,000$ 150,000.00$
150,000$ 150,000.00$
147,292$ 147,292.00$
75,000$ 75,000.00$
128,614$ 128,614.00$
100,000$ 100,000.00$
80,000$ 80,000.00$
48,000$ 48,000.00$
40,000$ 40,000.00$
18,247$ 18,247.00$
30,000$ 30,000.00$
(8,200)$ (8,200.00)$
3,000$ 3,000.00$
(1,667)$ (1,667.00)$
(7,000)$ (7,000.00)$
(35,000)$ (35,000.00)$
(50,000)$ (50,000.00)$
200$ 200.00$
(2,000)$ (2,000.00)$
(57,425)$ (57,425.00)$
(200,000)$ (200,000.00)$
Law Department
70,000$ 70,000$
(1,200)$ (1,200)$
557,838$ 557,838.00$
31,550$ 31,550.00$
5,000$ 5,000.00$
700$ 700.00$
(19,550)$ (19,550.00)$
(37,996)$ (37,996.00)$
(49,842)$ (49,842.00)$
(80,000)$ (80,000.00)$
Police
400,000$ 400,000$
25,475$ 25,475$
5,500$ 5,500$
Fire
21,000$ 21,000$
1,002$ 1,002$
2,000$ 2,000$
31,000$ 31,000$
3,000$ 3,000$
4,000$ 4,000$
(30,000)$ (30,000)$
147,600$ 147,600$
Miscellaneous Revenue
False Alarm Fees
Ambulance Services
Alarm Registration Fees
Fire Alarm Permits
Fire Building Inspections
Reimbursement for Fire Services & CPR Classes
Fire Dept Training Reimbursement
Plumbing Permits
RTA Grant
Police CTA and Barnes & Noble Detail (first time being budgeted)/accounting change in 2013
Violent Crime Victims Assistance Grant
Police Report Fees
HUD Emergency Shelter Grants
Zoning Fees
Historic Preservation Reviews
Elevator Permits
Electrical Permits
Ticket Fines-Parking
Liquor Licenses
One day Liquor Licenses
Community Development
Building Permits
Boot Release Fee
Natural Gas Utility Tax
Weights and Measures
Towing Charges
Property Sales and Rental
Evanston Motor Fuel Tax
Miscellaneous Revenue
Auto Rental Tax
Parking Meter Revenue
Pet Licenses
Athletic Contest Tax
Sales Tax - Home Rule
Personal Property Replacement Tax
Investment Income
State Use Tax
CITY OF EVANSTON FY 2015 BUDGET REDUCTION WORKSHEET
GENERAL FUND
RECOMMENDED REVENUES
City Clerk's Office
Miscellaneous Revenue
City Manager's Office
Cable Franchise Fee
Administrative Services
Sales Tax - Basic
State Income Tax
Parking Tax
Vehicle Licenses
From Economic Development Fund
Liquor Tax
Property Tax (southwest TIF)
69 of 73
2
(100,000)$ 12,000$
71,000$ 71,000$
3,100$ 3,100$
(800)$ (800)$
(37,248)$ (37,248)$
(20,000)$ (20,000)$
17,627$ 17,627$
10,000$ 10,000$
8,500$ 8,500$
(10,000)$ (10,000)$
60,000$ 60,000$
75,000$ 75,000$
1,000$ 1,000$
2,000$ 2,000$
10,000$ 10,000$
1,700$ 1,700$
180$ 180$
(9,150)$ (9,150)$
(24,820)$ (24,820)$
Subtotal Ongoing Revenue Increases/Decreases w/no change in rate 2,837,557$ 2,949,557$
70,000$ 70,000$
Subtotal New Revenue from new sources or higher fee rates 70,000$ 70,000$
2,907,557$ 3,019,557$
(833)$ (833)$
(650)$ (650)$
(2,500)$ (2,500)$
(59,200)$ (59,200)$
32,200$ 32,200$
(50,000)$ (50,000)$
(45,000)$ (45,000)$
(30,000)$ (30,000)$
Contract Savings-- Auditing and Armored Cars (50,500)$ (50,500)$
(29,134)$ (29,134)$
(21,982)$ (21,982)$
(11,500)$ (11,500)$
(27,054)$ (27,054)$
(23,290)$ (23,290)$
Telecommunications equipment
Consulting services/seasonal employees
Miscellaneous Program costs & Licensing
Decrease in local printers/ Office Supplies
Towing and Booting Contract Savings
Administrative Services
Citation and Secondary Collection Processing
Unemployment compensation & administration fees
M/W/EBE and Workforce Development Employee (eliminate $30,000 contract 2014)
City Manager's Office
Reduce contingency / Supplies
Law Department
Contracts for outside legal services/Services & Supplies
Department reduction detail - 3.0% cuts
City Clerk's Office
Office equipment maintenance
Books, publications, maps
Merchandise for resale
Administrative Services
Car Rental Tax
Subtotal Revenue Adjustments
Recommended reductions
City-wide budget adjustments - expenditures
Parks, Recreation and Community Services
Farmer's Market Licenses
Comm Aging Grant - Advocate
Other Federal Aid
Reduction of Golf Program Revenue
Right-of-Way Permits
Reimbursement for Salt Usage-District 65
Private elm tree insurance
Reimbursements-Services and Supplies
I Heart Evanston Trees
License, Permits, and Fees
Public Works
State highway maintenance
Misc Charges for Service
Damage to Traffic Signs/Street Lights
Il Vacant Property Grant
Misc Intergovernmental Revenue increase
Misc Charges for Service
Housing Code Violations
Rental Building Registrations
Health and Human Services
Birth and Death Certificates
70 of 73
3
(63,425)$ (63,425)$
(17,000)$ (17,000)$
(84,000)$ (84,000)$
(4,066)$ (4,066)$
(4,430)$ (4,430)$
Police
(5,000)$ (5,000)$
Fire
(3,865)$ (3,865)$
(169,549)$ (71,620)$
(21,452)$ (21,452)$
(1,200)$ (1,200)$
(1,333)$ (1,333)$
(5,000)$ (5,000)$
(6,150)$ (6,150)$
(10,925)$ (10,925)$
(12,000)$ (12,000)$
(14,000)$ (14,000)$
(21,000)$ (21,000)$
(35,300)$ (35,300)$
(35,718)$ (35,718)$
(68,000)$ (68,000)$
(87,000)$ (87,000)$
(117,998)$ (117,998)$
(160,000)$ (160,000)$
(1,903)$ (1,903)$
(2,351)$ (2,351)$
(3,532)$ (3,532)$
(3,900)$ (3,900)$
(4,517)$ (4,517)$
Printing (5,217)$ (5,217)$
(6,000)$ (6,000)$
(8,000)$ (8,000)$
Food (8,587)$ (8,587)$
(10,170)$ (10,170)$
(11,500)$ (11,500)$
(14,100)$ (14,100)$
(18,750)$ (18,750)$
(37,112)$ (37,112)$
(1,403,493)$ (1,305,564)$
GENERAL FUND - PROPOSED EXPENSES ADJUSTMENTS (ON-GOING)
19,500$ 39,500$
50,000$ 50,000$
M/W/EBE and Workforce Development Employee (add new FTE 2014)100,000$ 100,000$
Community sponsored organizations (Connection for the Homeless / YWCA) 29,184$ 29,184$
21,868$ 21,868$
Community Development
Other - Supplies / Services
Increases in Uniform Costs
Administrative Services
Electricity
Elimination of Golf Program
Subtotal expenses adjustments
City-wide
Other commodities
Recreation supplies
Contrib to other agencies
Other program costs
Instructor services
City Manager's Office
Increases for Arts Funding
Advertising
Office supplies
Work- study
Other - Services and Supplies
Merchandise for resale
Elimination of Architect Position vacancy
Furniture and Fixtures
DED Inoculation Decrease (off year)
Parks, Recreation and Community Services
Membership dues
Debris/removal contractual costs
Other misc. Capital outlay
Botanical supplies
Minor equipment & tools
Natural gas
Postage chargebacks
Festival lighting
Office/other eqt mtn matl
Services & supplies
Traffic light electricity
Elimination of one position in Vital Records
Grant related Program Costs
Public Works
Security alarm contracts
Consulting services
Other - supplies / services
Telecommunications and personal computers
Membership dues
Misc. Other Services and Supplies
Health and Human Services
Community Development
Elevator contract costs
Construction engineering services
Moving 2126 to CDBG Fund
71 of 73
4
Increase for Seasonal Employees - Zoning Application Processing 17,000$ 17,000$
Police
100,000$ 100,000$
35,000$ 35,000$
Health and Human Services
190,696$ 190,696$
Two additional positions -- Both in GF 140,000$ 140,000$
(General Assistance Specialist and Medical Billing Clerk)
Contract with Presence for Crisis Intervention Services 54,333$ 54,333$
Public Works
Snow / Ice Overtime and Salt 393,500$ 393,500$
Additional Snow-related Service Agreements/Contracts 38,000$ 38,000$
Additional Training 10,000$
Rate increase for electricity 13,000$ 13,000$
Seasonal employees 11,067$ 11,067$
Outreach Program Costs (BG, iHeart Trees, and Bicycle Safety Outreach)7,500$ 7,500$
Parks, Recreation and Community Services
Increase Workforce Development (from Economic Development Fund)110,000$ 110,000$
Service Agreements/Contracts / Program supplies 17,901$ 17,901$
SUBTOTAL NEW EXPENSES REQUESTS (ON-GOING)1,348,549$ 1,378,549$
GENERAL FUND - PROPOSED EXPENSES ADJUSTMENTS (ONE-TIME)
City-wide Copier and Toner Replacement (RFP going out in 2014)110,000$ 110,000$
Fire
11,400$ 11,400$
Public Works
Services and Supplies 25,400$ 25,400$
SUBTOTAL NEW EXPENSES REQUESTS (ONE-TIME)146,800$ 146,800$
SUBTOTAL NEW EXPENSES REQUESTS 1,495,349$ 1,525,349$
124,641$ 124,641$
20,921$ 20,921$
TOTAL PROPOSED REVENUES (General Fund - baseline)89,185,298$ 89,185,298$
TOTAL PROPOSED EXPENDITURES (General Fund baseline + salary increases)89,688,247$ 89,688,247$
TOTAL PROPOSED DEFICIT (General Fund)(502,949)$ (502,949)$
TOTAL REVENUE ADJUSTMENTS (General Fund)2,907,557$ 3,019,557$
3% CUTS PROPOSED (1,403,493)$ (1,305,564)$
TOTAL DEFICIT REDUCTION (General Fund)4,311,050$ 4,325,121$
TOTAL REVISED PROPOSED REVENUES (General Fund)92,092,855$ 92,204,855$
TOTAL REVISED PROPOSED EXPENSES (General Fund)88,284,754$ 88,382,683$
PROPOSED SURPLUS / (DEFICIT)3,808,101$ 3,822,172$
NEW TRANSFER TO DEBT SERVICE / TAX LEVY REDUCTION 1,414,583$ 1,414,583$
NEW TRANSFER OF TAX LEVY TO POLICE PENSION FUND 310,928$ 310,928$
NEW TRANSFER OF TAX LEVY TO GENERAL ASSISTANCE FUND 462,000$ 462,000$
GENERAL FUND BALANCE AFTER TRANSFERS 1,620,590$ 1,634,661$
NEW EXPENSE REQUESTS 1,495,349$ 1,525,349$
PROPOSED 2015 BUDGET SURPLUS/(DEFICIT)125,241$ 109,312$
Increases to Transfer to Debt Service -- ERI (General Fund Only - Due to wage increase)
Increases in transfers to Fleet Fund (5%)
Township portion of Community Purchased Services (to be transferred to Human Services Fund)
Medical Equipment Maintenance Agreement
Administrative Services
Animal Shelter Operating Expenses
Membership in Northeastern Illinois Crime Lab
72 of 73
5
WATER FUND
Position Reclassifications 6,000$ 6,000$
ECONOMIC DEVELOPMENT FUND
Workforce Development contribution 150,000$ 150,000$
CDBG
Transfer from General Fund/Community Development Housing Rehab 179,780$ 179,780$
Southwest TIF
2015 will have the final dispersement in this TIF 861,217$
Capital Fund
Increase for paving one additional alley in 2015 250,000$
Increase for paving 1.5 alleys approved in 2014 and delayed due to weather and legal discussions 400,000$
2014 surplus transfer for paving 0.5 miles of additional streets during 2015 350,000$
73 of 73