| Budget Comparison (Cash Basis) | Billing, Collection & Denials | |||||||||||||||||||
| FY 2007 | FY 2007 | FY 2007 | 10/31/06 | |||||||||||||||||
| Approved | 1 Month Budget | 1 Month Actual | Gross Billings | Bad Debt | Collections | |||||||||||||||
| Patient Revenues | 61,097,228 | 5,091,436 | 7,262,165 | Medically Indigent Program | 1,029,096 | 760 | 1,164,537 | |||||||||||||
| Cafeteria Sales | 600,000 | 50,000 | 121,847 | Medicaid | 1,578,441 | 12,250 | 2,912,764 | |||||||||||||
| ANA Grant | - | Medicare | 1,806,035 | 27,797 | 671,363 | |||||||||||||||
| Health Securities Trust Fund | - | - | TakeCare | 618,553 | 624,315 | |||||||||||||||
| Health Securities Trust Fund Series B | - | Staywell | 1,154,038 | 966 | 881,304 | |||||||||||||||
| Compact Impact Funds | 6,300,000 | 525,000 | Select Care | 627,693 | 178,074 | |||||||||||||||
| Bioterrorism | - | Net care | 335,195 | 139,403 | ||||||||||||||||
| FEMA | 164,101 | Commercial | 178,122 | 45,175 | ||||||||||||||||
| GovGuam Subsidy | 3,639,977 | 303,331 | Miscellaneous | |||||||||||||||||
| Bad Debt | - | - | Nanbo | |||||||||||||||||
| Charitable Donations | FSM | |||||||||||||||||||
| Advanced Appropriations | - | GOG | 35,286 | (621) | 20,086 | |||||||||||||||
| GRT | 10,062,795 | 838,566 | - | Healthy Futures Fund | ||||||||||||||||
| Medicare Reimbursement FY03 MCR | - | 4,921,530 | Health Securities Trust Fund | |||||||||||||||||
| Total Collections | 81,700,000 | 6,808,333 | 12,469,643 | Self-Pay | 2,191,473 | 128,398 | 539,896 | |||||||||||||
| DRT | 24,768,074 | 22,349 | ||||||||||||||||||
| Salaries | 39,709,411 | 3,309,118 | 2,733,288 | Attorney | 64,005 | |||||||||||||||
| Specialty Pay | 1,025,343 | 85,445 | 281,769 | Collection Agency of Guam | 3,024,821 | 54,560 | ||||||||||||||
| Benefits | 10,644,570 | 887,048 | 824,906 | Guam Marianas Collection Agency | 2,523,015 | |||||||||||||||
| Annual Lump Sum | 16,308 | Savant | 3,587,720 | 8,340 | ||||||||||||||||
| Other Pay | United Pacific Collection Agency | 401,948 | ||||||||||||||||||
| Overtime | 1,909,385 | 159,115 | 242,775 | Total | 9,553,930 | 34,539,132 | 7,262,166 | |||||||||||||
| Total Salaries & Benefits | 53,288,709 | 4,440,726 | 4,099,046 | 7,262,166 | ||||||||||||||||
| Travel & Training | 40,444 | 3,370 | 22,578 | Accounts Receivable (Net) | ||||||||||||||||
| Contractual Services | 11,200,657 | 933,388 | 1,477,096 | Medically Indigent Program | 5,811,221 | 24.40% | ||||||||||||||
| Supplies & Materials | 13,252,694 | 1,104,392 | 2,830,755 | GovGuam | 1,082,274 | 4.54% | ||||||||||||||
| Miscellaneous | 682,345 | 56,860 | 7,033 | Self Pay | 5,004,870 | 21.02% | ||||||||||||||
| Utilities | 2,324,865 | 193,739 | 246,199 | Medicare | 2,624,802 | 11.02% | ||||||||||||||
| Capital Outlay | 534,439 | 44,537 | 23,886 | Medicaid | 6,006,625 | 25.22% | ||||||||||||||
| Debt Service | - | 43,483 | Commercial | 3,285,629 | 13.80% | |||||||||||||||
| Minor Equipmant | 375,847 | |||||||||||||||||||
| Total Cash Disbursements | 81,700,000 | 6,777,012 | 8,750,076 | Total A/R (Net) | 23,815,421 | 100.00% | ||||||||||||||
| Surplus /(Deficit) | 3,719,567 | (0) | ||||||||||||||||||
| Accounts Payable Aging | ||||||||||||||||||||
| 10/31/06 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | ||||||||||||||||
| House Doctors | 152 | 692 | 7,766 | 8,610 | ||||||||||||||||
| Trade Payables | 1,172,241 | 1,433,549 | 962,427 | 2,201,982 | 5,770,199 | |||||||||||||||
| Payroll Payables | - | |||||||||||||||||||
| - Gov Ret DBP | 160,529 | 160,529 | ||||||||||||||||||
| - Gov Ret DCP | - | |||||||||||||||||||
| - Dept of Rev | 184,609 | 184,609 | ||||||||||||||||||
| GTA | - | |||||||||||||||||||
| GPA | 127,300 | 127,300 | ||||||||||||||||||
| GWA | 29,365 | 18,180 | 47,545 | |||||||||||||||||
| Unbilled PO Receipts | 257,171 | 257,171 | ||||||||||||||||||
| Total | 1,804,067 | 1,579,721 | 962,427 | 2,209,749 | 6,555,963 | |||||||||||||||
| Accounts Receivable Aging | ||||||||||||||||||||
| 10/31/06 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | ||||||||||||||||
| Commercial | 3,142,268 | 1,514,406 | 519,079 | 3,038,319 | 8,214,072 | |||||||||||||||
| GovGuam | 506,096 | 25,592 | 31,575 | 2,142,423 | 2,705,686 | |||||||||||||||
| Medicaid | 2,065,361 | 1,318,083 | 1,905,913 | 9,727,205 | 15,016,563 | |||||||||||||||
| Medically Indigent Program | 2,909,126 | 705,581 | 75,587 | 2,559,235 | 6,249,529 | |||||||||||||||
| Medicare | 3,349,318 | 1,147,800 | 1,136,145 | 8,894,789 | 14,528,052 | |||||||||||||||
| Self Pay | 3,691,009 | 1,625,303 | 1,710,220 | 42,767,855 | 49,794,389 | |||||||||||||||
| Total | 15,663,179 | 6,336,764 | 5,378,520 | 69,129,826 | 96,508,290 | |||||||||||||||
| 1 | ||||||||||||||||||||
| 2006 | ||||||||||||||||||||