Attachment 03 - Uniform Bipartisan Infrastructure Law Data Report.xlsx
XLSX spreadsheet 69 KB Posted
- Attached to
- Roof replacement at MFE ATCT (McAllen, TX) Federal contract opportunity
- Solicitation number
- Not on record
About this file
This file is a data reporting template and instructions for contractors to report on Bipartisan Infrastructure Law (BIL) funded projects for the Federal Aviation Administration. The Excel spreadsheet contains five tabs requiring specific information: (1) Contractor Information including business details, contract numbers, and Job Control Numbers (JCNs), (2) Buy American data for tracking non-domestic products/technology used, (3) Energy Savings initiatives and environmentally friendly products implemented, (4) Subcontracting data broken down by socioeconomic categories for first-tier subcontractors, and (5) Jobs Creation metrics showing full-time equivalent positions created by both prime and first-tier subcontractors.
The template requires detailed reporting of contract values, project locations, and subcontracting percentages across various small business categories including 8(a), WOSB, SDVOSB, HUBZone, and others. Contractors must submit the completed report to the FAA and provide ongoing updates about non-domestic purchases, energy savings initiatives, and jobs created through BIL-funded projects. The template functions as a standardized tracking mechanism for the FAA to monitor BIL spending, compliance with Buy American requirements, environmental initiatives, small business participation, and employment impacts.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 697DCK-25-R-00056-0007.pdf | ||
| Questions and Answers.docx | DOCX document | |
| 697DCK-25-R-00056-0008.pdf | ||
| Factor 6 Cost Proposal Breakdown.xlsx | XLSX spreadsheet | |
| QA Attachment 02 - PreBid Attendance Sheets.pdf | ||
| QA Attachment 01 - Original Drawings part 1 of 2.pdf | ||
| 697DCK-25-R-00056-0006.pdf | ||
| 697DCK-25-R-00056-0005.pdf | ||
| 697DCK-25-R-00056-0004.pdf | ||
| 697DCK-25-R-00056-0003.pdf | ||
| MFE - Revised Specifications 1 of 2.pdf | ||
| MFE - Revised Specifications 2 of 2.pdf | ||
| QA Attachment 01 - Original Drawings part 2 of 2.pdf | ||
| 697DCK-25-R-00056-0002.pdf | ||
| 697DCK-25-R-00056-0001.pdf | ||
| Attachment 02 - Wage Determination_TX20230255.pdf | ||
| Attachment 04 - Past Performance Questionnaire.pdf | ||
| Attachment 01b - EOSH.pdf | ||
| Attachment 01a - Drawings.pdf | ||
| Attachment 01 - Specifications.pdf | ||
| 697DCK-25-R-00056.pdf |
Show all 21
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
Text version
Instructions Bipartisan Infrastructure Law (BIL) Data Report
There are five tabs to complete. See below for Instructions related to each tab:
- Contractor Info
- Buy American
- Environmentally Friendly
- Subcontracting
- Jobs Creation If you have questions, please contact [insert email address] Submit the completed report to [insert email address]
| TAB 1 - CONTRACTOR INFO |
| This tab is to be completed with the information for the Prime contractor, the entity who is on contract with the FAA to perform the contractual requirements. |
| Contrcactor Point of Contact - Input the name, phone number, and e-mail address of the person filling out this report. |
| Business Name - Input the name of the prime contactor. |
| Business Address - Input the physical address of the prime contractor |
| Business Socio-economic status - Use the drop down menu to select the socio-economic status of the prime contractor. Choose the appropriate designation as reflected in the SAM.gov representation. Reference AMS Policy Appendix C for additional information on status definitions. |
| Contract No. - Input the contract identifier for the agreement between the FAA and the Prime Contractor. The number is to be entered with a dash after the sixth, eighth, and ninth characters, i.e. XXXXXX-XX-X-XXXXX |
| Order No. - If the agreement is established by a Purchase or Task order against a parent contract, enter order number with a dash after the sixth, eighth, and ninth characters, i.e. XXXXXX-XX-X-XXXXX. If not enter N/A. |
| Modification No. - If the agreement is established by a modification to an existing contract or order, enter the six digit modification number. If not, enter N/A. |
| Total Obligated to Date - Input the total dollars obligated to date for the performance of the contract requirement. Do not enter unobligated amounts. |
| JCN - Input the job control number for each project. |
| Location of the project - Input the city, state, and zip where each JCN will be performed. |
| Dollar Value - Input the total obligated dollar value for each JCN. If a JCN is unfunded, enter zero. The total for all JCN dollar values must be equal to the value in Total obligated to Date. |
| TAB 2- BUY AMERICAN |
| JCN - List all JCNs that incorporated the use of non-domestic products/technology. |
| Description - Describe the non-domestic product/technology to include manufacturer and model number, if more than one non-domestic product/technology is associated with the JCN, use multiple lines. |
| Dollar Value - Insert the dollar value of the non-domestic product/technology. |
| TAB 3 -ENERGY SAVINGS |
| JCN - List all JCNs that incorporate the use of environmentally friendly products/technology. |
| Description, Product/Technology Replaced - Describe the product/technology that is to be removed/replaced to include manufacturer, model number, size, age, etc. If more than one environmentally friendly product/technology is associated with the JCN, use multiple lines. |
| TAB 4 - SUBCONTRACTING |
| JCN - List each JCN on the contract/order/modification applicable to each first tier subcontractor. |
| Insert the total dollars subcontracted to date to first tier subcontactors for each JCN by socio-economic category |
| TAB 5 - JOBS CREATION |
| JCN - Input the job control number for each project. |
| Jobs Created - Input, by JCN, the number of jobs created expressed as "full-time equivalent" which must include full-time, part-time, temporary, and permanent positions as expressed as a "person-year," for the Contractor and all first tier subcontractors. |
Federal Aviation Administration BIL Data Report Instructions https://fast.faa.gov/docs/acquisitionManagementPolicy/AcquisitionManagementPolicyAppendixC.pdf Tab 1- Contractor Info Bipartisan Infrastructure Law (BIL) Funds Report
| Contractor Point of Contact | ||||||
| Full Name | ||||||
| Phone Number | ||||||
| Date of Submission | February 18, 2022 | |||||
| Business Information | ||||||
| Business Name | ||||||
| Business Address | ||||||
| City | ||||||
| State | ||||||
| Zipcode | ||||||
| Business Socio-economic Status | ||||||
| Contract No. | ||||||
| Order No. (if applicable) | ||||||
| Modification No. (if applicable) | ||||||
| Total Obligated to Date | $ - 0 | |||||
| Job Control Number(s) (JCN) | ||||||
| Complete the following entries for all JCNs on the contract/order/modification. If additional space is needed, contact the FAA POC on the Instructions tab for a supplemental JCN sheet. | ||||||
| Location of Performance | ||||||
| JCN | City | State | ZIP | Dollar Value |
Federal Aviation Administration BIL Data Report Contractor Info
Page &P
Tab 2 - Buy American
| February 18, 2022 | ||
| Buy American Data | ||
| Identify all non-domestic purchases, associated with this contract/order/modification during the period of this invoice, by associated JCN, description, and dollar value. If additional space is needed, contact the FAA POC on the Instructions tab for a supplemental Buy American sheet. | ||
| JCN | Description | Dollar Value |
Federal Aviation Administration BIL Data Report Buy American
Tables
| Large Business Concern | |
| Small Business Concern | |
| Small Disadvantaged Business Concern | |
| Socially and Economically Disadvantaged Small Business (8(a) Certified) | |
| Woman Owned Small Business Concerns | |
| Service Disabled Veteran Owned Small Business Concerns | |
| Hubzone Small Business Concerns | |
| Veteran -Owned Small Business Concerns | |
| Historically Black Colleges and Universities (HBCU) and Minority Institutions (MI ) | |
| Alabama | AL |
| Alaska | AK |
| Arizona | AZ |
| Arkansas | AR |
| California | CA |
| Colorado | CO |
| Connecticut | CT |
| Delaware | DE |
| Florida | FL |
| Georgia | GA |
| Hawaii | HI |
| Idaho | ID |
| Illinois | IL |
| Indiana | IN |
| Iowa | IA |
| Kansas | KS |
| Kentucky | KY |
| Louisiana | LA |
| Maine | ME |
| Maryland | MD |
| Massachusetts | MA |
| Michigan | MI |
| Minnesota | MN |
| Mississippi | MS |
| Missouri | MO |
| Montana | MT |
| Nebraska | NE |
| Nevada | NV |
| New Hampshire | NH |
| New Jersey | NJ |
| New Mexico | NM |
| New York | NY |
| North Carolina | NC |
| North Dakota | ND |
| Ohio | OH |
| Oklahoma | OK |
| Oregon | OR |
| Pennsylvania | PA |
| Rhode Island | RI |
| South Carolina | SC |
| South Dakota | SD |
| Tennessee | TN |
| Texas | TX |
| Utah | UT |
| Vermont | VT |
| Virginia | VA |
| Washington | WA |
| West Virginia | WV |
| Wisconsin | WI |
| Wyoming | WY |
| American Samoa | AS |
| District of Columbia | DC |
| Federated States of Micronesia | FM |
| Guam | GU |
| Marshall Islands | MH |
| Northern Mariana Islands | MP |
| Palau | PW |
| Puerto Rico | PR |
| Virgin Islands | VI |
http://www.alaska.gov/http://www.hawaii.gov/http://www.idaho.gov/http://www.illinois.gov/http://www.in.gov/http://www.iowa.gov/http://www.kansas.gov/http://www.kentucky.gov/http://www.louisiana.gov/http://www.maine.gov/http://www.maryland.gov/https://az.gov/http://www.mass.gov/http://www.michigan.gov/http://www.mn.gov/http://www.ms.gov/http://www.mo.gov/http://www.montana.gov/http://www.nebraska.gov/http://www.nv.gov/http://www.nh.gov/http://www.nj.gov/http://www.arkansas.gov/http://www.newmexico.gov/http://www.ny.gov/http://www.nc.gov/http://www.nd.gov/http://www.ohio.gov/http://www.ok.gov/http://www.oregon.gov/http://www.state.pa.us/http://www.ri.gov/http://www.sc.gov/http://www.ca.gov/http://sd.gov/http://www.tennessee.gov/http://www.texas.gov/http://www.utah.gov/http://www.vermont.gov/http://www.virginia.gov/http://access.wa.gov/http://www.wv.gov/http://www.wisconsin.gov/http://www.wyo.gov/http://www.colorado.gov/http://www.asg-gov.com/http://www.dc.gov/http://www.visit-micronesia.fm/http://www.guam.gov/http://www.rmiembassyus.org/http://governor.gov.mp/http://www.visit-palau.com/http://pr.gov/http://www.usvi.net/http://www.ct.gov/http://www.delaware.gov/http://www.myflorida.com/http://www.georgia.gov/ Tab 3- Energy Savings
| February 18, 2022 | |
| Energy Savings | |
| Identify all installed Energy Savings initiatives by associated JCN, description, and dollar value. At the completion of the installation, a detailed accounting of the energy savings must be submitted on the Energy Savings Information spreadsheet at the following link: https://www.faa.gov/other_visit/consultants_contractors/. If additional space is needed, contact the FAA POC on the Instructions tab for a supplemental Energy Savings sheet. | |
| Description | |
| JCN | Product/Technology to be Replaced |
Federal Aviation Administration BIL Data Report Environmentally Friendly
Tab 4 - Subcontracting
| February 18, 2022 | |||||||||
| Subcontracting | |||||||||
| Input the total dollars awarded on all first-tier subcontracts by socio-economic category, for each JCN. | |||||||||
| If additional space is needed, contact the FAA POC on the Instructions tab for a supplemental Subcontracting sheet. | |||||||||
| JCN | LARGE BUSINESS CONCERN | SMALL BUSINESS CONCERN | SMALL DISADVANTAGE BUSINESS CONCERN | WOMAN OWNED BUSINESS CONCERN | SOCIALLY AND ECONOMICALLY DISADVANTAGED BUSINESS CONCERN (8a) | SERVICE DISABLED VETERAN OWNED SMALL BUSINESS CONCERN | HUZONE SMALL BUSINESS CONCERN | VETERAN OWNED SMALL BUSINESS CONCERN | HISTORICALLY BLACK COLLEGES AND UNIVERSITIES |
| TOTAL | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| % OF CONTRACT |
Federal Aviation Administration BIL Data Report Subcontracting
Tab 5 - Jobs Creation
| February 18, 2022 | ||
| Jobs Creation | ||
| Identify the number of jobs created to date by JCN. If additional space is needed, contract the FAA POC on the Instructions tab for a supplemental Jobs Creation sheet. | ||
| JCN | Number of Jobs Created by Contractor | Number of Jobs Created by First Tier Subcontractors |
Federal Aviation Administration BIL Data Report Jobs Creation image1.png
File details come from the government source that posted it. Updated .