Attachment J.25,TE 5.2 Projected Workload DDBC for final RFP.docx

DOCX document 76 KB Posted

Attached to
Distribution and Warehousing Services at DLA Distribution Bartstow, CA Federal contract opportunity
Solicitation number
SP3300-21-R-5008
Issued by
Defense Logistics Agency Distribution

About this file

Written by GovTribe AI ·

This document contains a technical exhibit and projected workload for a federal contract opportunity to provide distribution and warehousing services at the Defense Logistics Agency Distribution facility in Barstow, California. The technical exhibit outlines the contractor's required workload over five one-year performance periods and includes projections for receipt and storage activities, inventory management, physical counts, packaging, and issue of materials both on- and off-base. Key services involve receiving, storing, inventory control, stock selection, packaging, shipping, and distribution of repair parts and supplies. The federal contract opportunity notices a solicitation for these services under solicitation number SP3300-21-R-5008 with a 100% small business 8(a) set-aside. The period of performance is five years from July 2022 to June 2027 including a 90-day transition. The estimated award date is June 2022. The incumbent contractor is Technica, LLC under contract SP3300-17-D-5002 expiring September 2022.

View the file

Other files for this federal contract opportunity

Other files attached to Distribution and Warehousing Services at DLA Distribution Bartstow, CA, newest first.
File Type Posted
RFP SP3300-21-R-5008 Sections B - M (updated 10.4.21).pdf PDF
Amendment 0004 Questions.docx DOCX document
RFP SP3300-21-R-5008 Sections B - M 9.29.21.pdf PDF
Attachment J.11 CDRLs.zip ZIP file
TE 4.4.5.1M Custodial Services.v4.docx DOCX document
Attachment J.25,TE 4.5 Other Equip PM Task Codes.xlsx XLSX spreadsheet
SF-30 SP3300-21-R-5008 Amendment 0002.pdf PDF
RFP SP3300-21-R-5008 Sections B - M 9.21.21.pdf PDF
SP330021R5008_ Questions Responses 9.21.21.docx DOCX document
Attachment J.1 Performance Work Statement Amend 002.docx DOCX document
Attachment J.32 TE 4.6 Contractor Furnished Equipment.doc DOC document
Attachment J.38 Staffing Matrix Amendment 002.xlsx XLSX spreadsheet
DDBC Pre-Proposal Conference Attendee List.pdf PDF
Attachment J.20,TE 4.2 Gov Oper Equip for Ctr Maint.xlsx XLSX spreadsheet
SF-30 SP3300-21-R-5008 Amendment 0001 2 of 2.pdf PDF
DLA Barstow SP330021R5008_ Questions Responses.docx DOCX document
Attachment J.32, Contractor Furnished Equipment.doc DOC document
Attachment J.17 TE 3.3 Government Data Systems.docx DOCX document
Attachment J.1 Performance Work Statement.docx DOCX document
CDRL A006 - Quality Control Plan with Attachments.pdf PDF
Attachment J.3 - Technica CBA - DLA Barstow FE.pdf PDF
SF33 SP330021R5008.pdf PDF
Attachment J.6 CLIN X006 Labor Rate Table.xlsx XLSX spreadsheet
Attachment J.17 TE 3.3 Government Data Systems.docx DOCX document
Attachment J.29 TE 5.4 Transshipment of Hazardous Assets.rtf RTF text file
Attachment J.30 TE 5.5 Type Physical Inventory Code (TPIC) Matrix.docx DOCX document
Attachment J.18 TE 3.4 GE - MHE.xls XLS spreadsheet
Attachment J.20,TE 4.3 MHE PM Task Codes.xlsx XLSX spreadsheet
Attachment J.22 TE 4.1 Contractor Training.docx DOCX document
Attachment J.36 TE 5.9 DSS Program Loading Data.docx DOCX document
Attachment J.39 Training Plan.xlsx XLSX spreadsheet
Attachment J.40 DDBC DRAFT Training Schedule July-September 2022.xlsx XLSX spreadsheet
Attachment J.42 Past Performance Questionnaire.docx DOCX document
RFP SP3300-21-R-5008 Sections B - M.pdf PDF
Attachment J.1 Performance Work Statement.docx DOCX document
Attachment J.2.docx DOCX document
Attachment J.11 CDRLs.pdf PDF
Attachment J.13 TE 1.2 CAC_Procedures (2021 Version).docx DOCX document
Attachment J.13, TE 1.2 CAC Procedures.docx DOCX document
Attachment J.14 TE 2.1 Definitions, Acronyms, and Abbreviations.docx DOCX document
Attachment J.28 TE 5.2 Projected Workload DDBC April 2021 updated.docx DOCX document
Attachment J.22, TE 4.1 Contractor Training.docx DOCX document
Attachment J.5 DD254 DDBC SP3300-21-R-5008.pdf PDF
Attachment J.16 TE 3.2 Government Training.docx DOCX document
Attachment J.24,TE 4.3 MHE PM Task Codes.xlsx XLSX spreadsheet
Attachment J.19 TE 3.5 GE - Misc.xls XLS spreadsheet
Attachment J.22,TE 4.5 Other Equip PM Task Codes.xlsx XLSX spreadsheet
Attachment J.37 TE 6.1 Government Forms.docx DOCX document
Attachment J.38 Staffing Matrix 7 July.xlsx XLSX spreadsheet
Attachment J.41, Limitation on Subcontracting Report.xls XLS spreadsheet
Show all 50

