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

XLSX spreadsheet 64 KB Posted

Attached to
EAGLE FORT CAMPBELL, KY W519TC-23-R-0022
Solicitation number
W519TC-23-R-0022
Issued by

About this file

This document provides formatting requirements and reporting templates for various transportation-related reports required under a federal contract. The reports include transportation statistical data, non-ASC customer work requests, vehicle accident logs, bus passenger logs, lost or stolen fuel credit card reports, CBL registers, wheels up/down reports, locomotive projected workload, and locomotive utilization. The reports must be submitted in Microsoft Excel format on a monthly, as-required, or immediate basis. Recipients include the Contracting Officer's Representative, Quality Assurance Evaluator, and installation personnel. The related federal contract opportunity is for transportation services at Fort Campbell, Kentucky under solicitation number W519TC-23-R-0022 issued by the Department of the Army Materiel Command Contracting Command at Rock Island Arsenal.

View the file

Other files

File Type Posted
B08 Attachment 0001 - PWS (24 Jul 23).pdf PDF
W519TC23R0022-0003.pdf PDF
B08 Solicitation_FCKY conformed thru Amendment 0003.pdf PDF
B08 Attachment 0001 - PWS (24 Jul 23).pdf PDF
B08 Attachment 0039 - Ft. Campbell Q&A2 Responses (27 Jul 23).xlsx XLSX spreadsheet
W519TC23R0022-0002.pdf PDF
B08 Attachment 0011 - Contract References Spreadsheet (18 Jul 23).xlsx XLSX spreadsheet
B08 Attachment 0038 - Ft. Campbell Q&A Responses (18 Jul 23).xlsx XLSX spreadsheet
B08 Attachment 0007 - Department of Labor Wage Determinations-SCA (27 Dec 22).pdf PDF
B08 Attachment 0015 - Subcontractor Cost Information Submission (18 Jul 23).pdf PDF
B08 Solicitation_FCKY conformed thru Amendment 0002.pdf PDF
B08 Attachment 0005 - Cost Price Matrix (18 Jul 23).xlsx XLSX spreadsheet
B08 Attachment 0002 - Staffing and Labor Mix_FCKY (31 Aug 22).xlsx XLSX spreadsheet
B08 Attachment 0001 - PWS (17 Jul 23).pdf PDF
W519TC23R0022-0001.pdf PDF
B08 Solicitation_FCKY.pdf PDF
B08 Attachment 0015 - Subcontractor Cost Information Submission (9 Feb 23).pdf PDF
B08 Exhibit A - DD1423-1.pdf PDF
B08 Attachment 0020 - PWS Annex D Environmental Requirements (24 Aug 22).pdf PDF
B08 Exhibit B - CDRL Listing.xlsx XLSX spreadsheet
B08 Exhibit F - MMD-02 MDRS Maintenance Report Format.XLSX XLSX spreadsheet
B08 Attachment 0025 - PWS Appendix A NON ASC_FCKY Classified Container (Safes) Maint_All Unit.pdf PDF
B08 Exhibit J - PM-09 Performance Management Review Format (version 16 Jun 20).pptx PPTX presentation
B08 Exhibit H - PM-08 GFE GFP CAP Format.xlsx XLSX spreadsheet
B08 Attachment 0023 - PWS Annex G MDRS PRS (1 Aug 22).pdf PDF
B08 Exhibit C - CD-02 Burn Rate Report V9.xlsx XLSX spreadsheet
B08 Attachment 0018 - PWS Annex B Supply PRS (1 Aug 22).pdf PDF
B08 Attachment 0019 - PWS Annex C Transportation PRS (2 Aug 22).pdf PDF
B08 Attachment 0011 - Contract References Spreadsheet (02 Mar 22).xlsx XLSX spreadsheet
B08 Attachment 0007 - Department of Labor Wage Determinations-SCA (26 Aug 22).pdf PDF
B08 Attachment 0003 - Performance Questionnaire (29 Jan 21).pdf PDF
B08 Exhibit E - MMD-01 Maintenance Report Format.xlsx XLSX spreadsheet
B08 Exhibit L - SS-01 Supply and Services Report Format.xlsx XLSX spreadsheet
B08 Attachment 0021 - PWS Annex E Definitions Acronyms Abbreviations (24 Aug 22).pdf PDF
B08 Attachment 0027 - PWS Appendix C NON ASC FCKY SDDC Deployable Container Maint_ITD.pdf PDF
B08 Attachment 0009 - Purchasing Invoicing Guide (9 Feb 23).pdf PDF
B08 Exhibit G - PM-01 Contractor Employee Information Format.xlsx XLSX spreadsheet
B08 Attachment 0010 - Blocked File Extensions (9 Feb 23).pdf PDF
B08 Attachment 0022 - PWS Annex F Publications and Forms (24 Aug 22).pdf PDF
B08 Exhibit K - PM-12 KTR Accident Reporting Format.xlsx XLSX spreadsheet
B08 Attachment 0001 - PWS (24 May 23).pdf PDF
B08 Attachment 0017 - PWS Annex A Maintenance PRS (16 Aug 22).pdf PDF
B08 Attachment 0013 - Mission Essential Contractor Services (22 Jun 22).pdf PDF
B08 Attachment 0002 - Staffing and Labor Mix_FCKY_ 31_AUG_22.xlsx XLSX spreadsheet
B08 Attachment 0026 - PWS Appendix B NON ASC FCKY 160th Fuel Lab Operations_ISD (3 Nov 22).pdf PDF
B08 Attachment 0004 - Letter of Consent (04 May 23).pdf PDF
B08 Attachment 0005 - Cost Price Matrix (5 May 23).xlsx XLSX spreadsheet
B08 Attachment 0006 - Preaward Survey of Prospective Contractor Accounting System (SF 1408).pdf PDF
B08 Attachment 0024 - PWS Annex H Government Property Incidental (27 Apr 23).pdf PDF
Show all 49

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 Exce1Monthly5th WorkdayCOR/QAE
2Non-ASC Customer Work RequestMicrosoft Exce1MonthlyMonthlyCOR/QAE
3Vehicle Accident LogMicrosoft Exce1MonthlyNOTIFY GOV PERSONNEL IMMEDIATELY WHEN ACCIDENT OCCURSCOR/QAE
4Bus Passenger LogMicrosoft Exce1Monthly5th WorkdayCOR/QAE
5Lost/Stolen GSA Fuel Credit Card ReportMicrosoft Exce1MonthlyNOTIFY GOV PERSONNEL IMMEDIATELY WHEN NOTIFIED OF LOST CARDCOR/QAE
6CBL RegisterMicrosoft Exce1Monthly5th WorkdayCOR/QAE
7Wheels Up/Down ReportMicrosoft Exce1As RequiredWithin 2 hours from wheels up/downCOR/QAE/UMC and IOC
8Locomotive Projected Workload For The InstallationMicrosoft Exce1Monthly5th WorkdayASC, 407th, COR, ITO
9Locomotive UtilizationMicrosoft Exce2Monthly5th WorkdayASC, 407th, COR, ITO

