SMAEC_II_Cost_Price_Template.xlsx

Contract form

&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

TRST CORE TECHNICAL AND MGT

Example Productive Hours 1860 Contract Year 1 Productive Hours per WYE 1860 Contract Year 2 Productive Hours per WYE 1860 Contract Year 3 Productive Hours per WYE 1860 Contract Year 4 Productive Hours per WYE 1860 Contract Year 5 Productive Hours per WYE

Ex: Engineer III 29 53,196 Paragraph x, Page xxx 29 53,196 CY 1 Efficiency Maintained 29 53,196 CY 1 Efficiency Maintained 29 53,196 CY 1 Efficiency Maintained 29 53,196 CY 1 Efficiency Maintained

LPT

Labor Pricing Template (LPT)

EXAMPLE (FBL Cost): Engineer III $ 1,445,131

OPT

Overtime Pricing Template (LPT)

EXAMPLE (FBL Cost): Engineer III $ 108,385

MSCST

Major Subcontractor Cost Summary Template (MSCST)

Major Subcontractor Name: Core Requirements

Sub-Total Cost ERROR:#VALUE! $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

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

PCST

Prime Cost Summary Template (PCST)

Prime Contractor Name: Core Requirements

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

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

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

IRAP

A separate IRAP is required for Contract Year 1 only from the prime Offeror, each major subcontractor, and all subcontractor(s) as defined in NFS 1852.231-71(d). This template is provided so that each Offeror may mathematically indicate the percentages of incumbents being retained, as well as, the percentage of incumbents being retained at current incumbent pay, resulting in a “net” percentage of incumbents retained and paid at current incumbent pay. Further, this template mathematically weights the various potential pay sources to calculate a weighted direct labor rate applicable to Contract Year 1. All calculations are per SLC position. The bottom of this template automatically calculates incumbency retention and incumbency pay percentages that must be reconciled to the Incumbency Assumptions (IA) tab.

The "Proposed Out-Year Rate of Escalation" field at the top right of the template (Column O, Row 3) is used to identify the Offeror's proposed out-year escalation.

The “Data Source Used By Offeror” column (B) is pre-populated with the six most likely sources of direct labor rates per SLC. Offerors may provide additional rows in any particular SLC to indicate their particular direct labor rate source, if necessary. However, no rows are to be deleted nor are the pre-populated data source names to be changed. Offerors are to add rows or use the "Other" row and indicate the appropriate data source name.

The "Historical Incumbent Rate" row is utilized if an Offeror is proposing to utilize the NASA provided historical incumbent rate data provided in the NASA Technical Library. NOTE: If the Offeror utilizes direct labor rate data from the NASA Technical Library in Column (N), then the Offeror shall not utilize direct labor rate data in Column (L) on the "Contractor Incumbent Rate" row discussed next.

The "Contractor Incumbent Rate" row may ONLY be utilized by a current incumbent contractor bidding on the follow-on procurement. It is not to be utilized by an Offeror who has no performance on the current contract. If an Offeror utilizes this row in lieu of the "Historical Incumbent Rate" row, then an explanation MUST BE PROVIDED in the Cost Narrative explaining the reason(s) why this data point is being used in lieu of the NASA provided "Historical Incumbent Rate". Further, the Offeror shall indicate if the direct labor data point used here is different than the direct labor data point previously provided to the Government, and the reasons why the data points are different. NOTE: If the Offeror utilizes direct labor rate data calculated by the Offeror in Column (L) of the "Contractor Incumbent Rate" row, then the Offeror shall not utilize the "Historical Incumbent Rate" row previously dicussed.

The "WD Rate" row is utilized if an Offeror is proposing to utilize a DOL WD rate.

The "CBA Rate" row is utilized if an Offeror is proposing to utilize a CBA rate, if applicable.

The "Third Party Rate Data" row is utilized if an Offeror is proposing to utilize a direct labor rate based on a third party source.

The "Contractor Rate Data" row is utilized if an Offeror is proposing to utilize a direct labor rate based on data obtained from the Offeror's accounting and/or estimating systems. This row is NOT to include any incumbent rate data provided by the Government or separately identified by the Offeror.