Distribution and Warehousing Services at DLA Distribution Bartstow, CA 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.

WHOLESALE WORKLOAD

C 5.1 Overall Projected Receipts and Issues

Y1 (9mo)
Y2
Y3
Y4
Y5
Total Receipts
18,010
25,823
25,728
25,660
25,840
Total Issues
51,018
73,158
72,882
72,689
73,199
Total
69,028
98,981
98,610
98,349
99,039

C-5.2 RECEIVING

Measurement in Lines

NLC Weight Bands By Lines
Y1 (9mo)
Y2
Y3
Y4
Y5
Weight Band 1
10,398
14,907
14,854
14,814
14,918
Weight Band 2
3,502
5,022
5,003
4,990
5,025
Weight Band 3
3,576
5,128
5,108
5,095
5,131
Weight Band 4
534
766
763
761
766
REW STOWs
0
0
0
0
0
Total Receipts
18,010
25,823
25,728
25,660
25,840

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

Y1 (9mo)
Y2
Y3
Y4
Y5
Return Lines
14%
13%
13%
13%
13%
Hazardous Lines
0.3%
0.2%
0.2%
0.2%
0.2%
Hard to Handle
3%
3%
3%
3%
3%

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
10,417
6,014
2,026
2,070
309
58%
2 to 9
2,887
1,666
561
573
86
16%
10 to 19
1,032
596
200
205
30
6%
20 to 29
666
385
130
132
20
4%
30 to 49
575
332
110
114
17
3%
50 to 99
698
403
137
136
21
4%
100+
1,735
1,002
338
346
51
10%
Totals
18,010
8,212
3,502
3,576
534
100%

C-5.2.4.1 SUPPLY DISCREPANCY REPORTS (SDR) (Type 8 or 9)

Measurement is Each

Type Discrepancy
Y1 (9mo)
Y2
Y3
Y4
Y5
All Inclusive
1,413
1,888
1,888
1,888
1,888

C-5.2.4.2 NON-PROCUREMENT (CUSTOMER RETURNS AND REDISTRIBUTION ORDERS) 5.2.4.3 NEW PROCUREMENT

Percent of Total Receipt Workload

New Procurement
23%
Customer Returns
18%
Redistributions
59%

C-5.3 Warehousing (As of the last day of the FY)

Y1 (9mo)
Y2
Y3
Y4
Y5
NSNs in Wholesale Storage
20,199
20,199
20,199
20,199
20,199

