Attachment J.28 TE 5.2 DDDC Projected Workload 3-19-2020.xlsx

XLSX spreadsheet 52 KB Posted Mar 20, 2020

Attached to: Warehousing Services at DLA Distribution San Diego, CA Federal contract opportunity
Solicitation number: SP3300-20-R-5001
Issued by: Defense Logistics Agency Distribution

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains workload projections to support a solicitation for warehousing services at the Defense Logistics Agency Distribution facility in San Diego, California. The solicitation seeks services including receiving, storing, preserving, packaging, and issuing wholesale and retail material across multiple commodity classes. Projected workloads are provided for receipt and issue transactions measured in lines and pounds by weight band, as well as inventory management tasks such as physical inventories, research, and location surveys. Additional services addressed include hazardous material handling, preservation, packaging and marking, traffic management, and foreign military sales. The workloads cover a five year period and are broken out by wholesale and retail requirements across the three supported sites.

View the file

Other files for this federal contract opportunity

Other files attached to Warehousing Services at DLA Distribution San Diego, CA, newest first.
File	Type	Posted
DDDC SP3300-20-R-5001 Questions 3.19.2020.docx	DOCX document	Mar 20, 2020
SP330020R5001 Amend 0007 3-16-2020.docx	DOCX document	Mar 16, 2020
DDDC SP3300-20-R-5001 Questions 3.11.2020 AF Responses.docx	DOCX document	Mar 13, 2020
Amendment 0006.pdf	PDF	Mar 13, 2020
Amendment 0004.pdf	PDF	Mar 3, 2020
Attachment J.2 Site Specific PWS 2-26-2020.docx	DOCX document	Feb 27, 2020
DDDC SP3300-20-R-5001 Questions 2.26.2020.docx	DOCX document	Feb 27, 2020
Amendment 0003.pdf	PDF	Feb 27, 2020
Attachment J.4 Wage Determination 2015-5635, Rev 12.pdf	PDF	Feb 27, 2020
DDDC Occupancy and Density report as of Jan 2020.pdf	PDF	Feb 6, 2020
Attachment J.2 Site Specific PWS 2-5-2020.docx	DOCX document	Feb 6, 2020
Attachment J.22, TE 4.1 Contractor Training 2-5-2020.docx	DOCX document	Feb 6, 2020
Amend 0001 Attachment J.2 DDDC PWS.docx	DOCX document	Jan 29, 2020
A031 - MPC Cargo Status Report Amend 0001.pdf	PDF	Jan 29, 2020
Amendment 0001.pdf	PDF	Jan 29, 2020
Attachment J.26 TE 5.0 APLs.doc	DOC document	Jan 29, 2020
A004 - MECSP 1.28.20.pdf	PDF	Jan 29, 2020
Attachment J.33, TE 5.6, Local Delivery and Pick Up Points.rtf	RTF text file	Jan 29, 2020
Physical Security v2.pdf	PDF	Jan 29, 2020
Final PPC Instructions DDDC Jan 2020 V1.pdf	PDF	Jan 3, 2020
A013 - Monthly Cost Report for Material Support CLIN.pdf	PDF	Dec 20, 2019
A015 - Monthly Cost Report for Special Projects and Surge and Sustainment CLIN.pdf	PDF	Dec 20, 2019
A006 - Quality Control Plan.pdf	PDF	Dec 20, 2019
Attachment J.26, TE 5.0 APLs.doc	DOC document	Dec 20, 2019
A009 - Management Plan (MCCP).pdf	PDF	Dec 20, 2019
A020 - Shipment to Restricted Country - Approval Necessary.pdf	PDF	Dec 20, 2019
A024 - Physical Security Plan.pdf	PDF	Dec 20, 2019
A036 - Local Delivery Refusal Log.pdf	PDF	Dec 20, 2019
A017 - Government Cargo Recovery Effort Program (GOCARE) Program.pdf	PDF	Dec 20, 2019
A001 - Transition Plan and Weekly Reports.pdf	PDF	Dec 20, 2019
Attachment J.18, TE 3.4 GE MHE.xlsx	XLSX spreadsheet	Dec 20, 2019
Attachment J.40 Draft Distribution Operations Training Schedule.xlsx	XLSX spreadsheet	Dec 20, 2019
A027 - Monthly Contractor Employee CAC Report.pdf	PDF	Dec 20, 2019
A004 - Surge, Sustainment, and Disaster Recovery Plan (SSDRP).pdf	PDF	Dec 20, 2019
A014 - Monthly Cost Report for Travel and Training CLIN.pdf	PDF	Dec 20, 2019
Attachment J.1 DDDC PWS.docx	DOCX document	Dec 20, 2019
Attachment J.4, Wage Determination San Diego, Ca.docx	DOCX document	Dec 20, 2019
Attachment J.35, TE 6.3N, MPC Home Ported Ships.rtf	RTF text file	Dec 20, 2019
Attachment J.36, TE 5.9 DSS Load and Maintain.docx	DOCX document	Dec 20, 2019
Attachment J.30, TE 5.5 Type Physical Inventory Code (TPIC) Matrix 07.02.2019.docx	DOCX document	Dec 20, 2019
Attachment J.13, TE 1.2 CAC Procedures.docx	DOCX document	Dec 20, 2019
A002 - SOH Plan and Reporting.pdf	PDF	Dec 20, 2019
A012 - Monthly Cost Rpt for Non-Capital Equip New or Replacement CLIN.pdf	PDF	Dec 20, 2019
A022 - RPO Quarterly Audit Checklist 9.25.19 (003).pdf	PDF	Dec 20, 2019
Attachment J.20 TE 3.6 GE Office Equipment.xlsx	XLSX spreadsheet	Dec 20, 2019
A037 - MPC Non-Delivery Log.pdf	PDF	Dec 20, 2019
A005 - Internal Order Number (ION) Reporting.pdf	PDF	Dec 20, 2019
Attachment J.42, Past Performance Questionnaire.docx	DOCX document	Dec 20, 2019
Attachment J.14, TE 2.1 Definitions, Acronyms, and Abbreviations.docx	DOCX document	Dec 20, 2019
A003 - Electrostatic Discharge (ESD) Control Program.pdf	PDF	Dec 20, 2019

