Attachment_J.25,_TE_5.2_Projected_Workload_20_Dec_17.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
Distribution and Warehouse Services Federal contract opportunity
Solicitation number
SP3300-18-R-5004
Issued by
Defense Logistics Agency Distribution

About this file

From the source

Attachment J.25 - TE 5.2

View the file

Other files for this federal contract opportunity

Other files attached to Distribution and Warehouse Services, newest first.
File Type Posted
Attachment J.2, DDGM Site Specific DOC document
A015 - Monthly Cost Report for Special Projects and SS CLIN.pdf PDF
Attachment J.36, Draft DDGM Dist Ops Training Schedule —
Attachment J.19, TE 4.2 Gov Operated Equip for Contractor Maint —
A031 - MHE Corrosion Control Program.pdf PDF
A011 - Monthly Cost Report for Equip Maint Mat CLIN.pdf PDF
Attachment J.38, TE 5.13N MTIS Offload Process Flow.docx DOCX document
Attachment J.2, DDGM Site Specific DOC document
Notice_Regarding_Restricted_Access.docx DOCX document
Attachment_J.32,_TE_5.8N_Leak_Monitoring_Detection_and_Transfer_Procdures.docx DOCX document
CDRL_A033_-_ODS_Leak_Detection_Report.pdf PDF
CDRL_A013_-_Cost_Report_for_Material_Support_CLIN.pdf PDF
Attachment_J.6,_GE_-_Material_Handling_Equipment.doc DOC document
CDRL_A019_-_Storage_Space_Management_Report.pdf PDF
CDRL_A012_-_Cost_Report_for_Non-Capital_Equip_Replacement_CLIN.pdf PDF
Attachment_J.29,_TE_6.1_Government_Forms.docx DOCX document
Attachment_J.34_Proposed_Training_Hours_(3-31-17).xlsx XLSX spreadsheet
Attachment_J.4,_DD254.pdf PDF
CDRL_A032_-_Hazardous_Materials_Standard_Operating_Procedures.pdf PDF
Attachment_J.3,_Collective_Bargaining_Agreement.pdf PDF
Attachment_J.30,_TE_5.6N_MPC_Homeported_Ships.docx DOCX document
Attachment_J.16,_TE_3.2_Government_Training.docx DOCX document
CDRL_A018_-_DOT_Exemption_Usage_Report.pdf PDF
Attachment_J.19,_TE_4.2_Gov_Operated_Equipment_for_Contractor_Maintenance.xlsx XLSX spreadsheet
CDRL_A034_-_Local_Delivery_Refusal_Log.pdf PDF
Attachment_J.28,_TE_5.9_DSS_Load_and_Maintain.docx DOCX document
Attachment_J.2,_DDGM_Site_Specific_PWS.doc DOC document
CDRL_A015_-_Cost_Report_for_Special_Projects_and_SS_CLIN.pdf PDF
Attachment_J.23,_TE_5.0_Acceptable_Performance_Levels.doc DOC document
Attachment_J.27,_TE_5.5_Type_Physical_Inventory_Code_Matrix.docx DOCX document
CDRL_A007_-_Customer_Service_Support_Procedures.pdf PDF
CDRL_A010_-_Cost_Report_for_CLIN_X001.pdf PDF
Solicitation_SP3300-18-R-5004.pdf PDF
Attachment_J.18,_TE_4.1_Contractor_Training.docx DOCX document
Attachment_J.1,_Section_C_-_PWS_(12-21-17)_.docx DOCX document
CDRL_A003_-_Electrostatic_Discharge_Control_Program.pdf PDF
CDRL_A025_-_Container_Reclamation_Report.pdf PDF
CDRL_A021_-_Training_Report.pdf PDF
CDRL_A004_-_SSDRP.pdf PDF
Attachment_J.26,_TE_5.11_Transshipment_of_Hazardous_Assets.doc DOC document
Attachment_J.16,_TE_3.2_Government_Training.docx DOCX document
Attachment_J.7,_GE_-_Miscellaneous.docx DOCX document
Attachment_J.30,_TE_5.6N_MPC_Homeported_Ships.docx DOCX document
Attachment_J.33_Proposed_Productive_Hours.xlsx XLSX spreadsheet
Solicitation_SP3300-18-R-5004.pdf PDF
Attachment_J.2,_DDGM_Site_Specific_PWS.doc DOC document
Attachment_J.24,_TE_5.1_DDGM_Historical_Workload_Through_September_2017.xls XLS spreadsheet
Attachment_J.20,_TE_4.3_MHE_PM_Task_Codes.xlsx XLSX spreadsheet
Attachment_J.4,_DD254.pdf PDF
Attachment_J.14,_TE_2.1_Definitions_Acronyms_and_Abbreviations.docx DOCX document
Show all 50

Distribution and Warehouse Services 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.

TE 5.2

