Attachment 14A - QMS_3Apr-pg.pdf

Military Sealift Command Managers’ Internal Control- Quality Management System

Procedure

N4.41.5224.1-WP

Rev 2

Endorsed by the QMS Steering Committee

Issued By: SSIC: 5224

Joe Hennessy N4, Director, Logistics

Afloat Supply Continuous Monitoring Program

REFERENCES

(a) NAVSUP P-485, Vol 1 and Vol 2 Afloat Supply Procedures

(b) COMSCINST 4000.2 series, Afloat Supply Procedures Policy

(c) COMSC Norfolk VA 191412Z Sep 22, Afloat Logistics Guidance (ALG)

(d) N4.44.4340.2-W, Afloat Government Owned Government Operated (GOGO) Excess Storeroom Item (SRI) Material Management

(e) COMSC Norfolk VA 131735Z SEP 21, Fleet Asset Sharing (FAS) and Asset Redistribution (AR) Guidance

(f) N4.41.7520.1-Q-W, Afloat Government Owned Government Operated (GOGO) Fleet

End-Use Audit Procedures

(g) COMSC Norfolk 181506Z May 22, FY22 Afloat Government Owned Government

Operated (GOGO) Supply Department FIAR Audit Tasker

(h) NAVSUP 723, Navy Inventory Integrity Procedures

(i) NAVSUP P-488, COSAL Use and Maintenance Manual

(j) COMSC Norfolk VA 051819Z Oct 22, Afloat Financial Guidance (AFG)

1 PURPOSE: Provide guidelines for Continuous Monitoring Program (CMP) for Military

Sealift Command (MSC) Government-Owned and Government-Operated (GOGO) Ships to ensure Supply afloat audit readiness.

1.1 This procedure does not replace instructions issued by higher authority, but rather sets policy not stated elsewhere and clarifies procedures wherein the Type Commander (TYCOM) is afforded an option. Use this QMS as a primary supplemental policy to references (a) through (j) and other publications, directives, and instructions referenced throughout this procedure.

1.2 This functional guide provides the basic objective, duties, and responsibilities of the CMP Team and Ships Supply Officer (SUPPO)/Junior Supply Officer (JSO). It is a guide and is not intended to restrict the initiative of any individual.

MSC Managers’ Internal Control-Quality Management System

Procedure

N4.41.5224.1-WP

Rev 2

Afloat Supply Continuous Monitoring Program Page 2 of 39

2 CANCELLATION/SUPERSESSION: Afloat Supply Continuous Monitoring (CM), Program, N4.41.1-Q, N4.41.5224.1-WP.

3 BACKGROUND / OBJECTIVES / APPLICABILITY:

3.1 Background: Afloat supply department personnel utilize the Shipboard Configuration Logistics Information Program (ShipCLIP) in the daily performance of their required tasks, and, through database replication, generate readiness data. Examples include issuing, receiving, requisitioning, and inventorying stock /allowance items; offloading excess inventory ashore; and expending expired shelf life material. MSC's Corrective Maintenance and Logistics System (CMLS) captures these transactions via data replication from ShipCLIP and summarizes them on the CMLS Continuous Monitoring Dashboard and CMP Dashboard (future). The CMLS Continuous Monitoring Dashboard dashboard and CMP dashboard color-codes the summarized data under respective Readiness Indicator (RI) tabs based on percentage ranges specified in para 5.2. Green CMP dashboard summaries indicate a ship is operating within TYCOM standards. Yellow and red CMP dashboard summaries indicate a ship is operating below TYCOM standards. Focusing on yellow and red indicators, the CMP Team analyzes afloat End-Use and Navy Working Capital Fund (NWCF) supply functional readiness data, identifies corrective action, training plans, and supports/coordinates actions to improve indicators.

3.2 Objective: Standardize the work procedures and practices by which the Logistics Directorate's (N4) CMP Team oversees afloat End-Use and NWCF supply functional readiness, identifies sub-optimal areas of execution, and coordinates solutions for improving performance in these areas.

3.2 Applicability: All MSC GOGO shipboard supply functional areas. These procedures will be expanded to include Government-owned Contract-operated (GOCO) ships in the future.

4 ROLES AND RESPONSIBILITIES:

4.1 MSC Logistics Operations Division (N41). Executes afloat Supply Department CMP, monitoring key afloat Readiness Indicator (RIs) and as required, recommending courses of action for improving readiness standards or moving RIs to within thresholds. The MSC Logistics Operations Division establishes RI criteria and evaluates which criteria are most important or relevant.

4.2 SUPPOs and JSOs on applicable ships. The SUPPO/JSO is responsible for maintaining positive control and accountability for all End-Use, Defense Working Capital Fund (DWCF), and NWCF material and financial records afloat. He/she must maintain an accountability file that becomes part of the retained financial and inventory files for CMP audit readiness. The SUPPO/JSO will respond to parrish.guerrero1 Cross-Out

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 3 of 39 correspondence from N41 and CMP Team in order to improve readiness criteria.

4.3 CMP Team:

4.3.1 Collects data, develops metrics, and generates reports in order to review RIs as assigned by N41.

4.3.2 Manages and conducts in-depth analysis of key End-Use and NWCF afloat functional RIs.

4.3.3 Coordinates corrective actions with N4 leadership, Program Managers (PM), ship’s SUPPO/ JSO, and N4 subject matter experts (SMEs) in those areas falling below established standards identified in references (a) through (i), or to improve a RIs, as directed by N41.

4.3.2 The CMP Team plays a direct role in monitoring, analyzing, and providing corrective action recommendations to shipboard activity and performance as well as providing training (high-velocity) to assigned ship Supply Department Civilian Mariners

(CIVMAR).

4.3.3 The CMP Team works closely with N41, N44, N45, N46, and N48 to coordinate shipboard actions with N4 leadership and Program Managers.

5 PROCEDURES / PROCESSES:

