ESSCA_DRFP_Attachment_L-3B_Cost_Forms_Offeror_Only.xlsx
XLSX spreadsheet 172 KB Posted
- Attached to
- Engineering Services and Science Capability Augmentation (ESSCA) Federal contract opportunity
- Solicitation number
- NNM16568754R
About this file
ESSCA DRFP Attachment L-3B
View the file
Other files for this federal contract opportunity
Show all 50
Engineering Services and Science Capability Augmentation (ESSCA) has more files on GovTribe.
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
Index Engineering Services and Science Capability Augmentation (ESSCA), RFP Number NNM16568754R
| Tab | Title | Specific Instruction |
| J | Development of Adjusted Subcontractor Fully Burdened Rates (SFBR) with Prime Offeror Burdens | This form is provided as a means to adjust subcontractor’s FBR/IDIQ rates by adding any additional prime contractor burdens to calculate a subcontractor fully burdened rate (SFBR). |
| K | Composite IDIQ Rate Development | This form is utilized to develop blended rates if the offerors teaming arrangement consists of multiple companies (e.g. prime and subcontractors labor) to perform the duties of a full WYE. Indicate the percentage of participation proposed for each labor rate. If the offeror proposes to have one company work 100% for a particular labor category then indicate 100% in the form. The Prime should fill out this form using fully burdened IDIQ rates from each company (Tab A). The formulas in colored cells will automatically calculate the blended rate. |
| L | Summary of Proposed Composite IDIQ Rates by Contract Year | This form inputs the composite rate into a table that can be used to complete Attachment J-7 of the model contract. |
&"Arial,Regular"&10NNM16568754R
L-5b-&P
Tab J
| Development of Adjusted Subcontractor Fully Burdened Rates (SFBR) | ||||||||||||
| With Prime Offeror Burdens | ||||||||||||
| NASA Labor Category Descriptions (LCDs) | Subcontract | Contract Mgmt | ADJUSTED | ADJ | ADJ | ADJ | ADJ | ADJ | ADJ | ADJ | ||
| FBR1 | G&A2 | OTHER2 | Rate 2 | SBFR3 | SBFR3 | SBFR3 | SBFR3 | SBFR3 | SBFR3 | SBFR3 | SBFR3 | |
| example: | 5.0% | 5.0% | 0% | CY 1 | CY 2 | CY 3 | CY 4 | CY 5 | CY 6 | CY 7 | CY 8 | |
| Major Subcontractor ABC: | ||||||||||||
| Subject Matter Expert 3 (SME-3) | $15.00 | $0.75 | $0.79 | $0.00 | $16.54 | |||||||
| Subject Matter Expert 2 (SME-2) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Subject Matter Expert 1 (SME-1) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Major Subcontractor XYZ: | ||||||||||||
| Engineer/Scientist 5 (ES-5) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Engineer/Scientist 4 (ES-4) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Engineer/Scientist 3 (ES-3) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Engineer/Scientist 2 (ES-2) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Engineer/Scientist 1 (ES-1) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Engineering Technician 6 (ET-6) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Engineering Technician 5 (ET-5) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Engineering Technician 4 (ET-4) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Engineering Technician 3 (ET-3) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Engineering Technician 2 (ET-2) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Engineering Technician 1 (ET-1) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Minor Subcontractor PDQ: |
| Note 1 The FBR should tie to the rates proposed in that SubOfferor's FBR template TAB A |
| Note 2 If a rate is not applicable then no further input is required in that column. Contract Management Rate should be applied on the allocation base that was used to calculate the rate. Tab D Section 3 |
| Note 3 The offeror SBFR is Subcontractor Fully Burdened Rate |
| Note: The offeror may add rows as needed to apply burdens to the subcontractor rates included in the composite rate |
&"Arial,Regular"&10NNM16568754R
Tab J L-5b-&P
Tab K
| To Be completed by the Prime Offeror |
| COMPOSITE IDIQ RATE DEVELOPMENT |
| Development of Contract Rates Weighted For Prime Offeror and Subcontractor Participation Mix |
| If the offerors teaming arrangement consists of multiple companies (e.g. prime and sub labor) to perform the duties of a full WYE then |
| indicate the percentages by company to establish a blended rate. If one company is 100% for a WYE then indicate that as 100%. |
| Labor Mix | NASA Labor Category Position Descriptions (LCPDs) | Usage | CY 1 | CY 2 | CY 3 | CY 4 | CY 5 | CY 6 | CY 7 | CY 8 |
| Prime | 50% | $10.00 | $10.27 | $10.55 | $10.83 | $11.12 | $11.42 | $11.73 | $12.05 | |
| Major Subcontractor ABC | 10% | $8.00 | $8.22 | $8.44 | $8.67 | $8.90 | $9.14 | $9.39 | $9.64 | |
| Major Subcontractor XYZ | 20% | $9.50 | $9.76 | $10.02 | $10.29 | $10.57 | $10.85 | $11.15 | $11.45 | |
| Minor Sub PDQ | 20% | $9.00 | $9.24 | $9.49 | $9.75 | $10.01 | $10.28 | $10.56 | $10.85 | |
| Subject Matter Expert 3 (SME-3) | 100% | $9.50 | $9.76 | $10.02 | $10.29 | $10.57 | $10.85 | $11.15 | $11.45 | |
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Subject Matter Expert 2 (SME-2) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Subject Matter Expert 1 (SME-1) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Engineer/Scientist 5 (ES-5) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Engineer/Scientist 4 (ES-4) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Engineer/Scientist 3 (ES-3) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Engineer/Scientist 2 (ES-2) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Engineer/Scientist 1 (ES-1) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Engineering Technician 6 (ET-6) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Engineering Technician 5 (ET-5) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Engineering Technician 4 (ET-4) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Engineering Technician 3 (ET-3) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Engineering Technician 2 (ET-2) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| 0% | ||||||||||
| Engineering Technician 1 (ET-1) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Notes: |
| Areas within the table that are white require Offeror input. Color areas contain formulas that may be adjusted by the Offeror as necessary, but the end result is that the spreadsheet must be self-calculating in the same areas as was provided by the Government |
| If the "% usage" varies among the Prime Offeror, Major Subcontract, Interdivisional, and/or Minor Subcontract weightings by contract year, then the Offeror is to add additional columns and/or rows as necessary and adjust the formula(s) accordingly. |
| Subcontractor rates shall trace/match to the Tab A of their individual EPM |
&"Arial,Regular"&10NNM16568754R
Tab K L-5b-&P
Tab L
Summary of Proposed Composite IDIQ Rates by Contract Year
NASA Standard Labor Category (SLC) CY 1 CY 2 CY 3 CY 4 CY 5 CY 6 CY 7 CY 8
| Subject Matter Expert 3 (SME-3) | $9.50 | $9.76 | $10.02 | $10.29 | $10.57 | $10.85 | $11.15 | $11.45 |
| Subject Matter Expert 2 (SME-2) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Subject Matter Expert 1 (SME-1) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Engineer/Scientist 5 (ES-5) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Engineer/Scientist 4 (ES-4) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Engineer/Scientist 3 (ES-3) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Engineer/Scientist 2 (ES-2) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Engineer/Scientist 1 (ES-1) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Engineering Technician 6 (ET-6) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Engineering Technician 5 (ET-5) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Engineering Technician 4 (ET-4) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Engineering Technician 3 (ET-3) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Engineering Technician 2 (ET-2) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Engineering Technician 1 (ET-1) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
&"Arial,Regular"&10NNM16568754R
Tab L L-5b-&P
File details come from the government source that posted it. Updated .