Att 7 - TE 5.2 Projected Workload.xlsx

XLSX spreadsheet 69 KB Posted

Attached to
Distribution and Warehousing Services at DLA Distribution Cherry Point, NC Federal contract opportunity
Solicitation number
SP3300-24-R-5003
Issued by
Defense Logistics Agency Distribution

About this file

Written by GovTribe AI ·

This document appears to be an attachment related to the performance requirements for a federal contract opportunity for distribution and warehousing services at DLA Distribution Cherry Point, North Carolina.

The attachment provides detailed projected workload data and performance metrics across various categories including receipts, issues, storage, inventory, transportation, and packaging for the 5-year contract period. Key details include projected receipt and issue volumes by weight band, additional requirements for controlled, hazardous, and frustrated material, storage capacity, inventory processes, shipment preparation, and packaging activities. The attachment contains granular data at the line item and monthly level to support the overall performance requirements for the distribution center operations. This information would be critical for offerors to understand the scope and scale of the services required under the contract.

View the file

Other files for this federal contract opportunity

Other files attached to Distribution and Warehousing Services at DLA Distribution Cherry Point, NC, newest first.
File Type Posted
Att 2 - Solicitation Conformed 8-21-24.pdf PDF
Att 1 - Solicitation Tracked 0010 8-21-24.docx DOCX document
0008 Att 1 Schedule.pdf PDF
Amendment 0008 SF30 SP330024R5003.pdf PDF
Att 3 0007 Applicable DSS Roles.pptx PPTX presentation
Att 2 0007 TE 2.1.1 WMS to DSS Crosswalk.pdf PDF
Amendment 0007 SF30 SP330024R5003.pdf PDF
Att 2 - Solicitation tracked 0005.docx DOCX document
Att 8 TE 5.0 APLs Conformed 0005.docx DOCX document
Att 7 TE 5.0 APLs Tracked 0005.docx DOCX document
Att 4 - J.1 PWS Tracked 0005.docx DOCX document
Att 1 - Questions and Answers 0005.docx DOCX document
Att 6 TE 5.2 Projected Workload 0005.xlsx XLSX spreadsheet
Att 5 - J.1 PWS Conformed 0005.docx DOCX document
Att 3 - Solicitation Conformed 0005.pdf PDF
Amendment 0005 SF30 SP330024R5003.pdf PDF
Att 10 - Solicitation conformed.pdf PDF
Att 5 - TE 5.0 APLs conformed.docx DOCX document
Att 3 - J.1 PWS conformed.docx DOCX document
Att 11 - DDCN SSMR Dec 2023.xlsx XLSX spreadsheet
Att 9 - Solicitation tracked changes.docx DOCX document
Att 8 - DLA DD254 Cont Page.docx DOCX document
Att 2 - J.1 PWS tracked change.docx DOCX document
Att 6 - TE 5.1 Historical Workload.docx DOCX document
Att 4 - TE 5.0 APLs tracked changes.docx DOCX document
Amendment 0004 SF30 SP330024R5003.pdf PDF
Att 1 - Questions and Answers.docx DOCX document
Amendment 0003 SF30 SP330024R5003.pdf PDF
Amendment 0002 SF30 SP330024R5003.pdf PDF
DDCN PPC Attendance 23 Aug 2024 (Day 1).pdf PDF
DDCN PPC Slide Deck_Final 4-23-2024 JCD Rev 1.pptx PPTX presentation
Att 1 Conformed Solicitation 0002.pdf PDF
Att 2 Conformed Solicitation 0001.pdf PDF
Att 1 Section M - Tracked Changes 0001.pdf PDF
Att 3 J.13 DDCN Preproposal Conference Instructions.pdf PDF
Amendment 0001 SF30 SP330024R5003.pdf PDF
J.12 Contractor Equipment List 24R5003.xlsx XLSX spreadsheet
J.10 Accounting System Self-Certification.pdf PDF
J.6 CLIN X006 Labor Rate Table.xlsx XLSX spreadsheet
J.3 WD 2015-5781 Rev 22.pdf PDF
J.2 DDCN 24R5003.docx DOCX document
J.5 DD254 DDCN SP330024R5003.pdf PDF
J.4 DDCN CBA.pdf PDF
J.11 Limitation on Subcontracting.xlsx XLSX spreadsheet
J.8 PPQ.docx DOCX document
J.7 Tech Exhibits.zip ZIP file
J.5 DLA DD254 Continuation Page Template_SP3300-24-R-5003.docx DOCX document
J.1 DDCN PWS 24R5003.docx DOCX document
J.9 CDRLs.zip ZIP file
SP3300-24-R-5003 DDCN RFP.pdf PDF
Show all 50

