Case Mix Index Assignment
Order Description
Case Mix Index Assignment
1. Listen/watch the lecture on CMI calculation.
2. Locate the spreadsheet file “CMI Excel Worksheet”. Using the Excel formulas, calculate CMI for this group of patients.
3. Then go to this website:
https://www.cms.gov/Medicare/Medicare-Fee-for-Service-Payment/AcuteInpatientPPS/FY2016-IPPS-Final-Rule-Home-Page-Items/FY2016-IPPS-Final-Rule-Tables.html (Links to an external site.)
On the bottom of this website, locate table 5 and download it.
4. From Table 5, locate each of the MS-DRGs and their corresponding relative weight. Using the file “CMI Excel Worksheet Update the Relative Weight” from the course, update the relative weight for each of the MS-DRGs for Fiscal Year 2016 in your spreadsheet.
5. Calculate CMI for this new group of patients with the updated FY 2016 relative weights.
6. Analyze the difference in the CMI, and explain what the difference means to this healthcare organization. What is the financial impact to them?
7. Submit both Excel files and your discussion to your instructor for this assignment.
Case Mix Index Assignment
Order Description
Case Mix Index Assignment
1. Listen/watch the lecture on CMI calculation.
2. Locate the spreadsheet file “CMI Excel Worksheet”. Using the Excel formulas, calculate CMI for this group of patients.
3. Then go to this website:
https://www.cms.gov/Medicare/Medicare-Fee-for-Service-Payment/AcuteInpatientPPS/FY2016-IPPS-Final-Rule-Home-Page-Items/FY2016-IPPS-Final-Rule-Tables.html (Links to an external site.)
On the bottom of this website, locate table 5 and download it.
4. From Table 5, locate each of the MS-DRGs and their corresponding relative weight. Using the file “CMI Excel Worksheet Update the Relative Weight” from the course, update the relative weight for each of the MS-DRGs for Fiscal Year 2016 in your spreadsheet.
5. Calculate CMI for this new group of patients with the updated FY 2016 relative weights.
6. Analyze the difference in the CMI, and explain what the difference means to this healthcare organization. What is the financial impact to them?
7. Submit both Excel files and your discussion to your instructor for this assignment.
Thanks for taking a look at our sample papers
Do you need any help with your assignment?
Our aim is to help you get the best grades for your Coursework.
We are very confident in our quality of work that we offer you 100% Money back guarantee
Header Button Label: Get StartedGet Started