You are the Health Information Management Director for Sunshine County Hospital in Long Beach, California. Sunshine is a 150-bed general hospital. The chief financial officer has tasked you to look at the benchmarks from similar hospitals in your region regarding the length of stay by MS-DRG. Your responsibility as the HIM director includes gathering statistical data concerning length of stay as it relates to MS-DRGs. Gather the appropriate data from the following Excel spreadsheet to answer the questions. • Calculate the adjusted length of stay for each MS-DRGs 3, 207 and 57. • Calculate the mean charge per day for each MS-DRGs 3, 207 and 57. • Calculate the mean charge per stay for each MS-DRGs 3, 207 and 57. • Compare and contrast the MS-DRGs by the three calculations above. • Build an Excel spreadsheet from your calculated data to create appropriate graphs that compare and contrast the calculations above. Build a cohesive PowerPoint presentation that displays your graphs and the information you have extracted from the dataset. You will be presenting your PowerPoint to the Board of Directors of Sunshine Hospital. • HINTS: o Answer the questions in order they are asked. o Make multiple graphs to show data in a cohesive manner. o Show trendline in your graphs. o Use the note option in PowerPoint to narrate your slides. Presentations will be graded on: • Accuracy (both the accuracy of the calculations and of display construction) • Display selection (selection of appropriate display type for individual answers and overall variety of display types used throughout the project) Presentation should be at least 10 slides. • Neatness and overall “look and feel” of the project – this should be a presentation that will be presented to an executive board. • Creativity