Transportation Statistical

Transportation Statistical Data
Functional AreaUnitDec-14Jan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15TotalDifference% increase/ decrease
Transportation Motor Pool
Extended Dispatch Vehicles
Vehicles on Dispatch to Authorized CustomersNumber

General Dispatch Vehicles Number

Bus Support (incl driver; do not include Non-ASC Customer or WTU Trips )
Shuttle Bus RidersNumber

Troop Lift Support Riders Number

Tractor/Trailer Support (incl driver)

Vehicles Coordinated for Maintenance Number

Licenses (Non-ASC Customer Service)
Requests ReceivedNumber

Licenses Issued Number

Passenger Travel/Movements
Number of Moves Processed for Charter Bus SupportNumber

Individual Passengers Moved by Commercial Bus (Govt Ticket) Number

Passengers Moved by Air Travel Number

Portcalls Processed Number

Govt Transportation Requests (GTR) Issued Number

Personal Property Movements
Customers Counseled on EntitlementsNumber

Outbound Shipments (DPS and TOPS) Number

Army Shipments Inspected (In-person/Face to Face) Number

Army Shipments Inspected (Virtual and/or Telephonic) Number

Joint Service (Non-Army) Shipments Inspected (In-person/Face to Face) Number

Joint Service (Non-Army) Shipments Inspected (Virtual and/or Telephonic) Number

Inbound Shipments (DPS and TOPS) Number

Diverted Shipments Number

DITY Moves Counseling Number

DITY Computations for Finance Number

Local Drayage Moves Processed (DPM) Number

Entitlement Extensions Coordinated Number

HHG and NTS TAC/LOA Verifications Number

