Exhibit K ITD-01 Transportation Report Format.xlsx

XLSX spreadsheet 65 KB Posted

Attached to
EAGLE Detroit, MI W519TC-24-R-0006
Solicitation number
W519TC24R0006
Issued by

About this file

Written by GovTribe AI ·

This document contains templates and reporting formats for various transportation-related reports required under a federal contract for maintenance, supply, and transportation services. Key reports include a transportation statistical data report, non-ASC customer work request log, vehicle accident log, bus passenger log, lost/stolen GSA fuel credit card report, CBL register, wheels up/down report, locomotive projected workload report, and locomotive utilization report. The reports require data on transportation assets, passenger travel, maintenance activities, fuel usage, cargo shipments, and accident reporting. They must be submitted in Microsoft Excel format on a regular monthly, annual, or as-needed basis to the contracting officer's representative and quality assurance evaluator. The related federal contract opportunity is for maintenance, supply, and transportation services at Detroit Arsenal, Michigan under solicitation number W519TC24R0006 issued by the Department of the Army Materiel Command Contracting Command at Rock Island Arsenal.

View the file

Other files

File Type Posted
B08 Amendment 0003 W519TC-24-R-0006(13MAR24).pdf PDF
B08 Amendment 0002 W519TC-24-R-0006 (06MAR24).pdf PDF
B08 Amendment 0001 W519TC-24-R-0006.pdf PDF
Exhibit A DD Form 1423.pdf PDF
Attachment 0005 - Cost Price Matrix (DTA).xlsx XLSX spreadsheet
Exhibit D PM-01 Contractor Employee Information Format.xlsx XLSX spreadsheet
Attachment 0002 Staffing and Labor Mix.xlsx XLSX spreadsheet
Attachment 0019 Annex C Transportation PRS.pdf PDF
Attachment 0014 - NOT APPLICABLE.pdf PDF
Attachment 0021 Annex E Definitions - Acronyms - Abbreviations.docx DOCX document
Attachment 0015 - Subcontractor Cost Information Submission_09 MAY 23.pdf PDF
Exhibit B CDRL Listing Updated Format.xlsx XLSX spreadsheet
Exhibit F PM-09 Performance Management Review Format.pptx PPTX presentation
Attachment 0017 Annex A Maintenance PRS.pdf PDF
Attachment 0018 Annex B Supply PRS.pdf PDF
Exhibit C CD-02 Burn Rate Report Format.xlsx XLSX spreadsheet
Attachment 0009 - Purchasing Invoicing Guide (PIG).docx DOCX document
Exhibit E PM-08 Scheduled Government Furnished Property (SGFP).xlsx XLSX spreadsheet
Exhibit J SS-01 Supply and Services Report Format.xlsx XLSX spreadsheet
B08 Solicitation - W519TC24R0006.pdf PDF
Attachment 0013 Mission Essential Contractor Services.pdf PDF
Attachment 0023 - NOT APPLICABLE.pdf PDF
Attachment 0012 - NOT APPLICABLE.pdf PDF
Attachment 0011 Contract References Spreadsheet_29 JUN 2023.xlsx XLSX spreadsheet
Attachment 0020 Annex D Environmental Requirements.docx DOCX document
Attachment 0006 - SF1408 Preaward Survey of Prospective Contractor Accounting System.pdf PDF
Attachment 0010 - Blocked File Extensions.pdf PDF
Attachment 0004 - Letter of Consent.docx DOCX document
Exhibit H MMD-07 Maintenance Report Format.xlsx XLSX spreadsheet
Attachment 0022 Annex F Publications and Forms.docx DOCX document
Attachment 0003 - Performance Questionnaire.docx DOCX document
Exhibit G PM-12 KTR Accident Reporting Format.xlsx XLSX spreadsheet
Attachment 0001 PWS.pdf PDF
Attachment 0007 Wage Determination (2015-4867).pdf PDF
Show all 34

On GovTribe

Work with this file

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

Text version

The file's text, extracted by GovTribe without its formatting.

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, 404th, COR, ITO
9Locomotive UtilizationMicrosoft Exce2Monthly5th WorkdayASC, 404th, 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 .