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 - 2012/12/03 (2)
CITY OF MOUNDS VIEW SPECIAL CITY COUNCIL MEETING AGENDA MOUNDS VIEW CITY HALL Monday, December 3, 2012 6:00 PM 1. CALL TO ORDER 2. PLEDGE OF ALLEGIANCE 3. ROLL CALL: Flaherty, Stigney, Hull, Mueller, Gunn 4. APPROVAL OF AGENDA 5. PUBLIC INPUT: Citizens may speak to issues not on tonight’s agenda. Before speaking, please give your full name and address for the minutes. Also, please limit your comments to three minutes. 6. SPECIAL ORDER OF BUSINESS 7. COUNCIL BUSINESS A. Truth in Taxation 8. Next Council Work Session: After this Meeting Next Council Meeting: Monday December 10, 2012, at 7 p.m. 9. ADJOURNMENT CITY OF MOUNDS VIEW, MINNESOTA Combined 2013 Budget All Funds Special Debt Capital Total Total General Revenue Service Projects Government Enterprise All Fund Funds Funds Funds Funds Funds Funds Revenues: Property taxes 3,690,581$ -$ 190,800$ 300,000$ 4,181,381$ -$ 4,181,381$ Tax increments - 3,652,524 - - 3,652,524 - 3,652,524 All other taxes 336,000 - - 253,000 589,000 - 589,000 Special assessments - - 32,556 20,000 52,556 50,000 102,556 Licenses & permits 180,492 - - - 180,492 - 180,492 Intergovernmental: State categorical aid 290,671 - - 383,000 673,671 - 673,671 County grants - 25,133 - - 25,133 - 25,133 Other local govt.69,000 21,216 - - 90,216 - 90,216 Charges for services: Culture and recreation - 194,804 - - 194,804 - 194,804 Utility service charges - - - - - 2,459,251 2,459,251 Miscellaneous 18,715 - - - 18,715 4,300 23,015 Fines 31,300 6,000 - - 37,300 - 37,300 Investment income 193,000 26,300 2,500 96,500 318,300 80,500 398,800 Miscellaneous: Other 235,002 5,350 - 6,000 246,352 - 246,352 Total revenues 5,044,761$ 3,931,327$ 225,856$ 1,058,500$ 10,260,444$ 2,594,051$ 12,854,495$ 1 CITY OF MOUNDS VIEW, MINNESOTA Combined 2013 Budget All Funds Special Debt Capital Total Total General Revenue Service Projects Government Enterprise All Fund Funds Funds Funds Funds Funds Funds Expenditures: General government: Personal services 462,850 - - - 462,850 - 462,850 Supplies 39,675 - - - 39,675 - 39,675 Contractual services 262,349 - - - 262,349 - 262,349 Capital outlay - - - 311,000 311,000 - 311,000 Public safety Personal services 2,122,851 - - - 2,122,851 - 2,122,851 Supplies 93,260 7,950 - - 101,210 - 101,210 Contractual services 548,536 1,650 - - 550,186 - 550,186 Capital outlay 25,736 - - 163,000 188,736 - 188,736 Public works Personal services 441,966 - - - 441,966 710,058 1,152,024 Supplies 124,810 - - - 124,810 139,543 264,353 Contractual services 151,855 - - - 151,855 1,373,388 1,525,243 Depreciation - - - - - 432,000 432,000 Capital outlay 16,300 - - 585,460 601,760 509,000 1,110,760 Sanitation Personal services - 12,165 - - 12,165 - 12,165 Supplies - - - - - - - Contractual services - 12,968 - - 12,968 - 12,968 Capital outlay - - Culture and recreation: Personal services 208,452 138,165 - - 346,617 - 346,617 Supplies 54,735 16,332 - - 71,067 - 71,067 Contractual services 232,008 375,763 - - 607,771 - 607,771 Capital outlay 8,000 4,000 - 183,500 195,500 - 195,500 Community & Economic development Personal services 325,501 109,931 - - 435,432 - 435,432 Supplies 4,680 300 - - 4,980 - 4,980 Contractual services 21,791 1,530,183 - - 1,551,974 - 1,551,974 Capital outlay - 2,390,490 - - 2,390,490 - 2,390,490 Miscellaneous Personal services 6,500 - - - 6,500 - 6,500 Contractual services 69,898 - - - 69,898 - 69,898 Debt principal 100,548 - 235,000 - 335,548 230,000 565,548 Interest and fiscal charges 37,192 - 23,283 - 60,475 6,700 67,175 Total expenditures 5,359,493 4,599,897 258,283 1,242,960 11,460,633 3,400,689 14,861,322 Surplus of revenues over (under) expenditures and (314,732) (668,570) (32,427) (184,460) (1,200,189) (806,638) (2,006,827) Other financing sources (uses) Transfers in 198,818 558,840 - 500,000 1,257,658 - 1,257,658 Transfers out (260,000) (388,840) - (68,736) (717,576) (540,082) (1,257,658) Total other financing sources (uses)(61,182) 170,000 - 431,264 540,082 (540,082) - Net change in fund balance or net assets (375,914) (498,570) (32,427) 246,804 (660,107) (1,346,720) (2,006,827) Add back capital outlay & debt principal - - - - - 739,000 739,000 Fund balance, January 1:9,275,851 3,600,321 298,945 10,183,587 23,358,704 12,396,911 35,755,615 Fund balance, December 31 8,899,937 3,101,751 266,518 10,430,391 22,698,597 11,789,191 34,487,788 2 City of Mounds View 2013 Budget Summary Y-T-D 2009 2010 2011 2012 07/31/2012 2013 Change from 2012 General Fund:Actual Actual Actual Budget Actual Request Dollar Percent Revenues: Property taxes - Base levy 3,105,868 3,000,707 3,135,624 3,367,610 1,982,649 3,325,809 (41,801) -1.24% Special tax levies, Bonds 158,895 154,606 93,885 93,734 - 144,627 50,893 54.30% Special tax levies, Operations 241,822 242,704 235,145 229,145 - 220,145 (9,000) -3.93% Franchise tax 235,002 225,581 241,289 253,000 97,716 253,000 - 0.00% Other taxes 102,284 81,975 221,001 45,000 8,042 30,000 (15,000) -33.33% Hotel/motel tax 43,835 51,002 53,516 51,000 25,877 53,000 2,000 3.92% Licenses and permits 175,816 129,834 172,841 182,260 83,656 180,492 (1,768) -0.97% Intergovernmental 816,717 570,267 575,178 326,671 283,763 359,671 33,000 10.10% Charges for services 23,302 41,570 20,533 18,565 10,966 18,715 150 0.81% Fines & forfeitures 29,819 26,107 39,970 26,300 28,183 31,300 5,000 19.01% Interest 96,267 75,421 224,063 195,000 (56,519) 193,000 (2,000) -1.03% Miscellaneous 124,176 305,000 241,507 227,018 214,568 235,002 7,984 3.52% Transfers:- 0.00% Special Projects Fund - - - 90,000 - 45,000 (45,000) -50.00% Police Grants Fund - - 12,531 - - - - 0.00% DARE Fund 4,393 4,393 3,000 - - - - 0.00% Water Fund 59,859 61,655 63,505 65,410 - 67,372 1,962 3.00% Sewer Fund 47,411 48,833 50,298 51,807 - 53,361 1,554 3.00% Storm Water Fund - - - 6,756 - 6,959 203 3.00% Street Light Fund 2,122 2,186 2,252 2,320 - 2,390 70 3.02% Levy Reduction Fund 249,315 250,000 6,472,060 - - - - 0.00% Vehicle & Equipment Fund 44,000 13,319 175,142 11,340 - 23,736 12,396 109.31% Bond sales - - 235,116 - - - - 0.00% Total revenues 5,560,903 5,285,160 12,268,456 5,242,936 2,678,901 5,243,579 643 0.01% Expenditures: Legislative Services: City Council 44,343 42,286 43,734 48,125 28,160 48,216 91 0.19% Advisory Commissions 9,575 7,079 4,877 10,650 756 10,150 (500) -4.69% Subtotal 53,918 49,365 48,611 58,775 28,916 58,366 (409) -0.70% Administrative Services: City Administrator 214,640 207,729 212,775 232,914 127,681 236,647 3,733 1.60% Elections 11,851 37,783 15,680 36,500 18,250 20,000 (16,500) -45.21% Finance 238,674 237,848 243,859 240,192 137,642 216,045 (24,147) -10.05% Central Services 193,815 197,045 190,839 218,251 91,127 233,816 15,565 7.13% Subtotal 658,980 680,405 663,153 727,857 374,700 706,508 (21,349) -2.93% Community Development 439,112 435,777 384,920 346,454 173,068 351,972 5,518 1.59% Police 2,276,827 2,179,150 2,282,169 2,373,986 1,344,053 2,479,537 105,551 4.45% Fire 318,765 332,068 531,728 463,132 348,797 448,586 (14,546) -3.14% Public Works Administration 106,794 111,755 120,094 129,153 69,354 130,769 1,616 1.25% Parks, Recreation & Forestry: Recreation 108,647 102,108 103,626 107,200 71,582 107,200 - 0.00% Parks 310,388 296,789 298,550 307,626 182,799 317,495 9,869 3.21% Forestry 50,496 34,385 53,650 55,000 33,914 78,500 23,500 42.73% Subtotal 469,531 433,282 455,826 469,826 288,295 503,195 33,369 7.10% Fleet Services: Building & Grounds Mtnce 132,439 119,776 133,369 129,958 67,212 133,298 3,340 2.57% Vehicle & Equipment Mtnce 84,828 89,560 94,490 84,390 47,164 93,759 9,369 11.10% Subtotal 217,267 209,336 227,859 214,348 114,376 227,057 12,709 5.93% Streets: Pavement Management 211,452 193,426 330,377 196,599 99,511 211,550 14,951 7.60% Snow & Ice Control 121,874 126,453 113,452 123,533 62,139 126,037 2,504 2.03% Sign Maintenance 35,321 32,371 32,308 37,629 20,098 39,518 1,889 5.02% Subtotal 368,647 352,250 476,137 357,761 181,748 377,105 19,344 5.41% Other Convention & Visitor's Bureau 40,171 48,452 50,840 48,450 19,796 50,350 1,900 3.92% Social Service Coordination 18,926 18,661 18,661 19,221 19,221 19,548 327 1.70% Miscellaneous/contingency 6,263 3,944 3,274 6,500 1,943 6,500 - 0.00% Transfers to other funds 335,000 220,000 245,000 245,000 - 260,000 15,000 6.12% Debt service - Fire Bonds 149,283 147,195 86,841 - - - - 0.00% Subtotal 549,643 438,252 404,616 319,171 40,960 336,398 17,227 5.40% Total expenditures 5,459,484 5,221,640 5,595,113 5,460,463 2,964,267 5,619,493 159,030 2.91% Net change in fund balance 101,419 63,520 6,673,343 (217,527) (285,366) (375,914) (158,387) Beginning Fund Balance 2,655,097 2,756,516 2,820,036 9,493,378 9,493,378 9,275,851 Ending Fund Balance 2,756,516 2,820,036 9,493,378 9,275,851 9,208,012 8,899,937 (158,387) 3 City of Mounds View GENERAL FUND 2013 Budget Summary Community Park Public 2013 2012 Percent Legislative Admin Finance Central Development Police Fire & Rec Works Misc.Total Total Variance Change Current Personnel services 33,065$ 232,187$ 197,598$ -$ 325,501$ 2,113,514$ 9,337$ 208,452$ 441,966$ 6,500$ 3,568,120$ 3,516,027$ 52,093$ 1.48% Materials & supplies 1,900 585 725 36,465 4,680 93,260 - 54,735 124,810 - 317,160 270,960 46,200 17.05% Contractual services 23,401 23,875 17,722 197,351 21,791 252,763 295,773 232,008 151,855 69,898 1,286,437 1,259,887 26,550 2.11% Contingency - - - - - - - - - - - - - #DIV/0! Current total 58,366 256,647 216,045 233,816 351,972 2,459,537 305,110 495,195 718,631 76,398 5,171,717 5,046,874 124,843 2.47% Other Principal - - - - - - 100,548 - - - 100,548 97,524 3,024 3.10% Interest - - - - - - 37,192 - - - 37,192 39,975 (2,783) -6.96% Capital outlays - - - - - 20,000 5,736 8,000 16,300 - 50,036 31,090 18,946 60.94% Transfers to other funds - - - - - - - - - 260,000 260,000 245,000 15,000 6.12% Other total - - - - - 20,000 143,476 8,000 16,300 260,000 447,776 413,589 34,187 8.27% Department Total 58,366$ 256,647$ 216,045$ 233,816$ 351,972$ 2,479,537$ 448,586$ 503,195$ 734,931$ 336,398$ 5,619,493$ 5,460,463$ 159,030$ 2.91% 4 City of Mounds View 2013 Budget Summary Y-T-D 2009 2010 2011 2012 07/31/2012 2013 Change from 2012 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 6,617 7,416 - - 3,764 - (23,996) 0.00% Finance - - - - - - - 0.00% Subtotal 6,617 7,416 - - 3,764 - (23,996) 0.00% Community Development 1,066 - - - - - - 0.00% Police 36,239 5,579 25,531 16,500 33,564 20,000 (34,533) -209.29% Fire - - - - - 5,736 5,736 0.00% Public Works Administration - - - - - - (1,791) 0.00% Parks, Recreation & Forestry: Recreation - - - - - - - 0.00% Parks - - - - - 8,000 (4,024) 0.00% Forestry - - - - - - - 0.00% Subtotal - - - - - 8,000 (4,024) 0.00% Fleet Services: Building & Grounds Mtnce - - - 1,750 1,734 5,100 5,100 291.43% Vehicle & Equipment Mtnce - - - - - 6,000 6,000 0.00% Subtotal - - - 1,750 1,734 11,100 11,100 634.29% Streets: Pavement Management - - 132,648 1,500 - 5,200 (17,554) -1170.27% Snow & Ice Control 949 - 1,048 - - - (2,705) 0.00% Sign Maintenance - - - - - - - 0.00% Subtotal 949 - 133,696 1,500 - 5,200 (20,259) -1350.60% 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 44,871 12,995 159,227 19,750 39,062 50,036 (67,767) -343.12% 5 City of Mounds View 2013 Budget Summary Y-T-D 2009 2010 2011 2012 07/31/2012 2013 Change from 2012 General Fund:Actual Actual Actual Budget Actual Request Dollar Percent Operating Expenditures: Legislative Services: City Council 44,343 42,286 43,734 48,125 28,160 48,216 91 0.19% Advisory Commissions 9,575 7,079 4,877 10,650 756 10,150 (500) -4.69% Subtotal 53,918 49,365 48,611 58,775 28,916 58,366 (409) -0.70% Administrative Services: City Administrator 214,640 207,729 212,775 232,914 127,681 236,647 3,733 1.60% Elections 11,851 37,783 15,680 36,500 18,250 20,000 (16,500) -45.21% Central Services 187,198 190,428 190,839 218,251 87,363 233,816 15,565 7.13% Finance 238,674 237,848 243,859 240,192 137,642 216,045 (24,147) -10.05% Subtotal 652,363 673,788 663,153 727,857 370,936 706,508 (21,349) -2.93% Community Development 438,046 434,711 384,920 346,454 173,068 351,972 5,518 1.59% Police 2,240,588 2,142,911 2,256,638 2,357,486 1,310,489 2,459,537 102,051 4.33% Fire 318,765 332,068 531,728 463,132 348,797 442,850 (20,282) -4.38% Public Works Administration 106,794 111,755 120,094 129,153 69,354 130,769 1,616 1.25% Parks, Recreation & Forestry: Recreation 108,647 102,108 103,626 107,200 71,582 107,200 - 0.00% Parks 310,388 296,789 298,550 307,626 182,799 309,495 1,869 0.61% Forestry 50,496 34,385 53,650 55,000 33,914 78,500 23,500 42.73% Subtotal 469,531 433,282 455,826 469,826 288,295 495,195 25,369 5.40% Fleet Services: Building & Grounds Mtnce 132,439 119,776 133,369 128,208 65,478 128,198 (10) -0.01% Vehicle & Equipment Mtnce 84,828 89,560 94,490 84,390 47,164 87,759 3,369 3.99% Subtotal 217,267 209,336 227,859 212,598 112,642 215,957 3,359 1.58% Streets: Pavement Management 211,452 193,426 197,729 195,099 99,511 206,350 11,251 5.77% Snow & Ice Control 120,925 125,504 112,404 123,533 62,139 126,037 2,504 2.03% Sign Maintenance 35,321 32,371 32,308 37,629 20,098 39,518 1,889 5.02% Subtotal 367,698 351,301 342,441 356,261 181,748 371,905 15,644 4.39% Other Convention & Visitor's Bureau 40,171 48,452 50,840 48,450 19,796 50,350 1,900 3.92% Social Service Coordination 18,926 18,661 18,661 19,221 19,221 19,548 327 1.70% Miscellaneous/contingency 6,263 3,944 3,274 6,500 1,943 6,500 - 0.00% Transfers to other funds 335,000 220,000 245,000 245,000 - 260,000 15,000 6.12% Debt service - Fire Bonds 149,283 147,195 86,841 - - - - 0.00% Subtotal 549,643 438,252 404,616 319,171 40,960 336,398 17,227 5.40% Total expenditures 5,414,613 5,176,769 5,435,886 5,440,713 2,925,205 5,569,457 128,744 2.37% 6 General Fund Revenue Detail - 2013 Budget Y-T-D Acct 2009 2010 2011 2012 07/31/2012 2013 Change from 2012 #Description Actual Actual Actual Budget Actual Request Dollar Percent Taxes 3101 Current ad valorem property tax 3,105,868 3,000,707 3,135,624 3,367,610 1,982,649 3,325,809 (41,801) -1.24% 3101 Fire Bonds property tax 1997 61,226 60,362 - - - - 0.00% 3101 Fire Mini-Pumper property tax 2,146 - - - - - 0.00% 3101 Fire bonds 05 & notes 11 95,523 94,244 93,885 93,734 144,627 50,893 54.30% 3101 PERA rate increase property tax 26,822 34,704 39,145 39,145 39,145 - 0.00% 3101 Police Officer property tax 215,000 208,000 196,000 190,000 181,000 (9,000) -4.74% 3102 Delinquent ad valorem prop tax 47,192 5,740 143,917 - - - 0.00% 3111 Manufact home tax - current 18,147 19,568 19,767 20,000 20,000 - 0.00% 3112 Manufact home tax - delinquent 10,476 8,679 (6,360) 10,000 10,000 - 0.00% 3113 Man. home Market value credit 11,507 11,239 10,472 15,000 - (15,000) -100.00% 3125 Excess TIF 12,052 32,839 28,813 - - - 0.00% 3180 Franchise tax on utilities 235,002 225,581 241,289 253,000 97,716 253,000 - 0.00% 3190 Penalties & interest 2,910 3,910 24,392 - 7,130 - - 0.00% 3192 Forfeited tax sales - - - - 912 - - 0.00% 3195 Hotel/Motel tax 43,835 51,002 53,516 51,000 25,877 53,000 2,000 3.92% Total taxes 3,887,706 3,756,575 3,980,460 4,039,489 2,114,284 4,026,581 (12,908) -0.32% Licenses and Permits 3211 Liquor on-sale 21,620 18,395 31,815 20,000 16,660 20,000 - 0.00% 3212 Liquor off-sale 645 410 600 700 630 700 - 0.00% 3215 Malt on-sale license 1,820 1,870 85 1,000 100 100 (900) -90.00% 3216 Malt off-sale 10 740 85 100 755 100 - 0.00% 3221 Tobacco license 3,000 2,685 2,760 1,900 3,220 2,700 800 42.11% 3223 Amusement devices 810 795 1,216 1,000 1,280 1,000 - 0.00% 3231 Bowling alley 640 640 1,344 640 672 672 32 5.00% 3232 Garbage hauling 1,740 1,820 2,740 2,500 2,820 2,500 - 0.00% 3233 Gasoline station 582 736 1,038 600 1,245 800 200 33.33% 3234 Used car sales 200 200 204 150 - 150 - 0.00% 3235 Kennel 263 184 157 120 189 120 - 0.00% 3236 Restraurant licenses 4,290 4,075 4,758 4,000 3,817 4,000 - 0.00% 3238 Transient & solicitor 2,385 2,480 1,432 1,500 2,295 1,500 - 0.00% 3239 Apartment 14,101 22,912 23,055 18,000 792 22,000 4,000 22.22% 3240 Rental conversion - - 1,575 - 975 - - 0.00% 3241 Dog license 1,060 2,204 1,356 900 799 900 - 0.00% 3242 Massage therapy 435 100 - - - - - 0.00% 3250 General contractor 1,050 595 1,180 1,100 600 1,100 - 0.00% 3251 HVAC contractor 4,503 5,035 3,895 3,800 2,280 3,800 - 0.00% 3252 Cement contractor 436 450 60 250 60 250 - 0.00% 3253 Asphalt contractor 700 552 540 500 60 500 - 0.00% 3254 Excavating contractor 50 150 120 50 - 50 - 0.00% 3255 Sign & billboard contractor 535 360 260 500 60 500 - 0.00% 3256 Sewer & water contractor 50 5 60 50 - 50 - 0.00% 3257 Other contractor 900 1,240 1,260 700 1,250 800 100 14.29% 3258 License check 1,210 1,079 1,661 1,000 870 1,000 - 0.00% 3260 Fire permits 750 900 660 600 500 600 - 0.00% Subtotal licenses 63,785 70,612 83,916 61,660 41,929 65,892 4,232 6.86% 7 General Fund Revenue Detail - 2013 Budget Y-T-D Acct 2009 2010 2011 2012 07/31/2012 2013 Change from 2012 #Description Actual Actual Actual Budget Actual Request Dollar Percent 3262 Grading permit - - 1,000 - 44 - - 0.00% 3268 Plan check fee 21,444 8,806 12,439 22,000 3,966 18,000 (4,000) -18.18% 3270 Building permits 44,478 18,470 34,437 55,000 21,250 50,000 (5,000) -9.09% 3271 Fixed fee - building permits 18,872 14,007 21,054 18,000 7,696 23,000 5,000 27.78% 3272 Wetland buffer permit 75 - - - 30 - - 0.00% 3273 HVAC permits 11,867 8,615 9,074 12,000 3,948 11,000 (1,000) -8.33% 3274 Plumbing permits 6,860 3,516 4,256 8,000 2,511 7,000 (1,000) -12.50% 3275 Non-building permits 7,038 4,784 4,287 5,000 3,081 5,000 - 0.00% 3278 Interim use permits - - 400 - - - 0.00% 3279 Conditional use permits 1,250 1,200 800 600 600 - 0.00% 3280 Building surcharge 109 (260) 371 - (365) - - 0.00% 3281 Fixed fee building surcharge 5 24 486 - (294) - - 0.00% 3282 Mechanical/commercial surcharg 31 5 60 - (57) - - 0.00% 3283 HVAC surcharge 17 49 158 - (41) - - 0.00% 3284 Plumbing surcharge 1 5 59 - (5) - - 0.00% 3287 Commercial plmb surcharge (16) 1 44 - (37) - - 0.00% Subtotal permits 112,031 59,222 88,925 120,600 41,727 114,600 (6,000) -4.98% Total licenses & permits 175,816 129,834 172,841 182,260 83,656 180,492 (1,768) -0.97% Intergovernmental: 3318 Federal grant 920 749 4,661 - 2,447 - - 0.00% 3341 Local Government Aid 495,704 232,078 232,078 - 116,039 - - 0.00% 3346 PERA Aid 8,671 8,671 8,671 8,671 4,335 8,671 - 0.00% 3351 Street Aid - MSA maintenance 94,294 105,033 107,240 105,000 106,605 107,000 2,000 1.90% 3355 Police Aid 128,272 120,233 116,412 116,000 120,000 4,000 3.45% 3356 Police training 7,532 6,095 6,438 6,000 6,000 - 0.00% 3357 State police grant - - 2,697 - 10,000 10,000 0.00% 3359 Other state grants 18,064 30,164 28,868 18,000 16,357 39,000 21,000 116.67% 3370 Other local government revenue 745 709 563 6,000 - (6,000) -100.00% 3371 IDS # 621 - SRO 62,515 66,535 67,550 67,000 37,980 69,000 2,000 2.99% Total intergovernmental 816,717 570,267 575,178 326,671 283,763 359,671 33,000 10.10% Charges for services 3410 Advertising revenue - 1,175 1,802 50 325 500 450 900.00% 3415 Housing inspections - 47 - 50 - 50 - 0.00% 3418 HRA inspections 1,656 2,188 2,860 1,900 442 2,000 100 5.26% 3419 Investigations 371 792 287 - - - 0.00% 3421 Police reports 1,645 5,168 1,507 1,200 658 1,200 - 0.00% 3422 Documents / copies 536 158 19 90 12 90 - 0.00% 3423 Customer service 814 238 201 500 202 400 (100) -20.00% 3425 Book sales - various 265 70 15 - 120 - - 0.00% 3426 Reimbursed staff time 780 560 1,360 1,000 - 1,000 - 0.00% 3430 Right-of-way 9,800 16,192 4,860 4,000 5,969 4,000 - 0.00% 3431 Street opening fee (875) - - - 125 - - 0.00% 3432 Tree removal charges 4,010 7,632 5,382 4,500 (1,037) 4,500 - 0.00% 3433 Overload permits 1,425 4,950 150 2,000 3,050 2,000 - 0.00% 3458 Zoning letter 100 75 90 75 100 75 - 0.00% 3460 Easement vacation 250 - 250 - - - - 0.00% 3461 Subdivision 775 1,250 700 1,000 - 1,000 - 0.00% 3462 Variance 1,125 450 600 1,000 800 1,000 - 0.00% 3463 Rezoning - - - 500 - 200 (300) -60.00% 3464 Development - non refund 375 375 50 350 - 350 - 0.00% 3465 Code appeal 250 250 - - 200 - - 0.00% 3467 PUD amendment - - 400 350 - 350 - 0.00% Total charges for services 23,302 41,570 20,533 18,565 10,966 18,715 150 0.81% 8 General Fund Revenue Detail - 2013 Budget Y-T-D Acct 2009 2010 2011 2012 07/31/2012 2013 Change from 2012 #Description Actual Actual Actual Budget Actual Request Dollar Percent Fines and Forfeitures 3510 Ramsey County municipal court 17,835 19,047 30,596 18,000 23,935 23,000 5,000 27.78% 3515 Mn Highway Patrol 234 568 490 300 359 300 - 0.00% 3520 Administrative offenses 10,050 4,817 6,384 6,000 2,664 6,000 - 0.00% 3525 False alarm charges 1,700 1,675 2,500 2,000 1,225 2,000 - 0.00% Total fines & forfeitures 29,819 26,107 39,970 26,300 28,183 31,300 5,000 19.01% Other Revenue 3550 Special assessments 8,957 15,203 5,365 7,000 658 7,000 - 0.00% 3610 Investment income 96,267 75,421 224,063 195,000 (56,519) 193,000 (2,000) -1.03% 3630 Billboard Lease 53,549 53,806 54,078 99,342 61,374 99,440 98 0.10% 3631 Water tower rental - 18,605 87,911 89,304 91,417 95,063 5,759 6.45% 3634 Equipment and space rental 5,250 5,050 3,172 3,172 1,893 3,299 127 4.00% 3650 Donations 5,390 465 10,480 - 21,896 - - 0.00% 3656 Tree sales (40) (101) - 1,200 - 1,200 - 0.00% 3665 Park site permit 9,189 12,214 15,266 8,000 6,594 10,000 2,000 25.00% 3679 Vending machine commissions 5 15 196 - 217 - - 0.00% 3680 Other revenue 5,253 153,198 8,035 11,000 5,491 11,000 - 0.00% 3685 Insurance reimbursements 31,551 29,607 47,162 4,000 19,491 4,000 - 0.00% 3690 Cash over / short - - - - - - - 0.00% 3911 Sale of assets - 7,000 7,065 3,000 3,554 3,000 - 0.00% 3912 Resale of materials 5,072 9,938 2,777 1,000 1,983 1,000 - 0.00% Total other revenue 220,443 380,421 465,570 422,018 158,049 428,002 5,984 1.42% Transfers & Debt proceeds 3972 Transfers: Special Projects - - - 90,000 45,000 (45,000) -50.00% Police Grants - - 12,531 - - - 0.00% Vehicle & Equip replacement 44,000 13,319 175,142 11,340 23,736 12,396 109.31% DARE fund 4,393 4,393 3,000 - - - 0.00% Water 59,859 61,655 63,505 65,410 67,372 1,962 3.00% Sewer 47,411 48,833 50,298 51,807 53,361 1,554 3.00% Storm Water - - - 6,756 6,959 203 3.00% Street light 2,122 2,186 2,252 2,320 2,390 70 3.02% Levy reduction - levy 249,315 250,000 6,472,060 - - - 0.00% 3993 Debt proceeds - - 235,116 - - - - 0.00% Total Transfers & Debt 407,100 380,386 7,013,904 227,633 - 198,818 (28,815) -12.66% Total 5,560,903 5,285,160 12,268,456 5,242,936 2,678,901 5,243,579 643 0.01% 9 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent City Council (100 - 4100): Personnel services 0100 Salaries, regular 29,196 29,196 29,220 29,100 17,087 29,292 192 0.66% 0300 Social Security 1,873 1,873 1,775 2,226 865 2,241 15 0.67% 0321 PERA 570 570 649 1,455 516 1,465 10 0.69% 0500 Workers compensation 41 48 60 64 42 67 3 4.69% Total personnel services 31,680 31,687 31,704 32,845 18,510 33,065 220 0.67% Materials & supplies 1600 Supplies, operating 1,158 870 1,408 1,600 1,639 1,600 - 0.00% Total materials & supplies 1,158 870 1,408 1,600 1,639 1,600 - 0.00% Contractual services 3030 Other professional services 5,985 5,542 5,687 7,925 2,894 7,925 - 0.00% 3610 Memberships 3,585 2,821 2,821 2,826 2,801 2,826 - 0.00% 3630 Training & conferences 875 501 1,257 1,800 1,772 1,800 - 0.00% 4800 Bonding & insurance 1,060 865 857 1,129 544 1,000 (129) -11.43% Total contractual services 11,505 9,729 10,622 13,680 8,011 13,551 (129) -0.94% Capital outlays - - - - - - - 0.00% Total City Council 44,343 42,286 43,734 48,125 28,160 48,216 91 0.19% Advisory Commissions (100-4110): Materials & supplies 1600 Supplies, operating - - - 200 - 200 - 0.00% 2100 Books & periodicals - - - 100 - 100 - 0.00% Total materials & supplies - - - 300 - 300 - 0.00% Contractual services 3030 Other professional services 2,199 2,710 1,137 5,500 756 5,000 (500) -9.09% 3630 Training & conferences - 30 252 350 350 - 0.00% 3900 Festivities Commission 7,376 4,339 3,488 4,500 - 4,500 - 0.00% Total contractual services 9,575 7,079 4,877 10,350 756 9,850 (500) -4.83% Capital outlays - - - - - - 0.00% Total Advisory Commissions 9,575 7,079 4,877 10,650 756 10,150 (500) -4.69% 2013 Budget Summary 10 Fund: 100 Department: 4100 City Council Account Description 2010 2011 2012 2013 Description 1600 Supplies, operating 850 800 800 800 Employee appreciation dinner 850 800 800 800 Plaques and gift certificates for employee appreciation 1,700 1,600 1,600 1,600 3030 Other professional services 1,000 1,000 500 500 Strategic planning session 8,490 8,490 7,425 7,425 Contractual minutes for Council mtgs ( $275 x 24 reg, + 3 special) 9,490 9,490 7,925 7,925 3610 Memberships 25 25 25 25 Mn Mayor's Association 2,801 2,875 2,801 2,801 North Metro Mayors (1/2 membership; 1/2 in EDA) 2,826 2,900 2,826 2,826 3630 Conferences 2,000 1,800 1,800 1,800 Council training, LMC conference, RCCLG dinners & NLC conference 2,000 1,800 1,800 1,800 4800 Bonds & insurance 1,129 1,129 1,129 1,000 Open meeting law insurance and general property & liability 1,129 1,129 1,129 1,000 17,145 16,919 15,280 15,151 -14.46%-1.32%-9.69%-0.84% Fund: 100 Department: 4110 Advisory Commissions Account Description 2010 2011 2012 2013 Description 1600 Supplies, operating 75 60 60 60 Misc supplies for various commissions. 150 140 140 140 Copies for Charter Commission 225 200 200 200 2100 Books & periodicals 75 100 100 100 Misc periodicals - Comp plan review, Ordinance revisions. 75 100 100 100 3030 Other professional services 1,000 500 500 500 Misc. consultant services. 2,000 2,000 2,000 2,000 Charter commission legal fees 3,700 3,500 3,000 2,500 Planning Commission meeting minutes 6,700 6,000 5,500 5,000 3630 Training 200 175 175 175 Misc training & conferences. 200 175 175 175 Planning Commissioner training & conferences 400 350 350 350 3900 Festival in the Park 4,500 4,500 4,500 4,500 City Festival in the Park (overtime for PW and PD and copier costs) 4,500 4,500 4,500 4,500 11,900 11,150 10,650 10,150 0.00%-6.30%-4.48%-4.69% 11 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Office of the City Administrator (100 - 4130): Personnel services 0100 Salaries, regular 169,137 162,076 165,245 175,098 97,840 176,864 1,766 1.01% 0110 Salaries, over-time - - - 716 - 724 8 1.12% 0150 Salaries, part-time 320 - - 2,910 - 2,910 - 0.00% 0300 Social Security 12,173 11,655 12,196 13,673 7,212 13,808 135 0.99% 0321 PERA 10,977 11,035 11,810 12,747 7,029 12,875 128 1.00% 0400 Group insurance 18,489 18,953 19,641 22,259 13,155 23,978 1,719 7.72% 0500 Workers compensation 637 727 846 1,001 664 1,028 27 2.70% 0990 Severence - - - - - - - 0.00% Total personnel services 211,733 204,446 209,738 228,404 125,900 232,187 3,783 1.66% Materials & supplies 1230 Supplies, equipment - 56 197 450 450 - 0.00% 1600 Supplies, operating 28 143 - 100 100 - 0.00% 2100 Books & periodicals - 16 - 35 - 35 - 0.00% Total materials & supplies 28 215 197 585 - 585 - 0.00% Contractual services 3100 Communications 456 694 965 760 305 760 - 0.00% 3610 Memberships 1,037 178 160 240 185 240 - 0.00% 3630 Training & conferences 1,206 2,191 1,693 2,525 1,291 2,500 (25) -0.99% 3800 Mileage 180 5 22 400 375 (25) -6.25% Total contractual services 2,879 3,068 2,840 3,925 1,781 3,875 (50) -1.27% Capital outlays 7030 Equipment - - - - - - - 0.00% 0.00% Total City Administrator 214,640 207,729 212,775 232,914 127,681 236,647 3,733 1.60% Elections (100 - 4140): Personnel services 0100 Salaries, regular 7,854 13,778 10,673 - - - 0.00% 0150 Salaries, part-time - 15,000 - - - - - 0.00% 0300 Social Security 565 998 781 - - - 0.00% 0321 PERA 526 955 774 - - - 0.00% 0400 Group insurance 1,213 1,934 1,616 - - - 0.00% 0500 Workers compensation 52 162 131 - - - 0.00% Total personnel services 10,210 32,827 13,975 - - - - 0.00% Materials & supplies 1600 Supplies, operating - 3,229 - - - - - 0.00% Total materials & supplies - 3,229 - - - - - 0.00% Contractual services 3030 Other professional services 1,641 1,727 1,705 36,500 18,250 20,000 (16,500) -45.21% Total contractual services 1,641 1,727 1,705 36,500 18,250 20,000 (16,500) -45.21% Total Elections 11,851 37,783 15,680 36,500 18,250 20,000 (16,500) -45.21% 2013 Budget Summary 12 Fund: 100 Department: 4130 Office of the City Administrator Account Description 2010 2011 2012 2013 Description 1230 Supplies, equipment 500 450 450 450 Furniture or equipment under the $1,000 capitalization threshold 500 450 450 450 1600 Supplies, Operating 100 90 100 100 Miscellaneous supplies 100 90 100 100 2100 Books & Periodicals 50 45 35 35 Miscellaneous reference books 50 45 35 35 3100 Communications 432 680 760 760 Sprint/Nextel service 432 680 760 760 3610 Memberships 760 - - - ICMA - International City Manager's Association 50 50 50 50 MAMA - (Administrator) Metro Area Manager's Association 120 150 150 150 Mn City County Managers Association 1,800 - - - New Brighton/Mounds View Rotary Club dues (administrator, police chief) 35 40 40 40 Municipal Clerks & Finance Officers Association 2,765 240 240 240 3630 Training & conferences 150 100 75 100 MAMA meetings 500 400 350 500 LMC / miscellaneous training 50 50 50 100 Chamber lunches 750 700 750 850 LMC annual conference 700 775 800 850 Mn City County Managers Assoc seminar 750 750 500 100 Mn Clerks and Finance Officers Association (MCFOA) institute training - - - - National ICMA conference (City Administrator)(budget in 2007, 2009) 2,900 2,775 2,525 2,500 3800 Mileage 600 500 400 375 Miscellaneous mileage @ IRS rate. 600 500 400 375 7,347 4,780 4,510 4,460 -21.59%-34.94%-5.65%-1.11% Fund: 100 Department: 4140 Elections Account Description 2010 2011 2012 2013 Description 1600 Supplies, operating 600 - - - Misc supplies - paper, pens, files, and mats for gym 1,350 100 - - Election Judge meals (even years and special elections) 1,000 - - - Paper ballots (even years and special elections) 2,950 100 - - 3030 Other professional services 1,700 625 36,500 20,000 Ramsey County fees (2012 contract to conduct elections) 200 200 - - Equip. maint. service costs (voting equip.)(even years and special elections) 1,900 825 36,500 20,000 3410 Legal notices 400 100 - - Primary and general election (even years and special elections) 400 100 - - 5,250 1,025 36,500 20,000 366.67%-80.48%3460.98%-45.21% 13 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Finance (100 - 4150): Personnel services 0100 Salaries, regular 159,984 159,620 166,776 146,607 82,235 150,998 4,391 3.00% 0110 Overtime 14 - - 58 - 59 1 1.72% 0150 Salaries, part-time 20,215 19,730 19,808 21,354 11,010 - (21,354) -100.00% 0300 Social Security 11,811 11,922 12,162 12,853 6,534 11,556 (1,297) -10.09% 0321 PERA 12,091 12,501 12,459 12,181 6,710 10,952 (1,229) -10.09% 0400 Group insurance 16,241 16,817 15,629 28,108 14,281 22,922 (5,186) -18.45% 0500 Workers compensation 1,063 1,243 1,180 1,221 809 1,111 (110) -9.01% 0990 Severence - - - - - - 0.00% Subtotal 221,419 221,833 228,014 222,382 121,579 197,598 (24,784) -11.14% Materials & supplies 1230 Supplies, equipment 165 - - 300 300 - 0.00% 1600 Supplies, operating 21 - 8 75 75 - 0.00% 2100 Books & periodicals 340 475 565 325 451 350 25 7.69% Subtotal 526 475 573 700 451 725 25 3.57% Contractual services 3030 Other professional 8,890 9,099 9,249 9,535 9,084 9,715 180 1.89% 3430 Printing 1,736 118 118 700 805 700 - 0.00% 3610 Memberships 700 445 480 560 495 780 220 39.29% 3630 Training 1,857 2,038 1,335 2,075 997 2,075 - 0.00% 5130 Repairs, equipment 3,546 3,840 4,090 4,240 4,231 4,452 212 5.00% Subtotal 16,729 15,540 15,272 17,110 15,612 17,722 612 3.58% Total Financial Services 238,674 237,848 243,859 240,192 137,642 216,045 (24,147) -10.05% 2013 Budget Summary 14 Fund: 100 Department: 4150 Finance Account Description 2010 2011 2012 2013 Description 1230 Supplies, equitpment 350 300 300 300 Furniture or equipment under the $5,000 capitalization threshold 350 300 300 300 1600 Supplies, operating 100 75 75 75 Misc supplies - planners, plaques, folders, files, etc. 100 75 75 75 2100 Books & periodicals 350 325 325 350 Misc computer & finance books & periodicals 350 325 325 350 3030 Other professional services 8,580 8,820 8,940 9,120 30% of audit 425 425 435 435 GFOA financial reporting fee 60 60 60 60 Safety deposit box rental 100 100 100 100 Ramsey County Special Assessment recap report 9,165 9,405 9,535 9,715 3430 Printing 400 350 350 350 Accts Payable & payroll checks & envelopes 400 350 350 350 Invoices, receipts, & bank deposit slips 800 700 700 700 3610 Memberships 190 200 210 210 Government Finance Officer's Association (GFOA) 120 120 120 120 Mn GFOA (2) - - - 220 AICPA Am. Institute of Certified Public Accts (postponed, 10,11,12,) 195 200 230 230 MNCPA Mn Society of Certified Public Accountants 505 520 560 780 3630 Training & conferences 90 75 75 75 Mn GFOA monthly meetings - - - - Mn GFOA annual seminar (postpone to 12)(13)(14)($750) 1,200 1,200 1,200 1,200 Seminars & training - - - - GFOA National conference ($l700)(postpone to 09)(11)(12)(13)(14) 500 500 500 500 Accounting software training 300 300 300 300 Mileage 2,090 2,075 2,075 2,075 5130 Equipment repairs 3,846 4,038 4,240 4,452 40% accounting software support charges 3,846 4,038 4,240 4,452 7030 Equipment - - - - - - - - 17,206 17,438 17,810 18,447 -10.21%1.35%2.13%3.58% 15 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 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 464 778 593 1,300 127 1,300 - 0.00% 1120 Copy materials 1,650 1,681 1,892 2,000 828 2,000 - 0.00% 1230 Supplies, equipment 1,045 971 15,269 800 49 16,800 16,000 2000.00% 1600 Supplies, operating 15,024 13,734 11,797 15,900 11,086 15,900 - 0.00% 2100 Books & periodicals 259 858 600 405 33 465 60 14.81% Total materials & supplies 18,442 18,022 30,151 20,405 12,123 36,465 16,060 78.71% Contractual services 3010 General legal 38,989 46,365 35,848 48,600 7,806 47,400 (1,200) -2.47% 3030 Other professional services 5,622 8,883 10,038 9,800 3,019 9,800 - 0.00% 3100 Telephone 7,638 6,798 5,700 7,200 3,715 6,400 (800) -11.11% 3300 Postage 10,397 6,082 8,191 11,800 6,174 10,500 (1,300) -11.02% 3410 Legal notices 2,250 1,302 1,839 2,700 1,936 2,500 (200) -7.41% 3420 Advertising 2,034 1,714 1,031 3,800 - 3,500 (300) -7.89% 3430 Printing 4,200 4,278 4,692 8,100 2,929 7,900 (200) -2.47% 3610 Memberships 9,965 10,375 10,021 10,698 585 11,052 354 3.31% 3630 Training & conferences 143 647 1,497 1,000 102 1,800 800 80.00% 4010 Rental, equipment 283 723 578 810 134 1,650 840 103.70% 4800 Insurance & bonds 23,673 20,321 18,519 22,000 10,942 22,000 - 0.00% 5100 Repairs, computers 62,545 63,396 61,847 70,438 37,898 71,949 1,511 2.15% 5130 Repairs, equipment 838 723 887 900 - 900 - 0.00% Total contractual services 168,577 171,607 160,688 197,846 75,240 197,351 (495) -0.25% Capital outlays 7030 Equipment 6,617 7,416 - - 3,764 - 0.00% Total capital outlays 6,617 7,416 - - 3,764 - - 0.00% Total central services 193,815 197,045 190,839 218,251 91,127 233,816 15,565 7.13% 2013 Budget Summary 16 Fund: 100 Department: 4160 Central Services Account Description 2010 2011 2012 2013 Description 1110 Stationery 1,500 1,400 1,300 1,300 Envelopes, labels, letterhead, etc. 1,500 1,400 1,300 1,300 1120 Copy materials 2,000 2,000 2,000 2,000 Copy paper 2,000 2,000 2,000 2,000 1230 Supplies, equitpment 700 700 800 16,800 Comp equip under the $5,000 cap threshold, pc's, software, switches.... 700 700 800 16,800 Replace 11 pc's @ $800, 5 yr. Replacement cycle on 53 city pc's 1600 Supplies, operating 15,400 15,400 15,400 15,400 Toner, rug service, paper, pens, staples, desk supplies, etc. 500 500 500 500 Misc operating supplies 15,900 15,900 15,900 15,900 2100 Books & periodicals 150 105 105 125 Employment handbooks/publications 260 270 300 340 Pioneer Press - $190/Star Tribune - $150 410 375 405 465 3010 General legal 27,600 27,600 27,600 26,400 Retainer for legal services 21,000 21,000 21,000 21,000 Legal fees outside scope of retainer. 48,600 48,600 48,600 47,400 3030 Other professional services 7,000 6,500 6,500 6,500 General labor assistance 1,050 1,200 1,400 1,400 Section 125 (Tax Saver flex spending) & COBRA administration 900 900 900 900 Human resources items 1,000 1,000 1,000 1,000 Web hosting/GovOffice 9,950 9,600 9,800 9,800 3100 Telephone 8,400 8,400 7,200 6,400 Basic telephone plus long distance 8,400 8,400 7,200 6,400 3300 Postage 300 300 300 300 Courier charges (delivery services) 12,000 11,500 11,500 10,200 General postage includes PW mailings for street projects. 12,300 11,800 11,800 10,500 3410 Legal notices 1,000 1,000 900 900 Truth in taxation notices and Ramsey County fees. 2,000 1,800 1,800 1,600 Legal notices. 3,000 2,800 2,700 2,500 3420 Advertising 4,000 3,800 3,800 3,500 Job opening advertisements for vacant positions 4,000 3,800 3,800 3,500 3430 Printing 6,000 8,000 6,600 6,400 4 newsletter-50% cost here, 50% in YMCA. 1,000 750 750 750 Miscellaneous printing 1,000 750 750 750 City guides, directories & miscellaneous 8,000 9,500 8,100 7,900 3610 Memberships 605 605 605 605 Ramsey County League of Local Governments (RCLLG) 9,799 9,799 10,093 10,447 League of Mn Cities 10,404 10,404 10,698 11,052 3630 Training & conferences 1,000 800 800 800 League training & seminars - - - 800 OSHA and blood borne pathogen training 400 200 200 200 Information technology training 1,400 1,000 1,000 1,800 4010 Rental, equipment - - - - Administration copier rental fee and maintenance 150 150 150 150 Misc 600 660 660 1,500 Postage machine and scale rental 750 810 810 1,650 4800 Bonding & insurance 19,000 19,000 19,000 19,000 Insurance policy premiums 3,000 3,000 3,000 3,000 Allowance for insurance policy deductibles 22,000 22,000 22,000 22,000 5100 Repairs, computer 55,000 55,000 58,500 58,500 Computer network & technology assistance - City of Roseville 3,000 3,800 3,990 4,190 Copier maintenance + overages 1,868 2,134 2,198 2,198 Laserfiche annual maintenance - - - 1,311 Hosted servers (saves approx. $689 per year)(2 servers) 3,000 5,000 5,750 5,750 Computer, printer, and networks repairs. 62,868 65,934 70,438 71,949 5130 Repairs, equipment 900 900 900 900 Postage meter, copy machine, fax, misc. 900 900 900 900 7030 Capital, equipment 11,000 9,000 - - Replace 11 pc's @ $800, 5 yr. Replacement cycle on 53 city pc's 4,500 4,500 - - Software licenses (Autocad, MS Office, Windows) 9,500 9,500 - - Network hardware (switches, routers, hubs, ups, servers) 25,000 23,000 - - 238,082 238,923 218,251 233,816 -4.08%0.35%-8.65%7.13% 17 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Community Development (100 - 4180): Personnel services 0100 Salaries, regular 319,530 314,562 261,640 213,197 108,861 226,132 12,935 6.07% 0110 Overtime, regular - - - 1,087 - 1,098 11 1.01% 0150 Salaries, part time 6,539 7,806 8,349 18,989 9,691 19,588 599 3.15% 0300 Social Security 16,560 16,447 12,250 17,845 5,448 18,882 1,037 5.81% 0321 PERA 30,765 30,339 27,102 16,250 11,091 17,234 984 6.06% 0400 Group insurance 50,913 51,915 47,827 43,274 24,614 41,135 (2,139) -4.94% 0500 Workers comp 1,315 1,574 1,689 1,336 886 1,432 96 7.19% 0600 Unemployment - - 15,028 7,605 - - (7,605) -100.00% 0990 Severence - - - - - - - 0.00% Total personnel services 425,622 422,643 373,885 319,583 160,591 325,501 5,918 1.85% Materials & supplies 1230 Supplies, equipment 734 24 - 475 75 475 - 0.00% 1600 Supplies, operating 136 70 189 375 32 375 - 0.00% 1700 Motor fuels & lubricants - - - 3,600 1,618 3,200 (400) -11.11% 2100 Books & periodicals 98 59 55 455 83 455 - 0.00% 2400 Uniforms 143 - - 175 175 - 0.00% Total materials & supplies 1,111 153 244 5,080 1,808 4,680 (400) -7.87% Contractual services 3030 Other professional 9,517 6,941 6,462 13,686 9,499 13,686 - 0.00% 3040 Consultants, special projects (3,110) - 123 - - - - 0.00% 3040 Consultants, development rev - 1,795 1,082 4,000 - 4,000 - 0.00% 3100 Telephone 1,056 1,001 658 900 306 900 - 0.00% 3430 Printing 1,055 1,228 976 1,400 467 1,400 - 0.00% 3610 Memberships 1,170 855 695 805 185 805 - 0.00% 3630 Training and conferences 1,451 1,104 779 900 204 900 - 0.00% 3800 Mileage 174 57 16 100 8 100 - 0.00% Total contractual services 11,313 12,981 10,791 21,791 10,669 21,791 - 0.00% Capital outlays 7030 Equipment 1,066 - - - - - - 0.00% Total capital outlays 1,066 - - - - - - 0.00% Total Community Development 439,112 435,777 384,920 346,454 173,068 351,972 5,518 1.59% 2013 Budget Summary 18 Fund: 100 Department: 4180 Community Development Account Description 2010 2011 2012 2013 Description 1230 Supplies, equipment 700 500 475 475 Miscellaneous equipment & computer peripherals 700 500 475 475 1600 Supplies, operating 250 200 175 175 Presentation supplies 250 200 200 200 Office supplies 500 400 375 375 1700 Motor fuels & lubs - - 3,600 3,200 Unleaded fuel: 800 gallons @ $4.00 (Gas for Comm Devlopment) - - 3,600 3,200 2100 Books & periodicals 90 90 - - Zoning Practice Newsletter 200 100 100 100 Reference materials - 70 80 80 Planning Commission Journal 600 100 100 100 Intl. Code Council Manuals and Code Updates 200 200 175 175 Manuals, pamphlets, etc. 1,090 560 455 455 2400 Uniforms 300 200 175 175 Clothing for inspections staff 300 200 175 175 3030 Other professional 1,400 1,300 1,300 1,300 Ramsey County JPA (geographic information system) 3,875 3,900 3,900 3,900 Permit Works system annual software support (includes busi. lic. mod) 1,725 1,750 1,750 - Business License Module (one time fee)(annual maintenance $375) 800 500 500 500 Filing fees (Ramsey County increased fees from $29 to $48) 1,575 1,600 1,736 3,486 Comcate code enforcement license 1,000 500 500 500 GIS assistance 4,000 4,000 4,000 4,000 Abatements of nuisance properties 14,375 13,550 13,686 13,686 3040-012 Consulting - Development 1,000 1,000 1,000 1,000 Environmental reviews Review (reimbursable)1,000 1,000 1,000 1,000 City attorney services 1,500 1,000 1,000 1,000 Development case reviews 1,500 1,000 1,000 1,000 Engineering services 5,000 4,000 4,000 4,000 3100 Telephone 500 500 500 500 Nextel Cell Accounts (2) for inspectors 600 600 400 400 Sprint network card for code enforcement 1,100 1,100 900 900 3430 Printing 1,500 1,500 1,400 1,400 Forms, flyers, etc. 1,000 - - - Comprehensive plan drafts 2,500 1,500 1,400 1,400 3610 Memberships 550 500 300 300 American Planning Association (APA) - National & state (1) 110 120 120 120 Assoc. of MN Building Officials 60 60 60 60 Fire Marshal's Assoc. of MN 120 120 120 120 International Code Council (ICC) 60 60 60 60 10K Lakes Chapter of ICC 60 60 60 60 MN Assoc. Housing Code Officials 85 85 85 85 MN Building Permit Technicians Association 1,045 1,005 805 805 3630 Training & conferences 500 300 300 300 APA state conference (one attendee) 700 - - - ICC code development hearings (out of state) 300 200 300 300 Other software training 500 300 300 300 Other staff training & seminars 2,000 800 900 900 3800 Mileage 100 100 100 100 Misc. use of personal automobiles 100 100 100 100 7030 Equipment - - - - Computer work station for temp inspector for Medtronic project - - - - Laptop for code enforcement - - - - FDM (Fire department user license software)($2,000 one time) - - - - 28,710 23,715 26,871 26,471 -20.77%-17.40%13.31%-1.49% 19 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Police (100 - 4200): Personnel services: 0100 Salaries, regular 1,469,882 1,401,178 1,397,162 1,462,482 816,319 1,516,728 54,246 3.71% 0110 Overtime 50,022 53,990 65,189 46,659 30,088 48,569 1,910 4.09% 0112 K9 Overtime - - - 6,273 - 6,336 63 1.00% 0150 Salaries, part-time 11,492 5,971 13,650 15,765 8,149 16,779 1,014 6.43% 0300 Social Security 22,338 20,506 22,112 26,027 13,444 26,785 758 2.91% 0321 PERA 201,575 188,773 206,571 212,106 118,455 220,198 8,092 3.82% 0400 Group insurance 183,002 177,468 186,308 221,792 117,147 230,645 8,853 3.99% 0500 Workers compensation 44,474 46,445 39,554 44,787 29,687 47,474 2,687 6.00% 0600 Unemployment 447 1,149 - - - - - 0.00% 0990 Severence - - - - - - - 0.00% Total personnel services 1,983,232 1,895,480 1,930,546 2,035,891 1,133,289 2,113,514 77,623 3.81% Materials & Supplies 1210 Supplies, buildings & grounds 400 400 400 800 400 800 - 0.00% 1230 Supplies, equipment 3,041 115 1,257 2,000 - 12,300 10,300 515.00% 1600 Supplies, operating 6,618 5,953 4,648 6,000 3,989 6,000 - 0.00% 1700 Motor, fuels & lubricants 33,570 41,312 52,304 53,500 29,759 53,500 - 0.00% 2100 Books & periodicals 233 578 670 900 482 900 - 0.00% 2400 Uniforms & clothing 18,932 15,543 24,644 19,760 15,834 19,760 - 0.00% Total materials & supplies 62,794 63,901 83,923 82,960 50,464 93,260 10,300 12.42% Contractual services 3010 General Legal 560 1,552 - - - - - 0.00% 3020 Legal, prosecuting attorney 46,750 56,459 51,000 53,580 21,688 55,142 1,562 2.92% 3030 Other professional services 7,033 2,210 6,780 3,490 349 3,490 - 0.00% 3050 Dispatching 55,755 54,432 76,159 90,189 55,860 94,450 4,261 4.72% 3055 Information systems fees 2,040 2,540 2,030 2,616 2,145 2,616 - 0.00% 3070 COPS events 273 - 196 500 - 500 - 0.00% 3080 Veternarian services 2,525 3,175 3,275 6,000 2,245 6,000 - 0.00% 3100 Telephone 1,917 1,972 2,105 2,000 877 2,150 150 7.50% 3210 Electricity 270 251 269 320 147 320 - 0.00% 3430 Printing 701 675 486 800 315 800 - 0.00% 3610 Memberships 1,861 1,265 1,630 1,660 1,250 1,910 250 15.06% 3630 Training 11,950 9,441 7,163 16,110 3,235 12,515 (3,595) -22.32% 4010 Rental, equipment - - - - - - - 0.00% 4800 Insurance & bonds 18,390 39,968 51,489 28,500 18,265 28,500 - 0.00% 5100 Technology maintenance 33,967 34,191 34,173 23,421 14,122 34,421 11,000 46.97% 5130 Maintenance, equipment 10,570 6,059 5,414 9,449 6,238 9,949 500 5.29% Total contractual services 194,562 214,190 242,169 238,635 126,736 252,763 14,128 5.92% Capital outlays 7030 Equipment 8,134 5,579 575 16,500 9,192 20,000 3,500 21.21% 7040 Vehicles 28,105 - 24,956 - 24,372 - - 0.00% Total capital outlays 36,239 5,579 25,531 16,500 33,564 20,000 3,500 21.21% Total police 2,276,827 2,179,150 2,282,169 2,373,986 1,344,053 2,479,537 105,551 4.45% 2013 Budget Summary 20 Fund: 100 Department: 4200 Police Account Description 2010 2011 2012 2013 Description 1210 Supplies, bldgs & grounds 800 800 800 800 Carpet cleaning & misc maintenance items 800 800 800 800 1230 Supplies, equipment 2,000 2,000 2,000 2,000 Miscellaneous office equipment - - - 10,300 (2) squad computers $8,000, light bar $2,300 2,000 2,000 2,000 12,300 1600 Supplies, operating 3,750 3,750 3,750 3,750 Photo print supplies, fire extinguishers, gloves, inkjet cartridges, toner, etc. - - 500 500 K9 Food 1,750 1,750 1,750 1,750 Batteries, breathalyzer parts, DVD's & CD's, disinfectant, ammunition, crime scene tape, emergency blankets, etc. 5,500 5,500 6,000 6,000 1700 Motor, fuels, & lubs -42,250 42,250 52,000 52,000 Unleaded gas 13,000 gallons @ $4.00/gal. - - 1,500 1,500 K9 take home car gas 42,250 42,250 53,500 53,500 2100 Books & periodicals 1,000 900 900 900 Traf. law, crim. law, HR, employ. law, school year books, & misc. books 1,000 900 900 900 2400 Uniforms & clothing 720 720 720 720 Chief 720 - 720 720 Deputy Chief 5,000 4,000 4,000 4,000 Initial officer set-ups replacing up to two retiring officers 12,240 12,240 12,240 12,240 17 officers @ $720 ($710 in 07, 08, 09, 10, 11) 1,080 1,080 1,080 1,080 Administrative assistant, Clerk-typist, Community Service Officer 1,500 1,000 1,000 1,000 Traffic vests, Taser holsters, & misc items 21,260 19,040 19,760 19,760 3020 Legal, prosecuting attorney 52,530 53,580 53,580 55,142 Retainer ($4,337.50 per month)(misc charges $1,530) 52,530 53,580 53,580 55,142 3030 Other professional services 600 600 600 600 Tobacco compliance project 500 150 150 150 Hazardous material disposal fee 2,200 1,500 1,500 1,500 Lab fees, blood tests, physical tests, video, misc. 240 240 240 240 Automated Pawn service 1,500 1,500 1,000 1,000 Civil Service and medical testing for new officers 5,040 3,990 3,490 3,490 3050 Dispatching 65,319 77,144 90,189 94,450 Ramsey County dispatching 65,319 77,144 90,189 94,450 3055 Informational systems fees 2,101 2,101 2,101 2,101 State service fee - CJDN ($510 per quarter in 07, 08, 09,10,11) 515 515 515 515 IACP.net ($500 annual in 06, 07, 08, 09,10,11) 2,616 2,616 2,616 2,616 3070 COPS events 1,200 800 500 500 National night out, town hall meeting, child ID, stickers 1,200 800 500 500 3080 Veterinarian services 3,750 6,000 5,000 5,000 Brighton Vet Clinic - - 1,000 1,000 K9 vet services 3,750 6,000 6,000 6,000 3100 Telephone 2,000 2,000 2,000 2,150 Nextel cell phones (10 phones) 2,000 2,000 2,000 2,150 3210 Electricity 360 320 320 320 Civil defense siren's electricity 360 320 320 320 21 Fund: 100 Department: 4200 Police Account Description 2010 2011 2012 2013 Description 3430 Printing 1,200 800 800 800 Dept manual, Emergency management manual, business cards, 1,200 800 800 800 3610 Memberships 100 100 100 100 Assoc. Metro Emergency Managers 35 50 100 50 FBI/LEEDA Law Enfor. Execu. Devel. Assoc. 2@ $50 60 60 60 60 Tri-County Investigator Association 45 45 45 45 Mn Crime Prevention Association 35 35 35 35 Mn DARE Officers Association 30 30 100 100 MN Emergency Managers Assoc. 200 200 200 400 Mn Police chiefs 129 129 129 129 IACP (International Association of Chief of Police) 36 36 36 36 MN Sex Crime Investigators Assoc. 30 30 30 30 Natl. Assoc. School Resource Officers 35 35 - - National DARE Officers Association - - - 100 K9 memberships 40 40 140 140 Notary commission (3 year due in 2012)($120+$20) 630 630 630 630 POST license reimbursement 7 @ $90 30 30 30 30 Prof. Law Enforcement Admin. Assoc. 25 25 25 25 National Association of Town Watch 1,460 1,475 1,660 1,910 3630 Training 900 900 900 900 MN Chief's conference - Chief & Dep Chief @ $450 200 200 200 200 BCA/CJDN training 320 320 320 320 Intox certification 1,000 1,000 1,000 1,000 Range Rental 750 - - - Juvenal Officer conference 300 300 300 300 Emergency Management Conference - 400 400 400 MN Sex Crimes Investigators Assoc Conference 4,000 3,000 3,000 3,000 Tuition reimbursement 1,200 1,200 1,200 1,200 Supervisor training - - 5,000 2,000 K9 training 600 600 600 600 Emergency Management training 3,100 2,000 2,000 2,000 Employee development courses 1,190 1,190 1,190 595 Post training for officers at Century College (2 officers) 13,560 11,110 16,110 12,515 4800 Insurance & bonds 18,000 18,500 18,500 18,500 Liability and automotive insurance 5,000 5,500 10,000 10,000 Allowance for insurance policy deductibles 23,000 24,000 28,500 28,500 5100 Technology - maintenance 2,000 2,000 2,000 2,000 Miscellaneous repairs agreements & support 1,200 1,200 1,200 1,200 Copier maintenance + overages (3 yr locked agreement thru March 2011) 32,407 34,027 20,221 31,221 Operating costs of police records management system 35,607 37,227 23,421 34,421 5130 Maintenance, equipment 1,900 2,500 2,500 3,000 Misc. equipment repair - defibs, cameras, recorders, fax, printers. 450 450 450 450 Fire extinguisher recharging 1,500 1,500 1,500 1,500 Squad mobil digital computer repairs 500 500 500 500 Civil Defense siren repair & maint. (all 3 have been replaced 06,07,08) 2,000 2,500 2,500 2,500 Radio repair 3,190 3,190 1,999 1,999 800 MHZ radio licenses fees 37@ 4.48 per month 9,540 10,640 9,449 9,949 7030 Equipment 8,000 - - - 2 replacement squad mobile computers (move to vehicle & equip fund) 2,500 - - - Light bar & Siren (moved to vehicle & equip fund) - - 2,200 - Digital cameras (7) - - 800 - Digital recorder (9) - - 13,500 - K9 ($7,500) and equipment ($800+$2,000+$1,500+$900+$800) 1,100 1,200 - - (1) Taser - - - 20,000 E-ticketing system for 7 squads 11,600 1,200 16,500 20,000 7040 Vehicles - Patrol 29,000 29,000 - - (squade purchases moved to vehicle and equipment capital project fund) 29,000 29,000 - - 330,592 332,392 338,095 366,023 -9.50%0.54%1.72%8.26% 22 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Fire (100 - 4210): Personnel services 0100 Salaries, regular - - - 20,518 6,988 6,841 (13,677) -66.66% 0300 Social Security - - - 1,570 92 523 (1,047) -66.69% 0321 PERA - - - 1,488 1,006 496 (992) -66.67% 0400 Group insurance - - - 3,578 1,353 1,440 (2,138) -59.75% 0500 Workers compensation - - - 108 72 37 (71) -65.74% Total personnel services - - - 27,262 9,511 9,337 (17,925) -65.75% Contractual services 3032 Contractual fire services 279,336 278,750 270,579 282,761 259,197 291,418 8,657 3.06% 3050 Dispatching 3,640 3,866 3,878 4,270 - 4,355 85 1.99% Total contractual services 282,976 282,616 274,457 287,031 259,197 295,773 8,742 3.05% Capital outlays: 7040 Vehicles & equipment 35,789 49,452 257,271 11,340 11,340 5,736 (5,604) -49.42% Total capital outlays 35,789 49,452 257,271 11,340 11,340 5,736 (5,604) -49.42% Debt Service: 8010 Principal - - - 97,524 48,681 100,548 3,024 3.10% 8020 Interest - - - 39,975 20,068 37,192 (2,783) -6.96% Total debt service - - - 137,499 68,749 137,740 241 (0) Total Fire 318,765 332,068 531,728 463,132 348,797 448,586 3,379 0.73% 2013 Budget Summary 23 Fund: 100 Department: 4210 Fire Account Description 2010 2011 2012 2013 Description 3032 Contractual fire services 278,750 270,573 282,761 291,418 Share of joint fire dept. op. costs (11 - 14.77%,12 - 15.12%,13 - 15.095%) 278,750 270,573 282,761 291,418 3050 Dispatching 4,000 4,000 4,270 4,355 Anoka County dispatching fee 4,000 4,000 4,270 4,355 7040 Capital, vehicles & equipment 46,452 22,894 11,340 5,736 Share of joint fire department's capital costs 46,452 22,894 11,340 5,736 8010 Interest - 2005 Fire bond - - 37,106 35,125 15.095% of interest payment on 2005 Fire bonds Interest - 2011 Equip Certs - - 2,869 2,068 15.095% of interest payment on 2011 Equipment Certificates 8020 Principal - 2005 Fire bond - - 52,164 53,676 15.095% of principal payment on 2005 Fire bonds Principal - 2011 Equip Certs - - 45,360 46,872 15.095% of principal payment on 2011 Equipment Certificates - - 137,499 137,741 329,202 297,467 435,870 439,250 -0.24%-9.64%46.53%0.78% 24 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Recreation (100 - 4350): Contractual services: 3036 Contractual recreation 107,201 100,805 102,335 105,500 70,763 105,500 - 0.00% 4800 Bonding & insurance 1,446 1,303 1,291 1,700 819 1,700 - 0.00% Total contractual services 108,647 102,108 103,626 107,200 71,582 107,200 - 0.00% Total Recreation 108,647 102,108 103,626 107,200 71,582 107,200 - 0.00% 2013 Budget Summary 25 Fund: 100 Department: 4350 Recreation Account Description 2010 2011 2012 2013 Description 3036 Contractual recreation 95,400 97,400 95,000 95,000 Management of recreation & park programs by YMCA 10,500 10,500 10,500 10,500 Ice Skating supervision 18,000 - - - Playground supervision 123,900 107,900 105,500 105,500 4800 Bonding & insurance 1,700 1,700 1,700 1,700 Insurance & bonding cost. 1,700 1,700 1,700 1,700 125,600 109,600 107,200 107,200 0.00%-12.74%-2.19%0.00% 26 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent 2013 Budget Summary Parks (100 - 4360): Personnel services 0100 Salaries, regular 118,198 117,118 116,492 117,345 64,533 118,529 1,184 1.01% 0110 Overtime, regular 5,749 4,275 4,976 4,419 2,930 4,463 44 1.00% 0150 Salaries, part-time 47,152 35,379 30,857 36,000 19,299 36,000 - 0.00% 0300 Social Security 11,980 11,237 11,034 12,070 6,299 12,163 93 0.77% 0321 PERA 9,635 9,554 8,617 8,827 4,912 8,917 90 1.02% 0400 Group insurance 20,335 19,063 19,273 22,016 12,047 23,040 1,024 4.65% 0500 Workers compensation 4,537 4,956 4,643 5,196 3,444 5,340 144 2.77% 0600 Unemployment - - 6,188 - - 0.00% Total personnel services 217,586 201,582 202,080 205,873 113,464 208,452 2,579 1.25% Materials & supplies: 1210 Supplies, bldgs & grnds 12,927 10,757 9,211 13,160 2,949 9,110 (4,050) -30.78% 1220 Supplies, vehicles 8,455 11,015 7,627 8,000 6,025 8,000 - 0.00% 1230 Supplies, equipment 1,285 1,930 2,931 3,750 1,634 3,750 - 0.00% 1600 Supplies, operating 5,788 9,399 4,766 6,500 6,646 7,800 1,300 20.00% 1700 Motor fuels & lubs 5,452 9,388 10,628 11,250 5,311 11,250 - 0.00% 2400 Uniforms & clothing 1,711 965 1,518 975 730 975 - 0.00% 2410 Mats & towels 1,436 1,307 958 850 701 850 - 0.00% Total materials & supplies 37,054 44,761 37,639 44,485 23,996 41,735 (2,750) -6.18% Contractual services: 3030 Other professional services 526 125 1,312 3,650 4,268 6,300 2,650 72.60% 3100 Telephone 2,603 1,535 1,264 1,490 696 1,790 300 20.13% 3200 Water & sewer 3,998 8,103 8,603 6,000 79 6,000 - 0.00% 3210 Electricity 5,670 5,423 6,435 6,000 3,204 6,000 - 0.00% 3220 Natural gas 4,880 4,145 4,222 4,800 2,155 4,800 - 0.00% 3530 Refuse collection - 662 - - - - - 0.00% 3610 Memberships 63 64 - 260 - 220 (40) -15.38% 3630 Training & conferences 1,878 919 809 1,460 325 740 (720) -49.32% 3900 Grants & subsidies 10,608 10,608 10,608 10,608 23,108 10,608 - 0.00% 4010 Rental, equipment - 41 51 500 222 350 (150) -30.00% 4030 Portable restrooms 5,753 4,212 2,387 3,000 2,075 3,000 - 0.00% 4800 Bonding & insurance 14,458 12,602 17,127 16,000 7,709 16,000 - 0.00% 5110 Repairs, bldg & grounds 5,311 2,007 6,013 3,500 1,498 3,500 - 0.00% Total contractual services 55,748 50,446 58,831 57,268 45,339 59,308 2,040 3.56% Capital outlays 7030 Equipment - - - - - 8,000 8,000 0.00% 7050 Construction - - - - - - - Total capital outlays - - - - - 8,000 8,000 0.00% Total Parks 310,388 296,789 298,550 307,626 182,799 317,495 9,869 3.21% 27 Fund: 100 Department: 4360 Parks Account Description 2010 2011 2012 2013 Description 1210 Supplies, bldgs & grounds 200 200 200 200 Replace bleacher parts 200 200 200 200 Repair hockey boards, gates 200 300 300 300 Sod 300 400 400 400 Janitorial supplies 210 150 150 150 Snow shovels 210 210 210 210 Ice melt 400 600 500 500 Round up 500 700 - - Repair fences, nets 500 500 500 500 Perennial flowers for park signs 700 700 - - Replace play equipment parts - - 1,500 1,500 Damaged building components (windows, locks, etc.) - - 100 150 Graffiti remover - - - - Broadleaf control (move from 3030) 500 500 500 500 Goose repellent 2,000 2,000 2,000 2,000 Replace irrigation heads 2,500 2,500 2,500 2,500 Seed, fertilizer 8,420 8,960 9,060 9,110 1220 Supplies, vehicles 4,300 4,300 6,500 6,500 Oil filters, mower blades, tires, vehicle registration fees, 500 500 1,500 1,500 Miscellaneous repairs 4,800 4,800 8,000 8,000 1230 Supplies, equipment 250 250 250 250 Drinking fountain parts - - 250 250 Field Lights 450 450 250 250 Park signage 250 250 500 500 Magnetic bases, jox boxes, etc. (jox box CHP 2014)(2 in Silverview) 1,250 1,000 2,500 2,500 Replace park equipment, fixtures and misc parts 2,200 1,950 3,750 3,750 1600 Supplies, operating 1,000 800 800 1,500 Sand/fiber fill for play lots & courts 100 200 200 200 Tri mix 600 800 800 1,200 Wood chips for trees 900 500 500 500 Ag-lime for fields 500 500 500 500 Surface drying compound 400 400 400 400 Nets 1,400 1,400 2,500 2,700 Field paint & chalk (partially reimb by school district) 1,000 - - - Jox box (Silverview (2), CH park (1) in 2014) 1,200 800 800 800 Landscaping materials 1,100 600 - - Percentage of shop costs 8,200 6,000 6,500 7,800 1700 Motor fuels & lubes 6,500 5,850 7,200 7,200 1,800 gallons of unleaded gas @ $4.00 3,750 3,375 4,050 4,050 900 gallons of diesel fuel @ $4.50 10,250 9,225 11,250 11,250 2400 Uniforms & clothing 434 434 175 175 Clothing allowance 1.0 FTE 1,596 1,596 600 600 Uniforms 10% of $6,000 - - 200 200 Safety glasses, masks, ear protection, etc. 2,030 2,030 975 975 2410 Mats & towels 800 800 850 850 Share of floor mats and shop towels 10% of $8,500 800 800 850 850 3030 Other professional services 155 155 240 240 Fire extinguisher inspection/maint. (2@ $120) - - 450 600 HVAC maintenance - - 840 840 Fire sprinkler testing (4@ $210) - 225 120 120 Backflow prevention testing (2@ $60) 5,000 2,500 4,100 4,500 Broadleaf control (move from 1210) 2,000 2,000 2,000 - Tree trimming (forestry) 7,155 4,880 7,750 6,300 28 Fund: 100 Department: 4360 Parks (continued) Account Description 2010 2011 2012 2013 Description 3100 Telephone 1,200 1,200 1,490 1,490 Cellular phones (17.5% of $8,500) - - - - Replace telephones in park buildings 300 300 - 300 Security at Silver View (phones removed from park buildings) 1,500 1,500 1,490 1,790 3200 Water & wastewater 7,500 6,000 6,000 6,000 Parkland irrigation & park bathrooms 7,500 6,000 6,000 6,000 3210 Electricity 6,500 6,500 6,000 6,000 Est. 5 park buildings, park sec. lighting, court & field lighting & misc. 6,500 6,500 6,000 6,000 3220 Natural gas 5,000 5,000 4,800 4,800 Heating cost for Random, Hillview, Groveland, & Lambert Park bldgs. 5,000 5,000 4,800 4,800 3610 Memberships - - - - MN Recreation & Park Assoc 65 65 40 40 Minnesota Safety Council - - 50 50 Playground inspector license - - 20 30 Pesticide license renewal - - 50 - State low voltage electrical licenses - 100 100 100 Tree inspector license 65 165 260 220 3630 Training & conferences 40 40 - - Chemical applicator license 75 75 75 75 Computer classes 200 200 - - Confined space training 120 120 100 100 Hearing tests/RTN training (2@$50) 370 370 250 - Low voltage/power limited training 60 60 60 60 Maintenance EXPO 110 110 110 110 Loss control workshops - - 570 100 Playground inspection training - - 210 210 Equipment training (10% of $2,050) 200 200 - - Pesticide application class (every 3 years) 20 20 - - Pesticide license renewal (every 3 years) 100 100 - - State low voltage electrical licenses (2) 450 450 - - Sewer, Water & traffic certificates - - 85 85 Tree inspector trainig 60 - - - Work zone traffic control 1,805 1,745 1,460 740 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 500 350 Tools and equipment (add rental of sod cutter 2012) 200 200 500 350 4030 Portable restrooms 6,300 6,150 3,000 3,000 For May thru Oct, plus special events such as tournaments, & extra cleanings and insurance 6,300 6,150 3,000 3,000 4800 Bonding & insurance 12,000 12,000 12,000 12,000 Insurance policy premiums 3,000 3,000 4,000 4,000 Allowance for insurance policy deductibles 15,000 15,000 16,000 16,000 5110 Repairs, bldgs & grounds 500 1,000 500 500 Windows, doors, & lock repairs 500 1,000 - - Replace locks 500 500 500 500 Field light repairs 500 1,500 2,500 2,500 Repairs to furnaces, plumbing, phones, electrical, etc 2,000 4,000 3,500 3,500 7030 Capital, equipment - - - - Mower replacement 16ft deck mower (vehicle & equip. fund) - - - 8,000 Utility cart - 24,000 - - Chipper - 36,000 - - Replace #404 F250 (Move to 2014) - 6,000 - - Plow for unit #428 - 66,000 - 8,000 100,333 161,513 101,753 109,043 -29.87%60.98%-37.00%7.16% 29 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent 2013 Budget Summary Forestry (100 - 4380): Materials & supplies 1200 Supplies, landscaping 581 781 3,338 3,000 705 13,000 10,000 333.33% Total materials & supplies 581 781 3,338 3,000 705 13,000 10,000 333.33% Contractual services 3030 Professional services 25,097 11,365 19,068 24,000 23,930 24,000 - 0.00% 3033 Joint powers forester 19,659 - - - - - - 0.00% 3520 Tree removal 5,109 22,224 31,244 28,000 9,279 41,500 13,500 48.21% 3610 Memberships - 15 - - - - - 0.00% 3630 Training & conferences 50 - - - - - - Total contractual services 49,915 33,604 50,312 52,000 33,209 65,500 13,500 25.96% Capital outlays 7030 Equipment - - - - - - 0.00% Total Forestry 50,496 34,385 53,650 55,000 33,914 78,500 23,500 42.73% 30 Fund: 100 Department: 4380 Forestry Account Description 2010 2011 2012 2013 Description 1200 Supplies, landscaping 575 400 400 400 Landscaping materials 575 800 800 800 Small trees to replace damaged trees 3,100 1,800 1,800 1,800 Large trees - storm damage replacement - - - 7,500 Ash tree replacement trees (MN DNR grant) - - - 2,500 EAB treatment supplies 4,250 3,000 3,000 13,000 3030 Professional services 11,000 9,000 9,000 9,000 Tree trimming - 15,000 15,000 15,000 Forestry consulting 2,000 - - - Tree trimming around Silver View Park 13,000 24,000 24,000 24,000 3033 Joint powers forester 16,000 - - - Amount per joint powers agreement 16,000 - - - 3520 Tree removal 28,000 28,000 28,000 28,000 Remove or treat diseased trees - - - 13,500 Ash tree removal (MN DNR grant) 28,000 28,000 28,000 41,500 3630 Training & memberships 200 - - - Forestry licensing seminar 200 - - - 61,450 55,000 55,000 78,500 -14.07%-10.50%0.00%42.73% 31 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Public Works Administration (100-4410): Personnel services: 0100 Salaries, regular 63,041 84,610 91,408 94,727 52,896 96,839 2,112 2.23% 0150 Salaries, part-time 80 - 21 754 - 754 - 0.00% 0300 Social Security 4,451 6,020 6,502 7,305 3,769 7,466 161 2.20% 0321 PERA 4,237 5,906 6,610 6,868 3,809 7,021 153 2.23% 0400 Group insurance 9,121 12,233 13,205 14,696 6,795 13,915 (781) -5.31% 0500 Workers compensation 1,306 1,377 977 1,138 754 1,209 71 6.24% Total personnel services 82,236 110,146 118,723 125,488 68,023 127,204 1,716 1.37% Materials & supplies: 1600 Operating supplies 153 131 - 200 192 200 - 0.00% 2400 Uniforms & clothing - 291 336 400 - 400 - 0.00% Total materials and supplies 153 422 336 600 192 600 - 0.00% Contractual services: 3030 Other professional services 23,503 361 - 340 - 340 - 0.00% 3100 Telephone - - - 720 332 720 - 0.00% 3610 Memberships 433 571 449 710 349 710 - 0.00% 3630 Training & conferences 469 167 474 995 300 895 (100) -10.05% 3800 Mileage reimbursement - 88 112 300 158 300 - 0.00% Total contractual services 24,405 1,187 1,035 3,065 1,139 2,965 (100) -3.26% Capital outlays: 7030 Equipment - - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total public works administration 106,794 111,755 120,094 129,153 69,354 130,769 1,616 1.25% 2013 Budget Summary 32 Fund: 100 Department: 4410 Public Works Adminstration Account Description 2010 2011 2012 2013 Description 1600 Operating Supplies 200 200 200 200 Office supplies 200 200 200 200 2400 Uniforms & clothing 400 400 400 400 33% of Supervisor's uniform cost. 400 400 400 400 3030 Other professional services 100 100 100 100 Physicals & drug testing - new employee 700 - - - EJCDC Construction document set 240 240 240 240 Drug & alcohol testing - federal mandate 1,040 340 340 340 3100 Telephone - - 720 720 Cellphone 8.5% of $8,500 - - 720 720 3610 Memberships/license fee 113 113 150 150 American Public Works Association memb. (APWA) (1/4 of $600) 60 60 60 60 City Engineer's Association of MN (CEAM) 40 40 40 40 NASASP (National Assoc. of State Agencies for Surplus Property) 275 275 30 30 MN Safety Council 200 - 200 200 MN Board of AELSLAGID (PE Renewal even years) 195 195 230 230 American Society of Civil Engineers 883 683 710 710 3630 Training & conferences 600 600 600 500 CEAM / APWA conferences 50 50 50 50 Computer classes/Web training 100 100 - - Confined space training 60 60 15 15 Hearing tests/RTN training (.34 FTE@$50) 30 30 30 30 Maintenance Expo 100 - - - Pesticide applicator's class 10 - - - Pesticide license renewal 200 200 200 200 Required continuing education seminars 100 100 100 100 Supervisor training 30 - - - Work zone traffic control 1,280 1,140 995 895 3800 Mileage reimbursement 300 300 300 300 vehicle mileage reimbursement 300 300 300 300 7030 Capital, equipment - - - - - - 4,103 3,063 3,665 3,565 3.74%-25.35%19.65%-2.73% 33 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent 2013 Budget Summary Building & Grounds Maintenance (100 - 4460): Personnel services: 0100 Salaries, regular 11,676 11,776 11,721 11,807 6,563 11,928 121 1.02% 0110 Salaries, overtime 764 975 442 954 33 963 9 0.94% 0300 Social Security 813 833 788 976 474 986 10 1.02% 0321 PERA 839 883 870 925 480 935 10 1.08% 0400 Group insurance 2,564 2,694 2,621 2,752 1,601 2,880 128 4.65% 0500 Workers compensation 598 687 369 414 274 426 12 2.90% Total personnel services 17,254 17,848 16,811 17,828 9,425 18,118 290 1.63% Materials & supplies: 1210 Supplies, building & grounds 329 2,498 1,456 1,500 386 1,500 - 0.00% 1220 Supplies, vehicles - - - - 15 - - 0.00% 1230 Supplies, equipment 928 237 1,681 690 546 690 - 0.00% 1600 Supplies, operating 3,767 4,355 3,416 4,800 1,518 4,500 (300) -6.25% 2400 Uniforms & clothing - - 118 195 95 195 - 0.00% 2410 Mats & towels - - 212 210 175 210 - 0.00% Total materials & supplies 5,024 7,090 6,883 7,395 2,735 7,095 (300) -4.06% Contractual services: 3030 Other professional services 25,590 18,243 25,172 24,520 15,056 24,520 - 0.00% 3100 Telephone - - - 130 59 130 - 0.00% 3200 Water & sewer 1,773 985 972 1,800 141 1,800 - 0.00% 3210 Electricity 24,238 24,452 26,334 25,000 12,509 25,000 - 0.00% 3220 Natural gas 22,474 18,098 19,511 20,000 10,359 20,000 - 0.00% 3530 Refuse collection 9,183 11,057 10,602 11,005 4,415 11,005 - 0.00% 4010 Rental, equipment - - - 205 118 205 - 0.00% 4800 Insurance 10,850 5,826 5,316 7,000 3,373 7,000 - 0.00% 5110 Repairs, bldgs & grounds 4,470 10,096 15,919 8,325 5,695 8,325 - 0.00% 5130 Repairs, equipment 11,583 6,081 5,849 5,000 1,593 5,000 - 0.00% Total contractual services 110,161 94,838 109,675 102,985 53,318 102,985 - 0.00% Capital outlays 7030 Equipment - - - 1,750 1,734 5,100 3,350 191.43% Total capital outlays - - - 1,750 1,734 5,100 3,350 191.43% Total buildings & grounds 132,439 119,776 133,369 129,958 67,212 133,298 3,340 2.57% 34 Fund: 100 Department: 4460 Building & Ground Maintenance Account Description 2010 2011 2012 2013 Description 1210 Supplies, bldgs & grounds 1,500 1,500 1,500 1,500 Bldg repairs, cleaning/heating supplies, batteries. 1,500 1,500 1,500 1,500 1230 Supplies, equipment 430 430 430 690 Repair parts, filters, hoses, etc. 690 690 690 690 1600 Supplies, operating 300 300 500 500 Cleaning supplies 300 300 300 300 Lumber & fasteners 550 550 550 550 Repair items & hardware 300 300 300 300 First aid supplies 500 500 500 500 Light bulbs & ballasts 500 500 500 500 Paper supplies 500 500 500 500 Mechanical items, fans, motors, etc 750 250 250 250 Goose repellent 500 500 500 200 Weed control - city hall 400 400 200 200 Office supplies 100 - - - Meeting refreshments 600 600 - - Steel supplies 700 700 700 700 Paint & supplies - parking lot & building 6,000 5,400 4,800 4,500 2400 Uniforms & clothing 120 120 150 150 Uniforms (2.5% of $6,000) - - 45 45 Clothing & boot allowance (.25 @$175) 120 120 195 195 2410 Mats & towels - - 210 210 Share of floor mats and shop towels (2.5% of $8,500) - - 210 210 3030 Other professional services 700 700 180 180 Backflow prevention testing (3@$60) 60 60 60 60 Boiler & pressure vessel registration program 2,500 2,500 3,250 3,250 HVAC maintenance (City Hall & PW facilities) 100 100 100 100 MN DOL operating permit - elevator (previously in acct. 5110) 15,750 15,750 15,300 15,300 City Hall cleaning contract 3,000 3,000 3,500 3,500 Carpet cleaning, floor striping & waxing (2 times) 250 250 210 210 Fire monitoring service (City hall sprinkler system) 1,350 1,350 1,320 1,320 Pest control (12@$110) 1,000 1,000 600 600 Fire extingiusher inspection/service (30@$20) 24,710 24,710 24,520 24,520 3100 Telephone - - 130 130 Cellphone (1.5% of $8,500) - - 130 130 3200 Water & Sewer 1,800 1,800 1,800 1,800 Service at City Hall and Public Works buildings 1,800 1,800 1,800 1,800 3210 Electricity 25,000 25,000 25,000 25,000 Electricity at City Hall and Public Works buildings 25,000 25,000 25,000 25,000 3220 Natural gas 26,612 26,612 20,000 20,000 Natural gas at City Hall and Public Works buildings 26,612 26,612 20,000 20,000 3530 Refuse collection 130 130 130 130 Lamps $100, batteries $30 260 260 264 264 Hazardous waste annual fee (State of MN PCA) - - 230 230 Hazardous waste generator license fee (Ramsey County) 500 400 150 150 Used oil filters ($100 in vehicle maint.) 8,200 8,200 9,200 9,200 Facility dumpsters, city hall, public works 1,031 1,031 1,031 1,031 Hazardous waste disposal 10,121 10,021 11,005 11,005 4010 Rental, equipment 205 205 205 205 Misc. rentals 205 205 205 205 4800 Bonding & insurance 5,500 5,500 5,500 5,500 Insurance policy premiums 1,500 1,500 1,500 1,500 Allowance for insurance policy deductibles 7,000 7,000 7,000 7,000 5110 Repairs, bldgs & grounds 1,300 1,300 1,300 1,300 Door & gate opener repairs 2,100 2,100 2,100 2,100 Building repairs 456 456 575 575 Elevator maintenance 350 350 350 350 Fire sprinklers & alarm repairs 4,000 4,000 4,000 4,000 General building & ground maintenance 8,206 8,206 8,325 8,325 5130 Repairs, equipment 515 - - - Telephone repairs 5,000 5,000 5,000 5,000 HVAC, plumbing & electrical repairs - - - - HVAC safety improvements per LMCIT (one time upgrades to boiler) 200 200 - - Multi-function office machine repair 1,400 - - - Oil heater maintenance 7,115 5,200 5,000 5,000 7030 Capital, equipment - - - - Floor scrubber for shop (1 in 2008 and 2009) - - 1,750 - Walk behind broom (1/2 bldg. 1/2 MVCC) - - - 5,100 800 amp panelboard (city hall) - - 1,750 5,100 119,079 116,464 112,130 115,180 -4.42%-2.20%-3.72%2.72% 35 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent 2013 Budget Summary Vehicle & Equipment Maintenance (100 - 4465): Personnel services: 0100 Salaries, regular 30,277 30,241 30,743 30,640 17,041 30,946 306 1.00% 0110 Salaries, overtime 72 141 282 516 386 521 5 0.97% 0300 Social Security 2,137 2,262 2,317 2,383 1,297 2,407 24 1.01% 0321 PERA 1,933 2,122 2,250 2,258 1,273 2,282 24 1.06% 0400 Group insurance 3,892 4,242 4,262 5,414 2,794 5,918 504 9.31% 0500 Workers compensation 1,462 1,729 897 1,009 669 1,040 31 3.07% Total personnel services 39,773 40,737 40,751 42,220 23,460 43,114 894 2.12% Materials & supplies: 1220 Supplies, vehicles 14,329 17,606 18,515 15,450 10,300 16,350 900 5.83% 1230 Supplies, equipment 1,929 3,157 4,042 2,600 521 2,600 - 0.00% 1600 Supplies, operating 1,995 2,920 4,069 3,550 2,682 3,850 300 8.45% 1700 Motor fuels & lubricants 4,729 5,071 4,041 2,010 2,434 2,460 450 22.39% 2400 Uniforms & clothing 1,871 577 1,128 465 227 465 - 0.00% 2410 Mats & towels 1,407 1,313 586 510 412 510 - 0.00% Total materials & supplies 26,260 30,644 32,381 24,585 16,576 26,235 1,650 6.71% Contractual services: 3100 Telephone 1,143 1,329 1,113 300 138 300 - 0.00% 3530 Refuse collection - - 115 100 - 100 - 0.00% 3610 Memberships 63 64 - 80 - 80 - 0.00% 3630 Training 48 456 958 605 35 630 25 4.13% 4010 Rental, equipment - - - 100 - 100 - 0.00% 5120 Repairs, vehicles 6,352 13,376 14,774 10,900 5,334 11,700 800 7.34% 5130 Repairs, equipment 11,189 2,954 4,398 5,500 1,621 5,500 - 0.00% Total contractual services 18,795 18,179 21,358 17,585 7,128 18,410 825 4.69% Capital outlays 7030 Equipment - - - - - 6,000 6,000 0.00% 7050 Construction - - - - - - - 0.00% Total capital outlays - - - - - 6,000 6,000 0.00% Total vehicle & equipment maintenance 84,828 89,560 94,490 84,390 47,164 93,759 9,369 11.10% 36 Fund: 100 Department: 4465 Vehicle & Equipment Maintenance Account Description 2010 2011 2012 2013 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 1,550 1,550 Minor repairs, rebuilds 900 900 1,100 1,100 Automotive parts 1,100 1,100 1,500 1,500 Filters: oil, air, fuel, transmission 1,300 1,300 1,300 1,500 Brake pads & shoes 6,400 6,400 6,800 7,500 Tires & batteries 13,450 13,450 15,450 16,350 1230 Supplies, equipment 200 200 200 200 Small equipment tune up items 500 400 400 400 Filters belts & hoses 1,100 1,000 1,000 1,000 Hydraulic system repairs 1,000 1,000 1,000 1,000 Tires - dump trucks, loader, & backhoe 2,800 2,600 2,600 2,600 1600 Supplies, operating 900 1,525 900 1,200 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 500 500 Steel for repairs & fabrication 500 500 500 500 Solvents & degreasers 500 500 500 500 Fastners & electrical supplies 3,250 3,875 3,550 3,850 1700 Motor fuels & lubs 60 60 60 60 Gear lube 450 450 450 200 ATF - 7 cases 750 600 600 200 Aftermarket additives 900 900 900 2,000 Engine oil: 150 gallons (synthetic) 2,925 2,925 - - Unleaded fuel: 900 gallons @ $4.00 (moved to Comm Dev) 5,085 4,935 2,010 2,460 2400 Uniforms & clothing 600 600 360 360 Uniforms 6% of $6,000) - - 105 105 Clothing and boot allowance (.6@$175) 600 600 465 465 2410 Mats & towels 650 650 510 510 Share of floor mats and shop towels (6% of $8,500) 650 650 510 510 3100 Communications 1,000 1,150 300 300 Cellular telephone (3.5% of $8,500) 1,000 1,150 300 300 3530 Refuse collection - 100 100 100 Oil filter recycling - 100 100 100 3610 Memberships 60 60 60 60 Vehicle inspection license renewal (DOT required) 65 65 20 20 Minnesota Safety Council (6% of $465) 125 125 80 80 3630 Training 50 - - - Computer classes 100 100 - - Confined space training 200 - - - Electronics updates, other classes 60 60 30 30 Hearing test/RTN training (.6@$50) - - 120 120 Equipment operation training (Skidsteer & boom) 30 30 30 30 Maintenance Expo 50 200 200 200 Misc training 160 180 150 175 ASE certification 300 300 - - Water/sewer license 75 75 75 75 Vehicle inspection recertification (DOT required) 30 - - - Work zone traffice control 1,055 945 605 630 4010 Rental, equipment 100 100 100 100 Specialty tool & equipment rental and mileage reimbursement 100 100 100 100 5120 Repairs, vehicles 4,500 4,500 4,500 4,500 Accident repairs 400 400 400 400 Alignments 1,000 1,000 1,000 1,000 Glass replacement 400 400 400 400 Radiator repairs, replacement 700 500 500 1,000 Tire repairs 600 700 700 700 Ignition scanner software update - 1,400 1,400 1,700 Mitchell On Demand Software 2,000 2,000 2,000 2,000 Transmission repairs 9,600 10,900 10,900 11,700 5130 Repairs, equipment 500 500 500 500 Accident repairs 3,000 3,000 3,000 3,000 Mechanical repairs 2,000 2,000 2,000 2,000 Motor repairs 5,500 5,500 5,500 5,500 7030 Capital, equipment - - - 6,000 Hoist adaptor - - - 6,000 43,215 44,930 42,170 50,645 2.05%3.97%-6.14%20.10% 37 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent 2013 Budget Summary Street Pavement Management (100 - 4470): Personnel services: 0100 Salaries, regular 78,420 87,408 90,637 92,701 52,606 94,175 1,474 1.59% 0110 Salaries, overtime 1,737 2,471 2,725 2,946 1,799 2,976 30 1.02% 0150 Salaries, part-time 18,744 8,771 5,295 7,200 6,638 7,200 - 0.00% 0300 Social Security 7,360 7,290 7,306 7,868 4,523 7,984 116 1.47% 0321 PERA 5,387 6,262 6,747 6,934 3,887 7,043 109 1.57% 0400 Group insurance 11,003 13,513 14,280 14,802 6,404 12,318 (2,484) -16.78% 0500 Workers compensation 4,249 4,981 4,306 4,853 3,217 5,009 156 3.21% 0990 Severence pay - - - - - - 0.00% Total personnel services 126,900 130,696 131,296 137,304 79,074 136,705 (599) -0.44% Materials & supplies: 1230 Supplies, equipment 1,628 1,169 993 500 815 10,000 9,500 1900.00% 1240 Supplies, streets 40,299 32,119 22,910 21,100 6,442 21,700 600 2.84% 1260 Supplies, traffic control 1,183 27 26 1,000 107 500 (500) -50.00% 1600 Supplies, operating 1,558 3,124 11,545 1,680 807 1,680 - 0.00% 1700 Motor fuels & lubricants 4,354 10,988 11,672 11,950 4,897 11,950 - 0.00% 2400 Uniforms & clothing 808 777 697 775 492 775 - 0.00% 2410 Mats & towels 1,427 1,014 884 850 686 850 - 0.00% Total materials & supplies 51,257 49,218 48,727 37,855 14,246 47,455 9,600 25.36% Contractual services: 3030 Other professional services 20,472 3,663 7,344 6,550 1,977 8,300 1,750 26.72% 3100 Telephone 1,127 1,375 1,118 890 423 890 - 0.00% 3160 Memberships - - 149 210 154 210 - 0.00% 3630 Training & conferences 1,097 1,079 577 1,090 650 1,090 - 0.00% 4010 Rental, equipment - 1,736 3,206 4,500 - 5,000 500 11.11% 4800 Insurance 10,599 4,752 5,031 6,200 2,987 6,200 - 0.00% 5130 Repairs, equipment - 907 281 500 - 500 - 0.00% 5140 Repairs, streets - - - - - - - 0.00% Total contractual supplies 33,295 13,512 17,706 19,940 6,191 22,190 2,250 11.28% Capital outlays 7030 Equipment - - 132,648 1,500 - 5,200 3,700 246.67% Total capital outlays - - 132,648 1,500 - 5,200 3,700 246.67% Total street pavement management 211,452 193,426 330,377 196,599 99,511 211,550 14,951 7.60% 38 Fund: 100 Department: 4470 Pavement Management Account Description 2010 2011 2012 2013 Description 1230 Supplies, equipment 500 500 500 500 Safety vest, hearing protection, safety protection - - 1,500 4,500 Radial arm saw - - - 5,000 Rear cameras for plow trucks 450 - - - Skid steer bucket (1/2 in snow & ice) 950 500 2,000 10,000 1240 Supplies, street repair 20,000 20,000 20,000 20,000 Asphalt & concrete for street patching & repair (winter mix $130 per ton) 500 500 500 500 Disposal ($10.00 per load X 50) 600 600 600 1,200 Bituminous tack coat/crack fill material 21,100 21,100 21,100 21,700 1260 Supplies, traffic control 180 700 700 400 Traffic cones/baracades 300 300 300 100 portable signs (traffic control) 480 1,000 1,000 500 1600 Supplies, operating 380 380 380 380 Asphalt hand tools, rakes, etc. 1,235 1,300 1,300 1,300 Traffic marking paint 500 - - - 10' straight edge, IR temp gauge 2,115 1,680 1,680 1,680 1700 Motor fuels & lubs 5,625 5,625 6,750 6,750 Diesel fuel: 1500 gallons @ $4.50. 2,200 - - - Propane: 1100 gallons @ $2 4,225 4,225 5,200 5,200 Unleaded fuel: 1300 gallons @ $4.00 12,050 9,850 11,950 11,950 2400 Uniforms & clothing 1,920 1,920 600 600 Uniforms (10% of $6,000) - - 175 175 Clothing and boot allowance (1@$175) 1,920 1,920 775 775 2410 Mats & towels 700 700 850 850 Share of floor mats and shop towels (10% of $8,500) 700 700 850 850 3030 Other professional services 1,800 1,800 1,800 1,800 Pavement Mgmt software annual maintenance. 3,305 1,000 1,000 1,000 Engineering services. 250 250 250 - Annual certification of weight scales - - - 2,000 Sidewalk joint corrections 3,295 3,500 3,500 3,500 Striping of streets, crosswalks, & school crossings. (Ramsey County) 8,650 6,550 6,550 8,300 3100 Communications 1,200 1,200 890 890 Cellular telephones (10.5% of $8,500) 1,200 1,200 890 890 3610 Memberships 113 113 150 150 American Public Works Association memb. (APWA) (1/4 of $452) 10 10 20 20 Pesticide license renewal - - 40 40 MN Safety Council 113 113 210 210 3630 Training & conferences 50 50 50 50 Computer classes 200 200 - - Confined space training 200 200 200 200 Electronics updates, other classes 150 150 60 60 Hearing test/RTN training (1.16@$50) 60 60 60 60 Maintenance Expo 125 125 125 125 APWA/MN conferences. 250 250 250 250 Pavement, sealcoating, patching & sealcoating seminars. - - 210 210 Equipment operator training 100 100 - - Pesticide applicator's class (every 3 years) 60 60 60 60 Vehicle inspection license renewal 75 75 75 75 Vehicle inspection recertification 60 - - - Work zone traffice control (every 3 years) 1,330 1,270 1,090 1,090 4010 Rentals, equipment 3,800 3,800 3,800 3,800 Annual trade-in of skid steer loaders - - 700 1,200 Specialized equip rental 3,800 3,800 4,500 5,000 4800 Bonding & insurance 4,800 4,800 4,800 4,800 Insurance policy premiums 1,400 1,400 1,400 1,400 Allowance for insurnace policy deductibles 6,200 6,200 6,200 6,200 5130 Repairs, equipment 500 500 500 500 Misc. equipment repairs 500 500 500 500 7030 Equipment - 45,000 - - Boom/bucket truck (used) - 5,656 - - Stump grinder attachment for skid stear (bobcat) - 4,712 - - Tracks for skid stear (bobcat) - 6,000 - - Plow for pickup - 140,000 - - Dump Truck replaces #133 (1996 Ford L8000) - - - 5,200 Tack coat applicator system - 201,368 - 5,200 61,108 257,751 59,295 74,845 -40.68%150.20%-77.00%26.22% 39 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent 2013 Budget Summary Street Snow & Ice Control (100 - 4472): Personnel services: 0100 Salaries, regular 57,588 56,394 55,134 56,174 31,900 56,735 561 1.00% 0110 Salaries, overtime 8,204 10,316 5,609 5,524 3,038 5,579 55 1.00% 0300 Social Security 4,840 4,934 4,414 4,721 2,570 4,768 47 1.00% 0321 PERA 4,418 4,641 4,360 4,472 2,489 4,517 45 1.01% 0400 Group insurance 8,939 9,875 9,981 9,926 5,349 10,850 924 9.31% 0500 Workers compensation 3,662 4,322 3,729 4,196 2,781 4,318 122 2.91% Total personnel services 87,651 90,482 83,227 85,013 48,127 86,767 1,754 2.06% Materials & supplies: 1230 Supplies, equipment 3,849 2,042 3,329 2,500 338 3,250 750 30.00% 1600 Supplies, operating 19,873 27,954 21,836 27,050 9,050 27,050 - 0.00% 1700 Motor fuels & lubricants 7,244 3,102 (138) 4,680 2,859 4,680 - 0.00% 2400 Uniforms & clothing 491 306 713 855 484 855 - 0.00% 2410 Mats & towels - 281 961 940 755 940 - 0.00% Total materials & supplies 31,457 33,685 26,701 36,025 13,486 36,775 750 2.08% Contractual services: 3030 Other professional services 700 700 700 700 - 700 - 0.00% 3100 Telephone - - - 550 257 550 - 0.00% 3610 Memberships 331 354 149 190 - 190 - 0.00% 3630 Training & conferences 80 - 400 55 55 55 - 0.00% 5130 Repairs, equipment 706 1,232 1,227 1,000 214 1,000 - 0.00% Total contractual supplies 1,817 2,286 2,476 2,495 526 2,495 - 0.00% Capital outlays 7030 Equipment 949 - 1,048 - - - - 0.00% 7040 Vehicles - - - - - - - 0.00% Total capital outlays 949 - 1,048 - - - - 0.00% Total streets snow & ice control 121,874 126,453 113,452 123,533 62,139 126,037 2,504 2.03% 40 Fund: 100 Department: 4472 Snow & Ice Control Account Description 2010 2011 2012 2013 Description 1230 Supplies, equipment 250 250 250 250 Filters 450 450 450 450 Broom for Bobcat 450 - - 750 Skid steer snow bucket 1,400 1,400 1,800 1,800 Cutting edges, plow shoes 2,550 2,100 2,500 3,250 1600 Supplies, operating 800 800 800 800 Welding supplies, steel stock, sod for boulevards, etc. - 2,250 2,250 2,250 Liquid Mg Chloride: 1,500 gallons @ $1.50 per gallon. 32,000 24,000 24,000 24,000 Salt: 300 tons @ $80 per ton. 32,800 27,050 27,050 27,050 1700 Motor fuels & lubs 180 180 180 180 Engine oil: 30 gallons @ $6.00 per gallon. 7,500 7,500 4,500 4,500 Diesel fuel: 1,000 gallons @ $4.50 per gallon. 7,680 7,680 4,680 4,680 2400 Uniforms & clothing 1,200 1,200 660 660 Uniforms (11% of $6,000) - - 195 195 Clothes & boots allowance (1.1@$175) 1,200 1,200 855 855 2410 Mats & towels - - 940 940 Cost share of mats & towels (11% of $8,500) - - 940 940 3030 Other professional services 700 700 700 700 Weather service reports 700 700 700 700 3100 Telephone - - 550 550 Cellphone (6.5% of $8,500) - - 550 550 3610 Memberships 25 25 - - MN Street Superintendent's Assoc. 113 113 150 150 American Public Works Association memb. (APWA) (1/4 of $600) 65 65 40 40 Minnesota Safety Council 203 203 190 190 3630 Training 250 250 55 55 Hearing tests/RTN training (1.1@$50) 250 250 55 55 5130 Repairs, equipment 1,000 1,000 1,000 1,000 Plow, blower, salt spreader repairs, paint plow assemblies 1,000 1,000 1,000 1,000 7030 Capital, equipment - - - - Pavement temp sensor - - - - Brine solution equipment (moved to vehicle & equip fund) - - - - 46,383 40,183 38,520 39,270 -4.37%-13.37%-4.14%1.95% 41 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent 2013 Budget Summary Street Sign Maintenance (100 - 4475): Personnel services: 0100 Salaries, regular 20,797 20,266 20,200 20,427 11,739 20,631 204 1.00% 0110 Salaries, overtime 650 848 921 737 632 744 7 0.95% 0300 Social Security 1,599 1,581 1,582 1,619 930 1,635 16 0.99% 0321 PERA 1,441 1,472 1,525 1,534 879 1,550 16 1.04% 0400 Group insurance 3,024 3,502 3,533 3,610 1,473 3,946 336 9.31% 0500 Workers compensation 1,281 1,511 1,340 1,507 999 1,552 45 2.99% Total personnel services 28,792 29,180 29,101 29,434 16,652 30,058 624 2.12% Materials & supplies: 1600 Supplies, operating 3,929 1,424 482 4,735 1,908 6,000 1,265 26.72% 1700 Motor fuels & lubricants 559 - - - - - - 0.00% 2400 Uniforms & clothing - - 254 310 197 310 - 0.00% 2410 Mats & towels - - 336 340 274 340 - 0.00% Total materials & supplies 4,488 1,424 1,072 5,385 2,379 6,650 1,265 23.49% Contractual services: 3100 Telephone - - - 210 95 210 - 0.00% 3250 Electricity - traffic signals 1,797 1,767 1,950 2,000 952 2,000 - 0.00% 3630 Training & conferences - - 70 100 20 100 - 0.00% 5130 Repairs, equipment 244 - 115 500 - 500 - 0.00% Total contractual supplies 2,041 1,767 2,135 2,810 1,067 2,810 - 0.00% Capital outlays 7030 Equipment - - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total street sign maintenance 35,321 32,371 32,308 37,629 20,098 39,518 1,889 5.02% 42 Fund: 100 Department: 4475 Street Sign Maintenance 1600 Supplies, operating 2,990 2,990 2,990 5,000 Signs, posts, sign hardware, and supplies 515 515 515 500 Shop supplies - fastners, degreasers, etc 615 615 615 500 Graffitti remover 615 615 615 - City signage in County right of way 4,735 4,735 4,735 6,000 2400 Uniforms & clothing 480 480 240 240 Uniforms 0.4 FTE @ $1,200 - - 70 70 Clothes and boot allowance (.4@$175) 480 480 310 310 2410 Mats & towels - - 340 340 Cost share of mats & towels (4% of $8,500) - - 340 340 3100 Telephone - - 210 210 Cellphone (2.5% of $8,500) - - 210 210 3250 Electricity - traffic signals 2,000 2,000 2,000 2,000 Electricity for traffic signals 2,000 2,000 2,000 2,000 3630 Training & conferences 250 - - - Manual on Uniform Traffic Control Devices, workzone safety - - 80 80 Equipment operator training - - 20 20 Hearing test/RTN trainging (.4@$50) 250 - 100 100 5130 Repairs, equipment 750 750 500 500 Traffic signal repairs & maintenance 750 750 500 500 8,215 7,965 8,195 9,460 2.94%-3.04%2.89%15.44% 43 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Convention & Visitor's Bureau (100-4653) Contractual services 3045 N Metro Convention Bureau 40,171 48,452 50,840 48,450 19,796 50,350 1,900 3.92% Total contractual services 40,171 48,452 50,840 48,450 19,796 50,350 1,900 3.92% Total Convention & Visitor's Bureau 40,171 48,452 50,840 48,450 19,796 50,350 1,900 3.92% Miscellaneous (100 - 4700): Personnel services 0300 Social security 277 106 167 - 92 - - 0.00% 0321 PERA 428 365 216 - 131 - - 0.00% 0400 Group insurance 423 304 290 - 170 - - 0.00% 0750 Fitness program 5,135 3,169 2,601 6,500 1,550 6,500 - 0.00% Total personnel services 6,263 3,944 3,274 6,500 1,943 6,500 - 0.00% Contractual services 3065 Family & youth social services 18,926 18,661 18,661 19,221 19,221 19,548 327 1.70% Total contractual services 18,926 18,661 18,661 19,221 19,221 19,548 327 1.70% Miscellaneous 9100 Contingency - - - - - - - 0.00% 9900 Transfers - Vehicle & Equip. Fund 175,000 50,000 75,000 75,000 - 90,000 15,000 20.00% 9900 Community Center 160,000 170,000 170,000 170,000 - 170,000 - 0.00% Total miscellaneous 335,000 220,000 245,000 245,000 - 260,000 15,000 6.12% 0.00% Total miscellaneous 360,189 242,605 266,935 270,721 21,164 286,048 15,327 5.66% Debt Service (100 - 4750): Debt Service Fire Bonds: 8010 Principal 99,088 115,060 77,737 - - - - 0.00% 8020 Interest 50,195 32,135 9,104 - - - - 0.00% Debt Service Fire Equipment Certificates: 8010 Principal - - - - - - - 0.00% 8020 Interest - - - - - - - 0.00% Total debt service 149,283 147,195 86,841 - - - - 0.00% 2013 Budget Summary 44 Fund: 100 Department: 4653 Convention & Visitor's Bureau Account Description 2010 2011 2012 2013 Description 3045 N Metro Convention Bureau 48,450 42,750 48,450 50,350 Payment of 95% of hotel/motel tax collections to support the promotion of tourism. 48,450 42,750 48,450 50,350 Fund: 100 Department: 4700 Miscellaneous Account Description 2010 2011 2012 2013 Description 0750 Fitness program 6,500 6,500 6,500 6,500 Fitness program (maximum $55/month paid with employee sick leave time). 6,500 6,500 6,500 6,500 3065 Family & youth social services 18,926 18,926 19,221 19,548 Northwest Youth and Family Services 18,926 18,926 19,221 19,548 9100 Contingency 100,000 - - - Unexpected expenditures, deductibles, grant matches 100,000 - - - 9900 Transfers - miscellaneous 50,000 75,000 75,000 90,000 Transfer to Vehicle & Equipment Fund 50,000 75,000 75,000 90,000 9990 Community Center 175,000 170,000 170,000 170,000 Subsidy for Community Center operating costs 175,000 170,000 170,000 170,000 350,426 270,426 270,721 286,048 Fund: 100 Department: 4750 Fire Bond Debt Service Account Description 2010 2011 2012 2013 Description 8010 Principal 48,672 50,213 - - 14.77% of 2012 principal payment on 48,672 50,213 - - the 2005 Bond Issue 8020 Interest 41,084 39,449 - - 14.77% of 2012 interest payment on 41,084 39,449 - - the 2005 Bond Issue 8010 Principal 54,756 - - - 15.21% of 2010 principal payment on 54,756 - - - the 1997 Bond Issue 8020 Interest 2,683 - - - 15.21% of 2010 interest payment on 2,683 - - - the 1997 Bond Issue 8010 Principal 103,428 50,213 - - Total principal 8020 Interest 43,767 39,449 - - Total interest Total 147,195 89,662 - - 45 CITY OF MOUNDS VIEW, MINNESOTA Special Revenue Funds 2013 Budgets Combining Statement of Revenues and Expenditures and Net Changes in Fund Balances Economic Cable Development Community Television DARE Forfeiture Authority Center Revenues: Taxes 110,000 - - - - Intergovernmental: County grants - - - - - Other local govt.- - - - - Charges for services: Culture and recreation - - - - 194,804 Miscellaneous: Fines - 500 5,500 - - Investment income - - - - 2,500 Other 5,100 - - - - Total revenues 115,100 500 5,500 - 197,304 Expenditures: Public safety Supplies - 350 7,600 - - Contractual services - 150 1,500 - - Capital outlay - - - - - Sanitation Personal services - - - - - Contractual services - - - - - Culture and recreation: Personal services 81,114 - - - 53,321 Supplies 3,000 - - - 11,232 Contractual services 42,871 - - - 316,956 Capital outlay - - - - 4,000 Economic development Personal services - - - 109,931 - Supplies - - - 300 - Contractual services - - - 228,746 - Capital outlay - - - 50,000 - Total expenditures 126,985 500 9,100 388,977 385,509 Surplus of revenues over (under) expenditures (11,885) - (3,600) (388,977) (188,205) Other financing sources (uses) Transfers in - - - 388,840 170,000 Transfers out - - - - - Total other financing sources (uses)- - - 388,840 170,000 Net change in fund balance (11,885) - (3,600) (137) (18,205) Fund balance, January 1:263,893 2,823 26,665 53,663 178,799 Fund balance, December 31 252,008 2,823 23,065 53,526 160,594 46 Lakeside Recycling TIF TIF TIF TIF Park Grant District #1 District #2 District #3 District #5 2013 2012 - - 1,687,621 154,335 373,792 1,326,776 3,652,524 3,376,178 - 25,133 - - - - 25,133 26,185 21,216 - - - - - 21,216 21,216 - - - - - - 194,804 189,934 - - - - - - 6,000 6,300 300 - 6,000 2,500 10,000 5,000 26,300 166,800 250 - - - - - 5,350 150 21,766 25,133 1,693,621 156,835 383,792 1,331,776 3,931,327 3,786,763 - - - - - - 7,950 1,150 - - - - - - 1,650 1,650 - - - - - - - 40,000 - 12,165 - - - - 12,165 11,999 - 12,968 - - - - 12,968 14,186 3,730 - - - - - 138,165 140,865 2,100 - - - - - 16,332 17,250 15,936 - - - - - 375,763 358,305 - - - - - - 4,000 54,000 - - - - - - 109,931 100,460 - - - - - - 300 280 - - 34,000 2,000 2,000 1,263,437 1,530,183 1,930,817 - - 2,340,490 - - - 2,390,490 2,504,743 21,766 25,133 2,374,490 2,000 2,000 1,263,437 4,599,897 5,175,705 - - (680,869) 154,835 381,792 68,339 (668,570) (1,388,942) - - - - - - 558,840 742,435 - - (107,501) (107,500) (107,500) (66,339) (388,840) (1,632,529) - - (107,501) (107,500) (107,500) (66,339) 170,000 (890,094) - - (788,370) 47,335 274,292 2,000 (498,570) (2,279,036) 40,078 17,121 788,370 534,987 1,068,346 625,575 3,600,321 11,771,352 40,078 17,121 0 582,322 1,342,638 627,575 3,101,751 9,492,316 Total 47 2013 Budget Summary Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Cable TV (Fund 210): Revenues 3180 Franchise fee 141,282 114,631 116,767 100,000 59,360 110,000 10,000 10.00% 3370 Other local government rev - - - - - - - 0.00% 3610 Investment income - - - - - - - 0.00% 3680 Other revenue 6,530 5,144 5,100 5,100 2,550 5,100 - 0.00% Total revenue 147,812 119,775 121,867 105,100 61,910 115,100 10,000 9.51% Operating expenses Operations (4350) Personnel services 0100 Salaries, regular 54,766 58,199 60,079 61,564 34,209 61,346 (218) -0.35% 0110 Salaries, over-time 2,074 - - - - - - 0.00% 0150 Salaries, part-time 8,017 4,211 1,689 6,261 1,684 - (6,261) -100.00% 0300 Social security 4,895 4,680 4,439 5,188 2,688 4,693 (495) -9.54% 0321 PERA 4,341 4,324 4,452 4,463 2,603 4,447 (16) -0.36% 0400 Group insurance 7,004 7,905 7,981 9,475 5,212 10,357 882 9.31% 0500 Workers compensation 239 290 260 293 194 271 (22) -7.51% 0600 Unemployment 1,246 744 - - - - - 0.00% 0990 Severence pay - - - - - - - 0.00% Total personnel services 82,582 80,352 78,901 87,244 46,590 81,114 (6,130) -7.03% Materials & supplies 1230 Supplies, equipment 2,598 396 592 2,000 - 2,000 - 0.00% 1600 Supplies, operating 551 221 2 1,000 - 1,000 - 0.00% Total materials & supplies 3,149 617 594 3,000 - 3,000 - 0.00% Contractual services 3030 Other professional services 4,850 3,622 3,600 4,140 918 4,260 120 2.90% 3630 Training & conferences 325 370 - 300 - 300 - 0.00% 3800 Mileage & parking 20 23 23 75 8 75 - 0.00% 3900 Grants & subsidies 26,719 26,933 27,232 27,232 27,414 28,236 1,004 3.69% 5130 Repairs, equipment 51 139 - 10,000 - 10,000 - 0.00% Total contractual services 31,965 31,087 30,855 41,747 28,340 42,871 1,124 2.69% Capital 7030 Equipment 9,767 - - - - - - 0.00% Total capital outlays 9,767 - - - - - - 0.00% Total expenditures 127,463 112,056 110,350 131,991 74,930 126,985 (5,006) -3.79% Net change in fund balance 20,349 7,718 11,517 (26,891) (13,020) (11,885) 15,006 -55.80% Fund balance, beginning year 262,716 283,065 283,065 290,784 290,784 263,893 (26,891) -9.25% Fund balance, end of year 283,065$ 290,784$ 294,582$ 263,893$ 277,764$ 252,008$ (11,885)$ -4.50% 48 Fund: 210 Cable TV Revenues Account Description 2010 2011 2012 2013 Description 3180 Franchise fee revenue 96,000 96,000 100,000 110,000 Estimated collections 96,000 96,000 100,000 110,000 3680 Other revenue 5,100 5,100 5,100 5,100 Lease revenue from Library fiber connection 5,100 5,100 5,100 5,100 Fund: 210 Department: 4350 Operations 1230 Supplies, equipment 4,000 2,000 2,000 2,000 Equipment costing less than $1,000 per item 4,000 2,000 2,000 2,000 1600 Supplies, operating 1,000 750 750 750 Recording media - tapes, DVD's 500 250 250 250 Batteries, cables, bulbs, tapes, misc 1,500 1,000 1,000 1,000 3030 Other professional services 3,400 3,600 4,140 4,260 Web streaming meetings $355 per month. 3,400 3,600 4,140 4,260 3630 Training & conferences 700 300 300 300 Attendance at local training 600 - - - Submission fees for awards (new item for 2010) 1,300 300 300 300 3800 Mileage & parking 100 100 75 75 Mileage 100 100 75 75 3900 Grants & subsidies 27,254 26,933 27,232 28,236 Share of costs of North Suburban Cable Commission 27,254 26,933 27,232 28,236 5130 Repairs, equipment 1,500 1,000 10,000 10,000 Repair and maintenance of equipment 1,500 1,000 10,000 10,000 7030 Capital, equipment - - - - Podeum and other council chamber improvements - - - ?Supplemental duct work/air conditioning ($5,000 - $15,000) - - - ?Video Camera ($5,000 - $8,000) - - - ?Computer graphics - bulletin board (Tightrope Carousel CG310)($4,000) - - - ?Video storage network ($5,100) - - - ?Control room replacement ($100,000 - $200,000) - - - - Adobe Creative Suite 3 Production Premium Software - - - - 39,054 34,933 44,747 45,871 -4.24%-10.55%28.09%2.51% 49 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Actual Actual Actual Budget Actual Request Dollar Percent DARE (Fund 220): Revenues 3511 Fines - controlled substnc 759 538 884 500 560 500 - 0.00% 3680 Other revenue 450 - - - - - 0.00% Total revenue 1,209 538 884 500 560 500 - 0.00% Operating expenses (4200): Materials & supplies 1600 Supplies, operating 754 1,189 582 350 708 350 - 0.00% Total Supplies 754 1,189 582 350 708 350 - 0.00% Contractual services 3430 Printing - - - 100 100 - 0.00% 3610 Memberships - - - 50 50 - 0.00% 3630 Training & conferences - - - - - - 0.00% Total contractual services - - - 150 - 150 - 0.00% Transfers 9900 Transfers out 4,393 4,393 3,000 - - - 0.00% Total capital outlays 4,393 4,393 3,000 - - - - 0.00% Total expenditures 5,147 5,582 3,582 500 500 - 0.00% Net change in fund balance (3,938) (5,044) (2,698) - 560 - 3,092 #DIV/0! Fund balance, beginning year 14,503 10,565 5,520 2,823 2,823 2,823 - 0.00% Fund balance, end of year 10,565$ 5,520$ 2,823$ 2,823$ 3,383$ 2,823$ -$ 0.00% 2013 Budget Summary Change from 2012 50 Fund: 220 DARE Revenues Account Description 2010 2011 2012 2013 Description 3511 Fines - controlled substance 850 800 500 500 Estimated collections 850 800 500 500 3610 Interest revenue - - - - Estimated interest earnings (moved to general fund per council 08) - - - - Fund: 220 Department: 4200 Operations 1600 Supplies, operating 2,000 650 350 350 DARE apparel and supplies. 2,000 650 350 350 3430 Printing 100 100 100 100 Programs and parent guides. 100 100 100 100 3610 Memberships 100 50 50 50 NSRO, NDOA, & MNDARE. 100 50 50 50 3630 Training & conferences 800 - - - DARE or NSRO conference. 800 - - - 9900 Transfer out 4,393 3,000 - - Reimburse General Fund for 5% of DARE officer salary 4,393 3,000 - - 7,393 3,800 500 500 -6.33%-48.60%-86.84%0.00% 51 2013 Budget Summary Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Forfeiture (Fund 225): Revenues 3514 Forfeitures 15,744 14,831 14,467 5,500 15,567 5,500 - 0.00% 3680 Other revenue - 422 - - 1,317 - - 0.00% Total revenue 15,744 15,253 14,467 5,500 16,884 5,500 - 0.00% Operating expenses (4200): Materials & supplies 1230 Supplies, equipment - - - - - 7,100 7,100 #DIV/0! 1600 Supplies, operating 206 340 1,266 500 6,098 500 - 0.00% Total materials & supplies 206 340 1,266 500 6,098 7,600 7,100 1420.00% Contractual services 3030 Other professional services 5,880 4,545 2,874 1,500 362 1,500 - 0.00% Total contractual services 5,880 4,545 2,874 1,500 362 1,500 - 0.00% Capital 7030 Equipment - - 29,186 - - - - 0.00% 7040 Vehicles - - 4,694 - - - - 0.00% Total capital outlays - - 33,880 - - - - 0.00% Total expenses 6,086 4,885 38,020 2,000 6,460 9,100 7,100 355.00% Net change in fund balance 9,658 10,368 (23,553) 3,500 10,424 (3,600) (7,100) -202.86% Fund balance, beginning year 26,692 36,350 46,718 23,165 23,165 26,665 3,500 15.11% Fund balance, end of year 36,350 46,718 23,165 26,665 33,589 23,065 (3,600) -13.50% 52 Fund: 225 Forfeiture Revenues Account Description 2010 2011 2012 2013 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 1230 Supplies - equipment - - - 1,100 Taser 4,000 Body camera system 2,000 Radar - - - 7,100 1600 Supplies - operating 500 500 500 500 Supplies to prepare vehicles for auction. (tows, title fees, batteries) 500 500 500 500 3030 Other professional services 2,000 1,500 1,500 1,500 Share of auction costs. 2,000 1,500 1,500 1,500 7030 Equipment - - - - In-squad cameras - 29,000 - - One squad $23,000 + set-up $6000 One in General Fund. 9,500 - - - Speed display unit 9,500 29,000 - - 12,000 31,000 2,000 2,000 -49.84%158.33%-93.55%0.00% 53 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent EDA (Fund 230): Revenues 3610 Investment income - - 3 - - - - 0.00% 3615 Interest received on notes 99 - 0.00% 3680 Other revenue 2,760 2,815 5,743 - 5,858 - - 0.00% 3972 Transfers 129,824 127,649 168,091 389,437 - 388,840 (597) -0.15% Total revenue 132,584 130,464 173,936 389,437 5,858 388,840 (597) -0.15% Operating expenses Economic Development (4650): Personnel services 0100 Salaries, regular 77,240 78,820 76,297 84,276 46,593 85,112 836 0.99% 0300 Social security 5,808 5,946 5,763 6,448 3,481 6,511 63 0.98% 0321 PERA 5,098 5,500 5,470 6,110 3,372 6,171 61 1.00% 0400 Group insurance 9,039 9,734 9,455 10,702 6,409 11,673 971 9.07% 0500 Workers compensation 274 323 382 452 300 464 12 2.65% Total personnel services 97,459 100,324 97,367 107,988 60,155 109,931 1,943 1.80% Materials & supplies 1600 Supplies, operating - - - 100 - 100 - 0.00% 2100 Book & periodicals 110 - 175 200 229 200 - 0.00% Total materials & supplies 110 - 175 300 229 300 - 0.00% Contractual services 3030 Other professional services 28,645 21,775 18,325 68,998 21,620 66,310 (2,688) -3.90% 3420 Advertisements 717 273 365 1,000 939 1,000 - 0.00% 3430 Printing 556 885 156 1,000 868 1,000 - 0.00% 3610 Memberships 3,935 3,066 3,236 3,451 3,551 3,736 285 8.26% 3630 Training & conferences 1,262 616 694 2,000 855 2,000 - 0.00% 3800 Mileage - - 22 100 - 100 - 0.00% 4800 Insurance 3,912 3,526 3,494 4,600 2,216 4,600 - 0.00% 5210 Housing replacement - - 451 150,000 - 150,000 - 0.00% Total contractual services 39,027 30,140 26,744 231,149 30,049 228,746 (2,403) -1.04% Capital outlays 9300 Business subsidies - - - 50,000 - 50,000 - 0.00% Total capital outlays - - - 50,000 - 50,000 - 0.00% Total expenditures 136,596 130,464 124,285 389,437 90,433 388,977 (460) -0.12% Net change in fund balance (4,012) - 49,651 - (84,575) (137) (137) #DIV/0! Fund balance, beginning year 4,012 - 4,012 53,663 53,663 53,663 - 0.00% Fund balance, end of year - - 53,663 53,663 (30,912) 53,526 (137) -0.26% 2013 Budget Summary 54 Fund: 230 EDA Revenues Account Description 2010 2011 2012 2013 Description 3610 Interest income - - - - Estimated interest earnings at 1.25%. - - - - 3972 Transfers 385,189 387,435 389,437 Transfers from TIF 1,2,3,5 385,189 387,435 389,437 - Fund: 230 Department: 4650 Economic Development 1600 Supplies, operating 150 150 100 100 Misc office supplies 150 150 100 100 2100 Books & periodicals 100 - - - MN Real Estate Journal 30 30 30 30 LMC directory 100 100 170 230 Misc. reports & periodicals (Finance & Commerce) 230 130 200 260 3030 Other professional services 7,000 7,000 7,000 6,500 Legal fees for development reviews 12,000 12,000 12,000 11,000 Financial consultant fees (Ehlers) 30,000 30,000 25,000 24,000 Special project consultant fees 5,000 5,000 5,000 4,500 Appraisal and environmental fees 4,290 4,410 4,498 4,560 15% audit fee 12,500 12,500 12,500 12,750 Housing Resource Center fees 3,000 3,000 3,000 3,000 Marketing Consultant fees 73,790 73,910 68,998 66,310 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 300 300 300 300 Misc printing 1,000 1,000 1,000 1,000 3610 Memberships 400 400 400 400 Economic Development Assoc of MN (EDAM) 600 600 250 250 Twin Cities North Chamber of Commerce dues - - - 60 MN Assoc. of Govt. Communicators (MAGC) - - - 225 Urban Land Institute 2,801 2,875 2,801 2,801 North Metro Mayors Assoc (50% of dues, 50% in GF) 3,801 3,875 3,451 3,736 3630 Training & conferences 400 400 300 300 Chamber of Commerce meetings 650 650 650 650 DEED/ EDC training 360 360 300 300 EDAM monthly meetings 600 600 600 600 EDAM summer conference 200 200 150 150 Other miscellaneous training 2,210 2,210 2,000 2,000 3800 Mileage 100 100 100 100 Misc. mileage 4800 Insurance 4,600 4,600 4,600 4,600 Allocation of the City's property & liability insurance 4,600 4,600 4,600 4,600 5210 Housing programs 150,000 150,000 150,000 150,000 Housing Improvement programs 150,000 150,000 150,000 150,000 9300 Business loans/subsidies 50,000 50,000 50,000 50,000 Business improvement partnership loans/subsidies 50,000 50,000 50,000 50,000 286,881 286,975 281,449 279,106 1.72%0.03%-1.93%-0.83% 55 2013 Budget Summary Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (Fund 252): Building overhead (4350) Building overhead revenues 164,151 173,342 178,288 172,500 (463) 172,500 - 0.00% Building overhead expenditures 6,139 8,184 - - 13,237 - - 0.00% Net Building Overhead Operations 158,012 165,158 178,288 172,500 (13,700) 172,500 - 0.00% Banquet Center (4730): Banquet revenues 84,276 84,895 91,136 80,000 58,066 84,000 4,000 5.00% Banquet Center expenditures 106,399 106,370 128,685 151,699 63,161 113,307 (38,392) -25.31% Net Banquet Center (22,123) (21,474) (37,549) (71,699) (5,095) (29,307) 42,392 -59.13% YMCA (4732): YMCA revenues 33,741 33,162 48,118 30,450 18,721 33,425 2,975 9.77% YMCA expenditures 196,866 203,284 215,981 232,835 125,483 234,194 1,359 0.58% Net YMCA (163,125) (170,122) (167,863) (202,385) (106,762) (200,769) 1,616 -0.80% Chamber of Commerce (4734): Chamber revenues 12,148 4,049 - - - - - 0.00% Chamber expenditures 6,272 5,929 - - - - - 0.00% Net Chamber of Commerce 5,876 (1,879) - - - - - 0.00% Creative Kids Child Care Center (4736): Creative Kids revenues 75,474 76,047 77,379 77,379 46,608 77,379 - 0.00% Creative Kids expenditures 33,151 34,910 38,370 37,164 15,388 38,008 844 2.27% Net Creative Kids 42,323 41,137 39,009 40,215 31,220 39,371 (844) -2.10% Total revenue 369,790 371,496 394,922 360,329 122,932 367,304 6,975 1.94% Total expenditures 348,827 358,677 383,036 421,698 217,269 385,509 (36,189) -8.58% Net change in fund balance 20,963 12,819 11,886 (61,369) (94,337) (18,205) 43,164 -70.34% Fund balance, beginning year 194,500 215,463 228,283 240,168 240,168 178,799 (61,369) -25.55% Fund balance, end of year 215,463 228,283 240,168 178,799 145,831 160,594 (18,205) -10.18% (continued) 56 2013 Budget Summary YTD 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (continued): Building overhead (4350) Building revenues: 3610 Investment income 2,784 2,508 2,710 2,500 (684) 2,500 - 0.00% 3634 Equipment rental 56 - 18 - 8 - - 0.00% 3650 Donations - - 5,358 - - - - 0.00% 3680 Miscellaneous 1,311 834 202 - 213 - - 0.00% 3972 Transfers from Sp. Projects - - - - - - - 0.00% 3972 Transfers 160,000 170,000 170,000 170,000 170,000 - 0.00% 164,151 173,342 178,288 172,500 (463) 172,500 - 0.00% Operating expenses Personnel services 0100 Salaries, regular 35,522 35,327 35,867 35,420 19,689 35,785 365 1.03% 0110 Salaries,overtime 380 958 757 1,703 136 1,720 17 1.00% 0300 Social Security 2,307 2,355 2,377 2,840 1,424 2,870 30 1.06% 0321 PERA 2,393 2,511 2,622 2,691 1,441 2,719 28 1.04% 0400 Group insurance 7,416 7,762 7,774 8,256 4,789 8,640 384 4.65% 0500 Workers compensation 1,359 1,558 1,371 1,540 1,021 1,587 47 3.05% 999 Allocation of salaries (49,377) (49,664) (50,768) (52,450) (24,709) (53,321) (871) 1.66% Total personnel services - 805 - - 3,791 - - 0.00% Materials & supplies 1210 Supplies, buildings & grounds 1,234 910 1,647 1,100 1,088 1,100 - 0.00% 1230 Supplies, equipment 748 2,380 686 800 575 800 - 0.00% 1600 Supplies, operating 10,170 6,526 4,822 7,000 2,918 7,000 - 0.00% 2400 Uniforms 604 396 616 582 295 582 - 0.00% 2410 Mats & towels 1,276 1,219 712 2,800 515 1,750 (1,050) -37.50% 2999 Allocation of supplies (14,032) (11,345) (8,483) (12,282) (4,618) (11,232) 1,050 -8.55% Total materials & supplies - 86 - - 773 - - 0.00% Contractual services 3030 Other professional services 111 147 1,921 200 491 200 - 0.00% 3100 Telephone 3,372 3,631 3,374 3,600 1,557 3,600 - 0.00% 3200 Water & sewer 6,745 8,792 7,473 9,500 1,282 9,000 (500) -5.26% 3210 Electricity 51,585 55,718 60,978 56,000 25,065 62,000 6,000 10.71% 3220 Natural gas 13,126 12,047 12,181 17,000 5,612 14,000 (3,000) -17.65% 3530 Refuse collection 4,026 4,792 4,124 4,500 1,914 4,500 - 0.00% 3999 Allocation of utilities (72,826) (85,183) (89,281) (90,800) (29,585) (93,300) (2,500) 2.75% 5110 Repairs, building & grounds 11,832 11,599 25,564 17,330 7,585 17,330 - 0.00% 5130 Repairs, equipment 13,352 9,599 11,402 6,700 4,246 6,700 - 0.00% 5999 Allocation of repairs (25,184) (21,198) (37,736) (24,030) (11,228) (24,030) - 0.00% Total contractual services 6,139 (56) - - 6,939 - - 0.00% Capital 7030 Equipment - 7,350 - - 1,734 - - 0.00% Total capital outlays - 7,350 - - 1,734 - - 0.00% 6,139 8,184 - - 13,237 - - 0.00% Total Building Overhead Net 158,012 165,158 178,288 172,500 (13,700) 172,500 - 0.00% (continued) 57 Fund: 252 Department: 4350 Community Center Building Overhead Account Description 2010 2011 2012 2013 Description 1210 Supplies, bldgs & grounds 1,200 1,100 1,100 1,100 Lights, signs, fertilizer 1,200 1,100 1,100 1,100 1230 Supplies, equipment 400 400 800 800 Small tools & equipment 400 400 800 800 1600 Supplies, operating 5,800 7,000 7,000 7,000 Batteries, soap, paper towels, cleaning supplies for bathrooms Paper cups, plates, etc. for lounge & customer service events 5,800 7,000 7,000 7,000 2400 Uniforms 450 450 582 582 Uniforms/Clothing (7.5% of $6,000)(.75FTE * $175) 450 450 582 582 2410 Mats & towels 2,000 2,000 2,000 1,250 Floor mats and cleaning towelsto provide better protection of carpets 800 800 800 500 Special events 2,800 2,800 2,800 1,750 3030 Other professional services 200 200 200 200 Backflow inspection 200 200 200 200 3100 Telephone & internet 3,000 3,000 3,600 3,600 Office & customer phones, internet, maintenance agreements, & repairs 3,000 3,000 3,600 3,600 3200 Water & Wastewater 9,500 9,500 9,500 9,000 Water & sewer charges for community center 9,500 9,500 9,500 9,000 3210 Electricity 54,000 53,000 56,000 62,000 Estimated electrice charges 54,000 53,000 56,000 62,000 3220 Natural gas 25,500 23,000 17,000 14,000 Estimated natural gas charges 25,500 23,000 17,000 14,000 3530 Refuse collection 3,420 4,000 3,720 3,720 Dumpsters $310 x 12 months (10-$333) - - 680 680 Extra garbage pick-up charges 100 100 100 100 Ramsey County recyclying fee 3,520 4,100 4,500 4,500 5110 Repairs, building & grounds 5,760 5,760 5,760 5,760 Custodial services: 12 mths X $480 4,000 3,000 3,000 3,000 Commercial carpet cleaning service (twice annually) 6,180 5,180 4,500 4,500 Exterior building maintenance 750 750 770 770 Exterminator: 12 months X 64.02 2,000 1,500 1,500 1,500 Fire alarm system service 2,060 1,310 1,300 1,300 Parking lot & grounds maintenance 750 500 500 500 Security system service 21,500 18,000 17,330 17,330 5130 Repairs, equipment 5,000 5,000 5,000 5,000 HVAC system maintenance 200 200 200 200 Sprinkler inspections 1,500 1,500 1,500 1,500 Plumbing, electrical, & misc. interior maintenance 4,025 6,700 6,700 6,700 7030 Capital, equipment - - - - HVAC Improvements - 10,000 - - Community Center Roof repairs - 10,000 - - 131,895 139,250 127,112 128,562 -5.59%5.58%-8.72%1.14% 58 2013 Budget Summary Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (continued): Banquet Center (4730): Banquet Revenues 3644 Equipment rental 140 - - - - - - 0.00% 3645 Rental - banquet facility 84,136 84,895 91,136 80,000 58,066 84,000 4,000 5.00% 0.00% 84,276 84,895 91,136 80,000 58,066 84,000 4,000 5.00% Banquet Expenditures Personnel services 0999 Allocation of salaries 11,133 9,933 10,144 10,490 5,217 10,664 174 1.66% Total personnel services 11,133 9,933 10,144 10,490 5,217 10,664 174 1.66% Materials & supplies 1230 Supplies, equipment 320 - 4,220 - 544 - - 0.00% 2999 Allocation of supplies 3,980 3,298 2,484 3,439 1,293 3,145 (294) -8.55% Total materials & supplies 4,300 3,298 6,704 3,439 1,837 3,145 (294) -8.55% Contractual services 3030 Other professional services 58,014 56,697 62,096 55,256 43,244 56,783 1,527 2.76% 3100 Telephone 312 399 607 500 470 - (500) -100.00% 3420 Advertising - - 66 500 - 500 - 0.00% 3430 Printing - - - 250 - 250 - 0.00% 3999 Allocation of utilities 20,519 23,616 27,705 25,136 8,177 25,836 700 2.78% 4800 Bonding & insurance 1,786 1,610 1,595 2,100 1,012 2,100 - 0.00% 5110 Repairs, building & grounds 2,302 320 5,940 1,700 60 1,700 - 0.00% 5130 Repairs, equipment 981 274 1,215 1,600 - 1,600 - 0.00% 5999 Allocation of repairs 7,052 5,935 12,613 6,728 3,144 6,728 0 0.01% Total contractual services 90,966 88,852 111,837 93,770 56,107 95,497 1,727 1.84% Capital 7030 Equipment - 4,287 - 44,000 - 4,000 (40,000) -90.91% Total capital outlays - 4,287 - 44,000 - 4,000 (40,000) -90.91% 106,399 106,370 128,685 151,699 63,161 113,307 (38,392) -25.31% Total Banquet Center net (22,123) (21,474) (37,549) (71,699) (5,095) (29,307) 42,392 -59.13% (continued) 59 Fund: 252 Community Center - 4730 Banquet Center Expenses Account Description 2010 2011 2012 2013 Description 2999 Allocation of supplies 2,982 3,318 3,439 3,145 28% Allocation from overall building support 2,982 3,318 3,439 3,145 3030 Other professional services 715 735 745 760 2.5% of audit 2,600 2,600 2,600 2,600 Miscellaneous professional services (linen service) 45,333 46,240 50,411 51,923 Banquet facility management 1,500 1,500 1,500 1,500 Legal costs 50,148 51,075 55,256 56,783 3100 Telephone/Internet 450 600 500 - Internet service (1/2 reimbursed from other tenants) 450 600 500 - 3420 Advertising & marketing 1,000 750 500 500 Website and traditional advertising, marketing 1,000 750 500 500 3430 Printing 250 250 250 250 Brochures, flyers, etc. 250 250 250 250 3999 Allocation of utilities 26,562 25,744 25,136 25,836 28% Allocation from overall building utilities 26,562 25,744 25,136 25,836 4800 Bonding & insurance 2,100 2,100 2,100 2,100 Insurance & bonding cost 2,100 2,100 2,100 2,100 5110 Repairs, building & grounds 1,200 1,200 1,200 1,200 Interior building repairs specific to the banquette center 500 500 500 500 Dance floor maintenance 1,700 1,700 1,700 1,700 5130 Repairs, equipment 1,600 1,600 1,600 1,600 Repairs to kitchen, audio system, and other banquette equipment 1,600 1,600 1,600 1,600 5999 Allocation of repairs 7,826 6,916 6,728 6,728 28% Allocation from overall building repairs 7,826 6,916 6,728 6,728 7030 Capital, equipment 4,000 4,000 4,000 4,000 Table replacement program - 40,000 40,000 - Chairs for banquet center (400 @ $100) 4,000 44,000 44,000 4,000 98,618 138,053 141,209 102,642 -3.11%39.99%2.29%-27.31% 60 2013 Budget Summary YTD 2009 2010 2011 2012 07/31/12 2013 Actual Actual Actual Budget Actual Request Dollar Percent Community Center (continued): YMCA (4732): YMCA Revenues 3405 Recreation profit 14,939 14,976 24,767 12,000 14,000 2,000 16.67% 3660 Gym & meeting room rental 7,235 4,691 9,395 5,000 7,107 6,000 1,000 20.00% 3661 Open gym participant fees 10,991 13,036 13,693 13,000 11,602 13,000 - 0.00% 3679 Commissions - vending 576 459 263 450 12 425 (25) -5.56% 33,741 33,162 48,118 30,450 18,721 33,425 2,975 9.77% YMCA Expenditures Personnel services - 0999 Allocation of salaries 32,812 34,268 35,829 37,764 17,790 38,391 627 1.66% Total personnel services 32,812 34,268 35,829 37,764 17,790 38,391 627 1.66% Materials & supplies 1600 Supplies, operating - - - - 4,221 - - 0.00% 2999 Allocation of supplies 7,108 5,892 4,496 6,509 2,447 5,953 (556) -8.54% Total materials & supplies 7,108 5,892 4,496 6,509 6,668 5,953 (556) -8.54% Contractual services 3030 Other professional services 94,149 94,659 94,703 99,505 73,011 102,468 2,963 2.98% 3300 Postage 312 - - 1,200 - 1,200 - 0.00% 3430 Printing 4,794 4,620 5,142 6,000 2,829 6,000 - 0.00% 3999 Allocation of utilities 37,928 43,608 45,231 49,096 15,980 50,421 1,325 2.70% 4800 Bonding & insurance 2,977 2,683 3,057 4,025 1,939 4,025 - 0.00% 5110 Repairs, building & grounds 608 178 7,187 12,000 - 9,000 (3,000) -25.00% 5130 Repairs, equipment 3,586 6,777 2,382 4,000 1,315 4,000 - 0.00% 5999 Allocation of repairs 12,592 10,599 17,954 12,736 5,951 12,736 (0) 0.00% Total contractual services 156,946 163,124 175,656 188,562 101,025 189,850 1,288 0.68% 196,866 203,284 215,981 232,835 125,483 234,194 1,359 0.58% Total YMCA net (163,125) (170,122) (167,863) (202,385) (106,762) (200,769) 1,616 -0.80% (continued) Change from 2012 61 Fund: 252 Community Center - 4732 YMCA Account Description 2010 2011 2012 2013 Description 2999 Allocation of supplies 5,325 6,281 6,509 5,953 50% Allocation from overall building support 5,325 6,281 6,509 5,953 3030 Other professional services 95,400 97,300 97,270 100,188 YMCA management contract (other half of fee in parks) 2,145 2,205 2,235 2,280 7.5% of audit 97,545 99,505 99,505 102,468 3300 Postage 1,200 1,200 1,200 1,200 50% of the cost of mailing the Mounds View Matters newsletter 1,200 1,200 1,200 1,200 3430 Printing 6,000 6,000 6,000 6,000 50% of the cost of printing the Mounds View Matters newsletter 6,000 6,000 6,000 6,000 3999 Allocation of utilities 48,760 49,994 49,096 50,421 50% Allocation from overall building utilities 48,760 49,994 49,096 50,421 4010 Rental, equipment - - - - RecNet recreation programming and facility rental software - - - - 4800 Bonding & insurance 3,500 4,025 4,025 4,025 Insurance & bonding cost. 3,500 4,025 4,025 4,025 5110 Repairs, building & grounds 2,000 3,000 3,000 3,000 General building repairs - 7,000 7,000 4,000 Interior improvements 10,000 2,000 2,000 2,000 Gym floor resurfacing & maintenance 12,000 12,000 12,000 9,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,975 13,091 12,736 12,736 50% Allocation from overall building repairs 13,975 13,091 12,736 12,736 192,305 196,096 195,071 195,803 -1.41%1.97%-0.52%0.38% 62 2013 Budget Summary YTD 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Creative Kids Child Care (4736): Child Care Revenues 3632 Lease - Child Care 75,474 76,047 77,379 77,379 46,608 77,379 - 0.00% 75,474 76,047 77,379 77,379 46,608 77,379 - 0.00% Child Care Ed Expenditures Personnel services 0999 Allocation of salaries 3,950 3,973 4,080 4,196 1,977 4,266 70 1.66% Total personnel services 3,950 3,973 4,080 4,196 1,977 4,266 70 1.66% Materials & supplies 2999 Allocation of supplies 2,701 2,236 1,612 2,334 877 2,134 (200) -8.57% Total materials & supplies 2,701 2,236 1,612 2,334 877 2,134 (200) -8.57% Contractual services 3999 Allocation of utilities 13,637 15,713 16,344 16,568 5,428 17,043 475 2.87% 4750 Taxes, licenses, & fees 6,888 7,888 8,100 8,100 4,298 8,600 500 6.17% 4800 Bonding & insurance 1,191 1,073 1,063 1,400 675 1,400 - 0.00% 5999 Allocation of repairs 4,784 4,028 7,170 4,566 2,133 4,566 (0) -0.01% Total contractual services 26,500 28,702 32,678 30,634 12,534 31,609 975 3.18% Total Child Care expenditures 33,151 34,910 38,370 37,164 15,388 38,008 844 2.27% Total Child Care net 42,323 41,137 39,009 40,215 31,220 39,371 (844) -2.10% 63 2013 Budget Summary Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Lakeside Park (Fund 255): Revenues 3370 Spring Lake Pk contribution 10,608 10,608 10,608 10,608 10,608 - 0.00% 3370 Mounds View contribution 10,608 10,608 10,608 10,608 33,716 10,608 - 0.00% 3610 Investment income 478 186 362 300 (91) 300 - 0.00% 3680 Other revenue - - 25,209 - 0.00% 3678 Concession - - - - - - 0.00% 3665 Park site permit 217 801 201 250 397 250 - 0.00% Total revenue 21,911 22,204 46,989 21,766 34,022 21,766 - 0.00% Operating expenses (4350): Personnel services 0150 Salaries, part-time 3,360 3,780 3,360 3,349 3,320 3,360 11 0.33% 0300 Social security 257 289 257 256 254 257 1 0.39% 0500 Workers compensation 87 94 84 94 62 113 19 20.21% Total personnel services 3,704 4,164 3,701 3,699 3,636 3,730 31 0.84% Materials & supplies 1210 Supplies, bldgs & grounds 432 4,285 1,058 600 - 600 - 0.00% 1600 Supplies, operating 1,714 - 671 1,800 - 1,500 (300) -16.67% Total materials & supplies 2,146 4,285 1,730 2,400 - 2,100 (300) -12.50% Contractual services 3030 Other professional services - - - - - - - 0.00% 3100 Telephone/Internet - - - - - - - 0.00% 3200 Water & sewer 2,159 1,315 1,962 1,400 2 1,400 - 0.00% 3210 Electricity 700 919 1,421 1,500 575 1,400 (100) -6.67% 3530 Refuse collection 48 118 48 250 48 250 - 0.00% 4010 Equipment Contribution SLP 4,481 4,481 4,481 4,372 - 4,372 - 0.00% 4030 Satellites 507 389 260 500 251 500 - 0.00% 4800 Insurance 3,572 4,019 4,150 4,200 - 4,500 300 7.14% 5130 Repairs, equipment 3,316 - 324 3,445 - 3,514 69 2.00% Total contractual services 14,783 11,242 12,646 15,667 876 15,936 269 1.72% Capital 7030 Equipment - - - - 13,385 - - 0.00% 7050 Construction - - - - 33,878 - - 0.00% Total capital outlays - - - - 47,263 - - 0.00% Total expenses 20,633 19,690 18,077 21,766 51,775 21,766 - 0.00% Net change in fund balance 1,278 2,513 28,912 - (17,753) - - 0.00% Fund balance, beginning year 7,374 8,652 11,165 40,078 40,078 40,078 - 0.00% Fund balance, end of year 8,652 11,165 40,078 40,078 22,325 40,078 - 0.00% 64 Fund: 255 Lakeside Park Account Description 2010 2011 2012 2013 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 1.25%. 300 300 300 300 3680 Park sit rental 150 150 250 250 Rental of the park by groups or individuals 150 150 250 250 Fund: 255 Department: 4350 1210 Supplies, bldgs & grounds 600 600 600 600 Paper, sand, etc. 600 600 600 600 1600 Supplies, operating 1,800 1,800 1,800 1,500 Fertilizer & pesticides 1,800 1,800 1,800 1,500 3200 Water & sewer 1,400 1,400 1,400 1,400 Estimated water & sewer charges 1,400 1,400 1,400 1,400 3210 Electricity 600 700 1,500 1,400 Estimated electric charges 600 700 1,500 1,400 3530 Refuse collection 400 300 250 250 Six months service 400 300 250 250 4010 Equipment, capital charge 4,372 4,372 4,372 4,372 Capital charge for usage of SLP city equipment 4,372 4,372 4,372 4,372 4030 Satellites 500 550 500 500 Five months service 500 550 500 500 4800 Insurance & bonds 4,200 4,150 4,200 4,500 Property & liability insurnace 4,200 4,150 4,200 4,500 5130 Repairs, equipment 4,095 4,095 3,445 3,514 Repair of equipment at the park 4,095 4,095 3,445 3,514 17,967 17,967 18,067 18,036 0.00%0.00%0.56%0.38% 65 2013 Budget Summary Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Recycling (Fund 290): Revenues 3360 Other County grants 25,806 25,598 26,185 25,199 3,992 25,133 (66) -0.26% 3610 Investment income - - 220 - (55) - - 0.00% 3680 Other revenue 943 - - - - - - 0.00% Total revenue 26,749 25,598 26,405 25,199 3,937 25,133 (66) -0.26% Operating expenses Operations (4420) Personnel services 0100 Salaries, regular 5,523 8,570 8,728 8,345 4,630 8,428 83 0.99% 0300 Social security 388 553 564 638 301 645 7 1.10% 0321 PERA 342 600 632 605 336 611 6 0.99% 0400 Group insurance 1,420 2,259 2,303 2,312 1,348 2,419 107 4.63% 0500 Workers compensation 27 55 56 61 40 62 1 1.64% 0990 Severence pay - - - - 0.00% Total personnel services 7,700 12,037 12,283 11,961 6,655 12,165 204 1.71% Materials & supplies 1600 Supplies, operating 4,320 4,505 - - 779 - - 0.00% Contractual services 3030 Other professional services 150 1,800 824 - - - - 0.00% 3300 Postage 1,806 2,245 2,682 1,700 2,770 1,700 - 0.00% 3430 Printing 4,158 520 2,161 1,400 339 1,400 - 0.00% 3530 Refuse collection 4,486 5,291 12,982 10,138 1,926 9,868 (270) -2.66% Total contractual services 10,600 9,856 18,650 13,238 5,035 12,968 (270) -2.04% Capital 7030 Equipment - - - - - - - 0.00% Total capital outlays - - - - - - - 0.00% Total expenses 22,620 26,398 30,933 25,199 12,469 25,133 (66) -0.26% Net change in fund balance 4,129 (800) (4,528) - (8,532) - - 0.00% Fund balance, beginning year 18,320 22,449 21,649 17,121 17,121 17,121 - 0.00% Fund balance, end of year 22,449 21,649 17,121 17,121 8,589 17,121 - 0.00% 66 Fund: 290 Recycling Grant Revenues Account Description 2010 2011 2012 2013 Description 3360 Other grants & aid 26,545 26,185 25,199 25,133 Estimated Ramsey County recycling grant 26,545 26,185 25,199 25,133 Fund: 290 Department: 4420 Operations 1600 Supplies, operatin - - - - - - - - 3030 Other professional services - - - - - - - - 3300 Postage 1,200 1,200 1,700 1,700 City wide mailing for Cleanup Day 1,200 1,200 1,700 1,700 3420 Advertisements 1,545 1,545 - - Promotional items 1,545 1,545 - - 3430 Printing 501 501 600 600 Articles in City newsletter 800 800 800 800 Clean-up Day printing of direct mailing items 1,301 1,301 1,400 1,400 3530 Refuse collection 10,500 10,140 10,138 9,868 Contractual services for City Cleanup Day 10,500 10,140 10,138 9,868 14,546 14,186 13,238 12,968 -10.28%-2.47%-6.68%-2.04% 67 2013 Budget Summary Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 1 (Fund 410): Revenues 3101 Tax collections 1,493,611 1,632,309 1,946,350 1,687,621 880,759 1,687,621 - 0.00% 3101 Tax collections - Mermaid 156,520 - - - - 0.00% 3102 Taxes - delinquent (113) (316,204) (54,487) - 0.00% 3103 Market value credit 1,022 1,130 - 0.00% 3610 Investment income 41,887 6,183 22,568 10,000 (5,912) 6,000 (4,000) -40.00% 3972 Transfer from other funds - - 0.00% Total revenue 1,693,040 1,639,509 1,652,714 1,697,621 820,360 1,693,621 (4,000) -0.24% Operating expenses (4650): Contractual services 3030 Other professional 2,212 2,818 3,846 4,000 4,000 - 0.00% 4750 Property taxes (532) - 0.00% 5220 Highway 10 redevelopment 20,261 1,200 - 30,000 30,000 #DIV/0! 7050 Construction 3,664,138 653,111 2,169,844 1,504,027 1,205,285 2,340,490 836,463 55.61% 8010 Developer PAG, principal 279,438 - 0.00% 9900 Transfers out to EDA 24,634 24,660 35,893 109,675 - 107,501 (2,174) -1.98% 9900 Transfers out to other funds - - - - - 0.00% Total contractual services 3,711,245 961,226 2,209,583 1,617,702 1,204,753 2,481,991 864,289 53.43% Net change in fund balance ########678,283 (556,868) 79,919 (384,393) (788,370) (868,289) -1086.46% Fund balance, beginning year 2,605,242 587,037 1,265,320 708,451 708,451 788,370 79,919 11.28% Fund balance, end of year 587,037 1,265,320 708,451 788,370 324,058 0 (788,370) -100.00% 68 Fund: 410 TIF District #1 Revenues Account Description 2010 2011 2012 2013 Description 3101 Tax increment collections 1,213,988 1,434,611 1,687,621 1,687,621 Estimated collections of incremental taxes on properties in the district. 1,213,988 1,434,611 1,687,621 1,687,621 3101 Tax increment collections 178,838 - - - Estimated collections of incremental taxes on the Mermaid 178,838 - - - property which are dedicated to the 2001A TIF bonds. (bonds paid off) 3610 Interest income 10,000 14,000 10,000 6,000 Estimated interest earnings at 1.25%. 10,000 14,000 10,000 6,000 Fund: 410 Department: 4650 Economic Development 3030 Other professional services 1,000 2,000 4,000 4,000 TIF administration and reporting fees 1,000 2,000 4,000 4,000 5220 County Rd 10 redevelopment - - - - CR 10 trail segmentsj 9 - 10 - - 5,000 5,000 CR 10/Silver Lake Rd Intersection (design) 100,000 375,000 25,000 25,000 CR 10/CR H Intersection (preconstruction) 100,000 375,000 30,000 30,000 7050 Construction 365,000 - - - Area B & C Street project 300,000 1,829,287 - - Area D Street project (preconstruction) - - 1,474,027 - Area E Street project and preconstruction 1,899,179 Area F Street project - - - 441,311 Area G&H Street project (preconstruction) 665,000 1,829,287 1,474,027 2,340,490 9900 Transfer out to EDA Fund 109,398 107,138 109,675 107,501 Transfer to cover the EDA operating budget. 109,398 107,138 109,675 107,501 875,398 2,313,425 1,617,702 2,481,991 -75.78%164.27%-30.07%53.43% 69 2013 Budget Summary Y-T-D 2009 2010 2011 2012 07/31/12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 2 (Fund 420): Revenues 3101 Tax collections 143,266 152,505 150,264 154,335 70,389 154,335 - 0.00% 3102 Tax collections - delinquent 1,116 - 6,999 - - - 0.00% 3103 Market value credit 765 638 - - - - 0.00% 3610 Investment income 11,347 5,523 8,279 2,500 (2,081) 2,500 - 0.00% 3680 Other revenue - - - - - - 0.00% 3972 Transfer from other funds - - - - - - 0.00% Total revenue 156,494 158,666 165,542 156,835 68,308 156,835 - 0.00% Operating expenses (4650): Contractual services 3030 Other professional 1,240 1,559 2,460 2,000 2,000 - 0.00% 4750 Taxes, Licenses, & Fees - - - - - - - 0.00% 7050 Construction 165,734 - - - - - - 0.00% 8010 Developer PAG, principal 37,358 42,602 42,495 38,238 19,119 - (38,238) -100.00% 9900 Transfers out to debt service/EDA 24,634 24,660 35,893 109,674 - 107,500 (2,174) -1.98% Total contractual services 228,966 68,821 80,848 149,912 19,119 109,500 (40,412) -26.96% Net change in fund balance (72,472) 89,845 84,694 6,923 49,189 47,335 40,412 583.74% Fund balance, beginning year 425,998 353,526 443,371 528,064 528,064 534,987 6,923 1.31% Fund balance, end of year 353,526 443,371 528,064 534,987 577,253 582,322 47,335 8.85% 70 Fund: 420 TIF District #2 Revenues Account Description 2010 2011 2012 2013 Description 3101 Tax increment collections 151,698 154,335 154,335 154,335 Estimated collections of incremental taxes on properties 151,698 154,335 154,335 154,335 in the district. 3610 Investment income 2,500 2,500 2,500 2,500 Estimated interest earnings at 1.25%. 2,500 2,500 2,500 2,500 Fund: 420 Department: 4650 Economic Development 3030 Other professional services 1,200 1,200 2,000 2,000 TIF administration and reporting fees 1,200 1,200 2,000 2,000 7050 Construction - - - - 2009/2010 Street project - - - - 8010 Pay-as-you-go principal 38,452 46,753 38,238 - Principal on a revenue note issued to promote a development. 38,452 46,753 38,238 - (Silver Lake Point Project - Heartland MV Common Bond, LLC.) 9900 Transfer out to EDA Fund 109,397 107,138 109,674 107,500 Transfer to cover the EDA operating budget. 109,397 107,138 109,674 107,500 149,049 155,091 149,912 109,500 -67.83%4.05%-3.34%-26.96% 71 2013 Budget Summary Y-T-D 2009 2010 2011 2012 07/31/12 2013 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 3 (Fund 430): Revenues 3101 Tax collections 351,862 475,317 349,928 349,928 186,896 373,792 23,864 6.82% 3102 Tax collections - delinquent - 69,085 - - - - 0.00% 3610 Investment income 21,013 7,701 19,943 10,000 (4,978) 10,000 - 0.00% 3972 Transfer from other funds - - - - - - 0.00% Total revenue 372,875 552,103 369,871 359,928 181,918 383,792 23,864 6.63% Operating expenses (4650): Contractual services 3030 Other professional 987 920 4,719 2,000 2,000 - 0.00% 5220 Highway 10 redevelopment 723,906 66,208 8,419 - 24,800 - - 0.00% 7050 Construction - - - 425,973 9,751 - (425,973) -100.00% 8010 Developer PAG, principal - - - - - - 0.00% 8020 Developer PAG, interest - - - - - - 0.00% 9900 Transfers out to other funds - - - - - - 0.00% 9900 Transfers out to EDA 24,634 24,660 35,893 109,675 - 107,500 (2,175) -1.98% Total contractual services 749,527 91,788 49,031 537,648 34,551 109,500 (428,148) -79.63% Net change in fund balance (376,652) 460,315 320,840 (177,720) 147,367 274,292 452,012 -254.34% Fund balance, beginning year 841,563 464,911 925,226 1,246,066 1,246,066 1,068,346 (177,720) -14.26% Fund balance, end of year 464,911 925,226 1,246,066 1,068,346 1,393,433 1,342,638 274,292 25.67% Change from 2012 72 Fund: 430 TIF District #3 Revenues Account Description 2010 2011 2012 2013 Description 3101 Tax increment collections 328,408 370,824 349,928 373,792 Estimated collections of incremental taxes on properties 328,408 370,824 349,928 373,792 in the district. 3610 Investment income 12,500 10,000 10,000 10,000 Estimated interest earnings at 1.25%. 12,500 10,000 10,000 10,000 Fund: 430 Department: 4650 Economic Development 3030 Other professional services 1,200 1,200 2,000 2,000 TIF administration and reporting fees 1,200 1,200 2,000 2,000 7050 Construction - 625,456 - - Area E Street project (preconstruction) - - 425,973 - Area E Street project (construction) - 625,456 425,973 - (prepare plans and specs in 2008) 9900 Transfer out to EDA Fund 109,397 107,138 109,675 107,500 Transfer to cover the EDA operating budget. 109,397 107,138 109,675 107,500 110,597 733,794 537,648 109,500 73 Y-T-D 2009 2010 2011 2012 07/31/12 2013 Actual Actual Actual Budget Actual Request Dollar Percent TIF # 5 (Fund 450): Revenues 3101 Tax collections 1,565,044 1,287,696 1,208,260 1,208,260 663,388 1,326,776 118,516 9.81% 3610 Investment income 4,161 5,286 6,818 6,000 (1,712) 5,000 (1,000) -16.67% Total revenue 1,569,205 1,292,982 1,215,078 1,214,260 661,676 1,331,776 117,516 9.68% Operating expenses (4650): Contractual services 3030 Other professional 1,109 1,517 2,839 2,600 3,000 400 15.38% 8010 Developer PAG, principal 1,062,514 170,896 - 1,147,847 573,924 1,260,437 112,590 9.81% 8020 Developer PAG, interest - 911,635 1,458,101 - - - 0.00% 9900 Transfers out to EDA 55,922 53,670 60,413 60,413 - 66,339 5,926 9.81% Total contractual services 1,119,545 1,137,717 1,521,354 1,210,860 573,924 1,329,776 118,916 9.82% Net change in fund balance 449,660 155,265 (306,276) 3,400 87,752 2,000 (1,400) -41.18% Fund balance, beginning year 323,526 773,186 928,451 622,175 622,175 625,575 3,400 0.55% . Fund balance, end of year 773,186 928,451 622,175 625,575 709,927 627,575 2,000 0.32% 2013 Budget Summary Change from 2012 74 Fund: 450 TIF District #5 Revenues Account Description 2010 2011 2012 2013 Description 3101 Tax increment collections 1,139,960 1,320,408 1,208,260 1,326,776 Estimated collections of incremental taxes on properties 1,139,960 1,320,408 1,208,260 1,326,776 in the district. 3610 Investment income 6,300 9,000 6,000 5,000 Estimated interest earnings at 1.25%. 6,300 9,000 6,000 5,000 Fund: 430 Department: 4650 Economic Development 3030 Other professional services 1,200 1,400 2,600 3,000 TIF administration and reporting fees 1,200 1,400 2,600 3,000 8010 Pay-as-you-go principal 1,082,963 1,266,569 1,147,847 1,260,437 Principal on a revenue note issued to promote a development. (Medtronic) 1,082,963 1,266,569 1,147,847 1,260,437 9900 Transfer out to EDA Fund 56,997 66,020 60,413 66,339 Transfer to cover the EDA operating budget. 56,997 66,020 60,413 66,339 75 2009 2010 2011 2012 Y-T-D 2013 Change from 2012 Actual Actual Actual Budget 07/31/12 Request Dollar Percent GO Improvement Bonds of 2004A Debt Service (Fund 505): Revenues 3101 Property taxes 186,427 178,567 187,736 190,892 98,292 190,800 (92) -0.05% 3550 Spec assess prepayments - - - - - - 0.00% 3551 Spec assess current 38,326 36,916 35,435 25,652 17,048 32,556 6,904 26.91% 3552 Spec assess delinquent 1,041 - 518 - - - 0.00% 3553 Spec assess penalty & int 282 - 154 - - - 0.00% 3610 Investment income 6,822 3,433 4,020 3,000 (1,017) 2,500 (500) -16.67% Total revenue 232,898 218,917 227,863 219,544 114,323 225,856 6,312 2.88% Operating expenses (4650): Contractual services 8010 Debt, principal 215,000 220,000 225,000 230,000 230,000 235,000 5,000 2.17% 8020 Debt, interest 51,058 44,423 37,300 29,563 16,794 21,308 (8,255) -27.92% 8030 Paying agent 431 431 431 475 431 475 - 0.00% 8040 Continuing disclosure 1,138 1,164 2,181 1,500 - 1,500 - 0.00% Total contractual services 267,627 266,018 264,912 261,538 247,225 258,283 (3,255) -1.24% Net change in fund balance (34,729) (47,101) (37,049) (41,994) (132,902) (32,427) 9,567 -22.78% Fund balance, beginning year 459,818 425,089 377,988 340,939 340,939 298,945 (41,994) -12.32% Fund balance, end of year 425,089 377,988 340,939 298,945 208,037 266,518 (32,427) -10.85% 2013 Budget Summary 76 CITY OF MOUNDS VIEW, MINNESOTA Capital Project Funds 2013 Budgets Combining Statement of Revenues and Expenditures Park Vehicle and Special Street Dedication Equipment Projects Improvement 2013 2012 Revenue: Taxes -$ -$ -$ 300,000$ 300,000$ 300,000$ Franchise fees - - - 253,000 253,000 253,000 Special assessments - - - 20,000 20,000 20,000 Intergovernmental: State - - - 383,000 383,000 578,000 Federal - - - - - - Miscellaneous: Investment income 10,000 - 6,500 80,000 96,500 92,500 Donations - - - - - - Other 6,000 - - - 6,000 6,000 Total revenue 16,000 - 6,500 1,036,000 1,058,500 1,249,500 Expenditures: General government - 90,000 221,000 - 311,000 581,300 Public safety - 163,000 - 163,000 110,000 Streets and highways - 585,460 585,460 1,078,280 Culture and recreation 183,500 - - 183,500 235,500 Total expenditures 183,500 253,000 221,000 585,460 1,242,960 2,005,080 Excess (deficiency) of revenue over expenditures (167,500) (253,000) (214,500) 450,540 (184,460) (755,580) Other financing sources (uses) Operating transfers Bonds issued - - - - - - Transfers in - 200,000 - 300,000 500,000 485,000 Transfers out - (23,736) (45,000) - (68,736) (390,340) Total other financing sources (uses)- 176,264 (45,000) 300,000 431,264 94,660 Net change in fund balance (167,500) (76,736) (259,500) 750,540 246,804 (660,920) Fund balance, January 1 459,790 1,641,930 493,073 7,588,795 10,183,587 10,844,506 Fund balance, December 31 292,290$ 1,565,194$ 233,573$ 8,339,335$ 10,430,391$ 10,183,586$ Total Budget 77 2013 Budget Summary Y-T-D 2009 2010 2011 2012 09-30-12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Park Dedication (Fund 451): Revenues 3610 Investment income 20,320 13,353 17,530 10,000 (4,415) 10,000 - 0.00% 3650 Park donations 2,664 39,969 4,500 3,000 - 0.00% 3652 Park dedication fees 1,800 - - 6,000 6,000 - 0.00% Total revenue 24,784 53,322 22,030 16,000 (1,415) 16,000 - 0.00% Operating expenses Operations (4470): Materials & supplies 1600 Supplies, operating - - - - - - - 0.00% Total materials & supplies - - - - - - - 0.00% Contractual services 3030 Other professional services - 615 - - - - - 0.00% Total contractual services - 615 - - - - - 0.00% Capital 7050 Construction 5,986 46,811 258,302 235,500 130,346 183,500 (52,000) -22.08% Total capital outlays 5,986 46,811 258,302 235,500 130,346 183,500 (52,000) -22.08% Total expenses 5,986 47,426 258,302 235,500 130,346 183,500 (52,000) -22.08% Net change in fund balance 18,798 5,896 (236,272) (219,500) (131,761) (167,500) 52,000 -23.69% Fund balance, beginning year 890,868 909,666 915,562 679,290 679,290 459,790 (219,500) -32.31% Fund balance, end of year 909,666$ 915,562$ 679,290$ 459,790$ 547,529$ 292,290$ (167,500)$ -36.43% 78 Fund: 451 Park Dedication Fund Revenues Account Description 2010 2011 2012 2013 Description 3610 Investment income 20,000 15,000 10,000 10,000 Estimated interest earnings at 1.25%. 20,000 15,000 10,000 10,000 3652 Park dedication fees 6,000 6,000 6,000 6,000 Developer payments 6,000 6,000 6,000 6,000 Fund: 451 Department: 4470 Expenditures 7050 Construction 15,000 - - - Lambert Park building (preconstruction)(50% in Spec. Projects Fund) - 260,000 35,000 - Lambert Park building (construction) - 40,000 40,000 - Relocate Lambert ballfield to accomodate reconfig. bld. site. (Carryover) - 10,000 10,000 - Hillview hockey rink expansion and grading (Carryover) - - 4,500 - Reconstruct irrigation controls at Silverview Park - - 100,000 - Replace playground equipment - Lambert 100,000 Replace playground equipment - Silverview Park - - 13,000 - PIP - Security lighting Imp. - Greenfield & Groveland Parks - - 8,000 - PIP - Replace playground media - City Hall Park 25,000 - - - Groveland & Hillview drainage and irrigation improvements - - - 8,500 Hillview Park building roof 25,000 - 25,000 25,000 Park Improvement Program (PIP) - - - 50,000 Greenfield Park Parking area (with area F street reconstruction) 65,000 310,000 235,500 183,500 79 2013 Budget Summary Y-T-D 2009 2010 2011 2012 09-30-12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Vehicle & Equipment (Fund 460): Revenues 3610 Investment income - - - - - - 0.00% 3972 Transfers in - General fund 175,000 50,000 75,000 75,000 90,000 15,000 20.00% 3972 Transfers in - Water Fund 20,000 20,000 58,000 58,000 58,000 - 0.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 16,000 16,000 16,000 16,000 - 0.00% Total revenue 237,000 122,000 185,000 185,000 - 200,000 15,000 8.11% Operating expenses Operations (4160): Capital 7010 Buildings - - - - - - - 0.00% 7030 Equipment - - - 59,300 56,991 90,000 90,000 151.77% 7040 Vehicles - - - 110,000 - 163,000 163,000 148.18% 7050 Construction - - - - - - - 0.00% Total capital outlays - - - 169,300 56,991 253,000 253,000 299.95% Other 9900 Transfer out - General Fund 44,000 13,319 175,142 11,340 23,736 12,396 109.31% 9900 Transfer out - Water Fund - - - 289,000 (289,000) -100.00% 9900 Transfer out - Sewer Fund - - 300,000 - 0.00% 9900 Transfer out - Storm Water Fund - - 40,000 - 0.00% Total other 44,000 13,319 515,142 300,340 - 23,736 (276,604) -92.10% Total expenses 44,000 13,319 515,142 469,640 56,991 276,736 (23,604) -5.03% Net change in fund balance 193,000 108,681 (330,142) (284,640) (56,991) (76,736) 207,904 -73.04% Fund balance, beginning year 1,955,031 2,148,031 2,256,712 1,926,570 1,926,570 1,641,930 (284,640) -14.77% Fund balance, end of year 2,148,031 2,256,712 1,926,570 1,641,930 1,869,579 1,565,194 (76,736) -4.67% 80 Fund: 460 Vehicle & Equipment Fund Revenues Account Description 2010 2011 2012 2013 Description 3961 Transfers in 50,000 75,000 75,000 90,000 From General Fund 20,000 58,000 58,000 58,000 From Water Fund 36,000 36,000 36,000 36,000 From Sanitary Sewer Fund 16,000 16,000 16,000 16,000 From Storm Water Fund 122,000 185,000 185,000 200,000 Fund: 460 Department: 4160 Central Services Operations 7030 Equipment - - 18,000 - 11 computers, software and network hardware reduce from $23,000. - - 18,000 - Fund: 460 Department: 4200 Police Operations 7030 Equipment - - 7,000 - Squad mobile computers (2), light bar, (Police) - - 4,800 - radar $2,800, light bar $2,000 (Police) - - 11,800 - 7040 Vehicles - - 29,000 87,000 3 vehicles $23,000 eacy and set-up $6,000 each (Police) - - 29,000 87,000 Fund: 460 Department: 4360 Parks Operations 7030 Equipment - - - 90,000 Parks mower (AEBI Terratrac TT705) 7,500 - Air compressor (1/2 parks 1/2 pavement mgt.) - - 6,000 Plow for pick-up (Parks)(Carryover from General Fund) - - 13,500 90,000 7040 Vehicles - - 36,000 36,000 1 F250 Pick-up (Parks) - - 36,000 36,000 Fund: 460 Department: 4460 Building & Grounds Operations 7030 Equipment - - 4,000 - Replace City Hall entrance lights (Bldg & grnds) - - 4,000 - Fund: 460 Department: 4470 Pavement Management Operations 7030 Equipment - - 4,000 - Brine solution equipment (Snow & Ice removal) - - 7,500 - Air compressor (1/2 parks 1/2 pavement mgt.) - - 11,500 - 7040 Vehicles - - 45,000 - Boom truck (Streets - pvmt mgt)(Carryover) - - - 40,000 Street maint. 1 ton pick-up - - 45,000 40,000 9900 Transfers out 25,000 23,000 - 18,000 11 computers, software and network hardware reduce from $25,000. 40,600 30,200 - - 1 vehicle $29,000, radar $1,200, light bar $2,000, digital equip. $3,000 - 22,894 11,340 5,736 Fire equipment per SBM - 66,000 - - Parks Pick-up $36,000, wood chipper $24,000, pick-up plow $6,000 - 140,000 - - PW plow truck - 45,000 - - PW boom truck - 6,000 - - Plow for pick-up - 289,000 289,000 - Water Tower major maintenance (Carryover) 330,000 300,000 - - Sewer - Vactor 40,000 40,000 - - Storm Water - truck (carryover from 2007) 435,600 962,094 300,340 23,736 81 2013 Budget Summary Y-T-D 2009 2010 2011 2012 09-30-12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Special Projects (Fund 480): Revenues 3551 Spec assessmt current - - - - 0.00% 3552 Spec assessmt delinquent 73 48 - - 0.00% 3553 Spec assessmt penalty & interest 12 18 - - 0.00% 3610 Investment income 28,276 19,322 24,547 10,000 (6,188) 6,500 (3,500) -35.00% 3680 Other revenue - - - - 0.00% 3972 Transfers in - - - - 0.00% Total revenue 28,361 19,388 24,547 10,000 (6,188) 6,500 (3,500) -35.00% Operating expenses Operations (4180): Contractual services 3030 Other professional services 1,116 11,475 29,405 10,000 5,690 - (10,000) -100.00% 5130 Repairs; Equipment - - - - 167 - - 0.00% Total contractual services 1,116 11,475 29,405 10,000 5,857 - (10,000) -100.00% Capital 7030 Capital equipment 84,949 - 50,673 - 155 88,000 88,000 #DIV/0! 7050 Construction 6,977 18,830 167,749 512,000 217,134 133,000 (379,000) -74.02% Total capital outlays 91,926 18,830 218,422 512,000 217,289 221,000 (291,000) -56.84% Other 9900 Transfer out - - - 90,000 45,000 (45,000) -50.00% Total other - - - 90,000 - 45,000 (45,000) -50.00% Total expenses 93,042 30,306 247,827 612,000 223,146 266,000 (346,000) -56.54% Net change in fund balance (64,681) (10,917) (223,280) (602,000) (229,334) (259,500) 342,500 -56.89% Fund balance, beginning year 1,393,951 1,329,270 1,318,352 1,095,073 1,095,073 493,073 (602,000) -54.97% Fund balance, end of year 1,329,270 1,318,352 1,095,073 493,073 865,739 233,573 (259,500) -52.63% 82 Fund: 480 Special Projects Revenues Account Description 2010 2011 2012 2013 Description 3610 Investment income 30,000 17,000 10,000 10,000 Estimated interest earnings at 1.25%. 30,000 17,000 10,000 10,000 Fund: 480 Department: 4180 Expenditures 3030 Other professional services - - - - - 10,000 10,000 - Scanning of microfilm to laserfiche - 10,000 10,000 - 7030 Capital, equipment - - - 28,000 Purchase/lease copiers (4) lease expires in July 2013 25,000 25,000 - - Community center furniture replacement - - - 10,000 Council Chambers chairs/tables (50 chairs @ $100, 10 tables @ $500) - - - 10,000 Video Security improvments for CH and CC (BBC grant of $2,000) - - - 40,000 City Hall sign - 65,000 - - Alternative Power Supply Project (City Hall generator for EOC) 25,000 90,000 - 88,000 7050 Construction 30,000 - 30,000 - Community center parking lot improvements 15,000 - - - Lambert Park building (preconstruction)(50% in Park Dedication) - 13,000 13,000 13,000 City Hall irigation project (postponed from 08)(Carryover) - 30,000 30,000 - Edgewood Dr. boulevard project (carryover from 2007)(Carryover) 104,000 104,000 104,000 100,000 Pathway construction program 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 - - - PW shop intermediate rehabilitation (carryover from 09) 40,000 20,000 20,000 20,000 Pathway rehabilitation program - - 250,000 - Community Center roof replacement/repair - 175,000 - - City Hall roof replacement/repair 424,000 342,000 512,000 133,000 9900 Transfer to General Fund 90,000 90,000 90,000 45,000 90,000 90,000 90,000 45,000 83 2013 Budget Summary Y-T-D 2009 2010 2011 2012 09-30-12 2013 Change from 2012 Actual Actual Actual Budget Actual Request Dollar Percent Street Improvement (Fund 485): Revenues 3101 Property taxes - 279,586 264,313 300,000 141,814 300,000 - 0.00% 3180 Franchise fee 235,002 225,581 241,289 253,000 97,716 253,000 - 0.00% 3319 Other federal grants 463,438 40,761 - - 16,306 - 0.00% 3352 MSA street construction 1,157,743 425,115 325,787 383,000 315,426 383,000 - 0.00% 3359 Other state grants - - - 195,000 (195,000) -100.00% 3360 Other county grant 216,973 - - - - 0.00% 3550 Spec assessmt prepayment 209,822 20,127 24,445 20,000 19,725 20,000 - 0.00% 3610 Investment income 106,092 82,329 125,713 72,500 (31,522) 80,000 7,500 10.34% 3680 Other revenue 42,369 25,377 45,090 - 7,848 - - 0.00% 3972 Transfer from other funds 280,000 300,000 300,000 300,000 300,000 - 0.00% Total revenue 2,711,439 1,398,876 1,326,636 1,523,500 567,313 1,336,000 (187,500) -12.31% Operating expenses Operations (4470): Contractual services 3030 Other professional services 99,508 259 - - - - 0.00% 3810 Special assessment refunds 3,818 - - - - - 0.00% Total contractual services 103,326 259 - - - - - 0.00% Capital 7050 Construction 572,522 160,424 143,212 1,078,280 182,256 585,460 (492,820) -45.70% Total capital outlays 572,522 160,424 143,212 1,078,280 182,256 585,460 (492,820) -45.70% Total expenses 675,848 160,683 143,212 1,078,280 182,256 585,460 (492,820) -45.70% Net change in fund balance 2,035,591 1,238,193 1,183,425 445,220 385,057 750,540 305,320 68.58% Fund balance, beginning year 2,686,366 4,721,957 5,960,151 7,143,575 7,143,575 7,588,795 445,220 6.23% Fund balance, end of year 4,721,957$ 5,960,151$ 7,143,575$ 7,588,795$ 7,528,632$ 8,339,335$ 750,540$ 9.89% 84 Fund: 485 Street Improvement Revenues Account Description 2010 2011 2012 2013 Description 3101 Property taxes 300,000 300,000 300,000 300,000 General tax levy for streets 300,000 300,000 300,000 300,000 3180 Franchise fee 287,000 249,900 253,000 253,000 Half of the 4% franchase fee on gas & electric utilities 287,000 249,900 253,000 253,000 3319 Other federal grants - - - - Federal trails grant - 630,000 630,000 - Federal safety grant for Cty H intersection(2013) - 630,000 630,000 - 3352 MSA Street Construction 365,000 383,000 383,000 383,000 State aid funds 365,000 383,000 383,000 383,000 3359 Other state grants - 300,000 300,000 - MNDOT Coop Agreement (2011 H and Cty 10 intersection project) - 70,000 70,000 - Ramsey Cty CSAH (2010 H and Cty 10 intersection project) - 125,000 125,000 - CR 10 Turnback Funds (2010 H and Cty 10 intersection project) - 495,000 495,000 - 3610 Investment income 72,500 100,000 72,500 80,000 Estimated interest earnings at 1.25%. 72,500 100,000 72,500 80,000 3972 Transfer in 300,000 300,000 300,000 300,000 Transfers from utility funds (water 100,000, sewer 160,000, storm 40,000) 300,000 300,000 300,000 300,000 Fund: 485 Department: 4470 Expenditures 3030 Other professional services - - - - - - - - 7050 Construction 547,000 - - - 2010 Area B&C Street & Utility project - 417,000 - - 2012 Area E Street & Utility project - - 778,280 - 2013 Area F Street & Utility project - - - 495,460 2014 Area G&H Street & Utility project - 350,000 300,000 - Mill and overlay (Mustang Drive)(move to 2014)(50,000 in utility funds) - - - 90,000 Seal coat project 547,000 767,000 1,078,280 585,460 85 CITY OF MOUNDS VIEW, MINNESOTA Enterprise Funds 2013 Budgets Combining Statement of Revenues and Expenses Sanitary Street Storm Water Sewer Lighting Water 2013 2012 Operating revenue: Operating revenues 821,034 1,307,099 80,400 250,718 2,459,251 2,375,240 Special assessments 50,000 - - - 50,000 50,000 Connection charges - 300 - - 300 300 Tower rental - - - - - - Other income - 4,000 - - 4,000 4,000 Total operating revenue 871,034 1,311,399 80,400 250,718 2,513,551 2,429,540 Operating expenses: Personal services 319,527 298,001 3,719 88,811 710,058 700,616 Supplies 74,398 32,220 - 32,925 139,543 120,786 Contractual services 191,263 109,673 3,900 48,685 353,521 304,253 Electricity & gas 88,500 2,100 83,000 - 173,600 162,100 Disposal charges - 816,267 - - 816,267 760,913 Contingency 15,000 15,000 - - 30,000 30,000 Depreciation 240,000 160,000 - 32,000 432,000 432,000 Capital outlays 267,000 125,000 - 117,000 509,000 1,430,400 Total operating expenses 1,195,688 1,558,261 90,619 319,421 3,163,989 3,941,068 Net operating income (loss)(324,654) (246,862) (10,219) (68,703) (650,438) (1,511,528) Non-operating revenue (expenses): Investment income 12,000 45,000 1,500 22,000 80,500 100,250 Principal payment on debt (230,000) - - - (230,000) (215,000) Interest expense (4,025) - - - (4,025) (11,705) Bond fees / discounts (2,675) - - - (2,675) (1,975) Total non-operating (224,700) 45,000 1,500 22,000 (156,200) (128,430) Transfers Transfers in - - - - - 289,000 Transfers out (225,372) (249,361) (2,390) (62,959) (540,082) (536,293) Revenues over (under) expenditures (774,726) (451,223) (11,109) (109,662) (1,346,720) (1,887,251) Add back: Capital outlays 267,000 125,000 - 117,000 509,000 1,430,400 Principal on debt 230,000 - - - 230,000 215,000 Net income (loss)(277,726) (326,223) (11,109) 7,338 (607,720) (241,851) Net assets (deficit), January 1 4,307,640 4,934,999 136,765 3,017,508 12,396,911 12,746,992 Net assets (deficit), December 31 4,029,914$ 4,608,776$ 125,656$ 3,024,846$ 11,789,191$ 12,505,141$ Total 86 2009 2010 2011 2012 Y-T-D 2013 Change from 2012 Actual Actual Actual Budget 07/31/12 Request Dollar Percent Water (Fund 700): Revenues 3424 Meter charge 2,451 - (6) - - - - 0.00% 3426 Reimbursed staff time 357 - - - - - - 0.00% 3551 Spec assessments-current 38,321 59,806 71,371 50,000 35,447 50,000 - 0.00% 3552 Spec assessments-delinquent 31,639 17,264 8,799 - 2,954 - - 0.00% 3553 Spec assess.-penalty & interest 1,559 1,059 1,807 - 180 - - 0.00% 3610 Investment income 33,770 20,946 23,536 31,250 (5,953) 12,000 (19,250) -61.60% 3631 Water tower space rental 62,832 62,539 - - - - 0.00% 3680 Other revenues 788 7,214 9,929 2,000 2,652 2,000 - 0.00% 3710 Water sales 683,987 676,858 680,647 737,052 492,772 766,534 29,482 4.00% 3714 Water service fee 50,547 52,092 52,258 51,500 40,366 51,500 - 0.00% 3715 Utility connections 480 420 1,635 1,000 900 1,000 - 0.00% 3716 Penalties 8,594 7,119 7,903 - 4,928 - - 0.00% 3913 Meter sales 763 4,090 3,859 - 1,793 - - 0.00% WAC/SWM charges 2,900 500 500 - 1,000 - - 0.00% 3940 Capital Contributions 42,475 - - 0.00% 3972 Transfers - Vehicle & Equip - - - 289,000 - (289,000) -100.00% Total revenue 961,463 909,907 862,238 1,161,802 577,039 883,034 (278,768) -23.99% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 33,262 33,133 33,152 36,690 20,540 37,060 370 1.01% 0300 Social security 2,360 2,369 2,404 2,806 1,466 2,836 30 1.07% 0321 PERA 2,196 2,282 2,379 2,660 1,450 2,687 27 1.02% 0400 Group insurance 2,803 2,983 3,103 5,260 2,095 5,673 413 7.85% 0500 Workers compensation 168 196 196 244 162 250 6 2.46% 0990 Severance - - - - - - 0.00% Total personnel services 40,796 40,963 41,234 47,660 25,713 48,506 846 1.78% Materials & supplies 1600 Supplies, operating 4 - 68 - - 0.00% Total materials & supplies 4 - 68 - - - - 0.00% Contractual services 3030 Other professional services 6,334 6,476 6,986 8,280 7,120 8,434 154 1.86% 3300 Postage 2,710 2,996 3,017 3,256 2,111 3,330 74 2.27% 3430 Printing 680 980 1,048 900 766 900 - 0.00% 3630 Training - 79 - 250 - 250 - 0.00% 5130 Repairs, equipment 3,128 3,063 3,345 3,498 3,173 3,673 175 5.00% Total contractual services 12,852 13,594 14,396 16,184 13,170 16,587 403 2.49% Debt Service: 8010 Principal 200,000 205,000 - 215,000 215,000 230,000 15,000 6.98% 8020 Interest 29,350 22,837 15,938 11,705 7,680 4,025 (7,680) -65.61% 8030 Paying agent fees 431 431 431 475 431 475 - 0.00% 8040 Continuing disclosure 1,138 1,164 2,181 1,500 - 2,200 700 46.67% Total capital outlays 230,919 229,432 18,550 228,680 223,111 236,700 8,020 3.51% Miscellaneous: 9800 Loss on disposal of asset 153 - - - 0.00% 9900 Transfers out to General Fund 59,859 61,655 63,505 65,410 67,372 1,962 3.00% 9900 Transfers out to Vehicle Fund 20,000 20,000 58,000 58,000 58,000 - 0.00% Total capital outlays 79,859 81,655 121,658 123,410 - 125,372 1,962 1.59% Total Billing 364,430 365,644 195,906 415,934 261,994 427,165 11,231 2.70% 2013 Budget Summary 87 Fund: 700 Department: 4820 Billing Services Account Description 2010 2011 2012 2013 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 6,435 6,615 6,705 6,840 22.5% of audit fee 800 800 800 800 Inserting & mailing bills 400 400 400 400 Legal services - - 375 394 Annual maintenance (meter reading software)(50% sewer, 50% Water) 7,635 7,815 8,280 8,434 3300 Postage 2,816 2,816 2,816 2,880 3200 bills X $0.45 postage X 4 billings X 1/2 cost 374 440 440 450 Late notices: 500 bills X $0.45 postage X 4 billings X 1/2 cost 3,190 3,256 3,256 3,330 3430 Printing 450 450 450 450 Utility bills (1/2 cost) 450 450 450 450 Envelopes 900 900 900 900 3630 Training 250 250 250 250 Seminars on new regulations, software updates, etc. INCODE training 250 250 250 250 Defer INCODE Training to future year $1,000 5130 Repairs, equipment 2,885 3,029 3,180 3,339 INCODE software support (30%) 289 303 318 334 Handheld interface support for new meter readers (50% water 50% sewer) 3,174 3,332 3,498 3,673 8010 Principal 205,000 210,000 215,000 230,000 Principal due on bonds 205,000 210,000 215,000 230,000 8020 Interest 25,570 18,825 11,705 4,025 Interest due on 2002 A Bonds 25,570 18,825 11,705 4,025 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 1,500 2,200 Annual debt disclosure requirements and Ramsey county sp. Assmt. Fees 2,150 2,150 1,500 2,200 9900 Transfers out 61,655 63,505 65,410 67,372 Transfer to General Fund for administrative overhead costs 20,000 57,000 58,000 58,000 Transfer to Vehicle & Equipment Fund to fund future purchases 81,655 120,505 123,410 125,372 330,049 367,558 368,324 378,709 88 2009 2010 2011 2012 Y-T-D 2013 Change from 2012 Actual Actual Actual Budget 07/31/12 Request Dollar Percent Water (Fund 700): 2013 Budget Summary Infrastructure & Equip Maintenance (4823): Personnel services 0100 Salaries, regular 153,144 165,318 173,564 173,363 96,597 175,954 2,591 1.49% 0110 Salaries, overtime 15,195 7,360 6,662 9,182 1,976 9,275 93 1.01% 0150 Salaries, part-time 16,474 13,449 14,486 18,475 6,320 18,475 - 0.00% 0300 Social security 12,845 13,028 13,284 15,377 7,371 15,584 207 1.35% 0321 PERA 11,637 11,990 12,761 13,518 6,897 13,710 192 1.42% 0400 Group insurance 25,145 28,231 28,791 31,130 16,913 31,592 462 1.48% 0500 Workers compensation 5,048 5,760 5,445 6,189 4,102 6,431 242 3.91% Total personnel services 239,488 245,136 254,993 267,234 140,176 271,021 3,787 1.42% Materials & supplies 1210 Supplies, bldg & grnds 3,174 1,210 1,443 5,300 994 3,800 (1,500) -28.30% 1220 Supplies, vehicles 593 442 1,091 800 1,326 800 - 0.00% 1230 Supplies, equipment 1,579 1,181 8,851 818 14 4,325 3,507 428.73% 1240 Supplies, streets 1,247 1,652 1,602 5,000 1,890 3,000 (2,000) -40.00% 1250 Supplies, utilities 5,902 10,163 12,602 14,250 633 14,000 (250) -1.75% 1260 Supplies, traffic control 38 - - 200 - 200 - 0.00% 1600 Supplies, operating 6,751 3,307 2,845 4,300 1,558 4,300 - 0.00% 1700 Motor fuels 2,832 5,635 4,785 5,850 2,495 5,850 - 0.00% 2400 Uniforms 1,239 1,043 1,496 1,475 722 1,475 - 0.00% 2410 Mats & towels 1,427 1,266 1,677 1,620 1,304 1,620 - 0.00% Total materials & supplies 24,782 25,899 36,392 39,613 10,936 39,370 (243) -0.61% Contractual services 3030 Other professional services 8,272 4,824 3,938 5,830 1,723 7,580 1,750 30.02% 3100 Communications - telephone 1,909 2,211 2,386 2,060 1,080 2,060 - 0.00% 3200 Water & wastewater charges 8,030 7,846 8,226 6,000 218 7,200 1,200 20.00% 3220 Natural gas 10,792 6,292 7,455 10,000 3,848 8,500 (1,500) -15.00% 3610 Memberships 261 265 189 440 154 440 - 0.00% 3630 Training 943 844 2,600 3,940 2,190 2,740 (1,200) -30.46% 4010 Equipment rental 2,458 1,927 5,123 4,500 - 4,000 (500) -11.11% 4800 Insurance 8,700 8,290 9,940 10,230 11,254 10,230 - 0.00% 5130 Repairs, equipment 6,309 13,430 3,249 1,250 1,890 11,100 9,850 788.00% 5140 Repairs, streets 12,500 18,219 35,096 10,000 3,598 14,000 4,000 40.00% 5150 Repairs, utilities 6,337 7,468 592 1,800 - 5,000 3,200 177.78% 5155 Water service repair 41,271 32,654 65,267 50,000 24,688 50,000 - 0.00% 5160 Repairs, system maintenance 2,650 5,107 9,955 15,000 7,078 30,121 15,121 100.81% Total contractual services 110,432 109,377 154,016 121,050 57,721 152,971 31,921 26.37% Capital outlays 7030 Equipment - - - 52,200 12,784 17,000 (35,200) -67.43% 7050 Construction - - - 1,097,700 131,843 250,000 (847,700) -77.23% 7950 Depreciation 230,375 229,199 213,184 240,000 - 240,000 - 0.00% Total capital outlays 230,375 229,199 213,184 1,389,900 144,627 507,000 (882,900) -63.52% Miscellaneous: 9100 Contingency - - - 15,000 15,000 - 0.00% 9900 Transfer to Street Fund 90,000 100,000 100,000 100,000 100,000 100,000 100.00% Total miscellaneous 90,000 100,000 100,000 115,000 - 115,000 100,000 86.96% Total infrastructure & equip maint 695,077 709,611 758,585 1,932,797 353,460 1,085,362 (747,435) -38.67% 89 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2010 2011 2012 2013 Description 1210 Supplies, Bldgs & grounds 100 100 100 100 Mops, buckets, brooms 600 600 600 600 Light tubes & ballasts 200 200 200 200 Paper products 200 200 200 200 Paint, thinner, & brushes 500 2,500 2,500 1,000 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 500 500 500 500 Irrigation parts 300 300 300 300 Goose repellent 3,300 5,300 5,300 3,800 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 100 100 100 100 Grounds maintenance equipment 100 100 100 100 Blades, suction hoses, filter screens 168 168 168 175 Hydraulic fluid: 35 gallons @ $4.80 / gallon 200 200 200 200 Solvents & cleaning fluids 150 150 150 200 Air compresser & dehumidifier parts (moved from 1250) 650 2,100 2,100 2,100 Chemical equipment parts (flouride pumps)(moved from 1250) - - - 1,100 Floride tank replacement (3 tanks every 3 years) 150 150 150 250 Air, oil, fuel, & trans filters 1,618 3,068 3,068 4,325 1240 Supplies, streets 3,000 5,000 5,000 3,000 Asphalt/concrete/sod/seed for patching minor street,curb, driveway repairs. 3,000 5,000 5,000 3,000 1250 Supplies, utilities 500 2,500 5,000 - Meter batteries (200 @ $25) 500 500 500 500 Paint & sandblasting materials for hydrants 500 500 500 500 Copper, steel & PVC pipe 1,200 - - - Location flags & paint (moved to account 1600) 1,500 1,500 1,500 1,500 Valve box risers, main repair clamps 1,000 1,000 1,000 1,000 Hydrant markers 1,500 1,500 1,500 1,500 Hydrant repair parts & used hydrants - 2,000 2,000 2,000 Meter supplies, etc. (move from account 1600) - - - 2,000 Motorized gate valve wrench - - - 1,500 Motorized hydrant wrench - - - 1,500 Hydrant cut-off tool - - - 2,000 Plasma cutter 6,700 9,500 12,000 14,000 1260 Supplies, traffic control 200 200 200 200 Traffic cones / safety vests 200 200 200 200 1600 Supplies, operating 500 500 500 500 Propane, acetylene & oxygen supplies 400 400 400 400 Gloves, masks, & rags 650 650 650 650 Film, first aid supplies, & batteries - 1,500 1,500 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 - - - Meter supplies, etc. (move to account 1250) 3,300 4,300 4,300 4,300 1700 Motor fuels & lubs 188 375 450 450 Diesel fuel - 100 gallons @ $4.50 300 200 200 200 Propane: 50 gallons @ $4 4,225 4,225 5,200 5,200 Unleaded fuel: 1,300 gallons @ $4.00 4,713 4,800 5,850 5,850 2400 Uniforms 1,380 1,380 1,475 1,475 Uniforms 19% of $6,000 and clothing 1.9 FTE x $175 per contract 1,380 1,380 1,475 1,475 2410 Mats & towels 800 800 1,620 1,620 Share of floor mats & shop towels (19% of $8,500) 800 800 1,620 1,620 3030 Other professional services 1,400 1,400 180 180 Backflow prevention testing (3 @ $60 per test) - 3,000 - 3,000 Water system leak survey (every 2 years, 2013) - - - 250 Water tower evaluation - 200 200 200 Fire sprinkler inspections/testing 350 350 200 200 Fire extinguisher inspection/servcie (10 @ $20) 2,750 2,750 2,750 2,750 Gopher State One-call locates 10,000 5,000 2,500 1,000 Arcview/GIS base map consulting 14,500 12,700 5,830 7,580 3100 Communications - telephone 400 400 400 400 Service & repair 1,200 1,200 1,570 1,570 Cellular phone service (18.5% of $8,500) 80 80 - - On call pager (half water / half sewer) - 100 90 90 800 Mhz license fee (33%)(5 radios @ $4.48 per month) 1,680 1,780 2,060 2,060 3200 Water and wastewater charges 5,000 5,000 6,000 7,200 5,000 5,000 6,000 7,200 90 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance Account Description 2010 2011 2012 2013 Description 3220 Natural gas 12,000 12,000 10,000 8,500 Heating fuel 12,000 12,000 10,000 8,500 3610 Memberships 113 113 150 150 American Public Works Association (APWA)(25% of $600) 195 100 100 100 MN Rural Water Association (50%) 65 80 80 80 MN Safety Council (19% of $405) - - 50 50 Suburban Utility Superintendant Association (SUSA)(50% of $100) 60 60 60 60 Pressurized vessel license 433 353 440 440 3630 Training 600 - - - Collection operator's seminar 250 250 250 250 Computer training/webinars 200 200 - - Confined space safety seminar - - 1,200 - Trench safety training (on-site)(not annual) 120 120 110 110 Hearing test/R2K (2.15 FTE * $50) 50 50 - - License renewal 60 60 60 60 Maintenance Expo 160 800 820 820 Water operator class/exam/certificate ($205 per person) 200 200 200 200 Misc. training seminars - - 390 390 Equipment operator training 400 200 200 200 MRWA workshops 125 150 150 150 MN Public Works Assoc workshop 560 560 560 560 Tuition reimbursement 60 60 - - Work zone safety seminar (every 3 years) 2,785 2,650 3,940 2,740 4010 Rental, equipment 2,500 3,500 3,500 3,500 Skid steer - upgrade 600 600 600 300 Barricades & signs 400 400 400 200 Tools & equipment 300 - - - Fax machine 3,800 4,500 4,500 4,000 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 & vehicles 1,000 1,000 100 - Chemical pump repairs - - - 2,500 Well and water treatment plant repairs 250 - - - Copier maintenance 1,000 1,000 1,000 1,500 Miscellaneous repairs (Backhoe, Skidsteer) - - - 1,500 Utility truck repairs 200 - - - Sprinkler inspections - Well #3 (moved to account 3030) - - - 5,500 10" gate valve repair (well #3) 150 150 150 100 Radio repairs 2,600 2,150 1,250 11,100 5140 Repairs, streets 10,000 10,000 10,000 14,000 Contractor repairs to streets after water main breaks 10,000 10,000 10,000 14,000 5150 Repairs, utilities 800 800 800 - RTU panel repairs 1,000 1,000 1,000 - Electrical modifications & repairs 900 - - - Floride tanks for each well house (every 3 years) 2,500 - - - Leak survey (moved to account 3030) - - - 5,000 Contractor repairs to distribution system 5,200 1,800 1,800 5,000 5155 Water service repairs 50,000 50,000 50,000 50,000 Contractor repairs to residential water services. 50,000 50,000 50,000 50,000 5160 System maintenance 13,000 13,000 12,500 10,000 Building repairs 2,000 2,000 2,500 3,500 Water system maintenance & repair items - - - 7,500 Well #4 perimeter fencing 15,000 15,000 15,000 21,000 7030 Capital, equipment 8,000 8,000 8,000 17,000 Gate valves 5,000 5,000 - - GPS Locating Equipment (Sewer 5,000)(carryover from 2010) 125,000 - - - Booster station - 10,500 10,500 - Plate compactor for backhoe - - 8,500 - Trench box - 5,000 - - SCADA System upgrade Phase #2 well #6 - - 19,000 - Chemical feed equipment (WTP #2 & 3) - - 3,200 - Dehumidifier (well #6) - - 1,200 - Laptop and mounting bracket for infield use of record drawings - - 1,800 - Hydrant diffuser 138,000 28,500 52,200 17,000 7050 Construction - 800,000 70,000 - Water tower rehabilitation 2011 - $800,000 100,000 75,000 - - Well #2 motor replacement (carryover from 2010) 22,700 22,700 22,700 - Well #1,2,3 building repairs (int. and exterior repairs)(carryover from 10,11) 211,000 250,000 250,000 250,000 Reservoir & booster station building and roof repairs (carryover from 10,11) - 65,000 50,000 - Roof replacement well #1 60,000 - 75,000 - Well pump rehabilitation project (wells no. 3&5) 393,700 1,212,700 467,700 250,000 7950 Depreciation 215,000 225,000 240,000 240,000 Estimated depreciation 215,000 225,000 240,000 240,000 9100 Contingency 15,000 15,000 15,000 15,000 Contingency 15,000 15,000 15,000 15,000 9900 Transfers out 100,000 100,000 100,000 100,000 Water system upgrades in conjunction with major roadway program 100,000 100,000 100,000 100,000 1,020,739 1,744,511 1,035,563 805,220 91 2009 2010 2011 2012 Y-T-D 2013 Change from 2012 Actual Actual Actual Budget 07/31/12 Request Dollar Percent Water (Fund 700): 2013 Budget Summary Water Production (4825): Materials & supplies 1600 Supplies, operating 31,007 31,982 24,570 32,778 18,652 32,778 - 0.00% 1700 Motor fuels 310 552 - 3,150 - 2,250 (900) -28.57% Total materials & supplies 31,317 32,534 24,570 35,928 18,652 35,028 (900) -2.51% Contractual services 3030 Other professional services 23,991 11,517 22,889 30,205 7,386 30,205 - 0.00% 3210 Electricity 74,990 76,248 82,096 77,000 38,630 80,000 3,000 3.90% 3630 Training - - - 200 - (200) -100.00% Total contractual services 98,981 87,765 104,985 107,405 46,016 110,205 2,800 2.61% Total water production 130,298 120,299 129,555 143,333 64,668 145,233 1,900 1.33% Total expenditures 1,189,805 1,195,554 1,084,046 2,492,064 680,122 1,657,760 (734,304) -29.47% Revenues over (under) expenditures (228,342) (285,647) (221,808) (1,330,262) (103,083) (774,726) 455,536 -34.24% Add back: capital outlays - - - 1,149,900 144,627 267,000 (882,900) -76.78% principal payment on debt 200,000 205,000 - 215,000 215,000 230,000 15,000 6.98% Change in net assets (28,342) (80,647) (221,808) 34,638 256,544 (277,726) (312,364) -901.80% Net Assets, beginning year 4,603,799 4,575,457 4,494,810 4,273,002 4,273,002 4,307,640 34,638 0.81% Net Assets, end of year 4,575,457$ 4,494,810$ 4,273,002$ 4,307,640$ 4,529,546$ 4,029,914$ (277,726)$ -6.45% 92 Fund: 700 Department: 4825 Water Production Account Description 2010 2011 2012 2013 Description 1600 Supplies, operating 550 550 550 550 Computer supplies 800 800 800 800 Testing reagents 3,950 3,950 3,950 3,950 Sulfur dioxide: 25 150# cylinders @ $1.05 per pound 8,000 8,000 8,000 8,000 Chlorine: 8 - 1 ton cylinders @ .50 per pound 8,438 8,438 8,438 8,438 75 - 150 # cylinders @ $.75 6,600 6,600 6,600 6,600 Hydrofluosilic acid: 20,000 pounds @ $0.33 3,190 3,190 3,190 3,190 R-999 Buffer solution 2 - 55 gal drums @ 29 per gal. - 850 850 850 Sand seperater 400 400 400 400 Water conservation program implementation 31,928 32,778 32,778 32,778 1700 Motor fuels & lubs 330 - - - Motor oil for well # 2 - 55 gallons $6 gal. 150 200 200 200 Turbine & electric motor oil 192 250 250 250 Oil for generators 1,000 - - - Propane for well #2: 500 gallons @ $2.00 2,250 2,250 2,700 1,800 Diesel fuel for primary generator: 400 gallons @ $4.50 3,922 2,700 3,150 2,250 3030 Other professional services 960 960 960 960 Bacteria tests (8*$10*12 months) 800 800 800 800 Computer maintenance 9,000 9,000 1,000 1,000 Consumer confidence report 6,800 7,500 7,500 7,500 DNR water permit fee (annual surcharge) 300 300 300 300 Emergency Response Commission fees 1,120 1,120 1,120 1,120 Full scan tests - 4 @ $280 600 600 600 600 Minimum contamination level (MCL) tests 1,000 1,000 1,000 1,000 Radon tests 800 800 800 800 Random sample tests - - 825 825 MCES discharge permits (3*$275) 150 150 300 300 MNDPS - EPCRA program ($100/WTP) 10,000 15,000 15,000 15,000 Well head protection plan (req. by Dept. of Health)(30k2/3yr 12-14) 31,530 37,230 30,205 30,205 3210 Electricity 75,510 77,000 77,000 80,000 Electricity for wells, tower & reservoir 75,510 77,000 77,000 80,000 3630 Training 200 200 200 - General training 200 200 200 - 143,090 149,908 143,333 145,233 93 2013 Budget Summary 2009 2010 2011 2012 Y-T-D 2013 Change from 2012 Actual Actual Actual Budget 07/31/12 Request Dollar Percent Sanitary Sewer (Fund 730): Revenues 3426 Reimbursed staff time - - 85 - - - 0.00% 3551 Spec. Assessments 2,125 5,749 1,848 - 4,015 - 0.00% 3610 Investment income 77,662 47,990 59,917 45,000 (15,111) 45,000 - 0.00% 3680 Other revenues - - 170 - 750 - 0.00% 3716 Penalties 11,019 9,637 10,363 - 5,567 - 0.00% 3720 Utility sales 1,138,858 1,153,260 1,167,808 1,257,470 901,548 1,307,099 49,629 3.95% 3721 SAC charges (15,480) (2,157) 268 4,000 71 4,000 - 0.00% 3725 Utility connections 180 420 775 300 350 300 - 0.00% 3726 Penalties & interest 824 248 - 0.00% 3728 Contractual wastewater service 74 - - - 0.00% 3911 Gain on sale of assets - - 30,204 - - 0.00% 3940 Capital Contributions 42,475 - - - 0.00% 3972 Transfers from Vehicle Fund - - 300,000 - - 0.00% Total revenue 1,256,913 1,214,899 1,572,262 1,306,770 897,438 1,356,399 49,629 3.80% Operating expenses Billing Services (4820): Personnel services 0100 Salaries, regular 33,262 33,133 33,152 36,690 20,540 37,060 370 1.01% 0110 Salaries, overtime 68 - - - - - 0.00% 0300 Social security 2,364 2,369 2,403 2,806 1,466 2,836 30 1.07% 0321 PERA 2,200 2,282 2,379 2,660 1,450 2,687 27 1.02% 0400 Group insurance 2,812 2,983 3,105 5,260 2,095 5,673 413 7.85% 0500 Workers compensation 168 196 196 244 162 250 6 2.46% Total personnel services 40,874 40,963 41,235 47,660 25,713 48,506 846 1.78% Materials & supplies 1600 Supplies, operating - - 57 50 - 50 - 0.00% Total materials & supplies - - 57 50 - 50 - 0.00% Contractual services 3030 Other professional services 6,334 6,476 6,986 7,905 7,120 8,040 135 1.71% 3300 Postage 2,710 2,996 3,017 3,256 2,111 3,330 74 2.27% 3430 Printing 680 980 1,048 900 766 900 - 0.00% 3630 Training - 310 - 250 - 250 - 0.00% 5130 Repairs, equipment 3,128 3,071 3,345 3,498 3,173 3,673 175 5.00% Total contractual services 12,852 13,833 14,396 15,809 13,170 16,193 384 2.43% Miscellaneous: 9900 Transfers out to General Fund 47,411 48,833 50,298 51,807 - 53,361 1,554 3.00% 9900 Transfers out to Vehicle Fund 36,000 36,000 36,000 36,000 - 36,000 - 0.00% Total miscellaneous 83,411 84,833 86,298 87,807 - 89,361 1,554 1.77% Total Billing 137,137 139,629 141,986 151,326 38,883 154,110 2,784 1.84% Infrastructure & Equip Maintenance (4823): Personnel services 100 Salaries, regular 148,658 159,201 157,397 166,553 90,266 167,612 1,059 0.64% 110 Salaries, overtime 5,215 5,814 7,552 7,365 3,088 7,439 74 1.00% 150 Salaries, part-time 7,511 10,071 9,369 11,100 6,102 11,100 - 0.00% 300 Social security 11,580 12,808 12,207 14,153 7,201 14,241 88 0.62% 321 PERA 10,655 11,404 11,489 12,892 6,749 12,973 81 0.63% 400 Group insurance 19,268 22,718 24,423 29,642 15,226 30,350 708 2.39% 500 Workers compensation 4,552 5,238 4,937 5,606 3,716 5,780 174 3.10% Total personnel services 207,439 227,254 227,374 247,311 132,348 249,495 2,184 0.88% 94 Fund: 730 Department: 4820 Billing Services Account Description 2010 2011 2012 2013 Description 1600 Supplies, operating 50 50 50 50 Utility billing supplies 50 50 50 50 3030 Other professional services 800 825 825 825 Inserting & mailing bills - - 375 375 Annual maintenance (meter reading software)(50% sewer, 50% Water) 6,435 6,615 6,705 6,840 22.5% of audit fee 7,235 7,440 7,905 8,040 3300 Postage 2,816 2,816 2,816 2,880 3200 bills X $0.45 postage X 4 billings X 1/2 cost 374 440 440 450 Late notices: 500 bills X $0.45 postage X 4 billings X 1/2 cost 3,190 3,256 3,256 3,330 3430 Printing 450 450 450 450 Envelopes 450 450 450 450 Utility bills (1/2 cost) 900 900 900 900 3630 Training 250 250 250 250 Seminars on new regulations, software updates, etc. INCODE training (new) 250 250 250 250 Defer INCODE training to a future year $1,000 5130 Repairs, equipment 2,885 3,029 3,180 3,339 Incode software support (30%) 289 303 318 334 Handheld interface support for new meter readers (50% water 50% sewer) 3,174 3,332 3,498 3,673 9900 Transfers out 48,833 50,298 51,807 53,361 Transfer to General Fund for admin costs 36,000 36,000 36,000 36,000 Transfer to Vehicle & Equipment Fund for vehicle use 84,833 86,298 87,807 89,361 99,632 101,526 103,666 105,604 95 2013 Budget Summary 2009 2010 2011 2012 Y-T-D 2013 Change from 2012 Actual Actual Actual Budget 07/31/12 Request Dollar Percent Sanitary Sewer (Fund 730): Materials & supplies 1210 Supplies, bldg & grnds 90 49 28 200 - 200 - 0.00% 1220 Supplies, vehicles 1,756 781 1,948 1,575 1,543 1,575 - 0.00% 1230 Supplies, equipment 3,243 2,484 1,685 3,250 6,046 4,750 1,500 46.15% 1240 Supplies, streets - - 5,320 850 - 3,000 2,150 252.94% 1250 Supplies, utilities 1,065 1,452 11 1,950 853 4,450 2,500 128.21% 1260 Supplies, traffic control - - - 300 - 300 - 0.00% 1600 Supplies, operating 1,806 2,367 2,526 4,300 5,998 6,300 2,000 46.51% 1700 Motor fuels 4,859 6,577 6,560 8,500 5,138 8,500 - 0.00% 2400 Uniforms 1,175 1,010 1,861 1,475 718 1,475 - 0.00% 2410 Mats & towels 1,427 1,295 1,677 1,620 1,304 1,620 - 0.00% Total materials & supplies 15,421 16,015 21,616 24,020 21,600 32,170 8,150 33.93% Contractual services 3030 Other professional services 1,452 1,194 4,746 5,350 1,072 5,350 - 0.00% 3100 Communications - telephone 1,214 1,407 1,641 1,660 763 1,660 - 0.00% 3200 Water & sewer 2,911 2,593 2,620 2,600 1,550 2,600 - 0.00% 3210 Electricity 2,072 2,019 2,494 2,100 951 2,100 - 0.00% 3230 Wastewater disposal - Met Council 733,120 776,845 776,066 760,913 507,275 816,267 55,354 7.27% 3610 Memberships 63 64 - 230 - 230 - 0.00% 3630 Training 513 756 965 4,590 2,473 4,590 - 0.00% 4010 Equipment rental - - - 1,000 - 1,000 - 0.00% 4800 Insurance 6,163 5,605 5,544 7,300 3,517 7,300 - 0.00% 5130 Repairs, equipment 20,222 3,660 6,133 8,750 7,239 8,750 - 0.00% 5150 Repairs, utilities - - 40,886 1,000 - 2,500 1,500 150.00% 5155 Utility service repairs - - 15,443 4,500 - - (4,500) -100.00% 5160 Repairs, maintenance 14,674 6,590 9,934 42,500 1,150 59,500 17,000 40.00% Total contractual services 782,404 800,733 866,472 842,493 525,990 911,847 69,354 8.23% Capital outlays 7030 Equipment - - - 38,500 - (38,500) -100.00% 7050 Construction - - - 125,000 92 125,000 - 0.00% 7950 Depreciation 157,989 156,758 161,512 160,000 160,000 - 0.00% Total capital outlays 157,989 156,758 161,512 323,500 92 285,000 (38,500) -11.90% Miscellaneous: 9100 Contingency - - - 15,000 - 15,000 - 0.00% 9900 Transfer to Street fund 150,000 160,000 160,000 160,000 - 160,000 - 0.00% Total miscellaneous 150,000 160,000 160,000 175,000 - 175,000 - 0.00% Total infrastructure & equip maint 1,313,253 1,360,760 1,436,974 1,612,324 680,030 1,653,512 41,188 2.55% Total expenditures 1,450,390 1,500,389 1,578,960 1,763,650 718,913 1,807,622 43,972 2.49% Revenues over (under) expenditures (193,477) (285,490) (6,698) (456,880) 178,525 (451,223) 5,657 -1.24% Add back: capital outlays - - - 163,500 92 125,000 (38,500) -23.55% Change in net assets (193,477) (285,490) (6,698) (293,380) 178,617 (326,223) (32,843) 11.19% Net Assets, beginning of year 5,714,044 5,520,567 5,235,077 5,228,379 5,228,379 4,934,999 (293,380) -5.61% Net Asset, end of year 5,520,567$ 5,235,077$ 5,228,379$ 4,934,999$ 5,406,996$ 4,608,776$ (359,066)$ -7.28% 96 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance Account Description 2010 2011 2012 2013 Description 1210 Supplies, bldgs & grounds 200 100 100 100 Paint, bulbs, fuses, etc 500 100 100 100 Seed, dirt, sod, etc 700 200 200 200 1220 Supplies, vehicles 75 75 75 75 Air, oil, fuel & transmission filters 775 775 775 775 Fluids 125 125 125 125 Repair & replacement parts 300 300 600 600 Tires & batteries 1,275 1,275 1,575 1,575 1230 Supplies, equipment 650 650 650 650 Tune up parts 500 500 500 500 Hydraulic fluids & hoses 550 200 200 200 Cutting edges (skid loader) 300 300 300 300 Misc. replacement & repair parts 300 300 300 300 Light equip misc replacement & repair parts 200 1,000 1,000 1,000 Camera track and parts 300 300 300 300 Minor repairs - - - 1,500 Cleaning nozzle for vactor 2,800 3,250 3,250 4,750 1240 Supplies, streets 50 50 50 200 Tack coat 300 300 300 300 Dewatering rock 500 500 500 2,500 Asphalt mix 500 - - - Gate @ Co. Rd. H2 & West City Limits (move to 2009) 1,350 850 850 3,000 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 - - - 2,500 Portable flow meter 750 750 750 750 Manhole covers, adjust rings & bolts 1,950 1,950 1,950 4,450 1260 Supplies, traffic control 300 300 300 300 Traffic cones, work zone sign face, safety vests 300 300 300 300 1600 Supplies, operating 650 500 500 500 Additional & replacement hand tools 100 250 250 250 Glove & paper products 150 150 150 150 Disinfectant supplies 500 500 500 500 Camera supplies 150 200 200 200 First aid supplies, protective equip 400 400 400 400 CD's, DVD's, software 500 500 500 500 Engineering supplies 700 700 700 700 Shop supplies, fastners, soap, degreasers, steet, batteries 500 500 500 500 Pipe, fittings, and accessories (connectors) - - - 1,500 Locating supplies (paint, flags, markers, etc.) - - - 500 Chemical blocks for lift stations - 600 600 600 Filter replacement for sewer gas monitors 3,650 4,300 4,300 6,300 1700 Motor fuels & lubs 300 300 300 300 Fluids 600 600 600 600 Motor oil - 100 gallons $6 gal. 3,250 3,250 4,000 4,000 Unleaded fuel 1,000 gallons @ $4 3,000 3,000 3,600 3,600 Diesel fuel 800 gallons @ $4.50 7,150 7,150 8,500 8,500 2400 Uniforms 1,438 1,438 1,475 1,475 Uniforms 19% of $6,000 and clothing 1.9 FTE x $175 per contract 1,438 1,438 1,475 1,475 2410 Mats & towels 800 800 1,620 1,620 Share of floor mats & shop towels (19% of $8,500) 800 800 1,620 1,620 3030 Other professional services 2,750 2,750 2,750 2,750 Gopher State One Call locates - - - - Consulting engineering services - - 100 100 Fire extinguisher inspection/servcie (5 @ $20) 10,000 5,000 2,500 2,500 Arcview/GIS base map consulting 12,750 7,750 5,350 5,350 3100 Communications - telephone 50 50 Service & repair 80 80 On call pager (half water / half sewer) 1,200 1,200 1,570 1,570 Cellular phone service (18.5% of $8,500) - 100 90 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 1,330 1,430 1,660 1,660 3200 Water & Sewer service 1,200 1,200 2,600 2,600 Estimated annual charge 1,200 1,200 2,600 2,600 3210 Electricity 1,888 2,100 2,100 2,100 Electricity for lift stations 1,888 2,100 2,100 2,100 38,581 33,993 35,730 43,880 97 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance (continued) Account Description 2010 2011 2012 2013 Description 3230 Metro Waste Commission 776,845 776,066 760,913 816,267 Estimated annual charge 776,845 776,066 760,913 816,267 3610 Memberships 113 - - - American Public Works Association (APWA)(25% of $600) - 100 100 100 MN Rural Water Assoc. (50%) - 50 50 50 Suburban Utility Superintendant Association (SUSA)(50% of $100) 65 80 80 80 MN Safety Council (20%) 178 230 230 230 3630 Training 600 600 1,400 1,400 Collection operators training/renewal ($350 per person) 560 560 560 560 Tuition reimbursement (PW Mgt. Class - North Hennepin CC) 250 250 250 250 Computer training/webinars 120 120 110 110 Hearing test/R2K (2.15 FTE * $50) 50 50 - - License renewal 200 200 1,200 1,200 Confined space seminar (on-site)(not annual) 150 150 - - Trench safety training 450 450 - - Wastewater collection operators recertification seminar 235 235 - - Low voltage license 320 320 320 320 Metro school 110 110 - - Pesticide applicators license - - 300 300 Miscellaneous wastewater training - - 60 60 Maintenance Expo - - 390 390 Equipment operator training 125 - - - APWA MN conference 60 60 - - Work zone safety seminar (every 3 years) 3,230 3,105 4,590 4,590 4010 Rental, equipment 1,000 1,000 1,000 1,000 Barricades & signs 1,000 1,000 1,000 1,000 4800 Insurance 7,246 7,300 7,300 7,300 Share of property/liability insurance 7,246 7,300 7,300 7,300 5130 Repairs, equipment 100 100 - - Fire extinguisher recharge / repair 500 - - - Groveland Lift Station repair 200 2,500 2,500 2,500 Repairs to motors & pumps 10,000 2,500 2,500 2,500 Repairs to Vactor (jet truck) - 2,500 2,500 2,500 Repairs to camera van and camera equipment - 1,000 1,000 1,000 Repairs to utility truck 250 250 250 250 Misc repairs 250 - - - Copy machine/fax machine repairs 11,300 8,850 8,750 8,750 5150 Repairs, utilities 500 - - - Repairs to RTUs - 1,000 1,000 2,500 Lift station repairs 500 1,000 1,000 2,500 5155 Utility service repairs 4,500 4,500 4,500 - Service line repairs 4,500 4,500 4,500 - 5160 System maintenance 50,000 15,000 15,000 15,000 Sewer main & manhole rehabilitation 15,000 25,000 25,000 25,000 Root control - - - 15,000 Contractor restoration of pavement, bwd., etc... 27,500 - 2,500 4,500 Lift station maintenance/cleaning 100,000 100,000 - - Sewer pipe relining program 192,500 140,000 42,500 59,500 7030 Capital, equipment 330,000 300,000 - - Vactor (includes auto chassis lube) 5,000 5,000 - - GPS Locating Equipment (carryover from 2010) - 30,000 30,000 - Generator - trailer mounted (carryover) - - 8,500 - Wincam software upgrade/desktop license/training - 2,500 - - Vehicle Cameras (3) 335,000 337,500 38,500 - 7050 Construction - - 125,000 125,000 Sewer pipe relining program (carryover from 12) - - 125,000 125,000 7950 Depreciation 165,000 160,000 160,000 160,000 Estimated depreciation 165,000 160,000 160,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 160,000 160,000 Sewer system upgrades in conjunction with major roadway program 160,000 160,000 160,000 160,000 1,672,299 1,614,551 1,329,283 1,360,137 98 2009 2010 2011 2012 Y-T-D 2013 Change from 2012 Actual Actual Actual Budget 07/31/12 Request Dollar Percent Street Lighting (Fund 740): Revenues 3610 Investment income 3,318 2,091 2,678 2,000 (675) 1,500 (500) -25.00% 3716 Penalties 688 713 635 500 489 500 - 0.00% 3740 Street lighting charges 76,520 75,548 75,493 75,000 57,754 79,900 4,900 6.53% Total revenue 80,526 78,352 78,806 77,500 57,568 81,900 4,400 5.68% Operating expenses Operations (4416) Personnel services 0100 Salaries, regular 2,753 2,630 2,700 2,691 1,493 2,718 27 1.00% 0110 Salaries, overtime 18 - 2 - - - - 0.00% 0300 Social security 185 184 179 206 104 208 2 0.97% 0321 PERA 183 185 190 195 108 197 2 1.03% 0400 Group insurance 499 520 518 550 321 576 26 4.73% 0500 Workers compensation 15 18 17 19 13 20 1 5.26% 0990 Severence pay - - - - - 0.00% Total personnel services 3,653 3,537 3,606 3,661 2,039 3,719 58 1.58% Materials & supplies 0 1600 Supplies, operating - 11 - - - - - 0.00% 0 Contractual services 3030 Other professional services - 0.00% 3210 Electricity 71,816 72,603 82,017 73,000 40,493 83,000 10,000 13.70% 4800 Insurance 765 690 684 900 434 900 - 0.00% 5150 Repairs, utilities 3,464 3,193 2,173 3,000 - 3,000 - 0.00% Total contractual services 76,045 76,486 84,874 76,900 40,927 86,900 10,000 13.00% Other 9900 Transfer to General Fund 2,122 2,186 2,252 2,320 - 2,390 70 3.02% Total other 2,122 2,186 2,252 2,320 - 2,390 70 3.02% 0.00% Total expenditures 81,820 82,220 90,732 82,881 42,966 93,009 10,128 12.22% Revenues over (under) expenditures (1,294) (3,868) (11,926) (5,381) 14,602 (11,109) (5,728) 106.45% 0.00% Add back: Capital outlays - - - - - - - 0.00% Change in net assets (1,294) (3,868) (11,926) (5,381) 14,602 (11,109) (5,728) 106.45% Net assets, beginning year 159,234 157,940 154,072 142,146 142,146 136,765 (5,381) -3.79% 0.00% Net assets, end of year 157,940$ 154,072$ 142,146$ 136,765$ 156,748$ 125,656$ (11,109)$ -8.12% 2013 Budget Summary 99 Fund: 740 Street Lighting Fund Revenues Account Description 2010 2011 2012 2013 Description 3610 Interest revenue 2,000 2,000 2,000 2,000 Estimated interest earnings at 1.25%. 2,000 2,000 2,000 2,000 3740 Street lighting charges 74,000 74,000 74,000 79,900 Estimated utility charges for street lighting. 74,000 74,000 74,000 79,900 Fund: 740 Department: 4416 Operations 3210 Electricity 68,770 72,000 73,000 83,000 Estimate 68,770 72,000 73,000 83,000 4800 Insurance 900 900 900 900 Share of property/liability insurance 900 900 900 900 5150 Repairs, utilities - - 3,000 3,000 Repairs to street lighting. - - 3,000 3,000 9900 Transfer out 2,186 2,252 2,320 2,390 Transfer to General Fund for administrative overhead costs 2,186 2,252 2,320 2,390 71,856 75,152 79,220 89,290 100 2013 Budget Summary 2009 2010 2011 2012 Y-T-D 2013 Change from 2012 Actual Actual Actual Budget 07/31/12 Request Dollar Percent Storm Water (Fund 745): Revenues 3610 Investment income 33,177 22,653 31,550 22,000 (7,932) 22,000 - 0.00% 3680 Other revenues - - 2,500 - - - 0.00% 3716 Penalties & interest 1,958 2,308 2,052 - 1,564 - - 0.00% 3730 Surface water charges 241,384 264,658 263,924 250,718 202,139 250,718 - 0.00% 3972 Transfer from other funds - - 40,000 - - - 0.00% Total revenue 276,519 289,619 340,026 272,718 195,771 272,718 - 0.00% Operating expenses System Maintenance (4415): Personnel services 0100 Salaries, regular 49,958 52,822 47,563 48,514 26,957 48,998 484 1.00% 0110 Salaries, overtime 1,293 329 1,855 1,105 348 1,116 11 1.00% 0150 Salaries, part-time 6,263 5,264 5,295 4,920 2,238 4,920 - 0.00% 0300 Social security 4,329 4,089 4,166 4,172 2,246 4,209 37 0.89% 0321 PERA 3,428 3,408 3,595 3,597 1,937 3,633 36 1.00% 0400 Group insurance 5,907 6,372 6,384 8,573 4,498 9,371 798 9.31% 0500 Workers compensation 3,266 3,875 3,466 3,884 2,574 3,995 111 2.86% 0990 Severence pay - - - - - - 0.00% Total personnel services 74,444 76,159 72,324 74,765 40,798 76,242 1,477 1.98% Materials & supplies 1230 Supplies, equipment 81 1,594 648 2,000 4,161 11,550 9,550 477.50% 1240 Supplies, streets - - 54 600 - 300 (300) -50.00% 1600 Supplies, operating 167 1,291 1,871 3,200 471 5,700 2,500 78.13% 1700 Motor fuels 2,388 2,686 2,553 3,350 762 3,350 - 0.00% 2100 Books/Periodicals - 54 - 100 - 100 - 0.00% 2400 Uniforms 723 614 715 740 559 740 - 0.00% 2410 Mats & towels 1,427 1,296 875 810 652 810 - 0.00% Total materials & supplies 4,786 7,535 6,716 10,800 6,605 22,550 11,750 108.80% Contractual services 3030 Other professional services 12,698 4,947 10,451 6,350 3,598 7,110 760 11.97% 3100 Telephone 1,143 1,057 1,417 780 770 780 - 0.00% 3610 Memberships 753 1,154 690 920 154 920 - 0.00% 3630 Training 365 307 2,094 3,195 929 3,195 - 0.00% 4800 Insurance 1,616 6,680 2,919 1,900 3,737 1,900 - 0.00% 5120 Repairs, vehicles - - - - - 1,500 1,500 #DIV/0! 5150 Repairs, utilities 7,147 - 3,336 25,000 - 25,000 - 0.00% Total contractual services 23,722 14,145 20,907 38,145 9,188 40,405 2,260 5.92% Capital outlays 7030 Equipment - - - 9,000 - 9,000 - 0.00% 7050 Construction - - - 108,000 - 108,000 - 0.00% 7950 Depreciation 31,878 32,151 30,566 32,000 - 32,000 - 0.00% Total capital outlays 31,878 32,151 30,566 149,000 - 149,000 - 0.00% Miscellaneous: 9900 Transfer out 30,000 40,000 56,000 46,756 - 46,959 203 0.43% Total miscellaneous 30,000 40,000 56,000 46,756 - 46,959 203 0.43% Total System Maintenance 164,830 169,990 186,513 319,466 56,591 335,156 15,690 4.91% 0.00% 101 2013 Budget Summary 2009 2010 2011 2012 Y-T-D 2013 Change from 2012 Actual Actual Actual Budget 07/31/12 Request Dollar Percent Storm Water (Fund 245): Street Sweeping (4417): Personnel services 0100 Salaries, regular 8,056 7,976 7,940 7,660 4,479 7,736 76 0.99% 0110 Salaries, overtime 292 181 286 1,105 62 1,116 11 1.00% 0150 Salaries, part-time - - - 240 - 240 - 0.00% 0300 Social security 610 577 571 689 321 695 6 0.87% 0321 PERA 577 571 595 635 314 642 7 1.10% 0400 Group insurance 1,278 1,353 1,349 1,354 872 1,480 126 9.31% 0500 Workers compensation 545 640 570 642 426 660 18 2.80% 0990 Severence pay - - - - - - - 0.00% Total personnel services 11,358 11,298 11,311 12,325 6,474 12,569 244 1.98% Materials & supplies 1230 Supplies, equipment 2,150 3,805 6,039 2,500 6,120 2,500 - 0.00% 1600 Supplies, operating 605 2,118 1,456 3,500 1,999 3,500 - 0.00% 1700 Motor fuels 2,389 1,583 4,987 4,150 3,193 4,150 - 0.00% 2400 Uniforms - - 75 115 57 115 - 0.00% 2410 Mats & towels - - 130 110 102 110 - 0.00% Total materials & supplies 5,144 7,506 12,687 10,375 11,471 10,375 - 0.00% Contractual services 3030 Other professional services - - - - 100 - 0.00% 3530 Disposal - - - 5,000 - 4,000 (1,000) -20.00% 3630 Training 40 109 - 280 15 280 - 0.00% 5130 Repairs, equipment - 2,036 8,139 4,000 - 4,000 - 0.00% Total contractual services 40 2,145 8,139 9,280 115 8,280 (1,000) -10.78% Capital outlays 7030 Equipment - - - - 9 - - 0.00% Total capital outlays - - - - 9 - - 0.00% 0.00% Miscellaneous:0.00% 9900 Transfer out 16,000 16,000 - 16,000 - 16,000 - 0.00% Total miscellaneous 16,000 16,000 - 16,000 - 16,000 - 0.00% Total street sweeping 32,542 36,949 32,137 47,980 18,069 47,224 (756) -1.58% Total expenditures 197,372 206,939 218,650 367,446 74,660 382,380 14,934 4.06% Revenues over expenditures 79,147 82,680 121,376 (94,728) 121,111 (109,662) (14,934) 15.77% Add back: Capital outlays - - - 117,000 9 117,000 - 0.00% Change in net asssets 79,147 82,680 121,376 22,272 121,120 7,338 (14,934) -67.05% Net assets, beginning year 2,712,033 2,791,180 2,873,860 2,995,236 2,995,236 3,017,508 22,272 0.74% Net assets, end of year 2,791,180$ 2,873,860$ 2,995,236$ 3,017,508$ 3,116,356$ 3,024,846$ 7,338$ 0.24% 102 Fund: 745 Storm Water Revenues Account Description 2010 2011 2012 2013 Description 3610 Interest revenue 25,000 22,000 22,000 22,000 Estimated interest earnings at 1.25%. 25,000 22,000 22,000 22,000 3730 Utility sales 250,718 250,718 250,718 250,718 Estimated surface water charges. 250,718 250,718 250,718 250,718 3972 Transfers - Vehicle & equip Fd 40,000 40,000 40,000 40,000 Transfer for capital equipment purchases 40,000 40,000 40,000 40,000 Fund: 745 Department: 4415 System Maintenance 1230 Supplies, equipment 500 500 500 250 Miscellaneous equipment - - - 2,500 Leveling bar for skidsteer - - - 3,500 Winch for pick-up truck - - - 3,700 Tommy gate fro pick-up truck - - - 600 Truck springs 1,000 1,500 1,500 1,000 Hoses & nozzles 1,500 2,000 2,000 11,550 1240 Supplies, streets 600 600 600 300 Bituminous mix 600 600 600 300 1600 Supplies, operating 300 300 300 250 Concrete - 1,000 2,000 2,450 Rain Garden mix, riprap, topsoil, seed and sod 1,200 200 200 175 Concrete adjustment rings - - - 150 Hand tools 200 200 200 175 CD's, DVD's, software upgrade for camera van 800 500 500 2,500 Catch basin castings, pipe, approns, etc... 2,500 2,200 3,200 5,700 1700 Motor fuels 2,250 1,125 1,350 1,350 300 gallons diesel fuel @ $4.50 / gallon for Vactor - 1,625 2,000 2,000 500 gallons unleaded @ $4.00 for utility truck 2,250 2,750 3,350 3,350 2100 Books/Periodicals 150 100 100 100 Storm water books/periodicals 150 100 100 100 2400 Uniforms 1,188 1,188 740 740 Uniforms/clothing (9.5% of $6,000, .95 FTE x $175 per contract) 1,188 1,188 740 740 2410 Mats & towels 800 800 810 810 Share of floor mats & shop towels (9.5% of $8,500) 800 800 810 810 3030 Other professional services 1,600 - - - GIS data input 5,000 5,000 5,000 5,000 Consulting engineers 5,000 2,500 1,250 1,250 Arcview/GIS base map consulting 10,000 - - - FEMA Study - 10,000 - - Silverview pond sediment removal study - - 100 100 Fire extinguisher inspection/servcie (5 @ $20) - - - 760 Audit fees 2.5% 21,600 17,500 6,350 7,110 3100 Communications 1,200 1,200 690 690 Cell Phone (8% of $8,500) - 50 90 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 1,200 1,250 780 780 3610 Memberships - - - - CPV Program 113 - 150 150 American Public Works Association (APWA)(25% of $600) 690 710 725 725 Minnesota Cities Storm Water Coalition 65 40 45 45 MN Safety Council (11% of $405) 868 750 920 920 3630 Training 200 200 200 200 Seminars & training sessions (Stormwater) - 60 55 55 Hearing test/R2K (1.1 FTE * $50) - 800 - - Wastewater class/exam - 350 350 350 Safety training - 750 750 750 NPDES compliance training - 1,250 1,250 1,250 Tuition reimbursement 700 - - - Public Education Fund 150 - - - Trench safety seminar 150 - - - Competent person training - - 270 270 Erosion & Stormwater Maint. Certification - - 220 220 Equipment operator training 500 - 100 100 Computer/webinar training 1,700 3,410 3,195 3,195 4800 Insurance 1,900 1,900 1,900 1,900 Share of property/liability insurance 1,900 1,900 1,900 1,900 5120 Repairs, vehicles - - - 1,500 Utility truck & equipment repairs - - - 1,500 5150 Repairs & maint., utilities 50,000 25,000 25,000 25,000 Repair & maintain storm sewers, ponds, basins, and drainage issues 10,000 25,000 - 10,000 Storm Sewer slip linning improvements 60,000 50,000 25,000 35,000 7030 Equipment - 4,000 4,000 4,000 Small generator for trailer - 5,000 5,000 5,000 Concrete mixer - 9,000 9,000 9,000 7050 Construction - - 25,000 - Sewer sliplining program - - 35,000 50,000 Mustang Drive improvements 48,000 - 48,000 48,000 Storm water projects, Subwatershed SC-1, SC-3, EW-4 48,000 - 108,000 98,000 103 Fund: 745 Department: 4415 System Maintenance 7950 Depreciation 35,000 32,000 32,000 32,000 Estimated depreciation 35,000 32,000 32,000 32,000 9900 Transfer out 40,000 40,000 40,000 40,000 Storm water system upgrades in conjunction with major roadway program - - 6,756 6,959 General Fund 40,000 40,000 46,756 46,959 219,256 165,448 244,701 258,914 Fund: 745 Department: 4417 Street Cleaning 1230 Supplies, equipment 200 200 2,500 2,500 Misc. repairs - belts, pumps, hoses, filters, etc. 200 200 2,500 2,500 1600 Supplies, operating 1,000 2,000 2,300 2,300 Gutter brooms - 700 700 700 Belts, pumps, hoses, filters, etc... for sweeper - 100 100 100 Gloves, hearing protection, etc... 100 400 400 400 2 dirt shoes 1,100 3,200 3,500 3,500 1700 Motor fuels 2,250 3,000 4,000 4,000 Diesel fuel - 800 gallons @ $5.00/gallon 150 150 150 150 Oil - 4 changes 2,400 3,150 4,150 4,150 2400 Uniforms 188 188 115 115 Uniforms/clothing (1.5% of $6,000, .15 FTE x $175 per contract) 188 188 115 115 2410 Mats & towels - - 110 110 Share of floor mats & shop towels (1.5% of $8,500) - - 110 110 3530 Disposal 5,000 5,000 5,000 5,000 Dumping charges for sweeping disposals 5,000 5,000 5,000 5,000 3630 Training 125 - - - American Public Works Assoc. MN conference - - - - Minnesota Public Works Assoc. conference - 500 250 250 NPDES compliance training - 30 30 30 Maintenance Expo 200 - - - MSSA operator training sessions. 200 - - - Sweeper operator seminar 200 - - - MCCA Membership 725 530 280 280 5130 Repairs, equipment - 2,000 4,000 4,000 Elgin sweeper repairs - 2,000 4,000 4,000 7030 Equipment 40,000 40,000 - - 3/4 T 4X4 Truck (carryover from 2008) 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 65,613 68,268 35,655 35,655 104 Item No: 7.A Meeting Date: December 3, 2012 Type of Business: Truth in Taxation Administrator Review: _____ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Mark Beer, Finance Director Item Title/Subject: Truth in Taxation and All Funds Budgets for 2013 Attached is the Truth in Taxation presentation and the budgets for all funds (General, Special Revenue, Debt Service, Capital Projects, and Enterprise) for your consideration. The Council has had an opportunity to review all the funds at different times during the budget process. The City Council did not increase the tax levy for 2013. Most property owners’ will see a tax decrease as a result of shifts in value away from residential property towards business, apartments, and higher valued residential properties. There have been some minor changes from the preliminary budget as more accurate information became available. The preliminary General Fund budget reflected a drawdown of fund balance of ($428,146) with adjustments that amount is now ($375,914). The biggest reductions were for the accounts payable clerk salary and benefits (retirement) and fire department adjustments. $198,000 will come from levy reduction “assigned” fund balance with the balance $178,000 coming from “unassigned” fund balance. Looking forward to 2013, state budget projections show a surplus for the current budget period. That means that there will probably not be any cuts to the late December LGA payment. The 2013 LGA payment is established at the same level as 2012 ($232,078) but the legislature will have to address a one billion deficit for the upcoming biennium. The revenue forecast will come out in early December and again in early February which is what the legislature will use to construct the next biennial budget. (2014/2015) The 2013 General Fund budget was constructed with no LGA included. Staff welcomes any comments or questions. Respectfully Submitted, Mark Beer City of Mounds View Truth in Taxation Public Hearing December 3, 2012 6:00 pm Mission Statement Our Mission is to provide high quality public services that effectively address changing citizen and community needs in a fiscally responsible and customer-friendly manner. Expenditures by Purpose Personnel 63%Supplies 6% Contractual services 23% Contingency 0% Fire debt service 2% Capital outlays 1%Transfers 5% General Fund Expenditures by Type 2013 General Government 14% Community Development 6% Public Safety 50% Streets & Highways 13%Park & Recreation 9% Debt service - Fire Bonds 2% Other 1% Transfers 5% General Fund Expenditures by Function 2013 Proposed Budget Expenditure Pie Chart - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 General Government Community Development Public Safety Streets & Highways Park & Recreation Debt service - Fire Bonds Other Transfers General Fund Expenditures 2011 Actual 2012 Budget 2013 Proposed Expenditure Bar Graph General Fund Expenditure Changes 2013 General Fund operating expenditures will increase by $124,803 or 2.47%, this includes personnel services, materials and supplies, contractual services, and contingency. 2013 General Fund capital expenditures, debt service and transfers will increase by $34,187 or 8.27%. Capital outlay and Transfers is the primary driver of the increase. Total 2013 General Fund expenditures will increase by $158,990 or 2.91% over 2012. Revenue Pie Chart General property taxes 70% Other taxes 6% Licenses & permits 4% Other revenues 9% Transfers from other funds 4% General Fund Revenues 2013 Proposed Budget $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 General Fund Revenues 2011 Actual 2012 Budget 2013 Proposed Revenue Bar Graph Budget Summary 2013 General Fund significant budget items •The City proposes a 2.91% increase in General Fund spending which includes operational spending of $124,803 and non-operational spending (debt service, capital outlay, transfers) of $34,187 for an overall increase of $158,990. •Estimated LGA in 2013 is $232,078, the City did not include this in the budget as a precaution from future uncertainty at the state level. •Other non-property tax revenues are projected to increase $46,598, this excludes transfers. •Fund Balance will be reduced by $375,874. Property Tax Levy 2013 2012 Property taxes - base levy $3,325,809 $3,367,610 Special levy - Police Referendum 181,000 190,000 Special levy - PERA rate increase 39,145 39,145 Debt service levy - Fire bonds 144,627 93,734 Debt service levy - Street bonds 190,800 190,892 Capital Project Street Imp.$300,000 $300,000 Total Levy $4,181,381 $4,181,381 No change -$ What Your Tax Dollars Buy for a Median Valued Home Median Taxable Valued Home in Mounds View 138,464$ City Tax on Median Valued Home 696.41$ Police 314.33 45.14% Public Works 99.14 14.24% Parks and Recreation 83.53 11.99% Fire 62.59 8.99% Street Improvement levy 40.46 5.81% Administration 38.60 5.54% Community Development 32.02 4.60% Debt service 25.74 3.70% 696.41$ 100.00% Sample Home Tax Impact 2012 Home 2012 2013 Home 2013 Taxable City Taxable City Value Tax Value Tax Difference 96,218$ 470.45$ 89,129$ 448.28$ (22.17)$ 120,272 588.05 111,411 560.34 (27.71) 144,327 705.66 133,693 672.41 (33.25) 149,477 730.84 138,464 696.41 (34.43) 168,381 823.27 155,975 784.48 (38.79) 192,436 940.88 178,257 896.55 (44.33) Sample Home Tax Impact City of Mounds View 28.37 cents Ramsey County 37.42 cents School District 30.08 cents Other taxing districts 4.13 cents Tax Bill Breakdown Tax Levy Per Capita Arden Hills $340.18 New Brighton $343.71 Mounds View $344.54 Shoreview $382.38Blaine $369.00 Fridley $409.62 Roseville $512.31 Spring Lake Park $402.51 $0.00 $100.00 $200.00 $300.00 $400.00 $500.00 $600.00 1 Spending per Capita In the most recent data available from the Office of State Auditor, the City spending per capita ranked 132 out of 225 For cities over 2500 in population Last Five Year’s Budgets Local Government Aid (LGA) to the City has fluctuated with significant amounts being withheld by the state. $121,371 for 2008, withheld $ 60,686 $642,866 for 2009, withheld $147,162 $571,636 for 2010, withheld $339,558 $484,724 for 2011, withheld $252,646 $232,078 for 2012, withheld $0 Market Value Homestead Credit was eliminated for 2012 and beyond $165,672 for 2008, withheld $ 82,836 $154,645 for 2009, withheld $ 0 $190,000 for 2010, withheld $160,156 $184,368 for 2011, withheld $150,477 Tax Levy No levy increase in 2006, 2007, 2008, 2009, 2012, 2013 Street levy in 2010 7.9% or $300,000 General Fund in 2011 2% or $80,993 Summary The budget is the outcome of a range of factors including: state aid, service level changes, capital projects and inflation. The goal of the budget is to efficiently apply existing city resources and new revenues to provide the service levels and infrastructure desired by the citizens of Mounds View. City of Mounds View Questions?