40PB Att J-14 EPA Tables.xlsx

XLSX spreadsheet 32 KB Posted

Attached to
40' Patrol Boats (40 PB) with Draft RFP
Solicitation number
N0002423R2275
Issued by

View the file

Other files

File Type Posted
L-2 Past Performance Form.doc DOC document
L-4 Delivery Order N0002424F22AX.docx DOCX document
40PB Att J-14 EPA Tables_07_10_2023.xlsx XLSX spreadsheet
L-3 Financial Data.xlsx XLSX spreadsheet
40PB Att J-13 Delivery Schedule_07.24.2023.xlsx XLSX spreadsheet
40PB Flt2.2 Att J-1 Specification Rev (-)_Final.pdf PDF
L-1 Bidders Questions Submittal Form.xls XLS spreadsheet
DRAFT RFP_N00024-23-R-2275_08.02.2023.docx DOCX document
40PB Att J-12 CLIN Price Sheet_08.02.2023.xlsx XLSX spreadsheet
40PB Att J-7 Technical Data Rights Assertion.docx DOCX document
40PB Att J-10 - Integrated Data Exchange Access.docx DOCX document
40PB Att J-4 GFI List Final.docx DOCX document
40PB Att J-6 Critical Equipment List.xlsx XLSX spreadsheet
40PB Att J-3 GFE List.pdf PDF
40PB Att J-9 - Essential_Cybersecurity_Components (ECSC) Documentation Package.xlsx XLSX spreadsheet
40PB Att J-1 Flt2 Specification Rev (A)_Final.pdf PDF
40PB Form J-11 Form DD 254.pdf PDF
40PB Att J-8 - Builders Warranty.docx DOCX document
40PB Att J-2 Data Requirements List.docx DOCX document
DRAFT_40PB_RFP_N00024_23_R_2275.pdf PDF
Show all 20

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

Table 1 - Material Values subject to EPA
Cx,Cy,CzXb, Yb, ZbX,Y,ZT
CLIN(s)Item/CLIN DescriptionBase Value Subject to EPA(per QTY)Date of Base ValueBase Award Index ValueDate of AdjustmentForecast for Date of Adjustment, 90 Days before Ordering Period StartEPA (to be completed unilaterally at modification)
Ordering Period 1 / CLIN 000140PB Flight 2 Boat (Aluminum) INDEX X$ 88,000Q1 2024204.23Q1 2024204.23$0
Ordering Period 1 / CLIN 000140PB Flight 2 Boat (Machinery & Equipment) INDEX Y$ 400,000Q1 2024174.96Q1 2024174.96$0
Ordering Period 1 / CLIN 000140PB Flight 2 Boat (Plastic and Resins) INDEX Z$ 312,000Q1 2024326.19Q1 2024326.19$0
Ordering Period 2 / CLIN 000140PB Flight 2 Boat (Aluminum)$ 87,554Q1 2025203.19DO DateTBDTBD
Ordering Period 2 / CLIN 000140PB Flight 2 Boat (Machinery & Equipment)$ 400,428Q1 2025175.15DO DateTBDTBD
Ordering Period 2 / CLIN 000140PB Flight 2 Boat (Plastic and Resins)$ 301,458Q1 2025315.17DO DateTBDTBD
Ordering Period 3 / CLIN 000140PB Flight 2 Boat (Aluminum)$ 87,729Q1 2026203.60DO DateTBDTBD
Ordering Period 3 / CLIN 000140PB Flight 2 Boat (Machinery & Equipment)$ 404,557Q1 2026176.96DO DateTBDTBD
Ordering Period 3 / CLIN 000140PB Flight 2 Boat (Plastic and Resins)$ 309,933Q1 2026324.03DO DateTBDTBD
Ordering Period 4 / CLIN 000140PB Flight 2 Boat (Aluminum)$ 88,180Q1 2027204.64DO DateTBDTBD
Ordering Period 4 / CLIN 000140PB Flight 2 Boat (Machinery & Equipment)$ 408,540Q1 2027178.70DO DateTBDTBD
Ordering Period 4 / CLIN 000140PB Flight 2 Boat (Plastic and Resins)$ 318,072Q1 2027332.54DO DateTBDTBD
Ordering Period 5 / CLIN 000140PB Flight 2 Boat (Plastic and Resins)$ 88,914Q1 2028206.35DO DateTBDTBD
Ordering Period 5 / CLIN 000140PB Flight 2 Boat$ 413,042Q1 2028180.67DO DateTBDTBD
Ordering Period 5 / CLIN 000140PB Flight 2 Boat$ 325,296Q1 2028340.09DO DateTBDTBD
Ordering Period 6 / CLIN 000140PB Flight 2 Boat$ 89,579Q1 2029207.89DO DateTBDTBD
Ordering Period 6 / CLIN 000140PB Flight 2 Boat$ 417,279Q1 2029182.52DO DateTBDTBD
Ordering Period 6 / CLIN 000140PB Flight 2 Boat$ 332,281Q1 2029347.39DO DateTBDTBD
Ordering Period 7 / CLIN 000140PB Flight 2 Boat$ 90,623Q1 2030210.31DO DateTBDTBD
Ordering Period 7 / CLIN 000140PB Flight 2 Boat$ 423,404Q1 2030185.20DO DateTBDTBD
Ordering Period 7 / CLIN 000140PB Flight 2 Boat$ 341,527Q1 2030357.06DO DateTBDTBD

