SCARS_RFP_Attachment_16_Prof_Employee_Compensation_Plan_Data.xlsx

TOC

TABLE OF CONTENTS

GENERAL INSTRUCTIONS

REMINDER: This spreadsheet only applies to Professional Employees as defined in 29 CFR 541.300

DO NOT ENTER DATA INTO GRAY-SHADED CELLS THROUGHOUT THE ENTIRE SPREADSHEET FILE.

(a) It is the Offeror's responsibility to ensure that all formulas are traceable and correct.

(b) Instructions are provided for each Exhibit. These instructions are to be applied only to the Exhibit in which they appear.

(c) The Calendar Year (CY) begins 1 January and ends 31 December.

(d) All rates shall be submitted in Then-Year (escalated) dollars.

(e) The Offeror is permitted to add Worksheets (Tabs) to this Workbook to perform intermediary calculations.

(f) The Offeror shall not include links to outside workbooks/source documents anywhere in this template.

(g) The Offeror shall not hide tabs, formulas, or rows/columns within this template.

A_Labor Rates Summary

EXHIBIT A: LABOR RATES

Government Site (Location)

&F &P of &N &A

Exhibit A Description: Offeror's proposed labor rates for Government (on-site) and Contractor (off-site) facilities. Note this Exhibit "A " automatically populates Offeror's inputs from another worksheet tab (Exhibit B) embedded in this spreadsheet; thus no entries necessary as all cells are shaded-gray.

Exhibit A Instructions:

DO NOT ENTER DATA INTO GRAY-SHADED CELLS.

(a ) This spreadsheet will capture labor rates (direct rate + fringe) for each professional labor category contained in the proposal. Differentiate between government site and contractor site labor rates, if applicable.

(b) The Offeror is authorized to insert rows to include additional labor categories if required.

(c) It is the Offeror's responsibility to ensure that all formulas are traceable and correct.

B_Labor Rates Detail

EXHIBIT B: LABOR RATES DETAIL

Figure B-1: Detailed Labor Rates (Contractor Site) for Calendar Year (CY)

Contractor Site (Location)

Figure B-2: Detailed Labor Rates (Government Site) for Calendar Year (CY)

Government Site (Location)

&F &P of &N &A

Exhibit B Description: Prime and Subcontractor proposed labor rates for both Government (on-site) and Contractor (off-site) facilities identified by Rate and Fringe.

Exhibit B Instructions:

DO NOT ENTER DATA INTO GRAY-SHADED CELLS.

(a) Provide labor rate information for each labor category contained in the proposal. Differentiate between Contractor Site (off-site) and Government Site (on-site) labor rates in Figures B-1 and B-2.

(b) Differentiate between prime and subcontractor rates where appropriate. The prime contractor may add additional worksheets to perform intermediary calculations and incorporate subcontractor labor rates. Those subcontractor labor rates should roll up to the Labor Category rows by CY on this worksheet.

(c) The Offeror is authorized to insert rows to include additional labor categories if required.

(d) It is the Offeror's responsibility to ensure that all formulas are traceable and correct.