Attachment_1_-_Revised_Attachment_J.24 TE_5_1_DDBC_Historical_Workload_DDBC_Tracked_Changes.pdf

SP3300-16-R-5003

Attachment J.24

Technical Exhibit 5.1 Historical Workload (March 2016) for DDBC Conformed through A004

TE 5.1

Historical Workload

WHOLESALE WORKLOAD

C-5.1.5 CUSTOMER SERVICE SUPPORT

Source Data Collection FY14 FY15 FY16 YTD Item Manager/Service Support (Occurrences) Technical Estimate 480 480 240 Call-in Special Inspections (Occurrences) Technical Estimate 25 25 12 Repacking and Stowing Assets (Number of NSNs) Technical Estimate 110 130 190

C-5.1.6 NAVSUP Weapons Systems Support (NAVSUP WSS) In-Transit Accountability (NITA) Source Data Collection FY14 FY15 FY16 YTD Number of SIT SDRs Received Technical Estimate 0 0 0 Number of SIT SDRs Researched & Completed Technical Estimate 0 0 0 Number of SDRs Researched & Completed Technical Estimate 1,205 638 436

C-5.2 and C-5.3.8 TOTAL RECEIPT AND ISSUE WORKLOAD

FY14 SECONDARY MONTHLY WORKLOAD (Lines) Measurement is Lines

Month Receipts (91140 ) Issue Total (92440) TOTAL Receipts and Issues

OCT 986 3,644 4,630

NOV 1,025 3,764 4,789

DEC 1,068 3,645 4,713

JAN 969 3,357 4,326

FEB 1,211 4,176 5,387

MAR 1,071 5,416 6,487

APR 1,048 4,634 5,682

MAY 882 4,613 5,495

JUN 981 4,062 5,043

C-5.2 and C-5.3.8 TOTAL RECEIPT AND ISSUE WORKLOAD FY14 SECONDARY MONTHLY WORKLOAD (Lines)

Measurement is Lines

JUL 998 4,826 5,824

AUG 869 4,617 5,486

SEP 877 4,332 5,209

TOTAL 11,985 51,086 63,071

FY15 SECONDARY MONTHLY WORKLOAD (Lines)

Measurement is Lines

Month Receipts (91140) Issue Total (92440) TOTAL Receipts and Issues

OCT 985 3,880 4,865

NOV 808 4,003 4,811

DEC 879 4,315 5,194

JAN 649 4,077 4,726

FEB 703 4,151 4,854

MAR 966 4,572 5,538

APR 949 4,357 5,306

MAY 777 3,724 4,501

JUN 901 4,704 5,605

JUL 1,018 4,191 5,209

AUG 956 4,007 4,963

SEP 1,157 3,464 4,621

TOTAL 10,748 49,445 60,193

FY16 YTD SECONDARY MONTHLY WORKLOAD (Lines)

Month Receipts (91140) Issue Total (92440) TOTAL Receipts and Issues YTD

OCT 1,168 3,852 5,020

FY16 YTD SECONDARY MONTHLY WORKLOAD (Lines) Measurement is Lines

Month Receipts (91140) Issue Total (92440) TOTAL Receipts and Issues YTD

NOV 1,184 3,484 4,668

DEC 1,343 3,889 5,232

JAN 1,176 3,364 4,540

FEB 1,608 4,565 6,173

MAR 2,526 6,355 8,881

APR

MAY

JUN

JUL

AUG

SEP

TOTAL YTD 9,005 25,509 34,514

2012 2013 2014 2015 2016 Lines 84,67 68,30 63,07 60,19 98,98

20,000

40,000

60,000

80,000

100,000

120,000

LI

N

ES

DDBC Workload

Pr oj ec te d

C-5.2 RECEIVING

Measurement is Lines

NLC Weight Bands By Lines NLC MIS DE FY14 FY15 FY16 YTD Weight Band 1 13001+61301 7,386 6,517 5,199 Weight Band 2 13002+61302 2,163 1,834 1,751 Weight Band 3 13003+61303 1,937 1,800 1,788 Weight Band 4 13004+61304 499 597 267 RDOs with Special Project 12960 0 0 0 Total Receipts 91452 11,985 10,748 9,005

Value Added Lines (Depiction of extra effort to process these types of Receipts within the above stated weight bands) MIS Data Element FY14 FY15 FY16 YTD Return Lines 13010+61310 2,227 2,109 988 Hazardous Lines 13011+61311 10 37 18 Hard to Handle 13012+61312 538 453 300

FY15 Percentage of Quantity per Line by Total Receipts in NLC

Quantity (Number of Individual receipts processed per line.)

Total Lines Total Lines by Weight Band

% Weight Band 1

Weight Band 2

Weight Band 3

Weight Band 4

1 6,430 4,750 606 455 619 58% 2 to 9 1,782 1,316 168 126 172 16% 10 to 19 637 471 60 45 61 6% 20 to 29 411 304 39 29 40 4% 30 to 49 355 262 33 25 34 3% 50 to 99 431 318 41 30 42 4% 100+ 1,071 791 101 76 103 10% Totals 11,117 8,212 1,048 786 1,071 100%

C-5.2.2 OFFLOAD AND TALLY

Inbound Trucks Source Data Collection FY14 FY15 FY16 YTD Trucks Manual Counts 1,741 2,432 984 Pieces Manual Counts 11,608 11,743 6,154 Pallets Manual Counts 1,600 2,050 550 Rail Cars Technical Estimate 63 70 34

C-5.2.4.1 SUPPLY DISCREPANCY REPORTS (SDR) (Type 8 or 9)

Measurement is Each

Type Discrepancy Source Data Collection FY14 FY15 FY16 YTD

Quantity Short (S_) QMF 107 75 84 Quantity Over (O_) QMF 7 15 37 Condition of Material (C_) QMF 133 188 179 Misdirected Material (M_) QMF 1 1 2 Missing Documentation (D_) QMF 192 154 197 Packaging Discrepancy (P_) QMF 80 77 73 Wrong Item (W_) QMF 123 79 36 Product Quality Deficiencies/Safety

