PLO and Medical Translator Serv. Compensation Price Matrix NOV 21-2023.xlsx
XLSX spreadsheet 45 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 seeking patient liaison and medical translation services. The solicitation requires offerors to provide fully burdened hourly rates for two labor categories - patient liaison services at 2.75 FTEs and medical translation services at 1.5 FTEs - for a base year and four one-year option periods. The template includes tabs for inputting productive hourly rates, fringe benefits, overhead costs, profit, and total billable hourly rates for each contract line item number and period of performance. Offerors must complete the template with their pricing proposals and ensure the mathematical calculations auto-populate across tabs as designed. The related federal contract opportunity is solicitation number HT001424R0003 issued by the Defense Health Agency to provide patient liaison and medical translation services in Spangdahlem and Geilenkirchen, Germany.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 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 | |
| Patient Liaison and Medical Translator Services Compensation Price Matrix NOV 2023.xlsx | XLSX spreadsheet | |
| 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: 6 December 2023 - 5 December 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 2.75 FTES | 4840 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| 0002 | Medical Translation Services 1.5 FTE | 1374 | 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: 06 December 2024 - 5 December 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 2.75 FTES | 4840 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| 1002 | Medical Translation Services 1.5 FTE | 1374 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| Total | $0.00 |
AB-Compensation Option Year 2
| POP Option Period#2: 06 December 2025 - 05 December 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 | ||
| 2001 | Patient Liaison Services 2.75 FTES | 4840 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| 2002 | Medical Translation Services 1.5 FTE | 1374 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| Total | $0.00 |
AC-Compensation Option Year 3
| POP Option Period#3: 06 December 2026 - 05 December 2027 |
| 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 | ||
| 3001 | Patient Liaison Services 2.75 FTES | 4840 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| 3002 | Medical Translation Services 1.5 FTE | 1374 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| Total | $0.00 |
AD-Compensation Option Year 4
| POP Option Period#3: 06 December 2027 - 05 December 2028 |
| 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 | ||
| 4001 | Patient Liaison Services 2.75 FTES | 4840 | ERROR:#DIV/0! | $0.00 | $0.00 | $0.00 | ||||
| 4002 | Medical Translation Services 1.5 FTE | 1374 | 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) Total Price (Option Year 4)
| 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! | ERROR:#REF! |
| 0002 | Medical Translation Services | $0.00 | ERROR:#REF! | 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! | ERROR:#REF! |
File details come from the government source that posted it. Updated .