4_Attachment_L-2_EPM_80JSC020R0034_FC_DRFP.xlsx

Workbook Instructions

FACILITIES CONTRACT

Instructions For Preparing The Electronic Pricing Model (EPM)

GENERAL INSTRUCTIONS

Cost 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 Microsoft 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 synonymous and are used interchangeable in these instructions. For other definitions, please reference Section C, Scope of Work, in the RFP.

The EPM shall be automated to the greatest extent possible. Although linking among the worksheets within the workbook is required, the use of external links (links to any files outside this workbook) 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 proposal shall include a single workbook with multiple worksheets. The workbook file shall be named per Section L's Table L-2 of the RFP. For example, contractor XYZ Company shall name the EPM workbook "Vol II_ EPM_XYZ Company.xlsx". Within the EPM workbook, each worksheet shall be named with the worksheet acronym followed by the contractor's name. Thus, the TRT worksheet prepared by contractor XYZ Company shall be named "TRT_XYZ Company".

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

TECHNICAL RESOURCES SUMMARY TEMPLATE - TRST

Prime Contractor's Name: NOTE:

This worksheet captures ALL Labor Resources, in WYEs, and ALL Labors Hours proposed for the CORE proposal, e.g., 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.

&"Times New Roman,Regular"&12Draft RFP No. 80JSC020R0034 Attachment L-2 SECTION L

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 have to be added from various worksheets in this EPM.

Although the WYEs for Minor Subcontractors are not shown in the Minor Subcontractors Worksheet, MST-CORE, the Prime Offeror shall include the WYEs that will be required of Minor Subcontractors in this template.

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 any second tier Major Subcontractors.

NOTE:

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

HOWEVER, IT IS VERY IMPORTANT TO NOTE THAT THE PROPOSAL IS 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 FORMULAS WHICH RESULT IN ERRONEOUS RESOURCES IN THE PROPOSAL THAT WERE NOT INTENDED BY THE OFFEROR.

TRT

TECHNICAL RESOURCES TEMPLATE - TRT

&"Times New Roman,Regular"&12Draft RFP No. 80JSC020R0034 Attachment L-2 SECTION L

INSTRUCTIONS FOR COMPLETING THE TECHNICAL RESOURCES TEMPLATE (TRT)

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

NOTE: The term "Annex" is defined in Section C, Statement of Work, of the 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 totaled into Annex 4.0. And Annexes 1.0, 2.0, 3.0, 4.0, 5.0, and 6.0 are totaled 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-Additional 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 and shall equal to the sum of the following:

1. The total hours in the Prime Offeror's LPT.

2. The total hours in all Major Subcontractors' LPT. In addition, it shall include hours for all second-tier Subcontractors.

3. The total hours of all of the Prime Offerors' Minor Subcontractors.

Major Subcontractors-Additional 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.

NOTE:

The Government has provided formulas in this worksheet. The formulas 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, 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 FORMULAS WHICH RESULT IN ERRONEOUS RESOURCES IN THE PROPOSAL THAT WERE NOT INTENDED BY THE OFFEROR.

PCST

Prime Cost Summary Template (Total Contract) (PCST)

Prime Offerors Company Name:

&"Times New Roman,Regular"&12Draft RFP No. 80JSC020R0034 Attachment L-2

INSTRUCTIONS FOR COMPLETING THE PRIME COST SUMMARY TEMPLATE (PCST)

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

1. The Core proposal

2. The IDIQ CPFF Task Order

3. The IDIQ FFP Delivery Order

4. The Pre-Priced Items

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 II of the proposal. The cost and price data submitted and described in Volume II 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 periods.

* The total annual straight time and overtime hours shall be totalled from all the major subcontractors' templates (MSCST).

NOTE:

The Government has provided formulas in this worksheet. The formulas 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 FORMULAS THAT RESULT IN ERRONEOUS RESOURCES OR COSTS IN THE PROPOSAL, THAT WERE NOT INTENDED BY THE OFFEROR

CPT-CORE

Cost Pricing Template (CPT) - CORE

Prime Offeror Company Name:

&"Times New Roman,Regular"&12Draft RFP No. 80JSC020R0034 Attachment L-2 SECTION L

L-4-ISCT-&P

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 section of 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)

4. Provided by the Government (green-shaded cells)

Straight-Time and Overtime Direct Labor Costs:

These costs are linked from the LPT and OPT templates respectively.

Indirect Rates:

The indirect rates used in this template shall match the rates in Templates [OHT], [GAT], and any other indirect rate templates included in this workbook. (Example: Fringe 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:

NLRs for the first year of the Contract are provided by the Government. Year 1 costs are straight-lined to the Years 2-5. However, if the Offeror's accounting system and policy requires an application of an annual escalation factor, then the costs may be escalated. Provide a detailed explanation of, and justification for, any escalation factors used.

Major Subcontractors:

Major Subcontractors' costs are linked from each Subcontractor's MSCST template. A separate template is required for each Major Subcontractor. It is the responsibility of the Prime Offeror 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 annual rate shall be calculated in a Worksheet in the format of the OHT worksheet, named appropriately, and included in this workbook. Care should be taken to apply the Material Handling Rate to the appropriate NLR cost.

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 II 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 a worksheet similar to the OHT worksheet, and include that worksheet as part of this workbook. A detailed explanation of both the base and rate shall be provided in the Cost Narrative in Volume II of the proposal. Please note that fee is not applied to FCCOM cost.

NOTE:

The Government has provided formulas in this worksheet. The formulas 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 FORMULAS THAT RESULT IN ERRONEOUS RESOURCES OR COSTS IN THE PROPOSAL, THAT WERE NOT INTENDED BY THE OFFEROR.

LPT

Labor Pricing Template (LPT) - CORE

CONVERSION FACTOR (Input Required)

&"Times New Roman,Regular"&12Draft RFP No. 80JSC020R0034 Attachment L-2 SECTION L

L-4-ISCT-&P

INTRUCTIONS FOR COMPLETING THE LPT TEMPLATE

This template is required from the Prime Offeror and each Major Subcontractor. It is used to price out the straight-time direct labor cost.

Prime Offeror

Prime Offerors shall link the Straight-Time labor costs by year from this worksheet to the CPT-CORE worksheet.

Major Subcontractors

Major Subcontractors shall link the Straight-Time labor costs by year from this worksheet to its MSCST worksheet.

WYEs

The WYEs are linked from the TRT template. The Government has inserted links to the TRT, however, it is the Contractor's responsibility to determine that the links are correct. In addition, the WYEs shall reconcile, and be supported by, the narrative in the Technical Volume and the Price Volume of the proposal.

Conversion Factor

Offerors are to input the conversion factor for each year used for converting WYEs to hours. The determination of the conversion factors are to be described in detail in the cost narrative in the Cost Volume included in the proposal.

Hours

The hours represent the application of the conversion factor to the WYEs.

Base Labor Rates

The first year base labor rates are linked from Column N in the IRAP template. The rates represents the composite labor rates for each SLC. The rates for years 2 through 5 are calculated by escalation of the previous year's rates. The escalation factors are to be described in detail and supported in the cost narrative in the Cost Volume included in the proposal.

Base Labor Cost

The base labor cost represents the application of the base labor rates to the corresponding hours. For the Prime Offeror, the base labor costs are linked to the CPT-CORE template. For Major Subcontractors, the base labor costs are linked to the MSCST template.

NOTE:

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

HOWEVER, IT IS VERY IMPORTANT TO NOTE THAT THE PROPOSAL IN THE REPRESENTATION 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 FORMULAS THAT RESULT IN ERRONEOUS RESOURCES IN THE PROPOSAL, THAT WERE NOT INTENDED BY THE OFFEROR.

OPT

Overtime Pricing Template (OPT)

&"Times New Roman,Regular"&12Draft RFP No. 80JSC020R0034 Attachment L-2 SECTION L

INTRUCTIONS FOR COMPLETING THE OPT TEMPLATE

This template is required from the Prime Offerors and all Major Subcontractors. It is used to price out the overtime direct labor cost.

Prime Offeror

Prime Offerors shall link the Overtime labor costs by year from this worksheet to the CPT-CORE worksheet.

Major Subcontractors

Major Subcontractors shall link the Overtime labor costs by year from this worksheet to its MSCST worksheet.

Hours

Prime Offerors and Major Subcontractors shall input Overtime hours directly into this worksheet by Year and SLC. The basis and rationale for the proposed Overtime hours shall be supported in details in the narratives in the Technical and Cost Volumes in the proposal.

Overtime Premium Percentage

Prime Offerors and Major Subcontractors shall input a premium percentage rate directly into this worksheet. The basis and rationale for the proposed overtime premium rate shall be supported in details in the narratives in the Technical and Cost Volumes in the proposal. If the overtime premium percentage differs among years, provide the rationale in the Technical and Cost Volumes in the proposal.

Base Labor Rates

The overtime labor rates are calculated by applying the overtime premium percentage to the base rates in the OPT template.

Overtime Labor Cost

The overtime labor cost represents the application of the overtime labor rates to the corresponding overtime hours. For the Prime Offeror, the overtime labor costs are linked to the CPT-CORE template. For Major Subcontractors, the overtime labor costs are linked to the MSCST template.

NOTE:

The Government has provided formulas in this worksheet. The formulas 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 FORMULAS THAT RESULT IN ERRONEOUS RESOURCES IN THE PROPOSAL, THAT WERE NOT INTENDED BY THE OFFEROR.

MST-CORE

Minor Subcontractor Template (MST) - CORE

Required of the Prime Contractor and All Major Subcontractors

&"Times New Roman,Regular"&12Draft RFP No. 80JSC020R0034 Attachment L-2 SECTION L

INSTRUCTIONS FOR COMPLETING THE MST-CORE TEMPLATE

This template is required by the Prime Offeror and all Major Subcontractors. It is used to document the annual and total core Contract hours and core costs for all Minor Subcontractors, both straight-time and overtime. The template is designed to accommodate six Minor Subcontractors; however, the Prime Offeror or Major Subcontractor shall add rows as necessary to accommodate additional Minor Subcontractors. The template is color-coded to facilitate the collection of Minor Subcontractors data and its transfer to the CPT-Core Template.

Prime Offeror's Instructions:

The total Minor Subcontractors costs by year (straight-time and overtime combined) are linked to the Cost Pricing Template (CPT-CORE).

Although the details of the Minor Subcontractors' costs are not required in this template, please note that it is the Prime Offeror's responsibility to evaluate each Subcontractor's proposal. The evaluations of the Minor Subcontractors shall be documented by the Prime Offeror in their respective Cost Narrative in Volume II of the proposal. The narrative shall also provide the rationale and basis for the Prime Offeror's decision on each Minor Subcontractor's cost. Also, the WYEs and hours proposed by all Minor Subcontracts to the Prime Offeror are required to be included in the Prime Offeror's TRST worksheet.

Major Subcontractor's Instructions:

The total Minor Subcontractors costs by year (straight-time and overtime combined) are linked to the Major Subcontractor Cost Summary Template (MSCST). Although the details of the Minor Subcontractors costs are not required in this template, please note that it is the Major Subcontractor's responsibility to evaluate each of its second-tier Subcontractor's proposal, whether that second-tier Subcontractor is a Major or Minor Subcontractor based on the definition of a Major Subcontractor. (A Major Subcontractoris one with at least $3,000,000 in the core proposal.) The evaluations of the Minor Subcontractors shall be documented by the Major Subcontractor in the Cost Narrative in Volume II of the Major Subcontractor's proposal. The narrative shall also provide the rationale and basis for the Major Subcontractor's decision on each second-tier Subcontractor's cost. Also, the WYEs and hours proposed by all second-tier Subcontracts to the Major Subcontractor are required to be included in the Major Subcontractor's TRST worksheet.

MSCST

Major Subcontractor Cost Summary Template (MSCST)

Major Subcontractor Company Name:

&"Times New Roman,Regular"&12Draft RFP No. 80JSC020R0034 Attachment L-2 SECTION L

INSTRUCTIONS FOR COMPLETION THE MSCST TEMPLATE

Major Subcontractor's Instructions:

Each subcontractor shall aubmit this worksheet in accordance with the following.

This worksheet is to be completed by Major Subcontractors only, and provided to the Prime Offeror unless there are Proprietary Data issues between the Prime and Subcontractor. The data in this worksheet pertain to the Subcontractor's Core effort only. Notwithstanding the first sentence in this paragraph, the data in this worksheet is to be provided to the Prime Offeror in the level of details agreed to between the Prime Offeror and the Major Subcontractor. However, at a minimum, the Major Subcontractor shall provide the following by Contract Year, for the entire period of performance, to the Prime Offeror.

Proposed WYEs by SLC Proposed Hours Separated by Straight Time and Overtime Total Cost, Fee, and Total…