J.22.A Historic & Proposed FTE, Hours & Gross Cost Instructions & Narrative redline Amend 1.docx
DOCX document 24 KB Posted
- Solicitation number
- 75FCMC20R0008
About this file
This document contains instructions and a narrative for a historic and proposed FTE, hours, and gross cost worksheet attachment to a solicitation. The solicitation is for a Part A/Part B Medicare Administrative Contractor to provide specified health insurance benefit administration services including Medicare claims processing and payment services in support of the Medicare Fee-For-Service program. The contractor will serve Jurisdiction L which includes Delaware, Maryland, New Jersey, Pennsylvania, Washington D.C., and parts of Virginia.
The instructions provide detailed guidance for completing tables in an Excel file with historic and proposed data for Program Management and Medicare Integrity Program functions. Areas of analysis, time periods, and data sources are specified. Explanations are required if proposed workload, costs, or FTEs differ from historic levels. Direct labor by category and function, travel, subcontractors, other direct costs, indirect costs, overhead, and fee must be documented. Page references to supporting explanations in the technical and business proposals are also required.
View the file
Other files
Show 40 more
Latest 50 of 79 listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Attachment J.22.A Historic & Proposed FTE, Hours, & Gross Cost Instructions & Narrative
RFP # 75FCMC20R0008
INSTRUCTIONS FOR HISTORIC & PROPOSED FTEs, HOURS, & GROSS COST WORKSHEET (ATTACHMENT J.22.B): Complete all tables in the Excel file using the instructions below.
NOTE: Offerors shall include Home Health and Hospice (HHH) data, whether historic or proposed, within the applicable rows for Part A data.
1. Offerors shall complete PM Table 1 in the J.22.B Historic & Proposed FTEs, Hours, & Gross Cost Worksheet with your historic data and your proposed OY1 data for Program Management (PM) only. See the following instructions:
a. Do not change any cells pre-populated with NA.
b. Do not change any formulas.
c. In Columns D, H, L and P, enter in the corresponding column headings the same information on the contract and start and end dates of the 12-month historic baseline you used in your basis of estimate. Offerors shall specify the contract used to obtain the baseline data.
d. The data in Column D shall match the data in Column O, Historic Workload, of Attachment J.22, Basis of Estimate.
e.
f. In Columns C, G, K and O, enter in the corresponding column headings the same historic contract as Column D with start and end dates 12 months prior to the dates entered for Column D. Offerors shall specify the contract used to obtain the historical data.
g. In Columns B, F, J and N, enter in the corresponding column headings the same historic contract as Column C with start and end dates 12 months prior to the dates entered for Column C. Offerors shall specify the contract used to obtain the historical data.
h. The Areas of Analysis in Column A, represented by uppercase alpha bullets A – N (e.g., rows 6, 9, 12, etc.), have subordinate rows, represented by lowercase alpha bullets (e.g., rows 7-8, 10-11, 13-17, etc.).
i. With the exception of the Workload Columns B through E for the uppercase alpha bullets G (i.e., row 42) and H (i.e., row 47), the rows for the corresponding subordinate lowercase alpha bullets automatically total the shaded row immediately above (i.e., per the formulas in the worksheet). For the Workload Columns B through E for the uppercase alpha bullets G (i.e., row 42) and H (i.e., row 47), enter only claims count data in the shaded rows (i.e., rows 42 and 47) and the respective data in the corresponding rows for the subordinate lowercase alpha bullets below (i.e., rows 43-46 and 48-52).
j. The data in Column E shall match the data in Column F, Proposal Workload, of Attachment J.22, Basis of Estimate.
k.
l. In Columns F through I, enter total FTEs (i.e., FTEs for both direct and indirect labor).
m. All historic costs should be gross (i.e., do not reduce gross costs for complementary credits).
n. All historic workloads, FTEs, hours and gross costs shall match data in the CMS Analysis, Reporting, and Tracking (CMSART) System, Contractor Reporting of Operational and Workload (CROWD) System, Monthly Status Report Excel (MSRE) files and other CMS data sources, as applicable.
o. All proposed workloads, FTEs, hours and costs in Attachment J.22.B Historic & Proposed FTEs, Hours, & Gross Cost Worksheet shall be consistent with your Technical Proposal, Business Proposal, as well as Attachment J.22 Basis of Estimate.
2. Offerors shall complete MIP Table 2 in the J.22.B Historic & Proposed FTEs, Hours, & Gross Cost Worksheet with your historic data and your proposed OY1 data for Medicare Integrity Program (MIP) only. See the following instructions:
a. Do not change any cells pre-populated with NA.
b. Do not change any formulas.
c. In Columns D, H, L and P, enter in the corresponding column headings the same information on the contract and start and end dates of the 12-month historic baseline you used in your basis of estimate. Offerors shall specify the contract used to obtain the baseline data.
d. The data in Column D shall match the data in Column O, Historic Workload, of Attachment J.22, Basis of Estimate.
e. In Columns C, G, K and O, enter in the corresponding column headings the same historic contract as Column D with start and end dates 12 months prior to the dates entered for Column D. Offerors shall specify the contract used to obtain the historical data.
f. In Columns B, F, J and N, enter in the corresponding column headings the same historic contract as Column C with start and end dates 12 months prior to the dates entered for Column C. Offerors shall specify the contract used to obtain the historical data.
g. The Areas of Analysis in Column A, represented by uppercase alpha bullets A – K (e.g., rows 6, 8, 10, etc.), have subordinate rows. These subordinate rows, represented by lowercase alpha bullets (e.g., rows 7, 9, 11-12, etc.), automatically total the shaded row immediately above (i.e., per the formulas in the worksheet).
h. The data in Column E shall match the data in Column F, Proposal Workload, of Attachment J.22, Basis of Estimate.
i. In Columns F through I, enter total FTEs (i.e., FTEs for both direct and indirect labor).
j. All historic workloads, FTEs, hours and costs shall match data in the CMS Analysis, Reporting, and Tracking (CMS ART) System, Contractor Reporting of Operational and Workload (CROWD) System, Monthly Status Report Excel (MSRE) files and other CMS data sources, as applicable.
k. All proposed workloads, FTEs, hours and costs in Attachment J.22.B Historic & Proposed FTEs, Hours, & Gross Cost Worksheet shall be consistent with your Technical Proposal, Business Proposal, as well as Attachment J.22 Basis of Estimate.
ADDITIONAL NARRATIVE DETAILS:
Using information from your completed Excel tables, address the points below.
Explain in detail any unit costs, workload per FTE, and/or cost per FTE proposed for the OY1 period of performance that contribute to why any of the points noted below are either lower or higher than your historic data. Explain why these proposed amounts are realistic. Include the following detail, as applicable:
· Direct Labor, broken out by number of FTEs, by labor category, by Mission Essential Functions (MEF)
· Travel
· Subcontractors
· Other Direct Costs (ODCs), broken out by category with amounts, such as service centers, print/mail/postage, etc.
· Indirect Costs
· Overhead
· General and Administrative
· Fee Offerors shall document all explanations in the space below and in the technical and/or business proposal as appropriate. For each point below indicate the page number where the same information can be found in your technical and/or business proposal.
1. See PM Table 1. Provide an explanation if any of your Proposed PM Part A Total Gross Cost per Unit data in Column U do not align with your corresponding Historic PM Part A Total Gross Cost per Unit data in Columns R though T.
2. See PM Table 1. Provide an explanation if any of your Proposed PM Part B Total Gross Cost per Unit data in Column U do not align with your corresponding Historic PM Part B Total Gross Cost per Unit data in Columns R though T.
3. See PM Table 1. Provide an explanation if any of your Proposed PM Part A Workload per FTE data in Column Y do not align with your corresponding Historic PM Part A Workload per FTE data in Columns V though X.
4. See PM Table 1. Provide an explanation if any of your Proposed PM Part B Workload per FTE data in Column Y do not align with your corresponding Historic PM Part B Workload per FTE data in Columns V though X.
5. See PM Table 1. Provide an explanation if any of your Proposed PM Part A Total Gross Cost per FTE data in Column AC do not align with your corresponding Historic PM Part A Total Gross Cost per FTE data in Columns Z though AB.
6. See PM Table 1. Provide an explanation if any of your Proposed PM Part B Total Gross Cost per FTE data in Column AC do not align with your corresponding Historic PM Part B Total Gross Cost per FTE data in Columns Z though AB.
7. See MIP Table 2. Provide an explanation if any of your Proposed PM Part A Total Gross Cost per Unit data in Column U do not align with your corresponding Historic PM Part A Total Gross Cost per Unit data in Columns R though T.
8. See MIP Table 2. Provide an explanation if any of your Proposed MIP Part B Total Gross Cost per Unit data in Column U do not align with your corresponding Historic MIP Part B Total Gross Cost per Unit data in Columns R though T.
9. See MIP Table 2. Provide an explanation if any of your Proposed MIP Part A Workload per FTE data in Column Y do not align with your corresponding Historic MIP Part A Workload per FTE data in Columns V though X.
10. See MIP Table 2. Provide an explanation if any of your Proposed MIP Part B Workload per FTE data in Column Y do not align with your corresponding Historic MIP Part B Workload per FTE data in Columns V though X.
11. See MIP Table 2. Explain why if any, or all, of your Proposed MIP Part A Total Gross Cost per FTE data in Column AC do not align with your corresponding Historic MIP Part A Total Gross Cost per FTE data in Columns Z though AB.
12. See MIP Table 2. Explain why if any, or all, of your Proposed MIP Part B Total Gross Cost per FTE data in Column AC do not align with your corresponding Historic MIP Part B Total Gross Cost per FTE data in Columns Z though AB.
File details come from the government source that posted it. Updated .