CMC3_EPM_DRFP_Pricing.xlsx

Workbook Instructions

The Government intends to use a personal computer with Microsoft Excel to aid in the evaluation of the cost proposal. The workbook/file must be automated to the greatest extent possible. All formulas used in the workbook must be clearly visible in the individual cells and verifiable. Whereas linking among the spreadsheets within the workbook may be necessary; the use of external links (source data not provided to NASA) of any kind is prohibited. The workbook must contain no macros or hidden cells.

The EPM and all its associated workbooks shall not be locked/protected or secured by passwords.

When multiple versions of the same template are required, then submit the multiple templates inside one worksheet stacked vertically. For example, if the FBR is required for each year of a five year contract then five vertically stacked templates will be submitted under a tab titled FBR under workbook xxxxxx-Company Name.xls

All electronic file/workbook names included in the Offeror’s proposal shall begin with the appropriate workbook acronym, hyphen, followed by the first three letters of the Offeror’s company name. For example: Assume the Offeror’s company name is ABC Company and the Offeror have completed the xxxxxx workbook; the workbook/file name would be xxxxxx-ABC.xls. Offerors shall use the Template acronyms below in naming individual worksheets/tabs within an Excel file/workbook:

CMC3 Workbook Acronyms:

TRT-Core: Technical Resources Template-Core TRST-Core: Technical Resources Summary Template-Core LPT: Labor Pricing Template OPT: Overtime Pricing Template MSCST: Major Subcontractor Cost Summary Template PCST: Prime Cost Summary Template FBR: Fully Burdened Rates Template MST: Minor Subcontract Template ISCT: SR – IDIQ Summary Cost Template – Specified Resources OHT: Overhead Template GAT: General & Administrative Expense Template TC (a): Compensation Template (a): Salaries & Wages – Non-Exempt TC (b): Compensation Template (b): Salaries & Wages –Exempt TC(c): Compensation Template (c): Fringe Benefit Analysis of Compensation Plan TC (d): Compensation Template (e): Incumbency Assumptions PIT: Phase in Template CFAOT: Cognizant Federal Audit Office Template

Attachment L -2. CMC3 Excel Pricing Model (EPM) Instructions

TRT-Core

Ex: Engineer III 2.0 2.0 3.0 4.0 7.0 4.0 6.0 10.0 15.0 8.0 43.0 54.0

RFP - NNJxxxxxxx &"Arial,Bold"Technical Resources Template (TRT)-CF Cost Reimbursable &"Arial,Bold"Attachment Lxx

This template is required by the prime Offeror only. This template is required for each Statement of Work area identified as completion form core effort. The template is designed to identify and summarize by lowest level SOW paragraphs all of the proposed labor and non-labor resources for CY 1. These templates require labor resources identification in WYEs by SLC. The TRT include columns that correspond to the lowest SOW paragraphs. A separate TRT template for ISS Core and Orion Core is required for each contract core type (the two boxes at the top section of this template are provided to facilitate this).

TRST-Core Instructions

Incumbent Retention %

Offerors are required to provide the percent of incumbent workforce they intend to retain by SLC (for the ISS Core and ORION Core work).

WYE Resources Basis

Offerors are required to fill in their assumed staffing level prior to implementation of any efficiencies that result from the application of the Offeror’s technical and management approach. The Offeror shall provide rationale, detailed narrative, and validation of their resources basis in Volume I, Mission Suitability (for the ISS Core and Orion Core).

Proposed WYEs with Efficiencies

If efficiencies are proposed, the Offeror shall include all proposed labor resources after implementation of efficiencies resulting from its technical and management approach to satisfying the SOW requirements (for the ISS Core and Orion Core). The Offeror shall also provide an integrated discussion including rationale, detailed narrative, and validation of their resources with the proposed efficiencies implemented as part of their responses in Volume I, Mission Suitability. Sufficient detail to allow a thorough Government understanding and analysis of the proposed efficiency must be provided. The Offeror’s proposal must present a clear and consistent description of what is being proposed across all sections.

NLR Resources Basis

