Attachment J.22 - TE 5.1 DDHU Historical Workload Update Jan 2021.docx

DOCX document 136 KB Posted

Attached to
Distribution and Warehousing Services DLA Distribution Hill AFB, Utah Federal contract opportunity
Solicitation number
SP3300-21-R-5005
Issued by
Defense Logistics Agency Distribution

About this file

Written by GovTribe AI ·

This document provides the historical workload and performance data for DLA Distribution Hill AFB in Utah under Solicitation SP3300-21-R-5005. The requirement is for distribution and warehousing services including receiving, storage, inventory, packaging, issue processing, packing, shipping, and distribution of repair parts and secondary items. The incumbent contractor is Amentum Services, Inc. under Contract SP3300-17-D-5001 expiring April 30, 2022.

The solicitation will be for an Indefinite Delivery Indefinite Quantity contract with a five-year period of performance from February 1, 2022 through January 31, 2027 including a 90-day transition period. The estimated award date is January 2022. The requirement was previously advertised under Solicitation SP3300-20-R-5008. The NAICS code is 493110 with a size standard of $30 million. Questions should be directed to the Acquisition Specialist and Contracting Officer listed.

View the file

Other files for this federal contract opportunity

Other files attached to Distribution and Warehousing Services DLA Distribution Hill AFB, Utah, newest first.
File Type Posted
Attachment 1 - J.29 Staffing Matrix 8_31_2021.xlsx XLSX spreadsheet
Attachment 4 - J.6 CDRLs.pdf PDF
Attachment 3 - Questions from Industry and Government Responses 8_31_2021.pdf PDF
Attachment 4 - Questions from Industry and Government Responses 8_26_2021.pdf PDF
Attachment 1 - J.1 Performance Work Statement PWS 8_26_2021.docx DOCX document
SP3300-21-R-5005_0003_SF30.pdf PDF
Attachment 2 - J.2 PWS DDHU Site Specific 8_18_2021.docx DOCX document
Attachment 3 - J.3 WD 2015-5483 Rev 14.pdf PDF
Attachment 8 - Questions from Industry and Government Responses 8_18_2021.pdf PDF
Attachment 6 - SP330021R5005 0002 8_18_2021.pdf PDF
Attachment 5 - J.29 - Staffing Matrix 8_18_2021.xlsx XLSX spreadsheet
Attachment 4 - J.23 TE 5.2 8_18_2021.xlsx XLSX spreadsheet
Attachment 1 - J.1 Performance Work Statement PWS 8_18_2021.docx DOCX document
SP3300-21-R-5005_0002_SF30.pdf PDF
DDHU Teleconference- SIte Tour Attendee Roster.pdf PDF
DDHU PPC Brief 8.11.21 FINAL UPDATED POST PPC.pptx PPTX presentation
SP3300-21-R-5005_0001_SF30.pdf PDF
Attachment 1 - SP330021R5005 0001 8_9_21.pdf PDF
Attachment J.30 - Proposed Training Hours.xlsx XLSX spreadsheet
Attachment J.26 - TE 5.6 Local Delivery and Pickup Points.xlsx XLSX spreadsheet
Attachment J.23 - TE 5.2 Projected Workload 7_6_2021.xlsx XLSX spreadsheet
Attachment J.21 - TE 5.0 APLs 7_6_2021.doc DOC document
Attachment J.16 - TE 4.1 Contractor Training.docx DOCX document
Attachment J.13 - TE 3.4 Government MHE and Misc.XLSX XLSX spreadsheet
Attachment J.5 - CLIN X006 Labor Rate Table.xlsx XLSX spreadsheet
Attachment J.1 - Performance Work Statement PWS 7_6_2021.docx DOCX document
Notice Supplement 1 - DDHU Preproposal Teleconference -Site Visit Instructions (7-28-21).pdf PDF
Attachment J.33 - Subcontracting Plan Template -Includes Elements 1-15.docx DOCX document
Attachment J.28 - TE 6.1 Government Forms.docx DOCX document
Attachment J.19 - TE 4.5 Other Equipment and PM Tasks.xls XLS spreadsheet
Attachment J.12 - TE 3.3 Government Data Systems 7_6_2021.docx DOCX document
Attachment J.7 - TE 1.1 Contractor Personnel Security.docx DOCX document
Attachment J.6 - CDRLs.pdf PDF
Attachment J.34 - Past Performance Questionnaire.docx DOCX document
Attachment J.32 - Small Business Participation Commitment Document Template 5_5_21.docx DOCX document
Attachment J.29 - Staffing Matrix 7_6_2021.xlsx XLSX spreadsheet
Attachment J.27 - TE 5.9 DSS Program Loading Data.docx DOCX document
Attachment J.25 - TE 5.5 Type Physical Inventory Code (TPIC) Matrix.docx DOCX document
Attachment J.14 - TE 3.5 GE Misc Equipment and PM Task Hours.xls XLS spreadsheet
Attachment J.11 - TE 3.2 Government Training.docx DOCX document
Attachment J.10 - TE 3.1 Government Facilities (GF).docx DOCX document
Attachment J.8 - TE 1.2 CAC Procedures.docx DOCX document
Attachment J.3 - WD 2015-5483 Rev 12.pdf PDF
Attachment J.2 - PWS DDHU Site Specific 7_6_2021.docx DOCX document
Attachment J.31 - DDHU Training Calendar Feb thru Apr 2022.xlsx XLSX spreadsheet
Attachment J.24 - TE 5.4 Transshipment of Hazardous Assets.docx DOCX document
Attachment J.20 - TE 4.6 Contractor Equipment List - July 2020.xlsx XLSX spreadsheet
Attachment J.18 - TE 4.3 MHE PM Tasks.xls XLS spreadsheet
Attachment J.17 - TE 4.2 Gov Operated Equipment for Contractor Maintenance.xlsx XLSX spreadsheet
Attachment J.15 - TE 3.8 Environmental Storage Control.docx DOCX document
Show all 50

