Exhibits 20-22.xlsx

XLSX spreadsheet 651 KB Posted

Attached to
Cybersecurity and Privacy Enterprise Solutions and Services (CyPrESS) Federal contract opportunity
Solicitation number
80TECH21R0007
Issued by
National Aeronautics and Space Administration

About this file

This document contains templates and instructions for developing pricing proposals for a potential indefinite-delivery, indefinite-quantity contract opportunity with the National Aeronautics and Space Administration. The Cybersecurity and Privacy Enterprise Solutions and Services contract will provide cybersecurity and privacy solutions and services including program management support, oversight support, standards and engineering, and security services to all NASA centers and facilities. The anticipated contract type is a single-award, cost-plus-award-fee IDIQ with both cost-reimbursable and firm-fixed-price contract line items. The period of performance includes a 20-month base period and four 24-month option periods. Offerors must hold a Top Secret facility clearance by the anticipated proposal due date in the second quarter of 2021. The templates include fully burdened labor rate worksheets for prime contractors and subcontractors to develop fixed-price pricing for sample task orders. Instructions are provided for completing the templates and developing composite rates.

View the file

Other files for this federal contract opportunity

Other files attached to Cybersecurity and Privacy Enterprise Solutions and Services (CyPrESS), newest first.
File Type Posted
CyPrESS DRFP Questions and Answers.pdf PDF
Industry Day - CyPrESS April 19 2021.pdf PDF
NASA Industry Day -Registered CyPrESS Attendees.xlsx XLSX spreadsheet
CyPrESS Industry Day Registration.pdf PDF
Draft Request for Proposals 80TECH21R0007 (CyPrESS).pdf PDF
Historical Data - HQ - HITSS_III_RFP_Attach._A_-PWS Page 295.pdf PDF
Historical Data - GSFC GITISS - NNG16VU01C.pdf PDF
Historical Data - NICS Contract - Performance Work Statement.pdf PDF
Historical Data - Historical Metrics.pdf PDF
Historical Data - SSC PWS.pdf PDF
Historical Data - Estimated Historical Labor.pdf PDF
Historical Data - MITS II-pws section 3.pdf PDF
Historical Data - GSFC SES II - NNG15CR67C.pdf PDF
Exhibits 20-22.pdf PDF
Enclosure BB - CyPrESS CPAF PEP Core Plus IDIQ Services.pdf PDF
Exhibits 1A-1C.xlsx XLSX spreadsheet
Attachment H - Small Business Subcontracting Plan Cover Page.pdf PDF
Attachment E - DD Form 254 Contract Security Classification Specification.pdf PDF
Attachment E - Attachment 2 to DD Form 254_SBU_20210125 DRAFT.pdf PDF
Attachment I - IAGP.pdf PDF
Enclosure EE CyPrESS Labor Categories.xlsx XLSX spreadsheet
Enclosure DD - GPM-Specified Non-Mgmt DL Categories - DL Hours and PDs Enclosure.pdf PDF
Exhibit 23 PastPerfQues.pdf PDF
Attachment Q - Fixed Price Rate Matrix.pdf PDF
Attachment J - OCI Avoidance Plan Cover Page.pdf PDF
Attachment F - Personal Identiy Verification (PIV) Card Issuance Procedures.pdf PDF
Attachment E - DD Form 254 Cover Page.pdf PDF
Attachment B - Applicable Documents List.pdf PDF
Attachment A - Performance Work Statement.pdf PDF
80TECH21R0007 (CyPrESS) Draft Request For Proposals.pdf PDF
Enclosure CC - Cover Page.pdf PDF
Attachment P - DIRECT LABOR RATES AND INDIRECT RATES AND FEE MATRICES.pdf PDF
Attachment O - Wage Determinations.pdf PDF
Attachment O - Wage Determinations Cover Page.pdf PDF
Attachment N - Phase-in Plan Cover Page.pdf PDF
Attachment I - Installation Accountable Government Property (IAGP) Cover Page.pdf PDF
Enclosure CC - IT Security Management Plan Template.pdf PDF
Enclosure AA - Quality Assurance Surveillance Plan (QASP).pdf PDF
Exhibits 2-19.xlsx XLSX spreadsheet
Attachment L - IT Security Management Plan Cover Page.pdf PDF
Attachment K - Contract Management Plan Cover Page - Copy.pdf PDF
Attachment G - Safety and Health Plan Cover Page.pdf PDF
Attachment E - Attachment 1 to DD Form 254_20210125 DRAFT.pdf PDF
Attachment D - Financial Management Reporting.pdf PDF
Attachment C - Data Requirements Descriptions.pdf PDF
Show all 45

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

