B08 Exhibit D - ITD-01 Transportation Report Format.xlsx

XLSX spreadsheet 76 KB Posted

Attached to
EAGLE Fort Cavazos, TX W519TC-23-R-0102
Solicitation number
W519TC23R0102
Issued by

About this file

This document is an exhibit that outlines the Contract Data Requirements List (CDRL) for the transportation reporting requirements under a federal contract opportunity.

The CDRL requires the contractor to provide 13 different monthly, weekly, and daily reports covering various transportation-related metrics, including statistical data, customer driver support, vehicle accident logs, fuel usage, maintenance logs, and vehicle status. The reports must be submitted electronically in Microsoft Excel or Word format by specified due dates to the Contracting Officer's Representative (COR) and Quality Assurance Evaluator (QAE). Key reporting requirements include vehicle mileage, passenger counts, leased vehicle usage, accident/incident tracking, and credit card verification. The contractor must also notify the government immediately of any vehicle accidents or lost/stolen fuel cards.

The related federal contract opportunity is for maintenance, supply, and transportation services at Fort Cavazos, TX, solicited by the Department of the Army Materiel Command Contracting Command Rock Island Arsenal.

View the file

Other files

File Type Posted
B08-Attachment 0039- Ft. Cavazos Q&A responses round 5.xlsx XLSX spreadsheet
W519TC23R0102-0009.pdf PDF
B08 Attachment 0004 - Letter of Consent_FCTX-REV1.pdf PDF
B08 - Attachment 0038- Ft. Cavazos Q&A responses round 4.xlsx XLSX spreadsheet
W519TC23R0102-0008.pdf PDF
B08 Attachment 0036- Ft. Cavazos Q&A Responses Round 2.xlsx XLSX spreadsheet
W519TC23R0102-0007.pdf PDF
B08 - Attachment 0037- FT. Cavazos Q&A responses round 3.xlsx XLSX spreadsheet
W519TC23R0102-0006.pdf PDF
W519TC23R0102-0004.pdf PDF
W519TC23R0102-0003.pdf PDF
Attachment 0035- Ft. Cavazos Q&A Responses Round 2.xlsx XLSX spreadsheet
FCTX QA Round 02_26JUN2024 - FOR OFFERORS.xlsx XLSX spreadsheet
B08 Attachment 0011 - Contract References Spreadsheet_18JUN24.xlsx XLSX spreadsheet
B08 Attachment 0001 - Performance Work Statement - PWS 24JUN2024.pdf PDF
W519TC23R0102-0002.pdf PDF
B08-Attachment 0001- Performance Work Statement - PWS 30MAY2024.pdf PDF
B08-Attachment 0035- Ft. Cavazos Q&A Responses_10JUN2024.xlsx XLSX spreadsheet
B08-Attachment 0031- Appendix C Red Hat 30MAY2024.docx DOCX document
B08-Attachment 0005 - Cost Price Matrix-Cavazos 03JUN2024.xlsx XLSX spreadsheet
B08-Attachment 0030- Appendix B Phantom SSA 30MAY2024.docx DOCX document
W519TC23R0102-0001.pdf PDF
B08-Attachment 0033- Appendix E PAAT 30MAY2024.docx DOCX document
B08-Attachment 0034- Appendix F 3SFAB 30MAY2024.docx DOCX document
B08-Attachment 0032- Appendix D FSR 30MAY2024.docx DOCX document
B08 Exhibit E - MMD-01 Maintenance Report Format.xlsx XLSX spreadsheet
B08 Attachment 0010 Blocked File Extensions_with updated DoDAAC (1).pdf PDF
W519TC23R0102.pdf PDF
B08 Exhibit J - SS-01 Supply and Services Report Format.xlsx XLSX spreadsheet
B08 Attachment 0008 - NOT APPLICABLE.pdf PDF
B08 Attachment 0014 - Small Business Participation Plan.docx DOCX document
B08 Attachment 0001 - Performance Work Statement - PWS 20240307.pdf PDF
B08 Attachment 0006 - Preaward Survey of Prospective Contractor Accounting System SF 1408.pdf PDF
B08 Attachment 0016 - PWS Annex A Maintenance PRS 20240301.pdf PDF
B08 Exhibit A - dd1423-1.pdf PDF
B08 Exhibit G - PM-09 Performance Management Review Format (version 3-04-24).pptx PPTX presentation
B08 Attachment 0020 - PWS Annex E - Definitions Acronyms Abbreviations.pdf PDF
B08 Attachment 0009 - Purchasing Invoicing Guide (PIG) FCTX.pdf PDF
B08 Attachment 0018 - PWS Annex C Transportation PRS 20240301.pdf PDF
B08 Attachment 0005 - Cost Price Matrix-Cavazos.xlsx XLSX spreadsheet
B08 Attachment 0002 - Staffing and Labor Mix 7MAR24.xlsx XLSX spreadsheet
B08 Attachment 0004 - Letter of Consent_FCTX.pdf PDF
B08 Exhibit B - CDRL Listing 6MAR24.xlsx XLSX spreadsheet
B08 Attachment 0022 - PWS Appendix A MDRS 20240229.pdf PDF
B08 Attachment 0021 - PWS Annex F - Publications and Forms.pdf PDF
B08 Attachment 0011 - Contract References Spreadsheet_FCTX.xlsx XLSX spreadsheet
B08 Attachment 0003 - Performance Questionnaire_FCTX.pdf PDF
B08 Attachment 0029 Government Responses to Industry FCTX.xlsx XLSX spreadsheet
B08 Exhibit F - PM-01 Contractor Employee Information Format.xlsx XLSX spreadsheet
B08 Exhibit C - CD-02 Burn Rate Report Format v10.xlsx XLSX spreadsheet
Show 40 more

