Attachment J.2-E - SETS Cost Summary Template.xlsx

XLSX spreadsheet 198 KB Posted

Attached to
Safety and Mission Assurance (SMA) Engineering and Technical Services (SETS) Final RFP Federal contract opportunity
Solicitation number
80GRC021R0011
Issued by
National Aeronautics and Space Administration Glenn Research Center

About this file

This document package includes a Request for Proposal for the Safety and Mission Assurance Engineering and Technical Services requirement. NASA Glenn Research Center is seeking proposals for administrative support services, communication and professional development services, IT services, and technical knowledge services. The contract is set aside for woman-owned small businesses with a NAICS code of 611430 and size standard of $12,000,000. Proposals are due no later than April 8, 2022. The solicitation includes statements of work, government furnished equipment descriptions, data requirements, templates, labor categories, reviews and status information, cost summaries, and past performance questionnaires.

View the file

Other files for this federal contract opportunity

Other files attached to Safety and Mission Assurance (SMA) Engineering and Technical Services (SETS) Final RFP, newest first.
File Type Posted
SETS Final RFP - SF 30 - Amendment 4.pdf PDF
SETS Final RFP - SF 30 - Amendment 3.pdf PDF
Attachment J.2-G - Past Performance Questionnaire - Revision 1.pdf PDF
SETS Final RFP - SF 30 - Amendment 2.pdf PDF
SETS Final RFP and Cover Letter - Revision 1.pdf PDF
SETS Final RFP - SF 30 - Amendment 1.pdf PDF
Attachment J.1-B - Statement of Work Appendices - Revision 1.pdf PDF
Attachment J.2-A - Historical Staffing - Revision 1.pdf PDF
SETS Final RFP - Consolidated Q and A.pdf PDF
Attachment J.2-B - Contractor Space and Support Location - Revision 1.pdf PDF
Attachment J.2-C - Labor Categories and Descriptions - Revision 1.pdf PDF
SETS Final RFP and Cover Letter.pdf PDF
Attachment J.1-A - Statement of Work.pdf PDF
Attachment J.1-D - Data Requirements Document.pdf PDF
Attachment J.2-G - Past Performance Questionnaire.pdf PDF
Attachment J.1-E - Guide to STEP.pdf PDF
Attachment J.2-B - Contractor Space and Support Location.pdf PDF
Attachment J.2-C - Labor Categories and Descriptions.pdf PDF
Attachment J.1-C - Government Furnished Equipment.pdf PDF
Attachment J.1-F - 533M Sample.xlsx XLSX spreadsheet
Attachment J.1-G - 533 Sample Baseline.xlsx XLSX spreadsheet
Attachment J.2-D - Business Systems Reviews and Status Information Template.xlsx XLSX spreadsheet
Attachment J.2-H - Sample Mandatory and Required Training.pdf PDF
Attachment J.1-B - Statement of Work Appendicies.pdf PDF
Attachment J.2-A - Historical Staffing.pdf PDF
Attachment J.2-F - CAOT.xlsx XLSX spreadsheet
Show all 26

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

1 Total + IDIQ

TOTAL OF COST ELEMENTS

Firm-Fixed PriceBase PeriodOption period
Cost ElementsPhase-InYear 1Year 2Year 3Year 4Year 56 Month ExtensionTotal
Direct Labor$ -
Fringe$ -
Overhead$ -
Other Direct Costs$ -
Subcontractor Costs$ -
Material Handling$ -
G&A$ -
Facilities Capital Cost of Money$ -
Fixed Fee$ -
IDIQ (Do not Adjust)$ - 0$ 500,000$ 500,000$ 500,000$ 500,000$ 500,000$ 250,000$ 2,750,000
Total Estimated Cost Plus Fixed Fee$ - 0$ -$ -$ -$ -$ -$ -$ -
IDIQ LABOR OVERHEAD RATES PROPOSED
BASE PERIODOPTION PERIODS
Year 1Year 2Year 3Year 4Year 5Year 6
IDIQ MATERIAL HANDLING RATES PROPOSED
BASE PERIODOPTION PERIODS
Year 1Year 2Year 3Year 4Year 5Year 6
IDIQ G&A RATES PROPOSED
BASE PERIODOPTION PERIODS
Year 1Year 2Year 3Year 4Year 5Year 6
IDIQ FIXED FEE RATES PROPOSED
BASE PERIODOPTION PERIODS
Year 1Year 2Year 3Year 4Year 5Year 6

2 Costs Total Cost Template

COST PLUS FIXED FEE

BASE PERIODOPTION PERIOD
ElementsYear 1Year 2Year 3Year 4Year 56 Month ExtensionTotal
Direct Labor Hours
Straightime Hours------
Overtime Hours------
Total Hours-------

Direct Labor Dollars from Labor Template $ - $ - $ - $ - $ - $ -

