Case Mix analysis- You have been asked by your administrator to evaluation the change in the case mix from 2011 to 2012 for maternity cases and newborn cases to determine the impact, if any of the multiple birthing centers which have opened in your city.Utilizing the spreadsheets provided for 2011 and 2012 identify all of the MSDRGs for obstetrics and newborns and copy onto new spreadsheets.

Calculate the case mix index overall for OB MSDRGs and NB MSDRGs for each year and determine the percentage of difference from 2011 to 2012.Also review individual MSDRGs within these groups and determine any significant differences from 2011 to 2012.

The base rate for your facility is $6249.Determine the financial impact of the changes for each MSDRG and overall for OB, NB and these cases combined.

Display your results in graphic presentation to present to the administration.