| Budget Comparison (Cash Basis) | Billing, Collection & Denials | ||||||||||||||||
| FY 2006 | FY 2006 | FY 2006 | 04/30/06 | ||||||||||||||
| Approved | 7 Month Budget | 7 Month Actual | Gross Billings | Bad Debt | Collections | ||||||||||||
| Patient Revenues | 52,675,260 | 30,727,235 | 33,124,859 | Medically Indigent Program | 941,374 | 1,114 | 1,050,692 | ||||||||||
| Cafeteria Sales | 600,000 | 350,000 | 407,623 | Medicaid | 1,177,176 | 14,569 | 936,798 | ||||||||||
| HRSA Grant | Medicare | 2,146,478 | 16,994 | 1,088,410 | |||||||||||||
| Healthy Futures | Pacificare | 670,557 | 421,513 | ||||||||||||||
| Health Securities Trust Fund | 3,500,000 | 2,041,667 | Staywell | 721,674 | 966 | 1,111,443 | |||||||||||
| Compact Impact Funds | 3,700,000 | 2,158,333 | 2,626,889 | Calvo's | 297,588 | 170,637 | |||||||||||
| Misc Revenues | Net care | 550,552 | 246,210 | ||||||||||||||
| FEMA | Commercial | 160,424 | |||||||||||||||
| GovGuam Subsidy | Miscellaneous | 72,369 | 982 | 87,191 | |||||||||||||
| Bad Debt | 1,027,527 | 599,391 | 640,897 | Nanbo | |||||||||||||
| Charitable Donations | FSM | ||||||||||||||||
| Advanced Appropriations | 7,800,000 | 4,550,000 | GOG | 28,434 | 47 | 26,021 | |||||||||||
| GRT | 9,431,212 | 5,501,540 | 4,010,894 | Healthy Futures Fund | |||||||||||||
| Health Securities Trust Fund | 283,130 | 165,159 | 183,130 | Health Securities Trust Fund | |||||||||||||
| Total Collections | 79,017,129 | 46,093,325 | 40,994,292 | Self-Pay | 1,427,032 | 251,607 | 374,555 | ||||||||||
| DRT | 21,530,759 | 64,639 | |||||||||||||||
| Salaries | 34,884,362 | 20,349,211 | 19,934,295 | Collection Agencies | |||||||||||||
| Specialty Pay | 830,670 | 484,558 | 2,398,798 | CAOG | 3,072,374 | 28,661 | |||||||||||
| Benefits | 9,549,665 | 5,570,638 | 5,231,867 | GMMS | 2,546,701 | 10,376 | |||||||||||
| Annual Lump Sum | 29,226 | SAVANT | 3,625,419 | 13,303 | |||||||||||||
| Other Pay | UPCA | 392,467 | |||||||||||||||
| Overtime | 2,011,306 | 1,173,262 | 1,362,382 | Total | 8,193,658 | 31,453,999 | 5,630,449 | ||||||||||
| Total Salaries & Benefits | 47,276,003 | 27,577,668 | 28,956,568 | ||||||||||||||
| Travel & Training | 100,230 | 58,468 | 85,013 | Accounts Receivable (Net) | |||||||||||||
| Contractual Services | 9,096,233 | 5,306,136 | 3,220,103 | Medically Indigent Program | 6,112,138 | ||||||||||||
| Supplies & Materials | 10,336,019 | 6,029,344 | 6,152,643 | GovGuam | 1,085,586 | ||||||||||||
| Minor Equipment | 192,423 | 112,247 | 78,781 | Self Pay | 6,474,621 | ||||||||||||
| Miscellaneous | 284,678 | 166,062 | 95,770 | Medicare | 2,734,290 | ||||||||||||
| Utilities | 1,987,615 | 1,159,442 | 983,197 | Medicaid | 8,149,412 | ||||||||||||
| Capital Outlay | 2,896,928 | 1,689,875 | 229,642 | Commercial | 4,298,585 | ||||||||||||
| Debt Service | 6,847,000 | 3,994,083 | Total A/R (Net) | 28,854,632 | |||||||||||||
| Total Cash Disbursements | 79,017,129 | 46,093,325 | 39,801,717 | ||||||||||||||
| Surplus /(Deficit) | - | - | 1,192,575 | ||||||||||||||
| Accounts Payable Aging | |||||||||||||||||
| 04/30/06 | |||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||
| House Doctors | 36,485 | 64,494 | 91,733 | 270,673 | 463,385 | ||||||||||||
| Trade Payables | 928,792 | 1,170,396 | 651,710 | 839,968 | 3,590,866 | ||||||||||||
| Payroll Payables | 153,001 | 21,249 | - | - | 174,250 | ||||||||||||
| - Gov Ret DBP | 156,728 | - | - | 459,196 | 615,924 | ||||||||||||
| - Gov Ret DCP | - | - | - | - | - | ||||||||||||
| - Dept of Rev | 349,816 | 344,822 | 176,716 | - | 871,354 | ||||||||||||
| GTA | - | ||||||||||||||||
| GPA | - | (307,251) | 228,982 | 460,419 | 382,150 | ||||||||||||
| GWA | 22,421 | 22,552 | 22,784 | (640) | 67,117 | ||||||||||||
| Unbilled P O Receipts | 756,352 | 756,352 | |||||||||||||||
| Total | 2,403,595 | 1,316,262 | 1,171,925 | 2,029,616 | 6,921,398 | ||||||||||||
| Accounts Receivable Aging | |||||||||||||||||
| 04/30/06 | |||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||
| Commercial | 2,884,779 | 1,971,069 | 513,150 | 3,359,263 | 8,728,261 | ||||||||||||
| GovGuam | 72,862 | 13,866 | 13,654 | 2,070,790 | 2,171,172 | ||||||||||||
| Medicaid | 2,229,225 | 1,790,465 | 1,322,120 | 10,957,014 | 16,298,824 | ||||||||||||
| Medically Indigent Program | 3,065,432 | 1,053,493 | 831,037 | 10,722,187 | 15,672,149 | ||||||||||||
| Medicare | 2,826,507 | 160,489 | 113,136 | 2,368,447 | 5,468,579 | ||||||||||||
| Self Pay | 3,153,514 | 1,561,813 | 1,635,009 | 36,813,805 | 43,164,141 | ||||||||||||
| Total | 14,232,319 | 6,551,195 | 4,428,106 | 66,291,506 | 91,503,126 | ||||||||||||