Distribution and Warehousing Services DLA Distribution Hill AFB, Utah has more files on GovTribe.

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

SP3300-20-R-5008

TECHNICAL EXHIBIT 5.1

DLA DISTRIBUTION HILL UT

HISTORICAL WORKLOAD

January 2021

C-5.1.5.1 ON-CALL RESPONSE

Measurement is Lines

Source Data Collection
FY18
FY19
FY20 MTD
Emergency Requisitions After Hours
Manual Logs
219
230
358

C-5.1.5 CUSTOMER SERVICE PLAN AND SUPPORT

Source Data Collection
FY18
FY19
FY20 MTD
Item Manager/Service Support (Occurrences)
Technical Estimate
6,921
5,778
2,907
Call-in Special Inspections (Occurrences)
Technical Estimate
1,498
728
510
Repacking and Stowing Assets (Number of NSNs)
Technical Estimate
23
36
18

C-5.1.6 NAVSUP WEAPONS SYSTEMS SUPPORT (NAVSUP WSS) IN-TRANSIT ACCOUNTABILITY (NITA)

Source Data Collection
FY18
FY19
FY20 MTD
Number of SIT SDRs Received
Technical Estimate
270
296
301
Number of SIT SDRs Researched & Completed
Technical Estimate
270
296
301

FY18 SECONDARY MONTHLY WORKLOAD (Lines)

Measurement is Lines

Month
Receipts (DE 91140)
Issues (DE 92440)
TOTAL Receipts and Issues

(DE 98400)

OCT
27,846
64,663
92,509
NOV
27,627
64,980
92,607
DEC
32,996
69,935
102,931
JAN
25,760
64,782
90,542
FEB
28,054
65,113
93,167
MAR
30,398
68,961
99,359
APR
27,576
64,800
92,376
MAY
27,061
65,852
92,913
JUN
26,330
63,517
89,847
JUL
24,060
56,856
80,916
AUG
26,771
67,247
94,018
SEP
24,800
54,783
79,583
TOTAL
329,279
771,489
1,100,768

FY19 SECONDARY MONTHLY WORKLOAD (Lines)

Measurement is Lines

Month
Receipts (DE 91140)
Issues (DE 92440)
TOTAL Receipts and Issues

(DE 98400)

OCT
25,097
58,442
83,539
NOV
24,920
58,260
83,180
DEC
25,713
51,189
76,902
JAN
24,219
55,636
79,855
FEB
24,490
53,862
78,352
MAR
27,648
60,290
87,938
APR
28,297
57,246
85,543
MAY
27,134
59,605
86,739
JUN
25,361
57,766
83,127
JUL
24,862
57,709
82,571
AUG
27,309
60,280
87,589
SEP
24,414
55,680
80,094
TOTAL
309,464
685,965
995,429

FY20 SECONDARY MONTHLY WORKLOAD (Lines)

Measurement is Lines

Month
Receipts (DE 91140)
Issues (DE 92440)
TOTAL Receipts and Issues

(DE 98400)

OCT
25,364
60,360
85,724
NOV
21,066
50,168
71,234
DEC
24,291
51,685
75,976
JAN
21,079
50,263
71,342
FEB
21,586
47,026
68,612
MAR
22,580
46,385
68,965
APR
20,054
42,000
62,054
MAY
18,763
40,182
58,945
JUN
20,505
49,499
70,004
JUL
21,107
53,796
74,903
AUG
22,751
49,677
72,428
SEP
22,694
49,323
72,017
TOTAL
261,840
590,364
852,204

C-5.2 RECEIVING

Measurement is Lines

NLC Weight Bands By Lines
NLC MIS DE
FY18
FY19
FY20
Weight Band 1
13001+61301
259,243
242,174
201,141
Weight Band 2
13002+61302
41,328
39,567
35,224
Weight Band 3
13003+61303
22,482
21,129
18,311
Weight Band 4
13004+61304
1,368
1,237
885
REW STOWs
40225
4,832
5,357
6,279
PC&P Excessed/Reclaimed Material
14500
26
0
0
RDOs with Special Project
12960
0
0
0
Total Receipts
91140
329.729
309,464
261,840

