Attachment J-10 - EPA Tables A00002.xlsx

XLSX spreadsheet 48 KB Posted Jul 8, 2021

Attached to: US Coast Guard Waterways Commerce Cutter Program
Solicitation number: 70Z02321RPRT00300
Issued by: Department of Homeland Security US Coast Guard

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains details for a federal solicitation seeking proposals for the design and production of Waterways Commerce Cutters for the U.S. Coast Guard. The solicitation is set aside for small businesses and seeks proposals to design and produce up to twenty-seven cutters to replace aging vessels performing construction, maintenance, and navigation duties. Proposals are due by July 30, 2021 and the agency plans to award an indefinite delivery, indefinite quantity contract. Offerors must be registered in the System for Award Management database and certified under the United States/Canada Joint Certification Program to access technical data documents restricted for distribution. Questions about the solicitation are due by June 1, 2021. The solicitation also includes economic price adjustment tables for direct labor and materials costs over the contract period.

View the file

Other files

File	Type	Posted
Section L - Instructions to Offerors_A00004.docx	DOCX document	Jul 27, 2021
70Z02321RPRT00300_A00004_KO_Signed.pdf	PDF	Jul 27, 2021
J-2 - Design and Readiness Review Requirements and Criteria_v2.0_A00003.pdf	PDF	Jul 21, 2021
Section L - Instructions to Offerors_A00003.docx	DOCX document	Jul 21, 2021
WCC_RFP_Change_Log_A00003.docx	DOCX document	Jul 21, 2021
70Z02321RPRT00300_A00003_KO_Signed1.pdf	PDF	Jul 21, 2021
Attachment J-4 - CDRL_v2.0_A00003.pdf	PDF	Jul 21, 2021
Section F Deliveries or Performance_WCC_A00003.docx	DOCX document	Jul 21, 2021
Section C - WCC SOW_v3.0_A00003.pdf	PDF	Jul 21, 2021
WCC_RFP_Industry_Responses_A00003.docx	DOCX document	Jul 21, 2021
J-1I - GFI List_v2.0 _A00003.pdf	PDF	Jul 21, 2021
70Z02321RPRT00300_A00002 KO signed.pdf	PDF	Jul 8, 2021
Attachment J-1F - WCC PPD-070-1 - ABS Classification Guide A00002.pdf	PDF	Jul 8, 2021
Attachment J-1E - FL_2602_11_1_-_1 Spud Arrangements A00002.pdf	PDF	Jul 8, 2021
Attachment J-12 - Records Management Requirements A00002.pdf	PDF	Jul 8, 2021
Section L Attachment L-2 Price Worksheets A00002.xlsx	XLSX spreadsheet	Jul 8, 2021
Attachment J-1 - WCC System Specification A00002.pdf	PDF	Jul 8, 2021
Attachment J-9 Tech Data and Computer Software Data Rights_v2.0 [A00002].pdf	PDF	Jul 8, 2021
Attachment J-1J - Outfitting List_v2.0 [A00002].xlsx	XLSX spreadsheet	Jul 8, 2021
WCC_RFP_Change_Log_Amendment_00002.docx	DOCX document	Jul 8, 2021
WCC_RFP_Industry_Responses_Amendment_00002.docx	DOCX document	Jul 8, 2021
Attachment J-1C - WCC-SK-580-002_A_ConstDeck A00002.pdf	PDF	Jul 8, 2021
Attachment J-1B - WCC-SK-580-001-A-BuoyDeck A00002.pdf	PDF	Jul 8, 2021
Attachment J-1G - WCC PPD-512-001 - HVAC DCM A00002.pdf	PDF	Jul 8, 2021
Section L - Attachment L-4 - Preliminary Weight Estimate A00002.xlsx	XLSX spreadsheet	Jul 8, 2021
Section L - Instructions to Offerors A00002.docx	DOCX document	Jul 8, 2021
Section B - Supplies or Services and Prices_WCC_UPDATED A00002.docx	DOCX document	Jul 8, 2021
Section C - WCC SOW_v2.0 [A00002].pdf	PDF	Jul 8, 2021
Section B - Supplies or Services and Prices A00002.pdf	PDF	Jul 8, 2021
Attachment J-11 - Section 508 Requirements_v1.0 [A00002].pdf	PDF	Jul 8, 2021
Section J - Attachment Index_v2.0 [A00002].pdf	PDF	Jul 8, 2021
70Z02321RPRT00300_A00001 KO signed.pdf	PDF	Jul 2, 2021
70Z02321RPRT00300_A00001 KO signed.pdf	PDF	Jul 1, 2021
WCC_RFP_Change_Log_Amendment_001_.docx	DOCX document	Jul 1, 2021
WCC_RFP_Industry_Responses_Amendment_001_.docx	DOCX document	Jul 1, 2021
Amendment A00001_Section L - Instructions to Offerors.docx	DOCX document	Jul 1, 2021
Response to Q65 - Picture of Crane w Hammer and Lead.pdf	PDF	Jun 22, 2021
Response to Q60 - Sketch of Bow Shapes.pdf	PDF	Jun 22, 2021
WCC_RFP_Change_Log_22 Jun 2021.docx	DOCX document	Jun 22, 2021
WCC_RFP_Industry_Responses_22 Jun 2021.docx	DOCX document	Jun 22, 2021
Question Form.xlsx	XLSX spreadsheet	May 25, 2021
Section B - Supplies or Services and Prices_WCC_UPDATED 051221.docx	DOCX document	May 12, 2021
Section F - Deliveries or Performance_WCC 043021.docx	DOCX document	Apr 30, 2021
Section G - Contract Administration_WCC 043021.docx	DOCX document	Apr 30, 2021
Section D - Packaging and Marking_WCC 043021.docx	DOCX document	Apr 30, 2021
Section K - Representations and Certifications_WCC 043021.docx	DOCX document	Apr 30, 2021
Section L - Attachment L-2 - Price Worksheets 043021.xlsx	XLSX spreadsheet	Apr 30, 2021
Section L - Attachment L-1 - Major Equipment List Template.xlsx	XLSX spreadsheet	Apr 30, 2021
Section L - Attachment L-3 - Design Placemat Template.xlsx	XLSX spreadsheet	Apr 30, 2021
Solicitation Cover Page - Sections A and B.pdf	PDF	Apr 30, 2021

