Loading...
HomeMy WebLinkAboutItem 05Lakeville Memorandum To: Mayor and City Council From: Steve Mielke, City Administrator Dennis Feller, Finance Director Date: August 28, 2013 Subject: Equipment City of Lakeville The City Council, at its August 28 work session, requested information on the proposed equipment acquisitions. Equipment acquisitions and replacements financed primarily with property taxes, sales of assets, unencumbered balances and liquor fund transfers are accounted for primarily in the Equipment Fund Equipment Fund Statement of Revenue, Expenditures and Changes in Fund Balance 2014 2015 2016 2017 2018 Revenues General property taxes $- $ 375,000 $ 408,800 $ 445,600 $ 485,700 ALF Ambulance distribution 19,814 - - - - Sale of assets 240,500 163,000 234,800 188,000 132,700 Transfer from: Liquor Fund Total Revenues 1,100,000 1,160,000 1,160,000 1,160,000 1,160,000 1,360,314 1,698,000 1,803,600 1,793,600 1,778,400 Expenditures Election equipment 26,667 26,667 26,667 - Fire 832, 805 63,332 35,000 666,750 263,750 Parks 485,212 448,221 473,325 362,210 174,130 Police 638,523 382,111 590,898 674,164 80,487 Streets 861,827 742,626 1,283,675 978,294 626,871 Technology 303,730 114,043 93,764 370,256 581,656 Total expenditures 3,148,764 1,777,000 2,503,329 3,051,674 1,726,894 Net change in fund balance (1,788,450) (79,000) (699,729) (1,258,074) 51,506 Fund balance, January 1 3,963,447 2,174,997 2,095,997 1,396,268 138,194 Fund balance, December31 $ 2,174,997 $ 2,095,997 $ 1,396,268 $ 138,194 $ 189,700 The Department Directors will be available at the September 9 work session to address Council questions. Attached is the 5 year Capital Improvement Plan - Equipment. Equipment Function Financing City Clerk Taxes - Equipment Fund Communications Franchise fees - Communications Fund Engineering and GIS Taxes - General Fund Fire Taxes - Equipment Fund Liquor Fund profits - Equipment Fund Inspections Permits - General Fund Liquor Liquor Fund profits Parks Taxes - Equipment Fund Police Taxes - Equipment Fund Liquor Fund profits - Equipment Fund Streets Taxes - Equipment Fund Liquor Fund profits - Equipment Fund Technology Taxes - Equipment Fund Utilities User fees - Utility Water User fees - Utility Sanitary Sewer User fees - Utility Environmental Resources Total Project Summary 2014 26,667 66,686 79,251 832,805 1 2015 2016 26,667 73,400 3,000 63,332 26,667 65,000 35,000 2017 2018 50,000 50,750 57,850 - 666,750 263,750 TO BE DETERMINED 22,460 16,233 41,272 485,212 448,221 473,325 362,210 174,130 638,523 382,111 590,898 674,164 80,487 TO BE DETERMINED 861,827 742,626 1,283,675 978,294 626,871 1 1 TO BE DETERMINED 303,730 114,043 93,764 370,256 581,656 67,740 118,549 15,074 60,717 67,044 290,608 118,549 403,576 60,717 67,044 29,799 3,721,541 2,131,769 2,986,978 3,280,957 1,911,732 Equipment Financing Function 2014 2015 2016 2017 2018 Franchise fees - Communications Fund Communications 66,686 73,400 65,000 50,000 50,750 Taxes - Equipment Fund Fire 832,805 63,332 35,000 666,750 263,750 Parks 485,212 448,221 473,325 362,210 174,130 Police 638,523 382,111 590,898 674,164 80,487 Streets 861,827 742,626 1,283,675 978,294 626,871 Technology 303,730 114,043 93,764 370,256 581,656 City Clerk 26,667 26,667 26,667 - - Total Taxes 3,148,764 1,777,000 2,503,329 3,051,674 1,726,894 Taxes - General Fund Engineering and GIS Liquor Profits - Equipment Fund Fire Police Streets City Clerk Total Liquor Profits Permits - General Fund Total Liquor Fund profits Total Project Financing 79,251 22,460 3,000 57,850 TO BE DETERMINED 16,233 41,272 User Fees - Utility - Environmental Resources Environmental Resources Utilities 29,799 Total User Fees - Env. Res. 29,799 - User Fees - Utility - Sanitary Sewer Technology Utilities 290,608 118,549 403,576 60,717 67,044 Total User Fees - Sewer 290,608 118,549 403,576 60,717 67,044 User Fees - Utility - Water Technology Utilities 67,740 118,549 15,074 60,717 67,044 Total User Fees - Water 67,740 118,549 15,074 60,717 67.044 Total - all funds 3.721,541 2.131.769 2,986,978 3,280,957 1.91 1.732 NM& EQUIPMENT Description Description Precinct Tabulators DEPARTMENT: City Clerk 2014 2015 2016 2017 2018 2014 2015 2016 2017 2018 26,667 26.667 26.667 - Description DEPARTMENT: Communications 2014 2015 2016 2017 2018 Edit station replacement 11,508 Crestron system 45,453 Backup digital file recording 4,269 Archival recording 3,842 Carpet 1,614 Minivan 22,000 Chamber audio system replacement 20,000 Chamber light panel 20,000 Transmission rack routing 10,000 Dais monitors 1,400 ENG Camera (2) with tri -pod 33,000 Tightrope replacement 25,000 Hand -held video camera 6,000 Computer desktop monitors (2) 1,000 Control room switch 40,000 Control room/council cameras 40,000 Lobby monitors 750 Portable lights - - - 10,000 Total 66,686 73,400 65,000 50,000 50,750 3 Year Year 10,000 EQUIPMENT Description DEPARTMENT: Technology 2014 2015 2016 2017 2018 Computer Replacement 24,218 47,925 57,510 57,510 Mobile replacements 136,526 136,526 Servers 218,828 VM Server ESX Host Machine 55,092 Virtualization SAN Solution 163,736 Data backup & recovery server /storage 4,779 Data backup & recovery tape library 15,789 Security camera video recorder - Police 25,284 Security camera video recorder - CMF 6,321 Switches 130,381 122,953 Telephone replacements 19,264 19,264 19,264 19,264 19,264 Blue Ray CD/DVD/DB Publisher Laserfiche Workflow 47,250 Copy machine 18,388 18,388 Software - 26,575 26,575 26,575 Total Capital Improvement 303,730 114,043 93,764 370,256 581,656 4 Year EQUIPMENT Description DEPARTMENT: Inspections 2002 1/2 ton pickup 22,460 2014 2015 2016 2017 2018 5 Year EQUIPMENT ►. �� Description Animal Control 2012 Compact Van Administration 2005 Sedan 2005 Sedan 2005 Sedan Investigations 2012 Sedan 28,691 Mid -size Crossover SUV 28,877 2005 Sedan 2008 Mid -size Crossover SUV 2004 Minivan 26,339 2004 Mid -size Crossover SUV 27,692 2002 Mid -size Crossover SUV Patrol - Un- marked 2010 Sedan Patrol - Other DEPARTMENT: Police 6 28,691 32,517 Year 2014 2015 2016 2017 2018 Community Service Officer 2013 Sport Utility Vehicle 2012 1/2 Ton 4x4 Pick -Up 27,783 28,600 2013 1/2 Ton 4x4 Pick -Up 28,654 23,400 24,500 26,269 26,400 27,387 Patrol - Marked - Sedan 2013 Sport Utility Vehicle 31,500 2013 Sport Utility Vehicle 29,987 2013 Sport Utility Vehicle 29,987 2013 Sport Utility Vehicle 29,987 2013 Police Interceptor 32,517 29,987 2013 Sport Utility Vehicle 29,987 2009 Sedan 32,517 29,987 2010 Sedan 32,517 29,987 2010 Sedan 32,517 29,987 2010 Sedan 32,517 29,987 2011 Sedan 32,517 29,987 2011 Sedan 32,517 29,987 2011 Sedan 32,517 29,987 Patrol - Marked - Utility 2010 Sedan 32,517 31,668 2013 Sport Utility Vehicle 33,461 2011 Sedan 35,000 2013 Sport Utility Vehicle 33,461 2010 Sedan 32,517 31,668 2009 Sedan 32,517 2011 Sedan 32,517 31,668 33,062 29,987 27,000 DEPARTMENT: Police Year Description 2014 2015 2016 2017 2018 John Deere Power Unit 9,000 John Deere Broom 3,000 Tennant Sweeper Scrubber 12,000 K9 Vehicle Insert 2,880 2,900 Glock handgun 1,639 Taser 16,230 16,062 PBTs 837 837 837 837 837 AEDs 19,032 CSU Cameras 2,412 Patrol Bikes 1,800 1,800 Bicycle lights 1,317 Laser 4,000 Binocular/Night Vision 670 800 mhz Portable radios 196,000 Squad radios 17,000 Conference room table 1,904 Light Bar and siren control 9,588 11,984 32,960 17,000 Emergency vehicle preemption 4,975 4,975 4,514 Radar Unit 30,300 18,180 6,730 2,795 2,795 AR15 Rifle and Equip 1,800 8,100 2,320 2,388 MAAG Rifles 2,994 MAAG COLT Entry Gun 1,350 Tint Meters 500 Dragon Naturally Speaking Devices /Software 65,134 Toughbooks 148,000 Computer Forensic Equipment 9,073 13,000 Field printer 507 LOGIS Public Safety Application Ste 176,964 Body Bunkers/Ballistic Shields 2,480 Digital Voice Recorders 10,000 Computers 2,214 2,214 GPS Unit 1,565 iPad 630 Total 638,523 382,111 590,898 674,164 80,487 7 EQUIPMENT Year Total DEPARTMENT: Fire Description 2014 2015 2016 2017 2018 1987 Spartan 75' Ladder 4 700,000 1993 Brush 3 Chevrolet 63,448 Audio visual equipment 3,950 3,950 1995 Snowmobile/Tracks for Kubota 9,057 Replacement of rescue tool hydraulic hoses 19,732 Firefighting nozzles 4,230 4,230 Sign Face Fire Station 1 & 3 3,480 Blitz Fire Nozzle 3,150 Folding traffic cones 3,200 Shealth for multi -tool 1,170 Low level strainer 1,550 Flag pole replacement 25' 1,64.0 Furniture replacement FS 1 3,068 Fitness equipment 4,825 Patient protection kit 2,205 Helmet flashlights 8,100 Computer /phone 2,308 Rechargable scene lights 3,825 Thermal camera for ladder trucks (2) 21,250 Hydrant valve 5,784 Ram Air Gear Dryers (3) 21,985 Refurbish command vehicle 35,000 1991 Peterbuilt Engine 2 600,000 Replacement portable radios 66,750 66,750 Rescue tools 65,000 2007 District Chief 3 Vehicle 44,000 2010 District Chief 4 Vehicle 44,000 2010 District Chief 5 Vehicle - 44,000 832,805 63,332 35,000 666,750 263,750 8 EQUIPMENT Description DEPARTMENT: Engineering/GIS Year 2014 2015 2016 2017 2018 2002 1/2 -ton 4WD 34,341 Sport Utility Vehicle 23,778 2005 1/2 -ton 4WD 2005 1/2 -ton 4WD Engineering office space reconfiguration 10,000 Chairs 6,152 Traffic counters 3,000 Computer workstation 3,480 Tablet 1,500 - Total 79,251 3,000 - 57,850 28,925 28,925 EQUIPMEN DEPARTMENT: Streets Description 2014 2015 2016 2017 2018 Maintenance Vehicles 2002 3/4 Ton Pick -Up 27,168 2006 1/2 Ton 4x4 Pick -Up 2006 3/4 Ton 4x4 Pick -Up 2003 3/4 Ton 4x4 Pick -Up 27,168 2002 3/4 Ton Pick -Up 27,168 2005 1 Ton 4x4 Truck 73,973 2007 1 Ton 4x4 Truck 85,808 2001 1/2 Ton Pick -Up 27,168 2006 3/4 Ton 4x4 Pick -Up 2002 Sign Truck with Crane 157,410 2006 1 Ton 4x4 Truck 83,588 Tree Trimming Truck 120,000 Heavy Duty Trucks Sterling Dump Truck 192,719 Sterling Dump Truck 192,719 Sterling Dump Truck 192,704 Sterling Dump Truck 192,704 Sterling Dump Truck 217,772 Sterling Dump Truck 217,772 Sterling Dump Truck 223,554 Sterling Dump Truck 231,263 Sterling Tandem Dump Truck 250,204 Sterling Dump Truck 231,263 Medium Duty Dump Truck (New Plow Route) 171,906 Special Use Equipment Kubota ATV 56,968 56,958 Tenant Floor Scrubber 55,105 CAT 938 Loader 214,438 Sidewalk Maintainer 158,285 New Holland TV 145 Tractor (+ Boom mower) 139,364 Sweeper - Pick -up 184,155 Sweeper - Pick -up 184,155 Sweeper - Vacuum (Tymco 500) 243,936 Trailers Towmaster Trailer 7,634 Hot Patch Trailer 23,963 General Equipment Sweepster Billy Goat Blower Air Compressor Car Starting Unit Chop Saw Honda Generator Wkr Water Pump -3" 1,350 1 0 6,725 720 Year 226 1,876 27,168 27,168 27,168 1,266 1,443 2,523 DEPARTMENT: Streets Description 2014 2015 2016 2017 2018 Wkr Water Pump -2" 1,710 G Rupp Water Pump -6" 19,977 Line Striper 5,489 Chain Saw 640 Chain Saw 640 Chain Saw 640 Chain Saw 640 Pole Saw 650 806 Pole Saw 650 Weed Whip 570 Weed Whip 570 Weed Whip 706 Schoenstedt Magnetic Locator 1,091 Drive on Heavy Duty Vehicle Hoist 34,800 Mitre Band Saw 2,945 Commerical Car Vacuum 2,189 Workstation 2,080 Audio visual equipment 8,000 Miscellaneous equipment - 20,000 21,875 861,827 742,626 1,283,675 978,294 626,871 11 Year Description DEPARTMENT: Parks 2001 1/2 Ton 4x4 Pick -up 2002 3/4 Ton 4x4 Pick -up (mowing) 2005 3/4 Ton 4x4 Pick -up & V -Plow 2004 3/4 Ton 4x4 Pick -up & V -Plow w/lift- gate 2006 3/4 Ton 4x4 Pick -up & plow 2006 3/4 Ton 4x4 Pick -up & V -Plow 2007 3/4 Ton 4x4 Pick -up & V -Plow 3/4 Ton 4x4 Pick -up & Plow 2005 1 Ton 4x4 & Plow w/lift -gate 2001 1 Ton 4x4 2001 1 Ton 4x4 (chipper truck) 1999 1 Ton 4x4 77,680 1999 1 Ton 4x4 (water truck) 2000 1/2 Ton 4x2 Ext Cab Pick -up 1993 Water Truck 74,638 2003 Skid Loader 49,624 1992 JD 2355 Tractor 2002 Kawasaki 4x4 Mule 2000 Kromer Striper 2007 Kubota ATV 2006 Kromer Striper 2006 Push mower 2010 Riding mower w /snow blower 2007 Riding mower w /sweeper 2006 Riding mower w /snow blower 37,870 2006 Riding mower 95,960 2008 Riding mower 2011 Riding mower 2004 Trailer 2000 Tandem Trailer (mowers) 20' & 4' 2000 Tandem Trailer (mowers) 2004 Tandem Trailer (mowers) 2000 Tandem Trailer (skid steer) 10,398 1994 Single -axle Trailer 10,398 2007 Paint mixing station 2003 Bronco tiler 2000 Sod cutter 2005 Versa Vac 1998 Portable Chipper 53,322 2002 Generator (puppet wagon) 1,099 1995 Generator Generator 1987 Planer 2001 Rear Blade 2006 Flail mower 2007 Top dresser 1991 Seeder 1990 Drum aerator /corifier 2002 Aerovator 12 25,851 34,245 37,154 63,007 57,821 34,694 42,478 95,960 12,728 12,728 2,204 15,498 Year 2014 2015 2016 2017 2018 39,500 73,400 31,000 92,000 30,000 1,375 39,500 75,000 22,000 107,120 14,000 14,000 8,000 1,750 3,500 27,000 3,000 2,500 5,500 28,000 10,000 8,000 35,000 40,300 40,300 5,000 28,500 7,000 Turbine blower (skid mount) Post Auger & bits (skid loader attachment) DEPARTMENT: Parks Description 2014 2015 2016 2017 2018 2008 Sprayer (300 -gal) 15,000 Weed Whip 330 Weed Whip 330 Weed Whip 320 Weed Whip 320 Weed Whip 320 Weed Whip 320 Weed Whip 330 Weed Whip 320 Weed Whip 330 Split -shaft with sweeper/hedge/line trimmer 750 1997 Irrigator 12,010 1997 Irrigator 12,010 2008 Water Pump 775 2007 Water Pump 468 Pole Saw 870 Pole Saw 845 Chain Saw 360 Chain Saw 800 Chain Saw 1,200 Chain Saw 800 Chain Saw 800 1990 Mower 1,200 Hedge Trimmer 600 Hedge Trimmer 660 Blower 275 Blower 275 Riding Mower (blvd mower) 27,979 Riding Mower w /sweeper (blvd mower) 42,479 Land leveler 78' (skid loader attachment) 1,617 Soil Conditioner (skid loader attachment) 6,801 Trencher (skid loader attachment) 5,764 Compound miter saw 738 Bucket truck/tree trimming, signs, lights 100,000 Used Tree Spade 44" 20,000 Herbicide sprayer (skid mount for ProGator) 12,500 13 Year 8,000 4,000 Tandem trailer 12,000 Ice Resurfacer 10,300 Weed Whip 350 Weed Whip 350 Total 485,212 448,221 473,325 362,210 174,130 Description Server replacements Cardboard bailer Computer replacements Cash register replacements DEPARTMENT: Liquor 2014 2015 2016 2017 2018 8,400 7,833 Total 16,233 41,272 14 8,772 32,500 Year 2007 1/2 Ton 4x4 Pick -Up 2007 1/2 Ton 4x4 Pick -Up 2006 3/4 Ton 4x4 Pick -Up 2007 3/4 Ton 4x4 Pick -Up 2007 3/4 Ton 4x4 Pick -Up 2007 3/4 Ton 4x4 Pick -Up Description DEPARTMENT: Utility Year 2014 2015 2016 2017 2018 27,910 27,910 27,910 27,910 27,910 27,910 2002 3/4 Ton Pick -Up 28,424 2002 1 Ton 4x4 Truck w /plow 73,972 2007 1 Ton 4x4 Truck w /plow 63,748 2002 F -550 Truck - Utility Truck 81,967 Chevy 1/2 Ton Pick -Up Ford 1 Ton w /plow and liftgate GMC 3/4 Ton Pick -Up (w/liftgate) Sterling Vactor 388,502 Jetter truck 222,869 Quipnet Trailer Honda Portable Generator Honda Generator (mounted in unit 1012) Air Compressor 1,865 Wacker Compactor Weed Whip Manhole Fan 2,237 Trash pump 1,776 Toro Snowblower 824XL Wacker Cut Off Saw 01 Case Backhoe 144,810 Induction locator 4,100 Cutoff saw 1,157 Towed generator Generator 2,259 GPS Unit 5,128 5,128 Skid Steer - Tracked Server Replacement 8,400 Computer Replacements 5,750 Multi -Gas detector & test station 5,235 Vibratory rammer 4,470 Water Treatment Facility admin carpet 1/2 Ton Pickup (Environmental Resources) 24,979 GPS Unit (Environmental Resources) 2,740 Computer Replacements (Environmental Resources) 2,080 Total 388,147 237,097 418,649 121,433 134,088 15 708 49,650