(Q_) QMF 0 1 13

HazMat (H_) QMF 1 4 0 Technical (T_) 18 29 11 Other Discrepancies (Z_) QMF 961 739 312 Total 1,623 1,362 944

C-5.2.4.2 NON-PROCUREMENT RECEIPTS AND 5.2.4.3 NEW PROCUREMENT (NP)

Types of receipts processed within the above stated weight bands MIS Data Element FY14 FY15 FY16 YTD

New Procurement 12101 3,107 2,707 1,473 Customer Returns (less retrograde) 12102 2,370 2,298 1,102 Redistributions 12103 6,507 5,743 6,428 Receipts from Maintenance 10402 103 113 69

Serviceable Returns (includes wholesale and MTIS returns) 10802 1,266 1,372 592 Unserviceable Returns 10302 5,920 4,695 2,213 Unit Cost Receipt Reversals (Discrepant Receipts) 12950 107 84 43

Hazardous Receipts 11703+60370+60297 10 37 18

C-5.2.5 ADDITIONAL REQUIREMENTS

FY14 FY15 FY16 YTD

*Materiel Type by (Lines) Source Data Collection

Classified/Confidential/Secret Wholesale/Retail Receipts 16202 0 0 0 Controlled/Pilferable/Sensitive Wholesale/Retail Receipts 16302 920 563 390 Classified/Confidential/Secret Wholesale and MTIS Returns 16502 2 1 1 Controlled/Pilferable/Sensitive Wholesale and MTIS Returns 16602 140 268 82 Classified/Confidential/Secret Redistributions 16802 0 0 0 Controlled/Pilferable/Sensitive Redistributions 16902 676 675 593 Compressed Gas Cylinder SAS 1 5 3 Radioactive SAS 16 26 18 *Receipts may fall into multiple types above. (Ex: One receipt may be a combination of classified, ESD, and radioactive)

C-5.3 WAREHOUSING (As of the last day of Mar’16 YTD)

Source Data Collection FY14 FY15 FY16 YTD

NSNs in Storage NSNs In Store Report 21,507 20,438 20,199 NOTE: Racks can not be higher than 19 feet. Racks currently at 15 feet high.

C-5.3.3 COSIS

Recording, Reporting, and Performing COSIS Actions Exceeding Minor Repair

DD 1225s Completed QMF 481 164 50

C-5.3.3 COSIS

COSIS SPECIAL INSPECTIONS

Cyclic Inspections (Shelf-Life) QMF 405 71 60 Other QMF 1 0 0 Routine COSIS (Visual Inspections)

(V06, V12, V24, V30, & V60) QMF 11,089 9,093 5,270

Special Inspections (SIR) QMF 814 797 502 Special Quality Inspections (QN1, QN2, QN3, CSI, CS2, CS3, SOF, SO2, SO3, RSI, RS2, RS3) QMF 75 64 45

C-5.3.7 REWAREHOUSING ACTIONS

Rewarehousing/Routines MIS Data Element FY14 FY15 FY16 YTD

Total Rewarehousing (Locations Rewarehoused) 40200 4,891 3,077 2,186

C-5.3.8 Issue of Material

On-Base Issues NLC DE FY14 FY15 FY16 YTD Weight Band 1 24002+62402 6,084 7,760 4,387 Weight Band 2 24003+62403 377 633 357 Weight Band 3 24004+62404 351 521 242

Weight Band 4 24005+62405 24 20 12

TOTAL 24001+62401 6,836 8,934 4,998

Off-Base Issues NLC DE FY14 FY15 FY16 YTD Weight Band 1 24007+62407 20,949 21,489 12,336 Weight Band 2 24008+62408 4,143 3,535 1,669 Weight Band 3 24009+62409 3,165 2,945 1,213 Weight Band 4 24010+62410 681 536 215

TOTAL 24006+62406 28,938 28,505 15,433

Transshipments-Off-Base NLC DE FY14 FY15 FY16 YTD Weight Band 1 24083+62610 3,240 3,216 1,721 Weight Band 2 24084+62611 804 1,217 546 Weight Band 3 24085+62612 1,442 1,676 562 Weight Band 4 24086+62613 2,916 1,921 737

TOTAL 24082+62602 8,402 8,030 3,566

Transshipments-On-Base NLC DE FY14 FY15 FY16 YTD NLC Trans On-Base TOTAL 24081+ 62601 2,177 1,868 532

NLC DROs MIS Element FY14 FY15 FY16 YTD Weight Band 1 24102 3,663 1,522 692 Weight Band 2 24103 461 231 116 Weight Band 3 24104 466 224 121 Weight Band 4 24105 143 131 51

TOTAL 24101 4,733 2,108 980

NLC DE FY14 FY15 FY16 YTD

RDOs with Special Project Codes 22160+22161 0 0 0

TOTAL NLC ISSUES

92752 51,086 49,445 25,509

C-5.3.8 Issue of Material - Value Added (VA) Lines (Depiction of extra effort to process these types of Issues within the above stated weight bands) Measurement is Lines

MIS Data Element FY14 FY15 FY16 YTD Hazardous 24032+62432 175 258 63 Controlled Items 24033+62433 5,534 4,311 2,148 Hard to Handle Items 24034+62434 2,077 2,175 1,319 Out of Cycle (Bearer Pick Up) 24061 0 0 0 Out of Cycle 24037+62437 166 75 29 Local Delivery 24035+62435 6,836 8,933 4,998 RDO Issues 20762 1,488 1,242 895 Retail MROs on Base 21562 106 3 5 Issues to Maintenance-(On-Base) 20462 25 30 131 Issues to Maintenance-(Off-Base) 20362 1,018 862 377

C-5.3.8 Issue of Material – FY15 Percentage Of Quantity Per Line By NLC Weight Bands

