Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Agenda Packets - 2010/10/04
CITY OF MOUNDS VIEW CITY COUNCIL WORK SESSION AGENDA MOUNDS VIEW CITY HALL Monday, October 4, 2010 7:00 p.m. ROLL CALL: Flaherty, Stigney, Hull, Mueller, Gunn PUBLIC COMMENT 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. Agenda Items Discussed by Consensus 1. Marre Jo Sager and Superintendent Dan Hoverman from the Mounds View School District 621 would like to speak to the City Council (Verbal Report -PowerPoint Presentation) 2. Meet Steve Markuson - Minnesota Metro North Tourism Director 3. All Funds 2011 Budget Review 4. Review Building Roof Management Proposal 5. Discuss Motor Replacement for Well No. 2 6. Public Works Vehicle & Equipment Replacement Schedule 7. Police Command Structure Next Work Session: Monday, November 1, 2010, at 7 p.m. Next City Council Meeting: Monday, October 11, 2010, at 7 p.m. Community Levy Meetings Fall 2010 A no -tax-increase request for renewal District facts •Mounds View Public Schools is a high-performing school district. •Residents of the District care deeply about the quality of their local schools. 2010 ACT scores Mounds View Public Schools: 25 Minnesota average: 22.9 National average: 21 National recognition Irondale and Mounds View among Top 5 percent in nation. District students perform 1 to 3 grade levels above national norms on standardized tests. Standardized testing Spring community survey •83%: Quality of education is excellent/good. •85%: Receive good value from investment. •80%: Proud/would recommend schools to others. Source: Decisions Resources, spring 2010 Expiring levy 2003: $6 million 5% of total operating budget Per-pupil spending declining Spending rank declining Spring community survey 87%: Budget problems are likely to get worse in the next few years. Source: Decisions Resources, spring 2010 Reductions since 2003 •Closed two schools. •Cut teachers. •Cut staff positions. Generated savings •Refunded long- term debt for interest savings of $4.5 million. •Saved $800,000 in energy expenses. User fees since 2003 •Facility rentals •Bus fees •Co-curriculars Containing costs •Budget reductions. •Keeping admin costs down. •Settling contracts in mid-market. Targeting spending Administrative costs1.Bloomington $4922.Burnsville $4693.Wayzata $4474.Lakeville $4025.South Washington $3966.White Bear Lake $3957.N. St. Paul $3868.Eden Prairie $3559.Robbinsdale $34810.Mounds View $34711.Edina $335 Investing in students 1.Burnsville $7,7572.Mounds View $7,6763.Edina $7,5754.Eden Prairie $7,4105.Bloomington $7,2836.Robbinsdale $7,1847.N. St. Paul $7,0908.Wayzata $7,0219.So. Washington $6,97110.White Bear Lake $6,95511.Lakeville $6,553 Spring community survey 7 out of 10: Mounds View is efficient. 8 out of 10: Mounds View is effective. Source: Decisions Resources, spring 2010 •2003 levy will expire in 2011. •Schools will stop receiving about $6 million a year. Funding facts Recent discussions Recent decision Impact on residents 2003: •$76 for every $100,000 of taxable market value annually. 2010: •$70 for every $100,000 of taxable market value annually. Levies across the state Levies across the metro 2010 requests: 1.Brooklyn Center Increase 2.Forest Lake Increase 3.Lakeville Increase 4.Rosemt./Eagan/AV Increase 5.West St. Paul Increase 6.Mounds View No increase Impact on students A successful levy will maintain. Class sizes Programs Impact on students A successful levy: •Does not provide “extras.” •Will not prevent future reductions as funding conditions are unpredictable. Impact on students An unsuccessful levy: •Brings loss of $6 million annually. •Brings increase to class sizes, reductions in programs. Levy renewal request No more. No less. Maintain. Find the facts •Ask questions tonight. •Visit www.moundsviewschools.org •Watch your mail. Item No: 3 Meeting Date: October 4, 2009 Type of Business: Work Session Administrator Review: _____ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Mark Beer, Finance Director Item Title/Subject: All Funds Budgets for 2011 Attached are 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 the General Fund. The Special Revenue, Debt Service, Capital Projects, and Enterprise funds have not been reviewed. Last year staff split up the various budgets and we tackled them on two different dates. Since Council wants to have a meeting dedicated to just budget discussions staff is providing all City budgets in advance of the meeting on October 18th at 6:30 pm in the conference room. Enterprise Funds The City continues to have low utility rates based on rate studies the City participates in and staff has shared with the City Council. Staff advocates a policy of nominal increases to maintain the infrastructure rather than larger increases with greater intervals between increases. The Water fund anticipates an increase in base user charges by a dime which will add about $8 per year for the average home. The increase is based on significant costs associated with the planned maintenance of the water tower in 2011 and a number of capital related items from the five year financial plan. The five year plan projects the need for nickel increases in the base rates for the years 2012 thru 2014. The Sewer fund anticipates a 6% increase in user charges which will add $14 to a residential utility bill. Met Council Environmental Services (MCES) waste charges have increased significantly over the last three years (20.54%) and we have not kept pace with the increases, future increases of 6% for 2012 thru 2015 will help stabilize the sewer fund. The MCES rate increase is flat for 2011. The Storm Water fund and the Street Light funds do not require increases in 2011. The Storm Water fund does not anticipate a rate increase for 2012 thru 2015. The City will be exploring the possibility of slip lining some of the storm sewers to extend their lives in the coming years and that could impact future rates. The Street Light Fund anticipates a $.25 per quarter increase in 2013 to offset higher electrical and trailway lighting and maintenance costs. Capital Projects Funds There are a number of capital projects that are anticipated to occur in 2011, the most prominent are the street project for Area D, Lambert Park Building, roof repairs for numerous buildings, generator for the lift stations and permanent City Hall generator, and possibly Mustang Drive. Special Revenue Funds Most of the special revenue funds are small and the budgets are driven by the specific revenues received. The most note worthy are the Cable, Forfeiture, EDA, Community Center, Levy Reduction, TIF 1, 2, 3, and the Equipment Special Revenue Funds as they have the most significant activity. Staff would recommend that Council review the funds that have not been reviewed first and then if there are areas of the General Fund that the Council would like to reconsider then that could be done at the end or when the budget worksession is held on the 18th. Respectfully Submitted, Mark Beer, Finance Director City of Mounds View 2011 Budget Summary Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 General Fund:Actual Actual Actual Budget Actual Request Dollar Percent Revenues: Property taxes - Base levy 3,319,587 3,253,546 3,105,868 3,212,525 1,689,471 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 135,179 249,900 (37,100) -12.93% Other taxes 65,431 157,410 102,284 45,000 46,693 45,000 - 0.00% Hotel/motel tax 52,615 51,263 43,835 51,000 33,934 45,000 (6,000) -11.76% Licenses and permits 212,041 193,930 175,816 180,270 106,285 178,560 (1,710) -0.95% Intergovernmental 348,800 380,602 816,717 557,807 288,355 321,171 (236,636) -42.42% Charges for services 18,576 11,459 23,302 22,190 26,383 16,565 (5,625) -25.35% Fines & forfeitures 41,833 38,617 29,819 40,800 17,799 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 133,129 174,844 88,188 101.77% 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 - 207,394 141,794 216.15% Total revenues 5,438,411 5,628,431 5,560,903 5,507,225 2,477,228 5,563,611 56,386 1.02% Expenditures: Legislative Services: City Council 51,470 49,409 44,343 49,974 32,425 49,767 (207) -0.41% Advisory Commissions 16,018 22,245 9,575 11,900 6,545 11,150 (750) -6.30% Subtotal 67,488 71,654 53,918 61,874 38,970 60,917 (957) -1.55% Administrative Services: City Administrator 177,895 181,283 214,640 217,232 146,199 222,354 5,122 2.36% Elections 14,409 32,051 11,851 38,210 22,901 10,308 (27,902) -73.02% Finance 221,996 232,688 238,674 249,270 173,623 247,642 (1,628) -0.65% Central Services 260,206 242,641 193,815 238,082 137,861 236,923 (1,159) -0.49% Subtotal 674,506 688,663 658,980 742,794 480,584 717,227 (25,567) -3.44% Community Development 469,777 459,520 439,112 486,119 311,107 462,326 (23,793) -4.89% Police 2,086,448 2,235,909 2,276,827 2,320,232 1,595,757 2,338,454 18,222 0.79% Fire 283,732 292,697 318,765 329,202 328,202 297,467 (31,735) -9.64% Public Works Administration 96,759 113,957 106,794 120,436 77,758 123,370 2,934 2.44% Parks, Recreation & Forestry: Recreation 122,566 136,343 108,647 125,600 55,855 109,600 (16,000) -12.74% Parks 308,718 316,080 310,388 306,586 218,821 321,766 15,180 4.95% Forestry 62,945 49,675 50,496 61,450 13,115 56,450 (5,000) -8.14% Subtotal 494,229 502,098 469,531 493,636 287,791 487,816 (5,820) -1.18% Fleet Services: Building & Grounds Mtnce 122,568 138,150 132,439 136,185 81,371 240,178 103,993 76.36% Vehicle & Equipment Mtnce 81,510 92,739 84,828 84,738 61,140 86,259 1,521 1.79% Subtotal 204,078 230,889 217,267 220,923 142,511 326,437 105,514 47.76% Streets: Pavement Management 185,174 204,005 211,452 191,215 143,553 189,405 (1,810) -0.95% Snow & Ice Control 122,264 130,272 121,874 128,811 90,271 122,712 (6,099) -4.73% Sign Maintenance 34,621 37,262 35,321 36,696 23,097 36,594 (102) -0.28% Subtotal 342,059 371,539 368,647 356,722 256,921 348,711 (8,011) -2.25% Other Convention & Visitor's Bureau 50,071 48,715 40,171 48,450 32,237 42,750 (5,700) -11.76% Social Service Coordination 17,927 18,375 18,926 18,926 18,661 18,661 (265) -1.40% Miscellaneous/contingency 4,069 5,400 6,263 106,500 2,337 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 73,598 89,662 (57,533) -39.09% Subtotal 625,791 573,116 549,643 546,071 126,833 402,573 (143,498) -26.28% Total expenditures 5,344,867 5,540,042 5,459,484 5,678,009 3,646,434 5,565,298 (112,711) -1.99% Net change in fund balance 93,544 88,389 101,419 (170,784) (1,169,206) (1,687) 169,097 Beginning Fund Balance 2,473,163 2,566,707 2,655,097 2,756,516 2,756,516 2,585,732 Ending Fund Balance 2,566,707 2,655,097 2,756,516 2,585,732 1,587,310 2,584,045 169,097 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,105$ 230,204$ -$ 438,611$ 2,006,062$ -$ 199,678$ 423,021$ 6,500$ 3,564,029$ 3,583,509$ (19,480)$ -0.54% Materials & supplies 1,900 685 700 20,375 1,660 70,490 - 43,015 114,514 - 253,339 271,764 (18,425) -6.78% Contractual services 26,169 4,872 16,738 193,548 22,055 231,702 274,573 218,823 155,983 61,411 1,205,874 1,238,489 (32,615) -2.63% Contingency - - - - - - - - - - - 100,000 (100,000) -100.00% Current total 60,917 232,662 247,642 213,923 462,326 2,308,254 274,573 461,516 693,518 67,911 5,023,242 5,193,762 (170,520) -3.28% 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 26,300 105,000 - 207,394 112,052 95,342 85.09% Transfers to other funds - - - - - - - - - 245,000 245,000 225,000 20,000 8.89% Other total - - - 23,000 - 30,200 22,894 26,300 105,000 334,662 542,056 484,247 57,809 11.94% Department Total 60,917$ 232,662$ 247,642$ 236,923$ 462,326$ 2,338,454$ 297,467$ 487,816$ 798,518$ 402,573$ 5,565,298$ 5,678,009$ (112,711)$ -1.99% 2 City of Mounds View 2011 Budget Summary Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 General Fund:Actual Actual Actual Budget Actual 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 3,045 23,000 (996) -3.98% Finance - - - - - - - 0.00% Subtotal 23,996 24,651 6,617 25,000 3,045 23,000 (996) -3.98% Community Development - - 1,066 - - - - 0.00% Police 54,533 89,804 36,239 40,600 4,576 30,200 (24,333) -59.93% Fire 32,613 13,048 35,789 46,452 49,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 - - - 26,300 14,276 0.00% Forestry - - - - - - - 0.00% Subtotal 12,024 5,845 - - - 26,300 14,276 0.00% Fleet Services: Building & Grounds Mtnce - - - - - 105,000 105,000 0.00% Vehicle & Equipment Mtnce - - - - - - - 0.00% Subtotal - - - - - 105,000 105,000 0.00% Streets: Pavement Management 22,754 2,002 - - - - (22,754) 0.00% Snow & Ice Control 2,705 6,001 949 - - - (2,705) 0.00% Sign Maintenance - - - - - - - 0.00% Subtotal 25,459 8,003 949 - - - (25,459) 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 57,073 207,394 56,978 50.85% 3 City of Mounds View 2011 Budget Summary Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 General Fund:Actual Actual Actual Budget Actual Request Dollar Percent Operating Expenditures: Legislative Services: City Council 51,470 49,409 44,343 49,974 32,425 49,767 (207) -0.41% Advisory Commissions 16,018 22,245 9,575 11,900 6,545 11,150 (750) -6.30% Subtotal 67,488 71,654 53,918 61,874 38,970 60,917 (957) -1.55% Administrative Services: City Administrator 177,895 181,283 214,640 217,232 146,199 222,354 5,122 2.36% Elections 14,409 32,051 11,851 38,210 22,901 10,308 (27,902) -73.02% Central Services 236,210 217,990 187,198 213,082 134,816 213,923 841 0.39% Finance 221,996 232,688 238,674 249,270 173,623 247,642 (1,628) -0.65% Subtotal 650,510 664,012 652,363 717,794 477,539 694,227 (23,567) -3.28% Community Development 469,777 459,520 438,046 486,119 311,107 462,326 (23,793) -4.89% Police 2,031,915 2,146,105 2,240,588 2,279,632 1,591,181 2,308,254 28,622 1.26% Fire 251,119 279,649 282,976 282,750 278,750 274,573 (8,177) -2.89% Public Works Administration 94,968 113,957 106,794 120,436 77,758 123,370 2,934 2.44% Parks, Recreation & Forestry: Recreation 122,566 136,343 108,647 125,600 55,855 109,600 (16,000) -12.74% Parks 296,694 310,235 310,388 306,586 218,821 295,466 (11,120) -3.63% Atheletic Field Mtnce - - - - - - - 0.00% Forestry 62,945 49,675 50,496 61,450 13,115 56,450 (5,000) -8.14% Subtotal 482,205 496,253 469,531 493,636 287,791 461,516 (32,120) -6.51% Fleet Services: Building & Grounds Mtnce 122,568 138,150 132,439 136,185 81,371 135,178 (1,007) -0.74% Squad & Staff Car Mtnce - - - - - - - 0.00% Vehicle & Equipment Mtnce 81,510 92,739 84,828 84,738 61,140 86,259 1,521 1.79% Subtotal 204,078 230,889 217,267 220,923 142,511 221,437 514 0.23% Streets: Pavement Management 162,420 202,003 211,452 191,215 143,553 189,405 (1,810) -0.95% Snow & Ice Control 119,559 124,271 120,925 128,811 90,271 122,712 (6,099) -4.73% Sign Maintenance 34,621 37,262 35,321 36,696 23,097 36,594 (102) -0.28% Subtotal 316,600 363,536 367,698 356,722 256,921 348,711 (8,011) -2.25% Other Convention & Visitor's Bureau 50,071 48,715 40,171 48,450 32,237 42,750 (5,700) -11.76% Social Service Coordination 17,927 18,375 18,926 18,926 18,661 18,661 (265) -1.40% Miscellaneous/contingency 4,069 5,400 6,263 106,500 2,337 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 73,598 89,662 (57,533) -39.09% Subtotal 625,791 573,116 549,643 546,071 126,833 402,573 (143,498) -26.28% Total expenditures 5,194,451 5,398,691 5,378,824 5,565,957 3,589,361 5,357,904 (208,053) -3.74% 4 General Fund Revenue Detail - 2011 Budget Y-T-D Acct 2007 2008 2009 2010 09/30/10 2011 Change from 2010 #Description Actual Actual Actual Budget Actual Request Dollar Percent Taxes 3101 Current ad valorem property tax 3,319,587 3,253,546 3,105,868 3,212,525 1,689,471 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 - 21,744 - - 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 6,174 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 - 16,559 - - 0.00% 3180 Franchise tax on utilities 273,540 283,796 235,002 287,000 135,179 249,900 (37,100) -12.93% 3190 Penalties & interest 2,878 6,208 2,910 - 2,216 - - 0.00% 3195 Hotel/Motel tax 52,615 51,263 43,835 51,000 33,934 45,000 (6,000) -11.76% Total taxes 3,987,026 3,980,530 3,887,706 3,992,835 1,905,277 4,071,722 78,887 1.98% Licenses and Permits 3211 Liquor on-sale 24,164 21,320 21,620 20,000 18,395 20,000 - 0.00% 3212 Liquor off-sale 685 2,475 645 700 410 700 - 0.00% 3215 Malt on-sale license - 1,835 1,820 1,000 1,870 1,000 - 0.00% 3216 Malt off-sale 100 100 10 100 740 100 - 0.00% 3221 Tobacco license 1,896 1,896 3,000 1,900 2,685 1,900 - 0.00% 3223 Amusement devices 1,755 1,950 810 1,000 795 1,000 - 0.00% 3231 Bowling alley 1,312 640 640 640 640 640 - 0.00% 3232 Garbage hauling 1,809 1,803 1,740 1,800 1,820 1,800 - 0.00% 3233 Gasoline station 1,067 582 582 600 736 600 - 0.00% 3234 Used car sales 158 158 200 150 200 150 - 0.00% 3235 Kennel 145 176 263 80 184 120 40 50.00% 3236 Restraurant licenses 4,723 4,190 4,290 4,000 4,075 4,000 - 0.00% 3237 Cabaret & Dance 100 - - - - - - 0.00% 3238 Transient & solicitor 1,860 2,455 2,385 1,000 1,390 1,500 500 50.00% 3239 Apartment 15,270 15,480 14,101 15,000 17,447 15,000 - 0.00% 3241 Dog 909 2,282 1,060 800 1,890 900 100 12.50% 3242 Massage therapy 1,905 955 435 - 100 - - 0.00% 3250 General contractor 1,244 1,050 1,050 1,200 365 1,100 (100) -8.33% 3251 HVAC contractor 3,611 4,586 4,503 3,000 2,720 3,800 800 26.67% 3252 Cement contractor 250 150 436 250 400 250 - 0.00% 3253 Asphalt contractor 400 500 700 400 200 500 100 25.00% 3254 Excavating contractor 150 50 50 150 150 50 (100) -66.67% 3255 Sign & billboard contractor 710 650 535 500 200 500 - 0.00% 3256 Sewer & water contractor - - 50 100 5 50 (50) -50.00% 3257 Other contractor 650 850 900 700 800 700 - 0.00% 3258 License check 1,492 1,761 1,210 1,000 842 1,000 - 0.00% 3260 Fire permits 990 1,155 750 600 600 600 - 0.00% Subtotal licenses 67,355 69,049 63,785 56,670 59,659 57,960 1,290 2.28% 5 General Fund Revenue Detail - 2011 Budget Y-T-D Acct 2007 2008 2009 2010 09/30/10 2011 Change from 2010 #Description Actual Actual Actual Budget Actual Request Dollar Percent 3262 Grading permit - 59 - - - - - 0.00% 3268 Plan check fee 31,238 22,603 21,444 25,000 7,017 22,000 (3,000) -12.00% 3270 Building permits 67,184 52,705 44,478 55,000 15,095 55,000 - 0.00% 3271 Fixed fee - building permits 17,196 26,901 18,872 18,000 10,974 18,000 - 0.00% 3272 Wetland buffer permit 100 78 75 - - - - 0.00% 3273 HVAC permits 12,475 11,726 11,867 12,000 5,564 12,000 - 0.00% 3274 Plumbing permits 10,258 5,267 6,860 8,000 2,209 8,000 - 0.00% 3275 Non-building permits 4,213 4,616 7,038 5,000 3,950 5,000 - 0.00% 3278 Interim use permits 375 25 - - - - - 0.00% 3279 Conditional use permits 1,375 750 1,250 600 1,200 600 - 0.00% 3280 Building surcharge 195 127 109 - (34) - - 0.00% 3281 Fixed fee building surcharge 7 10 5 - 360 - - 0.00% 3282 Mechanical/commercial surcharg 22 3 31 - 41 - - 0.00% 3283 HVAC surcharge 12 5 17 - 183 - - 0.00% 3284 Plumbing surcharge 29 1 1 - 67 - - 0.00% 3287 Commercial plmb surcharge 7 5 (16) - - - - 0.00% Subtotal permits 144,686 124,881 112,031 123,600 46,626 120,600 (3,000) -2.43% Total licenses & permits 212,041 193,930 175,816 180,270 106,285 178,560 (1,710) -0.95% Intergovernmental: 3318 Federal grant - 517 920 - 375 - - 0.00% 3341 Local Government Aid 38,729 60,685 495,704 231,636 116,039 - (231,636) -100.00% 3346 PERA Aid 8,671 8,671 8,671 8,671 4,336 8,671 - 0.00% 3351 Street Aid - MSA maintenance 93,940 93,541 94,294 100,000 105,033 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 6,094 7,500 - 0.00% 3358 State forestry grant 7,000 - - - - - 0.00% 3359 Other state grants 11,596 17,642 18,064 - 19,965 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 36,513 62,000 2,000 3.33% Total intergovernmental 348,800 380,602 816,717 557,807 288,355 321,171 (236,636) -42.42% Charges for services 3410 Advertising revenue 420 - - 100 1,035 50 (50) -50.00% 3415 Housing inspections - 150 - 50 47 50 - 0.00% 3418 HRA inspections 2,016 2,256 1,656 1,900 864 1,900 - 0.00% 3419 Investigations - 554 371 - 792 - - 0.00% 3421 Police reports 1,323 1,378 1,645 1,200 1,188 1,200 - 0.00% 3422 Documents / copies 34 60 536 90 155 90 - 0.00% 3423 Customer service 1,280 1,616 814 300 208 500 200 66.67% 3425 Book sales - various - 290 265 - 75 - - 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 13,316 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 1,403 4,500 (5,500) -55.00% 3433 Overload permits 1,200 2,850 1,425 2,000 4,950 2,000 - 0.00% 3458 Zoning letter 85 125 100 - 25 75 75 0.00% 3460 Easement vacation (250) 250 250 - - - - 0.00% 3461 Subdivision 1,275 1,275 775 1,200 1,250 1,000 (200) -16.67% 3462 Variance 750 1,200 1,125 1,500 450 1,000 (500) -33.33% 3463 Rezoning 500 500 - 1,000 - 500 (500) -50.00% 3464 Development - non refund - 375 375 500 375 350 (150) -30.00% 3465 Code appeal - - 250 - 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 26,383 16,565 (5,625) -25.35% 6 General Fund Revenue Detail - 2011 Budget Y-T-D Acct 2007 2008 2009 2010 09/30/10 2011 Change from 2010 #Description Actual Actual Actual Budget Actual Request Dollar Percent Fines and Forfeitures 3510 Ramsey County municipal court 23,955 21,949 17,835 23,000 13,168 18,000 (5,000) -21.74% 3515 Mn Highway Patrol 210 466 234 300 408 300 - 0.00% 3520 Administrative offenses 14,983 13,402 10,050 14,500 3,273 10,000 (4,500) -31.03% 3525 False alarm charges 2,685 2,800 1,700 3,000 950 2,000 (1,000) -33.33% Total fines & forfeitures 41,833 38,617 29,819 40,800 17,799 30,300 (10,500) -25.74% Other Revenue 3550 Special assessments 4,632 7,214 8,957 4,800 12,294 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 53,806 55,156 - 0.00% 3631 Water tower rental - - - - 17,605 85,868 85,868 0.00% 3634 Equipment and space rental 13 52 5,250 3,000 4,270 3,120 120 4.00% 3650 Donations 8,974 3,702 5,390 - 75 - - 0.00% 3655 City fines - 25 - - - - - 0.00% 3656 Tree sales 1,405 1,326 (40) 1,200 (101) 1,200 - 0.00% 3665 Park site rental 5,579 8,982 9,189 5,000 9,160 7,000 2,000 40.00% 3666 Park permit - - - - 480 - - 0.00% 3679 Vending machine commissions 362 - 5 - 15 - - 0.00% 3680 Other revenue 90,990 25,668 5,253 11,000 12,630 11,000 - 0.00% 3685 Insurance reimbursements 16,507 19,275 31,551 3,000 6,097 3,000 - 0.00% 3690 Cash over / short 22 - - - - - - 0.00% 3911 Sale of assets 7,425 4,818 - 3,000 7,000 3,000 - 0.00% 3912 Resale of materials 178 12,402 5,072 500 9,798 500 - 0.00% Total other revenue 293,925 376,445 220,443 190,656 133,129 278,844 88,188 46.26% 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 207,394 141,794 216.15% 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 - 666,449 143,782 27.51% Total 5,438,411 5,628,431 5,560,903 5,507,225 2,477,228 5,563,611 56,386 1.02% 7 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent City Council (100 - 4100): Personnel services 0100 Salaries, regular 29,292 29,292 29,196 29,100 21,897 29,100 - 0.00% 0300 Social Security 1,873 1,873 1,873 2,226 1,405 2,226 - 0.00% 0321 PERA 885 885 570 1,455 428 1,455 - 0.00% 0500 Workers compensation 89 36 41 48 48 67 19 39.58% Total personnel services 32,139 32,086 31,680 32,829 23,778 32,848 19 0.06% Materials & supplies 1600 Supplies, operating 1,593 1,140 1,158 1,700 870 1,600 (100) -5.88% Total materials & supplies 1,593 1,140 1,158 1,700 870 1,600 (100) -5.88% Contractual services 3030 Other professional services 10,879 10,093 5,985 9,490 3,680 9,490 - 0.00% 3610 Memberships 3,371 3,378 3,585 2,826 2,821 2,900 74 2.62% 3630 Training & conferences 2,421 1,677 875 2,000 411 1,800 (200) -10.00% 4800 Bonding & insurance 1,067 1,035 1,060 1,129 865 1,129 - 0.00% Total contractual services 17,738 16,183 11,505 15,445 7,777 15,319 (126) -0.82% Capital outlays - - - - - - - 0.00% Total City Council 51,470 49,409 44,343 49,974 32,425 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 2,206 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,339 4,500 - 0.00% Total contractual services 16,018 22,245 9,575 11,600 6,545 10,850 (750) -6.47% Capital outlays - - - - - - 0.00% Total Advisory Commissions 16,018 22,245 9,575 11,900 6,545 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Office of the City Administrator (100 - 4130): Personnel services 0100 Salaries, regular 139,527 143,461 169,137 162,956 112,745 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 8,264 13,135 401 3.15% 0321 PERA 7,894 9,022 10,977 11,458 7,833 12,244 786 6.86% 0400 Group insurance 14,591 14,460 18,489 18,473 14,021 19,778 1,305 7.06% 0500 Workers compensation 1,253 501 637 744 727 973 229 30.78% 0990 Severence - - - - - - - 0.00% Total personnel services 174,196 178,069 211,733 209,885 143,590 217,822 7,937 3.78% Materials & supplies 1230 Supplies, equipment - 130 - 500 450 (50) -10.00% 1600 Supplies, operating - 34 28 100 143 90 (10) -10.00% 2100 Books & periodicals - 49 - 50 - 45 (5) -10.00% Total materials & supplies - 213 28 650 143 585 (65) -10.00% Contractual services 3100 Communications - 432 456 432 265 432 - 0.00% 3610 Memberships 1,101 1,076 1,037 2,765 80 240 (2,525) -91.32% 3630 Training & conferences 2,090 1,260 1,206 2,900 2,121 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 2,466 3,947 (2,750) -41.06% Capital outlays 7030 Equipment - - - - - - - 0.00% 0.00% Total City Administrator 177,895 181,283 214,640 217,232 146,199 222,354 5,122 2.36% Elections (100 - 4140): Personnel services 0100 Salaries, regular 10,544 7,350 7,854 14,006 9,678 7,045 (6,961) -49.70% 0110 Salaries, overtime 51 - - - - - - 0.00% 0150 Salaries, part-time - 18,719 - 14,897 7,045 - (14,897) -100.00% 0300 Social Security 777 535 565 1,072 706 539 (533) -49.72% 0321 PERA 661 476 526 926 677 467 (459) -49.57% 0400 Group insurance 1,703 1,048 1,213 1,894 1,428 1,080 (814) -42.98% 0500 Workers compensation 59 126 52 165 162 152 (13) -7.88% 0990 Severence - - - - 0.00% Total personnel services 13,795 28,254 10,210 32,960 19,696 9,283 (23,677) -71.84% Materials & supplies 1600 Supplies, operating - 2,927 - 2,950 1,478 100 (2,850) -96.61% Total materials & supplies - 2,927 - 2,950 1,478 100 (2,850) -96.61% Contractual services 3030 Other professional services 614 636 1,641 1,900 1,727 825 (1,075) -56.58% 3410 Legal notices - 234 - 400 - 100 (300) -75.00% Total contractual services 614 870 1,641 2,300 1,727 925 (1,375) -59.78% 7030 Capital outlays - - - - - - - 0.00% Total Elections 14,409 32,051 11,851 38,210 22,901 10,308 (27,902) -73.02% 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 432 Sprint/Nextel service - 720 432 432 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,532 -21.86%39.12%-21.59%-38.31% 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 Ramsey County fees 600 200 200 Equip. maint. service costs (voting equip.)(even years and special elections) 1,200 825 1,900 - 3410 Legal notices 400 200 400 Primary and general election (even years and special elections) 400 200 400 - 4,050 1,125 5,250 100 138.24%-72.22%366.67%-98.10% 11 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Finance (100 - 4150): Personnel services 0100 Salaries, regular 147,317 154,033 159,984 161,839 113,527 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 14,174 20,935 197 0.95% 0300 Social Security 11,472 12,212 11,811 13,972 8,458 13,778 (194) -1.39% 0321 PERA 10,393 11,290 12,091 12,785 8,911 13,057 272 2.13% 0400 Group insurance 18,653 18,793 16,241 21,432 12,407 21,942 510 2.38% 0500 Workers compensation 741 872 1,063 1,239 1,243 1,325 86 6.94% 0990 Severence - - - 0.00% Subtotal 207,540 216,644 221,419 232,064 158,720 230,204 (1,860) -0.80% 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 309 325 (25) -7.14% Subtotal 660 858 526 800 309 700 (100) -12.50% Contractual services 3030 Other professional 7,269 8,771 8,890 9,105 9,099 9,345 240 2.64% 3430 Printing 205 179 1,736 800 - 700 (100) -12.50% 3610 Memberships 630 510 700 505 445 520 15 2.97% 3630 Training 2,315 2,213 1,857 2,090 1,211 2,075 (15) -0.72% 5130 Repairs, equipment 3,377 3,513 3,546 3,906 3,839 4,098 192 4.92% Subtotal 13,796 15,186 16,729 16,406 14,594 16,738 332 2.02% Total Financial Services 221,996 232,688 238,674 249,270 173,623 247,642 (1,628) -0.65% 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual 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 598 1,400 (100) -6.67% 1120 Copy materials 2,148 1,451 1,650 2,000 1,681 2,000 - 0.00% 1230 Supplies, equipment 2,569 751 1,045 700 167 700 - 0.00% 1600 Supplies, operating 16,198 15,338 15,024 15,900 9,421 15,900 - 0.00% 2100 Books & periodicals 215 239 259 410 228 375 (35) -8.54% Total materials & supplies 23,710 19,498 18,442 20,510 12,095 20,375 (135) -0.66% Contractual services 3010 General legal 51,167 57,805 38,989 48,600 22,175 48,600 - 0.00% 3030 Other professional services 18,654 15,541 5,622 9,950 4,720 9,600 (350) -3.52% 3100 Telephone 11,065 8,764 7,638 8,400 4,843 8,400 - 0.00% 3300 Postage 10,624 9,104 10,397 12,300 4,206 11,800 (500) -4.07% 3410 Legal notices 1,901 2,108 2,250 3,000 904 2,800 (200) -6.67% 3420 Advertising 5,675 8,530 2,034 4,000 1,714 3,800 (200) -5.00% 3430 Printing 6,693 6,956 4,200 8,000 3,180 7,500 (500) -6.25% 3610 Memberships 9,130 9,961 9,965 10,404 10,375 10,404 - 0.00% 3630 Training & conferences 587 138 143 1,400 172 1,000 (400) -28.57% 4010 Rental, equipment 9,840 5,293 283 750 434 810 60 8.00% 4800 Insurance & bonds 45,627 21,419 23,673 22,000 20,321 22,000 - 0.00% 5100 Repairs, computers 39,638 52,245 62,545 62,868 49,067 65,934 3,066 4.88% 5130 Repairs, equipment 1,899 628 838 900 610 900 - 0.00% Total contractual services 212,500 198,492 168,577 192,572 122,721 193,548 976 0.51% Capital outlays 7030 Equipment 23,996 24,651 6,617 25,000 3,045 23,000 (2,000) -8.00% Total capital outlays 23,996 24,651 6,617 25,000 3,045 23,000 (2,000) -8.00% Total central services 260,206 242,641 193,815 238,082 137,861 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, envelops, letterhead, 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Community Development (100 - 4180): Personnel services 0100 Salaries, regular 338,066 322,876 319,530 316,024 223,494 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 5,133 18,567 (16,715) -47.38% 0300 Social Security 19,237 17,296 16,560 26,953 11,257 25,610 (1,343) -4.98% 0321 PERA 27,913 29,016 30,765 24,510 21,592 23,623 (887) -3.62% 0400 Group insurance 43,585 42,261 50,913 52,050 37,352 52,724 674 1.29% 0500 Workers comp 2,637 1,173 1,315 1,568 1,574 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 300,402 438,611 (18,798) -4.11% Materials & supplies 1230 Supplies, equipment 15 671 734 700 19 500 (200) -28.57% 1600 Supplies, operating 57 - 136 500 70 400 (100) -20.00% 2100 Books & periodicals 994 604 98 1,090 59 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 148 1,660 (930) -35.91% Contractual services 3030 Other professional 9,970 11,212 9,517 14,375 6,607 13,550 (825) -5.74% 3040 Consultants, special projects 2,560 14,626 (3,110) - 1,157 - - 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 717 1,100 - 0.00% 3430 Printing 1,005 1,341 1,055 2,500 1,042 1,500 (1,000) -40.00% 3610 Memberships 760 730 1,170 1,045 455 1,005 (40) -3.83% 3630 Training and conferences 3,822 3,200 1,451 2,000 566 800 (1,200) -60.00% 3800 Mileage 81 61 174 100 13 100 - 0.00% Total contractual services 27,294 35,964 11,313 26,120 10,557 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 311,107 462,326 (23,793) -4.89% 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Police (100 - 4200): Personnel services: 0100 Salaries, regular 1,324,254 1,424,596 1,469,882 1,448,756 1,017,140 1,456,918 8,162 0.56% 0110 Overtime 39,252 33,177 50,022 49,439 35,823 49,439 - 0.00% 0150 Salaries, part-time 13,547 14,490 11,492 14,754 4,009 14,612 (142) -0.96% 0300 Social Security 21,419 22,122 22,338 25,773 14,803 25,753 (20) -0.08% 0321 PERA 156,533 181,254 201,575 205,070 134,672 210,859 5,789 2.82% 0400 Group insurance 177,534 166,822 183,002 199,536 129,635 203,016 3,480 1.74% 0500 Workers compensation 39,926 36,538 44,474 46,312 46,445 45,465 (847) -1.83% 0600 Unemployment - - 447 - 1,149 - 0.00% 0990 Severence - - - - - - - 0.00% Total personnel services 1,772,465 1,878,999 1,983,232 1,989,640 1,383,676 2,006,062 16,422 0.83% Materials & Supplies 1210 Supplies, buildings & grounds 588 - 400 800 400 800 - 0.00% 1230 Supplies, equipment 1,483 224 3,041 2,000 15 2,000 - 0.00% 1600 Supplies, operating 9,217 4,356 6,618 5,500 2,344 5,500 - 0.00% 1700 Motor, fuels & lubricants 45,231 42,619 33,570 42,250 27,663 42,250 - 0.00% 2100 Books & periodicals 1,271 564 233 1,000 402 900 (100) -10.00% 2400 Uniforms & clothing 15,669 17,385 18,932 21,260 13,876 19,040 (2,220) -10.44% Total materials & supplies 73,459 65,148 62,794 72,810 44,700 70,490 (2,320) -3.19% Contractual services 3010 General Legal - - 560 - 1,552 - - 0.00% 3020 Legal, prosecuting attorney 45,340 51,047 46,750 52,530 39,443 53,580 1,050 2.00% 3030 Other professional services 5,237 1,077 7,033 5,040 1,305 3,990 (1,050) -20.83% 3050 Dispatching 55,755 55,755 55,755 65,319 38,103 77,144 11,825 18.10% 3055 Information systems fees 2,540 2,540 2,040 2,616 1,520 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 2,150 6,000 2,250 60.00% 3100 Telephone 3,025 1,827 1,917 2,000 1,293 2,000 - 0.00% 3210 Electricity 247 248 270 360 159 320 (40) -11.11% 3430 Printing 649 773 701 1,200 569 800 (400) -33.33% 3610 Memberships 1,230 1,446 1,861 1,460 1,265 1,475 15 1.03% 3630 Training 11,987 11,201 11,950 13,560 7,340 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 39,968 24,000 1,000 4.35% 5100 Technology maintenance 30,864 30,015 33,967 35,607 25,875 37,227 1,620 4.55% 5130 Maintenance, equipment 6,879 4,447 10,570 9,540 2,263 10,640 1,100 11.53% Total contractual services 185,991 201,958 194,562 217,182 162,805 231,702 14,520 6.69% Capital outlays 7030 Equipment 11,290 13,027 8,134 11,600 4,576 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 4,576 30,200 (10,400) -25.62% Total police 2,086,448 2,235,909 2,276,827 2,320,232 1,595,757 2,338,454 18,222 0.79% 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Fire (100 - 4210): Contractual services 3032 Contractual fire services 247,780 276,197 279,336 278,750 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 278,750 274,573 (8,177) -2.89% Capital outlays: 7040 Vehicles & equipment 32,613 13,048 35,789 46,452 49,452 22,894 (23,558) -50.71% Total capital outlays 32,613 13,048 35,789 46,452 49,452 22,894 (23,558) -50.71% Total Fire 283,732 292,697 318,765 329,202 328,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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Recreation (100 - 4350): Contractual services: 3036 Contractual recreation 121,077 134,951 107,201 123,900 54,552 107,900 (16,000) -12.91% 4800 Bonding & insurance 1,489 1,392 1,446 1,700 1,303 1,700 - 0.00% Total contractual services 122,566 136,343 108,647 125,600 55,855 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 55,855 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent 2011 Budget Summary Parks (100 - 4360): Personnel services 0100 Salaries, regular 108,283 115,771 118,198 114,917 81,804 115,044 127 0.11% 0110 Overtime, regular 6,434 5,467 5,749 4,376 2,986 4,333 (43) -0.98% 0150 Salaries, part-time 48,616 48,297 47,152 41,400 31,231 34,500 (6,900) -16.67% 0300 Social Security 12,049 12,237 11,980 12,293 8,441 11,771 (522) -4.25% 0321 PERA 8,478 9,133 9,635 8,350 6,975 8,655 305 3.65% 0400 Group insurance 16,951 17,222 20,335 19,968 14,076 20,208 240 1.20% 0500 Workers compensation 4,240 3,885 4,537 4,949 4,956 5,167 218 4.40% Total personnel services 205,051 212,012 217,586 206,253 150,469 199,678 (6,575) -3.19% Materials & supplies: 1210 Supplies, bldgs & grnds 9,745 15,508 12,927 13,420 7,077 13,960 540 4.02% 1220 Supplies, vehicles 5,161 5,069 8,455 4,800 6,891 4,800 - 0.00% 1230 Supplies, equipment 1,587 2,136 1,285 2,200 1,019 1,950 (250) -11.36% 1600 Supplies, operating 7,332 6,689 5,788 8,200 7,922 6,000 (2,200) -26.83% 1700 Motor fuels & lubs 6,675 8,681 5,452 10,250 4,521 9,225 (1,025) -10.00% 2400 Uniforms & clothing 1,848 1,113 1,711 2,030 464 2,030 - 0.00% 2410 Mats & towels 758 1,137 1,436 800 1,014 800 - 0.00% Total materials & supplies 33,106 40,333 37,054 41,700 28,908 38,765 (2,935) -7.04% Contractual services: 3030 Other professional services 3,616 182 526 2,155 125 2,155 - 0.00% 3100 Telephone 3,360 3,748 2,603 1,500 1,113 1,500 - 0.00% 3200 Water & sewer 7,418 4,808 3,998 7,500 4,620 6,000 (1,500) -20.00% 3210 Electricity 5,391 6,921 5,670 6,500 3,163 6,500 - 0.00% 3220 Natural gas 4,148 5,797 4,880 5,000 2,874 5,000 - 0.00% 3530 Refuse collection 73 - - - 662 - - 0.00% 3610 Memberships 142 - 63 65 64 65 - 0.00% 3630 Training & conferences 1,947 198 1,878 1,805 699 1,845 40 2.22% 3900 Grants & subsidies 8,719 10,608 10,608 10,608 10,608 10,608 - 0.00% 4010 Rental, equipment - - - 200 41 200 - 0.00% 4030 Portable restrooms 5,588 5,703 5,753 6,300 3,315 6,150 (150) -2.38% 4800 Bonding & insurance 12,847 13,922 14,458 15,000 11,497 15,000 - 0.00% 5110 Repairs, bldg & grounds 5,288 6,003 5,311 2,000 663 2,000 - 0.00% Total contractual services 58,537 57,890 55,748 58,633 39,444 57,023 (1,610) -2.75% Capital outlays 7030 Equipment 12,024 - - - - 26,300 26,300 0.00% 7050 Construction - 5,845 - - - - - Total capital outlays 12,024 5,845 - - - 26,300 26,300 0.00% Total Parks 308,718 316,080 310,388 306,586 218,821 321,766 15,180 4.95% 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 (trim mower)(vehicle & equip. fund) - 32,000 - - Replace #404 F250 (postpone to 2011) - 32,000 - - 7050 Capital, construction 4,000 - - - Mounument signs for 1/2 of parks (1st half started in 07) - - - 16,000 Used wood Chipper - - - 5,600 Stump grinder attachment for skidstear - - - 4,700 Tracks for skid steer - - - - Resurface Silverview Basketball Court 4,000 - - 26,300 107,582 138,574 100,333 124,313 -20.56%28.81%-27.60%23.90% 27 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent 2011 Budget Summary Forestry (100 - 4380): Materials & supplies 1200 Supplies, landscaping 6,368 1,491 581 4,250 104 4,250 - 0.00% Total materials & supplies 6,368 1,491 581 4,250 104 4,250 - 0.00% Contractual services 3030 Professional services 8,223 18,510 25,097 13,000 7,729 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 5,267 28,000 - 0.00% 3610 Memberships - - - - 15 - - 0.00% 3630 Training & conferences - - 50 200 - 200 - Total contractual services 56,577 48,184 49,915 57,200 13,011 52,200 (5,000) -8.74% Capital outlays 7030 Equipment - - - - - - 0.00% Total Forestry 62,945 49,675 50,496 61,450 13,115 56,450 (5,000) -8.14% 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Public Works Administration (100-4410): Personnel services: 0100 Salaries, regular 74,020 54,954 63,041 88,009 58,651 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 4,157 7,044 255 3.76% 0321 PERA 4,235 3,144 4,237 6,160 4,101 6,623 463 7.52% 0400 Group insurance 7,813 6,410 9,121 13,275 8,775 13,469 194 1.46% 0500 Workers compensation 1,297 987 1,306 1,372 1,377 1,097 (275) -20.04% Total personnel services 92,814 69,449 82,236 116,333 77,061 120,307 3,974 3.42% Materials & supplies: 1230 Supplies, equipment - - - - - - - 0.00% 1600 Operating supplies - - 153 200 6 200 - 0.00% 2400 Uniforms & clothing 298 - - 400 165 400 - 0.00% Total materials and supplies 298 - 153 600 171 600 - 0.00% Contractual services: 3030 Other professional services 895 44,223 23,503 1,040 127 340 (700) -67.31% 3610 Memberships 142 185 433 883 341 683 (200) -22.65% 3630 Training & conferences 819 100 469 1,280 58 1,140 (140) -10.94% 3800 Mileage reimbursement - - - 300 - 300 - 0.00% Total contractual services 1,856 44,508 24,405 3,503 526 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 77,758 123,370 2,934 2.44% 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent 2011 Budget Summary Building & Grounds Maintenance (100 - 4460): Personnel services: 0100 Salaries, regular 11,654 11,816 11,676 11,237 8,294 11,575 338 3.01% 0110 Salaries, overtime 446 380 764 908 625 935 27 2.97% 0300 Social Security 855 837 813 929 581 957 28 3.01% 0321 PERA 755 784 839 851 624 907 56 6.58% 0400 Group insurance 2,220 2,111 2,564 2,496 1,944 2,526 30 1.20% 0500 Workers compensation 473 515 598 685 687 414 (271) -39.56% Total personnel services 16,403 16,443 17,254 17,106 12,755 17,314 208 1.22% Materials & supplies: 1210 Supplies, building & grounds 3,695 1,719 329 1,500 676 1,500 - 0.00% 1220 Supplies, vehicles - (89) - - - - - 0.00% 1230 Supplies, equipment 326 1,547 928 690 237 690 - 0.00% 1600 Supplies, operating 5,186 3,464 3,767 6,000 3,297 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 4,210 7,710 (600) -7.22% Contractual services: 3030 Other professional services 15,527 26,835 25,590 23,360 15,640 23,360 - 0.00% 3200 Water & sewer 1,794 993 1,773 1,800 582 1,800 - 0.00% 3210 Electricity 23,046 23,584 24,238 25,000 13,426 25,000 - 0.00% 3220 Natural gas 24,193 26,233 22,474 26,612 12,501 26,612 - 0.00% 3530 Refuse collection 9,559 9,942 9,183 10,121 8,369 10,021 (100) -0.99% 4010 Rental, equipment 596 367 - 205 - 205 - 0.00% 4800 Insurance 5,289 5,733 10,850 7,000 5,826 7,000 - 0.00% 5110 Repairs, bldgs & grounds 12,310 10,573 4,470 9,556 5,961 9,556 - 0.00% 5130 Repairs, equipment 4,548 10,725 11,583 7,115 2,101 6,600 (515) -7.24% Total contractual services 96,862 114,985 110,161 110,769 64,406 110,154 (615) -0.56% Capital outlays 7030 Equipment - - - - - 105,000 105,000 0.00% Total capital outlays - - - - - 105,000 105,000 0.00% Total buildings & grounds 122,568 138,150 132,439 136,185 81,371 240,178 103,993 76.36% 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) - - - 105,000 Boom truck 1,200 900 - 105,000 100,111 124,591 119,079 222,864 -4.77%24.45%-4.42%87.16% 33 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent 2011 Budget Summary Vehicle & Equipment Maintenance (100 - 4465): Personnel services: 0100 Salaries, regular 29,555 29,492 30,277 30,039 21,549 30,039 - 0.00% 0110 Salaries, overtime - - 72 505 - 505 - 0.00% 0300 Social Security 2,248 2,231 2,137 2,337 1,605 2,337 - 0.00% 0321 PERA 1,842 1,916 1,933 2,138 1,503 2,215 77 3.60% 0400 Group insurance 3,011 3,209 3,892 4,781 3,178 4,925 144 3.01% 0500 Workers compensation 1,173 1,258 1,462 1,723 1,729 1,008 (715) -41.50% Total personnel services 37,829 38,106 39,773 41,523 29,564 41,029 (494) -1.19% Materials & supplies: 1220 Supplies, vehicles 12,508 15,203 14,329 13,450 11,884 13,450 - 0.00% 1230 Supplies, equipment 2,125 1,123 1,929 2,800 2,138 2,600 (200) -7.14% 1600 Supplies, operating 3,261 3,730 1,995 3,250 1,433 3,875 625 19.23% 1700 Motor fuels & lubricants 7,201 7,959 4,729 5,085 2,741 4,935 (150) -2.95% 2400 Uniforms & clothing 960 485 1,871 600 284 900 300 50.00% 2410 Mats & towels 758 1,137 1,407 650 1,014 650 - 0.00% Total materials & supplies 26,813 29,637 26,260 25,835 19,494 26,410 575 2.23% Contractual services: 3100 Telephone 897 1,107 1,143 1,000 931 1,150 150 15.00% 3530 Refuse collection - - - - - 100 100 0.00% 3610 Memberships 142 - 63 65 64 65 - 0.00% 3630 Training 1,303 881 48 1,115 301 1,005 (110) -9.87% 4010 Rental, equipment - - - 100 - 100 - 0.00% 5120 Repairs, vehicles 4,913 17,967 6,352 9,600 8,653 10,900 1,300 13.54% 5130 Repairs, equipment 9,613 5,041 11,189 5,500 2,133 5,500 - 0.00% Total contractual services 16,868 24,996 18,795 17,380 12,082 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 61,140 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent 2011 Budget Summary Street Pavement Management (100 - 4470): Personnel services: 0100 Salaries, regular 84,631 74,991 78,420 88,018 61,422 90,167 2,149 2.44% 0110 Salaries, overtime 39 266 1,737 2,888 1,894 2,888 - 0.00% 0150 Salaries, part-time 5,441 26,338 18,744 7,200 7,508 7,200 - 0.00% 0300 Social Security 6,838 7,641 7,360 7,506 5,247 7,670 164 2.18% 0321 PERA 5,095 4,671 5,387 6,363 4,425 6,746 383 6.02% 0400 Group insurance 8,369 8,424 11,003 13,154 10,041 13,494 340 2.58% 0500 Workers compensation 3,660 3,583 4,249 4,968 4,981 4,847 (121) -2.44% 0990 Severence pay - - - - 0.00% Total personnel services 114,073 125,914 126,900 130,097 95,518 133,012 2,915 2.24% Materials & supplies: 1230 Supplies, equipment 807 701 1,628 950 159 500 (450) -47.37% 1240 Supplies, streets 15,934 25,160 40,299 21,100 31,528 21,100 - 0.00% 1260 Supplies, traffic control 1,685 1,960 1,183 480 27 1,000 520 108.33% 1600 Supplies, operating 6,320 4,069 1,558 2,115 1,995 1,680 (435) -20.57% 1700 Motor fuels & lubricants 10,151 14,941 4,354 12,050 6,433 9,850 (2,200) -18.26% 2400 Uniforms & clothing 519 266 808 1,920 469 1,920 - 0.00% 2410 Mats & towels 921 1,137 1,427 700 1,014 700 - 0.00% Total materials & supplies 36,337 48,234 51,257 39,315 41,625 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 969 1,200 - 0.00% 3160 Memberships - - - 113 - 113 - 0.00% 3630 Training & conferences 1,326 621 1,097 1,340 689 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 4,752 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 6,410 19,643 (2,160) -9.91% Capital outlays 7030 Equipment 22,754 2,002 - - - - - 0.00% Total capital outlays 22,754 2,002 - - - - - 0.00% Total street pavement management 185,174 204,005 211,452 191,215 143,553 189,405 (1,810) -0.95% 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 - - - - - 40,000 - - 1 ton pick-up (carryover from 2009)(postpone to 2011) 2,000 - - - Lift tail gate 2,000 40,000 - - 58,935 103,030 61,118 56,393 -40.72%74.82%-40.68%-7.73% 37 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual 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 40,094 55,073 - 0.00% 0110 Salaries, overtime 10,062 6,884 8,204 5,416 2,564 5,416 - 0.00% 0300 Social Security 4,996 4,781 4,840 4,627 3,155 4,627 - 0.00% 0321 PERA 3,797 4,192 4,418 4,234 2,980 4,386 152 3.59% 0400 Group insurance 7,203 7,424 8,939 8,765 7,144 9,029 264 3.01% 0500 Workers compensation 2,921 3,151 3,662 4,313 4,322 4,198 (115) -2.67% Total personnel services 85,461 84,193 87,651 82,428 60,259 82,729 301 0.37% Materials & supplies: 1230 Supplies, equipment 1,957 3,795 3,849 2,550 1,146 2,100 (450) -17.65% 1600 Supplies, operating 27,884 29,683 19,873 32,800 27,691 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 68 1,000 (200) -16.67% Total materials & supplies 31,100 38,282 31,457 44,230 28,905 37,830 (6,400) -14.47% Contractual services: 3030 Other professional services 580 580 700 700 700 700 - 0.00% 3610 Memberships 427 200 331 203 354 203 - 0.00% 3630 Training & conferences 320 - 80 250 - 250 - 0.00% 5130 Repairs, equipment 1,671 1,016 706 1,000 53 1,000 - 0.00% Total contractual supplies 2,998 1,796 1,817 2,153 1,107 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 90,271 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent 2011 Budget Summary Street Sign Maintenance (100 - 4475): Personnel services: 0100 Salaries, regular 20,830 20,718 20,797 20,026 14,475 20,026 - 0.00% 0110 Salaries, overtime - - 650 722 703 722 - 0.00% 0300 Social Security 1,700 1,573 1,599 1,587 1,137 1,587 - 0.00% 0321 PERA 1,604 1,348 1,441 1,453 1,060 1,504 51 3.51% 0400 Group insurance 3,117 2,546 3,024 3,187 2,655 3,283 96 3.01% 0500 Workers compensation 1,031 1,102 1,281 1,507 1,511 1,508 1 0.07% Total personnel services 28,282 27,287 28,792 28,482 21,541 28,630 148 0.52% Materials & supplies: 1600 Supplies, operating 2,238 7,209 3,929 4,734 554 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 554 5,214 - 0.00% Contractual services: 3250 Electricity - traffic signals 1,736 2,166 1,797 2,000 1,002 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 1,002 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 23,097 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Convention & Visitor's Bureau (100-4653) Contractual services 3045 N Metro Convention Bureau 50,071 48,715 40,171 48,450 32,237 42,750 (5,700) -11.76% Total contractual services 50,071 48,715 40,171 48,450 32,237 42,750 (5,700) -11.76% Total Convention & Visitor's Bureau 50,071 48,715 40,171 48,450 32,237 42,750 (5,700) -11.76% Miscellaneous (100 - 4700): Personnel services 0300 Social security - 133 277 - 26 - - 0.00% 0321 PERA - 133 428 - 266 - - 0.00% 0400 Group insurance - 165 423 - 230 - - 0.00% 0750 Fitness program 4,069 4,969 5,135 6,500 1,815 6,500 - 0.00% Total personnel services 4,069 5,400 6,263 6,500 2,337 6,500 - 0.00% Contractual services 3065 Family & youth social services 17,927 18,375 18,926 18,926 18,661 18,661 (265) -1.40% Total contractual services 17,927 18,375 18,926 18,926 18,661 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 20,998 270,161 (80,265) -22.90% Debt Service (100 - 4750): Debt Service Fire Bonds: 8010 Principal 170,919 107,098 99,088 103,428 52,002 50,213 (53,215) -51.45% 8020 Interest 30,396 41,098 50,195 43,767 21,596 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 73,598 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Cable TV (Fund 210): Revenues 3180 Franchise fee 101,969 109,828 141,282 96,000 57,186 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 2,580 5,100 - 0.00% Total revenue 117,794 111,943 147,812 101,100 59,766 101,100 - 0.00% Operating expenses Operations (4350) Personnel services 0100 Salaries, regular 18,733 49,259 54,766 58,781 41,020 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 3,554 8,432 (55) -0.65% 0300 Social security 1,749 4,460 4,895 5,146 3,354 5,188 42 0.82% 0321 PERA 1,255 4,030 4,341 4,114 3,095 4,308 194 4.72% 0400 Group insurance 1,950 5,292 7,004 8,366 5,934 8,618 252 3.01% 0500 Workers compensation 1,199 182 239 303 304 299 (4) -1.32% 0600 Unemployment 691 - 1,246 - 151 - - 0.00% 0990 Severence pay - - - - - - - 0.00% Total personnel services 32,758 71,490 82,582 85,197 57,412 86,228 1,031 1.21% Materials & supplies 1230 Supplies, equipment 1,662 237 2,598 4,000 223 2,000 (2,000) -50.00% 1600 Supplies, operating 1,388 1,081 551 1,500 221 1,000 (500) -33.33% Total materials & suppli 3,050 1,318 3,149 5,500 444 3,000 (2,500) -45.45% Contractual services 3030 Other professional service 4,024 3,713 4,850 3,400 1,822 3,600 200 5.88% 3630 Training & conferences 16 152 325 1,300 370 300 (1,000) -76.92% 3800 Mileage & parking 302 97 20 100 20 100 - 0.00% 3900 Grants & subsidies 23,658 25,936 26,719 27,254 26,933 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 29,145 31,933 (1,621) -4.83% Capital 7030 Equipment - 37,462 9,767 - 139 - - 0.00% Total capital outlays - 37,462 9,767 - 139 - - 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 87,140 121,161 (3,090) -2.49% Net change in fund balance 41,227 (29,131) 20,349 (23,151) (27,374) (20,061) 3,090 -13.35% Fund balance, beginning year 250,620 291,847 262,716 283,065 283,065 259,914 (23,151) -8.18% Fund balance, end of year 291,847$ 262,716$ 283,065$ 259,914$ 255,691$ 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Actual Actual Actual Budget Actual Request Dollar Percent DARE (Fund 220): Revenues 3511 Fines - controlled substnc 517 643 759 850 538 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 538 800 (50) -5.88% Operating expenses (4200): Materials & supplies 1600 Supplies, operating 5,974 1,357 754 2,000 1,188 650 (1,350) -67.50% Total Supplies 5,974 1,357 754 2,000 1,188 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 1,188 3,800 800 10.82% Net change in fund balance (1,752) (5,107) (3,938) (6,543) (650) (3,000) 92 -1.41% Fund balance, beginning year 21,362 19,610 14,503 10,565 10,565 4,022 (13,341) -126.28% Fund balance, end of year 19,610$ 14,503$ 10,565$ 4,022$ 9,915$ 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Actual Actual Actual Budget Actual 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 - - - - 100 - - 0.00% 3430 Printing - - - - - - - 0.00% 3630 Training & conferences - - - - - - - 0.00% Total contractual services - - - - 100 - - 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 - 100 11,000 11,000 #DIV/0! Net change in fund balance (1,438) (8,237) - - (100) (11,000) (11,000) #DIV/0! Fund balance, beginning year 22,306 20,868 12,631 12,631 12,631 12,631 10,909 86.37% Fund balance, end of year 20,868 12,631 12,631 12,631 12,531 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Forfeiture (Fund 225): Revenues 3514 Forfeitures 31,997 10,098 15,744 5,500 10,572 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 10,572 5,500 - 0.00% Operating expenses (4200): Materials & supplies 1230 Supplies, equipment - - - - - - 0.00% 1600 Supplies, operating 104 7,334 206 500 340 500 - 0.00% Total materials & supplies 104 7,334 206 500 340 500 - 0.00% Contractual services 3030 Other professional services 25,715 203 5,881 2,000 2,794 1,500 (500) -25.00% Total contractual services 25,715 203 5,881 2,000 2,794 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 3,134 31,000 19,000 158.33% Net change in fund balance 8,063 (37,312) 9,657 (6,500) 7,438 (25,500) (29,868) 459.51% Fund balance, beginning year 55,941 64,004 26,692 36,349 36,349 29,849 3,624 9.97% Fund balance, end of year 64,004 26,692 36,349 29,849 43,787 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual 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 56,011 78,681 1,384 1.79% 0300 Social security 3,462 5,335 5,808 5,914 4,237 6,019 105 1.78% 0321 PERA 2,942 4,438 5,098 5,411 3,913 5,703 292 5.40% 0400 Group insurance 5,417 9,577 9,039 9,364 7,277 9,628 264 2.82% 0500 Workers compensation 576 209 274 322 323 429 107 33.23% 0990 Severence pay - - - - - - - 0.00% Total personnel services 63,712 91,444 97,459 98,308 71,761 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 17,564 73,910 120 0.16% 3420 Advertisements 1,264 336 717 1,000 - 1,000 - 0.00% 3430 Printing - - 556 1,000 415 1,000 - 0.00% 3610 Memberships 10,366 10,086 3,935 3,801 3,066 3,875 74 1.95% 3630 Training & conferences 886 1,980 1,262 2,210 541 2,210 - 0.00% 3800 Mileage 21 - - 100 - 100 - 0.00% 4800 Insurance 3,487 3,767 3,912 4,600 3,526 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 25,112 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 96,873 387,435 2,246 0.58% Net change in fund balance 2,132 - (4,012) - (96,873) - - 0.00% Fund balance, beginning year 1,880 4,012 4,012 - - - - 0.00% Fund balance, end of year 4,012 4,012 - - (96,873) - - 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 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (Fund 252): Building overhead (4350) Building overhead revenues 182,099 179,969 164,151 176,500 41 177,500 1,000 0.57% Building overhead expenditures 5,000 1,632 6,139 - 7,034 - - 0.00% Net Building Overhead Operations 177,099 178,337 158,012 176,500 (6,993) 177,500 1,000 0.57% Banquet Center (4730): Banquet revenues 43,849 75,740 84,276 80,000 57,130 80,000 - 0.00% Banquet Center expenditures 75,723 92,125 106,399 108,529 56,574 108,241 (288) -0.27% Net Banquet Center (31,874) (16,385) (22,123) (28,529) 556 (28,241) 288 -1.01% YMCA (4732): YMCA revenues 41,018 24,572 33,741 36,450 13,361 30,450 (6,000) -16.46% YMCA expenditures 206,086 207,627 196,866 226,494 116,433 225,771 (723) -0.32% Net YMCA (165,068) (183,055) (163,125) (190,044) (103,072) (195,321) (5,277) 2.78% Chamber of Commerce (4734): Chamber revenues 13,120 10,832 12,148 12,148 4,049 - (12,148) -100.00% Chamber expenditures 6,029 5,990 6,272 6,984 3,823 - (6,145) -87.99% Net Chamber of Commerce 7,091 4,842 5,876 5,164 226 - (6,003) -116.25% Creative Kids Child Care Center (4736): Creative Kids revenues 70,862 72,866 75,474 74,570 57,023 76,984 2,414 3.24% Creative Kids expenditures 34,565 34,607 33,151 37,661 19,461 36,582 (1,079) -2.87% Net Creative Kids 36,297 38,259 42,323 36,909 37,562 40,402 3,493 9.47% Total revenue 350,948 363,979 369,790 379,668 131,604 364,934 (14,734) -3.88% Total expenditures 327,403 341,981 348,827 379,668 203,325 370,593 (8,236) -2.17% Net change in fund balance 23,545 21,998 20,963 - (71,721) (5,659) (6,498) #DIV/0! Fund balance, beginning year 148,957 172,502 194,500 215,463 215,463 215,463 20,023 9.29% Fund balance, end of year 172,502 194,500 215,463 215,463 143,742 209,804 62,416 28.97% (continued) 54 2011 Budget Summary 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual 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 - 41 - - 0.00% 3972 Transfers from Sp. Projects - - - - - - - 0.00% 3972 Transfers 175,000 175,000 160,000 175,000 - 175,000 - 0.00% Total - Building revenues 182,099 179,969 164,151 176,500 41 177,500 1,000 0.57% Operating expenses Personnel services 0100 Salaries, regular 34,856 35,408 35,522 33,712 24,882 34,726 1,014 3.01% 0110 Salaries,overtime - - 380 1,621 521 1,670 49 3.02% 0300 Social Security 2,557 2,545 2,307 2,703 1,642 2,785 82 3.03% 0321 PERA 2,213 2,163 2,393 2,473 1,776 2,639 166 6.71% 0400 Group insurance 6,428 6,473 7,416 7,488 5,649 7,578 90 1.20% 0500 Workers compensation 1,260 1,196 1,359 1,552 1,558 1,540 (12) -0.77% 999 Allocation of salaries (47,314) (47,785) (49,377) (49,549) (31,977) (50,938) (1,389) 2.80% Total personnel services - - - - 4,051 - - 0.00% Materials & supplies 1210 Supplies, buildings & grounds 444 532 1,234 1,200 325 1,100 (100) -8.33% 1230 Supplies, equipment 180 1,339 748 400 27 400 - 0.00% 1600 Supplies, operating 7,281 8,387 10,170 5,800 4,657 7,000 1,200 20.69% 2400 Uniforms 634 337 604 450 240 550 100 22.22% 2410 Mats & towels 2,718 2,757 1,276 2,800 938 2,800 - 0.00% 2999 Allocation of supplies (11,257) (13,352) (14,032) (10,650) (4,904) (11,850) (1,200) 11.27% Total materials & supplies - - - - 1,283 - - 0.00% Contractual services 3030 Other professional services - 239 111 200 53 200 - 0.00% 3100 Telephone 2,778 3,338 3,372 3,000 2,424 3,000 - 0.00% 3200 Water & sewer 9,703 9,412 6,745 9,500 4,362 9,500 - 0.00% 3210 Electricity 50,301 52,182 51,585 54,000 29,812 53,000 (1,000) -1.85% 3220 Natural gas 23,296 22,275 13,126 25,500 8,479 23,000 (2,500) -9.80% 3530 Refuse collection 3,847 4,272 4,026 3,520 3,743 4,100 580 16.48% 3999 Allocation of utilities (83,665) (91,718) (72,826) (95,720) (48,000) (92,800) 2,920 -3.05% 5110 Repairs, building & grounds 13,680 10,533 11,832 21,250 8,991 18,000 (3,250) -15.29% 5130 Repairs, equipment 6,693 5,734 13,352 6,700 4,026 6,700 - 0.00% 5999 Allocation of repairs (26,633) (16,267) (25,184) (27,950) (12,190) (24,700) 3,250 -11.63% Total contractual services - - 6,139 - 1,700 - - 0.00% Capital 7030 Equipment 5,000 1,632 - - - - - 0.00% Total capital outlays 5,000 1,632 - - - - - 0.00% Total Building overhead expenditures 5,000 1,632 6,139 - 7,034 - - 0.00% Total Building Overhead Net 177,099 178,337 158,012 176,500 (6,993) 177,500 1,000 0.57% (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,200 Lights, signs, fertilizer 1,200 1,200 1,200 1,200 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 4,000 Commercial carpet cleaning service (twice annually) 6,180 6,180 6,180 6,180 Exterior building maintenance 750 750 750 750 Exterminator: 12 months X 62 2,000 2,000 2,000 2,000 Fire alarm system service 2,060 2,060 2,060 2,060 Parking lot & grounds maintenance 500 500 750 500 Security system service 21,010 21,250 21,500 21,250 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 - - - Roof over kitchen area (will not occur in 2007 carry over to 2008) 10,000 - - - 134,220 139,700 131,895 132,600 56 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual 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 57,130 80,000 - 0.00% 0.00% Total - Banquet revenues 43,849 75,740 84,276 80,000 57,130 80,000 - 0.00% Banquet Expenditures Personnel services 0999 Allocation of salaries 9,463 9,557 11,133 9,910 6,396 10,188 278 2.80% Total personnel services 9,463 9,557 11,133 9,910 6,396 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 1,473 3,318 336 11.27% Total materials & supplies 3,530 3,798 4,300 2,982 1,473 3,318 336 11.27% Contractual services 3030 Other professional services 25,105 35,356 58,014 50,149 25,789 51,075 926 1.85% 3100 Telephone 404 412 312 450 250 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 13,284 25,744 (818) -3.08% 4800 Bonding & insurance 1,806 1,720 1,786 2,100 1,610 2,100 - 0.00% 5110 Repairs, building & grounds 2,513 2,907 2,302 1,700 74 1,700 - 0.00% 5130 Repairs, equipment 545 2,975 981 1,600 274 1,600 - 0.00% 5999 Allocation of repairs 5,834 4,400 7,052 7,826 3,413 6,916 (910) -11.63% Total contractual services 62,730 73,403 90,966 91,637 44,694 90,735 (902) -0.98% Capital 7030 Equipment - 5,367 - 4,000 4,011 4,000 - 0.00% Total capital outlays - 5,367 - 4,000 4,011 4,000 - 0.00% Total Banquet expenditures 75,723 92,125 106,399 108,529 56,574 108,241 (288) -0.27% Total Banquet Center net (31,874) (16,385) (22,123) (28,529) 556 (28,241) 288 -1.01% 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 - 1,200 - - LCD Projectors (2) 4,000 5,200 4,000 4,000 77,487 101,779 98,618 76,334 58 (continued) 2011 Budget Summary 2007 2008 2009 2010 09/30/10 2011 Actual Actual Actual Budget Actual 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 4,086 7,000 (6,000) -46.15% 3661 Open gym participant fees 10,899 13,050 10,991 11,000 8,997 11,000 - 0.00% 3679 Commissions - vending 1,683 360 576 450 278 450 - 0.00% Total - YMCA revenues 41,018 24,572 33,741 36,450 13,361 30,450 (6,000) -16.46% YMCA Expenditures Personnel services - 0999 Allocation of salaries 32,647 32,972 32,812 34,189 22,064 36,675 2,486 7.27% Total personnel services 32,647 32,972 32,812 34,189 22,064 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 2,631 6,281 956 17.94% Total materials & supplies 8,711 6,826 7,108 5,325 2,631 6,281 956 17.94% Contractual services 3030 Other professional services 93,698 93,213 94,149 97,545 48,409 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 3,602 6,000 - 0.00% 3999 Allocation of utilities 45,777 46,373 37,928 48,760 24,558 49,994 1,234 2.53% 4800 Bonding & insurance 3,179 2,866 2,977 3,500 2,683 4,025 525 15.00% 5110 Repairs, building & grounds 3,559 5,451 608 12,000 178 5,000 (7,000) -58.33% 5130 Repairs, equipment 1,723 2,827 3,586 4,000 6,213 4,000 - 0.00% 5999 Allocation of repairs 10,276 8,358 12,592 13,975 6,095 13,091 (884) -6.33% Total contractual services 164,728 167,829 156,946 186,980 91,738 182,815 (4,165) -2.23% Total YMCA expenditures 206,086 207,627 196,866 226,494 116,433 225,771 (723) -0.32% Total YMCA net (165,068) (183,055) (163,125) (190,044) (103,072) (195,321) (5,277) 2.78% (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 4,000 10,000 10,000 2,000 Gym floor resurfacing & maintenance 4,000 12,000 12,000 5,000 5130 Repairs, equipment 2,650 2,650 2,650 2,650 Copier maintenance contract 1,000 1,000 1,000 1,000 Registration system support 350 350 350 350 Repairs to other equipment 4,000 4,000 4,000 4,000 5999 Allocation of repairs 13,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 189,096 60 2011 Budget Summary 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Chamber of Commerce (4734); Chamber of Commerce Revenues 3633 Lease - Chamber of Commerce 13,120 10,832 12,148 12,148 4,049 - (12,148) -100.00% Total - Chamber revenues 13,120 10,832 12,148 12,148 4,049 - (12,148) -100.00% Chamber of Commerce Expenditures Personnel services 0999 Allocation of salaries 1,419 1,433 1,481 1,486 959 - (1,486) -100.00% Total personnel services 1,419 1,433 1,481 1,486 959 - (1,486) -100.00% Materials & supplies 2999 Allocation of supplies 338 403 426 320 158 - (320) -100.00% Total materials & supplies 338 403 426 320 158 - (320) -100.00% Contractual services 3999 Allocation of utilities 2,657 2,699 2,194 2,782 1,411 - (2,782) -100.00% 4750 Taxes, licenses, & fees 998 954 968 1,032 518 - (1,032) -100.00% 4800 Bonding & insurance - - 447 525 402 - (525) -100.00% 5999 Allocation of repairs 617 501 756 839 375 - (839) -100.00% Total contractual services 4,272 4,154 4,365 5,178 2,706 - (4,339) -83.80% Total Chamber of Commerce expendituers 6,029 5,990 6,272 6,984 3,823 - (6,145) -87.99% Total Chamber of Commerce Net 7,091 4,842 5,876 5,164 226 - (6,003) -116.25% (continued) 61 2011 Budget Summary 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Creative Kids Child Care (4736): Child Care Revenues 3632 Lease - Child Care 70,862 72,866 75,474 74,570 57,023 76,984 2,414 3.24% Subtotal - Child Care revenues 70,862 72,866 75,474 74,570 57,023 76,984 2,414 3.24% Child Care Ed Expenditures Personnel services 0999 Allocation of salaries 3,785 3,824 3,950 3,964 2,558 4,075 111 2.80% Total personnel services 3,785 3,824 3,950 3,964 2,558 4,075 111 2.80% Materials & supplies 2999 Allocation of supplies 2,139 2,549 2,701 2,024 1,000 2,252 228 11.24% Total materials & supplies 2,139 2,549 2,701 2,024 1,000 2,252 228 11.24% Contractual services 3999 Allocation of utilities 16,509 16,842 13,637 17,617 8,829 17,062 (555) -3.15% 4750 Taxes, licenses, & fees 7,098 6,790 6,888 7,345 3,685 7,100 (245) -3.34% 4800 Bonding & insurance 1,129 1,146 1,191 1,400 1,073 1,400 - 0.00% 5110 Repairs, building & grounds - - - - - - - 0.00% 5999 Allocation of repairs 3,905 3,456 4,784 5,311 2,316 4,693 (618) -11.64% Total contractual services 28,641 28,234 26,500 31,673 15,903 30,255 (1,418) -4.48% Total Child Care expenditures 34,565 34,607 33,151 37,661 19,461 36,582 (1,079) -2.87% Total Child Care net 36,297 38,259 42,323 36,909 37,562 40,402 3,493 9.47% 62 EXPENSE ALLOCATIONS Creative Key Banquet YMCA Chamber Kids A 28%53%0%19% B 20%80% C 20%72%0%8% Creative Check Banquet YMCA Chamber Kids Total Key C 0100 C Wages, Full time employee 34,726 6,945 25,003 - 2,778 34,726 C 0200 C Overtime 1,670 334 1,202 - 134 1,670 C 0300 C Social Security 2,785 557 2,005 - 223 2,785 C 0321 C PERA 2,639 528 1,900 - 211 2,639 C 0400 C Group insurance 7,578 1,516 5,456 - 606 7,578 C 0500 C Workers compensation 1,540 308 1,109 - 123 1,540 50,938 10,188 36,675 - 4,075 1210 A Supplies, buildings & grounds 1,200 336 636 - 228 1,200 1230 A Supplies, equipment 400 112 212 - 76 400 A 1600 A Operating supplies 7,000 1,960 3,710 - 1,330 7,000 A 2400 A Uniforms & clothing 450 126 239 - 86 450 2410 A Mats & towels 2,800 784 1,484 - 532 2,800 11,850 3,318 6,281 - 2,252 A 3030 A Other professional services 200 56 106 - 38 200 B 3100 B Telephone 3,000 600 2,400 - - 3,000 A 3200 A Water & sewer 9,500 2,660 5,035 - 1,805 9,500 A 3210 A Electricity 53,000 14,840 28,090 - 10,070 53,000 A 3220 A Natural gas 23,000 6,440 12,190 - 4,370 23,000 A 3530 A Refuse collection 4,100 1,148 2,173 - 779 4,100 92,800 25,744 49,994 - 17,062 A 5110 A Repairs, building & grounds 18,000 5,040 9,540 - 3,420 18,000 A 5130 A Repairs, equipment 6,700 1,876 3,551 - 1,273 6,700 C 5160 C Repairs, system maintenance - - - - - - 24,700 6,916 13,091 - 4,693 180,288 46,166 106,041 - 28,082 180,288 2011 Budget Summary Community Center (Fund 252): 63 2011 Budget Summary Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Lakeside Park (Fund 255): Revenues 3370 Spring Lake Pk contribution 8,719 10,608 10,608 10,608 10,608 10,608 - 0.00% 3370 Mounds View contribution 8,719 10,608 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 604 150 - 0.00% Total revenue 18,241 22,076 21,911 21,666 21,820 21,666 - 0.00% Operating expenses (4350): Personnel services 0150 Salaries, part-time 2,263 2,853 3,360 3,349 3,780 3,349 - 0.00% 0300 Social security 173 218 257 256 289 256 - 0.00% 0500 Workers compensation 87 63 87 94 94 94 - 0.00% Total personnel services 2,523 3,134 3,704 3,699 4,163 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 636 1,400 - 0.00% 3210 Electricity 489 637 700 600 433 700 100 16.67% 3530 Refuse collection 148 48 48 400 118 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 319 550 50 10.00% 4800 Insurance 4,400 3,440 3,572 4,200 4,019 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 5,525 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 9,688 21,666 - 0.00% Net change in fund balance (1,620) 5,266 1,278 - 12,132 - - 0.00% Fund balance, beginning year 3,728 2,108 7,374 8,652 8,652 8,652 - 0.00% Fund balance, end of year 2,108 7,374 8,652 8,652 20,784 8,652 - 0.00% 64 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% 65 2011 Budget Summary Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual 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 6,047 8,488 (40) -0.47% 0300 Social security 319 388 388 652 381 646 (6) -0.92% 0321 PERA 330 342 342 597 423 612 15 2.51% 0400 Group insurance 1,443 1,420 1,420 2,164 1,625 2,190 26 1.20% 0500 Workers compensation 22 27 27 58 55 63 5 8.62% 0990 Severence pay - - - - - - 0.00% Total personnel services 7,119 7,700 7,700 11,999 8,531 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 - 1,387 - - 0.00% 3300 Postage 7,096 1,806 1,806 1,200 931 1,200 - 0.00% 3420 Advertisements - - - 1,545 - 1,545 - 0.00% 3430 Printing 552 4,158 4,158 1,301 520 1,301 - 0.00% 3530 Refuse collection 3,346 4,486 4,486 10,500 2,985 10,500 - 0.00% 3960 Awards - - - - - - - 0.00% Total contractual services 10,994 10,600 10,600 14,546 5,823 14,546 - 0.00% Capital 7030 Equipment - - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total expenses 24,611 22,620 22,620 26,545 14,354 26,545 - 0.00% Net change in fund balance (1,357) 4,129 4,129 - (14,354) - - 0.00% Fund balance, beginning year 15,548 14,191 18,320 18,320 18,320 18,320 - 0.00% Fund balance, end of year 14,191 18,320 22,449 18,320 3,966 18,320 - 0.00% 66 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 67 2011 Budget Summary Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual 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,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,625,423 6,422,423 (119,000) -1.82% 68 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 69 2011 Budget Summary Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 1 (Fund 410): Revenues 3101 Tax collections 1,211,260 1,200,245 1,493,611 1,392,826 779,469 1,434,611 41,785 3.00% 3101 Tax collections - Mermaid 74,726 166,058 156,520 - - 0.00% 3102 Taxes - delinquent 6,806 4,310 - 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 783,779 1,448,611 45,785 3.26% Operating expenses (4650): Contractual services 3030 Other professional 6,665 3,463 2,212 1,000 2,017 2,000 1,000 100.00% 5220 Highway 10 redevelopment 601,359 100,168 20,261 100,000 1,200 375,000 275,000 275.00% 7050 Construction - 276,499 3,664,138 765,000 269,013 1,829,287 1,064,287 139.12% 8010 Developer PAG, principal - 238,940 - 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 511,170 2,313,425 1,338,027 137.18% Net change in fund balance 552,936 958,874 (2,018,205) 427,428 272,609 (864,814) (1,669,217) -390.53% Fund balance, beginning year 1,093,432 1,646,368 2,605,242 587,037 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 859,646 149,651 (580,830) -57.25% 70 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 71 2011 Budget Summary Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 2 (Fund 420): Revenues 3101 Tax collections 148,957 128,125 143,266 151,698 80,301 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 80,301 156,835 2,637 1.71% Operating expenses (4650): Contractual services 3030 Other professional 5,311 1,375 1,240 1,200 1,559 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 42,602 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 44,161 155,091 6,042 4.05% Net change in fund balance 72,302 88,570 (72,472) 5,149 36,140 1,744 (74,762) -1451.98% Fund balance, beginning year 265,126 337,428 425,998 353,526 353,526 358,675 260,309 73.63% Fund balance, end of year 337,428 425,998 353,526 358,675 389,666 360,419 185,547 51.73% 72 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 73 2011 Budget Summary Y-T-D 2007 2008 2009 2010 09/30/10 2011 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 3 (Fund 430): Revenues 3101 Tax collections 425,172 367,643 351,862 328,408 185,413 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 185,413 380,824 39,916 11.71% Operating expenses (4650): Contractual services 3030 Other professional 5,807 915 987 1,200 920 1,200 - 0.00% 5220 Highway 10 redevelopment - 95,413 723,906 - 15,171 - - 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 16,091 733,794 623,197 563.48% Net change in fund balance 432,753 (52,607) (376,652) 230,311 169,322 (352,970) (713,816) -309.94% Fund balance, beginning year 461,417 894,170 841,563 464,911 464,911 695,222 377,860 81.28% Fund balance, end of year 894,170 841,563 464,911 695,222 634,233 342,252 (335,956) -48.32% Change from 2010 74 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 75 Y-T-D 2007 2008 2009 2010 09/30/10 2011 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 5 (Fund 450): Revenues 3101 Tax collections - 674,255 1,565,044 1,139,960 673,026 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 673,026 1,329,408 183,148 15.98% Operating expenses (4650): Contractual services 3030 Other professional - 1,284 1,109 1,200 1,517 1,400 200 16.67% 8010 Developer PAG, principal - 319,118 1,062,514 1,082,963 176,974 1,266,569 183,606 16.95% 8020 Developer PAG, interest - - - - 905,557 - - 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,084,048 1,333,989 192,829 16.90% Net change in fund balance - 323,526 449,660 5,100 (411,022) (4,581) (9,681) -189.82% Fund balance, beginning year - - 323,526 773,186 773,186 778,286 5,100 0.66% Fund balance, end of year - 323,526 773,186 778,286 362,164 773,705 (4,581) -0.59% 2011 Budget Summary Change from 2010 76 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 77 2011 Budget Summary Y-T-D 2007 2008 2009 2010 09/30/10 2011 Change from 2010 Actual Actual Actual Budget Actual 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 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 2,148,031 1,183,037 (415,560) -22.65% 78 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 - 26,300 Parks stump grinder $5,600, wood chipper $16,000, skid steer tracks $4,700 - 40,000 - 105,000 PW boom truck - - - 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 836,394 79 2007 2008 2009 2010 Y-T-D 2011 Change from 2010 Actual Actual Actual Budget 09/30/10 Request Dollar Percent GO Improvement Bonds of 2004A Debt Service (Fund 505): Revenues 3101 Property taxes 179,504 186,903 186,427 189,558 89,547 190,892 1,334 0.70% 3550 Spec assess prepayments 6,358 - - - - - 0.00% 3551 Spec assess current 67,839 127,575 38,326 25,652 18,458 25,652 - 0.00% 3552 Spec assess delinquent 2,213 - 1,041 - - - 0.00% 3553 Spec assess penalty & int 526 - 282 - - - 0.00% 3610 Investment income 14,432 11,564 6,822 9,375 8,750 (625) -6.67% Total revenue 270,872 326,042 232,898 224,585 108,005 225,294 709 0.32% Operating expenses (4650): Contractual services 8010 Debt, principal 215,000 215,000 215,000 220,000 220,000 225,000 5,000 2.27% 8020 Debt, interest 62,883 57,239 51,058 44,423 44,423 37,300 (7,123) -16.03% 8030 Paying agent 431 431 431 475 431 475 - 0.00% 8040 Continuing disclosure 983 982 1,138 1,500 1,164 1,500 - 0.00% Total contractual services 279,297 273,652 267,627 266,398 266,018 264,275 (2,123) -0.80% Net change in fund balance (8,425) 52,390 (34,729) (41,813) (158,013) (38,981) 2,832 -6.77% Fund balance, beginning year 415,853 407,428 459,818 425,089 383,276 383,276 (41,813) -9.84% Fund balance, end of year 407,428 459,818 425,089 383,276 225,263 344,295 (38,981) -10.17% 2011 Budget Summary 80 Y-T-D 2007 2008 2009 2010 09-30-10 2011 Change from 2010 Actual Actual Actual Budget Actual 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 1,764,952 - - 0.00% Total capital outlays - - - 2,750,000 1,764,952 - - 0.00% Total expenses 650 - - 2,750,000 1,764,952 - (78,000) -2.84% Net change in fund balance 142,489 112,667 60,696 (2,682,750) (1,764,952) - 49,264 -1.84% Fund balance, beginning year 2,373,460 2,515,949 2,628,616 2,689,312 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 924,360 6,562 (2,260,813) -34452.90% 2011 Budget summary 81 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 - 82 Y-T-D 2007 2008 2009 2010 09-30-10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Special Projects (Fund 280): Revenues 3551 Spec assessmt current 3,826 3,591 - 48 - 0.00% 3552 Spec assessmt delinquent 83 - 73 - 0.00% 3553 Spec assessmt penalty & interest 20 - 12 18 - 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 66 17,000 (13,000) -43.33% Operating expenses Operations (4180): Contractual services 3030 Other professional services 18,481 22,260 1,116 - 16 10,000 10,000 #DIV/0! 5130 Repairs; Equipment 313 140 - - - - 0.00% Total contractual services 18,794 22,400 1,116 - 16 10,000 10,000 #DIV/0! Capital 7030 Capital equipment 651 27,092 84,949 25,000 40,000 15,000 60.00% 7050 Construction 94,804 31,379 6,977 424,000 18,080 285,000 (139,000) -32.78% Total capital outlays 95,455 58,471 91,926 449,000 18,080 325,000 (124,000) -27.62% 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 18,096 425,000 (114,000) -21.15% Net change in fund balance (13,681) (103,120) (64,681) (509,000) (18,030) (408,000) 101,000 -19.84% Fund balance, beginning year 1,510,752 1,497,071 1,393,951 1,329,270 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 1,311,240 412,270 (408,000) -49.74% 2011 Budget Summary 83 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 - - - - On-line bill pay software 42,000 7,500 - - Purchase copier (1) lease expires in July 2009 - 25,000 25,000 Community center furniture replacement - - - 40,000 Alternative Power Supply Project (60,000 in water & sewer) 5,067 - - - Laserfiche software upgrade (one-time pay to Roseville) 47,067 32,500 25,000 40,000 7050 Construction - - 30,000 - Community center parking lot improvements - - 15,000 - Lambert Park building (preconstruction)(50% in Park Dedication) - - - 18,000 City Hall grading (carryover from CH proj.) 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) - - - 100,000 City Hall and Community Center roof replacement/repair 163,000 385,500 424,000 285,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 84 Y-T-D 2007 2008 2009 2010 09-30-10 2011 Change from 2010 Actual Actual Actual Budget Actual Request Dollar Percent Street Improvement (Fund 285): Revenues 3101 Property taxes - - - 300,000 139,782 300,000 - 0.00% 3180 Franchise fee 273,540 283,796 235,002 287,000 135,179 249,900 (37,100) -12.93% 3319 Other federal grants - - 463,438 - 0.00% 3352 MSA street construction - - 1,157,743 365,000 425,115 383,000 18,000 4.93% 3359 Other state grants - - - - 0.00% 3360 Other county grant - - 216,973 - 0.00% 3550 Spec assessmt prepayment - - 209,822 9,509 - 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 - 25,377 - - 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 734,962 1,332,900 8,400 0.63% 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 146,307 767,000 220,000 40.22% Total capital outlays 224,470 325,219 572,522 547,000 146,307 767,000 220,000 40.22% Total expenses 270,047 580,563 675,848 547,000 146,307 767,000 220,000 40.22% Net change in fund balance 166,082 (60,250) 2,035,591 777,500 588,655 565,900 (211,600) -27.22% Fund balance, beginning year 2,580,534 2,746,616 2,686,366 4,721,957 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$ 5,310,612$ 6,065,357$ 565,900$ 10.29% 2011 Budget Summary 85 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 244,900 Half of the 3.87% franchase fee on gas & electric utilities 310,000 290,625 287,000 244,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 Estimated interest earnings at 2.50%. 93,750 93,750 72,500 - 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 86 Y-T-D 2007 2008 2009 2010 09-30-10 2011 Change from 2010 Actual Actual Actual Budget Actual 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 33,892 - 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 33,892 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 25,280 310,000 245,000 376.92% Total capital outlays 200,980 45,322 5,986 65,000 25,280 310,000 245,000 376.92% Total expenses 202,652 45,871 5,986 65,000 25,280 310,000 245,000 376.92% Net change in fund balance (133,295) 10,903 18,798 (39,000) 8,612 (289,000) (250,000) 641.03% Fund balance, beginning year 1,013,260 879,965 890,868 909,666 909,666 870,666 (39,000) -4.29% Fund balance, end of year 879,965$ 890,868$ 909,666$ 870,666$ 918,278$ 581,666$ (289,000)$ -33.19% 2011 Budget Summary 87 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 - - - - Oakwood Park Soccer Field and Park rehabilitation project 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 88 2007 2008 2009 2010 Y-T-D 2011 Change from 2010 Actual Actual Actual Budget 09/30/10 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 26,545 50,000 - 0.00% 3552 Spec assessments-delinquent 4,052 7,300 31,639 - 1,363 - - 0.00% 3553 Spec assess.-penalty & interest 373 464 1,559 - 264 - - 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 18,316 - (59,197) -100.00% 3680 Other revenues 3,666 2,939 788 2,000 2,655 2,000 - 0.00% 3710 Water sales 652,650 683,665 683,987 737,052 457,242 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 40,316 51,500 - 0.00% 3715 Utility connections 970 805 480 1,250 300 1,000 (250) -20.00% 3716 Penalties (758) 8,561 8,594 - 9,948 - - 0.00% 3912 Sale of materials - - - - - - - 0.00% 3913 Meter sales 1,020 1,020 763 - 4,160 - - 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 561,109 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 23,350 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 1,681 2,529 (38) -1.48% 0321 PERA 1,889 1,895 2,196 2,349 1,621 2,396 47 2.00% 0400 Group insurance 2,288 2,389 2,803 4,285 2,175 4,387 102 2.38% 0500 Workers compensation 184 138 168 197 197 222 25 12.69% 0990 Severance - - - - - 0.00% Total personnel services 36,446 37,565 40,796 42,949 29,024 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 6,476 7,815 180 2.36% 3300 Postage 3,020 2,974 2,710 3,190 2,209 3,256 66 2.07% 3430 Printing 933 1,093 680 900 980 900 - 0.00% 3630 Training - - - 250 - 250 - 0.00% 5130 Repairs, equipment 2,487 2,737 3,128 3,174 2,880 3,332 158 4.98% Total contractual services 12,758 14,819 12,852 15,149 12,545 15,553 404 2.67% Debt Service: 8010 Principal 185,000 190,000 200,000 205,000 205,000 210,000 5,000 2.44% 8020 Interest 40,935 35,325 29,350 25,570 25,570 18,825 (6,745) -26.38% 8030 Paying agent fees 431 431 431 475 431 475 - 0.00% 8040 Continuing disclosure 983 1,675 1,138 2,150 1,164 2,150 - 0.00% Total capital outlays 227,349 227,431 230,919 233,195 232,165 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 20,000 - 0.00% Total capital outlays 76,422 78,115 79,859 81,655 - 83,505 1,850 2.27% Total Billing 352,975 357,930 364,430 372,998 273,734 373,150 152 0.04% 2011 Budget Summary 89 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 90 2007 2008 2009 2010 Y-T-D 2011 Change from 2010 Actual Actual Actual Budget 09/30/10 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 114,853 168,844 2,248 1.35% 0110 Salaries, overtime 4,563 15,168 15,195 9,002 6,703 9,002 - 0.00% 0150 Salaries, part-time 31,290 11,667 16,474 18,475 10,941 18,475 - 0.00% 0300 Social security 13,486 13,735 12,845 14,847 9,280 15,019 172 1.16% 0321 PERA 10,145 9,974 11,637 12,564 8,492 13,176 612 4.87% 0400 Group insurance 21,109 21,482 25,145 28,450 20,630 28,828 378 1.33% 0500 Workers compensation 4,004 4,174 5,048 5,764 5,785 6,141 377 6.54% 600 Unemployment - - - - - - - 0.00% 990 Severence - - - - - - - 0.00% Total personnel services 248,414 235,380 239,488 255,698 176,684 259,485 3,787 1.48% Materials & supplies 1210 Supplies, bldg & grnds 2,154 1,668 3,174 3,300 1,100 5,300 2,000 60.61% 1220 Supplies, vehicles 409 191 593 800 346 800 - 0.00% 1230 Supplies, equipment 795 264 1,579 818 864 818 - 0.00% 1240 Supplies, streets 1,538 2,349 1,247 3,000 1,323 5,000 2,000 66.67% 1250 Supplies, utilities 7,397 9,786 5,902 7,500 5,489 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 2,200 4,300 1,000 30.30% 1700 Motor fuels 3,247 8,383 2,832 4,713 2,883 4,800 87 1.85% 2400 Uniforms 1,302 1,021 1,239 1,380 491 1,380 - 0.00% 2410 Mats & towels 758 1,140 1,427 800 1,014 800 - 0.00% Total materials & supplies 21,342 27,971 24,782 25,811 15,710 35,148 9,337 36.17% Contractual services 3030 Other professional services 6,942 470 8,272 14,150 4,252 12,350 (1,800) -12.72% 3100 Communications - telephone 10,091 4,515 1,909 1,680 1,618 1,780 100 5.95% 3200 Water & wastewater charges 5,765 7,002 8,030 5,000 4,518 5,000 - 0.00% 3220 Natural gas 8,695 11,964 10,792 12,000 4,075 12,000 - 0.00% 3610 Memberships 514 280 261 433 235 353 (80) -18.48% 3630 Training 2,639 896 943 2,785 544 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 7,841 10,230 - 0.00% 5130 Repairs, equipment 4,684 5,738 6,309 2,950 5,363 2,500 (450) -15.25% 5140 Repairs, streets 5,226 3,700 12,500 10,000 18,219 10,000 - 0.00% 5150 Repairs, utilities 8,301 2,138 6,337 5,200 6,904 1,800 (3,400) -65.38% 5155 Water service repair 39,934 55,824 41,271 50,000 25,312 50,000 - 0.00% 5160 Repairs, system maintenance - 980 2,650 15,000 5,089 15,000 - 0.00% Total contractual services 107,924 102,216 110,432 133,228 83,970 128,163 (5,065) -3.80% Capital outlays 7030 Equipment - - - 138,000 1,911 28,500 (109,500) -79.35% 7050 Construction - - - 393,700 59,940 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 61,851 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 338,215 2,003,996 827,559 64.83% 91 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 92 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 93 2007 2008 2009 2010 Y-T-D 2011 Change from 2010 Actual Actual Actual Budget 09/30/10 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 25,232 32,778 850 2.66% 1700 Motor fuels 428 616 310 3,922 553 2,700 (1,222) -31.16% Total materials & supplies 18,967 26,216 31,317 35,850 25,785 35,478 (372) -1.04% Contractual services 3030 Other professional services 15,190 12,307 23,991 31,530 11,277 37,230 5,700 18.08% 3210 Electricity 77,231 79,853 74,990 75,510 43,381 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 54,658 114,430 7,190 6.70% Total water production 111,388 118,376 130,298 143,090 80,443 149,908 6,818 4.76% Total expenditures 1,050,363 1,081,712 1,189,805 1,792,525 692,392 2,527,054 834,529 46.56% Revenues over (under) expenditures (80,947) (158,223) (228,342) (860,276) (131,283) (1,365,252) (604,976) 70.32% Add back: capital outlays - - - 531,700 61,851 1,241,200 709,500 133.44% principal payment on debt 185,000 190,000 200,000 205,000 205,000 210,000 5,000 2.44% Change in net assets 104,053 31,777 (28,342) (123,576) 135,568 85,948 209,524 -169.55% Net Assets, beginning year 4,467,969 4,572,022 4,603,799 4,575,457 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,711,025$ 4,537,829$ 85,948$ 1.93% 94 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 95 2011 Budget Summary 2007 2008 2009 2010 Y-T-D 2011 Change from 2010 Actual Actual Actual Budget 09/30/10 Request Dollar Percent Sanitary Sewer (Fund 730): Revenues 3551 Spec. Assessments - - 2,125 1,794 - 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 - 14,660 - - 0.00% 3720 Utility sales 1,038,773 1,101,413 1,138,858 1,138,145 873,583 1,209,106 70,961 6.23% 3721 SAC charges (3,251) 7,405 (15,480) 4,000 2,001 4,000 - 0.00% 3722 Unit charges - - - - - 0.00% 3725 Utility connections 300 300 180 300 240 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 892,278 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 23,350 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 1,681 2,529 (38) -1.48% 0321 PERA 1,894 1,901 2,200 2,349 1,621 2,396 47 2.00% 0400 Group insurance 2,284 2,400 2,812 4,285 2,176 4,387 102 2.38% 0500 Workers compensation 184 138 168 197 198 222 25 12.69% 0990 Severance - - - - - 0.00% Total personnel services 36,530 37,680 40,874 42,949 29,026 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 6,476 7,440 205 2.83% 3300 Postage 3,020 2,974 2,710 3,190 2,209 3,256 66 2.07% 3430 Printing 933 1,093 680 900 980 900 - 0.00% 3630 Training - - - 250 230 250 - 0.00% 5130 Repairs, equipment 2,487 2,589 3,128 3,174 2,880 3,332 158 4.98% Total contractual services 11,558 12,851 12,852 14,749 12,775 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 41,801 144,118 1,537 1.08% Infrastructure & Equip Maintenance (4823): Personnel services 100 Salaries, regular 155,003 139,887 148,658 159,920 110,765 162,168 2,248 1.41% 110 Salaries, overtime 2,010 1,345 5,215 7,221 5,135 7,221 - 0.00% 150 Salaries, part-time - 1,060 7,511 11,100 9,942 11,100 - 0.00% 300 Social security 10,926 10,774 11,580 13,635 9,312 13,807 172 1.26% 321 PERA 9,608 8,192 10,655 11,972 8,098 12,563 591 4.94% 400 Group insurance 19,357 16,323 19,268 26,938 16,782 27,406 468 1.74% 500 Workers compensation 3,615 3,813 4,552 5,228 5,247 5,554 326 6.24% 600 Unemployment - - - - - - - 0.00% 990 Severence - - - - - - - 0.00% Total personnel services 200,519 181,394 207,439 236,014 165,281 239,819 3,805 1.61% 96 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 97 2011 Budget Summary 2007 2008 2009 2010 Y-T-D 2011 Change from 2010 Actual Actual Actual Budget 09/30/10 Request Dollar Percent Sanitary Sewer (Fund 730): Materials & supplies 1210 Supplies, bldg & grnds 106 155 90 700 39 200 (500) -71.43% 1220 Supplies, vehicles 1,295 2,180 1,756 1,275 755 1,275 - 0.00% 1230 Supplies, equipment 1,183 290 3,243 2,800 891 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 657 1,950 - 0.00% 1260 Supplies, traffic control - - - 300 - 300 - 0.00% 1600 Supplies, operating 2,212 2,991 1,806 3,650 1,897 4,300 650 17.81% 1700 Motor fuels 7,373 4,109 4,859 7,150 4,108 7,150 - 0.00% 2400 Uniforms 1,325 887 1,175 1,438 576 1,438 - 0.00% 2410 Mats & towels 758 1,134 1,427 800 1,014 800 - 0.00% Total materials & supplies 19,783 13,126 15,421 21,413 9,937 21,513 100 0.47% Contractual services 3030 Other professional services 511 136 1,452 12,750 622 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 960 1,430 100 7.52% 3200 Water & sewer 2,221 2,456 2,911 1,200 2,024 1,200 - 0.00% 3210 Electricity 1,512 1,866 2,072 1,888 1,138 2,100 212 11.23% 3230 Wastewater disposal - Met Council 637,078 696,031 733,120 776,845 582,634 776,066 (779) -0.10% 3610 Memberships 141 - 63 178 64 230 52 29.21% 3630 Training 1,535 1,530 513 3,230 324 3,105 (125) -3.87% 4010 Equipment rental - - - 1,000 - 1,000 - 0.00% 4800 Insurance 8,090 10,381 6,163 7,246 5,605 7,300 54 0.75% 5130 Repairs, equipment 12,215 9,987 20,222 11,300 1,631 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 4,960 140,000 (52,500) -27.27% Total contractual services 688,257 779,662 782,404 1,014,467 599,962 954,531 (59,936) -5.91% Capital outlays 7030 Equipment - - - 335,000 8,175 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 8,175 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 783,355 1,888,363 (58,531) -3.01% Total expenditures 1,190,407 1,320,674 1,450,390 2,089,475 825,156 2,032,481 (56,994) -2.73% Revenues over (under) expenditures 63,905 (35,133) (193,477) (544,530) 67,122 (429,075) 115,455 -21.20% Add back: capital outlays - - - 335,000 8,175 337,500 2,500 0.75% Change in net assets 63,905 (35,133) (193,477) (209,530) 75,297 (91,575) 117,955 -56.30% Net Assets, beginning of year 5,685,272 5,749,177 5,714,044 5,520,567 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,595,864$ 5,219,462$ 26,380$ 0.50% 98 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 99 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 100 2007 2008 2009 2010 Y-T-D 2011 Change from 2010 Actual Actual Actual Budget 09/30/10 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 - 914 - - 0.00% 3740 Street lighting charges 75,786 76,963 76,520 74,000 57,741 74,000 - 0.00% Total revenue 83,018 84,087 80,526 76,000 58,655 76,000 - 0.00% Operating expenses Operations (4416) Personnel services 0100 Salaries, regular 2,475 2,670 2,753 2,718 1,888 2,638 (80) -2.94% 0110 Salaries, overtime - - 18 - - - - 0.00% 0300 Social security 160 192 185 208 131 202 (6) -2.88% 0321 PERA 165 166 183 190 132 191 1 0.53% 0400 Group insurance 439 433 499 499 374 505 6 1.20% 0500 Workers compensation 15 13 15 18 18 19 1 5.56% 0990 Severence pay - - - - 0.00% Total personnel services 3,254 3,474 3,653 3,633 2,543 3,555 (78) -2.15% Contractual services 3030 Other professional services - - 0.00% 3210 Electricity 63,207 66,125 71,816 68,700 45,091 72,000 3,300 4.80% 4800 Insurance 775 737 765 900 690 900 - 0.00% 5150 Repairs, utilities - - 3,464 - 934 - - 0.00% Total contractual services 63,982 66,862 76,045 69,600 46,715 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 49,258 78,707 3,288 4.36% Revenues over (under) expenditures 13,782 11,691 (1,294) 581 9,397 (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 9,397 (2,707) (3,288) -565.92% Net assets, beginning year 133,761 147,543 159,234 157,940 157,940 158,521 581 0.37% 0.00% Net assets, end of year 147,543$ 159,234$ 157,940$ 158,521$ 167,337$ 155,814$ (2,707)$ -1.71% 2011 Budget Summary 101 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 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 102 2007 2008 2009 2010 Y-T-D 2011 Change from 2010 Actual Actual Actual Budget Actual 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 - 2,848 - - 0.00% 3730 Surface water charges 208,953 222,137 241,384 250,718 195,113 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 197,961 312,718 (3,000) -0.95% Operating expenses System Maintenance (4415): Personnel services 0100 Salaries, regular 48,304 54,235 49,958 47,562 34,042 47,562 - 0.00% 0110 Salaries, overtime 1,067 123 1,293 1,083 638 1,083 - 0.00% 0150 Salaries, part-time 4,448 4,792 6,263 4,920 5,264 4,920 - 0.00% 0300 Social security 4,036 4,534 4,329 4,097 3,029 4,097 - 0.00% 0321 PERA 3,302 3,265 3,428 3,405 2,423 3,527 122 3.58% 0400 Group insurance 4,611 4,759 5,907 7,570 4,834 7,798 228 3.01% 0500 Workers compensation 2,676 2,852 3,266 3,891 3,905 3,893 2 0.05% 0990 Severence pay - - - - - - 0.00% Total personnel services 68,444 74,560 74,444 72,528 54,135 72,880 352 0.49% Materials & supplies 1230 Supplies, equipment 132 1,695 81 1,500 73 2,000 500 33.33% 1240 Supplies, streets 432 - - 600 - 600 - 0.00% 1600 Supplies, operating 412 1,345 167 2,500 797 2,200 (300) -12.00% 1700 Motor fuels 1,016 3,720 2,388 2,250 2,604 2,750 500 22.22% 2100 Books/Periodicals - - - 150 - 100 (50) -33.33% 2400 Uniforms 966 420 723 1,188 285 1,188 - 0.00% 2410 Mats & towels 758 1,137 1,427 800 1,014 800 - 0.00% Total materials & supplies 3,716 8,317 4,786 8,988 4,773 9,638 650 7.23% Contractual services 3030 Other professional services 9,888 15,032 12,698 21,600 553 17,500 (4,100) -18.98% 3100 Telephone 2,110 1,379 1,143 1,200 929 1,250 50 4.17% 3610 Memberships 831 690 753 868 64 750 (118) -13.59% 3630 Training 459 324 365 1,700 167 3,410 1,710 100.59% 4800 Insurance 1,627 1,556 1,616 1,900 6,680 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 8,393 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 67,301 229,328 (62,456) -21.40% 0.00% 2011 Budget Summary 103 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 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 104 2007 2008 2009 2010 Y-T-D 2011 Change from 2010 Actual Actual Actual Budget Actual 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 5,614 7,510 - 0.00% 0110 Salaries, overtime 34 - 292 1,083 189 1,083 - 0.00% 0150 Salaries, part-time - - - 240 - 240 - 0.00% 0300 Social security 543 662 610 676 408 676 - 0.00% 0321 PERA 527 531 577 602 406 623 21 3.49% 0400 Group insurance 1,054 1,061 1,278 1,195 994 1,231 36 3.01% 0500 Workers compensation 439 469 545 641 643 642 1 0.16% 0990 Severence pay - - - - - - 0.00% Total personnel services 10,486 11,154 11,358 11,947 8,254 12,005 58 0.49% Materials & supplies 1230 Supplies, equipment (4) 94 2,150 200 1,614 200 - 0.00% 1600 Supplies, operating 1,855 1,493 605 1,100 1,504 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 3,118 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 8,175 40,000 - 0.00% Total capital outlays - - - 40,000 8,175 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 19,547 82,273 4,713 6.08% Total expenditures 146,293 212,951 197,372 369,344 86,848 311,601 (57,743) -15.63% Revenues over expenditures 129,566 69,425 79,147 (53,626) 111,113 1,117 54,743 -102.08% Add back: Capital outlays - - - 88,000 8,175 40,000 (48,000) -54.55% Change in net asssets 129,566 69,425 79,147 34,374 119,288 41,117 6,743 19.62% Net assets, beginning year 2,513,042 2,642,608 2,712,033 2,791,180 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,910,468$ 2,866,671$ 41,117$ 1.46% 105 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 106 Item No: 6 Meeting Date: October 4, 2010 Type of Business: Council Work Session Administrator Review: ____ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Don Peterson Public Works Supervisor Item Title/Subject: Vehicle and Equipment Replacement Program Background: The City established a vehicle and equipment replacement program for the following reasons: 1. To keep repair and replacement costs down on older vehicles and equipment. 2. To assist the Public Works Department in efficiency so that tasks can be performed quicker and safer. With the existing program, vehicles and equipment were replaced after ten years of service regardless of the condition or maintenance history. The year for replacement was assigned at the time of purchase. While this may have been a normal practice by many City, County and State agencies in years past, the economy today has forced many of these agencies to re-visit their vehicle and equipment replacement program. While reviewing each individual department budget with Public Works Staff, the vehicle replacement program was discussed. One item that was suggested is to extend the years of replacement on some of the vehicles and equipment and shorten years on others. In order to make the best decision for replacing vehicles and equipment, the process for replacement is required to be redefined. The replacement program requirements should include the following: 1) The use of the vehicle and equipment a) Daily b) Heavy or Light c) Special projects only 2) Maintenance history a) Is the unit costing money in repairs 3) Condition of the vehicle a) Each vehicle and equipment will be subject to an annual inspection 4) Impact on the budget a) Can the purchase be postponed or is this an immediate need Discussion: Attached to this staff report is a 5 year replacement plan. This plan should be used as a guide and will need to be re-visited and adjusted accordingly each budget cycle as circumstances change year to year. (The current needs for the department are listed on the 2010 and 2011 pages.) Resolution 7593 Awarding Construction Contract for 2010 Well No. 1 & 2 Rehabilitation Project March 22, 2010 Page 2 Recommendation: Staff recommends that the City Council review the redefined vehicle and equipment replacement plan and consider approving it at the next regularly scheduled City Council Meeting. Respectfully submitted, Don Peterson Public Works Supervisor Attachments: Copy of 5 year vehicle /equipment plan 1 Item No: 07 Meeting Date: October 4, 2010 Type of Business: Work Session Administrator Review: ____ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Thomas Kinney, Chief of Police Item Title/Subject: Police Command Structure Discussion: The police department has an authorized staff of 19 full time sworn officers. This change took effect in 2003 when a referendum was placed before the residents who voted to increase the authorized strength of the department from 17 officers to 19 officers. The voters approved an increase in taxes for this addition of 2 officers. The major benefit to this action was an increase in the minimum staffing levels of officers covering the street. Prior to this action, there were times when only one officer was assigned for short periods of time. With the approved officers, a two person minimum was possible 24 hours every day. While we are still able to staff the two officer minimum, the supervisory structure has been substantially impacted with retirements of former Chief Mike Sommer on October 30, 2009 and Sergeant Mike Kampa on July 30, 2010. The loss of two senior supervisory positions has left only three remaining supervisory positions. The current authorized rank structure of the department is the following: 1 Chief 1 Deputy Chief 3 Sergeants However, we currently are structured as: 1 Chief 2 Sergeants This is an inadequate management structure for a department this size serving a population of 13,000. In order to provide comparisons with other agencies of similar sizes the following chart can be referenced: COMMAND STRUCTURE Agency Supervisors Authorized Sworn Officers Current Sworn Officers Population Centennial Lakes Chief Captain 3 Sergeants 17 16 10,500 Columbia Heights Chief Captain 3 Sergeants 2 Corporals 28 28 18,520 2 Crystal Chief Deputy Chief 2 Lieutenants 4 Sergeants 30 29 23,000 Hopkins Chief Captain 5 Sergeants 27 26 17,145 Mendota Heights Chief 3 Sergeants 18 18 13,000 Mound Chief Lieutenant 2 Sergeants 14 12 9,700 North St Paul Chief 4 Sergeants 18 17 11,500 Ramsey Chief Captain Lieutenant 4 Sergeants 23 23 24,000 Robbinsdale Chief Captain 4 Sergeants 22 21 14,123 St. Anthony Chief Captain Lieutenant 2 Sergeants 23 23 17,000 Spring Lake Park Chief 2 Sergeants 11 10 6,500 Many of these agencies have 4-6 supervisors in place for comparably sized communities. It is clear that our current staff of three supervisors is grossly under the staffing levels of other departments. A second in command position is in place in many of the agencies. While the title of the position varies from Captain or Lieutenant, the duties and responsibilities remain essentially the same. This Deputy Chief position is critical in the administration of the daily operations of the police department while holding the appropriate rank to exercise supervision over sergeants and patrol officers. One key duty this position handles is the investigation of internal affairs and employee misconduct complaints. It is simply impractical for the Police Chief to investigate these matters and also exercise a final decision with potential discipline. The existence of a position of rank between the officer and/or sergeant and the Chief should not be abolished. The necessity for this position to exist in the instance of internal investigations is critical in filling the gap between Police Chief and other subordinate officers. Having a position of rank such as the Deputy Chief allows internal investigations to be conducted on officers without any question of superior rank. The second in command is essential in managing the administrative duties affecting clerical staff, investigations and patrol staff. The officer holding this position steps in as commanding officer during the absence of the Police Chief. Presently, the lack of a second in command leaves a gap in the next logical officer to assume command. This can leave uncertainty with staff on the appropriate person in charge. The Deputy Chief (or second in command) can also be shifted to duties to include more 3 street functions that may not have been as much a part of past regular duties. Currently, most of the day shift hours do not have a patrol supervisor on duty, as the sergeants are typically scheduled during the night shifts. A second in command can assume more of these activities. However, most of the work and responsibilities will involve administrative functions such as equipment and supply maintenance, oversight of scheduling and a review and tracking of departmental training and timesheets. This position maintains a schedule consistent with general office hours, ensuring the supervision of personnel and availability to the public during regular business hours. The position of patrol sergeant that is vacant is also a critical and essential position requiring filling as soon as practical. A supervisor in place for the patrol officers can reduce the potential liability with employees who remain unsupervised. The department currently has 9 officers with 6 or less years experience. Providing proper supervision of employees is an obligation the city must adhere to in order to reduce the risk and potential costs the city may encounter. Having an experienced supervisor in place for as many of those hours as possible was a goal enacted 5 years ago. Presently our two sergeants work the majority of their shifts during the evening, but do adjust their hours to fill holes in coverage when another officer is off for various reasons (sick, training, approved vacation, etc.). The third sergeant enables a wider more complete coverage of hours overall. Both positions of Deputy Chief and sergeant can be filled from within the department by conducting a promotion process similar to past procedures in conducting promotions. There are qualified candidates employed by this department who would make excellent supervisors. A logical first step in accomplishing all of this is to compile an eligibility list for an entry level police officer. Resolution 7634 was approved by the City Council on June 28, 2010, authorizing to advertise and create an eligibility list for a police officer. This process has not been initiated due to the uncertainty in whether a candidate would be hired from any list established. An internal promotion to fill the Deputy Chief position would essentially remove an officer from a street patrol or other specialty assignment position. To avoid creating a gap in these areas, it would be in the best interests for all to initially hire a replacement officer(s) before this promotion would occur. However, the sergeant promotion process could essentially begin prior to a new officer hire. This sergeant would still handle patrol duties so the numbers of officers assigned to patrol would not decrease by promoting an officer to the rank of sergeant. Recommendation: Staff seeks direction from the council for future action in filling vacant command positions to include a Deputy Chief and patrol sergeant from within the police department. Staff also seeks clarification on whether a candidate can be hired for the filling of a police officer position from a yet to be created eligibility list. Respectfully Submitted, __________________ Thomas Kinney Chief of Police