NOTE: NSNs could vary from year to year as a result of SKU (Stock Keeping Unit) changes

C-5.3.3 COSIS

Measurement is Each

Y1 (9mo)
Y2
Y3
Y4
Y5
Visual Inspections
7,902
10,536
10,536
10,536
10,536
Special Inspections
756
1,004
1,004
1,004
1,004
Cyclic Inspections
90
120
120
120
120
Quality Inspections
72
90
90
90
90

NOTE: Inspections will change in coordination with NSN changes

C 5.3.8 NLC ISSUE WORKLOAD

On-Base Issues
Y1 (9mo)
Y2
Y3
Y4
Y5
Weight Band 1
8,774
12,581
12,534
12,501
12,589
Weight Band 2
714
1,024
1,020
1,017
1,024
Weight Band 3
484
694
691
690
694
Weight Band 4
24
34
34
34
34
TOTAL
9,996
14,333
14,279
14,242
14,341
Off-Base Issues
Y1 (9mo)
Y2
Y3
Y4
Y5
Weight Band 1
24,672
35,378
35,245
35,152
35,399
Weight Band 2
3,338
4,786
4,769
4,756
4,789
Weight Band 3
2,426
3,479
3,466
3,456
3,481
Weight Band 4
430
617
614
613
617
TOTAL
30,866
44,260
44,094
43,977
44,286
Transshipments-Off-Base
Y1 (9mo)
Y2
Y3
Y4
Y5
Weight Band 1
3,442
4,936
4,917
4,904
4,938
Weight Band 2
1,092
1,566
1,560
1,556
1,567
Weight Band 3
1,124
1,612
1,606
1,601
1,613
Weight Band 4
1,474
2,114
2,106
2,100
2,115
TOTAL
7,132
10,228
10,189
10,161
10,233
Transshipments On Base
1,064
1,526
1,520
1,516
1,527
NLC DROs
Y1 (9mo)
Y2
Y3
Y4
Y5
Weight Band 1
1,384
1985
1,977
1,972
1,986
Weight Band 2
232
333
331
331
333
Weight Band 3
242
347
346
345
347
Weight Band 4
102
146
146
145
146
TOTAL
1,960
2,811
2,800
2,793
2,812
Rewarehousing Picks for Retail
Y1 (9mo)
Y2
Y3
Y4
Y5
TOTAL
0
0
0
0
0
TOTAL NLC ISSUES
51,018
73,158
72,882
72,689
73,199

Value Added (VA) Lines (Depiction of extra effort to process these types of Issues within the above stated weight bands)

Measurement is Lines

Y1 (9mo)
Y2
Y3
Y4
Y5
Hazardous
200
266
265
265
265
Controlled Items
3,336
4,448
4,426
4,431
4,420
Hard to Handle Items
1,683
2,244
2,233
2,236
2,230
Local Delivery
6,913
9,217
9,172
9,183
9,158
Foreign Military Sales
904
1,205
1,199
1,201
1,197
Out of Cycle (Bearer Pick Up)
0
0
0
0
0
Out of Cycle
58
77
77
77
77
Redistributions (RDO/STO)
961
1,282
1,275
1,277
1,273
Retail MROs On-Base
2
3
3
3
3
Issues to Maintenance (On Base)
23
31
31
31
31
Issues to Maintenance (Off Base)
667
889
885
886
884

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
21,262
15,997
2,669
1,433
1,163
43%
2 to 9
16,133
12,138
2,025
1,088
882
32%
10 to 19
4,209
3,167
528
284
230
8%
20 to 29
2,031
1,528
255
137
111
4%
30 to 49
1,633
1,229
205
110
89
3%
50 to 99
1,718
1,293
216
116
94
3%
100+
2,718
2,045
341
183
149
5%
Totals
49,704
37,395
6,240
3,351
2,718
100%

C-5.4 PHYSICAL INVENTORY COUNTS

Inventories

Measurement is Number of Inventories Completed