The next four columns are used to identify the Offeror’s labor categories based on their accounting system, any applicable Department of Labor (DOL) Wage Determination (WD) and/or Collective Bargaining Agreement (CBA), whether the position is exempt or non-exempt, and the NASA Standard Labor Categories (SLCs) applicable to this procurement.

The "Proposed FTEs by SLC" column (G) is used to identify the total proposed FTEs for each SLC (entered by the Offeror on each SLC's composite row). The total FTEs for each SLC are then automatically allocated to that SLC's data source row based on the "% Usage" column data entered by the Offeror (explained further below). In the example, a total of 9 FTEs is proposed for illustrative purposes.

The “Incumbent Retention % (Column 1)” column (H) allows the Offeror to indicate the percentage retention of the existing workforce, per SLC, that is being proposed. The Offeror may propose any percentage, per SLC, that is based upon their proposed management and technical approach used to accomplish the statement of work. In the example, 75% is placed against an Engineer III SLC for illustrative purposes.

The “Retention % of Incumbents at Current Direct Labor Rates (Column 2)” column (I) allows the Offeror to indicate the percentage of the incumbent workforce that the Offeror intends to pay at the current incumbent direct labor rates, per SLC. In the example, 85% is placed against an Engineer III SLC for illustrative purposes.

The “Net Incumbents Paid at Current Direct Labor Rates (Column 1 times Column 2)” column (J) is automated and results in the “net” percentage of incumbents paid at current incumbent pay, per SLC. This percentage is automatically linked to the “% Usage” column (K) on the “Historical Incumbent Rate” row as previously discussed above.

Note: If there is no incumbent direct labor rate for a particular SLC, then no percentage – other than zero percent – can be entered into the “Retention % of Incumbents at Current Direct Labor Rates (Column 2)” column (I) and the “net” percentage calculated in the “Net Incumbents Paid at Current Direct Labor Rates (Column 1 times Column 2)” column (J) will be zero percent and the entry allowed on the “Historical Incumbent Rate” row will be zero percent.

The "% Usage" column (K) identifies the percentages of each specific data source row utilized by the Offeror for each specific SLC.

The "Unadjusted Base Direct Labor Rate (Pre-Contract Tear 1 Direct Labor Rate)" column (L) is used to identify the Offeror's proposed pre-Contract Year 1 direct labor rate prior to any escalation, or other adjustments, applied by the Offeror to bring the proposed direct labor rate source current to the proposed Contract Year 1 start date.

The "Escalation or Other Adjustment Applied to Pre-Contract Year 1 Direct Labor Rate" column (M) is used to reflect the proposed escalation, or other adjustments, applied to the "Unadjusted Base Direct Labor Rate (Pre-Contract Year 1 Direct Labor Rate)" column (L) to derive the proposed "Direct Labor Rate (Contract Year 1)" column (N) rate.

The “Direct Labor Rate (Contract Year 1)” column (N) contains the Offeror’s proposed direct labor rate for Contract Year 1, by SLC, per each data source utilized by the Offeror. A “Composite Average” direct labor rate is calculated, by SLC, based on the “% Usage” column (K) data per each data source.

The final column allows for the Offeror to indicate the basis of the proposed data sources utilized in the development of the proposed Contract Year 1 direct labor rate.

FBR

FULLY BURDENED RATES TEMPLATE (FBR)

RFP - NNJxxxxxxx &"Times New Roman,Regular"SECTION L Attachment L-xx

&A Page &P of &N

MST

MINOR SUBCONTRACT TEMPLATE (MST)

Prime Contractor Name:

Minor Subcontractor Offerors Labor Category NASA SLC Type of Contract Fee Rate in FBR Contract Year 1 FBR* Contract Year 2 FBR* Contract Year 3 FBR* Contract Year 4 FBR* Contract Year 5 FBR*

*Note: Provide the formula/weighting used to derive the FBR if more than one Offeror SLC labor category in a particular NASA SLC.

RFP - NNJxxxxxxx SECTION L

&A Page &P of &N

TRT 1-S2TO-MPCV

PRIME AND ALL SUBCONTRACT RESOURCES COMBINED

Non-Labor Resources