2 - Attachment D.3.6 - Monthly Transportation Invoice.xlsx

XLSX spreadsheet 32 KB Posted

Attached to
Third Party Logistic (3PL) Services Federal contract opportunity
Solicitation number
12-3J14-18-S-0096
Issued by
Department of Agriculture Agricultural Marketing Service Washington Office

About this file

From the source

Solicitation attachment.

View the file

Other files for this federal contract opportunity

Other files attached to Third Party Logistic (3PL) Services, newest first.
File Type Posted
Attachment_D.1_-_Schedule_of_Items_(A02).xlsx XLSX spreadsheet
Amendment_A02.pdf PDF
Amendment_A01.pdf PDF
Attachment_D.6_-_Temp__Humidity_Req_(A01).xlsx XLSX spreadsheet
2 - Attachment D.14 - Annual Subcontracting Plan Form.doc DOC document
2 - Attachment D.3.5 - Bi-Monthly Storage Invoice.xlsx XLSX spreadsheet
2 - Attachment D.8 - CSFP Foods Available List.xlsx XLSX spreadsheet
2 - Attachment D.10 - How Contract CLIN Values Determined.xlsx XLSX spreadsheet
2 - Attachment D.3.7 - Reporting Template with References.xlsx XLSX spreadsheet
2 - Attachment D.12 - Contractor's Nondisclosure Statement.docx DOCX document
2 - Attachment D.15 - WBSCM Requirements.docx DOCX document
2 - Attachment D.1 - Schedule of Items.xlsx XLSX spreadsheet
2 - Attachment D.3.3 - Bi-Monthly Transaction_Handling Invoice.xlsx XLSX spreadsheet
2 - Attachment D.4 - FRGRA.xlsx XLSX spreadsheet
2 - Attachment D.3.2 - Monthly Inventory Aging _Hold Report.xlsx XLSX spreadsheet
2 - Attachment D.7 - FIDPR Foods Available List.xlsx XLSX spreadsheet
2 - Attachment D.9 - Recipient Agencies.xlsx XLSX spreadsheet
2 - Attachment D.13 - Sample Past Performance Letter and Questionnaire.docx DOCX document
2 - Attachment D.5 - Sched of Deducts.xlsx XLSX spreadsheet
2 - Attachment D.9 - Recipient Agencies - At Award.xlsx XLSX spreadsheet
1_-_Solicitation.pdf PDF
2 - Attachment D.3.4 - Monthly Inventory Adjustment Report.xlsx XLSX spreadsheet
2 - Attachment D.11 - Sample Advanced Shipping Notice.docx DOCX document
2 - Attachment D.6 - Temp & Humidity Req.xlsx XLSX spreadsheet
2 - Attachment D.2 - PWS.xlsx XLSX spreadsheet
2 - Attachment D.3.1 - Monthly Floor Loaded Handling Invoice.xlsx XLSX spreadsheet
Show all 26

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
Try for free Login

Text version

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

Information D3.6 Monthly Transportation Invoice

Information
Due Date:7th Working Day After End of the Prior Month.
No later than 4:00 p.m. central time zone (Kansas City, MO).

Number of Copies: 3 electronic copies of Invoice with supporting documentation and 1 hard copy of the Invoice.

Format:When electronic copies are specified, they shall be submitted on a CD
Microsoft Excel file (Excel version 2013 compatible). Each report shall be contained in a separate folder.
D3 Monthly Transportation Invoice supporting documentation (e.g. outbound BOL/POD, related emails, etc.)
shall be contained in a separate file. Each transportation transaction shall be segregated with its own supporting documentation.
Deliver Reports To:Contracting Officer: One electronic copy of Invoice with supporting documentation
AMS/COR: One electronic copy of Invoice with supporting documentation and one hard copy of the Invoice.
FNS/COR: One electronic copy of Invoice with supporting documentation.

Reporting Period: Prior Month

Header Sort Support Docs D3.6 Monthly Transportation Invoice

Header Information Requirements for Reports/Invoices

1Contractor Name & Business Address (include sub-organization name, room number or mail stop if applicable)
2Contract Number
3Task Order Number
4Title of Report (include copy and/ or version number)
5Point of Contact (include name, title, and phone number)
6Include Page Numbers (sequential) on all reports
7Reporting Period
8Contractor's Invoice Number
9Date of Invoice
10Contractor's Ship To # Entity 4-50xxx (this will be provided at post award conference)

Note: All Invoices/Reports require Contractor's Certification in accordance with Section C.1.

SORT SEQUENCE:

1By program (FDPIR or CSFP)
2By shipping date
3By BOL
4By Multi Stop Truckload Identifier

SUPPORTING DOCUMENTATION TO BE SUBMITTED WITH EACH REPORT:

1Copy of each outbound BOL from contractor’s facility to the Recipient Agency(ies) and/or any destination
assigned by USDA with the following data on each BOL:
aName of Recipient Agency with WBSCM “Ship To #”; City, State and Zip Code located
bWBSCM Requisition Number
cWarehouse Lot number for each commodity ordered, with its corresponding
inbound PO and PO line item numbers and PR numbers.
dWBSCM Material Code and Commodity Description
eNumber of units/cases for each lot shipped
fSignature of carrier with date carrier accepts load from contractor’s facility
gWBSCM RA's Regular Scheduled Delivery Date (RSDD)
hSignature of Recipient Agency with date commodity is received notating any over, short and damaged commodities
iTotal gross weight for shipment and total number of pallets outbound
2Multi- Stop truckload BOLs in same pdf file
3Copy of applicable emails

Specific Data Req D3.6 Monthly Transportation Invoice

SPECIFIC DATA REQUIRED:

1CLIN number (for the specific transportation charge 0006-0009)
2For each shipment:
Identify the WBSCM programCSFP or FDPIR
WBSCM Req #
BOL #
Multi-Stop Truckload IdentifierOne unique number per multistop truckload
Stops1, 2 or 3( Final Stop = F)
Ship Date
WBSCM Regular Scheduled Delivery Date( RSDD)
Actual Delivery Date
RA WBSCM Ship to #WBSCM number ( i.e. "5001991")
Recipient Agency Name
Destination City
Destination State
Destination Zip Code
Shipment Gross weight
Temp or Dry
LTL or Truckload
Route Lane Miles
Out of Route Miles
Total Shipment Miles
Route Lane Identifier
Route Lane Rate$ per Truckload or LTLClin 6*
Out of Route Rate$/MileClin 7
Out of Route AmountClin 7*
FSurCH Rate
FSurCH AmountColumn Y= R*X , if OORR or Q*X if RLMilesClin 9*
Stop-Off chargeClin 8*
Total for shipment
Grand Total for movement
3Totals Page - Subtotals and Grand totals should only be shown on separate report page
Sub totals by program for Clin 6*, Clin 7*, Clin 9*, Clin 8*
Grand Total by Program
Example for Multi-stop Truckloads Invoicing:
1st stop Invoice charges =Out of route miles charge + fuel surcharge (Out of Route miles x fuel surcharge) + Stop off charge ($150.00)
If 2nd stop Invoice charges =Out of route miles charge + fuel surcharge (Out of Route miles x fuel surcharge) + Stop off charge ($150.00)
Final destinationRoute Lane Rate + fuel surcharge(route lane miles x fuel surcharge)

Transportation Template

D3.6 Monthly Transportation Invoice_YYYY<Month>
TEMPLATE
Header Information
Clin 6*R*VR*X=OORR
MultiTL/LTLClin 7Clin 7*Q*X= RLM
StopWBSCMTempLTLRouteOutTotalRouteRouteOut ofOut ofClin 9*Clin 8*
WBSCMWBSCMTruckloadWBSCMActualRARADestinationZipororLaneof RouteShipmentLaneLaneRouteRouteFSurChFSurChStop-OffGrand Total
ProgramReq #BOLIdentifierStopsShip DateRSDDDel DateShip to #NameCityStateCodeGr WtDryTrkloadMilesMilesMilesIdentifierRateRateAmountRateAmountChargeTotal(on last stop)
CSFP10002561734570110050112/10/172/15/172/15/175000753Top FoodbkToppenishWA500TempTL085$0.00$2.00$170.00$0.30$25.50$150.00$345.50
CSFP100025620045703100501F2/10/172/16/172/16/175005279Port FBKPortlandOR500TempTL4150500xxxxxxx$900.00$2.00$0.00$0.30$124.50$0.00$1,024.50$1,370.00
CSFP100025620445704F2/13/172/18/172/17/175001023BR FoodbkBaton RougeLA5000TempTL9060906xxxxxxx$1,000.00$2.00$0.00$0.30$271.80$0.00$1,271.80$1,271.80
CSFP10002562054570510050212/20/172/25/172/25/175000283Sike FdbkSikestonMO500TempTL0130$0.00$2.00$260.00$0.30$39.00$150.00$449.00
FDPIR10003457866579302100502F2/20/172/27/172/27/175000599ITOSault Ste MarieMI8000TempTL106001190xxxxxxx$2,000.00$2.00$0.00$0.30$318.00$0.00$2,318.00$2,767.00
CSFP100025623145710F2/25/172/28/172/26/175001191Spok FdbnkSpokaneWA800TempTL5050xxxxxxx$1,200.00$2.00$0.00$0.30$151.50$0.00$1,351.50$1,351.50

File details come from the government source that posted it.