Latest 50 of 55 listed here. See the rest on GovTribe.

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

CDRLs ITD-01 Transportation Report FORMAT

The Contractor shall provide all CDRLs in electronic format unless otherwise directed by the Government.
NumberReport TitleFormatFrequencyDate DueRecipients
1Transportation Statistical DataMicrosoft ExcelMonthly5th WorkdayCOR/QAE
2Customer Driver Support ReportMicrosoft ExcelMonthly5th WorkdayCOR/QAE
3Vehicle Accident LogMicrosoft ExcelMonthly5th Workday /Notify Gov personnel immediately when accident/incident occur VIA emailCOR/QAE
4Lost/Stolen GSA Fuel Credit Card ReportMicrosoft ExcelMonthly5th Workday /Notify Gov personnel immediately when accident/incident occur VIA emailCOR/QAE
5GSA Vehicle Listing ReportMicrosoft ExcelMonthly5th WordayCOR/QAE
6Vehicle InventoryMicrosoft ExcelMonthly5th WordayCOR/QAE
7Petroleum Issue ReportMicrosoft ExcelMonthly5th WordayCOR/QAE
8Vehicle Maintenace LogMicrosoft ExcelMonthly5th WordayCOR/QAE
9Vehicle Rotation PlanMicrosoft ExcelMonthly5th WordayCOR/QAE
10Credit Card Vertification ReportMicrosoft WordMonthly5th WordayCOR/QAE
11Critical Vehicle Status ReportMicrosoft ExcelWeeklyMondayCOR/QAE
12Vehicle Mileage reportMicrosoft ExcelMonthly25th of each monthCOR/QAE
13Daily Commitment LogMicrosoft ExcelDailyEvery work dayCOR/QAE

Transportation Statistical

Transportation Statistical Data
Functional AreaFeb-25Mar-25Apr-25May-25Jun-25Jul-25Aug-25Sep-25Oct-25Nov-25Dec-25Jan-26
TMP Reported Mileage
GSA Vehicle Mileage - Base Ops
GSA Vehicle Mileage - OCO
GSA Vehicle Mileage - Reimbursable Vehicles Including Leased
Army Owned Vehicle Mileage
TMP Vehicle Count
GSA Vehicles - Base Ops
GSA Vehicles - OCO
GSA Reimbursable Vehicles Including Leased
Army Owned
Contractor Information
Employee Count
Mileage
Mileage - Base Ops
Mileage - Contingency
Passengers
Passengers - Base Ops
Passengers - Contingency
CONTRACT INVOICES
Basic Invoice - Monthly
Contingency Invoice - Monthly
SAMMC Invoice - Monthly
Other Direct Costs - Monthly - Base Ops
Other Direct Costs - Monthly - Contingency
LEASED VEHICLES
Base Ops - Total Vehicles
Base Ops - Cost of Leased Vehicles
Contingency - Total Vehicles
Contingency - Cost of Leased Vehicles

SAMMC Service - Passenger Count

Total Commitments (Forscom Form 56-2) - Approved
Total Requests Not Submitted Within 2 Working Days
Average for Late Submittals
Total Vehicles for Valid Requests Filled
Number of Requests Received
Funeral Details
CAO Details
Corps SGS Executive Services (VIP)
Total Commitments with Contractor Drivers
RGAAF / Airport Commitments

Requests Disapproved by Motor Officer / COR or Not Supported by TMP

Vehicles Deadlined
Number Services Completed
Numbers of Reported Accidents
Numbers of Contractor Reported Accidents
Fuel Support
Diesel Gallons Issued
Diesel Gallons Received During Delivery
Number of Diesel Bulk Fuel Receipts
MOGAS Gallons Issued
MOGAS Gallons Received During Delivery
Number of MOGAS Bulk Fuel Receipts
Passengers Transported
After Hours Soldier Shuttle Passenger Count
Soldier Recovery Unit (SRU) Passenger Count
DRC Shuttle

NOTES:

Customer Driver Support Report Customer Report

Employee # Last name First name Date Hourly Rate Total Hours Total Cost Unit Assign Billing Code Trans # Function Overtime Hours Overtime Cost Total

SUMMARY
UNIT ASSGNBilling CodeFUNCTIONTOTAL HRSTOTAL COST

TOTAL REIMBURSEMENT

Vehicle Accident Log

