2 - Attachment D.3.5 - Bi-Monthly Storage Invoice.xlsx

XLSX spreadsheet 30 KB Posted Feb 8, 2018

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	Mar 7, 2018
Amendment_A02.pdf	PDF	Mar 7, 2018
Amendment_A01.pdf	PDF	Feb 27, 2018
Attachment_D.6_-_Temp__Humidity_Req_(A01).xlsx	XLSX spreadsheet	Feb 27, 2018
2 - Attachment D.14 - Annual Subcontracting Plan Form.doc	DOC document	Feb 8, 2018
2 - Attachment D.8 - CSFP Foods Available List.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.10 - How Contract CLIN Values Determined.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.3.7 - Reporting Template with References.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.12 - Contractor's Nondisclosure Statement.docx	DOCX document	Feb 8, 2018
2 - Attachment D.3.6 - Monthly Transportation Invoice.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.15 - WBSCM Requirements.docx	DOCX document	Feb 8, 2018
2 - Attachment D.1 - Schedule of Items.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.3.3 - Bi-Monthly Transaction_Handling Invoice.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.4 - FRGRA.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.3.2 - Monthly Inventory Aging _Hold Report.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.7 - FIDPR Foods Available List.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.9 - Recipient Agencies.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.13 - Sample Past Performance Letter and Questionnaire.docx	DOCX document	Feb 8, 2018
2 - Attachment D.5 - Sched of Deducts.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.9 - Recipient Agencies - At Award.xlsx	XLSX spreadsheet	Feb 8, 2018
1_-_Solicitation.pdf	PDF	Feb 8, 2018
2 - Attachment D.3.4 - Monthly Inventory Adjustment Report.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.11 - Sample Advanced Shipping Notice.docx	DOCX document	Feb 8, 2018
2 - Attachment D.6 - Temp & Humidity Req.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.2 - PWS.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.3.1 - Monthly Floor Loaded Handling Invoice.xlsx	XLSX spreadsheet	Feb 8, 2018

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.5 Bi-Monthly Storage Invoice as of 16th or 1st

Information

Email Due Dates:	Bi- Monthly Storage Invoice for Reporting Period 1st day through midnight on 15th day of month is
	due the 16th calendar day of the month by noon central time (2 weeks of reporting).
	If the 16th day of the month falls on a weekend or federal holiday, then report is due by noon central time the next business day.
	Note: 1st reporting period will be used for informational purposes, not for billing.

Bi- Monthly Storage Invoice for Reporting Period 16th day through midnight on last day of month is

due the first calendar day of the next month by noon central time (4 weeks of reporting; 2 periods).

If the first day of the month falls on a weekend or federal holiday, then report is due by noon central time the next business day.

Note: Second reporting period information should be added to first period and submitted for the whole month.

Note: These Bi-Monthly Reports submitted by email on each due date will not be paid against until supporting documents are received

with other reports/invoices after the end of the reporting month.

Number of Copies: See below

Format: Microsoft Excel file (Excel version 2013 compatible).

Deliver Reports To: Send Report as Email attachment to CO, AMS CORs, and FNS CORs

Reporting Periods:
	Reporting Period #1:	1st day of month through midnight on the 15th day of month
	Reporting Period #2:	16th day of month through midnight on the last day of month

Combined Bi-Monthly Storage Invoice submitted for the entire month

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 in
	Microsoft Excel file (Excel version 2013 compatible). Each report shall be contained in a separate folder.

Transactional information supporting Inventory positions for D3 Bi-Monthly Storage Invoice resides in D3 Bi-Monthy Transaction Report and Handling Invoice

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

Note: Bi-monthly means twice per month.

Note: Submit Bi-Monthly Reports by email by due dates and a Combined Bi-Monthly Storage Invoice for the entire Month.

Header Sort Support Docs D3.5 Bi-Monthly Storage Invoice as of

Header Information Requirements for Reports/Invoices

1	Contractor Name & Business Address (include sub-organization name, room number or mail stop if applicable)
2	Contract Number
3	Task Order Number
4	Title of Report (include copy and/ or version number)
5	Point of Contact (include name, title, and phone number)
6	Include Page Numbers (sequential) on all reports	( i.e. 1 of 200)
7	Reporting Period
8	Contractor's Invoice Number
9	Date of Invoice
10	Contractor's WBSCM 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:

1	By program (CSFP or FDPIR)
2	WBSCM Material Code and Commodity Description
3	Warehouse Lot Number
4	Invoice Period

