Attachment_9_-_Compensation_Matrix_(7.17.15).xlsx
XLSX spreadsheet 47 KB Posted
- Attached to
- Behavioral Health Services Federal contract opportunity
- Solicitation number
- HT0014-15-R-0016
- Issued by
- Defense Health Agency
About this file
Updated Matrix
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| HT0014-15-R-0016-0001.pdf | ||
| HT0014-15-R-0016_Behavioral_Health.doc | DOC document | |
| A.09.03_RFQ_Compensation_Matrix.xlsx | XLSX spreadsheet |
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
| 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 year. |
| The offeror can add additional columns according to their benefits package |
| The offeror can label the columns according to their benefits package. The Government has provided a few examples that can be change accordingly to the offerors benefits package. |
| 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 specialties (column A). |
| Productive Hrs.= total hours in a work year LESS vacation & holidays (e.g. 1,920 hours = One full time 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 overhead/fringe benefit rate, therefore the vacation/holiday associated costs are to be input into columns J&K (Tabs A, AA, AB, AC & AD) for the purposes of this spreadsheet. |
| Tab B "Roll Up": |
| Populate the Fully Burdened Hourly Rates for the Base Period and Option Years. |
| Verify the math is correctly computed. |
A- Compensation Plan Base Year
LABOR CATEGORY
and
| Level of Effort | Productive Hours | Base Salary (Hourly) | FICA | FUTA | SUTA | Medicare | Worker Comp | Health Insurance | Holiday | Vacation | Retirement | OTHER (Define). Insert additional column(s) if needed. | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead | G&A | Profit | Total Billable Hourly Rate | Total Annual Cost |
| Adult Psychiatrist (2 FTE) | 2,240 | $ | ||||||||||||||||||
| Psychiatrist Unscheduled Hours (1 FTE) | 56 | $ | ||||||||||||||||||
| Adult Psychologist (2 FTE) | 4,480 | $ | ||||||||||||||||||
| Child Psychologist (1 FTE) | 1,120 | $ | ||||||||||||||||||
| Psychologist Unscheduled (1 FTE) | 72 | $ | ||||||||||||||||||
| Psychiatric Nurse Pratitioner (1 FTE) | 1,120 | $ | ||||||||||||||||||
| Psychiatric Nurse Pratitioner Unscheduled (1 FTE) | 59 | $ | ||||||||||||||||||
| Adult Clinical Social Worker (4 FTE) | 7,840 | $ | ||||||||||||||||||
| Child Clinical Social Worker (2 FTE) | 2,240 | $ | ||||||||||||||||||
| Clinical Social Worker Unscheduled (1 FTE) | 233 | $ | ||||||||||||||||||
| On-Call (1 FTE) | 1,020 | $ | ||||||||||||||||||
| Contract Manpower Report | CMR | $ |
&"-,Bold"&18Compensation Plan&14 &"-,Regular"&11
&P
AA-Compensation Plan Option Yr1 and
| Level of Effort | Productive Hours | Base Salary (Hourly) | FICA | FUTA | SUTA | Medicare | Worker Comp | Health Insurance | Holiday | Vacation | Retirement | OTHER (Define). Insert additional column(s) if needed. | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | G&A | Overhead | Profit | Total Billable Hourly Rate | Total Annual Cost |
| Adult Psychiatrist (2 FTE) | 3,840 | $ | ||||||||||||||||||
| Psychiatrist Unscheduled Hours (1 FTE) | 56 | $ | ||||||||||||||||||
| Adult Psychologist (4 FTE) | 7,680 | $ | ||||||||||||||||||
| Child Psychologist (1 FTE) | 1,920 | $ | ||||||||||||||||||
| Psychologist Unscheduled (1 FTE) | 72 | $ | ||||||||||||||||||
| Psychiatric Nurse Pratitioner (1 FTE) | 1,920 | $ | ||||||||||||||||||
| Psychiatric Nurse Pratitioner Unscheduled (1 FTE) | 59 | $ | ||||||||||||||||||
| Adult Clinical Social Worker (7 FTE) | 13,440 | $ | ||||||||||||||||||
| Child Clinical Social Worker (2 FTE) | 3,840 | $ | ||||||||||||||||||
| Clinical Social Worker Unscheduled (1 FTE) | 400 | $ | ||||||||||||||||||
| On-Call (1 FTE) | 1,750 | $ | ||||||||||||||||||
| Contract Manpower Report | CMR | $ |
AC-Compensation Plan Option Yr3 and
| Level of Effort | Productive Hours | Base Salary (Hourly) | FICA | FUTA | SUTA | Medicare | Worker Comp | Health Insurance | Holiday | Vacation | Retirement | OTHER (Define). Insert additional column(s) if needed. | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead | G&A | Profit | Total Billable Hourly Rate | Total Annual Cost |
| Adult Psychiatrist (2 FTE) | 3,840 | $ | ||||||||||||||||||
| Psychiatrist Unscheduled Hours (1 FTE) | 56 | $ | ||||||||||||||||||
| Adult Psychologist (4 FTE) | 7,680 | $ | ||||||||||||||||||
| Child Psychologist (1 FTE) | 1,920 | $ | ||||||||||||||||||
| Psychologist Unscheduled (1 FTE) | 72 | $ | ||||||||||||||||||
| Psychiatric Nurse Pratitioner (1 FTE) | 1,920 | $ | ||||||||||||||||||
| Psychiatric Nurse Pratitioner Unscheduled (1 FTE) | 59 | $ | ||||||||||||||||||
| Adult Clinical Social Worker (7 FTE) | 13,440 | $ | ||||||||||||||||||
| Child Clinical Social Worker (2 FTE) | 3,840 | $ | ||||||||||||||||||
| Clinical Social Worker Unscheduled (1 FTE) | 400 | $ | ||||||||||||||||||
| On-Call (1 FTE) | 1,750 | $ | ||||||||||||||||||
| Contract Manpower Report | CMR | $ |
AB-Compensation Plan OptionYr2 and
| Level of Effort | Productive Hours | Base Salary (Hourly) | FICA | FUTA | SUTA | Medicare | Worker Comp | Health Insurance | Holiday | Vacation | Retirement | OTHER (Define). Insert additional column(s) if needed. | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead | G&A | Profit | Total Billable Hourly Rate | Total Annual Cost |
| Adult Psychiatrist (2 FTE) | 3,840 | $ | ||||||||||||||||||
| Psychiatrist Unscheduled Hours (1 FTE) | 56 | $ | ||||||||||||||||||
| Adult Psychologist (4 FTE) | 7,680 | $ | ||||||||||||||||||
| Child Psychologist (1 FTE) | 1,920 | $ | ||||||||||||||||||
| Psychologist Unscheduled (1 FTE) | 72 | $ | ||||||||||||||||||
| Psychiatric Nurse Pratitioner (1 FTE) | 1,920 | $ | ||||||||||||||||||
| Psychiatric Nurse Pratitioner Unscheduled (1 FTE) | 59 | $ | ||||||||||||||||||
| Adult Clinical Social Worker (7 FTE) | 13,440 | $ | ||||||||||||||||||
| Child Clinical Social Worker (2 FTE) | 3,840 | $ | ||||||||||||||||||
| Clinical Social Worker Unscheduled (1 FTE) | 400 | $ | ||||||||||||||||||
| On-Call (1 FTE) | 1,750 | $ | ||||||||||||||||||
| Contract Manpower Report | CMR | $ |
AD-Compensation Plan Option Yr4 and
| Level of Effort | Productive Hours | Base Salary (Hourly) | FICA | FUTA | SUTA | Medicare | Worker Comp | Health Insurance | Holiday | Vacation | Retirement | OTHER (Define). Insert additional column(s) if needed. | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | G&A | Profit | Total Billable Hourly Rate | Total Annual Cost |
| Adult Psychiatrist (2 FTE) | 3,840 | $ | |||||||||||||||||
| Psychiatrist Unscheduled Hours (1 FTE) | 56 | $ | |||||||||||||||||
| Adult Psychologist (4 FTE) | 7,680 | $ | |||||||||||||||||
| Child Psychologist (1 FTE) | 1,920 | $ | |||||||||||||||||
| Psychologist Unscheduled (1 FTE) | 72 | $ | |||||||||||||||||
| Psychiatric Nurse Pratitioner (1 FTE) | 1,920 | $ | |||||||||||||||||
| Psychiatric Nurse Pratitioner Unscheduled (1 FTE) | 59 | $ | |||||||||||||||||
| Adult Clinical Social Worker (7 FTE) | 13,440 | $ | |||||||||||||||||
| Child Clinical Social Worker (2 FTE) | 3,840 | $ | |||||||||||||||||
| Clinical Social Worker Unscheduled (1 FTE) | 400 | $ | |||||||||||||||||
| On-Call (1 FTE) | 1,750 | $ | |||||||||||||||||
| Contract Manpower Report | CMR | $ |
B- Roll Up
| Labor Category | # of Hours Base Year only | Fully Burdened Hourly Rate (Base Period) | Total Cost Base Period | # of Hours, Option Year 1 | Fully Burdened Hourly Rate Option Year 1 | Total Cost Option Year 1 | # of Hours, Option Year 2 | Fully Burdened Hourly Rate Option Year 2 | Total Cost Option Year 2 | # of Hours, Option Year 3 | Fully Burdened Hourly Rate Option Year 3 | Total Cost Option Year 3 | # of Hours, Option Year 4 | Fully Burdened Hourly Rate Option Year 4 | Total Cost Option Year 4 | Total Sum of Costs |
| Adult Psychiatrist | 2,240 | 3,840 | 3,840 | 3,840 | 3,840 | |||||||||||
| Psychiatrist Unscheduled Hours | 56 | 56 | 56 | 56 | 56 | |||||||||||
| Adult Psychologist | 4,480 | 7,680 | 7,680 | 7,680 | 7,680 | |||||||||||
| Child Psychologist | 1,120 | 1,920 | 1,920 | 1,920 | 1,920 | |||||||||||
| Psychologist Unscheduled | 72 | 72 | 72 | 72 | 72 | |||||||||||
| Psychiatric Nurse Pratitioner | 1,120 | 1,920 | 1,920 | 1,920 | 1,920 | |||||||||||
| Psychiatric Nurse Pratitioner Unscheduled | 59 | 59 | 59 | 59 | 59 | |||||||||||
| Adult Clinical Social Worker | 7,840 | 13,440 | 13,440 | 13,440 | 13,440 | |||||||||||
| Child Clinical Social Worker | 2,240 | 3,840 | 3,840 | 3,840 | 3,840 | |||||||||||
| Clinical Social Worker Unscheduled | 233 | 400 | 400 | 400 | 400 | |||||||||||
| On-Call | 1,020 | 1,750 | 1,750 | 1,750 | 1,750 | |||||||||||
| Contract Manpower Report | CMR | CMR | CMR | CMR | CMR |
Sheet1
File details come from the government source that posted it. Updated .