Overall Receipt and Issue Workload Projections – Lines
MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Receipts91140 or 914529,64412,85812,82012,85812,858
Issues9275263,30084,39184,13884,39184,391
Total72,94497,24996,95897,24997,249
C-5.2 Receiving
Measurement in Lines
Weight BandsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 113001 + 613016,8099,0779,0509,0779,077
Weight Band 213002 + 613021,5442,0592,0532,0592,059
Weight Band 313003 + 613031,1131,4841,4801,4841,484
Weight Band 413004 + 61304178238237238238
PC&P Excessed / Reclaimed Material1450000000
RDOs w/ Special Project1296000000
TOTAL RECEIPTS91140 or 914529,64412,85812,82012,85812,858
Value Added Lines (Depiction of extra effort to process these types of receipts within the above stated weight bands)MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Return Lines13010 + 61310478744742744744
Hazardous Lines13011 + 613111,3642,1222,1162,1222,122
Estimated Receipt Percentage of Quantity per Line
QuantityTotal LinesTotal Lines by Weight Band%
(Number of Individual Receipts processed per line)Weight Band 1Weight Band 2Weight Band 3Weight Band 4
11,51077935423814015.66%
2 to 93,4651,78881254532135.93%
10 to 191,45875234122913515.12%
20 to 29800413187126748.30%
30 to 49799412187126748.28%
50 to 99719371168113677.46%
100+892460209140839.25%
Totals9,6444,9762,2581,518892100.00%
C-5.2.4.1 Supply Discrepency Reports (SDR) (Type 8 or 9)
Measurement is Each
Type DiscrepancyYear 1 (9mo)Year 2Year 3Year 4Year 5
All Inclusive1962722,3132,3132,313
5.2.4.2 Non-Procurement Receipts (Customer Returns & Redistributions)/5.2.4.3 New Procurment
Measurement is Lines
Types of receipts processed w/in the above stated weight bandsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
New Procurement121018181,2731,2691,2731,273
Customer Returns121022,4753,8523,8403,8523,852
Redistributions101034,9697,7337,7117,7337,733
C-5.2.4.2 Receiving - Customer Returns
Measurement in Lines
Weight BandsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 113001 + 613011,7472,7192,7112,7192,719
Weight Band 213002 + 61302396617615617617
Weight Band 313003 + 61303286445443445445
Weight Band 413004 + 613044671717171
TOTAL RECEIPTS91140 or 914522,4753,8523,8403,8523,852
C-5.2.4.2 Receiving - Redistributions
Measurement in Lines
Weight BandsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 113001 + 613013,5085,4595,4445,4595,459
Weight Band 213002 + 613027961,2381,2351,2381,238
Weight Band 313003 + 61303574893890893893
Weight Band 413004 + 6130492143143143143
TOTAL RECEIPTS91140 or 914524,9697,7337,7117,7337,733
C-5.2.4.3 Receiving - New Procurements
Measurement in Lines
Weight BandsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 113001 + 61301577899896899899
Weight Band 213002 + 61302131204203204204
Weight Band 313003 + 6130394147146147147
Weight Band 413004 + 613041524232424
TOTAL RECEIPTS91140 or 914528181,2731,2691,2731,273
C-5.2.5 Additional Receipt Requirements (Value Added Lines)
(This table depicts the avg% of additional receipt lines each year over a five-year Year of performance)
Comments
Controlled Material1,036 per year
Hard to Handle< 5 items per year
Hazardous Material (HAZMAT)2,122 per year
Frustrated Material< 50 items per year
Misdirected Material< 50 items per year
Receipts Lost In-Transit< 3 items per year
Magnetic Material<3 per year
C-5.3 Storage (As of May 2017)
Year 1 (9mo)Year 2Year 3Year 4Year 5
NSNs in Storage11,55111,55111,55111,55111,551
Location Surveys116116116116116
C-5.3.3 Care of Supplies in Storage (COSIS)
Measurement is Each
Year 1 (9mo)Year 2Year 3Year 4Year 5
Visual Inspections1,6972,2622,2622,2622,262
Shelf Life (Cyclic)

Crusey, Shane M CIV (US): Crusey, Shane M CIV (US):

This is listed in J.1, is there worklod figures for this?558743743743743
Special Inspections650867867867867
C-5.3.8 Issue of Material
On-Base IssuesMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 124002 + 6240210,55914,07714,03514,07714,077
Weight Band 224003 + 624031,0261,3681,3641,3681,368
Weight Band 324004 + 624047871,0491,0461,0491,049
Weight Band 424005 + 6240581108107108108
TOTAL24001 + 6240112,45316,60216,55216,60216,602
Off-Base IssuesMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 124007 + 6240713,85218,46818,41318,46818,468
Weight Band 224008 + 62408429572570572572
Weight Band 324009 + 62409664885882885885
Weight Band 424010 + 624106080808080
TOTAL24006 + 6240615,00520,00519,94520,00520,005
Transshipments - Off-BaseMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 124083 + 626105,4067,2087,1867,2087,208
Weight Band 224084 + 62611287382381382382
Weight Band 324085 + 62612518691689691691
Weight Band 424086 + 62613114153152153153
TOTAL24082 + 626026,3258,4348,4088,4348,434
Transshipments - On-BaseMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
NLC Trans On-Base24081 + 226011,4301,9061,9011,9061,906
MPC Trans On-Base2262027,86837,15437,04237,15437,154
DROsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 124102176234234234234
Weight Band 2241032735353535
Weight Band 3241041621212121
Weight Band 42410500000
TOTAL24101219290290290290
TOTAL ISSUES63,30084,39184,13884,39184,391
Estimated Issue Percentage Of Quantity Per Line
Measurement is Lines
QuantityTotal LinesTotal Lines by Weight Band
(Number of Individual Issues processed per line)Weight Band 1Weight Band 2Weight Band 3Weight Band 4%
128,87723,4933,6961,16252645.62%
2 to 922,62018,4022,89591041235.73%
10 to 195,7024,6397302291049.01%
20 to 292,4001,95330797443.79%
30 to 491,3291,08117053242.10%
50 to 991,21999115649221.92%
100+1,15493914846211.82%
Totals63,30051,4978,1022,5471,154100.00%

