| Budget Comparison (Cash
Basis) |
|
Billing, Collection & Denials |
|
|
| |
|
FY 2005 |
|
FY 2005 |
|
FY 2005 |
|
06/30/05 |
|
| |
|
Approved |
|
9 Month
Budget |
|
9 Month
Actual |
|
|
|
|
Gross Billings |
Bad Debt |
Collections |
|
| Patient Revenues |
|
60,000,000 |
|
45,000,000 |
|
40,560,632 |
|
Medically Indigent
Program |
4,087,773 |
23,672 |
500,233 |
|
| Cafeteria Sales |
|
500,000 |
|
375,000 |
|
283,121 |
|
Medicaid |
|
1,236,608 |
38,071 |
500,000 |
|
| HRSA Grant |
|
46,908 |
|
35,181 |
|
|
|
Medicare |
|
2,198,238 |
2,494 |
858,990 |
|
| Healthy Futures |
|
3,700,000 |
|
2,775,000 |
|
2,349,999 |
|
Pacificare |
|
760,864 |
1,119 |
437,625 |
|
| Healthy Futures - Pt Education |
|
100,000 |
|
75,000 |
|
|
|
Staywell |
|
1,336,204 |
966 |
741,343 |
|
| Compact Impact Funds |
|
3,200,000 |
|
2,400,000 |
|
2,225,000 |
|
Calvo's |
|
381,859 |
|
219,678 |
|
| Misc Revenues |
|
50,000 |
|
37,500 |
|
1,845,599 |
|
Net care |
|
396,141 |
|
217,192 |
|
| FEMA |
|
- |
|
|
|
Commercial |
|
150,232 |
869 |
129,265 |
|
| GovGuam Subsidy |
|
5,100,000 |
|
3,825,000 |
|
|
|
Miscellaneous |
|
137,038 |
|
|
|
| Charitable Donations |
|
100,000 |
|
75,000 |
|
35,138 |
|
Nanbo |
|
- |
|
|
|
| Total Collections |
|
72,796,908 |
|
54,597,681 |
|
47,299,489 |
|
FSM |
|
- |
|
|
|
| |
|
|
|
|
GOG |
|
15,088 |
5,806 |
160 |
|
| Salaries |
|
30,380,099 |
|
22,785,074 |
|
22,318,318 |
|
Healthy Futures Fund |
|
|
308,333 |
|
| Specialty Pay |
|
679,317 |
|
509,488 |
|
386,665 |
|
Self-Pay |
|
1,359,549 |
239,642 |
369,813 |
|
| Benefits |
|
8,640,252 |
|
6,480,189 |
|
5,708,226 |
|
DRT |
|
|
21,881,905 |
|
|
| Annual Lump Sum |
|
|
- |
|
55,913 |
|
Collection Agencies |
|
|
|
|
| Other Pay |
|
1,825,384 |
|
1,369,038 |
|
2,250,382 |
|
CAOG |
|
|
5,387,027 |
43,955 |
|
| Overtime |
|
2,227,101 |
|
1,670,326 |
|
1,396,955 |
|
GMMS |
|
|
3,611,704 |
32,611 |
|
| Total Salaries & Benefits |
|
43,752,153 |
|
32,814,115 |
|
32,116,459 |
|
SAVANT |
|
|
3,909,555 |
17,549 |
|
| Travel & Training |
|
204,850 |
|
153,638 |
|
120,797 |
|
UPCA |
|
|
408,468 |
|
|
| Contractual Services |
|
8,950,172 |
|
6,712,629 |
|
6,361,829 |
|
Total |
|
|
12,059,594 |
35,511,298 |
4,376,747 |
|
| Supplies & Materials |
|
10,933,289 |
|
8,199,967 |
|
8,750,227 |
|
| Minor Equipment |
|
312,327 |
|
234,245 |
|
240,984 |
|
|
|
|
Accounts
Receivable (Net) |
| Miscellaneous |
|
284,513 |
|
213,385 |
|
203,954 |
|
|
|
Medically Indigent Program |
|
|
|
| Utilities |
|
2,215,120 |
|
1,661,340 |
|
981,690 |
|
|
|
GovGuam |
|
|
| Capital Outlay |
|
3,292,803 |
|
2,469,602 |
|
289,688 |
|
Self Pay |
|
|
| Debt Service |
|
2,851,681 |
|
2,138,761 |
|
227,898 |
|
Medicare |
|
|
| Total Cash Disbursements |
|
72,796,908 |
|
54,597,681 |
|
49,293,526 |
|
Medicaid |
|
|
| Surplus /(Deficit) |
|
- |
|
- |
|
(1,994,037) |
|
Commercial |
|
|
|
|
|
|
|
|
Total A/R (Net) |
- |
|
|
|
|
|
|
|
|
(29,563,194) |
| Accounts Payable Aging |
|
| 06/30/05 |
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
| House Doctors |
|
|
|
|
|
|
- |
|
| Trade Payables |
|
|
|
|
|
|
- |
|
| Payroll Payables |
|
|
|
|
|
|
- |
|
| - Gov Ret DBP |
|
|
|
|
|
|
- |
|
| - Gov Ret DCP |
|
|
|
|
|
|
- |
|
| - Dept of Rev |
|
|
|
|
|
|
- |
|
| GTA |
|
|
|
|
|
|
- |
|
| GPA |
|
|
|
|
|
|
- |
|
|
|
| GWA |
|
|
|
|
|
|
- |
|
| Total |
|
- |
|
- |
|
- |
|
- |
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts Receivable Aging |
|
| 06/30/05 |
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
| Medically Indigent Program |
|
2,980,035 |
|
781,818 |
|
1,079,250 |
|
8,158,078 |
|
12,999,181 |
|
|
|
| Self Pay |
|
2,091,379 |
|
961,079 |
|
1,485,311 |
|
13,200,453 |
|
17,738,222 |
|
|
|
| Medicare |
|
2,538,317 |
|
338,138 |
|
209,237 |
|
1,632,428 |
|
4,718,120 |
|
|
|
| Medicaid |
|
1,572,877 |
|
1,023,952 |
|
1,332,679 |
|
8,364,954 |
|
12,294,462 |
|
|
|
| GovGuam |
|
32,591 |
|
288,198 |
|
11,583 |
|
1,677,652 |
|
2,010,024 |
|
|
|
| Commercial |
|
3,981,136 |
|
1,865,319 |
|
853,188 |
|
15,339,276 |
|
22,038,919 |
|
|
|
| Total |
|
13,196,335 |
|
5,258,504 |
|
4,971,248 |
|
48,372,841 |
|
71,798,928 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
9 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|