Value Added Lines (Depiction of extra effort to process these types of Receipts within the above stated weight bands)

NLC MIS Data Element
FY18
FY19
FY20
Return Lines
13010+61310
89,890
80,299
68,729
Hazardous Lines
13011+61311
2,972
2,570
1,877
Hard to Handle
13012+61312
62,366
55,415
49,287
Manual Count Receipts
91200
20,531
17,521
12,626

FY20 Percentage of Quantity per Line by Total Receipts (QMF)

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
188,378
158,500
11,083
8,351
10,444
71.9%
2 to 9
31,933
26,868
1,879
1,416
1,770
12.2%
10 to 19
9,915
8,342
583
440
550
3.8%
20 to 29
5,490
4,619
323
243
304
2.1%
30 to 49
5,513
4,639
324
244
306
2.1%
50 to 99
6,095
5,128
359
270
338
2.3%
100+
14,517
12,215
854
644
805
5.5%
TOTAL
261,840
220,310
15,405
11,608
14,517
100.0%

Note: Results from SAS Program – limited access.

C-5.2.2 OFFLOAD AND TALLY - Site

Inbound Trucks
Source Data Collection
FY18
FY19
FY20MTD
Trucks
Manual Counts
N/A
N/A
N/A
Pieces
Manual Counts
329,279
309,464
239,146
Pallets
Manual Counts
N/A
N/A
N/A

SP3300-21-R-5005

TECHNICAL EXHIBIT 5.1

DLA DISTRIBUTION HILL UT

HISTORICAL WORKLOAD

January 2021

TE 5.1

Historical Workload

C-5.2.5 ADDITIONAL REQUIREMENTS

Measurement is Lines

FY18
FY19
FY20
*Materiel Type by Lines - Receipts
Source Data Collection
Classified/Confidential/Secret Wholesale/Retail Receipts
16202
153
95
143
Controlled/Pilferable/Sensitive Wholesale/Retail Receipts
16302
5,472
5,295
6,571
Classified/Confidential/Secret Wholesale and MTIS Returns
16502
359
385
299
Controlled/Pilferable/Sensitive Wholesale and MTIS Returns
16602
4,465
3,622
2,924
Classified/Confidential/Secret Redistributions
16802
130
104
95
Controlled/Pilferable/Sensitive Redistributions
16902
3,063
2,878
1,792
Compressed Gas Cylinder
QMF
223
189
65
Radioactive
QMF
46
55
29
Corrosive
QMF
34
23
11
Explosive
QMF
0
0
0
Flammable
QMF
94
61
44
Oxidizer
QMF
4
2
0
Poison
QMF
5
2
1
CCI
QMF
49
90
28
Magnetic
QMF
4
14
6
Reactive
QMF
5
2
4

*Receipts may fall into multiple types above. (Ex: One receipt may be a combination of classified, ESD, and radioactive)

C-5.2.4.2 NON-PROCUREMENT (CUSTOMER RETURNS AND REDISTRIBUTION ORDERS) C-5.2.4.3 NEW PROCUREMENT

Measurement is Lines

Types of receipts processed within the above stated weight bands
MIS Data Element
FY18
FY19
FY20
New Procurement
12101
42,758
40,810
33,670
Customer Returns (less retrograde)
12102
193,500
178,059
152,852
Redistributions
12103
66,861
66,711
55,902
Receipts from Maintenance
10402
41,623
43,679
29,881
Serviceable Returns
10802
23,855
19,923
7,710
Unserviceable Returns
10302
82,364
78,005
66,325
Unit Cost Receipt Reversals
12950
2,095
1,543
1,092
Hazardous Receipts
11703+60370+60297
2,972
2,570
1,877
REW STOWs
40225
4,832
5,357
6,279

Note: Receipts may fall into multiple types above.

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

Measurement is Each

Type Discrepancy
Source Data Collection
FY18
FY19
FY20
Quantity Short (S)
QMF
1,400
1,058
1,609
Quantity Over (O)
QMF
412
436
469
Condition of Material (C)
QMF
3,855
3,271
1,695
HazMat (H)
QMF
19
25
27
Lumber (L)
QMF
1
2
2
Misdirected Material (M)
QMF
4
13
4
Missing Documentation (D)
QMF
2,585
2,593
1,361
Packaging Discrepancy (P)
QMF
9,092
4,435
3,815
Wrong Item (W)
QMF
629
457
222
Product Quality Deficiencies/Safety (Q)
QMF
1,512
2,277
1,878
Technical Markings Missing (T)
QMF
910
159
72
Unique Item Identification Problems (U)
QMF
60
35
19
Other Discrepancies (Z)
QMF
30,862
25,861
23,976

Total

51,341
40,622
35,149

