J-07 Basis of Estimate.xlsx

XLSX spreadsheet 72 KB Posted

Attached to
DME MAC Jurisdiction A Federal contract opportunity
Solicitation number
RFP-CMS-2010-0004
Issued by
Department of Health and Human Services Centers for Medicare and Medicaid Services

About this file

J-07 Basis of Estimate

View the file

Other files for this federal contract opportunity

Other files attached to DME MAC Jurisdiction A, newest first.
File Type Posted
J-16_CLIN_0007_Cost_Proposal_Templates_Close_Out_Period.xls XLS spreadsheet
J-14_CLIN_0005_Cost_Proposal_Templates_Option_Period_3.xlsx XLSX spreadsheet
J-5_GFP-GFI_DME_MAC JA.xlsx XLSX spreadsheet
Amendment 000002 JA.docx DOCX document
J-11_CLIN_0002_Cost_Proposal_Templates_Base_Period.xlsx XLSX spreadsheet
J-10_CLIN_0001_Cost_Proposal_Templates_Implementation.xls XLS spreadsheet
J-12_CLIN_0003_Cost_Proposal_Templates_Option_Period_1.xlsx XLSX spreadsheet
RFP-CMS-2010-0004_DME MAC Juris A RFP Q As_ 01_28_10.xls XLS spreadsheet
J-12_CLIN_0003_Cost_Proposal_Templates_Option_Period_1.xls XLS spreadsheet
J-10_CLIN_0001_Cost_Proposal_Templates_Implementation.xlsx XLSX spreadsheet
Attachment J-19 Implementation Handbook redline.doc DOC document
J-15_CLIN_0006_Cost_Proposal_Templates_Option_Period_4.xlsx XLSX spreadsheet
J-13_CLIN_0004_Cost_Proposal_Templates_Option_Period_2.xls XLS spreadsheet
J-13_CLIN_0004_Cost_Proposal_Templates_Option_Period_2.xlsx XLSX spreadsheet
J-15_CLIN_0006_Cost_Proposal_Templates_Option_Period_4.xls XLS spreadsheet
J-14_CLIN_0005_Cost_Proposal_Templates_Option_Period_3.xls XLS spreadsheet
J-16_CLIN_0007_Cost_Proposal_Templates_Close_Out_Period.xlsx XLSX spreadsheet
J-02_Deliverables_DME_MAC_redline.xlsx XLSX spreadsheet
Amendment 00002.pdf PDF
J-11_CLIN_0002_Cost_Proposal_Templates_Base_Period.xls XLS spreadsheet
Amendment 00001 JA.docx DOCX document
J-25_TravelTemplate JA.xlsx XLSX spreadsheet
RFP-CMS-2010-0004_Jurisdiction A_SF30_Amendment 1.pdf PDF
J-13 CLIN 0004 Cost Proposal Templates Option Period 2.xlsx XLSX spreadsheet
J-01 Statement of Work 12-22-09.docx DOCX document
J-09_Cost Proposal Instructions.xls XLS spreadsheet
J-02 Deliverables_DME MAC.xlsx XLSX spreadsheet
J-01B SoW appendices.doc DOC document
J-10 CLIN 0001 Cost Proposal Templates Implementation.xlsx XLSX spreadsheet
J-05 GFP-GFI_DME MAC.xlsx XLSX spreadsheet
J-03 SmallBusinessSubcontractingPlan.doc DOC document
DME MAC JA Section B thru M 12-30-09.docx DOCX document
J-15 CLIN 0006 Cost Proposal Templates Option Period 4.xlsx XLSX spreadsheet
J-06 Sample Award fee Plan —
J-22 Contractors Guide for Gov Property 12 09 08.pdf PDF
J-01A MAC Shared System BaseNonbase.doc DOC document
J-12 CLIN 0003 Cost Proposal Templates Option Period 1.xlsx XLSX spreadsheet
J-24_DirectionsToCentralOffice.pdf PDF
Solicitation DME MAC A_coverletter.docx DOCX document
RFP-CMS-2010-0004_Jurisdiction A_SF33.pdf PDF
J-11 CLIN 0002 Cost Proposal Templates Base Period.xlsx XLSX spreadsheet
J-08 PastPerformanceQuestionnaire.doc DOC document
J-18 NonDisclosure Statement.doc DOC document
J-16 CLIN 0007 Cost Proposal Templates Close Out Period.xlsx XLSX spreadsheet
J-04 Billing Instructions.doc DOC document
J-01AA Base Reports PSCs ZPICs Need.xlsx XLSX spreadsheet
J-21 Corporate Experience Attestation.doc DOC document
J-14 CLIN 0005 Cost Proposal Templates Option Period 3.xlsx XLSX spreadsheet
J-17 Proposal Checklist.doc DOC document
J-20 Information Security Attestation.docx DOCX document
Show all 50