SUPPORTING DOCUMENTATION TO BE SUBMITTED WITH EACH REPORT:

1	Copy of inbound BOL with carrier’s signature and date (date carrier receipted for the load) and
	warehouse’s signature and date (date commodity received at contractor’s facility) with cases received.
2	Number of Pallets
3	Copy 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:
	a	Name of Recipient Agency with WBSCM “Ship To #”; City, State and Zip Code located
	b	WBSCM Requisition Number
	c	Warehouse Lot number for each commodity ordered, with its corresponding
		inbound PO and PO line item numbers and PR numbers.
	d	WBSCM Material Code and Commodity Description
	e	Number of units/cases for each lot shipped
	f	Signature of carrier with date carrier accepts load from contractor’s facility
	g	WBSCM RA's Regular Scheduled Delivery Date (RSDD)
	h	Signature of Recipient Agency with date commodity was received notating any over, short and damaged commodities
	i	Total gross weight for shipment and total number of pallets outbound
4	Copy of applicable emails.

Specific Data Req D3.5 Bi-Monthly Storage Invoice as of

SPECIFIC DATA REQUIRED: NOTE: The Excel file should be named "D3 Bi_Monthly Storage Invoice_yyyy". A tab should be created for each month and labeled accordingly. Each tab will contain information from both the 1st and 16th billing periods for that month. Cell I1 on the template should also list the month being reported.

1	WBSCM Program
2	WBSCM Material Code
3	WBSCM Commodity Description
4	Warehouse Lot Number
5	WBSCM PO Number
6	WBSCM PR Number
7	Receipt Date
8	Manufacturing Date
9	BIUB Date
10	Month
11	Invoice Periods	16th or 1st
12	Case Balance	Case count total ending midnight 15th or midnight last day of month
13	Billing Number of Pallets	Pallet count total ending midnight 15th or midnight last day of month (rounding up to full pallet)
14	Storage Clins (3, 4 or 5)
15	Storage Rate per Pallet	Half month storage rate (24 periods per year)
16	Storage Amount	for 16th or 1st
17	Totals Page:
	Storage Amount and Number of Billed Pallets Totals by program for Clin 3, Clin 4, and Clin 5
	Grand Total by Program for Storage Amount and Number of Billed Pallets

Bi-Monthly Storage Invoice D3.5 Bi-Monthly Storage Invoice Report YYYY <Month>

														Half-Month
	WBSCM	WBSCM	Warehouse	WBSCM	WBSCM							Billing	Storage	Storage
WBSCM	Material	Commodity	Lot	PO	PR	Receipt	Manufact	BIUB		Invoice	Case	Number	Clins	Rate per	Storage
Program	Code	Description	Number	Number	Number	Date	Date	Date	Month	Periods	Balance	Pallets	3, 4, or 5	Pallet	Amount
CSFP	100035	Cheese Reduced Fat	500357	41-24583-110	40-12345 -110	1/15/17	1/5/17	1/5/18	1	16th	1000	20	4	$15.00	$300.00
CSFP	100035	Cheese Reduced Fat	500357	41-24583-110	40-12345 -110	1/15/17	1/5/17	1/5/18	2	1st	1000	20	4	$15.00	$300.00
CSFP	100035	Cheese Reduced Fat	500357	41-24583-110	40-12345 -110	1/15/17	1/5/17	1/5/18	2	16th	582	12	4	$15.00	$180.00
CSFP	100035	Cheese Reduced Fat	500357	41-24583-110	40-12345 -110	1/15/17	1/5/17	1/5/18	3	1st	230	5	4	$15.00	$75.00
FDPIR	100001	Frozen Butter	500411	41-245900-1	40-12450-1	12/20/16	11/15/16	2/5/18	1	1st	2000	20	4	$15.00	$300.00
FDPIR	100001	Frozen Butter	500411	41-245900-1	40-12450-1	12/20/16	11/15/16	2/5/18	1	16th	2000	20	4	$15.00	$300.00
FDPIR	100001	Frozen Butter	500411	41-245900-1	40-12450-1	12/20/16	11/15/16	2/5/18	2	1st	2000	20	4	$15.00	$300.00
FDPIR	100001	Frozen Butter	500411	41-245900-1	40-12450-1	12/20/16	11/15/16	2/5/18	2	16th	2000	20	4	$15.00	$300.00

File details come from the government source that posted it.