Attachment L-3 SMAEC III Excel Pricing Model (EPM) Amendment 1 .xlsx

TRT STO 1

Ex: Engineer 3 0.75 - 0 0.60 0.25 - 0 0.20 - 0 1.80 0.45 0.05 2.30 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 2.30

INSTRUCTIONS TO OFFERORS

This template is required from the Prime Offeror only. It is used to identify and summarize all proposed labor resources, by SLC, and the types of non-labor resources (NLRs) for all SOW sections for Contract Year (CY) 1. The format is automated and only requires the Prime Offeror to include source data (WYEs) and identify types of NLRs required in areas shaded in blue. Resources should be allocated to the appropriate SOW sections in accordance with your Management and Technical approach. The resources identified by the Prime Offeror are the combined resources for your entire team (Prime Offeror and ALL subcontractors).

Note: A Basis of Estimate (BOE) for the WYEs and skill mix, along with supporting rationale for any NLRs identified as necessary, is required in accordance with Attachment L-1, Sample Task Orders. The BOE is to be included with Volume I.

***Note: A copy of the TRT STO 1 template shall be included in Volume I, Mission Suitability Factor, Technical Approach (TA) - Mission Suitability Subfactor 1, under TA.2. It is not utilized in support of Volume III, Cost and Price Factor***

TRT STO 2

Ex: Engineer 3 0.75 - 0 0.60 0.25 - 0 0.20 - 0 1.80 0.45 0.05 2.30 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 2.30

This template is required from the Prime Offeror only. It is used to identify and summarize all proposed labor resources, by SLC, and the types of non-labor resources (NLRs) for all SOW sections for Contract Year (CY) 1. The format is automated and only requires the Prime Offeror to include source data (WYEs) and identify types of NLRs required in areas shaded in blue. Resources should be allocated to the appropriate SOW sections in accordance with your Management and Technical approach. The resources identified by the Prime Offeror are the combined resources for your entire team (Prime Offeror and ALL subcontractors).

Note: A Basis of Estimate (BOE) for the WYEs and skill mix, along with supporting rationale for any NLRs identified as necessary, is required in accordance with Attachment L-1, Sample Task Orders. The BOE is to be included in Volume I.

***Note: A copy of the TRT STO 2 template shall be included in Volume I, Mission Suitability Factor, Technical Approach (TA) - Mission Suitability Subfactor 1, under TA.2. It is not utilized in support of Volume III, Cost and Price Factor***

TRT SOW 1.0

Ex: Business Specialist 2 - 0 0.50 0.30 - 0 1.50 0.40 - 0 - 0 - 0 0.65 - 0 - 0 3.35 3.35

This template is required from the Prime Offeror only. It is used to identify and summarize all proposed labor resources, by SLC, and all non-labor resources (NLRs) for SOW 1.0 for Contract Year (CY) 1. The format is automated and only requires the Prime Offeror to include source data (WYEs and NLRs) in areas shaded in blue. Labor resources should be allocated to the appropriate SOW sections in accordance with your Management and Technical approach. The resources identified by the Prime Offeror are the combined resources for your entire team (Prime Offeror and ALL subcontractors).

Note: A Basis of Estimate (BOE) for the WYEs, skill mix, and NLRs, along with supporting rationale, is required in accordance with Section L.22.2, MA.1, Management Requirements, Paragraph (b). The BOE is to be included with Volume I.

***Note: A copy of the TRT SOW 1.0 template shall be included in Volume I, Mission Suitability Factor, Management Approach (MA) - Mission Suitability Subfactor 2, MA.1. Further, the TRT SOW 1.0 template functions as a link between Volume I, Mission Suitability Factor, and Volume III, Cost and Price Factor***

ISPT

IDIQ Summary Price Template (ISPT)

Note: IMPORTANT: Self-calculating formulas MUST BE PROVIDED for all grey shaded areas.

This template is required from the Prime Offeror only. It is used to summarize the total proposed price (cost and profit), per Contract Year, the 6-month option to extend services, and in total. It captures the price for the evaluated Task Order shown in the TOPT template, the Government Specified Resources shown in the ICST-SR template, and the proposed Phase-In price. This template is automated and requires no input from the Offeror.