Show 40 more

Latest 50 of 62 listed here. See the rest on GovTribe.

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.

TABLE 1

	70Z02321RPRT00300
SCHEDULE

				TABLE 1
		ECONOMIC PRICE ADJUSTMENT FOR DIRECT LABOR COSTS
WCC ____
	PROJECTED			ACTUAL
COMPUTATION	INDEX		TOLERANCE	INDEX	INDEX	INDEX	ACTUAL	PERIOD
PERIOD	VALUE		BAND	VALUE	DIFFERENCE	CHANGE	COSTS	ADJUSTMENT
(1)	(2)		(3)	(4)	(5)	(6)	(7)	(8)

FY2023	OCT 22 - SEP 23	108.6	103.2 - 114.0
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------

FY2024	OCT 23 - SEP 24	111.2	105.6 - 116.8
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------

FY2025	OCT 24 - SEP 25	114.0	108.3 - 119.7
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------

FY2026	OCT 25 - SEP 26	117.7	113.0 - 122.4
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------

FY2027	OCT 26 - SEP 27	121.4	116.5 - 126.3
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------

FY2028	OCT 27 - SEP 28	125.1	120.1 - 130.1
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------

FY2029	OCT 28 - SEP 29	129.0	125.1 - 132.9
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------

FY2030	OCT 29 - SEP 30	133.0	129.0 - 137.0
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------

FY2031	OCT 30 - SEP 31	137.2	133.1 - 141.3
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------

FY2032	OCT 31 - SEP 32	141.4	137.2 - 145.6
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------

FY2033	OCT 32 - SEP 33	145.8	141.4 - 150.2
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------
FY2034	OCT 33 - SEP 34	150.3	145.8 - 154.8
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------

TABLE 2

	70Z02321RPRT00300
SCHEDULE

	TABLE 2
ECONOMIC PRICE ADJUSTMENT FOR DIRECT MATERIAL COSTS

WCC ____
	PROJECTED		ACTUAL