Offerors are required to identify their proposed NLR costs prior to the implementation of any efficiencies that result from the application of the Offeror’s technical and management approach (for the ISS Core and Orion Core work requirements). The Offeror shall provide rationale, detailed narrative, and validation of their NLR resources basis in Volume I, Mission Suitability.

Proposed NLR Cost with Efficiencies

If an Offeror proposes efficiencies, then the Offeror shall include all proposed NLR cost after implementation of the efficiencies in accordance with the Offeror’s technical and management approach to satisfying the ISS Core and Orion Core work requirements. The Offeror shall also provide an integrated discussion including rationale, detailed narrative, and validation of their resources with the proposed efficiencies implemented as part of their responses in Volume I – Mission Suitability. Sufficient detail to allow a thorough Government understanding and analysis of the proposed efficiency must be provided. The Offeror’s proposal must present a clear and consistent description of what is being proposed across all sections.

If no efficiencies are proposed, the NLR cost proposed in the “NLR Resources Basis” column is to be identical to the “Proposed NLR Cost with Efficiencies” column.

Delta from Resources Basis

These columns are automated and designed to calculate deltas between the resources (labor and NLR) identified both prior to the implementation of any proposed efficiencies and after the implementation of proposed efficiencies for Contract Year 1 only (for the ISS Core and Orion Core). These deltas must be fully justified in accordance with the instructions for the “BOE” paragraph in Volume I – Mission Suitability.

Reference

This column shall be used by the Offerors to refer the NASA evaluators to the specific Volume I, Mission Suitability “BOE” paragraph which provides the analysis of the efficiency resulting in the resource delta(s). The NASA evaluators will compare all “BOE” paragraphs to proposed resources for equivalence and to ensure all parts of the proposal reconcile.

Important Note: A separate TRST template for the ISS Core and for the Orion Core is required for each contract core type. The TRST functions as a link between Volume I, Mission Suitability and Volume III, Cost/Price Proposal.

Technical Resources Summary Template- ISS and Orion Core Template Instructions

TRST-Core

Note 1: The prime offeror shall populate the proposed WYE columns and the proposed NLR columns, inclusive of the Prime, Major and Minor subcontractors' proposed labor and nonlabor resources, respectively. It is very important that your reference column refer evaluators to all the Efficiencies or Cost Savings supporting data in the CS paragraph of Volume xx, Mission Suitability. If the labor resources are unchanged from the resource basis, no reference is required.

RFP - NNJxxxxxxx &11Technical Resources Summary Template (TRST)-CF Cost Reimbursement Section L Attachment L-xx

This template is required only from the Prime Offerors. This template is designed to summarize all proposed labor resources by SLC – both prior to the implementation of any proposed efficiencies and after the implementation of proposed efficiencies for the ISS Core and Orion Core work requirements. Offerors are required to complete a separate TRST template for the ISS Core and for the Orion Core.

LPT

EXAMPLE (Direct Labor Rate): Engineer III $ 50.00 $ 51.50 $ 53.05 $ 54.64 $ 56.28 $ 57.96 $ 59.70

EXAMPLE (ST Direct Labor Cost): Engineer III $ 6,872,400

RFP - NNJxxxxxxx SECTION L

&A Page &P of &N

A separate template is required from the prime Offeror and each major subcontractor(s). This template is intended to identify the proposed productive hours that are compensated at straight-time direct labor rates. In addition, the prime and each major subcontractor(s) are required to complete a separate LPT template for the ISS Core and the Orion Core.

Productive Hours

This section addresses Productive Hours. The Offeror shall determine the mix of labor categories and the labor hours required to perform the Core portion of the SOW based on the use of straight-time direct labor rates.

Straight-Time

This section identifies the straight-time direct labor rates per SLC.

Total Straight-time Direct Labor Cost

This section addresses the total straight-time direct labor cost associated with multiplying the Productive Hours by the straight-time direct labor rates per SLC.

Note

The hours and cost shown on this template shall support and reconcile to the hours and cost shown on either the Offeror’s Prime Cost Summary Template (PCST) or the Major Subcontractor Cost Summary Template (MSCST), as applicable.

Incumbent Retention %

Offerors are required to provide the percent of incumbent workforce they intend to retain by SLC.

