ATT L-8 Cost Price Templates.xlsx

Workbook Instructions

FACILITIES CONTRACT

Instructions For Preparing The Electronic Pricng Model (EPM)

GENERAL INSTRUCTIONS

Proposals shall be prepared using this Excel Electronic Pricing Model (EPM), which is included in the RFP. The Government will be evaluating the proposals using Micosoft Excel. Each prime contractor and major subcontractor is required to submit their EPM and any other electronic cost data, in the format described in the RFP. The proposal shall be submitted to the Government using the LFT-Large File Transfer protocol - see Section L.11, "JSC 52.215-108 Proposal Marking and Delivery Through Large File Transfer (LFT) (MAR 2020) (JSC Procurement Instruction)," in the RFP. No other submission method will be acceptable. The deadline for submission of proposals is indicated in the RFP.

The words "worksheet" and "template" are synonimous and are used interchangable in these instructions.

The EPM shall be automated to the greatest extent possible. However, whereas linking among the worksheets within the workbook is required, the use of external links (source data not provided to NASA) of any kind is prohibited. The workbook shall contain no macros or hidden cells, nor shall the workbook be locked, protected or secured by passwords.

When multiple years of data are required, the data shall be included in the same worksheet stacked vertically. (See the [FBR-CPFF] worksheet for an example.)

The EPM consists of multiple worksheets, which are color-coded as follows:

Each worksheet contains detail instructions on how to prepare that worksheet.

NAMING CONVENTION:

The Workbook shall be named as follows:

The proposal shall include a single workbook with multiple worksheets. The workbook shall be named EPM followed by a hyphen then the three letter company name acronym. E.g. The company named Abacus Business Corporation shall name it's workbook "EPM-ABC". The names of worksheets within the workbook shall start with the worksheet name, followed by a hyphen, then the company's name acronym. E.g. The FBR-CPFF worksheet for Abacus Business Corporation shall be named "FBR-CPFF-ABC".

The following worksheets are included in the EPM. The worksheets shall be submitted by Prime Offerors and all Major Subcontractors, except those worksheets that are designated "Prime Only".

Cost Templates Acronyms:

TRST

INSTRUCTIONS FOR COMPLETING THE TRST TEMPLATE

This template is required by the Prime Offeror and all Major Subcontractors.

Prime Offeror Instructions:

THE [TRST] WORKSHEET SHALL REFLECT THE LABOR RESOURCES, (IN WYEs AND LABOR HOUR), FOR THE ENTIRE TEAM, INCLUDING ALL MAJOR AND MINOR SUBCONTRACTORS. IT IS USED PRIMARILY BY THE TECHNICAL TEAM TO EVALUATE THE ENTIRE RESOURCES PROPOSED FOR THE ENTIRE CORE PROPOSAL. PLEASE NOTE: THIS WORKSHEET DOES NOT INCLUDE ANY PROPOSED OVERTIME RESOURCES (HOURS).

This template is designed to summarize the Labor Resources for the Core Work for the ENTIRE team for the entire contract period of performance. That includes the resources (WYEs and Hours) for the Prime Offeror and its Minor subcontractors, AND all Major Subcontractors and their Minor Subcontractors.

Since the conversion factors for the Prime Offeror, the Major and Minor subcontractors may all be different, conversion factors cannot be used to determine the total hours in this worksheet. The hours has to be added from various worksheets in this EPM.

In addition, although, the WYEs for Minor Subcontractors are not shown in the the Minor Subcontrators Worksheet, [MST-CORE], the Prime Offeror shall include in this template, the WYEs that will be required of Minor Subcontractors.

The resources in this worksheet shall agree with those described in the narrative in the cost/price Volume II, and the narrative in the Technical Volume III of the Prime Offeror's proposal.

Major Subcontractor Instruction:

The TRST for Major Subcontractor shall include the Labor for the subcontractor's entire team, including all minor and second tier major subcontractors.

NOTE:

The Government has provided formulae in this worksheet. The formulae were designed to assist Offerors in developing the worksheet.

