| Budget Comparison (Cash
Basis) |
|
Billing, Collection & Denials |
|
|
| |
|
FY 2005 |
|
FY 2005 |
|
FY 2005 |
|
05/31/05 |
|
| |
|
Approved |
|
8 Month
Budget |
|
8 Month
Actual |
|
|
|
|
Gross Billings |
Bad Debt |
Collections |
|
| Patient Revenues |
|
60,000,000 |
|
40,000,000 |
|
36,470,036 |
|
Medically Indigent
Program |
2,370,261 |
34,796 |
2,152,225 |
|
| Cafeteria Sales |
|
500,000 |
|
333,333 |
|
250,537 |
|
Medicaid |
|
1,409,148 |
40,909 |
92,602 |
|
| HRSA Grant |
|
46,908 |
|
31,272 |
|
|
|
Medicare |
|
1,920,925 |
2,494 |
671,409 |
|
| Healthy Futures |
|
3,700,000 |
|
2,466,667 |
|
2,041,666 |
|
Pacificare |
|
575,490 |
1,119 |
472,558 |
|
| Healthy Futures - Pt Education |
|
100,000 |
|
66,667 |
|
|
|
Staywell |
|
947,116 |
966 |
349,957 |
|
| Compact Impact Funds |
|
3,200,000 |
|
2,133,333 |
|
|
|
Calvo's |
|
183,436 |
673 |
101,241 |
|
| Misc Revenues |
|
50,000 |
|
33,333 |
|
210,232 |
|
Net care |
|
218,272 |
|
373,814 |
|
| FEMA |
|
- |
|
|
|
Commercial |
|
310,760 |
1,054 |
|
|
| GovGuam Subsidy |
|
5,100,000 |
|
3,400,000 |
|
|
|
Miscellaneous |
|
157,592 |
|
146,747 |
|
| Charitable Donations |
|
100,000 |
|
66,667 |
|
35,137 |
|
Nanbo |
|
- |
|
|
|
| Total Collections |
|
72,796,908 |
|
48,531,272 |
|
39,007,608 |
|
FSM |
|
- |
|
|
|
| |
|
|
|
|
GOG |
|
24,164 |
5,806 |
560 |
|
| Salaries |
|
30,380,099 |
|
20,253,399 |
|
19,934,789 |
|
Healthy Futures Fund |
|
|
150,000 |
|
| Specialty Pay |
|
679,317 |
|
452,878 |
|
347,263 |
|
Self-Pay |
|
1,522,661 |
240,104 |
213,329 |
|
| Benefits |
|
8,640,252 |
|
5,760,168 |
|
5,098,376 |
|
DRT |
|
|
21,904,361 |
143,024 |
|
| Annual Lump Sum |
|
|
- |
|
55,913 |
|
Collection Agencies |
|
|
|
|
| Other Pay |
|
1,825,384 |
|
1,216,923 |
|
1,984,431 |
|
CAOG |
|
|
5,433,247 |
58,536 |
|
| Overtime |
|
2,227,101 |
|
1,484,734 |
|
1,239,135 |
|
GMMS |
|
|
3,677,233 |
33,485 |
|
| Total Salaries & Benefits |
|
43,752,153 |
|
29,168,102 |
|
28,659,907 |
|
SAVANT |
|
|
3,939,456 |
21,507 |
|
| Travel & Training |
|
204,850 |
|
136,567 |
|
107,865 |
|
UPCA |
|
|
407,715 |
|
|
| Contractual Services |
|
8,950,172 |
|
5,966,781 |
|
5,414,404 |
|
Total |
|
|
9,639,825 |
35,689,932 |
4,980,993 |
|
| Supplies & Materials |
|
10,933,289 |
|
7,288,859 |
|
7,465,844 |
|
| Minor Equipment |
|
312,327 |
|
208,218 |
|
243,441 |
|
|
|
Accounts
Receivable (Net) |
| Miscellaneous |
|
284,513 |
|
189,675 |
|
192,398 |
|
|
|
Medically Indigent Program |
|
|
6,697,180 |
| Utilities |
|
2,215,120 |
|
1,476,747 |
|
922,664 |
|
|
|
GovGuam |
|
1,897,329 |
| Capital Outlay |
|
3,292,803 |
|
2,195,202 |
|
286,001 |
|
Self Pay |
|
3,437,493 |
| Debt Service |
|
2,851,681 |
|
1,901,121 |
|
135,968 |
|
Medicare |
|
2,045,439 |
| Total Cash Disbursements |
|
72,796,908 |
|
48,531,272 |
|
43,428,492 |
|
Medicaid |
|
6,416,224 |
| Surplus /(Deficit) |
|
- |
|
- |
|
(4,420,884) |
|
Commercial |
|
4,395,262 |
|
|
|
|
|
|
Total A/R (Net) |
24,888,927 |
|
|
|
|
|
|
|
|
- |
| Accounts Payable Aging |
|
| 05/31/05 |
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
| House Doctors |
|
16,205 |
|
59,459 |
|
46,093 |
|
569,120 |
|
690,877 |
|
| Trade Payables |
|
461,269 |
|
953,931 |
|
936,615 |
|
3,459,806 |
|
5,811,621 |
|
| Payroll Payables |
|
- |
|
65,996 |
|
- |
|
- |
|
65,996 |
|
| - Gov Ret DBP |
|
194,663 |
|
155,880 |
|
390,615 |
|
1,654,516 |
|
2,395,673 |
|
| - Gov Ret DCP |
|
|
|
145,971 |
|
286,349 |
|
288,064 |
|
720,383 |
|
| - Dept of Rev |
|
|
|
148,552 |
|
286,104 |
|
- |
|
434,656 |
|
| GTA |
|
|
|
|
|
|
- |
|
| GPA |
|
|
|
99,257 |
|
95,859 |
|
373,485 |
|
568,600 |
|
|
|
| GWA |
|
27,262 |
|
1,630 |
|
|
(147) |
|
28,745 |
|
| Total |
|
699,398 |
|
1,630,675 |
|
2,041,634 |
|
6,344,843 |
|
10,716,550 |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts Receivable Aging |
|
| 05/31/05 |
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
| Medically Indigent Program |
|
3,027,072 |
|
990,723 |
|
990,699 |
|
9,171,955 |
|
14,180,450 |
|
|
| Self Pay |
|
2,341,212 |
|
1,509,774 |
|
1,163,321 |
|
23,631,465 |
|
28,645,773 |
|
|
|
| Medicare |
|
2,497,033 |
|
560,684 |
|
169,475 |
|
1,318,227 |
|
4,545,419 |
|
|
|
| Medicaid |
|
1,380,507 |
|
1,243,652 |
|
1,287,017 |
|
9,740,365 |
|
13,651,541 |
|
|
|
| GovGuam |
|
309,434 |
|
20,927 |
|
27,235 |
|
1,740,855 |
|
2,098,452 |
|
|
|
| Commercial |
|
3,155,828 |
|
2,125,436 |
|
842,887 |
|
3,227,472 |
|
9,351,624 |
|
|
|
| Total |
|
12,711,087 |
|
6,451,197 |
|
4,480,634 |
|
48,830,340 |
|
72,473,259 |
|
|
|
|
|
|
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
8 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|