|
|
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
Regional Summary for Region IV for 2007 195 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 |
288,354,175 |
74.3% |
23.5% |
252,514,419 |
72.2% |
37.2% |
87.6% |
5,035,647 |
6,678,256 |
|
263,918 |
11,449,985 |
4.0% |
37,986,017 |
13.2% |
2a. Medicaid Managed Care (capitated)
|
44,606,702 |
11.5% |
3.6% |
53,338,945 |
15.3% |
7.9% |
119.6% |
8,191,121 |
1,038,282 |
2,805,487 |
0 |
12,034,890 |
27.0% |
-8,753,972 |
- 19.6% |
2b. Medicaid Managed Care (fee-for-service)
|
55,064,248 |
14.2% |
4.5% |
43,909,283 |
12.6% |
6.5% |
79.7% |
12,610,288 |
4,193,429 |
86,423 |
61,916 |
16,828,224 |
30.6% |
13,641,938 |
24.8% |
3. Total Medicaid (Lines 1 +
2a + 2b) |
388,025,125 |
100.0% |
31.7% |
349,762,647 |
100.0% |
51.5% |
90.1% |
25,837,056 |
11,909,967 |
2,891,910 |
325,834 |
40,313,099 |
10.4% |
42,873,983 |
11.0% |
4. Medicare Non-Managed Care |
133,812,325 |
98.1% |
10.9% |
98,796,288 |
98.0% |
14.6% |
73.8% |
969,691 |
2,703,726 |
|
217,579 |
3,455,838 |
2.6% |
26,240,763 |
19.6% |
5a. Medicare Managed Care (capitated)
|
1,095,315 |
0.8% |
0.1% |
1,232,539 |
1.2% |
0.2% |
112.5% |
0 |
0 |
30,171 |
0 |
30,171 |
2.8% |
-171,838 |
- 15.7% |
5b. Medicare Managed Care (fee-for-service)
|
1,523,141 |
1.1% |
0.1% |
805,313 |
0.8% |
0.1% |
52.9% |
0 |
128,858 |
0 |
537 |
128,321 |
8.4% |
502,795 |
33.0% |
6. Total Medicare (Lines 4 +
5a + 5b) |
136,430,781 |
100.0% |
11.1% |
100,834,140 |
100.0% |
14.9% |
73.9% |
969,691 |
2,832,584 |
30,171 |
218,116 |
3,614,330 |
2.6% |
26,571,720 |
19.5% |
7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
9,988,456 |
80.6% |
0.8% |
5,923,387 |
81.8% |
0.9% |
59.3% |
|
|
|
0 |
0 |
0.0% |
3,587,460 |
35.9% |
8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
239,919 |
1.9% |
0.0% |
264,202 |
3.6% |
0.0% |
110.1% |
|
|
0 |
0 |
0 |
0.0% |
-24,283 |
- 10.1% |
8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
2,165,421 |
17.5% |
0.2% |
1,053,795 |
14.6% |
0.2% |
48.7% |
|
|
0 |
0 |
0 |
0.0% |
698,372 |
32.3% |
9. Total Other Public (Lines
7 + 8a + 8b) |
12,393,796 |
100.0% |
1.0% |
7,241,384 |
100.0% |
1.1% |
58.4% |
|
|
0 |
0 |
0 |
0.0% |
4,261,549 |
34.4% |
10. Private Non-Managed Care |
151,224,596 |
94.0% |
12.3% |
84,480,836 |
91.8% |
12.4% |
55.9% |
|
|
|
7,056 |
-7,056 |
|
53,813,649 |
35.6% |
11a. Private Managed Care (capitated)
|
4,615,202 |
2.9% |
0.4% |
4,534,320 |
4.9% |
0.7% |
98.2% |
|
|
67,572 |
0 |
67,572 |
1.5% |
201,809 |
4.4% |
11b. Private Managed Care (fee-for-service)
|
5,031,191 |
3.1% |
0.4% |
2,975,131 |
3.2% |
0.4% |
59.1% |
|
|
15,888 |
3,315 |
12,573 |
0.2% |
1,991,756 |
39.6% |
12. Total Private (Lines 10
+ 11a + 11b) |
160,870,989 |
100.0% |
13.1% |
91,990,287 |
100.0% |
13.6% |
57.2% |
|
|
83,460 |
10,371 |
73,089 |
0.0% |
56,007,214 |
34.8% |
13. Self-Pay |
527,276,686 |
100.0% |
43.0% |
128,862,049 |
100.0% |
19.0% |
24.4% |
|
|
|
|
|
|
|
|
14. Total (Lines 3 + 6 + 9 +
12 + 13) |
1,224,997,377 |
|
100.0% |
678,690,507 |
|
100.0% |
55.4% |
26,806,747 |
14,742,551 |
3,005,541 |
554,321 |
44,000,518 |
3.6% |
129,714,466 |
10.6% |
|
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) |
334,554,898 |
63.4% |
45,695,574 |
8.7% |
Data as of: 7/3/2008 9:04:52
|