| Budget Comparison (Cash
Basis) |
|
Billing, Collection & Denials |
|
|
|
|
| |
|
FY 2005 |
|
FY 2005 |
|
FY 2005 |
|
09/30/05 |
|
| |
|
Approved |
|
Month Budget |
|
Month Actual |
|
|
|
|
Gross Billings |
Bad Debt |
Collections |
|
| Patient Revenues |
|
60,000,000 |
|
60,000,000 |
|
56,359,028 |
|
Medically Indigent
Program |
2,363,580.00 |
8,244.00 |
809,524.00 |
|
| Cafeteria Sales |
|
500,000 |
|
500,000 |
|
382,444 |
|
Medicaid |
|
2,244,168.00 |
31,321.00 |
767,015.00 |
|
| HRSA Grant |
|
46,908 |
|
46,908 |
|
|
|
Medicare |
|
2,248,484.00 |
23,982.00 |
831,454.00 |
|
| Healthy Futures |
|
3,700,000 |
|
3,700,000 |
|
4,791,666 |
|
Pacificare |
|
656,605.00 |
1,084.00 |
783,260.00 |
|
| Healthy Futures - Pt Education |
|
100,000 |
|
100,000 |
|
|
|
Staywell |
|
1,590,616.00 |
966.00 |
1,148,209.00 |
|
| Compact Impact Funds |
|
3,200,000 |
|
3,200,000 |
|
5,457,575 |
|
Calvo's |
|
540,718.00 |
|
168,716.00 |
|
| Misc Revenues |
|
50,000 |
|
50,000 |
|
419,799 |
|
Net care |
|
324,840.00 |
|
176,896.00 |
|
| FEMA |
|
- |
|
|
|
Commercial |
|
141,953.00 |
|
|
|
| GovGuam Subsidy |
|
5,100,000 |
|
5,100,000 |
|
|
|
Miscellaneous |
|
120,335.00 |
1,017.00 |
82,822.00 |
|
| Insurance Settlement |
|
730,844 |
|
Nanbo |
|
|
|
|
| Charitable Donations |
|
100,000 |
|
100,000 |
|
35,137 |
|
FSM |
|
|
|
|
| GTA Sale Proceeds |
|
5,000,000 |
|
GOG |
|
34,480.00 |
46.52 |
5,152.00 |
|
| Total Collections |
|
72,796,908 |
|
72,796,908 |
|
73,176,493 |
|
Healthy Futures Fund |
|
|
1,950,000.00 |
|
| |
|
|
|
|
Self-Pay |
|
2,150,062.00 |
320,593.00 |
360,835.00 |
|
| Salaries |
|
30,380,099 |
|
30,380,099 |
|
30,550,228 |
|
DRT |
|
|
21,702,247.00 |
54,156.00 |
|
| Specialty Pay |
|
679,317 |
|
679,317 |
|
503,397 |
|
Collection Agencies |
|
|
|
|
| Benefits |
|
8,640,252 |
|
8,640,252 |
|
7,963,266 |
|
CAOG |
|
|
4,123,267.00 |
37,071.00 |
|
| Annual Lump Sum |
|
|
- |
|
57,478 |
|
GMMS |
|
|
2,745,687.00 |
20,806.00 |
|
| Other Pay |
|
1,825,384 |
|
1,825,384 |
|
3,284,319 |
|
SAVANT |
|
|
3,759,475.00 |
12,406.00 |
|
| Overtime |
|
2,227,101 |
|
2,227,101 |
|
2,013,794 |
|
UPCA |
|
|
402,143.00 |
|
|
| Total Salaries & Benefits |
|
43,752,153 |
|
43,752,153 |
|
44,372,482 |
|
Total |
|
|
12,415,841.00 |
33,120,072.52 |
7,208,322.00 |
|
|
| Travel & Training |
|
204,850 |
|
204,850 |
|
121,565 |
|
|
| Contractual Services |
|
8,950,172 |
|
8,950,172 |
|
9,772,251 |
|
|
|
|
Accounts
Receivable (Net) |
|
| Supplies & Materials |
|
10,933,289 |
|
10,933,289 |
|
11,782,119 |
|
|
|
Medically Indigent Program |
|
|
6,860,553 |
|
| Minor Equipment |
|
312,327 |
|
312,327 |
|
235,386 |
|
|
|
GovGuam |
|
1,830,651 |
|
| Miscellaneous |
|
284,513 |
|
284,513 |
|
186,274 |
|
Self Pay |
|
2,841,787 |
|
| Utilities |
|
2,215,120 |
|
2,215,120 |
|
1,980,484 |
|
Medicare |
|
2,499,878 |
|
| Capital Outlay |
|
3,292,803 |
|
3,292,803 |
|
593,234 |
|
Medicaid |
|
5,182,323 |
|
| Debt Service |
|
2,851,681 |
|
2,851,681 |
|
249,777 |
|
Commercial |
|
6,171,660 |
|
| Total Cash Disbursements |
|
72,796,908 |
|
72,796,908 |
|
69,293,572 |
|
Total A/R (Net) |
25,386,852 |
|
| Surplus /(Deficit) |
|
- |
|
- |
|
3,882,921 |
|
|
|
|
|
|
|
| Accounts Payable Aging |
|
| 09/30/05 |
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
| House Doctors |
|
1,670 |
|
80,081 |
|
35,026 |
|
25,452 |
|
142,229 |
|
| Trade Payables |
|
583,547 |
|
601,760 |
|
204,039 |
|
496,263 |
|
1,885,609 |
|
| Payroll Payables |
|
|
- |
|
| - Gov Ret DBP |
|
153,039 |
|
1,047,537 |
|
1,200,576 |
|
| - Gov Ret DCP |
|
|
- |
|
| - Dept of Rev |
|
|
- |
|
|
|
| GTA |
|
|
- |
|
| GPA |
|
|
119,756 |
|
1 |
|
588,284 |
|
708,041 |
|
| GWA |
|
18,864 |
|
(53) |
|
18,811 |
|
| Unbilled P O Receipts |
|
|
- |
|
| Total |
|
757,120 |
|
801,597 |
|
239,066 |
|
2,157,483 |
|
3,955,266 |
|
|
|
|
|
|
|
|
|
| Accounts Receivable Aging |
|
|
|
| 09/30/05 |
|
|
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
|
|
| Medically Indigent Program |
|
3,564,629 |
|
1,119,782 |
|
838,774 |
|
9,391,060 |
|
14,914,245 |
|
|
|
| Self Pay |
|
3,195,852 |
|
1,391,249 |
|
1,240,549 |
|
23,189,942 |
|
29,017,592 |
|
|
|
| Medicare |
|
2,808,051 |
|
545,842 |
|
274,428 |
|
1,806,197 |
|
5,434,518 |
|
|
|
| Medicaid |
|
1,525,712 |
|
1,256,178 |
|
1,468,188 |
|
7,015,842 |
|
11,265,920 |
|
|
|
| GovGuam |
|
40,253 |
|
3,958 |
|
7,232 |
|
1,982,614 |
|
2,034,057 |
|
|
|
| Commercial |
|
3,864,966 |
|
1,751,763 |
|
649,259 |
|
7,448,811 |
|
13,714,799 |
|
|
|
| Total |
|
14,999,463 |
|
6,068,772 |
|
4,478,430 |
|
50,834,466 |
|
76,381,131 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|