B08_Attachment 0006_GFM Consumption Format and Instructions.xlsx

XLSX spreadsheet 27 KB Posted Feb 16, 2023

Attached to: M039 40lb Cratering Charge
Solicitation number: W519TC23R0011
Issued by: Department of the Army Materiel Command Contracting Command Rock Island Arsenal

View the file

Other files

File	Type	Posted
W519TC23R0011 Amd 0001.pdf	PDF	Mar 13, 2023
B08_Attachment 0007_Production and Shipping Progress Report - Sample.XLSX	XLSX spreadsheet	Feb 16, 2023
W519TC23R0011.pdf	PDF	Feb 16, 2023
B08_Attachment 0004_OPSEC PLAN - Sample.pdf	PDF	Feb 16, 2023
B08_Attachment 0005 _Government Furnished Property Listing.pdf	PDF	Feb 16, 2023
B08_Attachment 0003_GUIDANCE ON DOCUMENTATION OF CONTRACT REQUIREMENTS LIST (CDRL).pdf	PDF	Feb 16, 2023
B08_Exhibit A_Contract Data Requirements List (CDRL).pdf	PDF	Feb 16, 2023
B08_Attachment 0001_Price Matrix M039.xlsx	XLSX spreadsheet	Feb 16, 2023
B08_Attachment 0002_Hazardous_Material_Warning_Label.pdf	PDF	Feb 16, 2023

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.

Format

GFM CONSUMPTION CDRL
OVERALL GFM STATUS:		STEPS
Month and Year:	"1"	1	Enter in the Month and Year of the consumption report
GFM Component:	"2"	2	Enter in the Nomenclature of the GFM being consumed
GFM NSN:	"3"	3	Enter in the NSN of the GFM being consumed
Contract:	"4"	4	Enter in the Contract Number
Delivery Order:	"5"	5	Enter in the Delivery Order number for the contract (if applicable)
End Item:	"6"	6	Enter in the Nomenclature for the End Item associated with the contract
DODAAC:	"7"	7	Enter in the DODAAC associated with the contract. The DODAAC will always be established by JMC

Contract	BASE		This field will always be "BASE"
End Item BASE QTY	"8"	8	Indicate total End Item Qty for the base contract
GFM BASE Qty	"9"	9	Indicate total GFM for the base contract. (This will be for the GFM indicated in Block 2)

Contract MOD	"10"	10	If a new Contract MOD occurs that increases/decreases the total end item and/or GFM qty of the contract, indicate the contract MOD number in this field
End Item QTY Added/Subtracted from contract	"11"	11	Indicate End Item qty added/subtracted from contract
GFM QTY Added/Subtracted from contract	"12"	12	Indicate GFM qty added/subtracted from contract
			*Steps 10-12 will have to be repeated with every new contract MOD that increases/decreases the total contract quantity. Insert rows as necessary
Total End Item Qty for DO	"13"	13	This field should sum the total End Item qty in the contract. Contractors should update the summation formula to include each new MOD added to this report
Total GFM for DO	"14"	14	This field should sum the total GFM qty in the contract Contractors should update the summation formula to include each new MOD added to this report

Total End Item Production to Date "15" 15 This field should indicate the total End Item production to date

Total GFM Received (+)	"16"	16	This field shall identify the total GFM received by the contractor. This field will be auto populated from the "Overall Transactions" tables listed below
Total GFM Consumed (-)	"17"	17	This field shall identify the total GFM consumed by the contractor. This field will be auto populated from the "Overall Transactions" tables listed below
Total GFM Transferd In/Out(+/-)	"18"	18	This field shall identify any GFM transferred to/from other contracts. This field will be auto populated from the "Overall Transactions" tables listed below
Total GFM Identified for Disposition (-)	"19"	19	The filed shall identify any GFM that was dispositioned. This field will be auto populated from the "Overall Transactions" tables listed below
Total GFM on Hand	"20"	20	This field shall identify the total GFM the contractor has on hand by the end of the month. This field will be the summation of the previous four fields
GFM Remaining to be Received	"21"	21	This field shall identify the remaining GFM to be received. This field will subtract the total GFM on contract by the total GFM received

