HT0014-14-R-0008_Compensation_Matrix.xlsx
XLSX spreadsheet 45 KB Posted
- Attached to
- HT0014-14-R-0008_P0001 Federal contract opportunity
- Solicitation number
- HT0014-14-R-0008
- Issued by
- Department of the Army Medical Command
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| HT0014-14-R-0008_P0001.pdf | ||
| HT0014-14-R-0008_Compensation_Matrix_Chg_1.xlsx | XLSX spreadsheet | |
| Questions_received_and_Answers_provided_in_response_to_RFP_HT0014-14-R-0008.docx | DOCX document | |
| PAST_PERFORMANCE_SURVEY_QUESTIONNAIRE.doc | DOC document | |
| HT0014-14-R-0008.doc | DOC document |
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 = 1 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 ) | G&A | Profit | Total Billable Hourly Rate |
| Nuclear Medical Physicist | 1,920 | $ | ||||||||||||||||
| Nuclear Medical Pharmacist | 1,920 | $ | ||||||||||||||||
| Nuclear Medicine Technologists | 3,840 | $ | ||||||||||||||||
| Option - Nuclear Medicine Technologists | 7,680 | $ | ||||||||||||||||
| Manpower Report | 1 | $ |
&"-,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 | Profit | Total Billable Hourly Rate |
| Nuclear Medical Physicist | 1,920 | $ | ||||||||||||||||
| Nuclear Medical Pharmacist | 1,920 | $ | ||||||||||||||||
| Nuclear Medicine Technologists | 3,840 | $ | ||||||||||||||||
| Option - Nuclear Medicine Technologists | 7,680 | $ | ||||||||||||||||
| Manpower Report | 1 | $ |
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 ) | G&A | Profit | Total Billable Hourly Rate |
| Nuclear Medical Physicist | 1,920 | $ | ||||||||||||||||
| Nuclear Medical Pharmacist | 1,920 | $ | ||||||||||||||||
| Nuclear Medicine Technologists | 3,840 | $ | ||||||||||||||||
| Option - Nuclear Medicine Technologists | 7,680 | $ | ||||||||||||||||
| Manpower Report | 1 | $ |
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 ) | G&A | Profit | Total Billable Hourly Rate |
| Nuclear Medical Physicist | 1,920 | $ | ||||||||||||||||
| Nuclear Medical Pharmacist | 1,920 | $ | ||||||||||||||||
| Nuclear Medicine Technologists | 3,840 | $ | ||||||||||||||||
| Option - Nuclear Medicine Technologists | 7,680 | $ | ||||||||||||||||
| Manpower Report | 1 | $ |
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 |
| Nuclear Medical Physicist | 1,920 | $ | ||||||||||||||||
| Nuclear Medical Pharmacist | 1,920 | $ | ||||||||||||||||
| Nuclear Medicine Technologists | 3,840 | $ | ||||||||||||||||
| Option - Nuclear Medicine Technologists | 7,680 | $ | ||||||||||||||||
| Manpower Report | 1 | $ |
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 |
| Nuclear Medical Physicist | 1,920 | $0.00 | 1,920 | $0.00 | 1,920 | $0.00 | 1,920 | $0.00 | 1,920 | $0.00 | $0.00 | |||||
| Nuclear Medical Pharmacist | 1,920 | 1,920 | 1,920 | 1,920 | 1,920 | $0.00 | ||||||||||
| Nuclear Medicine Technologists | 3,840 | 3,840 | 3,840 | 3,840 | 3,840 | $0.00 | ||||||||||
| Option - Nuclear Medicine Technologists | 7,680 | 7,680 | 7,680 | 7,680 | 7,680 | |||||||||||
| Manpower Report | 1 | 1 | 1 | 1 | 1 |
File details come from the government source that posted it. Updated .