Y1 (9mo)
Y2
Y3
Y4
Y5
TPIC “C” Inventories
3,600
4,800
4,800
4,800
4,800
TPIC “E” Inventories
1
1
1
1
1
TPIC “H” Inventories
1
4
4
4
4
TPIC “I” Inventories
0
0
0
0
0
TPIC “J” Inventories
0
0
0
0
0
TPIC “K” Inventories
1
4
4
4
4
TPIC “M” Inventories
9
14
14
14
14
TPIC “A” Inventories
0
0
0
0
0
TPIC “R” Inventories
7
8
8
8
8
TPIC “S” Inventories
0
0
0
0
0
TPIC “T” Inventories
90
121
121
121
121
TPIC “V” Inventories
91
107
107
107
107
TPIC “Z” Book to Book
2
6
6
6
6
Other or Blank TPIC
0
0
0
0
0

GOVERNMENT PERFORMED INVENTORIES

TPIC “D” Inventories
1,482
2,223
2,223
2,223
2,223
TPIC “G” Inventories
162
216
216
216
216
Y1 (9mo)
Y2
Y3
Y4
Y5
TPIC “L” Inventories
135
181
181
181
181
TPIC “N” Inventories
594
789
789
789
789
TPIC “P” Inventories
207
279
279
279
279

NOTE: Inventories will change in coordination with NSN changes NOTE: Government Performed Inventories may result in IAVs or CAVs that the Contractor shall complete. The workload is included in the IAV and CAV projections.

C-5.4.1 FLOOR TO BOOK WORK LOAD

Measurement is Each

Y1 (9mo)
Y2
Y3
Y4
Y5

Floor to Book

1684
2526
2526
2526
2526
2nd Floor to Book For Count Mismatches
168
253
253
253
253
TPIC M Inventories
19
28
28
28
28
3rd Counts
18
26
26
26
26
Causative Research
1
1
1
1
1
TOTAL
1889
2834
2834
2834
2834

NOTE: This data includes both wholesale and retail

C-5.4.1.2 RESEACH OF POTENTIAL OR ACTUAL PHYSCIAL INVENTORY ADJUSTMENTS

Measurement is Each

Y1 (9mo)
Y2
Y3
Y4
Y5
Causative Research
27
36
36
36
36
IERLs (3rd Count Inventories)
153
202
202
202
202

NOTE: Inventory Adjustments will change in coordination with NSN changes

C-5.4.4 LOCATION SURVEYS

Measurement is Each

Y1 (9mo)
Y2
Y3
Y4
Y5
Total Number of Locations
59,133
59,133
59,133
59,133
59,133
Location Surveys
902
1,202
1,202
1,202
1,202

NOTE: This can change from year to year

C-5.6 PACKAGING (PPP&M)

Measurement is Each

Repackaged
Y1 (9mo)
Y2
Y3
Y4
Y5
X-Small
21,090
22,145
23,252
23,205
23,136
Small
4,914
5,160
5,418
5,407
5,391
Medium
139
146
153
153
152
Large
384
403
423
422
421
X-Large
363
381
400
399
398
XX-Large
71
74
78
78
77
Total
26,961
28,309
29,724
29,664
29,575

C 5.6 Measurement is Each

Packages Remarked Only
Y1 (9mo)
Y2
Y3
Y4
Y5
Total Remarks
26,724
28,060
29,463
29,404
29,316

C-6.3 CONTAINER FABRICATION

Measurement is Each by Type and Size

Y1 (9mo)
Y2
Y3
Y4
Y5

Number of Wooden Containers Fabricated

Small
846
1,122
1,122
1,122
1,122
Medium
45
62
62
62
62
Large
0
0
0
0
0
X-Large
0
0
0
0
0
Fiberboard Containers
261
350
350
350
350
Other Type Containers
144
190
190
190
190

C-5.7.1 LOAD AND OFF-LOAD SUPPORT

Measurement is Each

