9. Final 80ARC024R0003 - J.1(b) Att. 1 - Cost-Price Template Workbook.xlsx

XLSX spreadsheet 59 KB Posted

Attached to
NASA Academic Mission Services 2 (NAMS-2) - Request for Proposal Federal contract opportunity
Solicitation number
80ARC024R0003
Issued by
National Aeronautics and Space Administration Ames Research Center

About this file

Written by GovTribe AI ·

This document contains a cost/price template workbook for the National Aeronautics and Space Administration (NASA) Academic Mission Services 2 (NAMS-2) request for proposal (RFP) number 80ARC024R0003. The workbook includes templates for offerors to provide pricing for the phase-in period, core contract management, core technical ATM research, other direct costs, labor rate buildups, and indirect rate summaries. Offerors must complete all green cells with pricing and rate information for the base year and four option years. Templates include columns for labor categories, hours, rates, overhead, G&A, fee, and fully loaded prices. A schedule of subcontractors template requires information on subcontracted work, pricing type, affiliation with the prime, and whether a cost/price analysis was performed.

View the file

Other files for this federal contract opportunity

Other files attached to NASA Academic Mission Services 2 (NAMS-2) - Request for Proposal, newest first.
File Type Posted
1. 80ARC024R0003 Amendment 1- SF30.pdf PDF
80ARC024R0003 NAMS-2 Q and A - Posted with Amendment 1.xlsx XLSX spreadsheet
2. 80ARC024R0003 Amendment 1 - J.1(b) Att. 1 - Cost-Price Template Workbook - Amendment 1.xlsx XLSX spreadsheet
3. 80ARC024R0003 Amendment 1 - J.1(b) Att. 2 - NAMS-2 Labor Category Descriptions.pdf PDF
15. Final 80ARC024R0003 - J.1(b) Att. 7 - Past Performance Relevency Matrix.xlsx XLSX spreadsheet
10. Final 80ARC024R0003 - J.1(b) Att. 2 - NAMS-2 Labor Category Descriptions-Qualifications.pdf PDF
6. Final 80ARC024R0003 - J.1(a) Att. 4 - Installation Acctountable Government Property.pdf PDF
14. Final 80ARC024R0003 - J.1(b) Att. 6 - Past Performance Questionaire.docx DOCX document
12. Final 80ARC024R0003 - J.1(b) Att. 4 - FORM CASB-CMF.pdf PDF
7. Final 80ARC024R0003 - J.1(a) Att. 5 - Technical Reference Documents.pdf PDF
2. Final 80ARC024R0003 - SF33 - Request for Proposal.pdf PDF
1. Final Request For Proposal (RFP) Cover Letter.pdf PDF
NAMS-2 Q and A - 80ARC024R0003.xlsx XLSX spreadsheet
13. Final 80ARC024R0003 - J.1(b) Att. 5 - DD Form 1861.pdf PDF
4. Final 80ARC024R0003 - J.1(a) Att. 2 - CDRL.pdf PDF
11. Final 80ARC024R0003 - J.1(b) Att. 3 - SF1408 Preaward Survey.pdf PDF
8. Final 80ARC0240003 - J.1(a) Att. 6 - Government Furnished Software.pdf PDF
5. Final 80ARC024R0003 - J.1(a) Att. 3 - Government-Furnished Property List.pdf PDF
3. Final 80ARC024R0003 - J.1(a) Att. 1 - Performance Work Statement.pdf PDF
Show all 19

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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

1-1 Instructions

Insert Offeror's Name
NAMS-2 PRICING MATRIX
Instructions:
Overall Offeror Instructions for NAMS-2 Pricing Matrix. Reference section L of the solicitation for additional details and requirements.
1. Enter Company Name in cell A1 of this sheet. Your company name will auto-populate on all worksheets/templates.
GREEN FIELDS are to be completed by the Offeror.
YELLOW FIELDS are auto-calculated.
J.1(b) Attachment 1- Cost/Price Template Workbook - Exhibits 1-12
WHITE FIELD are information only no actions are required.
2. Price Schedule Tab Instructions:

a. 1-2 Total Evaluated Price: Calculations for the Total Evaluated Price based on the evaluated prices for Phase-In, Core Contract Management, Core Technical ATM Research, and the IDIQ with CPFF task orders. This tab is auto-calculated.

