HT001419R0017_Attachment_1_Compensation_&_Price_Matrix_rev_1.xlsx

XLSX spreadsheet 41 KB Posted Jul 19, 2019

Attached to: National Capital Region Pain Initiative (NCRPI)
Solicitation number: HT001419R0017
Issued by: Defense Health Agency

About this file

From the source

Attachment 1_Compensation & Price Matrix rev_1

View the file

Other files

File	Type	Posted
HT001419R001702.pdf	PDF	Jul 19, 2019
HT001419R001701.pdf	PDF	Jul 17, 2019
HT001419R0017.pdf	PDF	Jul 9, 2019
HT001419R0017_Attachment_1_Compensation_&_Price_Matrix.xlsx	XLSX spreadsheet	Jul 9, 2019
HT001419R0017_Attachment_2_PPQ_Template.pdf	PDF	Jul 9, 2019

On GovTribe

Work with this file

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

Tabs A, AA,AB,AC & AD:

All Rates, including benefits, must be based on hourly rates and not annual figures.

Compensation for health care providers (employees) shall not exceed $400,000 per 12 month year.

The offeror is responsible for doing the mathematical calculations, like adding the fringe benefits, calculating the percentage and the total salary, etc.

The offeror cannot change the order and name of the labor category specialties (column B on each of the TABs).

Productive Hrs.= total hours in a work year LESS vacation & holidays (e.g. 1,920 hours = 1 one full time equivelant [FTE] contractor employee for one year = 8 hrs/day x 5 days/wk for 48 wks productive hrs.)

Another way to think of productive hours is that they are hours actually worked and billed to the Govt. contract.

Costs associated with vacations and holidays are normally included in the fringe benefit rate, therefore the vacation/holiday associated costs are to be input into column F (Tabs A, AA,AB, AC & AD) for the purposes of this spreadsheet.

Tab B "Price":

Populate the Fully Burdened Hourly Rates for the Base Year and Option Periods (from Tabs A, AA, AB, AC & AD) into columns D, G, J, M & P respectively.

*** Verify the math is correctly computed.

A- Compensation Base Period

Period of Performance: 1 October 2019 - 30 September 2020

CLIN

LABOR CATEGORY

and

Level of Effort	Productive Hours	Base Salary (Hourly)	Health & Welfare	Fringe Benefits Percentage	Total base Salary +Fringe benefits (Hourly )	Total Billable Hourly Rate
	0001	Clinical Pharmacist; One (1) Full Time Equivelant (FTE)	1,920
	0002	Medical Clerk (1 FTE)	1,920
	0003	Integrative Medicine Physician (1 FTE)	1,920
	0004	Pain Nurse, RN (2 FTE)	3,840
	0005	Pain Physician, Anesthesiologist (1 FTE)	1,920
	0006	Senior Program Manager (1 FTE)	1,920
	0007	Integrative Medicine Nurse, RN (1 FTE)	1,920
	0008	Tele-Pain Nurse, RN (1 FTE)	1,920
	0009	Licensed Clinical Social Worker (LCSW)-Mind Body (1 FTE)	1,920
	0010	Contract Manpower Report					Not Separately	Priced

&"-,Bold"&18Compensation Plan&14 &"-,Regular"&11

AA-Compensation Year Period 1

Period of Performance: 1 October 2020 - 30 September 2021

CLIN

LABOR CATEGORY

and

Level of Effort	Productive Hours	Base Salary (Hourly)	Health & Welfare	Fringe Benefits Percentage	Total base Salary +Fringe benefits (Hourly )	Total Billable Hourly Rate
	1001	Clinical Pharmacist; One (1) Full Time Equivelant (FTE)	1,920
	1002	Medical Clerk (1 FTE)	1,920
	1003	Integrative Medicine Physician (1 FTE)	1,920
	1004	Pain Nurse, RN (2 FTE)	3,840
	1005	Pain Physician, Anesthesiologist (1 FTE)	1,920
	1006	Senior Program Manager (1 FTE)	1,920
	1007	Integrative Medicine Nurse, RN (1 FTE)	1,920
	1008	Tele-Pain Nurse, RN (1 FTE)	1,920
	1009	Licensed Clinical Social Worker (LCSW)-Mind Body (1 FTE)	1,920
	1010	Contract Manpower Report					Not Separately	Priced

AB-Compensation Option Year 2

Period of Performance: 1 October 2021 - 30 September 2022

CLIN

LABOR CATEGORY

and

Level of Effort	Productive Hours	Base Salary (Hourly)	Health & Welfare	Fringe Benefits Percentage	Total base Salary +Fringe benefits (Hourly )	Total Billable Hourly Rate
	2001	Clinical Pharmacist; One (1) Full Time Equivelant (FTE)	1,920
	2002	Medical Clerk (1 FTE)	1,920
	2003	Integrative Medicine Physician (1 FTE)	1,920
	2004	Pain Nurse, RN (2 FTE)	3,840
	2005	Pain Physician, Anesthesiologist (1 FTE)	1,920
	2006	Senior Program Manager (1 FTE)	1,920
	2007	Integrative Medicine Nurse, RN (1 FTE)	1,920
	2008	Tele-Pain Nurse, RN (1 FTE)	1,920
	2009	Licensed Clinical Social Worker (LCSW)-Mind Body (1 FTE)	1,920
	1010	Contract Manpower Report					Not Separately	Priced

