Attachment 0009 - Receiving and Weekly Report Instructions.xlsx
XLSX spreadsheet 69 KB Posted
- Attached to
- Pre-Solicitation Notice for Second Source Supplier to Produce 5. 56mm, 7. 62mm, and Caliber . 50 Ammunition
- Solicitation number
- W52P1J20R0046
About this file
This document contains receiving and weekly production report instructions and templates for a federal contract to produce small caliber ammunition. The contractor will be required to track quantities of 5.56mm ammunition produced, presented to the government for signature, and signed on a monthly basis using the provided receiving report and weekly production report templates. Data to be tracked includes date, DODIC, lot number, quantity, CLIN, MILSTRIP, and supplementary address. The contractor must also submit a monthly plan and provide actual production updates. The related federal contract opportunity is seeking a second source supplier to produce 5.56mm, 7.62mm, and .50 caliber ammunition geographically separated from the Lake City Army Ammunition Plant for the Department of the Army Materiel Command Joint Munitions Command. This is a restricted competition open only to US, outlying areas, and Canada.
View the file
Other files
Show all 16
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, 2020 | RECEIVING REPORT STATUS - 5.56mm |
| DD-MMM-YY1 |
| DATE | DATE | DATE | DD250's | DD250's | 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.
A059
| A059 TOTAL | Target | Produced | Presented | Signed |
| 0 | 0 | 0 |
A062
| A062 TOTAL | Target | Produced | Presented | Signed |
| 0 | 0 | 0 |
A080
| A080 TOTAL | Target | Produced | Presented | Signed |
| 0 | 0 | 0 |
AB56
| AB56 TOTAL | Target | Produced | Presented | Signed |
| 0 | 0 | 0 |
AB57
| AB57 TOTAL | Target | Produced | Presented | Signed |
| 0 | 0 | 0 |
AB58
| AB58 TOTAL | Target | Produced | Presented | Signed |
| 0 | 0 | 0 |
AB77
| AB77 TOTAL | Target | Produced | Presented | Signed |
| 0 | 0 | 0 |
| 5.56mm | TOTAL | Target | Produced | Presented | Signed |
| 0 | 0 | 0 | 0 |
a
Weekly Production Instructions
| Weekly Production Status Report - 5.56mm | |||||||||
| DD-MMM-YY1 | |||||||||
| Monthly Plan2 | Actual3 | Cum Variance4 | Monthly Plan | Actual | Cum Variance | ||||
| Oct ‘21 | 0 | Apr ‘22 | 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. | Nov ‘21 | 0 | May ‘22 | 0 | |||||
| Dec ‘21 | 0 | June ‘22 | 0 | ||||||
| Jan ‘22 | 0 | July ‘22 | 0 | ||||||
| Feb ‘22 | 0 | Aug ‘22 | 0 | ||||||
| Mar ‘22 | 0 | Sep ‘22 | 0 | ||||||
| 6-Mth Period 1 | 0 | 0 | 6-Mth Period 2 | 0 | 0 |
| MONTHLY PLAN5 | CURRENT TARGET6 | CARRYOVER7 | PRODUCED8 | DD250 PRESENTED9 | TOTAL | ||||
| SIGNED10 | COMMENTS11 | ||||||||
| A059 | M885, Clipped Mil Pack | ||||||||
| A062 | M885, Linked | ||||||||
| A080 | M200, Carton Pack | ||||||||
| AB56 | M855A1, Linked | ||||||||
| AB57 | M855A1, Clipped Mil Pack | ||||||||
| AB58 | M855A1, Clipped Comm Pack | ||||||||
| AB77 | M855A1, Clipped Bulk Pack | ||||||||
| Total | 0 | 0 | 0 | 0 | 0 | 0 |
File details come from the government source that posted it. Updated .