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) Draft RFP Federal contract opportunity
Solicitation number
80GRC021R0011
Issued by
National Aeronautics and Space Administration Glenn Research Center

About this file

This document contains a draft request for proposal for the Safety and Mission Assurance Engineering and Technical Services requirement. The National Aeronautics and Space Administration Glenn Research Center plans to issue a solicitation seeking administrative support services, communication and professional development services, information technology services, and technical knowledge services. The anticipated release date of the request for proposal is January 3, 2022, with an offer due date of February 2, 2022. The North American Industry Classification System code is 611430 for professional and management development training, and the size standard is $12,000,000. This acquisition is fully set aside for woman-owned small businesses. Interested parties can attend a virtual industry day on November 17, 2021 to learn more by registering using the instructions in the industry day letter attachment. Questions about the solicitation are due by December 3, 2021.

The attachments include the statement of work and appendices, government furnished equipment list, data requirements document, guidance on submitting proposals, historical staffing information, contractor facility requirements, labor categories and descriptions, a business systems review template, and a cost summary template. The agency is the National Aeronautics and Space Administration Glenn Research Center.

View the file

Other files for this federal contract opportunity

Show all 17

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 Tasks + 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$ -

4 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$ -

5 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$ -

6a 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%

6b 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%

6c 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%

7 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 .