40PB Att J-14 EPA Tables_07_10_2023.xlsx

XLSX spreadsheet 27 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
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-14 EPA Tables.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,CyXb, YbX,YT
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 (Boat Building and Repair) INDEX X$ 1,000,000Q1 2024362.40Q1 2024362.40$0
Ordering Period 2 / CLIN 000140PB Flight 2 Boat (Boat Building and Repair) INDEX X$ 1,033,035Q1 2025374.38DO DateTBDTBD
Ordering Period 3 / CLIN 000140PB Flight 2 Boat (Boat Building and Repair) INDEX X$ 1,028,613Q1 2026372.77DO DateTBDTBD
Ordering Period 4 / CLIN 000140PB Flight 2 Boat (Boat Building and Repair) INDEX X$ 1,031,039Q1 2027373.65DO DateTBDTBD
Ordering Period 5 / CLIN 000140PB Flight 2 Boat (Boat Building and Repair) INDEX X$ 1,044,967Q1 2028378.70DO DateTBDTBD
Ordering Period 6 / CLIN 000140PB Flight 2 Boat (Boat Building and Repair) INDEX X$ 1,064,024Q1 2029385.61DO DateTBDTBD
Ordering Period 7 / CLIN 000140PB Flight 2 Boat (Boat Building and Repair) INDEX X$ 1,083,475Q1 2030392.66DO DateTBDTBD

TABLE 2 -BA Forecasts

SCHEDULE
TABLE INDEX X
Producer Price Index, Boat Building and Repair
PROJECTED DIRECT MATERIAL COST INDEX
Q1Q2Q3Q4
2020286.07287.23289.83291.53
2021296.83299.50300.23300.97
2022304.90306.13307.73312.23
2023324.65331.32341.04349.02
2024362.40368.61371.54373.03
2025374.38373.47371.30370.09
2026372.77372.86371.71370.48
2027373.65374.37374.27374.17
2028378.70380.30380.73380.92
2029385.61387.24387.70387.89
2030392.66394.34394.81395.00

Q2 IHS Markit Forecast

Workbook
Created on Mon 3 Jul 2023, 2:20 PM EST (19:20 GMT)
Frequency: Quarterly
IndexShort LabelUnit42736.042826.042917.043009.043101.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.0
YUnited States, Producer Price Index, Boat Building and Repair1981M12=100272.77273.77277.70279.33280.40281.80286.07287.23289.83291.53296.83299.50300.23300.97304.90306.13307.73312.23324.65331.32341.04349.02362.40368.61371.54373.03374.38373.47371.30370.09372.77372.86371.71370.48373.65374.37374.27374.17378.70380.30380.73380.92385.61387.24387.70387.89392.66
Legend
S&P Global 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 .