Show all 50

Warehousing Services at DLA Distribution San Diego, 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.

Sheet1

WHOLESALE WHOLESALE WHOLESALE
Overall Receipt and Issue Workload Projections – Lines
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Receipts	91140	57,977	93,778	93,643	93,205	93,196
Issues	92440	464,816	608,068	607,194	604,356	604,296
Total Workload	98400	522,793	701,846	700,837	697,561	697,492

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
June	7,315	12.63%	58,646	12.63%	65,961
July	6,938	11.97%	55,625	11.97%	62,563
August	6,989	12.05%	56,030	12.05%	63,019
September	6,206	10.70%	49,755	10.70%	55,961
October	6,304	10.87%	50,543	10.87%	56,847
November	6,084	10.49%	48,776	10.49%	54,860
December	5,698	9.83%	45,685	9.83%	51,383
January	5,948	10.26%	47,685	10.26%	53,633
February	6,495	11.20%	52,071	11.20%	58,566
Total	57,977	100.00%	464,816	100.00%	522,793
*Note: Percentage figures in this table were calculated using the projected receipt and issue figures realized during Oct'19-Feb'19.

C-5.2 Receiving
Measurement in Lines
Weight Bands	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	13001 + 61301	44,800	74,532	74,425	74,077	74,069
Weight Band 2	13002 + 61302	7,586	11,588	11,571	11,517	11,516
Weight Band 3	13003 + 61303	5,060	7,022	7,012	6,979	6,979
Weight Band 4	13004 + 61304	529	636	635	632	632
Rewarehouse Stow at wholesale after Pick at Retail	40225	2	0	0	0	0
RDOs w/ Special Project	12960	0	0	0	0	0
Total Receipts	91140	57,977	93,778	93,643	93,205	93,196

Quantity	Total Lines	Total Lines by Weight Band				%
(Number of Individual Receipts processed per line)		Weight Band 1	Weight Band 2	Weight Band 3	Weight Band 4
1	52,904	38,276	6,004	4,021	4,603	56.41%
2 to 9	19,704	14,256	2,236	1,498	1,714	21.01%
10 to 19	5,955	4,308	676	453	518	6.35%
20 to 29	2,979	2,155	338	226	259	3.18%
30 to 49	3,105	2,181	342	229	262	3.21%
50 to 99	3,178	2,300	361	242	277	3.39%
100+	6,044	4,373	686	459	526	6.45%
Total	93,778	67,849	10,642	7,128	8,159	100.00%

C-5.2.4.1 Supply Discrepancy Reports (SDR) (Type 8 or 9)
Measurement is Each
Type Discrepancy	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
All Inclusive	QMF Query	5,629	7,505	7,505	7,505	7,505

C-5.2.4.3 New Procurements
Measurement in Lines
Weight Bands	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	N/A	6,945	11,554	11,537	11,483	11,482
Weight Band 2	N/A	1,176	1,796	1,794	1,785	1,785
Weight Band 3	N/A	784	1,089	1,087	1,082	1,082
Weight Band 4	N/A	82	99	98	98	98
Total	12103	8,987	14,537	14,516	14,448	14,447
Note: Based on J7's formula.