Quantity (Number of Individual Issues processed per line.)

Total Lines Total Lines by Weight Band

Weight Band 1

Weight Band 2

Weight Band 3

Weight Band 4 %

1 21,262 15,997 2,669 1,433 1,163 43% 2 to 9 16,133 12,138 2,025 1,088 882 32% 10 to 19 4,209 3,167 528 284 230 8% 20 to 29 2,031 1,528 255 137 111 4% 30 to 49 1,633 1,229 205 110 89 3% 50 to 99 1,718 1,293 216 116 94 3% 100+ 2,718 2,045 341 183 149 5% Totals 49,704 37,395 6,240 3,351 2,718 100%

C-5.3.8 ISSUE TRANSACTIONS BY HOUR AND TYPE

(Historical Data for a 30 Day Period – For Illustration Purposes)

HOUR/TYPE 999 IPG1 IPG2 IPG3 RDO STO DRO Total by Hour % by Hour 0000-0100 0 0 0 0 0 0 0 0 0.00% 0100-0200 0 0 0 0 0 0 0 0 0.00% 0200-0300 0 0 0 0 0 0 0 0 0.00% 0300-0400 0 0 0 0 0 0 0 0 0.00% 0400-0500 0 0 0 0 0 0 0 0 0.00% 0500-0600 0 1,620 518 201 17 0 24 2,339 37.28% 0600-0700 0 97 9 13 4 0 0 119 1.90% 0700-0800 0 37 38 6 0 0 0 81 1.29% 0800-0900 0 217 84 66 12 0 1 367 5.85% 0900-1000 0 61 27 7 0 0 0 95 1.51%

C-5.3.8 ISSUE TRANSACTIONS BY HOUR AND TYPE

(Historical Data for a 30 Day Period – For Illustration Purposes)

1000-1100 0 275 46 26 7 0 0 347 5.53% 1100-1200 0 10 1 0 0 0 0 11 0.18% 1200-1300 0 124 54 25 0 0 3 203 3.24% 1300-1400 0 167 78 43 3 0 2 288 4.59% 1400-1500 0 81 29 8 2 0 1 118 1.88% 1500-1600 0 45 22 2,233 292 0 90 2,300 36.66% 1600-1700 0 5 0 1 0 0 0 6 0.10% 1700-1800 0 0 0 0 0 0 0 0 0.00% 1800-1900 0 0 0 0 0 0 0 0 0.00% 1900-2000 0 0 0 0 0 0 0 0 0.00% 2000-2100 0 0 0 0 0 0 0 0 0.00% 2100-2200 0 0 0 0 0 0 0 0 0.00% 2200-2300 0 0 0 0 0 0 0 0 0.00% 2300-2400 0 0 0 0 0 0 0 0 0.00% Total by Day 0 2,739 906 2,629 337 0 121 6,274

% by Type 0% 44% 14% 42% 5% 0% 2% 100.00%

C-5.3.8 ISSUE TRANSACTIONS BY DAY OF WEEK AND TYPE

(Historical Data for a 30 Day Period – For Illustration Purposes)

DAY/TYPE 999 IPG1 IPG2 IPG3 RDO STO DRO Total by Day % by Day

Monday 0 151 150 315 66 0 27 616 10% Tuesday 0 531 178 468 83 0 29 1,177 19% Wednesday 0 568 167 510 40 0 22 1,245 20% Thursday 0 857 195 580 64 0 16 1,632 26% Friday 0 450 143 396 81 0 27 989 16% Saturday 0 182 73 360 3 0 0 615 10% Sunday 0 0 0 0 0 0 0 0 0%

Total by Type 0 2,739 906 2,629 337 0 121 6,274 % by Type 0% 44% 14% 42% 5% 0% 2% 100%

C-5.3.8 FY15 ISSUE TRANSACTIONS BY HOUR AND DAY OF THE WEEK

HOUR/DAY Mon Tue Wed Thu Fri Sat Sun Total by Hour % by Hour 0000-0100 0 0 0 0 0 0 0 0 0% 0100-0200 0 0 0 0 0 0 0 0 0% 0200-0300 0 0 0 0 0 0 0 0 0% 0300-0400 0 0 0 0 0 0 0 0 0% 0400-0500 0 0 0 0 0 0 0 0 0% 0500-0600 175 413 503 735 381 132 0 2,339 37% 0600-0700 6 32 23 25 26 7 0 119 2% 0700-0800 7 7 4 10 49 4 0 81 1% 0800-0900 32 72 82 95 46 40 0 367 6% 0900-1000 3 19 26 10 27 10 0 95 2% 1000-1100 16 55 60 149 33 34 0 347 6% 1100-1200 0 1 5 3 2 0 0 11 0% 1200-1300 13 49 67 49 20 5 0 203 3% 1300-1400 21 79 74 69 35 10 0 288 5% 1400-1500 16 30 9 25 24 14 0 118 2%

C-5.3.8 FY15 ISSUE TRANSACTIONS BY HOUR AND DAY OF THE WEEK

(Historical Data for a 30 Day Period – For Illustration Purposes)

1500-1600 326 419 391 462 343 359 0 2,300 37% 1600-1700 1 1 1 0 3 0 0 6 0% 1700-1800 0 0 0 0 0 0 0 0 0% 1800-1900 0 0 0 0 0 0 0 0 0% 1900-2000 0 0 0 0 0 0 0 0 0% 2000-2100 0 0 0 0 0 0 0 0 0% 2100-2200 0 0 0 0 0 0 0 0 0% 2200-2300 0 0 0 0 0 0 0 0 0% 2300-2400 0 0 0 0 0 0 0 0 0%

Total by Day 616 1,177 1,245 1,632 989 615 0 6,274 % by Day 10% 19% 20% 26% 16% 10% 0% 100%

C-5.3.11 ISSUES TO DLA Disposition Services

