Attachment 4 Weekly Shipment Detail Report.xlsx

XLSX spreadsheet 291 KB Posted

Attached to
Medical Freight Transportation (MFT) 2. 0
Solicitation number
SP4701-26-R-0004
Issued by

About this file

The file is an Excel spreadsheet titled "Attachment 4 Weekly Shipment Detail Report" related to the Medical Freight Transportation (MFT) 2.0 solicitation (SP4701-26-R-0004) issued by the Defense Logistics Agency (DLA) Troop Support Medical Supply Chain. The solicitation requires international commercial air cargo services for less-than-full planeload shipments to authorized users, encompassing complex transportation logistics for various cargo types including regular, hazardous, refrigerated, life-critical, oversized, and controlled narcotic shipments to locations outside the Continental United States (OCONUS).

The transportation services must include comprehensive logistics capabilities such as time-definite door-to-door pick-up and delivery, in-transit visibility (ITV), government-approved third-party payment system participation, and expedited customs processing and clearance. While the specific Excel attachment appears to be a weekly shipment tracking template, it is directly linked to the broader solicitation for medical supply chain transportation services, indicating a detailed operational tracking mechanism for managing international medical cargo movements.

View the file

Other files

Show all 14

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

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 #Airline MAWB# (xxx-xxxxxxxx)PICK UP DATETransferred to AirlineCustoms Clearance DateTransferred 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-6/17/25
TSPAKORA213961005CARDINAL WESTCAMP CARROLL, KRKorea6300003949WT4J8S213803760XXSAXRTSM08044369-845443909/2/229/3/22IN TRANSIT36984544390Atlas510191014…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 .