| Budget Comparison (Cash
Basis) |
|
Billing, Collection & Denials |
|
|
| |
|
FY 2005 |
|
FY 2005 |
|
FY 2005 |
|
04/30/05 |
|
| |
|
Approved |
|
7 Month
Budget |
|
7 Month
Actual |
|
|
|
|
Gross Billings |
Bad Debt |
Collections |
|
| Patient Revenues |
|
60,000,000 |
|
35,000,000 |
|
|
|
Medically Indigent
Program |
1,155,883.05 |
33,201 |
630,641 |
|
| Cafeteria Sales |
|
500,000 |
|
291,667 |
|
|
|
Medicaid |
|
1,469,694.86 |
33,946 |
2,602,557 |
|
| HRSA Grant |
|
46,908 |
|
27,363 |
|
|
|
Medicare |
|
1,790,627 |
1,142 |
165,970 |
|
| Healthy Futures |
|
3,700,000 |
|
2,158,333 |
|
|
|
Pacificare |
|
569,885 |
1,119 |
438,302 |
|
| Healthy Futures - Pt Education |
|
100,000 |
|
58,333 |
|
|
|
Staywell |
|
1,176,571 |
966 |
768,743 |
|
| Compact Impact Funds |
|
3,200,000 |
|
1,866,667 |
|
|
|
Calvo's |
|
265,120 |
|
311,020 |
|
| Misc Revenues |
|
50,000 |
|
29,167 |
|
|
|
Net care |
|
292,920 |
|
136,123 |
|
| FEMA |
|
- |
|
|
|
Commercial |
|
84,116 |
|
|
|
| GovGuam Subsidy |
|
5,100,000 |
|
2,975,000 |
|
|
|
Miscellaneous |
|
124,159 |
1,202 |
145,386 |
|
| Charitable Donations |
|
100,000 |
|
58,333 |
|
|
|
Nanbo |
|
0 |
|
80,165 |
|
| Total Collections |
|
72,796,908 |
|
42,464,863 |
|
- |
|
FSM |
|
- |
|
|
|
| |
|
|
|
|
GOG |
|
47,507 |
4,858 |
42,903 |
|
| Salaries |
|
30,380,099 |
|
17,721,724 |
|
|
|
Healthy Futures Fund |
|
|
|
|
| Specialty Pay |
|
679,317 |
|
396,268 |
|
|
|
Self-Pay |
|
1,696,938 |
204,973 |
302,143 |
|
| Benefits |
|
8,640,252 |
|
5,040,147 |
|
|
|
DRT |
|
|
21,934,892 |
|
|
| Annual Lump Sum |
|
|
- |
|
|
|
Collection Agencies |
|
|
|
|
| Other Pay |
|
1,825,384 |
|
1,064,807 |
|
|
|
CAOG |
|
|
5,485,957 |
|
|
| Overtime |
|
2,227,101 |
|
1,299,142 |
|
|
|
GMMS |
|
|
4,218,886 |
17,213 |
|
| Total Salaries & Benefits |
|
43,752,153 |
|
25,522,089 |
|
- |
|
SAVANT |
|
|
4,435,965 |
16,292 |
|
| Travel & Training |
|
204,850 |
|
119,496 |
|
|
|
UPCA |
|
|
513,935 |
|
|
| Contractual Services |
|
8,950,172 |
|
5,220,934 |
|
|
|
Total |
|
|
8,673,421 |
36,871,041 |
5,657,457 |
|
| Supplies & Materials |
|
10,933,289 |
|
6,377,752 |
|
|
|
| Minor Equipment |
|
312,327 |
|
182,191 |
|
|
|
|
|
Accounts
Receivable (Net) |
| Miscellaneous |
|
284,513 |
|
165,966 |
|
|
|
|
|
Medically Indigent Program |
|
|
|
| Utilities |
|
2,215,120 |
|
1,292,153 |
|
|
|
|
|
GovGuam |
|
|
| Capital Outlay |
|
3,292,803 |
|
1,920,802 |
|
|
|
Self Pay |
|
|
| Debt Service |
|
2,851,681 |
|
1,663,481 |
|
|
|
Medicare |
|
|
| Total Cash Disbursements |
|
72,796,908 |
|
42,464,863 |
|
- |
|
Medicaid |
|
|
| Surplus /(Deficit) |
|
- |
|
- |
|
- |
|
Commercial |
|
|
|
|
|
|
|
|
Total A/R (Net) |
- |
|
|
|
|
|
|
|
|
(24,674,759) |
| Accounts Payable Aging |
|
| 04/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 |
|
| 04/30/05 |
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
| Medically Indigent Program |
|
|
|
|
|
|
- |
|
|
| Self Pay |
|
|
|
|
|
|
- |
|
|
|
| Medicare |
|
|
|
|
|
|
- |
|
|
|
| Medicaid |
|
|
|
|
|
|
- |
|
|
|
| GovGuam |
|
|
|
|
|
|
- |
|
|
|
| Commercial |
|
|
|
|
|
|
- |
|
|
|
| Total |
|
- |
|
- |
|
- |
|
- |
|
- |
|
|
|
|
|
|
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
7 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|