TABLE 2 -BA Forecasts

SCHEDULESCHEDULESCHEDULE
TABLE INDEX XTABLE INDEX YTABLE INDEX Z
Producer Price Index, Aluminum Sheet Plate and FoilProducer Price Index, Machinery and EquipmentProducer Price Index, Plastics Materials and Resins
PROJECTED DIRECT MATERIAL COST INDEXPROJECTED DIRECT MATERIAL COST INDEXPROJECTED DIRECT MATERIAL COST INDEX
Q1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4
2020184.93165.70169.03176.372020144.73144.80144.93145.102020267.97251.97259.33274.97
2021188.30209.07224.81239.702021146.03148.13151.05154.552021304.87352.00375.14374.24
2022250.34249.92219.42207.342022159.40164.06167.14169.272022357.52376.21366.00341.17
2023209.44205.86205.41204.812023172.33174.06174.55174.532023334.21344.23337.39330.58
2024204.2204.1204.3203.62024175.0175.1174.9174.62024326.2322.9315.8312.3
2025203.2203.3203.7203.62025175.2175.5176.0176.42025315.2318.6320.1321.9
2026203.6204.0204.5204.42026177.0177.3177.7178.02026324.0326.6328.6330.5
2027204.6205.2205.9206.12027178.7179.2179.6180.02027332.5334.6336.4338.3
2028206.3206.9207.5207.62028180.7181.1181.4181.82028340.1341.9343.7345.6
2029207.9208.5209.1209.22029182.5183.0183.4183.82029347.4349.3351.1353.1
2030210.3211.1211.4211.92030185.20185.64186.03186.872030357.06358.88361.06363.29

Q2 IHS Markit Forecast

Selected series from Pricing and Purchasing Forecasts
Created on Fri 2 Jun 2023, 11:21 AM EST (16:21 GMT)
Frequency: Quarterly
Short LabelUnit43101.043191.043282.043374.043466.043556.043647.043739.043831.043922.044013.044105.044197.044287.044378.044470.044562.044652.044743.044835.044927.045017.045108.045200.045292.045383.045474.045566.045658.045748.045839.045931.046023.046113.046204.046296.046388.046478.046569.046661.046753.046844.046935.047027.047119.047209.0
United States, Producer Price Index, Machinery and Equipment1982=100138.97139.80140.83141.67142.93143.30143.50143.70144.73144.80144.93145.10146.03148.13151.05154.55159.40164.06167.14169.27172.33174.06174.55174.53174.96175.06174.89174.62175.15175.55175.97176.39176.96177.33177.66177.98178.70179.19179.62180.01180.67181.09181.44181.75182.52183.03
United States, Producer Price Index, Plastics Materials and Resins1976M6=100278.60284.60290.67286.80275.40274.27273.03270.37267.97251.97259.33274.97304.87352.00375.14374.24357.52376.21366.00341.17334.21344.23337.39330.58326.19322.88315.81312.30315.17318.56320.06321.94324.03326.59328.56330.52332.54334.58336.39338.27340.09341.87343.68345.62347.39349.32
United States, Producer Price Index, Aluminum Sheet Plate and Foil1975M12=100194.37210.70207.27203.37201.27200.90194.97189.53184.93165.70169.03176.37188.30209.07224.81239.70250.34249.92219.42207.34209.44205.86205.41204.81204.23204.05204.27203.59203.19203.32203.69203.60203.60204.04204.47204.39204.64205.22205.92206.06206.35206.89207.52207.62207.89208.47
Legend
IHS Markit Forecast
© 2023 IHS Markit
This Content was published by S&P Global Market Intelligence, S&P Commodities Insight and S&P Global Mobility and not by S&P Global Ratings, which is a separately managed division of S&P Global. Reproduction of any information, data or material, incl. ratings ("Content") in any form is prohibited except with the prior written permission of the relevant party. Such party, its affiliates and suppliers ("Content Providers") do not guarantee the accuracy, adequacy, completeness, timeliness or availability of any Content and are not responsible for any errors or omissions (negligent or otherwise), regardless of the cause, or for the results obtained from the use of such Content. In no event shall Content Providers be liable for any damages, costs, expenses, legal fees, or losses (inc. lost income or lost profit and opportunity costs) related to any use of the Content. Base Chemical Content Provider is Oil Price Information Service, LLC operating as Chemical Market Analytics by OPIS, a Dow Jones company.

image1.bin

This is the start of the file's text. The full file is on GovTribe.

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