HOWEVER, IT IS VERY IMPORTANT TO NOTE THAT THE PROPOSAL IN THE PRODUCT OF THE OFFEROR, AND AS SUCH, IT IS THE OFFEROR'S RESPONSIBILITY TO REVIEW EACH FORMULA AND CORRECT ANY ERRORS AS NECESSARY. THE GOVERNMENT IS NOT RESPONSIBLE FOR ANY ERRORS IN THE FORMULAE THAT RESULTS IN ERRONEOUS RESOURCES IN THE PROPOSAL, RESOURCES THAT WERE NOT INTENDED BY THE OFFEROR.

NOTE:

This worksheet captures ALL Labor Resources, in WYEs, and ALL Labors Hours proposed for the CORE proposal, i.e for the Prime Contractor, ALL major Subcontractors, and ALL Minor Subcontractors. Its main purpose is to allow the Technical Review Team to determine the reasonableness of the TOTAL proposed labor resources.

TRT

TECHNICAL RESOURCES TEMPLATE - TRT

INSTRUCTIONS FOR COMPLETING THE TECHNICAL RESOURCES TEMPLATE (TRT)

This template is required by the Prime Offeror and all Major Subcontractors.

NOTE: The term "Statement of Work" and "Annex" are synonymous, and used interchangably in this RFP.

The Annex level refers to the higher levels of the statement of work that includes 1.0, 2.0, 3.0 etc. The Annex sub-level is referred to as CLINs, and includes 1.1, 1.2, 1.3, etc.

For the Prime Offeror and all major subcontractors, this template provides for Labor Resources, in WYEs, for each entity (Prime and Major Subcontractor) for the Core section of the contract. The Labor Resources shall be provided at the level of detail at the CLIN level shown in the worksheet. Please note that for some CLINs, the Offeror (Prime and Major Subcontractor) is required to provide lower level details. For example, CLIN 1.8 requires details for sub-CLIN 1.8.1. All other WYEs for CLIN 1.8 shall be combined and shown as 1.8.X.

Labor Resources:

The template is designed to provide the labor resources, in WYEs, for each SLC at the CLIN level identified above, and as required by the RFP. (The Annex breakdown structure and the name of the Annex and CLINs are shown in this worksheet.) Lower level CLINs are summarized into the higher Annex level. For example, CLIN 4.1 through CLIN 4.10 are totalled into Annex 4.0. And Annexes 1.0, 2.0, 3.0, 4.0, 5.0, and 6.0 are totalled into the column labelled "Total WYEs Year 1" (Column DQ). The Year 1 WYEs will be straight-lined to Years 2-5 when pricing out the CORE effort .

(The worksheet is color-coded in accordance to the color chart shown above.)

Prime Offerors-Addition Instructions:

For the Prime Offeror, this template provides for Labor Resources at the CLIN level for Year 1 for the Prime contractor ONLY. This worksheet shall be linked to the Prime Offeror's LPT worksheet. The total in this worksheet shall include The total hours in the Prime Offeror's TRST shall equal to the sum of the following:

Major Subcontractors-Addition Instructions:

For Major Subcontractors, this template provides for Labor Resources at the CLIN level for Year 1 for the Major Subcontractor. This worksheet shall be linked to the Subcontractor's LPT worksheet.

The Government has provided formulae in this worksheet. The formulae are designed to assist Offerors in developing the worksheet.

HOWEVER, IT IS VERY IMPORTANT TO NOTE THAT THE PROPOSAL IS THE PRODUCT OF THE OFFEROR'S, AND AS SUCH, IT IS THE OFFEROR'S RESPONSIBILITY TO REVIEW EACH FORMULA AND CORRECT ANY ERRORS AS NECESSARY. THE GOVERNMENT IS NOT RESPONSIBLE FOR ANY ERRORS IN THE FORMULAE THAT RESULTS IN ERRONEOUS RESOURCES IN THE PROPOSAL, RESOURCES THAT WERE NOT INTENDED BY THE OFFEROR.

PCST

Prime Cost Summary Template (Total Contract) (PCST)

Prime Offerors Company Name:

PRIME OFFEROR TOTAL COST AND FEE