Overhead (List) Cost
1. (Name & Description of Base)$ -$ -$ -$ -$ -$ -
Overhead Rate0.00%0.00%0.00%0.00%0.00%0.00%
Overhead Cost$ -$ -$ -$ -$ -$ -$ -
2. (Name & Description of Base)$ -$ -$ -$ -$ -$ -
Overhead Rate0.00%0.00%0.00%0.00%0.00%0.00%
Overhead Cost$ -$ -$ -$ -$ -$ -$ -
Total Overhead Cost$ -$ -$ -$ -$ -$ -$ -
Other Direct Costs (ODCs)
1. Equipment - Low Cost$ 12,000$ 12,240$ 12,485$ 12,734$ 12,989$ 6,624$ 69,073
2. Materials and Supplies$ 54,000$ 55,080$ 56,182$ 57,305$ 58,451$ 29,810$ 310,828
3. Travel$ 110,000$ 112,200$ 114,444$ 116,733$ 119,068$ 60,724$ 633,169
4. Training and Certifications$ 18,000$ 18,360$ 18,727$ 19,102$ 19,484$ 9,937$ 103,609
5. Procured Courses$ 97,000$ 98,940$ 100,919$ 102,937$ 104,996$ 53,548$ 558,340
6. Consultant$ 90,000$ 91,800$ 93,636$ 95,509$ 97,419$ 49,684$ 518,047
7. Other Direct Costs$ 27,000$ 27,540$ 28,091$ 28,653$ 29,226$ 14,905$ 155,414
Total Other Direct Costs$ 408,000$ 416,160$ 424,483$ 432,973$ 441,632$ 225,232$ 2,348,481
Subcontractor Costs
1. (Subcontractor Name)$ -$ -$ -$ -$ -$ -$ -
2. (Subcontractor Name)$ -$ -$ -$ -$ -$ -$ -
3. (Subcontractor Name)$ -$ -$ -$ -$ -$ -$ -
Total Subcontract Cost$ -$ -$ -$ -$ -$ -$ -
Material Handling (Pass through costs)
1. (Description of Material Handling Base)$ -$ -$ -$ -$ -$ -
M&H Rate0.00%0.00%0.00%0.00%0.00%0.00%
M&H Cost$ -$ -$ -$ -$ -$ -$ -
G&A Cost
1. (Description of G&A Base)$ -$ -$ -$ -$ -$ -
G&A Rate0.00%0.00%0.00%0.00%0.00%0.00%
G&A Cost$ -$ -$ -$ -$ -$ -$ -

Subtotal $ 408,000 $ 416,160 $ 424,483 $ 432,973 $ - $ 225,232 $ 2,348,481

Facilities Capital Cost of Money (FCCOM)
1. (Description of FCCOM Base)$ -$ -$ -$ -$ -$ -
FCCOM Rate0.00%0.00%0.00%0.00%0.00%0.00%
FCCOM Cost$ -$ -$ -$ -$ -$ -$ -
Fixed Fee
1. Subcontractor$ -$ -$ -$ -$ -$ -
Fixed Fee Rate0.00%0.00%0.00%0.00%0.00%0.00%
Fixed Fee Amount$ -$ -$ -$ -$ -$ -$ -
2. (Description of Fee Base) less Subcontractor$ -$ -$ -$ -$ -$ -
Fixed Fee Rate0.00%0.00%0.00%0.00%0.00%0.00%
Fixed Fee Amount$ -$ -$ -$ -$ -$ -$ -
Total Fixed Fee Amount$ -$ -$ -$ -$ -$ -$ -

Total Estimated Cost Plus Fixed Fee $ 408,000 $ 416,160 $ 424,483 $ 432,973 $ - $ 225,232 $ 2,348,481

3 Labor Labor Template

CONTRACT YEAR: ONE
Labor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsProductive Work HoursStandard Labor RateLabor Cost
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.00$0.00
CONTRACT YEAR: TWO
Labor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsProductive Work HoursStandard Labor RateLabor Cost
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.00$0.00
CONTRACT YEAR: THREE
Labor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsProductive Work HoursStandard Labor RateLabor Cost
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.00$0.00
CONTRACT YEAR: FOUR
Labor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsProductive Work HoursStandard Labor RateLabor Cost
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.00$0.00
CONTRACT YEAR: FIVE
Labor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsProductive Work HoursStandard Labor RateLabor Cost
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.00$0.00
CONTRACT YEAR: SIX MONTH EXTENSION
Labor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsProductive Work HoursStandard Labor RateLabor Cost
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.000.00$0.00$0.00
0.00$0.00

4 SWR1

SWR1 - Work Requirement 1: Safety and Mission Assurance (SMA) Training Course Development

Elements

Labor Category Hours

Total - 0

Other Direct Costs (ODCs)Dollars
1. (ODC Description)$ -
2. (ODC Description)$ -
3. (ODC Description)$ -
Total Other Direct Costs$ -

