Attachment 4 Weekly Shipment Detail Report.xlsx

XLSX spreadsheet 289 KB Posted

Attached to
Medical Freight Transportation Federal contract opportunity
Solicitation number
SP4701-22-R-0029
Issued by
Defense Logistics Agency

About this file

This document includes a weekly shipment detail report template and information about a medical freight transportation solicitation. The report template provides instructions for carriers to track shipments under the Defense Logistics Agency contract by entering pickup, delivery, and status details for shipments originating from locations in Korea. The related solicitation seeks transportation services for ambient and HAZMAT medical cargo shipments to locations outside the continental U.S., including Hawaii, Alaska, Puerto Rico and Guam, for shipments over 300 pounds. Interested offerors must submit proposals by November 10, 2022, and any questions are due by November 4, 2022. In addition to standard carriers, proposals may also be submitted through public-private partnerships with designated agents that have established transportation infrastructure. The awarding agency is the Defense Logistics Agency.

View the file

Other files for this federal contract opportunity

Other files attached to Medical Freight Transportation, newest first.
File Type Posted
Amendment 01-RFP SP4701-22-R-0029.pdf PDF
Tab 1 - JnA - Medical Freight Transportation-_Redacted.pdf PDF
Amendment 01-SP4701-22-R-0029-Questions and Answers.xlsx XLSX spreadsheet
Amendment 01-RFP SP4701-22-R-0029.pdf PDF
Attachment Z - VPAT.docx DOCX document
Attachment 5-Pricing Structure Template-.xlsx XLSX spreadsheet
Final Draft - Pricing Structure Template - Medical Freight Transportation Contract.xlsx XLSX spreadsheet
Attachment 3 Expeditious Routing Matrix.xlsx XLSX spreadsheet
Attachment 5 Pricing Structure Template.xlsx XLSX spreadsheet
Attachment 2 Point of Contact Listing.docx DOCX document
Attachment 7 - Past Performance Template.docx DOCX document
RFP SP4701-22-R-0029 Medical Freight Transportation.pdf PDF
Attachment 1 Authorized Negotiator Letter.docx DOCX document
Attachment 6 Escalation Rate Template.xlsx XLSX spreadsheet
Show all 14

On GovTribe

Work with this file on GovTribe

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

Text version

Instructions

WEEKLY SHIPMENT DETAIL REPORT
>Carriers shall make timely entries in gray columns A-G and I-Q.
>Carriers may make entries in gray columns Y-AA.
>Cells with white fill contain locked, conditional formulas that key off of carrier entries in the gray cells.
>Since Okinawa requires different transit times then mainland Japan, and is billed at a different rate, the OKAA and OKAH CLINS will fill in the country column with Okinawa even though it is not a country. This is not an error.
>Any errors or inconsistencies in the file integrity should be reported to DLATroopSupportMedicalTransportation@dla.mil
>CLIN details can be referenced on the CLINs tab. This tab is being referenced by the formulas and is read only.

Performance Tracking

SCACCLINPiecesChargeable Weight (LB)Actual Weight (LB)Prime Vendor OriginDestinationCountryBOL #TCNTSP's HAWB #MAWB# (xxx-xxxxxxxx)PICK UP DATETransferred to AirlineTransferred to Delivery CarrierDELIVERY DATESHIPMENT STATUSIATA 3 digremainder of MAWBLinkRequired Transit Time (Days)Current Days in TransitDelta from RDDStatus:NOTES/COMMENTS/UPDATESDELAY CODEDATE DISCREPANCY RESOLVEDtoday is-9/7/22
TSPAKORA213961005CARDINAL WESTCAMP CARROLL, KRKorea6300003949WT4J8S213803760XXSAXRTSM08044369-845443909/2/229/3/22IN TRANSIT36984544390Atlas550…in transit

ICI

HOL

HOL

HOL

CUS
HOL

HOL

HOL
HOL

HOL

HOL

HOL
HOL

HOL

HOL

HOL

HOL

HOL

HOL

HOL
HOL
HOL

HOL

HOL

HOL

HOL

HOL

HOL
HOL
HOL
HOL

HOL

HOL

HOL

HOL

HOL

CUS
HOL
HOL
HOL

HOL

HOL

HOL
HOL
HOL
HOL
HOL

HOL

HOL
HOL
HOL
HOL

HOL

IEX

HOL
IEX
HOL

HOL

CUS

IEX

HOL

HOL
HOL
HOL

HOL

HOL
HOL

CUS

HOL

HOL

CUS

HOL

IEX

HOL

HOL

IEX

HOL

CUS

HOL

CUS
CUS

CUS

CUS
CUS
HOL
CUS
CUS
DGP/CUS4/19/22

CUS

HOL
CUS

HOL

HOL
HOL/CUS

CUS

HOL

HOL

HOL

HOL

HOL

CUS
CUS

CUS

CUS

CUS
DGP

CUS

CUS

CUS

CUS

CUS
CUS

CUS

DGP

CUS

CUS

CUS

3/28/22

3/28/22

CUS

DGP
DGP

ICI

SRC

CUS

3/17/22

SRC

C2

C2
C2
C2
C2
C2
C2
C2

C2

C2

C2
C2
C2
C2

CUS

CUS

CUS
CUS
CUS
CUS

CUS

CUS

CUS

CUS
CUS
CUS
CUS

CUS

CUS
CUS
C2
C2
C2
C2
CUS

CUS

CUS

C2

C2

C2
CUS
C2

CUS

CUS

CUS

CUS
CUS
C2
CUS

C2

C2
CUS
C2
C2
CUS
C2
C2
CUS
C2
C2

C2

C2
C2

C2

C2
C2
C2
C2
C2
C2

C2

C2
C2
C2

C2

C2
C2
C2

C2

C2
C2

C2

C2

C2

DGP 2/11/22

CUS

C3

C2

C2

C2

RSC

C2

CUS

DGP

CUS 2/4/22

C2

C2

C2

C2

C2
HOL
C2
HOL
C2
HOL
C2
C2

C2

DGP

C2

C2

C2
HOL
HOL

DGP 2/7/22

C2

HOL

HOL

U2

HOL

HOL

CUS

CUS

DGP/WEA

This is the start of the file's text. The full file is on GovTribe.

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