Note: The cell shaded in red is the Offeror's total proposed price that will be shown to the Source Selection Authority (SSA) for selection purposes.

ISCT - PR (SOW 1.0)

IDIQ Summary Cost Template - Proposed Resources (ISCT - PR)

Prime Contractor Company Name:

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

**NLR dollars are non-profit bearing per Section B.7(a) of the Model Contract.

This template is required from the Prime Offeror only. It is for pricing the Offeror proposed level of resources necessary to accomplish the management effort associated with this procurement. This template covers the estimated firm fixed price (cost and profit) to perform that effor, which is asociated with SOW 1.0.

The template is divided into four main sections. The first section addresses the Work Year Equivalents (WYEs) necessary to perform SOW 1.0 for each contract year. The second section addresses Productive Hours. The hours for each contract year are calculated by appplying the productive hours factor to the proposed WYEs. The third section addresses the Team Composite Fully Burdened Rates (FBRs). The FBRs are the team composite fully burdened rates that were calculated in the FBR Template and MUST MATCH the CPAF/CPFF rates proposed in Section B.7, Table B-1 Fully Burdened Rate Table of the Model Contract. The fourth section addresses the Fully Burdened Labor Cost (FBLC) and is developed by multiplying the productive hours by the FBRs. This will be the fully burdened labor cost per labor category.

The bottom of the template addresses the NLR and profit dollars. The NLR dollars included for each contract year shall be supported by a detailed Basis of Estimate (BOE) that supports the Offeror's proposed management and technical approach. Offerors shall apply any applicable burdens to the proposed NLR dollars. The bottom of the template also provides for the Prime Offeror NTE profit rate input (subcontractor profit rate(s) shall be included in the FBRs unless a fee sharing arrangement is being proposed) and calculates the fee dollars. The template currently assumes that the NTE profit rate is applied to all proposed dollars, excluding all NLR dollars which are RFP specified as non-profit bearing dollars. For this RFP, all NLR dollars excluding facilities costs are non-profit bearing. Offerors may adjust the NTE profit rate application to match their proposal. However, the NTE profit rate proposed here shall match the NTE profit rate proposed in Section B.7, Table B-1 Fully Burdened Rate Table of the Model Contract. Any cost elements proposed to be non-profit bearing here must contain the same contractual language in Section B.7 of the Model Contract.

Full Contract Year 2 through Contract Year 7 requirements are indicative of Contract Year 1 estimates prorated to a twelve month time period. Therefore this consideration shall be included in developing the Offeror’s FBRs. The pricing of Contract Year 2 through Contract Year 7, and the 6-month Option to Extend, is for proposal purposes only and is intended to provide the Government visibility regarding both the estimated price (cost and profit) of the future firm fixed price Task Order (TO) for the management of this procurement effort (e.g., SOW 1.0) and the effect of the proposed rates in the out years. The total price estimate for all contract years, and the 6-month option to extend, will be used for selection purposes.

Note: The 6-month Option to Extend period of performance is associated with FAR 52.217-8, Option To Extend Services. It covers the entire potential additional period of performance allowed under the clause.

ISCT - SR (SOW 2.0 - 4.0)

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

Prime Contractor Company Name:

Table L.xx: Specified Resources -- Hours

Total Cost $ 426,536 $ 439,332 $ 452,513 $ 466,088 $ 480,071 $ 494,472 $ 509,305 $ 262,291 $ 3,530,608

**NLR dollars are non-fee bearing per Section B.7(a) of the Model Contract.

This template is required from the Prime Offeror only. It is for pricing the Government specified level of resources identified in Table L-7 (direct labor hours) and Table L-8 (NLRs). This template covers the estimated price (cost and fee) to perform the SOW.

The template is divided into three main sections. The first section addresses Productive Hours. The hours included for each contract year shall match the hours provided in Table L-7. The second section addresses the Team Composite Fully Burdened Rates (FBRs). The FBRs are the team composite fully burdened rates that were calculated in the FBR Template and MUST MATCH the CPAF/CPFF rates proposed in Section B.7, Table B-1 Fully Burdened Rate Table of the Model Contract. The third section addresses the Fully Burdened Labor Cost (FBLC) and is developed by multiplying the productive hours by the FBRs. This will be the fully burdened labor cost per labor category.

