| Budget Comparison (Cash Basis) | Billing, Collection & Denials | ||||||||||||||||||
| FY 2006 | FY 2006 | FY 2006 | 07/31/06 | ||||||||||||||||
| Approved | 10 Month Budget | 10 Month Actual | Gross Billings | Bad Debt | Collections | ||||||||||||||
| Patient Revenues | 52,675,260 | 43,896,050 | 48,542,247 | Medically Indigent Program | 1,070,396 | 952 | 1,471,841 | ||||||||||||
| Cafeteria Sales | 600,000 | 500,000 | 605,761 | Medicaid | 1,240,586 | 12,250 | 221,153 | ||||||||||||
| ANA Grant | 5,713 | Medicare | 1,920,493 | 17,440 | 1,047,986 | ||||||||||||||
| Healthy Futures | PacifiCare | 878,436 | 492,846 | ||||||||||||||||
| Health Securities Trust Fund | 3,500,000 | 2,916,667 | Staywell | 1,155,190 | 966 | 1,082,747 | |||||||||||||
| Compact Impact Funds | 3,700,000 | 3,083,333 | 2,753,447 | Select Care | 376,139 | 150,341 | |||||||||||||
| Misc Revenues | Net care | 305,763 | 274,272 | ||||||||||||||||
| FEMA | 184,424 | Commercial | 303,203 | 95,882 | |||||||||||||||
| GovGuam Subsidy | Miscellaneous | ||||||||||||||||||
| Bad Debt | 1,027,527 | 856,273 | 646,460 | Nanbo | |||||||||||||||
| Charitable Donations | FSM | ||||||||||||||||||
| Advanced Appropriations | 7,800,000 | 6,500,000 | GOG | 22,931 | 12,884 | ||||||||||||||
| GRT | 9,431,212 | 7,859,343 | 5,924,014 | Healthy Futures Fund | |||||||||||||||
| Health Securities Trust Fund | 283,130 | 235,942 | 183,130 | Health Securities Trust Fund | |||||||||||||||
| Total Collections | 79,017,129 | 65,847,608 | 58,845,196 | Self-Pay | 1,458,112 | 205,217 | 365,314 | ||||||||||||
| DRT | 24,786,940 | 31,463 | |||||||||||||||||
| Salaries | 34,884,362 | 29,070,302 | 27,929,666 | Collection Agencies | |||||||||||||||
| Specialty Pay | 830,670 | 692,225 | 3,412,524 | Collection Agency of Guam | 3,034,264 | 49,155 | |||||||||||||
| Benefits | 9,549,665 | 7,958,054 | 7,413,068 | Guam Marianas Collection Agency | 2,514,026 | ||||||||||||||
| Annual Lump Sum | 122,416 | Savant | 3,607,368 | 6,689 | |||||||||||||||
| Other Pay | United Pacific Collection Agency | 402,588 | |||||||||||||||||
| Overtime | 2,011,306 | 1,676,088 | 1,950,717 | Total | 8,731,249 | 34,582,011 | 5,302,573 | ||||||||||||
| Total Salaries & Benefits | 47,276,003 | 39,396,669 | 40,828,391 | - | |||||||||||||||
| Travel & Training | 100,230 | 83,525 | 174,611 | Accounts Receivable (Net) | |||||||||||||||
| Contractual Services | 9,096,233 | 7,580,194 | 4,587,139 | Medically Indigent Program | 6,482,237 | 22.23% | |||||||||||||
| Supplies & Materials | 10,336,019 | 8,613,349 | 11,073,747 | GovGuam | 1,073,687 | 3.68% | |||||||||||||
| Miscellaneous | 477,101 | 397,584 | 761,664 | Self Pay | 7,216,572 | 24.75% | |||||||||||||
| Utilities | 1,987,615 | 1,656,346 | 1,581,009 | Medicare | 2,620,940 | 8.99% | |||||||||||||
| Capital Outlay | 2,896,928 | 2,414,107 | 456,962 | Medicaid | 7,737,961 | 26.54% | |||||||||||||
| Debt Service | 6,847,000 | 5,705,834 | 391,347 | Commercial | 4,022,591 | 13.80% | |||||||||||||
| Total Cash Disbursements | 79,017,129 | 65,847,608 | 59,854,870 | Total A/R (Net) | 29,153,988 | 100.00% | |||||||||||||
| Surplus /(Deficit) | - | - | (1,009,674) | - | |||||||||||||||
| Accounts Payable Aging | |||||||||||||||||||
| 07/31/06 | |||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||||
| House Doctors | 152 | 4,040 | 62,022 | 545,542 | 611,756 | ||||||||||||||
| Trade Payables | 2,492,656 | 1,215,717 | 832,071 | 1,471,124 | 6,011,568 | ||||||||||||||
| Payroll Payables | 263,983 | 156,048 | 88,006 | 31,997 | 540,034 | ||||||||||||||
| - Gov Ret DBP | 459,196 | 459,196 | |||||||||||||||||
| - Gov Ret DCP | - | ||||||||||||||||||
| - Dept of Rev | 394,105 | 386,349 | 358,032 | 1,070,759 | 2,209,245 | ||||||||||||||
| GTA | 22,962 | 22,962 | |||||||||||||||||
| GPA | 123,473 | 123,473 | |||||||||||||||||
| GWA | 25,389 | 25,444 | 18,999 | (541) | 69,291 | ||||||||||||||
| Unbilled P O Receipts | 36,880 | 36,880 | |||||||||||||||||
| Total | 3,359,600 | 1,787,598 | 1,359,130 | 3,578,077 | 10,084,405 | ||||||||||||||
| Accounts Receivable Aging | |||||||||||||||||||
| 07/31/06 | |||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||||
| Commercial | 3,540,910 | 1,057,629 | 291,740 | 3,154,903 | 8,045,182 | ||||||||||||||
| GovGuam | 80,891 | 13,382 | 12,211 | 2,040,889 | 2,147,373 | ||||||||||||||
| Medicaid | 1,890,360 | 1,334,998 | 1,816,642 | 10,433,922 | 15,475,922 | ||||||||||||||
| Medically Indigent Program | 3,094,367 | 1,010,588 | 1,115,927 | 9,184,090 | 14,404,972 | ||||||||||||||
| Medicare | 2,527,343 | 225,246 | 73,673 | 2,415,618 | 5,241,880 | ||||||||||||||
| Self Pay | 3,523,507 | 1,306,386 | 1,803,679 | 38,354,987 | 44,988,559 | ||||||||||||||
| Total | 14,657,378 | 4,948,229 | 5,113,872 | 65,584,409 | 90,303,888 | ||||||||||||||
| 10 | |||||||||||||||||||
| 2006 | |||||||||||||||||||