MONTHLY CONTRACTOR CONSUMPTION REPORT:

Overall

GFM Transactions by Month

Prior

Sep-17

Oct-17

Nov-17

Dec-17

Jan-18

Feb-18

Mar-18

Apr-18

May-18

Jun-18

Jul-18

Aug-18

Total

Prior*

*If the contract extends beyond 12 months, shift the quantity from the olderst month into the "Prior" column. Continue to add to the prior coulumn with each new month added to the table.

Total Qty Received by Month (+)

"22"

Log the qty of GFM received on a month by month basis. The Table will sum the total of GFM received on contract

Total Qty Consumed by Month (-)

"23"

Log the qty of GFM consumed on a month by month basis. The Table will sum the total GFM consumed in DO

Total Qty Transferred by Month (+/-)

"24"

Log the qty of GFM transferred to/from this contract. The Table will sum the total of GFM transferred on contract. Provide an explanation for the transfer (Step 27)

Total Qty Identified for Disposition by Month (-)

"25"

Log the qty of GFM transferred to/from this contract. The Table will sum the total of GFM dispositioned on contract. Provide an explanation for the disposition (Step 28)

Total Qty on Hand at End of the Month

"26"

This field shall identify the total GFM the contractor has on hand by the end of the month. This field will be the summation of the previous four fields and the previous month total

Transfer Explanation:	"27"	27	Explain the rational behind the transfer. Identify which Contract/DO the GFM is being shipped from/to
Disposition Explanation:	"28"	28	Explain the rational behind the disposition

By Lot

Lot Qty Received by Month

Prior

Sep-17

Oct-17

Nov-17

Dec-17

Jan-18

Feb-18

Mar-18

Apr-18

May-18

Jun-18

Jul-18

Aug-18

Total

LOTYYM###-###

"29"

Log the GFM qty by lot received per month. Indicate the lot number in this table, and add additional rows if necessary. The Table will sum the total of GFM received on contract

LOTYYM###-###

Total

Lot Qty Consumed by Month

Prior

Sep-17

Oct-17

Nov-17

Dec-17

Jan-18

Feb-18

Mar-18

Apr-18

May-18

Jun-18

Jul-18

Aug-18

Total

LOTYYM###-###

"30"

Log the GFM qty by lot consumed per month. Indicate the lot number in this table, and add additional rows if necessary. The Table will sum the total of GFM received on contract

LOTYYM###-###

Total

Steps

STEPS	Explanation
1	Enter in the Month and Year of the consumption report
2	Enter in the Nomenclature of the GFM being consumed
3	Enter in the NSN of the GFM being consumed
4	Enter in the Contract Number
5	Enter in the Delivery Order number for the contract (if applicable)
6	Enter in the Nomenclature for the End Item associated with the contract
7	Enter in the DODAAC associated with the contract. The DODAAC will always be established by JMC
	This field will always be "BASE"
8	Indicate total End Item Qty for the base contract
9	Indicate total GFM for the base contract. (This will be for the GFM indicated in Block 2)
10	If a new Contract MOD occurs that increases/decreases the total qty of the contract, indicate the contract MOD number in this field
11	Indicate End Item qty added/subtracted from contract
12	Indicate GFM qty added/subtracted from contract
	*Steps 10-12 will have to be repeated with every new contract MOD that increases/decreases the total contract quantity. Insert rows as necessary
