4. Factor 4 LEC Material IRA Sustainability Factor Table.xlsx

XLSX spreadsheet 28 KB Posted

Attached to
Design Build Contract for Kika De La Garza Land Port of Entry (LPOE) Border Roadway Improvement and Construction (BRIC), Pharr, TX
Solicitation number
47PH0825R0001
Issued by

About this file

This document is a Sustainability Factor Table for the Pharr Kika De La Garza Land Port of Entry (LPOE) Border Roadway Improvement and Construction (BRIC) project. It provides instructions for offerors to complete the table with their commitments to meet Inflation Reduction Act (IRA) embodied carbon limits for various construction materials, including concrete, cement, asphalt, and steel. The table includes a list of IRA-eligible materials, the applicable IRA limits, a calculation of raw and weighted scores based on the offeror's commitments, and a requirement that at least 80% of a construction assembly's total cost or weight must be composed of compliant materials. This project is part of a federal contract opportunity with the General Services Administration (GSA) for a design-build contract valued between $20-30 million to address concrete pavement repairs and replacements using low embodied carbon materials at the Pharr, Texas LPOE. The contract is set aside for small businesses and will be awarded based on a best value concept methodology.

View the file

Other files

File Type Posted
Amendment 6 - 47PH0825R0001 2025 06 10.pdf PDF
Amendment 5 - 47PH0825R0001 2025 01 10.pdf PDF
Pharr LPOE Bid Sheet 2025 01 10.xlsx XLSX spreadsheet
Amendment 4 - 47PH0825R0001 2025 01 08.pdf PDF
Pharr LPOE Bid Sheet 2024 12 20.xlsx XLSX spreadsheet
Amendment 3 - 47PH0825R0001 2024 12 20.pdf PDF
Amendment 2 - 47PH0825R0001 2024 12 13.pdf PDF
Pharr LPOE Bid Sheet_12.10.24 (1).xlsx XLSX spreadsheet
Amendment 1 - 47PH0825R0001 2024 12 05.pdf PDF
FY2024 Metric Waiver FINAL.pdf PDF
14. Bid Bond.pdf PDF
1. GSA Affiliated Custom Accounts (GACA) for Google Drive.pdf PDF
12. Asphalt - GSA IRA Low Embodied Carbon Requirements (Dec. 2023).pdf PDF
3. Past Experience_Past Performance Questionnaire (Factor 2).pdf PDF
Pharr Div 01 Specs.pdf PDF
6. GSA 527-21 - Contractor's Qualifications and Financial Informatio.pdf PDF
2. Past Experience & Performance of Co Questionnaire Factor 1.pdf PDF
9. Sample IRA Project Submittal_ Reporting Form.xlsx XLSX spreadsheet
7. Offeror Representations and Certifications Form Dec 2023 (1).pdf PDF
11. Steel - GSA IRA Low Embodied Carbon Requirements (Dec. 2023).pdf PDF
5. TX20240003 Highway 2024 01 05.pdf PDF
Pharr Solicitation 2024 11 22.pdf PDF
Communications Plan Template LPOE project 03 22 posted version.docx DOCX document
13. 2022.08.03 PHAR - Final Concepts Report_3_Rev-Redacted 10-8-24signed.pdf PDF
15. IRA Project Submittal Form and Data Dictionary PDF.pdf PDF
5. TX20240255 Building 2024 08 23.pdf PDF
10. Concrete - GSA IRA Low Embodied Carbon Requirements (Dec. 2023).pdf PDF
8. Award Allocation Form IRA.xlsx XLSX spreadsheet
Show all 28

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

CO Instruction Contracting Officer Instructions

1. Make a copy of this Google Sheet for the specific project in a format to issue to offerors with the solicitation package (e.g. Google Sheets, MS Excel, etc.)
2. Delete all rows where the materials are not included in the project.
3. Develop LEC Material Evaluation Weights (Column D) for individual materials to reflect the relative approximate cost of the materials required for the project. LEC Material Evaluation Weights must add up to 100%.
4. Ensure that all columns, except for Column B, are locked/protected prior to release.
4. Delete this tab prior to issuing to offerors.
For more information please refer to the IRA Program Construction Solicitation Desk Guide.

https://docs.google.com/document/u/0/d/1WqQH8m0TkdGKFEiBG6e1AZ8HtNXyxsMBofPj53ixyrs/edit Offeror Instructions

SUSTAINABILITY FACTOR INSTRUCTIONS TO OFFERORS
1. Offerors shall complete Column B of the Sustainability Table with the applicable IRA Limit they commit to meet for each IRA-Eligible Material.

