Attachment 2 - Comprehensive Needs Assessment Template v5 15Nov24.xlsx

XLSX spreadsheet 18 KB Posted

Attached to
USAF Fiscal Year 2025 Mentor Protege Program Open Call
Solicitation number
Not on record
Issued by

About this file

This is a comprehensive needs assessment template spreadsheet that evaluates a protégé company's capabilities across business and technical areas. The assessment uses a color-coded rating system (None, Minimal, Acceptable, Good, Advanced) to evaluate areas needing improvement under a potential Air Force Mentor-Protégé Program agreement.

The assessment reveals significant gaps in the protégé's capabilities, particularly in purchasing processes, proposal development, business capture, and executive leadership (rated Red). The company shows stronger performance in human resources (Blue) and billing processes (Green). Technical areas requiring improvement include Government customer support, commercialization of technology, and quality systems. The assessment indicates the protégé company works with biotechnology and medical samples, requiring specific attention to HIPAA compliance and secure data handling. Each capability gap is mapped to specific Work Breakdown Structure (WBS) elements ranging from 1.1 to 2.3, suggesting a structured improvement plan will be developed to address these areas.

View the file

Other files

Show all 13

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Gen Business Assessment Area Evaluated Assessment of Protégé WBS to Address Need Comments

General Business Capabilities Assessment

Financial Management / AccountingYellow1.1Needs assistance with cost controls, budget management, and control burn rates. This is needed as they use Government funds to develop their solutions.
Human ResourcesBlueHas well established processes and procedures.
Purchasing ProcessesRed1.3Needs particular improvement in buying xxxxx equipment and IT equipment to process and store the necessary data.
Contract ManagementYellow1.3Needs focus in this area to properly manage prime and subcontracts. As XXXXXXXXXXX wins contracts and manages subcontractors, the proper procedures must be put in place.
Billing ProcessesGreen1.1Has a system in place but will need to develop it as they win more business.
Business Development / Marketing / SalesGreen1.4Has good BD knowledge but needs help in working with the Federal Government and those agencies working with xxxxx applications.
Proposal Development and ManagementRed1.5Has limited knowledge but needs help working with the Federal Government.
Business CaptureRed1.4Has limited knowledge but needs help working with the Federal Government.
FAR and DFARS TrainingPurpleHas employees with extensive prior experience.
Executive Leadership and CoachingRed1.7Needs help developing leadership team knowledge, especially knowledge related to working with the Government.
Developing Processes Winning Research and Development ContractsYellow1.5Needs more expertise in developing and working Federal research and development topics.
Facilities and Plant Management (Security, OSHA standards, etc.)
Government Approved Accounting System

Rating Key:

None
Minimal
Acceptable
Good
Advanced

Eng & Technical Assessment Area Evaluated Assessment of Protégé WBS to Address Need Comments

Engineering and Technical (Technology Transfer) Capabilities Assessment

Agile Software DevelopmentYellow2.1Has some skills in this area but has limited experience in Government for xxxxxx. Agile software development will help provide more timely software to the Government.
Biotechnology for GovernmentYellow2.2Has biotechnology knowledge. They will need to advance their skills as they work with biotech in Government systems. As XXXXXXXXXXX delivers the solution, they will need help in understanding how the Government processes biotechnology and human samples.
Commercial Software DevelopmentGreen2.1XXXXXXXXXXX has good development skills for the commercial market but there is room for improvement.
Packaging and DeliveryYellow2.3XXXXXXXXXXX has some experience in this area but needs more training. The solution will require xxxxx to provide xxxxx, which must be carefully delivered, stored and processed.
Government Customer SupportRed2.3Has limited experience with Government customers. Will have to interface with Government systems for which they have no experience and will be working with agencies that have complex requirements.
Working with Government Technical SpecificationsYellow2.3Has some experience with Government customers and their technical specifications. They will be working with complex Warfighter requirements and regulations.
Commercialization of TechnologyRed2.1As with most small technology companies, XXXXXXXXXXX will need assistance in crossing the gap from research and development work to commercially available products. XXXXXXXXXXX has limited experience in this area. Commercialization will be needed to get the eventual solution to the Warfighter.
Working with SBIRs/STTRsYellow2.1, 1.2Has some experience in this area, especially with DoD. The Air Force has very specific needs for their Airmen. Being able to address these needs is critical to success.
Health, HIPPA and Safety PlanYellow1.1Has some experience in this area. This is extremely important as they handle medical samples and information. Data must be carefully handled and must be secure throughout the entire delivery process. All health information must be stored in secure locations and must protect individual identities.
Quality SystemsRed2.1Has minimal experience in this area but it is an important need. Specifically, will require xxxxx specific quality processes.
Certifications (ISO, CMMI, etc.)
Supply Chain Management
Hazardous Material Processes

Rating Key:

None
Minimal
Acceptable
Good
Advanced

&"-,Bold"&14Attachment 2 - Comprehensive Needs Assessment

Page &P of &N Revised: 25 Jun 24

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