Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Agenda Report - April 6, 2010 B-01 SM
AGENDA ITEM 13 1 dhCITY OF LODI COUNCIL COMMUNICATION W AGENDA TITLE: Receive Presentation Regarding Preliminary FY 2010/11 General Fund Budget Status MEETING DATE: April 6, 2010 PREPARED BY: Deputy City Manager RECOMMENDED ACTION: Receive presentation regarding preliminary FY 2010/11 General Fund budget status. BACKGROUND INFORMATION: Staff has prepared initial estimates for revenues and expenditures for the General Fund and is seeking direction regarding a number of issues. The General Fund estimates show that ongoing revenues will not fully cover ongoing expenditures. There is a projected shortfall in the General Fund. The City has long desired to properly fund maintenance of buildings, their major operating systems, information technology equipment, parks and other maintenance liabilities and would like to discuss options for funding. Staff has prepared information regarding the deferred maintenance needs for the above categories. The City will receive some one-time sales tax funding in FY 2010/11 related to the power island purchase for the Lodi Energy Center by the Northern California Power Agency (NCPA). NCPA has contracted with Siemens to build the power island equipment necessaryfor the operation of the Lodi Energy Center. The City was successful in getting a provision in the contract that specifies that the point of sale for the contract is the City of Lodi, resulting in all sales tax related to the purchase contract being reported to the City of Lodi. The receipt of the one-time windfall gives the City Council options it would not normally have. Staff will discuss the impact of the windfall on the FY 2010/11 budget. FISCAL IMPACT: Dependant upon Council direction. FUNDING AVAILABLE: JAfja C=4� Jordan Ayers Deputy City Manager APPROVED: l Blair g, ity Manager Preliminary FY 2010/11 General Fund Budget Status City Council April 6, 2010 Overview . Good News . Bad News • General Fund Budget Strategy • One -Time Revenue . Deferred Maintenance . Trade -Offs 2 Good News . Base General Fund revenue flat 3 Revenues . 2009/10 budget $39,,870,900* . 2010/11 estimate $40,136,850** . Net increase of $265,,950 *Includes LEC Sales Tax - $136,900 **Excludes LEC Sales Tax - $1,184,900 0 Revenues . New revenues . COPS Hiring Grant $370,000 . DIVCA Fees $85,000 . Other Revenue increases . Sales Tax - $133,000 . Card Room fees - $115,250 . Engineering Inspection fees - $113,000 . Police Reimbursements - $73,000 . SB 90 - $45,000 . Animal Licenses - $25,000 5 Revenues . Revenue decreases . One time PILOT re -capture — ($500,000) . Property Tax — ($166,520) . POST Reimbursements — ($30,000) . PILOT remains flat at $6.9M 0 Hidden Expenses . Property Tax Administration Fee - $290,000 . Up $80.,800 since 2007/08 . ERAF shift continues . Approximately $3.1M per year Bad News . Expenditure increases outside our control . PERS . Medical Insurance 0 Expenditures PERS cost increasing about 2% per year for the next few years . Estimated General Fund increase of $420,000 for 2010/11 . Total City PERS contribution for 2010/11 $7.2M YEAR Safety Misc 2010/11 34.02% 19.08% 2011/12 est. 36.3% 20.9% 2012/13 est. 38.3% 22.9% 9 Expenditures . Medical insurance costs estimated to increase by 6% . Estimated General Fund increase of $66,000 . Total Citywide medical contribution . $4.99M 10 Expenditures . 2009/10 budget $39,,870,900 . 2010/11 estimate $40,490,980 . Variance of $354,,130* * Excluding one-time revenues of $1,184,900 11 General Fund Budget Strategy • Use $354,130 of one-time sales tax revenue • Budget built on the assumption that all bargaining units will continue at the same level of contributions • Eliminate all non -reimbursed conference and training Savings of $112,060 for General Fund • Provide departments with approximately the same level of net general fund funding as prior year • Exploring another round of early retirement options to save money • Balanced budget 12 Employee Contributions 13 Waive Def. No No Salary Comp No CTO Holiday Vacation Total Est. Reduction Furlough Match Waive OT Cashout Cashout Cashout Savings Executive 96 hours Management 4.6% $93,766 Mid-Mgmt incl. 96 hours Confidential 4.6% $264,421 Maintenance & 48 hours Operators 2.3% $106,534 96 hours General Services 4.6% $3747625 96 hours Confidential GS 4.6% $14,234 Firefighters 2.5% $336,684 103 hours Fire Mid- Management 4.96% $86,937 58 hours Dispatchers 2.8% $1787493 48 hours ve, Police Officers 2.3% $638,335 108 hours Police Mid -M mt 5.2% $1837904 Reduced COLA from 24 hours IBEW 3.5% to 2% (1.15%) $50,147 13 Proposed Expenditures Department FY 2010/11 Appropriation FY 2009/10 Appropriation Difference City Attorney $468,150 $462,890 $5,260 City Clerk 606,100 546,606 59,494 City Manager 564,600 538,610 25,990 Economic Development 504,050 506,527 2,477 Fire 8,912,200 8,696,662 215,538 Internal Services 3,411,600 3,667,493 255,893 Non -Departmental 6,204,230 6,282,858 78,628 Parks 2,292,770 2,293,696 926 Police 15,817,590 14,955,058 862,532 Public Works 1,709,690 1,920,501 (210,811) Total Appropriation $40,490,980 $39,870,901 $620,079 Revenue* $40,136,850 $39,870,901 $265,949 Variance ($354,130) $0 ($354,130) * Excludes One-time Sales Tax Revenue 14 Summary Data Revenue* Expenditures Variance $40,136,850 $40,490,980 ($354,130) * Excludes One-time Sales Tax 15 One -Time Revenue • One-time sales tax revenue of $1,184,900 . Derived from NCPA power island purchase for the Lodi Energy Center 16 Use of One -Time Revenue . Close gap between revenue and expenditures ($354,130) . Begin to address deferred maintenance 17 Deferred Maintenance . Long list of deferred maintenance items . Roofs,, HVAC, Parks . Lack of funding for equipment replacement . IT, Vehicles . History of emergency replacement upon failure IN Emergency Replacements . 2007 forward . Police Channel One Replacement - $86,860 . City Hall &Carnegie Forum AC - $62,000 . Blakely Park Pool Heater - $26,200 . Blakely Park Pool Filter - $26,100 . Police AC repairs - $10,000 . Fire Station #4 Mold - $9,200 . Veteran's Plaza Fountain Pump - $1,000 . Street Sweeper fire - $247,000 . City Hall Chiller Compressor - $8,500 19 Roofs . Public works has assessed condition of roofs on City buildings . Estimated General Fund need of $132,000 for FY 2010/11 to adequately fund planned replacements . Total City-wide FY 2010/11 need - $297,000 20 HVAC Systems . Public works has assessed condition of HVAC Systems in City buildings . Estimated General Fund need of $289,000 for FY 2010/11 to adequately fund planned replacements . Total City-wide FY 2010/11 need - $414,500 21 Parks . Parks staff have is assessing condition of park structures, facilities and equipment . Roofs ($34,000) and HVAC ($51,500) included in estimated General Fund needs for FY 2010/11 to adequately fund planned replacements . Equipment replacement schedule for all park sites currently being evaluated 22 IT Equipment . 445 PC's over 4 years old . Estimated $1.1M to replace outdated equipment in FY 2010/11 23 Vehicles . City has a replacement fund, however, it is underfunded • Current balance - $2.1101,F232 . Needed balance - $4,064,890 (based on life of vehicles) . Shortfall - $1,963,658 24 Location §ulldln g-ENERAL FUND CAPITAL Civic Gonter City Hall CityHalllCamegie City Hail City HallControls Improv Camegle Forum Camegle Controls Improv Cameg€s Basement PublicSafety Building Fire Station #1 Rade (sewer)Rwm Radio Room Facilities Services Office Facilities Services Shop Finance Department M unlclpal Service Center Animal Services Bldg, Animal ServicesTrailer P. Mice Facility JaiUDispatch Station #2 Station #3 tANSIT il"odal Station Unil, Units Un Gourt UnK ComputerRoom Dispatch Bade up Units Units 1, 2, Depot Break Room101ock -lower (South An North Annex Intelpal 591vICeCOntdr TransIffleet Services Facility Radiant Fdocr Heat - I Units Internal or )[gM Future Yr l:E fnaw or Coat net 2009rlo10 I&L Quantity Size (tonal Comments Sandoe WEI tl Toa tiltw) Cost Pricul PY10I11 I Y 11112 FX 12M FY 151141 FY 1415 E]Cl5fill IFC1SL1i EY 17118 FY 18118 FY 1FY 211112111 Total = Replace :. - �� : 1 111 �o�� , 1 1„ ©�� ., �����������yy��■ ----------iJ�liuJ_- :. ��-�- 11 ' :11 © 1 , 1 -. 1 1 '. , I -, I 1 - 111 1 1' 1 -----�-lllllllllllll■ :. - � .1111 �o����©������e�e�■e�■■a�����®�� ©�'�� 11• ' 11 ', 111 ��������®' ®' ®' : <iLCll'1'J-- • : ©��0 11 • ', 11 , .I I �����C>•SWCi[PIaJ��CiS� l� � �-- .�_�_�_� ©�-� I 1 ', 1 1 -, 1 , 1 ©� 1 1•��'�,�1}1� . 1 1 1��!,��1.1j .y1�1,� 1 r� . 1 1 '�. 1 1j . 1 1 -y�lllllllllll■lllllllllllll■ -0 I -I ', I I . /1 ©l`iL1CiC�C�LSICI�I'iL7CICJ �{�1 l`>•L-7CICJC>•Idi`ICI I'�C'JL`2CJ�l`>•L�7 - • -`>�S�Jlllllllllll■lllllllllllll■ I' -, 11 -EW 111 . �©-� 11 '. 11 . 111 © ! 1 I -, YI 1 -, • 11 • 11 ', •, 1 -- 11 -. } 11 • 11 -. 111 111 -®-- ©-a 11• -. Ir.111 © .. .,., ., •.11 ', •11 !11 !11 !II •II '. •11 •11 111 -- � --�-- • �1- 11 FROM :��-0- '. II '. 111 ©�y�:y}.�a����T.)T}����}��'.�'' ICaR.Y:J•�l�C11J '. :: llllllllllllll■-- ' 1IM lllllllllll♦Cid'iI� 'A'A,+# R.. •:� ®L :lllllllllll■- ------------------- - ■��-o- . I, . 11.1 © 1 1 ---.--�-_-■ - ��' -�lllllllllll■ '. 11 111 ©C�It-G•Jr�IFC.•1l'if�. 1 7 �. ���•C''I��C`�"yJ������ GW !�.1 ----- �1- ----------- ---- ------- ----- -- ---- ---- ------- .11! '. 11 '. 111 0-----------®�- - - --- ----- ------------ - - ------ -- ----- ------- C:Wocumerds and SetsngeyayersU ocal SetsngsWemporary Internet FllesWLKI'Faclllses HVAC Roofs Replacement Plan. ds 1 04AM010 FadlMes HVAC Replacement Plan C9Documenls end SoW%sWyaslLocal SettlggsSTemporeryIntemet FIIes10LKlWadirdes HVAC Roofs ReplawnentPlan.xls 2 04AM010 Fadlitles HVAC Replacement Plan Pdodtp Index: H=High, M=Mad., PubEle works - Old MW shop 1 1 11 1 I 1 14 1'ZOu 14 7 2UU I L 1 S sw 11 41 jw I zo Juu 1-0.1 TOTALS S 2,00$MS S 474,504 $ 426,123 $ 429,166 $ 382,645 S 371,AN $ 33%W S 237,767 $ 165,745 $ 136,645 $ MAW S 72,874 S 3,695.776 GRAND TOTAL C:1Documents and Senngayaymll.ocel StA6ngslTompormy InWnBt FlleslOLKIWadllles I4VAC Roofs Replacement Manift 0410=10 ---- -------------- ---- PubEle works - Old MW shop 1 1 11 1 I 1 14 1'ZOu 14 7 2UU I L 1 S sw 11 41 jw I zo Juu 1-0.1 TOTALS S 2,00$MS S 474,504 $ 426,123 $ 429,166 $ 382,645 S 371,AN $ 33%W S 237,767 $ 165,745 $ 136,645 $ MAW S 72,874 S 3,695.776 GRAND TOTAL C:1Documents and Senngayaymll.ocel StA6ngslTompormy InWnBt FlleslOLKIWadllles I4VAC Roofs Replacement Manift 0410=10 F=FaW=Wigh, Lifespan: Single Ply = 20 yrs Asphalt Shingles = 25 yrs G=Gd, M=Med., Metal Roofs = 25 yrs Built Up Roofs = 25 yrs Fadllties Roof Re IaCernent Plan 1,E-='Ex-ce'llent I IL=Low IClayTlIe=25yrs Concrete Tile= 30yrs Quantity 200912010 Future Yr to Location Building Ilsalu Lim Condition %[ Cosf1SF Sri Pdo ll,[ FY 10!71 Eyjjlja EXI&O EX INJ EX IAU FY 151116 1 T FY 17118 FY 1811 FY 18120 FY 20121 Total Cost ROOF GENERAL FUND CAPITAL_ Civic Center Multi -Modal Station Depot Break Room/Clock Tower NorthAnnax Platform Walling Stations (four) Municipal Service Center TransitlFleat SePAGes Facltity OTHER FACILITIES Lodi station Parking Structure World of wonders ScienceMuseum WOW South (oval space) Leased Facilities: 100 E. Pine St. (LodiAdopta-Child) 2 East Lodi Ave. (Maple Square) Metal E20091 5.541 $ L4135 I$ City Hail Camegie Forum Roof Public Safety Building Main Rool 0!20021 Main Roof Perimeter & Rear poor Covers 22,856 I Fire Station Apparatus I �I 3 - —' Jail 2,20 ng e y Bike Cage Shed 3.721 $ Metal Canopy L Carport - - 2022123 FactlltiesServioes OlfioalShoplRadio Rm Carport & OtNcelShoplRadlo RM Gutters FinanceDepartment # Finance LOW Municipal ServiceCenter G 2002 Animal Services Bldg. 25169 Animal Servioes Trailer Police Facility 2022!23 FireStation#2 P Z FireStation #3 Apparatus M L.owerRoofs Fire Station #4 Multi -Modal Station Depot Break Room/Clock Tower NorthAnnax Platform Walling Stations (four) Municipal Service Center TransitlFleat SePAGes Facltity OTHER FACILITIES Lodi station Parking Structure World of wonders ScienceMuseum WOW South (oval space) Leased Facilities: 100 E. Pine St. (LodiAdopta-Child) 2 East Lodi Ave. (Maple Square) Metal E20091 5.541 $ L4135 I$ C:IDocuments and Settingsyayerstlocal Settingsk7emporary Internet Filas10LKITacfities HVAC Roofs Replacement Plan.xis 1 04/05M10 s 1"[Sin I PI 0!20021 3.7211 22,856 I L I �I 3 - —' 2022123 2,20 ng e y G 1 20021 3.721 $ 8,184 1 L I I $ - - 2022123 # 7,130 Built U G 2002 3.53 $ 25169 L $ 2022!23 1,674 Com Shi le P Z 3.09 $ 5,173 M $ 6,207 leased 13,277ISIngle Ply j F 1 IN61 3721$ 49.3901 M I # 9,5251 $ 9,525 I $ 9,525 I.$_ %525.1 $_..9,5251 $ 9,525 �;SZ81 $ 6,958 I $ 6.9591 $ 6.959 I $ @1559 $ 94,514 C:IDocuments and Settingsyayerstlocal Settingsk7emporary Internet Filas10LKITacfities HVAC Roofs Replacement Plan.xis 1 04/05M10 Localton B i+ l in irk & Rec Facilities P&R Administration Building PBRAnnex Building Repair Shop Building FieldHouse Lodi Look ChapmanRestroom/Goncesslon Softball Complex Concession Building Softball ComplexRestroom Building Zupo FieldConoession Building Zupo FieldRestroom Building Lawrence Park Restroom Building Hale Park MeetingRoomlRestroom Lodi Lake Discovery Center Lodi Lake Maintenance Office Lodi Lake Boat House Lodi Lake South Restroom Lodi Lake North Restroom Lodi Lake Mardenance Shop Emerson Park Restroom Legion Park Restroom/Lee Jones Bldg, Kofu ParkRestmomlKofu Building Salas Park Concession Building Salas Park Restroom Bullding Blakely PoolOiBce Katzekian Restmom Peterson Restroom Beckman Restroom Henry Glares Restroom utchins Street Square Crete Hall and west Lobbyarea Cottage Pisano Theater- Main Theater- Perimeteraround FineARs DressIVI-Ialls/Green Room Main Offioe Area Thomas Theater Thomas Lobby Main Lobby Fine Arts Building Auto Shop/Storage Camp Hutchins Kirst Hall Senior Center Metal Roof Senior Center Roof8Gartopfes UTILITY CAPITAL FUNDS unicipal Service Center EUD Building Index: P=Poor, F=Fair, Single Ply =20 yrs Asphalt SN r9les =25 yrs Roofs= 25yrs Built Up Roofs= 25yrs -ila=9,5vrst CnnrrrteTilP.=90vrs Quantity 1§9.w LM Condition 20,592 Concrete Tile F CostlSF 19791 200=010 6.82 $ Coat 140437 Priori M FY 10111 $ 27,085 FY 11112 $ 27.085 FY 121.13 $ 27,085 FY 1.3Lt4 $ 27085 FY 14115 $ 27,085 FY 15118 ��ff�(1 F�Y.170$ $ 27,085 Si'"::27065 X19787 19,7871$ FY 19120 FY 20121 19.787 -1 19;787 Future Yr to $ 3,434 Clay Tile F 1945 6.82 $ 23420 M $ 4 517 $ 4,517 $ 4,517 $ 4,517 $ 4,517 $ 4,517 :'St-7i'Ajtf j' z $ 3,300 $ 3,300 $ 3.300 14;3' . ' $ 44,817 15,150 Alumnium P 1980 4.30 $ 65,145 H $ 12,564 $ 12,564 $ 12,564 $ 12,564 $ 12,564 $ 12,564 ' $ 9,179 $ 9,179 $ 9,179 �. Ut :." $ 124,662 1,952 Alumn[um F 1962 4.30 $ 8,400 M $ 1,620 $ 1,620 $ 1,620 $ 1,620 $ 1,620 $ 1,620 ; z, $ 1,164 $ 1,184 $ 1,184 _'.-:Y' "_ $ 16,074 4,469 As hatt Shingle G 2008 3.09 $ 13,810 L $ 2,663 $ 2,663 $ 2,663 $ 2,663 $ 2,663 $ 2,663 :r°b $ 1,946 $ 1,946 $ 1,946 s . ..._ $ 26,427 1 008 Metal 528 Asphalt Shi F le P 2000 1970 5.54 $ 3.09 $ 5,600 1,632 L M $ $ 11080 315 $ 1,080 $ 315 $ $ 1,080 $15 $ $ 12080 „$,. 11080 315 $ 315 $ 1 1080 'WWAIM, $ $ 315 • . 'i $ 789 2301$ $ 789 230 $ 789 ' ',° ;= $ $ 230: r`;'= $ 10,716 3,123 826 Bulk Up P 1960 3.53 $ 2,210 H $ 426 $ 426 $ 426 $ 4261$ 426 $ 426 $ 311 $ 311 $ 311 4,229 $70 AsphattShingille F 1986 3.09 $ 1,762 M $ 340 $ 340 $ 340 $ 340 $ 340 1 $ 340 $ :.,{' ' $ 248 $ 248 $ 248 y5?5:f $ 3,372 488 Atumnlum F 1950 4.30 $ 2,100 M $ 405 $ 405 $ 405 $ 405 $ 4051$ 405 ' _.:. $ 296 $ 296 $ 296 :^:'> $ 4,015 1,024 Asphalt Shl le F 1986 3.09 $ 3,164 L $ 610 $ 610 $ 610 $ 610 $ 6101$ 610 is �, $ 446 $ 446 $ 446 s ; 8,066 228 Asphalt Shi le F 19951 3.09 $ 704 L $ 136 $ 136 $ 136 $ 136 $ 136 $ 136 i r^' 1'' $ 99 $ 99 r. , $ 99r $ 1,347 594 AS hall Shi le F 1989 3.09 $ 1,835 L $ 354 $ 354 $ $54 $ 354 $ 354 $ 354 ' $a_`::_ 4 " ' $ 259 $ 259 $ 259 .. $ 3,511 220 As haft Shingie F 1950 3.09 $ 680 M $ 131 1 $ 131 $ 131 $ 131 $ 131 $ 131w. .7:• $ 96 $ 96 $ 96 s. `.;';:11:; 9H; $ 1,301 621 ClayTile G 1995 6.82 $ 4,236 L $ 817 $ 817 $ 817 $ 817 $ 817 $ 817 a;' , $tT19 : $ 597 $ 597 $ 597 $ 1 z . $ 81106 70 Clay Tile G 1950 6.82 $ 478 L $ 92 $ 92 $ 92 $ 92 $ 92 $ 92 =S`� Fi $ 67 $ 67 $ 67 $ 915 494 Clay Tile F 1950 6.82 $ 3,370 M $ 650 $ 650 $ 650 $ 650 $ 650 $ 650 -' " -�, $ 475 $ 475 $ 475 a .::;'., 4' t $ 8,449 899 Clay Tile G 1991 6.82.$ 6,132 L $ 1,183 $ 1,183 $ 1,183 $ 1,183 $ 1,183 $ 1,183 c $ 864 $ 864 $ 864��i�, '' $ 11,734 1,395 Ctay Tile G 1999 6.82 $ 9,514 L $ 'I'm $ 11835 $ 11835 $ 1835 $ 1,835 $ 1,835 ':$', a $ 1,340 $ 1,340 $ 1,340 ;1' $ 18,206 312 Asphalt Shi le F 1991 3.09 $ 965 L $ 186 $ 186 $ 186 $ 186 $ 186 $ 186 :, ';A $ 136 $ 136 $ 136 ° .,::.. S 1,847 816 Metal E 1963!2007 5.54 $ 4,521 L $ 872 $ 872 $ 872 $ 872 $ 872 $ 872:^ $ 637 $ 637 $ 637 .4 -` ' ,: $ 8,651 1,568 fthalt le E 1950/2009 3.09 $ 4,845 L $ 934 $ 934 $ 9341S 934 $ 934 $ 934 "?H, S 683 $ 683 $ 683 W;j*Mil $ 9,271 462 Wood Shake P 1986 3.72 $ 1,719 M $ 332 $ 332 $ 332 $ 332 $ 332 $ 332 $ 242 $ 242 $ 242 _;€' S 8,289 775 Wood Shake P 1984 3.72 $ 2,283 L $ 440 $ 440 $ 440 $ 440 $ 440 $ 440 $ 322 $ 322 $ 322 ;; 0. S 4,369 324 Asphalt Shingle, P 1950 3.09.$ 11001 L $ 193 $ 193 $ 193 S 1931$ 193 $ -193 f :`-':: $ 141 $ 141 $ 141 =ci $ 1,916 496 Alumnlum E 2001 5.54 $ 2,748 L $ 530 $ 530 $ 530 $ 530 $ 530 $ $30 .; a $ 387 $ 367 $ 387 . '{,•_ i :. $ 5,259 660 Alumnium E 2000 5.54 $ 3,656 L $ 705 $ 705 $ 705 $ 705 $ 705 $ 705 a5 `.sa _i $ 515 $ 515 $ 515 ;3,..6 $ 61996 Alumnium E 5.54 L Alumnlum E 5.54 L 1305+Single Ply - " F 19981I 3.7211$ 49,123 + L +$ 7,921 �I $ 7,921 1$ 7,921 $ 7,921 $ 7,921 I $ 7,921 $ 7,921 $ 7.921 S 7 2f I I $ 71,285 In creta sf I In Crete sf $ $ 1 1 1I _ s $ 5,670 Single Ply F 199$ 3.72 $ 21,092 L $ 3,401 $ 3,401 $ 3,401 $ 3,401 $ 3,401 $ 3,401 $ 3,401 $ 3,401: `,,$'. ,1' $ 2,972 '; ;: ? $ 36,552 1,500 Single Ply F 1998 3.72 $ 51580 L $ 900 $ 900 $ 900 $ 900 $ 900 $ 900 $ 900 $ 900 786 ;. $ 8,870 Included $ $iio. $ 3,500 Single Ply F 1998 3.72 $ 13,020 L $ 2,099 $ 2,099 $ 2,099 $ 2,099 $ 2,099 $ 2,099 $ 2,099 $ 2,099 $;>,20119„ $ 1,834 tp= $ 22,863 in Fine Arts $ $ = ' $ In Fine Arts $ $ $ 2,880 SI le Ply F 1998 3.72 $ 10,714 L $ 1,727 $ 1,7271 $ 1,727 $ 11727 $ 1,727 $ 1,727 $ 1,727 $ 1,727 =5 -'': ` $ 1,599 s..:: $ 18,588 5200 Single Ply F 1998 3.72 $ 19,344 L $ 3,119 $ 3,119 $ 3,119 $ 3,119 $ 3,119 $ 3,119 $ 3,119 $ 3,119 a"s 9tt r. $ 2,725 N '; $ 33,522 5,3D0 Built U F 1996 3.53 $ 18,709 L $ 3,608 $ 3,608 $ 3,608 $ 5,608 $ 3.608 $ "3,608 $ 2,636 $ 30,530 3,400 Single Ply F 1998 3.72 $ 12,648 L $ 2,039 $ 2,039 $ 2,039 $ 2,039 $ 2,039 $ 2,039 $ 2,039 $ 2,039 $ 1,782E $ 21,918 3,100 Single Ply P 1988 3.72 $ 111,532 M $ 2,883 $ 2,883 $ 2,883 $ 2,883$ 1,859 $ 1,859 $ 11859 $ 1,825 z $ 25,102 12,056 Metal F 1989 5.54 $ 66,790 L $ 16,698 $ 16,698 $ 16,698 $ 16,698 ' .. $ 16,769 $ 10,769 $ 10,769 $ 9,410 $ 1145,31116 8,596 Single Ply P 1989 3.72 $ 31,977 tot $ 7,994 $ 7,994 $ 7994 $ 7,994 f:q„p" $ 5,156 $ 5,156 $ 5,156 £ $ 4,505 ,. F.. $ 69,608 7,898 Single Ply G 1119M 3.721 $_ 29381L L - L$_ 1 1 11 261 '($?"^:a4:'6i C:1Cocuments and Seitin9sNayer51Lo001 SettingslTemporary Internet FileMOLK1}facilkles WAC Roofs Replacement Plan.xfe 2 04105/2010 Location Building EUDAdministration EUDStoragetEquipment EUDVehicles Canopy Purchasing Warehouse ;ETS-WATER-WASTEWATER CAPITAL FUNDS Stough Old FleetServices Trailer !pal Service Center Public Works Administration Bldg. LockerRmAdditlon Streets 8 Water Sm. Sheds11,730 Sign Shop 8 Hydrant Shop Public Works -Trailer Old Fleet Shop 8 Fuel Island Canopy Shop Oils Storage Room Quantity 2009!2010 2,170Built U G 1995 3.53 $ 7,660 5,5811 Metal G 1969 5.54 $ 30,802 2,400 Metal G 1976 5.54 $ 13,296 13,371 Metal P 1969 5.54 $ 74,075 S 518 Built Up F $ $ 33,439 2020/21 $ 2024125 5,800 Single PlG 2000? 3.72 $ 21,57$ 1,344 Single Ply G 2004 3.72 $ 5,000 $1 Ie PI G 20007 3.72 $ 43,636 4,018 Si to PI G 2000? 3.72 $ 14,947 leased 2001 $ 6,788 SI to PI G 19957 3.72 $ 25,244 106 Metal G 19857 5.541$ 596 TOTALS 1$ 1,771,738 WLSIngle Ply= 20yrs AsphaltShinoes= 25yrs Roofs = 25 yrs Built Up Roofs= 25 yrs 'Ila = 2.5 vrs Cancrete Tile = 30 vm 290,678 1 $ 254,724 1 $ 200,335 $ 133,965 1 $ 111,350 IS 111,350 1 $ 102,145 I Future Yr to $ 33,8B3 $ 14,620 $ 88,890 ; 3 S $ 33,439 2020/21 $ 2024125 $ 87,628 2020121 $ 23,165 2020121 $ leased $ 32 818 $ 748 $ 1,823,363 1 GRAND TOTAL. C;Woouments and SetlingslJayerslLocal SetUngsWempomy Internet FNes10LK11Faci NI" HVAC Roofe Replw*mant Plen.As 04/05/2010 301Access Points ! 41 I 1 600 i S YEAR ASSET REPLACEMENT SCHEDULE 600 121; Hubs and Switches! Toga 's Date 412/10 I Est. Replacement Cost 4 YEAR OF CHANGEOVER 12100 lStart of Financial Year 10710112009 I i ;End of Financial Year '06/3012010 iI 20101 20115 20121 20131 20141 Quantity \ Item V Functional Area Date Purchased Estimated Life 2011 2012 2013 2014 2015 ears I 5 j jPCs and Servers 1[Spam filter i 51 $ 9,500 i � ! 138 PC 184 for Pp ?? $ 27,324 j $ 27,324 $ 27,324 i $ 27,324 1 $ 27,324 4 PC j 1936': 4j $ 990 ! 61PC 1997[ 41 10iPC 19981 4, $ 9,900 1 j 14;PC j 1999! 4 $ 13,860 14 PC E 2040! 4 $ 13,8601 i 281PC 20011 41S 27,720 1 60 PC ECIS Billinj@ifl �....... Permits Plus - 2002! 41 S 59,400 j 46' PC S 200,9001 2003 41 $ 45,540 1 29PC 20081I28441 I 20041 41$ 28,710 1 28:PC 2005'2 4 $ 27,720 E 71 PC j I 2006' 41 $ 70,290 461 PC 6 for PD 2007' 4; 45,540 331 PC I 2048 4 32,670 231 PC OSSI CAOIRMS S etems 2009 4? 22,770 8!PC I j 201014! i $ 7,920 21 Blade enclosures 2MV 2009; 41 22,000 j 1lUebertUPS i 20052 61 ! $ 7,000 5SAN devices I g 2009 4' I $ 80,000 ' 5. Servers ??, 41 No rFrl No rpl ; No rpl No rpl No rpl 6';Servers 12,00011 2002', 4 No rpl No II No rpl ; No rpl No rpl 11 Servers 2005 20031 4i No rpl No rpl 1 No rpt No rpil Norpl 31Servers 2004; 4! No rpl j No rpt I No rpl No rpl 1 No rpi 4 Servers II 20051 4' Nor No rpl I No rpl Na ryl No rpl 5!8ervers 2006; 4 No rpl I No rpl I No rpl No rpt I No rpI 6`8ervers2007; 'IBM 4 No rpI I No rpl No € :' No rpl 1 No rpl IjServers Fi nent 20071 4' $ 100,0001, 2 Servers I 2W8J C $ 11,W0 141Servers i 20093 4i $ 30,250 $ 30,250 11jServerS j 20101 41$ 30,250 $ 30,250 � i I !Network Devices j i I f [ 63 Various network devices 1 `Document camera i 1 61 18,900 18,9001 18,900 1 18,900 $ 18,900 41 Wireless P2P7 i .006 1 Core router ; 51 5€, 7,000 2 Core switch $_2 500 5i 10,000 301Access Points 41 6001 600 i 600 600 ' 600 121; Hubs and Switches! 4 12100 12100 12100' 12100 12 JQQ 431 Routers j 5! 1'Webfitter 5 $ 5,000! i 1[Spam filter 51 $ 9,500 1 I � I ':Major Licensed Software j D Edwards FRP system 1 I 000 ECIS Billinj@ifl �....... Permits Plus - ._.._1999 19971(hosted BI S 200,9001 J 1 Ca M;mnUpmpntq)4qtprn 20081I28441 MavguAe GIS system i 1998 14, 5 10.000 Pet tracking ! 20071 8 $20,000 OSSI CAOIRMS S etems 20091 8z I i $ 1,000,000 1SCADA FUD 2MV 8' $ 100,000 SCADA(White Slough) g iAslera ETL 20081 31S 12,00011 !SEQUELView oint 2005 81 FireView 20078 i $ 36 940 Telestaff 2008 gl1 An, non Fi nent 2 81 1$ 20.0001 i I ;CarnegieAudiolVide6PEG Equipment 1 i I ! 1 `Document camera i 20061 81 i $ 5,000 1 Ceiling MountedPpoector i 20081 51 $_2 500 1 AV Switchin and oontrol system i i 20061 8. 1 i I $ 15,000 liMain PAs stemam I 19891 101 $ 10,000 I I Microphones, speaker control system 1 19891 10$ 35,0001 1 I Camera (calor, pan. tilt. zoom) 20091 8 $ 1.300 1 21 Camera Evolor, pan, tilt. zoom ceilin ! j 20031 8€ $ 2,6001 1 Camera Control 1 2009; 10� $ 1,540 I 1L7VD HDMI Recorder/Player 1 2009 10 $ 200 1 - 1 Monitor BSW rack mount 4 screens I 0091 10' S 10! 500 1 llMonitor(color) _2009 20091 10 2M 1 Sound microphone mixer 20091 10' $ 15.000 1', Personalcomputer MS -Windows 20091 102$ 1,00D 1:17" Color Computer Monitor 10 $ 500 1' ATV Ph setockVi A uiator I 2ppg} 10V $ 5001 ! i iTeleco Equipment f i Ava alNort l t OM 5 cabinet Gom+muniGation Server.MBiDPBXtVoIP 1 1999: 10 $ 240 AvayalOcteLOvertu i Ava alNorfel Carrier Remotes PBX Cabinet lino C87000M 1999 1999! Ao $ 10? $ 6D,Onn I 20,000 1 j J �_ j Ava a1No tel Meridian Opt.11c-miniusmall PBX 2002? 10; i $ 20,000 AvayalNorte€Meridian Opt, 21CMediurn PBX 1993€ 10 165,0001 process of being rep]-edl- I5X24rielephon Ava alNortej Norstar IC30tele hone kU system I 10 IS 12,00011 !AvayalNortet Nomtar Modular ICSltelephone key system 2002; 101 '; $ 18,0001 1 Ava alNoriel Norstar8x24Efele hone key system 1 19931 10! 1$ 28,000 1 Ava alNortel NomWrIGSDtelephone kgysystem 1. 19991 10: 1$ 18,000 1 i IComp€ex PrinterTopier Equipment I € I I f I 1 KIP 3000 series JPWICD I 20071 7! 1 IS 22,000 11Canon IR 3025 Purchasina 20081 71 $ 4 20W 71 1 iKonica 7145 CD 2604` 71 1 $7 300 1 iCannon ima a PORGRAF iPF710 PW 2008 i $ 16,523 11KON copier IEUD 2008 P 2008; 7 ! $ 9,789 1' Cannon IR C5185I PW -MSC i 2008' 71 S 17,725 6€HP printers ISD 2006-2M:: 3$ 2,500 $ 5,000 1 $ 2,50D 1 $ 2.500. I i E f 'TOTALS $1,103,154 1 $1,070,7141 $164844 , $284,384 $2,012,307 VEHICLE REPLACEMENTWORKSHEET 2010 83 8Q -- Full FundWa 5 5 -- -_04--b-._ _'_6C_ Total Based Upon GEN GEN Sub- Vehicle/ In Sry In Sry Useful Purchase Replacement Elapsed Life Unfunded Class Class Equip ## Dept, Fund Year Manuf Model Description Mo Yr life Yrs Price $'s Allocated thru 6130/10 Amount 2 5 5 5 5 03-079 03-086_ COMM DEV COMM DEV CDD CDD 2002 2002 DODGE DODGE --- W -_.. - DAKOTA_ _ DAKOTA T PICKUP, 112 TON1 PICKUP, 112 TON --__...... _1 2002 _._...-2002 10 14 $17,2_59 - $17,25_9 $ 7,045.71 -$ _ 7,045.71 14 526.33 14,526.33 $ 7,480.61 $ 7,480.61 3 4 5 6 03-089 COMM DEV CDD 2002 DODGE - DAKOTA PICKUP, 112 TON - 1 2002 10 $17,259 $ - 7,045.71 - 14 526.33 $ 7,480.61 1 5 5 03-052 COMM DEV CDD 1997 DODGE INTREPID SEDAN, 4 DOOR - 9 ._... 1997 --- 1_0 -- $16,572 $ - - 6,765.25 16,572.00 $ 9,806.75 $441,519 $ 95,6_62.35 95 662.35 $ 0.00 COMMDEV Total _ _4 4 W - _ - 2004 PIERCE. QUANTAM -..----.._-_ _ $68,349 $ 27,902.38 _ $ 60,150.98 $ 32 248.59 78 - 6 6A 04-085 ENG GEN 1999 FORD F-150 PICKUP, 112 TON 8 1999 15 $23 478 $ 8,498.69 16,956.33 $ 8,457.64 76 6 6A 04-043 ENG GEN 2000 FORDF150 -- - - PICKUP, 112 TON 5 2000 15 $22,661 $ 8,202.95 15,2_33F2_3 $ 77 6 6A 04-060 ENG GEN 2002 CHEVROLET C1500 PICKUP, 112 TON -._,-- - 2 -2002 --.....95 $22,885 $ 8,284.03W12,713.89 2000 _7,030.28 $ 4,429.$6 79 5 5 04-090 ENG GEN 2000 HONDA CIVIC GX ISEDAN, 4 DOOR CNG 12 2000 10 $20,874 $ 7,556.08 - 19 830.30 $ 12 274.22 76 6 6B 04-013 ENG GEN2000 5 -- DODGE RAM 250 VAN 314 TON CNG 1 2001 15 $20,771 $ 7,518.80 13,039.57 $ 5,520.78 - $20 449 $ - 6,431.60 _20,062.00 20 449.00 $ 14,017.40 ENG Total 5 5 06-004 FIRE GEN 1997 CHEVROLET MONTE CARLO ..-_ _....-... SEDAN, 4 DOOR - Q -AA A&A 1997 _.. 10 83 8Q -- 5 10X - 5 5 -- -_04--b-._ _'_6C_ 04-080 04 047 FACILITIES FACILITIES ----__..__._.._.- GEN GEN 2001 2fl00 GMC HONDA SONOMA CIVIC GX -._...---._._._ PICKUP, 112 TON - - SEDAN, 4 DOOR CNG _�.. - -... 8 12 2002 2000 10 10 $16,023 $21,186 $ 5,792.00 $ 7,658.32 rrrr 12 551.35 20 126.70 ' $ 6,759.35 $ 12 468.38 82 6 --..._..._ 6C 49 _0_"4_04_8__"_'- FACILITIES --.._......_-.-....._.......-- GEN 1981 CHEVROLET - - - ._... - -.. C30 -. - - TRUCK, 1 TON FLATBED _ 1 - .._ 1981 - 15 _- $8 039 $ 2,905.94 - - ... 8,039.00 -_ -_r_w ._ -. $ 5,133.06 81 _ 6 6B 04 048 _FACILITIES - GEN 1986 DODGE 8250 -_..._.-.__._......., _.__-----..... VAN, 314 TON 8 ---_----- 1986 _... 15 $12,034 - .._..._..._�.. $ 4,350.05 _- 12,034.00 $ 7,683.95 91 92 10A 10A 10A 10A 02-102 02-103 PURCHASING PURCHASING GEN GEN 2003 1990 MITSUBISHI HYSTER FGC15K H100XL FORKLIFT FORKLIFT 3 10 2003 1990 20 20 w... ,�.,... $17,078 $32,172 w m=..,. ......., $ 6,021.00 $ 11,342.53 wmm_ ....,... ..vw 6190.78 31 635.80 w v...rv-.-...-r $ 169.77 $ 20,293.27 93 6 6B 02-105 PURCHASING GEN 1986 DODGE RAM 250 VAN, 314 TON 8 1986 15 $10,944 $ 3,858.41 10 944.00 $ 7,085.59 94 5 5 02-122 PURCHASING GEN 1998 PLYMOUTH VOYAGER VAN, MINI 1 1999 10 $16,800 $ 5,922.99 16,800.00 $ 10,877.01 D:1Budget 2010-11Wehicle ReplacementAllocations BASIS 1 JA Edits.xis 1 04/05/2010 rurcLnwainu I01al $76,994 $ 27144_.94 $ 65,570.58 $ 38 425.64 104 44 06-011 FIRE __. _-.........- . - - GEN 1994 - - HIGH TECH mm -----_.__ FIRE ENGINE _- ---....... ENGINE, FIRE 10 1994 25 $213,175 $ 67,047.64 133,589.67 3, $ 66,542,03 .03 2._. 11 4 4 06-023 FIRE GEN 1997 HITECH FT ENGINE, FIRE - _ 10 _.-_.. 1997 25 $257,000 ...... $ 80,831.44 _ 130 213.33 _ - $ 49 381.89 112 4 4 06-024 FIRE GEN 2004 PIERCE QUANTAMENGINE, FIRE 1 2005 $441,519 $ 95,6_62.35 95 662.35 $ 0.00 113 _4 4 06-030- FIRE - GEN 2004 PIERCE. QUANTAM -..----.._-_ ENGINE, FIRE ...._-___ .._.-.,._ 12 -2004 _25 - 25 $441,519 $ 97,134.08 $ -.._-0.00 114 4 4 06-031 _ FIRE - -GEN -1997 HITECH Fl- ENGINE, FIRE mm� - --- - 10 1997 25 _ - $257,000 $ 80,831.44 _ _97,134.08 - 130 213.33 $ 49,381.89 115 4 4 06-032 FIRE GEN 1976 VANPELT FIRE ENGINE ENGINE, FIRE 5 1972 25 $57,112 $ 57,112.00 57,112.00 $ - 102 7 10U 06-008 FIRE -- GEN _2000 FORD F450 PICKUP, 2_1/2 TON 12 2000 20 -- $48,626 _ $ 15,293.81 23 097.35 $ 7,803.54 95 5 5 06-001 FIRE GEN 1997 DODGE INTREPID SEDAN, 4 DOOR 9 1997 - 10 $20,062 $ - 6,309.88 $ 13 752.12 - 96 10- -- - 5 -- 06-002 FIREGEN 1995 FORD _ - CROWN VICTORIA -- SEDAN, 4 DOOR .- _....- 5 1995 10 - $20 449 $ - 6,431.60 _20,062.00 20 449.00 $ 14,017.40 98 5 5 06-004 FIRE GEN 1997 CHEVROLET MONTE CARLO ..-_ _....-... SEDAN, 4 DOOR - _.._-- 4 1997 _.. 10 - .. -. _._ $16,6_06 �..__.. - $_ -_ - 16,606.00 -- - - $ 11 383.09 99 5 5 06-005 - - FIRE GEN 1997 DODGE INTREPID - _- SEDAN, 4 DOOR _..�_..9 1997 -- - 10 - $20,062 _5,222.91 $ 6,309.88 13 374.67 $ 7,064.78 100 55 _I06-0_6 06-006 FIRE GEN 1997 DODGE INTREPID- SEDAN, 4 DOOR - 9 1997 10 -$20,062 $ __. 6>309.II8 -....____ 20,062.00 $ 13 752.12 97 10U 003 FIRE GEN 2003 FORD EXPEDITION SPORT VEHICLE 6 2003 10 $26,434 $ 8,943.04 19 903.80 $ 10,960.76 101 10U 10U 06-007 FIRE GEN 2002 FORD EXPEDITION XLT SUV, 4 DOOR 4X4 6 2002 10 $31,444 $ 9,889.74 25,155.20 $ 15 265.46 108 105 10S 06-015 FIRE GEN 2006 METRO UTILITY LIBERTY II TRAILER (S.C.B.A.) 7 2006 20 $68 OOD $ 13,316.67 13,316.67 $ 10.00 107 10S 10S 06-014 FIRE GEN 2005 WELLS CARGO X TRAILER, RESCUE 1 2005 20 $87,000 $ 23,562.50 23,562.50 $ - 106 10X 10S 06-013 FIRE GEN 2005 SURREY LTB TRAILER, SAFETY 1 2005 20 $6,200 $ 1,67917 1,679.17 $ X0.00) 116 7 10U fl6-433 FIRE GEN 1998 FREIGHTLINER FL70 TRUCK, 2 TON UTILITY 10 2002 20 $42,817 $ 13,466.77 16,413.18 $ 2,946.41 D:1Budget 2010-11Wehicle ReplacementAllocations BASIS 1 JA Edits.xis 1 04/05/2010 VEHICLE REPLACEMENTWORKSHEET 2010 120 121 10A 6 10A _6A - 04-062 04-122 FLEET FLEET_ FLT FLT 1996 1989 DAEWOO DODGE --- -- G308-2 D100 - FORKLIFT, H D PICKUP, 112 TON - 9 9 1996 19_89 Full Funding $22,097 $17,588$ $ 7,958.57 15 191.69 17,588.00 $ 7,233.12 $ 11,253.41 119 10X 6B 04-022 FLEET FLT 1989 DODGE RAM 350 Total Based Upon 1989 -- 15 $16,415 Sub- Vehicle/ $ 10 502.89 131 5 5 04 10-6 In Sry In Sry Useful Purchase Replacement Elapsed Life 4 DOOR Unfunded 2001 Class Class Equip # Dept. Fund Year Manuf Model Description Mo Yr life Yrs Price $'s Allocated thru 6/30/10 TOYOTA Amount 105 10T 10T 06-012 FIRE GEN 1989 EMERG-1 FIRE TRUCK TRUCK, FIRE 7 1990 25 $368,000 $ 135,284.84 293,173.33 $ 157,888.49 110 10X 10T 06-022 FIRE GEN 1967 GMC FIRE. TRUCK TRUCK, FIRE 1.0 1967 25 $56,000 $56,000.00 56 000.00 $ - 109 10T 10T 06-021 FIRE _ GEN GEN 2002 1995 AMERICAN LAFRANCE GMC W -_ QS -100 VANDURA 3500 — . .. TRUCK, QUINT TILLER FIRE �— __ VAN, HAZ MAT 5 5 2_002 _ 1995 _25 _ 20 _ $831,943 $75,000 $ 261,662.07 $ 23,588.94 268_,9_94.90 _ 56 562.50 + 2... $_ _ $ _7,332.84 32 973.56 103 -- - 7 - 10U _ 06-009 - FIRE _ 136 6 ___...__.__.._..........._._...... 6B 04-180 _ EIRE Tntal GEN 1987 FORD _ .. ----- CLUB CAIS _...__......_ __.... — VAN, 9 ._ . eo Ano non .d 4 A74 ann &"y ..._ _._ d 4 rIJ"b O12'7 AA &�_. Acn eec IJ 120 121 10A 6 10A _6A - 04-062 04-122 FLEET FLEET_ FLT FLT 1996 1989 DAEWOO DODGE --- -- G308-2 D100 - FORKLIFT, H D PICKUP, 112 TON - 9 9 1996 19_89 20 15 $22,097 $17,588$ $ 7,958.57 15 191.69 17,588.00 $ 7,233.12 $ 11,253.41 119 10X 6B 04-022 FLEET FLT 1989 DODGE RAM 350 ^- VAN, 1 TON - -9 1989 -- 15 $16,415 $ _..._......_6,334.5_9 5,912.11 16 415.00 $ 10 502.89 129 6 6A 04-102 MTR POOL GEN 1978 CHEVROLET C20 PICKUP, 314 TON _— 7 1978 - 15 $7,490 $ 2,697.64 7,490.00 $ 4,-79-2.3-6- 130 5 5 04-104 MTR POOL GEN 1997 CHEVROLET LUMINA -SEDAN, SEDAN, 4 DOOR 10 1997 10 $16,690 $ 0011.16 16,690.00 $ 10,678.84 131 5 5 04 10-6 MTR POOL GEN 2001 DODGE INTREPID 4 DOOR 7 2001 10 $18,082 $ 6,512.51 16123.12 $ 9,610.61 132 5 5 04-109 MTR POOL GEN 2000 TOYOTA CAMRY LE SEDAN, 4 DOOR CNG 9 2000 10 $24,954 $ 8,987.56 24,330.15 $ 15,342.59 133 5...,_._. .._..._5 04-145 - ---. MTR POOL ._ .....__......_...._ _....,_.. _ GEN 1992 _- -- CHEVROLET _.- ___._......_---------- S10 PICKUP, 112 TON EXTENDED 12 1991 10 $12,590 $ 4,534.48 12 590.00 $ 8,055.52 134 2 2 04-146 MTR POOL -- - ___.___._...__.... GEN 1998 CHEVROLET _- LUMINA _..................... _ SEDAN, 4 DOOR --- 4 -_-_-----_--i_._. 19_98 10 $19,194 _...__..._. ._ $ 6,913.01 ! __...._._.. 18,714.15 !.....__._.,.._._...,._. $ 11,801.14 135 5 5 04-147 MTR POOL GEN 1999 DODGE -- INTREPID SEDAN, 4 DOOR 9 2000 10 $17,096 -$ ..__ m 6,157.38 14,959.00 $W 8,801.62 136 6 ___...__.__.._..........._._...... 6B 04-180 _ MTR POOL --.--_ .__,_................. GEN 1987 FORD _ .. ----- CLUB CAIS _...__......_ __.... — VAN, 9 1987 15 $15,040'$ ! $ 5,416.88 15,040.00 $ 9,623.12 137 _ __....__. 5 5 _....— 04-181 _- -- - � MTR POOL ..._............. �_.... GEN 1999 DODGE INTREPID -----� _....._,._...._.._ SEDAN, 4 DOOR 9 — 2000 10 m $17,635 _m_._._........._.__.........._-- $ 6,351.51 _._. 17 194.13 $ 10 842.61 +...__...------- 138 5 5 -._5_.- 04-184 .._. MTR POOL GEN --GEN 1996 FORD -- _., _ CROWN VICTORIA SEDAN, 4 DOOR - _ _ 10 1996 10 $22 561 $ 8,125.69 _..!__.... �..-_...._...__............,...... $ 14,435.31 139 W.. 5........ 10C 04-E079 MTR POOL GEN -GEN 2001 TOYOTA RA V4 SUV, 4 DOOR ELEG m........_,... 8 _._. _ 2001 _ _ _ - 10 -- $17,685 ._,__..._.,_........._ $ 6,369.52 _22,561.00 - 15 621.75 $ 9,252.23 ............. - -- M i t< rwL t otai _ .. _ $189,017 $ 68,077.35 $ 181,313.29 $ ' 113,235.94 126 10.. B 16B MT -120` HUT ST SQ GEN 1997 TORO MOWER - 6 _ 1997 5 $7,057 $ 2,792.24 7,057.00 $ 4,264.76 127 6 10B 07-101 HUT ST SQ GEN 1987 DODGE RAM 150 PICKUP, 112 TON 7 1987 15 $12,698 $ 5,024.21 11-. - _... 12,698.00 $ 7,673.79 100 10C 11* HUT ST SQ GEN 1988 CUSHMAN -- -._. _ ---- _ .,-,.......,....._. SCOOTER, TURF 12 1988 10 $8,101 $ 3,205.32 8 101.00 - --- $ 4 895.68 125 10C 10C 16* HUT ST SQ GEN 1990 CUSHMAN SCOOTER, TURF 12 1990 10 $$,534 $ 3,376.64 $ 5,157.36 HUT ST SQ Total $36,390 -- $ 14,398,41 -----,534.00 _8,534A0 $ 36,39D 00 $ 21,991.59 140 10C 10C 19* Parks GEN _ 1992 CUSHMAN - - SCOOTER, TURF 11 1992 10 $11,009 $ 2,763.34 11,009.00 ..__: $ 8,245.66 141 10C 10C 22* Parks GEN 1997 JACOBSEN SCOOTER, TURF _ 9 1997 10 $15,000 $ - 3,765.11 15 000.00 $ 11 234.89 142 10C 10C 23* --.. Parks - -- - -- GEN 1997 - JACOBSEN - SCOOTER, TURF9 1997 _ 10 _ $15,000 $ - 3,765.19 15,000.00 $ 11,_234.89_ 143 10C 10C 25* Parks GEN 1997 JACOBSEN SCOOTER, TURF - - - - 9 1997 10 $150001'"', - 3,765.11 15 000.00 $ � _ 11 234.89 144 10C 10C 26* Parks_ --- - GEN -GEN 1998 JACOBSEN - SCOOTER, TURF 1 1999 10 $16,378 $ 4,110.99_ 16,378.00 $ 12,267A1 145 10C 10C _.. __.._ 28* -- --_. Parks _ _.__.... _ 1998 ---- JACOBSEN ---- -----_._.._..---------- SCOOTER, TURF _ .m__.._- -- 1 1999 Y- 10 $16,378 $ -- 4,110.99 16 378.00 $_... 12 267.01 12,267.01 10C 10C 29* Parks -- - GEN 2000 JACOBSEN _..._ - ._ SCOOTER, TURF_ -- 5 --._ 2000 --- 10 - $6 393 __. ..W_.. $ 1,604.69 _-------,__m__±_._._..� 6,393.00 ----- $ 4,788.31 147 10C 10C 30-* Parks GEN 2000 JACOBSEN SCOOTER, TURF _.__...... _..__ 5 2000 10 $8,587 $ 2,155.40 8,587.00 $ 6,431.60 148 10C _._.._... 10C _.................. 31* -3-2 Parks - - GEN _ 1998 JACOBSEN - - _............ TRUCK, TURF 6 2000 10 $16 450 $ 4,129.07 16,450.00 $ 12,320.93 149 106' 10C 32* Parks GEN 2001 JACOBSEN _.._..... TRUCK, TURF 5 -._._....... 20-01 10 __.. $17,812 _._............._......_..... -. $ 4,470.94 _ 16 179.23 $ 11 708.30 150 _... ......_... 10C 10C -- 33* —....__. Parks -- .,.. ---- GEN 2001 - JAGOBSEN __ ___ - UCK, TURF 5 2001 10 $17,812 $ 4,470.94 16,179.23 $ 11,708.30 GEN 2001JACOBSEN URF ........... UCK, TURF �TRUCK. 5 2001 10 $17,812 $ 4,470.94 16 179.23 $ 11,708.30 152 10C 10C 35* Parks GEN 2001 JACOBSEN TURF 5 2001 10 $17 723 $ 4,448.64 16,098.39 $ 11,649.79 D:IBudget 2010-11 Wehicle ReplacementAllocations BASIS 1 JA Edils.xts 2 04/05/2010 VEHICLE REPLACEMENT WORKSHEET 2010 181 - Full Funding 5 -- Total Based Upon GEN _..._. Sub- Vehicle/ In Sry In Sry Useful Purchase Replacement Elapsed Life Unfunded Class Class Equip # Dept. Fund Year Manuf Model Description Mo Yr life Yrs Price $'s Allocated thru 6130110 Amount 153 10C 10C 36* Parks -._...---.--- GEN 2003 JACOBSEN 07-014 - _......._._, TRUCK, TURF 7 200310 DODGE $18,948 $ 4,756.08 13 105.70 $ 8,349,62 156 1flM 1DM 1655 Parks GEN 1997 TORO - ..__ - SWEEPER, LEAF . _-- BACKHOE, MICRO -._.. 12 3 1997.....10 1986 7 $12,927 $25,000 $ 3,244,77 $ 8,065.83 12,927.00 25 000.00 + $ 9,682.23 $ 16 934.17 160 _ 10G 10G .--- ------------ BH -129* ------------------ -_.._ _ Parks GEN --- - - _ ..._ 1986 POWERFAB -- - 161 10A _... 10A FL -001" - Parks _ GEN 2002 YALE _-..._ - -� _ ._.._.... -- _ _....._...._..- __ ---- FORKLIFT ._. 5 2002 20 - $20,621 --__. $ 5,176.02 .-_ - 8,334.32 _-. $ 3,158.31 162 10C 10C - - - M1* Parks GEN 1995 MITSUBISHI TRUCK, TURF 4 1995 _..__._... 1D _.. $11,314 $ 2,839.89 __-- , _.......4..-._._ 11,314.00 11, 4....___ $ $,474.11 163 100 10C -- M2* --- Parks GEN 1995 MITSUBISHI - - TRUCK, TURF 4 -.._........._.._.._._._..- 1995 10 $11,314 _ $ 2,839.89 _. _ 11,314.00 .. __... _ ._ ..._..___. $ $,474.11 164 100 100 M3* Parks -- ._...... GEN 2002 WULING MTRS _._.___... - .,.....,._.....,..... __...__..._. - - .............._...._._-_�_ CUTIS 3 2002 _.._..._.._.-.-..__ 6 $10,853 _____....._.........__....._..._...__..___. $ 2,724.18 _ 9,04_4.17 $ 6 319.99 165 10C 10C M4* Parks - -- GEN - .........._............ 2002 - WULING MTRS ---- ----- _....._.....,.m.......... CUTIS _-- _ _ 4 - .............. 2002 .._ W- 6 $10,853 $ 2,724.18 - 9,044.17 ._...._...,._..._.......-._!_.------------ $ 6,319.99 166.____.._... - - 10B 108 MJ -003* ----- Parks ----._..._.._..._..-- GEN 1990 _ .._._ JACOBSEN --------- ---------- MOWER 3 -._ 1990 .___........ - 6 - $15,000 $ 3,765.11 ___..._. - 12,500.00 $ 8,734.89 167 1013 -- - -- 10B -- MJ -6288 Parks ..._.-. -- - GEN_ 2007 JACOBSEN MOWER 1 2003 6 $22,538 5,657.20 ..__.._...._.__..._._. _.._ 18,781.67 ...._-._... - ---- $ 13,124.47 168 1013 10B MJ -628D Parks GEN 2003 JACOBSEN MOWER--`-- ----- 1 2003 6 $18,792 _$ __.__---.....__...4,716.92 15,660.00 $ 10,943.08 169 1013 ---- 10B MJ -9016* Parks _.._ -- . GEN _. 1999 JACOBSEN - - - MOWER -.- -------- .. __. - 1999 6 $69,129 $ 17,351.91 57,607.64 $ 40,255.74 170 - 10B 1013 -- MJ -9016* ------ Parks ._...._.__... - GEN 2006 _.._.... JACOBSEN _ - --- MOWER 9 _...... 2006 __...... 6 $82,118 -----._,_.-_...__...... ..._ $ 20,612.19 . _.,..._. _ 51 323.75 , . -_._ . _.._ . $ 30 711.56 171 10B 10B MT -325* Parks GEN 1996 TORO _ -- MOWER ------------- 5 - -------- 1996 _-.._....._.. 6 $16,687 $ 4,188.55 ..-....._ _.._ 13 905.83 $ 9,717.28 179 6 6A 07-002 Parks GEN 1999 CHEVROLET SILVERADO 1500 PICKUP, 112 TON 5 1999 1 180 5 5 07-004 Parks GEN 2002 SATURN L200 SEDAN, 4 DOOR 2 2002 . 10 $19,464 $ 4,885.60 16,220.00 $ 11 334.40 182 6_ --6A-- 07-006 Parks _ GEN _ 2001 DODGE --- RAM 250OHD SLT _._.__..................-- PICKUP, 1/2 TON _.._._ _. 7 2001 15 $20,942 $ 5,256.59 12,448.86 $ 7,192.27 183 6 6A 07-008 Parks GEN 2008 CHEVROLET SILVERADO ------- PICKUP, 1/2 TO -� m _._...__.._...............-- ----._-__ _ _. _ _ 184 - 6 -------- 6A 07-009 Parks _m._,..._,_ .................. GEN 1999 FORD ---- _...._..._.,....... F-150 .. PICKUP, 112 TON 8 1999 15 $23,121 _.____m-._...._......_..._._.._ $ 5,803.53 ..............-----------.__-... 16,698.50 _-- $ 10,894.97 186 6 6D 07-018 -- Parks GEN m._._..._ .. ........... 2003 FREIGHTLINER -- FL60 -- _ TRUCK, CNG DUMP _ 12 ..._ ..__..._._...._._------ 2002 15 $93,393 $ 23,442.30 70 044.75 $ 46,602.45 188 6 6A 07-030 Parks GEN 1986 CHEVROLET 030 ------...._.- ....,...__..._._. PICKUP, 1 TON 1 _ 1986 -- 15 m $12,014 m _.......,.__....... $ 3,01_5.60 - 12,014.00 $ 8,998.40 190 6 6A 07-037 Parks GEN 2008 GMC SIERRA PICKUP, 112 TON 12 2009 _ 15 $15,951 $ 4,003.69 15,950.50 $ 11,946.81 191 --_-- 6 6A 07-038 _-. Parks _.._..._.._,.....-- --_ ._ GEN _ . 1996 DODGE . -- RAM 1500 PICKUP, 112 TON ._ _ _.--_---_-- 3 1997 15 $16,259 $ 4,081.12 14,362.12 $ 10,280.99 192 10G 10G 07-048 Parks GEN 2003 JOHN DEERE 110 BACKHOE, LOADER -__. 2 _..._-.._.,..,....-_ 2003 -.- 10 --_.---- $43,531 _- _ _ ...__ __ $ 10,926.59 _ ..__-_-.__.--- - 27,569.63 --.---------- $ 16,643.05 193 6 6C 07-069 Parks GEN 2001 GMC SIERRA TRUCK, FLATBED 12 2001 15 $28,277 $ 7,097.73 16,023.63 $ 8,925.91 194 - 6 _ 6A- 07-072 - Parks - - GEN 1991 -- DODGE - D250 PICKUP, 314 TON 6 1991 15 $22,745 $ 5,709.15 22,745.00 $ 17,035.85 195 - 6 6A 07-073 --- ParksGEN - -- - -- 2003 FORD - F150 .... PICKUP, 112 TON 4 2003 15 $20,192 --- _ $ 5,068.33 _.... 9,647.29 $ 4,578.96 197 - 6 -- -- 6C --- 07-086 Parks -. __._.._. GEN 1999 CHEVROLET - - - - 03500 _ --- _.. ._.,. PICKUP, 1 TON - ---- 8 - _ 1999 .. 15 $24,936 -- - $ 6,259.11 _._ .._.___. - _.. 18 009.33 --- . $ 11,750.22 198 6 6D 07-126 -. Parks GEN 1998 ._.__...._.. DODGE ------__,............._---_-- RAM 3500 - - - TRUCK, 1 TON DUMP - 5 - _ 1998 - - 15 - $28,920 ---- --- - - _ .....__..- $ 7,259.12 ._ 23,296.67 $ 16,037.54 199 10X 5 07-D015 ParksGEN_ - -- -- _ 1994 _PLYMOUTH - ACCLAIM --- _ _.___...._.-...-_ SEDAN, 4_D_OOR -----_._ 11 .__.__.._._ 1994 _-.-- 10 $10 794 - $ 2,709.37 W 10 794.00 -.� $ 8,084.63 200 10X 5 07-DO29 Parks GEN 1996 FORD CROWN VICTORIA SEDAN, 4 DOOR 7 1996 a 10 $22,575 -$-- 5,666.48 - - 22,575.00 $ 16,908.52 Parks Total - �97� Rn� It :; 9� 1RA99 R 777 7R9 5n: : ';5q3 ti[►9 91 181 - 5 - -- - 5 -- 07-005 Recreation GEN _..._. 2000 DODGE - - - - _ .__. CARAVAN -. _ ....-- VAN _-_.... _ 7 2001 10 $21,019 $ 5,886.85 1$,741.94 $ 12 855.09 185 5 5 07-014 - _......._._, Recreation _.... GEN 2001 DODGE DAKOTA --- --- PICKUP, 112 TON 7 ._...._ ---- 2001 - 10 $15,379 _......_.,..... $ 4,307.24 _ ... _. 13,712.94 $ 9,405.70 187 6 6B 07-022 Recreation GEN 2001 CHEVROLET ..._. G30 EXPRESS ..... _ ..........._......_....-- VAN -- .....,... 8 ._. 2000 15 $21,848 T.._.._._. _.__...__ ..._ $ 6,119.03 ......_. ................. .---- 14,322.58 - - $ 8,203.55 1$9 _5 5 07-035_ - Recreation GEN - 1989 DODGE _ _...._. CARAVAN VAN, MINI (TURBO) _..._m._.9 T1989 10 $15,438 $ 4,323.76 15,438.00: $ 11,114.24 196 5 5 07-079 Recreation GEN 1994 PLYMOUTH VOYAGER- -__ VAN-..MINL.......... - --..__.....8 --1995 10 $19,360 $ 5,422.21 19 360.00 $ 13 937.79 Recreation Total , . $93,0441 $ Tmm26,059.10 $T...__:.. 81,675.46: $ :. 55,516.36 201 L I qq_L 10C 124' POLICEGEN 2002 GO -4 PARKING ENFORCEMENT 1 2003 7 $23,2731 6,595.47 _ 23,273.00 $ 16,677.53 D:1Bedget 2010-111Vehicle Replacement Allocations BASIS 1 JA Edits.xls 3 04/05/2010 VEHICLE REPLACEMENTWORKSHEET 2010 D:1Budget 2010-111Vehicle Replacement Allocations BASIS 1 JA Edits.xls 4 04/05/2010 Full Funding Total Based Upon Sub- Vehicle/ In Sry In Sry Useful Purchase Replacement Elapsed Life Unfunded Class Class Equip # Dept. Fund Year Manuf Model Description Mo Yr life Yrs Price $'s Allocated thru 6/30/10 Amount 202 10S 10S 05-001 POLICE GEN 2002 EAGLE CCH TRAILER 12 2002 20 $170,375 $ 48,283.53 63,890.63 $ 15 607.10 204 -1 1 05-003- POLICE - - GEN2007 FORD CRWN VIC-PATROL SEDAN, 4 DOOR 5 2007 6 $35,175 $ 9,968.44_ 18,076.044 8,107.60 205 1 _ 1 05-005 POLICE GEN 2010 _ _ FORD CRWN VIC PATROL l SEDAN, 4 DOOR 12 2009 6 $23,198 _ $ 1,933.17 _ 1,933.17 $ (0.00) 206 1 1 05-008 POLICE GEN 2008 FORD CRWN VIC-PATROL SEDAN, 4 DOOR 5 20086 $34,518 $ 9,782.23 11,985.40 $ 2,203.16 207 1 1 05-009 POLICE GEN 2007 FORD ----- - CRWN VIC-PATROL SEDAN, 4 DOOR - - 4..._....-2007 6 $34,556 -$ --- 9,792.91 -- 18,237.69 8,444.78 208 1 1 05-010 POLICE GEN 2000 FORD CRWN VIC-PATROL SEDAN, 4 DOOR -10 _ 1999 6 $23,683 $ 6,711.66 23,683.00 -$ $ 16,971.34 209 1 1 05-012 POLICE GEN 2008 FORD CRWN_VIC-PATROL SEDAN, 4 DOOR 6 2008 6 $34,556 $ 9,792.91 11,518.54 $ 1,725.63 210 1 1 05-014 POLICE - GEN 2007 FORD - CRWN VIC-PATROL _..__...._.. ..- SEDAN, 4 DOOR - 4 2007 6 $34,556 $ 9,792.91 18,237.69 $ 8,444,7$ 211 1 - --......... 1 --- fl5-015 POLICE - GEN ..__,...._...__.. 2005 FORD CRWN VIC-PATROL _..,............... SEDAN, 4 DOOR - 8 2005 6 $27,889 $ 7,90_3.62 22,466.14 $ 14,562.52 212 1 1 05-016 POLICE GEN 2003 . ..... _.... FORD _ CRWN VIC-PATROL _ SEDAN, 4 DOOR _.__.._. _... 5 -- 2004 6 $28,734 -- -- $ 8,143.09 29,133.08 --- -- -- -- $ 20,989.99 213 - 1 ----- _----- 1 ---- 05-017 POLICE __ _..._......--- GEN 2005 FORD -__....._._....... CRWN VIC-PATROL SEDAN, 4 DOOR 9 2005 6 $27,904 $ 7,907.87 22,090.67 $ 14 182.80 +...� 214 1 1 05-018 ---- POLICE -- - --- - ---- - GEN --- 2005 _..._--- ---------- ..._.__ FORD ... _ -_---...-- CRWN VIC-PATROL _ -- SEDAN, 4 DOOR --- -- _- 7 2005 6 ------ -- $27,650 _,. $ 7,835.89 __. ._.. _._._.._,. _.,.,.... .,. 22,657.64 __....._.._,--- ,_._,.. ... _...... ,_.._. $ 14,821.75 215 215 _.._.......................... 1 1 -- 05-019 POLICE GEN 2008 FORD CRWN VIC-PATROL .... _- SEDAN, 4 DOOR - 7 ----.._.. - 2008 - - -- 6 $34,458 $ 9,765.13 --- 11,007.29 $ 1,242.16 216 1 1 �� 05-020 POLICE GEN 2005 FORD .......--_._._ CRWN VIC-PATROL _-- _._____... ._..._..__..... SEDAN, 4 DOOR - - - 7 2005 6 $27,650 $ 7,835.89 . ....... _._._..__._ 22,657.64 _.. _.._.._.._+__.. $ 14,821.75 217 1 - 1 05-021 POLICE _..____._...._._._ GEN 2009 FORD --- --_ .__._._.._.__.... .........._... CRWN VIC-PATROL ._.......__,_..,. _.._.._.....,...._ SEDAN, 4 DOOR ............ 2 ............... ............. 2009 ......... ---- - 6 $36,000 - ...__._._... $ 8,000.00 _,.. _ - - $ 000.00 --------- - $ �0.00A 218 1 1 05-022 POLICE GEN 2007 FORD ---- - -- CRWN VIC-PATROL SEDAN, 4 DOOR_ 7 2007 6 ---- -------------.____.__....__.m. $34,419 $ 9,754.05 ._._ 16,731.22 __.__-_ $ 6,977.17 219 1 1 05-024 POLICE -....__._._...._. GEN _`- 2008 FORD -- ---�_ CRWN VIC-PATROL SEDAN, 4 DOOR T - _...._ 6 2008 - 6 $33,822 $ 9,584.87 11 273.84 220 1 1 05-028 POLICE GEN 2010 mm FORD _......._..._._ ............................ -- CRWN VIC-PATROL -.-_.....__._ SEDAN, 4 DOOR -- ---------� . .._ _ __._...._ _...._....._._ _. .... 222 1 1 05-030 POLICEGEN _. 2004 FORD _... _ ._ . CRWN VIC-PATROL __-__ SEDAN, 4 DOOR 3 -------- 2004 ---- 6 $27,543 m_ _....___.__..._.._.........._.__...__....__.__.._.._._ $ 7,805.56 28,690.63 ......._._.___...._.....__...._ $ 20,885.06 223 1 1 05-032 POLICE -_ GEN 2009 FORD CRWN VIC-PATROL _.............. SEDAN, 4 DOOR 3 2009 6 $35,47_9 - $ 7,391.50 7,391 50 $ (0.00) 224 1 1 05-033 POLICE GEN 2008 FORD CRWN VIC-PATROL SEDAN, 4 DOOR 4 2008 6 $33,694 $ mmTmm 9,548.86 12,167.44 $ 2,618.58 225 1 1 _-__-- 05-034 -___---- POLICE ----. GEN 2005 --- FORD CRWN VIC-PATROL SEDAN, 4 DOOR 11 2006 6 $35,155 $ 9,962.77 20,995.35 $ 11,032.57 226 1 1 05-038 POLICE GEN 2007 __. ._. FORD ......... _ ...-- CRWN VIC-PATROL ----- _. _ SEDAN, 4 DOOR ._._, - - _ -- 4 - - -- 2007 - 6 $35,038 . -, $ 9,929.59 _ .. _,... _.._ ..... ............. . 18,492.23 $ 8,562.64 227 1 1 05-039 POLICE GEN 2004 FORD CRWN VIC-PATROL SEDAN, 4 DOOR 2 2004 6 $27,318 $ 7,741.80 27 318.00 $ 19 576.20 228 3 3 05-043 POLICE GEN 2006 HARLEY DAVIDSON FHLP- I MOTORCYCLE 3 2006 5 $18,705 $ 5,300.91 15,899.25 $ 10,598.34 229 - 3 -- 3 05-044 ------ POLICE --- - GEN _.._._ _.- 2006 HARLEY DAVIDSON FHLP- I MOTORCYCLE 3 2006 5 $17,315 $ 4,906.99 17,315.00 $ 12,408.01 230 3 3 05-047 POLICE GEN 2005 HARLEY DAVIDSON -- ------ FLHP-I ---.-._ .__..W.__..._ MOTORCYCLE . ............ . 1 ... --- 5 $24,445 S 6,92761 _,.._......,... ...__..__......_.._.......,.-..._.._.., 24,445.00 $ 17 517.39 2313 - ----_.._--- 3 -----_-- 05-048 - POLICE ---._. GEN _..._....._. 2005 HARLEY DAVIDSON FLHP-I MOTORCYCLE 2 _2005 2005 _ 5 $19,931 $ 5,648.36 19,931.00 $ 14,282.64 232 6 6A 05.050 POLICE GEN 2002 DODGE _-_ RAM 250OHD SILT PICKUP, 314 TON 9 2002 15 - ---, $34,226 --_.._._ $ 9,699.50 _.___..__._._ ._.___-_- ____.._ _ 17,683.43 _ _.. ...,.._........ ..... ._._,__........ $ 7,983.94 233 10X 6A 05-052 POLICE GEN 1995 DODGE DOKATA PICKUP, 112 TON 8 1995 15 $20,630 $ 5,846.45 20,40_0.78 $_ 14,554.33 234 10S 10S 05-055 POLICE GEN 1998 KUSTOM SIGNAL X TRAILER, RADAR 11 1999 20 $11,906 $ 3,374.11^ _.....-__ 6,300.26 $ mm 2,926.15 235 5 5 05-056 POLICE GEN 1991 DODGE CARGO VAN VAN 9 1991 10 $15,872 $ 15,032.02 15,872.00 $ 839.98 236 105 10S 05-058 POLICE GEN -2001 KUSTOM I TRAILER, RADAR 6 2001 20 $13,903 $ 3,940.05 6,256.35 $ 2,316.30 237 _ 6 6B 05-059 POLICE _.___._..._._,...W._...._. GEN 2005 FORD _................__._._.,._.,......_.__.__._., E450 ........_...__._ VAN, UNDERCOVER __..-,_......,.. W 7 2005 `_--- 15 $82,851 $ 23,479.61 27,156.72 $ 3,677.11 238 6 6B 05-063 POLICEGEN 2000 DODGE RAM 250 VAN, 314 TON CNG ---------------_.,..._... _.._..__.........._..._..,.__.._._._.,__......_.... _.,....._ .._...__.._.__ ..__..._....._ 239 105 10S 05-066 ---__._......_...___...-._..__......._.. POLICE GEN 2002 MIGHTY MOVER 31095-22 ......... TRAILER, DUI - - 7 2001 20 - - $23,898 _..._ ._... _ . $ 6,772.59 10,654.53 $ 3,881.94 240 5 - 5 -- 05-0_71 m.. POLICE ___......_,__._..._.._...-... GEN 1996 ._................_.........._....._......_..._.._-- FORD W CRWN VIC-ADMIN _...._._.._.._ SEDAN, 4 DOOR_ 10 1996 -- 10 $22,221 .__..__._.._........................_....._.__.._.....---.......____......._...._.........................._.._............................ $ 6,297.33 22,221.00 $ 15,923.67 241 2-- 2 05-072 POLICE _ .. GEN 2004 - CHEVROLET - _m _.,..__ ............._._._..._.........__...- IMPALA SEDAN, 4 DOOR-- ----- -- _ 12 2004 8 -$18 842 _.! .... $ - 5,339.74 _.__._._......._._.._-......_._......................_..._........................._.........._......_.........._......._._............__...._...._............ - 12 953.88 $ 7,614.14 D:1Budget 2010-111Vehicle Replacement Allocations BASIS 1 JA Edits.xls 4 04/05/2010 VEHICLE REPLACEMENT WORKSHEET 2010 Total Sub- Vehicle/ In Sry In Sry Useful Purchase Replacement Class Class Equip # Dept, Fund Year Manuf Model Description Mo Yr life Yrs Price $'s Allocated Full Funding Based Upon Elapsed Life thru 6/30/10 Unfunded Amount 242 243 ----- 2 2 2 2 05-073 05-074 -- POLICE POLICE GEN GEN 1999 1999 JEEP JEEP CHEROKEE CHEROKEE WAGON, 2 WHEEL DRIVE WAGON, TWO WHEEL DRIVE 6 6 1999 1999 8 8 $21,180 $21,619 $ 6,002.32 $ 6,126.73 21,180.00 21,619.00 $ 15,177.68 $ 15,492.27 -------- - 244 245 2 2 - 2 2 05-075 05-076 POLICE POLICE GEN GEN 1999PONTIAC 1999 .................._....,_,...,......_._.._......,_,.._.._..........._.-......._...,.._._-......----..._-- CHEVROLETASTRO GRAND PRIX GT COU -- _---_ - - -- - --- --- -- - - VAN --- 6 1_999 -- - 8 -- - - -- - $23,372 --.......-._._.........,._..._....._.__.._.. - ---- W..... $ 6,623.52 _ — - 23,372.00 - - -- $ 16,748.48 -_--- 246 2 2 05-077 POLICE GEN 2004 JEEP "..,.._..__,_,..,_......_............... _ _ GRAND CHEROKEE SPORT VEH, 4X4 12 _ 2004 8 $22,221 $ 6,297.33 --..._.._....._..,._..._....___.- -- 15,276.94 $ 8,979.60 247 2 2 05-078 POLICE GEN 2008 FORD CRWN VIC-ADMIN SEDAN, 4 DOOR 2 200_8 8 $25,826 $ 7,319.05 7,532.67 --$----5,331.58 $ 213.61 248 1 1 05-079 POLICE GEN 2005 FORD CRWN VIC-ADMIN SEDAN, 4 DOOR--- - -- -- 9 - 2005 - - 10 - $27,826 $ 7,885.77 13,217.35 $- 5,331.58 249 2 2 05-083 POLICE GEN 1997 CHEVROLET S-10 PICKUP, 1/2 TON 3 1997 8 $17,475 $ 4,952.34_ 17,475.00 $ 12,522.66 250 2 2 05-085 POLICE GEN 2004 FORD EXPLORER _ SPORT VEH, 2X2 1 2005 8 $22,221 $ 6,297.33 14,814.00 $ 8,516.67 251 252 2 2 2 2 05-086 05-087 POLICE POLICE GEN GEN 1998 ._. 1998 CHEVROLET - CHEVROLET_ LUMINA - -- -- - - - LUMINA SEDAN, 4 DOOR --- - - -- - SEDAN, 4 DOOR 4 4 1998 1998 8 8 $19,194 -- - $19,194 $ 5,439.50 -- --- $ 5,439.50 19,194.00 --- 19,1_94.00 $ 13,754.50 _ $ 13,754.50 253 254 5 1 5 1 05-090 05-091 POLICE POLICE GEN GEN 2000 2000 GMCSAFARI FORD CRWN VIC-ADMIN VAN, 8 PASSENGER SEDAN, 4 DOOR 8 8 2000 2000 10 6 $2'1,747 $23,704 $ 6,163.00 $ 6,717.61 21,384.55 23,704.00 $ 15,221.55 $ 16,986.39 255 -- 256 2 - - 2 2 2 05-092 05-093 POLICE - -- POLICE GEN GEN 2002 2002 FORDCRWN FORD VIC-ADMIN CRWN VIC-ADMIN SEDAN, 4 DOOR SEDAN, 4 DOOR 5 4 2003 2003 8 8 $25,603 $25,603 $ 7,255.78 $ 7,255.78 22,669.32 22,936.02 $ 15,413.55 $ 15,680.24 257 5 5 05-094- POLICE GEN 2004 FORD EXPEDITION SPORT VEH 8 2007 10 $24,000 $ 6,800.00 6,800.-00' $ (0.00) 258 5 5 05-095 POLICE GEN 2008 FORD CROWN VIC-ADMIN SEDAN, 4 DOOR 2 2008 10 $26,124 $ 6,095.68 6,095.69 $ 0.00 259 - 5 - - 5 - 05-096 POLICE _ GEN _ . 2008 _ _......._ FORD ....,._..,_..__-.._........................--- --- CROWN VIC -- - - -- SEDAN, 4 DOOR 2 2008 10 $25,714 $ 5,999.88 5 999.88 - - ...__........_....._._..,.......--I---.,-- $ (0.00 260 2 2 05-104 POLICE GEN 1998 CHEVROLET LUMINA SEDAN, 4 DOOR 4 1998 8 $19,194 $ 5,439.50 19,194.00 $ 13,754.50 261 5 5 05-109 POLICE GEN 2007 DODGE GRAND CARAVAN VAN 1 2008 10 $20,531 $ 4,961.66 4,961.66 $ 0.00 262 5 5 05-120 POLICE GEN 2004 DODGE CARAVAN VAN, MINI 1 2005 10 $22,363 $ 6,337.58 12,113.29 $ 5,775.72 263 5 5 05-121 POLICE GEN 2001 FORD WINDSTAR VAN, MINI 6 2001 10 $22,363 $ 6,337.58 20,126.70 $ 13,789.12 264 5 5 05-122 POLICE GEN 2002 DODGE CARAVAN VAN, MINI 1 2002 10 $20,275 $ 5,745.85 17,064.79 $ 11,318.95 270 10X 6B 05-D067 POLICE GEN 2002 CHEVROLET ASTRO VAN 3 2002 10 $2_6,303 $__ 7,454.15 21,699.98 $ 14,245.82 271 10X 5 05-D100 POLICE GEN 2005 CHEVROLET COLORADO _ PICKUP, 1/2 TON 10 _ 2005 _ 10 _ $16,551 $ 4,690.48 7,723.80 $ 3,033.32 272 10X 5 05-D101 POLICE GEN 1992 DODGE DOKATA PICKUP, 1/2 TON 12 1991 10 $_14,784 $__ 14,723.69 14,784.00 $ 60.31 273 i0X 5 05-D102 POLICE GEN 2005 FORD CROWN VICTORIA _ _ SEDAN, 4 DOOR 9 2006 10 $17,467 $ 4,950.03 6,550.07 $ 1,600.04 274 - i0X 5 05-D110 POLICE GEN 2003 CHEVROLET MALIBU SEDAN, 4 DOOR 7 2004 10 $12,122 $ 3,435.32 7,172.18 POLICE Total � --- — $1,907,605 $ 540,606.73 $ ° 1,150,044.93 _$ _3,736.8_6 $x`609,438.20 — — Grand Tota[ - - $6597$;2$1 $ :2,107;231.99 $ 4,064,890.82 $ 1;963,65$.83 D:IBudget 2010-111Vehicle ReplacementAllocations BASIS 1 JA Edits.xis 5 04/05/2010