| Budget Comparison (Cash Basis) | Billing, Collection & Denials | ||||||||||||||||||
| FY 2006 | FY 2006 | FY 2006 | 08/31/06 | ||||||||||||||||
| Approved | 11 Month Budget | 11 Month Actual | Gross Billings | Bad Debt | Collections | ||||||||||||||
| Patient Revenues | 52,675,260 | 48,285,655 | 52,189,271 | Medically Indigent Program | 2,232,741 | 760 | |||||||||||||
| Cafeteria Sales | 600,000 | 550,000 | 666,551 | Medicaid | 2,689,506 | 12,250 | 439,442 | ||||||||||||
| ANA Grant | 5,713 | Medicare | 2,422,005 | 17,440 | 776,930 | ||||||||||||||
| Healthy Futures | PacifiCare | 702,542 | 615,100 | ||||||||||||||||
| Health Securities Trust Fund | 3,500,000 | 3,208,333 | Staywell | 966 | 1,630,455 | ||||||||||||||
| Compact Impact Funds | 3,700,000 | 3,391,667 | 4,624,690 | Select Care | 370,031 | 302,298 | |||||||||||||
| Bioterrorism | 646,460 | Net care | 424,884 | (262) | 275,129 | ||||||||||||||
| FEMA | 184,424 | Commercial | 478,854 | 64,135 | |||||||||||||||
| GovGuam Subsidy | Miscellaneous | ||||||||||||||||||
| Bad Debt | 1,027,527 | 941,900 | 1,027,527 | Nanbo | |||||||||||||||
| Charitable Donations | FSM | ||||||||||||||||||
| Advanced Appropriations | 7,800,000 | 7,150,000 | GOG | (621) | 31,420 | ||||||||||||||
| GRT | 9,431,212 | 8,645,278 | 7,145,955 | Healthy Futures Fund | |||||||||||||||
| Health Securities Trust Fund | 283,130 | 259,536 | 183,130 | Health Securities Trust Fund | |||||||||||||||
| Total Collections | 79,017,129 | 72,432,369 | 66,673,721 | Self-Pay | 1,718,198 | 211,525 | 498,994 | ||||||||||||
| DRT | 1,604,222 | 24,852,307 | |||||||||||||||||
| Salaries | 34,884,362 | 31,977,332 | 31,012,948 | Attorney | 64,105 | ||||||||||||||
| Specialty Pay | 830,670 | 761,448 | 3,589,966 | Collection Agency of Guam | 3,058,279 | 26,436 | |||||||||||||
| Benefits | 9,549,665 | 8,753,860 | 8,134,156 | Guam Marianas Collection Agency | 2,507,597 | 9,751 | |||||||||||||
| Annual Lump Sum | 132,846 | Savant | 3,602,873 | 4,460 | |||||||||||||||
| Other Pay | United Pacific Collection Agency | 402,588 | |||||||||||||||||
| Overtime | 2,011,306 | 1,843,697 | 2,199,340 | Total | 12,642,984 | 34,729,808 | 4,674,551 | ||||||||||||
| Total Salaries & Benefits | 47,276,003 | 43,336,336 | 45,069,256 | (0) | |||||||||||||||
| Travel & Training | 100,230 | 91,878 | 184,119 | Accounts Receivable (Net) | |||||||||||||||
| Contractual Services | 9,096,233 | 8,338,214 | 4,807,084 | Medically Indigent Program | 6,768,352 | 22.56% | |||||||||||||
| Supplies & Materials | 10,336,019 | 9,474,685 | 12,076,723 | GovGuam | 1,057,003 | 3.52% | |||||||||||||
| Miscellaneous | 477,101 | 437,341 | 776,858 | Self Pay | 6,688,725 | 22.29% | |||||||||||||
| Utilities | 1,987,615 | 1,821,980 | 1,729,210 | Medicare | 2,615,797 | 8.72% | |||||||||||||
| Capital Outlay | 2,896,928 | 2,655,517 | 2,328,205 | Medicaid | 7,881,724 | 26.27% | |||||||||||||
| Debt Service | 6,847,000 | 6,276,418 | 434,830 | Commercial | 4,991,195 | 16.64% | |||||||||||||
| Total Cash Disbursements | 79,017,129 | 72,432,369 | 67,406,285 | Total A/R (Net) | 30,002,796 | 100.00% | |||||||||||||
| Surplus /(Deficit) | - | - | (732,564) | (0) | |||||||||||||||
| Accounts Payable Aging | |||||||||||||||||||
| 08/31/06 | |||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | - | ||||||||||||||
| House Doctors | 425 | 817 | 9,838 | 532,500 | 543,579 | ||||||||||||||
| Trade Payables | 979,179 | 2,991,159 | 1,025,385 | 2,181,385 | 7,177,108 | ||||||||||||||
| Payroll Payables | 304,908 | 172,644 | 21,388 | 21,579 | 520,518 | ||||||||||||||
| - Gov Ret DBP | 455,529 | 455,529 | |||||||||||||||||
| - Gov Ret DCP | - | ||||||||||||||||||
| - Dept of Rev | 369,243 | 395,114 | 381,965 | 1,626,123 | 2,772,446 | ||||||||||||||
| GTA | - | ||||||||||||||||||
| GPA | - | ||||||||||||||||||
| GWA | 31,905 | 817 | 1,614 | 197 | 34,533 | ||||||||||||||
| Unbilled P O Receipts | 449,520 | 449,520 | |||||||||||||||||
| Total | 2,135,179 | 3,560,551 | 1,440,190 | 4,817,314 | 11,953,233 | ||||||||||||||
| Accounts Receivable Aging | |||||||||||||||||||
| 08/31/06 | |||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||||
| Commercial | 200,427 | 166,600 | 456,479 | 7,392,635 | 8,216,140 | ||||||||||||||
| GovGuam | 21,459 | - | 2,180,631 | 2,202,090 | |||||||||||||||
| Medicaid | 944,336 | 203,643 | - | 15,272,279 | 16,420,258 | ||||||||||||||
| Medically Indigent Program | 977,646 | 223,471 | - | 14,181,501 | 15,382,618 | ||||||||||||||
| Medicare | 207,697 | - | 58,748 | 5,183,132 | 5,449,578 | ||||||||||||||
| Self Pay | 1,473,470 | 2,128,984 | 5,230,173 | 37,240,355 | 46,072,983 | ||||||||||||||
| Total | 3,803,577 | 2,744,157 | 5,745,401 | 81,450,532 | 93,743,667 | ||||||||||||||
| 11 | |||||||||||||||||||
| 2006 | |||||||||||||||||||