|
|
 |
|
|
TABLE 9D: PATIENT RELATED REVENUE (Scope of Project Only)
State Summary for Colorado for 2007
14 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 |
92,217,911 |
75.5% |
27.9% |
68,521,954 |
80.5% |
48.1% |
74.3% |
0 |
0 |
|
0 |
0 |
0.0% |
17,909,334 |
19.4% |
| 2a. Medicaid Managed Care (capitated)
|
29,933,326 |
24.5% |
9.0% |
16,410,751 |
19.3% |
11.5% |
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.1% |
0.0% |
161,163 |
0.2% |
0.1% |
256.4% |
0 |
0 |
0 |
0 |
0 |
0.0% |
103,086 |
164.0% |
| 3. Total Medicaid (Lines 1 +
2a + 2b) |
122,214,104 |
100.0% |
36.9% |
85,093,868 |
100.0% |
59.8% |
69.6% |
9,649,075 |
0 |
0 |
0 |
9,649,075 |
7.9% |
31,548,692 |
25.8% |
| 4. Medicare Non-Managed Care |
20,825,350 |
80.2% |
6.3% |
12,272,744 |
89.2% |
8.6% |
58.9% |
4,923 |
223,226 |
|
161,572 |
66,577 |
0.3% |
9,959,386 |
47.8% |
| 5a. Medicare Managed Care (capitated)
|
4,972,285 |
19.1% |
1.5% |
1,357,529 |
9.9% |
1.0% |
27.3% |
0 |
0 |
0 |
0 |
0 |
0.0% |
3,614,755 |
72.7% |
| 5b. Medicare Managed Care (fee-for-service)
|
176,985 |
0.7% |
0.1% |
121,128 |
0.9% |
0.1% |
68.4% |
0 |
0 |
0 |
0 |
0 |
0.0% |
66,896 |
37.8% |
| 6. Total Medicare (Lines 4 +
5a + 5b) |
25,974,620 |
100.0% |
7.8% |
13,751,401 |
100.0% |
9.7% |
52.9% |
4,923 |
223,226 |
0 |
161,572 |
66,577 |
0.3% |
13,641,037 |
52.5% |
| 7. Other Public including Non-Medicaid
CHIP (Non Managed Care) |
4,933,267 |
57.0% |
1.5% |
2,909,291 |
51.9% |
2.0% |
59.0% |
|
|
|
0 |
0 |
0.0% |
2,045,688 |
41.5% |
| 8a. Other Public including Non-Medicaid
CHIP (Managed Care Capitated) |
2,737,767 |
31.6% |
0.8% |
2,094,259 |
37.4% |
1.5% |
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 |
11.4% |
0.3% |
598,396 |
10.7% |
0.4% |
60.6% |
|
|
0 |
0 |
0 |
0.0% |
211,442 |
21.4% |
| 9. Total Other Public (Lines
7 + 8a + 8b) |
8,658,599 |
100.0% |
2.6% |
5,601,946 |
100.0% |
3.9% |
64.7% |
|
|
0 |
0 |
0 |
0.0% |
3,096,900 |
35.8% |
| 10. Private Non-Managed Care |
17,033,436 |
68.8% |
5.1% |
9,505,121 |
69.5% |
6.7% |
55.8% |
|
|
|
0 |
0 |
|
6,659,567 |
39.1% |
| 11a. Private Managed Care (capitated)
|
7,666,620 |
31.0% |
2.3% |
4,121,522 |
30.2% |
2.9% |
53.8% |
|
|
0 |
0 |
0 |
0.0% |
3,834,755 |
50.0% |
| 11b. Private Managed Care (fee-for-service)
|
64,199 |
0.3% |
0.0% |
43,021 |
0.3% |
0.0% |
67.0% |
|
|
0 |
0 |
0 |
0.0% |
30,260 |
47.1% |
| 12. Total Private (Lines 10
+ 11a + 11b) |
24,764,255 |
100.0% |
7.5% |
13,669,664 |
100.0% |
9.6% |
55.2% |
|
|
0 |
0 |
0 |
0.0% |
10,524,582 |
42.5% |
| 13. Self-Pay |
149,293,034 |
100.0% |
45.1% |
24,222,201 |
100.0% |
17.0% |
16.2% |
|
|
|
|
|
|
|
|
| 14. Total (Lines 3 + 6 + 9 +
12 + 13) |
330,904,612 |
|
100.0% |
142,339,080 |
|
100.0% |
43.0% |
9,653,998 |
223,226 |
0 |
161,572 |
9,715,652 |
2.9% |
58,811,211 |
17.8% |
|
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) |
109,323,360 |
73.2% |
17,320,281 |
11.6% |
data as of: 7/22/2008 11:18:28
|
