Attachment_10_-_Floor_Base_Hourly_Rate_Worksheet.xlsx

XLSX spreadsheet 33 KB Posted Jun 13, 2019

Attached to: Information Security Support Services (IS3) Federal contract opportunity
Solicitation number: FA703719RA001
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 workbook attachment with instructions for completing a floor base hourly rate worksheet in response to solicitation FA7037-19-R-A001 from the Department of the Air Force Air Combat Command for information security support services. Offerors are instructed to input proposed labor categories and base hourly rates without fringe benefits in the workbook, along with the corresponding median annual salaries from the Salary.com database. Offerors must certify that base rates paid to employees under the resultant contract will not fall below the listed values and may need to be higher to recruit qualified employees to meet the retention requirements in the performance work statement. The workbook contains templates for inputting the required information across multiple tabs and years.

From the source

Attachment 10

View the file

Other files for this federal contract opportunity

Other files attached to Information Security Support Services (IS3), newest first.
File	Type	Posted
Amendment_0007_(2019-07-18).pdf	PDF	Jul 18, 2019
Attachment_02_-_Past_Performance_Questionnaire_(2019-07-11).docx	DOCX document	Jul 15, 2019
Amendment_06.pdf	PDF	Jul 11, 2019
Question_Set__5.pdf	PDF	Jul 11, 2019
Attachment_02_-_Past_Performance_Questionnaire_(2019-07-11).docx	DOCX document	Jul 11, 2019
Attachment_14_-_Course_(Present_and_Future).pdf	PDF	Jul 9, 2019
FA7037-19-R-A001-0005.pdf	PDF	Jul 9, 2019
Attachment_05_-_Conformance_Review_Checklist_(2019-07-09).pdf	PDF	Jul 9, 2019
Exhibit_1_-_PWS_(20190709).pdf	PDF	Jul 9, 2019
Attachment_03_-_Professional_Compensation_(2019-07-09).xlsx	XLSX spreadsheet	Jul 9, 2019
Attachment_08_-_52.212-1_(2019-07-09).pdf	PDF	Jul 9, 2019
Attachment_04_-_Total_Evaluated_Price_Worksheet.xlsx	XLSX spreadsheet	Jul 8, 2019
SF-30_(Amendment_of_Solicitation_Modification_of_Contract).pdf	PDF	Jul 8, 2019
Attachment_13_-_Addition_of_CLIN.pdf	PDF	Jul 8, 2019
Exhibit_1_-_PWS_(20190701).pdf	PDF	Jul 2, 2019
FA7037-19-R-A001-0003.pdf	PDF	Jul 2, 2019
Attachment_10_-_Floor_Rate_Worksheet_(2019-07-02).xlsx	XLSX spreadsheet	Jul 2, 2019
Attachment_11_-_Courses_(Present_and_Future).pdf	PDF	Jul 2, 2019
Attachment_09_-_52.212-2.pdf	PDF	Jul 2, 2019
SF-30_FA703719RA001_Amendment_02.pdf	PDF	Jul 1, 2019
Attachment_05_-_Conformance_Review_Checklist_(2019-06-27).docx	DOCX document	Jul 1, 2019
Attachment_03_-_Professional_Compensation_(2019-06-27).xlsx	XLSX spreadsheet	Jul 1, 2019
RFP_Questions_and_Responses_-_Set_2.pdf	PDF	Jul 1, 2019
Attachment_08_-_52.212-1_(2019-06-27).pdf	PDF	Jul 1, 2019
Questions_and_Responses_-_Set_1.pdf	PDF	Jun 24, 2019
Attachment_10_-_Floor_Rate_Worksheet.xlsx	XLSX spreadsheet	Jun 24, 2019
Attachment_01_-_Past_Performance_Information.docx	DOCX document	Jun 24, 2019
Attachment_08_-_Addendum_to_52-212-1.pdf	PDF	Jun 24, 2019
Attachment_03_-_Professional_Compensation.xlsx	XLSX spreadsheet	Jun 24, 2019
Exhibit_1_-_PWS.pdf	PDF	Jun 24, 2019
Solicitation_Amendment_FA703719RA0010001_SF_30.pdf	PDF	Jun 24, 2019
Exhibit_3_-_254_Attachments_SCI_Addendum_ISSS_(29_March_2019).pdf	PDF	Jun 13, 2019
Attachment_09_-_Addendum_to_52-212-2.pdf	PDF	Jun 13, 2019
Attachment_04_-_Total_Evaluated_Price_Worksheet.xlsx	XLSX spreadsheet	Jun 13, 2019
Exhibit_08_-_CDRL_A009.pdf	PDF	Jun 13, 2019
Attachment_12_-_Contractor_USFK_SOFA_Designation_Request_Process_Guidance.pdf	PDF	Jun 13, 2019
Solicitation_-_FA703719RA001.pdf	PDF	Jun 13, 2019
Exhibit_07_-_CDRL_A007-A008.pdf	PDF	Jun 13, 2019
Attachment_11_-_Status_of_Forces_Agreement_(SOFA)_Clause.pdf	PDF	Jun 13, 2019
Exhibit_06_-_CDRL_A005-A006.pdf	PDF	Jun 13, 2019
Exhibit_04_-_CDRL_A001-A002.pdf	PDF	Jun 13, 2019
Attachment_06_-_Example_SalaryCom_Submittal_Page.pdf	PDF	Jun 13, 2019
Attachment_03_-_Professional_Compensation_Plan_Model.xlsx	XLSX spreadsheet	Jun 13, 2019
Attachment_05_-_Conformance_Review_Checklist.pdf	PDF	Jun 13, 2019
Attachment_02_-_Past_Performance_Questionnaire.docx	DOCX document	Jun 13, 2019
Exhibit_02_-_Fully_Burdened_Rates_by_Region.xlsx	XLSX spreadsheet	Jun 13, 2019
Attachment_01_-_Past_Performance_Information.docx	DOCX document	Jun 13, 2019
Exhibit_05_-_CDRL_A003-A004.pdf	PDF	Jun 13, 2019
Attachment_08_-_Addendum_to_52-212-1.pdf	PDF	Jun 13, 2019
Exhibit_1_-_PWS.pdf	PDF	Jun 13, 2019

