|
|
 |
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
State Summary for Wisconsin for 2007
16 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 |
109,786,536 |
93.9% |
49.9% |
74,228,611 |
90.4% |
62.3% |
67.6% |
23,398,455 |
13,633,857 |
|
0 |
37,032,312 |
33.7% |
39,826,742 |
36.3% |
| 2a. Medicaid Managed Care (capitated)
|
306,209 |
0.3% |
0.1% |
289,588 |
0.4% |
0.2% |
94.6% |
146,451 |
0 |
0 |
0 |
146,451 |
47.8% |
16,621 |
5.4% |
| 2b. Medicaid Managed Care (fee-for-service)
|
6,796,754 |
5.8% |
3.1% |
7,570,438 |
9.2% |
6.4% |
111.4% |
4,174,232 |
818,919 |
17,147 |
0 |
5,010,298 |
73.7% |
-937,455 |
- 13.8% |
| 3. Total Medicaid (Lines 1 +
2a + 2b) |
116,889,499 |
100.0% |
53.2% |
82,088,637 |
100.0% |
68.9% |
70.2% |
27,719,138 |
14,452,776 |
17,147 |
0 |
42,189,061 |
36.1% |
38,905,908 |
33.3% |
| 4. Medicare Non-Managed Care |
38,551,153 |
99.0% |
17.5% |
10,750,570 |
99.0% |
9.0% |
27.9% |
18,301 |
35,348 |
|
12,648 |
41,001 |
0.1% |
28,247,196 |
73.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)
|
398,584 |
1.0% |
0.2% |
112,331 |
1.0% |
0.1% |
28.2% |
0 |
252 |
0 |
0 |
252 |
0.1% |
216,027 |
54.2% |
| 6. Total Medicare (Lines 4 +
5a + 5b) |
38,949,737 |
100.0% |
17.7% |
10,862,901 |
100.0% |
9.1% |
27.9% |
18,301 |
35,600 |
0 |
12,648 |
41,253 |
0.1% |
28,463,223 |
73.1% |
| 7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
71,441 |
100.0% |
0.0% |
18,442 |
100.0% |
0.0% |
25.8% |
|
|
|
0 |
0 |
0.0% |
38,797 |
54.3% |
| 8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
|
|
0 |
0 |
0 |
--- |
0 |
--- |
| 8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
0 |
0.0% |
0.0% |
0 |
0.0% |
0.0% |
--- |
|
|
0 |
0 |
0 |
--- |
0 |
--- |
| 9. Total Other Public (Lines
7 + 8a + 8b) |
71,441 |
100.0% |
0.0% |
18,442 |
100.0% |
0.0% |
25.8% |
|
|
0 |
0 |
0 |
0.0% |
38,797 |
54.3% |
| 10. Private Non-Managed Care |
30,352,010 |
98.8% |
13.8% |
18,975,113 |
99.3% |
15.9% |
62.5% |
|
|
|
0 |
0 |
|
7,040,040 |
23.2% |
| 11a. Private Managed Care (capitated)
|
68,495 |
0.2% |
0.0% |
28,784 |
0.2% |
0.0% |
42.0% |
|
|
0 |
0 |
0 |
0.0% |
39,757 |
58.0% |
| 11b. Private Managed Care (fee-for-service)
|
294,701 |
1.0% |
0.1% |
114,014 |
0.6% |
0.1% |
38.7% |
|
|
0 |
0 |
0 |
0.0% |
165,852 |
56.3% |
| 12. Total Private (Lines 10
+ 11a + 11b) |
30,715,206 |
100.0% |
14.0% |
19,117,911 |
100.0% |
16.1% |
62.2% |
|
|
0 |
0 |
0 |
0.0% |
7,245,649 |
23.6% |
| 13. Self-Pay |
33,256,818 |
100.0% |
15.1% |
6,973,885 |
100.0% |
5.9% |
21.0% |
|
|
|
|
|
|
|
|
| 14. Total (Lines 3 + 6 + 9 +
12 + 13) |
219,882,701 |
|
100.0% |
119,061,776 |
|
100.0% |
54.1% |
27,737,439 |
14,488,376 |
17,147 |
12,648 |
42,230,314 |
19.2% |
74,653,577 |
34.0% |
|
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) |
22,419,131 |
67.4% |
3,538,350 |
10.6% |
Data as of: 7/22/2008 4:32:26
|
