2 - Attachment D.3.2 - Monthly Inventory Aging _Hold Report.xlsx

XLSX spreadsheet 27 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
Amendment_A02.pdf PDF
Attachment_D.1_-_Schedule_of_Items_(A02).xlsx XLSX spreadsheet
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.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.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.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.3.6 - Monthly Transportation Invoice.xlsx XLSX spreadsheet
2 - Attachment D.15 - WBSCM Requirements.docx DOCX document
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.2 Monthly Inventory Aging/Hold Report

Information
Due Date:Due the first calendar day of the month by noon central time. If the first day of the month falls
on a weekend or federal holiday, then its is due by noon central time the next business day.

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 Period: Prior Month as of the midnight last day of month

Header Sort D3.2 Monthly Inventory Aging/Hold Report

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( i.e. 1 of 200)
7Reporting Period
8Contractor's Invoice Number
9Date of Invoice
10Contractor'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:

1By program (CSFP or FDPIR)
2Number of Days from Expiration(Sort from -105 to + 105 days)
3WBSCM Material Code and Commodity Description

Specific Data Req D3.2 Monthly Inventory Aging/Hold Report

SPECIFIC DATA REQUIRED on Template:

1WBSCM Program
2WBSCM Material Code
3WBSCM Commodity Description
4Warehouse Lot Number
5WBSCM PO Number
6WBSCM PR Number
7Case Balance
8Receipt Date
9Mfg Date
10BIUB Date
11Number of Days from ExpirationLast day of reporting period minus (-) BIUB Date(-105 to +105 days)
12Lot on Hold?Y/N
13Reason Lot on Hold(See Legend)
14Date Lot put on Hold
Legend:
Recall
Rejection
Disposal
Donation-
Other-
BIUB

Monthly InventoryAging-Hold D3.2 Monthly Inventory Aging/Hold Report Last Day of Month - 10/31/2017 TEMPLATE

Header information
LotReason
WBSCMWBSCMWarehouseWBSCMWBSCM# DaysonLotDate
WBSCMMaterialCommodityLotPOPRReceiptMfgBIUBFromHold?onLot Put
ProgramCodeDescriptionNumberNumberNumberCasesDateDateDateExpiration(Y or N)HOLDOn HOLD
CSFP100035Cheese Reduced Fat50030041-45893-2040-5403 -20100010/15/169/30/169/30/17-31YDisposal8/15/17
CSFP100400AP Flour141-12355-1540-4578-15107111/15/1610/31/1610/31/170YRecall10/1/17
CSFP100218Peaches100041-12345-540-5503-59251/15/1612/20/1512/30/1760YBIUB10/30/17
CSFP100035Cheese Reduced Fat50040041-45893-2040-5403 -2010002/18/172/5/171/14/1875N
CSFP100218Peaches101541-12345-640-5503-69252/20/1612/20/151/31/1892N
CSFP100218Peaches101741-12345-740-5503-79253/2/1612/20/152/13/18105N
FDPIR110xxxPork Chops1114966/10/175/15/1711/15/1730YBIUB10/1/17
FDPIR100218Peaches102041-12345-840-5503-89251/15/1612/20/1512/20/1750YBIUB10/15/17
FDPIR100035Cheese Reduced Fat50040041-24593-2140-5403 -2110002/18/172/5/171/6/1867N
FDPIR100050UHT milk11001500x1/19/1880N

File details come from the government source that posted it.