COMPUTATION	INDEX	TOLERANCE	INDEX	INDEX	INDEX	ACTUAL	PERIOD
PERIOD	VALUE	BAND	VALUE	DIFFERENCE	CHANGE	COSTS	ADJUSTMENT
(1)	(2)	(3)	(4)	(5)	(6)	(7)	(8)

FY2023	OCT 22 - SEP 23	109.5	104.0 - 115.0
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------
FY2024	OCT 23 - SEP 24	110.1	104.6 - 115.6
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------
FY2025	OCT 24 - SEP 25	111.2	105.6 - 116.8
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------
FY2026	OCT 25 - SEP 26	112.6	108.1 - 117.1
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------
FY2027	OCT 26 - SEP 27	114.3	109.7 - 118.9
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------
FY2028	OCT 27 - SEP 28	116.0	111.4 - 120.6
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------
FY2029	OCT 28 - SEP 29	117.9	114.4 - 121.4
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------
FY2030	OCT 29 - SEP 30	119.8	116.2 - 123.4
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------
FY2031	OCT 30 - SEP 31	121.8	118.1 - 125.5
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------
FY2032	OCT 31 - SEP 32	123.9	120.2 - 127.6
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------
FY2033	OCT 32 - SEP 33	125.9	122.1 - 129.7
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------
FY2034	OCT 33 - SEP 34	128.0	124.2 - 131.8
	-------------------------	--------------------	--------------------	------------------	---------------------	---------------	---------------	---------------------

TABLE 3

70Z02321RPRT00300

SCHEDULE

TABLE 3

DIRECT LABOR (INCLUDING LUMP SUMS)

BLS Actuals through March 2021

February 2020 = 100
													Fiscal Year
													Oct - Sep
													Annual
	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Average
2011	84.4	83.8	83.1	83.4	83.7	84.3	83.9	83.8	83.5	84.2	84.6	84.7
2012	85.7	86.7	87.2	87.2	88.1	87.5	87.6	86.9	87.7	87.7	89.0	88.1	86.5
2013	87.0	87.9	89.4	89.5	90.0	88.9	88.8	88.0	89.0	89.4	88.4	89.0	88.6
2014	89.1	89.4	90.2	90.0	91.4	90.6	89.8	90.5	90.8	91.3	90.5	90.7	89.9
2015	91.3	92.8	92.6	92.8	92.8	93.2	92.1	92.7	92.7	93.7	93.1	93.9	92.1
2016	93.3	94.6	95.3	94.7	94.4	94.5	95.8	95.7	96.7	96.4	96.5	96.7	94.6
2017	96.2	96.9	97.8	97.1	96.8	96.0	96.6	98.0	97.3	97.9	97.0	99.0	96.9
2018	97.5	97.3	98.2	98.5	97.7	98.2	97.7	99.3	99.3	98.8	98.4	100.3	98.1
2019	99.3	99.1	98.8	99.0	98.4	98.8	98.3	99.2	99.4	98.5	99.8	100.3	99.0
2020	100.4	100.0	102.3	102.8	103.3	103.0	103.0	102.4	100.6	102.2	103.2	103.7	101.4
2021	104.2	103.5	103.1	103.4	103.6	103.9	104.1	104.4	104.6	104.9	105.1	105.4	103.7
2022	105.6	105.8	106.0	106.2	106.4	106.6	106.8	107.0	107.2	107.4	107.6	107.8	106.1
2023	108.0	108.2	108.4	108.7	108.9	109.1	109.4	109.6	109.8	110.0	110.3	110.5	108.6
2024	110.7	110.9	111.1	111.3	111.5	111.7	111.9	112.1	112.3	112.5	112.7	112.9	111.2
2025	113.2	113.5	113.8	114.1	114.5	114.8	115.1	115.4	115.7	116.0	116.3	116.7	114.0
2026	117.0	117.3	117.6	117.9	118.2	118.5	118.8	119.1	119.4	119.7	120.0	120.3	117.7
2027	120.6	120.9	121.2	121.5	121.8	122.1	122.4	122.8	123.1	123.4	123.7	124.0	121.4
2028	124.3	124.6	125.0	125.3	125.6	125.9	126.2	126.6	126.9	127.2	127.5	127.9	125.1
2029	128.2	128.5	128.8	129.2	129.5	129.8	130.2	130.5	130.8	131.2	131.5	131.8	129.0
2030	132.2	132.5	132.8	133.2	133.5	133.9	134.2	134.5	134.9	135.2	135.6	135.9	133.0
2031	136.3	136.6	137.0	137.3	137.7	138.0	138.4	138.7	139.1	139.4	139.8	140.1	137.2
2032	140.5	140.8	141.2	141.6	141.9	142.3	142.7	143.0	143.4	143.7	144.1	144.5	141.4
2033	144.8	145.2	145.6	146.0	146.3	146.7	147.1	147.5	147.8	148.2	148.6	149.0	145.8
2034	149.3	149.7	150.1	150.5	150.9	151.3	151.6	152.0	152.4	152.8	153.2	153.6	150.3

