Attachment 002 Compensation_Price Matrix_Revision 02.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
Hospitality Concierge Customer Service Representatives Federal contract opportunity
Solicitation number
HT001419R0021
Issued by
Defense Health Agency

About this file

This document contains a compensation matrix and price template for a non-personal services contract solicitation. The solicitation seeks to provide various types of Hospitality Customer Service Representatives for multiple departments at Walter Reed National Military Medical Center, Fort Belvoir Community Hospital, and Joint Base Andrews. Services include concierge services, customer service representatives, patient transport, and environment of care staff. Offerors must complete the templates providing fully burdened hourly rates and total proposed prices for base and option years. The minimum staffing includes six customer service representatives and one environment of care rover at WRNMMC. The Defense Health Agency is the contracting agency.

View the file

Other files for this federal contract opportunity

Other files attached to Hospitality Concierge Customer Service Representatives, newest first.
File Type Posted
HT001419R0021-0003.pdf PDF
Labor Category Minimum Compensation Matrix (Attachment 2) Revision 2.xlsx XLSX spreadsheet
HT001419R0021-02.pdf PDF
SOLICITATION AMENDMENT HT001419R00210001.pdf PDF
Attachment 3 - Past Performance Questionnaire.PDF PDF
Attachment 2 - Compensation and Price Matrix.xlsx XLSX spreadsheet
SOLICITATION HT001419R0021.pdf PDF

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

Text version

Instructions

Only Enter Data into the Yellow Colored Cells. Your Total Evaluated Price will be shown in the Orange Colored Cells on Tab B.
Tabs A (Compensation Matrix) and B (Price)
The Offeror is responsible for doing the Mathematical Calculations, like adding the fringe benefits, calculating the total Billable Rates and the total salary, etc.
All Rates, including benefits, must be based on hourly rates and not annual figures.
Compensation for one full time equivelant (FTE) Contractor Employee shall not exceed $400,000 per year.
The offeror cannot change the order and name of the specialties (column B).
Productive Hrs.= total hours in a work year LESS vacation & holidays (e.g. 1,920 hours = 1 one full time contractor employee for one year = 8 hrs/day x 5 days/wk for 48 wks productive hrs.) Billable/invoiced hours.
'Another way to think of productive hours is that they are hours actually worked and billed to the Govt. contract.
Tab B "Price":
Populate the Fully Burdened Hourly Rates for the Base Year and Option Periods (Tab A, Column T; Tab B, Columns E,H,K,N and Q).
Verify your math is correctly computed.
* Notes: Customer Service Representative (CSR) is applicable to Wage Determination Nos.: 2015-4269 Revision 12 & 2015-4281 Revision 16
Essential personnel,IAW DFARS clause 252.237-7023 including the program manager and the minimum staffing crew of 6 FTE Customer Services Representatives and 1 FTE Environment of Care Rover at WRNMMC
CLIN X011 (CSR at JBA) is identifed as an Optional requirement at this time

A - Compensation Matrix

