The URL can be used to link to this page

Home My WebLink About2. 2009-2018 Equipment List ;?, CITY OF SHAKO PEE Memorandum TO: Mayor and Council Mark McNeill, City Administrator FROM: Gregg Voxland, Finance Director SUBJ: 2009 - 2018 Equipment List DATE: July 22, 2008 Introduction & Background Attached for Council discussion is the list of requested capital equipment items for 2009 and projected items for 2010 - 2018 that are to be purchased from the Equipment Internal Service Fund or Enterprise funds. Also attached is the current equipment listing and rental rates charged for the equipment. The Equipment Fund is for funding larger items of mobile equipment which cost over $20,000 and last more than one year and are "mobile" meaning trucks, loaders, etc. The initial purpose of the fund was to smooth out spikes in the General Fund budget due to buying large items like fire trucks or loaders. Equipment for the Sewer and Storm Funds are not funded through the Equipment Internal Service Fund but are included in the list for Council review. Action Discuss and give staff direction. Gregg Voxland Finance Director 1 CITY OF SHAKOPEE Budget 2009 -10 Year Projection EQUIPMENT LIST 6QQ1! 2010 2011 2012 2013 2014 2015 2016 2017 2018 EQUIPMENT FUND Projected Cash Balance 1/1 $ 3,735,247 $ 4,476,017 $ 5,379,150 $ 6,352,417 $ 7,217,257 $ 7,964,038 $ 7,706.811 $ 8,564,264 $ 9,631,903 $ 10,341,136 Rentals 948,660 1,025,093 1,066,097 1,108,741 1,153,090 1,199,214 1,247,182 1,297,070 1,348,952 1,402,911 Sale of Assets 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 Interest 127,110 179,040 215,170 254,100 288,690 318,560 308,270 342,570 385,280 413,650 Total Revenue 1,087,770 1,216,133 1,293,267 1,374,841 1,453,780 1,529,774 1,567,452 1,651,640 1 ,746,232 1,828,561 Expenditul33s - open orders Expenditures per List 407,000 393.,000 405,000 600,000 802,000 1,882,000 710,000 584,000 1,037,000 2,229,000 Excess (Deficiency) 680,770 823,133 888,267 774,841 651,780 (352,226) 857,452 1,067,640 709,232 (400,439) Cash Balance Available 12/31 4,476,017 5,379,150 6,352,417 7,217,257 7,964,038 7,706,811 8,564,264 9,631,903 10,341,136 9,940,696 Cash Loan to Blocks 3 & 4 445,000 365,000 280,000 190,000 95,000 Fund Balance 12/31 $ 4,921,017 $ 5,744,150 $ 6,632,417 $ 7,407,257 $ 8,059,038 $ 7,706,811 $ 8,564,264 $ 9,631,903 $ 10,341,136 $ 9,940,696 Block 3 & 4 Note Payments $ 60,000 $ 80,000 $ 85,000 $ 90,000 $ 95,000 $ 95,000 'A~umulated depreciation 1/1/09 3,760,000 I 2009 I W,Q I 2011 I 2012 I 2013 I 2014 \ 2015 2016 2017 2018 Police Marked Patrol Cars " '" ~ ~, \\i ,,~, Administrative Car I I I 1 4x4 Patrol Car .. Chief's Car 30,000, Fire 2 Trucks - Pumper "'~,?l~QO;{jeo EquipmenVRescue Truck (Step Van) I I ~O~I Truck - Tanker Truck - Medium Re5cue(StepVan) I Airboat & Trailer Aerial I I 1 7(V\ 1\1\1\ Truck - Telesquirt . F ., " ,*, _~ ,.0,,~ One Ton 4x4 With Grass Pak I. 75,000 7_[1 I I Chief's Vehicle <,-,,"'" ,. Building I Inspector Vehicle (5) Engineering ,. Pickup Truck 4X4 " .,:]Il,~~ ., Street Loader ,~" '^ '. WTractor I 1 I 48,000 Single Axle Dump Truck/Equip ., Alley Grader I I I 75,000 Asphalt Roller Truck n. 4x2 I I I I Pick-up Truck 4x4 w/plow Asphalt Truck I I 130.000 I Snow Blower "'>" .. ~ '''. .. Park I I .. I Large Mower , Pick-up Truck 4x4/with plow I 3.11 I 39,0001 40,000 I Pick-up 2x4 1.5T. Bucket truck I I I ,I 1 I I Tractor .",',>, " ~' ... .' ,., Skid steer I I .. I *,":' I I I I Small mower ." ., '" Garbage truck I 1 I 85.000 I I Chipper t.~ . . .. Hook Truck 180,000 Recreation Fund lee Resurfacer Mini-van Total Governmental Funds $ 407,000 $ 393,000 $ 405,000 $ 600,000 $ 802,000 $ 1,882,000 $ 710,000 $ 584,000 $ 1,037,000 $ 2,229,000 Sewer Fund Low Pressure Jetter ., : Sewer Jetterlvac 250,000 I non truck - dump box/plow r Storm Drainage Fund I I I I I Large Tractor/mower r Street Sweeper 185.' I I I 195,000 I Side Broom non truck - dump box/plow I I I I I I Small Track hoe " ../:>. I Police I 2009: 5 Patrol Cars ($190,000). Replace four patrol cars purchased in 2005; and one Sergeant's vehicle. Staff is researching options for the most cost efficient and practical vehicle. 2010: 3 Patrol Cars ($122,000) . Replace two patrol cars purchased in 2006. Increase squad car fleet with one additional squad. 2011: 2 Patrol Cars ($78,000) . Replace two patrol cars purchased in 2007. 1 4x4 Patrol Veh~cle ($50,000) . Replace 4x4 vehicle purchased in 2006. This vehicle will be evaluated at this time. 2012: 5 Patrol Cars ($200,000) . Replace 5 Patrol Cars purchased in 2008. 2013: 4 Patrol Cars & 1 Unmarked Car ($200,000) . (Sgt's vehicle) . 1 Chief's Vehicle. ($30,000) . Replace 2003 Chev Impala. I Fire I 2009: Chief's Vehicle ($35,000) . This unit will replace the 2003 Dodge Ram 4X4 chiefs' truck. This unit will be used for the Assistant Chief's response to fire calls in the city. Retain for Fire Inspector. 2010: One Ton 4x4 with Grass pak ($75,000) . Replacement for the 1996 Chevy Pickup/grass pak. This unit is for fighting grass fires, towing the ice angel and hauling hoses and equipment. 2011: One Ton 4X4 with Grass pak ($75,000) . This unit will be an addition to the fleet for Station 3 (Southbridge Station). This unit is for fighting grass fires, towing the six wheeler and hauling hoses and equipment. Airboat and Trailer ($65,000) . Replacement for the 1999 airboat and trailer that is used for water rescues, diving and all ice rescues. 2012 : Step Van ($350,000) . Upgrade for future Fire rescue. 2013: No Anticipated Purchases. 5 I Building Inspection I 2009: 1 Inspector Vehicle ($22,000) . Replacement for unit #425, 1999 Ford Ranger. Retain for rec. to replace 1992 GMC Sonoma. Retain for Park to replace 1989 Chev 8-10. Staff is researching options for the most cost efficient and practical vehicle. 2010: 1 Inspector Vehicle ($23,000). Replacement for unit #421, 4x4 Ford Ranger, acquired in 2000. 2011: 1 Inspector Vehicle ($24,000) . Replacement for unit #424, 4x4 Chevy S10, acquired in 2001. 2012: 1 Inspector Vehicle ($25,000) . Replacement for unit #426, 4x4 GMC Sonoma, acquired in 2002. 2013: No Anticipated Purchases. I Engineering I 2009: No Purchases. 2010: No Anticipated Purchases. 2011: 2 Inspector Trucks ($48,000) . Replacement for units #303 & #306, 4x4 Chevy extended cabs. 2012: 1 Inspector Trucks ($25,000) . Replacement for unit #302, 4x4 GMC 4x4 extended. 2013: No Anticipated Purchases. I Street I 2009: Loader ($160,000) . Replace existing unit #119 1990 Case 621C. This unit is 19 years old and has 7,000 hours of operation. This unit is used for yard operations including the loading of trucks for snow removal operations and downtown clean-up. This unit's duties will be replaced by unit #121 and a new loader will be assigned unit #121's plowing responsibilities. 2010: 1 Ton pickup 4x4 with Plow ($35,000) . Replaces existing unit #125, Chev 3500 4x4 with plow, acquired in 2000. 2011: No Anticipated Purchases. 2012 : No Anticipated Purchases. 2013: Alley Grader ($75,000) . Replace existing unit #123, 1993 Gehl. Tractor ($48,000) . Replace Unit #131 2003 John Deere 4710. 2 Single Axle Dump Trucks ($325,000) . Replace existing units #106 & #107, both 1998 Ford L8511 dump trucks. 6 \ Park Maintenance I 2009: No Purchases. 2010: 1 Truck Dual Wheel 2x4 ($38,000) . Replace for unit #114, Chevy C3500, acquired in 1993. To be evaluated yearly. Large Mower ($100,000) . Replace unit #129, 2000 Toro Groundmaster 580D. 2011: 1 Ton pick Up Truck 4x4 wi th plow ($37,000) . Replace unit #161, 2001 Ford F350 4x4. 2012: No Anticipated Purchases. 2013 : Garbage Truck ($85,000) . Replacement for unit 122, Isuzu Garbage Truck, acquired in 2000. To be evaluated at this time. 1 pick Up Truck ($39,000). Replace unit #164, 2003 Ford F350 4x4 w/plow. I Recreation I 2009: No Purchases. 2010: No Anticipated Purchases. 2011: 1 Mini-van ($28,000) . Replace for unit #701, 2001 model. This unit will be evaluated at this time. 2012 : No Anticipated Purchases. 2013 ; No Anticipated Purchases. I Sewer Fund I 2009: No purchases. 2010: Sanitary Sewer Jetter/Vac ($250,000) . Replacement for unit #144, 1993 Ford High PSI Jetter. This unit will be evaluated at this time. combination unit may be required if NPDES storm water regulations require cleaning of storm sewer pipe. 1 Ton 4x4 Dual Wheel pickup/Dump Box/Plow ($55,000) . This is to replace existing unit #128 a 2000 Ford F550. 2011: No Anticipated purchases. 2012: No Anticipated purchases. 2013: No Anticipated purchases. 7 I Stor.m Drainage Fund I 2009: Street Sweeper ($185,000) . This is an addition to the fleet due to increased street miles. This will be a Regenerative Air Truck Mount Sweeper for increased efficiency in Fall sweeping of leaf debris and will reduce travel time to outer sub-divisions. 2010: No Anticipated purchases. S 2011: No Anticipated purchases. 2012: No Anticipated purchases. 2013 : Street Sweeper ($195,000) . Replace existing unit #151, 2003 Elgin Pelican. 8 IS Rent for 2009 I -I I I Est. Replace. -r I I i : I I ! Cost @ I 2008 I ANNUAL Monthly PWI L- -I Cost I Salvage I 4% Rentall Year Remaining I RENTAL Rental NumberiAsset # , Des<;rietion VIN I Deet. New/Used Value 10% Term I ACQuired Years , i RATE Rate , IA I B C 1 E --r- F H ! I J I K ! N I , I I 303 722 12001 S10 4X4 5527 ENGIN 19,000 1,500 25,100 10 2001 3 2.510 209 306 723 2 001 S10 4X4 7623 ENGIN 19,000 1,500 25,100 10 2001 3 2,510 209 302 869 2 002 GMC Sonoma 4X4 1764 ENGIN 18,000 1,500 23,700 10 2002 4 2,370 198 023 864 2 003 Ford Crown Vic(02) 4395 ENGIN 3,000 1,500 1,860 3 2006 1 620 52 3041 1088 2 005 Chev Colorado I 9523 ENGIN 15,700 1,500 20,480 10 2005 7 2,048 171 I "^' CL'~ i 74,700 96,240 10.058 838 95101 154 5961 Fire 156,465 4,000 465,394 20 1986 -2 1,551 9560 214 1298 Fire 107,735 4,000 319,206 20 1988 0 15960 1.330 95111 282 /C. 3501 Fire 35,000 3,000 102,000 20 1991 3 5,100 425 .9523 310 ' Fire nllmoer . .. 6396 Fire 227,676 4,000 679.027 20 1992 4 33,951 1 2,829 958( 383 ' SimorlDuolex - 0029 Fire 548,776 10,000 1,636,328 20 1994 I 6 , 81,816 6,818 9570 449 1 996 Chev Pickuo 5065 Fire 37,722 I 1,500 58,855 15 1996 3 I 3.924 327 9520' 535 1 998 Pierce Pumper 0653 Fire 340,227 4,000 1,016,681 20 1998 ! 10 I 50,834 4,236 9524 536 1 998 Pierce Pumper 0659 Fire 340,227 4,000 1,016,681 20 1998 10 50,834 4,236 9593 606 Ic e Angel Air Boat & Trailer 99trl Fire 50,541 3,000 98,082 10 1999 1 9,808 817 9590' 950 2 003 Dodae Ram 4X4 L_ 5624 Fire 19,000 2,000 24,600 10 2003 5 2,460 205 958fi 1 086 20 04 Zodiac Boat Motor & 1993 Trailer I F404 Fire 11,409 - 28,523 15 2005 12 1,902 158 1095 20 05 Spartan Gladiator Quint-~~-' ~=I.=- 2197 Fire 591,900 8,000 1,767,700 20 . 200B_+--_ 18 88,385 7,365 0'- 95211 1096 20 06 Spartan Pumper 2200 Fire 433,200 ' 4,000 1,295,600 20 2006 I 18 i 64,780 I 5,398 95121 1097 20 06 Spartan EquiptlRescue Truck T 2201 Fire 280,000 4,000 836,000 20 2006 18 41,800 3,483 9572' 1178 20 06 Ford F350 - Grass Rig ---1- 4794 Fire 60,000 , 4,000 92.000 15 2006 13 6,133 511 9592 1177 20 06 Ford F250 - Chiefs Rig 5047 Fire 27,200 . 2,000 36,080 10 2006 8 3,608 301 9514 1183 20 07 Spartan EQuip/Rescue Truck I 55234 Fire 300,800 8,000 894,400 20 2006 18 44,720 3,727 95911 2007 Ford F150 Crewcab Chiefs Rig ! 1908 Fire 30,000 2,000 40,000 10 2007 9 4,000 333 2008 Ford Expiorer - Chiefs Rig I 9004 Fire 30,000 2,000 40.000 10 2008 10 4,000 333 ~9~ 384 19 94 Chev 3/4T Suburban 4X4 + 9735 Insp't 8,000 1,500 7,460 3 2003 -2 25 TOTAL FIRE 3,635,877 10,454,616 I 532,930 44,411 155 534 19 981 Ton Chev Pickup withPIOW_--t_ 2344 Facilities 24,840 2,000 32,776 10 1998 0 I 3.278 273 702 309 19 92 GMC Sonoma PIU 7331 Facilities 10,834 1,000 14,168 10 1992 .6 Jail 47 304 380 19 94 Chev S10 PU J 3079 Facilities 10,231 1,500 12,824 10 1994 -4 43 167 1227 20 06 JD 1445 Mower, Blower, Broom 1f- 0949 Facilities 10,000 8,400 2,200 1.5 2005 -1.5 7 TOTAL Facilities 55,905 61,968 4,445 370 425 608 19 99 Ford Ranger i 7614 Insp't 17,104 1,500 22,446 10 1999 1 2,245 187 2011 657 20 00 Ford Ranger 4284 Insp't 17,100 1,500 22,440 10 2000 2 2,244 187 204 721 20 01 Chev S10 4X4 5549 Insp't 19,000 1,500 25,100 10 2001 3 1 2,510 209 206 868 20 02 GMC Sonoma 4X4 0042 Insp't 18,000 1,500 23,700 10 2002 4 I 2,370 198 'i''''T'^' 71,204 93,686 .. 781 196 251~ff~!I,!,{;,llllltlll~~ 3083 Park 9,061 1,000 11,685 10 1989 -9 39 156 283 9495 Park 9,571 1,500 11,899 10 1991 .7 40 114 338 7002 Park 25,799 2,500 33,618 10 1993 -5 112 139-2 381 11994 ." Toro 5400 0112 Park 11,467 1,000 17,347 15 1994 1 .1:156 96 157 604i}\'!.i!.lii~lijil 4713 Park 25,187 1,500 28,725 5 1999 -4 96 200, 533 3625 Park 17,631 1,500 23,183 10 1998 0 2.318 193 305 532 3626 Park 17,665 1,500 23,231 10 1998 0 2,323 194 122 665 'Garbaae 6308 Park 55,000 5,000 72,000 10 1999 1 7,200 600 129, 706 2000 Toro 5800 Mower 0131 Park 59,853 5,000 78,794 10 2000 2 7,879 657 130 663 2000 Bandit Brush Chipper 250XP 5313 Park 24,770 2,000 32,678 10 2000 2 3,268 272 161 733 2001 Ford F350 - 1 Ton w/Plow 9943 Park 22,790 2,500 29,406 10 2001 3 2,941 245 154 1273 2007 Melroe S-185 Hi-Flow 9725 Park 24,200 20,000 5,168 1 2007 0 5,168 431 135, 1277 2007 JD 1445 Mower , 70422 Park 19,000 16,800 3,340 1.5 2007 0.5 2,227 186 111' 727 2002 Sterling Acteera w/Hooklift Sys 3708 Park 102,735 4,000 160,376 15 2001 8 10.692 891 134 1228 2006 JD 5425 Tractor 3461 Park 37,300 30,500 9,038 1.5 2006 -0.5 30 143P 866 2002 Grace StripperlDriverlTrailer BA239 Park 12,120 800 16,168 10 2002 4 1.617 135 163 865 2002 Ford F350 4X4 W/Plow 1195 Park 25,295 2,500 32,913 10 2002 4 3,291 274 152 1275 2007 JD 1445 Mower _=-=- 0095 Park 20,000 16,250 4,950 1.5 2007 0.5 3,300 275 166' 1276 2007 Bobcat S300K Loader wlSB & For 5422 Park 32,000 28,750 4,530 1 2007 0 4,530 378 132M 1019 2004 LandPride Mower 6928 Park 11,620 - 16,268 10 2004 6 1,627 136 132 1274 2007 JD 5425 Tractor wlcab 4711 Park 38,000 31,500 8.780 1.5 2007 0.5 5,853 488 1651 1020 2004 Ford F350 4x4 w/plow 9469 Park 29,000 2,500 38,100 10 2004 6 810 318 167 1227 2006 JO 1445 Mower, Blower, Broom 1/ 0949 Park 10,000 8,400 2,200 1.5 2006 -0.5 7 139V 1083 2005 Taro Versa Vac 0217 Park 21,761 - 34,818 15 2005 12 193 145 1175 2006 Ford F550 4x2 cablchassis W/box 4274 Park 35,000 3,000 46,000 10 2006 8 383 131 ' 1272 2007 JD 5425 Tractor W/cab 5895 Park 39,000 32,250 9,090 1.5 2006 -0.5 30 1331 1279 2007 Toro 5800 0177 Park 81,700 8,000 106,380 10 2007 9 11 887 1741 1268 2007 Bobcat S-185 Skidloader , 9717 Park 27,000 ! 23,000 5,080 1 2007 I 0 5,080 423 New Bucket Truck Park 80,000 3,000 125,000 15 2008 15 8,333 694 I----Ont-- TOTAL PARK ---- 924,524 0 990,765 104,423 , 8,702 863 2003 Ford Crown Vic 4394 Comm Del 3,000 1,500 1,860 3 2007 2 620 52 ~-_:+- TOTAL COMM DEV I 3,000 1,860 620 52 I ----...-- 0151 - 860 2001 Ford Taurus 9603 Police 11 ,235 1,500 , 11,982 5 2002, -1 479 40 i 2002 Toyota Gamry i 4695 Police 10,000 1,500 i 9,700 3 2007 ! 2 3,233 269 i--._o.~3_,.__oo_954 12003 Impala 0716 Police i 17,500 i 1,500 ! 19,500 {t_~003 L ~f.;~~T- ~;~- ~__L._ 2004 Chev Cavalier ~~:==T 2184 Police 7,000 I '1,0001 7,120 4 2008 1 055r 1090 12005 Ford Crown Vic - Gray ---+ 7551 Police 24,7001 ~: 1,500-1 27.152 41 2005 I 1 .6,788 566 0511 1091 2005 Ford Crown Vic 7178 Police , 34,700 -+-- 1,500 : 38,752 . :1 2005 i 11 i 9,B8? : 807 054' 1092 12005 Ford Crown Vic ._--t 7179 Police 38,752 I 2005 I 0- 1 I 34,700 ! 1,500 I 1 9.688 I 807 9 7/??I?l1nR~.I1~ PM IS Rent for 2009 I __1--__ \ I: Est. Replace. I [ , ] I ___1' I I Cost @ [ 2008 i \ ANNUAL T Monthly PW I I I Cost I Salvage, 4% . Rental Year IRemalning L-1_ RENTAL T Rental Number Asset # Description ' VIN ' Dept. : New/Used : Value, 10% : Term Acauired Years RATE iRate IA .-r-=-:--B I -C=:-~! F i HI! J : ~ KIN 053 1093 '2005 Ford Crown Vic 7180: Police 34,700 1,500 i 38.752 4 2005 1 9,688 807 052 1094 2005 Ford Crown Vic 7181 Police 34,700 1,500 : 38,752 4 2005 1j 1 9.688 807 056 1089 2005 Chev Impala 0462 Police 16,800 1,500, 18.660 5 2005 21 3,732 311 057 1085 2005 Ford F350 4X4 Crew Cab : 8064 Police 32,260 3,000 48,616 15 2005 12! 3,241 270 062 1173 2006 Chev Impala I 2450 Police 18,950 1,500 I 21,240 5 2006 3 4,248 354 061 1172 2006 Chev Tahoe _ Marked 5855 Police 37,807 10,000T 33,856 4 2006 ' 2\ 8,464 705 063 1170 2006 Ford Crown Vic i 7321 Police 32,000 1,500 [ 35,620 4 2006 2\ 8,905 742 064 1171 2006 Ford Crown Vic 7322 Police 32,000 1,500 i 35,620 4 2006 21 ~ 8,905 742 072 1264 2007 Ford Crown Vic : 3077 Police 32,000 1,500 I 35,620 4 2007 3[ i 8,905 742 071 1265 2007 Ford Crown Vic i 3078 Police 32,000 1,500 I 35.620 4 2007 3! i 8,905 742 __ 081, !2008FordCrownVic ___.;.]~SliPolice 41,000 1,500. 46.060 4 2008 4:;- 11,515 960 082 12008 Ford Crown Vic i 3252lPolice 41,000 1,500 i 46,060 4 2008 41 11,515 960 083 !2008 Ford Crown Vic ! 3253 !Police 41,000 1,500 I 46,060 4 2008 41 [ 11,515 960 084 '2008 Ford Crown Vic ----., 3254 Police 41,000 1,500: 46,060 4 2008 ' -'li-. ____m 11.515 960 085 2008FordCrownVic ! 3250 I Police 41,000 1,5001 46,060 4 2008 41: 11,515 960 TOTAL POLICE I 648,052 I 725,614 I I 167,813 13,984 119 269 1990 Loader _ Case i 1442 Street 88,616 15,000 I 126,786 15 1990..'/iJ;;''',g;fim:1f~ 423 121 306 ,1992 Loader _ Case 621 : 775Z.Street 90,428 15,000 129,685 15 1992y})i'/!;'sl,X81;/Jr 432 ____ 123 343 i 1993 Alley Grader- Gehl747B _.~___~~~Street 50,295 5,00Q_'___ 85,531 20 1993- 1'4:277, 356 104 411 \1995 Ford LN 8000 Dump Truck i 2437 'Street 72,203 4,0001 111,525 15 1995 7,435 620 106 501 11998 Ford Single axle Dump Truck _-+ 0402 I Street 62,547 4,000 -I 96,075 15 1997 41 __ : 6,405 534 107 502 11998 Ford Single axle Dump Truck . 0403 Street 62,547 4,000 i 96,075 15 1997 4: 6.405 534 138 656 2000 Ranger ' 7936 Street 22,000 1,500 T 29,300 10 2000 2:: 2,930 244 105 667 2000 Sterling Dump Trk I 1918 Street 90,000 4,000 \ 140,000 15 2000 7 9,333 778 102 669 2000 Sterling Dump Trk 1919 Street 90,000 4,000 i 140,000 15 2000 71, 9.333 778 159 659 2000lntl4700LPPavingTrk 1937 Street 88,000 4,000T 136.800 15 2000 71 I 9,120 760 125 652 2000 GMC 3500 4x4 W/Plow & Lift i 9591 ,Street 31,000 2,500 , 40,900 10 2000 2' 4.090 341 013 726 2001 Ford Crown Vic _ Dk Blue 1038 Street 3,000 1,500 , 1,860 3 2005 0 I I 620 52 109 717 2001 Sterling Dump 3318 Street 95,000 4,000 [ 148,000 15 2001 8' i 9,867 822 118 7492001TencoTE172LMSnowBlower o Street 66,468 8,00~~ 90,373 12 2001 51 I 7,531 628 120 896 6210 Loader 3909 Street 136,000 15,000-,- 202.600 15 2002 91! 13,507 1,126 101 782 8314 Street 100,900 4,000 I 157,440 15 2002 91-1 10,496 875 131 1014 "nM.n ,."n. I w/cab 1211 Street 25,234 2,000 33,328 10 2003 51 .l- 3,333 278 164 951 2003 J=ord F350 4X4 w/plow 5015 Street 29,000 2,500 38.100 10 2003 511 3,810 318 110 953 2004SterlingDumpTruck 8146 Street 106,900 4,000 167,040 15 2003 10' --l 11,136 928 108 952 2004 Sterlino-Dump Truck 8147 Street 106,900 4,000 167,040 15 2003 10 I 11,136 928 168 1087 2005 Ford F550 _ Sion Truck 6625 Street 66,000 3,000 102,600 15 2005 12' 6,840 570 112 1084 2006 Sterling L8500 Dump Truck i 9090 Street 121,848 4,000 190,957 15 2005 12 12,730 1,061 113 1176 2006 Sterling L8500 Dump Truck \ 9099 Street 125,000 4,000 196,000 15 2006 13 13,067 1,089 117 1174 2007 Ford F550 4x2cab/chassis W/box! 4275 Street 35,000 3,000 46,000 10 2006 8 4,600 383 116 1266 2007 Sterling L8500 Plow/Hook Truck 1718 Street 150,000 4,000 236,000 15 2007 14 15,733 1,311 142 1278 2007 Case DV201 Roller WlTrailer 1844 Street 35,000 4,000 I 45,000 .10 2007 9 4.500 375 115 1267 2007 Sterling L8500 Dump Truck 1695 Street 130,500 4,000 204,800 '15 2007 14 13,653 1,138 2008 Ford F350 W/Plow 7204 Street 30,000 2,500 39,500 '10 2008 10' ._, 3,950 329 TOTAL STREET 2,110,386 3,199,314 216,096 18.008 870 170 1987 Chev Suburban 9645 Nat Res 4,000 1,500 3,300 5 2005 2 660 55 u_ TOTAL NAT RESOURCES 4,000 3,300 660 55 700 414 Ice Resurfacer 0 Rec Fund 45,000 2,000 61,000 10 1995 -3 203 701 7202001 Ford Windstar 3dr LX Minivan 3768 Rec Fund 19,533 1,500 25,846 10 2001 3 2585 215 ___._______ 1270 2007 Ice Resurfacer\i :'\ Kec Fund 85,000 4,000 ' 115,000 10 2006 8 11,500 958 I 'TOTAL REC. 149,533 I 201,846 16,525 1,377 I GRAND TOTAL 7,673,183 I 15,825,909 1,062,938 88,578 I r, , 10 "7J...",,,....,,(\O">,,.\'') nAA ~ WJ! w.1 ~ ~ A!!M ~ ~ m.z ~ Police .~:: ::..4QQ;QOO Marked Patrol Cars ;$.. : ;:1~;QOO :$}::;".144~qQQ: :~.:;:>;t~!),OoQ;t :$::" . 7\~Qo;QQO ;~:jf'" 14~.QQO ~:.: '114;OQQ .$;. .245,ooQ $. 235,000 .$.. 144.900 Administrative Car ;::.';":,.<;5P;909 I . ,:: . .' 4x4 Patrol Car :::::::j::: :'9(l,()QQ .:1: . . .' Chiefs Car 30,000 Fire .17.: ...... 2 Trucks - Pumper I: I 2,000;000 Equipment/Rescue Truck (Step Van) 350.0001 " . Truck - Tanker .. , ,: ': Truck - Medium Rescue(SlepVan) .... ''ij;: ", ' ';:, .; ":;', ,.....: . Airboat & Trailer ::';..,' ....:::::65,000 Aerial Y~~'()Q~ j, Truck - Telesquirt .:r~~I' c. One Ton 4x4 With Grass Pak ",' 75,000 , Chiefs Vehicle ;"':;::j:;..: '::W,OOO 37:.ooQ I ::40,Ooq , ' 40,000 Building 'j,::, ,"::21.POQ ::':::);jc:f'l2ti,OOO ' ,'. j I ' .:j,; Inspector Vehicle (s) ':;:;:j:',c '\22006 .:c ,:~,ppo '.7 " ',", ,yu, " Engineering ." , ::' ::::: ;2(;;ooQ : I:, ....' , .... Pickup Truck 4X4 ....::. ' ,,: )'~&.Oog .',', :':";:::j,;'~jooQ :'c Street :':: ;' :';::WQ;909 I.. 'j.j, ,180;909 I, " )', Loader : ',..,':" ,:, Tractor ,,;:;j:~1~:~ I; .:U2,909 Single Axle Dump Truck/Equip ':.c ';::'inO,OQQ 1<:',. ",' Alley Grader 75,000 :: 1<::... Asphalt Roller ,.:~mb~'(;,:;;:::{: Truck H. 4x2 7 , Pick-up Truck 4x4 w/plow r'j:;,j':::j:j::3ti;OQ,9 " .....,...',' .'. ,j'45;OPP Asphalt Truck 130.0001 Snow Blower 'j';; ',' .:r:;':j:j90jooQ . ' Park iT::; ;:;c:'10pj()Op , .c.; , : Large Mower ',r 40.000 ',' .115,000 Pick-up Truck 4x4/wilh plow ::;;:]"''(;;:?tl;909 37.000 3~\~00 ". Pick-up 2x4 1.5T. , ,,:';:::7 j:j.':j<:1;l;poQ Bucket truck '" ",' Tractor Skid steer Small mower ,.'7. 'J Garbage truck 85,0001 '."c:.'. Chipper 1i(ijHj~ikk~;~: :~Q~Q9Q :';:'.':: :::;'_: Hook Truck 180,000 Recreation Fund :: ::::j;115;OQO Ice Resurfacer Mini-van 28,000 Total Govemmental Funds $ 407 000 $ 393,000 $ 405 000 $ 600,000 $ 802,000 $ 1,882 000 $ 710 000 $ 564 000 $ 1 037 000 $ 2 229 000 Sewer Fund , , . ,,'7. Low Pressure Jetter Sewer Jelter/vac 250,000 Hon truck - dump box/plow Storm Drainage Fund Large Tractor/mower ,.:::;::J~C'~~' ',' i; :,:;; .'1~O909 12QQ00 Street Sweeper 195.000 Side Broom :.(j()!w Hon truck - dump box/plow 0 ~ Small Track hoe ;'. c.: .'. c1- ;$ p- O:> r- (0 CITY OF SHAKOPEE Budget 2009 . 10 Year Projection EQUIPMENT LIST 2009 w.l! 2011 2012 2013 2014 2015 2016 2017 2018 EQUIPMENT FUND Projected Cash Balance 1/1 $ 3,735,247 $ 4,476,017 $ 5,379,150 $ 6,352,417 $ 7,217,257 $ 7,964,038 $ 7,706,811 $ 8,564,264 $ 9,631,903 $ 10,341,136 Rentals 948,660 1,025,093 1,066,097 1,108,741 1,153,090 1,199,214 1,247,182 1,297,070 1,348,952 1,402,911 Sale of Assets 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 12,000 Interest 127,110 179,040 215,170 254,100 288,690 318,560 308,270 342,570 385,280 413,650 Total Revenue 1,087,770 1,216,133 1,293,267 1,374,841 1,453,780 1,529,774 1 ,567,452 1 ,651,640 1,746,232 1,828,561 Expenditures - open orders Expenditures per List 407,000 393,000 405,000 600,000 802,000 1,882,000 710,000 584,000 1,037,000 2,229,000 Excess (Deficiency) 680,770 823,133 888,267 774,841 651,780 (352,226) 857,452 1,067,640 709,232 (400,439) Cash Balance Available 12/31 4,476,017 5,379,150 6,352,417 7,217,257 7,964,038 7,706,811 8,564,264 9,631,903 10,341,135 9,940,696 Cash Loan to Blocks 3 & 4 445,000 365,000 280,000 190,000 95,000 Fund Balance 12/31 $ 4,921,017 $ 5,744,150 $ 6,632,417 $ 7,407,257 $ 8,059,038 $ 7,706,811 $ 8,564,264 $ 9,631 ,903 $ 10,341,136 $ 9,940,696 Block 3 & 4 Note Payments $ 60,000 $ 80,000 $ 85,000 $ 90,000 $ 95,000 $ 95,000 "Accumulated depreciation 1/1109 3,760,000 Interest is calculated @ a % of previous years ending balance. Estimated Rental Rates for years beyond 2009 are based on a projection using actual rental rate increases from prior years. (4.00%) Estimated Accumulated Depreciation is based on a projection using Accumulated Depreciation from prior years. (10.00%) The rental rates for 2009 are based on already calculated rental rates for the year. ~ 7/24/2008 . :J...-- 0/11 t.IA- /'L ~ Process of Equipment Request City of Shakopee 1. Fleet Manager emails departments for equipment requests for the next S years. S Year Capital Equipment List 2. Requests are compiled for discussion. Department Requests 3. Mechanics provide Vehicle/Equipment Evaluations. 4. City Administrator, Finance Director, Public Works Superintendent/Fleet Manager, & Public Works Director discuss requests for consideration and finalize the Equipment List. 5. Present to Council for Discussion and Approval. 10 Year IS Equipment 10 Year IS Equipment - - - - - -1- _ - - __,1OY.-PNo_ ~",,~,rl\''::' ... ... ... ... ... ... ... ... "" ... "-",,.~.~~..~, ...... "'.........,.""'''''''' ~~.("J:(t ~",.t.,."".,,'>_.,"" ........' ~"'''''''..''''''''',.. ~'o,,'''', u","_, ~ ,"",,,, t ,>.!~.,. . '''".W'-'",'."" ''''-'''''''''0.''''>'_' ,...,,"" """,.,u""":""^,,,,, . """"', wm ; .= ""'"-.,..,.,.""".,"''^",.,. ,.............. I..........., ...... ..: ......,. ~M'>.W_"''''. '" Police Dept. Police Dept. . 2009: S Patrol Cars ($ 190,000). Replace four patrol cars . 2011: 2 Patrol Cars ($ 78,000). Replace two patrol cars purchased in 200S; and one Sergeant's vehicle. purchased in 2007. Staff is researching options for the most cost 1 4x4 Patrol Vehicle ($50,000). Replace 4x4 efficient and practical vehicle. vehicle purchased in 2006. This vehicle will be evaluated at this time. . 2010: 3 Patrol Cars ($122.000). Replace two patrol cars . 2012: 5 Patrol Cars ($200,000). Replace 5 Patrol Cars purchased in 2006. Increase squad car fleet with purchased in 2008. one additional squad. , 2013: 5 Patrol Cars ($200,000). Replace four patrol cars purchased in 2009; and one Sergeant's vehicle. 2 Administrative Vehicles ($30,000). Replace 2 Chevrolet Impalas. 1 " 7/24/2008 . Fire Dept. Fire Dept. . 2011: One Ton 4X4 with Grass Pak ($75,000). This unit . 2009: Chiefs Vehicle ($ 3 5,000). This unit will will be an addition to the fleet for Station 3 replace the 2003 Dodge Ram 4X4 chiefs' (Southbridge Station). This unit is for fighting truck. This unit will be used for the Assistant grass fires, towing the six wheeler and hauling Chiefs response to fire calls in the city. hoses and equipment. Retain for Fire Inspector. Airboat and Trailer ($6S,OOO). Replacement for the 1 999 airboat and trailer that is used for water . 2010: One Ton 4x4with Grass Pak ($7S,OOO). rescues, diving and all ice rescues. Replacement for the 1 996 Chevy Pickup! grass pak. This unit is for fi9hting grass fires, towing . 2012: Step Van ($3S0,OOO). Upgrade for future Fire the ice angel and hauling hoses and equipment. rescue. . 2013: No Anticipated Purchases. Building Inspection Engineering . 2009: 1 Inspector Vehicle ($22,000). R?:lacement for unit . 2009: No Purchases. f~~~' d~~9S~~~':..~~nR:[~i~;~~i~a:J[ :;~e~Y:c".!'\a~~9 Chev 5-1 O. Staff is researchlne options for the most .2010: No Anticipated Purchases. cost efficient and practical ve ide. . 2010: 1 Inspector Vehicle ($23,000). Replacement for unit . 2011: 2 Inspector Trucks ($48,000). Replacement #421 ,4x4 Ford Ranger, acquired in 2000. for units #303 & #306, 1x4 Chevy extended . 2011: 1 Inspector Vehicle ($24,000). Replacement for unit cabs. #424, 4x4 Chevy 510, acquired in 2001. . 2012: 1 Inspector Vehicle ($25,000). R~'acement for unit . 2012: 1 Inspector Trucks ($25,000). Replacement #426, 4x4 GMC Sonoma, acquire in 2002, for unit #302, 4x1 GMC 1x4 extended. . 2013: No Anticipated Purchases. No Anticipated Purchases. Street Street . 2009: Loader ($160,000). Replace existing unit #11 9 . 2012: No Anticipated Purchases. 1 990 Case 621 C. This unit is 1 9 years old and has 7,000 hours of operation. This unit is used . 2013: Alley Grader ($75,000). Replace eXisting for yard operations including the loading of unit #1 23, 1993 Gehl. trucks for snow removal operations and downtown clean-up. This unit's duties will be replaced by unit #1 21 and a new loader will be Tractor ($48,000). Replace Unit #1 31 2003 John assigned unit #121's plowing responsibilities. Deere 4710. . 2010: 1 Ton Pickup4x4with Plow ($3S,OOO). Replaces 2 Single Axle Dump Trucks ($325,000). existing unit #125, Chev 3500 4x4 with plow, Replace existing units #1 06 & #1 07, both acquired in 2000. 1998 Ford L8511 dump trucks, . 2011: No Anticipated Purchases. 2 . 7/24/2008 '. Park Maintenance Park Maintenance . 2009: No Purchases. . 2012: No Anticipated Purchases. .2010: 1 Truck Dual Wheel2x4 ($38,000). Replace for unit #114, Chevy C3500, acquired in 1993, To be . 2013: Garbage Truck ($ 85,000). Replacement for evaluated yearly. unit 122, lsuzu Garbage Truck, acquired in 2000. To be evaluated at this time. Large Mower ($100,000). Replace unit #129, 2000 Toro Groundmaster 5800, 1 Pick Up Truck ($39,000). Replace unit #164,2003 Ford F350 4x4w/plow. . 2011: 1 Ton PickUp Truck 4x4 with plow ($37,000). Replace unit #161,2001 Ford F350 4x4. Recreation Sewer Fund . 2009: No purchases. . 2009: No Purchases. . 2010: Sanitary Sewer Jetter /Vac ($ 2 50,000). Replacement for unit #144, 1993 Ford Hi9h PSI . 2010: No Anticipated Purchases. Jetter. This unit will be evaluated at this time. Combination unit may be required if NPDES storm . 2011: 1 Mini-van ($28,000). Replace for unit #701, water regulations require cleaning of storm sewer 2001 model. This unit will be evaluated at pipe. this time, 1 Ton 4x4 Dual Wheel Truck/Dump Box/Plow . 2012: No Anticipated Purchases. ($55,000). This is to replace existin9 unit #128 a 2000 Ford F550. . 2013: No Anticipated Purchases. No Anticipated purchases. No Anticipated purchases. No Anticipated purchases. Storm Drainage Fund . 2009: Street Sweeper ($185,000). This is an addition to the fleet due to increased street miles. This will be a Regenerative Air Truck Mount Sweeper for increased efficiency in Fall sweepin9 of leaf debris and will reduce travel time to outer sub-divisions. . 2010: No Anticipated purchases. . 2011: No Anticipated purchases. . 2012: No Anticipated purchases. . 2013: Street Sweeper ($1 95,000), Replace existing unit #151,2003 Elgin Pelican. 3