Certified Storage Expiration Letters Coordinated with Trans Officer Number

Storage Extensions (Inbound&NTS) Coordinated Number

POV Storage Actions Processed Number

Reimbursements Coordinated Number

Excess Cost Calculations Prepared Number

Collection Actions Prepared Number

Retirement/Separations/etc. Briefings Conducted Number

Reweighs Processed Number

Outbound Freight Shipments
Shipping Documents Received from CustomersNumber

CBLs Processed Number

Small Packages Processed Number

Rail Moves Processed (number of CBL Included with CBL Processed above) Number

Outbound Shipments picked up on schedule (CBL + Small package) Number

Total Shipped Pounds

Route Requests Processed to SDDC on DD Form 1085 Number

Equipment Load Plans Prepared Number

Transportation Discrepancy Reports Processed Number

REPSHIPS for AA&E Number

REPSHIPS completed within 2 hours of shipment departure Number

AA&E Shipments requiring TDRs Number

AA&E Shipment TDRs completed within 24 hours Number

Movement Automation
RFID/CCID Tags WrittenNumber

HAZMAT Documents Reviewed Number

Military Shipping Labels Created Number

Deployment Assets inventoried (number of items on hand) Number

MPA OPS
MPA OPS SupportedNumber

Rolling Stock Inspected Number

Air Load OPS
Air Load Missions ConductedNumber

Air Load Plans Processed Number

Joint Inspections Performed Number

MHE Support
MHE Unit Movements SupportedNumber
Container OPS
Container Inspections for packing (unit)Number

Container Work Orders Submissions Number

Containers Moved (by Rail, Truck, etc?) Number

NOTES:

Non-ASC Work Req Non-ASC Customer Work Request

3/1 IBCT
REDEPLOYMENT (OCP T/I)
OCO FUNDED

Item Total # Hours/ Buses Cost Per Total Daily Cost Miles Cost per Mile Mileage Cost Overtime Hours Overtime Cost Total

Vehicle Accident Log

Vehicle Accident / Damage Log YYYY
#UnitGSA Tag #Accident DateDate ReportedEstimate of RepairClassificationDescription of AccidentPOC DD Form 200Repairs 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

Bus Passenger Log

Daily Bus Passenger Log
Month/Year
#DateData Entry In/Start TimeData Entry End TimeTimePickup
LocationDestination
LocationMiles
UsedTotal
PaxTMP DriverOtherComment
1
2
3
4
5
6
7
8
9
10
11

Lost Stolen GSA Credit Card

Lost/Stolen GSA Fuel Credit Card Report
Month
UnitVehicle Tag NumberDate Notified by UnitDate Reported to GSADate Reported to COR/QAEBrief DescriptionAction Taken

CBL Register

CBL Register (there are multiple tabs to include Small Package)
CategoryLoad TypeCBL#CBL Creation DateSCACFort/ OriginFort/ DestinationUnitWGTCostPCSDOCsCBLsPick Up on TimeSecureCXLTCMDRoute ReqInitials

Wheels Up Down Report

Wheels Up Down Report
Reporting Installation:POC:
Air Field:Inbound Freight:
Mission Number:Type Aircraft:
Tail #:POE:POD:
Actual Departure (Wheels Up):Actual Arrival (Wheels Down):
DTG (Zulu Time)DTG (Zulu Time)
Actual Cargo Totals
Total PAXTotal CargoType of Cargo

PAX S-tons Cargo S-tons

ULN

ULNs that were closed out:

Unit

Locomotive Projected Workload

Locomotive Projected Workload For The Installation
30 Days
Projected WorkloadDatesDest
60 Days
Projected WorkloadDatesDest
90 Days
Projected WorkloadDatesDest
120 Days
Projected WorkloadDatesDest
Past Moves
Completed WorkloadDatesDest
Intraplant Switches
Completed WorkloadDatesDest

Locomotive Utilization

Locomotive Number XXX Utilization
Put Into Service On DDMMMYY
Current Hours (Date)Last Hours (Date)Hours UsedFuel (gals)Miles as of Date
Gen 1Gen 1CurrentCurrent
Gen 2Gen 2LastLast
Gen 3Gen 3UsedTotal
IssuesDate ReportedPOC
No Pno roblems
Corrected Issues
IssueReportedCorrectedFixed by
Abnormal Occurrences
IssueFirst Date NotedFrequency

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