DIESEL_ENGINE_REPAIR_CY23.xlsx

XLSX spreadsheet 31 KB Posted

Attached to
DIESEL ENGINE REPAIRS
Solicitation number
25-P-00035
Issued by
Hillsborough County, Florida

About this file

This document is a detailed Work Order Sublet Report for diesel engine repair services for the City of Tampa Fleet Maintenance Department, covering the calendar year 2023 from January 1 to December 31. The report documents repair and maintenance work performed by three primary vendors: Florida Detroit Diesel, Goody's Fleet Solution LLC, and Kenworth of Central Florida, with comprehensive details on specific vehicle repairs, including engine block diagnostics, emission system repairs, air conditioning services, transmission work, and other mechanical interventions across the city's fleet.

The total expenditure for diesel engine repairs during the documented period was $312,595.06, with the majority of costs distributed across labor, parts, and additional service expenses. Repairs were processed through purchase orders and credit card transactions, with work orders spanning various vehicle systems and components. Vendors were selected based on specialized repair capabilities, with each vendor handling different types of mechanical services and diagnostic procedures. The report provides granular details on each repair, including work order numbers, repair descriptions, dates of service, and specific cost breakdowns, demonstrating a systematic approach to fleet maintenance and repair management for the City of Tampa.

View the file

Other files

Show all 16

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

W303 - Work Order Sublet by Ven