Note: Results from QMF Query named J7 TECH SDR TYPE 8 OR 9.

C-5.3 WAREHOUSING (As of the last day of the FY)

Source Data Collection
FY18
FY19
FY20
NSNs in Storage
NSNs In Store Report
79,438
79,339
82,393

Bin Density

23%

Rack Density

16%

ITSC-TSC mis-matches

26,673

Multi NIINs per Location

LIP BIN % Buildings Completed

25%

LIP RACK % Buildings Completed

33%

LIP BULK % Buildings Completed

0%

LIP OPEN Lots % Completed

0%

C-5.3 STORAGE (As of the last day of the FY)

Source Data Collection
FY18
FY19
FY20
Bin
Bin
Bin
Storage Occupancy Rate
J3 OW Storage Team
52%
53%
56%
Rack
Rack
Rack
Storage Occupancy Rate
J3 OW Storage Team
16%
19%
100%
Bulk
Bulk
Bulk
Storage Occupancy Rate
J3 OW Storage Team
97%
99%
N/A
FY18
FY19
FY20
Storage Space Density Rate
J3 OW Storage Team
56%
54%
39%

C-5.3.3 COSIS

COSIS SPECIAL INSPECTIONS

Measurement is Each

Source Data Collection
FY18
FY19
FY20
Cyclic Inspections (Shelf-Life)
QMF
887
907
885
Other
QMF
0
0
0
Routine COSIS (Visual Inspections) (V00,V06, V12, V24, V30, & V60)
QMF
5,163
16,397
11,065
Special Inspections (SIR)
QMF
11,117
9,919
7,024
Special Quality Inspections (QN1, QN2, QN3, CSI, CS2, CS3, SOF, SO2, SO3, RSI, RS2, RS3)
QMF
1,739
1,144
1,107

Note: Results from QMF Query named J7 TECH COSIS.

C-5.3.3 COSIS

Recording, Reporting, and Performing COSIS Actions Exceeding Minor Repair

Measurement is Each

Source Data Collection
FY18
FY19
FY20
DD 1225s Completed
QMF
1,825
1,538
1,188

Note: Results from QMF Query named J7 TECH COSIS_DD_1225_COMPLETED

C-5.3.3.2 WAREHOUSING ADHOCS

Source Data Collection
FY18
FY19
FY20
UII Missing Or Suspect
QMF
7
9
9
Base Supply Item Issued Under Local LSN
QMF
Condition Code Missing Or Suspect
QMF
465
391
419
Damaged Location
QMF
3
14
21
Damaged Stock
QMF
169
122
124
Deteriorated Packaging
QMF
2
2
1
Divider Damaged Or Missing
QMF
Expir. Date Missing Or Suspect
QMF
5
Handwritten On Stock (No Positive Id)
QMF
28
6
3
Hist Data Records Missing
QMF
1
Identification Turned From View
QMF
2
Illegible Marking On Stock
QMF
4
6
6
Improper Stacking
QMF
1
Improvised Label
QMF
Inspection Required
QMF
1038
616
274
Inspection Required KCC
QMF
4
3
27
Label Cannot Be Scanned Or Read
QMF
75
15
71
Location Markings Missing Or Unreadable
QMF
70
36
9
Manufacture Pack Date Missing Or Suspect
QMF
1
1
2
Marks A Bulk Location Full
QMF
Misidentified Materiel
QMF
82
129
63
Missing Set Identification Item
QMF
5
2
2
Missing Stock Change Card (Da2100)
QMF
1
3
1
Mixed Stock In Location
QMF
571
587
961
No Label
QMF
52
9
32
NSN Missing Or Suspect
QMF
19
38
81
Opened Container Without Label
QMF
6
5
1
P&P Required
QMF
19
25
10
Recoverability Code Suspect
QMF
Requires Pallet Count Card
QMF
1
Shelf Life Code Missing Or Suspect
QMF
23
24
25
Type Storage Suspect
QMF
2
Uii Duplicate Serial Number
QMF
1
1
Unidentified Stock
QMF
51
40
21
Unit Of Issue Missing Or Suspect
QMF
304
307
333
Unit Of Issue Repackaging Required
QMF
88
48
46
Unit Of Measure Repackaging Required
QMF
21
25
10
Unnecessary Multiple Locations
QMF
1
8
3
Unsafe Location
QMF
5
52
9
Update MSDS# & HCC
QMF
4496
3790
3046
Wrong Materiel
QMF
2256
2166
1715

Total

9878
8482
7383

C-5.3.7 REWAREHOUSING ACTIONS

Measurement is Lines

Rewarehousing/Routines
MIS Data Element
FY18
FY19
FY20
Total Rewarehousing (Locations Rewarehoused)
40200
88,938
80,832
57,419

C-5.3.8 NLC ISSUE WORKLOAD

Measurement is Each

