Real-World Case 14.1-Chapter 14, page 469, textbook from HIT 121: HIM Technology, An Applied Approach, 6th Ed.
Review Chapter 14: Healthcare Statistics–what do you recall? This is a review
SHOW YOUR Calculations–do not just submit a number!
A summary of the patients discharged from MS-DRG 689 at Community Hospital is presented in the table below.
| Data for Real-World Case 14.1 discussion | |||||||
| Case | Principal Diagnosis | Principal Procedure | Age | LOS | Discharge Destination | Charges | Payer |
| 1 | 599.0 | 38.93 | 53.5 | 4 | HOMEIV | $8,851 | MEDICAID |
| 2 | 599.0 | 45.13 | 28.2 | 7 | HOMEHEALTH | $18,966 | MEDICARE |
| 3 | 590.8 | 45.5 | 3 | HOME | $4,370 | MANAGED CARE | |
| 4 | 590.8 | 86.27 | 27.9 | 3 | HOMEHEALTH | $7,121 | GOV MNGD CARE |
| 5 | 590.8 | 38.8 | 3 | HOME | $13,350 | MEDICAID | |
| 6 | 590.8 | 45.23 | 67.1 | 4 | HOME | $15,854 | MANAGED CARE |
| 7 | 599.0 | 39.95 | 88.5 | 6 | SNF | $22,373 | MEDICARE |
| 8 | 599.0 | 27.8 | 6 | HOMEHEALTH | $11,381 | GOV MNGD CARE | |
| 9 | 590.1 | 52.6 | 2 | HOME | $4,082 | MEDICAID | |
| 10 | 599.0 | 81.9 | 6 | HOMEHEALTH | $17,025 | MEDICARE | |
| 11 | 590.8 | 23.3 | 3 | HOME | $5,039 | MEDICAID | |
| 12 | 599.0 | 43.11 | 90.1 | 5 | HOMEHEALTH | $17,411 | MEDICARE |
| 13 | 599.0 | 99.6 | 91.3 | 1 | UNKNOWN | $5,302 | MEDICARE |
| 14 | 599.0 | 88.72 | 73.1 | 4 | HOME | $11,091 | MEDICARE |
| 15 | 599.0 | 81.3 | 12 | SNF | $23,341 | MEDICARE | |
| 16 | 590.8 | 45.16 | 74.7 | 4 | HOMEHEALTH | $16,277 | MEDICARE |
| 17 | 599.0 | 71.2 | 5 | HOMEHEALTH | $9,239 | MEDICARE | |
| 18 | 599.0 | 79.3 | 7 | SNF | $21,050 | MEDICARE | |
| 19 | 590.1 | 31.3 | 4 | HOME | $7,085 | GOV MNGD CARE | |
| 20 | 590.8 | 38.93 | 74.1 | 13 | ACUTECARE | $49,487 | MEDICAID |
| 21 | 599.0 | 65.7 | 2 | HOMEHEALTH | $8,980 | MEDICARE | |
| 22 | 599.0 | 86.27 | 83.1 | 5 | SNF | $11,651 | MEDICARE |
| 23 | 599.0 | 77.0 | 5 | SNF | $12,295 | MEDICARE | |
| 24 | 599.0 | 99.04 | 81.2 | 7 | HOMEHEALTH | $23,745 | MEDICARE |
| 25 | 599.0 | 43.3 | 10 | HOMEHEALTH | $25,130 | MEDICARE | |
| 26 | 599.0 | 81.5 | 3 | SNF | $10,092 | MEDICARE | |
| 27 | 599.0 | 38.93 | 25.6 | 3 | HOMEIV | $8,722 | MEDICAID |
| 28 | 599.0 | 61.4 | 2 | SNF | $6,670 | MEDICAID | |
| 29 | 599.0 | 45.13 | 76.0 | 8 | SNF | $17,741 | GOV MNGD CARE |
| 30 | 590.1 | 44.4 | 4 | HOME | $10,800 | MANAGED CARE | |
| 31 | 590.8 | 44.8 | 2 | HOME | $10,916 | MEDICAID | |
| 32 | 599.0 | 45.13 | 61.2 | 8 | SNF | $32,796 | MEDICARE |
1. Calculate the length of stay for all patients.
2. Calculate the average length of stay for Medicare patients.
3. Calculate the average charge for all patients.
4. Calculate the average charge for Medicaid patients.
5. Calculate the average age of all patients.
6. Calculate the average age of patients discharged to skilled nursing facilities.
7. Calculate the average age of patients discharged home.
8. Calculate the ratio of Medicare patients to Medicaid patients.