DME MAC Jurisdiction A has more files on GovTribe.

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

Instructions

DME MAC Business Proposal
Basis of Estimate - Template Instructions
To provide CMS with an understanding of the Offeror's basis of estimate, the Offeror shall complete this template for the Base Year and Option Year One as part of its Volume II submission. CMS is providing instructions to the Offeror for populating this template below. In addition, CMS has provided a sample calculation for the Offeror under the Base Year Tab.
Column A,
Cost Estimating FactorThe first column of the spreadsheet has the workload categories identified in RFP section L. Note: In instances where Section L describes "provider counts" (i.e., Provider Customer Service), the Offeror shall provide the workload assumptions used in its Proposal based on the number of providers identified in the RFP. The Offeror shall insert a separate row for each workload category under the high-level workload category (shaded in grey) provided in the template.The Offeror shall copy and paste the FTE calculation formula in Column G for each inserted row. Also, the Offeror shall insert its proposed workload (by category) identified in its Medical Review Strategy (Tab F, Volume I) for Automated Reviews under the Medical Review heading. At a minimum, the Offeror shall include the categories identified in this Attachment. However, the Offeror is instructed to insert additional rows for Automated Reviews as necessary based on the categories proposed in its Medical Review Strategy. The Offeror shall copy and paste any formulas in the worksheet for each inserted row.
Column B,
Annual WorkloadThe Offeror shall identify the RFP workloads for each cost estimating factor subheading in either light blue or grey (see the example provided in Red under the Base Year Tab). The Offeror shall also provide the annual workload for each workload category using Column B. The annual workload represents the portion of the total functional workload that is projected to be impacted by the specific labor category in Column B (Position / Labor Category). For example, if Claims Analyst I performs some function in handling all paper claims, the workload touched by this position would equate to the total paper claims volume. However, if Claims Analyst I only handles 75% of paper claims, with 25% handled by a Claims Analyst II, this would be reflected in a workload number 75% of that quoted in the RFP Section L. Any workloads listed must tie back to those identified in Section L of the RFP. NOTE: A formula is provided in the template to calculate the workload for each labor category following each sub-heading shaded light blue or grey. However, the Offeror shall ensure that the formula is updated to reflect any new/inserted rows.
Column C,
% Workload Processed with Direct LaborFor each workload category identified in Column A, the Offeror shall identify in Column C the percentage of the annual workload (Column B) that will be processed using direct labor.
Column D,
Position/Labor CategoryFor each workload category identified in Column A, the Offeror shall identify in Column D all positions/labor catagories required to meet the functional requirements of the statement of work. Each position/labor category shall be displayed using a separate row. Note: This may require the Offeror to insert additional rows. The Offeror shall copy and paste all formulas in the worksheet for each inserted row. For manager and supervisor positions/labor categories, the Offeror is instructed to adjust formulas as needed and insert the FTEs based its own proposal assumptions.
Column E,
Annual Productive HoursThe Offeror shall provide the annual productive hours for each position/labor category (identified in Column D) using Column E.
Column F,
Daily Production per FTEThe Offeror shall provide the workload that can be accomplished by one (1) FTE in one (1) business day using Column E. For this template, one (1) business day is defined as eight (8) hours. For example, if Claims Analyst I requires an average of 24 minutes to complete the position-specific tasks for a single paper claim, the Daily Production per FTE for this position would be 20 paper claims (2.5 claims per hour x 8 hours in a day).
Column G,
Total FTEsColumn G contains a formula (in unshaded rows only) to automatically calculated total FTEs for each position/labor category provided by the Offeror. This should reflect the CLIN templates submitted with the Offeror's Business Proposal. Note: For all high-level workload headings (dark blue shading) and sub-headings (light blue or grey), the offeror shall provide a sum of the total FTEs (see example provided under the Base Year tab).
Column H,
% Workload Processed by Indirect Cost CenterWhere applicable, for each workload category identified in Column A, the Offeror shall identify in Column H the percentage of the annual workload (Column B) that will be processed by an Indirect Cost Center.
Column I,
CLIN Template CrosswalkThe Offeror shall provide a crosswalk to the CLIN templates for the FTEs identified for each workload category using Column I.
Column J,
Basis of EstimateThe Offeror shall specify whether the proposed productivity for each labor category is based on its history, or if it is based on a new innovation and/or process improvement proposed for this contract. The Offeror shall also crosswalk any referenced new innovation and/or process improvement in this column to the page, tab, and Volume of its Proposal that contains the narrative describing this innovation/process improvement (e.g., Volume I, Tab G, page 26). In addition, if the basis of the Offeror's proposed productivity is its history, which includes an implemented innovation and/or process improvement referenced in another section of its Proposal, the Offeror shall also crosswalk this to the page, tab, and Volume of its Proposal that contains the applicable narrative to support this implemented innovation and/or process improvement. Note: For the Bills/Claims workload, the Offeror shall notate the Suspence rates used in development of their Bills/Claims productivity estimates for both EMC and Paper claims using the light blue sub-headings (see example provided under the Base Year tab).
NOTE: The Offeror shall only provide Attachment J-03 via CD-ROM. The Offeror shall not submit hard copies of this document.

