The URL can be used to link to this page

Home My WebLink AboutWK - September 26, 20171685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 . WWW.ANDOVERMN.GOV City Council Workshop Tuesday, September 26, 2017 Conference Rooms A & B 1. Call to Order -5:00 p.m. 2. Community Bus Tour - Departing at 5:00 p.m. — Administration Anticipated return to City Hall — 7:00 p.m. 3. Discuss Winslow Cove Preliminary Plat, Roadway Connections & Park Dedication/17-39 - Engineering 4. 2017 CIP Progress Update & 2018-2022 CIP Discussions - Administration 5. 2018 Special Revenue, Debt Service, Capital Projects, Enterprise & Internal Service Funds Budget Distribution & Discussion—Administration 6. 2017 Budget Progress Reports -Administration 7. 2017 City Investments Review - Administration 8. Other Business 9. Adjournment 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: Mayor and Council Members CC: Jim Dickinson, City Administrat FROM: David D. Berkowitz, Director of Pu c Works/City Engineer SUBJECT: Community Bus Tour DATE: September 26, 2017 INTRODUCTION Annual Community Bus Tour will begin at 6:00 pm. 2017 and upcoming 2018 projects will be reviewed and discussed on the tour. Respectfully submitted, (Zlv Q. It . David D. Berkowitz, P.E. 0 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 . (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: Mayor and Council Members CC: Jim Dickinson, City Administrator FROM: David D. Berkowitz, Director of P Works/City Engineer SUBJECT: Discuss Winslow Cove Preliminary Plat, Roadway Connections & Park Dedication/17-39 - Engineering DATE: September 26, 2017 INTRODUCTION The City Council is requested to discuss a roadway connection from Wintergreen Street in Sophie's South to Winslow Cove and possible Park Land Dedication south of Sophie's South Park. DISCUSSION Staff is requesting direction from the Council on possible road connection and possible park expansion for the proposed development of Winslow Cove which is located south of Sophie's South. As staff reviews the preliminary plat these two items are important to have direction before this goes before the Planning and Zoning Commission and before the City Council for formal approval. Detail will be presented and discussed at the Workshop meeting. ACTION The City Council is requested to provide staff with direction on how to proceed with the items described. Respectfully submitted, (D. -z D-. David D. Berkowitz, P.E. 1 -.•, ,NDOVE 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 . (763) 755-5100 FAX (763) 755-8923 . WWW.ANDOVERMN.GOV TO: FROM: SUBJECT: DATE: Mayor and Councilmembers Jim Dickinson, City Administrator 2017 CIP Progress Update & 2018-2022 CIP Discussions September 26, 2017 INTRODUCTION Late March, Administration/Finance distributed baseline worksheets to Department Heads for the 2018-2022 CIP kick-off. Subsequent discussion has centered on the 2018-2022 CIP development, the need of other committees (Vehicle/Equipment Purchasing & Facility Management Committees) and commissions (Parks and Recreation & Community Center Advisory) to complete the work necessary to assemble a "draft" proposed 2018-2022 CIP. DISCUSSION Throughout the summer a significant amount of time has been spent on evaluating utility infrastructure, transportation improvements, building maintenance, equipment and park and recreation needs. Each of those items is integrated into a detailed fund balance analysis of funding sources that will be part of the proposed 2018-2022 CIP. Attached is a spreadsheet identifying the 2017 Capital Improvement Plan Proiects by Department and the progress on each proiect that will be reviewed with the Council. Staff would also like the Council to review the "draft" projects listing to confirm that the Council's priorities are being met. It is anticipated that an interactive review will be done at the workshop meeting, but a focus will be on outstanding questions on 2018 proposed projects where staff needs Council direction (such as State Aid Routes Reconstruction, the Crack Seal/Seal Coat Program and Street Overlay improvements). The current schedule indicates the 2018-2022 CIP is to be adopted by the Council in October. ACTION REQUESTED The Council is requested to review the attachments, receive a brief presentation, and provide direction to staff on Council priorities for the 2018-2022 CIP. Ibmitted, CITY OF ANDOVER 2017 Capital Improvement Plan Projects By Department - Use of Funds Community Center Exterior Painting $ 6,000 in process ACC/YMCA Expansion 75,000 Community Survey / RFP over summer 81,000 Emergency Management Emergency Operations Center Improvement 40,000 under construction Replacement - Emergency Sirens 45,000 in process 85,000 Engineering New Development Projects 160,000 ongoing Pedestrian Trail Maintenance 50,000 trail open, punchlist items remain New Pedestrian Trail and Sidewalk Segments 565,000 In process, Crosstown rolled to 2018 Pedestrian Trail Reconstruction 60,000 trail open, punchlist items remain Pedestrian Curb Ramp Replacements 15,000 rolled to 2018 LED Crosswalk Warning System 21,000 ACHD added a yellow flashing beacon Fire 871,000 Facility Management Annual Parking Lot Maintenance 90,000 done Replacement - Carpetlrile 10,000 ongoing Replacement - Security Management System 100,000 August/September Public Works Relocation / Expansion 50,000 Architect has been approved HD Upgrade - City Hall Council Chambers 60,000 late summer / early fall 310,000 Fire Replacement -Turnout Gear 20,000 purchased Replacement - Extrication (Rescue) Equipment 80,000 purchased 100,000 Park & Recreation - Operations Replace/Repair Play Structures - Various Parks 50,000 installed Replace/Repair Major Park Projects - Various Parks 25,000 ongoing Replacement - One Ton Crew Cab Truck 50,000 purchased New - Trail Machine 150,000 purchased 275,000 Park & Recreation - Projects Annual Miscellaneous Projects 15,000 ongoing Fox Meadows Park - Renovation 457,300 concrete & punchlist items remain Pine Hills North - Phase II 100,000 no funding for building Irrigation Projects - Small Parks 20,000 Bunker Hills & Wild Iris out for quotes Nordeen's Park Basketball Court 7,500 complete 599,800 Planning & Zoning Replacement - Planning Vehicle #7 30,000 purchased Sanitary Sewer Sanitary Sewer Extensions 105,000 dependent on development Replacement - Jet/Vac Truck #99 460,000 purchased Lift Station #4 Upgrade 50,000 working w/ consultant $ 615,000 CITY OF ANDOVER 2017 Capital Improvement Plan Projects By Department - Use of Funds Storm Sewer Storm Sewer Improvements $ 55,000 ongoing Street Signs Sign Design Software and Plotter 10,000 purchased Streets / Highways Annual Street Seal Coat Project 725,000 complete Annual Street Crack Seal Project 160,000 done Annual Pavement Markings 42,000 complete Annual Curb Replacement 50,000 not this year Municipal State Aid Routes / New & Reconstruct 1,300,000 complete - being assessed Annual Street Reconstruction 1,236,000 complete - being assessed Gravel Road Improvement 15,000 done Replacement - One Ton Truck w/ Plow #134 80,000 purchased New One Ton Truck w/ Regular box, lift 55,000 purchased New - Bobcat Paver 20,000 purchased 3,683,000 Water Rehabilitation of Wells 50,000 not this year Replacement - Dodge Dakota #95 30,000 purchased 80,000 Grand Total $ 6,794,800 City of Andover, MN Capital Plan 2018 thru 2022 PROJECTS & FUNDING SOURCES BY DEPARTMENT Department Project# Priority 2018 2019 2020 2021 2022 Total Building Replacement- Small Extended Cab Pick Up #8 19-02300-01 1 35,000 35,000 Equipment Bond 35,000 35,000 Building Total 35,000 35,000 Central Equipment 200,000 6,725,000 Replacement - Service Truck#371 19-08800-01 2 45,000 45,000 Equipment Bond 45,000 45,000 Central Equipment Total 45,000 45,000 Community Center ACCNMCA Expansion 18-04000-01 2 200,000 6,725,000 6,925,000 G.O. Bond 200,000 6,725,000 6,925,000 Replacement -Carpeting 18-04000-02 1 12,000 12,000 24,000 Comm Ctr Operations 12,000 12,000 24,000 New- Inflatables 18-04400-01 1 5,000 5,000 Comm Ctr Operations 5,000 5,000 Replacement- Pickleball lnserlslNet System 18-44400-02 1 5,000 5,000 Comm Ctr Operations 5,000 5,000 Replacement- All Community Center Doors 19-04000-01 1 75,000 75,000 Comm Ctr Operations 75,000 75,000 Replacement - Skate Sharpener 19-04200-01 1 8,000 8,000 Comm Ctr Operations 8,000 8,000 Refacing Rink Boards 1944300-01 1 25,000 25,000 Comm Ctr Operations 25,000 25,000 Repaint Ice Arena ceiling 19-44300-02 1 25,000 25,000 Comm CU Operations 25,000 25,000 Replacement- Ice Arena Refrigeration Replacement 19-04300-03 1 1,000,000 1,000,000 G.O. Bond 1,000,000 1,000,000 Replacement - Heat Exchangers-Munters Unit 19-04300-04 1 15,000 15,000 Comm Ctr Operations 15,000 15,000 Replacement- Zamboni Battery Pack 19-04300-05 1 14,000 14,000 Comm Ctr Operations 14,000 14,000 Replacement - Munters Desiccant Wheel 1944300-06 1 36,000 36,000 Comm Ctr Operations 36,000 36,000 Replacement - Scissor Lit 20-04000-01 1 15,000 15,000 Equipment Bond 15,000 15,000 Replacement - Lobby Furniture 20-04000-02 1 15,000 15,000 Comm Ctr Operations 15,000 15,000 Replacement - Roof 20-04000-03 1 500,000 500,000 G.O. Bond 500,000 500,000 Replacement- Kaivac Cleaning System 2044000-04 1 10,000 10,000 Department Project # Priority 2018 2019 2020 2021 2022 Total Comm Ctr Operations 117,000 120,000 10,000 125,000 125,000 10,000 Replacement- Camera/Security System 20-04000-05 1 43,000 45,000 12,000 55,000 60,000 12,000 Comm Ctr Operations 18-01600-02 1 55,000 60,000 12,000 70,000 75,000 12,000 Replacement- Zamboni Room Water Heater 20-04300-01 1 55,000 60,000 25,000 70,000 75,000 25,000 Comm Ctr Operations 18-01600-03 1 587,000 25,000 372,000 25,000 Replacement - Floor Scrubber 21-04000-01 1 29000 15,000 15,000 Comm Cfr Operations 587,000 681,000 15,000 15,000 Repaint Field House Ceiling 21-44200-01 1 80,000 100,000 120,000 25,000 160,000 25,000 Comm Ctr Operations 80,000 100,000 120,000 25,000 160,000 25,000 Replacement -Electric Edger 21-04300-02 1 16,000 17,000 18,000 8,000 20,000 8,000 Comm Ctr Operations 16,000 17,000 18,000 8,000 20,000 8,000 Replacement- Evaporative Condenser 21-04300-03 1 33,500 60,000 60,000 Comm Ctr Operations 33,500 60,000 60,000 Replacement -Field House Floor 21-04400-01 1 40,000 150,000 150,000 Comm Ctr Operations 40,000 150,000 150,000 Replacement - Zamboni 2244300-01 1 150,000 150,000 Comm Ctr Operations 150,000 150,000 Replacement- Ice Rink Hard Dividers 2244300-02 1 931,500 342,000 1,353,000 781,000 8,000 8,000 Comm Ctr Operations 8,000 8,000 Community Center Total 18-01900-01 1 222,000 7,923,000 589,000 258,000 158,000 9,150,000 Capital Equipment Reserve 130,000 35,000 37,000 39,000 40,000 281,000 Emergency Management Emergency Operations Center Improvement 18-42400-01 1 18,000 7,500 10,000 10,000 45,500 Capital Equipment Reserve 18,000 7,500 10,000 10,000 45,500 Replacement- Emergency Sirens 1842400-02 1 45,000 45,000 45,000 135,000 Capital Equipment Reserve 45,000 45,000 45,000 135,000 Emergency Management Total 63,000 52,500 55,000 10,000 180,500 Engineering New Development Projects 18-01600-01 1 160,000 165,000 175,000 180,000 185,000 865,000 Sewer Trunk Fund 117,000 120,000 125,000 125,000 125,000 611,000 Water Trunk Fund 43,000 45,000 50,000 55,000 60,000 253,000 Pedestrian Trail Maintenance 18-01600-02 1 55,000 60,000 65,000 70,000 75,000 325,000 Road B Bridge Funds 55,000 60,000 65,000 70,000 75,000 325,000 New Pedestrian Trail and Sidewalk Segments 18-01600-03 1 587,000 935,000 372,000 1,894,000 Grant 29000 29000 Trail Funds 587,000 681,000 372,000 1,640,000 Pedestrian Trail Reconstruction 18-41600-04 1 80,000 100,000 120,000 140,000 160,000 600,000 Road B Bridge Funds 80,000 100,000 120,000 140,000 160,000 600,000 Pedestrian Curb Ramp Replacements 1841600-05 1 16,000 17,000 18,000 19,000 20,000 90,000 Road B Bridge Funds 16,000 17,000 18,000 19,000 20,000 90,000 Replacement - Data Collector/TotalStation 18-01600-06 1 33,500 33,500 Road 8 Bridge Funds 33,500 33,500 Replacement - Pick Up Truck#6 2041600-01 2 40,000 40,000 Equipment Bond 40,000 40,000 Replacement -314 Ton Truck#12 22-41600-01 2 50,000 50,000 Equipment Bond 50,000 50,000 Engineering Total 931,500 342,000 1,353,000 781,000 490,000 3,897,500 Facility Management Annual Parking Lot Maintenance 18-01900-01 1 130,000 35,000 37,000 39,000 40,000 281,000 Capital Equipment Reserve 130,000 35,000 37,000 39,000 40,000 281,000 Department Project# Priority 2018 2019 2020 2021 2022 Total Public Works Relocation/Expansion 1841900-02 1 450,000 8,500,000 Replacement - Turnout Gear 8,950,000 G.O. Bond 20,000 Replacement - Grass #31 450,000 8,500,000 20,000 8,950,000 Replacement - Carpet/Tile 1841900-03 1 10,000 19-42200-02 10,000 10,000 30,000 Capital Equipment Reserve 20-02200-01 Equipment Bond 10,000 Replacement -800 MHz radios 10,000 10,000 30,000 Building A -Seal Floor 1941900-01 1 Equipment Bond 25,000 Replacement- Thermal Imaging Cameras 25,000 Capital Equipment Reserve Replacement- Grass Utility Vehicle (UTV) #4813 21-42200-01 25,000 25,000 Memorial - Veterans Memorial 1941900-03 1 Replacement -Engine 21#4884 10,000 Equipment Bond 10,000 Capital Equipment Reserve 22-02200-01 Equipment Bond 10,000 1 10,000 New- Diesel Exhaust Capturing System 19-41900-04 1 130,000 45,000 45,000 Capital Equipment Reserve 130,000 1 45,000 35,000 45,000 Surface Seal all Brick Structures 20-41900-01 1 35,000 85,000 85,000 Capital Equipment Reserve 1 85,000 48,000 48,000 Comm Ctr Operations 85,000 1$000 12,000 Water Fund 36,000 36,000 25.000 25.000 Facility Management Total Finance Financial/ Payroll System Upgrade/Replacement 19-01400-01 1 Capital Equipment Reserve Finance Total 200,000 Fire Replacement - Turnout Gear 18-02200-01 General Fund 20,000 Replacement - Grass #31 18-42200-02 Capital Equipment Reserve 20,000 Replacement - Tanker #11 19-42200-01 Equipment Bond 20,000 New- But lex Fire Extinguisher Prop 19-42200-02 Equipment Bond Replacement- SCBA Compressors 20-02200-01 Equipment Bond 85,000 Replacement -800 MHz radios 20-42200-02 Capital Equipment Reserve Replacement - Grass #21 20-42200-03 Equipment Bond Replacement- Thermal Imaging Cameras 20-02200-04 Equipment Bond Replacement- Grass Utility Vehicle (UTV) #4813 21-42200-01 Equipment Bond Replacement -1999 GMC Sonoma Truck (U-10) #4810 2142200-02 Equipment Bond Replacement -Engine 21#4884 21-42200-03 Equipment Bond Replacement -Engine 31#4800 22-02200-01 Equipment Bond 590,000 8,615,000 132,000 39,000 50,000 9,426,000 200,000 200,000 200,000 200,000 Fire Total Information Technology Smartboard Addition 18-01420-01 1 Capital Equipment Reserve 105,000 428,000 306,000 595,000 505,000 1,939,000 12,000 12,000 12000 12,000 200,000 200,000 1 20,000 20,000 20,000 20,000 20,000 100,000 20,000 20,000 20,000 20,000 20,000 100,000 1 85,000 85,000 85,000 85,000 1 400,000 400,000 400,000 400,000 2 81000 8,000 8,000 8,000 1 130,000 130,000 130,000 130,000 1 35,000 35,000 35,000 105,000 35,000 35,000 35,000 105,000 1 85,000 85,000 85,000 85,000 1 36,000 36,000 36,000 36,000 1 45,000 45,000 45,000 45,000 2 45,000 45,000 45,000 45,000 1 450,000 450,000 450,000 450,000 1 450,000 450,000 450,000 450,000 Fire Total Information Technology Smartboard Addition 18-01420-01 1 Capital Equipment Reserve 105,000 428,000 306,000 595,000 505,000 1,939,000 12,000 12,000 12000 12,000 Department Project# Priority 2018 2019 2020 2021 2022 Total Shoretel Switch Replacement 18-01420-02 1 10,000 10,000 General Fund 10,000 10,000 Information Technology Total 22,000 22,000 Park & Rec - Operations Replace/Repair Play Stmdures- Various Parks 18-05000-01 1 50,000 50,000 50,000 50,000 50,000 250,000 General Fund 50,000 50,000 50,000 50,000 50,000 250,000 Replace/Repair Major Park Projects- Various Parks 1845000-02 1 35,000 35,000 35,000 35,000 35,000 175,000 General Fund 35,000 35,000 35,000 35,000 35,000 175,000 Replacement- One Ton Truck w/ Plow #599 1845000-03 1 80,000 80,000 Capital Equipment Reserve 80,000 80,000 New- Brush cutter 18-45000-04 1 15,000 15,000 CapilalEquipmenf Reserve 15,000 15,000 Replacement - Bobcat Track Loader #610 1845000-05 1 60,000 60,000 Capital Equipment Reserve 60,000 60,000 Replacement- Small Extended Cab Truck #76 1845000-06 1 55,000 55,000 Capital Equipment Reserve 55,000 55,000 Replacement - Water Tanker #161 2045000-01 1 175,000 175,000 Equipment Bond 175,000 175,000 Replacement-Trailer #T555 20-05000-02 1 18,000 18,000 Equipment Bond 18,000 18,000 Replacement- Cushman Field Dresser#547 2045000-03 1 27,000 27,000 Equipment Bond 27,000 27,000 Replacement- Large Capacity Mower#11-582 2045000-04 1 110,000 110,000 Equipment Bond 110,000 110,000 Park & Rec - Operations Total 295,000 85,000 415,000 85,000 85,000 965,000 Park & Rec - Projects Annual Miscellaneous Park Projects 1845001-01 1 15,000 15,000 15,000 15,000 15,000 75,000 Park Dedication Funds 15,000 15,000 15,000 15,000 15,000 75,000 Irrigation Projects -Small Parks 1845001-02 1 25,000 20,000 45,000 Park Dedication Funds 25,000 20,000 45,000 Pine Hills North - Phase II 2045001-02 1 400,000 400,000 Capital Equipment Reserve 280,000 280,000 Park Dedication Funds 120,000 120,000 Park & Rec - Projects Total 40,000 35,000 415,000 15,000 15,000 520,000 Sanitary Sewer Lift Station Improvements 1848200-02 1 230,000 650,000 880,000 Assessments 170,000 170,000 Sewer Trunk Fund 60,000 650,000 710,000 Replacement- One Ton Utility Truck #69 1848200-03 1 150,000 150,000 Sanitary Sewer Fund 150,000 150,000 Sanitary Sewer Total 380,000 650,000 1,030,000 Storm Sewer Storm Sewer Improvements 1848300-01 1 60,000 60,000 62,000 65,000 68,000 315,000 Storm Sewer Fund 60,000 60,000 62,000 65,000 68,000 315,000 Replacement - Tymco Street Sweeper #172 1848300-02 1 235,000 235,000 Capital Equipment Reserve 235,000 235,000 Department Project# Priority 2018 2019 2020 2021 2022 Total Replacement- Elgin Street Sweeper#169 20-48300-01 1 250,000 250,000 Equipment Bond 250,000 250,000 Storm Sewer Total 295,000 60,000 312,000 65,000 68,000 800,000 Streets / Highways Annual Street Seal Coat Project 18-03100-01 1 400,000 260,000 275,000 285,000 300,000 1,520,000 Road B Bridge Funds 400,000 260,000 275,000 285,000 300,000 1,520,000 Annual Street Crack Seal Project 1843100-02 1 150,000 155,000 160,000 165,000 170,000 800,000 Construction Seal Coat Fund 10,000 12,000 14,000 16,000 18,000 70,000 Read &Bridge Funds 140,000 143,000 146,000 149,000 152,000 730,000 Annual Pavement Markings 18-43100-03 1 40,000 42,000 44,000 46,000 48,000 220,000 Road& Bridge Funds 40,000 42,000 44,000 46,000 48,000 228000 Annual Curb Replacement 18-43100-04 1 52,000 54,000 56,000 58,000 60,000 280,000 Road& Bridge Funds 51,000 54,000 56,000 58,000 60,000 280,000 Municipal State Aid Routes / New &Reconstruct 18-43100-05 1 900,000 2,050,000 410,000 290,000 1,080,000 4,730,000 Assessments 75,500 160,500 17,500 15,000 133,000 401,500 Municipal State Aid Funds 824,500 1,889,500 392,500 275,000 947,000 4,328,500 Annual Street Reconstruction 18-43100-06 1 667,000 1,163,000 1,202,000 1,306,000 1,560,000 5,898,000 Assessments 167,000 291,000 301,000 327,000 390,000 1,476,000 Road& Bridge Funds 500,000 872,000 901,000 979,000 1,170,000 4421,000 Street Overlays 1843100-07 1 350,000 500,000 850,000 Assessments 87,500 125,000 212,500 Road& Bridge Funds 262,500 375,000 637,500 Intersection Upgrades 1843100-08 1 285,000 2,075,000 2,360,000 Grant 1,600,000 1,600,000 Municipal State Aid Funds 285,000 475,000 760,000 Gravel Road Improvements 18-43100-09 1 20,000 20,000 21,000 21,000 22,000 104,000 Road&Bridge Funds 20,000 20,000 21,000 21,000 22,000 104000 Replacement- Lazar Line Painter 18-43100-10 1 8,500 8,500 Capital Equipment Reserve 8,500 8,500 Replacement - Hot Patch box #08-180 1843100-11 1 75,000 75,000 Capital Equipment Raserve 75,000 75,000 Pedestrian Tunnel Under Crosstown Blvd. 1943100-01 1 650,000 650,000 G.O. Bond 650,000 650,000 Replacement-Bobcat 5185#120 2043100-01 1 60,000 60,000 Equipment Bond 60,000 60,000 Replacement -One Ton Truck w/Plow #133 2043100-02 1 80,000 80,000 Equipment Bond 80,000 80,000 Replacement-Backhoe Loader#80 20-43100-03 1 100,000 100,000 Equipment Bond 100,000 100,000 Replacement -Front End Loader#124 20-43100-04 1 250,000 250,000 Equipment Bond 250,000 250,000 New- Dump Truck wl snow removal 2143100-01 1 220,000 220,000 Equipment Bond 220,000 220,000 Replacement- Dump Truck wl Snow removal#198 22-03100-01 1 230,000 230,000 Equipment Bond 230,000 230,000 Replacement- Aerial bucket truck #00-139 22-03100-02 1 200,000 200,000 Equipment Bond 200,000 200,000 Streets / Highways Total 2,662,500 4,679,000 3,158,000 4,466,000 3,670,000 18,635,500 Water Rehabilitation of Wells 18-48100-01 1 50,000 50,000 50,000 50,000 50,000 250,000 Water Fund 50,000 50,000 50,000 50,000 50,000 250,000 Department Project# Priority 2018 2019 2020 2021 2022 Total Replacement- 3/4 Ton Utility Truck #66 18-08100-02 1 60,000 60,000 Water Fund 60,000 60,000 Replacement - Side by Side UTV #70 18-08100-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 Main Improvements 18-08100-04 1 664,000 743,000 1,407,000 Assessments 520,000 743,000 1,263,000 Water Trunk Fund 144,000 144,000 New- Valve Maintenance Trailer 19-08100-01 1 70,000 70,000 Water Fund 70,000 70,000 Water Meter Reading System AMI/AMR 2048100-01 2 1,200,000 1,200,000 Water Fund 1,200,000 11200,000 Recondition& Paint Water Tower#2 2048100-02 1 1,000,000 1,000,000 Water Trunk Fund 1,000,000 1,000,000 Water Total 822,000 863,000 2,250,000 50,000 50,000 4,035,000 GRAND TOTAL 6,428,000 23,362,500 9,635,000 6,364,000 5,091,000 50,880,500 NDO: 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 . (763) 755-5100 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV TO: FROM: SUBJECT: DATE Mayor and Councilmembers Jim Dickinson, City Administrator 2018 Special Revenue, Debt Service, Capital Projects, Enterprise & Internal Service Funds Budget Distribution & Discussion September 26, 2017 The Council has had a number of reviews of the 2018 Proposed General Fund Budget that will be supported by the 2018 Tax Levy. The Council did adopt at the September 19th regular Council meeting a Preliminary 2018 General Fund Levy & Budget. The Preliminary 2018 Levy & 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. The 2018 Proposed Property Tax Levy is estimated to reduce the current City tax rate by 6% but will generate additional tax revenue through growth identified in the City's tax base, 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. This agenda item will focus on all the other City fund budgets. Other Funds: The attachments to this staff report are draft budgets for all the other funds outside of the General Fund within the City. The attachments are grouped by fund types' bolded below: For the most part these budgets are self-explanatory, except for the Community Center, Economic Development Authority (EDA) and Entemrise Funds. The Community Center Fund will be at the workshop, the EDA Fund detail will be presented to the EDA at a future meeting and the Enterprise Funds are driven by a rate analysis that is part of the Capital Improvement Plan (CIP) Development process. Administration will provide a brief Presentation of the attached budgets and answer anv questions the Council may have. The Special Revenue Funds (pgs. 1 — 20) are established to justify and account for revenue sources to finance particular functions or projects. Revenues for these funds come from a variety of sources (taxes, fees, gifts, grants or other contributions). Expenditures from these funds are normally restricted by statute, local ordinance or grant agreement. Also the funds may be used for either operations or capital outlay as legal restrictions mandate. Administration will be discussing with the Council the following funds: 1. Economic Development Authority Fund 2. Community Center 3. Charitable Gambling Fund The Debt Service Funds (pgs. 21 — 34) account for the accumulation of resources for, and the payment of general long-term principal and interest. Repayment of the debt through principal and interest payments to bond holders is backed by the full faith and credit of the City of Andover. Administration will briefly discussing with the Council how the overall debt service spreadsheet impacts the individual Debt Service Funds and the proposed 2018 Debt Service Levy. The Capital Project Funds (pgs. 35 — 62) are used to account for the acquisition or construction of major capital facilities or equipment financed by a variety of funding sources, including tax levy, debt, special assessments, grants or other governmental fund resources. Administration be discussing the Trail & Transportation fund with the Council, all other funds will not be discussed in detail. These funds are the primary funds that facilitate the annual Capital Improvement Plan (CIP). The Enterprise Funds (pgs. 63 — 70) are dependent on multiple factors such as community growth and demand for and usage of the service. The Enterprise funds are generally in line and step with the rate analysis done for these funds as part of the CIP development and review. Administration will discuss how these funds are impacted by rate analysis that facilitates the Enterprise Funds' annual Capital Improvement Plan (CIP). Internal Service Funds (pgs. 71 — 76) are used to account for services that are provided to other City Departments, or to other governments, on a cost reimbursement basis. Administration will briefly discuss with the Council the following funds: 1. Central Equipment Fund 2. Risk Management Fund ACTION REQUESTED The Council is requested to review the staff report, attachments, receive a presentation, and provide direction to staff. )miffed, CITY OF ANDOVER, MINNESOTA 2018 ANNUAL BUDGET DEFINITION Special revenue funds are established to justify revenue sources to finance particular functions or projects. Revenue for these funds can come from a variety of sources, such as taxes, fees, gifts and grants or contributions from other governmental entities. Expenditures from these funds are normally restricted by statute, local ordinance, or grant agreements. The funds may be used for either operations or capital outlay as legal restrictions mandate. 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: Fund Balance, December 31 $ 669,442 $ 736,826 $ 736,826 $ 705,492 40,106 701,722 10,949 830,773 1,583,550 1,583,550 2,252,992 488,401 84,081 201,533 387,492 47,859 1,209,366 306,800 1,516,166 $ 736,826 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 $ 617,406 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 $ 705,492 40,000 37,500 693,900 6,050 793,068 1,570,518 1,570,518 2,276,010 552,623 87,020 233,294 462,529 22,000 1,357,466 305,300 1,662,766 $ 613,244 Change in Fund Balance $ 67,384 $ (119,420) $ (31,334) $ (92,248) 10% -16% -4% -13% Actual 'Adopted Estimate Adopted bescn titin` - 2016 2017 201 T 2018' 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: Fund Balance, December 31 $ 669,442 $ 736,826 $ 736,826 $ 705,492 40,106 701,722 10,949 830,773 1,583,550 1,583,550 2,252,992 488,401 84,081 201,533 387,492 47,859 1,209,366 306,800 1,516,166 $ 736,826 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 $ 617,406 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 $ 705,492 40,000 37,500 693,900 6,050 793,068 1,570,518 1,570,518 2,276,010 552,623 87,020 233,294 462,529 22,000 1,357,466 305,300 1,662,766 $ 613,244 Change in Fund Balance $ 67,384 $ (119,420) $ (31,334) $ (92,248) 10% -16% -4% -13% City of Andover Special Revenue Funds Economic Development Authority Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues 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 Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 334,451 $ 312,000 $ 312,000 $ 263,922 9,181 10,000 8,000 8,000 3,860 3,000 3,000 3,000 1,478 - - 14,519 13,000 11,000 11,000 14,519 348,970 17,740 3,419 7,718 8,093 36,970 36,970 $ 312,000 $ (22,451) -7% 13,000 325,000 14,578 18,900 79,000 13,850 126,328 11,000 323,000 14,578 13,900 19,000 11,600 59,078 126,328 59,078 $ 198,672 $ (113,328) -36% $ 263,922 $ (48,078) -15% 11,000 274,922 14,220 18,900 63,200 13,850 110,170 110,170 $ 164,752 $ (99,170) -38% 3 Actual Adopfe'd Estimate Adopted lUescri tionr` 20'16. 2017 2017? '2018' Fund Balance, January 1 Revenues 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 Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 334,451 $ 312,000 $ 312,000 $ 263,922 9,181 10,000 8,000 8,000 3,860 3,000 3,000 3,000 1,478 - - 14,519 13,000 11,000 11,000 14,519 348,970 17,740 3,419 7,718 8,093 36,970 36,970 $ 312,000 $ (22,451) -7% 13,000 325,000 14,578 18,900 79,000 13,850 126,328 11,000 323,000 14,578 13,900 19,000 11,600 59,078 126,328 59,078 $ 198,672 $ (113,328) -36% $ 263,922 $ (48,078) -15% 11,000 274,922 14,220 18,900 63,200 13,850 110,170 110,170 $ 164,752 $ (99,170) -38% 3 Fund: Economic Development Authority Activity Type/Code: Special Revenue Expenditure Highlights 2017 & 2018 includes funding for monument entrance signs. EDA Budget provides for ongoing maintenance around the Andover Station Development area. Department Head: City Administrator General Activity Description To provide for the quality development of commercial and industrial properties to ensure a strong, viable and diversified tax base. Process Used Promotion and expansion of the commercial and industrial tax base through the development and redevelopment of land. The EDA is the primary authority involved in managing the City's four Tax Increment Financing (TIF) Districts. The EDA monitors and initiates the activities within the TIF Districts to reach the goals of the TIF plans. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Special Revenue Funds Community Development Block Grant Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues Intergovernmental Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Other Uses T f O 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 rans ers ut - - - Total Expenditures and Other Uses: 25,000 25,000 Fund Balance, December 31 $ $ - $ $ - Change in Fund Balance $ $ $ $ n/a n/a n/a n/a Actual, = Adopted= Estimate . Adopted D'escri tion 2016 2017 2017; 2018, Fund Balance, January 1 Revenues Intergovernmental Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Other Uses T f O 25,000 25,000 25,000 25,000 25,000 25,000 25,000 25,000 rans ers ut - - - Total Expenditures and Other Uses: 25,000 25,000 Fund Balance, December 31 $ $ - $ $ - Change in Fund Balance $ $ $ $ n/a n/a n/a n/a Fund: Community Development Block Grant Activity Type/Code: Special Revenue Expenditure Highlights This was a new fund created in 2004 to track the Community Development Block Grant (CDBG) Rental Rehab program. In 2018, additional grant monies will be applied for to study areas that have access to city water but are not currently hooked up. Department Head: Community Development Dir. General Activity Description The Rental Rehab program provides low-interest loans for the rehabilitation of rental housing units. This fund accounts for the loans disbursed, as well as the payments received. In 2008, a housing rehab program was started. Due to the lack of interest, the rental rehab program was terminated in 2012. Process Used Rehab Grants are received from CDBG and disbursed to qualified applicants. As payments come in, these funds create a revolving loan program and new loans are given out to qualified applicant's. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Special Revenue Funds Community Center Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Actual Adopted; Estimate Adopted ;Description". 2016 2017 ,- 201,7 2018 Fund Balance, January 1 $ 56,140 $ 136,459 $ 136,459 $ 177,287 Revenues 1,484,911 1,543,659 1,537,459 1,603,255 Charges for Services 649,726 632,200 646,000 647,900 Investment Income 2,190 - - - Miscellaneous 776,855 775,000 755,000 778,068 Total Revenues: 1,428,771 1,407,200 1,401,000 1,425,968 Other Sources Transfers In Total Revenues and Other Sources: 1,428,771 1,407,200 1,401,000 1,425,968 Total Available: 1,484,911 1,543,659 1,537,459 1,603,255 Expenditures Personal Services 451,332 481,368 481,368 517,860 Supplies and Materials 77,945 59,300 60,000 61,300 Purchased Services 106,381 89,000 70,000 92,500 Other Services and Charges 364,935 406,479 382,804 406,079 Capital Outlay 47,859 66,000 66,000 22,000 Total Expenditures: 1,048,452 1,102,147 1,060,172 1,099,739 Other Uses Transfers Out 300,000 300,000 300,000 300,000 Total Expenditures and Other Uses: 1,348,452 1,402,147 1,360,172 1,399,739 Fund Balance, December 31 $ 136,459 $ 141,512 $ 177,287 $ 203,516 Change in Fund Balance $ 80,319 $ 5,053 $ 40,828 $ 26,229 143% 4% 30% 15% 7 Fund: Community Center Activity Type/Code: Special Revenue Expenditure Highlights E3 2009 was the first year the YMCA made a full lease payment of $635,000. The transfer out is the difference between the tax levied for the Community Center debt service and the total annual debt service for the Community Center The capital outlay expenditure for 2017 is $60,000 to seal coat the parking lot and $6,000 for painting the entrances. 2018 includes carpet replacement ($12,000), inflatables ($5,000) and a pickleball net system ($5,000). Department Head: Recreation Facility Manager General Activity Description This fund accounts for the operations of the AndoverNMCA Community Center, particularly the ice arena, field house and concessions. The aquatic's portion of the Community Center is under the operations of the YMCA. Process Used The Community Center construction started in 2004 and was completed in the summer of 2005. The facility will be managed by the Recreational Facility Manager with oversight by a Community Center Advisory Board and the City Council. The YMCA is a long-term tenant and started making lease payments in 2008. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Special Revenue Funds Drainage and Mapping Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues Charges for Services Investment Income Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Supplies and Materials Purchased Services Other Services and Charges Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 144,771 $ 141,026 $ 141,026 $ 131,026 9,804 1,786 11,590 11,590 156,361 2,706 6,983 5,646 15,335 8,000 1,200 9,200 9,200 150.226 3,300 9,700 7,000 20,000 8,000 1,200 9,200 9,200 150,226 3,300 9,700 6,200 19,200 8,000 1,200 9,200 9,200 140,226 3,300 13,500 7,000 23,800 15,335 20,000 19,200 23,800 $ 141,026 $ (3;745) -3% $ 130,226 $ (10,800) -8% $ 131,026 $ (10,000) -7% $ 116,426 $ (14,600) -11% E Actual, Adopted? -Estimate Ado'tetl Description: 2016 2017"' r 2017- 2018 Fund Balance, January 1 Revenues Charges for Services Investment Income Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Supplies and Materials Purchased Services Other Services and Charges Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 144,771 $ 141,026 $ 141,026 $ 131,026 9,804 1,786 11,590 11,590 156,361 2,706 6,983 5,646 15,335 8,000 1,200 9,200 9,200 150.226 3,300 9,700 7,000 20,000 8,000 1,200 9,200 9,200 150,226 3,300 9,700 6,200 19,200 8,000 1,200 9,200 9,200 140,226 3,300 13,500 7,000 23,800 15,335 20,000 19,200 23,800 $ 141,026 $ (3;745) -3% $ 130,226 $ (10,800) -8% $ 131,026 $ (10,000) -7% $ 116,426 $ (14,600) -11% E Fund: Drainage and Mapping Activity Type/Code: Special Revenue Expenditure Hiehliehts 10 Minimal changes are planned for this fund as monies are set aside for future mapping needs. Department Head: Dir of PW / City Engineer General Activity Description The drainage and mapping activity provides the resource to maintain existing and develop new maps and mapping systems for the City. The City GIS is a key component in this mapping and data inventory task. Process Used Existing mapping systems and data are maintained manually in a reproducible format. The existing information is being converted to a digital format as is all new data which is developed for the City. All data will be accessible either manually or through a computerized application. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Special Revenue Funds Lower Rum River Watershed Fund Statement of Revenues, Expenditures and Changes in Fund Balance I Actual Adopted. Estimate Adopted Descri ption �= I 2016 2017 " 2017 _ 2018 Fund Balance, January 1 Revenues General Property Taxes Investment Income 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 Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 1,385 $ 9,845 $ 9,845 $ 26,760 40,106 40,000 40,000 40,000 (121) 100 100 100 39,985 40,100 40,100 40,100 39,985 41,370 9,288 11 22,061 165 31,525 40,100 49,945 9,720 520 12,780 200 23,220 40,100 49,945 9,720 520 12,780 165 23,185 40,100 66,860 10,049 520 12,894 200 23,663 31,525 23,220 23,185 23,663 $ 9,845 $ 8,460 611% $ 26,725 $ 16,880 171% $ 26,760 $ 16,915 172% $ 43,197 $ 16,437 61% 11 Fund: Lower Rum River Watershed Management Organization Activity Type/Code: Special Revenue Expenditure Highlights Minimal changes are planned for this fund. Department Head: Assistant City Engineer General Activity Description The function of the Lower Rum River Watershed Management Organization (LRRWMO) is to provide for: conservation of water and natural resources; prevention and alleviation of flood damage; and regulation of creeks, lakes, water courses and storm water conveyance systems for domestic, recreational and public use across municipal boundaries. To achieve this purpose, state law gives watershed management organizations several powers, among which are: 1. Responsibility for preserving natural retention areas. 2. Preparation of plans for water management. 3. Review of municipal water management plans and of projects directly affecting the water resources of the watershed. 4. Review of local land use in the absence of an approved municipal surface water management plan. 5. Collection of data. 6. Conducting of studies and investigations. 7. Construction of improvements, either in response to petition or on the initiative of the LRRWMO. 8. Levying of taxes and assessments for the financing of the previously mentioned activities and for general administration of the organization. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA 12 City of Andover Special Revenue Funds Forestry Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues Intergovernmental Investment Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Supplies and Materials Purchased Services Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: $ 6,831 Actual Adoptddi Estimate Adopted bescri tion 2016 2017 2017 2018 Fund Balance, January 1 Revenues Intergovernmental Investment Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Supplies and Materials Purchased Services Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: $ 6,831 $ 6,921 $ 6,921 $ 4,521 - 12,500 - 12,500 90 100 100 100 - 6,500 - - 90 19,100 100 12,600 100 90 19,100 12,600 6,921 26,021 7,021 17,121 - 6,500 2,500 2,500 12,500 - 12,500 19,000 2,500 15,000 Fund Balance, December 31 $ 6,921 Change in Fund Balance $ 90 1% 19,000 2,500 15,000 $ 7,021 $ 4,521 $ 2,121 $ 100 $ (2,400) $ (2,400) 1% -35% -53% 13 Fund: Forestry Activity Type/Code: Special Revenue Expenditure Highlights This fund tracks forestry -related grants with state agencies like the Minnesota Department of Natural Resources (DNR) and administers the bare root tree sale. A tree sale is proposed for 2018. Department Head: Dir of PW / City Engineer General Activity Description Forestry shall preserve Andover's forest resources and develop control plans to ensure preservation and/or restoration of these resources. Process Used The City utilizes the Natural Resources Technician to administer the annual bare root tree sale, coordinate various tree plantings with local organizations like the Eagle Scouts, and monitor preservation and disease tree management grants. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA 14 City of Andover Special Revenue Funds Right of Way Management / Utility Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues Charges for Services Investment Income 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 Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 47,909 $ 46,097 $ 46,097 $ 39,542 24,716 421 25,137 25,137 73,046 10,041 9,778 330 20,149 6,800 26,949 $ 46,097 $ (1,812) -4% 20,000 500 20,500 20,500 66,597 10,125 500 11,400 400 22,425 5,000 27,425 $ 39,172 $ (6,925) -15% =I 20,400 20,400 66,497 10,125 500 11,000 330 21,955 5,000 26,955 $ 39,542 $ (6,555) -14% 20,000 500 20,500 20,500 60,042 10,494 500 12,400 400 23,794 5,300 29,094 $ 30,948 $ (8,594) -22% 15 Actual Adopted; Estimate Adopted Description.___ 2016 2017 20171 .20118 , Fund Balance, January 1 Revenues Charges for Services Investment Income 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 Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 47,909 $ 46,097 $ 46,097 $ 39,542 24,716 421 25,137 25,137 73,046 10,041 9,778 330 20,149 6,800 26,949 $ 46,097 $ (1,812) -4% 20,000 500 20,500 20,500 66,597 10,125 500 11,400 400 22,425 5,000 27,425 $ 39,172 $ (6,925) -15% =I 20,400 20,400 66,497 10,125 500 11,000 330 21,955 5,000 26,955 $ 39,542 $ (6,555) -14% 20,000 500 20,500 20,500 60,042 10,494 500 12,400 400 23,794 5,300 29,094 $ 30,948 $ (8,594) -22% 15 16 Fund: Right of Way Management/Utility Activity Type/Code: Special Revenue Expenditure Hilzhlilzhts The transfer to the Road & Bridge Capital Projects is for the degredation of roadways associated with right-of-way permits. Department Head: Dir of PW / City Engineer General Activity Description The function of Right -of -Way Management is to provide for: management of the public rights-of-way and to recover the rights-of-way management costs; and to regulate the use of public rights-of-way by providers of telecommunication services, public utility services and the like, in a fair, efficient, competitively neutral and substantial uniform manner. Process Used To achieve this purpose, state law gives the City several powers to include requiring the following: 1. Require permits for work within the right-of-way. 2. Collect fees to recover costs associated with the permit including damages to the right-of-way. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Special Revenue Funds Charitable Gambling Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues Investment Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: $ 74,742 $ 79,530 $ 79,530 $ 56,986 960 'Actual Ad"opted: Estimate Adopted Descri tion 2016 201,7,2017: 53,400 201;8 Fund Balance, January 1 Revenues Investment Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: $ 74,742 $ 79,530 $ 79,530 $ 56,986 960 400 400 400 52,440 15,000 40,000 15,000 53,400 15,400 40,400 15,400 53,400 128,142 15,400 40,400 15,400 94,930 119,930 72,386 Expenditures Purchased Services 48,612 26,300 62,944 26,300 Other Uses Transfers Out - - - - Total Expenditures and Other Uses: 48,612 26,300 62,944 26,300 Fund Balance, December 31 $ 79,530 $ 68,630 $ 56,986 $ 46,086 Change in Fund Balance $ 4,788 $ (10,900) $ (22,544) $ (10,900) 6% -14% -28% -19% 17 Fund: Charitable Gambling Activity Type/Code: Special Revenue Expenditure Hi2hli2hts ff.] This fund was created to track the donations received from the Andover Hockey Association and Andover Football Association from their gambling activities. Funding is used towards the Alexandra House, Youth First, Family of Promise, teen programing, etc.. Funding for these expenditures are dependent upon donations. Department Head: Finance Director General Activity Description The licensed organizations are required to donate 10% of their net profits to the City. Process Used According to State Statute, all expenditures from this fund must be for police, fire and other emergency or public safety-related services, equipment, and and training, excluding pension obligations, or qualifying public service organizations. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Special Revenue Funds Construction Seal Coating Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues Charges for Services Investment Income Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Other Uses $ 3,213 Actual _` Adopted, Estimate ., Adopted Description . 2016 2017 1:.. 201:7' 2018: Fund Balance, January 1 Revenues Charges for Services Investment Income Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Other Uses $ 3,213 $ 4,948 $ 4,948 $ 5,448 Total Expenditures and Other Uses: 8,323 17,000 17,000 10,000 8,295 17,000 17,000 10,000 1,763 500 500 750 10,058 17,500 17,500 10,750 10,058 17,500 17,500 10,750 13,271 22,448 22,448 16,198 8,323 17,000 17,000 10,000 Transfers Out - - - - Total Expenditures and Other Uses: 8,323 17,000 17,000 10,000 Fund Balance, December 31 $ 4,948 $ 5,448 $ 5,448 $ 6,198 Change in Fund Balance $ 1,735 $ 500 $ 500 $ 750 54% 10% 10% 14% w Fund: Construction Seal Coating Activity Type/Code: Special Revenue Expenditure Hiehlights 20 The Construction Seal Coating Special Revenue Fund was established in 1996 and is utilized for the first application of crack seal and seal coat in new developments. Department Head: Dir of PW / City Engineer General Activity Description The Construction Seal Coating Special Revenue Fund accounts for contributions associated with land development to be used for the respective developments first application of crack seal and seal coat. Process Used The City has an annual crack seal and seal coat program. Currently the City is divided into nine zones and these developments are done within four years of being constructed. Crack sealing is completed one year prior to seal coating. This allows the crack sealing material to cure and minimize bleed through once seal coated. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA 21 CITY OF ANDOVER, MINNESOTA 2018 ANNUAL BUDGET DEFINITION` . , `' A debt service fund accounts for the accumulation of resources for, and the payment of general long-term principal and interest. Repayment of the debt through principal and interest payments to bond holders is backed by the full faith and credit of the government unit. City of Andover Debt Service Funds 2018 Budget - All Debt Service Funds Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources: Total Available: Expenditures Debt Service Principal Interest Other Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 $ 1,217,300 $ 1,317,487 $ 1,317,487 $ 951,895 2,099,582 (2,363) 2,097,219 311,417 2,408,636 3,625,936 1,770,000 444,144 1,325 2,215,469 92,980 2,308,449 $ 1,317,487 Change in Fund Balance $ 100,187 8% 1,610,047 1,610,047 300,000 1,910,047 3,227,534 1,800,000 418,419 2,000 2,220,419 48,819 2,269,238 $ 958,296 $ (359,191) -27% 1,610,047 (5,000) 1,605,047 300,000 1,905,047 3,222,534 1,800,000 418,419 1,375 2,219,794 50,845 2,270,639 $ 951,895 $ (365,592) -28% 1,599,087 1,599,087 300,000 1,899,087 2,850,982 1,416,000 385,555 2,000 1,803,555 1,803,555 $ 1,047,427 $ 95,532 10% 22 >Xt' V ,' AdopYedv Estim"afe Adopted D`escrn .. Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources: Total Available: Expenditures Debt Service Principal Interest Other Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 $ 1,217,300 $ 1,317,487 $ 1,317,487 $ 951,895 2,099,582 (2,363) 2,097,219 311,417 2,408,636 3,625,936 1,770,000 444,144 1,325 2,215,469 92,980 2,308,449 $ 1,317,487 Change in Fund Balance $ 100,187 8% 1,610,047 1,610,047 300,000 1,910,047 3,227,534 1,800,000 418,419 2,000 2,220,419 48,819 2,269,238 $ 958,296 $ (359,191) -27% 1,610,047 (5,000) 1,605,047 300,000 1,905,047 3,222,534 1,800,000 418,419 1,375 2,219,794 50,845 2,270,639 $ 951,895 $ (365,592) -28% 1,599,087 1,599,087 300,000 1,899,087 2,850,982 1,416,000 385,555 2,000 1,803,555 1,803,555 $ 1,047,427 $ 95,532 10% 22 City of Andover Debt Service Funds Certificates/Capital Notes - 2012A G.O. Equipment Certificate Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources: Total Available: Expenditures Debt Service Principal Interest Other Total Expenditures: Other Uses $ .506,434 $ 591,195 $ 591,195 $ 143,134 : Actual., _ Adopfeii "` Estimate Adbptetl Desch tion_. 2b16 2Q1T 20h.7 Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources: Total Available: Expenditures Debt Service Principal Interest Other Total Expenditures: Other Uses $ .506,434 $ 591,195 $ 591,195 $ 143,134 3,277 146,411 146,411 - - 652,845 591,195 591,195 50,000 535,000 535,000 11,200 5,350 5,350 450 500 - 61,650 540,850 540,350 Operating Transfers Out - 48,819 50,845 Total Expenditures and Other Uses: 61,650 589,669 591,195 Fund Balance, December 31 $ 591,195 $ 1,526 $ - $ Change in Fund Balance $ 84,761 $ (589,669) $ (591,195) $ 17% -100% -100% n/a 23 Fund: 3211 Cost Center: 2012A G.O. Equipment Certificates Department Head: Finance Director Activity Type/Code: Debt Service This fund will be closed in 2017. General Activity Description To account for the payment of principal and interest on long-term debt. Process Used The City issued $585,000 of Capital Notes in 2012 to facilitate the purchase of new equipment. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA 24 . City of Andover Debt Service Funds Certificates/Capital Notes - 2014 G.O. Equipment Certificate Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources: Total Available: Expenditures Debt Service Principal Interest Other Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 303,366 $ 317,509 $ 317,509 $ 333,469 295,986 1,507 297,493 297,493 600,859 260,000 23,350 283,350 295,260 295,260 295,260 612,769 260,000 18,800 500 279,300 295,260 295,260 295,260 612,769 260,000 18,800 500 279,300 294,945 294,945 294,945 628,414 265,000 13,550 500 279,050 283,350 279,300 279,300 279,050 $ 317,509 $ 14,143 5% $ 333,469 $ 15,960 5% $ 333,469 $ 15,960 5% $ 349,364 $ 15,895 5% 25 Actual..- . Estimate- Adopted` D'escn tion ,, 2016 .Al 7 Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources: Total Available: Expenditures Debt Service Principal Interest Other Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 303,366 $ 317,509 $ 317,509 $ 333,469 295,986 1,507 297,493 297,493 600,859 260,000 23,350 283,350 295,260 295,260 295,260 612,769 260,000 18,800 500 279,300 295,260 295,260 295,260 612,769 260,000 18,800 500 279,300 294,945 294,945 294,945 628,414 265,000 13,550 500 279,050 283,350 279,300 279,300 279,050 $ 317,509 $ 14,143 5% $ 333,469 $ 15,960 5% $ 333,469 $ 15,960 5% $ 349,364 $ 15,895 5% 25 26 Fund: 3212 Cost Center: 2014A G.O. Equipment Certificates Department Head: Finance Director Activity Type/Code: Debt Service Debt Service is scheduled as listed below: Year Amount Principal Interest 2018 $ 278,550 $ 265,000 $ 13,550 2019 278,200 270,000 8,200 2020 277,750 275,000 2,750 $ 834,500 $ 810,000 $ 24,500 General Activity Description To account for the payment of principal and interest on long-term debt. Process Used The City issued $1,355,000 of Capital Notes in 2014 to facilitate the purchase of equipment. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Debt Service Funds Certificates/Capital Notes - 2016 G.O. Equipment Certificate Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources: Total Available: Expenditures Debt Service Principal Interest Other Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ $ 5,022 $ 5,022 $ 147,671 m 9,386 9,468 9,468 152,529 152,529 152,529 157,551 152,529 152,529 152,529 157,551 143,310 143,310 143,310 290,981 - - - 126,000 4,446 9,880 9,880 8,683 - - - 500 4,446 9,880 9,880 135,183 4,446 $ 5,022 $ 5,022 n/a 9,880 $ 147,671 $ 142,649 2840% 9,880 $ 147,671 $ 142,649 2840% 135,183 $ 155,798 $ 8,127 6% 27 Actual = Adopted; Estimate. Adopted 201fi 20.17 201>7- 2018 Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources: Total Available: Expenditures Debt Service Principal Interest Other Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ $ 5,022 $ 5,022 $ 147,671 m 9,386 9,468 9,468 152,529 152,529 152,529 157,551 152,529 152,529 152,529 157,551 143,310 143,310 143,310 290,981 - - - 126,000 4,446 9,880 9,880 8,683 - - - 500 4,446 9,880 9,880 135,183 4,446 $ 5,022 $ 5,022 n/a 9,880 $ 147,671 $ 142,649 2840% 9,880 $ 147,671 $ 142,649 2840% 135,183 $ 155,798 $ 8,127 6% 27 M Fund: 3213 Cost Center: 2016A G.O. Equipment Certificates Department Head: Finance Director Activity Type/Code: Debt Service Debt Service is scheduled as listed below: Year Amount Principal Interest 2018 $ 134,683 $ 126,000 $ 8,683 2019 135,260 129,000 6,260 2020 134,791 131,000 3,791 2021 135,273 134,000 1,273 $ 540,007 $ 520,000 $ 20,007 General Activity Description To account for the payment of principal and interest on long-term debt. Process Used The City issued $520,000 of Capital Notes in 2016 to facilitate the purchase of equipment. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Debt Service Funds General Obligation Bonds - 2012B G.O. Capital Improvement Refunding Bonds Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources: Total Available: Expenditures Debt Service $ 76,564 $ $ $ 494,146 (3,030) - 491,116 491,116 - 567,680 Principal :Actual "' Adopted: Estimate - Adopted Descri` tion..- 2016 2017 2017 2018 , Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources: Total Available: Expenditures Debt Service $ 76,564 $ $ $ 494,146 (3,030) - 491,116 491,116 - 567,680 Principal 470,000 Interest 4,700 Other - Total Expenditures: 474,700 Other Uses Operating Transfers Out 92,980 Total Expenditures and Other Uses: 567,680 Fund Balance, December 31 $ - $ Change in Fund Balance $ (76,564) $ -100% n/a n/a n/a 29 Fund: 3303 Cost Center: 2012B G.O. Capital Improvement Refunding Bonds Activity Type/Code: DebtService This fund was closed in 2016. Kul Department Head: Finance Director General Activity Description To account for the payment of principal and interest on long-term debt. Process Used The City sold $3,890,000 of General Obligation Bonds in 2004 to finance the purchase of the Public Works Facility from the Andover Economic Development Authority and the construction of Fire Station #3. This issue will be used to refund the original issue sold in 2004. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Debt Service Funds General Obligation Bonds - 2012C G.O. Abatement Bonds Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources Total Available: Expenditures Debt Service Principal Interest Other Total Expenditures: Other Uses Operating Transfers Out Fund Balance, December 31 Change in Fund Balance $ 115,802 $ 172,284 $ 172,284 $ 227,546 979,038 (5,625) 973,413 300,000 1,273,413 1,389,215 845,000 371,506 425 ,216,931 $ 172,284 $ 56,482 49% 974,418 974,418 300,000 1,274,418 1,446,702 855,000 358,731 500 1,214,231 $ 232,471 $ 60,187 35% 974,418 (5,000) 969,418 300,000 1,269,418 1,441,702 855,000 358,731 425 1,214,156 $ 227,546 $ 55,262 32% 972,055 972,055 300,000 1,272,055 1,499,601 870,000 341,481 500 1,211,981 $ 287,620 $ 60,074 26% 31 Actual AdoptetlEstimaYe 1 Adopted. Desdri tion - 2016 , 20.1,7 2017 20.18` Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources Total Available: Expenditures Debt Service Principal Interest Other Total Expenditures: Other Uses Operating Transfers Out Fund Balance, December 31 Change in Fund Balance $ 115,802 $ 172,284 $ 172,284 $ 227,546 979,038 (5,625) 973,413 300,000 1,273,413 1,389,215 845,000 371,506 425 ,216,931 $ 172,284 $ 56,482 49% 974,418 974,418 300,000 1,274,418 1,446,702 855,000 358,731 500 1,214,231 $ 232,471 $ 60,187 35% 974,418 (5,000) 969,418 300,000 1,269,418 1,441,702 855,000 358,731 425 1,214,156 $ 227,546 $ 55,262 32% 972,055 972,055 300,000 1,272,055 1,499,601 870,000 341,481 500 1,211,981 $ 287,620 $ 60,074 26% 31 32 Fund: 3405 Cost Center: 2012C G.O. Abatement Bonds Department Head: Finance Director Activity Type/Code: Debt Service Debt Service is scheduled as listed below: Year Amount Principal Interest 2018 $ 1,211,481 $ 870,000 $ 341,481 2019 1,208,932 885,000 323,932 2020 1,215,982 910,000 305,982 2021 1,212,632 925,000 287,632 2022 1,213,932 945,000 268,932 2023 1,209,282 960,000 249,282 2024 1,213,000 985,000 228,000 2025 1,209,356 1,005,000 204,356 2026 1,208,275 1,030,000 178,275 2027 1,205,250 1,055, 000 150,250 2028 1,205,147 1,085,000 120,147 2029 1,212,675 1,125,000 87,675 2030 1,213,400 1,160,000 53,400 2031 1,218, 000 1,200, 000 18,000 $16,957,344 $14,140,000 $ 2,817,344 General Activity Description To account for the payment of principal and interest on long-term debt. Process Used The City sold $19,580,000 of Lease Revenue Bonds in 2004 to finance the construction of a community center. Approximately 50% of the debt will be paid for by a long-term lease arrangement with the YMCA of Minneapolis. The YMCA will run a full service YMCA out of the Community Center building. This issue will be used to advance refund the refunding issues sold in 2006 and 2007 that refunded the 2004 issue. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Debt Service Funds General Obligation Bonds - 2010A G.O. Open Space Referendum Bonds Statement of Revenues, Expenditures and Changes in Fund Balance "Actual ': , "` Adopte'd, "Estimate,---,,, Adoptedl Descri 'tion.; 2016, 201;7 2017 20;1.8 Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Operating Transfers In Total Revenues and Other Sources: Total Available: Expenditures Debt Service Principal Interest Other Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 215,134 187,278 1,426 188,704 2,031 190,735 405,869 145,000 28,942 450 174,392 $ 231,477 $ 231,477 $ 243,209 187,840 187,840 187,840 419,317 150,000 25,658 500 176,158 187,840 187,840 419,317 150,000 25,658 450 176,108 188,777 188,777 188,777 431,986 155,000 21,841 500 177,341 174,392 176,158 176,108 177,341 $ 231,477 $ 16,343 8% $ 243,159 $ 11,682 5% $ 243,209 $ 11,732 5% $ 254,645 $ 11,436 5% 33 CM Fund: 3901 Cost Center: 2010A G.O. Open Space Referendum Bonds Department Head: Finance Director Activity Type/Code: Debt Service Debt Service is scheduled as listed below: Year Amount Principal Interest 2018 $ 176,841 $ 155,000 $ 21,841 2019 177,507 160,000 17,507 2020 172,827 160,000 12,827 2021 172,870 165,000 7,870 2022 172,656 170,000 2,656 $ 872,701 $ 810,000 $ 62,701 General Activity Description To account for the payment of principal and interest on long-term debt. Process Used The City sold $1,660,000 of Open Space Referendum Bonds in 2010 to finance the purchase of land to remain as open space. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA 35 CITY OF ANDOVER, MINNESOTA 2018 ANNUAL BUDGET IDEINI)cION,. Capital Projects Funds can be used to account for acquisition or construction of major capital facilities financed mainly with governmental fund resources, general obligation debt, special assessments, special assessment debt, grants, or other resources that are not part of proprietary funds or trust funds. City of Andover Capital Projects Funds 2018 Budget Summary - All Capital Projects Funds Statement of Revenues, Expenditures and Changes in Fund Balance 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: Fund Balance, December 31 $ 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 28,694,343 2,519,865 2,522,220 196,719 5,238,804 96,513 5,335,317 $ 23,359,026 $ 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 28,412,564 3,977,470 3,124, 800 196,719 7,298,989 6,841,002 30,200,028 4,028,000 2,640,015 196,719 6,864,734 54,228 54,228 7,353,217 $ 21,059,347 Change in Fund Balance $ 1,193,250 $ (2,299,679) 5% -10% 6,918,962 $ 23,281,066 $ (77,960) 0% 3,821,437 27,102,503 3,293,500 3,604,500 196,719 7,094,719 114,850 7,209,569 $ 19,892,934 $ (3,388,132) -15% 36 Actual Adopted Esti nate Addpted " " ,Descri ion. �2017.�' 2018 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: Fund Balance, December 31 $ 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 28,694,343 2,519,865 2,522,220 196,719 5,238,804 96,513 5,335,317 $ 23,359,026 $ 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 28,412,564 3,977,470 3,124, 800 196,719 7,298,989 6,841,002 30,200,028 4,028,000 2,640,015 196,719 6,864,734 54,228 54,228 7,353,217 $ 21,059,347 Change in Fund Balance $ 1,193,250 $ (2,299,679) 5% -10% 6,918,962 $ 23,281,066 $ (77,960) 0% 3,821,437 27,102,503 3,293,500 3,604,500 196,719 7,094,719 114,850 7,209,569 $ 19,892,934 $ (3,388,132) -15% 36 City of Andover Capital Projects Funds Water Trunk Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Actual` Adoptetl Estiunate _ A'dopted` Descnptioh' 2016. Special Assessments 448,039 Fund Balance, January 1 $ 2,854,563 $ 2,887,206 $ 2,887,206 Revenues Special Assessments 448,039 30,000 273,069 Investment Income 37,680 25,000 25,000 User Charges 282,536 70,471 217,624 Total Revenues: 768,255 125,471 515,693 Other Sources Transfers In - - - Total Revenues and Other Sources: 768,255 125,471 515,693 Total Available: 3,622,818 3,012,677 3,402,899 Expenditures Other Services and Charges 408,254 - - Capital Outlay 242,262 43,000 43,000 Total Expenditures: 650,516 43,000 43,000 Other Uses Operating Transfers Out 85,096 54,228 54,228 Total Expenditures and Other Uses: 735,612 97,228 97,228 Fund Balance, December 31 $ 2,887,206 $ 2,915,449 $ 3,305,671 Change in Fund Balance $ 32,643 $ 28,243 $ 418,465 1% 1% 14% $ 3,305,671 50,000 25,000 73,289 148,289 148,289 3,453,960 707,000 707,000 114,850 821,850 $ 2,632,110 $ (673,561) -20% 37 Fund: 4110 38 Cost Center: Water Trunk Department Head: City Engineer Activity Type/Code: Capital Projects Expenditure Highliehts Projects planned for 2018 include: New Development Projects $ 43,000 143rd Avenue - Round Lake Blvd to Woodbine St 144,000 And Boundary Comm Plat 1 & Shirley Estates 520,000 $ 707,000 A portion of the connection fee is used to support the Water Treatment Plant and is transferred to the Water Enterprise Fund. Projects for 2017 included: New Development Projects 43,000 2016 included the advance payment of permit fees to various funds, in which, the Water Trunk fund will get reimbursed through the assessment process with interest ($327,854). General Activity Description The Water Trunk Capital Projects Fund accounts for water access fees and trunk improvements as part of development. Process Used The water system is continually reviewed by the Engineering and Water Departments through studies of service, water quality, and future system expansion or improvements. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Capital Projects Funds Sewer Trunk Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues Special Assessments Investment Income User Charges Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 6,081,930 $ 6,554,661 $ 6,554,661 $ 6,587,796 28,138 87,366 163,162 278,--- 400,000 678,666 6,760,596 33,210 172,725 205,935 105,000 50,000 12,912 167,912 400,000 567,912 7,122,573 502,000 502,000 20,000 50,000 65,135 135,135 400,000 535,135 7,089,796 502,000 502,000 205,935 502,000 502,000 $ 6,554,661 $ 472,731 8% $ 6,620,573 $ 65,912 1% $ 6,587,796 $ 33,135 1% 20,000 50,000 12,910 82,910 400,000 482,910 7,070,706 847,000 847,000 847,000 $ 6,223,706 $ (364,090) -6% 39 Actuaf Ad'op'tedEstitnste� "� „ piiopted` ,' i" Desai tion 2016 2017 201;7 201$1 ' Fund Balance, January 1 Revenues Special Assessments Investment Income User Charges Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 6,081,930 $ 6,554,661 $ 6,554,661 $ 6,587,796 28,138 87,366 163,162 278,--- 400,000 678,666 6,760,596 33,210 172,725 205,935 105,000 50,000 12,912 167,912 400,000 567,912 7,122,573 502,000 502,000 20,000 50,000 65,135 135,135 400,000 535,135 7,089,796 502,000 502,000 205,935 502,000 502,000 $ 6,554,661 $ 472,731 8% $ 6,620,573 $ 65,912 1% $ 6,587,796 $ 33,135 1% 20,000 50,000 12,910 82,910 400,000 482,910 7,070,706 847,000 847,000 847,000 $ 6,223,706 $ (364,090) -6% 39 Fund: 4120 40 Cost Center: Sewer Trunk Department Head: City Engineer Activity Type/Code: Capital Projects Expenditure Highli¢hts Projects planned for 2018 include: New Development Projects $ 117,000 Sanitary Sewer Ext - Crosstown Blvd 500,000 Aztec Estates Lift Station Upgrade 110,000 Lift Station #4 Upgrade 60,000 Lift Station #9 Upgrade 60,000 $ 847,000 Projects for 2017 included: New Development Projects $ 117,000 Lift Station #4 Upgrade - 50,000 Sanitary Sewer Extensions 105,000 Replacement - Jet/Vac Truck 230,000 $ 502,000 General Activity Desciption The Sewer Trunk Capital Projects Fund accounts for access fees and sanitary sewer improvements. City sewage flows through a pipe and lift station system to a large sewer interceptor, which is then carried to a metro treatment plant. Process Used The Sewer and Engineering Departments continually review the system to determine the proper sizing of pipes and lift stations to process sewage. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Capital Projects Funds Storm Sewer Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues Investment Income Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ (63,357) $ (64,193) $ (64,193) $ (65,093) (836) (900) (836) (900) (64,193) (64,193) (65,093) (65,093) $ (64,193) $ (64,193) $ (65,093) $ (65,093) $ (836) $ $ (900) $ 1% 0% 1% 0% 41 Actual:, .Adopted Estimate_ Adopted, f Despription 2016 , 2017 2017 2018. Fund Balance, January 1 Revenues Investment Income Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ (63,357) $ (64,193) $ (64,193) $ (65,093) (836) (900) (836) (900) (64,193) (64,193) (65,093) (65,093) $ (64,193) $ (64,193) $ (65,093) $ (65,093) $ (836) $ $ (900) $ 1% 0% 1% 0% 41 Fund: 4130 Cost Center: Storm Sewer Activity Type/Code: Capital Projects Expenditure Highlights No expenditures planned for 2018. Department Head: City Engineer General Activity Description The Storm Sewer Capital Projects Fund accounts for storm sewer fees and improvements as part of development and ongoing maintenance. Process Used The storm sewer system is continually reviewed by Public Works and Engineering through studies of storm water runoff and drainage patterns. Note: There is one part of the City where a special storm sewer trunk area assessment is required as part of any new development. This will be used to fund the oversizing of the storm sewer that was constructed under Project #93-3: Xeon Street Trunk Storm Sewer. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA 42 City of Andover Capital Projects Funds Road and Bridge Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues General Property Taxes Special Assessments Intergovernmental Investment Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 5,511,747 $ 6,083,068 $ 6,083,068 $ 6,270,682 1,176,138 263,699 830,897 81,984 358,955 2,711,673 6,800 2,718,473 8,230,220 1,577,433 569,719 2,147,152 1,179,154 552,000 1,314,902 35,000 3,081,056 5,000 3,086,056 9,169,124 3,657,000 3,657,000 1,179,154 552,000 2,073,460 35,000 3,839,614 5,000 3,844,614 9,927,682 3,657,000 3,657,000 1,269,014 330,000 430,899 40,000 2,069,913 5,300 2,075,213 8,345,895 3,038,500 3,038,500 2,147,152 3,657,000 3,657,000 3,038,500 $ 6,083,068 $ 571,321 10% $ 5,512,124 $ (570,944) -9% $ 6,270,682 $ 187,614 3% $ 5,307,395 $ (963,287) -15% 43 Actual Adopfetl:Estimate'' . Fitlopted ' Des`cri tion 2016" 20,1.7.. 2017"' 20.18._ Fund Balance, January 1 Revenues General Property Taxes Special Assessments Intergovernmental Investment Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 5,511,747 $ 6,083,068 $ 6,083,068 $ 6,270,682 1,176,138 263,699 830,897 81,984 358,955 2,711,673 6,800 2,718,473 8,230,220 1,577,433 569,719 2,147,152 1,179,154 552,000 1,314,902 35,000 3,081,056 5,000 3,086,056 9,169,124 3,657,000 3,657,000 1,179,154 552,000 2,073,460 35,000 3,839,614 5,000 3,844,614 9,927,682 3,657,000 3,657,000 1,269,014 330,000 430,899 40,000 2,069,913 5,300 2,075,213 8,345,895 3,038,500 3,038,500 2,147,152 3,657,000 3,657,000 3,038,500 $ 6,083,068 $ 571,321 10% $ 5,512,124 $ (570,944) -9% $ 6,270,682 $ 187,614 3% $ 5,307,395 $ (963,287) -15% 43 Fund: 4140 44 Cost Center: Road and Bridge Department Head: City Engineer Activity Type/Code: Capital Projects Expenditure Highlights Some of the major 2018 projects are as follows: Annual street seal coat Annual street crack seal New / reconstruct routes MSA - New / reconstruct routes MSA - Intersection upgrades Pedestrian trail maintenance Pedestrian trail reconstruction Pedestrian curb ramp replacement Overlays Equipment Annual pavement markings Gravel road improvements Curb replacement Some of the major 2017 projects are as follows: Annual street seal coat Annual street crack seal New / reconstruct routes MSA - New / reconstruct routes Pedestrian trail maintenance Pedestrian trail reconstruction Pedestrian curb ramp replacement LED Crosswalk Warning system Annual pavement markings Gravel road improvements Curb replacement $ 400,000 140,000 667,000 900,000 285,000 55,000 80,000 16,000 350,000 33,500 40,000 20,000 52,000 $ 3,038,500 $ 725,000 143,000 1,236,000 1,300,000 50,000 60,000 15,000 21,000 42,000 15,000 50,000 $ 3,657,000 General Activity Description The Road and Bridge Fund accounts for road projects and the Pavement Management Program. Process Used Construction projects are identified by the capital improvement process and contained in the five-year Capital Improvement Plan (CIP). The council approves the CIP annually, thereby initiating a process of feasibility study, preparation of plans and specifications, public hearings, ordering of the project, bidding the project and construction. This fund also accounts for the pavement management program, which includes annual seal coating, crack sealing and overlays for roads. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Capital Projects Funds Park Dedication Projects Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues General Property Taxes Investment Income User Charges Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 376,632 $ 405,368 $ 405,368 $ 49,453 15,463 6,506 431,784 19,808 473,561 473,561 850,193 29,147 415,678 444,825 15,000 147,600 100,000 262,600 262,600 667,968 15,000 584,800 599,800 15,000 1,500 147,600 10,000 174,100 174,100 579,468 15,000 515,015 530,015 15,000 75,950 90,950 90,950 140,403 15,000 25,000 40,000 444,825 599,800 530,015 40,000 $ 405,368 $ 28,736 8% $ 68,168 $ (337,200) -83% $ 49,453 $ (355,915) -88% $ 100,403 $ 50,950 103% 45 A"ctual"' Addpf'tl Estimate_ ; .Adopted Decd ti8n 2016 20'17 2017 2018; Fund Balance, January 1 Revenues General Property Taxes Investment Income User Charges Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 376,632 $ 405,368 $ 405,368 $ 49,453 15,463 6,506 431,784 19,808 473,561 473,561 850,193 29,147 415,678 444,825 15,000 147,600 100,000 262,600 262,600 667,968 15,000 584,800 599,800 15,000 1,500 147,600 10,000 174,100 174,100 579,468 15,000 515,015 530,015 15,000 75,950 90,950 90,950 140,403 15,000 25,000 40,000 444,825 599,800 530,015 40,000 $ 405,368 $ 28,736 8% $ 68,168 $ (337,200) -83% $ 49,453 $ (355,915) -88% $ 100,403 $ 50,950 103% 45 Fund: 4150 46 Cost Center: Park Dedication Projects Department Head: City Engineer Activity Type/Code: Capital Projects Expenditure Hi2hli2hts 2017 Projects include: Annual Miscellaneous Projects $ 15,000 Irrigation Projects - Small Parks 25,000 $ 40,000 2017 Projects include: Annual Miscellaneous Projects $ 15,000 Pine Hills North - Phase II 100,000 Fox Meadows Park - Renovation 457,300 Irrigation Projects - Small Parks 20,000 Nordeen's Park - Basketball Court 7,500 $ 599,800 General Activity Desciption The Park Dedication Fund accounts for contributions associated with land development to be used for constructing and upgrading the City's park system. Process Used The Park and Recreation Commission evaluates the needs of the community with regard to park and recreation facilities. Recommendations are made to the City Council and projects are then placed into the annual City Capital Improvement Plan. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Capital Projects Funds Building Fund Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Debt Service - Principal Retirement Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 779,066 $ 668,378 $ 668,378 $ 445,659 8,430 8,430 92,980 101,410 880,476 , 5,993 196,719 202,712 9,386 212,098 $ 668,378 $ (110,688) -14% 5,000 4,000 5,000 4,000 5,000 673,378 196,719 196,719 196,719 $ 476,659 $ (191,719) -29% 4,000 672,378 30,000 196,719 226,719 226.719 $ 445,659 $ (222,719) -33% 50,000 3,000 53,000 53,000 498,659 196,719 196,719 196,719 $ 301,940 $ (143,719) -32% 47 Actual= Adopfed. Estimate' Adopted. Descri tion 2016' 201712017 2018 Fund Balance, January 1 Revenues General Property Taxes Investment Income Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Debt Service - Principal Retirement Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 779,066 $ 668,378 $ 668,378 $ 445,659 8,430 8,430 92,980 101,410 880,476 , 5,993 196,719 202,712 9,386 212,098 $ 668,378 $ (110,688) -14% 5,000 4,000 5,000 4,000 5,000 673,378 196,719 196,719 196,719 $ 476,659 $ (191,719) -29% 4,000 672,378 30,000 196,719 226,719 226.719 $ 445,659 $ (222,719) -33% 50,000 3,000 53,000 53,000 498,659 196,719 196,719 196,719 $ 301,940 $ (143,719) -32% 47 Fund: 4160 48 Cost Center: Building Fund Department Head: Finance Director Activity TypelCode: Capital Projects Expenditure HiEhlishts In 2013, the City has signed a contract for deed to purchase some land adjacent to the city hall / public works campus. As part of that agreement, annual payments will be made starting in 2013 with final payment in 2018. 2018 $ 196,719 General Activity Description The Building Fund accounts for miscellaneous building improvement projects for all facilities, including land acquisitions. Process Used Facilities are reviewed annually for non-recurring repairs or for future facility needs. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Capital Projects Funds Trail & Transportation Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues Investment Income User Charges Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 347,400 $ 458,095 $ 458,095 $ 595,295 8,098 119,858 127,956 250,000 377,956 725,356 11,140 256,121 267,261 267,261 $ 458,095 $ 110,695 32% 3,000 39,200 42,200 42,200 500,295 565,000 565,000 565,000 $ (64,705) $ (522,800) -114% 3,000 39,200 42,200 250,000 292,200 750,295 5,000 150,000 155,000 155,000 $ 595,295 $ 137,200 30% 20,175 20,175 20,175 615,470 587,000 587,000 587,000 $ 28,470 $ (566,825) -95% 49 ActuaYAdopted,- Estimate , ... Adopfed. Descn tidn 2016 201.7 2"0:,17 201:8 Fund Balance, January 1 Revenues Investment Income User Charges Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 347,400 $ 458,095 $ 458,095 $ 595,295 8,098 119,858 127,956 250,000 377,956 725,356 11,140 256,121 267,261 267,261 $ 458,095 $ 110,695 32% 3,000 39,200 42,200 42,200 500,295 565,000 565,000 565,000 $ (64,705) $ (522,800) -114% 3,000 39,200 42,200 250,000 292,200 750,295 5,000 150,000 155,000 155,000 $ 595,295 $ 137,200 30% 20,175 20,175 20,175 615,470 587,000 587,000 587,000 $ 28,470 $ (566,825) -95% 49 Fund: 4170 Cost Center: Trail & Transportation Activity Type/Code: Capital Projects Expenditure Highlights Projects planned for 2018 include: BEI 8' Bituminous trail and boardwalk along Crosstown Blvd - Bunker Lake Blvd to 140th Ave - $587,000 Projects planned for 2017 include: 8' Bituminous trail along Andover Blvd - Bluebird St to Vale St - $150,000 Department Head: Dir of PW / City Engineer General Activity Description The Trail and Transportation Capital Projects Fund accounts for contributions associated with land development to be used for constructing and upgrading the City's Trail System. Process Used The Park and Recreation Commission evaluates the needs of the community with regard to trail facilities. Recommendations are made to the City Council and projects are then placed into the annual City Capital Improvement Plan. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Capital Projects Funds Capital Equipment Reserve Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues General Property Taxes Investment Income Miscellaneous Total Revenues: Other Sources Transfers In Proceeds from Sale of Capital Assets Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay . Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: $ 1,051,687 $ 976,432 $ 976,432 $ 1,442,592 260,295 10,273 38,082 308,650 25,693 334,343 1,386,030 83,914 325,684 409,598 409,598 Fund Balance, December 31 $ 976,432 Change in Fund Balance $ (75,255) -7% 750,000 5,000 2,000 757,000 48,819 805,819 1,782,251 205,000 680,000 885,000 750,000 5,000 45,315 800,315 550,845 1,351,160 2,327,592 205,000 680,000 885,000 23,500 823,500 2,266,092 140,000 688,500 828,500 885,000 885,000 828,500 $ 897,251 $ (79,181) -8% $ 1,442,592 $ 466,160 48% $ 1,437,592 $ (5,000) 0% 51 Actual" Adopted Estimate .' ;Adopt dtl =Desch tiorn �- 7016', 201 �' 2017 ;2018'- Fund Balance, January 1 Revenues General Property Taxes Investment Income Miscellaneous Total Revenues: Other Sources Transfers In Proceeds from Sale of Capital Assets Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay . Total Expenditures: Other Uses Operating Transfers Out Total Expenditures and Other Uses: $ 1,051,687 $ 976,432 $ 976,432 $ 1,442,592 260,295 10,273 38,082 308,650 25,693 334,343 1,386,030 83,914 325,684 409,598 409,598 Fund Balance, December 31 $ 976,432 Change in Fund Balance $ (75,255) -7% 750,000 5,000 2,000 757,000 48,819 805,819 1,782,251 205,000 680,000 885,000 750,000 5,000 45,315 800,315 550,845 1,351,160 2,327,592 205,000 680,000 885,000 23,500 823,500 2,266,092 140,000 688,500 828,500 885,000 885,000 828,500 $ 897,251 $ (79,181) -8% $ 1,442,592 $ 466,160 48% $ 1,437,592 $ (5,000) 0% 51 Fund: 4180 Cost Center: Capital Equipment Reserve Activity Type/Code: Capital Projects EEx enditure Hiehliehts Projects outlined in the 2018 - 2022 CIP for year 2018 using the Capital Equipment Reserve Capital Projects Fund include: Using 2018 Capital Projects Reserve / levy: Replacement - Carpet / Tile Replacement - Emergency Sirens Annual Parking Lot Maintenance Emergency Operations Center Improvement Smartboard Addition Replacement - Grass #31 Replacement - One Ton Truck w/ Plow #599 New - Brush Cutter Replacement -Track Loader #610 Replacement- Small Extended Cab Truck #76 Replacement - Tymco Street Sweeper #172 Replacement - Lazar Line Painter Replacement - Hot Patch Box #08-180 Using 2017 Capital Projects Reserve / levy: Annual Parking Lot Maintenance Replacement - Planning Vehicle #7 Replacement - Carpet / Tile Replacement - Security System Public Works Relocation / Expansion Plan HD Upgrade - City Hall.Council Chambers Replacement - Extrication (Rescue) Equipment Emergency Operations Center Improvement Replacement- Emergency Sirens Replacement - One Ton Truck w/ Plow #134 New - One Ton Truck w/ Reg. Box w/ Lift & Plow New- Bobcat Paver Sign Design Software & Plotter ACC / YMCA Expansion Plan New - Trail Machine Replacement- One Ton Crew Cab Pickup #502 10,000 45,000 130,000 18,000 12,000 85,000 80,000 15,000 60,000 55,000 235,000 8,500 75,000 828,500 $ 30,000 30,000 10,000 100,000 50,000 60,000 80,000 40,000 45,000 80,000 55,000 20,000 10,000 75,000 150,000 50,000 $ 885,000 Department Head: Finance Director General Activity Description Resources for this fund come from residual fund transfers, interest earnings and property tax (capital) levy. Process Used During 2017 and 2018 budget processes, it was determined that various capital expenditures were necessary. The Andover Management Team and Andover Vehicle Purchasing Committee reviewed departmental needs and prioritized capital needs. _ 2017 and 2018 includes a Capital Equipment Purchases levy to purchase equipment with levy dollars instead of issuing debt. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA 52 City of Andover Capital Projects Funds 2014 G.O. Equipment Certificates Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 $ Actu af il Adopted `Estimate Aibpted Desch tion 20162017 2017,, 2018 Fund Balance, January 1 $ 25,223 $ $ $ Revenues Investment Income - Other Sources Transfers In Total Revenues and Other Sources: - Total Available: 25,223 Expenditures Capital Outlay 25,223 Other Uses Operating Transfers Out - - Total Expenditures and Other Uses: 25,223 - Fund Balance, December 31 $ $ - $ $ Change in Fund Balance $ (25,223) $ - $ $ -100% n/a n/a n/a 53 Fund: 4212 54 Cost Center: 2014 G.O. Capital Notes Department Head: Finance Director Activity Type/Code: Capital Projects Expenditure Highlights The following is a list of equipment purchased with a 2014 Capital Note. Capital Note. Vehicle / Equipment Replacements: New- Mobile Vehicle Lifts $ 24,000 Survey Equipment 32,000 Replacement - Ladder Truck #11 1,100,000 Replacement - Bobcat #610 36,000 Replacement - Dump Truck w/ Snow Removal Equipment 150,000 Replacement - Fire Utility #4 32,000 Replacement - Fire Utility #5 32,000 Replacement - Toro Groundmaster #559 35,000 Replacement - One Ton Truck w/ Plow #503 65,000 New - Snowblower Attachment - Belos 23,000 Replacement -Snowblower Attachment - Bobcat 7,000 New -Add Rear Wing to Plow Truck 30,000 $ 1,566,000 This fund was closed in 2016. General Activity Description This fund accounts for major capital equipment purchases. Resources for the capital equipment come from the issuance of equipment notes. The notes are typically of a 5 -year duration and debt service is funded via the annual tax levy. Process Used During the 2014 budget process it was determined that various capital equipment was necessary. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Capital Projects Funds 2016 G.O. Equipment Certificates Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Actual: Adopted Estimate Adopted Descri tion .` 2016'" 20T7 2017" 20.18 Fund Balance, January 1 $ - Revenues Investment Income 1,005 Other Sources Bond Proceeds 520,000 Total Revenues and Other Sources: 521,005 Total Available: 521,005 Expenditures Other Services and Charges 6,500 Capital Outlay 514,505 Total Expenditures: 521,005 Other Uses Operating Transfers Out - Total Expenditures and Other Uses: 521,005 Fund Balance, December 31 $ - Change in Fund Balance $ n/a n/a n/a n/a 55 Fund: 4213 Cost Center: 2016 G.O. Capital Notes Activity Type/Code: Capital Projects Expenditure HiEhli2hts The following is a list of equipment purchased with a 2016 Capital Note. Capital Note. Vehicle / Equipment Replacements: Replacement - Small Extended Cab Pick Up #9 $ 30,000 Replacement - Fire Marshall Vehicle 40,000 Replacement - Breathing Air Compressor at St. #1 80,000 Replacement - Toro Groundmaster #559 45,000 Replacement - Toro Groundmaster #585 110,000 Replacement - Toro Groundmaster4000-D#583 70,000 Replacement - Dump Truck w/ Snow Removal #196 200,000 $ 575,000 This fund was closed in 2016. Department Head: Finance Director General Activity Description This fund accounts for major capital equipment purchases. Resources for the capital equipment come from the issuance of equipment notes. The notes are typically of a 5 -year duration and debt service is funded via the annual tax levy. Process Used During the 2016 budget process it was determined that various capital equipment was necessary. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Capital Projects Funds Tax Increment Projects Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues Tax Increments Investment Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay Total Expenditures: . Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 4,358,069 $ 4,459,335 $ 4,459,335 $ 3,729,335 91,808 59,940 314,095 465,843 465,843 4,823,912 364,274 303 364,577 118,480 35,000 153,480 153,480 4,612,815 100,470 750,000 850,470 364,577 850,470 $ 4,459,335 $ 101,266 2% $ 3,762,345 $ (696,990) -16% 85,000 35,000 120,000 120,000 4,579,335 100,000 750,000 850,000 85,000 35,000 120,000 120,000 3,849,335 100,000 750,000 850,000 850,000 850,000 $ 3,729,335 $ (730,000) -16% $ 2,999,335 $ (730,000) -20% 57 Actual' Adopted Esthiate: Aiopteii°. D, cri,tion 2016' 2017' 2017 2018 Fund Balance, January 1 Revenues Tax Increments Investment Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Capital Outlay Total Expenditures: . Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 4,358,069 $ 4,459,335 $ 4,459,335 $ 3,729,335 91,808 59,940 314,095 465,843 465,843 4,823,912 364,274 303 364,577 118,480 35,000 153,480 153,480 4,612,815 100,470 750,000 850,470 364,577 850,470 $ 4,459,335 $ 101,266 2% $ 3,762,345 $ (696,990) -16% 85,000 35,000 120,000 120,000 4,579,335 100,000 750,000 850,000 85,000 35,000 120,000 120,000 3,849,335 100,000 750,000 850,000 850,000 850,000 $ 3,729,335 $ (730,000) -16% $ 2,999,335 $ (730,000) -20% 57 Fund: 4501 58 Cost Center: Tax Increment Projects Department Head: Finance Director Activity Type/Code: Capital Projects Expenditure Hiehliehts 2018 Budgeted expenditures include: Redevelopment Site Purchases $ 750,000 Fray -As -You -Go Note 65,237 Administration 34,763 $ 850,000 2017 expenditures include: Redevelopment Site Purchases $ 750,000 Pay -As -You -Go Note 58,623 Administration 41,847 $ 850,470 TIF District 1-1 was decertified in 2012 and TIF District 1-2 was decertified in 2014. TIF District 1-3 and TIF District 1-4 was decertified in 2016. General Activity Description The Tax Increment Projects Fund accounts for activities in TIF districts 1-1, 1-2, 1-3, 1-4, 1-5 and 1-6 and all TIF land sales and expenditures to reach the goals of the TIF district plans. Process Used Promotion and expansion of the commercial / industrial tax base through redevelopment of land. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Capital Projects Funds Permanent Improvement Revolving Statement of Revenues, Expenditures and Changes in Fund Balance Fund Balance, January 1 Revenues Special Assessments Investment Income Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 840,785 $ 930,676 $ 930,676 $ 919,676 78,189 Actual` Adopted Estimat6. " Ailoptetl Descri tion-, ;�- 2016- 201;7 2017 , 2018- Fund Balance, January 1 Revenues Special Assessments Investment Income Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Other Services and Charges Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 840,785 $ 930,676 $ 930,676 $ 919,676 78,189 - - 2,400 11,702 5,000 5,000 5,000 89,891 5,000 5,000 7,400 89,891 5,000 5,000 7,400 930,676 935,676 935,676 927,076 $ 930,676 $ 935,676 $ 89,891 $ 5,000 11% 1% 16,000 - $ 919,676 $ 927,076 $ (11,000) $ 7,400 -1% 1% 59 Fund: 4601 60 Cost Center: Permanent Improvement Revolving Department Head: Finance Director Activity Type/Code: Capital Projects Expenditure Hi2hliehts No expenditures are planned for 2018. General Activity Description The Permanent Improvement Revolving (PIR) Fund serves as a long-term funding source for large improvement expenditures. These funds can be used to finance infrastructure improvements for new developments if requested instead of bonding for them. Process Used The City has issued four bonds totaling $15.4 million thru 2008 in the PIR Fund for large capital projects. This fund has collected $19.12 million of special assessments over the past 15 years. The annual cash flow of this fund is intended to eliminate unfunded projects through effective management of debt payments and project expenditures. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Capital Projects Funds 2010A G.O. Open Space Referendum Bonds Statement of Revenues, Expenditures and Changes in Fund Balance Fund, Balance, January 1 Revenues Investment Income Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Capital Outlay Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 2,031 $ $ $ 2,031 2,031 2,031 $ (2,031) $ $ $ -100% n/a n/a n/a 61 Actual. Adopted Estimate Adopted: Descri tion. 2016 2017' 2017 2018 Fund, Balance, January 1 Revenues Investment Income Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Capital Outlay Other Uses Operating Transfers Out Total Expenditures and Other Uses: Fund Balance, December 31 Change in Fund Balance $ 2,031 $ $ $ 2,031 2,031 2,031 $ (2,031) $ $ $ -100% n/a n/a n/a 61 Fund: 4901 Cost Center: 2010A G.O.Open Space Referendum Bonds Activity Type/Code: Capital Projects Expenditure Highlights Over the past four years, four parcels have been purchased for the preservation of open space in the City of Andover. The remaining funds ($2,031) were transferred to the Open Space Referendum Bonds Debt Service Fund to assist in the debt payments in 2016. This fund was closed in 2016. Department Head: Finance Director General Activity Description This fund is used to finance various land acquisitions for open space preservation within the City of Andover through the use of G.O. Open Space Referendum Bonds. Process Used An Open Space Advisory Commission has been created to establish both short and long term goals, in addition to, determining the criteria for which to acquire open space. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA 63 CITY OF ANDOVER, MINNESOTA 2018 ANNUAL BUDGET Governments establish enterprise funds to account for activities that consist of rendering services or providing goods to the public for which a fee or charge is collected. City of Andover Enterprise Funds 2018 Budget Summary - All Enterprise Funds Statement of Revenues, Expenditures and Changes in Fund Net Assets 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 828,751 4,695,491 596,930 5,292,421 $ 7,544,819 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 4,695,491 596,930 5,292,421 $ 7,528,819 5,186,102 46,000 13,000 67,000 5,312,102 114,850 114,850 5,426,952 12,955,771 1,083,687 320,700 2,287,723 258,000 776,843 4,726,953 602,058 5,329,011 $ 7,626,760 Change in Unrestricted Net Assets $ 611,280 $ 23,433 $ 7,433 $ 97,941 9% 0% 0% 1% Actual Ado ted P Estimate Ado ted ::: � p Deschiption,` 2016 " .201:7 2017 2018 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 828,751 4,695,491 596,930 5,292,421 $ 7,544,819 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 4,695,491 596,930 5,292,421 $ 7,528,819 5,186,102 46,000 13,000 67,000 5,312,102 114,850 114,850 5,426,952 12,955,771 1,083,687 320,700 2,287,723 258,000 776,843 4,726,953 602,058 5,329,011 $ 7,626,760 Change in Unrestricted Net Assets $ 611,280 $ 23,433 $ 7,433 $ 97,941 9% 0% 0% 1% City of Andover Enterprise Funds Water Statement of Revenues, Expenditures and Changes in Fund Net Assets 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 $ 3,040,230 $ 3,372,043 $ 3,372,043 $ 3,517,491 2,492,430 32,464 28,591 57,580 2,611,065 85,096 767 85,863 2,696,928 5,737,158 498,129 196,824 690,021 1,500 828,391 2,214,865 150,250 2,365,115 $ 3,372,043 Change in Unrestricted Net Assets $ 331,813 11% 2,433,052 15,000 13,000 6,000 67,000 2,534,052 54,228 54,228 2,588,280 5,960,323 457,216 238,200 747,415 15,000 828,751 2,286,582 150,250 2,436,832 $ 3,523,491 $ 151,448 4% 2,433,052 15,000 13,000 67,000 2,528,052 54,228 54,228 2,582,280 5,954,323 457,216 238,200 747,415 15,000 828,751 2,286,582 150,250 2,436,832 $ 3,517,491 $ 145,448 4% 2,456,616 15,000 13,000 67,000 2,551,616 114,850 114,850 2,666,466 6,183,957 488,294 250,700 751,665 76,000 776,843 2,343,502 90,700 2,434,202 $ 3,749,755 $ 232,264 7% 65 Actual: T AdoptedEstimate Adopted D'escri' do 201'6' 2017„ 20'1 209: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 $ 3,040,230 $ 3,372,043 $ 3,372,043 $ 3,517,491 2,492,430 32,464 28,591 57,580 2,611,065 85,096 767 85,863 2,696,928 5,737,158 498,129 196,824 690,021 1,500 828,391 2,214,865 150,250 2,365,115 $ 3,372,043 Change in Unrestricted Net Assets $ 331,813 11% 2,433,052 15,000 13,000 6,000 67,000 2,534,052 54,228 54,228 2,588,280 5,960,323 457,216 238,200 747,415 15,000 828,751 2,286,582 150,250 2,436,832 $ 3,523,491 $ 151,448 4% 2,433,052 15,000 13,000 67,000 2,528,052 54,228 54,228 2,582,280 5,954,323 457,216 238,200 747,415 15,000 828,751 2,286,582 150,250 2,436,832 $ 3,517,491 $ 145,448 4% 2,456,616 15,000 13,000 67,000 2,551,616 114,850 114,850 2,666,466 6,183,957 488,294 250,700 751,665 76,000 776,843 2,343,502 90,700 2,434,202 $ 3,749,755 $ 232,264 7% 65 Fund: 5100 Cost Center: Water Activity Type/Code: Enterprise Fund Expenditure Highlights No major changes planned in 2018, but does include the purchase of a new 3/4 ton utility truck and the cost sharing of a new side by side utv. Department Head: Utility Supervisor General Activity Description Operate and maintain the City's water system including WTP, wells, towers and water mains. Provide a continuous, potable, bacteria free water supply at proper pressure levels. Maintain customer water meters and respond to other service requests. Maintain water distribution for fire protection system needs. Conform to all State and Federal monitoring rules, provide tours and information to the public. Process Used Operate wells and WTP in a manner that ensures a safe, clean and adequate water supply, that will meet peak daily demands and fire protection demands. Maintain wells, treatment facility, and related infrastructure. Operate and maintain chemical feed equipment. Collect, analyze and record water samples daily. Maintain, test and repair water meters. Respond to emergencies 24 hours a day. Work with contractors to locate watermains, locate and operate gate valves, monitor tests during final inspections. Check WTP, 8 wells, 7 days a week, 365 days per year. Flush all watermains in the spring every other year. Maintain all hydrants. Locate operate and clean gate valves to ensure proper operation. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Enterprise Funds Sanitary Sewer Statement of Revenues, Expenditures and Changes in Fund Net Assets Unrestricted Net Assets, January 1 Revenues Charges for Services Interest Penalties Miscellaneous Total Revenues: Other Sources Gain on the Sale of Capital Assets Total Revenues and Other Sources: Total Available: Expenditures Personal Services Supplies and Materials Other Services and Charges Capital Outlay Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: $ 3,618,050 $ 3,733,701 $ 3,733,701 $ 3,555,094 2,144,583 Actual. 4d6pted '-'--,,Estimate 33,540 Descri" 4ion''201'6 30,000 2017 ', ,2017 201'8 Unrestricted Net Assets, January 1 Revenues Charges for Services Interest Penalties Miscellaneous Total Revenues: Other Sources Gain on the Sale of Capital Assets Total Revenues and Other Sources: Total Available: Expenditures Personal Services Supplies and Materials Other Services and Charges Capital Outlay Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: $ 3,618,050 $ 3,733,701 $ 3,733,701 $ 3,555,094 2,144,583 2,215,411 2,215,411 2,226,349 33,540 30,000 30,000 30,000 - 10,000 - - 211 - - - 2,178,334 2,255,411 2,245,411 2,256,349 1,425 - - _ 2,179,759 2,255,411 2,245,411 2,256,349 5,797,809 5,989,112 5,979,112 5,811,443 316,505 346,626 346,626 363,339 17,151 36,800 36,800 36,800 1,283,772 1,348,912 1,348,912 1,350,162 - 245,000 245,000 166,000 1,617,428 1,977,338 1,977,338 1,916,301 446,680 446,680 446,680 470,012 2,064,108 2,424,018 2,424,018 2,386,313 Unrestricted Net Assets, December 31 $ 3,733,701 $ 3,565,094 $ 3,555,094 $ 3,425,130 Change in Unrestricted Net Assets $ 115,651 $ (168,607) $ (178,607) $ (129,964) 3% -5% -5% -4% 67 Fund: 5200 Cost Center: SanitarySewer Activity Type/Code: Enterprise Fund Expenditure Highliehts .11 No major changes planned in 2018, but does include the purchase of a new one ton utility truck and the cost sharing of a new side by side utv. 2017 includes the purchase of a new vac truck split with the Sanitary Sewer Trunk Capital Projects Fund. Department Head: Utility Supervisor General Activity Desciption City sewage is collected through a pipe and lift station network to large Metro City Sewer interceptor pipes that carry it to the Metro Treatment Plant for processing. The sewer division inspects, cleans, and maintains the City's collection system which includes breaks in pipes, manholes, and lift stations. Sewer backups caused by blockage due to debris or breaks in pipe are cleaned and/or repaired immediately. This department maintains the integrity of the entire sanitary sewer system. Process Used Inspect all lift stations five days per week. Clean one-quarter of the City's sewer collection system via jetting and vacuuming each year. City has implemented a televising program of the collection system that analyzes the entire system over a five year period. A spot check program checks flows in problem areas. Start 1/1 program to monitor inflow and infiltration into sewer system. Clean known problem area once per month. Monitor inspection and testing of all new sewer lines and manholes before accepting from contractor. Respond to and record all requests from customers, respond to emergencies 24 hours a day. Contract out all major system repairs. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Enterprise Funds Storm Sewer Statement of Revenues, Expenditures and Changes in Fund Net Assets Unrestricted Actual Adopted Estimate ' , Atloptetl Descn tion. _ 2016 20,17:. -20-17- 2b17 Unrestricted Net Assets, January 1 Revenues Charges for Services Interest Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures Personal Services Supplies and Materials Other Services and Charges Capital Outlay Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: Unrestricted Net Assets, December 31 Change in Unrestricted Net Assets $ 251,826 $ 415,642 $ 415,642 $ 456,234 464,928 2,764 467,692 467,692 719,518 196,620 11,516 95,740 303,876 471,163 1,000 472,163 472,163 887,805 221,375 33,200 176,996 431,571 471,163 1,000 472,163 472,163 887,805 221,375 33,200 176,996 431,571 503,137 1,000 504,137 504,137 960,371 232,054 33,200 185,896 16,000 467,150 - - 41,346 303,876 431,571 431,571 508,496 $ 415,642 $ 163,816 65% $ 456,234 $ 40,592 10% $ 456,234 $ 40,592 10% $ 451,875 $ (4,359) -1% • s Fund: 5300 70 Cost Center: Storm Sewer Department Head: Utility Supervisor Activity Type/Code: Enterprise Fund Expenditure Hiehliehts 2018 includes the cost sharing of a new side by side utv. It also includes the operating transfer out of $23,500 for the payback of a new street sweeper and $17,846 for a General Fund Administration allocation. General Activity Description Maintenance of all storm sewers, catch basins, manholes, pipes, ditches, and sediment ponds. Process Used The ditches are cleaned with a backhoe for better drainage and to avoid the ponding of stagnant water. This dirt is hauled away or dumped in low places on ditch banks. When it is dumped on site, it becomes necessary to level and grade the banks to facilitate proper mowing. All catch basins and pipes are cleaned with a vac truck. The material is then hauled away for proper disposal. Occasional use of outside contractors to maintain parts of the system. Televising a portion of the system each year to help comply with new federal regulations. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA 71 CITY OF ANDOVER, MINNESOTA 2018 ANNUAL BUDGET DI'J^FI1vITION < . Internal Service Funds are used to account for goods and services that are provided to other City departments, or to other governments, on a cost reimbursement basis. City of Andover Internal Service Funds 2018 Budget Summary - All Internal Service Funds Statement of Revenues, Expenditures and Changes in Unrestricted Net Assets Unrestricted Net Assets, January 1 Revenues Charges for Services Interest Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures and Other Uses Personal Services Supplies and Materials Other Services and Charges Total Expenditures: Other Uses Transfers Out $ 744,804 $ 956,898 $ 956,898 $ 904,542 1,119,766 9,907 109,594 1,239,267 1,239,267 1,984,071 407,298 280,455 339,420 1,027,173 Total Expenditures and Other Uses: 1,027,173 Unrestricted Net Assets, December 31 $ 956,898 Change in Unrestricted Net Assets $ 212,094 28% 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 $ (45,964) -5% 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 $ (52,356) -5% 1,169,633 3,000 1,172,633 1,172,633 2,077,175 459,048 404,810 360,172 '11,224,030 1,224,030 $ 853,145 $ (51,397) -6% 72 Actual: Adopted Estimate: Adopted.', Descn tion,, 20;46 2D17, 2017.' .; 2018; Unrestricted Net Assets, January 1 Revenues Charges for Services Interest Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures and Other Uses Personal Services Supplies and Materials Other Services and Charges Total Expenditures: Other Uses Transfers Out $ 744,804 $ 956,898 $ 956,898 $ 904,542 1,119,766 9,907 109,594 1,239,267 1,239,267 1,984,071 407,298 280,455 339,420 1,027,173 Total Expenditures and Other Uses: 1,027,173 Unrestricted Net Assets, December 31 $ 956,898 Change in Unrestricted Net Assets $ 212,094 28% 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 $ (45,964) -5% 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 $ (52,356) -5% 1,169,633 3,000 1,172,633 1,172,633 2,077,175 459,048 404,810 360,172 '11,224,030 1,224,030 $ 853,145 $ (51,397) -6% 72 City of Andover Internal Service Funds Central Equipment Maintenance Statement of Revenues, Expenditures and Changes in Fund Net Assets Unrestricted Net Assets, January 1 Revenues Charges for Services Interest Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures and Other Uses Personal Services Supplies and Materials Other Services and Charges Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: Unrestricted Net Assets, December 31 Change in Unrestricted Net Assets $ 412,179 $ 503,069 $ 503,069 $ 429,413 720,592 6,180 481 727,253 727,253 1,139,432 262,035 257,422 116,906 636,363 636,363 $ 503,069 $ 90,890 22% 698,974 2,000 700,974 700,974 1,204,043 278,926 376,360 121,822 777,108 777,108 $ 426,935 $ (76,134) -15% 698,974 2,000 2,478 703,452 703,452 1,206,521 278,926 376,360 121,822 777,108 777,108 $ 429,413 $ (73,656) -15% 700,974 700,974 1,130,387 294,691 376,510 121,322 792,523 792,523 $ 337,864 $ (91,549) -21% 73 Actual :Adopted. Estimate Adopted ,`Desai tion ., 2016 - 2017 201:7 ," 2018 - Unrestricted Net Assets, January 1 Revenues Charges for Services Interest Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures and Other Uses Personal Services Supplies and Materials Other Services and Charges Total Expenditures: Other Uses Transfers Out Total Expenditures and Other Uses: Unrestricted Net Assets, December 31 Change in Unrestricted Net Assets $ 412,179 $ 503,069 $ 503,069 $ 429,413 720,592 6,180 481 727,253 727,253 1,139,432 262,035 257,422 116,906 636,363 636,363 $ 503,069 $ 90,890 22% 698,974 2,000 700,974 700,974 1,204,043 278,926 376,360 121,822 777,108 777,108 $ 426,935 $ (76,134) -15% 698,974 2,000 2,478 703,452 703,452 1,206,521 278,926 376,360 121,822 777,108 777,108 $ 429,413 $ (73,656) -15% 700,974 700,974 1,130,387 294,691 376,510 121,322 792,523 792,523 $ 337,864 $ (91,549) -21% 73 Fund: 6100 7 4 Cost Center: Central Equipment Department Head: Vehicle Maintenance Supervisor Activity Type/Code: Internal Service Fund Expenditure Hiehliehts No major changes planned for 2018. General Activity Description Maintains and repairs all City motorized and non -motorized vehicles and equipment to provide safe operation. Evaluates equipment needs, orders equipment/vehicles and writes specifications. The department maintains nearly 500 pieces of equipment,in addition to normal preventative maintenance procedures of tires, brakes, electrical, fabricating and body work. All work; except automatic transmission overhauls, major engine and major body work are done at the Public Works garage. Staff inspects garbage trucks as part of their licensure process, and performs commercial vehicle inspections required on all applicable City vehicles. Process Used City equipment is scheduled for normal service by miles driven or hours/days of service. Most work is done based on a first -in -first -out with the exception of that emergency repairs are done in the order of importance. Emergency equipment are fire vehicles and snow plow equipment, streets, utilities, and parks. Non -emergency equipment are the Building and Engineering departments, Planning and Zoning department and all other city equipment. ADOPTED 2018 BUDGET CITY OF ANDOVER, MINNESOTA City of Andover Internal Service Funds Risk Management Statement of Revenues, Expenditures and Changes in Unrestricted Net Assets Unrestricted Net Assets, January 1 Revenues Charges for Services Interest Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures and Other Uses Personal Services Supplies and Materials Other Services and Charges Total Expenditures: Other Uses Transfers, Out Total Expenditures and Other Uses: Unrestricted Net Assets, December 31 Change in Unrestricted Net Assets $ 332,625 $ 453,829 $ 453,829 $ 475,129 399,174 459,533 458,533 470,659 3,727 1,000 1,000 1,000 109,113 - - 512,014 460,533 459,533 471,659 512,014 844,639 145,263 23,033 222,514 390,810 390,810 $ 453,829 $ 121,204 36% 460,533 914,362 163,713 27,800 238,850 430,363 430,363 $ 483,999 $ 30,170 7% 459,533 913,362 171,583 27,800 238,850 438,233 438,233 $ 475,129 $ 21,300 5% 471,659 946,788 164,357 28,300 238,850 431,507 431,507 $ 515,281 $ 40,152 8% 75 -,Actual, Adopted, Estimate Adopted, Descri tion. ,. 2016. 2017'2017 2018' Unrestricted Net Assets, January 1 Revenues Charges for Services Interest Income Miscellaneous Total Revenues: Other Sources Transfers In Total Revenues and Other Sources: Total Available: Expenditures and Other Uses Personal Services Supplies and Materials Other Services and Charges Total Expenditures: Other Uses Transfers, Out Total Expenditures and Other Uses: Unrestricted Net Assets, December 31 Change in Unrestricted Net Assets $ 332,625 $ 453,829 $ 453,829 $ 475,129 399,174 459,533 458,533 470,659 3,727 1,000 1,000 1,000 109,113 - - 512,014 460,533 459,533 471,659 512,014 844,639 145,263 23,033 222,514 390,810 390,810 $ 453,829 $ 121,204 36% 460,533 914,362 163,713 27,800 238,850 430,363 430,363 $ 483,999 $ 30,170 7% 459,533 913,362 171,583 27,800 238,850 438,233 438,233 $ 475,129 $ 21,300 5% 471,659 946,788 164,357 28,300 238,850 431,507 431,507 $ 515,281 $ 40,152 8% 75 Fund: 6200 76 Cost Center: Risk Management Department Head: Finance Director Activity Type/Code: Internal Service Fund Expenditure Hiehliehts No major changes planned for 201 S. General Activity Desciption The Risk Management Fund was established to provide funding for compensated absences, safety, training, loss reduction and insurance premium deductibles. Social security and Medicare tax savings resulting from participation in the "cafeteria plan" are recorded in this fund on an annual basis. This fund also functions to mitigate significant rate increases or decreases. Departmental rates are managed by analyzing claims history. Process Used The City Administrator / Finance Director along with the Human Resources Manager promote various safety and wellness programs with the funding received. One of the most notable products is the wellness fitness room. Safety training is provided both in-house and by contracting for service. The city works through a broker and is provided insurance for general liability, automotive and workers' compensation through the League of MN Cities Insurance Trust. ADOPTED 2018 BUDGET CITY OF ANDOVER. MINNESOTA TT Y O F JOVE. 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: August 2017 General Fund Budget Progress Report DATE: September 26, 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 August 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 The Council is requested to receive a presentation from staff. mitted, CITY OF ANDOVER General Fund Budget Summary Totals Budget Year 2017 2016 2017 REVENUES Budget Aug YTD %Bud Final Budget Aug YTD %Bud General Property Tax $ 8,113,528 $ 4,226,438 52% $ 8,217,768 $ 8,420,354 $ 4,364,254 52% Licenses and Permits 346,205 390,446 113% 625,907 367,705 375,361 102% Intergovernmental 673,248 362,789 54% 733,951 766,150 414,000 54% Charges for Services 767,950 575,337 75% 857,163 773,950 507,019 66% Fines 100,750 59,000 59% 88,600 100,750 45,668 45% Investment Income 75,000 7,922 11% 43,747 75,000 19,980 27% Miscellaneous 116,800 116,036 99% 194,802 124,300 123,753 100% Transfers In 196,930 196,930 100% 196,930 196,930 196,930 100% Total Revenues $ 10,390,411 $ 5,934,898 57% S 10,958,868 $ 10,825,139 S 6,046,965 56% 2016 2017 EXPENDITURES Budget Aug YTD %Bud YE - Unaudited Budget Aug YTD %Bud GENERAL GOVERNMENT S 11,003,788 $ 7,266,663 66% S 10,509,726 $ Mayor and Council $ 88,780 $ 66,701 75% $ 86,990 $ 89,991 $ 64,643 72% Administration 192,778 123,990 64% 187,876 199,541 124,956 63% Newsletter 26,000 17,429 67% 22,731 26,000 15,779 61% Human Resources 35,260 12,915 37% 13,403 27,913 14,669 53% Attorney 187,640 107,736 57% 184,990 191,360 110,103 58% City Clerk 157,075 99,531 63% 148,338 148,599 98,264 66% Elections 82,919 43,093 52% 64,433 63,881 14,097 22% Finance 261,016 179,985 69% 252,563 268,129 187,298 70% Assessing 150,000 143,883 96% 146,472 150,000 145,367 97% Information Services 173,483 98,213 57% - 151,386 180,722 99,703 55% Planning & Zoning 435,606 277,832 64% 414,141 462,212 257,841 56% Engineering 509,514 339,938 67% 511,074 535,715 339,335 63% Facility Management 568,201 274,963 48% 408,250 681,733 311,794 46% Total General Gov 2,868,272 1,786,209 62% 2,592,647 3,025,796 1783,849 59% PUBLICSAFETF S 11,003,788 $ 7,266,663 66% S 10,509,726 $ Police Protection 2,936,467 2,202,350 75% 2,936,467 2,962,551 2,221,913 75% Fire Protection 1,294,795 729,735 56% 1,285,416 1,422,522 787,261 55% Protective Inspection 441,807 274,471 62% 424,247 446,688 293,091 66% Civil Defense 22,982 13,359 58% 17,495 24,847 13,540 54% Animal Control 7,950 1,988 25% 3,700 5,950 1,376 23% Total Public Safety 4,704,001 3,221,903 68% 4,667,325 4,8629558 3,3179181 68% PUBLIC WORKS S 11,003,788 $ 7,266,663 66% S 10,509,726 $ Streets and Highways 656,237 497,530 76% 686,087 614,668 397,481 65% Snow and Ice Removal 563,587 332,235 59% 468,174 547,777 296,178 54% Street Signs 204,193 106,728 52% 167,283 215,244 135,928 63% Traffic Signals 35,000 14,590 42% 27,919 37,000 18,555 50% Street Lighting 36,400 22,280 61% 37,089 38,400 15,820 41% Street Lights - Billed 217,500 117,431 54% 200,509 217,500 81,129 37% Park & Recreation 1,257,247 817,967 65% 1247,501 1,275,530 801,726 63% Natural Resource Preservation 10,096 50 0% 7,255 12,697 3,021 24% Recycling 130,927 71,133 64% 124,860 122,221 102,816 84% Total Publie works 3,111,187 1,979,944 64% 2,966,677 3,081,037 1,852,654 60% OTHER Miscellaneous 281,728 254,107 90% 258,577 31,728 14,850 47% Total Expenditures S 11,003,788 $ 7,266,663 66% S 10,509,726 $ 11,039,719 S 6,968,534 63% NET INCREASE (DECREASE) $ (613,377) S (1,331,765) S 449,142 $ (214,580) $ (921,569) NDOVE 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 . WWW.ANDOVERMN.GOV TO: FROM: SUBJECT: DATE: Mayor and Councilmembers Jim Dickinson, City Administrator August 2017 City Investments Review September 26, 2017 INTRODUCTION 0 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 August 2017 the August 2017 Investment Detail Report, and the August 2017 Money Market Funds Report These attachments are intended to assist with discussion when reviewing the August 2017 investments. ACTION REQUESTED Informational. The Council is requested to review and provide feedback to staff. submitted, Investment Maturities - August 2017 Investment Maturities (in Years) Credit Fair Less Than More Than Investment Type Rating Value 1 10 10Money market funds N/A $ 939,989 $ 939,989 $ $ - 11-56- MN Municipal Money Market Fund (4M) N/A 2,008,630 2,008,630 Premier Banks Money Market Fund N/A 261,248 261,248 Certificates of deposit FDIC 13,802,402 9,958,821 3,843,581 Local governments A/Al/A2 558,744 80,731 313,948 60,865 103,200 AA1/AA2/AA3 7,174,841 1,676,876 3,723,642 1,352,614 421,710 AAA 3,601,282 615,264 2,603,599 382,419 - - - State governments A/Al/A2 207,254 - 207,254 AAI/AA2/AA3 1,497,800 495,832 1,001,967 AAA 666,081 60,361 399,108 206,612 U.S. agenciesAAA 6,813,121 1,702,739 4,948,287 38,287 123,809 FNMA REMIC N/A 1,312 1,312 - - - U.S. agencies N/A 1,464,639 1,268,824 195,815 - - Total investments $ 38,997,342 $ 19,070,625 $ 17,237,201 $ 2,040,797 $ 648,719 Deposits 491,770 Total cash and investments $ 39,489,112 August 2017 Investment Detail Description iCusip Number Credit Rating/F DIC .# Type Purchase Price' Carrying Cost Maturity Amount Interest Rate > Current Market Value.Acquired `' �Interes�Paitl :(Date Coupon Date Maturity/. Due Date First Foundation Bank 32026UCN4 58647 CD 245,000.00 245,000.00 245,000.00 0.700% 244,973.05 maturity 12/16/16 none 09/15/17 Bank Leumi USA 063248GF9 19842 CD 245,000.00 245,000.00 245,000.00 0.850% 244,982.85 maturity 12/22/16 none 09/22/17 Morrill and Janes Bank 61778AAT6 1143 CD 245,000.00 245,000.00 245,000.00 1.100% 245,019.60 maturity 06/23/17 none 09/22/17 Mercantil CommerceBank 58733ADB2 22953 CD 245,000.00 245,000.00 245,000.00 0.900% 244,970.60 semi-annual 07/12/16 12/29/16 09/29/17 Bank of India NY 06279HR62 33648 CD 245,000.00 245,000.00 245,000.00 1.250% 245,075.95 maturity 07/20/17 none 10/18/17 Farmers & Merchants Svgs Bk 30856PAG1 9298 CD 249,000.00 249,000.00 249,000.00 1.050% 249,099.60 monthly 01/22/16 02/22/16 10/23/17 Whitney Bk New Orleans LA 966594BAO 12441 CD 245,000.00 245,000.00 245,000.00 1.200% 245,061.25 maturity 07/25/17 none 10/25/17 Luther Burbank - CA 550551CB9 32178 CD 245,000.00 245,000.00 245,000.00 1.150% 245,041.65 maturity 07/27/17 none 10/27/17 First Federal Svgs Bk of Florida 32022WAS5 31313 CD 245,000.00 245,000.00 245,000.00 1.150% 245,039.20 maturity 07/28/17 none 10/30/17 Washington Trust Company 940637HU8 23623 CD 245,000.00 245,000.00 245,000.00 0.750% 244,818.70 maturity 12/05/16 none 11/17/17 PeoplesBank 710465EEJ 90213 CD 245,000.00 245,000.00 245,000.00 1.150% 245,029.40 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 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 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 Valley Cent Svgs Bk Reading OH 91944RAE8 28555 CD 150,000.00 150,000.00 150,000.00 1.250% 150,046.50 monthly 12/22/14 01/22/15 rj12128/17 Safra National Bk 78658QD59 26876 CD 245,000.00 245,000.00 245,000.00 1.000% 244,865.25 maturity 12/29/16 none BankUnited NA 066519CT4 58979 CD 245,000.00 245,000.00 245,000.00 1.100% 244,943.65 maturity 12/29/16 none Bank Baroda New York 06062QY99 33681 CD 245,000.00 245,000.00 245,000.00 1.000% 244,855.45 maturity maturity maturity 03/31/17 07/18/17 06/21/17 none none none 01/18/18 01/24/18 State Bk India NY 856285DA6 33682 CD 245,000.00 245,000.00 245,000.00 1.300% 245,100.45 Beal Bank SSB Plano Tex 07370T6139 32574 CD 245,000.00 245,000.00 245,000.00 1.100% 244,897.10 First Bank_ of Highland _ TCF National Bank Plains Commerce Bank Home Savings & Loan Co 319141EL7 17470 CD 245,000.00 245,000.00 245,000.00 0.850% 244,522.25 maturity 02/22/17 none 02/22/18 872278YZ3 72651LBM5 43731LCF4 _ 28330 CD 245,000.00 245,000.00 245,000.00 0.850% 244,522.25 maturity 02/22/17 none 02/22/18 1678 CD 245,000.00 245,000.00 245,000.00 0.850% 244,495.30 maturity 02/28/17 none 02/28/18 28114 CD 245,000.00 245,000.00 245,000.00 0.900% 244,519.80 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,899.55 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,561.45 maturity maturity 03/15/17 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,627.60 none 03/15/18 Synovus Bank 87164DHW3 873 CD 244,999.78 244,999.78 245,000.00 1.000% 244,740.30 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,044.10 maturity 07/19/17 none 04/19/18 First Financial Bank 3202ISDTO 6600 CD 245,000.00 245,000.00 245,000.00 1.400% 245,117.60 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,193.55 maturity 07/27/17 none 04/27/18 Morgan Stanley Pvt Bank 61760ACH0 34221 CD 245,000.00 245,000.00 245,000.00 1.450% 245,193.55 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,004.90 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,090.65 maturity 08/11/17 none 05/11/18 PlainsCapital Bank 72663QC98 17491 CD 245,000.00 245,000.00 245,000.00 1.350% 244,887.30 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,029.80 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,135.15 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,110.25 maturity 07/20/17 none 07120/18 First National Bank of Omaha 332135HA3 5452 CD 245,000.00 245,000.00 245,000.00 1.450% 244,980.40 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%1 244,936.30 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% 244,936.30 maturity 08/09/17 none 08/09/18 Augusta ME 051411ND4 A3 local 11,250.00 11,250.00 10,000.00 5.250%1 10,028.70 semi-annual 03/07/12 none 10/01/17 9,958,820.74 CD Description p Cusip Number Credit Ratih /F DIf:# Type Purchase Price Carrying Maturity Amount Interest Rotel Current Market Value "Infe�estP di sx, 'qDate Acquired Coupon Date Maturity 1. Due Date Kaufman TX 486206KL8 A3 local 72,922.50 72,922.50 70,000.00 4.000% 70,702.10 semi-annual 06/28/16 02/15/17 02/15/18 Racine Wl 7500216D4 AA- local 101,792.00 101,792.00 100,000.00 2.100% 100,495.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% 143,245.20 semi-annual 12/30/16 none 08/01/18 Regl Transprtn Dist, Denver 759136RR7 AA1 local 254,312.50 254,312.50 250,000.00 2.000% 250,327.50 semi-annual 07/12/16 11/01/13 11/01/17 Dane County Wl 23609IM92 AA1 local 106,487.00 106,487.00 100,000.00 2.450% 100,296.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% 202,952.00 semi-annual 03/04/14 none 03/01/18 New York City NY Transitional 64971QTU7 AA1 local 100,440.00 100,440.00 100,000.00 1.600% 100,221.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,549.00 semi-annual 10/31/12 12/01/12 06/01/18 Prior Lake MN 742617CB7 AA2 local 230,000.00 230,000.00 1 230,000.00 1.000% 229,875.80 semi-annual 05/14/15 12/15/15 12/15/17 Hopkins Minn ISD #270 439881HC0 AA2 local 95,278.40 95,278.40 80,000.00 5.250% 81,237.60 semiannual 04/30/12 08/01/09 02/01/18 Orono MN ISO #278 136LA 6877 AA2 local 115,511.00 115,511.00 110,000.00 4.000% 111,480.60 semi-annual 08/04/16 02/01/17 02/01/18 Chippewa Falls Wl 169772VS6 AA3 local 255,321.30 255,321.30 255,000.00 1.550% 255,196.35 semi-annual 07/31/17 none 04/01/18 Washington County MN 937791KL4 AAA local 115,000.00 115,000.00 115,000.00 3.750% 115,672.75 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% 101,023.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% 152,193.00 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 246,375.00 maturity 06/26/13 none 08/15/18 New Hampshire St Hsg 64469DWUl AA2 state 200,762.00 200,762.00 200,000.00 1.789% 200,236.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% 115,387.55 semi-annual 12109/15 07/01/16 07/01/18 Kansas St Dev Fin Aulh 485429X90 AA3 state 182,743.20 182,743.20 180,000.00 1.877% 180,208.80 semi-annual semi-annual semi-annual 07/12/16 02/09/17 12/08/15 none 11/01/09 03/18/13_ 04/15/18 11/01/17 09/18/17 Virginia St Res Aulh Infrastructure 92817QKSO AAA stale 61,500.00 61,500.00 60,000.00 4.710% 60,361.20 Fed Farm Credit Bank 3133ECA95 AAA US 199,800.00 199,800.00 200,000.00 0.790% 199,972.00 Fed Home Ln Bank 313OA15P9 AAA US 251,187.50 251,187.50 250,000.00 1.000% 250,007.50 semi-annual 07/08/16 none 09/26/17 Fed Farm Credit Bank Fed Home Ln Bank Fed Farm Credit Bank3133EHDQ3 3133EFJMO 313379DT3 AAA US 249,750.00 249,750.00 250,000.00 0.930% 249,537.50 semi-annual 05/25/16 04/13/16 04/13/18 AAA US 250,010.74 250,010.74 250,000.00 1.250% 250,032.50 semi-annual 07/07/17 12/08/12 06/08/18 AAA US 200,042.00 200,042.00 200,000.00 1.180% 200,046.00 semi-annual 03/30/17 06/27/17 06/27/18 Fed Nail Mtg Assn 3135GOE33 - AAA US 249,677.50 249,677.50 250,000.00 1.125% 249,730.00 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,944.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% 103,469.00 semi-annual 09/11/13 none 08/01/18 Fed Nat Mtg Assn Remic 31393EAL3 US 204,187.50 1,328.91 1,301.66 4.500% 1,311.87 monthly 07/30/03 none 08/25/18 FICO Strip, Prin Zero Coupon 31771KAC1 US 295,932.00 295,932.00 300,000.00 299,631.00 maturity 10/23/15 none 10/06/17 FICO Strip Prn-4Zero Coupon 31771EAD3 US 194,572.00 194,572.00 200,000.00 199,754.00 maturity 03/16/15 none 10/06/17 FICO Strip Cpn-E Zero Coupon 31771JXM7 US 215,452.16 215,452.16 224,000.00 223,531.84 maturity 12/11/14 none 11/02/17 FICO Strip Cpn Zero Coupon 31771 EAA9 US 529,947.00 529,947.00 550,000.00 545,022.50 maturity 06/09/14 none 05/11/18 Fed Home Ln Mtg Corp 31393VM01 US 153,656.25 900.70 879.27 4.500% 884.39 monthly 06/30/03 06/15/18 15,860,758.99 Amex Centurion Sk 02587DU63 27471 CD 245,000.00 245,000.00 245,000.00 1.550% 245,014.70 maturity 08/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,051.45 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% 242,848.90 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,484.47 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,437.54 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,591.65 quarterly 07/15/16 10/15/16 07/15/19 PrivateBank & Trust Cc 74267GUQ8 33306 CD 247,000.00 247,000.00 247,000.00 2.000%1 248,435.07 semi-annual 07/21/14 01/21/15 07/22/19 2,372,870.60 local 556,193.55 state 2,972,874.10 US Less Than 1 Year Description Cusip Number Credit Rating/F DIC :# Type - Purchase Price 'Carrying Cost Maturity Amount Interest Rate ` Current Market Value 1 11 4`17f' Intere'st(Paldf °d»�, �„ Date Acquired Coupon Date`. Maturity1 Due Date Goldman Sachs Bank USA 38147JU59 33124 CD 247,000.00 247,000.00 247,000.00 2.050% 248,249.82 semi-annual 07/23/14 01/23/15 07/23/19 Sallie Mae Bank 795450695 58177 CD 245,000.00 245,000.00 245,000.00 1.700% 245,061.25 semi-annual 08/09/17 02/09/18 08/09/19 First Federal Svgs Bk 32021 YCH4 29690 CD 249,000.00 249,000.00 249,000.00 1.500% 250,541.31 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,405.43 semi-annual 09/24/14 03/24/15 09/24/19 Third Federal Sav & Loan 884130AW8 30012 CD 128,000.00 128,000.00 128,000.00 2.000% 128,993.28 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,754.05 semi-annual 12/20/13 06/20/14 12/20/19 Stearns Bank NA 857894PB9 10988 CD 247,000.00 247,000.00 247,000.00 1.000% 248,971.06 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,905.83 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,835.13 monthly 07/18/14 08/18/14 07/20/20 Elbow Lake MN 284281KC5 A local 170,045.70 170,045.70 165,000.00 2.750% 168,205.95 semi-annual 12/08/14 none 12/01/19 Oneida County NY 6824543R2 Al local 45,755.20 45,755.20 40,000.00 6.250% 41,963.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% 103,779.00 semi-annual 05/28/08 03/01/09 09/01/18 Farmington MN 311297W84 AA local 102,787.00 102,787.00 100,000.00 2.000% 101,606.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,655.60 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,009.90 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,387.15 semi-annual 02/16/12 04/01116 04/01/19 Rothsay MN ISD #850 778731AZ2 AA+ local 208,640.25 208,640.25 195,000.00 3.000% 204,726.60 semi-annual 07/06/16 none 02/01/20 Saint Paul MN Port Auth 793067CC1 AA+ local 79,756.80 79,756.80 80,000.00 2.000% 80,350.40 semi-annual 01/10/17 09/01/17 03/01/20 Stearns Cc MN 857896MH4 AA+ local 276,875.00 276,875.00 250,000.00 4.500% 250,525.00 semi-annual 04/17/13 none 06/01/20 Minnetrista MN 604229KG8 AA+ local 161,038.40 161,038.40 160,000.00 3.100% 160,174.40 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% 26,239.00 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% 102,650.00 semi-annual 06/05/12 12/01!11 12/01/18 Cedar Rapids IA Multnomah Cnty OR Sch Dist IJ Minneapolis MH Hampton VA 150528RM1 625517JMO 60374YS81 AAI local 217,672.00 217,672.00 200,000.00 3.000% 205,148.00 semi-annual 06/11/13 12/01/13 06/01/19 _ AA1 local 250,000.00 250,000.00 250.000.00 1.450% 250,595.00 semi-annual 08/10/17 12/15/17 06/15/19 AA1 local 278,632.50 278,632.50 250,000.00 3.500% 260,327.50 semi-annual 02/26/13 none 12/01/19 4095582,11 AA1 local 100,836.00 100,836.00 100,000.00 2.209% 101,224.00 semi-annual 01/20/16 none 04/01/20 Middleton Wl 596782RX2 AA1 local 106,979.00 106,979.00 100,000.00 3.750% 102,225.00 semi-annual 02/24/15 none 09/01/20 Des Moines IA Area Cmnty Col 2500971121 AA1 local 50,606.00 50,606.00 50,000.00 2.450% 51,292.00 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% 246,064.80 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% 156,323.70 semi-annual 12/22/16 none 06/01/19 Watedoo IA 941647PA1 AA2 local 50,559.50 50,559.50 50,000.00 2.000% 50,398.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,672.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% 301,646.35 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% 110,035.20 semi-annual 08/21/15 none 05/01/20 Fon Du Lac Cnty WI 344442KK3 AA2 local 259,715.00 259,715.00 250,000.00 3.250%° 258,010.00 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,568.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% 101,540.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,248.00 semi-annual 06/09/11 none 12/01/20 King Cnty WA 49474E3L5 AAA local 224,634.00 224,634.00 200,000.00 3.980°! 205,888.00 semi-annual 03(27112 none 12/01/18 Minnetonka MN ISD#276 604195RA7 AAA local 37,433.20 37,433.20 35.000.00 3.100% 35,557.20 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% 157,237.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,403.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,788.80 semi-annual 08/04/10 08/01/11 08/01/19 3,843,580.94 CD Description Cusip Number Credit Rating/F D101# Type PurchasePrice Carrying Cost Maturity Amount Interest Rate Current Market Value. r•+� 04'14- 3`� eye 0: nterestpaltl- +y -n+ s ; a� ,4i2,,;.�.t .Date Acquired Coupon Date' Maturity/ Due Date. Greensboro NC 39546OV21 AAA local 366,832.80 366,832.80 360,000.00 3.263% 369,302.40 semi-annual 07/15/11 none 10/01/19 Saint Paul AN PortAuth 793028WS6 AAA local 201,806.00 201,806.00 200,000.00 2.000% 202,614.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% 116,934.30 semi-annual 12/22/11 none 02/01/20 Dallas TX Indpt Sch Dist 235308QK2 AAA local 116,900.00 116,900.00 100,000.00 4.450% 106,545.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,144.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,650.00 maturity 03/18/13 none 07/15/20 McAllen TX Dev Corp 579086AW9 AAA local 175,000.00 175,000.00 175,000.00 1.400% 173,157.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% 252,550.00 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% 50,235.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% 100,241.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,352.00 semi-annual 02/20/15 none 12/01/21 Connecticut State 20772JQN5 Al stale 214,954.00 214,954.00 200,000.00 3.517% 207,254.00 semi-annual 05/27/16 02/15/14 08/15/21 Washington State 939758DL9 AA state 205,804.00 205,804.00 200,000.00 4.500% 205,852.00 semi-annual 01/24/12 04/01/12 10/01/18 Massachusetts State 57582P2T6 AA1 state 199,744.00 199,744.00 200,000.00 2.090% 201,884.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% 277,511.40 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,432.00 semi-annual 02/26/15 10/01/15 10/01/20 Florida St Dept Environmental 3416OWUAO AA3 state 217,800.00 217,800.00 200,000.00 6.206% 216,288.00 semi-annual 08/30/10 07/01/10 07/01/22 Georgia State 373384RQ1 AAA state 26,742.50 26,742.50 25,000.00 2.970% 25,426.25 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,692.00 semi-annual semi-annual 08/10/11 08/30/16 04/01/12 02/01/12 10/01/18 08/01/20 Tennessee State 880541QQ3 AAA state 48,218.85 48,218.85 45,000.00 3.178% 46,899.90 Virginia State 928109XD4 AAA stale 22,126.00 22,126.00 20,000.00 4.100% 20,811.40 semi-annual 02/07/12 none 06/01/21 Kentucky St Hsg Corp 49130TSHO AAA stale 203,458.00 203,458.00 200,000.00 2.780% 204,278.00 semi-annual 03/29/17 none 07/01/21 Fed Farm Credit Bank Govt Natl Mtg Assn Fed Farm Credit Bank Fed Farm Credit Bank 3133EGK87 3136G1LU1 3133EHQF3 AAA US 199,462.00 199,462.00 200,000.00 1.020% 199,410.00 semi-annual 03/30/17 none 09/24/18 AAA_ US 448,245.00 448,245.00 450,000.00 1.060% 447,079.50 semi-annual 08/21/17 none 11/14/18 AAA US 249,870.00 249,870.00 250,000.00 1.350% 250,042.50 semi-annual 07/07/17 01/07/18 01/07/19 3133EG3X1 AAA US 199,711.60 199,711.60 200,000.00 1.250% 199,796.00 semi-annual 06/16/17 07/17/17 01/17/19 Fed Nall Mtg Assn 3136GOY70 AAA US 199,300.00 199,300.00 200,000.00 1.080% 199,316.00 semi-annual 10/30/12 01/30/13 01/30/19 Fed Farm Credit Bank 31330NO AAA US 99,587.00 99,587.00 100,000.00 1.250% 99,677.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% 251,425.00 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,618.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% 250,540.00 semi-annual 07/07/17 09/08/12 03/08/19 Fed Nail Mtg Assn 3136FY0 AAA US 200,000.00 200,000.00 200,000.00 1.375% 200,088.00 semi-annual 06/22/17 none 03/13/19 Fed Natl Mtg Assn 3135GOK28 AAA US 299,700.00 -299,700.00 300,000.00 1.250% 299,052.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% 249,407.50 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% 198,196.00 quarterly 08/23/16 11/23/16 08/23/19 Fed Home Ln Mtg Corp Med Term Note 3134GALU6 AAA US 249,835.00 249,835.00 250,000.00 0.800% 249,977.50 semi-annual 03/29/17 03/30/17 09/30/19 RFCSP Strip Principal Zero Coupon 76116FAA5 AAA US 185,568.00 185,568.00 200,000.00 193,636.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% 198,864.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 962,410.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%1 100,052.00 semi-annual 07/22/15 08/10/15 02/10/20 Fed Nall Mtg Assn 3136G4JM6 AAA US 200,000.00 200,000.00 200,000.00 1.850% 199,700.00 semi-annual 12/28/16 06/28/17 12/28/20 FICO Strip Cpn13 Zero Coupon 31771C2G9 US 93,140.00 93,140.00 100,000.00 98,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 97,689.00 maturity 04/17/15 none 02/01/19 6,641,189.20 local 1,608,328.95 state 5,144,102.00 US Description Cusi p Number Credit Rating/F :DIC.# Type Purchase Price. Carrying Cost Maturity ty Amount Interest Rate' Current: Market Value InterasfPaW r ;.� ,. .�,, ., t. Date ., Acquired Coupon Date Maturity{ Due Date 17,237,201.09 Kaufman TX 486206KR5 A3 local 61,821.00 61,821.00 60,000.00 3.000% 60,865.20 semi-annual 06/28/16 02/15/17 02/15/23 Chaska MN 1616636S3 AA local 104,657.00 104,657.00 100,000.00 4.000% 103,352.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,398.00 semi-annual 12/20/11 06/15/19 06/15/24 MinnetristaMIN 604229KJ2 AA+ local 40,000.00 40,000.00 40,000.00 3.850% 40,056.80 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% 206,532.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,051.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% 105,345.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% 104,458.00 semi-annual 10/31/11 none 03/01/23 Minneapolis MN 60374YG76 AA1 local 72,201.35 72,201.35 65,000.00 4.800% 67,945.80 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% 282,317.40 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% 30,027.60 semi-annual 12/05/12 08/01/13 02/01/25 W Palm Beach FL 955116BE7 AA3 local 101,245.00 101,245.00 100,000.00 2.264% 99,174.00 semi-annual 07/05/16 10/01/16 10/01/22 Hawkins Cnty TN 420218PL7 AA3 local 111,480.00 111,480.00 100,000.00 4.800% 102,956.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% 132,419.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 373384208 AAA state 204,444.00 204,444.00 200,000.00 2.780% 206,612.00 semi-annual 12113/16 none 02/01/23 Fed Home Ln Bank 3130A8W33 AAA US 39,000.00 39,000.00 40,000.00 2.100% 38,286.80 semi-annual 07/27/17 08/22/17 08/22125 2,040,796.60 Itasca CountyMinn 465452GP9 A local 105,024.00 105,024.00 100,000.00 5.550% 103,200.00 semi-annual 07/12/11 none 02/01/28 Van Buren Mich Public Schools Will County IL Cmnly Zero Coupon Fed Farm Credit Bank _ 920729HD5 969078QM9 31331VLC8 AA1 local 102,750.00 102,750.00 100,000.00 6.430% 107,130.00 semi-annual 07/17/09 11/01/09 05/01/29 AA2 local 159,000.00 159,000.00 500,000.00 314,580.00 maturity 08/25/09 none 11/01/27 AAA US 106,030.45 106,030.45 100,000.00 5.250% 123,809.00 semi-annual 02/26/10 none 04/21/28 648,719.00 35,787,475.68 1- 5 Years 1,795,897.80 local 206,612.00 state 38,286.80 US 6 - 10 Years 524,910.00 local 123,809.00 US 10+ Years INVESTMENT SCHEDULE - Money Market Funds August 31, 2017 Description Current Market Value YTD Interest Wells Fargo i lWells Fargo Government Money Market Fund $939,988.661 $4,734.51 4M 1 14M 1,002,193.821 299.08 4M PLUS I 14M Plus 1,006,435.72 3,328.17 1. Premier Bank 1 Premier Bank Money Market 261,247.64 434.41 Grand Total Money Market Funds 1 $3,209,865.84 1 $8,796.17 Updated: 9114/2017