Auto_Schedule_as_of_07-05-2018.xls

XLS spreadsheet 58 KB Posted

Attached to
Property and Casualty Insurance
Solicitation number
RFP-2018-0369
Issued by
Florida

About this file

The file is an Auto Schedule spreadsheet dated July 5, 2018, detailing a comprehensive vehicle fleet inventory for a local government jurisdiction, likely in Florida. The spreadsheet catalogs 188 vehicles spanning model years 1995-2018, including various makes and models such as Ford, Chevrolet, GMC, and International trucks, vans, SUVs, and specialized vehicles like street sweepers and vacuum trucks. Each vehicle entry includes a vehicle number, serial number, department, year, make, model, original cost, and is designated for comprehensive and collision insurance coverage.

The vehicle fleet represents a diverse range of municipal transportation assets, with original costs ranging from approximately $13,000 to $364,136. The inventory includes numerous law enforcement vehicles (Ford Explorers, Interceptors), utility trucks (F-150, F-250, F-450), specialized municipal vehicles like street sweepers and vacuum trucks, and standard administrative vehicles. The spreadsheet appears to be supporting documentation for a property and casualty insurance contract, specifically for vehicle insurance coverage, with all vehicles marked for comprehensive and collision insurance. The fleet's age and composition suggest ongoing municipal vehicle replacement and maintenance strategies, with vehicles spanning over two decades of acquisition.

View the file

Other files

Show all 12

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

download (6)

