Patient Liaison and Medical Translator Services Compensation Price Matrix NOV 2023.xlsx
XLSX spreadsheet 44 KB Posted
- Attached to
- Patient Liaison and Medical Translation Services Spangdahlem and Geilenkirchen, Germany.
- Solicitation number
- HT001424R0003
- Issued by
-
Defense Health Agency
About this file
This document contains a compensation price matrix template for a federal contract solicitation for patient liaison and medical translation services in Germany. The template includes tabs for labor categories, productive hours, base salary rates, fringe benefits, overhead costs, profit, and fully burdened hourly rates for a base year and three option years. Labor categories are for patient liaison services and medical translation services. Productive hours are estimated at 5760 and 2880 hours respectively for the base year. Offerors are to complete the template with their pricing details for evaluation for contract number HT001424R0003 issued by the Defense Health Agency to provide said services in Spangdahlem and Geilenkirchen, Germany.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| PLO and Medical Translator Serv. Compensation Price Matrix NOV 21-2023.xlsx | XLSX spreadsheet | |
| HT0014-24-R-0003 MOD 0003.pdf | ||
| ANSWERS TO QUESTIONS 11212023.docx | DOCX document | |
| HT0014-24-R-0003 MOD 0002.pdf | ||
| HT0014-24-R-0003 MOD 0001.pdf | ||
| Past Performance Summary (PPS) 1.pdf | ||
| Past Performance Questionnaire (PPQ 1).doc | DOC document | |
| Instructions to Offerors 11012023.docx | DOCX document | |
| HT001424R0003.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 |
| All Rates including benefits must be based on hourly rates and not annual figures |
The offeror can add additional columns according to their 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 (columns A & B) nor the quantities of hours (column C). |
| 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 fringe benefit rate; therefore, the vacation/holiday associated costs are to be input into the "Fringe Benefits" |
| columns (in Tabs A, AA, AB,AC and AD) for the purposes of this spreadsheet. |
| Tab B "Price": |
| The Fully Burdened Hourly Rates for the Base Year and Option Periods (Tabs A, AA, AB,AC and AD) will auto-populate the cells of Tab B. |
| Verify the math is correctly computed. |
Attachment 7 - Instructions for Compensation Price Matrix for MQS RFP 14671
A- Compensation Base Period
| Base Period of Performance: Base Period: 18 Oct. 2023 - 30 Sept.2024 Leap year |
| CLIN |
LABOR CATEGORY
and
| Level of Effort | Productive Hours | Base Salary (Hourly) | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead (OH);G&A Profit | Total Billable Hourly Rate | Total Price | ||
| 0001 | Patient Liaison Services | 5760 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| 0002 | Medical Translation Services | 2880 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| Total | $0.00 |
&"-,Bold"&18Compensation Plan&14 &"-,Regular"&11
&P
AA-Compensation Year Period 1
| POP Option Period#1: 01 October 2024 - 30 September 2025 |
| CLIN |
LABOR CATEGORY
and
| Level of Effort | Productive Hours | Base Salary (Hourly) | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead (OH);G&A Profit | Total Billable Hourly Rate | Total Price | ||
| 1001 | Patient Liaison Services | 5736 | ERROR:#DIV/0! | $0.00 | $0.00 | |||||
| 1002 | Medical Translation Services | 2868 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| Total | $0.00 |
AB-Compensation Option Year 2
| POP Option Period#2: 01 October 2025 - 30 September 2026 |
| CLIN |
LABOR CATEGORY
and
| Level of Effort | Productive Hours | Base Salary (Hourly) | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead (OH);G&A Profit | Total Billable Hourly Rate | Total Price | ||
| 1001 | Patient Liaison Services | 5736 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| 1002 | Medical Translation Services | 2868 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| Total | $0.00 |
AC-Compensation Option Year 3
| POP Option Period#3: 01 October 2025 - 30 September 2026 |
| CLIN |
LABOR CATEGORY
and
| Level of Effort | Productive Hours | Base Salary (Hourly) | Total Fringe Benefits | Fringe Benefits Percentage | Total base Salary +Fringe benefits (Hourly ) | Overhead (OH);G&A Profit | Total Billable Hourly Rate | Total Price | ||
| 1001 | Patient Liaison Services | 5736 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| 1002 | Medical Translation Services | 2868 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| Total | $0.00 |
B- Price
| Base Year | OY 1 | OY 2 | OY 3 | |
| CLIN |
LABOR CATEGORY
and
| Level of Effort | Total Price (Base Period) |
| Total Price (Option Year 1) | |
| Total Price |
(Option Year 2) Total Price (Option Year 3)
| FAR Clause 52.217-8 6-month Extension For Evaluation Purposes Only | |
| (G/2) | Total Sum of Costs |
(C +D + E +F + G + H)
| 0001 | Patient Liaison Services | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 0002 | Medical Translation Services | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| Total Price | $0.00 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | |
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
File details come from the government source that posted it. Updated .