Real-World Case 14.1-Chapter 14, textbook
AHIMA Competency lll.3: Calculate statistics for healthcare operations.
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.
