|
|
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
State Summary for Florida for 2007 40 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 |
93,707,474 |
73.2% |
25.2% |
77,962,434 |
73.3% |
40.7% |
83.2% |
1,937,369 |
1,401,133 |
|
0 |
3,338,502 |
3.6% |
18,349,176 |
19.6% |
2a. Medicaid Managed Care (capitated)
|
18,706,365 |
14.6% |
5.0% |
17,382,702 |
16.3% |
9.1% |
92.9% |
1,799,021 |
544,042 |
1,179,722 |
0 |
3,522,785 |
18.8% |
1,253,042 |
6.7% |
2b. Medicaid Managed Care (fee-for-service)
|
15,559,258 |
12.2% |
4.2% |
11,066,194 |
10.4% |
5.8% |
71.1% |
2,785,680 |
893,908 |
0 |
59,771 |
3,619,817 |
23.3% |
4,124,360 |
26.5% |
3. Total Medicaid (Lines 1 +
2a + 2b) |
127,973,097 |
100.0% |
34.4% |
106,411,330 |
100.0% |
55.5% |
83.2% |
6,522,070 |
2,839,083 |
1,179,722 |
59,771 |
10,481,104 |
8.2% |
23,726,578 |
18.5% |
4. Medicare Non-Managed Care |
21,571,201 |
93.3% |
5.8% |
17,919,401 |
91.9% |
9.4% |
83.1% |
111,679 |
420,644 |
|
37,937 |
494,386 |
2.3% |
3,625,877 |
16.8% |
5a. Medicare Managed Care (capitated)
|
1,095,315 |
4.7% |
0.3% |
1,232,539 |
6.3% |
0.6% |
112.5% |
0 |
0 |
30,171 |
0 |
30,171 |
2.8% |
-171,838 |
- 15.7% |
5b. Medicare Managed Care (fee-for-service)
|
448,533 |
1.9% |
0.1% |
337,911 |
1.7% |
0.2% |
75.3% |
0 |
128,858 |
0 |
537 |
128,321 |
28.6% |
148,515 |
33.1% |
6. Total Medicare (Lines 4 +
5a + 5b) |
23,115,049 |
100.0% |
6.2% |
19,489,851 |
100.0% |
10.2% |
84.3% |
111,679 |
549,502 |
30,171 |
38,474 |
652,878 |
2.8% |
3,602,554 |
15.6% |
7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
4,270,681 |
69.9% |
1.1% |
2,051,576 |
71.6% |
1.1% |
48.0% |
|
|
|
0 |
0 |
0.0% |
2,170,688 |
50.8% |
8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
112,283 |
1.8% |
0.0% |
86,410 |
3.0% |
0.0% |
77.0% |
|
|
0 |
0 |
0 |
0.0% |
25,873 |
23.0% |
8b. Other Public including Non-Medicaid
CHIP (Managed Care fee-for-service) |
1,725,942 |
28.3% |
0.5% |
728,160 |
25.4% |
0.4% |
42.2% |
|
|
0 |
0 |
0 |
0.0% |
698,372 |
40.5% |
9. Total Other Public (Lines
7 + 8a + 8b) |
6,108,906 |
100.0% |
1.6% |
2,866,146 |
100.0% |
1.5% |
46.9% |
|
|
0 |
0 |
0 |
0.0% |
2,894,933 |
47.4% |
10. Private Non-Managed Care |
31,252,202 |
93.0% |
8.4% |
17,559,480 |
93.5% |
9.2% |
56.2% |
|
|
|
0 |
0 |
|
12,188,235 |
39.0% |
11a. Private Managed Care (capitated)
|
321,252 |
1.0% |
0.1% |
211,561 |
1.1% |
0.1% |
65.9% |
|
|
0 |
0 |
0 |
0.0% |
109,691 |
34.1% |
11b. Private Managed Care (fee-for-service)
|
2,047,259 |
6.1% |
0.6% |
1,004,820 |
5.4% |
0.5% |
49.1% |
|
|
0 |
3,315 |
-3,315 |
- 0.2% |
870,265 |
42.5% |
12. Total Private (Lines 10
+ 11a + 11b) |
33,620,713 |
100.0% |
9.0% |
18,775,861 |
100.0% |
9.8% |
55.8% |
|
|
0 |
3,315 |
-3,315 |
- 0.0% |
13,168,191 |
39.2% |
13. Self-Pay |
181,069,549 |
100.0% |
48.7% |
44,017,748 |
100.0% |
23.0% |
24.3% |
|
|
|
|
|
|
|
|
14. Total (Lines 3 + 6 + 9 +
12 + 13) |
371,887,314 |
|
100.0% |
191,560,936 |
|
100.0% |
51.5% |
6,633,749 |
3,388,585 |
1,209,893 |
101,560 |
11,130,667 |
3.0% |
43,392,256 |
11.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) |
108,836,442 |
60.1% |
15,396,079 |
8.5% |
data as of: 7/22/2008 11:44:49
|