Exhibit 20 TOPT-IDIQ-FFP

Task Order Pricing Template (TOPT-IDIQ-FFP)
Required of the Prime Contractor Only
Total Price
BaseOption Period 1Option Period 2Option Period 3Option Period 4
Annual HoursGFY 2022GFY 2023GFY 2024GFY 2025GFY 2026GFY 2027GFY 2028GFY 2029GFY 2030
NASA Standard Labor CategoriesFBRCostFBRCostFBRCostFBRCostFBRCostFBRCostFBRCostFBRCostFBRCost
All-Source Analyst401- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Analyst Specialist 280- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Application Programmer 2134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Business Analyst254- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Business Analyst 2167- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Business Systems Analyst134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Computer Security System Specialist 2655- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Computer Systems Analyst667- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Computer Systems Analyst 21,060- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Configuration Management Specialist 3134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cyber Defense Analyst3,476- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cyber Defense Forensics Analyst401- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cyber Defense Incident Responder535- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cyber Defense Infrastructure Support Specialist669- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cyber Policy and Strategy Planner134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cyber Workforce Developer and Manager134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cybersecurity Analyst669- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cybersecurity Lead401- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cybersecurity Specialist I802- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cybersecurity Specialist II669- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cybersecurity Specialist III401- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
CyberSystems Security Engineer198- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
CyberSystems Security Engineer 2181- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
CyberSystems Security Engineer 3576- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Data Reporting Analyst267- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Database Administrator267- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Desktop Support Analyst134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Functional Analyst21- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Functional Expert Consultant Level II84- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Incident Response201- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Information Assurance/Security Specialist 2134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Information Assurance/Security Specialist 3134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Information Assurance/Security Specialist 4134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Information Assurance/Security Specialist Senior134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Information Engineer202- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Information Engineer 260- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Information Security Analysts9,968- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Information System Training Specialist13- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Information Technologist 3187- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Auditor134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Data Analyst602- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Investment/Portfolio Manager134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Security Engineer I535- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Security Engineer II267- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Security Engineer III602- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Security Lead266- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Security Specialist 2415- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
IT Security Specialist 3495- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Lead Engineer336- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Network Engineer1,070- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Network Systems Security Engineer134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Product Support Specialist1,872- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Product Support Specialist 2134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Project Control Specialist12- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Project Manager669- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Project Manager 2535- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Project Manager 3134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Project Manager Master134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Project Manager Senior134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Requirements Engineer480- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Research & Development Specialist719- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Security Analyst648- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Security Architect267- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Design Engineer20- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Engineer159- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Requirements Manager281- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Senior Test Engineer118- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Software Engineer1,070- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Software Developer134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Subject Matter Expert Master340- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Systems Administrator2,859- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Systems Engineer2,006- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Systems Engineer 2802- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Systems Engineer 3645- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Systems Engineer 41,424- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Systems Security Administrator669- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Systems Security Engineer1,070- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Systems Support Specialist134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Task Manager134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Technical Manager535- 0
Technical Writer134- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Threat/Warning Analyst267- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Training Specialist267- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Vulnerability & Mitigation223- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Total 48,891 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0

INSTRUCTIONS FOR COMPLETING THE TOPT-IDIQ-FFP DELIVERY ORDER TEMPLATE

This template is used for pricing the Fixed Price Delivery Order and is required of the Prime Offeror only

This template is used to develop a price based on resources specified by the Government. It is used for comparison to other Offerors and will be presented to the SSA for contract award selection purposes. The only discrimator in the in the IDIQ FFP price will be the Fully-Burdened Labor Rates.

The template consists of 3 labor sections, (1) Specified Resources by year, (2) fuly burdened labor rates, and (3) fully burdened labor price.

Section 1. Specified Resources By Base Period and Option Periods:

This first section shows the Specified Resources provided by the Government. Offerors will price the same resources for each GFY.

Section 2. Fully Burdened Labor Rates:

The Fully Burdened Labor rates are linked from the [FBR-FFP] worksheet. It includes all indirect rates and also profit

