80ARC018R0007_J.1(b)Attachment5_Resource_Workbook_1DEC2017.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
Small Spacecraft Prototyping Engineering Development and Integration - Space Solutions (SSPEDI SpS) Federal contract opportunity
Solicitation number
80ARC018R0007
Issued by
National Aeronautics and Space Administration Ames Research Center

About this file

This document includes a resource workbook and related federal contract opportunity notice. The resource workbook provides templates for offerors to estimate resources required to complete tasks for the Small Spacecraft Prototyping Engineering Development and Integration - Space Solutions (SSPEDI SpS) contract. It includes work breakdown structure summaries and detailed resource workbooks for labor hours, materials, other direct costs, travel, and subcontracting costs over multiple contract line item numbers and years. The federal contract opportunity is for the SSPEDI SpS multiple award contract focused on developing small to medium spacecraft buses, payloads, and space vehicles based on mission requirements for the Orbital Rocket Systems program. The 5-year IDIQ contracts awarded by the National Aeronautics and Space Administration Ames Research Center are contemplated to include both fixed price and cost reimbursement task orders. The solicitation is anticipated to be released in November 2017 with proposals due in December 2017 and contracts awarded in June 2018. Set-aside goals include 25% for small business and targets for small disadvantaged, woman-owned, HUBZone, veteran-owned, and service-disabled veteran-owned small businesses.

Revised Resource Workbook dated 1 DEC 2017

View the file

Other files for this federal contract opportunity

Other files attached to Small Spacecraft Prototyping Engineering Development and Integration - Space Solutions (SSPEDI SpS), newest first.
File Type Posted
SSPEDI_SpS_Source_Selection_Statement_FINAL_signed.pdf PDF
SSPEDI_SpS_QandA_Vol4_20DEC2017.pdf PDF
80ARC018R0007P00003_-_SF30.pdf PDF
80ARC018R0007_SSPEDI_SpS_20DEC2017.pdf PDF
SSPEDI_SpS_QandA_Vol3_7DEC2017.pdf PDF
80ARC018R0007_SF33_4DEC2017.pdf PDF
80ARC018R0007P00002_-_SF30.pdf PDF
SSPEDI_SpS_QandA_Vol2_1DEC2017.pdf PDF
80ARC018R0007_J.1(b)Attachment11_Technical_Document_Library_List_1DEC2017.pdf PDF
80ARC018R0007_J.1(b)Attachment4_Cost-Price_Template_Workbook_1DEC2017.xlsx XLSX spreadsheet
80ARC018R0007P00001_-_SF30.pdf PDF
80ARC018R0007_SSPEDI_SpS_1DEC2017.pdf PDF
Show all 12

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 1

SpS Task Order 2 - ORS-8 Space Segment
WBS Summary of Resource Volume

Proposing Entity: _________________________________________

CLIN 0001 Space Vehicle: Development through Launch Operations 0

WBSWBS DescriptionLabor HrsMaterial $ODC $Travel $Subcontractor $
1.1Program Manager/Systems Engineering (PM/SE)45$ 360.00$ 225.00$ 12.00$ 18.00
1.1.1Level 3 Title15$ 120.00$ 75.00$ 6.00$ 9.00
1.1.2Level 3 Title30$ 240.00$ 150.00$ 6.00$ 9.00
1.1.3Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.1.4Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.2Space Vehicle- 0$ - 0$ - 0$ - 0$ - 0
1.2.1Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.2.2Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.2.3Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.2.4Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.3Mission Data Management System- 0$ - 0$ - 0$ - 0$ - 0
1.3.1Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.3.2Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.3.3Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.3.4Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.4Support Equipment- 0$ - 0$ - 0$ - 0$ - 0
1.4.1Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.4.2Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.4.3Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.4.4Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.5Launch Service Integration- 0$ - 0$ - 0$ - 0$ - 0
1.5.1Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.5.2Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.5.3Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.5.4Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
Total45$ 360.00$ 225.00$ 12.00$ 18.00

