The URL can be used to link to this page

Home My WebLink AboutWK - March 28, 2017C I T Y O F ND OVE 1685 CROSSTOWN BOULLVAKU N.W. • ANUUVLK, MINNLSU IA 5530 FAX (763) 755-8923 • WWW.ANDOVERMN.GOV City Council Workshop Tuesday, March 28, 2017 Conference Rooms A & B Call to Order — 6:00 p.m. 4 • (763) 755-5100 2. Joint Meeting with Planning & Zoning Commission — Administration/Planning a. Zoning Text Amendment Rural Reserve b. Atlas 14 Discussion c. Flag Lot Discussion d. Other Discussion Discuss Automatic Meter Reading (AMR) for Commercial Properties - Engineering 4. 2018-2022 CIP Discussion & 2017 CIP Progress Report 5. 2018 Budget Development Discussion -Administration 6. February 2017 Budget Progress Report - Administration February 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 Councilmembers Planning and Zoning Comm: CC: Jim Dickinson, City Administrator Joe Janish, Community Developme i ectorq FROM: Stephanie L. Hanson, City Planner SUBJECT: Joint Discussion Meeting with Planning and Zoning Commission: Zoning Text Amendment (ZTA) Rural Reserve and Other Business DATE: March 28, 2017 DISCUSSION a. ZTA - Rural Reserve 0 On March 21, 2017, City Council approved the CPA for the rural reserve area. Staff is in the process of submitting the CPA request to the Met Council for formal approval. The CPA will allow land owners within the rural reserve area the opportunity to subdivide lands at a density of no more than 4 units per 40 acres. Landowners will have 2 options: Create a lot split that allows a density of 4 units per 40 acres with the rest of the undeveloped land preserved for future urban development. Minimum lot size required is 5 acres. To comply with Met Council policies, this would require compliance with City Code and potential new zoning code provisions. 2. Create a lot split that allows a density of 4 units per 40 acres. Minimum lot size required is 10 acres. This complies with Met Council policies; however, does not require new zoning code provisions. The next step is to adopt zoning code provisions to regulate lot splits within the rural reserve area. Staff recommends the following to be discussed: Proposed Minimums for Lot Area, Width, Depth, Road Frontage and House Placement Lot Area: Minimum 5 acres Lot Width: 300 feet at the front yard setback Lot Depth: Minimum 150 feet Road Frontage: Minimum 300 feet of right-of-way frontage House Placement: House placement and private utilities should not impede the further urban subdivision of the land Submittal Process/Regulations Discussion • Current city code regulations does not require a public hearing for metes and bounds lot splits of 5 acres or more. Should a public hearing be required for lot splits within the rural reserve area? Or should the lot split approvals come through the Planning and Zoning Commission and City Council without a public hearing? • The 5 acre lot splits within the rural reserve area is still required to meet the Met Council density requirement of 4 units per 40 acres. With this in mind, a maximum number of 4 homes are allowed on a 40 acre parcel. The remaining land will be preserved for future development. City staff will continue to work with the City Attorney regarding recordable legal documents (deed restrictions, provision of easement, etc) to ensure the protection of the remaining land in the best way possible. Are there other concerns? • At a minimum, staff recommends the 5 acre lot splits should show how the lots can be further divided in the future to provide for an increased density. Should this be required if the lot split creates a 10 acre parcel as well or just for 5 acre parcels? • Plan details: what is the extent of the details required for the submittal process? • Lot Split vs Platting. What are the pros and cons of each as it pertains the rural large lot divisions? • The lot split(s) should not create land locked parcels. OTHER BUSINESS b. Atlas 14 Atlas 14 is new rainfall distribution data compiled by a large number of observation stations across the country, including Minnesota. The new data has resulted in an increase in rainfall depths and run-off volumes. The Coon Creek Watershed District has consulted with Wenck Associates to update the existing model with the new data. The new data suggests the floodplain within Andover, especially within the rural reserve area, has grown significantly. Once City Staff receives the data, it is suggested a joint work session between the City Council and Planning and Zoning Commission be schedule. This is important information that will need to be considered as the City moves forward with the 2018 Comprehensive Plan update. C. Flag Lots Recently, City Staff has been contacted about the potential of creating a flag lot in the rural residential area. Current code regulations do not allow flag lots since each lot is required to have a width of 300 feet at the front yard setback and a minimum of 50 feet of road frontage. Is there support to explore the option of allowing flag lots? d. OTHER BUSINESS ACTION REQUIRED The City Council and Planning and Zoning Commission are requested to have a joint discussion regarding the proposed ZTA and other items and to provide staff with direction. Respectfully S4,ed, Stephanie L. Hanson City Planner Y O%F OVE. 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 Berkowitz, Director of Engineer N SUBJECT: Discuss Automatic Meter Reading (AMR) for Commercial Properties - Engineering DATE: March 28, 2017 The City Council is requested to discuss Automatic Meter Reading (AMR) for commercial properties. DISCUSSION AMR is a system that allows a radio frequency hand held meter reader to collect meter readings by simply driving by the commercial property. This will save on City staff time to coordinate the meter reading with the property owner and will provide more efficient process of data collection and less human error. The current process and AMR process will be discussed in more detail at the meeting. This will serve as a pilot project for future residential meter reading. Attached is more detail on AMR and the benefits that it provides. Also attached are implementation costs from various vendors that will be discussed at the meeting. BUDGETIMPACT Implementation of this program will reduce staff time collecting meter readings; provide timely and more accurate reads and better service for our customers. The cost of this program would be funded through previous year's savings from operations. ACTION REQUIRED The City Council is requested to discuss AMR and direct staff on how to proceed with the pilot project. Respectfully submitted, �V o David D. BoDavid D. Berkowitz, P.E. Attachment: AMR Detail Information & Cost Estimates Reduce Costs, Calls and Foot Traffic with Real -Time AMR Meter Reads Meter readers handle a flood of data every day and entering that data manually can increase the chance for human error. Making sure your data is accurate, on time and analyzed is key to increasing cash flow, not to mention customer satisfaction. Sensus Automatic Meter Reading (AMR) solutions let you automatically collect consumption, diagnostic and status data from the water meters and then transfer that data to a central database for billing and analysis. SmartPoints are our robust, high-powered radio-frequency transmitters that provide inbound and outbound access to measurement and other diagnostics. They are available for use with walk -by or drive-by automated meter reading systems, and offer a choice of meter reading options. A hand-held unit can be used for reading SmartPoint modules or for manually entering visual readings by meter readers on foot. A more powerful Vehicle Gateway base station (VGB) provides greater range for any vehicle to read meters as they drive past SmartPoint modules. The effective range of the VGB is measured in miles, not feet. Upon returning to the office, these devices attach easily to your computers for downloading the data into your system. And when you're ready to upgrade to Advanced Metering Infrastructure (AMI), our solutions allow you to easily migrate your AMR infrastructure to our fixed -base FlexNet® communication network. Benefits to Andover • Lowers the cost of meter reading over time. • Provides real-time billing information, reducing estimated readings and re -billing costs • Enhances employee, customer safety and providing safer reading methods • More Accuracy - Reduces billing errors and disputes • Enables flexible reading schedules, eliminating delays in summary billing of commercial accounts • Increases cash flow by allowing quarterly or semi-monthly accounts to be converted to monthly billing • Reduces customer complaint calls and increases customer satisfaction • Monitors tampering and theft • Promotes energy conservation and customer savings with time -of -use consumption • Eliminates the need for business owners to be there to let an employee in to read the meter. Benefits to Andover Customers • Reduces billing errors Increases confidence in service Increases information about usage and empowers them to conserve resources and save money By starting with the Commercial, Institutional and City meters (154meters), you can get a handle on how this system will work and basically get the bugs out before switching over to read the entire water system that includes 6400+ residential meters. • SUPPLY WATERWORKS Bid Proposal for Radioread Upgrade Rev3 ANDOVER WATER DEPT HD Supply Waterworks Job Location: Andover, MN 15800 W 79th St Bid Date: 12/21/2016 02:00 p.m. Eden Prairie, MN 55344 HD Supply Bid #: 209510 Phone: 952-937-9666 Fax: 952-937-8065 Seq# Qty Description Units Price Ext Price 10 EQUIPMENT & SOFTWARE UPGRADE 30 OPTIONAL TRIMBLE UNIT 40 0 TRIMBLE 1050LE HANDHELD DEVICE 60 1 AUTOREAD SOFTWARE INCLUDES FIRST YEAR SUPPORT 80 ABOVE PACKAGES INCLUDES 90 COMMAND LINK 100 SET UP AND TRAINING _ 120 ENDPOINTS 140 100 510M SINGLE PORT TOUCH COUPLED ENDPOINT ISO ABOVE TO FIT OVER OVAL STYLE 160 TOUCH PAD 180 100 510M 3 WIRE ENDPOINT 200 PRICES DO NOT INCLUDE TAX EA 3,600.00 EA 2,740.00 EA 115.00 EA 110.00 33b" -aee- 2,740.00 11,500.00 11,000.00 Tax 0.00 Total ==5,�� '2-' ^--a tE a ¢aF�`Fd. 12/21/2016 - 8:51 AM Actual taxes may vary Page 1 of 2 ANDOVER, MN 'a BADGER AMR/AMI COST EVALUATION Badger Orion ME Migrateable Endpoint Solution Based On 200 Endpoints A j. lSP1 Orion Cellular Model 25 Bronze Costs Associated with Badger Orion ME/SE Meter Complete Software /Training / Orion ME Mierateable Endpoint Alone, With Encoded Software Fees / Training / Mobile AMR Solution Less Meter/ Less Register and Engagement Fee ar.pa Encoder Orion ME/SE 11116/ Laa Endpoint Badger Orion ME Endpoint 2°' $88.00 ea. $175.00 ea. $2,136.00/Yr. Initial Costs—Engagement/ $ .89 ea. $6,000.00 Mobilization Fee / One -Time Fee $6,000.00 Hardware—Trimble Handheld $6000.00 $1,300.00 .08/meter/yam $192.00/Yr. Other Costs—Annual Software Costs Other Costs — One -Time Training Fee $2,800.00 A j. lSP1 f545 Brown Deer Rood, Mllwaukee, Wdconsln 532249536 Ph: 8OD-876-3837 w .badgermetercnm Orion Cellular Model 25 Bronze r Orion Endpoint Alone, Meter Complete With Encoded Software /Training / Less Meter / Less Register and Engagement Fee Encoder Beacon Endpoint ar.pa /�fi Vdo $92.00 $179.00 $2,136.00/Yr. $ .89 ea. One- $6,000.00 $1,300.00 f545 Brown Deer Rood, Mllwaukee, Wdconsln 532249536 Ph: 8OD-876-3837 w .badgermetercnm Itron electric /Gael avatar Pricing Summary for Information collection, analysis and application City of Andover, MN 2111 N. Moller Rd. UteMLake, VVA99019 - BMR.411647-16 Vet Nov fax 866-787-6910 Nowouber29, 20ft xs`x2mn Cam Item Part Number Description Day Unit Price Extended Price Notes Hardware 1 IMR-0900-001 Itron Mobile Radio w/USB cable and charger 1 $1,995.00 $1,995.00 (1) Hardware Total $1,995.00 Software 2 FCSHH FCS Software License up to 2,500 Endpoints $1,800.00 (3-5) 3 Subscription Itron Mobile Walk -By Only Subsoripfion for up to 2,500 Endpoints $240.00 Software and Itron Mobile Total $2,040.00 Professional Services 4 Services FCS Implementation and Training Services $8,575.00 (6) 5 Services Estimated Travel and Expenses $2,125.00 (6) Professional Services Total $10,700.00 Total $14,735.00 Annual Maintenance 6 Maintenance FCS Software License up to 2,500 Endpoints 1 $720.00 $720.00 7 Maintenance than Mobile Radio wNSB cable and charger 1 $125.00 $125.00 Annual Maintenance Total $845.00 Notes and Assumptions 10/a sIra , P- (1) (1) Itron Mobile Radio is expected to be available for delivery 02. 2017. r (2) Pricing does not include cellular service or cellular phone activation. Devices must be preselected for the targeted cellular service and are not capable to be retrofitted for a different cellular service. (3) FCS Software License includes one copy of Crystal Reports 2013 Developer. Additional copies can be purchased separately at $595.00 each. (4) Pricing shown here does not include third party products needed for this system such as servers, PCs, operating systems, and Oracle or SOL Server database server (5) The Software Maintenance start date Is effective as of date of shipment unless otherwise specified in a contract. (6) Professional services pricing is an estimate and is based on assumptions that have not been confirmed. In order to create a formal Scope of Work and a more accurate professional services bid, a detailed discussion of actual project requirements will be necessary. Travel and expenses have been estimated above and will be billed at actual. (7) Freight and taxes are not included. Prices are in US dollars. Prices are valid for 90 days. / �D Confidential Confidential Company Information Shipping and Taxes not included QUOTATION DAKOTA SUPPLY GROUP For all the right connecwl l DSG Metering Technology Brad Simms 620 16th Avenue South Territory Manager Hopkins, MN 55343 bsimmsc@dsginc.biz Company: (952) 890-3811 Mobile: (952) 300-0352 DATE: November 17, 2016 TO: REFERENCE: City of Andover 1685 Crosstown Blvd NW Itron Automated Meter Reading (AMR) Solution Andover, MN 55304 QTY DESCRIPTION PRICE Itron Communication Module (ERT) - Option #1 ANY 100W+ Remote -style Water Communication Module (ERT) $ 82.00 ANY 100W+ Remote Backplate $ 3.00 Itron Communication Module (ERT) - Option #2 ANY 100W+ Pit -style Water Communication Module (ERT) with In-line Connector $ 82.00 m i BY: This quotation is good fora 90 -DAYS Confidential Company Information Shipping and Taxes not included 1 F^ ,NDOVE 1685 CROSSTOWN BOULEVARD N.W. • ANDOVER, MINNESOTA 55304 • (763) 755-5100 FAX (763) 755-8923 • WWW.CI.ANDOVER.MN.US TO: FROM: SUBJECT: DATE: Mayor and Councilmembers Jim Dickinson, City Administrator 2018-2022 CIP Discussion & 2017 CIP Progress Report March 28, 2017 INTRODUCTION In late March, Administration/Finance will distribute baseline worksheets to Department Heads for the 2018-2022 CIP kick-off. Subsequent discussion will center on the 2018-2022 CIP development and the need of other committees (Vehicle Purchasing & Facility Management Committees) and commissions (Parks and Recreation & Community Center Advisory) to start their work. DISCUSSION To assist with the 2018-2022 CIP discussion, I have attached for the Council's reference a progress report on the 2017 Capital Improvement Plan projects and a complete listing of the 2018-2022 CIP projects . Throughout the summer it is anticipated that a significant amount of time will be spent on evaluating utility infrastructure, transportation improvements, building maintenance, equipment and park and recreation needs. Each of these items will be supported by a detailed fund balance analysis of funding sources (based on various assumptions and estimates) that will be presented to the Council for review at future workshops. At this time the Staff would like the secure the Council's priorities to assure that those priorities are taken into consideration while staff develops a draft 2018-2022 CIP. ACTION REQUESTED The Council is requested to review the various attachments, receive a brief presentation, and provide direction to staff on Council priorities for the 2018-2022 CIP. submitted, CITY OF ANDOVER 2017 Capital Improvement Plan Projects By Department - Use of Funds Community Center Exterior Painting $ 6,000 summer project ACC/YMCA Expansion 75,000 Community Survey / RFP over summer Replacement - Security Management System 81,000 out for quotes Emergency Management 50,000 RFP's are out Emergency Operations Center Improvement 40,000 under construction Replacement - Emergency Sirens 45,000 out for quotes Fire 85,000 Engineering 20,000 ordered New Development Projects 160,000 ongoing Pedestrian Trail Maintenance 50,000 bids have been received New Pedestrian Trail and Sidewalk Segments 565,000 Andover Blvd - late summer; Crosstown - ROW issues Pedestrian Trail Reconstruction 60,000 summer Pedestrian Curb Ramp Replacements 15,000 summer LED Crosswalk Warning System 21,000 summer 871,000 Facility Management Annual Parking Lot Maintenance 90,000 summer Replacement - Carpetlrile 10,000 scheduling Replacement - Security Management System 100,000 out for quotes Public Works Relocation / Expansion 50,000 RFP's are out HD Upgrade - City Hall Council Chambers 60,000 late summer / early fall 310,000 Fire Replacement -Turnout Gear 20,000 ordered Replacement - Extrication (Rescue) Equipment 80,000 ordered 100,000 Park & Recreation - Operations Replace/Repair Play Structures - Various Parks 50,000 play structure has been ordered Replace/Repair Major Park Projects - Various Parks 25,000 ongoing Replacement - One Ton Crew Cab Truck 50,000 ordered New - Trail Machine 150,000 demo'ed various models $ 275,000 Park & Recreation - Projects Annual Miscellaneous Projects $ 15,000 ongoing Fox Meadows Park - Renovation 457,300 out for bids Pine Hills North - Phase II 100,000 no funding for building Irrigation Projects - Small Parks 20,000 water service at Bunker Hills & Wild Iris Nordeen's Park Basketball Court 7,500 summer 599,800 Planning & Zoning Replacement - Planning Vehicle #7 30,000 ordered Sanitary Sewer Sanitary Sewer Extensions 105,000 dependent on development Replacement - JeWac Truck #99 460,000 ordered Lift Station #4 Upgrade 50,000 summer 615,000 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 bids have been received Annual Street Crack Seal Project 160,000 bids have been received Annual Pavement Markings 42,000 bids have been received Annual Curb Replacement 50,000 summer Municipal State Aid Routes / New & Reconstruct 1,300,000 out for bids Annual Street Reconstruction 1,236,000 out for bids Gravel Road Improvement 15,000 summer Replacement - One Ton Truck w/ Plow #134 80,000 ordered New One Ton Truck w/ Regular box, lift 55,000 ordered New - Bobcat Paver 20,000 purchased 3,683,000 Water Rehabilitation of Wells 50,000 summer Replacement - Dodge Dakota #95 30,000 ordered 80,000 Grand Total $ 6,794,800 City of Andover, MN Capital Plan 2017 thru 2021 DEPARTMENT SUMMARY Department 2017 2018 2019 2020 2021 Total Building 35,000 35,000 Central Equipment 40,000 40,000 Community Center 81,000 248,000 7,879,000 589,000 268,000 9,065,000 Emergency Management 85,000 63,000 52,500 45,000 245,500 Engineering 871,000 569,500 607,000 1,088,000 809,000 3,944,500 Facility Management 310,000 580,000 9,025,000 115,000 40,000 10,070,000 Finance 150,000 150,000 Fire 100,000 190,000 510,000 635,000 55,000 1,490,000 Information Technology 12,000 12,000 Park&Rec - Operations 275,000 300,000 241,000 102,000 75,000 993,000 Park&Rec - Projects 599,800 35,000 35,000 457,500 15,000 1,142,300 Planning & Zoning 30,000 30,000 Sanitary Sewer 615,000 1,250,000 1,865,000 Storm Sewer 55,000 280,000 260,000 62,000 65,000 722,000 Street Signs 10,000 10,000 Streets/Highways 3,683,000 2,857,000 3,673,000 2,986,000 4,636,000 17,835,000 Water 80,000 798,000 1,660,000 50,000 50,000 2,638,000 TOTAL 6,794,800 7,222,500 24,127,500 6,129,500 6,013,000 50,281,300 City of Andover, MN Capital Plan 2017 thru 2021 FUNDING SOURCE SUMMARY Source 2017 2015 2019 2020 2021 Total Assessments 657,000 880,500 1,140,000 388,000 332,000 3,397,500 Capital Equipment Reserve 885,000 205,000 277,500 438,000 75,000 1,880,500 Comm Ctr Operations 66,000 48,000 79,000 49,000 268,000 510,000 Construction Seal Coat Fund 17,000 8,000 10,000 10,000 10,000 55,000 Donations 100,000 100,000 Equipment Bond 688,500 1,111,000 1,082,000 220,000 3,101,500 G.O. Bond 650,000 16,750,000 537,000 17,937,000 General Fund 95,000 95,000 95,000 95,000 95,000 475,000 Grant 265,000 1,600,000 1,865,000 Municipal State Aid Funds 1,057,000 1,029,500 1,546,000 335,000 750,000 4,717,500 Park Dedication Funds 499,800 35,000 35,000 177,500 15,000 762,300 Road & Bridge Funds 2,048,000 1,590,000 1,644,000 1,996,000 1,953,000 9,231,000 Sanitary Sewer fund 245,000 116,000 361,000 Sewer Trunk Fund 397,000 1,267,000 120,000 125,000 125,000 2,034,000 Storm Sewer Fund 55,000 76,000 60,000 62,000 65,000 318,000 Trail Funds 565,000 225,000 710,000 400,000 1,900,000 Water Fund 65,000 126,000 950,000 75,000 50,000 1,266,000 Water Trunk Fund 43,000 183,000 45,000 50,000 55,000 376,000 GRAND TOTAL 6,794,800 7,222,500 24,127,500 6,129,500 6,013,000 50,287,300 City of Andover, MN Capital Plan 2017 thin 2021 PROJECTS & FUNDING SOURCES BY DEPARTMENT Department Project# Priority 2017 2018 2019 2020 2021 Total Buildimx 1 Replacement - Small Extended Cab Pick Up #8 1942300-01 1 35,000 35,000 Equipment Bond 35,000 35,000 Building Total 35,000 35,000 (Central Equipment Replacement- Service Truck #371 1848800-01 2 40,000 40,000 Equipment Bond 40,000 40,000 Central Equipment Total 40,000 40,000 Community Center Exterior Painting 1744000-01 1 6,000 6,000 Comm CtrOperations 6,000 6,000 ACC/YMCA Expansion 17-44000-02 2 75,000 200,000 6,725,000 7,000,000 Capital Equipment Reserve 75,000 75,000 G.O. Bond 200,000 6,725,000 6,925,000 Replacement - Carpeting 18-44000-01 1 18,000 12,000 30,000 Comm Ctr Operations 18,000 11,000 30,000 Replacement - Skate Sharpener 18-44200-01 1 10,000 10,000 Comm Ctr Operations 10,000 10,000 Replacement- Pickleball InsertslNet System 18-44400-01 1 10,000 10,000 Comm Ctr Operations 10,000 10,000 New -Inflatables 18-44400-03 1 10,000 10,000 Comm Ctr Operations 10,000 10,000 Replacement- All Community Center Doors 19-44000-02 1 75,000 75,000 G.O. Bond 75,000 75,000 Refacing Rink Boards 19-44300-01 1 25,000 25,000 Comm Ctr Operations 25,000 25,000 Repaint Ice Arena ceiling 1944300-02 1 25,000 25,000 Comm Ctr Operations 25,000 25,000 Replacement- Ice Arena Refrigeration Replacement 1944300-03 1 1,000,000 1,000,000 G.O. Bond 1,000,000 1,000,000 Replacement- Heat Exchangers - Munters Unit 19-44300-04 1 15,000 15,000 Comm Ctr Operations 15,000 15,000 Replacement- Zamboni Battery Pack 19-44300-06 1 14,000 14,000 Comm Ctr Operations 14,000 14,000 Replacement - Scissor Lift 20-44000-01 1 15,000 15,000 Equipment Bond 15,000 15,000 Replacement - Lobby Furniture 20-44000-02 1 15,000 15,000 Comm Ctr Operations 15,000 15,000 Replacement - Roof 20-44000-03 1 500,000 500,000 G.O. Bond 500,000 500,000 Department Project# Priority 2017 2018 2019 2020 2021 Total Replacement- Kaivac Cleaning System 2044000-05 1 10,000 10,000 Comm Ctr Operations 10,000 10,000 Replacement- Camera/Security System 20-44000-06 1 12,000 12,000 G.O. Bond 12,000 12,000 Replacement- Zamboni Room Water Heater 20-44300-02 1 25,000 25,000 G.O. Bond 25,000 24000 Replacement - Floor Scrubber 2144000-01 1 15,000 15,000 Comm Ctr Operations 15,000 15,000 Repaint Field House Ceiling 21-44200-01 1 25,000 25,000 Comm Ctr Operations 25,000 25,000 Replacement - Munters Desiccant Wheel 21-44300-01 1 10,000 10,000 Comm CtrOperations 10,000 10,000 Replacement-Electric Edger 2144300-02 1 8,000 8,000 Comm Ctr Operations 8,000 8,000 Replacement- Evapor five Condenser 21-44300-03 1 60,000 60,000 Comm Ctr Operations 60,000 60,000 Replacement- Field House Floor 21-44400-02 1 150,000 150,000 Comm Ctr Operations 150,000 150,000 Community Center Total 81,000 248,000 7,879,000 589,000 2682000 9,065,000 Emergency Management Emergency Operations Center Improvement 17-42400-01 1 40,000 18,000 7,500 65,500 Capital Equipment Reserve 40,000 18,000 7,500 65,500 Replacement- Emergency Sirens 17-42400-02 1 45,000 45,000 45,000 45,000 180,000 CapilalEquipment Reserve 45,000 45,000 45,000 45,000 180,000 Emergency Management Total 852000 63,000 52,500 452000 245,500 Engineering New Development Projects 17-41600-01 1 160,000 160,000 165,000 175,000 180,000 840,000 Sewer Trunk Fund 117,000 117,000 120,000 125,000 125,000 604,000 Water Trunk Funtl 43,000 43,000 45,000 50,000 55,000 236,000 Pedestrian Trail Maintenance 17-41600-02 1 50,000 55,000 60,000 65,000 70,000 300,000 Road B Bridge Funds 50,000 55,000 60,000 65,000 70,000 300,000 New Pedestrian Trail and Sidewalk Segments 17-41600-03 1 565,000 225,000 265,000 710,000 400,000 2,165,000 Grant 265,000 265,000 Trail Funds 565,000 225,000 710,000 400,000 1,900,000 Pedestrian Trail Reconstruction 1741600-04 1 60,000 80,000 100,000 120,000 140,000 500,000 Road B Bridge Funds 60,000 80,000 100,000 120,000 140,000 500,000 Pedestrian Curb Ramp Replacements 17-41600-05 1 15,000 16,000 17,000 18,000 19,000 85,000 Road B Bridge Funds 15,000 16,000 17,000 18,000 19,000 85,000 LED Crosswalk Warning System 17-41600-06 1 21,000 21,000 Road 8 Bridge Funds 21,000 21,000 Replacement- Data Collector/Total Station 18-41600-01 1 33,500 33,500 Equipment Bond 33,500 33,500 Engineering Total 871,000 5692500 607,000 1,088,000 809,000 3,944,500 Facility Management Annual Parking Lot Maintenance 1741900-01 1 90,000 130,000 30,000 30,000 30,000 310,000 Capital Equipment Reserve 30,000 130,000 30,000 30,000 30,000 250,000 Comm Cir Operations 60,000 60,000 Replacement-Carpet I Tile 17-41900-02 2 10,000 10,000 10,000 30,000 Capital Equipment Reserve 10,000 10,000 10,000 30,000 Department Project# Priority 2017 2018 2019 2020 2021 Total Replacement- Security Management System 1741900-03 1 100,000 310,000 580,000 100,000 Capital Equipment Reserve 40,000 100,000 Finance 100,000 Public Warks Relocation I Expansion 17-01900-04 1 50,000 450,000 8,500,000 9,000,000 Capital Equipment Reserve 19-01400-01 50,000 50,000 G.O. Bond 150,000 450,000 8,500,000 8,950,000 HD Upgrade- City Hail Council Chambers 1741900-05 1 60,000 60,000 Capital Equipment Reserve 60,000 60,000 Building A -Seal Floor 1941900-01 1 150,000 25,000 25,000 Capital Equipment Reserve 25,000 25,000 Pedestrian Tunnel Under Crosstown Blvd. 1941900-05 1 1 450,000 20,000 450,000 G.O. Bond 20,000 100,000 450,000 450,000 Memorial -Veterans Memorial 19-01900-06 1 20,000 10,000 20,000 10,000 CapitalEqulpmentReserve 17-42200-02 1 10,000 10,000 Surface Seal all Brick Structures 20-41900-01 1 80,000 Capital Equipment Reserve 85,000 85,000 Capita/EquipmentReserve 48,000 48,000 Comm Cfr Opetations 18-42200-01 1 12,000 12,000 Water Fund 85,000 Equipment Bond 25,000 25,000 Facility Management Total 310,000 580,000 9,025,000 115,000 40,000 10,070,000 Finance Financial Payroll System Upgrade I Replacement 19-01400-01 1 150,000 150,000 Capital Equipment Reserve 150,000 150,000 Finance Total 150,000 150,000 Fire Replacement -Turnout Gear 17-42200-01 1 20,000 20,000 20,000 20,000 20,000 100,000 General Fund 20,000 20,000 20,000 20,000 20,000 100,000 Replacement- Extrication (Rescue) Equipment 17-42200-02 1 80,000 80,000 Capital Equipment Reserve 80,000 80,000 Replacement- Grass #31 18-42200-01 1 85,000 85,000 Equipment Bond 85,000 85,000 Replacement - Grass #21 18-42200-02 1 85,000 85,000 Equipment Bond 85,000 85,000 Replacement - Tanker #11 19-42200-01 1 400,000 400,000 Equipment Bond 400,000 400,000 Replacement - Grass Utility Vehicle (UTV) #4813 19-42200-03 1 45,000 45,000 Equipment Bond 45,000 45,000 Replacement- 1999 GMC Sonoma Truck (U-1 0) #48 10 19-02200-05 2 45,000 45,000 Equipment Bond 45,000 45,000 Replacement- SCBA Compressors 20-42200-01 1 130,000 130,000 Equipment Bond 130,000 130,000 Replacement -800 MHz radios 20-42200-02 1 35,000 35,000 70,000 Capital Equipment Reserve 35,000 35,000 70,000 Replacement -Engine 21#4884 20-02200-03 1 450,000 450,000 Equipment Bond 450,000 450,000 Fire Total 100,000 190,000 510,000 635,000 55,000 1,490,000 Information Technology Smartboard Addifion 18-01420-01 1 12,000 12,000 Capital Equipment Reserve 12,000 1$000 Department Project# Priority 2017 2018 2019 2020 2021 Total Information Technology Total 12,000 12,000 Park & Rec - Operations Replace/Repair Play Structures - Various Parks 1745000-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 17-45000-02 1 25,000 25,000 25,000 25,000 25,000 125,000 General Fund 25,000 25,000 25,000 25,000 25,000 125,000 Replacement - One Ton Crew Cab Pickup #502 1745000-03 1 50,000 50,000 Capital Equipment Reserve 50,000 50,000 New -Trail Machine 17-45000-04 1 150,000 150,000 Capital Equipment Reserve 150,000 150,000 Replacement - One Ton Truck w/ Plow #599 18-45000-01 1 80,000 80,000 Equipment Bond 80,000 80,000 New- Wood Chipper Tow-Behind 18-45000-02 1 20,000 20,000 Equipment Bond 20,000 20,000 Replacement-Bobcat Track Loader 4610 18-45000-03 1 55,000 55,000 Equipment Bond 55,000 55,000 Replacement - Small Extended Cab Truck #76 1845000-04 1 55,000 55,000 Equipment Bond 55,000 55,000 New - "V" Snow Plow for #09-589 18-45000-05 1 15,000 15,000 Equipment Bond 15,000 15,000 Replacement - Water Tanker #161 194500"1 1 150,000 150,000 Equipment Bond 150,000 150,000 Replacement-Trailer #T555 19-45000-02 1 16,000 16,000 Equipment Bond 16,000 16,000 Replacement- Cushman Field Dresser #547 20-45000-01 1 27,000 27,000 Equipment Bond 27,000 27,000 Park & Rec - Operations Total 275,000 300,000 241,000 102,000 75,000 993,000 Park & Rec - Projects Annual Miscellaneous Park Projects 17-45001-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 Fox Meadows Park - Renovation 1745001-02 1 457,300 457,300 Park Dedication Funds 457,300 457,300 Pine Hills North -Phase 11 1745001-03 1 100,000 400,000 500,000 Capital Equipment Reserve 280,000 280,000 Donations 100,000 100,000 Park Dedication Funds 120,000 120,000 Irrigation Projects -Small Parks 1745001-04 1 20,000 20,000 20,000 60,000 ParkDedica#on Funds 20,000 20,000 20,000 60,000 Nordeen's Park Basketball Court 1745001-05 1 7,500 7,500 Park Dedication Funds 7,500 7,500 Wild Iris Park Irrigation and Water Service 19-45001-02 1 42,500 42,500 Park Dedication Funds 42,500 41,500 Park & Rec - Projects Total 599,800 35,000 35,000 457,500 15,000 1,142,300 Planning & Zoning Replacement - Planning Vehicle #7 17-41500-01 1 30,000 30,000 Capital Equipment Reserve 30,000 30,000 Planning & Zoning Total 30,000 30,000 Department Project# Priority 2017 2018 2019 2020 2021 Total Sanitary Sewer 1 Sanitary Sewer Extensions 17-08200-01 1 105,000 500,000 605,000 Assessments 105,000 1,865,000 105,000 Sewer Trunk Fund 500,000 500,000 Replacement-Jet/Vac Truck #99 1748200-02 1 460,000 Storm Sewer Improvements 460,000 SanitarySewer Fund 55,000 230,000 60,000 230,000 Sewer Trunk Fund 302,000 230,000 230,000 Lift Station #4 Upgrade 1748200-03 1 50,000 62,000 50,000 Sewer Trunk Fund Replacement- Tymoo Street Sweeper#172 50,000 1 50,000 Yellow Pine Lift Station 1848200-01 1 650,000 650,000 Sewer Trunk Fund 650,000 650,000 Replacement- One Ton Utility Truck #69 1848200-02 1 100,000 100,000 Sanitary Sewer Fund 1 100,000 100,000 Sanitary Sewer Total 615,000 1,250,000 1,865,000 Storm Sewer 1 Storm Sewer Improvements 17-48300-01 1 55,000 60,000 60,000 62,000 65,000 302,000 Storm Sewer Fund 55,000 60,000 60,000 62,000 65,000 301,000 Replacement- Tymoo Street Sweeper#172 18-48300-01 1 220,000 220,000 Equipment Bond 220,000 220,000 Replacement -Elgin Street Sweeper 4169 1948300-01 1 200,000 200,000 Equipment Bond 200,000 200,000 Storm Sewer Total 55,000 280,000 260,000 62,000 65,000 722,000 Street Signs 1 Sign Design Software and Plotter 17-43300-01 2 10,000 10,000 Capital Equipment Reserve 10,000 10,000 Street Signs Total 10,000 10,000 Streets / Highways 1 Annual Street Seal Coat Project 1743100-01 1 725,000 250,000 260,000 275,000 285,000 1,795,000 Read &Bridge Funds 725,000 250,000 260,000 275,000 285,000 1,795,000 Annual Street Crack Seal Project 1743100-02 1 160,000 170,000 245,000 290,000 375,000 1,240,000 Construction Seal Coat Fund 17,000 8,000 10,000 10,000 10,000 55,000 Road &Bridge Funds 143,000 162,000 235,000 280,000 365,000 1,185,000 Annual Pavement Markings 17-43100-03 1 42,000 44,000 46,000 48,000 50,000 230,000 Road& Bridge Funds 42,000 44,000 46,000 48,000 50,000 230,000 Annual Curb Replacement 17-43100-04 1 50,000 52,000 54,000 56,000 58,000 270,000 Road& Bridge Funds 50,000 52,000 54,000 56,000 58,000 270,000 Municipal State Aid Routes / New & Reconstruct 17-43100-05 1 1,300,000 820,000 1,690,000 350,000 290,000 4,450,000 Assessments 243,000 75,500 144,000 15,000 15,000 492,500 Municipal State Aid Funds 1,057,000 744,500 1,546,000 335,000 275,000 3,957,500 Annual Street Reconstruction 17-43100-06 1 1,236,000 821,000 1,143,000 1,092,000 1,268,000 5,560,000 Assessments 309,000 206,000 286,000 273,000 317,000 1,390,000 Road &Bridge Funds 927,000 616,000 857,000 819,000 951,000 4,170,000 Intersection Upgrades 17-43100-07 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 1743100-08 1 15,000 15,000 15,000 15,000 15,000 75,000 Road &Bridge Funds 15,000 15,000 15,000 15,000 15,000 75,000 Replacement - One Ton Truck w/ Plow #134 17-43100-11 1 80,000 80,000 Capita/ Equipment Reserve 80,000 80,000 Department Project# Priority 2017 2018 2019 2020 2021 Total New - One Ton Truck w/ Regular Box w/ Lift & Plow 17-43100-12 1 55,000 55,000 Capital Equipment Reserve Rehabilitation of Wells 17-48100-01 55,000 50,000 50,000 50,000 55,000 New -Bobcat paver 17-43100-13 1 20,000 50,000 50,000 20,000 Capital Equipment Reserve 50,000 250,000 20,000 1748100-02 1 30,000 20,000 Street Overlays 1843100-01 1 30,000 400,000 400,000 800,000 Assessments 100,000 100,000 200,000 Road B Bridge Funds 300,000 300,000 Replacement - 3/4 Ton Utility Truck #66 600,000 New - Dump Truck w/ snow removal 19-43100-01 1 220,000 60,000 220,000 Equipment Bond 60,000 220,000 220,000 Replacement - Dump Truck w/Snow removal#198 2043100-01 1 48,000 220,000 220,000 Equipment Bond Sanitary Sewer Fund 220,000 220,000 Replacement -Bobcat S185#120 20-43100-02 1 50,000 16,000 50,000 Equipment Bond 16,000 Water Fund 50,000 50,000 Replacement - One Ton Truck w/Plow #133 20-43100-03 1 16,000 Water Main Improvements 80,000 1 80,000 EqulpmentBond 710,000 1,350,000 80,000 80,000 Replacement -Backhoe Loader#80 2043100-04 2 110,000 Water Trunk Fund 110,000 Equipment Bond 140,000 110,000 140,000 110,000 Replacement - Dump Truck w/Snow removal#200 21-43100-01 1 900,000 220,000 220,000 Equipment Bond 900,000 220,000 220,000 Streets 7 Highways Total Water Total 3,683,000 2,857,000 3,673,000 2,986,000 4,636,000 17,835,000 Water Rehabilitation of Wells 17-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 Replacement - Dodge Dakota #95 1748100-02 1 30,000 30,000 Sanitary Sewer Fund 15,000 15,000 Water Fund 15,000 15,000 Replacement - 3/4 Ton Utility Truck #66 18-48100-02 1 60,000 60,000 Water Fund 60,000 60,000 Replacement- Side by Side UN #70 18-48100-03 1 48,000 48,000 Sanitary Sewer Fund 16,000 16,000 Storm Sewer Fund 16,000 16,000 Water Fund 16,000 16,000 Water Main Improvements 1848100-04 1 640,000 710,000 1,350,000 Assessments 500,000 710,000 1,210,000 Water Trunk Fund 140,000 140,000 Water Meter Reading System AMI/AMR 19-48100-01 2 900,000 900,000 Water Fund 900,000 900,000 Water Total 80,000 7982000 1,660,000 50,000 50,000 2,638,000 GRAND TOTAL 6,794,800 7,222,500 24,127,500 6,129,500 6,013,000 50,287,300 rel 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: Discuss 2018 Budget Development Guidelines DATE: March 28, 2017 INTRODUCTION City Administration is starting to focus on the 2018 Annual Operating Budget Development process and is looking to the City Council to establish the Council's guidelines for the preparation of the 2018Annual Operating Budget. DISCUSSION The following are some suggested 2018 Budget Development guidelines for your consideration and could be impacted by the Councils discussion: 1) A commitment to a City Tax Capacity Rate to meet the needs of the organization and positioning the City for long-term competitiveness through the use of sustainable revenue sources and operational efficiencies. 2) A fiscal goal that works toward establishing the General Fund balance for working capital at no less than 45% of planned 2018 General Fund expenditures and the preservation of emergency fund balances (snow emergency, public safety, facility management & information technology) through targeting revenue enhancements or expenditure limitations in the 2016 adopted General Fund budget. 3) A commitment to limit the 2018 debt levy to no more than 25% of the gross tax levy and a commitment to a detailed city debt analysis to take advantage of alternative financing consistent with the City's adopted Debt Policy. 4) A comprehensive review of the condition of capital equipment to ensure that the most cost- effective replacement schedule is followed. Equipment will be replaced on the basis of a cost benefit analysis rather than a year based replacement schedule. 5) The use of long-term financial models that identify anticipated trends in community growth and financial resources that will help designate appropriate capital resources for future City needs. The financial models will be used in the budget planning process to ensure that key short-term fiscal targets are in line with long-term fiscal projections. 6) Continued commitment to strategic planning targeted toward meeting immediate and long- term operational, staffing, infrastructure and facility needs. 7) A management philosophy that actively supports the funding and implementation of Council policies and goals, and a commitment to being responsive to changing community conditions, concerns, and demands, and to do so in a cost effective manner. ACTION REQUESTED The Council is requested to review the aforementioned proposed Budget Development guidelines, discuss whether or not they are appropriate for developing the 2018 Annual Operating Budget. Administration would like to have the guidelines adopted at the April 4th City Council meeting 11 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: February 2017 General Fund Budget Progress Report DATE: March 28, 2017 INTRODUCTION The City of Andover 2017 General Fund Budget contains total revenues of $10,825,139 and total expenditures of $11,039,719 ; a decrease in fund balance is planned. Monthly reporting of the City Budget progress to the Governing body is a recommended financial practice and often viewed positively by rating agencies. DISCUSSION Attached is the General Fund Revenue & Expenditure Budget Summary - Budget Year 2017, reflecting year to date actual through February 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 were 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. p lly submitted, rm ickinson Attachment CITY OF ANDOVER General Fund Budget Summary Totals Budget Year 2017 2016 2017 REVENUES Budget Feb YTD % Bud YE - Unaudited Budget Feb YTD % Bud General Property Tax $ 8,113,528 $ 267 0% $ 8,217,768 $ 8,420,354 $ - 0% Licenses and Permits 346,205 46,410 13% 625,907 367,705 59,519 16% Intergovernmental 673,248 195,158 29% 733,951 766,150 190,093 25% Charges for Services 767,950 65,355 9% 857,163 773,950 77,123 10% Fines 100,750 6,979 7% 88,600 100,750 6,006 6% Investment Income 75,000 (22,800) -30% 43,747 75,000 - 0% Miscellaneous 116,800 60,141 51% 194,802 124,300 41,680 34% Transfers In 196,930 196,930 100% 196,930 196,930 196,930 100% Total Revenues $ 10,390,411 $ 548,440 5% S 10,958,868 $ 10,825,139 $ 571,351 5% 2016 1 2017 EYPENDTTURES Budget Feb YTD % Bud YE - Unaudited Budget Feb YTD % Bud GENERAL GOVERNMENT Mayor and Council $ 88,780 $ 36,588 41% $ 86,990 $ 89,991 $ 36,897 41% Administration 192,778 31,402 16% 187,876 199,541 31,259 16% Newsletter 26,000 5,351 21% 22,731 26,000 3,701 14% Human Resources 35,260 6,452 18% 13,403 27,913 6,161 22% Attorney 187,640 15,485 8% 184,990 191,360 15,641 8% City Clerk 157,075 28,633 18% 148,338 148,599 25,590 17% Elections 82,919 17,418 21% 64,433 63,881 1,817 3% Finance 261,016 54,729 21% 252,563 268,129 62,158 23% Assessing 150,000 - 0% 146,472 150,000 - 0% Information Services 168,483 26,077 15% 151,386 180,722 27,881 15% Planning & Zoning 435,606 72,369 17% 414,141 462,212 61,062 13% Engineering 509,514 82,900 16% 511,074 535,715 84,323 16% Facility Management 528,201 56,109 11% 408,249 681,733 66,558 10% Total General Gov 2,823,272 433,513 15% 2,592,646 3,025,796 423,048 14 PUBLIC SAFETY Police Protection 2,936,467 734,117 25% 2,936,467 2,962,551 740,638 25% Fire Protection 1,294,795 163,097 13% 1,285,416 1,422,522 175,874 12% Protective Inspection 441,807 67,581 15% 424,247 446,688 67,596 15% Civil Defense 22,982 4,468 19% 17,495 24,847 4,474 18% Animal Control 7,950 318 4% 3,700 5,950 196 3% Total Public Safety 4,704,001 969,581 21% 49667,325 4,862,558 988,778 20 PUBLIC WORKS Streets and Highways 656,237 105,159 16% 686,087 614,668 85,272 14% Snow and Ice Removal 563,587 178,994 32% 468,174 547,777 163,866 30% Street Signs 204,193 25,319 12% 167,283 215,244 35,086 16% Traffic Signals 35,000 1,749 5% 25,543 37,000 1,798 5% Street Lighting 36,400 2,969 8% 37,089 38,400 2,337 6% Street Lights - Billed 217,500 17,764 8% 200,509 217,500 11,418 5% Park & Recreation 1,257,247 156,169 12% 1,247,501 1,275,530 162,054 13% Natural Resource Preservation 7,596 50 0% 7,255 12,697 243 2% Recycling 130,927 10,863 16% 124,860 122,221 27,593 23% Total Public Works 3,108,687 499,036 16% 2,964,301 3,081,037 489,667 16% OTHER Miscellaneous 281,728 - 0% 258,577 31,728 3,000 9% Youth Services 38,600 8,500 22% 24,500 38,600 - 0% Total Other 320,328 8,500 3% 283,077 70,328 3,000 4% Total Expenditures $ 10,956,288 $ 1,910,630 17% $ 10,507,349 $ 11,0399719 $ 1,904,493 17% NET INCREASE (DECREASE) $ (565,877) $ (1,362,190) $ 451,519 $ (214,580) $ (1,333,142) LV 1 . �� . ,ND 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 February 2017 City Investments Review March 28, 2017 INTRODUCTION Summary reporting of the City Investment portfolio to the Governing body is a recommended financial practice and often viewed positively by rating agencies. Furthermore, the City of Andover Investment Policy recommends the Finance Director presents to the City Council at least quarterly the type of investments held by the City. DISCUSSION Attached is the Investment Maturities Summary for February 2017, the February 2017 Investment Detail Report, and the February 2017 Money Market Funds Report. These attachments are intended to assist with discussion when reviewing the February 2017 investments. ACTION REQUESTED The Council is requested to review and provide feedback to staff. submitted, Investment Maturities - February 2017 Investment Maturities (in Years) Credit Fair Less Than More Than Investment Type Rating Value 1 1 -5 6-10 10 Money market funds N/A $ 1,492,125 $ 1,492,125 $ $ $ MN Municipal Money Market Fund (4M) N/A 5,006 5,006 Premier Banks Money Market Fund N/A 260,914 260,914 - - - Certificates of deposit FDIC 13,590,676 9,482,701 4,107,975 - - Local governments A/Al/A2 583,274 81,745 337,440 60,249 103,840 AAI/AA2/AA3 7,235,588 1,499,088 3,976,274 1,349,946 410,280 AAA 3,507,372 460,177 2,666,173 381,022 - Stategovernments A/Al/A2 - - - - - AAI/AA2/AA3 2,537,103 1,018,769 1,298,900 219,434 - AAA 662,227 262,578 195,813 203,836 - U.S. agencies AAA 3,563,805 550,278 2,891,271 - 122,257 FNMA REMIC N/A 2,705 - 2,705 - - U.S. agencies N/A 1,458,113 1 719,870 1 738,243 1 - - Total investments $ 34,898,908 $ 15,833,250 $ 16,214,794 $ 2,214,487 $ 636,377 Deposits 2,347,038 Total cash and investments $ 37,245,946 February 2017 Investment Detail Description Cusip Number Credit Rating/F DIC If Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity/ Due Date City Nab Bk FL Miami Citizens Bk PA Philadelphia _ Bank Baroda New York BRH 17801 DBPO 17417QDA8 06062QYK4 20234 57282 _ CD CD 245,000.00 245,000.00 245,000.00 245,000.00 245,000.00 0.550% 0.550% 0.650% 0.650% 0.550% 0.600% 0.500% 245,000.00 245,004.90 245,009.80 245,019.60 245,009.80 245,019.60 maturity maturity maturity 12/02/16 12/07/16 12/09/16 none 03/02/17 245,000.00 245,000.00 none 03/07/17 CD 245,000.00 245,000.00 none 03/09/17 Merchants Bank of Indiana 588493GY6 _33681 8056_ CD 245.000.00 245,000.00 245,000.00 245,000.00 maturity 12116/16 none 03/16/17 Metabank Storm Lake Iowa 59101LAF4 30776 CD 245,000.00 245,000.00 maturity 12/16116 none 03/16/17 CIBM Bk Champaign III 12545JAJ4 11729 CD 245,000.00 245,000.00 245,000.00 maturity 12/22/16 12/23/16 none 03122/17 Dallas Cap Bk NA 234553AK1 20727 CD 245,000.00 245,000.00 245,000.00 245,004.90 maturity none 03/23/17 Beal Bk USA Las Vegas NV 07370WF50 57833 CD 245.000.00 245,000.00 245,000.00 0.650% 245,036.75 maturity 12128/16 none 03/29/17 Luther Burbank Savings 550551BM6 32178 CD 245,000.00 245,000.00 245,000.00 0.550% 245,017.15 maturity 12/30116 none 03/30/17 TCM Bank 872308CB5 34535 27334 27471 245,000.00 245,000.00 245,000.00 0.650% 245,039.20 maturity 05/31/16 none 03/31/17 Peoples Utd Bk Bridgeport CT 71270OQG4 _CD CD 245,000.00 245,000.00 245,000.00 0.600% 245,041.65 maturity 01/18/17 none 04/18/17 Amex Centurion Bank 02587DE61 CD 248,000.00 248,000.00 248,000.00 0.900% 248,163.68 semi-annual 10128/15 04128/16 04/28/17 Bank of India NY Blue Hills Bk Boston MA 06279HWT6 33648 90160 CD 245,000.00 245,000.00 245.000.00 245,000.00 245,000.00 0.650% 0.650% 0.650% 0.700% 245,044.10 maturity 02123117 none 05/24/17 095577DY5 _ CD 245,000.00 245,041.65 maturity 01125117 none 05/25/17 _ CIT Bank NA 12556LAA4 58978 CD 245,000.00 245,000.00 245.000.00 245,095.55 _ maturity 05131/16 none 05/31/17 Bank of America 06051VZY5 3510 CD 245,000.00 245,000.00 245,000.00 245,090.65 maturity 06/02/16 none 06/02/17 RBS Citizens NA Providence RI 75524KFZ2 57957 CD 245,000.00 245,000.00 245,000.00 0.700% 245,066.15 maturity 12107/16 none 06/07117 State Bank India NY 856284565 33682 CD 245,000.00 245,000.00 245,000.00 0.750% 245,102.90 maturity 12/12/16 none 06112117 Bank of Ruston LA 06427LBV6 29700 CD 245,000.00 245,000.00 245,000.00 0.650% 245,031.85 maturity 12114/16 none 06114117 _ Bank of China NY 06426TZ69 33653_ 23621 CD 245,000.00 245,000.00 245,000.00 0.700% 245,068.60 maturity 12/15/16 none 06115/17 Berkshire Bk Pittsfield MA 084601 GP2 CD 245,000.00 245,000.00 245,000.00 0.750% 245,107.80 maturity 12/30/16 none 06/30/17 Patriot Bank NA 70337MAR9 33928 CD 245,000.00 245,000.00 245,000.00 0.850% 245,191.10 maturity 12/30/16 none 06/30117 Capital One NA 14042E4O0 4297 CD 248,000.00 248,000.00 248,000.00 1.150% 248,339.76 semi-annual 07115115 01115/16 07117117 Investors Savings Bank 46176PFF7 28892 CD 245,000.00 245,000.00 245,000.00 0.650% 245,110.25 maturity 07/21/16 none 07/21/17 Champlain NO Bk Elizbt 158716AU4 7356 CD 245,000.00 245.000.00 245,000.00 0.700% 245,058.80 maturity 12/29/16 none 07/28/17 First Foundation Bank 32026UCN4 58647 CD 245,000.00 245,000.00 245,000.00 0.700% 245,024.50 maturity 12/16116 none 09/15/17 Bank Leumi USA 063248GF9 19842 CD 245,000.00 245,000.00 245,000.00 0.850% 245,222.95 maturity 12/22116 none 09/22/17 Mercanfil CommerceBank 58733ADB2 22953 CD 245,000.00 245.000.00 245,000.00 0.900% 245,181.30 semi-annual 07/12116 12/29116 09/29/17 Farmers & Merchants Svgs Bk 30856PAG1 9298 CD 249,000.00 249,000.00 249,000.00 1.050% 249,936.24 monthly 01/22/16 02/22/16 10/23/17 Washington Trust Company 940637HU8 23623 CD 245,000.00 245,000.00 245,000.00 0.750% 245,017.15 maturity 12/05/16 none 11/17/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 12116117 1 Year CD- Premier Bank Rochester 2055214401 33202 CD 246,474.02 246,474.02 246,474.02 150,000.00 245,000.00 246,474.02 0.600% 246,474.02 maturity 12116/16 none 12/16/17 1 Year CD - Premier Bank MN 3041574901 33204 CD 246,474.02 246,474.02 150,000.00 0.600% 1.250% 246,474.02 maturity 12116/16 none 12/16117 Valley Cent Svgs Bk Reading OH 91944RAE8 28555 CD 150,000.00 150,513.00 monthly 12122/14 01/22/15 12122117 Safra National Bk 78658QD59 26876 CD 245,000.00 245,000.00 1.000% 245,316.05 maturity 12/29/16 none 12/28117 BankUnited NA D66519CT4 58979 CD 245,000.00 245,000.00 245,000.00 1.100% 245,516.95 maturity 12/29/16 none 12129/17 First Bank of Highland 319141EL7 17470 CD 245,000.00 245,000.00 245,000.00 0.850% 244,617.80 maturity 02/22/17 none 02122/18 TCF National Bank 872278YZ3 28330 CD 245,000.00 245,000.00 245,000.00 0.850% 244,617.80 maturity 02/22/17 none 02122118 Plains Commerce Bank 72651 LBM5 1678 CD 245,000.00 245,000.00 245,000.00 0.850% 244,568.80 maturity 02/28/17 none 02/28/18 Augusta ME 051411ND4 A3 local 11,250.00 11,250.00 10,000.00 5.250% 10,211.00 semi-annual 03/07/12 none 10/01117 Kaufman TX 486206KL8 A3 local 72,922.50 72,922.50 70,000.00 4.000% 71,534.40 semi-annual maturity 06/28116 01/12/10 02/15/17 02/15/18 Philadelphia PA Auth Zero Coupon 71781LBJ7 AA local 161,700.00 161,700.00 245,000.00 244,755.00 none 04/15/17 9,482,700.87 CD Description Cusip Number Credit RatinglF DIC # Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value - Interest Paid Date Acquired Coupon Date Maturity/ Due Date McKinney TX _ _ Reg[Transpnn Dist, Denver Dane County WI _ Waterloo IA 581646Y91 AA1 local 126,856.25 254,312.50 106,487.00 126,856.25 254,312.50 106,487.00 125,000.00 250,000.00 100,000.00 1.472% 2.000% 2.450% 125,196.25 251,120.00 100,860.00 100,593.00 semi-annual semi-annual semi-annual semi-annual 05/20/15 07/12/16 07/16/12 none 11/01/13 08/15/17 11/01/17 12/01/17 06/01/17 759136RR7 AAI 23609IM92 AAI _local local none 941647KEB AA2 local 105,594.00 105.594.00 100.000.00 3.500% 02/24/15 none _ Prior Lake MN 742617CB7 AA2 _local 230,000.00 230,000.00 230,000.00 1.000% 229,650.40 82,792.00 semi-annual 05/14/15 04130/12 12/15115 12/15/17 02/01/18 _ _ _ Hopkins Minn ISD #270 439881HCO _ AA2 local 95,278.40 95,278.40 80.000.00 5.250% 08101/09 Orono MN ISD 687136LA7 AA2 local 115,511.00 115,511.00 110,000.00 4.000% 113,224.10 _semi-annual semi-annual 08/04/16 02/01/17 02/01/18 -#278 Tucson AZ 898711033 AA3 local 254,202.50 254,202.50 250,000.00 2.139% 250,897.50 semi-annual 12/09/15 none 07/01/17 Tennessee Valley Auth 880591EA6 AAA local 93,153.11 93,153.11 85,000.00 5.500% 86,566.55 semi-annual 06/01/09 01/18/08 07/18/17 Washington County MN 937791KL4 AAA local 115,000.00 112,114.00 115,000.00 112,114.00 115,000.00 3.750% 116,775.60 102,264.00 154,570.50 803,072.00 semi-annual 07101110 01/01/11 01/01/18 Saint Louis Park MN Bandera TX ISD_ _ Minnesota St 791740WC3 AAA local 100,000.00 3.850% semi-annual 12122/11 none 02/01/18 059851HR9 AAA local 154,890.00 154,890.00 150,000.00 800,000.00 4.000% semi-annual semi-annual 12122/16 none 02/15/18 604129F92 AA1 state 811,520.00 811,520.00 2.000% 07105116 none 08/01/17 New Hampshire St Hsg 64469DWUl AA2 state 215,819.15 215,819.15 215,000.00 1.789% 215,696.60 semi-annual 12109115 07/01/16 01/01118 Tennessee State 880541QM2 AAA state 201,894.00 201,894.00 200,000.00 2.326% 201,192.00 semi-annual 10126111 02/01/12 08101/17 Virginia St Res Auth Infrastructure 92817QKSO AAA state 61,500.00 61,500.00 99,647.00 60,000.00 100,000.00 4.710% 61,386.00 semi-annual 02/09/17 11/01/09 11101117 Fed Farm Credit Bank 3133EATE8 AAA US 99,647.00 0.900% 100,065.00 semi-annual 11104113 12/08/12 06108117 Fed Farm Credit Bank 3133ECA95 AAA US 199,800.00 199,800.00 200,000.00 0.790% 199,980.00 semi-annual 12108115 03118/13 09118117 Fed Home Ln Bank 3130A15P9 AAA US 251,187.50 251,187.50 250,000.00 1.000% 250,232.50 semi-annual 07/08/16 none 0926117 _ FICO Strip Prin Zero Coupon 31771KACI US 295,932.00 295,932.00 300,000.00 298,449.00 maturity 1023115 none 10106117 FICO Strip Pm -4 Zero Coupon 31771 EAD3 US 194,572.00 194,572.00 200,000.00 198,980.00 maturity 03/16/15 none 10/06117 FICO Strip Cpn-E Zero Coupon 3177IJXM7 US 215,452.16 215,452.16 224,000.00 222,440.96 maturity 12/11/14 none 11102117 14,075,205.23 244,999.78 Synovus Bank 87164DHW3 V3 CD 244,999.78 245,000.00 1.000% 245,191.10 12/05/16 none 04113/18 Capital One Bank (USA) 140420ZQ6 33954 CD 245,000.00 245,000.00 245,000.00 0.900% 244,399.75 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,566.35 semi-annual 07/13/16 01/13/17 07/13/18 BMW Bank of North America 05580ADR2 35141 CD 245,000.00 245,000.00 245,000.00 1.600% 246,136.80 semi-annual 0122116 0722/16 0122/19 Ally Bank Midvale Utah 02006LF32 57803 CD 245,000.00 245,000.00 245,000.00 1.2D0% 243,463.85 semi-annual 06/30/16 12/30/16 07/01/19 _ Barclays Bank 06740KHB6 57203 CD 247,000.00 247,0_00.00 247,000.00 2.050% 250,089.97_ _semi-annual semi-annual 07/03/14 01/02115 07/02/19 Synchrony Bank 87164WBT4 27314 CD 247,000.00 247,000.00 247,000.00 2.050% 250,038.10 07111114 01111/15 07/11/19 JP Morgan Chase Bank NA 48125Y51.4 628 CD 245,000.00 245,000.00 245,000.00 1.100% 243,169.85 quarterly 07115116 10115116 07/15/19 PdvateBank & Trust Co 74267GUQ8 33306 CD 247,000.00 247,000.00 247,000.00 2.000% 250,045.51 semi-annual 07121114 01121/15_ 0722/19 Goldman Sachs Bank USA 38147JU59 33124 CD 247,000.00 247,000.00 247,000.00 2.050% 249,808.39 semi-annual 07123114 01/23/15 0723/19 First Federal Svgs Bk 32021YCH4 29690 CD 249,000.00 249,000.00 249,000.00 1.500% 252,219.57 monthly 01121116 02/21116 0821/19 Victory Bank 92644LAB8 58615 CD 247,000.00 247,000.00 247,000.00 2.000% 250,040.57 semi-annual 09/24/14 03/24/15 09/24/19 Third Federal Sav & Loan 88413QAW8 30012 CD 128,000.00 128,000.00 128,000.00 2.000% 129,909.76 semi-annual 1124/14 05/24/15 11/25/19 Celtic Bank 15118RJMO 57056 CD 247,000.00 247,000.00 247,000.00 2.050% 251,715.23 semiannual 12/20/13 0620/14 12/20/19 Steams Bank NA 857894PB9 10988 CD 247,000.00 247,000.00 247,000.00 1.000% 250,764.28 semi-annual 1226/14 0626/15 12126119 Citizens Alliance Bank 17318LAP9 1402 CD 249,000.00 249,000.00 249,000.00 2.000% 253,845.54 monthly 06/27/14 0727/14 06/26/20 Enerbank USA 29266NA31 57293 CD 249,000.00 249,000.00 249,000.00 2.100% 252,570.66 monthly 07/18/14 08/18/14 07120120 Elbow Lake MN 284281 KC5 A local 170,045.70 170,045.70 165,000.00 2.750% 168,903.90 semi-annual 12/08/14 none 12101119 Oneida County NY 6824543R2 Al local 68,632.80 68,632.80 60,000.00 6.250% 62,778.00 semi-annual 08/16/10 none 04115119 2,041,010.30 local 1,281,346.60 state 1,270,147.46 US Less Than 1 Year 4,107,975.28 CD Description Cusip Number Credit Rating/F DIC # Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity) Due Date Junction City Kansas Farmington MN _ _ Rice Cnty MN_ _ _ Racine WI 481502F72 A2 AA local local local 101,558.00 102,787.00 45,466.80 101,792.00 101,558.00 102,787.00 45,466.80 100,000.00 100,000.00 40,000.00 5.500% 2.000% 4.400% 2.100% 4.302% 2.450% 4.500% 3.000% 105,758.00 101,866.00 42,210.40 100,815.00 145,206.60 10,010.00 145,406.00 205,450.05 semi-annual semi-annual semi-annual 05/28/08 07/06/16 03/01/09 none 09/01/18 02/01/19 311297W84 762698GK8 _ AA 03/07/12 none 02/01/19 06/01/18 08/01/18 02/01/19 04/01/19 02/01/20 03/01/20 06/01/20 02/01/21 03/15/21 03101/18 05/01/18 06/01/18 12/01/18 06/01/19 7500216D4 _ AA- local 101,792.00 100,000.00 semi-annual 01/24/12 06/01/12 none _ Indiana St Bond Bank 454624540 kcal 146,123.60 146,123.60 10,000.00 140,000.00 semi-annual semi-annual 12/30/16 _ _ _ Minnehista MN 6D4229KE3 _ _AA- AA+ local 10,000.00 10,000.00 10/10/13 08/01/14 _ Ramsey MN 751813PB6 AA+ kcal 158,677.85 158,677.85 145,000.00 semi-annual 02/16/12 07/06/16 _ _ Rothsay MN ISD #850 _ _ Saint Paul MN Port Auth Steams Co MN 778731AZ2 AA- AA. AA- AA+ AA+ kcal 208,640.25 208,640.25 195,000.00 semi-annual _04/01/16 _ 793067CC1 kcal 79,756.80 79,756.80 80,000.00 2.000% 79,915.20 semi-annual 01/10/17 _none 857896MH4 local kcal local local 276,875.00 161,038.40 27,593.50 220,938.00 276,875.00 250,000.00 160,000.00 4.500% 3.100% 251,540.00 160,150.40 26,531.00 205,868.00 100,329.00 102,700.00 103,658.00 206,348.00 semi-annual 04117/13 _09/01/17 none Minnetrista MN_ Greenway MN ISD #31 604229KG8 161,038.40 semi-annual 10/10/13 08/01114 none 39678LDF6 27,593.50 220,938.00 25,000.00 5.000% 4.000% semi-annual 07109/13 _ Minneapolis MN 60374YF93 AA1 200,000.00 semi-annual 03/04/14 none New York City NY Transitional 649710TU7 AA1 local 100,440.00 100,440.00 100,000.00 1.600% semi-annual 01127/17 none Scott County lA_ Minneapolis MN Cedar Rapids IA 809486EZ2 AA1 local 114,450.33 112,617.00 100,000.00 4.400% 3.250% semi-annual 10131/12 12/01/12 60374YS73 AAt local 111,898.00 111,898.00 217,672.00 100,000.00 semi-annual 06/05/12 12/01/11 150528RM1 AA1 local 217,672.00 200,000.00 3.000% semi-annual 06/11/13 12/01/13 Minneapolis MN_ 60374YS81 AAt local 278,632.50 278,632.50 250,000.00 3.500% 262,322.50 semiannual 02126/13 none 12/01/19 Hampton VA 4095582,11 AA1 local 100,836.00 100,836.00 100,000.00 2.209% 100,488.00 semiannual 01120/16 none 04/01/20 _ Middleton WI 596782RX2 AAI local 106,979.00 106,979.00 100,000.00 3.750% 102,939.00 semi-annual 02124/15 none 09/01120 Des Moines IA Area Cmnty Col 2500971-121 AA1 local 50,606.00 50,606.00 50,000.00 2.450% 50,977.00 semi-annual 11/10/14 12/01/14 06/01121 _ Orange Beach ALA Sioux City IA 68406PHF1 AA2 local 241,689.60 241,689.60 156,100.50 240,000.00 155,000.00 4.400% 2.000% 248,604.00 156,494.20 semi-annual semi-annual 08/05110 02/01/11 02/01119 06101/19 829458FC7 _ AA2 local 156,100.50 12/22/16 none Waterloo IA 941647PAI AA2 local 50,559.50 50,559.50 50,000.00 2.000% 50,445.00 semi-annual 06/27/13 12/01/13 06101/19 Western Lake Superior MN 958522WU4 73723RSL8 AA2 AA2 local 100,000.00 100,000.00 100,000.00 3.150% 103,312.00 semi-annual 08/16111 04/01/12 10101119 Portsmouth VA lIccal 286,268.00 286,268.00 295,000.00 2.400% 299,265.70 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% 109,403.80 semiannual 08/21/15 none 05/01/20 Kane McHenry Cook & De Kalb Zero Cpn 484080MB9 _ AA3 local 157,328.00 157,328.00 200,000.00 192,636.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,588.00 semi-annual 11/14/11 none 02/01/20 Davenport Iowa 238388GS5 AA3 local 111,948.00 111,948.00 100,000.00 4.650% 100,750.00 semi-annual 09/13/11 none 06/01120 Whitewater Wis 966204KA6 AA3 local 109,541.00 109,541.00 100,000.00 4.850% _ 109,045.00 semiannual 06/09111 none 12/01/20 Brownsville TX ISD Zero Coupon 116421E46 AAA local 229,640.00 229,640.00 250,000.00 244,715.00 maturity_ 06/26113 none 08/16/18 King Cnty WA 49474E3L5 _ AAA local 224,634.00 224,634.00 200,000.00 3.980% 208,394.00 35,802.90 semi-annual semi-annual 03/27/12 none 12/01/18 02/01/19 Minnetonka MN ISD #276 604195RA7 AAA local 37,433.20 37,433.20 35,000.00 3.100% 12/22/11 none Palm Beach Cnty FLA 696497TR7 AAA local 256,504.60 256,504.60 220,000.00 5.898% 231,444.40 semi-annual 07106/11 none D6/01/19 Tenn Val Auth Cpn Strip Zero Cpn 88059EWZ3 AAA local 262,890.00 262,890.00 300,000.00 287,241.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% 124,245.60 semi-annual 08/04/10 08/01/11 08/01/19 Greensboro NC 395460V21 AAA local 366,832.80 366,832.80 360,000.00 3.263% 372,020.40 semi-annual 07/15/11 none 10/01/19 Saint Paul MN Port Auth 793028WS6 AAA local 201,806.00 201,806.00 200,000.00 2.000% 201,756.00 semi-annual 12122/16 08101/17 02/01/20 Woodbury MN 97913PCQ7 AAA local 123,037.35 123,037.35 115,000.00 3.250% 117,055.05 semi-annual 12122/11 none 02/01/20 Dallas TX Indpt Sch Dist 235308OK2 AAA local 116,900.00 116,900.00 100,000.00 4.450% 107,988.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 282,069.00 maturity 03/11/13 none 05/01/20 Tenn Val Auth Cpn Ship Zero Cpn 88059EMX9 AAA local 88,133.00 88,133.00 100,000.00 92,856.00 maturity 03/18/13 none 07/15/20 Description bo Number Credit Rating/F DIC # Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity 1 Due Date McAllen TX Dev Corp Baltimore Cray MD _ _ _ _ New York Sl Mtge Agy 579086AW9 AAA _ local 175,000.00 175,000.00 51,290.00 175,000.00 50,000.00 1.400% 2.097% 171,547.25 49,878.00 semi-annual semi-annual semi-annual semi-annual 07/26/16 08/31/16 02/15/17 none 08115120 08/01/21 05914FME7 local 51,290.00 100,000.00 39,956.40 64988RHGO _AAA AAA local 100,000.00 100,000.00 2.375% 99,309.00 10/27/15 04101/16 10/01121 _ Columbus OH Washington State Massachusetts State 199492CS6 AAA local 39,956.40 40,000.00 2.133% 39,851.60 02/20/15 none 12101/21 AA state 205,804.00 205,804.00 200,000.00 4.500% 208,272.00 semi-annual semi-annual 01124/12 04/01/12 11/01/14 10101/18 _ AA1 state 199,744.00 199,744.00 200.000.00 2.090% 201,062.00 12/17/14 05/01/20 New Hampshire Sl Hsg AA2 state 120,715.20 120,715.20 120,000.00 1.939% 120,696.00 semi-annual 12/09/15 07/01/16 none 07101/18 04/15118 _9 Kansas St Dev Fin Auth V64469DWV9 AA3 state 182.743.20 182,743.20 180,000.00 1.877% 180,520.20 semi-annual 07112116 Florida St Hurricane AA3 state 279,439.80 279,439.80 270,000.00 2.995% 278,021.70 semi-annual 11/10/15 07101/13 07/01/20 Minnesota St Colleges 8 Univ AA3 state 100,000.00 100,000.00 100,000.00 2.000% 99,672.00 semi-annual 02/26/15 10101115 10/01/20 Connecticut State Georgia State AA3 state 214,954.00 26,742.50 103,089.00 214,954.00 200,000.00 3.517% 210,656.00 semi-annual 05/27116 02/15/14 08/15/21 373384RQ1 AAA state 26,742.50 103,089.00 25,000.00 2.970% 25,599.50 semi-annual 02/08112 none 10/01118 Texas State 882722,151 AAA state 100,000.00 2.894% 102,510.00 semi-annual 08/10/11 04/01/12 10/01/18 Tennessee State 880541QQ3 AAA stale 48,218.85 48,218.85 45,000.00 3.178% 46.763.55 semi-annual 08/30/16 02/01/12 08/01/20 Virginia State 928109XD4 _ AAA state 22,126.00 22,126.00 20,000.00 4.100% 20,940.00 semi-annual 02/07/12 none 06/01/21 Fed Farm Credit Bank 3133EFJMO AAA US 249,750.00 249,750.00 200,000.00 250,000.00 200,000.00 0.930% 249,412.50 semi-annual 05/25/16 04/13/16 04/13/18 Fed Home Ln Mtg Corp Mad Term Note 3134G3ZK9 US 200,000.00 1.200% 200,300.00 semi-annual 07/30/12 01/30/13 07/30/18 08101/18 Fed Farm Credit Bank 31331Y4S6 _AAA AAA US 114,000.00 114,000.00 100,000.00 5.050% 105,464.00 semi-annual 09/11/13 none Fed Nag Mtg Assn 3136GOY70 AAA US 199,300.00 199,300.00 200,000.00 1.080% 198,984.00 semiannual 10/30/12 01/30/13 01130/19 Fed Farm Credit Bank 3133EC5NO AAA US 99,587.00 99,587.00 100,000.00 1.250% 99,508.00 semi-annual 01/07/13 03/04/13 03104/19 08123/19 10115119 11/25119 Fed Home Ln Mtg Corp Med Tenn Note 3134G96U6 _ AAA AAA _ AAA US 200,000.00 200,0_00.00 200,000.00 1.050% 197,436.00 quarterly 08123/16 11/23/16 RFCSP SMp Principal Zero Coupon 76116FAA5 3133EGBKO US 185,568.00 185,568.00 200,000.00 191,964.00 maturity 07122115 none Fed Farm Credit Bank US 199,600.00 199,600.00 200,000.00 1.300% 198,430.00 _ semi-annual 05125/16 11/25/16 Fed Home Ln Mtg Corp Zero Cpn 31340OBV4 AAA US 950,527.00 950,527.00 1,000,000.00 951,120.00 maturity 11/02115 none 11/29119 Fed Nag Mtg Assn 3136G4KL6 3130A3XL3 AAA AAA US 200,000.00 200,000.00 200,000.00 1.700% 200,004.00 semi-annual 12/30/16 06/30/17 12/30119 Fed Home Ln Bank US 99,500.00 99,500.00 100,000.00 1.500% 100,296.00 semi-annual 07/22/15 08/10115 02/10/20 Fed Nall Mtg Assn 3136G4JM6 _ AAA US 200,000.00 200,000.00 200,000.00 1.850% 198,352.00 semi-annual 12/28/16 06/28/17 12/28/20 Fed Nab Mtg Assn Remic 31393FAL3 US 204,187.50 2,721.48 2,665.65 4.500% 2,705.31 monthly 07/30/03 none 08/25/18 FICO Strip Cpn Zero Coupon 31771 EAA9 US 529,947.00 529,947.00 550,000.00 541,590.50 maturity 06/09/14 none 05/11/18 Fed Home Ln Mtg Corp 31393VMQ1 US 153,656.25 1,683.98 1,643.91 4.500% 1,666.97 monthly 06/30/03 06/15/18 FICO Strip Cpn13 Zero Coupon 31771 C2139 US 93,140.00 93,140.00 100,000.00 97,668.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 972318.00 maturity 04117/15 none 02/01/19 16,214,794.46 Kaufman TX 486206KR5 A3 local 61,821.00 61,821.00 60,000.00 3.000% 60,249.00 semi-annual 06/28116 02/15/17 02/15/23 Chaska MN 161663653 AA local 104,657.00 104,657.00 100,000.00 4.000% 103,168.00 semi-annual 09/08/14 none 02/0124 Mitchell SD Sch Dist #17-2 606687EHO AA local 116,702.00 116,702.00 100,000.00 6.000% 107,289.00 semi-annual 1220/11 06/15/19 06/1524 MinnetristaMN 604229KJ2 AA+ local 40,000.00 40,000.00 40,000.00 3.850% 40,048.40 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,320.00 semi-annual 06/17/10 02/01/11 02/01/24 Lake City Minn 1SD#813 508084DW7 AA+ kcal 103,933.00 103,933.00 100,000.00 5.000% 104,098.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% 106,642.00 semi-annual 0722/11 none 02/0127 Minneapolis MN 60374YG68 AA1 kcal 110,419.00 110,419.00 100,000.00 4.700%1' .700% 105,455.00 semi-annual 10/31/11 none 03/0123 Minneapolis MN 60374YG76 AA1 local 72,201.35 72,201.35 65,000.00 4.800% 68,519.10 semi-annual 12/09/14 none 03/0124 6,979,886.95 local 1,494,712.95 state 3,632,219.28 US 1- 5 Years Description Cusip Number Credit RatinglF DIC# Type Purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity/ Due Date Alexandria MN ISD_#206 _ Duluth MN W Palm Beach FL _ Hawkins Cnty TN 015131LQ6 AA2 local 279,760.50 279,760.50 270,000.00 30,000.00 3.000% 2.625% 278,226.90 28,946.70 97,979.00 103,254.00 131,022.00 250,000.00 _ _ 219,434.00 203,836.00 — 2,214,487.10 semi-annual semi-annual semi-annual semi-annual 01/21/15 12/05/12 07/05/16 03/13/12 none 08/01/13 10/01/16 none none none 02/0'x::_ 02/01/25 10/01/22 05/01/24 11/01/25 01/01/26 264438ZL9 _ AA2 AA3 local local 29,767.20 29,767.20 955116BE7 101,245.00 101,245.00 100,000.00 100,000.00 100,000.00 250,000.00 200.000.00 200,000.00 _ — 2.264% 4.800% 6.750% 6.206% 2.780% 420218PU AA3 local local 111,480.00 121,500.00 111,480.00 121,500.00 250,000.00 217,800.00 204,444.00 Tennessee Valley Auth Ser E Ice Deposit- National Sports Center Florida St Dept Environmental _ Georgia State373384208 880591C,19 none AAA_ semi-annual maturity 03/19/09 02/06/08 local 250,000.00 34160WUAO _ AA3 state 217,800.00 semi-annual semi-annual 08/30/10 07/01/10 none 07/01/22 02/01/23 AAA state 204,444.00 12/13/16 Itasca County Minn Van Buren Mich Public Schools 465452GP9 A local 105,024.00 105,024.00 100,000.00 100,000.00 500,000.00 5.550% 6.430% 103,840.00 108.620.00 301.660.00 semi-annual 07/12/11 none 02/01/28 920729HD5 AA1 local 102,750.00 102,750.00 semi-annual maturity 07/17/09 11/01/09 05/01/29 Will County It. Cmnty Zero Coupon 9690780M9 AA2 local 159,000.00 159,000.00 08/25/09 none 11/01/27 Fed Farm Credit Bank 31331VLC8 AAA US 106,030.45 106,030.45 100,000.00 5.250% 122,257.00 semi-annual 02/26/10 none 04/21/28 636,377.00 33,140,863.79 1,791,217.10 local 423,270.00 state 6-10 Years 514,120.00 local 122,257.00 US 10+ Years INVESTMENT SCHEDULE - Money Market Funds February 28, 2017 Description Current Market Value YTD Interest Wells Fargo 1 Wells Fargo Government Money Market Fund 1 $1,492,125.091 $446.04 4M 1 4M 1,895.921 1.18 4M PLUS 1 4M Plus 1 3,109.841 2.29 Premier Bank 1 lPremier Bank Money Market 1 260,913.641 100.41 Grand Total Money Market Funds 1 $1,758,044.49 1$549.92 Updated: 311012017