Attachment_L-5_Excel_Pricing_Model_Update-11-21-2016.xlsx

Contract form

&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

&"Times New Roman,Bold"&11IDIQ CONTRACT RATES FORM

Workbook Instructions Attachment L-5 RPOC IV 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 five year contract then five 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:

RPOC IV Workbook Acronyms:

FBR: Fully Burdened Rates Template MST: Minor Subcontract Template ISCT: SR – IDIQ Summary Cost Template – Specified Resources OHT: Overhead Template GAT: General & Administrative Expense Template TC (a): Compensation Template (b): Salaries & Wages –Exempt TC(b): Compensation Template (c): Fringe Benefit Analysis of Compensation Plan TC (c): Compensation Template (e): Incumbency Assumptions PIT: Phase in Template CFAOT: Cognizant Audit Office Template

FBR Instructions

Fully Burdened Rates (FBR) Template

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.

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

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.

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

FBR

FULLY BURDENED RATES TEMPLATE (FBR)

RFP - NNJxxxxxxx &12Section L Attachment L-xx

MST

MINOR SUBCONTRACT TEMPLATE (MST)

Prime Contractor Name:

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

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

RFP - NNJxxxxxxx SECTION L

&A Page &P of &N

The minor subcontractor template is required of the prime Offeror only. This template is intended to provide the evaluation team with a concise assessment of the substance of minor subcontracts. An example showing how this template is to be completed is included on the template.

ISCT - SR

THIS IDIQ SCT - SPHs & NLRs WILL BE USED FOR SOURCE SELECTION PURPOSES.

CONTRACT RATES

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

LABOR COST

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

THIS IDIQ SCT - SPHs & NLRs WILL BE USED FOR SOURCE SELECTION PURPOSES.

CONTRACT RATES

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

LABOR COST

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

THIS IDIQ SCT - SPHs & NLRs WILL BE USED FOR SOURCE SELECTION PURPOSES.

CONTRACT RATES

LABOR COST

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

RFP - NNJxxxxxxx SECTION L

&A Page &P of &N

This template is for pricing the Government specified level of resources identified in Table L -3 (direct labor hours) and is required of the prime Offeror only. This template covers the estimated price (cost and fee) to perform WBS 2.0, WBS 2.2, WBS 2.3, and WBS 2.4, 3.0, 4.0, 5.0, 6.0 of the SOW.

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.

Full-Time Equivalent (FTE) and Productive Hours

This section addresses Productive Hours. The hours included for each contract year shall match the hours provided in Table L-3.

A FTE 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 FTE 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 FTE based on 2,080 total hours and who receives 5 holidays (40 hours), three and one half weeks of vacation (140 hours), and 5 sick days (40 hours), would be shown as a productive FTE of 1,860 hours (2,080 total hours minus 40 hours for holidays minus 100 hours for vacation time minus 40 hours for sick days).

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

Fee Dollars

This section of the template addresses the fee dollars. 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. This 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.x of the Model Contract.

This template is for pricing the Government specified level of resources identified in Table L -3 (direct labor hours) and is required of the prime Offeror only. This template covers the estimated price (cost and fee) to perform WBS 2.0, WBS 2.2, WBS 2.3, and WBS 2.4, 3.0, 4.0, 5.0, 6.0 of the SOW.

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.

This template is for pricing the Government specified level of resources identified in Table L -3 (direct labor hours) and is required of the prime Offeror only. This template covers the estimated price (cost and fee) to perform WBS 2.0, WBS 2.2, WBS 2.3, and WBS 2.4, 3.0, 4.0, 5.0, 6.0 of the SOW.

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.

OHT

Overhead Template (OHT)

Overhead or Service Center Pool -

Base of Application-

Contractor's Fiscal Year-

Total Overhead Pool Expenses $ - 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

CONVERSION OF BURDEN RATE TO CONTRACT YEAR Contract Year 1 Rate Contract Year 2 Rate Contract Year 3 Rate Contract Year 4 Rate Contract Year 5 Rate

RFP - NNJxxxxxxx SECTION L

&A Page &P of &N

Specify Type of Overhead Burden: Labor, Fringe, Onsite, Offsite, Engineering, Procurement, Service Center(s), etc.

Specify the Base of ApplicationType: Labor Dollars, Labor and Fringe Dollars, etc.

