| Budget Comparison (Cash Basis) | Billing, Collection & Denials | ||||||||||||||||
| FY 2006 | FY 2006 | FY 2006 | 01/31/06 | ||||||||||||||
| Approved | 4 Month Budget | 4 Month Actual | Gross Billings | Bad Debt | Collections | ||||||||||||
| Patient Revenues | 53,258,165 | 17,752,722 | 17,563,884 | Medically Indigent Program | 1,159,757 | 3,003 | 1,475,088 | ||||||||||
| Cafeteria Sales | 600,000 | 200,000 | 247,331 | Medicaid | 1,772,757 | 14,966 | 230,365 | ||||||||||
| HRSA Grant | Medicare | 1,691,037 | 16,994 | 202,684 | |||||||||||||
| Healthy Futures | 4,000,000 | 1,333,333 | Pacificare | 666,569 | 1,119 | 489,646 | |||||||||||
| Healthy Futures - Pt Education | Staywell | 1,341,383 | 966 | 633,023 | |||||||||||||
| Compact Impact Funds | 3,200,000 | 1,066,667 | 879,078 | Calvo's | 196,957 | 102,014 | |||||||||||
| Misc Revenues | Net care | 913,822 | 181,139 | ||||||||||||||
| FEMA | Commercial | 99,829 | 536 | ||||||||||||||
| GovGuam Subsidy | 17,958,964 | 5,986,321 | Miscellaneous | 108,920 | 75,258 | ||||||||||||
| Insurance Settlement | Nanbo | ||||||||||||||||
| Charitable Donations | FSM | ||||||||||||||||
| GTA Sale Proceeds | GOG | 20,762 | 47 | 506 | |||||||||||||
| GRT | 1,906,053 | Healthy Futures Fund | |||||||||||||||
| Health Securities Trust Fund | 183,130 | Health Securities Trust Fund | |||||||||||||||
| Total Collections | 79,017,129 | 26,339,043 | 20,779,476 | Self-Pay | 1,870,175 | 282,081 | 351,988 | ||||||||||
| DRT | 21,666,391 | ||||||||||||||||
| Salaries | 34,884,362 | 11,628,121 | 10,550,122 | Collection Agencies | |||||||||||||
| Specialty Pay | 830,670 | 276,890 | 1,475,984 | CAOG | 3,093,791 | 73,135 | |||||||||||
| Benefits | 9,549,665 | 3,183,222 | 2,769,698 | GMMS | 2,602,074 | 13,570 | |||||||||||
| Annual Lump Sum | 12,263 | SAVANT | 3,645,369 | 7,121 | |||||||||||||
| Other Pay | UPCA | 385,221 | |||||||||||||||
| Overtime | 2,011,306 | 670,435 | 738,413 | Total | 9,841,968 | 31,712,558 | 3,835,537 | ||||||||||
| Total Salaries & Benefits | 47,276,003 | 15,758,668 | 15,546,480 | - | |||||||||||||
| Travel & Training | 100,230 | 33,410 | 21,190 | Accounts Receivable (Net) | |||||||||||||
| Contractual Services | 9,096,233 | 3,032,078 | 1,996,361 | Medically Indigent Program | 6,182,035 | ||||||||||||
| Supplies & Materials | 10,336,019 | 3,445,340 | 3,349,013 | GovGuam | 1,765,078 | ||||||||||||
| Minor Equipment | 192,423 | 64,141 | 67,599 | Self Pay | 4,307,105 | ||||||||||||
| Miscellaneous | 284,678 | 94,893 | 47,336 | Medicare | 2,362,716 | ||||||||||||
| Utilities | 1,987,615 | 662,538 | 296,469 | Medicaid | 5,957,078 | ||||||||||||
| Capital Outlay | 2,896,928 | 965,643 | 212,540 | Commercial | 7,423,848 | ||||||||||||
| Debt Service | 6,847,000 | 2,282,332 | Total A/R (Net) | 27,997,860 | |||||||||||||
| Total Cash Disbursements | 79,017,129 | 26,339,043 | 21,536,988 | - | |||||||||||||
| Surplus /(Deficit) | - | - | (757,512) | ||||||||||||||
| Accounts Payable Aging | |||||||||||||||||
| 01/31/06 | |||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||
| House Doctors | 93,729 | 3,657 | 6,702 | 197,711 | 301,799 | ||||||||||||
| Trade Payables | 787,533 | 1,014,435 | 742,822 | 1,516,504 | 4,061,294 | ||||||||||||
| Payroll Payables | 333,649 | 333,649 | |||||||||||||||
| - Gov Ret DBP | 152,901 | (513,347) | 984,160 | 623,714 | |||||||||||||
| - Gov Ret DCP | 187,212 | 187,212 | |||||||||||||||
| - Dept of Rev | 350,274 | 350,274 | |||||||||||||||
| GTA | 22,649 | 22,649 | |||||||||||||||
| GPA | 116,804 | 549,274 | 666,078 | ||||||||||||||
| GWA | 16,557 | 1,136 | 15,007 | 430 | 33,130 | ||||||||||||
| Unbilled P O Receipts | 1,104,449 | 1,104,449 | |||||||||||||||
| Total | 3,048,953 | 622,685 | 764,531 | 3,248,079 | 7,684,248 | ||||||||||||
| - | |||||||||||||||||
| Accounts Receivable Aging | |||||||||||||||||
| 01/31/06 | |||||||||||||||||
| 0 - 30 | 31 - 60 | 61 - 90 | Over 90 | Total | |||||||||||||
| Commercial | 5,109,478 | 2,119,465 | 1,077,344 | 8,191,154 | 16,497,441 | ||||||||||||
| GovGuam | 42,355 | 6,867 | 10,531 | 2,016,809 | 2,076,562 | ||||||||||||
| Medicaid | 1,519,815 | 1,307,114 | 1,632,383 | 8,778,640 | 13,237,952 | ||||||||||||
| Medically Indigent Program | 3,024,679 | 983,875 | 1,154,141 | 10,292,392 | 15,455,087 | ||||||||||||
| Medicare | 2,800,245 | 66,969 | 148,700 | 2,234,566 | 5,250,480 | ||||||||||||
| Self Pay | 3,131,397 | 1,409,519 | 1,352,536 | 28,221,461 | 34,114,913 | ||||||||||||
| Total | 15,627,969 | 5,893,809 | 5,375,635 | 59,735,022 | 86,632,435 | ||||||||||||