Assignment Task: Rasmussen University Hospital has conducted a 5-year Strategic Plan Review. One of the goals stated the need for community engagement by expanding key services into underserved communities.
The Cardiology Department is requesting additional funding to expand services but needs validation that they have sufficient revenue. The CFO has sent a listing of MS-DRGs with their relative weights and has asked that you calculate the CMI for each DRG and then for the entire group. He wants you to analyze the data and report that addresses specific findings from the worksheet. He'll use your report and graphics in a presentation to the Cardiology Department.
A hospital's CMI represents the average diagnosis-related group (DRG) relative weight for that hospital. It is calculated by summing the DRG weights for all Medicare discharges and dividing by the number of discharges. CMIs are calculated using both transfer-adjusted cases and unadjusted cases. (2020, CMS.gov)
Q1. 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.
Q2. 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.)
Q3. 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.
Q4. 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.
Q5. Understanding what a Case Mix Index is based on, what would you suggest the facility do to increase the CMI revenue?