Specify the Beginning and Ending Date of Your Fiscal Year (i.e., January 1 thru December 31) The prime Offeror and all major subcontractor(s) shall provide either their Forward Pricing Rate Agreement (FPRA) covering the overhead rate(s) used to calculate the FBRs for this proposal or this template. This template shall provide insight into the composition of the burden pool for the proposed overhead rate(s). A separate overhead template for each of the proposed burden pools is to be completed. In addition, provide overhead cost history for the prior three years and for the term of the contract.

A few cost elements are included on this template that represents the type of cost detail the Government requires visibility into. If these cost elements are not applicable to any proposed indirect cost pool, leave blank. Add additional cost elements, as applicable.

Rate Reconciliation In the event the Offeror’s fiscal year and anticipated contract year do not coincide, the Offeror shall complete the rate reconciliation showing how their fiscal year overhead rate(s) result in the proposed overhead rate(s) for each contract year. The Government does not require or mandate that you propose indirect rate ceilings. However, if proposed, the template includes an area for overhead ceilings and they must be included in Section B.x of the Model Contract

GAT

G&A Template (GAT)

Base of Application-

Contractor's Fiscal Year-

Labor: (Identify)

Labor Related Cost: (Identify)

Total G&A Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Contractor Fiscal Year G&A Rate (%) No Information No Information No Information No Information No Information No Information No Information No Information

RFP - NNJxxxxxxx SECTION L

&A Page &P of &N

The prime contractor and all major subcontractor(s) must provide their Forward Pricing Rate Agreement (FPRA) covering the G&A rate used to calculate the FBRs for this proposal or this template. This template shall provide insight into the composition of the burden pool for the proposed General and Administrative (G&A) rate. Identify the estimated G&A expense and explain the method for its calculation. In addition, provide G&A cost history including the actual expense pool and distribution base dollars for the prior three years and for the term of the contract.

A few cost elements are included on the template which represents the type of cost detail the Government requires visibility into. If these cost elements are not applicable to your proposed G&A cost pool, leave blank. Add additional cost elements, as applicable.

Specify the Beginning and Ending Date of Your Fiscal Year (i.e., January 1 thru December 31) Specify the Base of ApplicationType: Total Cost Input (TCI), Value Added, etc.

Rate Reconciliation In the event the Offeror’s fiscal year and anticipated contract year do not coincide, the Offeror shall complete the rate reconciliation showing how their fiscal year G&A rate results in the proposed G&A rate for each contract year. The Government does not require or mandate that you propose indirect rate ceilings. However, if proposed, the template includes an area for overhead ceilings and they must be included in Section B.x of the Model Contract.

TC(a) TC(a) -- SALARIES & WAGES EXEMPT

* It is possible that these categories may be defined as either exempt or non-exempt labor categories.

&"Times New Roman,Regular"RFP - NNJxxxxxxx &"Times New Roman,Regular"SECTION L

&A Page &P of &N

This template is required of the prime Offeror and each major subcontractor(s).

The Offeror shall submit a completed Compensation Template (b) for exempt personnel for Contract Year 1.

Labor Category Offeror’s” column, list all proposed labor classifications (included in the cost proposal), by titles from the Offeror's estimating system. Each of the Offeror’s Labor Categories shall be mapped to the NASA SLC column.

Incumbent Actual Labor Rate Only applicable to incumbent contractors or sub-contractors. Incumbent contractors or sub-contractors are to include the actual average current direct labor rate for each SLC.

Contract Year 1 Actual Proposed Labor Rate The Offeror’s actual proposed composite direct labor rate proposed for Contract Year 1.

FTE

Shall include all proposed FTEs per SLC.

Proposed Labor Escalation % Contract Year 2 through Contract Year 5 columns shall include your annual proposed escalation percentage.

Contract Year 1 Actual Proposed Annual Salary The annual salary of the proposed labor category.

Source Identify the supporting data for each labor category, which shall include the source data (for example, Actual Wages or Wage Survey) for exempt personnel. An example is included on the template for illustration purposes only.

TC(b) TC(b) -- FRINGE BENEFITS ANALYSIS OF COMPENATION PLAN

TOTAL VACATION AND HOLIDAY ________

TOTAL FRINGE BENEFITS

&"Times New Roman,Regular"RFP - NNJxxxxxxx &"Times New Roman,Regular"SECTION L

&A Page &P of &N

