Attachment_L-8_Logistics_EPM.xlsx

Workbook Instructions Attachment L-8 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 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 Federal Audit Office Template

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.

TRST Instructions

Incumbent Retention % Offerors are required to provide the percent of incumbent workforce they intend to retain by SLC (for the Logistics Core work).

Proposed WYEs The Offeror shall also provide an integrated discussion including rationale, detailed narrative, and validation of their resources for the proposed WYEs (the Core and IDIQ) as part of their responses in AR-1-1 Logistics CMP. Sufficient detail to allow a thorough Government understanding and analysis of the proposed WYEs must be provided. The Offeror’s proposal must present a clear and consistent description of what is being proposed across all sections.

Proposed NLR Cost The Offeror shall also provide an integrated discussion including rationale, detailed narrative, and validation of their resources for the proposed NLRs (the Core and IDIQ) as part of their responses in AR-1-1 Logistics CMP. Sufficient detail to allow a thorough Government understanding and analysis of the proposed NLRs must be provided. The Offeror’s proposal must present a clear and consistent description of what is being proposed across all sections.

Reference This column shall be used by the Offerors to refer the NASA evaluators to the specific AR-1-1 Logistics CMP paragraph which provides the analysis of the resource delta(s). The NASA evaluators will compare all 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 supporting data in AR-1-1, Logistics CMP.

This template is required only from the prime offeror. This template is designed to summarize all proposed labor resources by SLC.

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

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

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

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.

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 Offeror Name:

Sub-Total Cost $ 350,000 $ 610,200 $ 620,573 $ 631,123 $ 641,852 $ 652,764 $ 663,861 $ 675,146 $ 286,093 $ 5,131,613

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

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

This template is required only from the prime offeror. This template is designed to summarize all proposed labor resources by SLC 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

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. Subcontractor is to complete portion with yellow border. Prime is to complete portion with blue border.

TOPT

TASK ORDER PRICING TEMPLATE (TOPT)

Prime Offeror Name:

Example: ** Engineer I Productive Hours 1,860 2,790 120,900 45,000 168,690

CONTRACT RATES

LABOR COST

TOTAL COST (Fully Burdened Labor, NLR, NLR Burden) $ - 0 $ - 0 $ - 0 $ - 0

**Remove example from official submission. 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.

This template is required of the prime offeror only; however, it is designed in such a way that the hours and NLRs for the prime, major subcontractor(s) and minor subcontractor(s) combined shall be included in the Productive Hours and NLR sections, respectively. This template is for pricing the TOs provided and covers a twelve month time period. Hours and NLRs are to be allocated to the TOs identified on the template for twelve month period based on the Offeror’s proposed management and technical approach and shall match the hours and NLRs proposed for each TO elsewhere NLR and Fee Dollars

This section of the template provides for the Offeror’s estimate of the NLRs necessary to perform the Task Order, as well as any applicable burdens applied to NLRs.

Labor This section also provides for the prime Offeror NTE fee rate input (subcontractor fee 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 labor dollars. 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.8 of the Model Contract.

NLRs The NTE fee rate for NLRs is 1%. Any cost elements proposed to be non-fee bearing here must contain the same contractual language in Section B.x of the Model Contract. The NTE fee rate proposed here shall match the NTE fee rate proposed for NLRs in Section B.8 of the Model Contract.

Labor Cost

The this section addresses the Labor Cost and is developed by multiplying the productive hours by the contract rates. This will be the fully burdened labor cost per labor category.

Contract Rates

This section addresses the Contract Rates. The contract rates are the fully burdened rates that were calculated in the FBR and MUST MATCH the rates proposed in Section B.8 of the Model Contract.

Work Year Equivalent (WYE) and Productive Hours

This section addresses Productive Hours. A WYE is defined as the proposed productive hours needed to comprise one average full time employee. This may be one employee or several part time employees. Productive hours are defined as the total available hours for productive work in a year, excluding overtime, less paid time off. Offerors shall identify the WYE assumptions utilized in pricing their Cost/Price Proposals.

Non-productive time includes such items as vacation, holiday and sick time, jury duty, or other excused absences that are accounted for separately under an Offeror’s specific accounting system. Offeror’s shall identify the productive hours assumptions utilized in pricing their Cost/Price Proposals.

For example, a WYE based on 2,080 total hours and who receives 10 holidays (80 hours), three weeks of vacation (120 hours), and 10 sick days (80 hours), would be shown as a productive WYE of 1,800 hours (2,080 total hours minus 80 hours for holidays minus 120 hours for vacation time minus 80 hours for sick days).

The Offeror shall determine the mix of SLCs and identify the productive labor hours required to perform each TO.

ISCT

IDIQ Summary Cost Template (ISCT)

Prime Offeror Name:

CONTRACT RATES