HT0014-16-R-0005__Attachment_1_-_Compensation_Matrix.xlsx
XLSX spreadsheet 42 KB Posted
- Attached to
- CHIROPRACTOR SERVICES Federal contract opportunity
- Solicitation number
- HT0014-16-R-0005
- Issued by
- Defense Health Agency
About this file
OFFERORS ARE TO USE ATTACHMENT ONE (1) COMPENSATION MATRIX TO DESCRIBE THEIR COMPENSATION PLAN
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| A.09.03_HT0014-16-R-0005_CHIROPRACTOR_SOLICITATION.pdf | ||
| EXCEL_WORKBOOK_COMPENSATION_PLAN_ _PRICING_SPREADSHEET_TEMPLATE_FOR__HT0014-16-R-0005.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 | CME | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead | G&A | Profit | Total Billable Hourly Rate |
| Chiropractor Services (2 FTE) | 3,856 | ||||||||||||||||||
| Contractor Manpower Reporting (CMR) | 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 | CME | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead | G&A | Profit | Total Billable Hourly Rate |
| Chiropractor Services (2 FTE) | 3,856 | ||||||||||||||||||
| Contractor Manpower Reporting (CMR) | 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 | CME | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead | G&A | Profit | Total Billable Hourly Rate |
| Chiropractor Services (2 FTE) | 3,856 | ||||||||||||||||||
| Contractor Manpower Reporting (CMR) | 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 | |
| Chiropractor Services (2 FTE) | 3,856 | $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 (CMR) | 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 | ||||
| $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 |
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 | |
| Chiropractor Services (2 FTE) | 3,856 | $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 (CMR) | 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 | ||||
| $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 |
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 |
| Chiropractor Services (2 FTE) | 3,856 | 3,856 | 3,856 | 3,856 | 3,856 | |||||||||||
| Contractor Manpower Reporting (CMR) | 1 | 1 | 1 | 1 | 1 |
File details come from the government source that posted it. Updated .