Module 06 Assignment - Case-Mix Index (CMI)-CDI Measure of Success Module 06 Content One measure of success of a Clinical Documentation Improvement Program (CDI) includes an increase in the case-mix index (CMI) resulting in increased reimbursement. In this assignment, you will be preparing quarterly statistics for reporting on the Quarterly CMI. To determine the CMI, several calculations are required using the data provided to arrive at the Quarterly CMI. Instructions For this assignment, you will populate a Microsoft Excel spreadsheet using MS-DRG data. Step 1: Download the Worksheet HIM2135 Module 06 Student CMI CDI Worksheet.xlsx Step 2: Populate the Spreadsheet Populate the Excel spreadsheet using the data provided in Table 1- Data Points. Table 1 - Data Points Data Points Step 3: Calculate the Volumes Calculate the weighted volumes (Wt. Vol) for each DRG and each of the 3 quarters (Q1, Q2, and Q3). Formula: MS-DRG RW Weight x Volume Populate the Excel spreadsheet with your results for each DRG for all 3 quarters Step 4: Determine the CMI Determine the CMI for each quarter. Formula: Total Weighted Volume/Total Volumes Populate the Excel spreadsheet with your CMI rate for each of the 3 quarters Step 5: Evaluate the Data Evaluate