STRATFI-TACFI Cohort Analysis & Time to First Award Analysis

STRATFI/TACFI Cohort Analysis and Time to First Subsequent Award Analysis

May 13th, 2025 Discussion Materials

Initial analysis on STRAFTI/TACFI cohort years and time to first subsequent award by various groups.

Contract Details

Contract Number: FA228024C0012
Contractor Name: P.W. Communications, Inc.
Contractor Address: 11200 Rockville Pike Suite 130 Rockville, MD 20852

Background

• All UEIs since fiscal 2019
• Air Force Funded AND Awarded Phase I/II SBIR/STTR
• Only UEIs with total Phase I/II Awards Air Force Awarded & Funded Awards >= $10,000
• Earliest contract date with earliest transaction date time that meets these parameters is treated as the analysis date and contract for the UEI

STRAFI/TACFI Assumptions

• Only awards that resolve to FPDS data as of March 13th, 2025.
• Cohort year determined by budget year of first type of award.
• If a company has a STRATFI it is considered a STRATFI company.
• Sometimes analysis award is not considered a SBIR/STTR in FPDS 0

Time to Award First Subsequent Award

Parent SHELDON Funding Type

Aggregate

Table

Data Viz

Box Plot

Empirical Density

Summary Statistic Scatter Plot

By Prior AFWERX Prior Company Type

Table

Data Viz

Boxplot

Empirical Density

Summary Statistic Scatter Plot

Company Level Beeswarm Plot

By Prior AFWERX Prior Company Type and Year

Table

SHELDON Funding Type

Aggregate

Table

Data Viz

Box Plot

Empirical Density

Summary Statistic Scatter Plot

By Prior AFWERX Prior Company Type

Table

Data Viz

Boxplot

Empirical Density

Summary Statistic Scatter Plot

Company Level Beeswarm Plot

By Prior AFWERX Prior Company Type and Year

Table

STRAFI/TACFI Analysis

UEI Count Breakdown by TACFI/STRATFI

Aggregate by Type

Table

Bar Chart

Aggregate by Type and STRATFI/TACFI Cohort Year

Table

Bar Chart

Analysis Period Variance

Bar Chart: Actual SHELDON Funding Type of Analysis Award

SHELDON Parent Type Level

Aggregrate Total

Financial Performance

Table

Bar Chart

Ratio Analysis

Table

Aggregate Total by STRATFI/TACFI Type

Financial Performance

Bar Chart: Total Amount by SHELDON Parent

Bar Chart: Total Amount by STRATFI/TACFI

Bar Chart: % with Subsequent Awards

Ratio Analysis

Table

Bar Chart: STRATFI vs TACFI Transition Ratio

Aggregate Total by STRATFI/TACFI Type and Cohort Year

Financial Performance

Table

Bar Chart: Subsequent Breakdown by Year and Type

Ratio Analysis

Table

Scatter Plot: Ratio

Company Level Analysis

Table

Scatter Plot: Subsequent Transition Amount

Scatter Plot: SBIR Efficency Ratio

SHELDON Funding Type Level

Aggregrate Total

Financial Performance

Table

Bar Chart

Ratio Analysis

Table

Aggregate Total by STRATFI/TACFI Type

Financial Performance

Table

Bar Chart: Total Amount by SHELDON Funding

Bar Chart: Total Amount by STRATFI/TACFI

Bar Chart: % with Subsequent Awards

Ratio Analysis

Table

Bar Chart: STRATFI vs TACFI Transition Ratio

Aggregate Total by STRATFI/TACFI Type and Cohort Year

Financial Performance

Table

Bar Chart: Subsequent Breakdown by Year and Type

Ratio Analysis

Table

Scatter Plot: Ratio

Company Level Analysis

Table

Scatter Plot: Subsequent Phase III Amount

Scatter Plot: Phase III Efficency Ratio