5 SWR2

SWR2 - Work Requirement 2: Information Dissemination and Outreach

Elements Hours

Labor Category

Total - 0

Other Direct Costs (ODCs)
1. (ODC Description)$ -
2. (ODC Description)$ -
3. (ODC Description)$ -
Total Other Direct Costs$ -

6 SWR3

SWR3 - Work Requirement 3: Application Development

Elements

Labor Category Hours

Total - 0

Other Direct Costs (ODCs)Dollars
1. (ODC Description)$ -
2. (ODC Description)$ -
3. (ODC Description)$ -
Total Other Direct Costs$ -

7 SWR4

SWR4 - Work Requirement 4: Data Analysis

Elements Hours

Labor Category

Total - 0

Other Direct Costs (ODCs)
1. (ODC Description)$ -
2. (ODC Description)$ -
3. (ODC Description)$ -
Total Other Direct Costs$ -

8a Indirect Rate

INDIRECT RATE TEMPLATE
A current DCAA Forward Pricing Rate Agreement may be provided in lieu of completing this template for the resepctive rates.
Duplicate Template for each Indirect Rate proposed
Company Name:_____________________________[ ] Prime[ ] Major Subcontractor
Indirect Rate Name:_____________________________
Application Base:_____________________________
Fiscal Year Begins:_____________________________
Fiscal Year Ends:_____________________________
ContractorContractorContractorContractorContractorContractorContractorContractorContractor
Cost Elements withinFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
Indirect Rate PoolPrior Yr 3Prior Yr 2Prior Yr 1______________________________________________________
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
Total Pool Expenses$ -$ -$ -$ -$ -$ -
Application Base ($)$ -$ -$ -$ -$ -$ -
Contractor FY Rate (%)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
CONVERSION OF BURDEN RATE TO CONTRACT YEARContractContractContractContractContractContract
Year 1Year 2Year 3Year 4Year 5Year 6
Proposed Contract Year Rate0.00%0.00%0.00%0.00%0.00%0.00%

8b Indirect Rate

INDIRECT RATE TEMPLATE
A current DCAA Forward Pricing Rate Agreement may be provided in lieu of completing this template for the resepctive rates.
Duplicate Template for each Indirect Rate proposed
Company Name:_____________________________[ ] Prime[ ] Major Subcontractor
Indirect Rate Name:_____________________________
Application Base:_____________________________
Fiscal Year Begins:_____________________________
Fiscal Year Ends:_____________________________
ContractorContractorContractorContractorContractorContractorContractorContractorContractor
Cost Elements withinFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
Indirect Rate PoolPrior Yr 3Prior Yr 2Prior Yr 1______________________________________________________
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
Total Pool Expenses$ -$ -$ -$ -$ -$ -
Application Base ($)$ -$ -$ -$ -$ -$ -
Contractor FY Rate (%)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
CONVERSION OF BURDEN RATE TO CONTRACT YEARContractContractContractContractContractContract
Year 1Year 2Year 3Year 4Year 5Year 6
Proposed Contract Year Rate0.00%0.00%0.00%0.00%0.00%0.00%

8c Indirect Rate

INDIRECT RATE TEMPLATE
A current DCAA Forward Pricing Rate Agreement may be provided in lieu of completing this template for the resepctive rates.
Duplicate Template for each Indirect Rate proposed
Company Name:_____________________________[ ] Prime[ ] Major Subcontractor
Indirect Rate Name:_____________________________
Application Base:_____________________________
Fiscal Year Begins:_____________________________
Fiscal Year Ends:_____________________________
ContractorContractorContractorContractorContractorContractorContractorContractorContractor
Cost Elements withinFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
Indirect Rate PoolPrior Yr 3Prior Yr 2Prior Yr 1______________________________________________________
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
$ -$ -$ -$ -$ -$ -
Total Pool Expenses$ -$ -$ -$ -$ -$ -
Application Base ($)$ -$ -$ -$ -$ -$ -
Contractor FY Rate (%)0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
CONVERSION OF BURDEN RATE TO CONTRACT YEARContractContractContractContractContractContract
Year 1Year 2Year 3Year 4Year 5Year 6
Proposed Contract Year Rate0.00%0.00%0.00%0.00%0.00%0.00%

9 Total Staffing

TOTAL STAFFING TEMPLATE (INCLUDES SUBCONTRACTOR LABOR)

BASE PERIODOPTION PERIODS
Year 1Year 2Year 3Year 4Year 56 Month Extension
Offeror or Subcontractor NameLabor Category per DOLWD, CBA, GSA, or Offeror's established positionIncumbent Labor ClassificationE=Exempt N=Non Exempt U=UnionWYEsWYEsWYEsWYEsWYEsWYEs
TOTAL STAFFING
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
0.000.000.000.000.000.00
TOTAL:0.000.000.000.000.000.00

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