| Budget Comparison (Cash
Basis) |
|
Billing, Collection & Denials |
|
|
|
|
| |
|
FY 2005 |
|
FY 2005 |
|
FY 2005 |
|
07/31/05 |
|
| |
|
Approved |
|
10 Month
Budget |
|
10 Month
Actual |
|
|
|
|
Gross Billings |
Bad Debt |
Collections |
|
| Patient Revenues |
|
60,000,000 |
|
50,000,000 |
|
46,214,942 |
|
Medically Indigent
Program |
2,500,105 |
21,484 |
874,332 |
|
| Cafeteria Sales |
|
500,000 |
|
416,667 |
|
314,585 |
|
Medicaid |
|
1,438,908 |
37,510 |
909,370 |
|
| HRSA Grant |
|
46,908 |
|
39,090 |
|
|
|
Medicare |
|
1,759,388 |
17,826 |
1,149,036 |
|
| Healthy Futures |
|
3,700,000 |
|
3,083,333 |
|
2,349,999 |
|
Pacificare |
|
716,612 |
1,119 |
547,803 |
|
| Healthy Futures - Pt Education |
|
100,000 |
|
83,333 |
|
|
|
Staywell |
|
1,166,647 |
966 |
795,716 |
|
| Compact Impact Funds |
|
3,200,000 |
|
2,666,667 |
|
2,225,000 |
|
Calvo's |
|
149,803 |
|
310,775 |
|
| Misc Revenues |
|
50,000 |
|
41,667 |
|
393,214 |
|
Net care |
|
171,108 |
|
196,506 |
|
| FEMA |
|
- |
|
|
|
Commercial |
|
94,521 |
869 |
|
|
| GovGuam Subsidy |
|
5,100,000 |
|
4,250,000 |
|
|
|
Miscellaneous |
|
23,448 |
|
78,442 |
|
| Insurance Settlement |
|
730844 |
|
Nanbo |
|
|
|
|
|
| Charitable Donations |
|
100,000 |
|
83,333 |
|
35,137 |
|
FSM |
|
|
|
|
| Total Collections |
|
72,796,908 |
|
60,664,090 |
|
52,263,721 |
|
GOG |
|
18,822 |
993 |
27,762 |
|
| |
|
|
|
|
Healthy Futures Fund |
|
|
|
|
| Salaries |
|
30,380,099 |
|
25,316,749 |
|
24,860,028 |
|
Self-Pay |
|
1,329,861 |
225,848 |
348,260 |
|
| Specialty Pay |
|
679,317 |
|
566,098 |
|
421,512 |
|
DRT |
|
|
21,875,718 |
327,060 |
|
| Benefits |
|
8,640,252 |
|
7,200,210 |
|
6,365,869 |
|
Collection Agencies |
|
|
|
|
| Annual Lump Sum |
|
|
- |
|
55,913 |
|
CAOG |
|
|
5,330,325 |
46,906 |
|
| Other Pay |
|
1,825,384 |
|
1,521,153 |
|
2,577,244 |
|
GMMS |
|
|
3,576,536 |
31,223 |
|
| Overtime |
|
2,227,101 |
|
1,855,918 |
|
1,569,819 |
|
SAVANT |
|
|
3,885,938 |
17,591 |
|
| Total Salaries & Benefits |
|
43,752,153 |
|
36,460,128 |
|
35,850,385 |
|
UPCA |
|
|
408,450 |
|
|
| Travel & Training |
|
204,850 |
|
170,708 |
|
122,097 |
|
Total |
|
|
9,369,223 |
35,383,582 |
5,660,782 |
|
|
| Contractual Services |
|
8,950,172 |
|
7,458,477 |
|
7,123,449 |
|
|
| Supplies & Materials |
|
10,933,289 |
|
9,111,074 |
|
9,394,088 |
|
|
|
|
Accounts
Receivable (Net) |
|
| Minor Equipment |
|
312,327 |
|
260,273 |
|
244,579 |
|
|
|
Medically Indigent Program |
|
|
6,304,942 |
|
| Miscellaneous |
|
284,513 |
|
237,094 |
|
178,399 |
|
|
|
GovGuam |
|
2,019,182 |
|
| Utilities |
|
2,215,120 |
|
1,845,933 |
|
1,373,399 |
|
Self Pay |
|
3,882,255 |
|
| Capital Outlay |
|
3,292,803 |
|
2,744,003 |
|
358,433 |
|
Medicare |
|
2,216,000 |
|
| Debt Service |
|
2,851,681 |
|
2,376,401 |
|
261,758 |
|
Medicaid |
|
5,674,722 |
|
| Total Cash Disbursements |
|
72,796,908 |
|
60,664,090 |
|
54,906,587 |
|
Commercial |
|
4,878,538 |
|
| Surplus /(Deficit) |
|
- |
|
- |
|
(2,642,866) |
|
Total A/R (Net) |
24,975,639 |
|
|
|
|
|
|
|
|
|
- |
|
|
| Accounts Payable Aging |
|
| 07/31/05 |
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
| House Doctors |
|
33,737 |
|
64,048 |
|
97,726 |
|
694,207 |
|
889,718 |
|
| Trade Payables |
|
569,453 |
|
1,223,679 |
|
937,338 |
|
3,203,928 |
|
5,934,398 |
|
| Payroll Payables |
|
104,123 |
|
- |
|
- |
|
|
104,123 |
|
| - Gov Ret DBP |
|
158,175 |
|
616 |
|
89,128 |
|
1,604,881 |
|
1,852,800 |
|
| - Gov Ret DCP |
|
170,214 |
|
- |
|
|
577,629 |
|
747,843 |
|
| - Dept of Rev |
|
342,382 |
|
142,010 |
|
|
286,104 |
|
770,496 |
|
| GTA |
|
|
|
23,535 |
|
84 |
|
|
23,619 |
|
|
|
| GPA |
|
|
|
107,471 |
|
106,403 |
|
374,410 |
|
588,284 |
|
| GWA |
|
|
|
22,966 |
|
47 |
|
(100) |
|
22,913 |
|
| Unbilled P O Receipts |
|
572,995 |
|
572,995 |
|
| Total |
|
1,951,079 |
|
1,584,325 |
|
1,230,726 |
|
6,741,059 |
|
11,507,189 |
|
|
|
|
|
|
|
| Accounts Receivable Aging |
|
| 07/31/05 |
|
|
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
|
|
| Medically Indigent Program |
|
2,961,203 |
|
922,166 |
|
850,873 |
|
8,401,054 |
|
13,135,296 |
|
|
|
| Self Pay |
|
2,920,242 |
|
1,096,261 |
|
1,017,001 |
|
26,295,925 |
|
31,329,429 |
|
|
|
| Medicare |
|
2,640,918 |
|
237,458 |
|
205,332 |
|
1,532,958 |
|
4,616,666 |
|
|
|
| Medicaid |
|
1,589,916 |
|
1,422,403 |
|
1,148,196 |
|
7,661,822 |
|
11,822,337 |
|
|
|
| GovGuam |
|
74,845 |
|
16,590 |
|
295,547 |
|
1,856,554 |
|
2,243,536 |
|
|
|
| Commercial |
|
3,147,547 |
|
2,190,441 |
|
883,911 |
|
3,734,301 |
|
9,956,200 |
|
|
|
| Total |
|
13,334,671 |
|
5,885,319 |
|
4,400,860 |
|
49,482,614 |
|
73,103,464 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11507189 |
|
|
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|