Attachment 5 - Price Proposal Workbook rvsd.xlsx
XLSX spreadsheet 53 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 contains a price proposal workbook template and instructions for a federal contract opportunity to provide medical coding and transcription services to the Defense Health Agency. Offerors are required to provide fully burdened labor rates and transcription rates for 10 labor categories over a 5-year period. The rates must be all-inclusive of taxes, fees, overhead, and profit. The workbook includes templates for offerors to populate their pricing for the base year and four option years. Notes columns allow offerors to explain their pricing approaches. The related opportunity notice identifies the solicitation number as HT001424R0004 to provide PAD Medical Coding and Transcription Services for the Defense Health Agency. No further details are provided on the opportunity in this document.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| RFP Q and A 11-29-23.pdf | ||
| HT001424R0004 PAD Medical Coders Solicitation.pdf | ||
| Attachment 2 - Past Performance Information Form (PPIF).docx | DOCX document | |
| Attachment 5 - Price Proposal Workbook.xlsx | XLSX spreadsheet | |
| Attachment 3 - Past Performance Recipient List.docx | DOCX document | |
| Attachment 1 - Performance Work Statement.pdf | ||
| Attachment 4 - Past Performance Questionnaire.docx | DOCX document |
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 |
FA0021-16-R-0040
Attachment 3 27 October 2016
&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
&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 .