Attachment_L-7_Logistics_EPM.xlsx

Workbook Instructions Attachment L-6 Logistics Excel Pricing Model 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 eight contract then eight 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:

Workbook Acronyms:

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

TRST-Core Instructions

Incumbent Retention %

Offerors are required to provide the percent of incumbent workforce they intend to retain by SLC (for the Logistics 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 AR-1-1 Logistics Contract Management Plan (CMP).

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 (the Core and IDIQ). 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 AR-1-1 Logistics CMP. 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 Core and IDIQ requirements). The Offeror shall provide rationale, detailed narrative, and validation of their NLR resources basis in AR-1-1 Logistics CMP.

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 Core and IDIQ 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 AR-1-1 Logistics CMP. 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 Core). These deltas must be fully justified in accordance with the instructions for the “BOE” paragraph in AR-1-1 Logistics CMP.

Reference

This column shall be used by the Offerors to refer the NASA evaluators to the specific AR-1-1 Logistics CMP “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: The TRST functions as a link between AR-1-1 Logistics CMP. Volume III, Cost/Price Proposal.

Technical Resources Summary Template- Logistics 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 refers evaluators to all the Efficiencies or Cost Savings supporting data in AR-1-1, Logistics CMP. 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 offeror. 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.

The NLR cost for Stores/Critical Spares/Furniture is a "plug" number and Offerors shall not change it.

TRT- Core

Ex: Engineer III 5.0 5.0

Total WYE (Prime and All Subs) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00%

This template is required only from the prime offeror. This template is designed to summarize all proposed labor resources, prime and ALL subcontractors, by SOW for 12 Month Period ONLY.

LPT

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

EXAMPLE (ST Direct Labor Cost): Engineer III $ 4,008,900

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.

Productive Hours

This section addresses Productive Hours. The Offeror shall determine the mix of labor categories and the labor hours required to perform the Completion Form 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 (Direct Labor Rate): Engineer III $ 50.00 $ 51.50 $ 53.05 $ 54.64 $ 56.28 $ 57.96 $ 59.70 $ 61.49 $ 63.34

EXAMPLE (ST Direct Labor Cost): Engineer III $ 200,445

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.

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

This section identifies 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

Major Subcontractor Cost Summary Template (MSCST)

Sub-Total Cost $ - 0 $ - 0 $ - 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.

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

Prime Cost Summary Template (PCST)

Prime Contractor Name:

Sub-Total Cost $ 373,333 $ 650,880 $ 661,945 $ 673,198 $ 684,642 $ 696,281 $ 708,118 $ 720,156 $ 305,166 $ 5,473,720

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.

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.

The NLR cost for Stores/Critical Spares/Furniture is a "plug" number and Offerors shall not change it.

TRST-IDIQ-CR

PRIME AND ALL SUBCONTRACT (MAJOR AND MINOR SUBS ) RESOURCES COMBINED

RFP - NNJxxxxxxx Technical Resources Summary Template (TRST)-IDIQ Cost Reimbursable Section L&K00B050 &K000000Attachment L-xx&K00B050

This template is required only from the prime offeror. 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 Logistics IDIQ requirements for a 12 month period ONLY.

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).

Incumbent Retention % Column Allows the Offeror to propose the percentage retention of the existing workforce per SLC. The Offeror may propose any percentage per labor category that is based upon their proposed management and technical approach required for the statement of work. In the example, 100% is placed against a Engineer I for illustrative purposes.

The Retention % of Incumbents at Current Direct Labor Rates Column 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. The percentage indicated in this column cannot be greater than the percentage indicated in the Incumbent Retention % column discussed in the paragraph above and if the percentage is less the Offeror MUST provide detailed calculations and detailed supporting justification for the lower percentage. In the example, 85% is placed against a Engineer I for illustrative purposes.

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.

Fixed 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.8 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