HT0014-15-R-0020_VOL_I_Technical_Sub_Factor_1_Compensation_Matrix_(Atch_7).xlsx
XLSX spreadsheet 42 KB Posted
- Attached to
- Certified Pharmacy Technicians - Inpatient/Outpatient Federal contract opportunity
- Solicitation number
- HT0014-15-R-0020
- Issued by
- Defense Health Agency
About this file
Compensation Matrix Attachment 7
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| HT0014-15-R-0020_Amendment_1__dated__8-19-15.pdf | ||
| HT0014-15-R-0020_VOL_I_Technical_Sub_Factor_1_Compensation_Matrix_(Atch7)_Amend_1...xlsx | XLSX spreadsheet | |
| HT0014-15-R-0020_Certified_Pharmacy_Technicians_-_Inpatient_and_Outpatient.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
| Tabs A, AA,AB, AC & AD: |
| All Rates including benefits must be based on hourly rates and not annual figures |
| Compensation for health care 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. |
| Note: If offerors would like to include a Narrative pages for the Compensation Matrix be advised that the total number of pages are included in the maximum 10 pages for Volume I |
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 | CME | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead | G&A | Profit | Total Billable Hourly Rate | |
| Pharmacy Technician-Outpatient | 14,520 | $0.00 | $0.02 | $0.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.26 | $0.40 | ERROR:#DIV/0! | $0.40 | $0.01 | $0.01 | $0.01 | $0.43 | |||
| Contractor Manpower Reporting | 1 | $0.00 | $0.02 | $0.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.26 | $0.40 | ERROR:#DIV/0! | $0.40 | $0.01 | $0.01 | $0.01 | $0.43 | |||
| $0.00 | $0.02 | $0.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.26 | $0.40 | ERROR:#DIV/0! | $0.40 | $0.01 | $0.01 | $0.01 | $0.43 | |||||
| $0.00 | $0.02 | $0.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.26 | $0.40 | ERROR:#DIV/0! | $0.40 | $0.01 | $0.01 | $0.01 | $0.43 | |||||
| $0.00 | $0.02 | $0.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.26 | $0.40 | ERROR:#DIV/0! | $0.40 | $0.01 | $0.01 | $0.01 | $0.43 | |||||
| $0.00 | $0.02 | $0.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.26 | $0.40 | ERROR:#DIV/0! | $0.40 | $0.01 | $0.01 | $0.01 | $0.43 |
&"-,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 | CME | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead | G&A | Profit | Total Billable Hourly Rate | |
| Pharmacy Technician-Outpatient | 30,720 | $0.00 | $0.00 | $0.02 | $0.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.26 | $0.40 | ERROR:#DIV/0! | $0.40 | $0.01 | $0.01 | $0.01 | $0.43 | ||
| Pharmacy Technicians-Inpatient | 3,840 | $0.00 | $0.00 | $0.02 | $0.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.26 | $0.40 | ERROR:#DIV/0! | $0.40 | $0.01 | $0.01 | $0.01 | $0.43 | ||
| Contractor Manpower Reporting | 1 | $0.00 | $0.00 | $0.02 | $0.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.26 | $0.40 | ERROR:#DIV/0! | $0.40 | $0.01 | $0.01 | $0.01 | $0.43 | ||
| $0.00 | $0.00 | $0.02 | $0.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.26 | $0.40 | ERROR:#DIV/0! | $0.40 | $0.01 | $0.01 | $0.01 | $0.43 | ||||
| $0.00 | $0.00 | $0.02 | $0.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.26 | $0.40 | ERROR:#DIV/0! | $0.40 | $0.01 | $0.01 | $0.01 | $0.43 | ||||
| $0.00 | $0.00 | $0.02 | $0.12 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.26 | $0.40 | ERROR:#DIV/0! | $0.40 | $0.01 | $0.01 | $0.01 | $0.43 |
AB-Compensation Plan OptionYr2 and
| Level of Effort | Productive Hours | Base Salary (Hourly) | FICA | FUTA | SUTA | Medicare | Worker Comp | Health Insurance | Holiday | Vacation | Retirement | CME | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead | G&A | Profit | Total Billable Hourly Rate |
| Pharmacy Technician-Outpatient | 30,720 | ||||||||||||||||||
| Pharmacy Technicians-Inpatient | 3,840 | ||||||||||||||||||
| Contractor Manpower Reporting | 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 | CME | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead | G&A | Profit | Total Billable Hourly Rate |
| Pharmacy Technician-Outpatient | 30,720 | ||||||||||||||||||
| Pharmacy Technicians-Inpatient | 3,840 | ||||||||||||||||||
| Contractor Manpower Reporting | 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 | CME | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead | G&A | Profit | Total Billable Hourly Rate |
| Pharmacy Technician-Outpatient | 30,720 | ||||||||||||||||||
| Pharmacy Technicians-Inpatient | 3,840 | ||||||||||||||||||
| Contractor Manpower Reporting | 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 |
| Pharmacy Technician-Outpatient | 30,720 | $ - 0 | $ - 0 | $0.00 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Pharmacy Technicians-Inpatient | 3,840 | $ - 0 | $ - 0 | $0.00 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| Contractor Manpower Reporting | 1 | $ - 0 | $ - 0 | $0.00 | $ - 0 | $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $0.00 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $0.00 | $ - 0 | $ - 0 | $ - 0 | |||||||||||
| $ - 0 | $ - 0 | $0.00 | $ - 0 | $ - 0 | $ - 0 |
Total Cost $ - 0
File details come from the government source that posted it. Updated .