Loading...
City of Hopkins - Equipment Replacement PlanEquipment Replacement Plan 2002 - 2006 Background EQUIPMENT REPLACEMENT 2002 -2021 The Equipment Replacement Plan is a twenty year forecast of equipment needs in the City of Hopkins. It is intended to alert the Council and citizens to the major equipment needs on the horizon. The first year of the plan becomes an adopted equipment budget and relates almost completely to the operating budget of the equipment replacement fund, which is approved on a yearly basis. The remaining nineteen years represent an estimate of equipment needs and funding capabilities of the City. Funding requirements vary from year to year. In order to maintain a more even levy year by year, the twenty year schedule is projected with a 3% inflation factor and a yearly average dollar need for the equipment replacement fund is presently $719,100. The cash flow requirements to fund the equipment needs in the equipment replacement fund, will experience a roller coaster effect over the next 20 years given the projected equipment needs and 3% inflation rate. Available funds will increase through the year 2002 and then the funds will fluctuate substantially for the next 17 years. The current intergovernmental charges of $496,000 will need to increase by $10,000 each year for the next 20 years in order to provide sufficient funds to carry us through 2021. The increase of $10,000 a year is about a 2% increase in charges to the general fund. Overall these charges represent 6% of total general fund expenditures. The increase is needed to get closer to the average dollar needed to fund the equipment replacement plan without issuing bonds. The Equipment Replacement Plan's basic premise is scheduled replacement of present equipment. A new item, must in the year proposed, be presented in the annual operating budget with a stipulation that replacement will be necessary in the future. Flexibility of the Equipment Replacement Plan is established through annual review and revision, if necessary. Highlights of changes from last year: Fire: The Laverne Pumper scheduled for replacement in 2002 has been pushed out to replacement in 2003. The costs of the pumper should not fluctuate too much over a one -year time frame. Purchasing the pumper one year later than planned saves the city about $11,000 in gained interest earnings in 2001. Breathing apparatus for the fire department was moved up from 2003 to 2002. The cost of the apparatus increased $30,000. Public Works: The purchase of a one ton dump truck has been moved back one year from 2002 to 2003. The engineering van will need to be replaced in 2003 instead of 2004. A tractor replacement can be moved to 2003 instead of 2002. Activity Center: The replacement of the copy machine is not needed due to a donation of a new copy machine in 2001. Finance: The financial software package replacement can be postponed until 2006 if we upgrade the current system in 2002. In 2006 we would analyze further upgrades or replace the entire system including utility billing. Art Center: Water Fund: The copy machine will not need replacement until 2004. The air compressor does not need replacement until 2004. CAPITAL EQUIPMENT EQUIPMENT REPLACEMENT FUND 2000 2001 2002 2003 2004 2005 2006 Working Capital Begin Year 1,465,507 1,492,662 1,661,008 1,806,375 1,291,231 1,471,926 742,551 Revenues from charges 487,945 496,000 506,000' 516,000 526,000 536,000 546,000 Interest earnings 63,501 89,006 82,327 62,717 57,454 65,585 32,764 Other revenues 42,600 15,000 15,000 15,000 15,000 15,000 15,000 Total Revenues 594,046 600,006 603,327 593,717 598,454 616,585 593,764 Expenditures (excludes Depr.) 19,996 21,960 23,460 24,960 26,460 27,960 31,460 Capital Outlay - Equipment 546,993 409,700 434,500 1,083,900 391,300 1,318,000 476,300 Working Capital Ending Balance 1,492,662 1,661,008 1,806,375 1,291,231 1,471,926 742,551 828,555 Cash balance 1,478,190 1,646,536 1,791,903 1,276,759 1,457,454 728,079 814,083 Working Capital Balance 12/31/06 828,555 Source 2002 2003 2004 2005 2006 Total Equipment Replacement Fund 434,500 1,083,900 391,300 1,318,000 476,300 3,704,000 MAC - Arts Center Fund 8,500 8,500 HRA - Housing and Redevelopment Authority 22,800 22,800 PA - Pavilion Fund 60,000 60,000 RF - Refuse Fund 198,000 198,000 SF - Sanitary Sewer Fund 8,000 81,400 21,800 111,200 WF - Water Fund 8,000 67,700 10,600 86,300 Report criteria: Project Type: Equipment All Departments All Categories All Priority Levels All data All data Total CAPITAL PLAN City of Hopkins, MN SOURCES OF REVENUE SUMMARY 2002 thru 2006 510,500 1,106,700 746,900 1,328,600 498,100 4,190,800 Page 1 of 1 Source CAPITAL PLAN City of Hopkins, MN PROJECTS BY FUNDING SOURCE 2002 th,u 2006 Project# Priority 2002 2003 2004 2005 2006 Total Equipment Replacement Fund City Hall Main Copy Machine 01- ERP -001 0 17,000 17,000 17,000 17,000 19,000 87,000 City Hall Small Copy Machine 01 -ERP -002 0 23,200 23,200 Network Server Upgrade 01- ERP -003 0 5,000 5,000 5,000 5,000 5,000 25,000 Telephone System 01- ERP -004 0 102,700 102,700 Finance Computer System Software 01 -ERP -005 0 30,000 150,000 180,000 Computers 01- ERP -006 0 30,000 30,000 30,000 30,000 30,000 150,000 Refrigerator /Freezer 01 -ERP -031 0 4,000 4,000 Luveme Pumper 01 -ERP -101 0 318,500 318,500 Administrative Vehicle 01 -ERP -103 0 20,900 20,900 Lite Rescue 01 -ERP -105 0 62,400 62,400 Stuphen Aerial Truck 01 -ERP -106 0 687,000 687,000 Breathing Apparatus 01 -ERP -108 0 130,000 130,000 Extraction Tool 01 -ERP -109 0 20,300 20,300 Copy Machine 01 -ERP, -110 0 7,400 7,400 Radio System 01 -ERP -111 0 177,000 177,000 Marked Patrol Vehicles (5) and Sergeant's Vehicle 01 -ERP -200 0 65,800 34,200 106,800 74,000 38,500 319,300 K -9 Marked Patrol Vehicle 01 -ERP -201 0 37,000 37,000 Utility 4x4 (211) 01 -ERP -203 0 29,700 29,700 Police Administrative Vehicles (2) 01 -ERP -204 0 20,300 21,000 21,500 22,200 22,800 107,800 Radio System 01 -ERP -205 0 300,000 300,000 Copy Machine 01 -ERP -207 0 16,500 16,500 Logging Recorder 01 -ERP -208 0 29,900 29,900 1/2 Ton Pickup 01 -ERP -300 0 19,200 19,200 3/4 Ton Truck 01 -ERP -301 0 27,200 27,200 1 Ton Dump Truck (2) 01 -ERP -303 0 30,500 30,500 1 Ton Traffic Boom Truck 01 -ERP -304 0 50,400 50,400 Single Axle Dump Truck (2) 01 -ERP -305 0 80,000 80,000 Front End Loaders (2) 01 -ERP -308 0 194,300 123,400 317,700 Roller 01 -ERP -312 0 37,300 37,300 Striper 01 -ERP -313 0 10,100 10,100 Engineering Van 01 -ERP -700 0 14,300 14,300 Public Works Radio System 01 -ERP -750 0 47,200 47,200 1/2 Ton Pickup Truck 01- ERP -800 0 20,300 20,300 4x4 3 /4Ton Trucks (2) 01 -ERP -801 0 53,200 53,200 Page 1 of 3 Source Project# Priority 2002 2003 2004 2005 2006 Total Tractors (2) 01 -ERP -806 0 32,700 34,700 67,400 Trucksters (3) 01- ERP -807 0 14,300 15,600 16,600 46,500 iding Mowers (2) 01 -ERP -808 0 15,000 15,000 Turf Sweeper 01 -ERP -811 0 11,600 11,600 Brush Chipper 01 -ERP -813 0 19,100 19,100 Trailer Flatbed 01 -ERP -814 0 1,400 1,400 Equipment Replacement Fund Total 434,500 1,083,900 391,300 1,318,000 476,300 3,704,000 HAC - Arts Center Fund Arts Center Copy Machine 01 - ERP - 1100 0 8,500 8,500 HAC - Arts Center Fund Total 8,500 8,500 HRA - Housing and Redevelopment Au 4x4 3/4 Ton Truck 01 ERP - 400 0 22,800 22,800 HRA - Housing and Redevelopment 22,800 22,800 Authority Total PA - Pavilion Fund Ice Resurfacer F - Refuse Fund efuse Truck Public Works Radio System PA - Pavilion Fund Total 60,000 RF - Refuse Fund Total SF - Sanitary Sewer Fund Utility Truck 01 -ERP -550 0 Rodding Machine 01 -ERP -553 0 Telephone System 01 -ERP -557 0 8,000 Public Works Radio System 01 -ERP -558 0 SF - Sanitary Sewer Fund Total 01 -ERP -1000 0 60,000 01 -ERP -900 01 -ERP -903 0 WF - Water Fund Air Compressor 01 -ERP -503 0 Public Works Copy Machine 01 -ERP -506 0 Telephone System 01 -ERP -507 0 8,000 Public Works Radio System 01 -ERP -508 0 WF - Water Fund Total Page 2 of 3 148,000 50,000 198,000 198,000 31,400 50,000 17,700 50,000 10,600 21,800 60,000 60,000 148,000 50,000 21,800 31,400 8,000 50,000 8,000 81,400 21,800 111,200 17,700 10,600 8,000 50,000 8,000 67,700 10,600 86,300 Source Project# Priority 2002 2003 2004 2005 2006 Total Report criteria: Project Type: Equipment All Departments All Categories All Priority Levels All data All data GRAND TOTAL Page 3 of 3 510,500 1,106,700 746,900 1,328,600 498,100 4,190,800 Department Report criteria: Project Type: Equipment All Departments All Categories All Priority Levels All data All data Total CAPITAL PLAN City of Hopkins, MN DEPARTMENT SUMMARY 2002 thru 2006 2002 2003 2004 2005 2006 Total Activity Center 4,000 4,000 Arts Center 8,500 8,500 City Hall Administration 184,700 52,000 52,000 52,000 227,200 567,900 Fire 130,000 523,800 769,700 1,423,500 HRA 22,800 22,800 Pavilion 60,000 60,000 Police 115,800 355,200 128,300 133,200 107,700 840,200 Public Works: Administration • 47,200 47,200 Public Works: Engineering 14,300 14,300 Public Works: Parks/Forestry 98,000 83,800 34,700 18,000 234,500 •ublicWorks: Streets/Traffic 40,600 80,000 328,400 123,400 572,400 Refuse 198,000 198,000 Sewer 8,000 81,400 21,800 111,200 Water 8,000 67,700 10,600 86,300 510,500 1,106,700 746,900 1,328,600 498,100 4,190,800 Page 1 of 1 Department Arts Center Arts Center Copy Machine HRA 4x4 3/4 Ton Truck Pavilion Ice Resurfacer CAPITAL PLAN City of Hopkins, MN PROJECTS BY DEPARTMENT 2002 thru 2006 Project# Priority 2002 2003 2004 2005 2006 Total Activity Center Refrigerator /Freezer 01 - ERP - 031 0 4,000 4,000 Activity Center Total 4,000 4,000 01 - ERP - 1100 0 8,500 8,500 Arts Center Total 8,500 8,500 City Hall Administration City Hall Main Copy Machine 01 -ERP -001 0 17,000 17,000 17,000 17,000 19,000 87,000 City Hall Small Copy Machine 01 -ERP -002 0 23,200 23,200 Network Server Upgrade 01 -ERP -003 0 5,000 5,000 5,000 5,000 5,000 25,000 Telephone System 01- ERP -004 0 102,700 102,700 Finance Computer System Software 01- ERP -005 0 30,000 150,000 180,000 Computers 01 -ERP -006 0 30,000 30,000 30,000 30,000 30,000 150,000 City Hall Administration Total 184,700 52,000 52,000 52,000 227,200 567,900 Fire Luveme Pumper 01 -ERP -101 0 318,500 318,500 Administrative Vehicle 01 -ERP -103 0 20,900 20,900 Lite Rescue 01 -ERP -105 0 62,400 62,400 Stuphen Aerial Truck 01 -ERP -106 0 687,000 687,000 Breathing Apparatus 01 -ERP -108 0 130,000 130,000 Extraction Tool 01 -ERP -109 0 20,300 20,300 Copy Machine 01 -ERP -110 0 7,400 7,400 Radio System 01 -ERP -111 0 177,000 177,000 Fire Total 130,000 523,800 769,700 1,423,500 HRA Total 01- ERP -400 01 -ERP -1000 0 60,000 60,000 Page 1 of 3 22,800 22,800 22,800 22,800 Department Project# Priority 2002 2003 2004 2005 2006 Total Public Works: Engineering Engineering Van Refuse Pavilion Total olice Marked Patrol Vehicles (5) and Sergeants Vehicle 01 -ERP -200 0 65,800 34,200 106,800 74,000 38,500 319,300 K -9 Marked Patrol Vehicle 01 -ERP -201 0 37,000 37,000 Utility 4x4 (211) 01 -ERP -203 0 29,700 29,700 Police Administrative Vehicles (2) 01 -ERP -204 0 20,300 21,000 21,500 22,200 22,800 107,800 Radio System 01 -ERP -205 0 300,000 300,000 Copy Machine 01 -ERP -207 0 16,500 16,500 Logging Recorder 01 -ERP -208 0 29,900 29,900 Police Total Public Works: Administration Public Works Radio System 01 ERP - 750 0 47,200 47,200 Public Works: Administration Total 47,200 47,200 Public Works: Engineering Total Public Works: Parks/Forestry Total Public Works: Streets/Traffic 1/2 Ton Pickup 01 -ERP -300 0 3/4 Ton Truck 01 -ERP -301 0 1 Ton Dump Truck (2) 01 -ERP -303 0 1 Ton Traffic Boom Truck 01 -ERP -304 0 Single Axle Dump Truck (2) 01 -ERP -305 0 Front End Loaders (2) 01 -ERP -308 0 Roller 01 -ERP -312 0 Striper 01 -ERP -313 0 60,000 60,000 115,800 355,200 128,300 133,200 107,700 840,200 01- ERP -700 0 14,300 14,300 14,300 14,300 Public Works: Parks/Forestry Ton Pickup Truck 01 -ERP -800 0 20,300 20,300 x4 3 /4Ton Trucks (2) 01- ERP -801 0 53,200 53,200 Tractors (2) 01- ERP -806 0 32,700 34,700 67,400 Trucksters (3) 01 -ERP -807 0 14,300 15,600 16,600 46,500 Riding Mowers (2) 01 -ERP -808 0 15,000 15,000 Turf Sweeper 01- ERP -811 0 11,600 11,600 Brush Chipper 01- ERP -813 0 19,100 19,100 Trailer Flatbed 01- ERP -814 0 1,400 1,400 98,000 83,800 34,700 18,000 234,500 Page 2 of 3 19,200 19,200 27,200 27,200 30,500 30,500 50,400 50,400 80,000 80,000 194,300 123,400 317,700 37,300 37,300 10,100 10,100 Public Works: Streets/Traffic Total 40,600 80,000 328,400 123,400 572,400 Department Refuse Truck Public Works Radio System Report criteria: Project Type: Equipment All Departments All Categories All Priority Levels All data All data Refuse Total Sewer Utility Truck 01 -ERP -550 0 Rodding Machine 01- ERP -553 0 Telephone System 01 -ERP -557 0 8,000 Public Works Radio System 01 -ERP -558 0 Sewer Total Water Air Compressor 01 -ERP -503 0 Public Works Copy Machine 01- ERP -506 0 Telephone System 01 -ERP -507 0 8,000 Public Works Radio System 01 -ERP -508 0 GRAND TOTAL Project# Priority 2002 2003 2004 2005 2006 Total 01 -ERP -900 0 148,000 148,000 01 -ERP -903 0 50,000 50,000 Page 3 of 3 198,000 198,000 31,400 50,000 21,800 21,800 31,400 8,000 50,000 8,000 81,400 21,800 111,200 17,700 50,000 10,600 17,700 10,600 8,000 50,000 Water Total 8,000 67,700 10,600 86,300 510,500 1,106,700 746,900 1,328,600 498,100 4,190,800 v� .:c'Zns �<�.:�.>, :.. :+:+ ,>z: m .c0. a r..x .. r ,y r+ . .8 c x° .�' k .. ... +, rr . ':�:. ,S. o T° :r . ,. s ;. . ., .. nr�. v��/. s. . .rte .. ,,,...M •ut°.:.y . .0a g .::.. , .. " ,"8,.,.. A� .., . sY. 3 a, 4 . a. , , $.E yr ..,.r . . 8 .. .. ..,,. 4. .. r� ° . Y3 .. ..., .. �,.`S�i�lsC..H::a'�£>�,..2ar/.: .n..> >^ . ^ .. ^ �� . , ..,n^ R>x " . ,i . >r. u w. < R� m .,,..,. b ,. k° ,n` wy.<'6.. � .... ... .° a . .. tt.:e ., . o. �. .. ..�� ..a .>u < ... .. C,+e�uw, � .. a ..$ . � .,. ".'� ., .s� .. . � �.r ..3, .., a.^+ : .. .. .. ,.. .... m.Z>:..��, o� 687,000 .:: ,. .."t. � , . ° . ., n � ) 3k� 343 "." J� ,�iL .."'K to ... .al ,,.,,...2.?,'. ; , r ..a .r'� � ^r u . ..,.e `. £ : ..v �o... s l` K s> .. 'sa`v wn' �."..".. �s°, a+ s .,& .x0 �' : •4a� '€ < te a.. ... sE' ". �,,i.K "a�.k . . Y � ' ... :.. ... '.xi > . / .... . E 'n: .;x:xx,:':: .� &y°<✓: , .,r:,., , .. ,.. °:y _.�u�E, t ' v. .. ... . r .E . . c .,zc. .. ... . �v.,. r,. �`.` v" c .:�.xs�,>E :r; � � < .. <r.. �.. ..N.r " ... ,. ..H.kS °r.r V , . ..' �..: 8�'. ... .. �.. w ,.. r yw £ m ew . ... , .. .. >r Ci .. , . �" .� .. , .. �! ,. F., c Y" . �.. . , . s,,,.a>w ,.6� r,.; ,�° ,. w; )a.y ° ..,zC cy . >. . d. .c': � . - far, ,2 .. .tt..... .. :;£3: ft' . .. .. .. , c ,,, v "> .. , "a. a. ..... � c .. .. ... � . �!ws'.n ... . o � .^e ... a t . .:. �£z.a.....?,5.5..d,:i .,., .. h ; .. ..V�. u2.�`n�H%£ , +c wr. .. .: x.:v. >`r,,,r" :, �c< i Y ",'����. � 'x .: ro5 ... . ". ??,•r K . �5.. . .... ,. , x ., a< . ^ . ...�,. rr .. .:. � S z. .. 3'.., ..n �, ...�x�� ,+cr ` :. � .: r' �.1• < �.'�.rn ... dT�iwZ,^>°A ,..... . : E �:� s . .,. E ����� K .. . : . <:fi:rr. •;o"w . ,. a wl ... 4.. . , . 3 .. . . . ... > . e.. ... ,. w �m�. v,�.skv e ..' .: .r�"a °3 .. �' 3� .,f' y , >� '.� < �. � ..'<' .. , .. ; ' V ti. '.. :. . 1 " F>r .:. ,+:. .. K�. - . s"a,` 3Y . ^... > .RY:n4': K•H�a. � Y ' 9 � �� °S�E ,. ^•,;.� u ���4 ..��.,, !o,r`a f �w F?.` ; r�ss�. �, .... , w 5 :88' 8'" °L�, ... '� 6�5...S's ..cfl:� `.Y;.: c( � �'..s . 'r)Y .: t^ v: �c.� . .a:.. �." �' ., .,�..' ... .4. .... °.. ,.K �:i .. �a`:<, co., ..a.w.:.T..t...�"'. ,.�>v ,.. 489,900 ? .. $& ^t3 �.., ': � .°2 n' "`"�a[x"�x. ;;�'�`r q: x 'k�' ' :. � " . ,, .. ....E �'A a m .,.. 43 . „p' : ., ., .; ; :�. `X3'� .. .... ��: u..,Za> � `^ �� �':.) ,.< %•i -... ' •k.c�`TF�h 362,800 ..... :�.. < � � ') co :s ... ... e � " v; °k > Ems •.:: � " E.u�'yi � ; ti:r:: ;.k•,. � , ��. �9:°:dn.4.av, � � c � a x. -.. -.. bx...,,,:n ..< . �S . .. . ,. r:,��n ' .� '> ;xq.. �y%ym�0:£s:E',;'2ti ,� a ��'' ,�i»�c<c ,. .. 491,200 :� ":� -�a . ;s% tcp�; � � .. zws ... . ,.�'., . n.� i9, °.�,.a ..:. $ r ; .. "u<.n. ..111E11111 t).i.,] a� .&D. . �:. �, ,x<£� °, "° 3. a°�.w` . ° ,,.",. > ". sc,.a:.a «a � "; �:Y , w...,...o. > .. ,o,.+ �is:T.. ^o O.;F rSi b:S`. " �.,<,<.. r ..z" 'a:s3{F... >: " ....,.. >"3`�:x :.tt..� °;r � > °, m. :... " •x'':; :: ».:. ., cJ'.'.S= w • � ; / tril ta � ; ! WM ( � } faS \ c ,>t,... .a...a ... ... . :x tz £p, ,,. ::6' ) ,,2„, xUi.T. Z .✓ �u 130,000 , O Z wk�Om . ..�.. s to r. , ,.���.. �K. :y:4, m. 'OW !:�... •'� ^.. 130,000 339,400 < <w � , ,y.. � . , .... :�' .... 3 ... ...) z,a.,,:a ,.,.. �n� 7,400 � '' ���tE � 184,400 �' "x<... E. .... . .. �5.o >''�., . ,, .u. c. � ^`�.." .. .. > . . °� -, �}. .. xxwwv ��s�w" � cry: :n :�� 749,400 .. ...,.. ...� .w.�.> :�. .. /F :. , � ., ^ Yu. � xt3,. n '3 .. .. c n.k aa�� It ax , ..six.. w � 20,300 .. .. ,. R>7. ^�, .� .. .. : tYN h� 5,.c � ...,.r • ,:� x'v.. . . 'Y ... d ad %� r , K ^w ��,_, '..:: .:. . ,r F5 -' s�' ,<:. • ro . x,!w. i4i3 ... ° . :. . v ... u ><a. ,A.,,. S' d�` >• , ,,. <:� . � ., at`. F° ,,. � , 24,300 . 4 c .. .. , . , ... t . , . .sa ,., ".r*�,...�.. n A � :., ,A'°S: �i � fi .4 °..,w,..., •:y,r : ¢tt .. r:°< ... ..g ^ xx . .. �. .mss ..tea ., . . � c4 . . . k f3i . ST , ^.:w >7.y4^.<k � ... .. Y. .. .. . ) m. L,.I � �� ",. t, �> �... ,,; �� ��n:.�,.�� ..� '' HR y , z � a x io E. ,..s.. �. :....0 . s. f. .s > .. at c Y .o..E':s Y:Wk?.cRld, ;.x >...� ,.. lit .. . J.3 > : H ..... .S�. x . .Y< "� . : , 4t�` .,, ... E' ''c ,,�. .. "£d• , s, �.,.fs� .r,�� "y , .';. ... r ` .., .. .> «:k:�^ °i ' .>a 29,900 <.�.• . . . . .y EaS• a .a. ."° .e ra:. ".u,.«.. ^. ,.;;;.. ..c,;:�:y � ^. . ... x' .a ,;4. .�� �, ,..., r ,a" :ss �M: L x, ' 28,000 , .n. .Sn a INS y't+'r y °�:::t.:az ,:c.. .,,.....,4"v...3�n:n.. v6m..: ....m�n>... ,.::ar"`- ,4 . ,�, , >, ::ccj'r, .: s %4 ..5 �c,.. u.:. -' , ... .�''� 4:, ...a r,., . t, � ... ay' a . ^L°: > :Y:.:o+: , � .£4�. at...,..� �:. " ,, 9,900 ;u� " ,3. �, . " a? .. w .a. '>` .,, 9,900 573,700 r;;x: � • .: ';3 � � � .. ..a..w' �„ � .: <.t,..c.?;.o,.,.,.... .'�.�uy x�E'� c..a> �"'a"y . Y� ` RR" ' : aY) � 27,200 362,800 °'<.: .'� :y.���� .+::Y ` , .,... >.�.z�„ x.Y >.waha wr .w. 3Fx:ar:'C:w>3 < ..w. rr.,�'a..,. �: ""�•a ..?� .,. Sn �:..,r.Mw� .:.?c... �GZ:>:. r. E. a..,.' �' �s,::- ,.. ,.�.. iisc�� ' ,,. ./�d$ ` 523,600 :r " s:a;>, r.�L, n '`S ^�;' - .. r .:; �.= zw.3.r. ...�:4� °.3i�; aJ%f' h . .. ?�. xt� 02,5 ,+ , � ..n.�a . ''�<''. .a?� ^ii., �'.r�`.a.�.c.� >j'ag, >;'�._„x aa2a.) .::s. a< n>' �. « a ..K:...^�".z3,':� ^ «;�a..._..... ?i ce " ??:y. � n.SF ' k! w."�YF � sk r� ?� � .. 202,500 275,600 .3; �:. u::�, �... «y: :)n3'," " &F`2: ^�'��:." .. &. , , ku „ �.F3::z ; :.>�a.'��•.'<: ° a:.._<. ...,.. ^. ^. r9'�.'c . mono Sh :a'�'.'.�.� s <:r 'w tr�'*�:a':` ^�. Ct"fi ..S' .`Y3 ?. :mss; ^., . \ . 01. ^3r°� <S� „a. . +,. a .�. "+:., . ; } M. ERE 102 TELE- SQUIRT 104 HEAVY RESCUE 107 PIRSCH PUMPER • 109 STUPHEN AERIAL IRK SUBTOTAL BREATHING APPARATUS g. COPIER POLICE SQUAD #1 SQUAD #3 SQUAD #5 SGT. CAR 211 UTILITY 4X4 SUBTOTAL 218 ADMIN CAR SUBTOTAL INFLATION FACTOR 3.0% REPL EQUIPMENT YRS 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 COMPUTER SYSTEM tl:M,. - ?.i >i' � c. 2_- : y E �y"Sw i,,.Y.;r�•" LOG RECORDER SUBTOTAL 02 Jul -01 EQUIPMENT REPLACEMENT SCHEDULE Net General Fund 20 Year Avg: $660,500 K " :ga 25 25 25 25 15 10 0 115,800 55,200 128,300 133,200 61,300 29,900 00 103,600 186,700 130,300 115,600 120,200 124,600 180,000 181,700 WNW 313,700 .ice <.. BMW r' ; a x 'w# yy ^d _`R Y• tea' 8.8;,tr wiz L " F 36,700 84,600 201,300 209,400 93,900 �V a 186,900 295,200 421,600 e <: 45,200 174,300 3 32,900 ' Min es; t�'- .cc,>.4�8141,, < 3 4 3 34,200 � f r F >; 3°A "^ avyTCY M'561-1 > �••')1,�,'r'Z:.�' aF,r r TRIM "+ ' . al ' < 4 £� s L,o, 6 29,700 2 20,300 300,000 35,600 35,600 I LL 21,500 37,000 38,500 f: 40,000 Ar° 22,800 46,400 41,600 37,700 24,200 41,600 E s a3 ,' es4g$' 43,300 t r a .+ E'Ya sF.° � +, a 25,600 46,800 313,700 19,100 48,700 C : , i a�' 1 " 'k �c4c L (WA 'l3 a�'9, � Y 5�.. kar 48,700 -� `�' ` „., � M cE�, � , a � � s a rw �� a �£� `✓�r��„ F. „;a�� F'sa'4,. H,%t,§' %.. �.r.S�tF:3 �A>° ; : x> . 47,700 � ff b :, as `� k nx ?r:.,�.�?�x: a< 'aKrc 2' .b AVIV 50 36,700 52,600 *SG -ea _. yep. 54,700 Kr ' yy y � s 27,200 28,800 56,900 56,900 Ej s 3 . 22,100 59,200 61,500 G5): .K 64,000 RE Msx. G:• 32,400 467,200 66,600 ',200 66,600 m> )a ya. t v. < t; @,�xc,. � ^�v< n.�te��., ".:.a.�' "Jat,4un aSO..�uy: , 60,400 'NM 35,000 466,800 25,600 Page 2 308 1 TON DUMP 310 SGLAX DUMP P.W. STREETS/TRAFFIC 300 1/2 T TRK 304 1 TON DUMP 0 1/4 6 et 314 TANDEM DUMP REPL EQUIPMENT YRS 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 . 2015 2016 2017 2018 2019 2020 2021 1 316 WATER TRUCK 321 FRONT END LOADER v�' ":'. >n . A.'n3s...`�.w °�' •mow 326 GRADER 330 ROLLER 337 PAVER as 349 TRAILER SUBTOTAL P.W ENGINEERING 700 ENGINEERING VAN SUBTOTAL P.W. ADMIN RADIO SYSTEM SUBTOTAL 10 $;z 1 12 12 15 15 15 15 20 15 1 20 10 15 P.W. BLDGJEQUIPMENT SERVICES 703 1/2 T TRK 10 I xF J . gb` , 3Q' 34 ,40 30,500 ; h` "•'tug,, 80,000 14,300 14,300 I 1 1 40,600 80,000 k5••#`s` rrrray 47,200 47,200 19,200 • c ir ZF a �x� to '.�.M, • fi ir/F4- F a• 194,300 37,300 328,400 123,400 »:9Y , fi' �F'� r �� y 4 '3i�•u un �� i X a��Mt ION RPM F47. 'Rt.3'" WIVE 84,300 �i• 'OUR n,( 31,800 133,700 . 4,900 36,700 133,700 324,500 1 24,100 1 eL� ,, ;s, s: s , a �^• zgr� j:si. ixev 'r .,rs(y; • rr�•.q'. " h1 i y e� y ,�•� s' ,sA.y 1 v� b 134,200 M ro �r D �v. w his A 44,700 tub IBM 182,100 19,200 I 19,200 EAR ;4. 25,800 44,800 255,400 170,600 5"3'3. `�CYl. -Eon . � ;P?Y�`.:: ': . -wr z a< _sr �' n Z� _ Ya:. $ W K. � c, I 1 1 1 1 1 1 1 1 & � ;aT t4 58,800 124,500 u " ; •h� •a...m3,r�,';r,�^¢cS L •ru,�x:';FS;?�x`�, ?nF : ;fir, fir - ws..rM <� <b ✓���.�a �a< �'���6� �..., •Fw��.`k.�. ��i:=�ia�rF M��s a ,.�s�Z:�s.: y .a. r.., �'sk.a•, ? ��i .�. &cx'`,��.,�x�:F. r::,,s ..,;,,, ti3'� •.�s..ru <i ^.. 1 32,300 1 I 73,400 73,400 r \ c 302,900 144,300 58,200 y ,.,.�... ,, ... ..x, 124,500 505,400 45,300 r wt Nw'w 489,600 Page 3 EQUIPMENT p.W, PARKS & FORESTRY 800 1/2 TON TRUCK ICAO 802 3/4 TON 4X4 TRUCK 810 SWAP LOADER , tkii 812 AERIAL LIFT 817 TRACTOR 820 TRUCKSTER 823 MOWER 825 HUSTLER 830 TURF SWEEPER 834 BRUSH CHIPPER SUBTOTAL SUBTOTAL SUBTOTAL CITY HALL ADMIN C.H. MAIN COPIER C.H. NETWORK UPGRADE rr4 r' m;. REPL YRS 10 8 15 20 20 ,c 10 vs-4- 8 20 15 entil 10 7 ACTIVITY CENTER COPY MACHINE 7 .ter'- �.. s'a rte, �f•.• � xy� . If h ;.E almumm CABLE TV CAMERAS /CONTROL SYS. 8 I 2002 2003 2004 2005 2006 2007 2008 2009 2010 17;000 r 5 5,000 30,000 184,700 26,600 L. � a.b � . aeiiafi"rL'a 55,100 22,800 Iptp 20,300 32,700 14,300 11,600 19,100 98,000 83,800 34,700 18,000 4,000 EMU 17,000 5,000 NN 52,000 5,000 mow Van 150,000 19,000 227,200 a a 111,800 87,300 19,000 s 5,000 5,000 Tv- 54,000 54,000 40,600 I 19,000 132,800 54,000 8,600 8,600 D irge 19,000 21,000 5,000 5,000 • 56,000 6L , srm trip R p> irge" 2011 2012 2013 2014 P 33,700 86,500 27,200 Ulf , 25,600 • 72,000 246,000 t,. R t x3. 19,200 21,000 21,000 23,000 5,000 5,000 190,000 58,000 7 2015 2016 2017 2018 2019 2020 2021 I 51,500 I �a a mss• �-�.:.., �. , �.. IMES 100,100 28,900 W Ei et • 18,000 fite 51,400 23,000 5,000 58,000 a a re 61,400 25,000 wy _.t Sw 5,000 60,000 Y• Fa"it.rra'•A"t 1,r ,1. mss,., ro ":a 4 917 a. .. 2 D... Z 42,600 rs ISITE "": ate' a 109,400 25,000 �F y r 5,000 240,600 5,000 • 60,000 300,600 tig 50,900 53,100 5,000 Page 4 ERA 411 4X43 /4TTRK WATER 500 1/2 T S -10 a" 533 BACKHOE JACK HAMMER �i,t,2r o 'e ymo. P.W. COPIER (Water) f RADIO SYSTEM P.W. EQUIPMENT SUBTOTAL SEWER 509 UT 09 ILITY TRK �� 1 530 JET VACTOR 534 GENERATOR "ix aaF t r BILLING SYSTEM RADIO SYSTEM P.W. SUBTOTAL BILLING SYSTEM SUBTOTAL STORM SEWER BILLING SYSTEM PAVILION ICE RESURFACER ARTS CENTER COPY MACHINE REPL YRS 2002 20 25 aZFwlg 15 10 8 15 REFUSE 900 REFUSE TRK (RAP -R) 5 naY•Y ' M 8 law MEW of 8,000 1 8,000 12 1 60,000 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 I 22,800 'Rant illi3O40 AN 111111 50,000 67,700 �.,s2*�":re\� =•n.�,?,,. `� fit; 148,000 198,000 8,500 I I I I 1 10,600 10,600 n ' ..°3.80 x� s 3Y 040x RP Y*�cu 21,800 20,500 MIME 34,700 31,100 h 7 c3 3 ?1 56,600 8,400 n 5 25,500 8,400 8,400 I sttrt� ' x• ,NF VI TOP iN 28,600 12,200 171,600 k, �r at 4i" 3. Y s C 3 - Y y `4S t 171,600 ux h"� h 2 , O FF £°g ... . t�• \. ^:. ^.,>F�... .. A, °y is £ i r ebn 28,800 I 23,500 rya s' r s �� ES � 23,500 3;5 10,800 . 4iFt F� 93,000 I 10,100 I gs; p sa , , 4?� 10,800 134,800 ifittaR �z^v F < Q¢ 134,800 nal r 5f n , 2014 2015 frr A f �' x _rs� a; ti 198,900 Nag s` 198,900 88,100 14,200 32,200 �'E IMP r , 3LZ� „rc•r �Y.,Mir.m 32,300 32,300 10,800 10,800 I 44 41A 2016 29,400 2017 2018 Ma" �s "5 0 F �x 4 s =Vr 2^gi "sau 63,100 41,800 Fg 68,200 `•tea �� Latiti I I I 1 12,100 I I 36,500 . o.r �a �aM 16,500 111114111111 77,800 2019 2020 202I 77,800 TivZ 77,800 16,500 lit 180,800 126,700 180,800 230,500 11 308,300 31,600 23,000 Q s: nth 23,000 i I � Page 5 TOTALS GEN FUND VEH/EQUIP • Rr� , 0 Y . ' i se; Aft WATER REFUSE PAVILION GENERAL FUND TOTAL CABLE TV FUND TOTAL ALL FUNDS ANNUAL TOTAL GENERAL FUND SALVAGE "X 20 YEAR AVERAGES; FIRE EQUIPMENT rya >:.:�� .; -. •�a POLICE EQUIPMENT STREET EQUIPMENT ENGINEERING EQUIPMENT �<a HRA WATER UTILITY FUND o.7 y ' ,n.n REFUSE UTILITY FUND . _ 4 ". E, 1 PAVILION FUND UTILITY VEHICLES/EQUIPMENT 111111 2,601,200 10 1 f . w .. 2,882,100 mss "� 2,938,000 33,500 CITY HALL ADMINISTRATION ACTIVITY CENTER ADMINISTRATION 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 115,800 547,500 292,100 1,245,700 202,700 215,400 382,600 323,900 249,300 444,700 211,100 481,300 202,700 4' A;8 8,000 60,000 5r r. VP . y 7 Y, k 434,500 1,083,900 71•1426 � �fi8 F 148,100 ,tip ' =7 22,800 48,000 27,000 Ago 130,100 . • 144,100 146,900 1,700 103,000 2,059,000 23,200 1,200 • GENERAL FUND VEHICLE/EQUIPMENT 9,632,500 481,600 ��'g�'g; `Y•`"ti3'Y"c3�vY . � f`4 ...V�s'.EBR .:� GENERAL FUND TOTAL 14,412,700 720,600 88,100 4,400 5:71111111 27,600 989,000 49,500 MEW 2,466,200 123,300 67,700 198,000 10,600 pan 34,700 8,400 28,600 q• 171,600 391,300 1,318,000 F - 476,300 269,400 ki is �' tiQc TAW 436,600 0 386,500 • +.sr 12,200 ,412701 619,000 23,500 28,800 93,000 10,800 134,800 & 88,100 �:xyu 913,700 Ar. ':YH• 32,200 198,900 10,800 V F h i2 405,300 773,900 834,800 jrmC6 •, 4 � � b o nt 260,800 63,100 . ;.N .wSY;"tt ^c{ 3... w � : . t . tx ^7�. :� a. 2. • ^ ..cu. y 2 a , M , a x 11`^ . ,•3,s " raf � '' ?a,.ss,., . .e>Eri .0 k .rte. 737,700 343,700 910,000 . ra t(µ ..wGa . 36,500 77,800 �za 308,300 s 66 aHz 16,500 717,000 31,600 � »flC 260,700 998,900 956,700 521,300 1,540,500 477,100 1,677,400 808,800 Z11.1171/1 t r.b.. �.... '�r:< ,, ,,.".���`'��`..,,. 510,500 1,106,700 746,900 1,328,600 498,100 377,500 436,600 586,700 631,200 732,000 426,900 908,700 547,700 1,085,000 986,100 652,600 1,552,600 1,026,400 1,874,700 863,400 • 68,700 111,000. 46,700 65,000 68,400 86,100 34,100 58,900 58,900 58,900 58,900 58,900 58,900 58,900 58,900 58,900 58,900 58,900 c,. ... ... .w.cx'^" ,.> . ., . ..... ... ...t: � ^c.ct .., .. . E r .. ». ..... m . .y-- .yn. :r .s "+ ...^ <g' a. .. ^ ✓,G.:::r <o:.'.. ::: >: >:..: Y;::�;• <:::: •2:y . "'''i iP:?'f r •. n `,. ° . ... .�. � , .., r .._ .� .k. � w... >. n .. `✓r.. � ,.�..»'.,a m.b d. .,# x. 3'. A ,..M's.� �. �z .h.:.. �`:. , x1' ^'r ,tom(` 4a• �,n stn`. ; f. ^w . �: », 11.11" ` '`: k� �° 3 • ° .z ` a �F z.:: ter i ��i »s*Fi. '�: �' c ef . t > ,•� h � k�, t�"� ���! .�.�3.,'� :x`� �.«. . , �'cr ��r r: 741 ,., »..G .i..s.