|
|
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
Regional Summary for Region II for 2007 88 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 |
265,515,361 |
35.5% |
20.8% |
180,431,845 |
33.0% |
25.1% |
68.0% |
1,106,550 |
2,491,197 |
|
1,921,066 |
1,676,681 |
0.6% |
69,168,883 |
26.1% |
2a. Medicaid Managed Care (capitated)
|
292,792,509 |
39.1% |
22.9% |
238,919,912 |
43.7% |
33.2% |
81.6% |
62,829,252 |
25,298,102 |
4,927,025 |
401,659 |
92,652,720 |
31.6% |
62,584,753 |
21.4% |
2b. Medicaid Managed Care (fee-for-service)
|
190,028,457 |
25.4% |
14.9% |
127,802,462 |
23.4% |
17.7% |
67.3% |
40,406,614 |
7,522,930 |
2,998,278 |
706,787 |
50,221,035 |
26.4% |
58,528,652 |
30.8% |
3. Total Medicaid (Lines 1 +
2a + 2b) |
748,336,327 |
100.0% |
58.6% |
547,154,219 |
100.0% |
76.0% |
73.1% |
104,342,416 |
35,312,229 |
7,925,303 |
3,029,512 |
144,550,436 |
19.3% |
190,282,288 |
25.4% |
4. Medicare Non-Managed Care |
77,601,310 |
78.8% |
6.1% |
40,890,824 |
81.2% |
5.7% |
52.7% |
31,194 |
175,312 |
|
47,652 |
158,854 |
0.2% |
26,371,852 |
34.0% |
5a. Medicare Managed Care (capitated)
|
5,787,500 |
5.9% |
0.5% |
3,415,346 |
6.8% |
0.5% |
59.0% |
0 |
0 |
45,743 |
0 |
45,743 |
0.8% |
2,372,154 |
41.0% |
5b. Medicare Managed Care (fee-for-service)
|
15,100,559 |
15.3% |
1.2% |
6,036,050 |
12.0% |
0.8% |
40.0% |
191,692 |
205,299 |
733,441 |
0 |
1,130,432 |
7.5% |
3,975,224 |
26.3% |
6. Total Medicare (Lines 4 +
5a + 5b) |
98,489,369 |
100.0% |
7.7% |
50,342,220 |
100.0% |
7.0% |
51.1% |
222,886 |
380,611 |
779,184 |
47,652 |
1,335,029 |
1.4% |
32,719,230 |
33.2% |
7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
4,467,114 |
14.8% |
0.3% |
2,661,807 |
19.0% |
0.4% |
59.6% |
|
|
|
14,077 |
-14,077 |
- 0.3% |
1,665,298 |
37.3% |
8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
14,775,946 |
49.1% |
1.2% |
7,585,256 |
54.3% |
1.1% |
51.3% |
|
|
285,009 |
0 |
285,009 |
1.9% |
7,183,592 |
48.6% |
8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
10,870,303 |
36.1% |
0.9% |
3,727,452 |
26.7% |
0.5% |
34.3% |
|
|
9,870 |
0 |
9,870 |
0.1% |
6,487,155 |
59.7% |
9. Total Other Public (Lines
7 + 8a + 8b) |
30,113,363 |
100.0% |
2.4% |
13,974,515 |
100.0% |
1.9% |
46.4% |
|
|
294,879 |
14,077 |
280,802 |
0.9% |
15,336,045 |
50.9% |
10. Private Non-Managed Care |
101,976,379 |
63.5% |
8.0% |
43,944,336 |
61.2% |
6.1% |
43.1% |
|
|
|
0 |
0 |
|
49,096,028 |
48.1% |
11a. Private Managed Care (capitated)
|
8,977,716 |
5.6% |
0.7% |
3,269,978 |
4.6% |
0.5% |
36.4% |
|
|
100,227 |
0 |
100,227 |
1.1% |
5,904,959 |
65.8% |
11b. Private Managed Care (fee-for-service)
|
49,557,210 |
30.9% |
3.9% |
24,585,308 |
34.2% |
3.4% |
49.6% |
|
|
798,989 |
0 |
798,989 |
1.6% |
22,413,559 |
45.2% |
12. Total Private (Lines 10
+ 11a + 11b) |
160,511,305 |
100.0% |
12.6% |
71,799,622 |
100.0% |
10.0% |
44.7% |
|
|
899,216 |
0 |
899,216 |
0.6% |
77,414,546 |
48.2% |
13. Self-Pay |
238,998,044 |
100.0% |
18.7% |
36,770,579 |
100.0% |
5.1% |
15.4% |
|
|
|
|
|
|
|
|
14. Total (Lines 3 + 6 + 9 +
12 + 13) |
1,276,448,408 |
|
100.0% |
720,041,155 |
|
100.0% |
56.4% |
104,565,302 |
35,692,840 |
9,898,582 |
3,091,241 |
147,065,483 |
11.5% |
315,752,109 |
24.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) |
162,622,987 |
68.0% |
29,909,608 |
12.5% |
Data as of: 7/3/2008 11:22:24
|