CLIN 0002 Launch and Early Orbit, and Mission Operations Support

WBSWBS DescriptionLabor HrsMaterial $ODC $Travel $Subcontractor $
1.6Mission Operations5$ 40.00$ 25.00$ 2.00$ 3.00
1.6.1Level 3 Title5$ 40.00$ 25.00$ 2.00$ 3.00
1.6.2Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.6.3Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.6.4Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
Total5$ 40.00$ 25.00$ 2.00$ 3.00

CLIN 0003 Option 1: Mission Operations Support

WBSWBS DescriptionLabor HrsMaterial $ODC $Travel $Subcontractor $
1.6Mission Operations10$ 44.00$ 30.00$ 3.00$ 4.00
1.6.1Level 3 Title10$ 44.00$ 30.00$ 3.00$ 4.00
1.6.2Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.6.3Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.6.4Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
Total10$ 44.00$ 30.00$ 3.00$ 4.00

CLIN 0004 Option 2: Mission Operations Support

WBSWBS DescriptionLabor HrsMaterial $ODC $Travel $Subcontractor $
1.6Mission Operations15$ 48.00$ 35.00$ 4.00$ 5.00
1.6.1Level 3 Title15$ 48.00$ 35.00$ 4.00$ 5.00
1.6.2Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.6.3Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
1.6.4Level 3 Title- 0$ - 0$ - 0$ - 0$ - 0
Total15$ 48.00$ 35.00$ 4.00$ 5.00
Labor HrsMaterial $ODC $Travel $Subcontractor $
TOTAL TASK ORDER 275$ 492.00$ 315.00$ 21.00$ 30.00
Instructions / Notes
Use Exhibit 2 to complete this chart.
Labor hrs, material $, ODC $, travel $, and subcontractor $ are direct costs only (no indirect costs applied).
To align with their proposed WBS Level 3 structure, vendors must add or subtract lines in this Exhibit for each CLIN.
Total labor hrs, material $, ODC $, travel $, and subcontractor $ should match cost/pricing in Attachment J.1(b)2 at the WBS Level II.
The numbers contained in this RFP Exhibit are examples only -- remove or replace in proposal.

80ARC018R0007 J.1(b) Attachment 5_x000D_Exhibit 1_x000D_

For Official Use Only This exhibit contains Source Selection Information. See FAR 3.104.

Exhibit 2

