Attachment_2_-_Revised_Attachment_J.25 TE_5.2__Projected_Workload_DDBC_Tracked_Changes_v4.pdf

SP3300-16-R-5003

Attachment J.25

Technical Exhibit 5.2 Projected Workload (March 2016) for DDBC Conformed through Amendment A004

TE 5.2

Projected Workload

WHOLESALE WORKLOAD

C 5.1 Overall Projected Receipts and Issues Y1 (9mo) Y2 Y3 Y4 Y5

Total Receipts 18,010 25,823 25,728 25,660 25,840 Total Issues 51,018 73,158 72,882 72,689 73,199 Total 69,028 98,981 98,610 98,349 99,039

C-5.2 RECEIVING

Measurement in Lines NLC Weight Bands By

Lines Y1 (9mo) Y2 Y3 Y4 Y5 Weight Band 1 10,398 14,907 14,854 14,814 14,918 Weight Band 2 3,502 5,022 5,003 4,990 5,025 Weight Band 3 3,576 5,128 5,108 5,095 5,131 Weight Band 4 534 766 763 761 766 REW STOWs 0 0 0 0 0 Total Receipts 18,010 25,823 25,728 25,660 25,840

C-5.2 Receiving - Estimated 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

Weight Band 2

Weight Band 3

Weight Band 4

1 10,417 6,014 2,026 2,070 309 58% 2 to 9 2,887 1,666 561 573 86 16% 10 to 19 1,032 596 200 205 30 6% 20 to 29 666 385 130 132 20 4% 30 to 49 575 332 110 114 17 3% 50 to 99 698 403 137 136 21 4% 100+ 1,735 1,002 338 346 51 10% Totals 18,010 8,212 3,502 3,576 534 100%

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

Type Discrepancy Y1 (9mo) Y2 Y3 Y4 Y5 All Inclusive 1,413 1,888 1,888 1,888 1,888

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

NEW PROCUREMENT (This table depicts the avg% of receipt lines projected each year over a five year period of performance)

Percent of Total Receipt Workload New Procurement 23% Customer Returns 18% Redistributions 59%

C-5.2.5 Additional Receiving Requirements (This table depicts the avg% of additional receipt lines each year over a five-year period of performance) Percent of Additional Receipt Requirements

Return Lines

80.87% Hazardous Lines 1.42% Hard to Handle 17.37% Level 1/Subsafe 0.34%

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

NSNs in Wholesale Storage 20,199 20,199 20,199 20,199 20,199

NOTE: NSNs could vary from year to year as a result of SKU (Stock Keeping Unit) changes

C-5.3.3 COSIS

Y1 (9mo) Y2 Y3 Y4 Y5 Visual Inspections 7,902 10,536 10,536 10,536 10,536 Special Inspections 756 1,004 1,004 1,004 1,004 Cyclic Inspections 90 120 120 120 120 Quality Inspections 72 90 90 90 90

NOTE: Inspections will change in coordination with NSN changes

C 5.3.8 NLC ISSUE WORKLOAD

On-Base Issues Y1 (9mo) Y2 Y3 Y4 Y5 Weight Band 1 8,774 12,581 12,534 12,501 12,589 Weight Band 2 714 1,024 1,020 1,017 1,024 Weight Band 3 484 694 691 690 694 Weight Band 4 24 34 34 34 34

TOTAL 9,996 14,333 14,279 14,242 14,341

Off-Base Issues Y1 (9mo) Y2 Y3 Y4 Y5 Weight Band 1 24,672 35,378 35,245 35,152 35,399 Weight Band 2 3,338 4,786 4,769 4,756 4,789 Weight Band 3 2,426 3,479 3,466 3,456 3,481 Weight Band 4 430 617 614 613 617

TOTAL 30,866 44,260 44,094 43,977 44,286

Transshipments-Off-Base Y1 (9mo) Y2 Y3 Y4 Y5 Weight Band 1 3,442 4,936 4,917 4,904 4,938 Weight Band 2 1,092 1,566 1,560 1,556 1,567 Weight Band 3 1,124 1,612 1,606 1,601 1,613 Weight Band 4 1,474 2,114 2,106 2,100 2,115

TOTAL 7,132 10,228 10,189 10,161 10,233

