Attach9_Fee_Basis_Providers-Price_Matrix-11_Jun_18.xlsx
XLSX spreadsheet 66 KB Posted
- Attached to
- US MEPCOM Fee Basis Providers
- Solicitation number
- W81K04-18-R-0003
- Issued by
-
Department of the Army Medical Command
About this file
Attachment 9-Price Matrix and Compensation Plan
View the file
Other files
| File | Type | Posted |
|---|---|---|
| W81K0418R0003_0001_17Aug18.pdf | ||
| W81K0418R00030001_Atch1Question_and_Answer_-17_Aug_18.pdf | ||
| A_09_03_W81K04-18-R-0003-Released_Solicitation-26_Jul_18.pdf | ||
| ExhibitFFBP_TB_Algorithm_(1).pdf | ||
| ExhibitCPRS.docx | DOCX document | |
| ExhibitAMEPS_Locations.pptx | PPTX presentation | |
| ExhibitBMEPS_Physical_Addresses.xlsx | XLSX spreadsheet | |
| ExhibitEFBP_HEP_B_Vaccine_Algorithm.pdf | ||
| ExhibitDImmunization_Status_Format.docx | DOCX document | |
| Draft_Performance_Work_Statement-13_Jun_18.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
INSTRUCTIONS:
1. Fee Basis Provider Rates.
The offeror shall propose an hourly rate for each Fee Basis Provider (FBP) listed in the "Specialty Rates" tab. Each proposed FBP hourly rate will be a composite rate, applicable to all Military Entrance Processing Stations (MEPS) listed in the solicitation. To be a complete price proposal In Accordance With (IAW) the solicitation Addendum 52.212-1 the offeror shall propose a regular hourly rate for all FBPs for all five ordering years. To build a fully burdened regular hourly rate, the offeror shall start with a base hourly rate in the "Compensation" tab. Elements completed in the "Compensation" tab will result in the offeror’s proposed fully burdened regular hourly rate in the "Specialty Rates" tab. The offeror shall complete the “Price Matrix/Compensation Plan” spreadsheet by following the directions below.
2. Headings.
Offerors shall insert their company name, cage code and due date on the top left corner of each “Compensation Year” tab and "Specialty Rates" tab.
3. Tabs.
The Price Matrix/Compensation Plan spreadsheet is made up of ‘Compensation Year’ tabs for each year of the ordering period, a ‘Specialty Rates’ tab, and a ‘Summary’ tab. The tabs are linked by cells that are pre-populated with formulas and locked. DO NOT change locked cells.
4. Compensation.
For purposes of evaluating compensation, offerors shall propose labor rates based upon 2080 hours as a full time equivalent. Failure to provide pricing based upon 2080 hours may result in the proposal being deemed unacceptable and the offer being rejected for consideration for award. It is understood that the 2080 hours representing 1 full time equivalent (FTE) will also contain allowances for sick leave, vacation, other types of leave, etc. The compensation tabs are comprised of elements of the offeror’s compensation plan. All rates provided shall be regional rates. Although the elements provided are the most common elements, the government understands that offerors may/may not provide certain elements in the compensation tab. If this is the case, leave the element blank. Compensation Plan elements are briefly explained below:
| a. Column B (Base Annual Salary): Offerors shall insert their base annual salary for each specialty listed. |
| b. Columns C thru H (Health, Medicare, FICA, FUTA, SUTA, Worker Comp): Offerors shall insert annual amounts for these elements paying particular attention to the Department of Labor required rates for each element. |
| c. Columns I thru L (Holiday, Paid Time Off (PTO), Continuing Medical Education (CME) and Retirement): Shall be completed by the offeror as applicable with annual amounts. |
| d. Column M (Other Benefits): Shall be completed by the offeror as an annual amount and combines benefits not listed in paragraphs b and c above. |
| e. Column N (Total Annual Fringe), Column O (Annual Fringe Percentage), and Column P (Base Annual Salary and Fringe): These columns will automatically populate based on the amounts filled in on the proceeding columns. However, offerors must populate Column Q, Profit, G&A, and Other, with the appropriately calculated annual amount. |
| f. The amount in Column R [(Total Annual Salary (Including Profit, G&A, and Other)] shall become the fully-burdened annual salary for each FBP. This salary amount will become the basis for the fully-burdened regular hourly rate listed in the ‘Specialty Rates’ tab. Columns D, G, J, and M on the ‘Specialty Rates’ tab contains an embedded formula which will automatically divide the amount listed on Column R of the Compensation Year spreadsheet by 1920 and round to the nearest cent. |
| g. The fully-burdened regular hourly rate for each FBP derived from the above calculations will become the ceiling price for any resultant contract. |
| 5. Specialty Rates Tab. |
| a. Within the ‘Specialty Rates’ tab, there is a list of FBPs. Offerors shall ensure that the “Price Matrix/Compensation Plan” spreadsheet is complete and accurate IAW the solicitation’s Addendum to 52.212-1. All rates provided in the ‘Specialty Rates’ tab will be considered composite rates for each FBP for all of the MEPS listed in the solicitation. |
| b. Regular hourly rates will automatically populate in each cell from information keyed in by the offeror in the ‘Compensation Year’ tab of each ordering year. |
| c. Do not insert formulas or allow Excel to perform mathematical functions that will result in additional decimal places, as this will produce rounding errors in the offeror's proposed price. Note: Excell will not automatically show the additional decimal places when they are present. |
| 6. Summary Tab. |
| a. Travel. The total estimated amount for travel for all contracts combined is $300,000.00 for the 5-year ordering period. This amount appears in the summary tab and will be included as a separate cost reimbursable Contract Line Item (CLIN) on any resultant contract. |
| b. Post Award Conference Participation. Post-award conference participation (in person or by telephone) within 30 days after contract award. Payment, in the amount of $1500.00, for participation in the post-award conference satisfies the minimum guarantee for this contract. This amount appears in the summary tab and will be included as a firm fixed-price CLIN on any resultant contract. |
| c. Contractor Manpower Reporting (CMR). CMR is Not Separately Priced (NSP) and will be included as a separate NSP CLIN on any resultant contract. CMR is marked NSP on the summary tab. |
| 7. Document Protection. |
Certain columns in each of the 'Compensation Year' tabs , and the 'Regular Hourly Rate' columns on the 'Specialty Rates' tab are locked and password protected to protect values and embedded formulas. Offerors shall return this document intact. Do not attempt to unlock cells or change values or formulas in this document.
8. Additional Documentation.
The offeror shall provide and include documentation along with this attachment to support the data entered in the Compensation Year tabs. This data shall include but not be limited to:
| a. Description of the base data used to estimate the base labor rate |
| b. Explanation of why the offeror chose to use this base data for the proposal |
| c. Description of adjustment, if any, to the base data and why adjustments were appropriate |
| d. Narrative to fully describe each element and benefit offered |
Instructions 7 Jun 18 W81K04-18-R-0003 Attachment 9
Compensation Year 1
PHYSICIAN SPECIALTIES BASE
ANNUAL
| SALARY | ANNUAL |
| HEALTH | ANNUAL |
| MEDICARE | ANNUAL |
| FICA | ANNUAL |
| FUTA | ANNUAL |
| SUTA | ANNUAL |
WORKER
| COMP | ANNUAL |
| HOLIDAY | ANNUAL |
| PTO | ANNUAL |
| CME | ANNUAL |
RETIRE-
| MENT | OTHER |
| ANNUAL BENEFITS | TOTAL |
ANNUAL
FRINGE ANNUAL
FRINGE %
BASE ANNUAL
| SALARY + FRINGE BENEFITS | ANNUAL |
| PROFIT, G&A, and OTHER | TOTAL |
ANNUAL SALARY (Including Profit, G&A, and Other)
| CLIN 0002-FEE BASIS CHIEF MEDICAL OFFICER (PHYSICIAN) | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | |
| CLIN 0003-FEE BASIS PROVIDER PROFILER (PHYSICIAN) | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | |
| CLIN 0004-FEE BASIS PROVIDIER NON-PROFILER (PHSYCIAN) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0005-FEE BASIS PROVIDER NON-PROFILER (PHYSICIAN ASSISTANT) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0006-FEE BASIS PROVIDER NON-PROFILER (NURSE PRACTIIONER) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0007-FEE BASIS PROVIDER DPC-1 PHYSICIAN INITIAL TRAINING | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
Contractor's Name Cage Code
| Submission Due Date | &"-,Bold"&14 Compensation Plan |
| 7 Jun 18 | W81K04-18-R-0003 |
Page &P of &N
Compensation Year 2
PHYSICIAN SPECIALTIES BASE
ANNUAL
| SALARY | ANNUAL |
| HEALTH | ANNUAL |
| MEDICARE | ANNUAL |
| FICA | ANNUAL |
| FUTA | ANNUAL |
| SUTA | ANNUAL |
WORKER
| COMP | ANNUAL |
| HOLIDAY | ANNUAL |
| PTO | ANNUAL |
| CME | ANNUAL |
RETIRE-
| MENT | OTHER |
| ANNUAL BENEFITS | TOTAL |
ANNUAL
| FRINGE | ANNUAL |
| FRINGE % | BASE ANNUAL |
| SALARY + FRINGE BENEFITS | ANNUAL |
| PROFIT, G&A, and OTHER | TOTAL |
ANNUAL SALARY (Including Profit, G&A, and Other)
| CLIN 0002-FEE BASIS CHIEF MEDICAL OFFICER (PHYSICIAN) | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | |
| CLIN 0003-FEE BASIS PROVIDER PROFILER (PHYSICIAN) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0004-FEE BASIS PROVIDIER NON-PROFILER (PHSYCIAN) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0005-FEE BASIS PROVIDER NON-PROFILER (PHYSICIAN ASSISTANT) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0006-FEE BASIS PROVIDER NON-PROFILER (NURSE PRACTIIONER) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0007-FEE BASIS PROVIDER DPC-1 PHYSICIAN INITIAL TRAINING | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
Contractor's Name Cage Code
| Submission Due Date | &"-,Bold"&14 Compensation Plan |
| 7 Jun 18 | W81K04-18-R-0003 |
Page &P of &N
Compensation Year 3
PHYSICIAN SPECIALTIES BASE
ANNUAL
| SALARY | ANNUAL |
| HEALTH | ANNUAL |
| MEDICARE | ANNUAL |
| FICA | ANNUAL |
| FUTA | ANNUAL |
| SUTA | ANNUAL |
WORKER
| COMP | ANNUAL |
| HOLIDAY | ANNUAL |
| PTO | ANNUAL |
| CME | ANNUAL |
RETIRE-
| MENT | OTHER |
| ANNUAL BENEFITS | TOTAL |
ANNUAL
| FRINGE | ANNUAL |
| FRINGE % | BASE ANNUAL |
| SALARY + FRINGE BENEFITS | ANNUAL |
| PROFIT, G&A, and OTHER | TOTAL |
ANNUAL SALARY (Including Profit, G&A, and Other)
| CLIN 0002-FEE BASIS CHIEF MEDICAL OFFICER (PHYSICIAN) | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | |
| CLIN 0003-FEE BASIS PROVIDER PROFILER (PHYSICIAN) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0004-FEE BASIS PROVIDIER NON-PROFILER (PHSYCIAN) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0005-FEE BASIS PROVIDER NON-PROFILER (PHYSICIAN ASSISTANT) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0006-FEE BASIS PROVIDER NON-PROFILER (NURSE PRACTIIONER) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0007-FEE BASIS PROVIDER DPC-1 PHYSICIAN INITIAL TRAINING | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
Contractor's Name Cage Code
| Submission Due Date | &"-,Bold"&14 Compensation Plan |
| 7 Jun 18 | W81K04-18-R-0003 |
Page &P of &N
Compensation Year 4
PHYSICIAN SPECIALTIES BASE
ANNUAL
| SALARY | ANNUAL |
| HEALTH | ANNUAL |
| MEDICARE | ANNUAL |
| FICA | ANNUAL |
| FUTA | ANNUAL |
| SUTA | ANNUAL |
WORKER
| COMP | ANNUAL |
| HOLIDAY | ANNUAL |
| PTO | ANNUAL |
| CME | ANNUAL |
RETIRE-
| MENT | OTHER |
| ANNUAL BENEFITS | TOTAL |
ANNUAL
| FRINGE | ANNUAL |
| FRINGE % | BASE ANNUAL |
| SALARY + FRINGE BENEFITS | ANNUAL |
| PROFIT, G&A, and OTHER | TOTAL |
ANNUAL SALARY (Including Profit, G&A, and Other)
| CLIN 0002-FEE BASIS CHIEF MEDICAL OFFICER (PHYSICIAN) | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | |
| CLIN 0003-FEE BASIS PROVIDER PROFILER (PHYSICIAN) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0004-FEE BASIS PROVIDIER NON-PROFILER (PHSYCIAN) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0005-FEE BASIS PROVIDER NON-PROFILER (PHYSICIAN ASSISTANT) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0006-FEE BASIS PROVIDER NON-PROFILER (NURSE PRACTIIONER) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0007-FEE BASIS PROVIDER DPC-1 PHYSICIAN INITIAL TRAINING | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
Contractor's Name Cage Code
| Submission Due Date | &"-,Bold"&14 Compensation Plan |
| 7 Jun 18 | W81K04-18-R-0003 |
Page &P of &N
Compensation Year 5
PHYSICIAN SPECIALTIES BASE
ANNUAL
| SALARY | ANNUAL |
| HEALTH | ANNUAL |
| MEDICARE | ANNUAL |
| FICA | ANNUAL |
| FUTA | ANNUAL |
| SUTA | ANNUAL |
WORKER
| COMP | ANNUAL |
| HOLIDAY | ANNUAL |
| PTO | ANNUAL |
| CME | ANNUAL |
RETIRE-
| MENT | OTHER |
| ANNUAL BENEFITS | TOTAL |
ANNUAL
| FRINGE | ANNUAL |
| FRINGE % | BASE ANNUAL |
| SALARY + FRINGE BENEFITS | ANNUAL |
| PROFIT, G&A, and OTHER | TOTAL |
ANNUAL SALARY (Including Profit, G&A, and Other)
| CLIN 0002-FEE BASIS CHIEF MEDICAL OFFICER (PHYSICIAN) | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | |
| CLIN 0003-FEE BASIS PROVIDER PROFILER (PHYSICIAN) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0004-FEE BASIS PROVIDIER NON-PROFILER (PHSYCIAN) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0005-FEE BASIS PROVIDER NON-PROFILER (PHYSICIAN ASSISTANT) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0006-FEE BASIS PROVIDER NON-PROFILER (NURSE PRACTIIONER) | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
| CLIN 0007-FEE BASIS PROVIDER DPC-1 PHYSICIAN INITIAL TRAINING | $ - 0 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 |
Contractor's Name Cage Code
| Submission Due Date | &"-,Bold"&14 Compensation Plan |
| 7 Jun 18 | W81K04-18-R-0003 |
Page &P of &N
Specialty Rates
| SPECIALTY | YEAR 1 (CLINS 0002AA, 0003AA, 0004AA, 0005AA, 0006AA 0007AA) | YEAR 2 (CLINS 0002AB, 0003AB, 0004AB, 0005AB, 0006AB, 0007AB) | YEAR 3 (0003AA, 0003AB, 0003AC, 0003AD, 0003AE) | YEAR 4 (0004AA, 0004AB, 0004AC, 0004AD, 0004AE) | Year 5 (0005AA, 0005AB, 0005AC, 0005AD, 0005AE) | |||||||||||
| Regular Hrly Rate | Estimated Hours | Total | Regular Hrly Rate | Estimated Hours | Total | Regular Hrly Rate | Estimated Hours | Total | Regular Hrly Rate | Estimated Hours | Total | Regular Hrly Rate | Estimated Hours | Total | ||
| CLIN 0002AA-AE FEE BASIS CHIEF MEDICAL OFFICER (PHYSICIAN) | $0.00 | 50,000 | $0.00 | $0.00 | 50,000 | $0.00 | $0.00 | 50,000 | $0.00 | $0.00 | 50,000 | $0.00 | $0.00 | 50,000 | $0.00 | |
| CLIN 0003AA-AE FEE BASIS PROVIDER PROFILER (PHYSICIAN) | $0.00 | 170,000 | $0.00 | $0.00 | 170,000 | $0.00 | $0.00 | 170,000 | $0.00 | $0.00 | 170,000 | $0.00 | $0.00 | 170,000 | $0.00 | |
| CLIN 0004AA-AE FEE BASIS PROVIDIER NON-PROFILER (PHSYCIAN) | $0.00 | 25,000 | $0.00 | $0.00 | 25,000 | $0.00 | $0.00 | 25,000 | $0.00 | $0.00 | 25,000 | $0.00 | $0.00 | 25,000 | $0.00 | |
| CLIN 0005AA-AE FEE BASIS PROVIDER NON-PROFILER (PHYSICIAN ASSISTANT) | $0.00 | 3,500 | $0.00 | $0.00 | 3,500 | $0.00 | $0.00 | 3,500 | $0.00 | $0.00 | 3,500 | $0.00 | $0.00 | 3,500 | $0.00 | |
| CLIN 0006AA-AE FEE BASIS PROVIDER NON-PROFILER (NURSE PRACTIIONER) | $0.00 | 3,000 | $0.00 | $0.00 | 3,000 | $0.00 | $0.00 | 3,000 | $0.00 | $0.00 | 3,000 | $0.00 | $0.00 | 3,000 | $0.00 | |
| CLIN 0007AA-AE FEE BASIS PROVIDER DPC-1 PHYSICIAN INITIAL TRAINING | $0.00 | 6,000 | $0.00 | $0.00 | 6,000 | $0.00 | $0.00 | 6,000 | $0.00 | $0.00 | 6,000 | $0.00 | $0.00 | 6,000 | $0.00 | |
| YEAR 1 TOTAL | $ - 0 | YEAR 2 TOTAL | $ - 0 | YEAR 3 TOTAL | $ - 0 | YEAR 4 TOTAL | $ - 0 | YEAR 5 TOTAL | $ - 0 |
Contractor's Name Cage Code
| Submission Due Date | &"-,Bold"&14Physician Rates |
| 7 Jun 18 | W81K04-18-R-0003 |
Summary
| FEE BASIS PROVIDERS | |
| TRANSITION | NSP |
| YEAR 1 | $0.00 |
| YEAR 2 | $0.00 |
| YEAR 3 | $0.00 |
| YEAR 4 | $0.00 |
| YEAR 5 | $0.00 |
| Travel | $300,000.00 |
| Minimum Guaranteed Amount | $1,500.00 |
| Contractor Manpower Reporting | NSP |
| GRAND TOTAL | $301,500.00 |
Price Summary 7 Jun 18 W81K04-18-R-0003
File details come from the government source that posted it.