| Budget Comparison (Cash Basis) | Billing, Collection & Denials | |||||||||||||||||||
| FY 2007 | FY 2007 | FY 2007 | 11/30/06 | |||||||||||||||||
| Approved | 2 Month Budget | 2 Month Actual | Gross Billings | Bad Debt | Collections | |||||||||||||||
| Medically Indigent Program | 1,453,868 | 3,502 | 456,606 | |||||||||||||||||
| Patient Revenues | 61,097,228 | 10,182,871 | $11,670,349 | Medicaid | 1,636,396 | 13,924 | 832,638 | |||||||||||||
| Cafeteria Sales/Other Revenues | 600,000 | 100,000 | 165,724 | Medicare | 2,085,437 | 24,735 | 868,418 | |||||||||||||
| ANA Grant | - | TakeCare | 590,448 | 876 | 464,506 | |||||||||||||||
| Advanced Appropriations | - | - | Staywell | 912,318 | 966 | 633,048 | ||||||||||||||
| Bioterrorism | - | Select Care | 701,840 | 254,336 | ||||||||||||||||
| Compact Impact Funds | 6,300,000 | 1,050,000 | NetCare | 323,621 | 130,607 | |||||||||||||||
| FMIP Reimbursement | 164,101 | Commercial | 236,312 | 78,927 | ||||||||||||||||
| GovGuam Subsidy-General Fund | 3,639,977 | 606,663 | Miscellaneous | |||||||||||||||||
| GRT | 10,062,795 | 1,677,133 | 1,107,171 | Nanbo | ||||||||||||||||
| Medicare Reimbursement FY03 MCR | 4,921,530 | FSM | ||||||||||||||||||
| Bad Debt | GOG | 18,657 | (621) | 76,248 | ||||||||||||||||
| Charitable Donations | Healthy Futures Fund | |||||||||||||||||||
| Total Collections | 81,700,000 | 13,616,667 | 18,028,875 | Health Securities Trust Fund | ||||||||||||||||
| Self-Pay | 2,258,157 | 121,641 | 426,082 | |||||||||||||||||
| DRT | 51,317,195 | - | ||||||||||||||||||
| Salaries | 39,709,411 | 6,618,235 | 5,498,305 | Attorney | 63,310 | |||||||||||||||
| Specialty Pay | 1,025,343 | 170,891 | 818,477 | Collection Agency of Guam | 2,992,371 | 37,081 | ||||||||||||||
| Benefits | 10,644,570 | 1,774,095 | 1,618,142 | Guam Marianas Collection Agency | 2,516,546 | 13,457 | ||||||||||||||
| Annual Lump Sum | 16,308 | Savant | 3,585,243 | 6,051 | ||||||||||||||||
| Other Pay | United Pacific Collection Agency | 401,948 | ||||||||||||||||||
| Overtime | 1,909,385 | 318,231 | 423,409 | Total | 10,217,054 | 61,041,634 | 4,278,007 | |||||||||||||
| Total Salaries & Benefits | 53,288,709 | 8,881,452 | 8,374,641 | |||||||||||||||||
| Travel & Training | 40,444 | 6,741 | 31,353 | Accounts Receivable (Net) | ||||||||||||||||
| Contractual Services | 11,200,657 | 1,866,776 | 1,620,735 | Medically Indigent Program | 5,248,312 | 21.09% | ||||||||||||||
| Supplies & Materials | 13,252,694 | 2,208,783 | 3,928,453 | GovGuam | 960,430 | 3.86% | ||||||||||||||
| Miscellaneous | 682,345 | 113,722 | 85,471 | Self Pay | 7,967,152 | 32.01% | ||||||||||||||
| Utilities | 2,324,865 | 387,478 | 466,941 | Medicare | 2,209,763 | 8.88% | ||||||||||||||
| Capital Outlay | 534,439 | 89,073 | 556,585 | Medicaid | 5,207,350 | 20.92% | ||||||||||||||
| Debt Service | - | 86,966 | Commercial | 3,295,372 | 13.24% | |||||||||||||||
| Minor Equipmant | 375,847 | |||||||||||||||||||
| Total Cash Disbursements | 81,700,000 | 13,554,025 | 15,151,145 | Total A/R (Net) | 24,888,379 | 100.00% | ||||||||||||||
| Surplus /(Deficit) | 2,877,730 | (0) | ||||||||||||||||||
| Accounts Payable Aging | ||||||||||||||||||||
| 11/30/06 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | ||||||||||||||||
| House Doctors | 9,194 | 1,841 | 6,625 | 73,636 | 91,296 | |||||||||||||||
| Trade Payables | 616,749 | 1,306,256 | 1,087,937 | 1,397,138 | 4,408,079 | |||||||||||||||
| Payroll Payables | 66,768 | 66,768 | ||||||||||||||||||
| - Gov Ret DBP | 161,140 | 161,140 | ||||||||||||||||||
| - Gov Ret DCP | 209,164 | 209,164 | ||||||||||||||||||
| - Dept of Rev | 222,492 | 384,300 | 606,792 | |||||||||||||||||
| GTA | - | |||||||||||||||||||
| GPA | 127,300 | 127,300 | ||||||||||||||||||
| GWA | 2,364 | 880 | 99 | 3,343 | ||||||||||||||||
| Unbilled PO Receipts | 1,070,075 | 1,070,075 | ||||||||||||||||||
| Total | 2,357,948 | 1,820,576 | 1,094,661 | 1,470,773 | 6,743,958 | |||||||||||||||
| Accounts Receivable Aging | ||||||||||||||||||||
| 11/30/06 | ||||||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | ||||||||||||||||
| Commercial | 3,650,921 | 1,894,578 | 680,791 | 3,189,059 | 9,415,349 | |||||||||||||||
| GovGuam | 509,938 | 58,508 | 18,698 | 2,156,941 | 2,744,084 | |||||||||||||||
| Medicaid | 1,957,715 | 1,393,823 | 1,404,725 | 10,121,880 | 14,878,143 | |||||||||||||||
| Medically Indigent Program | 3,107,835 | 1,395,633 | 1,236,632 | 9,255,077 | 14,995,178 | |||||||||||||||
| Medicare | 2,820,924 | 480,435 | 413,687 | 2,598,561 | 6,313,607 | |||||||||||||||
| Self Pay | 2,639,280 | 1,921,606 | 1,677,753 | 18,568,744 | 24,807,384 | |||||||||||||||
| Total | 14,686,614 | 7,144,584 | 5,432,285 | 45,890,262 | 73,153,746 | |||||||||||||||
| 2 | ||||||||||||||||||||
| 2006 | ||||||||||||||||||||