RFP-CMS-2010-0004

DURABLE MEDICAL EQUIPMENT (DME) MEDICARE ADMINISTRATIVE CONTRACTOR (MAC)

Attachment J-03 Basis of Estimate Source Selection Information - See FAR 2.101 and 3.104 &P

Base Year

J_ DME MAC Volume II
Basis of Estimate - Base Year
Example
Cost Estimating FactorAnnual
Workload1% Workload Processed with Direct LaborPosition/Labor CategoryAnnual Productive
Hours2Daily Production per FTE2Total FTEs% Workload Processed with Indirect Cost CenterCLIN Template CrosswalkBasis of Estimate
Bills/Claims54.41
Bills Claims - EMC6,121,9550.01History - EMC suspense rate of 16% based on implemented edits in 2008 (see page 15, Tab E, Volume I)
Bills/Claims - EMC9,7950.16%Claims Analyst I1,864.003,200.000.01All CLIN 0002, SLINAA, SOW D.1.2History - EMC suspense rate of 16% based on implemented edits in 2008 (see page 15, Tab E, Volume I)
Bills Claims - Paper145,52451.53New - Paper suspense rate of 9% on new OCR technology (see page 20, Tab E, Volume I)
Bills/Claims - Paper50,93335.00%Claims Analyst I1,864.0020.0010.93All CLIN 0002, SLINAA, SOW D.1.2History - Based on new OCR technology implemented in 2007 (see page 17, Tab E, Volume I)
Bills/Claims - Paper94,59165.00%Claims Analyst II1,864.0010.0040.60All CLIN 0002, SLINAA, SOW D.1.2History - Based on automated process flow implemented in 2006 (see page 17, Tab E, Volume I)
Claims Backlog - Pending Claims1,556,1292.87
Claims Backlog - Pending Claims2,4400.16%Claims Analyst I1,864.0020.000.52All CLIN 0002, SLINAA, SOW D.1.2History - EMC suspense rate of 16% based on implemented edits in 2008 (see page 15, Tab E, Volume I)
Claims Backlog - Pending Claims10,89335.00%Claims Analyst I1,864.0020.002.34All CLIN 0002, SLINAA, SOW D.1.2History - Based on new OCR technology implemented in 2007 (see page 17, Tab E, Volume I)
Claims Backlog - Pending Claims3265.00%Claims Analyst II1,864.0010.000.01All CLIN 0002, SLINAA, SOW D.1.2History - Based on automated process flow implemented in 2006 (see page 17, Tab E, Volume I)
Appeals Part B
Written Redeterminations
Written Redeterminations0ERROR:#DIV/0!
QIC Requests Supported
QIC Requests Supported0ERROR:#DIV/0!
Redeterminations on RAC Determinations
Redeterminations on RAC Determinations0ERROR:#DIV/0!
Clerical Error Reopenings
Clerical Error Reopenings0ERROR:#DIV/0!
Non-Clerical Error Reopenings
Non-Clerical Error Reopenings0ERROR:#DIV/0!
Effectuations
Effectuations0ERROR:#DIV/0!
ALJ Hearings
ALJ Hearings0ERROR:#DIV/0!
Appeals Backlog - Pending Redeterminations
Appeals Backlog - Pending Redeterminations0ERROR:#DIV/0!
PM Beneficiary Inquiries
Complex Beneficiary Inquiry Responses
Complex Beneficiary Inquiry Responses0ERROR:#DIV/0!
Complex 2nd Level Screenings
Complex 2nd Level Screenings0ERROR:#DIV/0!
PM Provider Customer Service
Provider Inquiries
Telephone Inquiries
Telephone Inquiries0ERROR:#DIV/0!
Written Inquiries
Written Inquiries0ERROR:#DIV/0!
Inquiries Backlog - Written Correspondence Pending
Inquiries Backlog - Written Correspondence Pending0ERROR:#DIV/0!
Congressionals
Congressionals0ERROR:#DIV/0!
PM Non-MSP collections (including RAC)
Non-MSP collections
Non-MSP collections0ERROR:#DIV/0!
PM Change Management
Draft Change Requests0
Draft Change Requests0ERROR:#DIV/0!
Finalized and Issued Change Requests - Shared System Changes0
Finalized and Issued Change Requests - Shared System Changes0ERROR:#DIV/0!
Finalized and Issued Change Requests - No Shared System Changes0
Finalized and Issued Change Requests - No Shared System Changes0ERROR:#DIV/0!
MIP Medical Review (MR)
Routine Manual Medical Reviews
Routine Manual Medical Reviews0ERROR:#DIV/0!
Existing LCDs Revised
Existing LCDs Revised0ERROR:#DIV/0!
New LCDs Developed
New LCDs Developed0ERROR:#DIV/0!
Prepay Complex Probe Reviews
Prepay Complex Probe Reviews0ERROR:#DIV/0!
Postpay Complex Probe Reviews
Postpay Complex Probe Reviews0ERROR:#DIV/0!
Prepay Complex Reviews
Prepay Complex Reviews0ERROR:#DIV/0!
Postpay Complex Reviews
Postpay Complex Reviews0ERROR:#DIV/0!
Medical Review Reopenings
Medical Review Reopenings0ERROR:#DIV/0!
Medical Review Claims Overturned on First Level Appeal
Medical Review Claims Overturned on First Level Appeal0ERROR:#DIV/0!
Medical Review Advanced Determination of Medicare Coverage (ADMC) Requests
Medical Review Advanced Determination of Medicare Coverage (ADMC) Requests0ERROR:#DIV/0!
Medical Review Data Requests
Medical Review Data Requests0ERROR:#DIV/0!
Medical Review Limited Education
Medical Review Limited Education0ERROR:#DIV/0!
Automated Reviews
Automated reviews developed based on the contractors own LCDs
Automated reviews developed based on the contractors own LCDs0ERROR:#DIV/0!
Medically Unlikely Edits
Medically Unlikely Edits0ERROR:#DIV/0!
Not Correct Coding Initiative Edits
Not Correct Coding Initiative Edits0ERROR:#DIV/0!
Not National Coverage Determination Edits
Not National Coverage Determination Edits0ERROR:#DIV/0!
MIP MSP Prepay
Claims Edits Resolved / "I" Records Resolved
Claims Edits Resolved / "I" Records Resolved0ERROR:#DIV/0!
COBC Claims Transferred
COBC Claims Transferred0ERROR:#DIV/0!
MIP Benefit Integrity Part B Workload
PSC Support Requests-Non Law Enforcement
PSC Support Requests-Non Law Enforcement0ERROR:#DIV/0!
PSC Support Requests- Law Enforcement
PSC Support Requests- Law Enforcement0ERROR:#DIV/0!
# of PSC Support Services Provided - Overpayments Recouped
# of PSC Support Services Provided - Overpayments Recouped0ERROR:#DIV/0!
MIP Provider Customer Service
MIP MSP Postpay
Provider/Supplier Duplicate Primary Payments
Provider/Supplier Duplicate Primary Payments0ERROR:#DIV/0!
General MSP Inquiries Resolved
General MSP Inquiries Resolved0ERROR:#DIV/0!
Debt Collection and Referrals
Debt Collection and Referrals0ERROR:#DIV/0!