Vehicle Accident / Incident / Damage Log YYYY
#Bumper#GSA Tag #UnitAccident DateDate ReportedEstimate of RepairClassificationDescription of AccidentUnit POCRepairs CompleteFinal BillDriver ResponsibleRemarks
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

Lost Stolen GSA Credit Card

Lost/Stolen GSA Fuel Credit Card Report
Month
Bumper #GSA #UnitDate Notified by UnitDate Reported to GSADate Reported to COR/QAEBrief DescriptionAction Taken

GSA Vehicle Listing Report

GSA Vehicle Listing Report
Bump #GSA #Lic 1Lic 2Date of
Last RotationOrganizationSub-OrganizationAccessoriesFuelSize Fuel
Tank GallonsLin #DescriptYearMakeModelColor
Of VehicleRegistrationDate
ReceivedDate
JustifiedMonthly
RateAddl
RateMile
RateFuel
SurchargeAFV ChargeTotal

Monthly

RateDaily
RateCLSH/R

Vehicle Value H/R Credit Card Value Keys GSA/Leased Mission Function Billing Code LHS/ADMIN 10/2019 OD 11/2019 OD 12/2019 OD 01/2020 OD 02/2020 OD 03/2020 OD 04/2020 OD 05/2020 OD 06/2020 OD 07/2020 OD 08/2020 OD 09/2020 OD BOAC Serial Number FED CODE

OD - Odomoter

Vehicle Inventory

Vehicle Inventory Report
Lin #GSA VEH# LRC FUNDED BASE OP GSA VEH# LRC FUNDED OCO GSA VEH# REIM GSA VEH# COMM LEASED VEH# ARMY OWNEDTOTAL TMP VEH

Petroleum Issue Report

Petroleum Issue Report
MONTHLY ABSTRACT OF ISSUES OF PETROLEUMPOST, CAMP OR STATIONMONTHVOUCHER NO.
PRODUCTS AND OPERATING SUPPLIESFort Hood Transportation Motor Pool
For use of this form, see AR 703-1: the proponent agency is DCSLOG
GALLONS ISSUEDGALLONS RECEIVED
MG1JP8DF2OTHEROTHEROTHERMG1JP8DS2OTHEROTHEROTHEROTHER
abcdefghIjklm
1000000
2000000
3000000
4000000
5000000
6000001,031
7000000
8000000
9000000
10000000
11000000
12000000
13000000
14000000
15000000
16000000
17000000
18000000
19000000
20000000
21000000
22000000
23000000
24000000
25000000
26000000
27000000
28000000
29000000
30000000
1 MAY 2019000000
TOTAL0000000000000
TOTAL GAL0000000000000
SIGNATURE OF ACCOUNTABLE PROPERTY OFFICERGRADEPOSTED TO STOCK RECORD ACCOUNT BYDATE
To convert oil, lubricating to gallons, divide total quarts by 4. To convert gear lube to gallons, divide total pounds by 71/2.
DA FORM 3644

Vehicle Reimbursable Report

Vehicle Reimburseable Report
Bumper #License #Start DateEnd DateTotal DaysOrganizationDescriptionVendor NameRate Per Day / Month or Hourly Vehicle CostVehicle CostMileage RateMiles DrivenMileage CostBilling CodeTotal Cost

TOTAL REIMBURSEMENT

Vehicle Maintenance Log

Vehicle Maintenance Log
BUMPERNOGSANOWORKORDER NO.DISCREPANCYDISCREPANCY1TYPEVENDORODOMETERSTART DATEDATE PICKED UPTOTAL DAYS

Vehicle Rotation Plan

Vehicle Rotation Plan
BumperGSAReplaced ByRotationOrganizationSuborganizationDescriptYearMakeModelColor of VehicleRegistrationDate ReceivedDate JustifiedMissionWBS # / Billing CodeFunctionDisposition RecommendationTransfer To Serial Number
NoNoDate

Credit Card Vertification

Credit Card Vertification
Provide a memorandum that states verification of cards has been completed for the previous month. Include how many credit cards verified versus total number of credit cards assigned to TMP vehicles and the percentage of credit cards verified. List the vehicles that failed to dispatch which resulted in cards not verified. Credit cards that were verified what attempts were made to notify the customer. Ie. Emails, phone call.

Critical Vehicle Status Report

Critical Vehicle Status
Vehicle Bumper #Passenger CountVehicle ManufactureRadioStoragePM StatusMaintenace IssueOperational / Non OperationalMaintenace StatusLocationDate sent to vendor

Vehicle Mileage Report

Mileage Report
Bump #GSA #Lic 1Lic 2OrganizationSub-OrganizationDec 2019 OD ReadingJan 2020 OD readingJan 2020 Miles drivenBOAC Serial NumberFED CODE

Daily Commitment Log

Daily Commitment Log
TRANS NOSTATUSWANT DATEDUE DATEVEH. TYPEVEHICLE ASSIGNEDFUNCTIONCOMMITMENTUNIT ASSIGNEDUNIT OF SUPPORTDEPLOY TYPEFLIGHT NOREMARKSUW DRIVERNo. VEH.REQUESTOR NAMEPHONEDATE RECEIVEDLOCATION

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