The URL can be used to link to this page

Home My WebLink AboutWK - April 26, 2016C I T Y O F NDOVE 1685 CROSSTOWN BOULLVARD N.W. -AN DOVER, MINNtSO IA 55304 • (763) 755 -5100 FAX (763) 755 -8923 • WWW.ANDOVERMN.GOV City Council Workshop Tuesday, April 26, 2016 Conference Rooms A & B 1. Call to Order— 6:00 p.m. 2. Joint Meeting with Community Center Advisory Commission — Community Center 3. 2017 -2021 CIP Discussion & 2016 CIP Progress Report - Administration 4. 2017 Budget Development Discussion - Administration 5. March 2016 Budget Progress Reports — Administration 6. March 2016 City Investments Review - Administration 7. Other Business 8. Adjournment 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755 -5100 FAX (763) 755 -8923 • WWW.CI.ANDOVER.MN.US TO: Mayor and Councilmember's CC: Jim Dickinson, City Administrator FROM: Erick Sutherland — Recreational Facility Manager SUBJECT: Community Center Update DATE: April 26, 2016 The Andover Community Center Advisory Commission, Andover Community Center Facility Manager, along with the Andover YMCA has put together a presentation to share with the City Council. There are four primary discussion points we would like to discuss. • Programs and who we serve • Financial review • Community support and needs • Our future We will review ways the Andover YMCA/Community Center continues to reach out and offer quality programs and services to the residents of Andover and neighboring communities while remaining financially responsible. We will discuss groups and programs that we currently cannot serve or offer due to space and availability issues. To conclude we will discuss the future, including the city campus plan and what steps we can take to continue to offer great services and programs to our community. Respectfully submitted, Erick Sutherland C C I T Y 0 F w Y 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: 2017 -2021 CIP Discussion & 2016 CIP Progress Report DATE: April 24, 2016 INTRODUCTION In late March, Administration/Finance distributed baseline worksheets to Department Heads for the 2017 -2021 CIP kick -off. Subsequent discussions have centered on the 2017 -2021 CIP development and the need of other committees (Vehicle Purchasing & Facility Management Committees) and commissions (Parks and Recreation & Community Center Advisory) to start their work. DISCUSSION To assist with the 2017 -2021 CIP discussion, I have attached for the Council's reference a progress report on the 2016 Capital Improvement Plan projects. Throughout the summer it is anticipated that a significant amount of time will be spent on evaluating utility infrastructure, transportation improvements, trail improvements, building maintenance, equipment and park and recreation needs. Each of these items will be supported by a detailed fund balance analysis of funding sources (based on various assumptions and estimates) that will be presented to the Council for review at future workshops. At this time the Staff will again secure the Council's priorities to assure that those priorities are taken into consideration while staff develops a draft 2017 -2021 CIP. Staff will also discuss with the Council the Vehicle/Eguipment Purchasing Committee's review of City vehicles /equipment and the preliminary recommendations. ACTION REQUESTED The Council is requested to review the various attachments, receive a brief presentation, and provide direction to staff on Council priorities for the 2017 -2021 CIP. submitted, 2016 CIP Project Update 2017 -2021 CIP Equipment Listing 2016 Cost Breakdown Per Vehicle Park & Recreation - Operations Replace /Repair Play Structures - Various Parks CITY OF ANDOVER 2016 Capital Improvement Plan 1PI/ o v-ekic d Projects By Department - Use of Funds 25,000 Building Replacement - Toro Groundsmaster #559 45,000 Replacement - Small Extended Cab Pick Up #9 S 30,000 ordered Community Center Replacement - Toro Groundsmaster 4000 -D #583 70,000 Replacement - Rink Flooring 36,000 ordered Engineering Storm Sewer Improvements 50,000 New Development Projects 150,000 ongoing Pedestrian Trail Maintenance 45,000 Awarded New Pedestrian Trail & Sidewalk Segments 230,000 Design process Pedestrian Trail Reconstruction 50,000 Identified trail segment, summer project summer 475,000 Facility Management Annual Parking Lot Maintenance 50,000 Awarded Public Works / Comm Ctr Master Planning 25,000 complete 75,000 Fire Replacement- Turnout Gear 19,000 purchased Replacement - SCBNs 250,000 purchased Replacement - Fire Marshall vehicle 40,000 purchased Replacement - 800 MHz radios 35,000 purchased Replacement - Breathing Air Compressor 80,000 in process 424,000 Information Technology New Server addition / replacement 20,000 needs assessment Park & Recreation - Operations Replace /Repair Play Structures - Various Parks 50,000 structures ordered Replace /Repair Major Park Projects - Various Parks 25,000 ongoing, summer Replacement - Toro Groundsmaster #559 45,000 purchased Replacement - Toro Groundsmaster #585 110,000 purchased Replacement - Toro Groundsmaster 4000 -D #583 70,000 purchased Storm Sewer 300,000 bids reviewed / awarded Park & Recreation - Projects Annual Miscellaneous Projects 15,000 ongoing Timber Trails Park - Renovation 284,000 Fence / Well contract awarded / budget amended Terrace Park Irrigation & Water Service 35,000 Summer Sunshine Park Scoreboard Wiring & Design 23,000 Quotes reviewed for electrical work Municipal State Aid Routes / New & Reconstruct 357,000 bids reviewed / awarded Storm Sewer 693,000 bids reviewed / awarded Storm Sewer Improvements 50,000 ongoing Streets / Highways Annual Street Seal Coat Project 460,000 Awarded Annual Street Crack Seal Project 230,000 Awarded Annual Pavement Markings 40,000 Awarded Annual Curb Replacement 50,000 design bid w/ sidewalk segments Municipal State Aid Routes / New & Reconstruct 2,600,000 bids reviewed / awarded Annual Street Reconstruction 693,000 bids reviewed / awarded Gravel Road Improvements 15,000 complete Replacement - Dump Truck w/ Snow Removal Equip #196 200,000 in process 4,288,000 Water Rehabilitation of Wells 50,000 summer Grand Total $ 6,105,000 City of Andover, MN Capital Plan 2017 thru 2021 LI u4rne n T L IAnj PROJECTS & FUNDING SOURCES BY DEPARTMENT Department Project# Priority 2017 2018 2019 2020 2021 Total Building Replacement - Small Extended Cab Pick lJp #8 19 -02300 -01 1 35,000 35,000 Equipment Bond 35,000 35,000 Building Total Central Equipment } Replacement - Service Truck #371 18 48800 -01 Equipment Bond 40,000 Central Equipment Total 40,000 Community Center Replacement - Point of Sale (POS) System 17-04000 -03 Comm Ctr Operations Replacement - Skate SharpenerlRental Skates 17-04200 -01 Comm Ctr Operations Replacement - Pickelball Inserts /Net System 17- 44400 -01 Comm Ctr Operations 1 8,000 Replacement - Kaivac Cleaning System 18- 44000 -01 Comm Ctr Operations Replacement - Zamboni Battery Pack 18- 44300 -01 Comm Ctr Operations Replacement - Ice Rink Dividers 18- 44300 -03 Comm Ctr Operations 1 10,000 New - Inflatables 18- 44400 -03 Comm Ctr Operations Replacement - Camera/Secudty System 19- 44000 -01 Comm Ctr Operations Replacement - Scissor Lift 20- 44000 -01 Equipment Bond 1 10,000 Replacement - Electric Edger 20-04300 -01 Comm Ctr Operations Replacement - Floor Scrubber 21-04000 -01 Comm Ctr Operations Replacement - Volleyball Equipment 21-04400 -01 Comm Ctr Operations 1 Community Center Total (Emergency Management Replacement - Emergency Sirens 17 42400 -02 Capitai Equipment Reserve 1 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 180,000 180,000 35,000 35,000 2 40,000 40,000 40,000 40,000 40,000 40,000 1 8,000 8,000 8,000 8,000 1 10,000 10,000 10,000 10,000 1 10,000 10,000 10,000 10,000 1 10,000 10,000 10,000 10,000 1 14,000 14,000 14,00a 14000 1 8,000 8,000 8,000 8,000 1 10,000 10,000 10,000 10,000 1 12,000 12,000 12,000 12,000 1 15,000 15,000 15,000 15,000 1 8,000 8,000 8,000 8,000 1 15,000 15,000 15,000 15,000 1 7,500 7,500 7,500 7,500 28,000 42,000 12,000 23,000 22,500 127,500 1 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 180,000 180,000 Department Project# Priority 2017 2018 2019 2020 2021 Total LaserPiche Upgrade 17 -01420 -01 1 25,000 25,000 Capital Equipment Reserve 25,000 Emergency Management Total 25,000 Smartboard Addition 45,000 45,000 45,000 45,000 Capital Equipment Reserve 180,000 12,000 12,000 Information Technology Total 25,000 12,000 37,000 Park & Rec - Operations Replacement - One Ton Crew Cab Pickup #502 18- 45000 -01 Facility Management Replacement - Security Management System 17 -01900 -03 1 100,000 50,000 50,000 Replacement- One Ton Truck w/ Plow #599 100,000 Capital Equipment Reserve 80,000 80,000 100,000 80,000 80,000 100,000 Facility Management Total 1 20,000 100,000 Equipment Bond 20,000 100,000 New - "V" Snow Plow for #09 -589 18- 45000 -04 1 15,000 15,000 Equipment Bond 15,000 15,000 Replacement - Small Extended Cab Truck #76 18- 45000 -05 1 45,000 45,000 Fire Replacement - Turnout Gear 17 42200 -01 1 20,000 20,000 20,000 20,000 20,000 100,000 General Fund 20,000 20,000 20,000 20,000 20,000 100,000 Replacement - Extrication(Rescue) Equipment 17- 42200 -02 1 100,000 100,000 Equipment Bond 100,000 100,000 Replacement- Grass #31 18 42200 -01 1 85,000 85,000 Equipment Bond 85,000 85,000 Replacement - Grass #21 18 42200 -02 1 85,000 85,000 Equipment Bond 85,000 85,000 Replacement - Tanker #11 19 -02200 -01 1 400,000 400,000 Equipment Bond 400,000 400,000 Replacement- Grass Utility Vehicle (UTV) #4813 19- 42200 -03 1 45,000 45,000 Equipment Bond 45,000 45,000 Replacement -1999 GMC Sonoma Truck (U -10) #4810 19 -02200 -05 2 45,000 45,000 Equipment Bond 45,000 45,000 Replacement - SCBACompressors 20- 42200 -01 1 130,000 130,000 Equipment Bond 130,000 130,000 Replacement -800 MHz radios 20- 42200 -02 1 35,000 35,000 70,000 Capital Equipment Reserve 35,000 35,000 - 70,000 Replacement - Engine 21#4884 20- 42200 -03 1 450,000 450,000 Equipment Bond 450,000 450,000 Fire Total 120,000 190,000 510,000 635,000 55,000 1,510,000 Information Technology LaserPiche Upgrade 17 -01420 -01 1 25,000 25,000 Capital Equipment Reserve 25,000 25,000 Smartboard Addition 18 -01420 -01 1 12,000 12,000 Capital Equipment Reserve 12,000 12,000 Information Technology Total 25,000 12,000 37,000 Park & Rec - Operations Replacement - One Ton Crew Cab Pickup #502 18- 45000 -01 1 50,000 50,000 Equipment Bond 50,000 50,000 Replacement- One Ton Truck w/ Plow #599 18- 45000 -02 1 80,000 80,000 Equipment Bond 80,000 80,000 New - Wood Chipper Tow - Behind 18- 45000 -03 1 20,000 20,000 Equipment Bond 20,000 20,000 New - "V" Snow Plow for #09 -589 18- 45000 -04 1 15,000 15,000 Equipment Bond 15,000 15,000 Replacement - Small Extended Cab Truck #76 18- 45000 -05 1 45,000 45,000 Equipment Bond 45,000 45,000 Replacement - Water Tanker #161 19 -05000 -01 1 150,000 150,000 Equipment Bond 150,000 150,000 Department Project# Priority 2017 2018 2019 2020 2021 Total Replacement - Trailer #T -555 19- 45000 -02 1 16,000 16,000 Equipment Bond 18 -08300 -01 1 210,000 16,000 16,000 New -Trail Machine 20-45000 -01 1 210,000 150,000 150,000 Equipment Bond 19A8300 -01 1 200,000 150,000 150,000 Replacement - Cushman Field Dresser #547 20- 45000 -02 1 200,000 27,000 27,000 Equipment Bond 210,000 200,000 27,000 27,000 Park & Rec - Operations Total 210,000 166,000 177,000 553,000 Sign Design Software and Plotter 17 -03300 -01 2 10,000 10,000 Capital Equipment Reserve 10,000 Planning & Zoning Replacement- Planning Vehicle #7 18 -01500 -01 1 30,000 10,000 30,000 Equipment Bond 10,000 Streets / Highways 30,000 30,000 Planning & Zoning Total Replacement- One Ton Truck w/ Plow #134 18 43100 -02 30,000 80,000 30,000 80,000 Equipment Bond 80,000 80,000 New - One Ton Truck wl Regular Box wl Lift & Plow 18- 43100 -03 1 Sanitary Sewer Replacement - Jet(Vac Truck #99 17 -08200 -02 1 460,000 Equipment Bond 460,000 Sanitary Sewer Fund 230,000 New - Bobcat paver 18- 43100 -04 1 230,000 Sewer Trunk Fund 230,000 Equipment Bond 230,000 Replacement - One Ton Utility Truck #69 18 -08200 -02 1 50,000 90,000 19- 43100 -01 1 90,000 Sanitary Sewer Fund 220,000 220,000 90,000 90,000 Sanitary Sewer Total 460,000 90,000 550,000 Storm Sewer Replacement - Tymco Street Sweeper #172 18 -08300 -01 1 210,000 210,000 Equipment Bond 210,000 210,000 Replacement - Elgin Street Sweeper #169 19A8300 -01 1 200,000 200,000 Equipment Bond 200,000 200,000 Storm Sewer Total 210,000 200,000 410,000 Street Signs Sign Design Software and Plotter 17 -03300 -01 2 10,000 10,000 Capital Equipment Reserve 10,000 10,000 Street Signs Total 10,000 10,000 Streets / Highways Replacement- One Ton Truck w/ Plow #134 18 43100 -02 1 80,000 80,000 Equipment Bond 80,000 80,000 New - One Ton Truck wl Regular Box wl Lift & Plow 18- 43100 -03 1 55,000 55,000 Equipment Bond 55,000 55,000 New - Bobcat paver 18- 43100 -04 1 50,000 50,000 Equipment Bond 50,000 50,000 New - Dump Truck wl snow removal 19- 43100 -01 1 220,000 220,000 Equipment Bond 220,000 220,000 Replacement -Dump Truck w /S now removal 198 20 -03100 -01 1 220,000 220,000 Equipment Bond 220,000 220,000 Replacement - Bobcat S185 #120 20 -03100 -02 1 50,000 50,000 Equipment Bond 50,000 50,000 Replacement- One Ton Truck w/ Plow #133 20 43100 -03 1 80,000 80,000 Equipment Bond 80,000 80,000 Replacement - Backhoe Loader #80 20-43100 -04 2 110,000 110,000 Department Project# Priority 2017 2018 2019 2020 2021 Total Equipment Bond 110,000 110,000 Streets / Highways Total 185,000 220,000 460,000 865,000 Water Replacement- Dodge Dakota #95 17 -48100 -02 1 30,000 30,000 Sanitary Sewer Fund GRAND TOTAL 15,000 15,000 Water Fund 77,500 5,485,500 15,000 15,000 Replacement - 3/4 Ton Utility Truck #66 18 -48100 -02 1 60,000 60,000 Water Fund 60,000 60,000 Replacement - Side by Side UTV #70 18- 48100 -03 1 48,000 48,000 Sanitary Sewer Fund 16,000 16,000 Storm Sewer Fund 16,000 16,000 Water Fund 16,000 16,000 Water Meter Reading System AMI /AMR 19- 48100 -01 2 900,000 900,000 Water Fund 900,000 900,000 Water Total 30,000 108,000 900,000 1,036,00tr GRAND TOTAL 818,000 1,162,000 2,088,000 1,340,000 77,500 5,485,500 2016 COST BREAKDOWN PER VEHICLE Change from Last Review - 03/30/15 CIP Unit Original Year Life To Date - 03/30/2016 Diff Diff Change in Year 'N Cost Purchased Department Miles/Hrs Maintenance Maint $! Unit Miles/Hrs Maintenance Cost / Unit 6 $ 17,337.00 1996 Dodge Pickup Engineering 85,216 $ 36,853 $ 0.43 3,125.00 $ 1,043 $ (0.01)_ 2018 7 $ 24,093.00 1999 Chev Blazer Planning 102,929 $ 29,979 $ 0.29 4,372.00 $ 2,927 $ 0.02 2019 8 $ 18,780.93 2004 Chev Colorado 4x4 Ext Cab Building 101,131 $ 29,381 $ 0.29 12,289.00 $ 3,440 _ $ - bids 9 $ 16,292.86 2005 Chev Colorado 4x4 Ext Cab Building 125,962 $ 38,498 $ 0.31 13,149.00 $ 4,072 $ 19 $ 22,622.00 1995 Chev S -10 Blazer Engineering 88,724 1 $ 25,891 1 $ 0.29 3,615.00 $ 1,047 $ - 12 $ 21,388.00 1997 Dodge Ram Pickup Engineering 76,621 $ 24,095 $ 0.31 2,875.00 $ 2,148 $ 0.01 98 -14 $ 26,165.00 1998 Dodge 3/4 Ton w/ Plow Engineering 49,911 $ 22,974 $ 0.46 863.00 $ 982 _ $ 0.01 16 $ 41,574.00 2002 Chev Tahoe Engineering 111,185 $ 40,830 $ 0.37 4,240.00 $ 1,624 $ - 97 -19 $ 26,707.59 1997 Chev S -10 BLAZER PW 74,100 $ 21,795 $ 0.29 3,254.00 $ 2,986 $ 0.02 2018 66 $ 30,347.59 12006 Ford I water 125,110 $ 51,426 $ 0.41 i 14,399.00 $ 5,569 $ - 09 -067 $ 24,415.00 12009 Cement Grout Spraying Machine sanitary/Storm 43 $ 3,134 $ 72.88. 6.00 $ 312 $ (3.39) 2018 69 $ 54,432.99 2006 Ford F450 sanitary 117,673 $ 79,806 $ 0.68 10,850.00 $ 5,092 $ (0.02) 2018 70 $ 33,844.00 2004 Toolcat water /sanitary/storm 1,214 $ 20,270 $ 16.70 59.00 $ 948 $ (0.03) 76 $ 17,959.00 2003 Chev S -10 parks 51,480 $ 20,388 $ 0.40 - 5,047.00 $ 2,679 _ $ 0.02 77 $ 17,841.00 2003 Chev S -10 water 31,811 $ 13,196 $ 0.41 1,388.00 $ 313 $ (0.01) 78 $ 54,156.52 2005 Ford F450 water 74,451 $ 54,215 $ 0.73 _ 5,902.00 107.00 164.00 7.00 $ _ 4,924 $ 2,549 $ 1,571 $ 607 $ 0.01 80 $ 84,716.00 2002 Backhoe Loader Cent Eq 3,200 1 53,240 $ 16.64 r � _ $ 0.25 08 -081 $ 80,461.00 2008 Takeuchi Track Hoe water /sanitary/Storm 612 $ 5,963 $ 9.74 $ (0.06) $ 0.18 82 $ 24,975.00 1995 Generator storm 3,140 $ 10,430 $ 3.32 S' 83 84 90 13 -091 $ 24,974.00 $ 33,230,00 $ 28,975.00 $ 29,420.00_ 1990 Generator 1993 Generator 1997 Pickup _ 2013 GMC 112 Ton Ext Cab 4x4 Cent Eq 3,219 $ 11,762 $ 3.65 , 46.00 $ 1,028 $ 584 $ 0.27 $ 0.10 $ 0.01 sanitary 4,893 $ 14,160 $ 2.89 35.00 water /sanitary 115,143 $ 62,918 $ 0.55 ° 2,375.00 $ 2,104 sanitary 27,232 $ 9,965 $ 0.37 9,605.00 $ 2,608 $ (0.05) _ 93 $_ 7,003.00 1997 JD Gator 6 X 4 Streets 1,097 $ 10,046 $ 9.16 42.00 $ 388 _ $ 0.01 13 -094 $ 50,304.00 2013 Chev Silverado 3500 One Ton / Plow sanitary /Storm 25,071 $ 11,092 $ 0.44 ��l >, 8,639.00 $ 3,386 _ $ (0.03) 2017 95 $ 23,322.00 2000 Dodge Dakota water /sanitary 125,005 $ 31,694 $ 0.25 2,808.00 $ 1,114 $ - 96 $ 40,045.00 1997 Takeuchi water /sanitary/store 998 $ 20,358 $ 20.40 25.00 $ 3,112 _ $ 2.68 2017 99 $ 218,966.00 1999 Vactor water /sanitary/Storm 26,015 $ 124,255 $ 4.78 !' 1,615.00 $ 10,211 $ 0.11 101 $ 18,986.10 2004 Chev Colorado 4x4 Ext Cab Streets 101,310 $ 32,035 $ 0.32 8,228.00 $ 3,795 _ $ 0.02 13 -102 $ 50,347.00 2013 Chev 3500 Truck w/ Plow Streets 22,228 $ 12,592 $ 0.57 6,848.00 $ 2,298 $ (0.10) 00 -103 1 $ 19,391.00 2000 GMC Ext Cab Pickup Streets 47,700 $ 29,490 $ 0.62 1,047.00 $ 1,981 $ 0.03 110 $ 21,073.00 2001 Compress Streets 519 $ 9,365 $ 18.04 37.00 $ 959 _ $ 0.60 I1 -111 $ 134,906.49 2012 JD Front End Loader _ Streets 1,656 $ 25,228 $ 15.23. 292.00 $ 6,319 $ 1.37 114 $ 12,460.00 2001 Wacker Steel Roller Streets 1,001 $ 12,047 $ 12.03 329.00 $ 752 $ (4.78) 13 -115 $ 113,340.00 2013 John Deere 6115M Tractor Streets 444 $ 11,564 $ 26.05 192.00 $ 2,994 $ (7.96) 2020 120 $ 17,540.31 2004 IR S185 Bobcat Skidsteer Streets 1,445 $ 19,636 $ 13.59 151.00 $ 1,944 $ (0.08) 124 $ 147,331.00 1998 JD Front End Loader Streets 5,830 $ 99,353 $ 17.04 113.00 $ 3,843 _ $ 0.33 132 $ 48,009.00 2001 Ford F450 4x4 w/ plow Streets 107,581 $ 60,939 $ 0.57 2,763.00 $ 2,766 $ 0.02 2020 133 $ 48,659.01 2004 Ford F450 4x4 w/ plow Streets 48,883 $ 49,523 $ 1.01 2,869.00 $ 3,071 _ $ - 2018 134 $ 47,999.78 2004 Ford F450 4x4 w/ plow Streets 83,128 $ 59,384 $ 0.71 2,812.00 $ 41 408 $ 0.03 08 -135 $ 35,429.00 2008 Ford F350 Fac Mtce Fac Mtce 32,670 $ 7,325 $ 0.22 6,502.00 $ 996 $ (0.02) 139 $ 73,275.00 2001 Ford F550 Aerial/Lift Track Streets 20,453 $ 38,979 $ 1.91 1,556.00 $ 6,766 _ $ 0.21 2019 161 $ 91,403.00 2002 Sterling Water Tanker Parks 56,125 $ 95,265 $ 1.70 1,845.00 $ 4,731 $ 0.03 2019 169 $ 65,215.00 2000 Elgin storm 4,534 $ 50,005 1 $ 11.03;. 236.00 $ 5,117 $ 0.59 2016 COST BREAKDOWN PER VEHICLE Change from Last Review - 03/30/15 CIP Unit Original Year Life To Date - 03/30/2016 Diff Diff _ Change in Year N Cost Purchased Department Miles /Hrs Maintenance Maint $ / Unit Miles /Hrs Maintenance _ Cost / Unit 3,460.00 $ 20,558 $ 0.26 171 $ 117,539.00 2006 Tymco storm 31,860 $ 121,552 $ 3.82 2018 172 $ 117,145.00 2003 Tymco storm 29,400 $ 106,958 $ 164 3,429.00 $ 12,989 _ $ 0.02 173 $ 161,205.00 1996 JD Grader Streets 5,492 $ 92,598 $ 16.86 167.00 $ 6,143 _ $ 0.62 07 -191 $ 155,171.00 2007 Roscoe Patching Trk Streets 21,268 $ 65,503 $ 3.08 1,218.00 $ 16,916 _ $ 0.66 ordered 196 $ 93,374.00 1996 Ford Dump Truck w/ Plow Streets 57,550 $ 97,831 $ 1.70 1,383.00 $ 6,178 _ $ 0.07 198 $ 134,206.00 2000 Sterling Dump Truck w/ Plow Streets 56,278 $ 119,520 $ 2.12 11,025.00 $ 11,002 _ $ (0.28) 2019 200 $ 106,540.00 2000 Sterling Dump Truck w/ Plow Streets 64,700 $ 128,151 $ 1.98 1,624.00 $ 4,938 _ $ 0.03 2020 201 $ 107,402.00 2000 Sterling Dump Truck w/ Plow Streets 43,072 $ 106,399 $ 2.47. 1,148.00 $ 5,523 _ $ 0.06 202 $ 111,158.00 2002 Sterling Dump Truck w/ Plow Sheets 47,709 $ 108,825 $ 2.28. 6,111.00 $ 6,775 _ $ (0.17)_ 203 $ 110,493.00 2002 Sterling Dump Truck w/ Plow Streets 51,675 $ 97,278 $ 1.88 '" 3,305.00 $ 6,239 $ - 204 $ 132,861.42 2006 Sterling L8500 Dump Truck w/ Plow Streets 23,379 $ 56,025 $ 2.40 1,127.00 $ 2,709 $ - 205 $ 148,872.20 2007 International 7400 Trk w/ Plow Streets 76,464 $ 158,110 $ 2.07 7,403.00 $ 34,935 $ 0.29 206 $ 176,555.00 2007 Sterling LT9500 Tandem Truck w/ Plows Streets 49,960 $ 114,543 $ 2.29 5.00 $ 5,507 $ 0.11 11 -207 14 -208 $ 188,335.58 $ 175,560.00 2011 Mack Tandem Plow Track 2015 International 7400 Dump Truck w/ Plow Streets Streets 22,791 3,025 $ 41,651 $ 5,886 $ 1.83 $ 1.95 .,1, 2,767.00 1,545.00 $ 8,565 $ 3,236 $ 0.18 $ 0.16 303 $ 24,771.00 2002 Toyota 5000 lb forklift Cent Eq 1,806 $ 8,318 $ 4.61 _ 114.00 _ - 7.320.00 5,266.00 421.00 _ $ 595 $ 101 $ 2,350 $ 1,918 $ 2,573 $ 0.05 _ $ 0.09 $ (O.OI ) $_ (0.02) _ $ (0.24) _ 2018 2018 324 $ 14,450.50 Floor Sweeper Cent Eq 1,031 $ 7,139 $ 6.92'�� F - t Cab Pickm P Cent E 9 112,765 r 08 408 452 13 -501 502 503 509 $ 66 129.00 $ 90,387.38 $ 53,905.00 $ 31,224.00 $ 47,637.00 $ 27,955.00 2008 Ford F450 Si 8m 2004 Zamboni Ice Resurfacer 2013 Chev 3500 Track w/ Plow 2002 Ford F250 4x4 Crew Cab 2002 Ford F450 4x4 Truck w/ Plow _ 2006 Vermeer brush Chipper _ 2015 Chev Silverado 3500 4x4 w/ box and plow 8n Comm Str 51,675 4,801 $ 24,958 $ 41,257 $ 0 48 $ 8.59 Parks Parks - 19,861 $ 11,958 $ 0.60 ! ea 4,979.00 $ 1,934 $ (0.07) 77,560 $ 43,017 $ 0.55 2,942.00 $ 3,116 $ 0.02 Parks_ 114,738 $ 70,127 $ 0.61 7,097.00 $ 4,058 $ - Streets Parks 948 11,910 $ 17,288 $ 5,360 $ 18.24 $ 0.45 x 167.00 7,653.00 $ 3,736 $ 2,910 $ 0.89 _ $ (0.13) 14 -510 _ $ 51,822.00 514 $ 21,031.00 2001 JD 4700 Tractor Parks 1,511 $ 13,003 1 $ 8.61, (415.00) $ 1,215 $ 2.49 515 $ 32,310.00 2002 JD 4710 Tractor Parks 4,486 $ 16,438 $ 3.66 - 114.00 $ 1,577 $ 0.26 525 $ 80,721.00 2004 Trackless MT5 110 hp Parks 1,285 $ 43,586 $ 33.92 : 50.00 $ 2,212 $ 0.42 546 $ 12,769.00 1994 Cushman Field Dresser Parks Parks 5,229 $ 8,991 $ 1.72 124.00 $ 372 _ $ 0.03 547 $ 5,998.00 1990 Cashman 3,607 $ 13,425 $ 3.72 11.00 $ 290 $ 0.07 548 $ 13,818.00 1998 Truckster Parks 5,677 $ 16,190 $ 2.85 343.00 $ 715 $ (0.05) 550 $ 26,678.00 1998 Toro Groundmaster 72" Parks 911 $ 27,849 $ 30.57 26.00 $ 873 _ $ 0.09 561 $ 30,476.24 2004 Toro Groundmaster 328 -D 4wd Parks 2,003 $ 19,396 $ 9.68 .: 76.00 $ 1,109 $ 0.19 14 -562 $ 36,579.00 2014 Toro GM 7210 w/ polar trac & cab, snowblower Parks 523 $ 3,377 $ 6.46 264.00 $ 1,964 _ $ 1.00 15 -563 $ 46,060.00 2015 Toro GM 7210 w/ polar trac & cab, broom Parks 93 $ 1,187 $ 12.76 93.00 $ 1,187 $ 12.76 564 $ 32,962.00 2007 Toro Groundmaster 328 -D 4wd Parks 1,005 $ 12,956 $ 12.89 25.00 $ 971 $ 0.66 565 $ 10,115.00 2001 Toro Workman 2100 Parks 943 $ 15,313 $ 16.24 34.00 $ 1,644 _ $ 1.20 566 $ 7,240.40 2004 Toro Workman 2100 Parks 512 $ 4,520 $ 8.83 F 37.00 $ 1,104 _ $ 1.64 567 $ 8,027.49 2005 Toro Workman 1100 Parks 699 $ 4,275 $ 6.12 156.00 $ 1,199 $ 0.46 568 $ 11,134.45 2006 Toro Workman 2110 Parks 778 $ 3,422 $ 4.40 - $ 297 _ $ 038 569 $ 52,126.00 _ 2005 Ford F450 4x4 w/ plow Parks 78,738 $ 61,470 $ 0.78 4,869.00 $ 2,740 $ (0.02) 572 S 21,286.64 2007 SmithCo Lawn Sweeper Parks 135 $ 2,221 $ 16.45 3.00 $ 319 $ 2.04 577 $ 54,637.00 2007 Ford F450 4x4 w/ plow _ Parks 43,424 $ 38,849 $ 0.89 3,154.00 $ 2,961 _ $ - 97 -578 $ 36,159.00 1997 GMC One Ton Irrigation Truck Parks 38,010 1 1 $ 51,759 $ 1.36 5,761.00 $ 3,306 $ (0.14) 2016 COST BREAKDOWN PER VEHICLE ..'! Change from Last Review- 03/30/15 CIP Unit Original Year Life To Date- 03/30/2016 Diff Diff Change in _ Year # Cost Purchased Department Miles/Firs Maintenance Maint $ / Unit ', Miles/Hrs Maintenance Cost /Unit _ 11 -582 $ 70,897.63 12011 Toro Groundmaster 5910 Parks 1,904 $ 33,287 $ 17.48 504.00 $ 11,819 $ 2.15 12 -584 $ 56,800.52 2012 Toro GM4000 -D Mower Parks 488 $ 4,152 $ 8.51 152.00 $ 1,560 $ 0.80 _ backup 585 $ 81,029.00 2001 Toro 580 -D Lavntrower w/ cab Parks 2,315 $ 64,464 $ 27.85 374.00 $ 12,020 $ 0.83 _ 09 -589 $ 151,654.40 2009 Belos Trans Giant Trail Machine Parks 1,468_ $ 36,839 $ 25.09 181.00 $ 2,489 $ (1.60) _ 13 -591 $ 10,460.00 2013 JD Z95OR Commercial Zero Turn Mower Parks 308 $ 2,150 6.98 138.00 $ 950 $ (0.08) _ 09 -592 $ 7,725.67 2009 Toro G3 Zero Tum 52" Lawnmower Parks 1,065 $ 4,703 $ 4.42 147.00 $ 1,082 $ 0.48 2018 599 $ 41,885.00 2000 Ford F450 Parks 75,278 $ 67,467 $ 0.90 2,172.00 $ 3,612 $ 0.03 14 -610 $ 43,511.00 2014 Bobcat T590 track loader Parks 642 $ 6,489 10.11 wY" 292.00 $ 2,482 $ (1.34) 4800 $ 359,750.00 2000 Pierce Engine E -31 Fire 13,202 $ 81,729 $ 6.19 1,206.00 $ 5,219 $ (0.19) 4805 $ 22,488.00 2000 GMC Ext Cab Pickup UT -5 Fire 47,407 $ 34,185 $ 0.72 x�':, 1,704.00 $ 2,833 $ 0.03 4807 $ 39,775.00 2002 Ford F250 Grass Vehicle Fire 5,997 $ 14,477 $ 2.41 u,' 388.00 $ 1,390 $ 0.08 _ 4808 $ 232,413.00 2002 Sterling Fire Tanker T -21 Fire 9,163 $ 60,672 $ 6.62 480.00 $ 4,421 $ 0.14 _ 4810 $ 21,276.00 2003 Chev 5 -10 4x4 Truck UT -10 Fire 50,250 $ 39,306 $ 0.78 1,845.00 $ 710 $ (0.02) 4813 $ 15,799.30 2004 Polaris 6x6 my Fire 112 $ 14,970 $ 133.66 q�p+ 5.00 $ 788 $ 1.12 _ 4817 $ 7,600.00 2006 Pro -Air 20hp Vacuum Fire 900 $ 3,326 $ 3.70tNF� 4818 $ 47,226.00 2006 Chev 3500 4x4 Crew Cab R -31 Fire 14,492 $ 19,148 $ 1.32 MI;f '^ �;IIiIV '• 1�.�4? ! t)�.. ; �� 791.00 968.00 535.00 3,570 00 12,536 00 $ 877 $ 2,151 $ 3,943 $ 6,553 $ 4,028 $ (0.01) $ 0.07 $ (0.14) 4819 $ 46,918.00 2007 Chev 3500 4x4 Crew Cab R -21 Fire 9,226 $ 15,222 $ 1.65 4820 $ 299,319.00 2009 Sterling LT9500 Fire Tanker Truck T -31 Fire 4,721 $ 22,481 $ 4.76 $ 2.95 _ 4821 $ 435,103.43 2010 Pierce Velocity E -1 I ty Pum er p Fire 10,411 $ 30,717 $ (0.58) $ 0.01 4824 $ 41,674.20 2012 Chev Tahoe 4x4 Fire Chiefs Vehicle Fire 44,548 $ 12,998 _ $ 0.29 12 -4825 $ 52,465.18 2012 Chev 3500 4x4 Crew Cab R -11 Fire 5,260 $ 3,558 $ 0.68 wd.0 928.00 $ 765 $ 0.04 _ 15.4826 $ 35,626.19 2015 GMC Sierra 4wd Dbl Cab - Fire #15 -4826 Fire 3,646 $ 1,528 $ 0.42 3,087.00 $ 1,156 $ (0.25) 1574827 $ 39,308.02 2015 Fordlnterceptor 4dr - Fire#15-4827 Fire 2,851 $ 837 $ 029 l 3¢ 2,851.00 $ 837 $ 0.29 4884 _ $ 319,640.00 1997 Pierce Pumper Engine E -21 Fire 25,362 $ 112,201 $ 4.42 1,314.00 $ 11,072 $ 0.21 14 -4886 $ 1,089,037.46 2014 Pierce Aerial I OOft Platform Fire Truck _ Fire _ _ 3,086 $ 7,918 _ $ 2.57 1,244.00 $ 6,917 $ 103 _ 2019 4889 $ 91,190.00 19911HC Tanker T -11 Fire 10,048 $ 20,648 $ 2.054p 287.00 $ 1,481 $ 0.09 2018 4892 $ 32,240.00 1991 Ford F350 Grass Vehicle #21 Fire 22,210 $ 18,870 $ 0.85. 122.00 $ 1,047 $ 0.04 2018 4893 $ 32,240.00 1991 Ford F350 Grass Vehicle 431 Fire 23,211 $ 24,446 $ 1.05 190.00 $ 739 $ 0.02 16 -01 $ 99,090.62 2016 Toro GM 5910 Parks d;3rrr _ 16 -02 $ 61,656.00 2016 Taro GM 4000 Parks ¢ $ 32,651.00 2016 Ford Police Interceptor Fire V _ ND OVE: 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755 -5100 FAX (763) 755 -8923 • WWW.CI.ANDOVER.MN.US TO: FROM: SUBJECT: DATE: Mayor and Councilmembers Jim Dickinson, City Administrator 2017 Budget Development Discussion April 26, 2016 INTRODUCTION 0 City Administration is starting to focus on the 2017 Annual Operating Budget Development process and is looking for City Council direction as the preparation of the 2017 Annual Operating Budget proceeds. City Administration will review with the Council the bold italics items at the meeting. DISCUSSION The following are the 2017 Budget Development guidelines were adopted at the April 19`I' City Council meeting: 1) A commitment to a City Tax Capacity Rate to meet the needs of the organization and positioning the City for long -term competitiveness through the use of sustainable revenue sources and operational efficiencies. Note: Preliminary Anoka County Assessor taxable market value figures for the City of Andover are reflecting a 4.23% increase in total taxable market value. (See attached City of Andover Property Tax Levy spreadsheet) & (See attached City of Andover Pay 2017 Valuation Estimates & Anoka County Payable 20161Pavable 2017 Taxable Market Value Comparison). 2) A fiscal goal that works toward establishing the General Fund balance for working capital at no less than 45% of planned 2017 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 2016 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. Emergency Fund Balances should be estimated to stabilize the situation, not be the complete solution. Staff will review with the Council the attached 2016 General Fund Balance Analysis at the meeting. 3) A commitment to limit the 2017 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 adopted 2016 debt levy was 18.12% of the gross tax levy, 25% will provide a reasonable margin to accommodate a 2017 Equipment and/or Improvement Bond. JSta will review with the Council at the meeting the attached City ofAndover Debt Service Levy Summary). 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 on the basis of a cost benefit analysis rather than a year based replacement schedule. Note: The City Vehicle Purchasing Committee is currently performing this analysis, and will make recommendations to the City Council as part of the 2017 -2021 Capital Improvement Plan(CIP) development process. This will be covered in more detail with the CIP discussion. 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 various financial models to determine the long -term impacts of present day expenditures and financing decisions. Fiscal assumptions are based upon a complex set of financial data including growth factors, tax capacity valuations, per capita spending and debt ratios. 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. 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 will pay special attention to fiscal values, commercial & residential development or redevelopment, collaboration opportunities, service delivery and the livability/image of the community. Staffing: A few new staffing requests are expected from CUP Departments for the 2017 budget. Also there are some anticipated retirements in the next few years; there will need to be a focus on appropriate succession planning. Personnel Related Implications: To date the following are projected issues facing personnel related expenses: 1. Human Resources will again review 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 the 2017 budget proposal. A cost of living adjustment (COLA) for non - bargaining employees will also be included. The Public Works Union contract will not expire until December 31, 2017. 2. A midyear review of the health plan will be conducted with our broker in July. The City currently offers the employees the option of two high deductible plans ($5,000 family, $2,500 single for in network expenses) with a health spending account (HSA), this was implemented in 2006. As part of the program, the City pays for 100% of the single health insurance premium for an accountable care plan and 76% for a family health insurance premium accountable care plan. Employees that select the open network health plan pay the increased cost over the accountable care plan. The City does contribute annually to the employees HSA. Contractual Departments: 1. The City Attorney 2016 contract included a 2.5% increase over the 2015 rate. No discussion to date. 2. The City of Andover has a Law Enforcement Contract with the Anoka County Sheriffs Office. The 2016 budget for the contract is $2,936,467 and is offset by a Police State Aid of $124,800 and School Liaison revenue of $91,820 reflecting a net tax levy impact of $2,719,847. The 2016 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 Sheriff's Department additional, but is not billable per the contract The 2016 contract maintained status quo service when compared to 2015, but sijenificant attention was done relative to equipment purchasinz and maintenance. The 2016 contract reflected a 0.62% increase ($18,159) over the 2015 contract. Staff has had initial discussions with the Anoka County Sheriff for a 2017 contract, and the Anoka County Sheriff is scheduled to be before the City Council at the May 24th workshop meetinz. Council Memberships and Donations /Contributions: The following memberships /contributions are included in the 2016 Budget: • North Metro Mayors Association $13,709 • Metro Cities $ 9,427 • Mediation Services $ 3,366 • YMCA — Water Safety Program $ 8,500 • Alexandra House $18,328 • Youth First (Program Funding) $12,000 • NW Anoka Co. Community Consortium - JPA $10,000 • Teen Center Funding (YMCA) $24,500 • Family of Promise $ 3,000 • Lee Carlson Central Center for Family Resources $ 1,500 • Senior High Parties $ 1,000 • Stepping Stone $ 600 Council direction will be sought on how to budget for these items in 2017. Capital Projects Levy: Capital Projects Levy — The 2016 Capital Projects Levy Budget specifically designates $1,415,984 of the general tax levy to capital projects and equipment needs relating to Capital Outlay ($250,000), Road and Bridge ($1,089,146), Pedestrian Trail Maintenance ($61,838) and Park Projects ($15,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 Fund. That State of Minnesota funding has largely gone away (down to $2,706) for 2016. Future significant increases in LGA for the City ofAndover are remote. For 2016, the levy to Road & Bridge is $1,089,146 a 9.39% increase over 2015, recognizing the simniRcant 2015 taxable market value increase and lost LGA. Administration will be proposing a 2.5% increase in the Road & Bridge levy for 2017. The 2016 levy to pedestrian trail maintenance is $61,838, that was a 6.1% increase over 2015. Administration will be proposing a 2.0% increase in the Pedestrian Trail Maintenance levy for 2017 • 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 of the 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 levy was be assigned to Parks Repair/Replacement items for a total levy of $90,000 in 2016. History of the supplemental Park Improvement Funding, In 2002, City Council committed $50,000 in tax levy to underwrite park improvement projects as recommended by the Park and Recreation Commission and approved by City Council. That levy was intended to be a supplemental source of capital funding for park projects as development started to slow down and minimal park dedication funds were available. As of 2015, that levy was up to $61,500 of which $15,000 was designated towards miscellaneous items that come up throughout the year. New direction of the Funding in 2016: With an emphasis on maintaining/preserving parks the City currently has, through the 2016 Budget / Levy process, the City Council re- assigned $46,500 of the Park Improvement Levy to the General Fund to focus on Park's maintenance /replacement items. A residual $15,000 of levy remained to the Park Improvement Fund to take care of miscellaneous items that come up throughout the year that the Park and Recreation Commission will continue to participate in. A $90,000 tax levy ($46,500 combined with an additional $43,500 of General Fund levy funding) is now identified as part of the General Fund levy to replace playground equipment, fences, pedestrian bridges in parks, parking lot reconstruction, etc. The Parks Maintenance Department will determine which replacement items have the highest priority through the Capital Improvement Plan (CIP). Any unused funds in M ig ven year will be specifically designated or carried forward for future park replacement items. If a park is to be reconstructed as recommended by the Park and Recreation Commission and approved by City Council through the CIP process, the Park and Recreation Commission will work with the Parks Maintenance Department to determine which items are replacements and which items are considered new and/or enhancements to determine the mix of funding sources to accomplish the project. • Equipment/Projects Under the Capital Projects Levy, a levy is proposed to be designated to capital improvement/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 2016 levy is $250,000, Administration will be recommendine the same for 2017. 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. (Staff along with Ehlers & Associates will complete a review and see if any efnancing opportunities are available at this time; we will then continue to monitor refunding opportunities, as markets can move quickly, and calculate potential savin s for each issue that may meet parameters which may generate savings, The proposed 2017 Debt Service levy is as follows: • 2010A G.O. Open Space Referendum $ 187,840 • 2012C Taxable G.O. Abatement Bonds $ 974,418 • 2014A G.O. Equipment Certificates $ 295,260 • 2016A G.O. Equipment Certificates $ 152,529 • Proposed New Bond Issuance $ 500,000 Total $271107047 It should be noted that the levy is offset significantly by a $635,000 YMCA annual rental payment for the Community Center bonds (2012C Taxable G.O. Abatement Bonds). The proposed 2017 Debt Service levy reflects a.46% increase ($9,634). Staff will review with the Council at the meeting the City of Andover Debt Service Levy Summary. ACTION REQUESTED The Council is requested to receive a presentation and provide direction to staff. Other Levies Capital Projects Levy Capital Equipment/Project 210,000 210,000 City of Andover, Minnesota 250,000 250,000 250,000 2.11% $ - 0.00% Palls Projects 61,500 Property Tax Levy 61,500 61,500 15,000 15,000 0.13% $ - 0.00% Road It Bndge 1.022,817 967,197 Preliminary 967,197 1,089,146 1,116,079 9.40% $ 26,933 Certified Certified Certified Certified Certified Requested 58,271 Change 61,838 63,075 0.53% 2012 2013 2014 2015 2016 2017 % of Total S % 40,000 General Fund Lew 0.34% It 0.00% Total Omer Gross City Levy 1,390,891 10,637,299 1,336,968 10,637,299 1,336,968 70,843,925 1,376,968 77,743,925 General Operations $ 7,332,857 $ 7,332,857 S 7,435,891 $ 7,630,892 $ 7,947,528 S 8,185,954 68.96% $ 238,426 3.00% 1,718,153 Parks Repair /Replacement Items - - 90,000 90,000 0.76% $ - 0.00% S 8,832,722 Total General Fund 7,332,857 7,332,857 7,435,891 7,630,892 8,037,528 8,275,954 69.72% $ 238,426 2.97% $ 182,558 Debt Service Funds Levy S 187,283 $ 184,238) $ 186,291 $ (167,840 Net Local Tax Rate Levy 2004A G.O. Capital Improvement Bonds 405,292 381,290 - - - - 2004 EDA Public Facility Revenue Bonds 1,092,684 452,062 181,803 - - - 26,389,573 2010A GO. Open Space Referendum Bonds 182,558 184,973 187,283 184,238 186,291 187,840 3.31%1 2011A G.O. Equipment Certificate 102,017 101,745 - - - - 2012A G.O. Equipment Certificate 125,000 125,000 140,000 140,000 142,885 - 43.358% 37.204% 38.447% 38.085% 2012B G.O. Cap Ini Refunding Bonds - 138,339 561,015 540,120 498,435 - 42.090% 41197% 37.070% 38.314% 2012C Taxable G.O. Abatement Bonds - 578,045 740,965 975,652 977,332 974,418 38.746% 42.539% 41657% 37.461% 2014A G.O. Equipment Certificate - - 260,000 296,055 295,470 295,260 Voter Approved Ref - MV 0.00568% 0.00778% 0.00841% 2016A G.O. Equipment Certificate - - - - - 152,529 Proposed New Bond Issuance - - - - - 500,000 Total Debt Service 1,907,551 1,961,474 2,071,066 2,136,065 2,100,413 2,110,047 17.78% $ 9,634 0.46% Q Other Levies Capital Projects Levy Capital Equipment/Project 210,000 210,000 210,000 250,000 250,000 250,000 2.11% $ - 0.00% Palls Projects 61,500 61,500 61,500 61,500 15,000 15,000 0.13% $ - 0.00% Road It Bndge 1.022,817 967,197 967,197 967,197 1,089,146 1,116,079 9.40% $ 26,933 2.47% Pedestrian Trail Maintenance 58,574 58,271 58,271 58,271 61,838 63,075 0.53% $ 1,237 2.00% Lower Rum River Watershed 40,000 40,000 40,000 40,000 40,000 40,000 0.34% It 0.00% Total Omer Gross City Levy 1,390,891 10,637,299 1,336,968 10,637,299 1,336,968 70,843,925 1,376,968 77,743,925 1,455,984 71,593,925 1.484.154 71,870,155 12.50% 100% 28,170 276,230 2.05% 2.48% Less Fiscal Disparities Distribution 1,791,496 1,798,577 1,718,153 1,846,295 1,586,747 1,631,840 Local Tax Rate Levy $ 8,839,803 S 8,832,722 $ 9,125,772 $ 9,297,630 $ 10,007,178 $ 10,238,315 Less Levy Based on Market Value $ 182,558 $ 184,973 S 187,283 $ 184,238) $ 186,291 $ (167,840 Net Local Tax Rate Levy $ 8,657,245 S 8,647,749 $ 8,938,489 $ 9,113,392 $ 9,820,887 $ 10,050,475 Adjusted Tax Capacity Value" 20,514,674 21,155,263 20,615,782 24,496,024 25,543,662 26,389,573 3.31%1 Charge 7%* Change Tax Capacity Rate "' 42.200% 40.878% 43.358% 37.204% 38.447% 38.085% - 0.362% - 0.943% Tax Capacity Rata W/O LRRWSD 38.407% 42.090% 41197% 37.070% 38.314% Tax Capacity Rate With LRRWSD 38.746% 42.539% 41657% 37.461% 38.702% Voter Approved Ref - MV 0.00568% 0.00778% 0.00841% 0.00719% 0.00699% Adjusted Value determined by adjusting for Fiscal Disparities arM Tax Increment estimates "' Blended rate due to the City of Andover levying for Lower Rum River Watershed District (1) Adjusted Tax Capacity Value is subject to change. CITY OF ANDOVER Pay 2017 Valuation Estimates Pay 2014 Pay 2015 Pay 2016 Pay 2017 - Est Taxable Tax Taxable Tax Taxable Tax Taxable Tax Market Capacity Market Capacity Market Capacity Market Capacity Value Value Value Value Value Value Value Value Andover Valuation Totals $ 2,071,812,281 $ 21,978,322 $ 2,435,770,612 $ 25,705,350 $ 2,539,686,867 $ 26,847,273 $ 2,647,133,414 $ 27,760,080 Captured Tax Increment (327,433) (210,936) (248,327) (248,327) Fiscal Disparity Contribution (1,035,107) (998,390) (1,055,284) (1,149,028) Local Tax Rate Value 20,615,782 24,496,024 25,543,662 26,362,725 Fiscal Disparity Distribution 4,202,605 4,257,801 4,264,789 4,364,789 Total Adjusted Values $ 24,818,387 $ 28,753,825 $ 29,808 451 $ 30,727,514 15.86% 3.67% 3.08% Taxable Market Value Tax Capacity Value % Change % Change Pay 2014 $ 2,071,812,281 Pay 2014 $ 21,978,322 Pay 2015 Pay 2016 $ 2,435,770,612 $ 2,539,686,867 17.57% 4.27% Pay 2015 Pay 2016 $ 25,705,350 $ 26,847,273 16.96% 4.44% cr�) Pay 2017 $ 2,647,133,414 4.23% Pay 2017 $ 27,760,080 3.40% Taxable Market Values Tax Capacity Values $3,000,000,000 $30,000,000 $2,500,000,000 $25,000,000 $2,000,000,000 $20,000,000 $1,500,000,000 $15,000,000 $1,000,000,000 $10,000,000 $500,000,000 $5,000,000 $0 $0 Pay 2014 Pay 2015 Pay 2016 Pay 2017 Pay 2014 Pay 2015 Pay 2016 Pay 2017 ANOKA COUNTY ANOKA 2016 Pay 2017 COUNTY Market Value PAYABLE 2016/PAYABLE 2017 TAXABLE MARKET VALUE A I COMPARISON as of 04/07/2016 IV 2016 Pay 2017 % CHG from 2016 Pay 2017 MV w/o New 2015 Pay 2016 2016 to 2017 New Construction Construction Market Value w/o NC LINWOOD AG 15,603,385 17,700 15,585,685 15,073,245 3.4% RESID 404,767,231 6,719,200 398,048,031 389,986,109 2.1% APTS 2,061,100 0 2,061,100 2,016,600 2.2% C AND I 2,392,100 49,800 2,342,300 3,988,400 41.3% PERSONAL 3,704,300 0 3,704,300 4,056,700 -8.7% TOTALS 428,528,116 6,786,700 421,741,416 415,121,054 1.6% Average Residential Value 164,600 155,500 5.9% esidential Value 164,400 157,900 4.1% ANDOVE AG 24,171,690 0 24,171,690 24,098,651 03% RESID 2,439,061,324 28,404,900 2,410,656,424 2,347,859,416 17% APTS 25,656,300 0 25,656,300 22,104,400 16.1% C AND I 131,608,900 730,800 130,878,100 118,989,300 10.0% PERSONAL 26,635,200 0 26,635,200 26,635,100 0.0% TOTALS 2,647,133,414 29,135,700 2,617,997,714 2,617,997,714 2,539,686,867 3.1% Average Residential Value 224,000 \,j J�o 211,900 5.7% Median Residential Value 213,900 205,000 4.4% ANOKA AG 22,100 0 22,100 23,700 -6.8% RESID 760,808,300 7,750,300 753,058,000 703,163,425 7.1% APTS 206,858,000 8,777,400 198,080,600 179,954,800 10.1% CANDI 304,500,400 2,535,800 301,964,600 284,694,500 6.1% PERSONAL 5,750,500 11,200 5,739,300 5,711,600 0.5% TOTALS 1,277,939,300 19,074,700 1,258,864,600 1,173,548,025 7.3% Average Residential Value 156,300 141,300 10.6% Median Residential Value 148,200 136,700 8.4% BETHEL AG 613,398 0 613,398 579,009 5.9% RESID 20,646,273 20,600 20,625,673 19,971,651 3.3% APTS 150,000 0 150,000 144,900 3.5% C AND I 3,984,400 19,000 3,965,400 3,804,000 4.2% PERSONAL 1,179,700 0 1,179,700 1,179,700 0.0% TOTALS 26,573,771 39,600 26,534,171 25,679,260 3.3% Average Residential Value 105,900 100,400 5.5% Median Residential Value 117,000 114,300 2.4% Thursday, April 07, 2016 Taxable Market Value Comparison [PRTPROD) 3 -1 c a ANOKA COUNTY 2016 Pay 2017 Market Value PAYABLE 2016/PAYABLE 2017 TAXABLE MARKET VALUE COMPARISON as of 04/07/2016 2016 Pay 2017 % CHG from 2016 Pay 2017 MV w/o New 2015 Pay 2016 2016 to 2017 New Construction Construction Market Value w/o NC BLAINE AG 14,004,120 0 14,004,120 15,737,807 - 11.0% RESID 4,308,100,769 87,078,900 4,221,021,869 4,009,211,438 5.3% APTS 193,904,600 5,560,200 188,344,400 168,721,800 11.6% C AND 1 1,006,843,900 29,795,300 977,048,600 859,366,300 13.7% PERSONAL 75,658,900 14,000 75,644,900 73,481,700 2.9% TOTALS 5,598,512,289 122,448,400 5,476,063,889 5,126,519,045 6.8% Average Residential Value 199,700 - 181,200 10.2% Median Residential Value 169,600 155,900 8.8% CENTERVILLE AG 745,656 0 745,656 760,266 -1.9% RESID 295,250,581 4,413,300 290,837,281 279,170,545 4.2% APTS 924,500 99,900 824,600 639,400 29.0% C AND I 23,561,300 353,200 23,208,100 21,060,900 10.2% PERSONAL 2,459,200 0 2,459,200 2,459,200 0.0% TOTALS 322,941,237 4,866,400 318,074,837 304,090,311 4.6% Average Residential Value 206,300 191,700 7.6% Median Residential Value 182,700 165,300 10.5% CIRCLE PINES AG 0 0 0 0 N/A RESID 309,453,851 318,400 309,135,451 294,660,081 4.9% APTS 17,374,300 0 17,374,300 15,856,500 9.6% C AND 1 15,149,900 0 15,149,900 13,690,500 10.7% PERSONAL 1,554,900 0 1,554,900 1,575,000 -1.3% TOTALS 343,532,951 318,400 343,214,551 325,782,081 5.4% Average Residential Value 159,500 149,000 7.0% Median Residential Value 144,000 134,200 7.3% COLUMBIA HEIGHTS AG 0 0 0 0 N/A RESID 903,786,591 14,806,500 888,980,091 828,645,704 7.3% APTS 93,034,400 50,500 92,983,900 73,490,000 26.5% C AND I 98,610,800 970,000 97,640,800 92,814,700 5.2% PERSONAL 6,500,600 0 6,500,600 6,489,800 0.2% TOTALS 1,101,932,391 15,827,000 1,086,105,391 1,001,440,204 8.5% Average Residential Value 128,600 115,400 11.4% Median Residential Value 129,900 119,800 8.4% Thursday, April 07, 2016 Taxable Market Value Comparison [PRTPROD] 3 - 2 ANOKA COUNTY a 2016 Pay 2017 Market Value PAYABLE 2016/PAYABLE 2017 TAXABLE MARKET VALUE COMPARISON as of 04/07/2016 2016 Pay 2017 % CHG from 2016 Pay 2017 MV w/o New 2015 Pay 2016 2016 to 2017 New Construction Construction Market Value w/o NC COLUMBUS AG 29,803,279 0 29,803,279 31,125,148 -4.2% RESID 389,746,170 5,135,500 384,610,670 358,907,170 7.2% APTS 0 0 0 0 N/A C AND I 69,809,900 436,100 69,373,800 66,628,200 4.1% PERSONAL 6,160,600 0 6,160,600 6,160,600 0.0% TOTALS 495,519,949 5,571,600 489,948,349 462,821,118 5.9% Average Residential Value 234,800 213,100 10.2% Median Residential Value 222,700 204,200 9.0% COON RAPIDS AG 884,800 0 884,800 993,185 -10.9% RESID 3,131,646,612 14,370,200 3,117,276,412 2,988,055,925 4.3% APTS 343,217,200 1,824,700 341,392,500 307,159,800 11.1% C AND I 924,724,600 5,129,200 919,595,400 884,721,200 3.9% PERSONAL 38,296,900 0 38,296,900 38,071,900 0.6% TOTALS 4,438,770,112 21,324,100 4,417,446,012 4,219,002,010 4.7% Average Residential Value 149,700 139,900 7.0% Median Residential Value 144,500 136,500 5.9% EAST BETHEL AG 30,010,591 133,800 29,876,791 30,402,529 -1.7% RESID 815,065,109 11,669,900 803,395,209 740,935,479 8.4% APTS 6,909,200 0 6,909,200 6,188,800 11.6% C AND I 46,225,700 412,100 45,813,600 44,019,800 4.1% PERSONAL 9,178,100 17,500 9,160,600 9,704,400 -5.6% TOTALS 907,388,700 12,233,300 895,155,400 831,251,008 7.7% Average Residential Value 175,800 157,300 11.8% Median Residential Value 174,400 157,900 10.5% FRIDLEY AG 0 0 0 0 N/A RESID 1,203,483,736 4,761,200 1,198,722,536 1,090,759,249 9.9% APTS 241,891,900 8,718,500 233,173,400 208,620,600 11.8% CANDI 799,466,700 22,252,800 777,213,900 723,129,100 7.5% PERSONAL 26,283,700 0 26,283,700 26,313,700 -0.1% TOTALS 2,271,126,036 35,732,500 2,235,393,536 2,048,822,649 9.1% Average Residential Value 137,700 122,700 12.2% Median Residential Value 142,100 127,700 11.3% Thursday, April 07, 2016 Taxable Market Value Comparison [PRTPROD] 3 - 3 _' "' ANOKA COUNTY n - 2016 Pay 2017 Market Value PAYABLE 2016/PAYABLE 2017 TAXABLE MARKET VALUE COMPARISON as of 04/0712016 2016 Pay 2017 % CHG from 2016 Pay 2017 MV w/o New 2015 Pay 2016 2016 to 2017 New Construction Construction - Market Value w/o NC HAM LAKE AG 32,550,605 0 32,550,605 32,647,960 -0.3% RESID 1,374,700,288 23,323,400 1,351,376,888 1,270,476,559 6.4% APTS 15,089,400 0 15,089,400 13,678,700 10.3% C AND I 125,175,000 579,300 124,595,700 117,957,400 5.6% PERSONAL 16,654,500 0 16,654,500 16,650,500 0.0% TOTALS 1,564,169,793 23,902,700 1,540,267,093 1,451,411,119 6.1% Average Residential Value 241,000 218,700 10.2% Median Residential Value 227,800 207,000 10.1% HILLTOP AG 0 0 0 0 N/A RESID 2,620,709 22,900 2,597,809 2,394,482 8.5% APTS 10,717,300 0 10,717,300 10,205,200 5.0% C AND I 9,186,000 0 9,186,000 8,438,200 8.9% PERSONAL 332,500 0 332,500 332,500 0.0% TOTALS 22,856,509 22,900 22,833,609 21,370,382 6.8% Average Residential Value 77,100 63,000 22.4% - Median Residential Value 72,400 47,900 51.4% LEXINGTON AG 0 0 0 0 N/A RESID 81,148,556 907,500 80,241,056 78,185,152 2.6% APTS 10,921,900 0 10,921,900 9,953,600 9.7% CANDI 18,638,500 749,100 17,889,400 16,076,100 11.3% PERSONAL 1,515,100 0 1,515,100 1,843,200 - 17.8% TOTALS 112,224,056 1,656,600 110,567,456 106,058,052 4.3% Average Residential Value 144,400 135,700 6.4% Median Residential Value 143,300 138,500 3.4% LINO LAKES AG 32,527,340 101,500 32,425,840 32,416,230 0.0% RESID 1,595,856,701 14,982,900 1,580,873,801 1,495,530,353 5.7% APTS 21,171,900 1,609,800 19,562,100 17,210,100 13.7% C AND I 145,316,300 906,400 144,409,900 135,966,900 6.2% PERSONAL 18,226,000 0 18,226,000 18,165,300 0.3% TOTALS 1,813,098,241 17,600,600 1,795,497,641 1,699,288,883 5.7% Average Residential Value 229,400 211,800 8.3% Median Residential Value 215,600 201,000 7.3% Thursday, April 07, 2016 Taxable Market Value Comparison (PRTPROD] 3 - 4 e , a. r ANOKA COUNTY 2016 Pay 2017 Market Value PAYABLE 20161PAYABLE 2017 TAXABLE MARKET VALUE COMPARISON as of 04/0712016 2016 Pay 2017 % CHG from 2016 Pay 2017 MV w/o New 2015 Pay 2016 2016 to 2017 New Construction Construction Market Value w/o NC NOWTHEN AG 64,766,079 663,700 64,102,379 64,742,276 -1.0% RESID 378,364,228 4,597,400 373,766,828 346,913,553 7.7% APTS 0 0 0 0 N/A C AND I 16,569,700 915,700 15,654,000 14,378,500 8.9% PERSONAL 6,187,200 0 6,187,200 6,187,200 0.0% TOTALS 465,887,207 6,176,800 459,710,407 432,221,529 6.4% Average Residential Value 232,800 210,600 10.5% Median Residential Value 235,700 214,000 10.1% OAK GROVE AG 32,393,220 65,500 32,327,720 32,717,650 -1.2% RESID 686,043,663 9,226,000 676,817,663 668,400,427 1.3% APTS 0 0 0 0 N/A CANDI 18,558,800 85,400 18,473,400 17,405,100 6.1% PERSONAL 8,131,700 0 8,131,700 8,131,700 0.0% TOTALS 745,127,383 9,376,900 735,750,483 726,654,877 1.3% Average Residential Value 212,300 201,900 5.2% Median Residential Value 201,900 196,900 2.5% RAMSEY AG 15,582,996 20,700 15,562,296 15,426,901 0.9% RESID 1,726,017,844 23,125,200 1,702,892,644 1,619,639,560 5.1% APTS 57,412,900 2,861,500 54,551,400 45,242,000 20.6% C AND I 273,435,200 1,410,300 272,024,900 259,553,800 4.8% PERSONAL 20,227,300 0 20,227,300 20,929,000 - -3.4% TOTALS 2,092,676,240 27,417,700 2,065,258,540 1,960,791,261 5.3% Average Residential Value 190,800 174,700 9.2% Median Residential Value 180,800 169,100 6.9% SPRING LAKE PARK AG 0 0 0 0 N/A RESID 298,203,062 5,176,300 293,026,762 274,887,430 6.6% APTS 51,713,800 502,900 51,210,900 45,059,900 13.7% C AND I 87,204,500 575,500 86,629,000 80,959,800 7.0% PERSONAL 3,045,000 0 3,045,000 3,045,000 0.0% TOTALS 440,166,362 6,254,700 433,911,662 403,952,130 7.4% Average Residential Value 147,100 133,400 10.3% Median Residential Value 146,400 132,300 10.7% Thursday, April 07, 2016 Taxable Market Value Comparison [PRTPROD] 3 - 5 A ANOKA COUNTY PAYABLE 2016/PAYABLE 2017 TAXABLE MARKET VALUE d COMPARISON as of 04/07/2016 2016 Pay 2017 % CHG from ANOKA 2016 Pay 2017 2016 Pay 2017 MV w/o New 2015 Pay 2016 2016 to 2017 COUNTY Market Value New Construction Construction Market Value w/o NC ST FRANCIS AG 24,548,425 345,700 24,202,725 24,543,356 -1.4% RESID 350,945,442 6,276,700 344,668,742 328,313,850 5.0% APTS 21,689,900 0 21,689,900 20,441,600 6.1% C AND 1 31,880,300 225,100 31,655,200 29,548,700 7.1% PERSONAL 6,691,100 0 6,691,100 6,691,100 0.0% TOTALS 435,755,167 6,847,500 428,907,667 409,538,606 4.7% Average Residential Value 140,900 129,100 9.1% Median Residential Value 142,000 133,100 6.7% COUNTY OF ANOKA AG 318,227,684 1,348,600 316,879,084 321,287,913 -1.4% RESID 21,475,717,040 273,087,200 21,202,629,840 20,136,067,558 5.3% APTS 1,320,698,600 30,005,400 1,290,693,200 1,146,688,700 12.6% CANDI 4,152,842,900 68,130,900 4,084,712,000 3,797,191,400 7.6% PERSONAL 284,373,000 42,700 284,330,300 283,814,900 0.2% TOTALS 27,551,859,224 372,614,800 27,179,244,424 25,685,050,471 5.8% Average Residential Value 182,000 U) f rp ""o 0 167,200 8.9% Median Residential Value 165,600 153,700 7.7% Comments and Current year State Assessed Values are not available, prior year values have been included for estimate purposes. Limiting Conditions: Thursday, April 07, 2016 Taxable Market Value Comparison [PRTPROD] 3 -6 City of Andover General Fund 2016 Fund Balance Analysis Requested Actual 4/22/2016 December 31, 2015 — $ 7,267,904 2016 Estimated Fund Balance Increase (Decrease) (363,377) Projected December 31, 2016 6,904,527 Less: %Snow Emergency (80,000) Public Safety (80,000) Facility Management (80,000) Information Technology (80,000) 2017 Budgeted Use of Fund Balance 3( 50 OQ.Q1 Economic Development (300,000) Prepaids / Inventories (131,813) Working Cash Flow - 5( 536,105) Estimated Balance Available for Adjustments �. $ 266,609 2016 Working Cash Flow Designation Calculation: 2017 Requested Expenditure - Preliminary Estimate $11,072,211 % of 2017 General Fund Expenditures 50.000% $ 5,536,105 GF - Fund Balancexls O c, C I T Y O F ND OVE 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: March 2016 General Fund Budget Progress Report DATE: April 26, 2016 INTRODUCTION The City of Andover 2016 General Fund Budget contains total revenues of $10,390,411 and total expenditures of $10,753,788 (includes $56,000 of 2015 budget carry forwards primarily for elections and facility management); 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 2016, reflecting year to date actual through March 2016. The attachment provided is to assist discussion in reviewing 2016 progress; other documents may be distributed at the meeting. The following represents Administration's directives and departmental expectations that are in place again for 2016: 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 The Council is requested to receive a presentation and provide direction to staff. submitted, Jiml Dickinson REVENUES General Property Tax Licenses and Permits Intergovernmental Charges for Services Fines Investment Income Miscellaneous Transfers In Total Revenues EXPENDITURES CITY OF ANDOVER General Fund Budget Summary Totals Budget Year 2016 2015 1 2016 Budget Mar YTD % Bud YE- Unaudited Budget Mar YTD % Bud $ 7,706,892 $ - 0% $ 7,634,714 316,588 83,289 26% 452,422 633,015 199,300 31% 749,571 748,550 111,670 15% 749,416 100,750 19,450 190/6 99,304 75,000 (25,300) -34% 40,690 98,850 62,703 63% 154,889 196,930 196,930 100% 196,930 $ 9,876,575 $ 648,042 7% $ 10,077,936 15,909 2015 7,474 21% Budget Mar YTD % Bud YE- Unaudited $ 8,113,528 $ 267 0% 346,205 76,611 22% 673,248 195,158 29% 767,950 105,615 14% 100,750 14,657 15% 75,000 (22,800) -30% 116,800 61,904 53% 196,930 196,930 100% $ 10,390,411 $ 628,342 60/. 27% 2016 26,000 Budget Mar YTD % Bud GENERAL GOVERNMENT Mayor and Council $ 87,154 $ 41,772 48% $ 85,060 $ 88,780 $ 41,962 47% Administration 180,888 40,918 23% 172,296 192,778 43,619 23% Newsletter 26,000 7,138 27% 21,042 26,000 10,477 40% Human Resources 40,156 6,513 16% 15,909 35,260 7,474 21% Attorney 182,000 30,249 17% 180,313 187,640 30,820 16% City Clerk 135,359 34,004 25% 134,776 157,075 38,072 24% Elections 57,492 1,956 3% 14,496 82,919 18,011 22% Finance 239,981 67,910 28% 240,317 261,016 70,221 27% Assessing 150,000 - 0% 146,315 150,000 - 0% Information Services 172,239 35,244 20% 131,745 173,483 35,895 21% Planning & Zoning 412,937 98,833 24% 406,045 435,606 103,368 24% Engineering 470,631 112,080 24% 464,842 509,514 119,503 23% Facility Management 579,802 104,180 18% 498,815 568,201 87,960 15% Total General Gov 2,734,639 580,797 21% 2,511,971 2,868,272 607,382 21% PUBLLCSAFETY Police Protection 2,918,308 729,577 25% 2,918,308 2,936,467 734,117 25% Fire Protection 1,192,330 173,953 15% 1,165,221 1,294,795 228,216 18% Protective Inspection 423,161 95,447 23% 391,948 441,807 97,369 22% Civil Defense 39,189 4,958 13% 24,352 22,982 4,990 22% Animal Control 9,950 568 6% 3,498 7,950 710 9% Total Public Safety 4,582,938 1,004,503 22% 4,503,327 4,704,001 1,065,402 23% PUBLIC WORKS Streets and Highways 625,664 131,894 21% 629,724 656,237 147,641 22% Snow and Ice Removal 539,770 189,194 35% 442,077 563,587 205,109 36% Street Signs 203,533 45,395 22% 204,494 204,193 35,158 17% Traffic Signals 35,000 4,073 12% 30,169 35,000 3,850 11% Street Lighting 36,400 5,169 14% 30,664 36,400 5,934 16% Street Lights - Billed 216,000 29,717 14% 201,501 217,500 32,365 15% Park & Recreation 1,185,338 222,250 19% 1,151,313 1,257,247 258,894 21% Natural Resource Preservation - - 0% - 10,096 50 0% Recycling 135,120 19,308 22% 128,038 130,927 17,469 13% Total Public Works 2,976,825 647,000 22% 2,817,980 3,111,187 706,470 23% OTHER Miscellaneous 31,728 15,328 48% 221,478 31,728 - 0% Youth Services 38,600 16,000 41% 35,242 38,600 14,500 38% Total Other 70,328 31,328 45% 256,720 70,328 14,500 21% Total Expenditures $ 10,364,730 $ 2,263,628 22% $ 10,089,998 $ 10,753,788 $ 2,393,754 22% NET INCREASE (DECREASE) $ (488,155) $ (1,615,586) $ (12,062) $ (363,377) S (1,765,412) •y'a No 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: March 2016 City Investments Review DATE: April 26, 2016 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 March 2016 the March 2016 Investment Detail Report, and the March 2016 Money Market Funds Report These attachments are intended to assist with discussion when reviewing the March 2016 investments. ACTION REQUESTED Informational. The Council is requested to review and provide feedback to staff. submitted, V Investment Maturities - March 2016 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,175,597 $ 1,175,597 $ $ $ MN Municipal Money Market Fund (4M) N/A 4,994 4,994 Premier Banks Money Market Fund N/A 260,264 260,264 Certificates of deposit FDIC 9,938,247 5,899,655 4,038,592 Local governments A /Al /A2 914,700 487,822 104,708 AA1 /AA2 /AA3 7,789,086 4,569,221 1,237,507 525,788 AAA 3,997,094 q1,456,57O 2,232,734 530,148 228,374 21,618 - 984,745 335,486 State governments A /Al /A2 - AA1 /AA2 /AA3 2,026,439 U.S. agencies AAA 759,396 402,292 AAA 3,245,608 531,322 2,186,922 300,264 227,100 FNMA REMIC N/A 6,889 6,889 U.S. agencies N/A 1,449,940 1,449,940 - Total investments $ 31,568,255 $ 12,100,396 $ 16,292,352 $ 2,317,911 $ 857,596 Deposits 2,883,859 Total cash and investments $ 34,452,114 March 2016 Investment Detail Description Cusip Number Credit RatinglF DIC # Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value merest Paid Date Acquired Coupon Date Maturity I Due Date Farmers State Bank 31034RBD6 12855 CD 248,000.00 248,000.00 248,000.00 0.350% 247,992.56 maturity 12/15115 none 04115/16 Cadence Bank 12738RCF9 4999 CD 249,000.00 249,000.00 249,000.00 0.350% 248,992.53 maturity 10/23/15 none 04/22/16 Bank of India NY 06279HBZ5 33648 CD 249,000.00 249,000.00 249,000.00 0.400% 248,990.04 maturity 10/30/15 none 04/27/16 BMO Harris Bank 05573J6A7 16571 CD 249,000.00 249,000.00 249,000.00 0.350% 248,990.04 maturity 10/28/15 none 04/28/16 Sallie Mae Bank 795450WQ4 58177 CD 249,000.00 249,000.00 249,000.00 0.400% 248,990.04 maturity 10/28/15 none 04/28116 Compass Bk 20451PPE0 19048 CD 248,000.00 248,000.00 248,000.00 0.450% 247,945.44 maturity 12/09/15 none 06/09/16 National Cooperative Bank 635573AG3 32612 CD 248,000.00 248,000.00 248,000.00 0.500% 247,947.92 maturity 12/09/15 none 06/09/16 Berkshire Bk 084601EX7 23621 CD 248,000.00 248,000.00 248,000.00 0.500% 247,942.96 maturity 12/11/15 none 06/10116 First Niagra Bk Natl Assn 33583CTB5 16004 CD 248,000.00 248,000.00 248,000.00 0.550% 247,938.00 maturity 12/11115 none 06/13/16 Safra National Bk 78658QSQ7 26876 CD 248,000.00 248,000.00 248,000.00 0.500% 247,918.16 maturity 12/14/15 none 06/14/16 First Source Bank 33646CGA6 9087 CD 248,000.00 248,000.00 248,000.00 0.450% 247,940.48_ maturity 12/15/15 none 06/15/16 Santander Bank NA 80280JKY6 29950 CD 249,000.00 249,000.00 249,000.00 0.650% 249,094.62 maturity 01120/16 none 07/20/16 Lake Forest Bank & Trust 509685ES8 27589 CD 200,000.00 200,000.00 200,000.00 0.850% 200,224.00 semi- annual 08/14/13 02/14/14 08115/16 Luana Savings Bank 549103MY2 253 CD 248,000.00 248,000.00 248,000.00 0.750% 248,188.48 semi - annual 08/16/13 02/16/14 08/16/16 BankUnited A Savings 066519BMO 58979 _CD 249,000.00 249,000.00 249,000.00 0.550% 249,099.60 maturity 02/19/16 none 08/19/16 Synovus Bank GA 87164DFL9 873 CD 248,000.00 248,000.00 248,000.00 0.800% 248,255.44 semi - annual 09/10/14 03/04/15 09/06116 Mountainone Bank 62452AAT7 90253 CD 245,000.00 245,000.00 245,000.00 0.600% 245,225.40 maturity 01/28/16 none 09/28116 Mizuho Bank USA 60688MSH8 21843 CD 245,000.00 245,000.00 245,000.00 0.700% 244,745.20 maturity 01/20/16 none 10/20/16 1 Year CD - Premier Bank 1091003210 21714 CD 250,000.00 250,000.00 250,000.00 0.600% 250,000.00 maturity maturity maturity maturity maturity maturity 12/16/15 12/16/15 12/16/15 12/16/15 none none none none 12/16/16 12/16/16 12/16/16 12/16/16 TCF National Bank_ _ 872278RE8 28330 CD 248,000.00 248,000.00 248,000.00 0.700% 247,898.32 1 Year CD - Premier Bank Rochester 1 Year CD - Premier Bank MN Wax Bank Whitney Bk New Orleans LA North Carolina Eastn Mun Pwr Prattville AL 2055214401 33202 CD 245,000.00 245,000.00 245,000.00 0.600% 0.600% 245,000.00 245,000.00 247,915.68 247,419.90 3041574901 92937CDJ4 966594AP8 658196U24 740019LG7 33204 CD 245,000.00 245,000.00 245,000.00 248,000.00 247,000.00 310,000.00 34697 CD CD 248,000.00 248,000.00 0.750% 12/16/15 none 12/16/16 12441 247,000.00 247,000.00 0.850% 6.217% 01/27/16 none 01/27/17 A3 AA local 323,218.40 323,218.40 322,170.60 semi - annual 03/16/16 07/01/08 01101/17 local 154,417.50 154,417.50 150,000.00 4.000% 152,031.00 semi- annual 10/27/15 none 09101/16 Chaska MN 161664DU8 AA local 76,434.00 76,434.00 75,000.00 2.000% 75,794.25 semi - annual 08/15/13 06/01/14 12/01/16 North Mankato MN Port Auth Com 660760AG4 AA local 107,657.00 107,657.00 100,000.00 4.000% 102,341.00 semi- annual 09/20/13 none 02/01/17 Lake Mills WI 510192FAO AA- local 65,000.00 65,000.00 65,000.00 0.700% 65,070.85 semi - annual 06/22/15 none 09/01/16 Des Moines IA Area Cmnty Col 250097A85 AA1 local 137,668.95 137,668.95 135,000.00 1.375% 135,247.05 semi - annual 07/30/12 12/01/12 06/01/16 Osseo MN ISO #279 688443,127 AA1 local 30,103.25 30,103.25 25,000.00 6.000% 26,129.50 semi - annual 12/22/11 none 02/01/17 Met Govt Nashville & Davidson Co TN 592112EH5 AA2 local 542,169.00 542,169.00 535,000.00 5.000% 541,179.25 semi - annual 03/17/16 none 07/01/16 Grand Forks NO Sales Tax Raven 385492GQO AA2 local 104,082.00 104,082.00 100,000.00 4.000% 101,422.00 semi- annual 06/23/15 09/01/12 09/01/16 Buffalo MN ISD #877 119655PS1 AA2 local 264,250.00 264,250.00 250,000.00 4.050% 257,355.00 semi - annual 03/10/15 none 02101/17 Charlotte NC Wtr & Swr Sys 161045GX1 AAA local 404,208.00 404,208.00 400,000.00 4.000% 403,652.00 semi - annual 03/17/16 01/01/09 07/01/16 Anchorage AK 033161E55 AAA local 508,285.00 508,285.00 500,000.00 5.000% 507,590.00 semi- annual 03/21/16 none 08/01/16 Maple Grove MN 56516PNY5 AAA local 230,520.40 230,520.40 220,000.00 2.000% 222,560.80 semi - annual 01/10/13 08/01/13 02/01/17 Ramsey Cnty MN 751622JG7 AAA local 100,000.00 100,000.00 100,000.00 1.130% 100,409.00 semi- annual 08/12/14 02101/15 02/01/17 Oregon State 68608URVO AA1 state 70,194.60 70,194.60 70,000.00 0.890% 70,142.80 semiannual 07/29/14 08/01113 08/01/16 Ohio State 677521BJ4 AA1 state 306,807.00 306,807.00 300,000.00 5.000% 306,252.00 semi- annual 03/17/16 none 09/15/16 Nevada State 641461NKO AA2 state 258,305.00 258,305.00 250,000.00 4.000% 251,525.00 semi - annual 06/18115 06/01/11 06/01/16 Mississippi State 605581BV8 AA2 state 25,000.00 25,000.00 25,000.00 1.116% 25,126.25 semi - annual 09/12/13 none 12/01/16 Florida St Hurricane 34074GDF8 AA3 state 160,836.80 160,836.80 160,000.00 1.298% 160,273.60 semi - annual 08/14/15 07/01/13 07/01/16 Ohio State Water Dev Auth Zero Coupon 67766WKK7 AAA state 199,412.00 199,412.00 200,000.00 199,890.00 maturity 07/28/15 none 06/01/16 5,899,654.81 CD 3,012,952.30 local March 2016 Investment Detail Description Cusip Number Credit Rating /F DIC # Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity Due Date Texas State 882723BT5 AAA state 211,414.00 211,414.00 200,000.00 4.000% 202,402.00 semi - annual 01/14/15 none 08/01/16 Fed NatlMtg Assn 3136G1YP8 AAA US 130,130.00 130,130.00 130,000.00 0.800% 130,643.50 semiannual 07/08/15 none 12/30/16 Farmer Mac 31315PZV4 AAA US 200,584.00 200,584.00 200,000.00 1.140% 200,750.00 semiannual 03/21/16 08/03/12 02/03/17 Fed Farm Credit Bank 3133EE6A3 AAA US 200,000.00 200,000.00 200,000.00 0.590% 199,928.00 semi - annual 12/09/15 02/06/16 02/06/17 10,659,540.26 Amex Centurion Bank 02587DE61 27471 CD 248,000.00 248,000.00 248,000.00 0.900% 248,267.84 semi - annual 10/28/15 04/28/16 04/28/17 Capital One 14042E4Q0 4297 CD 248,000.00 248,000.00 248,000.00 1.150% 248,290.16 semi - annual 07/15/15 01/15/16 07/17/17 Farmers & Merchants Svgs Bk 30856PAG1 9298 CD 249,000.00 249,000.00 249,000.00 1.050% 250,078.17 monthly 01/22/16 02/22/16 10/23/17 Valley Cent Svgs Bk Reading OH 91944RAE8 28555 CD 150,000.00 150,000.00 150,000.00 1.250% 150,462.00 monthly 12/22/14 01/22/15 12/22/17 BMW Bank of North America 05580ADR2 35141 CD CD 245,000.00 247,000.00 245,000.00 245,000.00 1.600%1 246,717.45 semi - annual 01/22/16 07/22/16 01/22/19 Barclays Bank 06740KHB6 57203 247,000.00 247,000.00 2.050% 251,077.97 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% 250,969.29 semi - annual 07/11/14 01/11/15 07/11/19 PdvateBank & Trust Cc 74267GUQ8 33306 CD 247,000.00 247,000.00 247,000.00 2.000% 250,937.18 semi- annual 07121/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% 250,611.14 semi - annual semi - annual 07/23/14 01/23/15 07/23/19 Bangor Savings Bank 060243DV1 18408 CD 245,000.00 245,000.00 245,000.00 1.000% 245,085.75 07/30/14 01/30/15 07/30/19 First Federal Svgs Bk 32021YCH4 29690 CD 249,000.00 249,000.00 249,000.00 1.500% 253,076.13 monthly 01121/16 02/21/16 08/21/19 Victory Bank 92644IAB8 58615 CD 247,000.00 247,000.00 247,000.00 2.000%1 250,702.53 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% 130,229.76 semi- annual 11124/14 05/24/15 11/25/19 Celtic Bank 15118RJMO 57056 CD CD CD CD local local 247,000.00 247,000.00 249,000.00 249,000.00 170,045.70 101,003.00 247,000.00 247,000.00 247,000.00 2.050% 252,542.68 semi - annual semi - annual 12/20/13 12/26/14 06/27/14 06/20/14 06/26/15 07/27/14 12/20/19 12/26/19 06/26/20 Stearns Bank NA _ Citizens Alliance Bank Enerbank USA Elbow Lake MN Oshkosh Wis Storm Wtr Util 857894PB9 17318LAP9 29266NA31 284281KC5 68825RBD1 6824543R2 10988 247,000.00 1.000% 251,273.10 254,119.44 254,151.81 173,485.95 1402 249,000.00 249,000.00 2.000% 2.100% 2.750% monthly _ monthly 57293 A Al 249,000.00 170,045.70 101,003.00 249,000.00 165,000.00 100,000.00 07/18/14 08/18/14 07/20/20 semi - annual semi - annual 12/08114 none 12/01/19 3.250% 103,542.00 10/05/10 05/01/11 05/01/18 Oneida County NY Al local 91,510.40 91,510.40 _ 80,000.00 6.250% 85,135.20 semi - annual 08/16/10 none 04/15/19 Junction City Kansas 481502F72 A2 local 101,558.00 101,558.00 100,000.00 5.500% 110,201.00 semi - annual 05/28/08 03/01/09 09/01/18 Augusta ME 051411ND4 A3 local 16,875.00 16,875.00 15,000.00 5.250% 15,457.65 semi - annual 03/07/12 none 10/01/17 Philadelphia PAAuth Zero Coupon 71781LBJ7 AA local 161,700.00 161,700.00 245,000.00 241,045.70 maturity 01/12/10 none 04/15/17 Rice Cnty MN 762698GK8 AA local 45,466.80 45,466.80 40,000.00 4.400% 43,757.60 semi - annual 03/07/12 none 02/01/19 Racine WI 7500216D4 AA- local 101,792.00 101,792.00 100,000.00 2.100%1 102,503.00 semi - annual 01124/12 06/01/12 06/01/18 Minnetrista MN 604229KE3 AA+ local 10,000.00 10,000.00 10,000.00 2.450%1 10,013.60 semi - annual 10/10/13 08/01/14 02/01/19 Ramsey MN 751813P86 AA+ local 158,677.85 158,677.85 145,000.00 4.500%1 145,439.35 semi - annual 02/16/12 04/01/16 04/01/19 Stearns Cc MN 857896MH4 AA+ local 276,875.00 276,875.00 250,000.00 4.500% 258,772.50 semi - annual 04/17/13 none 06/01120 Minnetrista MN 604229KG8 AA+ local 161,038.40 161,038.40 160,000.00 3.100% 160,217.60 semi - annual 10/10/13 08/01/14 02/01/21 Greenway MNISD #31 39678LDF6 AA+ local 27,593.50 27,593.50 25,000.00 5.000% 27,576.75 semi - annual 07/09/13 none 03/15/21 McKinney TX 581646Y91 AA1 local 126,856.25 126,856.25 125,000.00 1.472% 126,436.25 semi - annual 05/20/15 none 08/15/17 Dane County WI 236091M92 AA1 local 106,487.00 106,487.00 100,000.00 2.450% 4.000% 102,736.00 212,770.00 semi - annual semi- annual 07/16/12 03/04/14 none none 12/01/17 03/01/18 Minneapolis MN 60374YF93 AA1 local 220,938.00 220,938.00 _ 200,000.00 Scott County IA 809486EZ2 AA1 local 114,450.33 112,617.00 100,000.00 4.40006 105,608.00 semi- annual 10/31/12 12/01/12 06/01/18 King Cnty WA 49474E3L5 AA1 local 224,634.00 224,634.00 200,000.00 3.980% 215,174.00 semi - annual 03/27/12 none 12/01/18 Minneapolis MN 60374YS73 AA1 local 111,898.00 111,898.00 100,000.00 3.250% 106,491.00 semi- annual 06/05/12 12/01/11 12/01/18 Cedar Rapids ]A 150528RM1 AA1 local 217,672.00 217,672.00 200,000.00 3.000% 211,834.00 semi - annual 06/11/13 12/01/13 06/01/19 Minneapolis MN 60374YS81 I AA1 local 278,632.50 278,632.50 250,000.00 3.500% 270,857.50 semi - annual 02/26/13 none 12/01/19 1,215,611.65 state 531,321.50 US -ess Than 1 Year 4,038,592.40 CD March 2016 Investment Detail Description Cusip Number Credit Rating /F DIC # Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity 1 Due Date Hampton VA 4095582J1 AA1 local 100,836.00 100,836.00 100,000.00 100,000.00 2.209% 3.750% 103,166.00 106,252.00 semi- annual semi - annual 01/20/16 02/24/15 none none 04/01/20 Middleton WI 596782RX2 AA1 local 106,979.00 106,979.00 09/01/20 Waterloo IA 941647KE8 AA2 local 105,594.00 105,594.00 100,000.00 3.500% 103,195.00 semi - annual 02/24/15 none 06/01/17 Prior Lake MN 742617CB7 AA2 local 230,000.00 230,000.00 230,000.00 1.000% 231,025.80 semi - annual 05/14/15 12/15/15 12/15/17 Hopkins Minn ISD #270 439881HCO AA2 local 95,278.40 95,278.40 80,000.00 5.250% 86,235.20 semi - annual 04/30/12 08/01/09 02/01118 Orange Beach ALA 68406PHF1 AA2 local 241,689.60 241,689.60 240,000.00 4.400% 256,077.60 semi - annual 08/05/10 02/01/11 02/01/19 Waterloo IA 941647PAl AA2 local 50,559.50 50,559.50 50,000.00 2.000% 51,407.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% 106,362.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% 306,295.55 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% 111,905.20 semi - annual 08/21/15 none 05/01/20 Tucson AZ Kane McHenry Cook & De Kalb Zero Cpn 898711Q33 AA3 local 254,202.50 254,202.50 250,000.00 2.139%1 255,130.00 semi - annual 12/09/15 none 07/01/17 484080MB9 AA3 local 157,328.00 157,328.00 200,000.00 189,250.00 maturity 07/16/12 none 12/01118 Moorhead MN 616141287 AA3 local 108,820.00 108,820.00 100,000.00 3.800% 103,463.00 semi - annual 11/14/11 none 02/01/20 Davenport Iowa 238388GS5 AA3 local 111,948.00 111,948.00 100,000.00 4.650% 104,100.00 semi - annual 09/13111 none 06/01/20 Whitewater Wis 966204KA6 AA3 local 109,541.00 109,541.00 100,000.00 4.850% 114,124.00 semi - annual 06/09111 none 12/01/20 Tennessee Valley Auth 880591EA6 AAA local 93,153.11 93,153.11 85,000.00 5.500% 90,139.10 semi - annual 06/01/09 01/18/08 07/18/17 Washington County MN 937791KL4 AAA local 115,000.00 115,000.00 115,000.00 3.750% 118,864.00 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% 105,406.00 semi - annual 12/22/11 none 02/01/18 Brownsville TX ISD Zero Coupon 116421E46 AAA local 229,640.00 229,640.00 250,000.00 242,420.00 maturity semi - annual semi - annual maturity 06/26/13 12/22/11 07/06/11 none none none none 08115/18 02/01/19 06/01/19 06/15/19 Minnetonka MN ISD #276 604195RA7 AAA local 37,433.20 256,504.60 262,890.00 122,464.80 366,832.80 37,433.20 35,000.00 3.100% 36,490.65 Palm Beach Cnty FLA Tenn Val Auth Cpn Strip Zero Cpn Norwalk Conn Greensboro NC_ Woodbury MN Dallas TX Indpt Sch Dist 696497TR7 AAA local local local local local 256,504.60 220,000.00 5.898% 236,977.40 286,857.00 88059EWZ3 668844DS9 39546OV21 97913PCQ7 235308QK2 AAA AAA AAA AAA 262,890.00 122,464.80 366,832.80 123,037.35 300,000.00 120,000.00 360,000.00 115,000.00 100,000.00 12/27/13 4.050% 128,212.80 semi - annual 08/04/10 08/01/11 08/01/19 3.263% 3.250% 4.450% 383,018.40 semi - annual 07/15/11 none 10/01/19 123,037.35 120,601.65 semi - annual 12122/11 none 02/01/20 AAA AAA local local 116,900.00 116,900.00 111,191.00 semi- annual 04/16/12 08/15/11 02115/20 Tenn Valley Auth Zero Cpn 88059EHD9 263,970.00 263,970.00 300,000.00 279,792.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 92,764.00 maturity 03/18/13 none 07/15/20 Washington State 939758DL9 AA state 205,804.00 205,804.00 200,000.00 4.500% 213,420.00 semi - annual 01/24/12 1 04/01112 1 10101/18 Massachusetts State 57582P2T6 AA1 state 199,744.00 199,744.00 200,000.00 2.090% 206,238.00 semi - annual 12/17/14 11/01/14 05/01/20 New Ham )shire St Hsg 64469DWUI AA2 state 250,952.50 250,952.50 250,000.00 1.789% 253,195.00 semi- annual 12/09/15 07/01/16 01/01/18 New Hampshire St Hsg 64469DWV9 AA2 state 135,804.60 135,804.60 135,000.00 1.939% 137,177.55 semi - annual 12/09/15 07/01/16 07/01/18 Minnesota St Colleges & Univ 60414FPJ3 AA2 state 100,000.00 100,000.00 100,000.00 2.000% 102,354.00 semi- annual 02/26/15 10/01/15 10/01/20 Florida St Hurricane 34074GDH4 AA3 state 71,507.80 71,507.80 70,000.00 2.995% 72,360.40 semi - annual 11/10/15 07/01/13 07/01/20 Tennessee State 880541QM2 AAA state 201,894.00 201,894.00 200,000.00 2.326% 204,530.00 semi - annual 10/26/11 02/01/12 08/01/17 Georgia State 373384RQ1 AAA state 26,742.50 26,742.50 25,000.00 2.9700% 26,203.25 semi - annual semi - annual 02/08/12 08/10/11 none 04/01112 10/01/18 10/01/18 Texas State 882722,151 AAA state 103,089.00 103,089.00 100,000.00 2.894% 104,753.00 Fed Farm Credit Bank 3133EATE8 AAA US 99,647.00 99,647.00 100,000.00 0.900% 100,234.00 semi- annual 11/04/13 12/08/12 06/08/17 Fed Farm Credit Bank 3133ECA95 AAA US 199,800.00 199,800.00 200,000.00 0.790% 199,972.00 semi - annual 12/08/15 03/18/13 09/18/17 Fed Home Ln Mtlq Corp 3134G46D5 AAA US 198,000.00 198,000.00 200,000.00 1.200% 200,058.00 semi - annual 06/12/13 12/12/13 06/12/18 Fed Home Ln Mtg Corp Med Term Note 3134G3ZK9 AAA US 200,000.00 114,000.00 200,000.00 114,000.00 200,000.00 1.200% 201,450.00 semi - annual 07/30/12 01/30/13 07/30/18 Fed Farm Credit Bank 31331Y4S6 AAA US 100,000.00 5.050% 109,464.00 semi- annual 09/11/13 none 08/01118 Fed NatlMtg Assn 3136GORB9 AAA US 294,999.00 294,999.00 300,000.00 1.375% 300,087.00 semi - annual 12/05/13 12/28/12 12/28/18 Fed NatlMtg Assn 3136GOY70 AAA US 199,300.00 199,300.00 200,000.00 1.080%1 200,368.00 semi - annual 10/30/12 01/30/13 01/30/19 7,289,777.00 local 1,320,231.20 state March 2016 Investment Detail Description Cusip Number Credit Rating /F DIC # Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity/ Due Date Fed Farm Credit Bank 3133EC5N0 AAA US 99,587.00 185,568.00 99,587.00 100,000.00 1.250% 100,001.00 semi - annual 01/07113 03/04/13 03/04/19 RFCSP Strip Principal Zero Coupon 76116FAA5 AAA US 185,568.00 200,000.00 190,892.00 maturity 07/22/15 none 10/15/19 Fed Home Ln Mtg Corp Zero Cpn 313400BV4 AAA US 278,625.00 278,625.00 300,000.00 284,229.00 maturity 11/02/15 none 11129/19 Fed Home Ln Bank 3130A3XL3 AAA US 99,500.00 99,500.00 100,000.00 1.500% 100,167.00 semi - annual 07/22/15 08/10/15 02/10/20 Fed Farm Credit Bank 3133ECQ64 AAA US 191,812.00 191,812.00 200,000.00 1.740%1 200,000.00 semi - annual 07/23/13 11/21/13 05/21/20 Fed Natl Mtg Assn Remic 31393EAL3 US 204,187.50 6,865.42 6,724.62 4.500% 6,889.10 monthly 07/30/03 none 08/25/18 FICO Strip Prin Zero Coupon 31771KAC1 US 295,932.00 295,932.00 300,000.00 296,124.00 maturity 10/23115 none 10/06/17 FICO Strip Pm4 Zero Coupon 31771EAD3 US 194,572.00 194,572.00 200,000.00 197,528.00 maturity 03/16/15 none 10/06/17 FICO Strip Cpn -E Zero Coupon 31771JXM7 US 215,452.16 215,452.16 5224,000.00 220,312.96 maturity 12/11/14 none 11/02/17 FICO Strip Cpn Zero Coupon 31771EAA9 US 529,947.00 529,947.00 550,000.00 538,455.50 maturity 06/09/14 none 05/11/18 Fed Home Ln Mtg Carp 31393VMQ1 US 153,656.25 3,922.20 3,828.86 4.500% 3,922.59 monthly 06/30/03 06/15118 FICO Strip Cpn13 Zero Coupon 31771C2G9 US 93,140.00 93,140.00 100,000.00 97,126.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 96,471.00 maturity 04/17115 none 02/01/19 16,292,351.75 ] Chaska MN 1616636S3 AA local 115,122.70 115,122.70 110,000.00 4.000% 116,768.30 semi - annual 09108/14 none 02/01/24 Mitchell SD Sch Dist #17-2 606687EHO AA local 116,702.00 116,702.00 100,000.00 111,209.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 40,062.00 semi- annual semi - annual semi - annual semi - annual semi - annual 10/10113 06/17/10 05/11/11 11/10/14 10131/11 12/09/14 08/01/14 02/01/11 none 12/01/14 none none 02/01/23 02/01/24 02/01/25 06/01/21 03/01123 Savage Minn 80465PAN4 AA+ local 198,018.00 198,018.00 200,000.00 F4.8001%/. 212,120.00 Lake City Minn ISD #813 508084DW7 250097H21 60374YG68 60374YG76 0151311-06 264438ZL9 420218PL7 AA+ local 103,933.00 103,933.00 100,000.00 106,209.00 Des Moines IA Area Cmnty Col Minneapolis MN Minneapolis MN Alexandria MN ISD #206 Duluth MN Hawkins Cnty TN AA1 AA1 AA1 AA2 _ AA2 AA3 local local local local local 50,606.00 50,606.00 50,000.00 100,000.00 65,000.00 270,000.00 30,000.00 52,415.00 108,965.00 70,691.40 282,765.60 30,085.50 110,419.00 110,419.00 72,201.35 279,760.50 4.800% 3.000% 2.625% 72,201.35 279,760.50 29,767.20 semi - annual 03/01/24 semi- annual 01/21/15 none 02/01/23 29,767.20 semi - annual 12/05/12 08/01/13 02/01/25 local 111,480.00 111,480.00 100,000.00 4.800% 106,216.00 semi- annual 03/13/12 none 05/01/24 New York St Mtge Agy 64988RHGO AAA local 100,000.00 100,000.00 100,000.00 2.375% 102,351.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% 41,170.00 semi - annual 02/20/15 none 12/01/21 Tennessee Valley Auth SerE 880591CJ9 AAA local 121,500.00 121,500.00 100,000.00 6.750% 136,627.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 Florida St Dept Environmental 3416OWUAO AA3 state 217,800.00 22,126.00 217,800.00 200,000.00 6.206% 228,374.00 semi - annual 08/30/10 07/01/10 07/01/22 Virginia State 928109XD4 AAA state 22,126.00 20,000.00 4.100% 21,617.80 semi- annual 02/07/12 none 06/01/21 Fed Home Ln Bank 3130A6VA2 AAA US 300,000.00 300,000.00 300,000.00 300,264.00 semi - annual 12116!15 06/16!16 12/16/22 2,317,910.60 Itasca County Minn 465452GP9 A local 105,024.00 105,024.00 100,000.00 r2.450% 104,708.00 semi - annual 07/12/11 none 02/01/28 Milaca Minn ISD #912 598699NT9 AA+ local 106,941.00 106,941.00 100,000.00 107,509.00 semi- annual 07/22/11 none 02/01/27 Van Buren Mich Public Schools 920729HD5 AA1 local 102,750.00 102,750.00 100,000.00 112,129.00 semi - annual 07/17/09 11101/09 05/01/29 Will County IL Cmnty Zero Coupon 969078QM9 AA2 local 159,000.00 159,000.00 500,000.00 306,150.00 maturity 08/25/09 none 11/01/27 Fed Home Ln Bank 313381D51 AAA US 93,750.00 93,750.00 100,000.00 2.000% 99,630.00 semi - annual 12/23/14 none 11/23127 Fed Farm Credit Bank 31331VLC8 AAA US 106,030.45 106,030.45 100,000.00 5.250% 127,470.00 semi - annual 02/26/10 none 04/21/28 857,596.00 30,127,398.61 3,643,751.15 US 5 Years 1,767,654.80 local 249,991.80 state 300,264.00 US i- 10 Years 630,496.00 local 227,100.00 US 10+ Years INVESTMENT SCHEDULE - Money Market Funds March 31, 2016 Grand Total Money Market Funds 1 $1,440,856.12 1 $309.03 Updated: 411112016 Current Market. Value YTD Interest Wells Faro 1 Wells Fargo Government Money Market Fund 1 $1,175,597.471 $81.15 4M I 4M 1,892.52 - 4M PLUS I 4M Plus 3,101.767F 0.91 Premier Bank I I Premier Bank Money Market 1 260,264.371 226.97 Grand Total Money Market Funds 1 $1,440,856.12 1 $309.03 Updated: 411112016