Conversion Factor The Offeror is required to provide the factor used to convert WYEs into productive hours by SLC based on the Offeror’s approved accounting practices.

OPT

EXAMPLE (OT Labor Rate): Analyst II $ 45.00 $ 46.35 $ 47.74 $ 49.17 $ 50.65 $ 52.17 $ 53.73

EXAMPLE (Overtime Direct Labor Cost): Analyst II $ 309,258

RFP - NNJxxxxxxx SECTION L

&A Page &P of &N

A separate template is required from the prime Offeror and each major subcontractor(s). This template is intended to identify the proposed productive hours that are compensated at overtime direct labor rates. In addition, the prime and each major subcontractor(s) are required to complete a separate OPT template for the ISS Core and the Orion Core.

Productive Hours

The Offeror shall determine the mix of labor categories and the labor hours required to perform the Core portion of the SOW based on the use of overtime direct labor rates.

Overtime Direct Labor Rates

The Offeror shall provide the overtime direct labor rates per SLC.

Overtime Direct Labor Cost

The third section addresses the total overtime direct labor cost associated with multiplying the Productive Hours by the overtime direct labor rates.

Note

The hours and cost shown on this template shall support and reconcile to the hours and cost shown on either the Offeror’s Prime Cost Summary Template (PCST) or the Major Subcontractor Cost Summary Template (MSCST), as applicable.

MSCST

Sub-Total Cost $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

NOTE: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas and where otherwise identified.

RFP - NNJxxxxxx Section L

A separate template is required of each major subcontractor. This template is intended to identify all major subcontractor proposed hours, cost, and fee by contract period. In addition, the each major subcontractor(s) are required to complete a separate template for the ISS Core and the Orion Core.

Reference

This column has been provided on the template for the Offeror to use in identifying where the supporting data for each cost element is located in the Offeror’s cost proposal narrative. The cost data submitted shall be clearly displayed and detailed so that the Government may fully understand the cost development and computations.

PCST

Sub-Total Cost $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

NOTE: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas and where otherwise identified.

RFP - NNJxxxxxx Section L

This template is required of the Prime Offeror only. This template is intended to identify all Prime Offeror proposed hours, cost, and fee by contract period. In addition, the prime is required to complete a separate PCST template for the ISS Core and the Orion Core.

Reference

This column has been provided on the template for the Offeror to use in identifying where the supporting data for each cost element is located in the Offeror’s cost proposal narrative. The cost data submitted shall be clearly displayed and detailed so that the Government may fully understand the cost development and computations.

FBR Instructions

The top of this template, the columns below the blue area shall be completed by the prime contractor; likewise, the columns below the yellow area shall be completed by the major subcontractor.

The first two columns address the Offeror’s direct labor categories and the NASA Standard Labor Categories (SLCs).

Percentage Usage Column Provided so that the Offeror may weigh the proposed direct labor per the Offeror’s labor categories. The usage percentage must total to 100% for each SLC. In addition the Direct Labor Rate column is provided so that the Offeror may provide the average direct labor cost for each SLC while simultaneously mapping the Offeror’s job categories into the SLC’s. In the example, it is assumed that for the SLC “Engineer I,” the Offeror has two Offeror specific categories that map into this category. The two categories are “Mechanical Engineer” at $28.75/hr. and “Propulsion Engineer” at $25.25/hr. The Offeror (prime or subcontractor) also assumes that its specific labor category will be utilized 75% and 25%, respectively. Hence, the rates that should show up as the composite SLC rate for this specific category is derived as follows: ($28.75/hr. * 75%) + ($25.25/hr. * 25%) = $27.88. Note that this is simply an example and it may not capture all possibilities.

Overhead Rate The Overhead Cost column is the overhead cost per hour of labor. In the example, it is assumed that the Offeror’s overhead rate is applied solely to direct labor cost. However, it may be modified to accommodate the Offeror’s specific accounting system. You may add rows or columns to facilitate this. However, do not remove any SLC’s in your submitted templates. The overhead rate(s) provided on this template should tie directly to the overhead rate(s) provided on the overhead rate template (OHT) discussed below.

