Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2010 Proposed Preliminary Budget
2010 PROPOSED PRELIMINARY BUDGE CITY OF ARDEN HILLS T Council Worksession August 17, 2009 TABLE OF CONTENTS PART I City-wide Budget Summary PART II Program Summaries PART III General Fund PART IV Special Revenue Funds PART V Debt Service Fund PART VI Capital Funds PART VII Enterprise Funds PART VIII Salary Allocation City- Wide Budget Summary City of Arden Hills City-Wide Budget Summary Revenues Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Operating Revenue Mayor&Council $ $ $ - $ - $ - $ - #DN/0! Elections 256 - Administration 2,843,553 2,971,271 - #DIV/0! Finance&Support Services 3,171,089 3,171,089 1,568,430 3,264,140 27,662 31,357 31,357 2.54% Planning&Zoning 158,241 51,36362,600 - 11.29% Government Buildings 56,250 92,937 22,147 62,6001 11 56% 560,145 77,815 92,937 92,937 147 95,319 Public Safety 70,477 76,396 - 2.56% Emergency Mangement 80,200 80,200 11,219 85,641 6 78 - - - - - - DI0 Protective Inspections 322,467 189,825 193,300 193,300 80 0! ,756 193,300 . Street Maintenance 64,683 65,134 - 582% Park Maintenance 64,450 64,450 34,020 68,199 5.82% 3,066 2,659 91,634 3,500 3,500 1,801 3,500 - 0,00% Recreation 86,846 Transfers89,000 89,000 64,303 88,500 - -0.56% - - - - - - #DIV/0! Total General Fund 4,109,735 3,553,759 3,782,083 3,782,083 1,783,005 3,901,506 3.16% TCAAP 751,349 407,119 Cable Fund 1,001,000 1,001,000 (322,455) 70,000 Cable Management 87,233 70,810 83,000 83,000 41,399 90.01% 26,778 10,000 185,000 22,799 10,000 - 0.00% Park Fund 32,707 20628 5,461 15,000 - 50.00% Community Services 204,000 204,000 (7) 539,126 164.28% 60,649 30,781 50,500 50,500 24,027 EDA General Fund 103,393 4,754 50,0001 - 2.00% EDA TIF#3 Cottage Villas 15,000 1,000 9,11755 9,100 00.00% 50,171 50,592 51,000 51,000 19,557 EDA Revolving Fund 6,298 5,903 - -120.00% EDA TIF#2 Round Lake 5,000 5,000 366 5,000 -20.00% 444,555 478,771 435,000 435,000 246,233 435,000 - 0.00% Total Special Revenue Funds 1,563,133 1,092,157 1,844,500 1,844,500 23,698 1,205,226 - _34.66% GO Tax Increment Bonds of 1998A 42 52 - - (18) - - #DIV/0! Total Debt Service Funds 42 52 - (18) - - #DIV/0! Equipment,Bldg&Replacement - 10,000 - # Public Safety Capital 28,794 25,410 -71.15%52,000 72,000 981 15,000 - 25 Capital Improvement Fund(PIR) 798 501,510 372,000 372,000 200,059827,947 - 12. 7 Total Capital Funds 827,541 526,920 424,000 424,000 201,040 852,947 101.17% Water 1,487,339 1,360,007 Sanitary Sewer 1,443,942 1,443,942 511,641 1,675,853 Sanitary 1,358,734 1,139,825 1,226,200 1,226,200 - 33.57% 86,505 451,376 1,637,853 - 33.57% Surface Water Management 22,186 119,404 119,404 63,281 172,800 704,801 493,149 427,660 427,660 22.13% 202,581 522,321 - 22.13% Total Enterprise Funds 3,637,378 3,015,167 3,217,206 3,217,206 1,228,880 4,008,827 - 24.61% Total Operating Revenues 10,137,829 8,188,055 9,267,789 9,267,789 3,236,605 9,968,506 7.56% Other Financing Sources Mayor&Council - Elections - - Administration - - -- - - #DIV/0! - - - #DIV/0! Finance - - - - - - - #DIV/0! Planning&Zoning - - _ - - - - - #DIV/0! Government Buildings - - - - - #DIV/0! Public Safety - - - - #DIV/0! Emergency Mangement - - _ - - - - #DIV/0! Protective Inspections - - - - - - #ON/0! Street Maintenance - - - - - #DNl0! Park Maintenance - - #DIV/01 - - - - - Recreation 39,000 - - - #DIV/0! Transfers - - - - - - - - - #DIV/0! - - #DIV/0! Total General Fund 39,000 - - #DIV/0! TCAAP - Cable Fund - - - - - - - #DN/0! Risk Management - - - - - #DN/0i Park Fund --- - - - - - #DNIO! Community Services - _ _ - - - #DNIO! EDA General Fund _ - - - #DN/0! EDA TIF#3 Cottage Villas - 25,000 25,000 - 12,600 - -49.60% - -EDA Revolving Fund - - - #DN/0! EDA TIF#2 Round Lake _ - - - #DIV/0! - - - #DN/0! Total Special Revenue Funds - - 25,000 25,000 - 12,600 - -09.60% 1 GO Tax Increment Bonds of 1998A 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Total Debt Service Funds 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Equipment,Bldg&Replacement - 500,000 204,000 204,000 - 183,000 - -10.29% Public 166,862 65,000 50,000 50,000 25,000 -50.00% Capital Improvement Capital _ - provement Fund(PIR) 246,954 200,000 200,000 200,000 200,000 0.00% Total Capital Funds 413,816 765,000 454,000 454,000 - 408,000 - -10.13% - _ - _ - - #DIV/0! Water - - - - - #DIV/0! Recycli Sewer - - - - - - - #DIV/0! Recycling - - - - #DIV/0! Surface Water Management 13,783 - - - - - #DIV/0! Total Enterprise Funds 13,783 - - - Total Other Financing Sources 748,224 1,045,100 757,475 757,475 253,175 702,175 - -7.30% Prior Period Adjustment - Total Revenues $ 10,886,053 $ 9,233,155 $ 10,025,264 $10,025,264 $ 3,489,780 $ 10,670,681 $ - 6.44% 2 • City of Arden Hills City-Wide Budget Summary Expenditures Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Operating Expenses 54,609 $ 79,386 $ 79,386 $ 34,569 $ 94,386 $ - 18.90% Mayor Council $ 2,844 $ 12,600 - 1147.52% Elections 12,81320,288 1,010 1,010 1,641 - -2.11% Administration 421,277 342,265 388,879 388,879 146,203 380,6870.69% 70,741 124,705 142,832 142,832 76,824 143,816 Finance&Support Services 79,517 261,715 - 2.18% Government e Zoning 174,439 219,379 256,128 256,128 0.32% GovemmentBuildings 365,524 186,179 240,106 240,106 49,189 240,882 2.65% Public Safety 1,101,524 1,197,337 1,217,766 1,275,114 806,622 1,308,900 - 2.65% Emergency Mangement 7,131 32,746 32,746 2,736 32,943 Protective Inspections 216,482 216,320 243,144 243,144 112,076 252,294 3.76% 1.65% Street Maintenance 246,530 265,409 282,719 282,719 123,727 287,396 - .65% 281,976 351,958 407,636 407,636 171,543 416,771 Maintenance 86,813 216,516 - 0.73% Recreation 220,018 204,856 214,957 214,957 - _ - -100.00% 6,315 6,315 # 001 Te Transferss/CoMingency _ - - - - Total General Fund 3,170,367 3,190,436 3,513,624 3,570,972 1,691,461 3,648,906 - 2.18% TCAAP 535,322 383,561 1,009,009 1,009,009 170,793 70,000 -93.06%6.43% Cable Fund 54,755 65,894 79,154 79,154 35,029 84,240 0.00% Risk Management 8,080 6,836 27,000 27,000 4,575 27,000 2,471 23,224 3,322 15,000 #DIV/0! C Fund 50,000 50,000 - 25,000 - -50.00% Community Services 65,000 65,000 EDA General Fund 86,669 469 10,500 10,500 1,822 11 700 - 11.43%7 74 EDA TIF#3 Cottage Villas 41,485 42,359 44,200 44,200 186 1,000 #-g7.7! - - - - - - - TIF EDA TIF#22 Roo EDA # iRFund 548 1,300 1,300 186 1,300 - 0.00% und Lake 556 Total Special Revenue Funds 794,337 587,891 1,221,163 1,221,163 215,913 235,240 - -80.74 - - - - #DIV/0! GO Tax Increment Bonds of 1998A - Total Debt Service Funds - - - - - #DIV/01 -- - - - - #DIV/0! Equipment,Bldg&Replacement - - - - #DIV/0 1 Public Safety Capital - - - - - #D1V/0! Capital Improvement Fund(PIR) - _ Total Capital Funds - - - #DNIO! 2%0.1 Water 1,461,455 1,635,101 1,759,790 1,759,790 516,921 1,761,826 - 0. 2% Sanitary Sewer 1,280,488 1,143,174 1,389,531 1,389,531 562,528 1,426,561 Recycling 81,583 113,709 118,679 118,679 54,115 172,672 - 42.66% Surface Water Management 147,396 219,484 269,271 269,271 92,424 346,805 - 28.79% Total Enterprise Funds 2,970,922 3,111,468 3,537,271 3,537,271 1,225,989 3,707,865 - 4.82% Total Operating Expenses 6,935,626 6,889,795 8,272,059 8,329,407 3,133,364 7,5 92,011 - -8.85% Capital Outlay - - - - #DIV/0! Mayor&Council 1,657 -- - - - - - - #DIV/0! Elections _ _ - #DIV/0! Administration 5,379 1,919 _ _ - - - #DIV/0! Finance&Support Services - 1 037 - _ _ - #DIV/0! Planning&Zoning 1,927 _ _ - #DIV/0! Government Buildings 7,691 5,208 - - - #DN/0! Public Safety - 949 _ Emergency Mangement 3,593 - - - _ - #DIV/0! - - #DN/ ! Protective Inspections 1,613 1,047 _ - - #DIV/0! Street Maintenance 3,700 387 - _ - - #0IV/0! -Park Maintenance 5,364 387 - - - #DIV/0! Recreation - -- - - - - - - #DIV/0! Transfers _ - - - #DIV/O! Total General Fund 27,332 14,527 #DIV/0! - - - #DIV/0! TCAAP 6,568 - - - 3,000 - 1V/ l Cable Fund 47,508 39,266 4,000 4,000 -25.00%# 50� Risk Fundundgement 87 321 161,895 161,895 25,737 587,991 - 263.19% Park 2,100 _ - - #DIV/01 Community Services 10,000 10,000 - 10,000 - 0.00% EDA General Fund - _ - - - #OIV/0! EDA TIF#3 Cottage Villas - - - - #DN/0! EDA Revolving Fund - _ _ - - #DIV/0! EDA TIF#2 Round Lake Total Special Revenue Funds 56,176 126,587 175,895 175,895 25,737 600,991 - 241.68% 3 GO Tax Increment Bonds of 1998A - - - - - - - #OIV/O! Total Debt Service Funds - - - - - #0lV/0! Equipment,Bldg&Replacement - - 156,068 156,068 50,250 116,400 - -25.42% Public Safety Capital 25,653 162,555 103,935 103,935 58,161 131,496 - 26.52% Capital Improvement Fund(PIR) 939,781 119,866 1,634,250 1,634,250 57,863 723,750 - -55.71% Total Capital Funds 965,434 282,421 1,894,253 1,894,253 166,274 971,646 - -48.71% Water 807 387 74,140 74,140 60,170 34,000 - -54.14% Sanitary Sewer 37,706 387 216,100 216,100 61,379 635,600 - 194.12% Recycling - - - - - - - #DIV/0! Surface Water Management - - 414,500 414,500 - 338,500 - -18.34% Total Enterprise Funds 38,514 774 704,740 704,740 121,549 1,008,100 - 43.05% Total Capital Outlay 1,087,456 424,309 2,774,888 2,774,888 313,561 2,580,737 - -7.00% Debt Service GO Tax Increment Bonds of 1998A 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Total Debt Service 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Other Financing Uses Mayor&Council - - - " - #DIV/0! _ _ - - - #DIV/0! Elections _ _ _ - - #DIV/0! Administration - _ Finance&Support Services - - _ - - - #DIV/0! Planning&Zoning - - - - - #DIV/0! Government Buildings - - - - #OIV/O! - - - - - #DIV/0! PSafublic - - _ - - - #DIV/0! Emergency ennccy Mangement - - Protective Inspections - - - (0IV/0! Street Maintenance - - - - - - - #DIV/0! Park Maintenance - - - - - - - #DIV/0! Recreation - - - - - - CAM! Transfers 387,816 700,000 255,060 255,000 - 252,600 - -0.94% Total General Fund 387,816 700,000 255,000 255,000 - 252,600 - -0.94% TCAAP - - - - - - - #DIV/0! Cable Fund - - - - - - - #DIV/0! Risk Management - - - - - - - #DIV/O! Park Fund - - - - - - - #O1VI0! Community Services - - - - #DIV/0! EDA General Fund - - - - - - - #DIV/0! EDA TIF#3 Cottage Villas - - - - - - - #DIV/0! EDA Revolving Fund - - - - - - #DIV/0! EDA TIF#2 Round Lake 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Total Special Revenue Funds 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% GO Tax Increment Bonds of 1998A - - - - #DIV/O! Total Debt Service Funds - - - - - - - #DIV/0! Equipment,Bldg&Replacement - - - - - - - #0IV/0! Public Safety Capital - - - - - - - #DIV/0! Capital Improvement Fund(PIR) - - - - - - - #DIV/0! Total Capital Funds - - - - - - - #DIV/0! Water - - 39,500 39,500 - 43,000 - 8.86% Sanitary Sewer - - 58,500 58,500 - 62,000 - 5.98% Recycling - - - - - #DIV/0! Surface Water Management - - 34,500 34,500 - 38,000 - 10.14% Total Enterprise Funds - - 132,500 132,500 - 143,000 - 7.92% Total Other Financing Uses 669,441 980,100 665,975 665,975 253,175 677,175 - 1.68% Total Expenditures $ 8,974,147 $ 8,574,304 $ 11,991,397 $12,048,745 $ 3,953,275 $ 11,131,498 $ - -7.61% 4 City of Arden Hills Expenditure Summary Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/09 FY 2010 FY 2010 09 vs 10 Personal Services 1,804,054 1,878,988 2,081,909 2,081,909 899,783 2,144,944 - 3.03% Materials and supplies 168,517 219,628 300,740 300,740 131,980 304,740 - 1.33% Other services and charges 4,895,584 4,702,955 5,833,095 5,890,443 2,098,279 5,102,327 - -13.38% Total operating expenses 6,868,155 6,801,571 8,215,744 8,273,092 3,130,042 7,552,011 - -8.72% Capital Outlay 1,089,926 447,533 2,618,820 2,618,820 266,633 2,595,737 - -0.88% Debt Service 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Transfers 734,441 1,045,100 583,475 583,475 253,175 702,175 - 20.34% Total Expenditures 8,974,147 8,574,304 11,696,514 11,753,862 3,903,025 11,131,498 - -5.29% Contingency/Reserves - - 6,315 6,315 - - - -100.00% Total 8,974,147 8,574,304 11,702,829 11,760,177 3,903,025 11,131,498 - -5.35% Total Full-Time Equivalent Employees 23.6 24.0 25.0 25.0 23.0 25.0 - (without seasonal and temporary) 5 Program Summaries City of Arden Hills Function Summary General Government Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Personal Services 473,372 500,464 605,461 605,461 245,237 587,425 - -2.98% Materials and supplies 31,354 34,246 31,795 31,795 19,677 33,795 - 6.29% Other services and charges 1,197,269 869,006 1,586,248 1,586,248 333,426 694,106 - -56.24% Total operating expenses 1,701,995 1,403,716 2,223,504 2,223,504 598,340 1,315,326 - -40.84% Capital Outlay 70,731 47,430 4,000 4,000 - 3,000 - -25.00% Fund Total 1,772,725 1,451,146 2,227,504 2,227,504 598,340 1,318,326 - -40.82% Total Full-Time Equivalent Employees 6.6 7.1 6.8 6.8 5.1 6.1 (without seasonal and temporary) Departments Mayor and Council 41100 Elections 41410 Administration 41300 Finance&Support Services 41500 Planning and Zoning 41910 Government Buildings 41940 TCAAP 41600 Cable 41960 Risk Management 41980 • City of Arden Hills Function Summary Public Safety Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Personal Services 178,861 182,890 206,965 206,965 95,905 215,262 - 4.01% Materials and supplies 2,061 2,531 4,200 4,200 1,540 3,200 - -23.81% Other services and charges 1,137,084 1,235,367 1,282,491 1,339,839 823,991 1,375,675 - 2.67% Total operating expenses 1,318,005 1,420,788 1,493,656 1,551,004 921,435 1,594,137 2.78% Capital Outlay 27,266 168,144 103,935 103,935 58,161 131,496 - 26.52% 1 Program Total 1,345,272 1,588,932 1,597,591 1,654,939 979,596 1,725,633 - 4.27% Total Full-Time Equivalent Employees 2.5 2.7 2.7 2.7 2.7 2.7 (without seasonal and temporary) Sub-Functions: Public Safety 42100 Emergency Management 42300 Protective Inspections 42400 Public Safety Capital 48120 8 m. City of Arden Hills Function Summary Public Works Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/09 FY 2010 FY 2010 09 vs 10 Personal Services 793,976 822,569 856,817 856,817 376,176 923,897 - 7.83% Materials and supplies 97,640 125,469 193,490 193,490 71,470 193,490 - 0.00% Other services and charges 2,325,836 2,428,839 2,769,684 2,769,684 902,070 2,877,874 - 3.91% Total operating expenses 3,217,451 3,376,877 3,819,991 3,819,991 1,349,716 3,995,261 - 4.59% Capital Outlay 981,995 121,027 2,338,990 2,338,990 179,412 1,848,250 - -20.98% Program Total 4,199,446 3,497,904 6,158,981 6,158,981 1,529,128 5,843,511 - -5.12% Total Full-Time Equivalent Employees 10.4 10.3 10.8 10.8 10.6 11.5 (without seasonal and temporary) Sub-Functions: Streets Maintenance 43100 Capital Improvement(PIR) 48500 Water Utility 49440 Sanitary Sewer Utility 49490 Recycling 49520 Surface Water Management 49550 9 City of Arden Hills Function Summary Parks and Recreation Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/09 FY 2010 FY 2010 09 vs 10 Personal Services 325,515 373,065 412,666 412,666 182,465 418,360 - 1.38% Materials and supplies 37,462 57,367 68,255 68,255 38,316 71,255 - 4.40% Other services and charges 139,017 126,382 141,672 141,672 37,576 143,672 - 1.41% Total operating expenses 501,993 556,814 622,593 622,593 258,356 633,287 - 1.72% Capital Outlay 9,934 110,932 161,895 161,895 29,059 602,991 - 272.46% Program Total 511,928 667,746 784,488 784,488 287,416 1,236,278 - 57.59% Total Full-Time Equivalent Employees 3.8 3.9 4.7 4.7 4.5 4.7 (without seasonal and temporary) Sub-Function: Parks Maintenance 45200 Recreation 45120 Park Capital 45200 10 City of Arden Hills Function Summary Economic Development Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/09 FY 2010 FY 2010 09 vs 10 Personal Services 32,331 - - - - - - #DIV/0! Materials and supplies - 15 3,000 3,000 977 3,000 - 0.00% Other services and charges 96,379 43,361 53,000 53,000 1,217 11,000 - -79.25% Total operating expenses 128,710 43,376 56,000 56,000 2,194 14,000 - -75.00% Capital Outlay - - 10,000 10,000 - 10,000 - 0.00% Program Total 128,710 43,376 66,000 66,000 2,194 24,000 - -63.64% Total Full-Time Equivalent Employees 0.3 0 0 0 0 0 (without seasonal and temporary) Sub-Functions: EDA General 47300 EDA Revoloving 47306 EDA TIF Distr#2 47307 EDA TIF Dist#3 47305 11 City of Arden Hills Function Summary Debt Service Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/09 FY 2010 FY 2010 09 vs 10 Bond Principal 215,000 220,000 225,000 225,000 225,000 235,000 - 4.44% Bond Interest 66,175 59,650 52,975 52,975 28,175 46,075 - -13.03% Fiscal Agents'Fees 450 450 500 500 - 500 - 0.00% Issuance Costs - - - - - - - #DIV/0! Total debt service 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Program Total 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Sub-Functions: GO Tax Increment Bonds 1998A 47010 12 City of Arden Hills Function Summary Transfers Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Program Total 734,441 1,045,100 583,475 583,475 253,175 702,175 - 20.34% Sub-Functions: General Fund Transfers 49300 Community Services 45300 Public Safety Capital 48120 EDA TIF#2 47307 13 General Fund City of Arden Hills • General Fund Summary • Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/09 FY 2010 FY 2010 09 vs 10 Operating Expenses Mayor&Council $ 59,044 $ 54,609 $ 79,386 $ 79,386 $ 34,569 $ 94,386 $ - 18.90% Elections 12,813 20,288 1,010 1,010 1,641 12,600 - 1147.52% Administration 421,277 342,265 388,879 388,879 146,203 380,687 - -2.11% Finance&Support Services 70,741 124,705 142,832 142,832 76,824 143,816 - 0.69% Planning&Zoning 174,439 219,379 256,128 256,128 79,517 261,715 - 2.18% Government Buildings 365,524 186,179 240,106 240,106 49,189 240,882 - 0.32% Public Safety 1,101,524 1.197,337 1,217,766 1,275,114 806,622 1,308,900 - 2.65% Emergency Mangement - 7,131 32,746 32,746 2,736 32,943 - 0.60% Protective Inspections 216,482 216,320 243,144 243,144 112,076 252,294 - 3.76% Street Maintenance 246,530 265,409 282,719 282,719 123,727 287,396 - 1.65% Park Maintenance 281,976 351,958 407,636 407,636 171,543 416,771 - 2.24% Recreation 220,018 204,856 214,957 214,957 86,813 216,516 - 0.73% Reserves/Contingency - - 6,315 6,315 - - - -100.00% Transfers 387,816 700,000 255,000 255,000 - 252,600 - -0.94% Total Operating Expenses 3,558,183 3,890,436 3,768,624 3,825,972 1,691,461 3,901,506 - 1.97% Capital Outlay Mayor 8 Council 1,657 - - - - - - #O1V/0! Elections - - - - - - - #0tV/0! Administration 5,379 1,919 - - - - - #DIV/0! Finance - - - - - - - #DIV/0! Planning&Zoning 1,927 1,037 - - - - - #DIV/0! Government Buildings 7,691 5,208 - - - - - #OIV/0! Public Safety - 949 - - - - - #01V/0! Emergency Mangement - 3,593 - - - - - #DIV/0! Protective Inspections 1,613 1,047 - - - - - #DIV/0! Street Maintenance 3,700 387 - - - - - #0IV/0! Park Maintenance 5,364 387 - - - - - #O1V/0! Recreation - - - - - - - #01V/01 Transfers - - - - - - - #OIV/0! Total Capital Outlay 27,332 14,527 - - - - - #OIV/0! Total General Fund $ 3,585,514 $ 3,904,963 $ 3,768,624 $ 3,825,972 $ 1,691,461 $ 3,901,506 $ - 1.97% City of Arden Hills General Fund Summary Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Operating Revenue Mayor&Council $ - $ - $ - $ - $ - $ - $ - #DIV/0! Elections 256 - - - - - - #O1V/0! Administration 2,843,553 2,971,271 3,171,089 3,171,089 1,568,430 3,264,140 - 2.93% Finance - 27,662 31,357 31,357 - 40,307 - 28.54% Planning&Zoning 158,241 51,363 56,250 56,250 22,330 62,600 - 11.29% Government Buildings 560,145 77,815 92,937 92,937 147 95,319 - 2.56% Public Safety 70,477 76,396 80,200 80,200 11,219 85.641 - 6.78% Emergency Mangement - - - - - - - #0IV/0! Protective Inspections 322,467 189,825 193,300 193,300 80,756 193,300 - 0.00% Street Maintenance 64,683 65,134 64,450 64,450 34,020 68,199 - 5.82% Park Maintenance 3,066 2,659 3,500 3,500 1,801 3,500 - 0.00% Recreation 86,846 91,634 89,000 89,000 64,303 88,500 - -0.56% Transfers - - - - - - - #OIV/0! Total Operating Revenues 4,109,735 3,553,759 3,782,083 3,782,083 1,783,005 3,901,506 - 3.16% Other Financing Sources Mayor&Council - - - - - - - #DIV/0! Elections - - - - - - - #01V/0! Administration - - - - - - - #DIV/0! Finance - - - - - - - #DIV/01 Planning&Zoning - - - - - - - #01V/01 Government Buildings - - - - - - - #DlV/O! Public Safety - - - - - - - #01V/0! Emergency Mangement - - - - - - - #DIV/0! Protective Inspections - - - - - - - #OIV/0! Street Maintenance - - - - - - - #0IV/0! Park Maintenance - - - - - - - #01V/0! Recreation 39,000 - - - - - - #01V/0! Transfers - - - - - - - #DIV/0! Total Other Financing Sources 39,000 - - - - - - #01V/01 Total General Fund $ 4,148,735 $ 3,553,759 $ 3,782,083 $ 3,782,083 $ 1,783,005 $ 3,901,506 $ - 3.16% 15 City of Arden Hills Revenue Summary General Fund Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Taxes 2,610,563 2,703,447 2,963,146 2,963,146 1,494,369 3,117,971 - 5.23% Licenses and Permits 365,185 228,776 241,800 241,800 118,771 247,900 - 2.52% Intergovernmental Revenues 177,289 145,278 113,179 113,179 33,825 55,054 - -51.36% Charges for Services 343,179 355,337 378,908 378,908 125,826 389,990 - 2.92% Fines&Forfeits 28,653 30,189 34,000 34,000 11,019 39,441 - 16.00% Miscellaneous 584,865 90,732 51,050 51,050 (805) 51,150 - 0.20% Total operating revenues 4,109,735 3,553,759 3,782,083 3,782,083 1,783,005 3,901,506 - 3.16% Other Financing Sources 39,000 - - - - - - #DIV/0! Transfers - - - - - - - #DIV/0! Fund Total 4,148,735 3,553,759 3,782,083 3,782,083 1,783,005 3,901,506 - 3.16% Departments Mayor and Council 41100 Elections 41410 Administration 41300 Finance&Support Services 41500 Planning and Zoning 41910 Government Buildings 41940 Public Safety 42100 Emergency Management 42300 Protective Inspections 42400 Street Maintenance 43100 Park Maintenance 45200 Recreation 45120 Transfers 49300 Reserves/Contingency 16 City of Arden Hills Expenditure Summary 1 General Fund Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Personal Services 1,092,167 1,139,518 1,348,079 1,348,079 584,732 1,358,932 - 0.81% Materials and supplies 117,040 159,013 174,005 174,005 90,237 178,005 - 2.30% Other services and charges 1,961,159 1,891,905 1,985,225 2,042,573 1,016,493 2,111,969 - 3.40% Total operating expenses 3,170,367 3,190,436 3,507,309 3,564,657 1,691,461 3,648,906 - 2.36% Capital Outlay 27,332 14,527 - - - - - #DIVIO! Transfers 387,816 700,000 255,000 255,000 - 252,600 - -0.94% Contingency/Reserves - - 6,315 6,315 - - - -100.00% Fund Total 3,585,514 3,904,963 3,768,624 3,825,972 1,691,461 3,901,506 - 1.97% Total Full-Time Equivalent Employees 14.4 14 15.6 15.6 14.4 15.1 (without seasonal and temporary) Departments Mayor and Council 41100 Elections 41410 Administration 41300 Finance&Support Services 41500 Planning and Zoning 41910 Government Buildings 41940 Public Safety 42100 Emergency Management 42300 Protective Inspections 42400 Street Maintenance 43100 Park Maintenance 45200 Recreation 45120 Transfers 49300 Reserves/Contingency 17 City of Arden Hills 2010 Budget Function: General Government Department:Mayor&Council Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 10 vs 09 Total Personal Services 17,655 17,690 31,186 31,186 15,620 31,186 - 0.00% Total Materials and Supplies 1,023 - 500 500 - 500 - 0.00% Other Services and Charges 40,366 36,919 47,700 47,700 18,948 62,700 - 31.45% Total Operating Expenses 59,044 54,609 79,386 79,386 34,569 94,386 - 18.90% Total Capital 1,657 - - - - - - #DIV/0! Department Total $ 60,701 $ 54,609 $ 79,386 $ 79,386 $ 34,569 $ 94,386 $ - 18.90% Funding Source: General Fund 18 City of Arden Hills 2010 Budget Function: General Government Department:Elections Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 10 vs 09 Total Personal Services 11,169 15,326 - - - 8,000 - #DIV/0! Total Materials and Supplies 1,026 1,796 - - - 500 - #DIV/0! Other Services and Charges 618 3,166 1,010 1,010 1,641 4,100 - 305.94% Total Operating Expenses 12,813 20,288 1,010 1,010 1,641 12,600 - 1147.52% Total Capital - - - - - - - #DIV/0! Department Total $ 12,813 $ 20,288 $ 1,010 $ 1,010 $ 1,641 $ 12,600 $ - 1147.52% Funding Source: General Fund 19 City of Arden Hills 2010 Budget Function: General Government Department: Administration Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 10 vs 09 Total Personal Services 210,142 181,195 260,199 260,199 88,983 243,087 - -6.58% Total Materials and Supplies 24,530 973 - - 1,009 - - #DIV/0! Total Operating Expenses 421,277 342,265 388,879 388,879 146,203 380,687 - -2.11% Capital Outlay 101-41300-45400 Equipment 3,344 - - #DIV/0! 101-41300-45700 Office Equip 8 Furnishings 2,035 1,919 - - #DIV/0! Total Capital 5,379 1,919 - - - - - #DIV/0! Department Total $ 426,656 $ 344,184 $ 388,879 $ 388,879 $ 146,203 $ 380,687 $ - -2.11% Funding Source: General Fund 20 r n Hills City of A de 2010 Budget Function: General Government Department: Finance&Support Services Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 44,198 60,135 72,065 72,065 36,739 67,049 - -6.96% Total Materials and Supplies - 22,942 22,995 22,995 16,459 24,495 - 6.52% Other Services and Charges 26,542 41,628 47,772 47,772 23,627 52,272 - 9.42% Total Operating Expenses 70,741 124,705 142,832 142,832 76,824 143,816 - 0.69% Total Capital - - - - - - - #DIV/01 Department Total $ 70,741 $ 124,705 $ 142,832 $142,832 $ 76,824 $ 143,816 $ - 0.69% Funding Source: General Fund 21 City of Arden Hills 2010 Budget Function: General Government Department: Planning&Zoning Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 108,330 109,723 158,828 158,828 73,053 164,365 - 3.49% Total Materials and Supplies 903 1,778 1,300 1,300 500 1,300 - 0.00 Other Services and Charges 65,207 107,878 96,000 96,000 5,964 96,050 - 0.05% Total Operating Expenses 174,439 219,379 256,128 256,128 79,517 261,715 - 2 18 Total Capital 1,927 1,037 - - - - - #DIV/0I Department Total $ 176,366 220,416 $ 256,128 $256,128 $ 79,517 $ 261,715 $ - 2.18% Funding Source: General Fund 22 City of Arden Hills 2010 Budget Function:General Government Department: Government Buildings Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 32,843 32,417 33,456 33,456 14,523 34,232 - 2.32% Total Materials and Supplies 1,731 6,757 7,000 7,000 1,710 7,000 - 0.00% Other Services and Charges 330,951 147,005 199,650 199,650 32,956 199,650 - 0.00% Total Operating Expenses 365,524 186,179 240,106 240,106 49,189 240,882 - 0.32% Total Capital 7,691 5,208 - - - - - #DIV/01 Department Total $ 373,215 $ 191,387 $ 240,106 $ 240,106 $ 49,189 $ 240,882 $ - 0.32% Funding Source: General Fund 23 City of Arden Hills 2010 Budget Function:Public Safety Department: Public Safety Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Other Services and Charges 1,101,524 1,197,337 1,217,766 1,275,114 806,622 1,308,900 - 2.65% Total Operating Expenses 1,101,524 1,197,337 1,217,766 1,275,114 806,622 1,308,900 - 2.65% Total Capital - 949 - - - - - #DIV/01 Department Total $1,101,524 $1,198,286 $1,217,766 $1,275,114 $ 806,622 $1,308,900 $ - 2.65% Funding Source: General Fund 24 City of Arden Hills 2010 Budget Function: Public Safety Department: Emergency Management Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services - 4,890 5,096 5,096 2,397 5,293 - 3.87% Total Materials and Supplies - - - - - - - #DIV/0! Other Services and Charges - 2,241 27,650 27,650 339 27,650 - 0.00% Total Operating Expenses - 7,131 32,746 32,746 2,736 32,943 - 0.60% Total Capital - 3,593 - - - - - #DIV/Ol Department Total $ - $ 10,724 $ 32,746 $ 32,746 $ 2,736 $ 32,943 $ - 0.60% Funding Source: General Fund 25 City of Arden Hills 2010 Budget Function: Public Safety Department: Protective Inspections Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 178,861 178,000 201,869 201,869 93,508 209,969 - 4.01% Total Materials and Supplies 2,061 2,531 4,200 4,200 1,540 3,200 - -23.81% Other Services and Charges 35,560 35,789 37,075 37,075 17,029 39,125 - 5.53% Total Operating Expenses 216,482 216,320 243,144 243,144 112,076 252,294 - 3.76% Total Capital 1,613 1,047 - - - - - #DIV/0! Department Total $ 218,095 $ 217,367 $ 243,144 $243,144 $ 112,076 $ 252,294 $ - 3.76% Funding Source: General Fund 26 City of Arden Hills 2010 Budget Function:Public Works Department: Street Maintenance Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 163,456 167,077 172,714 172,714 77,444 177,391 - 2.71% Total Materials and Supplies 48,304 64,869 69,755 69,755 30,704 69,755 - 0.00% Other Services and Charges 34,770 33,463 40,250 40,250 15,579 40,250 - 0.00% Total Operating Expenses 246,530 265,409 282,719 282,719 123,727 287,396 - 1.65% Total Capital 3,700 387 - - - - - #DIV/0! Department Total $ 250,230 $ 265,796 $ 282,719 $282,719 $ 123,727 $ 287,396 $ - 1.65% Funding Source: General Fund 27 City of Arden Hills 2010 Budget Function:Parks and Recreation Department Park Maintenance Appropriation Detail • Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 164,282 234,820 265,534 265,534 122,256 271,669 - 2.31% Total Materials and Supplies 23,537 41,573 51,980 51,980 29,001 54,980 - 5.77% Other Services and Charges 94,157 75,565 90,122 90,122 20,287 90,122 - 0.00% Total Operating Expenses 281,976 351,958 407,636 407,636 171,543 416,771 - 2.24% Total Capital 5,364 387 - - - - - #DIV/0! Department Total $ 287,340 $ 352,345 $ 407,636 $407,636 $ 171,543 $ 416,771 $ - 2.24% Funding Source: General Fund 28 City of Arden Hills 2010 Budget Function- Parks and Recreation Department: Recreation Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 161,232 138,245 147,132 147,132 60,209 146,691 - -0.30% Total Materials and Supplies 13,925 15,794 16,275 16,275 9,315 16,275 - 0.00% Other Services and Charges 44,860 50,817 51,550 51,550 17,289 53,550 - 3.88% Total Operating Expenses 220,018 204,856 214,957 214,957 86,813 216,516 - 0.73% Total Capital - - - - - - - #DIV/0! Department Total $ 220,018 $ 204,856 $ 214,957 $214,957 $ 86,813 $ 216,516 $ - 0.73% Funding Source: General Fund 29 City of Arden Hills 2010 Budget Function: General Government Department: Transfers Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Operating Transfers 101-49300-47212 Transfer to Storm Water Mgmt $ - #DIV/0! 101-49300-47213 Transfer to Park Fund - #DIV/0! 101-49300-47214 Transfer to EDA General Fund 15,000 15,000 12,600 -16.00% 101-49300-47242 Transfer to Equipment Fund 500000 40,000 40,000 40,000 0.00% 101-49300-47243 Transfer to Public Safety Capital 140,862 - #DIV/0! 101-49300-47260 Transfer to PIR 246,954 200000 200,000 200,000 200,000 0.00% 101-49300-47285 Transfer to Debt Service - #DIV/0! Total Operating Transfers 387,816 700,000 255,000 255,000 - 252,600 - -0.94% Department Total $ 387,816 $ 700,000 $ 255,000 $ 255,000 $ - $ 252,600 $ - -0.94% Funding Source: General Fund 30 City of Arden Hills 2010 Budget Function: General Government Department: Reserves/Contingency Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2010 6/30/2009 FY 2010 FY 2010 09 vs 10 Reserves Contingency - 6,315 6,315 -100.00% Department Total $ - $ - $ 6,315 $ 6,315 $ - $ - $ - -100.00% Funding Source: General Fund Contingency for unforeseen expenses 31 Special Revenue Fund City of Arden Hills Special Revenue Fund Summary Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Operating Expenses TCAAP $ 535,322 $ 383,561 $ 1,009,009 $1,009,009 $ 170,793 $ 70,000 $ - -93.06% Cable Fund 54,755 65,894 79,154 79,154 35,029 84,240 - 6.43% Risk Management 8,080 6,836 27,000 27,000 4,575 27,000 - 0.00% Park Fund 2,471 23,224 - - 3,322 15,000 - #DIV/0! Community Services 65,000 65,000 50,000 50,000 - 25,000 - -50.00% EDA General Fund 86,669 469 10,500 10,500 1,822 11,700 - 11.43% EDA TIF Dist#3 Cottage Villas 41,485 42,359 44,200 44,200 186 1,000 - -97.74% - EDA Revolving Fund - - #DIV/0! - - EDA TIF Dist#2 Round Lake 556 548 1,300 1,300 186 1,300 - 0.00% Total Operating Expenses 794,337 587,891 1,221,163 1,221,163 215,913 235,240 - -80.74% Capital Outlay TCAAP 6,568 - - - - - #DIV/0! Cable Fund 47,508 39,266 4,000 4.000 - 3,000 - -25.00% Risk Management - - - - - - #DIV/0! Park Fund 2,100 87,321 161,895 161,895 25,737 587,991 263.19% Community Services - - - #DIV/0! EDA General Fund - - 10,000 10,000 - 10,000 0.00% EDA TIF Dist#3 Cottage Villas - - - - - - - #DIV/0! - EDA Revolving - - - - #DIV/0! Fund - - EDA TIF Dist#2 Round Lake - - - - - - - #D!V/0! Total Capital Outlay 56,176 126,587 175,895 175,895 25,737 600,991 - 241.68% Other Finance Uses _ - - - - #DIV/0! TCAAP - _ - - - - - - #DIV/0! Cable Fund - - - - #DIV/0! Risk Management - - _ _ - - - - - #DIV/o! Park Fund _ _ Community Services - - #DIV/0! EDA General Fund - - - - - #ON/0! EDA TIF Dist#3 Cottage Villas - - - - - - - #DIV/0! EDA Revolving Fund - - - - - - - #DIV/0! EDA TIF Dist#2 Round Lake 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Total Other Financing Uses 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Total Special Revenue Funds $ 1,132,139 $ 994,578 $ 1,675,533 $1,675,533 $ 494,826 $ 1,117,806 $ - -33.29% City of Arden Hills Special Revenue Fund Summary Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Operating Revenue TCAAP $ 751,349 $ 407,119 $ 1,001,000 $1,001,000 $ (322,455) $ 70,000 $ - -93.01% Cable Fund 87,233 70,810 83,000 83,000 41,399 83,000 - 0,00% Risk Management 26,778 22,799 10,000 10,000 5,461 15,000 - 50.00% Park Fund 32,707 20,628 204,000 204,000 (7) 539,126 164.28% Community Services 60,649 30,781 50,500 50,500 24,027 50,000 - -0.99% EDA General Fund 103,393 4,754 5,000 5,000 9,117 9,100 82.00% EDA TIF Dist#3 Cottage Villas 50,171 50,592 51,000 51,000 19.557 - - -100.00% EDA Revolving Fund 6,298 5,903 5,000 5,000 366 4,000 - -20.00% EDA TIF Dist#2 Round Lake 444,555 478,771 435,000 435,000 246,233 435,000 - 0.00% Total Operating Revenues 1,563,133 1,092,157 1,844,500 1,844,500 23,698 1,205,226 - -34.66% Other Financing Sources - - - - - #DIV/O! TCAA - - - Cable " Cable Fund - - - - - _ _ - #DIV/0! Risk Management - - - _ - - #DIV/0! Park Fund - Community Services - - - - - #DNl0! EDA General Fund - - 25,000 25,000 - 12,600 -49.60% EDA TIF Dist#3 Cottage Villas - - - - - - - #DIV/0! EDA Revolving Fund - - - - - - - #DN/0! - #DIV/0! EDA TIF Dist#2 Round Lake - - - Total Other Financing Sources - - 25,000 25,000 - 12,600 - -49.60% Total Special Revenue Funds $ 1,563,133 $ 1,092,157 $ 1,869,500 $1,869,500 $ 23,698 $ 1,217,826 $ - -34,86% 33 City of Arden Hills 2010 Budget Function: General Government Department:TCAAP Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Miscellaneous 229-41600-36210 Interest Earnings 1,296 1289 1,000 1,000 -100.00% 229-41600-36230 Contributions/Donations/Grants - 70,000 #DIV/0! 229-41600-36240 Developer Reimbursements 750,053 405830 1,000,000 1,000,000 (322,455) -100.00% Total Miscellaneous 751,349 407,119 1,001,000 1,001,000 (322,455) 70,000 - -93.01% Total Operating Revenues 751,349 407,119 1,001,000 1,001,000 (322,455) 70,000 - -93.01% Other Financing Sources 229-41600-39101 Sales of General Fixed Assets - #DIV/01 229-41600-39203 Transfer - #DIV/0! Total Other Financing Sources - - - - - - - #DIV/0! Department Total $ 751,349 $ 407,119 $ 1,001,000 $1,001,000 $ (322,455) $ 70,000 $ - -93.01% Funding Source: TCAAP Fund 34 City of Arden Hills 2010 Budget Function:General Government Department TCAAP Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 21,658 57,682 12,947 12,947 5,105 - - -100.00% Total Materials and Supplies 15 - - - - - - #DIV/0! Other Services and Charges 513,649 325,879 996,062 996,062 165,688 70,000 - -92.97% Total Operating Expenses 535,322 383,561 1,009,009 1,009,009 170,793 70,000 - -93.06% Total Capital 6,568 - - - - - - #DIV/0! Department Total $ 541,890 $ 383,561 $ 1,009,009 $1,009,009 $ 170,793 $ 70,000 $ - -93.06% Funding Source: TCAAP Fund 35 City of Arden Hills 2010 Budget Function: General Government Department:Cable Fund Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Taxes 228-41960-31810 Franchise Taxes 75,620 60520 76,000 76,000 40,917 76,000 0.00% Other Intergovernmental 75,620 60,520 76,000 76,000 40,917 76,000 - 0.00% Miscellaneous 228-41960-36210 Interest Earnings 11,613 10290 7,000 7,000 482 7,000 0.00% Total Miscellaneous 11,613 10,290 7,000 7,000 482 7,000 - 0.00% Total Operating Revenues 87,233 70,810 83,000 83,000 41,399 83,000 - 0.00% Other Financing Sources 228-41960-39101 Sales of General Fixed Assets - #DIV/0! 228-41960-39203 Transfer - #DIV/0! Total Other Financing Sources - - - - - - - #DIV/0! Department Total $ 87,233 $ 70,810 $ 83,000 $ 83,000 $ 41,399 $ 83,000 $ - 0.00% Funding Source: Cable Fund 36 City of Arden Hills 2010 Budget Function: General Government Department Cable Fund Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 27,378 26,296 36,780 36,780 11,213 39,506 - 7.41% Total Materials and Supplies 2,126 - - - - - - #DIV/0! Other Services and Charges 25,251 39,598 42,374 42,374 23,816 44,734 - 5.57% Total Operating Expenses 54,755 65,894 79,154 79,154 35,029 84,240 - 6.43% Total Capital 47,508 39,266 4,000 4,000 - 3,000 - -25.00% Department Total $ 102,263 $ 105,160 $ 83,154 $ 83,154 $ 35,029 $ 87,240 $ - 4.91% Funding Source: Cable Fund 37 City of Arden Hills 2010 Budget Function: General Government Department Risk Management Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Miscellaneous 230-41980-36210 Interest Earnings 13,922 13336 10,000 10,000 827 10,000 0.00% 230-41980-36260 Insurance Dividend 12,856 6666 - 4,634 5,000 #DIV/01 230-41980-36260 Insurance Loss Proceeds 2797 - - #DIV/0! Total Miscellaneous 26.778 22,799 10,000 10,000 5,461 15,000 - 50.00% Total Operating Revenues 26,778 22.799 10,000 10,000 5,461 15,000 - 50.00% Other Financing Sources 230-41980-39101 Sales of General Fixed Assets - #DIV/0! 230-41980-39203 Transfer - #DIV/0! Total Other Financing Sources - - - - - - - #DIV/0! Department Total $ 26,778 $ 22,799 $ 10,000 $ 10,000 $ 5,461 $ 15,000 $ - 50.00% Funding Source: Risk Management Fund 38 City of Arden Hills 2010 Budget Function: General Government Department, Risk Management Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Other Services and Charges 8,080 6,836 27,000 27,000 4,575 27,000 - 0.00% Total Operating Expenses 8,080 6,836 27,000 27,000 4,575 27,000 - 0.00% Department Total $ 8,080 $ 6,836 $ 27,000 $ 27,000 $ 4,575 $ 27,000 $ - 0.00% Funding Source: Risk Mangement 39 City of Arden Hills 2010 Budget Function: Parks and Recreation Department:Park Fund Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Intergovernmental Revenues 227-45200-3xxxx State Aid Funds - 463,326 #DIV/0! 227-45200-33422 State Grants - - 199,000 199,000 24,000 -87.94% Other Intergovernmental - - 199,000 199,000 - 487,326 - 144.89% Miscellaneous 227-45200-36210 Interest Earnings 8,652 6721 5,000 5,000 (7) 5,000 0.00% 227-45200-36230 Contributions and Donations - 46,800 #DIV/0! 227-45200-36235 Park Dedication Fees 24,055 13907 - #DIV/01 Total Miscellaneous 32,707 20,628 5,000 5,000 (7) 51,800 - 936.00% Total Operating Revenues 32,707 20,628 204,000 204,000 (7) 539,126 - 164.28% Other Financing Sources 227-45200-39101 Sales of General Fixed Assets - #DIV/0! 227-45200-39203 Transfer - #DIV/0! Total Other Financing Sources - - - - - - - #DIV/01 Department Total $ 32,707 $ 20,628 $ 204,000 $ 204,000 $ (7) $ 539,126 $ - 164.28% Funding Source: Park Fund 40 City of Arden Hills 2010 Budget Function: Parks and Recreation Department: Parks Capital Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Other Services and Charges 2,471 23,224 - - 3,322 15,000 - #DIV/01 Total Operating Expenses 2,471 23,224 - - 3,322 15,000 - #DIV/Ol Total Capital 2,100 87,321 161,895 161,895 25,737 587,991 - 263.19% Department Total $ 4,571 $ 110,545 $ 161,895 $161,895 $ 29,059 $ 602,991 $ - 272.46% Funding Source: Parks Fund 41 City of Arden Hills 2010 Budget Function: Park and Recreation Department:Community Services Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Miscellaneous 225-45300-36210 Interest Income 782 407 500 500 2 - -100.00% 225-45300-36230 Contributions/Donations 59,867 30374 50,000 50,000 24,025 50,000 0.00% Total Miscellaneous 60,649 30,781 50,500 50,500 24,027 50,000 - -0.99% Total Operating Revenues 60,649 30,781 50,500 50,500 24,027 50,000 - -0.99% Other Financing Sources 225-45300-39101 Sales of General Fixed Assets - #DIV/0! 225-45300-39203 Transfer - #DIV/0! Total Other Financing Sources - - - - - - - #DIV/0! Department Total $ 60,649 $ 30,781 $ 50,500 $ 50,500 $ 24,027 $ 50,000 $ - -0.99% Funding Source: Community Services Fund 42 City of Arden Hills 2010 Budget Function: Public Safety Department: Community Services Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Operating Transfers 225-42100-47200 Transfer to General Fund $ 39,000 $ - #DIV/0! 225-42100-47212 Transfer to Storm Water Mgmt - #DIV/0! 22 5-421 00-4721 3 Transfer to Park Fund - #DIV/0! 225-42100-47242 Transfer to Capital Equipment - #DIV/0! 225-42100-47243 Transfer to Public Safety Capital 26,000 65000 50,000 50,000 25,000 -50.00% 225-42100-47260 Transfer to PIR - #DIV/0! 225-42100-47285 Transfer to Debt Service - Total Operating Transfers 65,000 65,000 50,000 50,000 - 25,000 - -50.00% Department Total $ 65,000 $ 65,000 $ 50,000 $ 50,000 $ - $ 25,000 $ - -50.00% Funding Source: Community Services 43 City of Arden Hills 2010 Budget Function: Economic Development Department:EDA General Fund Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Taxes 701-47300-31059 Tax Increment Excess 14,003 4744 5,000 5,000 9,109 9,100 82.00% Other Intergovernmental 14,003 4,744 5,000 5,000 9,109 9,100 - 82.00% Intergovernmental 701-47300-33422 Other State Grants and Aids 76,285 0 - #DIV/0! Total Intergovernmental 76,285 - - - - - - #DIV/0! Miscellaneous 701-47300-36210 Interest Earnings 13,105 10 - - 8 - #DIV/0! Total Miscellaneous 13,105 10 - - 8 - - #DIV/0! Total Operating Revenues 103,393 4,754 5,000 5,000 9,117 9,100 - 82.00% Other Financing Sources 701-47300-39101 Sales of General Fixed Assets - #DIV/0! 701-47300-39203 Transfer 25,000 25,000 12,600 -49.60% Total Other Financing Sources - - 25,000 25,000 - 12,600 - -49.60% Department Total $ 103,393 $ 4,754 $ 30,000 $ 30,000 $ 9,117 $ 21,700 $ - Funding Source: EDA General Fund 44 City of Arden Hills 2010 Budget Function: Economic Development Department: EDA General Fund Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 32,331 - - - - - - #DIV/0! Total Materials and Supplies - 15 3,000 3,000 977 3,000 - 0.00% Other Services and Charges 54,338 454 7,500 7,500 844 8,700 - 16.00% Total Operating Expenses 86,669 469 10,500 10,500 1,822 11,700 - 11.43% Total Capital - - 10,000 10,000 - 10,000 - 0.00% Department Total $ 86,669 $ 469 $ 20,500 $ 20,500 $ 1,822 $ 21,700 $ - 5.85% Funding Source: EDA General Fund 45 City of Arden Hills 2010 Budget Function:Economic Development Department:EDA Revolving Fund Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Miscellaneous 702-47306-36210 Interest Earnings 6,298 5903 5,000 5,000 366 4,000 -20.00° #DIV/0! Total Miscellaneous 6,298 5,903 5,000 5,000 366 4,000 - -20.00% Total Operating Revenues 6,298 5,903 5,000 5,000 366 4,000 - -20.00% Other Financing Sources 702-47306-39101 Sales of General Fixed Assets - #DIV/0! 702-47306-39203 Transfer - #DIV/0! Total Other Financing Sources - - - - - - - #DIV/0! Department Total $ 6,298 $ 5,903 $ 5,000 $ 5,000 $ 366 $ 4,000 $ - -20.00% Funding Source: EDA Revolving Fund 46 City of Arden Hills 2010 Budget Function: Economic Development Department:EDA TIF District#3 Cottage Villas Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Taxes 705-47305-31050 Tax Increments 45,477 46456 48,000 48,000 19,371 - -100.00% Total Taxes 45,477 46,456 48,000 48,000 19,371 - - -100.00% Intergovernmental 705-47305-33402 Market Value Homestead Credit 113 10 - #DIV/0! Total Intergovernmental 113 10 - - - - - #DIV/0! Miscellaneous 705-47305-36210 Interest Earnings 4,581 4126 3,000 3,000 186 - -100.00% Total Miscellaneous 4,581 4,126 3,000 3,000 186 - - -100.00% Total Operating Revenues 50,171 50,592 51,000 51,000 19,557 - - -100.00% Other Financing Sources 705-47305-39101 Sales of General Fixed Assets - - #DIV/0! 705-47305-39203 Transfer - - #DIV/0! Total Other Financing Sources - - - - - - - #DIV/0! Department Total $ 50,171 $ 50,592 $ 51,000 $ 51,000 $ 19,557 $ - $ - -100.00% Funding Source: EDA TIF District#3 Cottage Villas 47 City of Arden Hills 2010 Budget Function: Economic Development Department EDA District#3 Cottage Villas Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services - - - - - - - #DIV/0! Total Materials and Supplies - - - - - - - #DIV/0! Other Services and Charges 41,485 42,359 44,200 44,200 186 1,000 - -97.74% Total Operating Expenses 41,485 42,359 44,200 44,200 186 1,000 - -97.74% Total Capital - - - - - - - #DIV/0l Total Other Financing Uses - - - - - - - #DIV/0! Department Total $ 41,485 $ 42,359 $ 44,200 $ 44,200 $ 186 $ 1,000 $ - -97.74% Funding Source: EDA TIF#3 48 City of Arden Hills 1 2010 Budget Function: Economic Development Department:EDA TIF District#2 Round Lake Office Park Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Taxes 704-47307-31050 Tax Increments 424,942 455608 425,000 425,000 243,281 425,000 0.00% Other Intergovernmental 424,942 455,608 425,000 425,000 243,281 425,000 - 0.00% Miscellaneous 704-47307-36210 Interest Earnings 19,613 23163 10,000 10,000 2,952 10,000 0.00% 704-47307-36270 Miscellaneous Reimbursements #DIV/0! Total Miscellaneous 19,613 23,163 10,000 10,000 2,952 10,000 - 0.00% Total Operating Revenues 444,555 478,771 435,000 435,000 246,233 435,000 - 0.00% Other Financing Sources 704-47307-39101 Sales of General Fixed Assets - - #DIV/0! 704-47307-39203 Transfer - #DIV/0! Total Other Financing Sources - - - - - - #DIV/0! Department Total $ 444,555 $ 478,771 $ 435,000 $435,000 $ 246,233 $ 435,000 $ - 0.00% Funding Source: EDA TIF District#2 RL 49 City of Arden Hills 2010 Budget Function: Economic Development Department: EDA District#2 Round Lake Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services - - - - - - - #DIV/0! Total Materials and Supplies - - - - - - - #DIV/0! Other Services and Charges 556 548 1,300 1,300 186 1,300 - 0.00% Total Operating Expenses 556 548 1,300 1,300 186 1,300 - 0.00% Total Capital - - - - - - - #DIV/0! Total Other Financing Uses 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Department Total $ 282,181 280,648 $ 279,775 $279,775 $ 253,361 $ 282,876 $ - 1.11% Funding Source: EDA TIF#2 50 Debt Service Fund City of Arden Hills Debt Service Fund Summary Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Debt Service GO Tax Increment Bonds of 1998A $ 281,625 $ 280,100 $ 278,475 $ 278,475 $ 253,175 $ 281,575 $ - 1.11% Total Operating Expenses 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Other Finance Uses GO Tax Increment Bonds of 1998A - - - - - - - #DIV/0! Total Capital Outlay - - - - - - #DIV/01 Total Debt Service $ 281,625 $ 280,100 $ 278,475 $ 278,475 $ 253,175 $ 281,575 $ - 1.11% City of Arden Hills Debt Service Fund Summary Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Operating Revenue GO Tax Increment Bonds of 1998A $ 42 $ 52 $ - $ - $ (18) $ - $ - #DIV/0! Total Operating Revenues 42 52 - - (18) - - #DIV/0! Other Financing Sources GO Tax Increment Bonds of 1998A 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Total Other Financing Sources 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Total Debt Service $ 281,667 $ 280,152 $ 278,475 $ 278,475 $ 253,157 $ 281,575 $ - 1.11% 51 City of Arden Hills 2010 Budget Function: Debt Service Department GO Tax Increment Bonds of 1998A Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Miscellaneous #DIV/0! 325-47010-36210 Interest Earnings 42 52 - (18) Total Miscellaneous 42 52 - - (18) - - #DIV/0! Total Operating Revenues 42 52 - - (18) - - #DIV/0! Other Financing Sources 325-47010-39310 Bond Proceeds 325-47010-39204 Transfer from TIF#2 281,625 280100 278,475 278,475 253,175 281,575 1.11% Total Other Financing Sources 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Department Total $ 281,667 $ 280,152 $ 278,475 $ 278,475 $ 253,157 $ 281,575 $ - 1.11% Funding Source: GO Tax Increment Bonds of 1998A 52 City of Arden Hills 2010 Budget Function: Debt Service Department: GO Tax Increment Bonds of 1998A Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Debt Service 281,625 280,100 278,475 278,475 253,175 281,575 - 1.11% Total Other Financing Uses - - - - - - - #DIV/0! Department Total $ 281,625 $ 280,100 $ 278,475 $278,475 $ 253,175 $ 281,575 $ - 1 11% Funding Source: TIF Bonds of 1998A Fund 53 City of Arden Hills Capital Fund Summary Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Capital Outlay Equipment,Bldg&Replacement - - 156,068 156,068 50.250 116,400 - -25.42% Public Safety Capital 25,653 162,555 103,935 103,935 58,161 131,496 - 26.52% Capital Improvement Fund(PIR) 939,781 119,866 1,634,250 1,634,250 57,863 723,750 - -55.71% Total Capital Outlay 965,434 282,421 1,894,253 1,894,253 166,274 971,646 - -48.71% Other Finance Uses Equipment,Bldg&Replacement - - - - - - - #DIV/0! Public Safety Capital - - - - - - - #DIV/0! Capital Improvement Fund(PIR) - - - - - - - #DIV/0! Total Other Financing Uses - - - - - - - #DIV/0! Total Capital Funds $ 965,434 $ 282,421 $ 1,894,253 $ 1,894,253 $ 166,274 $ 971,646 $ - -48.71% City of Arden Hills Captial Fund Summary Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Operating Revenue Equipment,Bldg&Replacement $ - $ - $ - $ - $ - $ 10,000 $ - #DIV/0! Public Safety Capital 28,794 25,410 52,000 52,000 981 15,000 - -71.15% Capital Improvement Fund(PIR) 798,748 501,510 372,000 372,000 200,059 827,947 - 122.57% Total Operating Revenues 827,541 526,920 424,000 424,000 201,040 852,947 - 101.17% Other Financing Sources Equipment,Bldg&Replacement - 500,000 204,000 204,000 - 183,000 - -10.29% Public Safety Capital 166,862 65,000 50,000 50,000 - 25,000 - -50.00% Capital Improvement Fund(PIR) 246,954 200,000 200,000 200,000 - 200,000 - 0.00% Total Other Financing Sources 413,816 765,000 454,000 454,000 - 408,000 - -10.13% Total Capital Funds $ 1,241,357 $ 1,291,920 $ 878,000 $ 878,000 $ 201,040 $ 1,260,947 $ - 43.62% 55 City of Arden Hills 2010 Budget Function: General Government Department:Equipment Building and Replacement Fund Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Miscellaneous 408-48100-36210 Interest Earnings - - - - - 10,000 #DIV/0! Total Miscellaneous - - - - - 10,000 - #DIV/01 Total Operating Revenues - - - - - 10,000 - #DIV/0! Other Financing Sources 408-48100-39201 Transfer from General Fund 500,000 50,000 50,000 - 40,000 -20.00% 408-48100-39203 Transfer from Other Funds - 154,000 154,000 - 143,000 -7.14% Total Other Financing Sources - 500,000 204,000 204,000 - 183,000 - -10.29% Department Total $ - $ 500,000 $ 204,000 $ 204,000 $ - $ 193,000 $ - -5.39% Funding Source: Equipment Building and Replacement Fund 56 City of Arden Hills 2010 Budget Function:General Government Department: Equipment Building and Replacement Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Capital - - 156,068 156,068 50,250 116,400 - -25.42% Total Other Financing Uses - - - - - - - #DIV/0! Department Total $ - $ - $ 156,068 $156,068 $ 50,250 $ 116,400 $ - -25.42% Funding Source: Equipment Bldg&Replacement Fund 57 City of Arden Hills 2010 Budget Function: Public Safety Department Public Safety Capital Equipment Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Miscellaneous -100.00% 412-48120-3xxxx State Aid Funds 32,000 32,000 41 2-481 20-3621 0 Interest Earnings 28,794 25410 20,000 20,000 981 15,000 -25.00% Total Miscellaneous 28,794 25,410 52,000 52,000 981 15,000 - -71.15% Total Operating Revenues 28,794 25,410 52,000 52,000 981 15,000 - -71.15% Other Financing Sources DIV/OI 412-48120-39201 Transfer from General Fund 140,862 25 D00 p DIV/ol 41 2-481 20-3920 3 Transfer from Community Servicr 26,000 65000 50,000 50,000 Total Other Financing Sources 166,862 65,000 50,000 50,000 - 25,000 - -50.00% Department Total $ 195,656 $ 90,410 $ 102,000 $ 102,000 $ 981 $ 40,000 $ - -60.78% Funding Source: Public Safety Capital Equipment Fund 58 City of Arden Hills 2010 Budget Function: Public Safety Department Public Safety Capital Equipment Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Capital 25,653 162,555 103,935 103,935 58,161 131,496 - 26.52% Total Other Financing Uses - - - - - - - #DIV/0! Department Total $ 25,653 $ 162,555 $ 103,935 $103,935 $ 58,161 $ 131,496 $ - 26.52% Funding Source: Public Safety Capital Equipment Fund 59 City of Arden Hills 2010 Budget Function: Public Works Department:Capital Improvement Fund Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Taxes 411-48500-31920 Forfeited Tax Sale Appirtionment $ - - $ - #DIV/0! - - #DIV/0! Total Taxes - Intergovernmental Revenues 411-48500-33419 MSA Construction - 202,947 #DIV/0! 411-48500-33610 County Grants and Aids Highways - - #DIV/0! Other Intergovernmental - - - - - 202,947 - #DIV/0! Special Assessments 411-48500-36100 Special Assessments 192,663 200524 147,000 147,000 180,777 400,000 172.11% 411-48500-36101 Delinquent Sp Assessments 36,693 - 1,004 #DIV/0! 411-48500-36102 Penalties and Int Sp Assessment 10,157 150 - 145 #DIV/0! 411-48500-36103 PrePaid Special Assessments 254,473 22480 - - #DIV/0! Total Special Assessments 493,987 223,154 147,000 147,000 181,926 400,000 - 172.11% Miscellaneous 411-48500-36210 Interest Income 302,184 278356 225,000 225,000 18,133 225,000!, 0.00% 411-48500-36210 Interfund Loan Interest - #DIV/0! 411-48500-36280 Miscellaneous 2,577 - - #DIV/0! Total Miscellaneous 304,761 278,356 225,000 225,000 18,133 225,000 - 0.00% Total Operating Revenues 798,748 501,510 372,000 372,000 200,059 827,947 - 122.57% Other Financing Sources 411-48500-39201 Transfer from General Fund 246,954 200000 200,000 200,000 200,000 0.00% 411-48500-39204 Transfer from TIF#2 - #DIV/0! Total Other Financing Sources 246,954 200,000 200,000 200,000 - 200,000 - 0.00% Department Total $ 1,045,702 $ 701,510 $ 572,000 $ 572,000 $ 200,059 $1,027,947 $ - 79.71% Funding Source: Capital Improvement Fund 60 Capital Fund City of Arden Hills 2010 Budget Function: Public Works Department: Pavement Mgmt Programs Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Materials and Supplies 167 - - - - - - #DIV/0! Other Services and Charges 245,782 124,971 - - 57,790 - - #DIV/0! Total Operating Expenses 245,949 124,971 - - 57,790 - - #DIV/0! Total Capital 693,832 (5,105) 1,634,250 1,634,250 74 723,750 - -55.71% Total Other Financing Uses - - - - - - - #D1V/0! Department Total $ 939.781 $ 119,866 $1,634,250 $1,634,250 $ 57,863 $ 723,750 $ - -55.71% Funding Source: Capital Improvement Fund 61 Enterprise Fund City of Arden Hills 2010 Budget Function: Public Works Department:Water Utility Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Licenses and Permits 2,050 705 1,800 1,800 1,130 1,800 - 0.00% Total Intergovernmental 38,946 - - - - - - #DIV/0! Total Special Assessments 1,722 4,125 350 350 12,657 350 - 0.00% Total Miscellaneous 31,988 33,021 25,000 25,000 212 22,000 - -12.00% Total Charges for Services 1,412,633 1,322,156 1,416,792 1,416,792 497,643 1,651,703 - 16.58% Total Operating Revenues 1,487,339 1,360,007 1,443,942 1,443,942 511,641 1,675,853 - 16.06% 1 Total Other Financing Sources - - - - - - - #DIV/0! Department Total $ 1,487,339 1,360,007 $ 1,443,942 $1,443,942 $ 511,641 $ 1,675,853 $ - 16.06% Funding Source: Water Utility 64 City of Arden Hills 2010 Budget Function: Public Works Department:Sanitary Sewer Utility Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Licenses and Permits 1,105 352 850 850 144 850 - 0.00% Total Special Assessments 1,873 122 400 400 11,916 400 - 0.00% Total Miscellaneous 14,017 18,637 10,000 10,000 (281) 10,000 - 0.00% Total Charges for Services 1,341,739 1,120,714 1,214,950 1,214,950 439,596 1,626,603 - 33.88% Total Operating Revenues 1,358,734 1,139,825 1,226,200 1,226,200 451,376 1,637,853 - 33.57% Total Other Financing Sources - - - - - - - #DIV/0! Department Total $ 1,358,734 1,139,825 $ 1,226,200 $1,226,200 $ 451,376 $ 1,637,853 $ - 33.57% Funding Source: Sanitary Sewer Utility 66 City of Arden Hills 2010 Budget Function: Public Works Department: Water Utility Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 242,213 243,638 258,825 258,825 114,189 257,461 - -0.53% Total Materials and Supplies 25,795 28,772 71,680 71,680 19,542 71,680 - 0.00% Other Services and Charges 1,193,446 1,362,691 1,429,285 1,429,285 383,190 1,432,685 - 0.24% Total Operating Expenses 1,461,455 1,635,101 1,759,790 1,759,790 516,921 1,761,826 - 0.12% Total Capital 807 387 74,140 74,140 60,170 34,000 - -54.14% Total Other Financing Uses - - 39,500 39,500 - 43,000 - 8.86% Department Total $ 1,462,262 1,635,488 $ 1,873,430 $1,873,430 $ 577,090 $ 1,838,826 $ - -1.85% Funding Source: Water Utility Fund 65 City of Arden Hills 2010 Budget Function:Public Works Department:Sanitary Sewer Utility Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 277,432 297,512 302,713 302,713 131,445 302,214 - -0.16% Total Materials and Supplies 20,799 23,030 35,480 35,480 15,805 35,480 - 0.00% Other Services and Charges 982,257 822,632 1,051,338 1,051,338 415,278 1,088,867 - 3.57% Total Operating Expenses 1,280,488 1,143,174 1,389,531 1,389,531 562,528 1,426,561 - 2.66% Total Capital 37,706 387 216,100 216,100 61,379 635,600 - 194.12% Total Other Financing Uses - - 58,500 58,500 - 62,000 - 5.98% Department Total $ 1,318,194 1,143,561 $ 1,664,131 $1,664,131 $ 623,908 $2,124,161 $ - 27.64% Funding Source: Sanitary Sewer Utility 67 City of Arden Hills 2010 Budget Function: General Government Department:Recycling Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Intergovernmental 18,396 20,301 19,866 19,866 19,866 19,000 - -4.36% Total Special Assessments 231 181 - - 43,252 - - #DIV/0! Total Miscellaneous 1,881 1,704 21,330 21,330 163 50,800 - 138.16% Total Charges for Services 65,996 - 78,208 78,208 - 103,000 - 31.70% Total Operating Revenues 86,505 22,186 119,404 119,404 63,281 172,800 - 44.72% Total Other Financing Sources - - - - - - - #DIV/0! Department Total $ 86,505 22,186 $ 119,404 $ 119,404 $ 63,281 $ 172,800 $ - 44.72% Funding Source: Recycling 68 City of Arden Hills 2010 Budget Function:Public Works Department:Surface Water Management Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Taxes 13,746 - - - - - - #DIV/0! Total Intergovernmental 225,000 - - - - - - #DIV/0! Total Special Assessments 2,821 13 - - 1,334 - - #DIV/01 Total Miscellaneous 7,416 19,293 3,000 3,000 1,941 12,000 - 300.00% Total Charges for Services 455,819 473,843 424,660 424,660 199,306 510,321 - 20.17% Total Operating Revenues 704,801 493,149 427,660 427,660 202,581 522,321 - 22.13% Total Other Financing Sources 13,783 - - - - - - #DIV/01 Department Total $ 718,584 493,149 $ 427,660 $ 427,660 $ 202,581 $ 522,321 $ - 22.13% Funding Source: Surface Water Management 70 City of Arden Hills 2010 Budget Function: Public Works Department:Surface Water Management Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 101,794 104,063 112,114 112,114 48,510 173,353 - 54.62% Total Materials and Supplies 2,742 8,798 16,575 16,575 5,418 16,575 - 0.00% Other Services and Charges 42,860 106,623 140,582 140,582 38,496 156,877 - 11.59% Total Operating Expenses 147,396 219,484 269,271 269,271 92,424 346,805 - 28.79% Total Capital - - 414,500 414,500 - 338,500 - -18.34% Total Other Financing Uses - - 34,500 34,500 - 38,000 - 10.14% Department Total $ 147,396 $ 219,484 $ 718,271 $718,271 $ 92,424 $ 723,305 $ - 0.70% Funding Source: Surface Water Management 71 City of Arden Hills Enterprise Fund Summary Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Operating Expenses Water $ 1,461,455 $ 1,635,101 $ 1,759,790 $ 1,759,790 $ 516,921 $ 1,761,826 $ - 0.12% Sanitary Sewer 1,280,488 1,143,174 1,389,531 1,389,531 562,528 1,426,561 - 2.66% Recycling 81,583 113,709 118,679 118,679 54,115 172,672 - 45.50% Surface Water Management 147,396 219,484 269,271 269,271 92,424 346,805 - 28.79% Total Operating Expenses 2,970,922 3,111,468 3,537,271 3,537,271 1,225,989 3,707,865 - 4.82% Capital Outlay Water 807 387 74,140 74,140 60,170 34,000 - -54.14% Sanitary Sewer 37,706 387 216,100 216,100 61.379 635,600 - 194.12% Recycling - - - - - - - #DIV/0! Surface Water Management - - 414,500 414,500 - 338,500 - -18.34% Total Capital Outlay 38,514 774 704,740 704,740 121,549 1,008,100 - 43.05% Other Finance Uses Water - - 39,500 39,500 - 43,000 - 8.86% Sanitary Sewer - 58,500 58,500 - 62,000 - 5.98% Recycling - - - - - - - #DIV/0! Surface Water Management - - 34,500 34,500 - 38,000 - 10.14% Total Other Financing Uses - - 132,500 132,500 - 143,000 - 7.92% Total Enterprise Funds $ 3,009,435 $ 3,112,242 $ 4,374,511 $ 4,374,511 $ 1,347,538 $ 4,858,965 $ - 11.07% City of Arden Hills Enterprise Fund Summary Actual Actual Budget Amended Actual Proposed Adopted %Change FY 2007 FY 2008 FY 2009 FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Operating Revenue Water $ 1,487,339 $ 1,360,007 $ 1,443,942 $ 1,443,942 $ 511,641 $ 1,675,853 $ - 16.06% Sanitary Sewer 1,358,734 1,139,825 1,226,200 1,226,200 451,376 1,637,853 - 33.57% Recycling 86,505 22,186 119,404 119.404 63,281 172.800 - 44.72% Surface Water Management 704,801 493,149 427,660 427,660 202,581 522,321 - 22.13% Total Operating Revenues 3,637,378 3,015,167 3,217,206 3,217,206 1,228,880 4,008,827 - 24.61% Other Financing Sources Water - #DIV/0! Sanitary Sewer - - - - - - - #DIV/0! Recycling - - - - - - - #DIV/0! Surface Water Management 13,783 - - - - - - #DIV/0! Total Other Financing Sources 13,783 - - - - - - #DIV/0! Prior Period Adjustment(Recycling) - Total Enterprise Funds $ 3,651,161 $ 3,015,167 $ 3,217,206 $ 3,217,206 $ 1,228,880 $ 4,008,827 $ - 24.61% 63 City of Arden Hills 2010 Budget Function:General Government Department:Recycling Appropriation Detail Account Actual Actual Budget Amended Actual Proposed Adopted %Change No. Activity FY 2007 FY 2008 FY_2009 _ FY 2009 6/30/2009 FY 2010 FY 2010 09 vs 10 Total Personal Services 9,081 10,279 10,450 10,450 4,588 13,478 - 28.98% Total Materials and Supplies - - - - - - #DIV/0! Other Services and Charges 72,502 103,430 108,229 108,229 49,528 159,194 - 47.09% Total Operating Expenses 81,583 113,709 118,679 118,679 54,115 172,672 - 45.50% Total Capital - - - - - - - #DIV/0! Total Other Financing Uses - - - - - - - #DIV/0! Department Total $ 81,583 $ 113,709 $ 118,679 $118,679 $ 54,115 $ 172,672 $ - 45.50% Funding Source: Recycling Fund 69 Salary Allocation ��ryypp� 8888 8 8 8 8 8 8 8 888888 8888888 • 8 m m el f O StN �I r r c� m --- Q-O . ..-,.-CIN N pe a me a wwQ �[f e o 888$ 888888• 888888 8888888 0 m 88 88 N. 888 888888 88880 888888r N 88 88 88 0 o 0 o 0 O 0 O O O O O 0 0 08 8 8 8 8 01 8 ` =_8 8 w� 0 w��0 0 0 O 0 O,c Q t e ape op 0 apo ap ap 88e e 0 0 ee po ooe o•- "' 1� a; ' n 0 0 O 0prSS N OSO A 8 8 8• N� M ��N N`1.4 „�i . p N Np c7N . N Y r000 NLs1 CO 0O O'N r 0 N5sT �1.4 O Na Sa e 0 e e e r rO .11 S 0e 9 0.-000\ '^ cp n n void 8 0 g o Up o0o m,^o ,,: U a r p0 66 6 0 O Uo00 O OO ' m ar a,mr X X ‘3 s pp e ee °e e e o eee eer N p.�wilE 0\ '. nn o 0 N�' .r.; O I r 88 N 8§8 88,.. 882 8 S N n 3 O f N N O N N�W y d, o y r 000 NNS 00r NNN 0 N t7 CO 0^ fr y_y', O a'f.-.. 4 eee r e e e eer 0 e e e ee O N ra',�a Ae" rr OON� mi. �88C 888 88� 888 8�N �pIN N;�r oN No NNmA. ; Q r O00 N N O 0pr0 crici NNN �� M � O�. m ' O t`�� ,. 0 e 0 0 0 o o� Oa, g 00000a;- gl 8 8 g-00i 8 Q - 0 o e 0 e O 0 N 0 0 0 Y l 0 0 �mp e e ep i N N N O N - UQr 8880 0 88 8 O O UQIDm NO � O p0 ON r r no pp�' L. ee 0 0 e e e N L. 0\ee 0\\0 00ON0�e m ty n p SSO S 8S f ' 24p2 M OMU,D O —v. , a'`^,JI O �(��J tN•1m R'NOOfg 60 0 l0S 0o 0 0 O e e a ee sj rp ''(VV a N a N N OOI O a Sl N S 0 88 Spp 8 S N ra SIO S O NQ O O N N g m 0 N O N O c N m 0 N a 0 0 p O 0 0 6 Q O e e a e e r 0 e a 0 0 0 r 0 e m8 8 0 8S 0 888 8�° o a8lo� 0o o0 °8� ec 0 v i n O 0 S 06 N r O N O N m m !- I p a e p O O 000OS S O 4% O 8 0 0 O h r O Q pp e 0 e r e e 0 0\° N.0. ..r N 0 % 0� 0 00 8. 8 8 O 88 N•O O a 0f 0 0 0 0 66 0 U' m Q M 0 0 0 V. m r O Q e e e e 38 0 0 0 dr { O mu rd.- r,dp 0 p r p Q Q Opp 8OO N- O OQ�5N aC N rp omv Q O0O N O N dyOO C Q O V o 0 o e o oo c oe o e 000ooa, e.8 0 0 0 ,� 0 8 000 w pp w F. i0 , e e e M e e e 0 L. 0 0,_N cm Aea OOn cr r 8 88 O 8 8 r 8 rn "cy.a do nor ao C 0 0 O 0 N .- C D10t'1 0 0 rr m r O N t0 m m Q a a ao o > 0 e O e 00000 e tgl e o eeo0 0 o gs8 s 8 8 s o ci U Uo p e e e 0 a o e e e e O 0 q r m o ^m N 0^o Q O ^SO 8 m 8 8886 8 0 8ui O N Q m 0 p 8 y m p p O 66 C t� ���OOp�fp0 w r w C yl tL U W cn 0 m U m c m c am o 715 ri y u E m c c 2 Q A .= t o = 0 E H y a t a s o E o o m n 1O w a U a c- 12 8 a 819,271a a g" E .0,0 Hof, LL c c g g 3 7,2 ya (0a 8 5 m y o E c �� o E'E"ya am Q g% EEaacy sna"rn o E c S.E2E3 N vo 0 cc� 00 oovam 7 > >cmma a oa._ om a«3 ITE«UOct, UUmma¢ aaawaaa a ti 0<itoa 73 r��yy9y� 8888 8888888 888888 8888888 8 0 mO6N E, ....Cl O ����00 .-�0.-a-m6 0 —I CV eee8 eee-ee8 eeeee8 eeeeee8 8 ao mew nmv�Nee VI 888 , 88888m 88888 •• 888888N• 1 88 88 88 �I 888 888888 88880 888888— CV88 88 88 e 0 e e e 0 0O O\, . O :::::!: 8 8 8 Sa8 8' 8O O O 0wQ O Ojg e ^ e e e e o N O eea e trm EMO r o 888 880 88N �— � € �Io:.., v0 ��� U) Y O CV CD ON '—N 7 N o N e N e N O O i N N N 0 O N\ 4.i Z r O' 8 8 00 8 O U�OO N OOO `O�Qii i� ON O N N O m Q 0 pp p p p p p p p p p K O) r 8 8 N 8o 8 8 S O S S�y O O N n ;8 ,x O•O N O O N n O , oar �j . OOO Ih M N ��� NNN N N N (oar • !. O orn eoeepeN e oe op��\jN 0 aoa apap. N He rNOON P: QQ� 1�SSN SOS SOS SSO OIL N or h gal CV N, OO 3 N� N N 04 Qj e-O O O M CNJ N N N N m > O I` `i 1� 0 M�'. 0 �e N 0 0 N �SO\, NO� ONOOOOo ' p 8 O O as 00 co m 0 Q N r�_ O ' N p 0 0 e e e e e N e 0 Yl N\ ,,e N N..O N p.t N O O 0 0 t 7 - O M O O O ap Of�)I S S S O S S O 8 O t O O m M � O O O O W 0 00 0 O�� .. 0 v 0 o ,. u) ,n 0 e �e m m�e u)e� tn ono Nu) $ e e o 8 8Q ^ u o n°�8 o M w o ,m o a!71 0 8 S 8 60 m`- a Id 0r m0 0 O� O$ e m V] O o 0 D o e ppO N N o N N O S O $ o o og $88� c mgp 00 0oci 6� 0 CV CO N o aQa SS pe N o eae ao ap�o co 'o� No os O..--om ml 8 Oo S8 0 888 8g °' N m8gCZ. - •O 0O O)�� N.— .6 .0n ` O Nl0 N co. N C N C N O 8 O 888 O O 0 O W O t D Or- O O O o 0 0 S 'n m8o cv LL m o V) e e o e aoN N N m\ mN.-NN Q p O co O 80 S S O 88 N O co °on O o a m 0 O co O o 0 0 co V �m 0 l7 YI N 00 0m0 �((11 p� N e e e 0 0 fofpp N� ,(1 o .m,..Om a? S� r p 8880 88O N 8 OEL8I0� O,'? 00N 8fp a �� O OV NN NON)8 N aCNQ 00 0 0 NO 6' O 0 0 o 0 O C KK O e 0 e 0 0 0 0 8 O m 8 8 O O d t 8 8 8 do N O, ,N N e�M O O O O Y w w co r 8 88 0 8 8 8 o to r g� e �`m'Qor� Ol 0 0 N N 0 ui v) O t7 '() 0 �- CI. > e 0 e e 0 e O o 0 0 > O e o e O o 0 0 o e 3Ev81 8 8 8 8 8 E I 8 8 8 0 d O 0 0 o Q p e¢,�ep,n pepepem e N ep o ripe °°e �rpmNore a0 88S 888' O O O O 5 i§RSei co O mQ!000�N CV LCi q Cu t in m ri m ri U m 0 E m -� Y e �� rnEy n . "E Nt Q c Q a opc�°1 �� d E m oo 2o`>o t ° E m e g a C m C CNN J 9� 17 p C d d as c C N a W .> „ t 5 L] a a c"�m 5 c ,>> — E E C c� N o u t y m g m 5 a n 1 E.g"yp 42 �Q im EE��cy an'n"rn�`u> c o coJ Q,) p LL a-<< 00 E o mm CO J J C W d> .. t ali(..)a aa� � coo ac�mma¢ o aawama a 74