|
|
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
Regional Summary for Region X for 2007 84 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 |
179,641,334 |
64.7% |
28.1% |
146,238,802 |
41.7% |
27.5% |
81.4% |
30,765,643 |
3,999,514 |
|
14,024 |
34,751,133 |
19.3% |
38,358,884 |
21.4% |
2a. Medicaid Managed Care (capitated)
|
52,832,786 |
19.0% |
8.3% |
143,820,682 |
41.0% |
27.1% |
272.2% |
61,469,125 |
8,520,313 |
23,440,956 |
51,407 |
93,378,987 |
176.7% |
-88,151,009 |
- 166.8% |
2b. Medicaid Managed Care (fee-for-service)
|
45,145,025 |
16.3% |
7.1% |
60,392,001 |
17.2% |
11.4% |
133.8% |
4,309,833 |
27,810,478 |
337,998 |
17,777 |
32,440,532 |
71.9% |
-12,386,303 |
- 27.4% |
3. Total Medicaid (Lines 1 +
2a + 2b) |
277,619,145 |
100.0% |
43.4% |
350,451,485 |
100.0% |
66.0% |
126.2% |
96,544,601 |
40,330,305 |
23,778,954 |
83,208 |
160,570,652 |
57.8% |
-62,178,428 |
- 22.4% |
4. Medicare Non-Managed Care |
44,473,470 |
93.1% |
6.9% |
29,313,023 |
94.1% |
5.5% |
65.9% |
190,865 |
891,536 |
|
8,076 |
1,074,325 |
2.4% |
8,147,776 |
18.3% |
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)
|
3,274,364 |
6.9% |
0.5% |
1,843,016 |
5.9% |
0.3% |
56.3% |
0 |
77,665 |
0 |
213 |
77,452 |
2.4% |
1,198,805 |
36.6% |
6. Total Medicare (Lines 4 +
5a + 5b) |
47,747,834 |
100.0% |
7.5% |
31,156,039 |
100.0% |
5.9% |
65.3% |
190,865 |
969,201 |
0 |
8,289 |
1,151,777 |
2.4% |
9,346,581 |
19.6% |
7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
4,419,971 |
17.6% |
0.7% |
3,145,431 |
7.5% |
0.6% |
71.2% |
|
|
|
816 |
- 816 |
- 0.0% |
1,026,370 |
23.2% |
8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
18,439,461 |
73.5% |
2.9% |
37,873,085 |
90.1% |
7.1% |
205.4% |
|
|
14,813,850 |
2,138 |
14,811,712 |
80.3% |
-17,073,126 |
- 92.6% |
8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
2,214,785 |
8.8% |
0.3% |
1,028,557 |
2.4% |
0.2% |
46.4% |
|
|
1,686 |
785 |
901 |
0.0% |
1,183,248 |
53.4% |
9. Total Other Public (Lines
7 + 8a + 8b) |
25,074,217 |
100.0% |
3.9% |
42,047,073 |
100.0% |
7.9% |
167.7% |
|
|
14,815,536 |
3,739 |
14,811,797 |
59.1% |
-14,863,508 |
- 59.3% |
10. Private Non-Managed Care |
84,612,212 |
99.7% |
13.2% |
51,321,381 |
99.6% |
9.7% |
60.7% |
|
|
|
55,445 |
-55,445 |
|
24,005,801 |
28.4% |
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)
|
270,182 |
0.3% |
0.0% |
199,298 |
0.4% |
0.0% |
73.8% |
|
|
1,341 |
0 |
1,341 |
0.5% |
64,227 |
23.8% |
12. Total Private (Lines 10
+ 11a + 11b) |
84,882,394 |
100.0% |
13.3% |
51,520,679 |
100.0% |
9.7% |
60.7% |
|
|
1,341 |
55,445 |
-54,104 |
- 0.1% |
24,070,028 |
28.4% |
13. Self-Pay |
204,616,020 |
100.0% |
32.0% |
55,708,830 |
100.0% |
10.5% |
27.2% |
|
|
|
|
|
|
|
|
14. Total (Lines 3 + 6 + 9 +
12 + 13) |
639,939,610 |
|
100.0% |
530,884,106 |
|
100.0% |
83.0% |
96,735,466 |
41,299,506 |
38,595,831 |
150,681 |
176,480,122 |
27.6% |
-43,625,327 |
- 6.8% |
|
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) |
120,259,925 |
58.8% |
20,567,628 |
10.1% |
Data as of: 7/7/2008 5:58:59
|