The URL can be used to link to this page

Memo- 2007-2026 Equipment Replacement Plan CITY OF HOPKINS I FINANCE DEPARTMENT I MEMORANDUM Date: June 22, 2006 To: Mayor & City Council From: Christine Harkess, Finance Director Subject: 2007-2026 Equipment Replacement Plan Ovenriew The City of Hopkins is beginning the process of establishing the 2007-2026 equipment replacement plan. Every year the city council reviews with the city manager and staff, the equipment planned for replacement for the next five years. The goal is to ensure the city's priorities and objectives are being met and the funding sources are reasonable and available. Departments were once again asked to assess the equipment planned for replacement, evaluate the estimated cost and life expectancy of the equipment with the intent to prolong equipment life expectancy when practical and to refurbishing equipment instead of replacing it. Through a combination of several equipment changes and a better estimate of costs, departments were successful in accomplishing this goal. Included in the ERP draft is an explanation of the changes that are considered for implementation. ERP Goals Maintain the integrity, reliability and safety of city equipment. · Provide funding for replacement of current equipment as needed. · Forecast funding needs and tax implications to assure strong long-term financial stability. Attached is a draft of the 2007-2026 equipment replacement plan. DRAFT CITY OF HOPKINS 2007 - 2011 EQUIPMENT REPLACEMENT PLAN June 22,2006 . EQUIPMENT REPLACEMENT PLAN 2007 - 2011 Back2:round The Equipment Replacement Plan is a twenty-year forecast and a five-year plan of equipment needs in the City of Hopkins. It is intended to inform the Council and citizens of the major equipment needs on the horizon. The first year of the plan becomes an adopted equipment budget and relates to the operating budget of the equipment replacement fund, which is approved on an annual 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 fairly consistent levy each year, the twenty-year schedule is projected with a 3% inflation factor for operating expenses and a yearly average dollar capital expenditure of $701,600. 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 remain about the same through the year 2008, decrease for approximately five years before increasing again in preparation for replacement of some major fire and police equipment in 2018, and 2020. It is anticipated that the intragovemmental charge to the general fund will need to increase each year unti12012 to replace funds lost when charges to city funds was reduced in 2003 in response to aid cuts. If the rate increases proposed are implemented revenues in 2012 will have returned to 2002 levels. The charges after 2013 will continue to increase each year, but at a slower pace. The future increases in charges to the general fund should provide sufficient funds to carry us through 2026. Each year staff reevaluates the equipment needs and adjusts the schedule accordingly. Changes to the plan are reflected in the document. Refurbishments, extended life expectancy and closer cost estimates of replacements have been incorporated into the plan. The equipment replacement charges in the general fund represent approximately 3% of total general fund expenditures. Future increases each year are needed to fund the equipment replacement plan without issuing debt. 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's equipment replacement plan for the years 2007-2011: Art Center: Cost for the copy machine scheduled for replacement in 2011 has been increased by $2,000 to reflect current pricing. Activity Center: Copy machine scheduled for replacement in 2010 has been moved back to 2013 and the cost adjusted to reflect current pricing. The Activity Center was able to purchase a used color copier in 2006 at a significant savings. The purchase of the copier replaced an item in the 2006 ERP that did not need to be replaced as originally planned. Cable TV Expenditures for upgrades to council chamber studio equipment, lighting and cameras has been extended from $40,000 in 2007 to $5,000 per year. Equipment will be replaced when its useful life has expired. City Hall: Network infrastructure upgrade costs of $15,000 were added in 2007 for replacement of wiring in city hall. This will replace the substandard network wiring and will be done in conjunction with the reconfiguration of the office spaces. Useful life is estimated at 15 years. Fire: The 100ft aerial ladder truck scheduled for replacement in 2008 at a total cost of $900,000 ($600,000 federal grant, $300,000 ERP funding) has been reduced to $600,000 due to lack of federal grant funding. After two unsuccessful attempts to secure a significant federal grant, the grant application was scaled back to a lesser amount in 2006. The truck has also been scaled back to meet available funding from the equipment replacement plan. ERP funding remains at $300,000 for 2008. Upgrades to the breathing apparatus were added at a cost of $36,000. These upgrades will be done in 2008 at a cost of $900 per unit and consists of new regulator and rapid escape valve, which are needed to make the units compliant with NFP A and OSHA requirements. All 40 units are scheduled for complete replacement in 201 7. Added a second extraction tool to the ERP in 2012 at a cost of $26,500. A second extraction tool was purchased in 2005 from the fire department budget and needs to be added to the ERP. The second extraction tool will be replaced in 2015. Added a second thermal imaging camera to the ERP in 2013 at a replacement cost of $18,000. A second camera was purchased in 2003 from the fire department budget was needs to be added to the ERP. The cameras have a 10-year life. A floor scrubber purchased from the fire department budget in 2005 was added to the ERP for replacement in 2016 at a cost of$8,000. A floor sweeper purchased from the fire department budget in 2005 was _ added to the ERP for replacement in 2016 at a cost of$3,500. Workout equipment purchased from the fire department budgeted in 2005 with grant funds was added to the ERP. Three pieces of equipment are owned and are scheduled for replacement on an ongoing basis. Added to Police: Public Works: the ERP is $5,000 in 2009 for an elliptical machine, $5,000 in 2011 for a treadmill, $5,000 in 2012 for an elliptical machine and $5,800 in 2014, 2016, and 2017, $6,700 in 2019, 2021, and 2022, $7,800 in 2024 and 2026. The fire department also owns weight equipment that will be added to the ERP in future years once the life of the equipment has been determ.ined~ A new computer system for public safety scheduled for replacement in 2010 at a cost of $500,000 has been updated with a cost of $700,000. The software was purchased in 2000 at a cost of $313,700 and in 2006 would cost $700,000 to replace. The cost of the mobile data computers scheduled for replacement in 2007 have been increased by $7,000 to $47,000 to reflect the replacement cost per the State of Minnesota contract. The logging recorder scheduled for replacement in 2007 has been eliminated. Due to unforeseen failure this item was replaced in 2006. The lives of the equipment are annually reviewed by the public works department and over the past 10 years they have extended the lives of the I-ton trucks from 8 to 12 years and the dump trucks from 13 to 15 years. Extending the lives of major equipment comes with the risk of increased maintenance costs. When maintenance costs become unmanageable the equipment will be put on the schedule for earlier replacement. ParksIForestrv A % ton utility truck originally scheduled for replacem~nt in 2008 was moved back to 2010. Th~ funding source for a swap mower scheduled for replacement in 2008 was changed to reflect funding as follows: 25% from ERP (was 50%), 75% from refuse (was 500;0) to better reflect how the equipment is used. The cost of a log truck scheduled for replacement in 2007 has been increased by $10,000 to $107,000 to reflect actual cost. Staffwill attempt to purchase a used log truck. Replace one tractor in 2009 and move second unit out from 2010 to 2012. Staff will look at alternative uses or a different machine. Streets/Traffic The useful life of I-ton traffic boom truck (item 309 in the ERP) has been changed from 12 to 17 years with replacement in 2012 at a cost of $75,000. Current unit has 45,000 miles. Originally swapped cab and chassis 10 years ago in 1996 and determined at that time the truck had 15 more years of life. The entire unit will be replaced at 20 years life. Refuse The funding source for a swap mower scheduled for replacement in 2008 was changed to reflect funding as follows: 25% from ERP (was 50%), 75% from refuse (was 50%) to better reflect how the equipment is used. (602) EQUIPMENT REPLACEMENT FUND BUDGET BUDGET BUDGET BUDGET 2008 2009 2010 2011 - -- -- -- - 781,850 1,372,153 1,257,381 1,655,327 BUDGET 2007 ACTUAL ACTUAL BUDGET 2004 2005 2006 ~ -~ -- - 460,196 418,360 1,141,330 700,876 20,000 20,000 380,327 345,752 314,320 1,006,959 1,537,775 48,882 _ 30,000 _ 559,078 27,303 305,500 75,445 _ 30,000 _ 543,805 26,508 1,107,600 20,000 70,281 _ 30,000 _ 500,608 25,736 20,000 88,188 ~ 25,000 _ 478,940 24,986 137,806 300,000 57,830 25,000 ~ 834,956 24,259 288,367 369,241 fire 96,686 40,212 25,000 -819,506 - 256,920 100,000 91,000 18,691 43,955 -510,566 - 256,920 31,000 326,841 44,456 _ 18,910 _ 678,127 Working Capital Begin Year Revenues frolll charges Transfer in General Fund Transfer In _ Pavilion - Capital Lease Federal & State Grants Reimbursement - Radio System Interest earnings Other revenues Total Revenues 851,900 -876,886 - -385,836 - 1,134,108 -332,803 - 1,008,125 781,850 360,100 1,372,153 1,257,381 296,700 -32,0,959 1,655,327 23,552 355,500 ~ 379,052 - 21,606 740,387 54,656 -816,649 - 16,957 1,151,201 40,785 1,208,943- expenditures include copier & eng scanner leases Capital Outlay" Equipment Transfer to Pavilion Expenditures (excludes Depr.) 1,312,537 35,609 1,086,263 55,609 1,676,565 75,609 1,561,793 1,959,739 1,141,330 1,445,742 1,006,959 Working Capital Ending Balance 1,005,289 1,348,146 1.141,872 95,609 115,609 683,240 253,415 1,752,174 1,657,402 2,075,348 1,699,157 622,656 659,000 Cash balance Long Term Receivable 1,627,945 1,342,240 Cash Balance + L T Receivable 1,595,010 working Capital Balance 12/31/26 liote~ (1) Revenues frolIl charges _ scheduled increases -- 2007 ~ 9%; 2008 ~ 10%; 2009 ~ 10% 2010 ~ 10%; 2011 ~ 10%: 2012 ~ 10%; 2013 ~ 6% ACf\lAL ACf\lAL B1Jl)GEf BUDGET B1Jl)GET BUDGET BUDGET BUDGET B1Jl)GEf B1JDGET BUDGET BUDGET BUDGET B1J])GET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET BUDGET B1J])GET _ 2004 _ ~ ~ _ 2007 _ ~ _ 2009._ _ 2010 _ ~ ~ ~ 2014 _ 2015 _ ~ ~ - 2018 - - 2019 .- - 2020 - 2021_ - 2022 - 2023 - - 2024 - 2025 - - 2026 - 1,537,775 1,006,959 700,876 1,141,330 1,655,327 1,257,381 1,372.153 781,850 1,008,125 904,682 848,814 1,352,085 1,393,861 l,4S4,90 1 730,288 938,131 27,916 293,852 577,885 1,086,294 1,306,9&7 1,146,27 910,390 875,375 841,707 809,334 65,281 40,000 1,015,671 296.700 851,900 360,100 1,107,600 3l)S,SOO 695.... 670,901l 375,100 383,900 63ll,9Oll 608,5Oll 1,481,900 522,900 1,690,000 500,600 523,301l 341,700 6Il3,5llO l,l07,301l S24,4OIl -320,959 _ 876,886- -385,836- 1,134,108- ~ 723,772- 699,866 -404,935- ~ 670,552- ~ 1,515,4.0 -557,487 1,725,625 '37,293- 561,094 - -380,628- -723,596- 1,148,599- -566,938- 42,538 1,595,010 1.899,423 72,513 40,000 _ 987,888 1,146,277 1,450,689 41,299 62,582 40,000 _ -944,1.89 1,306,9S7 1,611,400 40,096 39,703 40,000 -889,037 1,086,294 1,390,707 38,928 '178,205 26,922 40,000 -845,127 - 37,794 577,885 882,298 748,274 14,955 40,000 -803,229 - 598,264 36,693 293,852 719,495 55,914 40,000 815,409 - 332,328 35,625 27,916 678,769 46,562 40,000 -765,330 - 1,242,544 34,587 938,131 640,348 80,519 40,000 -760,867- 1,034,701 33,580 730,288 615,719 76,422 ~ 731,141 1.484,901 1,789,313 32,601 597,785 74,542 40,000 -712,328- 1,393,861 1,698,274 31,652 1,088,826 574,794 62,696 40,000 677,489- 1,352,085 30,730 558,051 51,895 ~ 644,947 1,088.826 29,835 536,588 54,409 25,000_ 643,998 848,814 18,000 28,966 506,216 59,064 ,25,000_ 620,280 904,682 20,000 28,122 460,196 48,882 ~ 559,078 1,008,125 20,000 27,303 418,360 75,445 ~ 543,805 26,508 20,000 380,327 70,281 30,000 500,608 25,736 20,000 345,752 88,188 ~ 478.940 24,986 20,000 (602) 369,241 137,806 fire 300,000 96,686 40,212 57,830 25,000 25,000 -819,506- -834,956- 24,259 EQUIPMENT RE'PL.~CEMENT FUND 314,320 23,552 355,500 379,052 28S,367 18,691 43,955_ 510.,566 21,606 740.,387 54,656_ 816,649 256,920 100,000 91,000 1,151,201 40,785 1,208,943 44,456 ~ 678.1:27 16,957 256,91.0 31,000 326,841 W or1cing Capital Begin Year Revenues from chaI1!;es Transfer in General Fund Transfer 1n ~ Pavilion - Capital Lease Federal & state Grants Reimbursement - Radio system 1nterest earnings Other revenues T tal Re\'enues E'XPendj:tureS (excludes De?r.) ~ include c:opie:r &. c:ng $CIlDDe:r leases Capital OutlaY - Equipment Transfer to Pavilion 781,850 1,656,498 1.393.239 1,372,153 1 ;257,381 1,153,226 (2,391) 1,209,095 15,609 1,312,537 35,609 1,086,263 1,676,565 1,561,793 1,655,327 1,959,739 1,141,330 700,876 1,006,959 W rkinJ!. Capital Endin~ Balance 1,224,704 55,609 75,609 95,609 1,445,742 1,005,289 1,348,146 683,240 1,141,872 1,752,174 1,657,402 115,609 253,415 622,656 659,000 Cash balance 2,Q75 ,348 1,699,157 1,627,945 Long Te:rDl Receivable 1,342,240 1,595,010 Cash Balance + LT Receivable 12/31/26 ~ (1) RtV= ftoJD _ _ ~ _ - 2007 $ 9%; 2008 $10%; 2009 $ 10% 2010 == 10%; 2011 = 10%; 2012 == 10%; 2013 == 6% W orldng eapiiB1 Balance I City of Hopkins, I\1N EQUIPMENT REPLACEMENT PLAN 2007 thru 2011 DEP ARTMENT SUMMARY Department 2007 2008 2009 2010 2011 Total Arts Center 12,100 12, 100 Cable TV 5,000 5,000 5,000 5,000 5,000 25,000 City Hall Administration 78,140 56,640 67,140 68,500 164,900 435,320 Fire 15,000 636,000 40,000 15,300 706,300 HRA 28,800 28,800 Police 169,700 164,100 35,000 866,200 122,900 1,357,900 Public Works: Bldg/Equip Serv 24,100 24,100 Public Works: Parks/Forestry 105,000 55,200 174,200 32,200 26,400 393,000 Public Works: Streetsrrraffic 42,300 164,700 207,000 Refuse 176,700 176,700 Sewer 26,000 6,800 32,800 Water 20,500 12,200 30,300 63,000 GRAND TOTAL 419,340 916,940 387,740 1,325,500 412,500 3,462,020 Wednesday, June 21,2006 City of Hopkins, :MN EQUIPMENT REPLACEMENT PLAN 2007 tbru 2011 PROJECTS BY DEPARTMENT Department Project# Priority 2007 2008 2009 2010 2011 Total IArts Center , Arts Center Copy Machine 01-ERP-1100 0 12,1 00 12, 100 Arts Center Total 12,100 12,100 ICable TV , Cable/Council Chamber Cameras & Control System 01-ERP-050 0 5,000 5,000 5,000 5,000 5,000 25,000 Cable TV Total 5,000 5,000 5,000 5,000 5,000 25,000 ICity Hall Administration I City Hall Main Copy Machine 01-ERP-001 0 10,000 10,000 14,000 14,000 14,000 62,000 City Hall Small Copy Machine 01-ERP-002 0 26,900 26,900 Network Server 01-ERP-003 0 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 01-ERP-004 0 76,000 76,000 Computers 01-ERP-006 0 30,000 30,000 30,000 30,000 30,000 150,000 Engineering Printer/Scanner 01-ERP-007 0 8,640 8,640 8,640 10,000 10,000 45,920 Document Management Scanner (2) 01-ERP-00B 0 6,500 6,500 6,500 19,500 Network Infrastructure Upgrade 01-ERP-009 0 15,000 15,000 City Hall Administration Total 78,140 56,640 67,140 68,500 164,900 435,320 IFire I Lite Rescue o 1-ERP-1 05 0 35,000 35,000 Stuphen Aerial Truck o 1-ERP-1 06 0 600,000 600,000 Breathing Apparatus 01-ERP-10B 0 36,000 36,000 Copy Machine 01-ERP-110 0 10,300 10,300 Thermal Imaging Camera (2) 01-ERP-112 0 15,000 15,000 Workout Equipment (7) 01-ERP-116 0 5,000 5,000 10,000 Fire Total 15,000 636,000 40,000 15,300 706,300 IHRA I 4x4 3/4 Ton Truck 01-ERP-400 0 28,800 28,800 lIRA Total 28,800 28,800 !Police I Marked Patrol Vehicles (6) and Sergeant's Vehicle 01-ERP-200 0 89,400 92,100 130,400 67,200 379,100 Utility 4x4 (211) 01-ERP-203 0 37,700 37,700 Police Administrative Vehicles (2) 01-ERP-204 0 24,800 25,600 26,300 27,100 27,900 131,700 Computer System 01-ERP-20B 0 700,000 700,000 Copy Machine 01-ERP-209 0 19,100 19,100 Wednesday, June 21, 2006 Department Project# Priority 2007 2008 2009 2010 2011 Total Network Server (3) 01-ERP-211 0 8,500 8,700 8,700 8,700 8,700 43,300 eObile Data Computers 01-ERP-212 0 47,000 47,000 Police Total 16.9,700 164,100 35,000 866,200 122,900 1,357,900 IPublic Works: Bldg/Equip Serv , 4X4 1/2 Ton Truck 01-ERP-710 0 24,100 24,100 Public Works: Bldg/Equip Serv Total 24,100 24,100 IPublic Works: Parks/Forestry l 1/2 Ton Pickup Truck 01-ERP-BOO 0 26,400 26,400 3/4 Ton Utility Truck 01-ERP-B02 0 32,200 32,200 Swap Loader 01-ERP-B03 0 55,200 55,200 Log Truck 01-ERP-B04 0 105,000 105,000 Aerial Lift 01-ERP-B05 0 110,000 110,000 Tractors (2) 01-ERP-B06 0 41,400 41,400 Riding Mowers (3) 01-ERP-BOB 0 22,800 22, BOO Public Works: ParksIForestry Total 105,000 55,200 174,200 32,200 26,400 393,000 IPublic Works: Streets/Traffic l 1 Ton Dump Truck (2) 01-ERP-303 0 37,400 37,400 Water Truck 01-ERP-307 0 133,700 133,700 Skid Loader (2) 01-ERP-309 0 31,000 31,000 Trailer 01-ERP-316 0 4,900 4,900 Public Works: Streets/Traffic Total 42,300 164,700 207,000 IRefuse , Refuse Truck (RAP-R) (2) 01-ERP-900 0 176,700 176,700 Refuse Total 176,700 176,700 ISewer l 3/4 Ton Utility Truck (2) 01-ERP-551 0 26,000 26,000 Telephone System 01-ERP-557 0 6,800 6,800 Sewer Total 26,000 6,800 32,800 IWater I 1/2 Ton Truck 01-ERP-500 0 20,500 20,500 Hydraulic Jack Hammer for Backhoe 01-ERP-504 0 23,500 23,500 Public Works Copy Machine 01-ERP-506 0 12,200 12,200 Telephone System 01-ERP-507 0 6,800 6,BOO Water Total 20,500 12,200 30,300 63,000 GRAND TOTAL 419,340 916,940 387,740 1,325,500 412,500 3,462,020 Wednesday, June 21,2006 City of Hopkins, MN EQUIPMENT REPLACEMENT PLAN 2007 thru 2011 FUNDING SOURCE SUMMARY Source 2007 2008 2009 2010 2011 Total Cable Television Fund 5,000 5,000 5,000 5,000 5,000 25,000 Equipment Replacement Fund 315,340 570,540 382,740 1,131,600 329,500 2,729,720 GA - Grant-in-Aid 300,000 300,000 HAC - Arts Center Fund 12,100 12, 100 HRA - Housing and Redevelopment Authority 28,800 28,800 RF - Refuse Fund 52,500 41,400 176,700 270,600 SF - Sanitary Sewer Fund 26,000 6,800 32,800 WF - Water Fund 20,500 12,200 30,300 63,000 GRAND TOTAL 419,340 916,940 387,740 1,325,500 412,500 3,462,020 Wednesday, June 21, 2006 City of Hopkins, J\1:N" EQUIPMENT REPLACEMENT PLAN 2007 thru 2011 PROJECTS BY FUNDING SOURCE Source Project# Priority 2007 2008 2009 2010 2011 Total ICable Television Fund , Cable/Council Chamber Cameras & Control System 01-ERP-050 0 5,000 5,000 5,000 5,000 5,000 25,000 Cable Television Fund Total 5,000 5,000 5,000 5,000 5,000 25,000 !Equipment Replacement Fund l City Hall Main Copy Machine 01-ERP-001 0 10,000 10,000 14,000 14,000 14,000 62,000 City Hall Small Copy Machine 01-ERP-002 0 26,900 26,900 Network Server 01-ERP-003 0 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 01-ERP-004 0 76,000 76,000 Computers 01-ERP-006 0 30,000 30,000 30,000 30,000 30,000 150,000 Engineering Printer/Scanner 01-ERP-007 0 8,640 8,640 8,640 10,000 10,000 45,920 Document Management Scanner (2) 01-ERP-00B 0 6,500 6,500 6,500 19,500 Network Infrastructure Upgrade 01-ERP-009 0 15,000 15,000 Lite Rescue o 1-ERP-1 05 0 35,000 35,000 Stuphen Aerial Truck 01-ERP-106 0 300,000 300,000 .reathing Apparatus 01-ERP-10B 0 36,000 36,000 Copy Machine 01-ERP-110 0 10,300 10,300 Thermal Imaging Camera (2) 01-ERP-112 0 15,000 15,000 Workout Equipment (7) 01-ERP-116 0 5,000 5,000 10,000 Marked Patrol Vehicles (6) and Sergeant's Vehicle 01-ERP-200 0 89,400 92,100 130,400 67,200 379,100 Utility 4x4 (211) 01-ERP-203 0 37,700 37,700 Police Administrative Vehicles (2) 01-ERP-204 0 24,800 25,600 26,300 27,100 27,900 131,700 Computer System 01-ERP-20B 0 700,000 700,000 Copy Machine 01-ERP-209 0 19,100 19,100 Network Server (3) 01-ERP-211 0 8,500 8,700 8,700 8,700 8,700 43,300 Mobile Data Computers 01-ERP-212 0 47,000 47,000 1 Ton Dump Truck (2) 01-ERP-303 0 37,400 37,400 Water Truck 01-ERP-307 0 133,700 133,700 Skid Loader (2) 01-ERP-309 0 31,000 31,000 Trailer 01-ERP-316 0 4,900 4,900 4X4 1/2 Ton Truck 01-ERP-710 0 24,100 24,100 1/2 Ton Pickup Truck 01-ERP-800 0 26,400 26,400 3/4 Ton Utility Truck 01-ERP-802 0 32,200 32,200 Swap Loader 01-ERP-803 0 13,800 13,800 Log Truck 01-ERP-804 0 52,500 52,500 Aerial Lift 01-ERP-805 0 110,000 110,000 Tractors (2) 01-ERP-806 0 41 ,400 41,400 Riding Mowers (3) 01-ERP-80B 0 22,800 22,800 Equipment Replacement Fund Total 315,340 570,540 382,740 1,131,600 329,500 2,729,720 IGA - Grant-In-Aid , Stuphen Aerial Truck 01-ERP-106 0 300,000 300,000 Wednesday, June 21,2006 Source Proj ect# Priority 2007 2008 2009 2010 2011 Total GA - Grant-In-Aid Total 300,000 300,000 IHAC - Arts Center Fund I Arts Center Copy Machine 01-ERP-1100 0 12,100 12, 100 HAC - Arts Center Fund Total 12,100 12,100 IHRA - Housing and Redevelopment A I 4x4 3/4 Ton Truck 01-ERP-400 0 28,800 28,800 BRA - Housing and Redevelopment 28,800 28,800 Authority Total IRF - Refuse Fund I Swap Loader 01-ERP.B03 0 41 ,400 41,400 Log Truck 01-ERP-B04 0 52.500 52.500 Refuse Truck (RAP-R) (2) 01-ERP-900 0 176,700 176.700 RF - Refuse Fund Total 52,500 41,400 176,700 270,600 ISF - Sanitary Sewer Fund I 3/4 Ton Utility Truck (2) 01-ERP-551 0 26,000 26,000 Telephone System 01-ERP-557 0 6,800 6,800 SF - Sanitary Sewer Fund Total 26,000 6,800 32,800 IWF - Water Fund I 1/2 Ton Truck 01-ERP-500 0 20.500 20,500 Hydraulic Jack Hammer for Backhoe 01-ERP-504 0 23,500 23.500 Public Works Copy Machine 01-ERP-506 0 12,200 12.200 Telephone System 01-ERP-507 0 6.800 6,800 WF - Water Fund Total 20,500 12,200 30,300 63,000 GRAND TOTAL 419,340 916,940 387,740 1,325,500 412,500 3,462,020 Wednesday, June 21,2006 City of Hopkins, J\1N EQUIPMENT REPLACEMENT PLAN 2007 thru 2011 PROJECTS & FUNDING SOURCES BY DEPARTMENT Department Pro j ect# Priority 2007 2008 IArts Center I Arts Center Copy Machine 01-ERP-1100 0 Arts Center Total 2009 2010 2011 Total 12,100 12,100 12,100 12,100 jCable TV I Cable/Council Chamber Cameras & Control System 01-ERP-050 o 5,000 5,000 5,000 5,000 5,000 25,000 Cable TV Total 5,000 5,000 5,000 5,000 5,000 25,000 ICity Hall Administration , City Hall Main Copy Machine 01-ERP-001 0 10,000 10,000 14,000 14,000 14,000 62,000 City Hall Small Copy Machine 01-ERP-002 0 26,900 26,900 Network Server 01-ERP-003 0 8,000 8,000 8,000 8,000 8,000 40,000 Telephone System 01-ERP-004 0 76,000 76,000 Computers 01-ERP-006 0 30,000 30,000 30,000 30,000 30,000 150,000 Engineering Printer/Scanner 01-ERP-007 0 8,640 8,640 8,640 10,000 10,000 45,920 Document Management S~anner (2) 01-ERP-008 0 6,500 6,500 6,500 19,500 Network Infrastructure Upgrade 01:-ERP-009 0 15,000 15,000 City Hall Administration Total 78,140 56,640 67,140 68,500 164,900 435,320 IFire Lite Rescue Stuphen Aerial Truck , 01-ERP-105 01-ERP-106 o o 35,000 35,000 600,000 600,000 Wednesday, June 21, 2006 Department Project# Priority 2007 2008 2009 2010 2011 Total Breathing Apparatus 01-ERP-108 0 36,000 36,000 Copy Machine 01-ERP-110 0 10,300 10,300 Thermal Imaging Camera (2) 01-ERP-112 0 15,000 15,000 Workout Equipment (7) 01-ERP-116 0 5,000 5,000 10,000 Fire Total 15,000 636,000 40,000 15,300 706,300 JHRA I 4x4 3/4 Ton Truck 01-ERP-400 o 28,800 28,800 HRA Total 28,800 28,800 IPolice I Marked Patrol Vehicles (6) and Sergeant's Vehicle 01-ERP-200 0 89,400 92,100 130,400 67,200 379,100 Utility 4x4 (211) 01-ERP-203 0 37,700 37,700 Police Administrative Vehicles (2) 01-ERP-204 0 24,800 25,600 26,300 27,100 27,900 131,700 Computer System 01-ERP-208 0 700,000 700,000 Copy Machine 01-ERP-209 0 19,100 19,100 Network Server (3) 01-ERP-211 0 8,500 8,700 8,700 8,700 8,700 43,300 Mobile Data Computers 01-ERP-212 0 47,000 47,000 Police Total 169,700 164,100 35,000 866,200 122,900 1,357,900 IPublic Works: Bldg/Equip Serv 4X4 1/2 Ton Truck I 01-ERP-710 o 24,100 24,100 Public Works: Bldg/Equip Serv Total 24,100 24,100 Wednesday, June 21,2006 Department Pro j ect# Priority 2007 2008 2009 2010 2011 Total Public Works: Parks/Forestry /2 Ton Pickup Truck 01-ERP-800 0 26,400 26,400 3/4 Ton Utility Truck 01-ERP-802 0 32,200 32,200 Swap Loader 01-ERP-803 0 55,200 55,200 Log Truck 01-ERP-804 0 105,000 105,000 Aerial Lift 01-ERP-805 0 110,000 110,000 Tractors (2) 01-ERP-806 0 41,400 41 ,400 Riding Mowers (3) 01-ERP-808 0 22,800 22,800 Public Works: ParkslForestry Total 105,000 55,200 174,200 32,200 26,400 393,000 IPublic Works: Streets/Traffic I 1 Ton Dump Truck (2) 01-ERP-303 0 37,400 37,400 Water Truck 01-ERP-307 0 133,700 133,700 Skid Loader (2) 01-ERP-309 0 31,000 31,000 Trailer 01-ERP-316 0 4,900 4,900 Public Works: Streets/Traffic Total 42,300 164,700 207,000 IRefuse Refuse Truck (RAP-R) (2) , 01-ERP-900 o 176,700 176,700 Refuse Total 176,700 176,700 ISewer I 3/4 Ton Utility Truck (2) 01-ERP-551 0 26,000 26,000 Telephone System 01-ERP-557 0 6,800 6,800 Sewer Total 26,000 6,800 32,800 Wednesday, June 2], 2006 Department Project# Priority 2007 2008 2009 2010 2011 Total IWater I 1/2 Ton Truck 01-ERP-500 0 20,500 20,500 Hydraulic Jack Hammer for Backhoe 01-ERP-504 0 23,500 23,500 Public Works Copy Machine 01-ERP-506 0 12,200 12,200 Telephone System 01-ERP-507 0 6,800 6,800 Water Total 20,500 12,200 30,300 63,000 Wednesday, June 21, 2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Ol-ERP-IIOO 2007 thru 2011 Arts Center Copy Machine Contact Public Works Director Department Arts Center Type Equipment Useful Life 7 years Category Equipment Priority nJa Description I Copy machine capable of enlarging and producing double sided, collated and stapled copies. Total Project Cost $53,800 Justification I Used to duplicate reports, letters, signs, flyers and rental information. Prior 8,500 I Total Expenditures Equipment 2007 2008 2009 2010 2011 12,100 12,100 Total Future 12,100 33,200 I 12,100 Total Total Prior 8,500 I Total Funding Sources HAC - Arts Center Fund 2007 2008 2009 2010 2011 12,100 12,100 Total 12,100 12,100 Future 33,200 I Total Total Operational Impact/Other I Variance from 20 year plan - increase by $2,000 to reflect actual cost. Estimate salvage/resale value on replaced item: $ Wednesday, June 21,2006 - - ------- - ----- EQUIPMENT REPLACEMENT PLAN 2007 thru 2011 Contact City Manager City of Hopkins, MN Department Cable TV Project # Ol-ERP-050 Type Equipment Useful Life 8 years Project Name Cable/Council Chamber Cameras & Control System Equipment Category Priority nla Total Project Cost $100,000 Description I Replacement of cameras, motors and ves communications specialist Calnera control unit. Justification I Studio equipment, lighting and cameras for meeting cable casts alld presentations. Expenditures 2007 2008 2009 2010 2011 Total Future Equipment 5,000 5,000 5,000 5,000 5,000 25,000 I 75,000 I Total 5,000 5,000 5,000 5,000 5,000 25,000 Total Funding Sources 2007 2008 2009 2010 2011 Total Future Cable Television Fund 5,000 5,000 5,000 5,000 5,000 25,000 I 75,000 I Total 5,000 5,000 5,000 5,000 5,000 25,000 Total Operational Impact/Other I Variance from 20 year plan - replace equiplnent as needed due to useful life variation. Estimate salvage/resale value on replaced item: $-0- Wednesday, June 21,2006 EQUIP:MENT REPLACEMENT PLAN City of Hopkins, MN Ol-ERP-OOl City HaIl Main Copy Machine 2007 thru 2011 Description I Copy machine to service needs of all departments located at City Hall. 1. Variety of copying tasks. 2. High volume product copier. Note: equipment is leased. Contact Finance Director Department City Hall Administration T)'pe Equipment Useful Life Unassigned Category Equipment Priority nJa Total Project Cost $445,000 Justification I Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports, council reports and updates, city code revisions, various department reports, and hearing and information notices. Machine will duplex, sort, collate and staple copies. Expenditures Equipment Prior 77,000 I Total 2007 10,000 10,000 2008 10,000 10,000 2009 14,000 14,000 2010 14,000 14,000 Total Prior 77,000 I Total Funding Sources Equipment Replacement Fund Total 2007 10,000 10,000 2008 10,000 10,000 2009 14,000 14,000 2010 14,000 14,000 2011 14,000 14,000 Future 306,000 I Total Total 62,000 62,000 2011 14,000 14,000 Total Future 62,000 306,000 I 62,000 Total Operational Impact/Other I Variance from 20 year plan - lease alTIOunt increased as issues have arisen with current copier which may require a new machine with a new lease. Estimate salvage/resale value on replaced item: $-0- Wednesday, JW1e 21,2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2007 thru 2011 Contact Finance Director Project # Ol-ERP-002 Project Name City Hall Small Copy Machine Department City Hall Administration Type Equipment Useful Life 5 years Category Equipment Priority nJa Total Project Cost $179,500 Description I Coyy machine to service needs of all departments located at City Hall. 1, Variety of copying tasks. 2. High volume product copier. Note: This is a color copier. Justification I Daily use to make copies of correspondence and forms. Periodically produce documents, i.e., budgets, financial reports, council reports and updates, city code revisions, various department reports, and hearing and information notices. Machine will duplex, sort, collate and staple copies. Prior 43,200 I Total Expenditures Equipment 2007 2008 2009 2010 2011 26,900 26,900 Total 26,900 I 26,900 Future 109,400 I Total Total Prior I 43,200 I Total Funding Sources Equipment Replacement Fund Total 2007 2008 2009 2010 2011 26,900 26,900 Total 26,900 I 26,900 Future 109,400 I Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Wednesday, June 21,2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, :MN 2007 thru 2011 Contact Finance Director/IT Project # Ol-ERP-003 Department City Hall Administration Type Equipment Useful Life 1 year Category Equipment Priority nJa Project Name Network Server Description I The network server is the hub of the network. New cOlnputers are faster and more reliable. Total Project Cost $193,000 Justification I Networking allows user to share information that is stored in a single location, the network server. This is more efficient because the infonnation does not have to be stored on many different computers. It also makes for better accuracy because as the infonnation changes or is updated, every user is working with the same data. Prior 33,000 I Total Expenditures Equipment 2007 8,000 8,000 2008 8,000 8,000 2009 8,000 8,000 2010 8,000 8,000 2011 8,000 8,000 Total Future 40,000 120,000 I 40,000 Total Total Prior 33,000 I Total Funding Sources Equipment Replacement Fund Total 2007 8,000 8,000 2008 8,000 8,000 2009 8,000 8,000 2010 8,000 8,000 2011 8,000 8,000 Total Future 40,000 120,000 I 40,000 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- Wednesday, June 21,2006 ----- , EQUIP:MENT REPLACE:MENT PLAN 2007 thru 2011 Finance Director/IT Contact City of Hopkins, :MN Department City Hall Administration Project # Ol-ERP-004 Type Equipment Useful Life 8 years Project Name Telephone S)Tstem Category Equipment Priority nla Total Project Cost $238,100 Description I Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems. Justification I Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) Prior Exp~nditures 2007 2008 2009 2010 2011 Total Future I 60,000 I Equipment 76,000 76,000 I 102,100 I Total Total 76,000 76,000 Total Prior Funding Sources 2007 2008 2009 2010 2011 Total Future I 60,000 I Equipment Replacement Fund 76,000 76,000 I 102,100 I Total Total 76,000 76,000 Total I Operational Impact/Other I Variance from 20 year plan - extend life to 8 years. Estimate salvage/resale value on replaced item: $ Wednesday, June 21, 2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2007 thru 2011 Project # Ol-ERP-006 Project Name Computers Contact Finance Director/IT Department City Hall Administration Type Equipment Useful Life 3-5 years Category Equipment Priority n/a Total Project Cost $780,000 Description I Personal computer purchases and upgrades for the entire City staff. Coordinating personal computer purchases from individual departments to one fund. Justification I Tools enabling staff to perfoID1 job responsibilities efficiently and effectively. Expenditures Equipment Prior 180,000 I Total 2007 30,000 30,000 2008 30,000 30,000 2009 30,000 30,000 2010 30,000 30,000 Total Prior 180,000 I Total Funding Sources Equipment Replacement Fund Total 2007 30,000 30,000 2008 30,000 30,000 2009 30,000 30,000 2010 30,000 30,000 Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $-0- 2011 30,000 30,000 Future 450,000 I Total Total 150,000 150,000 201'1 30,000 30,000 Total Future 150,000 450,000 r 150,000 Total Wednesday, June 21, 2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # Ol-ERP-007 Project Name Engineering Printer/Scanner 2007 thru 2011 Contact Finance Director Department City Hall Administration Type Equipment Useful Life 5 years Category Equipment Priority nla Total Project Cost $246,560 Description I Prillter/scanrier -large format copier use in Engineering to copy blueprints, plans and large documents. Equipment is leased. Justification I Large document copier/scanner for use in Engineering. Also scans documents for permanent storage. Prior 8,640 I Total Expenditures Equipment 2007 8,640 8,640 Total Prior 8,640 I Total Funding Sources Equipment Replacement Fund 2007 8,640 8,640 Total Operational Impact/Other I Variance from 20 year plan - new Estimate salvage/resale value on replaced item: $-0- 2008 8,640 8,640 2009 8,640 8,640 2010 10,000 10,000 2008 8,640 8,640 2009 8,640 8,640 2010 10,000 10,000 2011 10,000 10,000 Total 45,920 I 45,920 2011 10,000 10,000 Total 45,920 I 45,920 Futu re 192,000 I Total Future 192,000 I Total Wednesday, June 21,2006 EQUIPMENT REPLACEMENT PLAN ity of Hopkins, MN Ol-ERP-008 2007 thru 2011 Contact Finance Director Document Management Scanner (2) Department City Hall Administration Type Equipment Useful Life 3 years Category Equipment Priority nJa Total Project Cost $91,000 Description I Large document (11 "x1711) scanner for document Inanagement and retention as well as general administrative use. Justification I 2007 - Replaces the second scanner that only scans documents to 8 1/2"x1411 that was purchased in 2004. Prior 6,500 I Total Expenditures Equipment 2007 6,500 6,500 2008 2009 6,500 6,500 2010 6,500 6,500 2011 Total Future 19,500 65,000 I 19,500 Total Total Prior 6,500 I Total Funding Sources Equipment Replacement Fund Total 2907 6,500 6,500 2008 2009 6,500 6,500 2010 6,500 6,500 2011 Total Future 19,500 65,000 I 19,500 Tot.al Operational Impact/Other I Variance from 20 year plan - add second scanner that was purchased from budget in 2004. Estimate salvage/resale value on replaced item: $500-$1,000 Wednesday, June 21,2006 EQUIPMENT REPLACEMENT PLAN 2007 thru 2011 Contact Finance DirectorlIT City of Hopkins, MN Department City Hall Administration Project # Ol-ERP-009 Type Equipment Useful Life 15 years Project Name Network Infrastructure Upgrade Equipment Category Priority nla Total Project Cost $38,400 Description I Install new and additional network wiring and equipment. I Justification I Improve capacity, coverage and reliability. Installation will coincide with office space update. Expenditures 2007 2008 2009 2010 2011 Total Future Equipment 15,000 15,000 I 23,400 I Total 15,000 15,000 Total Funding Sources 2007 2008 2009 2010 2011 Total Future Equipment Replacement Fund 15,000 15,000 I 23,400 I Total 15,000 15,000 Total ! Operational Impact/Other I Variance from 20 year plan - new item to replace substandard network wiring. I Estimate salvage/resale value on replaced item: $ I I ! Wednesday, June 21,2006 ! EQUIPMENT REPLACE:MENT PLAN City of Hopkins, MN Project # Ol-ERP-I05 2007 thru 2011 Fire Chief Contact Department Fire Type Equipment Useful Life 10 years Category Vehicles Priority nJa Total Project Cost $118,800 Project Name Lite Rescue Description I Light rescue response vehicle on a 4 wheel drive chassis. Justification I Used for all emergency medical responses; vehicle accidents; industrical accidents; hazardous materials response. Expenditures Vehicles 2007 2008 2009 35,000 35,000 2010 2011 Total Future 35,000 83,800 I 35,000 Total Total Funding Sources Equipment Replacement Fund Total 2007 2008 2009 35,000 35,000 2010 2011 Total Future 35,000 83,800 I 35,000 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item $ - 4,000 Wednesday, June 21,2006 Project # Ol-ERP-I06 2007 thru 2011 Contact Fire Chief Department Fire . Type Equipment Useful ~ife 20 years Category Vehicles Priority nla Total Project Cost $600,000 EQUIPMENT REPLACEMENT PLAN City of Hopkins, :MN Project Name Stuphen Aerial Truck Description I One hundred foot aerial ladder truck with a 1500 GPM fITe pump and a full compliment of ground ladders. Justification I Vehicle responds to all structural emergencies. Used especially for rescue of people trapped on upper floors and ventilation of the hot gases and smoke. The body of the truck was refurbished in 1991. The pump, aerial ladder and hydraulics were not. The plan was to refurb these components in 2007. We have been informed by the manufacturer that because of the new aerial construction standards, we will not longer be able to refurb. Need to replace. Expenditures Equipment 2007 2008 600,000 600,000 2009 2010 2011 Total 600,000 600,000 Total Funding Sources 2007 Equipment Replacement Fund GA - Grant-In-Aid Total 2008 300,000 300,000 600,000 2009 2010 2011 Total 300,000 300,000 600,00p Operational Impact/Other I Variance from 20 year plan - cost of new truck reduced $300,000 due to lack of federal grant funding. Unable to secure a significant federal grant after two attempts so the truckwill be scaled back. An application for a smaller federal grant has been made in 2006. Estimate salvage/resale value on replaced item: $ Wednesday, June 21,2006 Project # Ol-ERP-I08 2007 thru 2011 Contact Fire Chief Department Fire Type Equipment Useful Life 15 years Category Equipment Priority nJa Total Project Cost $368,500 EQUIP:MENT REPLACE1\1ENT PLAN City of Hopkins, :MN Project Name Breathing Apparatus Description High pressure, light weight breathing apparatus carried on all emergency apparatus. Thirty minute capacity. Justification OSHA required self contained breathing apparatus must be worn by fire-fighters when working in hazardous atmospheric conditions or oxygen deficient situations. Upgrade consists of new regulator and rapid escape valve ($900 each/40 count) Prior 130,000 I Total Expenditures Equipment 2007 2008 36,000 36,000 2009 2010 2011 Total 36,000 36,000 Future 202,500 I Total Total Prior 130,000 I Total Funding Sources Equipment Replacement Fund Total 2007 2008 36,000 36,000 2009 2010 2011 Total Future 36,000 202,500 I 36,000 Total Operational Impact/Other Variance from 20 year plan - additional one time cost for upgrade in 2008. Needed to lnake apparatus compliant to NFP A and OSHA requirements for firefighter safety. Estimate salvage/resale value on replaced iteln: $ 200 each Wednesday, June 21,2006 EQUIP:MENT REPLACE:MENT PLAN City of Hopkins, 1\1N Project # Project Name Copy Machine Ol-ERP-IIO Description Fire Station copy machine. Justification Copying business papers, training records, etc. Prior 7,400 I Total Prior 7,400 I Total Expenditures Equipment 2007 Total Funding Sources Equipment Replacement Fund 2007 Total Operational Impact/Other Variance from 20 year plan - none Estimate salvage/resale value 011 replaced item: $500 2008 2008 2007 thru 2011 Fire Chief Contact Department Fire Type Equipment Useful Life 8 years Category Equipment Priority n/a Total Project Cost $30,800 2009 2009 2010 2011 10,300 10,300 Total Future 10,300 13,100 I 10,300 Total 2010 2011 10,300 10,300 Total 10,300 10,300 Future 13,100 I Total Wednesday, June 21,2006 EQUIP:MENT REPLACE1\1ENT PLAN City of Hopkins, MN 01-ERP-112 Project Name Thermal Imaging Camera (2) 2007 thru 2011 Contact Fire Chief Department Fire Type Equipment Useful Life 10 years Category Equipment Priority nla Total Project Cost $77,400 Description I Used by our fire companies to locate victuns trapped Ul a smoke filled building. It helps us determine where fire and heat may be hidden allowing for faster extinguishment. Note: purchased 1997 & 2003 Justification I Current camera is ten years old and has been through Inany hot fIres and needs to be replaced. Current camera was purchased with donation money. Expenditures Equipment 2007 15,000 Total 15,000 2008 2009 2010 2011 Total Future 15,000 62,400 I 15,000 Total Funding Sources Equipment Replacement Fund Total 2007 15,000 15,000 2008 2009 2010 2011 Total Future 15,000 62,400 I 15,000 Total Operational Impact/Other I Variance from 20 year plan - department owns 2 cameras. Previously one one was included in the replacement plan. Ulis will add to the replacement schedule the camera purchased from the Fire Dept budget in 2003. Estimate salvage/resale value on repalced item: $-0- Wednesday, June 21, 2006 2007 thru 2011 Fire Chief Contact Department Fire Type Equipment Useful Life 5 years Category Equipment Priority n/a Total Project Cost $68,100 EQUIPJ\.1ENT REPLACE:MENT PLAN City of Hopkins, MN Project # 01-ERP-116 ProjectName Workout Equipment (7) Description Workout equipment used in Fire Department workout room. 2009 - replace eliptical 2011 - replace treadlnill 2012 - replace elipitcal Note for subsequent years: 4 pieces of weight equipment will need to be added. Estimated life 6-9 years depending on iece of e uipment. Estimated cost $3-5,000 de ending on piece being re laced. Justification This equipment is available to all City employees for health and wellness. Expenditures Equipment 2007 2008 2009 5,000 5,000 Total Funding Sources 2007 Equipment Replacement Fund Total 2008 2009 5,000 5,000 Operational Impact/Other Variance from 20 year plan - new item Estimate salvage/resale value on replaced item: $ 2010 Total Future 10,000 58,100 I 10,000 Total 2011 5,000 5,000 2010 Total Future 10,000 58,100 I 10,000 Total 2011 5,000 5,000 Wednesday, June 21,2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # Ol-ERP-400 2007 thru 2011 Unassigned Contact Department BRA Type Equipment Useful Life 8 years Category Vehicles Priority n/a Total Project Cost $88,100 Project Name 4x4 3/4 Ton Truck Description I 4 wheel drive 3/4 ton truck to be used by Public Housing rnaintenance staff. Includes snow plow. Justification I Transportation for Public Housing Superintendent and snow plowing at various HRA properties around the city. Prior 22,800 I Total Expenditures Vehicles 2007 2008 2009 2010 2011 28,800 28,800 Total Future 28,800 36,500 I 28,800 Total Total Prior 22,800 I Total Funding Sources HRA - Housing and Redevelop Total 2007 2008 2009 2010 2011 28,800 28,800 Total Future 28,800 36,500 I 28,800 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,800 Wednesday, June 21,2006 EQUIPJ\.1ENT REPLACEMENT PLAN City of Hopkins, MN 2007 thru 2011 Project # Ol-ERP-200 Project Name Marked Patrol Vehicles (6) and Sergeant's Vehicle Contact Police Chief Department Police Type Equipment llseful Life 3-4 years Category Vehicles Priority n/a Total Project Cost $2,128,500 Description I Marked patrol vehicles used by patrol officers to respond to calls, enforce traffic laws and perform general patrol duties. Justification I Set up and marking of police vehicles m,:!st conform to Minnesota law and POST standards. Vehicles contain secure data and radio equipment for routine and emergency operations. Vehicles contain secure seating for prisoner transport. Additional vehicle comes from K-9 program. Vehicle will be used by the power shift officers (overlap shift that provides additional coverage during peak call times). This vehicle is on a 4 year life. Prior I 322,900 I Total 2007 89,400 89,400 2009 2010 130,400 130,400 Total 2008 92,100 92,100 Expenditures Vehicles Prior I 322,900 I Total 2007 89,400 89,400 2008 92,100 92,100 2009 2010 130,400 130,400 Funding Sources Equipment Replacement Fund Total Operational Impact/Other I Variance frOlTI 20 year plan - None. Estimate salvage/resale value on replaced item: $4,000 each 2011 67,200 67,200 Total Future 379,100 I 1,426,500 I 379,100 Total 2011 67,200 67,200 Total Future 379,100 I 1,426,500 I 379,100 Total Wednesday, June 21,2006 Project # 01-ERP-203 Project Name Utility 4x4 (211) 2007 thru 2011 Police Chief Contact Department Police Type Equipment Useful Life 6 years Category Vehicles Priority n/a Total Project Cost $247,600 EQUIP~NT REPLACE:MENT PLAN City of Hopkins, M.N Description 4 wheel drive uitlity vehicle. Justification Vehicle is normally used by public service officers for a wide variety of uses such as transporting annnals and equipment. The 4 wheel drive vehicle is also used at tnnes as a patrol vehicle, particularly nl the winter in extreme snow conditions. Prior . 29,700 I Total Expenditures Vehicles 2007 2008 37,700 37,700 2009 2010 2011 Total Future 37,700 180,200 I 37,700 Total Total Prior 29,700 I Total Funding Sources Equipment Replacement Fund Total 2007 2008 37,700 37,700 2009 2010 2011 Total Future 37,700 180,200 I 37,700 Total Operational Impact/Other Variance from 20 year plan - none EstiInate salvage/resale value on replaced item: $5,000 Wednesday. June 21. 2006 EQUIPMENT REPLACEMENT PLAN 2007 thru 2011 Contact Police Chief City of Hopkins, MN Department Police Project # Ol-ERP-204 Type Equipment Useful Life 2 years Project Name Police Administrative Vehicles (2) Category Vehicles Priority nla Total Project Cost $775,300 Description I Police administrative and detective vehicles. Justification I Unmarked vehicles, equipped with radios, siren and red grille lites used by chief and captain. Staff use is for two years. Vehicles are then rotated down to detectives and are kept for an additional 3-4 years. Vehicles are also used for surveillance by uniform and plain clothes officers. Prior Expenditures 2007 2008 2009 2010 2011 Total Future I 108,600 I Vehicles 24,800 25,600 26,300 27,100 27,900 131,700 I 535,000 I Total Total 24,800 25,600 26,300 27,100 27,900 131,700 Total Prior Funding Sources 2007 2008 2009 2010 2011 Total Future I 108,600 I Equipment Replacement Fund 24,800 25,600 26,300 27,100 27,900 131,700 I 535,000 I Total Total 24,800 25,600 26,300 27,100 27,900 131,700 Tot.al Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $4,000 each Wednesday, June 21, 2006 Project Name Computer System 2007 thru 2011 Police Chief Contact Department Police Type Equipment Useful Life 10 years Category Equipment Priority nla Total Project Cost $1,640,700 EQUIP:MENT REPLACEMENT PLAN City of Hopkins, MN Ol-ERP-208 Description Computer system for records management and retention of Police Department. Justification To store, retrieve and transfer required data to State and perform data entry, inquiries of local, state' and national crime databases. During last purchase, the Police Department did not have CAD or lTIobile systems. Since then, these systems have been added and share the same data base/operating system as the records management. ReplacelTIent will have to incorporate all three systems. Expenditures Equipment 2007 2008 2009 2010 700,000 700,000 2011 Total Future 700,000 940,700 I 700,000 Total Total Funding Sources 2007 Equipment Replacement Fund 2008 2009 2010 700,000 700,000 2011 Total Future 700,000 940,700 I 700,000 Total Total Operational Impact/Other Variance from 20 year plan - need to increase budgeted amount to $700,000 to better reflect a more realistic replacement cost for Records Mgmt Mobile Data SystelTI and COlTIputer Aided Dispatch (RMS/MDC/CAD) computer system. Estimate salvage/resale value on replaced item: $-0- Wednesday, June 21,2006 - -- ---- --- - - --- ----- EQUIP1\ffiNT REPLACEMENT PLAN 2007 thru 2011 Police Chief Contact City of Hopkins, MN Department Police Type Equipment I Project # Ol-ERP-209 I Useful Life 5 years Project Name Copy Machine Equipment Category Priority nJa Total Project Cost $127,200 Description I Police Department copy machine capable of producing double side copies and collating pages. Justification I Used to make duplicate copies of reports, letters, memos, etc., generated by police presonne!. Prior Expenditures 2007 2008 2009 2010 2011 Total Future I 30,700 I Equipment 19,1 DO 19,100 I n,400 I Total Total 19,100 19,100 Total Prior Funding Sources 2007 2008 2009 2010 2011 Total Future I 30,700 I Equipment Replacement Fund 19,100 19,100 I n ,400 I Total Total 19,100 19,100 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,000 Wednesday, June 21,2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2007 thru 2011 Contact Police ChiemT Department Police Project # Ol-ERP-211 Type Equipment Useful Life 3 years Category Equipment Priority n/a Project Name Network Server (3) Description I Computer servers store information and system programs. Total Project Cost $215~900 Justification I Annual replacement cycle allows developlnent of system storage program. Use of newer servers for heavy use programs while older servers rever to data storage. Prior 34,000 I Total Expenditures Equipment 2007 8,500 8,500 2008 8,700 8,700 2009 8,700 8,700 2010 8,700 8,700 2011 8,700 8,700 Total Future 43,300 138,600 I 43,300 Total Total Prior 34,000 , Total Funding Sources Equipment Replacement Fund Total 2007 8,500 8,500 2008 8,700 8,700 2009 8,700 8,700 2010 8,700 8,700 2011 8,700 8,700 Total Future 43,300 138,600 f 43,300 Tot.al Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced iteln - $ Wednesday, June 21,2006 Project # 01-ERP-212 2007 thru 2011 Police Chief Contact Department Police Type Equipment Useful Life 5 years Category Equipment Priority nJa Total Project Cost $237,900 EQUIP1vIENT REPLACEl\ffiNT PLAN City of Hopkins, MN Project Name Mobile Data Computers Description I Mobile data computers installed in squad cars used to receive calls from dispatch, query information from various databases, communicate car to car. Justification I Originally, :MDT's (mobile data terminals) were supplied/supported by the Hennepin County Sheriffs Dept. until they decided not to provide this service. Hopkins police obtained federal grant monies to replaced the MDT's in 2002. Limited life of 5 years. Expenditures Equipment 2007 47,000 Total 47,000 2008 2009 2010 2011 Total Future 47,000 I 190,900 f 47,000 Total Funding Sources Equipment Replacement Fund Total 2007 47,000 47,000 2008 2009 2010 2011 Total Future 47,000 I 190,900 I 47,000 Total Operational Impact/Other .1 Variance from 20 year plan - Need to increase budgeted amount to $47,000. Estimated cost per unit based on State of Minnesota contract is $4,300 each plus $2,800 tax and associated wiring or cabling needs. Estimate salvage/resale value on replaced item: $-0- Wednesday, June 21,2006 2007 thru 2011 EQUIPMENT REPLACE1vlENT PLAN City of Hopkins, MN roject # Ol-ERP-710 4X4 1/2 Ton Truck Description Pickup used by various divisions of Public Works. Contact Public Works Director Department Public Works: BldglEquip Ser Type Equipment Useful Life 10 years Category Vehicles Priority nJa Total Project Cost $56,400 Justification Light hauling and transportation for supervisors. Maintenance garage service vehicle. Expenditures Vehicles 2007 2008 2009 24,100 24,1 00 Total Funding Sources 2007 Equipment Replacement Fund Total 2008 2009 24,100 24,1 00 Operational Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $1,500 2010 2010 2011 Total Future 24,100 32,300 I 24,100 Total 2011 Total .Future 24,100 32,300 I 24,100 Tohll Wednesday, June 21, 2006 -------------- --- -- - -- EQUIPMENT REPLACEMENT PLAN 2007 thru 2011 Contact Public Works Director City of Hopkins, MN Department Public Works: Parks/Forestry Project # Ol-ERP-800 Type Equipment Useful Life 10 years Project Name 1/2 Ton Pickup Truck Category Vehicles Priority nla Total Project Cost $61,800 Description I Pickup used by Park Division of Public Works. Justification I Expenditures 2007 2008 2009 2010 2011 Total Future Vehicles 26,400 26,400 I 35,400 I Total 26,400 26,400 Total Funding Sources 2007 2008 2009 2010 2011 Total Future Equipment Replacement Fund 26,400 26,400 I 35,400 I Total 26,400 26,400 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced iteln: $ Wednesday, June 21, 2006 I EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Ol-ERP-802 2007 thru 2011 Contact Public Works Director Department Public Works: Parks/Forestry Type Equipment Useful Life 10 years Category Vehicles Priority n/a Project Name 3/4 Ton Utility Truck Total Project Cost $75,600 Description 3/4 ton truck with utility body used for transporting tools and equipment for repair of various buildings, irrigation, etc. around the city. Justification Expenditures Vehicles 2007 2008 2009 2010 32,200 32,200 2011 Total Future 32,200 43,400 I 32,200 Total Total Funding Sources Equipment Replacement Fund 2007 2008 2009 2010 32,200 32,200 2011 Total 32,200 32,200 Future 43,400 I Total Total Operational Impact/Other Variance from 20 year plan - move back two years (2008 to 2010). Current unit has 38,000 miles and is in good condition. Estimate salvage/resale value on replaced item: $ Wednesday, June 21,2006 EQUIP:MENT REPLACE1\1ENT PLAN City of Hopkins, :MN 2007 thru 2011 Contact Public Works Director Department Public Works: Parks/Forestry T~Tpe Equipment Useful Life 15 years Category Equipment Priority nia Project # Ol-ERP-803 Project Name Swap Loader Total Project Cost $141,200 Description I Single axle truck with a slide rail systelTI used to swap between various boxes and bodies. Utilitized by Refuse for hauling dumpsters and Forestry for chipping trees. Justification I Expenditures Equipment 2007 2008 55,200 55,200 2009 2010 2011 Total Future 55,200 I 86,000 I 55,200 Total Total Funding Sources 2007 2008 2009 2010 2011 Total Future Equipment Replacement Fund 13,800 13,800 I 86,000 I RF - Refuse Fund 41 ,400 41 ,400 Tornl Total 55,200 55,200 Operational Impact/Other I Variance from 20 year plan - 25% Equipment Replacement/75% Refuse Estimate salvage/resale value on replaced item: $ Wednesday, June 21, 2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, :MN Ol-ERP-804 2007 thru 2011 Contact Public Works Director Department Public Works: Parks/Forestry Type Equipment Useful Life 20 years Category Vehicles Priority n/a Project Name Log Truck Total Project Cost $105,000 Description Truck is used for hauling brush and logs in the Forestry department. Justification Expenditures Vehicles 2007 105,000 Total 105,000 2008 2009 2010 2011 Total 105,000 105,000 Funding Sources Equipment Replacement Fund RF - Refuse Fund 2007 52,500 52,500 105,000 2008 2009 2010 2011 Total 52,500 52,500 105,000 Total Operational Impact/Other Variance from 20 year plan - 50% Equipment Replacement/50% Refuse - increase amount to $105,000 to reflect actual cost. Estimate salvage/resale value on replaced item: $ Wednesday, June 21,2006 -------- --------- EQUIP:MENT REPLACE:MENT PLAN 2007 thru 2011 Public Works Director Contact City of Hopkins, MN Department Public Works: ParkslForestry Project # Ol-ERP-805 Type Equipment Useful Life 20 years Project Name Aerial Lift Category Equipment Priority nla Total Project Cost $110,000 Description I Aerial lift truck is utilized by the Forestry department to triIn and remove trees. It is also used for ballfield light maintenance in the parks. Justification I Expenditures 2007 2008 2009 2010 2011 Total Equipment 110,000 110,000 Total 110,000 110,000 Funding Sources 2007 2008 2009 2010 2011 Total Equipment Replacement Fund 110,000 110,000 Total 110,000 110,000 Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Wednesday, June 21, 2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN 2007 thru 2011 Contact Public Works Director Department Public Works: ParkslForestry Type Equipment Useful Life 20 years Category Equipment Priority nJa Project # Ol-ERP-806 Project Name Tractors (2) Total Project Cost $85,300 Description Farm type tractors with cab used with various attaclllnents. Ice rink sweeping, flail mower, fertilizing, aeration, plowing and grass seeding. Justification Expenditures Equipment 2007 2008 2009 41 ,400 41 ,400 2010 2011 Total Future 41,400 43,900 I 41,400 Total Total Funding Sources Equipment Replacement Fund Total 2007 2008 2009 41 ,400 41 ,400 2010 2011 Total Future 41,400 43,900 I 41,400 Total Operational Impact/Other Variance from 20 year plan - replace one in 2009. Look at altenlate uses or different machine. Move second unit out to 2012. Estimate salvage/resale value on replaced item: $3,500 Wednesday, June 21,2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, :MN 2007 thru 2011 Contact Public Works Director Department Public Works: Parks/Forestry Type Equipment Useful Life 8 years Category Equipment Priority n/a Project # Ol-ERP-808 Project Name Riding Mowers (3) Total Project Cost $206,600 Description I Riding mowers used by Parks Divison of Public Works. One mower also used for sidewalk snow removal during winter months. Justification I Mowing city parks and right of ways and sidewalk snow relTIOval. Prior 49,000 I Total Expenditures Equipment 2007 2008 2009 22,800 22,800 2010 2011 Total 22,800 I 22,800 Future 134,800 I Total Total Prior I 49,000 I Total Funding Sources Equipment Replacement Fund Total 2007 2008 2009 22,800 22,800 2010 2011 Total Future 22,800 I 134,800 I 22,800 Total Operational Impact/Other I Variance from 20 year plan - none. Estimate salvage/resale value on replaced item: $600 each Wednesday, June 21, 2006 EQUIP~NT REPLACEMENT PLAN City of Hopkins, MN 2007 thru 2011 Contact Public Works Director Department Public Works: Streets/Traffic Type Equipment Useful Life 12 years Category Vehicles Priority nla roject # Ol-ERP-303 Project Name 1 Ton Dump Truck (2) Total Project Cost $205,500 Description Truck is used in the Street Division of Public Works. Justification Vehicle used by various departments for street and park maintenance and light hauling. Prior 30,500 I Total Expenditures Vehicles 2007 2008 2009 37,400 37,400 2010 2011 Total Future 37,400 I " 137,600 I 37,400 Total Total Prior 30,500 I Total Funding Sources Equipment Replacement Fund Total 2007 2008 2009 37,400 37,400 2010 2011 Total Future 37,400 , 137,600 I 37,400 Total Operational Impact/Other Variance from 20 year plan - Estimate salvage/resale value on replaced iteln: $3,500 Wednesday, June 21,2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Project # Ol-ERP-307 Project Name Water Truck Description I Water truck used in Streets and Parks Division of Public Works. Justification I Used for street flushing, watering trees and plants, rink flooding and standby fire protection. Expenditures Vehicles 2007 2008 Total Funding Sources 2007 Equipment Replacement Fund Total 2008 Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $8,500 2007 thru 2011 2009 2009 2010 133,700 133,700 2010 133,700 133,700 Contact Public Works Director Department Public Works: StreetslTraffic Type Equipment Useful Life 15 years Category Vehicles Priority nla Total Project Cost $342,000 2011 Total Future 133,700 I 208,300 I 133,700 Total 2011 Total Future 133,700 I 208,300 I 133,700 Total Wednesday, June 21,2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Ol-ERP-309 Project Name Skid Loader (2) 2007 thru 2011 Description Loading trucks, landscape work, snow removal, material handling. Justification Expenditures Equipment 2007 Total Funding Sources Equipment Replacement Fund Total 2007 Operational Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ 2008 2009 2008 2009 2010 31,000 31 fOOO 2010 31,000 31 fOOO Contact Public Works Director Department Public Works: StreetsfTraffic Type Equipment Useful Life 12 years Category Equipment Priority nla Total Project Cost $117,100 2011 Total 31,000 31 fOOO 2011 Total 31,000 31 fOOD Futu re 86,100 I Total Future 86,100 I Tobll Wednesday, June 21,2006 ----------------- ---- - ---- -- ------ - - - - -- - -- - - - - - - --- EQUIPMENT REPLACEMENT PLAN 2007 thru 2011 Contact Public Works Director City of Hopkins, MN Department Public Works: StreetslTraffic Project # 01-ERP-316 Type Equipment Useful Life 20 years Project Name Trailer Equipment Category Priority n/a Total Project Cost $4,900 Description I Used for transporting and hauling equiplnent and supplies. Justification I Expenditures 2007 2008 2009 2010 2011 Total Equipment 4,900 4,900 Total 4,900 4,900 Funding Sources 2007 2008 2009 2010 2011 Total Equipment Replacement Fund 4,900 4,900 Total 4,900 4,900 Operational Impact/Other I Variance from 20 year plan - none Estiamte salvage/resale value on replaced item: $ ! I I Wednesday, June 21, 2006 EQUIPMENT REPLACE1\1ENT PLAN City of Hopkins, MN Ol-ERP-900 Refuse Truck (RAP-R) (2) Description Refuse truck used by Refuse Utility Division of Public Works. Justification Residential waste pick up. Prior 148,000 I Total Prior 148,000 I Total Expenditures Vehicles 2007 2008 Total Funding Sources RF - Refuse Fund 2007 2008 Total Operational Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $18,000 2007 thru 2011 2009 2009 2010 176,700 176,700 2010 176,700 176,700 Contact Public Works Director Department Refuse Type Equipment Useful Life 10 years Category Vehicles Priority nla Total Project Cost $1,042,100 2011 Total Future 176,700 717,400 I 176,700 Total 2011 Total Future 176,700 717,400 I 176,700 Total Wednesday, June 21,2006 -- EQUIPMENT REPLACEMENT PLAN 2007 thru 2011 Contact Public Works Director City of Hopkins, 1vfN Department Sewer Project # Ol-ERP-551 Type Equipment Useful Life 1 0 years - Project Name 3/4 Ton Utility Truck (2) Category Vehicles Priority nla Total Project Cost $164,700 Description I 3/4 ton utility trucks used by the Water/Sewer Division of Public Works. Justification 1 Transportation to and from job sites, box carries tools used by personnel for job site repairs and light hauling. Prior Expenditures 2007 2008 2009 2010 2011 Total Future I 25,000 I Vehicles 26,000 26,000 I 113,700 I Total Total 26,000 26,000 Total Prior Funding Sources 2007 2008 2009 2010 2011 Total Future I 25,000 I SF - Sanitary Sewer Fund 26,000 26,000 I 113,700 I Total Total 26,000 26,000 Tot.al Operational Impact/Other 1 Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $2,500 Wednesday, June 21,2006 EQUIPMENT REPLACEMENT PLAN City of Hopkins, MN Ol-ERP-557 2007 thru 2011 Contact I:inance Director/IT Department Sewer Type Equipment Useful Life 8 years Category Equipment Priority nla Total Project Cost $20,200 Project Name Telephone System Description Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems. Justification Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) Prior 4,700 I Total Expenditures Equipment 2007 2008 2009 2010 2011 6,800 6,800 Total 6,800 6,800 Future 8,700 I Total Total Prior 4,700 I Total Funqing Sources SF - Sanitary Sewer Fund Total 2007 2008 2009 2010 2011 6,800 6,800 Total Future 6,800 8,700 I 6,800 Total Operational Impact/Other Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Wednesday, June 21,2006 EQUIP:MENT REPLACEMENT PLAN 2007 thru 2011 Contact Public Works Director City of Hopkins, MN Department Water Project # Ol-ERP-500 Type Equipment Useful Life 10 years Project Name 1/2 Ton Truck Category Equipment Priority nla Total Project Cost $47,300 Description I Trucks used by Water Department. Justification I Expenditures 2007 2008 2009 2010 2011 Total Future Vehicles 20,500 20,500 I 26,800 I Total 20,500 20,500 Total Funding Sources 2007 2008 2009 2010 2011 Total Future WF - Water Fund 20,500 20,500 I 26,800 I Total 20,500 20,500 Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Wednesday, June 21,2006 EQUIP:MENT REPLACEMENT PLAN City of Hopkins, MN Ol-ERP-504 2007 thru 2011 Contact Public Works Director Department Water Type Equipment Useful Life 10 years Category Equipment Priority n/a Hydraulic Jack Hammer for Backhoe Total Project Cost $72,600 Description Replacement of smaller hydraulic jack hmnmer that is used on the Backhoe and Skid Loader. Justification Breaking frost for watermain breaks, breaking up blacktop and concrete so that the old surfaces can be replaced. Prior 17,500 I Total Expenditures Equipment 2007 2008 2009 2010 2011 23,500 23,500 Total Future 23,500 31,600 I 23,500 T ota I Totai Prior 17,500 I Total Funding Sources WF - Water Fund 2007 2008 2009 2010 2011 23,500 23,500 Total Future 23,500 31,600 I 23,500 Total Total Operational Impact/Other Variance from 20 year plan - new item Estimate salvage/resale value on repalced item: $500 Wednesday, June 21. 2006 --- --- EQUIPMENT REPLACEMENT PLAN 2007 thru 2011 Public Works Director Contact City of Hopkins, MN Department Water Project # Ol-ERP-506 Type Equipment Useful Life 5 years Project Name Public Works Copy Machine Category Equipment Priority nla Total Project Cost $72,600 Description I Copy Inachine to service needs of all division of Public Works. Justification 1 Making copies for various departments. Prior Expenditures 2007 2008 2009 2010 2011 Total Futu re I 10.600 I Equipment 12,200 12,200 I 49,800 I Total Total 12,200 12,200 Total Prior Funding Sources 2007 2008 2009 2010 2011 Total Future I 10,600 I WF - Water Fund 12,200 12,200 I 49,800 I Total Total 12,200 12,200 Tot.al Operational Impact/Other 1 Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $800 Wednesday, June 21. 2006 , EQUIP:MENT REPLACE1\ffiNT PLAN City of Hopkins, MN Ol-ERP-507 2007 thru 2011 Contact Finance DirectorlIT Department Water Type Equipment Useful Life 8 years Category Equipment Priority nJa Project Name Telephone System Total Project Cost $20,200 Description I Includes the PBX, the voice mail systems, and all telephone instruments. Currently there are over 200 extensions served by this system. Also includes software for the PBX and voice mail systems. Justification I Making, receiving and routing telephone calls, storing voice mail messages, and providing telephone based information services (snow line, etc.) Prior 4,700 I Total Expenditures Equipment 2007 2008 2009 2010 2011 6,800 6,800 Total Future 6,800 8,700 I 6,800 Total Total Prior 4,700 I Total Funding Sources WF - Water Fund 2007 2008 2009 2010 2011 6,800 6,800 Total Future 6,800 8,700 I 6,800 Total Total Operational Impact/Other I Variance from 20 year plan - none Estimate salvage/resale value on replaced item: $ Wednesday, June 21,2006 EQUIPMENT REPLACEMENT SCHEDULE Net General Fund 20 Year Average $652,600 Zl-Jun-06 3.0% REPL YRS INFLATION FACfOR FIRE 02 Tele~uirt 25 1 ~E~. ~~~~,..~,es~,u~,..,.. i'I,06:r!:A~rl~\{Qhi~le;< ;{'~kiittii~~~f~~(',:,~,;;'(' 109 Stuphen Aerial Truck SUBTOTAL 2026 2025 2024 2023 2022 202 2020 2019 2018 2017 2016 2015 2014 2013 2012 20 2010 2009 2008 2007 EQUIPMENT !VEHICLES ~t; )a~. 491,000 ~.,~.;~:"y~f~f.~ '1);' ~~t:~:~f::r~f~~Ht~~~it;t~€~rrt~~~[~~$~Od~9~~!:;,;~. :l:':!S"iijl~oo, f~ t', ,'i... 491,000 42,500 83,800 500,000 34,600 35,000 600,000 600,000 ), :~~;oo6 . 202,500. ~;' .36,000 ,,,~~ \ If . -/ r' ,. . ~ . 36,600 '~.5;~M) :..{ ::i.1';~Q~J~\; <':;S ..::-.: ,.~:t,t~)~:~fr~l '~1i~~~~~~ ~\t;l !'~i~ilm!f;~!~f:~l~!~r~~lapo~fi)~'l ~~~)~~~~!l:r~ ~,.~~l~ '~: 48,800 7,800 56,600 ," ,.. ~ 24.260. :~ci:16Q , ~ 261,500 *>' 8,000 t;'l$.oo'" 5,800 7.300 r!r8;obg~~~h{~t; ~ 5,000 5,800 5,300 31,500 5,800 :ii;lAAic9~fp~~.~t;t ~, .. ":o:;~,~i~~~~~~~t~~~\, ::'1': ~~};;,::11;1~;[~' ~~ 6:~?: : :~! ?1. T(~~i~$Y~itri~r;, ;,r~:;1';;,W!";:~C~J' :&1~::2 :}J:m~~;~, f: ;:{t;;i;~t:~~~~~~~;~ii'.;r~;':;~~[~~~;~;!:~~~~o6a; Floor Scrubber ::U:~;;'~l~~~$~~;p~t',::, ;;^t: Workout Equipment SUBTOTA . " 30,700 f2ij tfVtiMoi;~ ~f~~~~:~~1(f\!S;:J::::~~:O::f~;~~~:~::~~~~~~::::!::':'~~f:~':~ ~7:':;;:;~b ~:. ~~\:~'.: ~;~ : ~:~:~},:. 211 Utili b:4 6 37.700 l~};"'7~':;~~:~l1f,;;:r'::~ ' ';';: ;':;2.<~ 'r.1~;;;:r;r;~1i;~U;f~j'$;gcip;:-::':~:.;'~ ~:;f~:~f'ip~i~W1:t'21~i6.Q~:1;;:~' ,]j:Y~~:i~~~~~'Op? !':j~ih~{:'7:I::~;!:, ,.:~tt: 218 Admi 24 800 26,300 27,900 29,600 31,400 Policl 22,000 83,400 52,3~? ,. ;' &2,100 36,600 :. ,5lJ,a(J(j '^ " 0 ~~'~;~ 24,200 47,900 :,;:/~:"'f 4.m~66r.l~.r-:'t:i~~C";': 46,500 ~[~~l:t~~~~t:~~~Ti~:;; ;T', ':'~ ~';:4j i~Q~O:~~i~;::'~~~~~~~~' 46,500 :;. ;\):.~:;;!:;l4:&i.$00.: 00 6,700 Of" ,~!.!! ~l$b{t;;t: / l:~~i;;~,:~0: 42,500 (:'~:49J Ob~~;:~~ J'l~~:"':l~~!:~;' ,~il)::~:; g!:~t~~~:~:rl}A3:iiio~t~:~:rj;&: 42,500 ';i\4i,~6'6' t;'~{g~~f,,: :t" 19,800 100 21 40.1 O~ r(.~ 27,200 'I!J/b ~Yik';; gJ2~6M:p;;;~';'i;;;: '~ilr:~~'~I$l:"r;;;':'r.i,~~~k~ry~~;~o(rit~:~!!~~r.~r),~~f,~:~h;, . ::;I~~~1i;~{ '~ii~~o:{ 38,900 r[nJ~~ ~'~i~~~,t:~;l~;r;l~~' 32,600 35,600 38,900 ~:;~~:~~~:~:w ;:,,~~;l~;.rA~~:~il;:: ; ;1;' :~i'~";~'J;;-:~~ ~!~n::Prr{(;::lKin:l, .b '~JH~I~lliV}:':~. ;~;~;;~;lf 3'~:;t~~~~~n;;'.;;h:;~f:i ::{, 38,900 G'l':.~:r~;tl~i~i~;[;:;' 8,000 5,000 36,000 30,700 :!I~';I~~~r8p6J.~l:lt~ :::i ~~~ft;0~ 29,800 'f~t;~:l~'!~~{f~~:I~~~~:'~13p;~1ip,: 29,800 ~~:*l~~~}f~~ 15,000 POLICE i;J~~G[~~hf.lr~~F,; :Jl;~';b~~:ff Squad #3 ::::;:~J'1~~~~~Yi[4~~~~:~:~\:'.;~i~~~{:;~ e .;;:;~f4$~~~~':~'~;; It::r::'' Car ~~/,~OO , 4 "52-j3b,O ""33;~6'6 72,100 ';43;600, 60,400 ';/:34;~6o i~.}i:ft :~';~il:~:~~o6;~Oi)~r(~""".. .:ti: ,;r,;'~~"f~~1~; ;~~~;~::lt;+ l. ",::~:'l (1)ji;tOb"~; ~:i:.. ';.,' 33,300 35,400 37,500 39,800 42,200 A~:~~ :~::~: ~ >.~~1~~r;ti!t~;f:~:~1?r:'~k.~f:~~~:':;~~~l~,~7~~~1!~~~~f'~:~~~i ~; .(~ "'(' ':~~:: r:i{t~'~~'~fi ::;i}~~~~:,::~':~~~~';~\":'~"'~Y!l:~;~4Q;~jOq~: :;::: 29,600 264,500 }B~40ci;: t ~ :.'l:I';'~;l~rW~:~ it 306,500 'T[}~~~~~ ,,~ i';'lll,:::; 2b~ifut.lf:i ;r.;,:,:l;,i)f:; :'~r''';"1: :\,,;.,~ ,;,{;:'t;I~r:~:'~~~~I!ti~~;~it~i;liVl~~;~f,:,:' ~~^f.:;::~~r!i:t);~~:;:;:~i,ll~.I~:?~~~~~ \1*""~ i~~I,ti~~~~0r~~nllJ,d~~~ifu1;~~ti::~:!;;m~lillll~;l; '~;f,$;;I:lj~1~;r:l~!;~~:r:.: ;;';;:r~~fl.;~i~t;if~~~;J'ff;~;'~'f,;;'['1''/'!.:i ~'~Y}i;i~:; ;i "~~ i; ~,~~l,': ~i'; ~:~:l:~~!~~~:i'::'~:il'2~~6bd~)i'~,;:~~n ~:;;~~:l~~f,h~;;;,~:~,}p,~:lrt :\'r:f~ir,t~'i;!~~~:f:' 29110p Mobile Data Computers 5 47,000 _ _ _ _ 63,200 73,200 55,500 8,700 45,900 9,000 31.100 72,200 82,500 50 39,300 9,600 41,100 9,600 83,500 9,600 224,700 37,500 80,300 228,200 950,000 162,900 9,300 75,600 367,800 13,500 213,200 88,300 136,400 9,000 63,400 63,200 95,100 27,800 57,500 708,700 26,300 8,700 155,400 14,200 SUBTOTAL Page 2 REPL EQUIPMENT IVEHICLES YRS 2007 2008 2009 2010 2011 2011 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 ;~~~.:~~~:; i~i:),:~"~;1~~l~l;N~. 18,100 49,500 673,500 P.W. STREETSrrRAFFIC 300 4x4 3/4 Ton Truck/Plow 10 33,600 ~~J1,\.4'\\";;;";'4'~i;w.~!li<;:~)l~;;'Jlifllt~~~"~i;t$}'J_:il~\}lij;;'~~f:~;l.'i'm;;..:~~~:~J%;;"jjt"+iii~gp;~~i;l~l1;li,tli'~.'.tJ;\~ 306 4x2 I Ton Dump Truck 12 ~b~::~;J1fii'B~~~fptett. ~ ~ .:'!~ ,~~':11;,':;,:, :1~i:'f.;~f:f;,JL;:~:f~"" ':k:'~~~1~t~!;hl~;~~i;:r:;~;~~:t:~~Sj;flti7,~1ii~~t$~L~\:~j~i"~~~h,~;':' '~..~'i$16b(l~~~; rt ,( 312 Single Axle Dump Truck :aif:;~~h~j!\ii;:~1ftip'1~~iL".", " ?,~~ .~~d~~I?u~p'T~~~ .. ' '~,l$ ;:Tande.in'Dump'tfuOk ' , , ;',~ ' 316 Water Truck ii~o~J:Fio~~~~t,~44~t ~{),,,:,:: ::~;' '.,,:... 322 Front End Loader 218,11 l~24 '. ;$~4:m~d~f.:r.';>:< \i ~ i: ~:;:' ,,:" .;~:\ :;,;:J' :~:~,~~':.: 325 Skid Loader ~~~~:t~1~~Ii~;}~~::>~\~,;i:~~~~!~~:~:~i~~ 'I~. 334 Striper ;#11~~y-iitt;f!" '];::~:;:.~: ':,f 344 Snow Blower @:Jf.:Trlll:r;~r:;rF:', 't \;;, Sign Machme 327,600 327,200 48,800 189,400 161,000 11,200 178,600 218,100 224,000 44,200 211500 - - - 28,900 - 56~ - - 32,300 51 ~:.~ >kJ}~ 164,700 42,300 241100 SUBTOTAL P.W. ENGINEERING 700 Engineering Van 10 P.W. ADMIN Rado System 15 P.W. BLDG.lEQUIPMENl' SVCS. 703 1/2 TOil Truck 10 2008 Page 3 REPL EQUIPMENT /VEHICLES YRS 2007 P.W. PARKS & FORESTRY 800 1/2 Ton Truck 10 iilJ~ 804 2024 2026 2025 2023 ~" 2022 202 35,400 'iil~tJ~i(t;/~;l:{;'~:{'; ,: J ?~~:~d~i$;;,:;i~i~i;q;;,irl:/':;'~' 42,600 H{r~7f~!:~/~:;: !::"'fi~~:4,1~~?'[.t~.~f!'~::"::1: 23.000 .~ ti~~;~1i~f#Ji~(!~:;t;;';Z;.;J.:X':' ;'/. .,:.! :~;':li1~6Ql,~?:t?~ ,;. 143,800 35,400 2020 2019 2018 2017 2016 2015 26,400 ~~ 2014 ') /?t/~'T,;:ifll ':{r~~M~,:~!~~;~5~:,:'i !T'~~";:';'i:. ,r 5 2013 25,700 20lZ 141,400 20ll 26,400 2010 ,~~"l~}~f~:,J:>> Jll1fi~;' x ~,-~ 174,200 32,200 2009 13,800 ~ r"~:;~~;~~~ i~~;*jl;~'f~ !~. v. ( 110,000 ;': ::;';.' ':'''7n:"~':r:: ~\.' 41,400 ~,~IXll: ':t:':: '$:;:"/:, ~2~ . ~!?P~ Mr<?~~~,>>,"'","r, ,. 1, ill~6.;.'tlk~w'~A~1i!;1;;,o/;I"!i:r,%~. 832 Stump Culler '~Sa"i;;~W:&U;d;~~[fN'~:t\.:; ~~~\\\,~i't';~?'i\)0f;'l! SUBTOTAL 52,500 13,800 20 ;~... I 8l ~~ ." ~?I.~p... ~?~~~~ ;8l~r;'J~t1rttt:wJ{1~ 812 Aerial Lift fii~~Ef,~~~iJ~:Y:, :;~T~rj;!?:;i-?:i:r:;:!~~~~t! ~ 1 ~,., T~ac.!?,~ " '818.:;lTiU6k,ji~i :,820 Trucksler 36,600 22,000 22,000 22,000 22,000 22,000 26,000 26,000 26,000 ". ':. t:\1';~::'~~i1i;\11fJ!;1~;':~:i~l~;~ ;&?AO(i/ . "i4;'j~~/;~:11;17:.:e:~:~~"~tJ~{J~i7f1:;r,':!i:(~~:i''.!Y;:i: ~ !PI}1~L,' 4~(JQ9' 8,000 8,000 8,000 8,000 8,000 8,000 8,000 8,000 t;':i~~; tab;l ::1" ~\:~~~;!~t;:";';::i:~',,~;:: ,.,:,: ; ~T:rr~:W;:~~;;:~\:~{ ::';~\<'.:: ;~l;:}~it~;~~\:;;;J !!~~; ;t:;i:l;7l;;I~i];~;~:4:;lil#' :,:"::; 15,000 ',", 'iJo;(llio;'r~;:lo:o6ir;.;}5r;:j'Q~tioO/':' ~f'~a:OM;Ki(~'0 ~a~60p~\1~0ifj6!ri65'.tii. :~;ao;(l615i!;;};::~6~~OO 12,000 14,000 14,000 14,000 14,000 14,000 16,000 16,000 R;:f~~;~pp.'~:.i:~;J~~~':r-;;;~i~:.f.;;i6.~PQ.,; F~;~ lPl~06~r) ~;F :':;jl, .~., J;f;', ;~'~;~p.6~~:ii,~.~Q.ti.:.,; '~ 'll~;:~!1~r;~" 23,400 103,900 21,500 25,700 8,000 15,000 rn;o'651~~~fs,ij~OQij;;li~:~i~ol~~a~;[M:5ij;::~;::~b:600~;1.~';'~~O@Xr 10,000 10,000 12,000 12,000 12,000 12,000 i! *K~,:AAQ%~~I{ti:'~:l~~fr:t\: ~;;~~~~~Q~~~JM~6~$p,~;;~,1;;:~i:f.;,~~illl !1>t~$CJ.~ 82,100 10,600 20,300 8,000 ~;t:!;~PI 8,000 8,000 ):~l~W~fii~i?'?';~'~:.i 8,000 14,000 8.000 !~,OP~" ..', 1.1,OO"? q..,,,l4,~00 . .' I~,O~? }l,!;J,~}~;: ~l:Ji;1; :1f'H' :(i;;bJ~4f'~5.1~~~\~ >> 8,~?? ,>> ., 8!~.9.~,,"." 8,000 ,.. r. 8!~~~." .. '" 8,000 8,000 ::!'c~:;~~~$t~3,:~;:1 \;:Ii~l: :f.r-'ilif"J~:;~"i;:(;' . ');,' :);, ~:1 :'~~" , 0,000 10,000 7 ~l), :fm;r$~{;~;~~;ObQN;t, ~:'i,~o.oo'5,t{;. ";;~5.i)Od~:n:i~O;QOQ," l~i,7ji .,,,,,,,,,,,.E"~~,i~~~1.~~,.~~~,~.~r~~c~~~r,, ".,,,. \" "~~~~O". ..... . ~!6t~.,... . 8,~40.~.~,~0? ,,,)~,OOO ;~~\:;;:~!pg~~titiM~~$;~@6~e'{~~;~;;~~!.;3;'~1\'~;;'~,;(6;~P9,?:'itliti irN.;;f;~i(;:r~ 'lt~;,~~Q.j:i:.~;.$9,Q, li ;tI'tf Network Infrastructure Upgrad, 15 15,000 _ SUBTOTAL 78,140 67,140 16,700 89,000 80,600 74,500 68,000 105,700 74,500 66,000 83,500 68,500 164,900 68,500 56,640 ACTIVITY CENTER Copier 7 ~;IT~i~:I~~Ri1ti~f~(3tlit}<<';~F;tl;}r0~f~~i~: i~~~ft';:Ii}*{~Ur~; SUBTOTAL 122,000 86,500 84,500 74,000 ':""\1",1 ~:,:wr::':1"}:.}t:.~ifR.~: !':,I):~!iY;':)!;iC(' 8,400 5,000 15,000 5,000 5,000 5.000 5,000 5,000 5,000 5.000 5,000 5.000 5.000 5.000 CABLE TV Cameras/Control System ARTS CENTER Copier 5,000 5.000 5,000 5,000 5.000 5.000 5.000 5.000 5,000 8,300 14,900 52 12,100 Page 4 2026 2025 2024 1013 1011 1021 1020 2019 2018 1017 1016 1015 1014 2013 1012 101 1010 2009 2008 1007 REPL YRS EQUIPMENT /VEHICLES 36L500 :4&;000; ~~ .,/' X'~. ~j~'5:~~lj~~;;~:;,~:,::,,; 1,9,-l?0 l'~, I, 31,600 $~o<()6,; 16,500 '~:i66::~;1~ ~IIN<'- "'~ I ".~ I :~~,;,~(; ;:~. 28.800 10 20,500 Y . fu~:;~~1~~~~t~~;tiP::~~~~;~~3;~:;~~i: ~ ~:~ r~2]~\ 20 T '" ".:':.i!, :i6<; 134,800 ~;f j~~t~~~~~;~1~3~1(f6,~~~;~}~~f~~~~ }~t; ~r 23,5o.~ ., :~? 14,~0? 14,200 ~'~;'~?0:;:,:(;f,);;;6t~6.Q'( 10 ,:-'1;. 5 HI 15 lIRA 4x4 3/4 Ton Truck WATER 500 1.12 Ton Truck ;$0 i.~~4~4i~i4;ri~:rrtiel(t~.~:. 533 Backhoe :54~>> Xit.:c~6(tis$Qr,::~' , ." Jackhammer \;'if,.~~;;BiIlifiiS~ie~'~~:~~r<+'::' Copier /". 'T~h;Ptl~fi~ $;;$tim" ~' .', RadiO System SUBTOTAL 41 19,100 ,~:: :::;1;'4$,200. :.-": 48,000 31,600 21,500 8,700 00 26,800 35,700 139,800 23,100 30,300 12,200 20,500 SEWER 508 3/4 Ton Utility Truck 10 ~O?ii;~j~ffb~jwii~~f{~~~;/~Jj~:E;;;:;~V~~~j"i:o':f'" ; 530 Jet Vactor 20 ;$,3~;':j~4jhlg;M~ihi~~";':;,:,J:~ 't'~: .':;"1J:;',\'~,O;' '" 534 Generator 25 i~.i$.~~&;~~t;;t~i:t~;~;l;;~\, ~~~:. 't+ : 12f Billing System 7 !i'>~ei~p~~';;SY$tti1t" :.~: : '<Jf Radio System 15 SUBTOTAL REFUSE 901 Refuse Truck (RAP-R) 10 ~Azrtji~~~iftM~~~:(~?~1t~!:~,"ii':i';Hi;'. 903 Refuse Truck (Rear-L) 10 A1 (l ~sw~~I(;}id1f\(U%fWi#o;e~~)'.!,:r:T5>: :::'::;:""~ Radio System 15 _ _ 59,700_ SUBTOTAL 176,700 101,600 59,701 239,900 45,200 .~ l:~~' . ~?:~:~~?fO :{: '~i-y )>>1 : ~ '.: 23,000 185,800 8,700 61,300 33,600 5,000 39,800 6,800 26,000 {,;. 275,200 136,600 64,500 204,800 2,500 41,400 52,500 125,600 2,500 53 88,100 2,500 12 STORM SEWER Billing System PAVILION Ice Resurfacel GENERAL FUND-VEffii 272,800 484,800 206,800 772,200 00 632,600 296,900 294,600 233,900 581,600 974,600 306,500 i~~RALlf.~M~~ ;n~1~Q l,I~;(~tt:i~ry4.~i;~rDl~tlfdlfqo.lg'''~'''=':QtX~:J!~~$~;4tf~::~;:;20~:78~T';';:ijJi@!;Yr~~1~~Qg;[~t;:~?ii;pA~lJ~j~~aOij:;l;;it;~rf,~Oo.; HRA 00 :~Ati~&W'l0;~~'+~::i:~!~~r1';ll~f::' :;; "~tip~~'!~~~;~~~~9~~j!.~~~lW~:~{~~1~;ap6~;~W:;f;~(o~6)D ;'~'!ll~~~r.gQ6r:l~~~~~~Q~*;*~!~~'5~aoo ;\:~,j'!:f:j~bQ6~~r,i. :U~~;ciM!?~~1:~$i~a9~:n~~;~::i5~iJd~;j~;;;f~~'5~tiQQ't~~;t~i<5;ob() ARTS CENTER 14,' 18,300 ;wAjffifJ,1::~;~~;~~;~::'~:~;:;;i;t:; ~ lilJ~~61~~tt~~~:f~;;1}t~mr.(~llQP::~lf~~~:m :'ii~'?~o~~J~::~~~;I~yl![i~~;~~;:E!;~;:~~~;~i2t;~~~~~i:lioml:h:iilf~l~: Iii6Sn;~:!rr::~2:;;;;:' SEWER 33,600 61,300 59,' 23,000 45,200 :iEriJSg~:;,i;~;~~,;"l:~~;::,;:!~I~:ltlfi!~:;r;;s,.w ''':1' ;',',,", Ii ;,'''[);, Q~.;).uu/!'.' .'&I.4UlJ':c ,'.'l''>,;;:f'.l' :;!r "1E,UJj:IUUk,.; W:l.. ' ~,:.! -, i~; Mi~oD:::i!::;:I:lj~r-;';:'~~;;J\~:i<,: 'i~'i8i~j;~~H~~i ':. r;:~~ ~~.~ it: ~~64:$OO?':/::13~160&V;l~':'~15:i()({r. +': "/> :.: STORM SEWER ~P,AviLR5j;.l:. :'(:([~:~;\:: 1016 1015 1014 1013 1011 1011 1010 1019 1018 1017 2016 1015 1014 257.400 1013 545,400 2012 532,400 Uf~~!;iQ'" 201 1010 2009 2008 1007 TOTALS Page 5 ,','this,GOO 500,600 523,300 341,700 683,500 1,107,300 524,400 !U~~,.' ~~:~;~~::~:~~::?:~i:~j:0r:i~~i;f~iij!ii;{~"!!~~'fii~~:~t[~~1~:t~~:~;:~~:Z~~~1;J:~~i~;:;; 5,000 5,000 5,000 5,000 5,000 5,000 i . < 1~{;} ;~i:;' < j~:~~~ir~~~,f ~:::~;;~:~;~~~h~~}~~~~;:~~~~:':it~r;~1!fri'~~rf.H~aob~t~~~~ ~t ~;i, f ,:~1. 31,600 23,000 64,500 184,600 294,300 170,800 GENERAL FUND TOTAL 315,340 87 .. 695,600 670,900 375,100 383,500 638,900 608,500 1,481,900 522,900 1,690,000 :itM iQ.r.w~~f~~:~::ir~1(1(~ni~;'ij:!;~1~~(~;:~~l!!~~~ll;il~ft;~Z~~fijil~!I~~;i1ittil~~i~j~!Jf.~lVC~aiii~Q;::;~:":;':,"~;~T: ~~lI/J!;~~. fIr.! ~ ~;$!fjH~J: m!!t!Jr.!",i~{~~!{~[;t;~1~~ :l~di6?i::i~!:;:~m.:;:'::1 CABLE TV FUND TOTAL 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 iAR'iS;b~i~;t~it~;'~P.~~t~~~f.:'iT1~1~,:t~$t~f~:~~;;.i~}~T(.~~:p,l~r~::I,~;'~~r~r,i(~~W1IX~!r;~J!lb~~~lf:l~:'::~i ;~:~?,;>;Il,~ft~;i:O~J.;.~~~;',:;~,' :,J. ;'i !:'1~ :;;llilil'i!;~mWt~~II:~'~ihl;':;f~~~,;r~~{l!~~)~$~~*~t;j~:.;~!~~~~~r;,~f~:~:',~ti~$~;1ia;~,6lij;1j\~:,;J~~~k~;:;fj: ~:;"':,11":':~~!1f. ,',. UTILITY FUNDS TOTAL 99,000 4 62,900 149,800 225,400 219,000 33,600 88,100 179,100 17,400 449,700 i~~~~oof~~~~;~;;l~::'::;;'~~~i~~~i~::~~r ", 700,200 GENERAL FUND SALVAGE 25,000 25,000 30,000 30,000 30,000 35,000 35,000 35,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 iNEi.Gii~E~jpii~%:::;;;~i~'E,~{~~:':;~**~J%:~~q;a~O!~4~i4~f~Ao1'x~i~~t~41~~${O:~~QQ}~]J:~~~i$:ciQl;',":':6iiO.6^OO: Y:;~~~I~o'b:jr';j~QK~~~A~~;ifi~~~bO~f0j~~';s~;fhlijf;~9ti~~~M~QQ;:.:i.d~o;<i6(r', ,,, 460;60~:~m'f4~~~~W::;~1" :1()i:7~(f(~i~ffi4{J~B~:i:o'jtjQii?:f:f4~4:~OO 1,424,900 873,100 411,100 551,300 537,100 1,144,700 581,800 1,680,900 701,600 677,500 607,500 605,500 815,700 763,500 411,500 1,325,500 387,740 916,940 419,340 ALL FUNDS ANNUAL TOTAL 20 YEAR AVERAGES: lOIBl /\.veral!.e FIRE EQUIPMENT 1,786,900 89,300 ;iI~APMi~~~ifiQ.N~~:~':.:':;,~;,:~:;r~%i.i(i.i}~~~~7iWfr~[Q,~ POLlCE EQUIPMENT 2,871,200 143,600 ~poilii~~~t$Jf~1;iq,N11ff.:f~;11~.i.~~~lj~I~,~)(6p.~f~Tll~~~~~11 STREET EQUIPMENT 2,660,100 133,000 l~t~Gj7jQW:~~1f~i~Yri~~$~4~tJ:W~~~~I~~Q~iillt~)l:fjp~~ ENGINEERING EQUIPMENT 50,400 2,500 1P,q~~c;\.y~~$j:~~1$:i[dt{Ohl~~~;;!~;I;ir~~i;156:a6tt:~l}~f.Ft:;~ii8~Jij CITY HALL ADMlNISTRATIO 91,700 :~~tiYKt~~(;f~ijft~}[@~t~ :~;:r~tJQ!~ PARKSIFORESTRY EQUIPME 49,700 GENERAL FUND VEHICLE/EQUIPMENT 8,419,400 421,000 ~q~~.Qt~ii~i~viRMil~~~~~tj~8.4~b~Y,11~:i~t~&QJ GENERAL FUND TOTAL 13,777,820 688,900 HRA ;QlJfLjr~V:f~~'~;(lik~ ARTS CENTER FUND !;WA~lj~Jt~;p~ SEWER UTILITY FUND ~MP.#~j~~'ijJitiiii!i STORM SEWER UTILI :}>~ VJi.l0N:'~:OFll);fR:;:!! 54 138,500 2,770,800 UTILITY VEHICLESIEQUIPMENT