Section 3. Fully Burdened Labor Price:

This section calculates the Fully Burdened Labor Cost by multiplying the Specified Resources by the Fully Burdened Labor Rates.

Profit Profit is included in the Fully Burdened Labor Rates

IMPORTANT NOTES

This workbook contains links and formulae design to expedite the flow of information, and facilitate the development of the Total Delivery Order Price. However, the proposal is the product of the Offeror and as such, it is the Offeror's responsibility to review all links and formulae to determine that they are accurate and consistent with the Offeror's intent, and that the results are representative of the intended proposed price. Errors caused by inaccurate links or formulae included in this worksheet by the Government are not the responsibility of the Government, since it is the contractor's responsibility to change or correct any erroneous links or formulae. The Offeror shall review all links and formulae for accuracy and logic.

Exhibit 21 FBR-FFP

FULLY BURDENED RATES TEMPLATE - FIRM FIXED PRICE (FBR-FFP)

Company Name

Check a box on the right[ ] Prime Contractor:{ } GFY 2022 (Base){ } GFY 2027 (Option Period 2)Subcontractor's Profit RateFor Calculation in Column M
{ } GFY 2023 (Base){ } GFY 2028 (Option Period 3)Base Labor Escalation Rate
[ ] Significant Subcontractor:{ } GFY 2024 (Option Period 1){ } GFY 2029 (Option Period 3)Prime Offeror Burden Rate on Subcontractor, if ApplicableFor Calculation in Columns S, T & U
{ } GFY 2025 (Option Period 1){ } GFY 2030 (Option Period 4)Prime Contractor's Profit RateFor Calculation in Column AA
{ } GFY 2026 (Option Period 2)
The area below this yellow row is to be completed by the Prime Contractor and all Significant SubcontractorsThe area below this brown row is the subcontract price input area to be completed by the Prime Contractor with FBR data provided by all subcontractors
NASA Standard Labor Category (SLC)Direct Labor Base Rate (From IRAP Template)Overhead Rate (From FPRA, FPRR, or OHT)Overhead CostFringe Rate (From FPRA, FPRR, or OHT)Fringe Cost @G&A Rate (From FPRA, FPRR or GAT)G&A CostFCCOMOtherSubTotalProfit
IDIQ FFP (Subcontractor only)IDIQ FFP Fully-Burdened Labor RatesSubcontractor "A" FBR/hr*Subcontractor "B" FBR/hr*Subcontractor "C" FBR/hr*Subcontractor "A" FBR + Prime Burdened RateSubcontractor "B" FBR + Prime Burdened RateSubcontractor "C" FBR + Prime Burdened RatePercent UsageComposite - FFP(The profit rate is shown in Cell P9)USAGE SUMMARY
@@% Usage Prime% Usage Subcontractor "A"% Usage Subcontractor "B"% Usage Subcontractor "C"Prime & Sub FBRPrime & Sub FBR With Profit ***(For FFP TO)Total Usage (Used as a check. S/B 100%)Base Overtime Rate For Pricing CPAF EffortFully-Burdened Overtime Rate For Pricing IDIQ Task Order Labor
Engineer III (Example)$ 50.0020%10.0035%21.0010%8.10- 0- 089.10- 0$89.1056.0066.0060.00$ 56.00$ 66.00$ 60.0070%20%10%0%$ 80.17$ 80.17Ok$75.00$120.26
All-Source Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Analyst Specialist 2- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Application Programmer 2- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Business Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Business Analyst 2- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Business Systems Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Computer Security System Specialist 2- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Computer Systems Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Computer Systems Analyst 2- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Configuration Management Specialist 3- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Cyber Defense Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Cyber Defense Forensics Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Cyber Defense Incident Responder- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Cyber Defense Infrastructure Support Specialist- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Cyber Policy and Strategy Planner- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Cyber Workforce Developer and Manager- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Cybersecurity Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Cybersecurity Lead- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Cybersecurity Specialist I- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Cybersecurity Specialist II- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Cybersecurity Specialist III- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
CyberSystems Security Engineer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
CyberSystems Security Engineer 2- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
CyberSystems Security Engineer 3- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Data Reporting Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Database Administrator- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Desktop Support Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Functional Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Functional Expert Consultant Level II- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Incident Response- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Information Assurance/Security Specialist 2- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Information Assurance/Security Specialist 3- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Information Assurance/Security Specialist 4- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Information Assurance/Security Specialist Senior- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Information Engineer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Information Engineer 2- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Information Security Analysts- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Information System Training Specialist- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Information Technologist 3- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
IT Auditor- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
IT Data Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
IT Investment/Portfolio Manager- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
IT Security Engineer I- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
IT Security Engineer II- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
IT Security Engineer III- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
IT Security Lead- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
IT Security Specialist 2- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
IT Security Specialist 3- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Lead Engineer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Network Engineer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Network Systems Security Engineer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Product Support Specialist- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Product Support Specialist 2- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Project Control Specialist- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Project Manager- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Project Manager 2- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Project Manager 3- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Project Manager Master- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Project Manager Senior- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Requirements Engineer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Research & Development Specialist- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Security Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Security Architect- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Senior Design Engineer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Senior Engineer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Senior Requirements Manager- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Senior Test Engineer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Software Engineer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Software Developer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Subject Matter Expert Master- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Systems Administrator- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Systems Engineer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Systems Engineer 2- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Systems Engineer 3- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Systems Engineer 4- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Systems Security Administrator- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Systems Security Engineer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Systems Support Specialist- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Task Manager- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Technical Manager- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Technical Writer- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Threat/Warning Analyst- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Training Specialist- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
Vulnerability & Mitigation- 0- 0- 0- 0- 0$0.00- 0- 0- 0$ - 0$ - 0ERROR
ADDITIONAL NOTES TO THE FBR WORKSHEET:
@ Insert formula to calculate the Fringe Benefit cost in accordance with the contractor's accounting policies. The formula included in this worksheet may not be accurate for all Offerors.
@@ Significant subcontractors shall stop here in their individual FBR worksheet, and provide their FBRs to the Prime Contractor.
* These columns shall include the fully-burdened labor rates for significant subcontractors by SLC. This may be linked from worksheets inserted into this workbook by the prime Offeror, one for each subcontractor, or the data may be inputted.
** Based on the Prime Contractor's Accounting System, the Prime contractor may apply a burden rate to the significant subcontractors' FBRs, if applicable.
*** This column shows the calculated Prime Contractor's and significant subcontractors' composite fully burdened labor rates by SLC, including profit; these rates shall match the FBRs in the Model Contract attachments.