DROs DEMIL F QMF 22 12 17 DROs DEMIL G QMF 0 0 0 DROs DEMIL P QMF 0 0 1

C-5.3.12 SHIPMENT PREPARATION

Number of Packing Actions J3 OW 7,935 5,711 2,639

C.5.4 PHYSICAL INVENTORY COUNTS

Inventories

Measurement is Number of Inventories Completed

MIS Data Element FY14 FY15 FY16 YTD TPIC “C” Inventories 50141 48 251 339 TPIC “E” Inventories 50143 6 1 0 TPIC “H” Inventories 50145 0 0 0 TPIC “I” Inventories 50146 0 0 0 TPIC “J” Inventories 50147 0 0 0 TPIC “K” Inventories 50148 71 4 2 TPIC “M” Inventories 50150 9 14 1 TPIC “A” Inventories 50154 0 0 0 TPIC “R” Inventories 50155 7 8 5 TPIC “S” Inventories 50156 0 0 0 TPIC “T” Inventories 50157 189 121 85 TPIC “U” Inventories 50158 209 200 136 TPIC “V” Inventories 50159 109 107 90 TPIC “Z” Book to Book 52003 2 6 3 Other or Blank TPIC 50153 138 112 77

GOVERNMENT PERFORMED INVENTORIES

TPIC “D” Inventories 50142 45,481 29,742 5,110 TPIC “G” Inventories 50144 232 216 22 TPIC “L” Inventories 50149 2114 181 0 TPIC “N” Inventories 50151 798 789 404 TPIC “P” Inventories 50152 281 279 328

C-5.4 Physical Inventory Control - STATISTICAL RANDOM PERFORMANCE SAMPLE (TPIC N)

MEASUREMENT IS LINES

STRATA 2nd Qtr FY14 4th Qtr FY14 2nd Qtr FY15 4th Qtr FY15 A – Unit Price>$1,000 99.41% 100.00% 100.00% 100.00% B – Unit of Issue no equal to Each OR On Hand Bal>50 – AND – Ext $ Val<$50K OR Activity>50 100.00% 100.00% 98.00% 99.00%

C – On Hand Bal<50 – AND – Date of Last Inv >24 Mo 100.00% 100.00% 98.00% 98.11%

D – Other 100.00% 100.00% 100.00% 100.00%

5.4.1.2 RESEACH OF POTENTIAL OR ACTUAL PHYSCIAL INVENTORY ADJUSTMENTS

FY14 FY15 FY16 YTD

Causative Research 95700 73 37 4 FLIPLs Completed Manual Counts 0 0 0 IERLs (3rd Count Inventories) QMF 282 170 101

C-5.4.2 DENIALS RESEARCH

MIS Data Element FY14 FY15 FY16 YTD

Denial Research 26500+26550+ 27500+26290 351 170 103

C-5.4.3 ITEM DATA CHANGES AND C-5.4.5 ADHOC DISCREPANCY RESEARCH AND RESOLUTION

Stock Number Changes 3 3 1

Unit of Issue Changes 0 21 135

ADHOC Discrepancy Research and Resolution 424 898 1,983

C-5.4.4 LOCATION SURVEYS

Total Number of Locations J4 Inventory 59,234 58,485 59,133 Location Survey (Complete) J4 Inventory 58,627 58,363 24,461

Location Accuracy J4 Inventory 99.87% 99.93% 99.77%

C-5.4.7 INCOMING SUPPLY DISCREPANCY REPORTS

Number of ISDRs Completed QMF 152 206 118

C-5.5 TRANSPORTATION

MROs Shipped by MIS Data Element FY14 FY15 FY16 YTD Truck Load 22501 528 221 114 Less Than Truck Load 22502 5,927 5,623 2,692 Surface Parcel Post 22503 1 0 0 Surface Small Parcel 22504 11,912 12,076 6,393 Air Parcel Post 22505 0 0 0 Air Small Parcel 22506 10,311 10,269 6,158 Air Freight 22507 223 296 75 Local Delivery/Gov’t Truck 22509 6,836 8,933 4,998 Rail 22508 0 0 0 Other 22510 1 1 0

C-5.5 TRANSPORTATION

Commercial Trucks Shipped Source Data Collection FY13 FY14 FY15

Less than Truckload (Mode B) QMF (Number of Trucks Only) not pieces or lines 6,286 6,286 3,850

Truckload (Mode A) QMF (Number of Trucks Only) not pieces or lines 1,608 1,608 714

Rail (Number of Cars) Technical Estimate 143 105 55

C-5.5.5 ASTRAY FREIGHT (GOCARE) PROGRAM

Call to Local Freight Carriers Technical Estimate 16 30 15 Visits Made to Local Freight Carriers Technical Estimate 0 0 0 Pieces Recovered Technical Estimate 0 0 0

C-5.5.6 SECURITY ASSISTANCE PROGRAM (SAP): FOREIGN MILITARY SALES (FMS) AND GRAND AID

Issues 24036+62436 1,159 1,168 712

C-5.5.7 ADDITIONAL TRAFFIC MANAGEMENT / TRANSPORTATION REQUIREMENTS

Controlled Material/FMS Issues MIS FY14 FY15 FY16 YTD Classified/Confidential/Secret Shipped 32001 103 212 76 Controlled/Pilferable/Sensitive Shipped 32002 10,867 8,405 3,777

MIS FY14 FY15 FY16 YTD

Classified/Confidential/Secret MROShipped 32004 13 5 3 Controlled/Pilferable/Sensitive MRO Shipped 32005 5,908 4,754 2,481 Classified/Confidential/Secret FMS MRO Shipped 32007 0 0 0

Controlled/Pilferable/Sensitive FMS Shipped 32008 177 176 100

MIS FY14 FY15 FY16 YTD

Classified/Confidential/Secret Wholesale RDOs, Shipped 32010 0 0 0 Controlled/Pilferable/Sensitive Wholesale RDOs Shipped 32011 90 79

