Attachment_03_-_Professional_Compensation_Plan_Model.xlsx

XLSX spreadsheet 26 KB Posted Apr 5, 2019

Attached to: Information Security Support Services Federal contract opportunity
Solicitation number: FA7037-19-R-A001
Issued by: Department of the Air Force Air Combat Command

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains an Excel spreadsheet template and instructions for contractors to submit professional compensation plans in response to solicitation number FA7037-19-R-A001 for Information Security Support Services from the Department of the Air Force Air Combat Command.

The template requires contractors to input their company name and proposed job categories with corresponding base salary rates, fringe benefit rates, and median annual salaries from Salary.com. Contractors must certify that actual base rates paid will meet or exceed escalating yearly floor salaries set by the government. The solicitation seeks to procure qualified professional employees to support retention rates outlined in the Performance Work Statement. Responses are due by completing the template in accordance with the detailed instructions provided.

From the source

This is a model utilized to determine whether professional compensation plans are in line with Industry.

View the file

Other files for this federal contract opportunity

Other files attached to Information Security Support Services, newest first.
File	Type	Posted
Questions_and_Responses_to_Draft_RFP_(Master-Revised).pdf	PDF	May 13, 2019
Questions_and_Responses_to_Draft_RFP_(MASTER).pdf	PDF	May 10, 2019
Letter_to_Industry_(2019-04-09).pdf	PDF	Apr 10, 2019
Letter_to_Industry_(2019-04-09).pdf	PDF	Apr 9, 2019
Draft_52.212-2_Addendum.pdf	PDF	Apr 9, 2019
Draft_52.212-1_Addendum.pdf	PDF	Apr 9, 2019
Exhibit_3_-_Attachment_1.pdf	PDF	Apr 5, 2019
Exhibit_1_-_Performance_Work_Statement.pdf	PDF	Apr 5, 2019
Exhibit_6_-_CDRL_A005-A006.pdf	PDF	Apr 5, 2019
Attachment_01_-_Past_Performance_Information.pdf	PDF	Apr 5, 2019
Exhibit_5_-_CDRL_A003-A004.pdf	PDF	Apr 5, 2019
Attachment_07_-_Scenario_PWS.pdf	PDF	Apr 5, 2019
Exhibit_4_-_CDRL_A001-A002_with_Draft.pdf	PDF	Apr 5, 2019
Exhibit_7_-_CDRL_A007-A008.pdf	PDF	Apr 5, 2019
Attachment_06_-_Example_Salary.Com_Submittal_Page.pdf	PDF	Apr 5, 2019
Exhibit_2_-_Fully_Burdened_Rates_by_Region.xlsx	XLSX spreadsheet	Apr 5, 2019
FA703719RA001_Draft.pdf	PDF	Apr 5, 2019
Exhibit_3_-_DD_254_-_ISSS_(29_March_2019).pdf	PDF	Apr 5, 2019
Attachment_04_-_Total_Evaluated_Price_Worksheet.xlsx	XLSX spreadsheet	Apr 5, 2019
Attachment_02_-_Questionnaire.pdf	PDF	Apr 5, 2019
Attachment_05_-_Conformance_Review_Checklist.pdf	PDF	Apr 5, 2019

Show all 21

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Attachment 03 - Evaluation of Compensation for Professional Employees
FA7037-19-R-A001
	Tab	Professional Compensation Plan Model Instructions:
1	Comp Plan Model	Input the Offeror's name in cell B4 of the Comp Plan Model Tab
2	Comp Plan Model	Input in cells A7 - A60 all the proposed job categories. Should additional job categories be needed, add them to the cells following C60.
3	Comp Plan Model	Input in cells B7 - B60 all the base rates for every listed proposed job category. Base Rate based on average rate paid CONUS (i.e. all locations found within the PWS)
4	Comp Plan Model	Input in cells C7 - C70 all the fringe rates for every listed proposed job category. Fringe benefit information is the average fringe rate for all CONUS locations as found within the PWS.
5	Comp Plan Model	Input in cells E7 - E70 all the corresponding Salary.com job category titles.
6	Comp Plan Model	Input in cells F7 - F70 the median annual salary (without fringe) as found in Salary.com.
7	Floor Salaries	Certify the Floor Salaries Tab by Signing and Dating in cells A68, E68
8	Floor Salaries	Complete the signer's information in cells A69, A70, A71

Notice to Contractors

1. Unrealistically low professional employee salaries may impair Offerors ability to attract and retain competent professional employees and may be viewed as evidence of failure to comprehend the complexity of the contract requirements.

2. Professional compensation of employees is being done IAW FAR 22.1103 and provision 52.222-46.

3. The offeror is responsible for identifying the labor categories. Types and mixture of labor categories will be evaluated as part of the technical evaluation process. Completeness, reasonableness, unrealistic low prices, unbalanced pricing, and price realism will be evaluated as part of the price evaluation.

4. Qualifications (if any) may be found in Exhibit 1 - Performance Work Statement.

Page 1 - Instructions

DRAFT

Comp Plan Model

Attachment 03 - Evaluation of Compensation for Professional Employees
FA7037-19-R-A001
Offeror Name:	Input
Location:			Evaluation Rates
Offeror's Labor Category	Base Rate Hourly Salary Information	Fringe Benefit Information Fringe Rate (%)	Total Compensation Rate (for evaluation purposes only)	Corresponding Salary.com Labor Category	Annual Median Salary	Salary.com hourly median rate	Salary.com Median Rate - 5%	Check
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ 1.00	2001.00%		Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ 1.00	2101.00%		Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	$ - 0		$ - 0	Input	Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Notes:
1. Base Rate based on average rate paid CONUS (i.e. all locations found within the PWS)
2. Fringe benefit information is the average fringe rate for all CONUS locations as found within the PWS.

Page 2 - Professional Compensation Model

Floor Salaries

Attachment 03 - Evaluation of Compensation for Professional Employees
Certification - Paying At or Above Established Floor
FA7037-19-R-A001
		Year 2	Year 3	Year 4	Year 5
Escalation Values (Set by Government)		3.60%	3.60%	3.60%	3.60%
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Input	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
I certify that the during the period of performance of the contract, base rates paid to employees under the resultant contract
will never fall below the value in the above listed chart. I further certify that I understand that these rates are "floors" for the
purposes of the contract and that actual base rates paid to employees under the resultant contract may be higher than the listed
values in order to recruit and retain a sufficient number of qualified employees to support the retention rate as listed in the
service summary of the Performance Work Statement as supplied by the contractor in the management plan.
Sign Here				Place Date Here
Printed Name (Replace with Actual Name)				Date
Printed Position (Replace with Actual Position)
Printed Name of Company (Replace with Actual Name)

&P of &N - Floor

File details come from the government source that posted it. Updated Dec 30, 2023.