INSTRUCTIONS FOR COMPLETING THE FBR-FFP TEMPLATE

THIS WORKSHEET SHALL BE COMPLETED BY THE PRIME CONTRACTOR AND ALL SIGNIFICANT SUBCONTRACTORS

A separately identified and labeled Exhibit 21 shall be submitted for each individual GFY from the Prime Offeror and each individual Significant Subcontractor.

Instructions For Both Prime Offerors And All Subcontractors All Prime Offerors and each Significant Subcontractor shall prepare this worksheet through column N, under the yellow highlighted row. This worksheet is used to provide insight into the development of the FBR for the IDIQ FFP effort for each SLC for each contract year. A separate fully-burdened rate (FBR) calculation is required for each SLC for each contract year for the entire contract period.

The template starts with the base direct labor rates for the first contract year for each SLC . Indirect rates, (Overhead, Fringe Bemefit, G&A, etc) are applied to the base in accordance with the contractor's accounting system and policies. The indirect rates in this worksheet shall be in accordance with the contractor's accounting system). If the offeror's accounting system comprises additional indirect rates than those shown in the template, (OHT, Fringe Benefit, and GAT), additional columns shall be added to this template to accomodate the offeror's additional indirect rates. Please note that some Offerors' accounting system may have their Overhead and Fringe Benefit indirect rates shown separately, while other Offerors may have those two rates combined into one rate. If indirect rates used in this worksheet are obtained from a Forward Pricing Rate Recommendation (FPRR), or Forward Pricing Rate Approval (FPRA), the Offeror shall include a copy of the FPRR or FPRA in the Cost Narrative in Volume III of the proposal. If the FPRR or FPRA does not include all 8 years, 8 months of the contarct, then the indirect rates exhbits shall be included in this workbook for the years not included in the FPRR or FPRA.

Base labor rates for GFY 2023 through GFY 2030 shall be calculated using annual escalation factors. The basis of the escalation factor shall be explained and supported in the Cost Narrative provided in Volume III of the proposal. The worksheet is designed to accomodate the inclusion of the annual escalation factors. Note: Refer to FAR Clause 52.222-43, Fair Labor Standards & Service Contract Act – Price adjustment, with respect to escalation for non-exempt personnel.

