2 - Attachment D.3.7 - Reporting Template with References.xlsx

XLSX spreadsheet 34 KB Posted Feb 8, 2018

Attached to: Third Party Logistic (3PL) Services
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

File	Type	Posted
Amendment_A02.pdf	PDF	Mar 7, 2018
Attachment_D.1_-_Schedule_of_Items_(A02).xlsx	XLSX spreadsheet	Mar 7, 2018
Attachment_D.6_-_Temp__Humidity_Req_(A01).xlsx	XLSX spreadsheet	Feb 27, 2018
Amendment_A01.pdf	PDF	Feb 27, 2018
2 - Attachment D.15 - WBSCM Requirements.docx	DOCX document	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.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.1 - Schedule of Items.xlsx	XLSX spreadsheet	Feb 8, 2018
1_-_Solicitation.pdf	PDF	Feb 8, 2018
2 - Attachment D.9 - Recipient Agencies - At Award.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.3.4 - Monthly Inventory Adjustment Report.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.6 - Temp & Humidity Req.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.11 - Sample Advanced Shipping Notice.docx	DOCX document	Feb 8, 2018
2 - Attachment D.2 - PWS.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.14 - Annual Subcontracting Plan Form.doc	DOC document	Feb 8, 2018
2 - Attachment D.3.5 - Bi-Monthly Storage Invoice.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.3.1 - Monthly Floor Loaded Handling Invoice.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.7 - FIDPR Foods Available List.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.3.6 - Monthly Transportation Invoice.xlsx	XLSX spreadsheet	Feb 8, 2018
2 - Attachment D.12 - Contractor's Nondisclosure Statement.docx	DOCX 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

Show all 26

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.

Transportation Template

D3.6 Monthly Transportation Invoice_YYYY

<Month>

TEMPLATE

Header Information

Clin 6*

R*V

R*X=OORR

Multi

TL/LTL

Clin 7

Clin 7*

Q*X= RLM

Stop

WBSCM

Temp

LTL

Route

Out

Total

Route

Out of

Clin 9*

Clin 8*

WBSCM

Truckload

WBSCM

Actual

Destination

Zip

Lane

of Route

Shipment

Lane

Route

FSurCh

Stop-Off

Grand Total

Program

Req #

BOL

Identifier

Stops

Ship Date

RSDD

Del Date

Ship to #

Name

City

State

Code

Gr Wt

Dry

Trkload

Miles

Identifier

Rate

Amount

Rate

Amount

Charge

Total

(on last stop)

CSFP

1000256173

45701

100501

2/10/17

2/15/17

5000753

Top Foodbk

Toppenish

500

Temp

$0.00

$2.00

$170.00

$0.30

$25.50

$150.00

$345.50

CSFP

1000256200

45703

100501

2/10/17

2/16/17

5005279

Port FBK

Portland

500

Temp

415

500

xxxxxxx

$900.00

$2.00

$0.00

$0.30

$124.50

$0.00

$1,024.50

$1,370.00

CSFP

1000256204

45704

2/13/17

2/18/17

2/17/17

5001023

BR Foodbk

Baton Rouge

5000

Temp

906

xxxxxxx

$1,000.00

$2.00

$0.00

$0.30

$271.80

$0.00

$1,271.80

CSFP

1000256205

45705

100502

2/20/17

2/25/17

5000283

Sike Fdbk

Sikeston

500

Temp

130

$0.00

$2.00

$260.00

$0.30

$39.00

$150.00

$449.00

FDPIR

1000345786

6579302

100502

2/20/17

2/27/17

5000599

ITO

Sault Ste Marie

8000

Temp

1060

1190

xxxxxxx

$2,000.00

$2.00

$0.00

$0.30

$318.00

$0.00

$2,318.00

$2,767.00

CSFP

1000256231

45710

2/25/17

2/28/17

2/26/17

5001191

Spok Fdbnk

Spokane

800

Temp

505

xxxxxxx

$1,200.00

$2.00

$0.00

$0.30

$151.50

$0.00

$1,351.50

Month Inventory Adjustment Rep

D3.4 Monthly Inventory Adjustment Report_yyyy	TEMPLATE
Header information

WBSCM

Warehouse

WBSCM

Inventory

Plus or

Activity

Nature/Cause

WBSCM

Material

Commodity

Lot

Receipt

Manufact

BIUB

Activity

Adjustment

Minus

Reason

Disposition

Requisition

Outbound

Program

Code

Name

Number

Date

Type

Number

Cases

Code

& Reason

Number

BOL #

CSFP

100035

Cheese Reduced Fat

500357

41-24583-110

40-12345 -110

1/15/17