5.1 The CMP Team shall review the CMP Dashboards by ship class, PM, and individual hull. Using the CMP Dashboards, Supply Effectiveness and Analysis (SEAs) reports, and Inventory Posture and Effectiveness Metrics, described in paragraphs 5.2 - 5.9 below, the CMP Team will identify those ships falling below performance thresholds outlined in references (a) through (i) by yellow or red CMP Dashboard status.

5.2 CMP R I s : This section includes applicable TYCOM goals, RI purpose, RI grading criteria, potential causes of low scores, required analysis, RI Grid Summary, RI Summary Detail, and RI Grid drill down.

5.2.1 Net Effectiveness: Supply Effectiveness provides the Supply

Officer and higher authority a trend analysis on the effectiveness and readiness of the supply operation. Net Effectiveness is a measure of how well the carried inventory is managed and is an indicator of timely stock replenishment practices. Therefore, minimizing Not in Stock (NIS) demands has a direct impact on Net Effectiveness. Ref.

(a), para. 6236 applies.

5.2.1.1 Purpose: To measure the performance, management, and

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 4 of 39 determine the percentage of storeroom issues against total demand of storeroom item (SRI)/carried items.

5.2.1.2 Grading criteria: Net effectiveness equals the percentage of total repair part demands for carried items that were issued from onboard stock.

Net Effectiveness = # Repair Part Issues/(# Issues + # NIS).

> = 85% <= 70%

5.2.1.3 Required analysis and primary drivers of low Net

Effectiveness requiring corrective action:

a. Improper inventory management and stock record card maintenance.

b. Delay in reordering storeroom stock increases the probability of an NIS. Ships should reorder for stock material daily.

c. Storeroom inventory and location validity problems. Inventory validity has a great impact on effectiveness. Conducting inventories improves inventory validity, but accuracy will degrade quickly if the receipt and issue processes are not executed flawlessly every day. If inventory validity is low, there will be more NIS hits and effectiveness will suffer.

d. Poor stowage procedures resulting in low inventory accuracy rates.

e. Inadequate or improper labeling of material or locations.

f. Stock Material Outstanding File (MOF) is not routinely worked.

Having the most up-to-date status is important so that parts are put back on the shelf in the shortest time possible. The longer it takes, the higher the probability of an NIS.

g. Preliminary and causative research is not being performed for stock item with overaged shipping status.

h. Overaged shipments are not being processed accordingly.

i. Inadequate stock item table and or requisition maintenance.

j. Incoming status not being downloaded from OTS then uploaded into ShipCLIP.

k. Poor receipt processing procedures.

l. Inadequate storeroom or warehouse processing procedures (issues).

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 5 of 39

m. Range and Depth (R&D) are not being monitored.

n. Stock posture is not in accordance with TYCOM funding and stocking policy of 100% on hand or on order.

o. Failure to submit allowance change requests (ACR).

p. Lack of verification of NIS conditions.

q. Inadequate funding.

5.2.1.4 The Net Effectiveness Grid will reflect grade and drill down of

Mission Criticality Code (MCC) 3 and 4, Repair Part, and Consumable items:

a. Net Effectiveness Grid Summary:

b. Net Effectiveness Grid Detail (Example):

Net Effectiveness (Prior Month) xxx 4 Mo. Net Effectiveness (Prior Month) xxx 12 Mo. Net Effectiveness (Prior Month) xxx # NIS (Prior Month) xxx # Issued (Prior Month) xxx Net Effectiveness MCC 3 and 4 (Prior Month) xxx 4 Mo. Net Effectiveness MCC 3 and 4 (Prior Month) xxx 12 Mo. Net Effectiveness MCC 3 and 4 (Prior Month) xxx # NIS Repair Part MCC 3 and 4 (Prior Month) xxx # Issued Repair Part MCC 3 and 4 (Prior Month) xxx Net Effectiveness Repair Part (Prior Month) xxx 4 Mo. Net Effectiveness Repair Part (Prior Month) xxx 12 Mo. Net Effectiveness Repair Part (Prior Month) xxx # NIS Repair Part (Prior Month) xxx # Issued Repair Part (Prior Month) xxx Net Effectiveness Consumable (Prior Month) xxx 4 Mo. Net Effectiveness Consumable (Prior Month) xxx 12 Mo. Net Effectiveness Consumable (Prior Month) xxx # NIS Consumable (Prior Month) xxx # Issued Consumable (Prior Month) xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 6 of 39

Ship Date Net

Effectiveness (Prior Month)

MCC 3 and 4 Net

Effectiveness (Prior Month)

Repair Part Net

Effectiveness (Prior Month)

Consumable Net

Effectiveness (Prior Month)

CBR 1/29/2021 92.78 86 86 86

CBR 12/18/2020 79.78 75.16 77.45 77.45

CBR 11/30/2020 75.16 77.45 75.16 75.16

CBR 10/23/2020 77.45 77.45 75.16 75.16

CBR 9/27/2020 50.7 50.7 50.7 50.7

CBR 8/28/2020 61.17 61.17 61.17 61.17

CBR 7/23/2020 57.71 57.71 57.71 57.71

c. Net Effectiveness Grid Drill Down:

5.2.2 Gross Effectiveness: Gross Effectiveness equals the percentage of total repair part demands for carried and not carried items that were issued from on board stock. The drill down report captures the number of demands received, issued, not carried (N/C), and NIS. Ref.

a, para. 6236 apply.

5.2.2.1 Purpose: To measure the performance, management, and

determine the percentage of storeroom issues against total demand of storeroom item (SRI)/carried items.

ISSUES

row number dmd_type consumable fsc niin nom part # cog up net u/p allowance ave_mo repair part t-nicn qty dmd mcc 3 and 4 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

NIS

row number dmd_type consumable fsc niin nom part # cog up net u/p allowance ave_mo repair part qty dmd mcc 3 and 4 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 7 of 39

5.2.2.2 Grading: Gross Effectiveness equals the percentage of total repair part demands for carried and not carried items that were issued from on board stock. Gross Effectiveness = Issued / Issued + NIS + NC.

