| Budget Comparison (Cash Basis) | Billing, Collection & Denials | ||||||||||||||||
| FY 2006 | FY 2006 | FY 2006 | 03/31/06 | ||||||||||||||
| Approved | 6 Month Budget | 6 Month Actual | Gross Billings | Bad Debt | Collections | ||||||||||||
| Patient Revenues | 53,258,165 | 26,629,083 | Medically Indigent Program | 1,584,940 | 2,377 | 365,341 | |||||||||||
| Cafeteria Sales | 600,000 | 300,000 | Medicaid | 2,277,279 | 14,875 | 940,093 | |||||||||||
| HRSA Grant | Medicare | 2,141,551 | 16,994 | 734,903 | |||||||||||||
| Healthy Futures | 4,000,000 | 2,000,000 | Pacificare | 685,728 | 746,056 | ||||||||||||
| Healthy Futures - Pt Education | Staywell | 1,112,324 | 966 | 1,109,823 | |||||||||||||
| Compact Impact Funds | 3,200,000 | 1,600,000 | Calvo's | 459,607 | 322,207 | ||||||||||||
| Misc Revenues | Net care | 373,601 | 265,661 | ||||||||||||||
| FEMA | Commercial | 235,196 | |||||||||||||||
| GovGuam Subsidy | 17,958,964 | 8,979,482 | Miscellaneous | 83,918 | 982 | 83,458 | |||||||||||
| Insurance Settlement | Nanbo | ||||||||||||||||
| Charitable Donations | FSM | 47 | |||||||||||||||
| GTA Sale Proceeds | GOG | 18,904 | |||||||||||||||
| GRT | Healthy Futures Fund | ||||||||||||||||
| Health Securities Trust Fund | Health Securities Trust Fund | ||||||||||||||||
| Total Collections | 79,017,129 | 39,508,565 | - | Self-Pay | 1,445,444 | 273,220 | 475,968 | ||||||||||
| DRT | 21,606,460 | ||||||||||||||||
| Salaries | 34,884,362 | 17,442,181 | Collection Agencies | ||||||||||||||
| Specialty Pay | 830,670 | 415,335 | CAOG | 3,116,302 | |||||||||||||
| Benefits | 9,549,665 | 4,774,833 | GMMS | 2,550,578 | 9,987 | ||||||||||||
| Annual Lump Sum | SAVANT | 3,633,192 | 6,761 | ||||||||||||||
| Other Pay | UPCA | 385,483 | |||||||||||||||
| Overtime | 2,011,306 | 1,005,653 | Total | 10,418,492 | 31,601,476 | 5,060,258 | |||||||||||
| Total Salaries & Benefits | 47,276,003 | 23,638,002 | - | ||||||||||||||
| Travel & Training | 100,230 | 50,115 | Accounts Receivable (Net) | ||||||||||||||
| Contractual Services | 9,096,233 | 4,548,117 | Medically Indigent Program | 6,497,755 | |||||||||||||
| Supplies & Materials | 10,336,019 | 5,168,010 | GovGuam | 1,784,387 | |||||||||||||
| Minor Equipment | 192,423 | 96,212 | Self Pay | 4,352,307 | |||||||||||||
| Miscellaneous | 284,678 | 142,339 | Medicare | 2,442,620 | |||||||||||||
| Utilities | 1,987,615 | 993,808 | Medicaid | 7,376,829 | |||||||||||||
| Capital Outlay | 2,896,928 | 1,448,464 | Commercial | 5,080,286 | |||||||||||||
| Debt Service | 6,847,000 | 3,423,498 | Total A/R (Net) | 27,534,184 | |||||||||||||
| Total Cash Disbursements | 79,017,129 | 39,508,565 | - | - | |||||||||||||
| Surplus /(Deficit) | - | - | - | ||||||||||||||
| Accounts Payable Aging | |||||||||||||||||
| 03/31/06 | |||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||
| House Doctors | 58,398 | 47,924 | 16,190 | 324,495 | 447,007 | ||||||||||||
| Trade Payables | 839,397 | 1,002,596 | 631,074 | 1,201,015 | 3,674,082 | ||||||||||||
| Payroll Payables | 155,769 | 155,769 | |||||||||||||||
| - Gov Ret DBP | 161,637 | 459,196 | 620,833 | ||||||||||||||
| - Gov Ret DCP | - | ||||||||||||||||
| - Dept of Rev | 344,822 | 176,716 | 521,538 | ||||||||||||||
| GTA | 23,084 | 23,084 | |||||||||||||||
| GPA | 119,164 | 116,804 | 343,614 | 579,582 | |||||||||||||
| GWA | 21,603 | 22,784 | (416) | (224) | 43,747 | ||||||||||||
| Unbilled P O Receipts | 712,483 | 712,483 | |||||||||||||||
| Total | 2,317,193 | 1,369,184 | 763,652 | 2,328,096 | 6,778,125 | ||||||||||||
| - | |||||||||||||||||
| Accounts Receivable Aging | |||||||||||||||||
| 03/31/06 | |||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||
| Commercial | 3,571,381 | 1,645,788 | 806,075 | 3,189,440 | 9,212,684 | ||||||||||||
| GovGuam | 48,856 | 7,547 | 11,145 | 2,031,731 | 2,099,279 | ||||||||||||
| Medicaid | 2,264,802 | 1,222,056 | 1,477,513 | 11,428,583 | 16,392,954 | ||||||||||||
| Medically Indigent Program | 3,155,910 | 764,862 | 1,091,771 | 11,231,845 | 16,244,388 | ||||||||||||
| Medicare | 3,010,485 | 113,160 | 133,147 | 2,171,252 | 5,428,044 | ||||||||||||
| Self Pay | 3,130,194 | 1,505,304 | 1,351,006 | 35,464,036 | 41,450,540 | ||||||||||||
| Total | 15,181,628 | 5,258,717 | 4,870,657 | 65,516,887 | 90,827,889 | ||||||||||||