13	This field should sum the total End Item qty in the contract. Contractors should update the summation formula to include each new MOD added to this report
14	This field should sum the total GFM qty in the contract Contractors should update the summation formula to include each new MOD added to this report
15	This field should indicate the total End Item production to date
16	This field shall identify the total GFM received by the contractor. This field will be auto populated from the "Overall Transactions" tables listed below
17	This field shall identify the total GFM consumed by the contractor. This field will be auto populated from the "Overall Transactions" tables listed below
18	This field shall identify any GFM transferred to/from other contracts. This field will be auto populated from the "Overall Transactions" tables listed below
19	The filed shall identify any GFM that was dispositioned. This field will be auto populated from the "Overall Transactions" tables listed below
20	This field shall identify the total GFM the contractor has on hand by the end of the month. This field will be the summation of the previous four fields
21	This field shall identify the remaining GFM to be received. This field will subtract the total GFM on contract by the total GFM received
Prior*	*If the contract extends beyond 12 months, shift the quantity from the olderst month into the "Prior" column. Continue to add to the prior coulumn with each new month added to the table.
22	Log the qty of GFM received on a month by month basis. The Table will sum the total of GFM received on contract
23	Log the qty of GFM consumed on a month by month basis. The Table will sum the total GFM consumed in DO
24	Log the qty of GFM transferred to/from this contract. The Table will sum the total of GFM transferred on contract. Please provide explanation below the table
25	Log the qty of GFM transferred to/from this contract. The Table will sum the total of GFM dispositioned on contract. Please provide explanation below the table
26	This field shall identify the total GFM the contractor has on hand by the end of the month. This field will be the summation of the previous four fields and the previous month total
27	Please explain the rational behind the transfer. Identify which Contract/DO the GFM is being shipped from/to
28	Please explain the rational behind the disposition
29	If GFM is being shipped direct from contractor to contractor, please log the lot quantity received per month. The Table will sum the total of GFM received on contract
30	If GFM is being shipped direct from contractor to contractor, please log the lot quantity consumed per month. The Table will sum the total of GFM consumed on contract

Example

CDRL TITLE
OVERALL GFM STATUS:
Month and Year:	Nov-17
GFM Component:	CNU332 USAF 30mm Container (ALS Can)
GFM NSN:	8140-01-170-9614
Contract:	W52P1J-13-D-0037
Delivery Order:	DO 0035
End Item:	PGU-15
DODAAC:	CDAU78

Contract	BASE
End Item BASE QTY	900,000
GFM BASE Qty	1,620

Contract MOD	1
End Item QTY Added/Subtracted from contract	410,000
GFM QTY Added/Subtracted from contract	738

Total End Item Qty for DO	1,310,000
Total GFM for DO	2,358

Total End Item Production to Date 0

Total GFM Received (+)	810
Total GFM Consumed (-)	0
Total GFM Transferd In/Out(+/-)	0
Total GFM Identified for Disposition (-)	0
Total GFM on Hand	810
GFM Remaining to be Received	1,548

MONTHLY CONTRACTOR CONSUMPTION REPORT:

Overall
GFM Transactions by Month	Prior	Sep-17	Oct-17	Nov-17	Dec-17	Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Total
Total Qty Received by Month (+)	0	90	360	360										810
Total Qty Consumed by Month (-)	0	0	0	0										0
Total Qty Transferred by Month (+/-)	0	0	0	0										0
Total Qty Identified for Disposition by Month (-)	0	0	0	0										0
Total Qty on Hand at End of the Month	0	90	450	810	810	810	810	810	810	810	810	810	810

Transfer Explanation:

Disposition Explanation:

By Lot
Lot Qty Received by Month	Prior	Sep-17	Oct-17	Nov-17	Dec-17	Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Total
LOTYYM###-###	0	90	360	360										810
LOTYYM###-###	0	0	0	0										0
LOTYYM###-###	0	0	0	0										0
LOTYYM###-###	0	0	0	0										0
Total	0	90	360	360	0	0	0	0	0	0	0	0	0	810

Lot Qty Consumed by Month	Prior	Sep-17	Oct-17	Nov-17	Dec-17	Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Total
LOTYYM###-###	0	0	0	0										0
LOTYYM###-###	0	0	0	0										0
LOTYYM###-###	0	0	0	0										0
LOTYYM###-###	0	0	0	0										0
Total	0	0	0	0	0	0	0	0	0	0	0	0	0	0

File details come from the government source that posted it. Updated Feb 16, 2023.