# DMSMS Obsolescence Management Worksheet

> Source: https://netray.co/tools/dmsms-obsolescence-management-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

A part-by-part obsolescence tracker that computes months of stock cover and a likelihood-by-impact risk score so you can see which parts need a last-time buy or redesign first.

## Category

aerospace-defense

## Industry

Defense Electronics

## Audience

- Supply chain manager
- Program manager
- Component engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Part number

**Key:** part

**Type:** text

#### Description

**Key:** desc

**Type:** text

#### Lifecycle status

**Key:** status

**Type:** select

**Options:**

- Active
- NRND
- Last time buy notice
- Obsolete
- Unknown

#### On hand

**Key:** onhand

**Type:** number

**Unit:** pcs

#### Monthly usage

**Key:** monthly

**Type:** number

**Unit:** pcs/mo

#### Months of cover

**Key:** cover

**Type:** number

**Expr:** onhand / monthly

**Format:** decimal

#### Likelihood (1-5)

**Key:** like

**Type:** number

#### Impact (1-5)

**Key:** impact

**Type:** number

#### Risk score

**Key:** score

**Type:** number

**Expr:** like * impact

**Format:** integer

#### Resolution

**Key:** action

**Type:** select

**Options:**

- Monitor
- Last time buy
- Approved alternate
- Redesign
- Emulation / reverse engineer

#### Decision date

**Key:** due

**Type:** date

**Rows:**

**Part:** XC7K325T-2FFG900I

**Desc:** FPGA, 900-ball BGA

**Status:** NRND

**Onhand:** 140

**Monthly:** 20

**Like:** 3

**Impact:** 5

**Action:** Last time buy

**Due:** 2026-12-01

**Part:** LM2596S-5.0

**Desc:** Buck regulator, 5 V

**Status:** Active

**Onhand:** 600

**Monthly:** 50

**Like:** 1

**Impact:** 2

**Action:** Monitor

**Due:** 2027-03-01

**Part:** MC68HC11E1CFN2

**Desc:** Legacy microcontroller

**Status:** Obsolete

**Onhand:** 85

**Monthly:** 15

**Like:** 5

**Impact:** 5

**Action:** Redesign

**Due:** 2026-11-15

**Part:** CRCW060310K0FKEA

**Desc:** Thick film resistor 10k

**Status:** Active

**Onhand:** 25000

**Monthly:** 1800

**Like:** 1

**Impact:** 1

**Action:** Monitor

**Due:** 2027-06-01

**Part:** DS1307Z+

**Desc:** Real-time clock

**Status:** Last time buy notice

**Onhand:** 220

**Monthly:** 40

**Like:** 4

**Impact:** 3

**Action:** Approved alternate

**Due:** 2026-12-15

**Totals:**

#### Total pieces on hand

**Key:** onhand

**Agg:** sum

**Format:** integer

#### Highest risk score

**Key:** score

**Agg:** max

**Format:** integer

**Summary:**

#### Average risk score

**Key:** avg_risk

**Expr:** avg_score

**Format:** decimal

#### Shortest cover (months)

**Key:** short_cover

**Expr:** min_cover

**Format:** decimal

**Primary:** true

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How to use the worksheet

**Body:** 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

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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.

**Cta:** 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.

**Faq:**

#### What does DMSMS stand for?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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.

## Search terms

dmsms worksheet, dmsms tracking template excel, obsolescence management plan template, diminishing manufacturing sources and material shortages, last time buy worksheet, component obsolescence tracker, dmsms risk score, bom obsolescence excel

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json