Attachment L-03 Baseline EPM Template.xlsx

TRT - Baseline A

Combined resourcs for the entire team Prime Offeror and All Subcontractors (Major and Minor)

Ratio

*Note: The TRT templates funcation as a link between Volume I Technical Acceptability and Volume III Cost/Price

Note: Examples are on the top in red font and self-calculating formulas MUST BE PROVIDED for all grey shaded areas. Please remember to remove the red highlighted examples from the templates prior to your official proposal submission.

TRST - Baseline A

Combined resourcs for the entire team Prime Offeror and All Subcontractors (Major and Minor)

*Note: The TRST-CORE template funcations as a link between Volume I Technically Acceptability and Volume III Cost/Price Ex: Productive Hours per WYE Conversion Factor 1840.0 1840.0 1840.0 1840.0 1840.0

Ex: Business Specialist 3 100% 8.5 15640.0 8.5 15640.0 8.5 15640.0 8.5 15640.0 8.5 15640.0 42.5 78200.0

Productive Hours per WYE Conversion Factor

Note: Examples are on the top in red font and self-calculating formulas MUST BE PROVIDED for all grey shaded areas. Please remember to remove the red highlighted examples from the templates prior to your official proposal submission.

LPT - Baseline A Labor Pricing Template - Baseline A (LPT-Baseline A)

The hours and costs shown on this template shall support and reconcile to the hours and cost shown on either the PCST-Baseline A or MSCST-Baseline A tabs, as applicable. The hours shall also support and reconcile the proposed hours shown on the TRST-Baseline A tab.

Ex: Business Specialist 3 $27.17 $27.71 $28.27 $28.83 $29.41

Ex: Business Specialist 3 424,939 433,438 442,106 450,948 459,967

Note: Examples are on the top in red font and self-calculating formulas MUST BE PROVIDED for all grey shaded areas. Please remember to remove the red highlighted examples from the templates prior to your official proposal submission.

MSCST - Baseline A Major Subcontractor Cost Summary Template - Baseline A (MSCST - Baseline A)

Major Subcontractor Name:

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

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

MST - Baseline A

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

Example:

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

PCST - Baseline A Prime Cost Summary Template - Baseline A (PCST-Baseline A)

*IMPORTANT: The Prime Offeror's hours and cost identified in the PCST-Baseline A by the Prime Offeror for each Major Subcontractor should match the hours and cost identified in each Major Subcontractor's cost proposal. If not, differences MUST BE explained.

Prime Labor Cost $ - 0

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

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

TRT - Baseline B

Combined resourcs for the entire team Prime Offeror and All Subcontractors (Major and Minor)

Ratio

Ex: Business Specialist 3 0.5 1.0 1.5 1.5 1.5 1.5 1.5 1.5 1.5 12.0

*Note: The TRT templates funcation as a link between Volume I Technical Acceptability and Volume III, Cost/PriceI

NOTE: Examples are on the top in red font and self-calculating formulas MUST BE PROVIDED for all grey shaded areas. Please remember to remove the red highlighted examples from the templates prior to your official proposal submission.

TRST - Baseline B

Combined resourcs for the entire team Prime Offeror and All Subcontractors (Major and Minor)

*Note: The TRST-CORE template funcations as a link between Volume I Technically Acceptability and Volume III Cost/Price Ex: Productive Hours per WYE Conversion Factor 1840.0 1840.0 1840.0 1840.0 1840.0

Ex: Business Specialist 3 100% 8.5 15640.0 8.5 15640.0 8.5 15640.0 8.5 15640.0 8.5 15640.0 42.5 78200.0

Productive Hours per WYE Conversion Factor

Note: Examples are on the top in red font and self-calculating formulas MUST BE PROVIDED for all grey shaded areas. Please remember to remove the red highlighted examples from the templates prior to your official proposal submission.

LPT - Baseline B Labor Pricing Template - Baseline B (LPT-Baseline B)

The hours and costs shown on this template shall support and reconcile to the hours and cost shown on either the PCST-Baseline B or MSCST-Baseline B tabs, as applicable. The hours shall also support and reconcile the proposed hours shown on the TRST-Baseline B tabs.

Ex: Business Specialist 3 $27.17 $27.71 $28.27 $28.83 $29.41

Ex: Business Specialist 3 424,939 433,438 442,106 450,948 459,967

Note: Examples are on the top in red font and self-calculating formulas MUST BE PROVIDED for all grey shaded areas. Please remember to remove the red highlighted examples from the templates prior to your official proposal submission.

MSCST - Baseline B Major Subcontractor Cost Summary Template - Baseline B (MSCST - Baseline B)

Major Subcontractor Name:

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

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

MST - Baseline B

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

Example:

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

PCST - Baseline B Prime Cost Summary Template - Baseline B (PCST-Baseline B)

*Note: The Prime Offeror's hours and cost identified in the PCST-Baseline B by the Prime Offeror for each Major Subcontractor should match the hours and cost identified in each Major Subcontractor's cost proposal. If not, differences MUST BE explained.

Prime Labor Cost $ - 0

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

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

OHT

Overhead Template (OHT)

Total Overhead Pool Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Contractor Fiscal Year Rate (%) No Information No Information No Information No Information No Information No Information No Information No Information No Information

Instructions to Offerors

The Prime Offeror and all Major Subcontractor(s) must either provide their Forward Pricing Rate Agreement (FPRA) covering the OH and service center rate(s) used in pricing this proposal, OR complete this template. This template shall provide insight into the composition of both the burden pool and base used in the development of each of the proposed overhead and service center rate(s). A separate template for each of the proposed overhead and service center rate(s) is to be completed by the Offeror. In addition, provide the overhead and service center cost and rate history for the prior three (3) CFYs.

The basis for projections of all indirect rates shall also be provided along with an explanation in support of any significant changes in either the expense pool components or the composition of the distribution base dollars from the Offeror's historical data (prior 3 years) to the current contract year data. Further, an explanation of significant changes from one contract year to the next shall be provided. The distribution base dollars shall be further specifically identified by the Offeror's current existing government and commercial contract work (e.g. Existing Business Base), the value of this potential contract award (e.g., This Contract Base), and the Offeror's forecasted "other business" (e.g., Forecasted Business Base) work.

For no less than 80% of the Offeror identified total "Existing Business Base" dollars, the Offeror shall provide the following specific information for each contract comprising the existing business base dollars -- whether the work is government or commercial, the contract number, the organization and the point of contact within the organization (phone number and e-mail address identified), the dollar amount by CFY, and the period of performance of the contract. The remaining 20% may be lumped together on a single line with the number of contracts comprising the remaining 20% identified. For no less than 80% of the Offeror identified total "Forecasted Business Base" dollars, the Offeror shall provide the following specific information on the forecasted "other business" -- the nature of the forecasted "other business" (i.e., an existing RFP that the Offeror has or intends to bid on, follow-on work that the Offeror intends to bid on at the conclusion of an existing contract, unknown work that the Offeror has historically included in the development of its business base, etc.), the historical win percentage over the past five years when submitting bids or other statistical data to support the proposed "other business" dollars including a narrative explanation of the basis of estimate for the "Forecasted Business Base" dollars. Provide a dollar breakdown, by CFY, for each type of potential award(s) specifically used by the Offeror in support of the total "Forecasted Business Base" dollars (i.e., "other business").

In the event of the Offeror's fiscal year and anticipated contract year do not coincide, the Offeror shall identify the formula and/or rate reconciliation indicating the method used to convert the Offeror's fiscal year indirect rate(s) to the contract year indirect rate(s) proposed for each Contract Year.