W303 - Work Order Sublet by VendorSUBLETS BY VENDOR - DETAIL REPORTp.1
City Of Tampa Fleet Maint.01/01/2023 to 12/31/2023
10/15/2024 6:40:38 AM
DELIVEREDRETURNINVOICELABORLABORPARTSOTHER COSTTOTALTOTAL USING
ASSET NUMBERWORK ORDERREPAIR DESCDATEDATENUMBERSHOPHOURSCOSTCOST& TAXCOSTACTUAL COST
VENDOR: FLORIDA DETROIT DIESEL - 383078921
PURCHASE ORDER\CREDIT CARD: P-CARD
007502372235Engine Block / Misc Parts / Repair12/12/202312/18/202390059000TFM0$819.000$0.000$20.000$839.000$839.000
007519370821Emission System / System / Diagnosis09/13/202309/14/202390055153TFM0$364.000$0.000$0.000$364.000$364.000
007520370625Emission System / System / Diagnosis09/12/202310/19/202390055130TFM0$364.000$0.000$0.000$364.000$364.000
007558370262Engine Block / Seal Oil Front / Replace09/26/202310/19/202390055731TFM0$3,276.000$485.270$182.000$3,943.270$3,943.270
007584371817Driveability / System / Diagnosis10/18/202310/19/202390056759TFM0$1,638.000$0.000$47.990$1,685.990$1,685.990
007586374088Emission System / Pump Emission / Replace12/14/202312/15/202390058885TFM0$364.000$647.490$0.000$1,011.490$1,011.490
007707371907Engine Block / Misc Parts / Repair11/29/202312/04/202390058380TFM0$728.000$0.000$0.000$728.000$728.000
007707371907Air Supply / AirCompressoAsm / Replace11/03/202311/07/202390057520TFM0$2,730.000$93.400$0.000$2,823.400$2,823.400
PO\CC Totals:0$10,283.000$1,226.160$249.990$11,759.150$11,759.150
PURCHASE ORDER\CREDIT CARD: 123203948
007705357959Driveability / System / Diagnosis12/07/202201/26/202390045192TFM0$11,200.000$4,187.060$0.000$15,387.060$15,387.060
PO\CC Totals:0$11,200.000$4,187.060$0.000$15,387.060$15,387.060
PURCHASE ORDER\CREDIT CARD: 123204582
007585360680Cooling Engine / Misc Parts / Replace01/10/202302/03/202390045695TFM0$16,562.000$4,057.310$0.000$20,619.310$20,619.310
PO\CC Totals:0$16,562.000$4,057.310$0.000$20,619.310$20,619.310
PURCHASE ORDER\CREDIT CARD: 123208415
007506365679Driveability / System / Diagnosis04/26/202304/28/202390049105TFM0$0.000$0.000$6,903.840$6,903.840$6,903.840
PO\CC Totals:0$0.000$0.000$6,903.840$6,903.840$6,903.840
PURCHASE ORDER\CREDIT CARD: 123208416
007509365200Engine Block / Dip Stick / Replace06/16/202306/21/202390050054TFM0$10,738.000$1,579.860$0.000$12,317.860$12,317.860
PO\CC Totals:0$10,738.000$1,579.860$0.000$12,317.860$12,317.860
PURCHASE ORDER\CREDIT CARD: 123209247
007511366359Driveability / System / Diagnosis05/22/202306/05/202390050748TFM0$0.000$0.000$11,931.560$11,931.560$11,931.560
PO\CC Totals:0$0.000$0.000$11,931.560$11,931.560$11,931.560
PURCHASE ORDER\CREDIT CARD: 123209835
007507366730Engine Block / System / Part Issue06/14/202306/21/202390051645TFM0$0.000$0.000$8,332.020$8,332.020$8,332.020
PO\CC Totals:0$0.000$0.000$8,332.020$8,332.020$8,332.020
PURCHASE ORDER\CREDIT CARD: 123210111
007584368552Engine Block / System / Diagnosis08/03/202308/03/202390053442TFM0$21,840.000$27,665.000$500.000$50,005.000$50,005.000
PO\CC Totals:0$21,840.000$27,665.000$500.000$50,005.000$50,005.000
PURCHASE ORDER\CREDIT CARD: 123211312
007584368552Engine Block / System / Diagnosis08/18/202308/18/202390054102TFM0$2,366.000$3,882.930$0.000$6,248.930$6,248.930
PO\CC Totals:0$2,366.000$3,882.930$0.000$6,248.930$6,248.930
PURCHASE ORDER\CREDIT CARD: 123211558
007582362521Engine Block / System / Diagnosis07/13/202308/11/202390052424TFM0$17,108.000$3,766.610$215.000$21,089.610$21,089.610
PO\CC Totals:0$17,108.000$3,766.610$215.000$21,089.610$21,089.610
PURCHASE ORDER\CREDIT CARD: 124201061
007504372046Unit Services / COMPLETE UNIT / Deliver Unit10/17/202310/27/2023500960TFM0$9,100.000$3,330.890$0.000$12,430.890$12,430.890
PO\CC Totals:0$9,100.000$3,330.890$0.000$12,430.890$12,430.890
PURCHASE ORDER\CREDIT CARD: 124201063
007568372047Engine Block / System / Diagnosis10/17/202310/26/2023501017TFM0$7,098.000$1,051.880$200.000$8,349.880$8,349.880
PO\CC Totals:0$7,098.000$1,051.880$200.000$8,349.880$8,349.880
PURCHASE ORDER\CREDIT CARD: KM p-card FY23
007584361572Exhaust Engine / Misc Parts / Replace01/09/202301/09/202390044431TFM0$364.000$581.160$0.000$945.160$945.160
PO\CC Totals:0$364.000$581.160$0.000$945.160$945.160
PURCHASE ORDER\CREDIT CARD: KM pcard FY23-2
007514361949Engine Block / Dip Stick / Replace02/14/202302/14/202390045834TFM0$182.000$68.320$0.000$250.320$250.320
007519365113Cooling Engine / System / Flush06/14/202306/14/202390048931TFM0$364.000$226.120$0.000$590.120$590.120
007587365812Engine Block / Misc Parts / Replace06/14/202306/14/202390050569TFM0$0.000$397.880$0.000$397.880$397.880
007589363848Transmission Au / System / Service03/28/202303/28/202390047682TFM0$0.000$991.240$0.000$991.240$991.240
007705357959Air Supply / Line Air / Replace02/06/202302/06/202390045576TFM0$2,548.000$27.100$73.600$2,648.700$2,648.700
PO\CC Totals:0$3,094.000$1,710.660$73.600$4,878.260$4,878.260
PURCHASE ORDER\CREDIT CARD: KM p-card FY23b
007510363554Fuel System / Injector Fuel D / Replace03/06/202303/06/202390046728TFM0$2,548.000$1,286.240$400.000$4,234.240$4,234.240
007587365812Engine Block / System / Part Issue06/14/202306/14/202390050227TFM0$0.000$275.360$0.000$275.360$275.360
PO\CC Totals:0$2,548.000$1,561.600$400.000$4,509.600$4,509.600
PURCHASE ORDER\CREDIT CARD: KM p-card FY23d
007504366131Engine Block / Seal Oil Front / Replace06/21/202306/21/202390051273TFM0$3,458.000$407.030$0.000$3,865.030$3,865.030
007585360680Emission System / System / Diagnosis06/27/202306/27/202390049993TFM0$57.010$0.000$0.000$57.010$57.010
PO\CC Totals:0$3,515.010$407.030$0.000$3,922.040$3,922.040
PURCHASE ORDER\CREDIT CARD: Km p-card FY23e
007509365200Emission System / Misc Parts / Replace06/28/202306/28/202390051404TFM0$1,820.000$664.360$0.000$2,484.360$2,484.360
007514368335Emission System / Misc Parts / Repair07/12/202307/12/202390052318TFM0$182.000$0.000$0.000$182.000$182.000
007516368118Emission System / Misc Parts / Repair07/07/202307/07/202390052086TFM0$182.000$0.000$0.000$182.000$182.000
007517367701Driveability / System / Diagnosis07/07/202307/07/202390052088TFM0$182.000$0.000$0.000$182.000$182.000
PO\CC Totals:0$2,366.000$664.360$0.000$3,030.360$3,030.360
VENDOR: FLORIDA DETROIT DIESEL - 3830789210$118,182.010$55,672.510$28,806.010$202,660.530$202,660.530
DELIVEREDRETURNINVOICELABORLABORPARTSOTHER COSTTOTALTOTAL USING
ASSET NUMBERWORK ORDERREPAIR DESCDATEDATENUMBERSHOPHOURSCOSTCOST& TAXCOSTACTUAL COST
VENDOR: Goody's Fleet Solution LLC - 1247482
PURCHASE ORDER\CREDIT CARD: P-CARD
001259372818Engine Block / Seal Oil Front / Repair11/06/202311/16/2023130240030$2,802.500$463.800$50.000$3,316.300$3,316.300
002111374058Driveability / System / Diagnosis12/18/202312/21/2023133920090$1,568.500$780.960$50.000$2,399.460$2,399.460
002241372069Air Conditionin / Sensor High PSI / Replace10/24/202311/29/2023139370050$737.500$518.710$50.000$1,306.210$1,306.210
002589371696Gauge Instro / Speed Cont Asm / Repair10/16/202310/25/2023127790050$1,037.500$496.460$50.000$1,583.960$1,583.960
002641370541Emission System / System / Diagnosis10/17/202310/20/2023127240050$740.000$211.090$47.550$998.640$998.640
002664373230Cranking System / Starter Heavy / Replace11/28/202311/30/2023131260050$420.000$224.200$32.210$676.410$676.410
004921373246Transmission Au / System / Diagnosis11/30/202312/04/2023139500050$1,253.750$0.000$50.000$1,303.750$1,303.750
007633372056Driveability / System / Diagnosis11/16/202311/22/2023130960050$1,032.500$3,328.410$546.460$4,907.370$4,907.370
PO\CC Totals:0$9,592.250$6,023.630$876.220$16,492.100$16,492.100
PURCHASE ORDER\CREDIT CARD: 124202409
002241372069Engine Block / Assembly / Replace10/24/202311/30/2023135730050$4,838.000$19,559.740$50.000$24,447.740$24,447.740
PO\CC Totals:0$4,838.000$19,559.740$50.000$24,447.740$24,447.740
PURCHASE ORDER\CREDIT CARD: 124203433
002632373666Engine Block / System / Diagnosis12/05/202312/12/2023132900090$1,593.000$7,037.930$350.000$8,980.930$8,980.930
PO\CC Totals:0$1,593.000$7,037.930$350.000$8,980.930$8,980.930
PURCHASE ORDER\CREDIT CARD: EC P-CARD
002648373101Cooling Engine / System / Diagnosis12/05/202312/08/2023132490090$1,357.000$96.720$311.200$1,764.920$1,764.920
PO\CC Totals:0$1,357.000$96.720$311.200$1,764.920$1,764.920
PURCHASE ORDER\CREDIT CARD: FAM Pcard FY23
001515369672Air Conditionin / Control / Replace09/07/202309/18/2023123900090$663.750$503.460$50.000$1,217.210$1,217.210
001533366951Air Conditionin / Belt / Replace06/08/202306/09/2023113090090$442.500$220.160$33.130$695.790$695.790
001533364577Air Conditionin / System / Diagnosis03/28/202303/30/2023105950090$295.000$89.340$19.220$403.560$403.560
001533366951Axle Rear / Housing Axle Re / Repair05/30/202306/07/2023112780090$634.250$564.740$50.000$1,248.990$1,248.990
002444366368Transmission Au / System / Diagnosis05/16/202305/22/2023111060050$1,589.800$2,316.150$54.500$3,960.450$3,960.450
002526368913Brakes / Compressor Brak / Replace08/11/202308/22/2023121270050$1,253.750$2,361.780$50.000$3,665.530$3,665.530
002588363741Driveability / System / Diagnosis03/31/202303/31/2023105970050$740.000$541.540$50.000$1,331.540$1,331.540
002671365002Fuel System / Injector Fuel D / Replace04/26/202305/01/2023108800050$1,401.250$1,109.420$50.000$2,560.670$2,560.670
24A7904369415Engine Block / SealEngineOil R / Replace08/07/202308/28/2023121580050$3,879.250$1,062.290$50.000$4,991.540$4,991.540
PO\CC Totals:0$10,899.550$8,768.880$406.850$20,075.280$20,075.280
PURCHASE ORDER\CREDIT CARD: KA PCARD FY23
001515369672Air Conditionin / Blower / Replace08/11/202308/28/2023127700090$678.500$255.660$46.710$980.870$980.870
PO\CC Totals:0$678.500$255.660$46.710$980.870$980.870
PURCHASE ORDER\CREDIT CARD: WM P-CARD FY23
002414360715Ignition System / Control Module / Replace02/07/202302/27/2023102790050$1,187.500$1,361.470$50.000$2,598.970$2,598.970
002589362537Elect Propulsio / System / Diagnosis02/07/202302/20/2023102210050$595.000$29.750$425.540$1,050.290$1,050.290
PO\CC Totals:0$1,782.500$1,391.220$475.540$3,649.260$3,649.260
VENDOR: Goody's Fleet Solution LLC - 12474820$30,740.800$43,133.780$2,516.520$76,391.100$76,391.100
DELIVEREDRETURNINVOICELABORLABORPARTSOTHER COSTTOTALTOTAL USING
ASSET NUMBERWORK ORDERREPAIR DESCDATEDATENUMBERSHOPHOURSCOSTCOST& TAXCOSTACTUAL COST
VENDOR: KENWORTH OF CENTRAL FL. INC - 592450246
PURCHASE ORDER\CREDIT CARD: P-CARD
002614372257Driveability / System / Diagnosis10/25/202310/30/20233848050050$0.000$0.000$0.000$0.000$0.000
PO\CC Totals:0$0.000$0.000$0.000$0.000$0.000
PURCHASE ORDER\CREDIT CARD: 123201868
002332364507Driveability / System / Diagnosis04/11/202304/28/20235225360030$630.000$94.410$63.000$787.410$787.410
PO\CC Totals:0$630.000$94.410$63.000$787.410$787.410
PURCHASE ORDER\CREDIT CARD: 123206736
001211363722Cooling Engine / Fan Motor / Replace03/14/202303/29/2023053S222410030$5,040.000$403.510$402.500$5,846.010$5,846.010
002302364440Engine Block / System / Diagnosis03/28/202304/06/2023053S5226150030$5,040.000$725.960$656.710$6,422.670$6,422.670
002629364311Unit Services / COMPLETE UNIT / Towing03/28/202305/09/2023053S225670030$3,600.000$418.420$3,220.000$7,238.420$7,238.420
002629364311Hydraulic Syste / System / Diagnosis05/31/202306/12/2023053S5240880030$0.000$0.000$872.090$872.090$872.090
002651364030Cooling Engine / System / Diagnosis03/14/202303/20/2023053S5222330050$2,610.000$1,023.540$250.000$3,883.540$3,883.540
PO\CC Totals:0$16,290.000$2,571.430$5,401.300$24,262.730$24,262.730
PURCHASE ORDER\CREDIT CARD: 123206736.
001296365952Unit Services / COMPLETE UNIT / Quality/safety05/02/202307/12/2023053S5240870030$0.000$0.000$0.000$6,467.580$6,467.580
PO\CC Totals:0$0.000$0.000$0.000$6,467.580$6,467.580
PURCHASE ORDER\CREDIT CARD: EC P-CARD
002616371325Driveability / Misc Parts / Repair10/04/202310/09/2023053S5271010050$1,330.000$497.710$198.000$2,025.710$2,025.710
PO\CC Totals:0$1,330.000$497.710$198.000$2,025.710$2,025.710
PURCHASE ORDER\CREDIT CARD: WRNT
002595370233Unit Services / Recall-Campaign / Campaign09/05/202309/08/2023053S5264110050$0.000$0.000$0.000$0.000$0.000
002595370233Cooling Engine / Radiator / Replace09/05/202309/08/2023053S5264110050$0.000$0.000$0.000$0.000$0.000
PO\CC Totals:0$0.000$0.000$0.000$0.000$0.000
VENDOR: KENWORTH OF CENTRAL FL. INC - 5924502460$18,250.000$3,163.550$5,662.300$33,543.430$33,543.430
LABORLABORPARTSOTHER COSTTOTALTOTAL USING
HOURSCOSTCOST& TAXCOSTACTUAL COST
REPORT TOTALS:0$167,172.810$101,969.840$36,984.830$312,595.060$312,595.060
REPORT PARAMETERS:
Time Zone:Eastern Standard Time
Begin Date:01/01/2023
End Date:12/31/2023
Vendor:1247482 [Goody's Fleet Solution LLC]

383078921 [FLORIDA DETROIT DIESEL]

592450246 [KENWORTH OF CENTRAL FL. INC]

Vendor Status:All Values
Date Type:Return Date
Pricing:Cost
Payment Type:Purchase Order and Credit Card
Purchase Order Number:All Values
Group By:Vendor Name
Invoice Number:All Values
Credit Card Type:All Values
Credit Card Holder:All Values
Organization:All Values
Class:All Values
Use Department From:Work Order
Department:All Values
Maint Shop:All Values
Work Order Status:All Values
Repair Reason:All Values
Repair Group:All Values
Asset Number:All Values
Page Breaks:No
REPORT VERSIONS:
Report Version:20171004.1130
Script Version:20150923.1401

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