Attachment_J.28_TE_5.2_Projected_Workload_(JCD)_20190517_(Tracked_Changes).xlsx

36 KB Posted

Attached to
Distribution and Warehousing Services - DLA Distribution Cherry Point, North Carolina
Solicitation number
SP3300-19-R-5003
Issued by

About this file

Written by GovTribe AI ·

This document contains a workload projection template for distribution and warehousing services at Defense Logistics Agency Distribution Cherry Point, North Carolina. The template provides projected workloads for receipt, storage, inventory management, issue, preservation, and transportation of material over five years. Key details include projected volumes for receipt and storage of material across four weight bands, inventory counts on over 250 million National Stock Numbers, issues of material for on-base and off-base delivery totaling over 380,000 lines annually, and repackaging of over 75,000 lines of material each year. The associated federal contract opportunity relates to solicitation SP3300-19-R-5003 for distribution and warehousing services at DLA Distribution Cherry Point, with amendment 0003 providing government responses to additional industry questions.

From the source

Attachment J.28, Technical Exhibit (TE) 5.2 Projected Workload (Tracked Changes)

View the file

Other files

File Type Posted
SP3300-19-R-5003_Amendment_0003.pdf PDF
RFP_SP3300-19-R-5003_Sections_B_-_M_6.19.19.docx DOCX document
RFP_SP3300-19-R-5003_Sections_B_-_M_6.19.19_(Tracked_Changes).docx DOCX document
Amendment_3_Q&As.xlsx XLSX spreadsheet
Attachment_J.26_TE_5.0_APLs__Amend_2.doc DOC document
Attachment_J.2_Amend_2.docx DOCX document
A006_-_Quality_Control_Plan.pdf PDF
RFP_SP3300-19-R-5003_Sections_B_-_M_6.14.19.docx DOCX document
Attachment_J.38,_Proposed_Productive_Hours.xlsx XLSX spreadsheet
A028_-_Floor_to_Book_Report_(Portfolio).pdf PDF
Attachment_J.41,_Limitation_on_Subcontracting_Report.xls XLS spreadsheet
Amendment_2_Q&As.xlsx XLSX spreadsheet
A010_-_Monthly_Cost_Report_for_FPIF_CLIN_X001.pdf PDF
Attachment_J.38,_Proposed_Productive_Hours_(Tracked_Changes).xlsx XLSX spreadsheet
Attachment_J.26,_TE_5.0_APLs__Amend_2_(Tracked_Changes).doc DOC document
Current_Contract_Phase-Out_Requirement.docx DOCX document
Attachment_J.28_TE_5.2_Projected_Workload_(JCD)_201900517.xlsx XLSX spreadsheet
Attachment_J.16,_TE_3.2_Government_Training_(5-17-19).docx DOCX document
RFP_SP3300-19-R-5003_Sections_B_-_M_6.14.19_(Tracked_Changes).docx DOCX document
A009_-_Management_Plan_(MCCP).pdf PDF
Attachment_J.1_Amend_2_(Tracked_Changes).docx DOCX document
Attachment_J.2_Amend_2_(Tracked_Changes).docx DOCX document
Attachment_J.19,_TE_3.5_GE_Misc_Equipment.xlsx XLSX spreadsheet
Attachment_J.1_Amend_2.docx DOCX document
SP3300-19-R-5003_Amendment_0002.pdf PDF
Attachment_J.16,_TE_3.2_Government_Training_(5-17-19)_(Tracked_Changes).docx DOCX document
SP3300-19-R-5003_Amendment_0001.pdf PDF
SP3300-19-R-5003_Pre-Proposal_Conference_Roster.pdf PDF
DDCN_PPC_Slides_(5-1-19)_FINAL.pptx PPTX presentation
Attachment_J.5,_DD254.pdf PDF
Attachment_J.6,_CLIN_X006_Labor_Rate_Table.xlsx XLSX spreadsheet
Attachment_J.40,_Draft_DDCN_Dist_Ops_Training_Schedule.xlsx XLSX spreadsheet
Attachment_J.11,_CDRLs.zip ZIP file
RFP_SP3300-19-R-5003.pdf PDF
Attachment_J.42,_Past_Performance_Questionnaire.docx DOCX document
Attachment_J.39,_Training_Plan.xlsx XLSX spreadsheet
Notice_Regarding_Resticted_Access.docx DOCX document
Attachment_J.9,_Contractor_Equipment_List.xlsx XLSX spreadsheet
Attachment_J.2,_DDCN_Site_Specific_Requirements.docx DOCX document
Attachment_J.12_-_J.37,_Technical_Exhibit_(TE).zip ZIP file
Attachment_J.41,_Limitation_on_Subcontracting_Report.xls XLS spreadsheet
Attachment_J.3,_Collective_Bargaining_Agreement_Through_8.31.21.pdf PDF
Attachment_J.38,_Proposed_Productive_Hours.xlsx XLSX spreadsheet
Attachment_J.1,_PWS.docx DOCX document
Attachment_J.4,_Wage_Determination_12.26.18.pdf PDF
DDCN_Preproposal_Conference_Instructions.docx DOCX document
DDCN_Preproposal_Conference_Instructions.docx DOCX document
Show all 47

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 5-17-19