Y1 (9mo)
Y2
Y3
Y4
Y5
Load/Off-Load Support
10,680 hrs
14,240 hrs
14,240 hrs
14,240 hrs
14,240 hrs

SP3300-16-R-5003

Attachment J.25 Technical Exhibit 5.2 Projected Workload (March 2016) for DDBC

TE 5.2

Projected Workload

RETAIL WORKLOAD

C-5.1 Overall Projected Receipt Stows and Issues

Y1 (9mo)
Y2
Y3
Y4
Y5
Total Receipts
37,839
48,806
48,565
48,625
48,496
Total Issues
181,404
243,610
242,403
242,696
242,054
Total
219,243
292,416
290,968
291,321
290,550

C-5.2 Stows

Measurement in Lines

NLC Weight Bands By Lines
Y1 (9mo)
Y2
Y3
Y4
Y5
Weight Band 1
32,293
41,737
41,530
41,582
41,472
Weight Band 2
3,051
3,875
3,856
3,861
3,850
Weight Band 3
2,256
2,876
2,862
2,865
2,858
Weight Band 4
239
318
317
317
316

REW STOWs

Total Receipts
37,839
48,806
48,565
48,625
48,496

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
8,827
4,588
1,986
1,120
1,132
18.08%
2 to 9
16,543
8,601
3,723
2,098
2,122
33.90%
10 to 19
7,163
3,724
1,612
909
919
14.68%
20 to 29
3,820
1,986
860
485
490
7.83%
30 to 49
3,146
1,635
708
399
404
6.45%
50 to 99
3,046
1,583
685
386
391
6.24%
100+
6,261
3,254
1,409
794
803
12.83%
Totals
48,806
25,371
10,983
6,191
6,261
100.00%

C-5.2.4.2 RETAIL 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
Y1 (9mo)
Y2
Y3
Y4
Y5
New Procurement
479
639
636
636
635
Customer Returns
38,137
50,849
50,597
50,659
50,525
Redistributions
0
0
0
0
0
Receipts from Maintenance
0
0
0
0
0
Serviceable Returns
0
0
0
0
0
Unserviceable Returns
6
8
8
8
8
Unit Cost Receipt Reversals
73
97
96
96
96
Hazardous Receipts
18
24
23
23
23
REW Stows
0
0
0
0
0

NOTE: Receipts may fall into multiple types above

C-5.3 RETAIL WAREHOUSING (As of the last day of the FY)

Y1 (9mo)
Y2
Y3
Y4
Y5
NSNs in Retail Storage
29,655
29,655
29,655
29,655
29,655

NOTE: NSNs could vary from year to year as a result of SKU (Stock Keeping Unit) changes

C-5.3 RETAIL COSIS

Measurement is Each

Y1 (9mo)
Y2
Y3
Y4
Y5
Visual Inspections
171
228
228
228
228
Special Inspections
567
752
752
752
752
Cyclic Inspections
414
546
546
546
546
Other Inspections
14
14
14
14
14

NOTE: Inspections will change in coordination with NSN changes.

C-5.4 RETAIL PHYSICAL INVENTORY COUNTS

Inventories

Measurement is Number of Inventories Completed

Base Period
Y2
Y3
Y4
Y5
TPIC “C” Inventories
459
607
607
697
607
TPIC “E” Inventories
0
0
0
0
0
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
846
1,128
1,128
1,128
1,128
TPIC “M” Inventories
81
105
105
105
105
TPIC “A” Inventories
0
0
0
0
0
TPIC “R” Inventories
0
0
0
0
0
TPIC “S” Inventories
0
0
0
0
0
TPIC “T” Inventories
0
0
0
0
0
TPIC “V” Inventories
27
32
32
32
32
TPIC “Z” Book to Book
414
546
546
546
546
Other or Blank TPIC
18
24
24
24
24

GOVERNMENT PERFORMED INVENTORIES