Show all 50

Information Security Support Services (IS3) has more files on GovTribe.

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 10 - Floor Base Hourly Rate Worksheet

FA7037-19-R-A001

	Tab	Professional Compensation Plan Model Instructions:
1	Labor Categories	Input the Offeror's name in cell A2 of the Labor Categories Tab.
2	Labor Categories	Input in cells A5 – A29 all the proposed labor categories. Should additional labor categories be needed, add them to the cells following A29.
3	Labor Categories	Input in cells B5 – B29 all the proposed base hourly rates for every listed proposed labor category. Base Rate based on average rate paid CONUS (i.e. all locations found within the PWS).
4	Labor Categories	Input in cells C5 – C29 all the equivalent labor categories from Salary.com.
5	Labor Categories	Input in cells D5 – D29 all the corresponding Median Annual Salaries from Salary.com.
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.
5. Additional rows may be added, if needed.
6. REMINDER: Please sign/date the Certification Statement on the Escalation of Base Rates spreadsheet.

Labor Categories

Attachment 10 - "Floor" Base Hourly Rate Worksheet

Offeror's Name: Input Offeror's Name Here

JONES, CAMERON A CIV USAF ACC 25 AF/AMIC DET 2/PKA: Input Offeror's (Company) Name in this Cell

Contractor's Labor Category JONES, CAMERON A CIV USAF ACC 25 AF/AMIC DET 2/PKA: Input Offeror's Proposed Labor Category

	Proposed Base Hourly Rate without fringe
JONES, CAMERON A CIV USAF ACC 25 AF/AMIC DET 2/PKA: Input Offeror's Proposed Hourly Rate without Fringe	Labor Category from Salary.com

JONES, CAMERON A CIV USAF ACC 25 AF/AMIC DET 2/PKA: Input equivalent Labor Category from Salary.com

	Median Annual Salary from Salary.com
JONES, CAMERON A CIV USAF ACC 25 AF/AMIC DET 2/PKA: Input Median Annual Salary from Salary.com	Hourly Base Rate from Salary.com	Median Salary - 5%	Proposed Hourly Wage Conforms
	Example Only	Sanitary Engineer	$35.00	Janitor II	$30,000.00	$16.74	$15.90	YES
	1	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	2	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	3	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	4	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	5	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	6	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	7	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	8	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	9	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	10	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	11	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	12	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	13	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	14	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	15	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	16	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	17	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	18	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	19	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	20	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	21	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	22	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	23	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	24	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	25	Input Labor Category	Input Rate	Input Labor Category	Input Salary	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
	Average Rate		ERROR:#DIV/0!

&"Times New Roman,Bold"&16***FOR EVALUATION PURPOSES ONLY***

***For Evaluation Purposes Only***

Escalation of Base Rates

Attachment 10 - "Floor" Base Hourly Rate Worksheet
		3.60%	3.60%	3.60%	3.60%
	Contractor's Labor Category

JONES, CAMERON A CIV USAF ACC 25 AF/AMIC DET 2/PKA: Input Offeror's Proposed Labor Category (Same information from Labor Categories Tab) Proposed Base Hourly Rate without fringe JONES, CAMERON A CIV USAF ACC 25 AF/AMIC DET 2/PKA: Input Offeror's Proposed Hourly Rate without Fringe (Same information from Labor Categories Tab)

Year 2	Year 3	Year 4	Year 5
Example Only	Sanitary Engineer	$35.00	$36.26	$37.57	$38.92	$40.32
1	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
2	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
3	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
4	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
5	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
6	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
7	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
8	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
9	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
10	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
11	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
12	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
13	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
14	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
15	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
16	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
17	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
18	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
19	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
20	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
21	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
22	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
23	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
24	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
25	Input Labor Category	Input Rate	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!	ERROR:#VALUE!
Average Rate		ERROR:#DIV/0!
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

JONES, CAMERON A CIV USAF ACC 25 AF/AMIC DET 2/PKA: Signature validating certification is required Place Date Here JONES, CAMERON A CIV USAF ACC 25 AF/AMIC DET 2/PKA: Date Required

Printed Name (Replace with Actual Name)	Date
Printed Position (Replace with Actual Position)
Printed Name of Company (Replace with Actual Name)

&"Times New Roman,Bold"&16***FOR EVALUATION PURPOSES ONLY***

*** For Evaluation Purposes Only***

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