J3. Uniform BIL Data Report.xlsx

XLSX spreadsheet 91 KB Posted

Attached to
BIL FUNDED - A80 TRACON ROOF REPLACEMENT Federal contract opportunity
Solicitation number
697DCK-23-R-00072
Issued by
Department of Transportation Federal Aviation Administration Southwestern Region

About this file

This document contains instructions for completing a Uniform Bipartisan Infrastructure Law (BIL) Data Report related to a federal contract. The report requires a contractor to provide information across five tabs: Contractor Info, Buy American, Environmentally Friendly, Subcontracting, and Jobs Creation. The Contractor Info tab requires business identification and contract details. The Buy American tab identifies non-domestic purchases. The Environmentally Friendly tab details energy savings initiatives. The Subcontracting tab provides subcontracting amounts by socioeconomic category. Finally, the Jobs Creation tab outlines jobs created by the contractor and first-tier subcontractors. The completed report must be submitted to the Federal Aviation Administration by the specified due date.

View the file

Other files for this federal contract opportunity

Other files attached to BIL FUNDED - A80 TRACON ROOF REPLACEMENT, newest first.
File Type Posted
697DCK-23-R-00072 P00002.pdf PDF
J1 - FAA-A80-22003855 Roof replacement - Specifications Rev1 01232023.pdf PDF
J7. A80 RFI Set 2.pdf PDF
J6. A80 Roof - RFI Set 1.pdf PDF
697DCK-23-R-00072 Amend 01.pdf PDF
J4. TRACON ROOF PLAN.pdf PDF
J5. TRACON BUILDING SECTIONS.pdf PDF
FAA-A80-22003855 Roof replacement - Specifications Final.pdf PDF
Attachment B - A80-22003855-Final Drawing 081122.pdf PDF
L2. Past Performance Questionnaire.pdf PDF
L3 - Standardized Proposal Breakdown.xls XLS spreadsheet
697DCK-23-R-00072.pdf PDF
J2. Wage Rate GA20220313_10.14.22.pdf PDF
Attachment A - A80 Roof Special Conditions.pdf PDF
L1. BidBond.pdf PDF
Show all 15

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 Uniform 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 9-AFN-BIL-Questions@faa.gov Submit the completed report to 9-AFN-BIL-Reports@faa.gov

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 incorporate 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 energy savings inititives.
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 energy savings initiative is associated with the JCN, use multiple lines.
TAB 4 - SUBCONTRACTING
JCN - List each JCN on the contract/order/modification.
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.

&P July 2022 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
e-mail
Date of Submission9/22/22 0:00
Business Information
Business Name
Business Address
City
State
Zipcode (Zip + 4)
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
JCNCityStateZIP +4Dollar Value

Federal Aviation Administration BIL Data Report Contractor Info

&P July 2022

Tab 2 - Buy American

September 22, 2022
Buy American Data
Identify all non-domestic purchases to date associated with this contract/order/modification 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.
JCNDescriptionDollar Value

Federal Aviation Administration BIL Data Report Buy American

&P July 2022

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 )
AlabamaAL
AlaskaAK
ArizonaAZ
ArkansasAR
CaliforniaCA
ColoradoCO
ConnecticutCT
DelawareDE
FloridaFL
GeorgiaGA
HawaiiHI
IdahoID
IllinoisIL
IndianaIN
IowaIA
KansasKS
KentuckyKY
LouisianaLA
MaineME
MarylandMD
MassachusettsMA
MichiganMI
MinnesotaMN
MississippiMS
MissouriMO
MontanaMT
NebraskaNE
NevadaNV
New HampshireNH
New JerseyNJ
New MexicoNM
New YorkNY
North CarolinaNC
North DakotaND
OhioOH
OklahomaOK
OregonOR
PennsylvaniaPA
Rhode IslandRI
South CarolinaSC
South DakotaSD
TennesseeTN
TexasTX
UtahUT
VermontVT
VirginiaVA
WashingtonWA
West VirginiaWV
WisconsinWI
WyomingWY
American SamoaAS
District of ColumbiaDC
Federated States of MicronesiaFM
GuamGU
Marshall IslandsMH
Northern Mariana IslandsMP
PalauPW
Puerto RicoPR
Virgin IslandsVI

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

September 22, 2022
Energy Savings
Identify all Energy Savings initiatives to date by associated JCN and description. At the completion of the installation and prior to acceptance by the FAA, 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
JCNProduct/Technology to be Replaced

Federal Aviation Administration BIL Data Report Environmentally Friendly

&P July 2022

Tab 4 - Subcontracting

September 22, 2022
Subcontracting
Input the total dollars awarded to date 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.
JCNLARGE BUSINESS CONCERNSMALL BUSINESS CONCERNSMALL DISADVANTAGE BUSINESS CONCERNWOMAN OWNED BUSINESS CONCERNSOCIALLY AND ECONOMICALLY DISADVANTAGED BUSINESS CONCERN (8a)SERVICE DISABLED VETERAN OWNED SMALL BUSINESS CONCERNHUBZONE SMALL BUSINESS CONCERNVETERAN OWNED SMALL BUSINESS CONCERNHISTORICALLY BLACK COLLEGES AND UNIVERSITIES
TOTAL$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
% OF CONTRACT

Federal Aviation Administration BIL Data Report Subcontracting

&P July 2022

Tab 5 - Jobs Creation

September 22, 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.
JCNNumber of Jobs Created by ContractorNumber of Jobs Created by First Tier Subcontractors

Federal Aviation Administration BIL Data Report Jobs Creation

Page &P July 2022 image1.png

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