|
|
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
Regional Summary for Region VIII for 2007 55 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 |
119,082,538 |
79.9% |
26.1% |
96,118,437 |
85.3% |
45.1% |
80.7% |
488,935 |
955,749 |
|
0 |
1,444,684 |
1.2% |
17,649,262 |
14.8% |
2a. Medicaid Managed Care (capitated)
|
29,933,326 |
20.1% |
6.5% |
16,410,751 |
14.6% |
7.7% |
54.8% |
9,649,075 |
0 |
0 |
0 |
9,649,075 |
32.2% |
13,536,272 |
45.2% |
2b. Medicaid Managed Care (fee-for-service)
|
62,867 |
0.0% |
0.0% |
161,163 |
0.1% |
0.1% |
256.4% |
0 |
0 |
0 |
0 |
0 |
0.0% |
103,086 |
164.0% |
3. Total Medicaid (Lines 1 +
2a + 2b) |
149,078,731 |
100.0% |
32.6% |
112,690,351 |
100.0% |
52.9% |
75.6% |
10,138,010 |
955,749 |
0 |
0 |
11,093,759 |
7.4% |
31,288,620 |
21.0% |
4. Medicare Non-Managed Care |
34,288,161 |
86.9% |
7.5% |
22,476,310 |
93.8% |
10.5% |
65.6% |
446,993 |
477,255 |
|
400,317 |
523,931 |
1.5% |
11,576,291 |
33.8% |
5a. Medicare Managed Care (capitated)
|
4,972,285 |
12.6% |
1.1% |
1,357,529 |
5.7% |
0.6% |
27.3% |
0 |
0 |
0 |
0 |
0 |
0.0% |
3,614,755 |
72.7% |
5b. Medicare Managed Care (fee-for-service)
|
176,985 |
0.4% |
0.0% |
121,128 |
0.5% |
0.1% |
68.4% |
0 |
0 |
0 |
0 |
0 |
0.0% |
66,896 |
37.8% |
6. Total Medicare (Lines 4 +
5a + 5b) |
39,437,431 |
100.0% |
8.6% |
23,954,967 |
100.0% |
11.2% |
60.7% |
446,993 |
477,255 |
0 |
400,317 |
523,931 |
1.3% |
15,257,942 |
38.7% |
7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
6,219,550 |
62.5% |
1.4% |
3,452,299 |
56.2% |
1.6% |
55.5% |
|
|
|
0 |
0 |
0.0% |
2,482,838 |
39.9% |
8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
2,737,767 |
27.5% |
0.6% |
2,094,259 |
34.1% |
1.0% |
76.5% |
|
|
0 |
0 |
0 |
0.0% |
839,770 |
30.7% |
8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
987,565 |
9.9% |
0.2% |
598,396 |
9.7% |
0.3% |
60.6% |
|
|
0 |
0 |
0 |
0.0% |
211,442 |
21.4% |
9. Total Other Public (Lines
7 + 8a + 8b) |
9,944,882 |
100.0% |
2.2% |
6,144,954 |
100.0% |
2.9% |
61.8% |
|
|
0 |
0 |
0 |
0.0% |
3,534,050 |
35.5% |
10. Private Non-Managed Care |
41,523,775 |
83.9% |
9.1% |
26,218,678 |
85.8% |
12.3% |
63.1% |
|
|
|
586 |
- 586 |
|
11,344,156 |
27.3% |
11a. Private Managed Care (capitated)
|
7,666,620 |
15.5% |
1.7% |
4,121,522 |
13.5% |
1.9% |
53.8% |
|
|
0 |
0 |
0 |
0.0% |
3,834,755 |
50.0% |
11b. Private Managed Care (fee-for-service)
|
297,505 |
0.6% |
0.1% |
213,511 |
0.7% |
0.1% |
71.8% |
|
|
0 |
0 |
0 |
0.0% |
88,185 |
29.6% |
12. Total Private (Lines 10
+ 11a + 11b) |
49,487,900 |
100.0% |
10.8% |
30,553,711 |
100.0% |
14.3% |
61.7% |
|
|
0 |
586 |
- 586 |
- 0.0% |
15,267,096 |
30.9% |
13. Self-Pay |
209,075,923 |
100.0% |
45.7% |
39,864,845 |
100.0% |
18.7% |
19.1% |
|
|
|
|
|
|
|
|
14. Total (Lines 3 + 6 + 9 +
12 + 13) |
457,024,867 |
|
100.0% |
213,208,828 |
|
100.0% |
46.7% |
10,585,003 |
1,433,004 |
0 |
400,903 |
11,617,104 |
2.5% |
65,347,708 |
14.3% |
|
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) |
149,227,879 |
71.4% |
21,742,057 |
10.4% |
Data as of: 7/7/2008 5:45:09
|