General and Administration (G&A) The G&A Cost column is the G&A cost per hour of labor. In the example, it is assumed that the G&A rate is applied to both direct labor and overhead cost. However, it may be modified to accommodate the Offeror’s specific accounting system. The G&A rate provided on this template should tie directly to the G&A rate provided on the G&A rate template (GAT) discussed below.

Facilities Capital Cost of Money Provided should the Offeror both have this cost element and propose it as an allowable cost.

Fee Applicable to the major subcontractors only, if the major subcontractor is not sharing in a fee pool, and is proposing their own separate fee structure.

The FBR column basically combines the direct labor hourly rate and all the indirect costs, along with the subcontractor fee if applicable, to arrive at the prime Offeror’s or major subcontractors fully burdened labor rate per SLC.

Note: Major subcontractor(s) must complete the information on this template except at the subcontractor price input area and to the right of the subcontractor price input area. The subcontract price input area is only applicable to the prime Offeror who must provide the integrated subcontractor FBR as part of the blended FBR of the prime and subcontractor.

Subcontractor Price Input Area Addresses the subcontractor fully burdened rates. This area shall be completed by the prime Offeror. In the Subcontractor FBR column(s), the subcontractor(s) shall provide to the prime Offeror their fully burdened labor rate(s) and shall be one composite rate per SLC per subcontractor. The major subcontractor FBR is determined by the major subcontractor completing the FBR template and determining the FBR that shall be charged to the prime Offeror. The minor subcontractor FBR is determined by the minor subcontractor and provided to the prime Offeror. The prime Offeror will document the minor subcontractor’s FBR on the Minor Subcontractor Template (MST) discussed below. If more than one subcontractor (major or minor) is being proposed, then the prime Offeror is responsible for providing each subcontractor’s fully burdened rate in each column. In the template, three columns are provided and identified as Subcontractor “A”, “B” and “C”. More columns may be added as necessary. In this example, subcontractor “A” and subcontractor “B” are provided for illustrative purposes.

Prime Offeror Burdens Rate The rate that the prime Offeror may apply as a burden to the major or minor subcontractor FBR, if applicable. The Prime Offeror then combines the Subcontractor FBR with the Prime Burdens Rate to arrive at a total rate that addresses the use of the particular subcontractor.

The Percentage Usage Prime/Sub Addresses the weighting of the Prime FBR versus the Subcontractor FBR. Based upon this weighting, a Team Composite (Prime and Subcontractor) FBR can be determined. In the example, for Business Specialist 3, it is assumed that the prime Offeror has determined that the prime will perform 80% of the effort under this SLC, and that Subcontractor “A” and Subcontractor “B” will perform 12% and 8% of the effort under this SLC, respectively. The weighting results in a Team Composite FBR of $55.00 per hour.

Team Composite (prime Offeror and all subcontractors) FBR per Hour Addresses the final composite FBR that the prime Offeror has calculated. Important Note: The FBR identified in this column shall be the FBR that is included in Section B.6 of the Model Contract.

Team Composite Overtime (prime Offeror and all subcontractors) FBR per Hour If proposed, the Offeror must be clear on how the overtime FBR was calculated in their cost narrative discussion. Also, as with the rest of the template, include the formula within the cell to demonstrate the calculation. For example, the formula should demonstrate that if an Analyst 2 is paid time and a half, that the fringe costs are not included at time and a half also.

Fully Burdened Rates Template Instructions

FBR

RFP - NNJxxxxxxx &12Section L

A separate FBR is required for each contract year of the effort from both the prime Offeror and each major subcontractor(s). This template is provided so that each Offeror may show how they arrived at their individually proposed fully burdened rates including profit/fee.

MST

MINOR SUBCONTRACT TEMPLATE (MST)

Prime Contractor Name:

RFP - NNJxxxxxxx SECTION L

&A Page &P of &N

The minor subcontractor template is required of the prime Offeror only. This template is intended to provide the evaluation team with a concise assessment of the substance of minor subcontracts. Below is an example showing how this template is to be completed.

ISCT - SR

IDIQ Summary Cost Template - Specified Resources (ISCT - SR)

Prime Contractor Name:

THIS IDIQ SCT - SPHs & NLRs WILL BE USED FOR SOURCE SELECTION PURPOSES.

CONTRACT RATES