The bottom of the template addresses the NLR and fee dollars. The NLR dollars included for each contract year shall match the NLR dollars provided in Table L-8. Offerors shall apply any applicable burdens to the proposed NLR dollars. The bottom of the template also provides for the Prime Offeror NTE Award Fee (AF) and NTE Fixed Fee (FF) rate input (subcontractor fee rate(s) shall be included in the FBRs unless a fee sharing arrangement is being proposed) and calculates the fee dollars. The template currently assumes that the NTE fee rate is applied to all proposed dollars, excluding all NLR dollars which are RFP specified as non-fee bearing dollars. For this RFP, all NLR dollars excluding facilities costs are non-fee bearing. Offerors may adjust the NTE fee rate application to match their proposal. However, the NTE fee rate proposed here shall match the NTE fee rate proposed in Section B.7, Table B-1 Fully Burdened Rate Table of the Model Contract. Any cost elements proposed to be non-fee bearing here must contain the same contractual language in Section B.7 of the Model Contract.

Full Contract Year 2 through Contract Year 7 requirements are not indicative of Contract Year 1 estimates prorated to a twelve month time period. Therefore this consideration shall be included in developing the Offeror’s FBRs. The pricing of Contract Year 2 through Contract Year 7, and the 6-month Option to Extend, is for proposal purposes only and is intended to provide the Government visibility regarding the effect of the proposed rates in the out years. The total price estimate for all contract years, and the 6-month option to extend, will be used for selection purposes.

Note: The 6-month Option to Extend period of performance is associated with FAR 52.217-8, Option To Extend Services. It covers the entire potential additional period of performance allowed under the clause.

FBR

FULLY BURDENED RATES TEMPLATE (FBR)

This template is required from the Prime Offeror and each Major Subcontractor. It is intended to allow the Offeror to provide a breakdown on the individual cost components that comprise the Offeror's Fully Burdened Rate (FBR), by SLC, including the build-up to the FBR, including fee, if applicable. A separate template is required for each contract year, and the 6-Month Option to Extend, with each contract year stacked vertically, ending with the 6-Month Option to Extend. As noted towards the top of this template, the columns below the blue area shall be completed by the Prime Offeror, while the columns below the yellow area shall be completed by the Major Subcontractor.

The instructions in the following paragraph apply to both the Prime Offeror and each Major Subcontractor. The Standard Labor Categories (SLCs) column (Column B) identifies the NASA JSC SLCs applicable to this procurement. Offeror's may NOT identify additional SLCs. The Direct Labor Rate column (Column C) is provided so that the Offeror may provide the weighted average direct labor rate for each SLC. The Contract Year 1 direct labor rate for each SLC should be linked from the IRAP template and must match the composite direct labor rate data, per individual SLC, calculated in the IRAP template. The out-year direct labor rates should be escalated at the out-year rates of escalation identified in the IRAP template. The Overhead Rate column (Column D) addresses the overhead rate(s) and should be linked from the OHT template. The Overhead Cost column (Column E) is the overhead cost per hour of direct labor . In the example, it is assumed that the Offeror’s overhead rate is applied solely to direct labor cost. However, the formula may be modified to accommodate the Offeror’s specific accounting system and the base(s) to which the overhead rate applies. You may add rows or columns to facilitate this. However, do not remove any SLCs in your submitted templates. The Overhead rate provided on this template should tie directly to the Overhead rate provided on the Overhead rate template (OHT). Add additional columns (and additional OHT templates discussed later in the instructions contained in the OHT template), as necessary, to account for any additional non-G&A indirect rates (such as a separate fringe rate). The General and Administration (G&A) Rate column (Column F) addresses the G&A rate and should be linked from the GAT template. The G&A Cost column (Column G) 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, the formula may be modified to accommodate the Offeror’s specific accounting system and the base(s) to which the G&A rate applies. The G&A rate provided on this template should tie directly to the G&A rate provided on the G&A rate template (GAT). The Facilities Capital Cost Of Money (FCCOM) column (Column H) is provided should the Offeror both have this cost element and propose it as an allowable cost. The Other column (Column I) is for any other cost element applicable to the Offeror's specific accounting system. If not used, do not delete the column. The Fee Rate (Sub Only) column (Column J) is only applicable to the Major Subcontractor, if the Major Subcontractor is not sharing in a fee pool at the Prime Offeror level, and represents the Major Subcontractor's proposed separate fee rate structure. The Fee Cost (Sub Only) column (Column K) is the Major Subcontractor's fee dollar per hour calculated by applying the Major Subcontractor fee rate to the Major Subcontractor's proposed fee base. The FBR column (Column L) combines the direct labor rate and all the indirect costs, along with the Major Subcontractor fee, if applicable, to derive the Prime Offeror’s or Major Subcontractor's proposed Fully Burdened Rate (FBR) per SLC. Note: The Major Subcontractor stops at the FBR column (Column L). The Prime Offeror will complete the columns to the right of Column L as 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 Offeror and all team member subcontractors (both Major Subcontractors and Minor Subcontractors).