1/5/17

1/5/18

2/12/17

ADJ

9900001

-2

WH O/S

Two cases missing during cycle count

CSFP

100035

Cheese Reduced Fat

500357

41-24583-110

40-12345 -110

1/15/17

1/5/17

1/5/18

2/12/17

ADJ

9900002

-20

Shipment O/S

Overshipped order

1000256200

45703

Bi-MoTransactionHandling Inv D3.3 Bi-Monthly Transaction Report and Handling Invoice YYYY <Month> TEMPLATE

Header Information

WBSCM

Warehouse

WBSCM

Activity

Inventory

WBSCM

Billing

Handling

WBSCM

Material

Commodity

Lot

Receipt

Manufact

BIUB

Activity

Reason

Adjustment

Requisition

Outbound

Case

Inbound

Clin 1

Program

Code

Name

Number

Date

Type

Code

Number (IAN)

Number

BOL Num

Cases

Balance

Pallets

Rate

Amount

CSFP

100035

Cheese Reduced Fat

500357

41-24583-110

40-12345 -110

1/15/17

1/5/17

1/5/18

1/15/17

100256099

1000

$30.00

$600

CSFP

100035

Cheese Reduced Fat

500357

41-24583-110

40-12345 -110

1/15/17

1/5/17

1/5/18

1/15/17

END

1000

CSFP

100035

Cheese Reduced Fat

500357

41-24583-110

40-12345 -110

1/15/17

1/5/17

1/5/18

1/16/17

BEG

1000

CSFP

100035

Cheese Reduced Fat

500357

41-24583-110

40-12345 -110

1/15/17

1/5/17

1/5/18

1/31/17

END

1000

CSFP

100035

Cheese Reduced Fat

500357

41-24583-110

40-12345 -110

1/15/17

1/5/17

1/5/18

2/1/17

BEG

1000

CSFP

(Example of Outbound shipment to Receipient Agency)

2/10/17

OUT

1000256173

45701

-50

950

CSFP

2/10/17

OUT

1000256200

45703

-50

900

CSFP

( Example of Inventory Adjustment and IAN)

2/12/17

ADJ

WH O/S

9900001

-2

898

CSFP

( Example of Inventory Adjustment and IAN)

2/12/17

ADJ

Shipment O/S

9900002

-20

878

CSFP

2/13/17

OUT

1000256204

45704

-296

582

CSFP

(End of Reporting Period #1- Must ID END case balance)

2/15/17

END

582

CSFP

(Beginning of Reporting Period #2- Must ID BEG case balance -

2/16/17

BEG

582

CSFP

should be identical to END of previous period)

2/20/17

OUT

1000256205

45705

-104

478

CSFP

2/25/17

OUT

1000256231

45710

-248

230

CSFP

(End of Reporting Period #2- Must ID END case balance)

2/28/17

END

230

CSFP

100035

Cheese Reduced Fat

500357

41-24583-110

40-12345 -110

1/15/17

1/5/17

1/5/18

3/1/17

BEG

230

FDPIR

100001

Frozen Butter

500411

41-245900-1

40-12450-1

12/20/16

11/15/16

2/5/18

12/31/16

END

2000

FDPIR

100001

Frozen Butter

500411

41-245900-1

40-12450-1

12/20/16

11/15/16

2/5/18

1/1/17

BEG

2000

FDPIR

100001

Frozen Butter

500411

41-245900-1

40-12450-1

12/20/16

11/15/16

2/5/18

1/15/17

END

2000

FDPIR

100001

Frozen Butter

500411

41-245900-1

40-12450-1

12/20/16

11/15/16

2/5/18

1/16/17

BEG

2000

FDPIR

100001

Frozen Butter

500411

41-245900-1

40-12450-1

12/20/16

11/15/16

2/5/18

1/31/17

END

2000

FDPIR

100001

Frozen Butter

500411

41-245900-1

40-12450-1

12/20/16

11/15/16

2/5/18

2/1/17

BEG

2000

FDPIR

100001

Frozen Butter

500411

41-245900-1

40-12450-1

12/20/16

11/15/16

2/5/18

2/15/17

END

2000

FDPIR

100001

Frozen Butter

500411

41-245900-1

40-12450-1

12/20/16

11/15/16

2/5/18

2/16/17

BEG

2000

FDPIR

100001

Frozen Butter

500411

41-245900-1

40-12450-1

12/20/16

11/15/16

2/5/18

2/20/17

OUT

1000345786

6579302

-2000

FDPIR

100001

Frozen Butter

500411

41-245900-1

40-12450-1

12/20/16

11/15/16

2/5/18

2/28/17

END

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.