| Budget Comparison (Cash
Basis) |
|
Billing, Collection & Denials |
|
|
|
|
| |
|
FY 2005 |
|
FY 2005 |
|
FY 2005 |
|
08/31/05 |
|
| |
|
Approved |
|
11 Month
Budget |
|
11 Month
Actual |
|
|
|
|
Gross Billings |
Bad Debt |
Collections |
|
| Patient Revenues |
|
60,000,000 |
|
55,000,000 |
|
51,100,456 |
|
Medically Indigent
Program |
3,860,582.00 |
20,421.00 |
1,654,581.00 |
|
| Cafeteria Sales |
|
500,000 |
|
458,333 |
|
349,459 |
|
Medicaid |
|
1,693,764.00 |
35,373.00 |
279,549.00 |
|
| HRSA Grant |
|
46,908 |
|
42,999 |
|
|
|
Medicare |
|
2,326,521.00 |
16,451.00 |
658,625.00 |
|
| Healthy Futures |
|
3,700,000 |
|
3,391,667 |
|
2,841,666 |
|
Pacificare |
|
741,752.00 |
1,767.00 |
318,017.00 |
|
| Healthy Futures - Pt Education |
|
100,000 |
|
91,667 |
|
|
|
Staywell |
|
1,337,434.00 |
966.00 |
1,060,894.00 |
|
| Compact Impact Funds |
|
3,200,000 |
|
2,933,333 |
|
5,306,785 |
|
Calvo's |
|
245,099.00 |
|
1,749.00 |
|
| Misc Revenues |
|
50,000 |
|
45,833 |
|
402,639 |
|
Net care |
|
197,537.00 |
|
115,928.00 |
|
| FEMA |
|
- |
|
|
|
Commercial |
|
120,401.00 |
1,017.00 |
|
|
| GovGuam Subsidy |
|
5,100,000 |
|
4,675,000 |
|
|
|
Miscellaneous |
|
84,527.00 |
|
74,966.00 |
|
| Insurance Settlement |
|
730,844 |
|
Nanbo |
|
|
68,909.00 |
|
| Charitable Donations |
|
100,000 |
|
91,667 |
|
35,137 |
|
FSM |
|
|
|
|
| GTA Sale Proceeds |
|
5,000,000 |
|
GOG |
|
26,179.00 |
46.00 |
9,320.00 |
|
| Total Collections |
|
72,796,908 |
|
66,730,499 |
|
65,766,986 |
|
Healthy Futures Fund |
|
|
491,667.00 |
|
| |
|
|
|
|
Self-Pay |
|
2,083,794.00 |
253,583.00 |
376,809.00 |
|
| Salaries |
|
30,380,099 |
|
27,848,424 |
|
27,443,610 |
|
DRT |
|
|
21,841,205.00 |
|
|
| Specialty Pay |
|
679,317 |
|
622,707 |
|
453,877 |
|
Collection Agencies |
|
|
|
|
| Benefits |
|
8,640,252 |
|
7,920,231 |
|
7,018,419 |
|
CAOG |
|
|
5,346,258.00 |
42,214.00 |
|
| Annual Lump Sum |
|
|
- |
|
57,478 |
|
GMMS |
|
|
3,603,807.00 |
22,056.00 |
|
| Other Pay |
|
1,825,384 |
|
1,673,269 |
|
2,804,178 |
|
SAVANT |
|
|
3,881,652.00 |
15,611.00 |
|
| Overtime |
|
2,227,101 |
|
2,041,509 |
|
1,767,614 |
|
UPCA |
|
|
408,450.00 |
|
|
| Total Salaries & Benefits |
|
43,752,153 |
|
40,106,140 |
|
39,545,176 |
|
Total |
|
|
12,717,590.00 |
35,410,996.00 |
5,190,895.00 |
|
|
| Travel & Training |
|
204,850 |
|
187,779 |
|
122,327 |
|
|
| Contractual Services |
|
8,950,172 |
|
8,204,324 |
|
8,119,659 |
|
|
|
|
Accounts
Receivable (Net) |
|
| Supplies & Materials |
|
10,933,289 |
|
10,022,182 |
|
10,499,665 |
|
|
|
Medically Indigent Program |
|
|
6,511,752 |
|
| Minor Equipment |
|
312,327 |
|
286,300 |
|
234,123 |
|
|
|
GovGuam |
|
1,823,072 |
|
| Miscellaneous |
|
284,513 |
|
260,804 |
|
181,574 |
|
Self Pay |
|
3,233,443 |
|
| Utilities |
|
2,215,120 |
|
2,030,527 |
|
1,645,210 |
|
Medicare |
|
2,920,816 |
|
| Capital Outlay |
|
3,292,803 |
|
3,018,403 |
|
576,708 |
|
Medicaid |
|
5,663,993 |
|
| Debt Service |
|
2,851,681 |
|
2,614,041 |
|
307,094 |
|
Commercial |
|
4,661,540 |
|
| Total Cash Disbursements |
|
72,796,908 |
|
66,730,499 |
|
61,231,536 |
|
Total A/R (Net) |
24,814,616 |
|
| Surplus /(Deficit) |
|
- |
|
- |
|
4,535,450 |
|
|
|
|
- |
|
|
| Accounts Payable Aging |
|
| 08/31/05 |
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
| House Doctors |
|
6,123 |
|
20,660 |
|
7,734 |
|
32 |
|
34,549 |
|
| Trade Payables |
|
536,625 |
|
355,154 |
|
186,619 |
|
638,519 |
|
1,716,917 |
|
| Payroll Payables |
|
|
- |
|
| - Gov Ret DBP |
|
153,744 |
|
616 |
|
1,046,921 |
|
1,201,281 |
|
| - Gov Ret DCP |
|
178,094 |
|
178,094 |
|
| - Dept of Rev |
|
172,613 |
|
172,613 |
|
|
|
| GTA |
|
23,674 |
|
32 |
|
23,706 |
|
| GPA |
|
45,965 |
|
106,545 |
|
107,471 |
|
480,813 |
|
740,794 |
|
| GWA |
|
17,401 |
|
(53) |
|
17,348 |
|
| Unbilled P O Receipts |
|
2,643,470 |
|
2,643,470 |
|
| Total |
|
3,777,709 |
|
482,359 |
|
302,472 |
|
2,166,232 |
|
6,728,772 |
|
|
|
|
|
- |
|
|
|
| Accounts Receivable Aging |
|
|
|
| 08/31/05 |
|
|
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
|
|
| Medically Indigent Program |
|
3,362,238 |
|
765,945 |
|
988,180 |
|
8,738,429 |
|
13,854,792 |
|
|
|
| Self Pay |
|
3,206,010 |
|
1,230,049 |
|
1,114,370 |
|
27,351,905 |
|
32,902,334 |
|
|
|
| Medicare |
|
3,337,359 |
|
902,753 |
|
205,091 |
|
1,769,299 |
|
6,214,502 |
|
|
|
| Medicaid |
|
1,603,419 |
|
1,327,597 |
|
1,627,225 |
|
7,492,808 |
|
12,051,049 |
|
|
|
| GovGuam |
|
30,099 |
|
9,062 |
|
10,813 |
|
1,975,662 |
|
2,025,636 |
|
|
|
| Commercial |
|
3,343,651 |
|
2,132,678 |
|
635,016 |
|
3,806,824 |
|
9,918,169 |
|
|
|
| Total |
|
14,882,776 |
|
6,368,084 |
|
4,580,695 |
|
51,134,927 |
|
76,966,482 |
|
|
|
|
|
|
|
|
|
|
|
11 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|