Transshipments On Base 1,064 1,526 1,520 1,516 1,527

NLC DROs Y1 (9mo) Y2 Y3 Y4 Y5 Weight Band 1 1,384 1985 1,977 1,972 1,986 Weight Band 2 232 333 331 331 333 Weight Band 3 242 347 346 345 347 Weight Band 4 102 146 146 145 146

TOTAL 1,960 2,811 2,800 2,793 2,812

TOTAL NLC ISSUES 51,018 73,158 72,882 72,689 73,199

5.3.8 Issue of Material - Estimated Issue 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 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.9 Additional Issue Requirements (This table depicts the avg% of additional issue lines each year over a five year period of performance)

Measurement is Lines Percent of Additional Issue Requirements Hazardous 1.42% Controlled Items (classified, pilferable, and sensitive)

23.69%

Hard to Handle Items 11.95% Local Delivery 49.10% Foreign Military Sales 6.42% Out of Cycle 0.41% Redistributions (RDO/STO) 6.83% Retail MROs On-Base 0.01% Issues to Maintenance (On Base) 0.16% Issues to Maintenance (Off Base) 1.0% Level 1/Subsafe 0.05%

C-5.4 PHYSICAL INVENTORY COUNTS

Inventories Measurement is Number of Inventories Completed

Y1 (9mo) Y2 Y3 Y4 Y5 TPIC “C” Inventories 3,600 4,800 4,800 4,800 4,800 TPIC “E” Inventories 1 1 1 1 1 TPIC “H” Inventories 1 4 4 4 4 TPIC “I” Inventories 0 0 0 0 0 TPIC “J” Inventories 0 0 0 0 0 TPIC “K” Inventories 1 4 4 4 4 TPIC “M” Inventories 9 14 14 14 14 TPIC “A” Inventories 0 0 0 0 0 TPIC “R” Inventories 7 8 8 8 8 TPIC “S” Inventories 0 0 0 0 0 TPIC “T” Inventories 90 121 121 121 121 TPIC “Z” Book to Book 2 6 6 6 6 Other or Blank TPIC 0 0 0 0 0

GOVERNMENT PERFORMED INVENTORIES

TPIC “D” Inventories 1,482 2,223 2,223 2,223 2,223 TPIC “G” Inventories 162 216 216 216 216

Y1 (9mo) Y2 Y3 Y4 Y5 TPIC “L” Inventories 135 181 181 181 181 TPIC “N” Inventories 594 789 789 789 789 TPIC “P” Inventories 207 279 279 279 279

NOTE: Inventories will change in coordination with NSN changes NOTE: Government Performed Inventories may result in IAVs or CAVs that the Contractor shall complete. The workload is included in the IAV and CAV projections.

C-5.4.1 FLOOR TO BOOK WORK LOAD

Floor to Book 1684 2526 2526 2526 2526

2nd Floor to Book For Count Mismatches 168 253 253 253 253 TPIC M Inventories 19 28 28 28 28 3rd Counts 18 26 26 26 26 Causative Research 1 1 1 1 1

TOTAL 1889 2834 2834 2834 2834

NOTE: This data includes both wholesale and retail

C-5.4.1.2 RESEACH OF POTENTIAL OR ACTUAL PHYSCIAL INVENTORY ADJUSTMENTS

Y1 (9mo)

Y2 Y3 Y4 Y5 Causative Research 27 36 36 36 36 IERLs (3rd Count Inventories) 153 202 202 202 202

NOTE: Inventory Adjustments will change in coordination with NSN changes

C-5.4.4 LOCATION SURVEYS

Y1 (9mo) Y2 Y3 Y4 Y5 Total Number of Locations 59,133 59,133 59,133 59,133 59,133 Location Surveys 902 1,202 1,202 1,202 1,202

NOTE: This can change from year to year

C-5.6 PACKAGING (PPP&M)

Repackaged Y1 (9mo) Y2 Y3 Y4 Y5 X-Small 21,090 22,145 23,252 23,205 23,136 Small 4,914 5,160 5,418 5,407 5,391 Medium 139 146 153 153 152 Large 384 403 423 422 421 X-Large 363 381 400 399 398 XX-Large 71 74 78 78 77 Total 26,961 28,309 29,724 29,664 29,575

