Assessment Instructions Prepare an analysis for the CFO that includes the following: Calculate the CMI for each DRG and for the average CMI for the Cardiology Department using the CMI Report provided. Attach your worksheet to your report. Create a CMI Report showing and rating the MS-DRGs on a graph from the highest weight to the lowest using the relative weights. (You should be able to copy your calculations from the worksheet and paste them into an Excel spreadsheet for graphic creation.) Lastly, identify the DRG with the highest payment that is producing income for the facility. Include any variable that exists when you analyze the data. The CFO requests that in your report, you include an explanation of what a Case Mix Index is and give three examples of how a facility might use this data strategically. Understanding what a Case Mix Index is based on, what would you suggest the facility do to increase the CMI revenue