b. 1-3 Phase-in: The Offerors shall complete all sections highlighted in GREEN with your most favorable pricing for Phase-In. The Phase-In period of performance is 60 days.

c. 1-4 Core Contract Management: The Offerors shall complete all sections highlighted in GREEN with your most favorable pricing for each line item. The evaluated price for the Core Contract Mangement is auto-calculated and offerors shall not adjust the estimated hours included.

d. 1-5 Core Technical ATM Research: The Offerors shall complete all sections highlighted in GREEN with your most favorable pricing for each line item. The evaluated price for the Core Technical ATM Research is auto-calculated and offerors shall not adjust the estimated hours included.

e. 1-6 IDIQ with CPFF Task Orders: The Offerors shall complete all sections highlighted in GREEN with your most favorable pricing for each line item. The evaluated price for the IDIQ is auto-calculated and offerors shall not adjust the estimated hours included.

f. 1-7 CPFF Labor Rate Build-up: The Offerors shall complete all sections of the CPFF labor rate build-up tab for the base year and all option periods. The offerors shall propose their direct labor rate, all applicable indirect rates, fixed fee amount, and any Prime burdens on subcontractors (if applicable). The offeror may insert additional columns if needed. The offeror shall include all formulas intact in thier proposal submission.

g. 1-8 Summary of Indirect Rates: The Offerors shall complete the summary and include all calculations used in deriving their composite indirect rates being proposed.

h. 1-9 Overhead-Fringe Build-up and 1-10 G&A Build-up: Offerors shall complete the indirect rate build-up exhibits in accordance with Section L of the solicitation.

i. 1-11 ODCs: Offerors shall fill-in and identify all burdens and fixed fee being applied to the estimated ODCs. Offerors shall include all calculations in their proposal.
j. Schedule of Subcontractors: Offerors shall fill-in and identify all subcontractors (Major and Minor). This includes but not limited to, subcontractors address, contract type, and basis of selection. Reference section L of the solicitation for more detailed instructions.

1-2 Total Evaluated Price

Insert Offeror's Name
DescriptionEvaluated Price
Phase-In$0
Core Contract Management$0
Core Technical ATM Research$380,000
IDIQ$1,210,000
Total Evaluated Price$1,590,000

1-3 Phase-In

Insert Offeror's Name
CLIN 001 Phase-InOfferors Proposed Amount
Firm Fixed Price-Phase-In
Evaluated Phase-in Price$0.00
*Phase-Ins Period of Performance is 60-days.

1-4 CPFF Core Contract Mgmt.

Insert Offeror's Name
Base PeriodOption Period 1Option Period 2Option to Extend
Evaluated Price per Period$0.00$0.00$0.00$0.00
Evaluated CPFF Labor Price$0.00
TypeNASA Labor Categories:Base Period (CLIN 002)Option Period 1 (CLIN 005)Option Period 2 (CLIN 007)
Year 1Year 2Year 3Year 4Year 5
Estimated HoursLabor RateExtendedEstimated HoursLabor RateExtendedEstimated HoursLabor RateExtendedEstimated HoursLabor RateExtendedEstimated HoursLabor RateExtended
CPFF$0.00$0.00$0.00$0.00$0.00
CPFF$0.00$0.00$0.00$0.00$0.00
CPFF$0.00$0.00$0.00$0.00$0.00
CPFF$0.00$0.00$0.00$0.00$0.00
CPFF$0.00$0.00$0.00$0.00$0.00
Evaluated Amount by Contract Year$0.00$0.00$0.00$0.00$0.00

1-5 CPFF Core Technical