Instructions Specific To Significant Subcontractors Significant Subcontractors shall complete this worksheet through column N, (under the yellow highlighted row), and provide the FBRs per SLC per year to the Prime Offeror for incorporation into the Prime Offeror's FBR. Unless there is a fee-sharing arrangement with the Prime contractor, fee is added to the FBR and incorporated in Column M. The basis for the fee shall be explained and supported by the subcontractor in its Cost Narrative in Volume III of the proposal. The subcontractor's detailed proposal shall be submitted directly to the Government .

Instructions Specific To Prime Offerors Prime Offerors are to contimue completing this worksheet through the columns under the green highlighted row. These columns are used to accomodate the FBR for all subcontractors (nonsignificant and significant) to be included in the development of the Prime Offeror's composite FBRs. If necessary, columns shall be added to accomodate more than the three subcontractors included in the worksheet. (Actual subcontractor's names shall be used instead of "Subcontractor A", etc.) If the Prime Contractor's accounting system includes the addition of a burden rate to its subcontractors cost, the burdened rate is added here (Columns S, T, & U). The burden rate shall be explained and supported in the Cost Narrative in Volume III of the proposal. If the applied subcontractor rate is different from the G&A rate in the GAT template, provide an explanation and support in the Cost Narrative in Volume III of the proposal. The Percentage Usage Columns (Columns V, W, X, & Y) are provided so that the Prime Contractor may weight the proposed direct labor per SLC for the Prime Contractor and all subcontractors, nonsignificant and significant. A weighted average is then calculated for each SLC. (See the formula in the example provided in the worksheet for years 1 and 2,) NOTE: The total usage percentage of the Prime Contractor and all subcontractors shall total 100%. A "test" column, (AB) is used to verify the total percentage.

Column M: For the Prime Contractor, no profit is added in this column. Profit is added in Column AA.

Formulae and links shall be included in the worksheet as much as is possible to accomodate changes in any cell to facilitate easy recalculation of any FBR.

GFY 2023 THROUGH GFY 2030:

An escalation factor may be applied to the previous year's base rate for GFY 2023 through 2030. Formulas shall be used to facilitate the escalation of the FBR as shown in the worksheet for GFY 2023.

Note: Refer to FAR Clause 52.222-43, Fair Labor Standards & Service Contract Act – Price adjustment, with respect to escalation for non-exempt personnel.

The FBRs calculated in this worksheet shall be linked to the FRBs used in worksheet [TOPT-IDIQ FFP] to calculate the final proposed price for the FFP Sample Task Order.

IMPORTANT NOTES

This workbook contains links and formulae design to expedite the flow of information, and facilitate the development of the Total Task Order Price. However, the proposal is the product of the Offeror and as such, it is the Offeror's responsibility to review all links and formulae to determine that they are accurate and consistent with the Offeror's intent, and that the results are representative of the intended proposed price. Errors caused by inaccurate links or formulae included in this worksheet by the Government are not the responsibility of the Government, since it is the contractor's responsibility to change or correct any erroneous links or formulae. The Offeror shall review all links and formulae for accuracy and logic.

Also, if columns or rows are added to this worksheet to accomodate the Offeror's accounting system (E.g. aditional indirect rates), or the number of subcontractors (more than 3), then it is the contractor's responsinbility to change formulae and links as necessary.

Exhibit 22 MST-FBR-IDIQ

USED FOR DEVELOPING THE PRIME OR SIGNIFICANT SUBCONTRACTOR FFP FBR

