DMSMS Obsolescence Management Worksheet
DMSMS stands for Diminishing Manufacturing Sources and Material Shortages, the problem of parts going out of production before a defense program ends. This worksheet gives you a working tracker for parts at risk, with stock cover and a simple risk score.
| Part number | Description | Lifecycle status | On hand (pcs) | Monthly usage (pcs/mo) | Months of cover | Likelihood (1-5) | Impact (1-5) | Risk score | Resolution | Decision date | |
|---|---|---|---|---|---|---|---|---|---|---|---|
7 | 15 | ||||||||||
12 | 2 | ||||||||||
5.6667 | 25 | ||||||||||
13.8889 | 1 | ||||||||||
5.5 | 12 |
Risk score is likelihood times impact on a 1 to 5 scale, so 15 or more usually deserves an action owner and date. Months of cover divides on-hand stock by monthly usage; rows with zero usage show 0. Replace the sample parts with your own BOM export.
Build an obsolescence watch list from your ERP
An optional review of how on-hand, usage and where-used data can feed this list automatically.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
Paste in the parts you flagged from your BOM health check or a lifecycle service report. Set the lifecycle status, enter on-hand quantity and monthly usage, then score likelihood and impact from one to five. Sort by risk score and assign a resolution and a decision date for every part above your threshold. Export to Excel to share with the program office.
The logic behind the numbers
Months of cover is on-hand quantity divided by average monthly usage, and it tells you how long production can run if supply stops today. Risk score multiplies the probability that supply ends by the damage if it does. A part with high usage and long qualification time scores worse than a commodity resistor with ten approved alternates.
- Likelihood rises with NRND and last-time-buy notices
- Impact rises with sole source, long requalification and no form-fit-function alternate
- Shorter cover than qualification time means act now
Choosing a resolution
Resolution options run from monitoring through last-time buy, approved alternate, redesign and emulation. A last-time buy needs forecast data for the full remaining program life plus a spares allowance, and it ties up cash and storage. Alternates for defense parts often need customer approval, so allow time for that review.
Common mistakes
Teams often track only parts already declared obsolete, missing the NRND stage when options are widest. Others use average usage that ignores a production ramp. Remember also that counterfeit risk rises on obsolete parts bought from the open market, so use authorized sources or documented testing for any such buy.
Frequently Asked Questions
What does DMSMS stand for?
DMSMS means Diminishing Manufacturing Sources and Material Shortages. It describes the loss or impending loss of manufacturers or suppliers of items or raw materials. It is a standard concern in US defense programs with long lifecycles.
What is NRND?
NRND means not recommended for new designs. The manufacturer still produces the part but advises against using it in new products, which is often an early sign that a discontinuance notice may follow.
How do I pick a last-time buy quantity?
Forecast demand across the remaining program life, add spares and repair needs, then consider shelf life, storage and cash cost. Also factor in yield loss. This worksheet helps you see cover, but the forecast itself comes from your program plan.
Does the worksheet replace a lifecycle database?
No. Commercial lifecycle services supply the status data. This worksheet organizes the response: who owns each part, what action is planned and when the decision is due.
If your ERP holds on-hand quantities and where-used data, Netray can generate this list directly from live stock and BOM tables and refresh it on a schedule.
Related Tools
Component Obsolescence Risk Assessment
Answer 10 questions to score how exposed your BOMs are to component EOL, DMSMS, and lifecycle blind spots, with graded recommendations.
Aerospace & DefenseCounterfeit Parts Risk Assessment (AS5553)
A 10-question assessment of your counterfeit electronic parts exposure, aligned to AS5553 and DFARS counterfeit prevention requirements, with a risk band and mitigation plan.
Aerospace & DefenseMIL-PRF Component Qualification Tracking Worksheet
Track each qualified component against its MIL-PRF specification, QPL or QML status, quality level, source type, lot date code and cost.
Quality & InspectionRolled Throughput Yield Calculator for PCB Assembly
Multiply first pass yield across print, placement, reflow, inspection and test to see true rolled throughput yield, units needing rework and the cost of that loss.
More Aerospace & Defense tools
See all- Defense Electronics First Article Inspection Template
- MIL-STD-810H Test Methods Reference Table
- MIL-STD-461 EMI/EMC Test Method Reference Table
- CMMC 2.0 Level 2 Readiness Assessment
- ITAR Compliance Checklist for Manufacturers
- DFARS 252.204-7012 Compliance Self-Assessment
- AS9100 Audit Readiness Checklist
- Export Control Screening Checklist
- Defense Contractor AI Readiness Assessment