Attachment_2_Compensation_Matrix.xlsx
XLSX spreadsheet 43 KB Posted
- Attached to
- Therapeutic, Administrative, and Continuing Education Support to the National Intrepid Center of
- Solicitation number
- HT0014-16-R-0028
- Issued by
-
Defense Health Agency
About this file
Attachment 2 Compensation Matrix to the Solicitation
View the file
Other files
| File | Type | Posted |
|---|---|---|
| HT0014-16-R-0028-0001.pdf | ||
| PAST_PERFORMANCE_SURVEY_QUESTIONNAIRE.docx | DOCX document | |
| HT0014-16-R-0028.pdf |
On GovTribe
Work with this file
- 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: |
| 1. All Rates including benefits must be based on hourly rates and not annual figures |
| 2. The offeror is responsible for doing the mathematical calculations |
| 3. The offeror cannot change the order and name of the specialties (column A). |
| 4. Total Hours = 40 hours in a five day work week (48 weeks) + 10 Federal holidays + 10 vacation days (2,080 hours = 1 one full time contractor employee (FTE) for one year = 8 hrs/day x 5 days/wk for 52 weeks) |
| Costs associated with vacations and Federal holidays are normally included in fringe benefits, therefore the vacation/holiday associated costs are to be input into column D (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 Period of Performance: 30 Sep 16 thru 29 Sep 17
LABOR CATEGORY
and
| Level of Effort | Total Hours | Base Salary (Hourly) | Total base Salary +Fringe benefits (Hourly ) | G&A | Profit | Total Billable Hourly Rate | |
| Admin Support Specialist (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Arts Coordinator (1 FTE) | 1,920 | $ | $ | $ | $ | $ | |
| Arts Coordinator Assitants (2 FTE) | 3,840 | $ | $ | $ | $ | $ | |
| Nurse Consultant (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Health System Specialist (1 FTE) | 1,920 | $ | $ | $ | $ | $ | |
| Executive Administrative Specialist (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Service Dog Training Specialists (4 FTE)** | 7,680 | $ | $ | $ | $ | $ | |
| Canine Assisted Therapists (2 FTE)** | 3,840 | $ | $ | $ | $ | $ | |
| Adaptive Sports Specialist (1 FTE)** | 1,920 | $ | $ | $ | $ | $ | |
| Adaptive Sports Administrator (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Occupational Therapy Administrator (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Manpower Report | Not Separately Priced | ||||||
| Notes: | |||||||
| * These labor categories are comparable to labor categories on the Department of Labor's Wage Determination (WD), e.g. Medical Record Clerk or Administrative Assistant as applicable. Ensure you include the WD Health & Welfare cost in this Compensation Matrix for these labor categories. | |||||||
| ** These labor categories are required to have liability insurance, IAW clause 52.237-7, before and during performance of services. |
&"-,Bold"&18Compensation Plan&14 &"-,Regular"&11
&P
AA-Compensation Plan Option Yr1 Period of Performance: 30 Sep 17 thru 29 Sep 18
LABOR CATEGORY
and
| Level of Effort | Total Hours | Base Salary (Hourly) | Total base Salary +Fringe benefits (Hourly ) | G&A | Profit | Total Billable Hourly Rate | |
| Admin Support Specialist (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Arts Coordinator (1 FTE) | 1,920 | $ | $ | $ | $ | $ | |
| Arts Coordinator Assitants (2 FTE) | 3,840 | $ | $ | $ | $ | $ | |
| Nurse Consultant (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Health System Specialist (1 FTE) | 1,920 | $ | $ | $ | $ | $ | |
| Executive Administrative Specialist (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Service Dog Training Specialists (4 FTE)** | 7,680 | $ | $ | $ | $ | $ | |
| Canine Assisted Therapists (2 FTE)** | 3,840 | $ | $ | $ | $ | $ | |
| Adaptive Sports Specialist (1 FTE)** | 1,920 | $ | $ | $ | $ | $ | |
| Adaptive Sports Administrator (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Occupational Therapy Administrator (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Manpower Report | Not Separately Priced | ||||||
| Notes: | |||||||
| * These labor categories are comparable to labor categories on the Department of Labor's Wage Determination (WD), e.g. Medical Record Clerk or Administrative Assistant as applicable. Ensure you include the WD Health & Welfare cost in this Compensation Matrix for these labor categories. | |||||||
| ** These labor categories are required to have liability insurance before and during performance of services. |
AB-Compensation Plan OptionYr2 Period of Performance: 30 Sep 18 thru 29 Sep 19
LABOR CATEGORY
and
| Level of Effort | Total Hours | Base Salary (Hourly) | Total base Salary +Fringe benefits (Hourly ) | G&A | Profit | Total Billable Hourly Rate | |
| Admin Support Specialist (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Arts Coordinator (1 FTE) | 1,920 | $ | $ | $ | $ | $ | |
| Arts Coordinator Assitants (2 FTE) | 3,840 | $ | $ | $ | $ | $ | |
| Nurse Consultant (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Health System Specialist (1 FTE) | 1,920 | $ | $ | $ | $ | $ | |
| Executive Administrative Specialist (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Service Dog Training Specialists (4 FTE)** | 7,680 | $ | $ | $ | $ | $ | |
| Canine Assisted Therapists (2 FTE)** | 3,840 | $ | $ | $ | $ | $ | |
| Adaptive Sports Specialist (1 FTE)** | 1,920 | $ | $ | $ | $ | $ | |
| Adaptive Sports Administrator (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Occupational Therapy Administrator (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Manpower Report | Not Separately Priced | ||||||
| Notes: | |||||||
| * These labor categories are comparable to labor categories on the Department of Labor's Wage Determination (WD), e.g. Medical Record Clerk or Administrative Assistant as applicable. Ensure you include the WD Health & Welfare cost in this Compensation Matrix for these labor categories. | |||||||
| ** These labor categories are required to have liability insurance before and during performance of services. |
AC-Compensation Plan Option Yr3 Period of Performance: 30 Sep 19 thru 29 Sep 20
LABOR CATEGORY
and
| Level of Effort | Total Hours | Base Salary (Hourly) | Total base Salary +Fringe benefits (Hourly ) | G&A | Profit | Total Billable Hourly Rate | |
| Admin Support Specialist (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Arts Coordinator (1 FTE) | 1,920 | $ | $ | $ | $ | $ | |
| Arts Coordinator Assitants (2 FTE) | 3,840 | $ | $ | $ | $ | $ | |
| Nurse Consultant (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Health System Specialist (1 FTE) | 1,920 | $ | $ | $ | $ | $ | |
| Executive Administrative Specialist (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Service Dog Training Specialists (4 FTE)** | 7,680 | $ | $ | $ | $ | $ | |
| Canine Assisted Therapists (2 FTE)** | 3,840 | $ | $ | $ | $ | $ | |
| Adaptive Sports Specialist (1 FTE)** | 1,920 | $ | $ | $ | $ | $ | |
| Adaptive Sports Administrator (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Occupational Therapy Administrator (1 FTE)* | 1,920 | $ | $ | $ | $ | $ | |
| Manpower Report | Not Separately Priced | ||||||
| Notes: | |||||||
| * These labor categories are comparable to labor categories on the Department of Labor's Wage Determination (WD), e.g. Medical Record Clerk or Administrative Assistant as applicable. Ensure you include the WD Health & Welfare cost in this Compensation Matrix for these labor categories. | |||||||
| ** These labor categories are required to have liability insurance before and during performance of services. |
AD-Compensation Plan Option Pd4 Period of Performance: 30 Sep 20 thru 29 Mar 21
LABOR CATEGORY
and
| Level of Effort | Total Hours | Base Salary (Hourly) | Total base Salary +Fringe benefits (Hourly ) | G&A | Profit | Total Billable Hourly Rate | |
| Admin Support Specialist (1 FTE)* | 960 | $ | $ | $ | $ | $ | |
| Arts Coordinator (1 FTE) | 960 | $ | $ | $ | $ | $ | |
| Arts Coordinator Assitants (2 FTE) | 1,920 | $ | $ | $ | $ | $ | |
| Nurse Consultant (1 FTE)* | 960 | $ | $ | $ | $ | $ | |
| Health System Specialist (1 FTE) | 960 | $ | $ | $ | $ | $ | |
| Executive Administrative Specialist (1 FTE)* | 960 | $ | $ | $ | $ | $ | |
| Service Dog Training Specialists (4 FTE)** | 3,840 | $ | $ | $ | $ | $ | |
| Canine Assisted Therapists (2 FTE)** | 960 | $ | $ | $ | $ | $ | |
| Adaptive Sports Specialist (1 FTE)** | 960 | $ | $ | $ | $ | $ | |
| Adaptive Sports Administrator (1 FTE)* | 960 | $ | $ | $ | $ | $ | |
| Occupational Therapy Administrator (1 FTE)* | 960 | $ | $ | $ | $ | $ | |
| Manpower Report | Not Separately Priced | ||||||
| Notes: | |||||||
| * These labor categories are comparable to labor categories on the Department of Labor's Wage Determination (WD), e.g. Medical Record Clerk or Administrative Assistant as applicable. Ensure you include the WD Health & Welfare cost in this Compensation Matrix for these labor categories. | |||||||
| ** These labor categories are required to have liability insurance before and during performance of services. |
B- Roll Up
| Labor Category | # of Hours Base Year only | Total Billable Hourly Rate (Base Period) | Total Cost Base Period (B x C) | # of Hours, Option Year 1 | Total Billable Hourly Rate (Option Year 1) | Total Cost Option Year 1 (E x F) | # of Hours, Option Year 2 | Total Billable Hourly Rate (Option Year 2) | Total Cost Option Year 2 (H x I) | # of Hours, Option Year 3 | Total Billable Hourly Rate (Option Year 3) | Total Cost Option Year 3 (K x L) | # of Hours, Option Year 4 | Total Billable Hourly Rate (Option Period 4) | Total Cost Option Year 4 (N x O) | Total Sum of Costs |
| Admin Support Specialist (1 FTE) | 1,920 | $ | ERROR:#VALUE! | 1,920 | $ | ERROR:#VALUE! | 1,920 | $ | ERROR:#VALUE! | 1,920 | $ | ERROR:#VALUE! | 960 | $ | ERROR:#VALUE! | ERROR:#VALUE! |
| Arts Coordinator (1 FTE) | 1,920 | $ | 1,920 | $ | 1,920 | $ | 1,920 | $ | 960 | $ | $0.00 | |||||
| Arts Coordinator Assitants (2 FTE) | 3,840 | $ | 3,840 | $ | 3,840 | $ | 3,840 | $ | 1,920 | $ | $0.00 | |||||
| Nurse Consultant (1 FTE) | 1,920 | $ | 1,920 | $ | 1,920 | $ | 1,920 | $ | 960 | $ | ||||||
| Health System Specialist (1 FTE) | 1,920 | $ | 1,920 | $ | 1,920 | $ | 1,920 | $ | 960 | $ | ||||||
| Executive Administrative Specialist (1 FTE) | 1,920 | $ | 1,920 | $ | 1,920 | $ | 1,920 | $ | 960 | $ | ||||||
| Service Dog Training Specialists (4 FTE) | 7,680 | $ | 7,680 | $ | 7,680 | $ | 7,680 | $ | 3,840 | $ | ||||||
| Canine Assisted Therapists (2 FTE) | 3,840 | $ | 3,840 | $ | 3,840 | $ | 3,840 | $ | 960 | $ | ||||||
| Adaptive Sports Specialist (1 FTE) | 1,920 | $ | 1,920 | $ | 1,920 | $ | 1,920 | $ | 960 | $ | ||||||
| Adaptive Sports Administrator (1 FTE) | 1,920 | $ | 1,920 | $ | 1,920 | $ | 1,920 | $ | 960 | $ | ||||||
| Occupational Therapy Administrator (1 FTE) | 1,920 | $ | 1,920 | $ | 1,920 | $ | 1,920 | $ | 960 | $ | ||||||
| Manpower Report | Not Separately Priced |
File details come from the government source that posted it. Updated .