|
|
  |
 |
  |
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
State Summary for Utah for 2007 11 Grantees
| Payor Category |
Full
Charges This Period (a) |
Charges
as Percent of Payor |
Charges
as Percent of Total |
Amount
Collected This Period (b) |
Collections
as Percent of Payor |
Collections
as Percent of Total |
Collections
as Percent of Charges |
Collection
of recon./wrap around Current Year (c1) |
Collection
of recon./wrap around Previous Years
(c2) |
Collection
of other retroactive payments (c3) |
Penalty/Payback
(c4) |
Net
Retros |
Net
Retros as Percent of Charges |
Allowances
(d) |
Allowances
as Percent of Charges |
| 1. Medicaid Non-Managed Care |
11,120,562 |
100.0% |
20.7% |
11,307,969 |
100.0% |
41.4% |
101.7% |
337,182 |
936,300 |
|
0 |
1,273,482 |
11.5% |
5,363 |
0.0% |
| 2a. Medicaid Managed Care (capitated)
|
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
0 |
0 |
0 |
0 |
0 |
--- |
0 |
--- |
| 2b. Medicaid Managed Care (fee-for-service)
|
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
0 |
0 |
0 |
0 |
0 |
--- |
0 |
--- |
| 3. Total Medicaid (Lines 1 +
2a + 2b) |
11,120,562 |
100.0% |
20.7% |
11,307,969 |
100.0% |
41.4% |
101.7% |
337,182 |
936,300 |
0 |
0 |
1,273,482 |
11.5% |
5,363 |
0.0% |
| 4. Medicare Non-Managed Care |
3,671,135 |
100.0% |
6.8% |
2,809,892 |
100.0% |
10.3% |
76.5% |
3,555 |
64,302 |
|
1,707 |
66,150 |
1.8% |
749,964 |
20.4% |
| 5a. Medicare Managed Care (capitated)
|
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
0 |
0 |
0 |
0 |
0 |
--- |
0 |
--- |
| 5b. Medicare Managed Care (fee-for-service)
|
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
0 |
0 |
0 |
0 |
0 |
--- |
0 |
--- |
| 6. Total Medicare (Lines 4 +
5a + 5b) |
3,671,135 |
100.0% |
6.8% |
2,809,892 |
100.0% |
10.3% |
76.5% |
3,555 |
64,302 |
0 |
1,707 |
66,150 |
1.8% |
749,964 |
20.4% |
| 7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
787,382 |
100.0% |
1.5% |
241,709 |
100.0% |
0.9% |
30.7% |
|
|
|
0 |
0 |
0.0% |
284,191 |
36.1% |
| 8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
|
|
0 |
0 |
0 |
--- |
0 |
--- |
| 8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
|
|
0 |
0 |
0 |
--- |
0 |
--- |
| 9. Total Other Public (Lines
7 + 8a + 8b) |
787,382 |
100.0% |
1.5% |
241,709 |
100.0% |
0.9% |
30.7% |
|
|
0 |
0 |
0 |
0.0% |
284,191 |
36.1% |
| 10. Private Non-Managed Care |
10,351,509 |
100.0% |
19.2% |
6,683,178 |
100.0% |
24.4% |
64.6% |
|
|
|
0 |
0 |
|
2,495,171 |
24.1% |
| 11a. Private Managed Care (capitated)
|
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
|
|
0 |
0 |
0 |
--- |
0 |
--- |
| 11b. Private Managed Care (fee-for-service)
|
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
|
|
0 |
0 |
0 |
--- |
0 |
--- |
| 12. Total Private (Lines 10
+ 11a + 11b) |
10,351,509 |
100.0% |
19.2% |
6,683,178 |
100.0% |
24.4% |
64.6% |
|
|
0 |
0 |
0 |
0.0% |
2,495,171 |
24.1% |
| 13. Self-Pay |
27,919,944 |
100.0% |
51.8% |
6,303,538 |
100.0% |
23.1% |
22.6% |
|
|
|
|
|
|
|
|
| 14. Total (Lines 3 + 6 + 9 +
12 + 13) |
53,850,532 |
|
100.0% |
27,346,286 |
|
100.0% |
50.8% |
340,737 |
1,000,602 |
0 |
1,707 |
1,339,632 |
2.5% |
3,534,689 |
6.6% |
|
Sliding Discounts (e) |
Sliding Discounts as a Percent of Self-Pay
Charges |
Bad Debt Write Off(f) |
Bad Debt as Percent of Self-Pay
Charges |
| 13. Self-Pay (line 14 is same) |
19,703,795 |
70.6% |
1,394,907 |
5.0% |
data as of: 7/22/2008 4:16:43
 |