The URL can be used to link to this page

A-2. Second Quarter Revenue Activity, 2015 Preliminary Budget; Department Budget Presentations9 CITY OF CHMMSSEN 7700 Market Boulevard PO Box 147 Chanhassen, MN 55317 Administration Phone: 952.227.1100 Fax: 952.227.1110 Building Inspections Phone: 952.227.1180 Fax: 952.227.1190 Engineering Phone: 952.227.1160 Fax: 952.227.1170 Finance Phone: 952.227.1140 Fax: 952.227.1110 Park & Recreation Phone: 952.227.1120 Fax: 952.227.1110 Recreation Center 2310 Coulter Boulevard Phone: 952.227.1400 Fax: 952.227.1404 Planning & Natural Resources Phone: 952.227.1130 Fax: 952.227.1110 Public Works 7901 Park Place Phone: 952.227.1300 Fax: 952.227.1310 Senior Center Phone: 952.227.1125 Fax: 952.227.1110 Website www.ci.chanhassen.mn.us MEMORANDUM TO: Mayor and City Council FROM: Greg Sticha, Finance Director 6�01 DATE: August 11, 2014 SUBJ: 2015 Budget Discussion; 2014 First Half Financial Update; and Detailed Department Budget Presentations: Administration, Community Development, Finance, Law Enforcement, and Related Budgets BACKGROUND During this evening's 2015 budget discussion, staff will present three different scenarios for setting the preliminary levy. Items that will be reviewed include the assumptions made while preparing the budget document, the impact of each scenario on the average home, and staff's recommendation for setting the preliminary levy. Attached is the budget document that will be used to present the detailed PowerPoint presentations at tonight's meeting and on August 26. The preliminary levy will be set at the September 9th meeting. 2014 IF' RST HALF FINANCIAL UPDATE Attached find the first half of 2014 revenue and expenditure actual compared to budget performance for the city's general fund. On the revenue side, all revenue collections are meeting budget expectations to this point in 2014. It appears that, based on current collections, building permit revenue should finish with a similar surplus as compared to 2013 (approximately $200,0004300,000). On the expenditure side, all line items appear to be on par with the expected budgets to this point in 2014. Also find attached the city's investment portfolio analysis and performance thru June 30, 2014. The portfolio is currently earning around 1.20% on average. The distribution between sectors is also excellent with a fairly even distribution among CD's, government agencies and highly rated municipal bonds. The portfolio has an average maturity duration of 1.76 years and therefore is positioned very well to take advantage of the potential of increasing rates in the near future. Chanhassen is a Community for Life - Providing for Today and Planning for Tomorrow Mayor & City Council August 11, 2014 Page 2 BUDGET ASSUMPTIONS Staff has prepared the preliminary budget based on the following assumptions: 1. A 3.0 percent wage increase for employees in 2015 2. Establishing building permit revenue at the same level as 2014 3. An increase in healthcare costs of 15% 4. Law enforcement contract increase of 3% ($70,000) for inflationary increases in salaries and benefits The assumptions noted above were discussed in great detail over the past couple months. Assuming that building permit revenue in the second half of 2014 will be similar to the first half of the year, it is anticipated that we should exceed budget on this line item. However, staff felt it was prudent to set the budgeted permit revenue for 2015 at the same level as 2014. For 2015, staff is again going out for bids on health insurance. We have budgeted a 15% increase. Staff expects to have final quotes by the middle of September. Additionally, the city experienced a 1.76% increase in new construction. This results in about $181,881 in new property tax dollars payable in 2015. SCENARIOS When discussing the following scenarios, it is important to note that the average home in Chanhassen increased in value by over 10% for budget year 2015. As always, the value of individual homes compared to the average home will dictate the final outcome of individual property tax bills. Scenario #1: This scenario includes an increase in the total levy from the previous year of $221,881 or 2.15 %. Included in that amount is $181,881 in new property tax dollars, thus resulting in a .38% or $3 -4 increase in the city portion of the property tax bill for the average home in the city. ($40,000 above new growth) This scenario includes a 3.0% wage increase for employees, 15% for the increase to the healthcare contract, $71,500 for an increase in the police services contract, and other small adjustments to various line items (both decreases and increases). Scenario #2: This scenario includes an increase in the total levy of $181,881 or 1.76 %, which is the amount of new construction for taxes payable in 2015. This would result in a zero percent increase in the city portion of the property tax bill on the average home in the city (new growth). £ \gregs \budget\2015 budget \8 -11 prelim bud discussion.docx Mayor & City Council August 11, 2014 Page 3 In order to achieve this levy, $40,000 in levy reduction dollars would need to be implemented as compared to scenario #1. Staff will discuss some of the potential ideas to achieve this levy scenario at our August 25th work session. Scenario #3: The third scenario includes an increase in the total levy of $81,881 or 0.79% from the previous year. This would result in a.95% or $7 -$9 decrease in the city portion of the property tax bill on the average home ($100,000 below new growth). In order to achieve this levy, $140,000 in levy reduction dollars would need to be implemented as compared to scenario #1. Staff will discuss some of the potential ideas to achieve this levy scenario at our August 25th work session. RECOMMENDATION Based on all the information presented above, staff believes setting a preliminary levy as described in Scenario #1 would give the most flexibility before setting a final levy in December. Staff has researched all estimated costs and revenues to the fullest extent possible at this point in the year; however, a number of factors could either adversely or positively impact the budget between now and December. Since the final levy can only go down from the preliminary levy, staff believes setting a levy lower than Scenario #1 would not give the city as much flexibility to recover from any potential adverse factors that could impact the budget. NEXT STEP No action is required on this item. At our August 25th work session, department heads will present their proposed 2015 budgets. Their presentations will be based on Scenario #1 and will highlight any significant changes in their departments. ATTACHMENTS 1. Levy Impact Scenarios 2. Detailed General Fund Expenditure & Revenue Budget 3. Carver County Assessor's Office - Chanhassen Assessment Summary 4. Revolving Assessment Construction Fund 5. Debt Levies 6. 2014 first half revenue and expenditure actual vs. budget comparison in the general fund 7. Wells Fargo investment portfolio analysis for the city's investment portfolio as of June 30, 2014 f.\gregs\budget\20l5 budget \8 -11 prelim bud discussion.docx OPERATIONAL & CAPITAL LEVY General Fund Capital Replacement Fund (for equipment) Revolving Imp Street Reconstruction Pavement Mgmt Fund (Sealcoating) Total Operational & Capital Levy DEBT LEVY General Obligation Debt (212 Bonds) Audubon /Revolving Assess Fund /EDA Public Works Facility Library Referendum Total Debt Levy TOTAL TAX LEVY CITY OF CHANHASSEN TAX LEVY 2015 Budget 2014 2015 Dollar Percent Levy Levy Change Change $7,629,950 $7,711,831 800,000 800,000 - 395,192 185,000 185,000 8,614,950 9,092,023 477,073 5.54% 233,800 232,300 444,410 55,000 592,100 590,600 448,880 446,098 1,719,190 1,323,998 395,192 - 22.99% $10,334,140 $10,416,021 $81,881 0.79% Tax Generation Capacity (Not actual levy, Used only for estimating the impact on the average home) Prior Year $10,334,140 $10,334,140 $10,334,140 New Construction (1.76 %) $181,881 $181,881 $181,881 Total Capacity $10,516,021 $10,516,021 $10,516,021 Percent Change (To avg home city prop tax) after New Growth 0.38% 0.00% -0.95% Assumes the average home in Chanhassen of $330,000 and approx 10% valuation increase Scenario #1 Scenario #2 Scenario #3 Levy Levy Levy Taxes applied to: General Fund $7,851,831 $7,811,831 $7,711,831 Capital Replacement 800,000 800,000 800,000 Pavement Mgmt 185,000 185,000 185,000 Revolving Imp St Recon 395,192 395,192 395,192 Total Levy subject to levy limits $9,232,023 $9,192,023 $9,092,023 Library Referendum $446,098 $446,098 $446,098 GO Debt/212 Bonds 232,300 232,300 232,300 Public Works Facility 590,600 590,600 590,600 Audubon 55,000 55,000 55,000 Total $10,556,021 $10,516,021 $10,416,021 Tax Generation Capacity (Not actual levy, Used only for estimating the impact on the average home) Prior Year $10,334,140 $10,334,140 $10,334,140 New Construction (1.76 %) $181,881 $181,881 $181,881 Total Capacity $10,516,021 $10,516,021 $10,516,021 Percent Change (To avg home city prop tax) after New Growth 0.38% 0.00% -0.95% Assumes the average home in Chanhassen of $330,000 and approx 10% valuation increase 2015 Tax Levy 2014 2015 % Change Operational & Capital Levies General Fund $ 7,629,950 $ 7,851,831 Capital Replacement 800,000 800,000 Revolving Imp Street Reconstruction - 395,192 VISA Sealcoatin 185,000 185,000 Total Operational & Capital Levies $ 8,614,950 $ 9,232,023 7.16 % Debt Levies General Obligation Debt (212 Bonds) $ 233,800 $ 232,300 Audubon 444,410 55,000 Public Works Facility 592,100 590,600 Library Referendum 448,880 446,098 Total Debt Levies $ 1,719,190 $ 1,323,998 - 22.99% Total All Levies $ 10,334,140 $ 10,556,021 2.15% 2015 General Fund Budget Expenditures Personal Materials Contractual Capital 2015 2014 % 2013 Services & Supplies Services Outlay Total Total Change Actual General Government 1110 1120 1130 1140 Legislative Administration Finance Legal 32,200 480,100 255,900 - - - 200 - 76,700 51,100 51,400 161,000 - - - - 108,900 531,200 307,500 161,000 109,300 508,749 295,800 148,000 -0.37% 4.41% 3.96% 8.78% 122,198 506,943 283,928 159,919 1150 Property Assessment. - - 130,000 - 130,000 130,000 0.00% 123,590 1160 MIS 195,200 30,000 46,200 - 271,400 264,600 2.57% 251,747 1170 City Hall 77,000 39,800 291,400 - 408,200 407,600 0.15% 382,540 1180 Elections 22,500 3,500 12,200 - 38,200 38,200 0.00% 48 1190 Library Building - 3,000 111,300 - 114,300 114,200 0.09% 119,430 * Total 1,062,900 76,500 931,300 - 2,070,700 2,016,449 2.69% 1,950,343 Law Enforcement 1210 1220 1250 1260 Police Administration Fire Prevention & Admin Code Enforcement Community Service 72,200 604,500 643,500 58,400 3,000 48,900 6,500 2,300 1,674,000 143,100 12,400 7,600 - - - - 1,749,200 796,500 662,400 68,300 1,676,000 754,900 646,800 71,000 4.37% 5.51% 2.41% -3.80% 1,579,282 778,547 659,065 54,080 * Total 1,378,600 60,700 1,837,100 - 3,276,400 3,148,700 4.06% 3,070,974 Public Works 1310 Engineering 590,300 900 30,400 - 621,600 602,100 3.24% 583,222 1320 Street Maintenance 736,100 119,400 27,500 - 883,000 849,900 3.89% 863,434 1350 Street Lighting & Signals - 3,000 364,500 - 367,500 351,500 4.55% 351,219 1370 Fleet Department 287,100 203,500 68,500 5,500 564,600 556,800 1.40% 539,077 * Total 1,613,500 326,800 490,900 5,500 2,436,700 2,360,300 3.24% 2,336,951 Community Development 1410 1420 1430 Planning Commission Planning Administration Senior Commission - 397,100 24,000 200 400 - 3,600 11,500 9,700 - - - 3,800 409,000 33,700 4,000 396,700 33,700 -5.00% 3.10% 0.00% 3,196 378,465 32,461 * Total 421,100 TO- 0 24,800 - 446,500 434,400 2.79% 414,121 Park & Recreation 1510 Park & Rec Commission - 200 2,600 - 2,800 2,800 0.00% 2,842 1520 Park & Rec Administration 145,200 400 6,700 - 152,300 145,700 4.53% 140,493 1530 1540 1550 1560 Recreation Center Lake Ann Park Operations Park Maintenance Senior Citizens Center 211,400 8,700 805,000 49,800 35,000 10,200 77,100 3,300 92,700 41,800 90,600 19,900 - - 4,000 - 339,100 60,700 976,700 73,000 340,800 60,700 959,500 73,000 -0.50% 0.00% 1.79% 0.00% 321,319 63,823 976,898 70,728 1600 Recreation Programs 191,600 20,300 97,000 - 308,900 296,200 4.29% 299,925 1700 Self- Supporting Programs 36,300 5,200 22,000 - 63,500 65,100 -2.46% 57,064 1.800 Recreation Sports 20,100 8,800 300 - 29,200 25,300 15.42% 25,528 * Total 1,468,100 160,500 373,600 4,000 2,006,200 1,969,100 1.88% 1,958,620 Total Operational Expenditures 5,944,200 625,100 3,657,700 91500 10,236,500 9,928,949 3.10% 9,731,009 Transfer for Roads _ ** Total General Fund 10,236,500 9,928,949 3.1010 9,731,009 307,551 Dollar Change from Previous Year 2015 General Fund Budget Revenue Account Description 2012 Actual 2013 Actual 2014 Budget 2014 Projected 2015 Budget Inc Over PY Budget General Property Tax 3213 Solicitor 3226 Liquor On and Off Sale 3230 Rental Housing Licenses 3010 Current Property Tax 7,299,721 7,398,275 7,629,950 7,629,950 7,851,831 2.9 % 3002 Allowance for Delinquent Taxes (61,726) (100,528) (150,000) (150,000) (110,000) Misc. Permits 3011 Delinquent Property Tax 186,198 159,899 150,000 150,000 135,000 480,000 * Total General Property Tax 7,424,193 7,457,646 7,629,950 7,629,950 7,876,831 3.2 % Licenses 3401 3203 Dog Kennel 3205 Dog or Cat 3206 Massage License 3213 Solicitor 3226 Liquor On and Off Sale 3230 Rental Housing Licenses 3284 Rubbish * Total Licenses Permits 3401 3301 Building 3302 Plan Check 3305 Heating & A/C 3306 Plumbing 3307 Trenching 3308 Hunting /Shooting 3309 Sprinkler 3311 Sign 3316 Septic Tank 3320 Stable 3330 Elec Permit App Forms 3331 Firework's Application Fee 3390 Misc. Permits * Total Permits Fines & Penalties 3401 Traffic & Ordinance Violation 3402 Vehicle Lockouts 3404 Dog /Cat Impound 3405 Other Fines and Penalties * Total Fines & Penalties Intergovernmental Revenue 3503 Reimbursement from School Dist. 3509 Other Shared Taxes 3510 Grants -State 3520 Grants - County 3533 Grants -Other * Total Intergovernmental Revenue 575 425 500 500 500 600 575 1,000 1,000 1,000 94,610 97,108 94,000 94,000 97,000 3,900 3,600 4,000 4,000 4,000 99,685 101,708 99,500 99,500 102,500 3.0 % 644,522 617,896 480,000 480,000 480,000 311,597 319,672 220,000 220,000 220,000 110,441 124,288 82,800 82,800 82,800 83,803 96,091 65,000 65,000 65,000 43,485 42,565 30,000 30,000 30,000 1,340 1,080 1,400 1,400 1,400 12,377 11,593 11,000 11,000 11,000 6,995 6,665 6,500 6,500 6,500 - 1,119 - 210 220 300 300 300 - 200 - - - 2,870 3,862 3,000 3,000 3,000 1,217,640 1,225,251 900,000 900,O00 900,000 0.0% 115,729 98,968 120,000 120,000 110,000 1,250 1,000 2,500 2,500 2,500 2,993 - - - - 25 16 - - - 119,996 99,984 122,500 1220500 112,500 -8.2% 43,034 42,899 45,000 45,000 45,000 130,421 179,095 130,000 130,000 160,000 111,815 136,734 110,000 110,000 125,000 800 - - - 286,070 358,728 285,000 285,000 330,000 15.8% 2015 General Fund Budget Revenue I 2012 2013 2014 2014 2015 Inc Over 4ccount Description Actual Actual Budget Projected Budget PY Budget Charges for Current Services 3601 Sale of Documents 304 1,086 500 500 500 3602 Use & Variance Permits 11,069 21,832 7,000 7,000 10,000 3603 Rezoning Fees 550 1,950 500 500 1,000 3604 Assessment Searches 195 330 200 200 200 3605 Plat Recording Fees 4,942 4,590 2,000 2,000 4,000 3607 Election Filing Fees 30 - - - - 3613 Misc.- General Government 4,560 4,155 3,200 3,200 4,000 3614 Admin. Charge -2% Constr. 62,225 82,126 25,000 25,000 50,000 3615 Admin, Charge -5% Street Re- Constr. - - 20,000 20,000 - 3615 Admin. Charge -5% Utility Projects - - - - _ 3617 Engineering General 90 - - - - 3619 Investment Management Fee 75,000 75,000 75,000 75,000 75,000 3629 Misc.- Public Safety 8,194 8,403 10,000 10,000 10,000 3630 Recreation Program Fees 39,923 35,372 40,000 40,000 38,000 3631 Recreation Center 210,565 211,744 218,000 218,000 215,000 3633 Park Equipment Rental 37 70 300 300 300 3634 Park Facility Usage Fee 14,525 18,952 14,000 14,000 18,000 3635 Watercraft Rental 7,942 8,181 7,000 7,000 8,000 3636 Self- Supporting Programs 55,315 57,609 60,000 60,000 58,000 3637 Senior Programs 33,414 28,636 34,000 34,000 32,000 3638 Food Concessions 11,825 11,421 12,000 12,000 12,000 3639 Misc. -Park & Rec. 1,123 1,076 1,200 1,200 1,200 3641 Youth Sport Donation - - - - - 3642 Recreation Sports 34,822 42,245 35,000 35,000 46,300 3649 Misc.-Public Works 3,300 3,600 3,500 3,500 3,500 3651 Merchandise Sales 1,236 2,375 1,500 1,500 1,500 3670 Internment Fee 100 100 - - - * Total Charges for Current Services 581,286 620,853 569,900 569,900 588,500 3.3% Other Revenue 3801 Interest Earnings 29,148 (5,118) 45,000 45,000 45,000 3802 Equipment Rental & Sale 164,153 173,300 166,000 166,000 172,000 3803 Building Rental 5,420 5,420 7,000 7,000 5,500 3804 Land Sale 1,200 1,200 - - - 3807 Donations 20,885 19,645 21,799 21,799 21,369 3816 SAC Retainer 5,108 5,552 6,000 6,000 6,000 3818 Sur -Tax Retainer 849 847 1,000 1,000 1,000 3820 Misc. Other Revenue 228 381 300 300 300 3903 Refunds /Reimbursements 66,574 83,080 75,000 75,000 75,000 3980 Cash Short /Over (3) (1) - - - * Total Other Revenue 293,564 284,306 322,099 322,099 326,169 1.3% Total General Fund Revenue 10,422,433 10,148,476 9,928,949 9,928,949 10,236,500 3.1% Total General Fund Expenditures 10,236,500 Net Levy Remaining (Use of Gen Fund Reserves) - 2015 General Fund Budget Legislative (1110) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4020 Salaries & Wages -Temp 4030 Contributions - Retirement 4050 Workers Compensation * Total Personal Services 4120 Supplies- Equipment * Total Materials & Supplies 4300 Fees, Services 4330 Postage 4340 Printing & Publishing 4360 Subscriptions & Memberships 4370 Travel & Training 4375 Promotional Expenses 4933 Sales Tax * Total Contractual Services 29,900 30,550 30,000 30,000 0.0% 2,052 2,089 2,200 2,100 (4.5 %) 52 64 100 100 0.0 % 32,004 32,703 32,300 32,200 (0.3 %) 13 - - - 0.0% 13 - - - 0.0 % 1,758 17,322 3,000 3,000 0.0% 85 - - - 0.0% 31,710 32,316 35,000 33,000 (5.7 %) 32,161 33,986 33,000 34,500 4.5% 5,831 5,142 5,000 5,200 4.0% 3,203 695 1,000 1,000 0.0% 3 34 - - 0.0% 74,751 89,495 77,000 76,700 (0.4 %) ** Total Legislative 106,767 122,198 109,300 108,900 (0.4 %) 2015 General Fund Budget Adminstration (1120) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4010 Salaries & Wages -Reg 4011 Overtime -Reg 4020 Salaries & Wages -Temp 4030 Contributions - Retirement 4040 Contributions - Insurance 4050 Workers Compensation * Total Personal Services 4120 Supplies- Equipment 4130 Program Supplies 4210 Books & Periodicals * Total Materials & Supplies 4300 Fees, Services 4310 Telephone 4320 Utilities 4330 Postage 4340 Printing & Publishing 4360 Subscriptions & Memberships 4370 Travel & Training 4380 Mileage 4410 Rental - Equipment 4807 Property Tax Expense 4933 Sales Tax * Total Contractual Services 317,381 339,279 345,700 367,800 6.4% - 520 - - 0.0% 220 228 1,000 1,000 0.0% 45,612 47,707 51,500 55,800 8.3% 34,915 47,507 51,800 53,000 2.3% 2,107 1,404 2,000 2,500 25.0% 400,235 436,645 452,000 480,100 6.2 % 89 161 - - 0.0% - 43 - - 0.0% 2,895 13,239 4,012 5,466 36 37 21,513 23,090 577 71 3,565 3,558 7,185 8,468 5,215 - 14,175 14,215 64 1,684 57 35 59,294 69,863 ** Total Administration 459,983 506,943 200 100.0% 200 - (100.0 %) 7,000 6,000 (14.3 %) 4,100 5,500 34.1% - - 0.0% 23,000 24,000 4.3% 300 300 0.0% 4,000 3,800 (5.0 %) 8,000 8,000 0.0% 500 500 0.0% 9,649 3,000 (68.9 %) - - 0.0% - - 100.0% 56,549 51,100 (9.6%) 508,749 531,200 4.4 % 2015 General Fund Budget Finance (1130) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4010 Salaries & Wages -Reg 4011 Overtime -Reg 4030 Contributions - Retirement 4040 Contributions - Insurance 4050 Workers Compensation * Total Personal Services 4120 Supplies- Equipment 4210 Books & Periodicals * Total Materials & Supplies 180,647 184,435 - 66 26,411 26,936 22,593 24,483 1,098 809 230,749 236,728 188,000 196,000 4.3% - - 0.0% 28,000 29,700 6.1% 26,700 29,000 8.6% 1,200 1,200 0.0% 243,900 255,900 4.9 % 100 100 100 100 200 200 0.0% 0.0% 4300 Fees, Services 22,809 16,743 20,000 20,000 0.0% 4301 Fees, Financial /Audit 24,139 23,837 24,000 24,000 0.0% 4310 Telephone and Communications 910 790 1,000 1,000 0.0% 4340 Printing & Publishing 1,018 418 1,100 700 (36.4 %) 4360 Subscriptions & Memberships 225 465 300 500 66.7% 4370 Travel & Training 5,300 4,657 5,200 5,200 0.0% 4530 Repair & Maintenance -Equip - - 100 - (100.0 %) 4901 Refunds/ Reimbursements 27 21 - - 0.0% 4933 Sales Tax - 22 - - 0.0% * Total Contractual Services 54,428 46,954 51,700 51,400 (0.6 %) 4703 Office Equipment - 246 - - 0.0% * Total Capital Outlay - 246 - - 0.0 % ** Total Finance 285,177 283,928 295,800 307,500 4.0% 2015 General Budget Legal 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4302 Fees, Legal 134,256 159,919 148,000 161,000 8.8% 4340 Printing and Publishing 830 - - - 0.0% * Total Contractual Services 135,086 159,919 148,000 161,000 8.8% ** Total Legal 135,086 159,919 148,000 161,000 8.8% 2015 General Fund Budget Property Assessment (1150) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget %Q Inc /(Dec) 4300 Fees, Services 128,190 123,590 130,000 130,000 0.0% 4340 Printing & Publishing 118 - - - 0.0% * Total Contractual Services 128,308 123,590 130,000 130,000 0.0% ** Total Property Assessment 128,308 123,590 130,000 130,000 0.0 % 2015 General Find Budget Management Information Systems (MI5) (1160) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4010 Salaries & Wages -Reg 4020 Salaries & Wages -Temp 4021 Overtime -Temp 4030 Contributions - Retirement 4040 Contributions - Insurance 4050 Workers Compensation * Total Personal Services 4150 Supplies- Equipment 4210 Books & Periodicals 4220 Software Licensing & Support 4260 Small Tools & Equipment * Total Materials & Supplies 4300 Fees, Services 4310 Telephone and Communications 4320 Utilities 4350 Cleaning & Waste Removal 4370 Travel & Training 4530 Repair & Maintenance -Equip 4933 Sales Tax * Total Contractual Services 140,513 142,160 146,100 147,600 1.0 % 5,382 - - - 0.0 % 45 - - - 0.0 % 20,915 19,260 21,800 22,300 2.3% 19,441 19,696 23,200 24,200 4.3 % 888 1,453 900 1,100 22.2% 187,184 182,569 192,000 195,200 1.7 % 1,279 1,225 1,300 1,300 0.0% 286 20 300 300 0.0 % 22,926 29,953 28,800 28,100 (2.4 %) 370 40 300 300 0.0% 24,860 31,237 30,700 30,000 (2.3 %) 28,864 17,271 17,700 21,300 20.3% 2,512 3,107 3,200 3,300 3.1 % 6,279 9,055 13,000 10,600 (18.5 %) - 231 - - 0.0 % 5,011 3,547 4,000 6,000 50.0% 4,921 4,269 4,000 5,000 25.0% 1,323 461 - - 0.0% 48,910 37,941 41,900 46,200 10.3 % ** Total MIS 260,954 251,747 264,600 271,400 2.6% a a • � � � + a • City Kali (1170) 2014 to 2012 2013 2014 2015 2015 Iccount Description Actual Actual Budget Budget %fl Inc /(Dec', 4010 Salaries & Wages -Reg 4011 Overtime -Reg 4030 Contributions - Retirement 4040 Contributions - Insurance 4050 Workers Compensation * Total Personal Services 4110 Supplies -Office 4120 Supplies- Equipment 4140 Supplies - Vehicles 4150 Maintenance Materials 4260 Small Tools & Equipment * Total Materials & Supplies 4300 Fees, Services 4310 Telephone 4320 Utilities 4350 Cleaning & Waste Removal 4370 Travel & Training 4410 Rental- Equipment 4440 License & Registration 4483 Insurance - General Liability 4510 Repair & Maintenance - Building 4520 Repair & Maintenance - Vehicles 4530 Repair & Maintenance -Equip 4933 Sales Tax * Total Contractual Services 4705 Other Equipment * Total Capital Outlay 52,774 53,344 54,700 55,700 1.8 % 900 1,033 3,000 1,500 (50.0 %) 7,948 8,129 8,100 8,300 2.5% 7,337 7,965 8,600 9,300 8.1% 1,844 2,073 2,000 2,200 10.0% 70,803 72,544 76,400 77,040 0.8 % 42,611 30,924 39,100 34,800 (11.0 %) 443 981 900 900 0.0% 166 259 500 300 (40.0 %) 3,814 4,398 3,200 3,400 6.3% 968 238 400 400 0.0 % 48,002 36,800 44,100 39,800 (9.8 %) 5,359 7,486 7,700 7,500 (2.6 %) 12,168 11,027 12,500 12,000 (4.0 %) 44,078 47,348 44,700 48,000 7.4 % 35,805 32,917 33,800 33,800 0.0 % 29 114 200 200 0.0% - - - 13,700 100.0% 16 - 100 100 0.0% 156,708 159,421 175,000 163,000 (6.9 %) 6,313 8,151 7,700 7,700 0.0% - - 600 200 (66.7 %) 4,640 6,314 4,800 5,200 8.3 % 2,686 356 - - 0.0 % 267,802 273,135 287,100 291,400 1.5 % 62 - - 0.0% 62 - - 0.0% ** Total City Hall 386,607 382,540 407,600 408,200 0.1 % 2015 General Fund Budget Elections (1180) 2014 to 2012 2013 2014 2015 2015 count Description Actual Actual Budget Budget %u Inc /(DE 4020 Salaries & Wages -Temp 4030 Contributions - Retirement 4050 Workers Compensation 4060 Unemployment * Total Personal Services 4110 Office Supplies 4120 Supplies- Equipment * Total Materials & Supplies 4300 Fees, Services 4340 Printing & Publishing 4370 Travel & Training 4933 Sales Tax * Total Contractual Services 28,184 - 22,000 22,000 0.0 % 106 - 400 400 0.0 % - - 100 100 0.0 % - - - - 0.0% 28,290 - 22,500 22,500 0.0 % 1,504 - 1,500 1,500 0.0 % - - 2,000 2,000 0.0% 1,504 - 3,500 3,500 0.0 % 13,033 - 7,000 7,000 0.0% 1,408 - 2,000 2,000 0.0 % 6,703 48 3,200 3,200 0.0 % 43 - - - 0.0 % 21,187 48 12,200 12,200 0.0 %9 ** Total Elections 50,981 48 38,200 38,200 0.0 % 2015 General Fund Budget � ihrary Bu!"'dinng ('1193) Account Description 4150 Maintenance Materials 4260 Small Tools & Equipment * Total Materials & Supplies 4300 Fees, Services 4310 Telephone 4320 Utilities 4350 Cleaning & Waste Removal 4510 Repair & Maintenance - Building 4530 Repair & Maintenance -Equip * Total Contractual Services ** Total Library Building 2014 to 2012 2013 2014 2015 2015 Actual Actual Budget Budget % Inc /(Dec) 3,397 3,925 3,000 3,000 0.0% 29 1,618 - - 0.0% 3,426 5,543 3,000 3,000 (45.9 %) 645 4,301 6,000 4,500 (25.0 %) 1,450 1,525 1,600 1,600 0.0% 58,973 69,710 64,300 65,000 1.1% 32,503 32,902 31,000 33,500 8.1% 2,517 3,226 3,500 3,500 0.0% 3,035 2,223 4,800 3,200 (33.3 %) 99,123 113,887 111,200 111,300 0.1% 102,549 119,430 114,200 114,300 0.1 % 2015 General Fund Budget Police Administration (1210) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4010 Salaries & Wages -Reg 4030 Contributions - Retirement 4040 Contributions - Insurance 4050 Workers Compensation * Total Personal Services 4130 Program Supplies * Total Materials & Supplies 4300 Fees, Services 4360 Subscriptions & Memberships 4370 Travel & Training 4375 Promotional Expense 4933 Sales Tax * Total Contractual Services 51,442 52,382 53,500 54,600 2.1 % 7,674 7,810 8,000 8,300 3.8 % 7,333 7,970 8,500 9,000 5.9 % 234 253 200 300 50.0% 66,684 68,415 70,200 72,200 2.8 % 3,726 2,378 3,000 3,000 0.0% 3,726 2,378 3,000 3,000 0.0 % 1,394,757 1,505,692 1,599,000 1,670,500 4.5% 32 82 - - 0.0 % - 136 500 500 0.0 % 3,414 2,410 3,300 3,000 (9.1 %) 147 169 - - 0.0 % 1,398,351 1,508,489 1,642,800 1,674,000 4.4 % ** Total Police Administration 1,468,760 1,579,282 1,676,000 1,749,200 4.4 % 2015 i Budget Fire Prevention and Administration (1220) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4010 Salaries & Wages -Reg 137,392 146,559 154,200 189,500 22.9% 4011 Overtime 1,887 2,623 1,000 1,500 50.0% 4020 Salaries & Wages -Temp 156,862 161,094 166,000 166,000 0.0% 4022 Training Wages 31,910 39,660 32,000 32,000 0.0 % 4030 Contributions - Retirement 147,039 194,250 150,000 163,000 8.7 % 4040 Contributions - Insurance 23,107 22,031 29,000 30,500 5.2 % 4050 Workers Compensation 23,926 26,484 8,700 22,000 152.9% 4060 Unemployment - 2,814 - - 0.0% * Total Personal Services 522,122 595,516 540,900 604,500 11.8% 4120 Supplies- Equipment 12,843 7,077 9,000 8,000 (11.1 %) 4130 Supplies- Program 4,173 5,584 3,300 4,000 21.2% 4140 Supplies - Vehicles 11,813 9,506 11,000 10,200 (7.3 %) 4150 Maintenance Materials 401 387 500 800 60.0% 4210 Books & Periodicals 577 492 600 600 0.0% 4240 Uniforms & Clothing 8,380 12,285 11,700 12,000 2.6 % 4260 Small Tools & Equipment 5,119 9,190 6,800 6,800 0.0 % 4290 Misc. Materials & Supplies 6,257 6,799 6,000 6,500 8.3 % * Total Materials & Supplies 49,562 51,318 48,900 48,900 0.0 % 4300 Fees, Services 28,445 26,285 15,500 32,000 106.5% 4310 Telephone 5,483 7,479 7,000 7,700 10.0% 4320 Utilities 21,857 22,569 23,700 24,000 1.3% 4350 Cleaning & Waste Removal 4,639 4,130 4,500 4,300 (4.4 %) 4360 Subscriptions & Memberships 2,684 2,488 2,500 2,500 0.0 % 4370 Travel & Training 30,560 26,899 23,000 10,000 (56.5 %) 4375 Promotional Expense 10,954 8,709 10,000 10,000 0.0% 4483 Insurance - General Liability 2,767 2,766 2,800 2,800 0.0 % 4510 Repair & Maintenance - Building 5,570 6,145 5,100 5,300 3.9 % 4520 Repair & Maintenance - Vehicles 17,247 4,268 7,000 7,500 7.1 % 4530 Repair & Maintenance -Equip 12,257 7,611 13,500 13,000 (3.7 %) 4531 Repair & Maintenance - Radios 3,131 3,990 4,500 4,000 (11.1 %) Contribution for Performance 50,481 7,657 46,000 20,000 (56.5 %) 4933 Sales Tax 1,429 718 - - 0.0 % * Total Contractual Services 197,504 131,712 165,100 143,100 (13.3 %) ** Total Fire Prevention and Adrnin 769,188 778,547 754,900 796,500 5.5 %n • Code Enforcement (12 50) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4010 Salaries & Wages -Reg 456,535 468,044 478,800 490,400 2.4% 4011 Overtime -Reg - 2,518 - - 0.0% 4020 Salaries & Wages -Temp - 28,664 - - 0.0% 4030 Contributions - Retirement 66,645 71,215 74,000 74,300 0.4% 4040 Contributions - Insurance 66,391 71,063 73,000 76,000 4.1% 4050 Workers Compensation 2,246 2,935 2,400 2,800 16.7% * Total Personal Services 591,818 644,438 628,200 643,500 2.4 % 4120 Supplies- Equipment 317 9 100 100 0.0% 4130 Supplies- Program 765 669 900 900 0.0% 4140 Supplies - Vehicles 974 2,395 1,600 1,600 0.0% 4210 Books & Periodicals 290 262 1,000 3,000 200.0% 4240 Uniforms & Clothing 356 606 500 500 0.0% 4260 Small Tools & Equipment 387 165 400 400 0.0% * Total Materials & Supplies 3,091 4,107 4,500 6,500 44.4% 4310 Telephone 2,917 5,008 3,500 4,500 28.6% 4340 Printing & Publishing 1,401 - 1,500 1,500 0.0% 4360 Subscriptions & Memberships 472 472 900 500 (44.4 %) 4370 Travel & Training 4,965 2,944 5,500 4,500 (18.2 %) 4440 License & Registration 658 70 500 500 0.0% 4520 Repair & Maintenance - Vehicles - - 300 300 0.0% 4530 Repair & Maintenance -Equip 2,456 1,978 1,400 600 (57.1 %) 4901 Refunds/ Reimbursements - - 500 - (100.0 %) 4933 Sales Tax 54 49 - - 0.0% * Total Contractual Services 12,922 10,521 14,100 12,400 (12.1 %) ** Total Code Enforcement 607,831 659,065 646,800 662,400 2.4% Community Service J260) ON 4020 Salaries & Wages -Temp 4021 Overtime -Temp 4030 Contributions - Retirement 4040 Contributions - Insurance 4050 Workers Compensation * Total Personal Services 4120 Supplies- Equipment 4130 Supplies- Program 4140 Supplies - Vehicles 4240 Uniforms & Clothing * Total Materials & Supplies 4300 Fees, Services 4310 Telephone 4340 Printing & Publishing 4360 Subscriptions & Memberships 4370 Travel & Training 4520 Repair & Maintenance - Vehicles 4530 Repair & Maintenance -Equip 4531 Repair & Maintenance - Radios 4933 Sales Tax * Total Contractual Services ** Total Community Service 2014 to 2012 2013 2014 2015 2015 Actual Actual Budget Budget % Inc /fDf 44,617 38,597 49,700 49,700 0.0% 65 510 1,000 600 (40.0 %) 6,703 5,870 7,100 6,800 (4.2 %) 590 565 800 600 (25.0 %) 692 676 1,000 700 (30.0 %) 52,667 46,218 59,600 58,400 (2.0 %) 1,123 79 700 200 (71.4 %) 426 651 1,500 800 (46.7 %) 1,872 251 600 600 0.0% 255 150 1,000 700 (30.0 %) 3,676 1,130 3,800 2,300 (39.5 %) 9,705 4,793 5,000 5,000 0.0% 988 1,305 1,000 1,400 40.0% 205 273 300 300 0.0% 69 196 200 200 0.0% - 100 500 200 (60.0 %) 146 - 300 200 (33.3 %) - - 100 100 0.0% 115 - 200 200 0.0% 27 64 - - 0.0% 11,257 6,731 7,600 7,600 0.0% 67,600 54,080 71,000 68,300 (3.8 %) 2015 General Fund Budget Engineering i 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget %® Inc /(Dec) 4010 Salaries & Wages -Reg 4011 Overtime -Reg 4020 Salaries & Wages -Temp 4021 Overtime -Temp 4030 Contributions - Retirement 4040 Contributions - Insurance 4050 Workers Compensation * Total Personal Services 4120 Supplies- Equipment 4140 Supplies - Vehicles 4210 Books & Periodicals 4290 Misc. Materials & Supplies * Total Materials & Supplies 4300 Fees, Services 4310 Telephone 4340 Printing & Publishing 4360 Subscriptions & Memberships 4370 Travel & Training 4380 Mileage 4520 Repair & Maintenance - Vehicles 4530 Repair & Maintenance -Equip 4933 Sales Tax * Total Contractual Services 412,947 423,881 440,000 448,500 1.9% 725 524 1,000 700 (30.0 %) - 13,686 15,000 15,000 0.0% - 17 - - 0.0% 61,416 63,724 65,500 68,000 3.8% 45,239 44,353 47,100 55,500 17.8% 2,009 2,790 2,100 2,600 23.8% 522,335 548,975 570,700 590,300 3.4 % 31 496 100 100 0.0% 970 67 700 700 0.0% 30 204 100 100 0.0% - 34 - - 0.0% 1,032 801 900 900 0.0% 19,979 21,657 18,500 20,000 8.1 % 2,588 3,724 3,000 3,000 0.0% 147 625 600 600 0.0 % 462 830 1,000 1,000 0.0 % 2,517 2,121 3,000 2,600 (13.3 %) - 84 500 200 (60.0 %) 174 - - - 0.0 % 4,076 4,341 3,900 3,000 (23.1 %) 59 62 - - 0.0 % 30,002 33,446 30,500 30,400 (0.3% ** Total Engineering 553,369 583,222 602,100 621,600 3.2 % 2015 General Fund Budget Street Maintenance (1320) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4010 Salaries & Wages -Reg 4011 Overtime -Reg 4020 Salaries & Wages -Temp 4021 Overtime -Temp 4030 Contributions - Retirement 4040 Contributions - Insurance 4050 Workers Compensation * Total Personal Services 4120 Supplies- Equipment 4140 Supplies - Vehicles 4150 Maintenance Materials 4210 Books & Periodicals 4240 Uniforms & Clothing 4260 Small Tools & Equipment * Total Materials & Supplies 4300 Fees, Services 4310 Telephone 4320 Utilities 4340 Printing & Publishing 4350 Cleaning & Waste Removal 4360 Subscriptions & Memberships 4370 Travel & Training 4410 Rental- Equipment 4440 License & Registration 4510 Repair & Maintenance - Building 4520 Repair & Maintenance - Vehicles 4530 Repair & Maintenance -Equip 4540 Repair & Maintenance - Streets 4560 Repair & Maintenance -Signs 4933 Sales Tax * Total Contractual Services 464,175 464,813 479,700 490,700 2.3 % 13,929 25,708 20,000 20,000 0.0% 9,733 9,745 10,000 13,500 35.0% 212 19 - - 0.0% 70,563 71,813 71,500 74,900 4.8% 79,662 87,758 94,000 104,000 10.6% 28,320 31,241 29,500 33,000 11.9% 666,594 691,097 704,700 736,100 4.5 % 45,964 42,821 42,500 42,500 0.0% 23,965 32,600 19,000 23,000 21.1% 43,881 65,341 47,000 48,000 2.1 % - - 100 100 0.0 % 3,689 3,132 4,000 3,800 (5.0 %) 2,145 768 2,000 2,000 0.0 % 119,643 144,662 114,600 119,400 4.2 %n 1,484 1,246 1,000 1,500 50.0% 3,676 4,841 3,800 4,800 26.3% - 5 - - 0.0% 470 369 300 300 0.0% 444 542 300 500 66.7% 50 50 1,200 500 (58.3%) 1,508 1,501 1,800 1,600 (11.1 %) 401 8 800 500 (37.5 %) 448 - 600 500 (16.7 %) 500 - 500 500 0.0 % 267 764 1,500 1,000 (33.3 %) 2,245 1,140 6,000 2,500 (58.3 %) 2,480 4,333 2,500 3,000 20.0% 10,743 10,065 10,300 10,300 0.0 % 2,546 2,811 - - 0.0% 27,262 27,675 30,600 27,500 (10.1 %) ** Total Street Maintenance 813,500 863,434 849,900 883,000 3.9% 2015 General Fund Budget Street Lightfztg and Si p s (1 3 50) 2014 to 2012 2013 2014 2015 2015 count Description Actual Actual Budget Budget % Inc /(Dec) 4120 Supplies- Equipment 2,791 4,070 3,000 3,000 0.0 % * Total Materials & Supplies 2,791 4,070 3,000 3,000 0.0 % 4300 Fees, Services - - 500 500 0.0% 4310 Telephone 453 365 500 500 0.0% 4320 Utilities 313,065 333,160 319,000 335,000 5.0 % 4560 Repair & Maintenance -Signs - 319 - - 0.0 % 4565 Repair & Maintenance - Light /Signal 39,921 13,305 28,500 28,500 0.0% 4933 Sales Tax 285 - - - 0.0 % * Total Contractual Services 353,725 347,149 348,500 364,500 4.6 % ** Total Street Lighting and Signals 356,515 351,219 351,500 367,500 4.6% 2015 General Fund Budget Fleet Department (1370) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4010 Salaries & Wages -Reg 193,379 205,212 200,000 205,000 2.5% 4011 Overtime -Reg 1,262 4,031 1,200 1,500 25.0% 4030 Contributions - Retirement 27,462 29,400 29,800 31,000 4.0% 4040 Contributions - Insurance 34,014 36,866 41,000 43,500 6.1% 4050 Workers Compensation 5,136 5,915 5,500 6,100 10.9% * Total Personal Services 261,253 281,425 277,500 287,100 3.5 % 4120 Supplies- Equipment 3,273 828 2,800 2,800 0.0 % 4130 Supplies- Program - 193 - - 0.0% 4140 Supplies - Vehicles 510 98 800 600 (25.0 %) 4150 Maintenance Materials 574 71 700 600 (14.3 %) 4170 Motor Fuels & Lubricants 191,298 186,309 202,000 195,000 (3.5 %) 4240 Uniforms & Clothing 740 995 1,000 1,000 0.0% 4260 Small Tools & Equipment 3,086 2,774 3,800 3,500 (7.9 %) * Total Materials & Supplies 199,481 191,268 211,100 203,500 (3.6 %) 4300 Fees, Services 3,005 1,371 2,000 2,000 0.0 % 4310 Telephone 3,430 3,292 4,000 4,000 0.0 % 4320 Utilities 34,296 42,419 37,500 44,000 17.3% 4330 Postage 42 14 - - 0.0% 4350 Cleaning & Waste Removal 7,379 4,793 9,200 7,500 (18.5 %) 4360 Subscriptions & Memberships - 32 200 200 0.0% 4370 Travel & Training - 364 800 800 0.0% 4440 License & Registration 288 - 300 300 0.0% 4510 Repair & Maintenance - Building 6,852 6,796 6,700 6,900 3.0% 4530 Repair & Maintenance -Equip 1,591 3,412 2,000 2,800 40.0% 4933 Sales Tax 497 515 - - 0.0% * Total Contractual Services 57,378 63,007 62,700 68,500 9.3 % 4703 Office Equipment 712 - 500 500 0.0% 4705 Other Equipment 5,801 3,378 5,000 5,000 0.0% * Total Capital Outlay 6,514 3,378 5,500 5,500 0.0 % ** Total Fleet Department 524,626 539,077 556,800 564,600 1.4 % 2015 General Fund Budget Planning g a s (14'C' Account Description 4210 Books & Periodicals * Total Materials & Supplies 4340 Printing & Publishing 4360 Subscriptions & Memberships 4370 Travel & Training * Total Contractual Services ** Total Planning Commission 2012 2013 Actual Actual 2,637 2,655 - 95 27 446 2,664. 3,196 2,664 3,196 2014 to 2014 2015 2015 Ru dget Budget % Inc /(Dec, 200 200 0.0% 200 200 0.0% 3,000 2,800 (6.7 %) 200 200 0.0% 600 600 0.0% 3,800 3,600 (5.3 %) 4,000 3,800 (5.0 %) 2015 General Fund Budget Planning Administration (1420) 2014 . to 2012 2013 2014 2015 2015 account Description Actual Actual Budget Budget % Inc/(Dec' 4010 Salaries & Wages -Reg 277,141 278,157 281,200 291,000 3.5% 4011 Overtime -Reg 3,326 89 - - 0.0% 4020 Salaries & Wages -Temp 9,436 10,441 13,000 11,000 (15.4 %) 4021 Overtime -Temp 116 33 - - 0.0% 4030 Contributions - Retirement 39,911 40,725 42,000 44,000 4.8% 4040 Contributions - Insurance 41,185 42,293 46,300 49,000 5.8% 4050 Workers Compensation 1,743 2,697 1,800 2,100 16.7% * Total Personal Services 372,856 374,434 384,300 397,100 3.3% 4120 Supplies- Equipment 590 79 300 300 0.0% 4140 Supplies - Vehicles 146 11 100 100 0.0% * Total Materials & Supplies 736 90 400 400 0.0% 4300 Fees, Services 9,492 148 5,000 5,000 0.0% 4360 Subscriptions & Memberships 782 765 1,500 1,000 (33.3 %) 4370 Travel & Training 5,078 3,028 5,500 5,500 0.0% * Total Contractual Services 15,352 3,941 12,000 11,500 (4.2 %) ** Total Planning Administration 388,944 378,465 396,700 409,000 3.1©/0 2015 General Fund Budget Senior Commission (1430) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc/(Dec) 4010 Salaries & Wages -Reg 18,576 18,941 19,000 19,000 0.0 % 4030 Contributions - Retirement 2,715 2,745 2,900 2,900 0.0% 4040 Contributions - Insurance 1,851 2,010 2,000 2,000 0.0 % 4050 Workers Compensation 111 124 100 100 0.0 % * Total Personal Services 23,253 23,820 24,000 24,000 0.0 % 4300 Fees, Services 8,631 8,552 9,000 9,000 0.0 % 4370 Travel & Training 105 - 200 200 0.0% 4375 Promotional Expense 447 89 500 500 0.0% 4933 Sales Tax 31 - - - 0.0% * Total Contractual Services 9,213 8,641 9,700 9,700 0.0 % ** Total Senior Commission 32,466 32,461 33,700 33,700 0.0% 2015 General Fund Budget Park and Recreation Commission (1510) ------------------ 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc/(Dec) 4130 Supplies- Program 4210 Books & Periodicals * Total Materials & Supplies 4340 Printing & Publishing 4360 Subscriptions & Memberships 4370 Travel & Training * Total Contractual Services 100 100 0.0% 100 100 0.0% - - 200 200 0.0% 1,998 2,580 1,700 2,000 17.6% - - Soo 300 (40.0%) 220 262 400 300 (25.0%) 2,218 2,842 2,600 2,600 0.0% ** Total Park and Rec Commission 2,218 2,842 2,800 2,800 0.0% 201,L) General Fund Budget Park and Recreation A m r .� :rat o (152L" Account Descri 4010 Salaries & Wages -Reg 4030 Contributions - Retirement 4040 Contributions- Insurance 4050 Workers Compensation * Total Personal Services 4120 Supplies- Equipment 4130 Supplies- Program 4210 Books & Periodicals 4240 Uniforms & Clothing * Total Materials & Supplies 4300 Fees, Services 4310 Telephone 4330 Postage 4340 Printing & Publishing 4360 Subscriptions & Memberships 4370 Travel & Training 4380 Mileage 4933 Sales Tax * Total Contractual Services ** Total Park and Rec Admin. 2014 to 2012 2013 2014 2015 2015 Actual Actual Budget Budget % Inc /(Dec 104,603 106,717 107,200 112,000 4.5% 14,963 15,141 16,000 17,000 6.3% 12,153 13,268 14,500 15,500 6.9% 626 478 700 700 0.0% 132,345 135,604 138,400 145,200 4.9% 14 79 300 100 (66.7 %) 35 20 100 100 0.0% - - 100 100 0.0% - - 100 100 0.0% 48 99 600 400 (33.3 %) 619 50 800 700 (12.5 %) 1,541 1,130 800 1,200 50.0% - 6 - - 0.0% - 144 - - 0.0% 2,754 821 1,900 1,900 0.0% 2,488 2,608 3,100 2,800 (9.7 %) 39 31 100 100 0.0% 4 - - - 0.0% 7,444 4,789 6,700 6,700 0.0% 139,838 140,493 145,700 152,300 4.5% • Recreation Center (1530) 2014 to 2012 2013 2014 2015 2015 lccount Description Actual Actual Budget Budget % Inc /(Dec' 4010 Salaries & Wages -Reg 4020 Salaries & Wages -Temp 4030 Contributions - Retirement 4040 Contributions - Insurance 4050 Workers Compensation 4060 Unemployment * Total Personal Services 4120 Supplies- Equipment 4130 Supplies- Program 4150 Maintenance Materials 4240 Uniforms & Clothing * Total Materials & Supplies 4300 Fees, Services 4310 Telephone 4320 Utilities 4340 Printing & Publishing 4360 Subscriptions & Memberships 4370 Travel & Training 4375 Promotional Expense 4510 Repair & Maintenance - Building 4530 Repair & Maintenance -Equip 4590 Misc. Contractual Services 4933 Sales Tax * Total Contractual Services ** Total Recreation Center 55,420 56,516 109,436 109,915 23,600 24,555 7,348 7,985 4,512 5,011 245 235 200,561 204,217 58,000 59,400 2.4% 119,000 111,000 (6.7 %) 27,200 27,200 0.0% 8,500 8,800 3.5% 1,700 5,000 194.1% - - 0.0% 214,400 211,400 (1.4 %) 1,870 900 3,000 2,000 (33.3 %) 29,328 22,509 40,000 32,000 (20.0 %) 232 129 500 500 0.0% 276 392 500 500 0.0% 31,706 23,931 44,000 35,000 (20.5 %) 40,707 45,094 40,000 45,000 12.5% 211 1,084 300 1,200 300.0% 35,708 41,325 37,000 42,000 13.5% - 157 - - 0.0% 263 182 300 300 0.0% 40 125 400 400 0.0% 617 542 1,000 800 (20.0 %) 689 2,864 800 1,500 87.5% 400 1,746 1,100 1,500 36.4% - - 1,500 - (100.0 %) 534 51 - - 0.0% 79,168 93,171 82,400 92,700 12.5% 311,436 321,319 340,800 339,100 (0.5 %) 2015 General Fund Budget 2014 to 2012 2013 1014 2015 2015 count Descrii),601' Actual Actual Rai €Iget Budget % Inc /(DE 4020 Salaries & Wages -Temp 6,133 7,367 8,000 8,000 0.0 % 4030 Contributions - Retirement 469 564 500 500 0.0 % 4050 Workers Compensation 170 186 200 200 0.0 % * Total Personal Services 6,773 8,117 8,700 8,700 0.0 % 4130 Supplies- Program 10,763 14,128 8,000 10,000 25.0% 4240 Uniforms & Clothing 200 200 200 200 0.0 % * Total Materials & Supplies 10,963 14,328 8,200 10,200 24.4% 4300 Fees, Services 41,656 29,757 32,000 30,000 (6.3 %) 4310 Telephone 1,360 1,177 1,400 1,400 0.0% 4320 Utilities 9,197 9,751 10,000 10,000 0.0 % 4340 Printing & Publishing - 267 400 400 0.0% 4933 Sales Tax 453 427 - - 0.0 % * Total Contractual Services 52,667 41,379 43,800 41,800 (4.6 %) ** Total Lake Ann Park Operations 70,402 63,823 60,700 60,700 0.0% • Park Maintenance (1550) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4010 Salaries & Wages -Reg 474,437 501,059 483,000 481,000 (0.4 %) 4011 Overtime -Reg 9,497 21,806 20,000 20,000 0.0 % 4020 Salaries & Wages -Temp 103,642 102,191 105,000 110,000 4.8 % 4021 Overtime -Temp 3,592 3,880 4,000 4,000 0.0% 4030 Contributions - Retirement 77,352 78,955 72,000 79,000 9.7% 4040 Contributions - Insurance 76,310 81,270 91,000 94,000 3.3 % 4050 Workers Compensation 15,808 17,648 13,800 17,000 23.2% 4060 Unemployment 116 1,041 - - 0.0% * Total Personal Services 760,754 807,849 788,800 805,000 2.1 % 4120 Supplies- Equipment 40,791 38,619 37,500 38,000 1.3% 4130 Supplies- Program 42 - - - 0.0% 4140 Supplies - Vehicles 3,883 3,027 4,600 4,000 (13.0 %) 4150 Maintenance Materials 27,356 27,795 28,000 28,000 0.0% 4151 Irrigation Materials 3,848 3,313 3,200 3,300 3.1 % 4240 Uniforms & Clothing 2,869 2,495 2,800 2,800 0.0 % 4260 Small Tools & Equipment 864 591 1,000 1,000 0.0 % * Total Materials & Supplies 79,652 75,840 77,100 77,100 0.0% 4300 Fees, Services 42,502 33,571 21,500 30,000 39.5% 4310 Telephone 5,066 5,859 5,000 5,600 12.0% 4320 Utilities 12,612 10,748 12,600 11,000 (12.7 %) 4340 Printing & Publishing - 100 400 200 (50.0 %) 4350 Cleaning & Waste Removal 5,581 5,708 5,600 5,700 1.8% 4360 Subscriptions & Memberships - - 400 400 0.0 % 4370 Travel & Training 393 608 1,000 600 (40.0 %) 4400 Rental -Land & Buildings 29,101 27,545 31,000 28,000 (9.7 %) 4410 Rental - Equipment 505 51 1,000 500 (50.0 %) 4440 License & Registration 384 - 300 300 0.0 % 4510 Repair & Maintenance - Building 1,686 2,030 2,500 2,000 (20.0 %) 4520 Repair & Maintenance - Vehicles - 187 500 500 0.0% 4530 Repair & Maintenance -Equip 10,954 1,439 6,600 5,000 (24.2 %) 4560 Repair & Maintenance -Signs 613 409 1,200 800 (33.3 %) 4933 Sales Tax 477 302 - - 0.0% * Total Contractual Services 109,875 88,559 89,600 90,600 1.1% 4705 Other Equipment 4,068 4,651 4,000 4,000 0.0 % * Total Capital Outlay 4,068 4,651 4,000 4,000 0.0 % ** Total Park Maintenance 954,349 976,898 959,500 976,700 1.8% 2015 General :Fund Budget Senior Citizens Center (1560) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4010 Salaries & Wages -Reg 4030 Contributions - Retirement 4040 Contributions - Insurance 4050 Workers Compensation * Total Personal Services 4120 Supplies- Equipment 4130 Supplies- Program * Total Materials & Supplies 4300 Fees, Services 4340 Printing & Publishing 4350 Cleaning & Waste Removal 4360 Subscriptions & Memberships 4370 Travel & Training 4375 Promotional Expense 4380 Mileage 4933 Sales Tax * Total Contractual Services 39,280 40,808 43,000 43,000 0.0 % 5,820 6,048 6,200 6,200 0.0 % 295 295 300 300 0.0 % 240 256 300 300 0.0 % 45,635 47,407 49,800 49,800 0.0 % - 93 300 300 0.0 % 3,111 2,247 3,000 3,000 0.0 % 3,111 2,339 3,300 3,300 0.0 % 23,004 20,282 19,000 19,000 0.0 % 19 - 100 100 0.0 % 128 85 200 200 0.0% 94 70 100 100 0.0 % 403 212 300 300 0.0 % 36 46 100 100 0.0 % 30 15 100 100 0.0% - 273 - - 0.0% 23,714 20,982 19,900 19,900 0.0 % ** Total Senior Citizens Center 72,460 70,728 73,000 73,000 0.0 % 2015 General Fund Budget Programs Recreation 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4010 Salaries & Wages -Reg 94,192 96,290 97,500 102,000 4.6% 4020 Salaries & Wages -Temp 43,172 51,527 54,500 53,000 (2.8 %) 4021 Overtime -Temp 404 927 500 500 0.0% 4030 Contributions - Retirement 17,334 18,285 18,500 18,700 1.1% 4040 Contributions - Insurance 8,665 9,187 9,500 15,400 62.1% 4050 Workers Compensation 1,959 2,139 700 2,000 185.7% * Total Personal Services 165,726 178,354 181,200 191,600 5.7% 4120 Supplies- Equipment 2,216 2,720 2,000 2,000 0.0% 4130 Supplies- Program 16,270 19,394 15,600 16,400 5.1% 4240 Uniforms & Clothing 1,488 1,732 1,900 1,900 0.0% * Total Materials & Supplies 19,974 23,846 19,500 20,300 4.1% 4300 Fees, Services 45,213 52,930 51,000 53,000 3.9% 4310 Telephone 1,627 2,895 2,100 2,800 33.3% 4320 Utilities 2,454 6,767 2,800 4,800 71.4% 4340 Printing & Publishing 5,989 5,376 5,300 5,300 0.0% 4370 Travel & Training 108 243 500 500 0.0% 4380 Mileage - - 100 100 0.0% 4400 Rental -Land & Buildings 6,165 5,219 7,000 6,000 (14.3 %) 4410 Rental- Equipment 23,541 24,178 26,700 24,500 (8.2 %) 4933 Sales Tax 117 118 - - 0.0% * Total Contractual Services 85,214 97,725 95,500 97,000 1.6% ** Total Recreation Programs 270,914 299,925 296,200 308,900 4.3% 2015 General Fund Budget Self-Supporting Programs (1700) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4010 Salaries & Wages -Reg 4020 Salaries & Wages -Temp 4030 Contributions - Retirement 4040 Contributions - Insurance 4050 Workers Compensation * Total Personal Services 4130 Supplies- Program * Total Materials & Supplies 4300 Fees, Services 4933 Sales Tax * Total Contractual Services ** Total Self - Supporting Programs 23,548 24,072 2,671 2,600 3,704 3,767 2,167 2,297 215 203 32,304 32,939 7,293 7,293 20,191 23 20,214 59,811 24,400 25,500 4.5% 3,000 2,800 (6.7 %) 4,000 4,000 0.0% 2,300 3,800 65.2% 200 200 0.0% 33,900 36,300 7.1 % 2,907 7,200 5,200 (27.8 %) 2,907 7,200 5,200 (27.8 %) 21,212 24,000 22,000 (8.3 %) 7 - - 0.0% 21,218 24,000 22,000 (8.3 %) 57,064 65,100 63,500 (2.5 %) 2Q15 General Budget Fund Recreation Sports (1800) 2014 to 2012 2013 2014 2015 2015 Account Description Actual Actual Budget Budget % Inc /(Dec) 4020 Salaries & Wages -Temp 4021 Overtime -Temp 4030 Contributions - Retirement 4050 Workers Compensation * Total Personal Services 4120 Supplies- Equipment 4130 Supplies- Program 4240 Uniforms & Clothing * Total Materials & Supplies 4375 Promotional Expenses 4933 Sales Tax * Total Contractual Services 10,970 14,973 15,000 18,000 20.0% 57 - - - 0.0% 1,073 1,550 1,000 1,700 70.0% 269 406 200 400 100.0% 12,369 16,929 16,200 20,100 24.1% 566 48 500 500 0.0% 4,225 3,426 3,500 3,500 0.0% 3,801 4,801 4,800 4,800 0.0% 8,592 8,275 8,800 8,800 0.0% 242 150 300 300 0.0% 12 174 - - 0.0% 254 324 300 300 0.0% ** Total Recreation Sports 21,214 25,528 25,300 29,200 15.4% City of Chanhassen 2014 Assessment Summary Chanhassen Value Distribution 2014 ❑ Apartment ❑ Other 1% /�% ❑ Residential ■ Commercial/ ■ Commercial /In Industrial dustrial 12% ❑ Apartment E:1 Other C1 Residential 87% Residentia iercial/IndusstrialI Apartment Other Total 2014 EMV $3,198,693,300 $405,842,400 $47,012,700 $48,848,700 $3,700,397,100 2013 EMV $2,827,675,700 $402,534,800 $46,191,800 $41,344,100 $3,317,746,400 Total Value Change $371,017,600 $3,307,600 $820,900 $7,504,600 $382,650,700 New Construction $64,039,700 $815,200 $333,400 $0 $65,188,300 Market Change $306,977,900 $2,492,400 $487,500 $7,504,600 $317,462,400 % New Construction 2.00% 0.20% 0.71% 0.00% 1.76% % Market Change 10.86% 0.62% 1.06% 18.15% 9.57% 2014 Total % Increase 13.12% 0.82% 1.78% 18.15% 11.53% Chanhassen Value Distribution 2014 ❑ Apartment ❑ Other 1% /�% ❑ Residential ■ Commercial/ ■ Commercial /In Industrial dustrial 12% ❑ Apartment E:1 Other C1 Residential 87% City of Chanhassen, Minnesota Bond Tax Levies 2006 -2029 **-These funds to be used to pay down the debt levy each of the next four years ## - The PW facility is for 8 Million and bonding for $7 Million of the 8 Million. @@ - The 2009A Refunded the 2005A Mndot loand and 2006A MUSA area improvements. Debt Levies 2005 C Ref 1998A Park 2002A 2010A Subtotal of 2001C 2003A 2004A Subtotal of 1999 2001B ^^ Subtotal of 2000 Subtotal of Total Year of GO Park GO Library GO Refund Market GO Equip GO Equip GO GO GO Impr GO Impr Spec Assmt GO Pub Other General Collection Bonds Bonds 2002A Lib Value Levies Certs Certs Bonds Levies Bonds Bonds Levies Proj Levies Bonded Debt 2006 634,800 486,700 1,121,500 138,814 345,800 484,614 100,000 100,000 122,048 122,048 1,828,162 2007 696,500 489,100 1,185,600 141,380 346,900 488,280 100,000 100,000 122,548 122,548 1,896,428 2008 695,900 490,700 1,186,600 138,173 346,700 484,873 100,000 100,000 122,703 122,703 1,894,176 2009 972,700 491,300 1,464,000 297,900 297,900 - 122,603 122,603 1,884,503 2010 496,400 496,400 122,195 122,195 618,595 2011 495,400 495,400 126,420 126,420 621,820 2012 351,648 351,648 351,648 2013 445,310 445,310 445,310 2014 448,880 448,880 448,880 2015 446,098 446,098 446,098 2016 452,792 452,792 452,792 2017 451,952 451,952 451,952 2018 461,297 461,297 461,297 2019 459,512 459,512 459,512 2020 457,412 457,412 457,412 2021 465,497 465,497 465,497 Totals 2,999,900 2 949 600 4,440,398 10 389 898 - 418,367 1,337,300 1 755 667 300,000 300,000 738,515 738,515 13 184 080 2009A @@ 2005 2008 ## 2010 2010 Total Levy Excess to "• Potential Actual 212 Bonds PW Facility Fire Station Audubon Year w/ CIP Est Pay debt Excess Levy Levy 2006 80,000 2006 1,908,162 285,000 - 1,938,790 2007 80,000 2007 1,976,428 67,238 - 1,909,190 2008 285,000 2008 2,179,176 269,986 - 1,909,190 2009 285,000 2009 2,169,503 460,313 - 1,809,190 2010 337,500 599,300 253,795 2010 1,809,190 - - 1,809,190 2011 336,800 594,000 256,570 2011 1,809,190 - 1,809,190 2012 335,900 593,800 437,842 2012 1,719,190 - 1,719,190 2013 550,000 593,200 130,680 2013 1,719,190 - 1,719,190 2014 233,800 592,100 444,410 2014 1,719,190 - 1,719,190 2015 232,300 590,600 55,000 2015 1,323,998 395,192 1,719,190 2016 240,700 594,000 2016 1,287,492 431,698 1,719,190 2017 596,700 2017 1,048,652 670,538 1,719,190 2018 593,600 2018 1,054,897 664,293 1,719,190 2019 600,300 2019 1,059,812 659,378 1,719,190 2020 600,800 2020 1,058,212 660,978 1,719,190 2021 600,400 2021 1,065,897 653,293 1,719,190 2022 604,500 2022 604,500 649,193 1,253,693 2023 607,400 2023 607,400 646,293 1,253,693 2024 609,200 2024 609,200 644,493 1,253,693 2025 609,900 2025 609,900 643,793 1,253,693 2026 614,600 2026 614,600 639,093 1,253,693 2027 612,700 2027 612,700 640,993 1,253,693 2028 620,100 2028 620,100 633,593 1,253,693 2029 620,600 2029 620,600 633,093 1,253,693 Totals - - - - - - 2.267.000 730.000 12.047.800 - 1.578.297 48.420 29.807.177 1.082.536 **-These funds to be used to pay down the debt levy each of the next four years ## - The PW facility is for 8 Million and bonding for $7 Million of the 8 Million. @@ - The 2009A Refunded the 2005A Mndot loand and 2006A MUSA area improvements. 2005 Project Cost (Street Only) 2015 Assessments 40% 2017 City Share 2019 Other project Costs 2021 Tsfs in 2023 Fund Bal - BOY Estimate for 2014* * ** Levy - From Debt Levy Schedule Reduction for Other purposes Repayment 1,850,000 Project Costs 1,500,000 Investable Balance 1,500,000 MVHC 1,500,000 Street Levy & Tsf 1,500,000 Interest 1,600,000 Fund Bal - EOY (560,000) Repayment Schedule (600,000) 8 yr assmt @ 5.25% (600,000) Project Year 2005 (600,000) 2006 (600,000) 2007 (640,000) 2008 840,000 2009 900,000 2010 900,000 2011 900,000 2012 900,000 2013 900,000 2014 960,000 2015 Tenn Courts & 2016 122,387 2017 2018 2019 2020 2021 317,466 2022 77,297 2023 77,297 2024 2025 2026 2027 2028 2,199,552 2029 1,410,599 2030 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 1,400,000 1,850,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,500,000 1,600,000 1,600,000 (560,000) (740,000) (600,000) (600,000) (600,000) (600,000) (600,000) (600,000) (600,000) (600,000) (600,000) (640,000) (640,000) 840,000 1,110,000 900,000 900,000 900,000 900,000 900,000 900,000 900,000 900,000 900,000 960,000 960,000 (175,000) Tenn Courts & 122,387 122,387 122,387 317,466 61 study 77,297 77,297 77,297 77,297 2,167,054 2,199,552 1,688,874 1,410,599 1,360,901 1,339,518 1,283,508 1,244,817 1,181,468 1,118,411 1,057,511 971,239 780,528 444,410 450,192 431,698 670,538 664,293 659,378 660,978 653,293 649,193 646,293 644,493 643,793 639,093 802,493 856,015 762,369 753,080 788,059 759,446 775,923 760,193 765,820 772,072 750,192 750,192 756,443 (1,400,000) (1,850,000) (1,500,000) (1,500,000) (1,500,000) (1,500,000) (1,500,000) (1,500,000) (1,500,000) (1,500,000) (1,500,000) (1,600,000) (1,600,000) 2,156,423 1,655,758 1,382,941 1,334,217 1,313,253 1,258,341 1,220,409 1,158,302 1,096,481 1,036,775 952,195 765,223 576,064 43,128 33,115 27,659 26,684 26,265 25,167 24,408 23,166 21,930 20,736 19,044 15,304 11,521 2,199,552 1,688,874 1,410,599 1,360,901 1,339,518 1,283,508 1,244,817 1,181,468 1,118,411 1,057,511 971,239 780,528 587,585 34,000 209,300 209,300 103,063 103,063 103,063 58,795 58,795 58,795 58,795 122,387 122,387 122,387 122,387 122,387 77,297 77,297 77,297 77,297 77,297 77,297 109,504 109,504 109,504 109,504 109,504 109,504 109,504 $88,147 88,147 88,147 88,147 88,147 88,147 88,147 88,147 $87,522 87,522 87,522 87,522 87,522 87,522 87,522 87,522 $115,654 115,654 115,654 115,654 115,654 115,654 115,654 115,654 $93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 $93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 $93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 $93,774 93,774 93,774 93,774 93,774 93,774 93,774 $93,774 93,774 93,774 93,774 93,774 93,774 $93,774 93,774 93,774 93,774 93,774 $93,774 93,774 93,774 93,774 $93,774 93,774 93,774 $93,774 93,774 $100,025 2027 2028 1,700,000 1,700,000 (680,000) (680,000) 1,020,000 1,020,000 587,585 297,098 640,993 633,593 762,694 775,197 (1,700,000) (1,700,000) 291,272 5,887 5,825 118 297,098 6,005 2029 1,800,000 (720,000) 1,080,000 6,005 633,093 781,448 (1,800,000) (379,454) (7,589) (387,043) 2030 1,800,000 (720,000) 1,080,000 (387,043) 633,093 793,950 (1,800,000) (760,000) (15,200) (775,200) 93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 93,774 100,025 100,025 100,025 100,025 $100,025 100,025 100,025 100,025 $106,277 100,025 10 0, 025 $106,277 100,025 $112,528 General Ledger Expense Budget vs Actual Description Budget Actual Dollars Unspent % Unspent City Council 109,300.00 41,917.72 67,382.28 61.65 Administration 508,749.00 257,544.21 251,204.79 49.38 Finance 295,800.00 150,037.14 145,762.86 49.28 Legal 148,000.00 81,932.95 66,067.05 44.64 Property Assessment 130,000.00 8,261.01 121,738.99 93.65 Management Information Systems 264,600.00 122,509.25 142,090.75 53.70 City Hall Maintenance 407,600.00 388,999.71 18,600.29 4.56 Elections 38,200.00 - 38,200.00 100.00 Library Building 114,200.00 51,815.29 62,384.71 54.63 General Government $ 2,016,449.00 $ 1,103,017.28 $ 913,431.72 45.30% Police /Carver Co Contract 1,676,000.00 820,389.43 855,610.57 51.05 Fire Prevention & Admin 754,900.00 260,059.94 494,840.06 65.55 Code Enforcement 646,800.00 320,194.29 326,605.71 50.50 Animal Control 71,000.00 29,457.97 41,542.03 58.51 Law Enforcement $ 3,148,700.00 $ 1,430,101.63 $ 1,718,598.37 54.58% Engineering 602,100.00 285,466.39 316,633.61 52.59 Street Maintenance 849,900.00 380,530.66 469,369.34 55.23 Street Lighting & Signals 351,500.00 169,534.21 181,965.79 51.77 City Garage 556,800.00 291,241.31 265,558.69 47.69 Public Works $ 2,360,300.00 $ 1,126,772.57 $ 1,233,527.43 52.26% Planning Commission 4,000.00 3,394.24 605.76 15.14 Planning Administration 396,700.00 188,261.07 208,438.93 52.54 Senior Facility Commission 33,700.00 13,755.25 19,944.75 59.18 Community Development $ 434,400.00 $ 205,410.56 $ 228,989.44 52.71% Park Commission 2,800.00 1,537.47 1,262.53 45.09 Park Administration 145,700.00 69,550.96 76,149.04 52.26 Recreation Center 340,800.00 158,991.80 181,808.20 53.35 Lake Ann Park 60,700.00 13,172.34 47,527.66 78.30 Park Maintenance 959,500.00 443,278.93 516,221.07 53.80 Senior Citizens Center 73,000.00 34,184.02 38,815.98 53.17 Recreation Programs 296,200.00 124,441.65 171,758.35 57.99 Self- Supporting Programs 65,100.00 19,407.36 45,692.64 70.19 Recreation Sports 25,300.00 16,588.29 8,711.71 34.43 Park & Recreation $ 1,969,100.00 $ 881,152.82 $ 1,087,947.18 55.25% Grand Total $ 9,928,949.00 $ 4,746,454.86 $ 5,182,494.14 52.20% General Ledger Revenue Budget vs Actual Period 01 ® 06 Fiscal Year 2014 Account Description Budget Actual $ Uncollected % Uncollected General Property Tax 3010 Current Property Tax 7,629,950.00 3,799,166.01 3,830,783.99 50.21 3002 Allowance for Delinquent Taxes (150,000.00) - (150,000.00) 100.00 3011 Delinquent Property Tax 150,000.00 33,194.09 116,805.91 77.87 3041 Homestead & Ag Credit - - - - 3090 Other Property Taxes - 132,231.03 (132,231.03) - 3500 Local Government Aid - - - - Total General Property Tax $ 7,629,950.00 $ 3,964,591.13 $ 3,665,358.87 48.04% Licenses 3203 Dog Kennel 500.00 125.00 375.00 75.00 3205 Dog or Cat - - - - 3206 Massage License - 1,300.00 (1,300.00) - 3213 Solicitor 1,000.00 - 1,000.00 100.00 3226 Liquor On /Off Sale 94,000.00 97,099.00 (3,099.00) (3.30) 3230 Rental Housing Licenses - - - - 3284 Rubbish 4,000.00 - 4,000.00 100.00 Total Licenses $ 99,500.00 $ 98,524.00 $ 976.00 0.98% Permits 3301 Building 480,000.00 262,079.31 217,920.69 45.40 3302 Plan Check 220,000.00 138,450.19 81,549.81 37.07 3305 Heating & A/C 82,800.00 50,427.10 32,372.90 39.10 3306 Plumbing 65,000.00 54,202.93 10,797.07 16.61 3307 Trenching 30,000.00 15,807.00 14,193.00 47.31 3308 Hunting /Shooting 1,400.00 220.00 1,180.00 84.29 3309 Sprinkler 11,000.00 6,052.53 4,947.47 44.98 3311 Sign 6,500.00 2,140.00 4,360.00 67.08 3316 Septic Tank - - - - 3320 Stable 300.00 200.00 100.00 33.33 3331 Firework's Application Fee - 200.00 (200.00) - 3390 Misc Permits 3,000.00 1,330.00 1,670.00 55.67 Total Permits $ 900,000.00 $ 531,109.06 $ 368,890.94 40.99% Fines & Penalties 3140 S/A Penalties & Interest - - - - 3401 Traffic & Ordinance Violation 120,000.00 29,559.33 90,440.67 75.37 3402 Vehicle Lockouts 2,500.00 550.00 1,950.00 78.00 3404 Dog /Cat Impound - - - - 3405 Other Fines & Penalties - - - - Total Fines & Penalties $ 122,500.00 $ 30,109.33 $ 92,390.67 75.42% Intergovernmental Revenue 3503 School District Reimbursement 45,000.00 - 45,000.00 100.00 3509 Other Shared Taxes 130,000.00 - 130,000.00 100.00 3510 Grants -State 110,000.00 - 110,000.00 100.00 3520 Grants - County - - - - 3533 Other Grants - - - _ Total Intergovernmental Revenue $ 285,000.00 $ - $ 285,000.00 100.00% Page 1 of 2 Summary CITY OF CHANHASSEN Total Par Value: $29,255,733 Avg. Market Yield: 0.89 Total Market Value (w /o accrd): $29,366,680 Avg. Book Yield: 1.19 Unrealized G/L ($000): $68 Avg. Coupon: 1.41 First Year Book Income: $286,000 Avg. Price: 100.379 3 Month Cash Flow Projection: $7,869,421 Avg. Effective Duration: 1.76 Number of Bonds: 67 Avg. Convexity: -0.13 %Portfolio Floating Rate: 0 Avg. Life (Years): 1.74 % Portfolio Callable Coupon Distribution MUNI, Callable, 14 14 40 35 30 Not Callable, 86 25 20 15 10 5 0 0.00- 1.00- 2.00- 3.00- 5.00- 0.99 1.99 2.99 3.99 5.99 The information contained herein, while believed to be reliable, is not guaranteed. 2 of 12 Data from BondEdge. General Ledger Revenue Budget vs Actual Period 01 a 06 Fiscal Year 2014 Account Description Budget Actual $ Uncollected % Uncollected Charges for Current Services Equipment Rental & Sale 166,000.00 87,869.09 78,130.91 3601 Sale of Documents 500.00 335.00 165.00 33.00 3602 Use & Variance Permits 7,000.00 11,762.00 (4,762.00) (68.03) 3603 Rezoning Fees 500.00 1,275.00 (775.00) (155.00) 3604 Assessment Searches 200.00 285.00 (85.00) (42.50) 3605 Plat Recording Fees 2,000.00 2,100.00 (100.00) (5.00) 3607 Election Filing Fees - - - - 3613 Misc - General Government 3,200.00 1,472.74 1,727.26 53.98 3614 Admin Charge -2% Const 25,000.00 4,640.20 20,359.80 81.44 3615 Admin Charge -5% Street Re -Const 20,000.00 - 20,000.00 100.00 3617 Engineering General - - - - 3619 Investment Management Fee 75,000.00 - 75,000.00 100.00 3629 Misc - Public Safety 10,000.00 4,652.09 5,347.91 53.48 3630 Recreation Program Fees 40,000.00 28,763.92 11,236.08 28.09 3631 Recreation Center 218,000.00 93,971.41 124,028.59 56.89 3633 Park Equipment Rental 300.00 37.42 262.58 87.53 3634 Park Facility Usage Fee 14,000.00 15,608.45 (1,608.45) (11.49) 3635 Watercraft Rental 7,000.00 2,808.17 4,191.83 59.88 3636 Self- Supporting Programs 60,000.00 45,670.37 14,329.63 23.88 3637 Senior Programs 34,000.00 16,634.08 17,365.92 51.08 3638 Food Concessions 12,000.00 2,720.26 9,279.74 77.33 3639 Misc -Park & Rec 1,200.00 1,032.40 167.60 13.97 3641 Youth Sport Donation - - - - 3642 Recreation Sports 35,000.00 24,500.05 10,499.95 30.00 3649 Misc - Public Works 3,500.00 - 3,500.00 100.00 3651 Merchandise Sales 1,500.00 610.16 889.84 59.32 3670 Internment Fee - 50.00 (50.00) - Total Current Services $ 569,900.00 $ 258,928.72 $ 310,971.28 54.57% Other Revenue 3801 Interest Earnings 45,000.00 - 45,000.00 100.00 3802 Equipment Rental & Sale 166,000.00 87,869.09 78,130.91 47.07 3803 Building Rental 7,000.00 2,720.00 4,280.00 61.14 3804 Land Sale - 400.00 (400.00) - 3807 Donations 21,799.00 20,090.00 1,709.00 7.84 3808 Ins Recoveries & Reimbursements - - - - 3816 SAC Retainer 6,000.00 1,565.55 4,434.45 73.91 3818 Sur -Tax Retainer 1,000.00 364.34 635.66 63.57 3820 Misc Other Revenue 300.00 133.00 167.00 55.67 3829 Interest/Penalties -Other - - - - 3901 Contributed Assets - - - - 3903 Refunds /Reimbursements 75,000.00 35,680.96 39,319.04 52.43 3910 Misc Revenue - - - - 3980 Cash Over /Short - (0.04) 0.04 - Total Other Revenue $ 322,099.00 $ 148,822.90 $ 173,276.10 53.80% Grand Total $ 9,928,949.00 $ 5,032,085.14 $ 4,896,863.86 49.32% Page 2 of 2 Portfolio Analytics Analysis for: CITY OF CHANHASSEN Presented by: Jennifer Curtis June 30, 2014 Investments: NOT FDIC Insured • May Lose Value • No Bank Guarantee 1 of12 Together well go far `'4 M S ri F-, Distribution Graphs CITY OF CHANHASSEN 12 10 8 6 4 2 0 FHLB FNMA FHLMC Priced to Call. 10% 25 .W-20 20 15 - 10 8 t 5 0 _-- MN OR 2 2 9 CT WI NY PA MA 45 !� 40 1 r 35 K 30 r? 2s i 16 _. Is 10 1K 5 i i �'`{ V J . • � ,,ter <0.00 0.00 -0.99 1.00 - 2.99 3.00-3.99 4.00-5.99 6.00-7.99 — 8.00+ The information contained herein, while believed to be reliable, is not guaranteed. 3 of 12 Data from BondEdge. Portfolio History CITY OF CHANHASSEN *All averages market weighted 6/30/14 $29,255,733 $68 1.76 -0.13 1.74 0.89 0.08 1.19 1.41 100.379 Aai 67 3/31/14 $26,170,331 $37 1.87 -0.15 2.02 0.94 0.07 1.22 1.56 100.761 Aai 61 12/31/13 $33,874,552 ($34) 1.48 -0.09 1.53 0.81 0.11 0.95 1.21 100.437 Aai 64 9/30/13 $29,930,000 $43 1.60 -0.12 1.56 0.79 0.15 1.13 1.51 100.997 Aa1 62 6/28/2013 $31,781,000 $79 1.65 -0.12 1.74 0.78 0.15 1.09 1.49 101.147 Aa1 61 3/28/13 $27,258,000 $268 1.82 -0.09 1.75 0.62 0.15 1.25 1.69 102.067 Aai 55 12/31/12 $29,447,000 $287 1.68 -0.09 1.60 0.57 0.15 1.13 1.52 101.991 Aa1 56 9/28/12 $26,429,000 $513 2.13 -0.09 2.08 0.76 0.23 1.55 2.14 103.256 Aa1 60 6/29/12 $29,339,000 $473 1.84 -0.12 1.75 0.77 0.22 1.39 1.86 102.572 Aai 55 3/30/12 $25,125,000 $442 2.08 -0.09 2.28 1.03 0.33 1.80 2.34 102.831 Aai 45 12/30/11 $25,910,000 $347 1.88 -0.03 1.87 1.03 0.12 1.69 2.34 102.692 Aa1 46 9/30/11 $22,070,000 $369 2.08 -0.02 2.20 1.09 0.25 1.96 2.45 102.886 Aa1 36 6/30/11 $24,427,000 $244 1.91 -0.08 1.93 1.19 0.18 1.84 2.13 101.676 Aaa 39 3/31/11 $21,503,000 $60 1.82 -0.13 1.84 1.18 0.26 1.67 2.18 100.836 Aaa 36 12/31/10 $25,326,000 $160 1.77 -0.14 1.68 1.24 0.29 1.44 1.92 100.832 Aaa 43 9/30/10 $20,742,000 $228 1.34 -0.05 1.30 0.71 0.26 1.77 2.21 101.576 AGY 33 6/30/10 $24,387,000 $234 0.79 -0.01 0.77 0.69 0.32 2.52 3.09 101.710 AGY 42 4/30/10 $21,083,000 $233 0.62 0.00 0.64 0.34 0.45 2.54 3.23 101.681 AGY 41 3/31/10 $24,083,000 $282 0.98 -0.19 1.16 0.86 0.40 2.59 3.23 101.791 AGY 44 1/29/10 $33,510,000 $320 0.85 -0.07 1.07 1.03 0.34 2.79 3.26 101.507 AGY 79 9/30/09 $28,573,000 $557 0.72 0.01 0.74 0.76 0.40 3.32 3.85 102.528 N/A 78 6/30/09 $35,177,000 $638 0.80 -0.01 0.81 1.07 0.51 3.05 3.48 102.381 N/A 88 3/31/09 $36,027,000 $621 1.00 0.00 1.03 1.78 0.64 3.27 3.68 102.377 N/A 97 12/31/08 $42,745,000 $762 1.07 -0.03 1.08 1.70 0.49 3.12 3.54 102.441 AGY 107 History of Par Value $45,000,000 $40,000,000 $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 7 $0 00 Ql Q1 Q1 O O r-i O -4 O O r-i r-i O r-i ri -4 r-I N r-i r-I N r-I N r-i N M r-i .--I M M r-i r-I M r-I ,-i It ri M M M M N M M M M M M M M M M N N 00 M N N \ M M M M \ \ N M \ \ l0 01 \ r1 \ M \ It \ \ Ol \ \ N M \ \ l0 Cn \ \ N M \ l0 \ Ol \ \ N M 00 \ N Ol \ \ N M \ l0 kD The information contained herein, while believed to be reliable, is not guaranteed. 4 of 12 Data from BondEdge. Position by Sector CITY OF CHANHASSEN $500 3136FPGM3 FEDERAL NATL MTG ASSN Aaa AA+ 2.00 9/24/2015 N/A 104.739 7/11/2012 9/24/2015 102.075 $513 1.74 0.31 0.51 1.22 0.01 $1.21 $500 313370TW8 FEDERAL HOME LOAN BANKS Aaa AA+ 2.00 9/9/2016 N/A 105.392 7/12/2012 9/9/2016 103.048 $518 1.76 0.60 0.68 2.14 0.03 $0.94 $240 3134G3ZK9 FEDERAL HOME LN MTG CORP Aaa AA+ 1.20 7/30/2018 7/30/2014 100.000 7/30/2012 7/30/2018 99.143 $239 0.81 1.42 1.20 2.46 -1.43 ($2.06) $500 3130A07J3 FEDERAL HOME LOAN BANKS Aaa AA+ 1.85 11/5/2018 11/5/2015 100.848 12/4/2013 11/5/2015 100.464 $504 1.71 1.50 1.40 3.27 -0.68 ($0.67) $750 3133832J9 FEDERAL HOME LOAN BANKS Aaa AA+ 0.75 11/21/2018 11/21/2014 100.000 5/21/2013 5/21/2017 98.547 $740 2.51 1.65 0.69 2.97 -0.98 ($10.90) $750 3134G4QX9 FEDERAL HOME LN MTG CORP Aaa AA+ 1.50 12/27/2018 9/27/2014 100.000 12/31/2013 9/27/2014 100.232 $752 2.55 0.54 1.50 1.81 -1.48 $1.74 $1,155 31358BAA6 FEDERAL NATL MTG ASSN PRIN S Aaa AA+ 0.00 2/1/2019 N/A 91.430 6/19/2014 2/1/2019 90.833 $1,049 3.56 2.11 1.95 4.61 0.12 ($7.52) $600 3135GOUR2 FEDERAL NATL MTG ASSN Aaa AA+ 1.50 2/26/2019 8/26/2014 99.025 3/10/2014 2/26/2019 99.229 $598 2.03 1.67 1.71 2.68 -1.55 $0.88 $500 3136FTR68 FEDERAL NATL MTG ASSN Aaa AA+ 1.65 2/28/2019 N/A 99.675 3/5/2012 2/28/2019 99.830 $502 1.70 1.69 1.70 4.51 0.11 $0.26 $500 3136G22K2 FEDERAL NATL MTG ASSN Aaa AA+ 2.00 11/20/2019 5/20/2016 100.000 5/20/2014 11/20/2019 98.880 $496 1.68 2.22 2.00 4.70 -0.21 ($5.60) $695 313381TY1 FEDERAL HOME LOAN BANKS Aaa AA+ 1.00 1/29/2020 7/29/2014 97.555 12/4/2013 7/29/2016 97.773 $682 2.31 2.10 1.95 3.71 -1.31 ($2.08) AGY $6,690 1.24 4.25 98.270 $6,593 22.34 1.48 1.44 3.20 -0.64 ($23.80) $500 591852UT3 METROPOLITAN COUNCIL MINN M Aaa AAA 0.40 9/1/2014 N/A 100.000 7/24/2012 9/1/2014 100.011 $501 1.70 0.34 0.40 0.17 0.00 $0.06 $480 081617PT3 BEND ORE FULL FAITH CREDIT Aa3 N/A 2.10 11/1/2014 N/A 100.000 11/30/2010 11/1/2014 100.589 $484 1.64 0.34 2.10 0.34 0.00 $2.83 $345 604195VS3 MINNETONKA MINN INDPT SCH D Aaa N/A 0.50 1/1/2015 N/A 100.000 7/2/2013 1/1/2015 100.128 $347 1.18 0.25 0.50 0.50 0.00 $0.44 $275 305229DM5 FAIRMONT MINN INDPT SCH DIS Aa2 N/A 2.65 2/1/2015 N/A 100.000 8/12/2010 2/1/2015 101.169 $281 0.95 0.65 2.65 0.58 0.00 $3.21 $1,300 51043PAB2 LAKE PARK- AUDUBON MINN INDP N/A AA+ 2.75 2/1/2015 N/A 100.000 7/22/2010 2/1/2015 101.279 $1,331 4.51 0.56 2.75 0.58 0.00 $16.63 $500 603790CZ7 MINNEAPOLIS MINN SPL SCH DI Aal AA+ 2.00 2/1/2015 N/A 103.158 12/18/2012 2/1/2015 100.847 $508 1.72 0.55 0.50 0.59 0.00 ($0.15) $225 620535V68 MOUND MINN TAXABLE GO BDS 2 N/A AA 2.00 2/1/2015 N/A 102.605 5/2/2013 2/1/2015 100.975 $229 0.78 0.33 0.50 0.59 0.00 $0.22 $500 68607VNSO OREGON ST DEPT ADMINISTRATI Aa2 AAA 5.13 4/1/2015 N/A 112.260 7/29/2011 4/1/2015 103.554 $524 1.78 0.39 1.67 0.74 0.01 $4.91 $210 976860YZ3 WISCONSIN RAPIDS WIS GO REF Aa3 N/A 1.25 6/1/2015 N/A 101.600 5/10/2012 6/1/2015 100.653 $212 0.72 0.54 0.72 0.91 0.01 $0.35 $500 64966JG26 NEW YORK N Y TAXABLE GO BDS Aa2 AA 1.00 8/1/2015 N/A 100.764 6/25/2012 8/1/2015 100.620 $505 1.71 0.43 0.75 1.08 0.01 $1.75 $615 081617PUO BEND ORE FULL FAITH CREDIT Aa3 N/A 2.60 11/1/2015 N/A 100.000 11/30/2010 11/1/2015 102.789 $635 2.15 0.50 2.60 1.32 0.01 $17.15 $200 751622HA2 RAMSEY CNTY MINN CAP IMPT B Aaa AAA 2.00 2/1/2016 N/A 103.346 6/24/2013 2/1/2016 102.243 $206 0.70 0.58 0.70 1.56 0.02 $0.39 $510 951427X40 WEST BEND WIS TAXABLE G 0 R Aa3 N/A 2.88 3/1/2016 N/A 103.450 10/19/2010 3/1/2016 103.303 $532 1.80 0.88 2.19 1.62 0.02 $11.16 $500 941247V62 WATERBURY CONN GO BDS 20126 Al AA- 1.76 4/1/2016 N/A 101.160 6/26/2012 4/1/2016 100.674 $506 1.71 1.37 1.44 1.72 0.02 $0.64 $500 862811U46 STRATFORD CONN PENSION OBLI Al AA 2.64 8/1/2016 N/A 105.800 6/12/2012 8/1/2016 102.503 $518 1.76 1.42 1.20 2.01 0.03 ($2.29) $250 5476438G4 LOWELL MASS GO PARKING GARA Aa2 N/A 5.50 9/15/2016 N/A 117.611 7/18/2012 9/15/2016 107.864 $274 0.93 1.85 1.15 2.07 0.03 ($3.98) $625 081617PV8 BEND ORE FULL FAITH CREDIT Aa3 N/A 3.10 11/1/2016 N/A 100.000 11/30/2010 11/1/2016 105.279 $661 2.24 0.81 3.10 2.26 0.03 $32.99 $500 56516PNY5 MAPLE GROVE MINN TAXABLE GO N/A AAA 2.00 2/1/2017 N/A 104.782 1/10/2013 2/1/2017 102.796 $518 1.76 0.90 0.80 2.52 0.04 ($1.35) $500 591852UW6 METROPOLITAN COUNCIL MINN M Aaa AAA 1.20 9/1/2017 N/A 100.395 7/24/2012 9/1/2017 100.770 $506 1.71 0.95 1.12 3.12 0.05 $2.61 $900 20772JKK7 CONNECTICUT ST TAXABLE GO B Aa3 AA 1.26 10/15/2017 N/A 101.627 11/29/2012 10/15/2017 100.263 $905 3.07 1.18 0.92 3.23 0.06 ($7.58) $500 084509SW9 BERKS CNTY PA GO BDS 2012A Aal N/A 1.26 11/15/2017 N/A 101.167 11/29/2012 11/15/2017 100.633 $504 1.71 1.07 1.02 3.32 0.06 ($0.83) $70 161664DV6 CHASKA MINN GO TAX INCR REF N/A AA 2.00 12/1/2017 N/A 101.444 8/15/2013 12/1/2017 102.666 $72 0.24 1.20 1.65 3.33 0.06 $1.05 $380 604195VV6 MINNETONKA MINN INDPT SCH D Aaa N/A 1.10 1/1/2018 N/A 100.000 7/2/2013 1/1/2018 99.591 $383 1.30 1.22 1.10 3.42 0.07 ($1.55) $190 751622AJO RAMSEY CNTY MINN TAXABLE GO Aaa AAA 5.10 2/1/2018 2/1/2017 115.720 11/25/2011 2/1/2017 109.816 $213 0.72 1.23 1.90 2.44 0.02 $3.38 $175 269408MF4 EAGAN MINN TAX INCR BDS 201 Aaa AAA 2.00 2/1/2018 N/A 104.054 6/13/2013 2/1/2018 102.298 $180 0.61 1.34 1.10 3.47 0.07 ($1.50) $75 161664DW4 CHASKA MINN GO TAX INCR REF N/A AA 2.00 12/1/2018 N/A 100.000 8/15/2013 12/1/2018 101.269 $76 0.26 1.70 2.00 4.27 0.10 $0.95 $400 113835H54 BROOKLYN CENTER MINN GO TAX N/A AA 3.00 2/1/2021 N/A 101.876 1/24/2014 2/1/2021 102.018 $414 1.40 2.66 2.70 5.99 0.21 $0.98 Tax Muni $11,725 2.22 1.90 101.827 $12,025 40.75 0.87 1.57 1.82 0.03 $82.48 $150 161664BT3 CHASKA MINN GO IMPT BDS 201 N/A AA 2.00 2/1/2016 N/A 104.964 8/16/2012 2/1/2016 102.381 $155 0.52 0.49 0.83 1.56 0.02 $0.14 MUNI $150 2.00 1.59 102.381 $155 0.52 0.49 0.83 1.56 0.02 $0.14 $249 06426RJX2 BANK OF CHINA NEW YORK CITY N/A N/A 0.25 8/5/2014 N/A 100.000 2/5/2014 8/5/2014 99.982 $249 0.84 0.44 0.25 0.10 0.00 ($0.04) $249 86910RBW7 SUSQUEHANNA BK LITITZ PA N/A N/A 0.20 8/7/2014 N/A 100.000 2/7/2014 8/7/2014 99.976 $249 0.84 0.44 0.20 0.10 0.00 ($0.06) $245 36159SRAl GE CAP RETAIL BK DRAPER UTAH N/A N/A 1.90 8/20/2014 N/A 100.000 8/20/2010 8/20/2014 100.189 $247 0.84 0.60 1.90 0.14 0.00 $0.46 $245 14042E3R9 CAPITAL ONE NATL ASSN VA N/A N/A 1.75 8/25/2014 N/A 100.000 8/25/2010 8/25/2014 100.188 $247 0.84 0.57 1.75 0.15 0.00 $0.46 $245 140420MY3 CAPITAL ONE BK USA NATL ASSN N/A N/A 1.75 8/25/2014 N/A 100.000 8/25/2010 8/25/2014 100.188 $247 0.84 0.57 1.75 0.15 0.00 $0.46 $249 17417QAFO CITIZENS BK PA PHILADELPHIA N/A N/A 0.25 9/25/2014 N/A 100.000 6/25/2014 9/25/2014 99.954 $249 0.84 0.45 0.25 0.24 0.00 ($0.11) $249 06278CPS8 BANK INDIA NEW YORK N Y N/A N/A 0.30 10/15/2014 N/A 100.000 4/16/2014 10/15/2014 99.957 $249 0.84 0.45 0.30 0.29 0.00 ($0.11) $249 33583CHE2 FIRST NIAGARA BK N A NY N/A N/A 0.25 10/17/2014 N/A 100.000 4/17/2014 10/17/2014 99.942 $249 0.84 0.45 0.25 0.30 0.00 ($0.14) The information contained herein, while believed to be reliable, is not guaranteed. 5 of 12 Data from BondEdge. Position by Sector CITY OF CHANHASSEN $249 60688MHK3 MIZUHO BK USA INSTL CTF DEP N/A N/A 0.20 11/14/2014 N/A 100.000 5/14/2014 11/14/2014 99.795 $249 0.84 0.76 0.20 0.37 0.00 ($0.51) $249 92937CAVO WEX BK MIDVALE UTAH N/A N/A 0.35 11/28/2014 N/A 100.000 5/29/2013 11/28/2014 100.016 $249 0.84 0.31 0.35 0.41 0.00 $0.04 $249 17669WEP6 CITIZENS ST BK OKEMAH OKLA N/A N/A 0.20 3/5/2015 N/A 100.000 6/5/2014 3/5/2015 99.669 $248 0.84 0.69 0.20 0.68 0.00 ($0.82) $249 59013JAF6 MERRICK BK SOUTH JORDAN UTAH N/A N/A 0.30 3/20/2015 N/A 100.000 6/20/2014 3/20/2015 99.830 $249 0.84 0.54 0.30 0.72 0.00 ($0.42) $249 084601BG7 BERKSHIRE BK PITTSFIELD MA N/A N/A 0.30 3/27/2015 N/A 100.000 6/27/2014 3/27/2015 99.821 $249 0.84 0.55 0.30 0.74 0.01 ($0.45) $249 20033AEY8 COMENITY CAP BK UTAH N/A N/A 0.35 6/2/2015 N/A 100.000 6/2/2014 6/2/2015 99.715 $248 0.84 0.66 0.35 0.92 0.01 ($0.71) $249 07370WGR1 BEAL BK USA LAS VEGAS NEV N/A N/A 0.35 6/3/2015 N/A 100.000 6/4/2014 6/3/2015 99.669 $248 0.84 0.72 0.36 0.92 0.01 ($0.82) $247 05568PV95 BMW BK NORTH AMER UTAH N/A N/A 1.75 4/13/2017 N/A 100.000 4/13/2012 4/13/2017 101.777 $252 0.86 1.10 1.75 2.72 0.04 $4.39 $247 2546706U1 DISCOVER BK GREENWOOD DEL N/A N/A 1.85 4/18/2017 N/A 100.000 4/18/2012 4/18/2017 101.773 $252 0.85 1.20 1.85 2.73 0.04 $4.38 $247 36160XUC9 GE CAP BK INC N/A N/A 2.05 8/21/2017 N/A 100.000 8/19/2011 8/21/2017 102.118 $254 0.86 1.36 2.05 3.04 0.05 $5.23 $248 02587DLY2 AMERICAN EXPRESS CENTRN N/A N/A 1.05 1/31/2018 N/A 100.000 1/31/2013 1/31/2018 99.875 $249 0.84 1.09 1.05 3.53 0.07 ($0.31) $248 94768NJF2 WEBSTER BK WATERBURY N/A N/A 1.00 2/6/2018 N/A 100.000 2/6/2013 2/6/2018 99.886 $249 0.84 1.03 1.00 3.55 0.07 ($0.28) $248 060624XH1 BANK BARODA NEW YORK N Y N/A N/A 1.25 3/8/2018 N/A 100.000 3/8/2013 3/8/2018 99.373 $247 0.84 1.42 1.25 3.61 0.07 ($1.55) $247 795450RT4 SALLIE MAE BK SLT LAKE CITY N/A N/A 2.00 12/11/2018 N/A 100.000 12/11/2013 12/11/2018 100.415 $248 0.84 1.90 2.00 4.29 0.10 $1.03 $247 38147JZT2 GOLDMAN SACHS BK USA NY N/A N/A 2.00 5/14/2019 N/A 100.000 5/14/2014 5/14/2019 99.501 $246 0.83 2.11 2.00 4.67 0.12 ($1.23) CD $5,702 0.94 1.53 100.155 $5,724 19.40 0.84 0.94 1.50 0.03 $8.86 $1,642 0003CHAN3 WF N/A N/A 0.01 7/1/2014 N/A 100.000 6/30/2014 7/1/2014 100.000 $1,642 5.57 0.01 0.01 0.00 0.00 $0.00 $3,304 0006CHAN6 AMERICANA N/A N/A 0.35 7/1/2014 N/A 100.000 6/30/2014 7/1/2014 100.000 $3,327 11.28 0.35 0.35 0.00 0.00 $0.00 $32 0008CHAN2 NORTHLAND N/A N/A 0.00 7/1/2014 N/A 100.000 6/30/2014 7/1/2014 100.000 $32 0.11 0.00 0.00 0.00 0.00 $0.00 $4 0010CHAN8 STERNE N/A N/A 0.01 7/1/2014 N/A 100.000 6/30/2014 7/1/2014 100.000 $4 0.01 0.01 0.01 0.00 0.00 $0.00 $6 0002CHAN5 4M N/A N/A 0.02 7/1/2014 N/A 100.000 6/30/2014 7/1/2014 100.000 $6 0.02 0.02 0.02 0.00 0.00 $0.00 MMF $4,989 0.24 0.00 100.000 $5,012 16.99 0.24 0.24 0.00 0.00 $0.00 Total: $29,256 1.41 2.03 100.379 $29,510 100.00 0.89 1.19 1.76 -0.13 $67.68 The information contained herein, while believed to be reliable, is not guaranteed. 6 of 12 Data from BondEdge. Ratings Alert Report CITY OF CHANHASSEN Rating Actions:Watchlist /Outlook /Upgrades /Downgrades/ Reinstated /Withdrawn /Confirmed /Initial Ratings NO ALERTS The information contained herein, while believed to be reliable, is not guaranteed. 7 of 12 Data from BondEdge. Call Report CITY OF CHANHASSEN 3134G4QX9 FEDERAL HOME LN MTG CORP 1.50 12/27/2018 1.81 -1.48 $750,000 Sep -14 3135GOUR2 FEDERAL NATL MTG ASSN 1.50 2/26/2019 2.68 -1.55 $600,000 May -15 3130A0733 FEDERAL HOME LOAN BANKS 1.85 11/5/2018 3.27 -0.68 $500,000 Nov -15 313383239 FEDERAL HOME LOAN BANKS 0.75 11/21/2018 2.97 -0.98 $750,000 Nov -15 313381TY1 FEDERAL HOME LOAN BANKS 1.00 1/29/2020 3.71 -1.31 $695,000 Jan -16 3136G22K2 FEDERAL NATL MTG ASSN 2.00 11/20/2019 4.70 -0.21 $500,000 May -16 751622AJO RAMSEY CNTY MINN TAXABLE GO 5.10 2/1/2018 2.44 0.02 $190,000 Feb -17 Jun -16 Nov -17 Nov -16 May -17 May -18 Feb -17 Feb -17 The information contained herein, while believed to be reliable, is not guaranteed. 8 of 12 Data from BondEdge. Portfolio Shock CITY OF CHANHASSEN Y -300 3.81 0.77 3.04 0.93 0.92 0.02 $30,633,108 $1,266,428 $891,572 -250 3.34 0.77 2.57 0.92 0.90 0.02 $30,495,644 $1,128,964 $754,724 -200 2.88 0.77 2.11 0.91 0.89 0.01 $30,3601402 $993,722 $620,224 -150 2.43 0.77 1.66 0.90 0.89 0.01 $30,2271288 $860,608 $487,487 -100 2.00 0.79 1.22 0.89 0.88 0.01 $30,100,200 $733,520 $357,099 -50 1.58 0.80 0.77 0.88 0.89 0.00 $29,974,764 $608,084 $227,298 0 1.17 0.81 0.35 0.90 0.95 -0.06 $29,853,574 $486,894 $103,664 50 0.75 0.89 -0.15 1.21 1.08 -0.09 $29,729,384 $362,704 ($431463) 100 0.26 1.01 -0.75 1.26 1.20 -0.05 $29,586,177 $219,497 ($220,837) 150 -0.27 1.11 -1.37 1.31 1.25 0.00 $291431,305 $64,625 ($403,498) 200 -0.78 1.21 -1.99 1.31 1.25 0.02 $29,278,173 ($88,507) ($5841397) 250 -1.29 1.30 -2.60 1.30 1.24 0.02 $29,127,741 ($238,939) ($762,946) 300 -1.79 1.40 -3.20 1.28 1.23 0.02 $28,980,054 ($386,626) ($938,559) Horizon Months 12 Reinvestment Rate 0.055 Aged Simulation Base Currenev USD 0 0 0 0 0 0 Ln M N N .-i Price Change 0 0 $1,000,000 $500,000 _. $0 ° °o ° °o U0n °o ($500,000) ($1,000,000) ($1,500,000) The information contained herein, while believed to be reliable, is not guaranteed. 9 of 12 Data from BondEdge. MONTHLY CASH FLOW CALENDAR CITY OF CHANHASSEN Assumes flat rate Jul -14 35,760 4,988,733 0 0 0 0 0 0 4,988,733 5,024,493 0.00 0.24 Aug -14 80,062 1,233,000 0 0 0 0 0 0 1,233,000 1,313,062 0.52 1.16 Sep -14 32,866 749,000 750,000 0 0 0 0 0 1,499,000 1,531,866 0.51 0.93 Oct -14 28,132 498,000 0 0 0 0 0 0 498,000 526,132 0.45 0.28 Nov -14 41,627 978,000 0 0 0 0 0 0 978,000 1,019,627 0.44 1.17 Dec -14 5,347 0 0 0 0 0 0 0 0 5,347 0.00 0.00 Jan -15 9,299 345,000 0 0 0 0 0 0 345,000 354,299 0.24 0.50 Feb -15 71,583 2,300,000 0 0 0 0 0 0 2,300,000 2,371,583 1.08 2.03 Mar -15 29,999 747,000 0 0 0 0 0 0 747,000 776,999 0.59 0.27 Apr -15 27,428 500,000 0 0 0 0 0 0 500,000 527,428 0.38 1.67 May -15 38,789 0 600,000 0 0 0 0 0 600,000 638,789 1.42 1.71 3un -15 6,194 708,000 0 0 0 0 0 0 708,000 714,194 0.94 0.46 Jul -15 8,307 0 0 0 0 0 0 0 0 8,307 0.00 0.00 Aug -15 38,120 500,000 0 0 0 0 0 0 500,000 538,120 0.38 0.75 Sep -15 28,762 500,000 0 0 0 0 0 0 500,000 528,762 0.20 0.51 Oct -15 14,520 0 0 0 0 0 0 0 0 14,520 0.00 0.00 Nov -15 37,153 615,000 1,250,000 0 0 0 0 0 1,865,000 1,902,153 0.89 1.51 Dec -15 3,920 0 0 0 0 0 0 0 0 3,920 0.00 0.00 Jan -16 8,882 0 695,000 0 0 0 0 0 695,000 703,882 0.40 1.95 Feb -16 35,613 350,000 0 0 0 0 0 0 350,000 385,613 1.05 0.64 Mar -16 23,779 510,000 0 0 0 0 0 0 510,000 533,779 0.60 2.19 Apr -16 14,542 500,000 0 0 0 0 0 0 500,000 514,542 1.05 1.44 May -16 20,321 0 500,000 0 0 0 0 0 500,000 520,321 0.49 2.00 Jun -16 3,920 0 0 0 0 0 0 0 0 3,920 0.00 0.00 Jul -16 4,832 0 0 0 0 0 0 0 0 4,832 0.00 0.00 Aug -16 32,120 500,000 0 0 0 0 0 0 500,000 532,120 2.92 1.20 Sep -16 16,447 750,000 0 0 0 0 0 0 750,000 766,447 0.53 0.84 Oct -16 10,125 0 0 0 0 0 0 0 0 10,125 0.00 0.00 Nov -16 15,340 625,000 0 0 0 0 0 0 625,000 640,340 0.26 3.10 Dec -16 3,920 0 0 0 0 0 0 0 0 3,920 0.00 0.00 Jan -17 4,832 0 0 0 0 0 0 0 0 4,832 0.00 0.00 Feb -17 25,523 500,000 190,000 0 0 0 0 0 690,000 715,523 0.33 1.98 Mar -17 4,550 0 0 0 0 0 0 0 0 4,550 0.00 0.00 Apr -17 10,136 494,000 0 0 0 0 0 0 494,000 504,136 1.15 1.80 May -17 5,625 0 0 0 0 0 0 0 0 5,625 0.00 0.00 Jun -17 3,920 0 0 0 0 0 0 0 0 3,920 0.00 0.00 Jul -17 4,832 0 0 0 0 0 0 0 0 4,832 0.00 0.00 Aug -17 15,678 247,000 0 0 0 0 0 0 247,000 262,678 1.36 2.05 Sep -17 4,572 500,000 0 0 0 0 0 0 500,000 504,572 0.02 1.12 Oct -17 5,700 900,000 0 0 0 0 0 0 900,000 905,700 0.24 0.92 Nov -17 5,637 500,000 0 0 0 0 0 0 500,000 505,637 0.09 1.02 Dec -17 3,923 70,000 0 0 0 0 0 0 70,000 73,923 0.21 1.65 Jan -18 4,849 628,000 0 0 0 0 0 0 628,000 632,849 0.77 1.08 Feb -18 13,131 423,000 0 0 0 0 0 0 423,000 436,131 0.72 1.04 Mar -18 1,559 248,000 0 0 0 0 0 0 248,000 249,559 1.42 1.25 May -18 2,470 0 0 0 0 0 0 0 0 2,470 0.00 0.00 3un -18 3,220 0 0 0 0 0 0 0 0 3,220 0.00 0.00 Jul -18 1,440 240,000 0 0 0 0 0 0 240,000 241,440 0.15 1.20 Aug -18 10,125 0 0 0 0 0 0 0 0 10,125 0.00 0.00 Nov -18 2,470 0 0 0 0 0 0 0 0 2,470 0.00 0.00 Dec -18 3,231 322,000 0 0 0 0 0 0 322,000 325,231 1.54 2.00 Feb -19 10,173 1,655,000 0 0 0 0 0 0 1,655,000 1,665,173 0.52 1.87 The information contained herein, while believed to be reliable, is not guaranteed. 10 Of 12 MONTHLY CASH FLOW CALENDAR CITY OF CHANHASSEN Assumes flat rate May -19 2,476 247,000 0 0 0 0 0 0 247,000 249,476 2.11 2.00 Totals 877,781.00 24,870,733.00 3,985,000.00 0.00 0.00 0.00 0.00 0.00 28,855,733.00 29,733,514.00 30,000,000 25,000,000 0 20,000,000 U. s 15,000,000 N V 10,000,000 H 5,000,000 0 w Int CF w Maturity CF wCall CF The information contained herein, while believed to be reliable, is not guaranteed. 11 Of 12 PLEASE READ THE FOLLOWING IMPORTANT EXPLANATION AND CAUTION: Wells Fargo Securities LLC, Member NFA, NYSE, FINRA and SIPC This account summary was prepared by Wells Fargo Securities Portfolio Analytic Services and is not a substitute for your monthly statement or trade confirmation. Prices and yields are current as of the date of this summary and are subject to change and availability; past performance is no guarantee of future results. Municipal leases are shown at their par value. Any rating provided for a municipal lease investment is a rating associated with the lessee, and does not constitute a rating of the lease investment itself. Wells Fargo Securities is the trade name for the capital markets and investment banking services of Wells Fargo & Company and its subsidiaries, including but not limited to Wells Fargo Securities, LLC, a member of NYSE, FINRA, NFA and SIPC, Wells Fargo Institutional Securities, LLC, a member of FINRA and SIPC, Wells Fargo Prime Services, LLC, a member of FINRA, NFA and SIPC, and Wells Fargo Bank, N.A. Wells Fargo Securities, LLC carries and provides clearing services for Wells Fargo Institutional Securities, LLC customer accounts. Wells Fargo Securities, LLC, Wells Fargo Institutional Securities, LLC, and Wells Fargo Prime Services, LLC are distinct entities from affiliated banks and thrifts. The indicative valuation(s) provided in this report are for information purposes only and are intended for use solely by the addressee. The information contained herein is derived from sources that Wells Fargo Securities in good faith considers reliable, however Wells Fargo Securities does not guarantee the accuracy, reliability or completeness of this information and makes no warranty, express or implied, with respect thereto. The indicative valuations do not represent advice, an offer to purchase or sell any security or other instrument either at the indicative valuation(s) or any other price(s). There is no representation that any transaction can or could have been effected at the indicative valuation(s). The indicative valuations contained herein represent estimates as of the stated valuation date and are subject to change without notice. Such estimates do not necessarily reflect Wells Fargo Securities' internal bookkeeping or theoretical model -based valuation. The indicative valuations are based on certain assumptions, and different assumptions, by Wells Fargo Securities or any other source may yield substantially different results. These valuations also may vary from those of another Wells Fargo division, since they may use other sources of market information or make calculations as of a different time. Wells Fargo Securities is not responsible for any loss or damage arising out of any person's use of or reliance upon the information contained herein or otherwise, including but not limited to, errors (including errors of transmission), inaccuracies, omissions, changes in market factors or other conditions or any other circumstances whether or not such errors are within Wells Fargo Securities' control. Under no circumstances shall Wells Fargo Securities be liable for special or consequential damages that arise from any person's use of or reliance upon the information contained herein, even if Wells Fargo Securities has been advised of the possibility of such damages. Wells Fargo Securities and /or its affiliates may provide advice, may make markets in or may, from time to time, acquire, hold or sell positions in any of the securities to which this indicative valuation relates, either for its own account or for the account of others. 12 of 12