B08 Attachment 0009 - Receiving and Weekly Report Instructions.xlsx

XLSX spreadsheet 69 KB Posted

Attached to
Solicitation for Second Source Supplier to Produce 5. 56mm, 7. 62mm, and Caliber . 50 Ammunition
Solicitation number
W52P1J20R0046
Issued by

About this file

This solicitation requests proposals for the production of small caliber ammunition for the U.S. Army. The solicitation seeks a second source supplier to produce 5.56mm, 7.62mm, and .50 caliber ammunition at a facility geographically separated from Lake City Army Ammunition Plant. Required ammunition includes ball, blank, tracer, and linked/clipped configurations. The base contract consists of 10 million rounds each of 5.56mm M855A1 ball clipped and 12 million rounds of 7.62mm M80A1 ball linked, with option years evaluating pricing for additional family maximums of 75 million 5.56mm, 48 million 7.62mm, and 15 million .50 caliber rounds. Proposals are due by August 25, 2020, with the base award period running from date of award to 365 days after and optional pricing periods evaluating out to 1,825 days after award.

View the file

Other files

File Type Posted
W52P1J20R0046-0004.pdf PDF
W52P1J20R0046-0003.pdf PDF
W52P1J20R0046-0002.pdf PDF
RFP W52P1J-20-R-0046 Questions and Answers.pdf PDF
W52P1J20R0046-0001.pdf PDF
B08 Attachment 0011 - 7.62mm Program Receiving and Weekly Reports.XLSX XLSX spreadsheet
B08 Attachment 0013 - Ammunition Data Card Component Listing.pdf PDF
B08 Attachment 0002 - OPSEC Plan Sample.pdf PDF
B08 Attachment 0014 - Small Business Participation.pdf PDF
B08 Attachment 0010 - 5.56mm Program Receiving and Weekly Reports.xlsx XLSX spreadsheet
B08 Attachment 0004 - Sensitive Arms Ammunition Explosives Classifications.pdf PDF
B08 Attachment 0005 - Price Matrix.xlsx XLSX spreadsheet
B08 Attachment 0001 - CDRL Guidance.pdf PDF
B08 Attachment 0006 - EPA Material Content Factors.pdf PDF
B08 Attachment 0003 - NATO SOW.pdf PDF
FINAL RFP W52P1J-20-R-0046 July 24.pdf PDF
B08 Attachment 0015 - Contractor Vendor Guide - Contract Opportunities - beta.sam.gov.pptx PPTX presentation
B08 Exhibit A - Small Caliber Second Source CDRLs.pdf PDF
B08 Attachment 0007 - Contract Production Delivery Report SOW.pdf PDF
B08 Attachment 0012 - Caliber 50 Program Receiving and Weekly Reports.xlsx XLSX spreadsheet
B08 Attachment 0008 - Contract Delivery Schedule.xlsx XLSX spreadsheet
Show all 21

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Rec Report Status Instructions

Attachment 0009 RFP W52P1J-20-R-0046 May 6, 2020RECEIVING REPORT STATUS - 5.56mm
DD-MMM-YY1
DATEDATEDATEDD250'sDD250'sDD250's
DODIC2DD250#3LOT #4QUANTITY5PRODUCED6PRESENTED7SIGNED8CLIN9MILSTRIP10SUPP ADD11COMMENTS12PRODUCEDPRESENTEDSIGNED
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.

A059

A059 TOTALTargetProducedPresentedSigned
000

A062

A062 TOTALTargetProducedPresentedSigned
000

A080

A080 TOTALTargetProducedPresentedSigned
000

AB56

AB56 TOTALTargetProducedPresentedSigned
000

AB57

AB57 TOTALTargetProducedPresentedSigned
000

AB58

AB58 TOTALTargetProducedPresentedSigned
000

AB77

AB77 TOTALTargetProducedPresentedSigned
000
5.56mmTOTALTargetProducedPresentedSigned
0000

a

Weekly Production Instructions

Weekly Production Status Report - 5.56mm
DD-MMM-YY1
Monthly Plan2Actual3Cum Variance4Monthly PlanActualCum Variance
Oct ‘210Apr ‘220
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.Nov ‘210May ‘220
Dec ‘210June ‘220
Jan ‘220July ‘220
Feb ‘220Aug ‘220
Mar ‘220Sep ‘220
6-Mth Period 1006-Mth Period 200
MONTHLY PLAN5CURRENT TARGET6CARRYOVER7PRODUCED8DD250 PRESENTED9TOTAL
SIGNED10COMMENTS11
A059M885, Clipped Mil Pack
A062M885, Linked
A080M200, Carton Pack
AB56M855A1, Linked
AB57M855A1, Clipped Mil Pack
AB58M855A1, Clipped Comm Pack
AB77M855A1, Clipped Bulk Pack
Total000000

File details come from the government source that posted it. Updated .