Distribution and Warehousing Services at DLA Distribution Cherry Point, NC 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

WHOLESALEDDCN Projected TE24R5003May '24DDCN
Overall Receipt and Issue Workload Projections – Lines
SourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
ReceiptsSite & Historical59,12660,25261,05561,87262,703
IssuesSite & Historical231,286241,007244,220247,488250,809
Total Workload290,412301,259305,276309,360313,5120
Overall Receipt and Issue Monthly Workload Projections –Year 1 (9 mo) Lines (August 2025 through April 2026)
Receipts (91140)Issues (92440)Total (98400)
Monthly Receipts%Monthly Issues%Total Monthly Receipts & Issues
May
June
July
August6,44510.90%25,21010.90%24,628
September6,34410.73%24,81710.73%24,244
October7,11312.03%27,82412.03%27,181
November6,19010.47%24,21610.47%23,656
December6,22610.53%24,35410.53%23,792
January6,66911.28%26,08911.28%25,486
February6,44510.90%25,21010.90%24,628
March6,97111.79%27,26911.79%26,639
April6,72311.37%26,29711.37%25,690
Total59,126100.00%231,286100.00%225,944
*Note percentage figures in this table were calculated using the actual receipt and issue figures realized during FY24.
C-5.2 Receiving
Measurement in Lines
Weight BandsSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Weight Band 1Site & Historical44,02945,18245,78446,39647,01963,029
Weight Band 2Site & Historical8,3536,0286,1086,1906,2737,737
Weight Band 3Site & Historical5,9776,0286,1086,1906,2734,833
Weight Band 4Site & Historical4853,0083,0483,0893,131241
Rewarehouse Stow at Depot after Pick at RetailSite & Historical28200000
RDOs w/ Special ProjectSite & Historical000000
TOTAL RECEIPTS59,12660,25261,05561,87262,70375,840
Estimated Receipt Percentage of Quantity per Line - Year 1 (9 mo)
QuantityTotal LinesTotal Lines by Weight Band%
(Number of Individual Receipts processed per line)Weight Band 1Weight Band 2Weight Band 3Weight Band 4
133,27625,7803,7591,8521,88556.28%
2 to 911,8198,5281,98663267319.99%
10 to 193,9852,9595022502746.74%
20 to 291,8681,4871651041123.16%
30 to 491,8211,4401641041133.08%
50 to 992,0631,5902171241323.49%
100+4,2933,3554072652667.26%
TOTAL59,12645,1397,2003,3313,455100.00%
C-5.2.4.1 Supply Discrepancy Reports (SDR) (Type 8 or 9)
Measurement is Each
Type DiscrepancySourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
All InclusiveQMF Query6,7729,0299,0299,0299,029
C-5.2.4.2 New Procurement Receipts
Measurement is Lines
Weight BandsSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Weight Band 1N/A9,21511,26911,41911,57211,727
Weight Band 2N/A2,5011,7011,7241,7471,771
Weight Band 3N/A1,236913926938950
Weight Band 4N/A12989909193
Total New Procurement13,08113,97214,15914,34814,541
C-5.2.4.2 Customer Return Receipts
Measurement is Lines
Weight BandsSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Weight Band 1N/A7,7688,5378,6538,7668,885
Weight Band 2N/A8201,2891,3051,3241,341
Weight Band 3N/A873692701711720
Weight Band 4N/A83567686970
Total Customer Returns10,29610,58510,72710,87011,01612,727
C-5.2.4.2 Redistributions Receipts
Measurement is Lines
Weight BandsSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Weight Band 1N/A26,86128,78729,17029,56129,957
Weight Band 2N/A5,0214,3464,4044,4624,523
Weight Band 3N/A2,1342,3332,3642,3962,428
Weight Band 4N/A213227231234237
Total Redistributions34,22835,69336,16936,65337,14545,637
C-5.2.5 Additional Receipt Requirements (Value Added Lines)
SourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Controlled MaterialSite & Historical1011111111
Hard to HandleSite & Historical25,51620,02820,29520,56620,842
Hazardous Material (HAZMAT)Site & Historical5745464647
Frustrated MaterialSite & Historical20,08916,63616,85817,08417,31317,313
Misdirected MaterialSite & Historical000000
Receipts Lost In-TransitSite & Historical631662670679688688
Magnetic MaterialSite & Historical011111
C-5.2.5.14M MATERIAL TURNED INTO STORE (MTIS)
Measurement is Each
MPC LinesSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
DLRs w/ Project Code Z5S185244244244244247
CIIC w/Project Code Z5T124949494916
Consumables >$2500 w/Project Code Z5U1,7341,9771,9771,9771,9772,312
Consumables < $2500 w/Project Code Z5V5889889889889877
All Other w/o PMRD w/Project Code Z5W6855555555555590
Total MTIS Workload2,0573,7233,7233,7233,7232,742
C-5.3 Storage (as of Feb 2024, includes both wholesale and retail locations and empty locations)
SourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Locations (formerly NSNs)Site133,967178,623178,623178,623178,623
C-5.3.1 Stow of Receipts
Measurement in Lines
Weight BandsSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Weight Band 1Site & Historical37,73945,18245,78446,39647,019
Weight Band 2Site & Historical7,1606,0286,1086,1906,273
Weight Band 3Site & Historical5,1236,0286,1086,1906,273
Weight Band 4Site & Historical4163,0083,0483,0893,131
Rewarehouse StowSite & Historical2820000
TOTAL STOWS50,72060,25261,05561,87262,703
C-5.3.3 Care of Supplies in Storage (COSIS)
Measurement is Each
SourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Visual InspectionsSite & Historical9,5653,2133,2133,2133,213
Shelf Life (Cyclic)Site & Historical301401401401401
Special InspectionsSite & Historical7,2059,6079,6079,6079,607
Quality Inspections00000
C-5.3.7 Rewarehousing
Measurement is Each
SourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Locations RewarehousedSite & Historical25,82322,82322,82322,82322,823
C-5.3.8 Issue of Material
On-Base IssuesSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Weight Band 1Site & Historical83,89959,09159,87960,68061,494
Weight Band 2Site & Historical2,6682,0762,1042,1322,160
Weight Band 3Site & Historical2,3071,2391,2551,2721,289
Weight Band 4Site & Historical16233343435
TOTALSite & Historical89,03662,43963,27264,11864,978
Off-Base IssuesSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Weight Band 1Site & Historical114,998131,543133,294135,081136,892153,331
Weight Band 2Site & Historical2,4383,3483,3933,4383,4843,250
Weight Band 3Site & Historical1,2861,5601,5811,6021,6231,715
Weight Band 4Site & Historical293334343539
TOTALSite & Historical118,751136,484138,302140,155142,034158,335
Transshipments Off-BaseSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Weight Band 1Site & Historical2,5083,2053,2483,2923,336
Weight Band 2Site & Historical654836847858870
Weight Band 3Site & Historical695888900912924
Weight Band 4Site & Historical365467473479486
TOTALSite & Historical4,2235,3965,4685,5415,616
Transshipments - On-BaseSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
NLC Trans On-Base (Gov Perf, SP Deliver)Site & Historical7,4329,4969,6239,7519,882
MPC Trans On-BaseSite & Historical00000
DROsSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Weight Band 1Site & Historical3,5394,5234,5834,6444,707
Weight Band 2Site & Historical455581589597605
Weight Band 3Site & Historical293372377382387
Weight Band 4Site & Historical2633343435
TOTALSite & Historical4,3115,5095,5835,6575,734
RewarehousingSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Picks (at Depot for Stow at Retail )Site & Historical20,25321,68321,97222,26622,565
TOTAL ISSUES228,002241,007244,220247,488250,809