WHOLESALEDDCN Projected TE
Overall Receipt and Issue Workload Projections – Lines
MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Receipts9114075,810101,759101,776101,797101,816
Issues92440286,648383,766383,835383,904383,979
Total Workload98400362,458485,525485,611485,701485,795
Overall Receipt and Issue Monthly Workload Projections – Lines (June 2020 through February (2021)
Receipts (91140)Issues (92440)
Monthly Receipts%Monthly Issues%Total Monthly Receipts & Issues
Jun9,32312.30%31,07810.84%40,401
Jul8,98411.85%36,20512.63%45,190
Aug9,42212.43%37,43713.06%46,859
Sep5,7577.59%23,4248.17%29,181
Oct9,35512.34%33,34411.63%42,699
Nov8,41011.09%32,02211.17%40,432
Dec8,69111.46%29,07510.14%37,765
Jan8,12410.72%29,40010.26%37,524
Feb7,74310.21%34,66412.09%42,406
Total75,810100.00%286,648100.00%362,458
*Note percentage figures in this table were calculated using the actual receipt and issue figures realized during FY18.
C-5.2 Receiving
Measurement in Lines
Weight BandsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 113001 + 6130161,12082,07482,08882,10482,119
Weight Band 213002 + 613029,24612,38512,38712,39012,392
Weight Band 313003 + 613034,9646,6496,6506,6516,653
Weight Band 413004 + 61304480651651652652
Rewarehouse Stow at Depot after Pick at Retail4022500000
RDOs w/ Special Project1296000000
TOTAL RECEIPTS9114075,810101,759101,776101,797101,816
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
152,50237,6345,7814,2564,83151.59%
2 to 920,44114,6522,2511,6571,88120.09%
10 to 197,3015,2348045926727.18%
20 to 293,9032,7984303163593.84%
30 to 493,8492,7594243123543.78%
50 to 994,4003,1544843574054.32%
100+9,3636,7121,0317598629.20%
Total101,75972,94311,2048,2499,363100.00%
C-5.2.4.1 Supply Discrepancy Reports (SDR) (Type 8 or 9)
Measurement is Each
Type DiscrepancyMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
All InclusiveQMF Query7,90010,53410,53410,53410,534
C-5.2.4.2 New Procurement Receipts
Measurement is Lines
Weight BandsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 1N/A19,93426,75726,76126,76726,772
Weight Band 2N/A3,0104,0404,0404,0414,042
Weight Band 3N/A1,6162,1692,1692,1702,170
Weight Band 4N/A158212212212212
Total New Procurement1210124,71733,17733,18333,19033,196
C-5.2.4.2 Customer Return Receipts
Measurement is Lines
Weight BandsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 1N/A12,49616,77316,77616,77916,783
Weight Band 2N/A1,8872,5322,5332,5332,534
Weight Band 3N/A1,0131,3601,3601,3601,360
Weight Band 4N/A99133133133133
Total Customer Returns1210215,49420,79820,80120,80620,809
C-5.2.4.2 Redistributions Receipts
Measurement is Lines
Weight BandsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 1N/A28,65438,46238,46838,47638,483
Weight Band 2N/A4,3265,8075,8085,8095,810
Weight Band 3N/A2,3223,1173,1183,1193,119
Weight Band 4N/A227305305305305
Total Redistributions1210335,52947,69047,69847,70847,717
C-5.2.5 Additional Receipt Requirements (Value Added Lines)
MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Controlled Material306602230303030
Hard to Handle13012 + 6131220,67527,75227,75727,76327,768
Hazardous Material (HAZMAT)13011 + 613114865656565
Frustrated Material1030219,72427,34827,35327,35827,363
Misdirected Material3010400000
Receipts Lost In-Transit12950245339339340340
Magnetic MaterialSAS Query22222
C-5.2.5.14M MATERIAL TURNED INTO STORE (MTIS)
Measurement is Each
MPC LinesMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
DLRs w/ Project Code Z5S1400290120120120120
CIIC w/Project Code Z5T141023648484848
Consumables >$2500 w/Project Code Z5U142023648484848
Consumables < $2500 w/Project Code Z5V14302212282282282282
All Other w/o PMRD w/Project Code Z5W144024155555555
Total MTIS Workload415498498498498
C-5.3 Storage (as of Jul'18) **Includes approximately 25,000 NIINs shared by Retail
SourceYear 1 (9mo)Year 2Year 3Year 4Year 5
NSNs in StorageNSNs in Store FY18 Report2507650,3142507650,3152507650,3152507650,3152507650,315
C-5.3.1 Stow of Receipts
Measurement in Lines
Weight BandsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 1N/A61,12082,07482,08882,10482,119
Weight Band 2N/A9,24612,38512,38712,39012,392
Weight Band 3N/A4,9646,6496,6506,6516,653
Weight Band 4N/A480651651652652
TOTAL STOWSN/A75,810101,759101,776101,797101,816
C-5.3.3 Care of Supplies in Storage (COSIS)
Measurement is Each
SourceYear 1 (9mo)Year 2Year 3Year 4Year 5
Visual InspectionsQMF Query2,1772,9032,9032,9032,903
Shelf Life (Cyclic)QMF Query301401401401401
Special InspectionsQMF Query1,8292,4382,4382,4382,438
C-5.3.8 Issue of Material
On-Base Issues (includes mode of shipment codes equal to ‘9’ local delivery or ‘X’ Bearer, Walk-thru)MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 124002 + 6240270,76694,79494,81194,82894,846
Weight Band 224003 + 624032,9904,0054,0064,0074,007
Weight Band 324004 + 624042,3373,1313,1313,1323,133
Weight Band 424005 + 62405100134135135135
TOTAL24001 + 6240176,194102,064102,083102,102102,121
Off-Base IssuesMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 124007 + 62407167,225223,797223,834223,873223,918
Weight Band 224008 + 624084,0315,4005,4015,4025,403
Weight Band 324009 + 624092,1232,8432,8442,8442,845
Weight Band 424010 + 62410119159159159159
TOTAL24006 + 62406173,498232,199232,238232,278232,325
Transshipments Off-BaseMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 124083 + 626102,6263,5173,5183,5183,519
Weight Band 224084 + 62611668895896896896
Weight Band 324085 + 62612695930930931931
Weight Band 424086 + 62613623834835835835
TOTAL24082 + 626024,6126,1766,1796,1806,181
Transshipments - On-BaseMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
NLC Trans On-Base24081 + 226013,9665,3135,3145,3155,316
MPC Trans On-Base2262000000
DROsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 1241021,1951,6001,6011,6011,601
Weight Band 224103164220220221221
Weight Band 324104113151151151151
Weight Band 4241051115151515
TOTAL241011,4831,9861,9871,9881,988
RewarehousingMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Picks (at Depot for Stow at Retail )4021526,89636,02836,03436,04136,048
TOTAL ISSUES92440286,649383,766383,835383,904383,979
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%
1228,288188,98521,44010,5937,27059.49%
2 to 989,40774,0158,3974,1492,84723.30%
10 to 1923,38519,3592,1961,0857456.09%
20 to 2912,65610,4771,1895874033.30%
30 to 498,7877,2748254082802.29%
50 to 999,0207,4678474192872.35%
100+12,22210,1181,1485673893.18%
Total383,766317,69536,04217,80812,221100.00%

Additional Issue Requirements (Value Added Lines)

MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Controlled Material3200219,26725,79525,79925,80425,809
Hard to Handle24034 + 6243412,91217,28717,29017,29417,297
Hazardous Material (HAZMAT)212621,3691,8321,8321,8331,833
Frustrated MaterialN/A00000
Misdirected MaterialN/A00000
Receipts Lost In-TransitN/A00000
Magnetic MaterielSAS Query00000
C-5.3.12 Shipment Preparation
Off-Base Issues & Off-Base TransshipmentsSourceYear 1 (9mo)Year 2Year 3Year 4Year 5
WB1N/A169,851227,314227,352227,391227,437
WB2N/A4,7006,2956,2976,2986,299
WB3N/A2,8173,7733,7743,7753,776
WB4N/A743993994994994
TotalPercentage Formula178,110238,375238,417238,458238,506
C-5.4.1 Floor to Book - 2% of Total Locations
Measurement is Each
MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Floor to BookN/A2,17899229011,32229011,32229011,32229011,322
TPIC M Inventories (Included in 5.4.2 workload)N/A00000
C-5.4 .2 Warehouse Management System (WMS) Physical Inventory Counts
Inventories
Measurement is Number of Inventories Completed
MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
TPIC “D” Inventories - 1st Counts (Oct-Jul)5014260,58580,78080,78080,78080,780
TPIC “D” Inventories - 2nd Counts (Oct-Jul) (19.8% 1st Count TPIC "D")5014211,99615,99415,99415,99415,994
TPIC “G” Inventories -Classified50144138184184184184
All Other TPICs (E-V) - 1st Counts50143+50148+50150+ 50155+50517+501595,3037,0707,0707,0707,070
All Other TPICs (E-V) - 2nd Counts (19.8% 1st Count TPICs E-V)50143+50148+50150+50155+ 50517+501591,0501,4001,4001,4001,400
Total79,072105,428105,428105,428105,428
C-5.4.2.1 Research of Potential or Actual Physical Inventory Adjustments ** Includes both Wholesale and Retail
Measurement is Each
MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Causative Research957001,7642,3522,3522,3522,352
C-5.4.3 Denial Research ** Includes both Wholesale and Retail
Measurement is Each
MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Denial Research26490+26550+26590+ 26630+26670+26710+ 27490+27550+27590+ 27630+27670+277102,5613,4153,4153,4153,415
C-5.4.5 Location Surveys **Includes Both Wholesale and Retail locations; does not include Location Surveys associated with rewarehousing
Measurement is Each
SourceYear 1 (9mo)Year 2Year 3Year 4Year 5
Location SurveysJ4 Inventory1285178,670128,51711,560128,51711,560128,51711,560128,51711,560
Please Note: This can change from year to year.
C-5.4.6 ADHOC
Measurement is Each
SourceYear 1 (9mo)Year 2Year 3Year 4Year 5
5.4.3 V00 Adhocs (COSIS only)QMF Query2,1772,9032,9032,9032,903
C-5.5.2 Traffic Management and C-5.5.3 Shipping
Measurement is Each
Off-Base Issues & Off-Base TransshipmentsSourceYear 1 (9mo)Year 2Year 3Year 4Year 5
WB1N/A169,851227,314227,352227,391227,437
WB2N/A4,7006,2956,2976,2986,299
WB3N/A2,8173,7733,7743,7753,776
WB4N/A743993994994994
TOTALN/A178,110238,375238,417238,458238,506
C-5.5.5 Security Assistance Program (SAP): Foreign Military Sale (FMS) and Grant Aid
Measurement is Each
MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
FMS24036 + 624369,94913,31913,32213,32413,327

C-5.5.6 Additional Traffic Management/Transportation Requirements (Value Added Lines)

MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Controlled MaterialN/A00000
Hard to HandleN/A00000
Hazardous Material (HAZMAT)N/A00000
Frustrated MaterialN/A00000
Misdirected MaterialN/A00000
Receipts Lost In-TransitN/A00000
C-5.6.1 Preservation, Packaging and Marking (PPP&M)
Measurement is Each
RepackagedMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
X-Small16036+23827+42010+407102,5963,4773,4783,4793,479
Small16037+23828+42011+4071129,49039,49539,50339,51039,518
Medium16038+23829+42012+4071220,35527,26027,26627,27127,276
Large16039+23830+42013+407133,5214,7164,7174,7184,719
X-Large16040+23831+42014+40714517692692692692
XX-Large16041+23832+42015+407152,0492,7452,7452,7462,746
TOTAL58,52978,38578,40278,41678,430
C-5.6.2 Packaging Remarks (PPP&M)
Measurement is Each
Packages Remarked OnlyMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Total Remarks16035+23826+42009+4070917,48323,41423,41923,42423,428
C-5.6.3 Container Fabrication Support
Measurement is Each by Type and Size
SizeSourceYear 1 (9mo)Year 2Year 3Year 4Year 5
X-SmallSite159212212212212
SmallSite8691,1591,1591,1591,159
MediumSite656875875875875
LargeSite121161161161161
X-LargeSite75100100100100
XX-LargeSite102136136136136
Fiberboard ContainersSiteN/AN/AN/AN/AN/A
Other Type ContainersSiteN/AN/AN/AN/AN/A
C-5.7.1M Mobile Crane and Rigging Support
Measurement is Annual Productive Hours
Labor CategorySourceYear 1 (9mo)Year 2Year 3Year 4Year 5
Crane OperatorTechnical Estimate3547474747
RiggerTechnical Estimate7094949494
Blocker and BracerTechnical Estimate338450450450450
C-5.7.3.1 AV-8B PHM
Measurement is Annual Productive Hours
Labor CategorySourceYear 1 (9mo)Year 2Year 3Year 4Year 5
Warehouse Specialist SupervisorTechnical Estimate1,3351,7801,7801,7801,780
Warehouse SpecialistTechnical Estimate2,6703,5603,5603,5603,560
Supply SpecialistTechnical Estimate1,3351,7801,7801,7801,780
RETAILDDCM Projected TE
C-5.3M Storage (as of Jul'18) **Includes approximately 25,000 NIINs shared by Wholesale
SourceYear 1 (9mo)Year 2Year 3Year 4Year 5
NSNs in StorageNSNs in Store FY18 Report55,52655,52655,52655,52655,526
C-5.3.3M Care of Supplies in Storage (COSIS)
Measurement is Each
SourceYear 1 (9mo)Year 2Year 3Year 4Year 5
Visual InspectionsQMF Query87116116116116
Shelf Life (Cyclic)QMF Query231308308308308
Special InspectionsQMF Query371494494494494
C-5.3.8M Issue of Material
Off-Base IssuesMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 124007 + 624073,2764,1754,1724,1704,380
Weight Band 224008 + 624086283838383
Weight Band 324009 + 62409912121212
Weight Band 424010 + 6241022222
TOTAL24006 + 624063,3494,2724,2694,2674,477
Transshipments Off-BaseMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 124083 + 6261022222
Weight Band 224084 + 6261100000
Weight Band 324085 + 6261200000
Weight Band 424086 + 6261300000
TOTAL24082 + 6260222222
DROsMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Weight Band 124102128172172172172
Weight Band 22410356666
Weight Band 32410456666
Weight Band 42410500000
TOTAL24101137184184184184
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%
13,2013,04290452459.49%
2 to 91,0369842915823.30%
10 to 1987832116.09%
20 to 2937361103.30%
30 to 4933321002.29%
50 to 9929281002.35%
100+34321003.18%
Totals4,4584,2371256334100.00%

Additional Issue Requirements (Value Added Lines)

MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
Controlled Material3200200000
Hard to Handle24034 + 6243400000
Hazardous Material (HAZMAT)2126200000
Frustrated MaterialN/A00000
Misdirected MaterialN/A00000
Receipts Lost In-TransitN/A00000
Magnetic MaterielSAS Query00000
C-5.3.12M Shipment Preparation
Off-Base Issues & Off-Base TransshipmentsSourceYear 1 (9mo)Year 2Year 3Year 4Year 5
WB1N/A3,2784,1774,1744,1724,382
WB2N/A6283838383
WB3N/A912121212
WB4N/A22222
TotalN/A3,3504,2744,2714,2694,479
C-5.5.2M Traffic Management and C-5.5.3M Shipping
Measurement is Each
Off-Base Issues & Off-Base TransshipmentsSourceYear 1 (9mo)Year 2Year 3Year 4Year 5
WB1N/A3,2784,1774,1744,1724,382
WB2N/A6283838383
WB3N/A912121212
WB4N/A22222
TOTALN/A3,3504,2744,2714,2694,479
C-5.5.5M Security Assistance Program (SAP): Foreign Military Sale (FMS) and Grant Aid
Measurement is Each
MIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
FMS24036 + 62436250333333333333
C-5.6.1M Preservation, Packaging and Marking (PPP&M)
Measurement is Each
RepackagedMIS DEYear 1 (9mo)Year 2Year 3Year 4Year 5
X-Small16036+23827+42010+40710111163163163163
Small16037+23828+42011+4071175110110110110
Medium16038+23829+42012+40712168247247247247
Large16039+23830+42013+407133754545454
X-Large16040+23831+42014+407143246464646
XX-Large16041+23832+42015+4071500000
TOTAL422620620620620

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