C 5.6 Measurement is Each

Packages Remarked Only Y1 (9mo) Y2 Y3 Y4 Y5 Total Remarks 26,724 28,060 29,463 29,404 29,316

C-6.3 CONTAINER FABRICATION

Measurement is Each by Type and Size

Description Y1 (9mo) Y2 Y3 Y4 Y5

Size of Wooden Containers Fabricated

Small

Weight 6 lbs-40 lbs.

Item cube = or < 8 L/W/H are each > 6” or < =24” Length + Width + Height = or < 72” 846 1,122 1,122 1,122 1,122

Medium

Weight 41–150 lbs.

Item cube = or < 26 L/W/H are each > 24” or < = 48” Length + Width + Height = or <144” 45 62 62 62 62

Large

Weight 151–500 lbs.

Item cube = or < 48” L/W/H are each > 48 or < = 72” Length + Width + Height = or < 216” 0 0 0 0 0

X-Large

Weight 501-2000 lbs.

Item cube = or < 48” L/W/H are each > 48 or < = 72” 0 0 0 0 0

Fiberboard Containers Not Available 261 350 350 350 350 Other Type Containers Not Available 144 190 190 190 190

C-5.7.1 LOAD AND OFF-LOAD SUPPORT

Load/Off-Load Support 10,680 hrs 14,240 hrs 14,240 hrs 14,240 hrs 14,240 hrs

RETAIL WORKLOAD

C-5.1 Overall Projected Receipt Stows and Issues

Total Receipts 37,839 48,806 48,565 48,625 48,496 Total Issues 181,404 243,610 242,403 242,696 242,054 Total 219,243 292,416 290,968 291,321 290,550

C-5.2 Stows

Measurement in Lines NLC Weight Bands By

Lines Y1 (9mo) Y2 Y3 Y4 Y5 Weight Band 1 32,293 41,737 41,530 41,582 41,472 Weight Band 2 3,051 3,875 3,856 3,861 3,850 Weight Band 3 2,256 2,876 2,862 2,865 2,858 Weight Band 4 239 318 317 317 316 REW STOWs Total Receipts 37,839 48,806 48,565 48,625 48,496

Estimated 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

Weight Band 2

Weight Band 3

Weight Band 4

1 8,827 4,588 1,986 1,120 1,132 18.08% 2 to 9 16,543 8,601 3,723 2,098 2,122 33.90% 10 to 19 7,163 3,724 1,612 909 919 14.68% 20 to 29 3,820 1,986 860 485 490 7.83% 30 to 49 3,146 1,635 708 399 404 6.45% 50 to 99 3,046 1,583 685 386 391 6.24% 100+ 6,261 3,254 1,409 794 803 12.83%

Totals 48,806 25,371

10,983 6,191 6,261 100.00%

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

5.2.4.3 NEW PROCUREMENT (This table depicts the avg% of Non-Procurment and New Procurement receipt lines each year over a five year period of performance) Measurement is Lines

Percent of Total Non-Procurment and New Procurement

Receipt Requirements New Procurement 1.24% Customer ReturnsNon-Procurement 98.53% Unit Cost Receipt Reversals 0.19% Hazardous Receipts 0.05%

NOTE: Receipts may fall into multiple types above

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

NSNs in Retail Storage 29,655 29,655 29,655 29,655 29,655

NOTE: NSNs could vary from year to year as a result of SKU (Stock Keeping Unit) changes

C-5.3 RETAIL COSIS

Y1 (9mo) Y2 Y3 Y4 Y5 Visual Inspections 171 228 228 228 228 Special Inspections 567 752 752 752 752 Cyclic Inspections 414 546 546 546 546 Other Inspections 14 14 14 14 14

NOTE: Inspections will change in coordination with NSN changes.

C-5.4 RETAIL PHYSICAL INVENTORY COUNTS

Inventories

Measurement is Number of Inventories Completed Base Period Y2 Y3 Y4 Y5