Insert Offeror's Name
Base PeriodOption Period 1Option Period 2Option to Extend
Evaluated Price per Period$0.00$0.00$0.00$0.00
Evaluated CPFF Labor Price$0.00
TypeNASA Labor Categories:Base Period (CLIN 003)Option Period 1 (CLIN 006)Option Period 2 (CLIN 008)
Year 1Year 2Year 3Year 4Year 5
Estimated HoursLabor RateExtendedEstimated HoursLabor RateExtendedEstimated HoursLabor RateExtendedEstimated HoursLabor RateExtendedEstimated HoursLabor RateExtended
CPFFProject Manager1860$0.001860$0.001860$0.001860$0.001860$0.00
CPFFData Scientist III5580$0.003720$0.003720$0.003720$0.003720$0.00
CPFFReseach Engineer, Senior I3255$0.003255$0.003255$0.003255$0.003255$0.00
CPFFResearch Engineer, Senior II3720$0.003720$0.003720$0.003720$0.003720$0.00
CPFFResearch Engineer, Senior III3255$0.003255$0.003255$0.003255$0.003255$0.00
CPFFScientist, Senior II3720$0.003720$0.003720$0.003720$0.003720$0.00
CPFFSoftware Engineer I3720$0.003720$0.003720$0.003720$0.003720$0.00
CPFFSoftware Engineer II4650$0.004650$0.004650$0.004650$0.004650$0.00
CPFFSoftware Engineer III3255$0.003255$0.003255$0.003255$0.002790$0.00
CPFFSoftware Engineer, Senior I2790$0.002790$0.002790$0.002790$0.003255$0.00
CPFFSoftware Engineer, Senior II4650$0.004650$0.004650$0.004650$0.004650$0.00
CPFFSoftware Engineer, Senior III2790$0.002790$0.002790$0.002790$0.002790$0.00
Evaluated Amount by Contract Year$0.00$0.00$0.00$0.00$0.00

1-6 CPFF IDIQ

Insert Offeror's Name
Base PeriodOption Period 1Option Period 2Option to Extend
Evaluated Price per Period$0.00$0.00$0.00$0.00
Evaluated CPFF Labor Price$0.00
TypeNASA Labor Categories:Estimated HoursBase PeriodOption Period 1Option Period 2
Year 1Year 2Year 3Year 4Year 5
Labor RateExtendedLabor RateExtendedLabor RateExtendedLabor RateExtendedLabor RateExtended
CPFFProject Manager1488$0.00$0.00$0.00$0.00$0.00
CPFFResearch Assistant20460$0.00$0.00$0.00$0.00$0.00
CPFFResearch Fellow5580$0.00$0.00$0.00$0.00$0.00
CPFFResearch Associate2232$0.00$0.00$0.00$0.00$0.00
CPFFResearch Scientist3348$0.00$0.00$0.00$0.00$0.00
CPFFData Architect III3348$0.00$0.00$0.00$0.00$0.00
CPFFData Scientist III2325$0.00$0.00$0.00$0.00$0.00
CPFFResearcher, Aerospace2604$0.00$0.00$0.00$0.00$0.00
CPFFScientist I4464$0.00$0.00$0.00$0.00$0.00
CPFFScientist II6324$0.00$0.00$0.00$0.00$0.00
CPFFSenior Scientist II4464$0.00$0.00$0.00$0.00$0.00
CPFFReseach Engineer I1860$0.00$0.00$0.00$0.00$0.00
CPFFReseach Engineer II1860$0.00$0.00$0.00$0.00$0.00
CPFFReseach Engineer III1860$0.00$0.00$0.00$0.00$0.00
CPFFReseach Engineer, Senior I3720$0.00$0.00$0.00$0.00$0.00
CPFFResearch Engineer, Senior II5580$0.00$0.00$0.00$0.00$0.00
CPFFResearch Engineer, Senior III7440$0.00$0.00$0.00$0.00$0.00
CPFFSoftware Engineer I10416$0.00$0.00$0.00$0.00$0.00
CPFFSoftware Engineer II9300$0.00$0.00$0.00$0.00$0.00
CPFFSoftware Engineer, Senior I10044$0.00$0.00$0.00$0.00$0.00
CPFFSoftware Engineer, Senior II9672$0.00$0.00$0.00$0.00$0.00
CPFFSoftware Engineer, Senior III7440$0.00$0.00$0.00$0.00$0.00
Evaluated Amount by Contract Year$0.00$0.00$0.00$0.00$0.00

1-7 CPFF Labor Rate Build-up Insert Offeror's Name

