| Budget Comparison (Cash Basis) | Billing, Collection & Denials | |||||||||||||||||||
| FY 2006 | FY 2006 | FY 2006 | FY 2007 | 09/30/06 | ||||||||||||||||
| Approved | 12 Month Budget | 12 Month Actual | Approved | Gross Billings | Bad Debt | Collections | ||||||||||||||
| Patient Revenues | 52,675,260 | 52,675,260 | 56,323,089 | 61,097,228 | Medically Indigent Program | 1,163,050 | 760 | 1,077,721 | ||||||||||||
| Cafeteria Sales | 600,000 | 600,000 | 743,678 | 600,000 | Medicaid | 1,407,039 | 12,250 | |||||||||||||
| ANA Grant | 5,713 | Medicare | 2,191,486 | 16,402 | 732,258 | |||||||||||||||
| Health Securities Trust Fund | 283,130 | 283,130 | 466,260 | PacifiCare | 722,528 | 485,179 | ||||||||||||||
| Health Securities Trust Fund Series B | 3,500,000 | 3,500,000 | Staywell | 1,232,111 | 966 | 699,407 | ||||||||||||||
| Compact Impact Funds | 3,700,000 | 3,700,000 | 5,081,027 | 6,300,000 | Select Care | 344,611 | 268,435 | |||||||||||||
| Bioterrorism | 646,460 | Net care | 308,243 | 286,105 | ||||||||||||||||
| FEMA | 184,424 | Commercial | 197,202 | 77,253 | ||||||||||||||||
| GovGuam Subsidy | 3,639,977 | Miscellaneous | ||||||||||||||||||
| Bad Debt | 1,027,527 | 1,027,527 | 1,027,527 | Nanbo | 8,384 | |||||||||||||||
| Charitable Donations | FSM | |||||||||||||||||||
| Advanced Appropriations | 7,800,000 | 7,800,000 | GOG | 31,215 | (621) | 3,011 | ||||||||||||||
| GRT | 9,431,212 | 9,431,212 | 8,421,521 | 10,062,795 | Healthy Futures Fund | |||||||||||||||
| Medicare Reimbursement FY03 MCR | - | 1,457,016 | Health Securities Trust Fund | |||||||||||||||||
| Total Collections | 79,017,129 | 79,017,129 | 74,356,715 | 81,700,000 | Self-Pay | 2,164,388 | 121,325 | 435,566 | ||||||||||||
| DRT | 24,790,667 | 41,993 | ||||||||||||||||||
| Salaries | 34,884,362 | 34,884,362 | 35,260,272 | 39,009,411 | Attorney | 64,105 | ||||||||||||||
| Specialty Pay | 830,670 | 830,670 | 4,211,961 | 1,144,703 | Collection Agency of Guam | 3,064,693 | ||||||||||||||
| Benefits | 9,549,665 | 9,549,665 | 9,219,527 | 10,644,570 | Guam Marianas Collection Agency | 2,500,513 | 11,623 | |||||||||||||
| Annual Lump Sum | 132,846 | Savant | 3,597,194 | 6,883 | ||||||||||||||||
| Other Pay | United Pacific Collection Agency | 402,080 | ||||||||||||||||||
| Overtime | 2,011,306 | 2,011,306 | 2,547,632 | 1,790,025 | Total | 9,761,873 | 34,570,334 | 4,133,818 | ||||||||||||
| Total Salaries & Benefits | 47,276,003 | 47,276,003 | 51,372,238 | 52,588,709 | 0 | |||||||||||||||
| Travel & Training | 100,230 | 100,230 | 200,857 | 36,900 | Accounts Receivable (Net) | |||||||||||||||
| Contractual Services | 9,096,233 | 9,096,233 | 5,240,070 | 11,882,372 | Medically Indigent Program | 6,820,295 | 22.28% | |||||||||||||
| Supplies & Materials | 10,336,019 | 10,336,020 | 14,194,092 | 13,268,304 | GovGuam | 1,259,264 | 4.11% | |||||||||||||
| Miscellaneous | 477,101 | 477,099 | 804,848 | 688,564 | Self Pay | 7,723,921 | 25.23% | |||||||||||||
| Utilities | 1,987,615 | 1,987,615 | 2,016,910 | 2,324,865 | Medicare | 2,954,667 | 9.65% | |||||||||||||
| Capital Outlay | 2,896,928 | 2,896,928 | 2,328,205 | 561,439 | Medicaid | 8,417,065 | 27.49% | |||||||||||||
| Debt Service | 6,847,000 | 6,847,001 | 478,313 | Commercial | 3,442,606 | 11.24% | ||||||||||||||
| Minor Equipmant | 348,847 | |||||||||||||||||||
| Total Cash Disbursements | 79,017,129 | 79,017,129 | 76,635,533 | 81,700,000 | Total A/R (Net) | 30,617,818 | 100.00% | |||||||||||||
| Surplus /(Deficit) | - | (2,278,818) | (0) | |||||||||||||||||
| Accounts Payable Aging | ||||||||||||||||||||
| 09/30/06 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | ||||||||||||||||
| House Doctors | 152 | 273 | 434,225 | 434,650 | ||||||||||||||||
| Trade Payables | 527,326 | 1,134,967 | 2,378,221 | 1,486,023 | 5,526,537 | |||||||||||||||
| Payroll Payables | 187,588 | 91,609 | 279,197 | |||||||||||||||||
| - Gov Ret DBP | 157,829 | 135,163 | 292,991 | |||||||||||||||||
| - Gov Ret DCP | - | |||||||||||||||||||
| - Dept of Rev | 395,113 | 368,768 | 395,114 | 1,084,758 | 2,243,753 | |||||||||||||||
| GTA | - | |||||||||||||||||||
| GPA | - | |||||||||||||||||||
| GWA | 1,069 | 17,061 | 51 | 18,180 | ||||||||||||||||
| Unbilled PO Receipts | 220,003 | 220,003 | ||||||||||||||||||
| Total | 1,489,079 | 1,612,405 | 2,773,658 | 3,140,169 | 9,015,312 | |||||||||||||||
| Accounts Receivable Aging | ||||||||||||||||||||
| 09/30/06 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | ||||||||||||||||
| Commercial | 3,000,512 | 1,102,581 | 265,537 | 2,803,435 | 7,172,065 | |||||||||||||||
| GovGuam | 424,361 | 40,480 | 27,009 | 2,131,617 | 2,623,467 | |||||||||||||||
| Medicaid | 1,901,343 | 1,820,709 | 1,396,452 | 12,417,047 | 17,535,551 | |||||||||||||||
| Medically Indigent Program | 3,458,706 | 91,845 | 108,199 | 2,496,808 | 6,155,558 | |||||||||||||||
| Medicare | 3,043,490 | 1,110,667 | 1,036,392 | 9,320,716 | 14,511,265 | |||||||||||||||
| Self Pay | 3,403,349 | 1,716,718 | 1,462,274 | 41,625,925 | 48,208,266 | |||||||||||||||
| Total | 15,231,761 | 5,883,000 | 4,295,863 | 70,795,548 | 96,206,172 | |||||||||||||||
| 12 | ||||||||||||||||||||
| 2006 | ||||||||||||||||||||