J.29 BIL Data Report.xlsx

XLSX spreadsheet 102 KB Posted

Attached to
Not listed Federal contract opportunity
Solicitation number
Not on record
Issued by
Department of Transportation Federal Aviation Administration Franchise Acquisition Services

About this file

This file contains a template for contractors to report on federal funds received under the Bipartisan Infrastructure Law. The template includes five tabs for contractors to provide information on their company, any non-domestic purchases, energy savings initiatives, subcontracting data, and jobs created. Contractors must submit the completed template to the Federal Aviation Administration with relevant details for each job control number for projects under applicable contracts. Data includes descriptions of energy savings technologies replaced, dollars awarded to subcontractors by socioeconomic category, and full-time equivalent jobs created by the contractor and first-tier subcontractors. The Federal Aviation Administration will use this template to collect standardized data from contractors on their use of Bipartisan Infrastructure Law funds.

View the file

Other files for this federal contract opportunity

Other files attached to Not listed, newest first.
File Type Posted
Attachment J.23 Example BVM Design Package.pdf PDF
Attachment J.17 FAA Forms 3900-17 and 3900-18.pdf PDF
Attachment J.1 Pricing.xlsx XLSX spreadsheet
Attachment J.28 SOW.docx DOCX document
Attachment J.25 Past Performance Questionnaire.docx DOCX document
Attachment J.18 Program Management Report.xlsx XLSX spreadsheet
Attachment J.15 BAT SYS TEST PROC.docx DOCX document
Attachment J.14 Battery Replacement Contractor Acceptance Inspection Checklist.docx DOCX document
Attachment J.21 BVM Requirements.docx DOCX document
Attachment J.2 - GNAS Equipment Characteristics.docx DOCX document
Attachment J.16 Test Data Sheets.pdf PDF
Attachment J.13 Data Item Description.docx DOCX document
Attachment J.26 Sample Client Auth Ltr.docx DOCX document
Attachment J.24 Relevant Experience.docx DOCX document
Attachment J.19 Example DC Systems RFQ.xlsx XLSX spreadsheet
6973GH-23-R-00094_draft.pdf PDF
Attachment J.22 Example BVM Survey Report.pdf PDF
Attachment J.12 Contract Data Requirements List.pdf PDF
Attachment J.3 - J.11 Battery Technical Exhibits A-I.xls XLS spreadsheet
Attachment J.27 Battery Equip Charact Comp Review.xlsx XLSX spreadsheet
Attachment J.20 Example UPS Battery RFQ.xlsx XLSX spreadsheet
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

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 with copy to cognizant Contracting Officer

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.
Contractor 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
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. Enter "9999" if there is no JCN.
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. If non-domestic product/technology is used but there is no JCN, enter "9999".
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.
FAA 4400-93 (01/23)i
TAB 3 -ENERGY SAVINGS
JCN - List all JCNs that incorporate energy savings initiatives. If energy savings initiatives are involved but there is no JCN, enter "9999".
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. If subcontracting is performed but there is no JCN, enter "9999".
Insert the total dollars subcontracted to date to first tier subcontractors for each JCN by socio-economic category.
TAB 5 - JOBS CREATION
JCN - Input the job control number for each project. If jobs are created but there is no JCN, enter "9999".
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.
PAPERWORK REDUCTION ACT STATEMENT.
A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a currently valid OMB Control Number. The OMB Control Number for this information collection is 2120-0595. Public reporting for this collection of information is estimated to be approximately 25 minutes per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Federal Aviation Administration, 10101 Hillwood Parkway, Fort Worth, TX 76177-1524

FAA 4400-93 (01/23) ii

OMB Control No. 2120-0595 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 Submission5/22/23 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. Enter "9999" if there is no JCN.
Location of Performance
JCNCityStateZIP +4Dollar Value

FAA 4400-93 (01/23) &P

Tab 2 - Buy American

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

FAA 4400-93 (01/23) &P

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

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

FAA 4400-93 (01/23) &P

Tab 4 - Subcontracting

May 22, 2023
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.00
% OF CONTRACT

FAA 4400-93 (01/23) &P

Tab 5 - Jobs Creation

May 22, 2023
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

FAA 4400-93 (01/23) &P

image1.png

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