This template is required of the prime Offeror and all major subcontractor(s). It should be noted that the minimum hourly fringe benefits rate cannot be less than the DOL specified minimum rate listed in the RFP under Section J for non-exempt employees.

Cost of Fringe Benefit Shall include the cost, not rate, associated with the fringes specified (i.e. life insurance, disability insurance, etc.) that are proposed on this contract for each of the related personnel type (exempt, non-exempt non-union, and non-exempt union).

Percent of Direct Labor Cost Shall include the percentage of each of the related specified fringe costs as a percent of direct labor cost.

Average Cost Per Labor Hour Shall include hourly rates based on the average cost per labor hour proposed per specified fringe element.

TC(c) TC(c) -- Incumbency Assumptions

Incumbency Assumptions

RFP #NNJ13ZBR004R

SECTION L

ATTACHMENT L-10

This template is required of the prime Offeror and all major subcontractor(s) . This template is a data point that provides visibility into any incumbency assumptions proposed by each Offeror pertaining to incumbency retention, incumbency direct labor rates, and incumbency seniority rights for fringe benefit purposes, and is not intended to influence an Offeror’s staffing approach.

Incumbent Retention The Offeror shall identify the percentage of all positions that would be staffed with incumbents and the percentage of all positions that would be staffed by non-incumbents. The two percentages must total 100%.

Labor Rates The Offeror shall identify the percentage of all positions that would be paid current incumbent direct labor rates and the percentage of all positions that would be paid other than current incumbent direct labor labor rates. The two percentages must total 100%. The Government understands that non-incumbent Offerors may only be able to estimate what the current incumbents are making; however, it simply wants to understand your intentions regarding pay for these employees, if retained. The Offeror shall provide an explanation, including detailed supporting data, of how the proposed salary structure will facilitate the retention of the proposed percentage of the qualified incumbent workforce.

Seniority Rights The Offeror shall identify the percentage of all positions that would retain seniority rights for fringe benefit purposes and the percentage of all positions that would not retain seniority rights for fringe benefit purposes. The Government understands that non-incumbent Offerors may only be able to estimate the current incumbents’ seniority levels; however, it simply wants to understand your intentions regarding seniority for these employees, if retained. The Offeror shall provide an explanation, including detailed supporting data, of how the proposed fringe structure will facilitate the retention of the proposed percentage of the qualified incumbent workforce.

NOTE: Information pertaining to incumbent direct labor rates and seniority levels will be available in the Technical Library prior to the release of the Final RFP.

PIT

PHASE-IN TEMPLATE (PIT)

Prime Offeror Name:

Prime Labor cost 100 10 1000

Prime Facilities Capital Cost of Money

&"Times New Roman,Regular"RFP - NNJ12414367R &"Times New Roman,Regular"SECTION L Attachment L-4

&A Page &P of &N

The phase-in template is required of the prime Offeror only and is designed to show the total phase-in cost (includes all subcontractor phase-in costs and fee) proposed.

This template must be supported by a narrative basis of estimate (BOE). Include all skills and hours on this template and add rows if needed to account for all labor required. Use the SLCs for skill mix if appropriate or include your labor mix on the template with a brief job description in the narrative. The BOE should include a discussion of labor skill mix and significant non-labor resources (materials/supplies, equipment, other, etc.) necessary for accomplishment of phase-in requirements. The phase-in template is to include ALL phase-in costs necessary for full contract implementation.

CFAOT

COGNIZANT FEDERAL AGENCY AND AUDIT OFFICE TEMPLATE (POINTS OF CONTACT & AUDIT DATA)

POINTS OF CONTACT

RFP #NNJ13ZBR004R Section L Attachment L-10

This template is required of each prime contractor, teaming partner, joint venture partner, and major subcontractor that meets the major subcontractor threshold ($XX or more per year)If the Offeror does not know the cognizant DCAA field audit office, the information is readily available on the world-wide-web at www.dcaa.mil. Once the web site is accessed, click on the “Audit Office Locator” link. Enter the Offeror’s company’s 5 digit Zip Code in the area provided and click on the adjacent “search” button. (It is important that the Offeror enter the 5 digit Zip Code for the Offeror’s company location where auditable books and records supporting amounts in the Offeror’s proposal physically reside.) Once the search is completed, the cognizant field audit office physical and E-Mail addresses and Voice and FAX telephone numbers will be displayed.