Attachment 5 - Price Proposal Workbook rvsd2.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 contains a price proposal workbook and related federal contract opportunity for medical coding and transcription services. The price proposal workbook provides templates for offerors to submit pricing for medical coding labor categories and transcription services for a base year and four option years. Pricing tables include fill-in fields for fully burdened labor rates by labor category and year. The federal contract opportunity is a competitive 8(a) solicitation from the Defense Health Agency Contracting Activity Northeastern Markets Contracting Division for management of medical records support and transcription services at Walter Reed National Military Medical Center. The firm-fixed price, performance-based contract will have a one-year base period and four one-year options, with an anticipated award date of January 26, 2024. The NAICS code is 541219 for other accounting services and the small business size standard is $25,000,000. Questions are due by December 15, 2023 regarding the requirement to provide all necessary personnel, equipment and supplies to perform the services defined in the attached performance work statement, excluding government furnished property and services.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| HT001424R0004-0003.pdf | ||
| HT001424R0004 Amendment 0002.pdf | ||
| HT001424R0004 RFP Q and A 22Dec2023.pdf | ||
| Attachment 1 - PWS for PAD Medical Coders 22Dec2023.pdf | ||
| HT001424R0004 Conformed Copy 22Dec2023.pdf | ||
| HT001424R0004-0001.pdf | ||
| HT001424R0004 Conformed Copy.pdf | ||
| HT001424R0004 Solicitation.pdf | ||
| RFP Q and A 12-08-23.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 | |
| Attachment 5 - Price Proposal Workbook rvsd.xlsx | XLSX spreadsheet |
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 | 35,000 | $0.00 | $ - 0 | 35,000 | $0.00 | $ - 0 | 35,000 | $0.00 | $ - 0 | 35,000 | $0.00 | $ - 0 | 35,000 | $0.00 | $ - 0 | 17,500 | $0.00 | $ - 0 | $ - 0 | ||
| TOTAL EVALUATED PRICE | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
HT001424R0004
Attachment 5 22 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 .