C-5.3.9 Additional Issue Requirements (Value Added Lines)

SourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Controlled MaterialSite & Historical13,16616,59616,81717,04217,27117,554
Hard to HandleSite & Historical19,99725,20325,53925,88126,22826,662
Hazardous Material (HAZMAT)Site & Historical9231,0111,0241,0381,0521,231
Frustrated MaterialSite & Historical000000
Misdirected MaterialSite & Historical000000
Receipts Lost In-TransitSite & Historical000000
Magnetic MaterielSite & Historical000000
C-5.3.12 Shipment Preparation Includes Delivery of Gov Performed On-Base Transshipment
Off-Base Issues & Off-Base TransshipmentsSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
WB1Site & Historical100,720134,748136,542138,373140,228
WB2Site & Historical2,6504,1844,2404,2964,354
WB3Site & Historical1,6982,4482,4812,5142,547
WB4Site & Historical338500507513521
TOTAL105,406141,880143,770145,696147,650
C-5.4 Physical Inventory is Inclusive of Retail Locations
C-5.4.3 Execute Inventory Counts
Measurement is Each
SourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
1st Count Inventories (including unoccupied locations)Total Locations133,967178,623178,623178,623178,623133967
2nd Count Inventories% Est to go to 2nd Count20,09524,09721,48519,33717,4040
Classified, Pilferable, Sensitive, Controlled InventoriesCIIC Codes1,6011,6011,6011,6011,601
C-5.4.4 and C-5.4.5 Inventory Adjustment Review and Recordation/Causative Research/Pre-Adjustment Research
Measurement is Each
SourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Adjustment Review and Recordation/Causative Research/Pre-Adjustment Research50% of 2nd Counts11,89112,04910,7439,6698,702
C-5.4.6 Denial Research
Denial Research13,58121,12621,40821,69421,985
C-5.4.9 Exception Discrepancy Research and Resolution
Measurement is Each
SourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Exception R&R (COSIS Only)QMF Query1,8752,5002,5002,5002,500
C-5.5.2 Traffic Management and C-5.5.3 Shipping
Measurement is Each
Off-Base Issues & Off-Base TransshipmentsSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
WB1N/A100,720134,748136,542138,373140,228
WB2N/A2,6504,1844,2404,2964,354
WB3N/A1,6982,4482,4812,5142,547
WB4N/A338500507513521
TOTALN/A105,406141,880143,770145,696147,650
C-5.5.5 Security Assistance Program (SAP): Foreign Military Sale (FMS) and Grant Aid
Measurement is Each
SourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
FMSSite & Historical7,2326,8516,9427,0357,129
C-5.5.6 Additional Traffic Management/Transportation Requirements (Value Added Lines)
SourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Controlled MaterialN/A12,44716,59616,81717,04217,271
Hard to HandleN/A18,90225,20325,53925,88126,228
Hazardous Material (HAZMAT)N/A7581,0111,0241,0381,052
Frustrated MaterialN/A00000
Misdirected MaterialN/A00000
Receipts Lost In-TransitN/A00000
C-5.6.1 Preservation, Packaging and Marking (PPP&M)
Measurement is Each
RepackagedSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
X-SmallSite & Historical143,678114,222115,752117,299118,873438,623
SmallSite & Historical19,34329,96330,36430,77031,18364,110
MediumSite & Historical5,7656,3146,3986,4846,5719,415
LargeSite & Historical2,2043,1493,1913,2343,2774,115
X-LargeSite & Historical1,2721,0181,0311,0451,0591,144
XX-LargeSite & Historical2,4804,3744,4324,4914,5522,282
TOTAL174,742159,040161,168163,323165,515519,689
C-5.6.2 Packaging Remarks (PPP&M)244,302
Measurement is Each
Packages Remarked OnlySourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Total RemarksSite & Historical54,65554,65554,65554,65554,655
C-5.6.3 Container Fabrication Support277
Measurement is Each by Type and Size1,472
SizeSourceYear 1 (9mo)Year 2Year 3Year 4Year 51,569
X-SmallSite208277281285289
SmallSite1,1041,4721,4921,5121,532
MediumSite1,1771,5681,5891,6101,632
LargeSite268357362367372
X-LargeSite155207209212215
XX-LargeSite375500507513520
Fiberboard ContainersSite3,2864,3814,4404,4994,560
Other Type ContainersSiteN/AN/AN/AN/AN/A