5.2.4.2 Customer Return Receipts
Measurement is Lines
Weight Bands	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	N/A	5,813	9,671	9,657	9,612	9,611
Weight Band 2	N/A	984	1,504	1,501	1,494	1,494
Weight Band 3	N/A	657	911	910	906	906
Weight Band 4	N/A	69	83	82	82	82
Total	12102	7,523	12,168	12,150	12,094	12,092
Note: Based on J7's formula.

5.2.4.2 Non-Procurement Receipts (Redistributions Receipts)
Measurement is Lines
Weight Bands	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	N/A	11,379	18,930	18,903	18,814	18,812
Weight Band 2	N/A	1,927	2,943	2,939	2,925	2,925
Weight Band 3	N/A	1,285	1,783	1,781	1,773	1,773
Weight Band 4	N/A	134	162	161	161	161
Total	12101	14,725	23,818	23,784	23,672	23,670
Note: Based on J7's formula.

Additional Receipt Requirements -Value Added ((Depiction of extra effort to process these types of Receipts)
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Receipts from Maintenance	10402	6,702	10,841	10,826	10,775	10,774
Serviceable Returns	10802	571	924	923	918	918
Unserviceable Returns	10302	6,633	10,729	10,714	10,664	10,663
Unit Cost Receipt Reversals	12950	53	85	85	85	85
Hazardous Receipts	11703+60370+60297	200	324	324	322	322
Manual Count Receipts	91200	8	13	13	13	13
Rewarehouse STOWs	40225	1	2	2	2	2
Total Receipts	91140	14,169	22,919	22,886	22,779	22,777
Note: Receipts may fall into multiple types above. Not all receipts are captured in Weight Bands.

C-5.2.5 Additional Receipt Requirements
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Controlled Material	30660	464	619	619	619	619
Hard to Handle	13012 + 61312	10,964	14,618	14,618	14,618	14,618
Hazardous Material (HAZMAT)	13011 + 61311	194	466	466	466	466
Frustrated Material	10302	6,422	15,413	15,413	15,413	15,413
Misdirected Material	30104	0
Receipts Lost In-Transit Unit Cost Receipt Reversals	12950	51	122	122	122	122
Magnetic Material	SAS Query	2	2	2	2	2

C-5.2.6N MATERIAL TURNED INTO STORE (MTIS)
Measurement is Each
MTIS Lines	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5

DLRs w/ Project Code Z5S	14002	2	2	2	2	2
CIIC w/Project Code Z5T	14102	38	50	50	50	50
Consumables >$2500 w/Project Code Z5U	14202	551	734	734	734	734
Consumables < $2500 w/Project Code Z5V	14302	2,907	3,876	3,876	3,876	3,876
All Other w/o PMRD w/Project Code Z5W	14402	4	5	5	5	5
Total MTIS Workload		3,501	4,668	4,668	4,668	4,668

Overall MTIS Receipts (Navy Returns) Monthly Workload Projections – Lines (June 2020 through February (2021)
Receipts	Receipts
	Monthly Receipts	%
June	341	9.7%
July	378	10.8%
August	306	8.7%
September	461	13.1%
October	278	8.0%
November	433	12.3%
December	407	11.6%
January	484	13.8%
February	421	12.0%
Total	3,509	100.0%
*Note: Percentage figures in this table were calculated using the actual receipt and issue figures realized during FY18.

C-5.3 Storage (As of February 2019)
	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
NSNs in Storage	61,529	61,529	61,529	61,629	61,529
Note: This varies from year to year.

C-5.3.1 Stow of Receipts
Measurement in Lines
Weight Bands	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	N/A	44,800	74,532	74,425	74,077	74,069
Weight Band 2	N/A	7,586	11,588	11,571	11,517	11,516
Weight Band 3	N/A	5,060	7,022	7,012	6,979	6,979
Weight Band 4	N/A	529	636	635	632	632
Total Stows	N/A	57,977	93,778	93,643	93,205	93,196
Note: Based on J7's formula.

C-5.3.3 Care of Supplies in Storage (COSIS)
Measurement is Each
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Visual Inspections	QMF Query	8,815	11,753	11,753	11,753	11,753
Shelf Life (Cyclic)	QMF Query	274	365	365	365	365
Special Inspections	QMF Query	1,242	1,656	1,656	1,656	1,656
Quality Inspections	QMF Query	137	182	182	182	182

C-5.3.7 Rewarehousing of Material
Measurement is Each
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Rewarehouse Actions	40205	918	1,224	1,224	1,224	1,224

C-5.3.8 Issue of Material
On-Base Issues	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	24002 + 62402	62,986	99,047	98,905	98,443	98,433
Weight Band 2	24003 + 62403	4,535	6,744	6,734	6,703	6,702
Weight Band 3	24004 + 62404	2,225	3,639	3,634	3,617	3,617
Weight Band 4	24005 + 62405	163	296	296	295	295
Total	24001 + 62401	69,909	109,726	109,569	109,058	109,047
Off-Base Issues	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	24007 + 62407	118,052	148,129	147,917	147,225	147,209
Weight Band 2	24008 + 62408	5,813	6,976	6,966	6,934	6,933
Weight Band 3	24009 + 62409	3,026	3,738	3,732	3,715	3,715
Weight Band 4	24010 + 62410	110	114	114	113	113
Total	24006 + 62406	127,001	158,957	158,729	157,987	157,970
Transshipments - Off-Base	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	24083 + 62610	12,251	13,095	13,076	13,015	13,014
Weight Band 2	24084 + 62611	2,201	2,441	2,438	2,426	2,426
Weight Band 3	24085 + 62612	2,486	2,225	2,221	2,211	2,211
Weight Band 4	24086 + 62613	420	456	456	453	453
Total	24082 + 62602	17,358	18,217	18,191	18,105	18,104
Transshipments - On-Base	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
NLC Trans On-Base	24081 + 22601	10,454	19,822	19,794	19,701	19,699
MPC Trans On-Base	22620	227,324	274,555	274,160	272,878	272,851
DROs	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	24102	1,486	5,182	5,174	5,150	5,150
Weight Band 2	24103	261	638	637	634	634
Weight Band 3	24104	253	489	488	486	486
Weight Band 4	24105	23	60	60	60	60
Total	24101	2,023	6,369	6,359	6,330	6,330
Rewarehouse Picks	40215	10,747	20,422	20,392	20,297	20,295
Total Issues (Includes picks at Depot for Stow)	92440	464,816	608,068	607,194	604,356	604,296

Overall DRO Issues Monthly Workload Projections – Lines (June 2020 through February (2021)
Issues	Issues
	Monthly Issues	%
June	203	7.0%
July	174	6.0%
August	527	18.2%
September	713	24.7%
October	259	9.0%
November	209	7.2%
December	138	4.8%
January	164	5.7%
February	505	17.5%
Total	2,892	100.1%
*Note: Percentage figures in this table were calculated using the actual issued figures realized during FY18.

Estimated Issue Percentage Of Quantity Per Line
Measurement is Lines
Quantity	Total Lines	Total Lines by	Weight Band
(Number of Individual Issues processed per line)		Weight Band 1	Weight Band 2	Weight Band 3	Weight Band 4	%
1	353,151	309,183	28,455	9,818	5,694	58.08%
2 to 9	167,670	146,795	13,510	4,661	2,704	27.57%
10 to 19	36,214	31,706	2,918	1,007	584	5.96%
20 to 29	15,513	13,582	1,250	431	250	2.55%
30 to 49	10,924	9,564	880	304	176	1.80%
50 to 99	10,002	8,757	806	278	161	1.64%
100+	14,594	12,777	1,176	406	235	2.40%
Total	608,068	532,363	48,995	16,905	9,805	100.00%

Additional Issue Requirements
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Controlled Material	32002	26,345	35,126	35,126	35,126	35,126
Hard to Handle	24034 + 62434	22,493	29,990	29,990	29,990	29,990
HAZMAT/RAD	21262	1,201	1,601	1,601	1,601	1,601
Magnetic Issues	SAS Query	2	2	2	2	2

C-5.3.12 Shipment Preparation
Packing	Source	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
WB1	N/A	199,828	267,712	267,757	267,803	267,852
WB2	N/A	6,262	8,389	8,391	8,392	8,394
WB3	N/A	3,678	4,928	4,928	4,930	4,931
WB4	N/A	415	556	556	556	556
Total	Percentage Formula	210,183	281,585	281,632	281,681	281,733
Note: Based on J7's formula.

C-5.4.2. WAREHOUSE MANAGEMENT SYSTEM (WMS) PHYSICAL INVENTORIES Totals for 1st and 2nd Counts

	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
TPIC “E” Inventories	52	70	70	70	70
TPIC “D” Inventories	82,357	109,810	109,810	109,810	109,810
TPIC “B” Inventories	3	6	6	6	6
TPIC “T” Inventories	74	98	98	98	98
TPIC “P” Inventories	0	0	0	0	0
TPIC “L” Inventories	0	0	0	0	0
TPIC “G” Inventories	0	0	0	0	0
TPIC “M” Inventories	180	240	240	240	240
TPIC “R” Inventories	173	230	230	230	230
TPIC “S” Inventories	0	0	0	0	0
TPIC “V” Inventories	232	310	310	310	310
TPIC “K” Inventories	0	0	0	0	0
TPIC “C” Inventories	65	86	86	86	86
TPIC “H” Inventories	0	0	0	0	0
TPIC “N” Inventories	0	0	0	0	0
TPIC “J” Inventories	0	0	0	0	0
TPIC "I" Inventories	0	0	0	0	0
Total	83,136	110,850	110,850	110,850	110,850
Note: TPIC's listed in priority order. The inventory quantities include both wholesale and retail workload that will be completed for the entire distribution center.

C-5.4.1 Floor to Book (Wholesale & Retail) - 2% of total locations
Measurement is Each
	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Floor to Book	5,072	6,763	6,763	6,763	6,763
2nd Floor to Book For Count Mismatches	360	480	480	480	480
TPIC M Inventories	180	240	240	240	240
Quality Audits	254	338	338	338	338
Total	5,866	7,821	7,821	7,821	7,821
Note: F2B is 2% of total occupied locations.

C-5.4.2.1 Research of Potential or Actual Physical Inventory Adjustments
Measurement is Each
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Causative Research	95700	1,060	1,178	1,178	1,178	1,178

C-5.4.3 Denial Research
Measurement is Each
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Denial Research	26490+26550+26590+ 26630+26670+26710+ 27490+27550+27590+ 27630+27670+27710	995	1,327	1,327	1,327	1,327

C-5.4.5 Location Surveys
Measurement is Each
	Source	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Location Surveys (Number of Occupied Locations)	J3 Storage	85,040	85,040	85,040	85,040	85,040
Controlled Locations Only		776	862	862	862	862
Note: This can change from year to year.

C-5.3.3 COSIS & C-5.4.6 ADHOC
Measurement is Each
	Source	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
5.4.3 V00 Adhocs (COSIS only)	QMF Query	3,575	3,972	3,972	3,972	3,972

C-5.5.2 Traffic Management and C-5.5.3 Shipping
Measurement is Each
Off-Base Issues & Off-Base Transshipments	Source	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
WB1	N/A	133,448	164,737	164,501	163,732	163,715
WB2	N/A	8,042	9,448	9,435	9,391	9,390
WB3	N/A	5,547	6,003	5,992	5,965	5,965
WB4	N/A	530	570	570	566	566
Total		147,567	180,758	180,498	179,654	179,636
Note:Includes Both wholesale and retail workload.

C-5.5.5 Security Assistance Program (SAP): Foreign Military Sale (FMS) and Grant Aid
Measurement is Each
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
FMS	24036 + 62436	4,450	5,822	5,814	5,787	5,786

C-5.5.6 Controlled Materiel (Traffic Management/Transportation Requirements)

	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Classified	32001	918	1,201	1,199	1,194	1,193
Pilferable/Sensitive	32005	25,245	33,026	32,978	32,824	32,821
Controlled	24033+62433	24,989	32,690	32,643	32,490	32,487
Hard to Handle	24034+62434	19,541	25,563	25,526	25,407	25,404
Hazardous (HAZMAT)	21262	1,395	1,825	1,822	1,814	1,814
Total			94,304	94,169	93,729	93,719

C-5.6.1 Preservation, Packaging and Marking (PPP&M) Includes Wholesale and Retail Material
Measurement is Each
Repackaged	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
X-Small	16036+23827+42010+40710	1,837	2,467	2,475	2,464	2,452
Small	16037+23828+42011+40711	23,582	31,658	31,765	31,616	31,461
Medium	16038+23829+42012+40712	6,382	8,568	8,597	8,557	8,515
Large	16039+23830+42013+40713	876	1,176	1,180	1,174	1,169
X-Large	16040+23831+42014+40714	471	633	635	632	629
XX-Large	16041+23832+42015+40715	505	679	682	678	675
Total		33,653	45,181	45,334	45,121	44,901

C-5.6.2 Packaging Remarks (PPP&M) Only Wholesale Material
Measurement is Each
Packages Remarked Only	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Total Remarks	16035+23826+42009+40709	30,872	41,446	41,386	41,193	41,189

C-5.6.3 Container Fabrication Support Includes Wholesale and Retail Material
Measurement is Each by Type and Size
Size	Source	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
X-Small	Site	6	8	8	8	8
Small	Site	770	1,026	1,026	1,026	1,026
Medium	Site	620	826	826	826	826
Large	Site	249	332	332	332	332
X-Large	Site	299	398	398	398	398
XX-Large	Site	249	332	332	332	332
Fiberboard Containers	Site	0	0	0	0	0
Other Type Containers	Site	0	0	0	0	0
Total		2,193	2,922	2,922	2,922	2,922
Note: This workload is combination of both wholesale and retail workload.

C-5.7.1 N MATERIAL PROCESSING CENTER (MPC)
Measurement is Each
MPC Lines	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5

Total MPC Transshipments Closed 242,547 321,580 321,117 319,616 319,585

Overall MPC Transshipments Monthly Workload Projections – Lines (June 2020 through February (2021)
	Transshipments
	Monthly Transshipments	%
June	29,778	12.28%
July	26,499	10.93%
August	30,113	12.42%
September	29,802	12.29%
October	25,648	10.57%
November	27,108	11.18%
December	23,703	9.77%
January	24,931	10.28%
February	24,965	10.29%
Total	242,547	100.00%
*Note: Percentage figures in this table were calculated using the actual issued figures realized during FY18.

PNSY Point Loma Customer Support DSS ENTRIES	Source	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Receipts	QMF Queries	2,426	3,234	3,234	3,234	3,234
On base transshipments	QMF Queries	2,108	2,811	2,811	2,811	2,811
Off base Transshipments	QMF Queries	557	743	743	743	743
Note: Based on 2015 through 2018 Data

C-5.7.5N SERIALIZED ENGINES
Measurement is Each
SERIALIZED ENGINES EACH	Source	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5

Receipts	QMF Queries	24	32	32	32	32
Stow	QMF Queries	24	32	32	32	32
Issues	QMF Queries	51	67	67	67	67

RETAIL
Overall Receipt and Issue Workload Projections – Lines
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Receipts	91140	12,094	16,052	16,028	15,954	15,953
Issues	92440	59,098	79,521	79,408	79,036	79,027
Total Workload	98400	71,192	95,573	95,436	94,990	94,980

C-5.7.2.1N Receiving
Measurement in Lines
Weight Bands	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	13001 + 61301	3,372	4,527	4,520	4,499	4,499
Weight Band 2	13002 + 61302	121	163	162	162	162
Weight Band 3	13003 + 61303	109	146	146	145	145
Weight Band 4	13004 + 61304	12	16	16	16	16
Rewarehouse Stow in Retail after rewarehousing pick in wholesale	40220	8,480	11,200	11,184	11,132	11,131
RDOs w/ Special Project RDO Total Stowed Receipt	15202	0	0	0	0	0
Total Receipts	91140	12,094	16,052	16,028	15,954	15,953

Estimated Receipt Percentage of Quantity per Line
Quantity	Total Lines	Total Lines by Weight Band				%
(Number of Individual Receipts processed per line)		Weight Band 1	Weight Band 2	Weight Band 3	Weight Band 4
1	3,532	2,604	521	206	201	29.21%
2 to 9	5,386	3,972	795	314	306	44.53%
10 to 19	1,305	962	192	76	74	10.79%
20 to 29	479	353	71	28	27	3.96%
30 to 49	348	257	51	20	20	2.88%
50 to 99	357	263	53	21	20	2.95%
100+	687	507	101	40	39	5.68%
Total	12,094	8,918	1,784	705	687	100.00%

C-5.7.2.1N Supply Discrepancy Reports (SDR) (Type 8 or 9)
Measurement is Each
Type Discrepancy	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
All Inclusive	133	178	178	178	178

C-5.7.2.1N Non-Procurement Receipts (Customer Returns)
Measurement is Lines
Weight Bands	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	N/A	430	500	500	498	498
Weight Band 2	N/A	15	18	18	18	18
Weight Band 3	N/A	14	17	16	16	16
Weight Band 4	N/A	2	2	2	2	2
Total	12102	461	537	536	533	533
Note: Based on J7's formula.

C-5.7.2.1N Non-Procurement Receipts (Redistributions)
Measurement is Lines
Weight Bands	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	N/A	1,696	1,975	1,972	1,963	1,963
Weight Band 2	N/A	61	71	71	71	71
Weight Band 3	N/A	55	64	64	63	63
Weight Band 4	N/A	6	7	7	7	7
Total	12103	1,818	2,117	2,114	2,104	2,104
Note: Based on J7's formula.

C-5.7.2.1N Non-Procurement Receipts (New Procurements)
Measurement in Lines
Weight Bands	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	N/A	1,385	1,613	1,611	1,603	1,603
Weight Band 2	N/A	50	58	58	58	58
Weight Band 3	N/A	45	52	52	52	52
Weight Band 4	N/A	5	6	6	6	6
Total	12101	1,485	1,729	1,727	1,719	1,719
Note: Based on J7's formula.

Additional Receipt Requirements -Value Added ((Depiction of extra effort to process these types of Receipts)
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Receipts from Maintenance	10402	0	0	0	0	0
Serviceable Returns	10802	461	537	536	533	533
Unserviceable Returns	10302	0	0	0	0	0
Unit Cost Receipt Reversals	12950	4	4	4	4	4
Hazardous Receipts	11703+60370+60297	0	0	0	0	0
Manual Count Receipts	91200	0	0	0	0	0
Rewarehouse STOWs	40220	10,021	11,669	11,652	11,598	11,597
Total Receipts	91140	10,485	12,210	12,192	12,135	12,135
Note: Receipts may fall into multiple types above. Not all receipts are captured in Weight Bands.

C-5.7.2.1N Additional Receipt Requirements (Material Type)
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Controlled Material	30660	0	0	0	0	0
Hard to Handle	13012 + 61312	0	0	0	0	0
Hazardous Material (HAZMAT)	13011 + 61311	0	0	0	0	0
Frustrated Material	10302	0	0	0	0	0
Misdirected Material	30104	0	0	0	0	0
Receipts Lost In-Transit Unit Cost Receipt Reversals	12950	4	5	5	5	5
Magnetic Material	SAS Query	0	0	0	0	0

C-5.7.2.3N Warehousing (As of February 2019)
	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
NSNs in Storage	27,014	27,014	27,014	27,014	27,014

C-5.7.2.3N Stow of Receipts
Measurement in Lines
Weight Bands	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	N/A	3,372	4,527	4,520	4,499	4,499
Weight Band 2	N/A	121	163	162	162	162
Weight Band 3	N/A	109	146	146	145	145
Weight Band 4	N/A	12	16	16	16	16
Total Stows	N/A	3,614	4,852	4,844	4,822	4,822
Note: Based on J7's formula. Only using the total for the Weight Bands under the breakout above for Total Receipts reflecting Weight Band data.

C-5.7.2.3N Care of Supplies in Storage (COSIS)
Measurement is Each
	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Visual Inspections	410	456	456	456	456
Shelf Life (Cyclic)	1,717	2,290	2,290	2,290	2,290
Special Inspections	133	178	178	178	178
Quality Inspections	90	120	120	120	120

C-5.7.2.3N Retail Rewarehouse Actions
Measurement in Lines
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Rewarehousing Action	13001 + 61301	676	901	901	901	901

C-5.7.2.3N Issue of Material
On-Base Issues	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	24002 + 62402	31,537	44,283	44,220	44,013	44,007
Weight Band 2	24003 + 62403	187	365	365	363	363
Weight Band 3	24004 + 62404	104	207	207	206	206
Weight Band 4	24005 + 62405	0	0	0	0	0
Total	24001 + 62401	31,829	44,855	44,792	44,582	44,576
Off-Base Issues	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	24007 + 62407	3,132	3,498	3,493	3,477	3,477
Weight Band 2	24008 + 62408	28	31	31	31	31
Weight Band 3	24009 + 62409	35	40	39	39	39
Weight Band 4	24010 + 62410	0	0	0	0	0
Total	24006 + 62406	3,195	3,569	3,563	3,547	3,547
Transshipments Off-Base	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	24083 + 62610	13	15	15	15	15
Weight Band 2	24084 + 62611	0	0	0	0	0
Weight Band 3	24085 + 62612	0	0	0	0	0
Weight Band 4	24086 + 62613	0	0	0	0	0
Total	24082 + 62602	13	15	15	15	15
Transshipments On-Base	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
NLC Trans On-Base	24081 + 22601	16,690	21,611	21,580	21,479	21,477
MPC Trans On-Base	22620	68	92	92	91	91
DROs	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Weight Band 1	24102	148	165	165	164	164
Weight Band 2	24103	8	9	9	9	9
Weight Band 3	24104	8	9	9	9	9
Weight Band 4	24105	0	0	0	0	0
Total	24101	164	183	183	182	182
Rewarehouse Picks	40205	7,139	9,196	9,183	9,140	9,139

Total Issues 92440 59,098 79,521 79,408 79,036 79,027

Estimated Issue Percentage Of Quantity Per Line
Measurement is Lines
Quantity	Total Lines	Total Lines by Weight Band
(Number of Individual Issues processed per line)		Weight Band 1	Weight Band 2	Weight Band 3	Weight Band 4	%
1	40,696	38,911	1,216	268	303	68.86%
2 to 9	15,807	15,113	473	104	118	26.75%
10 to 19	1,442	1,378	43	9	11	2.44%
20 to 29	325	311	10	2	2	0.55%
30 to 49	221	211	7	1	2	0.37%
50 to 99	167	159	5	1	1	0.28%
100+	440	420	13	3	3	0.74%
Total	59,098	56,503	1,767	388	440	100.00%

C-5.7.2.3N Issue of Material (Material Type)
	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Controlled Material	32002	1,323	1,764	1,764	1,764	1,764
Hard to Handle	24034 + 62434	0	0	0	0	0
Hazardous Material (HAZMAT)	21262	1,829	2,438	2,438	2,438	2,438
Frustrated Material	N/A	N/A	N/A	N/A	N/A	N/A
Misdirected Material	N/A	N/A	N/A	N/A	N/A	N/A
Issues Lost In-Transit	N/A	N/A	N/A	N/A	N/A	N/A
Magnetic Material	SAS Query	0	0	0	0	0

C-5.7.2.3N Shipment Preparation
Off-Base Issues & Off-Base Transshipments	Source	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
WB1	N/A	3,145	3,513	3,508	3,492	3,492
WB2	N/A	28	31	31	31	31
WB3	N/A	35	40	39	39	39
WB4	N/A	0	0	0	0	0
Total	N/A	3,208	3,584	3,578	3,562	3,562
Note: Based on J7's formula.

C-5.7.2.3N Denial Research
Measurement is Each
	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Denial Research	79	106	106	106	106

C-5.7.2.3N Location Surveys
Measurement is Each
	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Number of Occupied Location	30,305	30,305	30,305	30,305	30,305
Location Surveys	90	120	120	120	120
Note: This can change from year to year.

C-5.7.2.5N Security Assistance Program (SAP): Foreign Military Sale (FMS) and Grant Aid
Measurement is Each
	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
FMS	106	164	163	163	163

C-5.7.2.3N Controlled Materiel (Traffic Management/Transportation Requirements) - Material Type

	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Classified	32001	0	0	0	0	0
Pilferable/Sensitive	32005	1,060	1,427	1,425	1,418	1,418
Controlled	24033+62433	1,059	1,425	1,423	1,416	1,416
Hard to Handle	24034+62434	0	0	0	0	0
Hazardous (HAZMAT)	21262	1,282	1,726	1,723	1,715	1,715

C-5.7.2.3N Packaging Remarks (PPP&M) Retail Material Only
Measurement is Each
Packages Remarked Only	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Total Remarks	30,084	39,887	39,830	39,644	39,640
MIS DEs 16035+23826+42009+40709

C-5.7.3N SMALL BOATS AND LANDING CRAFTS
Measurement is Each by Boats and Landing craft
Value Added	Source	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Receipt Boats and Landing Craft Receipts	Manual Counts	56	74	74	74	74
Issued Boats and Landing Craft Issues	Manual Counts	72	96	96	96	96

C-5.7.2.2N., Raw Stock MIS DE Year 1 (9mo) Year 2 Year 3 Year 4 Year 5

Receipt of Raw Stock	Manual Counts	590	786	786	786	786
Unit of Issue Change (IA to IA)	Manual Counts	90	120	`120	120	120
Issue of Raw Stock	Manual Counts	2,005	2,673	2,673	2,673	2,673

C-5.7.2.3N, DTO’s Measurement is Each	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
DTO’s	Manual Counts	30	40	40	40	40
In-Transit Material for FRC	Manual Counts	15	20	20	20	20

C-5.7.2.1N, Establishing a Stock Record for FRC	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
New Stock Records	Manual Counts	30	40	40	40	40

C-5.7.2.1N, Coordinate with FRC Missing Documentation	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Receipts for FRC without a PMR	Manual Counts	270	360	360	360	360
Receipts for FRC with another issue other than missing PMR	Manual Counts	90	120	120	120	120

C-5.7.2.1N, . Coordinating to Ensure Financial Records Post Within 60 days for Return of Excess Material	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Posting Financial Records	Manual Counts	1,170	1,560	1,560	1,560	1,560

C-5.7.2.5N: FMS processing for FRCSW	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
FMS processing for FRCSW	Manual Counts	472	629	629	629	629

C-5.7.2.3N,: Processing Issue Release Orders	MIS DE	Year 1 (9mo)	Year 2	Year 3	Year 4	Year 5
Complete QBL queries, trouble ticket submission	Manual Counts	195	260	260	260	260

DDDC Projected TE 5.2 October to February 2019 SP3300-20-R-5001 Attachment J 28

File details come from the government source that posted it. Updated Mar 20, 2020.