Case Mix Exercise

The CFO just called. She was supposed to have asked you to get her the Case Mix Index (CMI) for 2013, 2014, and 2015 a month ago. She has just realized that she never asked you for the data. She must have it for the administrative directors meeting that takes place the next day, but she actually needs the information by 3 pm so that it can be copied and placed in the packet for the directors. The CFO is requesting a report to include a graph and an analysis of trended data to report to the directors.

As you review the data from the Table, calculate the annual CMI for each year and design a bar graph of the CMI for calendar years 2013, 2014, and 2015. In your own words, explain any trends you notice from the graph and why these trends might be of some concern to the CFO and the directors. Based on the information from the graph, list and define the steps needed to be taken to provide as much information to the CFO as soon as possible to explain the trends. Explain your answers in detail. Please write clearly

CMI by Month Years 2013, 2014, and 2015
Month Year
2013 2014 2015
January	1.4321	1.3276	1.3756
February	1.3215	1.2535	1.4544
March	1.2487	1.2478	1.2489
April	1.5789	2.2435	1.2570
May	1.5789	1.5248	1.5278
June	1.5321	1.4245	1.5741
July	1.2635	1.2857	1.2576
August	1.5227	1.4456	1.5700
September	1.4568	1.2357	1.2768
October	1.2748	1.2575	1.2578
November	1.3578	1.3574	1.4456
December	1.2357	1.6574	1.5788
Annual

Source: Fictitious data, for illustration purposes only