RETAIL DDCM Projected TE

Barr, George William III CIV DLA DISTRIBUTION (USA): Barr, George William III CIV DLA DISTRIBUTION (USA):

Will need Locations vice NIINs.C-5.3.1 Stow of Receipts
Measurement in Lines
Weight BandsSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Weight Band 1Site5,9748,0728,1808,2898,401
C-5.3.3M Care of Supplies in Storage (COSIS)3,826
Measurement is Each
SourceYear 1 (9 mo)Year 2Year 3Year 4Year 514,429
Visual InspectionsSite3,3753,8273,8273,8273,827
Shelf Life (Cyclic)Site231308308308308
Special InspectionsSite10,82214,42814,42814,42814,428
Quality InspectionsSite00000
2,404
C-5.3.8M Issue of Material52
Off-Base IssuesSourceYear 1 (9 mo)Year 2Year 3Year 4Year 516
Weight Band 1Site1,8034,8394,9054,9705,037
Weight Band 2Site39932944957969
Weight Band 3Site12184186189191
Weight Band 4Site4108109111112
TOTALSite1,8586,0636,1446,2276,309
DROsSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5172
Weight Band 1Site8,5537,3327,4307,5297,631
Weight Band 2Site187160162164167
Weight Band 3Site129111112114115
Weight Band 4Site87777
TOTALSite8,8777,6107,7117,8147,920
C-5.3.12M Shipment Preparation
Off-Base Issues & Off-Base TransshipmentsSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
WB1N/A1,5454,8394,9054,9705,037
WB2N/A33932944957969
WB3N/A10184186189191
WB4N/A3108109111112
TOTALN/A1,5926,0636,1446,2276,309
C-5.5.2M Traffic Management and C-5.5.3M Shipping
Measurement is Each
Off-Base Issues & Off-Base TransshipmentsSourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
WB1Site & Historical1,5454,8394,9054,9705,037
WB2Site & Historical33932944957969
WB3Site & Historical10184186189191
WB4Site & Historical3108109111112
TOTALSite & Historical1,5926,0636,1446,2276,309
C-5.5.5M Security Assistance Program (SAP): Foreign Military Sale (FMS) and Grant Aid168
Measurement is Each
SourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
FMSSite & Historical126168170173175
C-5.6.1M Preservation, Packaging and Marking (PPP&M)13,968
Measurement is Each484
RepackagedSourceYear 1 (9 mo)Year 2Year 3Year 4Year 582
X-SmallSite & Historical4,0556,8236,9147,0077,10116
SmallSite & Historical13164565366267115
MediumSite & Historical191,5221,5421,5631,58476
LargeSite & Historical020620921221414,641
X-LargeSite & Historical0192195197200
XX-LargeSite & Historical524242425
TOTAL4,2099,4129,5379,6659,795
C-5.6.2M Packaging Remarks (PPP&M)315,529
Measurement is Each
Packages Remarked OnlySourceYear 1 (9 mo)Year 2Year 3Year 4Year 5
Total RemarksSite & Historical51,08858,38759,16559,95760,761

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