The URL can be used to link to this page

Home My WebLink AboutAgenda Packets - 2011/12/05 CITY OF MOUNDS VIEW SPECIAL CITY COUNCIL MEETING AGENDA MOUNDS VIEW CITY HALL Monday, December 5, 2011 6:00 PM 1. CALL TO ORDER 2. PLEDGE OF ALLEGIANCE 3. ROLL CALL: Flaherty, Stigney, Hull, Mueller, Gunn 4. APPROVAL OF AGENDA 5. PUBLIC INPUT: Citizens may speak to issues not on tonight’s agenda. Before speaking, please give your full name and address for the minutes. Also, please limit your comments to three minutes. 6. SPECIAL ORDER OF BUSINESS 7. COUNCIL BUSINESS A. Truth in Taxation 8. Next Council Work Session: After this Meeting Next Council Meeting: Monday December 12, 2011, at 7 p.m. 9. ADJOURNMENT Item No: 7.A Meeting Date: December 5, 2011 Type of Business: Truth in Taxation Administrator Review: _____ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Mark Beer, Finance Director Item Title/Subject: Truth in Taxation and All Funds Budgets for 2012 Attached is the Truth in Taxation presentation and the budgets for all funds (General, Special Revenue, Debt Service, Capital Projects, and Enterprise) for your consideration. The Council has had an opportunity to review all the funds at different times during the budget process. The City Council did not increase the tax levy for 2012. The Legislature and the Governor eliminated the Market Value Homestead Credit and replaced it with an exemption. Property owners will see a tax increase as a result of this change. The General Fund has been modified to reflect changes for GASB Statement 54 by including the Levy Reduction fund in the General Fund Balance. The Vehicle and Equipment fund has been changed from a special revenue fund to a capital projects fund. Capital activities in the General fund that were previously paid for by the Vehicle and Equipment fund have now been included in that fund. Also, billboard revenue increased by $45,000 reflecting the revised lease for the installation of a dynamic display billboard on 35W. The General fund budget also reflects additional expenditures and revenues for the addition of a K9 unit. Looking forward to the 2012, state budget projections show a surplus for the current budget period. This means that there will probably not be any cuts to the late December LGA payment or amounts that will be paid in 2012. The 2012 budget was constructed with no LGA included. Staff welcomes any comments or questions. Respectfully Submitted, Mark Beer 1 City of Mounds View Truth in Taxation Public Hearing December 5, 2011 6:00 pm 2 Mission Statement Our Mission is to provide high quality public services that effectively address changing citizen and community needs in a fiscally responsible and customer-friendly manner. 3 Expenditures by Purpose Personnel 64% Supplies 5% Contractual services 23% Contingency 0% Fire debt service 3%Capital outlays 1% Transfers 4% General Fund Expenditures by Type 2012 4 General Government 14% Community Development 6% Public Safety 49% Streets & Highways 13%Park & Recreation 9% Debt service - Fire Bonds 3% Other 1% Transfers 5% General Fund Expenditures by Function 2012 Proposed Budget Expenditure Pie Chart 5 - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 General Government Community Development Public Safety Streets & Highways Park & Recreation Debt service - Fire Bonds Other Transfers General Fund Expenditures 2010 Actual 2011 Budget 2012 Proposed Expenditure Bar Graph 6 General Fund Expenditure Changes 2012 General Fund operating expenditures will increase by $54,147 or 1.08%, this includes personnel services, materials and supplies, contractual services, and contingency. 2012 General Fund capital expenditures, debt service and transfers will decrease by $254,167 or 38.06%. Capital outlay is the primary driver of the decrease. Total 2012 General Fund expenditures will decrease by $200,020 or 3.53% over 2011. 7 Revenue Pie Chart General property taxes 71% Other taxes 7% Licenses & permits 3% Intergovern- mental 6% Other revenues 9% Transfers from other funds 4% General Fund Revenues 2012 Proposed Budget 8 $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 General Fund Revenues 2010 Actual 2011 Budget 2012 Proposed Revenue Bar Graph 9 Budget Summary 2012 General Fund significant budget items •The City saw a 1.08% increase in operational spending by $54,147, non-operational spending (debt service, capital outlay, transfers) decreased by $254,167 for an overall decrease of $200,020. •The State “Unalloted” Local Government Aid and MVHC over the last four years totaling $1,193,521 and may make further reductions in 2012. Estimated LGA in 2012 is $232,078, the City did not include this in the budget due to the uncertainty at the state level. •Other non-property tax revenues are projected to increase $21,474, this excludes transfers. 10 Property Tax Levy 2012 2011 Property taxes - base levy $3,367,610 $3,361,798 Special levy - Police Referendum 190,000 196,000 Special levy - PERA rate increase 39,145 39,145 Debt service levy - Fire bonds 93,734 93,885 Debt service levy - Street bonds 190,892 190,553 Capital Project Street Imp.$300,000 $300,000 Total Levy $4,181,381 $4,181,381 No change -$ 11 What Your Tax Dollars Buy for a Median Valued Home Median Valued Home in Mounds View 149,500$ City Tax on Median Valued Home 767.33$ Police 356.90 46.51% Public Works 97.32 12.68% Parks and Recreation 77.26 10.07% Community Development 35.75 4.66% Administration 40.52 5.28% Street Improvement levy 50.18 6.54% Debt service 56.83 7.41% Fire 52.58 6.85% 767.33$ 100.00%12 Sample Home Tax Impact 2011 Home 2011 2012 Home 2012 Taxable City Taxable City Value Tax Value Tax Difference 113,484$ 467.67$ 96,218$ 493.93$ 26.26$ 141,855 584.58 120,272 617.41 32.83 170,226 701.50 144,327 740.89 39.39 176,300 726.53 149,477 767.33 40.80 198,597 818.42 168,381 864.38 45.96 226,967 935.33 192,436 987.85 52.52 Sample Home Tax Impact 13 City of Mounds View 28.87 cents Ramsey County 36.83 cents School District 30.08 cents Other taxing districts 4.22 cents Tax Bill Breakdown 14 Tax Levy Per Capita Arden Hills $327.92 Mounds View $344.01New Brighton $339.64 Shoreview $370.97 Blaine $379.56 Roseville $454.29 Fridley $409.36 Spring Lake Park $542.69 $0.00 $100.00 $200.00 $300.00 $400.00 $500.00 $600.00 1 15 Spending per Capita In the most recent data available from the Office of State Auditor, the City spending per capita ranked 127 out of 225 For cities over 2500 in population 16 Last Four Year’s Budgets Local Government Aid (LGA) to the City has fluctuated with significant amounts being withheld by the state. $121,371 for 2008, withheld $ 60,686 $642,866 for 2009, withheld $147,162 $571,636 for 2010, withheld $339,558 $484,724 for 2011, withheld $252,646 Market Value Homestead Credit $165,672 for 2008, withheld $ 82,836 $154,645 for 2009, withheld $ 0 $190,000 for 2010, withheld $160,156 $184,368 for 2011, withheld $150,477 Tax Levy Street levy in 2010 7.9% or $300,000 General Fund in 2011 2% or $80,993 No levy increase in 2006, 2007, 2008, 2009, 2012 17 Summary The budget is the outcome of a range of factors including: state aid, service level changes, capital projects and inflation. The goal of the budget is to efficiently apply existing city resources and new revenues to provide the service levels and infrastructure desired by the citizens of Mounds View. 18 City of Mounds View Questions? 19 CITY OF MOUNDS VIEW, MINNESOTA Combined 2012 Budget All Funds Special Debt Capital Total Total General Revenue Service Projects Government Enterprise All Fund Funds Funds Funds Funds Funds Funds Revenues: Property taxes 3,690,489$ -$ 190,892$ 300,000$ 4,181,381$ -$ 4,181,381$ Tax increments - 3,400,144 - - 3,400,144 - 3,400,144 All other taxes 349,000 100,000 - 253,000 702,000 - 702,000 Special assessments - - 25,652 20,000 45,652 50,000 95,652 Licenses & permits 182,260 - - - 182,260 - 182,260 Intergovernmental: State categorical aid 259,671 - - 578,000 837,671 - 837,671 County grants 25,199 - - 25,199 - 25,199 Other local govt.67,000 21,216 - - 88,216 - 88,216 Charges for services: Culture and recreation - 187,829 - - 187,829 - 187,829 Utility service charges - - - - - 2,375,240 2,375,240 Miscellaneous 18,565 - - - 18,565 4,300 22,865 Fines 26,300 6,000 - - 32,300 - 32,300 Investment income 195,000 31,300 3,000 92,500 321,800 100,250 422,050 Miscellaneous: Other 227,018 5,350 - 6,000 238,368 - 238,368 Total revenues 5,015,303$ 3,777,038$ 219,544$ 1,249,500$ 10,261,385$ 2,529,790$ 12,791,175$ 20 CITY OF MOUNDS VIEW, MINNESOTA Combined 2012 Budget All Funds Special Debt Capital Total Total General Revenue Service Projects Government Enterprise All Fund Funds Funds Funds Funds Funds Funds Expenditures: General government: Personal services 483,631 - - - 483,631 - 483,631 Supplies 23,590 - - - 23,590 - 23,590 Contractual services 279,411 - - - 279,411 - 279,411 Capital outlay - - - 581,300 581,300 - 581,300 Public safety Personal services 2,063,153 - - - 2,063,153 - 2,063,153 Supplies 82,960 850 - - 83,810 - 83,810 Contractual services 525,666 1,650 - - 527,316 - 527,316 Capital outlay 27,840 - - 110,000 137,840 - 137,840 Public works Personal services 437,287 - - - 437,287 700,616 1,137,903 Supplies 111,845 - - - 111,845 120,786 232,631 Contractual services 148,880 - - - 148,880 1,257,266 1,406,146 Depreciation - - - - - 432,000 432,000 Capital outlay 3,250 - - 1,078,280 1,081,530 1,430,400 2,511,930 Sanitation Personal services - 11,961 - - 11,961 - 11,961 Supplies - - - - - - - Contractual services - 13,238 - - 13,238 - 13,238 Capital outlay - - Culture and recreation: Personal services 205,873 143,393 - - 349,266 - 349,266 Supplies 47,485 17,682 - - 65,167 - 65,167 Contractual services 216,468 370,380 - - 586,848 - 586,848 Capital outlay - 44,000 - 235,500 279,500 - 279,500 Community & Economic development Personal services 319,583 107,988 - - 427,571 - 427,571 Supplies 5,080 300 - - 5,380 - 5,380 Contractual services 21,791 1,427,834 - - 1,449,625 - 1,449,625 Capital outlay - 1,980,000 - - 1,980,000 - 1,980,000 Miscellaneous Personal services 6,500 - - - 6,500 - 6,500 Contractual services 67,671 - - - 67,671 - 67,671 Debt principal 97,524 - 230,000 - 327,524 215,000 542,524 Interest and fiscal charges 39,975 - 31,538 - 71,513 13,680 85,193 Total expenditures 5,215,463 4,119,276 261,538 2,005,080 11,601,357 4,169,748 15,771,105 Surplus of revenues over (under) expenditures and (200,160) (342,238) (41,994) (755,580) (1,339,972) (1,639,958) (2,979,930) Other financing sources (uses) Transfers in 227,633 559,437 - 485,000 1,272,070 289,000 1,561,070 Transfers out (245,000) (389,437) - (390,340) (1,024,777) (536,293) (1,561,070) Total other financing sources (uses)(17,367) 170,000 - 94,660 247,293 (247,293) - Net change in fund balance or net assets (217,527) (172,238) (41,994) (660,920) (1,092,679) (1,887,251) (2,979,930) Add back capital outlay & debt principal - - - - - 1,645,400 1,645,400 Fund balance, January 1:9,280,930 2,829,744 338,668 11,024,077 23,473,418 13,231,568 36,704,986 Fund balance, December 31 9,063,403 2,657,506 296,674 10,363,157 22,380,739 12,989,717 35,370,456 21 City of Mounds View 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 General Fund:Actual Actual Actual Budget Request Dollar Percent Revenues: Property taxes - Base levy 3,253,546 3,105,868 3,000,707 3,361,798 3,367,610 5,812 0.17% Special tax levies, Bonds 158,370 158,895 154,606 93,885 93,734 (151) -0.16% Special tax levies, Operations 76,145 241,822 242,704 235,145 229,145 (6,000) -2.55% Franchise tax 283,796 235,002 225,581 249,900 253,000 3,100 1.24% Other taxes 157,410 102,284 81,975 45,000 45,000 - 0.00% Hotel/motel tax 51,263 43,835 51,002 45,000 51,000 6,000 13.33% Licenses and permits 193,930 175,816 129,834 178,560 182,260 3,700 2.07% Intergovernmental 380,602 816,717 570,267 321,171 326,671 5,500 1.71% Charges for services 11,459 23,302 41,570 16,565 18,565 2,000 12.07% Fines & forfeitures 38,617 29,819 26,107 30,300 26,300 (4,000) -13.20% Interest 187,181 96,267 75,421 104,000 195,000 91,000 87.50% Miscellaneous 189,264 124,176 305,000 175,844 227,018 51,174 29.10% Transfers:- 0.00% Special Projects Fund 90,000 - - 90,000 90,000 - 0.00% DARE Fund 4,393 4,393 4,393 3,000 - (3,000) -100.00% Water Fund 58,115 59,859 61,655 63,505 65,410 1,905 3.00% Sewer Fund 46,030 47,411 48,833 50,298 51,807 1,509 3.00% Storm Water Fund - - - - 6,756 6,756 0.00% Street Light Fund 2,060 2,122 2,186 2,252 2,320 68 3.02% Levy Reduction Fund 249,000 249,315 250,000 250,000 - (250,000) -100.00% Levy Reduction Fund - permit 80,000 - - 6,472,060 - (6,472,060) -100.00% Vehicle & Equipment Fund 117,250 44,000 13,319 333,094 11,340 (321,754) -96.60% Total revenues 5,628,431 5,560,903 5,285,160 12,121,377 5,242,936 (6,878,441) -56.75% Expenditures: Legislative Services: City Council 49,409 44,343 42,286 49,767 48,125 (1,642) -3.30% Advisory Commissions 22,245 9,575 7,079 11,150 10,650 (500) -4.48% Subtotal 71,654 53,918 49,365 60,917 58,775 (2,142) -3.52% Administrative Services: City Administrator 181,283 214,640 207,729 222,794 232,914 10,120 4.54% Elections 32,051 11,851 37,783 10,323 36,500 26,177 253.58% Finance 232,688 238,674 237,848 247,870 240,192 (7,678) -3.10% Central Services 242,641 193,815 197,045 238,923 218,251 (20,672) -8.65% Subtotal 688,663 658,980 680,405 719,910 727,857 7,947 1.10% Community Development 459,520 439,112 435,777 463,831 346,454 (117,377) -25.31% Police 2,235,909 2,276,827 2,179,150 2,304,086 2,373,986 69,900 3.03% Fire 292,697 318,765 332,068 297,467 463,132 165,665 55.69% Public Works Administration 113,957 106,794 111,755 123,715 129,153 5,438 4.40% Parks, Recreation & Forestry: Recreation 136,343 108,647 102,108 109,600 107,200 (2,400) -2.19% Parks 316,080 310,388 296,789 363,464 307,626 (55,838) -15.36% Forestry 49,675 50,496 34,385 55,000 55,000 - 0.00% Subtotal 502,098 469,531 433,282 528,064 469,826 (58,238) -11.03% Fleet Services: Building & Grounds Mtnce 138,150 132,439 119,776 133,854 129,958 (3,896) -2.91% Vehicle & Equipment Mtnce 92,739 84,828 89,560 86,259 84,390 (1,869) -2.17% Subtotal 230,889 217,267 209,336 220,113 214,348 (5,765) -2.62% Streets: Pavement Management 204,005 211,452 193,426 380,501 196,599 (183,902) -48.33% Snow & Ice Control 130,272 121,874 126,453 122,712 123,533 821 0.67% Sign Maintenance 37,262 35,321 32,371 36,594 37,629 1,035 2.83% Subtotal 371,539 368,647 352,250 539,807 357,761 (182,046) -33.72% Other Convention & Visitor's Bureau 48,715 40,171 48,452 42,750 48,450 5,700 13.33% Social Service Coordination 18,375 18,926 18,661 18,661 19,221 560 3.00% Miscellaneous/contingency 5,400 6,263 3,944 6,500 6,500 - 0.00% Transfers to other funds 350,000 335,000 220,000 245,000 245,000 - 0.00% Debt service - Fire Bonds 150,626 149,283 147,195 89,662 - (89,662) -100.00% Subtotal 573,116 549,643 438,252 402,573 319,171 (83,402) -20.72% Total expenditures 5,540,042 5,459,484 5,221,640 5,660,483 5,460,463 (200,020) -3.53% Net change in fund balance 88,389 101,419 63,520 6,460,894 (217,527) (6,678,421) Beginning Fund Balance 2,566,707 2,655,097 2,756,516 2,820,036 9,280,930 Ending Fund Balance 2,655,097 2,756,516 2,820,036 9,280,930 9,063,403 (6,678,421) 22 City of Mounds View GENERAL FUND 2012 Budget Summary Community Park Public 2012 2011 Percent Legislative Admin Finance Central Development Police Fire & Rec Works Misc.Total Total Variance Change Current Personnel services 32,845$ 228,404$ 222,382$ -$ 319,583$ 2,035,891$ 27,262$ 205,873$ 437,287$ 6,500$ 3,516,027$ 3,534,391$ (18,364)$ -0.52% Materials & supplies 1,900 585 700 20,405 5,080 82,960 - 47,485 111,845 - 270,960 249,589 21,371 8.56% Contractual services 24,030 40,425 17,110 197,846 21,791 238,635 287,031 216,468 148,880 67,671 1,259,887 1,208,747 51,140 4.23% Contingency - - - - - - - - - - - - - #DIV/0! Current total 58,775 269,414 240,192 218,251 346,454 2,357,486 314,293 469,826 698,012 74,171 5,046,874 4,992,727 54,147 1.08% Other Principal - - - - - - 97,524 - - - 97,524 50,213 47,311 94.22% Interest - - - - - - 39,975 - - - 39,975 39,449 526 1.33% Capital outlays - - - - - 16,500 11,340 - 3,250 - 31,090 333,094 (302,004) -90.67% Transfers to other funds - - - - - - - - - 245,000 245,000 245,000 - 0.00% Other total - - - - - 16,500 148,839 - 3,250 245,000 413,589 667,756 (254,167) -38.06% Department Total 58,775$ 269,414$ 240,192$ 218,251$ 346,454$ 2,373,986$ 463,132$ 469,826$ 701,262$ 319,171$ 5,460,463$ 5,660,483$ (200,020)$ -3.53%23 City of Mounds View 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 General Fund:Actual Actual Actual Budget Request Dollar Percent Capital Outlays Legislative Services: City Council - - - - - - 0.00% Advisory Commissions - - - - - - 0.00% Subtotal - - - - - - 0.00% Administrative Services: City Administrator - - - - - - 0.00% Elections - - - - - - 0.00% Central Services 24,651 6,617 7,416 23,000 - (23,996) -104.33% Finance - - - - - - 0.00% Subtotal 24,651 6,617 7,416 23,000 - (23,996) -104.33% Community Development - 1,066 - - - - 0.00% Police 89,804 36,239 5,579 30,200 16,500 (38,033) -125.94% Fire 13,048 35,789 49,452 22,894 11,340 (21,273) -92.92% Public Works Administration - - - - - (1,791) 0.00% Parks, Recreation & Forestry: Recreation - - - - - - 0.00% Parks 5,845 - - 66,000 - (12,024) -18.22% Forestry - - - - - - 0.00% Subtotal 5,845 - - 66,000 - (12,024) -18.22% Fleet Services: Building & Grounds Mtnce - - - - 1,750 1,750 0.00% Vehicle & Equipment Mtnce - - - - - - 0.00% Subtotal - - - - 1,750 1,750 0.00% Streets: Pavement Management 2,002 - - 191,000 1,500 (21,254) -11.13% Snow & Ice Control 6,001 949 - - - (2,705) 0.00% Sign Maintenance - - - - - - 0.00% Subtotal 8,003 949 - 191,000 1,500 (23,959) -12.54% Other Convention & Visitor's Bureau - - - - - - 0.00% Social Service Coordination - - - - - - 0.00% Miscellaneous/contingency - - - - - - 0.00% Transfers to other funds - - - - - - 0.00% Debt service - Fire Bonds - - - - - - 0.00% Subtotal - - - - - - 0.00% Total expenditures 141,351 80,660 62,447 333,094 31,090 (119,326) -35.82% 24 City of Mounds View 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 General Fund:Actual Actual Actual Budget Request Dollar Percent Operating Expenditures: Legislative Services: City Council 49,409 44,343 42,286 49,767 48,125 (1,642) -3.30% Advisory Commissions 22,245 9,575 7,079 11,150 10,650 (500) -4.48% Subtotal 71,654 53,918 49,365 60,917 58,775 (2,142) -3.52% Administrative Services: City Administrator 181,283 214,640 207,729 222,794 232,914 10,120 4.54% Elections 32,051 11,851 37,783 10,323 36,500 26,177 253.58% Central Services 217,990 187,198 189,629 215,923 218,251 2,328 1.08% Finance 232,688 238,674 237,848 247,870 240,192 (7,678) -3.10% Subtotal 664,012 652,363 672,989 696,910 727,857 30,947 4.44% Community Development 459,520 438,046 435,777 463,831 346,454 (117,377) -25.31% Police 2,146,105 2,240,588 2,173,571 2,273,886 2,357,486 83,600 3.68% Fire 279,649 282,976 282,616 274,573 314,293 39,720 14.47% Public Works Administration 113,957 106,794 111,755 123,715 129,153 5,438 4.40% Parks, Recreation & Forestry: Recreation 136,343 108,647 102,108 109,600 107,200 (2,400) -2.19% Parks 310,235 310,388 296,789 297,464 307,626 10,162 3.42% Atheletic Field Mtnce - - - - - - 0.00% Forestry 49,675 50,496 34,385 55,000 55,000 - 0.00% Subtotal 496,253 469,531 433,282 462,064 469,826 7,762 1.68% Fleet Services: Building & Grounds Mtnce 138,150 132,439 119,776 133,854 128,208 (5,646) -4.22% Squad & Staff Car Mtnce - - - - - - 0.00% Vehicle & Equipment Mtnce 92,739 84,828 89,560 86,259 84,390 (1,869) -2.17% Subtotal 230,889 217,267 209,336 220,113 212,598 (7,515) -3.41% Streets: Pavement Management 202,003 211,452 193,426 189,501 195,099 5,598 2.95% Snow & Ice Control 124,271 120,925 126,453 122,712 123,533 821 0.67% Sign Maintenance 37,262 35,321 32,371 36,594 37,629 1,035 2.83% Subtotal 363,536 367,698 352,250 348,807 356,261 7,454 2.14% Other Convention & Visitor's Bureau 48,715 40,171 48,452 42,750 48,450 5,700 13.33% Social Service Coordination 18,375 18,926 18,661 18,661 19,221 560 3.00% Miscellaneous/contingency 5,400 6,263 3,944 6,500 6,500 - 0.00% Transfers to other funds 350,000 335,000 220,000 245,000 245,000 - 0.00% Debt service - Fire Bonds 150,626 149,283 147,195 89,662 137,499 47,837 53.35% Subtotal 573,116 549,643 438,252 402,573 456,670 54,097 13.44% Total expenditures 5,398,691 5,378,824 5,159,193 5,327,389 5,429,373 101,984 1.91% 25 General Fund Revenue Detail - 2012 Budget Acct 2008 2009 2010 2011 2012 Change from 2011 #Description Actual Actual Actual Budget Request Dollar Percent Taxes 3101 Current ad valorem property tax 3,253,546 3,105,868 3,000,707 3,361,798 3,367,610 5,812 0.17% 3101 Fire Bonds property tax 1997 60,410 61,226 60,362 - - - 0.00% 3101 Fire Mini-Pumper property tax 2,495 2,146 - - - - 0.00% 3101 Fire Bonds property tax 2005 95,465 95,523 94,244 93,885 93,734 (151) -0.16% 3101 PERA rate increase property tax 6,145 26,822 34,704 39,145 39,145 - 0.00% 3101 Police Officer property tax 70,000 215,000 208,000 196,000 190,000 (6,000) -3.06% 3102 Delinquent ad valorem prop tax 93,258 47,192 5,740 - - - 0.00% 3111 Manufact home tax - current 20,106 18,147 19,568 20,000 20,000 - 0.00% 3112 Manufact home tax - delinquent 11,903 10,476 8,679 10,000 10,000 - 0.00% 3113 Man. home Market value credit 15,129 11,507 11,239 15,000 15,000 - 0.00% 3125 Excess TIF 10,806 12,052 32,839 - - - 0.00% 3180 Franchise tax on utilities 283,796 235,002 225,581 249,900 253,000 3,100 1.24% 3190 Penalties & interest 6,208 2,910 3,910 - - - 0.00% 3195 Hotel/Motel tax 51,263 43,835 51,002 45,000 51,000 6,000 13.33% Total taxes 3,980,530 3,887,706 3,756,575 4,030,728 4,039,489 8,761 0.22% Licenses and Permits 3211 Liquor on-sale 21,320 21,620 18,395 20,000 20,000 - 0.00% 3212 Liquor off-sale 2,475 645 410 700 700 - 0.00% 3215 Malt on-sale license 1,835 1,820 1,870 1,000 1,000 - 0.00% 3216 Malt off-sale 100 10 740 100 100 - 0.00% 3221 Tobacco license 1,896 3,000 2,685 1,900 1,900 - 0.00% 3223 Amusement devices 1,950 810 795 1,000 1,000 - 0.00% 3231 Bowling alley 640 640 640 640 640 - 0.00% 3232 Garbage hauling 1,803 1,740 1,820 1,800 2,500 700 38.89% 3233 Gasoline station 582 582 736 600 600 - 0.00% 3234 Used car sales 158 200 200 150 150 - 0.00% 3235 Kennel 176 263 184 120 120 - 0.00% 3236 Restraurant licenses 4,190 4,290 4,075 4,000 4,000 - 0.00% 3238 Transient & solicitor 2,455 2,385 2,480 1,500 1,500 - 0.00% 3239 Apartment 15,480 14,101 22,912 15,000 18,000 3,000 20.00% 3241 Dog 2,282 1,060 2,204 900 900 - 0.00% 3242 Massage therapy 955 435 100 - - - 0.00% 3250 General contractor 1,050 1,050 595 1,100 1,100 - 0.00% 3251 HVAC contractor 4,586 4,503 5,035 3,800 3,800 - 0.00% 3252 Cement contractor 150 436 450 250 250 - 0.00% 3253 Asphalt contractor 500 700 552 500 500 - 0.00% 3254 Excavating contractor 50 50 150 50 50 - 0.00% 3255 Sign & billboard contractor 650 535 360 500 500 - 0.00% 3256 Sewer & water contractor - 50 5 50 50 - 0.00% 3257 Other contractor 850 900 1,240 700 700 - 0.00% 3258 License check 1,761 1,210 1,079 1,000 1,000 - 0.00% 3260 Fire permits 1,155 750 900 600 600 - 0.00% Subtotal licenses 69,049 63,785 70,612 57,960 61,660 3,700 6.38% 26 General Fund Revenue Detail - 2012 Budget Acct 2008 2009 2010 2011 2012 Change from 2011 #Description Actual Actual Actual Budget Request Dollar Percent 3262 Grading permit 59 - - - - - 0.00% 3268 Plan check fee 22,603 21,444 8,806 22,000 22,000 - 0.00% 3270 Building permits 52,705 44,478 18,470 55,000 55,000 - 0.00% 3271 Fixed fee - building permits 26,901 18,872 14,007 18,000 18,000 - 0.00% 3272 Wetland buffer permit 78 75 - - - - 0.00% 3273 HVAC permits 11,726 11,867 8,615 12,000 12,000 - 0.00% 3274 Plumbing permits 5,267 6,860 3,516 8,000 8,000 - 0.00% 3275 Non-building permits 4,616 7,038 4,784 5,000 5,000 - 0.00% 3278 Interim use permits 25 - - - - - 0.00% 3279 Conditional use permits 750 1,250 1,200 600 600 - 0.00% 3280 Building surcharge 127 109 (260) - - - 0.00% 3281 Fixed fee building surcharge 10 5 24 - - - 0.00% 3282 Mechanical/commercial surcharg 3 31 5 - - - 0.00% 3283 HVAC surcharge 5 17 49 - - - 0.00% 3284 Plumbing surcharge 1 1 5 - - - 0.00% 3287 Commercial plmb surcharge 5 (16) 1 - - - 0.00% Subtotal permits 124,881 112,031 59,222 120,600 120,600 - 0.00% Total licenses & permits 193,930 175,816 129,834 178,560 182,260 3,700 2.07% Intergovernmental: 3318 Federal grant 517 920 749 - - - 0.00% 3341 Local Government Aid 60,685 495,704 232,078 - - - 0.00% 3346 PERA Aid 8,671 8,671 8,671 8,671 8,671 - 0.00% 3351 Street Aid - MSA maintenance 93,541 94,294 105,033 100,000 105,000 5,000 5.00% 3355 Police Aid 128,710 128,272 120,233 128,000 116,000 (12,000) -9.38% 3356 Police training 7,610 7,532 6,095 7,500 6,000 (1,500) -20.00% 3358 State forestry grant - - - - - 0.00% 3359 Other state grants 17,642 18,064 30,164 15,000 18,000 3,000 20.00% 3370 Other local government revenue 3,891 745 709 - 6,000 6,000 0.00% 3371 IDS # 621 - SRO 59,335 62,515 66,535 62,000 67,000 5,000 8.06% Total intergovernmental 380,602 816,717 570,267 321,171 326,671 5,500 1.71% Charges for services 3410 Advertising revenue - - 1,175 50 50 - 0.00% 3415 Housing inspections 150 - 47 50 50 - 0.00% 3418 HRA inspections 2,256 1,656 2,188 1,900 1,900 - 0.00% 3419 Investigations 554 371 792 - - - 0.00% 3421 Police reports 1,378 1,645 5,168 1,200 1,200 - 0.00% 3422 Documents / copies 60 536 158 90 90 - 0.00% 3423 Customer service 1,616 814 238 500 500 - 0.00% 3425 Book sales - various 290 265 70 - - - 0.00% 3426 Reimbursed staff time 1,179 780 560 1,000 1,000 - 0.00% 3430 Right-of-way 875 9,800 16,192 2,000 4,000 2,000 100.00% 3431 Street opening fee 1,125 (875) - - - - 0.00% 3432 Tree removal charges (4,974) 4,010 7,632 4,500 4,500 - 0.00% 3433 Overload permits 2,850 1,425 4,950 2,000 2,000 - 0.00% 3458 Zoning letter 125 100 75 75 75 - 0.00% 3460 Easement vacation 250 250 - - - - 0.00% 3461 Subdivision 1,275 775 1,250 1,000 1,000 - 0.00% 3462 Variance 1,200 1,125 450 1,000 1,000 - 0.00% 3463 Rezoning 500 - - 500 500 - 0.00% 3464 Development - non refund 375 375 375 350 350 - 0.00% 3465 Code appeal - 250 250 - - - 0.00% 3466 Comprehensive Plan Amendmen - - - - - - 0.00% 3467 PUD amendment 375 - - 350 350 - 0.00% Total charges for services 11,459 23,302 41,570 16,565 18,565 2,000 12.07% 27 THIS PAGE LEFT BLANK INTENTIONALLY 28 General Fund Revenue Detail - 2012 Budget Acct 2008 2009 2010 2011 2012 Change from 2011 #Description Actual Actual Actual Budget Request Dollar Percent Fines and Forfeitures 3510 Ramsey County municipal court 21,949 17,835 19,047 18,000 18,000 - 0.00% 3515 Mn Highway Patrol 466 234 568 300 300 - 0.00% 3520 Administrative offenses 13,402 10,050 4,817 10,000 6,000 (4,000) -40.00% 3525 False alarm charges 2,800 1,700 1,675 2,000 2,000 - 0.00% Total fines & forfeitures 38,617 29,819 26,107 30,300 26,300 (4,000) -13.20% Other Revenue 3550 Special assessments 7,214 8,957 15,203 5,000 7,000 2,000 40.00% 3610 Investment income 187,181 96,267 75,421 104,000 195,000 91,000 87.50% 3630 Billboard Lease 105,800 53,549 53,806 55,156 99,342 44,186 80.11% 3631 Water tower rental - - 18,605 85,868 89,304 3,436 4.00% 3634 Equipment and space rental 52 5,250 5,050 3,120 3,172 52 1.67% 3650 Donations 3,702 5,390 465 - - - 0.00% 3655 City fines 25 - - - - - 0.00% 3656 Tree sales 1,326 (40) (101) 1,200 1,200 - 0.00% 3665 Park site permit 8,982 9,189 12,214 7,000 8,000 1,000 14.29% 3679 Vending machine commissions - 5 15 - - - 0.00% 3680 Other revenue 25,668 5,253 153,198 11,000 11,000 - 0.00% 3685 Insurance reimbursements 19,275 31,551 29,607 4,000 4,000 - 0.00% 3690 Cash over / short - - - - - - 0.00% 3911 Sale of assets 4,818 - 7,000 3,000 3,000 - 0.00% 3912 Resale of materials 12,402 5,072 9,938 500 1,000 500 100.00% Total other revenue 376,445 220,443 380,421 279,844 422,018 142,174 50.80% Transfers & Debt proceeds 3972 Transfers: Special Projects 90,000 - - 90,000 90,000 - 0.00% Vehicle replacement 117,250 44,000 13,319 333,094 11,340 (321,754) -96.60% DARE fund 4,393 4,393 4,393 3,000 - (3,000) -100.00% Water 58,115 59,859 61,655 63,505 65,410 1,905 3.00% Sewer 46,030 47,411 48,833 50,298 51,807 1,509 3.00% Storm Water - - - - 6,756 6,756 0.00% Street light 2,060 2,122 2,186 2,252 2,320 68 3.02% Levy reduction - levy 249,000 249,315 250,000 250,000 - (250,000) -100.00% Levy reduction - other 80,000 - - 6,472,060 - (6,472,060) -100.00% Total Transfers & Debt 646,848 407,100 380,386 7,264,209 227,633 (7,036,576) -96.87% Total 5,628,431 5,560,903 5,285,160 12,121,377 5,242,936 (6,878,441) -56.75% 29 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent City Council (100 - 4100): Personnel services 0100 Salaries, regular 29,292 29,196 29,196 29,100 29,100 - 0.00% 0300 Social Security 1,873 1,873 1,873 2,226 2,226 - 0.00% 0321 PERA 885 570 570 1,455 1,455 - 0.00% 0500 Workers compensation 36 41 48 67 64 (3) -4.48% Total personnel services 32,086 31,680 31,687 32,848 32,845 (3) -0.01% Materials & supplies 1600 Supplies, operating 1,140 1,158 870 1,600 1,600 - 0.00% Total materials & supplies 1,140 1,158 870 1,600 1,600 - 0.00% Contractual services 3030 Other professional services 10,093 5,985 5,542 9,490 7,925 (1,565) -16.49% 3610 Memberships 3,378 3,585 2,821 2,900 2,826 (74) -2.55% 3630 Training & conferences 1,677 875 501 1,800 1,800 - 0.00% 4800 Bonding & insurance 1,035 1,060 865 1,129 1,129 - 0.00% Total contractual services 16,183 11,505 9,729 15,319 13,680 (1,639) -10.70% Capital outlays - - - - - - 0.00% Total City Council 49,409 44,343 42,286 49,767 48,125 (1,642) -3.30% Advisory Commissions (100-4110): Materials & supplies 1600 Supplies, operating - - - 200 200 - 0.00% 2100 Books & periodicals - - - 100 100 - 0.00% Total materials & supplies - - - 300 300 - 0.00% Contractual services 3030 Other professional services 3,820 2,199 2,710 6,000 5,500 (500) -8.33% 3630 Training & conferences 153 - 30 350 350 - 0.00% 3900 Festivities Commission 18,272 7,376 4,339 4,500 4,500 - 0.00% Total contractual services 22,245 9,575 7,079 10,850 10,350 (500) -4.61% Capital outlays - - - - - - 0.00% Total Advisory Commissions 22,245 9,575 7,079 11,150 10,650 (500) -4.48% 2012 Budget Summary 30 Fund: 100 Department: 4100 City Council Account Description 2009 2010 2011 2012 Description 1600 Supplies, operating 950 850 800 800 Employee appreciation dinner 950 850 800 800 Plaques and gift certificates for employee appreciation 1,900 1,700 1,600 1,600 3030 Other professional services 3,000 1,000 1,000 500 Strategic planning session 8,490 8,490 8,490 7,425 Contractual minutes for Council mtgs ( $275 x 24 reg, + 3 special) 11,490 9,490 9,490 7,925 3610 Memberships 25 25 25 25 Mn Mayor's Association 3,500 2,801 2,875 2,801 North Metro Mayors (1/2 membership; 1/2 in EDA) 3,525 2,826 2,900 2,826 3630 Conferences 2,000 2,000 1,800 1,800 Council training, LMC conference, RCCLG dinners & NLC conference 2,000 2,000 1,800 1,800 4800 Bonds & insurance 1,129 1,129 1,129 1,129 Open meeting law insurance and general property & liability 1,129 1,129 1,129 1,129 20,044 17,145 16,919 15,280 -0.37%-14.46%-1.32%-9.69% Fund: 100 Department: 4110 Advisory Commissions Account Description 2009 2010 2011 2012 Description 1600 Supplies, operating 75 75 60 60 Misc supplies for various commissions. 150 150 140 140 Copies for Charter Commission 225 225 200 200 2100 Books & periodicals 75 75 100 100 Misc periodicals - Comp plan review, Ordinance revisions. 75 75 100 100 3030 Other professional services 1,000 1,000 500 500 Misc. consultant services. 2,000 2,000 2,000 2,000 Charter commission legal fees 3,700 3,700 3,500 3,000 Planning Commission meeting minutes 6,700 6,700 6,000 5,500 3630 Training 200 200 175 175 Misc training & conferences. 200 200 175 175 Planning Commissioner training & conferences 400 400 350 350 3900 Festival in the Park 4,500 4,500 4,500 4,500 City Festival in the Park (overtime for PW and PD and copier costs) 4,500 4,500 4,500 4,500 11,900 11,900 11,150 10,650 -46.08%0.00%-6.30%-4.48% 31 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Request Request Dollar Percent Office of the City Administrator (100 - 4130): Personnel services 0100 Salaries, regular 143,461 169,137 162,076 168,180 175,098 6,918 4.11% 0110 Salaries, over-time - - - 702 716 14 1.99% 0150 Salaries, part-time 286 320 - 2,810 2,910 100 3.56% 0300 Social Security 10,339 12,173 11,655 13,135 13,673 538 4.10% 0321 PERA 9,022 10,977 11,035 12,244 12,747 503 4.11% 0400 Group insurance 14,460 18,489 18,953 19,970 22,259 2,289 11.46% 0500 Workers compensation 501 637 727 973 1,001 28 2.88% 0990 Severence - - - - - - 0.00% Total personnel services 178,069 211,733 204,446 218,014 228,404 10,390 4.77% Materials & supplies 1230 Supplies, equipment 130 - 56 450 450 - 0.00% 1600 Supplies, operating 34 28 143 90 100 10 11.11% 2100 Books & periodicals 49 - 16 45 35 (10) -22.22% Total materials & supplies 213 28 215 585 585 - 0.00% Contractual services 3100 Communications 432 456 694 680 760 80 11.76% 3610 Memberships 1,076 1,037 178 240 240 - 0.00% 3630 Training & conferences 1,260 1,206 2,191 2,775 2,525 (250) -9.01% 3800 Mileage 233 180 5 500 400 (100) -20.00% Total contractual services 3,001 2,879 3,068 4,195 3,925 (270) -6.44% Capital outlays 7030 Equipment - - - - - - 0.00% 0.00% Total City Administrator 181,283 214,640 207,729 222,794 232,914 10,120 4.54% Elections (100 - 4140): Personnel services 0100 Salaries, regular 7,350 7,854 13,778 7,045 - (7,045) -100.00% 0110 Salaries, overtime - - - - - - 0.00% 0150 Salaries, part-time 18,719 - 15,000 - - - 0.00% 0300 Social Security 535 565 998 539 - (539) -100.00% 0321 PERA 476 526 955 467 - (467) -100.00% 0400 Group insurance 1,048 1,213 1,934 1,095 - (1,095) -100.00% 0500 Workers compensation 126 52 162 152 - (152) -100.00% 0990 Severence - - - 0.00% Total personnel services 28,254 10,210 32,827 9,298 - (9,298) -100.00% Materials & supplies 1600 Supplies, operating 2,927 - 3,229 100 - (100) -100.00% Total materials & supplies 2,927 - 3,229 100 - (100) -100.00% Contractual services 3030 Other professional services 636 1,641 1,727 825 36,500 35,675 4324.24% 3410 Legal notices 234 - - 100 - (100) -100.00% Total contractual services 870 1,641 1,727 925 36,500 35,575 3845.95% 7030 Capital outlays - - - - - - 0.00% Total Elections 32,051 11,851 37,783 10,323 36,500 26,177 253.58% 2012 Budget Summary 32 Fund: 100 Department: 4130 Office of the City Administrator Account Description 2009 2010 2011 2012 Description 1230 Supplies, equipment 800 500 450 450 Furniture or equipment under the $1,000 capitalization threshold 800 500 450 450 1600 Supplies, Operating 100 100 90 100 Miscellaneous supplies 100 100 90 100 2100 Books & Periodicals 50 50 45 35 Miscellaneous reference books 50 50 45 35 3100 Communications 720 432 680 760 Sprint/Nextel service 720 432 680 760 3610 Memberships 800 760 - - ICMA - International City Manager's Association 50 50 50 50 MAMA - (Administrator) Metro Area Manager's Association 160 120 150 150 Mn City County Managers Association 1,800 1,800 - - New Brighton/Mounds View Rotary Club dues (administrator, police chief) 40 35 40 40 Municipal Clerks & Finance Officers Association 2,850 2,765 240 240 3630 Training & conferences 200 150 100 75 MAMA meetings 500 500 400 350 LMC / miscellaneous training 50 50 50 50 Chamber lunches 1,000 750 700 750 LMC annual conference 500 700 775 800 Mn City County Managers Assoc seminar - 750 750 500 Mn Clerks and Finance Officers Association (MCFOA) institute training 1,800 - - - National ICMA conference (City Administrator)(budget in 2007, 2009) 4,050 2,900 2,775 2,525 3800 Mileage 800 600 500 400 Miscellaneous mileage @ IRS rate. 800 600 500 400 9,370 7,347 4,780 4,510 39.12%-21.59%-34.94%-5.65% Fund: 100 Department: 4140 Elections Account Description 2009 2010 2011 2012 Description 1600 Supplies, operating 100 600 - - Misc supplies - paper, pens, files, and mats for gym - 1,350 100 - Election Judge meals (even years and special elections) - 1,000 - - Paper ballots (even years and special elections) 100 2,950 100 - 3030 Other professional services 625 1,700 625 36,500 Ramsey County fees (2012 contract to conduct elections) 200 200 200 - Equip. maint. service costs (voting equip.)(even years and special elections) 825 1,900 825 36,500 3410 Legal notices 200 400 100 - Primary and general election (even years and special elections) 200 400 100 - 1,125 5,250 1,025 36,500 -72.22%366.67%-80.48%3460.98% 33 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Finance (100 - 4150): Personnel services 0100 Salaries, regular 154,033 159,984 159,620 159,110 146,607 (12,503) -7.86% 0110 Overtime - 14 - 57 58 1 1.75% 0150 Salaries, part-time 19,444 20,215 19,730 20,935 21,354 419 2.00% 0300 Social Security 12,212 11,811 11,922 13,778 12,853 (925) -6.71% 0321 PERA 11,290 12,091 12,501 13,057 12,181 (876) -6.71% 0400 Group insurance 18,793 16,241 16,817 22,170 28,108 5,938 26.78% 0500 Workers compensation 872 1,063 1,243 1,325 1,221 (104) -7.85% 0990 Severence - - 0.00% Subtotal 216,644 221,419 221,833 230,432 222,382 (8,050) -3.49% Materials & supplies 1230 Supplies, equipment 479 165 - 300 300 - 0.00% 1600 Supplies, operating - 21 - 75 75 - 0.00% 2100 Books & periodicals 379 340 475 325 325 - 0.00% Subtotal 858 526 475 700 700 - 0.00% Contractual services 3030 Other professional 8,771 8,890 9,099 9,345 9,535 190 2.03% 3430 Printing 179 1,736 118 700 700 - 0.00% 3610 Memberships 510 700 445 520 560 40 7.69% 3630 Training 2,213 1,857 2,038 2,075 2,075 - 0.00% 5130 Repairs, equipment 3,513 3,546 3,840 4,098 4,240 142 3.47% Subtotal 15,186 16,729 15,540 16,738 17,110 372 2.22% Total Financial Services 232,688 238,674 237,848 247,870 240,192 (7,678) -3.10% 2012 Budget Summary 34 Fund: 100 Department: 4150 Finance Account Description 2009 2010 2011 2012 Description 1230 Supplies, equitpment 350 350 300 300 Furniture or equipment under the $1,000 capitalization threshold 350 350 300 300 1600 Supplies, operating 100 100 75 75 Misc supplies - planners, plaques, folders, files, etc. 100 100 75 75 2100 Books & periodicals 350 350 325 325 Misc computer & finance books & periodicals 350 350 325 325 3030 Other professional services 8,400 8,580 8,820 8,940 30% of audit 425 425 425 435 GFOA financial reporting fee 60 60 60 60 Safety deposit box rental 100 100 100 100 Ramsey County Special Assessment recap report 8,985 9,165 9,405 9,535 3430 Printing 400 400 350 350 Accts Payable & payroll checks & envelopes 400 400 350 350 Invoices, receipts, & bank deposit slips 800 800 700 700 3610 Memberships 190 190 200 210 Government Finance Officer's Association (GFOA) 120 120 120 120 Mn GFOA (2) 200 - - - AICPA Am. Institute of Certified Public Accountants 190 195 200 230 MNCPA Mn Society of Certified Public Accountants 700 505 520 560 3630 Training & conferences 105 90 75 75 Mn GFOA monthly meetings 550 - - - Mn GFOA annual seminar (postpone to 12)(13) 1,000 1,200 1,200 1,200 Seminars & training 1,800 - - - GFOA National conference (not annual)(postpone to 09)(11)(12)(13) 500 500 500 500 Accounting software training 300 300 300 300 Mileage 4,255 2,090 2,075 2,075 5130 Equipment repairs 3,623 3,846 4,038 4,240 40% accounting software support charges 3,623 3,846 4,038 4,240 7030 Equipment - - - - - - - - 19,163 17,206 17,438 17,810 12.03%-10.21%1.35%2.13% 35 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Central Services (100 - 4160): Personnel services 0100 Salaries, regular - 179 - - - - #DIV/0! Total personnel services - 179 - - - - #DIV/0! Materials & supplies 1110 Stationery 1,719 464 778 1,400 1,300 (100) -7.14% 1120 Copy materials 1,451 1,650 1,681 2,000 2,000 - 0.00% 1230 Supplies, equipment 751 1,045 971 700 800 100 14.29% 1600 Supplies, operating 15,338 15,024 13,734 15,900 15,900 - 0.00% 2100 Books & periodicals 239 259 858 375 405 30 8.00% Total materials & supplies 19,498 18,442 18,022 20,375 20,405 30 0.15% Contractual services 3010 General legal 57,805 38,989 46,365 48,600 48,600 - 0.00% 3030 Other professional services 15,541 5,622 8,883 9,600 9,800 200 2.08% 3100 Telephone 8,764 7,638 6,798 8,400 7,200 (1,200) -14.29% 3300 Postage 9,104 10,397 6,082 11,800 11,800 - 0.00% 3410 Legal notices 2,108 2,250 1,302 2,800 2,700 (100) -3.57% 3420 Advertising 8,530 2,034 1,714 3,800 3,800 - 0.00% 3430 Printing 6,956 4,200 4,278 9,500 8,100 (1,400) -14.74% 3610 Memberships 9,961 9,965 10,375 10,404 10,698 294 2.83% 3630 Training & conferences 138 143 647 1,000 1,000 - 0.00% 4010 Rental, equipment 5,293 283 723 810 810 - 0.00% 4800 Insurance & bonds 21,419 23,673 20,321 22,000 22,000 - 0.00% 5100 Repairs, computers 52,245 62,545 63,396 65,934 70,438 4,504 6.83% 5130 Repairs, equipment 628 838 723 900 900 - 0.00% Total contractual services 198,492 168,577 171,607 195,548 197,846 2,298 1.18% Capital outlays 7030 Equipment 24,651 6,617 7,416 23,000 - (23,000) -100.00% Total capital outlays 24,651 6,617 7,416 23,000 - (23,000) -100.00% Total central services 242,641 193,815 197,045 238,923 218,251 (20,672) -8.65% 2012 Budget Summary 36 Fund: 100 Department: 4160 Central Services Account Description 2009 2010 2011 2012 Description 1110 Stationery 945 1,500 1,400 1,300 Envelopes, labels, letterhead, etc. 945 1,500 1,400 1,300 1120 Copy materials 2,500 2,000 2,000 2,000 Copy paper 2,500 2,000 2,000 2,000 1230 Supplies, equitpment 700 700 700 800 Computer equipment under the $1,000 capitalization threshold 700 700 700 800 1600 Supplies, operating 15,400 15,400 15,400 15,400 Toner, rug service, paper, pens, staples, desk supplies, etc. 500 500 500 500 Misc operating supplies 15,900 15,900 15,900 15,900 2100 Books & periodicals 200 150 105 105 Employment handbooks/publications 255 260 270 300 Pioneer Press - $150/Star Tribune - $150 455 410 375 405 3010 General legal 30,000 27,600 27,600 27,600 Retainer for legal services 21,000 21,000 21,000 21,000 Legal fees outside scope of retainer. 51,000 48,600 48,600 48,600 3030 Other professional services 7,000 7,000 6,500 6,500 General labor assistance 1,050 1,050 1,200 1,400 Section 125 (Tax Saver flex spending) & COBRA administration 1,400 - - - Newsletter preparation $350 per issue 900 900 900 900 Human resources items 1,000 1,000 1,000 1,000 Web hosting/GovOffice 11,350 9,950 9,600 9,800 3100 Telephone 11,000 8,400 8,400 7,200 Basic telephone plus long distance 11,000 8,400 8,400 7,200 3300 Postage 3,600 - - - 4 newsletters-50% cost here, 50% in YMCA. 300 300 300 300 Courier charges (delivery services) 12,000 12,000 11,500 11,500 General postage includes PW mailings for street projects. 15,900 12,300 11,800 11,800 3410 Legal notices 1,000 1,000 1,000 900 Truth in taxation notices and Ramsey County fees. 2,500 2,000 1,800 1,800 Legal notices. 3,500 3,000 2,800 2,700 3420 Advertising 5,000 4,000 3,800 3,800 Job opening advertisements for vacant positions 5,000 4,000 3,800 3,800 3430 Printing 6,000 6,000 8,000 6,600 4 newsletter-50% cost here, 50% in YMCA. 1,000 1,000 750 750 Miscellaneous printing 1,000 1,000 750 750 City guides, directories & miscellaneous 8,000 8,000 9,500 8,100 3610 Memberships 517 605 605 605 Ramsey County League of Local Governments (RCLLG) 9,799 9,799 9,799 10,093 League of Mn Cities 10,316 10,404 10,404 10,698 3630 Training & conferences 1,000 1,000 800 800 League training & seminars 400 400 200 200 Information technology training 1,400 1,400 1,000 1,000 4010 Rental, equipment - - - - Administration copier rental fee and maintenance 150 150 150 150 Misc 600 600 660 660 Postage machine scale rental 750 750 810 810 4800 Bonding & insurance 18,000 19,000 19,000 19,000 Insurance policy premiums 3,000 3,000 3,000 3,000 Allowance for insurance policy deductibles 21,000 22,000 22,000 22,000 5100 Repairs, computer 55,000 55,000 55,000 58,500 Computer network & technology assistance - City of Roseville 2,885 3,000 3,800 3,990 Copier maintenance + overages (3 yr locked agreement thru March 2011) 1,700 1,868 2,134 2,198 Laserfiche annual maintenance 3,000 3,000 5,000 5,750 Computer, printer, and networks repairs. 62,585 62,868 65,934 70,438 5130 Repairs, equipment 900 900 900 900 Postage meter, copy machine, fax, misc. 900 900 900 900 7030 Capital, equipment 11,000 11,000 9,000 - Replace 11 pc's @ $800, 5 yr. Replacement cycle on 53 city pc's 4,500 4,500 4,500 - Software licenses (Autocad, MS Office, Windows) 9,500 9,500 9,500 - Network hardware (switches, routers, hubs, ups, servers) 25,000 25,000 23,000 - 248,201 238,082 238,923 218,251 5.10%-4.08%0.35%-8.65% 37 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Community Development (100 - 4180): Personnel services 0100 Salaries, regular 322,876 319,530 314,562 315,168 213,197 (101,971) -32.35% 0110 Overtime, regular - - - 1,022 1,087 65 6.36% 0150 Salaries, part time 8,752 6,539 7,806 18,567 18,989 422 2.27% 0300 Social Security 17,296 16,560 16,447 25,610 17,845 (7,765) -30.32% 0321 PERA 29,016 30,765 30,339 23,623 16,250 (7,373) -31.21% 0400 Group insurance 42,261 50,913 51,915 54,229 43,274 (10,955) -20.20% 0500 Workers comp 1,173 1,315 1,574 1,897 1,336 (561) -29.57% 0600 Unemployment 820 - - - 7,605 7,605 0.00% 0990 Severence - - - - - - 0.00% Total personnel services 422,194 425,622 422,643 440,116 319,583 (120,533) -27.39% Materials & supplies 1230 Supplies, equipment 671 734 24 500 475 (25) -5.00% 1600 Supplies, operating - 136 70 400 375 (25) -6.25% 1700 Motor, fuels & lubricants - - - - 3,600 3,600 0.00% 2100 Books & periodicals 604 98 59 560 455 (105) -18.75% 2400 Uniforms 87 143 - 200 175 (25) -12.50% Total materials & supplies 1,362 1,111 153 1,660 5,080 3,420 206.02% Contractual services 3030 Other professional 11,212 9,517 6,941 13,550 13,686 136 1.00% 3040 Consultants, special projects 14,626 (3,110) - - - - 0.00% 3040 Consultants, development rev 1,171 - 1,795 4,000 4,000 - 0.00% 3040 Consultants, plan review 3,102 - - - - - 0.00% 3100 Telephone 521 1,056 1,001 1,100 900 (200) -18.18% 3430 Printing 1,341 1,055 1,228 1,500 1,400 (100) -6.67% 3610 Memberships 730 1,170 855 1,005 805 (200) -19.90% 3630 Training and conferences 3,200 1,451 1,104 800 900 100 12.50% 3800 Mileage 61 174 57 100 100 - 0.00% Total contractual services 35,964 11,313 12,981 22,055 21,791 (264) -1.20% Capital outlays 7030 Equipment - 1,066 - - - - 0.00% 7040 Vehicle - - - - - - 0.00% Total capital outlays - 1,066 - - - - 0.00% Total Community Development 459,520 439,112 435,777 463,831 346,454 (117,377) -25.31% 2012 Budget Summary 38 Fund: 100 Department: 4180 Community Development Account Description 2009 2010 2011 2012 Description 1230 Supplies, equipment 875 700 500 475 Miscellaneous equipment & computer peripherals 875 700 500 475 1600 Supplies, operating 500 250 200 175 Presentation supplies 500 250 200 200 Office supplies 1,000 500 400 375 1700 Motor fuels & lubs - - - 3,600 Unleaded fuel: 900 gallons @ $4.00 (Gas for Comm Devlopment) - - - 3,600 2100 Books & periodicals 100 90 90 - Zoning Practice Newsletter 250 200 100 100 Reference materials 130 - 70 80 Planning Commission Journal 600 600 100 100 Intl. Code Council Manuals and Code Updates 200 200 200 175 Manuals, pamphlets, etc. 1,280 1,090 560 455 2400 Uniforms 300 300 200 175 Clothing for inspections staff 300 300 200 175 3030 Other professional 1,300 1,400 1,300 1,300 Ramsey County JPA (geographic information system) 3,500 3,875 3,900 3,900 Permit Works system annual software support (includes busi. lic. mod) - 1,725 1,750 1,750 Business License Module (one time fee)(annual maintenance $375) 800 800 500 500 Filing fees (Ramsey County increased fees from $29 to $48) 2,500 1,575 1,600 1,736 Comcate code enforcement license 1,500 1,000 500 500 GIS assistance 4,000 4,000 4,000 4,000 Abatements of nuisance properties 2,500 - - - Permit works interface with INCODE 16,100 14,375 13,550 13,686 3040-012 Consulting - Development 1,000 1,000 1,000 1,000 Environmental reviews Review (reimbursable)1,000 1,000 1,000 1,000 City attorney services 1,500 1,500 1,000 1,000 Development case reviews 1,500 1,500 1,000 1,000 Engineering services 5,000 5,000 4,000 4,000 3100 Telephone 500 500 500 500 Nextel Cell Accounts (2) for inspectors 600 600 600 400 Sprint network card for code enforcement 1,100 1,100 1,100 900 3430 Printing 1,500 1,500 1,500 1,400 Forms, flyers, etc. 1,000 1,000 - - Comprehensive plan drafts 2,500 2,500 1,500 1,400 3610 Memberships 500 550 500 300 American Planning Association (APA) - National & state (1) 150 - - - Sensible Land Use Coalition 110 110 120 120 Assoc. of MN Building Officials 60 60 60 60 Fire Marshal's Assoc. of MN 110 120 120 120 International Code Council (ICC) 60 60 60 60 10K Lakes Chapter of ICC 60 60 60 60 MN Assoc. Housing Code Officials 80 85 85 85 MN Building Permit Technicians Association 1,130 1,045 1,005 805 3630 Training & conferences 600 500 300 300 APA state conference (one attendee) 750 - - - ArcView 9.0 training 700 700 - - ICC code development hearings (out of state) 300 300 200 300 Other software training 600 500 300 300 Other staff training & seminars - - - - League of MN Cities conference 600 - - - APA National conference (2009)(Minneapolis) 3,550 2,000 800 900 3800 Mileage 100 100 100 100 Misc. use of personal automobiles 100 100 100 100 7030 Equipment - - - - Computer work station for temp inspector for Medtronic project 1,300 - - - Laptop for code enforcement 2,000 - - - FDM (Fire department user license software)($2,000 one time) 3,300 - - - 36,235 28,710 23,715 26,871 8.08%-20.77%-17.40%13.31% 39 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Police (100 - 4200): Personnel services: 0100 Salaries, regular 1,424,596 1,469,882 1,401,178 1,425,204 1,462,482 37,278 2.62% 0110 Overtime 33,177 50,022 53,990 49,379 46,659 (2,720) -5.51% 0112 K9 Overtime - - - - 6,273 6,273 0.00% 0150 Salaries, part-time 14,490 11,492 5,971 13,914 15,765 1,851 13.30% 0300 Social Security 22,122 22,338 20,506 25,239 26,027 788 3.12% 0321 PERA 181,254 201,575 188,773 206,233 212,106 5,873 2.85% 0400 Group insurance 166,822 183,002 177,468 207,272 221,792 14,520 7.01% 0500 Workers compensation 36,538 44,474 46,445 44,453 44,787 334 0.75% 0600 Unemployment - 447 1,149 - - - 0.00% 0990 Severence - - - - - - 0.00% Total personnel services 1,878,999 1,983,232 1,895,480 1,971,694 2,035,891 64,197 3.26% Materials & Supplies 1210 Supplies, buildings & grounds - 400 400 800 800 - 0.00% 1230 Supplies, equipment 224 3,041 115 2,000 2,000 - 0.00% 1600 Supplies, operating 4,356 6,618 5,953 5,500 6,000 500 9.09% 1700 Motor, fuels & lubricants 42,619 33,570 41,312 42,250 53,500 11,250 26.63% 2100 Books & periodicals 564 233 578 900 900 - 0.00% 2400 Uniforms & clothing 17,385 18,932 15,543 19,040 19,760 720 3.78% Total materials & supplies 65,148 62,794 63,901 70,490 82,960 12,470 17.69% Contractual services 3010 General Legal - 560 1,552 - - - 0.00% 3020 Legal, prosecuting attorney 51,047 46,750 56,459 53,580 53,580 - 0.00% 3030 Other professional services 1,077 7,033 2,210 3,990 3,490 (500) -12.53% 3050 Dispatching 55,755 55,755 54,432 77,144 90,189 13,045 16.91% 3055 Information systems fees 2,540 2,040 2,540 2,616 2,616 - 0.00% 3070 COPS events 266 273 - 800 500 (300) -37.50% 3080 Veternarian services 2,900 2,525 3,175 6,000 6,000 - 0.00% 3100 Telephone 1,827 1,917 1,972 2,000 2,000 - 0.00% 3210 Electricity 248 270 251 320 320 - 0.00% 3430 Printing 773 701 675 800 800 - 0.00% 3610 Memberships 1,446 1,861 1,265 1,475 1,660 185 12.54% 3630 Training 11,201 11,950 9,441 11,110 16,110 5,000 45.00% 4010 Rental, equipment 2,255 - - - - - 0.00% 4800 Insurance & bonds 36,161 18,390 39,968 24,000 28,500 4,500 18.75% 5100 Technology maintenance 30,015 33,967 34,191 37,227 23,421 (13,806) -37.09% 5130 Maintenance, equipment 4,447 10,570 6,059 10,640 9,449 (1,191) -11.19% Total contractual services 201,958 194,562 214,190 231,702 238,635 6,933 2.99% Capital outlays 7030 Equipment 13,027 8,134 5,579 1,200 16,500 15,300 1275.00% 7040 Vehicles 76,777 28,105 - 29,000 - (29,000) -100.00% Total capital outlays 89,804 36,239 5,579 30,200 16,500 (13,700) -45.36% Total police 2,235,909 2,276,827 2,179,150 2,304,086 2,373,986 69,900 3.03% 2012 Budget Summary 40 Fund: 100 Department: 4200 Police Account Description 2009 2010 2011 2012 Description 1210 Supplies, bldgs & grounds 900 800 800 800 Carpet cleaning & misc maintenance items 900 800 800 800 1230 Supplies, equipment 2,500 2,000 2,000 2,000 Miscellaneous office equipment 2,500 2,000 2,000 2,000 1600 Supplies, operating 3,750 3,750 3,750 3,750 Photo print supplies, fire extinguishers, gloves, inkjet cartridges, toner, etc. - - - 500 K9 Food 1,750 1,750 1,750 1,750 Batteries, breathalyzer parts, DVD's & CD's, disinfectant, ammunition, crime scene tape, emergency blankets, etc. 5,500 5,500 5,500 6,000 1700 Motor, fuels, & lubs -50,063 42,250 42,250 52,000 Unleaded gas 13,000 gallons @ $4.00/gal. - - - 1,500 K9 take home car gas 50,063 42,250 42,250 53,500 2100 Books & periodicals 1,000 1,000 900 900 Traf. law, crim. law, HR, employ. law, school year books, & misc. books 1,000 1,000 900 900 2400 Uniforms & clothing 720 720 720 720 Chief 720 720 - 720 Deputy Chief 7,500 5,000 4,000 4,000 Initial officer set-ups replacing up to two retiring officers 12,240 12,240 12,240 12,240 17 officers @ $720 ($710 in 07, 08, 09, 10, 11) 1,080 1,080 1,080 1,080 Administrative assistant, Clerk-typist, Community Service Officer 1,500 1,500 1,000 1,000 Traffic vests, Taser holsters, & misc items 23,760 21,260 19,040 19,760 3020 Legal, prosecuting attorney 52,530 52,530 53,580 53,580 Retainer ($4,337.50 per month)(misc charges $1,530) 52,530 52,530 53,580 53,580 3030 Other professional services 600 600 600 600 Tobacco compliance project 500 500 150 150 Hazardous material disposal fee 2,400 2,200 1,500 1,500 Lab fees, blood tests, physical tests, video, misc. 240 240 240 240 Automated Pawn service 3,150 1,500 1,500 1,000 Civil Service and medical testing for new officers 2,500 - - - Transcription service (for large case files) 9,390 5,040 3,990 3,490 3050 Dispatching 55,755 65,319 77,144 90,189 Ramsey County dispatching 55,755 65,319 77,144 90,189 3055 Informational systems fees 2,101 2,101 2,101 2,101 State service fee - CJDN ($510 per quarter in 07, 08, 09,10,11) 120 - - - Dedicated CAD Line per St.Paul Records Mgt. System requirement 515 515 515 515 IACP.net ($500 annual in 06, 07, 08, 09,10,11) 2,736 2,616 2,616 2,616 3070 COPS events 1,200 1,200 800 500 National night out, town hall meeting, child ID, stickers 1,200 1,200 800 500 3080 Veterinarian services 3,605 3,750 6,000 5,000 Brighton Vet Clinic - - - 1,000 K9 vet services 3,605 3,750 6,000 6,000 3100 Telephone 3,000 2,000 2,000 2,000 Nextel cell phones (10 phones) 3,000 2,000 2,000 2,000 3210 Electricity 360 360 320 320 Civil defense siren's electricity 360 360 320 320 41 THIS PAGE LEFT BLANK INTENTIONALLY 42 Fund: 100 Department: 4200 Police Account Description 2009 2010 2011 2012 Description 3430 Printing 1,200 1,200 800 800 Dept manual, Emergency management manual, business cards, 1,200 1,200 800 800 3610 Memberships 100 100 100 100 Assoc. Metro Emergency Managers 100 - - - American Assoc. of Police Polygraphers 35 35 50 100 FBI/LEEDA Law Enfor. Execu. Devel. Assoc. 2@ $50 - 60 60 60 Tri-County Investigator Association 45 45 45 45 Mn Crime Prevention Association 35 35 35 35 Mn DARE Officers Association 30 30 30 100 MN Emergency Managers Assoc. 200 200 200 200 Mn Police chiefs 129 129 129 129 IACP (International Association of Chief of Police) 36 36 36 36 MN Sex Crime Investigators Assoc. 30 30 30 30 Natl. Assoc. School Resource Officers 35 35 35 - National DARE Officers Association - - - K9 memberships 40 40 40 140 Notary commission (3 year due in 2012)($120+$20) 630 630 630 630 POST license reimbursement 7 @ $90 30 30 30 30 Prof. Law Enforcement Admin. Assoc. 25 25 25 25 National Association of Town Watch 1,500 1,460 1,475 1,660 3630 Training 900 900 900 900 MN Chief's conference - Chief & Dep Chief @ $450 200 200 200 200 BCA/CJDN training 320 320 320 320 Intox certification 1,000 1,000 1,000 1,000 Range Rental 750 750 - - Juvenal Officer conference 300 300 300 300 Emergency Management Conference 500 - 400 400 MN Sex Crimes Investigators Assoc Conference 4,000 4,000 3,000 3,000 Tuition reimbursement 1,200 1,200 1,200 1,200 Supervisor training - - - 5,000 K9 training 600 600 600 600 Emergency Management training 2,100 3,100 2,000 2,000 Employee development courses 2,670 1,190 1,190 1,190 Post training for officers at Century College (2 officers) 14,540 13,560 11,110 16,110 4800 Insurance & bonds 17,000 18,000 18,500 18,500 Liability and automotive insurance 4,500 5,000 5,500 10,000 Allowance for insurance policy deductibles 21,500 23,000 24,000 28,500 5100 Technology - maintenance 2,000 2,000 2,000 2,000 Miscellaneous repairs agreements & support 1,200 1,200 1,200 1,200 Copier maintenance + overages (3 yr locked agreement thru March 2011) 32,407 32,407 34,027 20,221 Operating costs of police records management system 35,607 35,607 37,227 23,421 5130 Maintenance, equipment 1,900 1,900 2,500 2,500 Misc. equipment repair - defibs, cameras, recorders, fax, printers. 450 450 450 450 Fire extinguisher recharging 1,500 1,500 1,500 1,500 Squad mobil digital computer repairs 500 500 500 500 Civil Defense siren repair & maint. (all 3 have been replaced 06,07,08) 1,500 2,000 2,500 2,500 Radio repair 3,190 3,190 3,190 1,999 800 MHZ radio licenses fees 37@ 4.48 per month 9,040 9,540 10,640 9,449 7030 Equipment 8,000 8,000 - - 2 replacement squad mobile computers (move to vehicle & equip fund) 2,500 2,500 - - Light bar & Siren (moved to vehicle & equip fund) - - - 2,200 Digital cameras (7) - - - 800 Digital recorder (9) - - - 13,500 K9 ($7,500) and equipment ($800+$2,000+$1,500+$900+$800) 1,100 1,100 1,200 - (1) Taser - - - - (1) Radar (moved to vehicle & equip fund) 11,600 11,600 1,200 16,500 7040 Vehicles - Patrol 58,000 29,000 29,000 - One squad $23,000 + set-up $6000 58,000 29,000 29,000 - 365,286 330,592 332,392 338,095 1.22%-9.50%0.54%1.72% 43 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Fire (100 - 4210): Personnel services 0100 Salaries, regular - - - - 20,518 20,518 0.00% 0300 Social Security - - - - 1,570 1,570 0.00% 0321 PERA - - - - 1,488 1,488 0.00% 0400 Group insurance - - - - 3,578 3,578 0.00% 0500 Workers compensation - - - - 108 108 0.00% Total personnel services - - - - 27,262 27,262 0.00% Contractual services 3032 Contractual fire services 276,197 279,336 278,750 270,573 282,761 12,188 4.50% 3050 Dispatching 3,452 3,640 3,866 4,000 4,270 270 6.75% Total contractual services 279,649 282,976 282,616 274,573 287,031 12,458 4.54% Capital outlays: 7040 Vehicles & equipment 13,048 35,789 49,452 22,894 11,340 (11,554) -50.47% Total capital outlays 13,048 35,789 49,452 22,894 11,340 (11,554) -50.47% Debt Service: 8010 Interest - - - - 39,975 39,975 0.00% 8020 Principal - - - - 97,524 97,524 0.00% Total debt service - - - - 137,499 137,499 - Total Fire 292,697 318,765 332,068 297,467 463,132 138,403 46.53% 2012 Budget Summary 44 Fund: 100 Department: 4210 Fire Account Description 2009 2010 2011 2012 Description 3032 Contractual fire services 290,201 278,750 270,573 282,761 Share of joint fire dept. op. costs (10 - 15.216%,11 - 14.77%,12 - 15.12%) 290,201 278,750 270,573 282,761 3050 Dispatching 4,000 4,000 4,000 4,270 Anoka County dispatching fee 4,000 4,000 4,000 4,270 7040 Capital, vehicles & equipment 35,789 46,452 22,894 11,340 Share of joint fire department's capital costs 35,789 46,452 22,894 11,340 8010 Interest - 2005 Fire bond - - - 52,164 15.12% of interest payment on 2005 Fire bonds Interest - 2011 Equip Certs - - - 44,604 15.12% of interest payment on 2011 Equipment Certificates 8020 Principal - 2005 Fire bond - - - 37,106 15.12% of principal payment on 2005 Fire bonds Principal - 2011 Equip Certs - - - 4,120 15.12% of principal payment on 2011 Equipment Certificates - - - 137,994 329,990 329,202 297,467 436,365 12.53%-0.24%-9.64%46.69% 45 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Recreation (100 - 4350): Contractual services: 3036 Contractual recreation 134,951 107,201 100,805 107,900 105,500 (2,400) -2.22% 4800 Bonding & insurance 1,392 1,446 1,303 1,700 1,700 - 0.00% Total contractual services 136,343 108,647 102,108 109,600 107,200 (2,400) -2.19% Capital outlays 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total Recreation 136,343 108,647 102,108 109,600 107,200 (2,400) -2.19% 2012 Budget Summary 46 Fund: 100 Department: 4350 Recreation Account Description 2009 2010 2011 2012 Description 3036 Contractual recreation 97,500 95,400 97,400 95,000 Management of recreation & park programs by YMCA 8,400 10,500 10,500 10,500 Ice Skating supervision 18,000 18,000 - - Playground supervision 123,900 123,900 107,900 105,500 4800 Bonding & insurance 1,700 1,700 1,700 1,700 Insurance & bonding cost. 1,700 1,700 1,700 1,700 125,600 125,600 109,600 107,200 2.36%0.00%-12.74%-2.19% 47 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent 2012 Budget Summary Parks (100 - 4360): Personnel services 0100 Salaries, regular 115,771 118,198 117,118 115,044 117,345 2,301 2.00% 0110 Overtime, regular 5,467 5,749 4,275 4,333 4,419 86 1.98% 0150 Salaries, part-time 48,297 47,152 35,379 36,000 36,000 - 0.00% 0300 Social Security 12,237 11,980 11,237 11,886 12,070 184 1.55% 0321 PERA 9,133 9,635 9,554 8,655 8,827 172 1.99% 0400 Group insurance 17,222 20,335 19,063 20,816 22,016 1,200 5.76% 0500 Workers compensation 3,885 4,537 4,956 5,217 5,196 (21) -0.40% 0600 Unemployment - - - - - - 0.00% Total personnel services 212,012 217,586 201,582 201,951 205,873 3,922 1.94% Materials & supplies: 1210 Supplies, bldgs & grnds 15,508 12,927 10,757 11,460 13,160 1,700 14.83% 1220 Supplies, vehicles 5,069 8,455 11,015 4,800 8,000 3,200 66.67% 1230 Supplies, equipment 2,136 1,285 1,930 1,950 3,750 1,800 92.31% 1600 Supplies, operating 6,689 5,788 9,399 6,000 6,500 500 8.33% 1700 Motor fuels & lubs 8,681 5,452 9,388 9,225 11,250 2,025 21.95% 2400 Uniforms & clothing 1,113 1,711 965 2,030 975 (1,055) -51.97% 2410 Mats & towels 1,137 1,436 1,307 800 850 50 6.25% Total materials & supplies 40,333 37,054 44,761 36,265 44,485 8,220 22.67% Contractual services: 3030 Other professional services 182 526 125 2,380 3,650 1,270 53.36% 3100 Telephone 3,748 2,603 1,535 1,500 1,490 (10) -0.67% 3200 Water & sewer 4,808 3,998 8,103 6,000 6,000 - 0.00% 3210 Electricity 6,921 5,670 5,423 6,500 6,000 (500) -7.69% 3220 Natural gas 5,797 4,880 4,145 5,000 4,800 (200) -4.00% 3530 Refuse collection - - 662 - - - 0.00% 3610 Memberships - 63 64 65 260 195 300.00% 3630 Training & conferences 198 1,878 919 1,845 1,460 (385) -20.87% 3900 Grants & subsidies 10,608 10,608 10,608 10,608 10,608 - 0.00% 4010 Rental, equipment - - 41 200 500 300 150.00% 4030 Portable restrooms 5,703 5,753 4,212 6,150 3,000 (3,150) -51.22% 4800 Bonding & insurance 13,922 14,458 12,602 15,000 16,000 1,000 6.67% 5110 Repairs, bldg & grounds 6,003 5,311 2,007 4,000 3,500 (500) -12.50% Total contractual services 57,890 55,748 50,446 59,248 57,268 (1,980) -3.34% Capital outlays 7030 Equipment - - - 66,000 - (66,000) -100.00% 7050 Construction 5,845 - - - - - Total capital outlays 5,845 - - 66,000 - (66,000) -100.00% Total Parks 316,080 310,388 296,789 363,464 307,626 (55,838) -15.36% 48 Fund: 100 Department: 4360 Parks Account Description 2009 2010 2011 2012 Description 1210 Supplies, bldgs & grounds 200 200 200 200 Replace bleacher parts 100 200 200 200 Repair hockey boards, gates 200 200 300 300 Sod 210 300 400 400 Janitorial supplies 210 210 150 150 Snow shovels 210 210 210 210 Ice melt 400 400 600 500 Round up 720 500 700 - Repair fences, nets 800 500 500 500 Perennial flowers for park signs 720 700 700 - Replace play equipment parts - - - 1,500 Damaged building components (windows, locks, etc.) - - - 100 Graffiti remover 4,500 5,000 2,500 4,100 Broadleaf control 600 500 500 500 Goose repellent 2,165 2,000 2,000 2,000 Replace irrigation heads 2,300 2,500 2,500 2,500 Seed, fertilizer 13,335 13,420 11,460 13,160 1220 Supplies, vehicles 4,325 4,300 4,300 6,500 Oil filters, mower blades, tires, vehicle registration fees, 500 500 500 1,500 Miscellaneous repairs 4,825 4,800 4,800 8,000 1230 Supplies, equipment 450 250 250 250 Drinking fountain parts - - - 250 Field Lights 464 450 450 250 Park signage - 250 250 500 Magnetic bases, jox boxes, etc. (jox box CHP 2014)(2 in Silverview) 1,200 1,250 1,000 2,500 Replace park equipment, fixtures and misc parts 2,114 2,200 1,950 3,750 1600 Supplies, operating 1,000 1,000 800 800 Sand/fiber fill for play lots & courts 100 100 200 200 Tri mix 600 600 800 800 Wood chips for trees 900 900 500 500 Ag-lime for fields 500 500 500 500 Surface drying compound 400 400 400 400 Nets 1,400 1,400 1,400 2,500 Field paint & chalk 800 1,000 - - Jox box (Silverview (2), CH park (1) in 2014) 1,200 1,200 800 800 Landscaping materials 1,100 1,100 600 - Percentage of shop costs 8,000 8,200 6,000 6,500 1700 Motor fuels & lubes 7,500 6,500 5,850 7,200 1,800 gallons of unleaded gas @ $4.00 4,250 3,750 3,375 4,050 900 gallons of diesel fuel @ $4.50 11,750 10,250 9,225 11,250 2400 Uniforms & clothing 434 434 434 175 Clothing allowance 1.0 FTE 1,596 1,596 1,596 600 Uniforms 10% of $6,000 - - - 200 Safety glasses, masks, ear protection, etc. 2,030 2,030 2,030 975 2410 Mats & towels 800 800 800 850 Share of floor mats and shop towels 10% of $8,500 800 800 800 850 3030 Other professional services 155 155 155 240 Fire extinguisher inspection/maint. (2@ $120) - - - 450 HVAC maintenance - - - 840 Fire sprinkler testing (4@ $210) - - 225 120 Backflow prevention testing (2@ $60) 2,000 2,000 2,000 2,000 Tree trimming 2,155 2,155 2,380 3,650 49 THIS PAGE LEFT BLANK INTENTIONALLY 50 Fund: 100 Department: 4360 Parks (continued) Account Description 2009 2010 2011 2012 Description 3100 Telephone 1,200 1,200 1,200 1,490 Cellular phones (17.5% of $8,500) 100 - - - Replace telephones in park buildings 2,200 300 300 - Security at Silver View (phones removed from park buildings) 3,500 1,500 1,500 1,490 3200 Water & wastewater 7,500 7,500 6,000 6,000 Parkland irrigation & park bathrooms 7,500 7,500 6,000 6,000 3210 Electricity 6,469 6,500 6,500 6,000 Est. 5 park buildings, park sec. lighting, court & field lighting & misc. 6,469 6,500 6,500 6,000 3220 Natural gas 4,978 5,000 5,000 4,800 Heating cost for Random, Hillview, Groveland, & Lambert Park bldgs. 4,978 5,000 5,000 4,800 3610 Memberships - - - - MN Recreation & Park Assoc 65 65 65 40 Minnesota Safety Council - - - 50 Playground inspector license - - - 20 Pesticide license renewal - - - 50 State low voltage electrical licenses - - 100 100 Tree inspector license 65 65 165 260 3630 Training & conferences 40 40 40 - Chemical applicator license 250 75 75 75 Computer classes 500 - - - Tuition reimbursement 200 200 200 - Confined space training 120 120 120 100 Hearing tests/RTN training (2@$50) 370 370 370 250 Low voltage/power limited training 60 60 60 60 Maintenance EXPO 110 110 110 110 Loss control workshops - - - 570 Playground inspection training - - - 210 Equipment training (skidsteer & boom)(10% of $2,050) 200 - - - Minn Toro Industries school 200 200 200 - Pesticide application class (every 3 years) 20 20 20 - Pesticide license renewal (every 3 years) 100 100 100 - State low voltage electrical licenses (2) 450 450 450 - Sewer, Water & traffic certificates - - - 85 Tree inspector trainig 60 60 - - Work zone traffic control 2,680 1,805 1,745 1,460 3900 Grants & subsidies 10,608 10,608 10,608 10,608 Lakeside Park share of operating costs 10,608 10,608 10,608 10,608 4010 Rental, equipment 200 200 200 500 Tools and equipment (add rental of sod cutter 2012) 200 200 200 500 4030 Portable restrooms 6,300 6,300 6,150 3,000 For May thru Oct, plus special events such as tournaments, & extra cleanings and insurance 6,300 6,300 6,150 3,000 4800 Bonding & insurance 14,000 12,000 12,000 12,000 Insurance policy premiums 3,000 3,000 3,000 4,000 Allowance for insurance policy deductibles 17,000 15,000 15,000 16,000 5110 Repairs, bldgs & grounds 720 500 1,000 500 Windows, doors, & lock repairs 515 500 1,000 - Replace locks 515 500 500 500 Field light repairs 515 500 1,500 2,500 Repairs to furnaces, plumbing, phones, electrical, etc 2,265 2,000 4,000 3,500 7030 Capital, equipment - - - - Mower replacement 16ft deck mower (vehicle & equip. fund) - - - - Air compressor (1/2 parks 1/2 pavement mgt.)(moved to Vehicle fund) - - 24,000 - Chipper 32,000 - 36,000 - Replace #404 F250 (Move to 2014) - - 6,000 - Plow for unit #428 32,000 - 66,000 - 138,574 100,333 161,513 101,753 28.81%-27.60%60.98%-37.00% 51 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent 2012 Budget Summary Forestry (100 - 4380): Materials & supplies 1200 Supplies, landscaping 1,491 581 781 3,000 3,000 - 0.00% Total materials & supplies 1,491 581 781 3,000 3,000 - 0.00% Contractual services 3030 Professional services 18,510 25,097 11,365 24,000 24,000 - 0.00% 3033 Joint powers forester 25,452 19,659 - - - - 0.00% 3520 Tree removal 4,222 5,109 22,224 28,000 28,000 - 0.00% 3610 Memberships - - 15 - - - 0.00% 3630 Training & conferences - 50 - - - - Total contractual services 48,184 49,915 33,604 52,000 52,000 - 0.00% Capital outlays 7030 Equipment - - - - - - 0.00% Total Forestry 49,675 50,496 34,385 55,000 55,000 - 0.00% 52 Fund: 100 Department: 4380 Forestry Account Description 2009 2010 2011 2012 Description 1200 Supplies, landscaping 575 575 400 400 Landscaping materials 575 575 800 800 Small trees to replace damaged trees 3,100 3,100 1,800 1,800 Large trees - storm damage replacement 4,250 4,250 3,000 3,000 3030 Professional services 11,000 11,000 9,000 9,000 Boulevard tree trimming for 1/4 of city - - 15,000 15,000 Forestry consulting 2,000 2,000 - - Tree trimming around Silver View Park (moved to parks) 13,000 13,000 24,000 24,000 3033 Joint powers forester 28,058 16,000 - - Amount per joint powers agreement 28,058 16,000 - - 3520 Tree removal 26,000 28,000 28,000 28,000 Remove or treat diseased trees 26,000 28,000 28,000 28,000 3630 Training & memberships 200 200 - - Forestry licensing seminar 200 200 - - 71,508 61,450 55,000 55,000 1.16%-14.07%-10.50%0.00% 53 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Public Works Administration (100-4410): Personnel services: 0100 Salaries, regular 54,954 63,041 84,610 91,346 94,727 3,381 3.70% 0150 Salaries, part-time 71 80 - 728 754 26 3.57% 0300 Social Security 3,883 4,451 6,020 7,044 7,305 261 3.71% 0321 PERA 3,144 4,237 5,906 6,623 6,868 245 3.70% 0400 Group insurance 6,410 9,121 12,233 13,814 14,696 882 6.38% 0500 Workers compensation 987 1,306 1,377 1,097 1,138 41 3.74% Total personnel services 69,449 82,236 110,146 120,652 125,488 4,836 4.01% Materials & supplies: 1600 Operating supplies - 153 131 200 200 - 0.00% 2400 Uniforms & clothing - - 291 400 400 - 0.00% Total materials and supplies - 153 422 600 600 - 0.00% Contractual services: 3030 Other professional services 44,223 23,503 361 340 340 - 0.00% 3100 Telephone - - - - 720 720 0.00% 3610 Memberships 185 433 571 683 710 27 3.95% 3630 Training & conferences 100 469 167 1,140 995 (145) -12.72% 3800 Mileage reimbursement - - 88 300 300 - 0.00% Total contractual services 44,508 24,405 1,187 2,463 3,065 602 24.44% Capital outlays: 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total public works administration 113,957 106,794 111,755 123,715 129,153 5,438 4.40% 2012 Budget Summary 54 Fund: 100 Department: 4410 Public Works Adminstration Account Description 2009 2010 2011 2012 Description 1600 Operating Supplies 200 200 200 200 Office supplies 200 200 200 200 2400 Uniforms & clothing 400 400 400 400 33% of Supervisor's uniform cost. 400 400 400 400 3030 Other professional services 100 100 100 100 Physicals & drug testing - new employee - 700 - - EJCDC Construction document set 240 240 240 240 Drug & alcohol testing - federal mandate 340 1,040 340 340 3100 Telephone - - - 720 Cellphone 8.5% of $8,500 - - - 720 3610 Memberships/license fee 300 113 113 150 American Public Works Association memb. (APWA) (1/4 of $600) 50 60 60 60 City Engineer's Association of MN (CEAM) 40 40 40 40 NASASP (National Assoc. of State Agencies for Surplus Property) 275 275 275 30 MN Safety Council - 200 - 200 MN Board of AELSLAGID (PE Renewal even years) 195 195 195 230 American Society of Civil Engineers 860 883 683 710 3630 Training & conferences 600 600 600 600 CEAM / APWA conferences 125 50 50 50 Computer classes/Web training 100 100 100 - Confined space training 60 60 60 15 Hearing tests/RTN training (.34 FTE@$50) 30 30 30 30 Maintenance Expo 100 100 - - Pesticide applicator's class 10 10 - - Pesticide license renewal 600 200 200 200 Required continuing education seminars 200 100 100 100 Supervisor training 30 30 - - Work zone traffic control 1,855 1,280 1,140 995 3800 Mileage reimbursement 300 300 300 300 vehicle mileage reimbursement 300 300 300 300 7030 Capital, equipment - - - - - - - - 3,955 4,103 3,063 3,665 -20.02%3.74%-25.35%19.65% 55 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent 2012 Budget Summary Building & Grounds Maintenance (100 - 4460): Personnel services: 0100 Salaries, regular 11,816 11,676 11,776 11,575 11,807 232 2.00% 0110 Salaries, overtime 380 764 975 935 954 19 2.03% 0300 Social Security 837 813 833 957 976 19 1.99% 0321 PERA 784 839 883 907 925 18 1.98% 0400 Group insurance 2,111 2,564 2,694 2,602 2,752 150 5.76% 0500 Workers compensation 515 598 687 414 414 - 0.00% Total personnel services 16,443 17,254 17,848 17,390 17,828 438 2.52% Materials & supplies: 1210 Supplies, building & grounds 1,719 329 2,498 1,500 1,500 - 0.00% 1230 Supplies, equipment 1,458 928 237 690 690 - 0.00% 1600 Supplies, operating 3,464 3,767 4,355 5,400 4,800 (600) -11.11% 2400 Uniforms & clothing 81 - - 120 195 75 62.50% 2410 Mats & towels - - - - 210 210 0.00% Total materials & supplies 6,722 5,024 7,090 7,710 7,395 (315) -4.09% Contractual services: 3030 Other professional services 26,835 25,590 18,243 23,360 24,520 1,160 4.97% 3100 Telephone - - - - 130 130 0.00% 3200 Water & sewer 993 1,773 985 1,800 1,800 - 0.00% 3210 Electricity 23,584 24,238 24,452 25,000 25,000 - 0.00% 3220 Natural gas 26,233 22,474 18,098 26,612 20,000 (6,612) -24.85% 3530 Refuse collection 9,942 9,183 11,057 10,021 11,005 984 9.82% 4010 Rental, equipment 367 - - 205 205 - 0.00% 4800 Insurance 5,733 10,850 5,826 7,000 7,000 - 0.00% 5110 Repairs, bldgs & grounds 10,573 4,470 10,096 9,556 8,325 (1,231) -12.88% 5130 Repairs, equipment 10,725 11,583 6,081 5,200 5,000 (200) -3.85% Total contractual services 114,985 110,161 94,838 108,754 102,985 (5,769) -5.30% Capital outlays 7030 Equipment - - - - 1,750 1,750 0.00% Total capital outlays - - - - 1,750 1,750 0.00% Total buildings & grounds 138,150 132,439 119,776 133,854 129,958 (3,896) -2.91% 56 Fund: 100 Department: 4460 Building & Ground Maintenance Account Description 2009 2010 2011 2012 Description 1210 Supplies, bldgs & grounds 1,500 1,500 1,500 1,500 Bldg repairs, cleaning/heating supplies, batteries. 1,500 1,500 1,500 1,500 1230 Supplies, equipment 430 430 430 430 Air compressor parts, filters, hoses, etc. 300 - - - Barn fan (1) purchase another in 2009 260 260 260 260 Pressure washer repair parts, garage door motor 990 690 690 690 1600 Supplies, operating 300 300 300 500 Cleaning supplies 300 300 300 300 Lumber & fasteners 550 550 550 550 Repair items & hardware 300 300 300 300 First aid supplies 500 500 500 500 Light bulbs & ballasts 500 500 500 500 Paper supplies 500 500 500 500 Mechanical items, fans, motors, etc 750 750 250 250 Goose repellent 500 500 500 500 Weed control - city hall 400 400 400 200 Office supplies 100 100 - - Meeting refreshments 600 600 600 - Steel supplies 700 700 700 700 Paint & supplies - parking lot & building 6,000 6,000 5,400 4,800 2400 Uniforms & clothing 120 120 120 150 Uniforms (2.5% of $6,000) - - - 45 Clothing & boot allowance (.25 @$175) 120 120 120 195 2410 Mats & towels - - - 210 Share of floor mats and shop towels (2.5% of $8,500) - - - 210 3030 Other professional services 700 700 700 180 Backflow prevention testing (3@$60) 60 60 60 60 Boiler & pressure vessel registration program 2,500 2,500 2,500 3,250 HVAC maintenance (City Hall & PW facilities) - 100 100 100 MN DOL operating permit - elevator (previously in acct. 5110) 15,750 15,750 15,750 15,300 City Hall cleaning contract 3,000 3,000 3,000 3,500 Carpet cleaning, floor striping & waxing (2 times) 250 250 250 210 Fire monitoring service (City hall sprinkler system) - - - 1,320 Pest control (12@$110) 1,000 1,000 1,000 600 Fire extingiusher inspection/service (30@$20) 23,260 23,360 23,360 24,520 3100 Telephone - - - 130 Cellphone (1.5% of $8,500) - - - 130 3200 Water & Sewer 1,800 1,800 1,800 1,800 Service at City Hall and Public Works buildings 1,800 1,800 1,800 1,800 3210 Electricity 26,020 25,000 25,000 25,000 Electricity at City Hall and Public Works buildings 26,020 25,000 25,000 25,000 3220 Natural gas 26,612 26,612 26,612 20,000 Natural gas at City Hall and Public Works buildings 26,612 26,612 26,612 20,000 3530 Refuse collection 130 130 130 130 Lamps $100, batteries $30 260 260 260 264 Hazardous waste annual fee (State of MN PCA) - - - 230 Hazardous waste generator license fee (Ramsey County) 500 500 400 150 Used oil filters ($100 in vehicle maint.) 8,128 8,200 8,200 9,200 Facility dumpsters, city hall, public works 1,103 1,031 1,031 1,031 Hazardous waste disposal 10,121 10,121 10,021 11,005 4010 Rental, equipment 205 205 205 205 Misc. rentals 205 205 205 205 4800 Bonding & insurance 5,500 5,500 5,500 5,500 Insurance policy premiums 1,500 1,500 1,500 1,500 Allowance for insurance policy deductibles 7,000 7,000 7,000 7,000 5110 Repairs, bldgs & grounds 1,300 1,300 1,300 1,300 Door & gate opener repairs 2,100 2,100 2,100 2,100 Building repairs 456 456 456 575 Elevator maintenance 350 350 350 350 Fire sprinklers & alarm repairs 4,000 4,000 4,000 4,000 General building & ground maintenance 1,242 1,350 1,350 - Exterminator- City Hall and Public Works (in 3030) - - - - Fire extinguishers (in 3030) 9,448 9,556 9,556 8,325 5130 Repairs, equipment 515 515 - - Telephone repairs 2,500 5,000 5,000 5,000 HVAC, plumbing & electrical repairs 6,000 - - - HVAC safety improvements per LMCIT (one time upgrades to boiler) 200 200 200 - Multi-function office machine repair 1,400 1,400 - - Oil heater maintenance 10,615 7,115 5,200 5,000 7030 Capital, equipment 900 - - - Floor scrubber for shop (1 in 2008 and 2009) - - - 1,750 Walk behind broom (1/2 bldg. 1/2 MVCC) - - - - Replace City Hall entrance lights 900 - - 1,750 124,591 119,079 116,464 112,130 24.45%-4.42%-2.20%-3.72% 57 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent 2012 Budget Summary Vehicle & Equipment Maintenance (100 - 4465): Personnel services: 0100 Salaries, regular 29,492 30,277 30,241 30,039 30,640 601 2.00% 0110 Salaries, overtime - 72 141 505 516 11 2.18% 0300 Social Security 2,231 2,137 2,262 2,337 2,383 46 1.97% 0321 PERA 1,916 1,933 2,122 2,215 2,258 43 1.94% 0400 Group insurance 3,209 3,892 4,242 4,925 5,414 489 9.93% 0500 Workers compensation 1,258 1,462 1,729 1,008 1,009 1 0.10% Total personnel services 38,106 39,773 40,737 41,029 42,220 1,191 2.90% Materials & supplies: 1220 Supplies, vehicles 15,203 14,329 17,606 13,450 15,450 2,000 14.87% 1230 Supplies, equipment 1,123 1,929 3,157 2,600 2,600 - 0.00% 1600 Supplies, operating 3,730 1,995 2,920 3,875 3,550 (325) -8.39% 1700 Motor fuels & lubricants 7,959 4,729 5,071 4,935 2,010 (2,925) -59.27% 2400 Uniforms & clothing 485 1,871 577 900 465 (435) -48.33% 2410 Mats & towels 1,137 1,407 1,313 650 510 (140) -21.54% Total materials & supplies 29,637 26,260 30,644 26,410 24,585 (1,825) -6.91% Contractual services: 3100 Telephone 1,107 1,143 1,329 1,150 300 (850) -73.91% 3530 Refuse collection - - - 100 100 - 0.00% 3610 Memberships - 63 64 65 80 15 23.08% 3630 Training 881 48 456 1,005 605 (400) -39.80% 4010 Rental, equipment - - - 100 100 - 0.00% 5120 Repairs, vehicles 17,967 6,352 13,376 10,900 10,900 - 0.00% 5130 Repairs, equipment 5,041 11,189 2,954 5,500 5,500 - 0.00% Total contractual services 24,996 18,795 18,179 18,820 17,585 (1,235) -6.56% Capital outlays 7030 Equipment - - - - - - 0.00% 7050 Construction - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total vehicle & equipment maintenance 92,739 84,828 89,560 86,259 84,390 (1,869) -2.17% 58 Fund: 100 Department: 4465 Vehicle & Equipment Maintenance Account Description 2009 2010 2011 2012 Description 1220 Supplies, vehicles 200 200 200 200 Brake fluid 700 700 700 700 Misc parts, fastners 500 500 500 500 Anti freeze 300 300 300 300 Air conditioning gas 300 300 300 300 Headlamps, spots, & bulbs 800 800 800 800 Tune up items 400 400 400 400 Wiper blades & fluid 550 550 550 1,550 Minor repairs, rebuilds 900 900 900 1,100 Automotive parts 1,100 1,100 1,100 1,500 Filters: oil, air, fuel, transmission 1,300 1,300 1,300 1,300 Brake pads & shoes 6,400 6,400 6,400 6,800 Tires & batteries 13,450 13,450 13,450 15,450 1230 Supplies, equipment 200 200 200 200 Small equipment tune up items 500 500 400 400 Filters belts & hoses 1,100 1,100 1,000 1,000 Hydraulic system repairs 1,000 1,000 1,000 1,000 Tires - dump trucks, loader, & backhoe 2,800 2,800 2,600 2,600 1600 Supplies, operating 900 900 1,525 900 Specialty tools & hand tools 350 350 350 350 Welding supplies 100 100 100 100 Chains, clevises, & hitch pins 700 700 700 700 Equipment & vehicle cleaning supplies 200 200 200 500 Steel for repairs & fabrication 500 500 500 500 Solvents & degreasers 500 500 500 500 Fastners & electrical supplies 3,250 3,250 3,875 3,550 1700 Motor fuels & lubs 60 60 60 60 Gear lube 450 450 450 450 ATF - 7 cases 750 750 600 600 Aftermarket additives 900 900 900 900 Engine oil: 150 gallons @ $6 3,375 2,925 2,925 - Unleaded fuel: 900 gallons @ $4.00 (moved to Comm Dev) 5,535 5,085 4,935 2,010 2400 Uniforms & clothing 600 600 600 360 Uniforms 6% of $6,000) - - - 105 Clothing and boot allowance (.6@$175) 600 600 600 465 2410 Mats & towels 650 650 650 510 Share of floor mats and shop towels (6% of $8,500) 650 650 650 510 3100 Communications 1,000 1,000 1,150 300 Cellular telephone (3.5% of $8,500) 1,000 1,000 1,150 300 3530 Refuse collection - - 100 100 Oil filter recycling - - 100 100 3610 Memberships 60 60 60 60 Vehicle inspection license renewal (DOT required) 65 65 65 20 Minnesota Safety Council (6% of $465) 125 125 125 80 3630 Training 200 50 - - Computer classes 100 100 100 - Confined space training 200 200 - - Electronics updates, other classes 60 60 60 30 Hearing test/RTN training (.6@$50) - - - 120 Equipment operation training (Skidsteer & boom) 30 30 30 30 Maintenance Expo 200 50 200 200 Misc training 140 160 180 150 ASE certification 300 300 300 - Water/sewer license 75 75 75 75 Vehicle inspection recertification (DOT required) 30 30 - - Work zone traffice control 1,335 1,055 945 605 4010 Rental, equipment 100 100 100 100 Specialty tool & equipment rental and mileage reimbursement 100 100 100 100 5120 Repairs, vehicles 4,500 4,500 4,500 4,500 Accident repairs 400 400 400 400 Alignments 1,000 1,000 1,000 1,000 Glass replacement 400 400 400 400 Radiator repairs, replacement 700 700 500 500 Tire repairs 600 600 700 700 Ignition scanner software update - - 1,400 1,400 Mitchell On Demand Software 2,000 2,000 2,000 2,000 Transmission repairs 9,600 9,600 10,900 10,900 5130 Repairs, equipment 400 500 500 500 Accident repairs 2,000 3,000 3,000 3,000 Mechanical repairs 1,500 2,000 2,000 2,000 Motor repairs 3,900 5,500 5,500 5,500 7030 Capital, equipment - - - - - - - - 42,345 43,215 44,930 42,170 5.52%2.05%3.97%-6.14% 59 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent 2012 Budget Summary Street Pavement Management (100 - 4470): Personnel services: 0100 Salaries, regular 74,991 78,420 87,408 90,167 92,701 2,534 2.81% 0110 Salaries, overtime 266 1,737 2,471 2,888 2,946 58 2.01% 0150 Salaries, part-time 26,338 18,744 8,771 7,200 7,200 - 0.00% 0300 Social Security 7,641 7,360 7,290 7,670 7,868 198 2.58% 0321 PERA 4,671 5,387 6,262 6,746 6,934 188 2.79% 0400 Group insurance 8,424 11,003 13,513 13,590 14,802 1,212 8.92% 0500 Workers compensation 3,583 4,249 4,981 4,847 4,853 6 0.12% 0990 Severence pay - - - - 0.00% Total personnel services 125,914 126,900 130,696 133,108 137,304 4,196 3.15% Materials & supplies: 1230 Supplies, equipment 701 1,628 1,169 500 500 - 0.00% 1240 Supplies, streets 25,160 40,299 32,119 21,100 21,100 - 0.00% 1260 Supplies, traffic control 1,960 1,183 27 1,000 1,000 - 0.00% 1600 Supplies, operating 4,069 1,558 3,124 1,680 1,680 - 0.00% 1700 Motor fuels & lubricants 14,941 4,354 10,988 9,850 11,950 2,100 21.32% 2400 Uniforms & clothing 266 808 777 1,920 775 (1,145) -59.64% 2410 Mats & towels 1,137 1,427 1,014 700 850 150 21.43% Total materials & supplies 48,234 51,257 49,218 36,750 37,855 1,105 3.01% Contractual services: 3030 Other professional services 17,046 20,472 3,663 6,550 6,550 - 0.00% 3100 Telephone 1,383 1,127 1,375 1,200 890 (310) -25.83% 3160 Memberships - - - 113 210 97 85.84% 3630 Training & conferences 621 1,097 1,079 1,280 1,090 (190) -14.84% 4010 Rental, equipment 3,728 - 1,736 3,800 4,500 700 18.42% 4800 Insurance 5,077 10,599 4,752 6,200 6,200 - 0.00% 5130 Repairs, equipment - - 907 500 500 - 0.00% 5140 Repairs, streets - - - - - - 0.00% Total contractual supplies 27,855 33,295 13,512 19,643 19,940 297 1.51% Capital outlays 7030 Equipment 2,002 - - 191,000 1,500 (189,500) -99.21% Total capital outlays 2,002 - - 191,000 1,500 (189,500) -99.21% Total street pavement management 204,005 211,452 193,426 380,501 196,599 (183,902) -48.33% 60 Fund: 100 Department: 4470 Pavement Management Account Description 2009 2010 2011 2012 Description 1230 Supplies, equipment 500 500 500 500 Safety vest, hearing protection, safety protection - 450 - - Skid steer bucket (1/2 in snow & ice) 500 950 500 500 1240 Supplies, street repair 23,000 20,000 20,000 20,000 Asphalt & concrete for street patching & repair (winter mix $130 per ton) 500 500 500 500 Disposal ($10.00 per load X 50) - 600 600 600 Bituminous tack coat 23,500 21,100 21,100 21,100 1260 Supplies, traffic control 180 180 700 700 Traffic cones/baracades 300 300 300 300 portable signs (traffic control) 480 480 1,000 1,000 1600 Supplies, operating 380 380 380 380 Asphalt hand tools, rakes, etc. 1,235 1,235 1,300 1,300 Traffic marking paint - 500 - - 10' straight edge, IR temp gauge 1,615 2,115 1,680 1,680 1700 Motor fuels & lubs 6,375 5,625 5,625 6,750 Diesel fuel: 1500 gallons @ $4.50. 2,200 2,200 - - Propane: 1100 gallons @ $2 4,875 4,225 4,225 5,200 Unleaded fuel: 1300 gallons @ $4.00 13,450 12,050 9,850 11,950 2400 Uniforms & clothing 1,920 1,920 1,920 600 Uniforms (10% of $6,000) - - - 175 Clothing and boot allowance (1@$175) 1,920 1,920 1,920 775 2410 Mats & towels 700 700 700 850 Share of floor mats and shop towels (10% of $8,500) 700 700 700 850 3030 Other professional services 1,800 1,800 1,800 1,800 Pavement Mgmt software annual maintenance. 3,305 3,305 1,000 1,000 Engineering services. 250 250 250 250 Annual certification of weight scales 3,295 3,295 3,500 3,500 Striping of streets, crosswalks, & school crossings. (Ramsey County) 8,650 8,650 6,550 6,550 3100 Communications 1,200 1,200 1,200 890 Cellular telephones (10.5% of $8,500) 1,200 1,200 1,200 890 3610 Memberships - 113 113 150 American Public Works Association memb. (APWA) (1/4 of $452) 10 10 10 20 Pesticide license renewal - - - 40 MN Safety Council - 113 113 210 3630 Training & conferences 200 50 50 50 Computer classes 200 200 200 - Confined space training 200 200 200 200 Electronics updates, other classes 150 150 150 60 Hearing test/RTN training (1.16@$50) 60 60 60 60 Maintenance Expo 250 125 125 125 APWA/MN conferences. 250 250 250 250 Pavement, sealcoating, patching & sealcoating seminars. 600 - - - North Dakota Seminar for two - - - - PW mgt. Class - North Hennepin CC - - - 210 Equipment operator training (Skidsteer & boom) 100 100 100 - Pesticide applicator's class (every 3 years) 60 60 60 60 Vehicle inspection license renewal 75 75 75 75 Vehicle inspection recertification 60 60 - - Work zone traffice control (every 3 years) 2,205 1,330 1,270 1,090 4010 Rentals, equipment 2,600 3,800 3,800 3,800 Annual trade-in of skid steer loaders - - - 700 Specialized equip rental 2,600 3,800 3,800 4,500 4800 Bonding & insurance 4,800 4,800 4,800 4,800 Insurance policy premiums 1,400 1,400 1,400 1,400 Allowance for insurnace policy deductibles 6,200 6,200 6,200 6,200 5130 Repairs, equipment - 500 500 500 Misc. equipment repairs - 500 500 500 7030 Equipment - - 45,000 - Boom/bucket truck (used) - - 5,656 - Stump grinder attachment for skid stear (bobcat) - - 4,712 - Tracks for skid stear (bobcat) - - 6,000 - Plow for pickup - - 140,000 - Dump Truck replaces #133 (1996 Ford L8000) - - - - Air compressor (1/2 parks 1/2 pvmt. mgt.)(moved to vehicle fund) - - - 1,500 Radial arm saw 40,000 - - - 1 ton pick-up (carryover from 2009)(postpone to 2011) - - - - Lift tail gate 40,000 - 201,368 1,500 103,020 61,108 257,751 59,295 74.83%-40.68%150.20%-2.97% 61 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent 2012 Budget Summary Street Snow & Ice Control (100 - 4472): Personnel services: 0100 Salaries, regular 57,761 57,588 56,394 55,073 56,174 1,101 2.00% 0110 Salaries, overtime 6,884 8,204 10,316 5,416 5,524 108 1.99% 0300 Social Security 4,781 4,840 4,934 4,627 4,721 94 2.03% 0321 PERA 4,192 4,418 4,641 4,386 4,472 86 1.96% 0400 Group insurance 7,424 8,939 9,875 9,029 9,926 897 9.93% 0500 Workers compensation 3,151 3,662 4,322 4,198 4,196 (2) -0.05% Total personnel services 84,193 87,651 90,482 82,729 85,013 2,284 2.76% Materials & supplies: 1230 Supplies, equipment 3,795 3,849 2,042 2,100 2,500 400 19.05% 1600 Supplies, operating 29,683 19,873 27,954 27,050 27,050 - 0.00% 1700 Motor fuels & lubricants 3,970 7,244 3,102 7,680 4,680 (3,000) -39.06% 2400 Uniforms & clothing 834 491 306 1,000 855 (145) -14.50% 2410 Mats & towels - - 281 - 940 - 0.00% Total materials & supplies 38,282 31,457 33,685 37,830 36,025 (2,745) -7.26% Contractual services: 3030 Other professional services 580 700 700 700 700 - 0.00% 3100 Telephone - - - - 550 550 0.00% 3610 Memberships 200 331 354 203 190 (13) -6.40% 3630 Training & conferences - 80 - 250 55 (195) -78.00% 5130 Repairs, equipment 1,016 706 1,232 1,000 1,000 - 0.00% Total contractual supplies 1,796 1,817 2,286 2,153 2,495 342 15.88% Capital outlays 7030 Equipment 6,001 949 - - - - 0.00% 7040 Vehicles - - - - - - 0.00% Total capital outlays 6,001 949 - - - - 0.00% Total streets snow & ice control 130,272 121,874 126,453 122,712 123,533 (119) -0.10% 62 Fund: 100 Department: 4472 Snow & Ice Control Account Description 2009 2010 2011 2012 Description 1230 Supplies, equipment 250 250 250 250 Filters 450 450 450 450 Broom for Bobcat - 450 - - Skid steer bucket (1/2 in pavement snow & ice) 1,400 1,400 1,400 1,800 Cutting edges, plow shoes 2,100 2,550 2,100 2,500 1600 Supplies, operating 800 800 800 800 Welding supplies, steel stock, sod for boulevards, etc. - - 2,250 2,250 Liquid Mg Chloride: 1,500 gallons @ $1.50 per gallon. 33,150 32,000 24,000 24,000 Salt: 300 tons @ $80 per ton. 33,950 32,800 27,050 27,050 1700 Motor fuels & lubs 180 180 180 180 Engine oil: 30 gallons @ $6.00 per gallon. 8,500 7,500 7,500 4,500 Diesel fuel: 1,000 gallons @ $4.50 per gallon. 8,680 7,680 7,680 4,680 2400 Uniforms & clothing 1,200 1,200 1,200 660 Uniforms (11% of $6,000) - - - 195 Clothes & boots allowance (1.1@$175) 1,200 1,200 1,200 855 2410 Mats & towels - - - 940 Cost share of mats & towels (11% of $8,500) - - - 940 3030 Other professional services 700 700 700 700 Weather service reports 700 700 700 700 3100 Telephone - - - 550 Cellphone (6.5% of $8,500) - - - 550 3610 Memberships 25 25 25 - MN Street Superintendent's Assoc. 285 113 113 150 American Public Works Association memb. (APWA) (1/4 of $600) 65 65 65 40 Minnesota Safety Council 375 203 203 190 3630 Training 500 250 250 55 Hearing tests/RTN training (1.1@$50) 500 250 250 55 5130 Repairs, equipment 1,000 1,000 1,000 1,000 Plow, blower, salt spreader repairs 1,000 1,000 1,000 1,000 7030 Capital, equipment - - - - Pavement temp sensor - - - - Brine solution equipment (moved to vehicle & equip fund) - - - - 48,505 46,383 40,183 38,520 -12.55%-4.37%-13.37%-4.14% 63 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent 2012 Budget Summary Street Sign Maintenance (100 - 4475): Personnel services: 0100 Salaries, regular 20,718 20,797 20,266 20,026 20,427 401 2.00% 0110 Salaries, overtime - 650 848 722 737 15 2.08% 0300 Social Security 1,573 1,599 1,581 1,587 1,619 32 2.02% 0321 PERA 1,348 1,441 1,472 1,504 1,534 30 1.99% 0400 Group insurance 2,546 3,024 3,502 3,283 3,610 327 9.96% 0500 Workers compensation 1,102 1,281 1,511 1,508 1,507 (1) -0.07% Total personnel services 27,287 28,792 29,180 28,630 29,434 804 2.81% Materials & supplies: 1600 Supplies, operating 7,209 3,929 1,424 4,734 4,735 1 0.02% 1700 Motor fuels & lubricants - 559 - - - - 0.00% 2400 Uniforms & clothing - - - 480 310 (170) -35.42% 2410 Mats & towels - - - - 340 340 0.00% Total materials & supplies 7,209 4,488 1,424 5,214 5,385 (169) -3.24% Contractual services: 3100 Telephone - - - - 210 210 0.00% 3250 Electricity - traffic signals 2,166 1,797 1,767 2,000 2,000 - 0.00% 3630 Training & conferences - - - - 100 100 0.00% 5130 Repairs, equipment 600 244 - 750 500 (250) -33.33% Total contractual supplies 2,766 2,041 1,767 2,750 2,810 60 2.18% Capital outlays 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total street sign maintenance 37,262 35,321 32,371 36,594 37,629 695 1.90% 64 Fund: 100 Department: 4475 Street Sign Maintenance 1600 Supplies, operating 2,990 2,990 2,990 2,990 Signs, posts, sign hardware, and supplies 515 515 515 515 Shop supplies - fastners, degreasers, etc 615 615 615 615 Graffitti remover 615 615 615 615 City signage in County right of way - - - - Portable stop signs (4) 4,735 4,735 4,735 4,735 2400 Uniforms & clothing 480 480 480 240 Uniforms 0.4 FTE @ $1,200 - - - 70 Clothes and boot allowance (.4@$175) 480 480 480 310 2410 Mats & towels - - - 340 Cost share of mats & towels (4% of $8,500) - - - 340 3100 Telephone - - - 210 Cellphone (2.5% of $8,500) - - - 210 3250 Electricity - traffic signals 2,000 2,000 2,000 2,000 Electricity for traffic signals 2,000 2,000 2,000 2,000 3630 Training & conferences 250 250 - - Manual on Uniform Traffic Control Devices, workzone safety - - - 80 Equipment operator training - - - 20 Hearing test/RTN trainging (.4@$50) 250 250 - 100 5130 Repairs, equipment 515 750 750 500 Traffic signal repairs & maintenance 515 750 750 500 7,980 8,215 7,965 8,195 -6.99%2.94%-3.04%2.89% 65 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Convention & Visitor's Bureau (100-4653) Contractual services 3045 N Metro Convention Bureau 48,715 40,171 48,452 42,750 48,450 5,700 13.33% Total contractual services 48,715 40,171 48,452 42,750 48,450 5,700 13.33% Total Convention & Visitor's Bureau 48,715 40,171 48,452 42,750 48,450 5,700 13.33% Miscellaneous (100 - 4700): Personnel services 0300 Social security 133 277 106 - - - 0.00% 0321 PERA 133 428 365 - - - 0.00% 0400 Group insurance 165 423 304 - - - 0.00% 0750 Fitness program 4,969 5,135 3,169 6,500 6,500 - 0.00% Total personnel services 5,400 6,263 3,944 6,500 6,500 - 0.00% Contractual services 3065 Family & youth social services 18,375 18,926 18,661 18,661 19,221 560 3.00% Total contractual services 18,375 18,926 18,661 18,661 19,221 560 3.00% Miscellaneous 9100 Contingency - - - - - - 0.00% 9900 Transfers - Vehicle & Equip. Fund 175,000 175,000 50,000 75,000 75,000 - 0.00% 9900 Community Center 175,000 160,000 170,000 170,000 170,000 - 0.00% Total miscellaneous 350,000 335,000 220,000 245,000 245,000 - 0.00% 0.00% Total miscellaneous 373,775 360,189 242,605 270,161 270,721 560 0.21% Debt Service (100 - 4750): Debt Service Fire Bonds: 8010 Principal 107,098 99,088 115,060 50,213 - (50,213) -100.00% 8020 Interest 41,098 50,195 32,135 39,449 - (39,449) -100.00% Debt Service Fire Equipment Certificates: 8010 Principal 2,376 - - - - - 0.00% 8020 Interest 54 - - - - - 0.00% Total debt service 150,626 149,283 147,195 89,662 - (89,662) -100.00% 2012 Budget Summary 66 Fund: 100 Department: 4653 Convention & Visitor's Bureau Account Description 2009 2010 2011 2012 Description 3045 N Metro Convention Bureau 49,400 48,450 42,750 48,450 Payment of 95% of hotel/motel tax collections to support the promotion of tourism. 49,400 48,450 42,750 48,450 Fund: 100 Department: 4700 Miscellaneous Account Description 2009 2010 2011 2012 Description 0750 Fitness program 7,000 6,500 6,500 6,500 Fitness program (maximum $55/month paid with employee sick leave time). 7,000 6,500 6,500 6,500 3065 Family & youth social 18,926 18,926 18,926 19,221 Northwest Youth and Family Services services 18,926 18,926 18,926 19,221 9100 Contingency 150,000 100,000 - - Unexpected expenditures, deductibles, grant matches - - - - Local match for Federal / State grants 150,000 100,000 - - 9900 Transfers - miscellaneous 175,000 50,000 75,000 75,000 Transfer to Vehicle & Equipment Fund 175,000 50,000 75,000 75,000 9990 Community Center 185,000 175,000 170,000 170,000 Subsidy for Community Center operating costs 185,000 175,000 170,000 170,000 535,926 350,426 270,426 270,721 Fund: 100 Department: 4750 Fire Bond Debt Service Account Description 2009 2010 2011 2012 Description 8010 Principal 47,647 48,672 50,213 - 14.77% of 2012 principal payment on 47,647 48,672 50,213 - the 2005 Bond Issue 8020 Interest 43,327 41,084 39,449 - 14.77% of 2012 interest payment on 43,327 41,084 39,449 - the 2005 Bond Issue 8010 Principal 53,027 54,756 - - 15.21% of 2010 principal payment on 53,027 54,756 - - the 1997 Bond Issue 8020 Interest 5,283 2,683 - - 15.21% of 2010 interest payment on 5,283 2,683 - - the 1997 Bond Issue 8010 Principal 120,563 - - - Principal payment on 2003 Fire Equipment 120,563 - - - Certificates for mini-pumper. 8020 Interest 53 - - - Interest payment on 2003 Fire Equipment 53 - - - Certificates for mini-pumper. 8010 Principal 221,237 103,428 50,213 - Total principal 8020 Interest 48,663 43,767 39,449 - Total interest Total 269,900 147,195 89,662 - 67 CITY OF MOUNDS VIEW, MINNESOTA Special Revenue Funds 2012 Budgets Combining Statement of Revenues and Expenditures and Net Changes in Fund Balances Economic Cable Development Community Television DARE Forfeiture Authority Center Revenues: Taxes 100,000 - - - - Intergovernmental: County grants - - - - - Other local govt.- - - - - Charges for services: Culture and recreation - - - - 187,829 Miscellaneous: Fines - 500 5,500 - - Investment income - - - - 2,500 Other 5,100 - - - - Total revenues 105,100 500 5,500 - 190,329 Expenditures: Public safety Supplies - 350 500 - - Contractual services - 150 1,500 - - Capital outlay - - - - - Sanitation Personal services - - - - - Contractual services - - - - - Culture and recreation: Personal services 87,244 - - - 52,450 Supplies 3,000 - - - 12,282 Contractual services 41,747 - - - 312,966 Capital outlay - - - - 44,000 Economic development Personal services - - - 107,988 - Supplies - - - 300 - Contractual services - - - 231,149 - Capital outlay - - - 50,000 - Total expenditures 131,991 500 2,000 389,437 421,698 Surplus of revenues over (under) expenditures (26,891) - 3,500 (389,437) (231,369) Other financing sources (uses) Transfers in - - - 389,437 170,000 Transfers out - - - - - Total other financing sources (uses)- - - 389,437 170,000 Net change in fund balance (26,891) - 3,500 - (61,369) Fund balance, January 1:270,723 2,520 21,218 - 160,723 Fund balance, December 31 243,832 2,520 24,718 - 99,354 68 Lakeside Recycling TIF TIF TIF TIF Park Grant District #1 District #2 District #3 District #5 2012 2011 - - 1,687,621 154,335 349,928 1,208,260 3,500,144 3,376,178 - 25,199 - - - - 25,199 26,185 21,216 - - - - - 21,216 21,216 - - - - - - 187,829 189,934 - - - - - - 6,000 6,300 300 - 10,000 2,500 10,000 6,000 31,300 166,800 250 - - - - - 5,350 150 21,766 25,199 1,697,621 156,835 359,928 1,214,260 3,777,038 3,786,763 - - - - - - 850 1,150 - - - - - - 1,650 1,650 - - - - - - - 40,000 - 11,961 - - - - 11,961 11,999 - 13,238 - - - - 13,238 14,186 3,699 - - - - - 143,393 140,865 2,400 - - - - - 17,682 17,250 15,667 - - - - - 370,380 358,305 - - - - - - 44,000 54,000 - - - - - - 107,988 100,460 - - - - - - 300 280 - - 4,000 40,238 2,000 1,150,447 1,427,834 1,930,817 - - 1,504,027 - 425,973 - 1,980,000 2,504,743 21,766 25,199 1,508,027 40,238 427,973 1,150,447 4,119,276 5,175,705 - - 189,594 116,597 (68,045) 63,813 (342,238) (1,388,942) - - - - - - 559,437 742,435 - - (109,675) (109,674) (109,675) (60,413) (389,437) (1,632,529) - - (109,675) (109,674) (109,675) (60,413) 170,000 (890,094) - - 79,919 6,923 (177,720) 3,400 (172,238) (2,279,036) 11,165 21,649 400,505 445,115 572,256 923,870 2,829,744 11,771,352 11,165 21,649 480,424 452,038 394,536 927,270 2,657,506 9,492,316 Total 69 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Cable TV (Fund 210): Revenues 3180 Franchise fee 109,828 141,282 114,631 96,000 100,000 4,000 4.17% 3370 Other local government rev 569 - - - - - 0.00% 3610 Investment income - - - - - - 0.00% 3680 Other revenue 1,546 6,530 5,144 5,100 5,100 - 0.00% Total revenue 111,943 147,812 119,775 101,100 105,100 4,000 3.96% Operating expenses Operations (4350) Personnel services 0100 Salaries, regular 49,259 54,766 58,199 59,383 61,564 2,181 3.67% 0110 Salaries, over-time 3,056 2,074 - - - - 0.00% 0150 Salaries, part-time 5,211 8,017 4,211 8,432 6,261 (2,171) -25.75% 0300 Social security 4,460 4,895 4,680 5,188 5,188 - 0.00% 0321 PERA 4,030 4,341 4,324 4,308 4,463 155 3.60% 0400 Group insurance 5,292 7,004 7,905 8,618 9,475 857 9.94% 0500 Workers compensation 182 239 290 299 293 (6) -2.01% 0600 Unemployment - 1,246 744 - - - 0.00% 0990 Severence pay - - - - - - 0.00% Total personnel services 71,490 82,582 80,352 86,228 87,244 1,016 1.18% Materials & supplies 1230 Supplies, equipment 237 2,598 396 2,000 2,000 - 0.00% 1600 Supplies, operating 1,081 551 221 1,000 1,000 - 0.00% Total materials & supplies 1,318 3,149 617 3,000 3,000 - 0.00% Contractual services 3030 Other professional services 3,713 4,850 3,622 3,600 4,140 540 15.00% 3630 Training & conferences 152 325 370 300 300 - 0.00% 3800 Mileage & parking 97 20 23 100 75 (25) -25.00% 3900 Grants & subsidies 25,936 26,719 26,933 26,933 27,232 299 1.11% 5130 Repairs, equipment 906 51 139 1,000 10,000 9,000 900.00% Total contractual services 30,804 31,965 31,087 31,933 41,747 9,814 30.73% Capital 7030 Equipment 37,462 9,767 - - - - 0.00% Total capital outlays 37,462 9,767 - - - - 0.00% Total expenditures 141,074 127,463 112,056 121,161 131,991 10,830 8.94% Net change in fund balance (29,131) 20,349 7,718 (20,061) (26,891) (6,830) 34.05% Fund balance, beginning year 291,847 262,716 283,065 290,784 270,723 (20,061) -6.90% Fund balance, end of year 262,716$ 283,065$ 290,784$ 270,723$ 243,832$ (26,891)$ -9.93% 2012 Budget Summary 70 Fund: 210 Cable TV Revenues Account Description 2009 2010 2011 2012 Description 3180 Franchise fee revenue 96,000 96,000 96,000 100,000 Estimated collections 96,000 96,000 96,000 100,000 3680 Other revenue - 5,100 5,100 5,100 Lease revenue from Library fiber connection - 5,100 5,100 5,100 Fund: 210 Department: 4350 Operations 1230 Supplies, equipment 3,500 4,000 2,000 2,000 Equipment costing less than $1,000 per item 3,500 4,000 2,000 2,000 1600 Supplies, operating 1,000 1,000 750 750 Recording media - tapes, DVD's 500 500 250 250 Batteries, cables, bulbs, tapes, misc 1,500 1,500 1,000 1,000 3030 Other professional services 3,300 3,400 3,600 4,140 Web streaming meetings $300 per month. 3,300 3,400 3,600 4,140 3630 Training & conferences 700 700 300 300 Attendance at local training - 600 - - Submission fees for awards (new item for 2010) 700 1,300 300 300 3800 Mileage & parking 200 100 100 75 Mileage 200 100 100 75 3900 Grants & subsidies 26,382 27,254 26,933 27,232 Share of costs of North Suburban Cable Commission 26,382 27,254 26,933 27,232 5130 Repairs, equipment 1,500 1,500 1,000 10,000 Repair and maintenance of equipment 1,500 1,500 1,000 10,000 7030 Capital, equipment 2,000 - - - Podeum and other council chamber improvements 1,700 - - - Adobe Creative Suite 3 Production Premium Software 3,700 - - - 40,782 39,054 34,933 44,747 -30.39%-4.24%-10.55%28.09% 71 2008 2009 2010 2011 2012 Actual Actual Actual Budget Request Dollar Percent DARE (Fund 220): Revenues 3511 Fines - controlled substnc 643 759 538 800 500 (300) -37.50% 3610 Investment income - - - - - - 0.00% 3650 Donations - - - - - - 0.00% 3680 Other revenue - 450 - - - - 0.00% Total revenue 643 1,209 538 800 500 (300) -37.50% Operating expenses (4200): Materials & supplies 1600 Supplies, operating 1,357 754 1,189 650 350 (300) -46.15% Total Supplies 1,357 754 1,189 650 350 (300) -46.15% Contractual services 3030 Other professional services - - - - - - 0.00% 3430 Printing - - - 100 100 - 0.00% 3610 Memberships - - - 50 50 - 0.00% 3630 Training & conferences - - - - - - 0.00% Total contractual services - - - 150 150 - 0.00% Transfers 9900 Transfers out 4,393 4,393 4,393 3,000 - - 0.00% Total capital outlays 4,393 4,393 4,393 3,000 - - 0.00% Total expenditures 5,750 5,147 5,582 3,800 500 (300) -7.89% Net change in fund balance (5,107) (3,938) (5,044) (3,000) - 3,092 -103.07% Fund balance, beginning year 19,610 14,503 10,565 5,520 2,520 (3,000) -54.34% Fund balance, end of year 14,503$ 10,565$ 5,520$ 2,520$ 2,520$ -$ 0.00% 2012 Budget Summary Change from 2011 72 Fund: 220 DARE Revenues Account Description 2009 2010 2011 2012 Description 3511 Fines - controlled substance 1,600 850 800 500 Estimated collections 1,600 850 800 500 3610 Interest revenue - - - - Estimated interest earnings (moved to general fund per council 08) - - - - Fund: 220 Department: 4200 Operations 1600 Supplies, operating 2,500 2,000 650 350 DARE apparel and supplies. 2,500 2,000 650 350 3430 Printing 100 100 100 100 Programs and parent guides. 100 100 100 100 3610 Memberships 100 100 50 50 NSRO, NDOA, & MNDARE. 100 100 50 50 3630 Training & conferences 800 800 - - DARE or NSRO conference. 800 800 - - 9900 Transfer out 4,393 4,393 3,000 - Reimburse General Fund for 5% of DARE officer salary 4,393 4,393 3,000 - 7,893 7,393 3,800 500 73 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Forfeiture (Fund 225): Revenues 3514 Forfeitures 10,098 15,744 14,831 5,500 5,500 - 0.00% 3610 Investment income - - - - - - 0.00% 3650 Donations - - - - - - 0.00% 3680 Other revenue 6,703 - 422 - - - 0.00% Total revenue 16,801 15,744 15,253 5,500 5,500 - 0.00% Operating expenses (4200): Materials & supplies 1230 Supplies, equipment - - - - - 0.00% 1600 Supplies, operating 7,334 206 340 500 500 - 0.00% Total materials & supplies 7,334 206 340 500 500 - 0.00% Contractual services 3030 Other professional services 203 5,880 4,545 1,500 1,500 - 0.00% Total contractual services 203 5,880 4,545 1,500 1,500 - 0.00% Capital 7030 Equipment 21,576 - - - - - 0.00% 7040 Vehicles 25,000 - - 29,000 - - 0.00% Total capital outlays 46,576 - - 29,000 - - 0.00% Total expenses 54,113 6,086 4,885 31,000 2,000 - 0.00% Net change in fund balance (37,312) 9,658 10,368 (25,500) 3,500 29,000 -113.73% Fund balance, beginning year 64,004 26,692 36,350 46,718 21,218 (25,500) -54.58% Fund balance, end of year 26,692 36,350 46,718 21,218 24,718 3,500 16.50% 2012 Budget Summary 74 Fund: 225 Forfeiture Revenues Account Description 2009 2010 2011 2012 Description 3514 Forfeitures 5,500 5,500 5,500 5,500 Sale of forfeited vehicles at auction. 5,500 5,500 5,500 5,500 3610 Interest revenue - - - - Estimated interest earnings (moved to general fund per council 08) - - - - Fund: 225 Department: 4200 Operations 1600 Supplies - operating 1,000 500 500 500 Supplies to prepare vehicles for auction. (tows, title fees, batteries) 1,000 500 500 500 3030 Other professional services 4,125 2,000 1,500 1,500 Share of auction costs. 4,125 2,000 1,500 1,500 7030 Equipment 10,000 - - - In-squad cameras - - 29,000 - One squad $23,000 + set-up $6000 One in General Fund. 8,800 9,500 - - Speed display unit 18,800 9,500 29,000 - 23,925 12,000 31,000 2,000 75 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent EDA (Fund 230): Revenues 3425 Remodeling planbook 15 - - - - - 0.00% 3680 Other revenue 5,464 2,760 2,815 - - - 0.00% 3972 Transfers 156,680 129,824 127,649 387,435 389,437 2,002 0.52% Total revenue 162,159 132,584 130,464 387,435 389,437 2,002 0.52% Operating expenses Economic Development (4650): Personnel services 0100 Salaries, regular 71,885 77,240 78,820 78,681 84,276 5,595 7.11% 0300 Social security 5,335 5,808 5,946 6,019 6,448 429 7.13% 0321 PERA 4,438 5,098 5,500 5,703 6,110 407 7.14% 0400 Group insurance 9,577 9,039 9,734 9,628 10,702 1,074 11.15% 0500 Workers compensation 209 274 323 429 452 23 5.36% Total personnel services 91,444 97,459 100,324 100,460 107,988 7,528 7.49% Materials & supplies 1600 Supplies, operating - - - 150 100 (50) -33.33% 2100 Book & periodicals 269 110 - 130 200 70 53.85% Total materials & supplies 269 110 - 280 300 20 7.14% Contractual services 3030 Other professional services 46,277 28,645 21,775 73,910 68,998 (4,912) -6.65% 3420 Advertisements 336 717 273 1,000 1,000 - 0.00% 3430 Printing - 556 885 1,000 1,000 - 0.00% 3610 Memberships 10,086 3,935 3,066 3,875 3,451 (424) -10.94% 3630 Training & conferences 1,980 1,262 616 2,210 2,000 (210) -9.50% 3800 Mileage - - - 100 100 - 0.00% 4800 Insurance 3,767 3,912 3,526 4,600 4,600 - 0.00% 5210 Housing replacement 8,000 - - 150,000 150,000 - 0.00% Total contractual services 70,446 39,027 30,140 236,695 231,149 (5,546) -2.34% Capital outlays 9300 Business subsidies - - - 50,000 50,000 - 0.00% Total capital outlays - - - 50,000 50,000 - 0.00% Total expenditures 162,159 136,596 130,464 387,435 389,437 2,002 0.52% Net change in fund balance - (4,012) - - - - 0.00% Fund balance, beginning year 4,012 4,012 - - - - 0.00% Fund balance, end of year 4,012 - - - - - 0.00% 2012 Budget Summary 76 Fund: 230 EDA Revenues Account Description 2009 2010 2011 2012 Description 3610 Interest income 75 - - - Estimated interest earnings at 1.50%. 75 - - - 3972 Transfers 380,865 385,189 387,435 389,437 Transfers from TIF 1,2,3,5 380,865 385,189 387,435 389,437 Fund: 230 Department: 4650 Economic Development 1600 Supplies, operating 200 150 150 100 Misc office supplies 200 150 150 100 2100 Books & periodicals 100 100 - - MN Real Estate Journal - - - - Mpls./St.Paul Business Journal 30 30 30 30 LMC directory 100 100 100 170 Misc. reports & periodicals (Finance & Commerce) 230 230 130 200 3030 Other professional services 7,000 7,000 7,000 7,000 Legal fees for development reviews 12,000 12,000 12,000 12,000 Financial consultant fees (Ehlers) 31,500 30,000 30,000 25,000 Special project consultant fees 11,750 - - - City branding - Marketing Group Services 5,000 5,000 5,000 5,000 Appraisal and environmental fees 4,200 4,290 4,410 4,498 15% audit fee 12,000 12,500 12,500 12,500 Housing Resource Center fees 3,000 3,000 3,000 3,000 Marketing Consultant fees 86,450 73,790 73,910 68,998 3420 Advertising 1,000 1,000 1,000 1,000 Targeted advertisements. 1,000 1,000 1,000 1,000 3430 Printing 500 500 500 500 Property ad printing 200 200 200 200 Stationary/business cards/signs/site info 1,200 - - - Business directory reprints 300 300 300 300 Misc printing 2,200 1,000 1,000 1,000 3610 Memberships 375 400 400 400 Economic Development Assoc of MN (EDAM) 5,500 - - - North Metro 35 W Corridor Coalition 600 600 600 250 Twin Cities North Chamber of Commerce dues 3,500 2,801 2,875 2,801 North Metro Mayors Assoc (50% of dues, 50% in GF) 9,975 3,801 3,875 3,451 3630 Training & conferences 400 400 400 300 Chamber of Commerce meetings 650 650 650 650 DEED/ EDC training 125 360 360 300 EDAM monthly meetings 800 600 600 600 EDAM summer conference 300 200 200 150 Other miscellaneous training 2,275 2,210 2,210 2,000 3800 Mileage 100 100 100 100 Misc. mileage 4800 Insurance 4,600 4,600 4,600 4,600 Allocation of the City's property & liability insurance 4,600 4,600 4,600 4,600 5210 Housing replacement 150,000 150,000 150,000 150,000 Housing Improvement programs 150,000 150,000 150,000 150,000 9300 Business subsidies 25,000 50,000 50,000 50,000 Business improvement partnership loans 25,000 50,000 50,000 50,000 282,030 286,881 286,975 281,449 77 THIS PAGE LEFT BLANK INTENTIONALLY 78 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Community Center (Fund 252): Building overhead (4350) Building overhead revenues 179,969 164,151 173,342 172,500 172,500 - 0.00% Building overhead expenditures 1,632 6,139 8,184 9,900 - (9,900) -100.00% Net Building Overhead Operations 178,337 158,012 165,158 162,600 172,500 9,900 6.09% Banquet Center (4730): Banquet revenues 75,740 84,276 84,895 80,000 80,000 - 0.00% Banquet Center expenditures 92,125 106,399 106,370 148,241 151,699 3,458 2.33% Net Banquet Center (16,385) (22,123) (21,474) (68,241) (71,699) (3,458) 5.07% YMCA (4732): YMCA revenues 24,572 33,741 33,162 30,450 30,450 - 0.00% YMCA expenditures 207,627 196,866 203,284 232,771 232,835 64 0.03% Net YMCA (183,055) (163,125) (170,122) (202,321) (202,385) (64) 0.03% Chamber of Commerce (4734): Chamber revenues 10,832 12,148 4,049 - - - 0.00% Chamber expenditures 5,990 6,272 5,929 - - - 0.00% Net Chamber of Commerce 4,842 5,876 (1,879) - - - 0.00% Creative Kids Child Care Center (4736): Creative Kids revenues 72,866 75,474 76,047 76,984 77,379 395 0.51% Creative Kids expenditures 34,607 33,151 34,910 36,582 37,163 581 1.59% Net Creative Kids 38,259 42,323 41,137 40,402 40,216 (186) -0.46% Total revenue 363,979 369,790 371,496 359,934 360,329 395 0.11% Total expenditures 341,981 348,827 358,677 427,494 421,698 (5,796) -1.36% Net change in fund balance 21,998 20,963 12,819 (67,560) (61,369) 6,191 -9.16% Fund balance, beginning year 172,502 194,500 215,463 228,283 160,723 (67,560) -29.59% Fund balance, end of year 194,500 215,463 228,283 160,723 99,354 (61,369) -38.18% (continued) 79 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Community Center (continued): Building overhead (4350) Building revenues: 3610 Investment income 4,677 2,784 2,508 2,500 2,500 - 0.00% 3634 Equipment rental 167 56 - - - - 0.00% 3650 Donations - - - - - - 0.00% 3680 Miscellaneous 125 1,311 834 - - - 0.00% 3972 Transfers from Sp. Projects - - - - - - 0.00% 3972 Transfers 175,000 160,000 170,000 170,000 170,000 - 0.00% 179,969 164,151 173,342 172,500 172,500 - 0.00% Operating expenses Personnel services 0100 Salaries, regular 35,408 35,522 35,327 34,726 35,420 694 2.00% 0110 Salaries,overtime - 380 958 1,670 1,703 33 1.98% 0300 Social Security 2,545 2,307 2,355 2,785 2,840 55 1.97% 0321 PERA 2,163 2,393 2,511 2,639 2,691 52 1.97% 0400 Group insurance 6,473 7,416 7,762 7,578 8,256 678 8.95% 0500 Workers compensation 1,196 1,359 1,558 1,540 1,540 - 0.00% 999 Allocation of salaries (47,785) (49,377) (49,664) (50,938) (52,450) (1,512) 2.97% Total personnel services - - 805 - - - 0.00% Materials & supplies 1210 Supplies, buildings & grounds 532 1,234 910 1,100 1,100 - 0.00% 1230 Supplies, equipment 1,339 748 2,380 400 800 400 100.00% 1600 Supplies, operating 8,387 10,170 6,526 7,000 7,000 - 0.00% 2400 Uniforms 337 604 396 450 582 132 29.33% 2410 Mats & towels 2,757 1,276 1,219 2,800 2,800 - 0.00% 2999 Allocation of supplies (13,352) (14,032) (11,345) (11,850) (12,282) (432) 3.65% Total materials & supplies - - 86 (100) - 100 -100.00% Contractual services 3030 Other professional services 239 111 147 200 200 - 0.00% 3100 Telephone 3,338 3,372 3,631 3,000 3,600 600 20.00% 3200 Water & sewer 9,412 6,745 8,792 9,500 9,500 - 0.00% 3210 Electricity 52,182 51,585 55,718 53,000 56,000 3,000 5.66% 3220 Natural gas 22,275 13,126 12,047 23,000 17,000 (6,000) -26.09% 3530 Refuse collection 4,272 4,026 4,792 4,100 4,500 400 9.76% 3999 Allocation of utilities (91,718) (72,826) (85,183) (92,800) (90,800) 2,000 -2.16% 5110 Repairs, building & grounds 10,533 11,832 11,599 18,000 17,330 (670) -3.72% 5130 Repairs, equipment 5,734 13,352 9,599 6,700 6,700 - 0.00% 5999 Allocation of repairs (16,267) (25,184) (21,198) (24,700) (24,030) 670 -2.71% Total contractual services - 6,139 (56) - - - 0.00% Capital 7030 Equipment 1,632 - 7,350 10,000 - (10,000) -100.00% Total capital outlays 1,632 - 7,350 10,000 - (10,000) -100.00% 1,632 6,139 8,184 9,900 - (9,900) -100.00% Total Building Overhead Net 178,337 158,012 165,158 162,600 172,500 9,900 6.09% (continued) 80 Fund: 252 Department: 4350 Community Center Building Overhead Account Description 2009 2010 2011 2012 Description 1210 Supplies, bldgs & grounds 1,200 1,200 1,100 1,100 Lights, signs, fertilizer 1,200 1,200 1,100 1,100 1230 Supplies, equipment 400 400 400 800 Small tools & equipment 400 400 400 800 1600 Supplies, operating 5,090 5,800 7,000 7,000 Batteries, soap, paper towels, cleaning supplies for bathrooms Paper cups, plates, etc. for lounge & customer service events 5,090 5,800 7,000 7,000 2400 Uniforms 500 450 450 582 Uniforms/Clothing (7.5% of $6,000)(.75FTE * $175) 500 450 450 582 2410 Mats & towels 2,000 2,000 2,000 2,000 Floor mats and cleaning towelsto provide better protection of carpets 800 800 800 800 Special events 2,800 2,800 2,800 2,800 3030 Other professional services 200 200 200 200 Backflow inspection 200 200 200 200 3100 Telephone & internet 3,000 3,000 3,000 3,600 Office & customer phones, internet, maintenance agreements, & repairs 3,000 3,000 3,000 3,600 3200 Water & Wastewater 9,500 9,500 9,500 9,500 Water & sewer charges for community center 9,500 9,500 9,500 9,500 3210 Electricity 55,800 54,000 53,000 56,000 Estimated electrice charges 55,800 54,000 53,000 56,000 3220 Natural gas 30,240 25,500 23,000 17,000 Estimated natural gas charges 30,240 25,500 23,000 17,000 3530 Refuse collection 3,420 3,420 4,000 3,720 Dumpsters $310 x 12 months (10-$333) - - - 680 Extra garbage pick-up charges 100 100 100 100 Ramsey County recyclying fee 3,520 3,520 4,100 4,500 5110 Repairs, building & grounds 5,760 5,760 5,760 5,760 Custodial services: 12 mths X $480 4,000 4,000 3,000 3,000 Commercial carpet cleaning service (twice annually) 6,180 6,180 5,180 4,500 Exterior building maintenance 750 750 750 770 Exterminator: 12 months X 64.02 2,000 2,000 1,500 1,500 Fire alarm system service 2,060 2,060 1,310 1,300 Parking lot & grounds maintenance 500 750 500 500 Security system service 21,250 21,500 18,000 17,330 5130 Repairs, equipment 4,500 5,000 5,000 5,000 HVAC system maintenance 200 200 200 200 Sprinkler inspections 1,500 1,500 1,500 1,500 Plumbing, electrical, & misc. interior maintenance 6,200 4,025 6,700 6,700 7030 Capital, equipment - - - - HVAC Improvements - - 10,000 - Community Center Roof repairs - - - - Roof over kitchen area (will be done as part of full reroof above in 2012) - - 10,000 - 139,700 131,895 139,250 127,112 81 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Community Center (continued): Banquet Center (4730): Banquet Revenues 3644 Equipment rental 109 140 - - - - 0.00% 3645 Rental - banquet facility 75,631 84,136 84,895 80,000 80,000 - 0.00% 0.00% 75,740 84,276 84,895 80,000 80,000 - 0.00% Banquet Expenditures Personnel services 0999 Allocation of salaries 9,557 11,133 9,933 10,188 10,490 302 2.96% Total personnel services 9,557 11,133 9,933 10,188 10,490 302 2.96% Materials & supplies 1230 Supplies, equipment - 320 - - - - 0.00% 2999 Allocation of supplies 3,798 3,980 3,298 3,318 3,439 121 3.65% Total materials & supplies 3,798 4,300 3,298 3,318 3,439 121 3.65% Contractual services 3030 Other professional services 35,356 58,014 56,697 51,075 55,256 4,181 8.19% 3100 Telephone 412 312 399 600 500 (100) -16.67% 3420 Advertising 266 - - 750 500 (250) -33.33% 3430 Printing 97 - - 250 250 - 0.00% 3999 Allocation of utilities 25,270 20,519 23,616 25,744 25,136 (608) -2.36% 4800 Bonding & insurance 1,720 1,786 1,610 2,100 2,100 - 0.00% 5110 Repairs, building & grounds 2,907 2,302 320 1,700 1,700 - 0.00% 5130 Repairs, equipment 2,975 981 274 1,600 1,600 - 0.00% 5999 Allocation of repairs 4,400 7,052 5,935 6,916 6,728 (188) -2.71% Total contractual services 73,403 90,966 88,852 90,735 93,770 3,035 3.35% Capital 7030 Equipment 5,367 - 4,287 44,000 44,000 - 0.00% Total capital outlays 5,367 - 4,287 44,000 44,000 - 0.00% 92,125 106,399 106,370 148,241 151,699 3,458 2.33% Total Banquet Center net (16,385) (22,123) (21,474) (68,241) (71,699) (3,458) 5.07% (continued) 82 Fund: 252 Community Center Expenses Account Description 2009 2010 2011 2012 Description 2999 Allocation of supplies 2,797 2,982 3,318 3,402 28% Allocation from overall building support 2,797 2,982 3,318 3,402 3030 Other professional services 700 715 735 745 2.5% of audit 850 2,600 2,600 2,600 Miscellaneous professional services (linen service) 47,103 45,333 46,240 50,411 Banquet facility management 1,500 1,500 1,500 1,500 Legal costs 50,153 50,148 51,075 55,256 3100 Telephone/Internet 900 450 600 500 Internet service (1/2 reimbursed from other tenants) 900 450 600 500 3420 Advertising & marketing 1,000 1,000 750 500 Website and traditional advertising, marketing 1,000 1,000 750 500 3430 Printing 250 250 250 250 Brochures, flyers, etc. 250 250 250 250 3999 Allocation of utilities 28,393 26,562 25,744 25,136 28% Allocation from overall building utilities 28,393 26,562 25,744 25,136 4800 Bonding & insurance 2,100 2,100 2,100 2,100 Insurance & bonding cost 2,100 2,100 2,100 2,100 5110 Repairs, building & grounds 1,200 1,200 1,200 1,200 Interior building repairs specific to the banquette center 500 500 500 500 Dance floor maintenance 1,700 1,700 1,700 1,700 5130 Repairs, equipment 1,600 1,600 1,600 1,600 Repairs to kitchen, audio system, and other banquette equipment 1,600 1,600 1,600 1,600 5999 Allocation of repairs 7,686 7,826 6,916 6,728 28% Allocation from overall building repairs 7,686 7,826 6,916 6,728 7030 Capital, equipment 4,000 4,000 4,000 4,000 Table replacement program - - 40,000 40,000 Chairs for banquet center (400 @ $100) 1,200 - - - LCD Projectors (2) 5,200 4,000 44,000 44,000 101,779 98,618 138,053 141,172 83 2012 Budget Summary 2008 2009 2010 2011 2012 Actual Actual Actual Budget Request Dollar Percent Community Center (continued): YMCA (4732): YMCA Revenues 3405 Recreation profit 6,941 14,939 14,976 12,000 12,000 - 0.00% 3660 Gym & meeting room rental 4,221 7,235 4,691 7,000 5,000 (2,000) -28.57% 3661 Open gym participant fees 13,050 10,991 13,036 11,000 13,000 2,000 18.18% 3679 Commissions - vending 360 576 459 450 450 - 0.00% 24,572 33,741 33,162 30,450 30,450 - 0.00% YMCA Expenditures Personnel services - 0999 Allocation of salaries 32,972 32,812 34,268 36,675 37,764 1,089 2.97% Total personnel services 32,972 32,812 34,268 36,675 37,764 1,089 2.97% Materials & supplies 1600 Supplies, operating 29 - - - - - 0.00% 2999 Allocation of supplies 6,797 7,108 5,892 6,281 6,509 228 3.64% Total materials & supplies 6,826 7,108 5,892 6,281 6,509 228 3.64% Contractual services 3030 Other professional services 93,213 94,149 94,659 99,505 99,505 - 0.00% 3300 Postage 1,177 312 - 1,200 1,200 - 0.00% 3430 Printing 7,564 4,794 4,620 6,000 6,000 - 0.00% 3999 Allocation of utilities 46,373 37,928 43,608 49,994 49,096 (898) -1.80% 4800 Bonding & insurance 2,866 2,977 2,683 4,025 4,025 - 0.00% 5110 Repairs, building & grounds 5,451 608 178 12,000 12,000 - 0.00% 5130 Repairs, equipment 2,827 3,586 6,777 4,000 4,000 - 0.00% 5999 Allocation of repairs 8,358 12,592 10,599 13,091 12,736 (355) -2.71% Total contractual services 167,829 156,946 163,124 189,815 188,562 (1,253) -0.66% 207,627 196,866 203,284 232,771 232,835 64 0.03% Total YMCA net (183,055) (163,125) (170,122) (202,321) (202,385) (64) 0.03% (continued) Change from 2011 84 Fund: 252 Community Center Account Description 2009 2010 2011 2012 Description 2999 Allocation of supplies 4,995 5,325 6,281 6,440 50% Allocation from overall building support 4,995 5,325 6,281 6,440 3030 Other professional services 95,000 95,400 97,300 97,300 YMCA management contract (other half of fee in parks) 2,100 2,145 2,205 2,235 7.5% of audit 97,100 97,545 99,505 99,535 3300 Postage 1,200 1,200 1,200 1,200 50% of the cost of mailing the Mounds View Matters newsletter 1,200 1,200 1,200 1,200 3430 Printing 6,000 6,000 6,000 6,000 50% of the cost of printing the Mounds View Matters newsletter 6,000 6,000 6,000 6,000 3999 Allocation of utilities 52,030 48,760 49,994 49,096 50% Allocation from overall building utilities 52,030 48,760 49,994 49,096 4010 Rental, equipment 500 - - - RecNet recreation programming and facility rental software 500 - - - 4800 Bonding & insurance 3,500 3,500 4,025 4,025 Insurance & bonding cost. 3,500 3,500 4,025 4,025 5110 Repairs, building & grounds 2,000 2,000 3,000 3,000 General building repairs - - 7,000 - Interior improvements 10,000 10,000 2,000 2,000 Gym floor resurfacing & maintenance 12,000 12,000 12,000 5,000 5130 Repairs, equipment 2,650 2,650 2,650 2,650 Copier maintenance contract 1,000 1,000 1,000 1,000 Registration system support 350 350 350 350 Repairs to other equipment 4,000 4,000 4,000 4,000 5999 Allocation of repairs 13,725 13,975 13,091 12,736 50% Allocation from overall building repairs 13,725 13,975 13,091 12,736 195,050 192,305 196,096 188,032 85 THIS PAGE LEFT BLANK INTENTIONALLY 86 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Creative Kids Child Care (4736): Child Care Revenues 3632 Lease - Child Care 72,866 75,474 76,047 76,984 77,379 395 0.51% 72,866 75,474 76,047 76,984 77,379 395 0.51% Child Care Ed Expenditures Personnel services 0999 Allocation of salaries 3,824 3,950 3,973 4,075 4,196 121 2.97% Total personnel services 3,824 3,950 3,973 4,075 4,196 121 2.97% Materials & supplies 2999 Allocation of supplies 2,549 2,701 2,236 2,252 2,334 82 3.62% Total materials & supplies 2,549 2,701 2,236 2,252 2,334 82 3.62% Contractual services 3999 Allocation of utilities 16,842 13,637 15,713 17,062 16,568 (494) -2.90% 4750 Taxes, licenses, & fees 6,790 6,888 7,888 7,100 8,100 1,000 14.08% 4800 Bonding & insurance 1,146 1,191 1,073 1,400 1,400 - 0.00% 5110 Repairs, building & grounds - - - - - - 0.00% 5999 Allocation of repairs 3,456 4,784 4,028 4,693 4,566 (127) -2.71% Total contractual services 28,234 26,500 28,702 30,255 30,634 379 1.25% Total Child Care expenditures 34,607 33,151 34,910 36,582 37,163 581 1.59% Total Child Care net 38,259 42,323 41,137 40,402 40,216 (186) -0.46% 87 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Lakeside Park (Fund 255): Revenues 3370 Spring Lake Pk contribution 10,608 10,608 10,608 10,608 10,608 - 0.00% 3370 Mounds View contribution 10,608 10,608 10,608 10,608 10,608 - 0.00% 3610 Investment income 345 478 186 300 300 - 0.00% 3680 Other revenue - - - - 0.00% 3665 Park site permit 515 217 801 150 250 100 66.67% Total revenue 22,076 21,911 22,204 21,666 21,766 100 0.46% Operating expenses (4350): Personnel services 0150 Salaries, part-time 2,853 3,360 3,780 3,349 3,349 - 0.00% 0300 Social security 218 257 289 256 256 - 0.00% 0500 Workers compensation 63 87 94 94 94 - 0.00% Total personnel services 3,134 3,704 4,164 3,699 3,699 - 0.00% Materials & supplies 1210 Supplies, bldgs & grounds 1,595 432 4,285 600 600 - 0.00% 1600 Supplies, operating 1,155 1,714 - 1,800 1,800 - 0.00% Total materials & supplies 2,750 2,146 4,285 2,400 2,400 - 0.00% Contractual services 3030 Other professional services - - - - - - 0.00% 3100 Telephone/Internet - - - - - - 0.00% 3200 Water & sewer 1,381 2,159 1,315 1,400 1,400 - 0.00% 3210 Electricity 637 700 919 700 1,500 800 114.29% 3530 Refuse collection 48 48 118 300 250 (50) -16.67% 4010 Equipment Contribution SLP 4,233 4,481 4,481 4,372 4,372 - 0.00% 4030 Satellites 550 507 389 550 500 (50) -9.09% 4800 Insurance 3,440 3,572 4,019 4,150 4,200 50 1.20% 5130 Repairs, equipment 637 3,316 - 4,095 3,445 (650) -15.87% Total contractual services 10,926 14,783 11,242 15,567 15,667 100 0.64% Capital 7030 Equipment - - - - - - 0.00% 7050 Construction - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total expenses 16,810 20,633 19,690 21,666 21,766 100 0.46% Net change in fund balance 5,266 1,278 2,513 - - - 0.00% Fund balance, beginning year 2,108 7,374 8,652 11,165 11,165 - 0.00% Fund balance, end of year 7,374 8,652 11,165 11,165 11,165 - 0.00% 88 Fund: 255 Lakeside Park Account Description 2009 2010 2011 2012 Description 3370 Contributions 10,608 10,608 10,608 10,608 Spring Lake Park contribution for half of cost for joint park 10,608 10,608 10,608 10,608 3370 Contributions 10,608 10,608 10,608 10,608 Mounds View contribution for half of cost for joint park 10,608 10,608 10,608 10,608 3610 Interest revenue 300 300 300 300 Estimated interest earnings at 2.00%. 300 300 300 300 3680 Park sit rental 150 150 150 250 Rental of the park by groups or individuals 150 150 150 250 Fund: 255 Department: 4350 1210 Supplies, bldgs & grounds 600 600 600 600 Paper, sand, etc. 600 600 600 600 1600 Supplies, operating 1,595 1,800 1,800 1,800 Fertilizer & pesticides 1,595 1,800 1,800 1,800 3200 Water & sewer 1,000 1,400 1,400 1,400 Estimated water & sewer charges 1,000 1,400 1,400 1,400 3210 Electricity 600 600 700 1,500 Estimated electric charges 600 600 700 1,500 3530 Refuse collection 400 400 300 250 Six months service 400 400 300 250 4010 Equipment, capital charge 4,372 4,372 4,372 4,372 Capital charge for usage of SLP city equipment 4,372 4,372 4,372 4,372 4030 Satellites 500 500 550 500 Five months service 500 500 550 500 4800 Insurance & bonds 4,200 4,200 4,150 4,200 Property & liability insurnace 4,200 4,200 4,150 4,200 5130 Repairs, equipment 4,700 4,095 4,095 3,445 Repair of equipment at the park 4,700 4,095 4,095 3,445 17,967 17,967 17,967 18,067 0.00%0.00%0.00%0.56% 89 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Recycling (Fund 290): Revenues 3360 Other County grants 25,806 25,806 25,598 26,185 25,199 (986) -3.77% 3680 Other revenue 943 943 - - - - 0.00% Total revenue 26,749 26,749 25,598 26,185 25,199 (986) -3.77% Operating expenses Operations (4420) Personnel services 0100 Salaries, regular 5,523 5,523 8,570 8,488 8,345 (143) -1.68% 0300 Social security 388 388 553 646 638 (8) -1.24% 0321 PERA 342 342 600 612 605 (7) -1.14% 0400 Group insurance 1,420 1,420 2,259 2,190 2,312 122 5.57% 0500 Workers compensation 27 27 55 63 61 (2) -3.17% 0990 Severence pay - - - - - 0.00% Total personnel services 7,700 7,700 12,037 11,999 11,961 (38) -0.32% Materials & supplies 1600 Supplies, operating 4,320 4,320 4,505 - - - 0.00% Contractual services 3030 Other professional services 150 150 1,800 - - - 0.00% 3300 Postage 1,806 1,806 2,245 1,200 1,700 500 41.67% 3420 Advertisements - - - 1,545 (1,545) -100.00% 3430 Printing 4,158 4,158 520 1,301 1,400 99 7.61% 3530 Refuse collection 4,486 4,486 5,291 10,140 10,138 (2) -0.02% 3960 Awards - - - - - - 0.00% Total contractual services 10,600 10,600 9,856 14,186 13,238 (948) -6.68% Capital 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total expenses 22,620 22,620 26,398 26,185 25,199 (986) -3.77% Net change in fund balance 4,129 4,129 (800) - - - 0.00% Fund balance, beginning year 14,191 18,320 22,449 21,649 21,649 - 0.00% Fund balance, end of year 18,320 22,449 21,649 21,649 21,649 - 0.00% 90 Fund: 290 Recycling Grant Revenues Account Description 2009 2010 2011 2012 Description 3360 Other grants & aid 26,218 26,545 26,185 25,199 Estimated Ramsey County recycling grant 26,218 26,545 26,185 25,199 Fund: 290 Department: 4420 Operations 1600 Supplies, operatin 4,000 - - - 4,000 - - - 3030 Other professional services - - - - - - - - 3300 Postage 2,000 1,200 1,200 1,700 City wide mailing for Cleanup Day 2,000 1,200 1,200 1,700 3420 Advertisements 1,000 1,545 1,545 - Promotional items 1,000 1,545 1,545 - 3430 Printing 1,800 501 501 600 Articles in City newsletter 1,413 800 800 800 Clean-up Day printing of direct mailing items 3,213 1,301 1,301 1,400 3530 Refuse collection 6,000 10,500 10,140 10,138 Contractual services for City Cleanup Day 6,000 10,500 10,140 10,138 16,213 14,546 14,186 13,238 91 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent TIF # 1 (Fund 410): Revenues 3101 Tax collections 1,200,245 1,493,611 1,632,309 1,434,611 1,687,621 253,010 17.64% 3101 Tax collections - Mermaid 166,058 156,520 - - 0.00% 3102 Taxes - delinquent (113) - 0.00% 3103 Market value credit 951 1,022 1,130 - 0.00% 3610 Investment income 102,265 41,887 6,183 14,000 10,000 (4,000) -28.57% 3972 Transfer from other funds 40,747 - - 0.00% Total revenue 1,510,266 1,693,040 1,639,509 1,448,611 1,697,621 249,010 17.19% Operating expenses (4650): Contractual services 3030 Other professional 3,463 2,212 2,818 2,000 4,000 2,000 100.00% 5220 Highway 10 redevelopment 100,168 20,261 1,200 375,000 (375,000) -100.00% 7050 Construction 276,499 3,664,138 653,111 1,829,287 1,504,027 (325,260) -17.78% 8010 Developer PAG, principal 279,438 - 0.00% 9900 Transfers out to EDA 171,262 24,634 24,660 107,139 109,675 2,536 2.37% 9900 Transfers out to other funds - - - - - 0.00% Total contractual services 551,392 3,711,245 961,226 2,313,426 1,617,702 (695,724) -30.07% Net change in fund balance 958,874 (2,018,205) 678,283 (864,815) 79,919 944,734 -109.24% Fund balance, beginning year 1,646,368 2,605,242 587,037 1,265,320 400,505 (864,815) -68.35% Fund balance, end of year 2,605,242 587,037 1,265,320 400,505 480,424 79,919 19.95% 92 Fund: 410 TIF District #1 Revenues Account Description 2009 2010 2011 2012 Description 3101 Tax increment collections 1,213,988 1,213,988 1,434,611 1,493,611 Estimated collections of incremental taxes on properties in the district. 1,213,988 1,213,988 1,434,611 1,493,611 3101 Tax increment collections 156,520 178,838 - - Estimated collections of incremental taxes on the Mermaid 156,520 178,838 - - property which are dedicated to the 2001A TIF bonds. (bonds paid off) 3610 Interest income 40,000 10,000 14,000 10,000 Estimated interest earnings at 1.50%. 40,000 10,000 14,000 10,000 Fund: 410 Department: 4650 Economic Development 3030 Other professional services 1,000 1,000 2,000 4,000 TIF administration and reporting fees 1,000 1,000 2,000 4,000 5220 County Rd 10 redevelopment - - - - CR 10 trail segmentsj 9 - 10 - - - 5,000 CR 10/Silver Lake Rd Intersection (design) - 100,000 375,000 25,000 CR 10/CR H Intersection (preconstruction) - 100,000 375,000 30,000 7050 Construction 3,500,000 365,000 - - Area B & C Street project - 300,000 1,829,287 - Area D Street project (preconstruction) - - - 1,000,000 Area E Street project - - - 474,027 Area F Street project (preconstruction) 3,500,000 665,000 1,829,287 1,474,027 9900 Transfer out to EDA Fund 112,851 109,398 107,138 86,456 Transfer to cover the EDA operating budget. 112,851 109,398 107,138 86,456 9900 Transfer out to debt service - - - - Transfer to make debt service payments on TIF bonds 01A (Mermaid) - - - - 3,613,851 875,398 2,313,425 1,594,483 93 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent TIF # 2 (Fund 420): Revenues 3101 Tax collections 128,125 143,266 152,505 154,335 154,335 - 0.00% 3102 Tax collections - delinquent - 1,116 - - - - 0.00% 3103 Market value credit 730 765 638 - - - 0.00% 3610 Investment income 16,275 11,347 5,523 2,500 2,500 - 0.00% 3680 Other revenue 25 - - - - - 0.00% 3972 Transfer from other funds 60,978 - - - - - 0.00% Total revenue 206,133 156,494 158,666 156,835 156,835 - 0.00% Operating expenses (4650): Contractual services 3030 Other professional 1,375 1,240 1,559 1,200 2,000 800 66.67% 4750 Taxes, Licenses, & Fees - - - - - - 0.00% 7050 Construction - 165,734 - - - - 0.00% 8010 Developer PAG, principal 34,412 37,358 42,602 46,753 38,238 (8,515) -18.21% 9900 Transfers out to debt service/EDA 81,776 24,634 24,660 107,138 109,674 2,536 2.37% Total contractual services 117,563 228,966 68,821 155,091 149,912 (5,179) -3.34% Net change in fund balance 88,570 (72,472) 89,845 1,744 6,923 5,179 296.96% Fund balance, beginning year 337,428 425,998 353,526 443,371 445,115 1,744 0.39% Fund balance, end of year 425,998 353,526 443,371 445,115 452,038 6,923 1.56% 94 Fund: 420 TIF District #2 Revenues Account Description 2009 2010 2011 2012 Description 3101 Tax increment collections 146,436 151,698 154,335 138,330 Estimated collections of incremental taxes on properties 146,436 151,698 154,335 138,330 in the district. 3610 Investment income 11,250 2,500 2,500 2,500 Estimated interest earnings at 1.50%. 11,250 2,500 2,500 2,500 Fund: 420 Department: 4650 Economic Development 3030 Other professional services 1,200 1,200 1,200 2,000 TIF administration and reporting fees 1,200 1,200 1,200 2,000 7050 Construction 313,019 - - - 2009/2010 Street project 313,019 - - - 8010 Pay-as-you-go principal 36,264 38,452 46,753 38,238 Principal on a revenue note issued to promote a development. 36,264 38,452 46,753 38,238 (Silver Lake Point Project - Heartland MV Common Bond, LLC.) 9900 Transfer out to EDA Fund 112,851 109,397 107,138 86,456 Transfer to cover the EDA operating budget. 112,851 109,397 107,138 86,456 463,334 149,049 155,091 126,694 95 2012 Budget Summary 2008 2009 2010 2011 2012 Actual Actual Actual Budget Request Dollar Percent TIF # 3 (Fund 430): Revenues 3101 Tax collections 367,643 351,862 475,317 370,824 349,928 (20,896) -5.64% 3102 Tax collections - delinquent - - 69,085 - - - 0.00% 3610 Investment income 33,367 21,013 7,701 10,000 10,000 - 0.00% 3972 Transfer from other funds - - - - - - 0.00% Total revenue 401,010 372,875 552,103 380,824 359,928 (20,896) -5.49% Operating expenses (4650): Contractual services 3030 Other professional 915 987 920 1,200 2,000 800 66.67% 5220 Highway 10 redevelopment 95,413 723,906 66,208 - - - 0.00% 7050 Construction 1,484 - - 625,456 425,973 (199,483) -31.89% 8010 Developer PAG, principal 250,000 - - - - - 0.00% 8020 Developer PAG, interest 9,930 - - - - - 0.00% 9900 Transfers out to other funds - - - - - - 0.00% 9900 Transfers out to EDA 95,875 24,634 24,660 107,138 109,675 2,537 2.37% Total contractual services 453,617 749,527 91,788 733,794 537,648 (196,146) -26.73% Net change in fund balance (52,607) (376,652) 460,315 (352,970) (177,720) 175,250 -49.65% Fund balance, beginning year 894,170 841,563 464,911 925,226 572,256 (352,970) -38.15% Fund balance, end of year 841,563 464,911 925,226 572,256 394,536 (177,720) -31.06% Change from 2011 96 Fund: 430 TIF District #3 Revenues Account Description 2009 2010 2011 2012 Description 3101 Tax increment collections 394,056 328,408 370,824 349,928 Estimated collections of incremental taxes on properties 394,056 328,408 370,824 349,928 in the district. 3610 Investment income 22,500 12,500 10,000 10,000 Estimated interest earnings at 2.50%. 22,500 12,500 10,000 10,000 Fund: 430 Department: 4650 Economic Development 3030 Other professional services 1,200 1,200 1,200 2,000 TIF administration and reporting fees 1,200 1,200 1,200 2,000 7050 Construction - - 625,456 - Area E Street project (preconstruction) - - - 425,973 Area E Street project (construction) 750,000 - - - CR 10 trail segments 1 - 5 (H to Silver Lk Rd)(also in 285 grant portion) 750,000 - 625,456 425,973 (prepare plans and specs in 2008) 9900 Transfer out to EDA Fund 112,851 109,397 107,138 86,456 Transfer to cover the EDA operating budget. 112,851 109,397 107,138 86,456 864,051 110,597 733,794 514,429 97 2008 2009 2010 2011 2012 Actual Actual Actual Budget Request Dollar Percent TIF # 5 (Fund 450): Revenues 3101 Tax collections 674,255 1,565,044 1,287,696 1,320,408 1,208,260 (112,148) -8.49% 3610 Investment income 3,265 4,161 5,286 9,000 6,000 (3,000) -33.33% Total revenue 677,520 1,569,205 1,292,982 1,329,408 1,214,260 (115,148) -8.66% Operating expenses (4650): Contractual services 3030 Other professional 1,284 1,109 1,517 1,400 2,600 1,200 85.71% 8010 Developer PAG, principal 319,118 1,062,514 170,896 1,266,569 1,147,847 (118,722) -9.37% 8020 Developer PAG, interest - - 911,635 - - - 0.00% 9900 Transfers out to EDA 33,592 55,922 53,670 66,020 60,413 (5,607) -8.49% Total contractual services 353,994 1,119,545 1,137,717 1,333,989 1,210,860 (123,129) -9.23% Net change in fund balance 323,526 449,660 155,265 (4,581) 3,400 7,981 -174.22% Fund balance, beginning year - 323,526 773,186 928,451 923,870 (4,581) -0.49% Fund balance, end of year 323,526 773,186 928,451 923,870 927,270 3,400 0.37% 2012 Budget Summary Change from 2011 98 Fund: 450 TIF District #5 Revenues Account Description 2009 2010 2011 2012 Description 3101 Tax increment collections 846,270 1,139,960 1,320,408 1,208,260 Estimated collections of incremental taxes on properties 846,270 1,139,960 1,320,408 1,208,260 in the district. 3610 Investment income 6,300 6,300 9,000 6,000 Estimated interest earnings at 1.50%. 6,300 6,300 9,000 6,000 Fund: 430 Department: 4650 Economic Development 3030 Other professional services 1,200 1,200 1,400 2,600 TIF administration and reporting fees 1,200 1,200 1,400 2,600 8010 Pay-as-you-go principal 803,956 1,082,963 1,266,569 1,147,847 Principal on a revenue note issued to promote a development. (Medtronic) 803,956 1,082,963 1,266,569 1,147,847 9900 Transfer out to EDA Fund 42,313 56,997 66,020 60,413 Transfer to cover the EDA operating budget. 42,313 56,997 66,020 60,413 99 CITY OF MOUNDS VIEW, MINNESOTA Debt Service Funds 2012 Budgets Combining Statement of Revenues and Expenditures GO Improv. Bonds 2004A 2012 2011 Revenue: Taxes: Property taxes 190,892 190,892 190,553 Spec assess current 25,652 25,652 25,652 Miscellaneous: Investment income 3,000 3,000 8,750 Total revenue 219,544 219,544 224,955 Expenditures: Debt service: Principal 230,000 230,000 225,000 Interest 29,563 29,563 37,300 Paying agent fees 475 475 475 Continuing disclosure fees 1,500 1,500 1,500 Total expenditures 261,538 261,538 264,275 Surplus of revenue over (under) expenditures (41,994) (41,994) (39,320) Other financing sources: Operating transfers in - - - Total other financing sources - - - Net change in fund balance (41,994) (41,994) (39,320) Fund balance, January 1 338,668 377,989 417,309 Fund balance, December 31 296,674 335,995 377,989 Total 100 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent GO Improvement Bonds of 2004A Debt Service (Fund 505): Revenues 3101 Property taxes 186,903 186,427 178,567 190,553 190,892 339 0.18% 3550 Spec assess prepayments - - - - - - 0.00% 3551 Spec assess current 127,575 38,326 36,916 25,652 25,652 - 0.00% 3552 Spec assess delinquent - 1,041 - - - - 0.00% 3553 Spec assess penalty & int - 282 - - - - 0.00% 3610 Investment income 11,564 6,822 3,433 8,750 3,000 (5,750) -65.71% Total revenue 326,042 232,898 218,917 224,955 219,544 (5,411) -2.41% Operating expenses (4650): Contractual services 8010 Debt, principal 215,000 215,000 220,000 225,000 230,000 5,000 2.22% 8020 Debt, interest 57,239 51,058 44,423 37,300 29,563 (7,737) -20.74% 8030 Paying agent 431 431 431 475 475 - 0.00% 8040 Continuing disclosure 982 1,138 1,164 1,500 1,500 - 0.00% Total contractual services 273,652 267,627 266,018 264,275 261,538 (2,737) -1.04% Net change in fund balance 52,390 (34,729) (47,101) (39,320) (41,994) (2,674) 6.80% Fund balance, beginning year 407,428 459,818 425,089 377,988 338,668 (39,320) -10.40% Fund balance, end of year 459,818 425,089 377,988 338,668 296,674 (41,994) -12.40% 2012 Budget Summary 101 THIS PAGE LEFT BLANK INTENTIONALLY 102 CITY OF MOUNDS VIEW, MINNESOTA Capital Project Funds 2012 Budgets Combining Statement of Revenues and Expenditures Special Street Park Vehicle and Projects Improvement Dedication Equipment 2012 2011 Revenue: Taxes -$ 300,000$ -$ -$ 300,000$ 300,000$ Franchise fees - 253,000 - - 253,000 249,900 Special assessments - 20,000 - - 20,000 - Intergovernmental: State - 578,000 - - 578,000 578,000 Federal - - - - - - Miscellaneous: Investment income 10,000 72,500 10,000 - 92,500 132,000 Other - - 6,000 - 6,000 6,000 Total revenue 10,000 1,223,500 16,000 - 1,249,500 1,265,900 Expenditures: General government 522,000 - - 59,300 581,300 442,000 Public safety - - 110,000 110,000 - Streets and highways 1,078,280 - - 1,078,280 767,000 Culture and recreation - 235,500 - 235,500 310,000 Total expenditures 522,000 1,078,280 235,500 169,300 2,005,080 1,519,000 Excess (deficiency) of revenue over expenditures (512,000) 145,220 (219,500) (169,300) (755,580) (253,100) Other financing sources (uses) Operating transfers Transfers in - 300,000 - 185,000 485,000 300,000 Transfers out (90,000) - - (300,340) (390,340) (90,000) Net change in fund balance (602,000) 445,220 (219,500) (284,640) (660,920) (43,100) Fund balance, January 1 803,352 7,651,051 626,562 1,943,112 11,024,077 7,079,551 Fund balance, December 31 201,352$ 8,096,271$ 407,062$ 1,658,472$ 10,363,157$ 7,036,451$ Total Budget 103 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Special Projects (Fund 480): Revenues 3551 Spec assessmt current 3,591 - - - 0.00% 3552 Spec assessmt delinquent - 73 48 - 0.00% 3553 Spec assessmt penalty & interest - 12 18 - 0.00% 3610 Investment income 64,034 28,276 19,322 17,000 10,000 (7,000) -41.18% 3680 Other revenue 126 - - - 0.00% 3972 Transfers in - - - - 0.00% Total revenue 67,751 28,361 19,388 17,000 10,000 (7,000) -41.18% Operating expenses Operations (4180): Contractual services 3030 Other professional services 22,260 1,116 11,475 10,000 10,000 - 0.00% 5130 Repairs; Equipment 140 - - - - - 0.00% Total contractual services 22,400 1,116 11,475 10,000 10,000 - 0.00% Capital 7030 Capital equipment 27,092 84,949 - 90,000 - (90,000) -100.00% 7050 Construction 31,379 6,977 18,830 342,000 512,000 170,000 49.71% Total capital outlays 58,471 91,926 18,830 432,000 512,000 80,000 18.52% Other 9900 Transfer out 90,000 - - 90,000 90,000 - 0.00% Total other 90,000 - - 90,000 90,000 - 0.00% Total expenses 170,871 93,042 30,306 532,000 612,000 80,000 15.04% Net change in fund balance (103,120) (64,681) (10,917) (515,000) (602,000) (87,000) 16.89% Fund balance, beginning year 1,497,071 1,393,951 1,329,270 1,318,352 803,352 (515,000) -39.06% Fund balance, end of year 1,393,951 1,329,270 1,318,352 803,352 201,352 (602,000) -74.94% 104 Fund: 480 Special Projects Revenues Account Description 2009 2010 2011 2012 Description 3610 Investment income 45,000 30,000 17,000 10,000 Estimated interest earnings at 2.00%. 45,000 30,000 17,000 10,000 Fund: 480 Department: 4180 Expenditures 3030 Other professional services - - - - Ramsey County fee for spec. ass. adm. - - 10,000 10,000 Scanning of microfilm to laserfiche - - 10,000 10,000 7030 Capital, equipment 7,500 - - - Purchase copier (1) lease expires in July 2009 25,000 25,000 25,000 - Community center furniture replacement - - 65,000 - Alternative Power Supply Project (City Hall generator for EOC) 32,500 25,000 90,000 - 7050 Construction - 30,000 - 30,000 Community center parking lot improvements - 15,000 - - Lambert Park building (preconstruction)(50% in Park Dedication) - - 13,000 - City Hall irigation project (postponed from 08) - - 30,000 - Edgewood Dr. boulevard project (carryover from 2007) 104,000 104,000 104,000 104,000 Pathway construction program 50,000 50,000 - - Emergency power Supply PW generator city hall wiring (carryover from 09) 65,000 65,000 - 65,000 Community center energy improvements (carryover from 09) 120,000 120,000 - - PW shop intermediate rehabilitation (carryover from 09) 40,000 40,000 20,000 20,000 Pathway rehabilitation program 6,500 - - - Community Center Copier (lease expires 5/09) - - - 250,000 Community Center roof replacement/repair - - 175,000 - City Hall roof replacement/repair 385,500 424,000 342,000 469,000 9900 Transfer to General Fund 90,000 90,000 90,000 90,000 90,000 90,000 90,000 90,000 105 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Street Improvement (Fund 485): Revenues 3101 Property taxes - - 279,586 300,000 300,000 - 0.00% 3180 Franchise fee 283,796 235,002 225,581 249,900 253,000 3,100 1.24% 3319 Other federal grants - 463,438 40,761 630,000 (630,000) -100.00% 3352 MSA street construction - 1,157,743 425,115 383,000 383,000 - 0.00% 3359 Other state grants - - - 495,000 195,000 (300,000) -60.61% 3360 Other county grant - 216,973 - - 0.00% 3550 Spec assessmt prepayment - 209,822 20,127 20,000 20,000 #DIV/0! 3610 Investment income 122,387 106,092 82,329 100,000 72,500 (27,500) -27.50% 3680 Other revenue 14,130 42,369 25,377 - - - 0.00% 3972 Transfer from other funds 100,000 280,000 300,000 300,000 300,000 - 0.00% Total revenue 520,313 2,711,439 1,398,876 2,457,900 1,523,500 (934,400) -38.02% Operating expenses Operations (4470): Contractual services 3030 Other professional services 144,953 99,508 259 - - - 0.00% 3810 Special assessment refunds 110,391 3,818 - - - - 0.00% 5130 Repair - - - - - - 0.00% Total contractual services 255,344 103,326 259 - - - 0.00% Capital 7050 Construction 325,219 572,522 160,424 767,000 1,078,280 311,280 40.58% Total capital outlays 325,219 572,522 160,424 767,000 1,078,280 311,280 40.58% Total expenses 580,563 675,848 160,683 767,000 1,078,280 311,280 40.58% Net change in fund balance (60,250) 2,035,591 1,238,193 1,690,900 445,220 (1,245,680) -73.67% Fund balance, beginning year 2,746,616 2,686,366 4,721,957 5,960,151 7,651,051 1,690,900 28.37% Fund balance, end of year 2,686,366$ 4,721,957$ 5,960,151$ 7,651,051$ 8,096,271$ 445,220$ 5.82% 106 Fund: 485 Street Improvement Revenues Account Description 2009 2010 2011 2012 Description 3101 Property taxes - 300,000 300,000 300,000 General tax levy for streets - 300,000 300,000 300,000 3180 Franchise fee 290,625 287,000 249,900 253,000 Half of the 3.87% franchase fee on gas & electric utilities 290,625 287,000 249,900 253,000 3319 Other federal grants 525,000 - - - Federal trails grant - - 630,000 630,000 Federal safety grant for Cty H intersection(2011) 525,000 - 630,000 630,000 3352 MSA Street Construction 1,374,090 365,000 383,000 383,000 State aid funds 1,374,090 365,000 383,000 383,000 3359 Other state grants - - 300,000 300,000 MNDOT Coop Agreement (2011 H and Cty 10 intersection project) - - 70,000 70,000 Ramsey Cty CSAH (2010 H and Cty 10 intersection project) - - 125,000 125,000 CR 10 Turnback Funds (2010 H and Cty 10 intersection project) - - 495,000 495,000 3610 Investment income 93,750 72,500 100,000 72,500 Estimated interest earnings at 1.5%. 93,750 72,500 100,000 72,500 3972 Transfer in 280,000 300,000 300,000 300,000 Transfers from utility funds (water 100,000, sewer 160,000, storm 40,000) 280,000 300,000 300,000 300,000 Fund: 485 Department: 4470 Expenditures 3030 Other professional services - - - - - - - - 7050 Construction 900,000 - - - 2009/2010 Project ($4,313,019 in TIF funds) - 547,000 - - 2010 Area B&C Street & Utility project - - - - 2011 Area D Street & Utility project - - 417,000 - 2012 Area E Street & Utility project - - - 778,280 2013 Area F Street & Utility project 300,000 - 350,000 300,000 Mill and overlay (Mustang Drive)(move to 2011)(50,000 in utility funds) - - - - Cty Rd H intersection safety improvements (move to 2012) 525,000 - - - Trail segments 1 - 5 - - - - Seal coat project 1,725,000 547,000 767,000 1,078,280 107 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Park Dedication (Fund 451): Revenues 3610 Investment income 37,535 20,320 13,353 15,000 10,000 (5,000) -33.33% 3650 Park donations 1,000 2,664 39,969 - 0.00% 3652 Park dedication fees 18,239 1,800 - 6,000 6,000 - 0.00% Total revenue 56,774 24,784 53,322 21,000 16,000 (5,000) -23.81% Operating expenses Operations (4470): Materials & supplies 1600 Supplies, operating 549 - - - - - 0.00% Total materials & supplies 549 - - - - - 0.00% Contractual services 3030 Other professional services - - 615 - - - 0.00% Total contractual services - - 615 - - - 0.00% Capital 7050 Construction 45,322 5,986 46,811 310,000 235,500 (74,500) -24.03% Total capital outlays 45,322 5,986 46,811 310,000 235,500 (74,500) -24.03% Total expenses 45,871 5,986 47,426 310,000 235,500 (74,500) -24.03% Net change in fund balance 10,903 18,798 5,896 (289,000) (219,500) 69,500 -24.05% Fund balance, beginning year 879,965 890,868 909,666 915,562 626,562 (289,000) -31.57% Fund balance, end of year 890,868$ 909,666$ 915,562$ 626,562$ 407,062$ (219,500)$ -35.03% 108 Fund: 451 Park Dedication Fund Revenues Account Description 2009 2010 2011 2012 Description 3610 Investment income 30,000 20,000 15,000 10,000 Estimated interest earnings at 1.50%. 30,000 20,000 15,000 10,000 3652 Park dedication fees 6,000 6,000 6,000 6,000 Developer payments 6,000 6,000 6,000 6,000 Fund: 451 Department: 4470 Expenditures 7050 Construction - 15,000 - - Lambert Park building (preconstruction)(50% in Spec. Projects Fund) - - 260,000 35,000 Lambert Park building (construction) - - 40,000 - Relocate Lambert ballfield to accomodate reconfigured building site. - - 10,000 - Hillview hockey rink expansion and grading - - - 4,500 Reconstruct irrigation controls at Silverview Park - - - 100,000 Replace playground equipment - Silverview Park - - - 13,000 PIP - Security lighting Imp. - Greenfield & Groveland Parks - - - 8,000 PIP - Replace playground media - City Hall Park - 25,000 - - Groveland & Hillview drainage and irrigation improvements 8,000 - - - Playground media 25,000 25,000 - 25,000 Park Improvement Program (PIP) 20,000 - - - Groveland & Hillview baseball field rehab project (carryover Groveland) 10,000 - - - Groveland baseball field backstop (carryover to 2009) 32,000 - - - Hillview Parking Area 20,000 - - - Greenfield Park open space 115,000 65,000 310,000 185,500 109 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Vehicle & Equipment (Fund 460): Revenues 3610 Investment income - - - - - - 0.00% 3972 Transfers in - General fund 175,000 175,000 50,000 50,000 75,000 25,000 50.00% 3972 Transfers in - Water Fund 20,000 20,000 20,000 20,000 58,000 38,000 190.00% 3972 Transfers in - Sewer Fund 36,000 36,000 36,000 36,000 36,000 - 0.00% 3972 Transfers in - Storm Water Fund 6,000 6,000 16,000 16,000 16,000 - 0.00% Total revenue 237,000 237,000 122,000 122,000 185,000 63,000 51.64% Operating expenses Operations (4160): Contractual services 0.00% 3030 Other professional services - - - - - - 0.00% Total contractual services - - - - - - 0.00% Capital 7010 Buildings - - - - - - 0.00% 7030 Equipment - - - - 59,300 59,300 #DIV/0! 7040 Vehicles - - - - 110,000 110,000 #DIV/0! 7050 Construction - - - - - - 0.00% Total capital outlays - - - - 169,300 169,300 #DIV/0! Other 9900 Transfer out - General Fund 117,250 44,000 13,319 65,600 11,340 (54,260) -82.71% 9900 Transfer out - Water Fund - - - - 289,000 289,000 #DIV/0! 9900 Transfer out - Sewer Fund - - - 330,000 (330,000) -100.00% 9900 Transfer out - Storm Water Fund - - - 40,000 (40,000) -100.00% Total other 117,250 44,000 13,319 435,600 300,340 (135,260) -31.05% Total expenses 117,250 44,000 13,319 435,600 469,640 34,040 7.81% Net change in fund balance 119,750 193,000 108,681 (313,600) (284,640) 28,960 -9.23% Fund balance, beginning year 1,835,281 1,955,031 2,148,031 2,256,712 1,943,112 (313,600) -13.90% Fund balance, end of year 1,955,031 2,148,031 2,256,712 1,943,112 1,658,472 (284,640) -14.65% 110 Fund: 460 Vehicle & Equipment Fund Revenues Account Description 2009 2010 2011 2012 Description 3610 Interest income - - - - Estimated interest earnings (moved to general fund per council 08) - - - - 3961 Transfers in 175,000 50,000 75,000 75,000 From General Fund 20,000 20,000 58,000 58,000 From Water Fund 36,000 36,000 36,000 36,000 From Sanitary Sewer Fund 16,000 16,000 16,000 16,000 From Storm Water Fund 247,000 122,000 185,000 185,000 Fund: 460 Department: 4160 Operations 7030 Equipment - - - 18,000 11 computers, software and network hardware reduce from $23,000. - - - 7,000 Squad mobile computers (2), light bar, - - - 4,800 radar $2,800, light bar $2,000 - - - 15,000 Air compressor (1/2 parks 1/2 pavement mgt.) - - - 4,500 Brine solution equipment - - - 4,000 Replace City Hall entrance lights - - - 53,300 7040 Equipment - - - 29,000 1 vehicle $23,000 and set-up $6,000 - - - - - - - 29,000 9900 Transfers out 25,000 25,000 23,000 - 11 computers, software and network hardware reduce from $25,000. 68,500 40,600 30,200 - 1 vehicle $29,000, radar $1,200, light bar $2,000, digital equip. $3,000 - - 22,894 11,340 Fire equipment per SBM 32,000 - 66,000 - Parks Pick-up $36,000, wood chipper $24,000, pick-up plow $6,000 - - 140,000 - PW plow truck 40,000 - 45,000 - PW boom truck - - 6,000 - Plow for pick-up - - 289,000 289,000 Water Tower major maintenance 330,000 330,000 300,000 - Sewer - Vactor 40,000 40,000 40,000 - Storm Water - truck (carryover from 2007) 535,500 435,600 962,094 300,340 111 THIS PAGE LEFT BLANK INTENTIONALLY 112 CITY OF MOUNDS VIEW, MINNESOTA Enterprise Funds 2012 Budgets Combining Statement of Revenues and Expenses Sanitary Street Storm Water Sewer Lighting Water 2012 2011 Operating revenue: Operating revenues 791,552 1,257,470 75,500 250,718 2,375,240 2,325,376 Special assessments 50,000 - - - 50,000 50,000 Connection charges - 300 - - 300 300 Tower rental - - - - - - Other income - 4,000 - - 4,000 4,000 Total operating revenue 841,552 1,261,770 75,500 250,718 2,429,540 2,379,676 Operating expenses: Personal services 314,894 294,971 3,661 87,090 700,616 672,928 Supplies 75,541 24,070 - 21,175 120,786 108,615 Contractual services 157,639 95,289 3,900 47,425 304,253 443,929 Electricity & gas 87,000 2,100 73,000 - 162,100 163,100 Disposal charges - 760,913 - - 760,913 776,066 Contingency 15,000 15,000 - - 30,000 30,000 Depreciation 240,000 160,000 - 32,000 432,000 417,000 Capital outlays 1,149,900 163,500 - 117,000 1,430,400 1,618,700 Total operating expenses 2,039,974 1,515,843 80,561 304,690 3,941,068 4,230,338 Net operating income (loss)(1,198,422) (254,073) (5,061) (53,972) (1,511,528) (1,850,662) Non-operating revenue (expenses): Investment income 31,250 45,000 2,000 22,000 100,250 115,250 Principal payment on debt (215,000) - - - (215,000) (210,000) Interest expense (11,705) - - - (11,705) (18,825) Bond fees / discounts (1,975) - - - (1,975) (2,625) Total non-operating (197,430) 45,000 2,000 22,000 (128,430) (116,200) Transfers Transfers in 289,000 - - - 289,000 659,000 Transfers out (223,410) (247,807) (2,320) (62,756) (536,293) (526,055) Revenues over (under) expenditures (1,330,262) (456,880) (5,381) (94,728) (1,887,251) (1,833,917) Add back: Capital outlays 1,149,900 163,500 - 117,000 1,430,400 1,618,700 Principal on debt 215,000 - - - 215,000 210,000 Net income (loss)34,638 (293,380) (5,381) 22,272 (241,851) (5,217) Net assets (deficit), January 1 4,542,758 5,622,469 151,365 2,914,977 13,231,568 12,746,992 Net assets (deficit), December 31 4,577,396$ 5,329,089$ 145,984$ 2,937,249$ 12,989,717$ 12,741,775$ Total 113 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Water (Fund 700): Revenues 3424 Meter charge 1,859 2,451 - - - - 0.00% 3426 Reimbursed staff time - 357 - - - - 0.00% 3551 Spec assessments-current 34,719 38,321 59,806 50,000 50,000 - 0.00% 3552 Spec assessments-delinquent 7,300 31,639 17,264 - - - 0.00% 3553 Spec assess.-penalty & interest 464 1,559 1,059 - - - 0.00% 3610 Investment income 72,980 33,770 20,946 31,250 31,250 - 0.00% 3631 Water tower space rental 60,390 62,832 62,539 - - - 0.00% 3680 Other revenues 2,939 788 7,214 2,000 2,000 - 0.00% 3710 Water sales 683,665 683,987 676,858 737,052 737,052 - 0.00% 3714 Water service fee 47,587 50,547 52,092 51,500 51,500 - 0.00% 3715 Utility connections 805 480 420 1,000 1,000 - 0.00% 3716 Penalties 8,561 8,594 7,119 - - - 0.00% 3913 Meter sales 1,020 763 4,090 - - - 0.00% WAC/SWM charges 1,200 2,900 500 - - - 0.00% 3940 Capital Contributions - 42,475 - - 0.00% 3972 Transfers - Vehicle & Equip - - - 289,000 289,000 - 0.00% Total revenue 923,489 961,463 909,907 1,161,802 1,161,802 - 0.00% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 30,751 33,262 33,133 33,058 36,690 3,632 10.99% 0110 Salaries, overtime 67 7 - - - - 0.00% 0300 Social security 2,325 2,360 2,369 2,529 2,806 277 10.95% 0321 PERA 1,895 2,196 2,282 2,396 2,660 264 11.02% 0400 Group insurance 2,389 2,803 2,983 4,387 5,260 873 19.90% 0500 Workers compensation 138 168 196 222 244 22 9.91% 0990 Severance - - - - 0.00% Total personnel services 37,565 40,796 40,963 42,592 47,660 5,068 11.90% Materials & supplies 1600 Supplies, operating - 4 - 50 (50) -100.00% Total materials & supplies - 4 - 50 - (50) -100.00% Contractual services 3030 Other professional services 8,015 6,334 6,476 7,815 8,280 465 5.95% 3300 Postage 2,974 2,710 2,996 3,256 3,256 - 0.00% 3430 Printing 1,093 680 980 900 900 - 0.00% 3630 Training - - 79 250 250 - 0.00% 5130 Repairs, equipment 2,737 3,128 3,063 3,332 3,498 166 4.98% Total contractual services 14,819 12,852 13,594 15,553 16,184 631 4.06% Debt Service: 8010 Principal 190,000 200,000 205,000 210,000 215,000 5,000 2.38% 8020 Interest 35,325 29,350 22,837 18,825 11,705 (7,120) -37.82% 8030 Paying agent fees 431 431 431 475 475 - 0.00% 8040 Continuing disclosure 1,675 1,138 1,164 2,150 1,500 (650) -30.23% Total capital outlays 227,431 230,919 229,432 231,450 228,680 (2,770) -1.20% Miscellaneous: 9900 Transfers out to General Fund 58,115 59,859 61,655 63,505 65,410 1,905 3.00% 9900 Transfers out to Vehicle Fund 20,000 20,000 20,000 58,000 58,000 - 0.00% Total capital outlays 78,115 79,859 81,655 121,505 123,410 1,905 1.57% Total Billing 357,930 364,430 365,644 411,150 415,934 4,784 1.16% 2012 Budget Summary 114 Fund: 700 Department: 4820 Billing Services Account Description 2009 2010 2011 2012 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 6,300 6,435 6,615 6,705 22.5% of audit fee 800 800 800 800 Inserting & mailing bills 400 400 400 400 Legal services - - - 375 Annual maintenance (meter reading software)(50% sewer, 50% Water) 7,500 7,635 7,815 8,280 3300 Postage 2,688 2,816 2,816 2,816 3200 bills X $0.44 postage X 4 billings X 1/2 cost 357 374 440 440 Late notices: 500 bills X $0.44 postage X 4 billings X 1/2 cost 3,045 3,190 3,256 3,256 3430 Printing 450 450 450 450 Utility bills (1/2 cost) 450 450 450 450 Envelopes 900 900 900 900 3630 Training 250 250 250 250 Seminars on new regulations, software updates, etc. INCODE training 250 250 250 250 Defer INCODE Training to future year $1,000 5130 Repairs, equipment 2,717 2,885 3,029 3,180 INCODE software support (30%) - 289 303 318 Handheld interface support for new meter readers (50% water 50% sewer) 2,717 3,174 3,332 3,498 8010 Principal 200,000 205,000 210,000 215,000 Principal due on bonds 200,000 205,000 210,000 215,000 8020 Interest 31,850 25,570 18,825 11,705 Interest due on 2002 A Bonds 31,850 25,570 18,825 11,705 8030 Paying agent fees 475 475 475 475 Paying agent fees on bond issues 475 475 475 475 8040 Continuing Disclosure 2,150 2,150 2,150 1,500 Annual debt disclosure requirements and Ramsey county sp. Assmt. Fees 2,150 2,150 2,150 1,500 9900 Transfers out 59,859 61,655 63,505 65,410 Transfer to General Fund for administrative overhead costs 20,000 20,000 57,000 58,000 Transfer to Vehicle & Equipment Fund to fund future purchases 79,859 81,655 120,505 123,410 328,796 330,049 367,558 368,324 115 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Water (Fund 700): 2012 Budget Summary Infrastructure & Equip Maintenance (4823): Personnel services 0100 Salaries, regular 159,180 153,144 165,318 168,844 173,363 4,519 2.68% 0110 Salaries, overtime 15,168 15,195 7,360 9,002 9,182 180 2.00% 0150 Salaries, part-time 11,667 16,474 13,449 18,475 18,475 - 0.00% 0300 Social security 13,735 12,845 13,028 15,019 15,377 358 2.38% 0321 PERA 9,974 11,637 11,990 13,176 13,518 342 2.60% 0400 Group insurance 21,482 25,145 28,231 28,828 31,130 2,302 7.99% 0500 Workers compensation 4,174 5,048 5,760 6,141 6,189 48 0.78% Total personnel services 235,380 239,488 245,136 259,485 267,234 7,749 2.99% Materials & supplies 1210 Supplies, bldg & grnds 1,668 3,174 1,210 5,300 5,300 - 0.00% 1220 Supplies, vehicles 191 593 442 800 800 - 0.00% 1230 Supplies, equipment 264 1,579 1,181 818 818 - 0.00% 1240 Supplies, streets 2,349 1,247 1,652 5,000 5,000 - 0.00% 1250 Supplies, utilities 9,786 5,902 10,163 11,750 14,250 2,500 21.28% 1260 Supplies, traffic control - 38 - 200 200 - 0.00% 1600 Supplies, operating 3,169 6,751 3,307 4,300 4,300 - 0.00% 1700 Motor fuels 8,383 2,832 5,635 4,800 5,850 1,050 21.88% 2400 Uniforms 1,021 1,239 1,043 1,380 1,475 95 6.88% 2410 Mats & towels 1,140 1,427 1,266 800 1,620 820 102.50% Total materials & supplies 27,971 24,782 25,899 35,148 39,613 4,465 12.70% Contractual services 3030 Other professional services 470 8,272 4,824 12,350 5,830 (6,520) -52.79% 3100 Communications - telephone 4,515 1,909 2,211 1,780 2,060 280 15.73% 3200 Water & wastewater charges 7,002 8,030 7,846 5,000 6,000 1,000 20.00% 3220 Natural gas 11,964 10,792 6,292 12,000 10,000 (2,000) -16.67% 3610 Memberships 280 261 265 353 440 87 24.65% 3630 Training 896 943 844 2,650 3,940 1,290 48.68% 4010 Equipment rental 331 2,458 1,927 4,500 4,500 - 0.00% 4800 Insurance 8,378 8,700 8,290 10,230 10,230 - 0.00% 5130 Repairs, equipment 5,738 6,309 13,430 2,500 1,250 (1,250) -50.00% 5140 Repairs, streets 3,700 12,500 18,219 10,000 10,000 - 0.00% 5150 Repairs, utilities 2,138 6,337 7,468 1,800 1,800 - 0.00% 5155 Water service repair 55,824 41,271 32,654 50,000 50,000 - 0.00% 5160 Repairs, system maintenance 980 2,650 5,107 15,000 15,000 - 0.00% Total contractual services 102,216 110,432 109,377 128,163 121,050 (7,113) -5.55% Capital outlays 7030 Equipment - - - 28,500 52,200 23,700 83.16% 7050 Construction - - - 1,212,700 1,097,700 (115,000) -9.48% 7950 Depreciation 209,839 230,375 229,199 225,000 240,000 15,000 6.67% Total capital outlays 209,839 230,375 229,199 1,466,200 1,389,900 (76,300) -5.20% Miscellaneous: 9100 Contingency - - - 15,000 15,000 - 0.00% 9900 Transfer to Street Fund 30,000 90,000 100,000 100,000 100,000 100,000 100.00% Total miscellaneous 30,000 90,000 100,000 115,000 115,000 100,000 86.96% Total infrastructure & equip maint 605,406 695,077 709,611 2,003,996 1,932,797 28,801 1.44% 116 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2009 2010 2011 2012 Description 1210 Supplies, Bldgs & grounds 100 100 100 100 Mops, buckets, brooms 900 600 600 600 Light tubes & ballasts 200 200 200 200 Paper products 200 200 200 200 Paint, thinner, & brushes 250 500 2,500 2,500 Black dirt & sod/seed, landscaping materials 500 500 500 500 Misc. cleaners for well houses & % of shop 400 400 400 400 Fertilizer/seed/weed control 700 500 500 500 Irrigation parts 600 300 300 300 Goose repellent 3,850 3,300 5,300 5,300 1220 Supplies, vehicles 200 200 200 200 Air, oil, fuel, & transmission filters 100 100 100 100 Fluids 100 100 100 100 Batteries 50 50 50 50 Paint sealant 150 150 150 150 Tune ups 200 200 200 200 Misc repairs 800 800 800 800 1230 Supplies, equipment 100 100 100 100 Tune ups 300 100 100 100 Grounds maintenance equipment 150 100 100 100 Blades, suction hoses, filter screens 168 168 168 168 Hydraulic fluid: 35 gallons @ $4.80 / gallon 220 200 200 200 Solvents & cleaning fluids 200 150 150 150 Air, oil, fuel, & trans filters 1,138 818 818 818 1240 Supplies, streets 3,000 3,000 5,000 5,000 Asphalt/concrete/sod/seed for patching minor street,curb, driveway repairs. 3,000 3,000 5,000 5,000 1250 Supplies, utilities 150 150 150 150 Air compresser & dehumidifier parts 500 500 2,500 5,000 Meter batteries (200 @ $25) 500 500 500 500 Paint & sandblasting materials for hydrants 500 500 500 500 Copper, steel & PVC pipe 600 1,200 - - Location flags & paint (moved to account 1600) 650 650 2,100 2,100 Chemical equipment parts (flouride pumps) 1,500 1,500 1,500 1,500 Valve box risers, main repair clamps 2,000 1,000 1,000 1,000 Hydrant markers 2,500 1,500 1,500 1,500 Hydrant repair parts & used hydrants - - 2,000 2,000 Meter supplies, etc. (move from account 1600) 850 - - - Metal locator replacement 9,750 7,500 11,750 14,250 1260 Supplies, traffic control 200 200 200 200 Traffic cones / safety vests 200 200 200 200 1600 Supplies, operating 500 500 500 500 Propane, acetylene & oxygen supplies 400 400 400 400 Gloves, masks, & rags 650 650 650 650 Film, first aid supplies, & batteries - - 1,500 1,500 Location flags & paint (moved from account 1250) 250 250 250 250 Cleaning supplies 1,000 1,000 1,000 1,000 Additional & replacement hand tools 500 500 - - Meter supplies, etc. (move to account 1250) 3,300 3,300 4,300 4,300 1700 Motor fuels & lubs 213 188 375 450 Diesel fuel - 100 gallons @ $4.50 300 300 200 200 Propane: 50 gallons @ $4 4,875 4,225 4,225 5,200 Unleaded fuel: 1,300 gallons @ $4.00 5,388 4,713 4,800 5,850 2400 Uniforms 1,380 1,380 1,380 1,475 Uniforms 19% of $6,000 and clothing 1.9 FTE x $175 per contract 1,380 1,380 1,380 1,475 2410 Mats & towels 800 800 800 1,620 Share of floor mats & shop towels (19% of $8,500) 800 800 800 1,620 3030 Other professional services 1,400 1,400 1,400 180 Backflow prevention testing (3 @ $60 per test) - - 3,000 - Water system leak survey (every 2 years, 2013) 5,000 - - - Water tower evaluation - - 200 200 Fire sprinkler inspections/testing - - - 200 Fire extinguisher inspection/servcie (10 @ $20) 2,000 2,750 2,750 2,750 Gopher State One-call locates 3,000 10,000 5,000 2,500 Arcview/GIS base map consulting 11,400 14,150 12,350 5,830 3100 Communications - telephone 400 400 400 400 Service & repair 1,200 1,200 1,200 1,570 Cellular phone service (18.5% of $8,500) 80 80 80 - On call pager (half water / half sewer) - - 100 90 800 Mhz license fee (33%)(5 radios @ $4.48 per month) 1,680 1,680 1,780 2,060 3200 Water and wastewater charges 5,000 5,000 5,000 6,000 5,000 5,000 5,000 6,000 117 THIS PAGE LEFT BLANK INTENTIONALLY 118 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2009 2010 2011 2012 Description 3220 Natural gas 12,000 12,000 12,000 10,000 Heating fuel 12,000 12,000 12,000 10,000 3610 Memberships 200 113 113 150 American Public Works Association (APWA)(25% of $600) 195 195 100 100 MN Rural Water Association (50%) 65 65 80 80 MN Safety Council (19% of $405) - - - 50 Suburban Utility Superintendant Association (SUSA)(50% of $100) 60 60 60 60 Pressurized vessel license 520 433 353 440 3630 Training 600 600 - - Collection operator's seminar 250 250 250 250 Computer training/webinars 200 200 200 - Confined space safety seminar - - - 1,200 Trench safety training (on-site)(not annual) 120 120 120 110 Hearing test/R2K (2.15 FTE * $50) 50 50 50 - License renewal 60 60 60 60 Maintenance Expo 160 160 800 820 Water operator class/exam/certificate ($205 per person) 200 200 200 200 Misc. training seminars - - - 390 Equipment operator training 400 400 200 200 MRWA workshops 200 125 150 150 MN Public Works Assoc workshop 560 560 560 560 Tuition reimbursement 60 60 60 - Work zone safety seminar (every 3 years) 2,860 2,785 2,650 3,940 4010 Rental, equipment 2,500 2,500 3,500 3,500 Skid steer - upgrade 600 600 600 600 Barricades & signs 400 400 400 400 Tools & equipment 300 300 - - Fax machine 3,800 3,800 4,500 4,500 4800 Insurance 10,230 10,230 10,230 10,230 Share of property/liability insurance 10,230 10,230 10,230 10,230 5130 Repairs, equipment 1,000 1,000 1,000 100 Chemical pump repairs 250 250 - - Copier maintenance 350 350 350 - Fire extinguisher recharge / repair (moved to 3030) 1,000 1,000 1,000 1,000 Miscellaneous repairs 200 200 - - Sprinkler inspections - Well #3 (moved to account 3030) 150 150 150 150 Radio repairs 2,950 2,950 2,500 1,250 5140 Repairs, streets 10,000 10,000 10,000 10,000 Contractor repairs to streets after water main breaks 10,000 10,000 10,000 10,000 5150 Repairs, utilities 800 800 800 800 RTU panel repairs 1,000 1,000 1,000 1,000 Electrical modifications & repairs 900 900 - - Floride tanks for each well house (every 3 years) 2,500 2,500 - - Leak survey (moved to account 3030) 5,200 5,200 1,800 1,800 5155 Water service repairs 45,000 50,000 50,000 50,000 Contractor repairs to residential water services. 45,000 50,000 50,000 50,000 5160 System maintenance 13,000 13,000 13,000 12,500 Building repairs 2,000 2,000 2,000 2,500 Water system maintenance & repair items 15,000 15,000 15,000 15,000 7030 Capital, equipment 8,000 8,000 8,000 8,000 Gate valves - 5,000 5,000 - GPS Locating Equipment (Sewer 5,000)(carryover from 2010) - 125,000 - - Booster station - - 10,500 10,500 Plate compactor for backhoe - - - 8,500 Trench box - - 5,000 SCADA System upgrade Phase #2 well #6 20,000 - - - Generator (trailer mounted)(20,000 to water and 10,000 to sanitary sewer) - - - 19,000 Chemical feed equipment (WTP #2 & 3) - - - 3,200 Dehumidifier (well #6) - - - 1,200 Laptop and mounting bracket for infield use of record drawings - - - 1,800 Hydrant diffuser 28,000 138,000 28,500 52,200 7050 Construction 90,000 - - - Water system upgrades in conjunction with major roadway program 10,000 - 800,000 700,000 Water tower rehabilitation 2011 - $800,000 - 100,000 75,000 Well #2 motor replacement (carryover from 2010) - 22,700 22,700 22,700 Well #1,2,3 building repairs (int. and exterior repairs)(carryover from 10,11) - 211,000 250,000 250,000 Reservoir & booster station building and roof repairs (carryover from 10,11) - - 65,000 50,000 Roof replacement well #1 - 60,000 - 75,000 Well pump rehabilitation project (wells no. 3&5) 100,000 393,700 1,212,700 1,097,700 7950 Depreciation 220,000 215,000 225,000 240,000 Estimated depreciation 220,000 215,000 225,000 240,000 9100 Contingency 15,000 15,000 15,000 15,000 Contingency 15,000 15,000 15,000 15,000 9900 Transfers out - 100,000 100,000 100,000 Water system upgrades in conjunction with major roadway program - 100,000 100,000 100,000 518,246 1,020,739 1,744,511 1,665,563 119 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Water (Fund 700): 2012 Budget Summary Water Production (4825): Materials & supplies 1600 Supplies, operating 25,600 31,007 31,982 32,778 32,778 - 0.00% 1700 Motor fuels 616 310 552 2,700 3,150 450 16.67% Total materials & supplies 26,216 31,317 32,534 35,478 35,928 450 1.27% Contractual services 3030 Other professional services 12,307 23,991 11,517 37,230 30,205 (7,025) -18.87% 3210 Electricity 79,853 74,990 76,248 77,000 77,000 - 0.00% 3630 Training - - - 200 200 - 0.00% Total contractual services 92,160 98,981 87,765 114,430 107,405 (7,025) -6.14% Total water production 118,376 130,298 120,299 149,908 143,333 (6,575) -4.39% Total expenditures 1,081,712 1,189,805 1,195,554 2,565,054 2,492,064 27,010 1.05% Revenues over (under) expenditures (158,223) (228,342) (285,647) (1,403,252) (1,330,262) (27,010) 1.92% Add back: capital outlays - - - 1,241,200 1,149,900 (91,300) -7.36% principal payment on debt 190,000 200,000 205,000 210,000 215,000 5,000 2.38% Change in net assets 31,777 (28,342) (80,647) 47,948 34,638 (13,310) -27.76% Net Assets, beginning year 4,572,022 4,603,799 4,575,457 4,494,810 4,542,758 47,948 1.07% Net Assets, end of year 4,603,799$ 4,575,457$ 4,494,810$ 4,542,758$ 4,577,396$ 34,638$ 0.76% 120 Fund: 700 Department: 4825 Water Production Account Description 2009 2010 2011 2012 Description 1600 Supplies, operating 550 550 550 550 Computer supplies 800 800 800 800 Testing reagents 3,600 3,950 3,950 3,950 Sulfur dioxide: 25 150# cylinders @ $1.05 per pound 9,000 8,000 8,000 8,000 Chlorine: 8 - 1 ton cylinders @ .50 per pound 8,500 8,438 8,438 8,438 75 - 150 # cylinders @ $.75 6,200 6,600 6,600 6,600 Hydrofluosilic acid: 20,000 pounds @ $0.33 - 3,190 3,190 3,190 R-999 Buffer solution 2 - 55 gal drums @ 29 per gal. - - 850 850 Sand seperater 400 400 400 400 Water conservation program implementation 29,050 31,928 32,778 32,778 1700 Motor fuels & lubs 330 330 - - Motor oil for well # 2 - 55 gallons $6 gal. 150 150 200 200 Turbine & electric motor oil 192 192 250 250 Oil for generators 1,000 1,000 - - Propane for well #2: 500 gallons @ $2.00 2,550 2,250 2,250 2,700 Diesel fuel for primary generator: 600 gallons @ $4.50 4,222 3,922 2,700 3,150 3030 Other professional services 1,000 960 960 960 Bacteria tests (8*$10*12 months) 800 800 800 800 Computer maintenance 9,000 9,000 9,000 1,000 Consumer confidence report 6,470 6,800 7,500 7,500 DNR water permit fee (annual surcharge) 300 300 300 300 Emergency Response Commission fees 1,120 1,120 1,120 1,120 Full scan tests - 4 @ $280 600 600 600 600 Minimum contamination level (MCL) tests 2,000 - - - One-call locating (moved to 700-4823-3030) 1,000 1,000 1,000 1,000 Radon tests 800 800 800 800 Random sample tests 50,000 - - - Filter sand replenishment 25,000 - - - solenoid and valve repairs - - - 825 MCES discharge permits (3*$275) - 150 150 300 MNDPS - EPCRA program ($100/WTP) 25,000 10,000 15,000 15,000 Well head protection plan (req. by Dept. of Health)(30kl/3yr 09-11) 123,090 31,530 37,230 30,205 3210 Electricity 72,606 75,510 77,000 77,000 Electricity for wells, tower & reservoir 72,606 75,510 77,000 77,000 3630 Training 200 200 200 200 General training 200 200 200 200 229,168 143,090 149,908 143,333 121 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Sanitary Sewer (Fund 730): Revenues 3426 Reimbursed staff time - - - - - - 0.00% 3551 Spec. Assessments - 2,125 5,749 - - - 0.00% 3610 Investment income 149,549 77,662 47,990 60,000 45,000 (15,000) -25.00% 3680 Other revenues 364 - - - - - 0.00% 3716 Penalties 12,494 11,019 9,637 - - - 0.00% 3720 Utility sales 1,101,413 1,138,858 1,153,260 1,209,106 1,257,470 48,364 4.00% 3721 SAC charges 7,405 (15,480) (2,157) 4,000 4,000 - 0.00% 3725 Utility connections 300 180 420 300 300 - 0.00% 3728 Contractual wastewater service 12,891 74 - - - - 0.00% 3911 Gain on sale of assets 1,125 - - - - - 0.00% 3940 Capital Contributions - 42,475 - - - - 0.00% 3972 Transfers from Vehicle Fund - - - 330,000 - (330,000) -100.00% Total revenue 1,285,541 1,256,913 1,214,899 1,603,406 1,306,770 (296,636) -18.50% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 30,751 33,262 33,133 33,058 36,690 3,632 10.99% 0110 Salaries, overtime 159 68 - - - - 0.00% 0150 Salaries, part-time - - - - - - 0.00% 0300 Social security 2,331 2,364 2,369 2,529 2,806 277 10.95% 0321 PERA 1,901 2,200 2,282 2,396 2,660 264 11.02% 0400 Group insurance 2,400 2,812 2,983 4,387 5,260 873 19.90% 0500 Workers compensation 138 168 196 222 244 22 9.91% Total personnel services 37,680 40,874 40,963 42,592 47,660 5,068 11.90% Materials & supplies 1600 Supplies, operating - - - 50 50 - 0.00% Total materials & supplies - - - 50 50 - 0.00% Contractual services 3030 Other professional services 6,195 6,334 6,476 7,440 7,905 465 6.25% 3300 Postage 2,974 2,710 2,996 3,256 3,256 - 0.00% 3430 Printing 1,093 680 980 900 900 - 0.00% 3630 Training - - 310 250 250 - 0.00% 5130 Repairs, equipment 2,589 3,128 3,071 3,332 3,498 166 4.98% Total contractual services 12,851 12,852 13,833 15,178 15,809 631 4.16% Miscellaneous: 9900 Transfers out to General Fund 46,030 47,411 48,833 50,298 51,807 1,509 3.00% 9900 Transfers out to Vehicle Fund 36,000 36,000 36,000 36,000 36,000 - 0.00% Total miscellaneous 82,030 83,411 84,833 86,298 87,807 1,509 1.75% Total Billing 132,561 137,137 139,629 144,118 151,326 7,208 5.00% Infrastructure & Equip Maintenance (4823): Personnel services 100 Salaries, regular 139,887 148,658 159,201 162,168 166,553 4,385 2.70% 110 Salaries, overtime 1,345 5,215 5,814 7,221 7,365 144 1.99% 150 Salaries, part-time 1,060 7,511 10,071 11,100 11,100 - 0.00% 300 Social security 10,774 11,580 12,808 13,807 14,153 346 2.51% 321 PERA 8,192 10,655 11,404 12,563 12,892 329 2.62% 400 Group insurance 16,323 19,268 22,718 27,406 29,642 2,236 8.16% 500 Workers compensation 3,813 4,552 5,238 5,554 5,606 52 0.94% Total personnel services 181,394 207,439 227,254 239,819 247,311 7,492 3.12% 122 Fund: 730 Department: 4820 Billing Services Account Description 2009 2010 2011 2012 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 800 800 825 825 Inserting & mailing bills - - - - Financial/Payroll/Utility billing software search/selection costs - - - 375 Annual maintenance (meter reading software)(50% sewer, 50% Water) 6,300 6,435 6,615 6,705 22.5% of audit fee 7,100 7,235 7,440 7,905 3300 Postage 357 374 440 440 Late notices: 500 bills X $0.44 postage X 4 billings X 1/2 cost 2,688 2,816 2,816 2,816 3200 bills X $0.44 postage X 4 billings X 1/2 cost 3,045 3,190 3,256 3,256 3430 Printing 450 450 450 450 Envelopes 450 450 450 450 Utility bills (1/2 cost) 900 900 900 900 3630 Training 250 250 250 250 Seminars on new regulations, software updates, etc. INCODE training (new) 250 250 250 250 Defer INCODE training to a future year $1,000 5130 Repairs, equipment 2,717 2,885 3,029 3,180 Incode software support (30%) - 289 303 318 Handheld interface support for new meter readers (50% water 50% sewer) 2,717 3,174 3,332 3,498 9900 Transfers out 47,411 48,833 50,298 51,807 Transfer to General Fund for admin costs 36,000 36,000 36,000 36,000 Transfer to Vehicle & Equipment Fund for vehicle use 83,411 84,833 86,298 87,807 97,473 99,632 101,526 103,666 123 2012 Budget Summary 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Sanitary Sewer (Fund 730): Materials & supplies 1210 Supplies, bldg & grnds 155 90 49 200 200 - 0.00% 1220 Supplies, vehicles 2,180 1,756 781 1,275 1,575 300 23.53% 1230 Supplies, equipment 290 3,243 2,484 3,250 3,250 - 0.00% 1240 Supplies, streets 36 - - 850 850 - 0.00% 1250 Supplies, utilities 1,344 1,065 1,452 1,950 1,950 - 0.00% 1260 Supplies, traffic control - - - 300 300 - 0.00% 1600 Supplies, operating 2,991 1,806 2,367 4,300 4,300 - 0.00% 1700 Motor fuels 4,109 4,859 6,577 7,150 8,500 1,350 18.88% 2400 Uniforms 887 1,175 1,010 1,438 1,475 37 2.57% 2410 Mats & towels 1,134 1,427 1,295 800 1,620 820 102.50% Total materials & supplies 13,126 15,421 16,015 21,513 24,020 2,507 11.65% Contractual services 3030 Other professional services 136 1,452 1,194 7,750 5,350 (2,400) -30.97% 3030 Medtronic utility extension 1,965 - - - - - 0.00% 3100 Communications - telephone 2,894 1,214 1,407 1,430 1,660 230 16.08% 3200 Water & sewer 2,456 2,911 2,593 1,200 2,600 1,400 116.67% 3210 Electricity 1,866 2,072 2,019 2,100 2,100 - 0.00% 3230 Wastewater disposal - Met Council 696,031 733,120 776,845 776,066 760,913 (15,153) -1.95% 3610 Memberships - 63 64 230 230 - 0.00% 3630 Training 1,530 513 756 3,105 4,590 1,485 47.83% 4010 Equipment rental - - - 1,000 1,000 - 0.00% 4800 Insurance 10,381 6,163 5,605 7,300 7,300 - 0.00% 5130 Repairs, equipment 9,987 20,222 3,660 8,850 8,750 (100) -1.13% 5150 Repairs, utilities - - - 1,000 1,000 - 0.00% 5155 Utility service repairs - - - 4,500 4,500 - 0.00% 5160 Repairs, maintenance 52,416 14,674 6,585 140,000 42,500 (97,500) -69.64% Total contractual services 779,662 782,404 800,728 954,531 842,493 (112,038) -11.74% Capital outlays 7030 Equipment - - - 337,500 38,500 (299,000) -88.59% 7050 Construction - - - - 125,000 125,000 #DIV/0! 7950 Depreciation 153,931 157,989 156,758 160,000 160,000 - 0.00% Total capital outlays 153,931 157,989 156,758 497,500 323,500 (174,000) -34.97% Miscellaneous: 9100 Contingency - - - 15,000 15,000 - 0.00% 9900 Transfer to Street fund 60,000 150,000 160,000 160,000 160,000 - 0.00% Total miscellaneous 60,000 150,000 160,000 175,000 175,000 - 0.00% Total infrastructure & equip maint 1,188,113 1,313,253 1,360,755 1,888,363 1,612,324 (276,039) -14.62% Total expenditures 1,320,674 1,450,390 1,500,384 2,032,481 1,763,650 (268,831) -13.23% Revenues over (under) expenditures (35,133) (193,477) (285,485) (429,075) (456,880) (27,805) 6.48% Add back: capital outlays - - - 337,500 163,500 (174,000) -51.56% Change in net assets (35,133) (193,477) (285,485) (91,575) (293,380) (201,805) 220.37% Net Assets, beginning of year 5,749,177 5,714,044 5,520,567 5,714,044 5,622,469 (91,575) -1.60% Net Asset, end of year 5,714,044$ 5,520,567$ 5,235,082$ 5,622,469$ 5,329,089$ (495,185)$ -8.81% 124 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance Account Description 2009 2010 2011 2012 Description 1210 Supplies, bldgs & grounds 200 200 100 100 Paint, bulbs, fuses, etc 500 500 100 100 Seed, dirt, sod, etc 700 700 200 200 1220 Supplies, vehicles 75 75 75 75 Air, oil, fuel & transmission filters 775 775 775 775 Fluids 125 125 125 125 Repair & replacement parts 300 300 300 600 Tires & batteries 1,275 1,275 1,275 1,575 1230 Supplies, equipment 650 650 650 650 Tune up parts 500 500 500 500 Hydraulic fluids & hoses 550 550 200 200 Cutting edges (skid loader) 300 300 300 300 Misc. replacement & repair parts 300 300 300 300 Light equip misc replacement & repair parts 200 200 1,000 1,000 Camera track and parts 300 300 300 300 Minor repairs 2,800 2,800 3,250 3,250 1240 Supplies, streets 50 50 50 50 Tack coat 300 300 300 300 Dewatering rock 500 500 500 500 Asphalt mix 500 500 - - Gate @ Co. Rd. H2 & West City Limits (move to 2009) 1,350 1,350 850 850 1250 Supplies, utilities 100 100 100 100 Replacement pumps & motors 100 100 100 100 Filters, packings, relays, etc 300 300 300 300 Speed crete (mortar) 700 700 700 700 Repair parts 375 750 750 750 Manhole covers, adjust rings & bolts 1,575 1,950 1,950 1,950 1260 Supplies, traffic control 300 300 300 300 Traffic cones, work zone sign face, safety vests 300 300 300 300 1600 Supplies, operating 650 650 500 500 Additional & replacement hand tools 100 100 250 250 Glove & paper products 150 150 150 150 Disinfectant supplies 500 500 500 500 Camera supplies 150 150 200 200 First aid supplies, protective equip 400 400 400 400 CD's, DVD's, software 500 500 500 500 Engineering supplies 700 700 700 700 Shop supplies, fastners, soap, degreasers, steet, batteries 500 500 500 500 Pipe, fittings, and accessories (connectors) 600 - 600 600 Filter replacement for sewer gas monitors 4,250 3,650 4,300 4,300 1700 Motor fuels & lubs 300 300 300 300 Fluids 600 600 600 600 Motor oil - 100 gallons $6 gal. 3,750 3,250 3,250 4,000 Unleaded fuel 1,000 gallons @ $4 3,400 3,000 3,000 3,600 Diesel fuel 800 gallons @ $4.50 8,050 7,150 7,150 8,500 2400 Uniforms 1,438 1,438 1,438 1,475 Uniforms 19% of $6,000 and clothing 1.9 FTE x $175 per contract 1,438 1,438 1,438 1,475 2410 Mats & towels 800 800 800 1,620 Share of floor mats & shop towels (19% of $8,500) 800 800 800 1,620 3030 Other professional services 1,844 2,750 2,750 2,750 Gopher State One Call locates 750 - - - Consulting engineering services - - - 100 Fire extinguisher inspection/servcie (5 @ $20) - 10,000 5,000 2,500 Arcview/GIS base map consulting 2,594 12,750 7,750 5,350 3100 Communications - telephone 50 50 50 Service & repair 80 80 80 On call pager (half water / half sewer) 1,200 1,200 1,200 1,570 Cellular phone service (18.5% of $8,500) - - 100 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 1,330 1,330 1,430 1,660 3200 Water & Sewer service 1,200 1,200 1,200 2,600 Estimated annual charge 1,200 1,200 1,200 2,600 3210 Electricity 1,815 1,888 2,100 2,100 Electricity for lift stations 1,815 1,888 2,100 2,100 29,477 38,581 33,993 35,730 125 THIS PAGE LEFT BLANK INTENTIONALLY 126 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance (continued) Account Description 2009 2010 2011 2012 Description 3230 Metro Waste Commission 733,120 776,845 776,066 760,913 Estimated annual charge 733,120 776,845 776,066 760,913 3610 Memberships 200 113 - - American Public Works Association (APWA)(25% of $600) - - 100 100 MN Rural Water Assoc. (50%) - - 50 50 Suburban Utility Superintendant Association (SUSA)(50% of $100) 65 65 80 80 MN Safety Council (20%) 265 178 230 230 3630 Training 600 600 600 1,400 Collection operators training/renewal ($350 per person) 560 560 560 560 Tuition reimbursement (PW Mgt. Class - North Hennepin CC) 250 250 250 250 Computer training/webinars 120 120 120 110 Hearing test/R2K (2.15 FTE * $50) 50 50 50 - License renewal 200 200 200 1,200 Confined space seminar (on-site)(not annual) 150 150 150 - Trench safety training 450 450 450 - Wastewater collection operators recertification seminar 235 235 235 - Low voltage license 320 320 320 320 Metro school 110 110 110 - Pesticide applicators license - - - 300 Miscellaneous wastewater training - - - 60 Maintenance Expo - - - 390 Equipment operator training - 125 - - APWA MN conference 60 60 60 - Work zone safety seminar (every 3 years) 3,105 3,230 3,105 4,590 4010 Rental, equipment 1,000 1,000 1,000 1,000 Barricades & signs 1,000 1,000 1,000 1,000 4800 Insurance 7,246 7,246 7,300 7,300 Share of property/liability insurance 7,246 7,246 7,300 7,300 5130 Repairs, equipment 100 100 100 - Fire extinguisher recharge / repair 500 500 - - Groveland Lift Station repair 200 200 2,500 2,500 Repairs to motors & pumps 3,800 10,000 2,500 2,500 Repairs to Vactor (jet truck) - - 2,500 2,500 Repairs to camera van and camera equipment - - 1,000 1,000 Repairs to utility truck 250 250 250 250 Misc repairs 250 250 - - Copy machine/fax machine repairs 5,100 11,300 8,850 8,750 5150 Repairs, utilities 500 500 - - Repairs to RTUs - - 1,000 1,000 Lift station repairs 500 500 1,000 1,000 5155 Utility service repairs 4,500 4,500 4,500 4,500 Service line repairs 4,500 4,500 4,500 4,500 5160 System maintenance 50,000 50,000 15,000 15,000 Sewer main & manhole rehabilitation 15,000 15,000 25,000 25,000 Root control - 27,500 - 2,500 Groveland lift station maintenance/cleaning 75,000 100,000 100,000 - Sewer pipe relining program 140,000 192,500 140,000 42,500 7030 Capital, equipment 330,000 330,000 300,000 - Vactor (includes auto chassis lube) - 5,000 5,000 - GPS Locating Equipment (carryover from 2010) 10,000 - 30,000 30,000 Generator - trailer mounted (carryover) - - - 8,500 Wincam software upgrade/desktop license/training - - 2,500 - Vehicle Cameras (3) 340,000 335,000 337,500 38,500 7050 Construction 150,000 - - - Sewer system upgrades in conjunction with major roadway program - - - 125,000 Sewer pipe relining program - - - - Groveland lift station pump replacement 150,000 - - 125,000 7950 Depreciation 165,000 165,000 160,000 165,000 Estimated depreciation 165,000 165,000 160,000 165,000 9100 Contingency 15,000 15,000 15,000 15,000 Contingency - may include lift station impeller replacement at Bronson 15,000 15,000 15,000 15,000 9900 Transfer out - 160,000 160,000 160,000 Sewer system upgrades in conjunction with major roadway program - 160,000 160,000 160,000 1,564,836 1,672,299 1,614,551 1,334,283 127 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Budget Request Dollar Percent Street Lighting (Fund 740): Revenues 3610 Investment income 6,222 3,318 2,091 2,000 2,000 - 0.00% 3716 Penalties 902 688 713 - 500 500 #DIV/0! 3740 Street lighting charges 76,963 76,520 75,548 74,000 75,000 1,000 1.35% Total revenue 84,087 80,526 78,352 76,000 77,500 1,500 1.97% Operating expenses Operations (4416) Personnel services 0100 Salaries, regular 2,670 2,753 2,630 2,638 2,691 53 2.01% 0110 Salaries, overtime - 18 - - - - 0.00% 0300 Social security 192 185 184 202 206 4 1.98% 0321 PERA 166 183 185 191 195 4 2.09% 0400 Group insurance 433 499 520 505 550 45 8.91% 0500 Workers compensation 13 15 18 19 19 - 0.00% 0990 Severence pay - - - - - 0.00% Total personnel services 3,474 3,653 3,537 3,555 3,661 106 2.98% Materials & supplies 0 1600 Supplies, operating - - 11 - - - 0.00% 0 Contractual services 3030 Other professional services - 0.00% 3210 Electricity 66,125 71,816 72,603 72,000 73,000 1,000 1.39% 4800 Insurance 737 765 690 900 900 - 0.00% 5150 Repairs, utilities - 3,464 3,193 - 3,000 3,000 #DIV/0! Total contractual services 66,862 76,045 76,486 72,900 76,900 4,000 5.49% Other 9900 Transfer to General Fund 2,060 2,122 2,186 2,252 2,320 68 3.02% Total other 2,060 2,122 2,186 2,252 2,320 68 3.02% 0.00% Total expenditures 72,396 81,820 82,220 78,707 82,881 4,174 5.30% Revenues over (under) expenditures 11,691 (1,294) (3,868) (2,707) (5,381) (2,674) 98.78% 0.00% Add back: Capital outlays - - - - - - 0.00% Change in net assets 11,691 (1,294) (3,868) (2,707) (5,381) (2,674) 98.78% Net assets, beginning year 147,543 159,234 157,940 154,072 151,365 (2,707) -1.76% 0.00% Net assets, end of year 159,234$ 157,940$ 154,072$ 151,365$ 145,984$ (5,381)$ -3.55% 2012 Budget Summary 128 Fund: 740 Street Lighting Fund Revenues Account Description 2009 2010 2011 2012 Description 3610 Interest revenue 2,000 2,000 2,000 2,000 Estimated interest earnings at 2.00%. 2,000 2,000 2,000 2,000 3740 Street lighting charges 72,000 74,000 74,000 74,000 Estimated utility charges for street lighting. 72,000 74,000 74,000 74,000 Fund: 740 Department: 4416 Operations 3210 Electricity 65,000 68,770 72,000 72,000 Estimate 65,000 68,770 72,000 72,000 4800 Insurance 900 900 900 900 Share of property/liability insurance 900 900 900 900 5150 Repairs, utilities - - - 2,000 Repairs to street lighting. - - - 2,000 9900 Transfer out 2,122 2,186 2,252 2,320 Transfer to General Fund for administrative overhead costs 2,122 2,186 2,252 2,320 129 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Request Request Dollar Percent Storm Water (Fund 745): Revenues 3610 Investment income 57,985 33,177 22,653 22,000 22,000 - 0.00% 3680 Other revenues - - - - - - 0.00% 3716 Penalties & interest 2,254 1,958 2,308 - - - 0.00% 3730 Surface water charges 222,137 241,384 264,658 250,718 250,718 - 0.00% 3972 Transfer from other funds - - - 40,000 - (40,000) -100.00% Total revenue 282,376 276,519 289,619 312,718 272,718 (40,000) -12.79% Operating expenses System Maintenance (4415): Personnel services 0100 Salaries, regular 54,235 49,958 52,822 47,562 48,514 952 2.00% 0110 Salaries, overtime 123 1,293 329 1,083 1,105 22 2.03% 0150 Salaries, part-time 4,792 6,263 5,264 4,920 4,920 - 0.00% 0300 Social security 4,534 4,329 4,089 4,097 4,172 75 1.83% 0321 PERA 3,265 3,428 3,408 3,527 3,597 70 1.98% 0400 Group insurance 4,759 5,907 6,372 7,798 8,573 775 9.94% 0500 Workers compensation 2,852 3,266 3,875 3,893 3,884 (9) -0.23% 0990 Severence pay - - - - - - 0.00% Total personnel services 74,560 74,444 76,159 72,880 74,765 1,885 2.59% Materials & supplies 1230 Supplies, equipment 1,695 81 1,594 2,000 2,000 - 0.00% 1240 Supplies, streets - - - 600 600 - 0.00% 1600 Supplies, operating 1,345 167 1,291 2,200 3,200 1,000 45.45% 1700 Motor fuels 3,720 2,388 2,686 2,750 3,350 600 21.82% 2100 Books/Periodicals - - 54 100 100 - 0.00% 2400 Uniforms 420 723 614 1,188 740 (448) -37.71% 2410 Mats & towels 1,137 1,427 1,296 800 810 10 1.25% Total materials & supplies 8,317 4,786 7,535 9,638 10,800 1,162 12.06% Contractual services 3030 Other professional services 15,032 12,698 4,947 17,500 6,350 (11,150) -63.71% 3100 Telephone 1,379 1,143 1,057 1,250 780 (470) -37.60% 3610 Memberships 690 753 1,154 750 920 170 22.67% 3630 Training 324 365 307 3,410 3,195 (215) -6.30% 4800 Insurance 1,556 1,616 6,680 1,900 1,900 - 0.00% 5150 Repairs, utilities 50,474 7,147 - 50,000 25,000 (25,000) -50.00% Total contractual services 69,455 23,722 14,145 74,810 38,145 (36,665) -49.01% Capital outlays 7030 Equipment - - - - 9,000 9,000 #DIV/0! 7050 Construction - - - - 108,000 108,000 #DIV/0! 7950 Depreciation 31,878 31,878 32,151 32,000 32,000 - 0.00% Total capital outlays 31,878 31,878 32,151 32,000 149,000 117,000 365.63% Miscellaneous: 9900 Transfer out - 30,000 40,000 40,000 46,756 6,756 16.89% Total miscellaneous - 30,000 40,000 40,000 46,756 6,756 16.89% Total System Maintenance 184,210 164,830 169,990 229,328 319,466 90,138 39.31% 0.00% 2012 Budget Summary 130 Fund: 745 Storm Water Revenues Account Description 2009 2010 2011 2012 Description 3610 Interest revenue 34,000 25,000 22,000 22,000 Estimated interest earnings at 2.00%. 34,000 25,000 22,000 22,000 3730 Utility sales 225,669 250,718 250,718 250,718 Estimated surface water charges. 225,669 250,718 250,718 250,718 3972 Transfers - Vehicle & equip Fd 40,000 40,000 40,000 40,000 Transfer for capital equipment purchases 40,000 40,000 40,000 40,000 Fund: 745 Department: 4415 System Maintenance 1230 Supplies, equipment 200 500 500 500 Miscellaneous equipment (laser level) 1,000 1,000 1,500 1,500 Hoses & nozzles 1,200 1,500 2,000 2,000 1240 Supplies, streets 600 600 600 600 Bituminous mix 600 600 600 600 1600 Supplies, operating 300 300 300 300 Concrete - - 1,000 2,000 Rain Garden mix, riprap, topsoil, seed and sod 1,200 1,200 200 200 Concrete adjustment rings 200 200 200 200 CD's, DVD's, software upgrade for camera van 800 800 500 500 Catch basin castings 2,500 2,500 2,200 3,200 1700 Motor fuels 2,550 2,250 1,125 1,350 300 gallons diesel fuel @ $4.50 / gallon for Vactor - - 1,625 2,000 500 gallons unleaded @ $4.00 for utility truck 2,550 2,250 2,750 3,350 2100 Books/Periodicals 500 150 100 100 Storm water books/periodicals 500 150 100 100 2400 Uniforms 1,188 1,188 1,188 740 Uniforms/clothing (9.5% of $6,000, .95 FTE x $175 per contract) 1,188 1,188 1,188 740 2410 Mats & towels 800 800 800 810 Share of floor mats & shop towels (9.5% of $8,500) 800 800 800 810 3030 Other professional services 1,600 1,600 - - GIS data input 6,000 5,000 5,000 5,000 Consulting engineers - 5,000 2,500 1,250 Arcview/GIS base map consulting - 10,000 - - FEMA Study - - 10,000 - Silverview pond sediment removal study - - - 100 Fire extinguisher inspection/servcie (5 @ $20) 7,600 21,600 17,500 6,350 3100 Communications 1,200 1,200 1,200 690 Cell Phone (8% of $8,500) - - 50 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 1,200 1,200 1,250 780 3610 Memberships 85 - - - CPV Program - 113 - 150 American Public Works Association (APWA)(25% of $600) 690 690 710 725 Minnesota Cities Storm Water Coalition 65 65 40 45 MN Safety Council (11% of $405) 840 868 750 920 3630 Training 200 200 200 200 Seminars & training sessions (Stormwater) - - 60 55 Hearing test/R2K (1.1 FTE * $50) - - 800 - Wastewater class/exam - - 350 350 Safety training - - 750 750 NPDES compliance training - - 1,250 1,250 Tuition reimbursement 700 700 - - Public Education Fund 150 150 - - Trench safety seminar 150 150 - - Competent person training - - - 270 Erosion & Stormwater Maint. Certification - - - 220 Equipment operator training 500 500 - 100 Computer/webinar training 1,700 1,700 3,410 3,195 4800 Insurance 1,900 1,900 1,900 1,900 Share of property/liability insurance 1,900 1,900 1,900 1,900 5150 Repairs, utilities 70,000 50,000 25,000 25,000 Repair storm sewer and drainage issues throughout the city 10,000 10,000 25,000 - Storm Sewer slip linning improvements 80,000 60,000 50,000 25,000 7030 Equipment - - 4,000 4,000 Small generator for trailer - - 5,000 5,000 Concrete mixer - - 9,000 9,000 7050 Construction - - - 25,000 Sewer sliplining program - - - 35,000 Mustang Drive improvements 40,000 - - - Storm water system upgrades in conjunction with major roadway program - 48,000 - 48,000 Storm water projects, Subwatershed SC-1, SC-3, EW-4 315,000 - - - Storm water projects, Subwatershed AA-2, AA-6, EW-4 355,000 48,000 - 108,000 7950 Depreciation 35,000 35,000 32,000 34,000 Estimated depreciation 35,000 35,000 32,000 34,000 9900 Transfer out - 40,000 40,000 40,000 Storm water system upgrades in conjunction with major roadway program - 40,000 40,000 40,000 492,578 219,256 156,448 230,945 131 2008 2009 2010 2011 2012 Change from 2011 Actual Actual Actual Request Request Dollar Percent 2012 Budget Summary Storm Water (Fund 245): Street Sweeping (4417): Personnel services 0100 Salaries, regular 8,431 8,056 7,976 7,510 7,660 150 2.00% 0110 Salaries, overtime - 292 181 1,083 1,105 22 2.03% 0150 Salaries, part-time - - - 240 240 - 0.00% 0300 Social security 662 610 577 676 689 13 1.92% 0321 PERA 531 577 571 623 635 12 1.93% 0400 Group insurance 1,061 1,278 1,353 1,231 1,354 123 9.99% 0500 Workers compensation 469 545 640 642 642 - 0.00% 0990 Severence pay - - - - - - 0.00% Total personnel services 11,154 11,358 11,298 12,005 12,325 320 2.67% Materials & supplies 1230 Supplies, equipment 94 2,150 3,805 200 2,500 2,300 1150.00% 1600 Supplies, operating 1,493 605 2,118 3,200 3,500 300 9.38% 1700 Motor fuels - 2,389 1,583 3,150 4,150 1,000 31.75% 2400 Uniforms - - - 188 115 (73) -38.83% 2410 Mats & towels - - - - 110 110 #DIV/0! Total materials & supplies 1,587 5,144 7,506 6,738 10,375 3,637 53.98% Contractual services 3530 Disposal - - - 5,000 5,000 - 0.00% 3630 Training - 40 109 530 280 (250) -47.17% 5130 Repairs, equipment - - 2,036 2,000 4,000 2,000 100.00% Total contractual services - 40 2,145 7,530 9,280 1,750 23.24% Capital outlays 7030 Equipment - - - 40,000 - (40,000) -100.00% Total capital outlays - - - 40,000 - (40,000) -100.00% 0.00% Miscellaneous:0.00% 9800 Loss on disposal of asset - - - - - - 0.00% 9900 Transfer out 16,000 16,000 16,000 16,000 16,000 - 0.00% Total miscellaneous 16,000 16,000 16,000 16,000 16,000 - 0.00% Total street sweeping 28,741 32,542 36,949 82,273 47,980 (34,293) -41.68% Total expenditures 212,951 197,372 206,939 311,601 367,446 55,845 17.92% Revenues over expenditures 69,425 79,147 82,680 1,117 (94,728) (95,845) -8580.57% Add back: Capital outlays - - - 40,000 117,000 77,000 192.50% Change in net asssets 69,425 79,147 82,680 41,117 22,272 (18,845) -45.83% Net assets, beginning year 2,642,608 2,712,033 2,791,180 2,873,860 2,914,977 41,117 1.43% Net assets, end of year 2,712,033$ 2,791,180$ 2,873,860$ 2,914,977$ 2,937,249$ 22,272$ 0.76% 132 Fund: 745 Department: 4417 Street Cleaning 1230 Supplies, equipment 200 200 200 2,500 Misc. repairs - belts, pumps, hoses, filters, etc. 200 200 200 2,500 1600 Supplies, operating 1,000 1,000 2,000 2,300 Gutter brooms - - 700 700 Belts, pumps, hoses, filters, etc... for sweeper - - 100 100 Gloves, hearing protection, etc... 100 100 400 400 2 dirt shoes 1,100 1,100 3,200 3,500 1700 Motor fuels 2,550 2,250 3,000 4,000 Diesel fuel - 800 gallons @ $5.00/gallon 150 150 150 150 Oil - 4 changes 2,700 2,400 3,150 4,150 2400 Uniforms 188 188 188 115 Uniforms/clothing (1.5% of $6,000, .15 FTE x $175 per contract) 188 188 188 115 2410 Mats & towels - - - 110 Share of floor mats & shop towels (1.5% of $8,500) - - - 110 3530 Disposal - 5,000 5,000 5,000 Dumping charges for sweeping disposals 2010 - 5,000 5,000 5,000 3630 Training 150 125 - - American Public Works Assoc. MN conference 150 - - - Minnesota Public Works Assoc. conference - - 500 250 NPDES compliance training - - 30 30 Maintenance Expo 200 200 - - MSSA operator training sessions. 200 200 - - Sweeper operator seminar 200 200 - - MCCA Membership 900 725 530 280 5130 Repairs, equipment - - 2,000 4,000 Elgin sweeper repairs - - 2,000 4,000 7030 Equipment 40,000 40,000 40,000 - 3/4 T 4X4 Truck (carryover from 2008) 40,000 40,000 40,000 - 9900 Transfer out to Vehicle & Equip 16,000 16,000 16,000 16,000 Transfer to Vehicle & Equip Fund for future replacements 16,000 16,000 16,000 16,000 61,088 65,613 68,268 31,655 133