RFP Attachment 7 Price Matrix - Compensation REV 6-1.xlsx

XLSX spreadsheet 59 KB Posted Jun 1, 2022

Attached to: Credentialing Branch Service
Solicitation number: W81K04-22-R-0017
Issued by: Department of the Army Medical Command

View the file

Other files

File	Type	Posted
W81K04-22-R-0017-0003.pdf	PDF	Jun 1, 2022
RFP Questions and Answers W81K04-22-R-0017.xlsx	XLSX spreadsheet	May 25, 2022
RFQ Questions and Answeres W81K04-22-R-0017 Credentialing.xlsx	XLSX spreadsheet	May 25, 2022
52.219-14 Limitations of Subcontracting.docx	DOCX document	May 25, 2022
W81K04-22-R-0017-0002.pdf	PDF	May 25, 2022
RFP Attachment 7 Price Matrix - Compensation REV.xlsx	XLSX spreadsheet	May 25, 2022
W81K04-22-R-0017 -0001.pdf	PDF	May 10, 2022
W81K04-22-R-0017 Credentialing Services.pdf	PDF	May 3, 2022
Attachment 9 DD254 Credentialing.pdf	PDF	May 3, 2022
QASP Attachment 3 Nonconformance Report Worksheet.pdf	PDF	May 3, 2022
Attachment 2 ARCCC Charter October 2021.pdf	PDF	May 3, 2022
RFP Attachment 6 PAQ.docx	DOCX document	May 3, 2022
Exhibit D WD 2015-4471 Rev 21 dated 15 Mar 2022.pdf	PDF	May 3, 2022
RFP Attachment 1 Contractor Questions Sheet.xlsx	XLSX spreadsheet	May 3, 2022
RFP Attachment 7 Price Matrix - Compensation.xlsx	XLSX spreadsheet	May 3, 2022
Attachment 7 DHA 6025.13.pdf	PDF	May 3, 2022
Attachment 6 AWMS Engineering Plan.pdf	PDF	May 3, 2022
Attachment 4 NPPR Charter.pdf	PDF	May 3, 2022
Attachment 5 APMC-CB SOP MAR 2022.pdf	PDF	May 3, 2022
Attachment 8 DODi 5000.02.pdf	PDF	May 3, 2022
Attachment 3 ARCAP Charter Mar 22.pdf	PDF	May 3, 2022
RFP Attachment 5 PAQ Cover Ltr .docx	DOCX document	May 3, 2022

Show all 22

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

INSTRUCTIONS:

1. Contract Service Provider Rates. Offerors shall propose a fully burdened hourly rate for each labor category. The proposed labor rates provided in the price matrix will be incorporated into the resultant contract. To be a complete price proposal in accordance with the solicitatio addendum 52.212-1 offerors shall propose hourly rates for the base period and each option year. To build a fully burdened hourly rate offerors shall start with the base hourly rate in the 'Compensaton' tab for the base period and each option year. Elements completed in the 'Compensation' tab will result in the offeror's full burdened hourly rate. Offerors shall complete the "Price Matrix/Compensation Plan" spreadsheet by following the directions below.

2. Headings. Offerors shall insert their company name, cage code and due date on the top left corner of each tab.

3. Tabs. The Price Matrix/Compensation Plan spreadsheet is made up of 'CLIN Structure', 'Compensation Year' for the base period and each option year and the 'Summary' tab. The tabs are lined by cells that are pre-populated with formulas. DO NOT Change.

4. Compensation. For purposes of evaluating compensation, offerors shall propose labor rates based upon 2080 hours as a full time equivalent. Failure to provide pricing based upon 2080 hours may result in the proposal being deemed unacceptable and the offer being rejected for consideration for award. It is understood that the 2080 hours representing 1 full time equivalent (FTE) will also contain allowances for sick leave, vacation, other types of leave, etc. The compensation tabs are comprised of elements of the offeror’s compensation plan. Although the elements provided are the most common elements, the government understands that offerors may/may not provide certain elements in the compensation tab. If this is the case, leave the element blank. The offeror shall describe other direct costs.

