Attachment 5 - Price Proposal Workbook.xlsx
XLSX spreadsheet 60 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 templates for a price proposal workbook and consolidated fully burdened labor rates for a federal contract opportunity to provide PAD Medical Coders and Transcription Services to the Defense Health Agency. The templates require offerors to provide pricing details for medical coding and transcription labor categories for a base year and four option years. Pricing cells in the templates are blank and require offerors to input fully burdened labor rates inclusive of elements such as labor rates, fringe benefits, overhead, G&A, profit, and FCCOM. Notes columns allow offerors to explain their pricing approach and any subcontracting arrangements. The related federal contract opportunity is solicitation number HT001424R0004 to provide PAD Medical Coders and Transcription Services for the Defense Health Agency.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| RFP Q and A 11-29-23.pdf | ||
| Attachment 5 - Price Proposal Workbook rvsd.xlsx | XLSX spreadsheet | |
| HT001424R0004 PAD Medical Coders Solicitation.pdf | ||
| Attachment 2 - Past Performance Information Form (PPIF).docx | DOCX document | |
| Attachment 1 - Performance Work Statement.pdf | ||
| Attachment 4 - Past Performance Questionnaire.docx | DOCX document | |
| Attachment 3 - Past Performance Recipient List.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 "Summary" sheet/tab. 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 | 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 | ||||
| A*B*C | A*E*F | A*H*I | A*K*L | A*N*O | A*Q*R | Sum (D,G,J,M,P,S) | |||||||||||||||||
| 0001 | Inpatient Coder | 1-Feb-24 | 4 | 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 | |
| 0002 | Outpatient Coder | 1-Feb-24 | 44 | 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 | |
| 0003 | IPSR Coder | 1-Feb-24 | 4 | 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 | |
| 0004 | APV Coder | 1-Feb-24 | 4 | 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 | |
| 0005 | ER Coder | 1-Feb-24 | 3 | 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 | |
| 0006 | Anesthesia Coder | 1-Feb-24 | 3 | 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 | |
| 0007 | Inpatient Consults Coder | 1-Feb-24 | 2 | 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 | |
| 0008 | Transcription Services | 1-Feb-24 | 1 | 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
DRAFT
SUMMARY
| Fully Burdened Labor Rates and Premium Rates |
| Special Tactics Air Traffic Control (STATC) Training |
| AFICA / 765 SCONF |
| Negotiated FBLR and Premium Pay |
| SUMMARY |
**The summary page(s) will be incorporated into the resulting contract**
RATES SHALL BE INCLUSIVE OF ALL APPLICABLE TAXES, FEES, OVERHEAD, AND PROFIT.
- Auto Calculated Field(s)
| CLIN | Labor Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
| 0001 | to | 4001 | Inpatient Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0002 | to | 4002 | Outpatient Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0003 | to | 4003 | IPSR Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0004 | to | 4004 | APV Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0005 | to | 4005 | ER Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0006 | to | 4006 | Anesthesia Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0007 | to | 4007 | Inpatient Consults Coder | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 0008 | to | 4008 | Transcription Services | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
27 October 2016
&P of &N
DRAFT
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
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) | |||||||||
| 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 |
| 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
27 October 2016
&P of &N
DRAFT
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) | |||||||||
| 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 | $ - 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 |
| 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
27 October 2016
&P of &N
DRAFT
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) | |||||||||
| 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 | $ - 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 |
| 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
27 October 2016
&P of &N
DRAFT
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) | |||||||||
| 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 | $ - 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 |
| 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
27 October 2016
&P of &N
DRAFT
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) | |||||||||
| 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 | $ - 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 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
27 October 2016
&P of &N
DRAFT
File details come from the government source that posted it. Updated .