|
|
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
Regional Summary for Region VI for 2007 120 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 |
133,095,041 |
68.9% |
20.1% |
121,430,206 |
71.5% |
36.9% |
91.2% |
3,288,548 |
1,145,526 |
|
27,092 |
4,406,982 |
3.3% |
8,055,586 |
6.1% |
2a. Medicaid Managed Care (capitated)
|
11,256,537 |
5.8% |
1.7% |
12,595,347 |
7.4% |
3.8% |
111.9% |
5,322,630 |
758,717 |
338,159 |
0 |
6,419,506 |
57.0% |
-1,525,010 |
- 13.5% |
2b. Medicaid Managed Care (fee-for-service)
|
48,801,461 |
25.3% |
7.4% |
35,794,171 |
21.1% |
10.9% |
73.3% |
11,633,064 |
3,668,844 |
295,565 |
27,901 |
15,569,572 |
31.9% |
11,228,640 |
23.0% |
3. Total Medicaid (Lines 1 +
2a + 2b) |
193,153,039 |
100.0% |
29.1% |
169,819,724 |
100.0% |
51.6% |
87.9% |
20,244,242 |
5,573,087 |
633,724 |
54,993 |
26,396,060 |
13.7% |
17,759,216 |
9.2% |
4. Medicare Non-Managed Care |
54,797,109 |
99.3% |
8.3% |
41,578,983 |
99.4% |
12.6% |
75.9% |
272,973 |
604,262 |
|
149,910 |
727,325 |
1.3% |
8,122,659 |
14.8% |
5a. Medicare Managed Care (capitated)
|
297,856 |
0.5% |
0.0% |
221,125 |
0.5% |
0.1% |
74.2% |
0 |
0 |
0 |
0 |
0 |
0.0% |
78,071 |
26.2% |
5b. Medicare Managed Care (fee-for-service)
|
116,182 |
0.2% |
0.0% |
39,864 |
0.1% |
0.0% |
34.3% |
0 |
0 |
0 |
0 |
0 |
0.0% |
42,316 |
36.4% |
6. Total Medicare (Lines 4 +
5a + 5b) |
55,211,147 |
100.0% |
8.3% |
41,839,972 |
100.0% |
12.7% |
75.8% |
272,973 |
604,262 |
0 |
149,910 |
727,325 |
1.3% |
8,243,046 |
14.9% |
7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
27,949,059 |
80.8% |
4.2% |
8,703,239 |
74.1% |
2.6% |
31.1% |
|
|
|
0 |
0 |
0.0% |
15,267,310 |
54.6% |
8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
1,776,021 |
5.1% |
0.3% |
1,512,408 |
12.9% |
0.5% |
85.2% |
|
|
0 |
0 |
0 |
0.0% |
260,541 |
14.7% |
8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
4,881,072 |
14.1% |
0.7% |
1,525,194 |
13.0% |
0.5% |
31.2% |
|
|
0 |
0 |
0 |
0.0% |
2,630,729 |
53.9% |
9. Total Other Public (Lines
7 + 8a + 8b) |
34,606,152 |
100.0% |
5.2% |
11,740,841 |
100.0% |
3.6% |
33.9% |
|
|
0 |
0 |
0 |
0.0% |
18,158,580 |
52.5% |
10. Private Non-Managed Care |
54,405,412 |
89.9% |
8.2% |
27,456,213 |
89.5% |
8.3% |
50.5% |
|
|
|
0 |
0 |
|
20,550,349 |
37.8% |
11a. Private Managed Care (capitated)
|
3,989,123 |
6.6% |
0.6% |
2,413,606 |
7.9% |
0.7% |
60.5% |
|
|
36,071 |
0 |
36,071 |
0.9% |
1,574,112 |
39.5% |
11b. Private Managed Care (fee-for-service)
|
2,092,799 |
3.5% |
0.3% |
790,693 |
2.6% |
0.2% |
37.8% |
|
|
0 |
0 |
0 |
0.0% |
706,012 |
33.7% |
12. Total Private (Lines 10
+ 11a + 11b) |
60,487,334 |
100.0% |
9.1% |
30,660,512 |
100.0% |
9.3% |
50.7% |
|
|
36,071 |
0 |
36,071 |
0.1% |
22,830,473 |
37.7% |
13. Self-Pay |
319,606,627 |
100.0% |
48.2% |
75,183,224 |
100.0% |
22.8% |
23.5% |
|
|
|
|
|
|
|
|
14. Total (Lines 3 + 6 + 9 +
12 + 13) |
663,064,299 |
|
100.0% |
329,244,273 |
|
100.0% |
49.7% |
20,517,215 |
6,177,349 |
669,795 |
204,903 |
27,159,456 |
4.1% |
66,991,315 |
10.1% |
|
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) |
207,739,399 |
65.0% |
33,360,170 |
10.4% |
Data as of: 7/7/2008 5:25:03
|