5. Summary Tab. Contractor Manpower Reporting (CMR). CMR is Not Separately Priced (NSP) and will be included as a separate NSP CLIN on any resultant contract. CMR is marked NSP on the summary tab.

6. Additional Documentation. The offeror shall provide and include documentation along with this attachment to support the data entered in the Compensation Year tabs. This data shall include but not be limited to:

a. Description of the base data used to estimate the base labor rate

b. Explanation of why the offeror chose to use this base data for the proposal

c. Description of adjustment, if any, to the base data and why adjustments were appropriate

d. Narrative to fully describe each element and benefit offered

Instructions W81K04-22-R-0017 Attachment 2

CLIN Structure

CLIN	Description	Number of FTEs	Monthly Rate Per FTE	Monthly Rate	6 months + 1 Month Phase In	CLIN	Description	Number of FTEs	Monthly Rate Per FTE	Monthly Rate	Yearly Rate	CLIN	Description	Number of FTEs	Monthly Rate Per FTE	Monthly Rate	Yearly Rate	CLIN	Description	Number of FTEs	Monthly Rate Per FTE	Monthly Rate	Yearly Rate	CLIN	Description	Number of FTEs	Monthly Rate Per FTE	Monthly Rate	Yearly Rate
0001	Credentialing Program Management					1001	Credentialing Program Management					2001	Credentialing Program Management					3001	Credentialing Program Management					4001	Credentialing Program Management
	Program Manager	1.00		$ - 0	$ - 0		Program Manager	1.00		$ - 0	$ - 0		Program Manager	1.00		$ - 0	$ - 0		Program Manager	1.00		$ - 0	$ - 0		Program Manager	1.00		$ - 0	$ - 0
	Project Lead	4.00		$ - 0	$ - 0		Project Lead	4.00		$ - 0	$ - 0		Project Lead	4.00		$ - 0	$ - 0		Project Lead	4.00		$ - 0	$ - 0		Project Lead	4.00		$ - 0	$ - 0
	Total			$ - 0	$ - 0		Total			$ - 0	$ - 0		Total			$ - 0	$ - 0		Total			$ - 0	$ - 0		Total			$ - 0	$ - 0

0002	Credentialing Analysis				1002	Credentialing Analysis				2002	Credentialing Analysis				3002	Credentialing Analysis				4002	Credentialing Analysis
	Subject Matter Expert/Compliance Officer	1.00	$ - 0	$ - 0		Subject Matter Expert/Compliance Officer	1.00	$ - 0	$ - 0		Subject Matter Expert/Compliance Officer	1.00	$ - 0	$ - 0		Subject Matter Expert/Compliance Officer	1.00	$ - 0	$ - 0		Subject Matter Expert/Compliance Officer	1.00	$ - 0	$ - 0
	Management Analyst/Quality Control Evaluator	3.00	$ - 0	$ - 0		Management Analyst/Quality Control Evaluator	3.00	$ - 0	$ - 0		Management Analyst/Quality Control Evaluator	3.00	$ - 0	$ - 0		Management Analyst/Quality Control Evaluator	3.00	$ - 0	$ - 0		Management Analyst/Quality Control Evaluator	3.00	$ - 0	$ - 0
	Total		$ - 0	$ - 0		Total		$ - 0	$ - 0		Total		$ - 0	$ - 0		Total		$ - 0	$ - 0		Total		$ - 0	$ - 0