>= 65% <= 55%

5.2.2.3 Required analysis and primary drivers of low Gross

Effectiveness requiring corrective action:

a. Improper inventory management and stock record card maintenance.

b. Demand Processing Parameters that are not set properly.

c. Items with valid demand should be carried on board so it will not be N/C next time

d. Inadequate stock item table and/or requisition maintenance.

e. Failure to submit Fleet COSAL Feedback Report (FCBR).

f. Ensure issues are processed, issues posted, and stock replenishment processed daily.

5.2.2.4 The Gross Effectiveness Grid will reflect grade and drill down of MCC 3 and 4, Repair Part, and Consumable items:

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 8 of 39

a. Gross Effectiveness Grid Summary:

Gross Effectiveness (Prior Month) xxx 4 Mo. Gross Effectiveness (Prior Month) xxx 12 Mo. Gross Effectiveness (Prior Month) xxx # NIS (Prior Month) xxx # Not Carried (Prior Month) xxx # Issued (Prior Month) xxx Gross Effectiveness MCC 3 and 4 (Prior Month) xxx 4 Mo. Gross Effectiveness MCC 3 and 4 (Prior Month) xxx 12 Mo. Gross Effectiveness MCC 3 and 4 (Prior Month) xxx # NIS Repair Part MCC 3 and 4 (Prior Month) xxx # Not Carried Repair Part MCC 3 and 4 (Prior Month) xxx # Issued Repair Part MCC 3 and 4 (Prior Month) xxx Gross Effectiveness Repair Part (Prior Month) xxx 4 Mo. Gross Effectiveness Repair Part (Prior Month) xxx 12 Mo. Gross Effectiveness Repair Part (Prior Month) xxx # NIS Repair Part (Prior Month) xxx # Not Carried Repair Part (Prior Month) xxx # Issued Repair Part (Prior Month) xxx Gross Effectiveness Consumable (Prior Month) xxx 4 Mo. Gross EffectivenesS Consumable (Prior Month) xxx 12 Mo. Gross Effectiveness Consumable (Prior Month) xxx # NIS Consumable (Prior Month) xxx # Not Carried Consumable (Prior Month) xxx # Issued Consumable (Prior Month) xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 9 of 39

b. Gross Effectiveness Grid Detail (Example):

c. Gross Effectiveness Grid Drill Down:

5.2.3 Inventory Range: Range shall be reviewed to identify any category of material with low stock availability. Inventory Range as well as Inventory

Ship Date

Gross Effectiveness

(Prior Month)

MCC 3 and 4 Gross

Effectivene ss (Prior Month)

Repair Part Gross

Effectiveness (Prior Month)

Consumable Gross

Effectiveness (Prior Month)

RAP 1/29/2021 72.58 75 86.99 88

RAP 12/18/2020 51.4 51.4 51.4 51.4

RAP 11/30/2020 58.97 58.97 58.97 58.97

RAP 10/23/2020 72.58 75 86.99 88

RAP 9/27/2020 58.97 58.97 58.97 58.97

RAP 8/28/2020 61.17 61.17 61.17 61.17

RAP 7/23/2020 50.4 50.4 50.4 50.4

ISSUES

row number dmd_type consumable fsc niin nom part # cog up net u/p allowance ave_mo repair part qty dmd mcc 3 and 4 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

NIS

row number dmd_type consumable fsc niin nom part # cog up net u/p allowance ave_mo repair part qty dmd mcc 3 and 4 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

NOT CARRIED

row number dmd_type consumable fsc niin nom part # cog up net u/p allowance ave_mo repair part qty dmd mcc 3 and 4 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 10 of 39

Depth provides the data necessary to evaluate ships’ inventory position. It shall be reviewed during major stock replenishment evolutions, such as deployment load outs, allowance list processing, or Voyage Repair (VR) shortage processing to monitor the progress of the receiving process. After indication of shortage, SRI records must be reviewed to ensure that the item is on order and that the status indicates that the stock requisition is active in the supply system. Stock range values that do not meet goal can contribute to poor effectiveness. Expedite or follow-up action shall be performed when necessary. Requisitions must be generated or procurement action must be initiated for material shortages not on order. Ref. a, paras. 6003, 6007 section 2, and para. 2505; and all policies found in refs. a and h apply.

5.2.3.1 Purpose: To determine the percentage of NIINs that have an allowance quantity and have at least one item on hand.

5.2.3.1 Grading criteria: Range determines the percentage of allowed stock items with at least one on hand divided by the total number of allowed stock items.

> = 94% <= 84%

5.2.3.2 Required analysis and primary drivers of low Inventory Range requiring corrective action:

a. Aggressively review and follow-up on shipment of stock requisitions.

b. Review stock requisitions shipped over 60 days old, conduct spot inventory, make adjustments and process reorders immediately to replenish stock material lost in shipment.

c. Validate inventory and location audit procedures.

d. Review Stock replenishment policies and procedure.

e. Review OPTAR shortfall.

f. Validate NIINs with terminal/obsolete Acquisition Advice Code

(AAC).

g. Validate Erroneous conditions in stock records.

h. Reorder to the Ships authorized level.

5.2.3.3 The Inventory Range grid will reflect grade and drill down of combined Inventory Range, MCC 3 and 4, Repair Part, and Consumable, items:

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 11 of 39

a. Inventory Range Grid Summary:

b. Inventory Range Grid Detail (Example):

Range all xxx Range all Line Items xxx Range all Met xxx Range MCC 3 and 4 xxx Range MCC 3 and 4 Line Items xxx Range MCC 3 and 4 Met xxx Range Repair Part xxx Range Repair Line Items xxx Range Repair Part Met xxx Range Consumable xxx Range Consumable Line Items xxx Range Consumable Met xxx

Combined Range

MCC 3 and 4 Range

Repair Part Range

Consumable Range

AME 1/29/2021 93.71 96.68 93.71 90

