On-site Repair and Maintenance Technician Comp and Price Matrix (REV 05042020).xlsx
XLSX spreadsheet 52 KB Posted
- Solicitation number
- HT001420R0009
- Issued by
-
Defense Health Agency
About this file
This document package includes a compensation and pricing matrix template as well as a related federal contract opportunity notice for on-site repair and maintenance technician services. The pricing matrix template requires offerors to input fully burdened hourly labor rates for base and option periods by labor category and includes 1920 regular and 300 emergency hours. The related federal contract opportunity is a solicitation seeking these on-site repair and maintenance technician services at the Walter Reed National Military Medical Center in support of the Defense Health Agency. Offerors must submit quotes in accordance with FAR Part 13.302-2 by the June 2nd deadline and provide 1-2 past performance references. The requirement has a NAICS code size standard of $7.5M and is set aside for 8(a) small businesses. The government intends to make one purchase order award and reserves the right to award without discussions.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment PPQ TEMPLATE.doc | DOC document | |
| HT0014-20-R-0009.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 Only Enter Data into the Yellow Colored Cells. The Spreadsheet will perform all calculations. Your Total Evaluated Price will be shown in the Orange Colored Cells.
| 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 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. |
| Tab B "Price": |
| Populate the Fully Burdened Hourly Rates for the Base Year and Option Periods (Tabs A, AA , AB, AC & AD). |
| Verify/Add all formulas, and verify the math is correctly computed. |
A- Compensation Base Period
| Offeror Name | |||
| Period of Performance (POP)-Base | Funding FY | CLIN or SubCLIN |
LABOR CATEGORY
and
| LEVEL OF EFFORT | Productive Hours | Base Salary (Hourly) | Total Fringe Benefits | Total base Salary +Fringe benefits (Hourly) | Total Billable Hourly Rate | |
| 07/13/2020-07/12/2021 | 2020 | 0001 | On-site Repair & Maintenance Technician | 1920 | $0.00 | |
| 07/13/2020-07/12/2021 | 2020 | 0002 | On-site Repair & Maintenance Technician (Emergency hours ) | 300 | $0.00 | |
| 0003 | Contractor Manpower Report | Not Separately Priced |
&"-,Bold"&18Compensation Plan&14 &"-,Regular"&11
&P
AA-Compensation Year Period 1
| Offeror Name | |||
| Period of Performance (POP)-Base | Funding FY | CLIN or SubCLIN |
LABOR CATEGORY
and
| LEVEL OF EFFORT | Productive Hours | Base Salary (Hourly) | Total Fringe Benefits | Total base Salary +Fringe benefits (Hourly) | Total Billable Hourly Rate | |
| 07/13/2021-07/12/2022 | 2021 | 0001 | On-site Repair & Maintenance Technician | 1920 | $0.00 | |
| 07/13/2021-07/12/2022 | 2021 | 0002 | On-site Repair & Maintenance Technician (Emergency hours ) | 300 | $0.00 | |
| 0003 | Contractor Manpower Report | Not Separately Priced |
AB-Compensation Year Period 2
| Offeror Name | |||
| Period of Performance (POP)-Base | Funding FY | CLIN or SubCLIN |
LABOR CATEGORY
and
| LEVEL OF EFFORT | Productive Hours | Base Salary (Hourly) | Total Fringe Benefits | Total base Salary +Fringe benefits (Hourly) | Total Billable Hourly Rate | |
| 07/13/2022-07/12/2023 | 2022 | 0001 | On-site Repair & Maintenance Technician | 1920 | $0.00 | |
| 07/13/2022-07/12/2023 | 2022 | 0002 | On-site Repair & Maintenance Technician (Emergency hours) | 300 | $0.00 | |
| 0003 | Contractor Manpower Report | Not Separately Priced |
AC- Compensation Year Period 3
| Offeror Name | |||
| Period of Performance (POP)-Base | Funding FY | CLIN or SubCLIN |
LABOR CATEGORY
and
| LEVEL OF EFFORT | Productive Hours | Base Salary (Hourly) | Total Fringe Benefits | Total base Salary +Fringe benefits (Hourly) | Total Billable Hourly Rate | |
| 07/13/2023-07/12/2024 | 2023 | 0001 | On-site Repair & Maintenance Technician | 1920 | $0.00 | |
| 07/13/2023-07/12/2024 | 2023 | 0002 | On-site Repair & Maintenance Technician (Emergency hours) | 300 | $0.00 | |
| 0003 | Contractor Manpower Report | Not Separately Priced |
AD-Compensation Option Year 4
| Offeror Name | |||
| POP-OptionYear 2 | Funding FY | CLIN |
LABOR CATEGORY
and
| LEVEL OF EFFORT | Productive Hours | Base Salary (Hourly) | Total Fringe Benefits | Total base Salary +Fringe benefits (Hourly ) | Total Billable Hourly Rate | |
| 07/13/2024-07/12/2025 | 2024 | 0001 | On-site Repair & Maintenance Technician | 1920 | $0.00 | |
| 07/13/2024-07/12-2025 | 2024 | 0002 | On-site Repair & Maintenance Technician (Emergency hours) | 300 | $0.00 | |
| 0003 | Contractor Manpower Report | Not Separately Priced |
B- Price Offeror Name
| TOTAL PROPOSED PRICE | $ - 0 | |||||||||||||||||||
| CLIN | Labor Category | # of Hours | ||||||||||||||||||
| (Base Period) | Total Billable Hourly Rate (Base Period) | Total Cost (Base Period) | # of Hours, (Option Year 1) | Total Billable Hourly Rate (Option Period 1) | Total Cost (Option Year 1) | # of Hours, (Option Year 2) | Total Billable Hourly Rate (Option Year 2) | Total Cost (Option Year 2) | # of Hours, (Option Year 3) | Total Billable Hourly Rate (Option Year 3) | Total Cost (Option Year 3) | # of Hours, (Option Year 4) | Total Billable Hourly Rate (Option Year 4) | Total Cost (Option Year 4 ) | FAR Clause 52.217-8 6-month Extension For Evaluation Purposes Only | |||||
| 0001 | On-site Repair & Maintenance Technician | 1920 | ERROR:#REF! | ERROR:#REF! | 1920 | ERROR:#REF! | ERROR:#REF! | 1920 | ERROR:#REF! | ERROR:#REF! | 1920 | ERROR:#REF! | ERROR:#REF! | 1920 | $ | ERROR:#VALUE! | ERROR:#REF! | |||
| 0002 | On-site Repair & Maintenance Technician (Emergency hours) | 300 | ERROR:#REF! | ERROR:#REF! | 300 | ERROR:#REF! | ERROR:#REF! | 300 | ERROR:#REF! | ERROR:#REF! | 300 | $ | ERROR:#REF! | 300 | $ | ERROR:#VALUE! | ERROR:#REF! | |||
| 0003 | Contractor Manpower Report | Not Separately Priced | TOTAL PROPOSED PRICE | TOTAL EVALUATED PRICE | ||||||||||||||||
| ERROR:#REF! | ERROR:#REF! | ERROR:#REF! | $ | $ | $ | $ | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
File details come from the government source that posted it. Updated .