| Budget Comparison (Cash Basis) | Billing, Collection & Denials | |||||||||||||||||||
| FY 2007 | FY 2007 | FY 2007 | 01/31/07 | |||||||||||||||||
| Approved | 4 Month Budget | 4 Month Actual | Gross Billings | Bad Debt | Collections | |||||||||||||||
| Medically Indigent Program | 1,432,180 | 6,784 | 1,923,286 | |||||||||||||||||
| Patient Revenues | 61,097,228 | 20,365,743 | $23,563,514 | Medicaid | 1,736,997 | 16,293 | 754,409 | |||||||||||||
| Cafeteria Sales/Other Revenues | 600,000 | 200,000 | 269,054 | Medicare | 1,830,763 | 27,146 | 559,414 | |||||||||||||
| FEMA Assistance | 43,107 | TakeCare | 1,010,763 | - | 540,673 | |||||||||||||||
| Advanced Appropriations | - | - | Staywell | 1,052,578 | 2,561 | 1,085,288 | ||||||||||||||
| Bioterrorism | 57,678 | Select Care | 968,185 | 535,110 | ||||||||||||||||
| Compact Impact Funds | 6,300,000 | 2,100,000 | 80,229 | NetCare | 325,688 | 238,297 | ||||||||||||||
| FMIP Reimbursement | 164,101 | Commercial | 353,620 | 73,381 | ||||||||||||||||
| GovGuam Subsidy-General Fund | 3,639,977 | 1,213,326 | Miscellaneous | |||||||||||||||||
| GRT | 10,062,795 | 3,354,265 | 2,696,213 | Nanbo | ||||||||||||||||
| Medicare Reimbursement FY03 MCR | 5,098,419 | FSM | ||||||||||||||||||
| Bad Debt | GOG | 64,400 | 67 | 4,040 | ||||||||||||||||
| Charitable Donations | Healthy Futures Fund | |||||||||||||||||||
| Total Collections | 81,700,000 | 27,233,334 | 31,972,315 | Health Securities Trust Fund | ||||||||||||||||
| Self-Pay | 89,830 | 169,228 | 503,428 | |||||||||||||||||
| DRT | 51,168,862 | 34,339 | ||||||||||||||||||
| Salaries | 39,709,411 | 13,236,470 | 11,281,045 | Attorney | 63,405 | |||||||||||||||
| Specialty Pay | 1,025,343 | 341,781 | 1,616,386 | Collection Agency of Guam | 3,031,967 | 17,832 | ||||||||||||||
| Benefits | 10,644,570 | 3,548,190 | 3,182,837 | Guam Marianas Collection Agency | 2,507,813 | 6,880 | ||||||||||||||
| Annual Lump Sum | 22,706 | Savant | 3,575,803 | 3,346 | ||||||||||||||||
| Other Pay | United Pacific Collection Agency | 401,918 | ||||||||||||||||||
| Overtime | 1,909,385 | 636,462 | 811,329 | Total | 8,865,003 | 60,971,845 | 6,279,723 | |||||||||||||
| Total Salaries & Benefits | 53,288,709 | 17,762,903 | 16,914,303 | |||||||||||||||||
| Travel & Training | 40,444 | 13,481 | 38,008 | Accounts Receivable (Net) | ||||||||||||||||
| Contractual Services | 11,200,657 | 3,733,552 | 2,495,578 | Medically Indigent Program | 5,540,150 | 22.87% | ||||||||||||||
| Supplies & Materials | 13,252,694 | 4,417,566 | 6,895,236 | GovGuam | 1,137,860 | 4.70% | ||||||||||||||
| Miscellaneous | 682,345 | 227,446 | 114,854 | Self Pay | 4,332,172 | 17.88% | ||||||||||||||
| Utilities | 2,324,865 | 774,955 | 689,871 | Medicare | 2,794,733 | 11.54% | ||||||||||||||
| Capital Outlay | 534,439 | 178,146 | 556,585 | Medicaid | 6,103,364 | 25.19% | ||||||||||||||
| Debt Service | - | 130,449 | Commercial | 4,318,210 | 17.82% | |||||||||||||||
| Minor Equipmant | 375,847 | 125,282 | ||||||||||||||||||
| Total Cash Disbursements | 81,700,000 | 27,108,049 | 27,834,884 | Total A/R (Net) | 24,226,489 | 100.00% | ||||||||||||||
| Surplus /(Deficit) | 4,137,431 | 0 | ||||||||||||||||||
| Accounts Payable Aging | ||||||||||||||||||||
| 01/31/07 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | ||||||||||||||||
| House Doctors | 2,803 | 16,787 | 87,397 | 235,895 | 342,882 | |||||||||||||||
| Trade Payables | 877,255 | 1,258,796 | 830,140 | 1,643,049 | 4,609,240 | |||||||||||||||
| Payroll Payables | 101,993 | 101,993 | ||||||||||||||||||
| - Gov Ret DBP | 159,710 | 148,213 | 307,923 | |||||||||||||||||
| - Gov Ret DCP | 213,828 | 213,828 | ||||||||||||||||||
| - Dept of Rev | 396,142 | 396,142 | ||||||||||||||||||
| GTA | 24,480 | 24,480 | ||||||||||||||||||
| GPA | 124,472 | 124,472 | ||||||||||||||||||
| GWA | 25,914 | 33,404 | 23,664 | 979 | 83,961 | |||||||||||||||
| Unbilled PO Receipts | 1,622,606 | 1,622,606 | ||||||||||||||||||
| Total | 3,424,731 | 1,433,459 | 941,202 | 2,028,136 | 7,827,528 | |||||||||||||||
| Accounts Receivable Aging | ||||||||||||||||||||
| 01/31/07 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | ||||||||||||||||
| Commercial | 4,081,214 | 1,948,714 | 655,898 | 3,595,626 | 10,281,451 | |||||||||||||||
| GovGuam | 491,902 | 118,935 | 60,470 | 1,914,739 | 2,586,046 | |||||||||||||||
| Medicaid | 1,750,031 | 1,333,261 | 1,519,370 | 10,655,747 | 15,258,409 | |||||||||||||||
| Medically Indigent Program | 2,390,615 | 1,202,101 | 924,940 | 9,332,719 | 13,850,375 | |||||||||||||||
| Medicare | 2,944,896 | 311,080 | 167,223 | 2,787,317 | 6,210,517 | |||||||||||||||
| Self Pay | 2,527,032 | 1,757,348 | 2,226,345 | 22,200,323 | 28,711,048 | |||||||||||||||
| Total | 14,185,689 | 6,671,440 | 5,554,246 | 50,486,471 | 76,897,846 | |||||||||||||||
| - | ||||||||||||||||||||
| 4 | ||||||||||||||||||||
| 2007 | ||||||||||||||||||||