AME 12/18/2020 70 70 70 70

AME 11/30/2020 98 98 98 98

AME 10/23/2020 86 86 86 90

AME 9/27/2020 96.68 96.68 96.68 96.68

AME 8/28/2020 85 85 85 85

AME 7/23/2020 95 95 95 95

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 12 of 39

c. Inventory Range Grid Drill Down:

5.2.4 Inventory Depth: Depth shall be reviewed to identify any category of material with low stock availability and below the authorized Ships allowance. Ref. a, paras. 6003, 6007 section 2, and para. 2505; and all policies found in refs. a and h apply.

5.2.4.1 Purpose: To determine the percentage of allowed NSNs

that meet the ship’s authorized allowance.

5.2.4.2 Grading criteria: NIINs with on-hand quantity meeting or exceeding the allowance quantity divided by total number of allowed stock items.

> = 91% <= 79%

5.2.4.3 Required analysis and primary drivers of low Inventory Depth requiring corrective action:

a. Aggressively review and follow-up on shipment of stock requisitions.

b. Review stock requisitions shipped over 60 days old conduct spot inventory, make adjustments and process reorders immediately to replenish stock material lost in shipment.

c. Conduct scheduled inventory when required.

d. Research One Touch Support (OTS) for each item listed to update supply management data (i.e. COG, MCC, FSC, U/I, nomenclature, U/P & NET price, RIP code, etc.) and APLs for repair parts only with JCN. Pay close attention to substitutes and check for acquisition advice code (AAC). Note NSNs with AAC of “L”, “I”, and “K” should be ordered open purchase. Look for replacement NIINS or substitutes for items with "V" and "Y" (obsolete) AACs.

e. Part numbered items should be researched for cross-reference to NIINs utilizing OTS.

Range not met row nomenclature fsc niin cog mcc 3 and 4 erc allowance qty on_hand subs_on_hand stock_due subs_stock_due number t-nicn repair part consumable xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 13 of 39

f. Substitute NIINs shown in FEDLOG or OTS should be verified against ShipCLIP to ensure a cross-reference record exists. If not, build all substitute cross reference records before proceeding with the Tech Edit process.

g. Check NIIN/APL relationship and ensure that quantity ordered does not exceed the quantity installed per application/equipment (QPA). If the respective shipboard departmental representative is ordering over the QPA, it’s an indication of “stockpiling”.

5.2.4.4 The Inventory Depth grid will reflect grade and drill down of combined Inventory Depth, MCC 3 and 4, Repair Part, and Consumable, items:

a. Inventory Depth Grid Summary:

Depth all xxx Depth all Line Items xxx Depth all Met xxx Depth MCC 3 and 4 xxx Depth MCC 3 and 4 Line Items xxx Depth MCC 3 and 4 Met xxx Depth Repair Part xxx Depth Repair Line Items xxx Depth Repair Part Met xxx Depth Consumable xxx Depth Consumable Line Items xxx Depth Consumable Met xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 14 of 39

b. Inventory Depth Grid Detail (Example):

c. Inventory Depth Grid Drill Down:

5.2.5 Material Outstanding File (MOF): Problems with the MOF

can negatively impact all supply operation functions, inventory accuracy, financial accountability, record maintenance, and storeroom accuracy and validity. Proactive MOF maintenance is critical to both supply and maintenance operations. The benefits of proper MOF management include OPTAR savings, decreased requisition lead-time, and increased supply and maintenance effectiveness. It is paramount that all Supply personnel have access to OTS in order to ascertain latest status of requisitions. Those requisitions without valid status need to be followed up or cancelled to de-obligate OPTAR funds. Outstanding requisitions must be reviewed, followed-up and cancellation requests must be prepared and transmitted via OTS.

Refs. b, c, and ref. a paras. 3300-3341 apply.

5.2.5.1 Purpose: To ensure that all stock and DTO outstanding requisitions, older than 5 days, have "valid" and current, supply status.

5.2.5.2 Grading scale: Percentage of outstanding requisitions (> 5 days) on report that have valid status divided by the total number of outstanding requisitions (> 5 days).

> = 98 <= 89.99%

Depth

MCC 3 and 4 Depth

Repair Part Depth

Consumable Depth

TIP 1/29/2021 96.68 96.68 96.68 96.68

TIP 12/18/2020 95.98 96.68 95.98 96.68

TIP 11/30/2020 75 80 93.96 96.68

TIP 10/23/2020 93.71 96.68 93.71 96.68

TIP 9/27/2020 90 96.68 90 96.68

TIP 8/28/2020 93.01 96.68 93.01 96.68

TIP 7/23/2020 94.95 96.68 94.95 96.68

Depth not met row nomenclature fsc niin cog mcc 3 and 4 erc allowance on_hand subs_on_hand stock_due subs_stock_due number t-nicn repair part consumable xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 15 of 39

5.2.5.3 Required analysis and primary drivers of poor MOF

management requiring corrective action:

a. Validate over-aged priority designator (PD) 01-08 requisitions 30 days past the requisition date and PD 09-15 requisitions 60 days past the requisition date.

b. Validate requisitions for material no longer required for cancellation submission to the DoD Supply System.

c. Perform preliminary and causative research for stock items with overaged shipping status.

d. Validate incoming status not being cleared in ShipCLIP.

e. Review receipt processing procedures.

f. Review storeroom or warehouse processing procedures (issues).

g. Validate outstanding requisitions with invalid status. The following invalid statuses will cause CMP to be in “YELLOW” or “RED”.

5.2.5.4 The MOF Stock/DTO grid will reflect grade and drill down of requisitions with invalid status

A0 > 5 Days and no status AT > 5 Days and no status AE BM with TD > 10 Days AE BD with TD > 10 Days AE BF Invalid Status AE BB,BV,BC,BP,BZ with passed ESD AE BA,BN with TD > 10 Days AS > 60 Days (90 Deployed) AB > 60 Days (90 Deployed) AU with ESD >= 60 Days A0 with R9 and TD > 45 Days NW > 3 Days (21 Deployed) NL Trans Date > 45 Days (90 Deployed) AC/AK Trans Date > 10 Days Multiple Consecutive Follow-ups (AF/AT) # of STK Rqns with Bad Status # of STK Rqns > 5 days MOF Validity STK

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 16 of 39