On-Base Issues
NLC DE
FY18
FY19
FY20
Weight Band 1
24002+62402
238,035
183,594
152,045
Weight Band 2
24003+62403
18,632
16,781
13,053
Weight Band 3
24004+62404
8,362
8,153
6,229
Weight Band 4
24005+62405
698
503
386
TOTAL
24001+62401
265,727
209,031
171,713
Off-Base Issues
NLC DE
FY18
FY19
FY20
Weight Band 1
24007+62407
307,293
304,459
271,642
Weight Band 2
24008+62408
16,770
16,115
11,773
Weight Band 3
24009+62409
7,843
7,319
5,860
Weight Band 4
24010+62410
495
456
331
TOTAL
24006+62406
332,401
328,349
289,606
Issues From Receiving (IFRs)
NLC DE
FY18
FY19
FY20
Weight Band 1
24012+62412
54,589
49,536
45,699
Weight Band 2
24013+62413
5,662
5,543
5,926
Weight Band 3
24014+62414
3,977
3,772
3,251
Weight Band 4
24015+62415
24
15
24
TOTAL
24011+62411
64,252
58,866
54,900
Transshipments Off-Base
NLC DE
FY18
FY19
FY20
Weight Band 1
24083+62610
26,011
13,842
11,845
Weight Band 2
24084+62611
1,759
2,168
1,985
Weight Band 3
24085+62612
1,665
1,892
1,854
Weight Band 4
24086+62613
640
843
626
TOTAL
24082+62602
30,075
18,745
16,310
Transshipments-On-Base
NLC DE
FY18
FY19
FY20
TOTAL
24081+62601
1,858
2,203
1,640
NLC DROs
NLC DE
FY18
FY19
FY20
Weight Band 1
24102
6,648
5,731
2,916
Weight Band 2
24103
603
492
306
Weight Band 3
24104
424
320
239
Weight Band 4
24105
79
55
52
TOTAL
24101
7,754
6,598
3,513
NLC DRO IFRs
NLC DE
FY18
FY19
FY20
Weight Band 1
24133
8,124
8,716
6,068
Weight Band 2
24134
2,070
1,956
1,385
Weight Band 3
24135
1,004
1,100
585
Weight Band 4
24136
127
111
69
TOTAL
24132
11,325
11,883
8,107
Rewarehousing Picks
MIS Data Element
FY18
FY19
FY20
TOTAL
40215
58,097
50,290
44,575
TOTAL NLC (ISSUES)
92440
771,489
685,965
590,364

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

Measurement is Lines

MIS Data Element
FY18
FY19
FY20
Hazardous
24032+62432
10,635
9,156
7,872
Controlled Items
24033+62433
90,082
81,841
61,152
Hard to Handle Items
24034+62434
192,697
162,961
144,631
Out of Cycle (Bearer Pick Up)
24061
36,355
43,820
21,215
Out of Cycle
24037+62437
832
798
897
Local Delivery
24035+62435
265,721
209,020
171,712
RDO Issues
20762
75,006
76,067
58,357
Retail MROs on Base
21562
138,538
95,979
107,087
Issues to Maintenance (On-Base)
20462
78,128
77,389
54,553
Issues to Maintenance (Off-Base)
20362
7,182
5,719
5,115

Note: Issues may fall into multiple types above.

C-5.5.2.6.1 FOREIGN MILITARY SALES (FMS)

Source Data Collection
FY18
FY19
FY20
Issues
24036+62436
27,287
23,427
20,682

ISSUE – FY20 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
337,938
277,039
33,121
16,056
11,722
57.2%
2 to 9
146,038
119,720
14,313
6,939
5,066
24.7%
10 to 19
39,525
32,402
3,874
1,878
1,371
6.7%
20 to 29
18,336
15,032
1,797
871
636
3.1%
30 to 49
13,808
11,319
1,353
656
479
2.3%
50 to 99
14,242
11,675
1,396
677
494
2.4%
100+
20,478
16,788
2,007
973
710
3.5%
TOTALS
590,364
483,976
57,861
28,049
20,478
100.0%

Note: Results from SAS Program – limited access.

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
DRO
Total by Hour
% by Hour
0000-0100
57
115
122
113
228
2
637
0.96%
0100-0200
2
30
31
37
7
5
112
0.17%
0200-0300
7
25
1
0
292
0
325
0.49%
0300-0400
66
236
457
461
7
1
1,228
1.85%
0400-0500
20
285
360
419
8
0
1,092
1.65%
0500-0600
20
261
159
249
56
17
762
1.15%
0600-0700
21
2,017
290
341
360
83
3,112
4.69%
0700-0800
16
4,035
928
440
286
58
5,763
8.69%
0800-0900
31
3,818
562
581
290
71
5,353
8.07%
0900-1000
33
2,705
801
429
724
64
4,756
7.17%
1000-1100
31
3,459
849
506
770
129
5,744
8.66%
1100-1200
38
3,490
847
578
188
38
5,179
7.81%
1200-1300
51
1,856
468
1,065
416
75
3,931
5.92%
1300-1400
40
5,360
867
1,647
280
60
8,254
12.44%
1400-1500
18
3,227
1,026
1,689
132
4
6,096
9.19%
1500-1600
33
1,539
486
1,052
159
1
3,270
4.93%
1600-1700
11
1,355
435
597
121
6
2,525
3.81%
1700-1800
19
1,052
135
554
42
1
1,803
2.72%
1800-1900
11
556
209
505
24
1
1,306
1.97%
1900-2000
32
468
84
259
10
1
854
1.29%
2000-2100
20
505
204
323
52
0
1,104
1.66%
2100-2200
42
1,339
137
113
55
1
1,687
2.54%
2200-2300
22
353
203
113
3
0
694
1.05%
2300-2400
2
373
335
23
32
0
765
1.15%
Total by Type
643
38,459
9,996
12,094
4,542
618
66,352
100.00%
% by Type
0.97%
57.96%
15.07%
18.23%
6.85%
0.93%
100.00%