NOTE: If an offeror is utilizing multiple manufacturers/suppliers within one LEC material subcategory, and those materials achieve different GSA GWP limits, they shall, for evaluation purposes, self-score based on the material/product offered that has the highest GWP. (For example: within the 4,000 PSI concrete subcategory, if Offeror A's 4,000 PSI structural concrete meets GSA’s Top 40% GWP limit, and their 4,000 PSI site concrete meets GSA’s Top 20% limit, Offeror A shall use Top 40% in their scoring.)

2. Based upon the offeror's committment, the offeror will receive a number of Raw Scores in Column C, one for each IRA-Eligible Material required by the Contract. Column C will be automatically populated based on the offeror's input in Column B, as follows:

- Offerors will receive a Raw Score of 100 for each IRA-Eligible Material commitment that is better (lower) than GSA’s Top 20% Limits.

- Offerors will receive a Raw Score of 40 for each IRA-Eligible Material commitment that is only better (lower) than GSA’s Top 40% Limits.

- Offerors will receive a Raw Score of 20 for each IRA-Eligible Material commitment that is only better (lower) than GSA’s Better Than Average Limit.

3. The solicitation provides an LEC Materials Evaluation Weight in Column D. This weight will be multipled by the Raw Score (Column C), to automatically calculate the Weighted Score in Column D. which will be automatically calculated based on the Raw Score. The Weighted Score for each material will be rounded to the nearest hundredth decimal (i.e., two decimal places to the right of the whole number).
4. The Total Weighted Score will automatically add the Weighted Score for each material, rounded to the nearest hundredth decimal.

Sustainability Table IRA-Eligible Material* OFFEROR TO COMPLETE IRA Limit Commitment (i.e., Top 20% Limit, Top 40% Limit, Better Than Average Limit) DO NOT EDIT FORMULA Raw Score (i.e., 100, 40, or 20) DO NOT EDIT - CONTRACTING OFFICER TO PROVIDE LEC Materials Evaluation Weight (Insert as % (Example - 30%) (must add up to 100%) DO NOT EDIT FORMULA Weighted Score (multiply the material’s Raw Score by its LEC Materials Evaluation Weight) Concrete Specified concrete strength class (compressive strength [f'c] in pounds per square inch [PSI])

4000 PSITop 20%10040%40.00
Cement**Top 20%10020%20.00
AsphaltTop 20%10020%20.00
Steel
Fabricated RebarTop 20%10020%20.00
Total Weighted Score (sum of Weighted Scores) - DO NOT EDIT FORMULA100.00
* Required construction product assemblies (such as window assemblies) are included in IRA-Eligible Materials categories and will be bound by IRA Limit Commitments. At least 80% of the assembly’s total cost or total weight must be composed of compliant IRA-Eligible Materials.
** Where provision of concrete that qualifies under these GSA IRA Limits is impractical, GSA’s IRA Limits for cement may be applied to the cement being used in the concrete mix.

https://www.gsa.gov/system/files/Concrete%20-%20GSA%20IRA%20Low%20Embodied%20Carbon%20Requirements%20%28Dec.%202023%29_508.pdf

EXAMPLE

IRA-Eligible Material* OFFEROR TO COMPLETE IRA Limit Commitment (i.e., Top 20% Limit, Top 40% Limit, Better Than Average Limit) DO NOT EDIT FORMULA Raw Score (i.e., 100, 40, or 20) DO NOT EDIT - CONTRACTING OFFICER TO PROVIDE LEC Materials Evaluation Weight (Insert as % (Example - 30%) (must add up to 100%) DO NOT EDIT FORMULA Weighted Score (multiply the material’s Raw Score by its LEC Materials Evaluation Weight) Concrete Specified concrete strength class (compressive strength [f'c] in pounds per square inch [PSI])

5000 PSITop 20%10020%20.00
AsphaltTop 40%4030%12.00
Steel
Fabricated RebarTop 20%10035%35.00
Hot-Rolled Sections
(unfabricated)Better Than Average205%1.00
Flat GlassTop 40%4010%4.00
Total Weighted Score (sum of Weighted Scores) - DO NOT EDIT FORMULA72.00
* Required construction product assemblies (such as window assemblies) are included in IRA-Eligible Materials categories and will be bound by IRA Limit Commitments. At least 80% of the assembly’s total cost or total weight must be composed of compliant IRA-Eligible Materials.
** Where provision of concrete that qualifies under these GSA IRA Limits is impractical, GSA’s IRA Limits for cement may be applied to the cement being used in the concrete mix.

https://www.gsa.gov/system/files/Concrete%20-%20GSA%20IRA%20Low%20Embodied%20Carbon%20Requirements%20%28Dec.%202023%29_508.pdf

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