TE 5.2 DLA Projected Workload.xlsx

XLSX spreadsheet 35 KB Posted

Attached to
Distribution and Warehousing Services at DLA Distribution Djibouti, Africa
Solicitation number
SP3300-20-R-5010
Issued by

About this file

Written by GovTribe AI ·

This document contains a technical exhibit projecting workload requirements for distribution and warehousing services at a Defense Logistics Agency depot in Djibouti, Africa over a five year period. The projected work includes receiving over 650 lines annually with 15% classified as new procurement, no customer returns, and the remainder redistributions. Warehousing requirements include storing over 800 stock numbers and completing two physical inventories annually. Issuing work consists of over 28,000 lines annually across four weight bands, with additional requirements for hazardous, controlled, and hard to handle items. Additional services encompass inventory research, location surveys, shipping, packaging, container fabrication, and shipment preparation.

View the file

Other files

File Type Posted
TE 3.2 Government Training (Amendment 0004).docx DOCX document
SP3300-20-R-5010 - Amendment 0004.pdf PDF
Attachment J.35 Training Plan (Amendment 0004).xlsx XLSX spreadsheet
TE 3.2 Government Training (Amendment 0004) - Tracked Changes.docx DOCX document
Attachment J.35 Training Plan (Amendment 0004) - Tracked Changes.xlsx XLSX spreadsheet
TE 4.1 Contractor Training (Amendment 0003).docx DOCX document
Attachment J.35 Training Plan (Amendment 0003) - Tracked Changes.xlsx XLSX spreadsheet
Attachment J.35 Training Plan (Amendment 0003).xlsx XLSX spreadsheet
TE 4.1 Contractor Training (Amendment 0003) - Tracked Changes.docx DOCX document
Questions and Answers (Amendment 0003).docx DOCX document
SP3300-20-R-5010 - Amendment 0003.pdf PDF
SP3300-20-R-5010 - Sections C-M (Amendment 0002).docx DOCX document
Questions and Answers (Amendment 0002).docx DOCX document
SP3300-20-R-5010 - Amendment 0002.pdf PDF
Attachment J.1 - Section C - PWS (Amendment 0002) - Tracked Changes.docx DOCX document
Attachment J.1 - Section C - PWS (Amendment 0002).docx DOCX document
SP3300-20-R-5010 - Sections C-M (Amendment 0002) - Tracked Changes.docx DOCX document
DLA Dist 4140.13 Location Survey - July 2020 (Amendment 0002).pdf PDF
TE 3.2 Government Training (Amendment 0001) - Tracked Changes.docx DOCX document
Attachment J.36 - Transition Training Schedule (Amendment 0001).xlsx XLSX spreadsheet
CDRL A028 Attachment 2 - Assertion Control Information (Amendment 0001).docx DOCX document
CDRL A021 - Training Report (Amendment 0001).pdf PDF
TE 5.0 Acceptable Performance Levels (Amendment 0001) - Tracked Changes.docx DOCX document
TE 5.0 Acceptable Performance Levels (Amendment 0001).docx DOCX document
Attachment J.35 - Training Plan (Amendment 0001).xlsx XLSX spreadsheet
Attachment J.2 - Section C- Site Specific PWS (Amendment 0001) - Tracked Changes.docx DOCX document
SP3300-20-R-5010 - Sections C-M (Amendment 0001).docx DOCX document
SP3300-20-R-5010 - Amendment 0001.pdf PDF
Attachment J.2 - Section C- Site Specific PWS (Amendment 0001).docx DOCX document
CDRL A006 - QCP (Amendment 0001).pdf PDF
CDRL A028 Audit Assertions (Amendment 0001).pdf PDF
SP3300-20-R-5010 - Sections C-M (Amendment 0001) - Tracked Changes.docx DOCX document
Questions and Answers (Amendment 0001).docx DOCX document
Attachment J.1 - Section C - PWS (Amendment 0001) - Tracked Changes.docx DOCX document
TE 3.2 Government Training (Amendment 0001).docx DOCX document
Attachment J.1 - Section C - PWS (Amendment 0001).docx DOCX document
CDRL A028 Attachment 1 - Assertion MFR (Amendment 0001).docx DOCX document
DDDA PPC Slides 9-10-2020.pptx PPTX presentation
Pre-Proposal Instructions.docx DOCX document
Pre-Proposal Conference Attendance List.xlsx XLSX spreadsheet
TE 5.5 Type Physical Inventory Code Matrix.docx DOCX document
CDRL A021 - Attachment 3 (MHE Training and Licensing).xlsx XLSX spreadsheet
CDRL A017 - GOCARE Program.pdf PDF
CDRL A005 - Attachment 1.xlsx XLSX spreadsheet
CDRL A021 - Attachment 1 (LMS Data Requirement).pdf PDF
CDRL A015 - Monthly Cost Report for Special Projects and SS CLIN.pdf PDF
TE 3.6.1 SSA IT Inventory.pdf PDF
SP3300-20-R-5010 - Sections C-M.docx DOCX document
CDRL A020 - Shipment to Restricted Country - Approval Necessary.pdf PDF
CDRL A027 - Monthly Contractor Employee CAC Report.pdf PDF
Show 40 more

