FedMall – Tools – Supportability
Analysis Stock Out Report
The purpose of the Supportability Analysis (SA) Stock Out Report (SOR) is to proactively identify supportability issues before they actually become back-orders. The SA-SOR can assist in Logistics Support Analysis involving DLA managed materiel.
- DLA (SOS: SMS) managed materiel only
- Data extracted is available to all users, except for the DODAAC query
- DODAAC query only returns data on active JDA DDE/CC NSNs associated with the Submitter/Ship To/Sold To DODAAC
- Report results are displayed on screen and/or if >300 NSNs, is emailed to submitter
- The report returns SA, NSN, SOH, AAC, ALT/PLT, etc.
- NSNs with projected SO within 12
Rules of the SOR:
- The SOR is based on total DLA projected stock on hand and total requirements at the NSN level
- NSNs that do not have a current or projected Stock out (SO) will reflect a “ – “ in the following columns: Stock Out Date, Get Well Date, Past Due Receipts Date
- The SOR and Get-Well Date (GWD) is projected based on best available information at the time of the report
- NSNs with SO and have delinquent receipt will reflect the earliest scheduled receipt date on the "Past Due Receipts Date" column
- Non-stocked NSNs or non SOS: SMS
- NSNs will not reflect SO information
- SOR information is “as of date” printed on top of the report
- SA information within the SA-SOR is updated in real-time
- Red, Blue, and Orange will not reflect the date the NSN went into a SO position
- Yellow will reflect the projected date the NSN is expected to run out of stock:
- RED – SO on a Stocked NSNs (AAC: D)
- YELLOW – Potential SO on a Stocked NSNs (AAC: D)
- GREEN – Projected GWD for RED, YELLOW, BLUE or ORANGE code SOs
- BLUE – Non-replenishment NSNs SO, with demands in the last year
- ORANGE – Non-replenishment NSNs SO, no demands in the last year
Note: No GWD provided for Red and Yellow SOs if GWD exceeds 12 months into the future. GWD for Blue and Orange may exceed 12 months into the future and is based on the last scheduled receipt date for the delivery date that exist.
- The SA-SOR information is as current as the date reflected on the *SA-SOR information “as of” date.
- The SA-SOR is exportable to Excel, and sortable.
- Managing Profit Center equals the DLA Supply Chain.
- Item Notes on the NSN is viewable by clicking on the “Notes”; Notes may contain contract (KTR) information, GWD clarification, alternative NSNs, reasons for delayed in shipment, etc.
- The “*” denotes the SO information, which is updated weekly, all other information is mostly based on real-time data.
- Legend information gives clarification to the color coding under *Stock Out Date and *GWD.
- The GWD is blank if AAC: D, NSN is:
- >12 month “Red”
- Projected to be SO by the Stock Out Date “Yellow”
- No scheduled receipts “Blue” or “Orange”
- If the query results exceed 300 NSNs, the report is downloadable by clicking the “Download Completed Reports” link and is emailed to the submitter if the "email results to" box is checked.
- The Supply Codes and definitions are found in the DLA Customer Assistance Handbook.
Contact the Logistics Operations: DLA Training (Customer Support Division) DLA.TNG@dla.mil
This information is provided by: customeroutreach@dla.mil