Loading...
HomeMy WebLinkAboutAgenda Packets - 2010/12/06 (2) CITY OF MOUNDS VIEW SPECIAL CITY COUNCIL MEETING AGENDA MOUNDS VIEW CITY HALL Monday, December 6, 2010 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 13, 2010, at 7 p.m. City of Mounds View 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 General Fund:Actual Actual Actual Budget Request Dollar Percent Revenues: Property taxes - Base levy 3,319,587 3,253,546 3,105,868 3,212,525 3,402,792 190,267 5.92% Special tax levies, Bonds 161,327 158,370 158,895 154,606 93,885 (60,721) -39.27% Special tax levies, Operations 114,526 76,145 241,822 242,704 235,145 (7,559) -3.11% Franchise tax 273,540 283,796 235,002 287,000 249,900 (37,100) -12.93% Other taxes 65,431 157,410 102,284 45,000 45,000 - 0.00% Hotel/motel tax 52,615 51,263 43,835 51,000 45,000 (6,000) -11.76% Licenses and permits 212,041 193,930 175,816 180,270 178,560 (1,710) -0.95% Intergovernmental 348,800 380,602 816,717 557,807 321,171 (236,636) -42.42% Charges for services 18,576 11,459 23,302 22,190 16,565 (5,625) -25.35% Fines & forfeitures 41,833 38,617 29,819 40,800 30,300 (10,500) -25.74% Interest 118,620 187,181 96,267 104,000 104,000 - 0.00% Miscellaneous 175,305 189,264 124,176 86,656 175,844 89,188 102.92% Transfers:- 0.00% Special Projects Fund - 90,000 - 90,000 90,000 - 0.00% DARE Fund - 4,393 4,393 4,393 3,000 (1,393) -31.71% Water Fund 56,422 58,115 59,859 61,655 63,505 1,850 3.00% Sewer Fund 44,688 46,030 47,411 48,833 50,298 1,465 3.00% Street Light Fund 2,000 2,060 2,122 2,186 2,252 66 3.02% Levy Reduction Fund 157,600 249,000 249,315 250,000 250,000 - 0.00% Levy Reduction Fund - permit 134,000 80,000 - - - - 0.00% Vehicle & Equipment Fund 141,500 117,250 44,000 65,600 333,094 267,494 407.77% Total revenues 5,438,411 5,628,431 5,560,903 5,507,225 5,690,311 183,086 3.32% Expenditures: Legislative Services: City Council 51,470 49,409 44,343 49,974 49,767 (207) -0.41% Advisory Commissions 16,018 22,245 9,575 11,900 11,150 (750) -6.30% Subtotal 67,488 71,654 53,918 61,874 60,917 (957) -1.55% Administrative Services: City Administrator 177,895 181,283 214,640 217,232 222,794 5,562 2.56% Elections 14,409 32,051 11,851 38,210 10,323 (27,887) -72.98% Finance 221,996 232,688 238,674 249,270 247,870 (1,400) -0.56% Central Services 260,206 242,641 193,815 238,082 236,923 (1,159) -0.49% Subtotal 674,506 688,663 658,980 742,794 717,910 (24,884) -3.35% Community Development 469,777 459,520 439,112 486,119 463,831 (22,288) -4.58% Police 2,086,448 2,235,909 2,276,827 2,320,232 2,304,086 (16,146) -0.70% Fire 283,732 292,697 318,765 329,202 297,467 (31,735) -9.64% Public Works Administration 96,759 113,957 106,794 120,436 123,715 3,279 2.72% Parks, Recreation & Forestry: Recreation 122,566 136,343 108,647 125,600 109,600 (16,000) -12.74% Parks 308,718 316,080 310,388 306,586 365,964 59,378 19.37% Forestry 62,945 49,675 50,496 61,450 55,000 (6,450) -10.50% Subtotal 494,229 502,098 469,531 493,636 530,564 36,928 7.48% Fleet Services: Building & Grounds Mtnce 122,568 138,150 132,439 136,185 135,254 (931) -0.68% Vehicle & Equipment Mtnce 81,510 92,739 84,828 84,738 86,259 1,521 1.79% Subtotal 204,078 230,889 217,267 220,923 221,513 590 0.27% Streets: Pavement Management 185,174 204,005 211,452 191,215 380,501 189,286 98.99% Snow & Ice Control 122,264 130,272 121,874 128,811 122,712 (6,099) -4.73% Sign Maintenance 34,621 37,262 35,321 36,696 36,594 (102) -0.28% Subtotal 342,059 371,539 368,647 356,722 539,807 183,085 51.32% Other Convention & Visitor's Bureau 50,071 48,715 40,171 48,450 42,750 (5,700) -11.76% Social Service Coordination 17,927 18,375 18,926 18,926 18,661 (265) -1.40% Miscellaneous/contingency 4,069 5,400 6,263 106,500 6,500 (100,000) -93.90% Transfers to other funds 350,000 350,000 335,000 225,000 245,000 20,000 8.89% Debt service - Fire Bonds 203,724 150,626 149,283 147,195 89,662 (57,533) -39.09% Subtotal 625,791 573,116 549,643 546,071 402,573 (143,498) -26.28% Total expenditures 5,344,867 5,540,042 5,459,484 5,678,009 5,662,383 (15,626) -0.28% Net change in fund balance 93,544 88,389 101,419 (170,784) 27,928 198,712 Beginning Fund Balance 2,473,163 2,566,707 2,655,097 2,756,516 2,585,732 Ending Fund Balance 2,566,707 2,655,097 2,756,516 2,585,732 2,613,660 198,712 1 City of Mounds View GENERAL FUND 2011 Budget Summary Community Park Public 2011 2010 Percent Legislative Admin Finance Central Development Police Fire & Rec Works Misc.Total Total Variance Change Current Personnel services 32,848$ 227,312$ 230,432$ -$ 440,116$ 1,971,694$ -$ 201,951$ 423,538$ 6,500$ 3,534,391$ 3,583,509$ (49,118)$ -1.37% Materials & supplies 1,900 685 700 20,375 1,660 70,490 - 41,765 114,514 - 252,089 271,764 (19,675) -7.24% Contractual services 26,169 5,120 16,738 193,548 22,055 231,702 274,573 220,848 155,983 61,411 1,208,147 1,238,489 (30,342) -2.45% Contingency - - - - - - - - - - - 100,000 (100,000) -100.00% Current total 60,917 233,117 247,870 213,923 463,831 2,273,886 274,573 464,564 694,035 67,911 4,994,627 5,193,762 (199,135) -3.83% Other Principal - - - - - - - - - 50,213 50,213 103,428 (53,215) -51.45% Interest - - - - - - - - - 39,449 39,449 43,767 (4,318) -9.87% Capital outlays - - - 23,000 - 30,200 22,894 66,000 191,000 - 333,094 112,052 221,042 197.27% Transfers to other funds - - - - - - - - - 245,000 245,000 225,000 20,000 8.89% Other total - - - 23,000 - 30,200 22,894 66,000 191,000 334,662 667,756 484,247 183,509 37.90% Department Total 60,917$ 233,117$ 247,870$ 236,923$ 463,831$ 2,304,086$ 297,467$ 530,564$ 885,035$ 402,573$ 5,662,383$ 5,678,009$ (15,626)$ -0.28% 2 City of Mounds View 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 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 23,996 24,651 6,617 25,000 23,000 (996) -3.98% Finance - - - - - - 0.00% Subtotal 23,996 24,651 6,617 25,000 23,000 (996) -3.98% Community Development - - 1,066 - - - 0.00% Police 54,533 89,804 36,239 40,600 30,200 (24,333) -59.93% Fire 32,613 13,048 35,789 46,452 22,894 (9,719) -20.92% Public Works Administration 1,791 - - - - (1,791) 0.00% Parks, Recreation & Forestry: Recreation - - - - - - 0.00% Parks 12,024 5,845 - - 66,000 53,976 0.00% Forestry - - - - - - 0.00% Subtotal 12,024 5,845 - - 66,000 53,976 0.00% Fleet Services: Building & Grounds Mtnce - - - - - - 0.00% Vehicle & Equipment Mtnce - - - - - - 0.00% Subtotal - - - - - - 0.00% Streets: Pavement Management 22,754 2,002 - - 191,000 168,246 0.00% Snow & Ice Control 2,705 6,001 949 - - (2,705) 0.00% Sign Maintenance - - - - - - 0.00% Subtotal 25,459 8,003 949 - 191,000 165,541 0.00% 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 150,416 141,351 80,660 112,052 333,094 182,678 163.03% 3 City of Mounds View 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 General Fund:Actual Actual Actual Budget Request Dollar Percent Operating Expenditures: Legislative Services: City Council 51,470 49,409 44,343 49,974 49,767 (207) -0.41% Advisory Commissions 16,018 22,245 9,575 11,900 11,150 (750) -6.30% Subtotal 67,488 71,654 53,918 61,874 60,917 (957) -1.55% Administrative Services: City Administrator 177,895 181,283 214,640 217,232 222,794 5,562 2.56% Elections 14,409 32,051 11,851 38,210 10,323 (27,887) -72.98% Central Services 236,210 217,990 187,198 213,082 213,923 841 0.39% Finance 221,996 232,688 238,674 249,270 247,870 (1,400) -0.56% Subtotal 650,510 664,012 652,363 717,794 694,910 (22,884) -3.19% Community Development 469,777 459,520 438,046 486,119 463,831 (22,288) -4.58% Police 2,031,915 2,146,105 2,240,588 2,279,632 2,273,886 (5,746) -0.25% Fire 251,119 279,649 282,976 282,750 274,573 (8,177) -2.89% Public Works Administration 94,968 113,957 106,794 120,436 123,715 3,279 2.72% Parks, Recreation & Forestry: Recreation 122,566 136,343 108,647 125,600 109,600 (16,000) -12.74% Parks 296,694 310,235 310,388 306,586 299,964 (6,622) -2.16% Atheletic Field Mtnce - - - - - - 0.00% Forestry 62,945 49,675 50,496 61,450 55,000 (6,450) -10.50% Subtotal 482,205 496,253 469,531 493,636 464,564 (29,072) -5.89% Fleet Services: Building & Grounds Mtnce 122,568 138,150 132,439 136,185 135,254 (931) -0.68% Squad & Staff Car Mtnce - - - - - - 0.00% Vehicle & Equipment Mtnce 81,510 92,739 84,828 84,738 86,259 1,521 1.79% Subtotal 204,078 230,889 217,267 220,923 221,513 590 0.27% Streets: Pavement Management 162,420 202,003 211,452 191,215 189,501 (1,714) -0.90% Snow & Ice Control 119,559 124,271 120,925 128,811 122,712 (6,099) -4.73% Sign Maintenance 34,621 37,262 35,321 36,696 36,594 (102) -0.28% Subtotal 316,600 363,536 367,698 356,722 348,807 (7,915) -2.22% Other Convention & Visitor's Bureau 50,071 48,715 40,171 48,450 42,750 (5,700) -11.76% Social Service Coordination 17,927 18,375 18,926 18,926 18,661 (265) -1.40% Miscellaneous/contingency 4,069 5,400 6,263 106,500 6,500 (100,000) -93.90% Transfers to other funds 350,000 350,000 335,000 225,000 245,000 20,000 8.89% Debt service - Fire Bonds 203,724 150,626 149,283 147,195 89,662 (57,533) -39.09% Subtotal 625,791 573,116 549,643 546,071 402,573 (143,498) -26.28% Total expenditures 5,194,451 5,398,691 5,378,824 5,565,957 5,329,289 (236,668) -4.25% 4 General Fund Revenue Detail - 2011 Budget Acct 2007 2008 2009 2010 2011 Change from 2010 #Description Actual Actual Actual Budget Request Dollar Percent Taxes 3101 Current ad valorem property tax 3,319,587 3,253,546 3,105,868 3,212,525 3,402,792 190,267 5.92% 3101 Fire Bonds property tax 1997 61,088 60,410 61,226 60,362 - (60,362) -100.00% 3101 Fire Mini-Pumper property tax 2,529 2,495 2,146 - - - 0.00% 3101 Fire Bonds property tax 2005 97,710 95,465 95,523 94,244 93,885 (359) -0.38% 3101 PERA rate increase property tax 6,145 6,145 26,822 34,704 39,145 4,441 12.80% 3101 Police Officer property tax 70,000 70,000 215,000 208,000 196,000 (12,000) -5.77% 3102 Delinquent ad valorem prop tax 38,381 93,258 47,192 - - - 0.00% 3111 Manufact home tax - current 22,587 20,106 18,147 20,000 20,000 - 0.00% 3112 Manufact home tax - delinquent 8,940 11,903 10,476 10,000 10,000 - 0.00% 3113 Man. home Market value credit 15,564 15,129 11,507 15,000 15,000 - 0.00% 3125 Excess TIF 15,462 10,806 12,052 - - - 0.00% 3180 Franchise tax on utilities 273,540 283,796 235,002 287,000 249,900 (37,100) -12.93% 3190 Penalties & interest 2,878 6,208 2,910 - - - 0.00% 3195 Hotel/Motel tax 52,615 51,263 43,835 51,000 45,000 (6,000) -11.76% Total taxes 3,987,026 3,980,530 3,887,706 3,992,835 4,071,722 78,887 1.98% Licenses and Permits 3211 Liquor on-sale 24,164 21,320 21,620 20,000 20,000 - 0.00% 3212 Liquor off-sale 685 2,475 645 700 700 - 0.00% 3215 Malt on-sale license - 1,835 1,820 1,000 1,000 - 0.00% 3216 Malt off-sale 100 100 10 100 100 - 0.00% 3221 Tobacco license 1,896 1,896 3,000 1,900 1,900 - 0.00% 3223 Amusement devices 1,755 1,950 810 1,000 1,000 - 0.00% 3231 Bowling alley 1,312 640 640 640 640 - 0.00% 3232 Garbage hauling 1,809 1,803 1,740 1,800 1,800 - 0.00% 3233 Gasoline station 1,067 582 582 600 600 - 0.00% 3234 Used car sales 158 158 200 150 150 - 0.00% 3235 Kennel 145 176 263 80 120 40 50.00% 3236 Restraurant licenses 4,723 4,190 4,290 4,000 4,000 - 0.00% 3237 Cabaret & Dance 100 - - - - - 0.00% 3238 Transient & solicitor 1,860 2,455 2,385 1,000 1,500 500 50.00% 3239 Apartment 15,270 15,480 14,101 15,000 15,000 - 0.00% 3241 Dog 909 2,282 1,060 800 900 100 12.50% 3242 Massage therapy 1,905 955 435 - - - 0.00% 3250 General contractor 1,244 1,050 1,050 1,200 1,100 (100) -8.33% 3251 HVAC contractor 3,611 4,586 4,503 3,000 3,800 800 26.67% 3252 Cement contractor 250 150 436 250 250 - 0.00% 3253 Asphalt contractor 400 500 700 400 500 100 25.00% 3254 Excavating contractor 150 50 50 150 50 (100) -66.67% 3255 Sign & billboard contractor 710 650 535 500 500 - 0.00% 3256 Sewer & water contractor - - 50 100 50 (50) -50.00% 3257 Other contractor 650 850 900 700 700 - 0.00% 3258 License check 1,492 1,761 1,210 1,000 1,000 - 0.00% 3260 Fire permits 990 1,155 750 600 600 - 0.00% Subtotal licenses 67,355 69,049 63,785 56,670 57,960 1,290 2.28% 5 General Fund Revenue Detail - 2011 Budget Acct 2007 2008 2009 2010 2011 Change from 2010 #Description Actual Actual Actual Budget Request Dollar Percent 3262 Grading permit - 59 - - - - 0.00% 3268 Plan check fee 31,238 22,603 21,444 25,000 22,000 (3,000) -12.00% 3270 Building permits 67,184 52,705 44,478 55,000 55,000 - 0.00% 3271 Fixed fee - building permits 17,196 26,901 18,872 18,000 18,000 - 0.00% 3272 Wetland buffer permit 100 78 75 - - - 0.00% 3273 HVAC permits 12,475 11,726 11,867 12,000 12,000 - 0.00% 3274 Plumbing permits 10,258 5,267 6,860 8,000 8,000 - 0.00% 3275 Non-building permits 4,213 4,616 7,038 5,000 5,000 - 0.00% 3278 Interim use permits 375 25 - - - - 0.00% 3279 Conditional use permits 1,375 750 1,250 600 600 - 0.00% 3280 Building surcharge 195 127 109 - - - 0.00% 3281 Fixed fee building surcharge 7 10 5 - - - 0.00% 3282 Mechanical/commercial surcharg 22 3 31 - - - 0.00% 3283 HVAC surcharge 12 5 17 - - - 0.00% 3284 Plumbing surcharge 29 1 1 - - - 0.00% 3287 Commercial plmb surcharge 7 5 (16) - - - 0.00% Subtotal permits 144,686 124,881 112,031 123,600 120,600 (3,000) -2.43% Total licenses & permits 212,041 193,930 175,816 180,270 178,560 (1,710) -0.95% Intergovernmental: 3318 Federal grant - 517 920 - - - 0.00% 3341 Local Government Aid 38,729 60,685 495,704 231,636 - (231,636) -100.00% 3346 PERA Aid 8,671 8,671 8,671 8,671 8,671 - 0.00% 3351 Street Aid - MSA maintenance 93,940 93,541 94,294 100,000 100,000 - 0.00% 3355 Police Aid 121,782 128,710 128,272 150,000 128,000 (22,000) -14.67% 3356 Police training 7,637 7,610 7,532 7,500 7,500 - 0.00% 3358 State forestry grant 7,000 - - - - 0.00% 3359 Other state grants 11,596 17,642 18,064 - 15,000 15,000 0.00% 3370 Other local government revenue 140 3,891 745 - - - 0.00% 3371 IDS # 621 - SRO 59,305 59,335 62,515 60,000 62,000 2,000 3.33% Total intergovernmental 348,800 380,602 816,717 557,807 321,171 (236,636) -42.42% Charges for services 3410 Advertising revenue 420 - - 100 50 (50) -50.00% 3415 Housing inspections - 150 - 50 50 - 0.00% 3418 HRA inspections 2,016 2,256 1,656 1,900 1,900 - 0.00% 3419 Investigations - 554 371 - - - 0.00% 3421 Police reports 1,323 1,378 1,645 1,200 1,200 - 0.00% 3422 Documents / copies 34 60 536 90 90 - 0.00% 3423 Customer service 1,280 1,616 814 300 500 200 66.67% 3425 Book sales - various - 290 265 - - - 0.00% 3426 Reimbursed staff time 995 1,179 780 1,000 1,000 - 0.00% 3430 Right-of-way 3,500 875 9,800 1,000 2,000 1,000 100.00% 3431 Street opening fee (200) 1,125 (875) - - - 0.00% 3432 Tree removal charges 5,148 (4,974) 4,010 10,000 4,500 (5,500) -55.00% 3433 Overload permits 1,200 2,850 1,425 2,000 2,000 - 0.00% 3458 Zoning letter 85 125 100 - 75 75 0.00% 3460 Easement vacation (250) 250 250 - - - 0.00% 3461 Subdivision 1,275 1,275 775 1,200 1,000 (200) -16.67% 3462 Variance 750 1,200 1,125 1,500 1,000 (500) -33.33% 3463 Rezoning 500 500 - 1,000 500 (500) -50.00% 3464 Development - non refund - 375 375 500 350 (150) -30.00% 3465 Code appeal - - 250 - - - 0.00% 3466 Comprehensive Plan Amendmen 500 - - - - - 0.00% 3467 PUD amendment - 375 - 350 350 - 0.00% Total charges for services 18,576 11,459 23,302 22,190 16,565 (5,625) -25.35% 6 General Fund Revenue Detail - 2011 Budget Acct 2007 2008 2009 2010 2011 Change from 2010 #Description Actual Actual Actual Budget Request Dollar Percent Fines and Forfeitures 3510 Ramsey County municipal court 23,955 21,949 17,835 23,000 18,000 (5,000) -21.74% 3515 Mn Highway Patrol 210 466 234 300 300 - 0.00% 3520 Administrative offenses 14,983 13,402 10,050 14,500 10,000 (4,500) -31.03% 3525 False alarm charges 2,685 2,800 1,700 3,000 2,000 (1,000) -33.33% Total fines & forfeitures 41,833 38,617 29,819 40,800 30,300 (10,500) -25.74% Other Revenue 3550 Special assessments 4,632 7,214 8,957 4,800 5,000 200 4.17% 3610 Investment income 118,620 187,181 96,267 104,000 104,000 - 0.00% 3630 Billboard Lease 39,218 105,800 53,549 55,156 55,156 - 0.00% 3631 Water tower rental - - - - 85,868 85,868 0.00% 3634 Equipment and space rental 13 52 5,250 3,000 3,120 120 4.00% 3650 Donations 8,974 3,702 5,390 - - - 0.00% 3655 City fines - 25 - - - - 0.00% 3656 Tree sales 1,405 1,326 (40) 1,200 1,200 - 0.00% 3665 Park site rental 5,579 8,982 9,189 5,000 7,000 2,000 40.00% 3666 Park permit - - - - - - 0.00% 3679 Vending machine commissions 362 - 5 - - - 0.00% 3680 Other revenue 90,990 25,668 5,253 11,000 11,000 - 0.00% 3685 Insurance reimbursements 16,507 19,275 31,551 3,000 4,000 1,000 33.33% 3690 Cash over / short 22 - - - - - 0.00% 3911 Sale of assets 7,425 4,818 - 3,000 3,000 - 0.00% 3912 Resale of materials 178 12,402 5,072 500 500 - 0.00% Total other revenue 293,925 376,445 220,443 190,656 279,844 89,188 46.78% Transfers & Debt proceeds 3972 Transfers: Special Projects - 90,000 - 90,000 90,000 - 0.00% Vehicle replacement 141,500 117,250 44,000 65,600 333,094 267,494 407.77% DARE fund - 4,393 4,393 4,393 3,000 (1,393) -31.71% Water 56,422 58,115 59,859 61,655 63,505 1,850 3.00% Sewer 44,688 46,030 47,411 48,833 50,298 1,465 3.00% Street light 2,000 2,060 2,122 2,186 2,252 66 3.02% Levy reduction - levy 157,600 249,000 249,315 250,000 250,000 - 0.00% Levy reduction - other 134,000 80,000 - - - - 0.00% Total Transfers & Debt 536,210 646,848 407,100 522,667 792,149 269,482 51.56% Total 5,438,411 5,628,431 5,560,903 5,507,225 5,690,311 183,086 3.32% 7 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent City Council (100 - 4100): Personnel services 0100 Salaries, regular 29,292 29,292 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 885 570 1,455 1,455 - 0.00% 0500 Workers compensation 89 36 41 48 67 19 39.58% Total personnel services 32,139 32,086 31,680 32,829 32,848 19 0.06% Materials & supplies 1600 Supplies, operating 1,593 1,140 1,158 1,700 1,600 (100) -5.88% Total materials & supplies 1,593 1,140 1,158 1,700 1,600 (100) -5.88% Contractual services 3030 Other professional services 10,879 10,093 5,985 9,490 9,490 - 0.00% 3610 Memberships 3,371 3,378 3,585 2,826 2,900 74 2.62% 3630 Training & conferences 2,421 1,677 875 2,000 1,800 (200) -10.00% 4800 Bonding & insurance 1,067 1,035 1,060 1,129 1,129 - 0.00% Total contractual services 17,738 16,183 11,505 15,445 15,319 (126) -0.82% Capital outlays - - - - - - 0.00% Total City Council 51,470 49,409 44,343 49,974 49,767 (207) -0.41% Advisory Commissions (100-4110): Materials & supplies 1600 Supplies, operating - - - 225 200 (25) -11.11% 2100 Books & periodicals - - - 75 100 25 33.33% Total materials & supplies - - - 300 300 - 0.00% Contractual services 3030 Other professional services 10,143 3,820 2,199 6,700 6,000 (700) -10.45% 3630 Training & conferences - 153 - 400 350 (50) -12.50% 3900 Festivities Commission 5,875 18,272 7,376 4,500 4,500 - 0.00% Total contractual services 16,018 22,245 9,575 11,600 10,850 (750) -6.47% Capital outlays - - - - - - 0.00% Total Advisory Commissions 16,018 22,245 9,575 11,900 11,150 (750) -6.30% 2011 Budget Summary 8 Fund: 100 Department: 4100 City Council Account Description 2008 2009 2010 2011 Description 1600 Supplies, operating 950 950 850 800 Employee appreciation dinner 950 950 850 800 Plaques and gift certificates for employee appreciation 1,900 1,900 1,700 1,600 3030 Other professional services 3,000 3,000 1,000 1,000 Strategic planning session 8,490 8,490 8,490 8,490 Contractual minutes for Council mtgs ( $315 x 24 reg, + 3 special) 11,490 11,490 9,490 9,490 3610 Memberships 100 25 25 25 Mn Mayor's Association 3,500 3,500 2,801 2,875 North Metro Mayors (1/2 membership; 1/2 in EDA) 3,600 3,525 2,826 2,900 3630 Conferences 2,000 2,000 2,000 1,800 Council training, LMC conference, RCCLG dinners & NLC conference 2,000 2,000 2,000 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,119 20,044 17,145 16,919 4.00%-0.37%-14.46%-1.32% Fund: 100 Department: 4110 Advisory Commissions Account Description 2008 2009 2010 2011 Description 1600 Supplies, operating 100 75 75 60 Misc supplies for various commissions. 200 150 150 140 Copies for Charter Commission 300 225 225 200 2100 Books & periodicals 100 75 75 100 Misc periodicals - Comp plan review, Ordinance revisions. 100 75 75 100 3030 Other professional services 1,000 1,000 1,000 500 Misc. consultant services. 1,550 2,000 2,000 2,000 Charter commission legal fees 4,120 3,700 3,700 3,500 Planning Commission meeting minutes 6,670 6,700 6,700 6,000 3630 Training 250 200 200 175 Misc training & conferences. 250 200 200 175 Planning Commissioner training & conferences 500 400 400 350 3900 Festival in the Park 14,500 4,500 4,500 4,500 City Festival in the Park (overtime for PW and PD and copier costs) 14,500 4,500 4,500 4,500 22,070 11,900 11,900 11,150 89.44%-46.08%0.00%-6.30% 9 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Office of the City Administrator (100 - 4130): Personnel services 0100 Salaries, regular 139,527 143,461 169,137 162,956 168,180 5,224 3.21% 0110 Salaries, over-time - - - 710 702 (8) -1.13% 0150 Salaries, part-time 526 286 320 2,810 2,810 - 0.00% 0300 Social Security 10,405 10,339 12,173 12,734 13,135 401 3.15% 0321 PERA 7,894 9,022 10,977 11,458 12,244 786 6.86% 0400 Group insurance 14,591 14,460 18,489 18,473 19,970 1,497 8.10% 0500 Workers compensation 1,253 501 637 744 973 229 30.78% 0990 Severence - - - - - - 0.00% Total personnel services 174,196 178,069 211,733 209,885 218,014 8,129 3.87% Materials & supplies 1230 Supplies, equipment - 130 - 500 450 (50) -10.00% 1600 Supplies, operating - 34 28 100 90 (10) -10.00% 2100 Books & periodicals - 49 - 50 45 (5) -10.00% Total materials & supplies - 213 28 650 585 (65) -10.00% Contractual services 3100 Communications - 432 456 432 680 248 57.41% 3610 Memberships 1,101 1,076 1,037 2,765 240 (2,525) -91.32% 3630 Training & conferences 2,090 1,260 1,206 2,900 2,775 (125) -4.31% 3800 Mileage 508 233 180 600 500 (100) -16.67% Total contractual services 3,699 3,001 2,879 6,697 4,195 (2,502) -37.36% Capital outlays 7030 Equipment - - - - - - 0.00% 0.00% Total City Administrator 177,895 181,283 214,640 217,232 222,794 5,562 2.56% Elections (100 - 4140): Personnel services 0100 Salaries, regular 10,544 7,350 7,854 14,006 7,045 (6,961) -49.70% 0110 Salaries, overtime 51 - - - - - 0.00% 0150 Salaries, part-time - 18,719 - 14,897 - (14,897) -100.00% 0300 Social Security 777 535 565 1,072 539 (533) -49.72% 0321 PERA 661 476 526 926 467 (459) -49.57% 0400 Group insurance 1,703 1,048 1,213 1,894 1,095 (799) -42.19% 0500 Workers compensation 59 126 52 165 152 (13) -7.88% 0990 Severence - - - - 0.00% Total personnel services 13,795 28,254 10,210 32,960 9,298 (23,662) -71.79% Materials & supplies 1600 Supplies, operating - 2,927 - 2,950 100 (2,850) -96.61% Total materials & supplies - 2,927 - 2,950 100 (2,850) -96.61% Contractual services 3030 Other professional services 614 636 1,641 1,900 825 (1,075) -56.58% 3410 Legal notices - 234 - 400 100 (300) -75.00% Total contractual services 614 870 1,641 2,300 925 (1,375) -59.78% 7030 Capital outlays - - - - - - 0.00% Total Elections 14,409 32,051 11,851 38,210 10,323 (27,887) -72.98% 2011 Budget Summary 10 Fund: 100 Department: 4130 Office of the City Administrator Account Description 2008 2009 2010 2011 Description 1230 Supplies, equipment 800 800 500 450 Furniture or equipment under the $1,000 capitalization threshold 800 800 500 450 1600 Supplies, Operating 100 100 100 90 Miscellaneous supplies 100 100 100 90 2100 Books & Periodicals 50 50 50 45 Miscellaneous reference books 50 50 50 45 3030 Other professional services - - - - Misc. consultant services. - - - - 3100 Communications - 720 432 680 Sprint/Nextel service - 720 432 680 3610 Memberships 773 800 760 - ICMA - International City Manager's Association 50 50 50 50 MAMA - (Administrator) Metro Area Manager's Association 160 160 120 150 Mn City County Managers Association 1,712 1,800 1,800 - New Brighton/Mounds View Rotary Club dues (administrator, police chief) 40 40 35 40 Municipal Clerks & Finance Officers Association 2,735 2,850 2,765 240 3630 Training & conferences 200 200 150 100 MAMA meetings 500 500 500 400 LMC / miscellaneous training 50 50 50 50 Chamber lunches 1,000 1,000 750 700 LMC annual conference 500 500 700 775 Mn City County Managers Assoc seminar - - 750 750 Mn Clerks and Finance Officers Association (MCFOA) institute training - 1,800 - - National ICMA conference (City Administrator)(budget in 2007, 2009) 2,250 4,050 2,900 2,775 3800 Mileage 800 800 600 500 Miscellaneous mileage @ IRS rate. 800 800 600 500 6,735 9,370 7,347 4,780 -21.86%39.12%-21.59%-34.94% Fund: 100 Department: 4140 Elections Account Description 2008 2009 2010 2011 Description 1600 Supplies, operating 100 100 600 Misc supplies - paper, pens, files, and mats for gym 1,350 - 1,350 100 Election Judge meals (even years and special elections) 1,000 - 1,000 - Paper ballots (even years and special elections) 2,450 100 2,950 100 3030 Other professional services 600 625 1,700 625 Ramsey County fees 600 200 200 200 Equip. maint. service costs (voting equip.)(even years and special elections) 1,200 825 1,900 825 3410 Legal notices 400 200 400 100 Primary and general election (even years and special elections) 400 200 400 100 4,050 1,125 5,250 1,025 138.24%-72.22%366.67%-80.48% 11 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Finance (100 - 4150): Personnel services 0100 Salaries, regular 147,317 154,033 159,984 161,839 159,110 (2,729) -1.69% 0110 Overtime - - 14 59 57 (2) -3.39% 0150 Salaries, part-time 18,964 19,444 20,215 20,738 20,935 197 0.95% 0300 Social Security 11,472 12,212 11,811 13,972 13,778 (194) -1.39% 0321 PERA 10,393 11,290 12,091 12,785 13,057 272 2.13% 0400 Group insurance 18,653 18,793 16,241 21,432 22,170 738 3.44% 0500 Workers compensation 741 872 1,063 1,239 1,325 86 6.94% 0990 Severence - - - 0.00% Subtotal 207,540 216,644 221,419 232,064 230,432 (1,632) -0.70% Materials & supplies 1230 Supplies, equipment 192 479 165 350 300 (50) -14.29% 1600 Supplies, operating 117 - 21 100 75 (25) -25.00% 2100 Books & periodicals 351 379 340 350 325 (25) -7.14% Subtotal 660 858 526 800 700 (100) -12.50% Contractual services 3030 Other professional 7,269 8,771 8,890 9,105 9,345 240 2.64% 3430 Printing 205 179 1,736 800 700 (100) -12.50% 3610 Memberships 630 510 700 505 520 15 2.97% 3630 Training 2,315 2,213 1,857 2,090 2,075 (15) -0.72% 5130 Repairs, equipment 3,377 3,513 3,546 3,906 4,098 192 4.92% Subtotal 13,796 15,186 16,729 16,406 16,738 332 2.02% Total Financial Services 221,996 232,688 238,674 249,270 247,870 (1,400) -0.56% 2011 Budget Summary 12 Fund: 100 Department: 4150 Finance Account Description 2008 2009 2010 2011 Description 1230 Supplies, equitpment 400 350 350 300 Furniture or equipment under the $1,000 capitalization threshold 400 350 350 300 1600 Supplies, operating 100 100 100 75 Misc supplies - planners, plaques, folders, files, etc. 100 100 100 75 2100 Books & periodicals 400 350 350 325 Misc computer & finance books & periodicals 400 350 350 325 3030 Other professional services 8,220 8,400 8,580 8,820 30% of audit 425 425 425 425 GFOA financial reporting fee 100 100 100 100 Ramsey County Special Assessment recap report 8,745 8,925 9,105 9,345 3430 Printing 400 400 400 350 Accts Payable & payroll checks & envelopes 400 400 400 350 Invoices, receipts, & bank deposit slips 800 800 800 700 3610 Memberships 190 190 190 200 Government Finance Officer's Association (GFOA) 120 120 120 120 Mn GFOA (2) 190 200 - - AICPA Am. Institute of Certified Public Accountants 190 190 195 200 MNCPA Mn Society of Certified Public Accountants 690 700 505 520 3630 Training & conferences 120 105 90 75 Mn GFOA monthly meetings 550 550 - - Mn GFOA annual seminar (postpone to 12) 1,000 1,000 1,200 1,200 Seminars & training - 1,800 - - GFOA National conference (not annual)(postpone to 09)(11)(12) 500 500 500 500 Accounting software training 300 300 300 300 Mileage 2,470 4,255 2,090 2,075 5130 Equipment repairs 3,450 3,623 3,846 4,038 40% accounting software support charges 50 60 60 60 Safety deposit box rental 3,500 3,683 3,906 4,098 7030 Equipment - - - - - - - - 17,105 19,163 17,206 17,438 -1.89%12.03%-10.21%1.35% 13 2007 2008 2009 2010 2011 Change from 2010 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 2,580 1,719 464 1,500 1,400 (100) -6.67% 1120 Copy materials 2,148 1,451 1,650 2,000 2,000 - 0.00% 1230 Supplies, equipment 2,569 751 1,045 700 700 - 0.00% 1600 Supplies, operating 16,198 15,338 15,024 15,900 15,900 - 0.00% 2100 Books & periodicals 215 239 259 410 375 (35) -8.54% Total materials & supplies 23,710 19,498 18,442 20,510 20,375 (135) -0.66% Contractual services 3010 General legal 51,167 57,805 38,989 48,600 48,600 - 0.00% 3030 Other professional services 18,654 15,541 5,622 9,950 9,600 (350) -3.52% 3100 Telephone 11,065 8,764 7,638 8,400 8,400 - 0.00% 3300 Postage 10,624 9,104 10,397 12,300 11,800 (500) -4.07% 3410 Legal notices 1,901 2,108 2,250 3,000 2,800 (200) -6.67% 3420 Advertising 5,675 8,530 2,034 4,000 3,800 (200) -5.00% 3430 Printing 6,693 6,956 4,200 8,000 7,500 (500) -6.25% 3610 Memberships 9,130 9,961 9,965 10,404 10,404 - 0.00% 3630 Training & conferences 587 138 143 1,400 1,000 (400) -28.57% 4010 Rental, equipment 9,840 5,293 283 750 810 60 8.00% 4800 Insurance & bonds 45,627 21,419 23,673 22,000 22,000 - 0.00% 5100 Repairs, computers 39,638 52,245 62,545 62,868 65,934 3,066 4.88% 5130 Repairs, equipment 1,899 628 838 900 900 - 0.00% Total contractual services 212,500 198,492 168,577 192,572 193,548 976 0.51% Capital outlays 7030 Equipment 23,996 24,651 6,617 25,000 23,000 (2,000) -8.00% Total capital outlays 23,996 24,651 6,617 25,000 23,000 (2,000) -8.00% Total central services 260,206 242,641 193,815 238,082 236,923 (1,159) -0.49% 2011 Budget Summary 14 Fund: 100 Department: 4160 Central Services Account Description 2008 2009 2010 2011 Description 1110 Stationery 945 945 1,500 1,400 Envelopes, labels, letterhead, etc. 945 945 1,500 1,400 1120 Copy materials 2,500 2,500 2,000 2,000 Copy paper 2,500 2,500 2,000 2,000 1230 Supplies, equitpment 700 700 700 700 Computer equipment under the $1,000 capitalization threshold 700 700 700 700 1600 Supplies, operating 14,935 15,400 15,400 15,400 Toner, rug service, paper, pens, staples, desk supplies, etc. 500 500 500 500 Misc operating supplies 15,435 15,900 15,900 15,900 2100 Books & periodicals 400 200 150 105 Employment handbooks/publications 220 255 260 270 Pioneer Press - $115/Star Tribune - $140 620 455 410 375 3010 General legal 30,000 30,000 27,600 27,600 Retainer for legal services 21,000 21,000 21,000 21,000 Legal fees outside scope of retainer. 51,000 51,000 48,600 48,600 3030 Other professional services 6,500 7,000 7,000 6,500 General labor assistance 900 1,050 1,050 1,200 Section 125 (Tax Saver flex spending) & COBRA administration - 1,400 - - Newsletter preparation $350 per issue 900 900 900 900 Human resources items 1,370 1,000 1,000 1,000 Web hosting/GovOffice 9,670 11,350 9,950 9,600 3100 Telephone 10,500 11,000 8,400 8,400 Basic telephone plus long distance 10,500 11,000 8,400 8,400 3300 Postage 917 3,600 - - 4 newsletters-50% cost here, 50% in YMCA. 300 300 300 300 Courier charges (delivery services) 12,000 12,000 12,000 11,500 General postage includes PW mailings for street projects. 13,217 15,900 12,300 11,800 3410 Legal notices 1,200 1,000 1,000 1,000 Truth in taxation notices and Ramsey County fees. 3,000 2,500 2,000 1,800 Legal notices. 4,200 3,500 3,000 2,800 3420 Advertising 4,000 5,000 4,000 3,800 Job opening advertisements for vacant positions 4,000 5,000 4,000 3,800 3430 Printing 7,292 6,000 6,000 6,000 4 newsletter-50% cost here, 50% in YMCA. 1,000 1,000 1,000 750 Miscellaneous printing 1,000 1,000 1,000 750 City guides, directories & miscellaneous 9,292 8,000 8,000 7,500 3610 Memberships 517 517 605 605 Ramsey County League of Local Governments (RCLLG) 9,233 9,799 9,799 9,799 League of Mn Cities 9,750 10,316 10,404 10,404 3630 Training & conferences 1,000 1,000 1,000 800 League training & seminars 400 400 400 200 Information technology training 1,400 1,400 1,400 1,000 4010 Rental, equipment 6,500 - - - Administration copier rental fee and maintenance 2,400 - - - Finance copier rental fee and maintenance 150 150 150 150 Misc 300 600 600 660 Postage machine scale rental 9,350 750 750 810 4800 Bonding & insurance 19,000 18,000 19,000 19,000 Insurance policy premiums 2,000 3,000 3,000 3,000 Allowance for insurance policy deductibles 21,000 21,000 22,000 22,000 5100 Repairs, computer 42,000 55,000 55,000 55,000 Computer network & technology assistance - City of Roseville - 2,885 3,000 3,800 Copier maintenance + overages (3 yr locked agreement thru March 2011) 1,689 1,700 1,868 2,134 Laserfiche annual maintenance 3,000 3,000 3,000 5,000 Computer, printer, and networks repairs. 46,689 62,585 62,868 65,934 5130 Repairs, equipment 900 900 900 900 Postage meter, copy machine, fax, misc. 900 900 900 900 7030 Capital, equipment 11,000 11,000 11,000 9,000 Replace 11 pc's @ $1,000, 5 yr. Replacement cycle on 54 city pc's 9,500 4,500 4,500 4,500 Upgrade general software (Autocad, MS Office Vista) 4,500 9,500 9,500 9,500 Network hardware (switches, routers, hubs, ups, servers) 25,000 25,000 25,000 23,000 236,168 248,201 238,082 236,923 -0.36%5.10%-4.08%-0.49% 15 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Community Development (100 - 4180): Personnel services 0100 Salaries, regular 338,066 322,876 319,530 316,024 315,168 (856) -0.27% 0110 Overtime, regular - - - 1,022 1,022 - 0.00% 0150 Salaries, part time 9,142 8,752 6,539 35,282 18,567 (16,715) -47.38% 0300 Social Security 19,237 17,296 16,560 26,953 25,610 (1,343) -4.98% 0321 PERA 27,913 29,016 30,765 24,510 23,623 (887) -3.62% 0400 Group insurance 43,585 42,261 50,913 52,050 54,229 2,179 4.19% 0500 Workers comp 2,637 1,173 1,315 1,568 1,897 329 20.98% 0600 Unemployment 644 820 - - - - 0.00% 0990 Severence - - - - - - 0.00% Total personnel services 441,224 422,194 425,622 457,409 440,116 (17,293) -3.78% Materials & supplies 1230 Supplies, equipment 15 671 734 700 500 (200) -28.57% 1600 Supplies, operating 57 - 136 500 400 (100) -20.00% 2100 Books & periodicals 994 604 98 1,090 560 (530) -48.62% 2400 Uniforms 193 87 143 300 200 (100) -33.33% Total materials & supplies 1,259 1,362 1,111 2,590 1,660 (930) -35.91% Contractual services 3030 Other professional 9,970 11,212 9,517 14,375 13,550 (825) -5.74% 3040 Consultants, special projects 2,560 14,626 (3,110) - - - 0.00% 3040 Consultants, development rev 3,423 1,171 - 5,000 4,000 (1,000) -20.00% 3040 Consultants, plan review 5,200 3,102 - - - - 0.00% 3100 Telephone 473 521 1,056 1,100 1,100 - 0.00% 3430 Printing 1,005 1,341 1,055 2,500 1,500 (1,000) -40.00% 3610 Memberships 760 730 1,170 1,045 1,005 (40) -3.83% 3630 Training and conferences 3,822 3,200 1,451 2,000 800 (1,200) -60.00% 3800 Mileage 81 61 174 100 100 - 0.00% Total contractual services 27,294 35,964 11,313 26,120 22,055 (4,065) -15.56% Capital outlays 7030 Equipment - - 1,066 - - - 0.00% 7040 Vehicle - - - - - - 0.00% Total capital outlays - - 1,066 - - - 0.00% Total Community Development 469,777 459,520 439,112 486,119 463,831 (22,288) -4.58% 2011 Budget Summary 16 Fund: 100 Department: 4180 Community Development Account Description 2008 2009 2010 2011 Description 1230 Supplies, equipment 700 875 700 500 Miscellaneous equipment & computer peripherals 700 875 700 500 1600 Supplies, operating 500 500 250 200 Presentation supplies 600 500 250 200 Office supplies 1,100 1,000 500 400 2100 Books & periodicals 95 100 90 90 Zoning Practice Newsletter 250 250 200 100 Reference materials 130 130 - 70 Planning Commission Journal 600 600 600 100 Intl. Code Council Manuals and Code Updates 200 200 200 200 Manuals, pamphlets, etc. 1,275 1,280 1,090 560 2400 Uniforms 100 300 300 200 Clothing for inspections staff 100 300 300 200 3030 Other professional 1,250 1,300 1,400 1,300 Ramsey County JPA (geographic information system) 3,500 3,500 3,875 3,900 Permit Works system annual software support (includes busi. lic. mod) - - 1,725 1,750 Business License Module (one time fee)(annual maintenance $375) 750 800 800 500 Filing fees (Ramsey County increased fees from $29 to $48) - 2,500 1,575 1,600 Comcate code enforcement license 1,500 1,500 1,000 500 GIS assistance 4,000 4,000 4,000 4,000 Abatements of nuisance properties 2,500 2,500 - Permit works interface with INCODE 13,500 16,100 14,375 13,550 3040-010 Consulting - special projects 3,400 - - - Comprehensive plan - - - - 3,400 - - - 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 2,500 1,500 1,500 1,000 Development case reviews 1,500 1,500 1,500 1,000 Engineering services 6,000 5,000 5,000 4,000 3100 Telephone 750 500 500 500 Nextel Cell Accounts (2) for inspectors - 600 600 600 Sprint network card for code enforcement 750 1,100 1,100 1,100 3430 Printing 1,000 1,500 1,500 1,500 Forms, flyers, etc. 1,000 1,000 1,000 - Comprehensive plan drafts 2,000 2,500 2,500 1,500 3610 Memberships 495 500 550 500 American Planning Association (APA) - National & state (2) - 150 - - Sensible Land Use Coalition 105 110 110 120 Assoc. of MN Building Officials 55 60 60 60 Fire Marshal's Assoc. of MN 110 110 120 120 International Code Council (ICC) 55 60 60 60 10K Lakes Chapter of ICC 55 60 60 60 MN Assoc. Housing Code Officials 80 80 85 85 MN Building Permit Technicians Association 955 1,130 1,045 1,005 3630 Training & conferences 600 600 500 300 APA state conference (one attendee) 750 750 - - ArcView 9.0 training 395 700 700 - ICC code development hearings (out of state) 500 300 300 200 Other software training 800 600 500 300 Other staff training & seminars 600 - - - League of MN Cities conference - 600 - - APA National conference (2009)(Minneapolis) 3,645 3,550 2,000 800 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 - - 33,525 36,235 28,710 23,715 4.52%8.08%-20.77%-17.40% 17 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Police (100 - 4200): Personnel services: 0100 Salaries, regular 1,324,254 1,424,596 1,469,882 1,448,756 1,425,204 (23,552) -1.63% 0110 Overtime 39,252 33,177 50,022 49,439 49,379 (60) -0.12% 0150 Salaries, part-time 13,547 14,490 11,492 14,754 13,914 (840) -5.69% 0300 Social Security 21,419 22,122 22,338 25,773 25,239 (534) -2.07% 0321 PERA 156,533 181,254 201,575 205,070 206,233 1,163 0.57% 0400 Group insurance 177,534 166,822 183,002 199,536 207,272 7,736 3.88% 0500 Workers compensation 39,926 36,538 44,474 46,312 44,453 (1,859) -4.01% 0600 Unemployment - - 447 - - 0.00% 0990 Severence - - - - - - 0.00% Total personnel services 1,772,465 1,878,999 1,983,232 1,989,640 1,971,694 (17,946) -0.90% Materials & Supplies 1210 Supplies, buildings & grounds 588 - 400 800 800 - 0.00% 1230 Supplies, equipment 1,483 224 3,041 2,000 2,000 - 0.00% 1600 Supplies, operating 9,217 4,356 6,618 5,500 5,500 - 0.00% 1700 Motor, fuels & lubricants 45,231 42,619 33,570 42,250 42,250 - 0.00% 2100 Books & periodicals 1,271 564 233 1,000 900 (100) -10.00% 2400 Uniforms & clothing 15,669 17,385 18,932 21,260 19,040 (2,220) -10.44% Total materials & supplies 73,459 65,148 62,794 72,810 70,490 (2,320) -3.19% Contractual services 3010 General Legal - - 560 - - - 0.00% 3020 Legal, prosecuting attorney 45,340 51,047 46,750 52,530 53,580 1,050 2.00% 3030 Other professional services 5,237 1,077 7,033 5,040 3,990 (1,050) -20.83% 3050 Dispatching 55,755 55,755 55,755 65,319 77,144 11,825 18.10% 3055 Information systems fees 2,540 2,540 2,040 2,616 2,616 - 0.00% 3070 COPS events 1,100 266 273 1,200 800 (400) -33.33% 3080 Veternarian services 2,875 2,900 2,525 3,750 6,000 2,250 60.00% 3100 Telephone 3,025 1,827 1,917 2,000 2,000 - 0.00% 3210 Electricity 247 248 270 360 320 (40) -11.11% 3430 Printing 649 773 701 1,200 800 (400) -33.33% 3610 Memberships 1,230 1,446 1,861 1,460 1,475 15 1.03% 3630 Training 11,987 11,201 11,950 13,560 11,110 (2,450) -18.07% 4010 Rental, equipment 1,869 2,255 - - - - 0.00% 4800 Insurance & bonds 16,394 36,161 18,390 23,000 24,000 1,000 4.35% 5100 Technology maintenance 30,864 30,015 33,967 35,607 37,227 1,620 4.55% 5130 Maintenance, equipment 6,879 4,447 10,570 9,540 10,640 1,100 11.53% Total contractual services 185,991 201,958 194,562 217,182 231,702 14,520 6.69% Capital outlays 7030 Equipment 11,290 13,027 8,134 11,600 1,200 (10,400) -89.66% 7040 Vehicles 43,243 76,777 28,105 29,000 29,000 - 0.00% Total capital outlays 54,533 89,804 36,239 40,600 30,200 (10,400) -25.62% Total police 2,086,448 2,235,909 2,276,827 2,320,232 2,304,086 (16,146) -0.70% 2011 Budget Summary 18 Fund: 100 Department: 4200 Police Account Description 2008 2009 2010 2011 Description 1210 Supplies, bldgs & grounds - 900 800 800 Carpet cleaning & misc maintenance items - 900 800 800 1230 Supplies, equipment 2,700 2,500 2,000 2,000 Miscellaneous office equipment 2,700 2,500 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. 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 5,500 1700 Motor, fuels, & lubs -40,050 50,063 42,250 42,250 Unleaded gas 13,000 gallons @ $3.25/gal. (down from 13,350 gal.) 40,050 50,063 42,250 42,250 2100 Books & periodicals 900 1,000 1,000 900 Traf. law, crim. law, HR, employ. law, school year books, & misc. books 900 1,000 1,000 900 2400 Uniforms & clothing 730 720 720 720 Chief 730 720 720 - Deputy Chief 4,900 7,500 5,000 4,000 Initial officer set-ups replacing up to two retiring officers 12,410 12,240 12,240 12,240 17 officers @ $720 ($710 in 07, 08, 09, 10) 1,050 1,080 1,080 1,080 Administrative assistant, Clerk-typist, Community Service Officer 1,500 1,500 1,500 1,000 Traffic vests, Taser holsters, & misc items 21,320 23,760 21,260 19,040 3020 Legal, prosecuting attorney 51,000 52,530 52,530 53,580 Retainer ($4,337.50 per month)(misc charges $1,530) 51,000 52,530 52,530 53,580 3030 Other professional services 600 600 600 600 Tobacco compliance project 500 500 500 150 Hazardous material disposal fee 2,400 2,400 2,200 1,500 Lab fees, blood tests, physical tests, video, misc. 240 240 240 240 Automated Pawn service 3,150 3,150 1,500 1,500 Civil Service and medical testing for new officers 4,700 2,500 - - Transcription service (for large case files) 11,590 9,390 5,040 3,990 3050 Dispatching 55,755 55,755 65,319 77,144 Ramsey County dispatching 55,755 55,755 65,319 77,144 3055 Informational systems fees 2,227 2,101 2,101 2,101 State service fee - CJDN ($510 per quarter in 07, 08, 09,10) 1,020 120 - - Dedicated CAD Line per St.Paul Records Mgt. System requirement 600 515 515 515 IACP.net ($500 annual in 06, 07, 08, 09,10) 3,847 2,736 2,616 2,616 3070 COPS events 1,200 1,200 1,200 800 National night out, town hall meeting, child ID, stickers 1,200 1,200 1,200 800 3080 Veterinarian services 3,500 3,605 3,750 6,000 Brighton Vet Clinic 3,500 3,605 3,750 6,000 3100 Telephone 3,000 3,000 2,000 2,000 Nextel cell phones (10 phones) 3,000 3,000 2,000 2,000 3210 Electricity 300 360 360 320 Civil defense siren's electricity 300 360 360 320 19 Fund: 100 Department: 4200 Police (continued) Account Description 2008 2009 2010 2011 Description 3430 Printing 1,200 1,200 1,200 800 Dept manual, Emergency management manual, business cards, 1,200 1,200 1,200 800 3610 Memberships 90 - - - A.L.E.R.T. International 125 100 - - American Assoc. of Police Polygraphers 100 100 100 100 Assoc. Metro Emergency Managers 35 35 35 50 FBI/LEEDA Law Enfor. Execu. Devel. Assoc. 1@ $35 60 - 60 60 Tri-County Investigator Association 45 45 45 45 Mn Crime Prevention Association 35 35 35 35 Mn DARE Officers Association 100 30 30 30 MN Emergency Managers Assoc. 80 - - - MN Juvenile Officer Assoc 2@ $40 150 200 200 200 Mn Police chiefs 100 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 35 National DARE Officers Association 40 40 40 40 Notary commission (3 year due in 2009) 630 630 630 630 POST license reimbursement 7 @ $90 40 30 30 30 Prof. Law Enforcement Admin. Assoc. 25 25 25 25 National Association of Town Watch 1,756 1,500 1,460 1,475 3630 Training 850 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 750 - Juvenal Officer conference 300 300 300 300 Emergency Management Conference 750 500 - 400 MN Sex Crimes Investigators Assoc Conference 3,000 4,000 4,000 3,000 Tuition reimbursement 2,200 1,200 1,200 1,200 Supervisor training 1,200 600 600 600 Emergency Management training 2,500 2,100 3,100 2,000 Employee development courses 2,670 2,670 1,190 1,190 Post training for officers at Century College (2 officers) 15,740 14,540 13,560 11,110 4010 Rental, equipment 2,700 - - - Copy machine 2007 rate $174.99 X 1.03 =$180.25/mo or $2163/year 2,700 - - - 4800 Insurance & bonds 18,000 17,000 18,000 18,500 Liability and automotive insurance 3,500 4,500 5,000 5,500 Allowance for insurance policy deductibles 21,500 21,500 23,000 24,000 5100 Technology - maintenance 2,000 2,000 2,000 2,000 Miscellaneous repairs agreements & support - 1,200 1,200 1,200 Copier maintenance + overages (3 yr locked agreement thru March 2011) 32,407 32,407 32,407 34,027 Operating costs of police records management system 34,407 35,607 35,607 37,227 5130 Maintenance, equipment 1,900 1,900 1,900 2,500 Misc. equipment repair - defibs, cameras, recorders, fax, printers. 1,000 - - - Car washing 450 450 450 450 Fire extinguisher recharging 2,000 1,500 1,500 1,500 Squad mobil digital computer repairs 50 500 500 500 Civil Defense siren repair & maintenance (all 3 have been replaced 06,07,08) 1,500 1,500 2,000 2,500 Radio repair 2,450 3,190 3,190 3,190 800 MHZ radio licenses fees 37@ 7.18 per month 9,350 9,040 9,540 10,640 7030 Equipment 8,800 8,000 8,000 - 2 replacement squad mobile computers 2,500 2,500 2,500 - Light bar & Siren 1,050 1,100 1,100 1,200 (1) Taser 3,200 - - - (1) Radar 15,550 11,600 11,600 1,200 7040 Vehicles - Patrol 58,000 58,000 29,000 29,000 Two squads $23,000 + set-up $6000 x 2 = 58,000. One in Forfeiture Fund. 58,000 58,000 29,000 29,000 360,865 365,286 330,592 332,392 2.94%1.22%-9.50%0.54% 20 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Fire (100 - 4210): Contractual services 3032 Contractual fire services 247,780 276,197 279,336 278,750 270,573 (8,177) -2.93% 3050 Dispatching 3,339 3,452 3,640 4,000 4,000 - 0.00% Total contractual services 251,119 279,649 282,976 282,750 274,573 (8,177) -2.89% Capital outlays: 7040 Vehicles & equipment 32,613 13,048 35,789 46,452 22,894 (23,558) -50.71% Total capital outlays 32,613 13,048 35,789 46,452 22,894 (23,558) -50.71% Total Fire 283,732 292,697 318,765 329,202 297,467 (31,735) -9.64% 2011 Budget Summary 21 Fund: 100 Department: 4210 Fire Account Description 2008 2009 2010 2011 Description 3032 Contractual fire services 276,197 290,201 278,750 270,573 Share of joint fire dept. op. costs (09 - 15.37%, 10 - 15.216%,11 - 14.77%) 276,197 290,201 278,750 270,573 3050 Dispatching 4,000 4,000 4,000 4,000 Anoka County dispatching fee 4,000 4,000 4,000 4,000 7040 Capital, vehicles & equipment 13,048 35,789 46,452 22,894 Share of joint fire department's capital costs 13,048 35,789 46,452 22,894 293,245 329,990 329,202 297,467 10.09%12.53%-0.24%-9.64% 22 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Recreation (100 - 4350): Contractual services: 3036 Contractual recreation 121,077 134,951 107,201 123,900 107,900 (16,000) -12.91% 4800 Bonding & insurance 1,489 1,392 1,446 1,700 1,700 - 0.00% Total contractual services 122,566 136,343 108,647 125,600 109,600 (16,000) -12.74% Capital outlays 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total Recreation 122,566 136,343 108,647 125,600 109,600 (16,000) -12.74% 2011 Budget Summary 23 Fund: 100 Department: 4350 Recreation Account Description 2008 2009 2010 2011 Description 3036 Contractual recreation 94,600 97,500 95,400 97,400 Management of recreation & park programs by YMCA 8,400 8,400 10,500 10,500 Ice Skating supervision 18,000 18,000 18,000 - Playground supervision 121,000 123,900 123,900 107,900 4800 Bonding & insurance 1,700 1,700 1,700 1,700 Insurance & bonding cost. 1,700 1,700 1,700 1,700 122,700 125,600 125,600 109,600 2.27%2.36%0.00%-12.74% 24 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent 2011 Budget Summary Parks (100 - 4360): Personnel services 0100 Salaries, regular 108,283 115,771 118,198 114,917 115,044 127 0.11% 0110 Overtime, regular 6,434 5,467 5,749 4,376 4,333 (43) -0.98% 0150 Salaries, part-time 48,616 48,297 47,152 41,400 36,000 (5,400) -13.04% 0300 Social Security 12,049 12,237 11,980 12,293 11,886 (407) -3.31% 0321 PERA 8,478 9,133 9,635 8,350 8,655 305 3.65% 0400 Group insurance 16,951 17,222 20,335 19,968 20,816 848 4.25% 0500 Workers compensation 4,240 3,885 4,537 4,949 5,217 268 5.42% Total personnel services 205,051 212,012 217,586 206,253 201,951 (4,302) -2.09% Materials & supplies: 1210 Supplies, bldgs & grnds 9,745 15,508 12,927 13,420 13,960 540 4.02% 1220 Supplies, vehicles 5,161 5,069 8,455 4,800 4,800 - 0.00% 1230 Supplies, equipment 1,587 2,136 1,285 2,200 1,950 (250) -11.36% 1600 Supplies, operating 7,332 6,689 5,788 8,200 6,000 (2,200) -26.83% 1700 Motor fuels & lubs 6,675 8,681 5,452 10,250 9,225 (1,025) -10.00% 2400 Uniforms & clothing 1,848 1,113 1,711 2,030 2,030 - 0.00% 2410 Mats & towels 758 1,137 1,436 800 800 - 0.00% Total materials & supplies 33,106 40,333 37,054 41,700 38,765 (2,935) -7.04% Contractual services: 3030 Other professional services 3,616 182 526 2,155 2,380 225 10.44% 3100 Telephone 3,360 3,748 2,603 1,500 1,500 - 0.00% 3200 Water & sewer 7,418 4,808 3,998 7,500 6,000 (1,500) -20.00% 3210 Electricity 5,391 6,921 5,670 6,500 6,500 - 0.00% 3220 Natural gas 4,148 5,797 4,880 5,000 5,000 - 0.00% 3530 Refuse collection 73 - - - - - 0.00% 3610 Memberships 142 - 63 65 65 - 0.00% 3630 Training & conferences 1,947 198 1,878 1,805 1,845 40 2.22% 3900 Grants & subsidies 8,719 10,608 10,608 10,608 10,608 - 0.00% 4010 Rental, equipment - - - 200 200 - 0.00% 4030 Portable restrooms 5,588 5,703 5,753 6,300 6,150 (150) -2.38% 4800 Bonding & insurance 12,847 13,922 14,458 15,000 15,000 - 0.00% 5110 Repairs, bldg & grounds 5,288 6,003 5,311 2,000 4,000 2,000 100.00% Total contractual services 58,537 57,890 55,748 58,633 59,248 615 1.05% Capital outlays 7030 Equipment 12,024 - - - 66,000 66,000 0.00% 7050 Construction - 5,845 - - - - Total capital outlays 12,024 5,845 - - 66,000 66,000 0.00% Total Parks 308,718 316,080 310,388 306,586 365,964 59,378 19.37% 25 Fund: 100 Department: 4360 Parks Account Description 2008 2009 2010 2011 Description 1210 Supplies, bldgs & grounds 200 200 200 200 Replace bleacher parts 100 100 200 200 Repair hockey boards, gates 200 200 200 300 Sod 210 210 300 400 Janitorial supplies 210 210 210 150 Snow shovels 210 210 210 210 Ice melt 400 400 400 600 Round up 720 720 500 700 Repair fences, nets 800 800 500 500 Perennial flowers for park signs 720 720 700 700 Replace play equipment parts 3,000 4,500 5,000 5,000 Broadleaf control 1,200 600 500 500 Goose repellent 2,165 2,165 2,000 2,000 Replace irrigation heads 4,300 2,300 2,500 2,500 Seed, fertilizer 14,435 13,335 13,420 13,960 1220 Supplies, vehicles 4,325 4,325 4,300 4,300 Oil filters, mower blades, tires, vehicle registration fees, 500 500 500 500 Miscellaneous repairs 4,825 4,825 4,800 4,800 1230 Supplies, equipment 155 450 250 250 Drinking fountain parts 464 464 450 450 Park signage 1,000 - - - Trash cans (3) 810 - 250 250 Magnetic bases and replacement bases (ballfields) 800 1,200 1,250 1,000 Replace park equipment, fixtures and misc parts 3,229 2,114 2,200 1,950 1600 Supplies, operating 1,000 1,000 1,000 800 Sand/fiber fill for play lots & courts 100 100 100 200 Tri mix - 600 600 800 Wood chips for trees 900 900 900 500 Ag-lime for fields 500 500 500 500 Surface drying compound 400 400 400 400 Nets 1,600 1,400 1,400 1,400 Field paint & chalk 800 800 1,000 - Jox box (Silverview (2), CH park (1) in 2014) 1,400 1,200 1,200 800 Landscaping materials 1,100 1,100 1,100 600 Percentage of shop costs 7,800 8,000 8,200 6,000 1700 Motor fuels & lubs 6,000 7,500 6,500 5,850 1,800 gallons of unleaded gas @ $3.25 3,100 4,250 3,750 3,375 900 gallons of diesel fuel @ $3.75 9,100 11,750 10,250 9,225 2400 Uniforms & clothing 415 434 434 434 Safety glasses, masks, ear protection, shoes per contract 2,375 1,596 1,596 1,596 Uniforms for 1.9 @ $840 2,790 2,030 2,030 2,030 2410 Mats & towels 800 800 800 800 Share of floor mats and shop towels 800 800 800 800 3030 Other professional services 155 155 155 155 Fire extinguisher service - - - 225 Backflow preventer testing 2,000 2,000 2,000 2,000 Tree trimming 2,155 2,155 2,155 2,380 26 Fund: 100 Department: 4360 Parks (continued) Account Description 2008 2009 2010 2011 Description 3100 Telephone 1,200 1,200 1,200 1,200 Cellular phones 100 100 - - Replace telephones in park buildings 2,000 2,200 300 300 Security at Silver View (phones removed from park buildings) 3,300 3,500 1,500 1,500 3200 Water & wastewater 6,000 7,500 7,500 6,000 Parkland irrigation & park bathrooms 6,000 7,500 7,500 6,000 3210 Electricity 5,150 6,469 6,500 6,500 Est. 5 park buildings, park sec. lighting, court & field lighting & misc. 5,150 6,469 6,500 6,500 3220 Natural gas 3,195 4,978 5,000 5,000 Heating cost for Random, Hillview, Groveland, & Lambert Park bldgs. 3,195 4,978 5,000 5,000 3610 Memberships 400 - - - MN Recreation & Park Assoc 65 65 65 65 Minnesota Safety Council 85 - - - St of Minn, CPV Program 550 65 65 65 3630 Training & conferences 40 40 40 40 Chemical applicator license 250 250 75 75 Computer classes 500 500 - - Tuition reimbursement 200 200 200 200 Confined space training 120 120 120 120 Hearing tests 370 370 370 370 Low voltage/power limited training 60 60 60 60 Maintenance EXPO 110 110 110 110 MPRA & loss control workshops 200 200 - - Minn Toro Industries school 200 200 200 200 Pesticide application class 20 20 20 20 Pesticide license renewal 100 100 100 100 State low voltage electrical licenses (2) 450 450 450 450 Sewer, Water & traffic certificates - - - 100 Tree inspector license 60 60 60 - Work zone traffic control 2,680 2,680 1,805 1,845 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 200 Tools and equipment 200 200 200 200 4030 Portable restrooms 7,500 6,300 6,300 6,150 For May thru Oct, plus special events such as tournaments, & extra cleanings and insurance 7,500 6,300 6,300 6,150 4800 Bonding & insurance 14,500 14,000 12,000 12,000 Insurance policy premiums 2,500 3,000 3,000 3,000 Allowance for insurance policy deductibles 17,000 17,000 15,000 15,000 5110 Repairs, bldgs & grounds 720 720 500 1,000 Windows & doors 515 515 500 1,000 Replace locks 515 515 500 500 Light bulbs 515 515 500 1,500 Repairs to furnaces, plumbing, phones, electrical, etc 2,265 2,265 2,000 4,000 7030 Capital, equipment - - - - Mower replacement (vehicle & equip. fund) - - - 24,000 Chipper - 32,000 - 36,000 Replace #404 F250 (postponed from to 2009) - - - 6,000 Plow for unit #428 - 32,000 - 66,000 7050 Capital, construction 4,000 - - - Mounument signs for 1/2 of parks (1st half started in 07) - - - - Resurface Silverview Basketball Court 4,000 - - - 107,582 138,574 100,333 164,013 -20.56%28.81%-27.60%63.47% 27 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent 2011 Budget Summary Forestry (100 - 4380): Materials & supplies 1200 Supplies, landscaping 6,368 1,491 581 4,250 3,000 (1,250) -29.41% Total materials & supplies 6,368 1,491 581 4,250 3,000 (1,250) -29.41% Contractual services 3030 Professional services 8,223 18,510 25,097 13,000 24,000 11,000 84.62% 3033 Joint powers forester 25,325 25,452 19,659 16,000 - (16,000) -100.00% 3520 Tree removal 23,029 4,222 5,109 28,000 28,000 - 0.00% 3610 Memberships - - - - - - 0.00% 3630 Training & conferences - - 50 200 - (200) Total contractual services 56,577 48,184 49,915 57,200 52,000 (5,200) -9.09% Capital outlays 7030 Equipment - - - - - - 0.00% Total Forestry 62,945 49,675 50,496 61,450 55,000 (6,450) -10.50% 28 Fund: 100 Department: 4380 Forestry Account Description 2008 2009 2010 2011 Description 1200 Supplies, landscaping 575 575 575 400 Landscaping materials 575 575 575 800 Small trees to replace damaged trees 3,100 3,100 3,100 1,800 Large trees - storm damage replacement 4,250 4,250 4,250 3,000 3030 Professional services 11,000 11,000 11,000 9,000 Boulevard tree trimming for 1/4 of city - - - 15,000 Forestry consulting 2,000 2,000 2,000 - Tree trimming around Silver View Park (moved to parks) 13,000 13,000 13,000 24,000 3033 Joint powers forester 27,240 28,058 16,000 - Amount per joint powers agreement 27,240 28,058 16,000 - 3520 Tree removal 26,000 26,000 28,000 28,000 Remove or treat diseased trees 26,000 26,000 28,000 28,000 3630 Training & memberships 200 200 200 - Forestry licensing seminar 200 200 200 - 70,690 71,508 61,450 55,000 1.50%1.16%-14.07%-10.50% 29 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Public Works Administration (100-4410): Personnel services: 0100 Salaries, regular 74,020 54,954 63,041 88,009 91,346 3,337 3.79% 0150 Salaries, part-time 132 71 80 728 728 - 0.00% 0300 Social Security 5,317 3,883 4,451 6,789 7,044 255 3.76% 0321 PERA 4,235 3,144 4,237 6,160 6,623 463 7.52% 0400 Group insurance 7,813 6,410 9,121 13,275 13,814 539 4.06% 0500 Workers compensation 1,297 987 1,306 1,372 1,097 (275) -20.04% Total personnel services 92,814 69,449 82,236 116,333 120,652 4,319 3.71% Materials & supplies: 1230 Supplies, equipment - - - - - - 0.00% 1600 Operating supplies - - 153 200 200 - 0.00% 2400 Uniforms & clothing 298 - - 400 400 - 0.00% Total materials and supplies 298 - 153 600 600 - 0.00% Contractual services: 3030 Other professional services 895 44,223 23,503 1,040 340 (700) -67.31% 3610 Memberships 142 185 433 883 683 (200) -22.65% 3630 Training & conferences 819 100 469 1,280 1,140 (140) -10.94% 3800 Mileage reimbursement - - - 300 300 - 0.00% Total contractual services 1,856 44,508 24,405 3,503 2,463 (1,040) -29.69% Capital outlays: 7030 Equipment 1,791 - - - - - 0.00% Total capital outlays 1,791 - - - - - 0.00% Total public works administration 96,759 113,957 106,794 120,436 123,715 3,279 2.72% 2011 Budget Summary 30 Fund: 100 Department: 4410 Public Works Adminstration Account Description 2008 2009 2010 2011 Description 1600 Operating Supplies 300 200 200 200 Office supplies 300 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 - - - Capital Improvement Program Software (maintenance contract) - - 700 - EJCDC Construction document set 240 240 240 240 Drug & alcohol testing - federal mandate 1,040 340 1,040 340 3610 Memberships/license fee 490 300 113 113 American Public Works Association memb. (APWA) (1/4 of $452) 50 50 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 275 MN Safety Council - - 200 - MN Board of AELSLAGID (PE Renewal even years) 195 195 195 195 American Society of Civil Engineers 1,050 860 883 683 3630 Training & conferences 600 600 600 600 CEAM / APWA conferences 125 125 50 50 Computer classes/Web training 100 100 100 100 Confined space training 60 60 60 60 Hearing tests 30 30 30 30 Maintenance Expo 100 100 100 - Pesticide applicator's class 10 10 10 - Pesticide license renewal 600 600 200 200 Required continuing education seminars 200 200 100 100 Supervisor training 30 30 30 - Work zone traffic control 1,855 1,855 1,280 1,140 3800 Mileage reimbursement 300 300 300 300 vehicle mileage reimbursement 300 300 300 300 7030 Capital, equipment - - - - - - - - - - 4,945 3,955 4,103 3,063 -38.23%-20.02%3.74%-25.35% 31 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent 2011 Budget Summary Building & Grounds Maintenance (100 - 4460): Personnel services: 0100 Salaries, regular 11,654 11,816 11,676 11,237 11,575 338 3.01% 0110 Salaries, overtime 446 380 764 908 935 27 2.97% 0300 Social Security 855 837 813 929 957 28 3.01% 0321 PERA 755 784 839 851 907 56 6.58% 0400 Group insurance 2,220 2,111 2,564 2,496 2,602 106 4.25% 0500 Workers compensation 473 515 598 685 414 (271) -39.56% Total personnel services 16,403 16,443 17,254 17,106 17,390 284 1.66% Materials & supplies: 1210 Supplies, building & grounds 3,695 1,719 329 1,500 1,500 - 0.00% 1220 Supplies, vehicles - (89) - - - - 0.00% 1230 Supplies, equipment 326 1,547 928 690 690 - 0.00% 1600 Supplies, operating 5,186 3,464 3,767 6,000 5,400 (600) -10.00% 2400 Uniforms & clothing 96 81 - 120 120 - 0.00% Total materials & supplies 9,303 6,722 5,024 8,310 7,710 (600) -7.22% Contractual services: 3030 Other professional services 15,527 26,835 25,590 23,360 23,360 - 0.00% 3200 Water & sewer 1,794 993 1,773 1,800 1,800 - 0.00% 3210 Electricity 23,046 23,584 24,238 25,000 25,000 - 0.00% 3220 Natural gas 24,193 26,233 22,474 26,612 26,612 - 0.00% 3530 Refuse collection 9,559 9,942 9,183 10,121 10,021 (100) -0.99% 4010 Rental, equipment 596 367 - 205 205 - 0.00% 4800 Insurance 5,289 5,733 10,850 7,000 7,000 - 0.00% 5110 Repairs, bldgs & grounds 12,310 10,573 4,470 9,556 9,556 - 0.00% 5130 Repairs, equipment 4,548 10,725 11,583 7,115 6,600 (515) -7.24% Total contractual services 96,862 114,985 110,161 110,769 110,154 (615) -0.56% Capital outlays 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total buildings & grounds 122,568 138,150 132,439 136,185 135,254 (931) -0.68% 32 Fund: 100 Department: 4460 Building & Ground Maintenance Account Description 2008 2009 2010 2011 Description 1210 Supplies, bldgs & grounds 1,000 1,500 1,500 1,500 Bldg repairs, cleaning/heating supplies, batteries. 1,000 1,500 1,500 1,500 1230 Supplies, equipment 430 430 430 430 Air compressor parts, filters, hoses, etc. 300 300 - - Barn fan (1) purchase another in 2009 260 260 260 260 Pressure washer repair parts, garage door motor 990 990 690 690 1600 Supplies, operating 300 300 300 300 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 750 250 Goose repellent 500 500 500 500 Weed control - city hall 400 400 400 400 Office supplies 100 100 100 - Meeting refreshments 600 600 600 600 Steel supplies 700 700 700 700 Paint & supplies - parking lot & building 6,000 6,000 6,000 5,400 2400 Uniforms & clothing 120 120 120 120 Uniforms 0.1 FTE x $1,200 120 120 120 120 3030 Other professional services 660 700 700 700 Annual fire & backflow inspection 20 60 60 60 Boiler & pressure vessel registration program 2,500 2,500 2,500 2,500 City Hall HVAC maintenance contract - - 100 100 MN DOL operating permit - elevator (previously in acct. 5110) 15,700 15,750 15,750 15,750 City Hall cleaning contract - 3,000 3,000 3,000 Carpet cleaning, floor striping & waxing 765 250 250 250 Fire monitoring service (City hall sprinkler system) 850 1,000 1,000 1,000 Fire extingiusher service 20,495 23,260 23,360 23,360 3200 Water & Sewer 1,030 1,800 1,800 1,800 Service at City Hall and Public Works buildings 1,030 1,800 1,800 1,800 3210 Electricity 21,000 26,020 25,000 25,000 Electricity at City Hall and Public Works buildings 21,000 26,020 25,000 25,000 3220 Natural gas 20,000 26,612 26,612 26,612 Natural gas at City Hall and Public Works buildings 20,000 26,612 26,612 26,612 3530 Refuse collection 130 130 130 130 Lamps $100, batteries $30 430 260 260 260 Hazardous waste generator permit 500 500 500 400 Used oil filters ($100 in vehicle maint.) 5,871 8,128 8,200 8,200 Facility dumpsters, city hall, public works & parks 3,190 1,103 1,031 1,031 Hazardous waste disposal 10,121 10,121 10,121 10,021 4010 Rental, equipment 205 205 205 205 Misc. rentals 205 205 205 205 4800 Bonding & insurance 6,000 5,500 5,500 5,500 Insurance policy premiums 1,000 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 1,900 2,100 2,100 2,100 Building repairs 1,000 456 456 456 Elevator maintenance ($114 quarterly) 350 350 350 350 Fire sprinklers & alarm repairs 3,500 4,000 4,000 4,000 General building & ground maintenance 1,000 1,242 1,350 1,350 Exterminator- City Hall and Public Works (request) 200 - - - Fire extinguishers (in 3030) 9,250 9,448 9,556 9,556 5130 Repairs, equipment - 515 515 - Telephone repairs - 2,500 5,000 5,000 HVAC system service - 6,000 - - HVAC safety improvements per LMCIT (one time upgrades to boiler) 300 200 200 200 Multi-function office machine repair 1,400 1,400 1,400 1,400 Oil heater maintenance 1,700 10,615 7,115 6,600 7030 Capital, equipment 1,200 900 - - Floor scrubber for shop (1 in 2008 and 2009) 1,200 900 - - 100,111 124,591 119,079 117,864 -4.77%24.45%-4.42%-1.02% 33 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent 2011 Budget Summary Vehicle & Equipment Maintenance (100 - 4465): Personnel services: 0100 Salaries, regular 29,555 29,492 30,277 30,039 30,039 - 0.00% 0110 Salaries, overtime - - 72 505 505 - 0.00% 0300 Social Security 2,248 2,231 2,137 2,337 2,337 - 0.00% 0321 PERA 1,842 1,916 1,933 2,138 2,215 77 3.60% 0400 Group insurance 3,011 3,209 3,892 4,781 4,925 144 3.01% 0500 Workers compensation 1,173 1,258 1,462 1,723 1,008 (715) -41.50% Total personnel services 37,829 38,106 39,773 41,523 41,029 (494) -1.19% Materials & supplies: 1220 Supplies, vehicles 12,508 15,203 14,329 13,450 13,450 - 0.00% 1230 Supplies, equipment 2,125 1,123 1,929 2,800 2,600 (200) -7.14% 1600 Supplies, operating 3,261 3,730 1,995 3,250 3,875 625 19.23% 1700 Motor fuels & lubricants 7,201 7,959 4,729 5,085 4,935 (150) -2.95% 2400 Uniforms & clothing 960 485 1,871 600 900 300 50.00% 2410 Mats & towels 758 1,137 1,407 650 650 - 0.00% Total materials & supplies 26,813 29,637 26,260 25,835 26,410 575 2.23% Contractual services: 3100 Telephone 897 1,107 1,143 1,000 1,150 150 15.00% 3530 Refuse collection - - - - 100 100 0.00% 3610 Memberships 142 - 63 65 65 - 0.00% 3630 Training 1,303 881 48 1,115 1,005 (110) -9.87% 4010 Rental, equipment - - - 100 100 - 0.00% 5120 Repairs, vehicles 4,913 17,967 6,352 9,600 10,900 1,300 13.54% 5130 Repairs, equipment 9,613 5,041 11,189 5,500 5,500 - 0.00% Total contractual services 16,868 24,996 18,795 17,380 18,820 1,440 8.29% Capital outlays 7030 Equipment - - - - - - 0.00% 7050 Construction - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total vehicle & equipment maintenance 81,510 92,739 84,828 84,738 86,259 1,521 1.79% 34 Fund: 100 Department: 4465 Vehicle & Equipment Maintenance Account Description 2008 2009 2010 2011 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 550 Minor repairs, rebuilds 900 900 900 900 Automotive parts 1,100 1,100 1,100 1,100 Filters: oil, air, fuel, transmission 1,300 1,300 1,300 1,300 Brake pads & shoes 6,400 6,400 6,400 6,400 Tires & batteries 13,450 13,450 13,450 13,450 1230 Supplies, equipment 200 200 200 200 Small equipment tune up items 500 500 500 400 Filters belts & hoses 1,100 1,100 1,100 1,000 Hydraulic system repairs 1,000 1,000 1,000 1,000 Tires - dump trucks, loader, & backhoe 2,800 2,800 2,800 2,600 1600 Supplies, operating 900 900 900 1,525 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 200 Steel for repairs & fabrication 500 500 500 500 Solvents & degreasers 500 500 500 500 Fastners & electrical supplies 3,250 3,250 3,250 3,875 1700 Motor fuels & lubs 40 60 60 60 Gear lube 400 450 450 450 ATF - 7 cases 750 750 750 600 Aftermarket additives 720 900 900 900 Engine oil: 150 gallons @ $6 2,700 3,375 2,925 2,925 Unleaded fuel: 900 gallons @ $3.25 4,610 5,535 5,085 4,935 2400 Uniforms & clothing 600 600 600 600 Uniforms 0.5 FTE @ $1,200 600 600 600 600 2410 Mats & towels 500 650 650 650 Share of floor mats and shop towels 500 650 650 650 3100 Communications 1,200 1,000 1,000 1,150 Cellular telephone 1,200 1,000 1,000 1,150 3530 Refuse collection 210 - - 100 Oil filter recycling 210 - - 100 3610 Memberships 85 - - - CPV membership (Cooperative purchasing venture)(State contract) 65 65 65 65 Minnesota Safety Council 150 65 65 65 3630 Training 200 200 50 - Computer classes 100 100 100 100 Confined space training 200 200 200 - Electronics updates, other classes 60 60 60 60 Hearing test 30 30 30 30 Maintenance Expo 200 200 50 200 Misc training 140 140 160 180 ASE certification 300 300 300 300 Water/sewer license 60 60 60 60 Vehicle inspection license renewal (DOT required) 75 75 75 75 Vehicle inspection recertification (DOT required) 30 30 30 - Work zone traffice control 1,395 1,395 1,115 1,005 4010 Rental, equipment 100 100 100 100 Specialty tool & equipment rental and mileage reimbursement 100 100 100 100 5120 Repairs, vehicles 4,000 4,500 4,500 4,500 Accident repairs 300 400 400 400 Alignments 1,000 1,000 1,000 1,000 Glass replacement 400 400 400 400 Radiator repairs, replacement 700 700 700 500 Tire repairs 600 600 600 700 Ignition scanner software update - - - 1,400 Mitchell On Demand Software (every 4 years, next 2015) 2,000 2,000 2,000 2,000 Transmission repairs 9,000 9,600 9,600 10,900 5130 Repairs, equipment 350 400 500 500 Accident repairs 1,600 2,000 3,000 3,000 Mechanical repairs 1,000 1,500 2,000 2,000 Motor repairs 2,950 3,900 5,500 5,500 7030 Capital, equipment - - - - - - - 40,215 42,345 43,215 44,930 -14.87%5.30%2.05%3.97% 35 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent 2011 Budget Summary Street Pavement Management (100 - 4470): Personnel services: 0100 Salaries, regular 84,631 74,991 78,420 88,018 90,167 2,149 2.44% 0110 Salaries, overtime 39 266 1,737 2,888 2,888 - 0.00% 0150 Salaries, part-time 5,441 26,338 18,744 7,200 7,200 - 0.00% 0300 Social Security 6,838 7,641 7,360 7,506 7,670 164 2.18% 0321 PERA 5,095 4,671 5,387 6,363 6,746 383 6.02% 0400 Group insurance 8,369 8,424 11,003 13,154 13,590 436 3.31% 0500 Workers compensation 3,660 3,583 4,249 4,968 4,847 (121) -2.44% 0990 Severence pay - - - - 0.00% Total personnel services 114,073 125,914 126,900 130,097 133,108 3,011 2.31% Materials & supplies: 1230 Supplies, equipment 807 701 1,628 950 500 (450) -47.37% 1240 Supplies, streets 15,934 25,160 40,299 21,100 21,100 - 0.00% 1260 Supplies, traffic control 1,685 1,960 1,183 480 1,000 520 108.33% 1600 Supplies, operating 6,320 4,069 1,558 2,115 1,680 (435) -20.57% 1700 Motor fuels & lubricants 10,151 14,941 4,354 12,050 9,850 (2,200) -18.26% 2400 Uniforms & clothing 519 266 808 1,920 1,920 - 0.00% 2410 Mats & towels 921 1,137 1,427 700 700 - 0.00% Total materials & supplies 36,337 48,234 51,257 39,315 36,750 (2,565) -6.52% Contractual services: 3030 Other professional services 2,226 17,046 20,472 8,650 6,550 (2,100) -24.28% 3040 Consulting engineers 165 - - - - - 0.00% 3100 Telephone 951 1,383 1,127 1,200 1,200 - 0.00% 3160 Memberships - - - 113 113 - 0.00% 3630 Training & conferences 1,326 621 1,097 1,340 1,280 (60) -4.48% 4010 Rental, equipment 2,130 3,728 - 3,800 3,800 - 0.00% 4800 Insurance 4,922 5,077 10,599 6,200 6,200 - 0.00% 5130 Repairs, equipment - - - 500 500 - 0.00% 5140 Repairs, streets 290 - - - - - 0.00% Total contractual supplies 12,010 27,855 33,295 21,803 19,643 (2,160) -9.91% Capital outlays 7030 Equipment 22,754 2,002 - - 191,000 191,000 0.00% Total capital outlays 22,754 2,002 - - 191,000 191,000 0.00% Total street pavement management 185,174 204,005 211,452 191,215 380,501 189,286 98.99% 36 Fund: 100 Department: 4470 Pavement Management Account Description 2008 2009 2010 2011 Description 1230 Supplies, equipment 500 500 500 500 Safety vest, hearing protection, safety protection - - 450 - Skid steer bucket (1/2 in snow & ice) 500 500 950 500 1240 Supplies, street repair 17,510 23,000 20,000 20,000 Asphalt & concrete for street patching & repair (winter mix $130 per ton) 375 500 500 500 Disposal ($10.00 per load X 50) - - 600 600 Bituminous tack coat 17,885 23,500 21,100 21,100 1260 Supplies, traffic control 180 180 180 700 Traffic cones/baracades 750 300 300 300 portable signs (traffic control) 930 480 480 1,000 1600 Supplies, operating 380 380 380 380 Asphalt hand tools, rakes, etc. 1,235 1,235 1,235 1,300 Traffic marking paint - - 500 - 10' straight edge, IR temp gauge 1,615 1,615 2,115 1,680 1700 Motor fuels & lubs 4,650 6,375 5,625 5,625 Diesel fuel: 1500 gallons @ $3.75. 2,200 2,200 2,200 - Propane: 1100 gallons @ $2 3,900 4,875 4,225 4,225 Unleaded fuel: 1300 gallons @ $3.25 10,750 13,450 12,050 9,850 2400 Uniforms & clothing 1,920 1,920 1,920 1,920 Uniforms 1.6 FTE @ $1,200 1,920 1,920 1,920 1,920 2410 Mats & towels 600 700 700 700 Share of floor mats and shop towels 600 700 700 700 3030 Other professional services 1,800 1,800 1,800 1,800 Pavement Mgmt software annual maintenance. 3,305 3,305 3,305 1,000 Engineering services. 250 250 250 250 Annual certification of weight scales 3,295 3,295 3,295 3,500 Striping of streets, crosswalks, & school crossings. 8,650 8,650 8,650 6,550 3100 Communications 1,200 1,200 1,200 1,200 Cellular telephones 1,200 1,200 1,200 1,200 3160 Memberships - - 113 113 American Public Works Association memb. (APWA) (1/4 of $452) - - 113 113 3630 Training & conferences 200 200 50 50 Computer classes 200 200 200 200 Confined space training 200 200 200 200 Electronics updates, other classes 120 150 150 150 Hearing test 60 60 60 60 Maintenance Expo 250 250 125 125 APWA/MN conferences. 250 250 250 250 Pavement, sealcoating, patching & sealcoating seminars. 600 600 - - North Dakota Seminar for two - - - - PW mgt. Class - North Hennepin CC 100 100 100 100 Pesticide applicator's class 10 10 10 10 Pesticide license renewal 60 60 60 60 Vehicle inspection license renewal 75 75 75 75 Vehicle inspection recertification 60 60 60 - Work zone traffice control (every 3 years) 2,185 2,215 1,340 1,280 4010 Rentals, equipment 2,500 2,600 3,800 3,800 Annual trade-in of skid steer loaders 2,000 - - - Crack sealer machine rental 4,500 2,600 3,800 3,800 4800 Bonding & insurance 5,200 4,800 4,800 4,800 Insurance policy premiums 1,000 1,400 1,400 1,400 Allowance for insurnace policy deductibles 6,200 6,200 6,200 6,200 5130 Repairs, equipment - - 500 500 Misc. equipment repairs - - 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) - 40,000 - - 1 ton pick-up (carryover from 2009)(postpone to 2011) 2,000 - - - Lift tail gate 2,000 40,000 - 201,368 58,935 103,030 61,118 257,761 -40.72%74.82%-40.68%321.74% 37 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent 2011 Budget Summary Street Snow & Ice Control (100 - 4472): Personnel services: 0100 Salaries, regular 56,482 57,761 57,588 55,073 55,073 - 0.00% 0110 Salaries, overtime 10,062 6,884 8,204 5,416 5,416 - 0.00% 0300 Social Security 4,996 4,781 4,840 4,627 4,627 - 0.00% 0321 PERA 3,797 4,192 4,418 4,234 4,386 152 3.59% 0400 Group insurance 7,203 7,424 8,939 8,765 9,029 264 3.01% 0500 Workers compensation 2,921 3,151 3,662 4,313 4,198 (115) -2.67% Total personnel services 85,461 84,193 87,651 82,428 82,729 301 0.37% Materials & supplies: 1230 Supplies, equipment 1,957 3,795 3,849 2,550 2,100 (450) -17.65% 1600 Supplies, operating 27,884 29,683 19,873 32,800 27,050 (5,750) -17.53% 1700 Motor fuels & lubricants 251 3,970 7,244 7,680 7,680 - 0.00% 2400 Uniforms & clothing 1,008 834 491 1,200 1,000 (200) -16.67% Total materials & supplies 31,100 38,282 31,457 44,230 37,830 (6,400) -14.47% Contractual services: 3030 Other professional services 580 580 700 700 700 - 0.00% 3610 Memberships 427 200 331 203 203 - 0.00% 3630 Training & conferences 320 - 80 250 250 - 0.00% 5130 Repairs, equipment 1,671 1,016 706 1,000 1,000 - 0.00% Total contractual supplies 2,998 1,796 1,817 2,153 2,153 - 0.00% Capital outlays 7030 Equipment 2,705 6,001 949 - - - 0.00% 7040 Vehicles - - - - - - 0.00% Total capital outlays 2,705 6,001 949 - - - 0.00% Total streets snow & ice control 122,264 130,272 121,874 128,811 122,712 (6,099) -4.73% 38 Fund: 100 Department: 4472 Snow & Ice Control Account Description 2008 2009 2010 2011 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,400 Cutting edges, plow shoes 2,100 2,100 2,550 2,100 1600 Supplies, operating 800 800 800 800 Welding supplies, steel stock, sod for boulevards, etc. - - - 2,250 Liquid Mg Chloride: 1,500 gallons @ $1.50 per gallon. 30,955 33,150 32,000 24,000 Salt: 300 tons @ $80 per ton. 31,755 33,950 32,800 27,050 1700 Motor fuels & lubs 144 180 180 180 Engine oil: 30 gallons @ $6.00 per gallon. 6,200 8,500 7,500 7,500 Diesel fuel: 2,000 gallons @ $3.75 per gallon. 6,344 8,680 7,680 7,680 2400 Uniforms & clothing 1,200 1,200 1,200 1,200 Uniforms 1.0 FTE @ $1,200 1,200 1,200 1,200 1,200 3030 Other professional services 640 700 700 700 Weather service reports 640 700 700 700 3610 Memberships 25 25 25 25 MN Street Superintendent's Assoc. 400 285 113 113 American Public Works Association memb. (APWA) (1/4 of $452) 65 65 65 65 Minnesota Safety Council 425 375 203 203 3630 Training 500 500 250 250 Training e.g. MSSA training 500 500 250 250 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 1,500 - - - Pavement temp sensor 10,000 - - - V plow and blower for sidewalks, trails 11,500 - - - 55,464 48,505 46,383 40,183 3.30%-12.55%-4.37%-13.37% 39 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent 2011 Budget Summary Street Sign Maintenance (100 - 4475): Personnel services: 0100 Salaries, regular 20,830 20,718 20,797 20,026 20,026 - 0.00% 0110 Salaries, overtime - - 650 722 722 - 0.00% 0300 Social Security 1,700 1,573 1,599 1,587 1,587 - 0.00% 0321 PERA 1,604 1,348 1,441 1,453 1,504 51 3.51% 0400 Group insurance 3,117 2,546 3,024 3,187 3,283 96 3.01% 0500 Workers compensation 1,031 1,102 1,281 1,507 1,508 1 0.07% Total personnel services 28,282 27,287 28,792 28,482 28,630 148 0.52% Materials & supplies: 1600 Supplies, operating 2,238 7,209 3,929 4,734 4,734 - 0.00% 1700 Motor fuels & lubricants - - 559 - - - 0.00% 2400 Uniforms & clothing 255 - - 480 480 - 0.00% Total materials & supplies 2,493 7,209 4,488 5,214 5,214 - 0.00% Contractual services: 3250 Electricity - traffic signals 1,736 2,166 1,797 2,000 2,000 - 0.00% 3630 Training & conferences - - - 250 - (250) -100.00% 5130 Repairs, equipment 2,110 600 244 750 750 - 0.00% Total contractual supplies 3,846 2,766 2,041 3,000 2,750 (250) -8.33% Capital outlays 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total street sign maintenance 34,621 37,262 35,321 36,696 36,594 (102) -0.28% 40 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 1,200 - - - Portable stop signs (4) 5,935 4,735 4,735 4,735 2400 Uniforms & clothing 480 480 480 480 Uniforms 0.4 FTE @ $1,200 480 480 480 480 3250 Electricity - traffic signals 1,000 2,000 2,000 2,000 Electricity for traffic signals 1,000 2,000 2,000 2,000 3630 Training & conferences 250 250 250 - Manual on Uniform Traffic Control Devices, workzone safety 400 - - - Annual hearing test 650 250 250 - 5130 Repairs, equipment 515 515 750 750 Traffic signal repairs & maintenance 515 515 750 750 8,580 7,980 8,215 7,965 16.82%-6.99%2.94%-3.04% 41 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Convention & Visitor's Bureau (100-4653) Contractual services 3045 N Metro Convention Bureau 50,071 48,715 40,171 48,450 42,750 (5,700) -11.76% Total contractual services 50,071 48,715 40,171 48,450 42,750 (5,700) -11.76% Total Convention & Visitor's Bureau 50,071 48,715 40,171 48,450 42,750 (5,700) -11.76% Miscellaneous (100 - 4700): Personnel services 0300 Social security - 133 277 - - - 0.00% 0321 PERA - 133 428 - - - 0.00% 0400 Group insurance - 165 423 - - - 0.00% 0750 Fitness program 4,069 4,969 5,135 6,500 6,500 - 0.00% Total personnel services 4,069 5,400 6,263 6,500 6,500 - 0.00% Contractual services 3065 Family & youth social services 17,927 18,375 18,926 18,926 18,661 (265) -1.40% Total contractual services 17,927 18,375 18,926 18,926 18,661 (265) -1.40% Miscellaneous 9100 Contingency - - - 100,000 - (100,000) -100.00% 9900 Transfers - Vehicle & Equip. Fund 175,000 175,000 175,000 50,000 75,000 25,000 50.00% 9900 Community Center 175,000 175,000 160,000 175,000 170,000 (5,000) -2.86% Total miscellaneous 350,000 350,000 335,000 325,000 245,000 (80,000) -24.62% 0.00% Total miscellaneous 371,996 373,775 360,189 350,426 270,161 (80,265) -22.90% Debt Service (100 - 4750): Debt Service Fire Bonds: 8010 Principal 170,919 107,098 99,088 103,428 50,213 (53,215) -51.45% 8020 Interest 30,396 41,098 50,195 43,767 39,449 (4,318) -9.87% Debt Service Fire Equipment Certificates: 8010 Principal 2,332 2,376 - - - - 0.00% 8020 Interest 77 54 - - - - 0.00% Total debt service 203,724 150,626 149,283 147,195 89,662 (57,533) -39.09% 2011 Budget Summary 42 Fund: 100 Department: 4653 Convention & Visitor's Bureau Account Description 2008 2009 2010 2011 Description 3045 N Metro Convention Bureau 52,250 49,400 48,450 42,750 Payment of 95% of hotel/motel tax collections to support the promotion of tourism. 52,250 49,400 48,450 42,750 Fund: 100 Department: 4700 Miscellaneous Account Description 2008 2009 2010 2011 Description 0750 Fitness program 7,000 7,000 6,500 6,500 Fitness program (maximum $55/month paid with employee sick leave time). 7,000 7,000 6,500 6,500 3065 Family & youth social 18,375 18,926 18,926 18,926 Northwest Youth and Family Services services 18,375 18,926 18,926 18,926 9100 Contingency 92,000 150,000 100,000 - Unexpected expenditures, deductibles, grant matches - - - - Local match for Federal / State grants 92,000 150,000 100,000 - 9900 Transfers - miscellaneous 175,000 175,000 50,000 75,000 Transfer to Vehicle & Equipment Fund 175,000 175,000 50,000 75,000 9990 Community Center 185,000 185,000 175,000 170,000 Subsidy for Community Center operating costs 185,000 185,000 175,000 170,000 477,375 535,926 350,426 270,426 Fund: 100 Department: 4750 Fire Bond Debt Service Account Description 2008 2009 2010 2011 Description 8010 Principal 46,050 47,647 48,672 50,213 15.21% of 2011 principal payment on 46,050 47,647 48,672 50,213 the 2005 Bond Issue 8020 Interest 44,998 43,327 41,084 39,449 15.21% of 2011 interest payment on 44,998 43,327 41,084 39,449 the 2005 Bond Issue 8010 Principal 49,888 53,027 54,756 - 15.21% of 2010 principal payment on 49,888 53,027 54,756 - the 1997 Bond Issue 8020 Interest 7,646 5,283 2,683 - 15.21% of 2010 interest payment on 7,646 5,283 2,683 - the 1997 Bond Issue 8010 Principal 120,907 120,563 - - Principal payment on 2003 Fire Equipment 120,907 120,563 - - Certificates for mini-pumper. 8020 Interest 54 53 - - Interest payment on 2003 Fire Equipment 54 53 - - Certificates for mini-pumper. 8010 Principal 216,845 221,237 103,428 50,213 Total principal 8020 Interest 52,698 48,663 43,767 39,449 Total interest Total 269,543 269,900 147,195 89,662 43 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Cable TV (Fund 210): Revenues 3180 Franchise fee 101,969 109,828 141,282 96,000 96,000 - 0.00% 3370 Other local government re - 569 - - - - 0.00% 3610 Investment income 15,825 - - - - - 0.00% 3680 Other revenue - 1,546 6,530 5,100 5,100 - 0.00% Total revenue 117,794 111,943 147,812 101,100 101,100 - 0.00% Operating expenses Operations (4350) Personnel services 0100 Salaries, regular 18,733 49,259 54,766 58,781 59,383 602 1.02% 0110 Salaries, over-time - 3,056 2,074 - - - 0.00% 0150 Salaries, part-time 7,181 5,211 8,017 8,487 8,432 (55) -0.65% 0300 Social security 1,749 4,460 4,895 5,146 5,188 42 0.82% 0321 PERA 1,255 4,030 4,341 4,114 4,308 194 4.72% 0400 Group insurance 1,950 5,292 7,004 8,366 8,618 252 3.01% 0500 Workers compensation 1,199 182 239 303 299 (4) -1.32% 0600 Unemployment 691 - 1,246 - - - 0.00% 0990 Severence pay - - - - - - 0.00% Total personnel services 32,758 71,490 82,582 85,197 86,228 1,031 1.21% Materials & supplies 1230 Supplies, equipment 1,662 237 2,598 4,000 2,000 (2,000) -50.00% 1600 Supplies, operating 1,388 1,081 551 1,500 1,000 (500) -33.33% Total materials & suppli 3,050 1,318 3,149 5,500 3,000 (2,500) -45.45% Contractual services 3030 Other professional service 4,024 3,713 4,850 3,400 3,600 200 5.88% 3630 Training & conferences 16 152 325 1,300 300 (1,000) -76.92% 3800 Mileage & parking 302 97 20 100 100 - 0.00% 3900 Grants & subsidies 23,658 25,936 26,719 27,254 26,933 (321) -1.18% 5130 Repairs, equipment 196 906 51 1,500 1,000 (500) -33.33% Total contractual service 28,196 30,804 31,965 33,554 31,933 (1,621) -4.83% Capital 7030 Equipment - 37,462 9,767 - - - 0.00% Total capital outlays - 37,462 9,767 - - - 0.00% Transfers 9900 Transfers out 12,563 - 0.00% Total transfers 12,563 - - - - - 0.00% Total expenditures 76,567 141,074 127,463 124,251 121,161 (3,090) -2.49% Net change in fund balance 41,227 (29,131) 20,349 (23,151) (20,061) 3,090 -13.35% Fund balance, beginning year 250,620 291,847 262,716 283,065 259,914 (23,151) -8.18% Fund balance, end of year 291,847$ 262,716$ 283,065$ 259,914$ 239,853$ (20,061)$ -7.72% 2011 Budget Summary 44 Fund: 210 Cable TV Revenues Account Description 2008 2009 2010 2011 Description 3180 Franchise fee revenue 96,000 96,000 96,000 96,000 Estimated collections 96,000 96,000 96,000 96,000 3610 Interest revenue - - - - Estimated interest earnings (moved to general fund) - - - - 3680 Other revenue - - 5,100 5,100 Lease revenue from Library fiber connection - - 5,100 5,100 Fund: 210 Department: 4350 Operations 1230 Supplies, equipment 2,700 3,500 4,000 2,000 Equipment costing less than $1,000 per item 2,700 3,500 4,000 2,000 1600 Supplies, operating 600 1,000 1,000 750 Recording media - tapes, DVD's 500 500 500 250 Batteries, cables, bulbs, tapes, misc 1,100 1,500 1,500 1,000 3030 Other professional services 3,000 3,300 3,400 3,600 Web streaming meetings $300 per month. 3,000 3,300 3,400 3,600 3630 Training & conferences 700 700 700 300 Attendance at local training - - 600 - Submission fees for awards (new item for 2010) 700 700 1,300 300 3800 Mileage & parking - 200 100 100 Mileage - 200 100 100 3900 Grants & subsidies 25,490 26,382 27,254 26,933 Share of costs of North Suburban Cable Commission 25,490 26,382 27,254 26,933 5130 Repairs, equipment 1,500 1,500 1,500 1,000 Repair and maintenance of equipment 1,500 1,500 1,500 1,000 7030 Capital, equipment 12,100 - - - Camera for council chambers (Removed $12,000)_ 2,000 2,000 - - Podeum and other council chamber improvements - 1,700 - - Adobe Creative Suite 3 Production Premium Software 10,000 - - - Non-linear editing system (moved to 2008) 24,100 3,700 - - 58,590 40,782 39,054 34,933 22.63%-30.39%-33.34%-14.34% 45 2007 2008 2009 2010 2011 Actual Actual Actual Budget Request Dollar Percent DARE (Fund 220): Revenues 3511 Fines - controlled substnc 517 643 759 850 800 (50) -5.88% 3610 Investment income 1,275 - - - - - 0.00% 3650 Donations 2,040 - - - - - 0.00% 3680 Other revenue 450 - 450 - - - 0.00% Total revenue 4,282 643 1,209 850 800 (50) -5.88% Operating expenses (4200): Materials & supplies 1600 Supplies, operating 5,974 1,357 754 2,000 650 (1,350) -67.50% Total Supplies 5,974 1,357 754 2,000 650 (1,350) -67.50% Contractual services 3030 Other professional services 60 - - - - - 0.00% 3430 Printing - - - 100 100 - 0.00% 3610 Memberships - - - 100 50 (50) -50.00% 3630 Training & conferences - - - 800 - (800) -100.00% Total contractual services 60 - - 1,000 150 (850) -85.00% Transfers 9900 Transfers out - 4,393 4,393 4,393 3,000 3,000 68.29% Total capital outlays - 4,393 4,393 4,393 3,000 3,000 68.29% Total expenditures 6,034 5,750 5,147 7,393 3,800 800 10.82% Net change in fund balance (1,752) (5,107) (3,938) (6,543) (3,000) 92 -1.41% Fund balance, beginning year 21,362 19,610 14,503 10,565 4,022 (13,341) -126.28% Fund balance, end of year 19,610$ 14,503$ 10,565$ 4,022$ 1,022$ (13,249)$ -329.43% 2011 Budget Summary Change from 2010 46 Fund: 220 DARE Revenues Account Description 2008 2009 2010 2011 Description 3511 Fines - controlled substance 1,600 1,600 850 800 Estimated collections 1,600 1,600 850 800 3610 Interest revenue - - - - Estimated interest earnings (moved to general fund per council 08) - - - - Fund: 220 Department: 4200 Operations Operations Operations Operations 1600 Supplies, operating 3,200 2,500 2,000 650 DARE apparel and supplies. 3,200 2,500 2,000 650 3430 Printing 100 100 100 100 Programs and parent guides. 100 100 100 100 3610 Memberships 100 100 100 50 NSRO, NDOA, & MNDARE. 100 100 100 50 3630 Training & conferences 800 800 800 - DARE or NSRO conference. 800 800 800 - 9900 Transfer out 4,265 4,393 4,393 3,000 Reimburse General Fund for 5% of DARE officer salary 4,265 4,393 4,393 3,000 8,465 7,893 7,393 3,800 47 2007 2008 2009 2010 2011 Actual Actual Actual Budget Request Dollar Percent Police Grants (Fund 222): Revenues 3318 Federal police grant 350 - 9,870 - - - 0.00% 3359 Other state grants - - - - - - 0.00% 3360 Other county grants - - - - - - 0.00% 3370 Other local government revenu - - - - - - 0.00% 3610 Investment income 1,376 - - - - - 0.00% 3680 Miscellaneous revenue 159 - - - - - 0.00% Total revenue 1,885 - 9,870 - - - 0.00% Operating expenses (4200):0.00% Personnel services 0.00% 0100 Salaries, regular - - - - - - 0.00% Total personnel services - - - - - - 0.00% Materials & supplies 1600 Operating supplies 6 - - - - - 0.00% 2400 Uniform & clothing - - - - - - 0.00% Total Supplies 6 - - - - - 0.00% Contractual services 3030 Other professional services - - - - - - 0.00% 3430 Printing - - - - - - 0.00% 3630 Training & conferences - - - - - - 0.00% Total contractual services - - - - - - 0.00% Capital 7030 Equipment 3,317 8,237 9,870 - 11,000 11,000 #DIV/0! Total capital outlays 3,317 8,237 9,870 - 11,000 11,000 #DIV/0! Total expenses 3,323 8,237 9,870 - 11,000 11,000 #DIV/0! Net change in fund balance (1,438) (8,237) - - (11,000) (11,000) #DIV/0! Fund balance, beginning year 22,306 20,868 12,631 12,631 12,631 10,909 86.37% Fund balance, end of year 20,868 12,631 12,631 12,631 1,631 (3,924) -31.07% 2011 Budget Summary Change from 2010 48 Fund: 222 Police Grants Revenues Account Description 2008 2009 2010 2011 Description 3359 Other state grants 1,000 - - - Other grants that may be awarded. 1,000 - - - 3610 Interest revenue - - - Estimated interest earnings (moved to general fund per council 08) 1,000 - - - Fund: 222 Department: 4200 Operations 0100 Salaries regular - - - - Reimbursement of officer's salaries while training. - - - - 3030 Other professional services 30 - - - Services required to carry out grants 30 - - - 3630 Training & conferences 970 - - - Training specified in grant agreements. 970 - - - 7030 Equipment - - - 11,000 Grant for camera upgrades - - - 11,000 1,000 - - 11,000 49 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Forfeiture (Fund 225): Revenues 3514 Forfeitures 31,997 10,098 15,744 5,500 5,500 - 0.00% 3610 Investment income 3,776 - - - - - 0.00% 3650 Donations - - - - - - 0.00% 3680 Other revenue 1,431 6,703 - - - - 0.00% Total revenue 37,204 16,801 15,744 5,500 5,500 - 0.00% Operating expenses (4200): Materials & supplies 1230 Supplies, equipment - - - - - 0.00% 1600 Supplies, operating 104 7,334 206 500 500 - 0.00% Total materials & supplies 104 7,334 206 500 500 - 0.00% Contractual services 3030 Other professional services 25,715 203 5,881 2,000 1,500 (500) -25.00% Total contractual services 25,715 203 5,881 2,000 1,500 (500) -25.00% Capital 7030 Equipment 3,322 21,576 - 9,500 - (9,500) -100.00% 7040 Vehicles - 25,000 - - 29,000 29,000 #DIV/0! Total capital outlays 3,322 46,576 - 9,500 29,000 19,500 205.26% Total expenses 29,141 54,113 6,087 12,000 31,000 19,000 158.33% Net change in fund balance 8,063 (37,312) 9,657 (6,500) (25,500) (29,868) 459.51% Fund balance, beginning year 55,941 64,004 26,692 36,349 29,849 3,624 9.97% Fund balance, end of year 64,004 26,692 36,349 29,849 4,349 (26,244) -87.92% 2011 Budget Summary 50 Fund: 225 Forfeiture Revenues Account Description 2008 2009 2010 2011 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 1,000 500 500 Supplies to prepare vehicles for auction. (tows, title fees, batteries) - - - - - - - - - 1,000 1,000 500 500 3030 Other professional services 4,125 4,125 2,000 1,500 Share of auction costs. 4,125 4,125 2,000 1,500 7030 Equipment 16,500 - - - In-squad cameras (3) 10,000 - - - Department issued handguns and holsters - - - 29,000 One squad $23,000 + set-up $6000 One in General Fund. - 10,000 - - Install 3rd Video Camera - 8,800 9,500 - Speed display unit 26,500 18,800 9,500 29,000 31,625 23,925 12,000 31,000 51 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent EDA (Fund 230): Revenues 3425 Remodeling planbook - 15 - - - - 0.00% 3610 Investment income 2,653 - - - - - 0.00% 3680 Other revenue - 5,464 2,760 - - - 0.00% 3972 Transfers 120,000 156,680 129,824 385,189 387,435 2,246 0.58% Total revenue 122,653 162,159 132,584 385,189 387,435 2,246 0.58% Operating expenses Economic Development (4650): Personnel services 0100 Salaries, regular 51,315 71,885 77,240 77,297 78,681 1,384 1.79% 0300 Social security 3,462 5,335 5,808 5,914 6,019 105 1.78% 0321 PERA 2,942 4,438 5,098 5,411 5,703 292 5.40% 0400 Group insurance 5,417 9,577 9,039 9,364 9,628 264 2.82% 0500 Workers compensation 576 209 274 322 429 107 33.23% 0990 Severence pay - - - - - - 0.00% Total personnel services 63,712 91,444 97,459 98,308 100,460 2,152 2.19% Materials & supplies 1600 Supplies, operating - - - 150 150 - 0.00% 2100 Book & periodicals 215 269 110 230 130 (100) -43.48% Total materials & supplies 215 269 110 380 280 (100) -26.32% Contractual services 3030 Other professional services 40,446 46,277 28,645 73,790 73,910 120 0.16% 3420 Advertisements 1,264 336 717 1,000 1,000 - 0.00% 3430 Printing - - 556 1,000 1,000 - 0.00% 3610 Memberships 10,366 10,086 3,935 3,801 3,875 74 1.95% 3630 Training & conferences 886 1,980 1,262 2,210 2,210 - 0.00% 3800 Mileage 21 - - 100 100 - 0.00% 4800 Insurance 3,487 3,767 3,912 4,600 4,600 - 0.00% 5210 Housing replacement 22 8,000 - 150,000 150,000 - 0.00% 5220 Highway 10 redevelopment 102 - - - - - 0.00% Total contractual services 56,594 70,446 39,027 236,501 236,695 194 0.08% Capital outlays 9300 Business subsidies - - - 50,000 50,000 - 0.00% Total capital outlays - - - 50,000 50,000 - 0.00% Total expenditures 120,521 162,159 136,596 385,189 387,435 2,246 0.58% Net change in fund balance 2,132 - (4,012) - - - 0.00% Fund balance, beginning year 1,880 4,012 4,012 - - - 0.00% Fund balance, end of year 4,012 4,012 - - - - 0.00% 2011 Budget Summary 52 Fund: 230 EDA Revenues Account Description 2008 2009 2010 2011 Description 3610 Interest income 1,125 75 - - Estimated interest earnings at 2.50%. 1,125 75 - - 3972 Transfers 369,361 380,865 385,189 387,435 Transfers from TIF 1,2,3,5 369,361 380,865 385,189 387,435 Fund: 230 Department: 4650 Economic Development 1600 Supplies, operating 225 200 150 150 Misc office supplies 225 200 150 150 2100 Books & periodicals 95 100 100 - MN Real Estate Journal 90 - - - Mpls./St.Paul Business Journal 25 30 30 30 LMC directory 125 100 100 100 Misc. reports & periodicals (Finance & Commerce) 335 230 230 130 3030 Other professional services 7,500 7,000 7,000 7,000 Legal fees for development reviews 12,000 12,000 12,000 12,000 Financial consultant fees (Ehlers) 43,250 31,500 30,000 30,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,110 4,200 4,290 4,410 15% audit fee 11,300 12,000 12,500 12,500 Housing Resource Center fees 3,000 3,000 3,000 3,000 Marketing Consultant fees 86,160 86,450 73,790 73,910 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,250 1,200 - - Business directory reprints 250 300 300 300 Misc printing 2,200 2,200 1,000 1,000 3610 Memberships 355 375 400 400 Economic Development Assoc of MN (EDAM) 5,400 5,500 - - North Metro 35 W Corridor Coalition 575 600 600 600 Twin Cities North Chamber of Commerce dues 3,400 3,500 2,801 2,875 North Metro Mayors Assoc (50% of dues, balance in GF) 9,730 9,975 3,801 3,875 3630 Training & conferences 400 400 400 400 Chamber of Commerce meetings 650 650 650 650 DEED/ EDC training 125 125 360 360 EDAM monthly meetings 700 800 600 600 EDAM summer conference 400 300 200 200 Other miscellaneous training 2,275 2,275 2,210 2,210 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 25,000 50,000 50,000 Business improvement partnership loans 25,000 25,000 50,000 50,000 281,625 282,030 286,881 286,975 53 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Community Center (Fund 252): Building overhead (4350) Building overhead revenues 182,099 179,969 164,151 176,500 172,500 1,000 0.57% Building overhead expenditures 5,000 1,632 6,139 - 9,900 9,900 #DIV/0! Net Building Overhead Operations 177,099 178,337 158,012 176,500 162,600 (8,900) -5.04% Banquet Center (4730): Banquet revenues 43,849 75,740 84,276 80,000 80,000 - 0.00% Banquet Center expenditures 75,723 92,125 106,399 108,529 148,241 39,712 36.59% Net Banquet Center (31,874) (16,385) (22,123) (28,529) (68,241) (39,712) 139.20% YMCA (4732): YMCA revenues 41,018 24,572 33,741 36,450 30,450 (6,000) -16.46% YMCA expenditures 206,086 207,627 196,866 226,494 232,771 6,277 2.77% Net YMCA (165,068) (183,055) (163,125) (190,044) (202,321) (12,277) 6.46% Chamber of Commerce (4734): Chamber revenues 13,120 10,832 12,148 12,148 - (12,148) -100.00% Chamber expenditures 6,029 5,990 6,272 6,984 - (6,145) -87.99% Net Chamber of Commerce 7,091 4,842 5,876 5,164 - (6,003) -116.25% Creative Kids Child Care Center (4736): Creative Kids revenues 70,862 72,866 75,474 74,570 76,984 2,414 3.24% Creative Kids expenditures 34,565 34,607 33,151 37,661 36,582 (1,079) -2.87% Net Creative Kids 36,297 38,259 42,323 36,909 40,402 3,493 9.47% Total revenue 350,948 363,979 369,790 379,668 359,934 (14,734) -3.88% Total expenditures 327,403 341,981 348,827 379,668 427,493 48,664 12.82% Net change in fund balance 23,545 21,998 20,963 - (67,559) (63,398) #DIV/0! Fund balance, beginning year 148,957 172,502 194,500 215,463 215,463 20,023 9.29% Fund balance, end of year 172,502 194,500 215,463 215,463 147,904 516 0.24% (continued) 54 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Community Center (continued): Building overhead (4350) Building revenues: 3610 Investment income 4,279 4,677 2,784 1,500 2,500 1,000 66.67% 3634 Equipment rental - 167 56 - - - 0.00% 3650 Donations 2,720 - - - - - 0.00% 3680 Miscellaneous 100 125 1,311 - - - 0.00% 3972 Transfers from Sp. Projects - - - - - - 0.00% 3972 Transfers 175,000 175,000 160,000 175,000 170,000 (5,000) -2.86% Total - Building revenues 182,099 179,969 164,151 176,500 172,500 1,000 0.57% Operating expenses Personnel services 0100 Salaries, regular 34,856 35,408 35,522 33,712 34,726 1,014 3.01% 0110 Salaries,overtime - - 380 1,621 1,670 49 3.02% 0300 Social Security 2,557 2,545 2,307 2,703 2,785 82 3.03% 0321 PERA 2,213 2,163 2,393 2,473 2,639 166 6.71% 0400 Group insurance 6,428 6,473 7,416 7,488 7,578 90 1.20% 0500 Workers compensation 1,260 1,196 1,359 1,552 1,540 (12) -0.77% 999 Allocation of salaries (47,314) (47,785) (49,377) (49,549) (50,938) (1,389) 2.80% Total personnel services - - - - - - 0.00% Materials & supplies 1210 Supplies, buildings & grounds 444 532 1,234 1,200 1,100 (100) -8.33% 1230 Supplies, equipment 180 1,339 748 400 400 - 0.00% 1600 Supplies, operating 7,281 8,387 10,170 5,800 7,000 1,200 20.69% 2400 Uniforms 634 337 604 450 450 - 0.00% 2410 Mats & towels 2,718 2,757 1,276 2,800 2,800 - 0.00% 2999 Allocation of supplies (11,257) (13,352) (14,032) (10,650) (11,850) (1,200) 11.27% Total materials & supplies - - - - (100) (100) #DIV/0! Contractual services 3030 Other professional services - 239 111 200 200 - 0.00% 3100 Telephone 2,778 3,338 3,372 3,000 3,000 - 0.00% 3200 Water & sewer 9,703 9,412 6,745 9,500 9,500 - 0.00% 3210 Electricity 50,301 52,182 51,585 54,000 53,000 (1,000) -1.85% 3220 Natural gas 23,296 22,275 13,126 25,500 23,000 (2,500) -9.80% 3530 Refuse collection 3,847 4,272 4,026 3,520 4,100 580 16.48% 3999 Allocation of utilities (83,665) (91,718) (72,826) (95,720) (92,800) 2,920 -3.05% 5110 Repairs, building & grounds 13,680 10,533 11,832 21,250 18,000 (3,250) -15.29% 5130 Repairs, equipment 6,693 5,734 13,352 6,700 6,700 - 0.00% 5999 Allocation of repairs (26,633) (16,267) (25,184) (27,950) (24,700) 3,250 -11.63% Total contractual services - - 6,139 - - - 0.00% Capital 7030 Equipment 5,000 1,632 - - 10,000 10,000 #DIV/0! Total capital outlays 5,000 1,632 - - 10,000 10,000 #DIV/0! Total Building overhead expenditures 5,000 1,632 6,139 - 9,900 9,900 #DIV/0! Total Building Overhead Net 177,099 178,337 158,012 176,500 162,600 (8,900) -5.04% (continued) 55 Fund: 252 Department: 4350 Community Center Building Overhead Account Description 2008 2009 2010 2011 Description 1210 Supplies, bldgs & grounds 1,200 1,200 1,200 1,100 Lights, signs, fertilizer 1,200 1,200 1,200 1,100 1230 Supplies, equipment 400 400 400 400 Small tools & equipment 400 400 400 400 1600 Supplies, operating 5,090 5,090 5,800 7,000 Batteries, soap, paper towels, cleaning supplies for bathrooms Paper cups, plates, etc. for lounge & customer service events 5,090 5,090 5,800 7,000 2400 Uniforms 500 500 450 450 Uniforms 500 500 450 450 2410 Mats & towels 1,800 2,000 2,000 2,000 Floor mats and cleaning towelsto provide better protection of carpets 600 800 800 800 Special events 2,400 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,000 Office & customer phones, internet, maintenance agreements, & repairs 3,000 3,000 3,000 3,000 3200 Water & Wastewater 9,000 9,500 9,500 9,500 Water & sewer charges for community center 9,000 9,500 9,500 9,500 3210 Electricity 46,500 55,800 54,000 53,000 Estimated electrice charges 46,500 55,800 54,000 53,000 3220 Natural gas 25,200 30,240 25,500 23,000 Estimated natural gas charges 25,200 30,240 25,500 23,000 3530 Refuse collection 3,420 3,420 3,420 4,000 Dumpsters $333 x 12 months (07-$320) 100 100 100 100 Ramsey County recyclying fee 3,520 3,520 3,520 4,100 5110 Repairs, building & grounds 5,520 5,760 5,760 5,760 Custodial services: 12 mths X $480 4,000 4,000 4,000 3,000 Commercial carpet cleaning service (twice annually) 6,180 6,180 6,180 5,180 Exterior building maintenance 750 750 750 750 Exterminator: 12 months X 62 2,000 2,000 2,000 1,500 Fire alarm system service 2,060 2,060 2,060 1,310 Parking lot & grounds maintenance 500 500 750 500 Security system service 21,010 21,250 21,500 18,000 5130 Repairs, equipment 4,500 4,500 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 6,200 4,025 6,700 7030 Capital, equipment - - - - Equipment replacement - - - 10,000 Community Center Roof repairs 10,000 - - - Roof over kitchen area (will not occur in 2007 carry over to 2008) 10,000 - - 10,000 134,220 139,700 131,895 139,250 56 2007 2008 2009 2010 2011 Change from 2010 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 43,774 75,631 84,136 80,000 80,000 - 0.00% 0.00% Total - Banquet revenues 43,849 75,740 84,276 80,000 80,000 - 0.00% Banquet Expenditures Personnel services 0999 Allocation of salaries 9,463 9,557 11,133 9,910 10,188 278 2.80% Total personnel services 9,463 9,557 11,133 9,910 10,188 278 2.80% Materials & supplies 1230 Supplies, equipment - - 320 - - - 0.00% 1600 Supplies, operating - - - - - - 0.00% 2999 Allocation of supplies 3,530 3,798 3,980 2,982 3,318 336 11.27% Total materials & supplies 3,530 3,798 4,300 2,982 3,318 336 11.27% Contractual services 3030 Other professional services 25,105 35,356 58,014 50,149 51,075 926 1.85% 3100 Telephone 404 412 312 450 600 150 33.33% 3420 Advertising 1,800 266 - 1,000 750 (250) -25.00% 3430 Printing - 97 - 250 250 - 0.00% 3999 Allocation of utilities 24,723 25,270 20,519 26,562 25,744 (818) -3.08% 4800 Bonding & insurance 1,806 1,720 1,786 2,100 2,100 - 0.00% 5110 Repairs, building & grounds 2,513 2,907 2,302 1,700 1,700 - 0.00% 5130 Repairs, equipment 545 2,975 981 1,600 1,600 - 0.00% 5999 Allocation of repairs 5,834 4,400 7,052 7,826 6,916 (910) -11.63% Total contractual services 62,730 73,403 90,966 91,637 90,735 (902) -0.98% Capital 7030 Equipment - 5,367 - 4,000 44,000 40,000 1000.00% Total capital outlays - 5,367 - 4,000 44,000 40,000 1000.00% Total Banquet expenditures 75,723 92,125 106,399 108,529 148,241 39,712 36.59% Total Banquet Center net (31,874) (16,385) (22,123) (28,529) (68,241) (39,712) 139.20% 57 Fund: 252 Community Center Dept 4730 Banquet Center Operations Expenses Account Description 2008 2009 2010 2011 Description 2999 Allocation of supplies 2,685 2,797 2,982 3,318 28% Allocation from overall building support 2,685 2,797 2,982 3,318 3030 Other professional services 685 700 715 735 2.5% of audit 850 850 2,600 2,600 Miscellaneous professional services (linen service) 25,500 47,103 45,333 46,240 Banquet facility management 1,500 1,500 1,500 1,500 Legal costs 28,535 50,153 50,148 51,075 3100 Telephone/Internet 900 900 450 600 Internet service (1/2 reimbursed from other tenants) 900 900 450 600 3420 Advertising & marketing 3,200 1,000 1,000 750 Website and traditional advertising, marketing 3,200 1,000 1,000 750 3430 Printing 250 250 250 250 Brochures, flyers, etc. 250 250 250 250 3999 Allocation of utilities 24,398 28,393 26,562 4,025 28% Allocation from overall building utilities 24,398 28,393 26,562 4,025 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 1,000 500 500 500 Dance floor maintenance 2,200 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,619 7,686 7,826 6,916 28% Allocation from overall building repairs 7,619 7,686 7,826 6,916 7030 Capital, equipment 4,000 4,000 4,000 4,000 Table replacement program - - - 40,000 Chairs for banquet center (400 @ $100) - 1,200 - - LCD Projectors (2) 4,000 5,200 4,000 44,000 77,487 101,779 98,618 116,334 58 (continued) 2011 Budget Summary 2007 2008 2009 2010 2011 Actual Actual Actual Budget Request Dollar Percent Community Center (continued): YMCA (4732): YMCA Revenues 3405 Recreation profit 13,869 6,941 14,939 12,000 12,000 - 0.00% 3660 Gym & meeting room rental 14,567 4,221 7,235 13,000 7,000 (6,000) -46.15% 3661 Open gym participant fees 10,899 13,050 10,991 11,000 11,000 - 0.00% 3679 Commissions - vending 1,683 360 576 450 450 - 0.00% Total - YMCA revenues 41,018 24,572 33,741 36,450 30,450 (6,000) -16.46% YMCA Expenditures Personnel services - 0999 Allocation of salaries 32,647 32,972 32,812 34,189 36,675 2,486 7.27% Total personnel services 32,647 32,972 32,812 34,189 36,675 2,486 7.27% Materials & supplies 1600 Supplies, operating 3,081 29 - - - - 0.00% 2999 Allocation of supplies 5,630 6,797 7,108 5,325 6,281 956 17.94% Total materials & supplies 8,711 6,826 7,108 5,325 6,281 956 17.94% Contractual services 3030 Other professional services 93,698 93,213 94,149 97,545 99,505 1,960 2.01% 3300 Postage 1,634 1,177 312 1,200 1,200 - 0.00% 3430 Printing 4,864 7,564 4,794 6,000 6,000 - 0.00% 3999 Allocation of utilities 45,777 46,373 37,928 48,760 49,994 1,234 2.53% 4800 Bonding & insurance 3,179 2,866 2,977 3,500 4,025 525 15.00% 5110 Repairs, building & grounds 3,559 5,451 608 12,000 12,000 - 0.00% 5130 Repairs, equipment 1,723 2,827 3,586 4,000 4,000 - 0.00% 5999 Allocation of repairs 10,276 8,358 12,592 13,975 13,091 (884) -6.33% Total contractual services 164,728 167,829 156,946 186,980 189,815 2,835 1.52% Total YMCA expenditures 206,086 207,627 196,866 226,494 232,771 6,277 2.77% Total YMCA net (165,068) (183,055) (163,125) (190,044) (202,321) (12,277) 6.46% (continued) Change from 2010 59 Fund: 252 Community Center Department: 4732 YMCA Account Description 2008 2009 2010 2011 Description 2999 Allocation of supplies 4,795 4,995 5,325 6,281 50% Allocation from overall building support 4,795 4,995 5,325 6,281 3030 Other professional services 94,600 97,400 95,400 97,300 YMCA management contract (other half of fee in parks) 2,055 2,100 2,145 2,205 7.5% of audit 96,655 99,500 97,545 99,505 3300 Postage 1,100 1,200 1,200 1,200 50% of the cost of mailing the Mounds View Matters newsletter 1,100 1,200 1,200 1,200 3430 Printing 8,750 6,000 6,000 6,000 50% of the cost of printing the Mounds View Matters newsletter 8,750 6,000 6,000 6,000 3999 Allocation of utilities 45,250 52,030 48,760 49,994 50% Allocation from overall building utilities 45,250 52,030 48,760 49,994 4010 Rental, equipment 2,000 500 - - RecNet recreation programming and facility rental software 2,000 500 - - 4800 Bonding & insurance 3,500 3,500 3,500 4,025 Insurance & bonding cost. 3,500 3,500 3,500 4,025 5110 Repairs, building & grounds - 2,000 2,000 3,000 General building repairs - - - 7,000 Interior improvements 4,000 10,000 10,000 2,000 Gym floor resurfacing & maintenance 4,000 12,000 12,000 12,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,605 13,725 13,975 13,091 50% Allocation from overall building repairs 13,605 13,725 13,975 13,091 183,655 197,450 192,305 196,096 60 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Chamber of Commerce (4734); Chamber of Commerce Revenues 3633 Lease - Chamber of Commerce 13,120 10,832 12,148 12,148 - (12,148) -100.00% Total - Chamber revenues 13,120 10,832 12,148 12,148 - (12,148) -100.00% Chamber of Commerce Expenditures Personnel services 0999 Allocation of salaries 1,419 1,433 1,481 1,486 - (1,486) -100.00% Total personnel services 1,419 1,433 1,481 1,486 - (1,486) -100.00% Materials & supplies 2999 Allocation of supplies 338 403 426 320 - (320) -100.00% Total materials & supplies 338 403 426 320 - (320) -100.00% Contractual services 3999 Allocation of utilities 2,657 2,699 2,194 2,782 - (2,782) -100.00% 4750 Taxes, licenses, & fees 998 954 968 1,032 - (1,032) -100.00% 4800 Bonding & insurance - - 447 525 - (525) -100.00% 5999 Allocation of repairs 617 501 756 839 - (839) -100.00% Total contractual services 4,272 4,154 4,365 5,178 - (4,339) -83.80% Total Chamber of Commerce expendituers 6,029 5,990 6,272 6,984 - (6,145) -87.99% Total Chamber of Commerce Net 7,091 4,842 5,876 5,164 - (6,003) -116.25% (continued) 61 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Creative Kids Child Care (4736): Child Care Revenues 3632 Lease - Child Care 70,862 72,866 75,474 74,570 76,984 2,414 3.24% Subtotal - Child Care revenues 70,862 72,866 75,474 74,570 76,984 2,414 3.24% Child Care Ed Expenditures Personnel services 0999 Allocation of salaries 3,785 3,824 3,950 3,964 4,075 111 2.80% Total personnel services 3,785 3,824 3,950 3,964 4,075 111 2.80% Materials & supplies 2999 Allocation of supplies 2,139 2,549 2,701 2,024 2,252 228 11.24% Total materials & supplies 2,139 2,549 2,701 2,024 2,252 228 11.24% Contractual services 3999 Allocation of utilities 16,509 16,842 13,637 17,617 17,062 (555) -3.15% 4750 Taxes, licenses, & fees 7,098 6,790 6,888 7,345 7,100 (245) -3.34% 4800 Bonding & insurance 1,129 1,146 1,191 1,400 1,400 - 0.00% 5110 Repairs, building & grounds - - - - - - 0.00% 5999 Allocation of repairs 3,905 3,456 4,784 5,311 4,693 (618) -11.64% Total contractual services 28,641 28,234 26,500 31,673 30,255 (1,418) -4.48% Total Child Care expenditures 34,565 34,607 33,151 37,661 36,582 (1,079) -2.87% Total Child Care net 36,297 38,259 42,323 36,909 40,402 3,493 9.47% 62 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Lakeside Park (Fund 255): Revenues 3370 Spring Lake Pk contribution 8,719 10,608 10,608 10,608 10,608 - 0.00% 3370 Mounds View contribution 8,719 10,608 10,608 10,608 10,608 - 0.00% 3610 Investment income 689 345 478 300 300 - 0.00% 3680 Other revenue - - - - 0.00% 3665 Park site permit 114 515 217 150 150 - 0.00% Total revenue 18,241 22,076 21,911 21,666 21,666 - 0.00% Operating expenses (4350): Personnel services 0150 Salaries, part-time 2,263 2,853 3,360 3,349 3,349 - 0.00% 0300 Social security 173 218 257 256 256 - 0.00% 0500 Workers compensation 87 63 87 94 94 - 0.00% Total personnel services 2,523 3,134 3,704 3,699 3,699 - 0.00% Materials & supplies 1210 Supplies, bldgs & grounds - 1,595 432 600 600 - 0.00% 1600 Supplies, operating - 1,155 1,714 1,800 1,800 - 0.00% Total materials & supplies - 2,750 2,146 2,400 2,400 - 0.00% Contractual services 3200 Water & sewer 2,190 1,381 2,159 1,400 1,400 - 0.00% 3210 Electricity 489 637 700 600 700 100 16.67% 3530 Refuse collection 148 48 48 400 300 (100) -25.00% 4010 Equipment Contribution SLP 4,249 4,233 4,481 4,372 4,372 - 0.00% 4030 Satellites 551 550 507 500 550 50 10.00% 4800 Insurance 4,400 3,440 3,572 4,200 4,150 (50) -1.19% 5130 Repairs, equipment 5,311 637 3,316 4,095 4,095 - 0.00% Total contractual services 17,338 10,926 14,783 15,567 15,567 - 0.00% Capital 7030 Equipment - - - - - - 0.00% 7050 Construction - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total expenses 19,861 16,810 20,633 21,666 21,666 - 0.00% Net change in fund balance (1,620) 5,266 1,278 - - - 0.00% Fund balance, beginning year 3,728 2,108 7,374 8,652 8,652 - 0.00% Fund balance, end of year 2,108 7,374 8,652 8,652 8,652 - 0.00% 63 Fund: 255 Lakeside Park Revenues Account Description 2008 2009 2010 2011 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 150 Rental of the park by groups or individuals 150 150 150 150 Fund: 255 Department: 4350 Operations 1210 Supplies, bldgs & grounds 600 600 600 600 Paper, sand, etc. 600 600 600 600 1600 Supplies, operating 1,595 1,595 1,800 1,800 Fertilizer & pesticides 1,595 1,595 1,800 1,800 3200 Water & sewer 1,000 1,000 1,400 1,400 Estimated water & sewer charges 1,000 1,000 1,400 1,400 3210 Electricity 600 600 600 700 Estimated electric charges 600 600 600 700 3530 Refuse collection 400 400 400 300 Six months service 400 400 400 300 4010 Equipment, rental 4,372 4,372 4,372 4,372 Hourly usage of city equipment times commercial rental rates 4,372 4,372 4,372 4,372 4030 Satellites 500 500 500 550 Five months service 500 500 500 550 4800 Insurance & bonds 4,200 4,200 4,200 4,150 Property & liability insurnace 4,200 4,200 4,200 4,150 5130 Repairs, equipment 4,700 4,700 4,095 4,095 Repair of equipment at the park 4,700 4,700 4,095 4,095 17,967 17,967 17,967 17,967 20.79%0.00%0.00%0.00% 64 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Recycling (Fund 290): Revenues 3360 Other County grants 23,254 25,806 25,806 26,545 26,545 - 0.00% 3680 Other revenue - 943 943 - - - 0.00% Total revenue 23,254 26,749 26,749 26,545 26,545 - 0.00% Operating expenses Operations (4420) Personnel services 0100 Salaries, regular 5,005 5,523 5,523 8,528 8,488 (40) -0.47% 0300 Social security 319 388 388 652 646 (6) -0.92% 0321 PERA 330 342 342 597 612 15 2.51% 0400 Group insurance 1,443 1,420 1,420 2,164 2,190 26 1.20% 0500 Workers compensation 22 27 27 58 63 5 8.62% 0990 Severence pay - - - - - - 0.00% Total personnel services 7,119 7,700 7,700 11,999 11,999 - 0.00% Materials & supplies 1600 Supplies, operating 6,498 4,320 4,320 - - - 0.00% Contractual services 3030 Other professional services - 150 150 - - - 0.00% 3300 Postage 7,096 1,806 1,806 1,200 1,200 - 0.00% 3420 Advertisements - - - 1,545 1,545 - 0.00% 3430 Printing 552 4,158 4,158 1,301 1,301 - 0.00% 3530 Refuse collection 3,346 4,486 4,486 10,500 10,500 - 0.00% 3960 Awards - - - - - - 0.00% Total contractual services 10,994 10,600 10,600 14,546 14,546 - 0.00% Capital 7030 Equipment - - - - - - 0.00% Total capital outlays - - - - - - 0.00% Total expenses 24,611 22,620 22,620 26,545 26,545 - 0.00% Net change in fund balance (1,357) 4,129 4,129 - - - 0.00% Fund balance, beginning year 15,548 14,191 18,320 18,320 18,320 - 0.00% Fund balance, end of year 14,191 18,320 22,449 18,320 18,320 - 0.00% 65 Fund: 290 Recycling Grant Revenues Revenues Account Description 2008 2009 2010 2010 Description 3360 Other grants & aid 25,994 26,218 26,545 26,545 Estimated Ramsey County recycling grant 25,994 26,218 26,545 26,545 Fund: 290 Department: 4420 Operations 1600 Supplies, operatin - 4,000 - - - 4,000 - - 3030 Other professional services 1,800 - - - 1,800 - - - 3300 Postage 4,000 2,000 1,200 1,200 City wide mailing for Cleanup Day 4,000 2,000 1,200 1,200 3420 Advertisements 1,000 1,000 1,545 1,545 Promotional items 1,000 1,000 1,545 1,545 3430 Printing 1,800 1,800 501 501 Articles in City newsletter 1,564 1,413 800 800 Clean-up Day printing of direct mailing items 3,364 3,213 1,301 1,301 3530 Refuse collection 8,000 6,000 10,500 10,500 Contractual services for City Cleanup Day 8,000 6,000 10,500 10,500 18,164 16,213 14,546 14,546 66 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Levy Reduction (Fund 295): Revenues 3262 Grading Permit - - - - - - 0.00% 3268 Plan check fee 17,438 - - - - - 0.00% 3270 Building permit 26,139 - - - - - 0.00% 3271 Building permit - fixed fee - - - - - - 0.00% 3273 HVAC permit 13,319 - - - - - 0.00% 3274 Plumbing permit - - - - - - 0.00% 3277 Fire Department permits 150 - - - - - 0.00% 3280 Building surcharge - - - - - - 0.00% 3610 Investment income 399,852 299,523 151,343 166,000 131,000 (35,000) -21.08% 3680 Other revenue 115 - - - - - 0.00% 3972 Transfer from other funds - - - - - - 0.00% Total revenue 457,013 299,523 151,343 166,000 131,000 (35,000) -21.08% Operating expenses Transfers out 9900 Transfer to general fund 291,600 329,000 249,315 250,000 250,000 - 0.00% Total contractual services 291,600 329,000 249,315 250,000 250,000 - 0.00% Total expenses 291,600 329,000 249,315 250,000 250,000 - 0.00% Net change in fund balance 165,413 (29,477) (97,972) (84,000) (119,000) (35,000) 41.67% Fund balance, beginning year 6,587,459 6,752,872 6,723,395 6,625,423 6,541,423 (84,000) -1.27% Fund balance, end of year 6,752,872 6,723,395 6,625,423 6,541,423 6,422,423 (119,000) -1.82% 67 Fund: 295 Levy Reduction Fund Revenues Account Description 2008 2009 2010 2011 Description 3610 Investment income 247,125 253,233 166,000 131,000 Estimated interest earnings at 2.00%. 247,125 253,233 166,000 131,000 Fund: 295 Department: 4350 Expenditure Expenditure Expenditure Expenditures 9900 Transfer to General Fund 249,000 249,315 250,000 250,000 Levy reduction 80,000 - - - Temporary inspector and related costs 329,000 249,315 250,000 250,000 68 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent TIF # 1 (Fund 410): Revenues 3101 Tax collections 1,211,260 1,200,245 1,493,611 1,392,826 1,434,611 41,785 3.00% 3101 Tax collections - Mermaid 74,726 166,058 156,520 - 0.00% 3102 Taxes - delinquent 6,806 - 0.00% 3103 Market value credit 981 951 1,022 - 0.00% 3610 Investment income 78,614 102,265 41,887 10,000 14,000 4,000 40.00% 3972 Transfer from other funds 3,066 40,747 - - 0.00% Total revenue 1,375,453 1,510,266 1,693,040 1,402,826 1,448,611 45,785 3.26% Operating expenses (4650): Contractual services 3030 Other professional 6,665 3,463 2,212 1,000 2,000 1,000 100.00% 5220 Highway 10 redevelopment 601,359 100,168 20,261 100,000 375,000 275,000 275.00% 7050 Construction - 276,499 3,664,138 765,000 1,829,287 1,064,287 139.12% 8010 Developer PAG, principal - - 0.00% 9900 Transfers out to EDA 40,000 171,262 24,634 109,398 107,138 (2,260) -2.07% 9900 Transfers out to other funds 174,493 - - - - - 0.00% Total contractual services 822,517 551,392 3,711,245 975,398 2,313,425 1,338,027 137.18% Net change in fund balance 552,936 958,874 ########427,428 (864,814) (1,669,217) -390.53% Fund balance, beginning year 1,093,432 1,646,368 2,605,242 587,037 1,014,465 1,088,387 185.40% Fund balance, end of year 1,646,368 2,605,242 587,037 1,014,465 149,651 (580,830) -57.25% 69 Fund: 410 TIF District #1 Revenues Account Description 2008 2009 2010 2011 Description 3101 Tax increment collections 1,242,397 1,213,988 1,213,988 1,434,611 Estimated collections of incremental taxes on properties in the district. 1,242,397 1,213,988 1,213,988 1,434,611 3101 Tax increment collections 171,244 156,520 178,838 - Estimated collections of incremental taxes on the Mermaid 171,244 156,520 178,838 - property which are dedicated to the 2001A TIF bonds. (bonds paid off) 3610 Interest income 30,000 40,000 10,000 14,000 Estimated interest earnings at 2.00%. 30,000 40,000 10,000 14,000 Fund: 410 Department: 4650 Economic D Economic D Economic D Economic Development 3030 Other professional services 1,500 1,000 1,000 2,000 TIF administration and reporting fees 1,500 1,000 1,000 2,000 5220 County Rd 10 redevelopment - - - - CR 10 trail segmentsj 9 - 10 - - 100,000 375,000 CR 10/CR H Intersection (preconstruction) - - 100,000 375,000 7050 Construction 500,000 3,500,000 365,000 - Area B & C Street project - - 300,000 1,829,287 Area D Street project (preconstruction) 500,000 3,500,000 665,000 1,829,287 9900 Transfer out to EDA Fund 111,194 112,851 109,398 107,138 Transfer to cover the EDA operating budget. 111,194 112,851 109,398 107,138 9900 Transfer out to debt service 124,100 - - - Transfer to make debt service payments on TIF bonds 01A (Mermaid) 124,100 - - - 736,794 3,613,851 875,398 2,313,425 70 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent TIF # 2 (Fund 420): Revenues 3101 Tax collections 148,957 128,125 143,266 151,698 154,335 2,637 1.74% 3102 Tax collections - delinquent - - 1,116 - - - 0.00% 3103 Market value credit 745 730 765 - - - 0.00% 3610 Investment income 17,009 16,275 11,347 2,500 2,500 - 0.00% 3680 Other revenue 100 25 - - - - 0.00% 3972 Transfer from other funds 20,373 60,978 - - - - 0.00% Total revenue 187,184 206,133 156,494 154,198 156,835 2,637 1.71% Operating expenses (4650): Contractual services 3030 Other professional 5,311 1,375 1,240 1,200 1,200 - 0.00% 4750 Taxes, Licenses, & Fees 2,546 - - - - - 0.00% 7050 Construction - - 165,734 - - - 0.00% 8010 Developer PAG, principal 36,536 34,412 37,358 38,452 46,753 8,301 21.59% 9900 Transfers out to debt service/EDA 70,489 81,776 24,634 109,397 107,138 (2,259) -2.06% Total contractual services 114,882 117,563 228,966 149,049 155,091 6,042 4.05% Net change in fund balance 72,302 88,570 (72,472) 5,149 1,744 (74,762) -1451.98% Fund balance, beginning year 265,126 337,428 425,998 353,526 358,675 260,309 73.63% Fund balance, end of year 337,428 425,998 353,526 358,675 360,419 185,547 51.73% 71 Fund: 420 TIF District #2 Revenues Account Description 2008 2009 2010 2011 Description 3101 Tax increment collections 181,621 146,436 151,698 154,335 Estimated collections of incremental taxes on properties 181,621 146,436 151,698 154,335 in the district. 3610 Investment income 11,250 11,250 2,500 2,500 Estimated interest earnings at 2.50%. 11,250 11,250 2,500 2,500 Fund: 420 Department: 4650 Economic Development 3030 Other professional services 1,500 1,200 1,200 1,200 TIF administration and reporting fees 1,500 1,200 1,200 1,200 7050 Construction - 313,019 - 2009/2010 Street project - 313,019 - - 8010 Pay-as-you-go principal 68,158 36,264 38,452 46,753 Principal on a revenue note issued to promote a development. 68,158 36,264 38,452 46,753 (Silver Lake Point Project - Heartland MV Common Bond, LLC.) 9900 Transfer out to EDA Fund 111,193 112,851 109,397 107,138 Transfer to cover the EDA operating budget. 111,193 112,851 109,397 107,138 180,851 463,334 149,049 155,091 72 2011 Budget Summary 2007 2008 2009 2010 2011 Actual Actual Actual Budget Request Dollar Percent TIF # 3 (Fund 430): Revenues 3101 Tax collections 425,172 367,643 351,862 328,408 370,824 42,416 12.92% 3102 Tax collections - delinquent - - - - - - 0.00% 3610 Investment income 35,069 33,367 21,013 12,500 10,000 (2,500) -20.00% 3972 Transfer from other funds 27,423 - - - - - 0.00% Total revenue 487,664 401,010 372,875 340,908 380,824 39,916 11.71% Operating expenses (4650): Contractual services 3030 Other professional 5,807 915 987 1,200 1,200 - 0.00% 5220 Highway 10 redevelopment - 95,413 723,906 - - - 0.00% 7050 Construction 9,104 1,484 - - 625,456 625,456 #DIV/0! 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 40,000 95,875 24,634 109,397 107,138 (2,259) -2.06% Total contractual services 54,911 453,617 749,527 110,597 733,794 623,197 563.48% Net change in fund balance 432,753 (52,607) (376,652) 230,311 (352,970) (713,816) -309.94% Fund balance, beginning year 461,417 894,170 841,563 464,911 695,222 377,860 81.28% Fund balance, end of year 894,170 841,563 464,911 695,222 342,252 (335,956) -48.32% Change from 2010 73 Fund: 430 TIF District #3 Revenues Account Description 2008 2009 2010 2011 Description 3101 Tax increment collections 417,770 394,056 328,408 370,824 Estimated collections of incremental taxes on properties 417,770 394,056 328,408 370,824 in the district. 3610 Investment income 22,500 22,500 12,500 10,000 Estimated interest earnings at 2.50%. 22,500 22,500 12,500 10,000 Fund: 430 Department: 4650 Economic Development 3030 Other professional services 1,000 1,200 1,200 1,200 TIF administration and reporting fees 1,000 1,200 1,200 1,200 7050 Construction - - - 625,456 Area E Street project (preconstruction) 170,000 750,000 - CR 10 trail segments 1 - 5 (H to Silver Lk Rd)(also in 285 grant portion) 170,000 750,000 - 625,456 (prepare plans and specs in 2008) 8010 Pay-as-you-go principal 123,442 - - - Principal on a revenue note issued to promote a development. 123,442 - - - 8020 Pay-as-you-go interest 8,002 - - Interest on a revenue note issued to promote a development. 8,002 - - - 9900 Transfer out to EDA Fund 111,193 112,851 109,397 107,138 Transfer to cover the EDA operating budget. 111,193 112,851 109,397 107,138 413,637 864,051 110,597 733,794 74 2007 2008 2009 2010 2011 Actual Actual Actual Budget Request Dollar Percent TIF # 5 (Fund 450): Revenues 3101 Tax collections - 674,255 1,565,044 1,139,960 1,320,408 180,448 15.83% 3610 Investment income - 3,265 4,161 6,300 9,000 2,700 42.86% Total revenue - 677,520 1,569,205 1,146,260 1,329,408 183,148 15.98% Operating expenses (4650): Contractual services 3030 Other professional - 1,284 1,109 1,200 1,400 200 16.67% 8010 Developer PAG, principal - 319,118 1,062,514 1,082,963 1,266,569 183,606 16.95% 8020 Developer PAG, interest - - - - - - 0.00% 9900 Transfers out to EDA - 33,592 55,922 56,997 66,020 9,023 15.83% Total contractual services - 353,994 1,119,545 1,141,160 1,333,989 192,829 16.90% Net change in fund balance - 323,526 449,660 5,100 (4,581) (9,681) -189.82% Fund balance, beginning year - - 323,526 773,186 778,286 5,100 0.66% Fund balance, end of year - 323,526 773,186 778,286 773,705 (4,581) -0.59% 2011 Budget Summary Change from 2010 75 Fund: 450 TIF District #5 Revenues Account Description 2008 2009 2010 2011 Description 3101 Tax increment collections 715,626 846,270 1,139,960 1,320,408 Estimated collections of incremental taxes on properties 715,626 846,270 1,139,960 1,320,408 in the district. 3610 Investment income 6,300 6,300 6,300 9,000 Estimated interest earnings at 2.00%. 6,300 6,300 6,300 9,000 Fund: 430 Department: 4650 Economic D Economic D Economic D Economic Development 3030 Other professional services 1,500 1,200 1,200 1,400 TIF administration and reporting fees 1,500 1,200 1,200 1,400 8010 Pay-as-you-go principal 323,542 803,956 1,082,963 1,266,569 Principal on a revenue note issued to promote a development. (Medtronic) 323,542 803,956 1,082,963 1,266,569 9900 Transfer out to EDA Fund 35,781 42,313 56,997 66,020 Transfer to cover the EDA operating budget. 35,781 42,313 56,997 66,020 76 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Vehicle & Equipment (Fund 640): Revenues 3610 Investment income 98,639 - - - - - 0.00% 3972 Transfers in - General fund 175,000 175,000 175,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 6,000 16,000 16,000 - 0.00% Total revenue 335,639 237,000 237,000 122,000 185,000 63,000 51.64% Operating expenses Operations (4160): Other 9900 Transfer out - General Fund 141,500 117,250 44,000 65,600 207,394 141,794 216.15% 9900 Transfer out - Water Fund - - - - 289,000 289,000 #DIV/0! 9900 Transfer out - Sewer Fund - - - 330,000 300,000 (30,000) -9.09% 9900 Transfer out - Storm Water Fund - - - 40,000 40,000 - 0.00% Total other 141,500 117,250 44,000 435,600 836,394 400,794 92.01% Total expenses 141,500 117,250 44,000 435,600 836,394 400,794 92.01% Net change in fund balance 194,139 119,750 193,000 (313,600) (651,394) (757,298) 241.49% Fund balance, beginning year 1,641,142 1,835,281 1,955,031 2,148,031 1,834,431 341,738 15.91% Fund balance, end of year 1,835,281 1,955,031 2,148,031 1,834,431 1,183,037 (415,560) -22.65% 77 Fund: 640 Vehicle & Equipment Fund Revenues Account Description 2008 2009 2010 2011 Description 3610 Interest income - - - - Estimated interest earnings (moved to general fund per council 08) - - - - 3961 Transfers in 175,000 175,000 50,000 75,000 From General Fund 20,000 20,000 20,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 247,000 122,000 185,000 Fund: 640 Department: 4160 Operations 9900 Transfers out 117,250 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, taser $1,200 - - - 22,894 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 Water Tower major maintenance 36,000 - - - Sewer generator - trailer mounted - 330,000 330,000 300,000 Sewer - Vactor 40,000 40,000 40,000 40,000 Storm Water - truck (carryover from 2007) 193,250 535,500 435,600 962,094 78 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Community Fund (Fund 235): Revenues 3610 Investment income 143,139 112,667 60,696 67,250 - (28,736) -42.73% Total revenue 143,139 112,667 60,696 67,250 - (28,736) -42.73% Operating expenses Operations (4650): Contractual services 5150 Repairs, utility 650 - - - - (78,000) #DIV/0! Total contractual services 650 - - - - (78,000) #DIV/0! Capital 7050 Construction - - - 2,750,000 - - 0.00% Total capital outlays - - - 2,750,000 - - 0.00% Total expenses 650 - - 2,750,000 - (78,000) -2.84% Net change in fund balance 142,489 112,667 60,696 (2,682,750) - 49,264 -1.84% Fund balance, beginning year 2,373,460 2,515,949 2,628,616 2,689,312 6,562 (2,310,077) -85.90% Fund balance, end of year 2,515,949 2,628,616 2,689,312 6,562 6,562 (2,260,813) -34452.90% 2011 Budget summary 79 Fund: 235 Community Fund Revenues Account Description 2008 2009 2010 2011 Description 3610 Investment income 90,000 90,000 67,250 - Estimated interest earnings at 2.5% 90,000 90,000 67,250 - Fund: 285 Department: 4470 Expenditure Expenditure Expenditure Expenditures 7050 Construction - - 2,750,000 - 2010 Area B&C Street & Utility Project - - 2,750,000 - 80 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Special Projects (Fund 280): Revenues 3551 Spec assessmt current 3,826 3,591 - - 0.00% 3552 Spec assessmt delinquent 83 - 73 - 0.00% 3553 Spec assessmt penalty & interest 20 - 12 - 0.00% 3610 Investment income 84,076 64,034 28,276 30,000 17,000 (13,000) -43.33% 3680 Other revenue - 126 - - 0.00% 3972 Transfers in 12,563 - - - 0.00% Total revenue 100,568 67,751 28,361 30,000 17,000 (13,000) -43.33% Operating expenses Operations (4180): Contractual services 3030 Other professional services 18,481 22,260 1,116 - 10,000 10,000 #DIV/0! 5130 Repairs; Equipment 313 140 - - - - 0.00% Total contractual services 18,794 22,400 1,116 - 10,000 10,000 #DIV/0! Capital 7030 Capital equipment 651 27,092 84,949 25,000 90,000 65,000 260.00% 7050 Construction 94,804 31,379 6,977 424,000 342,000 (82,000) -19.34% Total capital outlays 95,455 58,471 91,926 449,000 432,000 (17,000) -3.79% Other 9900 Transfer out - 90,000 - 90,000 90,000 - 0.00% Total other - 90,000 - 90,000 90,000 - 0.00% Total expenses 114,249 170,871 93,042 539,000 532,000 (7,000) -1.30% Net change in fund balance (13,681) (103,120) (64,681) (509,000) (515,000) (6,000) 1.18% Fund balance, beginning year 1,510,752 1,497,071 1,393,951 1,329,270 820,270 (509,000) -38.29% Fund balance, end of year 1,497,071 1,393,951 1,329,270 820,270 305,270 (515,000) -62.78% 2011 Budget Summary 81 Fund: 280 Special Projects Revenues Account Description 2008 2009 2010 2011 Description 3610 Investment income 45,000 45,000 30,000 17,000 Estimated interest earnings at 2.00%. 45,000 45,000 30,000 17,000 Fund: 280 Department: 4180 Expenditures 3030 Other professional services - - - - Ramsey County fee for spec. ass. adm. 10,000 - - - PW Building Evaluation - - - 10,000 Scanning of microfilm to laserfiche 22,000 - - - 1st and 2nd phase of Laserfiche Imaging conversion over 2 years 32,000 - - 10,000 7030 Capital, equipment 42,000 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) 5,067 - - - Laserfiche software upgrade (one-time pay to Roseville) 47,067 32,500 25,000 90,000 7050 Construction - - 30,000 - Community center parking lot improvements - - 15,000 - Lambert Park building (preconstruction)(50% in Park Dedication) 80,000 - - - City Hall Alternative Power Supply Project (60,000 in water & sewer) 13,000 - - 13,000 City Hall irigation project (postponed from 08) 16,000 - - - Civil defense siren replacement (3rd of 3) 28,000 - - 30,000 Edgewood Dr. boulevard project (carryover from 2007) 23,000 - - - Seal coat Community Center parking lot 3,000 - - - City entrance signs (12) - 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 - Community center energy improvements (carryover from 09) - 120,000 120,000 - PW shop intermediate rehabilitation (carryover from 09) - 40,000 40,000 20,000 Pathway rehabilitation program - 6,500 - - Community Center Copier (lease expires 5/09) - - - 175,000 City Hall roof replacement/repair 163,000 385,500 424,000 342,000 9900 Transfer to General Fund 90,000 90,000 90,000 90,000 Transfer to Comm. Center Fund 10,000 - - - 100,000 90,000 90,000 90,000 82 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Street Improvement (Fund 285): Revenues 3101 Property taxes - - - 300,000 300,000 - 0.00% 3180 Franchise fee 273,540 283,796 235,002 287,000 249,900 (37,100) -12.93% 3319 Other federal grants - - 463,438 - 0.00% 3352 MSA street construction - - 1,157,743 365,000 383,000 18,000 4.93% 3359 Other state grants - - - 195,000 195,000 #DIV/0! 3360 Other county grant - - 216,973 - 0.00% 3550 Spec assessmt prepayment - - 209,822 - 0.00% 3610 Investment income 160,067 122,387 106,092 72,500 100,000 27,500 37.93% 3680 Other revenue 2,522 14,130 42,369 - - - 0.00% 3972 Transfer from other funds - 100,000 280,000 300,000 300,000 - 0.00% Total revenue 436,129 520,313 2,711,439 1,324,500 1,527,900 203,400 15.36% Operating expenses Operations (4470): Contractual services 3030 Other professional services 44,996 144,953 99,508 - - - 0.00% 3810 Special assessment refunds - 110,391 3,818 - - - 0.00% 5130 Repair 581 - - - - - 0.00% Total contractual services 45,577 255,344 103,326 - - - 0.00% Capital 7050 Construction 224,470 325,219 572,522 547,000 767,000 220,000 40.22% Total capital outlays 224,470 325,219 572,522 547,000 767,000 220,000 40.22% Total expenses 270,047 580,563 675,848 547,000 767,000 220,000 40.22% Net change in fund balance 166,082 (60,250) 2,035,591 777,500 760,900 (16,600) -2.14% Fund balance, beginning year 2,580,534 2,746,616 2,686,366 4,721,957 5,499,457 777,500 16.47% Fund balance, end of year 2,746,616$ 2,686,366$ 4,721,957$ 5,499,457$ 6,260,357$ 760,900$ 13.84% 2011 Budget Summary 83 Fund: 285 Street Improvement Revenues Account Description 2008 2009 2010 2011 Description 3101 Property taxes - - 300,000 300,000 General tax levy for streets - - 300,000 300,000 3180 Franchise fee 310,000 290,625 287,000 249,900 Half of the 3.87% franchase fee on gas & electric utilities 310,000 290,625 287,000 249,900 3319 Other federal grants - 525,000 - - Federal trails grant - - - 630,000 Federal safety grant for Cty H intersection(2011) - 525,000 - 630,000 3352 MSA Street Construction - 1,374,090 365,000 383,000 State aid funds - 1,374,090 365,000 383,000 3359 Other state grants - - - 300,000 MNDOT Coop Agreement (2011 H and Cty 10 intersection project) - - - 70,000 Ramsey Cty CSAH (2010 H and Cty 10 intersection project) - - - 125,000 CR 10 Turnback Funds (2010 H and Cty 10 intersection project) - - - 495,000 3610 Investment income 93,750 93,750 72,500 100,000 Estimated interest earnings at 2.00%. 93,750 93,750 72,500 100,000 3972 Transfer in - 280,000 300,000 300,000 Transfers from utility funds (water 100,000, sewer 160,000, storm 40,000) - 280,000 300,000 300,000 Fund: 285 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 - 300,000 - 350,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 212,000 - - - Traffic signal @ H and Silver Lake Road (what does council want to do?) 170,000 - - - Seal coat project 382,000 1,725,000 547,000 767,000 84 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Park Dedication (Fund 251): Revenues 3610 Investment income 57,306 37,535 20,320 20,000 15,000 (5,000) -25.00% 3650 Park donations 10,640 1,000 2,664 - 0.00% 3652 Park dedication fees 1,411 18,239 1,800 6,000 6,000 - 0.00% Total revenue 69,357 56,774 24,784 26,000 21,000 (5,000) -19.23% Operating expenses Operations (4470): Materials & supplies 1600 Supplies, operating - 549 - - - - 0.00% Total materials & supplies - 549 - - - - 0.00% Contractual services 3030 Other professional services 1,672 - - - - - 0.00% Total contractual services 1,672 - - - - - 0.00% Capital 7050 Construction 200,980 45,322 5,986 65,000 310,000 245,000 376.92% Total capital outlays 200,980 45,322 5,986 65,000 310,000 245,000 376.92% Total expenses 202,652 45,871 5,986 65,000 310,000 245,000 376.92% Net change in fund balance (133,295) 10,903 18,798 (39,000) (289,000) (250,000) 641.03% Fund balance, beginning year 1,013,260 879,965 890,868 909,666 870,666 (39,000) -4.29% Fund balance, end of year 879,965$ 890,868$ 909,666$ 870,666$ 581,666$ (289,000)$ -33.19% 2011 Budget Summary 85 Fund: 251 Park Dedication Fund Revenues Account Description 2008 2009 2010 2011 Description 3610 Investment income 30,000 30,000 20,000 15,000 Estimated interest earnings at 2.00%. 30,000 30,000 20,000 15,000 3652 Park dedication fees 6,000 6,000 6,000 6,000 Developer payments 6,000 6,000 6,000 6,000 Fund: 251 Department: 4470 Expenditures 7050 Construction - - 15,000 Lambert Park building (preconstruction)(50% in Spec. Projects Fund) - - - 260,000 Lambert Park building (construction)(does Council want to split?) - - - 40,000 Relocate Lambert ballfield to accomodate reconfigured building site. - - - 10,000 Hillview hockey rink expansion and grading - - 25,000 Groveland & Hillview drainage and irrigation improvements 38,000 - - - Playground replacement project (City Hall 2008) - 8,000 - - Playground media 30,000 - - - 2008 park pathway paving project 13,000 - - - Greenfield & Groveland parks security lights 22,000 - - - Silver View & Greenfield parks parking lot sealcoat project 22,500 25,000 25,000 Park Improvement Program 31,000 20,000 - - Groveland & Hillview baseball field rehab project (carryover Groveland) 10,000 10,000 - - Groveland baseball field backstop (carryover to 2009) 25,000 - - - Oakwood/Greenfield disc golf course 20,000 - - - Lakeside park improvements (Lions contribution $50,000, SLP $20,000) - 32,000 - - Hillview Parking Area - 20,000 - - Greenfield Park open space 211,500 115,000 65,000 310,000 86 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Water (Fund 700): Revenues 3424 Meter charge 44,305 1,859 2,451 - - - 0.00% 3426 Reimbursed staff time 220 - 357 - - - 0.00% 3551 Spec assessments-current 41,677 34,719 38,321 50,000 50,000 - 0.00% 3552 Spec assessments-delinquent 4,052 7,300 31,639 - - - 0.00% 3553 Spec assess.-penalty & interest 373 464 1,559 - - - 0.00% 3610 Investment income 107,137 72,980 33,770 31,250 31,250 - 0.00% 3631 Water tower space rental 55,480 60,390 62,832 59,197 - (59,197) -100.00% 3680 Other revenues 3,666 2,939 788 2,000 2,000 - 0.00% 3710 Water sales 652,650 683,665 683,987 737,052 737,052 - 0.00% 3713 Mn Safe Water fee 2,013 - - - - - 0.00% 3714 Water service fee 47,311 47,587 50,547 51,500 51,500 - 0.00% 3715 Utility connections 970 805 480 1,250 1,000 (250) -20.00% 3716 Penalties (758) 8,561 8,594 - - - 0.00% 3912 Sale of materials - - - - - - 0.00% 3913 Meter sales 1,020 1,020 763 - - - 0.00% WAC/SWM charges 9,300 1,200 2,900 - - - 0.00% 3940 Capital Contributions - - 42,475 - 0.00% 3972 Transfers - Vehicle & Equip - - - - 289,000 289,000 #DIV/0! Total revenue 969,416 923,489 961,463 932,249 1,161,802 229,553 24.62% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 29,950 30,751 33,262 33,551 33,058 (493) -1.47% 0110 Salaries, overtime 19 67 7 - - - 0.00% 0150 Salaries, part-time - - - - - - 0.00% 0300 Social security 2,116 2,325 2,360 2,567 2,529 (38) -1.48% 0321 PERA 1,889 1,895 2,196 2,349 2,396 47 2.00% 0400 Group insurance 2,288 2,389 2,803 4,285 4,387 102 2.38% 0500 Workers compensation 184 138 168 197 222 25 12.69% 0990 Severance - - - - - 0.00% Total personnel services 36,446 37,565 40,796 42,949 42,592 (357) -0.83% Materials & supplies 1600 Supplies, operating - - 4 50 50 - 0.00% Total materials & supplies - - 4 50 50 - 0.00% Contractual services 3030 Other professional services 6,318 8,015 6,334 7,635 7,815 180 2.36% 3300 Postage 3,020 2,974 2,710 3,190 3,256 66 2.07% 3430 Printing 933 1,093 680 900 900 - 0.00% 3630 Training - - - 250 250 - 0.00% 5130 Repairs, equipment 2,487 2,737 3,128 3,174 3,332 158 4.98% Total contractual services 12,758 14,819 12,852 15,149 15,553 404 2.67% Debt Service: 8010 Principal 185,000 190,000 200,000 205,000 210,000 5,000 2.44% 8020 Interest 40,935 35,325 29,350 25,570 18,825 (6,745) -26.38% 8030 Paying agent fees 431 431 431 475 475 - 0.00% 8040 Continuing disclosure 983 1,675 1,138 2,150 2,150 - 0.00% Total capital outlays 227,349 227,431 230,919 233,195 231,450 (1,745) -0.75% Miscellaneous: 9800 Loss on disposal of asset - - - - 0.00% 9900 Transfers out to General Fund 56,422 58,115 59,859 61,655 63,505 1,850 3.00% 9900 Transfers out to Vehicle Fund 20,000 20,000 20,000 20,000 57,000 37,000 185.00% Total capital outlays 76,422 78,115 79,859 81,655 120,505 38,850 47.58% Total Billing 352,975 357,930 364,430 372,998 410,150 37,152 9.96% 2011 Budget Summary 87 Fund: 700 Department: 4820 Billing Services Account Description 2008 2009 2010 2011 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 6,165 6,300 6,435 6,615 22.5% of audit fee 800 800 800 800 Inserting & mailing bills 400 400 400 400 Legal services 1,000 - - - Sensus System Support (water meter reading software) 8,365 7,500 7,635 7,815 3300 Postage 2,624 2,688 2,816 2,816 3200 bills X $0.44 postage X 4 billings X 1/2 cost 349 357 374 440 Late notices: 500 bills X $0.44 postage X 4 billings X 1/2 cost 2,973 3,045 3,190 3,256 3430 Printing 350 450 450 450 Utility bills (1/2 cost) 350 450 450 450 Envelopes 700 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,678 2,717 2,885 3,029 INCODE software support (30%) - - 289 303 Handheld interface support for new meter readers (50% water 50% sewer) 2,678 2,717 3,174 3,332 8010 Principal 190,000 200,000 205,000 210,000 Principal due on bonds 190,000 200,000 205,000 210,000 8020 Interest 37,700 31,850 25,570 18,825 Interest due on 2002 A Bonds 37,700 31,850 25,570 18,825 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 2,150 Annual debt disclosure requirements and Ramsey county sp. Assmt. Fees 2,150 2,150 2,150 2,150 9900 Transfers out 58,115 59,859 61,655 63,505 Transfer to General Fund for administrative overhead costs 20,000 20,000 20,000 57,000 Transfer to Vehicle & Equipment Fund to fund future vehicle purchases 78,115 79,859 81,655 120,505 323,456 328,796 330,049 367,558 88 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Water (Fund 700): 2011 Budget Summary Infrastructure & Equip Maintenance (4823): Personnel services 0100 Salaries, regular 163,817 159,180 153,144 166,596 168,844 2,248 1.35% 0110 Salaries, overtime 4,563 15,168 15,195 9,002 9,002 - 0.00% 0150 Salaries, part-time 31,290 11,667 16,474 18,475 18,475 - 0.00% 0300 Social security 13,486 13,735 12,845 14,847 15,019 172 1.16% 0321 PERA 10,145 9,974 11,637 12,564 13,176 612 4.87% 0400 Group insurance 21,109 21,482 25,145 28,450 28,828 378 1.33% 0500 Workers compensation 4,004 4,174 5,048 5,764 6,141 377 6.54% 600 Unemployment - - - - - - 0.00% 990 Severence - - - - - - 0.00% Total personnel services 248,414 235,380 239,488 255,698 259,485 3,787 1.48% Materials & supplies 1210 Supplies, bldg & grnds 2,154 1,668 3,174 3,300 5,300 2,000 60.61% 1220 Supplies, vehicles 409 191 593 800 800 - 0.00% 1230 Supplies, equipment 795 264 1,579 818 818 - 0.00% 1240 Supplies, streets 1,538 2,349 1,247 3,000 5,000 2,000 66.67% 1250 Supplies, utilities 7,397 9,786 5,902 7,500 11,750 4,250 56.67% 1260 Supplies, traffic control - - 38 200 200 - 0.00% 1600 Supplies, operating 3,742 3,169 6,751 3,300 4,300 1,000 30.30% 1700 Motor fuels 3,247 8,383 2,832 4,713 4,800 87 1.85% 2400 Uniforms 1,302 1,021 1,239 1,380 1,380 - 0.00% 2410 Mats & towels 758 1,140 1,427 800 800 - 0.00% Total materials & supplies 21,342 27,971 24,782 25,811 35,148 9,337 36.17% Contractual services 3030 Other professional services 6,942 470 8,272 14,150 12,350 (1,800) -12.72% 3100 Communications - telephone 10,091 4,515 1,909 1,680 1,780 100 5.95% 3200 Water & wastewater charges 5,765 7,002 8,030 5,000 5,000 - 0.00% 3220 Natural gas 8,695 11,964 10,792 12,000 12,000 - 0.00% 3610 Memberships 514 280 261 433 353 (80) -18.48% 3630 Training 2,639 896 943 2,785 2,650 (135) -4.85% 4010 Equipment rental 5,330 331 2,458 3,800 4,500 700 18.42% 4800 Insurance 9,803 8,378 8,700 10,230 10,230 - 0.00% 5130 Repairs, equipment 4,684 5,738 6,309 2,950 2,500 (450) -15.25% 5140 Repairs, streets 5,226 3,700 12,500 10,000 10,000 - 0.00% 5150 Repairs, utilities 8,301 2,138 6,337 5,200 1,800 (3,400) -65.38% 5155 Water service repair 39,934 55,824 41,271 50,000 50,000 - 0.00% 5160 Repairs, system maintenance - 980 2,650 15,000 15,000 - 0.00% Total contractual services 107,924 102,216 110,432 133,228 128,163 (5,065) -3.80% Capital outlays 7030 Equipment - - - 138,000 28,500 (109,500) -79.35% 7050 Construction - - - 393,700 1,212,700 819,000 208.03% 7950 Depreciation 208,320 209,839 230,375 215,000 225,000 10,000 4.65% Total capital outlays 208,320 209,839 230,375 746,700 1,466,200 719,500 96.36% 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.00% Total miscellaneous - 30,000 90,000 115,000 115,000 100,000 86.96% Total infrastructure & equip maint 586,000 605,406 695,077 1,276,437 2,003,996 827,559 64.83% 89 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2008 2009 2010 2011 Description 1210 Supplies, Bldgs & grounds 100 100 100 100 Mops, buckets, brooms 900 900 600 600 Light tubes & ballasts 200 200 200 200 Paper products 200 200 200 200 Paint, thinner, & brushes 250 250 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 700 500 500 Irrigation parts 600 600 300 300 Goose repellent 3,850 3,850 3,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 300 100 100 Grounds maintenance equipment 150 150 100 100 Blades, suction hoses, filter screens 168 168 168 168 Hydraulic fluid: 35 gallons @ $4.80 / gallon 220 220 200 200 Solvents & cleaning fluids 200 200 150 150 Air, oil, fuel, & trans filters 1,138 1,138 818 818 1240 Supplies, streets 3,000 3,000 3,000 5,000 Asphalt/concrete/sod/seed for patching minor street,curb, driveway repairs. 3,000 3,000 3,000 5,000 1250 Supplies, utilities 150 150 150 150 Air compresser & dehumidifier parts 500 500 500 2,500 Meter batteries (100 @ $25) 500 500 500 500 Paint & sandblasting materials for hydrants 500 500 500 500 Copper, steel & PVC pipe 600 600 1,200 - Location flags & paint (moved to account 1600) 650 650 650 2,100 Chemical equipment parts (flouride pumps) 1,500 1,500 1,500 1,500 Valve box risers, main repair clamps 2,000 2,000 1,000 1,000 Hydrant markers 2,500 2,500 1,500 1,500 Hydrant repair parts & used hydrants - - - 2,000 Meter supplies, etc. (move from account 1600) 850 850 - - Metal locator replacement 9,750 9,750 7,500 11,750 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 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 500 - Meter supplies, etc. (move to account 1250) 3,300 3,300 3,300 4,300 1700 Motor fuels & lubs 155 213 188 375 Diesel fuel - 100 gallons @ $3.75 188 300 300 200 Propane: 50 gallons @ $4 3,300 4,875 4,225 4,225 Unleaded fuel: 1,300 gallons @ $3.25 3,643 5,388 4,713 4,800 2400 Uniforms 1,380 1,380 1,380 1,380 Uniforms 1.15 FTE @ $1200 (inlcudes jackets/boots per contract) 1,380 1,380 1,380 1,380 2410 Mats & towels 800 800 800 800 Share of floor mats & shop towels 800 800 800 800 3030 Other professional services 1,400 1,400 1,400 1,400 Backflow preventor annual inspections: 7 @ $200 - - - 3,000 Water system leak survey 5,000 5,000 - - Water tower evaluation - - - 200 Sprinkler inspections - Well #3 (moved from account 5130) 2,000 2,000 2,750 2,750 Gopher State One-call locates 3,000 3,000 10,000 5,000 Arcview/GIS base map consulting 11,400 11,400 14,150 12,350 3100 Communications - telephone 400 400 400 400 Service & repair 1,200 1,200 1,200 1,200 Cellular phone service 80 80 80 80 On call pager (half water / half sewer) - - - 100 800 Mhz license fee (20% of $500) 1,680 1,680 1,680 1,780 3200 Water and wastewater charges 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 90 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2008 2009 2010 2011 Description 3220 Natural gas 12,000 12,000 12,000 12,000 Heating fuel 12,000 12,000 12,000 12,000 3610 Memberships 200 200 113 113 APWA - 1/4 membership 195 195 195 100 MN Rural Water Association (50%) 65 65 65 80 MN Safety Council (20%) 60 60 60 60 Pressurized vessel license 520 520 433 353 3630 Training 600 600 600 - Collection operator's seminar 250 250 250 250 Computer training 200 200 200 200 Confined space safety seminar 120 120 120 120 Hearing test 50 50 50 50 License renewal 60 60 60 60 Maintenance Expo 160 160 160 800 Water operator class/exam 200 200 200 200 Misc. training seminars 400 400 400 200 MRWA workshops 200 200 125 150 MN Public Works Assoc workshop 560 560 560 560 Tuition reimbursement 60 60 60 60 Work zone safety seminar 2,860 2,860 2,785 2,650 4010 Rental, equipment 2,500 2,500 2,500 3,500 Skid steer - upgrade 600 600 600 600 Barricades & signs 400 400 400 400 Tools & equipment 300 300 300 - Fax machine 3,800 3,800 3,800 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 1,000 Chemical pump repairs 250 250 250 - Copier maintenance 350 350 350 350 Fire extinguisher recharge / repair 1,000 1,000 1,000 1,000 Miscellaneous repairs 200 200 200 - Sprinkler inspections - Well #3 (move to account 3030) 150 150 150 150 Radio repairs 2,950 2,950 2,950 2,500 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 900 - Floride tanks for each well house (every 3 years) - 2,500 2,500 - Leak survey (moved to account 3030) 2,700 5,200 5,200 1,800 5155 Water service repairs 35,000 45,000 50,000 50,000 Contractor repairs to residential water services. 35,000 45,000 50,000 50,000 5160 System maintenance 13,000 13,000 13,000 13,000 Building repairs 2,000 2,000 2,000 2,000 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 - 10,000 - - Water tower assessment - - 5,000 5,000 GPS Locating Equipment (Sewer 5,000)(carryover from 2010) - - 125,000 - Booster station - - - 10,500 Plate compactor for backhoe 130,000 - - - Meters, MXUs - - - - 2,000 - - - 5,000 SCADA System upgrade Phase #2 well #6 80,000 20,000 - - Generator (trailer mounted)(20,000 to water and 10,000 to sanitary sewer) 25,000 - - - Water meter reader - handheld programmer 218,000 38,000 138,000 28,500 7050 Construction 30,000 90,000 - - Water system upgrades in conjunction with major roadway program - - - 800,000 Water tower rehabilitation 2011 - $800,000 - - 100,000 75,000 Well #2 motor replacement (carryover from 2010) - - 22,700 22,700 Well #1,2,3 building repairs (interior and exterior repairs)(carryover from 10) - - 211,000 250,000 Reservoir & booster station building and roof repairs (carryover from 2010) - - - 65,000 Roof replacement wells #2, 5, & 6 50,000 - 60,000 - Well pump rehabilitation project - well no. 1&2 80,000 90,000 393,700 1,212,700 7950 Depreciation 230,000 220,000 215,000 225,000 Estimated depreciation 230,000 220,000 215,000 225,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 Water system upgrades in conjunction with major roadway program - - 100,000 100,000 684,001 518,246 1,020,739 1,744,511 91 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Water (Fund 700): 2011 Budget Summary Water Production (4825): Materials & supplies 1600 Supplies, operating 18,539 25,600 31,007 31,928 32,778 850 2.66% 1700 Motor fuels 428 616 310 3,922 2,700 (1,222) -31.16% Total materials & supplies 18,967 26,216 31,317 35,850 35,478 (372) -1.04% Contractual services 3030 Other professional services 15,190 12,307 23,991 31,530 37,230 5,700 18.08% 3210 Electricity 77,231 79,853 74,990 75,510 77,000 1,490 1.97% 3630 Training - - - 200 200 - 0.00% 5150 Repairs, utilities - - - - - 0.00% Total contractual services 92,421 92,160 98,981 107,240 114,430 7,190 6.70% Total water production 111,388 118,376 130,298 143,090 149,908 6,818 4.76% Total expenditures 1,050,363 1,081,712 1,189,805 1,792,525 2,564,054 871,529 48.62% Revenues over (under) expenditures (80,947) (158,223) (228,342) (860,276) (1,402,252) (641,976) 74.62% Add back: capital outlays - - - 531,700 1,241,200 709,500 133.44% principal payment on debt 185,000 190,000 200,000 205,000 210,000 5,000 2.44% Change in net assets 104,053 31,777 (28,342) (123,576) 48,948 172,524 -139.61% Net Assets, beginning year 4,467,969 4,572,022 4,603,799 4,575,457 4,451,881 (123,576) -2.70% Net Assets, end of year 4,572,022$ 4,603,799$ 4,575,457$ 4,451,881$ 4,500,829$ 48,948$ 1.10% 92 Fund: 700 Department: 4825 Water Production Account Description 2008 2009 2010 2011 Description 1600 Supplies, operating 550 550 550 550 Computer supplies 800 800 800 800 Testing reagents 3,600 3,600 3,950 3,950 Sulfur dioxide: 25 150# cylinders @ $1.05 per pound 9,000 9,000 8,000 8,000 Chlorine: 8 - 1 ton cylinders @ .50 per pound 8,500 8,500 8,438 8,438 75 - 150 # cylinders @ $.75 6,200 6,200 6,600 6,600 Hydrofluosilic acid: 20,000 pounds @ $0.33 - - 3,190 3,190 R-999 Buffer solution 2 - 55 gal drums @ 29 per gal. - - - 850 Sand seperater 400 400 400 400 Water conservation program implementation 29,050 29,050 31,928 32,778 1700 Motor fuels & lubs 100 330 330 - Motor oil for well # 2 - 55 gallons $6 gal. 150 150 150 200 Turbine & electric motor oil 225 192 192 250 Oil for generators 1,000 1,000 1,000 - Propane for well #2: 500 gallons @ $2.00 1,860 2,550 2,250 2,250 Diesel fuel for primary generator: 600 gallons @ $3.75 3,335 4,222 3,922 2,700 3030 Other professional services - - - - Arsenal contaminant tests 1,000 1,000 960 960 Bacteria tests 800 800 800 800 Computer maintenance 9,000 9,000 9,000 9,000 Consumer confidence report 6,200 6,470 6,800 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 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 13,500 - - - Wide spectrum water testing for wells - 50,000 - - Filter sand replenishment - 25,000 - - solenoid and valvel repairs - - 150 150 MNDPS - EPCRA program ($25/well) - 25,000 10,000 15,000 Well head protection plan (req. by Dept. of Health)(30kl/3yr 09-11) 36,320 123,090 31,530 37,230 3210 Electricity 60,505 72,606 75,510 77,000 Electricity for wells, tower & reservoir 60,505 72,606 75,510 77,000 3630 Training 200 200 200 200 General training 200 200 200 200 129,410 229,168 143,090 149,908 93 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Sanitary Sewer (Fund 730): Revenues 3551 Spec. Assessments - - 2,125 - 0.00% 3610 Investment income 187,916 149,549 77,662 72,500 60,000 (12,500) -17.24% 3680 Other revenues 279 364 - - - - 0.00% 3716 Penalties (96) 12,494 11,019 - - - 0.00% 3720 Utility sales 1,038,773 1,101,413 1,138,858 1,138,145 1,209,106 70,961 6.23% 3721 SAC charges (3,251) 7,405 (15,480) 4,000 4,000 - 0.00% 3722 Unit charges - - - - 0.00% 3725 Utility connections 300 300 180 300 300 - 0.00% 3728 Contractual wastewater service 30,391 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 - 0.00% Total revenue 1,254,312 1,285,541 1,256,913 1,544,945 1,603,406 58,461 3.78% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 29,950 30,751 33,262 33,551 33,058 (493) -1.47% 0110 Salaries, overtime 96 159 68 - - - 0.00% 0150 Salaries, part-time - - - - - - 0.00% 0300 Social security 2,122 2,331 2,364 2,567 2,529 (38) -1.48% 0321 PERA 1,894 1,901 2,200 2,349 2,396 47 2.00% 0400 Group insurance 2,284 2,400 2,812 4,285 4,387 102 2.38% 0500 Workers compensation 184 138 168 197 222 25 12.69% 0990 Severance - - - - 0.00% Total personnel services 36,530 37,680 40,874 42,949 42,592 (357) -0.83% Materials & supplies 1600 Supplies, operating 9 - - 50 50 - 0.00% Total materials & supplies 9 - - 50 50 - 0.00% Contractual services 3030 Other professional services 5,118 6,195 6,334 7,235 7,440 205 2.83% 3300 Postage 3,020 2,974 2,710 3,190 3,256 66 2.07% 3430 Printing 933 1,093 680 900 900 - 0.00% 3630 Training - - - 250 250 - 0.00% 5130 Repairs, equipment 2,487 2,589 3,128 3,174 3,332 158 4.98% Total contractual services 11,558 12,851 12,852 14,749 15,178 429 2.91% Miscellaneous: 9900 Transfers out to General Fund 44,688 46,030 47,411 48,833 50,298 1,465 3.00% 9900 Transfers out to Street Fund - 60,000 150,000 - - - 0.00% 9900 Transfers out to Vehicle Fund 36,000 36,000 36,000 36,000 36,000 - 0.00% Total miscellaneous 80,688 142,030 233,411 84,833 86,298 1,465 1.73% Total Billing 128,785 192,561 287,137 142,581 144,118 1,537 1.08% Infrastructure & Equip Maintenance (4823): Personnel services 100 Salaries, regular 155,003 139,887 148,658 159,920 162,168 2,248 1.41% 110 Salaries, overtime 2,010 1,345 5,215 7,221 7,221 - 0.00% 150 Salaries, part-time - 1,060 7,511 11,100 11,100 - 0.00% 300 Social security 10,926 10,774 11,580 13,635 13,807 172 1.26% 321 PERA 9,608 8,192 10,655 11,972 12,563 591 4.94% 400 Group insurance 19,357 16,323 19,268 26,938 27,406 468 1.74% 500 Workers compensation 3,615 3,813 4,552 5,228 5,554 326 6.24% 600 Unemployment - - - - - - 0.00% 990 Severence - - - - - - 0.00% Total personnel services 200,519 181,394 207,439 236,014 239,819 3,805 1.61% 94 Fund: 730 Department: 4820 Billing Services Account Description 2008 2009 2010 2011 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 800 800 800 825 Inserting & mailing bills 6,165 6,300 6,435 6,615 22.5% of audit fee 6,965 7,100 7,235 7,440 3300 Postage 349 357 374 440 Late notices: 500 bills X $0.44 postage X 4 billings X 1/2 cost 2,624 2,688 2,816 2,816 3200 bills X $0.44 postage X 4 billings X 1/2 cost 2,973 3,045 3,190 3,256 3430 Printing 350 450 450 450 Envelopes 350 450 450 450 Utility bills (1/2 cost) 700 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,678 2,717 2,885 3,029 Incode software support (30%) - - 289 303 Handheld interface support for new meter readers (50% water 50% sewer) 2,678 2,717 3,174 3,332 9900 Transfers out 46,030 47,411 48,833 50,298 Transfer to General Fund for admin costs 36,000 36,000 36,000 36,000 Transfer to Vehicle & Equipment Fund for vehicle use 82,030 83,411 84,833 86,298 95,646 97,473 99,632 101,526 95 2011 Budget Summary 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Sanitary Sewer (Fund 730): Materials & supplies 1210 Supplies, bldg & grnds 106 155 90 700 200 (500) -71.43% 1220 Supplies, vehicles 1,295 2,180 1,756 1,275 1,275 - 0.00% 1230 Supplies, equipment 1,183 290 3,243 2,800 3,250 450 16.07% 1240 Supplies, streets 1,395 36 - 1,350 850 (500) -37.04% 1250 Supplies, utilities 4,136 1,344 1,065 1,950 1,950 - 0.00% 1260 Supplies, traffic control - - - 300 300 - 0.00% 1600 Supplies, operating 2,212 2,991 1,806 3,650 4,300 650 17.81% 1700 Motor fuels 7,373 4,109 4,859 7,150 7,150 - 0.00% 2400 Uniforms 1,325 887 1,175 1,438 1,438 - 0.00% 2410 Mats & towels 758 1,134 1,427 800 800 - 0.00% Total materials & supplies 19,783 13,126 15,421 21,413 21,513 100 0.47% Contractual services 3030 Other professional services 511 136 1,452 12,750 7,750 (5,000) -39.22% 3030 Medtronic utility extension - 1,965 - - - - 0.00% 3100 Communications - telephone 4,951 2,894 1,214 1,330 1,430 100 7.52% 3200 Water & sewer 2,221 2,456 2,911 1,200 1,200 - 0.00% 3210 Electricity 1,512 1,866 2,072 1,888 2,100 212 11.23% 3230 Wastewater disposal - Met Council 637,078 696,031 733,120 776,845 776,066 (779) -0.10% 3610 Memberships 141 - 63 178 230 52 29.21% 3630 Training 1,535 1,530 513 3,230 3,105 (125) -3.87% 4010 Equipment rental - - - 1,000 1,000 - 0.00% 4800 Insurance 8,090 10,381 6,163 7,246 7,300 54 0.75% 5130 Repairs, equipment 12,215 9,987 20,222 11,300 8,850 (2,450) -21.68% 5150 Repairs, utilities 4 - - 500 1,000 500 100.00% 5155 Utility service repairs 1,436 - - 4,500 4,500 - 0.00% 5160 Repairs, maintenance 18,563 52,416 14,674 192,500 140,000 (52,500) -27.27% Total contractual services 688,257 779,662 782,404 1,014,467 954,531 (59,936) -5.91% Capital outlays 7030 Equipment - - - 335,000 337,500 2,500 0.75% 7050 Construction - - - - - - 0.00% 7950 Depreciation 153,063 153,931 157,989 165,000 160,000 (5,000) -3.03% Total capital outlays 153,063 153,931 157,989 500,000 497,500 (2,500) -0.50% Miscellaneous: 9100 Contingency - - - 15,000 15,000 - 0.00% 9900 Transfer to Street fund - - - 160,000 160,000 - 0.00% Total miscellaneous - - - 175,000 175,000 - 0.00% Total infrastructure & equip maint 1,061,622 1,128,113 1,163,253 1,946,894 1,888,363 (58,531) -3.01% Total expenditures 1,190,407 1,320,674 1,450,390 2,089,475 2,032,481 (56,994) -2.73% Revenues over (under) expenditures 63,905 (35,133) (193,477) (544,530) (429,075) 115,455 -21.20% Add back: capital outlays - - - 335,000 337,500 2,500 0.75% Change in net assets 63,905 (35,133) (193,477) (209,530) (91,575) 117,955 -56.30% Net Assets, beginning of year 5,685,272 5,749,177 5,714,044 5,520,567 5,311,037 (209,530) -3.80% Net Asset, end of year 5,749,177$ 5,714,044$ 5,520,567$ 5,311,037$ 5,219,462$ 26,380$ 0.50% 96 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance Account Description 2008 2009 2010 2011 Description 1210 Supplies, bldgs & grounds 200 200 200 100 Paint, bulbs, fuses, etc 500 500 500 100 Seed, dirt, sod, etc 700 700 700 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 300 Tires & batteries 1,275 1,275 1,275 1,275 1230 Supplies, equipment 650 650 650 650 Tune up parts 500 500 500 500 Hydraulic fluids & hoses 550 550 550 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 200 1,000 Camera track and parts 300 300 300 300 Minor repairs 2,800 2,800 2,800 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 500 - Gate @ Co. Rd. H2 & West City Limits (move to 2009) 1,350 1,350 1,350 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 375 750 750 Manhole covers, adjust rings & bolts 1,575 1,575 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 650 500 Additional & replacement hand tools 100 100 100 250 Glove & paper products 150 150 150 150 Disinfectant supplies 500 500 500 500 Camera supplies 150 150 150 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 Replacement for sewer gas monitors 4,250 4,250 3,650 4,300 1700 Motor fuels & lubs 300 300 300 300 Fluids 700 600 600 600 Motor oil - 100 gallons $6 gal. 3,000 3,750 3,250 3,250 Unleaded fuel 1,000 gallons @ $3.25 2,480 3,400 3,000 3,000 Diesel fuel 800 gallons @ $3.75 6,480 8,050 7,150 7,150 2400 Uniforms 1,380 1,438 1,438 1,438 Uniforms 1.15 FTE @ $1250 (inlcudes jackets/boots per contract) 1,380 1,438 1,438 1,438 2410 Mats & towels 800 800 800 800 Share of floor mats & shop towels 800 800 800 800 3030 Other professional services 1,844 1,844 2,750 2,750 Gopher State One Call locates 750 750 - - Consulting engineering services 2,300 - 10,000 5,000 Arcview/GIS base map consulting 4,894 2,594 12,750 7,750 3100 Communications - telephone 50 50 50 50 Service & repair 80 80 80 80 On call pager (half water / half sewer) 1,200 1,200 1,200 1,200 Cellular phone service - - - 100 800 Mhz radio license fee (20%) 1,330 1,330 1,330 1,430 3200 Water & Sewer service 1,200 1,200 1,200 1,200 Estimated annual charge 1,200 1,200 1,200 1,200 3210 Electricity 1,648 1,815 1,888 2,100 Electricity for lift stations 1,648 1,815 1,888 2,100 29,982 29,477 38,581 33,993 97 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance (continued) Account Description 2008 2009 2010 2011 Description 3230 Metro Waste Commission 696,031 733,120 776,845 776,066 Estimated annual charge 696,031 733,120 776,845 776,066 3610 Memberships 200 200 113 - APWA 1/4 membership - - - 100 MN Rural Water Assoc. (50%) - - - 50 SUSA (50%) 65 65 65 80 MN Safety Council (20%) 265 265 178 230 3630 Training 600 600 600 600 Collection operators seminar 560 560 560 560 Tuition reimbursement (PW Mgt. Class - North Hennepin CC) 250 250 250 250 Computer training 120 120 120 120 Hearing test 50 50 50 50 License renewal 200 200 200 200 Confined space seminar 150 150 150 150 Trench safety seminar 450 450 450 450 Wastewater collection operators recertification seminar 235 235 235 235 Low voltage license 320 320 320 320 Metro school 110 110 110 110 Pesticide applicators license - - 125 - APWA MN conference 60 60 60 60 Work zone safety seminar 3,105 3,105 3,230 3,105 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,246 7,300 Share of property/liability insurance 7,246 7,246 7,246 7,300 5130 Repairs, equipment 100 100 100 100 Fire extinguisher recharge / repair 2,000 500 500 - Groveland Lift Station repair 200 200 200 2,500 Repairs to motors & pumps 3,800 3,800 10,000 2,500 Repairs to Vactor (jet truck) - - - 2,500 Repairs to camera van and camera equipment - - - 1,000 Repairs to utility truck 250 250 250 250 Misc repairs 250 250 250 - Copy machine/fax machine repairs 6,600 5,100 11,300 8,850 5150 Repairs, utilities 500 500 500 - Repairs to RTUs - - - 1,000 Lift station repairs 500 500 500 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 50,000 15,000 Sewer main & manhole rehabilitation 15,000 15,000 15,000 25,000 Root control 1,500 - 27,500 - Groveland lift station wet well rehabilitation 200,000 75,000 100,000 100,000 Sewer pipe relining program 266,500 140,000 192,500 140,000 7030 Capital, equipment - 330,000 330,000 300,000 Vactor (includes auto chassis lube) - - 5,000 5,000 GPS Locating Equipment (carryover from 2010) 40,000 10,000 - 30,000 Generator - trailer mounted 2,450 - - - Magnetic manhole cover lifter (split with storm water fund) - - - 2,500 Vehicle Cameras (3) 42,450 340,000 335,000 337,500 7050 Construction 60,000 150,000 - - Sewer system upgrades in conjunction with major roadway program 25,000 - - - Groveland lift station wet well relining 15,000 - - - Groveland lift station pump replacement 100,000 150,000 - - 7950 Depreciation 175,000 165,000 165,000 160,000 Estimated depreciation 175,000 165,000 165,000 160,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 Sewer system upgrades in conjunction with major roadway program - - 160,000 160,000 1,318,197 1,564,836 1,672,299 1,614,551 98 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Street Lighting (Fund 240): Revenues 3610 Investment income 7,399 6,222 3,318 2,000 2,000 - 0.00% 3716 Penalties (167) 902 688 - - - 0.00% 3740 Street lighting charges 75,786 76,963 76,520 74,000 74,000 - 0.00% Total revenue 83,018 84,087 80,526 76,000 76,000 - 0.00% Operating expenses Operations (4416) Personnel services 0100 Salaries, regular 2,475 2,670 2,753 2,718 2,638 (80) -2.94% 0110 Salaries, overtime - - 18 - - - 0.00% 0300 Social security 160 192 185 208 202 (6) -2.88% 0321 PERA 165 166 183 190 191 1 0.53% 0400 Group insurance 439 433 499 499 505 6 1.20% 0500 Workers compensation 15 13 15 18 19 1 5.56% 0990 Severence pay - - - - 0.00% Total personnel services 3,254 3,474 3,653 3,633 3,555 (78) -2.15% Contractual services 3030 Other professional services - - 0.00% 3210 Electricity 63,207 66,125 71,816 68,700 72,000 3,300 4.80% 4800 Insurance 775 737 765 900 900 - 0.00% 5150 Repairs, utilities - - 3,464 - - - 0.00% Total contractual services 63,982 66,862 76,045 69,600 72,900 3,300 4.74% Other 9900 Transfer to General Fund 2,000 2,060 2,122 2,186 2,252 66 3.02% Total other 2,000 2,060 2,122 2,186 2,252 66 3.02% 0.00% Total expenditures 69,236 72,396 81,820 75,419 78,707 3,288 4.36% Revenues over (under) expenditures 13,782 11,691 (1,294) 581 (2,707) (3,288) -565.92% 0.00% Add back: Capital outlays - - - - - - 0.00% Change in net assets 13,782 11,691 (1,294) 581 (2,707) (3,288) -565.92% Net assets, beginning year 133,761 147,543 159,234 157,940 158,521 581 0.37% 0.00% Net assets, end of year 147,543$ 159,234$ 157,940$ 158,521$ 155,814$ (2,707)$ -1.71% 2011 Budget Summary 99 Fund: 240 Street Lighting Fund Revenues Account Description 2008 2009 2010 2011 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 72,000 74,000 74,000 Estimated utility charges for street lighting. 72,000 72,000 74,000 74,000 Fund: 240 Department: 4416 Operations 3210 Electricity 56,000 65,000 68,770 72,000 Estimate 56,000 65,000 68,770 72,000 4800 Insurance 900 900 900 900 Share of property/liability insurance 900 900 900 900 5150 Repairs, utilities - - - - Repairs to street lighting. - - - - 9900 Transfer out 2,060 2,122 2,186 2,252 Transfer to General Fund for administrative overhead costs 2,060 2,122 2,186 2,252 100 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent Storm Water (Fund 245): Revenues 3262 Grading permit - - - - - - 0.00% 3610 Investment income 67,448 57,985 33,177 25,000 22,000 (3,000) -12.00% 3680 Other revenues - - - - - - 0.00% 3716 Penalties & interest (542) 2,254 1,958 - - - 0.00% 3730 Surface water charges 208,953 222,137 241,384 250,718 250,718 - 0.00% 3972 Transfer from other funds - - - 40,000 40,000 - 0.00% Total revenue 275,859 282,376 276,519 315,718 312,718 (3,000) -0.95% Operating expenses System Maintenance (4415): Personnel services 0100 Salaries, regular 48,304 54,235 49,958 47,562 47,562 - 0.00% 0110 Salaries, overtime 1,067 123 1,293 1,083 1,083 - 0.00% 0150 Salaries, part-time 4,448 4,792 6,263 4,920 4,920 - 0.00% 0300 Social security 4,036 4,534 4,329 4,097 4,097 - 0.00% 0321 PERA 3,302 3,265 3,428 3,405 3,527 122 3.58% 0400 Group insurance 4,611 4,759 5,907 7,570 7,798 228 3.01% 0500 Workers compensation 2,676 2,852 3,266 3,891 3,893 2 0.05% 0990 Severence pay - - - - - - 0.00% Total personnel services 68,444 74,560 74,444 72,528 72,880 352 0.49% Materials & supplies 1230 Supplies, equipment 132 1,695 81 1,500 2,000 500 33.33% 1240 Supplies, streets 432 - - 600 600 - 0.00% 1600 Supplies, operating 412 1,345 167 2,500 2,200 (300) -12.00% 1700 Motor fuels 1,016 3,720 2,388 2,250 2,750 500 22.22% 2100 Books/Periodicals - - - 150 100 (50) -33.33% 2400 Uniforms 966 420 723 1,188 1,188 - 0.00% 2410 Mats & towels 758 1,137 1,427 800 800 - 0.00% Total materials & supplies 3,716 8,317 4,786 8,988 9,638 650 7.23% Contractual services 3030 Other professional services 9,888 15,032 12,698 21,600 17,500 (4,100) -18.98% 3100 Telephone 2,110 1,379 1,143 1,200 1,250 50 4.17% 3610 Memberships 831 690 753 868 750 (118) -13.59% 3630 Training 459 324 365 1,700 3,410 1,710 100.59% 4800 Insurance 1,627 1,556 1,616 1,900 1,900 - 0.00% 5150 Repairs, utilities 3,398 50,474 7,147 60,000 50,000 (10,000) -16.67% Total contractual services 18,313 69,455 23,722 87,268 74,810 (12,458) -14.28% Capital outlays 7050 Construction - - - 48,000 - (48,000) -100.00% 7950 Depreciation 34,337 31,878 31,878 35,000 32,000 (3,000) -8.57% Total capital outlays 34,337 31,878 31,878 83,000 32,000 (51,000) -61.45% Miscellaneous: 9900 Transfer out - - 30,000 40,000 40,000 - 0.00% Total miscellaneous - - 30,000 40,000 40,000 - 0.00% Total System Maintenance 124,810 184,210 164,830 291,784 229,328 (62,456) -21.40% 0.00% 2011 Budget Summary 101 Fund: 245 Storm Water Revenues Account Description 2008 2009 2010 2011 Description 3610 Interest revenue 34,000 34,000 25,000 22,000 Estimated interest earnings at 2.00%. 34,000 34,000 25,000 22,000 3730 Utility sales 202,662 225,669 250,718 250,718 Estimated surface water charges. 202,662 225,669 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: 245 Department: 4415 System Maintenance 1230 Supplies, equipment 400 200 500 500 Miscellaneous equipment (laser level) 1,000 1,000 1,000 1,500 Hoses & nozzles 1,400 1,200 1,500 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 Rain Garden mix, riprap, topsoil, seed and sod 1,200 1,200 1,200 200 Concrete adjustment rings 200 200 200 200 CD's, DVD's, software upgrade for camera van 800 800 800 500 Catch basin castings 2,500 2,500 2,500 2,200 1700 Motor fuels 1,860 2,550 2,250 1,125 300 gallons diesel fuel @ $3.75 / gallon for Vactor - - - 1,625 500 gallons unleaded @ $3.25 for utility truck 1,860 2,550 2,250 2,750 2100 Books/Periodicals 500 500 150 100 Storm water books/periodicals 500 500 150 100 2400 Uniforms 1,140 1,188 1,188 1,188 Uniforms 0.95 FTE @ $1,250 (inlcudes jackets/boots per contract) 1,140 1,188 1,188 1,188 2410 Mats & towels 800 800 800 800 Share of floor mats & shop towels 800 800 800 800 3030 Other professional services 1,600 1,600 1,600 - GIS data input 6,000 6,000 5,000 5,000 Consulting engineers - - 5,000 2,500 Arcview/GIS base map consulting - - 10,000 - FEMA Study - - - 10,000 Silverview pond sediment removal study 7,000 - - - Map development and plan updates & reviews 5,000 - - - Rain Garden program 19,600 7,600 21,600 17,500 3100 Communications 1,200 1,200 1,200 1,200 Cell Phone - - - 50 800 Mhz radio license fee (10%) 1,200 1,200 1,200 1,250 3610 Memberships 85 85 - - CPV Program - - 113 - APWA/MN 690 690 690 710 Minnesota Cities Storm Water Coalition 65 65 65 40 MN Safety Council (10%) 840 840 868 750 3630 Training 200 200 200 200 Seminars & training sessions - - - 60 Hearing test - - - 800 Wastewater class/exam - - - 350 Safety training - - - 750 NPDES compliance training - - - 1,250 Tuition reimbursement 700 700 700 - Public Education Fund 150 150 150 - Trench safety seminar 150 150 150 - Competent person training 500 500 500 - Computer / Database training 1,700 1,700 1,700 3,410 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 70,000 50,000 25,000 Repair storm sewer and drainage issues throughout the city 10,000 10,000 10,000 25,000 Storm Sewer slip linning improvements 80,000 80,000 60,000 50,000 7030 Equipment - - - 4,000 Small generator for trailer - - - 5,000 Concrete mixer - - - 9,000 7050 Construction 230,000 - - - Spring Creek Regional Sedimantation Pond Project - 40,000 - - Storm water system upgrades in conjunction with major roadway program - - 48,000 Storm water projects, Subwatershed SC-1, SC-3, EW-4 - 315,000 - - Storm water projects, Subwatershed AA-2, AA-6, EW-4 230,000 355,000 48,000 - 7950 Depreciation 35,000 35,000 35,000 32,000 Estimated depreciation 35,000 35,000 35,000 32,000 9900 Transfer out - - 40,000 40,000 Storm water system upgrades in conjunction with major roadway program - - 40,000 40,000 379,040 492,578 219,256 156,448 102 2007 2008 2009 2010 2011 Change from 2010 Actual Actual Actual Budget Request Dollar Percent 2011 Budget Summary Storm Water (Fund 245): Street Sweeping (4417): Personnel services 0100 Salaries, regular 7,889 8,431 8,056 7,510 7,510 - 0.00% 0110 Salaries, overtime 34 - 292 1,083 1,083 - 0.00% 0150 Salaries, part-time - - - 240 240 - 0.00% 0300 Social security 543 662 610 676 676 - 0.00% 0321 PERA 527 531 577 602 623 21 3.49% 0400 Group insurance 1,054 1,061 1,278 1,195 1,231 36 3.01% 0500 Workers compensation 439 469 545 641 642 1 0.16% 0990 Severence pay - - - - - - 0.00% Total personnel services 10,486 11,154 11,358 11,947 12,005 58 0.49% Materials & supplies 1230 Supplies, equipment (4) 94 2,150 200 200 - 0.00% 1600 Supplies, operating 1,855 1,493 605 1,100 3,200 2,100 190.91% 1700 Motor fuels 2,317 - 2,389 2,400 3,150 750 31.25% 2400 Uniforms - - - 188 188 - 0.00% Total materials & supplies 4,168 1,587 5,144 3,888 6,738 2,850 73.30% Contractual services 3530 Disposal - - - 5,000 5,000 - 0.00% 3630 Training 829 - 40 725 530 (195) -26.90% 5130 Repairs, equipment - - - - 2,000 2,000 #DIV/0! Total contractual services 829 - 40 5,725 7,530 1,805 31.53% Capital outlays 7030 Equipment - - - 40,000 40,000 - 0.00% Total capital outlays - - - 40,000 40,000 - 0.00% 0.00% Miscellaneous:0.00% 9800 Loss on disposal of asset - - - - - - 0.00% 9900 Transfer out 6,000 16,000 16,000 16,000 16,000 - 0.00% Total miscellaneous 6,000 16,000 16,000 16,000 16,000 - 0.00% Total street sweeping 21,483 28,741 32,542 77,560 82,273 4,713 6.08% Total expenditures 146,293 212,951 197,372 369,344 311,601 (57,743) -15.63% Revenues over expenditures 129,566 69,425 79,147 (53,626) 1,117 54,743 -102.08% Add back: Capital outlays - - - 88,000 40,000 (48,000) -54.55% Change in net asssets 129,566 69,425 79,147 34,374 41,117 6,743 19.62% Net assets, beginning year 2,513,042 2,642,608 2,712,033 2,791,180 2,825,554 34,374 1.23% Net assets, end of year 2,642,608$ 2,712,033$ 2,791,180$ 2,825,554$ 2,866,671$ 41,117$ 1.46% 103 Fund: 245 Department: 4417 Street Cleaning 1230 Supplies, equipment 200 200 200 200 Misc. repairs - belts, pumps, hoses, filters, etc. 200 200 200 200 1600 Supplies, operating 1,000 1,000 1,000 2,000 Gutter brooms - - - 700 Belts, pumps, hoses, filters, etc... for sweeper - - - 100 Gloves, hearing protection, etc... 100 100 100 400 2 dirt shoes 1,100 1,100 1,100 3,200 1700 Motor fuels 1,860 2,550 2,250 3,000 Diesel fuel - 800 gallons @ $3.75/gallon 150 150 150 150 Oil - 4 changes 2,010 2,700 2,400 3,150 2400 Uniforms 180 188 188 188 Uniforms 0.15 FTE @ $1,250 (inlcudes jackets/boots per contract) 180 188 188 188 3530 Disposal - - 5,000 5,000 Dumping charges for sweeping disposals 2010 - - 5,000 5,000 3630 Training 150 150 125 - American Public Works Assoc. MN conference 150 150 - - Minnesota Public Works Assoc. conference - - - 500 NPDES compliance training - - - 30 Maintenance Expo 200 200 200 - MSSA operator training sessions. 200 200 200 - Sweeper operator seminar 200 200 200 - MCCA Membership 900 900 725 530 5130 Repairs, equipment - - - 2,000 Elgin sweeper repairs - - - 2,000 7030 Equipment 40,000 40,000 40,000 40,000 3/4 T 4X4 Truck (carryover from 2008) 2,450 - - - Magnetic manhole cover lifter (split with sewer fund) 42,450 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 62,840 61,088 65,613 68,268 104 Item No: 7.A Meeting Date: December 7, 2009 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 2011 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 General Fund has been modified to reflect the anticipated appointment of a new sergeant and the anticipated hire of a new patrol officer. The previous budget had the sergeant’s pay at the top step pending appointment and that will not be the step that the new sergeant will start at. The new patrol officer will also start at a lower salary than the officer he/she will replace. This will have a positive effect of about $35,000 on the budget. There will be additional savings when the Deputy Chief position is filled and the related staff movements are included. The General Fund was also adjusted to reflect the capital equipment purchases that were presented to the Council by the Public Works supervisor. Any capital item changes are off-set by a transfer-in from the Equipment Fund and thus have no impact on the General Fund balance. There were additional capital items added to the Community Center Fund and the Special Projects Fund for roof repairs as a result of the comprehensive roof evaluation from our consultant and replacement of banquet center chairs. Looking forward to the 2012/2013 state budget, projections show a 5 to 6 billion deficit already for that period. This will affect our state aid for 2011. The 2011 budget was constructed with no LGA included. Staff welcomes any comments or questions. Respectfully Submitted, Mark Beer City of Mounds View Truth in Taxation Public Hearing December 6, 2010 6:00 pm 1 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. 2 Expenditures by Purpose Personnel 63% Supplies 4% Contractual services 21% Contingency 0% Fire debt service 2%Capital outlays 6% Transfers 4% General Fund Expenditures by Type 2011 3 General Government 14% Economic Development 8% Public Safety 46% Streets & Highways 16%Park & Recreation 9% Debt service - Fire Bonds 2% Other 1% Transfers 4% General Fund Expenditures by Function 2011 Proposed Budget Expenditure Pie Chart 4 - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 General Government Economic Development Public Safety Streets & Highways Park & Recreation Debt service - Fire Bonds Other Transfers General Fund Expenditures 2009 Actual 2010 Budget 2011 Proposed Expenditure Bar Graph 5 General Fund Expenditure Changes 2011 General Fund operating expenditures will decrease by $163,988 or 3.16%,this includes personnel services, materials and supplies, contractual services, and contingency. 2011 General Fund capital expenditures, debt service and transfers will increase by $183,509 or 37.90%. Capital outlay is the primary driver of the increase. Total 2011 General Fund expenditures will in crease by $19,521 or .34% over 2010. 6 Revenue Pie Chart General property taxes 65%Other taxes 6% Licenses & permits 3% Intergovern- mental 6% Other revenues 6% Transfers from other funds 14% General Fund Revenues 2011 Proposed Budget 7 $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 2009 Actual 2010 Budget 2011 Proposed Revenue Bar Graph 8 Budget Summary 2011 General Fund significant budget items •The City reduced operational spending by $163,988, non-operational spending (debt service, capital outlay, transfers) increased by $183,509 for an overall increase of $19,521. •The State “Unalloted” Local Government Aid and MVHC over the last three years totaling $790,398 and is projecting further reductions in 2011. Estimated LGA in 2011 is $484,724, the City did not include this in the budget due to the large deficit at the state level. •Other non-property tax revenues are projected to decline $65,601, this will increase the pressure on the property tax. 9 Property Tax Levy Increases 2011 2010 Property taxes - base levy $3,402,792 $3,212,525 Special levy - Police Referendum 196,000 208,000 Special levy - PERA rate increase 39,145 34,704 Debt service levy - Fire bonds 93,885 154,606 Debt service levy - Street bonds 190,553 189,558 Capital Project Street Imp.$300,000 $300,000 Total Levy $4,222,375 $4,099,393 Increase 122,982$ 10 What Your Tax Dollars Buy for a Median Valued Home Median Valued Home in Mounds View 176,300$ City Tax on Median Valued Home 748.38$ Police 317.28 42.40% Public Works 105.70 14.12% Parks and Recreation 96.25 12.86% Community Development 52.08 6.96% Administration 46.75 6.25% Street Improvement levy 45.72 6.11% Debt service 42.76 5.71% Fire 41.85 5.59% 748.38$ 100.00% 11 Sample Home Tax Impact 2010 Home 2010 2011 Home 2011 Taxable City Taxable City Value Tax Value Tax Difference 119,921$ 491.29$ 113,484$ 481.73$ (9.56)$ 149,901 614.11 141,855 602.16 (11.95) 179,881 736.94 170,226 722.59 (14.35) 186,300 763.23 176,300 748.38 (14.85) 209,861 859.76 198,597 843.02 (16.74) 239,841 982.58 226,967 963.45 (19.13) Sample Home Tax Impact 12 City of Mounds View 28.28 cents Ramsey County 37.60 cents School District 30.16 cents Other taxing districts 3.96 cents Tax Bill Breakdown 13 Taxes Per Capita Arden Hills $304.72 Mounds View $316.22 New Brighton $331.33 Blaine $371.24Shoreview $365.30 Roseville $415.89 Fridley $433.86 Spring Lake Park $499.88 $0.00 $100.00 $200.00 $300.00 $400.00 $500.00 $600.00 1 14 Spending per Capita In the most recent data available from the Office of State Auditor, the City spending per capita ranked 208 out of 225 For cities over 2500 in population 15 Last Three 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 Market Value Homestead Credit $165,672 for 2008, withheld $ 82,836 $154,645 for 2009, withheld $ 0 $190,000 for 2010, withheld $160,156 Tax Levy Street levy in 2010 7.9% or $300,000 No levy increase in 2006, 2007, 2008, 2009 16 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. 17