MIS FY14 FY15 FY16 YTD

Classified/Confidential/Sensitive RCP Shipped 32013 0 0 0

Controlled Pilferable/Sensitive RCP Shipped 32014 0 0 0

MIS FY14 FY15 FY16 YTD

Classified/Confidential/Secret Transshipments 32016 90 207 72 Controlled Pilferable/Sensitive Transshipments 32017 2,612 2,455 703

MIS FY14 FY15 FY16 YTD

Classified/Confidential/Secret DROs 32019 0 0 1 Controlled/Pilferable/Sensitive DROs 32020 2,080 941 461

5.6 PACKAGING

Source Data Collection FY14 FY15 FY16 YTD X Small 16036+23827+42010+40710 153 1,043 8,957 Small 16037+23828+42011+40711 8,462 2,028 2,087 Medium 16038+23829+42012+40712 2,380 428 59 Large 16039+23830+42013+40713 71 79 163 X Large 16040+23831+42014+40714 21 55 154 XX Large 16041+23832+42015+40715 204 86 30

Packages Remarked Only

Source Data Collection FY14 FY15 FY16 YTD Total Remarks 16035+23826+42009+40709 2,201 1,129 13,362

C-5.6.3 CONTAINER FABRICATION

Measurement is Each by Type and Size

Number of Wooden Containers Fabricated Site Small Eaches 873 1,135 561 Medium Eaches 95 62 0

Large Eaches 0 0 0 X-Large Eaches 0 0 0 Total 968 1,197 561 Fiberboard Containers Eaches 0 13 175 Other Type Containers Eaches 395 380 95

C-5.7.1M Load and Offload Support Measurement is Lines and Pieces (lifts)

YERMO Support Requests Crane Lift Logs 1,974 1,870 261 Pieces (Lifts) Crane Lift Logs 8,976 10,007 1,932 Hours

DRMO Crane Lift Support Requests Crane Lift Logs 100 68 18 Pieces (Lifts) Crane Lift Logs 153 134 27 Hours

Fort Irwin, NTC Support Rotations Crane Lift Logs 11 10 6 Pieces (Lifts) Crane Lift Logs 4,346 3,794 2,578

RETAIL WORKLOAD

C-5.7.4M RETAIL SUPPORT

C-5.7.4M TOTAL RECEIPT AND ISSUE WORKLOAD

FY14 RETAIL WORKLOAD (Lines)

Measurement is Lines

Month Receipts (91140 ) Issue Total (92440) TOTAL Receipts and Issues

OCT 3,411 9,696 13,107

NOV 3,967 10,304 14,271

DEC 4,167 10,969 15,136

JAN 3,930 13,371 17,301

FEB 2,281 14,351 16,632

MAR 2,254 13,138 15,392

APR 4,296 15,702 19,998

MAY 2,230 14,793 17,023

JUN 4,082 14,500 18,582

JUL 4,146 17,125 21,271

AUG 5,200 18,332 23,532

SEP 5,758 20,637 26,395

C-5.7.4M TOTAL RECEIPT AND ISSUE WORKLOAD

FY14 RETAIL WORKLOAD (Lines)

TOTAL 45,722 172,918 218,640

FY15 RETAIL WORKLOAD (Lines)

Month Receipts (91140) Issue Total (92440) TOTAL Receipts and Issues

OCT 3,778 22,871 26,649

NOV 2,522 21,086 23,608

DEC 3,315 19,882 23,197

JAN 2,991 16,994 19,985

FEB 3,825 16,344 20,169

MAR 4,966 21,876 26,842

APR 3,520 22,737 26,257

MAY 4,352 18,464 22,816

JUN 4,726 19,448 24,174

JUL 10,121 21,892 32,013

AUG 9,471 22,029 31,500

SEP 5,496 23,816 29,312

TOTAL 59,083 247,439 306,522

FY16 YTD RETAIL WORKLOAD (Lines)

Month Receipts (91140) Issue Total (92440) TOTAL Receipts and Issues YTD

OCT 5,275 22,918 28,193

NOV 4,560 16,262 20,822

DEC 7,703 22,871 30,574

JAN 5,957 20,552 26,509

FY16 YTD RETAIL WORKLOAD (Lines) Measurement is Lines

Month Receipts (91140) Issue Total (92440) TOTAL Receipts and Issues YTD

FEB 6,667 25,386 32,053

MAR 7,558 32,485 40,043

APR

MAY

JUN

JUL

AUG

SEP

TOTAL YTD 37,720 140,474 178,194

2013 2014 2015 2016

YTD

Proj

Lines 214,82 218,64 309,55 178,19 292,32

50,000

100,000

150,000

200,000

250,000

300,000

350,000

LI

N

ES

DDBC Workload

Pr oj ec te d

C-5.7.4.1M RETAIL STOWS

NLC Weight Bands By Lines NLC MIS DE FY14 FY15 FY16 YTD

Weight Band 1 13001+61301 39,572 50,417 22,015 Weight Band 2 13002+61302 3,358 4,917 2,044 Weight Band 3 13003+61303 2,579 3,347 1,517 Weight Band 4 13004+61304 213 402 168 RDOs with Special Project 12960 0 0 0 Total Receipts 91,452 45,722 59,083 25,744

Value Added Lines (Depiction of extra effort to process these types of Receipts within the above stated weight bands) MIS Data Element FY14 FY15 FY16 YTD Return Lines 13010+61310 3,815 4,289 2,922 Hazardous Lines 13011+61311 0 27 38 Hard to Handle 13012+61312 0 0 0

FY15 Percentage of Quantity per Line by Total Receipts in NLC

Quantity (Number of Individual receipts processed per line.)

Total Lines Total Lines by Weight Band

% Weight Band 1

Weight Band 2

Weight Band 3

Weight Band 4

