Loading...
HomeMy WebLinkAboutBudget - 2000 - ~ .;Q -.g CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET ~ , 'j , i , ~ / ,. --'-'"1lIo'-""'""- ....._.'..,'-'10..;..__' ........- o o o TABLE OF CONTENTS DEFINITIONS AND PURPOSES SUMMARY OF REVENUES AND EXPENDITURES .............................................................................2 General Fund: General Government City Council............... ......... ................................... ......................... .......................26 Newsletter......................................................................................................... .....29 City Clerk.............................. ................................. .................. ........ ......................31 Elections...... ............................ ........... ................ ...... ................................. ..... ... .....34 Administration......................... .............................. ................ ................................37 Financial Administration......................... ................................................. ........... ..40 Auditing........ .................................... ........................ ............ ...................... .......... .43 Assessing. ... ... ................................... ........... .............................................. ............ .45 Attorney .................................................................................................................47 Community Development/Planning and Zoning ...................................................49 Data Processing......................................................................................................5 3 Government Building:s City Hall Building.... ........... ................................... .................. ..:......... ................. .57 Fire Station.......................................... .............................................................. .....5 8 Public Works Building...........................:................ .............. ............................... ..59 Senior Citizen Center....................... ........ ..............;................................. ....... ....... 60 Equipment Building.......................................................... ..:....................... .... ...... .61 City Hall Garage ............................................................................;...................... .62 Engineering........................................................................................................... .63 Public Safety Police Protection...................... ............................. ................................................ .69 Fire Protection.............................. ...... ................................................................ ....71 Protective Inspection.............................................. .............. ..................................75 Civil Defense .................................. ........................................................ ...............79 Animal Control................................................................ ..................................... .82 Public Works Streets and Highways....... ............ .................. .......................... ........... .................. .86 Snow and Ice Removal........:.................................................................................90 Storm Sewers....................... .................................. .............. ............................... ...93 Street Lighting...................................... .................. ............................... ............... .96 Street Signs...................................... ......................... ....... ......................................98 Traffic Signals... .......... ............................. ................................... .........................101 o o o Public Works. Continued Street Lights _ Billed............................................................................................1 03 Tree Preservation........................................................................................... ......1 05 Weed Control................................................................................ .......................108 Parks and Recreation..................................................................... .......................111 Sunshine Park............................................................................ ................. ......... .115 Recycling ...............................;.............................................................................117 Unallocated UnallocatedlOther ............................. ....... ....... ................................................. ....120 Special Revenue Funds: Economic Development............. ..........................................................................123 Drainage and Mapping............ ............................... ..................................... ........ .127 Lower Rum River ...................... ..........................................................................129 Forestry ............................................................... .................................. .... .......... .132 Septic Disposal.......................................................................... .......................... .13 5 Capital Equipment Reserve.... .................................. ............................. .............. .13 7 Oak Wilt Suppression .................................................... ............................ ..........139 Debt Service Funds: General Obligation Special Assessments...................................;.........................143 General Obligation Tax Increment ......................................................................147 General Obligation Bonds......................... .................... ...................................... .149 Revenue Bonds ....................................................................................................151 CaDital Proiects: Permanent Improvement Revolving .... ................................................................154 EnterDrise: Water............... ........................... ...... ............... .................................................... .157 Sanitary Sewer .............................. ....... ............................................................ ....172 Trust and Al!encv: Central Equipment..................... .... ............................................................... ...... .186 Risk Management ................................................................................................190 o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET CITY OF ANDOVER 12/30/9911 :21 AMREV-EXP.XLS Budget Summary. General Operating Budget Budget Year 2000 0 Actual Actual Actual Budget Budget 1996 1m 1998 1999 2000 REVENUES Property Taxes $ 2,180.470 $ 2,383,965 $ 2,804,065 $ 3,298.518 $ 3,478,505 Ucense and Permits $ 390,327 $ 456,413 $ 694,808 $ 456,821 $ 579,134 Intergovernmental Revenues $ 827,690 $ 988,814 $ 880,697 $ 961,917 $ 941,975 Charges for Current Services $ 447,198 $ 578,221 $ 1,018.441 $ 599,531 $ 780,693 Fines and Forfeits $ 57,125 $ 48.800 $ 48,923 $ 43,500 $ 52,000 Miscellaneous Revenue $ 180,601 $ 258.494 $ 360,738 $ 201 ,400 $ 286,390 Transfers $ 71,000 $ 317,200 $ 464,020 $ 949.423 $ 659,679 EXPENDITURES General Government $ 1,068,575 $ 1,217,720 $ 1,530.239 $ 1,773,880 $ 1,885,233 0 Public Safety 1,290,681 1.409,087 1,579,837 2,012,835 $ 2,017,738 Public Wor1<s 1.460,158 1,562,610 1,608,022 2,542,536 $ 2,707,092 Other 752,263 274.319 1,003,025 181,858 $ 168,312 o o $7,000,000 $6,000,0'00 $5,000,000 $4,000,000 o $3,000,000 .$2,00(},00(} $1,000,000 o CITY OF ANDOVER GENERAL FUND COMPARISON OF REVENUES Previous Five Years and Proposed 2000 Budget $- 1998 1999 2000 1995 1996 1997 -CITY OF ANDOVER GENERAL FUND COMPARISON OF REVENUES WITHOUT PROPERTY TAXES Previous Five Years and Proposed 200() nudget o $3,500,000 $3,000,000 $2,500,000 $2,000,000 o $1,500,000 $1,000,000 $500,000 o $- 1999 2000 1995 1996 1997 1998 CITY OF ANDOVER Summary Of Revenues Budget Year 2000 2000 Property Taxes 50% Licenses & Permits 9% Transfers 10% Charges for Current Services 12% FineslForfeits 1% Intergovernmental Revenues 14% 1999 Property Taxes 50% Licenses & Permits 7% FineslForfeits 1% Transfers 15% Charges for Current Services 9% Intergovernmental Revenues 15% CITY OF ANDOVER 12/30/9911 :22 AMREVSUM.xLS Revenue Budget Summary - General Government Budget Year 2000 0 Actual Actual Actual Budget Budget 1996 1997 1998 1999 2000 Property Taxes $ 2,180.470 $ 2,383.965 $ 2,804,065 $ 3,298,518 $ 3,478,505 License and Permits $ 390,327 $ 456.413 $ 694,808 $ 456,821 $ 579,134 Intergovernmental Revenues $ 827,690 $ 988,814 $ 880,697 $ 961,917 $ 941 ,975 Charges for Current Services $ 447,198 $ 578,221 $ 1,018.441 $ 599,531 $ 780,693 Fines and Forfeits $ 57,125 $ 48,800 $ 48,923 $ 43,500 $ 52,000 Miscellaneous Revenue $ 180,601 $ 258.494 $ 360,738 $ 201 .400 $ 286,390 Transfers $ 71,000 $ 317,200 $ 464,020 $ 949.423 $ 659,679 o o CITY OF ANDOVER Revenue Budget Worksheet Budget Year 2000 12/30/9911 :22 AMGENERAL.XLS ..[ 'I GENERAL FUND Revenue Code Actual 1996 Actual 1997 Actual 1998 Budget 1999 Budget 2000 PrODertv Taxes 31010 Current Ad Valorem Tax $ 1,778,003 $ 1,973,572 $ 2,327,230 $ 2,793,563 $ 2,953,341 31020 Del. Ad Valorem Taxes 23,923 22,894 23,890 20,000 23,000 31040 Fiscal Disparities 359,925 372,653 442,849 465,955 484,564 31910 Pen/lnt. on Ad Valorem 14,395 14,079 8,321 18,000 16,000 31920 Forfeited Tax Sale Apport 4,224 766 1,774 1,000 1,600 :::::'::::::::::::::::i::':::::::ii:::::::::::::j::::::::::::I!tl~~::::::::::::::::::::;:::~:::::.!!:~!.:::i:iiIii&::l:-::;::-:::i:IIl;!!:'!:!:: Licenses and Permits 32110 Liquor - Intoxicating $ 5,100 $ 4,600 $ 4,600 $ 4,600 $ 13,000 32111 Liquor - Non-Intoxicating 650 600 880 640 640 32130 Cigarette 325 300 975 900 1,050 32140 Refuse/Recycle Haulers 705 1,095 1,625 4,450 1,500 32150 Rental Licenses 100 5,150 333 10,150 7,200 32160 Contractor 6,535 7,295 7,520 7,500 7,500 32161 Dog Kennel 100 225 125 150 150 32162 Junk Yards 800 400 200 200 200 32163 Tree Trimmers 50 175 125 100 100 1"'''\32165 Peddler 450 300 300 400 400 "'11"32166 Therapeutic Massage - - 300 - 150 32210 Building 297,406 346,048 540,129 350,431 449,114 32211 Heating 16,485 20,876 37,767 15,500 16,000 32212 Plumbing 38,412 45,196 69,267 40,000 45,000 32213 Septic Systems 1,820 1,897 3,105 1,500 1,500 32214 Septic Pumping 1,983 1,839 1,998 1,000 1,000 32215 Septic Repair 1,365 2,170 2,331 , 550 550 32216 Sanitary Sewer 6,075 6,175 9,555 6,900 15,000 32218 Curb Cut 15 30 20 50 50 32219 Cert. of Occupancy 1,104 1,188 1,812 1,500 1,200 32220 Gas Fireplace - - - - 6,000 32240 Dog Licenses 769 1,178 959 900 1,080 32260 Burning Permits 1,220 1,570 1,880 1,500 1,500 32261 Rezoning 1,025 1,683 1,000 1,000 1,090 32262 Special Use 3,700 2,091 3,075 3,000 3,420 32263 Variance 1,175 1,150 500 1,000 1,200 32264 Lot SplitsNacate Ease 1,118 1,600 1,225 1,200 1,440 32265 Special Home Occupation - 400 950 200 200 32267 Signs 1,767 1,183 1,354 1,500 1,500 32268 Moving 75 - - - - 32269 Compo Plan Amendment - - 900 - 400 1:::i:ii:i:i:::::::':ii:'::':'i:.::::::::':i':I~~liji,:'i;:j:i::,:;::::::::::::!:::iiIii&:::\iiIii&:::I:-::i:::_ij:_::~ ............ ... .............. ...................... ... ....... ........ .... ... .............. ... ....... ........ " ..... r ~venue Actual Actual Actual Budget Budget ... ...eode 1996 1997 1998 1999 2000 Interaovernmental Revenue 33130 Comm. Develop. Block $ 84,283 $ 68,667 $ 29,974 $ 40,000 $ 40,000 33131 Electrical Permits 44 65 117 100 100 33401 Local Government Aid 106,935 120,769 122,651 111,145 119,752 33402 Homestead & Ag Credit 343,343 331,977 340,466 340,288 381,528 33403 Local Performance Aid - 23,111 28,490 27,087 - 33404 P.E.R.A. - 5,047 10,093 5,000 10,093 33405 C.O.P.S. Grant - - 23,750 110,000 50,000 33406 SCORE Reimbursement - - 48,852 51,000 55,000 33407 State Police Aide - - 52,009 49,547 53,132 33418 Munic. State Hwy Aid 140,000 140,000 140,000 140,000 140,000 33420 Insurance Premium Tax 54,542 54,275 57,830 65,000 62,000 33422 Other Grants 92,763 240,018 7,041 12,000 12,000 33430 School District Liason 5,780 4,887 19,424 10,750 18,370 '::~:~~:iii:~:::II::i:i'::'i:i:I::i:':~i.ii::':':::::::::::::'::::i~~:i::~li-::i:::-~:!l-'I Charaes for Current Services 34101 Rental of Fields/Rinks $ 600 $ 600 $ - $ 500 $ 500 34102 Notary Fees 18 27 36 50 50 34103 Plat Fees 14,572 6,488 5,109 5,500 5,500 34104 Plan Check Fees 188,714 209,458 342,074 195,431 291,923 .. ....34105 Sale of Copies, Ord. etc 1,364 1,035 1,340 900 900 I ~4106 Reports - 40 20 - - 34107 Assessment Searches 1,788 2,613 5,025 5,000 7,400 34108 Meeting Notif. Sign Fee - - - - 500 34109 Sewer Administration 3,695 3,675 5,680 3,500 3,500 34111 Engineering Mileage - 953 884 - - 34112 Party Permits 112 60 45 50 50 34114 Recycling 8,111 8,629 10,176 12,000 12,000 34115 Recording Fees 1,901 845 1,030 800 800 34116 Tournament Fees - 150 1,342 200 200 34117 Bad Check Charge 208 25 100 50 50 34118 Health Authority Fee 95 5 10 500 50 34119 Reinspection Fee 773 504 1,050 350 350 34120 Council Filing Fee 50 - 90 - 50 34121 Escrow Inspection Fee 3,925 2,735 3,525 1,400 3,200 34122 Site Plan Review - Trees 3,895 (1) - - - 34123 Sale of Street Signs 11,835 12,366 29,775 6,000 10,000 34124 Com. Site Plan Review 5,250 6,000 2,250 3,000 4,000 34125 City Engineer Fees 59,563 65,921 66,242 63,000 75,035 34126 Civil Engineer Fees 65,659 78,744 58,509 75,000 82,535 34127 Ass!. Engineer Fees 27,959 26,927 20,110 29,000 34,100 34128 Engineering Sec. Fees 24,741 25,560 20,989 26,300 29,000 34129 Engineering Intern Fees 2,808 2,856 8,968 4,000 4,200 34131 Public Works Fees 1,927 30,239 14,912 6,500 6,500 34135 Debris Removal 240 - - 100 100 34139 Weed Abatement 224 - - - - '- "\4140 Flood Zone Search 30 15 - 100 100 .. "34141 Financial Admin. Fees 303 19,988 257,892 33,000 80,000 34142 Planning Dep!. Fees 3,897 16,067 10,472 20,000 10,000 34143 Grading Inspection Fee 8,943 5,861 9,408 4,000 4,500 34145 Fire Department Fees 171 - - 200 300 34146 Administration Fees 1,069 486 55,053 - - CITY OF ANDOVER Revenue Budget Worksheet Budget Year 2000 12/30/9911 :22 AMGENERAL.XLS CITY OF ANDOVER Revenue Budget Worksheet Budget Year 2000 12/30/9911 :22 AMGENERAL.XLS I o-venuel -' e- e- ~ - .~:: - - I-- I-- .. .. I- - - - - I , Actual 1996 Actual 1997 Actual 1998 Budget 1999 Budget 2000 . continued o. ~.~ ~j~ _ 46,356 81,190 100,000 110,000 285 125 225 100 100 i:~:i.!::~~~:__:i~:~:~::l:::-I o. * 269,7:?io'i'( ::; 7 '{ ,. '{'I U . :c u '( > '"I $ 56,300 $ 47,590 $ 47,423 $ 43,000 $ 51,000 825 1,210 1,500 500 1,000 ::I:_::l:~:::i::-~~ 645 2 162,026 25,000 80,000 .....: ~ -; 15,544 - - 1,000 19,832 30,384 27,000 33,000 1,000 200 - - - 5 64 197 - - 318 439 810 1,500 1,200 _ c:.....- 102 - - 100 100 3b.::,+o :;ale ot Used Equipment 1,502 407 2,303 - - 36249 Fire Department Revenue 214 20 88 - - 36250 Concession Fees 1 - - - - 36255 Sale of Land 10,050 - - - - 36260 Refunds & Reimbursement 7,165 39,912 13,761 16,000 16,000 37401 Street Light User Fees 104,541 104,855 121,879 118,000 142,290 37460 Penalties - Street Lights 1,689 1,849 2,234 1,800 1,800 38401 Computer Services - 17,001 10,865 12,000 12,000 l::i:i:ii:::'::::!:iiii:'i:i:':ii::i~jiJ::::::::::::::l::::::I:~::I::_:::i:_~:i:::_iil::_:' 'iOO,5'!O-()3 + ~ ~ ~ ~ :,.i{j '( J ') c; C' ~ \J:) 392:;St,l3"'t.5 ,'. ,,' Transfers 39201 Transfers From Other Funds $ - $ 246,200 $ - $ - $ - 39203 Transfer From Admin. Trust 71,000 71,000 33,020 32,723 - 39207 Transfer From PIR Fund - - 50,000 140,000 - 39210 Transfer From Sewer Fund - - 12,000 12,300 10,000 39213 Transfer From Water Fund - - 69,000 70,775 71,961 39214 Transfer From Capital Equip. - - 50,000 693,625 577,718 39215 Transfer From In-House MSA - - ,??g,qOO" - - ". .......... ................. ". ....... ." ." ...... ...... o o $7,000,000 $6,000,000 $5,000,000 $4,000,000 o $3,000,000 $2,000,000 $1,000,000 o CITY OF ANDOVER GENERAL FUND COMPARISON OF EXPENDITURES Previous Five Years and Proposed 2000 Budget $- 1995 1996 1997 1998 1999 2000 o o o Public Safety 30% Public Safety 31% CITY OF ANDOVER Summary Of Expenditures By Function Budget Year 2000 2000 Public Works 40% General Government 28% 1999 Public Works 39% General Government 28% CITY OF ANDOVER 12/30/9911 :22 AMSUMMARY.XLS Expenditure Budget Summary - Totals Budget Year 2000 Actual ~ Actual ~ Actual ~ Budget 1i99. Budget 2QQQ. o o 0 Actual Actual Actual Actual Budget Budget 1I!!l!i 1996 11m 1998 1999 2000 GENERAL GOVERNMENT Mayor and Council $ 52,192 $ 53,034 $ 55.200 $ 58,388 $ 76,854 $ 72,750 Newsletter Total 4,439 5,247 6,287 7,200 17,000 21,000 City Cieri< Total 91,344 88,039 88,179 95,031 100,508 105,698 Elections Total 5,881 15,635 2.474 13,311 3,515 31,720 Administration Total 66,691 74,946 86.812 81.420 86,927 90,819 Financial Admin. Total 140,705 151,747 176,176 175,678 215,006 220.451 Auditing Total 12,579 9.425 7.468 7.420 8,600 9,500 Assessing Total 63,360 69,799 68,914 75,197 76,000 78,336 Attorney Total 97,899 99.407 97,926 98,242 107,900 108,120 Planning and Zoning Total 90,607 116,803 164,864 164,572 200,252 215,792 Data Processing Total 24,357 27.437 43,798 44,853 66,550 112,749 City Hall Building Total 40,909 48,271 48,104 59,341 67.900 70,539 Fire Station Total 35,008 40,622 43,622 41,997 53,750 54,200 Public Worl<s Building Total 45,140 45,383 45,503 238,072 246,343 269,818 Senior Citizen Center Total 7,573 8,583 9.464 9.454 12,180 12,433 Equipment Building Total 1.412 2,997 2,720 4,381 16,150 20,806 City Hall Garage Total 627 430 824 506 1,875 2,592 Engineer Total 150,602 210.771 269,385 355,176 416,570 387910 Illif.iii_?llm.i~;I:::_:::~;Iiiiii::i~:_:!:_:~_:::,:::_:1 ~/C SAFETY ~ce Protection $ 428,602 $ 568.943 $ 646,041 $ 771 ,225 $ 1,012,092 $ 1,062.430 Fire Protection 387,013 461,515 491 ,334 502,892 669,012 600,140 Protective Inspection 225,911 235,721 254,155 282,998 305,694 329,631 Civil Defense 9,230 12,940 6,246 12,868 12,712 13.432 ~nimal Control__.__ ......-- 9.46.1....____... 11,563.__.__ ____ 11,311. 9,854_____--.-- 1.3,325__.... .... 12105 Ifuf.$i:'lii:.~::::::::::::::;;:i:::::;:I::iiIiii::~~:liiiiii:_:!:_::~:::_;:I:::_;I PUBLIC WORKS Streets and Highways $ 257,148 $ 540,035 $ 458.483 $ 472,878 $ 985,030 $ 1,083,578 Snow and Ice Removal 191,614 215,230 375,829 265,026 440,267 467,504 Stonn Sewer . 16,349 29,209 69,061 66,693 150.486 124,222 Street Lighting 19,168 18,240 21,728 24,374 36,200 36.400 Street Signs 68,260 67,820 80,804 113,190 108,736 111,887 Traffic Signals 17.550 16,610 17,303 17,350 25,000 30,000 Street Lights - Billed 83,810 89,534 90,036 112,575 113,700 134,700 Tree Preservation 13,852 22,390 21,301 22,609 19,909 20,692 Weed Control 4.596 8,919 5,270 11,737 18,950 19,851 Parl<s and Recreation 329,416 396,991 327,022 403,636 522,817 550,714 Sunshine Pari< - 10 33.492 21,181 26,442 31,917 Recycling 58,26Q. 55,170 62,281 76,773 94,999 95 627 .. ............... .............. ,.. ...................... . ..... ....... ....~.. ...... ...... .... I I I I I I I ER 133,046 752,263 274,319 1,003,025 181,858 168,312 .................... ......... ....... .., ................... .... --' .. .-- ... .............. .... ......... CITY OF ANDOVER 12/30/9911 :24 AMTOTSUM2.XLS Expenditure Budget Summary - General Government Budget Year 2000 o Actual Budget Request Percentage 1998 1999 2000 of Budaet 2000 GENERAL GOVERNMENT Mavor and Council $ 58,388 $ 76,854 $ 72,750 1.07% Newsletter Total 7,200 17,000 21,000 0,31% City Clerk Total 95,031 100,508 105,698 1,56% Elections Total 13,311 3,515 31,720 0.47% Administration Total 81,420 86,927 90,819 1,34% Financial Admin. Total 175,678 215,006 220,451 3,25% Auditing Total 7,420 8,600 9,500 0.14% Assessina Total 75.197 76,000 78,336 1,16% Attorney Total 98,242 107,900 108,120 1,60% Planning and Zoning Total 164,572 200,252 215,792 3.18% Data Processing Total 44,853 66,550 112,749 1.66% City Hall Building Total 59,341 67,900 70,539 1.04% Fire Station Total 41,997 53,750 54,200 0,80% Public Works Building Total 238,072 246,343 269,818 3.98% Senior Citizen Center Total 9,454 12,180 12,433 0,18% Eaulpment Building Total 4,381 16,150 20,806 0.31% City Hall Garage Total 506 1,875 2,592 0.04% Engineer Total 355,176 416,570 387910 ~ l:~ii~_ll.imffiil::::~::iIiIiii:I::_:~:::-i:'::~::::::I::::::::::::::::11:::::11I1 PUBLIC SAFETY Police Protection $ 771 ,225 $ 1,012,092 $ 1,062,430 15.67% Fire Protection 502,892 669,012 600,140 8.85% Protective Inspection 282,998 305,694 329.631 4.86% Civil Defense 12,868 12.712 13,432 0,20% AnImal Control 9,854 13,325 12105 0.18% l~ii:'riii_~:~:!l::l!::!::I:::::!l_l-ll:;iIiIiii:I::i:~:~~:r::::::;;i!::::::I:i_1 ............. ....... ...~......... :.:.:.:.... .:.:.:.................... ...... .............. ...... ....... ..':':'." PUBLIC WORKS Streets and Hlahwavs $ 472,878 $ 985,030 $ 1,083,578 15,99% Snow and Ice Removal 265,026 440,267 467,504 6.90% Stonn Sewer 66,693 150,486 124,222 1.83% Street Liahtlng 24,374 36,200 36,400 0.54% Street SIlins 113,190 108,736 111,887 1.65% Traffic Signals 17,350 25,000 30,000 0.44% Street L1ahts . Billed 112,575 113,700 134,700 1.99% Tree Preservation 22,609 19,909 20,692 0.31% Weed Control 11,737 18,950 19,851 0,29% Parks and Recreation 403,636 522,817 550,714 8,12% Sunshine Park 21.181 26,442 31,917 0.47% Recycling 76,773 94,999 95 627 ~ 1:.lXi;lll!j:I;Ii~:,::::::::l:I:,:::~:::::~::iIiIiii:l:iIiIiii::illli.I~~:I:::::::;:lll1~ I I I I Il....::~ '. . .' : ~ :::.' : :;:::. . '.. '. .... . .. . CITY OF ANDOVER 12/30/9911:24AM%ALLOC'xLS Expenditure Budget Summary Budget Year 2000 o o CITY OF ANDOVER 12/30/9911 :22 AMSUMMARY.XLS Expenditure Budget Summary - General Government Budget Year 2000 o Actual ~ Actual ~ Actual ~ Budaet ~ Budget ~ Mavor and Council - OeDartment# 4111 0 Personal Services $ 20,024 $ 20,024 $ 20,024 $ 37,032 $ 37,780 Suoolies and Materials 201 776 209 400 400 Purchased Services 15,348 15,450 15,321 16,000 16,294 Other Services and Charges 17,461 19,816 22,834 23,422 18,276 LL::::,::,:;;~,:";;:.;,~:,;,;,,;;;;,:,;,,~;,~,;,::Z';;<l"",""",I~"!,~t,ii,,ttt"t~~tHlifffr'td,:t~a5$.fH~m~I:llil~l::milltOO: 1::ltI:n:':irn:t,l'M_9~1!nfHi~?Mflg~Iilrii~f~~i~"i~'i'~ N..w..iAtfAr. D 41140 Purchased Services 9> 5,247 $ 6,287 $ 7,200 $ 17,000 $ 21,000 t::~li;:!ii::ii:::iii:~~,ti::ljl.:.:::::;:::':::::~:~:!:::::::~:I:::iIIIIi.I::\:::-;::f:l_:I::~ ~jhl ~I"rk - D ~ 414nn .. Personal Services $ 71,424 $ 70,989 $ 76,363 $ 82,271 $ 86,645 , Buoolies and Materials 464 1 ,483 881 480 525 Purchased Services 15,030 15,039 15,623 16,607 17,093 Other Services and Charges 1 ,121 668 2,164 1 ,150 1 ,435 ~;j:ii!:ii!::::::i:i:i!li::iliiii~i~i::::::;il::::;l:i::I:iIIIIi.I:f-:::I::r-;!:l_~ Elections - Department # 4141 0 Personal Services $ 13,850 $ 1,323 $ 11,860 $ 1,515 $ 20,190 Supplies and Materials 203 - 146 - 250 Purchased Services 1 ,583 1 ,151 1 ,305 - 1 ,280 ~ T Atlmini..tr..tjon - O..n..rtm..nt # 414~ Personal Services $ 57,467 $ 68,071 $ 62,076 $ 66,962 $ 71,364 Supolies and Materials 2,598 3,229 2,045 2,500 2,500 Purchased Services 10,857 12,193 12,760 13,419 13,895 Other Services 4,023 3,318 4,538 4,052 3,060 :::::::il:::::l::::::l::;::!::::~I.'::.III'.1<~RI::,i:;::':i:~::::,::::::~~,::~:::',~i~:~i"~:;:;'::"~:?:~1~~~i:::i~::~:':~;:~:i::::::~'~~!!:~~~:::l:!:~':':~:~:::~:'~:::~:~::!~~~!;:::~~:~:;'::~::i:::::::~:::1~f.I!l~:::!~::~i~::::::l:::::::::~~~!:~;~:,:: .. ., CITY OF ANDOVER 12/30/9911 :22 AMSUMMARY.XLS Expenditure Budget Summary - General Government Budget Year 2000 c- . Actual Actual Actual Budget Budget ~ 1Jm ma ~ ~ Financial Administration . Deoartment # 41530 Personal Services $ 141 ,051 $ 161 ,283 $ 164,065 $ 198,662 $ 201 ,570 Supplies and Materials 2,097 3,465 2,976 3,742 4,150 Purchased Services 4,501 3,572 4,298 4,921 5,527 Other Services and Charges 4,098 7,002 4,339 6,182 7,005 Capital Outlay - 853 - 1 ,500 2,200 Audit . Department # 41540 Professional Services $ 9,425 $ 7,468 $ 7,420 $ 8,600 $ 9,500 Assessing - Department #41550 :il;~:.:I::":~~:i~:i:"ll 'Nu uuuuuuu..uuuuu. '.....'" UUUUUUU ' .uu.uu.. .. NUUU u.uuuuu ~nrn~v - ~:/t ~O4 Professional S.ervicesN. 'NN.,$ 99,4o.! !N' 97,926 $.,.u98,242 $..107,90.0. $, 108,120. 1~1'::::i'i:i:'::iiii'i:'!iI,:iii_i;ii::::i:::::::::i;i:l;:I;:--::I:ii:_::I~::-~::~ Plannino and Zonina - Deoartment # 41910 Personal Services $ 104,242 $ 134,311 $ 149,097 $ 176,736 $ 191,564 Supplies and Materials 2,452 5,748 4,018 5,000 5,000 Purchased Services 7,157 11 ,149 6,628 10,598 10,604 Other Services and Charges 2,952 6,136 4,829 7,918 7,625 ~ Data Processina - Deoartment # 41920 Personal Services $ - $ - $ - $ - $ 15,674 Supplies and Materials 27,437 38,894 42,608 66,550 82,075 C Capital Outlay - 4,904 2,245 - 15,000 ~i'ii::ii:ilii;itl:IIII!I::::l:i:::'::::I::--:::I~:i:-~I:':~ I r. CITY OF ANDOVER 12/30/9911 :22 AMSUMMARY.XLS Expenditure Budget Summary - General Government Budget Year 2000 ~iht 1-1..11 Actual lil96 . DeDartment # 4 1940 Actual .199Z Actual ~ Budget 1.99i Budget 2QOO Supplies and Materials $ 3,911 $ 4,878 $ 5,813 $ 6,500 $ 7,000 Purchased Services 25,546 30,661 38,064 38,275 40,414 Other Services and Charges 8,685 7,815 14,467 23,125 23,125 Capital Outlay 10,129 4,750 997 - - =irFl . Department # 41950 Supplies and Materials $ 1,598 $ 1,413 $ 1,960 $ 5,700 $ 5,700 Purchased Services 34,106 33,951 31,454 38,550 39,000 Other Services and Charges 4,917 8,257 8,582 9,500 9,500 Ollhli~ Work!; BlJildinn . Department # 41960 ... Supplies and Materials $ 4,470 $ 7,900 $ 15,962 $ 18,199 $ 18,603 Purchased Services 19,905 19,526 38,529 38,899 42,200 Other Services and Charges 4,472 8,983 17,113 19,220 20,500 Capital Outlay 16,535 9,094 688 - 15,000 Debt Service - - 165,780 170,025 173,515 Senior Center. Department # 41970 Supplies and Materials Purchased Services Other Services and Charges $ - $ 6,685 1,898 432 $ 6,727 2,275 452 $ 6,727 2,275 800 $ 7,280 4,100 800 7,533 4,100 I =nlJipmFlnt B '. 4~ Supplies and Materials $ 209 $ 732 $ 2,543 $ 1,000 $ 1,000 Purchased Services 2,492 1,988 1,024 13,750 13,406 Other Services and Charges 296 - 814 1,400 1,400 Capital Outlay - - - - 5,000 CITY OF ANDOVER 12/30/9911 :22 AMSUMMARY.XLS Expenditure Budget Summary. General Government Budget Year 2000 Actual ~ Actual ~ Actual ~ Budget ~ Budget ~ $ Personal Services Su lies and Materials Purchased Services Other Services and Charges Capital Outlay $ o CITY OF ANDOVER 12/30/9911 :23 AMSUMMARY.XLS Expenditure Budget Summary - Public Safety Budget Year 2000 -- &;;: Actual Actual Actual Budget Budget 1996 1MZ 1998 ~ .2QQQ Pnli~A PrntA~tion . ment ~2~ Supplies and Materials $ 20.72 $ 169.84 $ - $ - $ - Purchased Services 568,922.00 645,871 .00 719,670.00 1 ,012,092 1 ,062,430 Other Services and Charges - - 51,555.00 - - !~il!::II~~I:Bf.i~!I:~::::::!:I:::_~!_::I:_::~::~_:::j::~:::l .. ...... IEIII);,. ,t"""""'Lq,...,.. .'.r.....W...N....N.....,..N..... NN. q. ....q. ,.. . Fire Protection . ment # 42200 Personal Services $ 312,944.32 $ 281 ,308.36 $ 315,148.33 $ 417,078 $ 424,460 Supplies and Materials 19,596.09 27,704.37 22,756.77 29,100 29,350 Purchased Services 14,051.43 16,180.05 16,971.00 18,810 19,307 Other Services and Charges 83,350.21 125,302.63 125,540.87 142,649 127,023 Capital Outlay 31 ,572.65 40,838.68 22,475.39 62,000 - Protective InsDection . DeDartment # 42400 - Personal Services $ 217,392 $ 220,607 $ 240,634 $ 276,144 $ 293,818 Li Supplies and Materials 5,771 8,996 9,336 9,850 12,600 Purchased Services 2,684 4,458 21 ,348 5,474 8,015 Other Services and Charges 8,730 13,877 10,842 14,284 15,199 Capital Outlay 1,143 5,161 837 - - - ;:::;: . ........................ ................ ....... ........ .... .................. ... ................:.. I f"ivil nAfAnse . : # 42500 Personal Services $ 2,818 $ 2,837 $ 3,034 $ 3,162 $ 3,307 Supplies and Materials 5,142 - 5,054 4,450 4,950 Purchased Services 1,163 1,253 1 ,223 1 ,450 1,525 - ........................ ... ............................................... .....,.;.................. ......:.:.: .................:.;...;.... ..............;.. ..... ....... .... ... Anim:ill I . ment # 2700 Supplies and Materials $ 75 $ 186 $ 181 $ 250 $ 30 Purchased Services 1 1 ,488 11,125 9,673 13,075 12,075 CITY OF ANDOVER 12/30/9911 :23 AMSUMMARYXLS Expenditure Budget Summary - Public Works Budget Year 2000 r"" .. Actual Actual Actual Budget Budget ~ 1m wa ~ ~ II. Hinhw..v.. - D n i:lt 4~1nn Personal Services $ 1 39,552 $ 1 1 8,552 $ 1 58,81 8 $ 1 31 ,51 2 $ 1 38, 1 33 Supplies and Materials 33,087 24,31 8 21 ,240 27,357 28,700 Purchased Services 1 2,384 1 3,536 1 5,51 2 1 5,402 1 6,060 Other Services and Charges 302,237 302,077 277,308 81 1 ,001 900,686 Capital Outlay 52,776 - - - - Q"^,,. and Ice Remov'" - D",n..rtm"'nt :It 4~1 2" Personal Services $ 1 00,448 $ 1 58,705 $ 1 06,398 $ 228,225 $ 241 ,866 Supplies and Materials 65,81 1 1 44,620 84,861 1 26,400 1 36,600 Purchased Services 2, 1 46 2,300 2,422 3,070 3,296 Other Services and Charges 46,825 70,205 70,220 83,006 85,742 Capital Outlay - - 1 , 1 24 - - Q Storm Sewer - Department # 431 50 Personal Services $ 9,695 $ 34,866 $ 21 ,481 $ 47,389 $ 51 ,037 Supplies and Materials 4,51 7 3,31 5 1 2,1 03 4,500 4,500 Purchased Services 291 307 296 831 835 Other Services and Charges 4, 1 61 3,523 32,81 3 67,777 67,850 Capital Outlay 1 0,546 27,049 - 30,000 - I I Street Linhtinn - Denartment :It 4' 180 Purchased Services $ 1 7,531 $ 1 9,437 $ 20,964 $ 26,000 $ 26,000 Other Services & Charges $ 1 00 $ 50 $ 350 $ 200 $ 400 Capital Outlay $ 61 0 $ 2,241 $ 3,060 $ 1 0,000 $ 1 0,000 t Sinn.. - nt :It 4~1 7n Personal Services $ 27,256 $ 42,488 $ 61 ,521 $ 55,793 $ 58,044 Supplies and Materials 1 8,823 30,752 43,830 29,1 50 29,200 Purchased Services 90 301 1 76 31 6 41 9 ~ Other Services and Charaes 1 6,257 7,262 7,663 23,51 2 24,224 W Capital Outlay 5,395 - - - - CITY OF ANDOVER 12/30/9911 :23 AMSUMMARY.XLS Expenditure Budget Summary - Public Works Budget Year 2000 r! - Actual Actual Actual Budget Budget 19a.6. 1i9Z. ~ ~ .2WHl Tr dfic Sian~l<'t - nAn~rtmAnt:lt 4~ 1Rn Purchased Services $ 1 6,61 0 $ 1 7,303 $ 1 7,350 $ 25,000 $ 30,000 Capital Outlay - - - - - Street Liahts - Billed - DeDartment # 431 90 Supplies and Materials $ - $ - $ - $ 1 50 $ 1 50 Purchased Services 81 ,961 87,61 3 1 03,350 97,550 1 1 8,550 Repairs & Maintenance - 2,423 9,225 1 6,000 1 6,000 Capital Outlay 7,573 - - - - Tr !e Preservation - D '~ 46102 Personal Services $ 1 4,529 $ 1 2,981 $ 1 6,731 $ 4,092 $ 4,81 7 Supplies and Materials 737 1 9 551 1 ,350 1 ,350 ,., Purchased Services 5,081 4,279 3,598 1 0,624 1 0,626 - Other Services and Charges 1 ,240 2,941 1 ,729 3,851 3,900 Capital Outlay 803 1 ,082 - - - I I w ed - DeDartment # 4610~ Personal Services $ 2,546 $ 1 ,91 1 $ 4,600 $ 7,064 $ 7,880 Supplies and Materials 3, 1 1 7 1 ,427 863 3,400 3,450 Purchased Services 1 ,394 598 1 ,045 1 ,830 1 ,833 Other Services and Charges 1 ,862 1 ,333 5,229 6,660 6,688 I IPa 'ks. D #~ Personal Services $ 1 69,604 $ 1 24,694 $ 1 96, 923 $ 274,691 $ 333,387 Supplies and Materials 33,41 6 41 ,080 42,704 42,400 43,700 Purchased Services 20,435 20,632 25,297 26, 1 00 27,502 Other Services and Charges 55,578 78,470 73, 1 55 93,848 95,246 Capital Outlay 74,397 35,582 40,81 8 60,000 30,000 Debt Service Assessments 43,561 26,564 24,739 26,000 20,879 C Miscellaneous - - - - - I I T CITY OF ANDOVER 12/30/9911 :23 AMSUMMARy.xLS Expenditure Budget Summary - Public Works Budget Year 2000 Actual 1996. Actual ~ Actual ~ Bud et ~ Budget 2QOO Su lies and Materials $ 10 $ 955 $ 2,526 $ 2,820 $ 4,020 Purchased Services 28,618 16,362 16,322 17,197 Other Services and Charges 3,918 2,292 7,300 10,700 ::::l:I:::::::II!!,I:!!!!ill~!.I!',-~I::~I~':::::I:::::::::::!:::::!:::::::::::::!::::::::~.~':::!:::::::::!::::::!!!~!::,::;::(f:::::::::!:!::::::~!~~:~~!:;:::i::!::::::!~i!!::::::::~::::::!!:::::::::!::!!~:.l!!:~ Personal Services $ 22,054 $ 24,543 $ 39,585 $ Su lies and Materials 2,484 1,139 1,118 Purchased Services 6,235 10,077 3,202 Other Services and Charges 22,821 23,005 29,943 Capital Outlay 1,576 3,517 2,925 :::ll::::,lllll::::l::lllll.'i:l.i~!!~::::::::::::::::!::::~:::::::::!:~l~~~::l~:::::::::::::::::~~~!!~::::::::~!:::::::1!:!:~~~~::::~:::::::!::::::~~~~~!:::1~::::::::::::::!:::!:~~l.~~~l 53,063 $ 10,050 7,100 24,788 52,577 10,050 7,200 25,800 o o CITY OF ANDOVER 12130/9911:23AMSUMMARY.XLS Expenditure Budget Summary - Other Budget Year 2000 Actual ~ Actual 1m Actual ~ Budget ~ Budget ~ Other Financial Uses Unallocated $ 105,036 $ 199,054 $ 102,775 $ 146,858 $ 128,312 Other Uses 647,227 75,264 900,249 35,000 40,000 :!!~::::l:~::!:~g1il:i_::iiii2ii:l.l!:::::~:::::::::::~~~~~:!::::~::::1111::~~!!~~~::::::~::!:::::l!:~~I.~~!:::::::~::::::::::'::::::~!~~::I.~~!:::!i~1:::::::!:::::!:!:~~~~!~::: o o Q, City of Andover Budget Comparisons Budget Year 2000 PERSERV,XLS o GENERAL FUND SALARIES 1999 2000 1999 2000 DEPARTMENT BUDGET BUDGET BUDGET BUDGET Mayor/Council $ 76,854 $ 72,750 $ 34,400 $ 34,400 Newsletter 17,000 21,000 City Clerk 100,508 105,698 68,624 72,074 Elections 3,515 31,720 1,228 19,894 Administration 86,927 90,819 54,803 58,276 Financial Administration 215,006 220,451 161,064 162,621 Auditing 8,600 9,500 Assessing 76,000 78,336 Attorney 107,900 108,120 Planning & Zoning 200,252 215,792 142,758 157,041 Data Processing 66,550 112,749 0 14,560 City Hall Building 67,900 70,539 Firestation Building 53,750 54,200 Equipment Building 16,150 20,806 Public Works Building 246,343 269,818 City Hall Garage 1,875 2,592 Senior Center 12,180 12,433 Engineering 416,570 387,910 296,529 275,920 Police 1,012,092 1,062,430 Fire Protection 669,012 600,140 254,089 260,431 Protective Inspection 324,694 329,631 221,116 238,921 Civil Defense 12,712 13,432 2,586 2,714 Animal Control 13,325 12,105 Streets 985,030 1,083,578 106,191 112,621 Snow/Ice 440,267 467,504 183,280 195,897 Storm 150,486 124,222 37,760 41,126 Street Lighting 36,200 36,400 Street Signs 108,736 111,887 44,290 46,989 Traffic Signals 25,000 30,000 Street Lights- Billed 113,700 134,700 Tree Preservation 19,909 20,692 3,494 3,771 Weed Control 18,950 19,851 5,908 6,265 Parks 585,875 550,714 228,515 277,108 Sunshine Park 26,442 31,917 Recycling 94,999 95,627 42,356 41,572 Unal10cated 83,800 128,312 Other Fin. Uses 35,000 40,000 TOTALS $ 6,530,109 $ 6,778,376 $ 1,888,993 $ 2,022,202 o Page 1 @ CITY OF ANDOVER 2000 ANNUAL BUDGET &' o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The general fund is the primary government fund type. The purpose of the general fund is to account for all financial resources except those required to be accounted for in another fund. The general fund is very active and can become quite complex owing to the range of activities it covers. It accounts for most of the City's general activities, such as administration of the branches of government, public safety and highway and street maintenance. CITY OF ANDOVER Summary Of General Government Expenditures 2000 Data Processing 6% Government Bldg 22% City Clerk 6% Financial Administrati 12% Ne'7;.ettex.dministration Auditing Attorney 5% 1% 6% Elections 2% Council 4% o 1999 Government Bldg 23% City Clerk 6% Assessing 4% Financial Administration 12% Data Processing 4% ngineering 24% Newsletter o Auditing I YoAdmini" strati' 0,&% 5% Attorney 6% o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET I"""."'.'.'.'."'.."'.. '."""'.,...,.,..,...,.,.,.."".,.",..,.".,.,..,.,,., ".,.,....................................,.................. 111151...'..,...'...,.,.....,.,.,. . ... .... .... .. . . ........ .;;: :"::: ::::;::....::. ::;:::;:::;: :;:;: : :;:;: :::....::~:::::;:::: .... ...... ...... .... ... ... ........ . ...., .. .... . ..... .. . .. . ... . ..... ." ",. ........... ...... .... ....... .... . .... ... .. . .. . ..... . . - ..... . ..... .;.;;:.;.:::::::::;:;:::;:;:::::::::.:::;:::;:;:;:;:;:;:;:;:;:;:;:;:;:;:;:;:::;:;:;:;:;:.;.;.;;:.:;:;:;;.:;:::;:::::; .. ...... ......... ....................... .............................................. ....................... ...................... ;.:::::.;.;.;." ~:!:~:~~~: ............:........... ......, :.:.:.::::: ... {:~:;;:;~ ;':-:':';':':';':-:':';':';':'.'; ................. ................. :.:.;.;.:.:.:.:.:.;.:.:.:.;.:.:.: ..... ......... ................. -..... ....................... .................... . ....................... . . . . ..:::::::::?::?:;::::::::::::::;::t~:L.:.::~;::~;:;:;;;;;;;:;:::;::........ . . .. ....................... ...................... ......................... .... ........................ .':':':': :::::.:.;.:::::::::;:::::::::;::;::::::::::;::::: :: :~:~ :~:~:~:::::~::::: ::j::; The legislative body of city government is the City Council. Comprised of four council members and the mayor, the City Council is responsible for enacting ordinances, adopting the annual budget and establishing basic policies of the city. They are also responsible for appointing the city administrator, city attorney and members of city advisory commissions. The mayor is elected for a two year term and council members are elected for overlapping four year terms. C/) ...J ><; og <( :2 :2 :2 <( o .... 0) 0) 0) (:) ~ .... a: z w 0 >1-1- Ow::> ceJCO ~gg: VCl co (f) Ll.o- 000 ow >C\IeJ t- <( c:s :is: ...J (3 Q ~ (3 .... C") 0) 0) 0) 0 ~ 0 0 l!) l!) l!) CO CO l!) .... .... .... r--- as r---- to: to: to: to: C") I , , , , , , W LL ::i I , , , , , , ....I ~ Z W e I , , , , , , :J: ~ <I: w :J: I C") CO CO CO CO 0) .... 0) 0) 0) 0) 0) .... '<t , '<t C\J C\J C\J C\J C") CO .... .... .... .... C") ~ '<t '<t '<t '<t '<t .... C\f , g ~ 0) ~I '<t C") r:! 0 0 0 0 0 0 en ~ 0 l!) l!) l!) l!) 0 en CO CO CO CO CO '<t 0 ~ r---- cD cD cD cD -<i a: C") ~ ~ l- e. II: II: II: II: ~ W UJ UJ UJ ....I <I: III III III III I- :2 :2 :2 :2 0 w UJ UJ UJ UJ l- e :2 :2 :2 :2 e ~ ::::! ...J ...J ...J Z II: C,) <3 <3 <3 <I: I- 0 Z Z Z z a: ~ ~ ::> ::> ::> ::> ~ 0 0 0 0 e. :2 C,) C,) C,) C,) CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/999:10 AMMA YOR.XLS o 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Mayor 1.000 $ 7,800 1.000 $ 7,800 Council Members 4.000 26,600 4.000 26,600 Total 5.000 $ 34,400 5.000 $ 34,400 .0 o o o o CITY OF ANDOVER 12/30/999:11 AMWMAYOR.XLS Expenditure Budget Worksheet Budget Year 2000 MAYOR AND COUNCI L DEPARTM ENT# 41 1 1 0 General Fund Object Actual Actual Actual Budget Request ~ ~ 1m ~ limll .2QQQ Personal Services 1 06 Salaries $ 1 8,600 $ 1 8,600 $ 1 8,600 $ 34,400 $ 34,400 1 21 PERA $ - $ - $ - $ - $ 749 1 22 FICA 1 , 1 54 1 ,1 54 1 , 1 54 2,1 33 2, 1 33 1 25 Medicare 270 270 270 499 499 ::,:i:::li!:lii!:I'iiii::ii:ii.I,I,I~iiiil:iiiii!iii:iil::i':!i:iiiii':::ii::::l~:i:::!~i~!!::il!:iiiiii!~l~!~~:!~:::~::!~~~!:::~i!ii~!~!!::ii~~:!?~!!: Supplies and Materials 201 General Office Supplies $ 201 $ 71 7 $ 92 $ 350 $ 350 21 0 Operating Supplies - 59 1 1 7 50 50 ::l:iii:llii:i:i:ilil::~~:lii::ii.I!I!i!:I::::'::i::l::::ii:i:il,ii~i::i:i:i:iiiiii!~:ii~'iii~~~~:~~;:i::!:i::l,i~il:i:l~iiiiii!:i,::~::i:::~~::::~:i~ii:i:i':ii~ii:i!!i~~i~;i:l~:!':i:::~::i:::~~m,: Purchased Services 301 Professional Services $ 5,820 $ 5,650 $ 5,51 9 $ 6,000 $ 6,000 330 Transoortation 4 - 3 200 200 351 Printing 23 - - - - 360 Insurance 9 500 9 800 9 800 9 800 1 0 094 iiiil:l:~i:::::ilii:iii:i::iii:i:,.lllli!::ii::::i:::::::::::!:::i:i~iiii:i:iiiii::i:l:::::::i:~:iii:iii~ii~i~~~~~:i:!::::i:::i:~~!~~~i:ii~:ii:i:~~~~i:::::I:!::i:!~i~!~~':iiiiil~~i~i~:~~~~:i: Other Services and CharQes 433 Dues/Reaistrations $ 7,751 $ 9,580 $ 1 1 , 1 94 $ 1 2, 1 06 $ 6,000 435 Subscriotions - - - 1 20 1 20 441 LMC Dues 9,71 0 1 0,1 60 1 1 ,304 1 0,696 1 1 ,231 442 MealslLodaing - 75 337 500 500 443 Continuing Education - - - - 425 li!::liliiiliii:ii:i!::i::i::l:Ii,Illlilil:!I:iii!i:il!:i:::i:::ii::::::::il!:iil~iiii:~~~i~~~!iil!:iiiii:~~!~~~ii:il!:1:ii~~~iiii::l~:::::~i~~i;:11~::::~:~~~~ .' ;jSj , v v ; o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The newsletter serves as a communication tool between the city government and the residents of the community. o o o CITY OF ANDOVER Expenditure Budget Worksheet Budget Year 1999 12/30/999:11 AMWNEWS.XLS NEWSLETTER DEPARTMENT#41140 General Fund Ob' ect ~ Actual ~ Actual 1a9Z Actual ~ Budget ~ Re uest 2.QOO Purchased Services o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The City Clerk's department prepares the agenda and materials for council meetings. This division is responsible for special assessment billing internally, certification of assessments to the county and all special assessment searches. Official City records are maintained by this division as well as election administration. Certain city licenses and permits are issued by this division along with enforcing the false alarm and dog ordinances of the City. This division is also responsible for maintaining the receptionist area. en ...J X ~ Q o o ::2: <t: ,... ,... a> a> ~ o ~ ,... a: z w 0 >1-1- OUJ:J C~CC 0- ~z :J a: cc~ LLo- 000 >~UJ I- ~ o ~ ~ c:: Od 1= Q 0 LO 0 LO LO LO .;- .;- ~ LO a> ,... <.0 ~ a> C\i -.f cI5 LO ,... ,... (Xl l- I r-. 0 0 r-. 0 ,... ,... C\I ,... ,... ,... C') W u. ::::i I LO <.0 <.0 r-. ..I ~ C\I C\I a> ~ ,... ,... .;- Z W c I 0 , , 0 :E: 0 0 LO LO !:i .;-. -.f et W :E: I C') C') a> LO 0 <.0 r-. .;- r-. ,... ,... q ,... <.0 a> .;- a> 0 a> <.0 <.0 ~ 0 <.0 r-. .;- C"i -.f ,... .;- (Xl C') ,... (Xl C') C') ml LO LO <.0 r-. C\i C"i (Xl C') C') .;- en ~ r-. r-. C\I r-. en .;- C\I. C') 0 0 ; as ,... C\i C\i a: .;- ,... ,... r-. CJ ~ l- e. ~ ..I l- I- et I- W en en 0 c ~ z Z I- ~ c:: 0 0 C w F= F= z ...J 0 0- 0- et I- W W a: ~I >- 0 0 CJ !::: w w 0 c:: c:: CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/999:11 AMCLERK.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Citv Clerk 0.974 $ 46,008 0.974 $ 48,478 Receotionist 1.000 22,616 1.000 23,596 Total 1.974 $ 68,624 1.974 $ 72,074 o o o o o CITY OF ANDOVER Expenditure Budget Worksheet Budget Year 2000 12/30/999 :11 AMWCLERK.XLS CITY CLERK DEPARTMENT # 41400 General Fund Object Actual Actual Actual Budget Request ~ 1S.96. ~ ~ ~ 2QOO Personal Services , 101 Salaries $ 60,507 $ 59,801 $ 63,999 $ 68,624 $ 72,074 121 PERA 2,606 2,734 3,329 3,555 3,733 122 FICA 3,516 3,629 3,802 4,255 4,469 125 Medicare 823 879 889 995 1,045 131 Health Insurance 3,679 3,675 4,020 4,500 4,500 132 Dental Insurance 252 255 307 245 497 133 Life Insurance 39 16 16 97 327 :i:::::::!::::::i::::.::::::::::::::::::i.~~i~iJ::iii::i::i:':::::;:i::ii,::ii,::i:::::::;:i:::'i:':,:;::'::!i::':,'~:'::1:::::.::"!j~~!~~lli::~:::::::::::::~:~~i~~~:::::::~,:::::::!!~~::::::~:::1::::::::I1?!t~::::::::~,~::,~~~': SupDlies and Materials 201 General Office Supplies $ 464 $ 1 ,478 $ 654 $ 480 $ 500 210 Operating Supplies - 5 226 - 25 ................. .. .. .. .... Purchased Services 322 Postage $ 48 $ (21) $ - $ 50 $ 50 330 Transportation 238 176 120 300 300 351 PublishinQ 43 184 68 50 50 !1:1:..:i:.~:...:1~i:.:, Other Services and CharQes 406 Contractual Services $ - $ - $ 1 ,488 $ - $ - 415 Equipment Services - - 298 330 350 433 Dues/Registrations 867 467 378 520 1,035 o o .0 CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This division provides for the registration of voters and also conducts all elections according to local ordinances and state law. Ct) ...J >< ~ LU LU :2 <( C\I .... Ol Ol Ol 25 ~ a: z w 0 >1-1- Ow::::> C(!J1Il ~~~ LLo- 000 ow >C\I(!J ~ <C (3 ~ d I- () UJ -I UJ 0 0 0 ~ Ol 0 Ol "l CO .... .... as ci .... C\I ! C') , C') w u. :i ! r-- , r-- ...J ~ Z W 0 ! 0 , 0 :J: C\I C\I I- .... .... ...J <I: w :J: I Ol , Ol .... .... 0 , 0 CO CO ~ r-- , r-- CO CO i ..q 0 ..q en ! Ol 0 Ol en C\I CO CO 0 ~ .... as c:ri' a: .... .... e" ~ l- n. Ct) ~ LU ...J 0 <I: 0 51 W ::::l 0 ::.:: ., I- ~ a: z 0 LU 0 Z ...J i= <C I- () a: ~ >- () t::: LU e" ...J n. () LU CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/999:12 AMELECTION.XLS o 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services City Clerk 0.026 $ 1,228 0.026 $ 1,294 Elections Judoes 0.000 - 110.000 18,600 Total 0.026 $ 1,228 110.026 $ 19,894 o o o o o CITY OF ANDOVER Expenditure Budget Worksheet Budget Year 2000 12/30/999 :12 AMWELECT .XLS ELECTIONS DEPARTMENT # 41 41 0 General Fund Object Actual Actual Actual Budget Request ~ ~ ~ 1998. nm 2QQO. Personal Services 1 01 Salaries - Regular Employees $ 1 ,323 $ 1 ,088 $ 1 ,1 77 $ 1 ,228 $ 1 ,294 1 03 Salaries - Election Judges 1 1 ,370 - 1 0,424 - 1 8,600 1 21 PERA 59 50 61 64 67 1 22 FICA , 782 65 68 76 80 1 25 Medicare 1 83 1 5 1 6 1 8 1 9 1 31 Health Insurance 1 23 98 1 07 1 20 1 20 1 32 Dental Insurance 8 7 7 7 7 1 33 Life Insurance 0 0 1 3 3 .... -- .... ..... ... .... .. ,-- .......... .. .... ........... ........... ................. .... ,...., ......... IiA!':and M<llIAri<lllc> 201 General Office Supplies $ 1 1 8 $ - $ - $ - $ 1 00 ~~1,~:lil:lil:l;:::::::::I::::::;::::::::l::IIIIi::I-:!:::":;11-:;]::::11II1 .n ...... ...... ............ ::: .... .............................. ..;.:.:.:........ ....................:.;.:. ... ... ...... ;.;.;.....;.:...:....... , Purchased Services 301 Professional Services $ 537 $ 21 0 $ 1 ,072 $ - $ 1 ,1 00 321 Teleohone 1 6 26 23 - - 322 Postage - - - - - 330 Transportation 45 - 26 - 50 352 Printing 1 24 - 1 04 - 1 30 41 0 Rentals 860 91 5 80 - - ::::::::::::::'::l:::::::l:l::::::lli~~i~II::::::::::::::1::::::::::::::1:::::::::::::~1::::::::::1~:~~1:i~:::::::::'~i.~~~:::::~:::::::::~.~l:::::~!:::::l!::::::::!::::::~:::::::::~~~~ I nUII<ll" 580 Equipment $ - $ - $ - $ 2,000 $ 1 0,000 o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The city administrator's department is the general administrative unit of the city government. As such, it supervises and coordinates all activities of city departments, handles citizen inquires and service requests, implements policies of the city, enforces all city ordinances and appoints city employees. This activity also prepares regular and special management reports and advises the council on policy matters. en ...J ><; ~ ~ :2 <( C\I ... a> a> a> (3 ~ ... a: z w 0 >. - 01-1- W::l Q<9a:l ~' Z 0 ii: ::ll- a:lcn LLo- 000 >~W I- ~ C3 ~ z o ~ Q :iE Cl <( C\I 00 00 CO , '<t "- 00 0 a> CO ~ C\I CO "- CO C') ~ a> r-:- r-:- cD ... C\I C\I "- I- I C') C\I ... "- , C\I C') "- ... ... C') ... W 11. ::i I co '<t Ltl 00 , C\I ...J "- CO C\I C') 0 ~ ... C') Z w e I CO C') C\I CO , "- :I: 00 0 CO C\I "- C') 0 '<t C') ... I- ... c;t) ..n ...J < W :I: I "- '<t C') ... , Ltl Ltl ... a> 00 '<t C') C') 00 CO '<t CO "- , C') C\I '<t a> '<t ... ~ Lll C':!. C') C') CO ... ... en Ltl C\I ... 0 , a> "- C\I C') a> ... II C\I ... C') C\I 0 ... ... en , a> 0 0 00 , CO en ~ ... "- a> a> "- en CO <<!. C') Ltl C\I 0 ~ ~- ... cD ..n cO a: C\I Ltl e Q I- a: e: ~ ...J ~ a: z < ~ U - a: b UJ I- UJ W >- a: z l- I- e a: a: 15 <( z Q I- ~ l- e ~ UJ Z UJ Z ~ UJ U ::J U < I- a: z 0 z a: ~ :2 u <( u <( e Cl UJ Z ~ Z C. <( en iI iI CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/999:12 AMADMIN.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Administrator 0.300 $ 22,795 0.300 $ 24,619 Finance Director 0.100 6,606 0.100 6,390 Accountant I 0.150 4,981 0.150 5,598 "linance Intern 0.000 - 0.000 - Secretarv 0.670 20,421 0.650 21,670 , Total 1.220 $ 54,803 1.200 $ 58,276 o o o o CITY OF ANDOVER Expenditure Budget Worksheet Budget Year 2000 12/30/999:13 AMW ADM I N .XLS ADMINISTRATION DEPARTMENT # 41 430 General Fund Object Actual Actual Actual Budget Reauest ~ , 1992 199Z ~ 1999. 2000 Personal Services 1 01 Salaries $ 48,270 $ 57,227 $ 51 ,594 $ 54,803 $ 58,276 1 21 PERA 2,1 31 2,41 7 2,647 2,839 3,01 9 1 22 FICA 2,859 3,597 3,21 3 3,398 3,61 3 1 25 Medicare 669 849 768 795 845 1 31 Health Insurance 3,257 3,627 3,531 4,698 5,1 77 1 32 Dental Insurance 283 332 302 . 307 302 !:!!::i:;i::::::::!!~\iiiii:~i::::!::::!!::::::!::::::::::!::!::::::::::!:::::!:~~i~~~:!~!:~!::!!i~~~:::I:!!::::!:~~,;!!~!::!:I~::::~!i.i!~::!!!:::::::~,!~::i,~!: ~nd Materials 201 General Office Supplies $ 2,060 $ 2,931 $ 1 ,623 $ 2,000 $ 2,000 21 0 Operating Supplies 1 79 2 1 25 , 1 50 1 50 220 Repair/Maint. - Supplies 360 297 298 350 350 :::::::::~!!!!::::::~::;~!:::::I,II!!!:::!:!::!:::::::!:::::::!:!::::!I!:~:::::::~I!!I::I::::!!:::::e!!!~::1:::!!~!::~!~~!;::~::::~~~:~:~\~!:::::I':::!::::::~i!!: Purchased Services 301 Professional Services $ 5 $ 21 0 $ - $ 1 75 $ 1 75 321 Telephone 469 603 51 7 600 600 322 Postaae 544 784 706 81 0 800 330 Transportation 1 ,524 1 ,553 2,01 1 1 ,81 1 2,000 351 Publishing 1 6 44 76 1 00 1 00 1:::::!!i!li::!:!J:li:iiliil:!::::::::!!::!::::!::::!:: !:!::::::!::!:I::IIIII::I!IIII!!:":!I:::IIIII:::!:::M::I Other Services and Charges 401 Repair/Maint. - Labor $ 1 65 $ 57 $ 59 $ 1 50 $ 1 50 41 5 Equipment Services 500 754 745 845 875 41 6 Computer Services - 255 - - - 433 Dues/Reaistrations 2,963 1 ,883 1 ,348 790 51 0 442 Meals/Lodging 396 294 1 ,277 1 ,452 1 ,01 5 443 Continuing Education - 75 1 1 09 81 5 51 0 :::::::::::::::;:::::;::::::I::::::;RIIII:::::I::::::::;:::::l:;;:::::::::::::::::~~~:::!!~i~l:l:~:!:l::::;:~;~~:~:::!~~:::::::::::~!~~!::l:~::::::~:~:~~~~ff:~~~:::::~:!::::::::~~~~~l: " , .' '<:" '<'"W ill, " .' " " ., , , ow. , " ^ ", .;-:- , .. o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This division is responsible for administration of the city's financial affairs. This includes maintaining accounting records for all operations, custody and investment of funds, supervision of revenue collection and disbursement of city monies, administration of debt, payroll function, purchasing function, audit and budget preparation. This division is also responsible for administering the I) personnel program and 2) insurance program for all City departments. The personnel duties include keeping current with and updating when appropriate benefits, pay plan, personnel policy, affirmative action, job classification, recruitment, interviewing, final hiring selection, new laws and regulations affecting personnel, job descriptions current to insure they meet ADA requirements and administering wage and salary programs. Insurance program duties include administering the municipal liability, property, workers' comp, and employee group insurance programs. en ...J ~ OJ z iI I.L. ~ <C r--- T"" 0'> 0'> 2l ~ T"" a: c LU 0 0> Qj:;:::; o)::s ~eZ~@ - - al.!!! Ooe >8 ~ ~('I,IClS C3 :s: ~ <C Z iI ~ 0 0 0'> C\I T"" C\I 0 , l!) '<t co 0'> <Xl l!) 0 co 0'> ~ l!) C\I l!) T"" l!) 0'> C\I C\I_ as cO ci N t ..; ..; T"" C') l!) C') C') T"" 0 I- C\I I l!) '<t l!) r--- T"" T"" T"" 0 C') l!) 0'> <Xl r--- co '<t T"" C\I W '<t I.L. ::i ! co '<t '<t co 0'> l!) l!) 0 0'> ...J C\I T"" 0'> r--- C') (j) C\I co ~ T"" C\I T"" T"" T"" (j) Z W 0 I 0 r--- r--- '<t '<t C') C\I 0 r--- :J: T"" C\I l!) C') (j) C') co T"" C') (j) l!) C\I T"" t-;, '<t '<t I- C\I- M M M cO ...J T"" T"" <C T"" W :J: I C') 0'> '<t (j) <Xl <Xl 00 , <Xl co co '<t co (j) co '<t l!) '<t co C') C') C\I T"" C') N T"" (j) T"" r--- C') co r--- , C') 00 l!) r--- r--- r--- T"" 0 <Xl ~ (j) <Xl "t l!) C\I_ r--- C\I 0 T"" N T"" T"" T"" ci T"" l!) <Xl (j) r--- C') <Xl C') , '<t ~I l!) <Xl C\I T"" co (j) r--- C\I co C') C\I_ C') q l!) T"" '<t T"" C\I- T"" T"" T"" as 0 (j) 0 C\I l!) C\I '<t , T"" en ~ l!) 0 C\I C') C\I l!) C') C\I en (j) T"" r--- '<t l!) l!) C') co 0 T"" cO M Lti ci T"" M N ~ C') '<t C\I C\I C\I T"" co a: T"" 0 ~ - - - I- a: ~ ~ ~ D. a: a: a: ~ O. LU LU LU ...J I- ...J ...J ...J Z <C () () () - () a: I- LU e!} e!} l- e!} LU 0 W a: a: z z z z >- l- I- 0 '. <C Z Q LU i= i= I- i= a: 0 ~ a: ~ LU :::l Z Z Z Z LU Z () en :::l :::l :::l :::l LU () <C I- Z <C 0 0 0 0 a: z a: g <C LU () () () () () <C 0 Z a: () () () ~ LU Z D. iI I- <C <C <C en iI CITY OF ANDOVER EMPLOYEES 1999 BUDGET 12/30/999 :17 AMFINANCE.XLS Qf 1999 BUDGET '1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Finance Director 0.450 $ 29,727 0.500 $ 31,950 , Treasurer 0.850 44,393 0.850 46,109 Accountina Clerks III 1.550 53,931 1.470 49,152 ... .... . ~ccountina Clerk I 0.500 11 ,701 0.330 11,552 ,--c- Secretarv 0.100 3,048 0.100 3,334 Accountant I 0.550 18,264 0.550 20,525 Finance Intern 0.000 - 0.000 - Total 4.000 $ 161,064 3.800 $ 162,621 o o o <<0 CITY OF ANDOVER 12/30/999:18 AMWFINANCE.XLS Expenditure Budget Worksheet Budget Year 2000 FINANCIAL ADMIN. DEPARTMENT # 41 530 General Fund , Object Actual Actual Actual Budget Request ~ ~ 199Z 1998. .:1m MOO Personal Services 1 01 Salaries $ 1 1 7,071 $ 1 32,756 $ 1 34,476 $ 1 61 ,064 $ 1 62,621 ~ 1 21 PERA 5,069 6,050 6,984 8,343 8,424 1 22 FICA 6,828 8,1 37 7,995 9,986 1 0,083 1 25 Medicare 1 ,597 1 ,903 1 ,898 2,335 2,358 1 31 Health Insurance 9,446 1 1 ,230 1 1 ,572 1 5,426 1 6,41 7 1 32 Dental Insurance 763 91 9 857 882 969 1 33 Life Insurance 52 63 58 350 423 . ... ................. ...... .... ....:.:.: ,.;.".:.:.;.;.;.:.:.: ;.:.:.:.;. .. .. ...........................:.;.............;.:....... .......... ... ..... ....... ...................;.;.:.......;.:.;... "' ............ .." , " , l'Ind Ml'Itl'!ril'll~ ~ ~ _..--'/ 201 General Office Supplies $ 2,097 $ 3,441 $ 2,31 7 $ 3,442 $ 3,650 21 0 Operating Supplies , - 24 659 300 500 i!iiliiiiiiiii:!::i::!iil:i!i:l:i:i.!~I~I~ii:i:ii:ii:iiii!!i:::iiiiiii::iii!.iiili~1::!!:i!i:I~~~I::~:~::ii~i:ii~'~~l~~?i::iiii~iiii!iiii~i.!:~~:~:iiii!~::~~~~~::l:i~!iiii~:~l.~i?!:~:: Purchased Services 301 Professional Services $ 1 ,891 $ 1 ,500 $ 2,023 $ 2,000 $ 2,500 322 Postage 51 1 640 595 750 750 330 Transportation 629 61 9 670 650 750 351 Publishing 1 ,366 81 3 895 1 ,400 1 ,400 360 Insurance 1 05 - 1 1 5 1 21 1 27 Other Services and CharQes 401 Repair/Maint. - Labor $ 348 $ 1 51 $ , 54 $ 300 $ 300 406 Contractual Services - - - 200 200 41 5 Eauipment Services 1 ,200 1 ,81 0 1 ,791 1 ,982 2,1 00 41 6 Computer Services - 1 ,955 - - - 433 Dues/Registrations 2,1 56 1 ,1 44 923 500 805 442 Meals/Lodging 395 605 363 600 800 443 Continuing Education - 1 337 1 208 2 600 2 800 iiiili:i:I::::iiiiiil:!iiiiiiiRI!!!!!i:i::ili:il,i:iii:!iiiii:ii:~!iil:i!;ii~:::!:::i!:!~i.~~:!i:il!'iiii:i:i:i:?i~~liiiil~:::!::::i::i~~~~:l::i~iii!:ii!~~~f!iili:~~ii'!i!ii:i~!~g~i: Capital Outlay blU Office EqUipment :6 - :6 l:Sb;:l :Ii - :Ii 1,OUU ;j) <::,<::UU o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This department is responsible for all audit fees for the calendar year. o o o CITY OF ANDOVER Expenditure Budget Worksheet Budget Year 2000 12/30/999:18 AMWAUDIT.XLS AUDITING DEPARTMENT # 41540 General Fund Object ~ Actual .m6. Actual ~ Actual .1IDm Other Uses 301 Professional Services $ 9,425 $ 7,468 $ 7,420 $ 8,600 $ 9,500 :::::::I!::li:;!I::::I!I!llI11!:!:::~::I!::I:::I:::::1l:::::::::!:l::~:::::l:!::::!::!,:::!:~::::::~::!!::.:::~!!':::::!:::::::::!~~!!:::::::I:::!:::::::!~!!:::;::!~:::!::':!:~~!!::: o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This division is responsible for assessment for all real and personal property for valuation purposes. The City contracts with Anoka County for this servIce. o o o CITY OF ANDOVER 12/30/999:19 AMWASSESS.XLS Expenditure Budget Worksheet Budget Year 2000 ASSESSING DEPARTMENT # 41550 General Fund Ob'ect ~ Actual ~ Actual ~ Actual ~ Budget ~ Re uest 2QQQ Other Uses 301 Professional Services $ 69,799.24 $ 68,914 $ 75,197 $ 76,000 $ 78,336 !1::::!1::~::::::::::1::::::::::::::~~!!11~:::1::'1::::!::::!::':::::::::'::i:::::::::::::~:~!!i~!!~~!!::::!I::::!!:::::~!~~~!:::::~:::::::!!~~~~::i::i::!::::~::~::::~!~!!~!:::i:~:::::'::':!!i.~: o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The legal department supports legal services required by the city. The city attorney advises the city council and city departments in all legal matters relating to the operations of city government, prepares all contracts, ordinances, legal opinions and other legal documents required by city staff or council. In addition, the attorney appears on the City's behalf before any court or administrative body in the prosecution or defense of all proceedings in which the city is a party. o o o CITY OF ANDOVER 12/30/999:19 AMWATTORNY.XLS Expenditure Budget Worksheet Budget Year 2000 ATTORNEY OBJECT # 304 General Fund Ob"ect ~ Actual ~ Actual jj9z Actual ~ Other Uses 41610 $ 922 $ 5,027 $ 4,570 $ 5,000 $ 41611 837 2,488 281 5,000 41612 81,630 78,334 81,361 84,000 41613 13,092 11,012 8,719 12,000 41614 2,925 1,066 3,312 1,500 41615 Attorney - Fire Department 400 ::!::::::::!!::!!!:::::::!::!::!::!:~!llil!:::!!::::::::::::!;::::::::::!:::::::::::!:::~:::!::::~~~P!!!::!!~::::!!:::~~~~~~:::!:::~:::::::::::~~f!~~:::!::~:::::::~~:~!~~~~!::::::~::::~:~~;~?:9: 5,600 1,000 86,520 12,000 3,000 o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The Community Development Division is comprised of Planning and Zoning, Protective Inspections (Building Department), Housing and Economic Development. The primary function or role of this division is to coordinate development projects and activities within these departments as well as with other departments of the City. o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This division reviews and amends zoning ordinances, reviews and updates the Comprehensive Plan, monitors Metropolitan Council Policies, enforces codes and provides assistance with development. The division is also responsible for administering the Community Development Block Grant Program, monitoring and administrating Housing programs, Economic development, Redevelopment and other Communities Development related programs. CITY OF ANDOVER 2000 WAGE WORKSHEET 12/30/999:19 AMPPLANING.XLS to GROSS HEALTH DENTAL LIFE WAGE PERA ~ MEDICARE INSURANCE INSURANCE INS;IIR4N~E TOTAL POSITION DESCRIPTION COMMUNITY DEV. DIR. 34,250 1,774 2,124 497 2,402 131 57 41,235 ZONING ADMINISTRATOR 38,377 1,988 2,379 556 4,620 252 110 48,283 SECRETARY 30,041 1,556 1,863 436 2,171 252 110 36,428 INTERMEDIATE PLANNER 40,593 2,103 2,517 589 4,620 252 110 50,783 PLANNING COMMISSION 4,160 - 258 60 - - - 4,478 PLANNING INTERN 9,620 - 596 139 - - - 10,356 ORAND TOTAL 157,041 7,421 9,737 2,277 13,813 887 387 191,564 o CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/999:19 AMPLANNING.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Communitv Develooment Director 0.520 $ 31,744 0.520 $ 34,250 Zonina Administrator 1.000 35,893 1.000 38,377 , Intermediate Planner 1.000 34,241 1.000 40,593 !O-etarv 1.000 27,464 1.000 30,041 , Plannina Intern 0.500 9,256 0.500 9,620 Plannina Commission 4,160 4,160 Total 4.020 $ 142,758 4.020 $ 157,041 o o o o CITY OF ANDOVER 12/30/999:20 AMWPLANING.XLS Expenditure Budget Worksheet Budget Year 2000 PLANNING & ZONING , DEPARTMENT # 41910 General Fund Object ~ Actual 199!i Actual ~ Reauest ~ Actual ~ Budget ~ Personal Services 101 Salaries $ 87,902 $ 110,102 $ 119,617 $ 138,598 $ 152,881 106 Salaries - Commission 1,965 2,055 2,100 4,160 4,160 121 PERA 3,498 4,982 6,239 6,700 7,421 122 FICA 5,114 6,661 6,951 8,851 9,737 125 Medicare 1,196 1,558 1,626 2,070 2,277 131 Health Insurance 3,882 8,222 11,591 15,117 13,813 132 Dentallnsurance 642 672 913 887 887 133 Life Insurance 43 60 59 352 387 ::::::!!!:!:~::~i!:!:!:!::I!!.::ii!:!::::::::::::::!:::::::::!:::::::::::!::!~!:::!!:!::!::!!i;~!:~!!~::!::!:!!i~~:~:::::::~::::!!!!~!l::::I::!!!:!~:!~~!~!!::::~:!::::::~j~!:j!~: ISunnli~!'l and Mat~rial!'l: 201 General Office Suoplies $ 2,452 $ 5,748 $ 3,767 $ 5,000 $ 5,000 210 Operating Supplies - $ - $ 251 $ - $ - ::i:::::i::!:!:::::::!:!!:::!!!!!ll::::::!!::::!::::;:i:::::::::::~::::::~I:~::!:::::::~:::~:~r:!?~::::!~::::'!!::~::!!i!:~~:::::~:::::~!~~:!::::::I:::::::::::::!:~!!~?:!:::!:::::!!i!~::: Purchased Services 301 Professional Services $ 2,449 $ 3,137 $ 1 ,885 $ 3,000 $ 3,000 322 Postage 734 1,033 941 1,200 1,200 330 Transportation 69 98 49 200 200 351 Publishing 3,739 6,701 3,564 6,000 6,000 1:::l:ili:~1!111::~:[~!ilii!::1!:::::::::::::::::!::::::::::1~'~:::~::_:1::"'::!:_::~::::_:1:::_11 Other Services and Charges 401 Reoair/Maint. - Labor $ 254 $ 89 $ 92 $ ,300 $ 300 415 Equipment Services 1,100 1,659 1,642 2,268 1,925 416 Computer Services - 1,530 1,530 - 431 Recording Fees 429 1,012 400 1,000 1,000 433 Dues/Registrations 951 1,386 844 2,500 2,500 435 Subscriptions 50 - - 250 - 442 Meals/Lodging 167 322 321 200 500 443 Continuing Education - 138 - 1 400 1 400 !':l:!li::i!::l:!::!;:::llllljll:l::::::l:!:::::~:::;:::::::::,:::::::::::::::l~:~:~l::::::::!:l:::~j~~~::::ll:!~!~:":!!ii~:~:l:I:::!~::::::'~i.~:!:::l~l::!!::::::!ll~i!~:~i:::l:l:l:i:;:i!:i,:11i.1I!: Capital Outlay 570 Office Equipment $ - $ 7,520 $ - $ - $ 1,000 o o 4t CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The Data Processing department is to provide assistance to computer users within the City. It shall coordinate the continuing development of a comprehensive City wide information system which provides timely, accurate and meaningful data for program monitoring, decision-making and operational systems required for the effective completion of specific organizational objectives. This department also installs and maintains hardware and software. (J) ...J X 01 o o ~ <( o '.'! en en ~ ~ .... o o ~ ~ v co ..... .n- co .... .n- .... i , W LL ::::i ..J I , ~ Z W 0 ::J: I , ~ <C w ::J: I .... .... .... C\I .... C\I , C') , 0 C') ~ en 0 en , il (IJ 0 0 ! CO (IJ In CO 0 -.f In IX: ~ .... -.f ~ .... ~ l- e. ~ ...J <C w b 0 I- ~ 0 Z I- <C ~ IX: (J) ~ ~ CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/999:20 AMDATA.XLS Q 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services MIS 0.000 0.500 $ 14,560 Total 0.000 $ - 0.500 $ 14,560 o o o o -0 CITY OF ANDOVER 12/30/999:21 AMWDATAPRO.xLS Expenditure Budget Worksheet Budget Year 2000 DATA PROCESSING DEPARTMENT # 41920 General Fund Obiect Actual Actual Actual Budget Request ~ 1992 1m ~ ~ ~ Personal Services 101 Salaries $ 14,560 121 PERA - 122 FICA 903 125 Medicare 21 1 131 Health Insurance - 132 Dental Insurance - 133 Life Insurance _ ~ i and Materials 201 General Office Supplies $ 7,290 $ 9,342 $ 7,378 $ 9,500 $ 9,500 207 Training 105 231 - 1 ,000 1 ,000 220 Repair/Maint. - Supplies - 28 474 300 300 301 Professional Services 19,316 28,804 32,505 45,000 45,000 322 Postage 209 (45) - 300 300 330 Transportation 21 80 17 150 175 401 Repair/Maint.-Labor 198 175 50 200 200 418 Maintenance Contracts - - 2,063 9,800 10,300 433 Dues/Registrations 298 279 120 300 300 434 Technology Upgrades - , - - - 15 000 .................................... .. ........................ ....................... ............. ......... ... .... ........ Capital Outlay 570 Office Equipment $ - $ 4,904 $ - - $ 15,000 580 Equipment - - 2,245 - - ~"1 .....1 . ',.lli%.'" .. . ... . . . . . :.... : :... ~. $.::::.... .. . .." ... . . , , o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This function provides primarily for maintenance and operation of the City buildings. o o o CITY OF ANDOVER 12/30/999:23 AMWBLDGHAL.XLS Expenditure Budget Worksheet Budget Year 2000 CITY HALL BUILDING DEPARTMENT # 41 940 General Fund Object Actual Actual Actual Budget Request ~ 1996. 199Z 1i9a 1999 200Q SlInnlies ~'"... M",tAri"'I" 201 General Office Supplies $ 34 $ 25 $ - $ - $ - 21 0 Operating Supolies 769 1 ,558 2,608 1 ,700 2,000 21 1 Cleaning Suoolies 984 927 1 ,495 1 ,300 1 ,500 220 Repair/Maint. - Supplies 614 878 462 1 ,500 1 ,500 223 Repair/Maint. - Building 1 ,51 1 1 ,490 1 ,249 2,000 2,000 ::::::;:::::::I::::l::::.:.!~p~I~::,:ll'::::::::::::::::'::::::::::::~:::::::!,:;::::~!~~~:::::;::!:'::::i,::::.:::!!~::i:,::_::j!:_::1 Purchased Services 321 Telephone $ 1 2,725 $ 1 6,063 $ 1 7,1 1 8 $ 1 7,000 $ 1 7,000 360 Insurance 2,500 2,700 5,670 5,975 6,1 54 381 Electric 6,91 9 8,1 71 1 0,377 9,000 1 0,1 60 382 Water & Sewer - 61 7 1 ,71 3 800 1 ,600 383 Natural Gas 2,440 2,427 2,456 4,000 4,000 384 Refuse Collection 961 683 730 1 ,500 1 ,500 - - - - - Other Services and Charges 401 Repair/Maint. - Labor $ 1 ,648 $ 240 $ 723 $ 5,000 $ 2,500 402 Reoair/Maint. - Building 2,009 767 1 ,533 4,500 7,000 406 Contractual Services 4,41 7 6,1 21 1 1 ,605 1 2,975 1 2,975 41 0 Rentals 61 1 688 606 650 650 :::::::::::::1:::::::::::::.111111:::::::::1:::::::::1:::::l::::!:::::::!::~!~~:::;!:!:!:!::~i.~~~::l:::~:::!~:!i!~::!::'::!::~):~~?:::::::~:::::::~~~~?:! Capital Outlay 51 0 Land $ 1 0,1 29 $ - $ - $ - $ - 580 EqUipment , - 4,/oU HHI - - o o o CITY OF ANDOVER. 12130/999:24AMWFIRESTN.xLS Expenditure Budget Worksheet Budget Year 2000 FIRE STATION B LOG DEPARTMENT # 41 950 General Fund Obiect Actual Actual Actual Budget Request ~ ~ 1m ~ ~ .2OgQ ISuDDIi"''' ....r1 ~ials 21 0 Operating Supplies $ 56 $ 1 52 $ 774 $ 600 $ 600 21 1 Cleanina Supplies 84 256 - 600 600 220 Repair/Maint. - Supplies 1 09 791 665 1 ,500 1 ,500 223 Repair/Maint. - Building 1 ,350 21 5 521 3,000 3,000 !:::;::!:::l::::::::::::::fj!:::::~:.!~I~!I:::!:::::!::l:!l::::!:::::::::::::::':::~l:l:::::;!~~~:::~!:::!::::~:~!~.~::::::l~::::::::::::~::I.~~::::,!::~l:!::l::I~~::!:::~~::l::::::~~~i: Purchased Services 321 Telephone $ 5,403 $ 5,993 $ 6,552 $ 6,600 $ 6,800 360 Insurance 5,400 6,000 6,300 6,750 7,000 381 Electric 1 0,867 1 0, 1 85 8,605 1 1 ,000 1 1 ,000 382 Water and Sewer Service 1 ,01 0 1 ,726 2,874 2,000 2,500 383 Natural Gas 1 0,51 9 9,1 29 6,204 1 1 ,000 1 0,500 384 Refuse Collection 908 91 8 920 1 ,200 1 ,200 :::::::::::::::::::I::::I:l::I,:::.I!I~I~l::::::::l:::l:::::::'::::::::::l::~:::::l:I!!~~~~!l::[~!:::!!:~~~J~r~:::::::~':'!::~:!~;~!:.:::::~'!~!!:::~lrll::l::~:::::::!~~!!:' Other Services and Charges 401 Repair/Maint. - Labor $ 1 85 $ 763 $ 907 $ 1 ,500 $ 1 ,500 402 Repair/Maint. - Building 4,732 882 3, 1 46 2,500 2,500 406 Contractual Services - 6,61 2 4,529 5,500 5,500 o o o CITY OF ANDOVER 12/30/999:24 AMWPWBLDGXLS Expenditure Budget Worksheet Budget Year 2000 P.W. BUILDING DEPARTMENT # 41960 General Fund Obiect Actual Actual Actual Budget ReQuest ~ ~ ~ 1B ~ ~ "'.._, lies an~i"l,," 210 ODe rating Supplies $ 861 $ 788 $ 2,003 $ 3,097 $ 3,500 211 Cleaning SuDDlies 442 569 2,194 3,103 3,103 220 Repair/Maint. - Supplies 296 224 3,055 1,500 1,500 223 Repair/Maint. - Building 2,870 6,319 8.710 10,499 10,500 1:;l::::ii:ij::::::r!!:I;il:~:iil'!I!:;::::::::::::::::::::;:!::::;ij::::!;:::::,::':::::::i:::--:~;:_:;I::_::!:_:::i:~:-~I ..' ...... .... .... ..... .....:::........ .... ....... .... ........ . ........... .....~......... Purchased Services 321 TeleDhone $ 7,795 $ 8,697 $ 9,157 $ 10,000 $ 10,000 360 Insurance 1,550 1,700 3,500 3,800 4,200 381 Electric 4,840 3,387 12,416 8,000 10,000 382 Water and Sewer 383 203 3,038 2,100 3,000 383 Natural Gas 2,594 2,402 7,823 11 ,999 12,000 384 Refuse Collection 2,742 3,137 ,... ?!,~~~.. ' . 3,000 3,009, .. .... .... .. .... ... ........ .... ............ ......... .................................... .. .......... ....... ...... ....... ....... ....... ... .... Other Services and Charges 401 Repair/Maint. - Labor $ 517 $ 858 $ 4,908 $ 4,000 $ 4,000 402 ReDair/Maint. - Building 2,921 5,835 4,025 6,539 7,000 406 Contractual Services 619 1,368 6,738 8,181 9,000 410 Rentals 416 921 1 ,443 500 500 I:::!::!jli::i:!~:!:!l!i~[~il~!l:::::::::::::~~:::::::::!:::~:~::.::.:'!~::::::::.~::~:i_jll.~-::i::l_:~::::-:::1:::-::1 Capital Outlay 530 Improvements $ 15,051 $ 5,490 $ - $ - $ 2,000 570 Office EquiDment - 3,604 688 - 13,000 580 EquipmentuNN,NN~,~~5u. ':'u NN ... - . ':'u.uu ....N ,.~,. li~::::i~!II:ilj:::':::::I~iiii::iiii~\illl!!:i:i:!:i,i::::::i:!'::i::::::~:!::::::::i::i::i!::::!j:!_'l~:::_i:~!:_iili:i_!I,ii_:i' :.:. .... . ~... . .. ... ........ ......... ......... ......... ..... .............. ... ... . ... . .... .. . .. .. . ..... ............. UeDt, I 601 Principal $ - $ - $ 35,000 $ 40,000 $ 45,000 611 Interest - - 130,780 130,025 128,165 ~ o o o CITY OF ANDOVER 12/30/999:24 AMWSRCNTR.XLS Expenditure Budget Worksheet Budget Year 2000 SR. CITIZEN CENTER DEPARTMENT # 41970 General Fund Object Actual Actual Actual Budget Request ~ ~ 199Z 1998 ~ 200Q ~Ii..., "nd Materi::tl!': 210 Operating Supplies $ - $ - $ 209 $ 300 $ 300 211 Cleaning Supplies - 280 - 300 300 223 Repair/Maint. - Building - 152 244 200 200 Il:::::::::::::l::!:!!:::!~~1!:::::lil!~!~II:::::j::::l::!::~':I:::~:::::,::!::::!:I~::.I:I;I::::;llll.I:_:I::iiiii!::I:~~::!!'!::~::!!j~::!~~:::~:::~!'ij:.~~:::::::::::::::~: Purchased Services 321 Telephone $ 746 $ 715 $ 710 $ 800 $ 800 360 Insurance 2,062 2,200 2,310 2,430 2,503 381 Electric 2,965 2,266 2,469 2,600 2,600 382 Water and Sewer - 154 369 200 380 383 Natural Gas 610 607 614 850 850 384 Refuse Collection 301 236 255 400 400 ................................ ,'.:. ..... ..... ....... 0- ......... ........ Other Services and Charoes , 401 Repair/Maint. - Labor $ 64 $ 97 $ 72 $ 600 $ 600 402 Repair/Maint. - Building 245 325 - 700 700 - .......... o o o CITY OF ANDOVER Expenditure Budget Worksheet Budget Year 2000 12/30/999:24 AMWEQUIP.xLS EQUIPMENT B LOG. DEPARTMENT # 41 980 General Fund Object Actual Actual Actual Budget Request ~ 1ia6. 199Z 199.a 1a99. 2QO.Q ~ i and~ials 220 Repair/Maint. - Supplies $ 1 38 $ 221 $ 1 ,550 $ 500 $ 500 223 Repair/Maint. - Building 71 51 1 993 500 500 :!::::l:::::::I:::::I:::::::::::::U!tl!!I:::::::::;:::::::::::l::::!:::l::::!:::::::::~:::::::!!!'!!:~:::::::~!:;"!:::::::::!!~;::~::::::::::!;~!!:l::::~!:::!:::~::!!!~:;l~:::!:::~!~!:l Purchased Services 360 Insurance $ 1 30 $ 1 40 $ 1 75 $ 200 $ 206 381 Electric - - - 1 ,000 1 ,500 382 Water and Sewer - - - 1 0,000 1 0,000 383 Natural Gas 2,362 1 ,848 849 2,550 1 ,700 ::'!::~:::;:::::I:::::::::::;::I:::Ii,~!itil:::!:::::::1:::!::!:::!:I!:::::::::::!::::,:~::!'!::::I~~~::!:::~::::1:::::::,~1.~~1::::~::!::::!:::!:!::!!:::~~'!:1:::!::!:!!~~!!~!:::I::!l:::!!:~I.~!~:: Other Services and Charges 401 Repair/Maint. - Labor $ 1 46 $ - $ 299 $ 500 $ 500 402 Repair/Maint. - Building 1 50 - 51 5 900 900 1:::!l:::::l::::!:::l:::l::l~:l:l:I!!~I~!~!::::::li::::ll::::!::::::i::'l::l::::::::::::llj::_::l:::_l;):::_:1:1-::1:::-::1 Capital Outlay o o o ~ CITY OF ANDOVER 12/30/999:24 AMWHGARAGEXLS Expenditure Budget Worksheet Budget Year 2000 CITY HALL GARAGE DEPARTMENT 41990 General Fund Actual ~ Actual 1fm. Actual ~ Bud et Request 1.99i .2.QOO $ $ 10 $ 3 150 Purchased Services Insurance Electric Re air/Maint. - General Repair/Maint. - Building $ 217 $ 213 250 $ 564 300 $ 203 325 $ 900 o o Q CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The Engineering Division is responsible for the design and construction of the City infrastructure and the physical facilities of the city. This includes preparation of plans and specifications (or supervision of plan preparation if consulting engineers are used) and construction management of contracts awarded by the coundl for public improvements such as paving, storm sewers, sidewalks, etc. C/) -l ><; d LlJ LlJ ~ <C L() ~ 0"> 0"> 0"> (3 ~ ..... a: UJ ~ o 0: o ~ (3 Cl c: Q '0 c: LlJ c o - ,- (I)- el,S "C .- :2'::: m.l!! 00 0(1) Oel C\leu 3= , ex> ..... 0 ..... 0 ...... ..... CO CO 0"> , 0"> ~ 0 C\I CO 0 C\I 0 ..... ..... 0"> ...... ..... 0 0"> 0"> 0"> C') ..... C\I ..... CO ..... "" C\i cD as C\i ai r-: M M cD M M ex> C') L() C') "" "" ..... C') C') I 0 0 0"> L() , ex> L() 0 ...... 0"> , C\I ..... CO 0"> ex> ex> ex> L() ..... 0 ..... CO W u.. ::i I C\I ex> ...... "" , C\I "" C') ex> 0 , ex> -l L() C') C\I 0"> 0 0"> ..... C') C\I ...... ~ C\I ..... C\I ..... C\I ..... ..... C') ..... Z w e I 0 C\I ex> C\I , CO ...... ...... CO 0 , ...... ::J: C\I 0"> L() ...... 0"> L() ...... C\I ...... CO CO ..... ..... <<1. CO L() 0"> C') C') L() ~ .,f ..... .,f ..... M M 0 <C C\I W ::J: I 0 ...... 0 ex> CO "" CO "" ..... CO , ..... 0"> L() 0 0"> C\I L() 0 L() ex> C') 0 0"> "" ...... C') ..... L() L() ..... 0 .,f C') C\I C') ..... ...... 0"> "" ex> ...... C') , !:; C') L() en 0 C') CO CO L() "" L() ~ C\I 0"> en ...... L() C') ..... CO C') ..... ..... .,f ..... C\i ..... C\i C\i ...... ..... CO ..... ..... ..... , 0 ex> 0 0 ex> , ~ C') C') 0 ~ ex> 0 L() 0"> C\I i L() <<1. L() ~ ex> L() C\I ..... ex> M ..... C\i ..... ..... ..... M ..... ...... 0 ..... ..... ex> ex> ex> L() ex> "" , 0 en 2 co 0"> ex> C') L() ..... 0"> ..... 0"> co C\I en C\I ""- C\I "" co C\I ex> co L() "" 0"> 0 as ..... as r-: as as .,f 0 L6 C\i L6 co C') "" C\I C') C') ..... ...... a: C\I CJ ~ a: - I- LlJ :.::: Q. LlJ a: 6 - >- LlJ ..J CD a: a: -l <C <C I - () b z LlJ C/) I- W LlJ LlJ I- Z "" "" z CD Z LlJ :.::: z l- e a: I- a a: a: :::c :::c a: <C i= z ~ z () LlJ () () LlJ I- a: e LlJ ;:: I- Z Z LlJ Z LlJ Z LlJ LlJ LlJ -l LlJ C/) 6 l- I- () ::> ::> I- <C ~ Z !;!2 0 0 z a: a -l d d d d C/) ~ CD () () C/) CJ z C/) z z z z z ~ () Q. LlJ <C () LlJ LlJ LlJ LlJ LlJ <C CD CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/999:25 AMENGINEER.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Enaineer 1.000 $ 64,481 1.000 $ 68,267 Assistant Enaineer 0.549 30,130 0.549 31,490 Civil Enaineer 1 1.000 53,152 0.900 48,281 C lnaineerina Secretary 1.000 32,488 0.750 27,431 Enaineerina Interns 0.500 9,256 0.450 8,658 Engineerina Tech 4 1.000 46,330 0.800 38,218 Accountant 1 0.200 6,642 0.150 5,598 Enaineerina Tech 4 1.000 44,750 0.750 34,898 GIS Intern 0.000 - 0.500 - Enaineerina Clerk 0.500 9,301 0.425 10,615 Accountina Clerk III 0.08 2,464 o Total 6.749 $ 296,529 6.354 $ 275,920 o o o CITY OF ANDOVER 12/30/999:25 AMWENGINER.XLS Expenditure Budget Worksheet Budget Year 2000 ENGINEERING DEPARTMENT # 42000 General Fund Object Actual Actual Actual Budget ReQuest ~ ~ ~ ~ ~ .2000 Personal Services 101 Salaries $ 163,074 $ 194,314 $ 252,444 $ 296,529 $ 275,920 121 PERA 6,917 8,552 12,542 $ 14,881 13,844 122 FICA 9,017 1 1 ,408 15,103 $ 1 8,385 17,107 125 Medicare 2,109 2,668 3,532 $ 4,300 4,001 131 Health Insurance 10,200 14,295 18,862 $ 28,033 20,567 132 Dental Insurance 681 860 1 ,254 $ 1 ,701 1 ,378 133 Life Insurance 64 77 96 $ 675 602 :::!,~::!11!::1!!::!!!!:1:!li1!::i!i!!.~I:!!i:l::i!:!:1::.!::!!1!!!:1!::!!!,:!!!!!:!!i!::I!::::~::::!:~i~~1:il::~!!:!!:~~~~:~~!l~~!::':~~!~~!::!:::!~~!~~jl:!!~::::~t!~~~~:!: 1~lInnIiA~ ::lIntfM::lItAri::lll~ 201 General Office Supolies $ 3,300 $ 5,782 $ 4,769 $ 6,000 $ 6,000 210 Ooeratina Suoolies 1 ,101 2,726 3,286 5,000 5,000 220 Repair/Maint. - Supplies 8 - 879 - - 240 Small Tools 160 645 1 ,341 5,000 5,000 258 M s for Resale 1 .....:::::;::::..::- ...... ..:.:.....:. ............. .................'....... ............ ..... .. ................... Purchased Services 301 Professional Services $ 238 $ 420 $ 605 $ 500 $ 500 317 Consulting Enaineer - Gen. 2,752 2,947 404 1 ,600 1 ,600 319 Consulting Engineer - St. Pr - - - 1 ,500 1 ,500 321 Telephone 852 2,1 17 3,046 2,400 3,300 322 Postaoe 618 1 ,001 919 1 ,800 200 330 Transportation 186 210 281 200 500 351 Publishing 33 1 ,365 1 ,745 100 2,000 360 Insurance 180 180 200 210 216 !:!!::!!!l:::I,!!l!!!!!!!I!!!!!I!!i1lti!~I!:I!:!::!!:!::iii::l:i:i:::l':::::!!!!i:!!!!l!!!l!::::::::!:::::~;~!!!!il~:::!:!::!!~~~!!!!!!~::!::::::::::~~~~::::::~:!::::!:::::~~!~~::::::::l'~:::::::!:::::~~~~:~:!! Other Services and Charoes 401 Repair/Maint. - General $ 546 $ 501 $ 365 $ - $ - 415 Eauipment Services 1 ,700 2,564 2,537 2,807 2,975 416 Computer Services - 5,100 3,500 - - 418 Maintenance Contracts - - - 3,500 4,000 431 Recordina Fees 39 - - - - 433 Dues/Reaistrations 1 ,933 2,833 3,541 4,000 4,000 435 Subscriptions 125 - 330 200 300 442 MealslLodaing 174 65 649 750 1 ,600 443 Continuing Education - 75 298 3 500 4 300 !':!:::!I!::!!:!!!!,!:::!!::,!:!!I:!!!I!!i!I~!!!,I::.!!,l::::!::'l:::::::::::~::::::::!':!::::!!::!!!:!!!:~!:1::::::::::::::!~i.~~!!~::::!!:I!i:11:!:i::!1~!~:~~:~i!!:I!!:~:::::::::'~:!:.~:::'::~:!:::!i:::!~i!~~!!:!l!::~:!::!l::~:~!~:g~!: o o o CITY OF ANDOVER 12/30/999:25 AMWENGINER.XLS Expenditure Budget Worksheet Budget Year 2000 Object ~ ENGINEERING (CONTINUED) I Actual ~ Actual 1m Actual 1998. Bud et 1999. Request ~ $ 11,500 $ o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET Civil Defense 1% CITY OF ANDOVER Summary of Public Safety Expenditures By Area 2000 Fire 30% Protective Inspection 16% 1999 Civil Defense 1% Fire 33% Protective Inspection 15% Animal Control 1% o o o I CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The mission of the City of Andover is to maintain the peace and the protection of the community through diligent enforcement of laws and effective response to calls for service. Police services are contracted through Anoka County and they fulfill this mission. CITY OF ANDOVER 12/30/9910:46 AMWPOLlCE.XLS Expenditure Budget Worksheet Budget Year 2000 o POLICE PROTECTION DEPARTMENT # 42100 General Fund Ob. ect ~ Actual 1996. Actual 199Z Actual 1998 Budget 1i9a Request 2QOO 201 General Office Supplies $ 21 $ 170 $ - $ - $ ::I;::ll:::::::::::Il~~!~!ll::::::l:l::::l:::::::::::!l::::::::::::::::~:::::!!::::::::~:::::::~~::::::jt::::~::l:~:::~l't:::~l::':::l:::::~::::~::::~:~::~~::::~:::~::::::::::::~::::::~:::::::!:::::::::~::::~:~: Purchased Services 310 Contract $ 568,922 $ 645,871 $ 719,670 $ 1,012,092 $ 1,062,430 :::::::::::::::::::ll::::l::Il!~!l!l:l::::ll:::::::::::1::::,:::!::::1:1:::::::::::~1:::::::::?~~1.~~~1::~::::~::::~1.~~~:!1::~::::::::::~1:~~~~::::::::~:::::1i~~:~!~~:::::~::::::1::!~~~!~~:: Other Services and Charges 460 School Liason Officer $ $ $ 51,555 $ $ ::l::l::l:I::::~::::l:Il~~i~!ll::::::::::::::::::::~::::!:::::::::::::~:!:::::::1~::~~::::::::~::::::::::1:::::f:!::::~::::?~:~~:::~:::::~:::::~~~~:~:~~~:~::~~~:~l::::::::::::!: o o o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The purpose of the Andover Volunteer Fire Department is to preserve and protect the lives, safety and property of the residents of the City of Andover from fire, accident, injury, natural disaster or exposure, and to assist when possible, our neighboring departments. C/) ...J ><; b ~ I'- ~ o ..... en 25 ~ ..... a: w ~Q) cO) ~ 08 ~~ u p a: iI: .... , en C':l co C\l en l!) l!) to C\l 0 I'- 0 ~ I'- ..... en en co l!) ..... ..... to l!) C':l ..... ..... C\l 0 C\l ..... I'- .... ~ ~ l!) C':l en l!) co C'5 C'5 cD .,f cD cD T'"" ..... N r-: al ci cD I'- .... ..... C\l C\l co en ..... T'"" ..... C\l i 0 , 0 0 , , , , , , I'- 0 I'- I'- ..... 0 ..... ..... l!) to I'- ..... ..... C\l I'- I'- en W U. :::::i i C\l , C\l .... , , , , , , co , co C\l ...J l!) l!) 0 C':l C':l .... ~ C\l C\l l!) l!) z W Q i T'"" , ..... C\l , , , , , , 0 , 0 C\l ::I: I'- I'- .... C\l C\l to T'"" T'"" C':l to to en l- N N .,f .,f ...I ct W ::I: ~ I C\l , 0 C\l I'- T'"" I'- C\l C\l 0 to 0 .... to to C\l co l!) en co C\l C\l en co ~ en I'- co l!) C':!, C\l C':l I'- ; T'"" T'"" N C'5 : i I .... , l!) en C\l T'"" C\l C':l C':l 0 I'- 0 I'- I'- I co C\l 0 ~ en I'- en en ~ to .... C':l .... ~ ~ to C\l en C':l C':l C':l .... C\l T'"" : C'5 N L6 T'"" 1'-- ci cD T'"" ..... ~ , en C':l , , , , , to I'- , C':l to l!) C':l C':l 0 .... I'- i I'- co to q C':l C':l. en cD T'"" as T'"" T'"" al T'"" , T'"" C\l 0 0 0 0 0 0 en 0 en ..... lf) ! C\l en T'"" 0 0 0 0 0 0 T'"" 0 T'"" C':l lf) ..... co C':l en C':l 0 l!) l!) 0 en 0 T'"" .... 0 ~ en L6 L6 C'5 cD cD T'"" T'"" ci L6 ci L6 ci a: l!) C':l en C\l C\l to to ~ T'"" T'"" C\l CI) 0: CI) UJ Z CI) III 0: 0: f- e w w UJ :c i= w w ~ ~ 0 11- ~ ~ 0: 0: u: ii: ...I ...I U. UJ 0: UJ ~ UJ ...J &l 11- ...J 11- !:!:! u. () UJ C- o: <( :5 ...J .~ :c UJ u: () CI) UJ u: I- <( W W :c ~ () :c u. u::: ~ () 0: ~ ~ C U. ...J f- () 0 u. ~ w CI) ~ W UJ UJ I- Z :5 UJ 0: ~ :5 z b 0 0 ::2 z UJ 0 Cl e :c <( ~ Z f- i= i= ~ z ;:: i= UJ I- Z i= () ::2 UJ a: z f- Z <( ...I 0: 1Il. t: UJ ~ Z ::::> CD Iii ...I UJ UJ () Ci5 ~ C- <C u. ...J => a: 0: 0: ::::> <C ~ :I UJ CI) <( ~ <( 0: <( g: 0 C/) CJ u. u: u: CI) 11- Cl () f- CI) ~ > CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/9910:47 AMFIRE.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Full-' Fire Chief 1.000 $ 55,462 1.000 $ 59,421 Fire Marshall 0.000 . 0.000 . Secretary 1.000 33,828 1.000 35,891 o Subtotal 2.000 $ 89,290 2.000 $ 95,312 Part time and Volunteers Assistant Chief 1.000 3,900 1.000 3,900 District Chief 3.000 6,300 3.000 6,300 Caotain 4.000 6,000 4.000 6,000 Trainina Officer 1.000 1,500 1.000 1,500 Safety Officer 1.000 1,500 1.000 1,500 Part time Insoectors 1.000 20,000 1.000 20,000 Maintenance Workers 0.150 5,599 0.150 5,919 Volunteer Fire Fiahters 50.000 120,000 50.000 120,000 Subtotal 65.150 $ 164,799 65.150 $ 165,119 - t~ ... Total 67.150 $ 254,089 67.150 $ 260,431 - o o o CITY OF ANDOVER Expenditure Budget Worksheet Budget Year 2000 12/30/9910:47 AMWFIRE.XLS FIRE PROTECTION DEPARTMENT # 42200 General Fund Object Actual Actual Actual Budget Request ~ 1996. 199Z 1998 1i9a 2QOO Personal Services 1 01 Salaries $ 69,283 $ 65,1 34 $ 76,894 $ 89,290 $ 95,31 2 1 02 Salaries . Volunteer 1 1 8,271 98,599 1 1 4,688 1 64,799 1 65,1 1 9 1 21 PERA 6,074 6,287 7,21 9 9,401 9,976 1 22 FICA 8,332 6,709 8,464 1 5,753 1 6,1 47 1 24 Relief Association 86,792 86,525 91 ,580 1 05,000 1 05,000 1 25 Medicare 2,584 2,252 2,732 3,684 3,776 1 31 Health Insurance 5,687 5,789 6,1 1 2 7,644 4,962 1 32 Dental Insurance 1 95 464 469 542 542 1 33 Life Insurance . 552 626 675 965 977 1 35 Physicals 1 ,674 2,495 3,734 4,000 6,650 1 51 Worker's Compensation 1 3,500 6,429 2,581 1 6,000 1 6,000 :,!:'!::::!~!~::::::!::::1:1:::::::::::.1~!~!1::::::!':1::::::::::::':::~:::::::::::::::::1:::::::::!:::::::'~~g!!!:!!I::':::::::::::::!~I!!!::\~~:::::!:!~~e~~!:::::I:::~:~::!~':!i.~!!::::::~!:::!!!!~!!: ISunnlies and Materials 201 General Office SuDplies $ 1 ,1 60 $ 2,060 $ 3,021 $ 2,000 $ 2,250 207 Training SupDlies 1 ,950 2,790 989 4,000 3,500 21 0 ODe rating SupDlies 1 4,531 1 4,997 1 7,888 1 7,000 1 8,000 21 2 Gas . Vehicle . 73 27 1 00 1 00 220 Repair/Maint. . SuDplies 631 2,734 749 3,000 3,000 __'11iill:1::::::::::::1'::':::::::::.:::.::.I:!I__~:::"::I!:~"':!.::IIdI::!::::"'::1 "':':';':';':':':.:.. .... ......................................... ....................... ..........:...................... '. ...... .... ::: Purchased Services 321 Telephone $ 1 1 3 $ 221 $ 832 $ 700 $ 750 322 Postage 232 293 240 350 350 330 T ransDortation 706 522 728 1 ,000 1 ,000 351 PublishinQ 1 03 61 4 609 750 750 352 Printina 398 1 ,031 362 1 ,1 00 1 ,1 00 360 Insurance 1 2 500 1 3 500 1 4 200 1 4 91 0 1 5.357 Other Services and Charges . 401 Repair/Maint. . Labor $ 51 8 $ 3,797 $ 4,1 91 $ 1 ,700 $ 2,000 406 Contractual Services 1 ,097 3,247 7,622 3,250 5,000 41 5 EauiDment Services 65,000 98,030 96,724 1 09,449 91 ,773 41 6 Computer Services - 1 70 350 . - 430 Uniforms 2,1 38 1 ,883 1 ,664 3,000 2,500 433 Dues/Reaistration 1 3,1 34 1 6,939 1 3,567 22,000 22,000 435 Subscriptions 1 ,063 436 783 750 750 442 Meals/Lodging 400 800 641 2,500 3,000 o o o CITY OF ANDOVER Expenditure Budget Worksheet Budget Year 2000 12/30/9910:47 AMWFIRE.XLS Actual 1996. Actual 199Z Actual 1998 $ - $ $ o o , CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The division administers and enforces city ordinances relating to the building code. Building plans are reviewed prior to construction and buildings in the process of construction are inspected for compliance with applicable codes. C/) ...J ><; d CD CD ::2: <( CO ~ o T'"" en 25 ~ C\l T'"" a: z w 0 >1-1- OUJ~ Cc:lCC 0- ~~rr:. W.-:-- cc t; LLo- 000 oUJ >C\Ic:l I- <( o 3: z o f= () UJ C- OO ~ UJ > a b a: c- en I'- C\l .... T'"" .... 0 co ~ I'- 0 co C\l 0 co .... T'"" ..... C':l .... to en to to co .,f r-: C'5 en C'5 N N C'5 to l!) l!) .... C':l C':l en C\l i l!) 0 0 0 en en , C':l 0 T'"" T'"" ..... en en C':l T'"" T'"" T'"" T'"" to W u.. :::::i i 0 C\l C\l C\l I'- I'- , en ...I ~ l!) l!) l!) C\l C\l ~ ~ C\l C\l C\l C\l C\l T'"" Z W Q i .... 0 0 0 ;1i .... , T'"" ::I: en C\l C\l C\l l!) to C':l to to to en en T'"" ~ .,f ....- .,f .,f T'"" T'"" N ct C\l W ::I: I .... C\l C':l ~ to T'"" .... .... to I'- C\l 0 en C':l to I'- to to l!) .... C':l .... C'5 to l!) l!) I . C':l co T'"" l!) C':l to I'- to l!) C':l I'- .... T'"" ~ C\l co to .... I'- to T'"" co C'5 N N N T'"" T'"" .,f T'"" en C\l I'- 0 C\l to T'"" to C\l 0 C\l l!) l!) en C\l I'- i I'- .... C\l 0 ....- C':l T'"" C':l N N N N T'"" T'"" N T'"" C\l l!) l!) to to I'- 0 T'"" lf) ! co I'- co to C\l .... .... C\l lf) to C':l en l!) 0 en C':l en 0 N cD N gf as cD N as IX: l!) .... .... C\l C\l C':l ~ C\l :lo::: ~ ~ ...J a: I- <( ::c a. 13 >- >- 0 ~ a: a: C\l ...I iI: ~ ~ a: a: @J ct ...J <( <( <( U. l- I- C/) b w 13 0 () () w w 0 Q W W a: a: l- iI: CJ c.. c.. () () ::2: Q ~ u. Cl C/) C/) w w C':l z 0 ...J Z Z c.:i CD en C/) < I- CJ I- CJ CJ CJ CJ W IX: ~ Cl C/) Cl Cl Cl Cl en ~ ...J C/) ...J ...I ...J ...J I- a. CD <( CD CD CD CD c.. CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/9910:48 AMPROINSP.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services . Buildina Official 0.951 $ 50,193 0.951 $ 52,682 Assistant Buildina Official 1.000 44,260 1.000 46,375 Building InsDectors 2.000 74,389 2.000 82,551 , 'Uildina Secretaries 1.800 47,646 1.800 54,973 Part TIme Sec.o 3mos@20t 0.125 4,628 0.125 2,340 . Total 5.876 $ 221,116 5.876 $ 238,921 o o o o CITY OF ANDOVER 12/30/9910:49 AMWPROTINS.XLS Expenditure Budget Worksheet Budget Year 2000 PROTECTIVE INSPECTION DEPARTM ENT # 42400 General Fund Object Actual Actual Actual Budget Reauest ~ 1996. 199Z 1998 1i9a 2QOO Personal Services 1 01 Salaries $ 1 78,206 $ 1 79,779 $ 1 95,536 $ 221 , 1 1 6 $ 238,921 1 21 PERA 7,744 8,21 3 1 0,000 1 1 ,454 1 2,376 1 22 FICA 1 0,1 50 1 0,900 1 1 ,592 1 3,709 1 4,81 3 1 25 Medicare 2,374 2,549 2,71 1 3,206 3,464 1 31 Health Insurance 1 7,595 1 7,782 1 9,422 24,509 22, 1 61 1 32 Dental Insurance 1 ,240 1 ,301 1 ,292 1 ,575 1 ,449 1 33 Life I nsurance 83 83 83 575 633 ::::,:::::::::;~::::::!::I::!::::lill~!!l::':::::!:::!::::::::::l,::::::::!!::::::::!I:::::::::l~!E[?:!:i:l!::1::::::~[~~::::lm::!::11:~~~i!~1::~:~::::!1!!~i~~~:::1ll:::'::~~!:!!!!! 1~lJnnIiA!': ~nd M~tAri~l!': 201 General Office Supplies $ 3,222 $ 5,739 $ 4,001 $ 4,000 $ 4,500 203 Printed Forms 2,274 3,001 2,792 5,000 5,000 21 0 ODe rating Supplies 275 255 2,491 750 3,000 220 Repair/Maint. - General - - 52 1 00 1 00 !::ll:::::::l:l:::::i::l:ll~~I~i~!ll:::l::::::::l::!:::::::l::::::::::::::::~::::~:!~~:::!i!!~::~::::!:::::::::l~~~~~:I:::I::::::::l:::~.~::::::::~::':::~:::::~:~~~~l::ll~:::::::!::~~i~~~:: Purchased Services 301 Professional Services $ 364 $ 1 ,81 2 $ 1 6,696 $ 1 ,000 $ 1 ,000 321 TeleDhone 76 401 1 1 6 400 3,860 322 Postage 905 1 ,01 0 960 1 ,200 1 ,200 330 Transportation 1 00 31 1 2,332 1 ,600 500 351 Publishina 1 02 - 270 1 50 300 352 Printing 239 - - 1 00 1 00 360 Insurance 900 925 975 1 ,024 1 ,055 Other Services and CharQes 401 Repair/Maint. - General $ 234 $ 57 $ 31 0 $ 500 $ 800 41 5 EauiDment Services 6,000 9,049 9,089 1 0, 1 34 1 0,499 41 6 Computer Services . 1 ,530 - - - 433 Dues/Registration 2,463 2,203 1 ,079 1 ,400 1 ,400 442 Meals/Lodging 33 60 32 250 500 443 Continuing Education - 978 332 2 000 2 000 o o o CITY OF ANDOVER 12/30/9910:49 AMWPROTINS.XLS Expenditure Budget Worksheet Budget Year 2000 Actual 199Z Actual 1998 Budget ~ Request 2QOO Object Actual ~ 1996. PROTECTIVE INSPECTION - continued Capital Outlav $ 1,143 $ $ $ $ o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The Civil Defense department provides advanced warning to the public in cases of emergency. C/) ...J >< a () :2 <( en ~ o T'"" en 25 ~ C\l T'"" a: z w 0 >I-i= Ow::> CCJo:l 0- ~ ::> a: w,:-o:lt) L1.0- 000 ow >C\ICJ I- <( (3 3: UJ 00 z d :::! 2: () I'- I'- ~ 0 0 C':l C':l C'5 C'5 I l!) l!) w u. :::::i i C\l C\l ...I T'"" ..... ~ z W Q i to to ::I: C\l C\l ~ C\l C\l ct W ::I: I . en en C':l C':l co co to to ~ ..... T'"" T'"" ..... .... .... ~I T'"" T'"" .... .... lf) ! T'"" T'"" lf) I'- I'- 0 N N a: ~ S l- e: ...I ~ ...J ct W ~ b Q () I- ~ iI: Q u. Z 0 ct I- CJ a: ~ Cl ~ ...J c.. CD CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/9910:49 AMCIVIL.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Buildina Official 0.049 $ 2,586 0.049 $ 2,714 Total 0.049 $ 2,586 0.049 $ 2,714 o o o o o CITY OF ANDOVER Expenditure Budget Worksheet Budget Year 2000 12/30/9910:49 AMWCIVIL.XLS CIVIL DEFENSE DEPARTMENT # 42500 General Fund Obiect ~ Actual 1996. Actual 199Z Actual 1998 Budget ~ Reauest 2QOO Personal Services 101 Salaries $ 2,340 $ 2,348 $ 2,504 $ 2,586 $ 2,714 121 PERA 104 107 129 134 141 .122 FICA 142 148 150 160 168 125 Medicare 33 35 35 37 39 131 Health Insurance 185 185 203 226 226 132 Dentallnsurance 12 13 12 12 12 133 Life Insurance 1 1 1 5 5 lii!i:!:!!.l!i:i:ii:i:::!ii:::::~!:!M!.ii:!:!iii:!i::'::::!:i~~ii~!!iiiiiii!!~:!!.i:~:iil:i_1:!:i:_:i!iii_:1::_::lii_!.~ ~lInnIiA~ and Materials 201 General Office Supplies $ - $ . $ - $ 100 $ 100 210 ODeratina SupDlies - . - 50 50 220 Repair/Maint. - Supplies 5142 - 5054 4 300 4 800 !::::l:~!ii::i:iiliiiii:l:i,l::!III~~i:i::iilii:illiiliii:i:i::::i::::l:i:.:i:il:iiiii.:i:i:i:.::~~::~::::l:::'::?~~!~!i::i~1:::::'::'!:::1'~::!~1:::::1~i:i:ii:~:~:~:~::,::::?:!.~:.1~:::[!::~:::!1:~!i!~:::::1::~1:!::1::::::~~~::~ Purchased Services . 321 Telephone $ - $ 60 $ - $ 100 $ 100 360 Insurance 460 490 520 550 575 381 Electric 703 703 703 800 850 i:il:i:i:iilliii::liil!llliiil~:lili,I~:i::ii::ii::liiiiil:iiilii:il::l'l~l::l:i:iliiiiiiiii::ii~::::::!::::~::!~:~i:l:::~'~:!~:!::::!!~J~:::l:~::::::::::::~~~:ii::i:~:::::!:::::l~:~~~:ii::ili~:::::::::::l:::::!~:~~~::: Other Services and Charges 401 Repair/Maint.. General $ 3,817 $ 2,156 $ 3,557 $ 3,650 $ 3,650 I lill:i:ii:i:::::iiiiiiill!:il:i:lillllll::::i:::ii:iil!:ii:iliiii:ii::li::',::::i::li~iiiiiliiii:i!lilliiii::lliIiiii:ili~-iil:_:f:i_i:l " ,. ".... ,...... .. ..' .' . . : . . '. . . . .. .. . . . . . o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This division is responsible for enforcing City Ordinance #53 relating to cats and dogs. The City has a contract for this service. o o o CITY OF ANDOVER 12/30/9910:49 AMWANIMAL.XLS Expenditure Budget Worksheet Budget Year 2000 ANIMAL CONTROL DEPARTMENT 42700 General Fund Object ~ Actual 1996. Actual 199Z Actual 1998 Budget 1i9a Re uest 2QOO o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET CITY OF ANDOVER Summary of Public Works Expenditures by Area 2000 Streets & Highways 40% Recycling 4% Sunshine Park 1% Parks 20% Weeds 1% Trees lo/"Traffic Signals 1% Street Lighting 1% Snow & Ice 17% Street Signs 4% 1999 Traffic Si 1% Sunshine Park 1% Recycling 4% Streets & Highways 39% Trees . 10/. Street SIgns o 4% Storm Sewer Street Lighting 6% 1% Snow & Ice 17% Street Lights-Billed 4% o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET o This Streets and Highways Division maintains streets and roadways within the city, including street surfacing and repairs o GROSS . HEALTH DENTAL LIFE 0- WAGE PERA FICA MEDICARE INSURANCE INSURANCE IN~IIRAN~E TOTAL POSITION DESCRIPTION SUPERINTENDENT 8,666 449 537 126 693 38 17 10,525 JEFF O. 13,072 677 810 190 695 81 35 15,560 BRIAN K. 991 51 61 14 43 5 2 1,169 KEVIN S. 998 52 62 14 92 5 2 1,225 ...... ...... .... .... ...... ... ... .......... ...... ..... ................... ..... .. , ..... ...... .. ........... ....... ...... .... .... ......... .......... .. ......... . DENNIS M. 5,370 278 333 78 693 38 17 6,807 TERRY S. - - - - - - - - CHRIS O. 6,851 355 425 99 391 45 20 8,186 JEREMY J. 754 39 47 11 92 5 2 950 IRWIN R. 15,074 781 935 219 868 101 44 18,022 ~S. 15,376 796 953 223 1,848 101 44 19,342 1- ANDY K. 15,395 797 954 223 1,987 108 47 19,512 MERYL P. 14,584 755 904 211 1,987 108 47 18,598 RON SCOTT 1,696 88 105 25 231 13 6 2,163 OVERTIME 4,200 218 260 61 - - - 4,739 . . . . . . . . . . . . . . . . . . . .................... .... .. .... ........ .. ... .. ....... .... SEASONAL EMPLOYEE 6,400 332 397 93 - - - 7,221 RECYCLING COORD. 646 33 40 9 92 5 2 829 PUBLIC WORKS SEC. 1,187 61 74 17 208 11 6 1,564 GENERAL CLERK 590 31 37 9 54 6 3 729 DATA ENTRY CLERK 770 40 48 11 116 6 3 993 CJ!AND TOTAL 112,621 5,834 6,982 1,633 10,090 677 296 138,133 CITY OF ANDOVER 12/30/9910:56 AMSSTREET.XLS 2000 BUDGET WAGE WORKSHEET CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/9910:57 AMSTREETS.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Suoerintendent 0.150 $ 8,255 0.150 $ 8,666 SuDervisor 0.360 17,440 0.360 15,061 Maintenance Workers 2.060 71,151 2.060 79,301 iii 'Ublic Works Secretary 0.050 1,326 0.050 1,187 DataEntrv Clerk 0.025 564 0.025 770 Recyclina Coordinator 0.020 589 0.020 646 General Clerk 0.025 465 0.025 590 Seasonal EmDlovee 1.000 6,400 1.000 6,400 Total 3.690 $ 106,191 3.690 $ 112,621 o o o o CITY OF ANDOVER 12/30/9910:57 AMWSTREETS.xLS Expenditure Budget Worksheet Budget Year 2000 STREETS/HWY DEPARTMENT # 43100 General Fund Obiect Actual Actual Actual Budget Request ~ 1996. 199Z 1998 ~ 2QOO Personal Services 101 Salaries $ 1 15,195 $ 95,322 $ 128,274 $ 106,191 $ 1 12,621 121 PERA 4,457 4,253 6,645 5,501 5,834 122 FICA 6,489 5,814 7,846 6,584 6,982 125 Medicare 1 ,517 1,349 1,835 1,540 1,633 131 Health Insurance 1 1 ,177 10,958 13,321 10,786 10,090 132 Dental Insurance 659 799 835 653 677 133 Life Insurance 57 57 62 257 296 :::'::l:!l:::::::.:':ll::!~:::.lli!:'::~:::'ll:::::::'::::::::::::::::::::.::::::~:!l!~~!~!~:::!i:::~!::~!:!!!~!:l::::::!:::~'~!~!~~~~:::,:!:::::~!~i!~'!::~::!::::~~:!!!:!:!!~:: rsIJDDliA'" <Inti M<lt..rj<ll'" 201 General Office Supplies $ 344 $ 219 604 657 700 210 Operating Supplies 8,501 9,682 1 0,685 9,700 1 1 ,000 220 ReDair/Maint. - General 2,621 1 ,886 1 ,867 3,000 3,000 221 ReDair/Maint. - Vehicle - - - - - 224 ReDair/Maint. - Street 16,726 12,281 2,319 8,000 8,000 228 Repair. Maint - Spec. Proj. 3,929 - 5,295 5,000 5,000 240 Small Tools 966 250 469 1 ,000 1 ,000 !:::I:::::::::::::::l':~:::r;:::::::Ri~II~;:::::l:::l~::::::11:1:1::1:1::':::::':::::11::::~':1!.:::~!~~1.~!:~::;::::~!~:l::.,::~I~!i~~~:::::ll:::::::::!::~~,ii~~:::::~::~,,:~:~:~!~ml.~!:~j::::ll:::~::~l~!;?~~l: Purchased Services 301 Professional Services $ 362 $ 422.00 $ 386 $ 500 $ 500 321 TeleDhone 247 608.95 1 ,681 702 800 322 Postage 173 267 289 400 400 330 Transportation - 24 41 50 50 351 Publishina 217 214 1 15 100 250 - ,,:.:.:.:.: ..' ..............:.~:............ ....... . .. ....... ..................... ......... ............ ...... ......... I Other Services and Charoes 401 Repair/Maint. - General $ 567 $ 661 $ 413 $ 1 ,200 $ 1 ,200 403 ReDair/Maint. - Streets - 190 5,466 5,000 5,000 406 Contractual Servo - Grading 10,909 10,295 27,960 32,000 32,000 410 Rentals 15,037 15,000 13,230 15,000 15,000 415 Eauipment Services 25,130 37,900 37,510 42,445 43,973 416 Computer Services - 85 300 - - 433 Dues/Registration 614 1 ,394 1 ,225 1 ,500 1 ,500 442 Meals/Lodgina - - 404 400 465 ImDrovements - Streets 55,636 26,553 21 ,216 41 ,000 41 ,000 466 Cracksealina & Sealcoating 194,344 210,000 169,583 400,000 300,000 467 Overlay - - - 272,856 460,613 ::::::I!::::;::::::I:Il:;llilliliII;:~:::~::;I::::::::l:II::::,:::::;::::::::'I,:~;:~I::::~~~~~~~::::::~I:::::l~g~;g~~:::::::~I:::~~~I~~~::::::"I:::':~~:ii~~~::::::~:::~II~ggl~~~::,: o o o CITY OF ANDOVER 12/30/9910:57 AMWSTREETS.XLS Expenditure Budget Worksheet Budget Year 2000 Ob'ect ~ Actual 1996. Actual 199Z Actual 1998. Budget 1i9a Request 2QOO STREETS/HWV - CONTINUED Capital Outlav 570 Office E ui ment $ 4,052 $ $ $ $ 580 E ui ment 48,700 603 Assessment Principal 24 ::::'l:::l:::::::::::::::::::.:::::::..!:::::l:::::l::.:::~.::1:::~:::::::~:::::::::::::11:::~~.::.1:::::~~!~~~::::::~1::~::~:.:::~:~:::::1:~:::::::1:::::~~::.:::::~:::::::::~~':~~~::::~:1:::::::'~.::::::~::~!::.!~~::::;:',~::!:::::::~.::~~1:~~:~::~!~::: o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The snow and ice removal department is responsible for snow and ice removal for streets and roadways within the city. CITY OF ANDOVER 2000 BUDGET WAGE WORKSHEET 12/30/9910:57 AMSSNOW.XLS 0 GROSS HEALTH DENTAL LIFE WAGE PERA ~ MEDICARE N~IIRAN~E IN~IIRAN~~ INSURANCE TOTAL POSITION DESCRIPTION SUPERINTENDENT 8,666 449 537 126 693 38 17 10,525 RAY S. 12,255 635 760 178 651 76 33 14,588 BRIAN K. 9,913 513 615 144 434 50 22 11,691 KEVIN S. 9,978 517 619 145 924 50 22 12,255 .............. ..'.,. ,............ .. .on ............................ ........ ... ... ...... .......... .......... ................ :.:.:....... .. ........ :.:.:...:.;.:.:....... .'....... JOHN W. 7,697 399 477 112 785 43 19 9,532 SCOTT P. 7,613 394 472 110 924 50 22 9,586 DENNIS M. 10,741 556 666 156 1,386 76 33 13,613 TERRY S. 7,160 371 444 104 924 50 22 9,075 CHRIS O. 1 1 ,419 591 708 166 651 76 33 13,644 TOM J. 7,537 390 467 109 924 50 22 9,501 JEREMY J. 7,537 390 467 109 924 50 22 9,501 IRWIN R. 11 ,306 586 701 164 651 76 33 13,516 SCOTT H. 7,896 409 490 114 924 50 22 9,905 RALD K. 7,537 390 467 109 924 50 22 9,501 F O. 11 ,532 597 715 167 1,386 76 33 14,506 ANDY K. 10,741 556 666 156 1,386 76 33 13,613 TOM R. 7,160 371 444 104 924 50 22 9,075 MERYL P. 10,175 527 631 148 1,386 76 33 12,975 RON SCOTT 6,783 351 421 98 924 50 22 8,650 JIM SANNERUD 7,160 371 444 104 924 50 22 9,075 OVERTIME 11 ,898 616 738 173 - - - 13,425 .!lmi:III,I~~I~:III.I~!:::~:I~:~II:i::::I::I:lllil::::::::::::~~~~~:'~::lli:::::I:::::::I;I~~!::~:::!I::::::j:11~11:::::I::::::::::::~I::::::::I:!:I:::::::::I::::i~i:::::::lillii:::: SECRETARY 1,187 61 74 17 208 11 6 1,564 RECYCLING COORD. 646 33 40 9 92 5 2 829 ORDER ENTRY CLERK 770 40 48 11 116 6 3 993 GENERAL CLERK 590 31 37 9 54 6 3 729 GRAND TOTAL 195,897 10,147 12,146 2,841 19,121 1,193 521 241 ,866 o CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/9910:57 AMSNOW.XLS o 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services SuDerintendent 0.150 $ 8,255 0.150 $ 8,666 SuDervisor 0.700 33,720 0.700 32,146 Maintenance Workers 3.770 138,361 3.770 151,893 " tUbliC Works Secretary 0.050 1,326 0.050 1,187 Data Entry Clerk 0.025 564 0.025 770 Recyclina Coord. 0.020 589 0.020 646 Public Works Clerk 0.025 465 0.025 590 Total 4.740 $ 183,280 4.740 $ 195,897 o CITY OF ANDOVER 12/30/9910:57 AMWSNOW.XLS Expenditure Budget Worksheet Budget Year 2000 o SNOW AND ICE DEPARTMENT # 43125 General Fund . Obiect ~ Actual 1996. Actual 199Z Actual 1998 Budget Request 1i9a 2QOO Personal Services 101 Salaries $ 84,585 $ 132,146 $ 87,304 $ 183,280 $195,897 121 PERA 3,305 5,263 4,450 9,494 10,147 122 FICA 4,539 8,303 5,163 10,982 12,146 125 Medicare 1,062 1,954 1,208 2,658 2,841 131 Health Insurance 6,493 10,292 7,774 20,177 19,121 132 Dentallnsurance 428 692 463 1,169 1,193 133 Life Insurance 37 55 36 464 521 L""",:";,;"""h;,:":,~;,;i~~';;;;*~;",;"",,,,,""""""""""""""'"',"''''' ""!,,,,;;;;;;;;;;;:;;;;;;;; iiiLiMlw;;.iilmW&!iIk:;;0;:;;;#illiij\t~'~I:Kiljj,tlIA~if:t I~II~~~I1I]Ij~~]j~1~1;~II_I[~rfII1;II1tIt:~mmImmmnm@::~m~1j~t_~:~F~;;;8@~~W!S;m;~m~~~~~~;]1'8~!m~~~s~q ~nnIiA!'ll'lnd Ml'ltAril'll!'l o 201 General Office SupDlies $ 231 $ 199 $ 354 $ 400 $ 400 210 ODerating Supplies 7,512 10,906 11,317 12,000 12,000 220 ReDair/Maint. - Supplies 3,515 719 4,058 4,000 4,200 224 Repair/Maint.-Streets 54,553 132,795 69.133 110000 120000 ::1:::1::1:1:::::::::1::::::li~1H1il,:::::::1:~::1::::::::ll:::~::::::l::::::::::::::~::::::::.:~:!;~~~:::i.,:~i:!:::::!:::::~~~~!::l:~:::!~~~~:::~~~~:::::~:::::~:~!i~~::::::~~m1~~ Purchased Services 301 Professional Services 321 Telephone - $ 46 $ - $ 22 $ - $ 550 100 600 Other Services and Charges 401 ReDair/Maint. - General $ 1,600 $ - $ 2,302 $ 2,000 $ 2,000 406 Contractual Services - 2,069 - 4,000 4,000 415 EauiDment Services 45,000 67,867 67,169 76,006 78,742 416 Computer Services - 85 250 - - 433 Dues/Registration 225 183 499 1,000 1,000 ::::::I:::::::::::::!::1::;~::1:::1':lllti1il::::::::l:::::::::::::::::::::,!:~::::::::l::::~~:::::.::::::::~~!~~:l::::!~::.!::':::::~:i::~:i:~~.I::::::~~::::!1~~::!?':9~~~::1:~:::~!:::~~l~~~:;::::~1~~~!:!~::: Captial Outlay 570 Office EauiDment $ - $ - $ - $ - $ - 580 Equipment - - 1 ,124 - - o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET o The Storm Sewer Division is responsible for maintaining storm sewers within the city. '~'r , i;:> o --------------- CITY OF ANDOVER 12/30/9911 :02 AMSSTORM.XLS 2000 BUDGET WAGE WORKSHEET GROSS HEALTH DENTAL LIFE : WAGE EEBA E!CA MEDICARE NSURANCI= IINSURANCE INSURANCE TOTAL POSITION DESCRIPTION SUPERINTENDENT 2,889 150 179 42 231 13 6 3,508 RAYS. 2,043 106 127 30 109 13 6 2,431 BRIAN K. 4,956 257 307 72 217 25 11 5,845 SCOTT P. 3,806 197 236 55 462 25 11 4,793 DENNIS M. 1,790 93 111 26 231 13 6 2,269 CHRIS O. 1,903 99 118 28 109 13 6 2,274 JEREMY J. 754 39 47 11 92 5 2 950 IRWIN R. 1,884 98 117 27 109 13 6 2,253 RALD K. 7,537 390 467 I. 109 924 50 22 9,501 J FFO. 1,922 100 119 28 231 13 6 2,418 ANDY K. 1,790 93 111 26 231 13 6 2,269 TOM R. 716 37 44 10 92 5 2 908 MERYL P. 1,696 88 105 25 231 13 6 2,163 RONS. 1,696 88 105 25 231 13 6 2,163 JIM SANNERUD 3,580 185 222 52 462 25 11 4,538 .. ........ ..... .... ... ..................... ................ .... .... ..... ....................... .... ......................................... ................. ......... .................................. ......."........ .... ............. ... ............... ....... ..... .......... ..... ;';':':';':';';'," ..... .... .................. .. SECRETARY 475 25 29 7 83 5 2 626 RECYCLING COORD. 646 33 40 9 92 5 2 829 GENERAL CLERK 236 12 15 3 22 3 1 291 DATA ENTRY CLERK 308 16 19 4 46 3 1 397 c:;,RAND TOTAL 41,126 2,130 2,550 596 4,251 267 117 51,037 CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/9911 :02 AMSTORM.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services SuDerintendent 0.050 $ 2,752 0.050 $ 2,889 SuDervisor 0.160 7,664 0.160 7,498 Maintenance Workers . 0.790 25,813 0.790 29,075 ~UbIiC Works Secretary 0.020 531 0.020 475 Recvclina Coordinator 0.020 589 0.020 646 Public Works Clerk 0.010 186 0.010 236 Data Entrv Clerk 0.010 226 0.010 308 Total 1.060 $ 37,760 1.060 $ 41,126 o o STORM SEWERS DEPARTMENT # 43150 General Fund Object Actual Actual Actual Budget Request ~ 1996. 199Z 1998 1i9a 2QOO Personal Services 101 Salaries $ 8,153 $ 28,395 $ 17,764 $ 37,760 $ 41,126 121 PERA 351 1,246 884 1,956 2,130 122 FICA 492 1,690 1,071 2,341 2,550 125 Medicare 115 395 251 548 596 131 Health Insurance 533 2,914 1,412 4,426 4,251 132 Dental Insurance 47 212 92 257 267 133 Life Insurance 3 14 7 102 117 Ili~lii::i:i:il::':i!:\:i'i:'ri_:il::fu:::ii:iil:i::::::~:::':,:~:iiiil::::i:ii:i~:l::l::::li:iIIiii::liii--i~:i:_::i\i~i_~ 1!=:llnnIiA~Md MatArial~ 201 General Office Supplies $ - $ - $ - $ 100 $ 100 210 Operating SuDplies 175 - 1,100 500 500 220 Repair/Maint. - General 1,064 688 1,700 1,200 1,200 227 Repair/Maint. - System 3,279 2,527 8,794 2,000 2,000 240 Small Tools - 100 510 700 700 ........ .... .... .. ................... ........ .... ....... ..... ...... Purchased Services 303 Consulting Engineer - General $ - $ - $ 75 $ - $ - 330 Transportation - - - 200 200 360 Insurance 200 214 125 131 135 381 Electric 91 93 96 500 500 l:l::~:iiii::'l:i:i:ill:iiiill~l,ii:ll:::::ll~::::::::':l:liii:ii:,::i:i':i:iii:iill:iIIiii:iili__::I::_:ji:i_l!l_:: ................... .......... .................... ...... .... .... ... ....... ................. :. Other Services and Charoes 401 Repair/Maint. - General $ 299 $ 329 $ 1 ,422 $ 5,000 $ 5,000 404 ReDair/Maint - Sewer 1,576 1,226 412 5,000 5,000 406 Contractual Services - - 28,904 45,000 45,000 410 Rentals 1,065 63 99 8,000 8,000 412 InsDections - - - 2,500 2,500 415 EauiDment Services 1,200 1,810 1,791 2,027 2,100 416 ComDuter Services - 85 185 - - llil'_I~:lii:i_iii::_::.,::id::1 ........ ... .... ................. ........ on ..........:.;... '" ......... .... ................... ,':':' Capital Outlay 530 Improvements $ 6,582 $ - $ - $ - $ - 580 Equipment 3,963 27,049 - 30,000 - .n ......... .... .....~..... ....... .n .... CITY OF ANDOVER 12/30/9911 :02 AMWSTORMXLS Expenditure Budget Worksheet Budget Year 2000 o o o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET -.. ................. .................... .....0. II................. :.:.;.;.:.:.....;............................................................................................ The Street Lighting Division is responsible for traffic regulating device installation and maintenance. o o o CITY OF ANDOVER 12/30/9911 :02 AMWLlGHTSXLS Expenditure Budget Worksheet Budget Year 2000 STREET LIGHTING DEPARTMENT 43160 General Fund Object ~ Actual 1996. Actual 199Z Actual 1998 Purchased Services $ $ - $ $ - $ o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This Street Sign Division is responsible for the production and installation of street signs within the city. CITY OF ANDOVER 2000 BUDGET WAGE WORKSHEET 12/30/9911 :04 AMSSIGNS.xLS ~ GROSS HEALTH DENTAL LIFE --- WAGE PERA FICA MEDICARE INSURANCE INSURANCE INSURANCE TOTAL POSITION DESCRIPTION SUPERINTENDENT 1,733 90 107 25 139 8 3 2,105 RAYS. 6,128 317 380 89 326 38 17 7,294 BRIAN K. 496 26 31 7 22 3 1 585 KEVIN S. 499 26 31 7 46 3 1 613 ................. ..........,................ ......... ...... ..... ...... .... .... ......... ................ ...........:.:.:.:....................... .... DENNIS M. 10,025 519 622 145 1,294 71 31 12,706 SCOTT P. 381 20 24 6 46 3 1 479 CHRIS O. 10,658 552 661 155 608 71 31 12,734 JEREMY J. 754 39 47 11 92 5 2 950 lCJlN R. 2,638 137 164 38 152 18 8 3,154 JEFF O. 2,306 119 143 33 277 15 7 2,901 MERYL P. 1,018 53 63 15 139 8 3 1,298 RONS. 6,783 351 421 98 924 50 22 8,650 ANDY K. uu1 ,074 56 67 16 139 8 3 1,361 ..... .................. ............. ... ..... .................................. ............. . ........ ...... 0............ . .. ............ , ........... ....... ...... ........ ........... ..........................:.:.:.:.:....................... SECRETARY 712 37 44 10 125 7 3 938 RECYCLING COORD. 969 50 60 14 139 8 3 1,243 GENERAL CLERK 354 18 22 5 33 4 2 437 DATA ENTRY CLERK 462 24 29 7 69 4 2 596 GRAND TOTAL 46,989 2,434 2,913 681 4,568 319 140 58,044 o CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/9911 :04 AMSIGNS.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services SuDerintendent 0.030 $ 1,651 0.030 $ 1,733 Suoervisor 0.170 8,235 0.170 7,122 Maintenance Workers 0.980 32,108 0.980 35,636 "'UbIiC Works Secretary 0.030 796 0.030 712 Recvclina Coordinatar 0.030 883 0.030 969 Data Entrv Clerk 0.015 338 0.015 462 Public Works Clerk 0.Q15 279 0.015 354 Total 1.270 $ 44,290 .uzQ $ 46,989 o o o o CITY OF ANDOVER 12/30/9911 :05 AMWSIGNS.XLS Expenditure Budget Worksheet Budget Year 2000 STREET SIGNS DEPARTMENT It 43170 General Fund Object Actual Actual Actual Budget Request ~ 1996. 199Z 1998 ~ 2QOO Personal Services 101 Salaries $ 22,419 $ 35,064 $ 49,526 $ 44,290 $ 46,989 121 PERA 982 1,382 2,490 2,295 2,434 122 FICA 1,397 1,984 2,961 2,747 2,913 125 Medicare 327 464 693 642 681 131 Health Insurance 1,924 3,517 5,577 5,373 4,568 132 Dental Insurance 192 61 247 319 319 133 Life Insurance 15 17 27 127 140 I:!~:::i::iill:~li'ji:f!iiii!\il~:~::~:::':l:l~:~ljl::::::::::::!:::::::::::::I::~_.I::'-:l::_:I:l_l~i::_!1 ISunnli.... "'ntl Materials 201 General Office Supplies $ 14 $ - $ 9 $ 150 $ 200 210 Operatina SupDlies 16,560 7,792 42,774 17,000 17,000 220 ReDair/Maint. - General 540 1,641 2,055 2,000 2,000 ~!;::::::~::":'l!:"~j!::::"':\:l.::'I::::.:1 .. ........................ .. ... .... .. ................ ... .................... ........ ....... ..... ... ........................ ,", ..... ..... Purchased Services 301 Professional Services $ - $ 40 $ 66.00 $ - $ 100 330 TransDortation - 161 - $ 200 200 1:~:::~lil~j:::I::I:i:i~iii~::::::::,:::::::i::j:::::'1:~:::::::::::::':1:::~::!:::~:::I::_::'1::':--::!::::--:::I::~ Other Services and Charaes 401 ReDair/Maint. - Labor $ 2,049 $ - $ 286 $ 1,000 $ 1,300 410 Rentals 10,165 1,541 1,318 13,000 13,000 412 Inspections 346 - - 3,000 3,000 415 EQuiDment Services 3,500 5,279 5,224 5,912 6,124 416 ComDuter Services - 85 150 - - 433 Dues/Registrations 196 357 685 600 800 l:l::!i,ili1:!~:iliiiiiji::ili.:i::.:i~11:::,::,,:::,::::::::l::::,:::fl:,:_:::~::_:::~::_::~::_l:i::_:1 . "" ... ...~........ ... ..... ......... ... .... ......... ........... ........ ............. ......... ........... .......... ... .... ... Capital Outlay 530 ImDrovements $ 2,307 $ - $ - $ - $ - - o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This Traffic Signals Division is responsible for traffic regulating device installation and maintenance. o o o CITY OF ANDOVER 12/30/9911 :05 AMWTRAFFIC.XLS Expenditure Budget Worksheet Budget Year 2000 TRAFFIC SIGNALS DEPARTMENT # 43180 General Fund Object ~ Actual 1996. Actual 199Z Actual 1998 Budget 1i9a Request 2QOO Purchased Services 381 Electric $ 16,609.68 $ 17,303 $ 17,350 $ 25,000 $ 30,000 l';;::'::::::::!::::::~I:::!:l:::::':!.,,~II!:':l'::,l::::::!::::::!'::::.:~!:l::,::::::::::::':~::'!'::!:!!i!:'~.~~~~!~~!::11::1:!:::1':::~:~~!!:!:::':~:::~:~:.:~:~!!!!::::::;~~:::~::~~:~!!I!~::,::::l;1::~:::1!!~!::: o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This division is responsible for street lights that are billed back to residents. o o o CITY OF ANDOVER 12/30/9911 :05 AMWSTLlGHT.xLS Expenditure Budget Worksheet Budget Year 2000 ST. LIGHTS-BILLED DEPARTMENT # 431 90 General Fund Obiect Actual Actual Actual Budget Request ~ 1996. 199Z 1998 ~ 2QOO ~i~~ An~i::J1~ ~:i!i:::.::::::::I:::"':I:_l!:::_:::I::~_ll::illii ,.... ..N. ..... .......N ...,.NN ..... ..... ....... ,I' Purchased Services 301 Professional Services $ - $ - $ - $ 1 00 $ 1 00 322 Postage - - - 400 400 351 Publishing - 1 6 1 6 50 50 381 Electric 79,631 85,923 1 01 ,51 1 94,000 1 1 5,000 406 Contractual Services 2,206 1 ,1 67 1 ,823 3,000 3,000 ::::::::ii~;:::'::::li:[iiii\'~:::::::::~::i::::::'::::l:~:::'::~::::::::::::':~_'~:I:i_'::~:::_:,:1 Repairs & Maintenance 470 Street Lig hts Maintenance $ - $ 2,423 $ 9,225 $ 1 6,000 $ 1 6,000 ~::::::::~ll::::::::::::::::::::':::::llll::::::l:l::::::l.~~!i~:::::::::l:::::~:::::::::::::::~~:::!::::~::~!::~:::::::l::~:!::~:,::::~~!~~~::::::~:'~::::~j~~:::i~~::~~~~~::~::::~:::~::~~l.~g: Capital Outlay 530 Improvements $ 7,573 $ - $ - $ - $ - o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This division is responsible for tree disease control activities and some reforestation. o CITY OF ANDOVER 2000 BUDGET WAGE WORKSHEET 12/30/9911 :05 AMTTREES.XLS rt GROSS HEALTH DENTAL LIFE WAGE fEBA fl.QA MEDICARE INSURANCE INSURANCE INSURANCE TOTAL POSITION DESCRIPTION SUPERINTENDENT 578 30 36 8 46 3 1 702 PUBLIC WORKS SEC. 1,187 61 74 17 208 11 6 1,564 RECYCLING COORD. 646 33 40 9 92 5 2 829 NEW EMPLOYEE (REC.) 590 31 37 9 54 6 3 729 ORDER ENTRY CLERK 770 40 48 11 116 6 3 993 GRAND TOTAL 3,771 195 234 55 516 32 14 4,817 o o CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/9911 :05 AMTREES.xLS o 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Suoerintendent 0.010 $ 550 0.010 $ 578 Public Works Secretarv 0.050 1,326 0.050 1,187 Recvclina Coordinator 0.020 589 0.020 646 , ~ Data Entry Clerk 0.025 564 0.025 770 Public Works Clerk 0.025 465 0.025 590 Total 0.130 $ 3,494 0.130 $ 3,771 o o o o CITY OF ANDOVER 12/30/9911 :05 AMWTREES.XLS Expenditure Budget Worksheet Budget Year 2000 TREES DEPARTMENT # 46102 General Fund Object Actual Actual Actual Budaet Request ~ mR 199Z 1998 1i9a 2QOO Personal Services 101 Salaries $ 12,147 $ 10,647 $ 13,890 $ 3,494 $ 3,771 121 PERA 503 470 717 181 195 122 FICA 735 643 821 217 234 125 Medicare 172 150 192 51 55 131 Health Insurance 917 1,006 1,035 139 516 132 Dental Insurance 50 59 71 8 32 133 Life Insurance 5 5 5 3 14 ..... .... ... ................ ...... ...... .... ......... .................... .... .... ~l1nnlfA~ :lmt! M::ItAri::ll~ 201 General Office SupDlies $ - $ - $ - $ 150 $ 150 210 Operating Supplies 303 19 51 500 500 220 Repair/Maint. - Supplies 419 - 500 500 500 240 smaIlToo~_:~.:_ii:::_1::!:::..:il :~::~:i'::!:::!::::::!:::::~:::::,::::::.I~I~i........ .... ........... .... ........ .......... .. ..... .. Purchased Services 301 Professional Services $ 4,967 $ 4,193 $ 3,528 $ 10,000 $ 10,000 330 Transportation - - - 50 50 351 Publishing 64 25 - 500 500 360 Insurance 50 60 70 74 76 ... ................. ............. ..- ... ...... ............... ....... ........ ... ........... ........... ........... ....... ........ ...... Other Services and Charaes 406 Contractual Services $ - $ 1,154 $ - $ 2,000 $ 2,000 415 Equipment Services 800 1,207 1,194 1,351 1 ,400 416 Computer Services - 85 150 - - 418 Maintenance Contracts - - - - - :,:..::~:::...::I:::_:~::::..il ...... ............. . ........;...;.. ...........;...... ... ....... ....... .........;. Capital Outlay 580 Equipment $ 803 $ 1,082 $ - $ - $ - ... ...... ........ ................. .. .... .......... .......:.:.:.... o o ~ CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This division is responsible for responding to and taking care of weed complaints from our citizens and our code enforcement officer. CITY OF ANDOVER 12/30/9911 :08 AMWWWEEDS.xLS 2000 BUDGET WAGE WORKSHEET to GROSS HEALTH DENTAL LIFE WAGE PERA FICA MEDICARE IN URANCE INSURANCE INSURANCE TOTAL POSITION DESCRIPTION SUPERINTENDENT 578 30 36 8 46 3 1 702 KEVIN S. 2,495 129 155 36 231 13 6 3,064 PUBLIC WORKS SEC. 1,187 61 74 17 208 11 6 1,564 RECYCLING COORD. 646 33 40 9 92 5 2 829 GENERAL CLERK 590 31 37 9 54 6 3 729 DATA ENTRY CLERK 770 40 48 11 116 6 3 993 IO-RAND TOTAL 6,265 325 388 91 747 44 20 7,880 o CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/9911 :08 AMWEEDS.XLS o 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Superintendent 0.010 $ 550 0.010 $ 578 SuDervisor 0.050 2,414 0.050 2,495 Public Works SecretarY 0.050 1,326 0.050 1,187 , ~eCYClina Coordinator 0.020 589 0.020 646 Data Entrv Clerk 0.025 564 0.025 770 Public Works Clerk 0.025 465 0.025 590 Total 0.180 $ 5,908 0.180 $ 6,265 o o o o CITY OF ANDOVER 12/30/9911 :08 AMWWEEDS.XLS Expenditure Budget Worksheet Budget Year 2000 WEED CONTROL DEPARTMENT # 461 03 General Fund Obiect Actual Actual Actual Budaet Reauest ~ 1996. 199Z 1998 1i9a 2QOO Personal Services 1 01 Salaries $ 2,1 90 $ 1 ,672 $ 3,939 $ 5,908 $ 6,265 1 21 PERA 1 00 75 203 306 325 1 22 FICA 1 34 1 01 241 366 388 1 25 Medicare 31 24 56 86 91 1 31 Health Insurance 84 36 1 43 370 747 1 32 Dental Insurance 5 2 1 7 20 44 1 33 Life Insurance 1 1 2 8 20 ~:::::::',:i:::!::::::::::::::::i:.I~jf!I::i:::',::::::::::::::::::::::l:::i:'::::::::!lt~~!::~:::!::!:::::~~!!:::::~:!::::::::::l~j~:~~::::::!:~:::!::::::~i?!!::~:!~:::::::::!:~l!!:::::~~!:~i.~!! Supplies and Materials 201 General Office SuDDlies $ - $ - $ - $ 1 00 $ 1 50 21 0 Operating Supplies 1 ,277 206 200 600 600 220 Repair/Maint. - General 1 ,654 1 ,222 463 2,500 2,500 ~j~1i:::~:::::!:::!:::::::i::i:::::::::::::!;::_!li::_: 1::":1 11II !j:["i I Purchased Services 301 Professional Services $ 1 ,342 $ 538 $ 790 $ 1 ,500 $ 1 ,500 330 Transportation - - - 25 25 351 Publishing - - 1 55 200 200 360 Insurance 52 60 1 00 1 05 1 08 :::l::l~::l:::l:l:::;:l:::::Il!lil!I::l:::::::::::l::::::::::::::::::::1:1:1::11:::;~::::::':~:!!~::::1::!~~i:l!:::::!::::::::!~!:~~l:l~::::!:~~~~~l.~:::::~!:!:::::!:~:~~~::::1::~:::1!!:~[!:~:1 Other Services and Charges 401 ReDair/Maint. - Labor $ - $ - $ - $ 1 00 $ 1 00 406 Contractual Services 1 ,41 2 69 4,407 5,000 5,000 41 0 Rentals - 500 - 500 500 41 5 Equipment Services 450 679 672 760 788 41 6 ComDuter Services - 85 1 50 - - 433 Dues/Registrations - - - 300 300 o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This division is responsible for the general administration of the Park and Recreation Department, maintenance of all city parks and financing some park improvements. PARKS CITY OF ANDOVER 2000 BUDGET WAGE DISTRIBUTION 12/30/9911 :08 AMPPARKS.xLS GROSS HEALTH DENTAL LIFE rl ~ ~ FICA MEDICARE INSURANCE INSURANCE INSURANCE TOTAL POSITION DESCRIPTION ASST. ENGINEER 14,340 743 889 208 543 63 28 16,813 CIVIL ENGINEER 5,365 278 333 78 462 25 11 6,551 ENG.SECRETARY 7,125 369 442 103 434 50 22 8,546 ENG. INTERNS 962 50 60 14 0 - - 1,085 ENG. TECH IV 9,554 495 592 139 924 50 22 11,777 ENG. TECH IV 9,064 470 562 131 924 50 22 11 ,224 ENG. CLERK 1,179 61 73 17 109 13 6 1,457 SUPERINTENDENT 8,666 449 537 126 693 38 17 10,525 JEFF O. 817 42 51 12 43 5 2 973 BRIAN K. 496 26 31 7 22 3 1 585 DENNIS M. 716 37 44 10 92 5 2 908 TERRENCE S. 23,271 1,205 1,443 337 3,003 164 72 29,495 CHRIS O. 761 39 47 11 43 5 2 910 JEREMY J. 22,612 1,171 1,402 328 2,772 151 66 28,502 IRWIN R. 754 39 47 11 43 5 2 901 RAYS. 769 40 48 11 92 5 2 967 ANDREW K. 716 37 44 10 92 5 2 908 SCOTT P. 381 20 24 6 46 3 1 479 TOM JOHNSON 23,365 1,210 1,449 339 2,864 156 68 29,452 MERYL P. 678 35 42 10 92 5 2 865 RON SCOTT 6,783 351 421 98 924 50 22 8,650 OVERTIME 4,500 233 279 65 - - - 5,077 TOM SCHANDER 31,718 1,643 1,967 460 4~~20 252 110 40,769 ... ....... ....... .... ................... ...... ... .... ............. ...... ............. .....'.' ,_....... .......... ........ .. .... .....,... ........ .......................... PUBLIC WORKS SEC. 2,374 123 147 34 416 23 11 3,128 PARKS CITY OF ANDOVER 2000 BUDGET WAGE DISTRIBUTION 12/30/9911 :08 AMPPARKS.XLS IOYCLlNG COORD. 646 33 40 9 92 5 2 829 EMPLOYEE (REC.) 1,179 61 73 17 109 13 6 1,457 DATAENTRY CLERK 1,540 80 95 22 231 13 6 1,987 WARMING HOUSE ATTD 44,800 - 2,778 650 - - - 48,227 SUMMER HELP 19,200 - 1,190 278 - - - 20,669 COMMISSION 3,840 238 56 4,134 GRAND TOTAL 277,108 10,840 17,181 4,018 22,367 1,303 570 333,387 o o r CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/9911 :09 AMPARKS.XLS o 1999 BUDGET CLASSIFICATIONS # OF EMPLOYEES 1999 WAGES 2000 BUDGET # OF EMPLOYEES 2000 WAGES Personal Services SuDerintendent 0.150 $ 8,255 0.150 $ 8,666 30,249 Supervisor 0.610 29,444 0.610 Assistant Enaineer 0.250 13,720 0.250 14,340 Civil Enaineer 0.100 5,365 Ena. Secretarv 0.200 7,125 ...... 0.050 962 , IJSL Interns Eng. Tech IV's 0.400 18,619 Ena. Clerk 0.050 1,179 Maintenance Workers 3.200 103,956 3.200 117,024 Public Works Secretarv 0.100 2,653 0.100 2,374 Recyclina Coordinator 0.020 589 0.020 646 Public Works Clerk 0.050 930 0.050 1,179 Data Entry Clerk 0.050 1,128 0.050 1,540 Part Time Summer HelD 3.000 19,200 3.000 19,200 Warmina House Attendants 7.000 44,800 7.000 44,800 Commission 3,840 3,840 C 1\ Total .. 14.430 - $ 228,515 15.230 $ 277,108 , o o o ~ CITY OF ANDOVER 12/30/9911 :09 AMWPARKS.XLS Expenditure Budget Worksheet Budget Year 2000 PARKS DEPARTMENT # 45200 General Fund Object Actual Actual Actual Budget Reouest ~ 1996. 199Z 1998 1i9a 2QOO Personal Services 1 01 Salaries $ 1 40,864 $ 1 02,687 $ 1 60,31 7 $ 224,675 $ 273,268 1 06 Commission 1 ,800 2,490 1 ,990 3,840 3,840 1 21 PERA 5,631 3,894 7,366 8,323 1 0,840 1 22 FICA 8,772 6,534 9,450 1 3,930 1 7,1 81 1 25 Medicare 2,051 1 ,527 2,21 0 3,258 4,01 8 1 31 Health Insurance 9,735 7,1 57 1 4,554 1 9,1 76 22,367 1 32 Dental Insurance 685 365 971 1 ,066 1 ,303 1 33 Life Insurance 65 41 66 423 570 i:l::i:::l::::il!:i::i:!iiiiilillli:iiili:i:liiiii:iliii:!ii:ii:l:i::::::'::::::::::i~i:i:l:!:::::::!::1:!~!:!i:l::::I:::::!:::1:~~!!!ii!i~~:::~~!~!!:::::~:::~!!:!!~!;~:::::::::!!::~:::!~!!~~~: ~lInnliAllO ="nti M="tAri="lllO 201 General Office Supplies $ 1 ,389 $ 1 ,534 $ 2,41 2 $ 1 ,200 $ 1 ,500 21 0 Operating Supplies 1 0,1 91 1 0,338 1 3,923 1 2,000 1 3,000 21 1 Cleanina SuDplies 214 51 1 1 76 700 700 220 ReDair/Maint. - General 6,593 1 0,720 1 1 ,1 90 1 0,000 1 0,000 225 Repair/Maint. - Landscaping 1 3,535 1 6,540 1 3,029 1 7,000 1 7,000 240 Small Tools 1 ,494 1 ,437 1 ,974 1 ,500 1 ,500 iiiiiiii!i:!ii,ii~!:::!i!:il!lIIii:i:i:l:i:!i:i::'~::::::::::::::i!::::i:iiii!ii:ii:!i:i!I:::::::~'~~!:~~:::l~:::!i:;:::~~l~~::i:::I:::~:!!~I~f!i::i:~:::::I!~I~~~::i::i:I:!::!'::!!!3!~:i Purchased Services 301 Professional Services $ 1 ,81 7 $ 2,251 $ 2,248 $ 4,800 $ 4,800 321 Telephone 787 992 2,1 64 1 ,200 1 ,300 322 Postage 245 400 353 600 600 330 TransDortation - 1 8 23 50 50 351 Publishing 438 752 522 300 300 360 Insurance 6,700 7,638 8,000 8,400 8,652 381 Electric 5,455 3,893 4,896 5,000 5,000 383 Natural Gas 767 - - - - 384 Refuse Collection 4,226 4,001 6,651 5,000 6,000 390 Taxes - 688 441 750 800 :::!!!!::iii:ii::ii::::liiiil,ili~liii:iiiiiiii!ii:iiii!iiiii:::::::::::::::!:iii::ii~:::'::::::~}.~:::::1:~:~~~:!~~~~~:!I~::~::::::~.~:i:::I::::,:::::~!!~~qii:iii~:~:::!::l!~i~~~: I OthAr SArvi~AllO ="nd 401 Repair/Maint. - Labor $ 4,986 $ 7,1 23 $ 5,1 1 4 $ 7,000 $ 7,000 403 Repair/Maint. - Improvements 5,436 6,893 5,534 7,000 7,000 406 Contractual Services 1 2,383 22,01 3 1 8,782 20,000 20,000 41 0 Rentals 7,958 6,762 8,928 1 0,000 1 0,000 41 2 Inspections 91 4 - - - 41 3 ReDair/Maint. Trails - - - 1 0,000 1 0,000 41 5 EauiDment Services 23,000 34,688 34,351 38,848 40,246 41 6 Computer Services - 85 1 50 - - o o o CITY OF ANDOVER 12/30/9911 :09 AMWPARKS.XLS Expenditure Budget Worksheet Budget Year 2000 Obiect Actual Actual Actual Budget ReQuest ~ 1996. 199Z 1998 1i9a 2QOO PARKS - CONTINUED CaDital Outlav 530 ImDrovements $ 25,698 $ 35,582 $ 40,818 $ 60,000 $ 30,000 570 Office Equipment 48,700 - - - - 1;::;:li:i:::it::::I::i:ili.iii::t.::.::i:i:l~l::::::::l:~::i:::::::::::::::~::::::::::~:::::::::l::l_:~:::-:11::~-:::!::_::~::_~' Debt Service - Assessments 603 Assessment PrinciDal $ 35,898 $ 17,447 $ 17,454 $ 18,000 $ 16,557 613 Assessmentlnterest 7,663 9,117 7,285 8,000 4,322 1::ll:::il:':i:::~:I:':l<~iiiili'i:::'l'::i:':i:'::i,i:il:l::l::::~:::::':::::l::l::::l:~::_::I::l_:ll:_::'ll:_1::~:::_:1 ........ .................... ........... ......... ....... ..... ..... ....... ...... :.:.:.:.:..... . .................... '''' , o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET Sunshine Park shall provide an area for community recreation. o o o CITY OF ANDOVER 12/30/9911 :09 AMWFIELD.XLS Expenditure Budget Worksheet Budget Year 2000 SUNSHINE PARK DEPARTM ENT # 41 995 General Fund Object Actual Actual Actual Budget Request ~ 1996. 199Z 1998 1i9a 2QOO ~lInnlil'!~ :Inri MAtl'!riAls 201 General Office SupDlies $ - $ - $ - $ 20 $ 20 21 0 ODe rating Suoolies 1 0 249 524 600 1 ,000 21 1 Cleaning SuDDlies - 41 9 751 500 500 220 ReDair/Maint. - SuDDlies - 1 04 639 700 1 ,000 223 Repair/Maint. - Building - 1 83 61 3 1 ,000 1 ,500 :::'~l::~::l::l::ll::::::::::j.l~~!!!If:I~j:::lll::::::::::::::'::::.::::::::.::',:~::::::::::Ii::~:'::.::"::':::::::~11:~jl:i.i::!:::.,::i':::::::i~?~!::::~~:::::::~:::~i~~::::::~.~::~:!::~~::::::rt~::::~:::::'~i!:~~: Purchased Services 321 TeleDhone $ - $ 1 ,247 $ 1 ,51 6 $ 1 ,497 $ 1 ,497 360 Insurance - - 500 525 550 381 Electric - 2,749 3,401 1 ,500 2,000 382 Water and Sewer - 22,520 1 0, 1 89 1 0,000 1 0,250 383 Natural Gas - 1 , 1 02 675 1 ,800 1 ,800 384 Refuse Collection - 1 ,000 - 1 ,000 1 ,000 390 Taxes - - 80 - 1 00 1::::!::::::~::I':!:::l:::::::::~::::!I~g~!~:::::::::::::::::1::::'::::::::::.::::::1::::::::~:~::::~:~~:1::::::~!:::::::!11:~~:~i?~:!:::::::I~:!!!:~:?~~::::::~:!~::~~~~~!:::::::I:!::~~:~\~:~!::: Other Services and CharQes 401 Repair/Maint. - Labor $ - $ 606 $ 259 $ 2,000 $ 3,400 402 ReDair/Maint. - Building - 449 549 1 ,500 3,500 406 Contractual Services - 2,862 1 ,485 3,000 3,000 41 0 Rentals - - - 800 800 :l!:l::::l:::::::l::ll:::!i~III~::::::::::::::::::::::::::::::::::::::1:::::~::::::::::::1:~:!:1:::::1~::::::!:~i~~~::::::~:::!::::::::~\I~::::~::::::l:::~~~~::;::!~~~!~:~~~!~~:: " f] .. " ., .' ;:::- " o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET To promote recycling within the City and educate residents as to the importance of recycling. CITY OF ANDOVER 2000 BUDGET WORKSHEET 12/30/9911:10 AMRRECYCLEXLS r\ GROSS HEALTH DENTAL I LIFE ..... WA!iE PERA ~ MEDICARE INSURANCE INSURANCE INS' TOTAL POSITION DESCRIPTION SUPERINTENDENT 2,889 150 179 42 231 13 6 3,508 KEVIN S. 998 52 62 14 92 5 2 1,225 RAYS. 817 42 51 12 43 5 2 973 BRIAN K. 991 51 61 14 43 5 2 1,169 SCOTT P. 381 20 24 6 46 3 1 479 DENNIS M. 716 37 44 10 92 5 2 908 IRWINR. 377 20 23 5 22 3 1 451 ANDY K. 716 37 44 10 92 5 2 908 MERYL P. 678 35 42 10 92 5 2 865 RON SCOTT 1,696 88 105 25 231 13 6 2,163 OSO. 761 39 47 11 43 5 2 910 JEREMY J. 754 39 47 11 92 5 2 950 JEFF O. 769 40 48 11 92 5 2 967 SECRETARY 1,187 61 74 17 208 11 6 1,564 DATA ENTRY CLERK 770 40 48 11 116 6 3 993 GENERAL CLERK 590 31 37 9 54 6 3 729 RECYCLING COORDINATOR 25,521 1,322 1,582 370 3,650 199 87 32,731 ERICK SOHR 962 50 60 14 - - - 1,085 GRAND TOTAL 41,572 2,153 2,577 603 5,242 299 131 52,577 o CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/9911 :10 AMRECYCLE.XLS 1999 BUDGET CLASSIFICATIONS # OF EMPLOYEES 1999 WAGES 2000 BUDGET # OF EMPLOYEES 2000 WAGES Personal Services Su erintendent 0.050 $ 2,752 0.050 $ 2,889 Su ervisor 0.060 2,887 0.060 2,806 Maintenance Workers 0.190 6,114 0.190 6,848 ublic Works Secreta 0.050 1,326 0.050 1,187 Public Works Clerk 0.025 465 0.025 590 DataEnt Clerk 0.025 564 0.025 770 Rec clin Coordinator 0.790 23,248 0.790 25,521 Rec clin Maintenance 0.500 5,000 0.100 962 Total 1.690 $ 42,356 1.290 $ 41,572 o o RECYCLING DEPARTMENT # 461 40 General Fund Object Actual Actual Actual Budget Reauest ~ 1996. 199Z 1998 1i9a 2QOO Personal Services 1 01 Salaries $ 1 9,595 $ 21 ,622 $ 33, 1 61 $ 42,356 $ 41 ,572 1 21 PERA 722 849 1 ,703 2,1 94 2,1 53 1 22 FICA 1 ,1 91 1 ,347 1 ,938 2,626 2,577 1 25 Medicare 279 31 5 453 61 4 603 1 31 Health Insurance 243 381 2,206 4,889 5,242 1 32 Dental Insurance 21 27 1 20 275 299 1 33 Life Insurance 2 3 4 1 09 1 31 l:::::::::::ll:::::~l::!lll::l.!~g~~~:::::::::::::::::::::::::::::::::::::::::::::::~::':::.:.~!::::l~:::::1:::~:~~;~~~:::1~:::~:~:~~1.~!:!!.!::~:1~:!:~::::::::~~~~~::::::i~::!l:::::':~~!~~::l , And MAteriAl!:: 201 General Office Supplies $ 209 $ 220 $ 304 $ 300 $ 300 21 0 Operating SupDlies 2,1 79 91 9 766 9,000 9,000 220 ReDair/Maint. - General 97 - - 250 250 223 Repair/Maint. - Building - - 48 500 500 ;:i::!!::!::!!:::::,:i::::::~::::::::::'!.!iiift~,::':::~,!::~::::!:::,!,!:,::,::::::~:::::::!::~::::::!~.::::::\'-::::::':::::~~'I::':~:!~~I::::::!!:::~::!::~!~::~:~::!l:I!:::::::::::::::!~~~:::::,~~:!::!~::!:!~:!i~!~ Purchased Services 301 Professional Services $ 358 $ 367 $ 1 1 3 $ 400 $ 400 322 Postage 1 ,085 2,237 353 2,000 2,000 330 TransDortation 51 5 277 215 400 400 351 Publishing 2,81 7 5,521 1 ,1 41 3,000 3,000 384 Site Maintenance 1 460 1 674 1 380 1 300 1 400 Other ' "'n~ ChAr. Ie!': . 401 Repair/Maint. - Labor $ 51 9 $ - $ 77 $ 500 $ 500 402 Repair/Maint. - Building - - - 500 500 406 Contractual Services 21 ,862 22,268 28,998 23,000 24,000 41 5 Eauipment Services 200 302 298 338 350 41 6 ComDuter Services - 85 1 50 - - :I::_l!::_:~:::~:::~~-:l Capital OutliW 582 Equip. - Recycle Bins $ 1 ,576 $ 3,51 7 $ 2,925 $ - $ - CITY OF ANDOVER 12/30/9911 :10 AMWRECYCLE.XLS Expenditure Budget Worksheet Budget Year 2000 o o ~ C> o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET This division is to cover unexpected or emergency needs. It also finances miscellaneous items not directly chargeable to a specific function or activity. CITY OF ANDOVER 12/30/9911:10 AMWOTHUNAL.XLS Expenditure Budget Worksheet Budget Year 2000 o UNALLOCA TED DEPARTMENT It 49200 General Fund Obiect ~ Actual 1996. Actual 199Z Actual 1998 Budaet 1i9a ReQuest 2QOO Unallocated 151 Worker's Compensation 313 Mediation Services 499 Continaency 497 Employee Recognition $ 29,501 $ 21,777 $ 27,969 $ 32,000 $ 31,000 1,464 1,557 1,640 1,800 1,827 15,544 119,685 15,671 50,000 30,000 _ -. - - 2,000 ..J~"h:~:,i2i1iiifmiN':rlmrtril~ltlihrlt:r~fIll1m:AiWim J~jj~_4_!l&!I~1~!j!il~~;~~1~;~~~:~;~~;~~;;~;~:~1 Miscellaneous 819 Andover Fun Fest Contribution $ - $ - $ - $ 4,000 $ 4,000 820 Community Schools Proaram 51,377 48,886 50,295 51,858 52,285 ~ o OTHER FIN. USES 49300 General Fund Obiect ~ Actual 1996. Actual 199Z Actual 1998 Budaet 1i9a Request 2QOO Other Uses 458 CDBG $ 107,574 $ 69,264 $ 30,211 $ 35,000 $ 40,000 710 Residual Eauity Transfer Out 531,653 - 870,038 - - Ot~ o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET Special revenue funds are established to justify revenue sources to finance particular functions or projects. Revenue for these funds can come from a variety of sources, such as taxes, fees, gifts and grants or contributions from other governmental entities. Expenditures from these funds are normally restricted by statute, local ordinance, or grant agreements. The funds may be used for either operations or capital outlay as legal restrictions mandate. o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET To provide for the quality development of commercial and industrial properties to ensure a strong, viable and diversified tax base. en ...J >< q LlJ :a; a. C\l ~ T'"" en 25 ~ T'"" a:: z w 0 >1-1- OW;:) C~CC 0- ~ ;:) a:: w:-:"' cc ~ LLo- 000 OW >C\J~ I- <c (3 ~ f- Z UJ ::2 C- S UJ > UJ Cl () ~ o () UJ co en co .... C':l C\l 0 .... 0 to to en ~ en to I'- .... 0 I'- C'5 ci r-: .,f as .,f .... T'"" C':l 0 T'"" i 0 co T'"" T'"" C':l C\l l!) C\l T'"" ..... l!) l!) T'"" W u.. :::::i I C':l C':l l!) l!) T'"" co ...I T'"" to C\l C\l C\l .... ~ T'"" T'"" C':l Z W e i en l!) C\l I'- co ..... ::I: I'- l!) to T'"" T'"" C':l 0 ..... .... C\l C\l T'"" ~ N T'"" N cD ct W ::I: I l!) ..... C':l .... co T'"" C':l C\l en l!) l!) to l!) ..... .... C\l T'"" 0 I'- to ..... 0 .... en T'"" en C':l to en ~ C\l l!) C':l C\l O!. C':l N T'"" L6 C':l C\l T'"" C':l co I'- T'"" C':l C':l en C':l 0 il en .... C':l ..... ~ l!) T'"" ..... .,f co l!) 0 C\l to 0 lf) ! C\l C':l en C':l T'"" 0 lf) en C':l C':l I'- to 0 0 ~ cD as cD C'5 T'"" r-: a: C':l C':l co ~ ~ I- a: Cl !:!: >- ~ a: ~ z a: 0 ...I 0 f:!: (J - 0 g ~ LlJ LlJ I- (J W a: a: z ::> l- e ct a: (J Cl I- LlJ e ~ I- LlJ !:!2 LlJ Z Cl Z en (J ::) ct I- Z cj Z 0 :a; a: g :a; LlJ <( (J :a; e" Cl >< Z (J 0 c.. <( LlJ iI: <( (J CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/991 :42 PMEDA.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Administrator 0.500 $ 37,992 0.450 $ 36,928 Exec. Secretarv 0.230 7,010 0.250 8,335 Finance Director 0.150 9,909 0.100 6,390 2munitv Dev. Director 0.480 29,303 0.480 31,616 Accountant I 0.100 3,321 0.100 3,732 Total 1.460 $ 87,535 1.380 $ 87,000 o CITY OF ANDOVER 12/30/991 :42 PMECONDEV.XLS Revenue/Expenditure Budget Worksheet Budget Year 2000 o ECONOMIC DEVELOPMENT AUTHORITY SPECIAL REVENUE Revenues Revenue ~ Actual 1996. Actual 199Z Actual 1998 Budget 1i9a Request 2QOO 31050 CurrentTax Increments $ 4,000 $ - $ - $ - $ - li!::lil::l:::iliiii:,l:::::!i::i:iil:l:::i:::::'illl!1~!~II::::::::i::lii:i:::::~~_i:_~I::I_::I~:_:i:li:~~-,:, 34101 Rental Fees $ - $ 1,200 $ - $ - L"""""",;"";",:~,;",;,J",:,,;;,;,,,;~:,;;,~"''''-';';'*,",'',",~""""""""""""",}"',!,,,,~~,~bii2;%;;%ii_i?~tlt~twt\iltrrrrrrtt::rr:tbrl 1~~ttI~r~1~Iml!~I1~m[1~mmmm11mttl1tt:"\'~mt1If:rtJJ1nI1~i?~;~;g;@i{~1~1~j~@g#!~@g;~~~t~~t~f.;;~#.i;;;;;~!;tr:~:~:~::::~:~:I 36240 TIF Admin. Fee $ 78,200 $ 78,200 $ 82,000 $ 82,000 $ 85,000 36210 Interest Earned 1,500.00 314 2,841 1,326 2,000 36212 Valuation Adjustment - - 202 - - - o Expenditures Obiect ~ Actual 1996. Actual 199Z Actual 1998 Budget 1i9a Reauest 2QOO Personal Services 101 Salaries $ 53,460 $ 58,288 $ 81,295 $ 87,535 $ 87,000 121 PERA 2,566 2,667 4,251 4,534 4,507 122 FICA 3,315 3,581 4,885 5,427 5,394 125 Medicare 775 845 1,169 1,269 1,261 131 Health Insurance 3,454 3,834 5,359 6,367 6,131 132 Oentallnsurance - 289 381 368 348 133 Life Insurance 11 19 24 146 152 :::ii:il:iii:l,::::i:iil::iill:l::::!illl::il::~:l::l:llii:il:::l:i,i:~::i:~::i::l~:::::~::::::l::~~i~~~:::,;:i;!!::::::::'::::::!~;~~:lll~:::!:~:::!::':::::~~i~~::i:ii~::::::l:::~~~~~:::::::~:::::~!'::::~~i!~ Supplies and Materials 201 General Office Supplies $ 4,000 $ 82 $ 100 $ 2,000 $ 2,000 o CITY OF ANDOVER 12/30/991 :42 PMECONDEV.XLS Revenue/Expenditure Budget Worksheet Budget Year 2000 Object Actual Actual Actual Budget Request ~ 1996. 199Z 1998 1i9a 2QOO Purchased Services Professional Services $ 3,000 $ 298 $ 1,785 $ 2,800 $ 3,000 Attorney 2,100 192 2,100 3,000 Postage 250 500 500 Transportation 1,500 1,500 1,515 1,800 2,000 Publishing 2,000 745 1,074 2,000 2,000 Rate Programming 5,000 Insurance 1 Other Services and Charces Com uter Services Dues/Registrations Meals/Lodgin Continued Education C;:ontingency $ - $ 1,000 170 $ 548 - $ 9 24 170 $ 1,000 o Eq!Jity Transfers Residual Equity Trans. ou $ Transfer to Other Funds - $ - $ 2,000 $ - $ o o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET To maintain existing and develop new mapping information systems for use by city staff and city customers. CITY OF ANDOVER 12/30/991 :43 PMDRAINMAP.XLS Revenue/Expenditure Budget Worksheet Budget Year 2000 ^ .... DRAINAGE & MAPPING FUND SPECIAL REVENUE Revenues Revenue ~ Actual 1996. Actual 199Z Actual 1998 Budget 1i9a Request 20.00 34136 Drainage Revenue $ - $ 1,310 $ 8,293 $ 14,000 $ 14,000 34137 Mapping Revenue - 4,017 16,144 31,550 29,850 36210 Interest - 2,684 2,408 700 700 36212 Valuation Adiustment - - 281 - - 36247 Topographical Maps - 397 857 - - ~I Expenditures Object ~ Actual 1996. Actual 199Z Actual 1998 Budget 1i9a Request 2QOO C 101 122 125 Personal Services Salaries FICA Medicare $ $ - $ - $ - - - - - - - - - .. ..... ImDrovement Proiects . 201 General Office Supplies $ - $ 351 $ 1,140 $ 5,000 $ 5,000 210 Operating SuDDlies - 613 1,043 1,500 1,500 301 Professional Services - 14,180 16,289 32,500 32,500 303 Consulting Eng. - General - 785 7,299 5,000 5,000 412 InsDections 903 107 445 - - 416 Computer Services - 2,125 2,200 2,200 - 433 Dues/Registrations - - - 50 50 ~ - o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET o The function 'bf the Lower Rum River Watershed Management Organization (WMO) is to provide for: coIiservationof water and natural resources; prevention and alleviation of flood damage; and regulation of creeks, lakes, water courses and storm water conveyance systems for domestic, recreational and public use across municipal boundaries. To achieve this purpose, state law gives watershed management organizations several powers, among which are: 1. 2. 3. 4. 5. 6. 7. 8. 0 Responsibility for preserving natural retention areas. Preparation of plans for water management. Review of municipal water management plans and of projects directly affecting the water resources of the watershed. Review of local land use in the absence of an approved municipal surface water management plan. Collection of data. Conducting of studies and investigations. Construction of improvements, either in response to petition or on the initiative of the WMO. Levying of taxes and assessments for the financing of the previously mentioned activities and for general administration of the organization. o GROSS WAGE PERA ~ ME'DICA . POSITION DESCRIPTION ASSISTANT ENGINEER 11,529 ENG. SECRETARY 1,069 ENG. TECH 4 1,360 ENG.CLERK . I" GRAND TOTAL ..... 13,958 o 597 55 70 723 715 66 84 . 865 167 202 12/30/991 :44 PMLLRRW,XLS HEALTH DENTAL LIFE 'RA~ ~AAN~ NSURANC~ TOTAL 15 20 436 65 139 640 51 8 8 66 22 29 13,517 3 1,282 3 1,684 . 16,483 CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/991 :47 PMRUMRIVER.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Assistant Enoineer 0.201 $ 11,031 0.201 $ 11 ,529 Ena. Secretarv 0.050 $ 1,069 Eng. Tech 4 0.050 $ 1,360 R Clerk 0.025 $ - Total 0.201 $ 11,031 0.326 $ 13,958 o o LOWER RUM RIVER MGMT. DISTRICT SPECIAL REVENUE . Revenues Revenue Actual Actual Actual Budget Request ~ 1996. 199Z 1998 1i9a 2QOO Permits 31010 General Property Tax $ 10,395 $ 11,794 $ 11 ,286 $ 13,981 $ 21 ,430 31020 Del. Ad Valorem Taxes - 108 106 - - 31040 Fiscal Disparities 3,000 2,217 2,497 2,152 - 33402 HACA 3,470 2,547 2,546 1,867 - 36210 Interest 100 227 451 200 200 36212 Valuation Adjustment - 45 - Expenditures Obiect Actual Actual Actual Budaet Request . ~ 1996. 199Z 1998 19W 2QOO Personal Services 101 Salaries $ 9,544 $ 9,553 $ 10,296 $ 11,031 $ 13,958 121 PERA 428 436 532 571 723 122 FICA 592 541 580 684 865 125 Medicare 138 127 136 160 202 131 Health Insurance 498 571 627 698 640 132 Dental Insurance - 53 51 51 66 133 Life Insurance 5 3 3 20 29 1:.llili'::::ilii::i:i::i::~l:::::'I:i'liliiiii::::::ii::::::il::l::!~:::i!::1::::i~!_lil!:_::(\!~_::I:::.1I.III1::l:111.III:' lies an~i"'l.. 210 Operating Supplies 9; 555 9; - $ - $ 519 $ 519 Il::::::l:~:lii::'::i::::::~::!:::\\:i:~,_:iii:.l.:i::i:::~:.1~:::~:i:i:::::.::!:~1_1:lll_:~~::_::~11l.lll:!~::_1:1 ................. ........... ........... .............. ... ............ ........ ....... Purchased Services 303 Consulting Engineer $ 520 $ - $ - $ - $ - 304 Attorney - - - 460 460 Other Services and Charoes I 454 Lower Rum River 9; 4.205 9; 2947 $ 2,923 $ 4,205 $ 4,205 ...................... ... ....................... ....... .......... ... .. ... CITY OF ANDOVER 12/30/991 :47 PMLOWERRUM.XLS Revenue/Expenditure Budget Worksheet Budget Year 2000 o o o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET ':.'.. The Forestry Department shall preserve Andover's forest resources and develop control plans to ensure preservation of these resources. 0 . GROSS HEALTH DENTAL LIFE WAGE PERA .E!.CA MEDICARE INSURANCE INSURANCE INSURANCE TOTAL POSITION DESCRIPTION FORESTRY INTERN 9,620 - 596 139 - - - 1 0,356 GRAND TOTAL 9,620 - 596 139 - - - 10,356 CITY OF ANDOVER 2000 Budget Wage Distribution 12/30/991 :48 PMFFOREST.xLS o o CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/991 :48 PMFORESTXLS o 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Forestrv Intern 0.500 $ 9,078 0.500 $ 9,620 Total 0.500 $ 9,078 0.500 $ 9,620 o o CITY OF ANDOVER 12/30/991 :48 PMFORESTRY.XLS Revenue/Expenditure Budget Worksheet Budget Year 2000 FORESTRY SPECIAL REVEN U E FUN D CI Revenue Actual Actual Actual Budget Request ~ 1996. 19iZ .1m ~ ~ Revenues 33422 Other Grants $ - $ 40,260 $ - $ - $ - 341 22 Site Plan Review - Trees - 9,661 1 2,360 1 1 ,000 1 1 ,000 341 44 Forestrv Intern Fees - 1 1 ,384 532 5,000 5,000 3621 0 Interest Earned - 1 ,31 2 1 ,337 772 1 ,300 3621 2 Valuation Adjustment - - 1 91 - 36260 Refunds & Reimbursements - 35 - - 256 3l:l2U1 I ransters trom other funds - 1 ,5UU - - - . lie 'ij 0;:>'." :;>:;. .~. ,. ",[@!", , , , '. '" '" .<< .. Expenditures Obiect Actual Actual Actual Budaet Reauest ~ 1996. 19iZ .1m ~ ~ Personal Services 1 01 Salaries $ - $ 1 0,409 $ 9,622 $ 9,078 $ 9,620 1 21 PERA - - 1 54 - - 1 22 FICA - 645 594 563 596 1 25 Medicare - 1 51 1 39 1 32 1 39 . 1 31 Health Insurance - - 209 - - 1 32 Dental Insurance - - 1 7 - - 1 33 Life Insurance - - 1 - - 0 :::::II::::lli::l:::::::::II,,!I!M:::l:::::I::::II::1I::::I:::::l~~:~:~::::::::::::::::~:::::!::~~i:~::::fti;~.~:I~::::::::::~~;?~::::~:'~::1:1~;~::::~:~::~:1~1!~~~: ~lInnli~~ and Mat~rial~ 201 General Office SUDDlies $ - $ 1 1 3 $ 236 $ 500 $ 600 :1~:i:l::i~:~II:l::i~~!i~::I~~:l"'~:I:_:::1 Purchased Services 304 Attornev $ 93 $ - $ - $ - 330 TransDortation - 1 9 94 - - 353 Publications - - 265 500 500 II'::I:;::I~;:I:I:::~:::::I::;li_l::::IllI;l;:::::;:~.l::II::"~::::;::;;l!~'::f:l::~::::f::::i.'~]:::~I~~::~~:::I~::f::'l:~:::::~:::l::::::::~l::~~~':':::~l::::::::::::i?'l::::~i:::i::~::~:~:::~::~:i~mq: Oth~r ,and 406 Contractual Services - - $ - $ 5,000 $ 5,000 433 Dues/Reaistrations - - - 300 300 435 Subscriptions - - - 1 00 1 00 442 MealslLodging - - - 1 00 1 00 ::1::::::1::::::1::111:::::1::::111111::::::::::::1::::1:::::::::::::::::::::::::::::11:~:1:1~~1:!::1!~,:~::::::~:~:1::1::!::::::~:::::::::!~:::::::~!1!:1:::::~::!~:::li~l!:~~~i~~:::::i~::::~~:l:~:!iI~:: Transfers 71 0 Residual Equity $ - $ 30,205 $ - $ - $ - ::~l::::l:::::::l:::::::::::l::II.ll:::l::::::::::::::::::::::::::::::1:1::1:::::::::::::,~::::1:::1:::::~:l::~::::::::l~~!::I::[,-::::::::::::::::~~~:ll~::::::::::::1!::::!:::~1!~1:!::::::::!:::::!:~:: 0 o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET CITY OF ANDOVER 12/30/991:50 PMSEPTIC.XLS Revenue and Expenditure Budget Worksheet Budget Year 2000 SEPTIC DISPOSAL FUND SPECIAL REVENUE Revenues Revenue ~ Actual 1996. Actual 199Z Actual 1998 Budget 1i9a Request 2QOO 34138 Se tic Dum ing Fees 36210 Interest Earned 36212 Valuation Adjustment ::::::1::11;::1:;::::1:1::::11::;1::::':::::;::1::1111111f::::;I::: $ 3,550.00 $ 3,300 $ - $ - $ 88.75 458 545 100 100 56 :;:::::,:::I:::!'~::~!!!~~!~:::::I::::::':::::!::!::::~t!!~::::I:~::~:::~::::::::!:!:!!:~~:::::!!:::::!:::!!!::::::::::::::::!~::ll:::::::::::::!:::~::~:!::!::~ Expenditures Ob'ect Actual Actual Actual Budget Re uest ~ 1996. 199Z 1998 1i9a 2QOO $ $ - $ - $ 100 $ 100 o o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET . To Provide funding for Capital Expenditures. CITY OF ANDOVER 12/30/991:53 PMCAPEQUIP.XLS Expenditure Budget Worksheet Budget Year 2000 o CAPITAL EQUIPMENT SPECIAL REVENUE . Revenue Actual Actual Actual Budget Request ~ 1996. 199Z 1998 1i9a 2QOO Revenues 3621 0 Interest $ - $ 7,071 $ 69,374 $ - $ 58,000 3621 2 Valuation Adiustment - - 6,1 61 - - 39201 Transfer From Other Funds - 364,800 1 0,000 320,479 39202 Residual Equity Transfer In 591 ,727 - 1 ,060,638 - - 3921 0 Transfer from Sewer Fund - - 33,71 8 - 1 51 ,998 3921 3 Transfer from Water Fund - - 242,000 - 7,000 Obiect Actual Actual Actual Budaet ReQuest ~ 1996. 199Z 1998 1i9a 2QOO Expenditures Other Services and Charges 21 0 Operating SuDplies $ - $ - $ 5,209 220 Repair/Maint. SuDDlies - Gen. 3,769 401 Repair/Maintenance - - 1 2,890 406 Contractual Services - 1 3,408 9,21 2 41 0 Rentals 25,950 2,793 - Il:ll'ili~I:::I::::::!:i:i1i~li~:li~..I~::::::::.:I::1:::::::::~:::_:I-l:lIIiIj:_::I::-l r...nit... O"tl"v 530 Improvements $ - $ - $ 1 ,980 $ - $ . - 550 Vehicle 20,1 41 22,274 - - - 570 Office Equipment - - 9,323 - - 580 Equipment - 42 012 124 426 :1:::::::::::1:11::1:::':::::1::::::::::::::::::::1:::~:::l:l:::::i::::~i!I"I:::::::::l::::::::::::::l::::::~::~:~::::::~~~~~~1:::::1::~:::::~~~l'~::::::~~:~~:~1~~~1~:::::~::::~:~~:!:::::::::::::1~::::::1::!::1:!~,:::i~l~!:l:: Other Financing Uses 720 Transfer To General Fund $ - $ 246,200 $ 50,000.00 $ 320,479 $ 575,633 . .,................................ ..n. ....................... ..n nn..' ,.n. n. ........ .n.. .:.}R:::' ::.::::::::::~::::::::::::::: ... ............. :::::::: ...................... .......... ",' o o o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET o CITY OF ANDOVER 12/30/992:34 PMOAKWILTXLS Revenue and Expenditure Budget Worksht;!et Budget Year 2000 OAK WILT S U PPRESSION SPECIAL REVENUE . Reven ues Revenue Actual Actual Actual Budget Request ~ 1996. 199Z 1998 1i9a 2QOO 33422 Other Grants $ - $ - $ 1 0,000 $ 5,000 $ 5,000 3621 0 Interest - 493 1 57 200 200 3621 2 Valuation Adjustment - 5,1 09 1 1 - - 36260 Refunds & Reimbursements - - 7,057 5,000 5,000 39202 Residual Equity Trans. In - 30,205 - - - --1'1 ....... . :.':." . ~ ;."~ ,,' ~I::::i', .::. ~. . :.' .~: '."'~' . " .... . . ...:: .: '.. .~ : :..........; ;::'V : . . . C Expend itures Object Actual Actual Actual Budget Request ~ 1996. 199Z 1998 1999. 2000 Imnrnv~m~nt Pr 21 0 Operating Supplies $ - $ 395 $ - $ 1 00 $ 1 00 330 Transportation - 290 - - - 406 Contractual Services - 27,594 1 4,420 1 0,000 1 0,000 41 2 Inspections - 6,027 91 1 00 1 00 727 Transfer to Other Funds - 1 ,501 - - - ~ . :. . . . ;";:" :' ~ . : :~. : ': '.:'..' ;,' . .....: * ~ . .....::.:. .:'.. .:- .:.:.:.." : . o o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET A debt service fund accounts for the accumulation of resources for, and the payment of general long-term principal and interest.. k debt service fund may become a practical necessity in order to maintain control over the numerous principal and interest payments falling due to different dates. o lf) w ::) lf) ~ e z a:o wm >~ Oz Cc ~~ O~ >::) 1-0 _II.. 00 > a: ct :!i :!i ::) rn o Cl lml o -c .~ ~ ~I ..a o I- Cl ~ m c: l?! .Illm~ !!l N " ~ o l ~I ..!!l 1 ~I 0:: Cl c: :.a enl C:ca~ ~ ;; s o o J~ ~ ~ 0:: 01 m 'iU oJ 000 888 000 .... '" ..... '" '" .... C\iC\i ~;~ ~ "'.... ~ ~ S2 000 888 ui LCi 0 0..... co '" '" ..... C\iC\i ~mg ~I~ 000 00 0 00 0 g~ te ..... '" 0 N'cr; ) 000 000 000 000 '" '" ~ .....'" ~ Ncn 0000 0000 0000 oufciLO ~mcn..... (l') 0.. CD t--... 000 000 000 0"00 oco~ (l')(l')e\t 000 888 ui6 ui co '" '" co co .... cn"'C\i N ~ 000000 888888 anL6uici6 ui co "lOt C\I 0 0 (l') T-(I')'d"COlO C\I ui~~m ssss s 0000 0 0000 0 ui6uici c5 !Q.e~~ ~ 000000 888888 Ol.tfcioo ui C\I ('l:l 0 co 0 (l') C\I"1:t<OC01O(O ..n;~ m 00 88 60 ~~ o o o o .... '" ci ssss 0000 0000 0000 U)O)LOf'. --~- 00 88 00 ~& o o o I!f ~ 00 0 88 8 ufo ui ..... '" '" ...-q "!. 00 88 00 '" '" 0.. q o o o o '" !'2. ss s 00 0 00 0 co 0 "'''' co -c c o o o on ...... :s o 8 o ... .. on N ... ... Cl 8 o II) III ~ ... Cl 8 ~ cD ... Cl 8 o II) C') ,..: N ... Cl 8 on co III o .... ... m Cl '" a. 'f.'if!.. '" Cl .....'" <?u? 00 "'''' et:i.,; ~'" o~ -- ~~ ~ co..... ~~ ~:!:: ~'" c: o ~ B Q ~ ..... Ol '" -g '" 0 ~ lD o c: CD (I) .2 m"2 tii ,.... 0 .~ '0 III :c Ui l'J) Q) 0 -c-c" c r:: ti ~ ~.g ii; ~ c ClO:: m 0.5'0 G ; -g.!2. - Cl" 0 .Ill =mQ: 0 ..a 0:: <.> :E 00,= rJl E ..g .,ela. c ., el ssssssssss~o 000000000000 000000000000 ~~~~ggggg~g~ -ec~ce-e~t::..I'-LO !i 000000000000 8gggggggg888 tt>ci'LO'llioooooouio ~~g:g~g~~C\iro~o .... .. ~c?cD ~ o 0 8 8 LOu) '" '" '" '" c?cri So-Soo-SoSSS 0000000000 0000000000 OLOOOttiOIO"Oci'LO sa..~E.~~S2.!:9.~c:;j~ 0000000000 8888888888 uiuiuilO"'Lri'6LOOOU; CDC\I T""cot--.T""O) f'-.,C\ICO "'d"<DO>...-C\Im"d"..........v .. N N..o 000000000000 888888888888 ..oO'O'..o..ooO'O'O'..o..n..o C\i~::!g~~g~f6~~~ ~OO~N .. 00 <<>00"; '" -;fl."#'"#'"#''#."#'"#'''ifl.''ifl.-;fl. ~~~gM3~~~~~~ 0~~'-9~~~.j.~~-.i- ~OLOLOLb1OLOOOO..o ~~~~;:;:~~~~ "'''''''''' ~"''''8''''''' QQQQQQQQ-QQ ;;~~~~aiai~~~~ ......(I').q.LOL000..................0) t::~~~~~~~~~~ ~~~::::::::~~5S~~~ <c<co <c ~~d'; ~ S; ~ ~~~ ~ ~ 5 .~.~.~~ffi~~.~ ~m ~ c?jc?j~~m5C>c?jf'o-~~ E oooo:;:;So~oo m ,fg .g .g -g -g .~ ~ -g -g ~ -g. -g ~ s~~~~CI).2~~"C~~ tV ~EEEc~~EE~cE .~ c~mmm-c'-~~Cl~~ c. ~ m ~ ~ ~ 5 ~ m m c: m m ~ =eeee~geE;~Ees CD c. c. a. a..~ e c. 5..- c. c. .e :g..5..5..5..5-g0..5..5~..5..5..a ~oooo~oooooorJl .~ ci ci ci ci 0:: ci ci ci ci ci ci ., c. III o 8 on '" .... on ~ 0000 8888 0'..00'0' f'o-C\JLOLO C\JLOf'o-C> ..o~ o o o on '" .... oj 00 0 00 0 00 0 0..0 ..0 '" '" '" '" '" III ..J <c ~ .:( o W m ,s o g- :c "iii c: o c. Ol ~ m ,s ~ '" m " Ol .!!l -c c: o ..a Ol ;S c: o Ol Iii 8 l'l ":';: m Ol :E m o 000000 000000 000000 0'..0..0..00' ..0 C\J (J) 10 to 0 ~ LO(J)OOLOO~ <<i'N~ ,.- ~ ~~~~~ OCl)W~O ui""':uilOLO 8S;gt!!8 ~cD-ci-~~ (I').q. (I') (\JC\! QQ:!:::!:::!:: ~5S~~~ (I').q.LDwm ~~~~~ ,-,...'-,-,.- --0-- <x)1.O~(o(o lD .... '" co~o "'OlIO "'m'" m -I:: 0) ~m~ Ol ~ Ol ~~i~~ ~ o s'Ooa co CIJ m (I) (I) CIJ E -gai-g-g-g E ~~~~~ j ~~~~~~~ mooooo ....s.s.s.s.s g 51 " " " " " 0 E~~~~~ :E " f!ooooo ~ ~cicicicici >< to I- 0000 0000 0000 0'..00' ..0 LO ,... LO ,... ,- LO q f':, -;fl.-;fl. ~M3g 8"1'''': -ci-~~ -ci-('") '" 0.... ~QQ ~~~ .... '" '" ~~~ ;.55~~ Ol Ol m c: -c CIJ (I) ~ ~ ~ S Q) -6-6~ ~ ..a$ ..as".c; - in Q) Q) CD 0 ~"C"Co ~ c.E.EEcu "C '0 15 em ,l,! lim$c.t: .g ] "~ "~ <'!l .5t:'€w _ ~ <'!l <'!l q ~ s<coel .g ~ d';::g m CI) ;;::m~~ 'E ., o !~ z o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET 12/30/992:39 PMDEBTSER.XLS FUND DEBT DIVISION SPECIAL ASSESSMENTS CODE NO. CLASSIFICATIONS 321 329 337 333 342 344 DEBT 1977A IMP. 1995B REF. 1996 REF. 1997C REF. 1993 IMP. 1994C IMP. SUBTOTAL Revenue 36101 Assessment Principal- City 36102 Assessment Interest - City 36103 Assessments - County 31050 Current Tax Increments 33417 Municipal State Aid 36210 Interest Earnings 39201 Transfer In $ $ $ $ - $ 2,453 $ - $ 2,453 740 740 15,549 6,192 46,740 68,481 3,000 8,000 300 150 11 ,450 97,857 349,875 32,392 21 ,560 501,684 :::::::l::::::~:l::l::::ll::::::::::::l:::::::::::::::::::::::::::::::l::m.ll:I"'l!II:'::I::I::III~::~:;!Ii!tt::::ll::::::::::I~I::11:::~!1'1:l:I:::!!ffl:l:l~:!!:::::!II.': Expenditures 47000 Debt Service 601 Principal $ 65,000 $ 120,000 $ 300,000 $ 210,000 $ 365,000 $ 115,000 $ 1,175,000 1 Interest 20,250 5,820 26,700 9,450 66,613 40,550 169,383 0 Fiscal Agent Fee , 351 421 446 1,218 :::::::::::::!l:ll::l::!:::l::1 l:l:::::::l::::::l!:ll::!:I::llm.ll::;~::::I~I!~:::::I:~!!~l:~:::::1::l.1~~::11:1::::~~!f.:::::::I!IIfI~::::1::JI!~II:::::11::!::':.il~: o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET 12/30/992:39 PMDEBTSER.XLS FUND DEBT CLASSIFICATION GENERAL OBLIGATION BONDS DIVISION SPECIAL ASSESSMENTS CODE ~ CLASSIFICATIONS 345 346 348 349 DEBT TOTAL 1995A IMP. 1996C IMP. 1997B IMP. 1997A IMP. SUBTOTAL DEBT SERVICE 36101 36102 36103 31050 33417 36210 39201 :.:.:. ::: ::::@!:~~:~:~:~: :::::::.::::::: Revenue Assessment Principal - City Assessment Interest - City Assessments - County Current Tax Increments Municipal State Aid Interest Earnings Transfer In $ 4,671 $ 10,361 $ 168,874 $ 26,150 $ 210,056 $ 212,509 3,450 3,900 220,500 44,215 272,065 272,805 12,538 40,179 1,635 54,352 122,833 3,000 7,000 15,000 20,000 45,000 56,450 13,601 110,968 65,316 189,885 691,569 :::::::::::1::::::::::::::::::::::::::::1:::::::::::::m~~!l:::::::::::::::::::I!:::::III::::I::;~~~1:::1:~:::11111::::1~::.11~::::::1~!:::::1~11::::::~::::!~t!I~!:: 47000 Debt Service Expenditures Principal Interest Fiscal Agent Fee $ 240,000 $ 93,040 351 2,870,000 576,393 1,569 60,000 $ 20,675 785,000 $ 610,000 $ 1,695,000 $ 207,760 85,535 407,010 351 :::::':1:;::::;:::1::::::::::::1:::::::::1:11:::;:11;1:mil::l:::::::l::I::::IIi!!::::ll:::!!~.::ll::~::I!~!I::::I~~I~II::I;::!l!!i.l:::I:::::!!i!!~!~~ o CITY OF ANDOVER, MINNESOTA 12/30/992:41 PMDEBTSER.XLS 2000 ANNUAL BUDGET FUN~ ~ CLASSIFICA TIOf\ GENERAL OBLIGATION BONDS DIVISION SPECIAL ASSESSMENTS CODE llil. CLASSIFICATIONS 397 STORM SEWER 398 WATER 399 SEWER TRUNK TRUNK TOTAL DEBT SERVICE Revenue 36101 Assessment Principal - City 36102 Assessment Interest - City 36103 Assessments - County 31050 Current Tax Increments 33417 Municipal State Aid 36210 Interest Earnings 37251 Connection Charges $ $ - $ - $ 82,521 18,692 101,213 7,000 60,000 18,000 15,000 25,000 75,000 IIII::::I:::::I:III::::::::;::::;:I:::::!::I::IIIII:::::::II:::.:I:IIII:I;:::~lj[::II:III!:::~:::::::::l:~:::':~::IIII.::::::..~:I:~II~:::::I~II~::::::I:'::::::::~'lJ.jl1'I:: Expenditures 47000 Debt Service 601 Principal 611 Interest 620 Fiscal Agent Fee 727 Transfer $ $ - $ - $ 345,518 309,891 655,409 ::Ii::i:::::::::li:i:::::::;i::::i:::~::I::Ii'IiI:::~i:iiI~:;IiI::;::i:i:::Iirnlli~I:;:::::::i:;:::l:~::~:l::":l~I~:!;:;:i::;::_~i:::::i:':;I!I;I~~l:;'::;:::l:~::::::::::l.~III::: o o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET CITY OF ANDOVER, MINNESOTA 12/30/992:40 PMDEBTSER.XLS 2000 ANNUAL BUDGET FUND DEBT CLASSIFICATION GENERAL OBLIGATION BONDS DIVISION TAX INCRE. CODE J::l.Q. CLASSIFICATIONS 347 347 378 379 352 TOTAL TIF 19950 TIF 1996A TIF 1993B 1994B REF. TIF 1999 DEBT SERVo Revenue 36101 Assessment Principal- City 36102 Assessment Interest - City 36103 Assessments - County 31050 CurrentTax Increments 33417 Municipal State Aid 36210 Interest Earnings $ - $ - $ - $ - $ - $ 59,690 381,960 23,023 147,329 55,480 123,784 82,713 708,553 1,500 1,000 2,000 4,500 IIII:II;:::!Im;::::;IItIIII;:IIIIt::::!:::~iil::;:::::::;i::_I::il~'l1.~m1II::i~rllf.~.t::I~::iaal,ItII:~::::I:~:r9II:::::::lr~~Ftijif.fI~ Expenditures 47000 Debt Service Principal Interest Fiscal Agent Fee $ 175,000 $ 80,000 $ 55,000 $ 90,000 $ 281,513 95,938 10,340 30,090 100 100 425 - $ 400,000 65,975 417,880 625 I;:;~~;~:;:::::::;:::l:;:::::::::::;:::::::l::;:::::I:~:I:~:::~:::~:rng!i!:::::::::::I::j.il~II:;:i:~1mgl.;:::i!::.g:::Iir11Iilil::;::i!~:1U~l:i~:;:ii::::i111i1~ o o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET CITY OF ANDOVER, MINNESOTA 12/30/992:41 PMDEBTSER.XLS 2000 ANNUAL BUDGET o FUND ~ CLASSIFICATION GENERAL OBLIGATION BONDS DIVISION DEBT SERVo CODE till. CLASSIFICATIONS 301 Equipment Certificates 309 Fire Bonds 1998A Ref. 315 G.O. EQUIP. TOTAL CERT.1999 DEBT SERVo Revenue 31010 Property Taxes $ 112,830 $ 200,491 $ - $ 313,321 31040 Fiscal Disparities 17,993 42,354 60,347 33401 Local Government Aid 33402 Homestead Credit 26,456 61,721 88,177 36210 Interest Earnings 600 500 1,100 39210 Transfer from Water and Sewer 31 000 31,000 :!:::l~::':l~:l::::::lll'::::l:l!::::l~:::::~l,::~l'::::::I.~l::::::::::::::::::l::::::::::::::i!~:!!:~!!1~.~:::i:~~!~::~l.~.:::::I;!:~:'::::~'!::!::~:::'~::::::!!":':~~.~:: Expenditures 47000 Debt Service 601 Principal $ 175,000 $ 265,000 $ - $ 440,000 0 611 Interest 4,244 18,805 47,775 23,049 620 Fiscal Agent Fee 346 825 1 ,171 ::l:l:l::::l::::::::::::::::l:ll::::::~::l::::::::~tl!::::11:111::::::::':::::::1::1::::1!!::!:~~_:::::1:~:::::::::~~~:::::~1::::!:~~$."~:1~::~:::!1::!~~~ o o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET o ~ o en!- Ww ze" Zc :E;:) ~m ~<i! ~;:) CZ ZZ <c<C en LLen oen ~,.. C3 o z o SQ <CI 2::0 OW ~~ w gg W o L() nsn ~ @lm. RII ,.... ~!1#i ",.. """ o L()N CO ",.. III ::I C ~ III a: tIl OJ C Q) '2 E ~ 0 ro 0 w C -- tIl- ~.e Q) C - Q) .Eo: I"- .... OL()O o CO L() 0.... co ..000 '<I"N .... ::::::;::::; :.;.;.;.:.;.:. ",.. o L() o CO 0.... ..000 '<I"N .... ",.. ::::::::~::::::: J6~~ :::~::: :~~. ~1 ,:1 :.;.:.;.:.:.::: ::;:;:;:::::;:: ";liif. ~, ::::;:::::;:::::; ~:::;;':'::::::: . . :::::::::~:::::: :::::~:: '.'~.'.' :;:::: ~::::::::::::::: .:.:.:.:.:.:.:.:. :.:::;::::::::::: ill .......:.;:::;:;: :::;:::::::.:::.' ::::::::::::~::: :::::;:;::::::::: ~~J~tn~ ~ .......... .:.:.~:::::::::: :::::::::::::::;: ..;.;.;.:;:.;.;.; .. :.:;:::::::::;:;: ON ....L() NN CO CO C') C') ;:;:;:::;:;:.::: ;.;.;.:::.;.;.;. :::::;:;".;.;.; ::;:.; :::~:::::~:::: :11 \1:1: :::::::::::::~: :::::::~::::::: :;:.::;:;::::::: :::::::::::::::: Q) Q) III III lL. ~ - u c: ::I .~ Q) - _ OJ :s ~ ['li5<C c III 15 .- Q) (ij Q. o ~ 0 >< III .5 Q) tIl '- 'E .- W C o.._lL. 0 0 0 ........0 r-. O....N "" co coco ;:::~:~::~:) :::::::::~ :::::::::::::::: :::::::::::::::: :::::::::::::::: t:~~~~mf o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET Capital Projects Funds can be used to account for acquisition or construction of major capital facilities financed mainly with governmental fund resources, general obligation debt, special assessments, special assessment debt, grants, or other resources that are not part of proprietary funds or trust funds. o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET To serve as a long-term funding source for large capital expenditures. o o o CITY OF ANDOVER 12/30/992:43 PMPIR.XLS Revenue/Expenditure Budget Worksheet Budget Year 2000 PERM. IMP. REVOLV. CAPITAL PROJECT Revenues Revenue Actual Actual Actual Budget Request ~ ~ 1m ~ 1lm9. ~ 361 01 Assmt. Prin. - City $ 233,31 3 $ 374,037 $ 1 62,598 $ 1 00,000 $ 45,000 361 02 Assmt. Int. - City 24,474 6,574 1 3,431 9,000 3,500 361 03 Assmt. - County 1 03,1 81 76,230 93,687 1 5,000 3,000 361 04 Assmt. - Countv - Del. 2,876 7,465 6,1 95 - 3621 0 Interest Earned 36,698 74,1 1 6 - 7,656 1 0,000 3,500 3621 2 Valuation Adiustment - - 4,287 36260 Refunds & Reimbursements . 8,447 2,000 - - - 1:;::::1;::1::;:1:rlIII1:::l::::::I~~.I~lIl;1::;lIl:I'~I:':':!:!!!!:!:!:::;!I;i,:;~:I!!!!:!!~':::i.'~I:;'::~:~!@~!!~:I~:'mI~!!i!!!::Ii::::::::;~~!!'~l 39201 Transfers from other funds $ 1 1 6,246 $ 1 ,952,833 $ - $ - $ - 39202 Residual Equity Transfer 29,31 4 393,404 60,991 - - === Expenditures Object Actual Actual Actual Budget Request ~ ~ 1m ~ 1lm9. ~ P"hli... Imnrnvements 21 0 Operating Supplies $ - $ 6 $ 1 ,339 $ - $ - 301 Professional Services 8,31 2 1 ,580 9,505 - - 303 Consulting Engineer 1 2,094 - 784 - - 304 Attorney 1 38 288 92 - - 31 5 Professional Services - Lab. 14 - - - - 330 Transportation - - 44 351 Publishing 395 337 - - - 401 Inspections 4,764 - - - - 406 Contractual Services 21 4,248 1 20,81 8 35,895 41 2 Inspections 4,583 21 3,026 41 9 Improvements- SA Roll - - 1 43,388 530 Improvements - - - 1 34,000 55,000 532 Overlays - 1 1 9,686 - 560 Furniture - - - - 570 Office Equipment 46,027 5,200 - - - 580 Eauipment 2,401 406,632 - - - 727 Transfer to Other Funds 69,435 . 521 ,385 491 ,481 - - 1:::::::::1::1::11:::::1::::1::::~11~1::::::::::::::::::::l:::::::::l:::::::l:::::::::::l~::':!::!~::~::~~i~~~:::,:::~,:::!:,::::~l:~:~~i~~:::l~:!:::::::::::::~~~!.~:;:::!::::!'::~!1~~::::::::~:::::~::~:::~~~:: en, .;.., Tran!;fAr!; 71 0 Residual Equity Transfer $ - $ 1 ,248,657 $ 76,700 $ - $ - 71 1 Transfer to Debt Service 309,370 - - - - 71 3 Res. Eauity Transfer to PIR 365,497 - - - - 727 Transfer to Other Funds 55,1 66 500,000 50,000 - - ::::::;:::lI:lril::l::::::::;[!MIII!I~;:l:::::l::::l:;:l:i;I::::::::::::!::::~':::'~::~~\~~~:::::!~~:::~~::i.~!~~~!~~l:::::!:i.:r:i.~~::i.:~~~!~::lli.~:::~:i.::~:~i.:::~:i.!:!::~!f:::::::!:!~::!~::i!:~~~i.'!:~':i.:~:: " $Ii - " .. .. o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET o Governments establish enterprise funds to account for activities that consist of rendering services or providing goods to the public for which a fee or charge is collected. o o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET . The water department is to maintain all aspects of the water system, from line and hydrant maintenance, to the installation of water meters. We also do chemical feeding and testing to ensure the safety of all our customers. o City of Andover 12/30/992:55 PMWATSUM.xLS Water Enterprise Fund Revenue and Expenditure Summary Budget Year 2000 . Actual Actual Actual Budget Request .1996 .199Z. 1998. 1.999. .2000 REVENUES User Charges $ 657,448 $ 641 ,203 $ 825,687 $ 925,400 $ 997,880 Meters 38,803 37,1 80 65, 1 22 30,000 35,000 Permit Fees 1 2,686 1 2,082 1 8,975 1 2,000 7,500 Penalties 8,789 1 1 ,1 1 2 1 4,226 7,000 7,000 Other 41 ,477 63,353 86,790 1 2,000 1 3,000 ::III!~:::!!EM!!!::::::::::::::::::I:::I::::::::I::::~:~!!i~!!:::::I~~:::::::::::~~~~i~~~::l::I:::::::~~i~~:~!~~::::I~:::::::~:~:::~!~!!:::l:::~::::,:::':::::~~!~!~~:: EXPENSES Source Storage $ 1 20,069 $ 1 1 3, 1 1 9 $ 345,21 7 $ 41 6,950 $ 425,880 Distribution 247, 1 1 0 332,045 346,446 349,51 5 390,668 Administration 1 34,484 1 39,804 1 74,257 21 9,935 243,832 c; .1.~~51~!m~I!!:::::::::::::::::;::~::::::::~~~~~~:::1::~:::::::::::~!:~~~~!::::~::!:::!::~~~~~~::ll:~~::~~:~:::~:~~!~~::l:~::::::::::::~:~~i.~~ o o W> ~~; ~ Z'C o~a ~~~ ~<u Wt:~~ r~. f;o;l a - ~ ~ o ~ ~ ;...f;o;l~ ~~~ ~<"C u~~ ~ o o o o CITY OF ANDOVER Revenue Budget Worksheet Budget Year 2000 12/30/992:55 PMWATER.XLS WATER Revenue Actual Actual Actual Budget Request ~ ~ . ~ ~ 1.999. ~ 341 32 Water Dept. Fees $ 5,258 $ 4,829 $ 379 3,500 500 3621 0 Interest Earned 38,521 63,059 74,363 1 2,000 1 3,000 3621 1 Market Loss on Invest. 2,61 0 - - - - 36230 Valuation Adjustment - - 7,856 - 36245 Sale of Used Equipment 21 6 - - - - 36260 Refunds & Reimburse. 1 31 293 4,349 - - :1::::::::::1::111111:1::::1~1::1:::1:::1:1::11l!~!1!~:::!1:::::1!:1:::::::::~:::::111:~~i~~~:.I::~i,::::::i,::::!!~!:1:~~:1::1~:::::':~~:~:1:~~~~~::::::::1~:~~~:~11~~~::::!:::'~~i,i,:::~i,~:i,~!:l?~!:1: 371 1 0 Water Sales-General $ 652,1 90 $ 636,289 $ 825,025 921 ,900 997,380 37140 Water Dis/Reconnect - 60 283 - - 371 50 Water Permit Fees 1 2,686 1 2,082 1 8,975 1 2,000 7,500 371 52 Other Fees - Water - - 220 - - 371 60 Penalties - Water 8,789 1 1 ,1 1 2 1 4,226 7,000 7,000 371 70 Hydrant/Meter Rentals - 25 - - - 371 71 Meters 38,803 37,1 80 65,1 22 30,000 35,000 39200 Unallocated- Connexus En - - 3 - - ~ ...~~ ~. to:', ~. .':, .. I: ~ , :..m '". ...~: ..' r.-::..... ..... ~..' ~ ,;: . CITY OF ANDOVER WATER DEPARTMENT Expenses By Area o 2000 Source, Storage & Treatment 40% Administration 23% Distribution 37% o 1999 Administration 22% Source, Storage & Treatment 43% Distribution 35% o o o o CITY OF ANDOVER 12/30/992:56 PMSUMMARY.XLS Expenditure Budget Summary - Water Budget Year 2000 Actual Actual Actual Budget Budget ~ :m9Z 1998. ~ ~ Water Source, Storage, & Treatment Supplies and Materials $ 21 ,771 $ 28,007 $ 43,477 $ 51 ,800 $ 54,1 35 Purchased Services 43,863 50,81 8 57,544 65,1 50 71 ,745 Other Services and Charges 4,435 34,293 2,1 94 50,000 50,000 Capital Outlav 25,000 - 242,000 250,000 250,000 Transfers 25,000 - - - - :!:I:::;'I::::::~::I:::::~.;::I.t~~:lg.i~l~~:::~~:::::::I:~;"~:~;'::::::~.I!:::::lio:~::':::'::~:::~~I"~~I:::::!:'~:~~~~~~!~~~l::::~:::j::l:::::!~!l~!:I:::~I:~':':~!~!!!!!::: Distribution Personal Services $ 1 1 9,591 $ 1 62,027 $ 1 87,495 $ 1 76,302 $ 1 97,238 Supolies and Materials 1 3,1 56 1 6,1 29 1 1 ,889 22,000 26,000 Purchased Services 4,650 6,297 7,227 1 0,580 1 1 ,693 Other Services and Charges 1 1 3,785 1 37,592 1 39,835 39,333 62,437 Capital Outlay (4,073) 1 0,000 - 1 01 ,300 93,300 :::I:::III;::I::::::::::!;::I:I.:::I~I~,'~~!g~:::~::!::::;::::::::::I~~:~:~io:::io::~!:!~!:!~::~:~I::::::~:::l.1!:::::::I:i::::!::e!.:::;~l:::::::::~!!~!!!;:I:io:::::!!II~!:1 Administration . Personal Services $ 44,724 $ 49,288 $ 53,880 $ 35,01 1 $ 38,489 Suoolies and Materials 1 ,378 543 1 ,032 2,200 2,700 Purchased Services 22,21 5 23,393 23,775 43,624 54,582 Other Services and Charges 1 1 ,1 26 1 0,581 1 6,570 46,600 49,1 00 Caoital Outlav - - - 1 ,500 - Transfers 55,040 56,000 79,000 91 ,000 98,961 . ...... .... . '. .' ~. . CITY OF ANDOVER Water Department Source, Storage and Treatment o 2000 Transfers 0% Supplies and Materials 13% Capital Outlay 58% Other Services and Charges 12% o 1999;upplies and Materials 12% ~:;. !. :. :.!:.t....:. i::i::;:>~ 4~~":'" Capital Outlay 60% -- - - - - - - ~ - - Other Services and Charges 12% o CITY OF ANDOVER 12/30/992:48 PMWWWATER.XLS ~ GROSS HEALTH DENTAL LIFE WAGE PERA ~ MEDICARE INSURANCE INSUR~ INSURANCE TOTAL . POSITION DESCRIPTION SUPERINTENDENT 8,666 388 537 126 693 38 17 1 0,464 RAYS. 2,043 92 127 30 109 13 6 2,417 BRIAN K. 23,790 1,066 1,475 345 1,042 121 53 27,892 KEVIN S. 2,495 112 155 36 231 13 6 3,046 SCOTT P. 17,128 767 1,062 248 2,079 113 50 21 ,448 DENNIS M. 1,790 80 111 26 231 13 6 2,256 TERRY S. 1,790 80 111 26 231 13 6 2,256 CHRIS O. 1,903 85 118 28 109 13 6 2,261 OJ. 1,884 84 117 27 231 13 6 2,362 JEREMY J. 1,507 68 93 22 185 10 4 1,890 IRWIN R.. 1,884 84 117 27 109 13 6 2,240 GERALD K. 5,653 253 350 82 693 38 17 7,086 JEFF O. 1,922 86 119 28 231 13 6 2,404 ANDY K. 1,790 80 111 26 231 13 6 2,256 TOM R. 16,469 738 1,021 239 2,125 116 51 20,758 JIM S. 12,173 545 755 177 . 1,571 86 37 15,343 MERYL P. 1,696 76 105 25 231 13 6 2,151 RONS. 5,088 228 315 74 693 38 17 6,452 RANDY WESP 23,789 1,066 1,475 345 3,465 189 83 30,411 OVERTIME 3,201 143 198 46 - - - 3,589 !YCLlNG COORD. 646 29 40 9 92 5 2 824 GENERAL CLERK 2,949 132 183 43 272 32 14 3,623 CITY OF ANDOVER 12/30/992:48 PMWWWATER.XLS QA ENTRY CLERK 3,851 173 239 56 578 32 14 4,940 SECRETARY 5,935 266 368 86 1,040 57 28 7,779 SUMMER HELP 6,400 397 93 - - - 6,890 TOTAL 156,441 6,722 9,699 2,268 16,469 999 439 193,038 ADMINISTRATION GROSS HEALTH DENTAL LIFE WAGE PERA .E.!.CA MEDICAR~ INSURANCE IN URANC~ INSURANCE TOTAL POSITION DESCRIPTION ADMINISTRATOR 8,206 425 509 119 462 25 11 9,757 FINANCE DIRECTOR 6,390 331 396 93 462 25 11 7,708 IO.f.SURER 4,068 211 252 59 347 19 8 4,964 ACCOUNTING CLERK 2,310 120 143 34 347 19 8 2,980 ACCOUNTING CLERK 5,450 282 338 79 693 38 17 6,896 . BLDG. SECRETARY 1,557 81 97 23 109 13 6 1,883 BLDG. SECRETARY 1 ,497 78 93 22 109 13 6 1,816 DATA ENTRY CLERK 1,925 100 119 28 289 16 7 2,484 TOTAL 31 ,404 1,627 1,947 455 2,816 167 73 38,489 . GRAND TOTAL 187,845 8,349 11,646 2,724 19,285 1,166 512 231,527 o CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/992:49 PMWATER.XLS o 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES I. Personal Services Suoerintendent 0.150 $ 8,255 0.150 $ 8,666 Suoervisor 0.580 27,668 0.580 28,327 Maintenance Workers 2.740 . 89,873 2.740 99,667 Public Works Secretary 0.250 6,632 0.250 5,935 Recvclina Coordinator 0.020 589 0.020 646 C eneral Clerk 0.125 2,820 0.125 2,949 ata Entrv clerk 0.165 3,930 0.188 5,776 Administrator 0.100 7,598 0.100 8,206 . Finance Director 0.100 6,606 0.100 6,390 Treasurer 0.075 3,917 0.Q75 4,068 Accountina Clerks 0.225 7,845 0.225 7,760 Buildina Secretaries 0.100 2,647 0.100 3,054 Summer HelD 0.000 - 1.000 6,400 Total 4.630 168,380.28 5.653 $ 187,845 o CITY OF ANDOVER Expense Budget Worksheet Budget Year 2000 12/30/992:53 PMWWATERXLS WATER-SOURCE STORAGE DEPARTMENT # 49400 ENTERPRISE FUND o Obiect ~ Actual ~ Actual 199Z Actual ~ Budget 1999. Request 2000 SUDDlies and Materials 201 General Office Supplies $ - $ - $ 307 $ 500 $ 550 210 Operating Suoolies 821 274 855 2,500 2,500 216 Chemicals 19,503 24,593 38,026 45,000 47,000 220 Repair/Maint. Supplies- Gen. - 117 92 85 ~:::"'::l:"':I::"'::I:l"l Purchased Services 301 Professional Services $ 1 ,015 $ 1 ,607 $ 2,495 $ 3,000 $ 3,000 315 Professional Service - Lab 1 ,220 896 1,047 2,000 2,000 321 Telephone - - - 500 500 351 Publishing 64 - 150 5,500 6,000 360 Insurance 2,600 2,800 3,000 3,150 3,245 381 Electric 35,399 41,361 46,833 45,000 50,000 383 Natural Gas 1,951 1,732 1,500 3,000 3,000 o ~"::\:":l::":::!:":I:::":1 Other Services and Charges 401 Repair/Maint. - General $ 1,867 $ 3,095 $ 1,743 $ 7,500 $ 7,500 402 Repair/Maint. - Building 83 1,500 60 6,000 6,000 403 Repair/Maint. - Well/Pump. 694 27,784 - 30,000 30,000 404 Repair/Maint. - Improvements - 578 152 2,500 2,500 406 Contractual Services - 415 - 1,000 1,000 412 Inspections 1,532 - - 2,000 2,000 ~i;:::~::::::::::::;1::/.1_::~;;_;:j::_::~:"lj(::__1 Capital Outlay 582 Capital Maintenance Res. $ 25,000 - 242,000 250,000 250,000 !':::'j:::::l:::::::::::l:::::~::::Il~l'~i~:'::I::!::::!::::::!::l:::~::~::l::::::::::::::~lj:::j:::::::~,:::~:!::!~~i~~~;l::!~:::,:::::~:::::::::!,!t::::::i':~~:::!:~~~i.~~q:::~::~:!!l~~~q~:::::~:::!:::~~~l~q~! Transfers o o CITY OF ANDOVER WATER DEPARTMENT DISTRIBUTION 2000 Supplies and Materials 7% Purchased Services 3% Other Services and Charges 16% o 1999 Purchased Services 3% Supplies and Materials 6% Other Services and Charges 11% Personal Services 51% o CITY OF ANDOVER Expense Budget Worksheet Budget Year 2000 12/30/992:49 PMWWATER.XLS NTER-DISTRIBUTION DEPARTMENT # 49430 ENTERPRISE FUND ~ Object Actual Actual Actual Budget Request ~ 1992 ~ ~ ~ 2QQO. Personal Services 101 Salaries $ 95,968 $ 133,266 $ 150,898 $ 138,162 $ 156,441 121 PERA 4,252 5,634 7,671 6,190 6,722 122 FICA 5,650 7,548 9,061 8,566 9,699 125 Medicare 1,321 1,765 2,119 2,003 2,268 131 Health Insurance 8,271 10,276 13,665 16,120 16,469 132 Dental Insurance 636 755 852 924 999 133 Life Insurance 43 51 63 337 439 151 Workers Compensation 3,450 2,732 3,166 4,000 4,200 1::~::::.!::~\il:::::~::~:!!::!:::i:::!.I~!::I:~:II!::::::::l::l::!:::::::::::::::~:l::~:::i:_l:!:~::_::!::~_11::_:~:~!_: "' .. :'~:':'.'.' .... ......... .... ....n....... .......... :':':'Z':':~':'. .... ...:.:.:.... ...... .... .. ............. . :.:.:.:.:. ....... .....:: I ~lInnliA~ And MatAriAI~ 201 General Office Suoplies $ 15 $ - $ 60 $ 500 $ 500 210 Ooerating Suoplies 5,467 4,278 4,130 5,500 6,500 214 Meter Repair Supplies 1 ,402 1,036 3,510 3,500 4,000 219 Hydrant Reoair Suoolies 2,211 4,249 693 3,500 5,000 220 Repair/Maint. - General 1,916 2,067 1,649 3,000 3,500 224 Repair/Maint. - Streets - - - 3,000 3,000 ~~~~:;"::II'''::!::''::!:'''::~:''::1 ......:.... . ... .... .... ................. " ........ ....................... .... ............................. .............. ............... Purchased Services 301 Professional Services $ 46 $ - $ 270 $ 100 $ 300 303 Consulting Engineer - - - 500 500 314 Gopher One-State Call 724 771 1,267 1 ,400 1,500 321 Telephone 338 692 1,750 800 1,000 322 Postage 25 586 41 2,000 2,500 351 Publishino 416 898 299 2,000 2,000 360 Insurance 3.100 3350 3600 3.780 3 893 Other Services and Charaes 401 Repair/Maint. - General $ 1,375 $ 748 $ 599 $ 1,000 $ 1,000 403 Repair/Maint. - Streets - - 1,300 1,000 1,000 407 Meters - Labor 540 - - 700 700 408 Hvdrants - Labor - - - 500 500 410 Rentals 66 7,655 - 10,000 10,000 415 Eauipment Services 15,100 22,773 22,539 24,933 48,037 420 Depreciation 95,492 105,212 114,867 - - 433 Dues/ReQistrations 1,113 1,204 333 1,000 1,000 442 Meals/Lod ng 100 - HIR 200 200 ...,............................... .................... .. .. ... ....... CITY OF ANDOVER Expense Budget Worksheet Budget Year 2000 12/30/992:49 PMWWATERXLS . ect Actual Actual Actual ~ ~ ~ ~ WATER - DISTRIBUTION (continued) Capital Outlay 580 E uipment $ $ $ $ 40,000 $ 32,000 581 Meters/Horns 61,300 61,300 727 Transfer to Other Funds 10,000 o o o o o CITY OF ANDOVER Water Department Administration 2000 Transfers 41% Personal Services 16% Supplies and Materials 1% Purchased Services 22% Capital Outlay 0% Other Services and Charges 20% 1999 Transfers 41% Capital Outlay 1% Other Services an Charges 21% Purchased Services 20% Supplies and Materials 1% o o o CITY OF ANDOVER Expense Budget Worksheet Budget Year 2000 12/30/992:49 PMWWATER.XLS WATER-ADMINISTRATION DEPARTMENT # 49440 ENTERPRISE FUND Object Actual Actual Actual Budaet Reauest ~ ~ .1m 1.998. ~ ~ Personal Services 1 01 Salaries $ 38,205 $ 41 ,961 $ 44,883 $ 28,61 4 $ 31 ,404 1 21 PERA 1 ,526 1 ,733 2,304 1 ,282 1 ,627 1 22 FICA 2,1 46 2,450 2,680 1 ,774 1 ,947 1 25 Medicare 502 575 636 41 5 455 1 31 Health Insurance 2,1 74 2,374 3,1 25 2,71 5 2,81 6 1 32 Dental Insurance 1 57 1 80 234 1 51 1 67 1 33 Life Insurance 14 1 5 1 8 60 73 !::!::!::::!:::!l~!!Il!!!!I~III;:::!~:::!'!:::::::I:::~~::::!::::::!:::i::::::::l.~~::::::!!)~!~!:::!11::!::::!::!!!!!:::::~::::!!::!::~~I!~!::::::I::::!::!:!:!~!~:!::l:::!~!:~!:'::!~~l~~!:::~ lies and Materials 201 General Office Supplies $ 574 $ 331 $ 852 $ 700 $ 1 ,000 21 0 Operating Supplies 385 21 2 1 75 1 ,000 1 ,200 220 Repair/Maint. - General 41 9 - 5 500 500 ::ll::!ll::::::l:!'::l~:ll:lil.:l:::l:l::!:::::!::::::!:::::::::::::::::::::::::::l:~!:::::::::::::~:~~~::::::'~:::::!!!!::!l::~!::::!!~:::::::::!1:::~~!!~~::::::~1::::::::::::!~~~:!::1~::::::~::~::~:::~;~~: Purchased Services 301 Professional Services $ 2,506 $ 1 ,958 $ 1 ,590 $ 1 6,000 $ 1 6,000 303 Consulting Engineer - - - 200 200 322 Postaae 2,029 1 ,961 491 2,000 2,500 330 Transportation 234 298 407 200 200 351 Publishing 67 46 1 58 1 ,000 4,000 352 Printing - 51 - 1 00 500 353 Publications - - 200 500 5,500 360 Insurance 1 ,300 1 ,400 1 ,802 1 ,924 1 ,982 386 Water Quality Fee 1 6,079 1 7,680 1 9,1 27 21 ,000 23,000 390 Taxes - - - 700 700 vices and Charaes 401 Repair/Maint. - General $ 532 $ 360 $ 1 14 $ 700 $ 700 406 Contractual Services 1 0,361 7,533 1 4,067 1 7,000 1 7,000 41 0 Rentals - 458 - 500 500 41 6 Computer Services - 1 ,743 1 ,800 3,500 6,000 433 Dues/Registrations 233 487 553 600 600 442 Meals/Lodging - - 37 300 300 499 Contingency - - - 24,000 24,000 WATER ADMINISTRATION (continued) o o o CITY OF ANDOVER Expense Budget Worksheet Budget Year 2000 12/30/992:49 PMWWATERXLS Ob"ect ~ Actual ~ Actual 1iQZ Actual ~ Budget .1ilm Re uest .2QQQ CaDital Outlay 560 Furniture $ $ - $ _ $ _ $ 570 Office Equipment 1 ,500 :::::ll:::::l::l::::::::':::::::::il::::ll::~l::l:::ll:l.I~li!I::I:i:::::::l:::::::::l:~:::::::!!::::!:::~:::!:!:::l!!!!;:::!:!!:~::::!::~::l::l!!!:::!:::::!::!::::!:::~:::::::~:::::':':::!:!:~:~!:!:::::i.~::!:~::~!!!::::::~!::::::~:l Transfers Transfer to Computer Reserv $ Transfer to Admin. Trust Fund Transfer to Other Funds $ 25,000 $ 10,000 $ 10,000 $ 20,000 o 0: . 4:) CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET To provide a smooth and unobstructed flow through-out the city sewer. system. o City of Andover 12/30/993:45 PMSEWSUM.XLS Sewer Enterprise Revenue and Expenditure Summary Budget Year 2000 Actual Actual Actual Budget Request . ~ 199Z 1998. 1.9i9. ~ REVENUES User Charges $ 801 ,808 $ 850,704 $ 91 2,562 $ 930,000 $ 1 ,093,238 Penalties 1 0,61 9 1 3,202 1 5,468 9,000 1 2,000 Other 28,372 24,774 57,1 78 1 6,500 1 2,200 . Transfers . 30,500 - 30,500 30,000 - :*III~:::IIIIM!I:.;!:::l:::l:l::::::::::::::::::::::::l::::::::~!!:::::!:~~~~~::::::~!~:~:!'~~~::l::~:::!!~~:~~?~::~:~::~::::~:!~~~!:~:::~::!~:!~~~Et~:: EXPENSES Collection $ 654,256 $ 662,270 $ 709,41 6 $ 925,471 $ 1 ,026,086 Administration 72,699 65,699 1 24,1 1 3 60,029 91 ,353 I 1~!:!.~III[llllll!:::::::::::::i:::!:l!,:l~!:::::!!!i!!!::~:::::::!!!!!!~!!!::!:~::!:!::::!!~!!:::~::::!::~!!!~!!:::l!~::~:~j~:~:~~~:: to o $1,200,000.00 $1,000,000.00 $800,000.00 o $600,000.00 $400,000.00 $200,000.00 o CITY OF ANDOVER SEWER DEPARTMENT Yearly Summary of Revenues. $- 1995 1997 1996 1998 1999 2000 CITY OF ANDOVER Revenue Budget Worksheet Budget Year 2000 12/30/993:46 PMSEWER.XLS 0 SEWER Revenue Actual Actual Actual Budget Request ~ ~ 1.99Z ~ 1Jlml ~ 34133 Sewer De t. Fees $ 2,124 1 ,491 699 1,000 1,000 36103 Assmts. call. by cnty cur. (8,874) 36110 Certified Bills 36,074 9,666 23,195 9,500 4,200 36210 Interest Earned 26,912 24,614 51 ,736 6,000 7,000 36211 Market Loss on Invest. 1 ,460 36212 Valuation Ad'ustment 36260 Refunds & Reimburse. 37210 Sewer Charges - Gen. $ 682,876 $ 785,802 $ 873,070 895,000 1,083,238 37240 Sewer Charges - Other 80,734 53,745 24,471 35,000 10,000 37260 Penalties - Sewer 10,619 13,202 15,468 9,000 12,000 1:;:::lIIIIII:;::::I;III1I~~~tI!IIIIII;::Im.:m:!!lI'i;~i~:n$.::II~M~$~'::I$!:::!':li~Q1~II1I::!:11\.II!:;r~g;~!I 39204 Trans. Sewer Conn. $ 30,500 $ $ 30,500 30,000 o o o Q CITY OF ANDOVER SEWER DEPARTMENT Expenses By Area 2000 COLLECTION 92% ADMINISTRATION 8% 1999 COLLECTION 94% ADMINISTRATION 6% CITY OF ANDOVER 12/30/993:46 PMSUMMARVXLS Expenditure Budget Summary - Sewer Budget Year 2000 o Actual 1996. Actual .1.!m. Actual 1995. Budget 1.999. Budget 2llQQ Administration Personal Services $ 45,871 $ 49,103 $ 63,919 $ 35,211 $ 43,368 Sup lies and Materials 971 794 1,569 2,150 2,885 Purchased Services 3,466 3,889 3,111 8,968 10,650 Other Services and Charges 14,801 10,530 13,514 12,200 16,450 Ca ital Outlay 1,383 1,500 1,000 Transfer 7,590 42,000 17,000 :::::::::::i!lli!:i::::!::~:I!~i!l.ii!i~r.gi:::::::~!:;:,!:~!:'::;:::~:::!.~:!::;:~~!~!:!!~:!:.~:::::::~!:::!:,!::~~!~~~~~1::;:;~~:::::::!!!~:::~:~~~!:::::'~~'::::,!t!:::::!~~~~:: o Collection Personal Services $ Su lies and Materials Purchased Services Other Services and Charges Capital Outlay Transfers 74,279 $ 4,910 487,891 42,102 $ 64,675 $ 123,246 $ 7,768 12,500 550,954 600,455 52,301 39,270 150,000 o CITY OF ANDOVER 12/30/993:32 PMSSEWER.XLS 2000 BUDGET WAGE WORKSHEET ~ COLLECTION GROSS HEALTH DENTAL LIFE WAGE fEBA ~ MEDICARE INSURANCE INSUR~ INSURANCE TOTAL POSITION DESCRIPTION SUPERINTENDENT 5,777 282 358 84 462 25 11 6,999 RAYS. 2,043 100 127 30 109 13 6 2,425 BRIAN K. 7,434 363 461 108 326 38 17 8,746 KEVIN S. 2,495 122 155 36 231 13 6 3,056 SCOTT P. 7,613 371 472 110 924 50 22 9,563 DENNIS M. 1,790 87 111 26 231 13 6 . 2,263 TERRY S. 1,790 87 111 26 231 13 6 2,263 CHRIS O. 1,903 93 118 28 109 13 6 2,268 TOMJ. 1,884 92 117 27 231 13 6 2,370 IRWIN R. 1,884 92 117 27 109 13 6 2,247 IrfALD K. 15,074 736 935 219 1,848 101 44 18,956 FO. 1,922 94 119 28 231 13 6 2,412 ANDY K. 1,790 87 111 26 231 13 6 2,263 TOMR. 10,741 524 666 156 1,386 76 33 13,581 JEREMY J. 1,131 55 70 16 139 8 3 1 ,422 RECYCLING COORD. 646 32 40 9 92 5 2 827 MERYL P. 1,696 83 105 25 231 13 6 2,157 RON SCOTT 1,696 83 105 25 231 13 6 2,157 JIM SANNERUD 12,173 594 755 177 1,571 86 37 15,392 GENERAL CLERK 2,949 144 183 43 272 32 14 3,635 DATA ENTRY CLERK 3,851 188 239 56 578 32 14 4,956 RANDY WESP 7,930 387 492 115 1,155 63 28 10,169 OVERTIME 3,201 156 198 46 - - - 3,602 SECRETARY 5,935 290 368 86 1,040 57 28 7,802 SUMMER HELP 6,400 - 397 93 - - - 6,890 D TOTAL 111,746 5,141 6,928 1,620 11,965 709 312 138,422 CITY OF ANDOVER 12/30/993:32 PMSSEWER.XLS 2000 BUDGET WAGE WORKSHEET 0 . ADMINISTRATION GROSS HEALTH DENTAL LIFE WAGE PERA FICA MEDICARE INSURANCE IN~IIR4Nr.E IN~IIRANr.E TOTAL POSITION DESCRIPTION ADMINISTRATOR 12,309 638 763 178 693 38 17 14,636 FINANCE DIRECTOR 6,390 331 396 93 462 25 11 7,708 TREASURER 4,068 211 252 59 347 19 8 4,964 ACCOUNTING CLERK 2,310 120 143 34 347 19 8 2,980 ACCOUNTING CLERK 5,450 282 338 79 693 38 17 6,896 BLDG. SECRETARY 1,557 81 97 23 109 13 6 1,883 BLDG. SECRETARY 1 ,497 78 93 22 109 13 6 1,816 DATA ENTRY CLERK 1,925 100 119 28 289 16 7 2,484 ~OTAL 35,507 1,839 2,201 515 3,047 180 78 43,368 GRAND TOTAL 147,253 6,980 9,130 2,135 15,011 889 391 181,789 o CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/993:33 PMSEWER.XLS o 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Suoerintendent 0.100 $ 5,504 0.100 $ 5,777 Suoervisor 0.250 11,973 0.250 11,972 Maintenance Workers 1.970 66,481 1.970 74,217 Public Works Secretary 0.250 6,632 0.250 5,935 Recvclina Coordinator 0.020 589 0.020 646 C Data Entrv/Acct Clerk 0.165 2,820 0.188 5,776 ~W Clerk 0.125 2,325 0.125 2,949 Administrator 0.100 7,598 0.150 12,309 Finance Director 0.100 6,606 0.100 6,390 Treasurer 0.075 3,917 0.075 4,068 Accountina Clerks 0.225 7,845 0.225 7,760 Buildina Secretaries 0.100 2,647 0.100 3,054 Summer HelD 0.000 - 1.000 6,400 Total 3.480 $ 124,937 4.553 $ 147,253 o CITY OF ANDOVER SEWER DEPARTMENT Collection Expenses 2000 Purchased Services 73% Supplies and Materials 1% er Services and Charges 6% Personal Services 16% Capital Outlay 4% 1999 Purchased Services 66% Other Services and Charges 4% Supplies and Materials 1% Personal Services 13% Capital Outlay 16% CITY OF ANDOVER Expense Budget Worksheet Budget Year 2000 12/30/993:38 PMWSEWER.XLS QvER - COLLECTION DEPARTMENT # 49450 ENTERPRISE FUND Object Actual Actual Actual Budget Request ~ ~ 1m ~ ~ .2QOO Personal Services 101 Salaries $ 57,766 $ 63,320 $ 50,525 $ 96,323 $ 1 1 1 ,746 121 PERA 2,477 2,671 2,661 4,990 5,141 122 FICA 3,157 3,436 3,238 5,972 6,928 125 Medicare 738 804 757 1,397 1 ,620 131 Health Insurance 6,178 5,849 4,349 10,467 1 1 ,965 132 Dental Insurance 481 436 222 590 709 133 Life Insurance . 32 30 27 207 312 151 Workers Compensation 3,450 2,775 2,895 3,300 3,450 :::l::::::::::::::::::::l::::.!lili~l.::::l.::::::::::::::::::l:::::::::~!:~:!~!:l~~~:~::::::::~~t~~::l:::~~:::::~:::~;~~~:::~~::~:~~!~!~:~::~~:~~~!!:::~~~~~~!:~: Supplies and Materials 210 Operating Supplies $ 2,802 $ 2,884 $ 3,288 $ 3,500 $ 3,500 220 Repair/Maint. - General 1 ,472 369 1 ,748 5,500 5,500 224 Repair/Maint. - Streets 294 - 2,231 2,500 2,500 Purchased Services 303 Consulting Engineer $ - $ - $ - $ 8,500 $ 8,500 314 Gopher One-State Call 760 771 1 ,267 1 ,400 1 ,500 316 Contractual Sewer Systen 1 ,595 - 4,233 15,000 15,000 321 Telephone - - - 300 500 360 Insurance 1 ,960 2,100 2,100 2,205 2,271 381 Electric 444 468 470 550 550 385 Metro Waste Control Corr 483 132 518 571 542 883 572.500 608 500 ::::::::I::::::;l:::::l:!::l::!IJI~,I~~:::::jl:!lj:::!::~:::::::::::l:::I:::I$rrlljijt!B.Q~:::::::$)rrIr$~i:;aidII$rII~ld;l~i:i:I::::~d~~:;i::$::rI~lmi:: ....................................... ..... .. . ....... ... .. .... .................................................................................................. o CITY OF ANDOVER Expense Budget Worksheet Budget Year 2000 12/30/993:38 PMWSEWER.XLS 1'\ I "lI(IR5ject Actual Actual Actual Budaet Reauest ~ .1996. ~ ~ .:!B .2QOQ Other Services and Charaes 401 Repair/Maint. - General $ 41 8 $ 634 $ 527 $ 6, 1 00 $ 6,1 00 403 Repair/Maint. - Streets - - - 2,500 2,500 404 Repair/Maint. - Impr - - - 2,000 2,000 41 0 Rentals 6,000 - - 1 ,500 I. 1 ,500 41 5 Equipment Services 1 6,000 24, 1 30 23,882 26,420 27,997 41 8 Maintenance Contracts - - - 1 0,000 420 Depreciation 1 9, 1 67 22,877 27,742 - - 433 Dues/Registrations 51 8 780 1 50 750 798 :::::::I:lll:::::::::l:::::l:::.R'B~I~:::::::::::::li::::::::::::::::::I::I~::::~~!~~~~!~:::::~l:i:::::~~!~~~::1::~~::':::::!~!~~~::::~1::::::~~!~~::::~:1!:::!:~~~~~: SEWER - COLLECTION (continued) Capital Outlay 570 Office EQuipment $ - $ (1 ,383) $ - $ - 580 EQuipment - - - 1 50,000 32,000 582 Capital Maintenance Res - - - - - - ~2 Transfers Transfer to Cap. Ea. Res. $ 1 0,000 $ 1 0,000 $ 33,71 8 $ - $ 1 51 ,998 71 0 Residual Equity Transfer 35,074 - . - - - . . '.' . . . . '. . .' ... .. . . . . . . . . ." . . . . ...... ...... . .. . ....... . o CITY OF ANDOVER SEWER DEPARTMENT Administration Expenses 2000 Personal Services 59% Other Services and Charges 22% Capital Outlay 1% Purchased Services 14% Supplies and Materials 4% 1999 Capital Outlay 2% Personal Services 59% Other Services an Charges 20% Purchased Services 15% Supplies and Materials 4% CITY OF ANDOVER Expense Budget Worksheet Budget Year 2000 12/30/993:33 PMWSEWER.XLS "'ER - ADMINISTRATION DEPARTMENT # 49490 ENTERPRISE FUND Object Actual Actual Actual Budget Request ~ ~ 199Z 1m ~ ~ Personal Services 1 01 Salaries $ 39,361 $ 41 ,780 $ 52,934 $ 28,61 4 $ 35,507 1 21 PERA 1 ,524 1 ,732 2,788 1 ,482 1 ,839 1 22 FICA 2,1 43 2,449 3,246 1 ,774 2,201 1 25 Medicare 501 574 769 41 5 51 5 1 31 Health Insurance 2,1 71 2,373 3,882 2,71 5 3,047 1 32 Dental Insurance 1 57 1 80 280 1 51 1 80 1 33 Life Insurance 14 1 5 21 60 78 1:::::::::!:I::::::::::::\!lI~~~i~::::!I::!:::::!::::::::!:I:::::::::::::::!:I:::::!:!i.!~!!::I!::~::::~~:!:!i!~!:::::~:::::::!!i~~!!:::I:::::~::::::::!~!:!:::I~I::~:::::!:!~!!~::: Supplies and Materials 201 General Office Supplies $ 971 $ 635 $ 1 ,569 $ 1 ,800 $ 2,000 21 0 Operating Supplies - 1 58 - 200 700 220 Repair/Maint. - General - - - 1 50 1 85 l:!::'I::!!::I:!:I!::I::::l.!i~II~:!I:!:I!::::!:::i:i::::::i:::::::::::::::::!~I::::::!:::::~~!!,:!::l:~::::::::!:::::~~!l:!!!:!!:::::!~!!:::::::~:~::!!::~i~:!:!:::::I:::'!!~::::::~!~!!j~: Purchased Services 05-1 Professional Services $ 2,206 $ 1 ,920 $ 1 ,61 2 $ 4,388 $ 6,000 303 Consulting Engineer 1 05 - - 250 250 322 Postage 327 890 491 2,500 2,500 330 Transportation 228 279 265 600 600 351 Publishing - 1 49 1 43 400 400 352 Printing - 51 - 200 200 360 Insurance 600 600 600 630 700 Other Services and Charges 401 Repair/Maint. - General $ 1 50 $ 52 $ 54 $ 300 $ 300 406 Contractual Services 1 4,636 8,71 3 1 3,397 8,000 8,000 41 6 Computer Services - 1 ,743 - 2,000 6,000 433 Dues/Registrations 1 6 23 63 300 400 442 Meals/Lodging - - - 1 00 250 SEWER - ADMINISTRATION (continued) o CITY OF ANDOVER Expense Budget Worksheet Budget Year 2000 12/30/993:33 PMWSEWER.XLS Actual ~ Actual ~ Actual .ms. Budget ~ Request .2QQ2 CaDital Outlay 560 Furniture $ $ - $ - $ 500 $ 570 Office Equipment 1,383 1,000 1,000 !!!::.!:::!::!~::::::::!::::'::::!!':::i::!!:::::::,:::::::illtil!~:::!:!::::!::!::::::::,:::::::~::l:!~:::!::!:::!:~,::::::::::l::~::!!!:::!::~:~!!:::::,!!:::!~:!::::::'~:::!!!~:::::::!~~!~~::~::::~!:::~~!!:::!::I~:::!!~::::~::~::~~;~!::l 712 Transfer - Cert of Indebt $ 7,590 $ c $ - $ - $ 7,000 727 Transfer to Other Funds 42,000 10,000 !1:::!::I:::!:::~::::::I::!I::!:.I!p.;~!~::!::I:::ll::!!:::!::::l!:::::::::::::::::::::~::::::::::::~!~~:::l::~~!:i:::::::i::i:j::!i:l::t:!::::~~:!~:~~~~!:l::~:!::~!::::::~::!~:~:::::::::~:!:l~::::!:~!@l.~~~l :::I::::!:::~~III:;IIII!!EII.::::::::::::::::::~::::::::::!~l~~::l:~::::::!~l.~~:!:::~::~~~~::~~!::~::::::::~~~~:!::::~::::::!::~~l.~~~:: o o o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET A trust fund is often established by a formal trust agreement that places . restrictions on the use of the fund's assets. Resources are generally held in a trust fund for a longer period than in an agency fund. A trust fund can be an expendable,nonexpendable or a pension fund. An agency fund is custodial in nature. Since the fund operates as a clearing account for cash that the government entity collects for others and disburses to recipients, as authorized, the resources in an agency fund are usually not held for an extended period of time. o o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The Central Equipment division is responsible for providing safe and.well- maintained equipment for the City of Andover. CENTRAL EQUIPMENT CITY OF ANDOVER 2000 BUDGET WAGE DISTRIBUTION 12/30/994:15 PMCCEQUIP.XLS [Cl GROSS HEALTH DENTAL LIFE WAGE PERA ~ MEDICARE !NS.. !NS.. !NS.. TOTAL POSITION DESCRIPTION SUPERINTEN DENT 8,666 449 537 1 26 693 38 1 7 1 0,525 J EFF O. 409 21 25 6 22 3 1 486 BRIAN K. 496 26 31 7 22 3 1 585 KEVIN S. 499 26 31 7 46 3 1 61 3 11111~liil!:i:::iililii:iiii::ii:il:iii:I:I:'lii::ii:i::iii:i~I;.:i::::::::::II::::lli::i:illiiii!:iii:i:i:1ill::j:;I:III:i::.:li::i:liiliiii::i::i:li:~::::i::I:::!:l::l::i::::iiii::iiiliiiilll:::!::::::::::::::j:gliI JOHN W. 36,222 1 ,876 2,246 525 3,696 202 88 44,855 SCOTT H 31 ,582 1 ,636 1 ,958 458 3,696 202 88 39,620 ERIC S. 8,658 448 537 1 26 - - - 9,769 iIIIHIIIII!rnl~l:i:I~:!::!i~:!::i::::!lii:i:i:il~.ii:11iiiil]llji:i::::i:::I~il~::i:':ii:I~!lii:liii~:ill:;iii::!ii::i:::i::i:::!t~llil::li:iiil:iil:III:::i::i::::::i:::ii:!::i:i:'!:i~:!tli!:::i:i:i::::::::III.'i SCOTT P. 761 39 47 1 1 92 5 2 959 DENN IS M. 1 ,790 93 1 1 1 26 231 1 3 6 2,269 TERRENCE S. 1 ,790 93 1 1 1 26 231 1 3 6 2,269 .S O. 1 ,903 99 1 1 8 28 1 09 1 3 6 2,274 J. 1 ,884 98 1 1 7 27 231 1 3 6 2,375 J EREMY J. 1 ,884 98 1 1 7 27 231 1 3 6 2,375 I RWIN R. 1 ,884 98 1 1 7 27 1 09 1 3 6 2,253 GERALD K. 754 39 47 1 1 92 5 2 950 RAY S. 1 ,922 1 00 1 1 9 28 231 1 3 6 2,41 8 AN DREW K. 1 ,790 93 1 1 1 26 231 1 3 6 2,269 TOM R. 71 6 37 44 1 0 92 5 2 908 MERYL P. 1 ,696 88 1 05 25 231 1 3 6 2, 1 63 RON SCOTT 1 ,696 88 1 05 25 231 1 3 6 2, 1 63 JIM SANNERUD 71 6 37 44 1 0 92 5 2 908 OVERTIME 3,000 1 55 1 86 44 - - - 3,385 :lllllilllll'HIIIII!lg:I:I:::::::::::I;~~il~:iiill:l.iiiijiililil!:ii,ii:lii~;I;I::::::li:I:::::i:i:iiiii:il~::ii:liiiil::iiii:::I;I~:I::::::::::::i:ljlillilliiiiiii::l:l,:ii:il::::::ili'l::il:.il: SECRETARY 2,374 1 23 1 47 34 41 6 23 1 1 3,1 28 FINANCE DI RECTOR 1 ,278 66 79 1 9 370 20 9 1 ,841 ACCOUNTANT I 373 1 9 23 5 87 1 0 4 522 RECYCLING COORD. 646 33 40 9 92 5 2 829 DATA ENTRY CLERK 1 ,540 80 95 22 231 1 3 6 1 ,987 ERAL CLERK 1 , 1 79 61 73 1 7 1 09 1 3 6 1 ,457 i.II:IIII'llliil'iiiiii,liili:iiiiliiii:ii:I:~~I:~i::1:::::::i::::II::ii::i:i:iii::i:!liii:iiiiiiiiillii:i::j:U!t:::::::::!!lII:I!I;ii::i:iiiii~:iii:i:::iiili:i!l!:il:i::iiii:i:l:ll!t::::i:ii::iiiiiii.i:il~il: GRAND TOTAL 1 1 8, 1 1 0 6,1 1 8 7,323 1 ,71 3 1 1 ,91 4 678 297 1 46,1 52 CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/994:15 PMCENTEQ.xLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Superintendent 0.150 $ 8,255 0.150 $ 8,666 Suoervisor 0.030 1 ,443 0.030 1 ,403 Maintenance Workers 0.580 22,131 0.580 24,187 Qechanic 1.600 63,129 1.600 76,463 Summer Helo 0.000 6,400 0.000 - Public Works Secretary 0.100 2,653 0.100 2,374 Recvclina Coordinator 0.020 589 0.020 646 General Clerk 0.050 930 0.050 1,179 Data Entry Clerk 0.050 1,128 0.050 1,540 Finance Director 0.020 1,321 0.020 1,278 Accountant I 0.010 373 Total 2.600 $ 107,979 2.610 $ 118,110 o CITY OF ANDOVER 12/30/994:16 PMWCENTEQ.xLS Revenue/Expenditure Budget Worksheet Budget Year 2000 - CENTRAL EQUIPMENT FUND TRUST & AGENCY FUND I.i Revenues Revenue Actual Actual Actual Budget Request ~ 1.996. 199Z. 1.998 .1999 20QQ lr.h~rnA~ fnr SArvices 3621 2 Valuation Adjustment $ - $ - $ 527 - - 36260 Refunds and Reimb. - 21 1 ,895 - - 38400 Equipment Rental 205,880 31 0,501 307,306 349,721 358,752 l::::::::!:::::!::::::::l:::l:::!:::::::::::::::::l,::::I~ltitt:::::::l:::::::l:::::::!l~:!::::!~~~~!9.~:!:,::~!!::~:~~~::::::::~~~!~~::::~::::!:!:~~l!.~~~:::::~:::!:!~~~1!~::::!li::!~:::~~~~!!~~: Miscellaneous Revenue 3621 0 Interest Earnings $ 2,200.00 $ 472 $ 4,31 2 $ - $ 1 ,500 1::!:I::iI\IIIEI:m!BII:II::!~:I:!I:::::I:i:!:::::::I~:::::::~:::::~~~~:::::::Ii.:~l,:~i.:l:::::~~~I~~:::i.::~::::'::::::::'~1~~~~;::::~::!;:::~:~~~~i.~!:::::~':::,:::::~~!:~' I:] - Expenditures Object Actual Actual Actual Budget Request ~ 1.996. 199Z. 1.998 .1999 20QQ Personal Services 1 01 Salaries $ 71 ,031 $ 80,061 $ 91 ,888 $ 1 07,979 $ 1 1 8,1 1 0 1 21 PERA 3,1 48 3,583 4,765 5,262 6,1 1 8 1 22 FICA 4,1 92 4,674 5,368 6,695 7,323 1 25 Medicare 980 1 ,093 1 ,257 1 ,566 1 ,71 3 1 31 Health Insurance 7,251 7,61 2 9,21 9 1 0,81 2 1 1 ,91 4 1 32 Dental Insurance 472 51 6 603 600 678 1 33 Life Insurance 35 36 39 238 297 !::l::!!::::::!l::.::::::::::::::::::lilll::!:::::;::::l:::!:::::!!ll::!:::::::,:::!~:::::::::~::!::::::::'::!~~!~~~::::::l:~::~:::~!::!~::':::::~~i?:!?::::::~:::::::::~~~i~~:~~:::::I:::::~::::::~:~?~:~::::::~:::!::::::~~~~:~~:: ISurmlies and Materials 201 General Office Supplies $ - $ 5 $ 225 $ 400 $ 500 21 0 Operating Supplies 5,799 6,373 7,259 8,000 8,000 21 2 Gas - Vehicle 1 5,1 80 1 0,471 1 1 ,01 6 1 8,000 1 5,000 21 8 Diesel Fuel 25,577 32,497 20,407 32,000 32,000 220 Repair/Maint. - General 435 485 1 ,1 78 500 1 ,500 0 221 Repair/Maint. - Vehicle 97,248 75,453 84,41 8 75,000 75,000 240 Small Tools 2,026 3,269 3,850 3,500 3,500 CITY OF ANDOVER 12/30/994:16 PMWCENTEQ.xLS Revenue/Expenditure Budget Worksheet Budget Year 2000 C Object Actual Actual Actual Budget I Request ~ ~ 1.9aZ 1995. ~ I 2QQQ I::II:tt:::;I:iII::mll!!I!IItlltI::t::::;:::t:::::I~iI!:~i::~::~I~'!:!:i~!:!:IIi:::::::::~:::~~!i.~!!I::I~:':~:::::~~!~~!:;ti~i:~:~::~i:~:i1~~!~~::::I:I::~::~:1l!~!!J Purchased Services 301 Professional Services $ 1 58 $ - $ 200 $ 500 $ 500 321 Telephone - - - - 500 330 Transportation - - 2 500 334 Vehicle License 523 1 02 664 600 700 360 Insurance 37,050 1 4,281 7,736 42,085 43,348 Other Services and Charges 401 Repair/Maint. - General $ - $ 895 $ 441 $ - $ - 405 Repair/Maint. - Vehicle 1 5, 1 32 8,736 1 8,871 30,000 30,000 406 Contractual Services 1 53 91 6 780 1 ,000 1 ,000 409 Inspections/Emissions Test 40 40 56 500 500 41 0 Rentals 262 28 422 500 500 433 Dues/Registration 1 ,646 1 , 1 47 203 2,000 2,000 442 Meals/Lodging - - 31 9 - 442 :::I::::::I:::I::::,:::II:I:::::::::::.liiil~:::::I::1:1~::::I:::!:::I:!:::::::::i:!:::I:!:l.i::::::::::::::::~,~l!~!:I::I~'::::::::'~:~~::::!~!l~~::::I:~:::::::::;::!!:l~~:::::~I'::~::~::;'!i!f~l::!l',:::,::::~:'~~!i~ '" WI Capital Outlay 550 Vehicles $ - $ 1 0,907 $ - $ - $ - 580 Equipment 1 3,871 35,51 4 - - - o C) o o CITY OF ANDOVER, MINNESOTA 2000 ANNUAL BUDGET The Risk Management fund was established to provide funding for compensated absences, safety, training, loss reduction and insurance deductibles. Social security and medicare tax savings resulting from participation in the "cafeteria plan" are recorded in this fund on an annual basis. Each year the General Fund contributes a specific dollar amount to the Risk Management fund. This dollar amount is determined each budget year. CITY OF ANDOVER 2000 BUDGET WAGE WORKSHEET 12/30/994:17 PMRRISK.XLS Q GROSS HEALTH DENTAL LIFE WAGE fE.BA FICA MEDICARE INSURANCE INSURANCE INSURANCE TOTAL POSITION DESCRIPTION FINANCE DIRECTOR 5,112 265 317 74 370 20 9 6,166 ACCOUNTANT I 1 ,493 77 93 22 87 10 4 1,786 RAND TOTAL 6,605 342 409 96 456 30 13 7,952 o o CITY OF ANDOVER EMPLOYEES 2000 BUDGET 12/30/994:17 PMRISK.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Finance Director 0.080 $ 5,285 0.080 $ 5,112 Accountant I 0.040 $ 1 ,493 Total 0.080 $ 5,285 0.120 $ 6,605 o c ~ CITY OF ANDOVER 12/30/994:18 PMWRISK.XLS Revenue/Expenditure Budget Worksheet Budget Year 2000 o RISK MANAGEMENT FUND TRUST & AGENCY Hevenues Revenue ~ Actual ~ Actual 1m Actual 1i9a Budget ~ Request 2QQQ 36210 Interest Earned $ 3,073 $ 4,543 $ 5,961 $ 600 $ 4,200 36211 Market Loss on Investment 117 - - 36212 Valuation Adiustment - - 595 36230 Contributions - - 161 300 200 36246 Workers' Compo Refund - - - 36260 Refunds and Reimbursements 26,744 41,616 28,730 27,000 27,000 Expenditures Object ~ Actual ~ Actual 1m Actual 1i9a Budget ~ Request 2QQQ o Personal Services 101 Salaries $ 4,298 $ 5,788 $ 8,276 $ 5,285 $ 6,605 104 Salaries - Separation Acct. - 3,873 3,563 5,000 _ 121 PERA 191 264 467 274 342 122 FICA 256 565 692 328 409 125 Medicare 60 132 104 77 96 131 Health Insurance 213 385 623 370 456 132 Dental Insurance 18 36 54 20 30 133 Life Insurance 1 2 3 8 13 :::l:,::l:::l!:::l::::l:::::::::l:::l::l~::l::i::!::~:::::::1::~I:::::l.!~!!i!::i:::1l:::~::,:::::::::~:::::::::~:::::!::;::!:::::'::~I~~~:::::I'~::!::::~~:il!,:::::I:::::l:!~:::.!~i!~::::~::::;::::~1:~i.t!!;:':::1:~::::::::iT~!:~~: I SUDDlies and Maleril\ls 207 TraininQ Supplies $ - $ 75 $ - $ 500 $ 500 210 Operating Supplies 227 565 321 1 ,000 2,500 1:::1::::::1i:1::i~::::1::i::::1:11:::~I~~lfI1:::::1~1:::::'::::::::li:1::::::::::1::i:1:1i:::~:::_i,!:::_:::;:1_11:_1:;::_1 Purchased Services 301 Professional Services $ 552 $ 2,706 $ 5,000 $ 1,500 $ 3,500 302 Health & Wellness - _ _ _ 330 Transportation 37 - 8 50 360 Insurance 3,969 4,562 614 4,200 3,000 :1::::::,::::!::li.:i1l::::':::~:::::::::1:::::~::1!1~::::::ll::~:::l,::::::.li!I:!ll:::::::l::,,:l::::::::::::::,:I~:!:'::'i'!!:::i:!ili!:li~~!:!:::::i.~~:::!!i:~EI:::::!\~!::i!!:ii;';'!:!~l;~::,:::,:I!:i!::::!i:~~iM::i:::::I::i::!'::i!~~I:: C!arvices and ChArlJeS 433 Dues/Registration $ 50 $ 575 $ - $ 1 ,250 $ 1 ,010 499 Contingency 2,980 2,749 9,394 6,800 10,000 Capital Outlay 580 Equipment $ - $ - $ - $ - $ 3,000 1~jjII~:!~~~!!!~!~:~~~~1:~~!!~I:~!~m!~j![!!!l:~!!!:!j!f~j~~li[fl!j!1~H!!J!!!~!!!!!:!!!!:!!i!~P~i~11![il!j:~!!~!!!!:~!!!!I!!!!:I!!!:!!![:r!!!!:!!l![t:~ji~1li!l!i:~j!1!!J!~!iI1!!!!!:!!m!m!!@i1l!i~l1~:!!j![!!j!!:!~j!:!!~i~li~~ CITY OF ANDOVER 12/30/994:18 PMWRISK.XLS Revenue/Expenditure Budget Worksheet Budget Year 2000 Actual ~ Actual .1m Actual ~ Bud et ~ Request .2QQO. c o