COMPENSATION MATRIX HOSPITALITY
OFFER NAME:
TOTAL EVALUATED PRICE:
CLINSJOB TITLESAnnual Cost of Living RaiseHourly Base Salary (Direct Labor)FTE'SAnnual Hours (Billable Hours)Hours Off / NAAnnual Base Salary (Direct Labor)FICAFICA Above $110,000.00FUTASUTAOverhead and Security Clearance CostsHealth / Life InsuranceWorkman's CompensationAnnual Salary Fully LoadedHourly Rate Fully Loaded (Less G&A, OH and Profit)Fully Loaded Hourly Salary with G&A, OH and Profit AddedFully Loaded Annual Salary with G&A and Profit Added (F x R)
BASE YEAR
0001Program Manager (@ WRNMMC)**0$ 54.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0002Customer Service Representative (CSR) III* Supervisor (@ WRNMMC)$ 24.9547,6800$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0003Concierge Customer Service Representatives (CSR) I* or II* (@ WRNMMC)**$ 22.344178,7320$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0004CSR III* CDO Desk (@ WRNMMC)$ 23.84917,5200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0005Patient Transport Supervisor (@ WRNMMC)$ 40.7811,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0006Patient Transport Dispatch (@ WRNMMC)$ 23.84510,2900$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0007Patient Transport (@ WRNMMC)$ 22.341936,4620$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0008Environment of Care Rover Supervisor (@ WRNMMC)**$ 28.3411,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0009Environment of Care Rover (@ WRNMMC)$ 22.34158,7600$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0010Concierge Greeters (@ FBCH)$ 23.841223,0400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0011OPTION: Concierge Customer Service Representative III* (@ JBA)$ 23.8411,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL BASE YEAR$0.00
OPTION YEAR 01
1001Program Manager (@ WRNMMC)**0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
1002Customer Service Representative (CSR) III* Supervisor (@ WRNMMC)0.00%$0.0047,6800$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
1003Concierge Customer Service Representatives (CSR) I* or II* (@ WRNMMC)**0.00%$0.004178,7320$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
1004CSR III* CDO Desk (@ WRNMMC)0.00%$0.00917,5200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
1005Patient Transport Supervisor (@ WRNMMC)0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
1006Patient Transport Dispatch (@ WRNMMC)0.00%$0.00510,2900$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
1007Patient Transport (@ WRNMMC)0.00%$0.001936,4620$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
1008Environment of Care Rover Supervisor (@ WRNMMC)**0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
1009Environment of Care Rover (@ WRNMMC)0.00%$0.00158,7600$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
1010Concierge Greeters (@ FBCH)0.00%$0.001223,0400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
1011OPTION: Concierge Customer Service Representative III* (@ JBA)0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL OPTION YEAR 01$0.00
OPTION YEAR 02
2001Program Manager (@ WRNMMC)**0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2002Customer Service Representative (CSR) III* Supervisor (@ WRNMMC)0.00%$0.0047,6800$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2003Concierge Customer Service Representatives (CSR) I* or II* (@ WRNMMC)**0.00%$0.004178,7320$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2004CSR III* CDO Desk (@ WRNMMC)0.00%$0.00917,5200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2005Patient Transport Supervisor (@ WRNMMC)0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2006Patient Transport Dispatch (@ WRNMMC)0.00%$0.00510,2900$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2007Patient Transport (@ WRNMMC)0.00%$0.001936,4620$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2008Environment of Care Rover Supervisor (@ WRNMMC)**0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2009Environment of Care Rover (@ WRNMMC)0.00%$0.00158,7600$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2010Concierge Greeters (@ FBCH)0.00%$0.001223,0400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2011OPTION: Concierge Customer Service Representative III* (@ JBA)0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL OPTION YEAR 02$0.00
OPTION YEAR 03
3001Program Manager (@ WRNMMC)**0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
3002Customer Service Representative (CSR) III* Supervisor (@ WRNMMC)0.00%$0.0047,6800$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
3003Concierge Customer Service Representatives (CSR) I* or II* (@ WRNMMC)**0.00%$0.004178,7320$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
3004CSR III* CDO Desk (@ WRNMMC)0.00%$0.00917,5200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
3005Patient Transport Supervisor (@ WRNMMC)0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
3006Patient Transport Dispatch (@ WRNMMC)0.00%$0.00510,2900$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
3007Patient Transport (@ WRNMMC)0.00%$0.001936,4620$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
3008Environment of Care Rover Supervisor (@ WRNMMC)**0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
3009Environment of Care Rover (@ WRNMMC)0.00%$0.00158,7600$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
3010Concierge Greeters (@ FBCH)0.00%$0.001223,0400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
3011OPTION: Concierge Customer Service Representative III* (@ JBA)0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
TOTALOPTION YEAR 03$0.00
OPTION YEAR 04
4001Program Manager (@ WRNMMC)**0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4002Customer Service Representative (CSR) III* Supervisor (@ WRNMMC)0.00%$0.0047,6800$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4003Concierge Customer Service Representatives (CSR) I* or II* (@ WRNMMC)**0.00%$0.004178,7320$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4004CSR III* CDO Desk (@ WRNMMC)0.00%$0.00917,5200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4005Patient Transport Supervisor (@ WRNMMC)0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4006Patient Transport Dispatch (@ WRNMMC)0.00%$0.00510,2900$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4007Patient Transport (@ WRNMMC)0.00%$0.001936,4620$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4008Environment of Care Rover Supervisor (@ WRNMMC)**0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4009Environment of Care Rover (@ WRNMMC)0.00%$0.00158,7600$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4010Concierge Greeters (@ FBCH)0.00%$0.001223,0400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4011OPTION: Concierge Customer Service Representative III* (@ JBA)0.00%$0.0011,9200$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
TOTAL OPTION YEAR 04$0.00
* Notes: Customer Service Representative (CSR) is applicable to Wage Determination Nos.: 2015-4269 Revision 12 & 2015-4281 Revision 16
Essential personnel,IAW DFARS clause 252.237-7023 including the program manager and the minimum staffing crew of 6 FTE Customer Services Representatives and 1 FTE Environment of Care Rover at WRNMMC
CLIN X011 (CSR at JBA) is identifed as an Optional requirement at this time