1 10,943 5,688 2,463 1,388 1,404 18% 2 to 9 20,511 10,662 4,614 2,601 2,631 34% 10 to 19 8,881 4,617 1,999 1,127 1,139 15% 20 to 29 4,736 2,462 1,066 601 608 8% 30 to 49 3,900 2,027 878 495 500 6% 50 to 99 3,776 1,963 850 479 484 6% 100+ 7,762 4,035 1,747 985 996 13% Totals 60,509 31,454 13,617 7,676 7,762 100%

C-5.7.4M CUSTOMER RETURNS, NEW PROCUREMENT, REDISTRIBUTION ORDERS (RDO) STOWS

Types of receipts processed within the above stated weight bands MIS Data Element FY14 FY15 FY16 YTD

New Procurement 12101 865 733 297 Customer Returns (less retrograde) 12102 44,857 58,350 25,447 Redistributions 12103 0 0 0 Receipts from Maintenance 10402 0 0 0 Serviceable Returns (includes wholesale and MTIS returns) 10802 0 0 0 Unserviceable Returns 10302 0 9 3 Unit Cost Receipt Reversals (Discrepant Receipts) 12950 179 111 46

Hazardous Receipts 11703+60370+60297 0 27 38

C-5.7.4.1M RETAIL STOWS

FY14 FY15 FY16 YTD

*Materiel Type by (Lines) Source Data Collection

Classified/Confidential/Secret Wholesale/Retail Receipts 16202 0 0 0 Controlled/Pilferable/Sensitive Wholesale/Retail Receipts 16302 4,458 4,168 1,923 Classified/Confidential/Secret Wholesale and MTIS Returns 16502 0 0 0 Controlled/Pilferable/Sensitive Wholesale and MTIS Returns 16602 0 0 0

C-5.7.4.1M RETAIL STOWS ADDITIONAL REQUIREMENTS

FY14 FY15 FY16 YTD

*Materiel Type by (Lines) Source Data Collection

Classified/Confidential/Secret Redistributions 16802 0 0 0 Controlled/Pilferable/Sensitive Redistributions 16902 0 0 0 Compressed Gas Cylinder SAS 16 21 12 Radioactive SAS 0 0 0 *Receipts may fall into multiple types above. (Ex: One receipt may be a combination of classified, ESD, and radioactive)

C-5.7.4.1M RETAIL STORAGE (As of the last day of Mar’16 YTD)

NSNs in Storage NSNs In Store Report 28,482 31,170 29,655

C-5.7.4.1M RETAIL COSIS

COSIS SPECIAL INSPECTIONS

Cyclic Inspections (Shelf-Life) QMF 89 300 273 Other QMF 6 14 Routine COSIS (Visual Inspections)

(V06, V12, V24, V30, & V60) QMF 22 8 114

Special Inspections (SIR) QMF 983 606 376 Special Quality Inspections (QN1, QN2, QN3, CSI, CS2, CS3, SOF, SO2, SO3, RSI, RS2, RS3) QMF 0 0 0

C-5.7.4.1M RETAIL COSIS ACTIONS

Recording, Reporting, and Performing COSIS Actions Exceeding Minor Repair

DD 1225s Completed QMF 594 164 58

C-5.7.4.1M RETAIL REWAREHOUSING ACTIONS

Measurement is Lines

Rewarehousing/Routines MIS Data Element FY14 FY15 FY16 YTD Total Rewarehousing (Locations Rewarehoused) 40200 7,521 6,902 11,821

C.5.7.4.1 RETAIL PHYSICAL INVENTORY COUNTS

Inventories Measurement is Number of Inventories Completed

MIS Data Element FY14 FY15 FY16 YTD TPIC “C” Inventories 50141 6,906 607 479 TPIC “E” Inventories 50143 0 0 0 TPIC “H” Inventories 50145 0 0 0 TPIC “I” Inventories 50146 0 0 0 TPIC “J” Inventories 50147 0 0 0 TPIC “K” Inventories 50148 550 1,128 463 TPIC “M” Inventories 50150 258 105 33 TPIC “A” Inventories 50154 1 0 0 TPIC “R” Inventories 50155 0 0 0 TPIC “S” Inventories 50156 0 0 0 TPIC “T” Inventories 50157 0 0 0 TPIC “U” Inventories 50158 287 406 1,693 TPIC “V” Inventories 50159 23 32 122 TPIC “Z” Book to Book 52003 608 546 239 Other or Blank TPIC 50153 277 24 7

GOVERNMENT PERFORMED INVENTORIES

TPIC “D” Inventories 50142 18,631 29,958 7,675 TPIC “G” Inventories 50144 3 18 0

C.5.7.4.1M RETAIL PHYSICAL INVENTORY COUNTS

Inventories

Measurement is Number of Inventories Completed

TPIC “L” Inventories 50149 103 116 0 TPIC “N” Inventories 50151 912 907 467 TPIC “P” Inventories 50152 111 72 79

5.7.4.1M RETAIL RESEACH OF POTENTIAL OR ACTUAL PHYSCIAL INVENTORY ADJUSTMENTS

FY14 FY15 FY16 YTD

Causative Research 95700 11 14 2 FLIPLs Completed Manual Counts 0 0 0 IERLs (3rd Count Inventories) QMF 296 287 137

5.7.4.1M RETAIL ITEM DATA CHANGES C-5.4.3 ITEM DATA CHANGES AND C-5.4.5 ADHOC

DISCREPANCY RESEARCH AND RESOLUTION

MIS Data Element FY14 FY15 FY16 YTD

Stock Number Changes 16 21 2

Unit of Issue Changes 7 119 462

ADHOC Discrepancy Research and Resolution 822 771 2,135

C-5.7.4.1M RETAIL LOCATION SURVEYS

Total Number of Locations J4 Inventory 40,461 40,981 53,764 Location Survey (Complete) J4 Inventory 40,723 41,990 22,939

Location Accuracy J4 Inventory 98.55% 96.79% 97,56%

