The URL can be used to link to this page

Home My WebLink AboutWK - July 21, 2015A�NDQVEItll T Y O F 1685 CROSSTOWN SO ULt VARU N.W. • AN UUVI,R, MIN NtbU IA 553U4 • (783) 755 -5100 FAX (783) 755 -8923 • WWW.ANDOVERMN.GOV City Council Workshop Tuesday, July 21, 2015 Conference Rooms A & B 1. Call to Order -6:00 p.m 2. Anoka County Sheriff 2016 Contract Proposal Presentation 3. 2015 General Fund Budget Progress Report 4. June 2015 City Investments Review 5. Other Business 6. Adjournment AI T Y O F e DOVE 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304. (763) 755 -5100 FAX (763) 755 -8923 . WWW.CI.ANDOVER.MN.US TO: Mayor and Councilmembers FROM: Jim Dickinson, City Administrator SUBJECT: Presentation of 2016 Anoka County Sheriffs Contract DATE: July21,2015 Anoka County Sheriff James Stuart will be present at the meeting to present the proposed 2016 Law Enforcement Contract. DISCUSSION Attached is the 2016 Anoka County Sheriff Contract proposal costing. The 2016 proposal includes the following: a. 80 hours per day of patrol service b. 6 hours per day of service provided by a Community Service Officer c. School Liaison Officers in the middle school and high school d. 2 Patrol Investigators e. 50% of the Crime Watch Program's coordinator position. The proposed 2016 Anoka County Sheriff contract maintains the status quo and reflects a 0.62% increase ($18.159) over the 2015 contract. ACTION REQUESTED Receive a presentation from the Anoka County Sheriff and provide direction to Administration on how to proceed. ectfully submitted, son chment Andover - Cost Summary January 2016 - December 2016 L PERSONNEL A. Sworn Deputy Sheriff 1.) 16.80 Patrol Deputies 1,160,141 2.) 7 Overtime (Average hours /month per Deputy) 74,461 3.) 2 Liaison Officers 138,112 4.) 2 Patrol Investigators 139,912 B. Non -Sworn C.S.O. 6 hours per day 34,931 Non -Sworn C.S.O. - Parks 8,294 C. Crime Watch Coordinator 20 hours /week 26,333 Benefits for Sworn and Non -Sworn Personnel Total Benefits 717,868 TOTAL PERSONNEL COSTS $2,300,052 II. VEHICLE A. Police Equipped Vehicles 3.5 Squads 104,800 B. C.S.O. Vehicle 1 Vehicle 4,000.00 C.S.O. Vehicle - Parks 0 (split usage with cao vehicle above) 3,200.00 C. Liaison Vehicle 1 Vehicle 25,000.00 D. Crime Watch Coordinator Vehicle - 1/2 2,840.00 E. Patrol /Crime Investigators Vehicles 0.00 F. Total Maintenance Costs for all vehicles 1.) Vehicle 186,562 2.) Emergency & Communications Equipment 20,211 3.) Emergency Vehicle Equip. replc fee 3,750 4.) Insurance 26,600 5.) Cellular Telephone 7,060 Total Maintenance Costs 244,183 TOTAL VEHICLE COSTS $384,023 III. Administrative Costs A. PSDS Increased Maintenance costs 16,787 B. Administrative, Clerical,+ computer fee charges Etc. 235,605 Total Administrative Costs $252,392 IV. TOTAL COST TO CONTRACTING MUNICIPALITY $2,936,467 *Less Amount Received From State for Police State Aid 124,800 NET COST TO CONTRACTING MUNICIPALITY $2,811,667 *This figure is determined by the State and is subject to fluctuation. The latest estimate is $5900 per Deputy. Revenue received is for previous year Deputy hours hired prior to July 1 DetailAdaehed Andover Eighty Hour Coverage 365 DAY&YEAR January 2016 - December 2016 Six Hours C.S.O. 365 DAYSIYEAR Park CSO Twenty Hours/Week - Aprll Through September Includes: 2 FTE Inuestimutor 2 FTE SRO PERSONNEL A. Sworn Deputy Sheriff 1.) 16.80 Deputies at $5,755 /month 1,160,141 2.) 7 Overtime (Average hours /month per Deputy) 74,461 3.) 2 Liaison Officer A. Police Equipped Vehicles 2.5 Squads 138,112 4.) 2 1.0 Patrol & 1.0 Crime Investigators B. C.S.O. Vehicle 1 Vehicle 139,912 B. Nan -Sworn C.S.O.6 hrs /day C.S.O. Vehicle - Parks 0 (split usage With cs, va ie ati 34,931 Non -Swom C.S.O. - Parks Buy l are., Leh yaarcNy- 8,294 C. Benefits for Swom and Non -Swom Personnel more ethers sac year P.E.R.A. (Sworn) 245,045 P.E.R.A. (Non -Swom) 3,242 FICA 3,307 3.) Emergency Vehicle Equipment reply Fee Medicare 21,933 4.) Insurance Severance Allowance 38,830 5.) Cellular Telephone Unemployment Compensation 2,334 Total Maintenance Costs Life Insurance 874 TOTAL VEHICLE COSTS Health Insurance 332,800 III. Administrative Casts Dental Insurance 9,922 A. PSDS Increased Maintenance costs Long Term Disability Insurance 3,328 B. Administrative, Clerical +computer fee charges Etc. Worker's Compensation 23,493 Total Administrative Costs Uniforms 19,696 IV. TOTAL COST TO CONTRACTING MUNICIPALITY Total Benefits $2,883,209 704,803 TOTAL PERSONNEL COSTS JANIM II. VEHICLE A. Police Equipped Vehicles 2.5 Squads 1 Utility 104,800 B. C.S.O. Vehicle 1 Vehicle 4,000.00 C.S.O. Vehicle - Parks 0 (split usage With cs, va ie ati 3,200.00 C. Liaison Vehicle 1Vehicle Buy l are., Leh yaarcNy- 25,000.00 D. Investigator Vehicle 0Vehicle more ethers sac year D. Maintenance Costs 1.) Vehicle 184,862 2.) Emergency & Communications Equipment &replafee 20,211 3.) Emergency Vehicle Equipment reply Fee 3,750 4.) Insurance 25,200 5.) Cellular Telephone 6,880 Total Maintenance Costs 240,903 TOTAL VEHICLE COSTS $377;909^ III. Administrative Casts A. PSDS Increased Maintenance costs 16,787 B. Administrative, Clerical +computer fee charges Etc. 227,865 Total Administrative Costs $2/{,852 IV. TOTAL COST TO CONTRACTING MUNICIPALITY $2,883,209 'Less Amount Received From State for Police State Aid 124,800 NET COST TO CONTRACTING MUNICIPALITY $2,758,409 'Thin figure is &retained by the spate and is subject to fluctuation. The latest esdmete ls$6,000 par Deputy. Revenue mceived is for previous year Deputy hours hired prior to August Andover Crime Watch Coordinator January 2016 - December 2016 Average 20 Hours /Per Week I. PERSONNEL A. Civilian 1.) 1 Crime Watch Coordinator B. Benefits for Non -Sworn Personnel P.E.R.A. (Non -Sworn) FICA Severance Allowance Unemployment Compensation Life Insurance Health Insurance Dental Insurance Long Term Disability Insurance Worker's Compensation Uniforms Total Benefits TOTAL PERSONNEL COSTS II. VEHICLE A. Crime Watch Coordinator B. Maintenance Costs 1.) Vehicle 2.) Cell Phone 3.) Insurance Total Maintenance Costs TOTAL VEHICLE COSTS III. Administrative Costs Administrative, Office Space, Office Supplies, Etc. IV. Program Costs V. TOTAL COST OF CRIME WATCH PROGRAM VI. CRIME WATCH PROGRAM City Of Andover 50 % NET COST TO CONTRACTING MUNICIPALITY 260 DAYSIYEAR 3,950 4,029 1,422 79 42 16,000 477 116 15 0 1 Vehicle leased annually 3,400 360 2,800 52,666 26,130 5,680 6r560 $12,240 $8,481 $7,000 $106,516 $53,258 $53,258 Analysis Of ACSO Patrol Staffing Requirements Andover 1. Community Generated Workload 2,080 • Calls For Service 10,651.00 ' • Handling time /CFS in hrs. ( @34:18 Actual) 0.57 • Total CFS handling time in hrs. 6,067.52 • Officer back -up rate ( @1.4 — Est.) 0.40 • Officer back -up time (back -up @75% of first unit time on scene) in hours. 1,820.26 • Number of bookings (Est.) 282.00' • Booking time (Est. @ 0.75 hrs/booking) in hours 211.50 • Number of reports 10,651.00' • Report writing time (est. @ 30 minutes min. avg) in hours 5325.5 Total Time Required To Handle Community Generated Workloads (Hrs.) 2. Time for Preventative Patrol and Self Initiated Activities OR Alternative Levels of Proactivitv). in Hours. • 50% of Available Time 13,424.78 • 40% of Available Time 8,949.85 3. Total Time Required To Handle Both Reactive and Proactive Activities (In Hrs.l • @ 50% of Available Time 26,849.55 • @ 40% of Available Time 22,374.63 4. Officer Availability Est. Availability • Net shifts worked 2,080 • Net hours lost on shift 362 Net hours worked each year 1,718 5. Deputies Required to Handle Workloads • @ 50% of Proactive Time - • @ 40% of Proactive Time 6. Deputies Required Given Est. Turnover and Time Needed to Academy and Field Train • @ 50% of Proactive Time 16.15 • @ 40% of Proactive Time 13.46 Based on 2014 Calls for Service 06 10912015 C I T Y O F. n ND OVE V�1 . 1685 CROSSTOWN BOULEVARD N.W.. ANDOVER, MINNESOTA 55304. (763) 755 -5100 FAX (763) 755 -8923 . WWW.CI.ANDOVER.MN.US TO: Mayor and Councilmembers FROM: Jim Dickinson, City Administrator SUBJECT: June 2015 General Fund Budget Progress Report DATE: July 21, 2015 The City of Andover 2015 General Fund Budget contains total revenues of $9,876,575 and total expenditures of $10,364,730 (includes $26,000 of 2014 budget carry forward); 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 meeting. The following represents Administration's directives and departmental expectations that are in place again for 2015: 1. Expenditure budgets while approved, expenses are to meet with the spirit that needs are fulfilled first, expansions of service and special requests are to be reviewed with City Administration before proceeding. 2. Departments are to be committed to search for the best possible prices when purchasing goods and services. 3. Departments are to be committed to continually searching out new efficiencies and to challenge the status quo of how the City provides services. 4. Departments are to be committed to searching out collaborative opportunities to facilitate efficient and cost - effective utilization of governmental assets and personnel. 5. Departments are to be committed to developing effective, consistent and ongoing communications with City residents, businesses and other stakeholders. 6. Departments are to be cognizant that services provided are subject to available revenues and should not commit to services that are not sustainable. ACTION REQUESTED The Council is requested to receive a presentation and provide direction to staff. submitted, Imergovcmmenml 609,541 CITY OF ANDOVER 32% 697,493 633,015 292,920 46 0 General Fund Budget Summary Totals 685,900 572,61) 5 %- 945,114 Budget Year 2015 372,203 50°0 176 ,265 Fines IM,750 39 ,543 39% 2015 100,750 46,916 2014 12,247 REVENUES Budget Jun YID % Bud Final Budget Jr. WD %Bud (6,671) Geneml Properly Tax $ 7,501,816 E 150 0% $ 7,476,294 $ 7,706,892 $ - 0% Licenses and Permits 307,355 150,225 49% 364,430 316,588 222,305 70 %_ Imergovcmmenml 609,541 196,810 32% 697,493 633,015 292,920 46 0 Mayor and Conrad arges for Services 685,900 572,61) 5 %- 945,114 748,550 372,203 50°0 176 ,265 Fines IM,750 39 ,543 39% 94,375 100,750 46,916 47% 12,247 Ivveetmevt Income 75,000 95 0% 144,876 75,000 (6,671) -9% 23% Miscellmer., 91,850 108,205 118% 150,386 98,850 106,294 108% 177,427 Tmneoem In 196,930 196,930 100% 196,930 196,930 196,930 100% 135,359 Tobl Rerenum S 9569.(42 5 1.061r9�75 ll• /. S 1_� 04069098 5 9A76S75 S 1230 12 %.yam -_„ 18% Finance 235,459 132,816 56% 230,639 239,981 129,645 54% 9,950 1,583 Total Public Solely 4,383,894 1 2015 4,498,923 4582,938 2,135,173 2014 PUBLIC WORKS EXPENDITURES Budget Jun YTD %Bud Final Budget Jun YTD %Bud 251,814 GENERAL GOVERNMENT 401,360 179,186 45% 387,309 412,937 191,396 Englneering Mayor and Conrad $ $6,840 S 54,498 63% 5 84,650 $ 87,154 $ 55,709 64% Amenmelrmion 176 ,265 79,451 45% 169,219 180,888 80,803 45% Newslmer 26,000 12,247 4% 20,974 26,000 12,264 47% Human Resources 39229 9,073 23% 18,039 40,156 9,453 24% Atom, 178,300 74,091 42% 177,427 182,000 78,417 43% City Clerk 129,400 61,527 48% 128,859 135,359 65,299 48% Elections 55,336 8,427 15% 41,506 57,492 10,426 18% Finance 235,459 132,816 56% 230,639 239,981 129,645 54% Planning& Tuaing 401,360 179,186 45% 387,309 412,937 191,396 Englneering 465,656 212,552 46% 40,871 470,631 220,005 Facility Managemem 562,905 225,717 40% 470,400 579,802 210,540 Total General Gor 2.6833N 1130152 47% 2,479,088 2,734.639 1.126117 36,828 19,695 Youth Services 52,500 PUBLICSAFETY Total Other 89428 57462 pA,- Protection 2,818,132 1,409,066 50% 2,818,132 2,918,308 1459,154 Fire Protection 1,127,389 05963 54% 1,264,020 1,192,330 469,416 Protective Inspection 411,295 1647 ,06 45% 3908 90, 423,161 184,620 Civil DeOmse 17,128 14,163 83% 21,837 39,189 20,400 Animal COmml 9,950 1,729 17% 4,026 9,950 1,583 Total Public Solely 4,383,894 2,214988 51% 4,498,923 4582,938 2,135,173 PUBLIC WORKS Strews and Highways 604,078 251,814 42% 00,315 625,664 277,740 Snow and lee Removal 517,949 385,736 Saar Signs 197,274 102,058 Tragic Signals 35,000 9,602 Strew lighting 36,400 14,360 Strait Lights - Billed 210,000 80,246 Park& Recreation 1,138,426 428,450 Recycling 131,147 49,435 Total Public Warta 2,870,274 1321,701 OTHER Miscellaneous 36,828 19,695 Youth Services 52,500 37,767 Total Other 89428 57462 Total Expenditures $ 10,026,875 5 4,846303 NET INCREASE (DECREASE) 5 (457,733) $ (3781728) 740 637153 52% 186,587 27% 34,902 39% 32,646 38% 201,538 38% 1,005,573 38% 113,901 46% 2,812,615 53% 28,685 72% 52,500 64% 81185 48% $ 9,871,811 216,000 S 198,087 539,770 249.189 203,533 89,511 35,000 11,170 36,400 12,819 216,000 80,400 1,185,338 484,895 135,120 44,000 2976,825 1,249,724 31,728 15,443 38,600 16,000 70328 31,443 5 10364,730 5 4542987 5 (48&155) 5 (331100) -t 41O,C3g 46% 47% 36% 41% 50% - 39% CS� 52% 16% 47% 44%2 46% ) _ 4406 32% 35% 37% 41% 33% 42% 49% 41% 45% 44% O -9 S T Y O F �s DOVER 1685 CROSSTOWN BOULEVARD N.W. - ANDOVER, MINNESOTA 55304•(]63)]55 -5100 FAX (763) 755 -8923 • WWW.CI.ANDOVER.MN.US TO: Mayor and Councilmembers FROM: Jim Dickinson, City Administrator SUBJECT: June 2015 City Investments Review DATE: July 21, 2015 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 June 2015, the June 2015 Investment Detail Report, and the June 2015 Money Market Funds Report. These attachments are intended to assist with discussion when reviewing the June 2015 investments. ACTION REOUESTED The Council is requested to receive a presentation and provide feedback to staff. submitted, Investment Maturities - June 2015 _._ _._. Investment Maturities in Years Credit Fair Less Than More Than __. InvestmrntT a Ratin Value 1 1 -5 6 -]0 10 _ - Money market funds N/A __. $ 1,814,408 $ MN Municipal Money I - -_ Market Fund (4M) _ N/A 4,993 4,993' - FDIC 2,941,282 3,305,544 Certificates of deposit 6,495,809 248,983 t_ Local governments -' A/Al /A2 945,M _I 350,353 491,191 ! 104,008 AAl /AA2/AA3 7,825,200 1 1,363,748 4,343,744 1,617,714 499,993 AAA _ 3,742,998 766,652 i 2,442,169 150,602 383,575 State governments A/AI /A2 _429,518 -- 204,658 - - - 224,860 - - AAl /AA2/AA3 1,167,001 479,375 512,142 175,485 AAA 641,509 75,506 544,693 21,311 U.S.agencies .210,618 AAA 3,084,772 439,932 2,132,507 301,715 FNMA REMIC N/A 11,653 - 11,653 -- U.S. agencies - N/A 850,613 - 850,613 Total investments $ 27,014,025 -L $ 8,440,906 $ 14,634,255 $ 2,740,669 $ 1,198,194 _ Deposits _ -- - 2,006,040 -- Total cash and investments $ 29,02Q,064 June 2015 Investment Detail Description Cusip Number Credit Rating Type purchase Price Carrying Cost Maturity Amount Interest Rate Current Market Value Interest Paid Date Acquired Coupon Date Maturity Due Date Compass Be Birmingham 20451PKKI CD 249,001 249,000.00 249,000.00 0.300% 249,00.47 maturity 12/19114 12111114 07/13115 Gained State Bank 366526AJO CD 200,000.00 200,000.00 200,000.00 1.750% 200,122.00 monthly 01 06120111 0/20115 Paragon Commercial Bank 6991101 CD 249,000,00 249,000.00 249000.00 0300% 249,034.86 matuity 12119114 none 09114115 First Merit Bank (Chin) 320844PH0 GD 249.00000 249,000.00 249,000.00 0250% 249,009.96 maturity 03117115 none 09117115 Flushing Savings Bank 34403ODK4 CD 250,023.39 250,023.39 249,00000 1.750% 250,13046 monthly 0125111 none 10129115 Portage County Bank 73565NAZ6 CO 249,000.00 249,000.00 249,00000 1.650% 250,481.63 monthly 0125111 now 11103115 Mizuho Bank 60688MKD6 CO 249,000.00 249000.00 249,000.00 0.350% 248,98506 maturity 03111115 none 12/11115 Franklin Synergy Bank 35471TBR2 CO 249,00000 249,000.00 249,00000 0.300% 249,019.92 06/05/15 0/05/15 01/05116 First National Bank Beardslwn 321091AH3 CD 249,000.00 249,000.00 249,000.00 0.300% 249,01743 WIOM15 071OW15 01108/16 Sterling Savings Bank 859532AH6 CD 248,000.00 248,00.00 248,000.00 0750% 248,533.20 semi - annual 07131113 01131114 01129116 Pacific Western Bank 695D6YCG2 CD 249,000.00 249,00000 249,000.00 0.400% 248.987.55 maturity 03/08115 none 03/04116 Beal Bank 07370WNF9 CD 249,000.00 249,001 249,000.00 0400% 248,972.61 matunty 03111115 none 03109116 Beaver Dam At 075131GA3 Al local 250,000.00 250,00000 250000.00 0.850% 250.192.50 semi - annual 03122/15 none 09/01115 _ Trenton NJ 8951302V7 A2 local 101,2]7.00 101,27700 100,000.00 4.500% 100,160.00 semi - annual 03124/15 none 07115115 Pell City AL 705880ML3 AA local 100,000.00 100,00000 100,000.00 1200% 100,04000 semi- annual 04125112 08101112 OW01115 70,489.70 Chaska MN 161664DTI AA local 71663.20 71,663.20 70,000.00 2.000% semi- annual 08/15/13 06101114 12/01115 Minneapolis Minn 60374VP35 AA7 local 21,269.40 2126940 20,000.00 3.250% 20,37980 semi- annual 08102111 none 03/01118 Des Moines IA Area Cmnly Col 250097A85 AAt local 137,61 137,668.95 135,000.00 1.3)5% 136,D36.80 semi- annual 07/30112 12/01/12 06/01116 Riley Call Kars Uni Sch Dist 766651 NP4 AA2 local 36,8)6.00 36,8]fi 00 35,000.00 4.73084 35,256.55 semi - annual 05105114 OL01/10 09 /01115 Western Lake Superior MN 958522WG3 AA2 local 101,790.00 101,790.00 100,000.00 2,00% 10,411.00 semi- annual 08116111 04/01/12 10101115 New York NY 64966JAW6 AA2 local 208,324.00 208,324.00 200,000.00 3.170% 202,250.00 semi - annual 04107114 06101111 12101115 PlainfieM 111 726243LT3 AA2 local 79,373.25 ]9.3]325 75,00000 3.000% 75,892.50 semi - annual 12127/12 none 12115115 Duluth Minn ISDd709 264474CK1 A42 local 7493920 74,939.20 70,000.00 4000% ]0,91140 semi - annual 01/18111 none 02/01116 Duluth MN 264438281 AA2 local 105,652.05 105,652.05 105,001 1.W0°b 105,304.50 semi - annual 12105112 08/01113 02101118 Keller TX ISD Zero Coupon 487694DW8 AA2 local 249,0041.00 249,000.00 250,00000 249162.50 maturity 03124115 none 02115/16 Forest TX 7796986H7 AA2 local 101,905.55 101,905.55 95,000.00 3.000% 96,554.20 semi - annual 97110112 OW15112 ODIW16 East Bethel Minn 271074HRO AA3 local 101.00 100,941.00 10,00.00 3200% 101,09.00 semi - annual 12115110 08101111 02/01116 Johnson Cary KS 47870OJ99 AAA local 257,290.00 257,29000 250,000.00 2.000% 251,107.50 semi - annual 12112113 none 10101115 Madison WI 55844RFV5 AAA kcal 103,870.00 103,820.00 100,00000 2000 °0 100,411.00 semi - annual 10101/12 04/01113 10101/15 Hinsdale IL 433416LW2 AAA local 118,011.85 118,01165 115,000.00 2.000% 115,857.90 semi- annual 04123114 12115114 12115115 Three Rivers MN Park Dist 885718GG5 AAA local 210,828.00 210,828.00 200,00000 3000% 203,200.00 semi - annual 12112113 08/01/14 02I01116 Richardson TX 763227EC5 AAA local 98,031 45 98.031 45 95,000.00 3.150% 96,075.40 semi - annual 11112114 none 02115116 III'mois State 452152HR5 A3 state 217,312.00 217,312.00 200,000.00 4961% 204,658.00 semi- annual 07/16/12 0001111 01 Minnesota State 6 129WS7 AA state 225,566.00 225,56600 220,000.00 5.000% 220,91960 semi-annual 01/21115 none 08101/15 Nevada State 641461 NKO AA2 state 258,305.00 258,305.00 250,000.00 4000% 258,45500 semi - annual 06118115 06/01/11 06101116 Taus Slate 002722,728 AAA stale 80,158.50 80,156.50 ]5,000.00 3.000% 75,505.50 _ - -- __ se ml - ann021 al D3 04/01112 10101/15 __- -- Fed Farm Credit Bank 3133EA6K9 AAA US 200,000.00 200,000.00 200.000.00 0410% 200,148.00 semi - annual 10/29112 04129113 1029115 Fed Home Ln MI Corp Zero Cut 31301 HH6 AAA US -- 23927760 - 239,2]]80 240,000.00 239,78640 maturity 12104114 none 12101115 6,621,504.90 Lake Forest Bank &Trust 509685E58 CD 200,000.00 200,000.00 200,000.00 0850% 201,238.00 semi - annual 08/14/13 2113 02114/14 08115116 22 Luang Savings Bank -- 549703MV2 CD 248,000.00 _8 ,000 2020_. 248.00000 248,00000 0750% 249,]01.28 2022__ _.. semi - annual 0 &16113 02/18114 08116116 Syrwvus Bank GA 81764OFL9 CD 248,000.00 248,000.00 248.00000 0600% 248,503.44 semi - annual 09/10114 03001 09106/18 2,941,282.15 CD 2,480,752.25 local 759,538.10 state 439,932.40 US Less Than 1 Year June 2015Impoundment: Detail Descripgan Cusip Number Credit Rating Type Purchase Price Carrying Coat Maturity Amount Interest Rate Current Market Value Interest Paid Data Acquired Coupon Date Maturity Due Date Valley Cam Svgs Bk Reading OH 91944RAE8 CD 150.000.00 150000.00 _._..... 150,000.00 1250% 1111 149,660.50 monthly 12/22/14 0122115 1111 12122/17 Ni Savings Bank FSB 628825JN2 CD 100,000.00 100,000.00 100,000.00 1.500% 100,007.00 semi - annual 01 01125115 07120718 Barclays Bank 06740KHB6 CD 247,0001 247.000.00 247,000.00 2.050% 247,926.25 semi- annual 0]/03/14 01/02115 07102119 Synchrony Bank 87164WBT4 CD 247,000.00 247,000.00 247,000.00 2.050% 24],]53.35 semi - annual 07111114 01/11115 07111119 PrivateBank B Trust CO 74267GU08 CD 247,000.00 247,00000 24],000.00 2.000% 24],657.02 semi- annual 0]21/14 0121115 07122/19 Goldman Sachs Bank USA 1111_. 38747JU59 1111_ CD 247,000.00 24],000.00 _- 247,000.00 2.050% 24],266]6 _. semi- annual _. 0723114 0123115 0])23/19 Bangor Savings Bank 0601 CD 245,00000 245,000.00 245,000.00 1000% 245,13720 semi - annual 07/30/14 01130115 07130/19 Victory Bank 92644LABB _ CD 247,00000 247,00000 247,000.00 2.000% 24],0]1.63 semi - annual 09124114 03/24115 09/24119 Third Federal Eck 8 Loan 884130AW8 C0 128,000.00 128,000.00 128,000.00 2.000% 128,25] 28 semi - annual 11/24114 05/24/15 1125119 Celtic Bank 75778RJM0 CD 247,000.00 247,000.00 247,000.00 2.050% 248,83027 semi - annual 12120113 0820n4 12120719 Steams Bank NA 857894PB9 CD 247,000.00 247.000.00 247,000.00 1.000% 247,298.87 semi - annual 12/26114 0626115 12126/19 1111__ 1101 Cd¢e05 Alliance Bank 77378LAP9 CD 1111 _ 0101. 249,011 249,000.00 249,000.00 1111. 2.000% 249,03735 monmy 01 07/27114 06126120 Elbow Lake MN 284281KC5 A local 170,045,70 170,045.70 000.00 2]50°/ 169,582.05 semi - annual 12108114 none 12101119 Oshkosh WiS Stellrl WV Uti 68826RBD1 At local 1 101,003.00 111 101,007.00 1 _165 11 100,000.00 1 .250% 3.250% _. 103,70000 semi- annual 10105110 05101111 05101118 Oneida County NY 682454382 At local 114,388.00 91,510.40 100,000.00 6.250% 85,671.20 semi - annual 08116/10 none 04/15119 Junction City Kansas 481502F72 A2 local 101,558.00 101,558.00 100,000.00 5.500% _. 111280.. 0' _. semi- annual 05128108 00701109 09101/18 Augusta ME 051411 AN A3 local 22,500.00 22,500.00 20,000.00 5.207% 20,95].80 semi - annual 03107112 none 10101/1] Chaska MN 161664DU6 AA _ local l 1111. 4 78,4.00 78,434.00 75,000.00 2.000% 76383.50 semi- annual 08115113 06/01114 12101116 North Mankato MN Pon Auto Co. 661 AA local 107,657.00 107,657.00 100,000.00 4.000% 103,982.00 semi - annual 09120113 none 02101/17 Philadelphia PA Aulh Zero Coupon 71781LBJ7 AA Ideal 161,700.00 161,]0000 245,000.00 238,691.25 maturity 01/12110 none OW15/1] 1111 -_- N Rice Cry MIN 762698GK8 AA local 5011_ 45,466.80 06 466J 4580 40,000.00 4.400°/ 43,75800 semi-annual 0310])12 none 02/01/19 Lake Mills Wit 510192FAO AA local 90,000.00 90,000.00 90,000.00 0.700% 89,953.20 semi - annual 06122115 none 09/01116 Racine WI 750021604 AA- local 101,79200 101 79200 100,000 00 2.100% 102,067 00 com, amnual 01124112 06101/12 06/01/18 Minnstristo MN 604229KE3 AA, local 10,000.00 10,000.00 10,000.00 2450% 10,007.70 semi- annual 10/10113 0 &01/14' 02/01119 Ramsey MN 751813PB6 AA* Iota] 158.61 158,677.85 145,00000 4500% 148,203.05 semi-annual 01 0401/16 04101119 Steams Cc MN 857896MH4 AA- local 2]6,8]5.00 2]6,8]5.00 250,000.00 4.500% 260,640.00 semi - annual 0417/13 none 116101120 Osseo MN ISO #279 688443J27 AA7 local __. _. 30,103.25 _ 30,103.25 00_01. 25,000.00 soon% 2700250 ml annual 12122111 none 02101117 McKinney TX 581646Y91 AA1 Taal 126,85625 126,856.25 125,000.00 1472% 126,31].50 semi - annual 05120115 none OW15/17 Dane County Wit _. 1111. 0111. 2360911092 MI local 108,487 .00 106,48].00 100000 '0 2.450% 103,003 .00 semi - annual 0]116112 cron e 12/01117 Minneapolis MN 60374VF93 AA local 220.936.00 220,938.00 2011,00000 4.000% 215,790.00 semi - annual 03104114 none 03101/18 King Cnty WA 49474EX5 AA1 Ideal 224,63400 22481 2D0000.00 3.980% 215,32200 semi - annual 03127112 none 12/01118 Minneapolis MN 60374YS73 A41 local 111,898.00 111,898.00 100000.00 3.250% 108,945.00 semi - annual 06105112 12/01/11 12/01118 Cedar Rapids IA 1505288101 AAi _.. local 21 ],fi]200 217,67200 _. 200,000.00 3.000% 209,648.00 semi - annual 06111113 12/01/13 08101119 Minneapolis MN 61 101 local 278,63250 278,632.50 250,000.00 3.500% 268,285.00 semi- annual 02126/13 none 12101/19 Grand Forks NO Sales Tax seven 385492600 AA2 local 104,08200 104,08200 100.000.00 4.000°/ 104,079.00 semi - annual 06123115 00701112 09101118 Buffalo MN ISD #877 1111_ 119655PSt - 1111. - AA2 local 264,250.00 284,250.00 250,000.00 4050% 262,520.00 semi - annual 03110/15 none 02/01117 Waterloo IA 91 AA2 local 105,59400 105594.00 1 00.000 00 3.500% 104,500.00 semi - annual 02124115 none 06101117 Prior Lake MN 742617087 AA2 local 230.000.00 230,000.00 230,000.00 1.000% 229,578.80 semi - annual 05114115 121151 12/15117 __._ 1110 1101_ Hopkins Minn ISD '270 3988_- 439887HC0 AA2 local 95,278.40 9527840 80,00000 5250% 82796.80 semi - annual 04130112 00701/09 02/01118 Scoff County IA 809486EZ2 As local 114,450.33 112,617.00 100000.00 4.400% 106,674.00 semi annual IW31112 12/01/12 O6/01118 Orange Beach ALA 68406PHF1 AA2 local 241,68960 24168960 240,000.00 4400% 255,688.80 semi - annual 00700710 02101/11 02101119 Waterloo lA 941647PA7 AA2 local 50,559.50 50,559.50 __. 50,000.00 2.000 % 07,525.00 semi - annual 06/27/13 311 12/01113 IO11_" 06101118 _pe - Western lake Superior MN 958522WU4 J4 _.. AA2 Ideal 100000.00 10',00000 100.000.00 315 104.475.00 semi - annual OW1 0711 04/01112 10701/19 3,305,544.20 CD June 2015 Investment Datail Description Cusip Number Credit Rating Type Purchase Price Carrying Coal Maturity Amount Interest Rate Current Markel Value P,a Data Acquired Coupon Data Maturity Due Data Portsmouth VA 73723RSLS AA2 local 286,268.00 286,268.00 295,0001 2.400% 300,292.30 semi - annual 07117113 02/01114 02101/20 Kane McHenry Cook B De Kalb Zero Con 484080MB9 AA3 local 157,328.00 157,328.00 200,WO,W 184,082.00 maturity 07116112 none 12101/18 Moorhead MN 6161412R7 AA3 local 108,820.00 108,82000 100,001 3.800% 102,024.00 semi- annual 11114111 none 02101120 Davenport 10x0 238388GS5 AA3 local -. _. 111,948.00 111,948.00 100,000.00 4.650% 105.532.00 semi- annual 09113111 none 06101120 Maple Grove MN 56516PNV5 AAA local 230,520.40 230,52040 220,000.00 2.000% 223,458.40 semi- annual 01/10113 OW01113 02/01/17 Ramsey Cnty MN ]51622JG] AAA )oral 100,000.00 100,000.00 100,000.00 1.130% 1pp,2X 00 semi- annual 0&12114 02101115 02I01I17 Tennessee Valley Auth 080591EA6 AAA local 93,153.11 93.153.11 85,000.00 5500% 92,903.30 semi - annual X /01/09 01/18/08 07118117 Washington County MN 937791KL4 AAA local 115,000.00 115,000.00 115,000.00 3750% 119,659.80 s mi- annual 07101110 01101111 01101118 Saint Louis Park MN 79174OWC3 AAA local 112,114.00 112,114.00 100000.00 3850% 106,47500 semi - annual 12/22/11 none 02/01118 Brownsville TX ISD Zera Coupon 116421E46 AAA 1ora1 229.64000 229,640.00 250,000.00 237 ,700-00 maturity 061 none 0&15118 Minnetonka MNISD #2]fi 604195RA7 AAA local 37,43320 37.43320 35,000.00 3.101 35,991.20 semi- annual 12/22111 none 02101/19 Palm Beach Only FLA 696497TR7 AAA local 256,50480 256,504.60 220,000.00 5.898% 243.31560 semi - annual 07/06111 none 06101/19 Tenn Val Abut Con Strip Zero Con 88059EWZ3 AAA local 262,890.& 26100 300,000.00 278,259.00 maturity 12127113 none 06115119 Norwalk Conn 5681 AAA local 122,464.80 122,464.80 120,000.00 4.050% 125,49360 semi - annual 08104110 OW01 111 OW01119 Greensboro NO 39546OV21 AAA local 366,83280 3681 360,000.00 3.263% 375,742.80 semi - annual 07115111 none 10101/19 Woodbury MN 97973PCD7 AAA local 123,037.35 123,037.35 115.00000 3250% 117609.45 semi - annual 12122111 none 02/01120 Dallas TX lntlpt Sch Dist 2353080K2 AAA local 116,900.00 116,900.00 100,000.00 4.450% 110,805.00 semi - annual 04116112 08115111 02115120 Tenn Valley Auth Zero Cpn 88059EHD9 AAA local 263,970.00 263,970.00 300,00000 274,350.00 maturity 03/11113 none 05101120 Washington Stale 939758DL9 PA stale 205,804.00 205804.00 200,000.00 4.500% 215,072.00 semi - annual 01124112 04101112 10101118 Oregon State 6860SURVO AA1 slate 70,194.60 70,194.60 70,000.00 0.890% 70,284.90 semi - annual 07129114 08101113 08/01116 Massachusetts Stale 57582P2T6 AA1 state 199,744.00 199,744.00 200.00000 2090% 201,82400 semi- annual 12/17114 11/01114 05101/20 Mississippi Slate 605581 BVB AA2 slate 25.00000 2500000 25000.00 1.116% 25,16075 semi- annual 09112113 none 12101/18 Texas State 882723BT5 AAA state 211,414.00 211,414.00 200.00000 4000% 207,964.00 semi - annual 01114115 none 0&01116 Tennessee State 8805410M2 AAA state 20189400 201,894.00 200,000.00 2.326% 205,978.00 semi - annual 10126111 02/01/12 0 &01117 Georgia State 373304RC7 AAA state 28,742.50 26,742.50 25,00000 2970% 26,165.75 semi - annual 02/08/12 none 10101/18 Texas State 882722,51 AAA state 103,089.00 10308900 100,000.00 2.894% 104,585.00 semi- annua1 08110111 04101112 10101118 Fed Farm Credit Bank 3133E-0T86 AAA US 99,847.00 99,64].00 100.000.00 0.900% 10022000 semi- annual 11104113 12100112 06108117 Fetl Natl Mtg Assn 3136G16E4 AAA US 224,325.00 224,32500 225,000.00 0.600% 225,132.75 semi - annual 07111114 none 12128117 Fed Nad Mtg Assn 3136G1AJ0 AAA US 200,000.00 200,000.00 200,000.00 0700% 199,508.00 semi - annual 01130113 07130113 01130I18 Fed Farm Credit Bank 3133ECFA7 AAA US 100.000.00 100,000.00 100,000.00 1.080% 99,859.00 semiannual 02113113 08113113 02113/18 Fed Home Ln Mtg Corp 3134G46D5 AAA US 198,000.00 198,000.00 200,00000 1200% 199,374.00 semi - annual W112113 12/12113 X112/18 Fed Home Ln Mg Carp Med Ten Note 3134G3ZK9 AAA US 200.000.00 200.000.00 200,000.00 1.200% 2X,43400 semi - annual 07/30112 01130113 07130118 Fed Farm Credit Bank 31331y4S6 AAA US 114,000.00 114,000.00 100,000.00 5.050% 111 41800 e s mr- annual 09111113 none 08/01/18 Fed Natl Mig Assn 3136GORB9 AAA US 294,99900 294,999.00 3X,000.00 1.3]5 % 300,480.00 semi- annual 12105113 12128112 _ _ 12128118 Fed Natl Mig Assn 3136GOY70 AAA US 199,300.00 199,301 200,000.00 1080% 197490.00 semi - annual 10130112 01130/13 01/30/19 Fad Farm Credit Bank 3133EC5NO AAA US 99,58700 99,587.00 100,000.00 1.250% 99,429.00 semi - annual 01107113 03104/13 OW04/19 Fetl Farm Credit Bank 3133EE2C3 AAA US 200,000.00 200,000.00 200,000.00 1590% 200,198.00 semi - annual 06125115 12115115 03125119 Fed Farm Credit Bank 3133ECOM AAA US 191,812.W 191,812.00 200,000.00 1.740% 196966.00 5e mrannual 07123113 11121/13 05121120 Fed Nat] Mtg Assn Remic 31393EAL3 US 204,187.& 11444 22 11 209 52 4.500% 11,652.86 monthly 07130103 none 08125118 FICO Strip Pori Zero Coupon 31771EAD3 US 194,572-00 194,572.00 200,000.00 195,886.00 maturity 03116115 none 10106117 FICO Strip Cpn -E Zero Coupon 37771JXM7 US 215,452.16 215,452.16 224,00000 218,480.48 maturity 12111/14 none 11/02/17 FICO Strip Cpn Zero Coupon 31]]1 EAA9 U$ 238.235.00 236,235.00 250,000.00 241,202.50 maturity X109114 14 none __. 05111118 Fed Home Ln Mitt Carp 31393VM01 US 153,656.25 6.091.84 5.94586 4500% 8,16457 monthly 0 &3 1Y03 X11 &18 7,277,101 local 1,056,834.40 state June M15 Investment Detall Description Cusip Number Credit Rating Type Purchase Price Carrying Cast Amount Amount Interest Rafe Current Market Value Interest Paid Dale Acquired Coupon Date Maturity Doe Data FICO Ship Cpnl 3 Zero Coupon 9339 _ 3330 31771C2G9 u5 93,140.00 93,14000 100,00000 _ __ 95,05400 maturity 12129114 noire 0033 12127/18 FICO Ship Clan gem Coupon 31358BPA6 US 94,480.00 94,48000 100,00000 93845.00 maturity 01 none 02101/19 14,634,255.36 Enerbank USA 030._ 29266NA31 . CD 249,00000 9300.0 289,000.00 3390 249,000.00 2.100% 248982.57 ___ monthly 07/18/14 08118114 07/20120 Chaska MN 161663653 AA local 115,122.70 115,12270 110,00000 4.01 113,628.90 semi - annual 0WOW14 none 02/)1124 Mitchell SD Sch Dist #17-2 606687EHO AA Ideal 116,70200 116,702.00 100,000.00 6.000% 110,488.00 semi - annual 12120111 06/15119 06115124 Minnetonka MN 604229KG8 AA, Ideal 161,038.40 161,03840 160,00000 3.100% 160,110.40 semi- annual 10/10113 08/01/14 02/01121 Sashi MN ISD #31 39678LDF6 AA+ local 27,593.50 27,593.50 25,000.00 5.000% 27,525.75 semi - annual 07109113 none 03115121 Minnetdsta MN 604229KJ2 AA- local 40,000.00 40,000.00 40,000.00 3850% 40,03720 semi - annual 10110113 OW01 114 02101123 Savage Minn 80465PAN4 AA- local 19$018.00 198,018.00 200.000.00 4.800% 210,060.00 semi - annual 06117110 02101111 02/01124 Lake City Minn ISD #813 5080840507 AA. local 103.933.00 103,933.00 100,000.00 5.000% 105,047.00 semi - annual 05111111 none 02101125 Middleton Wl 596782RX2 AA local 106,979.00 106,979.00 10000000 3750% 105,262.00 semi- annual 02124/15 none 09/01/20 Des Moines lA Area Cmmy Col 250097H21 AA1 local 50,60600 50,606.00 50,000.00 2450% 50,]9900 semi- annual 11/10/14 12101114 06/01121 Minneapolis MN 50374YG68 AA local 110,419.00 110,419.00 100100000 4.700% 108,183.00 semi - annual 10/31111 none 03/01123 Minneapolis MN 60374YG76 AAI local 72201.35 72201.35 65,00000 4.800% 3330 7029]50 semL annual 12109114 none ___0210_.. 03101/24 3003 Alexandria MN ISD #206 01513I L06 AA2 local 279,760.50 2]9,]60.50 2]0,00000 3000% 289,994.60 semi - annual 01/21/15 none 02101/23 Duluth MN 264438ZL9 AA2 local 29,76] 20 29,767.20 30,000.00 2.625% 28,47] 80 semi - annual 12/05/12 08101113 _02/01/25 Whitewaler Wis 966204KA6 AA3 local 109,541.00 109,541.00 100.000.00 4850% 112,2 V.00 semi - annual 06109111 none 1210120 Hawkins Cnly TN 420218PL7 AA3 Ideal 111,480.00 111,480.00 100,000.00 4800% 105,586.00 semi - annual 03/13/12 none 05/01124 Tenn Val Auth Cpn Ship Zero Cpn 88059EMX9 AAA local 88,133.00 88,13300 100,000.00 90.168.00 maturity OW18113 none 07/15120 Minnetonka MN ISD #276 604195PO4 AAA local 23,491.]3 23,016.40 20,000.00 6200% 20,571.80 semi - annual 11119112 none 01101121 Columbus OH 199492CS6 AAA local 39,956.40 39,95640 40,00000 2.133% 39862 40 semi-annual 02/20/15 none 12101/21 Florida St Dept Environmental 3416OWUAO Al state 217,800.00 217.800.00 200,000.00 6206% 224,860.00 semi - annual 08/30/10 07101110 0710122 Minnesota St Beg Fin Agy Taxable 60415NE24 AA1 state 75.562.50 75,56250 75,000.00 6.300% 76.11675 semi - annual 07127106 01101 /07 07101/23 Minnesota St Colleges & Univ 61 AA2 state 100,000.00 100,000.00 100,000.00 2000% 99,368.00 semi - annual 02126115 10/01115 10101120 Virginia State 928109XD4 AAA stale 22,12600 22,126.00 20,000.00 4.100% 21,31000 semi- annual 02107112 none 0610121 Fee Home Ln Mtg Corp 3128X4S36 AAA US 105,712.00 105,71200 100,000.00 5400% 103,479.00 semi- annual 01/26115 none 0311721 Fed Home Ln Bank 3133803H8 AAA US 200,000.00 200,000.00 200,000.00 1.500% 198,236.00 semi - annual 07230112 01130113 07130/24 2,740,669.27 Itasca County Minn 465452GP9 A local 105,024.00 105,024.00 100,00000 5550% 10400800 semi - annual 07112111 none 02101/28 Milaca Minn ISD #912 5981 AA+ local 106,941 00 106,941.00 100,000.00 5.650% 107,498.00 semi- annual 01 none 0210127 Will County IL Cindy Zero Coupon 969078OM9 AA2 local 159,000.00 159,000.00 500,000.OD 279,525.00 maturity 0825109 none 11101127 Van Buren Mich Public Schools 92072911D5 AA2 Ideal 10 ?]50.00 102,750.00 109000.00 6430% 112,970.00 semi - annual 07117/09 11101109 05101129 Tennessee Valley Act, Bar E 880591CJ9 AAA local 121,50000 121,500.00 100,000.00 6.750% 133,57500 semi - annual 03/19109 none 11101125 Ice Deposit National Sports Center none local 250.00000 250,000.00 250,000.00 250,000.00 maturity 02106108 none 01101126 Fed Home Ln Bank 313381051 AAA US 93750.00 93.750.00 100,000.00 2.000% 89,203.00 semi - annual 12/23114 none 11/23/27 121,415.00 Fed Farm Credit Bank 31331VLC8 AAA US 106030.45 106,01 100,000.00 5250% semi - annual 02126110 none 0421128 1,196,194.00 25,194,623.53 2,994,772.16 US 1- 5 Years 248,982.57 CD 1,768,316.35 local 421,655.35 state 301,715.00 US 6 - 30 Years 987,576.00 local 210,618,00 US 10 +Years INVESTMENT SCHEDULE - Money Market Funds June 30, 2015 Description Current Market Value YTD Interest Wells Far o I Wells Fargo Government Money Market Fund 1 $1,814,407.82 $118.07 4M I 14M 1,892.52 - 4M PLUS 3,100.71 IFRP7PluT7 Grand Total Money Market Funds 1 $1,819,401.05 1 $118.67 Updated. 7/13/2015