a. MOF Stock/DTO Grid Summary:

b. MOF Stock/DTO Grid Detail (Example):

A0 > 5 Days and no status xx AT > 5 Days and no status xx AE BM with TD > 10 Days xx AE BD with TD > 10 Days xx AE BF Invalid Status xx AE BB,BV,BC,BP,BZ with passed ESD xx AE BA,BN with TD > 10 Days xx AS > 60 Days (90 Deployed) xx AB > 60 Days (90 Deployed) xx AU with ESD >= 60 Days xx A0 with R9 and TD > 45 Days xx NW > 3 Days (21 Deployed) xx NL Trans Date > 45 Days (90 Deployed) xx AC/AK Trans Date > 10 Days xx Multiple Consecutive Follow-ups (AF/AT) xx # of STK Rqns with Bad Status xx # of STK Rqns > 5 days xx MOF Validity STK xx

Ship Date MOF

STK

MOF DTO Internal MOV

CHD 12/18/2020 82.95 79.08 79.08

CHD 11/30/2020 88.86 74.35 74.35

CHD 10/23/2020 58.91 37.3 37.3

CHD 9/27/2020 94.36 94.02 94.02

CHD 8/28/2020 66.54 52.17 52.17

CHD 7/23/2020 83.33 30.9 30.9

CHD 8/28/2020 56.27 34.16 34.16

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 17 of 39

c. MOF Stock/DTO Grid Drill Down:

5.2.6 Zero Balance with Zero On-Order: Measures the total number of SRI NIINs which are at zero on-hand and have zero on order. Zero balance on a high demand item, especially very fast moving items, can result in multiple NIS hits, which has a dramatic impact on effectiveness. Ship’s Supply Department team should make every effort to expedite the NIINs having the highest Average Monthly Demand (AMD).

Proactive management will reduce the NIS zero balances and improve both Net and Gross Effectiveness. All policies found in refs. a Chapter 3 and e apply.

5.2.6.1 Purpose: To determine the number of SRIs not in stock with zero on-hand and none on-order (including Substitutes).

5.2.6.2 Grading Criteria:

< = 20 = > 30

5.2.6.3 Required analysis and primary drivers of high Zero Balance with Zero On-Order:

a. Review ship’s authorized allowance quantity.

b. Before deploying, low cost, high average monthly demand (AMD) items should be ordered.

STK BAD MOF

row # desc reqn # niin suffix advice fund doc id status status esd trans pri RDD ri qty cog demand supl signal div dept proj t-nicn code code code doc id code date ordered code address code code code code xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx

STK # of STK Rqns > 5 days row # desc reqn # niin suffix advice fund doc id status status esd trans pri RDD ri qty cog demand supl signal div dept proj t-nicn code code code doc id code date ordered code address code code code code xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx

STK FULL MOF

row # desc reqn # niin suffix advice fund doc id status status esd trans pri RDD ri qty cog demand supl signal div dept proj t-nicn code code code doc id code date ordered code address code code code code xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx xx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 18 of 39

c. Submit Allowance Change Request (ACR) for high AMD NSN.

Increasing quantity above ship’s authorized allowance will improve effectiveness and maintenance support when deployed.

High AMD parts are the most heavily demanded repair parts that must be replenished immediately to the ship’s authorized allowance quantity.

d. Review NIINs with Zero Balance and Zero On-Order to ensure the ship’s allowance quantity is high enough to support extended underway periods or deployment.

e. Requisitioning of stock deficiencies resulting from issues, loss by inventory or Fleet Asset Sharing (FAS) is mandatory to ensure stocked materials are 100% onboard or on-order. Requisitioning of materials must be conducted in accordance with requirements set forth by NAVSUP P-485 Chapter 3.

5.2.6.4 The Zero Balance with Zero On-Order grid will reflect grade and drill down of MCC 3 and 4, Repair Part, and Consumable items.

a. Zero Balance with Zero On-Order Grid Summary:

MCC 3 and 4 Zero balance with zero on order xxx MCC 3 and 4 Zero balance xxx MCC 3 and 4 items xxx Repair Part Zero balance with zero on order xxx Repair Part items Zero balance xxx Repair Part items xxx Consumable Zero balance with zero on order xxx Consumble zero balance xxx Consumable items xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 19 of 39

b. Zero Balance with Zero On-Order Grid Detail (Example):

c. Zero Balance with Zero On-Order Drill Down:

5.2.7 Deficiency to Ships Authorized Allowance: Measures the

total line items and extended money value (EMV) of all authorized SRI deficiencies not on board. This report identifies any stock items that are below ship’s authorized allowance. Report considers substitutes. All policies found in refs. a Chapter 3 and e apply.

5.2.7.1 Purpose: To determine the EMV and number of line items that are below or deficient to the ship’s authorized allowance quantity. Ship Authorized Allowance Deficiency = If (OH + Stk_Due < RO): (RO - OH - Stk_Due) x UP.

5.2.7.2 Grading Criteria: Not required.

5.2.7.3 Required analysis and primary drivers of high Deficiency to Ships Authorized Allowance:

a. Determine stock deficiencies that require replenishment.

b. Review high dollar value and other items suspected of incorrect on

MCC 3 and 4 Zero balance with zero on order

Repair Part Zero balance with zero on order

Consumable Zero balance with zero on order

HJK 1/29/2021 25 22 25 25

HJK 12/18/2020 15 15 15 15

HJK 11/30/2020 15 15 15 15

HJK 10/23/2020 15 15 15 15

HJK 9/27/2020 30 30 30 30

HJK 8/28/2020 15 15 15 15

HJK 7/23/2020 15 15 15 15

