Attachment 5 - Price Proposal Workbook rvsd.xlsx
XLSX spreadsheet 50 KB Posted
- Attached to
- PAD Medical Coders and Transcription Services Federal contract opportunity
- Solicitation number
- HT001424R0004
- Issued by
- Defense Health Agency
About this file
This document is a price proposal workbook template for a federal contract solicitation seeking medical coding and transcription services. The opportunity is solicitation number HT001424R0004 issued by the Defense Health Agency. The template provides instructions and tables for offerors to submit fully burdened labor rates for various coding and management labor categories over a five year base period and four one-year options. Pricing is required for inpatient, outpatient, anesthesia and other medical coders as well as transcription services. Notes columns allow offerors to explain proprietary information or pricing strategies. Related details include labor categories, service periods, and evaluation criteria.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| HT001424R0004 Conformed Copy 22Dec2023.pdf | ||
| Attachment 5 - Price Proposal Workbook rvsd2.xlsx | XLSX spreadsheet | |
| HT001424R0004 RFP Q and A 22Dec2023.pdf | ||
| Attachment 1 - PWS for PAD Medical Coders 22Dec2023.pdf | ||
| HT001424R0004-0003.pdf | ||
| HT001424R0004 Amendment 0002.pdf | ||
| HT001424R0004 Conformed Copy.pdf | ||
| HT001424R0004-0001.pdf | ||
| Attachment 1 - PWS for PAD Medical Coders 8Dec2023.pdf | ||
| Attachment 2 - Past Performance Information Form (PPIF).docx | DOCX document | |
| Attachment 3 - Past Performance Recipient List.docx | DOCX document | |
| Attachment 4 - Past Performance Questionnaire.docx | DOCX document | |
| HT001424R0004 Solicitation.pdf | ||
| RFP Q and A 12-08-23.pdf |
Show all 14
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
TEP Sheet
| PAD MEDICAL CODERS AND TRANSCRIPTION SERVICES |
| DHACA NM-CD |
| TOTAL EVALUATED PRICE WORKSHEET |
Note(s) and Instruction(s): This table is for evaluation purposes only and will be used to rank offers IAW FAR 52.212-2, Evaluation - Commercial Items, and its addendum detailed in SF 1449. Information presented here are automatically filled based on information provided in the subsequent sheets/tabs. Offeror is to complete the fill-in fields on this sheet.
This table is color coded as defined below
- Fill-in Field(s) - Pre-determined value.
- Auto-calculated Field(s) - Total Evaluated Price (Auto-calculated Field)
| CLIN | PWS LABOR CATEGORY | PWS Para. | Start Date | BASE YEAR (YEAR 1) | OPTION 1 (YEAR 2) | OPTION 2 (YEAR 3) | OPTION 3 (YEAR 4) | OPTION 4 (YEAR 5) | FAR 52.215-8 Option | % Subcontracted | ||||||||||||||
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |||||
| FTEs | Hours or Qty | FBLR or Rate | Proposed Price | Hours | FBLR or Rate | Proposed Price | Hours | FBLR or Rate | Proposed Price | Hours | FBLR or Rate | Proposed Price | Hours | FBLR or Rate | Proposed Price | Hours | FBLR or Rate | Proposed Price | TOTAL | |||||
| B*C | E*F | H*I | K*L | N*O | Q*R | Sum (D,G,J,M,P,S) | ||||||||||||||||||
| Hours per FTE | 1,920 | 1912 | 1912 | 1912 | 1920 | 960 | ||||||||||||||||||
| 0001 | Inpatient Coder | 5.5 | 1-Feb-24 | 4 | 7,680 | $0.00 | $ - 0 | 7648 | $0.00 | $ - 0 | 7648 | $0.00 | $ - 0 | 7648 | $0.00 | $ - 0 | 7680 | $0.00 | $ - 0 | 3840 | $0.00 | $ - 0 | $ - 0 | |
| 0002 | Outpatient Coder | 5.6 | 1-Feb-24 | 44 | 84,480 | $0.00 | $ - 0 | 84128 | $0.00 | $ - 0 | 84128 | $0.00 | $ - 0 | 84128 | $0.00 | $ - 0 | 84480 | $0.00 | $ - 0 | 42240 | $0.00 | $ - 0 | $ - 0 | |
| 0003 | IPSR Coder | 5.6 | 1-Feb-24 | 4 | 7,680 | $0.00 | $ - 0 | 7648 | $0.00 | $ - 0 | 7648 | $0.00 | $ - 0 | 7648 | $0.00 | $ - 0 | 7680 | $0.00 | $ - 0 | 3840 | $0.00 | $ - 0 | $ - 0 | |
| 0004 | Day Surgery Coder | 5.5 | 1-Feb-24 | 4 | 7,680 | $0.00 | $ - 0 | 7648 | $0.00 | $ - 0 | 7648 | $0.00 | $ - 0 | 7648 | $0.00 | $ - 0 | 7680 | $0.00 | $ - 0 | 3840 | $0.00 | $ - 0 | $ - 0 | |
| 0005 | ED Coder | 5.6 | 1-Feb-24 | 3 | 5,760 | $0.00 | $ - 0 | 5736 | $0.00 | $ - 0 | 5736 | $0.00 | $ - 0 | 5736 | $0.00 | $ - 0 | 5760 | $0.00 | $ - 0 | 2880 | $0.00 | $ - 0 | $ - 0 | |
| 0006 | Anesthesia Coder | 5.6 | 1-Feb-24 | 3 | 5,760 | $0.00 | $ - 0 | 5736 | $0.00 | $ - 0 | 5736 | $0.00 | $ - 0 | 5736 | $0.00 | $ - 0 | 5760 | $0.00 | $ - 0 | 2880 | $0.00 | $ - 0 | $ - 0 | |
| 0007 | Inpatient Consults Coder | 5.6 | 1-Feb-24 | 2 | 3,840 | $0.00 | $ - 0 | 3824 | $0.00 | $ - 0 | 3824 | $0.00 | $ - 0 | 3824 | $0.00 | $ - 0 | 3840 | $0.00 | $ - 0 | 1920 | $0.00 | $ - 0 | $ - 0 | |
| 0008 | Site Manager | 5.2 & 5.4 | 1-Feb-24 | 1 | 1,920 | $0.00 | $ - 0 | 1912 | $0.00 | $ - 0 | 1912 | $0.00 | $ - 0 | 1912 | $0.00 | $ - 0 | 1920 | $0.00 | $ - 0 | 960 | $0.00 | $ - 0 | $ - 0 | |
| 0009 | Deputy Site Manager | 5.2 & 5.4 | 1-Feb-24 | 1 | 1,920 | $0.00 | $ - 0 | 1912 | $0.00 | $ - 0 | 1912 | $0.00 | $ - 0 | 1912 | $0.00 | $ - 0 | 1920 | $0.00 | $ - 0 | 960 | $0.00 | $ - 0 | $ - 0 | |
| 0010 | Transcription Services | 5.7 | 1-Feb-24 | 200,000 | $0.00 | $ - 0 | 200,000 | $0.00 | $ - 0 | 200,000 | $0.00 | $ - 0 | 200,000 | $0.00 | $ - 0 | 200,000 | $0.00 | $ - 0 | 100,000 | $0.00 | $ - 0 | $ - 0 | ||
| TOTAL EVALUATED PRICE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
HT001424R0004
Attachment 5 8 December 2023
&P of &N
Consolidated
| Fully Burdened Labor Rates and Transcription Rates |
| PAD Medical Coders and Transcription Services |
| DHACA NM-CD |
| BASE YEAR (YEAR 1) |
This table is color coded defined as: - Auto Calculated Field(s) - Fill-in Field(s)
NOTE: Offerors may alter formulas in this spreadsheet to match offeror's pricing strategy and annotate it accordingly. Use Column H for any notes that will assist Government Price Evaluators in completing Price Analysis IAW FAR 52.212-1 Addendum and FAR 52.212-2 Addendum of the RFP.
RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT.
| BASE YEAR (YEAR 1) | |||||||||
| A | B | C | D | E | F | G | H | ||
| CLIN | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | ||||
| Identify Fringe, G&A, Profit Rates | |||||||||
| 0001 | Inpatient Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 0002 | Outpatient Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | B | |
| 0003 | IPSR Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 0004 | APV Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 0005 | ER Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 0006 | Anesthesia Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 0007 | Inpatient Consults Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 0008 | Transcription Services | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| OPTION 1 (YEAR 2) | |||||||||
| A | B | C | D | E | F | G | H | ||
| # | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | ||||
| Identify Fringe, G&A, Profit Rates | |||||||||
| 1001 | Inpatient Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 1002 | Outpatient Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | B | |
| 1003 | IPSR Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1004 | APV Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1005 | ER Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1006 | Anesthesia Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1007 | Inpatient Consults Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1008 | Transcription Services | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| OPTION 2 (YEAR 3) | |||||||||
| A | B | C | D | E | F | G | H | ||
| # | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | ||||
| Identify Fringe, G&A, Profit Rates | |||||||||
| 2001 | Inpatient Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 2002 | Outpatient Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | B | |
| 2003 | IPSR Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2004 | APV Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2005 | ER Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2006 | Anesthesia Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2007 | Inpatient Consults Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2008 | Transcription Services | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| OPTION 3 (YEAR 4) | |||||||||
| A | B | C | D | E | F | G | H | ||
| # | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | ||||
| Identify Fringe, G&A, Profit Rates | |||||||||
| 3001 | Inpatient Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 3002 | Outpatient Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | B | |
| 3003 | IPSR Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3004 | APV Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3005 | ER Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3006 | Anesthesia Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3007 | Inpatient Consults Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3008 | Transcription Services | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| OPTION 4 (YEAR 5) | |||||||||
| A | B | C | D | E | F | G | H | ||
| # | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | ||||
| Identify Fringe, G&A, Profit Rates | |||||||||
| 4001 | Inpatient Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 4002 | Outpatient Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | B | |
| 4003 | IPSR Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4004 | APV Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4005 | ER Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4006 | Anesthesia Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4007 | Inpatient Consults Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4008 | Transcription Services | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Notes to Fully Burdened Labor Rates and Premium Rates for Base Year (Year 1) | |
| A | Enter note(s) here associated with marked line item. For example, "Subcontracted to XYZ Company. Fringe, OH, G&A, and Profit of Subcontractor is proprietary information. Formulas adjusted accordingly." |
B Enter note(s) here associated with marked line item(s). For example, "Offeror will not apply OH and Profit on these line items as a pricing strategy. Further explained in Volume II, paragraph XX, of our proposal."
C
D
FA0021-16-R-0040
Attachment 3 27 October 2016
&P of &N
Year 1
| Fully Burdened Labor Rates and Transcription Rates |
| PAD Medical Coders and Transcription Services |
| DHACA NM-CD |
| BASE YEAR (YEAR 1) |
This table is color coded defined as: - Auto Calculated Field(s) - Fill-in Field(s)
NOTE: Offerors may alter formulas in this spreadsheet to match offeror's pricing strategy and annotate it accordingly. Use Column H for any notes that will assist Government Price Evaluators in completing Price Analysis IAW FAR 52.212-1 Addendum and FAR 52.212-2 Addendum of the RFP.
RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT.
| BASE YEAR (YEAR 1) | ||||||||||
| PWS Para. | A | B | C | D | E | F | G | H | ||
| CLIN | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES | |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | |||||
| Identify Fringe, G&A, Profit Rates | ||||||||||
| 0001 | Inpatient Coder | 5.5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 0002 | Outpatient Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | B | |
| 0003 | IPSR Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 0004 | Day Surgery | 5.5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 0005 | ER Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 0006 | Anesthesia Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 0007 | Inpatient Consults Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 0008 | Site Manager | 5.2 & 5.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 0009 | Deputy Site Manager | 5.2 & 5.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 0010 | Transcription Services | 5.7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Notes to Fully Burdened Labor Rates and Premium Rates for Base Year (Year 1) | |
| A | Enter note(s) here associated with marked line item. For example, "Subcontracted to XYZ Company. Fringe, OH, G&A, and Profit of Subcontractor is proprietary information. Formulas adjusted accordingly." |
B Enter note(s) here associated with marked line item(s). For example, "Offeror will not apply OH and Profit on these line items as a pricing strategy. Further explained in Volume II, paragraph XX, of our proposal."
C
D
&P of &N
Year 2
| Fully Burdened Labor Rates and Premium Rates |
| PAD Medical Coders and Transcription Services |
| DHACA NM-CD |
| OPTION 1 (YEAR 2) |
This table is color coded defined as: - Auto Calculated Field(s) - Fill-in Field(s)
NOTE: Offerors may alter formulas in this spreadsheet to match offeror's pricing strategy and annotate it accordingly. Use Column H for any notes that will assist Government Price Evaluators in completing Price Analysis IAW FAR 52.212-1 Addendum and FAR 52.212-2 Addendum of the RFP.
RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT.
| OPTION 1 (YEAR 2) | ||||||||||
| PWS Para. | A | B | C | D | E | F | G | H | ||
| # | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES | |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | |||||
| 1 | Identify Fringe, G&A, Profit Rates | |||||||||
| 1001 | Inpatient Coder | 5.5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 1002 | Outpatient Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | B | |
| 1003 | IPSR Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1004 | Day Surgery | 5.5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1005 | ER Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1006 | Anesthesia Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1007 | Inpatient Consults Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1008 | Site Manager | 5.2 & 5.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1009 | Deputy Site Manager | 5.2 & 5.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1010 | Transcription Services | 5.7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Notes to Fully Burdened Labor Rates and Premium Rates for Option 1 (Year 2) | |
| A | Enter note(s) here associated with marked line item. For example, "Subcontracted to XYZ Company. Fringe, OH, G&A, and Profit of Subcontractor is proprietary information. Formulas adjusted accordingly." |
B Enter note(s) here associated with marked line item(s). For example, "Offeror will not apply OH and Profit on these line items as a pricing strategy. Further explained in Volume II, paragraph XX, of our proposal."
C
D
&P of &N
Year 3
| Fully Burdened Labor Rates and Premium Rates |
| PAD Medical Coders and Transcription Services |
| DHACA NM-CD |
| OPTION 2 (YEAR 3) |
This table is color coded defined as: - Auto Calculated Field(s) - Fill-in Field(s)
NOTE: Offerors may alter formulas in this spreadsheet to match offeror's pricing strategy and annotate it accordingly. Use Column H for any notes that will assist Government Price Evaluators in completing Price Analysis IAW FAR 52.212-1 Addendum and FAR 52.212-2 Addendum of the RFP.
RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT.
| OPTION 2 (YEAR 3) | ||||||||||
| PWS Para. | A | B | C | D | E | F | G | H | ||
| # | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES | |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | |||||
| 1 | Identify Fringe, G&A, Profit Rates | |||||||||
| 2001 | Inpatient Coder | 5.5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 2002 | Outpatient Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | B | |
| 2003 | IPSR Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2004 | Day Surgery | 5.5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2005 | ER Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2006 | Anesthesia Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2007 | Inpatient Consults Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2008 | Site Manager | 5.2 & 5.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2009 | Deputy Site Manager | 5.2 & 5.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2010 | Transcription Services | 5.7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Notes to Fully Burdened Labor Rates and Premium Rates for Option 2 (Year 3) | |
| A | Enter note(s) here associated with marked line item. For example, "Subcontracted to XYZ Company. Fringe, OH, G&A, and Profit of Subcontractor is proprietary information. Formulas adjusted accordingly." |
B Enter note(s) here associated with marked line item(s). For example, "Offeror will not apply OH and Profit on these line items as a pricing strategy. Further explained in Volume II, paragraph XX, of our proposal."
C
D
&P of &N
Year 4
| Fully Burdened Labor Rates and Premium Rates |
| PAD Medical Coders and Transcription Services |
| DHACA NM-CD |
| OPTION 3 (YEAR 4) |
This table is color coded defined as: - Auto Calculated Field(s) - Fill-in Field(s)
NOTE: Offerors may alter formulas in this spreadsheet to match offeror's pricing strategy and annotate it accordingly. Use Column H for any notes that will assist Government Price Evaluators in completing Price Analysis IAW FAR 52.212-1 Addendum and FAR 52.212-2 Addendum of the RFP.
RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT.
| OPTION 3 (YEAR 4) | ||||||||||
| PWS Para. | A | B | C | D | E | F | G | H | ||
| # | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES | |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | |||||
| 1 | Identify Fringe, G&A, Profit Rates | |||||||||
| 3001 | Inpatient Coder | 5.5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 3002 | Outpatient Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | B | |
| 3003 | IPSR Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3004 | Day Surgery | 5.5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3005 | ER Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3006 | Anesthesia Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3007 | Inpatient Consults Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3008 | Site Manager | 5.2 & 5.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3009 | Deputy Site Manager | 5.2 & 5.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3010 | Transcription Services | 5.7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Notes to Fully Burdened Labor Rates and Premium Rates for Option 3 (Year 4) | |
| A | Enter note(s) here associated with marked line item. For example, "Subcontracted to XYZ Company. Fringe, OH, G&A, and Profit of Subcontractor is proprietary information. Formulas adjusted accordingly." |
B Enter note(s) here associated with marked line item(s). For example, "Offeror will not apply OH and Profit on these line items as a pricing strategy. Further explained in Volume II, paragraph XX, of our proposal."
C
D
&P of &N
Year 5
| Fully Burdened Labor Rates and Premium Rates |
| PAD Medical Coders and Transcription Services |
| DHACA NM-CD |
| OPTION 4 (YEAR 5) |
This table is color coded defined as: - Auto Calculated Field(s) - Fill-in Field(s)
NOTE: Offerors may alter formulas in this spreadsheet to match offeror's pricing strategy and annotate it accordingly. Use Column H for any notes that will assist Government Price Evaluators in completing Price Analysis IAW FAR 52.212-1 Addendum and FAR 52.212-2 Addendum of the RFP.
RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT.
| OPTION 1 (YEAR 2) | ||||||||||
| PWS Para. | A | B | C | D | E | F | G | H | ||
| # | Labor Category | Base Rate | Fringe | OH | G & A | Profit or Fee | FCCOM | FBLR | NOTES | |
| A * B1 | Sum(A:B)*C1 | Sum(A:C)*D1 | Sum(A:D)*E1 | Sum(A:E)*F1 | Sum(A:F) | |||||
| 1 | Identify Fringe, G&A, Profit Rates | |||||||||
| 4001 | Inpatient Coder | 5.5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | A | |
| 4002 | Outpatient Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | B | |
| 4003 | IPSR Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4004 | Day Surgery | 5.5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4005 | ER Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4006 | Anesthesia Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4007 | Inpatient Consults Coder | 5.6 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4008 | Site Manager | 5.2 & 5.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4009 | Deputy Site Manager | 5.2 & 5.4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4010 | Transcription Services | 5.7 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Notes to Fully Burdened Labor Rates and Premium Rates for Option 5 (Year 5) | |
| A | Enter note(s) here associated with marked line item. For example, "Subcontracted to XYZ Company. Fringe, OH, G&A, and Profit of Subcontractor is proprietary information. Formulas adjusted accordingly." |
B Enter note(s) here associated with marked line item(s). For example, "Offeror will not apply OH and Profit on these line items as a pricing strategy. Further explained in Volume II, paragraph XX, of our proposal."
C
D
&P of &N
File details come from the government source that posted it. Updated .