Attachment 14F - CM Ships Drill Down and Analysis Report sample (1).pdf
PDF 544 KB Posted
- Solicitation number
- N3220524R4105-RFP
About this file
This document is an Attachment 14F - CM Ships Drill Down and Analysis Report for the Military Sealift Command (MSC). It provides an analysis of inventory depth and range for various MSC ships, highlighting items with terminal/obsolete acquisition advice codes (AACs) and items that need review of their allowance. The report identifies steps to address the reasons for the ships' inability to meet depth and range goals, such as submitting COSAL Feedback Reports and focusing procurement efforts on materials with recorded demand history. It provides specific details on the inventory depth and range, shortage items, and recommended actions for the USNS Kanawha vessel. This report is intended to support the proactive monitoring of depth and range to achieve various benefits, including S&E OPTAR savings, decreased requisition lead-time, increased supply and maintenance effectiveness, and increased readiness.
View the file
Other files
Show 40 more
Latest 50 of 75 listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
ATTACHMENT 14F
USNS KANAWHA Analysis and Drilldown Report – SEP 2021
1. Inventory Depth and Range Provided below is the list of MSC ships with a rating of below 90% in either depth or range and a Red/Yellow indicated on the Readiness Indicator/Dashboard. Addressing some of the reasons and criteria as to why the ship is unable to meet the required goals will translate to a variety of benefits to the individual Command and ultimately to MSC. Proactive Depth/Range monitoring is critical to both supply and maintenance operations.
The benefits of properly monitoring Depth and Range include S&E OPTAR savings, decreased requisition lead-time, increased supply and maintenance effectiveness, and increased readiness.
In the analysis, there are three main processes/procedures impacting the majority of the requisitions meeting the analysis criteria:
1. Obsolete/Terminal item Acquisition Advice Codes (AAC)
2. Allowance maintenance – Fleet COSAL Feedback Reports
3. Focus procurement efforts on Material with recorded demand history
a) Inventory Depth and Range by Ship/Class (below 90%)
b) Shortage Report Items with Terminal/Obsolete AACs
Requisitions generated for below NIINs will have the tendency to be rejected with obsolete item status leading to an endless loop of Shortage-Requisition-Rejection due to the AAC. Address these items by submitting COSAL Feedback Report (CFBR) in Ship CLIP to get these items removed from the allowance battery or replaced with suitable substitutes addressing any questions with Logistics Type Desk. This will in turn improve the Depth and Range and ultimately increase effectiveness throughout MSC as well as ensuring funds are appropriately utilized on NIINs that will not get rejected due to obsolescence.
Ship Class Program Inv. Range Inv. Depth
APACHE T-ATF166 PM4 76.86% 66.06%
CARSON CITY T-EPF1 PM8 84.3% 85.79%
CHOCTAW COUNTY T-EPF1 PM8 81.27% 81.79%
DIEHL, WALTER S T-AO187 PM1 89.16% 88.31%
EARHART, AMELIA T-AKE1 PM6 88.3% 89.92%
EVERS, MEDGAR T-AKE1 PM6 86.29% 88.1%
GRUMMAN, LEROY T-AO187 PM1 87.98% 86.96%
HERSHEL WILLIAMS T-ESB1 PM3 89.44% 87.42%
KAISER, HENRY J. T-AO187 PM1 87.77% 86.44%
LEWIS AND CLARK T-AKE1 PM6 86.8% 88.65%
LEWIS B. PULLER T-ESB1 PM3 87.98% 84.69%
MERCY MTF T-AH19 PM4 15.0% 17.55%
MIGUEL KEITH T-ESB1 PM3 77.65% 76.46%
NEWPORT T-EPF1 PM8 80.64% 84.65%
SACAGAWEA T-AKE1 PM6 86.64% 88.52%
SIOUX T-ATF166 PM4 85.53% 69.95%
TIPPECANOE T-AO187 PM1 88.8% 88.89%
YUMA T-EPF1 PM8 83.17% 83.22%
BRASHEAR, CARL T-AKE1 PM6 86.86% 91.14%
BYRD, RICHARD E. T-AKE1 PM6 89.94% 91.83%
CHAMBERS, WASHINGTON T-AKE1 PM6 89.61% 90.11%
DREW, CHARLES T-AKE1 PM6 88.27% 90.0%
KANAWHA T-AO187 PM1 89.84% 92.57%
LARAMIE T-AO187 PM1 89.69% 93.4%
LENTHALL, JOHN T-AO187 PM1 89.01% 92.29%
RAPPAHANNOCK T-AO187 PM1 87.08% 91.37%
SCHIRRA, WALLY T-AKE1 PM6 89.09% 90.54%
SHEPARD, ALAN T-AKE1 PM6 88.16% 90.04%
COMFORT MTF T-AH19 PM4 92.48% 89.26%
GRASP T-ARS50 PM4 92.12% 85.36%
MERCY T-AH19 PM4 95.45% 89.64%
PUERTO RICO T-EPF1 PM8 76.71% 80.75%
ZEUS T-ARC7 PM2 73.76% 84.19%
USNS KANAWHA
T: Condemned. No longer authorized to be purchased, issued, or used.
V: Terminal Item. Item in stock but no future purchases authorized.
X: Semi-active - No Replacement Non-stocked Item. Stocks on-hand.
Y: Terminal Item. Future purchases not authorized.
c) Items Needing Review of Allowance Possible COSAL Feedback Report
Listed requisitions are a sample of various records rejected via One Touch Support (OTS) due to the item being obsolete, verification of AAC prior to order would have prevented the unnecessary wasted effort and delay in time. When rejection statuses of this type are received it is recommended to:
1. Ship verify allowance with Logistics Type Desk.
2. Submit COSAL Feedback report in Ship CLIP as needed to prevent recurring rejections.
FSC NIIN DESCRIPTION UI UNIT PRICE
ON
HAN
D
ON
ORDE
R
TOTAL
OHOO SRI
5 YEAR
DEMAND-
TOTAL
RECORD
COUNT
5 YEAR
DEMAND-
TOTAL
QUANTITY
SHORTAG
E EXT PRICE
AA
C
5960 001935085 ELECTRON TUBE EA 13.7 0 0 0 1 0 -1 13.7 V
4240 002627091 LENS,GOGGLES,INDUSTRIAL PR 1.98 0 0 0 4 0 -4 7.92 V
5950 003851396 TRANSFORMER ASSEMBLY EA 2772 0 0 0 1 1 1 -1 2772 V
4820 005858567 VALVE,GLOBE EA 58.32 0 0 0 1 2 4 -1 58.32 V
4730 008288799 NIPPLE,TUBE EA 2.81 0 0 0 2 0 -2 5.62 Y
5331 009569216 ORING EA 0.38 0 0 0 2 2 6 -2 0.76 V
4320 010885073 VANE,PUMP,ROTARY EA 1479 0 0 0 1 1 1 -1 1479 Y
5820 011144428 TRANSLATOR EA 3059 0 0 0 1 2 2 -1 3059 V
4820 011394410 VALVE,GLOBE EA 2295.22 0 0 0 1 3 3 -1 2295.22 Y
6130 011689768 POWER SUPPLY EA 7702.78 0 0 0 1 1 1 -1 7702.78 Y
6695 012530732 INDICATOR,SALINITY EA 1764 0 0 0 1 1 1 -1 1764 Y
4820 012694699 VALVE,BALL EA 1126.05 0 0 0 1 1 1 -1 1126.05 Y
5915 012743954 NETWORK EA 162.06 0 0 0 1 0 -1 162.06 V
5998 012754904 PRINTED WIRING BOARD EA 1349.36 0 0 0 1 0 -1 1349.36 V
6350 013006268 MODULE,ALARM,SMOKE EA 1308.92 0 0 0 1 1 1 -1 1308.92 Y
5940 013043164 TERMINAL BOARD EA 1931.4 0 0 0 1 0 -1 1931.4 Y
5920 013091544 FUSE,ENCLOSED LINK EA 621.18 2 0 2 6 1 1 -4 2484.72 Y
5998 013113761 CIRCUIT CARD ASSEMBLY EA 961.72 1 0 1 2 0 -1 961.72 Y
2040 013122776 HOOK,AUTOMATIC RELEASE EA 2586.45 0 0 0 1 0 -1 2586.45 Y
6210 013256129 LENS,LIGHT EA 25.53 1 0 1 2 1 1 -1 25.53 V
6210 013453226 LIGHT,INDICATOR EA 19.04 0 0 0 2 0 -2 38.08 V
5925 013565680 CIRCUIT BREAKER EA 10292.21 0 0 0 1 0 -1 10292.21 Y
5998 013569340 CIRCUIT CARD ASSEMBLY EA 11921 0 0 0 2 0 -2 23842 V
5915 013803107 FILTER,RADIO FREQUENCY INTERFERENCE EA 21.78 0 0 0 1 0 -1 21.78 V
6135 014376409 BATTERY ASSEMBLY EA 62.16 0 0 0 1 0 -1 62.16 Y
6140 014376412 BATTERY,STORAGE EA 93.2 0 0 0 1 0 -1 93.2 Y
5825 014408410 BEACON,RADIO EA 644.98 0 0 0 1 0 -1 644.98 V
USNS KANAWHA
Document Number NIIN FSC SMIC Quantity UI Cog UP Last StatusLast Status Date
N215811229S645 013002242 5930 1 EA 9B 356.34 CJ 8/17/2021
N215811269S179 005824737 6505 2 BT 9B 6.41 CJ 9/27/2021
N215811212S488 015226419 6630 1 EA 9B 541.16 CJ 8/2/2021
N215811224S569 015450769 5130 3 SE 9Q 293.54 CJ 8/13/2021
N215811185S367 015226419 6630 1 EA 9B 541.16 CJ 7/7/2021
N215811239S692 011398287 6515 1 EA 9B 341.32 CJ 8/28/2021
N215811019S279 251503054 5310 2 EA 9B 4.68 CJ 1/19/2021
N215811003S050 014907250 7045 2 EA 9Q 4.68 CG 1/3/2021
N215811001S049 011169888 4240 20 EA 1H 290 CG 1/6/2021
N215811040S473 015450769 5130 4 SE 9Q 293.54 CJ 2/9/2021
N215811014S194 014322753 5930 1 EA 9B 66.83 CU 1/14/2021
N215811013S156 007851162 4940 3 EA 9H 79.35 CJ 1/13/2021
N215811014S191 002245191 7195 1 EA 9Q 157.43 CJ 1/14/2021
N215811040S476 013857235 5110 8 EA 9Q 25.69 CJ 2/9/2021
N215810281S079 015963729 4130 4 EA 9B 172.22 CY 10/20/2020
N215810281S117 005845272 5310 124 HD 9B 3.09 CJ 10/8/2020
N215810347S644 014525038 8415 1 EA 9B 117.54 CJ 3/31/2021
N215810283S416 007296392 5120 1 SE 9Q 1.47 CJ 10/10/2020
N215810295S659 015359649 8430 4 PR 9B 140.24 CJ 10/21/2020
N215810365S045 011169889 4240 20 EA 1H 356 CG 1/6/2021
N215810291S617 013006268 6350 1 EA 9B 1255.82 CJ 7/21/2021
N215810344S628 014525038 8415 3 EA 9B 117.54 CJ 3/31/2021
N215810347S639 016417680 6630 1 EA 9B 68.26 CJ 12/15/2020
N215810364S039 011169889 4240 20 EA 1H 356 CG 1/6/2021
N215810281S098 014863141 6850 10 EA 9B 7.1 CJ 10/8/2020
N215810362S029 011169888 4240 20 EA 1H 290 CG 1/6/2021
N215810340S540 012053264 5930 1 EA 9B 121.99 CY 12/5/2020
N215810284S448 002508038 4930 3 EA 9B 11.63 CY 10/20/2020
N215810311S156 012283179 8430 3 PR 9B 49.38 CJ 11/6/2020
N215811177S278 015450769 5130 4 SE 9Q 293.54 CJ 6/27/2021
N215811177S279 014486690 5130 5 EA 9Q 92.4 CJ 6/27/2021
N215811114S316 002763187 5910 10 EA 9B 16.97 CJ 5/5/2021
N215811126S431 012283179 8430 5 PR 9B 49.38 CJ 5/6/2021
N215811154S004 002022598 5330 5 EA 9Z 3.55 CG 6/12/2021
N215811170S152 014553402 6515 4 EA 9B 46.36 CJ 6/22/2021
N215811132S480 014659514 9110 50 BG 9B 14.38 CJ 5/24/2021
N215811154S676 002022632 5330 5 EA 9B 5.81 CY 6/14/2021
N215811093S015 010885073 4320 1 EA 9B 1419 CJ 4/5/2021
N215811111S291 011169888 4240 100 EA 1H 290 CJ 4/21/2021
N215811154S683 002022626 5330 5 EA 9B 6.31 CJ 6/23/2021
d) Items Listed in Shortage Report with Recorded Demand
The following listed shortages are items that reflect demand within the 5-year history with AACs that will not result in rejections. Focusing on procurement of the items that reflect demand will also have the added benefit of increasing Net Effectiveness as well as increasing Depth and Range for the ship.
USNS KANAWHA
FSC NIIN DESCRIPTION UI
UNIT
PRICE
ON
HAND
ON
ORDER
TOTAL
OHOO SRI
5 YEAR
DEMAND-
TOTAL
RECORD
COUNT
5 YEAR
DEMAND-
TOTAL
QUANTITY SHORTAGE
EXT
PRICE AAC
5331 002526045 ORING EA 2.96 0 0 0 6 10 1163 -6 17.76 D
7920 002051711 RAG,WIPING BE 28.18 0 0 0 5 30 537 -5 140.9 H
6135 009857845 BATTERY,NONRECHARGEABLE PG 5.73 20 0 20 29 39 245 -9 51.57 H
6240 001433070 LAMP,INCANDESCENT EA 0.86 0 0 0 10 4 168 -10 8.6 Z
5330 011825226 GASKET EA 6.46 0 0 0 47 2 160 -47 303.62 Z
5935 010053579 CONNECTOR,PLUG,ELECTRICAL EA 6.08 4 0 4 9 13 151 -5 30.4 Z
4730 007939809 ADAPTER,STRAIGHT,PIPE TO HOSE EA 380.59 0 0 0 16 9 111 -16 6089.44 D
5945 008841320 CONTACT SET,RELAY EA 124.5 0 0 0 10 11 98 -10 1245 Z
6260 010744229 LIGHT,CHEMILUMINESCENT BX 20.22 0 0 0 17 6 71 -17 343.74 Z
4330 013066179 FILTER ELEMENT,FLUID EA 25.31 39 0 39 48 9 66 -9 227.79 D
5331 001651956 ORING EA 1.02 0 0 0 11 5 63 -11 11.22 Z
5330 012807558 GASKET EA 151.23 23 0 23 24 7 61 -1 151.23 Z
4330 013533924 FILTER,FLUID EA 30.5 0 0 0 2 3 60 -2 61 Z
5331 009843762 ORING EA 0.36 2 0 2 5 3 55 -3 1.08 D
4730 002038347 COUPLING,PIPE EA 3.55 0 0 0 1 2 50 -1 3.55 D
4030 003693963 SHACKLE PG 22.44 0 0 0 2 4 49 -2 44.88 Z
6210 008781131 LIGHT FI,TURE EA 557.42 0 0 0 10 7 47 -10 5574.2 Z
5330 002708468 PAPER,GASKET EA 4.09 0 0 0 2 4 41 -2 8.18 Z
5330 012807565 GASKET EA 34.49 12 0 12 20 3 38 -8 275.92 Z
4030 003693988 SHACKLE PG 58.23 0 0 0 5 6 36 -5 291.15 Z
4320 014542070 IMPELLER,PUMP,CENTRIFUGAL EA 701.64 0 0 0 1 6 35 -1 701.64 D
4030 002803453 SHACKLE PG 31.63 0 0 0 4 3 33 -4 126.52 Z
5360 013153422 SPRING,HELICAL,COMPRESSION EA 233.5 1 0 1 2 3 32 -1 233.5 Z
5360 013153423 SPRING,HELICAL,COMPRESSION EA 107.24 1 0 1 2 4 32 -1 107.24 Z
5331 012792242 ORING EA 3.58 20 0 20 24 3 32 -4 14.32 Z
5331 012791168 ORING EA 38.68 17 0 17 20 3 30 -3 116.04 Z
4510 011125792 BELLOWS,VALVE DISCH EA 28.09 0 0 0 3 2 30 -3 84.27 H
5330 012790803 SEAL RING,METAL EA 12.96 0 6 6 9 9 29 -3 38.88 Z
4730 002870420 UNION,PIPE EA 22.92 0 0 0 2 4 28 -2 45.84 D
0000 T21871552 GASKET EA 36.75 0 0 0 4 7 28 -4 147
5977 000190679 BRUSH,ELECTRICAL CONTACT EA 117.58 2 0 2 4 6 27 -2 235.16 Z
5330 004201133 GASKET EA 9.02 2 0 2 10 10 25 -8 72.16 Z
4730 001877648 COUPLING,PIPE EA 2.05 0 0 0 1 1 25 -1 2.05 Z
| 1. Inventory Depth and Range |
| a) Inventory Depth and Range by Ship/Class (below 90%) |
| b) Shortage Report Items with Terminal/Obsolete AACs |
| USNS KANAWHA |
| c) Items Needing Review of Allowance Possible COSAL Feedback Report |
| USNS KANAWHA |
| d) Items Listed in Shortage Report with Recorded Demand |
| USNS KANAWHA |
File details come from the government source that posted it. Updated .