DID FinderBack
Source
DI-SESS-82320A

Sonobuoy Monthly Status Report

Documents the status of the contractor effort toward achieving contract objectives, including accomplishments, difficulties encountered, and progress compared to planned goals, used by the Government to monitor and evaluate contractor performance.

Approval DateSeptember 30, 2021
AMSC NumberN10269
Preparing ActivityAS
Project NumberSESS-2021-024
OPR—
DTIC ApplicableNo
GIDEP ApplicableNo
Limitation—
Applicable FormsNone
Approval Limitation—
Form Version—
DID Formatfree_text
963C CompliantYes
DISTRIBUTION STATEMENT A: Approved for public release; distribution is unlimited.
Supersedes
DI-SESS-82320
Related
—

Description & Purpose

—

Application & Interrelationship

—

Use & Relationship

The Sonobuoy Monthly Status Report documents the status of the contractor effort towards achieving contract objectives. It identifies accomplishments to date and difficulties encountered, and compares the status achieved to planned goals and the resources expended. It is used by the Government to monitor and evaluate contractor performance.

This Data Item Description (DID) contains the format and content, and intended use information for the data deliverable resulting from the work task described in the contract.

This DID supersedes DI-SESS-82320.

Preparation Instructions

1Reference Documents
2FormatThe format for the report shall be any combination of the following: Microsoft (MS) Power Point Presentation, MS Excel, or MS Word and shall include graphics as required.
3Content
3.1The content for the Sonobuoy Monthly Status Report shall be as follows
3.1.1Materials
3.1.1.1Obsolete and potentially obsolete parts status
3.1.1.2Diminishing Manufacturing Sources and Material Shortages (DMSMS)
3.1.1.3Material, Supplier, Critical Supplier Changes
3.1.1.4Supplier Site Visit Schedule
3.1.1.5Supplier Management & Supplier QualitySee Figure 1 for additional guidance.
3.2Production and Contractor Data Requirements List (CDRL) contract and actual delivery schedules to includeContract number, nomenclature of the system or program, and period covered by the report.
3.3Summary of recent testing(sample lot, Engineering Change Proposal [ECP] or qualification), test results, and failure analysis.
3.4Risk Matrix with risk description, impact, response and actionsShall be included.
3.5Status of engineering test units provided as part of the contractWith brief summary of results/failures.
3.6A list and summary of ECP status, including identification of proposed ECPs, approved ECPs, and implemented ECPs to include the followingContract and buoy type, description of change, level of change, purpose of change, lot number and date that ECP changes were implemented into production.
3.7Any significant changes to the contractor's organization or method of operationTo the project management network, to the production line layout, or to the milestone charts.
3.8Problem areas affecting technical, scheduling or cost elements of the programsWith background, and any recommendations for solutions beyond the scope of the contract.
3.9Plans of activities during the following reporting periodTo include meeting schedule and certification event.
3.10Quality
3.10.1Quality metrics that are documented and tracked in support of the Contractor's Quality Management System (QMS)To include metrics and findings associated with scrap, repair, rework, first pass yield, lot acceptance test results/failures, Engineering Test Article results/failures, FIAR investigation results; and the root cause and corrective actions (RCCA) taken to mitigate and preclude their reoccurrence.
3.10.1.1Continuous Process Improvements
3.10.2Internal AS9100 schedule chart
3.10.3Listing of all open and new events for the current monthly reporting period, by buoy type, with a brief description, including remaining actions to closure, of the following
3.10.3.1List of Company internal Class II Engineering Change Notices (ECN)
3.10.3.2Nonconforming Material Reports (NMCR/QIR)
3.10.3.3Corrective & Preventive Action Requests (CAR/CAPA)
3.10.3.4Requests for Variance
3.10.3.5Internal failures due to Calibration
3.11Fill out Figure 2 "Delta PRR Content" on a monthly basisAnd provide briefing material associated with the areas that were identified as having changed.
3.12Sonobuoy Defect Waterfall ChartsThe Sonobuoy Defect Waterfall Chart provides a concise, visual reference of current and historical Lot Acceptance Test results. It provides information for each Production Lot with regard to manufacturing completion date, samples testing location and date, # of samples tested, # of defects recorded, PASS/FAIL status, and description of the defects observed. A separate chart must be maintained for each buoy type, and must be included as slides in the Monthly Production Status Report CDRL A00A. In addition, the updated Excel files are to be submitted for each buoy type along with the Monthly Production Status Report. Instructions for building and maintaining the spreadsheets are provided below. Table 1 provides a visual reference of the spreadsheet. Example data is included in the Table for clarity.
3.12.1Reference Document(s)N/A
3.12.2FormatThe Chart shall be in Microsoft Excel format, Arial 10 or 11-point font. Cells should be set to wrap. Cells should be formatted per the Table below, i.e., Date formatting, Text, and Number field formats. All number fields should be numeric, with zero (0) decimal places. Fields including alphanumeric information should be Text formatted. Columns of PASS Lots should be highlighted Green. Columns of FAILED Lots should be highlighted light red.
3.12.3Content
3.12.3.1Row 1 should provide the Chart Title "Defect Waterfall Chart"Including buoy type, manufacturer name, Contract #, and Submittal Date.
3.12.3.2Rows 2-14 should be titled in column B as shown in Table 1With appropriate data provided beginning in column C. The manufacturer shall supply the information requested in Rows 2-6. The information in Rows 7-10, 12, and 14 can be found in the Acceptance Test Report (ATR) provided by the Government following each Lot Acceptance Test. These reports are submitted to the manufacturer typically within two business days following the test. Rows 11 and 13 (Cumulative Totals of Major and Minor Defects) shall be calculated.
3.12.3.3Rows 15 and 16 form the transition to display of Defects observed during the Lot Acceptance TestingRow 16 is the Header for the Major Defects to be recorded below.
3.12.3.4The actual Defect Codes to be recorded in the ChartCan be found in the ATR submitted by the Government following each Lot Acceptance Test. Enter the Code in column A and the Description in column B. Only the Defects observed should be listed on the Chart. The list will grow as the number of tests displayed (i.e., # of columns) increases. Add or insert Rows as necessary, while maintaining the Defect Codes listed in proper alphanumeric sort order (per the Code in column A).
3.12.3.5Below the section for Major Defects is a section for Minor DefectsThis should be maintained in similar fashion to 3.12.3.4.
3.12.4General Instruction
3.12.4.1Manufacturer should use judgement regarding the number of columns displayed on the slides in the Monthly ReportMore than 15 columns of data in Landscape format will become difficult to read. Add Slides as necessary to cover the desired amount of historical data. Typically, the current and prior Government Fiscal Years (GFY) is sufficient.
3.12.4.2Freezing columns A and B will allow data columns to be hidden if necessaryWhen preparing snapshot slides for reporting.
3.12.4.3Each buoy type Excel file should segregate the data using individual tabs for each GFYA Chart/Tab should only include data from Lots of a single Contract Year. Contract Year Lots are as specified in the Contract by year, i.e., the year of Lot Purchases. They are NOT related to the actual date of manufacture and/or testing.
3.12.4.4Lot # nomenclature shall include appropriate indicationIf a Lot was previously withdrawn from testing (e.g., Lot 9(W)) or if Samples were submitted for testing a second or a third time (e.g., Lot 9(2), 9(3)).
3.12.4.5Lot # columns shall be ordered chronologically by Lot Acceptance Test Date

References

—

Figures

Figure 1: Please reference the following Power Point slides as guides to help illustrate the information and content the Supplier Management & Supplier Quality presentation slides shall capture.

Figure 1. Please reference the following Power Point slides as guides to help illustrate the information and content the Supplier Management & Supplier Quality presentation slides shall capture.

Figure 2: Delta PRR Content

Figure 2. Delta PRR Content

Figure Table 1: Defect Waterfall Chart

Figure Table 1. Defect Waterfall Chart

Schema v3.0Community-maintained · Verify against ASSIST
Community-maintained — not an official government database.
Verify against ASSIST·GitHub·About·Disclaimer