RETAIL STATISTICAL RANDOM PERFORMANCE SAMPLE (TPIC N)

MEASUREMENT IS LINES

STRATA

2nd Qtr.

FY14

4th Qtr.

FY14

2nd Qtr.

FY15

4th Qtr.

FY15

A – Unit Price>$1,000 98.14% 99.35% 100.00% 100.00% B – Unit of Issue no equal to Each OR On Hand Bal>50 – AND – Ext $ Val<$50K OR Activity>50 95.34% 95.41% 98.26% 99.13% C – On Hand Bal<50 – AND – Date of Last Inv >24 Mo 95.00% 99.12% 97.27% 99.00%

D – Other 97.14% 95.19% 98.00% 97.00%

C 5.7.4.1M RETAIL ISSUE WORKLOAD

On-Base Issues NLC DE FY14 FY15 FY16 YTD Weight Band 1 24002+62402 161,278 231,946 118,758 Weight Band 2 24003+62403 7,506 9,870 4,038 Weight Band 3 24004+62404 3,817 5,026 2,258 Weight Band 4 24005+62405 204 215 153

TOTAL 24001+62401 172,805 247,057 125,207

Off-Base Issues NLC DE FY14 FY15 FY16 YTD Weight Band 1 24007+62407 0 0 0 Weight Band 2 24008+62408 0 0 0 Weight Band 3 24009+62409 0 0 0 Weight Band 4 24010+62410 0 0 0

TOTAL 24006+62406 0 0 0

Transshipments-Off-Base NLC DE FY14 FY15 FY16 YTD Weight Band 1 24083+62610 0 0 0 Weight Band 2 24084+62611 0 0 0 Weight Band 3 24085+62612 0 0 0 Weight Band 4 24086+62613 0 0 0

TOTAL 24082+62602 0 0 0

Transshipments-On-Base NLC DE FY14 FY15 FY16 YTD NLC Trans On-Base TOTAL 24081+ 62601 101 381 20

NLC DROs MIS Element FY14 FY15 FY16 YTD Weight Band 1 24102 11 1 2,687 Weight Band 2 24103 0 0 363 Weight Band 3 24104 1 0 202 Weight Band 4 24105 0 0 19

TOTAL 24101 12 1 3,271

C 5.7.4.1M RETAIL ISSUE WORKLOAD

NLC DE FY14 FY15 FY16 YTD

RDOs with Special Project Codes 22160+22161 0 0 0

TOTAL NLC ISSUES

92752 172,918 247,439 128,498

RETAIL Value Added (VA) Lines (Depiction of extra effort to process these types of Issues within the above stated weight bands) Measurement is Lines

MIS Data Element FY14 FY15 FY16 YTD Hazardous 24032 + 62432 8,906 7,057 2,964 Controlled Items 24033+62433 5,717 6,640 3,366 Hard to Handle Items 24034+62434 0 0 0 Out of Cycle (Bearer Pick Up) 24061 118,962 155,962 70,020 Out of Cycle 24037+62437 0 0 0 Local Delivery 24035+62435 149,150 238,991 121,930 RDO Issues 20762 0 0 0 Retail MROs on Base 21562 172,805 247,057 125,207 Issues to Maintenance-(On-Base) 20462 0 8 2 Issues to Maintenance-(Off-Base) 20362 0 0 0

C-5.7.4.1M RETAIL DENIALS RESEARCH

Denial Research 26500+26550+ 27500+26290 2,156 1,326 948

RETAIL ISSUE – FY15 Percentage Of Quantity Per Line By NLC Weight Bands Measurement is Lines

Quantity (Number of Individual Issues processed per line.)

Total Lines Total Lines by Weight Band

Weight Band 1

Weight Band 2

Weight Band 3

Weight Band 4 %

1 93,446 71,319 12,587 5,419 4,122 38% 2 to 9 95,111 72,590 12,811 5,515 4,196 38% 10 to 19 22,323 17,037 3,007 1,294 985 9% 20 to 29 10,954 8,360 1,475 635 483 4% 30 to 49 7,017 5,355 945 407 310 3% 50 to 99 7,309 5,578 984 424 322 3% 100+ 10,899 8,318 1,468 632 481 4% Totals 247,059 188,557 33,277 14,326 10,899 100%

RETAIL INCOMING SUPPLY DISCREPANCY REPORTS (ISDR) (TYPE 7)

Number of ISDRs Completed QMF 0 0 0 Does not show in QMF query as being performed at Retail.

C-5.7.4.1M RETAIL ISSUE ADDITIONAL REQUIREMENTS

Controlled Material/FMS Issues MIS FY14 FY15 FY16 YTD Classified/Confidential/Secret Shipped 32001 0 0 0 Controlled/Pilferable/Sensitive Shipped 32002 6,238 7,298 3,930

MIS FY14 FY15 FY16 YTD

Classified/Confidential/Secret MROShipped 32004 0 0 0 Controlled/Pilferable/Sensitive MRO Shipped 32005 6,237 7,298 3,688 Classified/Confidential/Secret FMS MRO Shipped 32007 0 0 0

Controlled/Pilferable/Sensitive FMS Shipped 32008 0 0 0

Classified/Confidential/Sensitive RCP Shipped 32013 0 0 0 Controlled Pilferable/Sensitive RCP Shipped 32014 0 0 0

C-5.7.4.1M RETAIL ISSUE ADDITIONAL REQUIREMENTS

Measurement is Lines

Controlled Material/FMS Issues MIS FY14 FY15 FY16 YTD

Classified/Confidential/Secret Transshipments 32016 0 0 0 Controlled Pilferable/Sensitive Transshipments 32017 0 0 0

MIS FY14 FY15 FY16 YTD

Classified/Confidential/Secret DROs 32019 0 0 0 Controlled/Pilferable/Sensitive DROs 32020 1 0 242

C-5.7.4.1M RETAIL ISSUE TRANSACTIONS BY HOUR AND TYPE

