| Budget Comparison (Cash Basis) | Billing, Collection & Denials | ||||||||||||||||||
| FY 2006 | FY 2006 | FY 2006 | 05/31/06 | ||||||||||||||||
| Approved | 8 Month Budget | 8 Month Actual | Gross Billings | Bad Debt | Collections | ||||||||||||||
| Patient Revenues | 52,675,260 | 35,116,840 | 37,822,675 | Medically Indigent Program | 1,387,438 | 952 | 775,394 | ||||||||||||
| Cafeteria Sales | 600,000 | 400,000 | 464,222 | Medicaid | 2,187,872 | 14,330 | 550,000 | ||||||||||||
| HRSA Grant | Medicare | 2,282,232 | 16,994 | 736,863 | |||||||||||||||
| Healthy Futures | PacifiCare | 836,260 | 437,024 | ||||||||||||||||
| Health Securities Trust Fund | 3,500,000 | 2,333,333 | Staywell | 1,215,212 | 966 | 540,397 | |||||||||||||
| Compact Impact Funds | 3,700,000 | 2,466,667 | 2,626,889 | CALVO'S | 425,450 | 765,432 | |||||||||||||
| Misc Revenues | Net care | 380,473 | 328,295 | ||||||||||||||||
| FEMA | Commercial | 195,291 | 866 | ||||||||||||||||
| GovGuam Subsidy | Miscellaneous | 123,592 | |||||||||||||||||
| Bad Debt | 1,027,527 | 685,018 | 640,897 | Nanbo | 753 | ||||||||||||||
| Charitable Donations | FSM | ||||||||||||||||||
| Advanced Appropriations | 7,800,000 | 5,200,000 | GOG | 39,269 | (621) | ||||||||||||||
| GRT | 9,431,212 | 6,287,475 | 4,539,433 | Healthy Futures Fund | |||||||||||||||
| Health Securities Trust Fund | 283,130 | 188,753 | 183,130 | Health Securities Trust Fund | |||||||||||||||
| Total Collections | 79,017,129 | 52,678,086 | 46,277,246 | Self-Pay | 1,552,610 | 193,310 | 394,686 | ||||||||||||
| DRT | 24,828,661 | ||||||||||||||||||
| Salaries | 34,884,362 | 23,256,241 | 22,729,331 | Collection Agencies | |||||||||||||||
| Specialty Pay | 830,670 | 553,780 | 2,658,105 | Collection Agency of Guam | 3,014,650 | 31,378 | |||||||||||||
| Benefits | 9,549,665 | 6,366,443 | 5,963,508 | Guam Marianas Collection Agency | 2,538,381 | 7,933 | |||||||||||||
| Annual Lump Sum | 85,731 | Savant | 3,615,877 | 6,822 | |||||||||||||||
| Other Pay | United Pacific Collection Agency | 402,244 | |||||||||||||||||
| Overtime | 2,011,306 | 1,340,871 | 1,551,951 | Total | 10,502,860 | 34,626,610 | 4,697,816 | ||||||||||||
| Total Salaries & Benefits | 47,276,003 | 31,517,335 | 32,988,626 | - | |||||||||||||||
| Travel & Training | 100,230 | 66,820 | 102,925 | Accounts Receivable (Net) | |||||||||||||||
| Contractual Services | 9,096,233 | 6,064,155 | 4,029,812 | Medically Indigent Program | 6,168,405 | 20.96% | |||||||||||||
| Supplies & Materials | 10,336,019 | 6,890,679 | 7,319,429 | GovGuam | 1,107,456 | 3.76% | |||||||||||||
| Minor Equipment | 192,423 | 128,282 | 97,125 | Self Pay | 6,605,056 | 22.44% | |||||||||||||
| Miscellaneous | 284,678 | 189,785 | 100,102 | Medicare | 2,789,374 | 9.48% | |||||||||||||
| Utilities | 1,987,615 | 1,325,077 | 1,127,509 | Medicaid | 8,313,587 | 28.24% | |||||||||||||
| Capital Outlay | 2,896,928 | 1,931,285 | 222,926 | Commercial | 4,452,047 | 15.12% | |||||||||||||
| Debt Service | 1,764,000 | 1,176,000 | 401,301 | Total A/R (Net) | 29,435,925 | 100.00% | |||||||||||||
| Debt Service | 5,083,000 | 3,388,668 | 3,219,076 | ||||||||||||||||
| Total Cash Disbursements | 79,017,129 | 52,678,086 | 49,608,831 | ||||||||||||||||
| Surplus /(Deficit) | - | - | (3,331,585) | ||||||||||||||||
| Accounts Payable Aging | |||||||||||||||||||
| 05/31/06 | |||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||||
| House Doctors | 2,758 | 54,664 | 96,920 | 356,767 | 511,109 | ||||||||||||||
| Trade Payables | 572,375 | 1,456,500 | 995,150 | 1,138,164 | 4,162,189 | ||||||||||||||
| Payroll Payables | 94,867 | 50,527 | 145,394 | ||||||||||||||||
| - Gov Ret DBP | 158,572 | 459,196 | 617,768 | ||||||||||||||||
| - Gov Ret DCP | - | ||||||||||||||||||
| - Dept of Rev | 180,643 | 549,221 | 344,822 | 176,716 | 1,251,402 | ||||||||||||||
| GTA | - | ||||||||||||||||||
| GPA | 43,483 | (422,811) | 689,400 | 310,072 | |||||||||||||||
| GWA | 23,061 | 948 | (511) | 23,498 | |||||||||||||||
| Unbilled P O Receipts | 1,782,615 | 1,782,615 | |||||||||||||||||
| Total | 2,835,313 | 2,133,973 | 1,015,029 | 2,819,732 | 8,804,047 | ||||||||||||||
| Accounts Receivable Aging | |||||||||||||||||||
| 05/31/06 | |||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||||
| Commercial | 2,942,895 | 2,010,777 | 523,488 | 3,426,937 | 8,904,097 | ||||||||||||||
| GovGuam | 74,330 | 14,145 | 13,929 | 2,112,507 | 2,214,911 | ||||||||||||||
| Medicaid | 2,274,134 | 1,826,535 | 1,348,755 | 11,177,749 | 16,627,173 | ||||||||||||||
| Medically Indigent Program | 3,127,187 | 1,074,716 | 847,779 | 10,938,192 | 15,987,874 | ||||||||||||||
| Medicare | 2,883,449 | 163,722 | 115,415 | 2,416,161 | 5,578,747 | ||||||||||||||
| Self Pay | 3,217,043 | 1,593,277 | 1,667,947 | 37,555,440 | 44,033,707 | ||||||||||||||
| Total | 14,519,038 | 6,683,172 | 4,517,313 | 67,626,986 | 93,346,509 | ||||||||||||||