B08 Attachment 0008 - Receiving and Weekly Report Instructions.xlsx

XLSX spreadsheet 66 KB Posted Feb 14, 2022

Attached to: Solicitation for 12 Gauge Shotshell Ammunition
Solicitation number: W52P1J-22-R-0002
Issued by: Department of the Army Materiel Command Joint Munitions Command

View the file

Other files

File	Type	Posted
W52P1J22R0002-0002.pdf	PDF	Mar 29, 2022
B08 Attachment 0001 - Price Matrix.xlsx	XLSX spreadsheet	Mar 29, 2022
W52P1J22R0002-0001.pdf	PDF	Mar 3, 2022
B08 Attachment 0003 - CDRL Guidance.pdf	PDF	Feb 14, 2022
B08 Attachment 0002 - OPSEC Plan Sample.pdf	PDF	Feb 14, 2022
B08 Attachment 0007 - Shotshell Contract Delivery Schedule Template.xlsx	XLSX spreadsheet	Feb 14, 2022
B08 Attachment 0009 - Shotshell Program Receiving and Weekly Reports.xlsx	XLSX spreadsheet	Feb 14, 2022
W52P1J-22-R-0002 Shotshell RFP FINAL.pdf	PDF	Feb 14, 2022
B08 Attachment 0005 - Sensitive Arms Ammunition Explosives Classifications.pdf	PDF	Feb 14, 2022
B08 Attachment 0006 - Contract Production and Delivery Reporting SOW.pdf	PDF	Feb 14, 2022
B08 Attachment 0010 - Contractor Owned Contractor Operated Security Statement of Work.pdf	PDF	Feb 14, 2022
B08 Exhibit A - Contract Data Requirements List (CDRLs).pdf	PDF	Feb 14, 2022
B08 Attachment 0004 - Ammunition Data Card Component Listing.pdf	PDF	Feb 14, 2022
B08 Attachment 0001 - Price Matrix.xlsx	XLSX spreadsheet	Feb 14, 2022

Show all 14

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.

Rec Report Status Instructions

Attachment 0008 RFP W52P1J-22-R-0002 January 20, 2022	RECEIVING REPORT STATUS - SHOTSHELL
	DD-MMM-YY1

DATE

DD250's

DODIC2

DD250#3

LOT #4

QUANTITY5

PRODUCED6

PRESENTED7

SIGNED8

CLIN9

MILSTRIP10

SUPP ADD11

COMMENTS12

PRODUCED

PRESENTED

SIGNED

The contractor shall keep a running total throughout the month, then clear the file for the subsequent month. If more rows are needed for a DODIC(s), the contractor shall copy the formulas in Columns N, O, and P.

1. Enter date of report in DD-MMM-YY Format.

2. DODIC as indicated on contract. Do not change/edit this field

3. Enter DD250 number as indicated on WAWF.

4. Enter lot number using the 13 alpha-numberic format.

5. Enter the lot quantity.

6. Date Produced: The date in which the government lot has been packed out (canned, crated, palletized).

7. Date Presented: The date in which the lot has been preseneted to the Governmnet for signature..

8. Date Signed: The date in which the Government signs the DD250 and is in USG ownership.

9. CLIN: Enter the 6-character CLIN as it appears in the contract.

10. MILSTRIP: Enter the 14-character MILSTRIP as it appears in the contract.

11. SUPPADD: Enter the 6-character supplementary address as it appears in the contract.

12. Comments: Enter remarks with respects to the ammunition lot if needed.

13. The DD250 Produced, Presented and Signed columns are calculations. Do not enter anything into these cells.

A011

A011 TOTAL	Target	Produced	Presented	Signed
		0	0	0

A014

A014 TOTAL	Target	Produced	Presented	Signed
		0	0	0

A017

A017 TOTAL	Target	Produced	Presented	Signed
		0	0	0

TOTAL	Target	Produced	Presented	Signed
	0	0	0	0

Weekly Production Instructions

	Weekly Production Status Report - Shotshell
	DD-MMM-YY1
			Monthly Plan2	Actual3	Cum Variance4		Monthly Plan	Actual	Cum Variance
		22-Apr			0	22-Oct			0
The contractor shall keep a running total throughout the month, then clear the file for the subsequent month.

1. Enter date of report in DD-MMM-YY Format.

2. Monthly Plan: Enter the monthly plan for the entire Governmnet Fiscal Year (GFY) that is on contract.

3. Actuals: Enter the monthly actuals at the end of each month throughtout the GFY

4. Cum Variance: Automated field.

5. Monthly Plan: This field is a DODIC breakout for the current month of production. The total quantity should match the monthly plan above under the month of production, i.e., if Jan '21 monthly plan is 10M rounds, the monthly plan DODIC breakout should total 10M.

6. Current Target: The total quantity the contractor estimates will be DD250'd in the current month.

7. Carryover: Quantity produced from prior month(s) that did not get signed, but will get signed in the current month.

(If there is carryover product on hold for an extended period of time, only put the carryover on the chart for the month it is anticipated to be DD250’d)

8. Produced: The quantity that has been packed out (canned, crated, palletized) in the current month.

9. DD250 Presented: The quantity that has been preseneted to the Governmnet for signature, but not signed.

10. Total Accepted: The quantity that the Government has signed in the current month.

11. Remarks: Any remarks the contractor would like to enter for the Government's awareness.	22-May			0	22-Nov			0
		22-Jun			0	22-Dec			0
		22-Jul			0	23-Jan			0
		22-Aug			0	23-Feb			0
		22-Sep			0	23-Mar			0
		6-Mth Period 1	0	0		6-Mth Period 2	0	0

				MONTHLY PLAN5	CURRENT TARGET6	CARRYOVER7	PRODUCED8	DD250 PRESENTED9	TOTAL
SIGNED10	COMMENTS11
		A011	#00 Buckshot
		A014	#7 1/2 Shot
		A017	#9 Shot

Total

0 0 0 0 0 0

File details come from the government source that posted it. Updated Feb 14, 2022.