Loading...
HomeMy WebLinkAboutWK - November 28, 2017-9 C I T Y O F NDOVE 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 . (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV City Council Workshop Tuesday, November 28, 2017 Conference Rooms A & B 1. Call to Order — 6:00 p.m. 2. Fire Department Update — Fire 3. Discuss Ham Lake Proposed Development —Engineering 4. Discuss Parking Issues at Prairie Knoll Park — Engineering 5. 2018 Budget Development/Tax Levy Final Review Before Public Hearing - Administration 6. 2017 Budget Progress Reports -Administration 7. October 2017 City Investments Review - Administration 8. Other Business Closed Session 9. City Administrator Performance Appraisal 10. Adjournment 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 . WWW.ANDOVERMN.GOV TO: CC: FROM: SUBJECT: DATE: Mayor and Council Members Jim Dickinson, City Administrat( David D. Berkowitz, Director of Engineer Discuss Ham Lake Proposed Development —Engineering November 28, 2017 INTRODUCTION The City Council is requested to review and discuss the attached proposed Ham Lake development. DISCUSSION Attached is a proposed development in Ham Lake that borders the City of Andover. There are two questions staff is requesting direction from the City Council. Is there support to extend University Avenue north of Crosstown Boulevard? Is there support to make a road connection to 173`d Lane to provide a secondary access/egress to the Genthon Ponds development? The cul-de-sac at the end of 173`d Lane has a sign (Temporary Cul-de-sac) that indicates that the road will be extended in the future. Details will be presented and discussed at the meeting. The developer (Jeff Stalberger) will be attending the meeting and can provide more information regarding the proposed development. ACTION REQUIRED The City Council is requested to provide direction on how to proceed regarding the questions identified above. Respectfully submitted, David D. Berkowitz Attachments: Location Map E ail and Proposed Development Layout Received from Ham Lake Cc: Jeff Stalberger (Email) y ♦ j !l i ✓ t J> �� -t�" -•. ' �-rte ? r ; pw lw� FAR 69 �_•� \��r � V�� 4 y '� Jam^ , ` A 1� � % � 7 � t U�am y -�_ 1. r - •. a-: PIP •r it '� ��ti +oy 2-,.Lir r�ti- aY-� \ �� �� � .-.�► - ,—:��1 ,,o sit! 1 ; •', P r air Dave Berkowitz From: Tom Collins <TCollins@rfcengineering.com> Sent: Tuesday, October 17, 2017 1:27 PM To: Dave Berkowitz Subject: proposed development Attachments: Stalberger street layout - Section 6.pdf Dave, Jeff Stalberger is proposing a development in Section 6 of Ham Lake. The attached Concept C, along with the proposed redlines per the ACHD, show the proposed road network. The southwesterly street is proposed to tie- in with existing 173`d Lane NW. In addition, University Avenue is proposed to be constructed over the east side of parcel 01-32-24-44-0009 (28 173`d Lane NW) and the proposed 33 -feet of right-of-way over the Ham Lake parcel directly to the east. The 33 -feet of right-of-way over parcel 01-32-24-44-0009 was dedicated with the Genthon Ponds Addition plat. I do not believe that Jeff has spoken with either parcel south of the proposed right-of-way (17251 Butternut Street NW or 99 Crosstown Boulevard NE) to determine whether the cul-de-sac will be extended further to the south to allow for additional development of these two parcels. Construction as proposed would trigger a JPA for maintenance responsibilities of University Avenue. Any questions, comments or concerns with what is proposed? Tom Collins RFC Engineering, Inc. 13635 Johnson Street Ham Lake, Minnesota 55304 (763) 862-8000 tcollins&rfcenaineering.com CONCEPT PLAN C In A NO" ,4, ; lit � I / r O r �/��/ —. � o�5f/•`fit°.. � ia.'gCf �� Csi�'+„• �L�--t 1��. �1 .. I L I 1 ,�jryu�H fP.QwU:�•a i cpMK sG d •" Professional Land Surveyors '-' Lake NE Suite 110 Lino Lakes, MN SS19 r �. • x..vr 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: CC: FROM: SUBJECT: DATE: Mayor and Council Members Jim Dickinson, City Administrator� David D. Berkowitz, Director of Pu c orks/City Engineer Todd J. Haas, Asst. Public Works Discuss Parking Issues at Prairie Knoll Park - Engineering November 28, 2017 INTRODUCTION The City Council is requested to discuss the parking issues that are occurring at Prairie Knoll Park. DISCUSSION As you know the last half of October and first week of November is playoff time for the youth football program. On one of the nights recently (October 25th), when playoff games were going on, the Anoka County Sheriffs Department received a call from a resident about vehicles parking in the ditch along 146th Lane NW. This is not the first time the resident has called about parking issues at the park as this has been an on-going concern by the residents over the past few years during both lacrosse and football seasons. The Sheriffs Department responded to the call on October 25th and issued 3 citations. There were other multiple individuals that moved their vehicle, so they were not cited. By moving the vehicles elsewhere, the drivers really had no place to park accept on 148th Lane NW (north side of the park), Palm Street NW (west of the park that can be accessed by the existing paved trail) and on Prairie Road since the south, north and east parking lot within the park were full. There is designated No Parking signs along both sides of 1461h Lane NW west of Prairie Road past the park. Prairie Road has a couple sections posted No Parking on both sides, north and south of 146' Lane NW so it does not restrict the site distance concerns for vehicles wanting to access onto Prairie Road or to cross the intersection. See attached aerial view of the park identifying the No Parking locations. To resolve the concerns that have been raised by the neighbors (mostly concerned with drivers parking in the ditch or grassy areas or designated no parking areas) and by the Sheriff s Department regarding safety specifically the parking on Prairie Road, there are options for the City Council to consider. They are as follows: Recommend allowing parking on the north side of 146th Lane NW west of Prairie Road. The concerns with removing no parking is that the existing street is narrow (24 feet) which will limit the movement of vehicles traveling east and west on 146th Lane NW especially emergency vehicles. The other concern is if the City were to allow parking on the north side of the street, damage will occur from vehicles parking on the shoulders and grassy areas which will create maintenance issues for Public Works. Staff recommends continuing restricting no parking on both sides of the street. • Recommend restricting parking on the east side of Prairie Road north and south of 146`h Lane NW. Posting no parking along this section will eliminate crossing by pedestrians across Prairie Road which is posted as a 50 mph by MNDOT. Staff would prefer to see an option that does not allow any parking on either side of Prairie Road NW. • Recommend restricting the number of games being played on any given night. Staff would suggest that no more than 2 games be played on any given night. The games could be played at the same time or could be played back to back. Note: Most games are being back to back since the referee officials referee both games. Staff has discussed with the football association in the past about spacing out the start time for the second game but that was a concern with the referees as they are not being paid to wait that long in between games. If the association schedules 3 games on the same night, there could be as many as 6 teams at the park at the same time or if the association schedules 4 games there could be as many as 8 teams at the park at the same time. With having 6 or more teams at the park at the same time is creating traffic concerns as there just is not enough parking stalls to accommodate that many teams and spectators/relatives/friends especially during the playoff games. Staff would recommend limiting the number of games per night to no more than 2 games a night either at the same time or back to back during the regular season and during football playoffs. There are two main concerns. First item is safety. Does the City want to continue allowing parking on Prairie Road? If the City does not want to see parking along Prairie Road, then it will be necessary to restrict the number of games being played or require the associations to space out the start time of the second game at least one hour or more if 6 or more teams are scheduled to play at the park. The second item is concerns of the neighbors located near the park. Vehicles are avoiding the streets posted No Parking by parking in the ditch/grassy areas and in areas of the parking lot that are not designated parking stalls. By City Code 8-4-1(I)3 it is unlawful to park and travel within City parks that are not designated for such purposes. If there is no interest in allowing parking in these areas by the City Council, the Sheriff's Department will direct the Deputies and CSO' to issue citations for the violations. This is not the first time the Sheriffs Department has been dispatched to the park regarding issues with parking. It has happened on numerous occasions over the past few years and the residents have continued to bring these concerns to City staff and to the Sheriff Department's attention that something needs to be done. One other item that was brought up over the past few years by one of the neighbors at the north end of the park is the existing gravel parking lot. The neighbors are having issues with dust from individuals that go to the park and from issues of individuals spinning around in the gravel which causes a lot of dust and grooves/ruts in the gravel. Public Works staff has regraded the parking lot and magnesium chloride is applied at least once or twice a year to help keep the dust down, which will deteriorate over time thus causing the parking lot to be dusty again later in the season. One of the other issues that has been brought to staff's attention is since the parking lot is not paved and striped, drivers are not doing a good job knowing how to park in the parking lot. Drivers are also driving in the grassy areas and driving in the ditches to leave the lot onto 148a' Lane NW rather than backing out of the parking stall and using the exits that are available at each end of the parking lot. The Park and Recreation Commission is recommending the parking lot be paved and security lighting be provided for the parking lot and the trail that provides access to the fields and building but did not identify the funding source to pay for it. Generally it would be funded by park dedication but with limited funds available it appears the Commission would like to see if other funds could become available to pay for it. Three of the neighbors did participate in the discussion with the Park and Recreation Commission (1 individual at the north end of the park and 2 from the south end of the park). The neighbor from the north end of the park recommends the City not allow any parking along Prairie Road NW for safety reasons and pave the north parking lot (with curbing). The two neighbors at the south end of the park also would like to see no parking be restricted along Prairie Road NW and continue enforcing the no parking signs along 146' Lane NW west of Prairie Road. They also mention paving the north parking will help some but was not the ultimate solution with presence of that many teams all at one time at the park. ACTION REQUIRED The City Council is requested to discuss the parking issues that are occurring recently at Prairie Knoll Park and recommend the option or options that will result in having a safer area and eliminate neighborhood parking concerns that have been raised. Respectfully submitted, 4AO_IAWI� Todd J. Haas Cc: Paul Lenzmeier, Anoka County Sheriff's Department (copy sent by e-mail) Jason Strasser, Andover Football Association (copy sent by e-mail) Dan Thinnes, Andover Area Lacrosse Association (copy sent by e-mail) Shane Stenzel, Park and Recreation Commission Chair (copy sent by e-mail) Gary Aus, Resident (copy hand delivered) Jim Linehan, resident (copy hand delivered) Attachment: Aerial view of Prairie Knoll Park; South and north parking lot drawing details, Draft Park Commission meeting minutes from November 16, 2017 725 1 665 1 645 0 I 14815 0 1486 NORTH 1{2 SECTION: 25 TOWNSHIP: 32 RANGE: 24 Map Date: Oct 17, 2005 N 1.y t 3" Y 14755 0 ✓ l 2 � 0 I 14655 . 650 580 v m I m 710 co I 14590 I 840 a v 541 p 715 14545 EnEn o it't F cl) C NORTH 1{2 SECTION: 25 TOWNSHIP: 32 RANGE: 24 Map Date: Oct 17, 2005 II I j 'I ALL SIRIPMO 6HALL BE � SIX10 MHIft DIRMSONS AAE MDR THE EDGE OF W. µO M FACE CURB TO CEHIBA 6TNPE ONIEBB ROM ALL PHOW0 SCALLS ARE 10' fi le' DIAGONAL STRIPING SHALL BE 10' 0.1% iW'• w F 69 SEALLB - TryE 0 BAA UME — W/ PARWNG LOi CIASID SIGN `ME C ROAD WJRY.µUp SCN PucE Gar rasr oP 011MNCE 0 C) Q - ° 3 - TME N eAPP1CABE 146TH LANE N.W. B/ PMRIHO LOT 0.0BC0 SIM a J/ TRE C flOAO FA6MOT ORNF FNMµµF/-0 SIGN _ PUCE 30W CE SOu-1, goYK,v� loi' -' 89 g -'As (Pavel) ° =—W. W. �""`W �p�"��� I CITY O F PRAIRIE KNOLL PARK PARKING LOT IMPROVEMENTS I SOUTH PARKING LOT �pp ����� DOVE CITY PROJECT NO. 14-14 BASE BID LAYOUT /STRIPING PLAN 9oG ��'P1e`J•�- -� eu S.A.P. 198-117-003 AND 190-101-012 SHEET N0. 41 OF 46 SHEETS ITPE 0 6µplc W/ T11IlL GD3G E I I OR El OMIAY / RECONBM OT 61NWNWS TWL . P0.CPG9L r Emm E Ial ,1 PRWOSFD 6611 CONfAE2 CkO iW'• w F 69 SEALLB - TryE 0 BAA UME — W/ PARWNG LOi CIASID SIGN `ME C ROAD WJRY.µUp SCN PucE Gar rasr oP 011MNCE 0 C) Q - ° 3 - TME N eAPP1CABE 146TH LANE N.W. B/ PMRIHO LOT 0.0BC0 SIM a J/ TRE C flOAO FA6MOT ORNF FNMµµF/-0 SIGN _ PUCE 30W CE SOu-1, goYK,v� loi' -' 89 g -'As (Pavel) ° =—W. W. �""`W �p�"��� I CITY O F PRAIRIE KNOLL PARK PARKING LOT IMPROVEMENTS I SOUTH PARKING LOT �pp ����� DOVE CITY PROJECT NO. 14-14 BASE BID LAYOUT /STRIPING PLAN 9oG ��'P1e`J•�- -� eu S.A.P. 198-117-003 AND 190-101-012 SHEET N0. 41 OF 46 SHEETS 0 — TfPE IA BIAPICIDE — — — — — — — — — — — W/ PANNING LOT LIDsED SON 148TH LANE N.W. BN. Iy f0E' w IR' two' Ill' rtor� Pourk�v�p Lod —Its si-wlls i /' ] - TYPE III BARRICADE W/ PAWING LOT MBEB RON ` —iw— TIP. THE C ROAD MW µG0 SIM PGCE ]W WEST OF MIRANCE IN ti 16 I 12Y ` PROPOSED 0• CONCREIE \ o PROPOsm BBI2 WANC1E CBO. \ \ PROPOSED RIM SEMFII I I / / 51PIPINO NOrts CG�a.Fel SulEoee� I I I I ALL TX@WO BNALL BE eSOu. DE SIE TDIOMENNSSONNS MEPE OM IME EDGE OF BIL AND OR FACE GIRD TERI I GNIEsi NOTED NL PNWNO SINLS ARE 1V x IV k A I OIAGONK ADDING SHALL BE AO' 0.0. i1TE IO BMflICAOE � W/ TPNL CWSFp 5GX� I / �� \\111hI I I I I I u ArR Gu EAGIINO SEOWBNTATON POND PRAIRIE KNOLL PARK PARKING LOT IMPROVEMENTS CITY PROJECT 140. 14-14 ALTERNATE 810 S.A.P. 198-117-003 AND 198-101-012 NORTH PARKING LOT LAYOUT / STRIPING PLAN Regular Andover Park & Recreation Commission Meeting Minutes —November 16, 2017 Page 6 Ms. Kelly (last name unknown) who lives on Silverod Street NW would like to see the trail e sion to allow for bicycles and strollers to easily access the park. e playgroup equipment is now for younger kids. She would like age ap riate equipment in e park for young and older kids. Sand volleyball, tennis co ould be issues. Chair Stenzel asked if e are any trees planted and Mr. Grode ed there were some planted but they will take hile to get large enough for sha . Chair Stenzel thanked the residents for coming and n d there are some funds av ' ble due to the water tower lease the City has with Verizon fo ing in the park. nvited residents to contact Mr. Haas with any other suggestions. Commissioner Butler agreed with the cone out parking. He stated it is better now than it used to be. The parking lot was ex d when the second ball field was added. The Commission should look at add' some Nvarking spots and making the entrance/exits safer. Chair Stenzel asked if anyone ould be opposed to moving shelter closer to the green space area. A number of sidents raised their hands. Mr. stated staff would not recommend that either. r. Haas mentioned that the reason the grounds are located near the infield are is that some parents may other children wi them that are not playing and hav' g to watch game close by and having their other ldren on the equipment ri adjacent to them is a benefit. Mr. Haas indicated he will ak with the ABA abo preading the games apart further to help out on the parking situate . Mraas stated the neighborhood will be surveyed before any equipmelK is or ered/installed for their input. �� DISCUSS PARKING ISSUESAT PRAIRIE KNOLL PARK 0 Mr. Haas reviewed with the Park and Recreation Commission regarding the last half of October and first week of November which is playoff time for the youth football program. On October 25, when playoff games were going on, the Anoka County Sheriff s Department received a call from a resident about vehicles parking in the ditch along 140h Lane NW west of Prairie Road. The Sheriff's Department responded to the call and issued 3 citations. There were multiple individuals that moved their vehicles, so they were not cited. By moving the vehicles elsewhere, the drivers really had no place to park except on 148th Lane NW (north side of the park) and on Prairie Road since the south, north and east parking lots were full. There is no parking allowed along both sides of 146a' Lane NW west of Prairie Road past the park. There are also a couple sections posted no parking on both sides of Prairie Road north and south of 146th Lane NW so it does not restrict the site distance concerns for vehicles wanting to access onto Prairie Road or to cross the intersection. An aerial view of the park identifying those no parking areas was provided in the packet. Regular Andover Park & Recreation Commission Meeting Minutes —November 16, 2017 Page 7 To resolve the concerns that have been raised by the neighbors (mostly concerned with drivers parking in the ditch or grassy areas or designated no parking areas) and by the Sheriff's Department regarding safety specifically the parking on Prairie Road, there are options for the Park and Recreation Commission to consider. The options are: • Recommend to the City Council to allow parking on the north side of 146th Lane NW west of Prairie Road. The concerns with removing no parking is that the existing street is narrow (24 feet) which will limit the movement of vehicles traveling east and west on 146' Lane NW especially emergency vehicles. The other concern is if the City were to allow parking on the north side of the street, damage will occur from vehicles parking on shoulders and grassy areas which will create maintenance issues with the Public Works Department. If the Commission would prefer a nice -looking area along the street, it is recommended to continue restricting no parking on both sides of the street. • Recommend to the City Council to restrict parking on the east side of Prairie Road north and south of 146th Lane NW. Posting no parking along this section will eliminate crossing Prairie Road which is posted as a 50 mph by MNDOT. • Restrict the number of games being played on any given night. Staff would suggest that no more than 2 games be played on any given night. The games could be played at the same time or could be played back to back. Most games are being back to back since the referee officials referee both games. Staff has discussed with the football association in the past about spacing out the start time for the second game but that was a concern with the referees as they are not being paid to wait that long in-between games. Once the association schedules 3 games there could be as many as 6 teams at the park at the same time or if the association schedules 4 games there could be as many as 8 teams at the park at the same time. With having 6 or more teams at the park at the same time is creating traffic concerns as there is not enough parking stalls to accommodate that many.teams and spectators especially during the playoff games. It really comes down to two items: First item is safety. The second item are concerns of the neighbors located near the park. This was not the first time the Sheriff's Department had been dispatched to the park regarding issues with parking. It has happened on numerous occasions over the past few years and the residents have continued to bring these concerns to City staff and to the Sheriff Department's attention that something needs to be done. A letter was sent to the neighbors that live around the park was provided for Commission review along with a map of the area identifying the property owners that were notified. The safety and parking concerns will be presented to the City Council at their Work Session meeting on November 28, 2017. Regular Andover Park & Recreation Commission Meeting Minutes —November 16, 2017 Page 8 Commissioner Miskowiec asked if the issue is people wanting to park close to their particular game. Mr. Haas stated when there are eight teams present there are many cars. Chair Stenzel stated he was at the park and people parked fairly well in the north lot and the other lots were full along with parking on the streets. This was during a playoff game. He cited other parks with parking issues during tournaments, etc. but just occasionally. He does not feel generally parking is a problem. Mr. Haas stated the neighbors are looking for enforcement of no parking areas. Commissioner Butler stated there is no funding available to pave and stripe the north parking lot. If it is only a couple times a year it could be worked with the association. Commissioner Lindahl asked about game scheduling. Mr. Jason Strasser, Andover Football Association President, reviewed the scheduling of the tournaments. He stated when the people arrive for the second game the north lot is not lighted. Mr. Strasser stated they often turn on the lights on both fields even when there are not games to help light the area. He has spoken to the Sheriffs Deputies that monitor the parking. Games are typically scheduled 1 '/2 hours apart and games typically last 1 '/4 hours. Andover has the largest football association in the North Metro. Most of the time Prairie Knoll Park has had adequate parking. Football is a short season. It was mentioned that better signage would help in the no parking areas. Mr. Haas stated they can look at additional signage. Mr. Dan Thinnes and Brian (last name unknown), representing the Andover Area Lacrosse Association (AALA), stated there is a parking problem and parents have tried to park on 146th Lane NW. They do use the parking area at the north end of the park when using smaller field. The south parking lot is not large enough to handle the overlap of games but there is overflow parking. signs in the south parking lot to direct drivers to park in the parking lot. He also stated that adding security lights along the trail would be nice and additional lighting in the north parking lot would be helpful. Brian from AALA stated there are a lot of people not aware of the north parking lot. AALA have been unable to communicate to the visiting teams but there is enforcement and the Sheriff Department is there often. Lt. Paul Lenzmeier, Anoka County Sheriff Department, was present at the meeting. He stated this was a problem 12 years ago also. There are not enough spots for parking and the Deputies are frustrated with dealing with this issue. There needs to be better signage for the no parking areas and better signage for the overflow parking. If the games could be spaced better that would help. His main concern is Prairie Road and allowing parking on both sides would be a bad choice. He would rather have parking on the north side of 146" Lane NW rather than on Prairie Road. Chair Stenzel asked if calls are related to parking on 146th Lane NW and Lt. Lenzmeier stated they are. Mr. Haas stated the City can designate the additional no parking areas by resolution. Mr. Haas stated a sight distance analysis was done at the intersection of 146h Lane NW and Prairie Road so allowing vehicle parking closer to the intersection would not be recommended by staff. Regular Andover Park & Recreation Commission Meeting Minutes —November 16, 2017 Page 9 Parking on the east side of Prairie Road presents more danger but neither are desirable. Chair Butler asked if signage can be improved. Mr. Haas stated they will address signage. Commissioner Butler left the meeting at 8:22 p.m. Mr. Gary Aus who lives on 146th Lane NW stated that on 146th Lane NW all it takes is one person to park in the ditch and others follow. The street is not wide enough for a fire truck to pass if vehicles are parked on both sides of the street. He stated the existing no parking signs help tremendously. He has seen as many as 50 cars parked on Prairie Road on both sides of the road. Cars are going over 50 mph on that road. He doesn't think there should be parking on the east side. He feels the speed should remain at 35 mph. The games are scheduled too close together. He asked why other parks can't be used for football games. Commissioner Lindahl asked how many times Mr. Aus sees cars parked on both sides of Prairie Road. Mr. Aus stated there generally are more vehicles parked there for the football games. There are cars parking in the ditch at the south end of the park by the overflow parking lot sign that is posted. Mr. Aus has had his mailbox knocked over, his driveway used for a turn around and his lawn has been torn up. Mr. Aus said this park has been an issue since he moved into his house. Mr. Jim Linehan who lives on north side of the park on 148th Lane NW, stated he thought the north parking lot was going to be paved. He'd like to know how much is spent on maintenance. The lot needs to be paved with curbing. He stated parking on Prairie Road is dumb. He asked if it will take someone being killed before something is done. Something needs to be done with the pavilion. They are using the power box to get on the roof. He has made a lot of calls to the Sheriff's Department, but he is tired of looking after that park. He cannot have his windows open in the summer because of the dust. He stated the north lot is full often but if it was paved more people would park there. Ms. Gina (last name unknown) stated the no parking area has been enforced. She thinks more signage would be helpful. Parking on Prairie Road is very dangerous. Mr. Dan Thinnes, AALA, stated when the south parking lot was being paved, the north parking lot was used. He suggested expanding the north parking lot further to the east. Chair Stenzel suggested Football and Lacrosse Associations get together and petition the City to put in a pedestrian crossing on Prairie Road or speak with the adjacent landowner on the east side of Prairie Knoll Park north of 146th Lane NW to mow the property and rent/lease it so additional parking could be provided as an additional overflow parking lot. Mr. Strasser stated the football association has reduced its' use of Prairie Knoll Park fields over the past couple years. They only play 2-3 days per week. They practice on baseball fields throughout the City and use Sunshine Park fields for games and practices. Regular Andover Park & Recreation Commission Meeting Minutes — November 16, 2017 Page 10 Motion by Stenzel, seconded by Marinello, to recommend to the City Council to pave the jo north lot of Prairie Knoll Park and add lighting along the path. Motion carried on a 6 - ayes, 0 -nays, and 1 -absent (Butler) vote. PLAYGROUND EQUIPMENT REPLACEMENT PLAN (TERRACE AND 1ANPARKS). Mr. Haa requested the Parks and Recreation Commission to discuss playground equipment lacement plan for 2018. With Purple Park playground equipment bei on hold for 1 ye until the Community Center exploration plan has been co d and received by the 'ty Council, it is recommended by staff to consider replacin ne of the following playgro d structures at either Strootman Park or Terrace P Mr. Haas provided the followi information on each of the structures as follows: Strootman Park (Park 46 on the Park Map) — This park is in the al part of the City in a 2.5 -acre lot develop The existing playground equipme was installed in 2002. The equipment is outdated, aN the fall zone areas are sand rth rotting timber borders. Some of the rubber surfaces tha exist in the area are starti to peel off, the swing set sits too high and the paint is peeling f the metal on the e ipment. Some of the welds are also rusty. Terrace Park (Park 47C on the Park ' p) — T park is in the urban part of the City which are generally about a third of an/ i ize. The existing playground equipment was installed in 2002 and is in a little ' better condition than the equipment at Strootman Park but is still outdated. Thef ne is sand, and all the timber borders need to be removed. Of these two parks, Terrace Par is getting re use than Strootman Park. The Commission may want to hol off on the pla ound equipment replacement at Strootman Park until such tim e Commission has an opportunity to evaluate this park as part of the study to ermine if this is one of th parks where the playground equipment is not replaced t all or is downsized. From a cation perspective Terrace Park is the only park in s general area and having the play and structure replaced at this park makes sense. Haas noted Pine Hills South Park r already scheduled to be refurbished in 2018. Motion by Lind 1, seconded by Marinello, to recommend the CityVouncil replace the playground st cture at Terrace Park. Motion carried on a 6 -ayes, 0- ys, and 1 -absent (Butler) volt . A7onby MENT OF WORK SESSIONMEETING MLindahl, seconded by Commissioner Miskowiec, to adjourn the wo session meeting at 9:00 p.m. Motion carried on a 6 -ayes, 0 -nays, and 1 -absent (Butler) v te. 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: Mayor and Councilmembers FROM: Jim Dickinson, City Administrator SUBJECT: 2018 Budget Development/Tax Levy Final Review Before Public Hearing DATE: November 28, 2017 INTRODUCTION City Departments by July 1st submitted to Administration/Finance their proposed 2018 Annual Operating Budgets. Department budgets were reviewed for adherence to the Council's 2018 Budget Development Guidelines. The City Council has also had a number of reviews of the 2018 Proposed General Fund Budget that will be supported by the 2018 Tax Levy. On September 19th the City Council approved the 2018 Preliminary Levy certification. This approval was the outcome of the numerous budget workshops held by the Council over the summer. The Preliminary 2018 Budget proposes a total property tax levy of $12,416,357: $8,643,256 (69.61%) operational levy, $1,599,087 (12.88%) debt service levy, and $2,174,014 (17.51%) capital/watershed levy. (see attached Property Tax Levy spreadsheet) The 2018 Proposed Property Tax Levy is estimated to reduce the current City tax rate by over 7% but will generate additional tax revenue to preserve the City's current operations and infrastructure assets. This is a 4.00% increase in the gross tax levy. The Council has the right to reduce or keep constant this levy until the final certification date of December 28, 2017. By the November 28th workshop, property tax statements should have been received by all of the City of Andover residents and businesses. Much of what will be covered at the workshop will be repeat information with updates to date; Administration is looking for Citv Council direction as the final preparation steps for the December 5, 2017 Budget/Levy Hearing for the 2018 Budget nears. City Administration will review with the Council the bold italics items at the meeting. Also..... Administration/Finance will review with the Council the following attachments at the meeting: 1. Pay 2018 Valuation Estimates (pg. 8) 2. City ofAndover Property Tax Levy — 2014 to proposed 2018 s 9 —10,) 3. Proposed Resolution to Adopt the 2018 Budget and Tax Levy fpgs 11 —13) 4. City ofAndover 2018 Budget Summary by Fund Types (pgs 14 —23) 5. Proposed 2018 General Fund Revenue & Expense Summary (pgs 24 — 27) 6 Graphs that will be used at the December S 2017 Budget Hearing fts 28 — 34) DISCUSSION The following are the 2018 Budget Development guidelines adopted at the April 18`11 City Council meeting along with progress updates: 1) A commitment to a City Tax Capacity Rate to meet the needs of the organization and positioning the City for long-term competitiveness using sustainable revenue sources and operational efficiencies. Note: The Anoka County Assessor taxable market valuefigures for the City of Andover are reflecting close to a 16.22% increase in total taxable market value. The 2018 Proposed Property Tax Levy that was approved estimates reducing the current City tax rate by over 7%. (See attached City ofAndover Pay 2018 Valuation Estimates.) 2) A fiscal goal that works toward establishing the General Fund balance for working capital at no less than 45% of planned 2018 General Fund expenditures and the preservation of emergency fund balances (snow emergency, public safety, facility management & information technology) through targeting revenue enhancements or expenditure limitations in the 2017 adopted General Fund budget. Note: With property tax revenues making up close to 80% of the total General Fund revenues, cash flow designations approaching 50% would be appropriate and are recommended by the City's auditor. The 2018 proposed budget exceeds this guideline, also Emergency Fund Balances (approximately 3% of planned General Fund expenditures) are in place to stabilize a situation, not be a complete solution. 3) A commitment to limit the 2018 debt levy to no more than 25% of the gross tax levy and a commitment to a detailed city debt analysis to take advantage of alternative financing consistent with the City's adopted Debt Policy. Note: The proposed 2018 debt levy is at 12.88% of the gross tax levy, the 25% guideline provides reasonable margin to accommodate a 2018 Equipment and/or an Improvement Bond if necessary. Please keep in mind thatfor the 2017 & 2018 budgets, $500,000 & $525,000 respectively of existing debt levy is temporarily moved to a Capital Levy to fund planned equipment purchases (rather than issuing debt), that change decreases the debt levy percentage of the gross tax levy significantly. 4) A comprehensive review of the condition of capital equipment to ensure that the most cost- effective replacement schedule is followed. Equipment will be replaced based on a cost benefit analysis rather than a year based replacement schedule. Note: The City Vehicle Purchasing Committee has completed this analysis, and has made recommendations to the City Council as part of the 2018-2022 Capital Improvement Plan(CIP) development process. A public hearing was held October 17th on the 2018-2022 CIP and the CIP was adopted at that meeting. 5) The use of long-term financial models that identify anticipated trends in community growth and financial resources that will help designate appropriate capital resources for future City needs. The financial models will be used in the budget planning process to ensure that key short-term fiscal targets are in line with long-term fiscal projections. Note: The City continually maintains variousfinancial models to determine the long-term impacts of present day expenditures and financing decisions. Fiscal assumptions are based upon a complex set offinancial data including growth factors, tax capacity valuations, per capita spending and debt ratios. A long range financial model was reviewed with the Council during the budget deliberation discussions. 6) Continued commitment to strategic planning targeted toward meeting immediate and long- term operational, staffing, infrastructure and facility needs. Note: A strategic planning session was held with the City Council in 2015, with a final Council Community Vision and Organizational Goals and Values document approved by the City Council. Administration is to assure that direction provided in that document is integrated into various department work plans and budgets. 7) A management philosophy that actively supports the funding and implementation of Council policies and goals, and a commitment to being responsive to changing community conditions, concerns, and demands, and to do so in a cost-effective manner. Note: Management pays special attention to fiscal values, commercial & residential development or redevelopment, collaboration opportunities, service delivery and the livability/image of the community. Staffing: Administration did receive new staffing requests from the Fire Department for the 2018 budeet. One request was to expand the Duty -Crew model to cover weekends and the other was for an administrative support position to focus on mortine needs and community based education. After evaluation. Administration recommended the expansion of the Dutp-Crew model to cover weekends. Relative to the full-time administrative support position. I have requested that Human Resources pursue the use of existing staffing to address the administrative support and community based education proposal. There are some anticipated retirements and staff vacancies within the next few years; in response Administration is making a concerted effort to focus on appropriate succession planning effective utilization of internship opportunities in impacted departments continued cross -training of staff, part-time staffing and the potential realignment of existing resources. Personnel Related Implications: To date the following are projected issues facing personnel related expenses: 1. Human Resources has reviewed position -based salaries and our benefit package in detail to determine if the total package is competitive with other government entities. As part of the budget process, pay steps for eligible employees will be included in a 2018 budget proposal. A cost of living adjustment (COLA) for non -bargaining employees is also proposed. A Public Works Union contract was approved by the Council on September 191h, the new contract is set to expire on December 31, 2019. As part of that new contract, a 3% COLA is provided for in 2018. 2. A review ofthe health plan was conducted with our broker in July. The current employee health & dental plan provider is with HealthPartners. Administration authorized a marketing of the health plan to keep the rates inline as a rate increase under HealthPartners was proposed. Marketing was successful as Health Partners ultimately The City offers employees an open access high deductible plan ($5,000 family plan deductible and $2,500 single plan deductible) with a health spending account (HSA), this was implemented originally in 2006. As part of the program, the City pays for 100% of the single health insurance premium and 76% for a family health insurance premium. The City does contribute annually to the employee's HSA. Contractual Departments: 1. The City Attorney has agreed to a fee neutral status -quo service level contract for 2018. 2. The 2018 City of Andover Law Enforcement proposed expenditure budget is $3,053,526 which is offset by a Police State Aid revenue budget of $135,200 and School Liaison revenue budget of $95,529 reflecting a net tax levy impact of $2,822,797. The 2018 Sheriff s contract provides for: a. 80 hours per day of patrol service b. 6 hours per day of service provided by a Community Service Officer c. School Liaison Officers in the middle school and high school d. 2 Patrol Investigators e. 50% of the Crime Watch Program's coordinator position. It should be noted that the Sheriff's Department always provides the required number of deputies for all hours contracted by the City. If the Sheriff s Department has a vacancy or a deputy is injured etc.., they still provide the City with a deputy at straight time even though they may have to fill those hours with overtime which at times may cost the Sheriffs Department additional, but is not billable per the contract City Council direction was for Staff to secure a Status Ono Contract with the Anoka County Sheriff for 2018. Negotiations for a Status Quo Contract for 2018 reflected a 3.07% increase ($90.975) over the 2017 contract. The 2018 Law Enforcement Contract was approved at the October 3rd City Council meeting. Council Memberships and Donations/Contributions: The following memberships/contributions are included in the 2018 Budget: ■ North Metro Mayors Association $15,150 (GF) • Metro Cities $ 9,518 (GF) • Mediation Services $ 3,366 (GF) ■ YMCA — Water Safety Program $ 8,500 (GF) ■ Alexandra House $18,328 ($15,328 GF & $3,000 CG) ■ Youth First (Program Funding) $14,000 ($12,000 GF & $2,000 CG) • NW Anoka Co. Community Consortium - JPA $10,000 (GF) • Teen Center Funding (YMCA) $24,500 ($8,100 GF & $16,400 CG) • Family of Promise $ 3,000 (CG) ■ Lee Carlson Central Center for Family Resources $ 1,500 (GF) • Senior High Parties $ 1,000 (CG) • Stepping Stone $ 900 (CG) Some are funded via the General Fund(GF), and those that qualify for charitable gambling undine are done through the Charitable Gambling (CG) Special Revenue Fund Capital Projects Levy: Capital Projects Levy — The proposed 2018 Capital Projects Levy Budget specifically designates $2,134,014 of the general tax levy to capital projects and equipment needs relating to Capital Project Outlay ($275,000), Capital Equipment Purchases ($525,000) Road and Bridge ($1,169,014), Pedestrian Trail Maintenance ($100,000), Park Projects ($15,000) and Facility Maintenance Reserve ($50,000). Specific designation of the tax levy to anticipated City needs and priorities for transportation and trail maintenance, park projects and equipment outlays allows the City to strategically allocate its resources and raise the public's awareness of City spending priorities. The Road and Bridge levy is evaluated annually and along with Capital Outlay, Pedestrian Trail Maintenance and Park Levies increased/decreased according to the City Council budget guidelines. • Road and Bridge An adjustment was made to the Road & Bridge funding formula in 2014, primarily to stop the continual decrease in the levy that has been happening over the past few years due to decreases in the Anoka County Assessor taxable market value figures for the City of Andover. Based on Council discussion, consensus was to stop the decline in road funding and evaluate annually through the adopted City Council Budget Development Guidelines. It should be noted that in 2014, Local Government Aid (LGA) in the amount of $74,655 was used to help fund the Road & Bridge FuniL That State of Minnesota funding has largely gone away, down to $2,706 for 2016 and nothing budgeted for 2017 and 2018. Future increases in LGA or even the presence of LGAJar the City of Andover based on the current State formula are remote. The City of Andover Road & Bridge proposed levy of $1.169,014 for 2018 is a 4.74% increase over 2017. The City ofAndover provided a 2.0% increase in the Pedestrian Trail Maintenance levy to $63,075 for 2017, Administration is recommending another Pedestrian Trail Maintenance levy increase to $100.000 for 2018, a 58.54% increase in funding. • Park Improvements This levy is an annual appropriation to be used to underwrite park improvement projects as recommended by the Park and Recreation Commission and approved by the City Council. This funding is intended to be a supplemental source of capital funding for park projects that is separately identified in the City's Five -Year Capital Improvement Plan. The 2015 levy was $61.500, but only $15.000 was levied for 2016. $46.500 ofthe previous levy was re -assigned to the General Fund to focus on Park's maintenance/replacement items. In addition to the re -assigned funds an additional $43.500 of General Fund levv was assigned to Parks Repair/Replacement items for a total levy of $90.000 in 2016 and that continued for 2017. The 2018 General Fund levy assigned to Parks Repair/Replacement items levy is proposed to be $100.000. Again for 2018 Administration is recommending a Parks Project levy beset at $15,000. • Capital Equipment/Project Under the Capital Projects Levy, a levy is proposed to be designated to Capital Equipment/Project expenditures identified through the CIP process. Through this designation, the City, over time, will build a fund reserve to avoid cash flow "spikes" and address a wide range of capital improvement needs such as facility maintenance projects under a more controlled spending environment. The 2017 levy is $250.000, Administration is recommending a $25.000 increase to $275.000 for 2018. • Capital Equipment Purchases New, for the 2017 equipment purchases Administration/Finance proposed a straight $500,000 Capital Equipment Purchases Levy for the 2017 equipment purchases rather than through debt service levy and an equipment bond This process was anticipated to continue through 2018. Administration will be recommending that same process again or 2018, but increasing the levy by $25,000 to $525.000. • Facility Maintenance This is a new proposed $50,000 levy for 2018. The recent facility condition assessment study has identified many maintenance related repairs for City facilities such as roofs, HVAC, electrical panels, fire alarm systems, windows and air quality related items. Debt Service Levy: Annually the Finance Department conducts a detailed debt service analysis to monitor outstanding debt and to look for early debt retirement or refinancing opportunities that will yield interest expense savings to the City. (ata along with Ehlers & Associates have completed reviews to see if any refinancing opportunities are available now, of which there are none • we will continue to monitor refunding opportunities as markets can move quickly, and calculate potential savings for each issue that may meet parameters which may generate savings.) The proposed 2018 Debt Service levy is as follows: • 2010A G.O. Open Space Referendum $ 188,777 • 2012C Taxable G.O. Abatement Bonds $ 972,055 • 2014A G.O. Equipment Certificates $ 294,945 • 2016A G.O. Equipment Certificates $ 143,310 Total $1,599,087 The proposed 2018 Debt Service levy reflects a.68% decrease ($10,960). ACTION REQUESTED The Council is requested to receive a presentation and provide direction to staff. :ted, Taxable Market Values $3,500,000,000 $3,000.000,000 $2,500,000,000 $2,000,000,000 $1,500,000,000 $1,000,000,000 $500,000,000 $0 Pay 2015 Pay 2016 Pay 2017 Pay 2018 Tax Capacity Values $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 $0 Pay 2015 Pay 2016 Pay 2017 Pay 2018 1e CITY OF ANDOVER Pay 2018 Valuation Estimates Pay 2015 Pay 2016 Pay 2017 Pay 2018 Taxable Tax Taxable Tax Taxable Tax Taxable lax Market Capacity Market Capacity Market Capacity Market Capacity Value Value Value Value Value Value Value Value Andover Valuation Totals $ 2,435,770,612 $ 25,705,350 $ 2,539,686,867 $ 26,847,273 $ 2,636,599,713 $ 27,920,178 $ 3,064,254,900 $ 31,321,817 Captured Tax Increment (210,936) (248,327) (91,996) (94,542) Fiscal Disparity Contribution (998,390) (1,055,284) (1,124,211) (1,184,728) Local Tax Rate Value 24,496,024 25,543,662 26,703,971 30,042,547 Fiscal Disparity Distribution 4,257,801 4,264,789 4,516,466 4,807,372 Total Adjusted Values $ 28,753,825 $ 29,808,451 $ 31,220,437 $ 34,849,919 3.67% 4.74% 11.63% Taxable Market Value Tax Capacity Value % Change % Change Pay 2015 $ 2,435,770,612 Pay 2015 $ 25,705,350 Pay 2016 $ 2,539,686,867 4.27% Pay 2016 $ 26,847,273 4.44% Pay 2017 $ 2,636,599,713 3.82% Pay 2017 $ 27,920,178 4.00% Pay 2018 $ 3,064,254,900 16.22% Pay 2018 $ 31,321,817 12.18% Taxable Market Values $3,500,000,000 $3,000.000,000 $2,500,000,000 $2,000,000,000 $1,500,000,000 $1,000,000,000 $500,000,000 $0 Pay 2015 Pay 2016 Pay 2017 Pay 2018 Tax Capacity Values $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 $0 Pay 2015 Pay 2016 Pay 2017 Pay 2018 1e City of Andover, Minnesota Property Tax Levy Other Levies Capital Projects Levy Capital EquipmenVPmject Derfified Certified Certified Certified Requested 2.21% $ Change 1000% Capital Equipment Purchases 2014 2015 2016 2017 Mill %of Total $ s % General Fund Levv - - - - 50,000 0.40% S W.000 nle General Operations $ 7.435,891 $ 7,630,892 $ 7,947,528 $ 8,254,354 $ 8,543,256 68.81% $ 280,902 3.50% Parks Repe r(Replacement Items 967.197 967,197 9.000 90,000 100,000 0,81% $ 10.000 11.11% Total General Fund 7,435,891 7,630,692 8.037,528 8,344,354 11,643,256 69.61% $ 298,902 3.58% Debt Service Funds Lew 2004 EDA Public Facility Revenue Bonds 181,803 - - - - 0.32% $ 0.00% 2010A G.O. Open Space Referendum Bonds 187,283 184,238 196,291 187,840 188,7P 17.51% $ 189,860 9.57% 2012A G.O. Equipment CediBcete 140,000 140.000 142,885 - - 100% S 477,802 4.00% 20128 G.O. Cap Improv Refunding Bonds 561,015 540,120 498,435 - - 2012C Taxable G.O. Abatement Bonds 740.965 975,652 977,332 974,418 972,055 2014A G.O. Equipment Ce0 ricate 260,000 296,055 295,470 295,260 294.945 2016A G.O. Equipment COdicate 152,529 143,310 Total Debt Service 2,071,066 2,136,131 2,100,413 1,610,047 1,599,087 12.88% $ (10,960) 4).68% Other Levies Capital Projects Levy Capital EquipmenVPmject 210,000 250.000 2W,000 2W,000 275,000 2.21% $ 25,000 1000% Capital Equipment Purchases - - - 50.000 525,000 4.23% $ 25,000 500% Facility Maintenance Reserve - - - - 50,000 0.40% S W.000 nle Pats Projects 61,500 61,500 15,000 15,000 15,000 0.12% S - 0.00% Road &Bridge 967.197 967,197 1,089.146 1,116.079 1.169,014 9.42% S 52,935 474% Pe0esinen That Maintenance 5.271 58,271 61,638 63,075 100,000 0.81% $ 36.925 58.54% Lower Rum River Welershed 40,000 40,000 40,000 40,000 40.000 0.32% $ 0.00% Total Other 14336,968 1,376,968 1,455,984 1,984,154 2,174,014 17.51% $ 189,860 9.57% Gross City Levy 10."3.925 11,143,925 11,593,925 11,938,555 12,416,357 100% S 477,802 4.00% Less Fiscal Disparities Distribution Local Tax Rate Levy S 1,718,153 9,125,772 1,846,295 S 9,297,630 1,586,747 It 10,007,178 1,736,647 $ 10,202,008 1,802,963 S 10,613,394 Less Levy Based on Metal Value f 187,283 f 184,238 f 186,291 $ 187,840 f 188,77] Net Local Tax Rate Levy S 8,938,489 S 9,113,392 S 9,820,887 $ 1.014,168 $ 10,424,617 Adjusted Tax Capacity Value" (1) 20,615,782 24,496,024 16.82% 26,543,662 4.28% 26,703,971 4.54% 30,042,547 12.50% Tax Capacity Rate"' 43.358% 37.204% 38.447% Tax Capacl y Rate W/O LRRWSD 43.197% 37.070% 38.314% Tax Capacity Rate With LRRWSD 43.657% 37.461% 38.702% Voter Approved Ref - MV 0.00841% 0.00719% 0.00699% "Adjusted Value def ermined by adjusting Por Fiscal Disparities and Tax Increment estimates. "' Blended rate due to the Cxy of Andover levying fpr Lower Rum River Wafershe f Cannot (1) Adjusted Tax Capacity Value is subject to change. Change % Change 37501% 34700% -2.801% -7470% 37.374% 37338% 0.00681% City of Andover Gross Tax Levy $14,000,000 $13,000,000 $12,000,000 $11,938,555 $11,000,000 $10,856,299 $11,143,925 $11,593,925 $10,000,000 $10,631,299 $10,631,299 $9,000,000 $8,000,000 $7,000,000 $6,000,000 $5,000,000 2011 2012 2013 2014 2015 2016 2017 2018 (L) CITY OF ANDOVER COUNTY OF ANOKA STATE OF MINNESOTA RES. NO. A RESOLUTION ADOPTING THE CITY OF ANDOVER 2018 BUDGET AND 2018 PROPERTY TAX LEVY TO BE CERTIFIED TO THE COUNTY AUDITOR. WHEREAS, the preparation and adoption of budgets is recognized as sound financial practice; and WHEREAS, the City of Andover receives significant financial support from its residents through the payment of property taxes; and WHEREAS, the City of Andover has the responsibility to appropriately and efficiently manage the public's funds; and WHEREAS, Minnesota State Law requires the City to certify to the County Auditor an adopted tax levy and budget prior to December 28, 2017; and WHEREAS, Minnesota State Law requires the City to certify to the State of Minnesota Department of Revenue an adopted tax levy by December 28, 2017. NOW, THEREFORE, BE IT RESOLVED that the City Council of the City of Andover hereby adopts the 2018 City of Andover Budget and the 2018 property tax levy totaling $12,416,357 as listed on Attachment A. BE IT FURTHER RESOLVED that the City Council of the City of Andover hereby establishes the 2018 City of Andover Budget by fund type as follows: REVENUES General Fund Special Revenue Funds Debt Service Funds Capital Projects Funds Enterprise Funds Internal Service Funds Total Adopted by the City of Andover this ATTEST: Michelle Harmer — Deputy City Clerk $ 11,085,238 1,577,018 1,899,087 3,821,437 5,426,952 1,172,633 $ 24,982,365 day of December 2017. EXPENDITURES General Fund $ 11,265,315 Special Revenue Funds 1,656,938 Debt Service Funds 1,803,555 Capital Projects Funds 7,159,569 Enterprise Funds 5,313,315 Internal Service Funds 1.221.072 Total $ 28,419,764 CITY OF ANDOVER Julie Trude - Mayor lk CITY OF ANDOVER, MINNESOTA 2018 Property Tax Levy 2018 General Fund Levy General Operations $ 8,543,256 Park Repair/Replacement Items 100,000 Total General Fund 8,643,256 Debt Service Funds Levy 2010A G.O. Open Space Referendum Bonds 188,777 2012C Taxable G.O. Abatement Bonds 972,055 2014A G.O. Equipment Certificate 294,945 2016A G.O. Equipment Certificate 143,310 Total Debt Service 1,599,087 Other Levies Capital Projects Levy Capital Equipment/Project 275,000 Capital Equipment Purchases 525,000 Facility Maintenance Reserve 50,000 Parks Projects 15,000 Road & Bridge 1,169,014 Pedestrian Trail Maintenance 100,000 Lower Rum River Watershed 40,000 Total Other 2,174,014 Gross City Levy $ 12,416,357 LZ Attachment A STATE OF MINNESOTA) COUNTY OF ANOKA ) CITY OF ANDOVER I, the undersigned, being the duly qualified and acting City Clerk of the City of Andover, Minnesota, do hereby certify that I have carefully compared the attached Resolution No. adopting the City of Andover 2018 Budget and 2018 Property Tax Levy with the original record thereof preserved in my office, and have found the same to be true and correct transcript of the whole thereof. IN TESTIMONY WHEREOF, I have hereunto subscribed my hand this day of December 2017. Michelle Hartner — Deputy City t3 General Fund Revenues: $11,085,238 Expenditures: $11,265,315 -General Government Public Safety Public Works Fund Definitions CITY OF ANDOVER 2018 Budget Summary By Fund Type City of Andover - Budgeted Funds Total Revenues: $24,982,365 Total Expenditures: $28,419,764 I Governmental Funds I Special Revenue Funds Revenues: $1,577,018 Expenditures: $1,656,938 -EDA -Drainage & Mapping -LRRWMO -Forestry -ROW Mgmt / Utility -Construction Seal Coating -Community Center -CDBG -Charitable Gambling Debt Service Funds Revenues: $1,899,087 Expenditures: $1,803,555 G.O. Improvement Bonds G.O. State Aid Bonds G.O. Equip Certificates G.O. Referendum Bonds G.O. Abatement Bonds Capital Projects Funds Revenues: $3,821,437 Expenditures: $7,159,569 Water Trunk Storm Sewer Sewer Trunk Road & Bridge Trail & Transportation Cap Equip Reserve Tax Increment Park Dedication PIR Projects Building -Capital Notes / Bond Projects Proprietary Funds Enterprise Funds Revenues: $5,426,952 Expenditures: $5,313,315 Sewer Fund Water Fund Storm Sewer Fund Internal Service Funds Revenues: $1,172,633 Expenditures: $1,221,072 Equipment / Maint. Management General Fund - accounts for the revenues and expenditures necessary to carry out basic governmental activities of the City such as general government, public safety, public works, and other. Special Revenue Funds - accounts for revenue sources that finance particular functions and projects. Debt Service Funds - accounts for the accumulation of resources for, and the payment of general long-term debt. Capital Projects Funds - accounts for the acquisition or construction of major capital facilities financed mainly with governmental fund sources, general obligation debt, special assessments, and other. Enterprise Funds - accounts for activities that consist of rendering services or providing goods to the public for which a fee or charge is collected. Internal Service Funds - accounts for goods and services that are provided to other City departments, or to other governments, on a cost reimbursement basis. L{ Fund Balance/Net Assets, January 1 Revenues & Other Sources General Special Revenue Debt Service Capital Projects Enterprise Internal Service Total Revenues & Other Sources: Total Available: Expenditures & Other Uses General Special Revenue Debt Service Capital Projects Enterprise Internal Service Total Expenditures & Other Uses: Fund Balance/Net Assets, December 31 Change in Fund Balance CITY OF ANDOVER 2018 Budget Summary Revenues and Expenditures Fund Summary Actual Adopted 2016 2017 $ 38,975,332 11,038,567 1,583,550 2,408,636 6,528,567 5,344,379 1,239,267 28,142,966 67,118,298 10,509,726 1,516,166 2,308,449 5,335,317 4,733,099 1,027,173 25,429,930 $ 41,688,368 $ 2,713,036 6.96% ' S $ 41,688,368 10,825,139 1,567,000 1,910,047 5,053,538 5,315,854 1,161,507 25,833,085 67,521,453 10,992,219 1,686,420 2,269,238 7,353,217 5,292,421 1,207,471 28,800,986 $ 38,720,467 $ (2,967,901) -7.12% Estimate Budget 2017 2018 $ 41,688,368 10,998,472 1,539,700 1,905,047 6,841,002 5,299,854 1,162,985 27,747,060 69,435,428 11,729,471 1,571,034 2,270,639 6,918,962 5,292,421 1,215,341 28,997,868 $ 40,437,560 $ (1,250,808) -3.00% $ 40,437,560 11,085,238 1,577,018 1,899,087 3,821,437 5,426,952 1,172,633 24,982,365 65,419,925 11,265,315 1,656,938 1,803,555 7,159,569 5,313,315 1,221,072 28,419,764 $ 37,000,161 $ (3,437,399) -8.50% CITY OF ANDOVER 2018 Budget Summary Revenues and Expenditures by Fund Type Special Debt Capital Internal General Revenue Service Projects Enterprise Service Total Fund Balance/Net Assets, January 1 $ 7,065,746 $ 705,492 $ 951,895 $ 23,281,066 $ 7,528,819 $ 904,542 $ 40,437,560 Revenues General Property Taxes 8,721,256 40,000 1,599,087 2,134,014 - - 12,494,357 Tax Increments - - - 85,000 - - 85,000 Special Assessments - - - 402,400 - - 402,400 Licenses and Permits 377,900 - - - - - 377,900 Intergovernmental 766,274 37,500 - 430,899 - - 1,234,673 Charges for Services 746,700 693,900 - - 5,186,102 1,169,633 7,796,335 Fines 90,250 - - - - - 90,250 Investment Income 75,000 6,050 - 158,000 46,000 3,000 288,050 User Charges - - - 182,324 - - 182,324 Meters - - - - 13,000 - 13,000 Permit Fees - - - - _ _ - Penalties - - - - - _ _ Miscellaneous 129,300 799,56667,000 995,868 Total Revenues: 10,906,680 1,577,018 1,599,067 3,392,637 5,312,102 1,172,633 23,960,167 Other Financing Sources Operating Transfers In 178,558 - 300,000 428,800 114,850 - 1,022,208 Bond Proceeds - - - - _ _ - Proceeds from Sale of Property Total Other Financing Sources: 178,558 300,000 428,800 114,850 1,022,208 Total Revenues and Other Sources: 11,085,238 1,577,018 1,899,087 3,821,437 5,426,952 1,172,633 24,982,365 Total Available: 18,150,984 2,282,510 2,850,982 27,102,503 12,955,771 2,077,175 65,419,925 Expenditures Personal Services 4,938,919 546,795 - - 1,067,991 456,090 7,009,795 Supplies and Materials 693,423 87,020 - - 320,700 404,810 1,505,953 Purchased Services 4,074,764 233,294 - - - - 4,308,058 Other Services and Charges 1,458,209 462,529 - 3,243,500 2,287,723 360,172 7,812,133 Capital Outlay 100,000 22,000 - 3,604,500 258,000 - 3,984,500 Debt Service 1,803,555 196,719 776,843 2,777,117 Total Operating Expenditures: 11,265,315 1,351,638 1,803,555 7,044,719 4,711,257 1,221,072 27,397,556 Other Uses Operating Transfers Out - 305,300 - 114,850 602,058 - 1,022,208 Bond Discount - - - - _ _ _ Redemption of Refunded Bonds Total Other Uses: 305,300 114,850 602,058 1,022,208 Total Expenditures and Other Uses: 11,265,315 1,656,938 1,803,555 7,159,569 5,313,315 1,221,072 28,419,764 Fund Balance/Net Assets, December 31 $ 6,865,669 $ 625,572 $ 1,047,427 $ 19,942,934 $ 7,642,456 $ 856,103 $ 37,000,161 Change in Fund Balance $ (180,077) $ (79,920) $ 95,532 $ (3,338,132) $ 113,637 $ (48,439) $ (3,437,399) -2.55% -11.33% 10.04% -14.34% 1.51% -5.36% -8.50% CITY OF ANDOVER 2018 Budget Summary Revenues and Expenditures - All Funds L� Actual Budget Estimate Budget 2016 2017 2017 2018 Fund Balance/Net Assets, January 1 $ 38,976,332 $ 41,688,368 $ 41,688,368 It 40,437,560 Revenues General Property Taxes 11,809,352 12,014,555 12,016,555 12,494,357 Tax Increments 91,808 118,480 65,000 85,000 Special Assessments 818,085 687,000 845,069 402,400 Licenses and Permits 625,907 367,705 465,375 $77,900 Intergovernmental 1,564,848 2,118,552 2,901,166 1,234,673 Charges for Services 7,835,648 7,739,283 7,746,183 7,796,335 Fines 88,600 100,750 90,150 90,250 Investment Income 467,789 292,800 287,300 288,050 User -Charges, 997,340 270,183 469,559 182,324 Meters 28,591 13,000 13,000 13,000 Permit Fees - - - - Penalfles - 16,000 - - Miscellaneous 1,923,910 1,089,800 1,070,700 995,868 Total Revenues: 26,261,868 24,828,108 25,990,057 23,960,157 Other Financing Sources Operating Transfers In 1,343,223 1,004,977 1,757,003 1,022,208 Bond Proceeds 520,000 - - - Bond Premium - - - - ProceedsfromSaleofProperty 27,885 Total Other Financing Sources: 1,891,108 1,004,977 1,757,003 1,022,208 Total Revenues and Other Sources: 28,142,966 26,833,086 27,747,060 24,982,365 Total Available: 67,118,298 67,521,463 69,436,428 65,419,925 Expenditures Personal Services 6,427,059 6,873,621 6,819,503 7,009,795 Supplies and Materials 1,161,195 1,486,797 1,461,447 1,505,953 Purchased Services 3,944,957 4,348,669 4,157,053 4,308,058 Ober Services and Charges 6,614,537 8,300,233 8,501,583 7,812,133 Capital Outlay 2,698,380 3,540,800 3,056,015 3,984,500 Debt Service 3,240,579 3,245,889 3,245,264 2,777,117 Total Operating Expenditures: 24,086,707 27,796,009 27,210,865 27,397,656 Other Uses Operating Transfers Out 1,343,223 1,004,977 1,757,003 1,022,208 Bond Discount - - - - Redemption of Refunded Bonds Total Other Uses: 1,343,223 1,004,977 1,757,003 1,022,208 Total Expenditures and Other Uses: 25,429,930 28,800,986 28,997,868 28,418,764 Fund Balancelhiet Assets, December 31 It 41,608,368 $ 38,720,467 It 40,437,560 $ 37,000,161 Change in Fund Balance $ 2,713,036 $ (2,967,901) $ (1,250,808) $ (3,437,399) 6.96% -7.12% -3.00% -8.50% L� City of Andover 2018 Budget - General Fund Statement of Revenues, Expenditures and Changes in Fund Balance �k y t. u h�1oAcfua�l�fi3,aEstimat� lbe cndto�',�..!r.?,It Rh` 20 6 _rkbf#1iax>Pkn��r.20ref1.85� 2.O 7 17 e�q�dp"pedt� Fund Balance, January 1 Revenues General Property Taxes Licenses and Permits Intergovernmental Charges for Services Fines Investment Income Miscellaneous Revenue Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Personal Services Supplies and Materials Purchased Services Other Services and Charges Capital Outlay Total Expenditures: Other Uses Transfers Out $ 7,267,904 8,217,768 625,907 733,951 912,219 88,600 68,380 194,812 10,841,637 $ 7,796,745 $ 7,796,745 $ 7,065,746 8,420,354 367,705 766,150 773,950 100,750 75,000 124,300 10,628,209 8,422, 354 465,375 827,706 770,050 90,150 75,000 150,907 10,801,542 8,721,256 377,900 766,274 746,700 90,250 75,000 129,300 10,906,680 196,930 196,930 196,930 178,558 11,038,567 18,306,471 4,520,107 571,168 3,743,424 1,298,226 126,801 10,259,726 250,000 10,825,139 18,621,884 4,889,974 685,417 3,902,989 1,423,839 90,000 10,992,219 10,998,472 18,795,217 4,827,986 668,367 3,971,629 1,421,489 90,000 10,979,471 750,000 11,085,238 18,150,984 4,938,919 693,423 4,074,764 1,458,209 100,000 11,265,315 Total Expenditures and Other Uses: 10,509,726 10,992,219 11,729,471 11,265,315 Fund Balance, December 31 $ 7,796,745 Change in Fund Balance $ 528,841 7% $ 7,629,665 $ (167,080) -2% $ 7,065,746 $ (730,999) -9% $ 6,885,669 $ (180,077) -3% City of Andover Special Revenue Funds 2018 Budget Summary - All Special Revenue Funds Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues General Property Taxes Intergovernmental Charges for Services Investment Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Personal Services Supplies and Materials Purchased Services Other Services and Charges Capital Outlay Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: $ 669,442 $ 736,826 40,106 701,722 10,949 830,773 1,583,550 1,583,550 2,252,992 488,400 84,081 201,533 387,493 47,859 1,209,366 306,800 1,516,166 40,000 37,500 687,200 5,800 796,500 1,567,000 1,567,000 2,303,826 515,791 89,020 240,680 469,929 66,000 1,381,420 305,000 1,686,420 $ 736,826 $ 705,492 40,000 699,000 5,700 795,000 1,539,700 1,539,700 2,276,526 515,791 80,720 185,424 418,099 66,000 1,266,034 305,000 1,571,034 Fund Balance, December 31 $ 736,826 $ 617,406 $ 705,492 Change in Fund Balance $ 67,384 $ (119,420) $ (31,334) 10% -16% -4% �ci 40,000 37,500 693,900 6,050 799,568 1,577,018 1,577,018 2,282,510 546,795 87,020 233,294 462,529 22,000 1,351,638 305,300 1,656,938 $ 625,572 $ (79,920) -11% X�4�6.11, ed �G,3 lauvt` st e ; 'r...,x nw�+Ahdo�;wprtiedc°a,. .myFu ec tto�1M 6. *20a1tZd �e..<.t;;ur*;�Or1c��a�20a�ii%°1£; Fund Balance, January 1 Revenues General Property Taxes Intergovernmental Charges for Services Investment Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Personal Services Supplies and Materials Purchased Services Other Services and Charges Capital Outlay Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: $ 669,442 $ 736,826 40,106 701,722 10,949 830,773 1,583,550 1,583,550 2,252,992 488,400 84,081 201,533 387,493 47,859 1,209,366 306,800 1,516,166 40,000 37,500 687,200 5,800 796,500 1,567,000 1,567,000 2,303,826 515,791 89,020 240,680 469,929 66,000 1,381,420 305,000 1,686,420 $ 736,826 $ 705,492 40,000 699,000 5,700 795,000 1,539,700 1,539,700 2,276,526 515,791 80,720 185,424 418,099 66,000 1,266,034 305,000 1,571,034 Fund Balance, December 31 $ 736,826 $ 617,406 $ 705,492 Change in Fund Balance $ 67,384 $ (119,420) $ (31,334) 10% -16% -4% �ci 40,000 37,500 693,900 6,050 799,568 1,577,018 1,577,018 2,282,510 546,795 87,020 233,294 462,529 22,000 1,351,638 305,300 1,656,938 $ 625,572 $ (79,920) -11% City of Andover Debt Service Funds 2018 Budget - All Debt Service Funds Statement of Revenues, Expenditures and Changes in Fund Balance Y Y-3' +su�, F 1 v 'i "ire �ux�'s51MRt1 ,��" -. yfJ (Atex y y�.,,i i ea 1Actua 9u:N [ §h 10 Y J{°� 1 p7,FFAdopted }dEsmate, ''y < k 1`.e 0e, tAdopteY) D,escr� tion]dp� 0206027 Change in Fund Balance $ 100,187 $ (359,191) $ (365,592) k,20�17t����2018���( 2,099,582 Fund Balance, January 1 $ 1,217,300 $ 1,317,487 $ 1,317,487 $ 951,895 Revenues Change in Fund Balance $ 100,187 $ (359,191) $ (365,592) General Property Taxes 2,099,582 1,610,047 1,610,047 1,599,087 Investment Income (2,363) - (5,000) - Total Revenues: 2,097,219 1,610,047 1,605,047 1,599,087 Other Sources Operating Transfers In 311,417 300,000 300,000 300,000 Total Revenues and Other Sources: 2,408,636 1,910,047 1,905,047 1,899,087 Total Available: 3,625,936 3,227,534 3,222,534 2,850,982 Expenditures Debt Service Principal 1,770,000 1,800,000 1,800,000 1,416,000 Interest 444,144 418,419 418,419 385,555 Other 1,325 2,000 1,375 2,000 Total Expenditures: 2,215,469 2,220,419 2,219,794 1,803,555 Other Uses Operating Transfers Out 92,980 48,819 50,845 - Total Expenditures and Other Uses: 2,308,449 2,269,238 2,270,639 1,803,555 Fund Balance, December 31 $ 1,317,487 $ 958,296 $ 951,895 $ 1,047,427 Change in Fund Balance $ 100,187 $ (359,191) $ (365,592) $ 95,532 8% -27% -28% 10% City of Andover Capital Projects Funds 2018 Budget Summary - All Capital Projects Funds Statement of Revenues, Expenditures and Changes in Fund Balance S ;N�f inytti F 30,200,028 2,519,865 3,977,470 Arab ,y �e� z� .r:.4 h Adopted s +r�'h 9 Yxt;+�/�i EStlm`a1:e 9araF' "'rq � A�dopted�ty ttF Fund Balance, January 1 Revenues General Property Taxes Tax Increments Special Assessments Intergovernmental Investment Income User Charges Miscellaneous Total Revenues: Other Sources Transfers In Bond Proceeds Proceeds from Sale of Capital Assets Total Other Sources: Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay Debt Service - Principal Retirement Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: $ 22,165,776 1,451,896 91,808 818,065 830,897 312,148 997,340 730,940 5,233,094 749,780 520,000 25,693 1,295,473 6,528,567 $ 23,359,026 1,944,154 118,480 687,000 1,314,902 163,000 270,183 102,000 4,599,719 453,819 $ 23,359,026 $ 23,281,066 1,944,154 85,000 845,069 2,073,460 162,600 469,559 55,315 5,635,157 1,205, 845 2,134, 014 85,000 402,400 430,899 158,000 182,324 3,392,637 453,819 1,205,845 428,800 5,053,538 6,841,002 3,821,437 28,694,343 28,412,564 30,200,028 2,519,865 3,977,470 4,028,000 2,522,220 3,124,800 2,640,015 196,719 196,719 196,719 5,238,804 7,298,989 6,864,734 96,513 54,228 54,228 5,335,317 7,353,217 6,918,962 Fund Balance, December 31 $ 23,359,026 Change in Fund Balance $ 1,193,250 5% ()N $ 21,059,347 $ (2,299,679) -10% $ 23,281,066 $ (77,960) 0% 27,102,503 3,243,500 3,604,500 196,719 7,044,719 114,850 7,159,569 $ 19,942,934 $ (3,338,132) -14% City of Andover Enterprise Funds 2018 Budget Summary - All Enterprise Funds Statement of Revenues, Expenditures and Changes in Fund Net Assets « k ..,[: ;t' +y, tCe yt A ctwal,°:,ut # Ado tetl �Esttrnate € sl Adopfed, aw r N �, a.£3rtla ,m rs� i'")` �S.,v :n l,�i -^r p 'zY6 Ts +� rt AIw 209�T� p�snt,.��20�° ..Y §s�' ,,r` av1,u,7e�.Descn3onsr,�,,, ,,,. �,zN�,9�,.,t?. ,20,16�e+t.r,.,LLr.,xfrry20,1z7ra"�a,., 8 ,., Unrestricted Net Assets, January 1 Revenues Charges for Services Interest Meters Penalties Miscellaneous Total Revenues: Other Sources Transfers In Gain on the Sale of Capital Assets Total Other Sources: Total Revenues and Other Sources: Total Available: Expenditures Personal Services Supplies and Materials Other Services and Charges Capital Outlay Debt Service Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: Unrestricted Net Assets, December 31 $ 6,910,106 $ 7,521,386 $ 7,521,386 $ 7,528,819 5,101, 941 68,768 28,591 57,791 5,257,091 85,096 2,192 87,288 5,344,379 12,254,485 1,011,254 225,491 2,069,533 1,500 828,391 4,136,169 596,930 4,733,099 $ 7,521,386 5,119,626 46,000 13,000 16,000 67,000 5,261,626 54,228 54,228 5,315,854 12,837,240 1,025,217 308,200 2,273,323 260,000 5,119,626 46,000 13,000 67,000 5,245,626 54,228 54,228 5,299,854 12,821,240 1,025,217 308,200 2,273,323 260,000 828,751 828,751 4,695,491 4,695,491 596,930 5,292,421 596,930 5,292,421 5,186,102 46,000 13,000 67,000 5,312,102 114,850 114,850 5,426,952 12,955,771 1,067,991 320,700 2,287,723 258,000 776,843 4,711,257 602,058 5,313,315 $ 7,544,819 $ 7,528,819 $ 7,642,456 Change in Unrestricted Net Assets $ 611,280 $ 9% 22Z 23,433 $ 7,433 $ 113,637 0% 0% 2% City of Andover Internal Service Funds 2018 Budget Summary - All Internal Service Funds Statement of Revenues, Expenditures and Changes in Unrestricted Net Assets wr"S'•op *J ;{fir , �a40 'w 2 s d9fir1 '•. Y1,11i" �Pescri ACtel &r ^:j tetl y#4yu " `. ' ` 'Estiinafe o ': ks Ado ted in.: a 1 Tgi Pt n � �':;: ' tionG x is y > c x ';;1,111 ONE +, •t ig ,.t k ,� x w :( zr�.J,20x1!6� Y��nr��1201��;n�;��;2tlflY8•�r Unrestricted Net Assets, January 1 Revenues Charges for Services Interest Income Miscellaneous Total Revenues: $ 744,804 $ 956,898 $ 956,898 $ 904,542 1,119,766 9,907 109,594 1,239,267 Other Sources Transfers In - Total Revenues and Other Sources: 1,239,267 Total Available: 1,984,071 Expenditures and Other Uses Personal Services 407,298 Supplies and Materials 280,455 Other Services and Charges 339,420 Total Expenditures: 1,027,173 Other Uses Transfers Out - Total Expenditures and Other Uses: 1,027,173 Unrestricted Net Assets, December 31 $ 956,898 Change in Unrestricted Net Assets $ 212,094 28% Z3 1,158,507 3,000 1,161,507 1,161,507 2,118,405 442,639 404,160 360,672 1,207,471 1,207,471 $ 910,934 1,157,507 3,000 2,478 1,162,985 1,162,985 2,119,883 450,509 404,160 360,672 1,215,341 1,215,341 $ 904,542 $ (45,964) $ (52,356) —5% —5% 1,169,633 3,000 1,172,633 1,172,633 2,077,175 456,090 404,810 360,172 1,221,072 1,221,072 $ 856,103 $ (48,439) —5% CITY OF ANDOVER General Fund Revenue & Expense Summary EXPENDITURES Actual Actual Actual Actual Actual Budget* Estimate Requested * Budget Change (*) General Government 2012 2013 2014 2015 2016 2017 2017 2018 $ % REVENUES 4,087,065 4,311,340 4,498,920 4,503,332 4,667,326 4,862,558 4,863,008 4,978,056 115,498 2.38% Property Taxes $ 7,340,532 $ 7,376,284 $ 7,476,295 $ 7,634,715 $ 8,217,768 $ 8,420,354 $ 8,422,354 $ 8,721,256 300,902 3.57% License and Pennits 449,826 536,707 364,430 452,616 625,906 367,705 465,375 377,900 10,195 2.77% Intergovernmental Revenues 653,720 710,071 697,491 749,570 733,953 766,150 827,706 766,274 124 0.02% Charges for Current Services 973,604 1,122,460 998,150 804,684 912,220 773,950 770,050 746,700 (27,250) -3.52% Fines and Forfeits 97,571 96,130 94,375 99,304 88,600 100,750 90,150 90,250 (10,500) -10.42% Interest Income 95,365 (17,096) 144,876 63,709 68,380 75,000 75,000 75,000 0 0.00% Miscellaneous Revenue 149,857 140,983 150,759 154,239 194,812 124,300 150,907 129,300 5,000 4.02% Transfers 196,930 196,930 196,930 196,930 196,930 196,930 196,930 178,558 (18,372) -9.33% TOTAL REVENUES 9,957,405 10,162,469 10 123,306 10,155,767 11,038,569 10,825,139 10,998,472 11,085 238 260,099 2.Wfl EXPENDITURES General Government 2,223,773 2,308,882 2,481,927 2,511,970 2,592,649 2,883,511 2,928,098 3,010,679 127,168 4.41% Public Safety 4,087,065 4,311,340 4,498,920 4,503,332 4,667,326 4,862,558 4,863,008 4,978,056 115,498 2.38% Public Works 2,482,490 2,759,342 2,819,372 2,817,981 2,966,674 3,175,822 3,118,037 3,206,152 30,330 0.96% Other 663,372 210,510 81,185 256,720 283,077 70,328 820,328 70,428 100 0.14% TOTAL EXPENDITURES 9,456 700 9,590,074 9 881 404 10,090,003 10,509,726 10,992 219 11 729,471 11,265 315 273,096 2.48% UNDER(OVER)BUDGET $ 500,705 $ 572,395 $ 241,902 $ 65,764 $ 528,843 $ 167,080 $ 730,999 $ (180,077) $--(-12-,997)1 ` 11/2112017 CITY OF ANDOVER Revenue Comparison -General Fund City of Andover 2018 Revenue Comparison - General Fund Property Taxes Licenses & Permits Intergov'I Rev i Charges for Svcs Fines & Forfeits Interest Income �- Misc. Rev S Transfers $0.00 $2.00 $4.00 $6.00 $8.00 $10.00 -Millions 13 Budget 2018 ■ Estimate 2017 ■ Actual 2016 • Actual 2015 • Actual 2014 ZS City of Andover 2018 Revenue by Source - General Fund Misc. Rev Transfers 1% Interest Income 1% 1% Fines & Forfeits 1% Charges for Svos 7% IntergoV[ Rev 7% Licenses & Permits 3% Property Taxes 79% Actual Actual Actual Budget Estimate Budget 2014 2015 2016 2017 2017 2018 REVENUES Property Taxes $ 7,476,295 $ 7,634,715 $ 8,217,768 $ 8,420,354 $ 8,422,354 $ 8,721,256 License and Penults 364,430 452,616 625,906 367,705 465,375 377,900 Intergovernmental Revenues 697,491 749,570 733,953 766,150 827,706 766,274 Charges for Services 998,150 804,684 912,220 773,950 770,050 746,700 Fines and Forfeits 94,375 99,304 88,600 100,750 90,150 90,250 Interest Income 144,876 63,709 68,380 75,000 75,000 75,000 Miscellaneous Revenue 150,759 154,239 194,812 124,300 150,907 129,300 Transfers 196,930 196,930 196,930 196,930 196,930 178,558 TOTAL REVENUES $ 10,123,306 $ 10,155,767 $ 11,038,569 $ 10,825,139 $ 10,998,472 $ 11,085,238 City of Andover 2018 Revenue Comparison - General Fund Property Taxes Licenses & Permits Intergov'I Rev i Charges for Svcs Fines & Forfeits Interest Income �- Misc. Rev S Transfers $0.00 $2.00 $4.00 $6.00 $8.00 $10.00 -Millions 13 Budget 2018 ■ Estimate 2017 ■ Actual 2016 • Actual 2015 • Actual 2014 ZS City of Andover 2018 Revenue by Source - General Fund Misc. Rev Transfers 1% Interest Income 1% 1% Fines & Forfeits 1% Charges for Svos 7% IntergoV[ Rev 7% Licenses & Permits 3% Property Taxes 79% EXPENDITURES General Government Public Safety Public Works Other General Govt Public Safety Public Works Other TOTAL EXPENDITURES CITY OF ANDOVER Expenditure Comparison - General Fund Actual Actual Actual Budget Estimate Budget 2014 2015 2016 2017 2017 2018 $ 2,481,927 25% 3 2,511,970 25% $ 2,592,649 25% $ 2,883,511 26% $ 2,928,098 25% $ 3,010,679 27% 4,498,920 46% 4,503,332 45% 4,667,326 44% 4,862,558 44% 4,863,008 41% 4,978,056 44% 2,819,372 29% 2,817,981 28% 2,966,674 28% 3,175,822 29% 3,118,037 27% 3,206,152 28% 81,185 1% 256,720 3% 283,077 3% 70,328 1 % 820,328 7% 70,428 1 % $ 9,881,404 $ 10,090,003 $ 10,509,726 $ 10,992,219 $ 11,729,471 $ 11,265,315 City of Andover 2018 Expenditure Comparison - General Fund $0.00 $1.00 $2.00 $3.00 $4.00 $5.D0 $6.00 Millions 0 Budget 2018 ■ Estimate 2017 ■ Actual 2016 a Actual 2015 a Actual 2014 Ze City of Andover 2018 Expenditures by Function - General Fund General Go 27% Other 1% Public Safety 44 aIle Works 28% CITY OF ANDOVER General Fund - Expenditure Budget Summary Totals - By Department Budget Year 2018 PUBLIC WORKS Actual Actual Actual Actual Actual Budget" Estimate Requested" Change (*) Streets and Highways 2012 2013 2014 2015 2016 2017 2017 2018 $ % GENERAL GOVERNMENT 420,175 630,799 637,154 442,078 468,173 568,257 547,777 562,706 (5,551) -0.98% Mayor and Council $ 83,622 $ 83,595 $ 84,650 $ 85,060 $ 86,989 $ 89,991 $ 89,991 $ 91,298 1,307 1.45% Administration 140,048 147,503 169,218 172,296 187,876 199,541 199,541 203,833 4,292 2.15% Newsletter 22,336 17,677 20,974 21,042 22,731 26,000 24,500 26,000 0 0.00% Human Resources 12,485 17,907 18,038 15,908 13,404 27,913 20,913 28,431 518 1.86% Attorney 170,930 173,244 177,427 180,313 184,990 191,360 190,000 191,360 0 0.000% City Clerk 101,377 108,312 128,861 134,775 148,338 148,599 148,599 155,608 7,009 4.72% Elections 39,614 11,352 41,508 14,497 64,433 63,881 19,100 59,781 (4,100) -6.42% Finance 207,337 215,215 230,639 240,319 252,563 268,129 268,129 278,660 10,531 3.93% Assessing 143,338 144,561 145,051 146,315 146,473 150,000 149,000 154,000 4,000 2.67% Information Services 136,025 135,982 146,984 131,744 151,387 175,722 174,022 180,597 4,875 2.77% Planning & Zoning 318,523 349,489 387,308 406,045 414,141 462,212 461,912 438,827 (23,385) -5.06% Engineering 427,339 452,788 460,872 464,843 511,074 535,715 535,415 553,765 18,050 3.37% Facility Management 420,799 451,257 470,397 498,813 408,250 544,448 646,976 648,519 104,071 19.11% Total General Gov 2,223,773 2,308,882 2,481,927 2,511,970 2,592,649 2,883,511 2,928,098 3,010,679 127,168 4.41% PUBLIC SAFETY Police Protection 2,693,896 2,740,899 2,818,132 2,918,308 2,936,467 2,962,551 2,962,551 3,053,526 90,975 3.07% Fire Protection 1,015,825 1,126,979 1,264,018 1,165,223 1,285,417 1,4229522 1,423,222 1,423,914 1,392 0.10% Protective Inspection 354,753 423,495 390,908 391,951 424,247 446,688 446,438 462,164 15,476 3.46% Emergency Management 149088 13,930 21,836 24,352 17,495 249847 24,847 32,502 7,655 30.81% Animal Control 8,503 6,037 4,026 3,498 3,700 5,950 5,950 5,950 0 0.00% Total Public Safety 4,087,065 4,311,340 4,498,920 4,503,332 4,667,326 4,862,558 4,863,008 4,978,056 115,498 2.38% PUBLIC WORKS Streets and Highways 570,630 572,753 600,313 629,724 686,086 691,473 614,668 659,943 (31,530) -4.56% Snow and lee Removal 420,175 630,799 637,154 442,078 468,173 568,257 547,777 562,706 (5,551) -0.98% Street Signs 170,200 162,861 187,935 204,495 167,282 215,244 215,244 219,418 4,174 1.94% Traffic Signals 27,457 26,241 34,901 30,170 27,919 37,000 37,000 37,000 0 0.00% Street Lighting 33,439 31,702 32,646 30,664 37,089 38,400 38,400 40,400 2,000 5.21% Street Lights - Billed 195,197 210,331 203,148 201,500 200,509 217,500 217,500 220,500 3,000 1.38% Park & Recreation 912,750 946,545 1,009,373 1,151,314 1,247,501 1,275,530 1,273,530 1,297,395 21,865 1.71% Natural Resource Preservatiot - - - - 7,255 10,197 12,697 11,574 1,377 13.50% Recycling 152,642 178,110 113,902 128,036 124,860 122,221 161,221 157,216 34,995 28.63% Total Public Works 2,482,490 2,759,342 2,819,372 2,817,981 2,9665674 3,175,822 3,118,037 3,206,152 30,330 0.96% OTHER 663,372 210,510 81,185 256,720 283,077 70,328 820,328 70,428 100 0.14% Total Other 663,372 210,510 81,185 256,720 283,077 70,328 820,328 70,428 100 0.14% GRAND TOTAL $ 9,456,700 $ 9,590,074 S 9,881,404 $ 10,090,003 $ 10,509,726 $ 10,992,219 $ 11,729,471 $ 11,265,315 273,096 2.48% MUNICIPALITIES Proposed 2018 City Muni Hilltop Lexington WITHIN ANOKA Tax Rate i alities Onl COUNTY Comparison . 33 71.096 Columbia Heights 67.216 Centerville 64.067 Bethel 63.629 Circle Pines 55 77 Spring Lake Park 54.4 8 St. Francis 1 53.92 0 Columbus 51.688 6 N Fridley 47.425 z 0 East Bethel 44.476 Lino Lakes 42.756 Coon Rapids 42.214 Ramsey 41.654 Anoka 7.731 Blaine 35 323 Andover 34.5 7 Linwood 29.165 Nowthen 27.116 Ham Lake 24.972 Oak Grove 22.497 0.000 20.000 40.000 60.000 80.000 100.000 120.000 TAX RATE M F� CITY OF ANDOVER 2018 Proposed Tax Rate Breakdown Other School District 4.320% 18.227% County 10 nR70/o City 38.366% PERCENTAGES ARE PROPORTIONAL TO REFLECT 100% RATHER THAN ACTUAL AMOUNT OF 90.153%. * Does not include voter approved referendum levy based on market value. Z`i Miscell 1' License & Permits 3% CITY OF ANDOVER 2018 General Fund Revenue Types Interaovernmental Fina-, R Fnrfait-, M Property Taxes 79% �s Publi 2 CITY OF ANDOVER 2018 General Fund Expenditures by Function Other General Government 0.6% 26.7% Public Safety 44.2% 31 CITY OF ANDOVER General Fund - General Government Expenditures Administration NewsIetter Council 6 8% Human Resources Facility Mgmt 3.0% 0.9% 0.9% 21.5% Attorney 6.4% City Clerk 5.2% Elections 2.0% Finance 9.3% Engineering 18.4% Assessing Planning & Zoning Information Systems 5.1% 14.6% 6.0% 32- Fire Protection 28.6% CITY OF ANDOVER General Fund - Public Safety Expenditures ..___ _ _.___ Finarnanev hAnnnnamant Animal Cnntrnl 33 61.3% Natural Resource Preservation 0.4% Parks & Recreation 40.5% CITY OF ANDOVER General Fund - Public Works Expenditures r Recycling I 4.9% Streets & Highways 20.6% Street Signs Street Lighting Street Lights - Billed Traffic Signals 6.8% 6.9% 1.3 1.2% /0 3 L Snow & Ice 17.6% AC I T Y 0 F NDOVE 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: Mayor and Councilmembers FROM: Jim Dickinson, City Administrator SUBJECT: October 2017 General Fund Budget Progress Report DATE: November 28, 2017 INTRODUCTION The City of Andover 2017 General Fund Budget contains total revenues of $10,825,139 and total expenditures of $11,039,719; a decrease in fund balance is planned. Monthly reporting of the City Budget progress to the Governing body is a recommended financial practice and often viewed positively by rating agencies. DISCUSSION Attached is the General Fund Revenue & Expenditure Budget Summary - Budget Year 2017, reflecting year to date actual through October 2017. The attachments are provided to assist discussion in reviewing 2017 progress; other documents may be distributed at the meeting. The following represents Administration's directives and departmental expectations that are in place for 2017: 1. Expenditure budgets while approved, expenses are to meet with the spirit that needs are fulfilled first, expansions of service and special requests are to be reviewed with City Administration before proceeding. 2. Departments are to be committed to search for the best possible prices when purchasing goods and services. 3. Departments are to be committed to continually searching out new efficiencies and to challenge the status quo of how the City provides services. 4. Departments are to be committed to searching out collaborative opportunities to facilitate efficient and cost-effective utilization of governmental assets and personnel. 5. Departments are to be committed to developing effective, consistent and ongoing communications with City residents, businesses and other stakeholders. 6. Departments are to be cognizant that services provided are subject to available revenues and should not commit to services that are not sustainable. ACTION REQUESTED Council is requested to receive a presentation from staff. submitted, CITY OF ANDOVER General Fund Budget Summary Totals Budget Year 2017 2016 1 2017 REVENUES Budget Oct YTD %Bud Final Budget Oct YTD %Bud General Property Tax $ 8,113,528 S 4,226,438 52% $ 8,217,768 $ 8,420,354 S 4,364,254 52% I IWl Licenses and Permits 346,205 508,999 147% 625,907 367 705 448 157 12 % Intergovernmental 673,248 665,483 99% 733,951 766,150 718,865 94% Charges for Services 767,950 792,684 103% 857,163 773,950 664,633 _ 86 Fines 100,750 72,255 72% 88,600 100,750 57,044 57% Investment Income 75,000 28,249 38% 43,747 75,000 40,893 55% Miscellaneous 116,800 145,182 124% 194,802 124,300 156,814 126% Transfers In 196,930 196,930 100% 196,930 196,930 196,930 100% Total Revenues S 10 390,411 S 6,636,220 64 % S 10,958,868 S 30 825139 S 6,647,590 61% 2016 1 2017 EXPENDITURES Budget Oct YTD % Bud Final Budget Oct YTD % Bud GENERAL GOFERNMENT Miscellaneous 281,728 258107 92% 258,577 781,728 764,850 98% Mayor and Council $ 88,780 $ 75,596 85% S 86,990 $ 89,991 $ 74,025 82% Administration 192,778 154,114 80% 187,876 199,541 156,001 78% Newsletter 26,000 19,255 74% 22,731 26,000 18,315 70% Human Resources 35,260 14,639 42% 13,403 27,913 17,099 61% Attorney 187,640 138,717 74% 184,990 191,360 141,640 74% City Clerk 157,075 123,650 79% 148,338 148,599 123,301 83% n Elections 82,919 44,413 54% 64,433 63,881 15,715 25% Finance 261,016 211,920 81% 252,563 268,129 220,961 82% Assessing 150,000 143,883 96% 146,472 150,000 145,367 97% Information Services 173,483 123,906 71% 151,386 180,722 120,040 66% Planning & Zoning 435,606 345,260 79% 414,141 462,212 320,773 69% Engineering 509,514 420,678 83% 511,074 535,715 423,243 79% Facility Management 568,201 335,871 59% 408,250 681,733 399,823 59% Total General Gov 2,868,272 2,151,902 75% 2,592,647 3 025 796 2,176,303 72 PUBLIC SAFETY Miscellaneous 281,728 258107 92% 258,577 781,728 764,850 98% Police Protection 2,936,467 2,936,467 100% 2,936,467 2,962,551 2,962,551 100% Fire Protection 1,294,795 1097,276 85% 1,285,416 1,422,522 1,150,098 81% Protective Inspection 441,807 334,497 76% 424,247 446,688 366,026 82% Civil Defense 22,982 16,090 70% 17,495 24,847 14,849 60% Animal Control 7,950 2,447 31% 3,700 5,950 1,956 33% Total Public Safety 4,704,001 4,386 777 93% 4,667,325 4,862,558 4,495 480 92 PUBLIC WORKS Miscellaneous 281,728 258107 92% 258,577 781,728 764,850 98% Streets and llighways 656,237 610,197 93% 686,087 614,668 523,026 85% Snow and Ice Removal 563,587 384,572 68% 468,174 547,777 344,796 63% Street Signs 204,193 134,714 66% 167,283 215,244 165,961 77% Traffic Signals 35,000 18,913 54% 27,919 37,000 22,883 62% Street Lighting 36,400 28,254 78% 37,089 38,400 20,487 53% Street Lights - Billed 217,500 148,564 68% 200,509 217,500 107,158 49% Park & Recreation 1,257,247 1,017,282 81% 1,247,501 1,275,530 970,399 769% Natural Resource Preservation 10,096 50 0% 7,255 12,697 4,243 33% I Total Public Works 3.111.187 2.444304 79% 2.966.677 3.081.037 2.294.908 74%1 OTHER Miscellaneous 281,728 258107 92% 258,577 781,728 764,850 98% Youth Services 38,600 24,500 63% 24,500 38,600 _- _ 0% Total Other 320,328 282,607 88% 283,077 820,328 764,850 93% Total Expenditures S 11,003,788 S 9,265,590 84% 5 10,509,726 S 11,789,719 S 9,731,541 83% NET INCREASE (DECREASE) $ (613,377) $ (2,629,370) $ 449,142 5 (964,580) S (3,083,951) 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 . WWW.ANDOVERMN.GOV TO: Mayor and Councilmembers FROM: Jim Dickinson, City Administrator SUBJECT: October 2017 City Investments Review DATE: November 28, 2017 INTRODUCTION Summary reporting of the City Investment portfolio to the Governing body is a recommended financial practice and often viewed positively by rating agencies. Furthermore, the City of Andover Investment Policy recommends the Finance Director presents to the City Council at least quarterly the type of investments held by the City. DISCUSSION Attached is the Investment Maturities Summary for October 2017, the October 2017 Investment Detail Report, and the October 2017 Money Market Funds Report. These attachments are intended to assist with discussion when reviewing the October 2017 investments. ACTION REQUESTED Informational. The Council is requested to review and provide feedback to staff. A, Investment Maturities - October 2017 Investment Maturities (in Years) Credit Fair Less Than More Than Investment Type Rating Value 1 1 - 5 6-10 10 Money market funds N/A $ 1,500,149 $ 1,500,149 $ $ $ MN Municipal Money Market Fund (4M) N/A 1,010,051 1,010,051 - - - Premier Banks Money Market Fund N/A 261,357 261,357 - - - Certificates of deposit FDIC 12,330,510 8,487,804 3,842,706 Local governments A/Al/A2 543,861 173,555 207,633 60,043 102,629 AAI/AA2/AA3 7,158,524 1,672,681 3,802,265 1,244,848 438,730 AAA 3,586,790 613,122 2,593,339 380,329 - State governments A/Al/A2 206,162 - 206,162 - - AAI/AA2/AA3 1,487,523 698,269 789,254 - - AAA 660,217 186,658 _ 269,733 203,826 - U.S. agencies AAA 6,293,356 1,450,183 4,683,480 37,633 122,061 FNMA REMIC N/A 960 960 - - - U.S. agencies N/A 966,339 770,417 195,922 - - Totaiinvestments $ 36,005,797 $ 16,825,205 $ 16,590,494 $ 1,926,679 $ 663,420 Deposits 1,295,271 Total cash and investments $ 37,301,068 October 2017 Investment Detail Description Cusip Number Credit RatinglF ,DIG# Type Purchase Price (Carrying Cost Maturity Amount Interest,Current Rate Market Valuer Ih ere al Date Acquired Coupon Date l Maturity]. Due Date Washington Trust Company 940637HU8 23623 CD 245,000.00 245,000.00 245,000.00 0.750% 244,965.70 maturity 12/05/16 none 11/17/17 PeoplesBank 710465EE1 90213 CD 245,000.00 245,000.00 245,000.00 1.150% 245,017.15 maturity 07/21/17 none 11/21/17 1 Year CD - Premier Bank 1091003210 21714 CD 251,504.10 251,504.10 251,504.10 0.700% 251,504.10 maturity 12/16/16 none 12/16/17 1 Year CD - Premier Bank Rochester 2055214401 33202 CD 246,474.02 246,474.02 246,474.02 0.600% 246,474.02 maturity 12/16/16 none 12/16/17 1 Year CD - Premier Bank MN 3041574901 33204 CD 246,474.02 246,474.02 246,474.02 0.600% 246,474.02 maturity 12/16/16 none 12/16/17 Valley Cent Svgs Bk Reading OH 91944RAE8 28555 CD 150,000.00 150,000.00 150,000.00 1.250% 150,042.00 monthly 12/22/14 01/22/15 12/22/17 Safra National Bk 78658OD59 26876 CD 245,000.00 245,000.00 245,000.00 1.000% 244,973.05 maturity 12/29/16 none 12/28/17 BankUnited NA 066519CT4 58979 CD 245,000.00 245,000.00 245,000.00 1.100% 245,012.25 maturity 12/29/16 none 12/29/17 Bank Baroda New York 06062QY99 33681 CD 245,000.00 245,000.00 245,000.00 1.000% 244,965.70 maturity 03/31/17 none 01/02/18 State Bk India NY 856285DA6 33682 CD 245,000.00 245,000.00 245,000.00 1.300% 245,095.55 maturity 07/18/17 none 01/18/18 Beal Bank SSB Plano Tex 07370T6R9 32574 CD - 245,000.00 245,000.00 245,000.00 1.100% 244,975.50 maturity 06/21/17 none 01/24/18 First Bank of Highland 319141EL7 17470 CD 245,000.00 245,000.00 245,000.00 0.850% 244,732.95 maturity 02/22/17 none 02/22/18 TCF National Bank 872278YZ3 28330 CD 245,000.00 245,000.00 245,000.00 0.850% 244,732.95 maturity 02/22/17 none 02/22/18 Plains Commerce Bank 72651LBM5 1678 CD 245,000.00 245,000.00 245,000.00 0.850% 244,713.35 maturity 02/28/17 none 02/28/18 Home Savings & Loan Co 43731 LCF4 28114 CD 245,000.00 245,000.00 245,000.00 0.900% 244,723.15 maturity 03/10/17 none 03/09/18 Mabrey Bk Bixby OK 554133BP2 10667 CD 245,000.00 245,000.00 245,000.00 1.200% 244,980.40 maturity 07/14/17 none 03/14/18 Old National Bank 680061GY8 3832 CD 245,000.00 245,000.00 245,000.00 0.950% 244,747.65 maturity 03/15/17 none 03/15/18 S & T Bank 783861CJ4 11124 CD 245,000.00 245,000.00 245,000.00 1.000% 244,794.20 maturity 03/15/17 none 03/15/18 Synovus Bank 87164DHW3 873 CD 244,999.78 244,999.78 245,000.00 1.000% 244,867.70 semi-annual 12/05/16 none 04/13/18 IberiaBank 45083AGW6 28100 CD 245,000.00 245,000.00 245,000.00 1.350% 245,088.20 maturity 07/19/17 none 04/19/18 First Financial Bank 32021SDT0 6600 CD 245,000.00 245,000.00 245,000.00 1.400% 245,142.10 maturity 07/21/17 none 04/23/18 Morgan Stanley Bank NA 61747MXH9 32992 CD 245,000.00 245,000.00 245,000.00 1.450% 245,200.90 maturity 07/27/17 none 04/27/18 Morgan Stanley Pvt Bank 61760ACHO 34221 CD 245,000.00 245,000.00 245,000.00 1.450% 245,200.90 maturity 07/27/17 none 04/27/18 Community Bk Chesapeake MD 20350ACU3 30903 CD 245,000.00 245,000.00 245,000.00 1.350% 245,071.05 maturity 08/18/17 none 05/11/18 Compass Bk Birmingham AL 20451 PSG2 19048 CD 245,000.00 245,000.00 245,000.00 1.400% 245,134.75 maturity 08/11/17 none 05/11/18 PlainsCapital Bank 72663QC98 17491 CD 245,000.00 245,000.00 245,000.00 1.350% 245,031.85 maturity 06/21/17 none 06/21/18 Capital One Bank (USA) 140420ZQ6 33954 CD 245,000.00 245,000.00 245,000.00 0.900% 244,380.15 semi-annual 07/13/16 01/13/17 07/13/18 Key Bank National Association 49306SWQ5 17534 CD 245,000.00 245,000.00 245,000.00 0.850% 244,465.90 semi-annual 07/13/16 01/13/17 07/13/18 Bank of China NY 06426WNJ7 33653 CD 245,000.00 245,000.00 245,000.00 1.500% 245,262.15 maturity 07/20/17 none 07/20/18 First National Bank of Omaha 332135HA3 5452 CD 245,000.00 245,000.00 245,000.00 1.450% 245,169.05 maturity 07/28/17 none 07/27/18 Israel Discount Bank of NY 465076JU2 19977 CD 245,000.00 245,000.00 245,000.00 1.450% 245,139.65 maturity 08/09/17 none 08/09/18 Pacific Western Bank 69506YFT1 24045 CD 245,000.00 245,000.00 245,000.00 1.450% 245,139.65 maturity 08/09/17 none 08/09/18 BMO Harris Bk 05581WST3 16571 CD 245,000.00 245,000.00 245,000.00 1.400% 245,017.15 maturity 10/20/17 none 08/20/18 Bank India New York 06279H4M2 33648 CD 245,000.00 245,000.00 245,000.00 1.450% 244,906.90 maturity 10/19/17 none 10/17/18 CD F & M Bank 30246AFM5 9963 CD 245,000.00 245,000.00 245,000.00 1.350% 244,661.90 maturity 10/20/17 none 10/19/18 Junction City Kansas 481502F72 A2 local 101,558.00 101,558.00 100,000.00 5.500% 103,157.00 semi-annual 05/28/08 03/01/09 09/01/18 Kaufman TX 486206KL8 A3 local 72,922.50 72,922.50 70,000.00 4.000% 70,398.30 semi-annual 06/28/16 02/15/17 02/15/18 Racine WI 7500216D4 AA- local 101,792.00 101,792.00 100,000.00 2.100% 100,318.00 semi-annual 01/24/12 06/01/12 06/01/18 Indiana St Bond Bank 454624S40 AA+ local 146,123.60 146,123.60 140,000.00 4.302% 142,730.00 semi-annual 12/30/16 none 08/01/18 Reg[Transprtn Dist, Denver 759136RR7 AA1 local 254,312.50 254,312.50 250,000.00 2.000% 250,000.00 semi-annual 07/12/16 11/01/13 11/01/17 Dane County WI 236091M92 AAt local 106,487.00 106,487.00 100,000.00 2.450%1 100,088.00 semi-annual 07/16/12 none 12/01/17 Minneapolis MN 60374YF93 AA1 local 220,938.00 220,938.00 200,000.00 4.000%1 201,876.00 semi-annual 03/04/14 none 03/01/18 8,487,803.64 CD Description Cmbe Number Credit RatinglF DIC# Type Purchase Price Carrying Cost Maturity Amount Interest. Rate Current Market Value ,es ai Data Acquired Coupon Date- Maturity/ Due New York City NY Transitional 64971QTU7 AA1 local 100,440.00 100,440.00 100,000.00 1.600% 100,159.00 semi-annual 01/27/17 none 05/01/18 Scott County IA 809486EZ2 AA1 local 112,617.00 112,617.00 100,000.00 4.400% 101,309.00 semi-annual 10/31/12 12/01/12 06/01/18 Prior Lake MN 742617CB7 AA2 local 230,000.00 230,000.00 230,000.00 1.000% 229,848.20 semi-annual 05/14/15 12/15/15 12/15/17 Hopkins Minn ISO #270 439881HCO AA2 local 95,278.40 95,278.40 80,000.00 5.250% 80,736.00 semi-annual 04/30/12 08/01/09 02/01/18 Orono MN ISD #278 687136LA7 AA2 local 115,511.00 115,511.00 110,000.00 4.000% 110,803.00 semi-annual 08/04/16 02/01/17 02/01/18 Chippewa Falls WI 169772VS6 AA3 local 255,321.30 255,321.30 255,000.00 1.550% 254,813.85 semi-annual 07/31/17 none 04/01/18 Washington County MN 937791K1.4 AAA local 115,000.00 115,000.00 115,000.00 3.750% 115,424.35 semi-annual 07/01/10 01/01/11 01/01/18 Saint Louis Park MN 79174OWC3 AAA local 112,114.00 112,114.00 100,000.00 3.850% 100,576.00 semi-annual 12/22/11 none 02/01/18 Bandera TX ISD 059851HR9 AAA local 154,890.00 154,890.00 150,000.00 4.000% 151,276.50 semi-annual 12/22/16 none 02/15/18 Brownsville TX ISD Zero Coupon 116421E46 AAA local 229,640.00 229,640.00 250,000.00 245,845.00 maturity 06/26/13 none 08/15/18 Washington State 939758DL9 AA state 205,804.00 205,804.00 200,000.00 4.500% 203,328.00 semi-annual 01/24/12 04/01/12 10/01/18 New Hampshire St Hsg 64469DWU1 AA2 state 200,762.00 200,762.00 200,000.00 1.789% 199,842.00 semi-annual 12/09/15 07/01/16 01/01/18 New Hampshire St Hsg 64469DWV9 AA2 state 115,685.40 115,685.40 115,000.00 1.939% 114,645.80 semi-annual 12/09/15 07/01/16 07/01/18 Kansas St Dev Fin Auth 485429X90 AA3 state 182,743.20 182,743.20 180,000.00 1.877% 180,453.60 semi-annual 07/12/16 none 04/15/18 Virginia St Res Auth Infrastructure 92817QKSO AAA state 61,500.00 61,500.00 60,000.00 4.710% 60,000.00 semi-annual 02/09/17 11/01/09 11/01/17 Georgia State 373384RQ1 AAA state 26,742.50 26,742.50 25,000.00 2.970% 25,317.75 semi-annual 02/08/12 none 10/01/18 Texas State 882722,151 AAA state 103,089.00 103,089.00 100,000.00 2.894% 101,340.00 semi-annual 08/10/11 04/01/12 10/01/18 Fed Farm Credit Bank 3133EFJMO AAA US 249,750.00 249,750.00 250,000.00 0.930% 249,440.00 semi-annual 05/25/16 04/13/16 04/13/18 Fed Home Ln Bank 313379DT3 AAA US 250,010.74 250,010.74 250,000.00 1.250% 249,860.00 semi-annual 07/07/17 12/08/12 06/08/18 Fed Farm Credit Bank 3133EHDQ3 AAA US 200,042.00 200,042.00 200,000.00 1.180% 199,828.00 semi-annual 03/30/17 06/27/17 06/27/18 Fed Nall Mtg Assn 3135GOE33 AAA US 249,677.50 249,677.50 250,000.00 1.125% 249,457.50 semi-annual 07/07/17 07/20/15 07/20/18 Fed Home Ln Mtg Corp Med Term Note 3134G3ZK9 AAA US 200,000.00 200,000.00 200,000.00 1.200% 199,678.00 semi-annual 07/30/12 01/30/13 07/30/18 Fed Farm Credit Bank .___._.._...__- 31331Y4S6 AAA US 114,000.00 114,000.00 100,000.00 5.050% 102,705.00 semi-annual 09/11/13 none 08/01/18 Fed Farm Credit Bank 3133EGK87 AAA US 199,462.00 199,462.00 200,000.00 1.020% 199,214.00 semi-annual 03/30/17 none 09/24/18 Fed Natl Mtg Assn Remic 31393EA1.3 US 204,187.50 974.28 954.31 4.500% 959.76 monthly 07/30/03 none 08/25/18 FICO Strip Cpn-E Zero Coupon 31771JXM7 US 215,452.16 215,452.16 224,000.00 223,991.04 maturity 12/11/14 none 11/02/17 FICO Strip Cpn Zero Coupon 31771E AA9 US 529,947.00 529,947.00 550,000.00 545,792.50 maturity 06/09/14 none 05/11/18 Fed Home Ln Mtg Corp 31393VM01 US 153,656.25 645.77 630.41 4.500% 633.08 monthly 06/30/03 06/15/18 14,053,647.87 Amex Centurion Bk 02587DU63 27471 CD 245,000.00 245,000.00 245,000.00 1.550% 245,075.95 maturity 06/03/17 02/08/18 11/08/18 BMW Bank of North America 05580ADR2 35141 CD 245,000.00 245,000.00 245,000.00 1.600% 245,122.50 semi-annual 01/22/16 07/22/16 01/22/19 Ally Bank Midvale Utah 02006LF32 57803 CD 245,000.00 245,000.00 245,000.00 1.200% 243,125.75 semi-annual 06/30/16 12/30/16 07/01/19 Barclays Bank 06740KHB6 57203 CD 247,000.00 247,000.00 247,000.00 2.050% 248,430.13 semi-annual 07/03/14 01/02/15 07/02/19 Synchrony Bank 87164WBT4 27314 CD 247,000.00 247,000.00 247,000.00 2.050% 248,390.61 semi-annual 07/11/14 01/11/15 07/11/19 JP Morgan Chase Bank NA 48125Y51.4 628 CD 245,000.00 245,000.00 245,000.00 1.100% 242,878.30 quarterly 07/15/16 10/15/16 07/15/19 PrivateBank & Trust Co 74267GUQ8 33306 CD 247,000.00 207,000.00 247,000.00 2.000% 248,390.61 semi-annual 07/21/14 01/21/15 07/22/19 Goldman Sachs Bank USA 38147JU59 33124 CD 247,000.00 247,000.00 247,000.00 2.050% 248,220.18 semi-annual 07/23/14 01/23/15 07/23/19 Sallie Mae Bank 795450895 58177 CD 245,000.00 245,000.00 245,000.00 1.700% 245,134.75 semi-annual 08/09/17 02/09/18 08/09/19 First Federal Svgs Bk 32021YCH4 29690 CD 249,000.00 249,000.00 249,000.00 1.500% 250,494.00 monthly 01/21/16 02/21/16 08/21/19 Victory Bank 92644LAB8 58615 CD 247,000.00 247,000.00 247,000.00 2.000% 248,360.97 semi-annual 09/24/14 03/24/15 09/24/19 Third Federal Sav & Loan 88413QAW8 30012 CD 128,000.00 128,000.00 128,000.00 2.000% 128,930.56 semi-annual 11/24/14 05/24/15 11/25/19 Celtic Bank 15118RJMO 57056 CD 247,000.00 247,000.00 247,000.00 2.050% 249,544.10 semi-annual 12/20/13 06/20/14 12/20/19 2,459,358.20 local 884,927.15 state 2,221,558.88 US Less Than 1 Year Description Number. Credit. RatinglF DIC # Type Purchase Price Carrying Cost Maturity Amount Interest' Rate Current Market- Value `. res a' Date Acquired Coupon Date Maturity/ Due Date Stearns Bank NA 857894PB9 10988 CD 247,000.00 247,000.00 247,000.00 1.000% 248,812.98 semi-annual 12/26/14 06/26/15 12/26/19 Citizens Alliance Bank 17318LAP9 1402 CD 249,000.00 249,000.00 249,000.00 2.000% 251,422.77 monthly 06/27/14 07/27/14 06/26/20 Enerbank USA 29266NA31 57293 CD 249,000.00 249,000.00 249,000.00 2.100% 250,371.99 monthly 07/18/14 08/18/14 07/20/20 Elbow Lake MN 284281 KC5 A local 170,045.70 170,045.70 165,000.00 2.750% 165,945.45 semi-annual 12/08/14 none 12/01/19 Oneida County NY 6824543132 Al local 45,755.20 45,755.20 40,000.00 6.250% 41,687.60 semi-annual 08/16/10 none 04/15/19 Farmington MN 311297W84 AA local 102,787.00 102,787.00 100,000.00 2.000% 101,105.00 semi-annual 07/06/16 none 02/01/19 Rice Cnty, MN 762698GK8 AA local 45,466.80 45,466.80 40,000.00 4.400% 41,150.80 semi-annual 03/07/12 none 02/01/19 Minnetrista MN 604229KE3 AA+ local 10,000.00 10,000.00 10,000.00 2.450% 10,000.00 semi-annual 10/10/13 08/01/14 02/01/19 Ramsey MN 751813PB6 AA+ local 158,677.85 158,677.85 145,000.00 4.500% 145,320.45 semi-annual 02/16/12 04/01/16 04/01/19 Rothsay MN ISD #850 778731AZ2 AA+ local 208,640.25 208,640.25 195,000.00 3.000% 203,035.95 semi-annual 07/06/16 none 02/01/20 Saint Paul MN Pott Auth 793067CC1 AA+ local 79,756.80 79,756.80 80,000.00 2.000% 79,515.20 semi-annual 01/10/17 09/01/17 03/01/20 Stearns Co MN 857896MH4 AA+ local 276,875.00 276,875.00 250,000.00 4.500% 250,557.50 semi-annual 04/17/13 none 06/01/20 Minnetrista MN 604229KGB AA+ local 161,038.40 161,038.40 160,000.00 3.100% 160,000.00 semi-annual 10/10/13 08/01/14 02/01/21 Greenway MN ISD#31 39678LDF6 AA+ local 27,593.50 27,593.50 25,000.00 5.000% 25,857.50 semi-annual 07/09/13 none 03/15/21 Minneapolis MN 60374YS73 AA1 local 111,898.00 111,898.00 100,000.00 3.250% 101,741.00 semi-annual 06/05/12 12/01/11 12/01/18 Cedar Rapids IA 150528RM1 AA1 local 217,672.00 217,672.00 200,000.00 3.000% 203,614.00 semi-annual 06/11/13 12/01/13 06/01/19 Multnomah Cnty OR Sch Dist 1J 625517JMO AA1 local 250,000.00 250,000.00 250,000.00 1.450% 249,242.50 semi-annual 08/10/17 12/15/17 06/15/19 Minneapolis MN 60374YS81 AA1 local 278,632.50 278,632.50 250,000.00 3.500% 258,507.50 semi-annual 02/26/13 none 12/01/19 Hampton VA 4095582J1 AA1 local 100,836.00 100,836.00 100,000.00 2.209% 100,775.00 semi-annual 01/20/16 none 04/01/20 Middleton WI 596782RX2 AA1 local 106,979.00 106,979.00 100,000.00 3.750% 101,405.00 semi-annual 02/24/15 none 09/01/20 Des Moines IA Area Cmnty Col 2500971-121 AA1 local 50,606.00 50,606.00 50,000.00 2.450% 50,246.50 semi-annual 11/10/14 12/01/14 06/01/21 Orange Beach ALA 68406PHF1 AA2 local 241,689.60 241,689.60 240,000.00 4.400% 244,728.00 semi-annual 08/05/10 02/01/11 02/01/19 Sioux City IA _ _ 829458FC7 AA2 local 156,100.50 156,100.50 155,000.00 2.000% 155,711.45 semi-annual 12/22/16 none 06/01/19 Waterloo IA 941647PA1 AA2 local 50,559.50 50,559.50 50,000.00 2.000% 50,183.00 semi-annual 06/27/13 12/01/13 06/01/19 Western Lake Superior MN 958522WU4 AA2 local 100,000.00 100,000.00 100,000.00 3.150% 102,580.00 semi-annual 08/16/11 04/01/12 10/01/19 Portsmouth VA 73723RSL8 AA2 local 286,268.00 286,268.00 295,000.00 2.400% 299,545.95 semi-annual 07/17/13 02/01/14 02/01/20 Brunswick Cnty 117061VH1 AA2 local 108,967.10 108,967.10 110,000.00 1.740% 108,384.10 semi-annual 08/21/15 none 05/01/20 Fon Du Lac Cnty Wl 344442KK3 AA2 local 259,715.00 259,715.00 250,000.00 3.250% 256,042.50 semi-annual 03/10/17 none 03/01/21 Kane McHenry Cook & De Kalb Zero Cpn 484080MB9 AA3 local 157,328.00 157,328.00 200,000.00 194,086.00 maturity 07/16/12 none 12/01/18 Moorhead MN 6161412R7 AA3 local 108,820.00 108,820.00 100,000.00 3.800% 103,850.00 semi-annual 11/14/11 none 02/01/20 Whitewater Wis 966204KA6 AA3 local 109,541.00 109,541.00 100,000.00 4.850% 108,267.00 semi-annual 06/09/11 none 12/01/20 W Palm Beach FL 955116BE7 AM local 101,245.00 101,245.00 100,000.00 2.264%1 96,813.00 semi-annual 07/05/16 10/01/16 10/01/22 King Cnty WA 49474E3L5 AAA local 224,634.00 224,634.00 200,000.00 3.980% 205,104.00 semi-annual 03/27/12 none 12/01/18 Minnetonka MN ISD#276 604195RA7 AAA local 37,433.20 37,433.20 35,000.00 3.100% 35,216.30 semi-annual 12/22/11 none 02/01/19 Palm Beach Cnty FLA 696497TR7 AAA local 174,889.50 174,889.50 150,000.00 5.898% 154,552.50 semi-annual 07/06/11 none 06/01/19 Tenn Val Auth Cpn Strip Zero Cpn 88059EWZ3 AAA local 262,890.00 262,890.00 300,000.00 290,871.00 maturity 12/27/13 none 06/15/19 Norwalk Conn 668844DS9 AAA local 122,464.80 122,464.80 120,000.00 4.050% 122,074.80 semi-annual 08/04/10 08/01/11 08/01/19 Greensboro NC 395460V21 AAA local 366,832.80 366,832.80 360,000.00 3.263% 370,666.80 semi-annual 07/15/11 none 10/01/19 Saint Paul MN Port Auth 793028WS6 AAA local 201,806.00 201,806.00 200,000.00 2.000% 199,528.00 semi-annual 12/22/16 08/01/17 02/01/20 Woodbury MN 97913PCQ7 AAA local 123,037.35 123,037.35 115,000.00 3.250% 117,739.30 semi-annual 12/22/11 none 02/01/20 Dallas TX lndpl Sch Dist 235308QK2 AAA local 116,900.00 116,900.00 100,000.00 4.450% 105,577.00 semi-annual 04/16/12 08/15/11 02/15/20 Tenn Valley Auth Zero Cpn 88059EHD9 AAA local 263,970.00 263,970.00 300,000.00 285,390.00 maturity 03/11/13 none 05/01/20 Tenn Val Auth Cpn Strip Zero Cpn 88059EMX9 AAA local 88,133.00 88,133.00 100,000.00 94,722.00 maturity 03/18/13 none 07/15/20 3,842,706.15 CD Description Cusip - Number. Credit RatinglF ,DIC:# Type Purchase Price Carrying Cost Maturity Amount Interest Rate _: Current Market- Value I e Pa e Date Acquired Coupon Date - Maturity Due Date.: McAllen TX Dev Corp 579086AW9 AAA local 175,000.00 175,000.00 175,000.00 1.400% 171,715.25 semi-annual 07/26/16 02/15/17 08/15/20 Indianapolis Ind 45528UGF2 AAA local 251,507.50 251,507.50 250,000.00 2.219% 250,657.50 semi-annual 07/11/17 07/15/13 01/15/21 Baltimore Cnty MD 05914FME7 AAA local 51,290.00 51,290.00 50,000.00 2.097% 49,905.00 semi-annual 08/31/16 none 08/01/21 New York St Mtge Agy 64988RHGO AAA local 100,000.00 100,000.00 100,000.00 2.375% 99,362.00 semi-annual 10/27/15 04/01/16 10/01/21 Columbus OH 199492CS6 AAA local 39,956.40 39,956.40 40,000.00 2.133% 40,257.20 semi-annual 02/20/15 none 12/01/21 Connecticut State 20772JQN5 Al state 214,954.00 214,954.00 200,000.00 3.517% 206,162.00 semi-annual 05127/161 02/15/14 08/15/21 Massachusetts State 57582P2T6 AAI state 199,744.00 199,744.00 200,000.00 2.090% 200,634.00 semi-annual 12/17/14 11/01/14 05/01/20 Florida St Hurricane 34074GDH4 AA3 state 279,439.80 279,439.80 270,000.00 2.995% 274,673.70 semi-annual 11/10/15 07/01/13 07/01/20 Minnesota St Colleges & Univ 60414FPJ3 AA3 state - 100,000.00 100,000.00 100,000.00 2.000% 100,018.00 semi-annual 02/26/15 10/01/15 10/01/20 Florida St Dept Environmental 34160WUAO AA3 state 217,800.00 217,800.00 200,000.00 6.206% 213,928.00 semi-annual 08/30/10 07/01/10 07/01/22 Tennessee State 880541QQ3 AAA state 48,218.85 48,218.85 45,000.00 3.178% 46,652.40 semi-annual 08/30/16 02/01/12 08/01/20 Virginia State 928109XD4 AAA state 22,126.00 22,126.00 20,000.00 4.100% 20,714.80 semi-annual 02/07/12 none 06/01/21 Kentucky St Hsg Corp 49130TSHO AAA state 203,458.00 203,458.00 200,000.00 2.780% 202,366.00 semi-annual 03/29/17 none 07/01/21 Govt Natl Mtg Assn 31361311-U1 AAA US 448,245.00 448,245.00 450,000.00 1.060% 446,278.50 semi-annual 08/21/17 none 11/14/18 Fed Farm Credit Bank 3133EHQF3 AAA US 249,870.00 249,870.00 250,000.00 1.350% 249,520.00 semi-annual 07/07/17 01/07/18 01/07/19 Fed Farm Credit Bank 3133EG3X1 AAA US 199,711.60 199,711.60 200,000.00 1.250% 199,348.00 semi-annual 06/16/17 07/17/17 01/17/19 Fed Natl Mtg Assn 3136GOY70 AAA US 199,300.00 199,300.00 200,000.00 1.080% 198,782.00 semi-annual 10/30/12 01/30/13 01/30/19 Fed Farm Credit Bank 3133EC5NO AAA US 99,587.00 99,587.00 100,000.00 1.250% 99,382.00 semi-annual 01/07/13 03/04/13 03/04/19 Fed Farm Credit Bank 3133EDTU6 AAA US 251,285.00 251,285.00 250,000.00 1.700% 250,472.50 semi-annual 07/07/17 03/04/15 03/04/19 Fed Farm Credit Bank 3133EHLZ4 AAA US 199,654.80 199,654.80 200,000.00 1.270% 199,230.00 semi-annual 06/16/17 09/06/17 03/06/19 Fed Home Ln Bank 3133782M2 AAA US 250,470.00 250,470.00 250,000.00 1.500% 249,820.00 semi-annual 07/07/17 09/08/12 03/08/19 Fed Natl Mtg Assn 313661FYO AAA US 200,000.00 200,000.00 200,000.00 1.375% 199,324.00 semi-annual 06/22/17 none 03/13/19 Fed Nati Mtg Assn_ 3135GOK28 AAA US 299,700.00 299,700.00 300,000.00 1.250% 298,053.00 semi-annual 07/19/17 10/26/16 04/26/19 Fed Home Ln Mtg Corp _ _ 3137EADK2 AAA US 249,035.00 249,035.00 250,000.00 1.250% 248,375.00 semi-annual 07/07/17 02/01/13 08/01/19 Fed Home Ln Mtg Corp Med Term Note 3134G96U6 AAA US 200,000.00 200,000.00 200,000.00 1.050% 197,660.00 quarterly 08/23/16 11/23/16 08/23/19 RFCSP Strip Principal Zero Coupon 76116FAA5 AAA US 185,568.00 185,568.00 200,000.00 193,252.00 maturity 07/22/15 none 10/15/19 Fed Farm Credit Bank 3133EGBKO AAA US 199,600.00 199,600.00 200,000.00 1.300% 197,944.00 semi-annual 05/25/16 11/25/16 11/25/19 Fed Home Ln Mtg Corp Zero Cpn 31340OBV4 AAA US 950,527.00 950,527.00 1,000,000.00 958,910.00 maturity 11/02/15 none 11/29/19 Fed Home Ln Bank 313OA3XL3 AAA US 99,500.00 99,500.00 100,000.00 1.500% 99,441.00 semi-annual 07/22/15 08/10/15 02/10/20 Fed Home Ln Mtg Corp Med Term Note 3134GBS78 AAA US 200,000.00 200,000.00 200,000.00 1.500% 199,550.00 semi-annual 10/27/17 04127/181 10/27/20 Fed Nad Mtg Assn 3136G4JM6 AAA US 200,000.00 200,000.00 200,000.00 1.850% 198,138.00 semi-annual 12/28/16 06/28/17 12/28/20 FICO Strip Cpn13 Zero Coupon 31771 C2G9 US 93,140.00 93,140.00 100,000.00 98,049.00 maturity 12/29/14 none 12/27/18 FICO Strip Cpn Zero Coupon 31358BAA6 US 94,480.00 94,480.00 100,000.00 97,873.00 maturity 04/17/15 none 02/01/19 16,590,493.65 Kaufman TX 486206KR5 A3 local 61,821.00 61,821.00 60,000.00 3.000% 60,043.20 semi-annual 06/28/16 02/15/17 02/15/23 Chaska MN 161663683 AA local 104,657.00 104,657.00 100,000.00 4.000% 101,666.00 semi-annual 09/08/14 none 02/01/24 Mitchell SD Sch Dist #17-2 606687EHO AA local 116,702.00 116,702.00 100,000.00 6.000% 106,638.00 semi-annual 12/20/11 06/15/19 06/15/24 Minnetrista MN 604229KJ2 AA+ local 40,000.00 40,000.00 40,000.00 3.850% 40,000.00 semi-annual 10/10/13 08/01/14 02/01/23 Savage Minn 80465PAN4 AA+ local 198,018.00 198,018.00 200,000.00 4.800% 208,764.00 semi-annual 06/17/10 02/01/11 02/01/24 Lake City Minn ISD #813 508084DW7 AA+ local 103,933.00 103,933.00 100,000.00 5.000% 104,132.00 semi-annual 05/11/11 none 02/01/25 Milaca Minn ISD#912 598699NT9 AA+ local 106,941.00 106,941.00 100,000.00 5.650% 103,706.00 semi-annual 07/22/11 none 02/01/27 Minneapolis MN 60374YG68 AA1 local 110,419.00 110,419.00 100,000.00 4.700% 103,473.00 1 semi-annual 10/31/11 none 03/01/23 6,603,236.60 local 1,265,148.90 state 4,879,402.00 US 1- 5 Years Description Cusip Number Credit - RatinglF DIC# Type Purchase Price Carrying Cost Maturity Amount. Interest: Rate - Current Market Value I ores al Date Acquired Coupon Dater Maturity 1. Due Date'. Minneapolis MN 60374YG76 AA1 local 72,201.35 72,201.35 65,000.00 4.800% 67,270.45 semi-annual 12/09/14 none 03/01/24 Alexandria MN ISD #206 015131LQ6 AA2 local 279,760.50 279,760.50 270,000.00 3.000% 276,598.80 semi-annual 01/21/15 none 02/01/23 Duluth MN 264438ZL9 AA2 local 29,767.20 29,767.20 30,000.00 2.625% 29,520.00 semi-annual 12/05/12 08/01/13 02/01/25 Hawkins Cnty TN 420218PL7 AA3 local 111,480.00 111,480.00 100,000.00 4.800% 103,080.00 semi-annual 03/13/12 none 05/01/24 Tennessee Valley Auth Ser E 880591CJ9 AAA local 121,500.00 121,500.00 100,000.00 6.750% 130,329.00 semi-annual 03/19/09 none 11/01/25 Ice Deposit- National Sports Center none local 250,000.00 250,000.00 250,000.00 250,000.00 maturity 02/06/08 none 01/01/26 Georgia State 3733842Q8 AAA state 204,444.00 204,444.00 200,000.00 2.780% 203,826.00 semi-annual 12/13/16 none 02/01/23 Fed Home Ln Bank 3130A8W33 AAA US 39,000.00 39,000.00 40,000.00 2.100% 37,632.80 semi-annual 07/27/17 08/22/17 08/22/25 1,926,679.25 Itasca County Minn 465452GP9 A local 105,024.00 105,024.00 100,000.00 5.550% 102,629.00 semi-annual 07/12/11 none 02/01/28 Van Buren Mich Public Schools 920729HD5 AA1 local 102,750.00 102,750.00 100,000.00 6.430% 106,320.00 semi-annual 07/17/09 11/01/09 05/01/29 Will County IL Cmnty Zero Coupon 969078QM9 AA2 local 159,000.00 159,000.00 500,000.00 332,410.00 maturity 08/25/09 none 11/01/27 Fed Farm Credit Bank 31331VLC8 AAA US 106,030.45 106,030.45 100,000.00 5.250% 122,061.00 semi-annual 02/26/10 none 04/21/28 663,420.00 33,234,240.77 1,685,220.45 local 203,826.00 state 37,632.80 US 6 -10 Years 541,359.00 local 122,061.00 US 10+Years INVESTMENT SCHEDULE - Money Market Funds October 31, 2017 Description Current Market Value YTD Interest Wells Faro I Wells Fargo Government Money Market Fund 1 $1,500,149.251 $5,991.59 4M z 4M 1,003,127.55 1,232.81 4M PLUS I 14M Plus 6,923.081 3,815.53 Premier Bank I lPremier Bank Money Market 261,356.80 543.57 Grand Total Money Market Funds 1 $2,771,556.68 $11,583.50 Updated: 11113/2017 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.CLAN DOVER. MN. US TO: Mayor and Councilmembers CC: James Dickinson, City Administrator FROM: Dana Makinen, Human Resources Manager SUBJECT: Discuss City Administrator's Performance DATE: November 28, 2017 C The City Council is requested to discuss the 2017 performance of City Administrator James Dickinson DISCUSSION All employees are required to have an annual review. The City Councilmember's were requested to evaluate Mr. Dickinson in the areas of Council relations, fiscal management, personnel, supervision, leadership, intergovernmental relations and community relations. Responses were then sent to the Human Resources Manager to complete. The complied version of the performance review is attached. A copy of this report has been provided to Mr. Dickinson. ACTION REQUESTED Council is requested to discuss Mr. Dickinson's 2017 performance. Respectfully submitted, Dana Makinen