0003	Credentialing IT System Support				1003	Credentialing IT System Support				2003	Credentialing IT System Support				3003	Credentialing IT System Support				4003	Credentialing IT System Support
	Sr Information Technology Specialist	1.00	$ - 0	$ - 0		Sr Information Technology Specialist	1.00	$ - 0	$ - 0		Sr Information Technology Specialist	1.00	$ - 0	$ - 0		Sr Information Technology Specialist	1.00	$ - 0	$ - 0		Sr Information Technology Specialist	1.00	$ - 0	$ - 0
	Software Developer/Application Programmer	1.00	$ - 0	$ - 0		Software Developer/Application Programmer	1.00	$ - 0	$ - 0		Software Developer/Application Programmer	1.00	$ - 0	$ - 0		Software Developer/Application Programmer	1.00	$ - 0	$ - 0		Software Developer/Application Programmer	1.00	$ - 0	$ - 0
	Database Administrator and Architect	1.00	$ - 0	$ - 0		Database Administrator and Architect	1.00	$ - 0	$ - 0		Database Administrator and Architect	1.00	$ - 0	$ - 0		Database Administrator and Architect	1.00	$ - 0	$ - 0		Database Administrator and Architect	1.00	$ - 0	$ - 0
	Computer Network Support Help Desk Tier 1&2	1.00	$ - 0	$ - 0		Computer Network Support Help Desk Tier 1&2	1.00	$ - 0	$ - 0		Computer Network Support Help Desk Tier 1&2	1.00	$ - 0	$ - 0		Computer Network Support Help Desk Tier 1&2	1.00	$ - 0	$ - 0		Computer Network Support Help Desk Tier 1&2	1.00	$ - 0	$ - 0
	Total		$ - 0	$ - 0		Total		$ - 0	$ - 0		Total		$ - 0	$ - 0		Total		$ - 0	$ - 0		Total		$ - 0	$ - 0

0004 Computer Network Support Help Desk Tier 1&2 Weekend Support 1.00 $ - 0 $ - 0 1004 Computer Network Support Help Desk Tier 1&2 Weekend Support 1.00 $ - 0 $ - 0 2004 Computer Network Support Help Desk Tier 1&2 Weekend Support 1.00 $ - 0 $ - 0 3004 Computer Network Support Help Desk Tier 1&2 Weekend Support 1.00 $ - 0 $ - 0 4004 Computer Network Support Help Desk Tier 1&2 Weekend Support 1.00 $ - 0 $ - 0

0005 Technical Writer 1.00 $ - 0 $ - 0 1005 Technical Writer 1.00 $ - 0 $ - 0 2005 Technical Writer 1.00 $ - 0 $ - 0 3005 Technical Writer 1.00 $ - 0 $ - 0 4005 Technical Writer 1.00 $ - 0 $ - 0

0006	Credentialing Support Services				1006	Credentialing Support Services				2006	Credentialing Support Services				3006	Credentialing Support Services				4006	Credentialing Support Services
	Credentialing Specialists	33.00	$ - 0	$ - 0		Credentialing Specialists	33.00	$ - 0	$ - 0		Credentialing Specialists	33.00	$ - 0	$ - 0		Credentialing Specialists	33.00	$ - 0	$ - 0		Credentialing Specialists	33.00	$ - 0	$ - 0

0007	Credentialing Support Services Weekend				1007	Credentialing Support Services Weekend				2007	Credentialing Support Services Weekend				3007	Credentialing Support Services Weekend				4007	Credentialing Support Services Weekend
	Credentialing Specialists Weekend	1.00	$ - 0	$ - 0		Credentialing Specialists Weekend	1.00	$ - 0	$ - 0		Credentialing Specialists Weekend	1.00	$ - 0	$ - 0		Credentialing Specialists Weekend	1.00	$ - 0	$ - 0		Credentialing Specialists Weekend	1.00	$ - 0	$ - 0

0008 CMR 1.00 NSP $0.00 $0.00 1008 CMR 1.00 NSP $0.00 2008 CMR 1.00 NSP $0.00 $0.00 3008 CMR 1.00 NSP $0.00 $0.00 4008 CMR 1.00 NSP $0.00 $0.00

0009	Phase In	1
	Total		$0.00	$0.00	Total	$0.00	$0.00	Total	$0.00	$0.00	Total	$0.00	$0.00	Total	$0.00	$0.00

