|
|
 |
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
State Summary for Michigan for 2007
30 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 |
41,783,632 |
46.1% |
19.7% |
41,216,995 |
44.1% |
26.1% |
98.6% |
20,131,179 |
3,366,110 |
|
271,116 |
23,226,173 |
55.6% |
2,354,515 |
5.6% |
| 2a. Medicaid Managed Care (capitated)
|
13,067,255 |
14.4% |
6.1% |
13,643,334 |
14.6% |
8.6% |
104.4% |
7,677,711 |
947,468 |
404,761 |
231,494 |
8,798,446 |
67.3% |
-1,164,295 |
- 8.9% |
| 2b. Medicaid Managed Care (fee-for-service)
|
35,787,277 |
39.5% |
16.8% |
38,643,393 |
41.3% |
24.5% |
108.0% |
17,650,391 |
3,030,390 |
734,962 |
162,193 |
21,253,550 |
59.4% |
-803,810 |
- 2.2% |
| 3. Total Medicaid (Lines 1 +
2a + 2b) |
90,638,164 |
100.0% |
42.6% |
93,503,722 |
100.0% |
59.3% |
103.2% |
45,459,281 |
7,343,968 |
1,139,723 |
664,803 |
53,278,169 |
58.8% |
386,410 |
0.4% |
| 4. Medicare Non-Managed Care |
20,191,441 |
95.7% |
9.5% |
17,893,489 |
98.8% |
11.3% |
88.6% |
548,517 |
427,241 |
|
47,648 |
928,110 |
4.6% |
2,513,902 |
12.5% |
| 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)
|
912,408 |
4.3% |
0.4% |
218,871 |
1.2% |
0.1% |
24.0% |
0 |
0 |
12,776 |
0 |
12,776 |
1.4% |
223,227 |
24.5% |
| 6. Total Medicare (Lines 4 +
5a + 5b) |
21,103,849 |
100.0% |
9.9% |
18,112,360 |
100.0% |
11.5% |
85.8% |
548,517 |
427,241 |
12,776 |
47,648 |
940,886 |
4.5% |
2,737,129 |
13.0% |
| 7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
2,678,378 |
87.7% |
1.3% |
1,331,316 |
85.0% |
0.8% |
49.7% |
|
|
|
0 |
0 |
0.0% |
1,406,833 |
52.5% |
| 8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
43,545 |
1.4% |
0.0% |
106,464 |
6.8% |
0.1% |
244.5% |
|
|
0 |
0 |
0 |
0.0% |
-62,919 |
- 144.5% |
| 8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
332,887 |
10.9% |
0.2% |
128,927 |
8.2% |
0.1% |
38.7% |
|
|
0 |
0 |
0 |
0.0% |
144,041 |
43.3% |
| 9. Total Other Public (Lines
7 + 8a + 8b) |
3,054,810 |
100.0% |
1.4% |
1,566,707 |
100.0% |
1.0% |
51.3% |
|
|
0 |
0 |
0 |
0.0% |
1,487,955 |
48.7% |
| 10. Private Non-Managed Care |
36,948,307 |
90.7% |
17.4% |
26,985,139 |
90.5% |
17.1% |
73.0% |
|
|
|
0 |
0 |
|
10,202,072 |
27.6% |
| 11a. Private Managed Care (capitated)
|
1,845,374 |
4.5% |
0.9% |
1,377,798 |
4.6% |
0.9% |
74.7% |
|
|
57,971 |
0 |
57,971 |
3.1% |
467,557 |
25.3% |
| 11b. Private Managed Care (fee-for-service)
|
1,950,283 |
4.8% |
0.9% |
1,454,693 |
4.9% |
0.9% |
74.6% |
|
|
83,437 |
0 |
83,437 |
4.3% |
479,510 |
24.6% |
| 12. Total Private (Lines 10
+ 11a + 11b) |
40,743,964 |
100.0% |
19.2% |
29,817,630 |
100.0% |
18.9% |
73.2% |
|
|
141,408 |
0 |
141,408 |
0.3% |
11,149,139 |
27.4% |
| 13. Self-Pay |
57,093,824 |
100.0% |
26.9% |
14,809,725 |
100.0% |
9.4% |
25.9% |
|
|
|
|
|
|
|
|
| 14. Total (Lines 3 + 6 + 9 +
12 + 13) |
212,634,611 |
|
100.0% |
157,810,144 |
|
100.0% |
74.2% |
46,007,798 |
7,771,209 |
1,293,907 |
712,451 |
54,360,463 |
25.6% |
15,760,633 |
7.4% |
|
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) |
34,792,591 |
60.9% |
3,241,655 |
5.7% |
data as of: 7/22/2008 3:45:24
|
