Attachment W Reporting Template with References.xlsx

XLSX spreadsheet 42 KB Posted Jan 16, 2025

Attached to: FNS Storage and Distribution Services Federal contract opportunity
Solicitation number: 12-3198-25-R-0010
Issued by: Department of Agriculture Food and Nutrition Service

About this file

Written by GovTribe AI · Jan 16, 2025

This is a reporting template attachment (Attachment W) containing multiple spreadsheet templates for tracking inventory, transactions, and logistics for USDA food distribution programs. The templates include: Monthly Inventory Aging/Hold Report for tracking product lots, expiration dates and hold status; Bi-Monthly Transaction Report and Handling Invoice for recording inbound/outbound shipments and handling fees; Monthly Inventory Adjustment Report for documenting inventory changes; Bi-Monthly Storage Invoice Report for billing storage fees; and Transportation Template for tracking shipment details including routes, delivery dates, and freight charges.

The templates are designed to track various food commodities distributed through the Food Distribution Program on Indian Reservations (FDPIR) and Commodity Supplemental Food Program (CSFP). Sample data shows tracking of products like canned goods, cheese, cereals, and beverages with fields for WBSCM codes, purchase orders, receipt dates, quantities, and billing rates. The templates enable comprehensive reporting of warehouse operations, inventory management, and transportation logistics for the USDA food distribution contract.

View the file

Other files for this federal contract opportunity

Other files attached to FNS Storage and Distribution Services, newest first.
File	Type	Posted
Attachment K Performance Work Statement PWS revised.pdf	PDF	Feb 5, 2025
12-3198-25-R-0010 Amend A00001.pdf	PDF	Feb 5, 2025
Attachment X rev. Incentive and Penalties.xlsx	XLSX spreadsheet	Feb 5, 2025
A00001 Questions and Answers.xlsx	XLSX spreadsheet	Feb 5, 2025
Attachment A USDA CSFP Rev Max Month Distrib Rates.pdf	PDF	Jan 16, 2025
Attachment F CSFP Factsheet.pdf	PDF	Jan 16, 2025
Attachment S CSFP Foods Available List.xlsx	XLSX spreadsheet	Jan 16, 2025
Solicitation 12-3198-25-R-0010.pdf	PDF	Jan 16, 2025
Attachment C USDA Foods Available List for CSF.pdf	PDF	Jan 16, 2025
Attachment D USDA Foods Available List for FDP.pdf	PDF	Jan 16, 2025
Attachment G TEFAP Factsheet.pdf	PDF	Jan 16, 2025
Attachment K Performance Work Statement PWS.pdf	PDF	Jan 16, 2025
Attachment O Bi-Monthly Storage Invoice.xlsx	XLSX spreadsheet	Jan 16, 2025
Attachment Q Household Foods Shelf Life Guidelines.xlsx	XLSX spreadsheet	Jan 16, 2025
Attachment U Summary of CSFP and FDPIR Orders.xlsx	XLSX spreadsheet	Jan 16, 2025
Attachment V Temp Humidity Req.xlsx	XLSX spreadsheet	Jan 16, 2025
Attachment Z Subcontracting Plan.pdf	PDF	Jan 16, 2025
SF1449 12-3198-25-R-0010.pdf	PDF	Jan 16, 2025
Attachment H MAP for FDPIR - CSFP Zone and Program Locations.pdf	PDF	Jan 16, 2025
Attachment I Detailed Zone Delivery Locations w Avg Volumes.xlsx	XLSX spreadsheet	Jan 16, 2025
Attachment J Pricing Schedule.xlsx	XLSX spreadsheet	Jan 16, 2025
Attachment L CSFP and FDPIR Food Package Descr.pdf	PDF	Jan 16, 2025
Attachment M Nat Multifood Warehouse Interaction With WBSCM.pdf	PDF	Jan 16, 2025
Attachment P Monthly Transportation Invoice.xlsx	XLSX spreadsheet	Jan 16, 2025
Attachment R FDPIR Foods Available List.xlsx	XLSX spreadsheet	Jan 16, 2025
Attachment T Aggregate Delivery Locations.xlsx	XLSX spreadsheet	Jan 16, 2025
ATTACHMENT Y Past Performance Questionnaire.docx	DOCX document	Jan 16, 2025
Attachment B USDA FDPIR Monthly Distribution G.pdf	PDF	Jan 16, 2025
Attachment E FDPIR Factsheet.pdf	PDF	Jan 16, 2025
Attachment N Bi-Monthly Transaction Handling Invoice.xlsx	XLSX spreadsheet	Jan 16, 2025
Attachment X Incentives and Penalties.xlsx	XLSX spreadsheet	Jan 16, 2025

Show all 31

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.

Monthly InventoryAging-Hold

Attachment W Monthly Inventory Aging/Hold Report

Last Day of Month - MM/DD/YYYY

TEMPLATE

Lot

Reason

WBSCM

