| Budget Comparison (Cash Basis) | Billing, Collection & Denials | ||||||||||||||||||
| FY 2006 | FY 2006 | FY 2006 | 06/30/06 | ||||||||||||||||
| Approved | 9 Month Budget | 9 Month Actual | Gross Billings | Bad Debt | Collections | ||||||||||||||
| Patient Revenues | 52,675,260 | 39,506,445 | 43,121,367 | Medically Indigent Program | 1,595,022 | 952 | 510,058 | ||||||||||||
| Cafeteria Sales | 600,000 | 450,000 | 563,499 | Medicaid | 1,575,947 | 14,330 | 1,337,972 | ||||||||||||
| HRSA Grant | Medicare | 1,880,868 | 16,994 | 954,769 | |||||||||||||||
| Healthy Futures | PacifiCare | 644,864 | 539,257 | ||||||||||||||||
| Health Securities Trust Fund | 3,500,000 | 2,625,000 | Staywell | 1,154,635 | 966 | 950,002 | |||||||||||||
| Compact Impact Funds | 3,700,000 | 2,775,000 | 2,626,889 | Select Care | 206,991 | 209,789 | |||||||||||||
| Misc Revenues | Net care | 341,320 | 277,482 | ||||||||||||||||
| FEMA | 184,424 | Commercial | 273,698 | 866 | 120,341 | ||||||||||||||
| GovGuam Subsidy | Miscellaneous | ||||||||||||||||||
| Bad Debt | 1,027,527 | 770,645 | 646,460 | Nanbo | |||||||||||||||
| Charitable Donations | FSM | ||||||||||||||||||
| Advanced Appropriations | 7,800,000 | 5,850,000 | GOG | 38,794 | 10,314 | ||||||||||||||
| GRT | 9,431,212 | 7,073,409 | 5,207,661 | Healthy Futures Fund | |||||||||||||||
| Health Securities Trust Fund | 283,130 | 212,348 | 183,130 | Health Securities Trust Fund | |||||||||||||||
| Total Collections | 79,017,129 | 59,262,847 | 52,533,430 | Self-Pay | 1,453,156 | 332,536 | 413,322 | ||||||||||||
| DRT | 24,754,405 | 30,459 | |||||||||||||||||
| Salaries | 34,884,362 | 26,163,272 | 25,606,679 | Collection Agencies | |||||||||||||||
| Specialty Pay | 830,670 | 623,003 | 2,998,228 | Collection Agency of Guam | 3,018,476 | ||||||||||||||
| Benefits | 9,549,665 | 7,162,249 | 6,688,373 | Guam Marianas Collection Agency | 2,526,602 | 7,497 | |||||||||||||
| Annual Lump Sum | 85,731 | Savant | 3,612,137 | 6,933 | |||||||||||||||
| Other Pay | United Pacific Collection Agency | 402,244 | |||||||||||||||||
| Overtime | 2,011,306 | 1,508,480 | 1,747,712 | Total | 9,165,295 | 34,680,508 | 5,368,195 | ||||||||||||
| Total Salaries & Benefits | 47,276,003 | 35,457,002 | 37,126,723 | ||||||||||||||||
| Travel & Training | 100,230 | 75,173 | 173,413 | Accounts Receivable (Net) | |||||||||||||||
| Contractual Services | 9,096,233 | 6,822,175 | 4,195,817 | Medically Indigent Program | 6,381,674 | 21.79% | |||||||||||||
| Supplies & Materials | 10,336,019 | 7,752,014 | 9,222,332 | GovGuam | 1,100,892 | 3.76% | |||||||||||||
| Minor Equipment | 192,423 | 144,317 | 42,134 | Self Pay | 6,987,236 | 23.86% | |||||||||||||
| Miscellaneous | 284,678 | 213,509 | 596,197 | Medicare | 2,904,601 | 9.92% | |||||||||||||
| Utilities | 1,987,615 | 1,490,711 | 1,413,083 | Medicaid | 7,636,140 | 26.07% | |||||||||||||
| Capital Outlay | 2,896,928 | 2,172,696 | 396,213 | Commercial | 4,277,926 | 14.61% | |||||||||||||
| Debt Service | 1,764,000 | 1,323,000 | 347,864 | Total A/R (Net) | 29,288,469 | 100.00% | |||||||||||||
| Accounts payables | 5,083,000 | 3,812,250 | - | ||||||||||||||||
| Total Cash Disbursements | 79,017,129 | 59,262,847 | 53,513,776 | ||||||||||||||||
| Surplus /(Deficit) | - | - | (980,346) | ||||||||||||||||
| Accounts Payable Aging | |||||||||||||||||||
| 06/30/06 | |||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||||
| House Doctors | 3,612 | 3,929 | 88,488 | 463,156 | 559,185 | ||||||||||||||
| Trade Payables | 773,342 | 983,557 | 1,202,185 | 1,790,965 | 4,750,049 | ||||||||||||||
| Payroll Payables | 96,384 | 154,555 | 31,997 | 282,936 | |||||||||||||||
| - Gov Ret DBP | 459,196 | 459,196 | |||||||||||||||||
| - Gov Ret DCP | - | ||||||||||||||||||
| - Dept of Rev | 197,332 | 358,032 | 549,221 | 521,537 | 1,626,122 | ||||||||||||||
| GTA | 23,300 | 23,300 | |||||||||||||||||
| GPA | 129,635 | 1 | 129,636 | ||||||||||||||||
| GWA | 25,444 | 18,999 | (541) | 43,902 | |||||||||||||||
| Unbilled P O Receipts | 387,559 | 387,559 | |||||||||||||||||
| Total | 1,636,608 | 1,519,072 | 1,871,891 | 3,234,314 | 8,261,885 | ||||||||||||||
| - | |||||||||||||||||||
| Accounts Receivable Aging | |||||||||||||||||||
| 06/30/06 | |||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||||
| Commercial | 3,050,722 | 1,544,640 | 461,953 | 3,498,539 | 8,555,854 | ||||||||||||||
| GovGuam | 73,027 | 40,155 | 23,210 | 2,065,391 | 2,201,783 | ||||||||||||||
| Medicaid | 1,970,531 | 1,760,646 | 1,614,880 | 9,926,222 | 15,272,279 | ||||||||||||||
| Medically Indigent Program | 3,047,273 | 1,064,410 | 941,096 | 9,128,722 | 14,181,501 | ||||||||||||||
| Medicare | 3,338,495 | 66,976 | 96,062 | 2,307,669 | 5,809,202 | ||||||||||||||
| Self Pay | 2,882,707 | 1,723,425 | 1,589,182 | 36,701,145 | 42,896,459 | ||||||||||||||
| Total | 14,362,755 | 6,200,252 | 4,726,383 | 63,627,688 | 88,917,078 | ||||||||||||||