Latest 50 of 125 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
Try for free Login

Text version

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

TE 5.2

C 5.1 Overall Projected Receipts and Issues
Y1 (8mo)Y2Y3Y4Y5
Total Receipts6539801,0231,0321,032
Total Issues28,01242,01843,82744,23044,231
Total28,66542,99844,85045,26245,263
C-5.2 RECEIVING
Measurement in Lines
NLC Weight Bands By LinesY1 (8mo)Y2Y3Y4Y5
Weight Band 1346519542547547
Weight Band 2124186194196196
Weight Band 3163244255257257
Weight Band 42031323232
REW STOWs00000
Total Receipts6539801,0231,0321,032
C-5.2 Receiving - Estimated Percentage of Quantity per Line by Total Receipts in NLC
QuantityTotal LinesTotal Lines by Weight Band%
(Number of Individual receipts processed per line.)Weight Band 1Weight Band 2Weight Band 3Weight Band 4
1562914869%0.08609271523316960.08609271520.08609271520.08609271520.0860927152
2 to 928114569382843%0.43046357621668044320.43046357620.43046357620.43046357620.4304635762
10 to 191156029161118%0.1766004415683318130.17660044150.17660044150.17660044150.1766004415
20 to 29462411657%0.07064017662713750.07064017660.07064017660.07064017660.0706401766
30 to 49562914869%0.08609271523316960.08609271520.08609271520.08609271520.0860927152
50 to 9933178535%0.0507726269209540.05077262690.05077262690.05077262690.0507726269
100+6534169610%0.099337748338181070.09933774830.09933774830.09933774830.0993377483
Total6533371618965100.00%1386185102741111
0.59091508370.28283115120.15656724440.1136375161
C-5.2.4.1 SUPPLY DISCREPANCY REPORTS (SDR) (Type 8 or 9)0.08609271520.51655629140.24724061810.13686534220.09933774830.08609271520.08609271520.08609271520.0860927152
Measurement is Each0.43046357620.43046357620.43046357620.43046357620.4304635762
Type DiscrepancyY1 (8mo)Y2Y3Y4Y50.17660044150.17660044150.17660044150.17660044150.1766004415
All Inclusive63949494940.07064017660.07064017660.07064017660.07064017660.0706401766
0.08609271520.08609271520.08609271520.08609271520.0860927152
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)0.05077262690.05077262690.05077262690.05077262690.0507726269
0.09933774830.09933774830.09933774830.09933774830.0993377483
Percent of Total Receipt Workload1
New Procurement15.14%15.14%15.14%15.14%15.14%
Customer Returns0.00%0.00%0.00%0.00%0.00%
Redistributions84.86%84.86%84.86%84.86%84.86%
C 5.2.4.3 New Procurement
Y1 (8mo)Y2Y3Y4Y5
Weight Band 14872727272
Weight Band 21726262626
Weight Band 32234343434
Weight Band 434444
Total90136136136136
C 5.2.4.2 Non-Procurement
Customer ReturnsY1 (8mo)Y2Y3Y4Y5
Weight Band 100000
Weight Band 200000
Weight Band 300000
Weight Band 400000
Total00000
C 5.2.4.2 Non-Procurement
Redistributions/ STOsY1 (8mo)Y2Y3Y4Y5
Weight Band 1269404404404404
Weight Band 296144144144144
Weight Band 3127190190190190
Weight Band 41624242424
Total508762762762762
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 Lines0,54%
Hazardous Lines0.00%
Hard to Handle0.00%
Level 1/SubsafeN/A
C-5.3 Warehousing (As of the last day of the FY)
Y1 (8mo)Y2Y3Y4Y5
NSNs in Wholesale Storage820820820820820
C-5.3.3 COSIS
Measurement is Each
Y1 (8mo)Y2Y3Y4Y5
Visual Inspections2436363636
Special Inspections2436363636
Cyclic Inspections88132132132132
Quality Inspections1624242424
C-5.3.7 Rewarehousing
Y1 (8mo)Y2Y3Y4Y5
WB195142142142142
WB23451515151
WB34567676767
WB468888
Total180268268268268
C 5.3.8 NLC ISSUE WORKLOAD
On-Base IssuesY1 (8mo)Y2Y3Y4Y5
Weight Band 17511,1261,1751,1861,186
Weight Band 2129193202204204
Weight Band 35582868787
Weight Band 4913141414
Total9441,4011,4771,4911,491
Off-Base IssuesY1 (8mo)Y2Y3Y4Y5
Weight Band 1213320334337337
Weight Band 287130136137137
Weight Band 392138144145145
Weight Band 400000
Total392588614619619
Transshipments-Off-BaseY1 (8mo)Y2Y3Y4Y5
Weight Band 12944464646
Weight Band 2710101010
Weight Band 3711121212
Weight Band 400000
Total4365686868
Transshipments On Base17,43422,89023,85924,08024,080
MPC Trans On-Base12,99617,05117,78517,94817,949
NLC DROsY1 (8mo)Y2Y3Y4Y5
Weight Band 158888
Weight Band 234444
Weight Band 3711121212
Weight Band 400000
Total1523242424

