80LARC24R0011 - Attachment L-2 Pricing Model.xlsx
XLSX spreadsheet 52 KB Posted
- Solicitation number
- 80LARC24R0011DRFP
About this file
This document is an attachment (Attachment L-2 Pricing Model) to a draft Request for Proposal (RFP) for the Evaluations, Assessments, Studies, Services, and Support 4 (EASSS 4) contract opportunity.
The EASSS 4 contract is a Cost-Plus-Fixed-Fee (CPFF) Indefinite Delivery/Indefinite Quantity (IDIQ) contract with a 5-year ordering period. The contract will support evaluations, assessments, studies, services, and support for the Science Office for Mission Assessments (SOMA) and other NASA organizations. The RFP is a small business set-aside with a North American Industry Classification System (NAICS) code of 541715 and a size standard of 1,000 employees. The current planned RFP release date is December 10, 2024, with proposals due approximately 60 days later. The anticipated contract award date is July 2025, with an October 1, 2025 contract effective date. The contract will be performed offsite. The pricing model instructions in this attachment provide details on how offerors should complete the pricing tables for CPFF labor, travel, other direct costs (ODCs), and indirect rates.
View the file
Other files
Show all 28
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 |
| Attachment L-2 EASSS 4 Pricing Model |
| Instructions: |
| Overall Offeror Instructions for Attachment L-2 Pricing Model. |
| 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. |
2. Price Schedule Tab Instructions:
a. 1-2 Total Proposed Price: Calculations for the Total Proposed Price based on the CPFF Labor, Travel, ODCs and option to extend services. This tab is auto-calculated.
b. 1-3 CPFF Labor Price: This tab is auto calculated based on the offerors inputs on tab 1-4 CPFF Labor Rate build up. It is the offerors responsibilty to verify the fully loaded rates in 1-3 CPFF Labor Price match those included in tab 1-4 CPFF Labor Rate Build up. Offerors may allocate hours to subcontractors by adding additional rows as needed. However, the total evaluated hours by labor category must equal the amounts included in tab 1-3 CPFF Labor Price.
c. 1-4 CPFF Labor Rate Build-up: The Offerors shall complete all sections of the CPFF labor rate build-up tab for years 1-5. 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.
d. 1-5 Travel and ODCs: The Offeror shall complete all sections highlighted in GREEN by proposing any applicable burden (Ex. Material Handling, G&A, etc.) that would be applied to Travel and/or ODCs during contract execution. The ODC burdens shall NOT include profit/fee as ODCs will be awarded on a no profit or fee basis. The offeror may insert additional columns if needed. The offeror shall include all formulas intact in thier proposal submission. The evaluated price for Travel and ODCs is auto-calculated and offerors shall not adjust the Government provided ODC amounts.
e. 1-6 Summary Indirect Rates: The Offerors shall complete the summary and include all calculations used in deriving the indirect rates being proposed.
| f. 1-7 Fringe and Overhead and 1-8 G&A: Offerors shall complete the indirect rate build-up exhibits in accordance with Section L of the solicitation. Additional tabs may be added for additional indirect rates (if applicable). |
| g. Schedule of Subcontractors: Offerors shall fill-in and identify ALL subcontractors. This includes but not limited to, subcontractors address, contract type, and basis of selection. Reference section L of the solicitation for more detailed instructions. |
| h. 1-10 Limit on Subcontracting: Offerors shall complete and provide the information necessary to demonstrate that it meets the limitations set forth in FAR 52.219-14(b)(1) (OCT 2022), Limitations on Subcontracting (see L.7 of the RFP). |
1-2 Total Proposed Price
| Insert Offeror's Name | ||
| Description | Proposed Price | |
| CPFF Labor | $0 | |
| Travel | $2,494,558 | |
| ODCs | $303,686 | |
| Total Proposed Price | $2,798,244 |
1-3 CPFF Labor Price
| 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 |
| Cost-plus Fixed Fee Labor | ||||||||||||||||
| Type | NASA Labor Categories: | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||
| Evaluated Hours | Labor Rate | Extended | Evaluated Hours | Labor Rate | Extended | Evaluated Hours | Labor Rate | Extended | Evaluated Hours | Labor Rate | Extended | Evaluated Hours | Labor Rate | Extended | ||
| CPFF | SME | 42,713 | $0.00 | $0.00 | 53,550 | $0.00 | $0.00 | 63,002 | $0.00 | $0.00 | 56,525 | $0.00 | $0.00 | 29,436 | $0.00 | $0.00 |
| CPFF | Study Manager | 6,788 | $0.00 | $0.00 | 8,510 | $0.00 | $0.00 | 10,012 | $0.00 | $0.00 | 8,983 | $0.00 | $0.00 | 4,678 | $0.00 | $0.00 |
| CPFF | Editor/Technical Writer | 297 | $0.00 | $0.00 | 372 | $0.00 | $0.00 | 438 | $0.00 | $0.00 | 393 | $0.00 | $0.00 | 205 | $0.00 | $0.00 |
| CPFF | Data/Task Integrator | 453 | $0.00 | $0.00 | 567 | $0.00 | $0.00 | 667 | $0.00 | $0.00 | 599 | $0.00 | $0.00 | 312 | $0.00 | $0.00 |
| Total | 50,251 | $0.00 | 62,999 | $0.00 | 74,119 | $0.00 | 66,500 | $0.00 | 34,631 | $0.00 |
1-4 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 | SME | ||||||||||||||||||||||||||||||||||||||||||||||||
| CPFF | Study Manager | ||||||||||||||||||||||||||||||||||||||||||||||||
| CPFF | Editor/Technical Writer | ||||||||||||||||||||||||||||||||||||||||||||||||
| CPFF | Data/Task Integrator |
1-5 Travel and ODCs
| Insert Offeror's Name | |||||||
| Travel | Period | Estimated Amount | Indirect Rate | Indirect Rate | Indirect Evaluated Amount | Evaluated Amount | |
| (Specify) | (Specify) | ||||||
| Travel | Year 1 | $548,209 | $409,893 | ||||
| Year 2 | $689,465 | $513,896 | |||||
| Year 3 | $813,905 | $604,603 | |||||
| Year 4 | $732,767 | $542,446 | |||||
| Year 5 | $382,569 | $282,480 | |||||
| Option to Extend Services | $141,240 | ||||||
| Evaluated Travel Price | $2,494,558 | ||||||
| ODCs | Period | Estimated Amount | Indirect Rate | Indirect Rate | Indirect Evaluated Amount | Evaluated Amount | |
| (Specify) | (Specify) | ||||||
| ODCs | Year 1 | $64,491 | $49,900 | ||||
| Year 2 | $81,108 | $62,561 | |||||
| Year 3 | $95,747 | $73,604 | |||||
| Year 4 | $86,202 | $66,037 | |||||
| Year 5 | $45,005 | $34,389 | |||||
| Option to Extend Services | $17,195 | ||||||
| Evaluated ODC Price | $303,686 |
1-6 Summary Indirect Rates
| Insert Offeror's Name |
| 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 |
| Option Period 1; Contract Year 2: |
| Portion of Contractor FY __ From: ________ to ________ |
| Portion of Contractor FY __ From: ________ to ________ |
| Base Period Average |
| Option Period 2; Contract Year 3: |
| Portion of Contractor FY __ From: ________ to ________ |
| Portion of Contractor FY __ From: ________ to ________ |
| Option Period 1 Average |
| Option Period 3; Contract Year 4: |
| Portion of Contractor FY __ From: ________ to ________ |
| Portion of Contractor FY __ From: ________ to ________ |
| Option Period 1 Average |
| Option Period 4; 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. |
80ARC019R0004P00008 J(b) Attachment 1 Exhibit 11
Page &P of &N
1-7 Fringe & Overhead
| Insert Offeror's Name |
| 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! |
80ARC019R0004P00008 J(b) Attachment 1 Exhibit 12
Page &P of &N
1-8 G&A
| Insert Offeror's Name |
| 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! |
80ARC019R0004P00008 J(b) Attachment 1 Exhibit 13
Page &P of &N
1-9 Schedule of Subcontractors
| Insert Offeror's Name |
| 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. |
1-10 Limit on Subcontracting
| Verification of Limitations on Subcontracting |
| EASSS 4 |
Offeror: _________________________________________________
FAR 52.219-14, Limitations on Subcontracting
| Cost of Contract Performance Calculations: |
| Prime Offeror's cost of contract performance including similarly situated Subcontractors/Consultants (i.e., burdened labor cost excluding profit). |
| Not Similarly Situated Subcontractors' cost of contract performance (i.e., burdened labor cost excluding profit). |
| Total Cost of Contract Performance: |
| Percent Calculations: |
| Prime Offeror's percent of the cost of contract performance: |
| Subcontractors' percent of the cost of contract performance: |
| TOTAL: |
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 .