INSTRUCTIONS FOR COMPLETING THE PRIME COST SUMMARY TEMPLATE (PCST)

This template is required of the Prime Offeror only. It is used to summarise the Prime Offeror's proposed hours, and price, by Contract Year, for the entire period of performance for the entire proposal. This summary worksheet includes the following.

Cells in this worksheet shall be linked to the appropriate worksheet in this workbook. A reference column has been provided on this template for the Offeror to identify the location of the supporting cost narrative in the Offeror's Cost Narrative in Volume III of the proposal. The cost and price data submitted and described in Volume III shall be clearly described so that the Government may fully understand the cost development and computations.

Please note that the total hours shall reflect the TOTAL HOURS for the entire team for the entire contract period including the option period, and award term periods.

CPT-CORE-CPAF

Subtotal - Cost $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

INSTRUCTIONS FOR COMPLETING THE CPT-CORE TEMPLATE

This template is required of Prime Offerors only. It represents the summary of the total costs and award fee for the Core CPAF componentof the proposal. Data in this worksheet are either:

1. Linked from other worksheets in this workbook (blue-shaded cells)

2. Calculated (grey-shaded cells)

3. Input (Pink shaded cells. Explanation required)

Straight-Time Direct Labor Costs:

These costs are linked from the LPT template.

Indirect Rates:

The indirect rates used in this template shall match the rates in the IRT Templates used in this proposal, and the [GAT]. (Examples of IRT are: Labor Overhead, Rate Fringe Benefit Rate, Engineering Rate, Material Handling Rate etc). For the base of application of the indirect rates, Offerors can either link the base to another cell, or input the base cost directly in the cell. If a direct input is used, Offerors shall provide a detailed explanation in this worksheet and in the Cost Narrative in Volume II of the proposal.

NLR:

NLR cost are to be proposed by the Offeror for all years of the contract. For years 2 through 10, Offerors shall propose NLR costs by either showing the details or by applying escalation factors to the previous year's NLR cost. Offerors shall provide a detail explanation of, and justification for, the costs proposed or the escalation actors used.

Major Subcontractors:

Major subcontractors' costs are linked from each subcontractor's MSCST templates. A separate template is required for each major subcontractor. It is the responsibility of the Prime Offerr to evaluate its subcontractors' cost for reasonableness.

Minor Subcontractor:

The total minor subcontractors' cost are linked from the MST-Core Template.

Material Handling Rate And Cost:

If an Offeror's accounting system includes a separate Material Handling indirect rate, then the development of the annnual rate shall be calculated in an IRT Worksheet , named appropriately, and included in this workbook. Care should be taken to apply the Material Handling Rate to the appropriate NLR cost, since not all NLR costs may be subject to an overhead rate.

Fee:

An explanation of the basis for the proposed fee rate and the base to which the fee rate is applied shall be provided in the Cost Narrative in Volume III of the proposal. The basis of the fee rate shall be supported with corroborating data.

Facilities Capital Cost of Money (FCCOM):

If FCCOM is proposed, the base and rate are shown in this template. In addition, an Offeror proposing FCCOM shall provide the FCCOM factor calculation in an IRT worksheet, and include that worksheet in this workbook. A detailed explanation of both the base and rate shall be provided in the Cost Narrative in Volume III of the proposal. Please note that fee is not applied to FCCOM cost.

The Government has provided formulae in this worksheet. The formulae are designed to assist Offerors in developing the worksheet.

HOWEVER, IT IS VERY IMPORTANT TO NOTE THAT THE PROPOSAL IN THE PRODUCT OF THE OFFEROR, AND AS SUCH, IT IS THE OFFEROR'S RESPONSIBILITY TO REVIEW EACH FORMULA AND CORRECT ANY ERRORS AS NECESSARY. THE GOVERNMENT IS NOT RESPONSIBLE FOR ANY ERRORS IN THE FORMULAE THAT RESULTS IN ERRONEOUS RESOURCES OR COSTS IN THE PROPOSAL, RESOURCES AND COSTS THAT WERE NOT INTENDED BY THE OFFEROR.

LPT

Conversion Factor