Loading...
2020-30 - RTOWN OF PROSPER:  REPLACEMENT BUDGETNon‐Emergency ResponseDepartmentOld Vehicle #Current Vehicle InformationRequested Replacement CategoryEFM Quote #Recommended ReplacementLights Tool Box Goose Nk MirrorsLinerCuston AME*Veh Price (incl AME) Mo Mgmt Fee Mo Maint Chg Annual SpendBuilding Inspections41012013 CHEVROLET 1500 SILVERADO 2WD V6 REG CAB 4.3L W/T1/2 Ton Pickup Reg 4x2 4623160 2020 Chevrolet Silverado 1500 Double Cab WT 4x2 8 ft bedX $25,841.58 $25.84 $36.23 $744.84Park Operations62112013 FORD F150 2WD V6 FFV REG CAB 3.7L XL1/2 Ton Pickup Reg 4x2 4623167 2020 Chevrolet Silverado 1500 Double Cab WT 4x2 8 ft bed X X X $28,663.58 $28.67 $36.23 $778.80Public Works - Water52042013 CHEVROLET 2500HD SILVERADO 4WD V8 FFV EXT CAB 6.0L W/T3/4 Ton Pickup Ext 4x446234452020 Chevrolet Silverado 2500 Double Cab WT 4x4 8ft box X X $36,311.73$36.31$38.23$894.48Public Works - Water5208 2009 FORD F-450 SUPER CAB XL 4x4 CHASSISMedium Duty Chassis 4x4 4623592**2020 Ford F‐450 XL Super Cab 4x2 168 in WB DRW X X Custom Flat Bed $57,304.16 $57.31 $50.00 $1,287.72Public Works - Wastewater5304 2013 FORD F-450 REG CAB XL 4x2 CHASSISMedium Duty Chassis 4x2 4623592**2020 Ford F‐450 XL Super Cab 4x2 168 in WB DRW X X Custom Flat Bed $57,304.16 $57.31 $50.00 $1,287.72Construction Inspections59012013 CHEVROLET 2500HD SILVERADO 4WD V8 FFV EXT CAB 6.0L W/T3/4 Ton Pickup Ext 4x446234752020 Chevrolet Silverado 2500 Double Cab WT 4x4 6.75ft box X X X Step Up Bar $37,608.92 $37.62 $38.23 $910.202021 REPLACEMENT BUDGET TOTALS$243,034.13 $2,916.72 $2,987.04 $5,903.76Emergency ResponseDepartmentOld Vehicle #Current Vehicle InformationRequested Replacement CategoryEFM Quote #Recommended ReplacementLights Tool Box Goose Nk MirrorsLinerCuston AMEVeh Price (incl AME) Mo Mgmt Fee Mo Maint Chg Annual SpendFire Department2011 2011 Chevrolet C3500 Ambulance$307,600.00$0.00Police Department2117 2017 Chevrolet Tahoe Admin UnitChevrolet Tahoe4604791 2020 Chevrolet TahoeDefender Patrol upfit$52,907.50$52.75$0.00$633.00Police Department2118 2017 Chevrolet TahoeChevrolet Tahoe4588149 2020 Chevrolet TahoeDefender Patrol upfit$52,907.50$52.75$0.00$633.00Police Department2119 2017 Chevrolet TahoeChevrolet Tahoe4605380 2020 Chevrolet TahoeDefender Patrol upfit$52,907.50$52.75$0.00$633.00Police Department2120 2017 Chevrolet TahoeChevrolet Tahoe4605382 2020 Chevrolet TahoeDefender Patrol upfit$52,907.50$52.75$0.00$633.00Police Department2121 2017 Chevrolet TahoeChevrolet Tahoe4605385 2020 Chevrolet TahoeDefender Patrol upfit$52,907.50$52.75$0.00$633.00Police Department2122 2017 Chevrolet TahoeChevrolet Tahoe4605387 2020 Chevrolet TahoeDefender Patrol upfit$52,907.50$52.75$0.00$633.002021 REPLACEMENT BUDGET TOTALS$625,045.00 $316.50 $0.00 $3,798.00*Estimated pricing based on anticipated annual price increase for model year 2021**Conservative estimate based on available information ‐ will need to be revised$868,079.13 $3,233.22 $2,987.04 $9,701.76Resolution No. 2020-30, Page 3 Market Value EstimatesNon‐Emergency ResponseVehicle #VINDepartmentYearEst. Months in Service Miles Per Year Current Odometer Current Market Value41011FTFX1CF4BFB97542Building Inspections2013 CHEVROLET 1500 SILVERADO 2WD V6 REG CAB 4.3L W/T84609342649$5,000.0062115TFRY5F18BX113329Park Operations2013 FORD F150 2WD V6 FFV REG CAB 3.7L XL84942165945$4,500.0052041FT7X2A66CEB84991Public Works - Water2013 CHEVROLET 2500HD SILVERADO 4WD V8 FFV EXT CAB 6.0L W/T84655245861$11,500.0052081FTNF20586EC85991Public Works - Water2009 FORD F-450 SUPER CAB XL 4x4 CHASSIS84617943256$5,000.0053041GC2KVCGXCZ203535Public Works - Wastewater2013 FORD F-450 REG CAB XL 4x2 CHASSIS8414477101342$14,000.0059011FT7X2A66EEB87750Construction Inspections2013 CHEVROLET 2500HD SILVERADO 4WD V8 FFV EXT CAB 6.0L W/T132789086788$8,000.00Total$48,000.00Emergency ResponseVehicle #VINDepartmentYearEst. Months in Service Miles Per Year Current Odometer Current Market Value2011Fire Department2011 Chevrolet C3500 Ambulance120                                       65,633 $25,000.002117 Police Department 2017 Chevrolet Tahoe48                                         64,262 $11,000.002118 Police Department 2017 Chevrolet Tahoe48                                         67,911 $11,000.002119 Police Department 2017 Chevrolet Tahoe48                                         65,898 $11,000.002120 Police Department 2017 Chevrolet Tahoe48                                         72,751 $11,000.002121 Police Department 2017 Chevrolet Tahoe48                                         61,975 $11,000.002122 Police Department 2017 Chevrolet Tahoe48                                         57,552 $11,000.00Total$91,000.00$139,000.00Resolution No. 2020-30, Page 4 2021 VERF BUDGET BY DEPARTMENTBuilding InspectionTotal Vehicle Needs1Vehicle Acquisition Cost*$25,841.58Annual Maintenance Charges$434.76Annual Enterprise Management Fee $310.08Anticipated Gains from Sales$5,000.00Net Cashflow$21,586.42Park OperationsPolice DepartmentTotal Vehicle Needs1Total Vehicle Needs6Vehicle Acquisition Cost*$28,663.58Vehicle Acquisition Cost*$317,445.00Annual Maintenance Charges$434.76Annual Maintenance Charges$0.00Annual Enterprise Management Fee $344.04Annual Enterprise Management Fee $316.50Anticipated Gains from Sales$4,500.00Anticipated Gains from Sales$66,000.00Net Cashflow$24,942.38Net Cashflow$251,761.50Public Works StreetsFire DepartmentTotal Vehicle Needs0Total Vehicle Needs1Vehicle Acquisition Cost*$0.00Vehicle Acquisition Cost*$307,600.00Annual Maintenance Charges$0.00Annual Maintenance ChargesAnnual Enterprise Management Fee$0.00Annual Enterprise Management Fee $0.00Anticipated Gains from Sales$0.00Anticipated Gains from Sales$25,000.00Net Cashflow$0.00Net Cashflow$282,600.00Public Works Wastewater2021 VERF BUDGETTotal Vehicle Needs1Total Vehicle Needs13Vehicle Acquisition Cost*$57,304.16Vehicle Acquisition Cost*$868,079.13Annual Maintenance Charges$600.00Annual Maintenance Charges$2,987.04Annual Enterprise Management Fee $687.72Annual Enterprise Management Fee $3,233.22Anticipated Gains from Sales$14,000.00Anticipated Gains from Sales$139,000.00Net Cashflow$44,591.88Net Cashflow$735,299.39Public Works WaterTotal Vehicle Needs2Vehicle Acquisition Cost*$93,615.89Annual Maintenance Charges$1,058.76Annual Enterprise Management Fee $1,123.44Anticipated Gains from Sales$16,500.00Net Cashflow$79,298.09Construction InspectionsTotal Vehicle Needs1Vehicle Acquisition Cost*$37,608.92Annual Maintenance Charges$458.76Annual Enterprise Management Fee $451.44Anticipated Gains from Sales$8,000.00Net Cashflow$30,519.12Resolution No. 2020-30, Page 5