SpS Task Order 2 - ORS-8 Space Segment
Detailed Resource Workbook
Proposing Entity: _________________________________________
Task OrderCLINWBS Level 2WBS Level 3WBS Level 3 DescriptionCost ElementUnits (Hrs or Dollars)Resource CodeTO Year 1TO Year 2TO Year 3TO Year 4TO Year 5TO Year 6Total
200011.11.1.1Level 3 TitleLaborHrsLabor Category 11110003
200011.11.1.1Level 3 TitleLaborHrsLabor Category 21110003
200011.11.1.1Level 3 TitleLaborHrsLabor Category 31110003
200011.11.1.1Level 3 TitleLaborHrsLabor Category 41110003
200011.11.1.1Level 3 TitleLaborHrsetc.1110003
200011.11.1.1Level 3 TitleMaterialDollarsMaterial Category 110101000030
200011.11.1.1Level 3 TitleMaterialDollarsMaterial Category 210101000030
200011.11.1.1Level 3 TitleMaterialDollarsMaterial Category 310101000030
200011.11.1.1Level 3 TitleMaterialDollarsetc.10101000030
200011.11.1.1Level 3 TitleODCDollarsODC 155500015
200011.11.1.1Level 3 TitleODCDollarsODC 255500015
200011.11.1.1Level 3 TitleODCDollarsODC 355500015
200011.11.1.1Level 3 TitleODCDollarsODC 455500015
200011.11.1.1Level 3 TitleODCDollarsetc.55500015
200011.11.1.1Level 3 TitleTravelDollarsTravel Category 12220006
200011.11.1.1Level 3 TitleSubcontractorDollarsSubcontractor Name3330009
200011.11.1.2Level 3 TitleLaborHrsLabor Category 12220006
200011.11.1.2Level 3 TitleLaborHrsLabor Category 22220006
200011.11.1.2Level 3 TitleLaborHrsLabor Category 32220006
200011.11.1.2Level 3 TitleLaborHrsLabor Category 42220006
200011.11.1.2Level 3 TitleLaborHrsetc.2220006
200011.11.1.2Level 3 TitleMaterialDollarsMaterial Category 120202000060
200011.11.1.2Level 3 TitleMaterialDollarsMaterial Category 220202000060
200011.11.1.2Level 3 TitleMaterialDollarsMaterial Category 320202000060
200011.11.1.2Level 3 TitleMaterialDollarsetc.20202000060
200011.11.1.2Level 3 TitleODCDollarsODC 110101000030
200011.11.1.2Level 3 TitleODCDollarsODC 210101000030
200011.11.1.2Level 3 TitleODCDollarsODC 310101000030
200011.11.1.2Level 3 TitleODCDollarsODC 410101000030
200011.11.1.2Level 3 TitleODCDollarsetc.10101000030
200011.11.1.2Level 3 TitleTravelDollarsTravel Category 12220006
200011.11.1.2Level 3 TitleSubcontractorDollarsSubcontractor Name3330009
200011.11.1.3Level 3 Title0
200011.11.1.4Level 3 Title0
200011.21.2.1Level 3 Title0
200011.21.2.2Level 3 Title0
200011.21.2.3Level 3 Title0
200011.21.2.4Level 3 Title0
200011.31.3.1Level 3 Title0
200011.31.3.2Level 3 Title0
200011.31.3.3Level 3 Title0
200011.31.3.4Level 3 Title0
200011.41.4.1Level 3 Title0
200011.41.4.2Level 3 Title0
200011.41.4.3Level 3 Title0
200011.41.4.4Level 3 Title0
200011.51.5.1Level 3 Title0
200011.51.5.2Level 3 Title0
200011.51.5.3Level 3 Title0
200011.51.5.4Level 3 Title0
200021.61.6.1Level 3 TitleLaborHrsLabor Category 10001001
200021.61.6.1Level 3 TitleLaborHrsLabor Category 20001001
200021.61.6.1Level 3 TitleLaborHrsLabor Category 30001001
200021.61.6.1Level 3 TitleLaborHrsLabor Category 40001001
200021.61.6.1Level 3 TitleLaborHrsetc.0001001
200021.61.6.1Level 3 TitleMaterialDollarsMaterial Category 1000100010
200021.61.6.1Level 3 TitleMaterialDollarsMaterial Category 2000100010
200021.61.6.1Level 3 TitleMaterialDollarsMaterial Category 3000100010
200021.61.6.1Level 3 TitleMaterialDollarsetc.000100010
200021.61.6.1Level 3 TitleODCDollarsODC 10005005
200021.61.6.1Level 3 TitleODCDollarsODC 20005005
200021.61.6.1Level 3 TitleODCDollarsODC 30005005
200021.61.6.1Level 3 TitleODCDollarsODC 40005005
200021.61.6.1Level 3 TitleODCDollarsetc.0005005
200021.61.6.1Level 3 TitleTravelDollarsTravel Category 10002002
200021.61.6.1Level 3 TitleSubcontractorDollarsSubcontractor Name0003003
200021.61.6.2Level 3 Title0
200021.61.6.3Level 3 Title0
200021.61.6.4Level 3 Title0
200031.61.6.1Level 3 TitleLaborHrsLabor Category 10000202
200031.61.6.1Level 3 TitleLaborHrsLabor Category 20000202
200031.61.6.1Level 3 TitleLaborHrsLabor Category 30000202
200031.61.6.1Level 3 TitleLaborHrsLabor Category 40000202
200031.61.6.1Level 3 TitleLaborHrsetc.0000202
200031.61.6.1Level 3 TitleMaterialDollarsMaterial Category 1000011011
200031.61.6.1Level 3 TitleMaterialDollarsMaterial Category 2000011011
200031.61.6.1Level 3 TitleMaterialDollarsMaterial Category 3000011011
200031.61.6.1Level 3 TitleMaterialDollarsetc.000011011
200031.61.6.1Level 3 TitleODCDollarsODC 10000606
200031.61.6.1Level 3 TitleODCDollarsODC 20000606
200031.61.6.1Level 3 TitleODCDollarsODC 30000606
200031.61.6.1Level 3 TitleODCDollarsODC 40000606
200031.61.6.1Level 3 TitleODCDollarsetc.0000606
200031.61.6.1Level 3 TitleTravelDollarsTravel Category 10000303
200031.61.6.1Level 3 TitleSubcontractorDollarsSubcontractor Name0000404
200031.61.6.2Level 3 Title0
200031.61.6.3Level 3 Title0
200031.61.6.4Level 3 Title0
200041.61.6.1Level 3 TitleLaborHrsLabor Category 10000033
200041.61.6.1Level 3 TitleLaborHrsLabor Category 20000033
200041.61.6.1Level 3 TitleLaborHrsLabor Category 30000033
200041.61.6.1Level 3 TitleLaborHrsLabor Category 40000033
200041.61.6.1Level 3 TitleLaborHrsetc.0000033
200041.61.6.1Level 3 TitleMaterialDollarsMaterial Category 1000001212
200041.61.6.1Level 3 TitleMaterialDollarsMaterial Category 2000001212
200041.61.6.1Level 3 TitleMaterialDollarsMaterial Category 3000001212
200041.61.6.1Level 3 TitleMaterialDollarsetc.000001212
200041.61.6.1Level 3 TitleODCDollarsODC 10000077
200041.61.6.1Level 3 TitleODCDollarsODC 20000077
200041.61.6.1Level 3 TitleODCDollarsODC 30000077
200041.61.6.1Level 3 TitleODCDollarsODC 40000077
200041.61.6.1Level 3 TitleODCDollarsetc.0000077
200041.61.6.1Level 3 TitleTravelDollarsTravel Category 10000044
200041.61.6.1Level 3 TitleSubcontractorDollarsSubcontractor Name0000055
200041.61.6.2Level 3 Title0
200041.61.6.3Level 3 Title0
200041.61.6.4Level 3 Title0
TO Year 1TO Year 2TO Year 3TO Year 4TO Year 5TO Year 6Total
Labor Hrs Subtotal (based on what is filtered in table)1515155101575
Material $ Subtotal (based on what is filtered in table)120120120404448492
ODC $ Subtotal (based on what is filtered in table)757575253035315
Travel $ Subtotal (based on what is filtered in table)44423421
Subcontractor $ Subtotal (based on what is filtered in table)66634530
Instructions / Notes
Offerors must add/subtract rows to this spreadsheet to add/subtract labor categories, material categories, and ODC. Columns B through P must be filled in when inserting new rows, and correct mapping from CLIN to WBS Level 2 to WBS Level 3 and on must be maintained.
All labor hrs, material $, ODC $, travel $, and subcontractor $ must be given at each contractor defined WBS Level 3.
Enter direct costs only (no indirect costs applied).
Labor hrs, material $, ODC $, travel $, and subcontractor $ should match cost/pricing in Attachment J.1(b)2 at the WBS Level 2.
The rows and numbers contained in this RFP Exhibit are examples only -- remove or replace in proposal.

80ARC018R0007 J.1(b) Attachment 5_x000D_Exhibit 2

For Official Use Only This exhibit contains Source Selection Information. See FAR 3.104.

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