TABLE 4

70Z02321RPRT00300

SCHEDULE

TABLE 4

DIRECT MATERIAL COST INDEX

BLS Actuals through May 2021

February 2020 = 100
													Fiscal Year
													Oct - Sep
													Annual
	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Average
2011	94.3	95.4	96.3	97.2	97.3	97.4	97.7	97.5	97.5	97.1	96.8	96.8
2012	97.4	97.7	98.0	97.8	97.5	96.4	95.8	96.2	96.5	95.8	95.9	96.0	97.0
2013	96.2	96.4	96.6	96.5	96.2	96.1	96.3	96.5	96.4	96.4	96.5	96.9	96.2
2014	97.7	97.8	97.6	97.9	97.9	97.9	98.0	98.0	98.0	97.4	96.8	96.2	97.6
2015	95.7	94.6	94.4	94.0	94.0	94.3	94.0	93.1	92.6	91.7	90.9	90.4	94.8
2016	90.3	90.2	90.7	91.7	92.7	92.9	93.1	93.2	92.9	92.4	92.7	93.6	91.7
2017	94.9	95.4	95.9	96.0	96.1	96.3	96.4	96.5	96.9	96.6	96.6	97.0	95.3
2018	98.0	98.7	99.3	100.0	100.9	101.5	101.9	101.9	102.1	102.3	102.2	102.0	99.5
2019	101.8	101.6	102.2	102.1	101.6	100.8	100.6	100.4	100.0	99.4	99.4	99.6	101.5
2020	100.5	100.0	99.8	98.3	98.3	98.8	99.0	99.3	99.9	100.1	100.7	103.0	99.4
2021	105.3	106.3	110.2	112.8	114.7	117.3	117.2	117.1	117.0	115.9	115.0	114.0	110.1
2022	113.2	112.3	111.5	111.2	111.0	110.7	110.4	110.2	110.0	109.8	109.6	109.4	112.1
2023	109.4	109.4	109.5	109.5	109.5	109.5	109.6	109.6	109.7	109.6	109.6	109.5	109.5
2024	109.7	109.9	110.1	110.2	110.3	110.4	110.5	110.5	110.5	110.6	110.6	110.6	110.1
2025	110.8	111.0	111.1	111.3	111.4	111.5	111.6	111.7	111.8	111.9	111.9	112.0	111.2
2026	112.2	112.4	112.6	112.8	112.9	113.1	113.2	113.3	113.4	113.4	113.5	113.6	112.6
2027	113.8	114.0	114.3	114.4	114.6	114.7	114.9	115.0	115.1	115.1	115.2	115.3	114.3
2028	115.6	115.8	116.1	116.2	116.4	116.5	116.6	116.7	116.9	116.9	117.0	117.1	116.0
2029	117.4	117.6	117.9	118.1	118.2	118.4	118.5	118.7	118.8	118.9	119.0	119.0	117.9
2030	119.3	119.6	119.8	120.0	120.2	120.4	120.5	120.6	120.7	120.8	120.9	121.0	119.8
2031	121.3	121.6	121.8	122.0	122.2	122.4	122.5	122.6	122.8	122.9	122.9	123.0	121.8
2032	123.3	123.6	123.9	124.1	124.2	124.4	124.5	124.7	124.8	124.9	125.0	125.1	123.9
2033	125.4	125.7	125.9	126.1	126.3	126.5	126.6	126.8	126.9	127.0	127.1	127.2	125.9
2034	127.5	127.8	128.0	128.2	128.4	128.6	128.7	128.9	129.0	129.1	129.2	129.3	128.0