HOUR/TYPE 999 IPG1 IPG2 IPG3 RDO STO DRO Total by Hour % by Hour 0000-0100 0 0 0 0 0 0 0 0 0.0% 0100-0200 0 0 0 0 0 0 0 0 0.0% 0200-0300 0 0 0 0 0 0 0 0 0.0% 0300-0400 0 0 0 0 0 0 0 0 0.0% 0400-0500 0 0 0 0 0 0 0 0 0.0% 0500-0600 0 0 0 0 0 0 0 0 0.0% 0600-0700 0 0 0 9,861 0 0 0 9,861 29.8% 0700-0800 0 0 0 96 0 0 0 96 0.3% 0800-0900 0 0 0 1,670 0 0 0 1,670 5.1% 0900-1000 0 0 0 3,772 0 0 0 3,772 11.4% 1000-1100 0 0 0 4,014 0 0 0 4,014 12.1% 1100-1200 0 0 0 4,145 0 0 0 4,145 12.5%

C-5.7.4.1 RETAIL ISSUE TRANSACTIONS BY HOUR AND TYPE

HOUR/TYPE 999 IPG1 IPG2 IPG3 RDO STO DRO Total by Hour % by Hour

1200-1300 0 0 0 2,906 0 0 0 2,906 8.8% 1300-1400 0 0 0 1,674 0 0 0 1,674 5.1% 1400-1500 0 0 0 4,317 0 0 0 4,317 13.1% 1500-1600 0 0 0 593 0 0 66 593 1.8% 1600-1700 0 0 0 1 0 0 0 1 0.0% 1700-1800 0 0 0 0 0 0 0 0 0.0% 1800-1900 0 0 0 0 0 0 0 0 0.0% 1900-2000 0 0 0 0 0 0 0 0 0.0% 2000-2100 0 0 0 0 0 0 0 0 0.0% 2100-2200 0 0 0 0 0 0 0 0 0.0% 2200-2300 0 0 0 0 0 0 0 0 0.0% 2300-2400 0 0 0 0 0 0 0 0 0.0%

Total by Type 0 0 0 33,049 0 0 66 33,049 % by Type 0% 0% 0% 100% 0% 0% 0% 100.00%

C-5.7.4.1M RETAIL ISSUE TRANSACTIONS BY DAY OF WEEK AND TYPE

DAY/TYPE 999 IPG1 IPG2 IPG3 RDO STO DRO Total by Day % by Day Monday 0 0 0 4,501 0 0 66 4,501 13.6% Tuesday 0 0 0 7,249 0 0 0 7,249 21.9% Wednesday 0 0 0 5,096 0 0 0 5,096 15.4% Thursday 0 0 0 6,807 0 0 0 6,807 20.6% Friday 0 0 0 6,603 0 0 0 6,603 20.0% Saturday 0 0 0 2,793 0 0 0 2,793 8.5% Sunday 0 0 0 0 0 0 0 0 0.0%

Total by Type 0 0 0 33,049 0 0 66 33,049 % by Type 0% 0% 0% 100% 0% 0% 0% 100%

C-5.7.4.1M RETAIL FY15 ISSUE TRANSACTIONS BY HOUR AND DAY OF THE WEEK

HOUR/DAY Mon Tue Wed Thu Fri Sat Sun Total by Hour % by Hour 0000-0100 0 0 0 0 0 0 0 0 0.0% 0100-0200 0 0 0 0 0 0 0 0 0.0%

0200-0300 0 0 0 0 0 0 0 0 0.0% 0300-0400 0 0 0 0 0 0 0 0 0.0% 0400-0500 0 0 0 0 0 0 0 0 0.0% 0500-0600 0 0 0 0 0 0 0 0 0.0% 0600-0700 418 2,951 2,084 2,540 1,249 619 0 9,861 29.8% 0700-0800 5 4 23 14 38 12 0 96 0.3% 0800-0900 302 137 56 352 567 256 0 1,670 5.1% 0900-1000 389 331 142 1,251 759 900 0 3,772 11.4% 1000-1100 840 650 269 527 1,332 396 0 4,014 12.1% 1100-1200 1,023 833 717 457 517 598 0 4,145 12.5% 1200-1300 421 681 388 667 739 10 0 2,906 8.8% 1300-1400 177 416 106 419 554 2 0 1,674 5.1% 1400-1500 859 1243 790 577 848 0 0 4,317 13.1% 1500-1600 67 3 521 2 0 0 0 593 1.8% 1600-1700 0 0 0 1 0 0 0 1 0.0% 1700-1800 0 0 0 0 0 0 0 0 0.0% 1800-1900 0 0 0 0 0 0 0 0 0.0% 1900-2000 0 0 0 0 0 0 0 0 0.0% 2000-2100 0 0 0 0 0 0 0 0 0.0% 2100-2200 0 0 0 0 0 0 0 0 0.0% 2200-2300 0 0 0 0 0 0 0 0 0.0% 2300-2400 0 0 0 0 0 0 0 0 0.0%

Total by Day 4,501 7,249 5,096 6,807 6,603 2,793 0 33,049 % by Day 13.6% 21.9% 15.4% 20.6% 20.0% 8.5% 0.0% 100.0%

Packages Remarked Only

Source Data Collection FY14 FY15 FY16 YTD Total Remarks 16035+23826+42009+40709 0 0 0

Does not show in QMF query as being performed at Retail.

C-5.7.4.3 – C-5.7.4.4M Line Side Stock (LSS) and Local Delivery Shipment Consolidation (Kitting)

Collection FY14 FY15

FY16 YTD

LSS Documents Site 7,742* 45,847 14,847 LSS Items Site 465,249* 2,646,129 779,920 Local Delivery Shipment Consolidation (Kitting) Documents Site 6,317** 82,184 47,959

Local Delivery Shipment Consolidation (Kitting) Items Site N/A 51,379 232,379

*Beginning Jan’14 **Beginning Sep’14