TypeNASA Labor Categories:Offeror/Subcontractor NameLabor Category per DOLWD, CBA, GSA, or Offeror's established positionBasis of Direct Labor Rate (Ex. FPRP, Payroll, ERI Salary Survey, etc.)Year 1Year 2Year 3Year 4Year 5
Direct Labor RateFringeOverheadG&AFeeSubtotalPrime Burdens on SubconractorsFully Loaded Labor RateDirect Labor RateFringeOverheadG&AFeeSubtotalPrime Burdens on SubconractorsFully Loaded Labor RateDirect Labor RateFringeOverheadG&AFeeSubtotalPrime Burdens on SubconractorsFully Loaded Labor RateDirect Labor RateFringeOverheadG&AFeeSubtotalPrime Burdens on SubconractorsFully Loaded Labor RateDirect Labor RateFringeOverheadG&AFee
Escalation FactorEscalation FactorEscalation FactorEscalation Factor
(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Esc. Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Esc. Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Esc. Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Esc. Rate)(Insert Rate)(Insert Rate)(Insert Rate)(Insert Rate)
CPFFAdministrative Assistant
CPFFAerospace Engineer II
CPFFContracts Manager
CPFFData Architect III
CPFFData Scientist I
CPFFData Scientist II
CPFFData Scientist III
CPFFHuman Resources Manager
CPFFProject Manager
CPFFResearch Assistant
CPFFResearch Associate
CPFFResearch Engineer I
CPFFResearch Engineer II
CPFFResearch Engineer III
CPFFResearch Engineer, Senior I
CPFFResearch Engineer, Senior II
CPFFResearch Engineer, Senior III
CPFFResearch Fellow
CPFFResearch Scientist
CPFFSenior Data Scientist II
CPFFSenior Financial Analyst
CPFFSite Manager (ST)
CPFFSoftware Engineer I
CPFFSoftware Engineer II
CPFFSoftware Engineer III
CPFFSoftware Engineer, Senior I
CPFFSoftware Engineer, Senior II
CPFFSoftware Engineer, Senior III

1-8 Summary of Indirect Rates Summary of Indirect Cost Rates

[ ] Prime Contractor: __________________________________
[ ] Major Subcontractor: __________________________________
Fringe Benefits*Overhead**G&A
Example:
Portion of Contractor FY 16 From: _11/1/16_ to _4/30/17_46.00%75.00%25.00%
Portion of Contractor FY 17 From: _5/1/17_ to _10/31/1744.00%80.00%26.00%
Base Period Weighted Average45.00%77.50%25.50%
Base Period; Contract Year 1:
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Base Period Average
Base Period; Contract Year 2:
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Base Period Average
Option Period 1; Contract Year 3:
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Option Period 1 Average
Option Period 1; Contract Year 4:
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Option Period 1 Average
Option Period 2; Contract Year 5:
Portion of Contractor FY __ From: ________ to ________
Portion of Contractor FY __ From: ________ to ________
Option Period 2 Average
* Disregard if it is your normal accounting practice to include fringe benefits with overhead.
** If you plan to propose more than one overhead rate (e.g., Contractor Site OH and Customer Site OH), modify this
exhibit by adding the necessary number of columns to display all proposed overhead rates.
Offeror shall remove examples when submitting its proposal.
The example is provided to demonstrate formatting and how the data is to be submitted. The data in the example is not real and should not be interpreted as such.

1-9 Overhead-Fringe Build-up Overhead and/or Fringe Benefits (Composition of Burden Pool)

[ ] Prime Contractor: __________________________________
[ ] Major Subcontractor: _________________________________Overhead or Service Center Pool* = ___________________
Base of Application = __________________________

* Specify Type of Overhead Burden: Fringe Benefits, Labor, Onsite, Offsite, Engineering, Procurement, Service Center(s), etc.

OFFEROR'S FISCAL YEAR BEGINS ____________ AND ENDS ____________.

ActualForecast
Prior Year 3Prior Year 2Prior Year 1
Cost Elements withinContractorContractorContractorContractorContractorContractorContractorContractorContractorContractorContractor
the Overhead Burden PoolFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
20xx20xx20xx20xx20xx20xx20xx20xx20xx20xx20xx
Payroll Taxes
FICA (Social Security)
HIT (Medicare)
FUI (Federal Unemployment)
SUI (State Unemployment)
WC (Workers Comp)
Fringes:
Retirement
Health/Life Insurance
Paid Leave
Other
Other (Identify)
Facilities
Depreciation
Total Overhead Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Application Base ($)
Contractor FY Rate (%)ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