&14RFP-CMS-2010-0004

DURABLE MEDICAL EQUIPMENT (DME) MEDICARE ADMINISTRATIVE CONTRACTOR (MAC)

&X1 &XWorkload supplied in Section L of the solicitation&X 2&X Supplied by Offeror (one day is defined as 8 hours).

Source Selection Information - See FAR 2.101 and 3.104 &P

Option Year One

J_ DME MAC Volume II
Basis of Estimate - Option Year One
Cost Estimating FactorAnnual
Workload1% Workload Processed with Direct LaborPosition/Labor CategoryAnnual Productive
HoursDaily Production per FTE2Total FTEs% Workload Processed with Indirect Cost CenterCLIN Template CrosswalkBasis of Estimate
Bills/Claims
Bills Claims - EMC
Bills/Claims - EMC0ERROR:#DIV/0!
Bills Claims - Paper
Bills/Claims - Paper0ERROR:#DIV/0!
Claims Backlog - Pending Claims
Claims Backlog - Pending Claims0ERROR:#DIV/0!
Appeals Part B
Written Redeterminations
Written Redeterminations0ERROR:#DIV/0!
QIC Requests Supported
QIC Requests Supported0ERROR:#DIV/0!
Redeterminations on RAC Determinations
Redeterminations on RAC Determinations0ERROR:#DIV/0!
Clerical Error Reopenings
Clerical Error Reopenings0ERROR:#DIV/0!
Non-Clerical Error Reopenings
Non-Clerical Error Reopenings0ERROR:#DIV/0!
Effectuations
Effectuations0ERROR:#DIV/0!
ALJ Hearings
ALJ Hearings0ERROR:#DIV/0!
Appeals Backlog - Pending Redeterminations
Appeals Backlog - Pending Redeterminations0ERROR:#DIV/0!
PM Beneficiary Inquiries
Complex Beneficiary Inquiry Responses
Complex Beneficiary Inquiry Responses0ERROR:#DIV/0!
Complex 2nd Level Screenings
Complex 2nd Level Screenings0ERROR:#DIV/0!
PM Provider Customer Service
Provider Inquiries
Telephone Inquiries
Telephone Inquiries0ERROR:#DIV/0!
Written Inquiries
Written Inquiries0ERROR:#DIV/0!
Inquiries Backlog - Written Correspondence Pending
Inquiries Backlog - Written Correspondence Pending0ERROR:#DIV/0!
Congressionals
Congressionals0ERROR:#DIV/0!
PM Non-MSP collections (including RAC)
Non-MSP collections
Non-MSP collections0ERROR:#DIV/0!
PM Change Management
Draft Change Requests0
Draft Change Requests0ERROR:#DIV/0!
Finalized and Issued Change Requests - Shared System Changes0
Finalized and Issued Change Requests - Shared System Changes0ERROR:#DIV/0!
Finalized and Issued Change Requests - No Shared System Changes0
Finalized and Issued Change Requests - No Shared System Changes0ERROR:#DIV/0!
MIP Medical Review (MR)
Routine Manual Medical Reviews
Routine Manual Medical Reviews0ERROR:#DIV/0!
Existing LCDs Revised
Existing LCDs Revised0ERROR:#DIV/0!
New LCDs Developed
New LCDs Developed0ERROR:#DIV/0!
Prepay Complex Probe Reviews
Prepay Complex Probe Reviews0ERROR:#DIV/0!
Postpay Complex Probe Reviews
Postpay Complex Probe Reviews0ERROR:#DIV/0!
Prepay Complex Reviews
Prepay Complex Reviews0ERROR:#DIV/0!
Postpay Complex Reviews
Postpay Complex Reviews0ERROR:#DIV/0!
Medical Review Reopenings
Medical Review Reopenings0ERROR:#DIV/0!
Medical Review Claims Overturned on First Level Appeal
Medical Review Claims Overturned on First Level Appeal0ERROR:#DIV/0!
Medical Review Advanced Determination of Medicare Coverage (ADMC) Requests
Medical Review Advanced Determination of Medicare Coverage (ADMC) Requests0ERROR:#DIV/0!
Medical Review Data Requests
Medical Review Data Requests0ERROR:#DIV/0!
Medical Review Limited Education
Medical Review Limited Education0ERROR:#DIV/0!
Automated Reviews
Automated reviews developed based on the contractors own LCDs
Automated reviews developed based on the contractors own LCDs0ERROR:#DIV/0!
Medically Unlikely Edits
Medically Unlikely Edits0ERROR:#DIV/0!
Not Correct Coding Initiative Edits
Not Correct Coding Initiative Edits0ERROR:#DIV/0!
Not National Coverage Determination Edits
Not National Coverage Determination Edits0ERROR:#DIV/0!
MIP MSP Prepay
Claims Edits Resolved / "I" Records Resolved
Claims Edits Resolved / "I" Records Resolved0ERROR:#DIV/0!
COBC Claims Transferred
COBC Claims Transferred0ERROR:#DIV/0!
MIP Benefit Integrity Part B Workload
PSC Support Requests-Non Law Enforcement
PSC Support Requests-Non Law Enforcement0ERROR:#DIV/0!
PSC Support Requests- Law Enforcement
PSC Support Requests- Law Enforcement0ERROR:#DIV/0!
# of PSC Support Services Provided - Overpayments Recouped
# of PSC Support Services Provided - Overpayments Recouped0ERROR:#DIV/0!
MIP Provider Customer Service
MIP MSP Postpay
Provider/Supplier Duplicate Primary Payments
Provider/Supplier Duplicate Primary Payments0ERROR:#DIV/0!
General MSP Inquiries Resolved
General MSP Inquiries Resolved0ERROR:#DIV/0!
Debt Collection and Referrals
Debt Collection and Referrals0ERROR:#DIV/0!

&14RFP-CMS-2010-0004

DURABLE MEDICAL EQUIPMENT (DME) MEDICARE ADMINISTRATIVE CONTRACTOR (MAC)

&X1&X Workload supplied in Section L of the solicitation &X2&X Supplied by Offeror (one day is defined as 8 hours).

Source Selection Information - See FAR 2.101 and 3.104 &P

File details come from the government source that posted it. Updated .