C-5.3.8 ISSUE TRANSACTIONS BY DAY OF WEEK AND TYPE

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

DAY/TYPE
999
IPG1
IPG2
IPG3
RDO
DRO
Total by Day
% by Day
Monday
32
2,029
421
484
173
29
3,168
20.4%
Tuesday
51
2,140
956
607
226
11
3,991
25.7%
Wednesday
26
1,556
738
502
216
13
3,051
19.7%
Thursday
16
1,728
515
513
173
37
2,982
19.2%
Friday
21
792
511
460
106
51
1,941
12.5%
Saturday
4
122
22
47
20
0
215
1.4%
Sunday
9
20
44
58
24
2
157
1.0%
Total by Type
159
8,387
3,207
2,671
938
143
15,505
100.0%
% by Type
1.0%
54.1%
20.7%
17.2%
6.0%
0.9%
100.0%

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

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

HOUR/DAY
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Total by Hour
% by Hour
0000-0100
18
31
39
23
50
47
0
208
1.3%
0100-0200
1
0
0
0
0
1
0
2
0.0%
0200-0300
0
13
20
15
13
2
1
64
0.4%
0300-0400
7
174
57
21
74
52
0
385
2.5%
0400-0500
13
121
58
14
24
31
31
292
1.9%
0500-0600
9
9
31
27
35
11
7
129
0.8%
0600-0700
232
245
141
126
84
1
0
829
5.3%
0700-0800
163
214
189
354
195
25
0
1,140
7.4%
0800-0900
262
299
162
225
145
32
0
1,125
7.3%
0900-1000
163
375
302
165
146
7
0
1,158
7.5%
1000-1100
146
314
408
131
63
1
3
1,066
6.9%
1100-1200
225
160
141
130
115
1
57
829
5.3%
1200-1300
204
220
100
190
181
0
1
896
5.8%
1300-1400
619
307
407
365
401
1
0
2,100
13.5%
1400-1500
309
736
117
590
59
0
0
1,811
11.7%
1500-1600
146
344
260
155
48
0
1
954
6.2%
1600-1700
107
149
136
41
171
2
32
638
4.1%
1700-1800
41
78
111
121
36
0
10
397
2.6%
1800-1900
101
50
35
121
48
0
2
357
2.3%
1900-2000
9
41
22
50
13
0
5
140
0.9%
2000-2100
43
59
80
53
17
1
3
256
1.7%
2100-2200
11
22
21
29
14
0
4
101
0.7%
2200-2300
53
18
127
22
8
0
0
228
1.5%
2300-2400
286
12
87
14
1
0
0
400
2.6%
Total by Day
3,168
3,991
3,051
2,982
1,941
215
157
15,505
100.0%
% by Day
20.4%
25.7%
19.7%
19.2%
12.5%
1.4%
1.0%
100.0%

C-5.3.11 ISSUES TO DLA DISPOSITION SERVICES

Measurement is Lines

Source Data Collection

FY18

FY19

FY20

DROs DEMIL F
QMF
39
175
137
DROs DEMIL G
QMF
0
5
1
DROs DEMIL P
QMF
4
1
0

Note: Results from QMF Query named J7 TECH DEMIL Issues

C-5.3.12 SHIPMENT PREPARATION

Source Data Collection
FY18
FY19
FY20
Number of Packing Actions
Technical Estimate
51,285

44,082

38,747

Note: Results are from taking 10% Off-Base Issue totals plus 60% of Off-Base Transshipment totals

C-5.4 PHYSICAL INVENTORY COUNTS

Inventories

Measurement is Number of Inventories Completed

MIS Data Element
FY18
FY19
FY20
TPIC “C” Inventories
50141
2,388
750
4,788
TPIC “E” Inventories
50143
335
349
257
TPIC “H” Inventories
50145
4
0
0
TPIC “I” Inventories
50146
0
0
0
TPIC “J” Inventories
50147
0
0
0
TPIC “K” Inventories
50148
194
157
100
TPIC “M” Inventories
50150
2,738
5,589
894
TPIC “A” Inventories
50154
0
0
0
TPIC “R” Inventories
50155
1,072
751
539
TPIC “S” Inventories
50156
2
0
0
TPIC “T” Inventories
50157
1,888
807
27
TPIC “U” Inventories
50158
1,257
1,139
47
TPIC “V” Inventories
50159
572
513
973
TPIC “Z” Book to Book
52003
2,655
2,444
2,818
Other or Blank TPIC
50153
2,804
2,231
2,059

