| Budget Comparison (Cash Basis) | Billing, Collection & Denials | |||||||||||||||||||
| FY 2007 | FY 2007 | FY 2007 | 02/28/07 | |||||||||||||||||
| Approved | 5 Month Budget | 5 Month Actual | Gross Billings | Bad Debt | Collections | |||||||||||||||
| Medically Indigent Program | 1,376,995 | 8,507 | ||||||||||||||||||
| Patient Revenues | 61,097,228 | 25,457,178 | $28,453,234 | Medicaid | 1,397,943 | 26,905 | 1,542,024 | |||||||||||||
| Cafeteria Sales/Other Revenues | 600,000 | 250,000 | 319,492 | Medicare | 2,227,654 | 32,103 | 119,349 | |||||||||||||
| FEMA Assistance | 43,107 | TakeCare | 785,703 | 420 | 408,510 | |||||||||||||||
| Advanced Appropriations | - | - | Staywell | 1,267,757 | 2,561 | 613,212 | ||||||||||||||
| Bioterrorism | 197,927 | Select Care | 595,412 | 859,302 | ||||||||||||||||
| Compact Impact Funds | 6,300,000 | 2,625,000 | 291,348 | NetCare | 159,731 | 94,632 | ||||||||||||||
| FMIP Reimbursement | 164,101 | Commercial | 267,220 | 401 | 180,204 | |||||||||||||||
| GovGuam Subsidy-General Fund | 3,639,977 | 1,516,657 | Miscellaneous | 30,902 | ||||||||||||||||
| GRT | 10,062,795 | 4,192,831 | 3,572,846 | Nanbo | ||||||||||||||||
| Medicare Reimbursement FY03 MCR | 4,522,765 | FSM | ||||||||||||||||||
| Bad Debt | GOG | 38,705 | 67 | 11,652 | ||||||||||||||||
| Charitable Donations | Healthy Futures Fund | |||||||||||||||||||
| Total Collections | 81,700,000 | 34,041,666 | 37,564,820 | Health Securities Trust Fund | ||||||||||||||||
| Self-Pay | 1,831,556 | 174,983 | 394,580 | |||||||||||||||||
| DRT | 51,124,120 | 51,504 | ||||||||||||||||||
| Salaries | 39,709,411 | 16,545,588 | 14,226,447 | Attorney | 64,400 | |||||||||||||||
| Specialty Pay | 1,025,343 | 427,226 | 1,922,069 | Collection Agency of Guam | 3,033,608 | 28,402 | ||||||||||||||
| Benefits | 10,644,570 | 4,435,238 | 3,990,378 | Guam Marianas Collection Agency | 2,503,267 | 7,632 | ||||||||||||||
| Annual Lump Sum | 53,248 | Savant | 3,571,807 | 2,797 | ||||||||||||||||
| Other Pay | United Pacific Collection Agency | 401,918 | ||||||||||||||||||
| Overtime | 1,909,385 | 795,577 | 1,075,207 | Total | 9,979,578 | 60,945,068 | 4,313,800 | |||||||||||||
| Total Salaries & Benefits | 53,288,709 | 22,203,629 | 21,267,349 | |||||||||||||||||
| Travel & Training | 40,444 | 16,852 | 44,887 | |||||||||||||||||
| Contractual Services | 11,200,657 | 4,666,940 | 2,654,541 | |||||||||||||||||
| Supplies & Materials | 13,252,694 | 5,521,957 | 8,264,702 | |||||||||||||||||
| Miscellaneous | 682,345 | 284,308 | 139,887 | |||||||||||||||||
| Utilities | 2,324,865 | 968,694 | 838,922 | |||||||||||||||||
| Capital Outlay | 534,439 | 222,683 | 556,585 | |||||||||||||||||
| Debt Service | - | 173,932 | ||||||||||||||||||
| Minor Equipment | 375,847 | 156,603 | ||||||||||||||||||
| Total Cash Disbursements | 81,700,000 | 34,041,666 | 33,940,805 | |||||||||||||||||
| Surplus /(Deficit) | 3,624,015 | |||||||||||||||||||
| Accounts Receivable Aging | ||||||||||||||||||||
| 02/28/07 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | ||||||||||||||||
| Commercial | 4,018,119 | 2,584,818 | 691,633 | 3,606,229 | 10,900,799 | |||||||||||||||
| GovGuam | 475,585 | 88,550 | 38,887 | 1,939,590 | 2,542,611 | |||||||||||||||
| Medicaid | 1,811,792 | 1,147,451 | 1,361,327 | 9,391,295 | 13,711,865 | |||||||||||||||
| Medically Indigent Program | 2,622,425 | 783,295 | 1,261,267 | 9,306,374 | 13,973,360 | |||||||||||||||
| Medicare | 2,778,365 | 381,712 | 132,190 | 2,841,886 | 6,134,153 | |||||||||||||||
| Self Pay | 2,646,261 | 1,553,488 | 1,910,876 | 24,214,268 | 30,324,893 | |||||||||||||||
| Total | 14,352,547 | 6,539,312 | 5,396,180 | 51,299,642 | 77,587,681 | |||||||||||||||
| 5 | ||||||||||||||||||||
| 2007 | ||||||||||||||||||||
| 02/28/07 | ||||||||||||||||||||