TPIC “D” Inventories
3,619
5,428
5,428
5,428
5,428
TPIC “G” Inventories
14
18
18
18
18
TPIC “L” Inventories
90
116
116
116
116
TPIC “N” Inventories
684
907
907
907
907
TPIC “P” Inventories
54
72
72
72
72

NOTE: Inventories will change in coordination with NSN changes

5.4.1.2 RETAIL RESEACH OF POTENTIAL OR ACTUAL PHYSCIAL INVENTORY ADJUSTMENTS

Measurement is Each

Y1 (9mo)
Y2
Y3
Y4
Y5
Causative Research
9
14
14
14
14
IERLs (3rd Count Inventories)
153
202
202
202
202

NOTE: Inventory Adjustments will change in coordination with NSN changes

C-5.4.4 RETAIL LOCATION SURVEYS

Measurement is Each

Y1 (9mo)
Y2
Y3
Y4
Y5
Total Number of Locations - Retail
53,949
53,949
53,949
53,949
53,949
Location Surveys
91
121
121
121
121

NOTE: This can change from year to year

C 5.3.8 RETAIL ISSUE WORKLOAD

On-Base Issues
Y1 (9mo)
Y2
Y3
Y4
Y5
Weight Band 1
167,560
225,145
224,028
224,298
223,706
Weight Band 2
5,740
7,655
7,617
7,627
7,606
Weight Band 3
3,210
4,281
4,260
4,265
4,253
Weight Band 4
217
290
289
289
288
TOTAL
176,727
237,371
236,194
236,479
235,853
Transshipments On Base
Y1 (9mo)
Y2
Y3
Y4
Y5
Other
28
38
38
38
38
NLC DROs
Y1 (9mo)
Y2
Y3
Y4
Y5
Weight Band 1
3,819
5,094
5,069
5,075
5,062
Weight Band 2
516
688
685
686
684
Weight Band 3
287
383
381
382
381
Weight Band 4
27
36
36
36
36
TOTAL
4,649
6,201
6,171
6,179
6,163
TOTAL NLC ISSUES
181,404
243,610
242,403
242,696
242,054

RETAIL ISSUE - Value Added (VA) Lines (Depiction of extra effort to process these types of Issues within the above stated weight bands)

Measurement is Lines

Y1 (9mo)
Y2
Y3
Y4
Y5
Hazardous
5,497
7,330
7,293
7,302
7,283
Controlled Items
5,172
6,896
6,862
6,871
6,852
Hard to Handle Items
0
0
0
0
0
186,166
248,222
246,992
247,292
246,638
Out of Cycle (Bearer Pick-up)
121,489
161,986
161,184
161,379
160,952
Out of Cycle
0
0
0
0
0
RDO Issues
0
0
0
0
0
Retail MROs on Base
192,449
256,599
255,328
255,638
254,962
Issues to Maintenance (On Base)
6
8
8
8
8
Issues to Maintenance (Off Base)
0
0
0
0
0

RETAIL - 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
92,142
70,323
12,411
5,343
4,065
37.82%
2 to 9
93,783
71,577
12,630
5,439
4,138
38.50%
10 to 19
22,011
16,799
2,965
1,276
971
9.04%
20 to 29
10,801
8,243
1,455
626
476
4.43%
30 to 49
6,919
5,281
932
401
305
2.84%
50 to 99
7,207
5,500
971
418
318
2.96%
100+
10,747
8,202
1,448
623
474
4.41%
Totals
243,610
185,925
32,812
14,126
10,747
100.00%

C-5.7.4.3M Line Side Stock (LSS) and C-5.7.4.4M Local Delivery Shipment Consolidation

Measurement is Each

Y1 (9mo)
Y2
Y3
Y4
Y5
LSS Documents
29,694
10,452
3,679
1,295
456
LSS Items
1,559,840
641,094
263,490
108,294
44,509
Local Delivery Shipment Consolidation Documents
95,918
109,618
123,318
137,018
150,718
Local Delivery Shipment Consolidation Items
255,617
281,179
309,291
340,220
374,242

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