B - Price

Offeror Name
Total Evaluated Price$ - 0
CLINLabor Category# 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 (Q/2)
X001Program Manager (@ WRNMMC)**1920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 0$ - 0
X002Customer Service Representative (CSR) III* Supervisor (@ WRNMMC)7680$ - 0$ - 07680$ - 0$ - 07680$ - 0$ - 07680$ - 0$ - 07680$ - 0$ - 0$ - 0
X003Concierge Customer Service Representatives (CSR) I* or II* (@ WRNMMC)**78732$ - 0$ - 078732$ - 0$ - 078732$ - 0$ - 078732$ - 0$ - 078732$ - 0$ - 0$ - 0
X004CSR III* CDO Desk (@ WRNMMC)17520$ - 0$ - 017520$ - 0$ - 017520$ - 0$ - 017520$ - 0$ - 017520$ - 0$ - 0$ - 0
X005Patient Transport Supervisor (@ WRNMMC)1920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 0$ - 0
X006Patient Transport Dispatch (@ WRNMMC)10290$ - 0$ - 010290$ - 0$ - 010290$ - 0$ - 010290$ - 0$ - 010290$ - 0$ - 0$ - 0
X007Patient Transport (@ WRNMMC)36462$ - 0$ - 036462$ - 0$ - 036462$ - 0$ - 036462$ - 0$ - 036462$ - 0$ - 0$ - 0
X008Environment of Care Rover Supervisor (@ WRNMMC)**1920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 0$ - 0
X009Environment of Care Rover (@ WRNMMC)8760$ - 0$ - 08760$ - 0$ - 08760$ - 0$ - 08760$ - 0$ - 08760$ - 0$ - 0$ - 0
X010Concierge Greeters (@ FBCH)23040$ - 0$ - 023040$ - 0$ - 023040$ - 0$ - 023040$ - 0$ - 023040$ - 0$ - 0$ - 0
X011OPTION: Concierge Customer Service Representative III* (@ JBA)1920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 0$ - 0
Total Yearly Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
* Notes: Customer Service Representative (CSR) is applicable to Wage Determination Nos.: 2015-4269 Revision 12 & 2015-4281 Revision 16
Essential personnel,IAW DFARS clause 252.237-7023 including the program manager and the minimum staffing crew of 6 FTE Customer Services Representatives and 1 FTE Environment of Care Rover at WRNMMC
CLIN X011 (CSR at JBA) is identifed as an Optional requirement at this time

File details come from the government source that posted it. Updated .