Attachment L-6 EPM Workbook - Amendment 4 12-2-19 - FRFP-3.xlsx

TRT-SOW 1.0

TRT-SOW 2.0

TRT-SOW 3.0

TRT-SOW 4.0

TRT-SOW 5.0

COMBINED RESOURCES FOR THE ENTIRE TEAM -- PRIME OFFEROR AND ALL SUBCONTRACTORS (INCLUDING MINOR SUBCONTRACTORS)

TRT-SOW 6.0

COMBINED RESOURCES FOR THE ENTIRE TEAM -- PRIME OFFEROR AND ALL SUBCONTRACTORS (INCLUDING MINOR SUBCONTRACTORS)

TRT-SOW 7.0

COMBINED RESOURCES FOR THE ENTIRE TEAM -- PRIME OFFEROR AND ALL SUBCONTRACTORS (INCLUDING MINOR SUBCONTRACTORS)

TRT-SOW 8.0

TRT-SOW 9.0

TRST-CORE

Ex: Productive Hours per WYE Conversion Factor 1840 1840 1840 1840 1840

Ex: Business Specialist 3 100% 11.8 21,712 11.8 21,712 11.8 21,712 11.8 21,712 11.8 21,712 59.0 108,560

PRODUCTIVE HOURS PER WYE CONVERSION FACTOR

LPT

Proposed Rate of Escalation N/A 0.00% 0.00% 0.00% 0.00%

Ex: Business Specialist 3 $ 589,832 $ 606,347 $ 623,325 $ 640,778 $ 658,719

MSCST

Sub-Total Cost ERROR:#VALUE! $ - 0 $ - 0 $ - 0 $ - 0 ERROR:#VALUE!

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

PCST

Sub-Total Cost ERROR:#VALUE! $ - 0 $ - 0 $ - 0 $ - 0 ERROR:#VALUE!

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

TOPT-SR

Task Order Pricing Template - Specified Resources (TOPT-SR)

The template is divided into three main sections. The first section addresses Productive Hours. The hours included for each contract year shall match the hours provided in Table L-6. The second 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.6 of the Model Contract. The third 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.

The bottom of the template addresses the NLR and fee dollars. The NLR dollars included for each contract year shall match the NLR dollars provided in Table L-7. Offerors shall apply any applicable burdens to the proposed NLR dollars. The bottom of the template 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 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.6 of the Model Contract. Any cost elements proposed to be non-fee bearing here must contain the same contractual language in Section B.6 of the Model Contract.

Full Contract Year 2 through Contract Year 5 requirements may not be indicative of Contract Year 1 estimates prorated to a twelve month time period. Therefore this consideration shall be included in developing the Offeror’s FBRs. The pricing of Contract Year 2 through Contract Year 5 is for proposal purposes only and is intended to provide the Government visibility regarding the effect of the proposed rates in the out years. The total price estimate for all contract years will be used for selection purposes.

Table L-6 hours are used in each Contract Year

CONTRACT RATES

EXAMPLE: Analyst 2 Link to FBR Link to FBR Link to FBR Link to FBR Link to FBR

LABOR COST

FBR

FULLY BURDENED RATES TEMPLATE (FBR)

As noted towards 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).

The 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 Business Specialist 3 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 Business Specialist 3 for illustrative purposes.

The Percentage Usage Column is provided so that the Offeror may weigh the proposed direct labor per the Offeror’s labor categories.