BH4-17-029,_RFP_Section_5_Pricing_Template.xlsx

Workbook 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 Electronic Pricing Model (EPM) and all its associated workbooks shall not be locked/protected or secured by passwords.

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.

SRT

Specified Resources Template

Prime Offeror's Name:

NASA Standard Labor Categories (SLCs) Contract Year 1 Contract Year 2 Contract Year 3 Contract Year 4 Contract Year 5 Total CY 1-5

TOTAL PRICE (Fully-Burdened Labor Cost + Total NLR Price $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Specifed Resources (Hours) The hours shown in this template are specified resources provided in the RFP and are required to be priced out by the prime contractor. An Offeror shall not change, eliminate or modify these hours when preparing its proposal. The hours represent the total for the prime contractor and all subcontractors for each contract year.

Fully-Burdened Composite Labor Rates The fully-burdened composite labor rates represent the composite rates for the prime contractor and all subcontractors for each SLC. The composite rates are calculated based on the percentage of performance by the prime and all subcontractors for each SLC. The fully-burdened rates shall include profit.

Fully-Burdened Labor Price The fully-burdened labor price is developed by multiplying the Specified Resources (hours) by the appropriate Fully-Burdened Composite Labor Rates.

Non-Labor Resources (NLR) This section of the template provides for annual NLR required for the performance of the contract and is to be completed by the prime contractor (including information for both the prime and subcontract). An Offeror shall not change, eliminate or modify this NLR cost provided in the RFP when preparing its proposal. The NLR cost represents the total cost for the prime contractor and all subcontractors for each contract year. If an Offeror proposes any burdens and profit, they shall be identified and calculated in this section of the template.

Phase-In Price The phase-in firm-fixed price is required of the prime Offeror only and is designed to show the total phase-in price (includes all subcontractor phase-in costs and profit) proposed. The price must be supported by a narrative basis of estimate (BOE).

SAI

Subcontracting Arrangement Information (SAI)

Reference FAR 52.219-14, Limitation on Subcontracting

*For this requirement, total Fully Burdened Labor Cost does not include NLRs or profit.

This template is required from the prime contractor only, or in the case of a joint venture, from each member company. It is required to evaluate the small business prime contractor's level of performance of the more complex contract function. This template shall show the amount of fully-burdened labor cost to be incurred by the small business prime contractor and all subcontractors for the total contract (Reference FAR 52.219-14, Limitation on Subcontracting.)

In this template, the example, shown in red, is provided to demonstrate formatting and how the data is to be submitted. The data in the example is not real and should not be interpreted as such. The examples shall be removed from the chart prior to submitting the proposal.

TC (a) TC(a) -- Salaries & Wages (Non-Exempt)

This template is required of the prime Offeror, each major subcontractor(s), and all subcontractors as defined in NFS 1852.231-71(d). The Offeror shall submit a completed Compensation Template (a) for non-exempt personnel for Contract Year 1.

Labor Category Mapping 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. The DOL WD or CBA column shall be mapped to the LABOR CATEGORY – Offeror’s column.

Incumbent Actual Labor Rate This column is only applicable to incumbent contractors or subcontractors. Incumbent contractors or sub-contractors are to include the actual average current direct labor rate for each SLC. Depending on whether the category is DOL or CBA covered, include the wage rate in the appropriate column.

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

WYE

Shall include all proposed WYEs per SLC.

Proposed Labor Escalation % The Contract Year 2 through Contract Year 8 columns shall include your annual proposed escalation percentage (Note: The information provided should match the escalation percentage shown and discussed in the “Specific Guidelines” section of the narrative.)

Source Identify the supporting data for each labor category, which shall include the source data (for example, DOL, CBA, etc.) for non-exempt personnel. An example is included on the template for illustration purposes only.

TC (b) TC(b) -- Salaries & Wages (Exempt)

LABOR CATEGORY MAPPING Incumbent Actual Labor Rate Contract Year 1 Actual Proposed Labor Rate WYEs Proposed Labor Escalation % CY 1 Actual Proposed Annual Salary Source

NASA (JSC) Standard Labor Category Offeror's Category CY 2 CY 3 CY 4 CY 5

This template is required of the prime Offeror, each major subcontractor(s), and all subcontractors as defined in NFS 1852.231-71(d). The Offeror shall submit a completed Compensation Template (b) for non-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.

WYE

Shall include all proposed FTEs per SLC.

Proposed Labor Escalation % Contract Year 2 through Contract Year 8 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(c) TC(c) -- Fringe Benefits Analysis of Compensation Plan

CATEGORY COST OF FRINGE BENEFIT PERCENT OF DIRECT LABOR COST AVERAGE COST PER LABOR HOUR DESCRIPTION OF BENEFIT

TOTAL VACATION AND HOLIDAY ________

TOTAL FRINGE BENEFITS

This template is required of the prime Offeror and all major subcontractor(s) as defined in NFS 1852.231-71(d). It should be noted that the minimum hourly fringe benefits rate cannot be less than the DOL specified minimum rate listed in the Wage Determination 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(d) TC(d) -- Incumbency Assumptions

Proposing to pay _____% of incumbents current incumbent direct labor rates. Proposing to pay _____% of incumbents less than current incumbent direct labor rates.

Seniority Rights Proposing to maintain seniority rights for fringe purposes for __% of incumbents.

Proposing to not maintain seniority rights for fringe purposes for __% of incumbents.

This template is required of the Prime Offeror only. 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. This template is to reflect the overall program percentages including prime, major and minor subcontractors.

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 rates. The three 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 Final RFP.