Attachment_L-07_CF_EPM_Template.xlsx
XLSX spreadsheet 743 KB Posted
- Attached to
- Joint Operations and Integrated Systems Technology (JOIST) Federal contract opportunity
- Solicitation number
- NNJ17580323R
About this file
Attachment L-07 CF
View the file
Other files for this federal contract opportunity
Show all 50
Joint Operations and Integrated Systems Technology (JOIST) 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
TRT - Baseline A
| TECHNICAL RESOURCES TEMPLATE - BASELINE A (TRT-Baseline A) | SOW 1.0 Baseline A: NAMIS Services |
| Prime Contractor Name: |
PRIME AND ALL SUBCONTRACT (INCLUDING MINOR SUBCONTRACTORS) RESOURCES COMBINED
| SOW | SOW | SOW | SOW | SOW | Total CY 1 | Skill mix | |
| Standard Labor Category | 1.2 FTEs | 1.3 FTEs | 1.4 FTEs | 1.5 FTEs | 1.6 FTEs | SOW 1.0 FTEs | Ratio |
| FTEs | |||||||
| Ex: Business Specialist 3 | 0.5 | 1.0 | 1.5 | 1.5 | 1.5 | 6.0 |
| Business Specialist I | 0.0 | ERROR:#DIV/0! | |||||
| Business Specialist II | 0.0 | ERROR:#DIV/0! | |||||
| Business Process Specialist I | 0.0 | ERROR:#DIV/0! | |||||
| Business Process Specialist II | 0.0 | ERROR:#DIV/0! | |||||
| Business Process Specialist IIII | 0.0 | ERROR:#DIV/0! | |||||
| Business Process Specialist IV | 0.0 | ERROR:#DIV/0! | |||||
| Database Analyst I | 0.0 | ERROR:#DIV/0! | |||||
| Database Analyst II | 0.0 | ERROR:#DIV/0! | |||||
| Database Analyst III | 0.0 | ERROR:#DIV/0! | |||||
| Graphic Specialist I | 0.0 | ERROR:#DIV/0! | |||||
| Graphic Specialist II | 0.0 | ERROR:#DIV/0! | |||||
| Graphic Specialist III | 0.0 | ERROR:#DIV/0! | |||||
| IT Professional I | 0.0 | ERROR:#DIV/0! | |||||
| IT Professional II | 0.0 | ERROR:#DIV/0! | |||||
| IT Professional III | 0.0 | ERROR:#DIV/0! | |||||
| Program Manager | 0.0 | ERROR:#DIV/0! | |||||
| Project Manager | 0.0 | ERROR:#DIV/0! | |||||
| Quality Assurance Specialist | 0.0 | ERROR:#DIV/0! | |||||
| Senior Training Specialist | 0.0 | ERROR:#DIV/0! | |||||
| Software Engineer I | 0.0 | ERROR:#DIV/0! | |||||
| Software Engineer II | 0.0 | ERROR:#DIV/0! | |||||
| Software Engineer III | 0.0 | ERROR:#DIV/0! | |||||
| Software Engineer IV | 0.0 | ERROR:#DIV/0! | |||||
| Software Engineer V | 0.0 | ERROR:#DIV/0! | |||||
| Software Quality Assurance Engineer | 0.0 | ERROR:#DIV/0! | |||||
| Systems Administrator I | 0.0 | ERROR:#DIV/0! | |||||
| Systems Administrator II | 0.0 | ERROR:#DIV/0! | |||||
| Systems Administrator III | 0.0 | ERROR:#DIV/0! | |||||
| Technical Editor | 0.0 | ERROR:#DIV/0! | |||||
| Technical Writer | 0.0 | ERROR:#DIV/0! | |||||
| Training Specialist | 0.0 | ERROR:#DIV/0! | |||||
| Web Software Developer | 0.0 | ERROR:#DIV/0! | |||||
| Other: (Specify) | 0.0 | ERROR:#DIV/0! | |||||
| Total FTE Prime and All Subs | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | ERROR:#DIV/0! |
| NOTE: Examples are highlighted in red font. IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas, |
| whether or not in red font. Please remember to remove red highlighted examples from the templates in your official proposal submission. |
&"Times New Roman,Regular"&12Attachment L-07 Technical Resources Template (TRT)-CF Cost Reimbursable &A
&"Times New Roman,Regular"&12NNJ17580232R &"Times New Roman,Regular"&12L-07CF-&P
TRST - Baseline A
| TECHNICAL RESOURCES SUMMARY TEMPLATE - BASELINE A (TRST-Baseline A) |
| Prime Offeror Company Name: |
| PRIME AND ALL SUBCONTRACT (INCLUDING MINOR SUBCONTRACTORS) RESOURCES COMBINED | ||||||||
| NASA (JSC) | ||||||||
| Standard Labor Category | Incumbent Retention % | Base Period | Option 1 | Option 2 | ||||
| CY1 | CY2 | CY3 | CY4 | CY5 | CY 1 Thru CY 5 | |||
| FTE Resources Basis | FTE Resources Basis | FTE Resources Basis | FTE Resources Basis | FTE Resources Basis | Average Annual FTEs | |||
| Ex: Business Specialist 3 | 100% | 8.5 | 8.5 | 8.0 | 8.0 | 8.0 | 8.2 |
| Business Specialist I | 0.0 | |||||
| Business Specialist II | 0.0 | |||||
| Business Process Specialist I | 0.0 | |||||
| Business Process Specialist II | 0.0 | |||||
| Business Process Specialist IIII | 0.0 | |||||
| Business Process Specialist IV | 0.0 | |||||
| Database Analyst I | 0.0 | |||||
| Database Analyst II | 0.0 | |||||
| Database Analyst III | 0.0 | |||||
| Graphic Specialist I | 0.0 | |||||
| Graphic Specialist II | 0.0 | |||||
| Graphic Specialist III | 0.0 | |||||
| IT Professional I | 0.0 | |||||
| IT Professional II | 0.0 | |||||
| IT Professional III | 0.0 | |||||
| Program Manager | 0.0 | |||||
| Project Manager | 0.0 | |||||
| Quality Assurance Specialist | 0.0 | |||||
| Senior Training Specialist | 0.0 | |||||
| Software Engineer I | 0.0 | |||||
| Software Engineer II | 0.0 | |||||
| Software Engineer III | 0.0 | |||||
| Software Engineer IV | 0.0 | |||||
| Software Engineer V | 0.0 | |||||
| Software Quality Assurance Engineer | 0.0 | |||||
| Systems Administrator I | 0.0 | |||||
| Systems Administrator II | 0.0 | |||||
| Systems Administrator III | 0.0 | |||||
| Technical Editor | 0.0 | |||||
| Technical Writer | 0.0 | |||||
| Training Specialist | 0.0 | |||||
| Web Software Developer | 0.0 | |||||
| Other: (Specify) | 0.0 | |||||
| Total | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Non-Labor Resources (NLR) Cost ($) | CY1 | CY2 | CY3 | CY4 | CY5 | CY1 - CY5 |
| Material | $ - 0 | |||||
| Training | $ - 0 | |||||
| Travel | $ - 0 | |||||
| Other NLR Costs | $ - 0 | |||||
| Total NLR Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Note 1: The prime offeror shall populate the proposed FTE columns and the proposed NLR columns, inclusive of the Prime, Major and Minor subcontractors' proposed labor and nonlabor resources, respectively. It is very important that your reference column refer evaluators to all the Efficiencies or Cost Savings supporting data in the CS paragraph of Volume xx, Technical Acceptability. If the labor resources are unchanged from the resource basis, no reference is required.
| Note 2: Examples are highlighted in red font. IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas, |
| whether or not in red font. Please remember to remove red highlighted examples from the templates in your official proposal submission. |
&"Times New Roman,Regular"&12Attachment L-07 Technical Resources Template (TRT)-CF Cost Reimbursable &A
&"Times New Roman,Regular"&12NNJ17580232R &"Times New Roman,Regular"&12L-07CF-&P
LPT - Baseline A LABOR PRICING TEMPLATE - BASELINE A (LPT-Baseline A)
| Prime Contractor Name: | |
| Major Subcontractor Name: | Conversion Factor: 1 FTE = [OFI] Productive Hours |
| Base Period | Option 1 | Option 2 | |||||
| Contract | Contract | Contract | Contract | Contract | Total | ||
| NASA Standard Labor Category (SLC) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | CY 1-5 | Ref. |
| Straight-Time (ST) Hours | |||||||
| Business Specialist I | - 0 | ||||||
| Business Specialist II | - 0 | ||||||
| Business Process Specialist I | - 0 | ||||||
| Business Process Specialist II | - 0 | ||||||
| Business Process Specialist IIII | - 0 | ||||||
| Business Process Specialist IV | - 0 | ||||||
| Database Analyst I | - 0 | ||||||
| Database Analyst II | - 0 | ||||||
| Database Analyst III | - 0 | ||||||
| Graphic Specialist I | - 0 | ||||||
| Graphic Specialist II | - 0 | ||||||
| Graphic Specialist III | - 0 | ||||||
| IT Professional I | - 0 | ||||||
| IT Professional II | - 0 | ||||||
| IT Professional III | - 0 | ||||||
| Program Manager | - 0 | ||||||
| Project Manager | - 0 | ||||||
| Quality Assurance Specialist | - 0 | ||||||
| Senior Training Specialist | - 0 | ||||||
| Software Engineer I | - 0 | ||||||
| Software Engineer II | - 0 | ||||||
| Software Engineer III | - 0 | ||||||
| Software Engineer IV | - 0 | ||||||
| Software Engineer V | - 0 | ||||||
| Software Quality Assurance Engineer | |||||||
| Systems Administrator I | - 0 | ||||||
| Systems Administrator II | - 0 | ||||||
| Systems Administrator III | - 0 | ||||||
| Technical Editor | - 0 | ||||||
| Technical Writer | - 0 | ||||||
| Training Specialist | - 0 | ||||||
| Web Software Developer | - 0 | ||||||
| Other: (Specify) | - 0 | ||||||
| Subtotal ST Hours | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Straight-Time Rates |
| Business Specialist I |
| Business Specialist II |
| Business Process Specialist I |
| Business Process Specialist II |
| Business Process Specialist IIII |
| Business Process Specialist IV |
| Database Analyst I |
| Database Analyst II |
| Database Analyst III |
| Graphic Specialist I |
| Graphic Specialist II |
| Graphic Specialist III |
| IT Professional I |
| IT Professional II |
| IT Professional III |
| Program Manager |
| Project Manager |
| Quality Assurance Specialist |
| Senior Training Specialist |
| Software Engineer I |
| Software Engineer II |
| Software Engineer III |
| Software Engineer IV |
| Software Engineer V |
| Software Quality Assurance Engineer |
| Systems Administrator I |
| Systems Administrator II |
| Systems Administrator III |
| Technical Editor |
| Technical Writer |
| Training Specialist |
| Web Software Developer |
| Other: (Specify) |
| Straight-Time Labor Cost | ||||||
| Business Specialist I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Business Specialist II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Business Process Specialist I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Business Process Specialist II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Business Process Specialist IIII | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Business Process Specialist IV | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Database Analyst I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Database Analyst II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Database Analyst III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Graphic Specialist I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Graphic Specialist II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Graphic Specialist III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| IT Professional I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| IT Professional II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| IT Professional III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Project Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Quality Assurance Specialist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Senior Training Specialist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Software Engineer I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Software Engineer II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Software Engineer III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Software Engineer IV | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Software Engineer V | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Software Quality Assurance Engineer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Systems Administrator I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Systems Administrator II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Systems Administrator III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Technical Editor | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Technical Writer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Training Specialist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Web Software Developer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Other: (Specify) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL LABOR COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NOTE: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas. |
&F &A
&A
&"Times New Roman,Regular"&12NNJ17580232R &"Times New Roman,Regular"&12L-07CF-&P
MSCST - Baseline A MAJOR SUBCONTRACTOR COST SUMMARY TEMPLATE - BASELINE A (MSCST - Baseline A)
Major Subcontractor Name:
| Base | Option 1 | Option 2 | |||||
| Contract | Contract | Contract | Contract | Contract | |||
| Cost Element | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total CY 1-5 | Ref. |
| Direct Labor Hours: | |||||||
| Major Sub Straight-Time Hours | - 0 | ||||||
| Total Direct Labor Hours | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Direct Labor Cost: | ||||||
| Major Sub Direct Labor Cost | $ - 0 | |||||
| Total Direct Labor Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Overhead (OH) and Service Center (SC) Cost: | ||||||
| Major Sub OH or SC No. 1 (identify by name) | ||||||
| Base | ||||||
| Rate | ||||||
| Sub-Total Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Major Sub OH or SC No. 2 (identify by name) | ||||||
| Base | ||||||
| Rate | ||||||
| Sub-Total Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Major Sub OH or SC No. 3 (identify by name) | ||||||
| Base | ||||||
| Rate | ||||||
| Sub-Total Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total OH and SC Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Non-Labor Resources (NLRs): | ||||||
| Material | $ - 0 | |||||
| Equipment | $ - 0 | |||||
| Training/Conference | $ - 0 | |||||
| Travel | $ - 0 | |||||
| Other | $ - 0 | |||||
| Total NLR Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Sub-Total Cost $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| G&A Cost: | ||||||
| G&A Base | ||||||
| G&A Rate | ||||||
| Total G&A Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Facilities Capital Cost of Money (FCCOM): | ||||||
| FCCOM Base | ||||||
| FCCOM Rate | ||||||
| Total FCCOM Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Estimated Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Fee: | ||||||
| Fee Base | ||||||
| Fee Rate | ||||||
| Total Fee Dollars | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Major Sub Estimated Cost and Fee | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
NOTE: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas.
&"Times New Roman,Regular"&12Attachment L-07 Technical Resources Template (TRT)-CF Cost Reimbursable &A
&"Times New Roman,Regular"&12NNJ17580232R &"Times New Roman,Regular"&12L-07CF-&P
PCST - Baseline A PRIME COST SUMMARY TEMPLATE - BASELINE A (PCST-Baseline A)
| Prime Contractor Name: | |||||||
| Base | Option 1 | Option 2 | |||||
| Contract | Contract | Contract | Contract | Contract | |||
| Cost Element | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total CY 1-5 | Ref. |
| Team Direct Labor Hours: | |||||||
| Prime Contractor Straight-Time (ST) Hours |
Arevalo, Rosa: NASA JSC: The prime and each major subcontractor may link their proposed ST and OT hours per Contract Year from their respective LPT.
| - 0 | ||||||
| Major Subcontractor ST Hours | - 0 | |||||
| Minor Subcontractor ST Hours | - 0 | |||||
| Total Team Direct Labor Hours | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
Prime Labor Cost Arevalo, Rosa: NASA JSC:
The prime may link the proposed Total ST and OT labor cost per Contract Year from their LPT (Row 117; Columns D117-H117). $ - 0
Subcontractor Cost:
Arevalo, Rosa: NASA JSC:
The prime shall provide each Major Subcontractor's Proposed Price (Fully Burdened Labor & NLR costs plus Profit) per Contract Year in this section.
| Major Subcontractor No. 1 Cost (identify by name) | $ - 0 | |||||
| Major Subcontractor No. 2 Cost (identify by name) | $ - 0 | |||||
| Sub-Total Major Subcontractor Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Minor Subcontractor Price Arevalo, Rosa: NASA JSC:
The prime shall provide the Minor Sub's Proposed Price (Fully Burdened Labor and NLR plus Profit) per Contract Year in this section. If more than one Minor Sub is proposed, the Prime may add rows (as applicable), and identify each minor sub by name.
| $ - 0 | ||||||
| Total Subcontractor Cost (Cost & Fee) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Total Prime Non-Labor Resources (NLR) Cost Arevalo, Rosa: NASA JSC:
The prime shall provide their total proposed Fully Burdened NLR Cost per Contract Year in this section. They may link the dollar values from the TRST-CF (FFP) tab (Row 38; Columns D38, H38, L38, P38 and T38).
Arevalo, Rosa: NASA JSC: The prime and each major subcontractor may link their proposed ST and OT hours per Contract Year from their respective LPT.
$ - 0
Total (Prime and Sub) Labor and Prime NLR Costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Prime Indirect Cost:
Arevalo, Rosa: NASA JSC: The prime shall provide their total proposed Indirect Costs (e.g. Overhead, Fringe Benefit and G&A) per Contract Year in this section.
Expand this worksheet to include rows for any other indirect rates proposed; similar to the two rows below.
Prime Overhead Rate Khan, Wally: Khan, Wally:
Linked to OHT
Arevalo, Rosa: NASA JSC:
The prime may link the proposed Total ST and OT labor cost per Contract Year from their LPT (Row 117; Columns D117-H117).
Arevalo, Rosa: NASA JSC:
The prime shall provide each Major Subcontractor's Proposed Price (Fully Burdened Labor & NLR costs plus Profit) per Contract Year in this section. Prime Overhead Cost
Prime G&A Rate Khan, Wally: Khan, Wally:
Linked to GAT
| Prime G&A Cost | ||||||
| Total Prime Indirect Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Prime Facilities Capital Cost of Money (FCCOM) (if applicable): | ||||||
| FCCOM Base | ||||||
| FCCOM Rate | ||||||
| Total Prime FCCOM Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Estimated Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Fee: | ||||||
| Fee Base | ||||||
| Fee Rate | ||||||
| Total Fee Dollars | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL PROPOSED PRICE (Cost & Fee) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NOTE: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas. |
&A
&"Times New Roman,Regular"&12NNJ17580232R &"Times New Roman,Regular"&12L-07CF-&P
TRT - Baseline B
| TECHNICAL RESOURCES TEMPLATE - BASELINE B (TRT-Baseline B) | SOW 2.0 Baseline B: FOD IT and PIC Services |
| Prime Contractor Name: |
PRIME AND ALL SUBCONTRACT (INCLUDING MINOR SUBCONTRACTORS) RESOURCES COMBINED
| SOW | SOW | SOW | SOW | SOW | SOW | SOW | SOW | SOW | SOW | Total CY 1 | Skill mix | |
| Standard Labor Category | 2.2 FTEs | 2.3 FTEs | 2.4 FTEs | 2.5 FTEs | 2.6 FTEs | 2.7 FTEs | 2.8 FTEs | 2.9 FTEs | 2.10 FTEs | 2.11 FTEs | SOW 2.0 FTEs | Ratio |
| FTEs | ||||||||||||
| Ex: Business Specialist 3 | 0.5 | 1.0 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 13.5 |
| Business Process Specialist I | 0.0 | ERROR:#DIV/0! | ||||||||||
| business Process Specialist II | 0.0 | ERROR:#DIV/0! | ||||||||||
| Business Process Specialist III | 0.0 | ERROR:#DIV/0! | ||||||||||
| Business Process Specialist IV | 0.0 | ERROR:#DIV/0! | ||||||||||
| Business Specialist I | 0.0 | ERROR:#DIV/0! | ||||||||||
| business Specialist II | 0.0 | ERROR:#DIV/0! | ||||||||||
| Computer Engineer I | 0.0 | ERROR:#DIV/0! | ||||||||||
| Computer Engineer II | 0.0 | ERROR:#DIV/0! | ||||||||||
| Computer Engineer III | 0.0 | ERROR:#DIV/0! | ||||||||||
| Computer Engineer IV | 0.0 | ERROR:#DIV/0! | ||||||||||
| Computer Security Systems Specialist | 0.0 | ERROR:#DIV/0! | ||||||||||
| Database Analyst I | 0.0 | ERROR:#DIV/0! | ||||||||||
| Database Analyst II | 0.0 | ERROR:#DIV/0! | ||||||||||
| Database Analyst III | 0.0 | ERROR:#DIV/0! | ||||||||||
| Graphic Specialist I | 0.0 | ERROR:#DIV/0! | ||||||||||
| Graphic Specialist II | 0.0 | ERROR:#DIV/0! | ||||||||||
| Graphic Specilaist III | 0.0 | ERROR:#DIV/0! | ||||||||||
| IT Professional I | 0.0 | ERROR:#DIV/0! | ||||||||||
| IT Professional II | 0.0 | ERROR:#DIV/0! | ||||||||||
| IT Professional III | 0.0 | ERROR:#DIV/0! | ||||||||||
| Program Manager | 0.0 | ERROR:#DIV/0! | ||||||||||
| Project Control Specialist I | 0.0 | ERROR:#DIV/0! | ||||||||||
| Project Control Specialist II | 0.0 | ERROR:#DIV/0! | ||||||||||
| Project Control Specialist III | 0.0 | ERROR:#DIV/0! | ||||||||||
| Project Control Specialist IV | 0.0 | ERROR:#DIV/0! | ||||||||||
| Project Manager | 0.0 | ERROR:#DIV/0! | ||||||||||
| Quality Assurance specialist | 0.0 | ERROR:#DIV/0! | ||||||||||
| Software Engineer I | 0.0 | ERROR:#DIV/0! | ||||||||||
| Software Engineer II | 0.0 | ERROR:#DIV/0! | ||||||||||
| Software Engineer III | 0.0 | ERROR:#DIV/0! | ||||||||||
| Software Engineer IV | 0.0 | ERROR:#DIV/0! | ||||||||||
| Software Engineer V | 0.0 | ERROR:#DIV/0! | ||||||||||
| Systems Administrator I | 0.0 | ERROR:#DIV/0! | ||||||||||
| Systems Administrator II | 0.0 | ERROR:#DIV/0! | ||||||||||
| Systems Administrator III | 0.0 | ERROR:#DIV/0! | ||||||||||
| Web Software Developer | 0.0 | ERROR:#DIV/0! | ||||||||||
| Other: (Specify) | 0.0 | ERROR:#DIV/0! | ||||||||||
| Total FTE Prime and All Subs | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | ERROR:#DIV/0! |
&A
&"Times New Roman,Regular"&12NNJ17580232R &"Times New Roman,Regular"&12L-07CF-&P
TRST - Baseline B
| TECHNICAL RESOURCES SUMMARY TEMPLATE - BASELINE B (TRST-Baseline B) |
| Prime Offeror Company Name: |
| PRIME AND ALL SUBCONTRACT (INCLUDING MINOR SUBCONTRACTORS) RESOURCES COMBINED | ||||||||
| NASA (JSC) | ||||||||
| Standard Labor Category | Incumbent Retention % | Base Period | Option 1 | Option 2 | ||||
| CY1 | CY2 | CY3 | CY4 | CY5 | CY 1 Thru CY 5 | |||
| FTE Resources Basis | FTE Resources Basis | FTE Resources Basis | FTE Resources Basis | FTE Resources Basis | Average Annual FTEs | |||
| Ex: Business Specialist 3 | 100% | 8.5 | 8.5 | 8.0 | 8.0 | 8.0 | 8.2 |
| Business Process Specialist I | 0.0 | |||||
| business Process Specialist II | 0.0 | |||||
| Business Process Specialist III | 0.0 | |||||
| Business Process Specialist IV | 0.0 | |||||
| Business Specialist I | 0.0 | |||||
| business Specialist II | 0.0 | |||||
| Computer Engineer I | 0.0 | |||||
| Computer Engineer II | 0.0 | |||||
| Computer Engineer III | 0.0 | |||||
| Computer Engineer IV | 0.0 | |||||
| Computer Security Systems Specialist | 0.0 | |||||
| Database Analyst I | 0.0 | |||||
| Database Analyst II | 0.0 | |||||
| Database Analyst III | 0.0 | |||||
| Graphic Specialist I | 0.0 | |||||
| Graphic Specialist II | 0.0 | |||||
| Graphic Specilaist III | 0.0 | |||||
| IT Professional I | 0.0 | |||||
| IT Professional II | 0.0 | |||||
| IT Professional III | 0.0 | |||||
| Program Manager | 0.0 | |||||
| Project Control Specialist I | 0.0 | |||||
| Project Control Specialist II | 0.0 | |||||
| Project Control Specialist III | 0.0 | |||||
| Project Control Specialist IV | 0.0 | |||||
| Project Manager | 0.0 | |||||
| Quality Assurance specialist | 0.0 | |||||
| Software Engineer I | 0.0 | |||||
| Software Engineer II | 0.0 | |||||
| Software Engineer III | 0.0 | |||||
| Software Engineer IV | 0.0 | |||||
| Software Engineer V | 0.0 | |||||
| Systems Administrator I | 0.0 | |||||
| Systems Administrator II | 0.0 | |||||
| Systems Administrator III | 0.0 | |||||
| Web Software Developer | 0.0 | |||||
| Other: (Specify) | 0.0 | |||||
| Total | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| Non-Labor Resources (NLR) Cost ($) | CY1 | CY2 | CY3 | CY4 | CY5 | CY1 - CY5 |
| Material | $ - 0 | |||||
| Training | $ - 0 | |||||
| Travel | $ - 0 | |||||
| Other NLR Costs | $ - 0 | |||||
| Total NLR Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Note 1: The prime offeror shall populate the proposed FTE columns and the proposed NLR columns, inclusive of the Prime, Major and Minor subcontractors' proposed labor and nonlabor resources, respectively. It is very important that your reference column refer evaluators to all the Efficiencies or Cost Savings supporting data in the CS paragraph of Volume xx, Technical Acceptability. If the labor resources are unchanged from the resource basis, no reference is required.
| Note 2: Examples are highlighted in red font. IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas, |
| whether or not in red font. Please remember to remove red highlighted examples from the templates in your official proposal submission. |
&A
&"Times New Roman,Regular"&12NNJ17580232R &"Times New Roman,Regular"&12L-07CF-&P
LPT - Baseline B LABOR PRICING TEMPLATE - BASELINE B (TRT-Baseline B)
| Prime Contractor Name: |
| Major Subcontractor Name: |
| Base | Option 1 | Option 2 | |||||
| Contract | Contract | Contract | Contract | Contract | Total | ||
| NASA Standard Labor Category (SLC) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | CY 1-5 | Ref. |
| Straight-Time (ST) Hours | |||||||
| Business Process Specialist I | - 0 | ||||||
| business Process Specialist II | |||||||
| Business Process Specialist III | |||||||
| Business Process Specialist IV | |||||||
| Business Specialist I | |||||||
| business Specialist II | |||||||
| Computer Engineer I | |||||||
| Computer Engineer II | |||||||
| Computer Engineer III | |||||||
| Computer Engineer IV | |||||||
| Computer Security Systems Specialist | |||||||
| Database Analyst I | |||||||
| Database Analyst II | |||||||
| Database Analyst III | |||||||
| Graphic Specialist I | - 0 | ||||||
| Graphic Specialist II | - 0 | ||||||
| Graphic Specilaist III | - 0 | ||||||
| IT Professional I | - 0 | ||||||
| IT Professional II | - 0 | ||||||
| IT Professional III | - 0 | ||||||
| Program Manager | - 0 | ||||||
| Project Control Specialist I | |||||||
| Project Control Specialist II | |||||||
| Project Control Specialist III | |||||||
| Project Control Specialist IV | |||||||
| Project Manager | - 0 | ||||||
| Quality Assurance specialist | - 0 | ||||||
| Software Engineer I | - 0 | ||||||
| Software Engineer II | |||||||
| Software Engineer III | |||||||
| Software Engineer IV | |||||||
| Software Engineer V | |||||||
| Systems Administrator I | |||||||
| Systems Administrator II | |||||||
| Systems Administrator III | |||||||
| Web Software Developer | |||||||
| Other: (Specify) | |||||||
| Subtotal ST Hours | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Straight-Time Rates |
| Business Process Specialist I |
| business Process Specialist II |
| Business Process Specialist III |
| Business Process Specialist IV |
| Business Specialist I |
| business Specialist II |
| Computer Engineer I |
| Computer Engineer II |
| Computer Engineer III |
| Computer Engineer IV |
| Computer Security Systems Specialist |
| Database Analyst I |
| Database Analyst II |
| Database Analyst III |
| Graphic Specialist I |
| Graphic Specialist II |
| Graphic Specilaist III |
| IT Professional I |
| IT Professional II |
| IT Professional III |
| Program Manager |
| Project Control Specialist I |
| Project Control Specialist II |
| Project Control Specialist III |
| Project Control Specialist IV |
| Project Manager |
| Quality Assurance specialist |
| Software Engineer I |
| Software Engineer II |
| Software Engineer III |
| Software Engineer IV |
| Software Engineer V |
| Systems Administrator I |
| Systems Administrator II |
| Systems Administrator III |
| Web Software Developer |
| Other: (Specify) |
| Straight-Time Labor Cost | ||||||
| Business Process Specialist I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| business Process Specialist II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Business Process Specialist III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Business Process Specialist IV | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Business Specialist I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| business Specialist II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Computer Engineer I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Computer Engineer II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Computer Engineer III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Computer Engineer IV | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Computer Security Systems Specialist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Database Analyst I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Database Analyst II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Database Analyst III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Graphic Specialist I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Graphic Specialist II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Graphic Specilaist III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| IT Professional I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| IT Professional II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| IT Professional III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Project Control Specialist I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Project Control Specialist II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Project Control Specialist III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Project Control Specialist IV | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Project Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Quality Assurance specialist | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Software Engineer I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Software Engineer II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Software Engineer III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Software Engineer IV | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Software Engineer V | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Systems Administrator I | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Systems Administrator II | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Systems Administrator III | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Web Software Developer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Other: (Specify) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL LABOR COST | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NOTE: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas. |
&A
&"Times New Roman,Regular"&12NNJ17580232R &"Times New Roman,Regular"&12L-07CF-&P
MSCST - Baseline B Major Subcontractor Cost Summary Template - BASELINE B (MSCST - Baseline B)
Major Subcontractor Name:
| Base | Option 1 | Option 2 | |||||
| Contract | Contract | Contract | Contract | Contract | |||
| Cost Element | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total CY 1-5 | Ref. |
| Direct Labor Hours: | |||||||
| Major Sub Straight-Time Hours | - 0 | ||||||
| Total Direct Labor Hours | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Direct Labor Cost: | ||||||
| Major Sub Direct Labor Cost | $ - 0 | |||||
| Total Direct Labor Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Overhead (OH) and Service Center (SC) Cost: | ||||||
| Major Sub OH or SC No. 1 (identify by name) | ||||||
| Base | ||||||
| Rate | ||||||
| Sub-Total Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Major Sub OH or SC No. 2 (identify by name) | ||||||
| Base | ||||||
| Rate | ||||||
| Sub-Total Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Major Sub OH or SC No. 3 (identify by name) | ||||||
| Base | ||||||
| Rate | ||||||
| Sub-Total Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total OH and SC Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Non-Labor Resources (NLRs): | ||||||
| Material | $ - 0 | |||||
| Equipment | $ - 0 | |||||
| Training/Conference | $ - 0 | |||||
| Travel | $ - 0 | |||||
| Other | $ - 0 | |||||
| Total NLR Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Sub-Total Cost $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
| G&A Cost: | ||||||
| G&A Base | ||||||
| G&A Rate | ||||||
| Total G&A Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Facilities Capital Cost of Money (FCCOM): | ||||||
| FCCOM Base | ||||||
| FCCOM Rate | ||||||
| Total FCCOM Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Estimated Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Fee: | ||||||
| Fee Base | ||||||
| Fee Rate | ||||||
| Total Fee Dollars | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Major Sub Estimated Cost and Fee | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
NOTE: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas.
RFP - NNJxxxxxx Section L Attachment L-xx
PCST - Baseline B PRIME COST SUMMARY TEMPLATE - BASELINE B (PCST-Baseline B)
| Prime Contractor Name: | |||||||
| Base | Option 1 | Option 2 | |||||
| Contract | Contract | Contract | Contract | Contract | |||
| Cost Element | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Total CY 1-5 | Ref. |
| Team Direct Labor Hours: | |||||||
| Prime Contractor Straight-Time (ST) Hours |
Arevalo, Rosa: NASA JSC: The prime and each major subcontractor may link their proposed ST and OT hours per Contract Year from their respective LPT.
| - 0 | ||||||
| Major Subcontractor ST Hours | - 0 | |||||
| Minor Subcontractor ST Hours | - 0 | |||||
| Total Team Direct Labor Hours | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
Prime Labor Cost Arevalo, Rosa: NASA JSC:
The prime may link the proposed Total ST and OT labor cost per Contract Year from their LPT (Row 117; Columns D117-H117). $ - 0
Subcontractor Cost:
Arevalo, Rosa: NASA JSC:
The prime shall provide each Major Subcontractor's Proposed Price (Fully Burdened Labor & NLR costs plus Profit) per Contract Year in this section.
| Major Subcontractor No. 1 Cost (identify by name) | $ - 0 | |||||
| Major Subcontractor No. 2 Cost (identify by name) | $ - 0 | |||||
| Sub-Total Major Subcontractor Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Minor Subcontractor Price Arevalo, Rosa: NASA JSC:
The prime shall provide the Minor Sub's Proposed Price (Fully Burdened Labor and NLR plus Profit) per Contract Year in this section. If more than one Minor Sub is proposed, the Prime may add rows (as applicable), and identify each minor sub by name.
| $ - 0 | ||||||
| Total Subcontractor Cost (Cost & Fee) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Total Prime Non-Labor Resources (NLR) Cost Arevalo, Rosa: NASA JSC:
The prime shall provide their total proposed Fully Burdened NLR Cost per Contract Year in this section. They may link the dollar values from the TRST-CF (FFP) tab (Row 38; Columns D38, H38, L38, P38 and T38).
Arevalo, Rosa: NASA JSC: The prime and each major subcontractor may link their proposed ST and OT hours per Contract Year from their respective LPT.
$ - 0
Total (Prime and Sub) Labor and Prime NLR Costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Prime Indirect Cost:
Arevalo, Rosa: NASA JSC: The prime shall provide their total proposed Indirect Costs (e.g. Overhead, Fringe Benefit and G&A) per Contract Year in this section.
Expand this worksheet to include rows for any other indirect rates proposed; similar to the two rows below.
Prime Overhead Rate Khan, Wally: Khan, Wally:
Linked to OHT
Arevalo, Rosa: NASA JSC:
The prime may link the proposed Total ST and OT labor cost per Contract Year from their LPT (Row 117; Columns D117-H117).
Arevalo, Rosa: NASA JSC:
The prime shall provide each Major Subcontractor's Proposed Price (Fully Burdened Labor & NLR costs plus Profit) per Contract Year in this section. Prime Overhead Cost
Prime G&A Rate Khan, Wally: Khan, Wally:
Linked to GAT
| Prime G&A Cost | ||||||
| Total Prime Indirect Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Prime Facilities Capital Cost of Money (FCCOM) (if applicable): | ||||||
| FCCOM Base | ||||||
| FCCOM Rate | ||||||
| Total Prime FCCOM Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Estimated Cost | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Fee: | ||||||
| Fee Base | ||||||
| Fee Rate | ||||||
| Total Fee Dollars | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| TOTAL PROPOSED PRICE (Cost & Fee) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| NOTE: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas. |
&A
&"Times New Roman,Regular"&12NNJ17580232R &"Times New Roman,Regular"&12L-07CF-&P
File details come from the government source that posted it. Updated .