Attachment 2 - Compensation and Price Matrix.xlsx

XLSX spreadsheet 22 KB Posted

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

About this file

This compensation matrix and price proposal template is for a non-personal services contract to provide various hospital concierge customer service representatives at multiple military medical facilities. Services include program management, customer service, patient transport, environmental monitoring, and facility greeters. The contract will have a one-year base period and four one-year options periods. Labor categories, hours, and fully loaded rates have been provided for offerors to complete price proposals for evaluation. The solicitation number is HT001419R0021 and was issued by the Defense Health Agency to support Walter Reed National Military Medical Center, Fort Belvoir Community Hospital, and Joint Base Andrews.

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
Attachment 002 Compensation_Price Matrix_Revision 02.xlsx XLSX spreadsheet
HT001419R0021-02.pdf PDF
SOLICITATION AMENDMENT HT001419R00210001.pdf PDF
Attachment 3 - Past Performance Questionnaire.PDF PDF
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

Sheet1

COMPENSATION MATRIX HOSPITALITY
OFFER NAME:
TOTAL EVALUATED PRICE:
CLINSJOB TITLESAnnual Cost of Living RaiseBase Salary (Direct Labor)FTE'SAnnual HoursHours Off / NAAnnual Base Salary (Direct Labor)FICAFICA Above $110,000.00FUTASUTAOverhead and Security Clearance CostsHealth / Life InsuranceWorkman's CompensationAnnual Salary Fully LoadedHourly Rate Fully LoadedFully Loaded Annual Salary of All FTEsFully Loaded Hourly Salary with G&A and Profit AddedFully Loaded Annual Salary with G&A and Profit Added
BASE YEAR
0001Program Manager (WRNMMC)0.00%$0.00119200$0.00$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) Supervisor (WRNMMC)0.00%$0.00476800$0.00$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 ( WRNMMC)0.00%$0.0041787320$0.00$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)0.00%$0.009175200$0.00$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)0.00%$0.00119200$0.00$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)0.00%$0.005102900$0.00$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)0.00%$0.0019364620$0.00$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)0.00%$0.00119200$0.00$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)0.00%$0.001587600$0.00$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)0.00%$0.0012230400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0011Concierge Customer Service Representative (JBA)0.00%$0.00119200$0.00$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.00119200$0.00$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) Supervisor (WRNMMC)0.00%$0.00476800$0.00$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 ( WRNMMC)0.00%$0.0041787320$0.00$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.009175200$0.00$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.00119200$0.00$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.005102900$0.00$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.0019364620$0.00$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.00119200$0.00$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.001587600$0.00$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.0012230400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
1011Concierge Customer Service Representative (JBA)0.00%$0.00119200$0.00$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.00119200$0.00$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) Supervisor (WRNMMC)0.00%$0.00476800$0.00$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 ( WRNMMC)0.00%$0.0041787320$0.00$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.009175200$0.00$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.00119200$0.00$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.005102900$0.00$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.0019364620$0.00$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.00119200$0.00$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.001587600$0.00$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.0012230400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
2011Concierge Customer Service Representative (JBA)0.00%$0.00119200$0.00$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.00119200$0.00$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) Supervisor (WRNMMC)0.00%$0.00476800$0.00$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 ( WRNMMC)0.00%$0.0041787320$0.00$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.009175200$0.00$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.00119200$0.00$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.005102900$0.00$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.0019364620$0.00$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.00119200$0.00$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.001587600$0.00$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.0012230400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
3011Concierge Customer Service Representative (JBA)0.00%$0.00119200$0.00$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.00119200$0.00$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) Supervisor (WRNMMC)0.00%$0.00476800$0.00$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 ( WRNMMC)0.00%$0.0041787320$0.00$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.009175200$0.00$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.00119200$0.00$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.005102900$0.00$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.0019364620$0.00$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.00119200$0.00$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.001587600$0.00$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.0012230400$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
4011Concierge Customer Service Representative (JBA)0.00%$0.00119200$0.00$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

Sheet2

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
X001Program Manager (WRNMMC)1920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 0$ - 0
X002Customer Service Representative (CSR) Supervisor (WRNMMC)7680$ - 0$ - 07680$ - 0$ - 07680$ - 0$ - 07680$ - 0$ - 07680$ - 0$ - 0$ - 0
X003Concierge Customer Service Representative (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
X011Concierge Customer Service Representative (JBA)1920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 01920$ - 0$ - 0$ - 0
Total Yearly Costs$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

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