GOVERNMENT PERFORMED INVENTORIES

TPIC “D” Inventories
50142
43,098
122,905
100,233
TPIC “G” Inventories
50144
902
1,756
1,116
TPIC “L” Inventories
50149
0
0
0
TPIC “N” Inventories
50151
385
0
0
TPIC “P” Inventories
50152
573
475
130

C-5.4.1.2 RESEACH OF POTENTIAL OR ACTUAL PHYSCIAL INVENTORY ADJUSTMENTS

Measurement is Each

Source Data Collection
FY18
FY19
FY20
Causative Research
95700
1,023
1,667
1,460
FLIPLs Completed
Manual Counts - Site
17
14
6
IERLs (3rd Count Inventories)
QMF
6,724
8,678
16,453

Note: Results from QMF Query named J7 TECH IERL 3rd COUNTS.

C-5.4.2 DENIALS RESEARCH

MIS Data Element
FY18
FY19
FY20
Denial Research
26500+26550+27500+26290
15,483
10,717
7,138

C-5.4.7 ADHOCS DISCREPANCY RESEARCH AND RESOLUTION

DESCRIPTION
MIS Data Element
FY18
FY19
FY20
Reserved, No Other UII's Available
QMF
0
1
0
Add Location Required
QMF
350
1495
2460
Automatic Freeze Flag Applied
QMF
3207
2446
2460
Catalog Data Suspect
QMF
4
1
2
Controlled Inventory Item Code Missing Or Suspect
QMF
0
0
28
Default Discrepancy - Nonspecific Condition
QMF
818
712
1006
Delete Location Required
QMF
1
12
19
Lost Receipt
QMF
1
0
0
Manager Suspect
QMF
5
0
0
Material Found On Post - Requires Research
QMF
3
8
171
MWO Suspect
QMF
2
1
0
No Stock
QMF
914
458
288
Noun Missing
QMF
1
0
0
Other Stock
QMF
6
0
30
Potential Denial
QMF
2
145
122
Special Control Item Suspect
QMF
2
0
0
UII Has Different Owner
QMF
0
1
2
Wrong Count (Overages/Shortages)
QMF
5491
4178
2975
Zero Balance
QMF
10
9
2

Total

10817
9467
8575

C-5.4.4 LOCATION SURVEYS

Measurement is Each

Source Data Collection
FY18
FY19
FY20
Total Number of Locations
J3 OW - Cory M
159,950
158,468
166,694
Location Survey (Complete)
J3 OW - Cory M
2,246
2,353
2,546
Location Accuracy
Site – MIMR
N/A
N/A
N/A

SAMPLE INVENTORY RESULTS - Site

MEASUREMENT IS LINES

CATEGORY
2nd Qtr FY18
4th Qtr FY18
2nd Qtr FY19
4th Qtr FY19
A – Unit Price>$1,000
N/A
N/A
N/A
N/A

B – Unit of Issue no equal to Each OR On Hand Bal>50 – AND – Ext $ Val<$50K OR Activity>50

N/A
N/A
N/A
N/A
C – On Hand Bal<50 – AND – Date of Last Inv >24 Mo
N/A
N/A
N/A
N/A
D – Other
N/A
N/A
N/A
N/A

C-5.4.7 INCOMING SUPPLY DISCREPANCY REPORTS

Source Data Collection
FY18
FY19
FY20
Number of ISDRs Completed
QMF
5,372
4,554
3,575

Note: Results from QMF Query named J7 TECH ISDR TYPE 7.

C-5.5 TRANSPORTATION

Measurement is Lines

MROs Shipped by
MIS Data Element
FY18
FY19
FY20
Truck Load
22501
1,715
2,387
992
Less Than Truck Load
22502
9,711
7,665
5,391
Surface Parcel Post
22503
0
0
0
Surface Small Parcel
22504
160,601
160,913
125,796
Air Parcel Post
22505
0
0
0
Air Small Parcel
22506
168,612
165,246
161,195
Air Freight
22507
9,178
9,757
9,068
Local Delivery/Gov’t Truck
22509
298,372
228,402
193,125
Rail
22508
0
0
0
Other
22510
48
73
9

C-5.5.5 ASTRAY FREIGHT(GOCARE) PROGRAM

Source Data Collection
FY18
FY19
FY20
Call to Local Freight Carriers
J3 OS
30
135
121
Visits Made to Local Freight Carriers
J3 OS
0
13
4
Pieces Recovered
J3 OS
8
130
205

C-5.5.7 ADDITIONAL TRAFFIC MANAGEMENT/TRANSPORTATION REQUIREMENTS