The instructions in the following paragraph apply only to the Prime Offeror. The 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) (Columns N-P), the Prime Offeror shall indicate the applicable subcontractor name and that subcontractor's FBR, by SLC. The FBR utilized by the Prime Offeror for each Major Subcontractor must match the FBR provided by the Major Subcontractor to the Government or an explanation as to the difference must be provided. The FBR utilized by the Prime Offeror for each Minor Subcontractor shall tie directly to the data provided by the Prime Offeror in the MST template. The FBR is to be determined by the Minor Subcontractor and provided to the Prime Offeror. If more than one subcontractor (major or minor) is being proposed, then the Prime Offeror is responsible for providing each subcontractor’s FBR data in a separate column, by SLC. In the template, three columns are provided and identified as Subcontractor “A”, “B” and “C”. Additional columns may be added as necessary. Do not delete any unused columns. In this example, Subcontractor “A” and Subcontractor “B” are provided for illustrative purposes. The Prime Offeror Burden Rate column (Column Q) is 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 Burden Rate to derive a total FBR that addresses the use of the particular subcontractor (Columns R-T). The Percentage Usage Prime/Sub columns (Columns U-X) address the weighting of the Prime Offeror FBR versus the Subcontractor(s) FBR. Based upon this weighting, a Team Composite (Prime and Subcontractor) Straight-time FBR Per Hour (Column Y) can be computed. In the example, for Business Specialist 3, it is assumed that the Prime Offeror has determined that the Prime Offeror 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 $46.89 per hour. The Team Composite Straight-time FBR Per Hour column (Column Y) address the final composite FBR that the Prime Offeror has calculated. Important Note: The FBR identified in this column shall be the CPAF (Contract Years 1 - 2) or CPFF (Contract Years 3 - 7, and 6-Month Option to Extend) FBR that is included in Section B.7 of the Model Contract.

Note: The Not-To-Exceed (NTE) award fee, fixed fee, and profit rate applicable to the Team Composite FBRs shall be addressed at the IDIQ Summary Cost Template – SR and IDIQ Summary Cost Template -- PR , as applicable. The NTE award fee, fixed fee, and profit rates shall match the NTE award fee, fixed fee, and profit rates proposed in Section B.7 of the Model Contract.

MST

MINOR SUBCONTRACT TEMPLATE (MST)

Prime Contractor Company Name:

Minor Subcontractor Offerors Labor Category NASA SLC Incumbent Retention at Current Pay* (Yes/No) Proposed Direct Labor Rate* Type of Contract Fee Rate Included in FBR Contract Year 1 FBR** Contract Year 2 FBR** Contract Year 3 FBR** Contract Year 4 FBR** Contract Year 5 FBR** Contract Year 6 FBR** Contract Year 7 FBR** 6-Month Option to Extend FBR**

Example:

This template is required from the Prime Offeror only. This template is intended to provide the SEB with a concise assessment of the substance of minor subcontracts. An example showing how this template is to be completed is provided in red.

*See the "Incumbent Retention at Current Pay (Yes/No)" column to enter required data. If the Offeror is proposing to fill the NASA SLC with incumbent employees AND maintain current pay by utilizing the NASA Historical Incumbent Direct Labor Rate posted in the NASA Technical Library, then the Offeror is to answer "Yes" in the column. Otherwise, answer "No" in the column. In the "Proposed Direct Labor Rate" column identify the proposed unburdened direct labor rate being used.

IRAP

Ex: CY 2 - 9 & OTE Rate of Escalation 2.80%