MMHA6235 week 5 assignment

Exercises AssignmentExercise 9.1The chief at the ultrasound division of the radiology department in a community hospital would like to measure the multi-factor productivity for a complete abdomen procedure. The last three years of data were accumulated as shown in Table Ex. 9.1Exercise 9.4Calculate the case mix index for the following hospitals, which use the same patient classification system, using the data in Table Ex. 9.4.Exercise 9.7The PERFORMSBETTER MEDICAL CENTER (PMC), a three-site urology group practice, requires productivity monitoring. To create a benchmark for future years and to be able to compare performance to similar peer practices, the data in Table Ex 9.7 were gathered for each of the three locations.Complete Exercises 9.1, 9.4 and 9.7 on pages 232–236 in Quantitative Methods in Health Care Management. Use the Excel document below to record your answers. Save the template to your desktop before using. .waldenu.edu/bbcswebdav/institution/USW1/201540_02/MS_MMHA/MMHA_6235/Week%205/Exercises/Week%205%20Exercises/embedded/Ex._9.1_9.4_9.7_templates.xls”>Excel template for Exercises 9.1, 9.4, and 9.7 Note:
For 9.7, provide a short response to the following (9.7j): “Use the
measures in 9.7h and i for the final comparison among the three sites,
and discuss potential problems at each site or overall for the company.
What are your recommendations to correct them?”