Measurement is Lines

Controlled Material/FMS Issues
MIS
FY18
FY19
FY20
Classified/Confidential/Secret Shipped
32001
3,798
4,192
3,485
Controlled/Pilferable/Sensitive Shipped
32002
122,198
113,072
86,790
MIS
FY18
FY19
FY20
Classified/Confidential/Secret MRO Shipped
32004
3,614
4,015
3,293
Controlled/Pilferable/Sensitive MRO Shipped
32005
105,582
97,199
73,643
Classified/Confidential/Secret FMS MRO Shipped
32007
1
0
0
Controlled/Pilferable/Sensitive FMS Shipped
32008
3,402
2,745
2,260
MIS
FY18
FY19
FY20
Classified/Confidential/Secret RDOs, Shipped
32010
0
0
0
Controlled/Pilferable/Sensitive RDOs Shipped
32011
566
847
466
MIS
FY18
FY19
FY20
Classified/Confidential/Sensitive RCP Shipped
32013
0
0
0
Controlled Pilferable/Sensitive RCP Shipped
32014
1
1
2
MIS
FY18
FY19
FY20
Classified/Confidential/Secret Transshipments
32016
173
176
189
Controlled Pilferable/Sensitive Transshipments
32017
6,706
5,716
5,840
MIS
FY18
FY19
FY20
Classified/Confidential/Secret DROs
32019
10
1
3
Controlled/Pilferable/Sensitive DROs
32020
6,741
6,564
4,579

C-5.6 PACKAGING

Measurement is Each (EA)

Source Data Collection (MIS)
FY18
FY19
FY20
X-Small
16036+23827+42010+40710
49,478
92,393
17,819
Small
16037+23828+42011+40711
116,991
106,401
96,089
Medium
16038+23829+42012+40712
42,409
32,915
25,688
Large
16039+23830+42013+40713
9,610
9,474
7,371
X -Large
16040+23831+42014+40714
1,757
1,240
1,259
XX-Large
16041+23832+42015+40715
2,559
1,639
1,070

C-5.6 PACKAGING (Other) - Site

DEPACK WHEELS AND BRAKES

Source Data Collection (MIS)
FY18
FY19
FY20
X- Small
QMF
N/A
N/A
N/A
Small
QMF
N/A
N/A
N/A
Medium
QMF
N/A
N/A
N/A
Large
QMF
N/A
N/A
N/A
X-Large
QMF
N/A
N/A
N/A
XX- Large
QMF
N/A
N/A
N/A

DEPACK SUPPORT HOURS

C-5.6 PPP&M REMARKS

Measurement is Each =Label

Packages Remarked Only
Source Data Collection
FY18
FY19
FY20
Total Remarks
16035+23826+42009+40709
68,615
31,613
72,723

C-5.6.3 CONTAINER FABRICATION

Measurement is Each by Type and Size

Number of Wooden Containers Fabricated
Source Data Collection
FY18
FY19
FY20 MTD
Small
Eaches
2,322
3,240
3,201
Medium
Eaches
869
1,280
1,210
Large
Eaches
970
401
400
X-Large
Eaches
302
98
43
Fiberboard Containers
Eaches
3,000
3,000
2,280
Other Type Containers
Eaches
0
0
0

C-5.7.1AF ILS-S WORKLOAD - Site

FY18
FY19
FY20 Oct - May
Issues
N/A
N/A
N/A
Receipts
N/A
N/A
N/A
SBSS Cyclic Inspections
N/A
9,682
9,435
DORs
6,732.
6,732.
5,424.

C-5.7.2.1AF DMISA WORKLOAD – Site

FY18
FY19
FY20 Oct - May
N/A
N/A
N/A

C-5.7.1AF SBSS WORKLOAD - Site

FY18
FY19
FY20 MTD
Issues
N/A
N/A
N/A
Receipts
N/A
N/A
N/A
DORs
N/A
N/A
N/A

C-5.7.2.1AF DMISA WORKLOAD - Site

FY18
FY19
FY20 MTD
N/A
N/A
N/A

C-5.3.4.5AF F-35 RECEIVING - Site

Measurement is Lines

Receipt Weight Bands
Site
FY18
FY19
FY20 MTD

Weight Band 1

0
0

Weight Band 2

0
0

Weight Band 3

0
0

Weight Band 4

0
0

Total Receipts

0
0
1,561

C-5.3.4.5AF F-35 Issue

F-35 Issues
Site
FY18
FY19
FY20 MTD

Weight Band 1

0
0

Weight Band 2

0
0

Weight Band 3

0
0

Weight Band 4

0
0

Total Issues

0
0
1,412

C 5.5AF F-35 Traffic Management Workload Project - Site

Measurement is each

Shipment type
FY18
FY19
FY20 MTD
Standard Shipments
0
0
1,561
Heavy Weight Shipments
0
0
319

TE 5.1

Historical Workload

File details come from the government source that posted it. Updated .