|
|
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
Regional Summary for Region III for 2007 105 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 |
98,864,910 |
35.5% |
13.2% |
71,464,393 |
31.6% |
15.0% |
72.3% |
971,795 |
2,291,800 |
|
152,325 |
3,111,270 |
3.1% |
22,265,764 |
22.5% |
2a. Medicaid Managed Care (capitated)
|
47,168,647 |
16.9% |
6.3% |
47,617,999 |
21.1% |
10.0% |
101.0% |
11,089,258 |
7,279,728 |
660,512 |
0 |
19,029,498 |
40.3% |
2,737,421 |
5.8% |
2b. Medicaid Managed Care (fee-for-service)
|
132,696,628 |
47.6% |
17.7% |
106,786,564 |
47.3% |
22.4% |
80.5% |
18,510,521 |
10,308,240 |
750,573 |
0 |
29,569,334 |
22.3% |
29,707,947 |
22.4% |
3. Total Medicaid (Lines 1 +
2a + 2b) |
278,730,185 |
100.0% |
37.2% |
225,868,956 |
100.0% |
47.4% |
81.0% |
30,571,574 |
19,879,768 |
1,411,085 |
152,325 |
51,710,102 |
18.6% |
54,711,132 |
19.6% |
4. Medicare Non-Managed Care |
76,396,165 |
89.4% |
10.2% |
55,909,338 |
92.1% |
11.7% |
73.2% |
1,687,513 |
2,374,873 |
|
114,905 |
3,947,481 |
5.2% |
13,746,300 |
18.0% |
5a. Medicare Managed Care (capitated)
|
934,480 |
1.1% |
0.1% |
475,660 |
0.8% |
0.1% |
50.9% |
0 |
0 |
1,875 |
0 |
1,875 |
0.2% |
458,820 |
49.1% |
5b. Medicare Managed Care (fee-for-service)
|
8,169,510 |
9.6% |
1.1% |
4,287,117 |
7.1% |
0.9% |
52.5% |
21,838 |
100,872 |
132,834 |
0 |
255,544 |
3.1% |
3,818,090 |
46.7% |
6. Total Medicare (Lines 4 +
5a + 5b) |
85,500,155 |
100.0% |
11.4% |
60,672,115 |
100.0% |
12.7% |
71.0% |
1,709,351 |
2,475,745 |
134,709 |
114,905 |
4,204,900 |
4.9% |
18,023,210 |
21.1% |
7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
42,480,347 |
97.0% |
5.7% |
39,595,419 |
98.2% |
8.3% |
93.2% |
|
|
|
0 |
0 |
0.0% |
1,461,597 |
3.4% |
8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
472,462 |
1.1% |
0.1% |
304,627 |
0.8% |
0.1% |
64.5% |
|
|
11,603 |
0 |
11,603 |
2.5% |
175,346 |
37.1% |
8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
842,850 |
1.9% |
0.1% |
437,699 |
1.1% |
0.1% |
51.9% |
|
|
0 |
0 |
0 |
0.0% |
174,614 |
20.7% |
9. Total Other Public (Lines
7 + 8a + 8b) |
43,795,659 |
100.0% |
5.8% |
40,337,745 |
100.0% |
8.5% |
92.1% |
|
|
11,603 |
0 |
11,603 |
0.0% |
1,811,557 |
4.1% |
10. Private Non-Managed Care |
148,580,972 |
85.7% |
19.8% |
91,017,116 |
87.8% |
19.1% |
61.3% |
|
|
|
0 |
0 |
|
46,921,320 |
31.6% |
11a. Private Managed Care (capitated)
|
9,552,204 |
5.5% |
1.3% |
5,726,609 |
5.5% |
1.2% |
60.0% |
|
|
144,187 |
0 |
144,187 |
1.5% |
3,972,400 |
41.6% |
11b. Private Managed Care (fee-for-service)
|
15,275,023 |
8.8% |
2.0% |
6,861,580 |
6.6% |
1.4% |
44.9% |
|
|
55,171 |
0 |
55,171 |
0.4% |
7,104,704 |
46.5% |
12. Total Private (Lines 10
+ 11a + 11b) |
173,408,199 |
100.0% |
23.1% |
103,605,305 |
100.0% |
21.7% |
59.7% |
|
|
199,358 |
0 |
199,358 |
0.1% |
57,998,424 |
33.4% |
13. Self-Pay |
168,339,650 |
100.0% |
22.5% |
46,265,452 |
100.0% |
9.7% |
27.5% |
|
|
|
|
|
|
|
|
14. Total (Lines 3 + 6 + 9 +
12 + 13) |
749,773,848 |
|
100.0% |
476,749,573 |
|
100.0% |
63.6% |
32,280,925 |
22,355,513 |
1,756,755 |
267,230 |
56,125,963 |
7.5% |
132,544,323 |
17.7% |
|
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) |
104,170,166 |
61.9% |
19,158,868 |
11.4% |
Data as of: 7/3/2008 11:30:46
|