The file's text, extracted by GovTribe without its formatting.
DLA DISTRIBUTION HILL, UT SP3300-16-R-5004
TECHNICAL EXHIBIT 5.2
PROJECTED WORKLOAD
November 2016
C 5.1 Overall Projected Receipts and Issues
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Total Receipts |
| 265,962 |
| 354,117 |
| 353,666 |
| 354,095 |
| 353,158 |
| Total Issues |
| 503,828 |
| 670,824 |
| 669,968 |
| 670,781 |
| 669,006 |
| Total |
| 769,790 |
| 1,024,941 |
| 1,023,634 |
| 1,024,876 |
| 1,022,164 |
C-5.2 RECEIVING
Measurement in Lines
| NLC Weight Bands By Lines |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Weight Band 1 |
| 213,381 |
| 284,113 |
| 283,756 |
| 284,096 |
| 283,354 |
| Weight Band 2 |
| 33,916 |
| 45,092 |
| 45,035 |
| 45,089 |
| 44,971 |
| Weight Band 3 |
| 16,312 |
| 21,779 |
| 21,745 |
| 21,777 |
| 21,708 |
| Weight Band 4 |
| 950 |
| 1,265 |
| 1,264 |
| 1,265 |
| 1,262 |
| PC&P Excessed/Reclaimed Matl |
| 20 |
| 27 |
| 27 |
| 27 |
| 27 |
| REW STOWs |
| 1,383 |
| 1,841 |
| 1,839 |
| 1,841 |
| 1,836 |
| Total Receipts |
| 265,962 |
| 354,117 |
| 353,666 |
| 354,095 |
| 353,158 |
Value Added Lines (Depiction of extra effort to process these types of Receipts within the above stated weight bands) This table depicts the % of receipt lines from the total above.
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Return Lines |
| 65,403 |
| 87,081 |
| 86,970 |
| 87,076 |
| 86,845 |
| Hazardous Lines |
| 3,848 |
| 5,124 |
| 5,117 |
| 5,124 |
| 5,110 |
| Hard to Handle |
| 55,251 |
| 73,564 |
| 73,470 |
| 73,559 |
| 73,365 |
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 1 |
| Weight Band 2 |
| Weight Band 3 |
| Weight Band 4 |
| 1 |
| 217,563 |
| 183,982 |
| 14,270 |
| 9,319 |
| 9,992 |
| 70.9% |
| 2 to 9 |
| 42,001 |
| 35,518 |
| 2,755 |
| 1,799 |
| 1,929 |
| 13.7% |
| 10 to 19 |
| 12,830 |
| 10,850 |
| 842 |
| 550 |
| 589 |
| 4.2% |
| 20 to 29 |
| 7,303 |
| 6,176 |
| 479 |
| 313 |
| 335 |
| 2.4% |
| 30 to 49 |
| 6,274 |
| 5,306 |
| 412 |
| 269 |
| 288 |
| 2.0% |
| 50 to 99 |
| 6,873 |
| 5,812 |
| 451 |
| 294 |
| 316 |
| 2.2% |
| 100+ |
| 14,097 |
| 11,921 |
| 925 |
| 604 |
| 647 |
| 4.6% |
| Totals |
| 306,941 |
| 259,564 |
| 20,133 |
| 13,147 |
| 14,097 |
| 100.0% |
C-5.2.4.2 NON-PROCUREMENT (CUSTOMER RETURNS AND REDISTRIBUTION ORDERS)
5.2.4.3 NEW PROCUREMENT
Measurement is Lines
| Types of receipts processed within the above stated weight bands |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| New Procurement |
| 36,333 |
| 48,376 |
| 48,314 |
| 48,373 |
| 48,245 |
| Customer Returns |
| 143,346 |
| 190,858 |
| 190,615 |
| 190,847 |
| 190,342 |
| Redistributions |
| 58,681 |
| 78,131 |
| 78,031 |
| 78,126 |
| 77,919 |
| Receipts from Maintenance |
| 33,566 |
| 44,692 |
| 44,635 |
| 44,689 |
| 44,571 |
| Serviceable Returns (wholesale) |
| 18,265 |
| 24,319 |
| 24,288 |
| 24,318 |
| 24,253 |
| Unserviceable Returns |
| 64,082 |
| 85,322 |
| 85,214 |
| 85,317 |
| 85,091 |
| Unit Cost Receipt Reversals |
| 1,527 |
| 2,033 |
| 2,030 |
| 2,033 |
| 2,027 |
| Hazardous Receipts |
| 3,849 |
| 5,124 |
| 5,118 |
| 5,124 |
| 5,110 |
| REW STOWs |
| 1,167 |
| 1,553 |
| 1,551 |
| 1,553 |
| 1,549 |
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 |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| All Inclusive |
| 7,193 |
| 9,591 |
| 9,591 |
| 9,591 |
| 9,591 |
C-5.3 Warehousing (As of the last day of the FY)
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| NSNs in Wholesale Storage |
| 75,952 |
| 75,952 |
| 75,952 |
| 75,952 |
| 75,952 |
NOTE: NSNs could vary from year to year as a result of SKU changes
C-5.3.3 COSIS
Measurement is Each
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| C-5.3.3 Visual Inspections |
| 13,500 |
| 18,000 |
| 18,000 |
| 18,000 |
| 18,000 |
| C-5.3.3 Special Inspections Wholesale |
| 4,907 |
| 6,542 |
| 6,542 |
| 6,542 |
| 6,542 |
| C-5.3.3 Cyclic Inspections |
| 594 |
| 792 |
| 792 |
| 792 |
| 792 |
NOTE: Inspections will change in coordination with NSN changes.
C 5.3.8 ISSUE OF MATERIAL WORKLOAD
| On-Base Issues |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Weight Band 1 |
| 155,971 |
| 208,334 |
| 208,068 |
| 208,321 |
| 207,770 |
| Weight Band 2 |
| 13,064 |
| 17,394 |
| 16,771 |
| 16,793 |
| 17,047 |
| Weight Band 3 |
| 5,755 |
| 7,663 |
| 7,568 |
| 7,604 |
| 7,577 |
| Weight Band 4 |
| 377 |
| 502 |
| 501 |
| 502 |
| 500 |
| TOTAL |
| 175,167 |
| 233,893 |
| 232,908 |
| 233,220 |
| 232,894 |
| Off-Base Issues |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Weight Band 1 |
| 181,932 |
| 242,226 |
| 241,912 |
| 242,210 |
| 241,559 |
| Weight Band 2 |
| 10,626 |
| 13,549 |
| 14,131 |
| 14,148 |
| 14,110 |
| Weight Band 3 |
| 6,676 |
| 8,830 |
| 8,877 |
| 8,888 |
| 8,865 |
| Weight Band 4 |
| 346 |
| 460 |
| 461 |
| 460 |
| 459 |
| TOTAL |
| 199,580 |
| 265,065 |
| 265,381 |
| 265,706 |
| 264,993 |
| Issues From Receiving (IFRs) |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Weight Band 1 |
| 43,118 |
| 57,445 |
| 57,372 |
| 57,441 |
| 57,289 |
| Weight Band 2 |
| 4,022 |
| 5,355 |
| 5,348 |
| 5,354 |
| 5,340 |
| Weight Band 3 |
| 2,321 |
| 3,090 |
| 3,086 |
| 3,090 |
| 3,082 |
| Weight Band 4 |
| 33 |
| 43 |
| 43 |
| 43 |
| 43 |
| TOTAL |
| 49,494 |
| 65,933 |
| 65,849 |
| 65,928 |
| 65,754 |
| Transshipments-Off-Base |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Weight Band 1 |
| 16,657 |
| 22,179 |
| 22,150 |
| 22,177 |
| 22,119 |
| Weight Band 2 |
| 1,124 |
| 1,497 |
| 1,495 |
| 1,497 |
| 1,493 |
| Weight Band 3 |
| 586 |
| 780 |
| 779 |
| 780 |
| 778 |
| Weight Band 4 |
| 237 |
| 316 |
| 315 |
| 316 |
| 315 |
| TOTAL |
| 18,604 |
| 24,772 |
| 24,739 |
| 24,770 |
| 24,390 |
Transshipments On-Base
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| TOTAL |
| 1,445 |
| 1,924 |
| 1,921 |
| 1,924 |
| 1,919 |
| NLC DROs |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Weight Band 1 |
| 3,194 |
| 4,252 |
| 4,247 |
| 4,252 |
| 4,241 |
| Weight Band 2 |
| 502 |
| 669 |
| 668 |
| 669 |
| 667 |
| Weight Band 3 |
| 515 |
| 685 |
| 684 |
| 685 |
| 683 |
| Weight Band 4 |
| 113 |
| 151 |
| 151 |
| 151 |
| 150 |
| TOTAL |
| 4,324 |
| 5,757 |
| 5,750 |
| 5,757 |
| 5,741 |
| NLC DRO IFRs |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Weight Band 1 |
| 5,380 |
| 7,163 |
| 7,154 |
| 7,163 |
| 7,144 |
| Weight Band 2 |
| 1,478 |
| 1,967 |
| 1,965 |
| 1,967 |
| 1,962 |
| Weight Band 3 |
| 890 |
| 1,185 |
| 1,183 |
| 1,185 |
| 1,182 |
| Weight Band 4 |
| 25 |
| 33 |
| 33 |
| 33 |
| 33 |
| TOTAL |
| 7,773 |
| 10,315 |
| 10,335 |
| 10,315 |
| 10,321 |
| Rewarehousing Picks for Retail |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| TOTAL |
| 47,441 |
| 63,165 |
| 63,085 |
| 63,161 |
| 62,994 |
Value Added (VA) Lines (Depiction of extra effort to process these types of Issues within the above stated weight bands)
Measurement is Lines
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Hazardous |
| 1,124 |
| 1,499 |
| 1,544 |
| 1,591 |
| 1,590 |
| Controlled Items |
| 12,984 |
| 17,312 |
| 17,829 |
| 18,374 |
| 18,359 |
| Hard to Handle Items |
| 8,483 |
| 11,311 |
| 11,649 |
| 12,005 |
| 11,995 |
| Local Delivery |
| 48,181 |
| 64,242 |
| 66,158 |
| 68,180 |
| 68,124 |
| Foreign Military Sales |
| 25,328 |
| 33,723 |
| 33,680 |
| 33,721 |
| 33,632 |
| Out of Cycle |
| 511 |
| 681 |
| 702 |
| 723 |
| 723 |
| Out of Cycle By Requisitioning Service |
| 98 |
| 131 |
| 135 |
| 139 |
| 139 |
| RDO Issues |
| 48,181 |
| 64,242 |
| 66,158 |
| 68,180 |
| 68,124 |
| Retail MROs On-Base |
| 5 |
| 7 |
| 7 |
| 7 |
| 7 |
| Issues to Maintenance (On-Base) |
| 10,187 |
| 13,582 |
| 13,988 |
| 14,415 |
| 14,403 |
| Issues to Maintenance (Off-Base) |
| 172 |
| 229 |
| 236 |
| 243 |
| 243 |
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 |
| 356,878 |
| 297,396 |
| 32,405 |
| 15,441 |
| 11,636 |
| 61.2% |
| 2 to 9 |
| 129,315 |
| 107,762 |
| 11,742 |
| 5,595 |
| 4,216 |
| 22.2% |
| 10 to 19 |
| 35,821 |
| 29,851 |
| 3,253 |
| 1,550 |
| 1,168 |
| 6.1% |
| 20 to 29 |
| 17,155 |
| 14,296 |
| 1,558 |
| 742 |
| 559 |
| 2.9% |
| 30 to 49 |
| 12,965 |
| 10,804 |
| 1,177 |
| 561 |
| 423 |
| 2.2% |
| 50 to 99 |
| 12,279 |
| 10,232 |
| 1,115 |
| 531 |
| 400 |
| 2.1% |
| 100+ |
| 19,023 |
| 15,852 |
| 1,727 |
| 823 |
| 620 |
| 3.3% |
| Totals |
| 583,436 |
| 486,193 |
| 52,976 |
| 25,244 |
| 19,023 |
| 100.0% |
C-5.4 PHYSICAL INVENTORY COUNTS
Inventories
Measurement is Number of Inventories Completed
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| TPIC “C” Inventories |
| 22,500 |
| 30,000 |
| 30,000 |
| 30,000 |
| 30,000 |
| TPIC “E” Inventories |
| 110 |
| 146 |
| 146 |
| 146 |
| 146 |
| 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 |
| 1,281 |
| 1,708 |
| 1,708 |
| 1,708 |
| 1,708 |
| TPIC “M” Inventories |
| 2,415 |
| 3,220 |
| 3,220 |
| 3,220 |
| 3,220 |
| TPIC “A” Inventories |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| TPIC “R” Inventories |
| 596 |
| 794 |
| 794 |
| 794 |
| 794 |
| TPIC “S” Inventories |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| TPIC “T” Inventories |
| 276 |
| 368 |
| 368 |
| 368 |
| 368 |
| TPIC “V” Inventories |
| 870 |
| 1,160 |
| 1,160 |
| 1,160 |
| 1,160 |
| TPIC “Z” Book to Book |
| 1,359 |
| 1,812 |
| 1,812 |
| 1,812 |
| 1,812 |
| Other or Blank TPIC |
| 846 |
| 1,128 |
| 1,128 |
| 1,128 |
| 1,128 |
| TOTAL |
| 30,253 |
| 40,336 |
| 40,336 |
| 40,336 |
| 40,336 |
GOVERNMENT PERFORMED INVENTORIES
| TPIC “D” Inventories |
| 13,133 |
| 13,133 |
| 13,133 |
| 13,133 |
| 13,133 |
| TPIC “G” Inventories |
| 1,170 |
| 1,560 |
| 1,560 |
| 1,560 |
| 1,560 |
| TPIC “L” Inventories |
| 0 |
| 0 |
| 0 |
| 0 |
| 0 |
| TPIC “N” Inventories |
| 779 |
| 1,038 |
| 1,038 |
| 1,038 |
| 1,038 |
| TPIC “P” Inventories |
| 3 |
| 4 |
| 4 |
| 4 |
| 4 |
NOTE: Inventories will change in coordination with NSN changes
5.4.1 FLOOR TO BOOK WORK LOAD
Measurement is Each
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
Floor to Book
| 5,171 |
| 6,876 |
| 6,876 |
| 6,876 |
| 6,876 |
| 2nd Floor to Book For Count Mismatches |
| 516 |
| 688 |
| 688 |
| 688 |
| 688 |
| TPIC M Inventories |
| 511 |
| 681 |
| 681 |
| 681 |
| 681 |
| 3rd Counts |
| 485 |
| 647 |
| 647 |
| 647 |
| 647 |
| Causative Research |
| 24 |
| 32 |
| 32 |
| 32 |
| 32 |
5.4.1.2 RESEACH OF POTENTIAL OR ACTUAL PHYSCIAL INVENTORY ADJUSTMENTS
Measurement is Each
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Causative Research - Wholesale |
| 185 |
| 246 |
| 246 |
| 246 |
| 246 |
| IERLs (3rd Count Inventories) |
| 1,278 |
| 1,701 |
| 1,701 |
| 1,701 |
| 1,701 |
NOTE: Inventory Adjustments will change in coordination with NSN changes
C-5.4.4 LOCATION SURVEYS
Measurement is Each
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Total Locations |
| 402,652 |
| 402,652 |
| 402,652 |
| 402,652 |
| 402,652 |
| Location Survey |
| 1,772 |
| 2,363 |
| 2,363 |
| 2,363 |
| 2,363 |
NOTE: This can change from year to year
5.6 PACKAGING (PPP&M)
Measurement is Each
| Repackaged |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| X-Small |
| 4,211 |
| 5,615 |
| 5,615 |
| 5,615 |
| 5,615 |
| Small |
| 47,832 |
| 63,776 |
| 63,776 |
| 63,776 |
| 63,776 |
| Medium |
| 33,015 |
| 44,020 |
| 44,020 |
| 44,020 |
| 44,020 |
| Large |
| 5,711 |
| 7,615 |
| 7,615 |
| 7,615 |
| 7,615 |
| X-Large |
| 838 |
| 1,117 |
| 1,117 |
| 1,117 |
| 1,117 |
| XX-Large |
| 3,324 |
| 4,432 |
| 4,432 |
| 4,432 |
| 4,432 |
| TOTAL |
| 94,931 |
| 126,575 |
| 126,575 |
| 126,575 |
| 126,575 |
C-5.6 Measurement is Each
| Packages Remarked Only |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Total Remarks |
| 12,329 |
| 18,123 |
| 18,087 |
| 18,032 |
| 17,996 |
C-5.6.3 CONTAINER FABRICATION
Measurement is Each by Type and Size
| Number of Wooden Containers Fabricated |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| X Small |
| N/A |
| N/A |
| N/A |
| N/A |
| N/A |
| Small |
| 2,438 |
| 3,250 |
| 3,250 |
| 3,250 |
| 3,250 |
| Medium |
| 975 |
| 1300 |
| 1,300 |
| 1,300 |
| 1,300 |
| Large |
| 308 |
| 410 |
| 410 |
| 410 |
| 410 |
| X-Large |
| 75 |
| 100 |
| 100 |
| 100 |
| 100 |
| XX Large |
| N/A |
| N/A |
| N/A |
| N/A |
| N/A |
C-5.7.6AF KITTING
Measurement is kits
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Assembled |
| 75 |
| 100 |
| 100 |
| 100 |
| 100 |
| Disassembled |
| 15 |
| 20 |
| 20 |
| 20 |
| 20 |
C-5.7.1 Overall Projected SBSS Receipts and Issues
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| SBSS Receipts |
| 27,801 |
| 37,069 |
| 37,069 |
| 37,069 |
| 37,069 |
| SBSS Issues |
| 29,148 |
| 38,863 |
| 38,863 |
| 38,863 |
| 38,863 |
| Total |
| 56,949 |
| 75,932 |
| 75,932 |
| 75,932 |
| 75,932 |
| SBSS Cyclic Inspections |
| 1,425 |
| 1900 |
| 1900 |
| 1900 |
| 1900 |
| SBSS Inventories |
| 11,062 |
| 14,750 |
| 14,750 |
| 14,750 |
| 14,750 |
| SBSS DORs |
| 7,280 |
| 9,706 |
| 9,706 |
| 9,706 |
| 9,706 |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| Year 5 |
| Load/Offload Support |
| 225 hrs |
| 300 hrs |
| 300 hrs |
| 300 hrs |
| 300 hrs |
| Depack Support |
| 1575 hrs |
| 2100 hrs |
| 2100 hrs |
| 2100 hrs |
| 2100 hrs |
TE 5.2
Projected Workload