1-10 G&A Build-up General and Administrative Expense (G&A)

[ ] Prime Contractor: __________________________________
[ ] Major Subcontractor: _________________________________Base of Application = __________________________

OFFEROR'S FISCAL YEAR BEGINS ____________ AND ENDS ____________.

ActualForecast
Prior Year 3Prior Year 2Prior Year 1
Cost Elements withinContractorContractorContractorContractorContractorContractorContractorContractorContractorContractorContractor
the Overhead Burden PoolFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal YearFiscal Year
20xx20xx20xx20xx20xx20xx20xx20xx20xx20xx20xx

Labor: (Identify)

Labor Related Cost: (Taxes & Fringes Etc.)

B&P
IR&D
Corporate Allocations:
Other (Specify):
Facilities
Depreciation
Total G&A Expenses$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Distribution Base Dollars:
Existing Business Base
This Contract Base
Forecasted Business Base
Total Distribution Base $$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Calculated G&A Rates (%)ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

1-11 ODCs

DescriptionCLINYearODC DescriptionEstimated AmountIndirect RateIndirect RateIndirect RateFixed FeeIndirect Evaluated AmountEvaluated Amount
(Specify)(Specify)(Specify)(Insert Rate)
Core Technical0031ODC Travel - Project Meetings/Conferences$62,500$0$62,500
ODC Other - Conference Fees, Materials$17,500$0$17,500
2ODC Travel - Project Meetings/Conferences$62,500$0$62,500
ODC Other - Conference Fees, Materials$17,500$0$17,500
0063ODC Travel - Project Meetings/Conferences$62,500$0$62,500
ODC Other - Conference Fees, Materials$17,500$0$17,500
4ODC Travel - Project Meetings/Conferences$62,500$0$62,500
ODC Other - Conference Fees, Materials$17,500$0$17,500
0085ODC Travel - Project Meetings/Conferences$31,250$0$31,250
ODC Other - Conference Fees, Materials$8,750$0$8,750
Option to Extend Services$20,000
Evaluated Core Technical ODC Price$380,000
IDIQ0041ODC Travel - Project Meetings/Conferences$200,000$0$200,000
ODC Materials - Conferences Fee$20,000$0$20,000
2ODC Travel - Project Meetings/Conferences$200,000$0$200,000
ODC Materials - Conferences Fee$20,000$0$20,000
3ODC Travel - Project Meetings/Conferences$200,000$0$200,000
ODC Materials - Conferences Fee$20,000$0$20,000
4ODC Travel - Project Meetings/Conferences$200,000$0$200,000
ODC Materials - Conferences Fee$20,000$0$20,000
5ODC Travel - Project Meetings/Conferences$200,000$0$200,000
ODC Materials - Conferences Fee$20,000$0$20,000
Option to Extend Services$110,000
Evaluated IDIQ ODC Price$1,210,000

1-12 Schedule of Subcontractors Schedule of Subcontracts

[ ] Prime Contractor: ______________________________________

Description of Work:

Number of quotes solicited/received
Subcontractor selected:Subcontract (1) Name and AddressSubcontract (2) Name and AddressSubcontract (3) Name and AddressSubcontract (4) Name and Address

Basis of Selection:*

Type of Subcontract:**

Cost
Fee/Profit
Total Amount Proposed$ - 0$ - 0$ - 0$ - 0
Affiliation with Prime:***

Cost/Price Analysis Performed by Prime:****

* Lowest price, teaming partner, technical qualifications, etc.
** FFP, CPAF, CPFF, T&M, etc.
*** Subcontractor, subsidiary, interdivisional, etc.
**** FAR 15.404-3(b) requires that contractors conduct appropriate cost or price analyses to establish the reasonableness of proposed subcontract prices
and include the results of these analyses in the price proposal. If response above is "No", explain why cost or price analysis was not performed and how
the Offeror determined that the proposed subcontract price was reasonable.

This is the start of the file's text. The full file is on GovTribe.

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