| Budget Comparison (Cash Basis) | Billing, Collection & Denials | |||||||||||||||||||
| FY 2007 | FY 2007 | FY 2007 | 03/31/07 | |||||||||||||||||
| Approved | 6 Month Budget | 6 Month Actual | Gross Billings | Bad Debt | Collections | |||||||||||||||
| Medically Indigent Program | 1,245,096 | 7,071 | 1,417,163 | |||||||||||||||||
| Patient Revenues | 61,097,228 | 30,548,614 | $34,858,802 | Medicaid | 1,719,125 | 23,898 | 1,117,842 | |||||||||||||
| Cafeteria Sales/Other Revenues | 600,000 | 300,000 | 382,306 | Medicare | 2,038,181 | 27,239 | 715,240 | |||||||||||||
| FEMA Assistance | 43,107 | TakeCare | 641,715 | 170 | 719,715 | |||||||||||||||
| Advanced Appropriations | - | - | Staywell | 1,195,879 | 2,561 | 1,023,506 | ||||||||||||||
| Bioterrorism | 355,133 | Select Care | 1,059,762 | 398,721 | ||||||||||||||||
| Compact Impact Funds | 6,300,000 | 3,150,000 | 291,348 | NetCare | 259,550 | 147,519 | ||||||||||||||
| FMIP Reimbursement | 164,101 | Commercial | 379,398 | 401 | 129,791 | |||||||||||||||
| GovGuam Subsidy-General Fund | 3,639,977 | 1,819,989 | Miscellaneous | |||||||||||||||||
| GRT | 10,062,795 | 5,031,398 | 4,279,921 | Nanbo | ||||||||||||||||
| Medicare Reimbursement FY03 MCR | 4,522,765 | FSM | ||||||||||||||||||
| Bad Debt | GOG | 134,594 | 67 | 20,898 | ||||||||||||||||
| Charitable Donations | Healthy Futures Fund | |||||||||||||||||||
| Total Collections | 81,700,000 | 40,850,001 | 44,897,483 | Health Securities Trust Fund | ||||||||||||||||
| Self-Pay | 2,012,476 | 193,422 | 456,263 | |||||||||||||||||
| DRT | 50,841,801 | 236,296 | ||||||||||||||||||
| Salaries | 39,709,411 | 19,854,706 | 17,199,541 | Attorney | 64,368 | |||||||||||||||
| Specialty Pay | 1,025,343 | 512,672 | 2,221,803 | Collection Agency of Guam | 3,011,897 | 20,633 | ||||||||||||||
| Benefits | 10,644,570 | 5,322,285 | 4,777,134 | Guam Marianas Collection Agency | 2,500,583 | 7,965 | ||||||||||||||
| Annual Lump Sum | 53,248 | Savant | 3,566,745 | |||||||||||||||||
| Other Pay | United Pacific Collection Agency | 401,918 | ||||||||||||||||||
| Overtime | 1,909,385 | 954,693 | 1,295,252 | Total | 10,685,776 | 60,642,140 | 6,411,551 | |||||||||||||
| Total Salaries & Benefits | 53,288,709 | 26,644,355 | 25,546,978 | |||||||||||||||||
| Travel & Training | 40,444 | 20,222 | 56,246 | |||||||||||||||||
| Contractual Services | 11,200,657 | 5,600,329 | 2,990,405 | |||||||||||||||||
| Supplies & Materials | 13,252,694 | 6,626,348 | 8,948,308 | |||||||||||||||||
| Miscellaneous | 682,345 | 341,171 | 178,936 | |||||||||||||||||
| Utilities | 2,324,865 | 1,162,433 | 1,087,836 | |||||||||||||||||
| Capital Outlay | 534,439 | 267,220 | 956,312 | |||||||||||||||||
| Debt Service | - | 217,415 | ||||||||||||||||||
| Minor Equipment | 375,847 | 187,924 | ||||||||||||||||||
| Total Cash Disbursements | 81,700,000 | 40,850,002 | 39,982,436 | |||||||||||||||||
| Surplus /(Deficit) | 4,915,047 | |||||||||||||||||||
| Accounts Receivable Aging | ||||||||||||||||||||
| 03/31/07 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | ||||||||||||||||
| Commercial | 3,652,988 | 2,559,975 | 1,045,864 | 4,020,952 | 11,279,778 | |||||||||||||||
| GovGuam | 377,638 | 81,250 | 65,210 | 1,940,507 | 2,464,605 | |||||||||||||||
| Medicaid | 1,974,859 | 1,228,265 | 1,237,587 | 10,229,569 | 14,670,280 | |||||||||||||||
| Medically Indigent Program | 2,604,614 | 1,084,657 | 610,120 | 9,612,862 | 13,912,252 | |||||||||||||||
| Medicare | 2,494,237 | 415,283 | 275,875 | 2,900,855 | 6,086,251 | |||||||||||||||
| Self Pay | 2,578,119 | 1,584,568 | 1,584,069 | 25,899,051 | 31,645,807 | |||||||||||||||
| Total | 13,682,455 | 6,953,998 | 4,818,725 | 54,603,796 | 80,058,974 | |||||||||||||||
| 6 | ||||||||||||||||||||
| 2007 | ||||||||||||||||||||
| 03/31/07 | ||||||||||||||||||||