row number fsc niin part # cog nom consumable amd inv_flag up nup last allowance on_hand stock_due erc subs subs stock_due t-nicn repair part processed qty on-hand stock due deficiency mcc 3 and 4 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 20 of 39 board allowances. Ensure all applicable NIIN APLs in ShipCLIP are considered for total shipboard allowance.

c. Review for substitutes as required. Build the SRF and update the cross-reference file.

d. Review requisitions for stock items that are no longer available in the supply system are normally rejected with status codes CG, CJ, CK, CU, or CY.

5.2.7.3 The deficiency to ships authorized allowance will reflect grade and drill down of MCC 3 and 4, Repair Part, and Consumable items:

a. Ship Authorized Allowance Deficiency Grid Summary:

b. Ship Authorized Allowance Deficiency Grid Detail (Example):

Below allowance amount (EMV) xxx Below allowance amount MCC 3 and 4 (EMV) xxx Below allowance amount MCC 3 and 4 (line items) xxx Below allowance amount Repair part (EMV) xxx Below allowance amount Repair part (line items) xxx Below allowance amount Consumable amount (EMV) xxx Below allowance amount Consumable (line items) xxx

4 Def to

Allowance

Repair Part Def to Allowance

Consumable Def to

Allowance

WLS 1/29/2021 181,464 75,000 65,000 15,000

WLS 12/18/2020 78,000 45,444 65,000 15,000

WLS 11/30/2020 75,000 33,444 65,000 15,000

WLS 10/23/2020 140,000 109,000 65,000 15,000

WLS 9/27/2020 141,444 102,000 65,000 15,000

WLS 8/28/2020 146,999 30,000 65,000 15,000

WLS 7/23/2020 80,786 50,000 65,000 15,000

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 21 of 39

c. Ship Authorized Allowance Deficiency Grid Drill Down:

5.2.8 Redistributable Assets On Order (RAO): RAO is the value of excess stock material on order. The maximum allowable RAO is 1% of ship’s allowance level.

Ref a, paras 3311-3341 apply.

5.2.8.1 Purpose: To determine RAO as percent of authorized

inventory number of line items and total EMV of SRI.

5.2.8.2 Grading Criteria:

< = 1% = > 3 %

RAO % of SAL = RAO/SAL (Ship’s Authorized Level)

SAL = SAL quantity X Unit Price (U/P) Stock Due = Stock Due X U/P - this is the correct formula On-hand (OH) = OH X U/P

RAO = If OH + Stock Due > SAL

5.2.8.3 Required analysis and primary drivers of high Redistributable Assets On-Order (RAO):

a. Check multiple requisitions for the same NSN. Take the total quantity of these requisitions and check against the quantity per application and total number of equipment installed onboard. Initiate cancellation action for any excess material.

b. Review storeroom stock requisitions for validity.

c. Review ship’s authorized allowance quantity.

d. Validate status of cancellation request for requisitions with excess stock dues quantity.

row number fsc niin part # cog nom consumable amd inv_flag up nup last allowance on_hand stock_due erc subs subs stock_due t-nicn repair part processed qty on-hand stock due deficiency mcc 3 and 4 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 22 of 39

5.2.8.4 The RAO grid will reflect grade and drill down of combined SRI, MCC 3 and 4, Repair Part, and Consumable items:

d. RAO Grid Summary:

e. RAO Grid Detail (Example):

f. RAO Grid Drill Down:

5.2.9 Excess Without Allowance (EWA) Material: EWA is the value of excess stock material on board without equipment application across the same class of ships. The

RAO (total Line items) xxx RAO (total EMV ) xxx MCC 3 and 4 RAO (total Line items) xxx MCC 3 and 4 RAO (Total EMV) xxx Repair Part RAO (total Line items) xxx Repair Part RAO (Total EMV) xxx Consumable RAO (total Line items) xxx Consumble RAO (Total EMV) xxx

4 RAO Repair Part RAO Consumable

RAO

MEV 1/29/2021 5 1 3 4

MEV 12/18/2020 5 1 5 5

MEV 11/30/2020 5 1 2 20

MEV 10/23/2020 5 1 5 5

MEV 9/27/2020 5 1 5 5

MEV 8/28/2020 5 1 5 5

MEV 7/23/2020 5 1 5 5

row number fsc niin part # cog nom requisition status status trans date esd consumable erc up nup allowance total excess t-nicn number doc id code repair part qty on-hand due in mcc 3 and 4 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 23 of 39 maximum allowable EWA is 3% of ship’s allowance level. EWA are items that no longer have adequate demand to be retained onboard, DTO material returned by other departments, or no shipboard equipment application. Removal of excess material frees resources, increases storeroom space and reduces manpower required for shipboard inventory management. Ships are to request removal of excess material 90 days post major availability. Request will be made to the MSC N44 Logistics Type Desk (LTD) for review of authorized allowance quantity and equipment application. Refs. a, paras. 5022-5039, d, and e apply.

5.2.9.1 Purpose: To determine EWA number of line items and total EMV of excess SRI material.

5.9.2.2 Grading criteria:

< = 3% = > 5 %

EWA % of SAL = EWA/SAL (On Hand (OH) – SAL – AR) X U/P

OH = OH X U/P

SAL = SAL quantity X U/P Authorized Retention (AR) = On-hand X U/P > $1,000.00

5.2.9.3 Required analysis and primary drivers of high EWA

requiring corrective action:

a. Inadequate forecasting methods. Inaccurate demand forecasts often lead to carrying too little or too much stock.

b. Review stock reorder process, receipt and issue procedures.

c. Review DTO material returned by other department’s inventory management procedures.

d. Review MOF and excess stock on-order.

e. Validate ship’s authorized allowance.

f. Validate equipment application.

5.2.9.4 The EWA grid will reflect the grade and drill down of combined SRI, MCC 3 and 4, Repair Part, and Consumable items with excess quantity:

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 24 of 39

a. EWA Grid Summary:

b. EWA Grid Detail:

c. EWA Grid Drill Down (Example):

5.2.10 Loss by Inventory/Gain by Inventory (LBI/GBI) Validity: Use to determine the overall SRI inventory condition. An effective program of sample inventories will point to the weak processes (such as issue and receipt processes) that impact inventory validity. If samples show low inventory validity, the SUPPO/JSO must take aggressive action to correct the inventory validity problem and fix the processes that caused the problem. All losses should be researched with the FED-LOG to determine if substitute receipts were incorrectly identified during the receipt process. LBIs/GBIs are recorded in ShipCLIP by posting the results of a spot inventory or scheduled inventory.

Moving the same quantity between different locations will not generate an LBI or GBI.

EWA (total Line items) xxx EWA (total EMV ) xxx MCC 3 and 4 EWA (total Line items) xxx MCC 3 and 4 EWA (total EMV) xxx Repair Part EWA (total Line items) xxx Repair Part EWA (total EMV) xxx Consumable EWA (total Line items) xxx Consumble EWA (total EMV) xxx

Ship Date Combined EWA MCC 3 and 4 EWA Repair Part EWA Consumable

EWA

MEV 1/29/2021 5 2 2 1

MEV 12/18/2020 5 2 2 1

MEV 11/30/2020 5 2 2 1

MEV 10/23/2020 5 2 2 1

MEV 9/27/2020 5 2 2 1

MEV 8/28/2020 5 2 2 1

MEV 7/23/2020 5 2 2 1

row number fsc niin part # cog nom consumable erc up nup emv allowance total location excess quantity t-nicn repair part qty on-hand mcc 3 and 4 xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 25 of 39

Refs. a paras. 5040 - 5042 and 6000 – 6023, b, f, g, and h apply.

5.2.10.1 Purpose: To determine TYCOM goals for CAT A 99%

(DLRs), CAT B 95% (All other material) and CAT C 100% (Controlled Inventory Items) are being met.

5.2.10.2 Grading Criteria:

a. Unit price > $1,000 and all DLRs (CAT A):

Met Not Met

b. All other material (CAT B):

c. Controlled inventory items (CAT C):

5.2.10.3 Required analysis and primary drivers of LBI/GBI requiring corrective action:

a. Before posting any inventory differences, all files should be searched for issues, receipts, FAS not posted, erroneous postings, recent unit of issue changes, identification of deteriorated shelf life material, multiple locations consolidation, substitutes erroneously posted, and location discrepancies.

b. All gains should be compared to the Material Outstanding File (MOF) with status in NIIN sequence to ensure aged requisitions were not received and receipt not posted.

c. Review NIS requirements that can be satisfied with inventory gain.

d. Review location audit procedure.

e. Conduct location audit to verify physically that material in storage locations agrees with location data recorded in ShipCLIP. A well-managed Location Audit Program improves supply effectiveness, reduces inventory effort, improves inventory existence and completeness, and optimizes use of available storage space. A location audit of all storage locations shall be conducted on an annual basis.

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 26 of 39

f. Conduct preliminary and causative research.

g. Storeroom-inventory and location-validity problems.

5.2.10.4 The LBI/GBI Inventory Validity Grid will reflect grade and drill down of category A, B, and C items:

a. LBI/GBI Inventory Grid Summary:

Current Quarter: Category A - Validity xxx Current Quarter: Category A - Validity xxx Current Quarter: Category B - Validity xxx Current Quarter: Category C - Validity xxx Current Quarter: Category A - Inventoried Line Items xxx Current Quarter: Category A - LBI Line Items xxx Current Quarter: Category A - LBI EMV xxx Current Quarter: Category A - GBI Line Items xxx Current Quarter: Category A - GBI EMV xxx Current Quarter: Category A - Total Discrepancy Line Items xxx Current Quarter: Category A - Total Discrepancy EMV xxx Current Quarter: Category B - Inventoried Line Items xxx Current Quarter: Category B - LBI Line Items xxx Current Quarter: Category B - LBI EMV xxx Current Quarter: Category B - GBI Line Items xxx Current Quarter: Category B - GBI EMV xxx Current Quarter: Category B - Total Discrepancy Line Items xxx Current Quarter: Category B - Total Discrepancy EMV xxx Current Quarter: Category C - Inventoried Line Items xxx Current Quarter: Category C - LBI Line Items xxx Current Quarter: Category C - LBI EMV xxx Current Quarter: Category C - GBI Line Items xxx Current Quarter: Category C - GBI EMV xxx Current Quarter: Category C - Total Discrepancy Line Items xxx Current Quarter: Category C - Total Discrepancy EMV xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 27 of 39

b. LBI/GBI Inventory Grid Detail (Example):

c. LBI/GBI Grid Drill Down:

Inventories

(Previous Quarter)

Inventories (Current Quarter)

ESL 12/18/2020 met met ESL 11/30/2020 met met ESL 10/23/2020 met met ESL 9/27/2020 met met ESL 8/28/2020 met met ESL 7/23/2020 not met not met ESL 8/28/2020 not met not met

Category A Discrepancy xxx row number location cog fsc niin erc part # ui qty expenditure nom transactionunit_priceemv code date xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

Category B Discrepancy xxx row number location cog fsc niin erc part # ui qty expenditure nom transactionunit_priceemv code date xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

Category C Discrepancy xxx row number location cog fsc niin erc part # ui qty expenditure nom transactionunit_priceemv code date xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 28 of 39

5.3 Other CMP RIs are in the works: The next review will describe RIs on DLR Carcass, Internal MOV, Shelf Life, and OPTAR Balance.

5.4 CMP Reporting Requirements: During the execution of CMP RI analysis and review of the ship’s requisitions and expenditures, the CMP Team (Senior Logistician and CMP TSAs) must prepare, obtain, and retain documentation to support the transactions, process steps, internal controls, and related activities. Documentation must be maintained in accordance with the Department of the Navy (DoN) records management retention requirements, including but not limited to the following examples.

