ICU COST in a 20 bed unit

ICU COST in a 20 bed unit

Dear Students: Attached is an Excel Spreadsheet of a “valid and reliable” data set of potential ICU costs in a 20 bed unit. The ICU director has goals that she must meet on an annual basis to keep her annual contract. You are the associate director in charge of research and she has asked you to answer the following based on the data of an average amount per day (each is worth 1 extra point for your overall grade – you must provide the correct answer within 10% of the exact number): 1. Will she meet her goal of $500,000 profit for the year – If yes, by how much – If no, by how much? [You can use the data as a monthly amount that can be extrapolated x 12 for an annual amount] 2. What are the percentage of days that DRGs are covering costs in the ICU [You can use the data as a monthly amount that represents the entire year] 3. What is the percent of variation explained by the process of care (part 1), and the structure of care (part 2). [You can use the data as a representation for the entire year. I suggest SPSS or SAS to complete the multiple regression – hint: you can use pearson MR] 4. What is the greatest single predictor of total costs and is it statistically significant at p<0.01? * Note: Please let me know if you would like me to scan the chapter on multiple regression from the book if you need it or can’t find how to do it.