| Budget Comparison (Cash
Basis) |
|
Billing, Collection & Denials |
|
|
|
|
| |
|
FY 2006 |
|
FY 2006 |
|
FY 2006 |
|
10/31/05 |
|
| |
|
Approved |
|
1 Month
Budget |
|
1 Month
Actual |
|
|
|
|
Gross Billings |
Bad Debt |
Collections |
|
| Patient Revenues |
|
53,258,165 |
|
4,438,180 |
|
4,149,628 |
|
Medically Indigent
Program |
1,108,558.00 |
5,593.00 |
695,723.98 |
|
| Cafeteria Sales |
|
600,000 |
|
50,000 |
|
34,696 |
|
Medicaid |
|
1,492,235.00 |
30,772.00 |
24,818.50 |
|
| HRSA Grant |
|
|
|
|
Medicare |
|
1,893,735.00 |
17,070.00 |
679,288.82 |
|
| Healthy Futures |
|
4,000,000 |
|
333,333 |
|
|
|
Pacificare |
|
747,433.00 |
1,119.00 |
403,857.02 |
|
| Healthy Futures - Pt Education |
|
|
|
|
|
|
|
Staywell |
|
1,419,365.00 |
966.00 |
1,561,896.92 |
|
| Compact Impact Funds |
|
3,200,000 |
|
266,667 |
|
|
|
Calvo's |
|
348,596.00 |
|
156,392.88 |
|
| Misc Revenues |
|
|
|
|
Net care |
|
193,060.00 |
|
140,803.43 |
|
| FEMA |
|
|
|
|
|
Commercial |
|
43,111.00 |
947.00 |
|
|
| GovGuam Subsidy |
|
17,958,964 |
|
1,496,580 |
|
|
|
Miscellaneous |
|
47,288.00 |
|
79,472.38 |
|
| Insurance Settlement |
|
|
|
Nanbo |
|
|
|
|
| Charitable Donations |
|
|
|
|
FSM |
|
|
|
|
| GTA Sale Proceeds |
|
|
|
GOG |
|
50,431.00 |
47.00 |
46,837.79 |
|
| Total Collections |
|
79,017,129 |
|
6,584,761 |
|
4,184,324 |
|
Healthy Futures Fund |
|
|
|
|
| |
|
|
|
|
Self-Pay |
|
1,657,132.00 |
284,373.00 |
305,401.39 |
|
| Salaries |
|
35,288,651 |
|
2,940,721 |
|
2,722,413 |
|
DRT |
|
|
21,709,826.00 |
|
|
| Specialty Pay |
|
2,481,976 |
|
206,831 |
|
258,389 |
|
Collection Agencies |
|
|
|
|
| Benefits |
|
9,549,665 |
|
795,805 |
|
694,735 |
|
CAOG |
|
|
3,394,859.00 |
48,183.29 |
|
| Annual Lump Sum |
|
|
- |
|
|
|
GMMS |
|
|
2,726,834.00 |
|
|
| Other Pay |
|
|
- |
|
|
|
SAVANT |
|
|
3,739,479.00 |
12,614.75 |
|
| Overtime |
|
|
- |
|
187,596 |
|
UPCA |
|
|
385,221.00 |
|
|
| Total Salaries & Benefits |
|
47,320,292 |
|
3,943,358 |
|
3,863,133 |
|
Total |
|
|
9,000,944.00 |
32,297,106.00 |
4,155,291.15 |
|
|
| Travel & Training |
|
97,590 |
|
8,133 |
|
15,958 |
|
|
| Contractual Services |
|
8,220,896 |
|
685,075 |
|
1,117,242 |
|
Accounts
Receivable (Net) |
|
|
|
| Supplies & Materials |
|
11,057,169 |
|
921,431 |
|
1,659,606 |
|
Medically Indigent Program |
|
|
7,157,006 |
|
| Minor Equipment |
|
192,023 |
|
16,002 |
|
9,256 |
|
GovGuam |
|
1,867,650 |
|
| Miscellaneous |
|
7,133,567 |
|
594,464 |
|
37,205 |
|
Self Pay |
|
3,531,148 |
|
| Utilities |
|
1,987,615 |
|
165,635 |
|
220,942 |
|
Medicare |
|
3,005,645 |
|
| Capital Outlay |
|
3,007,977 |
|
250,665 |
|
99,827 |
|
Medicaid |
|
5,829,942 |
|
| Debt Service |
|
|
- |
|
|
|
Commercial |
|
4,669,554 |
|
| Total Cash Disbursements |
|
79,017,129 |
|
6,584,761 |
|
7,023,169 |
|
Total A/R (Net) |
26,060,945 |
|
| Surplus /(Deficit) |
|
- |
|
- |
|
(2,838,845) |
|
|
|
|
- |
|
|
| Accounts Payable Aging |
|
| 10/31/05 |
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
| House Doctors |
|
17,926 |
|
5,002 |
|
74,303 |
|
50,538 |
|
147,769 |
|
| Trade Payables |
|
394,630 |
|
1,034,848 |
|
518,014 |
|
670,670 |
|
2,618,162 |
|
| Payroll Payables |
|
- |
|
- |
|
- |
|
- |
|
- |
|
| - Gov Ret DBP |
|
|
1,047,537 |
|
1,047,537 |
|
| - Gov Ret DCP |
|
|
- |
|
| - Dept of Rev |
|
170,405 |
|
170,405 |
|
|
|
| GTA |
|
- |
|
- |
|
- |
|
- |
|
- |
|
| GPA |
|
- |
|
117,469 |
|
588,284 |
|
705,753 |
|
| GWA |
|
52,097 |
|
18,864 |
|
(53) |
|
70,908 |
|
| Unbilled P O Receipts |
|
585,221 |
|
585,221 |
|
| Total |
|
1,220,279 |
|
1,176,183 |
|
592,317 |
|
2,356,976 |
|
5,345,755 |
|
|
|
|
|
- |
|
|
|
| Accounts Receivable Aging |
|
|
|
| 10/31/05 |
|
|
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
|
|
| Commercial |
|
3,630,956 |
|
2,671,529 |
|
732,596 |
|
3,341,706 |
|
10,376,787 |
|
|
|
| GovGuam |
|
75,080 |
|
10,266 |
|
2,776 |
|
1,987,045 |
|
2,075,167 |
|
|
|
| Medicaid |
|
1,697,807 |
|
1,160,200 |
|
1,336,785 |
|
8,478,995 |
|
12,673,787 |
|
|
|
| Medically Indigent Program |
|
3,439,913 |
|
1,255,999 |
|
1,188,743 |
|
9,674,053 |
|
15,558,708 |
|
|
|
| Medicare |
|
3,459,424 |
|
752,639 |
|
353,817 |
|
1,968,131 |
|
6,534,011 |
|
|
|
| Self Pay |
|
3,038,618 |
|
1,435,105 |
|
1,409,908 |
|
27,685,885 |
|
33,569,516 |
|
|
| Total |
|
15,341,798 |
|
7,285,738 |
|
5,024,625 |
|
53,135,815 |
|
80,787,976 |
|
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
2006 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|