| Budget Comparison (Cash
Basis) |
|
Billing, Collection & Denials |
|
|
|
|
| |
|
FY 2006 |
|
FY 2006 |
|
FY 2006 |
|
11/30/05 |
|
|
| |
|
Approved |
|
2 Month
Budget |
|
2 Month
Actual |
|
|
|
|
Gross Billings |
Bad Debt |
Collections |
|
|
| Patient Revenues |
|
53,258,165 |
|
8,876,361 |
|
8,262,465 |
|
Medically Indigent
Program |
1,341,867.00 |
5,553.00 |
335,433.00 |
|
|
| Cafeteria Sales |
|
600,000 |
|
100,000 |
|
100,304 |
|
Medicaid |
|
1,310,662.00 |
29,750.00 |
643,117.00 |
|
|
| HRSA Grant |
|
|
|
|
Medicare |
|
2,149,174.00 |
16,994.00 |
898,779.00 |
|
|
| Healthy Futures |
|
4,000,000 |
|
666,667 |
|
|
|
Pacificare |
|
683,147.00 |
1,119.00 |
556,197.00 |
|
|
| Healthy Futures - Pt Education |
|
|
|
|
|
|
|
Staywell |
|
1,459,202.00 |
966.00 |
664,084.00 |
|
|
| Compact Impact Funds |
|
3,200,000 |
|
533,333 |
|
678,589 |
|
Calvo's |
|
539,018.00 |
|
257,795.00 |
|
|
| Misc Revenues |
|
|
|
|
Net care |
|
227,221.00 |
|
268,014.00 |
|
|
| FEMA |
|
|
|
|
|
Commercial |
|
106,260.00 |
138.00 |
78,483.00 |
|
|
| GovGuam Subsidy |
|
17,958,964 |
|
2,993,161 |
|
684,705 |
|
Miscellaneous |
|
49,696.00 |
|
|
|
|
| Insurance Settlement |
|
|
|
Nanbo |
|
|
|
|
|
| Charitable Donations |
|
|
|
|
FSM |
|
|
|
|
|
| GTA Sale Proceeds |
|
|
|
GOG |
|
32,616.00 |
47.00 |
31,162.00 |
|
|
| Total Collections |
|
79,017,129 |
|
13,169,522 |
|
9,726,063 |
|
Healthy Futures Fund |
|
|
|
|
|
| |
|
|
|
|
Self-Pay |
|
1,693,330.00 |
293,439.00 |
318,002.00 |
|
|
| Salaries |
|
34,884,362 |
|
5,814,060 |
|
5,320,296 |
|
DRT |
|
|
21,681,280.00 |
6,300.00 |
|
|
| Specialty Pay |
|
830,670 |
|
138,445 |
|
738,408 |
|
Collection Agencies |
|
|
|
|
|
| Benefits |
|
9,549,665 |
|
1,591,611 |
|
1,386,297 |
|
CAOG |
|
|
3,160,082.00 |
34,104.00 |
|
|
| Annual Lump Sum |
|
|
4,140 |
|
GMMS |
|
|
2,681,016.00 |
15,317.00 |
|
|
| Other Pay |
|
|
|
|
SAVANT |
|
|
3,680,675.00 |
12,120.00 |
|
|
| Overtime |
|
2,011,306 |
|
335,218 |
|
349,905 |
|
UPCA |
|
|
385,221.00 |
|
|
|
| Total Salaries & Benefits |
|
47,276,003 |
|
7,879,334 |
|
7,799,046 |
|
Total |
|
|
9,592,193.00 |
31,936,280.00 |
4,118,907.00 |
|
|
| Travel & Training |
|
100,230 |
|
16,705 |
|
19,290 |
|
|
|
| Contractual Services |
|
9,096,233 |
|
1,516,039 |
|
1,266,609 |
|
Accounts
Receivable (Net) |
|
|
|
|
| Supplies & Materials |
|
10,336,019 |
|
1,722,670 |
|
1,715,379 |
|
Medically Indigent Program |
|
|
6,573,266 |
|
|
| Minor Equipment |
|
192,423 |
|
32,071 |
|
38,586 |
|
GovGuam |
|
1,902,491 |
|
|
| Miscellaneous |
|
284,678 |
|
47,446 |
|
49,260 |
|
Self Pay |
|
3,535,886 |
|
|
| Utilities |
|
1,987,615 |
|
331,269 |
|
155,932 |
|
Medicare |
|
2,559,097 |
|
|
| Capital Outlay |
|
2,896,928 |
|
482,821 |
|
162,427 |
|
Medicaid |
|
6,436,527 |
|
|
| Debt Service |
|
6,847,000 |
|
1,141,167 |
|
|
|
Commercial |
|
5,360,902 |
|
|
| Total Cash Disbursements |
|
79,017,129 |
|
13,169,522 |
|
11,206,529 |
|
Total A/R (Net) |
26,368,169 |
|
|
| Surplus /(Deficit) |
|
- |
|
- |
|
(1,480,466) |
|
|
|
|
- |
|
|
|
|
|
|
| Accounts Payable Aging |
|
|
| 11/30/05 |
|
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
|
| House Doctors |
|
35,967 |
|
61,700 |
|
34,525 |
|
107,445 |
|
239,637 |
|
|
| Trade Payables |
|
562,110 |
|
761,412 |
|
749,374 |
|
706,179 |
|
2,779,075 |
|
|
| Payroll Payables |
|
|
- |
|
|
| - Gov Ret DBP |
|
|
1,047,537 |
|
1,047,537 |
|
|
| - Gov Ret DCP |
|
|
- |
|
|
| - Dept of Rev |
|
191,568 |
|
191,568 |
|
|
|
|
| GTA |
|
21,217 |
|
21,217 |
|
|
| GPA |
|
|
117,469 |
|
494,347 |
|
611,816 |
|
|
| GWA |
|
(16,456) |
|
52,097 |
|
18,864 |
|
(53) |
|
54,452 |
|
|
| Unbilled P O Receipts |
|
692,804 |
|
692,804 |
|
|
| Total |
|
1,487,210 |
|
992,678 |
|
802,763 |
|
2,355,455 |
|
5,638,106 |
|
|
|
|
|
|
- |
|
|
|
| Accounts Receivable Aging |
|
|
|
|
| 11/30/05 |
|
|
|
|
| |
|
0 - 30 |
|
31 - 60 |
|
61 - 90 |
|
Over 90 |
|
Total |
|
|
|
|
| Commercial |
|
3,608,035 |
|
2,273,856 |
|
1,018,937 |
|
5,012,287 |
|
11,913,115 |
|
|
|
|
| GovGuam |
|
77,764 |
|
57,063 |
|
16,092 |
|
2,087,306 |
|
2,238,225 |
|
|
|
|
| Medicaid |
|
1,913,997 |
|
1,326,577 |
|
1,292,370 |
|
9,770,450 |
|
14,303,394 |
|
|
|
|
| Medically Indigent Program |
|
3,763,607 |
|
752,144 |
|
1,228,643 |
|
10,688,770 |
|
16,433,164 |
|
|
|
|
| Medicare |
|
2,927,312 |
|
461,735 |
|
137,088 |
|
2,160,747 |
|
5,686,882 |
|
|
|
|
| Self Pay |
|
3,309,994 |
|
1,483,865 |
|
1,463,791 |
|
27,529,468 |
|
33,787,118 |
|
|
|
| Total |
|
15,600,709 |
|
6,355,240 |
|
5,156,921 |
|
57,249,028 |
|
84,361,898 |
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
2006 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|