5.4.1 Documentation must be adequate so that the MSC personnel and ship’s

SUPPO/JSO can clearly understand the correctness of actions taken and determine its accuracy.

5.4.2 Supporting documentation should be prepared in a manner so that a knowledgeable person unfamiliar with the situation could obtain a clear understanding of the CMP metrics, reports, and results of analyses.

5.4.3 Documentation should be maintained in a central location along with associated records, in hard copy, electronic form, or both and made available for review by authorized personnel/agencies and auditors. Supporting documentation in electronic form must be maintained in the MSC N41 CMP Portal.

5.4.4 Data collection/storage: The CMP Team (Senior Logistician and CMP TSAs) will save and electronically file the CMP Dashboard screenshots, raw data, aggregated data, performance metrics reports, drill down and analysis reports, trend charts, graphs, and weekly/monthly/triannual reports in https://msc.navy.deps.mil/sites/N4/N41/N41Documents/Forms/CONTINUOUS%20MONITORI NG%20PROGRAM.aspx. File convention will be by year, month, PM, ship’s class, and ship. Filing protocol facilitates quick data location and retrieval upon N4 leadership or N41 CMP Lead request.

5.5 CMP Monthly Reports: This section will consist of applicable monthly reports but is not limited to CMP Cumulative Performance Metrics (para 5.5.1), CMP RI Grid (para 5.5.2), N41 Drill Down Report and Analysis Reports (para 5.5.3), and Ship’s Drill Down Report and Analysis Reports (5.5.4). The CMP Team will develop the Monthly Cumulative Performance Metrics, N41 Summary Drill Down and Analysis Report, and Ships Drill Down and Analysis report based on in-depth analysis of CMP RIs. The CMP monthly reports and metrics will reflect trend chart, graph, raw data, drill down data, summary of noted deficiencies, required remediation actions, and results of analyses for the past 24 months. On the first day of each month, the CMP Team will pull the RIs data and related information from MSC, DON, and DOD Ashore and Afloat Logistics Systems (e.g. CMLS, ShipsCLIP, and ERP (Enterprise Resource System), One Touch, etc.), Tableau CMP Dashboard, and N45 Inventory and https://msc.navy.deps.mil/sites/N4/N41/N41Documents/Forms/CONTINUOUS%20MONITORING%20PROGRAM.aspx https://msc.navy.deps.mil/sites/N4/N41/N41Documents/Forms/CONTINUOUS%20MONITORING%20PROGRAM.aspx

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 29 of 39

Inventory Posture and Effectiveness Metrics. Data will not be pulled earlier than the first day of the month.

5.5.1 CMP Cumulative Performance Metrics (Example):

USNS Kanawha Stock MOF Readiness Indicator Previous 24 months

> = 98% <= 89.99%

PM1 MCC 3 and 4 Range Readiness Indicator Previous 24 months

> = 94% <= 84%

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 30 of 39

AS (Hull Type) Repair Part Depth Readiness Indicator Previous 24 months

> = 91% <= 79%

T-AKEs Combined Net Effectiveness Readiness Indicator Previous 6 months

> = 85% <= 70%

N4.41.5224.1-WP

Afloat Supply Continuous Monitoring Program Page 31 of 39

5.5.2 CMP RI Grid (Example):

REQUIREMENTS MANAGEMENT

Hull No Ship Name Date Comments MOF (End- Use Stock)

MOF (End-Use Stock) 12 Month Avg

MOF (End-Use DTO) MOF (End Use-DTO) 12 Month Avg

MOF (End Use and DTO) Combined) 12 Month Avg

MOF (CARGO) MOF (CARGO)

12 Month Avg

Internal MOV Internal MOV 12 Month Avg

T-AO 187 KAISER, HENRY J. 1/29/2021 No 98 98 79.08 79.08 88.54 98 98 5 24 T-AO 188 HUMPHREYS, JOSHUA 12/18/2020 No 88.86 88.86 74.35 74.35 81.61 98 98 14 24 T-AO 189 LENTHALL, JOHN 11/30/2020 No 95 95 98 98 96.50 95 88 23 40 T-AO 193 DIEHL, WALTER S 10/23/2020 No 94.36 94.36 97 97 95.68 90 90 26 30 T-AO 194 ERICSSON, JOHN 9/27/2020 No 90 90 96 96 93.00 95 86 7 10 T-AO 195 GRUMMAN, LEROY 8/28/2020 No 98 98 80 80 89.00 90 90 5 7 T-AO 196 KANAWHA 7/23/2020 No 90 90 80 80 85 98 98 3 70

Totals 93.5 93.5 86.3 86.3 89.9 94.9 92.6 11.9 29.3

INVENTORY MANAGEMENT

Hull No Ship Name Date Comments Def to Allowance (MCC 3 and 4)

Def to Allowance (RepairPart)

Def to Allowance (Consumable)

Def to Allowance (Combined)

Zero Balance w/ Zero on Order (MCC 3 and 4)

Zero Balance w/ Zero on Order (Repair

Part)

Zero Balance w/ Zero on Order (Consumable)

Zero Balance w/ Zero on

Order (Combined)

EWA

EWA

(record count)

EWA (value) RAO

RAO

(Record Count)

RAO (value)

(Current Quarter)

(Previous Quarter)

T-AKE 1 LEWIS AND CLARK 1/29/2021 No 36,316.71 50,000.00 12 86,328.71 28 25 4 57 5 5 67,000.00 0.05 4 40,000.00 met met T-AKE 2 SACAGAWEA 12/18/2020 No 128,011.94 100,000.00 0 228,011.94 94 100 0 194 6.5 10 678,000.00 0.05 6 36,000.00 met met T-AKE 3 SHEPARD, ALAN 11/30/2020 No 37,116.15 38,000.00 0 75,116.15 46 45 0 91 1.2 17 45,000.00 0.06 10 37,116.15 met met T-AKE 4 BYRD, RICHARD E.