TPIC “C” Inventories 459 607 607 697 607 TPIC “E” Inventories 0 0 0 0 0 TPIC “H” Inventories 0 0 0 0 0 TPIC “I” Inventories 0 0 0 0 0 TPIC “J” Inventories 0 0 0 0 0 TPIC “K” Inventories 846 1,128 1,128 1,128 1,128 TPIC “M” Inventories 81 105 105 105 105 TPIC “A” Inventories 0 0 0 0 0 TPIC “R” Inventories 0 0 0 0 0 TPIC “S” Inventories 0 0 0 0 0 TPIC “T” Inventories 0 0 0 0 0 TPIC “Z” Book to Book 414 546 546 546 546 Other or Blank TPIC 18 24 24 24 24

GOVERNMENT PERFORMED INVENTORIES

TPIC “D” Inventories 3,619 5,428 5,428 5,428 5,428 TPIC “G” Inventories 14 18 18 18 18 TPIC “L” Inventories 90 116 116 116 116 TPIC “N” Inventories 684 907 907 907 907 TPIC “P” Inventories 54 72 72 72 72

NOTE: Inventories will change in coordination with NSN changes NOTE: Government Performed Inventories may result in IAVs or CAVs that the Contractor shall complete. The workload is included in the IAV and CAV projections.

5.4.1.2 RETAIL RESEACH OF POTENTIAL OR ACTUAL PHYSCIAL INVENTORY ADJUSTMENTS

Y1 (9mo)

Y2 Y3 Y4 Y5 Causative Research 9 14 14 14 14 IERLs (3rd Count Inventories) 153 202 202 202 202

NOTE: Inventory Adjustments will change in coordination with NSN changes

C-5.4.4 RETAIL LOCATION SURVEYS

Y1 (9mo) Y2 Y3 Y4 Y5 Total Number of Locations - Retail 53,949 53,949 53,949 53,949 53,949 Location Surveys 91 121 121 121 121

NOTE: This can change from year to year

C 5.3.8 RETAIL ISSUE WORKLOAD

On-Base Issues Y1 (9mo) Y2 Y3 Y4 Y5 Weight Band 1 167,560 225,145 224,028 224,298 223,706 Weight Band 2 5,740 7,655 7,617 7,627 7,606 Weight Band 3 3,210 4,281 4,260 4,265 4,253 Weight Band 4 217 290 289 289 288

TOTAL 176,727176,755 237,371237,409 236,194236,232 236,479236,517 235,853235,891

Transshipments On Base Y1 (9mo) Y2 Y3 Y4 Y5 Other 28 38 38 38 38 NLC DROs Y1 (9mo) Y2 Y3 Y4 Y5 Weight Band 1 3,819 5,094 5,069 5,075 5,062 Weight Band 2 516 688 685 686 684

Weight Band 3 287 383 381 382 381 Weight Band 4 27 36 36 36 36

TOTAL 4,649 6,201 6,171 6,179 6,163

TOTAL NLC ISSUES 181,404 243,610 242,403 242,696 242,054

C-5.3.9 RETAIL ADDITIONAL ISSUE REQUIREMENTS (This table depicts the avg% of additional issue lines each year over a five year period of performance) Measurement is Lines

Percent of Additional Issue Requirements Hazardous 1.73% Controlled Items 1.62% Local Deliveries 58.48% Out of Cycle (Bearer Pick-up) 38.17%

RETAIL - Estimated Issue 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

Weight Band 2

Weight Band 3

Weight Band 4 %

1 92,142 70,323 12,411 5,343 4,065 37.82% 2 to 9 93,783 71,577 12,630 5,439 4,138 38.50% 10 to 19 22,011 16,799 2,965 1,276 971 9.04% 20 to 29 10,801 8,243 1,455 626 476 4.43% 30 to 49 6,919 5,281 932 401 305 2.84% 50 to 99 7,207 5,500 971 418 318 2.96% 100+ 10,747 8,202 1,448 623 474 4.41% Totals 243,610 185,925 32,812 14,126 10,747 100.00%

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

Y1 (9mo) Y2 Y3 Y4 Y5 LSS Documents 29,694 10,452 3,679 1,295 456 LSS Items 1,559,840 641,094 263,490 108,294 44,509 Local Delivery Shipment Consolidation Documents 95,918 109,618 123,318 137,018 150,718 Local Delivery Shipment Consolidation Items 255,617 281,179 309,291 340,220 374,242