| Budget Comparison (Cash Basis) | Billing, Collection & Denials | |||||||||||||||||||
| FY 2007 | FY 2007 | FY 2007 | 12/31/06 | |||||||||||||||||
| Approved | 3 Month Budget | 3 Month Actual | Gross Billings | Bad Debt | Collections | |||||||||||||||
| Medically Indigent Program | 775,016 | 3,502 | 754,999 | |||||||||||||||||
| Patient Revenues | 61,097,228 | 15,274,307 | $17,234,996 | Medicaid | 1,126,531 | 14,908 | 1,495,001 | |||||||||||||
| Cafeteria Sales/Other Revenues | 600,000 | 150,000 | 214,234 | Medicare | 2,040,020 | 24,167 | 874,701 | |||||||||||||
| FEMA Assistance | 43,107 | TakeCare | 862,953 | - | 477,350 | |||||||||||||||
| Advanced Appropriations | - | - | Staywell | 1,109,807 | 2,207 | 513,695 | ||||||||||||||
| Bioterrorism | 57,678 | Select Care | 701,506 | 293,565 | ||||||||||||||||
| Compact Impact Funds | 6,300,000 | 1,575,000 | 61,194 | NetCare | 194,015 | 425,325 | ||||||||||||||
| FMIP Reimbursement | 164,101 | Commercial | 196,531 | 105,858 | ||||||||||||||||
| GovGuam Subsidy-General Fund | 3,639,977 | 909,994 | Miscellaneous | |||||||||||||||||
| GRT | 10,062,795 | 2,515,699 | 1,733,964 | Nanbo | ||||||||||||||||
| Medicare Reimbursement FY03 MCR | 5,093,962 | FSM | ||||||||||||||||||
| Bad Debt | GOG | 108,878 | 47 | 558 | ||||||||||||||||
| Charitable Donations | Healthy Futures Fund | |||||||||||||||||||
| Total Collections | 81,700,000 | 20,425,000 | 24,603,236 | Health Securities Trust Fund | ||||||||||||||||
| Self-Pay | 1,865,008 | 158,939 | 558,812 | |||||||||||||||||
| DRT | 51,258,737 | 32,524 | ||||||||||||||||||
| Salaries | 39,709,411 | 9,927,353 | 8,465,549 | Attorney | 63,185 | |||||||||||||||
| Specialty Pay | 1,025,343 | 256,336 | 1,188,064 | Collection Agency of Guam | 3,026,842 | 19,606 | ||||||||||||||
| Benefits | 10,644,570 | 2,661,143 | 2,397,577 | Guam Marianas Collection Agency | 2,508,222 | 8,288 | ||||||||||||||
| Annual Lump Sum | 22,706 | Savant | 3,581,133 | 4,365 | ||||||||||||||||
| Other Pay | United Pacific Collection Agency | 401,918 | ||||||||||||||||||
| Overtime | 1,909,385 | 477,346 | 619,571 | Total | 8,980,265 | 61,043,806 | 5,564,647 | |||||||||||||
| Total Salaries & Benefits | 53,288,709 | 13,322,177 | 12,693,467 | |||||||||||||||||
| Travel & Training | 40,444 | 10,111 | 31,353 | Accounts Receivable (Net) | ||||||||||||||||
| Contractual Services | 11,200,657 | 2,800,164 | 1,940,516 | Medically Indigent Program | 6,138,917 | 25.26% | ||||||||||||||
| Supplies & Materials | 13,252,694 | 3,313,175 | 5,213,907 | GovGuam | 1,258,240 | 5.18% | ||||||||||||||
| Miscellaneous | 682,345 | 170,584 | 90,443 | Self Pay | 4,010,098 | 16.50% | ||||||||||||||
| Utilities | 2,324,865 | 581,216 | 513,057 | Medicare | 2,621,456 | 10.78% | ||||||||||||||
| Capital Outlay | 534,439 | 133,610 | 556,585 | Medicaid | 6,079,953 | 25.01% | ||||||||||||||
| Debt Service | - | 86,966 | Commercial | 4,198,730 | 17.27% | |||||||||||||||
| Minor Equipmant | 375,847 | 93,962 | ||||||||||||||||||
| Total Cash Disbursements | 81,700,000 | 20,331,037 | 21,126,294 | Total A/R (Net) | 24,307,394 | 100.00% | ||||||||||||||
| Surplus /(Deficit) | 3,476,942 | 0 | ||||||||||||||||||
| Accounts Payable Aging | ||||||||||||||||||||
| 12/31/06 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | ||||||||||||||||
| House Doctors | 172,067 | 12,479 | 28,097 | 201,639 | 414,282 | |||||||||||||||
| Trade Payables | 829,778 | 1,314,417 | 1,377,481 | 1,424,973 | 4,946,649 | |||||||||||||||
| Payroll Payables | 171,574 | 171,574 | ||||||||||||||||||
| - Gov Ret DBP | 166,458 | 148,213 | 314,671 | |||||||||||||||||
| - Gov Ret DCP | - | |||||||||||||||||||
| - Dept of Rev | 387,453 | 222,492 | 384,300 | 994,245 | ||||||||||||||||
| GTA | - | |||||||||||||||||||
| GPA | 122,586 | 122,586 | ||||||||||||||||||
| GWA | 33,404 | 23,664 | 99 | 57,167 | ||||||||||||||||
| Unbilled PO Receipts | 1,231,494 | 1,231,494 | ||||||||||||||||||
| Total | 2,992,229 | 1,695,639 | 1,789,977 | 1,774,825 | 8,252,670 | |||||||||||||||
| Accounts Receivable Aging | ||||||||||||||||||||
| 12/31/06 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | ||||||||||||||||
| Commercial | 3,591,977 | 2,315,884 | 666,514 | 3,422,603 | 9,996,978 | |||||||||||||||
| GovGuam | 521,876 | 75,116 | 51,122 | 2,147,975 | 2,796,088 | |||||||||||||||
| Medicaid | 1,823,050 | 1,358,501 | 1,483,574 | 10,534,758 | 15,199,883 | |||||||||||||||
| Medically Indigent Program | 2,985,692 | 998,584 | 1,434,116 | 9,928,899 | 15,347,292 | |||||||||||||||
| Medicare | 2,394,512 | 457,873 | 230,406 | 2,742,665 | 5,825,457 | |||||||||||||||
| Self Pay | 2,511,268 | 1,967,455 | 1,983,718 | 20,143,405 | 26,605,846 | |||||||||||||||
| Total | 13,828,375 | 7,173,414 | 5,849,451 | 48,920,305 | 75,771,545 | |||||||||||||||
| - | ||||||||||||||||||||
| 3 | ||||||||||||||||||||
| 2006 | ||||||||||||||||||||