J.1(b)1 Cost-Price Template Workbook COSMC.xlsx
XLSX spreadsheet 58 KB Posted
- Attached to
- Center Occupational Safety, Health, Medical, System Safety and Mission Assurance Contract (COSMC)
- Solicitation number
- 80ARC024R0009
About this file
This document is a pricing template titled "J.1(b)1 Cost-Price Template Workbook COSMC.xlsx" related to a federal contract opportunity for the Center Occupational Safety, Health, Medical, System Safety and Mission Assurance Contract (COSMC).
The template provides instructions and worksheets for the offeror to input their pricing for the contract, including a Firm Fixed Price for a 42-day Phase-In period, as well as Cost-Plus-Fixed-Fee (CPFF) pricing for the Core Contract Management and IDIQ task orders. The template includes worksheets for the offeror to provide labor rates, indirect rate buildups, ODC pricing, and a schedule of subcontractors. The total evaluated price for the opportunity is $2,551,679. The contract has a base period of 1 year and 4 option periods. The procurement is being conducted by the National Aeronautics and Space Administration (NASA) Ames Research Center, and may also support the Armstrong Flight Research Center through task orders.
View the file
Other files
Show all 23
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
1-1 Instructions
| Insert Offeror's Name |
| COSMC PRICING MATRIX |
| Instructions: |
| Overall Offeror Instructions for COSMC 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. |
| 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 and the IDIQ with CPFF task orders. This tab is auto-calculated.
b. 1-3 Phase-in: offeror to provide FFP price for 42 day Phase-In period, which shall show the price build-up that is consistent with the proposed phase-in plan.
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. Add/delete rows as necessary
e. 1-5 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-6 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, FCCOM (if applicable), 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-7 Summary of Indirect Rates: The Offerors shall complete the summary and include all calculations used in deriving their composite indirect rates and FCCOM (if applicable) being proposed.
h. 1-8 Overhead-Fringe Build-up and 1-9 G&A Build-up: Offerors shall complete the indirect rate build-up exhibits in accordance with Section L of the solicitation.
| i. 1-10 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. 1-11 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. |
80ARC024R0009 Attachment J.1(b)1
&P
1-2 Total Evaluated Price
| Insert Offeror's Name | ||
| Description | Evaluated Price | |
| Phase-In | $0 | |
| Core Contract Management | $0 | |
| IDIQ | $2,551,679 | |
| Total Evaluated Price | $2,551,679 |
80ARC024R0009 Attachment J.1(b)1
&P
1-3 Phase-In
| Insert Offeror's Name | ||
| CLIN 001 Phase-In | Offerors Proposed Amount | |
| Firm Fixed Price-Phase-In | ||
| Evaluated Phase-in Price | $0.00 | |
| *Phase-In Period of Performance is 42-days (1/2/2025 - 2/13/2025) | ||
| Enter FFP and buildup demonstrating consistency with Phase In Plan | ||
| Show build up of Price supporting approach |
80ARC024R0009 Attachment J.1(b)1
&P
1-4 CPFF Core Contract Mgmt.
| Insert Offeror's Name | |||||||
| Base Period | Option Period 1 | Option Period 2 | Option Period 3 | Option Period 4 | Option to Extend | ||
| Evaluated Price per Period | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Evaluated CPFF Labor Price | $0.00 |
| Type | NASA Labor Categories: | Base Period (CLIN 002) 2/14/2025 - 2/13/2026 | Option Period 1 (CLIN 004) 2/14/2026 - 2/13/2027 | Option Period 2 (CLIN 005) 2/14/2027 – 2/13/2028 | Option Period 3 (CLIN 006) 2/14/2028 – 2/13/2029 | Option Period 4 (CLIN 007) 2/14/2029 – 2/13/2030 | ||||||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||||
| Estimated Hours | Labor Rate | Extended | Estimated Hours | Labor Rate | Extended | Estimated Hours | Labor Rate | Extended | Estimated Hours | Labor Rate | Extended | Estimated Hours | Labor Rate | Extended | ||
| 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 |
80ARC024R0009 Attachment J.1(b)1
&P
1-5 CPFF IDIQ
| Insert Offeror's Name | ||||||||||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Option to Extend | |||||||
| Evaluated Price per Period | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||
| Evaluated CPFF Labor Price | $0.00 | |||||||||||
| CLIN 003 | ||||||||||||
| Type | NASA Labor Categories: | Estimated Hours | 2/14/2025 – 2/13/2026 | 2/14/2026 – 2/13/2027 | 2/14/2027 – 2/13/2028 | 2/14/2028 – 2/13/2029 | 2/14/2029 – 2/13/2030 | |||||
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||
| Labor Rate | Extended | Labor Rate | Extended | Labor Rate | Extended | Labor Rate | Extended | Labor Rate | Extended | |||
| CPFF | Physician (Part Time Backup) | 376.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Medical Director | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Nurse Practitioner (NP) | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Registered Nurse (RN) | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Licensed Vocational Nurse (LVN) | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Optomitrist | 188.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Clinic Operations Manager | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Fitness Center Monitor | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Fitness Trainer/Manager | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Senior Industrial Hygienist | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Industrial Hygienist (Lead and Asbestos) | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Industrial Hygiene Technician | 5,640.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Health Physics Technician | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Health Physicist | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Fire Protection Engineer | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Safety Engineer (Generalist) | 4,230.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Safety Analyst | 3,760.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Senior Safety Engineer | 5,640.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Training Specialist | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Quality Assurance Engineer Level I | 2,538.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Software Assurance & Systems Safety Level I | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Systems Safety Engineer, Electrical Level I | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Software Assurance & Software Safety Level II | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Systems Safety Engineer Level I | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | Pressure Systems Safety Engineer | 1,880.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | AFRC SME I | 3,760.0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| CPFF | AFRC SME II | 3,760.0 | $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 |
80ARC024R0009 Attachment J.1(b)1
&P
1-6 CPFF Labor Rate Build-up Insert Offeror's Name
| Type | NASA Labor Categories: | Offeror/Subcontractor Name | Labor Category per DOLWD, CBA, GSA, or Offeror's established position | Basis of Direct Labor Rate (Ex. FPRP, Payroll, ERI Salary Survey, etc.) | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||||||||||||||||||||||||||||||||
| Direct Labor Rate | Fringe | Overhead | G&A | Fee | Subtotal | Prime Burdens on Subconractors | Fully Loaded Labor Rate | Direct Labor Rate | Fringe | Overhead | G&A | Fee | Subtotal | Prime Burdens on Subconractors | Fully Loaded Labor Rate | Direct Labor Rate | Fringe | Overhead | G&A | Fee | Subtotal | Prime Burdens on Subconractors | Fully Loaded Labor Rate | Direct Labor Rate | Fringe | Overhead | G&A | Fee | Subtotal | Prime Burdens on Subconractors | Fully Loaded Labor Rate | Direct Labor Rate | Fringe | Overhead | G&A | Fee | |||||||||||||
| Escalation Factor | Escalation Factor | Escalation Factor | Escalation 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) |
| CPFF | Physician (Part Time Backup) |
| CPFF | Medical Director |
| CPFF | Nurse Practitioner (NP) |
| CPFF | Registered Nurse (RN) |
| CPFF | Licensed Vocational Nurse (LVN) |
| CPFF | Optomitrist |
| CPFF | Clinic Operations Manager |
| CPFF | Fitness Center Monitor |
| CPFF | Fitness Trainer/Manager |
| CPFF | Senior Industrial Hygienist |
| CPFF | Industrial Hygienist (Lead and Asbestos) |
| CPFF | Industrial Hygiene Technician |
| CPFF | Health Physics Technician |
| CPFF | Health Physicist |
| CPFF | Fire Protection Engineer |
| CPFF | Safety Engineer (Generalist) |
| CPFF | Safety Analyst |
| CPFF | Senior Safety Engineer |
| CPFF | Training Specialist |
| CPFF | SME I - Quality Assurance Engineer |
| CPFF | SME I - Software Assurance & Systems Safety |
| CPFF | SME I - Systems Safety Engineer, Electrical |
| CPFF | SME II - Software Assurance & Software Safety |
| CPFF | SME II - Systems Safety Engineer |
| CPFF | Pressure Systems Safety Engineer |
| CPFF | AFRC SME I |
| CPFF | AFRC SME II |
80ARC024R0009 Attachment J.1(b)1
&P
1-7 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/17 | 44.00% | 80.00% | 26.00% |
| Base Period Weighted Average | 45.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. |
80ARC024R0009 Attachment J.1(b)1
&P
1-8 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 ____________.
| Actual | Forecast | ||||||||||
| Prior Year 3 | Prior Year 2 | Prior Year 1 | |||||||||
| Cost Elements within | Contractor | Contractor | Contractor | Contractor | Contractor | Contractor | Contractor | Contractor | Contractor | Contractor | Contractor |
| the Overhead Burden Pool | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year |
| 20xx | 20xx | 20xx | 20xx | 20xx | 20xx | 20xx | 20xx | 20xx | 20xx | 20xx |
| 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! |
80ARC024R0009 Attachment J.1(b)1
&P
1-9 G&A Build-up General and Administrative Expense (G&A)
| [ ] Prime Contractor: __________________________________ | |
| [ ] Major Subcontractor: _________________________________ | Base of Application = __________________________ |
OFFEROR'S FISCAL YEAR BEGINS ____________ AND ENDS ____________.
| Actual | Forecast | ||||||||||
| Prior Year 3 | Prior Year 2 | Prior Year 1 | |||||||||
| Cost Elements within | Contractor | Contractor | Contractor | Contractor | Contractor | Contractor | Contractor | Contractor | Contractor | Contractor | Contractor |
| the Overhead Burden Pool | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year | Fiscal Year |
| 20xx | 20xx | 20xx | 20xx | 20xx | 20xx | 20xx | 20xx | 20xx | 20xx | 20xx |
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! |
80ARC024R0009 Attachment J.1(b)1
&P
1-10 ODCs
| Description | CLIN | Year | ODC Description | Estimated Amount | Indirect Rate | Indirect Rate | Indirect Rate | Fixed Fee | Indirect Evaluated Amount | Evaluated Amount |
| (Specify) | (Specify) | (Specify) | (Insert Rate) |
| IDIQ | 003 | 1 | EAP | $200,787 | $0 | $200,787 |
| Supplies, Equipment, Calibration, Travel, Training | $250,000 | $0 | $250,000 | |||
| 2 | EAP | $206,709 | $0 | $206,709 | ||
| Supplies, Equipment, Calibration, Travel, Training | $250,000 | $0 | $250,000 | |||
| 3 | EAP | $212,621 | $0 | $212,621 | ||
| Supplies, Equipment, Calibration, Travel, Training | $250,000 | $0 | $250,000 | |||
| 4 | EAP | $218,766 | $0 | $218,766 | ||
| Supplies, Equipment, Calibration, Travel, Training | $250,000 | $0 | $250,000 | |||
| 5 | EAP | $225,197 | $0 | $225,197 | ||
| Supplies, Equipment, Calibration, Travel, Training | $250,000 | $0 | $250,000 | |||
| Option to Extend Services | $237,599 | |||||
| Evaluated IDIQ ODC Price | $2,551,679 |
80ARC024R0009 Attachment J.1(b)1
&P
1-11 Schedule of Subcontractors Schedule of Subcontracts
[ ] Prime Contractor: ______________________________________
Description of Work:
| Number of quotes solicited/received | ||||
| Subcontractor selected: | Subcontract (1) Name and Address | Subcontract (2) Name and Address | Subcontract (3) Name and Address | Subcontract (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. |
80ARC024R0009 Attachment J.1(b)1
&P
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 .