TOTAL NLC ISSUES 28,013 42,018 43,827 44,230 44,231

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 LinesTotal Lines by Weight Band
Weight Band 1Weight Band 2Weight Band 3Weight Band 4%
125,13623,2331,28842818678.5%
2 to 94,4664,128229763313.9%
10 to 191,1621,074602093.6%
20 to 2947944325841.5%
30 to 4930728416521.0%
50 to 9923822012420.7%
100+23822012420.7%
Total32,02629,6021,641545238100.0%
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
Hazardous0.07%0.07%0.07%0.07%0.07%
Controlled Items (classified, pilferable, and sensitive)0.23%0.23%0.23%0.23%0.23%
Hard to Handle Items0.00%0.00%0.00%0.00%0.00%
Local Delivery3.36%3.36%3.36%3.36%3.36%
Foreign Military Sales0.00%0.00%0.00%0.00%0.00%
Out of Cycle0.04%0.04%0.04%0.04%0.04%
Redistributions (RDO/STO)0.65%0.65%0.65%0.65%0.65%
Retail MROs On-Base2.82%2.82%2.82%2.82%2.82%
Issues to Maintenance (On Base)0.00%0.00%0.00%0.00%0.00%
Issues to Maintenance (Off Base)0.00%0.00%0.00%0.00%0.00%
Level 1/SubsafeN/A
C-5.3.12 Shipment Preparation
PackingY1 (8mo)Y2Y3Y4Y5
WB13958616161
WB21319202020
WB31420222222
WB400000
Total6698102103103
C-5.4 PHYSICAL INVENTORY COUNTS
Inventories
Measurement is Number of Inventories Completed
Y1 (8mo)Y2Y3Y4Y5
TPIC “C” Inventories22222
TPIC “E” Inventories00000
TPIC “H” Inventories00000
TPIC “I” Inventories00000
TPIC “J” Inventories00000
TPIC “K” Inventories00000
TPIC “M” Inventories00000
TPIC “A” Inventories00000
TPIC “R” Inventories00000
TPIC “S” Inventories00000
TPIC “T” Inventories00000
TPIC “Z” Book to Book00000
Other or Blank TPIC00000
Total22222
GOVERNMENT PERFORMED INVENTORIES
TPIC “D” Inventories820820820820820
TPIC “G” Inventories00000
Y1 (8mo)Y2Y3Y4Y5
TPIC “L” Inventories00000
TPIC “N” Inventories00000
TPIC “P” Inventories00000
C-5.4.1 FLOOR TO BOOK WORK LOAD
Measurement is Each
Y1 (8mo)Y2Y3Y4Y5
Floor to Book180180180180180
2nd Floor to Book For Count MismatchesN/AN/AN/AN/AN/A
TPIC M InventoriesN/AN/AN/AN/AN/A
3rd CountsN/AN/AN/AN/AN/A
Causative ResearchN/AN/AN/AN/AN/A
Total180180180180180
C-5.4.1.2 RESEACH OF POTENTIAL OR ACTUAL PHYSCIAL INVENTORY ADJUSTMENTS
Measurement is Each
Y1 (8mo)Y2Y3Y4Y5
Causative Research11111
IERLs (3rd Count Inventories)22222
C-5.4.4 LOCATION SURVEYS
Measurement is Each
Y1 (8mo)Y2Y3Y4Y5
Total Number of Locations1,0501,0501,0501,0501,050
Location Surveys5555555555
C-5.5.3 Shipping/Outloading
Measurement is Each
WB3 and WB4 Off-base Issues & Off-base TransshipmentsY1 (8mo)Y2Y3Y4Y5
WB31420222222
WB400000
C-5.6 PACKAGING (PPP&M)
Measurement is Each
RepackagedY1 (8mo)Y2Y3Y4Y5
X-Small12222
Small12222
Medium12222
Large12222
X-Large12222
XX-Large12222
Total612121212
C 5.6 Remarks
Measurement is Each
Packages Remarked OnlyY1 (8mo)Y2Y3Y4Y5
Total Remarks55555
C-6.3 CONTAINER FABRICATION
Measurement is Each by Type and Size
DescriptionY1 (8mo)Y2Y3Y4Y5
Size of Wooden Containers Fabricated
SmallWeight 6 lbs-40 lbs; Item cube = or < 8; L/W/H are each > 6” or < =24”; Length + Width + Height = or < 72”N/AN/AN/AN/AN/A
MediumWeight 41–150 lbs; Item cube = or < 26; L/W/H are each > 24” or < = 48”; Length + Width + Height = or <144”N/AN/AN/AN/AN/A
LargeWeight 151–500 lbs; Item cube = or < 48”; L/W/H are each > 48 or < = 72”; Length + Width + Height = or < 216”N/AN/AN/AN/AN/A
X-LargeWeight 501-2000 lbs; Item cube = or < 48”; L/W/H are each > 48 or < = 72”N/AN/AN/AN/AN/A
Fiberboard ContainersNot AvailableN/AN/AN/AN/AN/A
Other Type ContainersNot AvailableN/AN/AN/AN/AN/A

