Loading...
HomeMy WebLinkAbout3.A.2.b. Internal Service-Equipment Fund CITY OF SHAKOPEE 7/17/2012 Budget 2013 -10 Year Projection EQUIPMENT LIST 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Sources Departmental Charges * 620,000 632,000 645,000 658,000 671,000 685,000 698,000 712,000 712,000 712,000 Sale of Assets 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 Interest 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 75,000 Total Revenue 705,000 717,000 730,000 743,000 756,000 770,000 783,000 797,000 797,000 797,000 Uses Capital Equipment 1,075,000 1,587,000 904,000 1,135,000 1,215,000 1,338,000 757,000 603,000 927,000 967,000 Excess (Deficiency) of Sources over Uses (370,000) (870,000) (174,000) (392,000) (459,000) (568,000) 26,000 194,000 (130,000) (170,000) Anticipated Cash Position 12/31 $ 6,706,145 $ 5,836,145 $ 5,662,145 $ 5,270,145 $ 4,811,145 $ 4,243,145 $ 4,269,145 $ 4,463,145 $ 4,333,145 $ 5,830,000 * reflects a 2 % increase in departmental charges Estimated Cash Position 12/312012 $ 7,076,145 co CITY OF SHAKOPEE 7/17/2012 Budget 2013 - 10 Year Projection EQUIPMENT LIST 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 Police Marked Patrol Cars 7 $ --- `722 - 5 .7 000 7:$ . 920 -$' - -- r- c 7 - 0' 9 1 7-- 7 o 7f7.77§8666 11=--. f5000d7 7$7:772OTO 7 $77.72a -- , A..... ' - , .....k ?,..:....1.4.4. .4.4 ... c..4.:....... ..., --tit a ...... .c 4,71. . A. ;.: ',:,..Aiitn., ) - _ .,.. e... ..: .":4.3.,' k.1 ..: _4 , ..-.A...-- .e: 1...i.o.:-,.... > 24: [ ..;-..,"_•:.:07.: -, .... _`.. Administrative Car 27,000 28,000 29,000 4x4 Patrol Car Chiefs Car 26,000 Fire • ..." ..•-•.--- ,..:7.-7---,-..7.--:.--.---.---,.:-" ,- - ..." , "*.n:,Kfrr": ,,- 1."'" ":" r- r....."7 r 2 Trucks - Pumper ,...,....,, ..,,..",.,-,.... :•,,...;„<„,'...,....,:-_, -..„,...„,...-. 4...-....i.:_-„:....;::.......-; -- ,,,:.:-..,:.......,...;;.:.4:;;I:,....n r«.-;', ..........:44..... 0:1.::,i4 fe ..:::.%:.4:,-,-,:r./...:;:.;;;:;,....;:. Equipment/Rescue Truck (Step Van) 350,000 Airboat Trailer .......-...: -,. , _ 000 ..„ t:.;,-:.:• ,......i. ...:4411C0■61■ ...S .M.C.N.L ..0.1.4.....4 PK/ ...,.....,... , .....:114.:4+,,,:s:en,......:-.e, ..i:, .::.;ti,..•:.....4........:1......t.:1 J..i:......tir......-4.:4...........1:.::It :ri. ::a:•.a:4..,..4.......f.24......:■.--C '.4...i.....i....(•'•:':..v..::".■,..1: Aerial 1,200,000 .-•!-.---------.”-----Is ---:-:---,..--,--,-.-----,!--, ..---,... ,,,r,--,z; ,,.:1 - -n” , :-.•-•: - .. - , ...., , !..,, , , , .:• ,, :! ,, ,I.70"Kf.....-..11 :fiw. ,",...!•:".•',..„ ,,..,.,; One Ton 4x4 With Grass Pak 7:--.<-.. -...<;;,-.:•<:•..,....<.;.-,:....-.-.; ,:;.-' , •..•:` .....- :.i...,.;:-.,,.•,.....Yu. , .;:,. , .i.4.,-,..,•:,..,..c4..,-...;,-,-;., ?.:-...-...,;.:,,,, :":z-........, Chiefs Vehicle - 40,000 40,000 42,000 All terrain vehicle/Grass Pak . - - • - - ------.---- -,--------------- ------ --- • - - --„,,-, •.--,•-•.----------.... --r-----------,---. --7---..----1--. ----m--------7----- ---.-.1-----..”--,--A-r„-,--„,-,-_-, "...?"..-7----.-",--r-,5•- ,77--47.:-7-...7-1-1.:. •.- ..•.:„.•,..': ; - -:';-.,..,,,,: i ., ;•,;„,.:.--:.•.......--.;;:- - .:. -,',..,.-. -. :.,-,:!--„... ., ;„,"•:,,.-. ..,',...-„, ; ,, .....-,,:-...- ;„,-, .-..,....,<.- „<„,,:-.....',,,. , -...,: - -,,, ,,,.....„..,:: :.,_ .., .:_-_<,,,' k „._ -,-;,-,-..,9-u,uuu ,,,......„,.:.... , ,. . ..• -..;.-. - - ,-...,:„.•..,....•.,...,.., Building , - - '`.. !!..."!:."7"." , 7.!...... '' ... , "r ?'• -7 •^7 , " - ^"....r. ." ■:'"'"7""'r"":'''';;;7riiiii 1 ft Inspector Vehicle (s) -,.< "- ',„. - .--.....,;;, ..- -.....,:••.....; ,f, - -- :„.. ;,.."-:-....,:, -- .. ,, .-. „ - '' '.... .. •-•-:- •'*----,,,-••• : -;„.:..-,.: ...i... „... •----; • -; •:-. ',-,:;....1.- -.-.-:.:= ',,, „- ...,,,,.......,,,,,,,,,.- - ,:„• • .:,.,.:. - -..6o,uuu Engineering ,,,,..- -- - --- .............ft....,-......./...-1,-• ^ -.9.- vr:ti.o.. ., ... .•-, • ••,......rw Pickup Truck 4X4 ,....: :• :‘ '"r" ,ifej ..:.., ,:' ! :27;000 . .,..-..,-;.."--, . ...:' e.,... • ..:.' -30,000 ',-.., ...... " , _ ... v ...-.-.< . ' .-:: ., -6 .,•••.... ..... •<:-..- <;;,.- .,. : „:„.: -,:„. • . ,:,;,:'-'.....--:-•-_-•' -:,.....- -.--.;,-. --... - -- ',... • -- •-,' a Street ... 7 ^. - ...... ...."-,,. ,•,,,......^....",-,...?"" 71, ,,. . - ^ ,,, "••••• ,,,,,,, T .tor........e..r. - -r-v -.- -r-1-...!..r.,....e,...tv.v.7 7:‘,.................,...m.-a, :cett......r"..-:::•,.....pfre. -resty:o.......7,......,...rtr.r ........11...-6,9"-^ -, -,,---,-. Loader ;:... - „,...,, - ,„.,;__,,,„, .„,......,__.....,...,:,, ,..„...,..,--;_-.......,....,....,.,:<.,....-,_,...,....-_,........„, ..,....,...:•:,-...,. , _ P, 4 . . ,..4.i....,- Ls.......,.......1...41,..4,...A. is, _..e.o... 1.. 2. - ... Single Axle Dump Truck/Equip 420,000 460,000 240,000 250,000 520,000 530,000 540,000 Alley Grader 72...: ""Arr.""..1" nc-nnn ^7". 7.---r-- - - - vr. 777.''''''''' .7"." 77.7.''''.."'''''71 :"..''''''''',"!.”" '''.' ......,........,: 4. . ,...:40:•,,,,V":' .......,:......:,.....ettt: *Pi .{.0.... : nt: 21,;, ...1 . .....,...., a i4; : 4, .." .. .■•■• V. , ■ • ■Ii. .i. r . , 4.■ . ■ w .a ....... ■ 7 :A4: Ja,..,1 so.,..,.....-.4,4,.....v......v.:. .t :,.........:..,,.- .....,:.....te... Pick-up Truck 4x4 w/plow 27,000 40,000 43,000 45,000 AsphaltTruck ...... -........,...,.........,...e ,.....,..........---.....::.,_,.,„ ;:-.., -,..,-,......... .....,.._ 000 ,,,,..."...... .......,.....:„.......,....., ..............-_:,...........,,,....,.:„.: 1,,,,,,,,...14. 1/...,T AS.A.W.,......V.714 V. WAV .7.........n. 1,..,.....,.....- 24.......... ....,,,..... Snow Blower 100,000 SignTruck -...:.: :-.- , : .,•• ....... :',..;:•:..• ...- . : ",.. ..•... --..< :'. _,....-.,.. _"-:•.-:::., ....: - -;:. ; . : • f. .,.:-. -._,...„-.. -,.•.-. -.. - ,..- , ,:-..-... :_t;I:. „-:„:-.• , -, ._.„ ..: ,,,,-- „.. :- ; Park Large Mower 7 ' - ' 7 I666615 7 '''' - ' 77 : 77 '" 777 7.7.r.7. " ..7.. ' . . ' " *:7 77-'77 13b 7 toti -7-77-7 '.- 77-777: 066 7,77 =- 7 7. 7:-, ' , ...;: , ;: r7'''.7 . 7 ; 1 , ......-.4;... , .__ :..:...........,;.,..:.......;.,....-.. ;,...--4....;....:,.......ki :-..-_,.....;..-:::.-_,.....,:;...... :.....-.....,...,-,...-.;,_,,. ,. s:..4-,..:;z.,,,....:“.........:: : :;:....,:‘,....-. .._ ..-:„-,.....),-:„.4.-.-,..,. , . , ...,cyx,-.-,...:,........ Pick-up Truck 4x4/with plow 27,000 38,000 39,000 40,000 ----.---,--,-----;••-•<• -----•-•••••-- .--t•-•----• -------•!-----..:-..-9 ----•,..-----•:-:-•-•.----• :--•-,---,---",-,: ---- -r------r-r-:•!----1-•••-•:-----(1-- -7.- - - .!•'. '..Y.'•?..! Pick - up 2x4 1.5T. .:---..---,----...■ •'•■ •ri .... . • :■,. 4, • ■ i: / - ',..■ P ... .9 i'il; .......■...........,,,...... a., : 4 do...ii..,-.1....,...4. .. ,,. ._ .... -,...%.,;-. ,...,....--...■ 4..........0,,,,.........: ............f..-0-4,...., Garbage truck 85,000 ..," -- ---------,---- -,----------------,---- ------- ----.-,-,•,--------, - --- rr- 'Y. 7 , ....".."T"7","=' Chipper ...,.......;...........L.,:.:,,•;: ...,..,-.....,,•-• ...............;.-: L',.....-....-...,..Y.,u..u. 7.....,..-.. ,...,.::::,:li,.....-,..,.,L .....:..,,........,....,...:::: L, i::-...,,::.::,,-.;..;,;......: :-....-:,...::-..-:L.4..,-:::.. ::::- Hook Truck/equip 240,000 ---------.--- --- - - -- -------.----.---- .---.""...--,,--- .,.-r .....-..-....-•-•-■••:"..,--,---.. 17^-,--,...-: ........-....^.---r"."....,........, •••,--•••••••,“-.-7 - ......71•-,..".,--,...7■-•1,-,-71, ,-,:-.7:7■7.7,-......---n,-.7.7; • Aerator :-.;.'..;:. .... 31,000 ,:"......;...; : ' ;-'. - .---.:;. .,'; ... .:.;,..f..... ::...-- -..... 1,:',. - -. -, .- ,;-:, . ; - '- -..;.--: . ::::'......•-...,... f • ,'*.;::,.. • • ::.... ...,..,.. :::. ...• ........:47.- -7.4: '.::!.....',.. .....' ..`-: ::.,.' '....‘-';'-',...',' • . .. Recreation Ice Resurfacer ..•: ;.•-. '.,,....-- •.. ..'•-•••.:::.,.-::::. ,-...;.;,:'- .;.:-...::. -.." 1 ". ...-;,:-...*:* ". ;,. y..: ,.; <;• ::.;....;c.,-Z ....<±. Mini-van 38,000 Total Governmental Funds $ 1,075,000 $ 1,587,000 $ 904,000 $ 1,135,000 $ 1,215,000 $ 1,338,000 $ 757,000 $ 603,000 $ 927,000 $ 967,000 --.1 5 Year Plan 18 2013 Budget - Internal Service Fund Equipment Replacement Departmental Plan Police 2013 5 Patrol Cars ($225,000). Replace four patrol cars purchased in 2009; and one Sergeant's vehicle. 1 Chief's Vehicle ($26,000). Replace unit #033, 2003 Chevy Impala. 2014 2 Patrol Cars ($92,000). Replace two patrol cars purchased in 2010. 1 Administrative Car ($27,000). Replace unit #045 2004 Chev. Cavalier. 2015 3 Patrol Cars ($141,000). Replace three patrol cars purchased in 2011. 1 Patrol Vehicle 4x4 ($46,000). Replace unit #057, 2005 4x4 crew -cab pickup. 1 Administrative Car ($28,000). Replace unit #056, 2005 Chevy Impala. 2016 4 Patrol Cars ($192,000). Replace four patrol cars purchased in 2012. 1 Patrol Vehicle ($57,000). Replace unit #9115, purchased in 2011. 1 Administrative Car ($29,000). Replace unit #062, purchased in 2006. 2017 5 Patrol Cars ($240,000). Replace four patrol cars and one Sergeant's vehicle, purchased in 2013. Fire 2013 Airboat and Trailer ($165,000). Replacement for the 1999 airboat and trailer that is used for water recues, diving and all ice rescues. 2014 Aerial Truck ($1,200,000). Replace Aerial truck purchased in 1994. 2015 No anticipated purchases. 2016 Chief's Vehicle ($37,000). Replace Utility Truck purchased in 2006. Rescue Truck /Equipment ($350,000). To replace Rescue Unit #9511 a 1991 Chevy Step Van. 1 Ton 4x4 with Grass Pak ($90,000). Addition pending Station 3. 2017 Chief's Vehicle ($40,000). Replace 2007 Ford F150 4x4 Building Inspection 2013 1 Inspector Vehicle ($27,000). Replacement for unit #424, 2001 4x4 Chevy S10 2014 No anticipated purchases 2015 No anticipated purchases 2016 No anticipated purchases 2017 No anticipated purchases Engineering 2013 1 Inspector Truck ($27,000). Replacement for unit #306, 2001 4x4 Chevy extended cab. To be evaluated. 2014 No anticipated purchases 2015 1 Inspector Truck ($30,000). Replace unit #304, 2005 4x4 Chevy Colorado extended cab. 2016 No anticipated purchase. 2017 No anticipated purchase. 5 Year Plan 19 Street 2013 Pickup Truck 4x4 ($27,000). Replaces unit #125, 2000 Chevy 3500 4x4 with plow. Retire and retain for seasonal use. 2 Single Axle Dump Trucks ($420,000). Replace existing units #106 & 107, both 1998 Ford L8511 dump trucks. 2014 Pickup Truck 4x4 with Plow ($40,000). Replaces existing unit #163, 2002 Ford F350 4x4 truck. Alley Grader ($105,000). Replace existing unit #123, 1993 Gehl. 2015 2 Single Axle Dump Trucks ($460,000). Replace existing units #102 & #105, both 2000 Sterling dump trucks. 1 Asphalt Truck ($120,000). Replace unit #159, a 2000 International 4700 LP paving truck. 2016 1 Single Axel Dump Truck ($240,000). Replace existing unit #109, 2001 Sterling dump truck. 1 Snow Blower ($100,000).Replacing existing unit #118, 2001 Tenco Snow Blower. 2017 1 Single Axel Dump Truck ($250,000). Replace existing unit #101, 2002 Sterling dump truck. 1 Loader ($200,000). Replace 2002 Case 621D Loader with plow and wing. Park Maintenance 2013 1 Large Mower ($100,000). Addition to the fleet due to park construction. Mowing athletic fields, parks and drainage ways. 50% I.S. Fund, 50% Surface water. 1 Aerator ($31,000). Core aeration to alleviate turf compaction on heavily used athletic fields and parks. Pickup Truck 4x4 ($27,000). Replaces unit #161, 2001 Ford F350 4x4. Retain for seasonal use. 2014 Garbage Truck ($85,000). Replacement for unit 122, Isuzu Garbage Truck, acquired in 2000. To be evaluated at this time. 1 Truck Dual Wheel 2x4 ($38,000). Replace unit #114, Chevy C3500, acquired in 1993. 2015 1 Pickup Truck ($39,000). Replace unit #164, 2003 Ford F350 4x4 w /plow. 1 Brush Chipper ($40,000). Replace unit #130, 2000 Bandit Brush Chipper 250XP. 2016 1 Pickup Truck ($40,000). Replace unit #165, 2004 Ford F350 4x4 w /plow. 2017 1 Single Axle Plow /Hook Truck (240,000). Replaces unit #111, 2002 Sterling Acterra Dump /Hook truck. 1 Large Mower ($130,000). Replace unit #133, 2007 Toro Groundsmaster 580D. Recreation 2013 No Anticipated Purchases. 2014 No Anticipated Purchases. 2015 No Anticipated Purchases. 2016 No Anticipated Purchases. 2017 Ice Re- surfacer ($115,000). Replace existing unit purchases in 2007.