Higher-Tier Contractor (Subcontractor) Name:
Nonsignificant SubcontractorNASA SLCType of Contract With Lower Tier SubcontractorFee Rate in FBRGFY 2022 FBRGFY 2023 FBRGFY 2024 FBRGFY 2025 FBRGFY 2026 FBRGFY 2027 FBRGFY 2028 FBRGFY 2029 FBRGFY 2030 FBR
Annual Escalation Factor
Example:
ABC, Inc.
Escalation Factor2.0%3.0%2.9%2.9%2.9%2.9%2.9%2.9%
Analyst 1Time & Material6.50%$49.89$50.89$52.41$53.93$55.50$57.11$58.76$60.47$62.22
Analyst 3Time & Material6.50%$53.25$54.32$55.94$57.57$59.24$60.95$62.72$64.54$66.41
Engineer 2Time & Material6.50%$56.90$58.04$59.78$61.51$63.30$65.13$67.02$68.96$70.96
Engineer 3Time & Material6.50%$56.90$58.04$59.78$61.51$63.30$65.13$67.02$68.96$70.96
XYZ Company
Escalation Factor1.9%2.5%2.2%2.2%2.2%2.2%2.2%2.2%
Quality Engineer IIFirm Fixed Price5.5%$55.50$56.55$57.97$59.24$60.55$61.88$63.24$64.63$66.05
Safety EngineerFirm Fixed Price5.5%$60.00$61.14$62.67$64.05$65.46$66.90$68.37$69.87$71.41
System Operator IFirm Fixed Price5.5%$48.00$48.91$50.13$51.24$52.36$53.52$54.69$55.90$57.13

(Identify Nonsignificant Subcontractor) NASA SLC Type of Contract With Lower Tier Subcontractor Fee Rate in FBR GFY 2022 FBR GFY 2023 FBR GFY 2024 FBR GFY 2025 FBR GFY 2026 FBR GFY 2027 FBR GFY 2028 FBR GFY 2029 FBR GFY 2030 FBR

Base PeriodOption Period 1Option Period 2Option Period 3Option Period 4
Annual Escalation Factor

(Identify Nonsignificant Subcontractor) NASA SLC Type of Contract With Lower Tier Subcontractor Fee Rate in FBR GFY 2022 FBR GFY 2023 FBR GFY 2024 FBR GFY 2025 FBR GFY 2026 FBR GFY 2027 FBR GFY 2028 FBR GFY 2029 FBR GFY 2030 FBR

Base PeriodOption Period 1Option Period 2Option Period 3Option Period 4
Annual Escalation Factor

(Identify Nonsignificant Subcontractor) NASA SLC Type of Contract With Lower Tier Subcontractor Fee Rate in FBR GFY 2022 FBR GFY 2023 FBR GFY 2024 FBR GFY 2025 FBR GFY 2026 FBR GFY 2027 FBR GFY 2028 FBR GFY 2029 FBR GFY 2030 FBR

Base PeriodOption Period 1Option Period 2Option Period 3Option Period 4
Annual Escalation Factor

(Identify Nonsignificant Subcontractor) NASA SLC Type of Contract With Lower Tier Subcontractor Fee Rate in FBR GFY 2022 FBR GFY 2023 FBR GFY 2024 FBR GFY 2025 FBR GFY 2026 FBR GFY 2027 FBR GFY 2028 FBR GFY 2029 FBR GFY 2030 FBR

Base PeriodOption Period 1Option Period 2Option Period 3Option Period 4
Annual Escalation Factor

INSTRUCTIONS FOR COMPLETING THE MST TEMPLATE

This template is required of Prime Offerors and all Significant Subcontractors.

Examples showing how this template is to be completed is provided in red above.

The Fully Burdened Rates (FBR) for Nonsignificant Subcontractors provided in this worksheet shall be used to develop the IDIQ FBRs for the Prime Offeror or the Signficant Subcontractor for the FFP Task Order.

This template provides for the following.

1. The type of contract between the nonsignificant subcontractor and the higher-tier entity, (Prime Offeror or Signifiant Subcontractor)

2. The fully-burdened labor rates per year for all nonsignifiant subcontractor's SLCs included in the higher-tier entity's FBR development

3. The fee rate included in the Nonsignificant Subcontractor's FBR

4. Annual Escalation Factor applied to the Nonsignificant Subcontractor's base direct labor rates to develop the FBR for he following years (2 through 510 of the contract

It is the Prime Offeror's and Significant Subcontractor's responsibility to evaluate each of their Nonsignificant Subcontractor's proposal.

The evaluations of the Nonsignificant Subcontractors shall be documented by the Prime Offeror or Significant Subcontractors in the Cost Narrative in Volume III of the Prime Offeror's or Significant Subcontractor's proposal. The narrative shall provide the rationale and basis for the Prime Offeror's or Significant Subcontractor's opinion and decision on each nonsignificant subcontractor's FBRs.

The worksheet has space to accomodate 4 nonsignificant subcontractors; Offerors shall add rows as necessary to accomodate more subcontractors if necessary.

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