AC-Compensation Option Year 3

Period of Performance: 1 October 2022 - 30 September 2023

CLIN

LABOR CATEGORY

and

Level of Effort	Productive Hours	Base Salary (Hourly)	Health & Welfare	Fringe Benefits Percentage	Total base Salary +Fringe benefits (Hourly )	Total Billable Hourly Rate
	3001	Clinical Pharmacist; One (1) Full Time Equivelant (FTE)	1,920
	3002	Medical Clerk (1 FTE)	1,920
	3003	Integrative Medicine Physician (1 FTE)	1,920
	3004	Pain Nurse, RN (2 FTE)	3,840
	3005	Pain Physician, Anesthesiologist (1 FTE)	1,920
	3006	Senior Program Manager (1 FTE)	1,920
	3007	Integrative Medicine Nurse, RN (1 FTE)	1,920
	3008	Tele-Pain Nurse, RN (1 FTE)	1,920
	3009	Licensed Clinical Social Worker (LCSW)-Mind Body (1 FTE)	1,920
	3010	Contract Manpower Report					Not Separately	Priced

AD-Compensation Option Year 4

Period of Performance: 1 October 2023 - 30 September 2024

CLIN

LABOR CATEGORY

and

Level of Effort	Productive Hours	Base Salary (Hourly)	Health & Welfare	Fringe Benefits Percentage	Total base Salary +Fringe benefits (Hourly )	Total Billable Hourly Rate
	4001	Clinical Pharmacist; One (1) Full Time Equivelant (FTE)	1,920
	4002	Medical Clerk (1 FTE)	1,920
	4003	Integrative Medicine Physician (1 FTE)	1,920
	4004	Pain Nurse, RN (2 FTE)	3,840
	4005	Pain Physician, Anesthesiologist (1 FTE)	1,920
	4006	Senior Program Manager (1 FTE)	1,920
	4007	Integrative Medicine Nurse, RN (1 FTE)	1,920
	4008	Tele-Pain Nurse, RN (1 FTE)	1,920
	4009	Licensed Clinical Social Worker (LCSW)-Mind Body (1 FTE)	1,920
	4010	Contract Manpower Report					Not Separately	Priced

B- Price

CLIN

LABOR CATEGORY

and

Level of Effort	# of Hours
(Base Period)	Total Billable Hourly Rate (Base Period)	Total Cost (Base Period)	# of Hours, (Option Year 1)	Total Billable Hourly Rate
(Option Period 1)	Total Cost (Option Year 1)	# of Hours, (Option Year 2)	Total Billable Hourly Rate (Option Year 2)	Total Cost
(Option Year 2)	# of Hours,
(Option Year 3)	Total Billable Hourly Rate
(Option Year 3)	Total Cost
(Option Year 3)	# of Hours,
(Option Year 4)	Total Billable Hourly Rate
(Option Year 4)	Total Cost
(Option Year 4)	FAR Clause 52.217-8 6-month Extension For Evaluation Purposes Only	Total Sum of Costs
	X001	Clinical Pharmacist; One (1) Full Time Equivelant (FTE)	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	$ - 0	$ - 0
	X002	Medical Clerk (1 FTE)	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	$ - 0	$ - 0
	X003	Integrative Medicine Physician (1 FTE)	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	$ - 0	$ - 0
	X004	Pain Nurse, RN (2 FTE)	3,840	$ - 0	$ - 0	3,840	$ - 0	$ - 0	3,840	$ - 0	$ - 0	3,840	$ - 0	$ - 0	3,840	$ - 0	$ - 0	$ - 0	$ - 0
	X005	Pain Physician, Anesthesiologist (1 FTE)	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	$ - 0	$ - 0
	X006	Senior Program Manager (1 FTE)	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	$ - 0	$ - 0
	X007	Integrative Medicine Nurse, RN (1 FTE)	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	$ - 0	$ - 0
	X008	Tele-Pain Nurse, RN (1 FTE)	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	$ - 0	$ - 0
	X009	Licensed Clinical Social Worker (LCSW)-Mind Body (1 FTE)	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	1,920	$ - 0	$ - 0	$ - 0	$ - 0
	X0010	Contract Manpower Report	6,400	ERROR:#REF!	ERROR:#REF!	7,680	Priced	ERROR:#VALUE!	7,680	Priced	ERROR:#VALUE!	7,680	Priced	ERROR:#VALUE!				Not Separately	Priced
																			ERROR:#VALUE!	Total Price

File details come from the government source that posted it.