TABLE 5

	70Z02321RPRT00300
TABLE 8
CALCULATING THE DIRECT MATERIAL INDEX

The DIRECT MATERIAL INDEX is a weighted average of the following constituent indexes:
		Index	Weight	Base
	BLS PPI - General Purpose Machinery and Equipment (WPU114) (not seasonally adjusted)		33%	1982 = 100
	BLS PPI - Electrical Machinery and Equipment (WPU117) (not seasonally adjusted)		25%	1982 = 100
	BLS PPI-Industrial Commodities (WPIIND) Series ID: WPU03THRU15 (not seasonally adjusted)		21%	1982 = 100
	BLS PPI - Iron and Steel (WPU101) (not seasonally adjusted)		18%	1982 = 100
	BLS PPI - Nonferrous Metals (WPU102) (not seasonally adjusted)		3%	1982 = 100

The method used to calculate the composite DIRECT MATERIAL INDEX is shown below. The actual calculation of the index for Mar 20 - Sep 20 is presented as an example:

STEP 1. Obtain the constituent index information from the applicable source (BLS Dept. of Labor). (Lines 1 - 5 below).

STEP 2. Calculate the percentage change in the index values from one month to the next. (Lines 6 - 10 below). For example, the Mar 20 calculation for the BLS PPI - General Purpose Machinery and Equipment index is:

(250.7 - 249.7) = 0.4%

249.7

STEP 3. Calculate the weighted average percent change in the composite DIRECT MATERIAL INDEX from one month to the next. (Line 13). For example, the Feb 11 calculation is:

BLS PPI - General Purpose Machinery and Equipment	0.400%	* .33 weight =	0.132%
BLS PPI - Electrical Machinery and Equipment	0.000%	* .25 weight =	0.000%
PPI-Industrial Commodities	-2.082%	* .21 weight =	-0.437%
BLS PPI - Iron and Steel	0.717%	* .18 weight =	0.129%
BLS PPI - Nonferrous Metals	0.359%	* .03 weight =	0.011%

-0.165%

STEP 4. Obtain the current value for the DIRECT MATERIAL INDEX by multiplying the composite DIRECT MATERIAL INDEX in the preceding month by the % change in the composite index (Line 10). For example, the Mar 20 value for the DIRECT MATERIAL INDEX is equal to: 100.0 * (1 + (-0.165%)) = 99.8

Line
	Constituent Indexes	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Jul-20	Aug-20	Sep-20
1	BLS PPI - General Purpose Machinery and Equipment	249.7	250.7	250.9	250.7	250.9	250.9	251.4	251.3
2	BLS PPI - Electrical Machinery and Equipment	118.0	118.0	117.7	117.7	117.6	117.7	117.7	117.8
3	PPI-Industrial Commodities	196.9	192.8	184.7	185.8	190.4	193.0	194.7	195.6
4	BLS PPI - Iron and Steel	209.1	210.6	204.7	203.5	203.5	200.9	200.4	205.2
5	BLS PPI - Nonferrous Metals	250.7	251.6	245.1	239.5	243.2	251.9	262.1	267.0

	% Changes, month to month
6	BLS PPI - General Purpose Machinery and Equipment	0.400%	0.080%	-0.080%	0.080%	0.000%	0.199%	-0.040%
7	BLS PPI - Electrical Machinery and Equipment	0.000%	-0.254%	0.000%	-0.085%	0.085%	0.000%	0.085%
8	PPI-Industrial Commodities	-2.082%	-4.201%	0.596%	2.476%	1.366%	0.881%	0.462%
9	BLS PPI - Iron and Steel	0.717%	-2.802%	-0.586%	0.000%	-1.278%	-0.249%	2.395%
10	BLS PPI - Nonferrous Metals	0.359%	-2.583%	-2.285%	1.545%	3.577%	4.049%	1.870%

13 Composite % Change -0.165% -1.501% -0.075% 0.571% 0.185% 0.327% 0.592%

14 Composite Direct Material Index 100.0 99.8 98.3 98.3 98.8 99.0 99.3 99.9

File details come from the government source that posted it. Updated Jul 8, 2021.