You are the Supervisor of Coding for Big City Hospital and the Director of HIM has asked you to analyze the case mix index for 2021 and 2022 for specified DRGs. There are 2 parts to this assignment, one part is the calculation of the CMIs and the second part is an analysis of the CMIs. Using the provided spreadsheet Download spreadsheet, calculate the CMIs You are the Supervisor of Coding for Big City Hospital and the Director of HIM has asked you to analyze the case mix index for 2021 and 2022 for specified DRGs. There are 2 parts to this assignment, one part is the calculation of the CMIs and the second part is an analysis of the CMIs. Using the provided spreadsheet Download spreadsheet, calculate the CMIs as indicated by the highlighted cells. Upload the completed spreadsheet to this assignment. In a Word document, analyze the data. Include your findings/analysis as well as your recommended plan of action to ensure that the coding of these discharges was accurate. Upload your Word document to this assignment