Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
WK August 9, 1999
.,. - " .," ~ -: ':' -'.. '::~~_:'.Y:~l~;;~~.':-;" " , . ' '. '. .' , - .-:.... .!'.-' ,.'- ~ - " . - .: '-, "'. ~-~ ---',~' -....:-- :~-.:.'. ':'-_c':' ~t;"~-''''-''''''~''~X,~':-'~ .. CITY of ANDOVER' ---':',~',-'-;,.~~:~<: . .Special City Council Workshop - Monday, August 9, 1999 - '--, '.....' :.:~ _:_- ~ 1. 2.> : Adjourrimenf., ~~-~~' $ : .~. .~.~ \_~~:Z,~:/~~'.:~::'.:~" CITY OF ANDOVER 1/4/9911 :56 AMREV-EXP.XLS Budget Summary - General Operating Budget Budget Year 2000 Actual 1996 Actual 1m Actual 1l!9!l Budget 11!l!li! Budget 2lK!2 REVENUES Property Taxes $ 2,180,470 $ 2,383,965 $ 2.804,065 $ 3,298.518 $ 3,543,672 Ucense and Permits $ 390,327 $ 456,413 $ 694,808 $ 431,390 $ 491 ,490 Intergovernmental Revenues $ 827,690 $ 988,814 $ 880,697 $ 961,917 $ 931,882 Charges for Current Services $ 447,198 $ 578,221 $ 1,018,441 $ 574.100 $ 701,998 Fines and Forfeits $ 57,125 $ 48.800 $ 48,923 $ 43,500 $ 52,000 Miscellaneous Revenue $ 180,601 $ 258,494 $ 360,738 $ 201,400 $ 278,800 Transfers $ 71,000 $ 317,200 $ 464,020 $ 949,423 $ 385,000 .......................IT9j~~gy~~ .......................Ii. ......i........4')i5,i@"\.j...... $' .........I..fs.&iiR..i............. J...gili'iil{@.i .....$... ......i......sl:w6ili;m;...i.........................~~~~~... EXPENDITURES General Government $ 1,068,575 $ 1,217,720 $ 1,530,239 $ 1,773.880 $ 1,911,115 Other 693,737 218.282 945,530 2,031,835 $ 2,605,594 $ 118,800 $ 2,026,402 2,869,032 114,827 Public Safety 1,290,681 1,518,684 1,409,087 1,618,646 1,579,837 1,665,517 Public Works ...........,...................................................................................-.-...........-. ...,......-,..-...-................ ..........-....................'.........-........ .........'......,........................... .....-..................'..........-............ ..:.:.:-:....-:...:...;...;...:-:................ ............,.............,........ Tbt'*W~*feNPtr9~$S<$.4;5'Alt7i;$4AM1735$\S,?21;*23~S;530)1091@,921;375 .:.~:.....i:t9Y~ll_~]:.r'.....i...II..l~iFi;~~.~t..ii...i&i$ii~r*..::.:..: ..ti$jMrl..iI......ilN6~l~~H~~:$.....;.....~j~$~ CITY OF ANDOVER 1/4/9911 :56 AMREVSUM.XLS Revenue Budget Summary - General Government Budget Year 2000 Actual Actual Actual Budget Budget 1m 1m 1.996 ~ 2Q!!Q Property Taxes $ 2,180,470 $ 2,383,965 $ 2,804.065 $ 3,298,51 8 $ 3,543,672 License and Permits $ 390,327 $ 456,41 3 $ 694,808 $ 431 ,390 $ . 491 .490 Intergovernmental Revenues $ 827,690 $ 988,814 $ 880,697 $ 961 ,91 7 $ 931 ,882 Charges for Current Services $ 447.198 $ 578,221 $ 1 ,01 8.441 $ 574,100 $ 701 ,998 Fines and Forfeits $ 57,125 $ 48,800 $ 48,923 $ 43,500 $ 52.000 Miscellaneous Revenue $ 180,601 $ 258.494 $ 360,738 $ 201 .400 $ 278,800 Transfers $ 71 ,000 $ 31 7,200 $ 464,020 $ 949.423 $ 385.000 A_:mt~::::::'i::'f:l':i:m:::"::Il::l::::lf:'$@@':;;mf::H(1$iil1It$i;@I@:;:::i:;_;_;':*j'IIf::@~mlmti$':t@:miil~:::i@l':;EI~ CITY OF ANDOVER Revenue Budget Worksheet Budget Year 2000 1/4/9911 :56 AMGENERAL.XLS GENERAL FUND I I Revenue I Actual Actual Actual Budget Budget Code 1996 1mZ 1998 1999 2000 prooerty Taxes 31010 Current Ad Valorem Tax $ 1,778,003 $ 1,973,572 $ 2,327,230 $ 2,793,563 $ 3,149,936 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 357,236 31910 Pen/lnt. on Ad Valorem 14,395 14,079 8,321 18,000 12,000 31920 Forfeited Tax Sale Apport 4,224 766 1,774 1,000 1,500 ,.,..,.,. ,:.,:,:" ~.. ,~ l~"""" :i::":'" !tlU,4IU "",........... Licenses and Permits 32110 Liquor - Intoxicating $ 5,100 $ 4,600 $ 4,600 $ 4,600 $ 4,600 32111 Liquor - Non-Intoxicating 650 600 880 640 640 32130 Cigarette 325 300 975 900 900 32140 Refuse/Recycle Haulers 705 1,095 1,625 4,450 1,500 32150 Rental Licenses 100 5,150 333 1 0,150 3,250 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 32165 Peddler 450 300 300 400 400 32166 Therapeutic Massage - - 300 - 150 32210 Building 297,406 346.048 540,129 325.000 375,000 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 7.500 Water Permit - - - - 7.500 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 900 32260 Burning Permits 1,220 1.570 1.880 1.500 1.500 32261 Rezoning 1,025 1.683 1,000 1.000 1,000 32262 Special Use 3,700 2.091 3.075 3.000 3,000 32263 Variance 1,175 1.150 500 1.000 1,000 32264 Lot SplitsNacate Ease 1,118 1.600 1,225 1.200 1,200 32265 Special Home Occupation - 400 950 200 200 32267 Signs 1.767 1.183 1.354 1,500 1,500 Meeting Notif. Sign Fee - - - - 500 32268 Moving 75 - - - - 32269 Compo Plan Amendment - - 900 - - I .",..,. .,.,.".".".. """,~ ~: i~ ~.. ~...~......,.~,. ....i.. i.... CITY OF ANDOVER Revenue Budget Worksheet Budget Year 2000 Revenue ~ Actual Actual ~ ~ 84,283 $ 68,667 $ 44 65 106,935 120,769 343,343 331,977 - 23,111 - 5,047 - - - - - - .Interaovernmental Revenue I 33130 Comm. Develop. Block $ 33131 Electrical Permits 33401 Local Gcvernment Aid 33402 Homestead & Ag Credit 33403 Lccal Performance Aid 33404 P.E.R.A. 33405 C.O.P.S. Grant 33406 SCORE Reimbursement 33407 State Police Aide 33418 Munic. State Hwy Aid 33420 Insurance Premium Tax 33422 Other Grants 33430 School District Liason ~~~A!~t..$} 140,000 54,542 92,763 5,780 ...-....'...'....-...-.;.-.;.;.;.-.-.-.-...:..<.,. a21;69~.~ 140,000 54,275 240,018 4,887 ...-.-.-..-,..-.-...-.-........,..'_..'..'.--..-.......-.'.-.-.. .. ....... ........98.. . ..8$14. ........ . -......., . _.. ............... , . "';'.;:.-':<:::::::::::: ,- ..-: >:::\::: .".-.'..'......... ". 1/4/9911 :56 AMGENERAL.XLS Actual 1998 I Budget 1m 40,000 :Ii 100 111,145 340,288 27,087 5,000 110,000 51,000 49,547 140,000 65,000 12,000 10,750 96.1:9fli~ Budget 2!12Q 40,000 100 119,752 381,528 50,000 55,000 53,132 140,000 62,000 12,000 18,370 931;882 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 170,000 243,750 34105 Sale of Copies, Ord. etc 1,364 1,035 1,340 900 900 34106 Reports - 40 20 - - 34107 Assessment Searches 1,788 2,613 5,025 5,000 5,000 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 Recycli ng 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 - - 34121 Escrow Inspection Fee 3,925 2,735 3,525 1 .400 1.400 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 66,780 34126 Civil Engineer Fees 65,659 78,744 58,509 75,000 79,500 34127 Asst. Engineer Fees 27,959 26,927 20,110 29,000 30.740 34128 Engineering Sec. Fees 24,741 25,560 20,989 26,300 27,878 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 - - - - 34140 Flood Zone Search 30 15 - 100 100 34141 Financial Admin. Fees 303 19,988 257,892 33,000 80,000 34142 Planning Dept. Fees 3,897 16,067 10.4 72 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 - - 29,974 $ 117 122,651 340,466 28.490 10,093 23,750 48,852 52,009 140,000 57,830 7,041 19.424 $i8~;~~7$i CITY OF ANDOVER Revenue Budget Worksheet Budget Year 2000 1/4/9911 :56 AMGENERAL.XLS Actual 1996 Charaes for Current Services. continued 34149 Tech 4 fees 34200 Bid Plans 34951 Sac Retainage "':"'::::",.":::: ..}}.,>..>>................ .............. '. . .... i~ 285 2.475 Actual Actual Budget Budget 1997 1998 1999 2000 46.356 81.190 100.000 100.000 125 225 100 100 2.869 4.911 3.000 3,200 ...... "~:~ ...........~; Revenue Code . . . Fines and Forfeits 35101 Court Fines $ 56.300 $ 47.590 $ 47.423 $ 43.000 $ 51.000 35102 Other Fines 825 1.210 1.500 500 1.000 i.......... ::: ".s>> ~..,~+ ., ..........:;;; .......... ..... ..... Miscellaneous Revenue 36103 Assmt. Coil. by Cty. - Cur. - 2.383 645 - - 36104 Assml. Coli. by Cty. - Del. 361 308 2 - - 36210 Interest Earned 47.910 71.224 162.026 25.000 80.000 36211 Market loss on Investment 4,744 - - - - 36212 Valuation Adustment - - 15.544 - - 36220 Rent Other Than City Hall 1,000 19.832 30.384 27.000 33.000 36230 Contributions 1.000 200 - - - 36241 Pop Machine 5 64 197 - - 36242 Maps. Etc. 318 439 810 1.500 1,200 26243 Tree Tape 102 - - 100 100 36245 Sale of 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 134.700 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 ::: .....".....,..". ..' ......... ..... """. ".....iAO('. '" ,..... ..............~. .:>:'.: ,$. ".,,::::./. '1.4UU :'1;:>>.. ,:. .... ......... ........ ........ ....... ... ..... ........ Transfers 39201 Transfers From Other Funds 39203 Transfer From Admin. Trust 39207 Transfer From PIR Fund 39210 Transfer From Sewer Fund 39213 Transfer From Water Fund 39214 Transfer From Capital Equip. 39215 Transfer From In-House MSA '.' .... "'subidtaf $ . $ 246,200 $ - $ 71.000 71.000 33.020 - - 50,000 - - 12.000 - - 69.000 - - 50.000 - - 250.000 .. 7t,000> $> 317(200)$> 464i(i20$ '.' .........................................1...... :.:.:.:..:.:.:.:.:.:.:.:....:...:.:..:.:.',:...'.:.:.:.i;:.'.:..o.)"......~.............dn......"...:.....:..,:.:..:.::1.:. :...:....'.:.:.:.:.:.:.'..:.:.:.:...:.:...........6...>..::.:.,.:"'...:........~......:.:.:.~h...:.....3...'.:.:.'.:..,..:.1..:.:.:...:..,:. 4/i54;'4ttI ". "'."'''' =".""" ..... $ 32.723 140.000 12,300 70.775 693.625 10.000 50.000 325.000 r .,. I II. 9aAffRT9TAY..:.JI': $ :I~ 949.423\$/ 385;000 .::6~400;24S:.l.I .':::.6;384~':: CITY OF ANDOVER 1/4/9911:57 AMSUMMARY.XLS Expenditure Budget Summary - Totals Budget Year 2000 Actual ~ Actual .lim Actual ~ Budget 1999. Budaet 2QQQ GENERAL GOVERNMENT r.ENERAL GOVERNMENT 'r'ptalGel1eralt1ov'ii$ .... 1;f21(608$ii;21S;554 $1;530;241$lf773.S79> $>+.91i'11s '),....E.~I3LI9.~.eF~l".v.....>.., ....."."i.........................."",...',..., ............ ............. .... ..... .......... .............................................. mRm!g9!lJI~~;;I~..$t;290tl3~1.~1;~99;~1~i;5i9;e37$~Q31;a35$a()26;4()2 PUBLIC WORKS 'r'Ptalpq~!,~WpikS i$ll5f8;687$a;61e;&17~I 1;6~~~516 ......~......g;6lJ~l594$~~~~9! OTHER .. ...Totlilfotfieii> .$} 693;736iS9$I2:18i282$ ...................................r.. ...r.... .r' ....II~aANPTQTAt;IIII$4;fi24;71gtial;$I4~o;~j$I... ............................................. .................9...5. "'5"3' 0 "'$' }. ",'\. "j.' ."",:.1:, ..5}721;1~$ ................................................. ..,......1..1. '0'8" .Nt.....~..... }>".~I~i ...L .,.,.,.,t~~Q;lQ.8if......$.t.. r....'.'114;8Zi ............................... r..f~~.~al~... CITY OF ANDOVER 1/4/9911 :59 AMTOTSUM2.XLS Expenditure Budget Summary - General Government Budget Year 2000 Actual Actual Actual Actual Budget Budget 1995 1996 1997 1998 1999 2000 GENERAL GOVERNMENT I Mayor and Council $ 52.~92 I $ 53,034 $ 55,200 $ 58,388 $ 76,854 $ 79,056 Newsletter Total 4,439 5,247 6,287 7,200 17,000 21,000 City Clerk Total 91,344 88,039 88,179 95,031 100,508 107,392 Elections T olal 5,881 15,635 2,474 13.311 3,515 31,720 Administration Total 66,691 74.946 86,812 81,420 86,927 89,463 Financial Admin. Tolal 140,705 I 151,747 176,176 175,678 215,006 235,539 Auditing Tolal 12.579 9,425 7,468 7,420 8,600 9,500 Assessing T olal 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,858 Dala Processing Tolal 24,357 27,437 43,798 44,853 66,550 107,075 City Hall Building Total 40,909 48,271 48,104 59,341 67,900 70.539 Fire Slatlon Tolal 35,008 40,622 43,622 41,997 53,750 54,800 Public Works Building Tolal 45,140 45,383 45,503 238,072 246,343 278,358 Senior Citizen Center Total 7,573 8,583 9,464 9,454 12,180 14,433 Equipment Building Tolal 1,412 2,997 2,720 4,381 16,150 20,806 City Hall Garage Tolal 6271 430 824 506 1,875 2,592 Engineer Total 150,602 210,771 269,385 355,176 416,570 386 527 ... ...............,.".,.,. ~. I}', ". ~..." =C'...'=' = PUBLIC SAFETY Police 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 613,448 Protective Inspection 225,911 235,721 254,155 282,998 324,694 326,787 Civil Defense 9,230 12,940 6,246 12,868 12,712 13,632 Animal Control 9,464 11,563 11,311 9,854 13,325 10105 "~'i== ~~:"'.""."'."" ~, n 'i.,"",. Si. .,".",.". 7. .".....,.,..",...,., .","".,,' (,.,.,.,.." PUBLIC WORKS Streets and Highways $ 257,148 $ 540,035 $ 458.483 $ 472,878 $ 985,030 $ 1,194,616 Snow and Ice Removal 191.614 215,230 375,829 265,026 440,267 476,626 Storm Sewer 16,349 29,209 69,061 66,693 150,486 124,761 Street Lighting 19,168 18,240 21,728 24,374 36,200 38,400 Street Signs 68,260 67,820 80,804 113,190 108,736 116,202 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 22,478 Weed Control 4,596 8,919 5,270 11,737 18,950 20,072 Parks and Recreation 329,416 455,517 383,058 461,131 585,875 580,896 Sunshine Park - 10 33,492 21,181 26,442 31,917 Recycling 58,260 55,170 62,281 76,773 94,999 98 363 I,."",.""" "".',.,.".,.".' ,....'::n ~ ';.;.';;". ~ I ..}.}. '.',','.' "..,.".,., ,'.",,',",,' ,...,.,.,.,.,..,...,.".,.,..,.,. ",.,..".,' OTHER .........,....,..".,. ,',"-,"-' ...................-".._...,-,'.-,..._...,',.....,.,......-. '",..''' ........-----.--...... . ......'.'.'.".""'$.. 'l'Clbirith<< "il} ::gi~:l(iii~%:i:I::lmiI 133,046 693,737 218,282 945,530 118,800 114,827 1~~~~I$59sii~~I$~~~!i~945,iB~j $11~~~~.j~114,iE7 :::$iQl;Mi:Il$InI:1I;m'_:ll$:I::n:i;Ml%1!:~::$I::I:IIilMI1~I!:~:i:I:::nm~illiWi!:i:::'m~;1i$ CITY OF ANDOVER 1/4/9912:00 PMSUMMARY.XLS Expenditure Budget Summary - General Government Budget Year 2000 Actual Actual Actual Budget Budget ~ ~ ~ ~ ~ Mavor and Council - Department# 41 1 1 0 Personal Services $ 20,024 $ 20,024 $ 20,024 $ 37,032 $ 37,780 Supplies and Materials 201 776 209 400 400 Purchased Services 1 5,348 1 5,450 1 5,321 1 6,000 1 6,294 Other Services and Charges 1 7,461 1 9,81 6 22,834 23,422 24,582 [9~~!M~Y9r!9~qI!9e.~ $\.... .'S:{.D34 ..........,....................... 58\388;$/ ......-.......-..-....... ....-............."... $ iiM;OO5 I$ .............nr..... .$i "Y""'" ".,.".,.,."..,.,,854 i79(056 ,letter. nen"" 41140 Purchased Services $ 5,247 $ 6,287 $ 7,200 $ 1 7,000 $ 21 ,000 ................ j'otaiNewsl~ft~ I$ 5;241I ............................... ............................... ................................. ............................. ................. $ 6(2S.7 $ i7;2bO $ ......'.'........7..000.. $ .,.....'..2fooo ."..-..........-..., .... .,."....>:'>:>:'.4",.... .'i. ,-.".-"..-".--'- ',',' ", ..1...'."',.".,.,....... .... ........... :;::<<:::::::::::...:.:i.... ::: I City Clerk . Department # 41 400 Personal Services I $ 71 ,424 $ 70,989 $ 76,363 $ 82,271 $ 88,305 Supplies and Materials 464 1 ,483 881 480 525 Purchased Services 1 5,030 1 5,039 1 5,623 1 6,607 1 7,093 Other Services and Charges 1 ,1 21 668 2,1 64 1 ,1 50 1 ,469 .."".,."..".......",.. .......'........., !5 II "'" .:Ii>:,., Elections . Department # 41 41 0 Personal Services $ 1 3,850 $ 1 ,323 $ 1 1 ,860 $ 1 ,51 5 $ 20,1 90 Supplies and Materials 203 . 1 46 . 250 Purchased Services 1 ,583 1 ,1 51 1 ,305 - 1 ,280 Capital Outlay - - - 2,000 1 0,000 . " i) ~dministration . DeDartment it 41 4 m . Personal Services $ 57,467 $ 68,071 $ 62,076 $ 66,962 $ 69,924 Supplies and Materials 2,598 3,229 2,045 2,500 2,500 Purchased Services 1 0,857 1 2,1 93 1 2,760 1 3,41 9 1 3,895 Other Services 4,023 3,31 8 4,538 4,047 3,1 45 TQtajAdffil!j,~ti~~iQni ... .................. 74;946/ .(86(812 86[927 ...........-...,.......,'.... $i.. $ $> .81,420 i$ ${ $9,4$S CITY OF ANDOVER 1/4/9912:00 PMSUMMARY.XLS Expenditure Budget Summary - General Government Budget Year 2000 . Actual ~ inancial Administration. DeDartment # 41530 I $ Personal Services Supplies and Materials Purchased Services Other Services and CharQes Capital Outlay Total#lOli6eJalA:ilri'linlst@lklH T"""".'.'. . .... ... ... .... ..................... ... ..... ~lJl'Iit . D . # 41540 Professional Services Im~ Assessing. Department # 41550 Professional Services T9~j Attorney. Object # 304 141,051 $ 2,097 4,501 4,098 .... $ .. .... '151,147\$. ... .... ..... .r. . $ !. 9,425 $ $ Actual 199Z 161,283 $ 3,465 3,572 7,002 853 17611t6 7,468 $ 69,799 $ 68,914 $ '.',', ... ... ..... .,.... . . . . .... $ 99,407 $ ",., , ",., x,,:, '..; Professional Services Planning and Zoning - Department # 41910 Personal Services Supplies and Materials Purchased Services Other Services and Charges c:;~pit~19utl~x.,,' ,.. ,., ".,.., .,.,.",.....".. ..... .".,.,., , ..Tg1atPlaJm,ngiln~:Z0l1jog $' ."'r... I Data Processing - Department # 41920 r........ ... .. Supplies and Materials Capital Outlay 'I[R!~!9~~gfRSi~iDgI ...(.."'. I ........,..$. I I 97,926 $ Actual ~ 164,065 $ 2,976 4,298 4,339 $ ...... ....175,67& .$ 7.420 $ II 75,197 $ ".'.".'~I 98,242 $ "i Budget llm 198,662 $ 3,742 4,921 6,182 1,500 215l00s$i BudQet 2QOO. 214,160 4,350 5,527 9,303 2,200 >235)539 8,600 $ 9,500 76,000 $ ~ ~- 78,336 107,900 $ 108,120 '-..,.."~. 1 04,242 $ 1 34,31 1 $ 149,097 $ 1 76,736 $ 2,452 5,748 4,01 8 5,000 7,1 57 1 1 ,149 6,628 1 0,598 2,952 6,1 36 4,829 7,91 8 - 7,520 - - ... ,.. ",........ $ l>. 164,512 i$> 200[252 $> .......116,803> 164,864 'O"'. $ $ 27,437 $ ............ .$. .......-,-.-- -- ,-:,-..-,-.-.:: .., , . ,.. ., 27 437 ... ... ...., .. . . '.. . .'.1 ' . ... I 38,894 $ 4,904 431798>$ .r...... 42,608 $ 2,245 . .... . ...44. . ..853.....$ ......"..".., ..... iff 66,550 $ ....\t36!5S() ... [ '$\ I 191,019 5,000 10,604 8,236 1,000 215;858 92,075 15,000 dl}7~07S CITY OF ANDOVER 1/4/9912:00 PMSUMMARY.XLS . . Expenditure Budget Summary - General Government .' ,. He Budget Year 2000 ,. "'..;'.'.~. ._~,.. Citv Hall Buildina. Department # 41940 Supplies and Materials $ Purchased Services Other Services and Charges Capital Outlay mg!!'S~ff~~~9Ii~$!"n $I ire: .1t 41Q~n $ Supplies and Materials Purchased Services Other Services and Charges Til1~IEjr~$t~llif!i$ """""""""""""""""'T"" I Public Works Building. Department # 41960 "'f"""" .1..... Supplies and Materials Purchased Services Other Services and Charaes Capital Outlay Debt Service ,'. ......... ........ ......TliHllRgi:m~Worj{S' T"'" $ Actual ~ 3,911 $ 25,546 8,685 10,129 ............... : 48;271$I 1 ,598 $ 34,106 4,917 40;622 )$ 4,470 $ 19,905 4,472 16,535 Actual 1lm :" ,-'.t-~';.; Budget Budoet ~ ~ $ 6,500 $ 7,000 38,275 40,414 23,125 23,125 - - Actual ~ 4,878 $ 30,661 7,815 4,750 ""....".:48~1~4,.... 5,813 38,064 14,467 997 ... .. $} .'::.59;341 1,413 $ 33,951 8,257 :43;6.22)1; 7,900 $ 19,526 8,983 9,094 Ii$i4Si383i$i4S(S03$ ,eninr ~"nt"r . D 1:tt41Q7C Supplies and Materials $ Purchased Services Other Services and Charges TQtaisel1iQ'C~nter$ """"'"''''''''''r''' . Buildinn . m..nt tt 41QRn Supplies and Materials Purchased Services Other Services and Charges Capital Outlay .,.i.I....W9~~'~9~IRm~n~~~I~19,9....... $ 6,685 1,898 /8;583 $ 432$ 6.727 2,275 ...-...-...-.........-.',.'.....'....,._-.'.-. )$>.9)434$}i 209 $ 2,492 296 732 $ 1,988 .... ........'............................................ .... ......-.....-.-.....................:.-.:.....;.:.:.:. I$iSl~gonI$\7U;539 1,960 $ 31,454 8,582 .-...-.....-...',-.'.-...'....'..'.-_....--:-:. ..4ti997 15,962 $ 38,529 17,113 688 165,780 ............................... 238;072 . 452 $ 6,727 2,275 .-.....-...-....-......-.-.,.-.....-.;-;.-.'. '9;454. >~ 2,543 $ 1,024 814 5,700 $ 38,550 9,500 .:.;.-.;.;.;.-.-.;.;.,.;".-.-.;.'.;.-.;".'.:.;.-.;.:.;. .......~sa;750$ 18,199 $ 38,899 19,220 170,025 $i2461343 $./ 800 $ 7,280 4,100 12;18O$i 1,000 $ 13,750 1 ,400 5,700 39,600 9,500 54~8Od 18,603 43,200 30,040 13,000 173,515 2781358 800 7,533 6,100 141#33 1,000 13,406 1 ,400 5,000 20fiID6 $ii2J197$2;720$i '4~381>$a6h5d$i CITY OF ANDOVER 1/4/9912:00 PMSUMMARY.XLS Expenditure Budget Summary - General Government . . Budget Year 2000 . . - Gitv Hall - DeDartment # 41 ~90 Supplies and Materials Purchased Services ...T.............P.........~....a..........~.....C.............ffY............................!-f.......a.........It.................~........................................Q!....................................t ...r......,.........". Enaineer - Department # 42000 Personal Services Supplies and Materials Purchased Services Other Services and CharQes Capital Outlay .-........................................'..........--...........-.-.---........'----.'-...--.--...--.................. ........................,...,.......T........'.E..............,.......... >Q@} .llgl~I"}. ...................,-.-.-.. .................. I$ ...........$:. Actual ~ $ - $ 430 .....-...-.'..........-...'..'......,.'.., :::t~}:>/::>:::})430 ::r${}:{:}:::: Actual ~ 10 $ 814 i824I$ 232,174 $ 9,286 8,239 11,138 8,549 269!BS5i$i Actual ~ 3 $ 503 500..~ 303,832 $ 10,400 7,200 11 ,220 22,525 ..................-.-. 355Atft $i Budget ~ 150 $ 1,725 i~i~75i$ 364,503 $ 17,500 . 8,310 14,757 11,500 416;570$> Budget 2QOO 350 2,242 2;592 ................... 330,049 19,000 10,016 17,462 10,000 >386;527 ...:i1'lffipTAiJlGel'lJSRAt$p.Il';':$1II :I1;lal$Q$Ii :....;t~j;iti~I$ ............;i~~Q~It'iI.$.'.;i;17~jfj7ij'.I$1;9jinl1$:.. $ 192,060 $ 4,800 4,859 4,517 4,535 ..--.---.................,...,..,...,..,.,...,. 210;771 Iit CITY OF ANDOVER 1/4/9912:00 PMSUMMARY.XLS Expenditure Budget Summary - Public Safety Budget Year 2000 Police Actual ~ ion. DeDartm"nt 4"1 nn Actual rnrr Supplies and Materials $ 20.72 $ 169.84 $ Purchased Services 568,922.00 645,871.00 Other Services and Charges - - 'T6tajpojj(!ilpiot~alon($.......'............'..............568.................................I. 942:72$\64. 6.'.,. O.......4ol84 II$ .........................................'....T... Fire Protection. Department # 42200 Personal Services $ Supplies and Materials Purchased Services Other Services and Charaes Capital Outlay TQjaIErr~pr~!~~l!Q.iHI~? 312,944.32 $ 19,596.09 14,051.43 83,350.21 31,572.65 4611514['70$ Protective InsDection . Department # 42400 Personal Services $ Supplies and Materials Purchased Services Other Services and Charges Capital Outlay Miscellaneous "J"R!~lgi'#~~~y~!9~~sti.??j~ 217,392 $ 5,771 2,684 8,730 1 ,143 '.235)721($ Civil Defense. Department # 42500 Personal Services $ Supplies and Materials Purchased Services Other Services and Charges .. :::::::::::::Totill:-'CHii"f"Oefense:::::::" :"-:':':-:"':-:':':-:$':':':-:::':':'" . . /1(( 2,818 $ 5,142 1,163 3,817 ..-..-.....-........ .12,940($ Anim~1 ~nntrnl . Dl'!n~rtml'!nt It 42700 Supplies and Materials Purchased Services TCi!aIA9'm~19oQ#~1 $ 75 $ 11 ,488 ....,...-.,....-....-.....-....................'....',..-,'..,- ~:i~~~I~I '.N. . uuuuuuuuJ ..II.t..j.~~)6$1.tt$ ..$ ....(. lI.....:1;QTAkeUtJtJP;:.S,AEaj;)i! III.Ii 281,308.36 27,704.37 16,180.05 125,302.63 40,838.68 491;S34lo9 220,607 $ 8,996 4,458 13,877 5,161 1,056 2541155 $ 2,837 $ 1,253 2,156 .....6,246$ 186 $ 11,125 .. ....~~i~j~I~(.. .,.,.,.,...,...,."".........,.........................................1..,.,.,..,.., t::tl{:t]:l1i4Q$Jm7{mr$~::: Actual ~ 719,670.00 51,555.00 7i1t22S;o6 $ 315,148.33 $ 22,756.77 16,971.00 125,540.87 22,475.39 $(502)892;36{$0 240,634 9,336 21,348 10,842 837 Budget ~ Budget ZQQQ $ $ 1,012,092 1,062,430 $a;612;(j92$id;96~;430 417,078 $ 29,100 18,810 142,025 62,000 669;Ot2 423,143 34,350 20,057 135,897 .-.......'..,................... ..... $ ... .i613;44a $ 276,144 $ 9,850 24,474 14,226 - 288,459 13,900 8,015 16,414 I 282.998 $ 324.694 $326.787 3,034 $ 5,054 1,223 3,557 12;868 i$> 181 $ 9,673 .............................................-.......'..',-.'. ....9. '.854.. ..$......... .............ijii 1~!i7~;ijij7...I.$ 3,162 $ 4,450 1 ,450 3,650 12.712{$> 3,307 5,150 1,525 3,650 13)632. 30 10,075 dq\!Os 250 $ 13,075 13,325$/ ."( "'"'1''' a<i1~ija$1.I:.$:;;:.a_mi.. CITY OF ANDOVER 1/4/9912:00 PMSUMMARY.XLS Expenditure Budget Summary - Public Works Budget Year 2000 ~tr..I>t'" & Hiahwavs. Deoartmen # 43100 Actual ~ Actual lim Actual 1Wl3. I Budget : Budget ~ 2QOO Personal Services $ 139,552 Supplies and Materials 33,087 Purchased Services 12,384 Other Services and Charges 302,237 Capital Outlay 52,776 ,[9~~'~tr~~~~tll~~!f.~X~,~ii 540,035i$4i58;Ml3i$ .472;~78~>>i9~5;b30~idlf9~f~i~ I I I~nnw =lnd Ice val- D"'"'" . # 43125 Personal Services $ Supplies and Materials Purchased Services Other Services and Charges Capital Outlay TQiaISnbwanatceR~movar$ ""..,(".,.. ........................... ......... ............ "f I Storm Sewer - Department # 43150 $ 118,552 $ 158,818 $ 131,512 $ 130,919 24,318 21,240 27,357 30,700 13,536 15,512 15,402 16,060 302,077 277,308 810,759 1,016,938 - - - - 100,448 $ 65,811 2,146 46,825 158,705 $ 144,620 2,300 70,205 215;230 $> 37S;829 I $( Personal Services $ Supplies and Materials Purchased Services Other Services and Charges Capital Outlay .... ,. .....,.'.'''tolall)to~m$~Wel'>$> 'I.' ",.,,<,'(,.. Street Lighting. Department # 43160 Purchased Services Other Services & Charges Capital Outlay '.T()t~!?!t~~tgm!,!!ipg """"1"'.'." $ $ $ >......$> """""'1".. . Street Signs - Department # 43170 Personal Services $ Supplies and Materials Purchased Services Other Services and Charaes Capital Outlay ..I..............T.........O..'.....~..'...I~Jr~. !$19.'./ts.'..."".'..'......$/ ..1'. ..........sf 106,398 $ 84,861 2,422 70,220 1,124 265;U2S 228,225 $ 126,400 3,070 82,573 241 ,575 138,400 3,296 93,356 ..................................... ................... $440,287.$> 47S;B26H 9,695 4,517 291 4,161 10,546 "".>29,20j:f $ 34,866 $ 21 ,481 $ 47,389 $ 51 ,073 3,31 5 1 2,1 03 4,500 4,800 307 296 831 835 3,523 32,81 3 67,765 68,053 27,049 - 30,000 - i$><. 69;001 /$.'.. 66;693 i$ 150(486 $> >124,761'. 17,531 100 610 '.'18(241i 27,256 $ 18,823 90 16,257 5,395 67i82() [$> $ 19,437 $ $ 50 $ $ 2,241 $ $(21)728 $) 42,488 $ 30,752 301 7,262 20,964 350 3,060 .. . 24,374 61,521 $ 43,830 176 7,663 $ $ $ $> 26,000 $ 200 $ 10,000 $ 36;200i $ 26,000 400 12,000 ...... '. .. ,. ..',.. 38,400 55,793 $ 29,150 316 23,478 58,066 32,700 419 25,016 .........'00864$ . .t13!190i$i08736$i'1ie202 .. >.>. ..,.. .'/[i .'..,.,........... .1> 'Ii , .. ,., CITY OF ANDOVER 1/4/9912:00 PMSUMMARY.XLS Expenditure Budget Summary - Public Works Budget Year 2000 Traffic Sianals . Department # 43180 Purchased Services ....... c;~~i;~~~~~fflP$19b~I$ Supplies and Materials $ Purchased Services Repairs & Maintenance Capital Outlay . ..[I'R~~~~~~~~~~~~t~m~~I~ Actual ~ $ 16,610 $ Actual ~ 17,303 $ $ - $ 87,613 2,423 I Actual ~ 17,350 $ - $ 103,350 9,225 Budget I ~ 25,000 $ 150 $ 97,550 16,000 Budget 2QQQ 30,000 150 118,550 16,000 7,573 - - - - 89i534)$}90id$ )$('112j575 ($ 11aj700}$} 1341}ioo Tree Preservation - Department # 46102 Personal Services $ Supplies and Materials Purchased Services Other Services and Charges Capital Outlay TolaiTreepteservati&n$< .. ,,'(.,.. , ..."f. Weed Control- Department # 46103 Personal Services $ Supplies and Materials Purchased Services Other Services and Charges ................... TolaJW~d~iUt9~n>$ , .."['.'.... Parks. Department # 45200 Personal Services Supplies and Materials Purchased Services Other Services and Charges Capital Outlay Debt Service Assessments Miscellaneous TotaiPlifj(silf . ..... .. ........ >'.'.<<<<>..('.... ...1.. I 81,961 . 14,529 $ 737 5,081 1,240 803 22(390$) 2,546 $ 3,117 1,394 1,862 8,s1{:1<$ $ 169,604 $ 33,416 20,435 55,578 74,397 43,561 58 527 ...............----_..... ...4.55..5.1. .7 ...$ . < ... ...<1(< $ 16,731 $ 4,092 $ 4,967 551 1,350 1,850 3,598 10,624 10,626 1,729 3,844 5,035 - - - 12,981 19 4,279 2,941 1,082 2j,OOl$i<22;BOS) $lS;90S$>> <22Ji'i8 1,911 $ 1 ,427 598 1,333 5;270 i$> 124,694 $ 41,080 20,632 78,470 35,582 26,564 56 036 ..".381. 058 r $.<'.' 4,600 $ 863 1,045 5,229 11;737$i 196,923 $ 42,704 25,297 73,155 40,818 24,739 57 495 461'1311$} 7,064 $ 3,400 1,830 6,656 1S(9S0$> 274,691 $ 42,400 26,100 93,626 60,000 26,000 63 058 585875$< ..........'T . 8,026 3,450 1,833 6,764 20j072 333,772 49,300 28,702 105,638 63 485 ~Q896 CITY OF ANDOVER 1/4/9912:00 PMSUMMARY.XLS Expenditure Budget Summary - Public Works Budget Year 2000 Actual ~ Sunshine P:lrk . Dpn:ll #41 ~C1!; Supplies and Materials $ 10 $ Purchased Services - Other Services and Charges - Iqmt$ijg~fi!~P~r~$ld$ """"""'!"""""..".. linn. D ! # 4~14n Personal Services $ 22,054 $ Supplies and Materials 2,484 Purchased Services 6,235 Other Services and Charges 22,821 Capital Outlay 1,576 "..I...'.i...'.,.'.....T.........'Pta.......'...../.."..'.".!....'...R.....,......~................".y.....'.<:.!.1./1.....9$55;1't6\$ ".""l""... ".'...'.'.'.'..l' .. .. .... ...... ".'f. ;ml:jf&iiEieUEftlp.;WiBKSlmmill$7;m':11~j$~,:I,$ Actual 1m Actual ~ 955 $ 2,526 $ 28,618 16,362 3,918 2,292 OOQ4~~\~\~~~~1 W\$ 24,543 $ 39,585 $ 1,139 1,118 10,077 3,202 23,005 29,943 3,517 2,925 6'2;~~1;r~76}77SI$ :'.Il!6I[$W47EI;iI::iIi:i665Jiifiij"$ Budget ~ 2,820 $ 16,322 7,300 ..'..I'...I~t~2 ....:..$.'., 53,063 $ 10,050 7,100 24,786 ............................................... ..................9.4...9.9...9.........$. .... ........... --- ..... ............ -.- -,.... ....d.,_..,_ .. , .... ;::::::;::::;:;:;:}::, ,-:'. :~:_, --,' :::::::::< :::: .. ......................r 'r2~!$9;ti~I$ Budget 20QQ 4,020 17,197 10,700 ........-.....-.................. 31;917' 52,630 11,100 7,800 26,834 ........................................ 98;MS} i:"".Ia$6s!oo2. CITY OF ANDOVER 1/4/9912:00 PMSUMMARY.XLS Expenditure Budget Summary - Other Budget Year 2000 Actual ll9!i Actual 1JmZ Actual ~ Bud et ~ Bud et 200ll Other Financial Uses Unallocated $ . Other Uses ..........................%iliJ.~~~..E~~~!!.~Ii~... ........$ 46,510 $ 143,018 $ 647,227 75,264 ........................................ .............................. t)~7az$2MM~!S~ .. .................................................-...-................ ..,..-.-.-............... 45,280 $ 900,249 ....~........................~i.~..........~... 83,800 $ 74,827 35,000 40,000 11~;SOOJir.ljftS2.'7 ..................... ................... ...................... I GENERAL FUND PERSONAL SERVICES 1999 2000 1999 2000 DEPARTMENT BUDGET BUDGET BUDGET BUDGET Mayor/Council $ 76,854 $ 79,056 $ 34,400 $ 34,400 Newsletter 17,000 21,000 City Clerk . 100,508 107,392 68,624 73,545 Elections 3,515 31,720 1,228 19,894 Administration 86,927 89,463 54,803 57,220 Financial Administration 215,006 235,539 161,064 173,163 Auditing 8,600 9,500 Assessing 76,000 78,336 Attorney 107,900 108,120 Planning & Zoning 200,252 215,858 142,758 156,558 Data Processing 66,550 107,075 City Hall Building 67,900 70,539 Firestation Building 53,750 54,800 Equipment Building 16,150 20,806 Public Works Building 246,343 278,358 City Hall Garage 1,875 2,592 Senior Center 12,180 14,433 Engineering 416,570 386,527 296,529 273,122 Police 1,012,092 1,062,430 Fire Protection 669,012 613,448 254,089 259,264 Protective lnsoection 324,694 326,787 221,116 234,171 Civil Defense 12,712 13,632 2,586 2,714 Animal Control 13,325 10, I 05 Streets 985,030 1,194,616 106,191 106,227 Snow/Ice 440,267 476,626 183,280 195,639 Storm 150,486 124,761 37,760 41,158 Street Lighting 36,200 38,400 Street Signs 108,736 116,202 44,290 47,008 Traffic Signals 25,000 30,000 Street Lights- Billed 113,700 134,700 Tree Preservation 19,909 22,478 3,494 3,904 Weed Control 18,950 20,072 5,908 6,394 Parks 585,875 580,896 228,515 277,101 Sunshine Park 26,442 31,917 Recycling 94,999 98,363 42,356 41,619 Unallocated 83,800 74,827 Other Fin. Uses 35,000 40,000 TOTALS $ 6,530,109 $ 6,921,375 $ 1,888,992 $ 2,003,101 City of Andover Budget Comparisons Budget Year 2000 PERSERV.XLS .. Page 1 " ~ >- >E--<: 0""l..J oc."E- ZC;;l ~:;)O ~..J ~~~ 00_ >f'l~ Eo- -<: _ u u 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 c: 0 0 0 c: 0 0 0 c: 0 c: 0 0 0 0 0 0 0 c: 0 0 E- O 0 V'\ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 "" 0 0 "'. 0 O. O. V'\ 0 0 "'. O. 0 V'\ 0 0 0 O. OC 0 '" q 0 O. 0 a '" a M V'\ N a M N a - oc a M M ..0- - M - U - N - - - - - - N M ...:l . < E- o E- fA E- """ c 9 = 0 0 0 0 0 0 0 0 :z: ;z; ;z; ;z; ;z; ;z; ;z; ;z; ;z; - I~ I~ E- ~ <Zl <Zl <Zl <Zl <Zl <Zl <Zl <Zl <Zl <Zl <Zl <Zl <Zl <Zl <Zl <Zl Q U.l U.l U.l U.l U.l U.l U.l U.l U.l U.l U.l U.l U.l U.l U.l U.l ;:;I >- >- >- >- >- >- >- >- >- >- >- >- >- >- >- >- a:i :z: - r.l c=:: <> ...; c <= ;:;I <= 5 .<! J!.l ~ .c:i <> '"" ..:!l 'g <> E- '"" <> - ... OJ) or. - >= <= U.l <= U.l :oj u 0 ~ - <> ~ N ..>: ~ ~ ~ OJ) .0 0 <> Q .: 13 ..c:: ~ ~ - 0 .: u ..:!J .~ <= ~ .~ <= '" :s ..>: -0 ril ~ :z: ..c:: ~ .-' u ~ 0 ~ :oj e;; '" a... .C a... 'C 0 u -0 0 u ~ :r:: @ -0 u r.l '"" E ~ <> <> :r:: <= E U <> .::! '"" ... ~ U -0 <= - ...; <> >( a... ~ '"" <= ~ 0 '"" 0 '"" -0 C :oj <> a... ..c:: ..:s <> -g ... ... 0 .: >( ..c:: ... ""' - ~ - - ~ 8 0 .0 U gf ... 0 c '" <> 0 co <> ... =' 0 <> .0 --- > r.l .C .e- N <> N <> 'C; 0 -0 ~ -0 '"" -, -0 0 --- "& --- '"" ..c:: I;:: "0 <> , <> "0 ~ ... - CI - CI ..c:: ..c:: ~ E 0 0 :;; '0 >- ... -0 0 <> E u <Zl C u 0 ... ..c:: <> u .~ ""' ""' ""' ""' ... - <> '" "0 U > - - :; - ~ <> 0 0 0 0 0 ~ , 0 0 2 ... - - or. C 0 <= '" u >( - '"" a <= ... > E - .C "; <> ..c:: N N C:! C:! <> :oj , .2 0 .0 .C '"" <> 0 ..c:: ;z; ~ u --- --- ;z; "'"' <Zl "'"' N <Zl a... a... .....J N - a... <Zl a... - M - - N <= <= ~ 0 .~ E - - - c c c c c ~ <= <= ~ <= <= E- ob .~ .~ - - <> <> <> <> <> <> <> ~ '" '" E E E .~ E >= E :z: :9 u u :5 :5 .9 """ :r:: co .E <> E ~ .9 .9 .9 .9 .9 ~ ~ :; <= .~ .~ .~ ,~ .~ ::l .~ -0 .~ 0 0-0 ""::l 0- <= <= E- '" <= ob ob u u < < U.l U.l U.l U.l U.l U.l U.l .C 'C c=:: OJ) :oj .~ <> u <= <= :9 :9 , ~ ~ ~ e;; e;; e;; :;; e;; e;; e;; u u < .~ '0 '" ... ... ... ... ... ... ... ... t: ... ... <= <= u u co co U.l '" <> <> <> <> <> <> <> - - - - - - .~ .~ a... <= <> ~ ~ ~ <> - - '" ~ ~ ~ ~ <= <= <= <= <= <= <= r.l .E ..:s ... <> '"" '"" <> <> <> <> <> <> <> <= <= - ... ~ ~ ~ <> <> <> <> u u u u u u u U.l U.l Q U.l a... <Zl a... a... a... f- <Zl <Zl <Zl <Zl <> OJ) :oj a... ~ ~ ;;... >-~< o~~ Qc.:l~ Z~~ <~o i:Q...:l ~~~ 0=_ >-f'lQ., Eo-< < _ u u 0 0 0 0 0 0 0 0 0 0 = 0 0 0 0 0 0 0 0 0 0 = E- O 0 0 0 0 0 0 0 0 0 I.rl rJ1 0 0 0 0 0 0 0 0 0 0 f'l o. q o. o. 0 o. o. 0 N 0 P - N II) II) 0 II) II) 0 N 0 ~ .... - N 0 - '<t II) r- - - '"'" ....J I.rl < ~ E: ~ Gi"l E- ~ Q 0 0 0 0 0 0 Cl:l Z Z Z Z Z Z - ~ z ! u:l u:l u:l u:l u:l ~ ~ ~ ~ ~ >- >- >- >- >- M ~ 'It: '" c::: --- c:: c:: =- CI .8 .~ E- <t: :;:; .;.cl 1> u:l - U U:j '-' -:::l Q "" '" 2 i: <t: E E .;.cl ~ :.a '-' z .... '-' E- .;.cl 0) ........ 0) g 0) u:l 0 ~ :€ '" s 0) 0 c:: '" e -:::l c:: .D '" .... Q., j os. :.a ~ .... t: r.Z u X .:f .~ '-' < r.Z 0 .... ~ CI =- '" cd 0:1 '" 0) c:<l ~ ~ :2 cJ oS 0) ~ .... < c:: ~ 0) u '-' 0) .~ '-' ~ c:: '" ~ ~ '" t;:: u:l u:l c:: fr s c:: 0 0) 0 ..... 0 II) '" 0 =' CI u:l 0 U N M c... ~ U 0:1 ~ E- Z eo "" ~ oS ~ '" ~ gf g g '" c:: 0) .:f E- .;: .;: .;: '-' c::: 0) 0) 0) e 0) u:l < 0) 0) 0) c... '-' '-' c:: c:: c:: c:: t;:: Q., .~ og .g '" .g .~ <:.l <:.l '" ..... ~ - oS '" c:: c:: c:: '" .::: .::: .... Q ~ ~ ~ CI "'"" "'"" "'"" "'"" "'"" E- N <:.l eo '" c... rJ:l Eo- rJ:l "'l ~ c:=:: 01 ~ "'l > ~ OEo-"'l "'l"'l Q~>O ZQO <~..J ~:~ 08"'l ~N..J ... < ~ Z U 0 - Eo- - Q Q < 0 0 0 0 0 0 0 0 0 0 ",. 0 0 0 t3 0 0 0 0 0 C! 0 0 0 0 0 0 0 0 0 0 C! 0 0 0 -.6 -.6 0 0 0 0 0 C! 0\ -.6 -.6 ., V) 0 ~ \0 c: 0 0 V) V) V) 0 0 0 0\ 0\ 0\ t- V) V) ., t- O 00 00 '"'l M M "'". q \0. 00 00 \0 \0 M M .0 \0 V) --0 ci ci --0 --0 . o. 0\ ci ci + r-: .,f' c: - 0 00 V) M 0 - - - - - M M N - - 0 ..J N 0 < ci I~ V) , 0 0 E- O .,.; <A "<t" <A e-. E- ~ CIl CIl CIl CIl CIl CIl CIl ~ ~ ~ ~ 0 0 0 0 0 ~ ~ 0 ~ ~ 0 0 0 0 ~ >< >< >< :z :z :z z z >< >< Z >< >< Z Z Z Z = ~ c. - I~ '" '" '" '" ..c: ..c: ..c: ..c: .... .... ;:: .... c: c: c: 0 0 0 0 r..l S S S s I~ \0 \0 \0 \0 c: ... ... ... ... 0 - <E <E <E <E i!l - - - - g ... ... ... 9- 9- 9- e. g ..c: ..c: -- E E .... E E 0 -- 0 c: V) 0 V) '-' ., "" ., '-' 00 c r-.: ... ... "'0 ... ... <A ...:i r-.: '-' '-' c: '-' '-' u < <A @ E ~ B E E .2 .9 Z @) ~ .... ~ ~ "" c "" ..c: 0 '" '" >< u V) Jf CIl CIl CIl CIl '-' t- CIl ] '-' :::E <A < "'0 0; 0; "9 0; 0; S -. = [;;;l -. c: c: E c c ... t .~ 0 .~ .~ '-' 0 rJ1 ...... 0 S ..;:: '-' '-' .... .... U .... .... u:i :.c :;:; :;:; :;:; :;:; ~ c: U "'0 "'0 c: "'0 "'0 .~ 0 < < .; < < CIl ",. '5 c 0 :::E i!l - - - "'" - - - '-' .D .... .C ..c: .... eo c [;;;l t: 0 = '-' u ::; .!:: U - ~ 0 E- O; '" '" ~ c < c::: .~ ...... .'.:: '-' -< "'0 - C. "'0 ~ < V) OJ '" "" ~ r..l u ., .5 ::; ~ "'. 0 - 0 0; .... E- "9 u ..c: OJ I .2 '" ~ ...:i E ... "" "" - ..J ., ..c: :::E "'0 =- :;: u "3 ., ~ OJ :::E OJ 0 c .!:: :3: - - ~ ~ ;:: .... E- :;: c: c c ., OJ C - ..c: E E Z - - - - ~ r..l "'" "'" 0\ 0\ .9- .8 ::; - - - - ::c .q .~ "'" "'" "'" "'" "'0 E- o , '" '" di: d1 c: ~ ~ c::: c: c: "" OJ 0 .~ .s c: ~ ~ ~ u < .2 ... ... c: c. .... .... c: OJ ~ ~ ~ OJ ., .... .... "" u u c: c: ~ ~ :;: c: c: CIl OJ OJ .~ r..l OJ ., ..::= "" '-' '-' - c: .!:: ... .... "" "" "" :3: '-' ~ ~ Q u:i u:i c. 0: CIl c. c. c. CIl U U 0 ~ ~ OJ eo "" C. , GENERAL FUND PERSONAL SERVICES 1999 2000 1999 2000 DEPARTMENT BUDGET BUDGET BUDGET BUDGET Mavor/Council S 76,854 S 79,056 S 34,400 $ 34,400 Newsletter 17,000 21,000 City Clerk 100,508 107,392 68,624 73,545 Elections 3,515 31,720 1,228 19,894 Administration 86,927 89,463 54,803 57,220 Financial Administration 215,006 235,539 161,064 173,163 Auditing 8,600 9,500 Assessing 76,000 78,336 Attornev 107,900 108,120 Planning & Zoning 200,252 215,858 142,758 156,558 Data Processing 66,550 107,075 City Hall Building 67,900 70,539 Firestation Building 53,750 54,800 Eauioment Building 16,150 20,806 Public Works Building 246,343 278,358 City Hall Garage 1,875 2,592 Senior Center 12,180 14,433 Engineering 416,570 386,527 296,529 273,122 Police 1,012,092 1,062,430 Fire Protection 669,012 613,448 254,089 259,264 Protective Insnection 324,694 326,787 221,116 234,171 Civil Defense 12,712 13,632 2,586 2,714 Animal Control 13,325 10,105 Streets 985,030 1,194,616 106,191 106,227 Snow/Ice 440,267 476,626 183,280 195,639 Storm 150,486 124,761 37,760 41,158 Street Lighting 36,200 38,400 Street Signs 108,736 116,202 44,290 47,008 Traffic Signals 25,000 30,000 Street L ights- Billed 113,700 134,700 Tree Preservation 19,909 22,478 3,494 3,904 Weed Control 18,950 20,072 5,908 6,394 Parks 585,875 580,896 228,515 277,101 Sunshine Park 26,442 31,917 Recycling 94,999 98,363 42,356 41,619 Unallocated 83,800 74,827 Other Fin. Uses 35,000 40,000 TOTALS $ 6,530,109 $ 6,921,375 $ 1,888,992 $ 2,003,101 City of Andover Budget Comparisons Budget Year 2000 PERSERV.XLS Page 1 " ~ >- ~E-<: O~....J QoE- ZQ=- <=-0 =:l....J ~Q<: 05~ ;>OMp.. E-o <: _ u u 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 c: 0 c: 0 0 0 0 0 c: 0 0 0 0 0 0 0 0 0 0 E- O 0 or) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 0 0 N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O. \0 0 O. 0 or) 0 0 \0. 0 0 or) 0 o. 0 0 OC 0 \0 O. 0 0 0 0- -.c o' <'1 vi' N' 0- <'1 N o' - OC 0- <'1 <'1 -.c <'1 - U - N - - - - - N <'1 """ -< E- O E- <A E- W ~ 19 I; 0 0 0 0 0 0 0 0 I~ z z z z z z z Z I~ I~ E- ~ en en en en en en en en en en en en en en en en Q ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ =- >- >- >- >- >- >- >- >- >- >- >- >- >- >- >- >- Q:I Z - w a: Q - =- c c C Q .ct .'!l ~ .ct Q '" ..:!l .~ E- '" OJ g - .... ~ '" - := c ~ c ~ b1; OJ 0 e - OJ c N .;.: ~ e g -. 0 Q Q c Q ..c u u - .D ~ - ~ 0 ~ z :.a E .:: u .!!l 0: c :g 0: '" S :::. "'" u -- 0 ci'i o:l ~ '" 'C: 'C: 0 u ~ ;l: 0 w u ;>. :r: E 5- u OJ :r: u u ~ .~ '" u -- - '" ;l: c c u .... u Q. '" C ~ ~ ~ ...: E u >( o:l ~ <U ::'i: 0.. ~ .E! .9 .8 .9 -::l .... .... .:: ~ ..c ..c .... ..... ;l: ;l: u -g 0 0 .D - .5 .... 0 c '" Q 0 co Q .... .... ::> 0 Q .D -- > Q W o:l ....., 'C: :s! .~ 0 N <U g. N Q .;; '" ..c 0 -::l ;l: -::l Q Q ~ .... -- 0 -- 0 ..c ~ E !;: 0 "0 ~ , 0 .~ - E - ..c .... ~ - >- .... ~ 0 u ..... ..... ..... ..... u en c u .9 Q ;; 0 u :; E Q 0 0 0 0 0 , 0 .... 0 .... E 0; t) > - E ;l: ;l: 0 o:l - '" 0 - u >( - - ....: .... > s - 'C: .;; Q o:l ..c N N N C:! Q '" .2 0 .D C .C: '" Q 0 ..c ;::: -- -- -- , - 0.. en 0.. Z U - - <'1 - - z U- en U- N N en 0.. 0.. ...J N . ~ C '" ::5 .s: ;>. o:l E g - - E E E - - ;l: C C C C C c E- ~ .g .s: - <U <U Q Q Q U OJ ..c '" .~ E E E E E E := Z E -::l t) :5 ~ .9 w u .9 .9- .9 .9 .9 .8 ~ :r: co ~ ,g E .~ .~ .~ ::> .~ ::> .~ .~ ~ gj -::l .9- 0 0 -::l -5 0"' 0"' E- '" ~ c ~ E u u -< -< ~ ~ ~ ~ ~ ~ ~ 'C: 'C a: '" .~ OJ <U C C ~ ::::! ~ , , ~ ~ ~ ~ ~ ~ ~ :; U <U -< .s: '" .... .... .... .... .... c c .c - co co ~ '" <U OJ OJ OJ .... .... b .... .... .... .... u OJ .8 .8 OJ E E E - E <= .en .g Q. c OJ ~ ;l: ;l: ;l: ;l: c c u ;::: ;::: ;::: e o:l '" W ~ o:l b ;::: ;::: ;::: U Q U OJ <U Q <U <U <U OJ OJ C c Q ~ Q. en 0.. 0.. Q. E- en en en en U U U U U U U ~ ~ Q ~ o:l 0.. ~ ~ >- ~Eo-<< o~~ Q~~ Zc:lo <~...:l ~=:l< ogEo-< c..... ;;"N~ E-o -< _ U U 0 0 0 0 0 0 0 0 0 0 C 0 0 0 0 0 '=l 0 0 '=l '=l ~ I~ ci ci ci ci ci 0 ci ci 0 0 \Ij 0 0 0 0 0 0 0 0 0 0 N O. 0 O. 0 0 O. 0 O. C'l. q ~ 18 - N on on 0 on on" 0 C'l 0 - C'l 0 - '<t on t- - - """ ...J \Ij < E- o E- .... Gf'l E- ~ ~ ;; 0 0 0 0 0 Q:I Z Z Z Z Z Z - S:: z ! <Zl <Zl <Zl <Zl <Zl >I.l >I.l >I.l >I.l >I.l >- >- >- >- >- r'1 [;oJ 'It -;; cz:: --- s::: s::: :;J Cl .9 .:!l E- -< ~ ~ G <Zl - U or. ciS u 1: -0 '" 2 Q -< ~ ~ ~ ~ :.a <l) z .... s::: ~ u E- ~ <l) ....... <l) ~ g <l) <Zl 0 [;oJ .t:l '" a <l) 0 s::: or. .... 0 "E .s .0 '" .... i:l. :~ .9- .... e <E u X eJ) ~ -< <; <E :3 .~ u 0 .... o(! [;oJ Cl :;S (1l cq g;n <l) ...:l >I.l :2 u ~ -< ~ .... s::: J u ~ u 0) .~ Q ~ 'a :;S Eo-< u ~ '" ~ <Zl <Zl s::: ~ a s::: 0 Q 0 ..... 0 on '" <l) 0 ;:l Cl <Zl 0 U C'l r'1 E:: e::: u (1l Eo-< E- eJ) Z '" [;oJ .5 -;; ::; .s ~ .SO or. s::: or. . .5 Q .:!l E- u .... .... .... 0 <Zl cz:: Q <l) Q .... Q -< Q <l) Q a... u u s::: s::: s::: s::: ~ i:l. 'g "g 'en :;S 2 Q Q .~ '" ..... [;oJ ~ .::: .::: .5 '" s::: s::: s::: .... Q >I.l >I.l >I.l Cl "'" "'" "'" "'" "'" f- C'l <l) eJ) '" a... tI:l Eo-< tI:l ~ ~ " 0- ~ ~ >Eo-<~ o~~ Qe".... ZQO <~~ ~=e:: OQ~ Q~ ;>t~~ Eo-< <: _ z U 0 - Eo-< - Q Q <: 0 0 0 0 Q 0 0 o. 0 0 e--. 0 0 0 l..g 0 0 0 0 0 0 0 0 0 0 0 0 0 c: c: 0 0 0 ;.. d d -0 -0 -0 d d d d d 0 -0 llJ or; d 0\ '-0 c: 0 0 V) V) V) 0 0 0 0\ 0\ 0\ l- V) V) llJ I- 0 00 00 M M M ""'". 0 '-0. 00 00 '-0 '-0 M M .0 '-0 V) vS - <0 0 o' 00 ori' M vS -6 0 0\ 0 o' + r-: ..,f - - - - M M ("of - - 0 - 0 I"'; N 0 < <0 I~ V) , 0 'E: 0 0 ori' ~ ""'" ~ e- Eo-< r? en en en en en en en Q ~ ~ ~ 0 0 0 0 0 ~ ~ 0 ~ ~ 0 0 0 0 ; >- >- >- Z Z Z Z Z >- >- Z >- >- Z Z Z Z = I~ Q.. - I~ '" '" '" '" ...c:: ...c:: ...c:: ...c:: ~ E - - - c: c: c: 0 0 0 0 ro.l 8 8 8 8 I~ '-0 '-0 \0 \0 c: .... .... .... .... 0 - oS oS oS oS ~ - - - - g .... .... .... e e- El: e- g .e .e 0 E E - E E 0 0 V) llJ c:.> c: llJ c:.> V) 0 '" 00 r--: .... .... "'0 .... .... I r--: c:.> c:.> c: c:.> c:.> '-' ~ @: ~ E E E '2 I@ ~ B B E '(; ~ E '" 0 ...c:: '" ;::l ;::l '-' V) '" ~ ><: }l: <Zl <Zl c:.> <Zl <Zl llJ I- "'0 ca ca "9 ca ca ::E ~ -. ;::l E ~ -. c: c: E c:: c:: .... .g .g .S! 0 c:.> 0 '-' ...... 0 .;: 8 ~ llJ c:.> U - ~ :.a :a :a c: :a :a ~ c: U "'0 "'0 "'0 "'0 .S! 0 ...:: ...:: 'C; ...:: ...:: <Zl e--. - 0 0 ::E ~ ;::l - - - ""'" - - - c:.> :9 - I ...c:: ... ~ E ro.l 0 llJ '-' :; .:: u - .... 0 Eo-< ca '" ~ '" c: ...:: c:l:: :~ ...... ...:: llJ "'0 - Q.. "'0 ~ ...:: V) llJ '" '" ~ ro.l c:.> c:.> .5 :; ~ e--. 0 - ca - Eo-< ::: '-' ..c:: llJ I '2 ...J ::: '" ~ ~ ...J C3 ...c:: '" ~ ;;: '-' ::E "'0 c:.> :; .... c:.> ::E llJ 0 c:: .:: ~ - - .... . ;; '" E - Eo-< ;;: c: 0 0 0 - ...c:: (l) (l) Z - - - - ~ 8 E ro.l ""'" ""'" 0\ 0\ .9 .9 :; - - - - ::r: ""'" ""'" ""'" ""'" "'0 .~ .~ Eo-< , , ~ ~ c: '" '" ~ ~ c:l:: c: c: '" llJ < .S! 0 c: c:: '" ca ca '-' '2 '2 .... .... - ~ :r. ~ llJ (l) l:: .... c:: Q.. t) t) c:.> - c: c: ~ -'" - ;;: c: c: <Zl '" c:.> ~ .~ ro.l ..!:! (l) '" '" .... '" (l) (l) - c: .:: ~ 0:: '" '" '" ~ c:.> ~ ~ Q ~ 0:: <Zl c.. c.. c.. <Zl U U 0 .... .... c:.> eJ) '" c.. '* -.,' .. .. '. ." . ~'~ . ,-. -, ,".~ . . CITY OF ANDOVER -. EMPLOYEES 2000 BUDGET 1/4/9911:20AMMAYOR.XlS' - - ' :~~~~~:;~~:~:~::~~:~t:::::/t:{::~::???~::tt:::::~::.;.:-:.;.:;:;";":;:;:::;:;:;:;:;:::;:;;;;:;:;:;:;::}}::;:;:;:::::';:;\::;::;:;:......;.:.;:;::-;.;.;.;.;.;.:. .::::::::::.:::;:;:::::::::::::::::::::":::::::;:;:;:::;:::;:::::...:.:..,...;.;.;. ;.;.:.:.:.:;:;;:;:;:::;:;:;:;:;:;:;:;:;:::;:;;:;;:;::;:::;:::':':';".:.;.;.; ;.:.;.;.:.;.:.;-;.:.>:-::.:-:.;.;:;:;;::;:;;;:;:;::;::;:;:::;:::::;:;:::::::;:::;;;:;:;:;:;::::::::::::;::::;:;:;:;::;;:;:;.:....., ." '.~:.~:.' :.;.:.};:;:::;:;:;:;:::::::::;:::;:;:;:;:;:;:;:::;:::;::;;:;:;::.:.:-:.:.-.:.:: "."'."'.'.'.'.."'.'.~:.N. ft.".."'"".",.,. ,.",.".".".",.,.'.'..'.'..nS""A. ..rt.""'*'ltE..,tT""",., .."'."'.""'''''''''''.''iSl\ll..S'.'.~J''''''...'''''. ~j~~~j:j~j]l\jil;j1:;~ijl~;:ffig::;;;;;:;f{jmj~~::\~1i;\ii~~ii~j:j~;j :il~jili:;~ij[~iji:\j:~~ji:~~jl~\;:l~g::::::::5;;:;;;.:;;g;:~::f9~;:;:;:;;~~]:~::~\j;~iji:~ ~:~:~:~):~)):}~::u :~:: . - 'IUI,::~:}~/::::: r.@.GENbFf:AE.,Ii.....:...."..,.:..~Y'0R1~~~....!~i.M~11 :;:::;:;;::::~:}~:::;:::;:::;:::::::::::::::r::::::::;:: .t~~~::~~:~~~~:{tt:~~)~: :~~{~rtt~t{t:t~t:~ttt{t~~~~:~:~~ ~;;;;~~~;~;~;~;~:~;~;~:~;~:~;~;:~~;~;~;~;; ........ _. .:::::::::;:::::;:::~::;:::;:::;~;;:;;:::;::::~::;:::;:::::' :}~;}~:;:::~;::;;:}~;~::::::: ...... :;::;:::;;;:;:;;~ ~:::~:::~ :;;::::;:::::;:::;::~:::~:::~::::;:::;;:;:::'W'.'."" :;;;:;::::;:~::::::::::::;~:;;::::::;::; :~;::::::: :.:.:.:~. .:.;.:.:. ::;};::;::::~:::~;}::~;}{:;:{::::;:;;::: .............,................ .................... ................... ........-........... ..................... ...................... ;.:.:.:..:.:.;.:.:.;.:.....;.;.:..:.:.;.:-: ...............-... .................... ................... ..................... ................... ......................................... ..................... ..................... ...................... .................... ....................-. ................... '................... ................... ..................... ............... ..--.....-................... ..,,-............. ::~;::?~?~:r:::::::::::::: :.:.:.:.;...:.;.:.:...;.......:.:.:.:.:.: ..................... ...................... ..... ............. ....-............... .........-.......... ::::::::::::;::::;:::;;:::;.:-::;.:.:.:.' ................... ....................' ...............-. ........,.......... ...................................-. ...-............... .................... ...................-........,........ .:.:..;.:.;.:.:.:.:.:.:.:.:.;.:.:-:.;.::. ..-.................. ........... ..... ................... ...............'...................-_. ....-................................. .................................... ...:-........... :/:\:~::mt~:~~t::~~:t::t~.~::f~~~ ............................. ..... ~:::::: :~?;;:;:;::;::::::::::~:::;~::::::::~/.::: 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Mavor 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 . ~ \. . ,--. .. . CITY OF ANDOVER Expenditure Budget WorkshE!et Budget Year 2000 'P .,. "... _.........', 1/4/9911 :21 AMWMAYOR.XLS . . .... ~.. --, . - ,. . .. - ~. MA YOR AND COUNCIL DEPARTMENT # 41110 General Fund Obiect ~ Actual ~ Actual 1m Actual 1m Budget ~ Personal Services 106 121 122 125 Salaries PERA FICA Medicare ...su6HHalY.. $ $ 18,600 $ - $ 18,600 $ - $ 18,600 $ - $ 34,400 $ - $ ...$ 1,154 270 <20,024 /$ 1,154 270 ......-.--'....'...-...'.. <20,024 1,154 270 $< ..20;024/$ 2,133 499 37;032 Reauest 2Q.QQ 34,400 749 2,133 499 .. $37;780 1~lInnli~!': ~nrl M",.ori:tl!': 201 General Office Supplies $ 201 $ 717 $ 92 $ 350 $ 350 210 Operating Supplies - 59 117 50 50 hi .,< ,: .,...,. ,,.. Purchased Services 301 Professional Services $ 5,820 $ 5,650 $ 5,51 9 $ 6,000 $ 6,000 330 Transportation 4 - 3 200 200 351 Printing 23 - - - - 360 Insurance 9 500 9 800 9 800 9 800 1 0 094 .. . SUbtotal . '.<.,<$'< ..45,348 $ 15;450/ $< ...15,321 <$ .18;000 /$ 1(:)(294 Other Services and Charges 433 Dues/Registrations 435 Subscriptions 441 LMC Dues 442 Meals/Lodging 443 Continuing Education .-:::::::>}::}}/>>>> SUbiotal>::::?:':':- ....'... I ~~m9!~Fr 12,306 120 11,231 500 425 .22\834$23,422/,$24\582 .......1.. .......1.. . ... /5ti~ti$7$;~......~'t9~656... $ 7,751 $ 9,580 $ 11,194 $ 12,106 $ - - - 120 9,710 10,160 11,304 10,696 - 75 337 500 - - - - <$ 17;461...//$19;816/$ .:::[;.. I... .. ... "....rIII.~ ....t......SS,Q34US.aeides.l$ ~ . '~.. ,. # " 'CITY OF ANDOVER, ,,', ." . ..1/4/9911 :22 AMCLERK.XLS EMPLOYEES 2000 BUDGET 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services City Clerk 0.974 $ 46,008 0.974 $ 48,478 Receotionist 1.000 , 22,616 1.000 25,067 Total 1.974 $ 68,624 1.974 $ 73,545 .. 1/4/9911 :22 AMWCLERK.XLS .. .".,. -..- CITY OF ANDOVER Expenditure Budget Worksheet Budget Year 2000 CITY CLERK DEPARTMENT # Object ~ Actual ~ Personal Services $ 60,507 $ 2,606 3,516 823 3,679 252 39 71;424 /$\ 101 Salaries 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Dentallnsurance 133 Life Insurance $tl~j9taf>$ Supplies and Materials 201 210 I.': , General Office Supplies Operating Supplies '.'..'.'.'.'...'.-':',.:\.> :.:::: .,..",." $ 464 $ .... ... ... . . Purchased Services 322 Postage 330 Transportation 351 Publishing 360 Insurance $tl~tojalt .. $ 48 $ 238 43 14 700 :>151930 $... Other Services and Charaes 406 Contractual Services 415 Equipment Services 433 Dues/Registrations 442..... .Me~lsI~o9gi~g . .....----..-..-.--.-. SU.btQtal):(": r :~j1gmQ~~I $ 867 254 $\ 1,t21 >$ ,..... :-.-.--II.${ ...:.......{B$;(la9..!J:I.:. 41400 General Fund Actual ~ 59,801 $ 2,734 3,629 879 3,675 255 16 70(989 $: 1,478 $ 5 - . (21) $ 176 184 14 700 >$15,039 /$ $ 467 201 B68$/ :.:.:aa;1~!$..--': . ..~. . --...... Actual ~ Budget Request ~ I 2QQQ 63,999 $ 3,329 3,802 889 4,020 307 16 76;363$/ 654 $ 226 ..... - .,.:~,:,. - $ 120 68 15435 t5~B23 $ 1 ,488 $ 298 378 '2d64/$ .S$~Q3.iI~$.:: 68,624 $ 3,555 4,255 995 4.500 245 97 82:271$/ 480 $ 50 $ 300 50 16 207 $16,607$ 73,545 3,810 4,560 1,066 4,500 497 327 Ba;305 500 25 .<ll . 50 300 50 16 693 >17,093. $ 330 384 520 . 1,035 300 50 1;150$1,4-69 :':1mj5Oal$JQ7~m .. . , Obiect C22.e. NEWSLETTER Purchased Services 322 Postage 3~2.. ....~rirltinQ....... ......... ........ ... i.SubtolaJ CITY OF ANDOVER ~ Expenditure Budget Worksheet-".. Budget Year 1999 DEPARTMENT # 41140 1/4/9911 :23 AMWNEWS.XLS ".- ,. .-..... " General Fund Actual ~ Actual ~ Actual ~ Budaet 1m Reauest ~ 32 $ (13) $ - $ - $ 6,000 1~4if($~i~ij~I$~;~~i~~t;~I~~~i~~g .:.E.5~Wl7,1$:::mi:6iwll:$:;:;-[t~;~$"a7;b(lij!.:~'$f;:2j;QijQ, . "..; .~ ,,"""- . . .....' -. . ~ -. . .. 'CITY OF ANDOVER . EMPLOYEES 2000 BUDGET -.:,.- -.. 1/4/9911 :23AMELECTION.XLS . .., . 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 Judnes 0.000 - 110.000 18,600 Total 0.026 $ 1,228 110.026 $ 19,894 CITY OF ANDOVER Expenditure Budget Wor.ksheet. Budget Year 2000 , . ELECTIONS DEPARTMENT # Object ~ Actual ~ Personal Services 101 Salaries - Regular Employees $ 103 Salaries - Election Judges 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Dentallnsurance 133 Life Insurance .................................................................'.--",'" .,.......-....................-.-,. $Q~~9!~li$ 1,323 $ 11 ,370 59 782 183 123 8 o ........--........ jei~$i Supplies and Materials 201 General Office Supplies 210 up"""'''''\'! Q~" ..ii ..W,'}>} $ 118 $ 85 . . '. .:;:-. . .. .' .~ . .... .. ~l .... . .... [ I Purchased Services 301 Professional Services 321 Teleohone 322 Postage 330 Transportation 352 Printing 410 Rentals li:.ii' ..:,.,"'.,........,..... ;:ii'" I>' . ,..t....> > $ 537 $ 16 Actual ~ 1,088 $ 50 65 15 98 7 o ........,.,................-,... ..........23...... ....-. . ," .' ........ - . ,. ........ -- - .. .......,.,..,J.,3...,:} - $ . '. . 210 $ 26 1/4/9911 :23 AMWELECT.XLS . . ...,:,........ .. 41410 General Fund Actual ~ Budget 1.9W 1,177 $ 10,424 61 68 16 107 7 1 $lit860 1,228 $ $i 64 76 18 120 7 3 ...........'....--........ 1;51$ - $ 1~ - I $ .. ... . 1,072 $ 23 - $ 45 - 26 124 - 104 860 915 -SO ::"'..i........ ",,-.= - ..':.) :. :llii'.i.583 $:)'1',.101> $.1Qh", . Capital Outlay 580 Equipment I. . '.' '. Ci;tht~ .... . . .'. : I. ..... . ,':'~~'~ .' '.. .... $ ... - $ : -' ..... - $ ..,. Request 2QOO. 1,294 18,600 67 80 19 120 7 3 $ii6i196 100 150 ~., 1,100 50 130 .. J~ '. - $ 1.280 - $ 2,000 $ 1 n nnn .... :- . I.........IIIiaHifid'.m. Ct."". .a.I..... ...................--..........--....---.... .... ............................-...'.. .. .IIi:..i.....mtI.i.$...( .....?15~tla5il.$ .....II Z'474........$) ....i13ta.11.l.r$.m..I31$j5...I$,,?3j.~72Q... . - " . - . '-CITY OF ANDOVER- EMPLOYEES 2000 BUDGET .. . , - 1/4/9911:25 AMADMIN.XLS ..' .................-.-. .... :;:;;;:;:::::::::::;::=;::::=:=;=:;::;::{::::::;::::::::: :,:,:,:,:,:~,:,:,:,:,:,:,:,:,:,:,:,,';-:':':"':':':':':.; .:.:.:.;.;.;.:.;.:.;.;.;.;.;.;.......:.;..........;.....;. ................,.'...~,Ii<tri...,.............. ;::::::::::::::::::::;::::::::r::.:UI:~l~i,::::::::(:::::::::;:;: .E..I..! .:.:.:.:':.::~:-:.:<.:.:. ..........:..,:.:.;-:.;.:.:.:.;.;-::.:.;.;.;.;.;-:: :.:.: ~:::t~f;t:\f}}: :::::::::::::::::::;:~: .'........QerrA:O.E. ..Ql............... .........................................,........ 'iD..M'.'.:.'...~b.I..~+ai~Ii.G.........g:im.;gb\.~E;;i~m.m .M '. 11:'1 :O::I::nM.:I~:~'::::::::;::;::-." CR..:::UV:v.::C:n:J:~:::::::::: .........................--....' .IIBII:., ..' ii~ft~14~~I~~1 .. .... .................. ..."............. ................... ................. ;:;:;::;:;:;=;::::;:::::::::;:::;;:. :,;",:::::':':-:';':':':::' .;.:.:.:.:.:.:.:.:.:.:.:.:.' ;~.;.;-;.;.:.;......." ::;::::~;:;;;:::; :';':':-;':-:':':':'. ;;:::::~::::::::~:: ~:::::::::~::;:;;:: .........-......................... ................... ................... .. ;;::;~::::.:~;::;::;:;:::::::::;;:;; ................ ~... .. ......;...... .. ........ .................:.:.:.;.:.;.:.:.:.....;.: ................ ................. ............................... :.:.:.; ;;:;~::;;. ................................ 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Administrator 0.300 $ 22,795 0.300 $ 24,690 Finance Director 0.100 6,606 0.100 7,135 Accountant I 0.150 4.981 0.150 5,393 . Finance Intern 0.000 - 0.100 - Secretary 0.670 20,421 0.600 20,003 Total 1.220 $ 54,803 1.250 $ 57,220 - . Obiect ~ 201 210 220 CITY OF ANDOVER 1/4/9911 :25 AMWADMIN.XLS .' Expenditure Budget Worksheet - , . Budget Year 2000 ADMINISTRATION DEPARTMENT # Actual ~ Personal Services $ 48,270 $ 2,131 2,859 669 3,257 283 (~) 57;4?7 $ .........................-.......... .i.$ Supplies and Materials General Office Supolies Operating Supplies Repair/Maint. - Supplies "$u6iotal/ '. $ 2,060 $ 179 360 "/$<2,598>$< Purchased Services 41430 IGeneral Fund -: Actual ~ 57,227 $ 2,417 3,597 849 3,627 332 22 /6~i~?~$ 2,931 $ 2 297 ...3,229 $ Actual ~ 51,594 $ 2,647 3,213 768 3,531 302 20 ~2;07e<$ 1,623 $ 125 298 2,l)4S} $>< Budget 1.9W 54,803 $ 2,839 3,398 795 4,698 307 122 ~;9S2!1; 2,000 $ 150 350 "2,500>$ Reauest ~ 57,220 2,964 3,548 830 4,946 290 127 i~;~24 2,000 150 350 2;500 301 Professional Services 321 Telephone 322 Postage 330 Transportation 351 Publishing 360 Insurance "'Subtotal}' $ 5 $ 21 0 $ - $ 1 75 $ 1 75 469 603 51 7 600 600 544 784 706 81 0 800 1 ,524 1 ,553 2,01 1 1 ,81 1 2,000 1 6 44 76 1 00 1 00 8 300 9 000 9 450 9 923 1 0 220 'i$ 10,857 }$ 12;193 $/< >12,760 $ 13)4019 $< "13;895 101 Salaries 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Dentallnsurance 133 Life Insurance ,$q~!P~ Other Services and Charaes 401 415 416 433 442 443 Repair/Maint. - Labor Equipment Services Computer Services Dues/Registrations Meals/Lodging C~nt,i,~,uI~~~?ucatioD . 'SlIbtota!< . $ 165 $ 500 57 $ 754 255 1,883 294 75 <a(318} $>> 59 $ 745 1,348 1,277 1 109 "4\538/$ 150 $ 840 790 1 ,452 815 iA,d41i$> 150 960 510 1,015 510 {kl4S .......:'lQfmNP1jt21ftlg:}$ '74:946:' $~j2$'ain420 $miai;'9Z7;$'m$jl~ 2,963 396 ...... .$ 4,023$ CITY OF ANDOVER EMPLOYEES 1999 BUDGET 1/4/9911 :25 AMFINANCE.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES , # OF EMPLOYEES WAGES Personal Services Rnance Director 0.450 $ 29,727 0.450 $ 32,107 Treasurer 0.850 44,393 0.850 46,109 Accountina Clerks III 1.550 53,931 1.670 60,673 Accountino Clerk I 0.500 11,701 0.420 11,166 Secretarv 0.100 3,048 0.100 3,334 Accountant I 0.550 18,264 0.550 19,774 Finance Intern 0.000 - 0.400 - Total 4.000 $ 161,064 4.440 $ 173,163 Obiect ~ CITY OF ANDOVER 1/4/9911 :25 AMWFINANCE.XLS Expenditure Budget Worksheet Budget Year 2000 FINANCIAL ADMIN. Personal Services 101 Salaries $ 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Dental Insurance 133 Life Insurance ~~~Ri,1~~1~f1ij10~. 201 210 in 301 322 330 351 360 I Supplies and Materials General Office Supplies $ Operating Supplies ,', c,', ..."..i,""',,, i' ",'," Purchased Services Professional Services Postage Transportation Publishina Insurance 'sobtot~f ",','" , " '$ ,..\' , , Other Services and Charges 401 Repair/Maint. - Labor 406 Contractual Services 415 Equipment Services 416 Computer Services 433 Dues/Reaistrations 442 Meals/Lodaing 443 Continuing Education \':',"","""",'" ':'" ':<< :.,:':,:'::< Capital Outlay DEPARTMENT # Actual ~ 117,071 $ 5,069 6,828 1,597 9,446 763 52 225 I~~~;~~!$ 2,097 $ $ 1,891 $ 511 629 1,366 105 4'501. 41530 General Fund Actual ~ 132,756 $ 6,050 8,137 1,903 11 ,230 919 63 225 II~~~\!~$I 3,441 $ 24 ',' 1,500 $ 640 619 813 $ '3;572 $ '. 57U i Ut1lce equipment $ - $ ,'Subtotal,:""'" ""$/" "">$ """"""'1""""" '.."".'\"" '" ,,(, ::j:ij.'jj:~':::::.NI\t9].:.'i:':j:'i:,I:j$'11m1111471;:1:'1 85~ $ """'853,$>" """1' 1;f6~176!i$ Actual ~ 134,476 6,984 7,995 1,898 11 ,572 857 58 225 1&J,;965 Budget 1m $ 161,064 $ 8,343 9,986 2,335 15,426 882 350 275 ~I 19S:;662H~ 2,317 $ 3,442 $ 659 300 ~'" 2,023 $ 595 670 895 115 <4;29S$i 2,000 $ 750 650 1 ,400 121 4;921$ Reauest ZQQQ 173,163 8,970 10,736 2,511 17,318 1,018 444 .....-...-_......... 21~;160 3,650 700 ".. 2,500 750 750 1 ,400 127 <5;527 , 348 $ 151 $ 54 $ 300 $ 300 - - - 200 200 1,200 1 ,810 1 ,791 1,982 2,303 - 1 ,955 - - - 2,156 1 ,144 923 500 805 395 605 363 600 800 - 1 337 1 208 2 600 4 895 '" ti'r.ihii </ ""',' $ - $ 1 ,500 $ 2,200 '" """"'H/$",l;500$<2(200' ".."''('" '..."( :';17Sli7ii~j$1'Z1$.",I::'$;::~1i CITY OF ANDOVER 1/4/9911 :26 AMWAUDIT.XLS Expenditure Budget Worksheet . Budget Year 2000 AUDITING DEPARTMENT # 41540 General Fund Object C22.e. Actual ~ Actual 1m: Actual ~ Budaet 1.9W Reauest ~ Other Uses 301 Professional Services $ 9,425 $ 7,468 $ 7,420 $ 8,600 $ 9,500 . ........ ...... ................................... .........................,..........,........... .......... ......................... SubtO:l~ni$9;425$i 7;468i$i 7,4.-20 $atooo. $'9\500 ,",,',',',', """':"""l"""""""""" """"""""""""""""'(".. ,',,',,', "',..,""""r"".""" "'[""'" "l"r' :,!il~jil:iii:::j:.::'I:IIII.imlll~i:,::::i:.,::l;::,:::l::i~::":':l:;~~:~:~::::::l'::::~.:::;l:~::.:,::l:.:l.I::'l.~~.:\~:I~:I'I:l::l'R:!~:,~::::::::::::::~i~:! : ....~ ....-, <. :.---.. a~ 0' , _,' i . _, ." _ _~., . CITY OF ANDOVER 1/4/9911:27 AMWASSESS.XLS '. , _. _ - Expenditure BudgetWorksheet.,~ , ,,""'.. _"".., ...., ',. Budget Year 2000 >- " - ~ :.., ASSESSING DEPARTMENT # , ! 41550 General Fund Object C22.e. Actual ~ Actual ~ Actual ~ Other Uses 301 Professional Services $ 69,79924 $ 68,914 $ 75,197 $ j~Pbtotall~691799ili24$68!9i4$~5j19?r$ '''''''':"'''''.l:i:r~E!g'.ie!";..,,.,::::;.I~t~~1~44!'' $, 68~914 1. $' 75~1Q7".1 $ Budget 1.9W Reauest 2QOO 76,000 $ 78,336 76!~r$Y7g;336 """""."""""""",."",.1.""""""",."""""""""""""""""""" ,m,OOf)I.$'ttt~~. .' ".~..... CITY OF ANDOVER ". ,Expendi.ture.Budget Work~h.e,et .' Budget Year 2000 1/4/9911 :27 AMWATTORNYXLS ., _.~ . . .... .". . _. _.. ._....r~ ,"L!' ~ .,~...;, ..~_...~,~."..'J' ATTORNEY , OBJECT # 304 General Fund Object C22.e. Actual ~ Actual ~ Actual ~ Budget 1.9W Request ~ Other Uses 41610 Attorney - General $ 922 $ 5,027 $ 4,570 $ 5,000 $ 41611 Attorney - Planning & Zoning 837 2,488 281 5,000 41612 Attorney - Prosecutions 81,630 78,334 81,361 84,000 41613 Attorney - Meetings 13,092 11,012 8,719 12,000 41614 Attorney - Ordinance Enforce. 2,925 1,066 3,312 1,500 41615 Attorney - Fire Department - - - 400 $.il,~totai '/$99,407/$\971926 ,$/ i98@42>$101;9QO($108;120 ..'"]", ,,' ' , '....(..'1'.. """"1.. ".., ..'"]""" '..""'"]'.." .~ 5,600 1,000 86,520 12,000 3,000 I . '.- '.~. ' ~ I -." . , CITY OFANDOVER 1/4/9911:29 AMWDATAPRO.XLS ...', . .>_....~. ...Expenditure Budget Worksheet....., ,., "". ._,', .,.. . . , Budget Year 2000 DATA PROCESSING Obiect C22.e. ISuoolies "Off M"t"rials 201 207 220 301 322 330 401 418 433 General Office Suoolies Training Repair/Maint. - Supplies Professional Services Postaoe Transoortation Reoair/Maint.-Labor Maintenance Contracts Dues/Reaistrations Technology Upgrades Suhto1i11) Capital Outlay 570 Office Equipment 580 Equipment " ..",.. -' ; ',,' , ,'.',.'"'..,,,,<SL, DEPARTMENT # I 41920 General Fund I I .-.- ....~" -... Request 2000 9,500 1,000 300 45,000 300 175 200 10,300 300 25 000 $ 27;437 $ i 38;894 $, 42;608 $ ", 66,550 \,$ > > 92;()75 I $ 15,000 I Actual ~ $ 7,290 $ 105 - 19,316 209 21 198 - 298 - Actual ~ Actual ~ Budget 1999 ! ...',.'~~~~9mq!!~;I.....,','."'.'.,,'.,..'..""..'.'."".. .....$.}'.}...... '.21~43i.,.. $',..t.;t3;798 '...,.$ ....44;853....1$ ...'66;55(j" ".,$..r1(tt~D7$.'.. 9,342 $ 7,378 $ 9,500 $ 231 - 1,000 28 474 300 28,804 32,505 45,000 (45) - 300 80 17 150 175 50 200 - 2,063 9,800 279 120 300 - - - $ $ 4,904 $ 2.245 ':': '" ':, , - :> "~', -',', J4 , CITY OF ANDOVER " EMPLOYEES 2000 BUDGET '.. .1/4/9911 :29 AMPLANNING.xLS .............---.'.... .-......-............. ................... . . :}~{;:::;;:::::::~:):{;:::;::::: :;:'::;::::::;:;:?~::;:::::::;:::;;:;::;:' :;}=::::::;;:::=;:::::;::=;=?{ 1IIIiIiIlI",:PlliU':',p,' ',.,'""'.,.,'.,.,.,:,.,.,.".,'.,:,',,.,':,.,:,:,':,:,:".,.:,:,.,',..,',':,':,..,:,',:,'.,.,:,",n",',.,',.:..,"':t"',"u;""','..n'..'b,",""n"':'."',.., ...r:::tt:BifliiJ::BiHWflHii:::t. r:L;IoUUB~ ::?::t:{::::a~:::~'''::CFU~:t:~ ;.;.;.;.;::.;.; :}::~::~;:i:;t:{:::}~:}~:::::::}::::::::::{:::::::::. :...;.......::)i:::::::~(<:}}:::::.: "III~- ,; P".. ,..',.. ,11)i1i1l41!:J1Qi I," -, -. .......-....-_.. ;.:-:.;.;.;.;.;.;.:-:.:.;.;.:.;.;.;.:.;.;.:.:.:....... ':"..',.,.,',',',:""i, >i,', i,' ,,'t..:':.:':.r.:.:.:.,.:::".""'."',"""'.,',".,:,.,.,.,:,.,.,.,.,.,.",.,.,.,.,.,.,.,:",."""", '......'.,...,'}<~U"..'N"'" 'n}}}}',.,} """"",',,",,}',,", :::)P:~::)L)LL:: }:{{ltt:{}f\.::;.;:;.;:::;.:kf)I)}j:[:}})]::?r::( ':':':'::':':'::':':'>-:"':'::;:::::::::::;:::~'ENE:':.:.:.:.;::.:.:.:.:.:.:R...:.;.}ftr~:?:::.:::::::::::::::::::::::::::::, ~~:rmmru ':: " - :::,:' ~.lftHftl/ltf{ ....d,..... __..," ...........--'.... .........,................'........... ..................... 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Community Deyelooment Director 0.520 $ 31,744 0.520 $ 34,250 Zonino Administrator 1.000 35,893 1.000 38,377 Intermediate Planner 1.000 34,241 1.000 40,593 Secretary 1.000 27,464 1.000 29,558 Plannino Intern 0.500 9,256 0.500 9,620 Plannina Commission 4,160 4,160 Total 4.020 $ 142,758 4.020 $ 156,558 CITY OF ANDOVER 1/4/9911 :29 AMWPLANING.XLS ...._........... ...Exp'enpitur~.BudgetW()rk~h~et..... ........,_,~.. .,...., ..,..,... Budget Year 2000 .,." . .." .-............. PLANNING & ZONING DEPARTMENT # Object C22.e. Actual ~ Personal Services 1 01 Salaries $ 106 Salaries - Commission 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Dentallnsurance 133 Life Insurance $q~t9~1$i 87,902 $ 1,965 3,498 5.114 1,196 3,882 642 43 104;242$ $ 2,452 $ "2,452 $ 2,449 $ 734 69 3,739 165 >$ i>7;157A2 i$ 41910 General Fund , Actual ~ 110,102 $ 2,055 4,982 6,661 1,558 8,222 672 60 134:;311 $ $ $ i$' 5,748 $ - $ ,", 5;748i$ Actual ~ 119,617 $ 2,100 6,239 6,951 1,626 11,591 913 59 149';097$( 3,767 $ 251 $ ..--.............-....... '(4:018$> 1,885 $ 941 49 3,564 189 ifk628'$> Budget 1.9W 138,598 $ 4,160 6,700 8,851 2,070 15,117 887 352 .....,................ 17'S;736 $ 5,000 $ - $ 5;000$( 3,000 $ 1,200 200 6,000 198 to;59ai~ Request ~ 152,398 4,160 7,396 9,707 2,270 13,813 887 387 H91;~lg 5,000 '5;006 3,000 1,200 200 6,000 204 10,604 Other Services and Charaes 401 Repair/Maint. - Labor $ 254 $ 89 $ 92 $ 300 $ 300 415 Equipment Services 1,100 1,659 1,642 2,268 2,111 416 Comouter 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,925 435 Subscriptions 50 - - 250 - 442 Meals/Lodging 167 322 321 200 500 443 Continuing Education - 138 - 1400 1400 .i"'" ','.',.','.',',.".',..',',','}.' i: ,t: <i:1 ' ,',' ,',.'. 1((( )i("".,r~l; == ..., Capital Outlay 570 Office Equipment SotHotaj ,[;gJli~mgm.,;m 3,137 $ 1,033 98 6,701 180 11'149 i$ $ "['::"N iti$.iJi _ $ 7,520 $ - $ - $ 1,000 ~ CITY OF ANDOVER 1/4/9911:31 AMWBLDGHAL.XLS ..ExpenditureBudget Wor~$heet...< _.. .... .. ~ ......, ....... Budget Y~ar 2000 CITY HALL BUILDING DEPARTMENT # Object .Q.QQe. I Actual ~ Supplies and Materials 201 General Office Suoolies $ 210 Ooerating Supplies 211 Cleaning Suoolies 220 Reoair/Maint. - Suoolies 223 Repair/Maint - Building P:5iJbtclta($ 34 $ 769 984 614 1,511 .-..,.............-..'...... <(Hal 41940 'General Fund Actual ~ 25 $ 1,558 927 878 1,490 $4)B78:I$ Actual ~ 2,608 1,495 462 1,249 5;813 Budget 1.9W $ - $ 1,700 1,300 1,500 2,000 S;soO $i\ - .... < ' Reauest ~ 2,000 1,500 1,500 2.000 nooo Purchased Services , 321 Telephone $ 12,725 $ 16,063 $ 17,118 $ 17,000 $ 17,000 360 Insurance 2,500 2,700 5,670 5,975 6,154 381 Electric 6,919 8,171 10,377 9,000 10,160 382 Water - 617 1,713 800 200 383 Natural Gas , 2,440 2,427 2,456 4,000 4,000 384 Refuse Collection 961 683 730 1,500 1,500 Sewer - - - - 1400 .'.iii~H~tOl < <t?';'''Y;;' ","',' ,,'innn"> "," ,.r:<",,,n,<';L1 i ,~","" ,/'..".,., ". '.',"'". ,,7., Other Services and Charaes 401 Repair/Maint. - Labor 402 Repair/Maint - Building 406 Contractual Services 410 Rentals SUbtotal $ I , 1$ 1,648 $ 2,009 4,417 611 .. ,,8,685 $ , Capital Outlay 510 Land $ 10,129 $ 5!lU I l::qulpment - <""","""""""$d1tt2! '>>"':"',"""<,7,~/\:",,,i""', '.'...., 240 $ 767 6,121 688 7,815 $ - $ 4.10U , 723 $ 1,533 11,605 606 14,467$ - $ 997 ',."l-l!-ll " $<< 5,000 $ 4,500 12,975 650 " '23.125 .' $ - $ 2,500 7,000 12,975 650 23.125 '..',,", ... .. n" .." .................... ........................ ................,...................... ..........~.. ..... ............ .. .' ... ....................... ...... ................... ...........,................ .... "'((...',....'.'..",...,.."...,...I~ANQ[q]A-YI...." .I(S.. II~~j ,'",..$t<. .<4$;1~'" ,.'$", "'i$$341 ..'...'$' "'i~~()i$ i't{)~,." 1/4/9911 :31AMWFIRESTN.XLS CITY OF ANDOVER , . _ .... .Expenditure Budget Worksheet Budget Year 2000 FIRE STATION BLDG DEPARTMENT # Object C22.e. Actual ~ Supolies and Materials 210 OoeratinQ Suoolies $ 211 Cleanino Supplies 220 Reoair/Maint. - Suoolies 223 Repair/Maint. - Building $Ybtq1~t$n 56 $ 84 109 1,350 1;59Bm $> Purchased Services .. .~ .,.,. .".. '. 41950 General Fund Actual ~ 152 $ 256 791 215 1;4'13/$ Actual ~ 774 $ 665 521 ....--...-........ 1,960 Budget 1.9W 600 $ 600 1,500 3,000 .....-......,.............,.,.,..... ,. I$!5!,?qGi$ Request ~ 600 600 1,500 3,000 s}ioo 321 Telephone 360 Insurance 381 Electric 382 Water and Sewer Service 383 Natural Gas 384 Refuse Collection SubtOtal $ 5,403 $ 5,993 $ 6,552 $ 6,600 $ 7,400 5,400 6,000 6,300 6,750 7,000 10,867 1 0,1 85 8,605 1 1 ,000 1 1 ,000 1 ,01 0 1 ,726 2,874 2,000 2,500 1 0,51 9 9,1 29 6,204 1 1 ,000 10,500 908 918 920 1 ,200 1 ,200 i~ 34;106i $ .. .. 33,951 i$ ai(454 ...-...............--.. $ M.600 i$ 38,550 Other Services and Charces 401 Repair/Maint. - Labor 402 Repair/Maint. - Building 406 Contractual Services '\"SUfltoHlf\ 'I'" "'" "" ., .1 .. .. ~aAJiQTQ]~9 $ 185 $ 4,732 is; 'r """""""."",.J""""""", .,.'..I.,.......'i$ ::::f:4;9l7 \\$: ",(.. """"..""""""""""""""""",\..."""" I4O'lS~i....'.$ 763 $ 882 6,612 :.-,:-:,:::-:,:,:-:,...:-:,-:.-...-.....:-::::.::-::,:.-:--;.:.:-:.:.. '8i.257$\ " 'I' ",.""""""..."""""""",':'""",...1""""',','",., i.i4$J:l22I$i... 907 $ 3,146 4,529 "".',8;582, \$> "'T' """"""""""""""""""""",1.""""",." iioll;a9f:,$i 1,500 $ 2,500 5,500 >9;500'$ "I' "Sil1.$(j'~,...$ 1,500 2,500 5,500 i9;500 SiB ,..... ..' .~' . CITY OF ANDOVER , Expenditure Budget Worl<sh~et". '. _. Budget. Year 2000 _ 1/4/9911 :31 AMWEQUIPXLS EQUIPMENT BLDG. DEPARTMENT # 41980 General Fund Object C22.e. ~lInnlil!s :md M::Itl!rials Actual ~ Actual ~ Actual ~ Budget ~ Request ~ , 220 Repair/Maint. - Supplies $ 138 $ 223 Repair/Maint. - Building 71 SU6total:$200$/ 221 $ 511 >732 /$> 1 ,550 $ 993 i2!543 i$> 500 $ 500 11000I$ 500 500 j~ooO Purchased Services 360 Insurance $ 130 $ 381 Electric - 382 Water - b"",~83 Natural Gas ,',',',,'," ",?'~El? I>""., ,,':,i ,... 140 $ 175 $ 200 $ 206 - - 1,000 1,500 - - 10,000 10,000 1,848 849 ?,~5g' . noo ...11 .. Other Services and Charges 401 Repair/Maint. - Labor 402 Repair/Maint. - Building ,,",,"",",',," ,',""c','...., i> :.';(," $ 146 $ 150 ',,', ~""''', ".'....200 -~ - $ 299 $ 515 500 $ 500 900 900 ...,.. " Capital Outlay 530 Improvements 'SubiBlal $ _ $ _ $ - $ - $ 5,000 >,$ , _' '$>><$i<$.-> "+$>5;()()() ?>iII$I...,'~~~.:I~,.it~1-2b!]$I~3~il.$~~15Q]$..2~~~6,..' 1 ~~~tim();t~J .............................;.;.:.:.:.;.:;:.;.;.:...:..:.:.: ............:.;.:................. CITY OFANDOVER Expenditure Budget Worksheet - ," 'Budget Year 2000" '"., P.W. BUILDING , I Object ~ Suoolies and Materials 210 OperatinG Supplies $ 211 Cleanina Suoolies 220 Reoair/Maint. - Suoplies 223 Repair/Maint. - Building >/ ,,"""'" Purchased Services 321 Telephone $ 360 Insurance 381 Electric 382 Water 383 Natural Gas 384 Refuse Collection ';.';:n:n;;!:::::\t\:\:});.{gijbjotal:?::;:;::;-'" .. . ".-."' "." "::. :;: ':: ::;':;:::':::;:;:\($<::: Other Services and Charges 401 Repair/Maint. - Labor 402 Reoair/Maint. - Building 406 Contractual Services 410 Rentals '.'.';..;. > "..',',',',.. ~,,,.,. """""",/ , " Capital Outlay DEPARTMENT # Actual ~ 861 $ 442 296 2,870 :. 7,795 $ 1,550 4,840 383 2,594 ~.7~~1 19\96!5I$ $ 517 $ 2,921 619 416 ..'. 'L' $ 1/4/9911 :31 AMWPWBLDG.XLS '-. - .;:'<,. 41960 General Fund Actual ~ Actual ~ Budget 1.9W Reauest ~ 788 $ 2,003 $ 3,097 $ 3,500 569 2,194 3,103 3,103 224 3,055 1,500 1,500 6,319 8,710 10,499 10,500 /1 ;::::" , 8,697 $ 1,700 3,387 203 2,402 3,137 ""19;526$ , 9,157 $ 3,500 12,416 3,038 7,823 2,594 , "'38;529/ 1 0,000 $ 3,800 8,000 2,100 11,999 3,000 $313;1399< 10,000 4,200 10,000 3,000 13,000 3,000 $431200 858 $ 5,835 1,368 921 4,908 $ 4,025 6,738 1 .443 · <!>l (,11 " ,..,' ,'.., , ,'.., ...., .." .... '" ,,' '--c- 4,000 16,540 9,000 500 4,000 $ 6,539 8,181 500 530 Improvements $ 15,051 $ 5,490 $ - $ - $ - 570 Office Eauioment - 3,604 688 - 13,000 580 Equipment 1 ,485 - - - - ..),.,..':....',...'.,', /' ;c.'... ii,OOS.... 00 /i ',<< ."".,."...,.........,=cc=. ",.. """"""",'.'"""""'."",..,,,,= I Del'lt S"rvl"" 601 Principal 611 Interest Fiscal Agent Fees "'., $ - $ - $ 35,000 $ 40,000 $ 45,000 - - 130,780 130,025 128,165 - - - - :'1<;0 """""'~,',~"",',",' .",$100il ~. ........ " ' . ......:tiqft~NQmQT~gIII.ir.. ,,:,.:.,:,.:.:.'$45;382~1.:.r'$I:IF45~ /$ .:..:..23&072:.$I[M6~i3.'$;:;27ij~ CITY OF ANDOVER . Expenditure Budget. Works!Jeet - '. '. , Budget Year 2000 ~. -. ',' -. .. ~ CITY HALL GARAGE DEPARTMENT # Object C22.e. Actual ~ ~lInnli"c:: ~nd M;!t"ri~lc:: 210 Ooerating Supplies 220 Repair/Maint. supplies - Gen 223 Repair/Maint. supplies - Bldg. ,"",..'..,",',"'..,',,' ",'" Purchased Services $ 360 Insurance 381 Electric 401 Reoair/Maint. - General 402 Repair/Maint. - Building """""""""",sUf,ltBial{ '$' "" iiil ,',,','" ,',,',',',',',',',,' , ,iir/ ,,) ,....n'nn.n,L nn QRA:NP;t'()'tA1i$' ............................:...:.:.:.:.:.;.:.;.; :.;.".:.:.;.;.:.:.;.;.;.",;.;.;.;.;.;.; .-.................-..... ; 217 $ 213 .......---...................-. /430$/ "( """"""""""""""""""""""",..1""",',',',',',' ,..,.."....'.......'.'.'.'4$Qii.$..".,' Actual ~ $ 10 $ ~.....'.~ 250 $ 564 1/4/9911 :31 AMWHGARAGE.XLS < _.J ~ '..,._ 41990 General Fund Actual ~ Budget Request 1.9W ~ 3 $ 50 150 150 - 150 g....~.. )~ 300 $ 203 325 $ 900 342 900 500 500 i2;242. - - 500 i&14{$iSOOI$@(i12S,$ I I I .......{i.'.'....a2iiI'..'.S.'.', ...,...,ir........,.,.ls:,.r:1~B1S"I,I$ .r.j;m'. CITY OF ANDOVER _ Expenditure Budget Wo.rksh~e~ Budget Year 2000 1/4/9911 :32 AMWSRCNTR.XLS .. '. ~ . SR. CITIZEN CENTER DEPARTMENT # 210 Operating Suoplies 211 CleaninQ Supplies 223 Repair/Maint. - Building ,,",',"",",""" \\\\\\<>~"'<) ,",\"'""" ,',',"..".,........'.'.'....'... $ $ - $ 280 152 41970 General Fund I I Actual Budget Reauest ~ 1.9W 2QOO 209 $ 300 $ 300 - 300 300 244 200 200 ,'..'..',' ...~ Object C22.e. I ~lInnli~!; ;Inri M;lt~ri;ll!; Actual ~ Actual ~ .',' "'."','.','.,'~"","', I" , " .. Purchased Services 321 Telephone $ 360 Insurance 381 Electric 382 Water 383 Natural Gas ,",,",',,~,~""""'" ",~,,~Luse Co.ll~sti8~".,.,., "..\\"\,, "\\,..,,. ....,..', 746 $ 715 $ 710 $ 800 $ 800 2,062 2,200 2,310 2,430 2,503 2,965 2,266 2,469 2,600 2,600 - 154 369 200 380 610 607 614 850 850 301 236 255 400 400 lk ;I, $7L533 ',..,',......,..........,..,,== Other Services and Charges 401 Repair/Maint. - Labor $ 64 $ 97 $ 72 $ 600 $ 600 402 Repair/Maint. - Building 245 325 - 700 2,700 406 Contractual Services 1.590 2,432 2.203 2 ROO 2,800 I ",..,....c ,,',', ,,',' ""') ,i Efln, ,"IUU ','""""",.'.,,',"""i""'... ,,',', =..,,=, Q~A'NOTQTiU ..,'"'..,..,.',.,,'.,.,.,..,'.,.,,.',...,.,,',..I,'.,",'.'.,."'.,,..,..,", $,ISj.$9;. I$II9,',',,:,4,",,".,',54,..',,'."'" i$1~160I$:14;,43,'..,.'",3,d,'.,'",', ................:.:.....:.:.:.:.:.:.:.:-:.:.:.:.:.:.:.:.:::.::;.:.::~ . . . . "..' CITY OF ANDOVER -, EMPLOYEES 2000 BUDGET " ,1/4/9911 :33 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 Enaineerina SecretarY 1.000 32,488 0.750 25,892 Enaineerina Interns 0.500 9,256 0.450 8,658 Enoineerino Tech 4 1.000 46,330 0.800 38,218 Accountant 1 0.200 6,642 0.150 5,393 Enoineerina Tech 4 1.000 44,750 0.750 33,992 GIS Intern 0.000 - 0.500 - Enaineerino Clerk 0.500 9,301 0.425 10,025 Accountino Clerk III 0.08 2,906 Total 6.749 $ 296,529 6.354 $ 273,122 CITY OF ANDOVER 1/4/9911 :33 AMWENGINERXLS .. Expenditure Eiudget ~~rk~h~~t_ Budget Year 2000 " . .' ENGINEERING Object C22.e. Personal Services 101 Salaries 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Dentallnsurance 133 Life Insurance $U~!9!~tI ..................... .~....... """""""""""'..""""""""'$.""""" ................-...... ..-.- ......-...........,-- ..... ..-.......-.....,-...- .... ...-........'...-........... :~:\:.::::.:::::-:;::::..;::::;::;::.:::::::::: ,::::::::' I ~lInnli"" ::lrltt M-;t,:;ri::ll.. 201 General Office Supplies 210 Operating Suoplies 220 Repair/Maint. - Supplies 240 Small Tools 258~ap~!~f~~7ale" , "'.."',.$lIl?~otat' " ,.......,1,$"." ""'1 Purchased Services DEPARTMENT # i Actual ~ $ 163,074 $ 6,917 9,017 2,109 10,200 681 64 %92;066\$i Actual ~ 194,314 $ 8,552 11 ,408 2,668 14,295 860 n g32ili174 $ 42000 General Fund Actual ~ Budget 1.9W Reauest ~ $ 273,122 13,699 16,934 3,960 20,377 1,362 594 $300;(149Y 3,300 $ 5,782 $ 4,769 $ 6,000 $ 6,500 1 , 1 01 2,726 3,286 5,000 5,500 8 - 879 - - 1 60 645 1 ,341 5,000 5,500 232 1 34 1 25 1 500 1 500 \4,800 i$< '9(286 <$ 10;MlO $< 17\500 /$ 19;000 252,444 $ 12,542 $ 15,103 $ 3,532 $ 18,862 $ 1 ,254 $ 96 $ 003;0021$ 296,529 14,881 18,385 4,300 28,033 1,701 675 $4;503 $ 301 Professional Services $ 238 $ 420 $ 605 $ 500 $ 500 317 Consulting Engineer - Gen. 2,752 2,947 404 1 ,600 1 ,600 31 9 Consulting Engineer - St. Pr - - - 1 ,500 1 ,500 321 Telephone , 852 2,1 17 3,046 2,400 3,500 I 322 Postage 618 1 ,001 919 1 ,800 200 330 Transportation 1 86 210 281 200 500 351 Publishing 33 1 ,365 1 ,745 1 00 2,000 360 Insurance 1 80 1 80 200 210 216 '$I!~t()t~li ",'" $ "4.859 iSi >i8;239 i$ " "'7,200 $< "'8,310 >$ 10,016 Other Services and Charaes 401 Repair/Maint. - General $ 546 $ 501 $ 365 $ - $ - 415 Equipment Services 1,700 2,564 2,537 2,807 3,262 416 Computer Services - 5,100 3,500 - - 418 Maintenance Contracts - - - 3,500 4,000 431 Recording Fees 39 - - - - 433 Dues/Registrations 1,933 2,833 3,541 4,000 4,000 435 Subscriptions 125 - 330 200 300 442 Meals/Lodging 174 65 649 750 1,600 443 Continuing Education - 75 298 3500 4 300 , "..,,',.., "",' ;1.';1 ~l ,',,"" ",,) ,',' """"~.. ILli ,"',',' .' . CITY OF ANDOVER 1/4/9911 :33 AMWENGINER.XLS Expenditure Budget Worksheet , .' , Budget"Year '2000 ' 0 biectl Actu a I Actu a I Act u a I B u dae t Reau e st C22.e. I 1992 ~ ~ 1.9W ~ E N G I N E E R I N G ( C 0 N TI N U E 0 l ;::IDI 570 Off ic e Eauiom e nt $ 4 , 3 52 $ 7 , 8 88 $ 6 1 1 $ 1 1 , 5 00 $ 5, 000 580 Eq u ip m e nt 1 82 6 60 2 1 , 9 1 4 - 5 , 000 , """""""'>:"">subtotal<< """..""'..""""""""""....'....'.."...."...."4:535'"$' <8;549$ 22$25$ lil5dd$i lftdOO , ""':'(""""" i1. ' 'i1" .."T'" ,,(, .....'.:.....:..,'.:.:.;...:-:-:.:-:.... . ...'..;.....:..,:...:.;.....:-.- ..,......:.'.:.;....-.... .-- ... " "'I ..... :~::~::;::: !,i;t9~R*9ill~fft;:i:i'ilittti:il:~;.ffim;~~~~~;;/-:~ffi;ffi~.lt~m;~~~~~.;II~ffi;;~~!~~il~;;;~~~~?' ~.. .. ' CITY OF ANDOVER , ~pe~ditu~e Bl;I~9e.~ 'l.'9~k~~_eet Budget Year 2000 1/4/9911 :36 AMWPOLlCE.XLS .' .. POLICE PROTECTION DEPARTMENT # 42100 General Fund Object Actual Actual Actual Budget Reauest C22.e. ~ ~ ~ ~ ~ C::..nnlies and Materials 201 . C1' Office Supplies $ 21 $ 170 $ - $ - $ - ,{",{"""",,'{{ ~..I #ill 44 """"""""""""'" , Purchased Services 310 Contract $ 568,922 $ 645,871 $ 719,670 $ 1,012,092 $ 1,062,430 ............................................,......,.-.. .-.,..-.........,.................................. .-.......--.-..-....-....-.. ..-........-.-....... ....................... ........................,.... ..................-....... $Ml;l~g~~!)I$5ag;922,$>a45;g'l1 )$<'t19;61'O$dJli2;lJ92$d;062;420 Other Services and Charoes 460 School Liason Officer $ $ $ 51,555 $ $ , , , " ..'~ , , .. ' - , " , ::",,":',:..:..:' :',', ,,'..",', ,,',' " "," '" ".., .uu.,:~f!l~BJ[~<ut:i$5aa;94iI $~{t14'JI $i"71<f~~I $ijiQ1'2>>92'$lib6IM30( . ._~.. . " . ~. .. .'-", CITY.OF ANDOVER., '..' EMPLOYEES 2000 BUDGET ,.,1/4/9911 :36 AMFIRE.XLS ", , 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services FilII Tim~ Emnl Fire Chief 1.000 $ 55,462 1.000 $' 59,421 Fire Marshall 0.000 - 0.000 - Secretarv 1.000 33,828 1.000 34,781 Subtotal 2.000 $ 89,290 2.000 $ 94,202 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 Trainino Officer 1.000 1,500 1.000 1,500 Safetv 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,862 Volunteer Fire Fiahters 50.000 120,000 50.000 120,000 Subtotal 65.150 $ 164,799 65.150 $ 165,062 - Total 67.150 $ 254,089 67.150 $ 259,264 Obiect C22.e. CITY OF ANDOVER Expenditure Budget Worksheet .,.,. Budge't Yea'r'2000' . -.' I FIRE PROTECTION I DEPARTMENT # Actual ~ I Personal Services I 101 Salaries $ 102 Salaries - Volunteer 121 PERA 122 FICA 124 Relief Association 125 Medicare 131 Health Insurance 132 Dental Insurance 133 Life Insurance 135 Phvsicals 151 Worker's Compensation SUbtoia!?$ 69,283 $ 118,271 6,074 8,332 86,792 2,584 5,687 195 552 1,674 13,500 ..................,......-...-.......-.,... (12);944.}~f 201 207 210 212 220 240 321 322 330 351 352 360 Supplies and Materials General Office Supplies I Training Supplies Ooerating Supplies Gas - Vehicle Reoair/Maint. - Suoolies Small Tools SUbtotcd $ 1,160 $ 1,950 14,531 631 1 324 .............,......,..--.,.,.,....,.".....'.... "" '" ,',',,',',...',., ,$,..., ", ,19,596 "$ 'f.""" I Purchased Services I I Teleohone Postage Transoortation Publishing I Printing ,lln,~ur~nc~, 'SqJjttltal $ 113 $ 232 706 103 398 12 500 ""1if;d51 $,.' '," I .'$ Other Services and CharQes 401 Reoair/Maint. - Labor $ 406 Contractual Services 415 Equioment Services 416 Comouter Services 430 Uniforms 433 Dues/Registration 435 Subscriptions 442 Meals/Lodging ',.., """"".",.,",",..,',',',',',..,',",'"',',',,',,,~,"'.,"',,"',.'b","'t",,'o""','t.'.'a"',"'l",'""",',..,",'""',,,',,',, """"""'...'...'..,, """""""""""$"" ...~..:...........:-:.:::.::::>::>:-;::-;.>:.:<-:<::::::::-:::::::-:::-:::-:.':-:.:.:-:.:.:. ("'il 518 $ 1,097 65,000 2,138 13,134 1,063 400 ",......."....-........ ....... aa:SSO$i ''I"'' Actual ~ 65,134 $ 98,599 6,287 6,709 86,525 2,252 5,789 464 626 2,495 6,429 Z81;OO8$ 2,060 $ 2,790 14,997 73 2,734 5050 27;'104 /$/ 221 $ 293 522 614 1,031 13500 de(18()$/ 3,797 $ 3,247 98,030 170 1,883 16,939 436 800 125;303}$ "',', "('" 1/4/9911 :36 AMWFIREXLS " '. . . ~. .. . ," ..;0.., .... 42200 General Fund , Actual ~ 76,894 $ 114,688 7,219 8,464 91,580 2,732 6,112 469 675 3,734 2,581 ...................... 315}148 \\$ 3,021 $ 989 17,888 27 749 83 22(157 i$> 832 $ 240 728 609 362 14200 , " >16,971\$ 4,191 $ 7,622 96,724 350 1,664 13,567 783 641 1.25:54.1 .,.,$ "'j' BudClet 1.9W 89,290 $ 164,799 9,401 15,753 105,000 3,684 7,644 542 965 4,000 16,000 )417)07$ 2,000 $ 4,000 17,000 100 3,000 3000 >29(100$/ 700 $ 350 1,000 750 1,100 14 91 0 19;alo $> 1,700 $ 3,250 108,825 3,000 22,000 750 2,500 ?j~~;9~~I~ Reauest ~ 94,202 165,062 9,915 16,074 105,000 3,759 4,962 542 977 6,650 16,000 $423;143 2,250 3,500 22,000 100 4,000 2 500 $4,350 750 350 1,750 750 1,100 15 357 2.6;057 2,000 5,000 100,647 2,500 22,000 750 3,000 135;007 . '-.""'-. ",,-. .... .~. . . _. . '" .". - ." CITY OF ANDOVER Expenditure Budget Worksheet , ,,' Budget Year 2000 ' .. , ..., 1/4/9911 :36 AMWFIRE.XLS . , '. . . - . . ". ~, 0 bj ec t Actu a I Actu a I Actu a I B u dge t R eQu e st ~ ~ ~ ~ JJm .zooo. UUTl3V 530 I mprov e m e n ts $ 1 , 9 8 0 $ 234 $ - $ 1 2 , 00 0 $ - 5 80 Eq u i p m e nt 29 5 9 3 4 0 , 6 04 22 , 475 50 , 00 0 - , , , SUbla tar , , i'$ .,......>31,573 ${{ , 40,839 $ {~;~!~i$ , 62,000 $i' - ,..:,:,.,::"::,:,:,,,.,(',..:, "I" ""1""" ..,[" """T'" ;:;i:;i:!;;i,~i:l;iii;~.JI11Igl.1i~;iii!iii.ii;~:;.I:ii~;::':f;'[1::;:ilii~m~1:li~;;:;';:~:rr~1.I~~:'\:~1;;r:;~.;\;~;:1':~~~~'~!;i~m~~~.: . CITY OF.ANDOVER EMPLOYEES 2000 BUDGET , ",1/4/99.11 :37. 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 Buildinn Official 1.000 44,260 1.000 46,375 Buildino Insoectors 2.000 74,389 2.000 82,551 Buildino Secretaries 1.800 47,646 1.800 50,224 Part Time Sec.- 3mos@2m 0.125 4,628 0.125 2,340 Total 5.876 $ 221,116 5.876 $ 234,171 '." CITY OF ANDOVER Expenditure Budget Worksheet ..' . 'Budget Year 2000 ".. 1 /4/9911 :37 AMWPROTINS.XLS PROTECTIVE INSPECTION DEPARTMENT # 42400 General Fund Object Actual Actual Actual Budget Request C22.e. ~ ~ ~ ~ 2QQQ Personal Services 101 Salaries $ 178,206 $ 179,779 $ 195,536 $ 221,116 $ 234,171 121 PERA 7,744 8,213 10,000 11 ,454 12,130 122 FICA 10,150 10,900 11 ,592 13,709 14,519 125 Medicare 2,374 2,549 2,711 3,206 3,395 131 Health Insurance 17,595 17,782 19,422 24,509 22,161 132 Dental Insurance 1,240 1,301 1,292 1,575 1,449 133 Life Insurance 83 83 83 575 633 SubtoUU .........................................-.... /g~?i3.92 220;007 I$ .........-.-.-.......... 2'76;144 288;459/ "..,"',","',"',","',",' ',",",,',',"",",,"'$""" /$ '240;634 ii$ /$ ............................................... !:!:!:t??i:;:?in:]:::;:::;;;nr:@H}/@[{t .:}~:: ................ ........................... ........................................-.-.. Sunnlie!; and Materials 201 General Office Supplies $ 3,222 $ 5,739 $ 4,001 $ 4,000 $ 5,500 203 Printed Forms 2,274 3,001 2,792 5,000 5,000 210 Operating Supplies 275 255 2,491 750 3,300 220 Repair/Maint. - General - - 52 100 100 ,iI ",'," ..'....'..' """,.'.'. ..' :50,771 ..,/Cl' i$13.900 / ,ill'. " ,,',",' ,',", .., Purchased Services 301 Professional Services i$ 364 $ 1,812 $ 16,696 $ 20,000 $ 1,000 321 Telephone I 76 401 116 400 3,860 322 Postage I 905 1,010 960 1,200 1,200 330 Transportation I 100 311 2,332 1,600 500 I 351 Publishing I 102 - 270 150 300 352 Printing 239 - - 100 100 360 Insurance 900 925 975 1,024 1,055 ".II ~OA:' RiHi::. Other Services and Charges 401 Repair/Maint. - General $ 234 $ 57 $ 310 $ 500 $ 1,000 415 Equipment Services 6,000 9,049 9,089 10,076 11,514 416 Com outer 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 2000 2 000 '.".'.."'.. ,',..',..,",',,'>,<:.<',<>"'..:/ ".,.".,',.,.,.,.,.,',.,.,.".~i $/16.414 i """,'.' ..."..'.'.'..'. ",,'" .".'.'...'.' '.'.' ".".",' ..'.. '.' PROTECTIVE INSPECTION . continued CITY OF ANDOVER , Expenditur~ Bu~get ,!,o~ks~eet , , Budget Year 2000' " . ' . 1/4/9911 :37 AMWPROTINS,XLS :' ~ ~ . .... Obiect C22.e. Actual ~ Actual 1.92Z Actual ~ Budaet Reauest 1.9W. 20QQ Capital Outlav 570 Office Equioment 580 Equipment """"......'.....,'. ......'... $ 1,143 $ 4,921 $ 240 - $ 837 ~..Im; $ "',',,',',',',',',',',,,',"'" lE....~ 810 Refunds/Reimbursements $ - $ 1,056 $ - $ - $ - CITY OF ANDOVER, EMPLOYEES 2000 BUDGET .,. 1/4/9911:38AMCIVIL.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Buildino Official 0.049 $ 2,586 0,049 $ 2,714 Total ,0.049 $ 2,586 0.049 $ 2,714 '. CITY OF ANDOVER Exp~nditure ~udget Work.shee.t Budget Year 2000 . ' 1/4/9911 :38 AMWCIVILXLS CIVI L DEFENSE DEPARTMENT # 42500 General Fund Object Actual Actual Actual Budaet Reauest C22.e. ~ ~ ~ ~ 2QQQ Personal Services 1 01 Salaries $ 2.340 $ 2,348 $ 2,504 $ 2,586 $ 2,71 4 1 21 PERA 1 04 1 07 1 29 1 34 1 41 1 22 FICA 1 42 1 48 1 50 1 60 1 68 1 25 Medicare 33 35 35 37 39 1 31 Health Insurance 1 85 1 85 203 226 226 1 32 Dental Insurance 1 2 1 3 1 2 1 2 1 2 1 33 Life Insurance 1 1 1 5 5 I"",,""""""""',',..,..,..,.. '.."'.... ~.. ,-;- ~.. ~lInnli~!': :Ind M:lt~ri:ll!': 201 General Office Supplies $ - $ - $ - $ 1 00 $ 1 00 21 0 Operating Supplies - - - 50 50 220 Repair/Maint. - SuppliEls 5142 - 5 054 4300 5000 "'SUbtotal"" " ,,$.,., <5<142- "$.." .. - $>' 5[054> ,$,'" >4:;450 i$> 5aSO Purchased Services 321 Telephone $ - $ 60 $ - $ 1 00 $ 1 00 360 Insurance 460 490 520 550 575 381 Electric 703 703 703 800 850 ...........................-...-..........,.,......,.-.,.. ?H$ >$ 1;253 i$i 1;223 1;.450 Siibtotal? t;lBS, $ "$ """""""'1525 :.::;::::;:.:;::::;:;:::,:.," "" Other Services and Charges 401 Repair/Maint. - General $ 3,81 7 $ 2,1 56 $ 3,557 $ 3,650 $ 3,650 ............... ',,',',',"",,',",',',.. ',',',, ~ I H~ "".. frrrGRANl)?tOTAC"r. .. ":""1r.:~$' ::t2'.'94d $) ."riH246.',$:"1~~1$ .',.:127121'$':1:,13$32,.' . ... CITY OF ANDOVER , ~~e~~itur~ .Budget vtork.~he,et , Budget Year 2000 , . 1/4/9911 :39 AMWANIMALXLS ' .- .:.", ..." ANIMAL CONTROL DEPARTMENT # 42700 General Fund I I Object Actual Actual Actual Budget I Request C22.e. I ~ ~ ~ 1.9W I ~ SUDDlies and Materials 203 Printed Forms $ - $ ~~ggt~h~~1a1J88Ii~~I$?t~$ - $ - $ 100 $ 30 186 181 150 - {{>?{\+OO \:::$:: /)//\\dai :{1::$:1)1/:::: :}:::::t250 :}:$:::::::::-:: :::::::::::?):)//?/?30( Purchased Services , """""""""""''1'"'''''''''''' ........",...".1.."..,." ,,',',','..,.,',.,','..,..,..,,' ..,....",..., , ,'.'"., .i,."."',.",.", ,'.,'.. .',',',.'..~~~,9!;r!TAE....../,'.'...'... $ 11,470 $ 18 $?jli4a8$ ,'.., '....'T'..' ,', .."''[,.', ,1$,.:.:ii1.W6G'.~$.f .:.;.:-;.:-,...;.................:. ..................;.:-:.:...:(.... .. .................:...;.:... I 11,072 $ 9,673 $ 13,000 $ 10,000 53 -....75................75.. ijlH2!3I$9;$7$I$!?;~~~I~a(,U}75 .I.11~'1:~."'$' ....'stii~$;:.'13l325,.I:,$ .t....rl.I.1Q;1PS'.,. "..., , ..'........'..""(, ,.... 310 Contract .~~~?'~.~S~b~otat.r"':",., CITY OF ANDOVER. EMPLOYEES 2000 BUDGET 1/;4/9911 :41 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 Supervisor 0.360 .. 17,440 0.360 14,938 Maintenance Workers 2.060 71 ,151 2.060 79,297 Public Works Secretarv 0.050 1,326 0.050 1 ,427 DataEntrv Clerk 0.025 564 0.025 665 RecvclinQ Coordinator 0.020 589 0.020 644 General Clerk 0.025 465 0.025 590 Seasonal Emolovee 1.000 6,400 2.000 . Total 3.690 $ 106,191 4.690 $ 106,227 CITY OF ANDOVER 1/4/9911:41 AMWSTREETS.XLS Expenditure Budget Worksheet, Budget Year 2000 STREETS/HWY DEPARTMENT # 43100 General Fund Obiect Actual Actual Actual Budaet Reauest C22.e. ~ ~ ~ 1.9W 2QOO Personal Services 101 Salaries $ 1 15,195 $ 95,322 $ 128,274 $ 106,191 $ 106,227 121 PERA 4,457 4,253 6,645 5,501 5,503 122 FICA 6,489 5,814 7,846 6,584 6,586 125 Medicare 1 ,517 1 ,349 1 ,835 1 ,540 1 ,540 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 Sul:i1oUIlI ......-............... ......... 13~i~52 118;552 15~i~18 iH~~i~12 1$9;~1ij ....................-............ i$ $.. I$ i$ ?$. ... .... ..... ............-_...........-.-_....... .................................. Supplies and Materials 201 General Office Supplies $ 344 $ 219 604 657 700 210 Operating Supplies 8,501 9,682 10,685 9,700 12,000 220 Reoair/Maint. - General 2,621 1,886 1 ,867 3,000 3,000 221 Repair/Maint. 0 Vehicle - - - - - 224 Repair/Maint. - Street 16,726 12,281 2,319 8,000 9,000 228 Repair. Maint - Spec. Proi. 3,929 - 5,295 5,000 5,000 240 Small Tools 966 250 469 1 ,000 1 ,000 """""""""$U~19j~r" .... )$' 33,087 $ i24;318 $. 21.240 "'$.. 27';357' 30/tOO '$ Purchased Services 301 Professional Services $ 362 $ 422.00 $ 386 $ 500 $ 500 321 Telephone 247 608.95 1 ,681 702 800 322 Postage 173 267 289 400 400 330 Transportation 0 24 41 50 50 351 Publishing 217 214 1 15 100 250 360 Insurance 1 1 385 12 000 13000 13,650 14,060 L> \:$~.~' ,,',',,',' ',' ,= !,: 1Q.. ,~i< ,',',,',',',',",",',',',',', "".'..........',.',,'. "'.',.,.,.""",,,'.... ,. Other Services and Charges 401 Repair/Maint. - General $ 567 $ 661 $ 413 $ 1 ,200 $ 1,200 403 Repair/Maint. - Streets - 190 5,466 5,000 5,000 406 Contractual Servo 0 Grading 10,909 10,295 27,960 32,000 35,000 410 Rentals 15,037 15,000 13,230 15,000 15,000 415 Equipment Services 25,130 37,900 37,510 42,203 48,225 416 Computer Services - 85 300 - - 433 Dues/Registration 614 1 ,394 1 ,225 1 ,500 1,500 442 Meals/Lodging - - 404 400 465 Improvements 0 Streets 55,636 26,553 21 ,216 41,000 50,000 466 CracksealinQ & Sealcoating 194,344 210,000 169,583 400,000 400,000 467 Overlay - - - 272,856 460,613 Syhtot~li i$ $02;2$7 i$ 302;077 .$ 277;$08 \$ 810;759 $1;016;938 . .........- - ...... " .. CITY OF ANDOVER '.- Expenditure Budget Worksheet ,Budget Year 2000 1/4/9911 :41 AMWSTREETS.xLS Ob"ect C22.e. Actual 1.992 Actual 1m Actual ~ Budget ~ $ $ $ .:."..'...:.,........:'@d~~tI;roTAu'IITrIg'F:"'.ir..,....'..540.:;i'Iji...."'iaa;i)i72;aiS ..".$~moi:$i(,~}6[i;, ~CITYOF ANDOVER ." ','_' "_, 1/4/9911 :41 AMSNOW.xLS , EMPLOYEES 2000 BUDGET 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Suoerintendent 0.150 $ 8,255 0.150 $ 8,666 Suoervisor 0.700 33,720 0.700 32,016 Maintenance Workers 3.770 138,361 3.770 151,632 Public Works Secretarv 0.050 1,326 0.050 1 ,427 Data Entrv Clerk 0.025 564 0.025 665 Recvclina Coord, 0.020 589 0.020 , 644 Public Works Clerk 0.025 465 0.025 590 Total 4.740 $ 183,280 4.740 $ 195,639 , CITY OF ANDOVER Expenditure Budget Worksheet , ' - "Budget Year' 2000' , . SNOW AND ICE DEPARTMENT # Obiect C22.e. Actual ~ Personal Services 101 Salaries 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Dentallnsurance 133 Lifelnsurance $4~!9j~JI $ 84,585 $ 3,305 4,539 1,062 6,493 428 37 .......................... dO~t44gI$ ..,.................... .."""""""""""""""$..' ..............-_... ..,..-....,..,',....... .-..-....,'.-..,-........ ;::::;:;:;:;:;:;:;:;:;:;:;:;:;:;::::L- Supplies and Materials 201 General Office Supplies $ 210 Operating Supplies 220 Repair/Maint. - Suoplies 224 Repair/Maint. - Streets -Isdi:Hola({ , ,',' '$I 231 $ 7,512 3,515 54,553 65;811i$ , Purchased Services 1/4/9911 :41 AMWSNOW,XLS 43125 General Fund Actual ~ 132,146 $ 5,263 8,303 1,954 10,292 692 55 158;795 199 $ 10,906 719 132,795 144;62f1n $ 301 321 360 Professional Services $ 46 $ - $ Telephone -- Insurance 2 1 00 2 300 "c',,'.''"'',',',',',''','''',' ",,,. ",',",',',', 'I ',$,{,: ".{, ",'.., " Other Services and Charaes Actual ~ 87,304 4,450 5,163 1,208 7,774 463 36 ...-.......................... ,$1001$98 354 $ 11,317 4,058 69 133 84;861 Ii$ 22 $ 2,400 Budget Request 1.9W 2QQQ $ 183,280 9,494 10,982 2,658 20,177 1,169 464 $I~g~;~~~ 400 $ 12,000 4,000 11 0000 126;4()() $195,639 10,134 12,130 2,837 19,121 1,193 521 ~~~~;~?~ 400 12,000 6,000 120 000 $138.400 - $ 100 550 600 2,520 2,596 ',"," ,= ,', , 401 Repair/Maint. - General $ 1,600 $ - $ 2,302 $ 2,000 $ 2,000 406 Contractual Services - 2,069 - 4,000 4,000 415 Equipment Services 45,000 67,867 67,169 75,573 86,356 416 Computer Services - 85 250 - - 433 Dues/Registration 225 183 499 1,000 1,000 r'..".."....~ """'I '.....".'. :," ",',','. ~.. ,..' Captial Outlay 570 Office Eauioment $ - $ - $ - $ - $ - 580 Equipment - - 1.124 - - $. Ii ,,'"', :;; ..~ .:,QRANgltQI*~I":."..'II$ ..:~t5a30'.'$;'.' .;'$i5~~:$...:n.iti2&:.'$::::.j~'...' $41ilfi~ , 0". " ,CITY,.OF ANDOVER. EMPLOYEES 2000 BUDGET ~ 1/4/9911 :;42.t\MSTORM.xLS, 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Suoerintendent 0.050 $ 2,752 0.050 $ 2,889 Suoervisor 0.160 7,664 0.160 7,478 Maintenance Workers 0.790 25,813 0.790 29,074 Public Works Secretarv 0.020 531 0.020 571 Recvclina Coordinator 0.020 589 0.020 644 Public Works Clerk 0.010 186 0.010 236 , Data Entrv Clerk 0.010 226 0.010 266 Total 1.060 $ 37,760 1.060 $ 41,158 CITY OF ANDOVER Expenditure Budge~ Wo.rksheet. Budget Year 2000' , 43150 General Fund - 1,100 688 1,700 2,527 8,794 100 510 """,""','.. <>>,'..,..,,$<""."'...(l3'! 0$/ ",.""','.""",,,,""""""" STORM SEWERS DEPARTMENT # Obiect Actual Actual C22.e. ~ ~ Personal Services 101 Salaries $ 8,153 $ 28,395 $ 121 PERA 351 1,246 122 FICA 492 1,690 125 Medicare 115 395 131 Health Insurance 533 2,914 132 Dental Insurance 47 212 133 Life Insurance 3 14 I................... :,., ~ C::llnnlies ",nrt M"'h'ri"'lc: 201 General Office Suoolies 210 Ooeratino Suoplies 220 Repair/Maint. - General 227 I Repair/Maint. - System 240 ]Small Tools I'':':':::'' I,'..': "",..".:"",.'':'",.'",'. $ $ 175 1,064 3,279 , Purchased Services 1/4/9911 :42 AMWSTORM.XLS -, '. ".. ~ . Actual ~ Budaet 1m Reauest 2QOO 17,764 $ 37,760 $ 41 ,158 884 1,956 2,132 1,071 2,341 2,552 251 548 597 1,412 4,426 4,251 92 257 267 7 102 117 H':...,~ - $ - $ 100 $ 100 500 500 1,200 1,200 2,000 2,000 700 1 000 '"", 303 Consulting Engineer - General $ - $ - $ 75 $ - $ - 330 Transportation - - - 200 200 360 Insurance 200 214 125 131 135 381 Electric 91 93 96 500 500 '::"',,..,':""" ~.' 1<'<" .'<': ,<.... ,< <ruT .'. $ '':': iT I".."",':",', .' ".',......,.' .., Other Services and Charaes 401 Repair/Maint. - General $ 299 $ 329 $ 1 ,422 $ 5,000 $ 5,000 404 Repair/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 Inspections - - - 2,500 2,500 415 Equipment Services 1 ,200 1 ,810 1 ,791 2,015 2,303 416 Computer Services - 85 185 - - 433 Dues/Registrations 20 10 - 250 250 '$~t#9taF/"""'" , .., " /$< """"4,lGl <$ <3,$23 /$ <32,813 /~ <i67!765 $ <68;053 Capital Outlay 530 Improvements $ 6,582 $ - $ - $ - $ - 580 Equipment 3,963 27,049 - 30,000 - ~........~ -..... ...... CITY OF ANDOVER Expe!lditure ,Bl:Id.get Worksheet .. Bu~get Year2~OO 1/4/9911 :44 AMWLlGHTS,XLS . . .... . .. ,. .-' ~ '. . , -. .. .' ,'. . STREET LIGHTING DEPARTMENT -# 43160 General Fund Object C22.e. Actual ~ Actual ~ Actual ~ Budget 1.9W Request ~ Purchased Services 351 Publishing 381 Electric $pl:)\qtlil\r $ - $ - $ 40 $ 20,923 i20;964 - $ 17,531 19,437 $i171i531$>19;437 i$ 26,000 26,000 \$21:1';000 } ,$> 26;000 Other Services & Charges 401 Repair/Maint. Labor-General $ 100 $ 50 $ 350 $ 200 $ 400 :$u.I:)J9@I$dOO~iiIOO$iiI350,~Ii200 '$'\400 Capital Outlav 530 Improvements sdtitotali $ 610 $ x$ "'~>10\$ '( t,.I$jil;~4Ql52 2241 $ 3,060 $ 21241$3;0001$ T I J'$f\'.fI;~l;~~I$ .fII~~~~~"I~f 10000 $ 12,000 '10000$12;600 '" ""( ,..'...f~~~I~f3a~~..., r t:jl.II.[g;r~~"II . . . . . CITY. OF ANDOVER. EMPLOYEES 2000 BUDGET 1 /4/9911 :~5 AMSIGN.S.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Suoerintendent 0.030 $ 1,651 0.030 $ 1,733 SUDervisor 0.170 8.235 0.170 . 7,065 Maintenance Workers 0.980 32,1 08 0.980 35,635 Public Works Secretarv 0.030 796 0.030 856 Recvclino Coordinator 0.030 883 0.030 966 Data Entrv Clerk 0.015 338 0.015 399 Public Works Clerk 0.015 279 0.015 354 Total 1.270 $ 44,290 1.270 $ 47,008 1/4/9911 :45 AMWSIGNS.XLS CITY OF ANDOVER Expenditure Budget Worksheet ~ ,- .,.., . . .. . :. . ", ""-' . '. '. . '.. Budget Year 2000 ' I.' ..~. .. . ~ STREET SIGNS DEPARTMENT # Object C22.e. Actual 1992 Personal Services 1 01 Salaries 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Dentallnsurance 133 Life Insurance $Qijtq~lI $ 22,419 $ 982 1,397 327 1,924 192 15 ........................... ig~i~f$ ...-..,....,..................,' """"""""""""""""""""$' :;>::;::::;::::::;:::;:::{}/(:::)):., , Supplies and Materials , 201 General Office Supolies 210 Operating Supplies 220 Repair/Maint. - General 226 Repair/Maint. -Signs Subtotal ""'" ,,' $ 14 $ 16,560 540 1709 >i$<J8i823\$< . . ~'.. ." ~ .~ 43170 General Fund Actual ~ 35,064 $ 1,382 1,984 464 3,517 61 17 421488 - $ 7,792 1,641 21 319 <<$0;752 ".'.~.."'. Actual ~ 49,526 $ 2,490 2,961 693 5,577 247 27 f$i~1;521 9 $ 42,774 2,055 ",. (1008) >43,830\$ Budget ~ \$ 44,290 $ 2,295 2,747 642 5,373 319 127 55;~3 IUll Reauest ~ 47,008 2,435 2,915 682 4,568 319 140 ..................... $8;066 200 20,000 2,500 10 000 32;700 Purchased Services 301 Professional Services $ - $ 40 $ 66.00 $ - $ 100 330 Transportation - 161 - $ 200 200 360 Insurance ~O 100 110 ~.' 11~ I..,>. ',',',',',',' ,'" '''''':1 '."".":',>>" == Other Services and Charges 401 Reoair/Maint. - Labor $ 2,049 $ - $ 286 $ 1,000 $ 1,300 410 Rentals 10,165 1,541 1,318 13,000 13,000 412 Insoections 346 - - 3,000 3,000 415 Equipment Services 3,500 5,279 5,224 5,878 6,716 416 Computer Services - 85 150 - - 433 Dues/Registrations 196 357 685 600 1,000 f<>> ",',' ,,',' " .,'.',' ""CSAI ~b.Ult:i ,,'.'.'...'.'.'.'..'.' ,',', Capital Outlay 530 Improvements $ 2,307 $ - $ - $ - $ - 580 Equipment 3.089 - - - - '."",....'. """""""",,;12..,., ",=",.".,c;:: 2 "',',," "',""',"",",""',' 150 $ 17,000 2,000 10 000 29;150$< ...................... . ........ ..................................................................................................................~........ ~. ." . . ... .......~..... ... ................. ................................. I:.IgHiNR:TQfaII:.'$II,'T:jf~O;:I$ ...IIii]ijQ4.I,$II\i~$;j~$lQij;m:$;l'jij:. .. -.. .~ CITY OF ANDOVER 1/4/9911 :45 AMWTRAFFIC.xLS Expenditure Budget Wor!<Sheet . . . , .. Budget Vear'2000 ,--.- ,. , "-.'~.. -.-.... TRAFFIC SIGNALS DEPARTMENT # 43180 General Fund Object C22.e. Actual ~ Actual ~ Actual ~ Budget ~ Reauest ~ Purchased Services 381 Electric $ 16,609.68 $ 17,303 $ 17,350 $ 25,000 $ 30,000 $4~!9!~j{$16;E~Ol:U'j8 }$< .17[363" \$H1il)S50}$2S:000i$3Q;OOO Caoital Outlav 530 Improvements ....................',.'.....'....... $ - $ - $ =c"'i._.l..~ - $ - $ .,..",, H :::":"'.~.:~.~::..;.!..!!~!!I!!~E ":."" ~,:,w<'~:$"jijii:6a,<<~,\,:,w'ii~::t~$v,:"":,,wi~E: ::~~:":'~~~@!i~r ::'~';~'~~. CITY OF ANDOVER Expenditure Budget Worksheet . ,'. Budget Year 2000 '. ...', 1/4/9911 :46 AMWSTLlGHT.XLS .".,... ST. LIGHTS-BILLED DEPARTMENT # 43190 General Fund Object C22.e. SUDDlies anti M"'t"ri""'" Actual ~ Actual ~ Actual ~ Budqet ~ Reauest ~ 201 General Office Supplies illmi $ $ _ $ - $ 150 $" ~...,-'I~ 150 """..'....-,,', , , Purchased Services 301 Professional Services 322 PostaQe 351 Publishing 381 Electric 406 Contractual Services 0~s'si~~~~~r~ii" $ $ - $ - $ 100 $ - 400 16 50 1 01 ,511 94,000 1,823 3,000 - - 100 400 50 115,000 3,000 79,631 2,206 124 > 81J:iEi1 16 85,923 1,167 507 stiErS? '$ ,103,350$97,550$118,550 ..':','," '$ $,.',. , Repairs & Maintenance 470 Street Lights Maintenance ,,' "'SiibtQ~I> $ .','..'i$." $ 2,423 $ 9,225 $ 16,000 $ 16,000 $>2;423 $>>9;225$1&;000$> 16;000 Capital Outlay 530 Improvements $ 7,573 $ """""""""'..'"""."",,, ,',', ..""':...ii"'>.'..""..'" "OJ"a,,' 7.5; .'"",...,.."""".EC,' - $ " - $ ;' - $ -$ " ..':.':~".."..:....'~~~~~'!tBIg"'., ".'.'.'...'...'m'$I89;s3319a:$'i{:;90;O:m'$.ii.11~,~75 .$Jjj~iOO'$dij4~7!ijij -~ ~"_. . ~ . CITY OF ANDOVER, EMPLOYEES 2000 BUDGET .1/4/9911 :47-AMTREES.XLS 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Superintendent 0,010 $ 550 0.010 $ 578 - Public Works Secretary 0.050 1,326 0.050 1 ,427 Recvclina Coordinator 0.020 589 0.020 644 Data Entrv Clerk 0.025 564 0.025 665 Public Works Clerk 0.025 465 0.025 590 Total 0.130 $ 3,494 0.130 $ 3,904 1/4/9911 :47 AMWTREES.XLS 406 Contractual Services 415 Equipment Services 416 Computer Services 418 Maintenance Contracts 433 Dues/ReQistrations 440 495 385 "".,.S9?,J 500 Sti6t(jhW< "" """"'<$1;~MOi$<2;94t /$>fW29$<3,844.$< <5;035 CITY OF ANDOVER Expenditure Budget Worksheet ", ',' Budget Year 2000' ' -- . TREES DEPARTMENT # 461 02 General Fund Obiect C22.e. Actual ~ Actual ~ Actual ~ Budget ~ Personal Services 101 Salaries 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Dental Insurance 133 Life Insurance $9~191AtII $ 12,147 $ 503 735 172 917 50 5 14~$29I$ 10,647 $ 470 643 150 1,006 59 5 ...................... 121981 /i$ 13,890 $ 717 821 192 1,035 71 5 16;731$i 3,494 $ 181 217 51 139 8 3 4:092I $ .....,.......,',....,.....,',',.....,',....,' ,',",',',','"""',','",',','..""",',,,,',,',',,(5 ........... ,',........-..... ........--.--- .,...........,",',' ',.........----,','"........... .........---, ,.........-.-.--. .............,...........",',' ......................... ::.:..,....:-;.;.:.;.:::.:::::::::::::::::::::;::::;:::::::;:::i: - Supplies and Materials 201 General Office Supplies 210 Ooerating Supplies 220 Reoair/Maint. - Suoplies ",319,~T~U.:rools $ - $ - $ 303 19 419 - 1R - "..,., ",'," - $ 51 500 150 $ 500 500 ::>00 ',.., ,',.',. ...." ' , Purchased Services 301 ' Professional Services $ 330 Transportation 351 Publishing 360 Insurance Stibtdtal>" '>$ 4,967 $ 4, 1 93 $ 3,528 $ 1 0,000 - - - 50 64 25 - 500 50 60 70 74 <5,081 ii$ 4.279i $ <3,598 $> Hc);624 Other Services and Charges $ $ 1,154 $ 1,207 85 - $ 2,000 $ 1,344 800 1,194 150 Capital Outlay 580 Equipment .................................................................. $ 801 $ 1.082 $ <t,082 - $ - $ ~..IL.,.,.,..,..,',.".'.""'.. '<I Reauest ~ 3,904 202 242 57 516 32 14 .......,............. 4;967 .................. 150 1,000 500 ?oo " $ 10,000 50 500 76 .'.,' $10;626 3,000 1,535 ::. :.::..::':lli:::'.~"':...:i:.llmR:'IiT..;lli;:..,:.:.::::';::...;:,.:::$i;E:;~Id.;[$:ra1Iea1;";J$i::.l~l&::i:'$.:::;::i:J~1&;i.:$':::iii1i' . CITY OF ANDOVER. . EMPLOYEES 2000 BUDGET ,1/4/9911 :47 AMWEEDS.XLS . 1999 BUDGET 1999 2000 BUDGET 2000 CLASSIFICATIONS # OF EMPLOYEES WAGES # OF EMPLOYEES WAGES Personal Services Suoerintendent 0,010 $ 550 0.010 $ 578 Suoervisor 0.050 2,414 0.050 2,490 Public Works Secretary 0.050 1,326 0.050 1 ,427 Recvclina Coordinator 0.020 589 0.020 644 Data Entrv Clerk 0.025 564 0.025 665 Public Works Clerk 0.025 465 0.025 590 Total 0.180 $ 5,908 0.180 $ 6,394 1/4/9911 :48 AMWWEEDS.XLS CITY OF ANDOVER ~xpenditu.r~ ,Bu~ge~Worksh~et.. . Budget Year 2000 . ..~ ~ .",' . , WEED CONTROL DEPARTMENT # Obiect C22.e. Actual ~ Personal Services 101 Salaries 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Oentallnsurance 133 Life Insurance ............................................................................... ,$Y~tqJ@J,,) $ 2,190 $ 100 134 31 84 5 1 I,,$2;54t1'$\< lies ~nrf M~t~ri::ll~ 201 General Office Supplies $ 210 Operating Supplies 220 Reoair/Maint. - General 240 Small Tools $y~##~i)" '/$ 1,277 1,654 186 3(111 Purchased Services 46103 General Fund Actual ~ 1,672 $ 75 101 24 36 2 1 >~~~1.1<$ $ - $ 206 1,222 .". ~1 ,427> $ Actual ~ Budget Request ~ ~ 3,939 $ 203 241 56 143 17 2 4;600$> - $ 200 463 200 <863 <$/ 5,908 $ 306 366 86 370 20 8 7;064/$ 100 $ 600 2,500 200 <3;)400 /$ 301 Professional Services 330 Transportation 351 PublishinQ 360 Insurance " """""""'SyiH6hl(/' 1 ,342 $ 538 $ 790 $ 1 ,500 - - - 25 - - 1 55 200 52 60 1 00 1 05 1)394 :$ >598 i$ ><1.045 i$ 1;830 $ ...,.-..--.--.........-...-.-.'...' ,', ,,',,' ,.'i$ 6,394 331 396 93 747 44 20 ~;2?$ 150 600 2,500 200 ::..',3450", ,,-.,)-. .':: $ 1 ,500 25 200 108 i$1i833 Other Services and Char<;Jes 401 Repair/Maint. - Labor $ - $ - $ - $ 100 $ 100 406 Contractual Services 1,412 69 4,407 5.000 5,000 410 Rentals - 500 - 500 500 415 Equipment Services 450 679 672 756 864 416 Comouter Services - 85 150 - - 433 Dues/Registrations - - - 300 300 '.','.'.'."," ..',",',' i)~ ""',"""~..,"'" ""'in,, '..'..' ~. ...'v... ....... ." '" .............;.............;........................ .... .........,......... :::GBAijpW&mm;:/ "$II,..".','.,..,.~,",,'.,",9,",,'.,',,it,'.,'$.'.,'.,",."..,.. st,..,",!;"'.,'.,_,'.,",'.,..,'.".,'.,.,'"..,,.,',...$,",'.,."..,..,..,..,."... jj~,737,..',..",'.,..,.,."..,I,'.,$.",'.,'.,..,'.."..,:,1".., s~m,.',..,$;,','.,.., 2jjj(tt2) ;:;.;.;.;:.;;:;:;:;:;:;:;:::;::.;.;.;.;.;:; .......... .;.;.;.;.;.;.;.;.;.;.;.;.;.;.;.;.;.;.;.;.;...................... _. . CITY OF ANDOVER EMPLOYEES 2000 BUDGET . 1/4/9911:48 AMPARKS.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,610 29,444 0.610 30,194 Assistant Enoineer 0.250 13,720 0.250 14,340 Civil Ennineer 0.100 5,365 Eno. Secretarv 0.200 6,905 Eno. Interns 0.050 962 Eno. Tech IV's DADO 18,619 Eno. 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,855 Recvclino Coordinator 0.020 589 0.020 644 Public Works Clerk 0.050 930 0.050 1,179 Data Entrv Clerk 0.050 1,128 0.050 1,329 Part Time Summer Helo 3.000 19,200 3.000 19,200 Warmino House Attendents 7.000 44,800 7.000 44,800 Commission 3,840 3,840 Total 14.430 $ 228,515 15.230 $ 2n,101 CITY OF ANDOVER 1/4/9911 :48 AMWPARKS.XLS E~penditure Budget ~ork~h~et, " Budget Year 2000 PARKS DEPARTMENT # I 45200 General Fund Object ~I Personal Services Actual I Actual ~ ~ 101 Salaries 106 Commission 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Dentallnsurance 133 Life Insurance ....................................................................... ......................................... [$~9~~ ~lInnIiAc: "'nrl M",tArj",lc: 201 General Office Supplies $ 210 Operating Supplies 211 Cleaninq Supplies 220 Repair/Maint. - General 225 Repair/Maint. - Landscaping ... .2.40 "ISm~H!.~o.I.~ """'"""""",,," ',,',.,'.'.'," ".' ,.., "i$i.i~!~> """"...""""" '/$ $ 140,864 $ 1,800 5,631 8,772 2,051 9,735 685 65 1~~;~ 102,687 $ 2,490 , 3,894 6,534 1,527 7,157 365 41 i$1a1;~4 1,534 $ 10,338 511 10,720 16,540 1 ,437 41;080 i$ Actual ~ I$ 160,317 1,990 7,366 9,450 2,210 14,554 971 66 ........,....,.......... """"'9..'6"'9.23""""""'" t"ln,} , Budget 1.9W $ 224,675 $ 3,840 8,323 13,930 3,258 19,176 1,066 423 $27~;~~1{$i 1 ,200 $ 12,000 700 10,000 17,000 1,500 42,400 ..'.'..~... Reauest 2QQQ 273,261 3,840 10,840 17,180 4,018 22,367 1,303 963 3331772 1,500 15,000 800 12,000 18,000 2,000 49;300 Purchased Services 301 Professional Services $ 1,817 $ 2,251 $ 2,248 $ 4,800 $ 5,000 321 T eleohone 787 992 2,164 1,200 1,300 322 Postage 245 400 353 600 600 330 Transportation - 18 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 CoHection 4,226 4,001 6,651 5,000 7,000 390 Taxes - 688 441 750 800 ,,'",,'C", > ..',..',- ".,.,.,.,.,.""~.... ~,........~,."" ;;;;"""""[00 $ {"".....'.. '" "".""""", Other Services and Charges 1 ,389 $ 1 0,191 214 6,593 13,535 1,494 33\416 I $ 2,412 $ 13,923 176 11 ,190 13,029 1,974 /42iZ04$i 401 Repair/Maint. - Labor $ 4,986 $ 7,123 $ 5,1 14 $ 7,000 $ 8,000 403 Repair/Maint. - Improvements 5,436 6,893 5,534 7,000 7,000 406 Contractual Services 12,383 22,013 1 8,782 20,000 25,000 410 Rentals 7,958 6,762 8,928 1 0,000 10,000 412 Insoections 914 - - - 413 Repair/Maint. Trails - - - 1 0,000 10,000 415 Equioment Services 23,000 34,688 34,351 38,626 44,138 416 Computer Services - 85 1 50 - - 433 Dues/Registrations 900 907 296 1 000 1 500 i$i.i6tQiWI i$ 55;578 /$> 78;470 >$ 73;155 i$} 93(626 $} 105;638 ...... .....,,_.... 1/4/9911 :48 AMWPARKS.XLS CITY OF ANDOVER Expenditure Budget Worksheet .' ' 'Bu-dget 'Year 2000 ' Object ~ Actual ~ Actual :tmrr Actual 1.900. Budget ~ PARKS - CONTINUED Capital Outlav 530 Imorovements 570 Office Equipment ......,.......-.-.............................--........................--.-....'.. t\\{1:\Jj%~%\1]H[I$.PQ,t9!~J\~{)t~?~1()\/}~:}:::::': $ ./:\[:[:)[;;r::;U\1:i\1[l[:\:\}$F?t 25,698 $ 48,700 ......-..-...........,..,... <74)391', 35,582 $ 40,818 $ 60,000 $ """"""""""""""""",1"""""" ',""""",","',"" """","""""" $<3$iQ32$);.tO;SlB$iSa;Oaa $< Debt Service. Assessments 603 Assessment Princioal 613 Assessment Interest ,I$~tp.t~tm $ 35,898 $ 7,663 4g~1 >$ 17,447 $ 9,117 ....................... 26;564 $ $ 18,000 8,000 i$2SjljOO 17,454 7,285 24.739 ......,.................. i$ Miscellaneous Andover Fun Fest Contribution 820 Community Schools Program 821 Summer School Program / ~,u,..,)),J,o,",JaJ, / ' ' """'<:'(,::' . """"",."".I.....'::m.nt':6\NDTOTICii ",. ;.;.:.:.:.:::.;.:.;.:.:.:.;. :;.:::;;::;;::;::::::::::;;::;:~;::;;::;:;:::;:;::::;:::::;:;:;::::::::;::::::~::::;;;::.; ...........w................ ........ - $ - $ 4,000 $ 48,886 50,295 51,858 "",:,'.1.,~?J 7,200 7,200 /56,036$57;4$5/$ "63;058i$ '..'I" "[ 'T "'T' 'l' ~~ $ $ 51 377 7,150 /$58)521 /$ Reauest 2000 $) ',................. .....,..........-. ....-............ ..... .d......... ........-...,',.....,' ............ .d.. ..................--. ......--.-......-...,........,-, " ......---....... 4,000 52 285 7,200 63;485 $aa;~ ................... . CITY OF ANDOVER Expendit.ure. Budge.t Worksheet Budget Year 2000 1/4/9911 :50 AMWFIELD.XLS SUNSHINE PARK DEPARTMENT # 41995 General Fund Obiect C22.e. Actual ~ Actual ~ Actual I Budget ~ 1.9W Reauest ~ ISuDDlies anti U"t"ri"I" ' , 201 General Office Suoolies 210 Ooeratino Supplies 211 CleaninG Suoolies 220 Repair/Maint. - Suoolies 223 Repair/Maint. - Building .........,............-..............................~.........~~,..... $U6tQm~< $ $ - $ 249 419 104 183 i955$i - $ 524 751 639 613 ................... 2i52S 20 $ 600 500 700 1,000 ........,......,...,....... 2iB2tfi $\ 20 1,000 500 1,000 1,500 .-4;020 10 .....-............,................. .................,.. t:\}{@}\{~)$t))\ {~:)H:))1:0 :$i> $I Purchased Services 321 Telephone 360 Insurance 381 Electric 382 Water and Sewer 383 Natural Gas 384 Refuse Collection ~~.O Taxes $ - $ 1,247 $ 1,516 $ 1 ,497 $ 1 ,497 - - 500 525 550 - 2,749 3,401 1,500 2,000 - 22,520 10,189 10,000 10,250 - 1,102 675 1,800 1,800 - 1,000 - 1,000 1,000 - - 80 - 100 ",'"'.',, ~.. ",'",',.'.' ",., , "" ,= Other Services and Charaes 401 Reoair/Maint. - Labor $ - $ 606 $ 259 $ 2,000 $ 3,400 402 Repair/Maint. - Building - 449 549 1,500 3,500 406 Contractual Services - 2,862 1 ,485 3,000 3,000 410 Rentals - - - 800 800 ..'"..""',,".'."',"',.. , ",' ,',"',', " liiiii9riif ,':",:"" ........ .............~..,......,.... .................... ... . ......... ....... .........,.u.............. ......,......... .. .................................................. .... ..........,..... ......................................................', ,f.f,..:.'.'...IIII,.:...GgH~x~ijg,..,.I":,,..,:..IIIII,sI..':f::'ii.':'flOfI$ ifaaI4~..:..: $ :f~1d8j..'.., $?'~~442$)...".'31;Q17.. CITY OFANDOVER EMPLOYEES 2000 BUDGET 1/4/9911 :50 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,797 Maintenance Workers 0.190 6,114 0.190 6,847 Public Works Secreta 0.050 1,326 0.050 1 ,427 Public Works Clerk 0.025 465 0.025 590 DataEnt Clerk 0.025 564 0.025 665 Rec din Coordinator 0.790 23,248 0.790 25,442 Rec din Maintenance 0.500 5,000 0.500 962 Total 1.690 $ 42,356 1.690 $ 41,619 CITY OF ANDOVER' 1/4/9911 :50 AMWRECYCLE.XLS Expenditure Budget Worksheet Budget Year 2000 RECYCLING Object C22.e. Personal Services 101 Salaries 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Dental Insurance 133 Life Insurance .................................................................-. $9~~~U~I{ i$f SUDiiIi~q ~nrl M~t~ri~lq 201 General Office Supplies 210 Operating Supplies 220 Repair/Maint. - General 223 Repair/Maint. - Building {~ ,,',,',', "'",':,::':", ,'...,"'( .."",'., Purchased Services 301 Professional Services $ 322 Postage 330 Transportation 351 Publishing 384 Site Maintenance " ", ,$UiitqjaFi$.... ""'1 Other Services and Charges DEPARTMENT # Actual 1m $ 19,595 $ 722 1,191 279 243 21 2 .22,Q5.4i$ 46140 General Fund Actual ~ 21,622 $ 849 1,347 315 381 27 3 24;543 220 $ 919 .,~~......~ 367 $ 2,237 277 5,521 1 674 j(),077 - $ 401 Reoair/Maint. - Labor 402 Repair/Maint. - Building 406 Contractual Services 415 Equipment Services 416 Computer Services """",:4,~~"'" ""D~eslFle9istrations 240 ",'" "',',,' . ,SUbtotal'" ""...$22;821$( Capital Outlay 582 Equip. - Recycle Bins $ $9bjQj~jI" ..'...'.~...' "',..",;I;:.mBi"Q;m~I~;:;;~:$i $ 209$ 2,179 97 ~,~ 358 $ 1,085 515 2,817 1460 6!2$$$i $ 519 $ 21,862 200 1,576 $ ::: 22,268 302 85 350 '23;005 Actual ~ 33,161 $ 1,703 1,938 453 2,206 120 4 .......................... $iS!}!5S1) Budaet 1.9W $i 42,356 $ 2,194 2,626 614 4,889 275 109 53;003 \$\ Reauest ~ 41,619 2,156 2,580 603 5,242 299 131 52;630 304 $ 300 $ 350 766 9,000 10,000 - 250 250 48 500 500 ..".."'<'" ..",..".'.',.., "",..""G"", , 113 $ 353 215 1 ,141 1 380 \$2;202: 77 $ 28,998 298 150 420 . ............. {$"'29;943 is''' 400 $ 2,000 400 3,000 1 300 7#tJd"'$i 400 2,000 400 3,000 2 000 >7,800 500 500 25,000 384 450 450 $......24;786 fi$26!S3:4 500 $ 500 23,000 336 3,517 $ 2,925 $ - $ - '3,S17$2;S25$\>/$ , "" :E~,1~;:;;~;<I~~~.;::9i~\I$.::;9aia6a. CITY OF ANDOVER 1/4/9911 :51 AMWOTHUNAL.XLS Expenditure Budget Worksheet Budget Year '2000 ' UNALLOCATED DEPARTMENT # 49200 IGeneral Fund I Object C22.e. Actual rn!2 Actual ~ Actual ~ Budaet 1.9W Reauest ~ Unallocated 151 Worker's Comoensation $ 29,501 $ 21,777 $ 27,969 $ 32,000 $ 31,000 313 Mediation Services 1,464 1,557 1,640 1,800 1,827 499 Contingencv 15,544 119,685 15,671 50,000 40,000 Employee Recognition - - - - 2,000 "'SUbtQtaJ>i$461S10$ "","143Q18\$@45.,',>,",2B.,'" Om $\8s;eOOd;74,",',',8,"",.,'27"".,..,,'.',m,, <T "'fr?; 'I ' '" 'I ",'," ,',' 'r>lJ , ;j~11~1rlM:lr~~ttlil&...lml!flrlJ;1l:f~;;~flITi~a1~~li~fl~m~ltllr~11f:'m~B'1~~?;;!rf~~~~~:*1~~~;. , OTHER FIN. USES 49300 General Fund Obiect C22.e. Actual ~ Actual ~ Actual ~ Budget ~ Request ~ Other Uses 458 CDSG $ 107,574 $ 69,264 $ 30,211 $ 35,000 $ 40,000 710 Residual Eauity Transfer Out 531,653 - 870,038 - - 727 Transfer to Other Funds 8000 6000 - - - ~~~.~s W09~~~ .;.,':;::..:';I,:.:::."G.iiii:igt~!,I.:...l.ll,:$:;ii3~liil::,$!:::iiiiil:.:$:.:~~~$:'.it.liiiQll::'.$::,:t4;m;' CITY OF ANDOVER, EMPLOYEES 2000 BUDGET 1/4/9911 :52 AMCENTEQ.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 Suoervisor 0.030 1 ,443 0.030 1,398 Maintenance Workers 0.580 22,131 0.580 24,187 , Mechanic 1.600 63,129 1.600 66,590 Summer Help 0.000 1,128 0.000 - Public Works Secretarv 0.100 22,131 0.100 2,855 Recvclinq Coordinator 0.020 1,321 0.020 644 General Clerk 0.050 589 0.050 1,179 Data Entrv Clerk 0.050 930 0.050 1,329 Finance Director 0.020 2,653 0.020 1 ,427 Accountant I 0.010 360 Total 2.600 $ 123,710 2.610 $ 108,635 . CITY OF ANDOVER 1/4/9911 :52 AMWCENTEQ.XLS Revenue/Expenditure Budget Worksheet Budget Year 2000 CENTRAL EQUIPMENT FUND TRUST & AGENCY FUND Revenues Revenue C22.e. Actual ~ Actual ~ Ir.h~rnl'!l': fnr ~l'!rvi"'l'!l': 36212 Valuation Adjustment 36260 Refunds and Reimb. 38400 Equipment Rental .:;:nm:I:m}:~]::Imntn1mnnWI::]J 1)?mrSdbt6til:;mm:r:rm: :::::;:::::;:::::;::::::;::::;:::::::;:::::::::.;.:::.:-:.i......... .............-.'-..'.'.--..'...'...'.-...-.-'-.''..'...'.......... $ - $ - $ 21 310,501 319;522$:i """',""""'.',",', 205,880 ............................,...... >$205;$BOJ)(j} $1 Miscellaneous Revenue Actual ~ 527 1,895 307,306 3O~i72a Budaet 1.9W Reauest ~ 345,753 393,588 $345'1753 $Ii 39$;588 36210 Interest Earnings ,.,""'::':I'SubtotiU 2,200.00 $ 2U200;OO~I " ., """"""'..""'1"""'" ..'...'.'208;08OJOO.~..$ 472 $ 4,312 $ 472~4;312$) """"""'1"""""""" """"""",..,..""..""".."""""",...1,..,..", " ' '" ,.", 310;993$ 314J146,i$ - $ 1 ,500 ..-:......,.............-.'.-.......-.-.-.;.-.-.-.....-. ':':';';';':';"':':':':':':-:':':':';';':', <$)/1;1500 """""'[""""" """""",..""".',.,..,.""J,..,..""" """"',",'...,""" >345,753,$39$;083 $ .,', iII, I, II,.., )ti} """""""""""r.. ......-- ........ .......".......-..,............;...;..-.; "..,..""'..""".."..L"",,' """""'$ .',-.....-..-:...'....-...,.. ::::::::;.-.:::.:":::;:::;.;.) : .,""""""""""',("",..,""',..,'" ," ....-.......:.:.:.;.:.:.-.:-...-:.:.:-:.;.:-:.:-:.:...-.--..........'.... -. ,Ii """TOTAllREVENUES""""""""""", ... .,"',',..,.,........',',....,........,",',',',",........-..,",'"........ . -. ... ........ -.. ........ . ......-.-- - ...... Expenditures Actual 1m Obiect C22.e. Actual ~ Personal Services 101 Salaries $ 121 PERA 122 FICA 125 Medicare 131 Health Insurance 132 Dental Insurance 133 Life Insurance .-.........,...-..... ..-...~...........................,...... ..,... ..... . """""""$ij~tQt~t> "'."'.."""">$;/ 71,031 $ 3,148 4,192 980 7,251 472 35 (87)110/$ 80,061 $ 3,583 4,674 1,093 7,612 516 36 i97,575 ,$ ,.:. Actual 199B. 91,888 $ 4,765 5,368 1,257 9,219 603 39 113538 $>> Budaet 1.9W 107,979 $ 5,262 6,695 1,566 10,812 600 238 1':33J152I $ , Reauest 2000 117,293 6,076 7,272 1,701 11,914 678 297 145;231 SUDDlies and Materi"lc: 201 General Office Supolies $ - $ 5 $ 225 $ 400 $ 500 210 Operating Supolies 5,799 6,373 7,259 8,000 9,500 212 Gas - Vehicle 15,180 10,471 11,016 18,000 15,000 218 Diesel Fuel 25,577 32,497 20,407 32,000 32,000 220 Reoair/Maint. - General 435 485 1,178 500 1,500 221 Reoair/Maint. - Vehicle 97,248 75,453 84,418 75,000 80,000 240 Small Tools 2,026 3,269 3,850 3,500 4,000 p CITY OF ANDOVER 1/4/9911 :52 AMWCENTEQ.XLS Revenue/Expenditure Budget Worksheet Budget Year 2000 Object Actual I, Actual Actual I Budget I Reauest C22.e. .199li I nm ll9a I ~ I 200Q $~~np~$146;266$1~;552$12g;353$ 137;~~~.'!S~OO . Purchased Services 301 Professional Services $ 321 Telephone 330 Transportation 334 Vehicle License 360 Insurance $g~Jqti4iil II n'''ft"' : and 158 $ - $ 523 37,050 ,""'ij"".'H' ,:,,''o7V701 102 14,281 ....................... ....{$ .i.{.I.{,I.'.i~i~83 $ - $ 895 $ 15,132 8,736 153 916 40 40 262 28 1,646 1,147 - - 401 Repair/Maint, - General 405 Repair/Maint. - Vehicle 406 Contractual Services 409 Inspections/Emissions Test 410 Rentals 433 Dues/Registration 442 Meals/Lodging $H~~~~~J$17;233~1ji763~{ Capital Outlay 200 $ 2 664 7,736 ..-...................--. $IiS;602i$ 441 $ 18,871 780 56 422 203 319 .'.........'..'.'...'.-.'.'...',....-.-.-.....-. 21(001 500 $ 500 500 500 700 43,348 " ._-_.-.....-..... .,.,........................... ifl4S;~{ 600 42,085 ..-.-.-............. ...-.-..-.................... """",""""'A'>j"'~"o'5".. ::::::::~:::::~:>~~t~:? -.": - $ 30,000 1,000 500 500 2,000 .-.-.-.,.-.,.,.-.;.;.;.-.-.-.-.-.-.-.-.',-. iI$341000 ".'..~' 1,000 30,000 1,000 500 500 3,000 500 ~i~iXj 550 Vehicles $ - $ 10,907 $ - $ - $ - 580 Equipment 13871 35,514 - - - ,m9]~tEXgE~P!IgBE~$302,210$298.694$27;1Aa4$347;737$369i17a ............~ 1/ .. CITY OF ANDOVER CENTRAL EQUIPMENT FUNDING BUDGET YEAR 2000 1/4/9912:02 PMEOUIP.XLS E!.I.t:!Q DEPARTMENT ~ PERCENT AMOUNT GENERAL ADMINISTRATION 41430.415 00,2429% 898.19 GENERAL CITY CLERK 41400.415 00.0971% 359,05 GENERAL FINANCIAL ADMIN 41530,415 00,5829% 2,155.44 GENERAL PLANNING / ZONING 41910.415 00,5343% 1,975.72 GENERAL ENGINEERING 42000,415 00,8257% 3,053.26 GENERAL FIRE PROTECTION 42200.415 25.4747% 94,199.88 GENERAL BUILDING 42400.415 02.9143% 10,776.45 GENERAL STREET/HIGHWAYS 43100.415 12,2061% 45,135.49 GENERAL SNOW AND ICE 43125.415 21.8574% 80,823.89 GENERAL STORM SEWERS 43150.415 00.5829% 2,155.44 GENERAL STREET SIGNS 43170.415 01,7000% 6,286,23 GENERAL PARK AND RECREATION 45200.415 11.1716% 41,310.14 GENERAL TREES 46102.415 00.3886% 1,436.96 GENERAL WEEDS 46103.415 00.2186% 808.34 GENERAL RECYCLING 46140.415 00.0971 % 359.05 WATER WATER 49430.415 13.3344% 49,307,70 , SEWER SEWER 49450.415 07,7714% 28,736.94 CENT. Ea. RENTAL REVENUE 38400 100.0000% 369,778.17 TOTAL 369,778,17