C-5.3.9 Additional Issue Requirements (Value Added Lines)

Comments
Controlled Material3,139 per year
Hard to Handle< 5 items per year
Hazardous Material (HAZMAT)2,122 per year
Frustrated Material< 50 items per year
Misdirected Material< 50 items per year
Receipts Lost In-Transit< 3 items per year
C-5.3.12 Shipment Preparation
PackingYear 1 (9mo)Year 2Year 3Year 4Year 5
WB119,43425,91025,83325,91025,910
WB274398915,62615,645989
WB31,1981,5979,6569,6681,597
WB4174233504776233
Total21,54928,72951,61951,99928,729
C.5.4 Physical Inventory Counts
Inventories
Measurement is Number of Inventories Completed
Year 1 (9mo)Year 2Year 3Year 4Year 5
TPIC “C” Inventories1,0931,1551,1551,1551,155
TPIC “E” Inventories00000
TPIC “K” Inventories00000
TPIC “M” InventoriesF2BF2BF2BF2BF2B
TPIC “T” Inventories912121212
TPIC “U” InventoriesN/AN/AN/AN/AN/A
TPIC “V” InventoriesN/AN/AN/AN/AN/A
TPIC “Z” Book to Book3547474747
Total1,1371,2141,2141,2141,214
Government Performed Inventories
TPIC “D” Inventories6,3998,5328,5328,5328,532
TPIC “G” Inventories99132132132132
TPIC “L” Inventories11111
TPIC “N” Inventories378507507507507
TPIC “P” Inventories2,0252,6972,6972,6972,967
5.4.1 Floor to Book
Measurement is Each
Year 1 (9mo)Year 2Year 3Year 4Year 5
Floor to Book425567567567567
2nd Floor to Book For Count Mismatches00000
TPIC M Inventories00000
3rd Counts00000
Causative Research00000
Quality Audits2129292929
TOTAL446596596596596
C-5.4.1.2 Research of Potential or Actual Physical Inventory Adjustments
Measurement is Each
Year 1 (9mo)Year 2Year 3Year 4Year 5
Causative Research00000
IERLs (3rd Count Inventories)24444
C-5.4.4 Location Surveys
Measurement is Each
Year 1 (9mo)Year 2Year 3Year 4Year 5
Total Number of Locations20,39927,19827,19827,19827,198
Location Surveys204272272272272
Note: This can change from year to year.
C-5.5.2 Traffic Mangement and C-5.5.3 Shipping/Outloading
Measurement is Each
Off-base Issues & Off-base TransshipmentsYear 1 (9mo)Year 2Year 3Year 4Year 5
WB119,25825,67625,59925,67625,676
WB2716954951954954
WB31,1821,5761,5711,5761,576
WB4174233232233233
C-5.6.1 Preservation, Packaging and Marking (PPP&M)
Measurement is Each
RepackagedYear 1 (9mo)Year 2Year 3Year 4Year 5
X-Small174233232233233
Small546729726729729
Medium372497496497497
Large108144144144144
X-Large2939393939
XX-Large81107107107107
TOTAL1,3101,7491,7441,7491,749
C-5.6.2 Packaging Remarks (PPP&M)
Measurement is Each
Packages Remarked OnlyYear 1 (9mo)Year 2Year 3Year 4Year 5
Total Remarks472628630628628
MIS DEs 16035+23826+42009+40709
C-5.6.3 Container Fabrication Support
Measurement is Each by Type and Size
Year 1 (9mo)Year 2Year 3Year 4Year 5
# Wooden Cont FabricatedN/AN/AN/AN/AN/A
C-5.7N MATERIAL PROCESSING CENTER (MPC)
Measurement is Each
MPC LinesYear 1 (9mo)Year 2Year 3Year 4Year 5

Total MPC Transshipments Closed 47,401 63,201 63,201 63,201 63,201

C-5.8N THEATER CONSOLIDATION & SHIPPING POINT (TCSP) Air/Surface Pallet-Seavan Breakdown
TCSP LinesYear 1 (9mo)Year 2Year 3Year 4Year 5

Total TCSP Transshipments 6,059 8,078 8,078 8,078 8,078

&"-,Bold"TECHNICAL EXHIBIT 5.2 DDGM PROJECTED WORKLOAD &"-,Bold"SP3300-18-R-5004 Attachment J.25

&N

File details come from the government source that posted it.