Attachment_8_DMSMS_Quarterly_Report_Formats_24_Sep_2012.xls
XLS spreadsheet 103 KB Posted
- Attached to
- Draft FMV Pre-Solicitation Federal contract opportunity
- Solicitation number
- N00019-16-R-3000
About this file
Diminishing Manufacturing Sources and Material Shortages (DMSMS) Quarterly Report Format
View the file
Other files for this federal contract opportunity
Show all 18
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
Text version
Table 1 - Solution Guide
| Attachment (8) DMSMS Quarterly Report Formats |
| Table 1 |
Report Guide per Solution
| Solution / Resolution | Table to fill out | OCL Entry | Case Sheet | Solution Cost | Solution Cost Avoidance |
| 1. Solution Not Required | Table 3 | N/A | N/A | ||
| 2. Original component | |||||
| 2a. - Continue to Manufacture (Extend Production) | Table 3 | YES | YES | N/A | N/A |
| 2b. - Life of Type Buy (LOT Buy) or Bridge Buy | Table 3 | YES | YES | TBD | TBD |
| 2c. - Existing Stock | Table 3 | YES | YES | $0.00 | $0.00 |
| 2d. - Broker Market | Table 3 | YES | YES | $0.00 | $0.00 |
| 2e. - Reclamation | Table 3 | YES | YES | $0.00 | $0.00 |
| 3. Alternate | Table 3 | YES | YES | $0.00 | $0.00 |
| 4. Substitute | Table 3 | YES | YES | $0.00 | $0.00 |
| 4a. - Substitute due to ROHS | Table 3 | YES | YES | $0.00 | $0.00 |
| 5. Aftermarket | Table 3 | YES | YES | $0.00 | $0.00 |
| 6. Emulation | Table 3 | YES | YES | $0.00 | $0.00 |
| 7. Reverse Engineering (Hybrids) | Table 3 | YES | YES | $0.00 | $0.00 |
| 8. Redesign – Minor (ASIC) (Footprint of the board stays the same) | Table 3 | YES | YES | $0.00 | $0.00 |
| 9. Redesign – Major (Footprint of the board changes) | Table 3 | YES | YES | $0.00 | N/A |
| 10. Tech Insert/Refresh | Table 3 | YES | YES | TBD | N/A |
| 11. Need More Research | Table 3 | YES | YES | TBD | TBD |
| 12. COTS / Subcontracted Assemblies | |||||
| 12a. – No Action Required | Table 3 | YES | YES | N/A | N/A |
| 12b. - Design Longevity (DMSMS Support for Vendor) | Table 3 | YES | YES | TBD | TBD |
| 12c. - Extend OEM Maintenance Agreement | Table 3 | YES | YES | TBD | TBD |
| 12d. - Purchase 3rd Party Maintenance Agreement | Table 3 | YES | YES | TBD | TBD |
| 12e. – Life of Type Buy (LOT Buy) or Bridge Buy | Table 3 | YES | YES | TBD | TBD |
| 12f. – Alternate | Table 3 | YES | YES | $0.00 | $0.00 |
| 12g. - Tech Insert/Refresh | Table 3 | YES | YES | TBD | N/A |
| 12h. – Redesign/Integrated Change | Table 3 | YES | YES | $0.00 | N/A |
| 12i. – Purchase Data Rights | Table 3 | YES | YES | TBD | N/A |
| 12j. – Reclamation Salvage | Table 3 | YES | YES | $0.00 | $0.00 |
| ASIC (Application Specific Integrated Circuit ) |
ECP (Engineering Change Proposal) ROHS (Restriction of Hazardous Substances)
&A Page &P of &N
Table 2 -Obsolescence Summary Table 2 Obsolescence Summary by Platform (MH-60R, MH-60S, HH-60H, SH-60B, SH-60F), System, WRA, and SRA
| CDRL NO. | Delivery Due Date | Review Due Date | Company Name | Technical POC Name | Technical POC Phone # | Technical POC E-Mail | NOTES | |||||||||||||
| System Obsolescence Summary | ||||||||||||||||||||
| Part Type | Next Higher Assembly | REFDES | P/N | Nomenclature | BOM Delivered to PMA299 | Monitored Parts | Red Parts | List Red Parts | Yellow Parts | List Yellow Parts | Orange Parts | List Orange Parts | Green Parts | Gray Parts | List Gray Parts | COTS Parts | Current Health Status | 2 Year Health Status | 5 Year Health Status | Comments |
| System | ||||||||||||||||||||
| WRA/SRA/COTS Obsolescence Summary | ||||||||||||||||||||
| Part Type (WRA/SRA/COTS) | Next Higher Assembly | REFDES | P/N | Nomenclature | BOM Delivered to PMA299 | Monitored Parts | Red Parts | List Red Parts | Yellow Parts | List Yellow Parts | Orange Parts | List Orange Parts | Green Parts | Gray Parts | List Gray Parts | COTS Parts | Current Health Status | 2 Year Health Status | 5 Year Health Status | Comments |
| Note: If the system is comprised of multiple WRA(s) list the first WRA followed by the SRA(s) in that WRA and then list the next WRA followed by it's SRA(s) etc. | ||||||||||||||||||||
| Red (R): A part that is not in production by the original manufacturer. No FFF (Form Fit and Function) part is available that’s in production. High cost and high risk resolution due to redesign and requalification. | ||||||||||||||||||||
| Yellow (Y): A part that is not in production by the original manufacturer. A FFF (Form Fit and Function) part is available that's in production. Qualification Issues, requires in circuit testing, minimal cost, minimal risk resolution. | ||||||||||||||||||||
| ORANGE (O): A part that is still in production by the original manufacturer but a Life-of-Type buy date has been issued by the original manufacturer on the part. LTB cost, no risk resolution. | ||||||||||||||||||||
| Green (G): A part that is still in production by the original manufacturer or an authorized aftermarket source i.e. Rochester Electronics, Lansdale, E2V/QP Semiconductor, etc. No cost, no risk resolution. | ||||||||||||||||||||
| Gray (G): A part that is currently under research to determine its obsolesce status. | ||||||||||||||||||||
| COTS (Commercial off-the-shelf): By definition are software or hardware products/parts used in commercial applications and environments that are ready-made and available for sale to the general public. COTS products/parts require a manual survey of the manufacturer to determine the obsolescence status. | ||||||||||||||||||||
| Current Health Status: Based on current obsolescence and current availability of parts can the OEM supply the required Quantities, as specified by PMA299, that currently are needed to support new production, spares and repairs of the specified Part Type (WRA/SRA/COTS) P/N. (Green if YES and Red if NO) | ||||||||||||||||||||
| 2 Year Health Status: Based on current obsolescence and current availability of parts can the OEM supply the required Quantities, as specified by PMA299, that are needed to support new production, spares and repairs of the specified Part Type (WRA/SRA/COTS) P/N for the next 2 years. (Green if YES and Red if NO) | ||||||||||||||||||||
| 5 Year Health Status: Based on current obsolescence and current availability of parts can the OEM supply the required Quantities, as specified by PMA299, that are needed to support new production, spares and repairs of the specified Part Type (WRA/SRA/COTS) P/N for the next 5 years. (Green if YES and Red if NO) | ||||||||||||||||||||
| CDRL/OMIS BOM STATUS: If a BOM has been delivered to PMA 299 list the CDRL Number if not List "NO". |
&A Page &P of &N
Table 3 - Obsolescence Issues
| # | Table 3A | |||
| Parts / Components / COTS / Subcontracted Assemblies Obsolescence Issues | Table 3B | |||
| Parts / Components / COTS / Subcontracted Assemblies Obsolescence Issues | Table 3C |
Parts / Components / COTS / Subcontracted Assemblies Obsolescence Issues Red (R): A part that is not in production by the original manufacturer. No FFF (Form Fit and Function) part is available that’s in production. High cost and high risk resolution due to redesign and requalification.
Yellow (Y): A part that is not in production by the original manufacturer. A FFF (Form Fit and Function) part is available that's in production. Qualification Issues, requires in circuit testing, minimal cost, minimal risk resolution.
ORANGE (O): A part that is still in production by the original manufacturer but a Life-of-Type buy date has been issued by the original manufacturer on the part.
Green (G): A part that is still in production by the original manufacturer or an authorized aftermarket source i.e. Rochester Electronics, Lansdale, E2V/QP Semiconductor, etc. No cost, no risk resolution.
Gray: A part that is currently under research to determine its obsolesce status. Red (R): A part that is not in production by the original manufacturer. No FFF (Form Fit and Function) part is available that’s in production. High cost and high risk resolution due to redesign and requalification.
Yellow (Y): A part that is not in production by the original manufacturer. A FFF (Form Fit and Function) part is available that's in production. Qualification Issues, requires in circuit testing, minimal cost, minimal risk resolution.
ORANGE (O): A part that is still in production by the original manufacturer but a Life-of-Type buy date has been issued by the original manufacturer on the part.
Green (G): A part that is still in production by the original manufacturer or an authorized aftermarket source i.e. Rochester Electronics, Lansdale, E2V/QP Semiconductor, etc. No cost, no risk resolution.
Gray: A part that is currently under research to determine its obsolesce status. Red (R): A part that is not in production by the original manufacturer. No FFF (Form Fit and Function) part is available that’s in production. High cost and high risk resolution due to redesign and requalification.
Yellow (Y): A part that is not in production by the original manufacturer. A FFF (Form Fit and Function) part is available that's in production. Qualification Issues, requires in circuit testing, minimal cost, minimal risk resolution.
ORANGE (O): A part that is still in production by the original manufacturer but a Life-of-Type buy date has been issued by the original manufacturer on the part.
Green (G): A part that is still in production by the original manufacturer or an authorized aftermarket source i.e. Rochester Electronics, Lansdale, E2V/QP Semiconductor, etc. No cost, no risk resolution.
Gray: A part that is currently under research to determine its obsolesce status.
| Obsolescence Initial Issue Data (Fill in When first reporting an Obsolescence Issue) | Obsolescence Interim Solution Data (Fill in current status of an obsolescence issue that has not been resolved) | Obsolescence Final Solution Data (Fill in when an obsolescence issue has been resolved) | ||||||||||||||||||||||||||||||||
| STATUS (Pick One of the following: New / Unresolved / Resolved) | Case Sheet Number | OMIS OCL # | Open Date | LTB Date | Impact Date | SCD P/N (Original) | Vendor P/N (Original) | Vendor P/N Cage Code (Original) | P/N Description | NHA P/N | WRA P/N | SYSTEM P/N | Vendor P/N Status (R,Y,O,G) | LOT BUY QUANTITY | LOT BUY UNIT PRICE | LOT BUY TOTAL COST | WHO IS FUNDING LOT BUY | HAS LOT BUY BEEN FUNDED | HAS LOT BUY BEEN EXECUTED | Span of Coverage Part Buy is Good for | Alternate P/N | Alternate P/N Cage Code | Is Alternate P/N Under Engineering Evaluation (Yes/No) | Has Alternate P/N Been Approved (Yes/No) | Has Final Resolution Been Implemented (Yes/No) and provide details for either Yes or No | Solution Type (Table 1) | Solution Cost (Actual or from Table 1) | Solution Cost Avoidance (Actual or from Table 1) | Solution SCD P/N (Replacement) | Solution Vendor P/N (Replacement) | Solution Vendor P/N Cage Code (Replacement) | Closed Date | NOTES: | |
| 1 | ||||||||||||||||||||||||||||||||||
| 2 | ||||||||||||||||||||||||||||||||||
| 3 | ||||||||||||||||||||||||||||||||||
| 4 | ||||||||||||||||||||||||||||||||||
| 5 | ||||||||||||||||||||||||||||||||||
| 6 | ||||||||||||||||||||||||||||||||||
| 7 | ||||||||||||||||||||||||||||||||||
| 8 | ||||||||||||||||||||||||||||||||||
| 9 | ||||||||||||||||||||||||||||||||||
| 10 | ||||||||||||||||||||||||||||||||||
| 11 | ||||||||||||||||||||||||||||||||||
| 12 | ||||||||||||||||||||||||||||||||||
| 13 | ||||||||||||||||||||||||||||||||||
| 14 | ||||||||||||||||||||||||||||||||||
| 15 |
&A Page &P of &N
Table 4 - Monitored Part List Table 4 Monitored Parts List
| NHA P/N | SCD P/N | Vendor P/N | Vendor P/N Cage Code | Vendor P/N QTY | Vendor P/N Description | Status (R,Y,O,G Gray) | Sourcing Issues and Recommended Resolutions |
| Red (R): A part that is not in production by the original manufacturer. No FFF (Form Fit and Function) part is available that’s in production. High cost and high risk resolution due to redesign and requalification. | |||||||
| Yellow (Y): A part that is not in production by the original manufacturer. A FFF (Form Fit and Function) part is available that's in production. Qualification Issues, requires in circuit testing, minimal cost, minimal risk resolution. | |||||||
| ORANGE (O): A part that is still in production by the original manufacturer but a Life-of-Type buy date has been issued by the original manufacturer on the part. LTB cost, no risk resolution. | |||||||
| Green (G): A part that is still in production by the original manufacturer or an authorized aftermarket source i.e. Rochester Electronics, Lansdale, E2V/QP Semiconductor, etc. No cost, no risk resolution. | |||||||
| Gray (Gray): A part that is currently under research to determine its obsolesce status. |
&A Page &P of &N
Other DMSMS Issues
| 5.1 Planned Upgrades Due to DMSMS Issues | |
| Provide a description and solution for planned ECP upgrades to CCAs due to obsolescence, part number changes, and redesigns. | |
| Example: No planned ECP upgrades to any CCAs at this time | |
| 5.2 Proposed Upgrades Due to DMSMS Issues | |
| Provide a description and solution for proposed ECP upgrades to CCAs due to obsolescence, part number changes, and redesigns. | |
| Example: No proposed ECP upgrades to any CCAs at this time | |
| 5.3 COTS DMSMS Issues | |
| Provide a description and solution for COTS DMSMS issues due to obsolescence, part number changes, and redesigns. | |
| Example: No COTs DMSMS issue at this time | |
| 5.4 Passive DMSMS Issues | |
| Provide a description and solution for passive component DMSMS issues due to obsolescence, part number changes, and redesigns. | |
| Example: No passive DMSMS issue at this time | |
| 5.5 Electro-Mechanical DMSMS Issues | |
| Provide a description and solution for electro-mechanical component DMSMS issues due to obsolescence, part number changes, and redesigns. | |
| Example: No electro-mechanical DMSMS issues at this time | |
| 5.6 Mechanical DMSMS Issue | |
| Provide a description and solution for mechanical component DMSMS issues due to obsolescence, part number changes, and redesigns. | |
| Example: No Mechanical DMSMS issues at this time | |
| 5.7 Software DMSMS Impact Issues | |
| Provide a description and solution for software DMSMS issues due to software obsolescence, part number changes, and redesigns | |
| Example: No software DMSMS issues at this time |
&A Page &P of &N
File details come from the government source that posted it. Updated .