&"-,Bold"Technical Exhibit 5.2 DLA Projected Workload &"-,Bold"SP3300-20-R-5010

Sheet2

C-6.3 CONTAINER FABRICATION
Measurement is Each by Type and Size
DescriptionY1 (9mo)Y2Y3Y4Y5
Size of Wooden Containers Fabricated
SmallWeight 6 lbs-40 lbs; Item cube = or < 8; L/W/H are each > 6” or < =24”; Length + Width + Height = or < 72”8461122112211221122Weight 151–500 lbs; Item cube = or < 48”; L/W/H are each > 48 or < = 72”; Length + Width + Height = or < 216”8461122112211221122
MediumWeight 41–150 lbs; Item cube = or < 26; L/W/H are each > 24” or < = 48”; Length + Width + Height = or <144”4562626262
LargeWeight 151–500 lbs; Item cube = or < 48”; L/W/H are each > 48 or < = 72”; Length + Width + Height = or < 216”00000
X-LargeWeight 501-2000 lbs; Item cube = or < 48”; L/W/H are each > 48 or < = 72”00000Weight 501-2000 lbs; Item cube = or < 48”; L/W/H are each > 48 or < = 72”
Fiberboard ContainersNot Available261350350350350
Other Type ContainersNot Available144190190190190
MediumWeight 41–150 lbs; Item cube = or < 26; L/W/H are each > 24” or < = 48”; Length + Width + Height = or <144”4562626262

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 ContainersNot Available261350350350350
Other Type ContainersNot Available144190190190190

Sheet1

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)WB157.7%
WB219.4%
Percent of Total Receipt WorkloadWB319.9%
New Procurement23%WB43.0%
Customer Returns18%
Redistributions59%
C 5.2.4.3 New Procurement
Y1 (9mo)Y2Y3Y4Y5
Weight Band 187130136137137
Weight Band 22944464646
Weight Band 33045474747
Weight Band 447777
TOTAL150225235237237
C 5.2.4.2 Non-Procurement
Customer ReturnsY1 (9mo)Y2Y3Y4Y5
Weight Band 168102106107107
Weight Band 22334363636
Weight Band 32335373737
Weight Band 435566
TOTAL118176184186186
C 5.2.4.2 Non-Procurement
Redistributions/ STOsY1 (9mo)Y2Y3Y4Y5
Weight Band 1222334348352352
Weight Band 275112117118118
Weight Band 376115120121121
Weight Band 41117181818
TOTAL385578604609609

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