Warehouse

WBSCM

# Days

Lot

Date

WBSCM

Material

Commodity

Lot

Receipt

Mfg

BIUB

From

Hold?

Lot Put

Program

Code

Description

Number

Line Item

Number

Line Item

Cases

Date

Expiration

(Y or N)

HOLD

On HOLD

FDPIR

100127

BEEF CAN-24/24 OZ

159990

4100030869

4000011847

1,000.000

12/6/24

11/6/24

10/27/26

-31

Recall

12/15/24

CSFP

100314

PEAS CAN-24/300

159980

4100030129

139

4000011771

2550

1,620.000

12/6/24

11/6/24

10/27/26

CSFP

100320

VEG MIX CAN-24/300

159867

4100030131

4000011773

1,620.000

2/4/23

1/5/23

12/25/24

BIUB

12/25/24

FDPIR

110162

MILK SKIM EVAPORATED CAN-24/12 FL OZ

1335

4100030618

4000011930

710

1,836.000

12/13/24

11/13/24

11/13/25

FDPIR

110199

CHEESE PROCESS REG LVS-6/5 LB

159863

4100030956

4000011856

1,320.000

12/4/24

11/4/24

11/4/25

FDPIR

111075

RICE US#2 LONG GRAIN PKG-24/1 LB

1323

4100030527

324

4000011930

940

1,680.000

12/9/24

11/9/24

11/9/25

105

CSFP

111740

CEREAL CORN FLKS 1248 PKG-12/18 OZ

160221

4100030365

4000011828

660

1,248.000

2/12/24

1/13/24

10/9/24

-30

Disposal

8/9/24

Bi-MoTransactionHandling Inv

Attachment W Bi-Monthly Transaction Report and Handling Invoice YYYY_Month
TEMPLATE
	WBSCM	WBSCM	Warehouse	WBSCM	WBSCM	WBSCM	WBSCM						Activity	Inventory	WBSCM				Billing	Handling	Handling
