56  1.8513  35 38 33 57  1.0716  12  13  11  58  1.7198  47  48  43  59  1.0134  5  7  5  60  0.813  21  19  20  61  2.6843  35  34  28  62  1.8918  27  31  25  63  1.5238  4  6  3  64  1.7326  35  36  33  65  1.0593  44  46  42 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 VolumePopulate 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 VolumesPopulate the Excel spreadsheet with your CMI rate for each of the 3 quarters Step 5: Evaluate the Data Evaluate the data to determine which MS-DRG would have the most significant impact on the CMI in Q4, if there was increased volume for that DRG. Consider the MS DRG RW Weight and volumeHighlight the MS DRG you determine to have the biggest impact in yellow on the spreadsheet