Compensation_Matrix_WRNMMC.xlsx
XLSX spreadsheet 33 KB Posted
- Attached to
- KITCHEN GALLEY EQUIPMENT MAINTENANCE Federal contract opportunity
- Solicitation number
- HT0014-15-R-0003
- Issued by
- Defense Health Agency
About this file
Compensation Matrix Template
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| HT0014-15-R-0003-P0002.doc | DOC document | |
| Questions_and_Answers_in_Response_for_Solicitation_HT0014-15-R-0003-0001.doc | DOC document | |
| HT0014-15-R-0003-P0001.doc | DOC document | |
| Kitchen_Equipment_List.xls | XLS spreadsheet | |
| Compensation_Matrix_WRNMMC.xlsx | XLSX spreadsheet | |
| HT0014-15-R-0003.doc | DOC document | |
| HT0014-15-R-0003.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 ) | Overhead | G&A | Profit | Total Billable Hourly Rate | |
| $0.00 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||||
| $0.00 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||||
| $0.00 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||||
| $0.00 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||||
| $0.00 | ERROR:#DIV/0! | $0.00 |
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 ) | Overhead | G&A | Profit | Total Billable Hourly Rate | |
| 0 | 2920 | $0.00 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | $0.00 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | $0.00 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | $0.00 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | $0.00 | ERROR:#DIV/0! | $0.00 |
AA-Compensation Plan option Yr2 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 | |
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 |
AA-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 | |
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 |
AA-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 ) | Overhead | G&A | Profit | Total Billable Hourly Rate | |
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 | ||||||||||||||||
| 0 | 0 | 0 | ERROR:#DIV/0! | $0.00 |
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 |
| $0.00 | 0 | $0.00 | $0.00 | 2,920 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 |
| $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 |
| $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 |
| $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 |
| $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | $0.00 |
File details come from the government source that posted it. Updated .