WBSCM	Material	Commodity	Lot	PO	PO	PR	PR	Receipt	Manufact	BIUB	Activity	Activity	Reason	Adjustment	Requisition	Outbound		Case	Inbound	Clin 1	Clin 1
Program	Code	Name	Number	Number	Line Item	Number	Line Item	Date	Date	Date	Date	Type	Code	Number (IAN)	Number	BOL Num	Cases	Balance	Pallets	Rate	Amount
CSFP	100035	CHEESE BLEND AMER SKM LVS-12/2 LB	500357	4100024583	110	4000012345	10	11/15/24	10/5/24	10/5/25	11/15/24	IN					1000	1000	20	$30.00	$600
CSFP	100035	CHEESE BLEND AMER SKM LVS-12/2 LB	500357	4100024583	110	4000012345	10	11/15/24	10/5/24	10/5/25	11/16/24	BEG						1000
CSFP	100035	CHEESE BLEND AMER SKM LVS-12/2 LB	500357	4100024583	110	4000012345	10	11/15/24	10/5/24	10/5/25	11/30/24	END						1000
CSFP			(Example of Outbound shipment to Receipient Agency)								12/10/24	OUT			1000256173	45701	-50	950
CSFP											12/11/24	OUT			1000256200	45703	-50	900
CSFP			( Example of Inventory Adjustment and IAN)								12/12/24	ADJ	Wh O/S	9900001			-2	898
CSFP			( Example of Inventory Adjustment and IAN)								12/13/24	ADJ	Wh O/S	9900002			-20	878
CSFP											12/14/24	OUT			1000256204	45704	-296	582
CSFP			(End of Reporting Period #1- Must ID END case balance)								12/15/24	END						582
CSFP			(Beginning of Reporting Period #2- Must ID BEG case balance -				should be identical to END of previous period)				12/16/24	BEG						582
CSFP											12/17/24	OUT			1000256205	45705	-104	478
CSFP											12/18/24	OUT			1000256231	45710	-248	230
CSFP			(End of Reporting Period #2- Must ID END case balance)								12/19/24	END						230
FDPIR	110199	CHEESE PROCESS REG LVS-6/5 LB	500411	4100245900	1	4000012450	20	6/20/24	5/15/24	5/5/25	6/20/24	IN						1650
FDPIR	110199	CHEESE PROCESS REG LVS-6/5 LB	500411	4100245900	1	4000012450	20	6/20/24	5/15/24	5/5/25	7/1/24	BEG						1650
FDPIR	110199	CHEESE PROCESS REG LVS-6/5 LB	500411	4100245900	1	4000012450	20	6/20/24	5/15/24	5/5/25	7/15/24	END						1650
FDPIR	110199	CHEESE PROCESS REG LVS-6/5 LB	500411	4100245900	1	4000012450	20	6/20/24	5/15/24	5/5/25	7/16/24	BEG						1650
FDPIR	110199	CHEESE PROCESS REG LVS-6/5 LB	500411	4100245900	1	4000012450	20	6/20/24	5/15/24	5/5/25	7/31/24	END						1650
FDPIR	110199	CHEESE PROCESS REG LVS-6/5 LB	500411	4100245900	1	4000012450	20	6/20/24	5/15/24	5/5/25	8/1/24	BEG						1650
FDPIR	110199	CHEESE PROCESS REG LVS-6/5 LB	500411	4100245900	1	4000012450	20	6/20/24	5/15/24	5/5/25	8/15/24	END						1650
FDPIR	110199	CHEESE PROCESS REG LVS-6/5 LB	500411	4100245900	1	4000012450	20	6/20/24	5/15/24	5/5/25	8/16/24	BEG						1650
FDPIR	110199	CHEESE PROCESS REG LVS-6/5 LB	500411	4100245900	1	4000012450	20	6/20/24	5/15/24	5/5/25	8/20/24	OUT			1000345786	6579302	-1650	0
FDPIR	110199	CHEESE PROCESS REG LVS-6/5 LB	500411	4100245900	1	4000012450	20	6/20/24	5/15/24	5/5/25	8/20/24	END						0

Month Inventory Adjustment Rep

Attachment W Monthly Inventory Adjustment Report_YYYY_Month

TEMPLATE

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

Line Item

Number

Line Item

Date

Type

Number

Cases

Code

& Reason

Number

BOL #

CSFP

100035

CHEESE BLEND AMER SKM LVS-12/2 LB

159860

4100024583

4000012345

110

12/15/24

11/5/24

11/5/25

12/20/24

ADJ

9900001

-2

Wh O/S

Two cases missing during cycle count

FDPIR

110199

CHEESE PROCESS REG LVS-6/5 LB

159863

4100024583

4000012372

150

12/15/24

11/5/24

11/5/25

12/21/24

ADJ

9900002

-20

Shipmnt O/S

Overshipped order

1000256200

45703

Bi-Monthly Storage Invoice Attachment W Bi-Monthly Storage Invoice Report YYYY_Month

Half-Month

WBSCM

Warehouse

WBSCM

Billing

Storage

WBSCM

Material

Commodity

Lot

Receipt

Manufact

BIUB

Invoice

Case

Number

Clins

Rate per

Storage

Program

Code

Description

Number

Line Item

Number

Line Item

Date

Month

Periods

Balance

Pallets

3, 4, or 5

Pallet

Amount

CSFP

100306

BEANS GREEN CAN-24/300

160009

4100030133

250

4000011771

250

12/6/24

6/9/24

6/9/26

1st

1,620

CSFP

100311

CORN WHOLE KERNEL CAN-24/300

159878

4100030129

1810

4000011771

1810

12/4/24

6/4/24

6/4/26

1st

1,530

CSFP

111691

CEREAL TOASTY O'S 1440 PKG-12/14 OZ

160260

4100030363

150

4000011828

150

12/12/24

11/13/24

11/13/25

1st

1,440

FDPIR

100333

TOMATO SAUCE CAN-24/300

160197

4100030540

4000011834

12/11/24

7/11/24

7/11/26

1st

1,530

FDPIR

100897

ORANGE JUICE PLST BTL-8/64 FL OZ

160364

4100030663

4000011843

12/16/24

11/16/24

7/16/25

2nd

1,025

FDPIR

111771

OIL EXTRA VIRGIN OLIVE BTL-6/16.9 FL OZ

159989

4100030507

1170

4000011630

10/23/24

9/5/24

9/5/25

2nd

3,360

Transportation Template

Attachment W Monthly Transportation Invoice_YYYY_Month

TEMPLATE

Clin 6*

Clin 7

Clin 7*

Clin 9*

Clin 8*

Multi

TL/LTL

R*V

R*X=OORR

Stop

WBSCM

Temp

LTL

Route

Out

Total

Route

Out of

Q*X= RLM

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

1000677138

1234

157986

12/2/24

12/3/24

5003690

FOOD BANK OF THE ROCKIES

DENVER

36500

Temp

603

FDPIR

1000677582

2345

157828

11/19/24

12/2/24

11/20/24

5000275

LAC DU FLAMBEAU FD PROG

LAC DU FLAMBEAU

37662

Temp

647

CSFP

1000677533

3456

158203

12/2/24

12/4/24

5002215

MAHONING VALLEY FOODBANK

YOUNGSTOWN

22861

Temp

830

FDPIR

1000677795

4567

158324

12/4/24

12/5/24

5001315

WINNEBAGO TRIBE OF NEBRASKA

WINNEBAGO

20000

Temp

269

$ 150.00

CSFP

1000677796

5678

158325

12/4/24

12/5/24

5006620

Winnebago Tribe of Nebraska - CSFP

WINNEBAGO

5000

Dry

**THIS NEED FORMULAS BASED ON FINAL CLIN**

File details come from the government source that posted it. Updated Jan 16, 2025.