Loading...
HomeMy WebLinkAboutWK October 24, 2006 o 1685 CROSSTOWN BOULEVARD N,W, . ANDOVER, MINNESOTA 55304 . (763) 755-5100 FAX (763) 755-8923 . WWW.CI.ANDOVER.MN,US City Council Workshop Tuesday, October 24, 2006 Conference Rooms A & B 1. Call to Order - 6:00 p.m. 2. Natural Resource Topics - Engineering a. Status of Oak Wilt in Andover (DNR) b. Conservation Development Presentation (City of Lino Lakes) 3. Railroad Quiet Zones Update/06-1O - Engineering 0 4. 5. 6. 7. Discuss Crosstown Boulevard Tumbackl06-13 - Engineering 2007 -2011 CIP Updates/Trail System Discussion - Administration/Engineering 2007 Budget Update/Enterprise Funds and Community Center - Administration Charitable Gambling Ordinance Research Update - Administration 8. Other Business 9. Adjournment .~ 6J o 5'\NDbVE~ 1685 CROSSTOWN BOULEVARD N,W. . ANDOVER. MINNESOTA 55304 . (763) 755-5100 FAX (763) 755-8923 . WWW.CI.ANDOVER.MN,US cc: City Council ~~ Jim Dickinson, City Administrator David Berkowitz, City Engineer ~ To: From: Kameron Kytonen, Natural Resources Technician Subject: Status of Oak Wilt in Andover (DNR) - Engineering Date: October 24, 2006 :J INTRODUCTION The Minnesota Department of Natural Resources (DNR), Division of Forestry is taking additional measures to help communities develop and/or enhance forestry programs, specifically related to the control of shade tree diseases, such as oak wilt. DISCUSSION City staff has been working with a consultant for the DNR to review and evaluate the City's diseased tree program and to help better control the effects of oak wilt on the City. This consultant was invited to share information with the City Council regarding the current status of oak wilt in Andover, challenges and concerns in the present and future and long-term goals of the DNR for controlling the disease. ACTION REQUESTED This is for information only and no action is required at this time. Respectfully submitted, ~/1'-- Kameron Kytonen Natural Resources Technician ~J /--, <J () ,J @) 5'\NDbVE~ 1685 CROSSTOWN BOULEVARD N.W. . ANDOVER, MINNESOTA 55304 . (763) 755-5100 FAX (763) 755-8923 . WWW,CI.ANDOVER,MN.US To: CC: From: Kameron Kytonen, Natural Resources Technician Subject: Conservation Development Presentation (City ofLino Lakes) - Engineering Date: October 24, 2006 INTRODUCTION There has been previous discussion between the City Council and staff to discuss information on Conservation Development, which in general terms, is a form of development that makes conserving and/or enhancing natural resources a high priority and may offer economic incentives to developers while achieving public benefits. DISCUSSION The City's native ecosystems are home to various species of wildlife, help clean air and water, offer recreational opportunities and are aesthetically appealing. As the City of Andover continues to develop at a rapid pace, continued pressure is being put on these natural resources. Development and progress is inevitable in a growing suburb like Andover, but there are some alternative approaches that can be used to balance growth and conservation. Conservation development may be a form of development that offers this balance. The City of Lino Lakes has been on the cutting edge of conservation developments and Mr. Marty Asleson from the City of Lino Lakes will share some of their experiences with this type of development. ACTION REQUESTED This is for information only and no action is required at this time. Respectfully sUbm~' ter;l, /(/ , . k~eron Kytonen Natural Resources Technician @ .r~ 'J C I T Y 0 F NDOVE 1685 CROSSTOWN BOULEVARD N.W, . ANDOVER, MINNESOTA 55304 . (763) 755-5100 FAX (763) 755-8923. WWW.CI.ANDOVER,MN,US CC: Jim Dickinson, City Administrator TO: Mayor and Council Members FROM: David D. Berkowitz, City Engineer SUBJECT: Railroad Quiet ZonesUpdate/06-10 - Engineering DATE: October 24,2006 INTRODUCTION Wayside horns may be a feasible option to reduce noise pollution through Andover at two railroad crossings (Andover Boulevard NW and Crosstown Boulevard NW) caused by train horns. To determine if wayside horns are a feasible option, a diagnostic meeting must be completed. 0) '--~ DISCUSSION The diagnostic meeting will identify if Andover Boulevard NW and Crosstown Boulevard NW are eligible for wayside horns. The diagnostic team includes Robert Albritton (Railroad Controls), Dave McKenzie (SEH), BNSF, MNDOT, City staff and the Anoka County Engineer. The team will evaluate the current conditions at each crossing and the required improvements needed to meet all agencies improvement requirements for wayside horns. Once the improvement requirements are identified, a detailed cost analysis can be determined. City staff, SEH and Railroad Controls are currently in the process of setting up the diagnostic meeting. Once the meeting has been held the estimated costs will be determined. At that time staff will present the information to the City Council for discussion. BUDGET IMP ACT Funding options would be from Municipal State Aid funds and/or the City's Road & Bridge fund. Crosstown is not currently a County or Municipal State Aid road. If the City was to accept the road as a turnback, the City could then designate this segment as a MSA designation making improvements ofthe road eligible for MSA funding. ACTION REOUlRED This item is to update the City Council on the process to determine the costs of wayside horns. .-.J Respectfully submitted, David D. Berkowitz Q,:d;u.l @ r,- 'J FROM: 1685 CROSSTOWN BOULEVARD N,W. . ANDOVER, MINNESOTA 55304. (763) 755-5100 FAX (763) 755-8923 . WWW,CI.ANDOVER.MN.US Mayor and Council Members ~ ~ Jim Dickinson, City Administrator~ David D. Berkowitz, City Engineer ~ Discuss Crosstown Boulevard TurnbackJ06-13 - Engineering TO: CC: SUBJECT: DATE: October 24. 2006 INTRODUCTION The City Council is requested to discuss Project 06-13, Crosstown Boulevard Tumback (Hanson Boulevard NW to 16151 Avenue NW). DISCUSSION The Anoka County Highway Department (ACHD) has notified staff that they are beginning the process to tumback Crosstown Boulevard NW from Hanson Boulevard NW to 161 51 Avenue NW to the City in the next few weeks. This section of roadway was reconstructed this summer in which the plan was reviewed by City staff and for the most part constructed according to City staffs recommendations. C) There are some outstanding items that staff has requested from the ACHD. They are listed below. . Have the signs been updated and do they all meet reflective standards? . The approaches to the class 5 City streets were going to be paved. When will that be complete? (ACHD responded that this will be completed by November 1, 2006.) . There are washouts along the road from heavy rain. When will they be fixed? . The City requests a total construction cost for the project. . Sycamore Street has increased drainage from the improvements. The City would like this addressed. (ACHD responded that this will be completed by November 1, 2006.) . How will any warranty or material failures be handled? . When is this going to the Anoka County Public Works Committee? . When will this go to the County Commission for approval? · The City has not included maintenance of this road for 2006. We request that if this is approved it go into effect January 1, 2007. . Please provide information regarding the tumback process. · City staff also requests that the County provide time for City staff to discuss this with the Andover City Council before formal approval. At the time this staff item was completed, the ACHD had addressed bullet points 2 & 5. If other information becomes available before the workshop it will be presented at that time. ACTION REOUIRED The City Council is requested to discuss Project 06-13, Crosstown Boulevard Tumback (Hanson Boulevard NW to 16151 Avenue NW).and direct staff on how to proceed with the process. '1 '--./ Respectfully submitted, David D. Berkowitz Q~GJ. r'. <J CITY OF NDOVE @ 1685 CROSSTOWN BOULEVARD N,W. . ANDOVER, MINNESOTA 55304. (763) 755-5100 FAX (763) 755-8923 . WWW.CI.ANDOVER.MN.US TO: Mayor and Council Members CC: Jim Dickinson, City Administrator FROM: David D. Berkowitz, City Engineer SUBJECT: 2007~201l elP Updates/Trail System Discussion - Engineering DATE: October 24,2006 INTRODUCTION The City Council is requested to review the attached proposed trail map and direct staff on trail improvements for the 2007-2011 Capital Improvement Plan. \ " ) DISCUSSION Provided for City Council review is a Proposed Trail map that identifies potential trail improvements to be included in the 2007-2011 Capital Improvement Plan. The fund balance for the City's Trail Fund after the 2006 trail improvements are finalized is $166,317. The fund is estimated to generate revenue of approximately $29,500 per year for trail improvements over the next 5 years. The available trail funds in 2007 are approximately $195,000 to $200,000 which would cover one project identified below. If this is all expended in 2007 then the next project (dependent on size) would be out at least 5 years. After 2007 the trail fund revenue is uncertain due to the potential lack of new development. Staff has identified trail options for 2007. The segments and estimated costs are as follows: · Crosstown Boulevard NW (north side) from Hanson Boulevard NW to Nightingale Street NW. The approximate project cost is $200,000. · Hanson Boulevard NW (east side) from 14Sth Avenue NW to Crosstown Boulevard NW. $ The approximate project cost is $230,000. · Crosstown Boulevard NW (west side) from Coon Creek to South Coon Creek Boulevard NW. The approximate project cost is $200,000. · Bunker Lake Boulevard NW (south side) from Hidden Creek North Park parking lot to Crosstown Boulevard NW. The approximate project cost is $170,000 1 ...../ The other segments identified on the Proposed Trails map should be considered but are longer segments and/or have a higher cost per foot that may require additional funding sources outside the trail fund. ,...--, '.J . \ " j ." ,-) Mayor and Council Members October 24, 2006 Page 2 of2 The trail sections along Hanson Boulevard NW south of 140th L~e NW that are shown on the plan are proposed to be constructed in 2007 with the Hanson Boulevard improvements. These sections oftrail are to be funded by Federal and Municipal State Aid Funds. Also included for your information is the 2003, 2004, 2005 and 2006 Capital hnprovement Trail Plan. ACTION REQUIRED City Council is requested to review the Proposed Trail map and direct staff on which trail segment to . . include in the 2007-2011 Capital hnprovement Plan. Respectfully submitted, 'CJ~CJ,~ David D. Berkowitz c::; Attachments: Proposed Trails Ma~rail Fund Projected Fund Balanc~ Trail CIP items from 2003 through 2006"/ ~~ i .&' \ 'O<~ /' ;0 \. ..,CJQ('IIA"B ~ ! .- CMD~AST ! i ~ , f I , , ,f , .f I a....c~I'OoTS1" "-,,<-_..,,,>~, (3'1 L! ,....oL<",,"'_"" ...". ) ..>>'" .r,"" ._ - \ V.~T_~' ~ 1..,,~~ E__ ~ ;,.~~ ! '} 'J - ~"": \ _:._~ i , .- ."" CutYS' OF<:~'QST - ~ - - ~ - ~,.,,~,~,f - I- I- ~~~t { _~:.~l ~.. S .r .. 4"->-'. j .- .", \. ~ ,""'000$' , ."",~ . i """ , '" " - t - c.a:ussr ~,. ~9 ".."",, , , \ ~......, - ..~" ,. , ., ., - -~ .s....""- "" ~~,;; e"a a a a a a a a p a a <t;"'UT i. ~ f~ ~~c;#.' i . ~ ~ -'.SJ.3:>O"'! , ~ AyOCl"TST , , B ~5 ~VOI<>rST ~ , , l , l ._~ ........, '\ , \ ~,,'''' , , ,f ", , .....s! , , .. ~;~' \. \ ~.. a ..C . d ~ a a a a a a a a 1CI,.,,1:.\, , , ,. , , , ~/ / CCu;r,.p,"5C' '''of _ , ....,R'E"'" f' , > , - ,. ~ ; , i i a .u~!lu.'sT ~ ! ,s.#' \ ~, ~ ~,.,. c,. ~ ~ , , . "^,, ~..].>l"'O~ -c> (I~" " _5:>O.;.~_ ~ '\ r..eo,Z , "t......Sr_ '''''" P ...",,", -----~ ,/,. _.~""',", ~,--'-i,. " " 0,% . " '. .' '\ .,,;'.......... #,,'-' "" \ ... ., ,- - '" . ( ( ( ( ( ( ( ( r- ~ Q ...... .. m ::J ~ .. b C"l ~ ::T = CD .. ""0 N ...... 00 :::E en CO C1 0" 0" G) .0 c.Z ~ ~ 0 0 a.. ...., 0 .- A c = ...., 0" ll) C C CD tll 0 ;:;.: 0 CD < :::::l 3 :::E CIl = "'0 0" 0" a.. :::E CD ...... m f'V -. 0 ...... ;:;.: C ll) '< :::::l ll) .... III en c c 3 C1 '< 0 CD 3 3 :::r A 0 0 III ~ c Z 0 a.. :::::l "'0 en Cii' :::::l :::::l 0 =- -; 0 0 C CD ...., C - ll) C c en en en en ..." , I '-~ '" .-- ! . , ~, VOUJv~.:. . /._, U I Projected Sources of Revenue Trail Fee $590 per unit platted units Trail Fee Total Revenues Available Projected Commitments 04-32 Crosstown Blvd & Xeon 51 - landscaping supplies 05-25 Sophies South Trail ~12 East side of Crosstown Blvd -139th Ave to 141st lane 06-17 The Oaks Park Trail Total Commitments Revenues Over (Under) Expenditures Fund Balance as of December 31, 2005 Fund Balance Brought Forward Ending Fund Balance * 2006 $ 153,829 153,829 1,578 3,373 89,778 238 94,967 58,862 107,455 $ 166,317 CITY OF ANDOVER Trail Fund Projected Fund Balance 2007 50 $ 29,500 29,500 29,500 166,317 $ 195,817 2008 $ 29,500 29,500 29,500 195,817 $ 225,317 2009 50 $ 29,500 29,500 29,500 195,817 $ 225,317 2010 50 $ 29,500 29,500 29,500 225,317 $ 254,817 ,. " Target -10% of current years commitments to create a contingency for any project overages. .~ tt Is anticipated that all projects will not be fully expended by the end of the year, and future projects will be contingent on additional revenues. ') '--.J 2011 50 $ 29,500 29,500 29,500 254,817 $ 284,317 TOTALS 50 $ 301,329 301,329 1,578 3,373 89,778 238 $ 94,967 1 10 1 1 1 I 1 I ! I o I 1 I I I I 1 10 1 I CAPITAL PLAN 6003 thru 2007 ~ City of Andover, MN Project # 03- TRAIL-Ol Project Name Construct Bikeway! Walkway Conidon Type Useful Life Catego ry Improvement 25 Years Trail Construction Priorit)' Contact Department 1- High Todd Haas Parks & Recreation-Projects Total Project Cost S711,OOO Description I Construct bituminous bikeway/walkway trails along corridors identified in the Andover Comprehensive Trail Plan. 2003. Construct a trait along Round Lake Blvd from Bunker Lake Blvd to 153rd Ave NW (SI25,000) and construct a trail along the south side of Andover Bivd from Hanson Blvd to Bluebird St (S35,000). 2004 - Construct a trail along Bunker Lake Blvd (north side) from Hanson Blvd to Crane St NW (S25,000) and complete the trail system along the north side of Crosstown Blvd from Yellow Pine St to Avocet St (S55,OOO), 2006 - Construct a trail along Crosstown Blvd (both sides) from South Coon Creek Drive to Andover Blvd (SIOO,OOO), 2007. Construct a trail along the north side of Crosstown Blvd from Hanson Blvd to Nightindale St NW (SI21,OOO) and construct a trail along 161st Ave from Hanson Blvd east to the railroad tracks, Also, construct a trail on Hanson Blvd from 161st Ave south to 155th Ave (S250,OOO), Justification I Improve pedestrian and multi-modal access to various destinations within and externally to the city. The trails have reviewed by the Park and Recreation Commission. These trails that are proposed are a combination of interest by the Park Commission and City Council. Expenditures Construction 2003 160,000 160,000 2004 80,000 80,000 2005 2006 100,000 100,000 2007 371,000 371,000 Total 711,000 711,000 Total Funding Soun:es 2003 2004 2005 2006 2007 Total Municipal State Aid Funds 125,000 125,000 Trail Funds 35,000 80,000 100,000 121,000 336,000 Unfunded 250,000 250,000 Total 160,000 80,000 100,000 371,000 711,000 Operationallmpact/Other -I Additional long-term maintenance and snowplowing will be necessary. 55 ( -J\_<'-l ,r ~ '--./ City of Andover, Minnesota Incorportated 1974 ~-1 '-;. J/- i ,- ~~)c, 1--, ~:---' . h I ~~'~ ~ :~~r_~:__~,_ L _', _., r--:~'-; --,/" ~ I CAPITAL IMPROVEMENT PLAN PROJECT #:\ 03- TRAIL-OI PROJECT NAME: TRAIL PROJECTS, 2003-2007 . , -'--1- .1..- '.-j '_, _T_.J-----J, -~-1 .--(" A. ~ . ---r- ~ : :; : /_~_____-+-__-+ _._ ______J..- . . . i {~ --T-:-'-,. ,. I 1_ '~___~---:...)__ --L LEGEND . _ Roads o Lots I Parcels o Water Features l'v! City Limits .~ .-------'- -r----- 2000 0 r-- i-I , . \ i j !_.-L- -L-l_, \....-- - ) , - ~ ,\ .____~, ...;..-.i I i :--;-- ,-- , "'.: ,---j r---i N W+E s 2000 4000 Feet 56 =---.;..--=..:....~-..., I I .--. t J -' J J / J J J , I , , J , J '\ \..J ;J , '\ o ~ Capital Plan City of Andover, MN C2004 thru 2008 ~ ~ Project # 04- TRAIL-Ot Project Name Construct Bikewayl Walkway Corridors ~ ~ Type Useful Life Category Improvement 25 Years Trail Construction Priority Contact Department I-High Todd Haas Streets I Highways Total Project Cost 8809,000 ~ Description Construct bituminous bikeway/walkway trails along corridors identified in the Andover Comprehensive Trail Plan. 2004. Construct the Coon Creek Corridor Trail, west of Hanson Blvd ($225,000) and trail connection with Bunker Lake Regional Park at Prairie Road & Bunker Lake Blvd (833,000 City portion), 2006 - Construct a trail along Bunker Lake Blvd (north side) from Hanson Blvd to Crane St NW (825,000) and complete the trail system along the north side of Crosstown Blvd from Yellow Pine St to Avocet St (S55,OOO), 2007 - Construct a trail along Crosstown Blvd (both sides) from South Coon Creek Drive to Andover Blvd (S 100,000), 2008 - Construct a trail along the north side of Crosstown Blvd from Hanson Blvd to Nightindale St NW (SI2I,OOO) and construct a trail along 161st Ave from Hanson Blvd east to the railroad tracks, Also, construct a trail on Hanson Blvd from 16lst Ave south to 155th Ave (S250,OOO). Justification ~ ~ ~ Improve pedestrian and multi-modal access to various destinations within and externally to the city. The trails have reviewed by the Park and Recreation Commission. These trails that are proposed are a combination of interest by the Park Commission and City Council. - Expenditures Construction 2004 258,000 258,000 2005 2006 80,000 80,000 2007 100,000 100,000 2008 371,000 371,000 Total 809,000 809,000 - Total ~ Funding Sources 2004 2005 2006 2007 2008 Total DNR Grant 100,000 100,000 Municipal State Aid Funds 33,000 33,000 Trail Funds 125,000 80,000 100,000 305,000 Unfunded 371,000 371,000 Total 258,000 80,000 100,000 371,000 809,000 - - , Operational Impact/Other I Additional long-term maintenance and snowplowing will be necessary. , , , " 98 I II I 11-" v II II II II II II II -~ II ~ ~ ~ ~ ~ - ~<) ~ - S'\NDbVE~ City of Andover, Minnesota Incorporated 1974 .-":/:""--.. ..., , I '- , , , i . I. 1'1 I, I; 1: i' I, " -1 , Ii , f LEGEND o Roads o Lots I Parcels o Water Features City Limits N Trail Projects i i I CAPITAL IMPROVEMENT PLAN PROJECT NAME: TRAIL PROJECTS, 2004-2008 ~ Ii I' I , j 'I I :' !~ ~~20061 ' 1..- i" II I ' 'I !: " i i 1 i ~..:;j!.i i ' I t . 2007.. ... ' '.... .. · . . .. . I. I.... I 'I~. "., ; '.)2.00.4~ .: " ' , ' I, . I 1-. ; ! I , - ill' ~ - , ,xo~4l I , I , ' I I I I' i i N W*E s 2000 2000 4000 Feet o 99 I I I j , I I I I I F I ,I , \ \ i I .1 " ,I l I I , I / "Capital Plan C 2005 Ihru 2009 J "'-./'City of Andover, MN Project # 05-TRAIL-Ol Project Name Construct Bikeway! Walkway Corridors Type Useful Life Category Improvement 25 Years Trail Construction Priority Contact Department I-High City Engineer Streets / Highways Description Construct bituminous bikeway/walkway trails along corridors identified in the Andover Comprehensive Trail Plan. 2005 - Construct a trail along Hanson Blvd from 155th Lane to 161st Avenue ($150,000) and construct a trail along Crosstown Blvd (north side) between the existing trail at the east end of Hamilton Square to the existing trail just to the east of Avocet St in Chesterton Commons ($50,000). 2006 - Construct a trail along the east side of Crosstown Blvd from 139th Avenue to 141st Lane ($30,000) and along Bunker Lake Blvd from Hanson Blvd to Crane St ($30,000). 2009 - Construct a trail along 157th Avenue from Prairie Road to Kumquat St ($230,000). Current unfunded projects include Station Parkway from Thrush St to Jay St ($60,000), Silver Meadows development to l66th Ave ($20,000), north side of Crosstown Blvd from Nightingale St to Hanson Blvd ($100,000) and the west side of Crosstown Blvd from South Coon Creek to Andover Blvd $75,000 , Justification Improve pedestrian and multi-modal access to various destinations within and externally to the city. The trails have reviewed by the Park and Recreation Commission. These trails that are proposed are a combination of interest by the Park Corrunission and City Council. . Expenditures Construction 2005 200,000 200,000 2006 60,000 60,000 2007 2008 2009 485,000 485,000 Total 745,000 745,000 '\ ,......) Total Funding Sources 2005 2006 2007 2008 2009 Total Trail Funds 200,000 60,000 230,000 490,000 Unfunded 255,000 255,000 Total 200,000 60,000 485,000 745,000 Operational Impact/Other I Additionallong-tenn maintenance and snowplowing will be necessary. '0 110 II II II II II II II II II II II I II I 1 1/-" 1 1 1 I I I I '-../ / " I~: I I I I II I I" " '--./ I I S'\NDbVE~ Capital Improvement Plan . Project Name: TRAIL PROJECTS, 2005-2009 ~ {1-,!5ffi 1--, 1=")" I ~Ir I Tl : , ~~~09 ~ ~=i - ;~Tri i =r1l f? / /r--J .... . ~ 2005 1: -j IT "\ 1'"' I , , '--- -L~ '~r: .Ll A.T~ l'r )- iN I 'II I I- '::::i=:H -r I _ rT LL tllJ I I ~ "'W,~ > l Ji):.~ h'- f=3 -r ~ .tf.Sr ~ - .,.... \,-\.-- \~ :f;Bb . t11\~'':'" ~ + -1 lIT ~-C! I t "1 iii'i1,! VF , \ I . I l t.. ,,'_ .. : -rrr I I I ::i~UIT~RiD;;) cJ. 11 91 ..~ "- ~~'~Wf ". '" <oo~-c"~t,.t1t;-!{T)f 2009 " v1 . ~Mt~~0fJr i, ~0~6~ ': ' ,-,po' - ,I ,~11~ " - I -.f/ E' crr I " -l ". 2009 ~- T 7" " -c i-' H- ,,J-; -l "'-Jlili '\., " !', .~ ~ 20091 j 6[j'~! l~;; '2009 I ~j' I It!FPi . .;..-- '.J. ~ ;~ ~ fE :f'::~\ ~ .t:.l;. ~ LEGEND GROW .+ s o Lots I Parcels o Water Features N City Limits rzzzzz:::I Project Location 1,500 750 0 1,500 P"""""'"lI Feet 6 ~ -rr ~ iYl \ \.>, 0;1 "1 II J Iv I-- ,k -, r ~~~~I \ '-] ,~ ID -1 __- ~u Il 2?09 (~n~, I JJ:J: Y::aJ II~ 'fA-'- ~ ~ ~~ ,\ ! 2005 II J,\ 'I I! -, , -'" T T I .;\ c..L:: I I I I i I ~.L-l I ~ ~ 'W ctr6~'CRE~K~' ~iki~ -L '~'~~j~-:~f.:: 1*~ ~~n <'..v""i!T , , 06 \?z:s A ""~ l" f--- Location Map ~~~~~ -,~ ~~'~ ~ I Capital Plan I,... City of Andover, MN , I f'rojed# 06-TRAlL-Ol I Projed Name Construct Bikeway! Walkway Corridors l:!:006 thru 2010 ~ I Type Improvement Useful Life 25 Years Category Trail Construction Priority I - High Contad City Engineer Department Streets I Highways I Description Construct bituminous bikewaylwalkway trails along corridors identified in the Andover Comprehensive Trail Plan. 2006 - Construct a trail along the east side of Crosstown Blvd from 139th Avenue to 141st Lane (S30,000) and alongBunker Lake Blvd from Hanson Blvd to Crane St (S30,000). 2007 - Station Parkway from Thrush St to Jay St (S60,OOO). 2008 - north side of Crosstown Blvd from Nightingale St to Hanson Blvd (SI00,000). 2009 - Construct a trail along 157th Avenue from Prairie Road to Kumquat St ($230,000). 2010 - the west side of Crosstown Blvd from South Coon Creek to Andover Blvd (S75,000). I I Justification Improve pedestrian and multi-modal access to various destinations within and extema1ly to the city. I The trails have reviewed by the Park and Recreation Commission. These trails that are proposed are a combination of interest by the Park Commission and City Council. I 10 Expenditures Construction 2006 60,000 60,000 2007 60,000 60,000 2008 100,000 100,000 2009 230,000 230,000 2010 75,000 75,000 Total 525,000 525,000 Total I I Funding Sources Trail Funds 2006 60,000 60,000 2007 60,000 60,000 2008 100,000 100,000 2009 230,000 Total 230,000 2010 75,000 75,000 Total 525,000 525,000 I I Operational Impact/Other I Additiooallong-term maintenance and snowplowing will be necessary. I I I() I I 97 ~NDbVE~ ",/"",, . 1 , '- lV1-~~ i_~ bJ- I\. ?'i -~, H "" t- ./ '" n. ~:. '" :J:' " ",ffiF.. If- .,.." li.' :: -,. \H . I f-- .,I '" ". H rF' ROUN LAKE .~ ' \../ LEGEND ~ROW o Lots I Parcels G Water Features N City Limits c::=::J Project Location ( --- .-... '"' _I::"J .,.. ~ ~ .< Y. .; ~ . .. '" '/ 1 ~. " l- - ,<11 r "'r' { II J:-~IL_L 4,250 -l 2006 .,/",/ I I J J J I J J - J - , , - II I I II II Capital Improvement Plan Project Name: TRAIL PROJECTS, 2006-2010 j r- I - ,.. ~r.r~ ,._~~ Iii T '1 '"1"";.0- ... ..' S 2.125 0 J ~ ] I-- ~~ 2008 , ::'i:~ ".; '(>"j: " ~ 007 4,:250 :::::J I.L '. 1--'-1 , Q '''''::l, \..; ,.), t+ "'" !lI\I-.~j: . w. A. ~ )(. .....,.. , T --.. ~ L JI:: -u. lllJ 10.' ~ - ff. ~... \'t'> '\ r\ f-- - J..... J't. r7 -!O" 1 ~IJ ~ I n- I-- .J. 1.. =-:l;~. !Ii s... -..,,, . ~. p:1: -t I~~ ~ '" , I .,. l..--'" '. I. I ;:1 ." I I -=- liy .~ ..,....,.... U ......T.. Fetlt Location Map rd~ ~J;9n ~~ -~ L! H~ " ~Fa'J ~ ~ I '-, l{n U . f-... In =c '~IL~ IV:-- \, m J ).. ~~ , ," U RliJb:\,- "1 '6'f-' If.. -',- == b~~ r'. ~ ~tL ~ u'.. '-<, ~ "~"" m!;j a;j,JJ ~~ ;-0. ~).. .Ii ~~ f:": !~ft h 'f , " , \ '--...J ;j :' ') \~ Q CITY OF NDOVE 1685 CROSSTOWN BOULEVARD N.W. . ANDOVER, MINNESOTA 55304 . (763) 755-5100 FAX (763) 755-8923 . WWW,CI.ANDOVER,MN.US TO: Mayor and Councilmembers FROM: Jim Dickinson, City Administrator SUBJECT: 2007 Budget Update / Enterprise Funds and Community Center DATE October 24, 2006 INTRODUCTION The Council has had a number of reviews of the 2007 Proposed Budget that will be supported by the 2007 Tax Levy. At the last meeting only a few questions remained and those questions will be addressed through the discussion. The Council did adopt a Preliminary 2007 Tax Levy and General Fund Budget at the September 5th Council meeting. The Preliminary 2007 Budget proposed a total property tax levy of $9,316,427: $6, 115, I 79 (65.6%) operational levy, $1,833,494 (19.7%) debt service levy, and $1,367,754 (14.7%) capital levy. The Council has the right to reduce or keep constant this levy until the final certification date of December 28, 2006. DISCUSSION The following items identifY sections of the budget that have been updated since the last workshop meeting with the Council. Updates are underlined: Personnel Related Implications: A total salary compensation adjustment package is proposed to provide wages that are competitive with other government entities. Human Resources indicated that 2007 wage proposals in other communities for a cost-of-living increase are ranging from 3% to over 4%. Finance/Administration is currently utilizing a 3.5% cost-of-living increase for the proposed 2007 Budget as a place holder. Human Resources provided a survey at the August 29th meeting and will continue to update the survey of increases proposed in neighboring communities and provide updates to the Council if changes occur. Human Resources and Administration will meet with the Public Works Union over the next few months to comolete the wage negotiation portion of the Union agreement. Community SchoolsNouth First: Council requested a report on the activities of Community School and requested that Community Schools provide information on what would happen if City of Andover Funding was eliminated. That was done at the September 26th Workshop. The Council also indicated a desire to see if additional funds could be sought for Youth First. It appears that savings. from what is currently being budgeted. will likelv be achieved in the employee heath insurance renewal (forecasted at 15%. negotiated to around 5%) that can be used to assist Youth First ($6.000 to $8.000), 1 / - '- Other Funds: . I '-J () c.) The attachments to this staff report are budgets and narratives for other funds that will be reviewed with the Council at the meeting. Community Center Budget (Pgs. 3-17) Enterprise Funds (Pgs. 18-34) Erick Sutherland. Recreational Facility Manager and Brian Kraabel will be available to answer questions of the Council at the meeting. The Community Center budget is now able to benefit from past history and the Enterprise funds are generally in line and step with the rate analysis done for these funds as part of the CIP development and review. ACTION REOUESTED The Council is requested to review the staff report, attachments and provide direction to staff. 2 (- "') '--./ 1685 CROSSTOWN BOULEVARD N.W. . ANDOVER, MINNESOTA 55304. (763) 755-5100 FAX (763) 755-8923 . WWW.CI.ANDOVER,MN.US CC: Mayor and Councilmember's J. D.kin C. Ad" ~ -- rm lC son, lty mrmstrator Erick Sutherland - Recreational Facility anager TO: FROM: SUBJECT: 2007 Community Center Budget DATE: October. 18,2006 Revenues ') ~ Ice Arena The ice arena will surpass the budget numbers for 2006. We have increased the expected revenue for 2007 by approximately 10%. Ice time continues to sell out from late August through mid March. Staff continues to look at other outside users and in house programming to increase revenues during the spring and summer months. Field House Much like the ice arena the field house will far exceed the budgeted number for 2006. We are increasing the budget number in 2007 by approximately 70%. The field house's prime hours are sold out from Dec through mid-April. We have established some great relationships with our main users and honestly could probably sell another court or two during the winter season. Staff continues to look at ways to sell day hours during the school year and also expand our summer rentals through programming and outside users. Concessions Having now had a full year in the concessions we are better able to predict the times and type of events that will generate the revenues needed to open. The biggest thing we learned is that the summer months were very slow, and we can't depend on much business from the Y side. Weare expecting the concessions to show a small profit for 2006 as well as 2007. C) Advertising This is one area that we hope to continue to expand through new sponsorships. All the dasherboards on the west side of the ice arena have been sold, and we are now moving to the north end. Both the Zamboni ads as well as the ice arena scoreboards still have three years left on their contracts. The field house is one area where we hope to add more advertisers. (3) ,,--) 'o"",J Expenses Utilities Utilities continue to be a huge issue at the Community Center. Staffhas spent many hours over the last two months reviewing all the utilities and making adjustments to equipment and settings where needed. Staff has met with Connexus, Center Point and Honeywell to get some things worked out. The biggest issue being the continued, research on gas feedmg the boiler room and how that cost is not being shared with the YMCA. More to come! Other Other costs have started to stabilize. There were a fair amount of supplies and operational needs still in 2006. At this point we feel most of those items have been purchased, and we should just be keeping our inventory on useable products. We do need to keep aware that most of the warranties are now expired so any mechanical breakdowns could lead to some higher bills for parts and some labor. We have budgeted for some of that in 2007, not really knowing ifit will be needed. ,-~ "--j Respectfully submitted, Erick Sutherland ,-j '--' C0 . ') . --..J . ') \. .....J ,,) INTEROFFICE MEMORANDUM TO: ERICK SUTHERLAND FROM: DATE: CINDY RAMSEIER SUBJECT: 9/19/2006 MEETING ROOM RESERVATIONS The amount of time staff has been spending on booking meeting rooms has increased dramatically this past year. Most civic groups are planning a year's worth of meeting dates. The majority of reservation requests that have been taken are from local non-profit groups. Reservations from an existing customer can take anywhere from 2 minutes to a Y2 hour or more depending on the number of requests being made. Additional staff time is spent creating new customers, sending out schedules, invoices, meeting room guideline policies, posting revised schedules and cleaning up after the meeting. I feel staff has been spending at least 15 hrs/per week on meeting room requests and maintenance. cD ) -'.J Community Meeting Room Booking Procedures For Staff · Receive request via phone or email · If new customer, create new customer profile in Max · Book Reservation utilizing Max software · Send customer via email or by USPS a summary of the reservation/invoice -\ ~- ../ . For first-time customers, send a copy of the Meeting Room Guidelines requesting that the back page be signed and returned to ACC. File returned completed forms in 3- ring binder. · Print out meeting room reservation calendars for: Meeting Room A Meeting Room B Ice Arena Conference Room . Follow-up with customer if Meeting Room Guidelines sheet has not been returned prior to first date of reservation. . Track invoicing - enter payments into Max, put a copy of invoice and check payment in receivables file · When accepting a customer's revision, make sure: They have updated summary/invoices Update calendar and post as often as needed '\ '-.j . Attendant, check meeting rooms before and after each reservation: Set-up room as specified by "paying" customer Clean as needed (vacuum, dust) Tables back to conference style Wall divider Extra chairs/tables 15200 Hanson Blvd. NW · Andover, MN 55304 Ph: 763-767-5100. Fx: 763-755-2129 Website: www.ci.andover.mn.us · E-mail: accinfo@cLandover.mn.us (f) ..... ~ 0 '; ~ ~ ~ ~ ~ ~ ~ "& 0 0> 0 0 0 0 0> - = = 0 0 0 = 0 0 0 0 0 0 ...... "- 0 ... c:i 0 0 0 c:i 0 c:i :,J '" c 0 ~ 0 ~ ~ 0 0> ... 0 t:l.., 10' 0 0 " 0 0 0 0 = 0 0'1 C 0 = = 0 0 0 = 0 ... C I C c:i 0 0 0 c:i 0 r..: ~ " , ;>- GI'l .... .... GI'l GI'l .... M '" , " r-;. ...... C>; 0 ~ ... 0 - GI'l "'" " 0 '" Qll ... .S c ~ ~ ~I = 0 0 0 0 0 0'1 " = 0 0 0 = 0 ... e c:i 0 0 0 c:i 0 r..: E: GI'l .... .... .... GI'l GI'l 0'1 GI'l " .c - I (. .S = 0 0 0 0 0 = = 0 0 0 = 0 = ::t '" c:i 0 0 0 c:i 0 c:i - GI'l .... .... .... GI'l .... GI'l c /\.. " ;>- f;I;l ~ .. oS I 0 ~ ~ = 0 0 0 = 0 0 .. = 0 0 0 0 0 0 0 , 0 c:i 0 0 0 c:i 0 c:i J ~ :I: GI'l .... GI'l .... GI'l .... l"'l J -;:l ""~ ~ :; ... r. GI'l \1 '; '$. ~ ~ ~ '$. ~ '$. () ~ - - I- - '" '" l- I- l"'l '" 0 "" '<I; 00 "<t "<t "<t ... r\ = ... ro U 0\ 0 r-.: c:i 0 ..c 4l ~ -- - 0> C - 0 ~I z = 0 0 0 = 0 = :.) ....... ~ ~ -i ..0 gc) 00 ~ ~ "" N - N = ... - ... -< 0 - - - - 0 M 0 '; '$. ~ ~ ~ '$. ~ ~ 0 0> ... - = 0 0 0 0 0 = - 0 , 0 = = = = = = = ... - " ... c:i 0 0 0 c:i 0 c:i ~ ~ Qll ~ = C .... .. 0> ... ~ -< ~ ~ = ; = " = 0 0 0 0 0 0 '" M e = 0 0 <::> <::> <::> <::> ~ ... E: c:i 0 0 0 c:i 0 c:i S GI'l .... .... .... GI'l .... l"'l ....... .. ~ - oS 0 .. .. 'OJ ... CI:l = GI'l .... .. "0 .. CI:l 'C .. " r. = < - r. .. '" U .:= = ~ ~ ~ ~ '$. ~ '$. t ..... .. 0> - , "0 - I- - '" '" l- I- l"'l ~ = e -< ~ "" '<I; 00 "<t "<t '<I; ... ,... ~ .c Cl: '" 0\ 0 r-.: c:i <::> ..c c.... .. ~ = ...: = 0> ~ -0 = 0 ~ 0> ~ " u :I: U '" ~ e ~I => => 0 0 => 0 => ~ -i -i ..0 gc) 00 ~ C ~ ,;; Cl: "" N - N => S " ~ ... - ... = 0 ... ';; ... = = .... .: e CI:l = = 0 e ~ 0> -< ~ e u u U ~ .: , ~ == ~ IX! e = e >- 01) .c CI:l ,5 Q CI:l ....... Cl: c 0:; I- ~ 0 U Cj => :3- .;;; ;>- ... ';; ~ .... => 'i CI:l ~ = ... e - .r- '\ - ... ... " '" .... Sl e " CI:l >. '--" ' ~ ~ 0 - 0 " 0 ~ .... u c U ~ IX! 00. 0 .. ... " - " ~ .. Q - < c > ~ "" .. e " "'-l 0 'a '; " - "C => ;,; " 0 ;>- '" > t.= ell ~ e u ';;: ;>-. .c 0 0 => - f;I;l " - "0 .. = ~ '" ~ 0 = U U "0 C " ~ ~ CI:l '<) - -< -< ~ ..:.: ; -< ... '" U '" .. ~ ....... .. = U .. 0 0'1 ... U -< =:I r. ~ ~ .~ ~ ~ ~ ~ '$. ~ ~ ~ ~ ~ ~ 0> " " '" I- 0 0 = 0 0 => 0 0 0 0 0 0 t-; 00 "<t 0 => 0 <::> => 0 0 0 0 <::> <::> on ..0 r-.: 0 c:i 0 0 c:i 0 0 0 0 0 0 N \0 0'1 0 0 0 => 0 0 => => 0 0 0 0 0 '" C! 00 0 => 0 C! => 0 0 0 <::> <::> <::> -.i- on r-.: 0 c:i 0 0 c:i 0 0 0 0 0 0 "<t on N .... GI'l .... .... GI'l .... .... .... .... .... .... "<t - - .... - .... .... '" 0 0 0 => 0 0 => 0 0 => 0 0 0 "l C! 00 0 => 0 0 => <::> <::> <::> 0 0 0 "<t on r-.: 0 c:i 0 0 c:i 0 0 0 0 0 0 N \0 .... .... GI'l .... .... GI'l .... .... .... .... .... .... .... .... 0 0 0 0 => => => => 0 0 0 0 => 0 0 0 <::> <::> => <::> 0 => 0 <::> <::> <::> <::> <::> 0 0 0 0 0 0 0 c:i 0 0 0 0 0 0 .... .... .... .... GI'l .... .... GI'l .... .... .... .... .... .... => 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:i 0 0 c:i 0 0 0 0 0 0 N '" N .... GI'l .... .... GI'l GI'l .... .... .... .... .... "<t o. - .... - .... .... ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ 0 - I- "<t 0> - on 0> \0 00 '" '" '" N I/'l => v: "! '<I; "l 0Cl t-; - I- "<t 0; on t-; on - - '" 0 0 c:i 0 0 ..; 0 - 0 N 0 0 l"'l - I/'l on v: on C! 0 I/'l 0 on r-; on 0 0 N 0 C! on -.i- 00 ..0 ~ N N ... r-.: 0 0 ..0 0\ N N on - ... - l- I- N - "<t I/'l - ~ ~ ~ ~ '$. ~ ~ '$. ~ ~ ~ ~ ~ ~ " l- I- \0 0 0 0 <::> => 0 0 0 0 0 0 t-; 00 '" => = => => = <::> <::> <::> <::> <::> <=> on ..0 r-.: 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 = 0 0 = 0 0 0 0 0 0 N '" N .... GI'l .... .... GI'l .... .... .... .... .... .... "<t o. - .... - .... .... ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ 0> 0> 0 - I- "<t I/'l - on = \0 00 '" '" '" N v: "! "<t '" 0Cl I- - I- "<t 0; V) l- V) - - '" 0 0 = 0 0 ..; 0 - 0 N 0 0 l"'l - I/'l on v: on C! 0 I/'l C! v: r-; on 0 0 "! 0 0 on -.i- 00 ..0 ..; N N ... r-.: 0 0 \0 0\ N N on - ... - l- I- N - "<t I/'l - .!::! S- o - '" g ~ '" ~ .. -< ~ e " "0 .5 0 '" 0 ..g '" ... " ~ 0 '" 00 15.. .. .... <::> I- U >. ~ 0 \0 \0 ~ " " 01) C 0. 0. .. ~ u ,5 0 u ....:I " 0 0 B US '" - e e e '" 0 " " - ::I: >. " ~ 0 ... ... 0 " <B ~ 0 ~ ~ 0 " 0 :.:l '" IX! - - IX! "'" '0 :E = = '~ .. - ii .. .. 0 0 CI:l ~5 "'" 0 " " " 1 .c Cj > t.= > > u u ::I: u 0 .!!l " CI:l 0 0 ~ 0 0 CI:l CI:l '" g ~ OJ VJ "0 .. "0 "0 >. >. >. ~ ~ ~ c ~ 0 0 0 0 c Z ~ .c c -< -< IX! IX! iXI - Qll == 0 z ~ u 0 .s 0 ~ 0 = .9 " "0 '" 0 E <=> = 0 E .... .~ ::E '- 0> ~ = '" e 0 0. <::> .. 0 ~ .... .~ e- o 0 C 0 ~ 0 .... ::E ;>, .c '" ~ 0 ,. 0 0 0.. 0 0 .... ~ \0 oq v: - '" ~ o o o o o o .... ~ \0 oq v: '" ~ .5 0:; 01) ;g .. IX! (]) "" ~ "; 'Ci' - 0 '" "- E- ~ ., c ~ ~ ~ ~ Q., '0' ... C '" C = ~ ... 0\ > ...... ... C5; cz:: - '1::l ... 0 ., lOll E- - " ,5 01 ... cz:: Q., ~I ... e E= ... .c - I ,5 '" - = ... > ~ .. oS ; '" .. '" ~ 0 == - -= 'y ~ 01 ~ "; ... - '" 0 '" E- U ~ ... ~ = - 0 il z ~ ...... :; < <:> '? I N "; .... I ... - 0 I 0 .. ... ... E- ~ :; lOll ~ .... = ~ < 01 ~ ~ <:> cz:: I <:> ... '"' M e ~ .... E= 5 ...... .. ... oS 0 01 oS .... CIl = " 'C '" ';: .. ... = -< ... ~ " '" U ~ '" l. ,;; ,_ 01 'C - I .. < ~ (l) ~ '" Ii ... .c Cl: '" Q,E- .. ~ = ...: '" ~ >> . = 0 (l) Eo-; 1l 0 == u U '"' ~ e il ~ ~ ,;; Cl: 5 " ~ '" 0 E- 'Ci .... = = .... cf e '" = = 0 e :; 0 e u u cf , >> == e '" ,Q CIl e Q '" ...... Cl: CJ I' ~ U .. <:> 'Ci .... <:> '" ~ = /.~ l. .. .... e .... t:! e " ,--"I (l) ~ 0 ~ .... III U 00. 0 E- .. Q ... -< " .. e "C ~ ~ ~ " I:lll <:> 0 <:> ~ e ... = ~ ~ 0 '" '" '<l ... '" I -< .... '" u ~ ...... oS '" 0\ ... U "t!- "t!- "t!- ~ ~ ~ "t!- "t!- o 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <A <A <A <A <A <A <A <A 0 0 0 <:> <:> <:> 0 0 0 0 <:> <:> <:> 0 0 0 0 0 0 0 0 0 0 0 <A <A <A <A <A <A <A <A <:> <:> <:> <:> <:> <:> 0 0 0 0 0 0 0 0 0 <:> 0 0 0 0 0 0 0 0 <A <A <A <A <A <A <A <A 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <A <A <A <A <A fA <A <A ~ "t!- ~ "t!- "t!- "t!- "t!- "t!- o 0 0\ .... "" 0\ 0 ~ - ~ ~ t-: .... N "" ~ I' "" 0 0 .... 0 N .... 0 "" on '" ~ N ~ on ~ 0 '" .... N 0; on r..: 00 l'i on .... .... '<t .... .... ~ "t!- "t!- "t!- "t!- "t!- "t!- "t!- ~ 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 0 0 0 0 0 ~ ~ ~ ~ ~ ~ ~ ~ 0 0 0 0 0 0 0 0 <A <A <A <A <A <A <A <A "t!- ~ ~ "t!- ~ ~ ~ "t!- o 0 0 0 0 0\ .... "" 0\ 0 ~ .... ~ 0 I' --: N "" ~ I' "" 0 0 .... 0 N .... 0 "" on '" 0 N ~ on 0 0 '" .... l'i 0; on r..: 00 l'i on .... .... '<t .... .... ~ .. " .,. ~ 0 0\ ..... I' 0 ",. 00 .... 0 ",. .... "" ~ '(3 ~ ",. M .... ,.,. " 0. 0. I' C. .... u S -0 "" 0 0 ., ., 0 0 .... e ~ 0.- 0 " e e 'lj, E- '" '" U .....l E- E- " " ... ... '" '" '" '" " " " " 0 0 0 0 .~ .~ '~ '~ u u u u CIl en en en e 0 0 0 .D .D i: :E .. .. .. '" '" is co co co co u u 0 "t!- "t!- o 0 0 0 0 0 0 0 0 0 0 0 <A <A 0 0 0 0 0 0 <A <A 0 0 0 0 0 0 <A <A o 0 o 0 o 0 <A <A "t!- "t!- ~ 0 0 '" 0 ~ '" .... on N ~ ~ 0 0 0 0 <:> ~ 0 0 0 0 0 ~ 0 0 fA <A "t!- "t!- ~ 0 0 '" 0 ~ '" .... on N I' I' 0 0\ .... "" 'lj, .... C. 0. 0 0 0 e .. E- E- ... " '" 0 0 u u en en :E :E 0 0 "t!- ~ ~ "t!- "t!- "t!- "t!- o 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 0 0 0 ~ 0 0 0 0 0 0 0 0 0 0 0 0 <A fA <A <A <A <A <A 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <A <A <A <A <A <A <A 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <A <A <A fA <A <A <A 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <A <A <A <A fA <A <A "t!- "t!- "t!- "t!- ~ "t!- "t!- o "" 0\ N I' N N 00 on "" .... '<l: .... I' .... 0 .... 0 0 0 0 0 on 0 0 0 ~ ~ N ~ 0; l'i l'i 00 N l'i "" M .... "t!- "t!- "t!- "t!- "t!- "t!- "t!- o 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 0 0 0 0 0 0 0 0 0 0 0 <A fA <A <A <A <A <A "t!- "t!- "t!- "t!- ~ "t!- ~ 0 0 M 0\ N I' N N 00 '" "" .... '<l: .... I' .... 0 .... 0 0 0 0 0 on 0 0 0 ~ 0 N ~ 0; l'i l'i 00 l'i l'i M "" .... '" -0 .. " 0 > 0 '" [;i is -€ .D .. E::: ..!.! 0 N on '" " .D N "" U ~ -5 '2 fn M ~ " ;;; " '0) 0. 0. .. C > " " '" Z 0 0 ... en ::c: ...., e ~ '" .. ~ 0 " [;i ~ E- o .:: ci'i " ... co Ci3 .;:: 0.- '" en '0 E ~ 0 0 'OJ u u ::c: c. " " en en u g '€ '> '" :a :E :E :E " " 0 ~ 0 0 0 :; :; Z 0 ~ "t!- ?t. "t!- "t!- o 0 0 0 0 oS <:> <:> <:> 0 <:> 0 0 ~. 0 0 0 0 0 = .2 :; '0 Cfl <:> 0 <:> 0 0 e <:> 0 <:> 0 0 = 0 0 0 0 0 E fA <A fA <A <A .~ ::E ... 0 tl = '0 8 <:> 0 <:> 0 0 0. <:> 0 <:> 0 0 oS 0 0 0 0 0 @ fA <A fA <A <A " .~ e- " <:> 0 <:> 0 0 C <:> ~ <:> 0 0 '" 0 0 0 0 0 1:; fA <A fA <A <A ::E ;>, "" '0 ~ " i< 0 <:> 0 <:> 0 0 "- <:> 0 <:> 0 0 0 0 0 0 0 fA <A fA <A <A ?t. "t!- ~ "t!- "t!- ~ III on .... '<t 00 .... .... .... "! .... 0 0 0 0 0 III on <:> 0 ~ N l'i r-: ..,f M "t!- "t!- ~ "t!- "t!- ~ <:> 0 <:> 0 0 <:> ~ <:> 0 0 0 0 0 0 0 <:> 0 <:> 0 0 <:> 0 <:> ~ ~ 0 0 0 0 0 fA <A fA <A <A ~ "t!- ~ "t!- "t!- ~ on ~ '<t 00 III .... .... .... '<t N .... 0 0 0 0 0 III on <:> 0 ~ N l'i r-: ..,f M ;;; ;;; ~ ~ ~ ..!.! '0 ..!.! '0 0.- > > ~ '" .. ,.,. "; -0 0 u ... '€ '~ ., = ::: " i:O ...., cz:: "; 01 .. " U ..Cl ,.,. " ... U >. 0 on ., ..!:! ~ 0 > < ez:: ';: '0 @ 0.- > .... ~ , '; ~ ~ ~ ~ ~ ~ ~ ~ ~ u c c c .E "& , ... <=> 0 <=> <=> 0 0 <=> <=> <=> , 0 <=> 0 <=> 0 0 <=> 0 <=> <=> ,,; .... "- , E- o:; 0 0 0 0 0 0 0:; 0 " <) ., <::l , ~ .2 ~ " 0 " '" c <::l 0 "0 c... 0 '" '0' 0 .. <=> <=> 0 0 <=> 0 0 <=> 0 0'1 e <::l 0 = <=> 0 0 C! <=> 0 0 <=> 0 ... " <::l = 0:; 0 0 0 0 0 0:; 0 r-: e ~ 0 " 0 0 .. ~ fA fA fA fA fA fA "" fA N .~ 0\ 0 " r-;, ..... ::E ~ 0 ~ ... '- 0 ... ~ 0 "':l " 0 1:) ~ OJ) E- = " .S "" OS e <t ~ ~I <=> 0 <=> 0 0 <=> 0 <=> <=> 0'1 '" " <=> 0 0 0 0 <=> 0 <=> 0 ... .. 5 0:; 0 0 0 0 0 0 0:; 0 r-: @' E: ~ fA fA fA fA fA fA ~ fA 0'1 " ~ "" .;: " Eo -= " ... I <=> <=> ;: .5 <=> <=> <=> 0 0 0 0 0 '" <=> 0 0 0 0 0 0 0 0 <=> ~ '" 0:; 0 0 0 0 0 0 0:; 0 0:; ... ~ fA fA fA fA fA fA ~ fA ~ ::E = ;., " .. .c '" "" e ... " .s i< ~ ~ <=> 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 "" fA fA fA fA fA fA "" fA '" ~ -; ... Iioo ~ '; ~ ~ ~ ~ ~ ~ ~ ~ ~ c '" '" '" ... ... '" N 00 N r-- 0\ '" 0'1 0\ '" 0 '" C! "'! ... "'1 '" "'1 = E- N 0 0; '" U iii ... 0 N ,..j '" ~ "" ... ... ... ... c = - 0 il III V) Z N 0 0 V) r-- lrl V) III V) III / "- .... r-: vi 00 0 ..0 '" '" r-: ...: ..0 '-~ :; \C> r-- 00 ... '" N '" III V) 0'1 r-- ... '" \C> -< ... <=> <=> M I '; ~ ~ ~ ~ ~ ~ ~ ~ ~ c c ... , ... <=> 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 ~ :; OJ) ~ .... c ~ -< OS c ~ <=> ~ ; <=> " <=> 0 0 0 0 0 0 <=> 0 <=> l. 5 <=> 0 0 0 0 C! 0 <=> 0 <=> ~ N E: 0:; 0 0 0 0 0 0 0:; 0 0:; ... e ~ fA fA fA fA fA fA ~ fA ~ .... ... ... .s Q OS " ... .... rJl " ~ " '0 rIl 'i: ... " = < ... Iioo " '" U = ";!. ~ ~ ~ ~ ~ ~ ";!. ~ ,;; ~ ..... OS - , '0 ... '" N 00 N r-- 0\ '" 0'1 0\ ... -< ~ '" C! '" ... '" ClJ = E N "'1 '" "'1 ...... ~ -= co: '" iii 0 ... 0 N 0; ,..j '" c..E- ... ~ "" ... ... == ...: = c ~ -0 " 0 ClJ Eo-; c:> ::c " u III V) U l. ~ e il N C! 0 V) r-- lrl lrl III V) III ~ ,;; co: r-: V) 00 0 ..0 '" '" r-: ...: ..0 .c \C> r-- 00 '" N '" III V) 0'1 e " ~ r-- ... ... '" \C> ,I = '2 ... ... Q E- " == .... .: e rIl = = 0 e :; 0 e u u - .: = ~ = '" " s e = E ..c rJl e " 0 = ~ (,) 0- E- .... co: 0 .~ 0 0 rIl r-- ~ .~ 0:; '0 U C.l <=> ~ " .. !E c .. <=> '2 rn " OS .... ~ " '" '" >. ... Cl 0 ... rIl e :S (,) OS '" " ~ " r,""",\ - .. ... .~ '0 .0 .... e "' -5 , ~ " .8 :E " E i5: '--./ ClJ ~ 0 = .s = >. ~ .... III U C" " 0 " 0 00. 0 , E- ... -< -< a:l ~ :; >< ..:0: .~ 0 ... < " CJ ... ... 5 -< -< -< -< -< -< 0 ... "C ~ \C> ;.; " ::c (,) :s bJl <=> 0 U U U U U u '.5 <=> ~ 5 ... -< ..., == ~ ~ 0 '" :; ~ ~ ~ :; :; -= "' 'C> rIl '1j ... = U >< >< >< ... 0 0) , -< ... '" U :; = ... ;:J .... " = 0 .;j 0'1 ... U >< >< "\ J /:J Cll o C l'll l'll In " c ::s LL c t/) Cll OJ C t/) " l'll "C.c C::s(,) ...::sLL" Cll LL ... C >Cll,Sl'll o ::s C t/) " C Cll Cll C Cll (,) ... <( > ::s .... Cll ~::: ~ a:: 'c -g +,.'- ::s .- l'll ~ Cllc. (J .- r;; o E >< 8.ow CJ)(,)t/) Cll ::s C Cll > Cll a:: .... o - C Cll E Cll - l'll - CJ) '\ \..J "0 jg.f"- 0.0 00 "ON <( !!l III to E 0 ~ 0 N W "0 .m<o 0.0 00 "ON <( Iii Il'l ::l 0 - 0 0 <( N c 0 ~ .... 0 II) Ql 0 -- -- 0) 0 0 0 0 ..... MOOOO M 'It I'- to I'- 0 0 0 0 N COLOONO II) I'- N 0 II) LO I 'it. 0) 0) M 'itLOLO'itLO 'It N I'- 'It I:IS ~ 'it I:IS 0:) 0 ci~~N'LO ...: ...: ..; ..; II) LO M CO CO M OCONLO...... I'- M ..... CO M LO ...... to to M M M I'- N 0 to - - ..... ~ ~ -- -- -- ..... 0 00 0 0 0) OOOLO II) M CO 0) M 0 00 0 0 to MOOO M ..... 'It I'- 'It LO 00> 'It 'It 0) NLOLOM I II) 0 II)~ ~ 0 N LOa I:IS CO" I'-~ r--" N. LO 1'-. N ..; to CO N I"- ...... LO 0 0 CO LOO>MI"- to CO .., II) LO .............. I'- I'- to N M I'- N 0 M - ..... ~ ~ -- -- ..... 00 0 0 0) 'itOOLO 0) M N M M 00 0 0 to ......000 ..... ..... M to 'It 'it. a. I 'It 'It 0) tOOI"-N I II) 0 II) II) 0 'itN uS uS II) ~C"io:)ci to ..; 0 ..; N .., 'It 'It N LOM...... ...... ..... CO 0 I'- - LO II) II) II) N M to N 0) M - ~ ~ -- -- M 0 MN 0) to II) CO ......I"-O>OM 0 0) 0) ..... N I"- 'it...... M ..... II) I'- ...... 'it ON...... 0 0 0 M I'- LO MCO CO N 0 I'- I"-l"-tONtO 0) M N 'It uS r--" N'r--" N ..; ...: M air--"aiC"iai 0)" ..; ..; 0 I'- 0>...... M N N 0 COCO ...... CO M N N 'It M.............. II) II) 0 ...... M II) 'It 0 - ..... ..... ~ ~ UI UI Gl Gl U UI .... ~ :I ..... 0 .. M tn Gl ... ..... .c .. II) - Gl ~ Gl OJ 0 .c .c Ol E I'll - .... 'C ::s 0 III C Gl II) .c UI l: II) 'C Iii () l!! C'lI U I'll OJ C .;:: II) UI Gl ., 0 OJ UI C'lI OJ OJ "0 :I Gl C .~ E Gl II) - 0 c :!:: .. or ::s UI ili OJ III '~ III 'C :I or 0 c UI Gl 0 :2 c :!:: U OJ 0 :is '~ II) U l: tn E II) Gl Gl :I UI OJ OJ >- Gl - 'C l: ::l > U c ..!!! Gl "0 tn 0 III a. ::l c .!!! .... - 0 Gl .. E Gl .. OJ C '~ :;:; lC UI 0 Gl .!!! I'll UI .E c OJ IX: :I > C'lI :I tn III "0 ::l W Gl a. I'll Gl OJ C 0 l!! :!:: OJ 0 UI II) m :I II) ..!!! tn Gl ~ "0 Iii II) II) OJ ~ .... lC m c OJ E iii .2! IX: c c .!!1 III tn S iii .2! w 'tJ Ol - Qi .. II) 0 - .c .... .. II) 'tJ Gl .... II) - Gl Gl - Gl iii l: > III OJ 0 0 c C'lI C'lI a. II) 0.0 OJ .- 0 c l: .!!! I- .c III - - .... a..... .c ~I- .c III - ::s Gl .c > - .... 0 0 lC OJ ::l ::l 6 - .... 0 ::s u.. IX: () E :2 0 l- I- I- W c.. en c.. () 0 l- I- u.. @ o " \J , '" '--..J .. oS Ql C ::::s Ql c U Ql >-> ... Ql 'c c:: ::::s- E .!!! E lil o Co UUl Qj 'C o U a:; Co >- I- 2:- U oS ~:;:; ::::s U lJ..<( .. Ql Cl ell C ell :!: >- = 'u ell lL. C o :;:; ell Ql .. U Ql c:: -0 ctl Ol J: 'E Ol E t:: ctl Co Ol Cl 2:- ~ '2 :: ::::s Ol 0 E..c III E I- c Quig UCell <( ,Q Qj ~gj8' ""OlOl ,>-u..c ~5- ~ u CD 0'C'C 'Ccc C ctl ::::s <(OlIIl Q) ~ ': :;oJB -..cc o'COl IIl-U cJ1>- o ... :;::; cO "2 ~ c: ~ Ol ~ E 8'ctlE Ol Ol 0 ..c,~ U -OlOl .9== 0.2'-15 - .. C ctl C 5'5,Q u.Q15 1615 Co 'C Co III 5 L: ~~ ex: .....21iiu ,!!1 ai 5-:2 ~Uctl>- :~ ... ... -< -; ... .. = .. c; 'C Ol C U ctl >'''''C c: Q) :gID~U ::::s l;::: Ol '~ E Ol ;;: Ol E..c 'C III ol-Ol_ ucti=-g Q)C(/)"'O =~:;:Q) .....(O:::J_ o III 0 C (/) (.) .... Q) c: .- J!:! () ~ omen>.!! :;:; .J:: r::: .-== c: ~-~C:Q) a>C5.....:::Ju CoIllIllE>- oc..cl-E,,=, Ol 0 0 C .J:::;::; 'U:::J -ctlll) E tlQjo~E ctJ c.~ ..... 0 l:;o.....ou o ~.(/)..... Q) -.....:::J"'C.s:::. "ltcC)m..... a 0 :::J ._ '- oE<(ili.E Noc_Ol c .- >- ,- ~ m > .~ 'COl _ C ..'!! c: ..... 0 .Q x Q) co U)..... cucn ~1ii~:::1J U,- III ctl Ol ""C~8"~"C 5 8~cctlm - - ::::s 3:~.;:!1Il2 Q) 0 en:; ctJ CNCQic:_ ctl ,3: III .s .~ 2 ~ ~ .9 .!!1 ai 5 III ~ ~ ~U..c.c_ "C GI III ::::l III III GI U o .. lJ.. Cl C :;;: "Cm"Cctl IIlC"E - 0 ctl Q)=o~ c.ro[Dctl E ~ c:-iil o U 0 = U III III 'S: III c:: 'S; ;> ctl 1Il"C 'C 3:..c<(c -..ctl "C >. Q) ..... ffi..o"Effi -.r'ClIlc o ~U oS o ctl >- E Nc::!:::.... CctlcOl ~ E ::1 +( III III E Cl t::.cEg ctl_o_ iil~Uctl c: >. Ct'I .~ .Q "=' >- <( OTI:':U 2 ~"5~ iil 1Il.- >- C .J:: ~ Q) 81-~..ca:i .. '01-0 Ol ll)..c ,0 "Eo_=-=N Ol ~ 'j: g .!: u..........:::Jen >.00>0..... -== ..... C>>() ffi '5 IIlE ~ 2:- E E ctl .- >- E:2U ctl E~>-IIlCo o .......c0) uQ)::::.....U) Q)=~-gctJ ..c C lL. ctl ..'!! I- ._ r-c.: o~ 0;;.- "'0 00 ~Z 1-< ~ o~ 00 <>- I- < I- o 1-""' ~~ oZ oZ ;:,i [D u @ :-J CITY OF ANDOVER Budget Worksbeet - 2007 I , COmmMnUy ulfter I I 2130- , , Au...... Actual I Actual I A...... , BodEd ........ Ileq-'" Number DesaiDtioa 2003 , 2004 , 2'" 2006 2006 , 2007 , , Communi ',......, I I I ............. I , , I , Investment Income I 56910 In_ Eam<d I 4,801 3,109 I 2,000 (15,000) 56920 Valuation Adjustment I 15,453 (15,453) , . I Investment income I I 20.254 I I (12,344 , 2,000 , (15,000)1 I I I I I MisceUaneous Revenue I I 58]00 : Refunds &, Reimburnements . , 38,671 58105 """ . I 289 I 1,500 58125 Donations - i 1,000 58130 Donations - Restricted . I 97,646 I 50,000 fi(),000 50,000 'MisceUaneous Revenue I I 137,612 I 50,000 I 61,500 50,000 , I , 'Other Financin,g Sources I 59100 1~J!Transfersln 500,000 4,2161 . I Other Financine Sources I 500,000 I 4,216 i I . , I , ITotal Revalues . 520.,2..";4 129.434 52,000 I 46_ SO,ooo I I '-:'Eip;;.;.;;;;;;;:~--' , I I Illeuanm<o>w I 61320 IAnnuaIDues/Licenses I . I I - Illeuanm<o>w I I . I I . I . I I I I Other Financin,g Uses I I 67101 I I Ooemine. Transfers Out , 434,309 284,013 I 284,013 237.274 I I Other Financing Uses I I I . , 434,309 I 284,013 I 284,013 I 231.274 I I I I : Total EJ:peuditures . . , 04,:J<l9 184,01] I 284.o11 237,2'" I I I I Nellntrease (Dec':rease) in FB . 520.2..-"4 (304,825) (232,013)' (231,513) (187,274) I I I I I I I I I I I I I I I I I I I I ITotal Rn'alDm I 549,937 , 527,054 I 546,400 I 708,400 6118,900 I I I ITotal EJ:peaditures I 73.213 I 1,024,209 I 901,332 I 1,046,548 1,014,721 I I I iNet lnr:reue (Decreue) in FB 416,724 , (491.155) (354,932)' (338,148) (325,821) I , I I 476,124 (491,155) (354,932)i (338,148) (325,821) I I I I Fund Balanu I I I BezinniD! . . I 416.12.4 (20,431); (20,431) (358,519) Eodin! - 47'-124 (20,431) (315,363): (358.,519) (684,406) I I I I Charges for Services 29,683 391,510 410,000 I 572,500 554,500 I investment lnr:ome 20,254 I (I2,344)I 2,000 i (15,000) I Miscellaneous Revenue I 131,612 134,400 I 150,900 134,400 I Other Financing Sources 500,000 4,216 . I I I 549,931 I 521,054 I 546,400 I 108,400 688,900 I I I I I ~^^""o;., Eip..;...;.;;;e,'. I I. n ~"" ~. I I Salaries & Benefits 40,551 189,711 254,614 I 257,230 300,483 I Deoartmental 22,834 61,141 35,200 i 92,500 84,550 10pera1in2 9,026 313,220 312,505 I 371,305 352,420 I Professional Services I '02 9,609 15,000 i 35,500 24,500 ICapital Outlay . 9,613 I 15,500 I Other Financim! Uses - 434,309 284,013 I 284,013 231,214 I I I 73,213 I 1,024,209 I 901,332 I I 1,046,548 1,014,721 I I I 476,124 (491,155) (354.932)1 (338.148), (325.821) "" \J '\ "-.J @ 10/19/2006 '~J " <) r, '-.-/ I Communily Center Acc:ouat N~ber Dcsc:riDtiOB 'I 55570 ICharges for Services Vending Revenue I CharRes for Services 58100 MisceUaneous Revenue I Refunds & Reimbursements I Miscellaneous Revenue I ITotal Reven.. I t ^^^:i~~^"7': i Salaries & Benefits ' ISalaries-R I FICA I Medicare I Health Insurance IDentallnsurance lure Insurance IlonR-Term Disability IPERA IWorken Como Ilnter-CitvLabor Allocation Ilnter-Citv Labor Allocation I Salaries &; Benefits 1 I Departmmtal I Supplies - General : Supplies - Otleratin.e I Supplies - Cleaning . Supolies - Diesel Fuel I IR & M Supolies - Genera1 I I R & M Suonlies - Building I R & M Supplies - Landscape I ISmaIl & Expend - Small Tools I Small & Expend - Office Equiprn I Software I Technolo2Y Ullwades I Items for Resale M~/LOO~n2 I Continuin.e Education I Annual Dues I Licenses Pomg, Transportation I MilellRe Departmental 60110 60210 60220 60310 60320 60330 60340 60410 60520 60990 61005 61020 61025 61050 61105 61120 61130 61205 61210 61220 61225 61245 61310 61315 61320 61405 61410 62005 62010 62015 62020 62025 62030 62100 62200 62300 62305 Opcnoting Electric Water & Sewer Service N""""'''''' Refuse Collection StormWatcrUtility~e Telephone """""'" Rm1ab I EQuipment Maintenance Contract Software Maintenance Contracts '''''''''''''''' 63005 63010 63025 63030 63100 63105 Professional Services Professional Services Contractual Services IPublishin2 Printin2 R &. M Labor - General R &. M Labor - Buildin2 I Professional Services I 1"",,,,"0ut!,,, IImVTOvements I Office EauiDlnent I I EQuiomcnt I ICanital Outlay I I I ITotal EJ:peoditurn I I I 65300 65500 65600 INet IDcreue (Decrease) iD FB I I I I I I I , Adual 2003 I , , I I ! I I , , I I CfIY OF ANDOVER Budeet Worksheet - 2007 I AduaI 2004 I I I I ; I , I I I , I , I I I I I I I I I I I i I , 34,275 I 2,1781 509 I 1,540 i 196 I 14 I 77 I 1,762 I I , 40,551 I I I 6511 11,168 I 4,274 I I 2881 I 1,843 3,1185 288 I I I , 275 162 22,834 I , 9(J8 278 , I I 1,245 I I 6,595 I , 9,026 409 393 802 73.213 (73.213 Ada'" 2005 148,951 8,068 1,881 11,794 745 46 266 I 5,5311 2,146 i , , 179,446 I I i 2,544 I 28,155 I 972 I I 3,089 I 3,595 I 506 I 79(J 134 485 1,093 679 10 36 351 42,441 I I I 124,974 I 3,018 I 149,113 I 3,]09 I I 4,772 1 10,000 I 8,213 365 I 450 I 304,0]4 I 1,440 1,188 318 105 6,203 9,255 9,613 9,613 544,768 Bud2d 2006 I I I I I I I I I 200,502 12,431 I 2,907 I 12,956 784 I 321 261 1 12,030 2,506 I 10,205 i 254,614 I I 175,000 6,000 110,000 2,200 308,900 613,714 (538,714) I I I 15,000 15,000 60,000 60,000 75,000 3,000 I 17,500 1 5,000 . I 5,000 2,500 1,000 600 600 35,200 4,600 10,300 800 5,000 5,000 5,000 15,noo I 1 , , , , I I I I ......... 2006 1 7,000 7,000 ! I I , 65,000 65,000 72,000 88,730 88,730 1,000 15,000 150 100 2,000 300 , , I , , 200 18,750 I 140,000 5,500 190,000 4,200 5,000 10,300 800 4,000 500 360,300 2,000 8,000 300 8,000 1,200 19,500 - , I I I 487,280 I I , (415.,280)1 I I I I I _...... 2007 238,412 14,781 3,457 13,455 856 32 279 14,901 3,576 10,734 (120,124) 180,359 130,000 4,800 180,000 4,500 338,881 552,090 (....090 I , 213~ 6,000 6^000 60,000 60,000 66,000 350 350 4,800 10,815 3,966 8,000 6,500 5,000 5,000 24,500 8,000 8,000 J 0/ J 9/2006 @ ~-\ \J CITY OF ANDOVER Budj!et Worksheet - 2007 I , COmmllnity Center I 2130- I I A<<O_tl AduAl AduAl AduAl Bud I Estimate R~:i~ Numberl DescriptioD 2003 2004 2005 I 2006 I 2006 I , Commw":t't' Center I I R~ I Charges for Services 55540 IConcessions 39,521 25,000 113,000 125,000 ICharges for Services . I 39,521 I I 25,000 ! I 113,000 I 125,000 i I I , I MisceUaneous RevEnue I I , 58100 I Refunds & Reimbursements - I I , I MisceUaneous ReveJIue . I I I , I , 'Total Revalues . I 39,521 25,000 113,000 I 125_ - I . -:::",q;;;;;i';;;;,;;'2:: ... I I I Salaries & Benefits 60110 I 'S"""".R....... 9,560 . 60210 I FICA 572 60220 I Medicare I 134 . 60310 I I Health Insurance I . 60320 , """"I",,,,,,,,,,,, I - 60330 I I life lnsunmce ; . 60340 , I Long-Term Disability i . 60410 , IPERA , . . 60520 i Workers Como I . . 60990 , Inter-Citv Labor Alloca1ion . 43,000 65,470 , Salaries & Benefits , 10,266 i I 43,000 ' i 65,470 i I I I Departmental I 61005 I I Supplies - General 656 500 I 61020 I ISUDPlies-()peratin2 5,645 8,500 8.000 61015 I Supolies - Cleaning . . 61105 i I R & M Supplies - General . . 1,000 61205 I ! Small & Exoend - Small Tools 1,304 450 61245 I I Items for Resale . 16,246 41,000 43,750 61310 I IMe:alsI Lodginv: . 61315 IContinuing Education 310 61320 Annual Dues I Licenses 939 100 450 61405 I Postage 61410 ITransportation I Mileage I Departmental , 25,099 I 50,550 I I 53,200 I 10000000ng I 62005 I Electric I 5,266 9,000 7,800 62010 IWater & Sewer Service . I 61 400 288 62020 I Refuse CoUectioo I 379 1,400 1,485 62030 IT elephone . 62100 ' Insurance I , 62200 R~"'" . I 1,600 I 62305 'Software Maintenance Contracts I I , 'OponuiDg I 5,706 I , 12,400 , 9,573 I I ; Professional Services I , 63005 : Professional Services . 160 , 63010 ;CootractualServices . , 1,500 63025 Publishilllz - I , 63100 : R & M Labor - General I . 195 I , 500 , ;Professional Services I I 354 I , I 2,000 , I ! I I Capital Outlay I i 65300 Ilmprovemenls I I 65600 I Equipment I - I I Capital Outlay I I I I I I I I I I Total Ellpeoditulft - I 41.,425 I . 107.950 1211,243 I I I I I Net Increase (Decrease) ill FB . I (l~)i 25,000 I 5,050 (3.,143 I I I I , I I , I I " ....J \ '-.J @ 10/19/2006 '0 CITY OF ANDOVER Badpet Worksheet - 2007 I I I COMIfIMnUy Center I 2130- AaoUDt Artwd Artwd A....aJ I Bud~ Estimate R........ Num.... DeKriDtiolll '003 , ,... ,... , ,... ,... '007 , I , I I I I I I Community Ceater Pro Shop - 44200 I I I ., .,............ I I I I I I I Chanzes for Services I , 55514 ISka1eRental I - , - - I - 55515 SkateSharnenine: I - I ',000 1,000 I 3,000 55516 I Merchandise , , 1,1% - I 2,000 3,000 Charges for Services I - , 1,1% 2,000 I 3,000 I I 6,000 I , I Total Revalues I - - 1,196 '.... 3,000 i 6,000 O.,,~- I , I m =-~-E~tu;;s-~ I , I I I I I Salaries & Bmefits I I I 60110 ISalaries-RlWliar - I - I - 60210 I FICA - I - I 60220 I Medicare - - - I - 60310 IHea1thInsurance - - - I - 60320 I DentaIlnsunmce I - 60330 I Lire Insurance - , - 60340 ! Lon2- Term Disabilitv - , - 60410 iPERA , 60520 Workers Com - I - 60990 IInter-City Labor Allocation - I 3,000 ISalaries&Bmefits I I I - I I 3,000 , I Departmmtal I 61020 Supplies.()peratinJ: I I 1,000 500 61245 Items for Resale I I 207 500 I 750 Departmental I I - I 207 ! I 1,500 I 1,250 I I Total Espcuditurn I - - 207 - 1,500 '-'-'" I I , I I Net Int:rease (D<<rase) ia FB I - I ... 2.... 1,500 , 1,750 , I , I I I I I I I I I "- <J , \ ,---I @ JOI19/2()()6 \ o CITY OF ANDOVER Buden Worksheet - 2007 I I I I COmMUnity OIf1er I I 2130- , , AceolUlt I Actual Actual Arluool Bud... Estimate , Requested Number Desc:ription I 1003 100< l00s 1006 ZOO6 1007 I I , I , , I I I I I I I I Co=".;to C~.... '''. A.....:...lOO I I : ': I I I I I esforServices I 55505 , IIceRcntal 21,511 275,444 , 274,000 270,000 290,000 55506 I lice Rental- Taxable - 22,576 I 35,000 55510 , Opon Skate 361 6,739 I 10,000 18,000 15,000 55530 I Fee Admissions - 12,218 I 9,000 12,000 12,000 55570 , Vendinl!:Maclrines 1,000 6,316 , 3,000 55580 , Advertisinll: 6,810 7,416 , 35,000 10,000 15,000 , Charges for Services I I 29,6831 I 330,709 , 328,000 , 348,000 I 332,000 , , I I I Miscellaneous Revenue , I 58100 I I Refunds & Reimbursements I 24,400 , 24,400 24,400 58105 I Rent I , - 58130 I I Donations - Restricted I , - I Miscellaneous Revenue I , I 24,400 , 24,400 24,400 I I I ITotal Rew:aun - 29.683 I 330,709 351,400 I 372,400 356,400 I ".. , I : , , I I 'Salaries & Benefits 60110 Salaries - Regular - - 60210 FICA - 60120 IMedicare I - 60310 i Hea11h lmurance - I 60320 IDentallnsurance , - 60330 Life Insurance - 60340 Long- Tenn Disabilitv - 60410 PERA I 60520 Workm ComD , 60990 lnter-City Labor Allocation I 112,000 38,244 Salaries & Benefits I , I I I I I 112,000 i I 38.244 I I I DeoartmentaJ , I 61005 Supolies - General - 600 61020 I SunDlies - Ooerating - I 7,000 , 16,000 61025 Supplies-Cleanin2 I 61105 I R &. M S~'p~ies - General , I 500 2,500 61120 I R &. M Sunnlies - Buildin2 I ; I 1,500 61205 ISmail &. ExrH5Id. Small Tools I I 1,500 61210 I Small &. Expend - Office &juipm I - I I 61220 !Software - I I - 61225 ITechnology Upgrades - , 61310 IMea1s/Lod~2 I I '00 '00 61315 iContin~~ucation I I 700 61320 Annual Dues I Licenses I , - , 200 61405 IP""",," I - 61410 Transportation I Mileage I - 100 250 O"!""''''''''''' , I I I I I I , 11,200 I 21,250 I I iOnernting I 62005 I Electric , I - 62010 I Water &. Sewer Service I , 62015 N",,",,"" I 62020 I Refuse CoUection , - 62025 !Storm Water Utilily Charge - I I - 62030 ITelephone - I - 62100 11rnunon~ - - 62200 I Rentals - I , - 62205 'Central Eouipment Services , 3,500 3,605 3,605 I 3,966 62300 IEouipment Maintenance Contract , 62305 ISoftware Maintenance Contracts I - 10nen0Iin. I 3,500 3.605 3,605 3,966 IProfessional Services , 63005 Professional Services I - 4,000 63010 Contnu:tualServices I 1,000 63025 Publishin2 63030 Printin2 63100 R &. M Labor - General I 4,500 ' , 63105 R &. M Labor. Buildin2 , I 2.000 I , - Professional Services I I I 11,500 i I I I I I Capital Outlay I 65300 Improvements - - 65500 Office EQuipment - - 65600 I &juipment - I Canital Outlay I I - , - , TDtal EJ:peDdituns - 3,500 3_ 11lI,105 63_ I , INet1ac:rase (Deueue) in FB , 19,683 327.,209 , l48, 795 , 134.... 292,940 I I I I I I I I I I I I I , I I I I I I I I @ .~J ,- '\ ,...-I 10119/2006 , '\ '-) CITY OF ANDOVER Bud~et Worksheet - 2007 I I COlflml"lity Cen1er I I 2130- I I A<<ountl Ado" Ado" AduaI Bud!d Estimate ....-... Numberl DeH:ription 1003 1004 1005 1006 1006 1007 I I , Communi.... Ceatu - ..... , .. ............ ........ I I I I C esforServices I 55520 I Fieldhouse Rental - 13,562 40,000 60,000 , 68,000 55521 Fieldhouse Rental. Taxable - 4,890 23,000 I 55522 I Open Fieldhouse - 5,483 16,000 ; 11,000 55530 Fee Admissions - - 55550 I Eqwpmmt Rental 2,209 - I 1,500 55570 , VendingMacltines - , 55580 I Advertisine. - I 2,500 5,000 I<:han!es for Services I 26,144 I 40,000 I , 101,500 85,500 I I I Miscellaneous Revenue I I 58100 ; Refunds &. Reimbursements - I I 58105 """ - , I , ; Miscellaneous Revenue I I I , I Total Rewllua - 16,144 ".000 101.500 85.500 '~'.-.,^ I r-EXpmdi~ ~ I I Salaries & Benefits I 60110 Salaries. Regular , - - 60210 FICA I - 60220 Medicare - - 60310 I Health Insunmce , - - 60320 Denlallnsurance I 60330 I lire Insurance , - 60340 ILong-Term Disability I I - 60410 IPERA I I - - 60520 Workers Camp , 60990 Inler-Citv Labor Allocation I 13,5001 13,410 Salaries & Benefits , I I I , I 13,'500 I I 13,410 I I I Departmental , 61005 I ISupplies-General - I 61020 I Supplies - Operating - 7,500 1,500 61025 ! Supplies - Cleaning I - 61105 I R & M Supplies - General - - , , 1,000 61120 : R & M Supplies - Buildim~ - I 500 61205 : Small & Expend. Small Tools I , 2.500 61210 : Small & Expend - Office Eouiom 61220 ~Software , 61225 T edmolo(!V Upgrades - 61245 Items for Resale - 61310 Meals/Lod1!in1! , - 61315 Continuin Education - 61320 Annual Dues I Licenses I - 61405 Postage 61410 I Transporta1ion I Mileage I Departmental I I I I , 10.5001 I 8,500 I I I 'Ooenotin, , , , I 62005 I Electric I - I 62010 IWater & Sewer Service - - 62015 INa1uraIGas - 62020 I Refuse CoUection - - , - 62025 Storm Wlllel' Utility Charge - - 62030 Telephone 62100 """"""" - - I I 62200 I I Rentals - 1,000 62205 , ICentral Equipment Services I 62300 I Equipment Maintenance Contract I - 62305 ' Software Maintenance Contracts I I 'Ooenotin, I I I I 1,000 , - I Professional Services I 63005 Professional Services I - 2.500 63010 Contractual Services I 63025 Publishin,g - 63030 Printing , 63100 R&M Labor. General I - I - , 63105 R & M Labor - Buildin,g I I - , Professional Services I I , I I I I 2,500 I I I I I Capital Outlay I I 65300 I Improvements I - I 65500 Office Equipment , - , I 65600 IEquipment I , 7.500 Capital Outlay , I , I I I , I 7.500 I I Total Expeaditurel - , - 27,500 I I 29,410 I I I I INet Increa!e (Deuease) io FB - I 26,144 I ",000 74,000 I 56"" I I I I I I I I I I I I I I I I I I I I I I I I I I I \ , ../ \ 'J @ JOIJ912006 , " ) ,~J INTEROFFICE MEMORANDUM TO: JIM DICKINSON FROM: BRIAN KRAABEL SUBJECT: 2007 PROJECTS DATE: 10/19/2006 CC: Water Department · The Water Utility would like to get underway with the Automatic Meter Reading System (AMR). A Fixed Network System would be the most beneficial system to utilize. This type of system would allow the water utility to read all meters on a monthly basis to determine usage, to see if there has been any tampering with the meter and down to where the utility could see when the highest water consumption was taking place at any meter and what time of day this was happening. This would also eliminate any estimated bills. If a meter is not reading the utility would be made aware of it immediately and not every three months as is happening now. .. " , '_./ · Another item is the sealing of well number one. This well has not pumped any water for the past few years and should now be sealed. The well pumps a tremendous amount of sand and the quality of the water is no better than what is coming from well two. There is no benefit to having this particular well as part of the system and it is time to eliminate it. Sanit:u:y Sewer Department · The first sanitary sewer lift station on the system is in need of a major overhaul and part of this will take place this year (2006) with a new control cabinet. Next year the department is planning to install a backup generator to this site. This station is the highest pumping station with a force main over one half mile in length. Over the years there have been many power outages in which temporary power was required. A pennanent generator would be a welcome addition to this particular pumping station. Storm Sewer Department . \ \.J · There are a few storm sewer areas in need of major repairs. One is on 141" Ave. in the Green Acres development, 148th and Makah St. and 174th Ln and Aztec St.. The project on 174th Ln and Aztec St is a spillway that runs down a property line to a pond in the rear yard. Staff has looked at a new technology to do the repairs. This consists of an interlocking block system that allows grasses to grow up through the blocks making it stronger and resistant to wash outs. @ " , ) "- \ '- / J!J Q) In In <C - Q) Z "C In l: "C ~ l:LL. ~ l: LL. Q) In In Q) '':: C) c.l: ... ca Q),c 'Co W"C l: <C ca In ~e ~ :!:: "C l: Q) C. >< Q')W C)1n "C Q) ~ ~ m l: "" Q) o > o Q) NO::: .... o - l: Q) E Q) - ca - en ... In Q)"C > l: o ~ "CLL. l: Q) <C In .... '':: Oc.ca bCi;E .- - E o l: ~ Wen - '\ o '0 2<0 0.0 00 'ON <( iVli) ~O 00 <(N '0 2" 0.0 00 'ON <( III m<o EO ~o ",N W c: g 'C o '" III o LI) Ul "l .... N M M o M '<t CIQ M N o M o M '<t cxt M N o M o en CIQ LI) en M LI) N o .... ~ III ;:, C III ., S Gl III ~ - Gl Z 'C Gl - U ";: - III ~ C :;) Ul al o '2: al en "- ell .E QI :J~u; ; E' ~ > III QI QI ..c: _ a::u,S O)COOOOOLl) "-COOOOOCIQ ..-'<tOOOCOM '<t- 0)- .o .o .o 0)- cO Ltl'<tN '<t CIQ co .... M M 0000000 0000000 OOOOOli)LI) .o N .o Ltl- .o N '<to LtlCON '<t..-o '<t Ul M M COOOOOOCIQ 0000000 '<t00000'<t ....-.o66N-CO'O N'<t'<t..-M Ul ..- N .M M' ~OCOOT'""CX)CD CDNT"'"1t)T'"""""C") COCOMMNCON N- ,...; co- ..: '<t- '<t' ,..: (J)~'V"C""'"'VT""1l) ..- M M M ell QI ~ Ul C ~ QI o > al QI Ul e: a:: rn!l~~S ~'Em1lo w Iii ffi .~ I- :!;c..c..:!; ell QI ~ .= ~ o l!! en,l!! .. Ul QI e: .c ~ 01- .... .... Ul ,..: LI) '<t N '<t ,..: Ul .... '<t N '<t ,..: CD .... CD LI) 0, CD '<t CIQ M '<t N O!. .... .... .... M N M CIQ ,..: N '<t M CD M N ,..: LI) M M ell QI ~ ~ o II) .. QI .c o 'C e: I'll ell QI ~ C QI > QI a:: ~ o I- .... N '<t ,..: CD .... ,..: COOO LtlON LtlLtl'<t .ooiN Ltl Ltl ..- ....NCO .... CD .... .n en .... cD Men COM 'CO.... .oM '<t.... ....M M MLtl'<tOON ....O)..-ONO COMCOO....'<t T"'"- (0- ..q- L.O y-- a; NN'<t......-.... ....NLtl '<ten ..- N' LI) .... Il:!. .... LI) '<t cD MO'<tOO.... ....OO)ONCIQ CO..-OO....LI) ..: .o N Ltl- cD 0 NOO....'<tLl) ....NCO ....M M LI) N CIQ, CD en CIQ .n COCO 0) 0)..-0 O)N..- MNoi '<t..-O) co N M, ..- QI :is .!!! '; > <( ~ o I- Ul al u ell '2: l!! QI ~ en ~"iii c 5 ! ~ )( al W c.. Ul QI E' III Ul ..c: ell mU l!! 't: "'C :J ale: _ mm :c :!; '" >- c "C~.!!!Q)8. 1ij '2: '5 ,~ )( UlalOC:W .!!1 en m Jl ~ CiCii~-o g.:5 g. -g I- enOuo O)N LtlCIQ , co en ....-N ..-.... '<tll:!. N '5 :l 0 ell l!! ~,l!! .. Ul QI e: .c ~ 01- LI) N Il:!. .... LI) LI) o o o .n en '<t o o o .n en '<t o o o 0' o N '<t CD ~ '<t N O!. M .... LI) CD N '<t f'!. M o N o '<to '<t .... "It M LI) CD "l .... N M M o .... CIQ lit LI) '<t CIQ, M CIQ CIQ o cD o CD N o N CIQ O!. N .... CIQ, N M '<t CIQ M N q M o ell QI ell ~ .. QI .c o 'C C I'll ell l!! ~ - '6 c QI C. )( W ~ o I- .... M .. Gl .D E Gl U Gl o J!.! Gl III III <( - Gl Z 'C Gl - U ";: - III ~ C :;) ,@ ~ ~) ... rn Ql'C > C o :2 'CLL... C Ql Ql <rn- _ 'I: :: o c.> >.... - Ql ,- - o~ ~j rn - Ql rn rn < - Ql Z 'C C :2 LL C rn Ql C) C C'll .c U 'C C C'll rn Ql ... :2 - "0 Oll'- -0 0.0 ON ~ Ol iii eo E 0 ::::: 0 III N W '0 Oleo Ci.o 00 "ON <( iii J.t) :::l 0 - 0 ~ N I I ~ ~ 0 III Ql 0 - 'C C Ql C. >< W rn Ql :2 C Ql > Ql 0::: - o - C Ql E Ql - C'll - en co '<:I' "" uS .... '<:1'_ .... COCOOOOON OlCOOOOO(g CO '<:1'0000.... N"N"l.I'il.l'io'<iai CO....N N N CO ""_ .... "" (g ,..: It) ..- ..- ~ o '<:I' .... N "" N 0000000 0000000 0000000 OI.l'iI.l'iI.l'iO""-N LONN N M LO (g_ '<:I' N '<:I' ,..: (g .... .... ..- .... ~ o '<:I' .... N "" N .... OlOOOOOOl MOOOOOM 0000000 '<il.l'iooN"'<i1l"i OlN'<:I'''-''- CO '<:1'_ It) '<:I' N '<:I' ,..: (g .... ..- .... ~ CO CO o ai "" ~ .... MCOCOOCONIt) N CO ..- LO M Ol CO "-'<;I'MMCOCOIt) l.I'iN"tei"":"":I.I'iN N..-'<;I'..-N N '<;1'_ It)_ ..- .... ~ M M CO uS CO ""- .... MOO LOLOCO M,,"LO NNCO "" ..- Ol MN'<;I' M (g CO '<:I' 'COM LOai '<;I'N "" CO .... It) N U!. .... '<:I' .... o o It) ,..: M .... o o It) ,..: M .... o o o rxi '<:I' .... .... "" Ol r:i "" Ol .... o .... (g N M N .... .... CO It) M o N M ~ (g .... CO ..; It) (g CO '<:I' "" uS .... '<l;. .... '<:I' N '<:I' ai Ol "" .... '<:I' (g It) OlLONOO(g ""OlNON.... NLOf'-Of'-M MOteil.l'i"":"': CO OlCOCO..-.... M..-'<;I' '<:I'1t) .... .... ~ (g It) '<:I' (g- Ol Ol .... "" '<:I' .... rxi N o .... .... "" o M ~ M M It) ai N It)_ .... o '<:I' .... N "" N .... M (g '<:I' N It) ""- .... M o (g ..; N o M 0l0f'-00(g f'-OLOONIt) NLO'<;I'Of'-Ol M'<;I'-ail.l'iteirxi COf'-COCO'<;l'1t) M ..- '<;I' f'- CO_ .... ~ .... M .... ... Ql ~ .c III III E III Gl Gl ~ <.I III Ql C ... ::::l (J III :::l ... Ql ..., 0 Gl C J!l- (/) .c ... III .. $ Gl Ol 0 Ql .c e> "0 Ql Ul .. m Ul ~ 0 III .c III C ~ In "0 iii U Gl C'lI .. - Ol Ul C 'C "0 :::l III - Ql 0 C'lI Ol Gl Gl III c: :!:: .. Ql Z .~ :::l III Ol iii m "0 :::l Z Ol c: III Gl Gl 0 :2 III C :!:: "'C (/) III Gl Gl :::l :is III '~ Ol >. Gl '5 "0 "'C Ql :::l > l::! c .!! Gl Ol "0 0 m Ol a. c Ql - ~ 0 Gl -= Gl .. c: '~ ., 0 >< Ul 0 Gl - (J III .E Ol :::l 'i;j :::l en m :::l '~ Gl (J ';: Gl In c: l%: 0 !!! > :!:: 0 W III !!! a. ';: III Gl ~ iii III Ol >< - :::l Ol - !l Ol .!!! en .l!! l%: "0 Olen Ol ::::l .l!! w - Ul c: III III ::::: iii c c: }gOO iii Ul e> ~ ID .. :.= '- .. Ql Gl Ql Ol 'E iii .. Gl III OJ OJ Gl 0 Cl.Ol .. Gl III OJ Ql ... > m ~ 0 0 c: a. III "5. 15 0 c: ... C Ol Qi ~ c: ,!!! I- .c m .. .. ~ Cl..c I- .c m .. c Gl .c - Ol Ol .. ~ 0 0 >< Ol :::l - m Ol .. ~ 0 :;) l%: U -= :2 a. a. :2 0 l- I- I- W a. enO u 0 0 l- I- :;) It) CO It) N N It) .... M "" (g- .... o CO N f'-NLO LOf'-'<;I' COLO'<;I' ""-1!'io '<;I'COM M ..- '<;I' OlM LO M 'COlt) f'- .... ..- CO '<;I'M .... @ ~ /'\ 'J ,'"- o .. o .. .~ '" c. " en .. ~~ ~~ c ki Ol Ol E rn 1:: e: rn~ 0. '" Ol';:: o 0 tl Ol .. (5 "0 "'0 ~?ij -c i..: e: Ol ::Jc LL Ol o - '" o o 'C '" cu~~ "'0 "gN..;t aJ C "''''f'- t::5Ln dNLO Cill)..q .ag~ ~NLt) '" .. ~ .. "'" '" - e: Ol m > ':; cr UJ UJ l- LL = Ii: .. - rn .. .s.~ -g~CJ.)E:C m ~ '~.E 5- ~c.C:CQ) m-CDO.c ;;: rn "'0- .9 -a Qj ",' .s ~a.5"C c: cn~OQ).Q =aicnol1JCti 3:2;~E ~C:~a2.E lU ~ ~ .5 OlOl"'''C C>>.::.....cc: .5 m"C 0 co "C.t:c:.;:;cn :JQ)ctlio.... u.....UJQ):J c~Q;o.8 'E "': 1) 0. ~ Ol 2 E ~ .:;; cn.c.....ij::O ~caQ.1'-..... cnom.E Co Qio.;;:e:gf m en Cii .Q "2 ;;: 5 E '5 _UJ~.8:g~ ~.- en en 'C o~l3:c.9 CD 0 c: ..... '2 :5rn'n;20 OlC",E :E'n; ;;: m >:2.5Qj e m 'C a.. (/) C Q) Qi 'n; LL ~~:2 -g om co E ~!i Cl) ~ ~ 19 "'::JCI) e? g = 0... rn = .5: .::s -e: 'n; E "C e: rn Ol - :~ ~ ..... -Q)~ <.Io.rn <0;;: 'C '" - .... "'0 "'0 'gN aJ <"> 0 lO lO <">f'- C\iC\i f'-~ <">N <"> lO ~ <ONf'- 'coc.oen L()- -0 "Ot"Otf'- f'-~Cl) 00 o co <">N M-ari f'-N NN ~ ~ C)lt)C'\IOOOOtO t--.cnNOOC'\lO__ NlD,......OO,......l.OCO C co ri oocn-arico-"":ai ~C)CXJmCOOtO""'MC:O ::::I~C"')--NN ......__cn U ~ ~ <0 lO co "iianr--: .aOv ~~M N f'- lO lO co ~ Cl) co <"> <"> <0<"> a:i N- <"> co o ~ <"><0<"> lOO<O I ___ cn_ .q-_ COCl)N ~<">~ "Ot<">lO N ~ ~ '" .. '" = .. .. ~ .. <.I "E .. rn "' Ol ~ "' rn "' -n;J::Q) :B 'i:: ~ U o2cn'~~ '~~fl~rnOl 00 o/l '2: "C 5 .2 '" m",OlOlO~31 c: ~ ~~-_mCJ)::>-J ~ Co G) U .- ..... w ~ Qjg-;;~g.-a3=O 0..0000..0001- m .. .~.~ ~ c~ ~C5(/)ai 'n; L: c- 0 ~ ~ co ":2u'n;s:a'Ou (I) t:'E ElO.3 ~ ui 'm 'm >.. _ co ;;>"Cc:2m(/)Mui ~ ~ .~ >.. ~ ~ ~ ~ 5-QJ"Cro~> ==~ w"'C ffi-c 52 co..c::: ~5QJ~..c::~~m ~ ~ ~ ~~ ~ ~.ffi oc.m8JO)"""'i: ffi 0.0 en.o Co -'n; QJ (jjcoJg:2 o_~~~~-gQJ Q)"C:J;> OJ ctIi ==~ 'mffi~~~~co_; ca.{gcnuoull..c: en cg ~-..Q cOl co Q) m c:"'C"'C -:> :s E .- c: B ~ ~ .5 ~ ~ 2 ~ ~.~ ~ ~ >-rnNOlt:o.c ro==Qi~C:: Q) U ..c:m"-m...... .m ....."'C"'Cc:~~enQ) ,,-~c:mQ) Ben Ole: m m ...; .....Ol _w ~ c: e: Ol . U E - u'- m c.~.9l 0 Q) m Eli~82.Q ~~ m E ~ m .9 .- m c:_ ....3:enm3: .-- e: e:.... e: "t:l !!! ';:: Ol Ol 'n; .s l;:: 'iij ~ Qi- E E o.U Ol.c ;J 3:~co.Q.~ f!!.5 f/) fIJ W..... ~ ::] "'C 1:: "- ::] fIJ.....>......C'"c:o-au: t~O"f/)-Q)mu Q QJ O'=~cn..c: ~ ~ ~o-~~~~j~~ '" 2l .~ " (fl co C o l!! " Q. II .. co .C .Sl '" ::;: "" '" .!!1 15. Cl. :> (fl . '" " Cl lo ~ u - '" 2l .~ " (fl ~ " 5 o o .. ~ .. <.I oE .. rn c o .. ~ Ol 0. o .. Ol 0. o .. 0. ~ ::J '" e: Ol o - "' Ol > m > Ol ro Ol e: rn Ol o '0 e: rn Ol ro .. Ol 0. o "' Ol Ol'O > :::J "'0 ..c:.5 'E Ol III U o .2: .0 Ol ~CI) -:0 ~ Ol eO lij e: Cl)g ~:o ::J'O - rn ~ r::: Ol ~.B Ol Ol e:m o U 'iij 'E 03~ g. u . ui~ :a.~ 0 .5 ~ C\I sa; e: . Ol rn",'O c.~&l 1:: c. r::: W g..- .EUJe: rn Ol Ol ~ .5: E - "C >- .. ::J rn ~~o c. rne:- .. ;;: ._ rn ~ "C.9- ~ W Q) U .~;; rJ 'E i:;.cOlo. ~~OQJ rn s: .5: :5 '" 2l .~ " (fl 'C " '" '" ~ :> Q. o 2l .~ " (fl :5 " o [] '" " '" => ~ " ~ o . 'C .. - .... "0 "'0 'gN aJ ONCO <OlO~ f'-.exl N lON"Ot <"> o Cl) lO <Of'-"Ot 1: "_cO u-) "'lON"Ot ~ g M :::IN U ~~ ONO lO"OtO _... 'V_ cO.,... anLOMCO .ag 'V .:t,N = oS: .... <.I .. = = = U ... .. ~ '" .. '" = .. .. ~ ~~ "' e: o U~ GJ:Ero e:-::J B B 2 0:2<( "I:l '" 0 19femN""'~ "gNI.O aJ - r::",0 ~g~mC\l""'~ dNLCi caanO :::JolO U 0 "l;f'_ <(NlO '" .. ... :::J '" .. .. :; .. " = .. e ... os: ... .. ~ Cl)0 mN""',,~ Ol Ol en ~~ c: cnu ,Q "C rn U QJLL. Ol - r::: ~ m r::: Qi a; 8;;:Qi - - - 00 0 .. .. .. Ol Ol Ol .0 .0 .0 E E E ::J ::J ::J ZZ Z "' -'" e: rn - <"> co <0 <"> ON ~N" <"> co <0 <"> ON .,...-N" e: 'n; CE Ol E Qi COCO ~ ;;: 1-- .. 0 2 "' rn2 s:~ '" - e: '" rn Ol .02: >-rn .c > - - o 0 .. .. Ol Ol .0 .0 E E ::J ::J ZZ ~~ o co o C\i I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I , I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . I . . < f-< o f-<'" ~w oZ oZ ::J:E ~ r--~ Ow 0:> N o 00 ~Z f-<-o:t: c.. 0"- 00 <>0 f-< u 61> ClTY OF ANDOVER Water System Flnancilll Projections Actual Aotual Actual Estl~.. Fon:ast Vea, 2003 2004 200S 200S 2007 2008 2009 2010' 2011 2012 Inflation Factor 3.00% 3_00% 3.00% 3._ 3._ 3.00% 3._ 3._ 3..... 3._ '0 Average Use (gallons per user fIE 39,871 39,845 37,858 37,858 37,858 37,658 37,658 37,858 37,858 37,658 Acres Added 55 65 50 50 35 35 35 35 35 35 New Connections 200 200 150 150 100 100 100 100 100 100 New Customers 200 200 150 150 100 100 100 100 100 100 Total Custome" 5,190 5,410 5,657 5,807 5,907 5,007 5,107 6,207 6,307 6,407 Rates Base Rate 8.05 8.45 6.87 9.49 10.16 10.87 11.63 1221 12.82 13.46 Use Rate 126 1.32 1.39 1.49 1.59 1.70 1.82 1.91 2.01 2.11 Connection Charge 2,146 2,318 2,503 2,704 2,920 3,153 3,406 3,678 3,9n 4,290 AIea Charge 1,967 2,124 2~ 2,4n 2,675 2,890 3,121 3,370 3,640 3,931 Connection/Area 6% 6% 6% .% .% .% .% .% .% .% Base Rate 5% 5% 5% 7% 7% 7% 7% 5% 5% 5% Use Rate 5% 5% 5% 7% 7% 7% 7% 5% 5% 5% Use+Base 1,337,130 1,329,831 1,425,123 1,550,000 1,662,696 1,809.203 1,958,073 2,100,315 2,240,860 2,390,210 Mete" 28,392 48,616. 46,316 25,000 25,000 25,000 25,000 25,000 25,000 25,000 Parmit Fees 8,350 13,350 11,350 5,000 5,000 5,000 6,000 5,000 5,000 5,000 Penallies 25,926 14,606 21,638 20,000 20,000 20,000 20,000 20,000 20,000 20,000 Interest (93,195) 2,786 12,466 25,000 12,466 12,466 12,466 12,466 12,466 12,466 Xferln 505,170 739,438 167,424 57,671 57,485 72,883 78,714 85,011 91,812 othe' 127,986 5,692 7,000 4.000 4,000 4.000 4,000 4,000 4,000 Total 1,811,n3 2,276.813 1,522,585 1,799,424 1,786,833 1,943,154 2,107.422 2,245,495 2,392,337 2,548,488 Expenses Operations 974,455 993,752 1,098,874 1,178,096 1,170,308 1,205,417 1,241,580 1,278,827 1,317,192 1,356,708 Debt Service 458,030 749,467 754,392 411,720 745,663 748,228 749,439 754,221 757,507 759,440 Capital Outlay 66,196 65,000 65,000 63,000 50,000 50,000 55,000 55,000 Replacement Reserve 350,000 434,000 Total 1,782,485 2,1n,219 1,919,462 1,654,816 1,970,971 2,016,645 2,041,019 2,083,048 2,129,699 2,171,148 Balance - Unrestricted Annual SUrpluslDeficit 29,288 99,594 (396,877) 144,608 (184,138) (73.492) ",- 162,447 262,638 3n,340 Cumulative balance 1,569,423 1,669,017 1,272,140 1,416,748 1,232,610 1,159,118 1,225,522 1,387,958 1,650,607 2,027,946 Connection Charges 797,979 1,335,347 961,261 325,000 291,985 315,344 340,571 367,817 397,242 429,022 Area Charges 93,641 101,133 109,223 117,961 127,398 137,590 Interest 45,328 50,119 79,891 85,000 50,000 25,000 25,000 25,000 25,000 25,000 " '\ Special Assessment. 766,758 45,656 130,910 40,000 50,000 50,000 50,000 '-~ Replacement Reserve 350,000 434,000 oth"' 12,385 2,210, Total 1,960,065 1,8n,507 1,174,2n 450.000 485.626 491,476 524,795 510,n8 549,640 591.612 Expenses Debt Service 888,235 463,254 284,210 284,210 284,210 Capital Outlay 56.998 399,166 976,847 170,250 299,100 1,173,500 299,000 650,000 150,000 150,000 XferOut 505.170 739,438 167,424 57,671 67,485 n,883 78,714 85,011 91,812 Total 1,450,403 1,601,858 976,847 337,674 356,n1 1,240.985 371,883 1.012,924 519.221 526,022 Balance Annual SUrpluslDeficit 509,662 275,649 197,425 112,326 128,855 (749,509) 152,912 (502,146) 30,420 65,590 Balance 1,817,697 2,403,097 Rehab Wells 40,000 45,000 45,000 50,000 50,000 55,000 65,000 Sealing of Well #11 10,000 Trunk New Development Projects 170.250 175,500 120,500 124,000 150,000 150,000 150,000 MSA Routes. New J Reconstruct 123,600 1Z' water line down South Coon Creek from Crosstown to Round Lake 795,000 p~nt Paint water tower 258,000 2 million gallon storage tank 2,950,000 Surface Seal Brick Structures 18,000 Demo tower 175,000 WTP reclaim tank addition 500,000 Equipment 65,000 T_ 275,250 354,100 1,236,500 3,299,000 700,000 205,000 205,000 Funded by Operations 105,000 55,000 63,000 50,000 65,000 55,000 Funded by InfrastructurelTrunk 170,250 299,100 1,173,500 650,000 150,000 150,000 Funded by debt Total Te"" 10 10 10 10 10 10 15 15 15 15 MDS 284,210 ~ Cumulative OS 284,210 284,210 284,210 Current OS WTP 739,.(38 741,393 7046,720 745.663 748,228 749,439 7S4,221 757,507 759,440 17.5% of Connection J Area Charges is used to support the WTP @ CITY OF ANDOVER Budget Worksheet - 2007 ~-) Water 5100-48100 Account Number Description Actual 2003 Actual 2004 Actual 2005 Budget 2006 Estimate 2006 Requested . 2007 Charges for Services 54250 Water Department Fees 471 158 55110 Water - General Sales 1,334,341 1,519,357 1,425,123 1,494,039 1,550,000 1,662,696 55115 Water - Disconnect I Reconnect 120 100 55120 Water - Permit Fees 8,350 12,150 11,350 10,000 5,000 5,000 55130 Water - Other Fees 535 1,500 1,500 55140 Water - Penalties 25,926 15,806 21,638 12,000 20,000 20,000 55150 Water - Hydrant Rental 1,144 690 55160 Water - Meter Sales 28,392 47,672 46,316 40,000 25,000 25,000 55170 Water - Tapping Charges for Services 1,397,009 1,596,720 1,505.910 1.557.539 1,601,500 1,712,696 Investment Income 56910 Interest Earned 32,295 24,358 30,878 25,000 25,000 12,466 56920 Valuation Adjustment (8,112) (27,809) (18,411) Investment Income 24,183 (3,451) 12,466 25,000 25,000 12,466 Special Assessments 57200 Spec Assess - CWTent by Count 2,788 1,909 57300 Spec Assess - Interest & Penal 11 43 57400 Special Assess - Certified Bi! 2,524 3,000 Special Assessments 2,788 1,920 2,567 3,000 Miscellaneous Revenue ,-) 58100 Refunds & Reimbursements 1 911 1,642 2,500 2,500 4,000 58120 Contributions 709,493 608,267 371,359 58155 Sale of Used Equipment 3,427 Miscellaneous Revenue 709,494 612,605 373,001 2,500 2,500 4,000 Other Financing Sources 59100 Operating Transfers In 505,170 739,438 167,424 167,424 57,671 Other Financing Sources 505,170 739,438 167,424 167,424 57,671 Total Revenues 2,638,644 2,947,232 1,893,944 1,752,463 1,799,424 1,786,833 :~ @ CITY OF ANDOVER Budget Worksheet - 2007 . \ Water 5100-48100 0 Account Actual Actual Actual Budget Estimate Requested Number Description 2003 2004 2005 2006 2006 2007 Salaries & Benefits 60110 Salaries - Regular 260,123 275,121 282,583 339,447 339,447 318,727 60210 FICA 15,315 16,299 16,047 21,047 21,047 19,760 60220 Medicare 3,594 3,870 3,753 4,922 4,922 4,621 60310 Health Insurance 24,248 27,925 25,786 45,304 45,304 33,810 60320 Dental Insurance 1,696 1,719 1,814 2,744 2,744 2,568 60330 Life Insurance 197 199 111 112 112 96 60340 Long-Term Disability 616 683 668 844 844 790 60410 PERA 13,725 14,298 14,021 20,367 20,367 19,921 60520 Workers Comp 2,422 2,788 3,072 4,244 4,244 4,781 60990 Inter-City Labor Allocation 720 (55,752) (55,752) (32,721) Salaries & Benefits 322,656 342,902 347,856 383,279 383,279 372,353 Departmental 61005 Supplies - General 1,679 1,659 3,055 2,000 2,000 2,000 61020 Supplies - Operating 8,405 8,250 10,862 13,500 10,000 13,500 61035 Supplies - Water Meters 6,106 41,163 60,862 37,000 34,000 37,000 61040 Supplies - Chemicals 80,289 61,128 67,260 80,000 98,000 11 0,000 61050 Supplies. Diesel Fuel 1,022 2,804 4,500 2,700 3,500 61105 R & M Supplies - General 5,105 11,450 6,088 8,500 8,500 8,500 61110 R & M Supplies - Hydrant 2,933 3,593 8,537 2,000 1,500 2,000 61120 R & M Supplies - Building 1,521 1,572 8,481 2,500 2,500 3,500 61125 R & M Supplies - Streets 991 2,500 2,500 2,500 61130 R & M Supplies. Landscape 2,577 355 3,500 3,500 3,500 r~\ 61135 R & M Supplies. Water 13,176 12,459 7,787 15,500 15,500 15,500 'J 61150 R & M Supplies - Meters 3,609 2,235 885 3,000 3,000 3,000 61210 Small & Expend - Office Equipm 820 600 61220 Software 2,985 857 175 400 61310 Meals I Lodging 355 508 600 600 600 61315 Continuing Education 300 1,954 2,000 1,500 1,500 61320 Annual Dues I Licenses 2,829 2,270 1,512 1,200 600 1,200 61325 Subscriptions I Publications 910 710 500 350 500 61405 Postage 2,066 2,504 3,628 3,500 2,500 3,000 61410 Transportation I Mileage 205 286 285 450 350 450 Departmental 131.208 155.281 185,572 ]82,750 190,595 212,750 Operating 62005 Electric 82,979 102,167 106,983 120,000 120,000 ]20,000 62010 Water & Sewer Service 87 3,000 500 62015 Natural Gas 8,616 18,929 29,007 30,000 25,000 30,500 62020 Refuse Collection 683 1,239 2,000 1,500 2,000 62025 Storm Water Utility Charge 168 335 357 540 460 540 62030 Telephone 5,599 7,152 5,797 5,750 5,750 7,950 62035 Taxes 340 2,078 62100 Insurance 10,315 16,331 16,678 17,178 17,178 18,037 62200 Rentals 276 1,865 1,860 3,000 2,000 1,800 62205 Central Equipment Services 56,938 56,939 59,606 61,394 61,394 67,533 62210 Computer Services 12,000 13,000 14,000 15,500 15,500 15,500 62300 Equipment Maintenance Contract 5,213 6,846 10,009 8,940 8,940 8,940 62305 Software Maintenance Contracts 62900 Depreciation 455,845 631,075 791.025 Operating 638,376 855,322 1,038,639 264,302 260,722 273,300 U @ . CITY OF ANDOVER Budget Worksheet - 2007 r ." Water 5100-48100 0 Account Actual Actual Actual Budget Estimate Requested Number Description 2003 2004 2005 2006 2006 2007 Professional Services 63005 Professional Services 17,072 16,334 25,348 18,700 18,700 27,075 63010 Contractual Services 26,707 31,261 33,603 37,155 34,000 31,155 63015 Attorney 59 63025 Publishing 2,748 2,748 87 3,500 3,500 3,500 63030 Printing 5,750 5,750 63040 Locate Service 1,930 3,905 6,311 5,800 5,800 5,800 63050 Water Permit Fee 30,336 34,361 48,080 45,000 45,000 45,000 63100 R & M Labor - General 19,469 5,173 1,510 10,000 8,000 10,000 63105 R & M Labor - Building 77 8,230 24,104 6,000 6,000 6,000 63110 R & M Labor - Streets 63115 R & M Labor - Wells / Pumps II 0,292 77,900 40,728 79,500 79,500 85,500 63120 R & M Labor - Meters 1,244 5,500 5,500 5,500 63200 Inspections 160 307 1,323 Professional Services 208,791 180,278 182,338 216.905 206,000 225,280 Capital Outlay 65300 Improvements 4,250 65400 Vehides 65500 Office Equipment 65600 Equipment 3.876 1,500 65,000 65,000 Capital Outlay 8,126 1,500 65,000 65,000 Debt Service 66100 Principal 335,000 335,000 345,000 .:J 66110 Interest 685,587 426,467 417,659 411,720 411,720 400,663 66350 Fiscal Agent Fees 374 494 Debt Service 685,587 426,841 418,153 746,720 746,720 745,663 Other Financing Uses 67101 Operating Transfers Out 485,518 582,000 148,000 137,500 13 7,500 141,625 67800 Prior Period Adjustment 191,906 Other Financing Uses 485,518 582,000 339,906 137,500 137,500 141,625 Total Expenditures 2,480,262 2,544,124 2,512,463 1,996,456 1,989,816 1,970,971 Net Incr (Decr) in Nct Assets 158,382 403,108 (618,520) (243,993) (190,392) (184,138) ~~ C9 o ~ o ~ .. ~ .~ .. .. enCL ~~ ~l:' c= ca:'= en::> c ~ Q) Cl E III 1:: c III III c.:::;; Q)>::: Cl a t) Q) ~ is :~) '\ V ~ .. en ~ ~g =..... "'co en ... "C t.: c Q) ::;J'E Ll.. Q) o u; a o "C .. 'S,....co C)O "! -g~Ct) III - =",1'-- ~gO') aNN ~.."U') t)g~ <.....M '" .. ... .. ...l '" 'E Q) 'iU > '5 C' w W l- Ll.. c E .. - rL1 ,g: al'E e ""eQ) III Q) Q)~(/)g~:5 :Eo~1a~~a Q)~u--", - ~c co .z:. caCOQ)d;:::W'i:: -a::.;; = Q.C) o en "'C '5. $, ~~.~ffi.~.~ Os::_urcnQ) ~ iii ,S; Q) 1ij :5 Q)Q)IllOQ)'" c~E..c""c: c I- e.c 'n; oo"Cca....... ~ l::; ffi E 0 c ~ ~ en en .~ .~ =Q)ffi8.~- ~ :5 ~ '0. -0 5i c,guc:.9E co _ en"' '",- Q) 1:: aJ'-o~::::Jca 0.~Q)1ll-c1i} 'c..ma.~Q)"C cao~.og'.!!! -5,m'~~~..c :1=.Q-O gl- e UJ .~ ~ :0 >. :5 8..~ g ~ m "C '5. ~ ~ .a co m....cuo-gu t) .9 Q);;::C '" Q) .!!!1i}",;;:::;JE 8f::!Q)Erl,~ Cl) ..c Q) en "'C '~"EI-(;) g-~ (1).- . ~.x'- cn'-C)(/)o~ mQ)cc:Ct1 ;;: ;;: 'in a .c ~ wQ)(I):.;:;........ :~"'U)Q)uQ)a -~~g~ ;;::0 ~uu5.8Jlffi "C .. -.... "0 Cl)o "C..... ::J III MONll'l ~o,.....C'\I oCOC"')"C""" -.i"'::-.ioi LnNCD"C""" N Cl ~ ~OM I'--ll'lCO _ co_ I"'--~ COa CCDLO"C"""m ~C,,","NU') ::::lI~N o ~ vt'--......U') ...ClNCO O_MaLOa ..... "ii""OVl'-""- ,30............__('\1 ~~N lOCO ~ '" .. '" c .. '" Q) Cl ~ "'jg (f)COU B .~ '~ OJ '" Q):::;; l'l U) O/l .~ 'iU"'Jl c .~ ~c.Qi Qi g-:5 Q.U)O ~ '"' .. y Of .. rL1 E Q) - '" >- '" ~ Q) ;;: Q) '" ~ III - '2 III '" 00 o~ 10 Ma ...Cl Clll'l M co. ~ ~ 00 ll'l0 ...0 cri'1li o Cl 0... OM ll'l... NM ...ll'l Mll'l ~ ~ oco 0... 'O~ "'::0 ...~ CO_ ~ ~ '" Q) U '~ Q) >- U) III "C~ UJ Q) ::;J Q) ",0'" III - ::> -I ..cS....<( ~c.Q)1-- ::;J1ll:50 0..001- Cl .~ ui ~ .~ ':>ro gJ mCO Q)Q) Q)-c6-~ _U)]!~.9 m c: ~a; ~1ll~EEIll'iU:5 U"C,.,,~.!!!~ a Q) OJ t..- C).c ~ "E 1:) =ffi~ee om ,+--Q)c..c..Cl)~.b 0(1) msc:;:.....ca Q:i"':u 3:m"C 1::111!51iig"'ffi0 cu>-_-~::o~ :J...ccn(/)c:Q)_ca C" 0 co m-=-o"'C cbm~uiQ)-C:m eCD_CO-CUo oC)ca~U"""c.~ c:c:_ra..o~:] 1ll"ElilEEg'c::2 -:]c.Q)!!:.;:3 (J:]U)-U)tn...;"'It ~ ~ .5 -g in' 2 ~ ~ Q) > 'S; ~ ....."'C Q) :> -- Q) c: m .- ~ -g 10 .5 ;: m -E g ~1ll.c",Q)e8Q) Q)C).......;:en.Q e>> o.,~ E .g .9 t) E Q) ~15!! en.5 8.e E m.-en.:w::c:en.....Q) "O.~~g~.5~.9 ~>c:.r:._~.....:s:~ ""Eau .9~~ '" 2 'B E i<: .2 Q) a c:cnQ)m.5ogg. ~~oCJ"'C~m~ sc:ueffi.r:.e "C en .Q ~ c. ;: 1:: .E ~~Ei5~~~~ rIlctJ8E"fi';:Q)~ rl~ Iii ~ 0 ~ C.Q)2 ~c.~C)c.C:uC: ...enQ)oenoc:ctJ Q.,c",5.<l:EaE '" I.~ :2: IQ) ,C/) :tii i5 ,'" ,Ii; ~a.. II '" c;; ." J!l '" ::E "" '" ."1 1'i Cl. " C/) . >- '" 5 o S .0. '" U . '" B - .~ '" Q) B C/) .~ "C Q) II) ~ C/) Q) '" Q) ~e fi jg ::J ouo.. D D ~~ cti Q) .~ E III .91i} '" ~ G E Q) Eu; a >- J:: '" - e Q) E Q) U III a. Q) ~ III - a 0. ::;J Ql '" Q) :5 "!!! -c c ::;J ui Ll..'E ~ Q) c E 2 Q) I- U ~ III Q)a. ;;: Q) Q) .... U)"C ~ffi rIl ~ ~ - ffi .co .:: U) 1i} Q) .... .c Q) -;:s -:5 -- ::;J ~ 02 "0 C .a .. Q) .~ I- ~ .. Q) Q) .. .c '" oo..-e '" Q) '" ::;J Ii; .<:: 15 [] "C .!l .. CI) "C ::J III o co... COOCl ll'l."": N ....(OC'\llll g N ..... ~~ OMO coll'l ": ~ - _0)(0 iCD(O't"'""M t:g N ::J ..... o ~~ Ol'--N ~'<I:"! "ii.,.,cONC:; ::Jg N u..... < ~~ c .:= - y .. c c C> U .. .. '" Q.,e rI) .Q ~t) >-_ ~~~g: c e e ~ooc: ,",0:::;;<1: "C .. 0 -;;....(0 .g8LO ::J N to III M O)~;: N - c"'o "oco Coll'l e3NtO 1M I'--~ ClICO ~ "ii.,.,o ::Joll'l uoN. <""'co co co~l';; '" ~ = '" .. .. ::; .. y C .. 5 .. .$: .. .. Q., '" Q) o '" .c c '" c ,2 c III U ~.~ E ~_"'mEIii c ....;;: 8~~31 o 0 ~IO ..... .....,..... ..... Q)Q)OQ) ..c.cl"'.c E, E, Q) E :]1 :]::= :] ZiZI:::;; Z -< E-< o 1-'" t;Jt;J OZ OZ ::l i:!:I~ ....~ ot.t:l 0> N o 00 t.t:Iz E-<-< c.. 0"- 00 -<>- I- u @ - '\ o II.. ~ II.. Q) ... Q) > C;> o ::::l ;> '\ -g U- ~ ,j <C .~ ~ '0 as II.. .- ~Q)c ._ - l'lI UJien :.J II) - Q) II) II) <C - Q) Z "C C ::::l U- C II) Q) C) C l'lI .c U "C C l'lI II) Q) II.. ::::l ~ "C C Q) C. >< W II) Q) ::::l C Q) > Q) 0::: - o - c Q) E Q) - l'lI - en "C jB.,..... 0.0 0 0 ~ N Q) - ell co ,~ 0 0 1i) N W "C .sco 0.0 00 "C N <( - ro It) ;:) 0 '0 0 <( N c: 0 ~ L. Q Ul Q) Q o N v o 10 "" .... ~ v 10 co co .... CD .... ~ v 10 co !Xi .... co .... ~ v "" co o co .... .... ~ .... ~ III ;::, C III ""') iii - Gl Ul Ul <( - Gl Z 'C Gl - U ';: - Ul Gl ... C ~ Ul Q) Q '~ Q) en .... en .E ~ Ul _ c: Q) Ul CD ~ ~ > ell <1l Gl.<:::_ IX:(,),E: MOOOI'? NOOON vOOOv cDLliLliLli~ OMN "" "" "" ...... 00000 00000 00000 oLliLliLliIO NMN co co CD ...... Oloooen COOOOCD Oloooen v. 0 0 N. CD ~ CONN 0 M ~ ...... V""" CO V 10 f'--OVNv vCOCOCOI'? M M oj r-: v~ NM...... co I{) 10 ...... en Gl :l Ul C '" Gl o > <1l Gl Ul c: IX: <1l~ ~~~ c: ,!!1 I- cf::2: .... .... .... .... .... o <1l ro en Q) .<::: :g E ~ g :l o Ul en"C .. <1l Gl Q) .c g oa: Ul W Ul Ul <( E! '0. ell (,) I'? N v~ .... "" "" .... o v o 10 o ~ uf I'? co 0 CD I'?~ .... I'? en CD en~ CD o v~ .... 10 v I'? v. co 10 .... en Gl r.J .. :l o en .. Gl .c - o "C C ca en Gl :l C Gl > Gl IX: iii ... o I- I'? v co~ .... N 10. I'? MOf'-- ...... 0 Ol OeoN vf'--N .1{) N eo N Ol o .... I .... ..; CD ~ .... ......OMOV f'--1{)......OI'? eof'--MOen Lli ...: ai Lli o. T"""NCD IIf""" N Ol N .... I'? N ~ 10 N q I'? ......oeooen f'--OeoOIO eocoeoOI'? Lli ai oj Lli en. T"""T"""""'" IIf""" N Ol N en .... ~ 10 CD ""0 N vf'--v 10 vOlN CD O.M.Ol. I I'? Ovv en T"""T"""t--. en N eo 0 .... a; :c .!! 'iQ > <( iii - o I- Ul <1l Cl .... ell Ul.<::: III ro(,) l!! "i:: ""C ::s tnQ)c ~_ <1l- Q ell ell "C en '~ ::2: gJ >. ; l!!<1l-gQ~o. :l en ell '~ "5 wI< ~ <1l0 'C ro Ul C5~~roiii 8.~a.Q)E.O I< <1lg-:5e1ll- wc..enO(,) .... - '" :gO en f!? ::::l.l!! .. Ul Gl c: .c ~ 01- o o o 10 en I'? o v o I'? 10 v~ N I'? v 10 I'? 10 .... o o 10 N v I'? o o o ,.: v o .... .... en 10 CD I'? I'? "" N CD co .... .... ~ o N v o 10 "" .... ~ en 10 co v CD en M CD v~ .... .... CD 10 .... ~ 10 CD I'? lri v .... .... v 10 co !Xi .... CD .... ~ III Gl III ::::l .. Gl .c o 'C C ca III Gl .. :l ~ "C C Gl a. I< w iii - o I- .... I'? ... Gl .c E Gl U Gl C iii - Gl Ul III <( - Gl Z 'C Gl - U ';: - Ul l!! c ~ @ CITY OF ANDOVER Sewer System Financial Projections Actual Actual Actual Estimate Forecast Year 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Inflation Fador - expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 0 Acres Added 65 65 50 50 35 35 35 35 35 35 New Connections 200 200 150 150 100 100 100 100 100 100 New Customers 200 200 150 150 100 100 100 100 100 100 Total Services 6,995 6,996 7,656 7,828 7,928 8,028 8,128 8,228 8,328 B.428 Rates Base Rate 46.00 47.84 49.75 51.74 53.81 55.96 56.20 60.53 62.95 65.47 Use Rate Connection Charge 341 351 361 372 387 402 418 435 452 470 Area Charge 1,252 1,302 1,340 1,379 1,434 1,491 1,551 1,613 1,678 1,745 Connection/Area 3% 3% 3% 3% 4% 4% 4% 4% 4% 4% Base Rate 3% 4% 4% 4% 4% 4% 4% 4% 4% 4% Use Rate 0% 0% 3% 3% 3% 3% 3% 3% 3% 3% Base Use 1,287,168 1,336,825 1,523,475 1,620,000 1,706,423 1,796,988 1,892,198 1,992,163 2,096,990 2,207,125 Penalties 22,418 18,914 19,646 25,000 25,000 25,000 25,000 25,000 25,000 25,000 Interest (1.416) 4,016 33,601 35,000 35,000 35,000 35,000 35,000 35,000 35,000 Other 7,527 7,624 5,000 5,000 Total 1,308,168 1.369,282 1 ,564,346 1 ,685,000 1,771.423 1,856,988 1,952.198 2,052.163 2,156,990 2,267125 Expenses Operations 986,413 988,704 1,139,365 1.248,434 1,309,110 1,348,363 1,388,835 1.430,500 1,473.415 1,517,617 Debt Service 410,873 7,000 7,000 Capital Outlay 61,173 5,000 300,000 Replacement Reserve 390,000 400,000 300,000 350,000 350,000 400,000 400,000 450,000 500,000 Total 1 787,286 1,395.704 1,207,538 1,553,434 1,659.110 1,998,363 1,788,835 1,830,500 1,923,415 2,017,617 Balance. Unrestricted Annual Surplus/Deficit (479,118) (26.422) 376,808 131,566 112,313 (141,395) 163,363 221,663 233,575 249,508 FB 12/3112000 Balance 1,268,468 1,242,046 1,618,854 1,750,420 1,862,733 1,721,338 1,884,701 2,106,364 2,339,939 2,569,447 Connection Charges 246,773 365,173 350,165 100,000 36,700 40,200 41,800 43,500 45,200 47,000 ~) Area Charges 50,190 52,185 54,285 56.455 58,730 61,075 Interest 34,135 39,185 37,532 45,000 45,000 45,000 45,000 45,000 45,000 45,000 Replacement Reserve 390,000 400,000 300,000 350,000 350,000 400,000 400,000 450,000 500,000 Special Assessments 331,507 16,959 94,484 40,000 40,000 40,000 40,000 300,000 300,000 Other 72.228 48,122 Total 1,002.415 913,545 530,303 485,000 523,890 527,385 581,085 544,955 898,930 953,075 Expenses Debt Service 127,957 463,254 453,266 453,266 453,266 Capital Outlay 144,377 207,904 455,017 523,900 207,000 520,500 774,000 150,000 150,000 150,000 Total 272,334 671,158 455,017 523,900 207,000 520,500 774,000 603,266 603,266 603,266 Balance Annual SurplusIDeficit 730,081 242,367 75,286 (38,900) 316,890 6,885 (192,915) (56,311) 295,664 349,809 FB 12/3112000 Balance 741,739 984,126 1,059.412 1,020,512 1,337,402 1,344,287 1,151,372 1,093,061 1,388,725 1,738,534 New Development Projects 170,250 175,500 120,500 124,000 150,000 150,000 150,000 Crosstown Blvd Trunk 353,650 400,000 Yellow Pine Lift Station 650,000 lift Station #1 Upgrage 25,000 MSA Routes - New I Reconstruct 6,500 Rural Reserve Sanitary Trunk 3,500,000 Equipment GPS 5,000 Jet Vac TRIck 300,000 Total 528,900 207,000 820,500 774,000 3,650,000 150,000 150,000 Funded by Operations 5,000 300,000 Funded by Infrastruc:turelTrunk 523,900 207,000 520,500 774,000 150,000 150,000 150,000 Funded by debt 3,500,000 528,900 207,000 820,500 774,000 3,650,000 150,000 150,000 Tenn 10 10 10 10 10 10 10 10 10 10 (] OS Annualized 453,266 Total Annual Debt Service 453,266 453,268 453,266 (ii) CITY OF ANDOVER Budget Worksheet - 2007 8 Sanitary Sewer 5200-48200 Account Number Description Actual 2003 Actual 2004 Actual 2005 Budgct 2006 Estimate 2006 Requested 2007 Charges for Services 54255 Sewer Department Fees 493 1,719 602 55210 Sewer - General Sales 1,279,950 1,308,721 1,519,103 1,360,969 1,620,000 1,706,423 55215 Sewer - Other Sales 3,140 25,217 4,372 4,000 55240 Sewer - Penalties 22,416 18,914 19,646 20,000 25,000 25,000 Charges for Services 1,305,999 1,354,571 1,543,723 1,384,969 1,645,000 1,731,423 Investment Income 56910 Interest Earned 25,934 10,289 34,120 20,000 35,000 35,000 56920 Valuation Adjustment (27,351) (6,274) (519) Investment Income (1,417) 4,015 33,601 20,000 35,000 35,000 Special Assessments 57300 Spec Assess - Interest & Penal 70 57400 Special Assess - Certified BiI 3,584 3,168 4,323 2,000 5,000 5,000 Special Assessments 3,584 3,168 4.393 2,000 5,000 5,000 Miscellaneous Revenue 58100 Refunds & Reimbursements 4,100 2,629 58120 Contributions 454,925 1,220,797 539,962 58155 Sale of Dsed Equipment 3,427 Miscellaneous Revenue 454,925 1.228,324 542,591 ~) Other Financing Sources 59100 Operating Transfers In Other Financing Sources Total Revenues 1,763,091 2,590,078 2,124,308 1,406,969 1,685,000 1,771,423 Salaries & Benefits 601\0 Salaries - Regular 132,412 146,664 170,864 100,554 100,554 147,827 60210 FICA 8,046 8,368 9,768 6,235 6,235 9,]66 60220 Medicare 1,901 2,029 2,286 1,459 1,459 2,143 60310 Health Insurance 1\,62] 12,294 15,566 8,694 8,694 22,310 60320 Dental Insurance 886 877 1,131 784 784 1,284 60330 Life Insurance 180 183 69 32 32 48 60340 Long-Term Disability 331 364 428 228 228 351 60410 PERA 7,349 7,196 8,902 6,033 6,033 9,239 60520 Workers Comp 829 946 ],031 1,257 1,257 2,218 60990 Inter-City Labor Allocation 1,080 90,595 90,595 59,427 Salaries & Benefits 164,635 178,921 210.044 215,87] 215,871 254,013 ~ @ CITY OF ANDOVER Budget Worksheet - 2007 '\ Sanitary Sewer 5200-48200 \.J Account Actual Actual Actual Budget Estimate Requested Number Description 2003 2004 2005 2006 2006 2007 - Departmental 61005 Supplies - General 2,502 1,273 1,536 1,500 800 1,500 61020 Supplies - Operating 4,612 4,307 5,260 5,200 4,600 5,200 61050 Supplies - Diesel Fuel 61105 R & M Supplies - General 1,988 9,691 5,804 6,200 7,000 9,200 61125 R & M Supplies - Streets 61130 R & M Supplies - Landscape 308 2,000 2,000 2,000 61140 R & M Supplies - Sewer 779 3,000 4,000 6,500 61205 Small & Expend - Small Tools 125 68 60 500 600 500 61220 Software 2,985 857 200 200 200 61310 Meals / Lodging 445 400 400 400 61315 Continuing Education 200 418 850 1,000 850 61320 Annual Dues / Licenses 1,292 965 125 150 200 150 61405 Postage 835 1,013 983 900 700 900 61410 Transportation / Mileage 374 208 211 400 250 400 Departmental 16,445 18,382 14,397 21,300 21,750 27,800 Operating 62005 Electric 2,230 3,578 3,802 4,500 4,500 4,500 62015 Natural Gas 2,000 2,000 2,000 62030 Telephone 169 415 653 725 800 1,110 62100 Insurance 3,360 3,368 3,440 3,543 3,543 3,720 62200 Rentals 16 75 9 500 500 500 62205 Central Equipment Services 33,184 33,184 34,194 35,220 35,220 38,742 62210 Computer Services 8,000 9,000 10,000 11,500 11,500 11,500 :) 62300 Equipment Maintenance Contract 1,641 1,100 1,800 2,300 62305 Software Maintenance Contracts 62900 Depreciation 415,336 437,329 463,782 Operating 462,295 486,949 517,521 59,088 59.863 64,372 Professional Services 63005 Professional Services 13,971 13,627 11,778 12,250 9,000 13,275 63010 ContractuaI Services 70,226 10,030 65,914 125,000 120,000 9,000 63025 Publishing 22 400 400 400 63030 Printing 250 250 250 63040 Locate Service 1,930 3,905 6,311 5,800 5,800 5,800 63100 R & M Labor - General 7,733 2,579 4,879 6,400 5,000 122,400 63110 R & M Labor - Streets 10,724 63230 Metro Waste Control Comm 603,070 644,721 732,281 768,000 768,000 768,000 Professional Services 707,654 674,862 821,185 918,100 908,450 919,125 Capital Outlay 65300 Improvements 4,250 65400 Vehicles 65500 Office Equipment 65600 Equipment 431 5.000 5.000 Capital Outlay 4,681 5,000 5,000 Other Financing Uses 67101 Operating Transfers Out 843,391 467,000 47,000 342,500 342,500 394,000 Other Financing Uses 843,391 467,000 47,000 342.500 342,500 394,000 Total Expenditures 2,199,101 1,826,114 1,610,146 1,561,859 1,553,434 1,659,310 Net Incr (Decr) in Net Assets (436,010) 763,964 514,162 (154,890) 131,566 112,113 ~J @ " '\ '-~ J!l Q) t/) t/) <( .... Q) Z 't:l e ~ u.. e t/) Q) C) e n:s .c 10. t/) (J Q) 't:l 10. 't:l > e Q) 0 ~ ~ e /) 't:l u.. n:s Q) eQ)U) t/) '-", <( t/) Q) 10. .... 'I: E ~ o C. 10. .... ~1o.0 't:l Q).... 1- .... U'J e (J e Q) W C. >< W t/) Q) ~ e Q) > Q) 0:: .... 0 .... e Q) E Q) .... n:s .... U) ~j '0 JB.,..... 0.0 00 'ON <( - 1Il .. lU CO E 0 :;:; 0 '" N W '0 lIlCO -..0 0.0 ON ~ m to :;, 0 ~ 0 N - c: 0 Q "- 0 '" 1Il 0 ~ 0) .... ..; ltl .... ~ 0) '0:1' CO N M .... 00 00 00 LON CD N ~ 0) '0:1' CO N M .... o o '0:1" CD co N ~ ~ N co ai ~ 00 00 00 LON CD N 00 00 'CDCO ,..: CO N 00 00 'LOltl ,..: CO N o o ''0:1' as CO N 'O:I'M~NCO COLONCOO NLOmLOM oq:"":c-i"":O '0:1' ltl N N ~ .... ~ III :::I C l'Il .., iii - Cll III III < - Cll Z 'C Cll - U 't: - III E c ::::l '" Cll o '2: Cll en "- III .E ~ "'.. C Cll '" Q)E'~ aijgi!! a: U c: III CI) :::I '" C :;, CI) o > Cll CI) '" r::: a: Cll.!!! ECi):! I1l 0 0 c: Ul t- ~~ 1Il CI) l::!E :::I o !!! I/)~ ... Ul CI) r::: :: ~ 01- o o CO ,..: CO N o o ltl ,..: CO N o 0) o '0:1' 'O:I'~ N CO .... CO 0 N '0:1' co o M o ltl N 1Il CI) U ... :::I o I/) ... CI) .c (5 '0 C ca III CI) :::I C CI) > CI) a: ca .. o I- ~ 0) 0) OOM mLO'<t ..-mLO oioo",,: N..-M ..- ..- .... '0:1' '0:1' 0) '0:1' M o N '0:1' MomON NLO~Oltl LOOLOO.... c-i '<t- oi LO .... N..-O ltl ..- ..- N M CO 'CO O)~ ~ N MomON NO'<tO~ LOOt--ON N-N-NLON N..-M ~ ..- ..- N M M 0) 0)" N M t--t--O m'<t'<t ONt-- CO- c-i ri CD..-m CI) :c .!! 'iij ~ "iii .. o I- Ul Cll ~ I1l III .c III mU E "i:: U ::::s ~ .s r::: ~ U I1l I1l 'tl III ':;: :2 lfl >- ; (1)..."-'Oo.!!!c. Olc:.__>< :::Ienl1l~:;'w ==mUlCllO -gr:::~~m"iii cPOc.Q)~O ~ ~ g.:5 g-1- wa.enOU '0:1' CO '0 N 0) .... .. :J :go 1Il !!! ~~ ... '" CI) c: .c I1l (5~ o o o an"' .... o o o an"' .... o N o ~ o N an"' ,..: .... CO N o o o ltl" M CO CO '0:1'" 0) N '0:1' .... M ,..: '0:1' .... ~ N ltl .... tD CO N ~ 0) .... ..; ltl .... ~ ~ ~ 0) M .... .... ~ '0:1' CO o ,..: 0) ..- 0) '0:1' CO N M .... ~ in CI) III ~ ... CI) .c .. o 'tl C ca 1Il CI) "- :::I .. :0 c CI) c. >< w "iii .. o I- .... M ... Cll .c E Cll u Cll c J!f Cll III III < - Cll Z 'C Cll - U 't: - III Cll ... c ::::l 6V r~ I ',J ~ o Ul ~ .~ ; 8- .. :::0 In In ~~ en:5 1: ~ <ll 0> E ro t:: c: ro ro 0.:2 <ll";:: Cl 0 U <ll ~ is / ') , ' ~ :~ ~ .. ;= .. In e8 0'" cn~ "'0 t.: c: <ll :J'E LL <ll U ti o U "C .. u~~ "'0 "g'" III c .."'~ cgo 8NN "ii ::I:g~ tlo <c'" '" .. ~ .. ..:l = c .. ... 00 "C c: ro Ul <ll J::. .B '6 iii <ll a. '0. iii <ll (5 J::. c: ro E iii c: '00 ro .0 J::. U 1\1 U iii ~ <ll ~ <ll Ul E ~ o ... Ul ui "C <ll c: U 0 c:o. ro c: c: <ll .2! E c: ,_ u"m ~ <(:2Ul Ul 'E <ll Iii > ':; C' W W l- LL "C .. ... ... "0 "'0 "g'" III OOMO C)LC)(])LO T""C')CO<O~ O')~ajcio NT"".q-C) ~ 0'" oeo '0<0 lri~ ~O> N ~ ("l')OmOOON NLO......OOOLO C LOOOLOOO.,.... "c '" N"'/:- cO ri lri lri <0 g"'.....M...... """(0 :::0 '" N U ~ ......eo... C')v.....("l') ONN'" ~'t)cDNm~ci n8coT""C"') (0 <c'" N 00 00 '00> Ll)N o "'/: ~ '" .. '" = .. .. '" .. .. 'E .. 00 Ul <ll 0> ~ Ul ro Ul U)~B B ,~ '* Ul '~ ~ :2 <ll <ll <ll ,2 en enell~"C -U)CJ)cu ~ ,91 en ~ ~a.ffi..c:: iu g.:; ~ a.enOa. >- ro .... Ul :J <ll o Ul -~...J Jg....<( .- <ll I- g.::; 0 UOI- "C E Ul c: <ll GJmcacu u;~ :;0_..... ~Q) ~-a~~ i~ >~-c..iu...::.. roo o'o.g-'O Ii) .s:5~"C..... (I) t: -g"CDlffi~ffi~ ca~~f/)..ea.;;. <ll E U ,5 >- ,5 >- rn....cuUJcoma. ro~c:ro~-E c:"CUl.oro,5 -~oQJ..c:::......cuou '~>-E.BQ)Eo. ~moro3o(U _Q)3:~o~.......c Q)ra.c<(~~.s .c~- .wo.... ,ES 2-g'= ~ m cu ~ "en ":;: .~ 'E >. QU)t:o(ijo..c:: J::.'-oE,<:u16 ~~-giu~~QJ .0 Ul o.g-E!l E m:25c.miS"* =....."CQ)t=o~ ":: cri '_~ co ~ Q) QJ "0"'" ::::.....cn= Q)~c:130:::::l,- m'E~.l!!~~g o~>.s~'U):e "'Of!?~ui~m~& ~~~~~E8m ~~~c:~u~~ni ~ ~ :;::; Q)c: OUl :>; - ... ~ :!::::: Q) C<Ilc:"C"Croo.<Il s.. .c 0 c: ~ ~ .!!! CD =-'1- a. 0 ClU"C I- ~ ~ ~ .. '" .. .. 'E .. 00 Ul c: o ., .!!! :J 0> ~ I., ifl 0,'2: IQ> '00 ,- :(0 115 ~ Q> ,<l. .Ie ., Q> Ol ., l;; co .c U) 'C: U fl ~ en .~ ::E fl 8J 1;- 015 .~ "'C :s ~ U) Q.l m 0 U) .~ (f.J co - ~ Q.S~:[ ~5~J .cc. c: ,Q ~ :is "'0 J::.o ~o C:O .U) .,.... ro~ .0 , J::. Ul g.H ~ 0_ B '0. ~a~ "'~o ~ .....UJa~rn .c....LO_ <ll Ll) <ll ~~~ <ll , _ en Ul Ul c5~~ ~.g'~c: =...JQ)QJ ~~cn ~ ;.<.5 ro ~ "'.l11:J_ ~ ~ "00 .~'ffi jg 10 6lt55l ooO::UO:: ~ Q> .c: ~I "C .. - ... "0 "'0 "g'" III 0...'" ~"!~ _NN 0> '" O"'/:Ll) O"'/:N C --~Nm ~gm N :::0", U 0"'... 0...... "ii o_..;-.i .a ~ m 'II;f' yO <c'" .. .. = C ... '" = U .. .. Q., Ul '" ~ .. <ll ~ E ~Iii ~ 0:5 ::J t5 c: c: ~ ::J 0 c: "'U:2<( "C .!!,....O ~gg -g N 0)- III u~ "'I~'<ll "'/:~o N~ ~ - <=",0 ~oo ~oo aNa) ,Ll) t5 ~I~I~ , calnO '=00 yoO <c"'o> C").~ t5 ~ <ll "'/: N-a:: '" .. .. = '" .. .. :; .. .. = '" = .. .s: .. .. =-. ~111 '~I~ U) Era-g 'iij E 0 E ell ~ e!U)U)O Q) Q) c:,:+:; ~ ~ ~I~ cn'-..c:E <3 ~~I:~ ............uU) o 0............ '-Q)OO ~ C) . . E m ~:~ ~I~I~I~ ~~ ~~ ~~ , I . I . I . I , I , I , I , I . I , I , I . I . I . I , I , I . I . I . I . I . I . I . I . I . I . I . I , I . I . I . I . I . I . I . I , I . I . I . I . I . I , I . I . I . I . <( I- o f-'" UJUJ oZ oZ ~ c:l~ "c,: OUJ 0> N o 00 UJz f-<( 0. O~ 00 <(>- f- u @ CITY OF ANDOVER Budget Worksheet - 2007 " -, Storm Sewer '-J \ccount 'lumber 5300-48300 Description Actual 2003 Actual 2004 Actual 2005 Budgct 2006 Estimate 2006 Requested 2007 Charges for Services 55310 Storm Sewer - Utility Charge 117,469 238,894 244,264 268,400 285,000 285,000 55340 Storm Sewer - Penalties 1,169 3,196 2,927 Charges for Services 118,638 242,090 247,191 268,400 285,000 285,000 Investment Income 56910 Interest Earned (320) 306 1,367 2,000 2,000 56920 Valuation Adjustment 787 186 Investment Income (320) 1,093 1,553 2.000 2,000 Special Assessments 57300 Spec Assess -Interest & Penal 7 57400 Special Assess - Certified Bi! 1,178 500 800 Special Assessments 1,185 500 800 Miscellaneous Revenue 58100 Refunds & Reimbursements 376 58120 Contributions 6,105,502 457,669 574.902 Miscellaneous Revenue 6,105,502 457.669 575,278 Other Financing Sources 59100 Operating Transfers In Other Financing Sources !~-\ Total Revenues 6.223,820 700,852 825.207 268,400 287,s00 287.800 ' ' , ' -.J Salaries & Benefits 60110 Salaries - Regular 28,908 70,484 70,744 60210 FICA 1,324 4,149 4,153 60220 Medicare 310 979 971 60310 Health Insurance 1,856 6,782 5,764 60320 Dental1nsurance 156 500 516 60330 Life Insurance 11 34 32 60340 Long-Term Disability 48 175 176 60410 PERA 1,200 3,769 3,742 60990 Inter-City Labor Allocation 23,721 122,523 122,523 129,190 Salaries & Benefits 33,813 110,593 86,097 122,523 122,523 129,190 :~ @ CITY OF ANDOVER Budget Worksheet - 2007 ..- -\ Storm Sewer 5300-48300 '--~ \ccount Actual Actual Actual Budget Estimate Requested ~umbcr Description 2003 2004 2005 2006 2006 2007 Departmental 61005 Supplies - General 50 100 50 61020 Supplies - Operating 414 3,592 250 250 500 61050 Supplies - Diesel Fuel 61105 R & M Supplies - General 509 1,968 3,781 4,000 4,000 7,500 61130 R & M Supplies - Landscape 1,786 3,000 3,000 3,000 61145 R & M Supplies - StolIDS Sewer 1,309 4,430 2,356 4,000 4,000 4,000 61205 Small & Expend - Small Tools 180 700 700 700 61220 Software 86 61310 Meals I Lodging 13 61315 Continuing Education 61320 Annual Dues I Licenses 550 500 500 1,700 61405 Postage 379 616 1,000 1,000 1,000 61410 Transportation I Mileage 103 500 500 500 Departmental 2,232 7,593 12.247 14,000 14,050 18,950 Operating 62005 Electric 93 96 150 150 150 62100 Insurance 77 153 157 162 162 2,162 62200 Rentals 11,500 11,500 11,500 62205 Central Equipment Services 15,014 31,504 32,463 23,437 23,437 25,781 62210 Computer Services 1,300 62300 Equipment Maintenance Contract 687 62305 Software Maintenance Contracts 830 62900 Depreciation 91,632 188,846 205,815 /-, Operating 106,723 220,596 239,218 35,249 36,079 40,893 \J Professional Services 63005 Professional Services 6,647 30,386 4,493 23,000 4,000 23,150 63010 Contractual Services 18,388 13,933 55,667 55,000 55,000 50,000 63025 Publishing 129 74 1,000 500 1,000 63100 R & M Labor - General 565 10,000 10,000 10,000 63200 Inspections 1,663 4.091 103 6,500 4,000 6.500 Professional Services 26,698 49,104 60,337 95,500 73,500 90,650 Capital Outlay 65300 Improvements 65600 Equipment 5,000 5.000 Capital Outlay 5,000 5,000 Other Financing Uses 67101 Operating Transfer.; Out 5,000 5,000 15,000 15,000 15,000 Other Financing Uses 5.000 5,000 15.000 15.000 15,000 Total Expenditures 169,466 392,886 402,900 287,272 266,152 294,683 Net Incr (Decr) in Net Assets 6,054,354 307,966 422,307 (18,872) 21,348 (6,883) :.J @ (j) '-~ 1685 CROSSTOWN BOULEVARD N,W. . ANDOVER, MINNESOTA 55304. (763) 755-5100 FAX (763) 755-8923 . WWW.CI.ANDOVER,MN.US TO: Mayor and Councilmembers FROM: Jim Dickinson, City Administrator SUBJECT: Charitable Gambling Ordinance Research Update DATE: October 24,2006 INTRODUCTION The City of Andover has a Gambling Ordinance (attached) that guides charitable gambling within the City of Andover. At a recent meeting the Council was asked to review the ordinance by a local sports association. At the October 3rd Council meeting the Council directed staff to survey some other communities, attached are the results. DISCUSSION ,. --" "--/ If modifications to the ordinance are desired by the Council, staff would prepare the necessary ordinance amendments and bring those to a future Council meeting or workshop for review. After that review, the Council would then be requested to schedule a public hearing on the ordinance. ACTION REOUESTED The Andover City Council is requested to review the attached survey results, the current City Gambling Ordinance and provide direction to staff if any modifications are needed. J[ '.J. C) City Gamblina Survey o How do you define your trade area? Roseville - Must have an address in the city, be a tax exempt organization and be in existence for at least three years prior. Woodbury - Do not specifically define the trade area. White Bear lake - Define the trade area as the communities that border White Bear Lake, Blaine - Didn't answer. Arden Hills - The corporate boundaries of the City and each City immediately contiguous to the City. S1. louis Park - The cities of St. Louis Park, Minneapolis, Edina, Hopkins, Minnetonka, Plymouth and Golden Valley located in this state. Ham lake - Encompassing the Anoka County Area, Communities of Ham Lake, Oak Grove, East Bethel, Linwood Township, Columbus Township, Lino Lakes, Blaine, Coon Rapids, and Andover. Eagan - The cities of Apple Valley, Bloomington, Burnsville, Inver Grove Heights, Mendota Heights, Rosemount, and Sunfish Lake, New Hope - Area within the boundaries of the City and within the boundaries of the cities of Crystal, Robbinsdale, Golden Valley, Brooklyn Center and Brooklyn Park; provided that a contribution to ISD 281 is deemed to have been made in the trade area of the city. Coon Rapids - The cities of Coon Rapids, Andover, Anoka, Blaine, Brooklyn Park, Champlin and Fridley. Anoka - On their Oct. 16th agenda. Will check back with City Clerk after the 16th. Oak Grove - The City of Oak Grove and the cities of Andover, Ham Lake, East Bethel, Bethel, St. Francis, Ramsey and the Town of Burns. Cottage Grove - Didn't answer. Ramsey - Cities of Ramsey, Anoka, Andover, and the Town of Burns in Anoka County, the City of Elk River in Sherburne County, and the City of Dayton in Hennepin County. i ! i. o Do you have a 10% gambling ordinance? Roseville - Collect 10% of the net profits, which goes to the Roseville community fund, and 3% of gross receipts, for administrative costs. Woodbury - No. Under Eligibility for License and Use of Proceeds there are restrictions. White Bear lake - No. Blaine - Yes, collected by the Finance Dept. Arden Hills - Yes, Collect 10% of net profits, to a special fund to be administered by the City Council for lawful purposes. Payments to the fund shall be calculated for quarterly periods ending on the last days of March, June, September and December each year. St. louis Park - No, Ham lake - No, Eagan - No. Every organization shall expend 60% of its expenditures from gambling in the trade area. New Hope - Yes. Coon Rapids - At least 10% per year of an organization's net profits must be expended for lawful purposes within the City of Coon Rapids, No less than 60% per year of the organization's net profits must be expended for lawful purposes within the City's Trade Area, Anoka - Yes, the organization shall be required to spend 10% of its net profits within the City, upon a lawful purpose specifically designated by the City Council, unless the organization can show that it spent an equivalent or greater sum for the benefit of citizens of the City within the preceding year without such council designation. @ o Oak Grove - Yes, the organization shall either contribute 10% of its net profits to a fund administered and regulated by the City without cost to the fund, for disbursement by the City for lawful purposes; or expend 10% of its expenditures for lawful purposes on Local School Purposes. Cottage Grove - Yes, require gambling organizations to contribute 10% of net profit each month, Ramsey - Any organization shall be required to contribute a certain percent of its net profits from lawful gambling to a fund administered and regulated by the City without cost to such fund, The required percent to contribute shall be established from time to time by Council resolution. Do you have a limit on the number of locations an association can be at? Roseville - No limit to the number of locations an association can be at. Woodbury - No limit to the number of locations an association can be at. White Bear Lake - Yes, a limit of three within the City. Blaine - No limit to the number of locations an association can be at. Arden Hills - Nine lawful gambling locations are allowed in Arden Hills. St. Louis Park - No. Ham Lake - Yes, a limit of three within the City. Eagan - No limit of locations an association can operate legal gambling, New Hope - No. Coon Rapids - Yes, a limit of three within the City. Anoka - No. Oak Grove - Yes, a limit of five total locations for a year. Cottage Grove - Yes, two locations within the City, Ramsey - See ordinance. () Do you have a limit on the number of associations per facility? Roseville - No limit on the number of associations per facility. Woodbury - No limit on the number of associations per facility. White Bear Lake - Yes, only one per location. Blaine - No limit on the number of associations per facility. Arden Hills - Not at this time, St. Louis Park - No. Ham Lake - No. Eagan - No limit on number of associations per facility. New Hope - No, Coon Rapids - Yes, only one per location. Anoka - No, Oak Grove - No, Cottage Grove - Didn't answer. Ramsey - See ordinance. o Any other suggestions/recommendations? Roseville - Currently have three associations using the bingo hall. Arden Hills - Attached a copy of their ordinance for review. Ham Lake - Attached a copy of their ordinance for review. Eagan - Can access their code via www.cityofeagan.com - Section 6,35 cj) o :J ~ New Hope - Only allow local non-profit organizations which have operated for at least three years within the City. St. Louis Park - Provided copy of their ordinance for review, Coon Rapids - Copy of Code from website. Anoka - Only allow fraternal, religious, veterans, or other nonprofit organizations which have been in existence for at least three years and has at least 15 active members, Oak Grove - faxed a copy of their ordinance for review. Ramsey - Have a copy of their ordinance for review. Look at Ordinance 94-05, repealed and replaced original ordinance. @ L . C) I 'e IJ I 'e ~J e Page 1 of 1 ORDINANCE #94.05 CITY OF RAMSEY ANOKA COUNT STATE OF MINNESOTA AMENDMENT TO CHAPTER 7 WHICH IS KNOWN AS THE LICENSING AND PERMITS CHAPTER OF THE CITY CODE. AN ORDINANCE AMENDING CHAPTER 7, SECTION 7.61 ENTITLED "LAWFUL GAMBLING" OF THE CITY CODE OF RAMSEY, MINNESOTA The City of Ramsey ordains: SECTION 1. A.UTHORITY This Ordinance is adopted pursuant to the authority granted by Minnesota Statutes, Chapter 349. et al. SECTION 2. A.MENnM~NT Section 7.61 of the City Code is amended to read as follews: 7.61.01 Purpose The purpose of thillseclion is to regulate and control the conduct of lawful gambling pursuant to the provisions of Chapter 349 of Minnesota Statu~s. 7.61.02 Adoption of ~ererenc:e Ckapter 349 of Minnesota SWutei is adopted by reference the same as if fully set forth h~ln. 7.61.03 Notice; Approval or Disapproval The applicant for a lawful gambling premises permit ("premises pennit") within the City sha11.appIY 10 the Council in writinS in ~ manner I'e'JW= by law for a premises permit. at least 60 days before issuing or rcncwina the premISCS 'p~rmit. Each application for a premisel permit shall be a.pproved. or disapprovcQ by the Council. "1.61.04 Location Lawful .ambling under license issued by the Minnesota Gambling Control Board ("Board") may be conducted only at locations that comply with applicll.ble zoning, building, fire ~ health codes of'the City. AIlll.pplications must be for a specific location with the exception of Clul!! D (raffle only) licenses. The following loeations ~ oonsidertld unsuitable for iamblin~ op=rations and any request for a. p~milell permit It such a IQCation will bo rejected W1thOUt clear and convincing ~vidcJice that such II. location will not pose undue enforoement difficulties, (~ssen property vatu" of adjoining properties, or expose gambling to persons under 18 years of age: a. Areas zoned for agriculture or residential use; @ http://156.142.111.1 05/weblink7 IImageDisplay.aspx?cache=yes&sessionkey=WLImageDisplay&uniqu... 10/18/2006 Page 1 of1 I " .) '-- " e b. Locations where the predominant clientele is und<< the age of 18 years, '7.' 1.05 Condition a Tho conduct of lawful gambling under license i!lsued by the Board shall be subject to the following oondidons in ihc 011: I 1-- " 1 iJ A eopy of any lease agreement betwcon It non-profit organization and a gambling location owner or operator sh&ll be filed with the Administrator together with the p~mi5C5 pennit application; Tho Council may refuse to issue I premiSC8 permit for a location in which gambling violationa have previoualy occurred, and the Council may refuse to issue a lawful gambling premi&e8 pennit to a non-profit organization which bas previously violated tenns of this Code and/or Minnesota Statutes, Chapter 349. The maximum number of gambling devices at anyone loeation in the City shall be limited to two of anyone type of device. The maximum number of each gambling device may be operated by anyone or more than one organization llolding a pnmtises pcnnill1t anyone location. 7.61.06 love_UIlIUon b. a. c. e Every Ol'ganization which files an application for i"uance or renewal of a premises permit shill deliver tho a.~plication to the Adminiitrator. The Administrator shall investigate each appJlc.ation and report any findings and recommendations to rhe Council. 7.61.0' FlUng of Recordsj Inspections; Access ao Records Subd.l.Every organization holding a premiscs pennie to conduct lawful gambling in the City shall flle with the Administrator copies of ell records and reports required to be filCd with the Board purSUW1t to Minnesota Statutes, Chapter 349 and the rules and regulations promul~ated th~eunder. The. reconls and reports shall be filed in the office of rho AdminIStrator on or before the day they IlrO required to be filed with tho Board; Subd.2.Every gambling ovcmt in the City conducted by an organization under Minnesota. StatlllCJ, Chapter 349 shall be open to insp,ction by officers of the Ramsey Police Deparrment; . Sllbd,3.The Administrator or employees of the Police D~a.rtm.ent. at the direction of the Administrator, may inspect at any roalfonll.ble time, without not~ or search warrant, a.U rocords of Il.J1 organization holding a premises permit in the City, including Bambling r.ccount and oth~ bank records required by the Board to oe mdntaincd and ~servcd. 7.61.08 Fee Tho City will charge all new applications the maximum invo.stigadon fee pmnitted by Minnesoea Statutes. Chl-prer 349 in order to cover costs incurred. investi~ating the applb.tion. Any unused portion of this fee will be refunded to the applicant. This fe~ does not apply to applications for roncwal of pre.mise pennitll or additional sites for an orgattli.al:i.on cW'l'entJy holding a premises pennit in the City. (1) http://156.142.111.1 05/weblink7 IImageDisplay.aspx?cache=yes&sessionkey=WLImageDisplay&uniqu... 10/18/2006 ~ tit I . ,~ (~' e '1 'J e ~ It Page 1 ofl . . 7.61.09 Use of Lawful Gambling Net Pron.. Any cq:anization that holds a premises.PCtRrlt sball be ~uired to contribute a certain pere~t of its net profits from Jawfulsamblini to I fund administered and regulated by the City without cost to such fund. The ~uired percent to be oontributed shall oe that percent established from timt to time by Council resolution. However, in no event snan the required percent be greatet than that amount allowed by Chapter 349 of Minnesota StatulClI. Disbunc~t8 from this fund shall be for lawful purposes as determined from time hi time by Councl1 resolution. The term I1net profits" aIi used herein shall be defined al profits1ess amounts expended for allowable expenses. "Allowable eltpenscsll as LlSed herein shall not include those "lawful purpose" expenditures defined by Chapter 349 of Minnesota StatLIt:es. 7.61.10 E"pendflurea for Lawful Purposes Within CUy's Trade Area An~ organization holding a pmmSOJ pemlit to conduct lawful J.ambIing within tho City shall be required to e]li~~d 75% of its "lawful PUIpOllC" expenditures on lawful purposes condl1Cled or localCd Within the City's trade area and to the benefit of the City's trade area. In the event the CJ.ty is unable to detem1ine with a reasonable degree of certainty that the required 7!% oIlhe lawful pU!'Posc expenditum of the organization holding a premises pcimiuo conducllawful gambllnS within the City is being expended on lawful pUlpOses, the City Administra.tor may require such other finanoiw infonnation as is reasonably neecllllUy for tho Oty to maXc this determination. Por putposea of this subsection. the tem1lrllde area is defined as the Cities of Ramsey, Anale.. Amlever, and lhe Town of Bums in Anon COllnty, the City of Elk River in Shetbume Count~ and the City of Dayton in Hennepin County. For :purposes of this subsootion, the lenn "lawful purpose(s)" is that definition assigned to 11 by Minnesota Statutes. Chapter M9. Thil subsection shallllpply to all organizations holding a premises permit to oondul:t lawful gambling within the City. SECTION 3. vrnLATlON~ Anyone who violates dle provisions of this section shll1l be guilty of a misdemeanor. This section does not preclude civil and criminal penalties under applicablelaw8. Failure to file timely report& and pa.yments as required by this &ection may result in a recommenda.tion to the Board that the organization's premises permit should be revoked. SECTION 4. SUMMA.RV The followil\J'u the offICial summary of Ordin8Jlce 94-05, which has been approved by the City Council of the City of Ramsey as clearly informing the public of the intent and effect of the Ordinance. The ordinance .~peab the ~isting elt)' Code Section 7.61 and replaces it with a new Section 7.61. This section ll:to mgulale and control the conduct of lawful gambling pursuant to the provisions of Chapter 349 of'Minnesota Statutes. G) http://156.142.111.1 05/weblink7 /ImageDisplay.aspx?cache=yes&sessionkey=WLImageDisplay&uniqu... 10/18/2006 Page 1 ofl , .. t. I . r) \......... I I Ie SECTION S. EFFECTIVR DATE The effective.dato of this Ordinanoe is thirty (30) days after its pamge and. publicalion, subject ID City Charter Scction s.m. Adopted by the Ramsey City CollIlCil the 24th day of May. 1994. ~~~ Ma)'Cf ATTEST: JJ?li:A , I ,- " I J e IntroductJon Date: Po.tln. Dates: Adoption D.te: Publicatlon Date: Effective Date: Ma, 10, 1994 May 10 - 24, 19P4 Ma)' 24, 15194 May 27, :1994 June 27, 1994 ~ e ~ http://156.142.111.1 05/weblink7 IImageDisplay.aspx?cache=yes&sessionkey=WLImageDisplay&uniqu... 10/18/2006 r' ') 1....-' SECTION: 5-3-1: . 5-3-2: 5-3-3: 5-3-4 : 5-3-5: 5-3-6 : 5-3-7: 5-3-8 : 5-3-9: CHAPTER 3 c,+~ ()~ ~~dov-fr o()ol i "",- n r( GAMBLING Purpose Definitions Licensing Requirements Premises Permit Approved Organizations Management Expenditures, Profits And Taxes Background Information Violation; Penalties 5-3-1: PURPOSE: The purpose of this chapter is to closely regulate and control the conduct of gambling and to ensure that profits derived from gambling activities in the city provide, to the extent authorized by law, direct benefits for the citizens of Andover. (Amended Ord. 258, 5-4-1999) 5-3-2: DEFINITIONS: For the purposes of this chapter, the following words and terms will have the meanings given them: / -., . I 'oj BOARD: LAWFUL GAMBLING: The State Gambling Control Board. The operation of gambling activities by an organization eligible for a license from the Board to conduct such activities. NET PROFITS, LAWFUL PURPOSE, AND ALLOWABLE EXPENSE: Will have the meanings provided in Minnesota Statutes Section 349.12, as may be amended from time to time. PREMISES PERMIT: ~J A resolution adopted by the City Council authorizing the named organization to operate lawful gambling activities at a specified location in the city. @ ,..- '\ '...j :) \.._j ~) TRADE AREA: The cities of Andover, Anoka, Coon Rapids, Ramsey, Oak Grove, and Ham Lake. (Amended Ord. 258, 5-4- 1999) 5-3-3: LICENSING REQUIREMENTS: A. State License Required: Except as specifically exempted by this chapter, no organization may operate lawful gambling activities in the city without a license issued by the Board. B. Disapproval Of License: Nothing contained in this chapter shall be deemed to limit the City Council's authority to disapprove a license for lawful gambling. C. Limitation Of Gambling Licenses: No organization shall be permitted to conduct gambling in more than three (3) establishments within the city. Only one organization shall be permitted to operate or sell lawful gambling devices at an owned or leased establishment. (Amended Ord. 258, 5-4- 1999) 5-3-4: PREMISES PERMIT: A. Qualification For Permit; Compliance With Provisions: No organization may obtain a new or renewal premises permit, or maintain a premises permit, unless the organization and location of the lawful gambling activities remain in full compliance with the provisions of this chapter and all state laws related to lawful gambling as those laws may be amended from time to time. B. Application For Permit: Application for a new or renewal premises permit must be made to the City Clerk on forms provided by the city. C. Number Of Permits Per Location: Only one premises permit may be issued to any particular location in the city. D. Revocation Of Permit: The City Council may by resolution revoke the premises permit of any organization that does not comply with the requirements of this chapter or state gambling laws as those laws may be amended and revised from time to time. Prior to adopting a revocation resolution, the organization will be given at least ten (10) days' notice of the time, date, and place of the revocation hearing. At the hearing, the organi zation may appear with or without counsel and submit evidence on its behalf. A resolution revoking a premises permit must include the basis for that action. A certified copy of the resolution will be forwarded to the Board. (Amended Ord. 258, 5-4-1999) @ r -\ ,-j 5-3-5: APPROVED ORGANIZATIONS: A. In order to be eligible for a premises permit, an organization must meet each of the following requirements: 1. The organization has at least fifteen (15) members that are residents of the city. Such organization must conduct regular meetings at least monthly, and each person must attend not less than fifty percent (50%) of all regularly scheduled meetings and pay dues annually in order to be considered a member of such organization for qualification under this chapter. 2. The physical site for the organization headquarters or the registered business office of the organization is located within the city and has been located within the city for at least two (2) years immediately preceding the application for a license. 3. The physical site where the organization regularly holds its meetings and conducts its activities, other than lawful gambling and fund raising, is in the city and has been located within the city for at least two (2) years immediately preceding application for a license. /- -" , ) <J 4. Meet all the qualifications for a lawful gambling license issued by the Board. 5. The paddle wheel game is prohibited except for meat raffles, and no premises permit shall be issued to any organization to conduct the paddle wheel game except for meat raffles. (Amend. 10/18/05, Ord. 315) 6. The maximum rent allowed in leases to charitable organizations must be in compliance with what is set forth in State Statute. No other services or expenses provided or contracted by the lessor may be paid by the organization, including but not limited to trash removal, janitorial and cleaning services, snow removal, lawn services, electricity, heat, security, security monitoring, storage, other utilities or services, and in the case of bar operations, cash shortages. Any other expenditures made by an organization that are related toa leased premises must be approved by the Director of the Gambling Control Board. Rent payments may not be made to an individual. (Ord. 313, 9/06/05) B. Any organization, which meets the conditions set forth above shall certify in writing on its application which conditions are being met. (Amended Ord. 258, 5-4-1999) ,r ) \.~ 5-3-6: MANAGEMENT: All gambling operations must be managed by a @ (~-, ,-__J bona fide member of the licensed organization. (Amended Ord. 258, 5-4-1999) 5-3-7: EXPENDITURES, PROFITS AND TAXES: A. Expenditures For Lawful Purposes: 1. During any year that an eligible organization is licensed to conduct gambling events, not less than ninety percent (90%) of its lawful purpose expenditures will be for lawful purposes conducted or located within the city trade area. A semi-annual report of the expenditures for lawful purposes within the trade area shall be provided to the City Clerk on or before July 2 and February 2 of each year after the date of the adoption of this chapter. 2. Not less than ten percent (10%) per year of the amounts specified herein must be expended for lawful purposes within the city. B. Contribution Of Net Profits: During any year that an eligible organization is licensed to conduct gambling events, such organization shall contribute ten percent (10%) of the net profits derived from lawful gambling to a fund administered and regulated by the city, without cost to such fund, for disbursements by the city of the receipts for lawful purposes. ,,- " '.j C. Gambling Tax: Pursuant to Minnesota Statutes Section 349.213, a gambling tax is hereby imposed of one-tenth percent (0.1 %) of the gross receipts of each licensed organization from all lawful gambling less prizes actually paid out by the organization. Such tax shall be imposed and commenced to accrue as of September 1, 1991, and shall be payable at the office of the City Clerk on October 2, 1991 and on or before July 2 and February 2 of each year thereafter. D. Records And Reports: All qualified organizations operating gambling devices in the city shall keep monthly financial records of same and provide such records to the City Clerk commencing September 2, 991, and on or before July 2 and February 2 of each year thereafter. (Amended Ord. 258, 5-4-1999; amd. 2003 Code) ~J 5-3-8: BACKGROUND INFORMATION: Acopy of all applications and reports required by and submitted to the Minnesota Charitable Gambling Control Board shall also be sLbmitted to the City Clerk within seven (7) days after they are submitted to said Board. (Amended Ord. 258, 5-4-1999) @ r--" . -' 5-3-9: VIOLATION; PENALTIES: Any person violating any of the provisions of this chapter shall be guilty of a misdemeanor and subject to all penalties provided under state law. (Amended Ord. 258, 5-4-1999) \ \ ---' ~J @