|
|
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
Regional Summary for Region VII for 2007 50 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 |
63,186,852 |
61.3% |
23.0% |
56,969,377 |
63.8% |
37.6% |
90.2% |
879,870 |
2,685,586 |
|
322,367 |
3,243,089 |
5.1% |
1,669,741 |
2.6% |
2a. Medicaid Managed Care (capitated)
|
5,896,797 |
5.7% |
2.1% |
2,912,553 |
3.3% |
1.9% |
49.4% |
413,606 |
0 |
0 |
19,203 |
394,403 |
6.7% |
2,434,017 |
41.3% |
2b. Medicaid Managed Care (fee-for-service)
|
33,986,809 |
33.0% |
12.4% |
29,407,314 |
32.9% |
19.4% |
86.5% |
10,921,148 |
1,596,271 |
81,740 |
269,355 |
12,329,804 |
36.3% |
4,100,420 |
12.1% |
3. Total Medicaid (Lines 1 +
2a + 2b) |
103,070,458 |
100.0% |
37.6% |
89,289,244 |
100.0% |
58.9% |
86.6% |
12,214,624 |
4,281,857 |
81,740 |
610,925 |
15,967,296 |
15.5% |
8,204,178 |
8.0% |
4. Medicare Non-Managed Care |
21,551,052 |
99.1% |
7.9% |
15,954,519 |
99.3% |
10.5% |
74.0% |
28,327 |
627,572 |
|
122,671 |
533,228 |
2.5% |
3,409,063 |
15.8% |
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)
|
198,692 |
0.9% |
0.1% |
109,848 |
0.7% |
0.1% |
55.3% |
0 |
0 |
0 |
0 |
0 |
0.0% |
75,721 |
38.1% |
6. Total Medicare (Lines 4 +
5a + 5b) |
21,749,744 |
100.0% |
7.9% |
16,064,367 |
100.0% |
10.6% |
73.9% |
28,327 |
627,572 |
0 |
122,671 |
533,228 |
2.5% |
3,484,784 |
16.0% |
7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
2,413,195 |
100.0% |
0.9% |
1,907,873 |
100.0% |
1.3% |
79.1% |
|
|
|
0 |
0 |
0.0% |
414,821 |
17.2% |
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) |
2,413,195 |
100.0% |
0.9% |
1,907,873 |
100.0% |
1.3% |
79.1% |
|
|
0 |
0 |
0 |
0.0% |
414,821 |
17.2% |
10. Private Non-Managed Care |
35,317,690 |
98.0% |
12.9% |
19,641,359 |
97.5% |
12.9% |
55.6% |
|
|
|
370 |
- 370 |
|
10,983,533 |
31.1% |
11a. Private Managed Care (capitated)
|
78,483 |
0.2% |
0.0% |
80,043 |
0.4% |
0.1% |
102.0% |
|
|
0 |
0 |
0 |
0.0% |
-4,264 |
- 5.4% |
11b. Private Managed Care (fee-for-service)
|
633,445 |
1.8% |
0.2% |
419,682 |
2.1% |
0.3% |
66.3% |
|
|
0 |
0 |
0 |
0.0% |
246,226 |
38.9% |
12. Total Private (Lines 10
+ 11a + 11b) |
36,029,618 |
100.0% |
13.1% |
20,141,084 |
100.0% |
13.3% |
55.9% |
|
|
0 |
370 |
- 370 |
- 0.0% |
11,225,495 |
31.2% |
13. Self-Pay |
111,057,041 |
100.0% |
40.5% |
24,294,585 |
100.0% |
16.0% |
21.9% |
|
|
|
|
|
|
|
|
14. Total (Lines 3 + 6 + 9 +
12 + 13) |
274,320,056 |
|
100.0% |
151,697,153 |
|
100.0% |
55.3% |
12,242,951 |
4,909,429 |
81,740 |
733,966 |
16,500,154 |
6.0% |
23,329,278 |
8.5% |
|
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) |
73,056,597 |
65.8% |
9,562,640 |
8.6% |
Data as of: 7/7/2008 5:31:36
|