SHELDON-AFWERX Portfolio Analysis Template

Portfolio Explanation

Portfolio Analysis

Distinct UEIs with an Air Force Funded and Awarded Phase I/II SBIR/STTR since fiscal 2019

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

Understanding AFWERX Intervention

Entity Background Materials

AFWERX Portfolio Companies

Breakdown by Prior AFWERX SBIR Type

Table

Bar Chart

Breakdown by Prior AFWERX SBIR Type and AFWERX Intervention Year

Table

Bar Chart

Sankey Diagram

Sunburst Chart of UEI Portfolio

Breakdown by Prior AFWERX SBIR Type and Year of First Air Force Funded & Award Phase I/II SBIR/STTR Award

Table

Bar Chart

New Defense Funded and Awarded Entities

Table

Bar Chart

New Defense Funded and Awarded Entities by AFWERX Intervention Fiscal Year

Table

Bar Chart

New Defense Funded and Awarded Phase I/II SBIR/STTR Entrants

Table

Bar Chart

New Defense Funded and Awarded Phase I/II SBIR/STTR Entrants by AFWERX Intervention Fiscal Year

Table

Bar Chart

Breakdown by Prior Phase I/II $ Bin

Table

Bar Chart

Breakdown by Prior Phase I/II Distinct Award Bin

Attribution Table

Bar Chart

Question 1

Entities with Subsequent FPDS Phase III?

Attribution Table

Bar Chart by Prior Type

Question 2

Annual FPDS Phase III Amount by Fiscal Year

Attribution Table

Bar Chart by Prior Type

Question 3

Subsequent FPDS Phase III Award $ by Awardee State

Table

Point Plot

Map

Question 4

Subsequent FPDS Phase III Award $ by Awardee State and Fiscal Year

Table

Bar Chart

Question 5

Subsequent Air Force FPDS Phase III Award $ by Awardee State and Fiscal Year

Table

Point Chart

Map

Question 6

Subsequent Air Force FPDS Phase III Awardees by Awardee State and Fiscal Year

Table

Point Chart

Map

Question 7

Subsequent Air Force FPDS Phase III Award $ by Awardee State/Congressional District and Fiscal Year

Table

Point Chart

Question 8

Subsequent Air Force FPDS Phase III Awardees by Awardee State/Congressional District and Fiscal Year

Table

Point Chart

STRATFI & TACFI Transitions

Bar Chart

Table

Subsequent Award Breakdown

Subsequent Award Amount Sunburst Chart

Subsequent Award Distinct Count Sunburst Chart

Key Visualizations by AFWERX Intervention Year

Subsequent Sheldon Transition Awards by AFWERX Intervention Year and AFWERX Group

Subsequent FPDS Phase III by AFWERX Intervention Year and AFWERX Group

Subsequent Award SHELDON Efficency Ratio Amount by Intervention Year and AFWERX Group

Company Level Transition Analysis

Award $

Subsequent vs Prior Federal Award $

Distinct Awards

Subsequent vs Prior Federal Distinct Award Count

GWalkR

GWalkR Analysis Tool