Vehicle NumberSerial NumberDepartmentCity NumberYearMakeModelOriginal Cost NewClass CodeMotorcycle CCSMotorcycle Fire TheftCoverage
15938PK1991995FORDVAN1799514990Comprehensive & Collision
24863SF3381998GMC1 TON SIERRA1732114990Comprehensive & Collision
3785PK701999CHEVROLETPICKUP1439614990Comprehensive & Collision
41881SF3401999GMCTRUCK2584014990Comprehensive & Collision
53946CE2622000GMCPICKUP1805814990Comprehensive & Collision
6727WP4732000CHEVROLETASTRO VAN1743473980Comprehensive & Collision
7691DC4122001INTERNATIONALTRUCK44695214990Comprehensive & Collision
83909PC4612001GMCSONOMA1359814990Comprehensive & Collision
99266SF3422001INTERNATIONALTRUCK39633214990Comprehensive & Collision
108495PD1952002CHEVROLETBLAZER1864473980Comprehensive & Collision
118007PD1822004CHEVROLETMALIBU2150079110Comprehensive & Collision
122095CE2592003CHEVROLETMALIBU2200079080Comprehensive & Collision
137207SF3502004FORDF45030000214990Comprehensive & Collision
141245DC4202005INTERNATIONALVAC CON189956504990Comprehensive & Collision
155487PD1422002FORDF1501600014990Comprehensive & Collision
167501LS4482005FORDTRUCK2151614990Comprehensive & Collision
174346WP4762005CHEVROLETSILVERADO1382014990Comprehensive & Collision
187711PD1522006FORDCGO VAN1460014990Comprehensive & Collision
199378DC4212006SILVERADOPICKUP2166014990Comprehensive & Collision
206316PD1462006CHEVROLETIMPALA2397273980Comprehensive & Collision
218548PD1482006CHEVROLETIMPALA2397273980Comprehensive & Collision
223973PD1452006CHEVROLETIMPALA2397273980Comprehensive & Collision
239762PD1572006CHEVROLETTAHOE3319973980Comprehensive & Collision
249230PK822007CHEVROLETCOLORADO 2WD EXT CAB1657814990Comprehensive & Collision
258864MR622007CHEVROLETCOLORADO 2WD EXT CAB1495314990Comprehensive & Collision
268930WP4772007CHEVROLETCOLORADO 2WD EXT CAB1625314990Comprehensive & Collision
274913PD5112007CHEVROLETIMPALA1755379110Comprehensive & Collision
284750PD5102007CHEVROLETIMPALA1755379110Comprehensive & Collision
293797PD5092007CHEVROLETIMPALA1755379110Comprehensive & Collision
303713PD5082007CHEVROLETIMPALA1755379110Comprehensive & Collision
311395PD5072007CHEVROLETIMPALA1755379110Comprehensive & Collision
32890PD5062007CHEVROLETIMPALA1755379110Comprehensive & Collision
33177PD5052007CHEVROLETIMPALA1755379110Comprehensive & Collision
348907PD5042007CHEVROLETIMPALA1755379110Comprehensive & Collision
368899PD5032007CHEVROLETMALIBU1495579110Comprehensive & Collision
378501PD5022007CHEVROLETMALIBU1495579110Comprehensive & Collision
386665SF3532007FORDEXTENDED CAB TRUCK1763114990Comprehensive & Collision
406869SF3552008FORDF-150 DUMP TRUCK68834214790Comprehensive & Collision
416177WP4782009CHEVROLETCOLORADO EXT CAB1859114990Comprehensive & Collision
426571PK842009CHEVROLETCOLORADO EXT CAB1788714990Comprehensive & Collision
437007MR632009CHEVROLETCOLORADO EXT CAB1788714990Comprehensive & Collision
44511SW3852009FORDF45035833214990Comprehensive & Collision
45512SW3842009FORDF45035833214990Comprehensive & Collision
46530SW3872010INTERNATIONALSTREET SWEEPER207664314990Comprehensive & Collision
472619SF3572010FORDBUCKET TRUCK64925214990Comprehensive & Collision
488951PD5242010CHEVROLETIMPALA1906279110Comprehensive & Collision
499023PD5252010CHEVROLETIMPALA1906279110Comprehensive & Collision
509536PD5262010CHEVROLETIMPALA1906279110Comprehensive & Collision
518182SW3822008FORDF2502220214990Comprehensive & Collision
522357PD5132010CHEVROLETIMPALA1938579110Comprehensive & Collision
532463PD5142010CHEVROLETIMPALA1938579110Comprehensive & Collision
542962PD5152010CHEVROLETIMPALA1938579110Comprehensive & Collision
553017PD5162010CHEVROLETIMPALA1938579110Comprehensive & Collision
565206PD5172010CHEVROLETIMPALA1938579110Comprehensive & Collision
572330PD5182010CHEVROLETIMPALA1938579110Comprehensive & Collision
584462PD5192010CHEVROLETIMPALA1938579110Comprehensive & Collision
594678PD5222010CHEVROLETIMPALA1938579110Comprehensive & Collision
604813PD5232010CHEVROLETIMPALA1938579110Comprehensive & Collision
617733SF3582010FORDF1501818514990Comprehensive & Collision
627234PD5272010CHEVROLETIMPALA1884979110Comprehensive & Collision
637741PD5282010CHEVROLETIMPALA1884979110Comprehensive & Collision
648561PD5292010CHEVROLETIMPALA1884979110Comprehensive & Collision
659052PD5302010CHEVROLETIMPALA1884979110Comprehensive & Collision
66TBDAVIS2010UNDERCOVERROTATING CAR2000079110Comprehensive & Collision
674196DC4232011FORDF150 PICKUP1909514990Comprehensive & Collision
68506PD5312011CHEVROLETIMPALA1945679110Comprehensive & Collision
693949PD5322011CHEVROLETIMPALA1945679110Comprehensive & Collision
704165PD5332011CHEVROLETIMPALA1945679110Comprehensive & Collision
715352PD5342011CHEVROLETIMPALA1945679110Comprehensive & Collision
725689PD5352011CHEVROLETIMPALA1945679110Comprehensive & Collision
736956PD5362011CHEVROLETIMPALA1945679110Comprehensive & Collision
749378CE202012FORDF1502330014990Comprehensive & Collision
759379CE212012FORDF1502330014990Comprehensive & Collision
768496DC4252012FORDTRUCK3919714990Comprehensive & Collision
778495DC4242012FORDTRUCK3919714990Comprehensive & Collision
789377DC4262012FORDF150 DUMP TRUCK1734914790Comprehensive & Collision
797425SF3542007FORDF2502340914990Comprehensive & Collision
807839SF3592012FORDF-750 DUMP72600314790Comprehensive & Collision
817838DC4272012FORDF-750 DUMP72600314790Comprehensive & Collision
828057PD5382012CHEVROLETIMPALA1975879110Comprehensive & Collision
83692PD5392012CHEVROLETIMPALA1975879110Comprehensive & Collision
841166PD5402012CHEVROLETIMPALA1975879110Comprehensive & Collision
858374PD5422013FORDINTERCEPTOR2352879110Comprehensive & Collision
868375PD5432013FORDINTERCEPTOR2352879110Comprehensive & Collision
878376PD5442013FORDINTERCEPTOR2352879110Comprehensive & Collision
888371PD5452013FORDINTERCEPTOR2424679110Comprehensive & Collision
898372PD5462013FORDINTERCEPTOR2424679110Comprehensive & Collision
908377PD5472013FORDINTERCEPTOR2424679110Comprehensive & Collision
914295PC4642013FORDF150 TRUCK1672914990Comprehensive & Collision
92803SW3902013FORDEXPLORER2436373980Comprehensive & Collision
932923PD5482013FORDEXPLORER2441779110Comprehensive & Collision
942925PD5492013FORDEXPLORER2538979110Comprehensive & Collision
959678PD1722013FORDF-250 TRAFFIC UTILITY3097514990Comprehensive & Collision
962924PD5502013FORDEXPLORER2538979110Comprehensive & Collision
971061WP4792013FORDESCAPE1907273980Comprehensive & Collision
987093DC4282013FORDF55056586214990Comprehensive & Collision
99TBD2007UNDERCOVERVEHICLE2000079110Comprehensive & Collision
1006519PD1552013FORDFUSION2041673980Comprehensive & Collision
1017576PD1741997FREIGHTLINERFL6085000314990Comprehensive & Collision
1023893PD 1732013FORDF1502165479120Comprehensive & Collision
10365182013FORDFUSION2041679110Comprehensive & Collision
1045187DC4292013FORDE450190505214990Comprehensive & Collision
1052868PD1542006CHEVROLETIMPALA2397279110Comprehensive & Collision
1068373PD5412013FORDINTERCEPTOR2352879110Comprehensive & Collision
107290AD32014FORDEXPLORER2419873980Comprehensive & Collision
1085652PD5512013CHEVROLETIMPALA2034279110Comprehensive & Collision
1095777PD5522013CHEVROLETIMPALA2034279110Comprehensive & Collision
1106626PD5532013CHEVROLETIMPALA2034279110Comprehensive & Collision
1116664PD5542013CHEVROLETIMPALA2034279110Comprehensive & Collision
1126711PD5552013CHEVROLETIMPALA2034279110Comprehensive & Collision
1137453PD5562013CHEVROLETIMPALA2034279110Comprehensive & Collision
1147516PD5572013CHEVROLETIMPALA2034279110Comprehensive & Collision
1157641PD5582013CHEVROLETIMPALA2034279110Comprehensive & Collision
1167712PD5592013CHEVROLETIMPALA2034279110Comprehensive & Collision
1179298DC4302013FORDF450 DUMP TRUCK43826214790Comprehensive & Collision
11893002013FORDF450 DUMP TRUCK43826214790Comprehensive & Collision
11992992013FORDF450 4X2 TRUCK28466214990Comprehensive & Collision
120744DC4332014FORDF1502176914990Comprehensive & Collision
1217045SF3612014FORDFLEET FUEL TRUCK2536014990Comprehensive & Collision
1229197PK7032014FORDF150 REG CAB 4X21888414990Comprehensive & Collision
1237243DC4342014FORDF55070791314990Comprehensive & Collision
12412952015FORDF450 SUPER DUTY38964214990Comprehensive & Collision
12570082014FORDTRANSIT CONNECT2119014990Comprehensive & Collision
12691972014FORDF1502875814990Comprehensive & Collision
1273742014FORDEXPLORER2445573980Comprehensive & Collision
12877752015FORDF-750103022314990Comprehensive & Collision
12950752014TEXASTRAILER8979684990Comprehensive & Collision
1303281DCSEQ2014UTILITY5X8 LS TRAILER1095684990Comprehensive & Collision
1316765DC4382015FORDF250 SERVICE TRUCK3018414990Comprehensive & Collision
1326763DC4392015FORDF2503426314990Comprehensive & Collision
1336766DC4492015FORDF2503187914990Comprehensive & Collision
1346950AD42015FORDEXPLORER2535373980Comprehensive & Collision
1356951AD52015FORDEXPLORER2535373980Comprehensive & Collision
136832PC4652015FORDF-150 TRUCK2091214990Comprehensive & Collision
137831WP4802015FORDF-150 TRUCK2091214990Comprehensive & Collision
138833MR642015FORDF-150 TRUCK2091214990Comprehensive & Collision
1398088IN532015FORDF-150 TRUCK2048314990Comprehensive & Collision
1405709DC4502016FREIGHTLINERVAC- CON363423504990Comprehensive & Collision
141834TruckDC4512015FORDF1502185314990Comprehensive & Collision
1422270PK7052016FORDTRANSIT CONNECT1954014990Comprehensive & Collision
1433177SW3932016FORDF-1502582514990Comprehensive & Collision
1443842SW3942015FORDF-150 TRUCK2874814990Comprehensive & Collision
1456874AD62016FORDEXPLORER2490073980Comprehensive & Collision
1462317PD5602016CHEVROLETTRAVERSE2787173980Comprehensive & Collision
14752482016FORDTRANSIT WAGON2517014990Comprehensive & Collision
1485891PD5612016FORDEXPLORER3012873980Comprehensive & Collision
1498596REG CAB PICKUP2016GMCSIERRA 2WD1973014990Comprehensive & Collision
1504257MR652016GMCSIERRA1973014990Comprehensive & Collision
1515375WP4812016GMCSIERRA1973014990Comprehensive & Collision
1528596PK7082016GMCSIERRA1973014990Comprehensive & Collision
1539430CRANE TRUCK LS4452016FORDF550 WITH CRANE86934214990Comprehensive & Collision
1544202PD5622016FORDEXPLORER3012879110Comprehensive & Collision
1558325VAC CON SEWER SWEEPE2017FREIGHTLINER114SD CHASSIS364136314990Comprehensive & Collision
1568439DC4532017FORDF1502505414990Comprehensive & Collision
1573587PK7092017FORDF1502555414990Comprehensive & Collision
1584659CE232017FORDEXPLORER2435973980Comprehensive & Collision
1593588PK7102017FORDF1502055414990Comprehensive & Collision
1603586PK7112017FORDF1502054414990Comprehensive & Collision
16146642017FORDEXPLORER3220773980Comprehensive & Collision
16246652017FORDEXPLORER3212273980Comprehensive & Collision
1639742017FORDF250 SUPERCAB3013514990Comprehensive & Collision
1644474PD5652017FORDINTERCEPTOR3764179110Comprehensive & Collision
1654475PD5662017FORDINTERCEPTOR3764179110Comprehensive & Collision
1664477PD5682017FORDINTERCEPTOR3764179110Comprehensive & Collision
1674658CE242017FORDEXPLORER2808473980Comprehensive & Collision
1684476PD5672017FORDINTERCEPTOR3764179110Comprehensive & Collision
1694478PD5692017FORDINTERCEPTOR3764179110Comprehensive & Collision
170346WP4822017FORDF1502055414990Comprehensive & Collision
171347MR662017FORDF1502055414990Comprehensive & Collision
1721863PK7132017FORDTRANSIT CONNECT VAN2215773980Comprehensive & Collision
1731866PK7142017FORDTRANSIT CONNECT VAN2215773980Comprehensive & Collision
17438572018CHEVROLETTAHOE4750079110Comprehensive & Collision
1756543SF3672018CHEVROLETSILVERADO2813014990Comprehensive & Collision
1767817PD5722018FORDEXPLORER2972079110Comprehensive & Collision
1777813PD5712018FORDEXPLORER2972079110Comprehensive & Collision
1787812PD5702018FORDEXPLORER2972079110Comprehensive & Collision
179733PD5732018FORDEXPLORER2972079110Comprehensive & Collision
1807814PD5742018FORDEXPLORER3005079110Comprehensive & Collision
1817816PD5752018FORDEXPLORER3005079110Comprehensive & Collision
1827815PD5762018FORDEXPLORER3005079110Comprehensive & Collision
1839145PD5772018FORDF1503208979110Comprehensive & Collision
1841700PD5782018FORDEXPLORER3005079110Comprehensive & Collision
1851698PD5792018FORDEXPLORER3005079110Comprehensive & Collision
1861697PD5802018FORDEXPLORER3005079110Comprehensive & Collision
1871695PD5812018FORDEXPLORER3005079110Comprehensive & Collision
1881696PD5822018FORDEXPLORER3005079110Comprehensive & Collision

File details come from the government source that posted it. Updated .