W81K04-22-R-0017

Base Period Labor Category BASE HOURLY RATE BASE

ANNUAL

SALARY	ANNUAL
HEALTH	ANNUAL
MEDICARE	ANNUAL
FICA	ANNUAL
FUTA	ANNUAL
SUTA	ANNUAL

WORKER

COMP	ANNUAL
HOLIDAY	ANNUAL
PTO	ANNUAL
CME	ANNUAL

RETIRE-

MENT	OTHER
ANNUAL BENEFITS	TOTAL

ANNUAL

FRINGE ANNUAL

FRINGE %

BASE ANNUAL

SALARY + FRINGE BENEFITS	ANNUAL
PROFIT, G&A, and OTHER	TOTAL ANNUAL SALARY (Including Profit, G&A and Other
	Program Manager	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Project Lead	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Subject Matter Expert/Compliance Officer	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Management Analyst/Quality Control Evaluator	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Sr Information Technology Specialist	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Software Developer/Application Programmer	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Database Administrator and Architect	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Computer Network Support Help Desk Tier 1&2	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Computer Network Support Help Desk Tier 1&2 Weekend Spt	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Technical Writer	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Credentialing Specialists	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Credentailing Specialists Weekend Support	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0

&"-,Bold"&14 Compensation Plan Credentialing Branch Support Services Base Period 19 September 2022 - 18 March2023 W81K04-22-R-0017

Page &P of &N

Option Year 1 Labor Category BASE HOURLY RATE BASE

ANNUAL

SALARY	ANNUAL
HEALTH	ANNUAL
MEDICARE	ANNUAL
FICA	ANNUAL
FUTA	ANNUAL
SUTA	ANNUAL

WORKER

COMP	ANNUAL
HOLIDAY	ANNUAL
PTO	ANNUAL
CME	ANNUAL

RETIRE-

MENT	OTHER
ANNUAL BENEFITS	TOTAL

ANNUAL

FRINGE ANNUAL

FRINGE %

BASE ANNUAL

SALARY + FRINGE BENEFITS	ANNUAL
PROFIT, G&A, and OTHER	TOTAL ANNUAL SALARY (Including Profit, G&A and Other
	Program Manager	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Project Lead	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Subject Matter Expert/Compliance Officer	$ - 0	ERROR:#DIV/0!	$ - 0
	Management Analyst/Quality Control Evaluator	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Sr Information Technology Specialist	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Software Developer/Application Programmer	$ - 0	ERROR:#DIV/0!	$ - 0
	Database Administrator and Architect	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Computer Network Support Help Desk Tier 1&2	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Computer Network Support Help Desk Tier 1&2 Weekend Spt	$ - 0	ERROR:#DIV/0!	$ - 0
	Technical Writer	$ - 0	ERROR:#DIV/0!	$ - 0
	Credentialing Specialists	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Credentialing Specialists Weekend Support	$ - 0	ERROR:#DIV/0!	$ - 0

Compensation Plan Credentialing Branch Support Services Option Yr 1 19 March 2023 - 18 March2024 W81K04-22-R-0017

Option Year 2 Labor Category BASE HOURLY RATE BASE

ANNUAL

SALARY	ANNUAL
HEALTH	ANNUAL
MEDICARE	ANNUAL
FICA	ANNUAL
FUTA	ANNUAL
SUTA	ANNUAL

WORKER

COMP	ANNUAL
HOLIDAY	ANNUAL
PTO	ANNUAL
CME	ANNUAL

RETIRE-

MENT	OTHER
ANNUAL BENEFITS	TOTAL

ANNUAL

FRINGE ANNUAL

FRINGE %

BASE ANNUAL

SALARY + FRINGE BENEFITS	ANNUAL
PROFIT, G&A, and OTHER	TOTAL ANNUAL SALARY (Including Profit, G&A and Other
	Program Manager	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Project Lead	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Subject Matter Expert/Compliance Officer	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Management Analyst/Quality Control Evaluator	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Sr Information Technology Specialist	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Software Developer/Application Programmer	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Database Administrator and Architect	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Computer Network Support Help Desk Tier 1&2	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Computer Network Support Help Desk Tier 1&2 Weekend Spt	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Technical Writer	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Credentialing Specialists	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Credentialing Specialists Weekend Support	$ - 0	ERROR:#DIV/0!	$ - 0

Compensation Plan Credentialing Branch Support Services Option Yr 2 19 March 2024 - 18 March2025 W81K04-22-R-0017

Option Year 3 Labor Category BASE HOURLY RATE BASE

ANNUAL

SALARY	ANNUAL
HEALTH	ANNUAL
MEDICARE	ANNUAL
FICA	ANNUAL
FUTA	ANNUAL
SUTA	ANNUAL

WORKER

COMP	ANNUAL
HOLIDAY	ANNUAL
PTO	ANNUAL
CME	ANNUAL

RETIRE-

MENT	OTHER
ANNUAL BENEFITS	TOTAL

ANNUAL

FRINGE ANNUAL

FRINGE %

BASE ANNUAL

SALARY + FRINGE BENEFITS	ANNUAL
PROFIT, G&A, and OTHER	TOTAL ANNUAL SALARY (Including Profit, G&A and Other					Compensation Plan
	Program Manager	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0		Credentialing Branch Support Services
	Project Lead	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0		Option Yr 2 19 March 2024 - 18 March2025
	Subject Matter Expert/Compliance Officer	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Management Analyst/Quality Control Evaluator	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Sr Information Technology Specialist	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Software Developer/Application Programmer	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Database Administrator and Architect	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Computer Network Support Help Desk Tier 1&2	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Computer Network Support Help Desk Tier 1&2 Weekend Spt	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Technical Writer	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Credentialing Specialists	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Credentialing Specialists Weekend Support	$ - 0	ERROR:#DIV/0!	$ - 0

Compensation Plan Credentialing Branch Support Services Option Yr 3 19 March 2025 - 18 March2026 W81K04-22-R-0017

Option Year 4 Labor Category BASE HOURLY RATE BASE

ANNUAL

SALARY	ANNUAL
HEALTH	ANNUAL
MEDICARE	ANNUAL
FICA	ANNUAL
FUTA	ANNUAL
SUTA	ANNUAL

WORKER

COMP	ANNUAL
HOLIDAY	ANNUAL
PTO	ANNUAL
CME	ANNUAL

RETIRE-

MENT	OTHER
ANNUAL BENEFITS	TOTAL

ANNUAL

FRINGE ANNUAL

FRINGE %

BASE ANNUAL

SALARY + FRINGE BENEFITS	ANNUAL
PROFIT, G&A, and OTHER	TOTAL ANNUAL SALARY (Including Profit, G&A and Other
	Program Manager	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Project Lead	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Subject Matter Expert/Compliance Officer	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Management Analyst/Quality Control Evaluator	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Sr Information Technology Specialist	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Software Developer/Application Programmer	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Database Administrator and Architect	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Computer Network Support Help Desk Tier 1&2	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Computer Network Support Help Desk Tier 1&2 Weekend Support	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Technical Writer	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Credentialing Specialists	$ - 0	ERROR:#DIV/0!	$ - 0	$ - 0
	Credentialing Specialists Weekend Support	$ - 0	ERROR:#DIV/0!	$ - 0

Compensation Plan Credentialing Branch Support Services Option Yr 4 19 March 2026 - 18 March2027 W81K04-22-R-0017

Summary

Credentialing Support Services
Base Period	$ - 0
Option Year 1	$ - 0
Option Year 2	$ - 0
Option Year 3	$ - 0
Option Year 4	$ - 0
Total	$ - 0

&K000000Price Summary W81K04-22-R-0017

File details come from the government source that posted it. Updated Jun 1, 2022.